title: How do I get the column and/or row of a value in a dynamic array, has 30 or 31 columns (depending on which month) and variable rows that are dyna
body: <p>I have a dynamic array... <code>=SEQUENCE(COUNTIF(F8#,&quot;&lt;&gt;&quot;),COUNTIF(G7#,&quot;&lt;&gt;&quot;))</code>
  <code>F8</code> is a list (1 column many rows) of names that changes and is dynamic
  <code>G7</code> is a list (1 row many columns) of days in a month that dynamic changes whether it is 30 days or 31.</p>
  <p><code>(r,c)</code> is like <code>(n,(30 or 31))</code>.</p>
  <p>The array sequentially goes from 1 to y.. depending on the number of rows (i.e. n).  So if I have a list of 13, and it is Jun (30 days), then I have a matrix of 30 columns, 13 rows.  That go from 1 to 30 in row 1.  31 to 60 in row 2, etc...all the way to 390.</p>
  <p>I have a separate column of numbers 1 to 390 (also dynamic).  I would like to apply a logic such that for a particular value in the array <code>r,c --&gt; (13 x 30)</code>, It will return the relative column and/or row.</p>