MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Compare value against a list


Posted by Harry on September 26, 2000 5:56 PM

I have to compare a default value against a list of numbers and keep track of how many times the default value appears.

This may be a stupid question but is there any way to compare a value against an entire range of numbers in an 'if' statement????


Posted by Celia on September 26, 2000 6:15 PM


Harry
You can use the COUNTIF worksheet function.
Have a look at on-line Help.
Celia