Looking for a max if formula to find the max value if a cell contains certain text. In the example below I'd like cells C and D to return the max.
A B C D
47-3 4,000 Max of column B if column A contains "47" Max of column B if column A contains "43"
47-1 3,000 4,000 3,000
43-2 3,000
43-1 2,000
47-2 2,000
47-2 1,000
43-3 1,000
43-3 500
I've tried this formula but it doesn't seem to work.
{=MAX(IF(A2:A8="*47*",B2:B8,))}
Bookmarks