Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced use of LARGE function
I've looked through all the posts I could find back to 2005 and couldn't find
the exact answer to my question. Setup: I have created a VB form which populates a hidden data sheet. Column A is account numbers - each unique Column B is a Vendor name NOT UNIQUE Problem: I need to use the LARGE function to find the LAST number given to each of the vendors So what I think I'm looking for is a nested IF statement in a LARGE or the other way around. Not quiet sure though how to formulate this. Thanks in advance I know you all always come up with the answer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numerical integration | Excel Discussion (Misc queries) | |||
Custom function | Excel Worksheet Functions | |||
Large function | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Help on Large Function | Excel Worksheet Functions |