ExcelBanter - Max and Min Numbers with text

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Max and Min Numbers with text (https://www.excelbanter.com/excel-programming/359975-max-min-numbers-text.html)

maperalia

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.

Bob Phillips[_6_]

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.

All times are GMT +1. The time now is 06:24 AM.