I NEED HELP ORGANIZING DATA BY DATE!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I HAVE CANCELLATIONS COME IN EVERYDAY W/ DIFFERENT CANCEL DATES AND i WOULD LIKE A WAY TO LIST ALL THE INFO SUCH AS NAME ADDRESS ECT. BUT ORGANIZE IT BY THE DATE ON THE CANCELATION.
 
Sort the data. Data>Sort

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Kay said:
I HAVE CANCELLATIONS COME IN EVERYDAY W/ DIFFERENT CANCEL DATES AND i
Click to expand...
WOULD LIKE A WAY TO LIST ALL THE INFO SUCH AS NAME ADDRESS ECT. BUT ORGANIZE
IT BY THE DATE ON THE CANCELATION.
 
Hi
first: please turn off your CAPS-Lock: difficult to read and considered
as shouting

Regarding your question:
You may provide some more details about your data. e.g. post some
example rows (plain text - no attachment please) and describe your
expected result

--
Regards
Frank Kabel
Frankfurt, Germany

Kay said:
I HAVE CANCELLATIONS COME IN EVERYDAY W/ DIFFERENT CANCEL DATES AND i
Click to expand...
WOULD LIKE A WAY TO LIST ALL THE INFO SUCH AS NAME ADDRESS ECT. BUT
ORGANIZE IT BY THE DATE ON THE CANCELATION.
 
Hi,

You must order the data by date in descendent order.

First you are due to locate in the first row, right under the heade
one of the first column of the data table.
Suppose that you have a data table with 3 columns, each column mus
have heading. it must not have columns or rows in blank, because th
DATA/SORT could not do it automatically. You would have to select th
range to order manually. Once the range is selected you must go to men
DATA/SORT and to select the column title you wish to order, in you
case, you must select the title corresponding to the column of dates
later it selects descendent and finally to accept. I think that that i
everything.

Note: My english is not very good.

Helma
 
Back
Top