All Questions
14
questions
9
votes
3
answers
35k
views
Excel TEXT function does not work properly
Let say I have the following values in the cells
A1 : `=Now()` which displays 17.03.2014 13:45
A2 : 12.03.2014
Both are in date format and I have the function in another cells like this:
B1 : `=...
2
votes
1
answer
3k
views
Excel formula to show FORMULA
Ok, guys. I am 100% sure that a few days ago I saw and tested a real built-in Excel formula for showing a formula as text in any cell. Now, when I need it, I cannot find it!!! No VBA, no tricks. Just ...
2
votes
3
answers
13k
views
Listing non-blank cells in Excel based on adjacent column(s)
Given columns A and B, I want to list the A-values that have a non-blank B-cell in their row, in column C:
A B C
One Two
Two x Four
Three
Four x
...
The best I came up with so ...
33
votes
4
answers
5k
views
AND function gives TRUE result for empty, BLANK cell - why?
I have blank B2 cell.
=ISBLANK(B2) gives TRUE
A simple logical test on it returns FALSE
=IF(B2,TRUE,FALSE) gives FALSE
Yet when directly used in an AND statement, it returns TRUE
=AND(B2,TRUE) ...
8
votes
5
answers
276k
views
Excel Formula To Get First Non-Zero Value in Row and Return Column Header
I am attempting to find a formula where I can look at a column range within a row and return the column header in that row where the first non-zero value occurs, moving left to right.
Below is a ...
5
votes
2
answers
26k
views
How to interpolate intermediate values for arbitrary data in Excel
I have data tables like this example, nine entries at A1:B9 in this case:
A B
-- ---
1 2.9
2 5.06
3 7
4 8.84
5 10.87
6 13.24
7 16.22
8 20.25
9 36.7
The above ...
2
votes
1
answer
13k
views
Is it possible to automatically add cells from a new sheet to a formula in Excel?
I would like to make a new financial spreadsheet for tracking expenses. Since the expense sheets are created as and when I cannot pre-generate a spreadsheet to populate with formulae. I have a summary ...
1
vote
0
answers
206
views
MS Excel Formula For Fitting Things in Buckets
I have a spreadsheet that defines a collection/container of shelves, and then an assortment of objects that can be placed on the shelves
So, there are 4 collections of shelves defined in a table, ...
0
votes
1
answer
4k
views
Two related cells: give a value in one, calculate the other, and vice versa? [duplicate]
How can I have a cell that uses the literal value written into it, or calculates its value when no literal value was given?
For example:
I have two columns: column B with a price including VAT, and ...
0
votes
1
answer
3k
views
How do I merge data from other Excel files to one master Excel worksheet?
I have an uniform ID system throughout all the files, except with multiple entries and differing data named columns. I would like to create a master excel sheet with specific data columns from each ...
0
votes
2
answers
8k
views
How to remove duplicates from 1 column but leave empty cells in place of duplicate?
I have a sheet with 2 columns. first column has unique values, while the second column has many duplicates.
I would like to remove duplicates from the second column , however the cells that ...
0
votes
2
answers
109
views
Split data into new column
As per attachment i have column A having name with underscore "_' and bracket " [ " . I need a formula to get answer of column B means I need formula to get id before underscore and inside bracket .
...
0
votes
1
answer
38
views
Nested Ifs for personal accounting sheet
I have a personal accounting sheet with 5 columns. C is Debit, D is Credit and E is Balance. I want to do 3 things but I've been confusing myself for the past hour.
If C5 and D5 are both blank, ...
0
votes
1
answer
7k
views
How to Mirror cells in excel 2013 [closed]
I want to make an excel file for sales management of my company. the excel I have created has 4 sheets and every sheet is handled by different persons.
I want to dedicate the first column of these ...