G
Guest
Site# Serial# No. of times repeated
205 12345 4
205 5678 5
205 54785 7
310 65432 4
310 47859 6
Could you suggest with any formula to count maximum number of times a serial
number has repeated.
For Eg:
Site # Serial#
205 54785
310 47859
In the above case, for site# 205 the maximum repeated serial# is 54785 and
for site# 310 the maximum repeated serial# 47859.
Suggest me with any formula to perform this work.
205 12345 4
205 5678 5
205 54785 7
310 65432 4
310 47859 6
Could you suggest with any formula to count maximum number of times a serial
number has repeated.
For Eg:
Site # Serial#
205 54785
310 47859
In the above case, for site# 205 the maximum repeated serial# is 54785 and
for site# 310 the maximum repeated serial# 47859.
Suggest me with any formula to perform this work.