Trending questions in Others

0 votes
1 answer

Hide or visible sheets

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

Feb 10 in Others by narikkadan
 • 63,160 points • 174 views
0 votes
1 answer

Exclude worksheets from loop with a list

You can achieve this by making a ...READ MORE

Feb 11 in Others by Kithuzzz
 • 38,010 points • 126 views
0 votes
1 answer

Sort numeric values VBA

Try: The formula in B1: =SORTBY(A1:A8,LEFT(A1:A8&"0000 ...READ MORE

Feb 11 in Others by Kithuzzz
 • 38,010 points • 124 views
0 votes
1 answer

How to rename a workbook other than using (Name) and (FileSystemObject. MoveFile)?

Use  SHFileOperation API Option Explicit Private Declare PtrSafe Function SHFileOperation ...READ MORE

Feb 11 in Others by Kithuzzz
 • 38,010 points • 119 views
0 votes
1 answer

Excel: Count distinct numerical values if string condition matches

FILTER Shipper and Month based on Employee ...READ MORE

Feb 10 in Others by narikkadan
 • 63,160 points • 157 views
0 votes
1 answer

How to read A column in xlsx file with pandas?

You can view all the columns with: excel_data.head() ...READ MORE

Feb 9 in Others by narikkadan
 • 63,160 points • 196 views
0 votes
1 answer

Ordering data in python or excel

Basically, the data is converted from wide ...READ MORE

Feb 11 in Others by Kithuzzz
 • 38,010 points • 109 views
0 votes
1 answer

Inferior statement

Try this: =IF(ISBLANK(A1),"Date Missing",IF((B1-A1)<365,"Death& ...READ MORE

Feb 10 in Others by narikkadan
 • 63,160 points • 151 views
0 votes
1 answer

Google Spreadsheet/ Excel - how to find matching values in column A, having necessary values in column M

Try this: =COUNTIF($M$2:$M$5;A2) If the product is present in ...READ MORE

Feb 10 in Others by narikkadan
 • 63,160 points • 147 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 in Others by narikkadan
 • 63,160 points • 397 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 in Others by narikkadan
 • 63,160 points • 263 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 in Others by narikkadan
 • 63,160 points • 260 views
0 votes
1 answer

Finding duplicate values in 5 excel sheets and results to be moved in the sixt one

See this article: VBA duplicated values coloring. I ...READ MORE

Feb 10 in Others by narikkadan
 • 63,160 points • 129 views
0 votes
1 answer

Generate number by using Dynamic array (w/o VBA)

Try: The formula in F2: =IFERROR(REDUCE(HSTACK("Name",SEQUENCE(,MAX(D2#))),UNIQUE(A2#),LAMBDA(a,b,LET(c,BYROW(HSTACK(C2#,D2#),LAMBDA(d,MIN(d))),e,FILTER(HSTACK(B2#,B2#&"-"&c,D2#),A2#=b),VSTACK(a,HSTACK(b,XLOOKUP(SEQUENCE(,MAX(DROP(e,,2)))-1,TAKE(e,,1),INDEX(e,,2),0,1)))))),"") If you really happen to ...READ MORE

Feb 10 in Others by narikkadan
 • 63,160 points • 126 views
0 votes
1 answer

How to increment a column value if it repeats, otherwise reset to 1?

Use COUNTIF: =COUNTIF(A$2:A2,A2) The absolute and relative cell coordinates ...READ MORE

Feb 4 in Others by narikkadan
 • 63,160 points • 381 views
0 votes
1 answer

PowerQuery Extract everything before alphabet from a column

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

Feb 9 in Others by narikkadan
 • 63,160 points • 164 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 in Others by narikkadan
 • 63,160 points • 273 views
0 votes
1 answer

Get column names of Excel worksheet with OpenPyXL in readonly mode

This will print every thing from row ...READ MORE

Oct 22, 2022 in Others by narikkadan
 • 63,160 points • 4,900 views
0 votes
1 answer

Excel - Conditional Formatting not working because cell has an existing formula

Go to Conditional Formatting -> Rules to ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 63,160 points • 2,799 views
0 votes
1 answer

'composer' is not recognized as an internal or external command in windows server

For anyone coming here from Google who ...READ MORE

Feb 17, 2022 in Others by Aditya
 • 7,680 points • 15,540 views
0 votes
1 answer

VBA Export as PDF and Save to Location with name as per a Cell in the worksheet

Following is the code that gets generated ...READ MORE

Jan 20 in Others by narikkadan
 • 63,160 points • 999 views
0 votes
1 answer

VBA How to extract the date and time of arrival of a answered email

Use MailItem.ReceivedTime property. I hope this helps you ...READ MORE

Jan 9 in Others by narikkadan
 • 63,160 points • 1,458 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 in Others by narikkadan
 • 63,160 points • 336 views
0 votes
1 answer

Python Error when I'm converting Excel to JSON

The "Birth Year" value in the p ...READ MORE

Feb 5 in Others by narikkadan
 • 63,160 points • 284 views
0 votes
1 answer

Excel VBA Scheduled message pop up box reminder

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

Feb 3 in Others by narikkadan
 • 63,160 points • 370 views
0 votes
1 answer

How can increase the speed of if statement in VBA Code?

Use a Dictionary Object. Option Explicit Sub PreencherO() ...READ MORE

Feb 7 in Others by narikkadan
 • 63,160 points • 197 views
0 votes
1 answer

How can I rename each column of a table?

Add Name For Each Column Sub AddNames() ...READ MORE

Feb 7 in Others by narikkadan
 • 63,160 points • 176 views
0 votes
1 answer

Excel Copy/ Paste Special with selected sheets not working

Application.DisplayStatusBar = True Is cancelling your ...READ MORE

Feb 5 in Others by narikkadan
 • 63,160 points • 249 views
0 votes
1 answer

Looking to create a conditional statement in excel

Try using a rule based on a ...READ MORE

Feb 7 in Others by narikkadan
 • 63,160 points • 159 views
0 votes
1 answer

Newbie needs Excel suggestions with a simple script

Formula to Count the Number of Occurrences ...READ MORE

Feb 7 in Others by narikkadan
 • 63,160 points • 158 views
0 votes
1 answer

How do I output the row containing the lowest value from a specific column inside a filtered dynamic array?

Instead of using 1 filter function to ...READ MORE

Feb 6 in Others by narikkadan
 • 63,160 points • 192 views
0 votes
1 answer

How can one sort a list of dictionaries into an excel sheet such that each unique key and one corresponding key are placed into columns?

With pandas, you can use something like this ...READ MORE

Feb 6 in Others by narikkadan
 • 63,160 points • 191 views
0 votes
1 answer

I want to compare two Excel files and highlight the differences with VBA

The workbook doesn't have the UsedRange property ...READ MORE

Jan 13 in Others by narikkadan
 • 63,160 points • 1,228 views
0 votes
1 answer

Copy the respective values from another workbook depend on specific conditions

Try this: Sub Get_Respective_Values_Of_Last_Closing_Date() Dim wb1 ...READ MORE

Feb 6 in Others by narikkadan
 • 63,160 points • 185 views
0 votes
1 answer

VBA - user input of row value to use in a cell range

Use this: Range("C" & c & ":I" & ...READ MORE

Feb 7 in Others by narikkadan
 • 63,160 points • 144 views
0 votes
1 answer

Writing large Excel in Java causing high CPU usage using apache-poi

Giving SXSSFWorkbook a window size appears to ...READ MORE

Jan 29 in Others by narikkadan
 • 63,160 points • 531 views
0 votes
1 answer

Is there an efficient way to do this excel function

Use vlookup(): VLOOKUP(E2,$B$4:$C$8,2,1) READ MORE

Feb 7 in Others by narikkadan
 • 63,160 points • 129 views
0 votes
1 answer

Reshape excel table with stacked date column

I agree that using a pivot makes ...READ MORE

Feb 6 in Others by narikkadan
 • 63,160 points • 165 views
0 votes
1 answer

Selecting a value of a table in Excel

Use this formula: =LET(step1,FILTER(A1:D6,A1:D1=B11), INDEX(D1:D6, ...READ MORE

Feb 7 in Others by narikkadan
 • 63,160 points • 122 views
0 votes
1 answer

Excel Visual Basic managing coordinate tuple type

A tuple can be saved as an ...READ MORE

Feb 4 in Others by narikkadan
 • 63,160 points • 234 views
0 votes
1 answer

Excel VBA - Need to get a specific line from TextBox and send to an specific Cell

Moving your string into an array first ...READ MORE

Feb 2 in Others by narikkadan
 • 63,160 points • 314 views
0 votes
1 answer

How to split only one column to multiple rows while copying rest of the columns along the way?

Try this: =DROP(REDUCE(0,REDUCE(0,C2:C3,LAMBDA(a,x,VSTACK(a,CONCAT ...READ MORE

Feb 6 in Others by narikkadan
 • 63,160 points • 127 views
0 votes
1 answer

To Keep only 1 header while merging Multiple file

There is potential for improvement here, such ...READ MORE

Jan 31 in Others by narikkadan
 • 63,160 points • 379 views
0 votes
1 answer

Searching Multiple Criteria In Large Data Set to make new Data Set Excel VBA

Copy the data to an array, filter ...READ MORE

Jan 31 in Others by narikkadan
 • 63,160 points • 365 views
0 votes
1 answer

Excel VBA: Auto increment cell value after each printing

Print Copies of Single Worksheet With Increment Option ...READ MORE

Jan 22 in Others by narikkadan
 • 63,160 points • 751 views
0 votes
1 answer

Autofill macro to autofill dates up to 31 days regardless of the month

If you wish to utilise a single ...READ MORE

Feb 5 in Others by narikkadan
 • 63,160 points • 132 views
0 votes
1 answer

Hide contents of drop-down list in Excel with password?

So, 3 versions all relatively similar: Above shown ...READ MORE

Feb 3 in Others by narikkadan
 • 63,160 points • 219 views
0 votes
1 answer

How do I make my subs() not change inputdata in Vba excel

Use the ByVal keyword to pass on ...READ MORE

Feb 5 in Others by narikkadan
 • 63,160 points • 127 views
0 votes
1 answer

Successive retrieval of defined ranges, by splitting thier names in a constant as well as a dynamic part

You can use a Select Case statement : Option Explicit Sub ...READ MORE

Feb 5 in Others by narikkadan
 • 63,160 points • 124 views
0 votes
1 answer

Excel Vlookup function to map duplicate and get the max occurence value

Assuming there is no Excel version restriction ...READ MORE

Feb 4 in Others by narikkadan
 • 63,160 points • 167 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.