Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add numbers to a list on a conditional basis
I'm a begining excel user so my question is more or less in laymen's terms;
What I would like to do is take a number that I place in one cell and post it to a list of vertical cells in a different worksheet; as if the number was being placed one after another in a vertical fashion on another page. The list that it would be placed in would be determined by the text in an adjacent cell. Particularly I'm making accounting records and I'm using one sheet as a general journal and I want the number to post itself to the ledger account on another sheet. I want the list that it's put in to be determined by the account title that I put in a cell that is on the same horizontal axis as it. I was thinking that I could make some sort of conditional test but excel only allows for 7 nested conditions and i have about 20 so far. thanks in advance to anyone willing to help me out -Brian |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
add numbers to a list on a conditional basis
brian -
you want to do alot and you are new at this = so try and break down your requests into very small problems/issues. complicated stuff or things that take lots of steps/explaination won't get answered well for testing conditions try array formulas or sumproduct function array formula example is : =sum(if(a1:a101,a1:a10,0)) and hold down crtl-shift when you hit enter this performs the sum function on the tested array sumproduct is: = sumproduct((a1:a10="West")*1,(B1:b10="soap")*1,c1: c10) assume $ are in c1:c10. this will sum soap sales in the west region if you are not using formulas, try looking on the web for VBA examples to learn a bit or record some macros and look at them then post specific questions. best of luck - voodooJoe "brian" wrote in message ... I'm a begining excel user so my question is more or less in laymen's terms; What I would like to do is take a number that I place in one cell and post it to a list of vertical cells in a different worksheet; as if the number was being placed one after another in a vertical fashion on another page. The list that it would be placed in would be determined by the text in an adjacent cell. Particularly I'm making accounting records and I'm using one sheet as a general journal and I want the number to post itself to the ledger account on another sheet. I want the list that it's put in to be determined by the account title that I put in a cell that is on the same horizontal axis as it. I was thinking that I could make some sort of conditional test but excel only allows for 7 nested conditions and i have about 20 so far. thanks in advance to anyone willing to help me out -Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I automatically reset numbers to 0 on a daily basis? | Excel Discussion (Misc queries) | |||
Automatically create list in different sheet on basis of other lis | Excel Worksheet Functions | |||
Basis of Icon Set (conditional formatting) Excel 2007 | Excel Discussion (Misc queries) | |||
Clear Contents of Adjacent Cell on Conditional Basis | Excel Discussion (Misc queries) | |||
conditional value required on basis of column a | Excel Worksheet Functions |