Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel help
Hello,
I maintain a monthly workbook that tracks daily deposits. Some of those deposits are electronically posted (aka: 835s) and some are posted by hand. The IT dept uses a separate workbook to enter batch #s, dollar amounts, & ect. for the 835 batches. Some of the 835s are electronically deposited and some are checks. IT holds check batches until the check along with the payment detail come in. Is there a way for excel to put an X in a column of the IT dept's spreadsheet when we enter an 835 on our spreadsheet so they'll know when a check comes in and they can post that batch? Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel help
Are you asking for some way to automatically enter an X in one column if an
835 is entered in another? -- HTH RP (remove nothere from the email address if mailing direct) "grandmamashortlegs" wrote in message ... Hello, I maintain a monthly workbook that tracks daily deposits. Some of those deposits are electronically posted (aka: 835s) and some are posted by hand. The IT dept uses a separate workbook to enter batch #s, dollar amounts, & ect. for the 835 batches. Some of the 835s are electronically deposited and some are checks. IT holds check batches until the check along with the payment detail come in. Is there a way for excel to put an X in a column of the IT dept's spreadsheet when we enter an 835 on our spreadsheet so they'll know when a check comes in and they can post that batch? Thank you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel help
Thank you for answering my post, Bob. Yes...My manager wants me to come up
with a way to have something show up on the same row as a matching dollar amount on the IT department's spreadsheet when we enter an 835 on our spreadsheet. The problem I'm running into is that the 835 check could be deposited on any working day of the month. Also we put an 835 in one of 3 columns on our daily spreadsheets so I think I need to use an array. I haven't been able to get =count(if or =vlookup to work (granny's a bit rusty using those commands). Anyway, I thank you for any suggestions you can give me. "Bob Phillips" wrote: Are you asking for some way to automatically enter an X in one column if an 835 is entered in another? -- HTH RP (remove nothere from the email address if mailing direct) "grandmamashortlegs" wrote in message ... Hello, I maintain a monthly workbook that tracks daily deposits. Some of those deposits are electronically posted (aka: 835s) and some are posted by hand. The IT dept uses a separate workbook to enter batch #s, dollar amounts, & ect. for the 835 batches. Some of the 835s are electronically deposited and some are checks. IT holds check batches until the check along with the payment detail come in. Is there a way for excel to put an X in a column of the IT dept's spreadsheet when we enter an 835 on our spreadsheet so they'll know when a check comes in and they can post that batch? Thank you |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel help
You should be able to use a formula in row of
=IF(OR(A2=835,G2=835,K2=835),"X","") and copy down. Just change A2, G2, K2 to your columns. If the columns are contiguous, you could use =IF(COUNTIF(G2:I2,835)0,"X","") -- HTH RP (remove nothere from the email address if mailing direct) "grandmamashortlegs" wrote in message ... Thank you for answering my post, Bob. Yes...My manager wants me to come up with a way to have something show up on the same row as a matching dollar amount on the IT department's spreadsheet when we enter an 835 on our spreadsheet. The problem I'm running into is that the 835 check could be deposited on any working day of the month. Also we put an 835 in one of 3 columns on our daily spreadsheets so I think I need to use an array. I haven't been able to get =count(if or =vlookup to work (granny's a bit rusty using those commands). Anyway, I thank you for any suggestions you can give me. "Bob Phillips" wrote: Are you asking for some way to automatically enter an X in one column if an 835 is entered in another? -- HTH RP (remove nothere from the email address if mailing direct) "grandmamashortlegs" wrote in message ... Hello, I maintain a monthly workbook that tracks daily deposits. Some of those deposits are electronically posted (aka: 835s) and some are posted by hand. The IT dept uses a separate workbook to enter batch #s, dollar amounts, & ect. for the 835 batches. Some of the 835s are electronically deposited and some are checks. IT holds check batches until the check along with the payment detail come in. Is there a way for excel to put an X in a column of the IT dept's spreadsheet when we enter an 835 on our spreadsheet so they'll know when a check comes in and they can post that batch? Thank you |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel help
Thank you. I'll let you know how it works.
"Bob Phillips" wrote: You should be able to use a formula in row of =IF(OR(A2=835,G2=835,K2=835),"X","") and copy down. Just change A2, G2, K2 to your columns. If the columns are contiguous, you could use =IF(COUNTIF(G2:I2,835)0,"X","") -- HTH RP (remove nothere from the email address if mailing direct) "grandmamashortlegs" wrote in message ... Thank you for answering my post, Bob. Yes...My manager wants me to come up with a way to have something show up on the same row as a matching dollar amount on the IT department's spreadsheet when we enter an 835 on our spreadsheet. The problem I'm running into is that the 835 check could be deposited on any working day of the month. Also we put an 835 in one of 3 columns on our daily spreadsheets so I think I need to use an array. I haven't been able to get =count(if or =vlookup to work (granny's a bit rusty using those commands). Anyway, I thank you for any suggestions you can give me. "Bob Phillips" wrote: Are you asking for some way to automatically enter an X in one column if an 835 is entered in another? -- HTH RP (remove nothere from the email address if mailing direct) "grandmamashortlegs" wrote in message ... Hello, I maintain a monthly workbook that tracks daily deposits. Some of those deposits are electronically posted (aka: 835s) and some are posted by hand. The IT dept uses a separate workbook to enter batch #s, dollar amounts, & ect. for the 835 batches. Some of the 835s are electronically deposited and some are checks. IT holds check batches until the check along with the payment detail come in. Is there a way for excel to put an X in a column of the IT dept's spreadsheet when we enter an 835 on our spreadsheet so they'll know when a check comes in and they can post that batch? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |