Sorting

  • Thread starter Thread starter heather
  • Start date Start date
H

heather

I am wanting to do a group sort...i have to rows that need to stay together
when i sort, how can i do this?
 
When you sort, be sure to select all the columns you want to move with the
column you are sorting by.
 
ITEM_CD VC_CD QTY VC_CAUSE_CD
699875 0102802NTUG 1 C15
AAMRLA 0102802NTUG 29 C15
699875 0102802NTZG 1 C44
AAMRLA 0102802NTZG 15 C44
345666 0102802NUCU 1 C3
AAMRLA 0102802NUCU 30 C3
548986 0104802NWPZ 1 C1
AAMRLA 0104802NWPZ 10 C1
699875 0107802OBEX 1 C1
AAMRLA 0107802OBEX 8 C1
699875 0107802OBFA 1 C17
AAMRLA 0107802OBFA 10 C17
462083 0107802OBZY 1 C1
AAMRLA 0107802OBZY 18 C1

gary, these are my columns and rows...I would like to sort the rows but the
smallest number to the largest but keep the AAMRLA under the appropriate
number...is this possible...when i select the area to sort and sort ascending
it sorts the number and then after all numbers it sorts the aamrla's what can
I do?
 
How would I go about setting up the functionality of the helper column...I
guess I am not understanding...sorry =)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keeping Rows Together 1
link columns to sort all together 4
Cell Groupings 2
Sorting day names chronologically 5
Cells are not sorting correctly 2
Sorting a portion of a worksheet 1
Is it possible to have an image as a background? 0
keeping rows together during column sorts of linked worksheets 1

Back
Top