Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I group multiple lines of excel info for easy sorting
I am putting a correspondence review in a big project. There are 7 columns:
Date, Form, From, To, , Comments, Pages. Information in some of the columns contain multiple lines. What I want to do is, I want to put the information in and finally sort them according to dates. How do I group all information for a specific correspondence so that when I sort all information will be attached to the date. Thank you. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I group multiple lines of excel info for easy sorting
Seems like you have the date in the first column.
If not, it should be Then select all cells: A2:G100 assuming your first date entry starts in A2 and is 100 rows down by 7 columns wide) select the "sort -Ascending or Descending- icon" on the toolbar ( A over Z with an arrow to it's right). HTH "ericsayang" wrote: I am putting a correspondence review in a big project. There are 7 columns: Date, Form, From, To, , Comments, Pages. Information in some of the columns contain multiple lines. What I want to do is, I want to put the information in and finally sort them according to dates. How do I group all information for a specific correspondence so that when I sort all information will be attached to the date. Thank you. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I group multiple lines of excel info for easy sorting
The only way to keep a set of data like this together is to have one column that
contains data common to all rows in that set. Col A ColB Date1 data3 data2 data1 Date2 data5 data4 data6 These rows will not stay together when sorted by date. You must enter the date on each row and sort by that column Date1 data3 Date1 data2 Date1 data1 Date2 data5 Date2 data4 Date2 data6 To fill in the blank dates, select column A and F5SpecialBlanksOK In active blank cell enter an = sign then point to the cell above and CTRL + ENTER to fill down. CopyPaste Special(in place)ValuesOKEsc to get rid of formulas. Gord Dibben MS Excel MVP On Thu, 12 Jan 2006 08:15:02 -0800, "ericsayang" wrote: I am putting a correspondence review in a big project. There are 7 columns: Date, Form, From, To, , Comments, Pages. Information in some of the columns contain multiple lines. What I want to do is, I want to put the information in and finally sort them according to dates. How do I group all information for a specific correspondence so that when I sort all information will be attached to the date. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
excel group sorting | Excel Discussion (Misc queries) | |||
Can I create a form to run off of info saved on Excel 97? | Charts and Charting in Excel | |||
Exporting from Excel to multiple XML files | Excel Discussion (Misc queries) | |||
opening multiple instances of excel | Excel Discussion (Misc queries) |