Share via

How can I get the count of all values in an array in a list format?

Anonymous
2021-10-22T05:53:06+00:00

This is a summary of my total list of numbers. There are many more and to get them all in one single column will take ages. I want to get a list that will tell me the total number of times each number appears in the total array. for example, 8703 appears 32 times and so on. How can I do this ?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101K Reputation points Volunteer Moderator
    2021-10-22T23:52:34+00:00

    Hi,

    Share the link from where i can download your MS Excel file.

    0 comments
  2. Anonymous
    2021-10-23T03:11:57+00:00

    why would it take ages to get them all in one column? how many rows are we talking about?

    0 comments
  3. Anonymous
    2021-10-25T13:52:40+00:00

    Hi KnzEfL,

    Did you check above replies? If you still need further support, please do not hesitate to reply to me.

    Best regards,

    Jazlyn

    0 comments