Can't believe I've never noticed you can sort by column as well as row in Excel - thanks for the info. Great idea to use the MOD formula to come up with the number sequence too.
Thank you for this video. It helped me clear blank rows. I used the ISBLANK function to identify the blank cells and BOOM! Worked like a charm. Thanks again.
Could you make a video on how to create a formula that references data in alternate cells (this will most likely be helpful when referring to VLookUP tables). Many thanks.
Nice to see the application of the formula. But before seeing this I used to create a column in just left of my data range and then manually put the value "YES, NO". Then double click on the cell below corner to make a copy of these "two cell values" up to the end of my desired range column. After then I could easily apply DATA FILTER and select YES to get my desired rows. If I need to delete every 3rd row, then I create and copy "YES, NO, NO". Then drag these three cell values up to the end. After then you can easily apply DATA FILTER. Why would I memorize the critical formula again and again;)
Can't believe I've never noticed you can sort by column as well as row in Excel - thanks for the info. Great idea to use the MOD formula to come up with the number sequence too.
Hi Sumit.. great video. Thanks for the useful tips and also the VBA code. Thumbs up!!
Thank you for this video. It helped me clear blank rows. I used the ISBLANK function to identify the blank cells and BOOM! Worked like a charm. Thanks again.
Awesome video. By far the best on the topic. Thanks!
Thank you, this will be very helpful as i get a large data with duplicates.
This is so freaking clever!
Really excellent video, thanks very much.
Thank you so much you saved me so much time
Thank you ! This really helped me!
Thank you
Love your work
Great Video! thanks a bunch.
Lovely video. Thanks Sumit
Thxx in abundance....your vdo tutorial is very useful for my jobbb :)
Excellent bro
Very helpful
Kindly make a video for inserting a row after every even row
thank you sir
wonderful
Could you make a video on how to create a formula that references data in alternate cells (this will most likely be helpful when referring to VLookUP tables). Many thanks.
Nice vid
Thank you.
Nice to see the application of the formula. But before seeing this I used to create a column in just left of my data range and then manually put the value "YES, NO". Then double click on the cell below corner to make a copy of these "two cell values" up to the end of my desired range column. After then I could easily apply DATA FILTER and select YES to get my desired rows.
If I need to delete every 3rd row, then I create and copy "YES, NO, NO". Then drag these three cell values up to the end. After then you can easily apply DATA FILTER. Why would I memorize the critical formula again and again;)
thanks a lot
Glad you found the video useful!
How to delete rows containing specific names? For example, how to delete rows having John and Xin?
One way I can think of is to filter based on these names, delete all the filtered rows and remove the filter
@@trumpexcel that would be tedious work. Bcas I wanna delete rows of 50+ names.
hi, only if I select 4 columns, does it execute the code. otherwise, it doesn't. My range in a couple hundred
i used the method with the 1s and 0s instead and I got it!
👌👍👍👍👍👍