Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
equation that will filter out #N/A's
I currently have a string of items that looks like the following:
#N/A #N/A 1" Shaft Liner DensGlass Ultra 2'x12' #N/A #N/A #N/A 1/2" 4'x12' Regular #N/A #N/A 1/2" DensArmor Plus 4'x08' (paperless) #N/A #N/A 1/2" DensShield 32"x05' #N/A #N/A 1/2" Hardi-Backer 3'x05' #N/A 1/2" MR 4'x08' 1/2" MR 4'x12' #N/A #N/A #N/A 5/8" 4'x14' FC Type X #N/A #N/A 5/8" DensGlass Gold 4'x08' FC Type X #N/A #N/A #N/A 5/8" MR 4'x08' FC Type X #N/A 5/8" MR 4'x12' FC Type X #N/A #N/A I am trying to filter out the #N/A's, so that it will output on the same worksheet the following: 1" Shaft Liner DensGlass Ultra 2'x12' 1/2" 4'x12' Regular 1/2" DensArmor Plus 4'x08' (paperless) 1/2" DensShield 32"x05' 1/2" Hardi-Backer 3'x05' 1/2" MR 4'x08' 1/2" MR 4'x12' 5/8" 4'x14' FC Type X 5/8" DensGlass Gold 4'x08' FC Type X 5/8" MR 4'x08' FC Type X 5/8" MR 4'x12' FC Type X Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |