Deleting #NA in a Spreadsheet
ctrl + F | find what: # | options | look in : values | find all | ctrl
+ A | esc | delete |
On Oct 31, 5:18*pm, Confused_in_Houston
wrote:
I run vlookups and get a large number of #NA responses. *I know in a single
column, I can sort by the vlookup column, group the #NA's; highlight and
delete. *
However, some spreadsheets have 10 or more columns of vlookups, so I've got
#NA's all over the page. *Rather than do ten sorts, I'd like to find a way to
delete all #NA's at the same time.
I've tried the Replace function but it doesn't connect my #NA with the #NA's
on the spreadsheet.
Thanks. *I always appreciate the help I get here.
|