| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the largest number help
I have an excel spreadsheet with four columns. I have one work sheet that
needs to findest the highest dollar amount during a period of time. Example Company Date Total Credits Total Debits Company A 10/1/07 125,000 200,000 Company A 10/2/07 75,500 125,000 Company B 10/2/07 500,000 1,000 Company A 10/3/07 400,000 100,000 Company B 10/5/07 200,000 200,000 So the worksheet would first need to look for all the ones that have company A and then look for the highest number. So in this case it would have happened on 10/3/2007 (15). I would think this would involve a vlookup, but can't figure how to write it. Could someone lend some insight. Anything will help Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding largest number from list | Excel Discussion (Misc queries) | |||
| Finding the Largest Number, based on two criteria | Excel Discussion (Misc queries) | |||
| Finding the 3rd largest number in a list | Excel Worksheet Functions | |||
| finding the largest number from the last row and look up its name. | Excel Worksheet Functions | |||
| finding the second largest number in a list | Excel Discussion (Misc queries) | |||
Threaded Mode
