• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 108
  • Last Modified:

Need to filter out certain rows in an excel spreadsheet

I have a large spreadsheet to modify, but have included a small sample (attached) for explanation.

I only want certain rows.  

For example, I want Row 2 because there is a # sign in column A beside it.  I do NOT want Row 1 because there is a Row 2 where R1C2 matches R2C2.

Another Example:  I only want row 8, not row 7 or row 9, because a row exists with G0105 in column B and a # sign in column A.

I DO want the rows 14 through 18, however,because there are no rows where a # sign exists for those identifiers in column B.

So the # sign trumps all, but in addition I want to exclude any rows where there is a value in column C.

Does anyone know how to do this?
testing-sample-2.xlsx
0
Becky Edwards
Asked:
Becky Edwards
  • 4
  • 3
1 Solution
 
ProfessorJimJamCommented:
run the macro in the attached workbook and it will do the job
testing-sample-2.xlsm
0
 
Becky EdwardsEpic Clarity DeveloperAuthor Commented:
I tried it, we are almost there!.  Except it removed all the rows where there were no # signs in the row.  I need those rows also, if no row exists for that Code (example G0108) with a # sign beside it.  

Example:
I DO want the rows 14 through 18, however,because there are no rows where a # sign exists for those identifiers in column B.
0
 
ProfessorJimJamCommented:
i do not understand the requirement.

can u upload the file, by deleting all of the rows that need to be deleted and leave those need to stay.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Becky EdwardsEpic Clarity DeveloperAuthor Commented:
I need EXCEL to evaluate each row and delete if necessary.  

In the attached file,
I do not need row one because row two exists, for G0101, with a # sign in column a. Delete row one.
I do not need row three because row four exists, for G0102, with a # sign in column a.  Delete row three.
The same for rows 5,6,7,8,9,10.  I want to keep the rows 6,8, 10 and delete rows 5,7,9.
I need row 11 for code G0106 because rows 12 and 13 for G0106 have modifiers in column C, so that disqualifies rows 12 and 13.  Delete rows 12 and 13.
I need row 14 - 18 because no row exists with a # sign for those codes in column B, G0108 through G0120.

Does this help?  Thank you for your patience!
0
 
ProfessorJimJamCommented:
please see attached file.  run the macro "deleterows"
testing-sample-2.xlsm
0
 
Becky EdwardsEpic Clarity DeveloperAuthor Commented:
Wow.  This is awesome.  You just corrected my huge spreadsheet in seconds.  Something the girl at work here takes hours to do by hand.  

I really appreciate your hard work, and the fact you are willing to share with others.

Your my hero.

Thank you ProfessorJimJam
0
 
ProfessorJimJamCommented:
You are welcome.

Thanks for feedback.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now