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.