| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help needed: Minimum value based upon either/or criteria
Hi all,
I'm trying to find a minimum value in one column (A) for all records in which columns B or C are equal to a cell reference in a separate worksheet. I've tried something like: =MIN(IF(OR(COLUMN B option, Column C option),Column A range)). But it's only giving me zeros which I know are not correct. Any ideas? Thanks in advance. M |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to reference a cell based on the minimum of division of two cells, please help? | Excel Worksheet Functions | |||
| Minimum With Two Criteria | Excel Discussion (Misc queries) | |||
| Returning contents of a cell based upon the minimum value in a ran | Excel Worksheet Functions | |||
| find minimum of range based on multiple criteria | Excel Worksheet Functions | |||
| Minimum and Maximum with Complex Criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
