rafamilanes21
New Member
- Joined
- Feb 9, 2014
- Messages
- 7
Hello guys,
I am new to excel and I'm having a little trouble tying to figure this one out.
I have a huge set of data and I do not want to separate them.
I want to take an average from B2 but skip every other 2 rows. Essentially I want the averages of B2,B5,B8 and so on.
PLease advise...
Thanks,
Rafa
I am new to excel and I'm having a little trouble tying to figure this one out.
I have a huge set of data and I do not want to separate them.
I want to take an average from B2 but skip every other 2 rows. Essentially I want the averages of B2,B5,B8 and so on.
PLease advise...
Thanks,
Rafa