You did not include the total counts in the B Column which is what I need to count.
A1: Text1 B1:3000
A2: Text2 B2:2500
A3: Text1 B3: 250
so on and so on for 5000 cells
because you did not even see the B column description, I wonder how much you studied my detailed question
You don't yet seem to understand what I am asking so it won;'t do any good to send you a file as the answer will still be wrong
I just spent 30 minutes with the expert above and he never answered it because he never understood it. I am looking for an answer to an excel question. Are you an Excel expert?
The totals are in b1-b5000 but there are many different page referrals and its the total referrals in the B column I need to count. I am sending snapshot of what the report will look like using a small sample. The highlighted cells are the multiple park occurrences.
Ok So were close but the totals in your example for Text1 show 615,000 the actual number (SUM) is 620,000.
Once this is clarified then please help me get it in to my spreadsheet so I can test against the actual numbers. Then we should be done.
One other thing the example you sent had only 3 parks, I have 87 spread over 5000 links. so we have to pull the up the 3rd occurence of "-" to id it completely
so we have to pull the up the 3rd occurrence of "-" (after the first 28 characters) to id it completely
The download link is:
I think so I have one count off I am using to check but I believe its because I have more rows then I sent you. Can you send me any directions I need to add the extra rows...That way I won;t hold up the process and I can close the question.