Linked Questions

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 ...

15 30 50 per page