Forum Discussion
I can't find a formula to spill range with multiple conditions. URGENT !!!
Nishkarsh31 Perhaps like in the attached file? Not very elegant, but it seems to work.
Nishkarsh31 Perhaps like in the attached file? Not very elegant, but it seems to work.
I applied it in a table format. It worked like a charm. I want to add a FILTER formula to filter the descriptions that matched no filter. Can you help me out with that? Here's the updated file. I tried myself, I'm going wrong with the argument.
Riny_van_EekelenNishkarsh31 I dare to say that this is not possible without splitting the description column in its separate components. While you can search for the names "pathak" and "Sanjay" in a large text string, you can not determine which names were not found, as Excel doesn't know "Suman" is a name and that "IMPS" is not. So, break-up the Description column into 6 columns where each column hold the same attribute (i.e. type, name, reference number, etc.) Then the filtering should become easier, although I don't really understand what it is that you want to filter.
Since I wanna automate the segregation, I need to know which all entries didn't get matched to the parameters. It worked in the previous formula with individual helper columns. Are you sure it can't be done? I'm attaching a new file where the formula worked.
