After using a formula how can I filter out answers I don't want?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try
=IF(ISERROR(your_formula),"",your_formula) to hide the #REF errors

Unclick Tools>Options>View>Zero values to hide the 0 answers
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use & with two formulas 2
VLOOKUP displaying "NO ANSWER" instead of "0" 2
auto extend formulas 2
Automatic filter for unique records 10
Using cell contents in Vlookup formula 3
formula drag down when using filter in 2007 0
Using VLOOKUP to locate an answer in one of multiple columns 7
Searching the formula (not the value) for a text string 1

Back
Top