Home |
Search |
Today's Posts |
#1
|
|||
|
|||
After using a formula how can I filter out answers I don't want?
I have used a vlookup formula with success, but I would like to hide all #REF
and 0 answers that have come up. An IF function won't work, what can I use to filter these answers out? |
#2
|
|||
|
|||
Try
=IF(ISERROR(your_formula),"",your_formula) to hide the #REF errors Unclick ToolsOptionsViewZero values to hide the 0 answers -- Regards Roger Govier "Em" wrote in message ... I have used a vlookup formula with success, but I would like to hide all #REF and 0 answers that have come up. An IF function won't work, what can I use to filter these answers out? |
#3
|
|||
|
|||
If I understand you correctly, a function that may help is ISERROR (see how
to use on http://www.auditexcel.co.za/information.html ). This works well in conjunction with an IF statement although the cells won't be hidden but will rather show a character of your choosing, maybe a - or a zero or blank. "Em" wrote: I have used a vlookup formula with success, but I would like to hide all #REF and 0 answers that have come up. An IF function won't work, what can I use to filter these answers out? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Frequency formula | Excel Worksheet Functions | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions |