All Questions
172
questions
1
vote
1
answer
286
views
how to rearrange values in multiple cells in different columns in excel
I have a list of questions with 4 answer options for each question of them placed in 4 columns one next to the other, the correct answer option is ended with "!" which turn the cell to green ...
- 23
-7
votes
1
answer
76
views
URGENT =IF(C3>37.6,"high"), IF(C3<36.6,"low"),IF(AND(C3>36.7,C3<37.5,"normal"))) is this formula right
The second half of the formula doesn't work If body temperature of patient (t) < 36,6, it is low, from 36,7 to
37,5 - normal, greater than 37,6 - high.
This is the information to create the ...
- 1
0
votes
1
answer
8k
views
matching names from one Excel Spreadsheet to another
I have two separate spreadsheets, both with several hundreds of employees names. My task at the moment is to go through one of the spreadsheets to see if any employees are matching on both, which will ...
0
votes
2
answers
228
views
Multiplying Arrays of Uneven Length based on criteria and Summing the result
I have two tables in my spreadsheet, a Name Table:
and a Category Table:
From the above two, how do I create a formula that lets me calculate cost by category in a single cell as shown below:
0
votes
4
answers
2k
views
Display column header containing highest value in a spreadsheet
So, I have a list of names and values, linked here:
Ideally, I want to locate the highest value in the spreadsheet, and then display the name of the person with the highest value overall.
So far, ...
0
votes
1
answer
62
views
What should I do if I have to match one column with another column in excel in the same spreadsheet?
I need to find out how many rows in column B match with rows of column A.
1
vote
1
answer
732
views
How to fit a polynomial trendline such that only the leading two coefficients are non-zero in Excel?
I have data on the displacement of an object over time and a cubic trendline fits it very well.
I know that the initial displacement is 0 so I can tick the "set intercept" box.
However, I also know ...
-1
votes
1
answer
5k
views
How to automatically update all the relevant cells in Excel when a new row is added
So I have a spreadsheet used for calculating let's say the taxes on something which I purchased. It has a column with the sales tax calculation, state tax, etc. and all each of these columns reference ...
- 1
1
vote
0
answers
250
views
What is the VBA equivalent of using an array formula to calculate the max non-blank value of a range?
I have the following array formula in Excel: {=MAX((C9:C44<>"")*(ROW(C9:C44)))} that calculates and returns the row number of the last non-blank cell in a range.
I could reference the result in ...
- 103
0
votes
1
answer
97
views
How to automatically multiple match/dropdown on Excel
I am trying to generate a report for the assets within the company. I am essentially trying to create an automatic drop down list. I have done some research on using INDEX and AGGREGATE methods but I ...
0
votes
1
answer
863
views
How to sum values in a spreadsheet based on matching criteria in another sheet?
I have a spreadsheet where I track income and expenses. The spreadsheet has two different sheets which I am trying to craft a query between (example tables below).
Transactions:
Categories:
The ...
- 65
0
votes
2
answers
51
views
How do I apply =If to an existing formula?
I have this formula currently:
=INDEX(C2:C6,MATCH(MAX(B2:B6),B2:B6,0))
I want to apply this formula if the criteria is something specific in column A. Any ideas how to do it?
Perhaps my initial ...
1
vote
2
answers
2k
views
MS Excel - Separate text based on keyword
I need to separate text based on a keyword to different columns. the original text is in one column but I want to split the intended subtext into different columns. The problem in this case is I get ...
1
vote
1
answer
83
views
Open a spreadsheet with broken formulas
I am using code the generate a spreadsheet, including a formula for a cell on certain rows. When I do this, there is something wrong with the formula, and when I try and open the spreadsheet, Excel ...
- 2,651
2
votes
1
answer
207
views
Devising Excel Spreadsheet Formulas
I'm using Excel for the accounting purposes of a group venture, to keep track of our expenses, costs, payments, and balances.
Details of each expense are stored in columns A:J
Total costs and ...
- 393