User Profile
Katie_W83
Copper Contributor
Joined Aug 09, 2022
User Widgets
Recent Discussions
Formula help
Hi, I'm trying to come up with a formula to help me calculate some things. For background, I need to look at bus services running from a stop and assess the frequency within a time frame. If the service runs east and west, I need to use the most frequent. I'm using COUNTIFS to calculate the number of services in a time frame so that bit is sorted. I essentially now want the formula to look at the row with highest number of services and use that in the next part of the formula. E.g if service 1 (cell A1) has 4 buses per hour and service 2 (cell A2) has 6, to use the cell A2, leaving A1 out of the calculation. So in essence I want my formula to look at 2 cells, and use the highest number within the 2 cells for the formula, forgetting about the lowest number. Is this possible?829Views0likes1Comment
Recent Blog Articles
No content to show