+ Reply to Thread
Results 1 to 3 of 3

Complex data set, trying to identify to find needles in haystack

  1. #1
    Registered User
    Join Date
    04-21-2015
    Location
    London
    MS-Off Ver
    Windows 7 Profressional
    Posts
    2

    Complex data set, trying to identify to find needles in haystack

    I have a fairly large data set that I’m looking to analyse - and it’s way beyond what I’m able to do..

    I would like to be able to find out, which ‘Global Brand/ ‘Market’ had the largest increase in a given measures over time.

    For example, in this data set, which brand was able to generate the largest jump in Consideration. This would then show me the years over which it made the jump, (e.g. 2009-2013) as well as where it was located (e.g. Brazil).

    Ideally I would like to be able to do this for all 5 measures (Presence, through to Bonding) – but would be more than happy with just one – ‘Consideration’ for now.

    I'm hoping that if there's anyone that can help with this they are for sure on this forum. I have tried a lot of people already with no luck...

    Thanks in advance!

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,077

    Re: Complex data set, trying to identify to find needles in haystack

    Can you post some example data?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    04-21-2015
    Location
    London
    MS-Off Ver
    Windows 7 Profressional
    Posts
    2

    Re: Complex data set, trying to identify to find needles in haystack

    Thanks for replying Special K.

    Data sample at the link here, I have had to tweak the figures btw, these are not actauls.

    https://app.box.com/s/bhqyz04tnymr3y3xh0muxzj3womxav53

    It is about 10% of the total data I have.

    Thanks for taking a look.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find particular data from complex data string by macro
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-07-2014, 01:24 PM
  2. Find and identify duplicate data across multiple workbooks
    By raw_geek in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-23-2013, 02:27 PM
  3. Excel 2007 : finding a needle in a haystack
    By niruban in forum Excel General
    Replies: 1
    Last Post: 12-28-2010, 08:10 AM
  4. [SOLVED] How to find a needle in a haystack?
    By ScottJSP in forum Excel General
    Replies: 2
    Last Post: 02-04-2005, 10:34 AM
  5. Replies: 1
    Last Post: 01-04-2005, 10:06 PM

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