• 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

    Quarterly headcount

    Here is the sample file. in the "HC & Attrition BU Wise" sheet i am attempting to do Calculate F7 independently
  2. R

    Quarterly headcount

    Hi People, this issue i am facing is counting average headcount in a quarter. the long way is i have monthly headcount which i average for the monthly HC (headcount) of march i use countif Countif(join Date column, <April 1) minus Countif (attrite date column, <April 1) ---sum all heads joined...
  3. R

    Sum of Values of distinct entries

    Hello all, i have a data which has duplicate entries for same date. i can get the distinct count of values in column A using a pivot but i also want the sum of only the distinct entries from column B based on dates in column C. A B C 1 100 15/02 2 600 15/02 3 500 15/02 1 100 15/02 4 200...
  4. R

    code to align multiline field

    I am sending an automated email and have a string body which includes a multiline field fetched. how can i uing vba align all lines in this multiline filed to be tabbed under each other.
Back
Top