Do While Loop or an Array

[mdwills]

Hello all,

First time on here as completely stuck on something in Excel 2010 and cant work it out!!!

I have a table with cross country runners in and their information:

Position Race Number Name School Year Gender Group
1 11 Andy Barratt Castle Manor 8 M M8

Here is the top line and will go on for 400 runners.

The group is a concatenate of the year and gender.

On a seperate worksheet i need to organise the runners so they automatically go into the group in placings rather then obviously someone do it manually.

The idea is that the next worksheet in excel will workout who has won based on the year and gender

Below is the closest link I could find to what i want but the example .xlas file does not work!:

http://en.allexperts.com/q/Excel-105...a-column-B.htm

Any help would be very much appreciated!

[tigeravatar]

mdwills,

Welcome to the forum!
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
To attach a file, click the "Go Advanced" button and then click the paperclip icon to open the Manage Attachments dialog.

[mdwills]

Hi, sorry to sound stupid but how to I attach a file?

[tigeravatar]

To attach a file, click the "Go Advanced" button and then click the paperclip icon to open the Manage Attachments dialog.