I have been building on a converter between two systems. The goal have
been to find which twelve "Skills" is followed by the highest value,
and then create a list out of the top twelve. It may look something
like this:

Climb
Heal
Craft: Electronics
Listen
Performance: Dance
Craft: Art
Knowledge: Physics
Drive
Knowledge: History
Diplomacy
Sleight of Hand
Knowledge: Geology
Hide
Move Silently

What would help me a great deal would be if I somehow could build a
separate list of cells gathered from this list, searching for a
specific word, such as "Knowledge:" "Craft:" and "Performance:". The
"hits" should build up separate smaller lists, filling them up from top
down, leaving empty cells (or 0, or a word) at the bottom.

Theese new, smaller and sorted lists will then be used for other
formulas.

For example, I have decicated cells for up to eight "Knowledge". I
would love if I can get the end result to something like:

1=Knowledge: Geology
2=Knowledge: History
3=Knowledge: Physics
4=
5=
6=
7=
8=

The list for "Craft" shoud be a list of 6:

1=Craft: Art
2=Craft: Electronics
3=
4=
5=
6=

2 for "Performance"

1=Performance: Dance
2=

You should have got the deal by now...

Can this be done in Excel at all?
Would be really happy if someone could help me out.

My english is not 100% so ask me to redefine if needed.


--
JemyM
------------------------------------------------------------------------
JemyM's Profile: http://www.excelforum.com/member.php...o&userid=26945
View this thread: http://www.excelforum.com/showthread...hreadid=468703