Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 81
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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