I am trying to count the number of times a number from the numbers field appears in either num1,num2,num3,num4, and num5

[#1]

I am trying to count the number of times a number from the numbers field appears in either num1,num2,num3,num4, and num5

[Anonymous]

Do you mean this? - attached

[qliksus]

Can you please elaborate your requirement?

Suggestion: Use Pivot chart and use some expression to get your req.

[Anonymous]

Chris

Depending on exactly what you are trying to do a crosstable load something like this may help:

GLoad:

crosstable ( DD , Numbers , 1 )

load

Draw,

    Num1,

    Num2,

    Num3,

    Num4,

    Num5

    from

powerball.xlsx

(ooxml, embedded labels, table is Sheet2);

Best Regards,     Bill