r1998
Board Regular
- Joined
- Sep 9, 2018
- Messages
- 106
Dear Friends and Respected Seniors,
I have this data in A1-B10
<tbody>
</tbody>
I want to find the maximum value from column B wherever column A has value 1, so in C1 I am using
with control+shift+enter
I am getting the correct answer as 40.
But if column B has any #N/A values, I get #N/A in C1, that is, if I change B8 from 33 to #N/A, I get #N/A in C1.
How can I ignore #N/A values in above formula.
Can anyone please kindly help me.
Awaiting your replies.
Thank you.
I have this data in A1-B10
1 | 28 |
2 | 20 |
3 | 80 |
3 | 70 |
2 | 65 |
1 | 40 |
2 | 88 |
1 | 33 |
3 | 41 |
2 | 58 |
<tbody>
</tbody>
I want to find the maximum value from column B wherever column A has value 1, so in C1 I am using
Code:
=MAX(IF(A:A=A1,B:B))
I am getting the correct answer as 40.
But if column B has any #N/A values, I get #N/A in C1, that is, if I change B8 from 33 to #N/A, I get #N/A in C1.
How can I ignore #N/A values in above formula.
Can anyone please kindly help me.
Awaiting your replies.
Thank you.
Last edited: