All Questions
Tagged with excel excel-formula
28,591
questions
1
vote
1
answer
33
views
nested "if and" statements in excel
I have the below table and have an 2 "IF AND" statement there:
May I ask, if I would like to combine the "IF AND" statement together, how should I go about it? What I am trying to ...
- 577
0
votes
0
answers
20
views
Excel - Find all duplicate entries in Column A (and its Row), copy each dupe entry so they're grouped together, to new Spreadsheet
My apologies for this and this is because I need a solution relatively quick, and I have very little Experience in Excel Functions, VBS, etc. meaning, I won't hit a goal I need very soon.
My goal Move ...
-2
votes
2
answers
77
views
Excel, while loop with variable loops
Good evening all,
I have a table in columns "A" and "B". It is known as a BOM (Bill of Material) and column "A" is the parent of column "B" the child. Some ...
- 951
0
votes
1
answer
43
views
How to calculate times in variable cells [closed]
I am trying to create an Excel file that logs diver times. Specifically, I am logging their in/out times, total dive time, and surface intervals. If you're not a diver, the total dive time is the ...
- 147
0
votes
1
answer
38
views
What excel formula can I use to compare 2 columns and pick the cell that does not have #n/a in it?
A
B
C
**1**
ID 1
ID 2
Expected Output
**2**
0011Q00001xC8a7QAC
#N/A
0011Q00001xC8a7QAC
**3**
0011Q00001xC8aTQAS
#N/A
0011Q00001xC8aTQAS
**4**
#N/A
0011Q00001xxxFFFQr
0011Q00001xxxFFFQr
**5**
#N/A
...
0
votes
4
answers
55
views
How to return number placement based on criteria from a table?
I've run into an issue that I can't quite figure out. I need to return the placement of a list of values based on a separate criteria.
I have a table that looks like this:
I'm looking for a way to ...
- 189
1
vote
0
answers
21
views
How to stop a #N/A result showing in a most frequent value formula? [duplicate]
I have a spreadsheet of raw data that includes a cost based on a product code. I am trying to create a table that collates that information into an easy to read overview.
The cell I am currently ...
- 11
4
votes
4
answers
89
views
Compare a number array with existing records in Excel or VBA
I have a sheet with 3k+ lines and 15 columns. Each column is filled with a random number from 1 to 25. Very much like lottery results, where each column is a number drawn from the lottery. (from 1-25)
...
- 123
-2
votes
2
answers
85
views
Excel multidimensional count
Is the below possible in Excel for Mac?
I have a sheet containing 10s of 1000s of records and I need to repeatedly do analysis on it to count the total incidence of substrings within different samples ...
0
votes
1
answer
55
views
Counting Non-blanks and Date Condition within Specific Ranges
I'm trying to make this work with when I filter data on excel I understand countif doesn't work here but I can't seem to make SUBTOTAL work.
=((SUBTOTAL(103,A3:A76))-(COUNTIF(E3:E76,"<="&...
- 1
0
votes
1
answer
62
views
Is there something wrong with this function to exclude entries in a conditional format in Excel?
I am trying to format a column to display duplicate entries, but I would like to exclude #N/A as that is what shows up when there is no data to display that is meaningful. I have a memo from an order ...
- 9
0
votes
0
answers
15
views
Matching text using more than one column in excel 2016 [duplicate]
I'm trying to use MATCH with INDEX to retrieve a value from a different sheet based on 2 columns. Basically from Sheet1 I need to bring the Value located on Sheet2 using Project1 and Project2, when ...
- 735
0
votes
2
answers
40
views
Name on Envelope
I have a spreadsheet with one to two names per row, broken into first and last names. I'm trying to concatenate the names, the result depending on whether the last name is the same or different, or ...
- 69
0
votes
0
answers
47
views
Entered too many arguments for this function
I am having a problem where I am unable to find out the issue with my formula in Excel. Everything worked fine until I added an additional argument to the string, but I do not see any erroneous commas ...
0
votes
0
answers
41
views
Counting cells which only contain 0 [closed]
How am I able to count the cells which contain only 0
My range is
July Payment
August Payment
September Payment
October Payment
November Payment
December Payment
0
0
0
0
0
1000
I tried to use:
=...
