Auto entry of data based on entry of text in another column or fie

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Judy Rose - 16 May 2008 19:06 GMT

I have a spreadsheet for each month of the year to track my reappointment
evaluations, each month I get a list of who is supposed to be reviewed next
month and I type it into my spreadsheet for the given month, my question is I
have a sort indicator that should read "1" in column A as soon as I enter a
value into column B for the given row. Is there any way to get the system to
do this for me automatically or do I have to continue to manually enter the
"1" on each row I use.

Thank you for any help.

Signature

Judy Rose Cohen

Reply to this Message

SSG QuarterMaster - 16 May 2008 22:01 GMT

Try this formula:

in column A1 enter: =IF(B1="","","1") if you need the "1" to be a number
then disregard the quotes aronud the 1. and replace the cell references with
the appropriate references.

> I have a spreadsheet for each month of the year to track my reappointment
> evaluations, each month I get a list of who is supposed to be reviewed next
[quoted text clipped - 5 lines]
>
> Thank you for any help.

Reply to this Message

Judy Rose - 21 May 2008 13:14 GMT

Thank you, I figured it was an If statement, but couldn't figure out the
exact way to phrase the B1 information. You have been very helpful.

Signature

Judy Rose Cohen

> Try this formula:
>
[quoted text clipped - 11 lines]
> >
> > Thank you for any help.

Reply to this Message