Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 30th 07, 10:09 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 1
Default Grouping cells together for sorting

Is there a function or a way to group multiple cells together to behave as
the first? I don't mean merge, or just highlighting them. I want to bind the
cells together so that any function performed on the first cell will apply to
all. Specifically, the function I want to use is the sort. I have several
events sorted by date and I want to sort them chronologically with some
exceptions. I want some events that occur later in time and "technically"
should fall later in the sort to appear with the earlier (or later) events
they correspond to.

I realize there may not be a specific tool in excel to do this, but if there
is any function or way to "pre-sort" the events that need to be paired it
would save me the time of having to manually go through and separate the
cells that i don't want sorted. Thanks for the help!

  #2   Report Post  
Old December 30th 07, 11:11 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 396
Default Grouping cells together for sorting

Hi

just an idea.

You could a helper column (you can hide it if needed), and store the same
number for rows that need to be together. Then, that column would also be
used when sorting.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Ouroboros" wrote:

Is there a function or a way to group multiple cells together to behave as
the first? I don't mean merge, or just highlighting them. I want to bind the
cells together so that any function performed on the first cell will apply to
all. Specifically, the function I want to use is the sort. I have several
events sorted by date and I want to sort them chronologically with some
exceptions. I want some events that occur later in time and "technically"
should fall later in the sort to appear with the earlier (or later) events
they correspond to.

I realize there may not be a specific tool in excel to do this, but if there
is any function or way to "pre-sort" the events that need to be paired it
would save me the time of having to manually go through and separate the
cells that i don't want sorted. Thanks for the help!



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
Grouping Cells / Sorting [email protected] Excel Discussion (Misc queries) 1 May 9th 07 08:50 PM
grouping and sorting data mb7q Excel Discussion (Misc queries) 0 March 30th 06 08:29 PM
Sorting while grouping 3 rows together... steve Excel Discussion (Misc queries) 5 June 23rd 05 10:39 PM
Microsoft Excel - Grouping and Sorting Cells Michael Blogg Excel Worksheet Functions 1 May 26th 05 09:27 PM
Microsoft Excel - Grouping and Sorting Cells Michael Blogg Excel Discussion (Misc queries) 1 May 26th 05 12:50 PM


All times are GMT +1. The time now is 07:27 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017