Searching rows
 

I want to be able to search a row of data and count the number of occurrence
of a similar number in that row. I won't know how many rows of data or how
many columns to search. Once a row has been checked, I want to know how many
of each of the similar items where in each row (Ex. 15 of 900, 2 of 901,
etc.).

1 A B C D E F
2 Model Scheme Car1 Car2 Car3 Car4
3 501 02 900 901 900 900
4 501 03 901 901 901 902
5 502 00 900 900 901 950
6 505 01 900 901 901 902
7 506 02 902 902 901 905

Any and all help will be greatly appreciated.

Searching rows
 

Your example shows exact matches as opposed to similar. Which do you want?


"Greg2582" wrote:

I want to be able to search a row of data and count the number of occurrence
of a similar number in that row. I won't know how many rows of data or how
many columns to search. Once a row has been checked, I want to know how many
of each of the similar items where in each row (Ex. 15 of 900, 2 of 901,
etc.).

1 A B C D E F
2 Model Scheme Car1 Car2 Car3 Car4
3 501 02 900 901 900 900
4 501 03 901 901 901 902
5 502 00 900 900 901 950
6 505 01 900 901 901 902
7 506 02 902 902 901 905

Any and all help will be greatly appreciated.

Searching rows
 

Sorry about that. I want to be able to search a row of data and count the
number of occurrence of a matches in that row. I won't know how many rows of
data or how many columns to search. Once a row has been checked, I want to
know how many of each of the items where in each row (Ex. 15 of 900, 2 of
901, etc.).

1 A B C D E F
2 Model Scheme Car1 Car2 Car3 Car4
3 501 02 900 901 900 900
4 501 03 901 901 901 902
5 502 00 900 900 901 950
6 505 01 900 901 901 902
7 506 02 902 902 901 905

Any and all help will be greatly appreciated.

"JLGWhiz" wrote:

Your example shows exact matches as opposed to similar. Which do you want?


"Greg2582" wrote:

I want to be able to search a row of data and count the number of occurrence
of a similar number in that row. I won't know how many rows of data or how
many columns to search. Once a row has been checked, I want to know how many
of each of the similar items where in each row (Ex. 15 of 900, 2 of 901,
etc.).

1 A B C D E F
2 Model Scheme Car1 Car2 Car3 Car4
3 501 02 900 901 900 900
4 501 03 901 901 901 902
5 502 00 900 900 901 950
6 505 01 900 901 901 902
7 506 02 902 902 901 905

Any and all help will be greatly appreciated.