sorting worksheet range

ncferro · Mar 5th, 2002, 10:41 AM

I want to find out if I can reduce the number of times I have to use the sort feature when I am trying to find all my data on a worksheet that has the same common data. My problem is that my left hand column is numerical numbers which are all different. I have 150 rows of data with the number of columns varying but normally around 15 columns. I am trying to find out which rows are the same.

IML · Mar 5th, 2002, 11:21 AM

Quote:

On 2002-03-05 09:41, ncferro wrote:
I want to find out if I can reduce the number of times I have to use the sort feature when I am trying to find all my data on a worksheet that has the same common data. My problem is that my left hand column is numerical numbers which are all different. I have 150 rows of data with the number of columns varying but normally around 15 columns. I am trying to find out which rows are the same.

If I understand you right, you could use advanced filter. Highlight all rows except the left hand one. Choose data - filter - advance filter. Check unique records only and okay. Be sure your list has headings. good luck.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 10:41 AM	#1
ncferro New Member Join Date: Mar 2002 Posts: 2	I want to find out if I can reduce the number of times I have to use the sort feature when I am trying to find all my data on a worksheet that has the same common data. My problem is that my left hand column is numerical numbers which are all different. I have 150 rows of data with the number of columns varying but normally around 15 columns. I am trying to find out which rows are the same.