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

    Extract dates in order (news to oldest) that meet criteria (e.g. name)

    Please upload a sample file to help us help you...
  2. PaulF

    Deleting Empty ROWS - Between 2 worksheets

    Turn your data into a table > CTRL-T (Yes to headers) Date Tab >> Get Data from Table Select Sales Date Pull Down and deselect 0 Close and Load Done: Takes about 10 seconds... (maybe :-P ) Keep Calm and XL ON !!
  3. PaulF

    Lookup problem

    =INDEX($A$1:$A$8,MATCH(E1,$B$1:$B$8,0))&E1 ^^ Works.... but your have 2 number 112's... For vlookup and/or index/match you will need to have unique values in column b.
  4. PaulF

    Dependent data validation drop down list

    Please see attached... I use this method for a little eBay business that my daughter has. Column E is the Indirect formula that you were asking about. In the Variables tab there is a category list, then a table and named range for every category on that list. I then have separate spread sheet...
  5. PaulF

    formatting question

    Date are a serial number starting with 1 = 1/1/1900 so 42,165 dates after 1/1/1900 = 6/10/2015
  6. PaulF

    find remaining months.

    =DATEDIF(D2,B2,"m")
  7. PaulF

    Looking for help on combining data validation and conditional formatting for resource tracking

    I would turn this into a tabular data set from your existing matrix format. That would make all of your calculations easier and allow you to use pivot tables for most of what you will need.
  8. PaulF

    Plot date in calendar

    You will require VBA to utilize a clicked cell to action. What have you tried so far?
  9. PaulF

    Plot date in calendar

    L26 =COUNTIFS(tblCourse[Start Date],">="&DATE($AN$5,1,1),tblCourse[Coruse Type],Settings!$D$5) T26 =COUNTIFS(tblCourse[Start Date],">="&DATE($AN$5,1,1),tblCourse[Coruse Type],Settings!$D$6) AA26 =COUNTIFS(tblCourse[Start Date],">="&DATE($AN$5,1,1),tblCourse[Coruse Type],Settings!$D$7)
  10. PaulF

    Plot date in calendar

    You are trying to SUM a text range... You need to count... D26 =COUNTIFS(tblCourse[Start Date],">="&DATE($AN$5,1,1),tblCourse[Coruse Type],Settings!$D$4)
  11. PaulF

    Excel formula help

    I sure can... Once you have the sequence set on the Source page, we can use the formula in "C" to start: We start by looking at: ROW(A1) - ROW(celREF) will return the ROW# Portion so A1 = 1, A2 = 2, we can use this in formulas to get a sequence of numbers to lookup. We use this ROW(A1) = 1 as...
  12. PaulF

    Excel formula help

    Hazra Hadee, Take a look at the file I uploaded for you. I added a helper column and used a ROW() MAX() combination to sequence your Admins for lookup. I named the table and added a named range of cntAdmin (look in name manager). On the lookup page there is a combination of index/match to...
  13. PaulF

    how to write a transpose formula

    Select cells: B5:B9 set your formula to: =TRANSPOSE($B$2:$F$2) and press Ctrl-Shift+Enter
  14. PaulF

    IF & AND

    =IF(AND(E2<> "Closed",LEFT(B2,2)="DC"),"Active Queue",IF(LEFT(B2,2)="CM",AM2,IF(LEFT(B2,2)="NS",AM2,B2))) Your quotes around Closed were some strange non-quotes... You syntax for your and statement wasn't correct... Check the changes... I did NOT check for accuracy to meet your requirements...
  15. PaulF

    Pivot Table Subtraction Question

    Std PivotTable from Table as source.
  16. PaulF

    Matrix to List (DataBase)

    Good clean data upfront is the key... I need to add some checking / data cleansing with the project and the client. Thank you again Chihiro !!
  17. PaulF

    Pivot Table Subtraction Question

    Hello all! I have a Database (list) that contains projection and actuals and can get a nice subtotal as needed. I would like the grand total to be the difference between the subtotals, not the sum... Am I blind or ?? Respectfully, PaulF
  18. PaulF

    Matrix to List (DataBase)

    Run lightning fast... There are 8,288 entries in the 1/1 to 1/31 matrix, but the results of your script is 8,276 I'm looking at the differences now to see what I determine...
  19. PaulF

    Matrix to List (DataBase)

    HOLY SCHNIKEYS BATMAN !! I have sooooo much to learn... thank you...
  20. PaulF

    Long row formula

    Add some new data and or delete the formulas...
  21. PaulF

    Long row formula

    Check out attached file and see if this works for you. Any edit on Sheet2 till trigger the VBA to replace the formulas in the rows that have data.
  22. PaulF

    Matrix to List (DataBase)

    Not in a locked down enterprise environment running Excel 2007 :-( (You have to meet the client where they are...)
  23. PaulF

    Matrix to List (DataBase)

    Thank you for this link sir !!
  24. PaulF

    Long row formula

    If you upload a file I can provide a vba on change solution if you don't want to convert your data to a table.
  25. PaulF

    Matrix to List (DataBase)

    SirJB7, Thank you !! With little training on my end and I'm going through your code and love the structure... In trying to learn can you help me understand the naming conventions. in Const ws & ranges - ks << why ks ? in Const filter - ki << why ki ?? I'm going to spend a few hours...
Back
Top