Filling in cells (or not) based on the entry in a specific collumn

[callmark1]

11:39 AM 1/24/2009

Well this is so easy a child could do it! Problem is, I don't have a child
handy.

In my spreadsheet, I have a series of values that might (or might not) repeat.

If they DO repeat, then I want a column that I can click a drop-down box or
enter "Yes" (or "No") in order to fill the remaining cells that will have the
same value (or Not).

If they do NOT repeat, I want to enter "No" and then proceed to enter
whatever values ARE necessary for the subsequent cells.

I can't remember what this type of action is called so I can't even do a
proper SEARCH in HELP. I know this will involve some sort of "if-then"
statement, but I rarely work with those and was hoping someone could shove me
in a good direction. I think it should sound something like this--

"if collumn F = 'Yes', then fill collumn G (same row) with the same value in
collumn B (same row) ... OR ... if collumn F = 'No', then do not fill
collumn G (same row) with the same value in collumn B (same row), but rather
permit me to fill in something else without restrictions"

I tried typing this in but the little dog-wizard only sneered.

Oh, I have Excel in Office 2003.

Thank you in advance for the shove. : ^ )

 

[Steven]

I am not sure that I understand your question, but this may help
If your data is in column A, then enter the following formula in
column B
=IF(COUNTIF(a:a,a1)>1,"yes","no")
and drag down

 

[callmark1]

Thank you. I am not sure that is the solution. I just realized that this
issue is very similar to a "ship-to" address vs. "bill-to" address issue. If
my data entry person types in a 'ship-to" address, it seems there should be
some way to automatically enter the same date in the event that the "bill-to"
address is the same (75% of the time) by inserting a collumn along the way
that simply asks for Same? "Yes" or "No".

Or to NOT enter the same info but rather be allowed to enter different info
when the "bill-to" address is different. I hope that clarifies and thanks
again.

 

[Fred Smith]

There are several ways of solving the problem:
1. Write a macro. It would ask "Ship to same as bill to?" If yes, then fill
in the ship to address.

2. Have the data entry person copy and paste the bill to address.

3. Create a second set of fields for the Ship to address. Use the formula:
=if(a1="yes",b1,c1)
A1 is the "Same as bill to?" response.
B1 is the Bill to address
C1 is the data entered Ship to address

Regards,
Fred.