Home > Forum Home > Automating Data Analysis Tasks > Finding max value based on data that contains both text and numbers > MAX with IF formula Share

MAX with IF formula

Excel Help for Max With If Formula in Automating Data Analysis Tasks

Forum TopicLogin

Max With If Formula

Rate this:
(3/5 from 1 vote)
FedupThe DMAX will not work with multiple column criteria. The best option is to use a combination of MAX and IF in an array formula. A detailed example of this can be found here.
 Excel Business Forums Administrator
 Posted by on
View Full Post

Find relevant Excel templates and add-ins for MAX with IF formula in the