Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with logic or Vlookup formula
I am relatively new to excel and need help with creating a formula.
Based on the table below my goal is to take information from column A (or a range of cells), and return a min from column C and a max from column D. For code 10060, I need the initials in column B to return when the min in column C has been located (for each code in column A) and the min amount For the same code 10060 I need the initials in column B to return when the max in column D has been located (for each code in column A) and the max amount The results for code 10060 should read 10060 cc 113 185 I.e. A B C D 10060 CC 113 164 TS 156 185 10180 CC 327 275 TS 327 327 11041 CC 79 79 TS 60 106 11042 CC 106 106 TS 122 149 11043 CC 357 357 TS 424 424 13133 PS 50 50 TS 247 248 Thanks, Andrea |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the color of a cell in a logic formula | Excel Discussion (Misc queries) | |||
Logic Formula | Excel Worksheet Functions | |||
Array Formula Using Max Match Logic | Excel Discussion (Misc queries) | |||
Logic formula using Time | Excel Discussion (Misc queries) | |||
Need help setting up a formula using perhaps the logic functions . | Excel Worksheet Functions |