| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula: select value in column if condition in 2nd col met
I want to construct a formula to select the largest value in a column of data
for only data that meets a condition in a second column. Specifically I want to select the largest value in a column of data for only values that are specified "WIN" in a second column. Example: column 1: cell A1 = 5, cell A2 = 10, cell A3 = 20 column 2: cell B1 = WIN, cell B2 = loss, cell B3 = WIN So formula should give 20 as the result (eg largest WIN value). I have pored over help guides and on-line references but can't do it, so if anyone can help....pleease! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a formula to select a cell using the row and column values | Excel Worksheet Functions | |||
| Formula to select every third cell in a very long column of data? | Excel Discussion (Misc queries) | |||
| How to select the value based on given condition? | Excel Discussion (Misc queries) | |||
| How to select certains records meeting a certain condition !!!! | Excel Worksheet Functions | |||
| How to randomly select from a list with condition | Excel Worksheet Functions | |||
Threaded Mode
