| Home > Forum Home > Automating Data Analysis Tasks > Finding max value based on data that contains both text and numbers > Values split, having troubles with creating a correct formula. | Share |
Values split, having troubles with creating a correct formula.
Excel Help for Values Split, Having Troubles With Creating A Correct Formula. in Automating Data Analysis Tasks
| Forum Topic | Login |
Values Split, Having Troubles With Creating A Correct Formula. | Rate this: (3/5 from 1 vote) |
 | Thanks for your reply. I have split the values by the "-" into 3 columns. But I am still having problems with creating a formula that returns a max value based on whether a file is of type "CAR" or "NCR". How would I utilize the 3 columns to get these two different max values (one for CAR and one for NCR files). Could I use the DMAX formula? Thanks, Margret | |
| Maggy | ||
| Posted by Margretjona on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Values split, having troubles with creating a correct formula. in the Excel Business Solutions Directory |