• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    Need some input

    All working well now. Turns out it was a lot easier than I first imagined. C.
  2. C

    Need some input

    Hi there everyone. I track multiple Adwords accounts and look at data on a daily/weekly/monthly level. So I am always looking for interesting ways of simplifying what I'm looking it, but still getting the best possible results. But usually simplifying means doing a few complicated things first...
  3. C

    Charting for a new dashboard

    Thanks for the reply. When I uploaded the doc to Google it didn't take into account the different sheets, each of them represent a different market. Sorry for the confusion. I uploaded it again, but converted the format this time...
  4. C

    Charting for a new dashboard

    Hi there, I manage a number of Adwords accounts for a large online travel agency. And I've built a fairly rudimentary dashboard for each market, now I would like to bring all of those markets together in one dashboard with dynamic data that can be shifted between market and timeline. Another...
  5. C

    VLOOKUP in a formula

    I quickly made a dataset in Google Docs: https://docs.google.com/spreadsheet/ccc?key=0AjOf1rWqZkz2dEVOQ3JrTWpIbU15VTA2c0I4a2txUGc
  6. C

    VLOOKUP in a formula

    I am trying to run a comparison formula on a set of data from Google Adwords. In one worksheet, "adgroups_data" I have data relating specific to ad groups over a 90 day period, in another worksheet, "sqr_data" I have the specific keyword data with all of the accompanying data, including the...
  7. C

    Unique Identifier based on values in sheet

    Worked perfectly, thanks. This is the first step in me pooling all the data so that my weekly data can be combined to create a working, dynamic dashboard that can call custom date ranges and compare a variety of metrics.
  8. C

    Unique Identifier based on values in sheet

    Hi there everyone. I import data on a weekly basis, and create reports on the data every week. But I would like to collate all of my weekly data into a bigger pool of data so that I can pull them into reports later down the line. My first step would be to create a unique identifier for each...
  9. C

    Hello .. Introduce yourself

    Hi there everyone. My name is Charl and I am from Cape Town in South Africa. I am hoping to expand my knowledge of Excel and share what I can with the community.
Back
Top