Hi All
Hope you are well, I've been stuck on this problem for a while now, I've been able to figure out half of it but not the rest. Basically I have a data sheet that lists categories, levels and titles, and I'm trying to get a formula that will populate a grid of results based on the category and level of the job titles. There are duplicates in this data set so I only want to retrieve 1 of the duplicates and all unique values.
Also I'm looking for the formula to stop when there are no more results, and if a new result is added, the formula should pick this up and populate on the grid.
Lastly something more advance, I'm interested to find out from all the experts out there if its possible to list these results one line after another but in 1 cell? In the Grid tab I've added 2 examples of what the final grid should look like
Below is a sample of my data
View attachment sample.xlsx
Thank you so much in advance for your help and taking the time to look at my query
Regards
TTTT
Hope you are well, I've been stuck on this problem for a while now, I've been able to figure out half of it but not the rest. Basically I have a data sheet that lists categories, levels and titles, and I'm trying to get a formula that will populate a grid of results based on the category and level of the job titles. There are duplicates in this data set so I only want to retrieve 1 of the duplicates and all unique values.
Also I'm looking for the formula to stop when there are no more results, and if a new result is added, the formula should pick this up and populate on the grid.
Lastly something more advance, I'm interested to find out from all the experts out there if its possible to list these results one line after another but in 1 cell? In the Grid tab I've added 2 examples of what the final grid should look like
Below is a sample of my data
View attachment sample.xlsx
Thank you so much in advance for your help and taking the time to look at my query
Regards
TTTT