Crappy Hunter College computers!! This thing is soooo sloooow; it froze and
somehow posted to the wrong discussion!!

Anyway..........the easiest way would be to use a Pivot Table. It would
take about 5-10 seconds to get the results you want. See this link for info:
http://www.cpearson.com/excel/pivots.htm

Place all your date elements in the Row field. Double-click each field (at
the top of the Row) and choose Subtotals None Ok. If it doesn't work
for you at first, try a couple times. I know it works. it is a little
tricky the first couple times you deal with it though...

Regards,
Ryan---


--
RyGuy


"New2This" wrote:

I have a spreadsheet that is generated via a C# program. In the spreadsheet,
for example, column A will contain unit numbers. Each unit may have several
products associated with it. So for example the spreadsheet will look like
this.

Unit # Team Leader Product Manufacturer
258 John Smith SONY
258 John Smith LG
258 John Smith MITSUBISHI
659 Chris Jones MAYTAG
659 Chris Jones KENMORE
659 Chris Jones AMANA
659 Chris Jones GE
8241 Sean White MOTOROLA
8241 Sean White SAMSUNG
8241 Sean White LG
8241 Sean White NOKIA

My problem is that I am trying to merge a range of cells. I only want one
unit number to show up and one team leader. So the spreadsheet would look
like this instead......Can someone give me some pointers? Thanks!

Unit # Team Leader Product Manufacturer
258 John Smith SONY
LG
MITSUBISHI
659 Chris Jones MAYTAG
KENMORE
AMANA
GE
8241 Sean White MOTOROLA
SAMSUNG
LG
NOKIA