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

    Plot a stacked column chart with multiple sets of data

    Hello Everyone, I have searched for a solution to this but I am struggling trying to find a way to plot comparative data on one chart that shows revenues by major customer over several years. More specifically, I am trying to plot each year on a stacked column that shows each of the major...
  2. S

    Relative comparison of two data sets?

    Hello Everyone, I am trying to figure out a way to determine/show the relative improvement of a productivity KPI compared to the increased travel volume on the roads. I have attached a simple example of the type of data I would like to compare. The issue that I am trying to present is that...
  3. S

    Return a dynamic reference to a cell beside a pivot table

    Hello again Everyone, I am trying to find a way to return values in cells beside a pivot table. The data set that the original pivot table draws from does not contain certain data so it is accumulated in a second worksheet. What I want to know is if I can return specific values to match up...
  4. S

    Compare data from one list to another if there are duplicates within the same column

    Hello Everyone, I would appreciate some assistance in trying to identify (highlight preferably) unique values in two columns but exclude values that are duplicates in a column. I did search the site but could only find a solution if there are no duplicates in the same column. Any help is much...
  5. S

    Text formatting & leading dots

    Hello Excel Gurus I am trying to format text with multiple formats and leading dots. I have not been able to figure out if it can be done. I have attached a sample worksheet for reference. If anyone know the trick here, I would be most appreciative. Thanks in advance! Scott
  6. S

    Match multiple columns in multiple lists

    Hello I am trying to match two columns in one list with two columns in a second list. What is the formula to verify this? For example, list 1 has column A(address), column B(bin size) and list 2 has column D(address) and column E(bin size). In list 1, the address could have multiple bin...
Back
Top