In column their are multiple cells with same data but i want last row

[psudhakar999]

Hi

Order_ID Status
76899 Packing
76899 Sent for deliver
76900 Sent for deliver
76900 Delivered
76899 Delivered

Now I want get only 76899 Delivered & 76900 Delivered it should get last Order ID I mean if any order ID was repeating it should take last one and get status

[:) Sixthsense :)]

Use Lookup() Formula

[psudhakar999]

Use Lookup() Formula

Hi Can you provide sample code for above example in lookup

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[psudhakar999]

Hi please find attachment for sample data

[:) Sixthsense :)]

In E2 Cell

=LOOKUP(C2,C2:C11,D2:D11)

[psudhakar999]

This was getting error i have 4,00,000 rows data if column 1 having same order ID 3 times it should get 3rd row order id and 3rd row status column

[:) Sixthsense :)]

if column 1 having same order ID 3 times it should get 3rd row order id and 3rd row status column

That is what Lookup() will do

[psudhakar999]

This was getting error i have 4,00,000 rows data if column 1 having same order ID 3 times it should get 3rd row order id and 3rd row status column

[psudhakar999]

Can you run formula in sample data worksheet and send it to [email protected] i will use same way against all 4lkhs records

[:) Sixthsense :)]

Please show it in excel with sample data with the formula resulting error data.

It is not useful for both of us in digging something on assumption, because without seeing the data and the way you applied the formula will not help us in fixing the issue

[martindwilson]

lookup wont work directly unless the data is sorted ascending
but you could use
=LOOKUP(2,1/($C$2:$C$40000=76899),$D$2:$D$40000)

[psudhakar999]

testeidprocess.csvtesteidprocess.xlsx Please find sample data

[martindwilson]

see attached