excel help

[Guest]

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

 

[Bob Phillips]

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)

 

[Guest]

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]

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)

 

[Guest]

Thank you. I'll let you know how it works.

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)