NE2TRY THIS ARRAY FORMULA and copy towards down![]()
=MAX(SUBTOTAL(9,OFFSET(D2,0,COLUMN(D2:NB2)-COLUMN(D2),1,3)))
since it is an array formula please confirm it with Ctrl+Shift+Enter
NE2TRY THIS ARRAY FORMULA and copy towards down![]()
=MAX(SUBTOTAL(9,OFFSET(D2,0,COLUMN(D2:NB2)-COLUMN(D2),1,3)))
since it is an array formula please confirm it with Ctrl+Shift+Enter
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks