Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a Formula with conditions
I apologize if this is a repeat.
I am trying to compare a monetary value from one column to another column. However, I am running a worksheet with auto-filters because I have quite a bit of data including every line item from a 76 page invoice. I am trying to find the difference between different months and years. For example, I want to compare the total of one line item from July 2008 to the same line item in July 2009. But then lets say I want to be able to compare the same line item from July 2008 to July 2007. However, I want to be able to filter out everything but that one line item. I want to be able to do this for every single line item (rows) and for all and individual months(columns). I hope this makes sense. Can anyone help me write a formula? Obviously, I'm not very proficient at Excel. I have Excel 2003. Please help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a Formula with conditions
This would depend on the actual format of the file you have.
Are all dates in one line? Is every month listed across all columns? If so, sounds like you're just needing to do a quick =M1-A1 in a blank column? That would be Jan vs. Jan (assuming you started with January in column A and have one month per column). Then, you can just copy and paste along the columns to get Feb 07 vs Feb 08, March 07 to March 08, etc... "princess1_116" wrote: I apologize if this is a repeat. I am trying to compare a monetary value from one column to another column. However, I am running a worksheet with auto-filters because I have quite a bit of data including every line item from a 76 page invoice. I am trying to find the difference between different months and years. For example, I want to compare the total of one line item from July 2008 to the same line item in July 2009. But then lets say I want to be able to compare the same line item from July 2008 to July 2007. However, I want to be able to filter out everything but that one line item. I want to be able to do this for every single line item (rows) and for all and individual months(columns). I hope this makes sense. Can anyone help me write a formula? Obviously, I'm not very proficient at Excel. I have Excel 2003. Please help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a Formula with conditions
It looks something like this:
July 08 Qty Jun 08 $ July 08 Qty July 08 $ July 09 $ Difference 510008.96 $413,290.97 $493,325.71 However, what if I want to compare June 09 to June 08? If I have a formula for July, do I have to change the formula for June, etc? I want something that I don't have to change the formula every single time. I just want to enter some type of comparison critera. Is this even possible? Do I have to put a difference column after each month? Thanks for your help. Sean Timmons wrote: This would depend on the actual format of the file you have. Are all dates in one line? Is every month listed across all columns? If so, sounds like you're just needing to do a quick =M1-A1 in a blank column? That would be Jan vs. Jan (assuming you started with January in column A and have one month per column). Then, you can just copy and paste along the columns to get Feb 07 vs Feb 08, March 07 to March 08, etc... I apologize if this is a repeat. [quoted text clipped - 9 lines] this makes sense. Can anyone help me write a formula? Obviously, I'm not very proficient at Excel. I have Excel 2003. Please help! -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula with 2 conditions | Excel Discussion (Misc queries) | |||
Formula with 3 conditions | Excel Discussion (Misc queries) | |||
Need a formula to sum with conditions | Excel Worksheet Functions | |||
If formula with 12 conditions | Excel Discussion (Misc queries) | |||
Help for a formula using two conditions | Excel Worksheet Functions |