find data in a row based on column value

[ajith]

[TABLE="class: grid, width: 500, align: right"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"]J[/TD]
[TD="align: center"]K[/TD]
[TD="align: center"]L[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]name[/TD]
[TD]age[/TD]
[TD]complaint[/TD]
[TD]response[/TD]
[TD]days[/TD]
[TD]drug[/TD]
[TD]symp[/TD]
[TD]repeat[/TD]
[TD]R.resp[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD="align: center"]Shyam[/TD]
[TD="align: center"]33[/TD]
[TD="align: center"]pain[/TD]
[TD="align: center"]good[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]a[/TD]
[TD="align: center"]ss[/TD]
[TD="align: center"]y[/TD]
[TD="align: center"]good[/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: center"]Sunil[/TD]
[TD="align: center"]24[/TD]
[TD="align: center"]fever[/TD]
[TD="align: center"]good[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"]aa[/TD]
[TD="align: center"]n[/TD]
[TD="align: center"]bad[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: center"]Aji[/TD]
[TD="align: center"]46[/TD]
[TD="align: center"]colic[/TD]
[TD="align: center"]good[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]f[/TD]
[TD="align: center"]ss[/TD]
[TD="align: center"]y[/TD]
[TD="align: center"]bad[/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: center"]Tom[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]fever[/TD]
[TD="align: center"]bad[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]g[/TD]
[TD="align: center"]dd[/TD]
[TD="align: center"]y[/TD]
[TD="align: center"]bad[/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: center"]Mathew[/TD]
[TD="align: center"]23[/TD]
[TD="align: center"]fever[/TD]
[TD="align: center"]good[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]c[/TD]
[TD="align: center"]ab[/TD]
[TD="align: center"]n[/TD]
[TD="align: center"]good[/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: center"]Sucy[/TD]
[TD="align: center"]17[/TD]
[TD="align: center"]pain[/TD]
[TD="align: center"]bad[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]a[/TD]
[TD="align: center"]ss[/TD]
[TD="align: center"]n[/TD]
[TD="align: center"]bad[/TD]
[/TR]
</tbody>[/TABLE]
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.