-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Count Unique Entries in a range.
- Thread starter rajivsoni
- Start date
Gates Is Antichrist
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 1,961
Richard,
Frank Kabel stated that your formula is only completely robust starting with Excel 2003. He adds that in previous versions you have to be sure what the data range (in our example A1:A10) is completely within the used range of your spreadsheet. Otherwise this formula returns #DIV/0. You can check this in a new/fresh workbook by simply entering this formula. To prevent this bug use [the other formula] instead.
He's certainly right for XL97.
Frank Kabel stated that your formula is only completely robust starting with Excel 2003. He adds that in previous versions you have to be sure what the data range (in our example A1:A10) is completely within the used range of your spreadsheet. Otherwise this formula returns #DIV/0. You can check this in a new/fresh workbook by simply entering this formula. To prevent this bug use [the other formula] instead.
He's certainly right for XL97.
Upvote
0
Excel Facts
What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Similar threads
- Solved
