Solved

Need to filter out certain rows in an excel spreadsheet

Posted on 2015-02-04
7
66 Views
Last Modified: 2015-02-12
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
Comment
Question by:Becky Edwards
  • 4
  • 3
7 Comments
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40589904
run the macro in the attached workbook and it will do the job
testing-sample-2.xlsm
0
 

Author Comment

by:Becky Edwards
ID: 40590041
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
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40590139
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
ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

 

Author Comment

by:Becky Edwards
ID: 40591579
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
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40602590
please see attached file.  run the macro "deleterows"
testing-sample-2.xlsm
0
 

Author Closing Comment

by:Becky Edwards
ID: 40605797
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
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40605800
You are welcome.

Thanks for feedback.
0

Featured Post

ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

To stay competitive, modern businesses must adapt and stay innovative, and this is increasingly only possible by working with outside talent. Managers and executives have understood the power of outsourcing for quite some time, but traditional clien…
Photo Albums in PowerPoint Photo Albums are a very useful tool in PowerPoint and allow you quickly add a large number of images. The images can be formatted in a variety of ways so that you are able to create a professional looking presentation v…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question