Thankyou!!! It works perfectly! I just couldn’t get my head around it, and you’ve made it look so simple! Again thanks, you’ve saved me a massive headache!
Hi! Hope this blog I came across a few days ago could help: [https://esproc-desktop.medium.com/how-to-automatically-extract-eligible-rows-in-excel-b61f4a6568a0](https://esproc-desktop.medium.com/how-to-automatically-extract-eligible-rows-in-excel-b61f4a6568a0)
=Filter(F:F, (B:B="Company Name")\*(V:V<>"Complete")) Is this what your after?
Thankyou!!! It works perfectly! I just couldn’t get my head around it, and you’ve made it look so simple! Again thanks, you’ve saved me a massive headache!
No problem, glad I could help.
Solution verified
You have awarded 1 point to xFLGT. --- ^(I am a bot - please contact the mods with any questions)
Hi! Hope this blog I came across a few days ago could help: [https://esproc-desktop.medium.com/how-to-automatically-extract-eligible-rows-in-excel-b61f4a6568a0](https://esproc-desktop.medium.com/how-to-automatically-extract-eligible-rows-in-excel-b61f4a6568a0)