# Date Max of Date 1001 8/2/2010 # Total 1001 6/10/2010 1001
8/2/2010 1001 3/14/2010 2355 4/12/2010 1001 3/1/2010 5252 3/15/2010 1001
2/15/2010 1001 2/15/2010 2355 4/12/2010 2355 1/6/2010
5252 3/15/2010 5252 2/15/2010 5252 1/6/2010
On 8/6/10, Srinivasan Ethirajalu wrote:
>
Use pivot table, use# column in ROW area & Date in DATA area, change "Count
of Date" to "Max of Date", format the data area to date format. Then "Hide"
the grand total.
Srinivasan Ethirajalu
On 8/5/10, Nadine S wrote:
>
> Sheet 1 contains
> # Date 1001 03/01/10 5252 02/15/10 1001 02/15/1
Thanks a lot Krisnan
It is working.
I really appricieat your knowladge, I m glade to get help from you.
Regards
Pankaj k PAndey
On 8/5/10, Kishan Reddy, K wrote:
> Try this,
>
> But check it may have adverse effects,
>
> Private Sub CommandButton2_Click()
> UserForm1.Show 0
> End Sub
>
> Also c
Sheet 1 contains
# Date
1001 03/01/10
5252 02/15/10
1001 02/15/10
1001 02/15/10
1001 08/02/10
5252 03/15/10
5252 01/06/10
2355 04/12/10
1001 06/10/10
1001 03/14/10
2355 01/06/10
Sheet 2 contains
# Last Date
1001 8/2/2010
5252 3/15/2010
2355 4/12/2010
The dates in sheet 2 in yellow
Thanks for the advice. :)
2010/8/5 Kishan Reddy, K
> As per my policy, replacing/deleting any rows/values is not a good
> idea.
>
> I will simply use pivot table or subtotals command on the data and get
> the results in another sheet.
>
> Regards,
> Kishan Reddy, K
>
> On Aug 4, 4:11 pm, Dave Bo
Sudhir,
I am assuming by the subject matter of your posting you need to find
the X and Y coordinates of any place on the graph where series 1 and
series 2 intersect. So if I understand your request correctly, this
should help
Lets put your X axis coordinates in cells B4 through E4. So in cell B4
hi friend,
i have a problem , i made two graph in excel sheet intersecting with each
other. now i want to highlight the value of the intersection point. plze
help
--
Regards-
Sudhir Kumar
Design Engineer,
Conceptia Software Technologies Pvt. Ltd.
Email id-sudhir.p...@gmail.com,
--
-
For track changes u have to share the workbook... thats why i m not using
that.
On Thu, Aug 5, 2010 at 2:15 PM, Kishan Reddy, K <
kishanreddy.kethire...@gmail.com> wrote:
> Sudhir,
>
> Why can't you use Track changes from Tools menu?
>
> Regards,
> Kishan Reddy, K
>
> On Aug 4, 7:51 pm, sudhir k
hi all, can anybody help me out in the below problem., its urgent,
thanks..., saber
-- Forwarded message --
From: mohd ateeq
Date: Mon, Aug 2, 2010 at 10:30 PM
Subject: Fwd: $$Excel-Macros$$ Re: automation error
To: excel-macros@googlegroups.com
hi all,
can anybody help me out
This seems to be missing your text, Kumar. :(
From: Kumar Punnam
To: excel-macros@googlegroups.com
Sent: Thu, August 5, 2010 6:29:35 AM
Subject: Re: $$Excel-Macros$$ Sumproduct with 3 criteria +
On Tue, Aug 3, 2010 at 5:54 PM, Nadine S wrote:
Let me try
Unfortunately I didn't receive an email from the email address I see below for
you. I did receive one from someone who signed the email as Stuart but with a
different name in the email address. Was that you? If so, it will work. I
need to add in all the 20+ payment columns which will make it
Hi Dave,
Thanks for responding. No, I haven't gotten an answer so thank you, thank you,
thank you for helping me.
Sheet 1 contains the details and Sheet 2 is the summary. So, Sheet 1 B, C, D
has information that may show the same on multiple lines due to different
information in the others c
Hi Pooja,
Just click on excel options.
dialog box with different options are displayed then click on trust center.
and enable option is seen just click on trust and save it and close the work
book .
then u can use the macro enabled workbook.
Regards,
Raj
On Fri, Jul 30, 2010 at 12:25 PM, Pooj
On Tue, Aug 3, 2010 at 5:54 PM, Nadine S wrote:
> Let me try this again.
>
> Sheet 1 has info in B, C and D that needs to match info Sheet 2 column F,
> G, and H. If those all match then I need to check if column AH in Sheet 1
> matches either R2, R1 or R4 in Sheet 2. If so, then I need to sum
Hi Nadine,
Sorry I haven't got back to you on this. And I don't even know if it has been
answered by someone else. If you still need an answer, then I need to know what
you want summed in Col X.
If everything matches up as you have described, then the cell fom Col X is just
one cell, which I
Sudhir,
Why can't you use Track changes from Tools menu?
Regards,
Kishan Reddy, K
On Aug 4, 7:51 pm, sudhir kumar wrote:
> Thanks stuart for ur reply, but, macro record is work for when u r using
> same type of command again and again, but this time issue is different
>
>
>
> On Wed, Aug 4,
First of all,
Let me know why you want you use such type of objects, in excel, when
the same can be done through simple formulas and simple macros.
Let me understand the purpose.
Regardds,
Kishan Reddy, K
On Aug 2, 12:26 pm, Stuart Redmann wrote:
> Santiago Afonso wrote:
> > Hello. I'd like
As per my policy, replacing/deleting any rows/values is not a good
idea.
I will simply use pivot table or subtotals command on the data and get
the results in another sheet.
Regards,
Kishan Reddy, K
On Aug 4, 4:11 pm, Dave Bonallack wrote:
> Hi Angelo,
>
> Have a look at the attached and run th
Agreed with your point, but i want that if i required so i can only
see any other Excel file while opening a Form. I dont want to do any
thing on that file just want to see for refrence.
Kindly suggest
Regards
Pankaj k Pandey
On 8/5/10, Intelligent But Crazy wrote:
> Hi Dav,
>
>
Try this,
But check it may have adverse effects,
Private Sub CommandButton2_Click()
UserForm1.Show 0
End Sub
Also check for help on SHOW method ( modal/nonmodal forms).
Share with me if you have any problems
Bye,
Kishan Reddy, K
kishanreddy.kethire...@gmail.com
On Aug 5, 6:38 am, Intelligen
you used to pivot table..
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/grou
Dear All
Earlier i had got an excel file in which bse prices are automatically
updated like that way i need to track lme prices. can any one help on this .
Regards
LKModi
--
--
Some important links for excel users:
Hi Nadine,
I've sent you an email with a file that hopefully does what you want.
Please don't answer by email, since I have a quite selective spam-
filter. Please post to this newsgroup instead. Thanks.
Stuart Redmann wrote:
> > I guess that what you wanted to say is that you want to
> > get the
23 matches
Mail list logo
