Google Spreadsheet Post #1713
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jul-29-2014
post by Alan Brito:
(https://productforums.google.com/forum/#!mydiscussions/docs/C3JDc6x8zXk)
Formula to seek repeated values
hi, i want to make a formula to seek repepated values on a single column, and anotate them on another one as a counter.
for example.
on a column, i want to know how many times Each name is repeated, and make another column called "counter" wich contains the total number of the value repetitions, im doing this to count bans. For example:
Column A Column B (Counter)
asd 1
asd 2
dea 1
ad 1
asd 3
is it posible to do that? that a formula automatically detects the number of repetitions and continues adding them?
would be thankfull for an answer
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jul-29-2014
post by Alan Brito:
(https://productforums.google.com/forum/#!mydiscussions/docs/C3JDc6x8zXk)
Formula to seek repeated values
hi, i want to make a formula to seek repepated values on a single column, and anotate them on another one as a counter.
for example.
on a column, i want to know how many times Each name is repeated, and make another column called "counter" wich contains the total number of the value repetitions, im doing this to count bans. For example:
Column A Column B (Counter)
asd 1
asd 2
dea 1
ad 1
asd 3
is it posible to do that? that a formula automatically detects the number of repetitions and continues adding them?
would be thankfull for an answer
-------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment