Maths Question

[AbelianGrape]

It sounds to me as if you could do with something a little more powerful than a spreadsheet. Have you tried using a database? Even a desktop database like Microsoft Access would be better than Excel - it can remove duplicate entries with a single query, and it would almost certainly be faster in the long run, if you plan to maintain the list.

 

[subaqua]

wibble

 

[thom]

[QUOTE 2276013, member: 9609"]I didn't get any of that, but many thanks for posting it all the same.

After my success of creating the first bit all by myself, I was sort of beating myself up at not being able to figure out the next part. Now I can see I wouldn't have got that in a million years.[/quote]
Ok, just to make clear, AbelianGrape's formula is what you want. What my post does is a general formula that includes the n(n+1)/2 case as well as your case. It is overkill but i had too much time on my hands...

 

[rich p]

Ok, just to make clear, AbelianGrape's formula is what you want. What my post does is a general formula that includes the n(n+1)/2 case as well as your case. It is overkill but i had too much time on my hands...

(n+1)/2?
Half a new bike? Stick to Pro Race research Thom