CountIf Formula

R

Redi

Hi all,
i need your help with another formula

column a..column b... column c....column d
green..... banana... 1 5
orange... apple...... 2 3
blue...... apple..... 2 6
yellow... orange... 3 8
black.... orange... 3 4
white.... orange... 3 9
red..... rasbery... 4 6

In column e, where the formula will be, I'd like this condition: if
c1=c2 give me highest between d1:d2, if not give me d1

can anyone put something together for this one?
 

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

Top