Need help with a function, Excel 2004

[Laurie A. Duncan]

I have a list of a few hundred names. Each name needs to have a base URL
with a referrer ID next to it, and the referrer string at the end needs to
be generated sequentially in increments of 13. This is for a mailing to a
group of survey takers.

For example:

Joe Smith | http://www.domain.com/test.cgi?PID=100001
John Doe | http://www.domain.com/test.cgi?PID=100014
Jim Jones | http://www.domain.com/test.cgi?PID=100027

How can I have Excel auto-generate those numbers a the end down the entire
column and append them to the URL?

Thanks for any help you can provide.

 

[JE McGimpsey]

I have a list of a few hundred names. Each name needs to have a base URL
with a referrer ID next to it, and the referrer string at the end needs to
be generated sequentially in increments of 13. This is for a mailing to a
group of survey takers.

For example:

Joe Smith | http://www.domain.com/test.cgi?PID=100001
John Doe | http://www.domain.com/test.cgi?PID=100014
Jim Jones | http://www.domain.com/test.cgi?PID=100027

How can I have Excel auto-generate those numbers a the end down the entire
column and append them to the URL?

Thanks for any help you can provide.

Do you need actual hyperlinks or just the text?

Text:

B1: ="http://www.domain.com/text.cgi?PID=" & 100001 + (ROW()-1)*13

If an actual hyperlink:

B1: =HYPERLINK("http://www.domain.com/test.cgi?PID=" &
100001+(ROW()-1)*13)

 

[Laurie A. Duncan]

Do you need actual hyperlinks or just the text?

Text:

B1: ="http://www.domain.com/text.cgi?PID=" & 100001 + (ROW()-1)*13

If an actual hyperlink:

B1: =HYPERLINK("http://www.domain.com/test.cgi?PID=" &
100001+(ROW()-1)*13)

Just the text

Thanks for this! It works beautifully!

Laurie