Hi,
I am doing a project where I have to create a list of all possible combination from a set of rows and columns. The problem is the number of rows are not the same in each and every column. This created blank cells when the cross join is obtained. I want to give numbers to all the possible...
I am sorry.. I was in a rush! I meant to type Advanced Filters but ended up typing Auto Filters. And yes I did go through the threads to see if anything related is applicable to my case. Unfortunately no, mine is way more complex scenario I believe. Anyways thanks for your help. I appreciate it.
Hi ! Thanks for the reply. Unfortunately Auto Filter is not a feasible solution for my sheet because the user input in not going to be direct. It is going to more like a matrix input where they ask for the possible combinations.
Hello Everyone,
I am doing a project which generates close to 12,000 values(Texts) in a table. Each has unique values. I have another sheet that asks the user their preference. Now I need to match the preferences and the values in the generated table. If they match then that particular row must...