Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional format columns | Excel Discussion (Misc queries) | |||
Format and Align Columns | New Users to Excel | |||
Sorting Columns to a set Format. | Excel Discussion (Misc queries) | |||
Format new Lines into Columns | Excel Worksheet Functions | |||
Compare 2 columns & format row | Excel Worksheet Functions |