Home » Forums » Open Source Learning Center » Question and Answer

I need the formula that gives the nunber of same data

Submitted by turkmen on 13 April, 2012 - 16:29

I need the formula that gives the nunber of same data

AttachmentSize
example.xlsx11.42 KB
‹ I need to set a range of cells to copy based on a column search result for variable text. segregating data in an excel sheet ›
»
Vishesh's picture

Formula =IF(A2<>A1,COUNTIF($A

Submitted by Vishesh on 14 April, 2012 - 06:00.

Formula
=IF(A2<>A1,COUNTIF($A$2:$A$24,A2),"")

»

error

Submitted by Anonymous on 16 April, 2012 - 10:59.

hey Dr.Wish thanks for your formula but it gives error.

»
Vishesh's picture

Whats error it gives. Try

Submitted by Vishesh on 16 April, 2012 - 13:32.

Whats error it gives. Try adjusting the cell ranges it refers to.

»

I tried it on office (english

Submitted by turkmen on 17 April, 2012 - 13:55.

I tried it on office (english version) and it works thank you very much. Before I had tried it on office russian version.

»

Thank you

Submitted by turkmen on 15 April, 2012 - 10:45.

Thank you very much.

»