Getting the MAX value from a list of values in a single cell

[antedenise]

I am trying to identify the greatest value in a list of values in a single cell. For example, cell has 1,2,3,4. I would like to identify the greatest (or least) value in that cell. Can this be done?

Thank you!!

-denise

[stanleydgromjr]

antedenise,

Can we see examples of your raw data?

Please attach your workbook or a sample workbook that accurately portrays your current workbook on one sheet, and what it should look like 'After' on another sheet. This makes it much easier to see exactly what you want to do, as well as shows us whether there is a consistent number of rows between tables and such.

Click on the New Post button, then scroll down and see Manage Attachments.

[6StringJazzer]

Also would be helpful to know if there are always the same number of numbers in the list, or if it varies, and whether the values are sorted or in random order.

When you have a list like that in a cell, it treated as text rather than numeric data so it is not trivial to manipulate it as numbers. It is certainly possible with VBA, and is likely possible with formulas, but I echo stanleydgromjr's suggestion to post a sample.

[squiggler47]

You could try this entered with CTRL+SHIFT+ENTER

Please Login or Register  to view this content.

[DonkeyOte]

Or:

Please Login or Register  to view this content.

An alternative would be to utilise Evaluate - either via Defined Name (XLM), 3rd Party Add-In (morefunc) or your own basic UDF, eg:

Please Login or Register  to view this content.

the above, stored in a Module in VBE in a Macro Enabled File would be invoked from a cell along the lines of:

Please Login or Register  to view this content.

there is an optional parameter to define the function you wish to apply to the string - MAX is assumed by default - so if you wanted to return the MIN

Please Login or Register  to view this content.