Max and Min Numbers with text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
See response in excel.misc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max and Min Number with text 2
Using Min() and Max() on column with both strings and numbers - can it work? 2
MAX with Text and Numbers 1
Anyone smarter than WD support? (wish I was). 8
EZbios writes to drive it was not installed on. 5

Back
Top