Excel - Arranging, Matching & Presenting data using a macro.

Hi Everyone,

I’m doing a project where I have to manipulate some data using Excel and the project’s programming requirements are sadly a bit beyond my skills.

I am studying 2 variables and looking for a way that one may influence the other.

The data in the project concerns counting bacteria in water samples with temperature. Boring I know!

Anyway I have huge sets of data of bacteria counts and temperature. Temperature is measured to the nearest 0.25 degree. What I need to do is associate a certain bacteria count with a set temperature.

In one column (say column B) I have the bacteria counts and in the next column (C) I have the temperatures at which those bacteria counts were taken. I want to scan down column B and first of all find the highest and the lowest range of bacteria count. Say 5 to 15. There will be say 20 temperatures associated with the 5 value and then 23 assocated with the 6 value and so on down the column. So for each individual count in that column I need to find the temperatures that are associated with them and put the temperatures in cells on the same row and resent it like below.

Bacteria Count	Temp

5		20.25 20.5 20.00 19.75 20.00 etc.
6                 20.50 20.75 20.20 21.75 22.00 etc
7
8
9
10
11
12
13
14
15

Here’s as far as I’ve got and I hope someone can fill in the blanks

Sub Scatter ()

Dim r As Range, c As Range, cfind As Range
Dim r1 As Range
Set r = Range (Range (“C10”), Range (“C50”))
Set r1 = Range (Range (“D10”), Range (“D50”))

HERE I NEED TO FIND THE MAX AND MIN VALUES OF THE RANGE AND THEN FOR THOSE MAX AND MIN VALUES AS WELL AS EACH COUNT IN BETWEEN FIND THE ASSOCIATED TEMPERATURES FROM COLUMN D AND WRITE THEM IN SUBSEQUENT SAME COLUMN.

End Sub

Any help at all would be very much appreciated.

Thank you so much in advance,

AJ