Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear All
I am unsure how to proceed with the following challenge. I have a worksheet with 3 columns (see below). For each group of data with the same value in the first colum I need to 'capture' that data set and then run a predefined function on it. I then need to proceed to 'capture' the second group of data and so on. I'm not sure if the data should be read to an array and if so how to capture it all. My initial feeble attempts either lost the 1st or last data set and then I got stuck with the looping. Thanks Matt Col1 Col2 Col3 BH-01 14.8 0.08 BH-01 28.5 0.85 BH-01 42.1 2 BH-01 82.4 19 BH-01 100 38.1 BH-02 14.9 0.08 BH-02 24.2 0.85 BH-02 34.7 2 BH-02 50.7 4.75 BH-03 22.4 0.08 BH-03 31.6 0.15 BH-03 41.2 0.25 BH-03 56.4 0.43 BH-03 81.8 0.85 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to write an array to a range without looping | Excel Worksheet Functions | |||
Error after last object in the array when looping For...each | Excel Programming | |||
Looping through Sheets and passing values to an Array | Excel Programming | |||
Looping question | Excel Programming | |||
Looping Question? | Excel Programming |