Looping with logic
Hi
you may also post some example data as plain text :-)
Some questions:
- you can have several rows per employee?
- is column B the only relevant column to identify if a row should
stay?
--
Regards
Frank Kabel
Frankfurt, Germany
"Patti" schrieb im Newsbeitrag
...
I need some help cleaning up an imported document. Right now, each
employee
appears numerous times, and I need to condense it to one row per
employee.
All of the information - barring one piece - already appears on one
row.
Here is what I know:
Column A: contains the employee name (already sorted)
Column B: determines the validity of the row. A lot of gibberish
(left
over from headers, page breaks, etc) is included in this report, but
the one
thing that I can rely on is that if "Bldg. A", "Bldg. B", OR "Bldg.
C"
appears in column B, then this is the row that contains most of the
employee
data and must not be deleted. I'll call this "MySaveRow".
Column E: the problem child - may or may not include data that must
be
saved. For each employee in column A, if column E of MySave row is
Null,
then I can quit looking and go to the next employee. If E is not
Null, then
I need to see if it contains "FUL", "PR4", "MGR", OR "CON" . If one
of
those is found, I would like column F of MySaveRow to be written to.
For
example, if "FUL" is found, I would like column F of MySaveRow to
say:
"Full time", if "CON" then "Consultant". If E is not Null but does
not
contain "FUL", "PR4", "MGR", OR "CON", then I need to keep checking
for
those in each row until I get to the next employee. They won't
necessarily be found.
Once I capture any required information from Column E and place the
text
remark in column F of MySaveRow, then anything that is not MySaveRow
should
be deleted.
Any help *greatly* appreciated!
Patti
|