Hi all,
See the attached $$
I am trying to rank companies by top "social media accounts" the problem is companies can have the same name, its just the way the data is. Is there a way to add figures and rank together?
Therefore, instead of:
Company A // 10
Company A // 7
Company B // 2
Company C // 4
I would have
Company A // 17
Company B // 2
Company C // 4
Last edited by guy13; 11-04-2014 at 11:32 AM.
I hope I have been clear?
Can you use a helper column? You could just do an =SUMIF by company name and then rank the company subtotals.
That would work the problem is companies are added weekly. Really want something that works every time on the fly.
bumpbumpbump
Hi
RANKING sheet
C4This is array formula!! Press same time Ctrl+Shift+Enter, NOT ENTER!! Then copy down.Formula:
Please Login or Register to view this content.
A4This is array formula!! Press same time Ctrl+Shift+Enter, NOT ENTER!! Then copy down.Formula:Please Login or Register to view this content.
B4copy downFormula:Please Login or Register to view this content.
Do the same D,E,F columns change a letter!!
USE REPORT sheet
A5This is array formula!! Press same time Ctrl+Shift+Enter, NOT ENTER!! Then copy down.Formula:Please Login or Register to view this content.
See the file!! Highlight yellow cell!!
Regard
micope21
Last edited by micope21; 11-05-2014 at 10:17 AM.
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
Check the file again!! 6# Small error!!
Regard
micope21
this is amazing. please can you explain it??
can you resend the file?
Here the correct file!!
I got to get back to work now!!
Will explain later or tomorrow!!
Regard
micope21
Thanks mate! I dont think it is 100% just looking at the connections for company named 25 should = 6 but it =0.
In fact if you total the connections on both slides the RANKING slide is about 7k lower
HiOriginally Posted by guy13
Thanks mate! I dont think it is 100% just looking at the connections for company named 25 should = 6 but it =0.
In fact if you total the connections on both slides the RANKING slide is about 7k lower
Can't see anything wrong mate!!
Company 25 is spot on saying = 6!!
Check the file!!
Regard
micope21
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks