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

    Select Top (x) per category no duplicates

    I'm hoping someone has had this problem before and can help me with a strategy or formula but I have a list of processes and the names of people who have completed those processes and a composite score assigned to each individual. Each person is capable of completing multiple processes and...
  2. B

    Conditional Format Calc vs. In cell Calc

    Has anyone ever encountered this situation... I'm using Countifs formula with named ranges to compare two lists (on separate tabs) to highlight when cells do not match. Generally speaking it works correctly but there are certain instances where the lists match perfectly but the cell is still...
  3. B

    Data Table Fun

    I've got a data table setup based on transaction pricing. Column headers are fees for incoming transactions and row headers are fees for outgoing transactions. The data table is dynamic based on different volume scenarios in the other part of our model. What I want to do is find some way to...
  4. B

    Pivot Table VBA

    I want a simple macro to copy all data below column headers in a pivot table and paste to another sheet. I've tried multiple methods for selecting the data to copy and it always gives me the same error. "run-time error 438, Object doesn't support this property or method." Below is the code. Any...
  5. B

    New to VBA

    I'm really new to VBA and I think I have a pretty basic need but can't quite figure it out. If a row in column 1 has a particular letter (each entry will only be 1 letter) then I want the same row for column 2 to have a certain level on indention based on the letter. I found some code on the...
  6. B

    Formula Errors

    I'm getting an error stating "A formula in this worksheet contains one or more invalid references" but I can't find any formulas or invalid references. I checked "show formulas" and even looked for invalid named ranges but can't find anything. Has anyone ever encountered this and if so how did...
  7. B

    Dynamic sumif formula using column and row filtering

    I'm stumped!! I've tried Sumif, Sumproduct, Offset, Index and I can't seem to figure out to do this. I have a datasheet with multiple columns each with a date heading. I want to add up the data for a particular column based on a reference cell while filtering the sum based on the product type...
  8. B

    Sorting with formulas

    I have a problem that is driving me crazy because I know there must be something simple I'm missing but I'm working on a data sheet for capacity planning that has 29 columns with the intention that it feeds into a pivot table. Here's a breakdown of the setup: Columns A-D contain basic...
  9. B

    dynamic project tracking with scroll bar

    Hoping someone has an easy solution but I've basically created a project gantt chart with each column representing one day. Above each month's dates I have a merged cell that displays the name of the month. For ease of reporting I've created a second tab that shows only 4 months worth of data...
  10. B

    Difference in Timestamps

    I have a column of date/timestamps with each row representing a new entry. I need to determine the difference between row 3 and row 2, row 4 and row 3, row 5 and row 4, etc. Row 2 2/10/10 9:33 Row 3 2/10/10 10:06 Row 4 2/16/10 18:37 Row 5 2/17/10 8:56 Row 6 2/23/10 16:39 Row 7 2/25/10...
Back
Top