Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf Formula
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf Formula
so, in E1 or E2:
=if(c1=c2,max(d1:d2),d1) "Redi" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF formula | Excel Worksheet Functions | |||
Formula Help (countif, I think....) | Excel Discussion (Misc queries) | |||
Formula Countif | Excel Discussion (Misc queries) | |||
countif formula | Excel Discussion (Misc queries) | |||
CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions |