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

    Fuzzy Name Match Lookup

    Hi, This will help you. https://www.mrexcel.com/forum/excel-questions/195635-fuzzy-matching-new-version-plus-explanation.html
  2. V

    VBA to insert formula in column

    Hi, Check out it this.
  3. V

    FILTER the data

    Hi Techtrend, Do you need something like this?
  4. V

    Pop Up Reminder, based off of Dates

    Hi, Check out this approach. Option Explicit Private Sub Workbook_Open() Dim LastRow As Long Dim a As Long Dim Message As String Dim Today As Integer With Worksheets("Sheet1") LastRow = .Range("B" & .Rows.Count).End(xlUp).Row For a = 2 To LastRow If...
  5. V

    Count form merged cells

    Hi, Is this help?
  6. V

    How to grab underlined text in a cell

    Hi, Check out this sample file.
  7. V

    Consolidating several worksheets into one pivot table

    And what about the Data Model technique? If the data on sheet Oct16, Nov16, Dec16 are in Tables then you can integrate these tables into 1 pivot table. Or VBA.
  8. V

    Pivot table and calculated fields

    Hi Janine, Check it out.
  9. V

    Consolidating several worksheets into one pivot table

    Is this help for you? https://support.office.com/en-us/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3AE257D2-CA94-49FF-A481-E9FC8ADEEEB5
  10. V

    Dynamic VLOOKUP?

    Hi, Can you upload a sample file with the desired result?
  11. V

    Multiple Sumif Criteria - Month & Name

    Hi, Check out this approach.
  12. V

    How many conditional formatted cells are in the range (more colour criterias)

    Hi @p45cal, Thank you very much the .DisplayFormat tip, I was able to figure out the code. Option Explicit Sub CountColoredCells() Dim a As Range Dim Count, Lastrow1, Lastrow2 As Long Dim b As Variant Count = 0 Lastrow1 = ActiveSheet.UsedRange.Rows.Count For Each a In Range("B9:C"...
  13. V

    How many conditional formatted cells are in the range (more colour criterias)

    Hi PCosta87, Thank you the feedback, I have so much cell, the manual coloring is not possible. Who can confirm PCosta87's statement "there is no way"?
  14. V

    How many conditional formatted cells are in the range (more colour criterias)

    Hi, I would like to ask your help regading the conditional formatted cells counting. In range B9:C19 I applied 4 different conditional formatting rules (colours: red, orange, yellow, green) and my target is to count those cells which are formatted with red, orange and yellow. The sample file...
  15. V

    create scroll bar in chart

    Hi ira, Check out this approach on Sheet2.
  16. V

    adding data labels

    Hi, Is this what you need?
  17. V

    Drop down list with suggestion

    another proposal with helper columns
  18. V

    Formula to show the text between the quotations marks

    Hi, Is this help for you?
  19. V

    Lookup and match Multiple criteria

    Hi, Check this array proposal.
  20. V

    Find a specific value from a Multiple criteria range

    Hi, The standard decimail separator is comma on my PC therefore I had to modify the MIN and MAX columns to get numbers.
  21. V

    Find a specific value from a Multiple criteria range

    Hi, Check out this array approach. Note: I changed the decimal separators of MIN and MAX (on sheet Material code master) from point to comma and converted to numbers.
  22. V

    RANDBETWEEN with no duplicates

    Is the VBA allowed for you? If so then here is another option, just press the command button and follow the instructions. Check it out.
  23. V

    Help Required on Sumproduct with multiple condition

    Hi, Is this formula what you are looking for? =SUM(SUMIF(B:B,I1:I8,D:D)) entered with CSE
  24. V

    Some Advice Dashboard

    Hi, Upload your file here, more eyes see more things than two.
  25. V

    Some Advice Dashboard

    missing attached file
Back
Top