add number after value 1 to ..x for range of values

[janvdallas]

don't know how to ask the question in words and I hope the attached file is making my question clear

[JeteMc]

Hello janvdallas and Welcome to Excel Forum.
Try pasting the following formula into cell C3 and copying down:

Please Login or Register  to view this content.

Let us know if you have any questions.

[janvdallas]

Hi JeteMC thank you for your quick reply. When pasting this formula I get an error #NAME? . Also column D, E, f and G must be filled same way as in the attachement.

[AliGW]

Have you adjusted the function names for your Dutch locale?

http://dolf.trieschnigg.nl/excel/index.php

[janvdallas]

Hi AliGW, good point. That helps. still I have the problem with the other columns. I will attach a new file with a macro that will almost do what I need but not perfect.

[JeteMc]

Here is a copy of the file from post #1 that has the formula applied.
Let us know if you have any questions.

[janvdallas]

Thank you JeteMC

[JeteMc]

You're Welcome. If your question has been answered, please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.