Geschafft!

Hinweis

Fehler

Session expiration Your session is going to expireClick here to extend

Budget:

Kleines Projekt <800

Geposted am

25.04.12 18:25

Kunde

Dan***

Dieses Projekt wurde abgeschlossen

Schreiben Sie ein ähnliches Projekt aus und erhalten Sie Angebote von Freelancern. Unverbindlich. Kostenlos. Schnell.

Jetzt ähnliches Projekt einstellen

Beschreibung:

 

I would like to have an excel macro which do the following steps:

check [column A]

- PROPER(cell) - IF cell contains the words "A", "B", "C" THEN write words replace words "a", "b", "c" - IF cell contains "a-a" THEN replace it with "-" - IF LEN (cell) <  THEN replace cell with "copy01"

check [column B]

- PROPER(cell) - IF cell in the same line in column a contains "copy01" then replace information in column B with "X" - IF cell contains "a-a" THEN replace it with "-"

check [column C]

- IF cell contains"D" replace it with "copy02" - IF cell contains "E" replace it with "copy03" - IF cell contains "F" OR cell in same line and [column A] contains "copy01" replace it with "copy04"

 

Waiting for your bids