i have one number from 6- 12 in each row of Col A and I want to find out the avg skip, max skip, and longest out (currently) for each number. Thanks
i have one number from 6- 12 in each row of Col A and I want to find out the avg skip, max skip, and longest out (currently) for each number. Thanks
It may just be me, but I have no idea what you are looking for here. What is "average skip", "maximum skip" and "longest out"?
Can you post an example of the sort of data you have and what you want to get out of it.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
for instance,
6
8
7
6
5
6
9
8
5
6
the avg skip for 6 is 2, the max skip is 3
When I say skip I mean that the 6 is not there
Last edited by Jordans121; 12-12-2010 at 05:23 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks