Hi Vinod,
Attached file has three different solution scenarios to your query. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 8/25/09, vinod rao wrote:
>
> Hello Team,
>
> How do i rank only posit
On Tue, Aug 25, 2009 at 9:52 PM, vinod rao wrote:
> Hello Team,
>
> How do i rank only positive numbers. Plz help me on formula.
>
> Example
>
> Amount Rank
> 200 2
> 100 3
> -50NA
> 10 4
> -5 NA
> 3001
>
>
> >
>
i attc
On Aug 25, 9:39 pm, NOURREDINE BELHAJ wrote:
> Hi All,
>
> Hope you are well.
>
> I would like to ROUNDUP the figure below
>
> 9,235,200.23 € to 9,500
>
> Can you please advise ?
> Thanks
> --
> Regards
>
> Nourredine BELHAJ
>
> +41783081988
> +33665248617
Hi Nourredine,
A solution is at
Hi
attached is the solution to your query
Hope it helps
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Tue, Aug 25, 2009 at 9:52 PM, vinod rao wrote:
> Hello Team,
>
> How do i rank only positive numbers. Plz help me on fo
Thanks Harmeet..!!
But, I must say that the solution provided by Paul is also good, the only
limitation which I can see in it is that It won't work in Excel 2003 / xp or
versions below than that.
Suresh.. the Brave man... if you have Excel 2007 version installed in your
PC, then please go ahead an
ROUNDUP(9235200,23*2;-6)/2000
On Aug 25, 1:39 pm, NOURREDINE BELHAJ
wrote:
> Hi All,
>
> Hope you are well.
>
> I would like to ROUNDUP the figure below
>
> 9,235,200.23 € to 9,500
>
> Can you please advise ?
> Thanks
> --
> Regards
>
> Nourredine BELHAJ
>
> +41783081988
> +33665248617
--~--~-
Hello Team,
How do i rank only positive numbers. Plz help me on formula.
Example
Amount Rank
200 2
100 3
-50NA
10 4
-5 NA
3001
--~--~-~--~~~---~--~~
I solved the problem my self, like this:
Txt1 = Txtbox1.Value
Txt2 = Txtbox2.Value
Txt3 = CDec(Txt1) + CDec(Txt2)
TxtTotal.Text = Format(Txt3, "###0.00")
It works like a charm.
--~--~-~--~~~---~--~~
---
Yea Vidyut,
You can use this formula to extract data from another sheet.. U just have to
changed the reference cells.
Lemme know if I can help u more on this..
Cheers!!
ANISH
On Tue, Aug 25, 2009 at 4:22 PM, vidyut more wrote:
> can i use this formula to another sheet extract data from anothe
I think Dilip has already provided the solution.
plese refer to attached file.
On Tue, Aug 25, 2009 at 5:53 PM, suresh k wrote:
>
> Can anyone provide me the formula for below query.
>
>Report Date Total Logged Time at Work Hrs 7/2/2009 8.86 7/2/2009 9.03
> 7/2/2009 7.92 7/2/2009 9.02 7
Hey Putta, thanks for the appreaciting note. . !!
Warm Regards,
DILipandey
On 8/25/09, Putta Madaiah wrote:
> Thank you Dilip, I appreciate your efforts.
>
> Rgds- Putta
>
> On Tue, Aug 25, 2009 at 4:35 PM, Dilip Pandey wrote:
>
>> Hi Putta,
>>
>> Attached herewith is the solved spreadsheet co
Try =SUMIFS (not SUMIF, but SUMIFS)
the plural means multiple conditions!!!
the function Wizard makes it very easy to use.
But your formula becomes:
=SUMIFS(B2:B6,A2:A6,"7/2/2009",B2:B6,">8")
Sums B2-B6, if A2-A6 is "7/2/2009"
and if B2-B6 is > 8.
hope this helps.
Paul
__
Absolutely!
What you're looking for is a specific type of macro (or subroutine)
called an "Event".
There are lots of kinds of events.
the "workbook_open" event runs when a workbook is open.
the "workbook_activate" or "workbook_deactivate" events run when you
switch between windows.
What you descri
Hi Anish
can i use this formula to another sheet extract data from another sheet.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Tex
I have a worksheet where users log daily
activities. There are three columns where
they need to respond either "Yes" or "No"
to these activities based on a specific question.
For ease of entry I have made a data validation
from a list with either Yes or No as the options for
each cell in the col
I will use conditional formatting in the 2nd and 3rd columns instead.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add
Hi All,
Hope you are well.
I would like to ROUNDUP the figure below
9,235,200.23 € to 9,500
Can you please advise ?
Thanks
--
Regards
Nourredine BELHAJ
+41783081988
+33665248617
--~--~-~--~~~---~--~~
---
Here is the macro attached to the command button that populates the
comboboxes:
Private Sub CommandButton3_Click()
Sheet2.Include1.Value = False
Sheet2.Include2.Value = False
Sheet2.Include3.Value = False
Sheet2.Include4.Value = False
Sheet2.Include5.Value = False
Sheet2.Include6.Value = False
Can anyone provide me the formula for below query.
Report Date Total Logged Time at Work Hrs 7/2/2009 8.86 7/2/2009 9.03
7/2/2009 7.92 7/2/2009 9.02 7/3/2009 9.05
Answer should be 26.91. Excluding the value less than 8.00 hrs and it should
calculate only for one day(7/2/2009).
I have tried i
Thank you Dilip, I appreciate your efforts.
Rgds- Putta
On Tue, Aug 25, 2009 at 4:35 PM, Dilip Pandey wrote:
> Hi Putta,
>
> Attached herewith is the solved spreadsheet containing two possible
> scenarios. Thanks.
>
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
can i use this formula to another sheet extract data from another sheet.
-- Forwarded message --
From: Anish Shrivastava
Date: Tue, Aug 25, 2009 at 3:32 PM
Subject: Re: $$Excel-Macros$$ Help regarding formula
To: excel-macros@googlegroups.com
Cc: vidyutm...@gmail.com
Hi Vidyut,
Hi
Anish Shrivastava.
its cool
Thnaks a lot
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://
Hello Experts,
I am looking for a way to start a macro by clicking on a specific cell
in the spreadsheet. The macro have to run each time the value in the
cell is changed.
Is this possible???
Thank in advance for the help
Kind regard
Hans Dijkstra
--~--~-~--~~~---
Hi Vidyut,
Attached please find the worksheet wid formula. I just used Data Validation
to create the list of your Q.No. and used below formula.. Hope it Helps.
=SUMPRODUCT(($A$2:$A$211=$F$219)*($C$2:$C$211=G217)*($H$2:$H$211))
Cheers!!
ANISH
On Tue, Aug 25, 2009 at 2:23 PM, vidyut more wrote:
I'm looking for an efficient way to download data from Reuters into
vba.
Downloading into a workbook cell is easy enough, but I want to avoid
using reuters links in my spreadsheet, as it slows things down
considerably.
At the moment I'm using the following code in vba:
ReutersData = Application
Hi Gaurav,
Attached sheet has two possible solutions for your query. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Aug 24, 2009 at 7:39 PM, Gaurav Banerjee wrote:
> Hi,, How to fnd the second
Hi Vidyut,
Solution is attached with this email. thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 25, 2009 at 2:23 PM, vidyut more wrote:
> plz find attd. excel file. i want formula for pa
Ok..I think tomorrow, we can discuss on this over Gtalk.
If you want you can draft your queries as well and sent that to the group.
Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 25, 2009 at 6
Hi William,
I have included your both the examples in the solved workbook and attached
that with this email. Please have a look.
Further to this, what I have understood as per your query is "there are some
numbers which will be generated randomly and at the end will be followed by
some Zeros".. h
Hi Suresh.. the Brave man.!!
Attached workbook has the solution to your query. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 25, 2009 at 5:06 PM, suresh k wrote:
> Hi Dilip,
>
> Could yo
Hi Shivashankar,
I have given out the solution in the attached spreadsheet. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 4, 2009 at 6:14 PM, shivashankar katageri <
shankarkatag...@gmail
Hi Putta,
Attached herewith is the solved spreadsheet containing two possible
scenarios. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 4, 2009 at 2:38 PM, Putta Madaiah wrote:
> Hi All,
Could you paste your Macro Codes here and probably it will be easy to
identify solution.
May be your macros are event based.
Kamal
On Mon, Aug 24, 2009 at 5:09 PM, Joseph Choi wrote:
> you may need to save the user input state of your controls (combo box,
> listbox) and save it on your workbook
plz find attd. excel file. i want formula for particular q.No. Mtrs on
particular date.
txn in advance.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tu
Vivek,
I have not used the user form.I have inserted active x controls.Have used
text boxes and comboboxes.Want to hav tab functionalities for the active x
controls.
Regards,
Bharghav R
On Tue, Aug 25, 2009 at 12:27 PM, vivek agrawal
wrote:
> Hi
>
> See the attached image which contains th
Hi Venkatesh i have uploaded the File jsut now ( 02:00 PM IST) in the
Group folder http://groups.google.com/group/excel-macros/web/sample%20sheet.xls
Please let me know the answer
On Aug 24, 9:53 am, Suhas wrote:
> Hi Venkatesh,
>
> How can i send the attachement, i cant find any options here
Hello JM
The custom addins can be added in Excel 2007 through the Office Button. \
Click on .
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
3rd Floor, Adiba Mansion
Maszid Lane, Kamarpatty
Fancy Bazar
Guwahati : 781001
Assam
+91 361 2638864 (Telefax)
+91 361 2517820 (Office)
+91
Hi Michael
You may use =MIN(500,
IF(A11<=6000,IF(A11<0,#VALUE!,ROUND(A11*0.012,2)),72+ROUND((A11-6000)
*0.009+18,2)))
This will give you the minimum of either values.
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
3rd Floor, Adiba Mansion
Maszid Lane, Kamarpatty
Fancy Bazar
Guwahat
Hello JM
The custom addins can be added in Excel 2007 through the Office Button. \
Click on .
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
3rd Floor, Adiba Mansion
Maszid Lane, Kamarpatty
Fancy Bazar
Guwahati : 781001
Assam
+91 361 2638864 (Telefax)
+91 361 2517820 (Office)
+91
Hi Everybody,
I need help with below Vlookup function in macro.
Following is the code I am presently using
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[2],'[SAP Codes.xls]Sheet1'!C2:C4,3,0)"
But above formula prompts me every time to locate the SAP code worksheet. Is
there any way I can put the path o
Thankyou very much Sandeep.
Brilliant way to solve the problem. Thanks.
On Aug 24, 9:01 pm, "Sandeep" wrote:
> - Original Message -
> From: "Sandeep"
> To: "Shahryar Rahman"
> Sent: Sunday, August 23, 2009 8:25 AM
> Subject: Re: $$Excel-Macros$$ Rolling Payments Calculation
>
> > Hi S
41 matches
Mail list logo
