Bug in Worksheet

[FlyingKiwi]

I have two worksheets attached. The worksheet called "Issue1" gives the final array's as a single number (Equal_Count and LessThanCount). The other worksheet called "array count comparison - Ver 2" gives array's for the array's as I would have expected inthe Issue1 worksheet. Would anybody please let me know what I am doing wrong?

Thanks,

Matt

[VladimirN]

Hello!

I corrected the file "Issue_1". See attachment.

[FlyingKiwi]

Hi Vladimir,

Any chance you could save your solution in another version of MathCAD. I am currently using MathCAD 13. And thank-you for looking into this wee issue for me. It was driving me mad!

[MikeArmstrong]

How did you upload the worksheet in the first place?

Mike

[MikeArmstrong]

I have attached the worksheet you require in M11 format.

A quick note:- Your worksheet doesn't seem to make sense.

For example your have a function which is meant to count the number of times z occurs in x, but all you return is the count output, surely you would require to know which value of that the count corresponds to.

[FlyingKiwi]

Thanks Mike. What did you change to make Issue_1 work? Is it in the way I have set-up the worksheet?

As for knowing what value the count is attributable to, I was just going to augment them together. z is the array of distinct values that I am comparing with the array of all data values which may have repeats. When I count how many values are the same or how many values are less, both are based on z and will have the same row index. That's why I thought I could just augment them together. Perhaps not very elegant but it works. I am always open to better ways of doing things though.

Thanks for your help and expertise.

Matt

[FlyingKiwi]

Mike, I found what you changed. Sorry about that.

[MikeArmstrong · Accepted solution]

That's why I thought I could just augment them together. Perhaps not very elegant but it works. I am always open to better ways of doing things though.

Thanks for your help and expertise.

Matt

Yes that is a valid option and would work, but what if there is zero (condition not met). Are you still happy to show the corresponding value even though the condition hadn't been met?

Just a thought.

Mike

[VladimirN]

Matt,

I attached a file for Mathcad 13.