Linked Questions
28 questions linked to/from Display Blank when Referencing Blank Cell in Excel 2010
7
votes
2
answers
11k
views
Turn one row into multiple rows in Excel
I have multiple items that are available in multiple distribution centers (i.e., a many-to-many relationship). There is currently one row per item, with one column for each distribution center. A cell ...
7
votes
3
answers
1k
views
Excel IFBLANK equivalent for IFERROR
IFERROR works great because it shortened the formula significantly by having a default behavior, returning the results if condition is not met (no error).
I'm looking for the IFBLANK version of this ...
0
votes
1
answer
60
views
No answer if cell blank
I'm subtracting 2 dates. If the dates are <=5 then the answer is Y, if not then the answer is N. How do I ignore blank cells so I don't automatically get a Y? This is the formula I'm using.
=IF(...
0
votes
1
answer
1k
views
i want to return value( eg;- sum) only if the source is not blank,other wise return blank !!not zero!! in excel, wps
see this screenshot for reference
see this screenshot..
I used SUM formula in the botton cells to get sum of all values from each row , the bottom cells display TOTAL
and i will assign the TOTAL ...
0
votes
3
answers
3k
views
Excel MAX IF Function To Ingore Zero Date (1/0/00)
=MAX(IF('[YTD -2021.xlsx]OB'!$H$2:$H$23967=$C5,IF('[YTD -2021.xlsx]OB'!$J$2:$J$23967=$B$1,'[YTD -2021.xlsx]OB'!$A$2:$A$23967)))
I want to ignore Zero date and result should give me 0 or blank instead ...
1
vote
2
answers
2k
views
I have a formula in excel and want it to return blank if referenced cell is blank and not a "0" [duplicate]
Some of the referenced cells are blank and I would like that to be carried over instead of returning "0" in the cell
This is my formula -
=VLOOKUP(B2, SKUs!A$2:$E$7, 3, FALSE)
Thanks for any ...
1
vote
1
answer
14k
views
How to display blank if linked cell is blank? Excel 2010
I have a database that have two sheets, Sheet 1 is a link of Sheet 2. if a cell in Sheet 2 is blank then I want the same cells in Sheet 1 to be blank, instead they either show "0" or "00/01/1900" how ...
-1
votes
1
answer
25
views
How do I populate an Excel 2010 cell when a different cell is manually populated the same worksheet but a different tab? [closed]
How do I auto populate an Excel 2010 cell when a different cell is manually populated in the same worksheet but a different tab?
2
votes
2
answers
727
views
One column data into database table format
I have data in an Excel worksheet in a single column like the following:
[Name]
[Company]
"EMAIL" (HYPERLINK)
[Name]
[Company]
"EMAIL" (HYPERLINK)
[Phone]
[Name]
...
Most people don't have phone ...
0
votes
2
answers
3k
views
How to keep cell blank until date entered [duplicate]
So basically, "INVOICE DUE DATE" is the SUM of D11+7 ("Date invoice sent out" + 7 days as this is when the invoice is due). However, when there is no date inputted in "DATE INVOICE SENT OUT" the "...
3
votes
2
answers
816
views
How can I select data and draw chart using a button in Excel?
In my Excel workbook (i.e., file),
I have for example seven sheets (Mon, Tue ... Sun) of temperatures.
This data is recorded for the whole day in a fixed frequency.
Now I want to create a tool to ...
0
votes
2
answers
340
views
Excel interprets percentage inputs inconsistently
I am inputting numbers into a cell that is formatted to display the number as percentage.
I desire to enter 10%, so I type “10” into the cell and hit Enter. The cell now displays 10% (great).
I ...
0
votes
1
answer
136
views
having trouble making a special work calendar in excel
This is the setup:
1. work days
Mo
Tu
Wed
Thu,
Fri different hours
2. shifts daily MO to THU:
early 5:15 - 13:30 = 8:15
Late 13:30 - 21:30 = 8:00
night 21:30 - 5:15 = 7:45
3. Friday hours
...
1
vote
2
answers
175
views
Robust linking of cells Excel
Is there a way to link cells so that not only content updates automatically, but also format (fill, border, font, etc.)?
Also, is there a way, other than doing each cell individually, to avoid blank ...
0
votes
1
answer
20k
views
Display 0 as blank in a pivot table
How can i display a value of 0 as blank in a pivot table. The column I wish to apply this to is formatted as a date. And anything with a value 0 displays as 00/01/1900.
I tried conditional formatting ...