Recent questions tagged excel-formula

0 votes
0 answers

What is the extension of MS Excel?

Sep 8, 2023 in Others by Satyawrat
 • 460 points • 1,347 views
0 votes
0 answers

What is function in MS Excel?

Sep 7, 2023 in Others by anonymous
 • 990 points • 1,333 views
0 votes
0 answers

Require a dropdown list based on input that matches Column header

Apr 11, 2023 in Others by Kithuzzz
 • 38,000 points • 1,308 views
0 votes
0 answers

How do I use text as reference in EXCEL

Apr 11, 2023 in Others by Kithuzzz
 • 38,000 points • 2,060 views
0 votes
0 answers

VLOOKUP with date range does not work as intended

Apr 11, 2023 in Others by Kithuzzz
 • 38,000 points • 1,379 views
0 votes
0 answers

Formula in Excel with a particular increment value

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 1,241 views
0 votes
1 answer

Find specific term in a text string and return that term in the previous column

Apr 10, 2023 in Others by narikkadan
 • 86,360 points • 1,569 views
0 votes
1 answer

Excel Debt Payoff Calculator

Apr 9, 2023 in Others by Kithuzzz
 • 38,000 points • 1,568 views
0 votes
1 answer

MS Excel Reordering letters in cell

Apr 7, 2023 in Others by narikkadan
 • 86,360 points • 1,413 views
0 votes
1 answer

Excel worksheet multi-criteria function (like Index-Match array) to fetch last value of an item, looking up by item name and date

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

Count Function for identifying the Unique values in Excel

Apr 6, 2023 in Others by Kithuzzz
 • 38,000 points • 1,875 views
0 votes
1 answer

Nesting functions within the IF statement in EXCEL

Apr 6, 2023 in Others by Kithuzzz
 • 38,000 points • 1,582 views
0 votes
1 answer

Click cell to generate dynamic table

Apr 6, 2023 in Others by Kithuzzz
 • 38,000 points • 1,339 views
0 votes
1 answer

How to use COUNTIFS with multiple conditions and columns in Excel?

Apr 4, 2023 in Others by narikkadan
 • 86,360 points • 1,888 views
0 votes
1 answer

Excel - FIND function (case-sensitive) ignores case?

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

Choosing a random text value from a list

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

How to get subscript into formulas text string

Apr 3, 2023 in Others by Kithuzzz
 • 38,000 points • 2,296 views
0 votes
1 answer

Type the max number title in Excel

Apr 2, 2023 in Others by narikkadan
 • 86,360 points • 1,445 views
0 votes
1 answer

Excel Nested IF INDEX MATCH Function

Apr 1, 2023 in Others by Kithuzzz
 • 38,000 points • 2,159 views
0 votes
1 answer

Stuck on a Query for a stock trading spreadsheet

Apr 1, 2023 in Others by Kithuzzz
 • 38,000 points • 1,321 views
0 votes
1 answer

How to transpose data in an other tab in excel

Mar 31, 2023 in Others by narikkadan
 • 86,360 points • 1,612 views
0 votes
1 answer

Adjacent excel cells show same cell address on using =cell("address") formula.

Mar 31, 2023 in Others by narikkadan
 • 86,360 points • 1,468 views
0 votes
1 answer

List Fridays and Saturdays in excel

Mar 31, 2023 in Others by narikkadan
 • 86,360 points • 1,312 views
0 votes
1 answer

How to turn a number recognized as string to number

Mar 30, 2023 in Others by Kithuzzz
 • 38,000 points • 1,678 views
0 votes
1 answer

Is there a function in excel to automatically calculate age using date of birth?

Mar 28, 2023 in Others by narikkadan
 • 86,360 points • 1,787 views
0 votes
1 answer

Excel - How do I round a date type to the next hour if it is more than one minute

Mar 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,608 views
0 votes
1 answer

Mapping cells between between two ranges

Mar 27, 2023 in Others by Kithuzzz
 • 38,000 points • 2,039 views
0 votes
1 answer

Count unique matches between two rows in Excel

Mar 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,607 views
0 votes
1 answer

Highlight duplicates with only 2 colors

Mar 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,485 views
0 votes
1 answer

Excel AVERAGEIF function in combination with MOD to average over every nth row not behaving as expected

Mar 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,715 views
0 votes
1 answer

Combine Two Formulas in Separate Cells Into One Cell

Mar 26, 2023 in Others by narikkadan
 • 86,360 points • 2,223 views
0 votes
0 answers

Excel Formulas Limitations when compared to Excel VBA Power

Mar 26, 2023 in Others by narikkadan
 • 86,360 points • 1,131 views
0 votes
1 answer

Extracting a Variable Number of Letters from a Formula using VBA Code

Mar 26, 2023 in Others by narikkadan
 • 86,360 points • 1,614 views
0 votes
1 answer

How to assign assign condition using if statement and VLOOKUP?

Mar 26, 2023 in Others by narikkadan
 • 86,360 points • 1,519 views
0 votes
1 answer

Comparison operator with duration that may exceed 1 day with format h:mm

Mar 25, 2023 in Others by Kithuzzz
 • 38,000 points • 1,228 views
0 votes
1 answer

VBA Macro to add a relative reference column

Mar 25, 2023 in Others by Kithuzzz
 • 38,000 points • 1,504 views
0 votes
1 answer

Why does difference between same dates shows a difference of 1 month in Excel?

Mar 24, 2023 in Others by narikkadan
 • 86,360 points • 1,662 views
0 votes
1 answer

Check multiple cells in excel, move to next cell if null and if value found stop and return that value

Mar 24, 2023 in Others by narikkadan
 • 86,360 points • 1,739 views
0 votes
1 answer

Substring/Find last occurence of "/" and output everything to the right of it

Mar 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,790 views
0 votes
1 answer

Excel, unable to update count

Mar 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,674 views
0 votes
1 answer

Count number of equal values in two rows in Excel

Mar 21, 2023 in Others by narikkadan
 • 86,360 points • 1,730 views
0 votes
1 answer

Reading Excel file Date/time Incorrectly

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

Return value if scores contain value form min and Max column

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

IF statement for a tax sheet does not work

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

How to trick an Excel function that wants a column as input to accept a list of values as if these were in a column

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 2,049 views
0 votes
1 answer

EXCEL - Is there a formula for TEXTSPLIT from 3 different rows into a sequencing of rows without data /text duplication?

Feb 26, 2023 in Others by narikkadan
 • 86,360 points • 1,755 views
0 votes
1 answer

Dragging Down Skipping Rows

Feb 26, 2023 in Others by narikkadan
 • 86,360 points • 1,603 views
0 votes
1 answer

How to calculate current streak of conditional number, and excluding blanks?

Feb 26, 2023 in Others by narikkadan
 • 86,360 points • 1,449 views
0 votes
1 answer

How can I sum all the data in January example

Feb 26, 2023 in Others by narikkadan
 • 86,360 points • 1,512 views
0 votes
1 answer

Reshaping/Deduping long data to wide in R

Feb 26, 2023 in Others by narikkadan
 • 86,360 points • 1,641 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.