• 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

    VBA- Delete rows doesn't match with criteria

    another approach: Sub DeleteRows() Dim lastrow As Long, i As Long Application.ScreenUpdating = False With Sheets("Sheet2") lastrow = .Range("C" & Rows.Count).End(xlUp).Row For i = lastrow To 2 Step -1 If IsError(Application.Match(.Range("C" & i).Value, Sheets("Sheet1").Range("A2:A5")...
  2. V

    index/match, lookup, countif ohmy!

    Maybe the problem is triggered by the version of your Excel (do you have 2003 or earlier?). Some function in the formula is not exist under Excel 2007. Can you work with .xlsx files? If yes then find in attached.
  3. V

    Need help with formula

    Hi, Please, post a sample file with the desired results, that will help a lot.
  4. V

    Macro to find and match debit/Credits by BOLD

    Ok, could you test this conditional formatting: Sub Test() Columns("U:U").Select Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _ "=IF(ISERROR(IF(U1=VLOOKUP(-1*U1,$U:$U,1,FALSE),,)),FALSE,TRUE)"...
  5. V

    Date Formula

    Could you please check out this proposal? The date format is separated by slash (/) on my computer, if you have another character then change it in the DATEVALUE function.
  6. V

    Date Formula

    Hi, I see in your file the "Month no." and "Month" is not corresponding each other. "Month no." or "Month"should be considered in the calculation?
  7. V

    Macro to find and match debit/Credits by BOLD

    try this: Sub ModifyFindMatch() Dim myVar Dim x As Integer Dim y As Integer Dim mycell ActiveSheet.Range("u1").Select y = ActiveSheet.Range("u1").End(xlDown).Row - ActiveCell.Row Do Until IsEmpty(ActiveCell) myVar = ActiveCell For i = 1 To y If ActiveCell.Offset(i).Value = -1 * myVar...
  8. V

    Macro to find and match debit/Credits by BOLD

    Hi, Highlight just by color?
  9. V

    How to lookup the values with multiple criterias and yet not filtering the data, cleanest way to do?

    Hi, Is it an answer for you question?
  10. V

    Is it possible to automatically open spreadsheets & run macros at a certain time of the day

    Hi, Try this: Step1: open your workbook by windows task scheduler Step2: write a function in your macro which is able to launch your code when the workbook can be considered as opened
  11. V

    getting week start date and end date for multiple weeks

    Hi, Check out this file. The last 2 entries (in column C) are displayed in the drop down list.
  12. V

    Show Address from another sheet

    Here you can find.
  13. V

    Show Address from another sheet

    I removed the hyphen (-) character from the formula. Is it OK?
  14. V

    Show Address from another sheet

    Not totally clear for me your question, could you please explain it deeply?
  15. V

    Show Address from another sheet

    Hi, Check this proposal (note: array formula).
  16. V

    index/match, lookup, countif ohmy!

    Hi, If you have names under Row28 then go to cell I2 --> extend the ranges of names in the formula --> press CSE --> copy down. To get the scores: go to J2 --> extend the ranges of names and scores --> press Enter --> copy down.
  17. V

    getting week start date and end date for multiple weeks

    Hi, Is this proposal help for you?
  18. V

    Return the largest number in a range

    Hi, Is this formula help for you?
  19. V

    Automatic tranposing of column entries into rows

    Hi, Could you check the provided formula in the sample file if it's suit for you?
  20. V

    Calculating Growth vs Loss Year over Year

    Hi, Is the pivot table help for you?
  21. V

    index/match, lookup, countif ohmy!

    Hi, Check this proposal (column I & J) if Ok for you.
  22. V

    SUMPRODUCT or SUMIFS that will allow formulas

    Hi, Something like this? =SUMPRODUCT(($A$3:$A$24=$F5)+0,$B$3:$B$24,$C$3:$C$24/100)/(SUMIF($A$3:$A$24,$F5,$C$3:$C$24)/100)
  23. V

    Spin Button in Do-nut Chart

    I insereted a spin button from the Developer tab after right click on the button --> Format control and set the Current, Minimum and Maximum value and the incremental change then just adjusted the Cell link.
  24. V

    Spin Button in Do-nut Chart

    Hi, Is this what you need?
  25. V

    Moving average

    Hi, Here is another proposal.
Back
Top