I'm not sure what I'm asking for is possible, but will try and ask anyway!
Basically, we have a list of test results in the following format -
Business Process - Response Time
BP1 - 2.34
BP1 - 4.32
BP1 - 3.21
BP1 - 1.27
BP1 - 2.95
It's on a larger scale, but let's keep it small for now.
The number of business processes is likely to change each time we run a test; the first test might have 50 BP1 results, but the second test might have 52, etc.
What I want to do is use a formula to count how many BP1's there will be, and then print the cell ranges. Is this possible?
For example, in the values above, they could be A1:A5 so the results would be B1:B5 - I need the B1:B5 values printed somewhere I can use them in another formula.
Please help!
Basically, we have a list of test results in the following format -
Business Process - Response Time
BP1 - 2.34
BP1 - 4.32
BP1 - 3.21
BP1 - 1.27
BP1 - 2.95
It's on a larger scale, but let's keep it small for now.
The number of business processes is likely to change each time we run a test; the first test might have 50 BP1 results, but the second test might have 52, etc.
What I want to do is use a formula to count how many BP1's there will be, and then print the cell ranges. Is this possible?
For example, in the values above, they could be A1:A5 so the results would be B1:B5 - I need the B1:B5 values printed somewhere I can use them in another formula.
Please help!