Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I have some data, only the values zero and one

1 0 1 0 1 1

1 0 1 0 1 0

: ;

; :

for example number of total colums is 7 and rows is 50, if row 1 = row2 , row

3, row 4. Then 8th col of row should come the number 4 ...how can solve this

problem using excel macro... if anybody know pls help

I think he wants a number in the eighth column (immediately to the right of

the data) showing how many identical rows there are in succession immediately

prior to the row.

I think he wants this only where the following row is different from the

present row. i.e at the end of each sequence.

I would assume all the rows are filled.

There are 7 col and 50 rows , each cell contain the values zero and one

only, i want to find out how many rows are equal.. each col should contain the

value of 0 and one .

if first row can equal to the 4, 5 and 6 , (colum range is to from a1:a7).

then value a8 should contain the value 4. that means how many rows are equal.as

like i want to check row values up to 8.. I think it can done in loops. if u

can pls help me.

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?

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

Related Topics:

- Counting the rows If the next row value is same as the previous row
- Delete Part of Row and move next Row Down Up
- Move data from a column of row couplets to multiple rows of colum
- String-Split Function parameter "compare"
- .NET Compare Validator
- compare struts2 and jsf
- Compare two XML files
- Cell search & match and grab and compare from another column
- Question regarding comparing integer as text
- Comparing file lists
- compare 2 column of record
- How to compare 2 column of record with VBA
- Need to compare individual list items with fixed master list
- compare data from different worksheets
- compare data in two sheets
- compare data between 2 sheets
- Comparing Columns using VBA
- compare data in two sheets
- compare data between 2 sheets
- Comparing Columns using VBA
- Program to compare dot print before and after abrasion
- Comparing folders and files
- Merge a series of rows with the same ID reference to a single row automatically using VBA.
- Connect 4 or Four in a row help
- JTable not editable in rows/columns