find the column

[sksanjeev786]

Hi Team,

I need a column ref. as per below yellow highlighted cell

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2		2018					2019					2020					2021
3	Column	Wave 1	Wave 2	Wave 3	Wave 4		Wave 1	Wave 2	Wave 3	Wave 4		Wave 1	Wave 2	Wave 3	Wave 4		Wave 1	Wave 2	Wave 3
4		2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19
5
6
7				2020			2021
8				Wave 2	Wave 3		Wave 2	Wave 3
9				3	4		3	4
10
11		Output Need		13	14		18	19
12
13
Sheet2

Cell Formulas
Range	Formula
D9:E9,G9:H9	D9	=MATCH(D$8,$A$3:$S$3,0)

Thanks in advance
Sanjeev

 

[offthelip]

Another thought: if you have got data like post#7, then I think the only way to use it would be to ask the user what year corresponds to columns Column B and just count up from there. there would also need to be someway of determining which of the two types of data layout each sheet is. This is possible but it might be easier to process the sheets that have data as in post'7, to change them into the post#8 format, then you can process them all the same way.

 

[sksanjeev786]

with your data as shown in post#7, How are you going to tell which year each set of four waves is the one you want?? There is no year shown anywhere

Hello sir,

We are using the ETAB version so while extracting data from ETAB I am not getting the year column in excel sheet but I can able to see years on etab

so just want a column Reff.

based on post #7 if we have duplicate waves

 

[offthelip]

We are using the ETAB version so while extracting data from ETAB I am not getting the year column in excel sheet but I can able to see years on etab

so just want a column Reff.

I have no idea what this means