Forum Discussion

kheldar's avatar
kheldar
Iron Contributor
Jun 10, 2022

Filter Function Skip Every 9 Cell

Hello,   I need the result array of this filter formula to skip every 9 cell for the sake of argument.       =FILTER(Bucket[Name],Bucket[DM]=C1)       Let's assume the formula is in A...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 10, 2022

kheldar 

Perhaps

=LET(
  f, FILTER(Bucket[Name],Bucket[DM]=C1),
  n, SEQUENCE( ROWS(f)*9 ),
  IF( MOD(n-1,9)+1 =1, INDEX( f, INT( (n-1)/9) +1 ), "") )

Resources