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

    Having COUNTA ignore cells with formulas

    Hi, Just to add one more formula that I think it is more easier. if your formula is in Column A, you can write this formula in B1 =COUNTIF(A:A,"?*")
  2. R

    empty rows

    But if you dont want to use macro just highlight the column A then follow the command below. 1. Ctrl G, Alt S, K and Enter 2. Ctrl -, R and Enter I hope it will help you this method.
  3. R

    empty rows

    Hi, Copy this code in your macro and run, it will automatically delete the row of empty cells in column A. Sub DeleteBlankRows() Columns("A:A").SpecialCells(xlCellTypeBlanks).Select Selection.EntireRow.Delete End Sub
  4. R

    REMOVING DUPLICATES IN A COLUMN WITHOUT EFFECTING OTHER COLUNMS

    I would like to share this formula if you don't want to sort the data, put this formula in another column =IF(COUNTIF(A$1:A1,A1)=1,A1,"")
  5. R

    To convert text string to date format

    Hi, You can use the the text to columns application (from DATA ribbon). First highlight the data and select the delimited then click next twice then select date and select DMY then OK. Hope this will help...
  6. R

    Project Management Dashboards - Lookup/Count Text Values

    A B 1 Roger =IF(COUNTIF(A$1:A1,A1)=1,1,0) 2 Imee =IF(COUNTIF(A$1:A2,A2)=1,1,0) 3 Ruth =IF(COUNTIF(A$1:A3,A3)=1,1,0) 4 Roger =IF(COUNTIF(A$1:A4,A4)=1,1,0) 5 Imee =IF(COUNTIF(A$1:A5,A5)=1,1,0) 6 Imee =IF(COUNTIF(A$1:A6,A6)=1,1,0) 7 Merly =IF(COUNTIF(A$1:A7,A7)=1,1,0)...
Back
Top