if i avoid #N/A Error it will be effect my custom chart, so i need #N/A if data not show.It would also be a good idea to modify your formulas to avaiod the #N/A error
What formula is in Col "C"
thanks for your help , but i need it to show in same row that contain max valueI have never used this function, but I think it would look something like:
VBA Code:=AGGREGATE(4,6,$C$3:$C$9)
The '4' equates to Max
The '6' equates to Ignore errors
Try this:
=IF(ISERROR(C3),C3,IF(C3=AGGREGATE(4,6,$C$3:$C$9),C3," "))
Thanks alot Phuoc its work...Try this:
=IF(ISERROR(C3),C3,IF(C3=AGGREGATE(4,6,$C$3:$C$9),C3,"
I don't think Phuoc's formula needs the IF(ISERROR( part?Thanks alot Phuoc its work...
21 08 31.xlsm | ||||
---|---|---|---|---|
C | D | |||
3 | #N/A | #N/A | ||
4 | #N/A | #N/A | ||
5 | #N/A | #N/A | ||
6 | #N/A | #N/A | ||
7 | #N/A | #N/A | ||
8 | 125,705,758 | 125705758 | ||
9 | 49,902,855 | |||
Mark Max |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D3:D9 | D3 | =IF(C3=AGGREGATE(4,6,C$3:C$9),C3," ") |