I have a spreadsheet where i have participants that enrollment start and
end dates. i would like to know if there is a formula to determine if they
were in active status for a particular month and since there is a group of
them, to count a number people who were also active given the start and
that's correct
On Thursday, May 14, 2015 at 1:13:52 PM UTC-4, ashish wrote:
just wanted to check even if the some one is active just for a day in a
month like start date is 1 jan 2014 and end date is 2 jan 2014 will that
be counted as active in jan month
On Thu, May 14, 2015 at 10:37
just wanted to check even if the some one is active just for a day in a
month like start date is 1 jan 2014 and end date is 2 jan 2014 will that
be counted as active in jan month
On Thu, May 14, 2015 at 10:37 PM, Heather Battle hbattle2...@gmail.com
wrote:
I have a spreadsheet where i have
Hi MV,
Firstly, I want to say thanks for sharing this valuable Macro. People already
had given up hope but you have done a great work here.
In this macro, getting runtime error in below line:- Invalid procedure call or
argument.
AppActivate Adobe Reader
And also, if any
Dear Sir,
My company has two shifts say Ist shift working =6:00 to 14:00 ans
second shift 14:00 to 22:00
i have large data of employees (rotating shifts) and want to calculate
which employee worked in which shift
Excel is on that format
EmployeeCode Shift
Ok thanks!
I got what you mean thanks alot!!!
2015-05-14 14:07 GMT+03:00 liron glam gliron11041...@gmail.com:
hi,
Thanks!
but to change this:
=IFERROR(ROUND((E6/G6*100),0)/100,0)
instead of what formula?
2015-05-14 12:52 GMT+03:00 Nasir Saikh nasirsa...@gmail.com:
Hi,
You need to
HI abbas,
Use the conditional formatting with Use a formula to determine which cells
to format'
Regards,
Ganesh N
On Thu, May 14, 2015 at 3:24 PM, Ali Abbas tigarman...@gmail.com wrote:
Dear All. Hope u r all well.
I have two column with numbers. My requirement is if one column values is
Dear Ashish,
Thanks for your efforts,
pl find the attached sheet for your reference.
Kindly suggest any appropriate formula which give me the exect which i want.
RAKESH SHARMA
NPI –Team
Ericsson India Pvt. Ltd.
4th Floor, Gupta Towers, Commercial Block, Rail Head
Jammu Kashmir, INDIA
Phone
Hello
I have another problem with this macro code,
whenever it's #DIV/0!
its an error and the loop stops,
what can i do to make it go further with the loop without coloring the
error rows?
Thanks in advance
2015-01-13 13:09 GMT+02:00 Ashish Kumar kumar.ashish...@gmail.com:
Nice Solution
Dear Sir,
We need to send multiple email to client for outstanding on starting of
every month. The client database is quite huge we required your help on the
same.
We required all the emails to be saved in Outlook drafts after checking
it goes to client. We need to sent the email on email
hi,
Thanks!
but to change this:
=IFERROR(ROUND((E6/G6*100),0)/100,0)
instead of what formula?
2015-05-14 12:52 GMT+03:00 Nasir Saikh nasirsa...@gmail.com:
Hi,
You need to change formula with below...
=IFERROR(ROUND((E6/G6*100),0)/100,0)
On Monday, January 12, 2015 at 7:45:03 PM
Dear All. Hope u r all well.
I have two column with numbers. My requirement is if one column values is
greater than other then greater values color should be red and its smaller
values color is green. How can I compare two columns by using of
conditional.
--
Are you =EXP(E:RT) or
Hi,
You need to change formula with below...
=IFERROR(ROUND((E6/G6*100),0)/100,0)
On Monday, January 12, 2015 at 7:45:03 PM UTC+5:30, liron glam wrote:
I have big data file on excel, the file has 6930 rows and 8 columns, the 8
column has percents (0%, 4%, 16%, 18%, 19% and etc..)
I
PLEASE SHARE SAMPLE FILE
On Thursday, May 14, 2015 at 3:24:47 PM UTC+5:30, ali abbas wrote:
Dear All. Hope u r all well.
I have two column with numbers. My requirement is if one column values is
greater than other then greater values color should be red and its smaller
values color is
14 matches
Mail list logo