I have got a sheet that looks like this:

B C

20 77.8
20 77.7
20 77.7
20 77.7
20 77.6
40 77.4
40 77.4
40 77.4
40 77.3
60 77.3
60 77.3
60 77.3
60 77.3
60 77.4
60 77.4
60 77.4
80 77.6
80 77.6
80
80
100
100
100
100
100
100
100
120
120
120
120
120
120
140
140
140
140 78.4
140 78.5
140 78.5
140 78.5
160 78.6
160 78.6
160 78.7
160 78.7
160 78.7
160 78.8
180 78.6
180 78.6
180 78.5
180 78.5
180 78.5
180 78.4
200 78.4
200 78.3
200 78.3
200 78.3
200 78.2
200 78.2

It starts at B1 and goes on to B... What I want is to have the range o
values in column C for all of the same values in column B.
For example, the first range would return C1:C5 (because al
coresponding values in column B are 20). And then C6:C9 for value 40 i
column B etc... But it should only return values that exist. For exapl
value 80 in column B has only 2 coresponding values in column C so onl
the range of those 2 value should be returned

--
Message posted from http://www.ExcelForum.com