Excel formula help....

GIBURROWS

GIBURROWS

GIBURROWS

Soldato
Joined
13 Jan 2010
Posts
5,189
Location
The 'Shire'
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
 
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)
 
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.
 
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?!?
 
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.
 
You must log in or register to reply here.
Back
Top Bottom