MAX and MIN value of a column

[graham fraser]

Hi Mr Excell users

Looking for help to solve a problem
I have 2 columns , one which has mixed data

89045; 8

that i first separate into the second column using "=RIGHT(A1,LEN(A1)-SEARCH(";",A1))"

8

I then need to have a third cell only that i am trying to show MAX value from the data in the second column made up from numbers ranging from 0-400
If i use the =MAX(B1:B15) then return is always 0,

89045; 8	8
95919; 8	8		MAX	0​
96326; 8	8		MIN	0​
90719; 8	8
89087; 8	8
00642; 8	8
08981; 9	9
07031; 9	9
01333; 8	8
01537; 8	8
10211; 9	9
17457; 9	9
16945; 9	9
11979; 9	9
07827; 9	9

any help much appreciated

 

[Georgiboy]

How about:

Book1
	A	B	C	D
1	89045; 8
2	95919; 8		MAX	9
3	96326; 8		MIN	8
4	90719; 8
5	89087; 8
6	00642; 8
7	08981; 9
8	07031; 9
9	01333; 8
10	01537; 8
11	10211; 9
12	17457; 9
13	16945; 9
14	11979; 9
15	07827; 9
Sheet1

Cell Formulas
Range	Formula
D2	D2	=LET(r,--TEXTAFTER(A1:A15,"; "),MAX(r))
D3	D3	=LET(r,--TEXTAFTER(A1:A15,"; "),MIN(r))

 

[nemmi69]

Think the problem is that the second column is text. Need to format the column to number (right click- format, number)

 

[graham fraser]

perfect ...now working