Formula for finding MAX and MIN value excluding blank cells from an ALPHA-Numeric column

[Manrique]

Hello, I am looking for a formula that finds the MIN & MAX value from a list of alphanumeric values with empty rows:[TABLE="width: 500"]
<tbody>[TR]
[TD]REF[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100A[/TD]
[TD]100A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]100A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]100A[/TD]
[/TR]
[TR]
[TD]100B[/TD]
[TD]100B[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]100B[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]100B[/TD]
[/TR]
[TR]
[TD]100C[/TD]
[TD]100C[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]100C[/TD]
[/TR]
[TR]
[TD]100D[/TD]
[TD]100D[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]100D[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]100D[/TD]
[/TR]
[TR]
[TD]100E[/TD]
[TD]100E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]100E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]100E[/TD]
[/TR]
</tbody>[/TABLE]

 

[Ron Coderre]

I see the sample data....Can you post the desired result and the logic you want to use?

 

[Manrique]

My apologies. From column A (Ref), populate column B until column A changes to another value and continues populating column B with the new value a so on. Thanks for your help.

 

[jtakw]

Hi,

Since there's no new value in Column A after 100E, how far is Column B supposed to copy down 100E?

Book1
	A	B
1	REF
2	100A	100A
3		100A
4		100A
5	100B	100B
6		100B
7		100B
8	100C	100C
9		100C
10	100D	100D
11		100D
12		100D
13	100E	100E
14		100E
15		100E
Sheet41

Cell Formulas
Range	Formula
B2	=IF(A2<>"",A2,B1)

B2 formula copied down.

 

[Manrique]

Hello Ron, It works perfectly. Thank you very much!

 

[jtakw]

Hello Ron, It works perfectly. Thank you very much!

Err...it wasn't Ron, but you're welcome.

 

[Manrique]

Thank you very much Jtakw!!!