Forum Discussion
formula for getting different sets of data entered
can anyone help me in this col.1| col.2| col.3 A | A | SET1 A | B | SET2 B | A | SET3 A | B | SET2 C | B | SET4 B | A | SET3 C | B | SET4 And so on... how can i get get different sets in co...
Please try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of Enter alone.
In C2
=IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2)=1,
"SET"&SUM(--(FREQUENCY(MATCH(A$2:A2&B$2:B2,INDEX(A$2:A2&B$2:B2,),0),ROW(A$2:A2)-ROW($A$2)+1)>0)),
INDEX(C$1:C1,MATCH(A2&B2,INDEX(A$1:A1&B$1:B1,),0)))Confirm with Ctrl+Shift+Enter and then copy it down.
ok got it formula working fine
Thanks a lot.))