formula to count the number of cells including the one which repeats itself
Good evening.
I would be very grateful if anyone could help with the below.
With regards the file attached.
you will see that column J has numerous numbers in said column.
is there a formula that will compare the first number in column J, against all the others down the column, one by one, until it finds a number that repeats itself with any of the above, it then tallys the amount of numbers in total including that which has repeated itself, and display this beside the last number that repeated itself in column K, and then carries on down the column doing the same thing over and over again until it gets to the end of the said column.
Just in case i have not explained myself properly. if you look at column K, in the attached file maybe it is self explanatory what i would like to do.
any help is greatly appreciated.
many thanks all
Terence MARTINEZ
Good evening. I would be very grateful if anyone could help with the below. With regards the file attached. you will see that column J has numerous numbers in said column. is there a formula that will compare the first number in column J, against all the others down the column, one by one, until it finds a number that repeats itself with any of the above, it then tallys the amount of numbers in total including that which has repeated itself, and display this beside the last number that repeated itself in column K, and then carries on down the column doing the same thing over and over again until it gets to the end of the said column. Just in case i have not explained myself properly. if you look at column K, in the attached file maybe it is self explanatory what i would like to do. any help is greatly appreciated. many thanks all Terence MARTINEZ Read More