Hello Everyone,

Just want to ask if you know what formula to be used for example, you have multiple duplicate amounts (about 10 items amounting 10,000 - some are received in the same day) received and you want to vlookup in your summary of OR issued. The common vlookup will result same OR number (which is the first one in the series). Hope you can help me on this.. the result i was hoping is that it will eliminate duplicate OR. thanks