Skip to Content
author's profile photo Former Member
0
Former Member

How to sort in xcelsius

Posted on Apr 26, 2011 at 05:46 AM 25 Views

Hi All,

Please give me an idea how to do the sorting in Xcelsius.

Thanks

Sathiya

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2011 at 07:48 AM
    0

    Hi Sathiya,

    Can you be more specific with your question

    You require sorting on chart components or on selectors or you want logic for excel.

    If you want sorting for component level, we have sorting option at component properties.(Behaviour Tab)

    Let me know if you need mroe information on excel logic.

    Correct me if i am wrong on your explanation..

    Regards,

    AnjaniKumar C.A.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Apr 26, 2011 at 12:11 PM

      Hi,

      You can apply LARGE() function for your data.

      LARGE(array, k)

      Where array is your dataset and K is your S.No.

      Note you have to add a column which contains the S.No, as shown below

      
1	300	293
2	78	018
3	141	699
4	74	562
5	35	312
6	14	609
7	1	701
8	3	149

Solution 
	A	B	A-ans	B-ans
1	300	293	300	701
2	78	018	141	699
3	141	699	78	609
4	74	562	74	562
5	35	312	35	312
6	14	609	14	293
7	1	701	3	149
8	3	149	1	18

Solution with formula:

	A	B	A-ans	                     B-ans
1	300	293	=LARGE($J$9:$J$16,I9)	=LARGE($K$9:$K$16,I9)
2	78	18	=LARGE($J$9:$J$16,I10)	=LARGE($K$9:$K$16,I10)
3	141	699	=LARGE($J$9:$J$16,I11)	=LARGE($K$9:$K$16,I11)
4	74	562	=LARGE($J$9:$J$16,I12)	=LARGE($K$9:$K$16,I12)
5	35	312	=LARGE($J$9:$J$16,I13)	=LARGE($K$9:$K$16,I13)
6	14	609	=LARGE($J$9:$J$16,I14)	=LARGE($K$9:$K$16,I14)
7	1	701	=LARGE($J$9:$J$16,I15)	=LARGE($K$9:$K$16,I15)
8	3	149	=LARGE($J$9:$J$16,I16)	=LARGE($K$9:$K$16,I16)

      If you want ascending then you can use

      SMALL() function

      Let me know if you have any issues.

      Regards,

      AnjaniKumar C.A.

      Edited by: AnjaniKumarCasula on Apr 26, 2011 5:42 PM

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.