Hi forum,
I have this formula (it was given to me by a member of this forum few days ago):
=IFERROR(AGGREGATE(15,6,$M$25:$W$29/ISTEXT($M$25:$W$29)/(--$M$25:$W$29>MAX(A$33:A33)),1),"")
From the sample attached, I need the 5 digits jobs to go only in the table FULL LOADS and the 4 digits jobs to go only in the table JOBS.
How can integrate a check in the formula so that it is calculated only for a string of a certain length?
Any help would be greatly appreciated!
Thank you,
Alberto
Bookmarks