Dear All,
Need some help on retrieve unique values into column E. Please refer below for samples. i have tried vlookup and hlookup but can't work![Frown :( :(](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
<tbody>
</tbody>
Need some help on retrieve unique values into column E. Please refer below for samples. i have tried vlookup and hlookup but can't work
columnA | columnB | columnC | columnD | columnE | reference |
apple | not | not | not | apple | watermelon |
not | orange | not | not | orange | banana |
not | not | banana | not | orange | |
not | not | not | watermelon | apple |
<tbody>
</tbody>