Forum Discussion
Solved
Help with tricky formulas
Hi there, I need some help with some tricky excel formulas. Would greatly appreciate some help as I have nearly 7000 rows of data to sort out. The developer I was hoping to get help from has hand...
Hi Nic,
Formula in D could be
=IF(COUNTIFS($B$1:$B1,$B2,$C$1:$C1,$C2),LOOKUP(2,1/($B2=$B$1:$B1),$A$1:$A1),"")
and attached
Greetings!
As understood, please find formula
for 4th column:=IF(AND(B3>B2,C2<>""),CELL("contents",C2),"")
for 5th column:=IF(AND(B3=B2,C2<>""),CELL("contents",C2),"")
Thanks,