Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can anyone solve this!?
Imagine the following data: A B C D 1003 0.89 R1 23 1003 0.59 R2 24 2444 0.32 R1 23 2444 0.84 R2 24 1003 1.14 R3 13 1003 0.79 R1 23 1003 0.12 R1 16 WITHOUT using ANY LOOPS (or ADO/SQL), I would like to retrieve the lowest value for B , where A = 1003 and C = R1 and D = 23 (affectively criteria from the first row). In this case the answer should be B=0.79. Does anybody know a way that this can be done!? (it would have to work assuming that there were 4000+ rows in the table) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Let's see if you can solve this. | Charts and Charting in Excel | |||
How do I solve for x? | Excel Worksheet Functions | |||
need help to solve this | Excel Discussion (Misc queries) | |||
y i cannot solve it ? | Excel Worksheet Functions | |||
I can't solve this one...can anyone help | Excel Programming |