All Questions
Tagged with microsoft-excel worksheet-function
7,324
questions
2
votes
2
answers
21k
views
Excel 2007: how to work out percentages of groups (top 10% of...)
I've recently read the following paragraph, and wondered:
how you would organise the data (possibly Column A = country, Column B = salary, Column C = tax paid)
but what formulas/calculations are used ...
4
votes
2
answers
2k
views
How can I write "use this cell or, if blank, use this other cell" in Excel 2007?
I am trying to show the Days between NOW() and the dates (dd/mm/yy) in either Column B or Column C - depending which one is not blank.
A B C
29/03/10 01/04/10
29/03/10 02/...
0
votes
2
answers
462
views
EXCEL generate a character in one column of a row, only if other columns in the same row are not blank
My speadsheet keeps track of when patients leave a specific floor of the hospital. There are columns in which where each patient goes is documented (1 column for "home", another column for "rehab ...
1
vote
1
answer
2k
views
Excel: VLookUp solves a potential Nested IF problem
I manually enter numbers on one cell according to text values in the cell adjacent to it. Is there a way to use the IF function to help me manage this? The text is automatically generated with a ...
2
votes
2
answers
1k
views
Excel Table lookup with indexes in multiple columns
I have a Table in Excel the looks about like this:
Test1 100 test2 200
Test3 110 test4 210
Test5 120 test6 220
I want a function that, given test 1 as input, will return 100 AND given ...
1
vote
1
answer
2k
views
Concatenate cells that change daily automatically?
I use concatenate to pull data together from different cells in my spreadsheet. Since my data changes daily, I want the formula to also change daily without having to manually input the new cell in ...
2
votes
1
answer
208
views
Return the date of the day under an if formula with Excel or VBA
I have two columns A and B and many lines with some specific tasks to be done. In column B, I have a drop-down list with the name of people who are scheduled for the task . And in column A, I want the ...
2
votes
2
answers
9k
views
How can I write an excel formula to do row based calculations?
Could someone please help me with the following excel formula. Each row in my spreadsheet contains details about a product.
I have one column 'Quantity' (Col B) and 'Profit' (Col F). I want to use ...
7
votes
5
answers
101k
views
Excel: copy cell formatting in equation
If I make an equation:
' on cell A2
=A1
Is there a way to make A2 have the exact same formatting as A1 and not just the value?
i.e. I want a FORMULA that copies both the value and the format/...
6
votes
4
answers
64k
views
How do you include an OR inside a SUMPRODUCT function, in Microsoft Excel?
How do you include an OR inside the sumproduct function in Excel? I currently use two sumproduct formulas because I have two variables I want it to count:
=Sumproduct((A3:A159=B3:B159)*(D3:D159="...
23
votes
5
answers
158k
views
How to get time difference as minutes in Excel?
I have time values in two cells in an Excel sheet and I need the difference of
the times in minutes.
The cells in the Excel are like below:
A B C
1 6:38 8:23 1:45:00
A is ...
5
votes
4
answers
6k
views
Excel annoyance: How to maintain formulas in a ledger?
A common use of Excel is to create a spreadsheet which functions as a transaction ledger of some kind, where one or more fields in each row is calculated by adding a value or values from the current ...
4
votes
2
answers
38k
views
excel VLOOKUP, how to specify dynamic worksheet name?
I'm trying to create a VLOOKUP formula in excel, however, the table array may be in a number of different worksheets.
For example, I have this forumula
=Vlookup(a1, ‘[Datafile.xlsx]worksheetapples’!$...
3
votes
3
answers
56k
views
How to set Function "formula" for whole column in Excel 2007?
I want to set "Formula" to all cells in certain column whatever the number of rows was.
But i don't want to set this function to first cell "Header" of this column.
How do i make it ?.
3
votes
3
answers
8k
views
What is an excel formula that will return me the last row number of a cell within a range that contains specific data?
I have a spreadsheet that will default with values of "No". Over time, these values will be changed to "Yes".
I need a formula (no VB, please, VB is useless to me) that will get me the row number of ...