Find text in N columns and one Row
Hi,
I have the following data in a sheet : A B C D E F iglo iol iglo sapo iglo aeiou iglo mf iglo af I would like to put in "G" (for each row) column the text between Column B and Column C. Example G2 = IOL, G3= Sapo. There is only a value for each row Thanks in advance |
Find text in N columns and one Row
one way. copy down
=INDEX(2:2,0,MATCH("zzz",A2:F2)) On Nov 30, 6:00*am, Carpe Diem wrote: Hi, I have the following data in a sheet : A * * * B * * * C * * * D * * * E * * * F iglo * *iol iglo * * * * * *sapo iglo * * * * * * * * * *aeiou iglo * * * * * * * * * * * * * *mf iglo * * * * * * * * * * * * * * * * * *af I would like to put in "G" (for each row) column the text between Column B and Column C. Example G2 = IOL, G3= Sapo. *There is only a value for each row Thanks in advance |
All times are GMT +1. The time now is 10:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com