Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Kerri Gonzalez   on Jan 28 In MS Office Category.

  
Question Answered By: Aaminah Khan   on Jan 28

Easiest way is probably to use a spare column  to hold a filled-in name.

Assume ... name is in column A; cells without names are empty; if the cell
is empty, then take the name from the previous cell  that is not empty; spare
column is G.

=IF(A5="",G4,A5)

If this is copied down G, it'll bring names across, or look up to the
previous row  for a value.

You can then auto-filter on G.

Now this isn't a copy, it's a formula. E.g. you can't delete a row without
mucking things up.

If you want, though, you can select all of column G, then
copy/paste-special-values to get rid of the formulas.

Not sure why you'd look for Post Code being blank. If that's significant,
then this simple formula won't cater for it.

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Copy IF Staff Spreadsheet Or get search suggestion and latest updates.


Tagged: