Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
organising reciepts
When making my spending reports I have to organize lots of receipts in a
particular way. Say I have spent 80,000 in a year and I have 100 reciepts of different amounts for things I have purchased. I need to organize them in batches of 5000 each. I was thinking maybe if I enter the data for all reciepts in Excel and ask it to compile reciepts so that I get groups of reciepts that add up to 5000 or less. I am a casual user of Excel and I am not sure if Excel is able to achieve this. If it can I will appreciate if anyone can direct me in the right direction so I can make my own spreadsheet. If there is an add-in available it would be great. I will appreciate any advice or comments. Thanks very much OYK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
organising reciepts
Assuming your receipts are in column A
In B1 put =A1 In B2 put =B1+A1 and copy down In C1 put =INT(B1/5000)+1 and copy down Column C will then show you the "groups" in 5000 increments. Column A can be in any order, sorted ascending, decending, or random. Vaya con Dios, Chuck, CABGx3 "oykhan" wrote: When making my spending reports I have to organize lots of receipts in a particular way. Say I have spent 80,000 in a year and I have 100 reciepts of different amounts for things I have purchased. I need to organize them in batches of 5000 each. I was thinking maybe if I enter the data for all reciepts in Excel and ask it to compile reciepts so that I get groups of reciepts that add up to 5000 or less. I am a casual user of Excel and I am not sure if Excel is able to achieve this. If it can I will appreciate if anyone can direct me in the right direction so I can make my own spreadsheet. If there is an add-in available it would be great. I will appreciate any advice or comments. Thanks very much OYK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
organising dates in pivot table column | Excel Discussion (Misc queries) | |||
Organising Info | Excel Discussion (Misc queries) | |||
Organising Info | Excel Discussion (Misc queries) |