I am trying to find all of the rows that have a specific entry in column B, any entry in column C and A is blank in a spreadsheet that is about 63,00 lines long. Unfortunately I can not sort to get the blanks out because of a formula issue.
John
Can anyone tell me how to find Blank or Emmpty cells using the advanced filter. I have tried "", "Blank", (Blank), etc. nothing seemd to work
Thanks for your help
John
Thanks everyone, I unfortunately never know how many rows contain the criteria that I'm looking for. In the past it has been from several hundred to several thousand. What would be nice to have would be code that finds the first occurance and then while setting this (securing the row) as the...
For anyone who can help me!
I need to find rows which meet a specific criteria, for example:
Find and copy to the clip board all rows which have a blank in Collumn A, the four letter phrase "ACCT" in Column B and column C is not blank.
Thanks in advance for any help you might be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.