Hi Haseeb,
Thank you for your solution.
It works perfectly too... I'm spoilt for choice now!
As with the sumproduct function in the last suggestion I'm not familiar with sign or frequency functions in yours so will have to learn more about these and their uses.
It's funny really, I can hold...
Hello again Bosco!
That works perfectly and accommodates increases in size. Thank you once again for your assistance! You can't be far off Excel Ninja status!
Also Chihiro - thank you for your input. There's so many sheets because to reduce the likelihood of errors it will be used for people...
Chihiro,
I do have a quick question about the formula if you can possibly assist again.
The data I put on the spreadsheet running from A6:A25 is just dummy data that I was playing with to try to get the outcome you provided.
In reality, the number of orders to be assessed by the formula will...
Hi Chihiro!
Thank you for taking an interest in my question.
Having zero exposure to array formulae I've opted to try your second suggestion
which works perfectly.
I've not used sum product so will definitely need to get familiar with it so I can work out how your formula works.
Thanks...
Hi everybody,
I'm constructing a sales related spreadsheet and need to record the number of unique numbers in a list.
To assist with any understanding of my query, the list consists of order numbers which are unique to customers.
The spreadsheet will be used to monitor fulfilment failures...
You make a fair point... and thanks for editing the graph data ranges. I'm still getting to grips with many parts of excel. I used to use it years ago but just going through a period of refresher training and improvement, so any tips I pick up along the way are always welcome
Hi vletm,
Sorry for the late reply. I've been in work since early this morning and didn't have access to internet.
Re the graphs, I think they're all there. There's 6 graphs for OM's and corresponding ones at TM level. I did lose one at one point because I composed it in Excel 2016 and when I...
vletm - thank you again for your time and effort in seeking to assist with my query. It is very much appreciated. The revised spreadsheet didn't quite address the average issue I was looking to resolve. The average calculated by the spreadsheet for Steve Wilson was for all of the agents...
Hi vletm!
Thank you for taking the time to look at my query.
You are correct, the Team Manager data is populating the OM Dashboard but unfortunately I'm sorry to say that this is not what I am looking for.
I was hoping to get this in to a position whereby the categories measured for each...
Hi Bosco,
Many thanks for getting back to me.
What I am looking for on the OM Dashboard tab is as follows:-
1. The OM selects his or her name so for example if we use Steve Wilson as an example, he selects his name from the drop down box then in column A under the Team Manager heading I am...
Hi everybody,
Please can I ask for some further assistance.
I have been given a project in work and I have had some help via this forum which has just been fantastic. The result of the assistance has shown me some capabilities in Excel that I did not know it could do.
Firstly thanks and...
Hi Bosco and p45cal,
I've had a look at both of your options and they both look great!
I used to think I was ok at Excel until I saw the standard of work that is generated on this site... I have sooo much to learn. I am truly humbled.
p45cal, your option is probably the more simple of the 2...
Hi Bosco and p45cal,
I've had a look at both of your options and they both look great!
I used to think I was ok at Excel until I saw the standard of work that is generated on this site... I have sooo much to learn. I am truly humbled.
p45cal, your option is probably the more simple of the 2...
-----------------------------
Hi p45cal!
This is also very interesting and I thank you so much for your time and effort.
I'm not going to get a chance to have a proper play around with it until tomorrow.
As soon as I can do that I'll send another response.
Kind regards
Will
Hi Bosco,
Thank you so much for the reply.
Apologies for my late response but I've only just had a moment to log on.
On first glance this looks great... very interesting indeed. I'll get a proper chance to have a look and play tomorrow.
I just didn't want to leave a response /...
Hi Jawaha,
You are absolutely correct, that is the way I put the original information with David Gent reporting to 2x different OM. That way part of his figures would show on Steve Wilson and part on Craig Lynn's data. The routing of the data from advisor to TM to OM worked perfectly as you had...
Hi Jawahar,
Thank you so much for taking the time to assist and reply.
The file you provided is part way there for sure but I'm looking a couple of slight differences.
The capture of the AHT, ACW etc is great and exactly what I need it to do.
The list of advisors I provided was just to put...
Hi All,
Please can I ask for some assistance with lookup formulas? I can do basic vlookup but that's it and I think I need more than that for this task.
I want to create a spreadsheet that will act as a dashboard to present different level data to different readers but from the same source...
No problem Narayan . I see your point. I think that I could keep a list of the names and how they correlate to the numbers to one side.
Thank you so much for all your help and assistance with this spreadsheet.
Kind regards
Andy
Hi Narayan,
That looks awesome, thank you.
Can I ask a question?
Where the points for advisers on the chart currently have a number because I gave you Adviser 1, Adviser 2 titles along the way, could these be substituted with names at some point or does that throw everything out?
It's not a...
Hi Narayan,
The plan at this time would be for the quadrants to be fixed to show periods in time spanning a total of 12 weeks as it would be the intention for this to monitor a training period from when trainees commence training to when they get ready to join the department.
Going forward...
Hi Narayan,
It is probably easier for me to show you what I am looking for. That way you will be better placed to say it can or cannot be done as stands, or it can be done but only with changes.
I have made an illustration of what I am looking for. See what you think. Hopefully this will make...
Hi Narayan,
Thank you for such a prompt reply.
I've attached a spreadsheet showing what I believe the data will look like when I am presented with it.
I should just get people's names together with their tenure and rating.
Kind regards
Will