I have excel file. Its calculation in option always go Manual from
automatic mode. So all calculation to be made manually. any solution.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tr
Ayush Jain has sent you a link to a blog:
Dear Group, An amazing tip to use only visible rows in formulas.. Check
it out now.. Best regards, Ayush Jain Group Owner
Blog: Excel Daily Tip
Post: Sum/Count/Average only Visible Rows with SUBTOTAL Function
Link:
http://exceldailytip.blogspot.com/2010/0
On Feb 20, 12:05 pm, Christopher Luka
wrote:
> Here's an example with one way to do it. Let me know if the formula is too
> complex & I'll walk you thru it.
> [...]
Interesting! It looks like what I need. I will give a try on my
spreadsheet.
Thank you both for your offers.
--
---
How can I transfer a variable size range into an array and then
perform a mathematical operation on it, i.e. subtraction? I am using
the refedit control from the user forms section. Initially, I tried
using a For Each Next Statement but this creates an immediate problem
because Subtracting UserSum
thanks to all it works
On Mon, Feb 22, 2010 at 11:03 PM, Dilip Pandey wrote:
> Dear Abdul,
>
> Use Networkdays function to accomplish this task. An example is attached
> with this email.
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
> MBA-HR,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dili
Dilipji,
If we need to consider 1st and 3rd Saturday as working, please guide.
Thanks in advance
Anand
On Mon, Feb 22, 2010 at 11:33 PM, Dilip Pandey wrote:
> Dear Abdul,
>
> Use Networkdays function to accomplish this task. An example is attached
> with this email.
>
> --
> Thanks & Regards,
thnks dear
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Mon, Feb 22, 2010 at 11:34 PM, Dilip Pandey wrote:
> Good one...!!
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
> MBA-HR,B.Com(Hons),BCA
> Mobile: +91 98
I used this formula to extract numbers from alphanumeric string
=1*mid(b2,match(true,isnumber(1*mid(b2,row($1:$159),1)),0,count(1*mid(b2,row($1:$159),1)))
but it doesnt seem to work.
--
--
Some important links for exc
This is a amasing solution. Works great, have tested a test file
Will try it on a real life situation too.
Thanks mate
Harpreet
On Feb 20, 10:27 pm, SHAM wrote:
> To crack the password of an VBA Macro / coding first download an HEX
> Editor
>
> its available from the
> sitehttp://www.chmaas.h
Hi Sudesh,
Your data is not arranged properly. If this is not an ad-hoc request, then
you are requested to arrange your data in order and then proceed further to
create pie chart. See help section for charts to have a knowledge for the
same OR you can search google as well.
--
Thanks & Regards,
Good one...!!
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 2/22/10, VIRAL PANDYA wrote:
>
> Dear All,
>
> I am using the attached addins WST macro.
>
> and like to share the same with
Dear Abdul,
Use Networkdays function to accomplish this task. An example is attached
with this email.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 2/22/10, Abdul Rasheed wrote:
>
>
Dear all,
I would suggest to search internet for free VBA password breakers /
crackers, else one can buy the same from open market as well.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
O
Dear all,
I would suggest to search internet for free VBA password breakers /
crackers, else one can buy the same from open market as well.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
You can use the network days function.
Please tell me if it clarifies your doubt.
Guru
On Mon, Feb 22, 2010 at 5:37 PM, Abdul Rasheed wrote:
>
>
> How to skip non working days to calculate number of days betewwn dates
> ??
>
> Such as sunday or any vacations came between working days.
>
>
How to skip non working days to calculate number of days betewwn dates
??
Such as sunday or any vacations came between working days.
Thanking You
Abdul Rasheed
--
--
Some important links for excel users:
1.
Hi
I have attached below an file which contains The name of the person who has
made in the respective fields in so and so month . My aim over here was i
wanted to prepare and Pie chart which will show the percentage wise error
for the month of jan with all th erealtive fields
Basically i wanted to
Hi SHAM,
Thanks for the wonderful link.
Does anyone have any tool for breaking the password of excel file
itself? As it has happened many times in the past that i have put
password for opening excel sheet and later on, i could not remember
the password.
Thanks & Regards,
Durgesh
On Feb 20, 10:27
here is simple the solution. Ernie from Calamba, Philippines.
On Mon, Feb 22, 2010 at 11:24 AM, Akash $urkatha wrote:
> Dear Rohan,
>
> I have tried that formula. Its fine for normal calculations. But its not
> showing correct result when my activity starts on say Monday afternoon 12:00
> Hrs a
19 matches
Mail list logo
