Hi, I have a question which may be easy for your guys, but very useful to my case.
As a short example. There are three sheets in the file: S1, S2, S3. For each sheet, the column A has formulas. The goal is, for each sheet, to delete all rows whose values in column A is equal to blank spaces.
I attached the example here. For example, in sheet S1, only keep the first 5 rows with numbers in column A, and all other rows can be deleted.
Soemthing like
Please Login or Register to view this content.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Try:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Try the attached.
Hi billij..
the problem is that...
we can refer the whole column...
as It will result in infinite loop...
give use some limited range.. which we can refer..
Don't forget to click *
Another:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks