data categorization

Hi all, Thanks for reading and hopefully helping! I have a slightly weird question and have been searching for hours for an answer, and so far, no such luck. I would like to be able to have two drop down lists that link by a formula, so that if a person wants to select either way, it will...

Hi All, I have a huge set of statistical data which needs to be sorted. This data is spread across multiple sheets. The format of the data is "Name (A-Z) - Type" in column A and its corresponding numerical values in arranged row wise. eg: <tbody> NameA_Type1 10 12 14 NameA_Type2 16 18 20...

Hi all, I have "x" categories of different sizes and would like to create "y" teams with the same proportion of each category in it. Also I need the teams to be of equal size plus or minus maximum one individual. For instance, let's stay I have 3 categories: Bachelor's, 8 students; Master's...

I have a large spreadsheet with three columns of info. In Col A is the group name, Col B is the sub-group name, and Col C is a list of the items. Each group name in Col A has a very small icon on the left side, showing a + or -. By clicking on the +, the data in Column B opens up. Each item...

I have recently categorized a large amount of companies into industry sectors manually. I have a similar dataset now, and cannot think how to automatically categorize the new dataset. I need a formula to search the new dataset and where a company is found that also exists in the old data...