Recent questions tagged excel-formula

0 votes
1 answer

Transform Excel table columns (not all) into rows - long to wide transformation

Jan 8, 2023 in Others by Kithuzzz
 • 38,000 points • 1,537 views
0 votes
1 answer

Excel - Find the Max for Total revenue just for year 1

Jan 8, 2023 in Others by Kithuzzz
 • 38,000 points • 1,229 views
0 votes
1 answer

How to merge two Tables and Add the amount at the same time?

Jan 7, 2023 in Others by Kithuzzz
 • 38,000 points • 1,638 views
0 votes
1 answer

How can find location of value in a square using excel

Jan 7, 2023 in Others by Kithuzzz
 • 38,000 points • 1,458 views
0 votes
1 answer

Broken external links in Excel : a leading "file:///" scheme appended to paths can't be evaluated in formulas

Jan 7, 2023 in Others by Kithuzzz
 • 38,000 points • 1,517 views
0 votes
1 answer

Excel formula in Pandas

Jan 6, 2023 in Others by Kithuzzz
 • 38,000 points • 3,493 views
0 votes
1 answer

Separate full address into street address, city, state, zip, country in excel

Jan 6, 2023 in Others by Kithuzzz
 • 38,000 points • 2,614 views
0 votes
1 answer

Microsoft Open XML Read Excel file using SAX method row by row and finding cell data

Jan 6, 2023 in Others by Kithuzzz
 • 38,000 points • 2,670 views
0 votes
1 answer

Excel - Separating text with numbers, text and brackets into separate cells

Jan 5, 2023 in Others by Kithuzzz
 • 38,000 points • 2,595 views
0 votes
1 answer

INDEX MATCH formula in Excel returning incorrect results in some cells and correct results in others

Jan 5, 2023 in Others by Kithuzzz
 • 38,000 points • 2,374 views
0 votes
1 answer

Dynamic Subtraction formula in excel sheet

Jan 5, 2023 in Others by Kithuzzz
 • 38,000 points • 2,358 views
0 votes
1 answer

Excel 365 Formulas - How to save LAMBDA function permanently (for all existing and new files)?

Jan 5, 2023 in Others by Kithuzzz
 • 38,000 points • 2,836 views
0 votes
1 answer

How can I perform a reverse string search in Excel without using VBA?

Jan 5, 2023 in Others by Kithuzzz
 • 38,000 points • 3,257 views
0 votes
1 answer

Excel formula to convert number to both feet and inches

Jan 5, 2023 in Others by Kithuzzz
 • 38,000 points • 2,136 views
0 votes
1 answer

Excel grade formula

Jan 3, 2023 in Others by Kithuzzz
 • 38,000 points • 1,420 views
0 votes
1 answer

Excel - count days between two dates per year

Dec 28, 2022 in Others by Kithuzzz
 • 38,000 points • 1,652 views
0 votes
1 answer

How to automate split by delimiter in Excel (equivalent of =SPLIT in gSheets)

Dec 28, 2022 in Others by Kithuzzz
 • 38,000 points • 2,060 views
0 votes
1 answer

Excel Formula Help Conditional Formatting - If A2 =TODAY and B2=Y turn A2 Green. If B2 = N turn A2 RED

Dec 28, 2022 in Others by Kithuzzz
 • 38,000 points • 1,768 views
0 votes
1 answer

Stop Excel from automatically converting certain text values to dates

Dec 28, 2022 in Others by Kithuzzz
 • 38,000 points • 2,151 views
0 votes
1 answer

Excel-How can I get the address of a cell instead of a value?

Dec 28, 2022 in Others by Kithuzzz
 • 38,000 points • 1,728 views
0 votes
1 answer

How to subtract dates in Excel with different date formats?

Dec 28, 2022 in Others by Kithuzzz
 • 38,000 points • 2,346 views
0 votes
1 answer

Excel Formula/Function to Subtract randomly

Dec 28, 2022 in Others by Kithuzzz
 • 38,000 points • 1,585 views
0 votes
1 answer

DATEDIF Excel - output incorrect

Dec 28, 2022 in Others by Kithuzzz
 • 38,000 points • 1,835 views
0 votes
1 answer

Excel Formula - Calculating Total Percentage

Dec 28, 2022 in Others by Kithuzzz
 • 38,000 points • 1,445 views
0 votes
1 answer

Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)

Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 2,205 views
0 votes
1 answer

Excel formula to convert EST date time into IST date time?

Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 1,758 views
0 votes
1 answer

How can I count the rows with data in an Excel sheet?

Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 1,835 views
0 votes
1 answer

Division formula in excel

Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 1,198 views
0 votes
1 answer

What is the character code for new line break in excel

Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 1,799 views
0 votes
1 answer

How to subtract date only format "mm/dd" in excel?

Dec 25, 2022 in Others by Kithuzzz
 • 38,000 points • 2,120 views
0 votes
1 answer

Get random value in the range of plus/minus 10% of a cell value in Excel

Dec 25, 2022 in Others by Kithuzzz
 • 38,000 points • 2,139 views
+1 vote
1 answer

Excel or Google formula to count occurrences of an 8-digit number within a text string

Dec 24, 2022 in Others by Kithuzzz
 • 38,000 points • 2,454 views
0 votes
1 answer

Calculating accuracy within excel

Dec 22, 2022 in Others by Kithuzzz
 • 38,000 points • 4,218 views
0 votes
1 answer

Non-exact Vlookup with multiple search criteria - Microsoft Excel

Dec 22, 2022 in Others by Kithuzzz
 • 38,000 points • 1,235 views
0 votes
1 answer

Excel - VLOOKUP vs. INDEX/MATCH - Which is better?

Dec 22, 2022 in Others by Kithuzzz
 • 38,000 points • 1,607 views
0 votes
1 answer

IfError with else, does this function exist in Excel?

Dec 22, 2022 in Others by Kithuzzz
 • 38,000 points • 2,758 views
0 votes
1 answer

How to sum column until current row?

Dec 19, 2022 in Others by Kithuzzz
 • 38,000 points • 2,279 views
0 votes
1 answer

HLOOKUP in Excel Formula

Dec 17, 2022 in Others by Kithuzzz
 • 38,000 points • 1,340 views
0 votes
1 answer

Return blank cell only if referred cell is blank, but return aging if date is entered

Dec 17, 2022 in Others by Kithuzzz
 • 38,000 points • 3,098 views
0 votes
1 answer

How to freeze the =today() function once data has been entered

Dec 17, 2022 in Others by Kithuzzz
 • 38,000 points • 3,072 views
0 votes
1 answer

Adding formulas to excel spreadsheet using python

Dec 17, 2022 in Others by Kithuzzz
 • 38,000 points • 3,334 views
0 votes
1 answer

Standard deviation only for data that meets two conditions in Excel

Dec 16, 2022 in Others by Kithuzzz
 • 38,000 points • 1,638 views
0 votes
1 answer

Filter sumproduct formula based on array

Dec 16, 2022 in Others by Kithuzzz
 • 38,000 points • 2,313 views
0 votes
1 answer

Excel data validation list

Dec 16, 2022 in Others by Kithuzzz
 • 38,000 points • 1,895 views
0 votes
1 answer

What would I have to add to this VBA Code to keep Undo Button working after it runs?

Dec 16, 2022 in Others by Kithuzzz
 • 38,000 points • 1,660 views
0 votes
1 answer

How do I avoid repeating long formulas in Excel when working with comparisons?

Dec 15, 2022 in Others by Kithuzzz
 • 38,000 points • 1,828 views
0 votes
1 answer

Excel VLOOKUP between two sheets failing

Dec 12, 2022 in Others by Kithuzzz
 • 38,000 points • 1,587 views
0 votes
1 answer

PMT function in Javascript

Dec 12, 2022 in Others by Kithuzzz
 • 38,000 points • 3,703 views
0 votes
1 answer

Copy formula from Excel to Notepad++

Dec 12, 2022 in Others by Kithuzzz
 • 38,000 points • 3,415 views
0 votes
1 answer

Excel If Functions with Multiple Conditions

Dec 12, 2022 in Others by Kithuzzz
 • 38,000 points • 1,516 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.