All Questions
693
questions
-2
votes
1
answer
71
views
Writing an Excel Spreadsheet Formula
I need an Excel formula that will find the most efficient combination of products based on the value of a single cell.
e.g., I have a product list as follows: 400 / 220 / 150 / 110 / 72 / 60.
I need a ...
- 1
1
vote
3
answers
28k
views
Excel Formula To Get Last Non Zero or Not Blank Value in Column And Return Value
I already saw a few related questions on here about finding the last item but my question is a bit different because I'm trying to find the last not blank or non zero value in a column and either ...
- 135
1
vote
1
answer
2k
views
How to find "#VALUE" cells in Excel?
In Excel 2007 I have two sheets:
sheets1 with data
sheets2 links with some formulas data from sheets1
If a formula does not work in sheets2 I have cell that shows #VALUE!, but in the bar I can see ...
- 756
0
votes
3
answers
1k
views
Excel VLOOKUP for range of dates
I have been struggling with VLOOKUP for sometime. I want to use VLOOKUP for a range of dates using the two tables I have given. I want to get which Term each row belongs to. Basically I want to check ...
- 101
1
vote
2
answers
2k
views
How to calculate average and standard deviation from the same range in excel
I have an excel sheet in which there are there are groups of 4 values in column H. So H7 to H10 contain 4 values relating to one sample. H11 to H14 contain 4 values relating to another sample.
In ...
- 13
0
votes
1
answer
210
views
OFFSET function in Excel
I'm having some trouble with the OFFSET function in Excel. I'm modifying a file created by someone else, the code was not written by me.
So in one sheet of the file, in the cells it applies the ...
- 103
1
vote
3
answers
20k
views
Selecting the first row in excel where a column value equals a certain value
I have a excel sheet which displays the status of various products on my website throughout the day, along with the timestamp of the status as so:
| Timestamp | Product 1 | Product 2 | ...
0
votes
1
answer
142
views
Is it possible to know if the field in Excel is raw value or two numbers added together
Meaning... I have b5 with value 345,33 and b6 with value 22,00+12,00 which Excel correctly calculates as 34,00 BUT I need to know if the 34 is result of adding or just a plain number like in b5 ? ...
0
votes
1
answer
842
views
Excel transpose function returns a 0, multiple worksheets
I do have two worksheets.
In worksheet 1 I do have the following values horizontal listed:
A1 = 2010
B1 = 2011
C1 = 2012
In worksheet 2 I would like to list the values (2010, 2011, 2012) vertically. ...
- 121
1
vote
3
answers
4k
views
Subtraction formula which ignores or treats any non-number precedent cell as 0 (to fix #VALUE! error)
I need to subtract cells, but when one or both of them is blank, or contains text, the subtract formula returns a #VALUE! error.
I am using =SUM(A1-B1).
Can anyone please help with the formula which ...
- 542
0
votes
1
answer
78
views
Excel Database for Questionnaire Results
I need to make an ongoing database for a questionnaire with 12 questions. The tick box options are Certainly True, Somewhat True, Not True and Dont Know.Each of these has a value. So if you select ...
- 1
0
votes
1
answer
1k
views
How to show a column name in excel if a condition is met (eliminating the blank ones)
I have the following table:
I need the Result row to show the name of Fruits if their value is greater than 1. I have the following function for R18, it gets dynamic when stretched to the succeeding ...
0
votes
1
answer
46
views
Excel If-Else formula to capture ''hour" and "min" across an excel row
I have a row of "h min" values (eg:2h 15min) across a row. I need to capture the 'hour' and 'min' separately for which I'm using "=LEFT(B2,(FIND(" ",B2,1)-1))" and "=...
- 103
1
vote
0
answers
224
views
Formatting cell to show text in a text box. Excel Sheet
I have this sheet. The Product details section and the price section are not visible because of large amounts of text in them. When I manually make the size equal to the text..It becomes very ugly and ...
- 125
0
votes
0
answers
45
views
excel how to search content text from multiple that opening file
I have one folder that content many excel file in it(share drive). file opening by user using it. How we can search text in each file. I trying search by ''content:"str search"'' but result ...
- 101