Luis Ramirez
New Member
Hello Guys,
I am looking for a macro a bit difficult, at least to my expertise level. I have a column with values:
A1. 100
A2. 98
A3. 19
A4. 134
A5. 234
A6. 21
Then I need to compare each cell with previous one (let´s say A6 with A5) IF the value is minor then continue to compare with next previous next one (A6 with A4 in this case). And continue to do it until the value is greater (in this case until A3). A counter must show up the number of cells that met the criteria (in this case 2, A5 and A4).
If someone can put me on the right track will be really great!
I am looking for a macro a bit difficult, at least to my expertise level. I have a column with values:
A1. 100
A2. 98
A3. 19
A4. 134
A5. 234
A6. 21
Then I need to compare each cell with previous one (let´s say A6 with A5) IF the value is minor then continue to compare with next previous next one (A6 with A4 in this case). And continue to do it until the value is greater (in this case until A3). A counter must show up the number of cells that met the criteria (in this case 2, A5 and A4).
If someone can put me on the right track will be really great!