Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Good Afternoon,
I currently have an aging report with the below data: 1-30 Days 31-60 Days 61 - 90 Days Sum a. -2491.02 100 368.98 -2022.04 b. -5,000 29443.04 -5,000 19,443.04 c. 10.18 5.00 28.95 44.13 d. What I require is that for the greatest absolute value to be populated in the below table which will show which period the overall sum of aging pertains to. I have used IF statements however I was unable to get this to work due to the negative amounts. 1-30 Days 31-60 Days 61 - 90 Days a. -2022.04 b. 19,443.04 c. 44.13 Please let me know if you have a solution for this. :) Leo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
creating an aging report | Excel Worksheet Functions | |||
Accounts Receivable Aging Report | Excel Discussion (Misc queries) | |||
Re-organization of data | Excel Discussion (Misc queries) | |||
Help with Aging Report | Excel Worksheet Functions | |||
30 Day Aging Report Using Conditional Formating | Excel Worksheet Functions |