I have tried all that I know to turn off the rounding up/down in this formula. Can anyone help?
=IFERROR((MATCH(TRUE,SUBTOTAL(9,OFFSET(E845:$BB845,,,,COLUMN(E845:$BB845)-COLUMN(E845)+1))>E843,0)-1),">"&COUNTA(E845:$BB845))
Thanks
I have tried all that I know to turn off the rounding up/down in this formula. Can anyone help?
=IFERROR((MATCH(TRUE,SUBTOTAL(9,OFFSET(E845:$BB845,,,,COLUMN(E845:$BB845)-COLUMN(E845)+1))>E843,0)-1),">"&COUNTA(E845:$BB845))
Thanks
Last edited by TPBC; 11-10-2015 at 04:00 PM.
Please adapt your thread title as per forum rules - Thx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks