Vbalearner85
Board Regular
- Joined
- Jun 9, 2019
- Messages
- 139
- Office Version
- 2016
- Platform
- Windows
Hi,
I have 2 columns(col A and B) continuous data in a sheet "Analysis" as below.
Column A has value either of N, L and H is consecutive until it changes to other 2 options. Each value in column A has numerical value against it (either negative ,0, or Positive numerical value)
I wanted to get output as max and min for each value of continuous range of column A. so for below data output should be
Output
Value Min Max
N -1 5
L -2.5 6
H -3.7 7
L -2.3 1.2 and so on.....for below data
Data
Column A Column B
N 1
N 2
N -1
N 5
L 6
L -2.5
H -3.7
H 7
H 4.5
L -2.3
L 1.2
and so on....
and so on....
I have 2 columns(col A and B) continuous data in a sheet "Analysis" as below.
Column A has value either of N, L and H is consecutive until it changes to other 2 options. Each value in column A has numerical value against it (either negative ,0, or Positive numerical value)
I wanted to get output as max and min for each value of continuous range of column A. so for below data output should be
Output
Value Min Max
N -1 5
L -2.5 6
H -3.7 7
L -2.3 1.2 and so on.....for below data
Data
Column A Column B
N 1
N 2
N -1
N 5
L 6
L -2.5
H -3.7
H 7
H 4.5
L -2.3
L 1.2
and so on....
and so on....