• 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. M

    Base Line On Line Graph

    Good morning all, Firstly I love the new forum! I am having a problem with a line graph I am creating. Basically, I am creating a line graph to track costs for certain items. What I need is to be able to create a straight line that will always sit at £10,000 on the line graph. So if an...
  2. M

    Index And Match [SOLVED]

    Good day all, I am trying to use Index and match to achieve a kind of reverse v look up. What I need is to pull out what information is in column A on sheet 1, if what is on sheet 2 column C is found. So it looks through Sheet 1 Column C to find what is in Sheet 2 C1, then makes Sheet 2 A1...
  3. M

    Check For Duplicates Over Several Sheets

    Good morning all, We currently have an excel document that is used by three people, who work on three seperate sheets. It is a shared document, so it updates each time the user saves with the changes from the other users. One thing we are having a problem with is duplicate information. What...
  4. M

    Bring To Front Macro

    Good afternoon, I currently have two web browser objects on a spreadsheet. WB1 is covering WB2 as WB2 has an advert at the bottom, and the way they are now, WB1 covers WB2's ad, while its add is off screen. One of the problems I have is that on occasion, WB2 will load on top of WB1. I want...
  5. M

    Dynamic Charts In VBA?

    Hi Chandoo, I was just wondering if anyone knew a way that a chart like this: http://www.highcharts.com/demo/line-ajax (data points highlighting on mouse over) was possible in Excel 2007? Either by including Javascript, or by writing it in VBA? Many thanks, Mike
  6. M

    Covering Part Of A WebBrowser Object?

    Hey all, I am currently using a web browser object to display a website within my excel spreadsheet. The problem I am having is the website has advertisements, that (like all things on the internet) can be nsfw. Is there a way to cover the bottom of a web browser object, with say a solid...
  7. M

    Check If Entry Exists: If Yes, Update. If No, Create?

    Hey all, I have quite a particular problem and I'm sure you guys can help. I did run a search, however its quite a specific problem so I wasn't able to get any hits. The problem is as follows: We have raw data entered into a sheet called "Data". This information is updated weekly, and tracks...
  8. M

    Most Common Text Value

    Hi all, Just a quick question (I have done a search, and wasn't able to find a working finished post) about finding the most common text value in a column? For example, I have column J, the entirety of J (can sometimes be 1-100, sometimes 1-500) filled with varying strings of text. Job...
Back
Top