Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting #NA in a Spreadsheet
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
deleting a spreadsheet | Excel Discussion (Misc queries) | |||
deleting rows in a huge spreadsheet with subtotals | Excel Discussion (Misc queries) | |||
Deleting a Command Button from my Spreadsheet | Excel Discussion (Misc queries) | |||
Excel 2003; spreadsheet with filtering; deleting rows | Excel Worksheet Functions | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel |