Home > Blockchain >  How To Add The Ordinal Count To Values Set In Horizontal Non-Contiguous Ranges In Google Sheets With
How To Add The Ordinal Count To Values Set In Horizontal Non-Contiguous Ranges In Google Sheets With

Time:12-31

Problem:

I'm trying to add each ordinal reference to a set of repeating values in each cells just above each value.

The values are organized in horizontal and non-contiguous order.

The illustration example I show below is simple for testing purposes, but the end use should be for hundreds of values/ranges, so it would be optimal to use a script or a simplified version of the formula I found.

Illustration Example:

Ordinals from Non-Contiguous Ranges

Other Related Question and Solution:

I found that question and answers that address the same question but for vertical and contiguous values using the following formula as solution:

=COUNTIF(A$1:A1,A1)

=COUNTIF(A$1:A1,A1)&MID("thstndrdth",MIN(9,2*RIGHT(COUNTIF(A$1:A1,A1))*(MOD(COUNTIF(A$1:A1,A1)-11,100)>2) 1),2)

output

Note:

  • The range that is to be passed assumes that the first row should be the first range, not a blank one. And also the last row of the range should contain the last row of the data.
  • Any unrelated data should be starting with - on the first column so it can be allowed without processing it.
  • Related