I have 3000 tables as in this example:
IneedtomergethemintooneandI'musingthecommand:
=ÍNDICE(TXT!$B$1:$B$200,CORRESP(MAIOR(SE(TXT!$A$1:$A$200="Last Name:",TXT!$B$1:$B$200,""),1),TXT!$B$1:$B$200,0))
The problem is that it just shows me the following:
Is this command best suited for this case? If so, what am I doing wrong?
PS: I just need the data marked on csv sheet
If the ranges are regular, you can do the following:
Create an auxiliary column in the CSV tab with title "line" in A2
in A3 fill in with number 8, which is the first line of the TXT tab
in A4 fill in =A3+15
the formula of cell 'B3' will become =índice(txt!$b:$b;$A3;1)
cell formula 'C3' will become =índice(txt!$b:$b;$A3+1;1)
the formula of cell 'D3' will be =índice(txt!$b:$b;$A3+2;1)
And so on ...