| Home > Forum Home > Automating Data Analysis Tasks > Finding max value based on data that contains both text and numbers > Split values to use MAX function | Share |
Split values to use MAX function
Excel Help for Split Values To Use Max Function in Automating Data Analysis Tasks
| Forum Topic | Login |
Split Values To Use Max Function | Rate this: (3/5 from 1 vote) |
 | The easiest solution would be to split the values by the "-" character so that the MAX function can be used on the part required. To do this, you can use the Text to Columns functionality and choose the "-" as the separator. Otherwise FIND, LEFT, RIGHT and IF functions can be used in combination within a somewhat complex formula. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Split values to use MAX function in the Excel Business Solutions Directory |