Group unique value

[rplim2016]

Hi Mr. Excel,

I need help, as my lead challenge me but I can't do it in any means. He only wants me to use a formula in column B. Only FORMULA.

Col A:
a
b
b
a
a
b
c
c
c

Col B: Answer must me in group unique value
1
2
2
1
1
2
3
3
3

Please help.

 

[Aladin Akyurek]

Book1
	A	B
1	item	group
2	a	1
3	b	2
4	b	2
5	a	1
6	a	1
7	b	2
8	c	3
9	c	3
10	c	3
Sheet1

In B2 enter and copy down:

=IF(ISNA(MATCH($A2,$A$1:A1,0)),MAX($B$1:B1)+1,VLOOKUP($A2,$A$1:$B1,2,0))

 

[jmacleary]

Hi there. This should work:

In cell B1 put the value 1 (As its the first entry it will always be 1). In cell B2 put this formula '=IF(ISNA(VLOOKUP(A2,A$1:A1,1,FALSE)),MAX(B$1:B1)+1,VLOOKUP(A2,A$1:B1,2,FALSE))' and drag B2 down column B. The use of $ signs is important so make sure you put the formula exactly as written.

 

[rplim2016]

Thank you so much!!!