WANT TO return a group number of each po, and group items.

Is using a pivot table an option? Perfect job for a pivot table

Thanks for the reply.
No its not in a pivot table but I might try that out if it works.

I'm not too familiar with using pivot tables? Can you show me how that can be used?

Can anyone help with a formula that would return a group number in column C

Attached is a pivot example. Not the most elegant solution but maybe someone else knows better

Wrong formula

thanks for the input.

However, the values in column C are what I want to get. So in order to get those values I need a formula for the rows in column C.

Thank you

	a	b	c	d	e	f	g	h
1	po#	item	group			po#	item	group
2	123	a	1			123	a	1
3	123	a	1			123	b	2
4	123	b	2			123	c	3
5	123	b	2			456	a	1
6	123	c	3			456	b	2
7	456	a	1			456	c	3
8	456	b	2
9	456	b	2
10	456	c	3

H2=IF($F2<>"",SUM(IF(FREQUENCY(IF($A$2:$A$10&$B$2:$B$10=F2&G2,$C$2:$C$10),$C$2:$C$10),$C$2:$C$10)),"")

Control+shift+enter copy down