| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
1. locate an un-used row of cells
2. use Tools Text to Columns... to separate the list into cells from step #1 3. use the MAX() function to get the largest value. -- Gary''s Student "Hells" wrote: Hello, Can anyone help me, I wish to return the higest number in a string of numbers (all in the same cell) seperated by commas. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| How do I align numbers where one number has a dollar sign? | Charts and Charting in Excel | |||
| How to compare 3 numbers and return value | Excel Worksheet Functions | |||
| finding the second largest number in a list | Excel Discussion (Misc queries) | |||
| Lookup closest number in list | Excel Discussion (Misc queries) | |||
Hybrid Mode
