+ Reply to Thread
Results 1 to 11 of 11

Building a Comparison tool... possible?

  1. 12-18-2013, 05:17 AM #1
    txguyg
    txguyg is offline
    Registered User
    Join Date
    12-18-2013
    Location
    Best, Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    8

    Question Building a Comparison tool... possible?

    Hi Guys,

    I was asked to create an Excel version of this sharepoint/infopath thingy I did a while ago. I think that once ready Excel is much better suited for a thing like this, but I never did anything with advanced layouts and such in Excel.
    Is this possible to do? What are my keywords to search?

    (screenshot attached)

    Many thanks!

    short explanation:
    you can select 3 products and put them side by side. When you select a product it pulls in the data for that product from another list. Data labels in the blue column.
    The three dropdown boxes are used for filtering products. (select a brand, select a type, and then the third dropdown box only shows products with that brand and type)[img]284810[/img]
    Attached Images Attached Images
    Last edited by txguyg; 12-18-2013 at 05:59 AM.
    Reply With QuoteRegister To Reply
  2. 12-18-2013, 05:55 AM #2
    Olly
    Olly is offline
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Is this possible in Excel?

    Perfectly possible. Data validation, dynamic named ranges, lookups, filters... there are several ways it could be done, depending on your data structure and specific outcome requirements.

    Worst thread title and attachment EVER, though.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...
    Reply With QuoteRegister To Reply
  3. 12-18-2013, 05:57 AM #3
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: Is this possible in Excel?

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Reply With QuoteRegister To Reply
  4. 12-18-2013, 06:01 AM #4
    txguyg
    txguyg is offline
    Registered User
    Join Date
    12-18-2013
    Location
    Best, Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Is this possible in Excel?

    Thanks guys. Title changed... Just want to solve my problem here.

    What information do you need from me? Unfortunately I can't share a screenshot that contains actual data .
    Reply With QuoteRegister To Reply
  5. 12-18-2013, 06:04 AM #5
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Building a Comparison tool... possible?

    Hi and welcome to the forum!

    What's going on with that attachment? Does the "blurred" in the filename suggest you knew it was actually of that quality, but decided to post it anyway? If so, and looking at it again, how would you rate that picture in terms of its effectiveness at supporting your query?

    Kindly attach an actual spreadsheet.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  6. 12-18-2013, 06:11 AM #6
    txguyg
    txguyg is offline
    Registered User
    Join Date
    12-18-2013
    Location
    Best, Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Is this possible in Excel?

    Quote Originally Posted by OllyXLS View Post
    .

    Worst thread title and attachment EVER, though.
    Thank you for the constructive critisism

    Please feast your eyes on a new screenshot.Drawing1.png
    Reply With QuoteRegister To Reply
  7. 12-18-2013, 06:14 AM #7
    txguyg
    txguyg is offline
    Registered User
    Join Date
    12-18-2013
    Location
    Best, Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Building a Comparison tool... possible?

    Hi Xor

    My question is about rebuilding something that's not a spreadsheet into a spreadsheet, so I can't attach one for you. For the moment I can only add visualisations of the problem

    Thanks!
    Reply With QuoteRegister To Reply
  8. 12-18-2013, 06:15 AM #8
    Olly
    Olly is offline
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Is this possible in Excel?

    Quote Originally Posted by txguyg View Post
    Thank you for the constructive critisism

    Please feast your eyes on a new screenshot.Attachment 284826
    Still doesn't help. It gives no clues as to your data structure / hierarchies / location / content. We could be here all day offering vague suggestions which may or may not match your data.

    Attach a workbook please, which clearly demonstrates what data you have, and what your desired outcome is.
    Reply With QuoteRegister To Reply
  9. 12-18-2013, 06:39 AM #9
    Kyle123
    Kyle123 is offline
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Building a Comparison tool... possible?

    Something like this maybe?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 12-18-2013, 06:47 AM #10
    txguyg
    txguyg is offline
    Registered User
    Join Date
    12-18-2013
    Location
    Best, Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Building a Comparison tool... possible?

    Quote Originally Posted by Kyle123 View Post
    Something like this maybe?
    That is exactly it!!!! You are a genious, thank you very much!
    Reply With QuoteRegister To Reply
  11. 12-20-2013, 06:57 AM #11
    txguyg
    txguyg is offline
    Registered User
    Join Date
    12-18-2013
    Location
    Best, Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    8

    Thumbs up Re: Building a Comparison tool... possible?

    This works very well, however there is one problem: I'm building this tool to show in a Sharepoint page. For reasons unknown to me, Sharepoint does not support data validation (used for the dropdown list) in their Excel web part.
    Would anyone be able to dish up an alternative?

    edit - nevermind solved.
    Last edited by txguyg; 12-20-2013 at 07:05 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1