Returning a truly blank cell if formula return is nil I have a Spreadsheet (Nomi

Question

Returning a truly blank cell if formula return is nil

I have a Spreadsheet (Nominal) with employees information in the Columns A, B and C rows 1 to 150 (Name, Initial, Age)

My next Spreadsheet (Info) refers to the info in Nominal! columns A,B and C. However because I have inserted the formula =NominalA1 =Nominal!A2 and Nominal!A3 etc right down to A300, but at present only the first 150 rows are populated the last 150 cells return a "0". I tried using the

=IF(ISBLANK(Nominal!A1),"",Nominal!A1) formula to not display the "0"

This worked fine, but when I try to sort my Info sheet by A to Z I have 150 blank rows at the top before I get to my other data.#

How can I stop this from happening.

Thanks

Explanation / Answer

Well, you could

1) Sort the data on Nominal instead

2) Sort Z-A, then select the cells that are not "" and sort A-Z

3) Use =IF(ISBLANK(Nominal!A1),"ZZZZZ",Nominal!A1)

4) Use a macro

5) Don't use two sheets - use one sheet and 2 views

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.