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

  1. P

    Formulas to Avoid Loops?

    Thanks, but the problem was not that I had changed the data. The answers that I was getting when I was trying to apply this formula to a much larger data sets (over 400 rows and 70 columns) were wrong, with static data. The data is not going to change because I am dealing with historical data...
  2. P

    Formulas to Avoid Loops?

    Thank you! Unfortunately, even with absolute references, the formulas don't work properly with the large set of data, returning values that have 0's in the original data sheet
  3. P

    Formulas to Avoid Loops?

    Thanks! I have 365 both at home and at work. Unfortunately, the formula didn't work with the large set of data. Do you think I can have column references, i.e., instead of Data!$B$2:$J$9, Data!$B:$J ;and instead of Data!$A$2:$A$9, just Data!$A:$A? Also, in the first part of the example, the...
  4. P

    Formulas to Avoid Loops?

    Also, is it possible to reference the entire columns because my actual data sets includes hundreds of rows and dozens of columns? Thanks again!
  5. P

    Formulas to Avoid Loops?

    Hi Naresh, Once again, thanks for such a fast and efficient reply. Just one quick question (again, sorry - my apologies, I haven't used the AGGREGATE function in years), but when you get a chance, could you please explain the role of a slash "/" in the formula? Thank you!
  6. P

    Formulas to Avoid Loops?

    Thank you!
  7. P

    Formulas to Avoid Loops?

    Hi Naresh, It certainly does - thank you very much!
  8. P

    Formulas to Avoid Loops?

    Hello, I have a list of participating stores and products that the company carries (please see attached - it's highlighted in yellow). Not all stores have all products available. What I need to get is a list of available products for each store displayed next to the name of the store (no lbs)...
  9. P

    Help with INDEX/MATCH

    Thank you all for your input, it's greatly appreciated! I will have to go with SUMPRODUCT. I am well versed in Pivot tables (and love those), but the trick was to create something that was not dynamic and could not be refreshed/updated by other users. SUMPRODUCT should work for this example...
  10. P

    Help with INDEX/MATCH

    I understand that INDEX/MATCH might not be ideal as it's looking for the first column that matches the description. The company frowns upon using macros, so apart from that, what formulas can I use to cover all the columns in the range?
  11. P

    Help with INDEX/MATCH

    Hi guys, got stuck with the INDEX/MATCH functions, getting an incorrect result. Need to get a summary by product type by region in the example below (combined number of units of fruit and vegetables for both regions). When I added =SUMIF($B:$B,"Fruit",((INDEX($C:$H,,MATCH($N2,$C$1:$H$1,0)))))...
  12. P

    Need Help with Data Summary

    Hello... Here is a very condensed version of what I am trying to accomplish here. Several workers are assigned to several ongoing projects; their time is fully allocated in cells B2 through G4. 1) How I give their manager a summary similar to what I have in cells B12 through D14 without...
  13. P

    Enhancing SUMPRODUCT for am Additional Criterion

    Does it work with absolute column references in 365? Just tried it in my real-life example and got the #VALUE error again :(
  14. P

    Enhancing SUMPRODUCT for am Additional Criterion

    Wonderful - thank you very much!!!!!
  15. P

    Enhancing SUMPRODUCT for am Additional Criterion

    Hello, The attached spreadsheet contains 2 tabs. Sheet1 is the original example where we got the summary of sales by region by distribution channel. Part 2 (red) is the same example, but with an additional criterion. I had to separate products by Type (Meat and Produce) and get the answer for...
Back
Top