| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 58271 | 2005-05-27 03:30:00 | Excel Question | cruz (8216) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 358826 | 2005-05-27 03:30:00 | Hi, Just having some trouble collating some information in Excel at the moment. I am gathering data on population on one sheet within the workbook. I have the age brackets in cells B6:G6 and the population numbers in cells B8:G8. What I need to do is have Excel find the maximum number from cells B8:G8 and return the age bracket above in cells B6:G6. For example if age group "15-19" had 4500 people (that being the highest bracket), then I need to have "15-19" return on a seperate sheet within the workbook. Thanks very much for your help. |
cruz (8216) | ||
| 358827 | 2005-05-27 04:39:00 | If you could swap the rows (move the age below the population) you could use the hlookup function e.g. =HLOOKUP(MAX(B6:G6),B6:G8,3,FALSE) | kiwipole (2469) | ||
| 1 | |||||