Hi All
Have an csv file as a source file and would like to extract dome data.
On source file look to column L and return values from columns B, E and J;
Criteria:
Always return the first value from column B,E,J (even when the alphanumeric string is the same on column B)
Ignore blanks
Ignore duplicates, unless the value on Column J changes for the same values on column L and B
Don't know explain very well so have created a mock up file (Book1)for better understanding.
Thanks in advance.
Regards
R
Have an csv file as a source file and would like to extract dome data.
On source file look to column L and return values from columns B, E and J;
Criteria:
Always return the first value from column B,E,J (even when the alphanumeric string is the same on column B)
Ignore blanks
Ignore duplicates, unless the value on Column J changes for the same values on column L and B
Don't know explain very well so have created a mock up file (Book1)for better understanding.
Thanks in advance.
Regards
R