L ladybug New Member Feb 6, 2012 #1 Please advise a formular for counting # of repeats: A column will be given and need a formula for the repeat calculation. Example: Need the repeat number of A colum -- apple (4x repeated), pear(2x repeated), mango (1x) A column apple pear apple pear apple apple mango
Please advise a formular for counting # of repeats: A column will be given and need a formula for the repeat calculation. Example: Need the repeat number of A colum -- apple (4x repeated), pear(2x repeated), mango (1x) A column apple pear apple pear apple apple mango
SirJB7 Excel Rōnin Feb 6, 2012 #2 Hi, ladybug! Tried COUNTIF function? In B1 type: =COUNTIF(A$1:A$7,A1) Copy to B2:B7. Regards!
