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...
In the attached version of Subodh_Tiwari_sktneer"s solution file, the array formula (confirmed with Ctrl+Shift+Enter) in D2 is:
=IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2)-1,
LOOKUP(2,1/(A$1:A1&B$1:B1=A2&B2),D$1:D1),
"SET"&MAX(IFERROR(--SUBSTITUTE(D$1:D1,"SET",""),0))+1)
You're welcome.