Results 1 to 10 of 51

Thread: Specification Comparison Table from Different Worksheets

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Acolyte Polignac's Avatar
    Join Date
    Apr 2021
    Posts
    23
    Articles
    0
    Excel Version
    Office 365

    Specification Comparison Table from Different Worksheets

    Hi everyone, I'm trying to compile a specification table for a product that comes with different models, and I stumble upon on one that exactly matches what I have in mind:


    1st step: choose the 2 products for comparison at https://www.dpreview.com/products/compare/cameras
    2nd step: display the properties of the 2 (or more products) at this result: https://www.dpreview.com/products/co...anon_ixus500hs


    My question is: is it possible to do this in Excel 365? I have the specifications of the different models in different worksheets and what I have in mind is to compare the models on a new worksheet that'll populate the models that I choose.


    Sorry if I'm not making any sense? Thanks everyone.

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,692
    Articles
    0
    Excel Version
    Office 365 Subscription
    There are various ways it could be done.Provide a sample workbook with some dummy data that resembles your real data - 20-30 rows will suffice.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Acolyte Polignac's Avatar
    Join Date
    Apr 2021
    Posts
    23
    Articles
    0
    Excel Version
    Office 365

    Sample dummy data

    Quote Originally Posted by AliGW View Post
    There are various ways it could be done.Provide a sample workbook with some dummy data that resembles your real data - 20-30 rows will suffice.
    Hi there, here's a workbook that resembles what I'm after in the comparison tab, and the specs of individual models of different brands are in subsequent worksheets, if that make sense?
    Attached Files Attached Files

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,692
    Articles
    0
    Excel Version
    Office 365 Subscription
    The attached solution uses PowerQuery to process the camera brand data and produce a composite lookup table and a list of models for the drop-down. The comparison table then uses simple LOOKUP formulae to populate the data. The initial version uses tables and an append query, and the second uses named ranges and the =Excel.CurrentWorkbook() function.

    If this is something you feel you can work with, let me know, and I can talk you through how to set it up. Adding more makes and models would be relatively painless.
    Attached Files Attached Files
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Acolyte Polignac's Avatar
    Join Date
    Apr 2021
    Posts
    23
    Articles
    0
    Excel Version
    Office 365

    Yes!

    Hi AliGW, yes! The output is exactly what I'm after! If you don't mind coaching me through it, I'd really appreciate all the help i can have for this. Thanks!
    Last edited by AliGW; 2021-04-10 at 09:11 AM. Reason: PLEASE don't quote unnecessarily!

  6. #6
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,692
    Articles
    0
    Excel Version
    Office 365 Subscription
    Have a look at the second - it maintains the layout in the individual model pages, however that makes it a little more fiddly to maintain. If you can live with the layout in the first option, I'd go with that.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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