Hi everyone, long time away from this forum. I bring a tough one (I think) and is more of thinking an approach than coming up with a formula.
I'm a 2007 user, and I have the attached scenario. Basically, I'd need to pull a list with the Region (column I) and Username (column J) based on whether they have rated or not the different aspects of a product (3 aspects for Experience, 4 for Usability).
The "1"s in columns B to H indicate they have indeed rated that aspect, so for example everyone has rated Module1 except for those individuals in rows 7, 13 and 15. So the outcome of filtering this would be a new list, with the regions and usernames of everyone except for those that are blank in those rows.
Also, seeing that it is uneven, users may have rated some modules in "Experience" but not others, I'd like to make a new list with those that have rated at least one aspect in Experience overall, regardless the Module.
There's no desired approach, formula, array, pivot table, code. I just can't think of the most practical way of doing it or fastest in calculating.
I appreciate anyone out there willing to help.
Thanks!!
I'm a 2007 user, and I have the attached scenario. Basically, I'd need to pull a list with the Region (column I) and Username (column J) based on whether they have rated or not the different aspects of a product (3 aspects for Experience, 4 for Usability).
The "1"s in columns B to H indicate they have indeed rated that aspect, so for example everyone has rated Module1 except for those individuals in rows 7, 13 and 15. So the outcome of filtering this would be a new list, with the regions and usernames of everyone except for those that are blank in those rows.
Also, seeing that it is uneven, users may have rated some modules in "Experience" but not others, I'd like to make a new list with those that have rated at least one aspect in Experience overall, regardless the Module.
There's no desired approach, formula, array, pivot table, code. I just can't think of the most practical way of doing it or fastest in calculating.
I appreciate anyone out there willing to help.
Thanks!!
