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>
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