Need next number

N

Nadine

I have the following information
Col A ColB ColC ColD Col E (where the formula needs to go
but showing what the result should be)
CA1234 75016 AA 1 5
CA1234 75016 AA 1 5
CA1234 75016 AA 1 5
CA1234 75016 AA 2 5
CA5678 75321 BB 4 4
CA5678 75321 BB 3 4
CA1234 75016 AA 5 5
CA5678 75321 CD 1 4
CA5678 75321 CD 4 4
CA5678 75321 BB 1 4
Col E should find the largest number in Col D that belongs to the
combination in the first 3 columns.
Any ideas on the formula to go in each line in col E?
Thank you.
 
J

Jordon

Nadine said:
I have the following information
Col A ColB ColC ColD Col E (where the formula needs to go
but showing what the result should be)
CA1234 75016 AA 1 5
CA1234 75016 AA 1 5
CA1234 75016 AA 1 5
CA1234 75016 AA 2 5
CA5678 75321 BB 4 4
CA5678 75321 BB 3 4
CA1234 75016 AA 5 5
CA5678 75321 CD 1 4
CA5678 75321 CD 4 4
CA5678 75321 BB 1 4
Col E should find the largest number in Col D that belongs to the
combination in the first 3 columns.
Any ideas on the formula to go in each line in col E?
Thank you.
Click to expand...

What does "belongs to the combination of the first 3 columns", mean?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find next number 2
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Function to mapping data 0
Cell Counter/Increment 2
Min Max Question 4
Creating Different Headers in Word 0
Counting unique values in multiple columns 4

Top