| 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 Topic | Login |
Max With If Formula | Rate this: (3/5 from 1 vote) |
 | The 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 Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for MAX with IF formula in the Excel Business Solutions Directory |