Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 33
Default Format the columns 30 - 60 - 90 -120

Wouldn't ya know after I built all of this the stupid columns are coming out
as: 120, 120, 30, 60, 90
I need for them to look this way: 30, 60, 90, 120,120

I know i've seen a post around here about this but I just couldn't find it
again.

Joe

PS anybody seen a good course online for advanced pivot table training. I
already did the Microsoft one.

Joe

"Anna Wood" wrote:

I need to add values in different columns of data based on due dates.

Categories of data include:
Current Due Date (say, 2/1/09)
Grace Days (i.e., 5 days)
Current Payment Amount
Jan Due Date (1/1/09)
Jan Payment Amount
Dec Due Date (12/1/08)
Dec Amount

The current payment amount falls into a "Within Grace Days" column if it is
within 5 days of the current due date. I need to lump amounts due for "1-30
Days", "31 to 60 Days", etc. based on the amounts and when the payments were
due.

As today's date changes, the data will need to flow into the respective
delinquency categories as it passes from 30 to 31 days, etc.

I would like to copy this formula down the page and need to use an ISNA or
ISBLANK formula (say they don't owe a Jan or Dec payment) as I don't want a
$0.00 amount in a cell - it needs to stay blank.

Your help is greatly appreciated.


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,240
Default Format the columns 30 - 60 - 90 -120

Just turn off Auto-Sort for that field and then drag them to the order you want
them.


JoeM wrote:
Wouldn't ya know after I built all of this the stupid columns are coming out
as: 120, 120, 30, 60, 90
I need for them to look this way: 30, 60, 90, 120,120

I know i've seen a post around here about this but I just couldn't find it
again.

Joe

PS anybody seen a good course online for advanced pivot table training. I
already did the Microsoft one.

Joe

"Anna Wood" wrote:

I need to add values in different columns of data based on due dates.

Categories of data include:
Current Due Date (say, 2/1/09)
Grace Days (i.e., 5 days)
Current Payment Amount
Jan Due Date (1/1/09)
Jan Payment Amount
Dec Due Date (12/1/08)
Dec Amount

The current payment amount falls into a "Within Grace Days" column if it is
within 5 days of the current due date. I need to lump amounts due for "1-30
Days", "31 to 60 Days", etc. based on the amounts and when the payments were
due.

As today's date changes, the data will need to flow into the respective
delinquency categories as it passes from 30 to 31 days, etc.

I would like to copy this formula down the page and need to use an ISNA or
ISBLANK formula (say they don't owe a Jan or Dec payment) as I don't want a
$0.00 amount in a cell - it needs to stay blank.

Your help is greatly appreciated.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 33
Default Format the columns 30 - 60 - 90 -120

I'm in a PivotTable, if that makes any difference?
Joe

"Glenn" wrote:

Just turn off Auto-Sort for that field and then drag them to the order you want
them.


JoeM wrote:
Wouldn't ya know after I built all of this the stupid columns are coming out
as: 120, 120, 30, 60, 90
I need for them to look this way: 30, 60, 90, 120,120

I know i've seen a post around here about this but I just couldn't find it
again.

Joe

PS anybody seen a good course online for advanced pivot table training. I
already did the Microsoft one.

Joe

"Anna Wood" wrote:

I need to add values in different columns of data based on due dates.

Categories of data include:
Current Due Date (say, 2/1/09)
Grace Days (i.e., 5 days)
Current Payment Amount
Jan Due Date (1/1/09)
Jan Payment Amount
Dec Due Date (12/1/08)
Dec Amount

The current payment amount falls into a "Within Grace Days" column if it is
within 5 days of the current due date. I need to lump amounts due for "1-30
Days", "31 to 60 Days", etc. based on the amounts and when the payments were
due.

As today's date changes, the data will need to flow into the respective
delinquency categories as it passes from 30 to 31 days, etc.

I would like to copy this formula down the page and need to use an ISNA or
ISBLANK formula (say they don't owe a Jan or Dec payment) as I don't want a
$0.00 amount in a cell - it needs to stay blank.

Your help is greatly appreciated.


.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,240
Default Format the columns 30 - 60 - 90 -120

I gathered that much. Did you try what I suggested?

In case you weren't sure how, right click on one of the column headers, select
"Field Settings", click on "Advanced..." and under Auto-Sort Options select
"Manual (you can drag items to rearrange them)". Click "OK" and "OK". Then
drag the columns into the order you want them.


JoeM wrote:
I'm in a PivotTable, if that makes any difference?
Joe

"Glenn" wrote:

Just turn off Auto-Sort for that field and then drag them to the order you want
them.


JoeM wrote:
Wouldn't ya know after I built all of this the stupid columns are coming out
as: 120, 120, 30, 60, 90
I need for them to look this way: 30, 60, 90, 120,120

I know i've seen a post around here about this but I just couldn't find it
again.

Joe

PS anybody seen a good course online for advanced pivot table training. I
already did the Microsoft one.

Joe

"Anna Wood" wrote:

I need to add values in different columns of data based on due dates.

Categories of data include:
Current Due Date (say, 2/1/09)
Grace Days (i.e., 5 days)
Current Payment Amount
Jan Due Date (1/1/09)
Jan Payment Amount
Dec Due Date (12/1/08)
Dec Amount

The current payment amount falls into a "Within Grace Days" column if it is
within 5 days of the current due date. I need to lump amounts due for "1-30
Days", "31 to 60 Days", etc. based on the amounts and when the payments were
due.

As today's date changes, the data will need to flow into the respective
delinquency categories as it passes from 30 to 31 days, etc.

I would like to copy this formula down the page and need to use an ISNA or
ISBLANK formula (say they don't owe a Jan or Dec payment) as I don't want a
$0.00 amount in a cell - it needs to stay blank.

Your help is greatly appreciated.

.

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 33
Default Format the columns 30 - 60 - 90 -120

You are correct and yes this did work.
Thanks
Joe

"Glenn" wrote:

I gathered that much. Did you try what I suggested?

In case you weren't sure how, right click on one of the column headers, select
"Field Settings", click on "Advanced..." and under Auto-Sort Options select
"Manual (you can drag items to rearrange them)". Click "OK" and "OK". Then
drag the columns into the order you want them.


JoeM wrote:
I'm in a PivotTable, if that makes any difference?
Joe

"Glenn" wrote:

Just turn off Auto-Sort for that field and then drag them to the order you want
them.


JoeM wrote:
Wouldn't ya know after I built all of this the stupid columns are coming out
as: 120, 120, 30, 60, 90
I need for them to look this way: 30, 60, 90, 120,120

I know i've seen a post around here about this but I just couldn't find it
again.

Joe

PS anybody seen a good course online for advanced pivot table training. I
already did the Microsoft one.

Joe

"Anna Wood" wrote:

I need to add values in different columns of data based on due dates.

Categories of data include:
Current Due Date (say, 2/1/09)
Grace Days (i.e., 5 days)
Current Payment Amount
Jan Due Date (1/1/09)
Jan Payment Amount
Dec Due Date (12/1/08)
Dec Amount

The current payment amount falls into a "Within Grace Days" column if it is
within 5 days of the current due date. I need to lump amounts due for "1-30
Days", "31 to 60 Days", etc. based on the amounts and when the payments were
due.

As today's date changes, the data will need to flow into the respective
delinquency categories as it passes from 30 to 31 days, etc.

I would like to copy this formula down the page and need to use an ISNA or
ISBLANK formula (say they don't owe a Jan or Dec payment) as I don't want a
$0.00 amount in a cell - it needs to stay blank.

Your help is greatly appreciated.
.

.



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,240
Default Format the columns 30 - 60 - 90 -120

You're welcome! Glad I could help!


JoeM wrote:
You are correct and yes this did work.
Thanks
Joe

"Glenn" wrote:

I gathered that much. Did you try what I suggested?

In case you weren't sure how, right click on one of the column headers, select
"Field Settings", click on "Advanced..." and under Auto-Sort Options select
"Manual (you can drag items to rearrange them)". Click "OK" and "OK". Then
drag the columns into the order you want them.


JoeM wrote:
I'm in a PivotTable, if that makes any difference?
Joe

"Glenn" wrote:

Just turn off Auto-Sort for that field and then drag them to the order you want
them.


JoeM wrote:
Wouldn't ya know after I built all of this the stupid columns are coming out
as: 120, 120, 30, 60, 90
I need for them to look this way: 30, 60, 90, 120,120

I know i've seen a post around here about this but I just couldn't find it
again.

Joe

PS anybody seen a good course online for advanced pivot table training. I
already did the Microsoft one.

Joe

"Anna Wood" wrote:

I need to add values in different columns of data based on due dates.

Categories of data include:
Current Due Date (say, 2/1/09)
Grace Days (i.e., 5 days)
Current Payment Amount
Jan Due Date (1/1/09)
Jan Payment Amount
Dec Due Date (12/1/08)
Dec Amount

The current payment amount falls into a "Within Grace Days" column if it is
within 5 days of the current due date. I need to lump amounts due for "1-30
Days", "31 to 60 Days", etc. based on the amounts and when the payments were
due.

As today's date changes, the data will need to flow into the respective
delinquency categories as it passes from 30 to 31 days, etc.

I would like to copy this formula down the page and need to use an ISNA or
ISBLANK formula (say they don't owe a Jan or Dec payment) as I don't want a
$0.00 amount in a cell - it needs to stay blank.

Your help is greatly appreciated.
.

.

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
conditional format columns Cerberus Excel Discussion (Misc queries) 1 August 11th 09 06:29 PM
Format and Align Columns TKM New Users to Excel 3 October 19th 06 06:06 PM
Sorting Columns to a set Format. samprince Excel Discussion (Misc queries) 1 June 12th 06 02:25 PM
Format new Lines into Columns efenili Excel Worksheet Functions 1 May 16th 06 06:09 PM
Compare 2 columns & format row moremetrics Excel Worksheet Functions 2 June 23rd 05 04:47 PM


All times are GMT +1. The time now is 10:10 AM.

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

About Us

"It's about Microsoft Excel"