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

Recent content by cubs610

  1. C

    Help with returning data averaging x rows returned

    Awesome, and thanks for your help!!!
  2. C

    Help with returning data averaging x rows returned

    Hmm... interesting as to why that happened. I went back and changed the format to numbers. Sorry about that, and I truly appreciate your help. :)
  3. C

    Help with returning data averaging x rows returned

    Ach... my bad! Sorry forgot to upload it. :(
  4. C

    Help with returning data averaging x rows returned

    I have a list: multi column and multi rows in an excel sheet. The first column is TIME in seconds with a unique number on each line. The last column is called STEP (as a number from zero and up). Each STEP has a different number of rows (time at a data point which varies) that corresponds to a...
  5. C

    Looking for simple VLOOKUP (?)

    Hey @GraH - Guido -- that does it!! Many thanks! -Dave
  6. C

    Looking for simple VLOOKUP (?)

    Hello all, This one should be easy, yet for some reason I get the feeling I'm overthinking it and would love to get your thoughts. Here is what I'm trying to accomplish. On the attached spreadsheet, I would like the answer in B11 to inform the cell C11. However, I’m trying to write ranges...
  7. C

    IF or NESTED IF? Not sure, could use a hand

    @Peter Bartholomew Thanks! I appreciate your effort. You Rock!
  8. C

    IF or NESTED IF? Not sure, could use a hand

    Hello All, I could use a hand with building a formula. I'm teetering between two distinct IF statement, or perhaps a nested IF (?). Here is the issue. We are given the sheet with product cost and MSRP. Our prices are 40% margin above cost (cell/0.6), which gives us our web retail price. We...
  9. C

    IF statement formula structure help

    Hey GraH, Yeah... I gotta admit it was the end result of a hurried conversation of which I wrote down what the powers that be are looking for. I'll take a peek at your suggestion. Many thanks! -Dave
  10. C

    IF statement formula structure help

    Hello All, To make things easier attached is a spreadsheets with comment to help spell things out. In short here is what I'm looking to solve. We work with a product list that lists many columns, of which the key one are: wholesale, retail, our price and displayed. The our price and...
  11. C

    PowerPivot Calendar Table Question

    @Narayan and @Chihiro Awesome and thank you!! -Dave
  12. C

    PowerPivot Calendar Table Question

    Hello All, I just started studying PowerPivot and for the most part can grasp the data modeling since it's similar to Access. The one question I have pertains to calendar (date) tables. The one thing I really don't understand is why do you need to create a separate calendar table in the first...
  13. C

    Help with IF statement within Table

    @Chihiro -- Thanks so much and to answer your question, no I have not read the article. I'll give it a glance when I have a moment. Thanks! -dave
  14. C

    Help with IF statement within Table

    Hello All, I thought this would be easy, yet I'm missing something. The attached file uses a table and my understanding is the Excel table formula structure are a little different. What I'd like to accomplish is, if either cells G2 or H2 are blank then leave cell I2 blank. I know there is...
  15. C

    Seeking help adding up unique zip codes

    Hah!! Nice One! ;) All the best, Dave
See more
Back
Top