I have data consisting of New Traffic and Returning Traffic. I need to find
out the percentage of New Traffic that is Returning Traffic. What formula do
I use? Help!!!

Please tell us a bit more about how the data is set out.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"cempire5" wrote in message
...
I have data consisting of New Traffic and Returning Traffic. I need to
find
out the percentage of New Traffic that is Returning Traffic. What formula
do
I use? Help!!!

And don't cross-post -- I answered your question in the other section.
Bob Umlas

"cempire5" wrote in message
...
I have data consisting of New Traffic and Returning Traffic. I need to
find
out the percentage of New Traffic that is Returning Traffic. What formula
do
I use? Help!!!

I have exact traffic numbers for each month Jan-Sep '06-'07. (Ex. B1 labeled
Jan '06; B2 New Traffic 848; B3 Returning Traffic 47 -- C1 labeled Jan '07;
C2 New Traffic 583; C3 Returning Traffic 282. In the original spreadsheet I
do have the variance % of Returning Traffic between '06-'07 per month. Now
they want to know what the % of New Traffic is Returning Traffic.

I started another spreadsheet that now includes the data as described above.

I was thinking I would take the variance % of New Traffic '06 to '07 and the
variance % of Returning Traffice '06 to '07 but don't know how to write a
formula for that. Would that be correct?

"cempire5" wrote:

I have data consisting of New Traffic and Returning Traffic. I need to find
out the percentage of New Traffic that is Returning Traffic. What formula do
I use? Help!!!

So, is there anyone out there who can help with this formula?

"cempire5" wrote:

I have exact traffic numbers for each month Jan-Sep '06-'07. (Ex. B1 labeled
Jan '06; B2 New Traffic 848; B3 Returning Traffic 47 -- C1 labeled Jan '07;
C2 New Traffic 583; C3 Returning Traffic 282. In the original spreadsheet I
do have the variance % of Returning Traffic between '06-'07 per month. Now
they want to know what the % of New Traffic is Returning Traffic.

I started another spreadsheet that now includes the data as described above.

I was thinking I would take the variance % of New Traffic '06 to '07 and the
variance % of Returning Traffice '06 to '07 but don't know how to write a
formula for that. Would that be correct?

"cempire5" wrote:

I have data consisting of New Traffic and Returning Traffic. I need to find
out the percentage of New Traffic that is Returning Traffic. What formula do
I use? Help!!!

I have exact traffic numbers for each month Jan-Sep '06-'07. (Ex. B1 labeled
Jan '06; B2 New Traffic 848; B3 Returning Traffic 47 -- C1 labeled Jan '07;
C2 New Traffic 583; C3 Returning Traffic 282. In the original spreadsheet I
do have the variance % of Returning Traffic between '06-'07 per month. Now
they want to know what the % of New Traffic is Returning Traffic.

I started another spreadsheet that now includes the data as described above.

I was thinking I would take the variance % of New Traffic '06 to '07 and the
variance % of Returning Traffice '06 to '07 but don't know how to write a
formula for that. Would that be correct?



"Bernard Liengme" wrote:

Please tell us a bit more about how the data is set out.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"cempire5" wrote in message
...
I have data consisting of New Traffic and Returning Traffic. I need to
find
out the percentage of New Traffic that is Returning Traffic. What formula
do
I use? Help!!!

If he'd cross-posted it wouldn't have been such a problem, but he
multi-posted.
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html
--
David Biddulph

"Bob Umlas" wrote in message
...
And don't cross-post -- I answered your question in the other section.
Bob Umlas

"cempire5" wrote in message
...
I have data consisting of New Traffic and Returning Traffic. I need to
find
out the percentage of New Traffic that is Returning Traffic. What
formula do
I use? Help!!!