LinkBack URL
About LinkBacks
I don't understand why don't you use formula in post that can be normally entered?!?
I don't understand why don't you use formula in post that can be normally entered?!?
Never use Merged Cells in Excel
Okay this did work in the end, thank you for that!
The only way I get now that it completely excludes the double values (so for instance the code 123 is present a couple of times in the column, then I want it to be counted as 1, now it doesn't count it at all..).
How can I do that?
Try this array formula**:
=SUM(IF(FREQUENCY(IF(B2:B100<>"",MATCH(B2:B100,B2:B100,0)),ROW(B2:B100)-ROW(B2)+1),1))
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks