Remember Me?

#1
October 5th 05, 03:40 AM
 dennis34 Posts: n/a
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
October 5th 05, 04:42 AM
 Dan Posts: n/a

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
October 5th 05, 12:09 PM
 Dave Peterson Posts: n/a

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

Debra Dalgleish has a nice instruction page at:

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post R.VENKATARAMAN Excel Discussion (Misc queries) 3 June 13th 05 05:33 AM David Gerstman Excel Discussion (Misc queries) 2 May 23rd 05 03:58 PM Federali Excel Worksheet Functions 1 May 3rd 05 06:01 PM jacob Excel Worksheet Functions 1 April 17th 05 02:25 PM JPB Excel Discussion (Misc queries) 1 February 24th 05 08:43 PM

All times are GMT +1. The time now is 04:24 PM.