Count Unique Values and Position

**ccpsc** · 10-23-2012, 02:21 AM

In Column A in the attached spreadsheet there are 10 numbers but only 8 of them are unique. I need code to display each numbers position in the eight 1/8, 2/8, etc as shown in column B. Can someone help me with this?

**zbor** · 10-23-2012, 02:54 AM

I overcomplicated it

But I try to work for all kind of possibilities (not only if it's just pairs)...

Formula:

Please Login or Register  to view this content.

**ccpsc** · 10-23-2012, 02:57 AM

Hi zbor. That works great but I need it in vba code as the results will not be entered into the same cell each time the spreadsheet is run. Any help would be good, thanks.

**zbor** · 10-23-2012, 04:11 AM

You can use Evaluate(function).
But since you need a VBA it can be simplier that way.

**ccpsc** · 10-23-2012, 04:35 AM

Thanks zbor I managed to get it all to work. I used your formula in another sheet and used vba to transfer the results where I want them to display. I will keep Evaluate() in mind, I haven't seen it before.

**ccpsc** · 10-23-2012, 06:40 PM

zbor - There is a problem with the formula. It counts some different values as the same. See rows 1, 3 & 8 in attached file "Book2" This also means there is no 6/6

Can anyone fix the formula?