Skip to main content
lvl10720-Turquoise
20-Turquoise
September 28, 2010
Solved

Rows_Gathered_Count.

  • September 28, 2010
  • 23 replies
  • 9196 views

Hi,
With intuition, I need help to write a function (in Mathcad 12) was briefly described as following:

Rows_Gathered_Count_1.PNG

In other words,

Rows_Gathered_Count_2.PNG

Thanks in advance.

-LL-

Best answer by AlvaroDíaz

Some kind of explanation added.

Regards. Alvaro.

23 replies

RichardJ19-Tanzanite
19-Tanzanite
September 29, 2010

Column 1 of the output is the number. Column 3 is the number of occurrences. What's column 2? Sometimes it seems to be the index of the first occurrence, sometimes the index of the second.

lvl10720-TurquoiseAuthor
20-Turquoise
September 29, 2010

Sorry, Richard. I forgot to generalize my question.

Rows_Gathered_Count_3.PNG

-LL-

MikeArmstrong1-Visitor
1-Visitor
September 29, 2010

Loi,

There is no consistency in your answers.

I assume "L" is being called because it sits adjacent to the last time 0.968 occurs - If this is the case why had 0.981 got the letter "F"next to it. Shouldn't it be "O"

Mike

AlvaroDíaz12-Amethyst
12-Amethyst
September 29, 2010

Similar to

http://communities.ptc.com/message/152543

Please check the attached.

Regards. Alvaro.

lvl10720-TurquoiseAuthor
20-Turquoise
September 29, 2010

It's a neat answer. Thanks a lot. Sorry, I forgot to generalize my question, above.

-LL-

AlvaroDíaz12-Amethyst
12-Amethyst
September 29, 2010

Don't worry. Generalization added. Also use first or last letter in the answer. In your picture, letter for 0.981 is "F" or "O"? Notice that the csort at the end is optional.

Regards. Alvaro.

Terms & ConditionsAccessibility statement