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.
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_Eekelen
Nishkarsh31 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.
Nishkarsh31 Sorry, perhaps I'm missing the point. You obviously want to extract information from the description column so that you can summarise the debit ans credits in various ways. Rather than trying to create all sorts of complicated formulae, focus on splitting up the description column in stead, and then summarise the data with pivot tables, for instance.
While I'm writing this, I see the PeterBartholomew1 has responded. Perhaps he can help you further.
- Hi sir, I was trying different arguments in filter function to get it done. But none worked.
I agree with you. I've decided to split the description column into different columns.
Thank you so much for the idea.
However I don't wanna use a pivot table, I need things to be automated and don't wanna refresh at every new entry. I've decided to use a combination of LEFT,MID to make 6 helper columns, and use match function to automate the segregation.
Do you think that would work? Can you help me out with that?