How to select only

Closed

DG83 - Jan 6, 2012 at 04:43 AM
DG83 - Jan 6, 2012 at 07:09 AM

Hello,

this might be an easy one. If i have a long list of numbers and that list contains the same items, numbers whatever several times, how do i get excel to show only the items on this list once? Thank you so much!

How to select only
Vba select case like - Guide
How to select at the rate in laptop - Guide
How to select multiple areas in photoshop - Guide
To create a network bridge you must select at least two lan - Network Forum
Reboot and select proper boot device - Laptop Forum

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 6, 2012 at 06:49 AM

you can highlight the column
and control+F and type the string or number you want to find and click findall
you will get the cell addresses at the bottom of the find window

if you want a vba post back

DG83
Jan 6, 2012 at 07:09 AM

Thank you very much. It may not even possible to do what I am trying here. Image a long list of numbers, for example three digit numbers: 610, 624,624,640 etc the list goes on. I would want excel to display each number but only once in a different column. So for example if 624 is 250 times on this list it would only show once. I know it can be easily done with a pivot table but I thought there might be a function for this.

Similar discussions

Why can't I bridge connect?

Can't select text

How to bridge connections from laptop to pc

cannot get my home pc to bridge connections

Nfs most wanted 2005 shows "please insert the correct CD

Similar discussions

Subscribe To Our Newsletter!