Try
=MAX(($B$1:$B$6)*($A$1:$A$6="Desk 1"))
Enter with Ctrl+Shift+Enter#
dates in column B
If not testing for Start/end dates!
Try
=MAX(($B$1:$B$6)*($A$1:$A$6="Desk 1"))
Enter with Ctrl+Shift+Enter#
dates in column B
If not testing for Start/end dates!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks