| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help, Multiple conditional calculation
I have a question about multiple conditional calculation. Here is my
question. A B C D E F A1 B1 C1 D1 =Max(A1:D1) A2 B2 C2 D2 =Max(A2:D2) A3 B3 C3 D3 ... A4 B4 C4 D4 ... I have a database like row 1-4 and column A to D. (The actual database is much bigger.) I konw how to get the maximum value as I write above. My question is how to get the location of the maximum number in F colum? For example, if in E3, the maximum number is B3, then F should be B3. I have checked with the excel help, but just find a "if function" with two conditions. So what can I do? I am a greenhand in advanced Excel and know nothing about VBA program. So if the program is needed, would you please explain in a little detail? Thanks. wwj |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) | |||
| how do i use multiple conditional formats in one cell? | Excel Discussion (Misc queries) | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| How do I use conditional formatting for multiple rows? | Excel Worksheet Functions | |||
Threaded Mode
