find data in a row based on column value

[ajith]

	D	E	F	G	H	I	J	K	L
11	name	age	complaint	response	days	drug	symp	repeat	R.resp
12	Shyam	33	pain	good	2	a	ss	y	good
13	Sunil	24	fever	good	5	x	aa	n	bad
14	Aji	46	colic	good	6	f	ss	y	bad
15	Tom	34	fever	bad	2	g	dd	y	bad
16	Mathew	23	fever	good	4	c	ab	n	good
17	Sucy	17	pain	bad	6	a	ss	n	bad

<tbody>
</tbody>

sir,
Please suggest an excel formula to extract the data in the entire row of those which have "fever" in column F. ie we should paste the data in row no. 13, 15 and 16 in another table in Sheet2 having the same headings. Thank you

 

[Aladin Akyurek]

Thank you sir,
I got it. I made a mistake in row number. Ok It is perfect. Thank you

Glad to help. Thanks for the update.