Finding and Displaying Multiple values

[Kimmysue1]

I have a spread sheet that has about 36,000 rows of data. I am trying to sort it so that the only rows that show are the ones that have multiples of a "store #" within my store "# column". I know how get only unique numbers, but I don't know how to get rid of them....

[Kevbw]

Hi Have you tried using the filter function? Open the spreadsheet put your cursor in the data, then in the data tab click on filter, you will see dropdown arrows appear in each of the column headings. Choose the store # column click on the dropdown, you will see a list of all the store # remove the ticks from all then enter a tick on the store# you want and click Ok, this will give you a list of all sores with that number, to remove the list just press the filter button again.

hope this is of some help

[Kimmysue1]

Yes, I can do that. My problem is that I only want to display the rows that have Multiples of a particular store number in a column labeled "store numbers". For example if store number 123456 has 12 rows of data, I want to see those rows, but I don't want to see the row for store number 78910 if it only has one row of data.....