Hi,
i have a set of data in excel as followes:
A B
16 12
14 1
5 3
16 43
1 14
3 5
5 3
the desired solution that i am looking to get in c and d and e is as followes:
C D E
3 5 3
14 1 2
in the above example at the top there is 3 in c1 and 5 in d1 because it has occurred 3 times in the data also their frequency is displayed in e1 as 3 because it has occurred three times and c2 is 14 and d2 is 1 because it has occurred 2 times also their frequency is displayed in e2 as 2 as it has occurred 2 times in the data.
I have also attached a workbook to receive some solutions , so hoping to receive genuine response from serious contributors.
Thanks
Bookmarks