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