need help mga master
pano ko po mafi filter yung latest version from column A ang result na gusto ko po yung sa column B.
naka attached po yung file ko.
thanks in advance po
Column A Column B
DDD-01050-00K
DDD-01050-01K DDD-01050-01K
DDD-01050-01
DDD-01050-02 DDD-01050-02
DDD-01410-01Z
DDD-01410-02Z
DDD-01410-03 DDD-01410-03
DDD-01412-01S
DDD-01412-02S
DDD-01412-03 DDD-01412-03
DDD-03000-01X
DDD-03000-02 DDD-03000-02
DDD-04594-00L
DDD-04594-01 DDD-04594-01
DDD-05188-01
DDD-05188-02 DDD-05188-02
DDD-05189PZ-00
DDD-05189PZ-01
DDD-05189PZ-02
DDD-05189PZ-03
DDD-05189PZ-04
DDD-05189PZ-05
DDD-05189PZ-06
DDD-05189PZ-07 DDD-05189PZ-07
DDD-05190CZ-00
DDD-05190CZ-01 DDD-05190CZ-01
DDD-05191CZ-00
DDD-05191CZ-01
DDD-05191PZ-02 DDD-05191PZ-02
DDD-05194-02
DDD-05194-03 DDD-05194-03
DDD-05196-00
DDD-05196-01
DDD-05196-02 DDD-05196-02
Gandang umaga po sa lahat...Up ko lang po sana may makatulong. thanks
ang hirap kung pagbabasehan lang yung sample mo
ano mga criteria ng naming?
paano mo masasabi na ibang sequence na yung bagong entry mo against sa nauna?
kung makakagawa ka sana ng simpleng logical reasoning ng name1 =! name2 or name1+1 or something similar para may pagbasehan ng formula