Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To delete paired numbers or pickup last cell for each item
Following is the extract from sage detailed Balance sheet. The actual closing
balance is normally the last line for each item (eg 2219.53 this month for Plant & £56057.77 YTD for Furniture). I am trying to prepare a summary showing end balance for each of items on BS (using commonly used Balance sheet format) €“ Cant use €˜sumif for obvious reasons and unsure how to have the correct balances for each of balance sheet accounts. Please note the earliers numbers are forming pairs and I can have a summary report by deleting paired numbers and only by picking the last number in each column for each item - or - I can delete paired numbers then do sumif forumula to pickup on separate tab. Please advise Month YTD Plant 2106036.08 Plant 2106036.08 Plant 626802.03 Plant 626802.03 Plant 2219.53 3401264.68 Plant 2219.53 3401264.68 Plant 2219.53 1593188.38 Plant 2219.53 1593188.38 Plant 2219.53 2008859.05 Furniture 1897.42 Furniture 1897.42 Furniture 20429.51 Furniture 20429.51 Furniture 8129.76 Furniture Furniture 23500 75510.52 Furniture 23500 75510.52 Furniture 23500 56057.77 Many thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup (pickup the last row... | Excel Worksheet Functions | |||
how to delete 1 item in colum | Excel Discussion (Misc queries) | |||
Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
How do I delete a character from a list of item numbers? | Excel Worksheet Functions | |||
pickup cell value according another cell value | Excel Worksheet Functions |