| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Max and Min Numbers with text
I want to get the max and min number for "numbers only", "numbers with A"
,numbers with B", numbers with C", numberd with D", of the following list: 120 2 48 54 6 1A 5A 10A 200A 58A 60A 10B 150B 200B 13C 69C 1C 56D 23D 7D 150D Can you get the function please and how to apply it in VBA with unlimited rows? Thanks in advance. Maperalia. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Max and Min Numbers with text
See response in excel.misc.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "maperalia" wrote in message ... I want to get the max and min number for "numbers only", "numbers with A" ,numbers with B", numbers with C", numberd with D", of the following list: 120 2 48 54 6 1A 5A 10A 200A 58A 60A 10B 150B 200B 13C 69C 1C 56D 23D 7D 150D Can you get the function please and how to apply it in VBA with unlimited rows? Thanks in advance. Maperalia. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using TEXT and &TEXT - display numbers with commas, underline text | Excel Discussion (Misc queries) | |||
| Changing A Column Of Text numbers To True Numbers: How ? | New Users to Excel | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
| How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
Linear Mode
