use subtotals
--
Thanks
Suleman Peerzade


"MIK" wrote:

I have a range D1:Q25 that can have differnet numbers and the numbers can
repeat. In column A, I want to list the each number used in the range. Column
B is to show the number of times each number is used in the range. In other
words, I want to make a summary of numbers used in the range and show how
many times each number is used in the range.