I have a list of words in row 3 across a number of columns. In row 4 I have a list of values in the same columns. I would like to have a function were I take the max value for a given word, something like MaxIf(A3:A7,"Old","A4:A7). Any ideas?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Need to do a MaxIf
- Thread starter yussi1870
- Start date
Juan Pablo González
MrExcel MVP
- Joined
- Feb 8, 2002
- Messages
- 11,959
I think you made a typo in the references ?yussi1870 said:
Anyway, try this array entered (As in with Control Shift Enter, not just Enter)
=MAX(IF(A3:G3="Old",A4:G4))
Upvote
0
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Care to post a small sample along with desired result(s)?
Upvote
0
Similar threads
