Formula to rank invoices based on status and date

Javielin

New Member
Joined
Mar 24, 2019
Messages
1
HELLO, I ALREADY HAD SPEND TO MUCH TIME TRYING TO FIND THIS FORMULA FOR MY OWN,
SO I DECIDED TO ELEVATE THIS TO THE EXPERTS.
IM LOOKING FOR A FORMULA TO RANK INVOICES BASED ON STATUS AND DATE.

STATUSDATERANK (must Be)RANK FORMULA
PAID31-JAN-20196
PAST DUE28-FEB-20191
PAST DUE31-MAR-20192
DUE TODAY30-ABR-20193
CURRENT31-MAY-20194
CURRENT30-JUN-20195

<tbody>
</tbody>


My arguments are the followings:
IF STATUS IS "PAID" RANK MUST BE THE LAST ONE
IF STATUS IS "PAST DUE" AND CELL DATE IS THE OLDEST FROM OTHER "PAST DUE" DATES, RANK FIRST
IF STATUS IS "DUE TODAY" AND THERE IS NOT ANY OTHER "PAST DUE", RANK FIRST
IF STATUS IS "CURRENT" AND THERE IS NOT ANY OTHER "PAST DUE", AND CURRENT DATE IS OLDEST FROM OTHER CURRENT, RANK FIRST

<tbody>
</tbody>


APRECIATE ANY HELP.

<tbody>
</tbody>
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,214,907
Messages
6,122,181
Members
449,071
Latest member
cdnMech

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top