ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Excel Formula Help (https://www.excelbanter.com/new-users-excel/160505-excel-formula-help.html)

cempire5

Excel Formula Help
 
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!!!

Bernard Liengme

Excel Formula 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!!!




Bob Umlas

Excel Formula 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!!!




cempire5

Excel Formula 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!!!


cempire5

Excel Formula 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!!!


cempire5

Excel Formula 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!!!





David Biddulph[_2_]

Excel Formula 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!!!







All times are GMT +1. The time now is 05:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com