Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 5th 05, 03:40 AM
dennis34
 
Posts: n/a
Default Get excel to list values that occur within raw data

If I enter new information into excel eg heights of individual people. How
can I get excel to look at the cells where the data is and then produce a
list of the different heights measured.

Eg heights: 162, 180, 145, 180, 123, 123, 180, 144, 145, 145

I need excel to list values that occur: 123, 144, 145, 162, 180

At this stage I'm not interested in the frequency. I just want excel to
look at my data and say these are the values that occur in the data youve
just entered.

  #2   Report Post  
Old October 5th 05, 04:42 AM
Dan
 
Posts: n/a
Default

Try to use Pivot Table. Put the required range on the right and same on the
main (grouping section). which you could have both the values and frequency.


"dennis34" wrote:

If I enter new information into excel eg heights of individual people. How
can I get excel to look at the cells where the data is and then produce a
list of the different heights measured.

Eg heights: 162, 180, 145, 180, 123, 123, 180, 144, 145, 145

I need excel to list values that occur: 123, 144, 145, 162, 180

At this stage I'm not interested in the frequency. I just want excel to
look at my data and say these are the values that occur in the data youve
just entered.

  #3   Report Post  
Old October 5th 05, 12:09 PM
Dave Peterson
 
Posts: n/a
Default

It sounds like you could use Data|Advanced filter and use the unique records
box.

Debra Dalgleish has a nice instruction page at:
http://www.contextures.com/xladvfilter01.html#FilterUR

dennis34 wrote:

If I enter new information into excel eg heights of individual people. How
can I get excel to look at the cells where the data is and then produce a
list of the different heights measured.

Eg heights: 162, 180, 145, 180, 123, 123, 180, 144, 145, 145

I need excel to list values that occur: 123, 144, 145, 162, 180

At this stage I'm not interested in the frequency. I just want excel to
look at my data and say these are the values that occur in the data youve
just entered.


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
list of all excel 2000functions R.VENKATARAMAN Excel Discussion (Misc queries) 3 June 13th 05 05:33 AM
eXceL 2003 - list or combo box question David Gerstman Excel Discussion (Misc queries) 2 May 23rd 05 03:58 PM
How do I sum rounded values from two seperate formulas in Excel? Federali Excel Worksheet Functions 1 May 3rd 05 06:01 PM
Hyperlinks from a List, Excel 2000 jacob Excel Worksheet Functions 1 April 17th 05 02:25 PM
Create a cascading list box using Excel JPB Excel Discussion (Misc queries) 1 February 24th 05 08:43 PM


All times are GMT +1. The time now is 06:57 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017