Excel formula help....

GIBURROWS · 25 Aug 2022 at 06:19

I have a spreadsheet which I have organised but I need to remove full rows of data that have certain words in certain columns (area managers and coordinators) and is it possible to attach it to a macro?

Thanks in advance for any help

Cadder · 25 Aug 2022 at 06:22

Can you not filter so only those rows show? Then highlight and remove said rows.

GIBURROWS · 25 Aug 2022 at 13:45

Yes but I'm trying to sync into one motion.

Cadder · 25 Aug 2022 at 14:01

GIBURROWS said:
Yes but I'm trying to sync into one motion.

VBA Macro to Delete Rows Based on Cell Values or Conditions in Excel

Learn how to use VBA macros to delete rows based on cell values or conditions in Excel. Includes sample code and video tutorial.

www.excelcampus.com

Any good?

GIBURROWS · 25 Aug 2022 at 15:57

Cadder said:
VBA Macro to Delete Rows Based on Cell Values or Conditions in Excel

Learn how to use VBA macros to delete rows based on cell values or conditions in Excel. Includes sample code and video tutorial.

www.excelcampus.com

Any good?

Oooh you legend!

swillsy · 26 Aug 2022 at 15:54

easiest way without messing in VBA is to just add a new column with a formula looking for the text needed - if it finds it then provide a flag (1 or 0) which you can then sort the rows on and then bulk delete. You can add more flags for multiple criteria or nest the ifs if easier.

e.g. =IF(ISERROR(FIND("manager",A1)),0,1)

gpuerrilla · 28 Aug 2022 at 09:56

I used to do that ^. Then I tough myself power query and its so much better at cleaning/manipulating data using Excel. What was more of a shock is how many competent excel users don't even know about power pivot/query. It's quite a growing space now.

GIBURROWS · 28 Aug 2022 at 10:30

I'll look into power query.

So my question is that it can all be done with one hit basically, get rid of the 10 top rows and shift the data up, delete the left column and shift the data left, then delete entire rows if a certain column contains a specific word or words?!?

gpuerrilla · 28 Aug 2022 at 10:32

Yes. Drop me a message @GIBURROWS if you need any help.

You can set it so all you have to do is drop in the fresh file and it will update the output in seconds.

GIBURROWS · 28 Aug 2022 at 10:47

gpuerrilla said:
Yes. Drop me a message @GIBURROWS if you need any help.

You can set it so all you have to do is drop in the fresh file and it will update the output in seconds.

Thank you, I'll give it a go myself first.