6 Replies Latest reply on Sep 14, 2018 8:02 AM by Ankit Bansal

    How to group a bunch of phone numbers?

    Umer FAZ

      I'm trying to make a bar chart for a national hospital booking platform and need to make a table regarding how many patients had booked how may appointments have been booked. The format my boss wants it in is that he wants to see how many patients used the platform once and how many patients used the platform twice and so on and so forth. I have a spread sheet in which i have a bunch of phone numbers which are also repeated. The chart i am able to create is showing me how many appointments a certain phone number is making but if there are 12 numbers that made 6 appointments and 18 numbers that made 5 appointments, how will i be able to group numbers in accordance to how many appointments are being made?