Hello,
Is there a way to count thresholds of different ID? I have spreadsheet of more than 300K.
Thank you!
COUNT Thresholds
-
- NewLounger
- Posts: 24
- Joined: 23 Nov 2018, 20:24
COUNT Thresholds
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 79561
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: COUNT Thresholds
I'd add a column to group the amounts, then create a pivot table.
See the attached demo workbook.
See the attached demo workbook.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 24
- Joined: 23 Nov 2018, 20:24
Re: COUNT Thresholds
Thank you so much Hans!!