cockneyjim
New Member
- Joined
- Nov 1, 2013
- Messages
- 4
Hi and best wishes.
I'm returning to Excel
after many years.
It's amazing how much one forgets!
I'm hoping for some advice on constructing
a method to sort out some numerical results.
Basically, I need to take readings from a machine
in a laboratory. Each reading will yield 5 numbers.
Each reading will have a whole number value of between 1 and 99,
which I will enter into columns ABCD and E.
I need to read each row of 5 numbers and somehow display or highlight
all the rows that have 3,4 and 5 consecutive numbers.
I also need to display or highlight those rows where 3,4 and 5 numbers are all even or all odd.
Any ideas would be welcomed, or even point me to a tutorial that might
deal with such a problem.
Many thanks in advance.
Best wishes
Jim
I'm returning to Excel
after many years.
It's amazing how much one forgets!
I'm hoping for some advice on constructing
a method to sort out some numerical results.
Basically, I need to take readings from a machine
in a laboratory. Each reading will yield 5 numbers.
Each reading will have a whole number value of between 1 and 99,
which I will enter into columns ABCD and E.
I need to read each row of 5 numbers and somehow display or highlight
all the rows that have 3,4 and 5 consecutive numbers.
I also need to display or highlight those rows where 3,4 and 5 numbers are all even or all odd.
Any ideas would be welcomed, or even point me to a tutorial that might
deal with such a problem.
Many thanks in advance.
Best wishes
Jim