jacktc
10-16-2022, 07:12 PM
Dear experts
I have set of data download from portal, which is clumsy data i want split into two sheet with set of criteria from two columns I & J
Ist criteria :In column I:I Description have unsorted data i want select only on which data meets approximately to defined key words
key words are might be prefix or suffix or in middle
ZPAC
REDO
_RE
REDO(1)
JAP2
SCO3
GIFTS2
for e.g
CBT # 20462 CBT TRANSFER Tanjim Alam Choudhury _REDO(1)
all data move to sheet Delimited!!sheet(*data should be deleted once copy in Ledger sheet)
2nd criteria from col source J:J met with only 2 criteria filter Web Adi and Web Adi MC_MT.
all data move to sheet WEB_ADI!! Sheet (*data should be deleted once copy in Ledger sheet)
I have set of data download from portal, which is clumsy data i want split into two sheet with set of criteria from two columns I & J
Ist criteria :In column I:I Description have unsorted data i want select only on which data meets approximately to defined key words
key words are might be prefix or suffix or in middle
ZPAC
REDO
_RE
REDO(1)
JAP2
SCO3
GIFTS2
for e.g
CBT # 20462 CBT TRANSFER Tanjim Alam Choudhury _REDO(1)
all data move to sheet Delimited!!sheet(*data should be deleted once copy in Ledger sheet)
2nd criteria from col source J:J met with only 2 criteria filter Web Adi and Web Adi MC_MT.
all data move to sheet WEB_ADI!! Sheet (*data should be deleted once copy in Ledger sheet)