If you had a dataset of 3 companies information and you need to get:
1- The market share of each of the 3 competitors
2- Find the 10 largest stations
3- Market share at each of these 10 stations between the top 3 competitors
What formula can be used in excel to solve this? Thank you so much
It depends on how the data is set up.
I would solve it with an pivot table solution.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Can you walk me through it? Thanks!
In that case you have to post an excel file, without confidentional information.
Please also add the desired (expcected) result.
unfortunately i can't share the file
There is no need for the Original file.
Just an excel file, with the same format and sheets.
The issue is I don't have the file yet, someone is preparing it but I wanted to know of ways to solve those questions since thats what I will have to do when I get the file ( thhis weekend probably). Besides a pivot table, would other functions work? I was thinking about the "Rank" function for the 2 nd question. Thank you!Originally Posted by oeldere
I believe the point, without any data to work from and how the data is setup, it's anybody's guess how this can be solved.
In order for us to come even close with an option, we would have to make up some data to test solutions so that's where we ask you to provide a test sample.
#2 sounds like a quick and simple pivot table could work, but maybe not so with #1 and #2.
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
HTH
Regards, Jeff
Thank you, I have no idea what the sample will look like as it has not been provided to me yet. I guess I will get back to you when I get it. Thanks a lot!
Last edited by jeffreybrown; 07-26-2013 at 09:27 AM.
I would like a formula that will total the sales to the left for each code to the right. Thanks
A pivot table would work best, but you could also use Advanced Filter and then SUMIF.
Thanks a bunch. That worked. Now, if I want to figure out for company A, B , C in these 3 diff.sheets, In the first half of 2015, which sales person has the most business expiring, what is the easiest way to do it? I am struggling to find a quick way. Thanks a lot.
Last edited by jeffreybrown; 07-28-2013 at 01:31 PM. Reason: Removed attachment due to privacy
I'm stepping out the door for the next few hours so don't have time right now. I would say on Tab A, those are not dates so they need to be adjusted so they are. I'll place a call to the other forum members to see if they can help.
On Tab A you can convert what is in column C to a date with
D2 Copied down >> =(MID(A!C2,5,2)&" "&LEFT(A!C2,3)&" "&MID(A!C2,8,4))+0
then format to whatever format you desire.
Thank you Jeff. I was thinking about just changing the format to Date, wouldn't that work?
I changed the date format on that sheet and i used a pivot table to filter the dates I wanted. Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks