so if what i understand is correct, try this array formula:
=IF(MIN(MOD(ROW(INDIRECT(C1-2&":"&C1)),4)),"no","yes")
you have to paste the formula inside the formula bar & press CTRL + SHIFT + ENTER
so if what i understand is correct, try this array formula:
=IF(MIN(MOD(ROW(INDIRECT(C1-2&":"&C1)),4)),"no","yes")
you have to paste the formula inside the formula bar & press CTRL + SHIFT + ENTER
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks