Display cell value only to unique cell

[calvinle]

Hi,

The left table is the main data and right is the result I wanna get.

Can anyone help?

[jeffreybrown]

How about...

=IF(COUNTIFS($E$2:E2,E2,$F$2:F2,F2)>1,"",E2&F2)

[calvinle]

Hi,

The left table is the main data and right is the result I wanna get.

Can anyone help?

Nope, it doesnt work..

[jeffreybrown]

Nope, it doesnt work..

Well ain't that a bummer. What didn't work? What did you try? Care to share what you did?

[Green Crocodile]

Nope, it doesnt work..

Jeffrey's solution works. Try converting the table to a range, then putting in the formula, then you can convert it back to a table. See if that works out for you.