All Questions
Tagged with microsoft-excel worksheet-function
7,317
questions
-2
votes
1
answer
91
views
How to count occurrences of rows that have certain value only if preceding by certain value, and count how many rows of that
I have some data spread over one column and 120 rows
there is a repetition of the value 1 and 0 corresponding to certain operation mode
so it looks as per the image attached
My question is how to ...
0
votes
1
answer
42
views
Nested If statement. working in two sheets
its been a long time since I used Excell so my thinking may be complety wrong, but this wont work. Am I using the wrong Syntax for LibreOffice Calc
=IF(M3>$'Shipping Profile'.$A$3,then $'Shipping ...
0
votes
0
answers
50
views
How to highlight cells based on my defined pattern
Experts, Please help this excel newbie
Admin Developer Subscribe
Contributor Product Owner Write
Viewer Stakeholder Create
Test engineer View
Viewer ...
0
votes
0
answers
60
views
Find missing rows from two data sets based on multiple criteria
I have two datasets, one of claims I have submitted to our biller, another of claims that my biller has in their system. These data sets contain some of the same data and some different data.
I need ...
0
votes
0
answers
26
views
Rule for if cell has data manually added it changes text colour
Hi i have a sheet with months and years horizontally and a location vertically per cell.
I will ad a score in each cell for the different locations, but not add scores in all cells each month as we ...
0
votes
1
answer
55
views
XLOOKUP - I need the lookup value to default to 2 decimal places
I currently have a spreadsheet that i want an occurance ratio, the lookup value is giving me 9 decimal places, how can i change it to 2 so i don't have a million lines with the lookup values?
Example: ...
0
votes
0
answers
20
views
Subtracting value from pivot table (only when the data is available)
The data in my pivot table changes every week. Sometimes the value for certain data will not be available during certain week and available in other week. For now I had to manually check the data and ...
0
votes
2
answers
71
views
Calculate a moving average in excel where the lookback (window) duration is a variable that changes based on another cell's changing values
I am trying to calculate a moving average of a dataset where the moving window time duration is not fixed, but changes over time based on numbers in a different column. Using the screenshot I have ...
0
votes
0
answers
36
views
Excel - Formula help - If A2 = !A2:A4, highlight !B2:B4 IFNOT = B2
I have 2 large workbooks of employee data and need to express the following in a formula.
Workbook 1:
Employee ID
First Name
00000001
Sam
00000002
Fred
00000003
Bob
Workbook 2:
Employee ID
First ...
4
votes
1
answer
166
views
Consolidate Data from Multiple Columns into One Column
I have a dataset that looks something like this:
Customer
Col1
Col2
Col3
Bob
111
2221
Michael
112
Anna
113
2223
Rachel
114
2224
334
Person5
115
I'd like to put all data into one column, ...
0
votes
1
answer
104
views
Why does rank.avg and rank.eq give duplicate ranks?
I have just recently (a week ago) started learning Excel, and I'm struggling to understand why Rank.avg() and Rank.eq() are giving duplicate rankings, when all the values are different. Neither my ...
1
vote
1
answer
79
views
Excel Formula: How to filter against an array excluding blank cells?
I have a worksheet tab that contains a table exported from a piece of software used. On another sheet I have a filter function set up to be based on cell input, essentially a quicker way to search ...
0
votes
2
answers
86
views
MS Excel Convert column data into row
I have all data in a column in MS excel.
Please see the attached picture: .
I am trying to covert data with its corresponding heading and other data associated with its "Acct No.". as sample ...
0
votes
1
answer
79
views
In Excel is there a way to “turn on and off” the =min in a formula?
I am creating a budget spreadsheet in Excel and in some instances I will need the formulas in the spreadsheet to include the =MIN and in some instances I won’t. For example, the formula is:
=MIN(...
0
votes
0
answers
36
views
Excel SUM function and + operator different for blank text
The + operator in Excel gives an error when adding two cells whose values are empty text, while the SUM function treats these cells as zero (as I expected). I am trying to understand if this is the ...