Hi,
Please for correct excel formula with condition i need Result Column B fill name from Column A, if have same will Blank ""
[TABLE="border: 1, cellpadding: 1, width: 500"]
[tr][td]NAME
[/td][td]NEED RESULT
[/td][td]MY WRONG RESULT
[/td][td]my wrong formula
[/td][/tr][tr][td]A
[/td][td]A
[/td][td]A
[/td][td]=IF((A2=A3);"";(A$2:A2))
[/td][/tr][tr][td]B
[/td][td]B
[/td][td][/td][td]=IF((A3=A4);"";(A$2:A3))
[/td][/tr][tr][td]B
[/td][td][/td][td]B
[/td][td]=IF((A4=A5);"";(A$2:A4))
[/td][/tr][tr][td]C
[/td][td]C
[/td][td][/td][td]=IF((A5=A6);"";(A$2:A5))
[/td][/tr][tr][td]C
[/td][td][/td][td]C
[/td][td]=IF((A6=A7);"";(A$2:A6))
[/td][/tr][tr][td]D
[/td][td]D
[/td][td]D
[/td][td]=IF((A7=A8);"";(A$2:A7))
[/td][/tr][tr][td]E
[/td][td]E
[/td][td]E
[/td][td]=IF((A8=A9);"";(A$2:A8))
[/td][/tr]
[/TABLE]
Thanks - John