Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cycle through list and put data found in col a into col d
sorry about the confusing subject title.
col a col b col c col d account # debit account # credit journal reference i want the journal reference to appear in col d rows 1 and 2. currently, col d is empty. the rows do not always follow the pattern row 1 debit, row 2 credit. you can have 4 rows of debit and one row of credit thank you in advance for your help. -- aprilshowers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cycle through list and put data found in col a into col d
You can do it without a macro...
Add this formula to cell D2 and copy down... =IF(SUM(B2:C2)=0, A2,D3) If you need to remove the reference lines that can be done... -- HTH... Jim Thomlinson "april" wrote: sorry about the confusing subject title. col a col b col c col d account # debit account # credit journal reference i want the journal reference to appear in col d rows 1 and 2. currently, col d is empty. the rows do not always follow the pattern row 1 debit, row 2 credit. you can have 4 rows of debit and one row of credit thank you in advance for your help. -- aprilshowers |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cycle through list and put data found in col a into col d
Thanks, Jim but this doesn't work. i don't think that i explained myself
very well. i'll give this another try. Col A Col B Col C Col D Row 2 Food 96173 Row3 Cash 96173 Row 4 Ch. No. :003990 i want to put the desc found in Row 4, Col A in Rows 2 and 3 of column D. the pattern is not always 2 rows. there could be 5 rows of debits and 1 row of credits. thank you in advance for your help-- aprilshowers "Jim Thomlinson" wrote: You can do it without a macro... Add this formula to cell D2 and copy down... =IF(SUM(B2:C2)=0, A2,D3) If you need to remove the reference lines that can be done... -- HTH... Jim Thomlinson "april" wrote: sorry about the confusing subject title. col a col b col c col d account # debit account # credit journal reference i want the journal reference to appear in col d rows 1 and 2. currently, col d is empty. the rows do not always follow the pattern row 1 debit, row 2 credit. you can have 4 rows of debit and one row of credit thank you in advance for your help. -- aprilshowers |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
cycle through list and put data found in col a into col d
I must be missing something because that is what my formula is doing. With
your source data and a bit more of my own I get: Food 96173 Ch. No. :003990 Cash 96173 Ch. No. :003990 Ch. No. :003990 Ch. No. :003990 This 12345 asdf That 12345 asdf Other 12345 asdf asdf asdf Perhaps you could show me what the output is supposed to look like if not that. -- HTH... Jim Thomlinson "april" wrote: Thanks, Jim but this doesn't work. i don't think that i explained myself very well. i'll give this another try. Col A Col B Col C Col D Row 2 Food 96173 Row3 Cash 96173 Row 4 Ch. No. :003990 i want to put the desc found in Row 4, Col A in Rows 2 and 3 of column D. the pattern is not always 2 rows. there could be 5 rows of debits and 1 row of credits. thank you in advance for your help-- aprilshowers "Jim Thomlinson" wrote: You can do it without a macro... Add this formula to cell D2 and copy down... =IF(SUM(B2:C2)=0, A2,D3) If you need to remove the reference lines that can be done... -- HTH... Jim Thomlinson "april" wrote: sorry about the confusing subject title. col a col b col c col d account # debit account # credit journal reference i want the journal reference to appear in col d rows 1 and 2. currently, col d is empty. the rows do not always follow the pattern row 1 debit, row 2 credit. you can have 4 rows of debit and one row of credit thank you in advance for your help. -- aprilshowers |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
cycle through list and put data found in col a into col d
My apologies, Jim. this works like a charm. makes me feel foolish for
spending so much time trying to work out a macro. just one more thing... how do i get rid of those reference lines? thanks for all your help. by the way, do you know why i don't receive emails notifying me of replies even though i have that box checked? -- aprilshowers "Jim Thomlinson" wrote: I must be missing something because that is what my formula is doing. With your source data and a bit more of my own I get: Food 96173 Ch. No. :003990 Cash 96173 Ch. No. :003990 Ch. No. :003990 Ch. No. :003990 This 12345 asdf That 12345 asdf Other 12345 asdf asdf asdf Perhaps you could show me what the output is supposed to look like if not that. -- HTH... Jim Thomlinson "april" wrote: Thanks, Jim but this doesn't work. i don't think that i explained myself very well. i'll give this another try. Col A Col B Col C Col D Row 2 Food 96173 Row3 Cash 96173 Row 4 Ch. No. :003990 i want to put the desc found in Row 4, Col A in Rows 2 and 3 of column D. the pattern is not always 2 rows. there could be 5 rows of debits and 1 row of credits. thank you in advance for your help-- aprilshowers "Jim Thomlinson" wrote: You can do it without a macro... Add this formula to cell D2 and copy down... =IF(SUM(B2:C2)=0, A2,D3) If you need to remove the reference lines that can be done... -- HTH... Jim Thomlinson "april" wrote: sorry about the confusing subject title. col a col b col c col d account # debit account # credit journal reference i want the journal reference to appear in col d rows 1 and 2. currently, col d is empty. the rows do not always follow the pattern row 1 debit, row 2 credit. you can have 4 rows of debit and one row of credit thank you in advance for your help. -- aprilshowers |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
cycle through list and put data found in col a into col d
i think that i figured out how to get rid of the reference. copy/paste
values ccol d. the go to col e =if(sum(b2:c2)<0,d2," ") -- aprilshowers "Jim Thomlinson" wrote: I must be missing something because that is what my formula is doing. With your source data and a bit more of my own I get: Food 96173 Ch. No. :003990 Cash 96173 Ch. No. :003990 Ch. No. :003990 Ch. No. :003990 This 12345 asdf That 12345 asdf Other 12345 asdf asdf asdf Perhaps you could show me what the output is supposed to look like if not that. -- HTH... Jim Thomlinson "april" wrote: Thanks, Jim but this doesn't work. i don't think that i explained myself very well. i'll give this another try. Col A Col B Col C Col D Row 2 Food 96173 Row3 Cash 96173 Row 4 Ch. No. :003990 i want to put the desc found in Row 4, Col A in Rows 2 and 3 of column D. the pattern is not always 2 rows. there could be 5 rows of debits and 1 row of credits. thank you in advance for your help-- aprilshowers "Jim Thomlinson" wrote: You can do it without a macro... Add this formula to cell D2 and copy down... =IF(SUM(B2:C2)=0, A2,D3) If you need to remove the reference lines that can be done... -- HTH... Jim Thomlinson "april" wrote: sorry about the confusing subject title. col a col b col c col d account # debit account # credit journal reference i want the journal reference to appear in col d rows 1 and 2. currently, col d is empty. the rows do not always follow the pattern row 1 debit, row 2 credit. you can have 4 rows of debit and one row of credit thank you in advance for your help. -- aprilshowers |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
cycle through list and put data found in col a into col d
That is it...
-- HTH... Jim Thomlinson "april" wrote: i think that i figured out how to get rid of the reference. copy/paste values ccol d. the go to col e =if(sum(b2:c2)<0,d2," ") -- aprilshowers "Jim Thomlinson" wrote: I must be missing something because that is what my formula is doing. With your source data and a bit more of my own I get: Food 96173 Ch. No. :003990 Cash 96173 Ch. No. :003990 Ch. No. :003990 Ch. No. :003990 This 12345 asdf That 12345 asdf Other 12345 asdf asdf asdf Perhaps you could show me what the output is supposed to look like if not that. -- HTH... Jim Thomlinson "april" wrote: Thanks, Jim but this doesn't work. i don't think that i explained myself very well. i'll give this another try. Col A Col B Col C Col D Row 2 Food 96173 Row3 Cash 96173 Row 4 Ch. No. :003990 i want to put the desc found in Row 4, Col A in Rows 2 and 3 of column D. the pattern is not always 2 rows. there could be 5 rows of debits and 1 row of credits. thank you in advance for your help-- aprilshowers "Jim Thomlinson" wrote: You can do it without a macro... Add this formula to cell D2 and copy down... =IF(SUM(B2:C2)=0, A2,D3) If you need to remove the reference lines that can be done... -- HTH... Jim Thomlinson "april" wrote: sorry about the confusing subject title. col a col b col c col d account # debit account # credit journal reference i want the journal reference to appear in col d rows 1 and 2. currently, col d is empty. the rows do not always follow the pattern row 1 debit, row 2 credit. you can have 4 rows of debit and one row of credit thank you in advance for your help. -- aprilshowers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a graph with 2-cycle X 3-cycle log-log graph paper? | Charts and Charting in Excel | |||
Excell Dropdown List. Display alternate text than found in list. | Excel Discussion (Misc queries) | |||
excel 2007, how to select a data point and cycle through data points | Charts and Charting in Excel | |||
lookup a value from a list excluding a previously found value | Excel Worksheet Functions | |||
How do I keep result from 1 iteration cycle to use in next cycle? | Excel Discussion (Misc queries) |