Formula Help

[Harini1100]

Hello Guys,

Please help me with the formula for below scenario. Team A is the key and I have more than 12000 rows of data in the work book.

 

[awoohaw]

try this:
insert one column, then:

Mr Excel Questions 75.xlsm
	A	B	C
1			14569
2	14569	Team A	Team A
3		Team B	Team B
4		Team C	Team C
5			15986
6	15986	Team A	Team A
7		Team B	Team B
8		Team C	Team C
Sheet2

Cell Formulas
Range	Formula
A2:A8	A2	=IF(ISNUMBER(C2),"",IF(C2="Team A",C1,""))
B2:B8	B2	=IF(ISNUMBER(C2),"",C2)

Then copy paste as values,
Then delete column C.

 

[Harini1100]

Perfect solution Thanks