Posted to microsoft.public.excel.newusers
|
|
Automate Merge
Max,
Direct Link: http://www.freefilehosting.net/download/3bed9
Let me know when you get the file.
John
"Max" wrote:
John,
.. when I insert comas.
Try it like this for the 2nd formula over there,
with semicolons replacing the commas:
In F2: =IF(AND(C2<"";E2="");D2;E2)
If the above still doesn't resolve it,
perhaps you could post a link to your sample?
You could use:
http://www.freefilehosting.net/
to upload your sample, then copy n paste the "Direct Link" generated
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"John" wrote:
Max,
You are right, there is a repeat of the phrase in col D. I tried the earlier
formula but I run into trouble ("invalid" in the formula arguments) when I
insert comas.
I know that the demo that you sent works fine the problems start when I
insert the second formula onto my spreadsheet.
John
|