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.

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.

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.