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

    Conditional formatting with pivot table

    Thank you Ravi Kumar. Appreciate your help. Best Regards, Mushtaq Kadar.
  2. M

    Conditional formatting with pivot table

    Hi, I have a pivot table with data columns and I need to apply conditional formatting on 3 columns based on the following criteria. 1. Action Status column as "Completed" should be highlighted as green. 2. Action Deadline Date column should be red if the action status is not completed and the...
  3. M

    Index function giving a #NUM! Error

    It Works. Thanks a million, you are "AWSOME"
  4. M

    Index function giving a #NUM! Error

    Attached are the 2 files for your review. In the SAM Monthly Report Test file. I am trying to achieve the following. I want pervious monthly records for employee only where the "Injury Type" is not "First Aid" or "Reported Only".
  5. M

    Index function giving a #NUM! Error

    This is what I have written with the Error function, but its not giving me the right data. =IF(ISERROR(INDEX('[Safety Stats.xlsx]Occupational Injuries'!$J$5:$J$128,SMALL(IF('[Safety Stats.xlsx]Occupational Injuries'!$A$5:$A$128=TEXT(EOMONTH(TODAY(),-1),"MMMM"),IF('[Safety Stats.xlsx]Occupational...
  6. M

    Index function giving a #NUM! Error

    Below is my formula which is giving me a #NUM!. How can I fix it. I have to spreadsheet. One with the data called "Safety Stats" and the other one is actual report where I am using this formula to pull the record from the data file i.e "Safety Stats" =IF(INDEX('[Safety Stats.xlsx]Occupational...
Back
Top