Identifying a ranked value and then displaying a value
So I'm a bit stuck.
I've got a range of columns that indicate salary brackets on my spreadsheet. eg column A is £0-10K, column B 11-20K etc
Then on the rows I have how many people for a particular area fit into each of these columns.
What i need to do is display in a separate column: what the number one salary bracket is for that particular area and then in a second column what the 4th salary bracket is. So that when you look at the data at a glance you can see that the top 4 salary brackets for each area. eg 10K-40K
So I've managed to highlight on each row what the top 4 salary brackets are using conditional formatting but cant for the life of me work out if this next bit is possible!
in my head the logic goes something like this:
If the highest number of people in a salary bracket is in column A then display XXXX
The issue is that there are 11 columns where the first and 4th can be.
Any ideas?!
thanks
Jamie
| Attachment | Size |
|---|---|
| excel mind blowup.xlsx | 17.99 KB |
Calculating Salary and displaying the highest.
You said "column A is £0-10K." But it is "Base Households."
You said "column B 11-20K." But it is "1. Mean Gross Family Income > £60K."
You said "on the rows I have how many people for a particular area fit into each of these columns." Give example mentioning the Cell Address.
You said "display in a separate column: what the number one salary bracket..." Mention the Cell Address in your file.
You said "in a second column what the 4th salary bracket is." But instead in column X you have Salary TOTAL of the Large 4 Salaries. For example in X2 you have 7916, which is the total of 2513, 2218, 2018 & 1167. How will you "look at the data at a glance" and "see the top 4 salary brackets', when there is only the TOTAL?
Explain your logic. "If the highest number of people in a salary bracket is in column A..." Are you talking about the whole column or a cell in a row?
"then display XXXX" in which cell? in which row?
If your query is explained me or someone else may help you. I am not an expert. Still learning. But happy to help if I can.
Unclear request
Hi Jamie, I looked at your file and still can't figure out what you are about to. There is no conditional formatting visible. As I could see, in column X there is a sum of Top 4 brackets. Do you need separate Top 1 and Top 4 sums? Or, maybe their references, like what bracket is Top 1 and what bracket is Top 4?