Nested If Statements , Help needed urgently

[Bill]

Please help,
I have a csv file produced via a website that I need to
format for a database import.
The required address fields are not populated in the
correct sequence for the import.
Add1(C) Always Populated Required Field
Add2(D) Always Populated
Add3(E) Sometimes Populated
Add4 F) Sometimes Populated Required Field
Pcode (G)
The problem is that Columns D and E sometimes contain
data that is required for Column F and that column
sometimes contains the information required for Column G
The nested if statement I've produced looks like this
=If(F2="",If(E2="",D2,E2))
What I am trying to do is to populate F2 if blank with
either E2 or D2 but when I paste special the value of
F2 ends up as false if F2 is populated.

Also, I can't figure out how to delete the duplicated
information


I hope that this isn't to much detail

I would really be grateful for any assistance

Thanks

Bill

 

[Frank Kabel]

Hi Bill
if I understood you correctly you want a formula in column F. But
currently column F contains some data?. If this is True, this is not
possible with formulas. Use the following formula in a helper column
first:
=If(F2="",If(E2="",D2,E2),F2)

After this use 'Patse Special' to copy these data to column F

 

[Bill]

I understand it better now, thank you

Is there a way of deleting the duplicated information
F2 will end up with data currently in either D or E2 ?

Thanks

Bill

 

[Frank Kabel]

Hi Bill
not quite sure what duplicated data you mean? Could you give an
example?

 

[Bill]

Thanks for the help

The data now in F2 (Required Field) Add4 is the same
data as in either E2 or D2 depending upon which cell
was populated. I need to delete the duplicated entry
in either the E2 or D2 cell.

I have tried variations on the if function
to get a result of blanking the duplicated cell
but no joy so far

Thanks again for taking the time to help me

Bill

 

[gls858]

I understand it better now, thank you

Is there a way of deleting the duplicated information
F2 will end up with data currently in either D or E2 ?

Thanks

Bill





column F. But


this is not


helper column


column F

See if this helps
http://www.cpearson.com/excel/duplicat.htm
gls858

 

[Frank Kabel]

Hi
not possible with functions. This would require VBA

 

[Bill]

Thank You

Bill

-----Original Message-----
Hi
not possible with functions. This would require VBA

--
Regards
Frank Kabel
Frankfurt, Germany


.