Hi,

I have attached a worksheet:

1) I have the German Version. So I would think, posting my error message in German wont help, sadly. If necessary, I would buy a language pack for English (which will cost 19,95€ according to MS - not so cheap imho)

2) Why is it: "$A$1:$A$11"? I would think, it should be "$A$2:$A$12". Or does it not matter?

3) How can I extract a list from the matrix in my example without redundancies to "List of Index-Words"?

5) How can I compact a list of numbers. At the end I do not want "21, 22, 23, 24, 25" (for example), but "21-25", "34, 35" changed to "34f" and "56, 57, 58" changed to "56ff"

Maybe you want to know: Hopefully this way I can create indices for some books I own (in fact 94 Books) in order to work more efficient with them. So there is some more work to to with excel and some more things I dont not understand. But I know I have to learn excel better and I do not want, that you do all the job for me. You helped me a lot so far.

TIA!

Attached Files

Array 2.xlsx (13.4 KB, 12 views)