Multiple Filter and remove null rows

[Jeyanzon]

hi, im trying to create a workflow by reconciling 2 inout file. but im having no success in removing the null rows and doing multiple filtering.

can someone help me out?

Here are the thinggs i need:

1. remove whole null rows (meaning if column A to column N is blank) in dummyfile1 please remove

2. Once all null rows are remove, 2nd condition is to filter out all matched items which is if b5=b6(simcorp party id and wcis party id matched  then its matched) show matched in new column , if not unmatched, show unmatched

3. Once we have the unmatched items in the new column, then the next condition is to vlookup it in dummyfile2

4. if the party id is in dummyfile2, show in new column acceptable breaks. If the party id is not in dummyfile 2 show as need to research

5. create an output file in excel format for all the party ids that did not matched

[caltang]

Like this?

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

[Jeyanzon]

i want the the party id and wcis  for the both rows to matched.

what we need is if party id is the same, then next thing to matched is the wcis id for the 

[caltang]

Your requirements aren’t very clear. But my workflow shared with you should give you an idea of how to do it. 

Re: Your point on b5 = b6, are you saying that it’s comparing between rows? If yes, you need the MultiRow formula. 

[Jeyanzon]

i'm trying to do a multi row formula but i wasn't able to get the result i want. what should be the correct formula? thanks!

[caltang]

I understand you better now. PFA.

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

[Jeyanzon]

is it possible this null rows? everything works except i need this part to be removed

[caltang]

Certainly. Try again. Based on your comment, this should be the last change.

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

[caltang]

@Jeyanzon did the above solve your need? Kindly mark as accepted solution to close the thread. Thanks!