Listing values within a range

[karanbatra]

Hi,

Would anyone know a formula/macro for listing out all values within a certain range. E.g., I am trying to list all values within a zipcode range 20100 thru 20150.

Thanks

 

[yee388]

Something like this?

Book1
	A	B	C	D
1	90210	99000
2	90058	90200
3	39405
4	90210	90210,90210,98450,90211
5	98450
6	78940
7	90211
Sheet1

Using this UDF:

Function ListAll(rng As Range, upper As Long, lower As Long)

Dim Cell As Range

For Each Cell In rng
    If Cell.Value >= lower And Cell.Value<= upper Then
        ListAll = ListAll & ", " & Cell.Value
    End If
Next Cell

'to clear the first comma & space...
ListAll = Right(ListAll, Len(ListAll) - 2)

End Function

 

[bjwillingham]

You can use the Edit/Fill/Series if you just want the values be put in consecutive cells.

 

[yee388]

You might also have a look at AutoFilter's custom filters... you can narrow it down by a range...