S
Srinivasulu B
I have a label work which will be finally imposed (mail merge method) in
Corel DRAW, an illustration software.
The data is available as an Excel sheet.
Each label contains ONLY four lines (Col A, Col B, Col C, Col D)
I have to reposition these fields in columns E,F,G and H based on the
number of empty fields.
For this I have used =CountA(range) function and put the same in Col I
Beyond this I am hitting blank walls.
The requirement is as under.
If the record (row) has ALL the fields populated, then E1,F1,G1 and H1
should be be replaced with A1, B1, C1 and D1 respectively..
If the record has only three fields populated, then E1,F1, and G1 should be
replaced with A1, B1, and C1 (D1 will be empty any way) respectively
If the record has only two fields populated, then F1 and G1, should be
replaced with A1 and B1, respectively.
If the record has only one field populated, then F1 should be replaced with
A1.
For this I need formulas for Columns E,F,G and H which will be copied down
to all records(rows).
After this..I might have to do the following things manually.
1. Delete all the raw data and Column I (which has , =CountA results).
2. Delete all records with contains even number of fields.
3. Then I will be left with a spread sheet with data in a pyramid like
structure.
I will do similar operation for odd number of fields.
These two files after saving as a CSV file, will be used as input files for
PrintMerge operations of Corel DRAW
I tried to do using nested If's ...but did not work...results were
disastrous.
Presently I am doing it manually...but when the volume goes to 200 labels
and above...I am feeling insecure.
Hence this request
Can any one help ?
If a sample sheet indicating raw data and processed data is required as a
sample, I can send off the list.
seena
Corel DRAW, an illustration software.
The data is available as an Excel sheet.
Each label contains ONLY four lines (Col A, Col B, Col C, Col D)
I have to reposition these fields in columns E,F,G and H based on the
number of empty fields.
For this I have used =CountA(range) function and put the same in Col I
Beyond this I am hitting blank walls.
The requirement is as under.
If the record (row) has ALL the fields populated, then E1,F1,G1 and H1
should be be replaced with A1, B1, C1 and D1 respectively..
If the record has only three fields populated, then E1,F1, and G1 should be
replaced with A1, B1, and C1 (D1 will be empty any way) respectively
If the record has only two fields populated, then F1 and G1, should be
replaced with A1 and B1, respectively.
If the record has only one field populated, then F1 should be replaced with
A1.
For this I need formulas for Columns E,F,G and H which will be copied down
to all records(rows).
After this..I might have to do the following things manually.
1. Delete all the raw data and Column I (which has , =CountA results).
2. Delete all records with contains even number of fields.
3. Then I will be left with a spread sheet with data in a pyramid like
structure.
I will do similar operation for odd number of fields.
These two files after saving as a CSV file, will be used as input files for
PrintMerge operations of Corel DRAW
I tried to do using nested If's ...but did not work...results were
disastrous.
Presently I am doing it manually...but when the volume goes to 200 labels
and above...I am feeling insecure.
Hence this request
Can any one help ?
If a sample sheet indicating raw data and processed data is required as a
sample, I can send off the list.
seena