Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create list (exluding blanks) from different fields?
I am trying to create a list in Excel that will remove all blanks from
possible entry fields that might be left blank during data entry. I thought about doing an "if" statement that gives me either a 1 or 0 based on whether the fields are completed or empty. Then, I could add the numbers in columns so that the 1st completed column has the number 1 beside it and the second completed column has the number 2 beside it etc. How can I make a cell find (for example) the number 2 and then reference a cell in the same row? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
Create a summary list using same fields from multiple sheets | Excel Discussion (Misc queries) | |||
Update fields with blanks | Excel Discussion (Misc queries) | |||
Show value 0 in blanks fields | Excel Programming | |||
Import - query table - retain trailing blanks in fields | Excel Programming |