Hi all,

I'm a beginner for Macro kind of thing. I need some help on extracting
data from large text file. The text file look like these;

C1111-1111,_M322209,step1,081022,095518,P
C1111-1111,_M322209,step2,081022,095527,P
C1111-1111,_M322209,step3,081022,095528,P
C1111-1111,_M322209,step4,081022,095531,P
C1111-1111,_M322209,step5,081022,095532,P
C1111-1111,_M322209,step6,081022,095534,P
C1111-1111,_M322209,step7,081022,095535,P
C1111-1111,_M322209,step8,081022,095537,P
C1111-1111,_M322209,step9,081022,095538,P
C1111-1111,_M322209,step10,081022,095539,P
C1111-1111,_M322209,step11,081022,095548,P
C1111-1111,_M322209,step12,081022,095551,P
C1111-1111,_M322209,step13,081022,095553,P
C1111-1111,_M322209,step14,081022,095556,P
C1111-1111,_M355509,final_step,081022,095736,P
C2222-2222,_M355509,step1,081022,095518,P
C2222-2222,_M355509,step2,081022,095527,P
C2222-2222,_M355509,step3,081022,095528,P
C2222-2222,_M355509,step4,081022,095531,P
C2222-2222,_M355509,step5,081022,095532,P
C2222-2222,_M355509,step6,081022,095534,P
C2222-2222,_M355509,step7,081022,095535,P
C2222-2222,_M355509,step8,081022,095537,P
C2222-2222,_M355509,step9,081022,095538,P
C2222-2222,_M355509,step10,081022,095539,P
C2222-2222,_M355509,step11,081022,095548,P
C2222-2222,_M355509,step12,081022,095551,P
C2222-2222,_M355509,step13,081022,095553,P
C2222-2222,_M355509,step14,081022,095556,P
C2222-2222,_M355509,final_step,081022,095736,P

This is only a complete steps of a test for 2 board. The text file
could have hundred of lines.
What I want is the last step for each board. These should do.

C1111-1111,_M355509,final_step,081022,095736,P
C2222-2222,_M355509,final_step,081022,095736,P

Any help would be appreciate.Thanks...

B1, array formula entered, (confirmed with Ctrl+Alt +Enter ) :

{=INDEX(A:A,SMALL(IF(ISNUMBER(FIND("final_step",A$ 1:A$1000)),ROW(A$1:A$1000),60000),ROWS(A$1:A1)))&" "}

Regards
Bosco

" wrote:

Hi all,

I'm a beginner for Macro kind of thing. I need some help on extracting
data from large text file. The text file look like these;

C1111-1111,_M322209,step1,081022,095518,P
C1111-1111,_M322209,step2,081022,095527,P
C1111-1111,_M322209,step3,081022,095528,P
C1111-1111,_M322209,step4,081022,095531,P
C1111-1111,_M322209,step5,081022,095532,P
C1111-1111,_M322209,step6,081022,095534,P
C1111-1111,_M322209,step7,081022,095535,P
C1111-1111,_M322209,step8,081022,095537,P
C1111-1111,_M322209,step9,081022,095538,P
C1111-1111,_M322209,step10,081022,095539,P
C1111-1111,_M322209,step11,081022,095548,P
C1111-1111,_M322209,step12,081022,095551,P
C1111-1111,_M322209,step13,081022,095553,P
C1111-1111,_M322209,step14,081022,095556,P
C1111-1111,_M355509,final_step,081022,095736,P
C2222-2222,_M355509,step1,081022,095518,P
C2222-2222,_M355509,step2,081022,095527,P
C2222-2222,_M355509,step3,081022,095528,P
C2222-2222,_M355509,step4,081022,095531,P
C2222-2222,_M355509,step5,081022,095532,P
C2222-2222,_M355509,step6,081022,095534,P
C2222-2222,_M355509,step7,081022,095535,P
C2222-2222,_M355509,step8,081022,095537,P
C2222-2222,_M355509,step9,081022,095538,P
C2222-2222,_M355509,step10,081022,095539,P
C2222-2222,_M355509,step11,081022,095548,P
C2222-2222,_M355509,step12,081022,095551,P
C2222-2222,_M355509,step13,081022,095553,P
C2222-2222,_M355509,step14,081022,095556,P
C2222-2222,_M355509,final_step,081022,095736,P

This is only a complete steps of a test for 2 board. The text file
could have hundred of lines.
What I want is the last step for each board. These should do.

C1111-1111,_M355509,final_step,081022,095736,P
C2222-2222,_M355509,final_step,081022,095736,P

Any help would be appreciate.Thanks...