Darrenbilly
Posts: 163 +2
Good afternoon, all
I have an Excel question.
I have a set of date (over 4000 cells) The format is consistent, H-00000. Each sequence is a contract number, every time it repeats it represents a terminal which a customer had, so if H-02999 appears 5 times in the list, the customer had 5 terminals. I need to calculate how many contracts had 1, 2, 3, 4, 5, 6+ terminals.
Can anyone help?
Thanks!
I have an Excel question.
I have a set of date (over 4000 cells) The format is consistent, H-00000. Each sequence is a contract number, every time it repeats it represents a terminal which a customer had, so if H-02999 appears 5 times in the list, the customer had 5 terminals. I need to calculate how many contracts had 1, 2, 3, 4, 5, 6+ terminals.
Can anyone help?
Thanks!