+ Reply to Thread
Results 1 to 5 of 5

data in 2 column and display the desired result in 3rd column

  1. #1
    Registered User
    Join Date
    01-02-2013
    Location
    in
    MS-Off Ver
    Excel 2007
    Posts
    11

    data in 2 column and display the desired result in 3rd column

    hi,

    i need help on the following:

    i have lot of data that contains width and height for ex:

    A B C
    1 120 60 Button
    2 120 120 R/H Button
    3 468 60 Banner
    4 300 250 MPU

    is it possible that with the help of any command in excel that i am able to display values mention in the column C. doing this manually is hectic task. i have already applied dropped down list but looking for some better solution on this??

    thanks

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: data in 2 column and display the desired result in 3rd column

    Does the attached work? put width and height in H2 and K2 respectively, and column C is displayed in N2.
    Attached Files Attached Files
    Please click the * icon below if I have helped.

  3. #3
    Registered User
    Join Date
    01-02-2013
    Location
    in
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: data in 2 column and display the desired result in 3rd column

    Thanks a lot for your reply, unfortunately it does not work.

    please see attached excel. this is how i need it for report.

    may be after viewing the attachment you may be able to help..
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: data in 2 column and display the desired result in 3rd column

    Using the same principle, does the attached work?
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-02-2013
    Location
    in
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: data in 2 column and display the desired result in 3rd column

    thanks a ton.. Melvin.. it worked ...

    thanks ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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.6.0 RC 1