Advertisement

11.09.2006 at 02:45PM PST, ID: 22055478
[x]
Attachment Details

Distinct Rows.

Asked by pinaldave in Microsoft Excel Spreadsheet Software

Tags: , ,

how to find distinct row in excel

I have A:1 to A:158  cells and they have values like
aa
bb
bb
cc
cd
aa
sp

I want to get only distinct values. How can I do that?
Start Free Trial
[+][-]11.09.2006 at 02:53PM PST, ID: 17910290

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Excel Spreadsheet Software
Tags: distinct, excel, values
Sign Up Now!
Solution Provided By: jeverist
Participating Experts: 2
Solution Grade: A
 
 
[+][-]11.09.2006 at 02:55PM PST, ID: 17910305

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.09.2006 at 03:21PM PST, ID: 17910472

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32