I have multiple sheets of timings. I would like to create a list (ascending or descending) of the times that occur in each sheet and the amount of times that each time occurs. Which is the easiest way to achieve it?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Extract timings and occurences.
- Thread starter ToxinUK1
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 92,968
- Office Version
- 365
- Platform
- Windows
Ok, how about
Excel Formula:
=LET(a,SORT(TOCOL(VSTACK('[Workbook1.xlsx]Sheet1'!B3:P24,'[Workbook2.xlsx]Sheet1'!B3:P24,'[Workbook3.xlsx]Sheet1'!B3:P24),1)),HSTACK(a,MMULT(--(a=TOROW(a)),SEQUENCE(ROWS(a),,,0))))
Upvote
0
Solution
Excel Facts
How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Similar threads
- Question
