Trending questions in Others

0 votes
1 answer

How to split column into two

Using WRAPSROWS() • Formula used in cell C2 --> Exclusively Applicable To ...READ MORE

Feb 21, 2023 in Others by narikkadan
 • 63,600 points • 449 views
0 votes
1 answer

Color specific cell in an xlsx with python

Column B's cells must be iterated through ...READ MORE

Jan 14, 2023 in Others by narikkadan
 • 63,600 points • 2,086 views
0 votes
1 answer

Converting excel to pdf using PHP

If utilizing PHP on a Windows PC, ...READ MORE

Oct 23, 2022 in Others by narikkadan
 • 63,600 points • 5,660 views
0 votes
1 answer

Python erroring

Amend the spreadsheet file path from: 'C:\Technical\AutomationScri ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 63,600 points • 904 views
0 votes
1 answer

Automatically fill cell with a set value on specific calendar day and time

 Use this formula: =IF(NOW()>DATE(2023,3,1)+TIME(8,0, ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 63,600 points • 557 views
0 votes
1 answer

How to solve "Error: Apache shutdown unexpectedly"?

To answer your question, as this port ...READ MORE

Feb 10, 2022 in Others by Rahul
 • 9,680 points • 16,638 views
0 votes
1 answer

How to hide blank rows in an excel form if they are blank

If an empty row should be defined ...READ MORE

Feb 13, 2023 in Others by narikkadan
 • 63,600 points • 755 views
0 votes
1 answer

Extract Text after Second Underscore in Excel from right side

The UDF to use. The default separator is ...READ MORE

Feb 3, 2023 in Others by narikkadan
 • 63,600 points • 1,178 views
0 votes
1 answer

How to set a column as a range variable as long as there is data in it?

Try this: Dim rng As Range Set rng = ...READ MORE

Feb 16, 2023 in Others by narikkadan
 • 63,600 points • 616 views
0 votes
1 answer

Multiplication of all numbers in a cell by a specific number

With ms365, try: The formula in B1: =MAP(A1:A3,LAMBDA(x,TE ...READ MORE

Feb 21, 2023 in Others by narikkadan
 • 63,600 points • 398 views
+1 vote
1 answer

ng is not recognized as an internal or external command

I solved this problem in accordance with ...READ MORE

Feb 11, 2022 in Others by Rahul
 • 9,680 points • 16,532 views
0 votes
1 answer

Differences between git pull origin master & git pull origin/master

To answer your question, the git pull ...READ MORE

Feb 11, 2022 in Others by Rahul
 • 9,680 points • 16,572 views
0 votes
1 answer

Put text body above the pasted range

Set x before you paste. x = doc.Range.End ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
 • 38,000 points • 423 views
0 votes
1 answer

How can I stop my vba code from giving me an error 424?

Object Variables in Loops The main issue was ...READ MORE

Feb 9, 2023 in Others by narikkadan
 • 63,600 points • 898 views
0 votes
1 answer

Sublist on Excel

Try using this formula in sheet 1  =FILTER(Sheet2!B3:B8,Sheet2!E3:E8<2) The ...READ MORE

Feb 21, 2023 in Others by narikkadan
 • 63,600 points • 379 views
0 votes
1 answer

Excel Pivot Table : Calculated Field ( formula to be used like sumproduct)

With a calculated field, you might not ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 63,600 points • 2,489 views
0 votes
1 answer

Power Query - Find matching contents from multiple other tables

Try entering this code in Powerquery's input ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
 • 38,000 points • 541 views
0 votes
1 answer

Excel: Get text between two characters

Try this: =SUBSTITUTE(TEXTAFTER(A1:A4,"/",-1),"'","") Here is the output:  Similarly to get ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
 • 38,000 points • 650 views
0 votes
1 answer

Dropdown list circular reference Excel/VBA

Try this: Private Sub Workbook_SheetChange(ByVal Sh As Object, ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 63,600 points • 473 views
0 votes
1 answer

VBA Excel: Write timestamp to cell on change of another cell

Your request is a little vague, and ...READ MORE

Feb 5, 2023 in Others by narikkadan
 • 63,600 points • 1,024 views
0 votes
1 answer

Delete all rows in filtered range Except first filtered row in excel VBA

Use a flag to omit first row Sub ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 63,600 points • 2,234 views
0 votes
1 answer

Why the data type in last columns is str instead of float?

Have you attempted to float-ify that column ...READ MORE

Feb 13, 2023 in Others by narikkadan
 • 63,600 points • 679 views
0 votes
1 answer

Copying and pasting from one workbook to another doesn't work

Your ranges aren't fully qualified. Excel will make ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 63,600 points • 458 views
0 votes
1 answer

Type mismatch error when referring to array element by location vba

We utilise MID to parse the string. ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,000 points • 756 views
0 votes
1 answer

Excel VBA Scheduled message pop up box reminder

What exactly does W11 contain? In Excel, ...READ MORE

Feb 3, 2023 in Others by narikkadan
 • 63,600 points • 1,098 views
0 votes
1 answer

Allow alpha numeric values instead of isnumeric

Here's a small Function you could add to your ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 63,600 points • 453 views
0 votes
1 answer

Struggling to move object based on the value to respect sheet

If you are not moving many rows ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
 • 38,000 points • 615 views
0 votes
1 answer

Appreciate any suggestion

You could try and add a feature ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
 • 38,000 points • 605 views
0 votes
1 answer

Lock and unlock cells in Excel based on color in all worksheets

The following should function if you actually ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,000 points • 723 views
0 votes
1 answer

Concatenate only upper case letters?

In ms365, try: The formula in B1‡: =CONCAT(TEXTSPLIT(A1,TEXTSPLIT(A1,CHAR(ROW(65:90)),,1))) ‡ If not a ...READ MORE

Feb 16, 2023 in Others by narikkadan
 • 63,600 points • 504 views
0 votes
1 answer

Export from r in excel

Try this: library(xlsx) write.xlsx(x, file, sheetName="Sheet1") READ MORE

Feb 13, 2023 in Others by narikkadan
 • 63,600 points • 625 views
0 votes
1 answer

VBA How do I replace the range with an array in SUMIF

You can't, in my opinion. When you ...READ MORE

Feb 7, 2023 in Others by narikkadan
 • 63,600 points • 879 views
0 votes
1 answer

Highlight closest cell value in a table

Conditional formatting will be used to highlight ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 63,600 points • 405 views
0 votes
1 answer

Create a hyperlink to a sheet with same name as the value in the selected cell in Excel through VBA

Credit to Spectral Instance who found the ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 63,600 points • 911 views
0 votes
1 answer

Do Until replay tree times

Clean Data: Apply Consistent Formatting in Columns Option ...READ MORE

Feb 13, 2023 in Others by narikkadan
 • 63,600 points • 595 views
0 votes
1 answer

Excel Formula Extract any number greater than x charters from a string

Given that you employ two separate delimiters, ...READ MORE

Feb 16, 2023 in Others by narikkadan
 • 63,600 points • 445 views
0 votes
1 answer

Excel VBA - Out of memory when create a dynamic array formula

Try this: Sub MyArray() Range("A1").Formula2 = "=R[2]C[2]:R[2]C[6]" End Sub But that ...READ MORE

Feb 9, 2023 in Others by narikkadan
 • 63,600 points • 738 views
0 votes
1 answer

How can I automatically formulate a column while adding values ​to another? EXCEL

Use a # in your range references ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
 • 38,000 points • 402 views
0 votes
1 answer

Send message using excel to whatsapp web reloading

Inputs Range("W_C") = A list of Contacts' telephone ...READ MORE

Sep 21, 2022 in Others by narikkadan
 • 63,600 points • 6,827 views
0 votes
1 answer

Index and Match multiple matches

You can try the following (formula 1) ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 63,600 points • 679 views
0 votes
1 answer

I need help connecting my python file to excel to execute the output of my program to excel

you can replace concat with append and its will work but ...READ MORE

Feb 4, 2023 in Others by narikkadan
 • 63,600 points • 935 views
0 votes
1 answer

Excel: How to set a dropdown list cell to fetch list of strings from an API JSON response

The values you wish to display in ...READ MORE

Jan 30, 2023 in Others by narikkadan
 • 63,600 points • 1,147 views
0 votes
1 answer

How to divide data in excel into 4 columns whose sum is almost equal to 1/4 of the sum of all values/

5049 is the sum of all numbers, ...READ MORE

Feb 7, 2023 in Others by narikkadan
 • 63,600 points • 798 views
0 votes
1 answer

OR and IF function for multiple values

Your OR functions will always return TRUE ...READ MORE

Feb 13, 2023 in Others by narikkadan
 • 63,600 points • 533 views
0 votes
1 answer

How To Copy/Cut Row of Data Based on TRUE/FALSE Condition [Excel VBA]

Solution Loop through the rows on the Price ...READ MORE

Feb 4, 2023 in Others by narikkadan
 • 63,600 points • 918 views
0 votes
1 answer

How to query a matrix for multiple values and receive value

Try: =IFERROR(INDEX(SORT(SORT(FILTER(MATRIX, (LENGTHS>length)*(WEIGHTS>weight)),1,1),2,1),1,3),1) , where MATRIX, LENGTHS, and WEIGHTS ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,000 points • 618 views
0 votes
1 answer

Excel Power Query Moves old Data to the right

Just empty the page and then add ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
 • 38,000 points • 356 views
0 votes
1 answer

Hide or visible sheets

Use a loop instead of repeating very similar ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 63,600 points • 637 views
0 votes
1 answer

PowerQuery Extract everything before alphabet from a column

Add column, custom column, with formula: = ...READ MORE

Feb 9, 2023 in Others by narikkadan
 • 63,600 points • 678 views
0 votes
1 answer

Application.Workbooks(V_WBNameOutPut).Activate alternative

You can capture the workbook when it's ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 63,600 points • 279 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.