Hello all,
I need to see if someone can help me with a simple problem that I am having with my Excel spreadsheet.
I have 5 rows of numbers in my spreadsheet. In those 5 rows the numbers repeat sometimes. I want to be able to display in either a column next to my spreadsheet or a row above my spreadsheet all of the unique numbers.
So if the #12 shows up three times in my spreadsheet I only want it to be displayed in the column one time.
I have an example of what I am looking for in my attached spreadsheet. Please let me know if you need any other information. Thanks for your help.