I have a list of sites I have visited, is there a formula to count the number of times each name appears?
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!
I have a list of sites I have visited, is there a formula to count the number of times each name appears?
Show us a sample file with some sample data and then show a mocked up solution of what you want to see. 8-10 records should suffice. Do not load a picture as we cannot manipulate data in a picture.
Show us sample file . Then i see either it is possible or not.
I have a list of sites I have visited, is there a formula to count the number of times each name appears?
Hello,
With your list located in column A ... place this formula in cell B2 =COUNTIF($A$2:$A$45,A2) ... and copy down
Hope this will help
Don’t have an account yet? Register yourself now and be a part of our community!