Hi Sagar,
Any Changes for any excel sheet, you can go the DATA Menu & Click Edit
Links & Select All then Update Value & Refresh All Sheets.
Regards,
Kuldeep Singh
On Sat, Aug 18, 2012 at 12:00 AM, SAGAR KASANGOTTUWAR <
sagarkasangottu...@gmail.com> wrote:
> Dear Kuldeep,
>
> But if the location
Thanks Mr. Don, Mr. Sam, Mr Rajan.
Thanks a lot.
On Fri, Aug 17, 2012 at 11:09 PM, Rajan_Verma wrote:
> * *
>
> *Another solution is *
>
> * *
>
> *=Mode(rng)*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* Rajan_Verma [mailto:rajanverma1...@g
Thanks Mr. Paul
For such a beautiful & accurate reply.
On Fri, Aug 17, 2012 at 6:50 PM, Paul Schreiner wrote:
> Is this homework?
> It sure looks like it.
> I think we've been getting a LOT of that lately, school must have begun!
>
> I SUPPOSE that school should be teaching how best to use reso
banned
-Ayush
On Saturday, 18 August 2012 00:49:25 UTC+5:30, Seraj wrote:
> Dear group member follow the group rule #6.job podting is not allowed
> in this forum.
> Sent from BlackBerry® on Airtel
> --
> *From: *Job Postings >
> *Sender: *excel-...@googlegr
Dear All,
Good morning to all !!!
Can you send me the Business analyst tools or helping book/material for
learn about Business analyst
Thanks in advance
Regards,
XLS S
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already
Hello Noorain & Rajan,
Please help me, my query is still not yet resolved. please provide me the
solution.
Regards
Lokesh M
On Thu, Aug 16, 2012 at 6:19 PM, Lokesh Loki wrote:
> Hi Experts,
>
> May i know the reason why my query has been not yet resolved? Any think
> you want information from m
Sir,
I am not able to activate it.
Message
"Your installation cannot be activated because you have activated upto the
limit of your Multiple Activation Key. Consult your administrator for
further help."
On Tue, Jul 31, 2012 at 4:15 PM, NOORAIN ANSARI wrote:
> Dear Joshep,
>
> Please see screen
Good!
2012/8/17
> **
> Dear group member follow the group rule #6.job podting is not allowed
> in this forum.
> Sent from BlackBerry® on Airtel
> --
> *From: * Job Postings
> *Sender: * excel-macros@googlegroups.com
> *Date: *Fri, 17 Aug 2012 12:40:53 -0400
>
Dear group member follow the group rule #6.job podting is not allowed in
this forum.
Sent from BlackBerry® on Airtel
-Original Message-
From: Job Postings
Sender: excel-macros@googlegroups.com
Date: Fri, 17 Aug 2012 12:40:53
To:
Reply-To: excel-macros@googlegroups.com
Subject:
Did you attempt to implement the VBA I supplied (also at the end of this email)
It will work properly if the number of records in each sheet are not the same
and are not in the same order.
Paul
-
“Do all the good you can,
By all the means you can,
In all th
Dear Kuldeep,
But if the location of any code is change then linking will not showing
correct results.
Can you give me other solution for the same.
Thanks & Regards,
CA KSAGAR
On Fri, Aug 17, 2012 at 11:27 PM, Kuldeep Singh wrote:
>
> Dear Sudhir,
>
> Kindly see the attached file.
>
> Regards
Hi,
Please don't post any job mails.
Regards,
Kuldeep Singh
On Fri, Aug 17, 2012 at 10:58 PM, Job Postings <
requirements.jobposti...@gmail.com> wrote:
> *Please send the resume with contact details to
> resu...@gallopresources.com*
> *
> *
>
> *Cognos Developer*
>
> *Coppell, TX*
>
> *6 Months
Another solution is
=Mode(rng)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 17 August 2012 10:19
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ MOST REPEATED NO
If your list is Name is rng
Hi
Microsoft page is always helpful ,please visit to understand.
http://office.microsoft.com/en-gb/excel-help/dcount-HP005209049.aspx
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of joseph.cam..
If your list is Name is rng
Without Array
=INDEX(rng,MATCH(MAX(FREQUENCY(rng,rng)),FREQUENCY(rng,rng),0),0)
With Array
=SMALL(IF(COUNTIF(rng,rng)=MAX(COUNTIF(rng,rng)),rng,""),1)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto
Hi Rajan,
Could you please elaborate?
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Rajan_Verma"
Sender: excel-macros@googlegroups.com
Date: Fri, 17 Aug 2012 22:12:08
To:
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need a Sugge
You can use DCount()
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Santosh Kumar Singh
Sent: 17 August 2012 10:14
To: excel-macros@googlegroups.com
Cc: dguille...@gmail.com
Subject: $$Excel-Macro
Dear Group,
Please suggest
How we can reduce this formula (if Possible)
=COUNTIFS('Jan12'!F4:F60,"=Corrective",'Jan12'!H4:H60,"=DATA",'Jan12'!G4:G60
,"=Completed")+COUNTIFS('Jan12'!F4:F60,"=Implementation",'Jan12'!H4:H60,"=DA
TA",'Jan12'!G4:G60,"=Completed")+COUNTIFS('Jan12'!F4:F60,"=Traini
Or, a macro to round b..
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Friday, August 17, 2012 10:43 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ MOST REPEATED NO
Or directly by rounding in the formula itself
Hi,
Kuldeep,
This is very interesting can u explain.
thanks
regards
sudhir
On 17/08/2012, Kuldeep Singh wrote:
> Simple Create a pivot table. All files paste link & create a new pivot you
> can combine all 2000+++ Sheets Database.
>
> Regards,
> Kuldeep Singh
>
> On Fri, Aug 17, 2012 at 8:50
Or directly by rounding in the formula itself
=ROUND(INDEX(B3:B21,MATCH(LARGE(FREQUENCY(ROUND(B3:B21,2),ROUND(B3:B21,2)),2
),FREQUENCY(ROUND(B3:B21,2),ROUND(B3:B21,2)),0)),2)
Change the RED colored 2 to 3 for third most repeated number and so on
And if you only need to get the second largest num
Go here :
http://excelpoweruser.wordpress.com/2012/06/07/compile-worksheets/
if you have data in same format on multiple worksheets and you want to
compile on a single sheets you can Use this Macro,
Sub ConsolidateAllSheets()
Dim wksConsolidate As Worksheet
Simple Create a pivot table. All files paste link & create a new pivot you
can combine all 2000+++ Sheets Database.
Regards,
Kuldeep Singh
On Fri, Aug 17, 2012 at 8:50 PM, Paul Schreiner wrote:
> I made a few assumptions.
> Like: What to do if there is a "Code" in one of the sheets that is NOT
I made a few assumptions.
Like: What to do if there is a "Code" in one of the sheets that is NOT
represented in the Required Data sheet.
Or: if not ALL codes in the Required Data sheet are repredented in each of the
other sheets.
With this macro, if there are new codes in one of the detail she
HI Prince,,,
To avoid 0 s & na please use below formula
=IF(VLOOKUP(F4,B4:D9,2,0)=0,"",VLOOKUP(F4,B4:D9,2,0))
On Thu, Aug 16, 2012 at 10:52 PM, Prince Dubey wrote:
> Please see the attachment
>
>
> regards
> prince
>
> On Thursday, August 16, 2012 3:39:08 PM UTC+5:30, amar takale wrote:
>>
>>
>
thanks to one all.for sharing this material.
On Tue, Aug 14, 2012 at 8:20 AM, NOORAIN ANSARI wrote:
>
> Correct Rajan, You are right,
>
>
>> By Mistake i have send study material of Power Point instead of Power
>> pivot.
>> see attachment for Power pivot.
>>
>>
>> --
>> With Regards,
>> Noora
thanks alot ashish now i am able to fix it..
On Tue, Aug 7, 2012 at 9:39 PM, ashish koul wrote:
> result on google search
>
> http://www.youtube.com/watch?v=dBTkl1tnXao
> http://www.pcreview.co.uk/forums/scrolling-marquee-t917395.html
> http://officeone.mvps.org/powershow/powershow_ticker_show
You can use Pivot Table.
Regards,
Kuldeep Singh
On Fri, Aug 17, 2012 at 7:41 PM, SAGAR KASANGOTTUWAR <
sagarkasangottu...@gmail.com> wrote:
> Dear Friends,
>
> I want combine the data from other worksheets to one specific worksheet so
> kindly give me the fastest way to do same task.
>
> Note. I
Dear Friends,
I want combine the data from other worksheets to one specific worksheet so
kindly give me the fastest way to do same task.
Note. I HAVE NEAR ABOUT 200 worksheets which I WANT to combine.
THANKS IN ADVANCE,
Regards,
CA KSAGAR
--
Join official facebook page of this forum @
http
Looks like homework to me also but this should do it AFTER rounding your column
B into column A
=INDEX($A$3:$A$21,MATCH(LARGE(FREQUENCY($A$3:$A$21,$A$3:$A$21),ROW(A1)),FREQUENCY($A$3:$A$21,$A$3:$A$21),0))
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Amit G
Is this homework?
It sure looks like it.
I think we've been getting a LOT of that lately, school must have begun!
I SUPPOSE that school should be teaching how best to use resources at your
disposal to accomplish a task,
and this forum is DEFINITELY a valuable resource, so...
First of all, you've
plz ignore
On Fri, Aug 17, 2012 at 5:34 PM, Rakesh Kumar Sharma wrote:
> Hi Noorain,
>
> As you told to use INDEX MATCH to replace VLOOKUP .
>
> Plz find the attached file & share how to use these
>
> On Thu, Aug 16, 2012 at 6:11 PM, Rakesh Kumar Sharma <
> rakeshks@gmail.com> wrote:
>
>> D
Hi Noorain,
As you told to use INDEX MATCH to replace VLOOKUP .
Plz find the attached file & share how to use these
On Thu, Aug 16, 2012 at 6:11 PM, Rakesh Kumar Sharma wrote:
> Dear Noorain/ Amresh,
>
>
> Thank u so much for great helping.
>
>
>
> On Thu, Aug 16, 2012 at 4:21 PM, NOORAIN ANSA
Hi Pravin
It is not magic it is condtional formatting. The condition looks if a cell
is the same as the search cell and colors it.
On 17 August 2012 17:59, Pravin Gunjal wrote:
> *Can anyone inform me how it works.. Thanks!*
> * *
>
> *With regards,
> **Pravin Gunjal**
> *
>
> --
> Join
Dear Rakesh,
See attached sheet.
On Fri, Aug 17, 2012 at 4:13 PM, Rakesh Kumar Sharma wrote:
> Hi Noorain,
> As you told to use INDEX & MATCH to replace VLOOKUP .
> plz find the attached file & share how to use these
>
>
> On Thu, Aug 16, 2012 at 6:11 PM, Rakesh Kumar Sharma <
> rakeshks@g
Hi Noorain,
As you told to use INDEX & MATCH to replace VLOOKUP .
plz find the attached file & share how to use these
On Thu, Aug 16, 2012 at 6:11 PM, Rakesh Kumar Sharma wrote:
> Dear Noorain/ Amresh,
>
>
> Thank u so much for great helping.
>
>
>
> On Thu, Aug 16, 2012 at 4:21 PM, NOORAIN ANS
Dear Sundar,
Please try it..
Dear Sunder,
You can also use..
=IF(WEEKDAY(A1)=6,"Sun","")
On Fri, Aug 17, 2012 at 3:09 PM, Sundarvelan N wrote:
> Dear friends,
>
> I need to find is the date in the cell is sunday
>
> 8/3/2012 10:30 8/3/2012 11:47 8/3/2012 10:26 8/3/2012 10:03 8/3/201
Dear Sundervelan,
Please Use
=IF(TEXT(A2,"")="Sunday",1,"")
Cheers,
Andy
On Fri, Aug 17, 2012 at 3:27 PM, Sundarvelan N wrote:
> Please find the attached file for your reference.
>
>
> Thanks
> N.Sundarvelan
> 9600160150
>
>
>
> On Fri, Aug 17, 2012 at 3:13 PM, Manoj Kumar
> wrote:
>
>> H
Please find the attached file for your reference.
Thanks
N.Sundarvelan
9600160150
On Fri, Aug 17, 2012 at 3:13 PM, Manoj Kumar wrote:
> Hi Sundarvelan,
>
> Tri it..
>
> =Text(a1,"ddd")
>
> Regard
> Manoj
>
>
> On Fri, Aug 17, 2012 at 3:12 PM, Kuldeep Singh wrote:
>
>>
>> Hi Sundarvelan,
>>
>>
Hi Sundarvelan,
Tri it..
=Text(a1,"ddd")
Regard
Manoj
On Fri, Aug 17, 2012 at 3:12 PM, Kuldeep Singh wrote:
>
> Hi Sundarvelan,
>
> Please share a sample worksheet.
>
> Regards,
> Kuldeep Singh
>
>
> On Fri, Aug 17, 2012 at 3:09 PM, Sundarvelan N wrote:
>
>> Dear friends,
>>
>> I need to find
Hi Sundarvelan,
Please share a sample worksheet.
Regards,
Kuldeep Singh
On Fri, Aug 17, 2012 at 3:09 PM, Sundarvelan N wrote:
> Dear friends,
>
> I need to find is the date in the cell is sunday
>
> 8/3/2012 10:30 8/3/2012 11:47 8/3/2012 10:26 8/3/2012 10:03 8/3/2012
> 11:09 8/3/2012 1
Dear friends,
I need to find is the date in the cell is sunday
8/3/2012 10:30 8/3/2012 11:47 8/3/2012 10:26 8/3/2012 10:03 8/3/2012
11:09 8/3/2012 10:55 8/4/2012 10:57 8/3/2012 16:17 8/3/2012
14:21 8/3/2012
11:29 8/3/2012 11:28 8/3/2012 11:53 8/3/2012 14:33
Thanks
N.Sundarvelan
Hi Kuldeep
Its not working. Pls show example in sample file.
Regards
Amit
On Fri, Aug 17, 2012 at 12:08 PM, Kuldeep Singh wrote:
>
> You can try this.
>
> =COUNTIF(B3:B21,B3)>1
>
> Regards,
> Kuldeep Singh
> Phone.: +91-120-4763789, Extn.: 789
> naukrikuld...@gmail.com || www.naukri.com
> *Pl
*Can anyone inform me how it works.. Thanks!*
* *
*With regards,
**Pravin Gunjal**
*
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
44 matches
Mail list logo