Hi Guys,
Can someone please have a look at the attached file and help me?
Quartiles 3.xlsx
Hi Guys,
Can someone please have a look at the attached file and help me?
Quartiles 3.xlsx
I changed your formula a little to this...
=IFERROR(VLOOKUP(F9,$H$8:$J$12,MATCH($B$2,$H$7:$J$7,0),1),"")
It is based off the table which you kind of started in H. Take a look atthe attached, I put the new formula in K (highlighted yellow) so you can compare with what you had. Move it to where you want it when you are satisfied it works
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
In G9 use and drag down.
Please Login or Register to view this content.
Thank u so very much fdibbins and kv.
your solution works perfectly!
I am not sure if a new thread is needed but I would want the column b9 and g9 to talk to each other.
for eg:
if B column has team name as x and 10 different consultants, I want it to calculate how many in team x are in top, bottom, middle upper and middle lower.
team x 4 top, 2 bottom etc - I ideally want a graph of these numbers.
Can you help?
For "Top" use this.Similarly you can get for others.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks