What numbers are present?

[pontiff]

Hello again!

Imagine a spreadsheet where every cell from A1 to H200 has a number value in it. Numbers are repeated numerous times.

Is there a way of creating a new sheet which shows which numbers are present? I don't need to know how many of each number there are.

Thanks in anticipation,
Pontiff

 

[Scott Huish]

Have a look at Pivot Tables:

http://www.homeandlearn.co.uk/excel2007/excel2007s7p7.html

 

[pontiff]

Wow thats opened up a whole new world! Cheers.