Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jody Mills   on Oct 12 In MS Office Category.

  
Question Answered By: Quinn Johnson   on Oct 12


I think you are confused about what is a row  and what is a column. I am also
not sure if you want all identical rows  counted or only successive ones.

Try this

In H1 put =G1+2*F1+4*E1+8*D1+16*C1+32*B1+64*A1
In I1 put =COUNTIF($H$1:$H$50,H1)

Now select both those cells and copy them down all the rows to row 50.

If you want you can hide column H

Does this give you what you want?

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on compare rows Or get search suggestion and latest updates.


Tagged: