i'm trying to get a max value based on 2 criteria.
call data sheet is the raw data source
i press Shift, ctrl, enter and get error
=MAX(IF('call data'!B2:B14=F2,IF('call data'!C2:C14=G2,'call data'!D2:D14)))
i'm trying to get a max value based on 2 criteria.
call data sheet is the raw data source
i press Shift, ctrl, enter and get error
=MAX(IF('call data'!B2:B14=F2,IF('call data'!C2:C14=G2,'call data'!D2:D14)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks