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

    vlookup from columns to row

    Thanks to both of you; both solutions work well.
  2. C

    vlookup from columns to row

    I have 2 files; one has volume data by invoice month setup in rows. The other file contains the net price setup in columns. I want to bring the net price into the volume file based on product/contract/invoice month. How? I've attached an example file. Appreciate any help!
  3. C

    formula to omit errors

    Thanks everyone, I appreciate all your suggestions.
  4. C

    formula to omit errors

    I am comparing month vs. month volume sales for 4 months. When there are numbers greater than zero in all columns everything works fine. The problem is when one or more months are zero. If current month is 24 and prior month is zero, I'd like the result to be 100.0% If current month is zero and...
  5. C

    Pivot Table options are grayed out

    Hallelujah!!! Thank you so much!
  6. C

    Pivot Table options are grayed out

    Ok, here's the file (there were hidden tabs that were making the file so big)! If you filter the rows to just Brand 4, I no longer have a 3 month trend in column S. How to I keep all 13 months in the table?
  7. C

    Pivot Table options are grayed out

    Unfortunately, that didn't make it smaller. The section I am referring to is below: Show items w/no data on rows Show items w/no data on columns
  8. C

    Pivot Table options are grayed out

    I checked the format of the dates, no blanks, no zeros. Still doesn't work.
  9. C

    Pivot Table options are grayed out

    I am using 2016. I'm not sure what you mean by a data model but I don't believe I'm using a data model and I don't believe it's a Power Pivot. Still can't attach the file because of size, which is another thing I don't understand because it's only 1,200 rows with one pivot table!
  10. C

    Pivot Table options are grayed out

    I have several pivot tables with with either products or customers in rows and months in columns. Outside of the table, I have various calculations, 12 month trend, 3 month trend, current month compared to trends etc. If I filter my row to a certain product that does not have data in all columns...
  11. C

    Rebates paid early or late - how many days?

    Your solution is not exact but has given me some ideas to work with, thank you!
  12. C

    Rebates paid early or late - how many days?

    yes, that is correct
  13. C

    Rebates paid early or late - how many days?

    I've attached a workbook containing data and pivots. My organization is trying to identify how much we could have saved (if anything) by paying customer rebates according to the contract rather than paying earlier (or later) than contract terms. I show in the pivots that we would have paid close...
  14. C

    Show Month in a column based on a MM/DD/YYYY in another

    great, thank you.
  15. C

    Show Month in a column based on a MM/DD/YYYY in another

    I have a column of dates formatted MM/DD/YYYY. I want to create another column that will state that date as just the month. Such as, 2/15/2016 would be Feb, 3/23/2017 would be Mar etc.
  16. C

    Unable to add or delete sheets

    Checked with my IT dept; we are not able to download the add-in. Thanks for your time!
  17. C

    Unable to add or delete sheets

    Sub PasswordRecovery() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To...
  18. C

    Unable to add or delete sheets

    2016
  19. C

    Unable to add or delete sheets

    I've dug a little further, it looks like there is another password protecting the workbook, however, the usual password we use is not working. I found a VBA code on the internet that should recover the password but that's not working either.
  20. C

    Unable to add or delete sheets

    I'm reluctant to attach the file because it has confidential info (customer pricing) in it. Yes, it is password protected.
  21. C

    Unable to add or delete sheets

    We have an existing workbook that we have been able to add and delete sheets to in the past. Today we are unable to do so. When we right click on a tab almost everything is greyed out. Please help!!!
  22. C

    Inventory allocation

    Great, it worked perfectly. Thank you!
  23. C

    Inventory allocation

    We have 3 products with more quantity in Open Orders than On Hand. We already allocated quantity by customer ship-to but then realized most customers had more than one order. We need to tell customer service how much to release against each order. I've attached a file showing the orders on the...
  24. C

    Nested formula help

    Narayan, thank you, that formula worked!
  25. C

    Nested formula help

    Thanks David. Unfortunately working with tables is completely new for me. I tried to replicate what you did but it's not working for me. If anyone has another solution I'd greatly appreciate the help.
Back
Top