Hi,
I'm am using the SMALL formula to sort an array of dates and using the IF function to name the sorted data (see the table below).
A B C D E F
1 # Job # Unsorted Dates of Payment Job # Sorted DoP
2 1 BS21 02/06/2020 BS22 01/06/2020
3 2 BS22 01/06/2020 BS21 02/06/2020
4 3 BS23 03/06/2020 BS23 03/06/2020
In the sorted DoP column I'm using the fomula:
=SMALL(C$2:C$4,A2) --> =SMALL(C$2:C$4,A4)
In the Job # column
=IF(F2=C2,B2,(IF(F2=C3,B3,(IF(F2=C4,B4,"F")))))
How can I replicate these IF functions over a much larger scale (30 rows) without just typing out an increasing length formula.
Thanks for looking.
Dexter
Bookmarks