Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

Could you help in finding the solution for:

My problem is:

I have 300X100 matrix filled (in Excel Sheet) with Texts and I have find how

many times first 5 columns in 300 rows are repeated. E.g

A B C D E F G H

A B C D E I J K

M N O P Q R T Y

Here A, B, C,D, E cells are repeated 2 times/in 2 rows. Is there any way in

excel, we can do it or can you write a macro that will do it.

Please use meaningful subject lines.

Sort the rows on the first five columns

In the column after the last column used in row 2 if that is the first row of

the matrix put the following (I am assuming CW2) :

=IF((A2=A1)*(B2=B1)*(C2=C1)*(D2=D1)*(E2=E1),CW1+1,1)

Now copy that down the 300 rows

The count will increment until one of the first five cells changes.

Question:

Can (based on your example of a 300x100 'grid') the search text also be in the

same row AFTER the original text? or will it only appear once per row?

Example:

row1: ABCDELXZQABCDESN.....ABCDEOSZW

the 'ABCDE' search will find three occurances in the first data row.

I have to find out how many times this combination of cells appears in matrix.

It could be one of Fity.

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

Related Topics:

- help required regerding making hidden file
- Help required to solve one problem related to javax.swing.JTable
- Help required ( Struts Validation ) Urgently
- SMS web services required
- Required field validators for a datagrid
- unable to open word document in asp.net urgent required
- Running a program help required
- REQUIRED HELP IN MAKING EXE FILE
- awt help required
- help required in RMI
- Help required for filtering XML using DOM parser
- Help Required
- Spell Check Utility Required
- Programmer required for games project.
- Help required related to weblogic.utils.AssertionError
- Cactus tutorial required
- JAVA FAQ required
- user defined-help required
- Run Time Error 424 - Object Required
- Help required in Web to Excel
- vba listview assistance required
- require help for my doubt in excel
- Help required in Vlookup
- Report creation through VBA macro help required!
- vba listview assistance required