L Lester May 2, 2004 #1 I'm trying to count the number of instances a number appears within a range of a1:e244. The numbers range from 1-56.
I'm trying to count the number of instances a number appears within a range of a1:e244. The numbers range from 1-56.
H Harald Staff May 2, 2004 #3 Hi Lester A Pivot table will set up a count of all uniques in a second. See http://www.cpearson.com/excel/pivots.htm (They never made an Excel version 6 by the way ;-) Best wishes Harald
Hi Lester A Pivot table will set up a count of all uniques in a second. See http://www.cpearson.com/excel/pivots.htm (They never made an Excel version 6 by the way ;-) Best wishes Harald
