Lesson#57: Simple trick to count rows by color

 Can you count rows by color? Yes It’s very easy and simple. Here I have a data table which has different colors in rows. I have count rows by color by these simple steps. 1. I will add Filter at the columns. 2. Add this formula =SUBTOTAL(2,A2:A52) and this should be on that column where the…

Lesson#44: Simple trick to paste in reverse order

Sometime it needs to paste a list in reverse then a simple trick should keep in mind. Copy the list and paste it. Add an extra column beside this column. Add digits in this column.  Add filter above like shown in picture.  Select  the opposite order of which the digit column is. Here I have selected Sort…

Copyright 2017-2018@Excelabcd