Hi,
Bit of an odd request that I have not been able to solve.
Using a simplified example as an easier way of explaining the problem:
I have a visitor log that has the times in which someone enters and exits. I would like to find the highest number of visitors in the building throughout the day.
I am not looking for a timeframe that there are the most visitors, but rather the highest number of visitors in the building.
Can this be done in anyway?
Many Thanks
Last edited by callumt683; 08-23-2021 at 08:16 AM.
There are instructions at the top of the page explaining how to attach your sample workbook.
assuming a version prior to O365 and your sample file, you might try something like:
this isn't particularly efficient though - as it's performing 1440 COUNTIFS, one for each minute of the day -- you could streamline a little, by isolating MIN & MAX, e.g.:Formula:
Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Pl see file.
This works
=AGGREGATE(14,6,COUNTIFS($B$2:$B$7,"<="&$C$2:$C$7,$C$2:$C$7,">="&$B$2:$B$7),1)
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks