+ Reply to Thread
Results 1 to 1 of 1

Thread: Displaying results in a column using a user forum

  1. #1
    Registered User
    Join Date
    06-16-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    40

    Displaying results in a column using a user forum

    I'm creating an worksheet in excel 2007. I need to display the results in column J using this array formula "=IF(AND($A$2:$A2=A3,MATCH(F3,F:F,0)=ROW())(20-(SUM($G$2:$G3)))/20,INDEX(J$2:J2,SMALL(IF(F$2:F3=F3,ROW(F$2:F3)),COUNTIF(F$2:F3,F3)-1)-1,1)-I3)".

    This calculation is dependent on several columns entries. I want to show it in a specific format. In column F I've created a user forum with several items. If I select more than an option in column F, the results has to be displayed accordingly both in column I & J accordingly.

    Lets say I select the entries abc, xyz in F2. Then after the calculation in column I & J, I want the results to be displayed in the following format:

    In I2:
    abc: 50% ; xyz = 50%;

    In J2:

    abc : 50% ; xyz = 50%;


    Please note that the value 50% is just a dummy value used to show an example and not a result of actual calculation.

    Is it possible to achieve this using macros easily?
    I've attached the excel for reference.
    Attached Files Attached Files
    Last edited by daymaker; 07-13-2011 at 11:50 PM. Reason: no solution provided

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0