It returns TRUE when the given value is even, and FALSE if it is odd. The ISEVEN function is used to check if a numeric value is an even number. Let’s assume you again have your list in cells A1:A50.Ĭopy the following function into cell B1. After that, repeat the same procedure as shown above.Īlso read: How to Select Every Other Row (Alternate Row) in Excel? Method 2: Using Filters This will ensure that there is a number only every nth row. ![]() Note: If you want every third, fourth or nth cell selected, simply place a number in the first row and a letter in every n-1 rows below it. That means we want the range A1:A50 activated. In our case, we specified the offset function to activate the range that is 0 rows and -1 columns away from the range B1:B50. The Offset function is used to activate the range that is a particular number of rows and columns away from a certain range. When you run the above macro code (Developer –>Macros –>SelectAlternateCells –>Run) you will see alternate cells of Column A selected.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |