Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional if or lookup
HI all,
i posted another one like this but i can't seem to find it here in the group. I need your help with a formula that would be on column d. if b1=b2 then give me the value in column a with highest number between c1:c2. if b1 does not equal b2, then give me the value of a1. if b8=b9=b10=b11, then give me the coresponding column a value with highest in c8:c11. or another way of looking at is: if column b has two (or more) numbers of the same, then give me the coresponding column a value which has the highest number in c. Column a.......column b........column c red ...............1......... 1 blue .......... 2........ 4 green .......... 3........ 1 purple ......... 4.......... 1 black ......... 4......... 10 orange ......... 5........... 1 pink ......... 6........... 1 gray ...... 7.......... 7 white ....... 7.......... 1 brown ........ 7......... 5 gold ......... 7.......... 1 thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Lookup | Excel Discussion (Misc queries) | |||
Conditional Lookup | Excel Worksheet Functions | |||
Conditional Lookup | Excel Discussion (Misc queries) | |||
Conditional Lookup? | Excel Worksheet Functions | |||
conditional lookup | Excel Worksheet Functions |