Please help me in attached sheet.
i have 5 sheets, sheet1 to sheet5 each sheet contain 97%, 98%, 99%, 58%,
100% of recovery in Cell a respectively.
Now i want to cot count only those recoveries which are above to 97%.
Urgent Please.
--
Good!
On Tue, Jul 6, 2010 at 8:55 AM, WizExcel wrote:
> This is just too good Ayush ,
> thanks for the explanation.
>
>
> On Jul 5, 8:16 pm, Ayush wrote:
> > Thanks Ankit.
> > As the running count was required, The formula should have running
> > range. I have used Row f(x) to return the curren
it's not working...
On Sun, Jul 4, 2010 at 3:03 PM, ayush jain wrote:
> Hi Neil,
>
> As there are multiple items in a range, You need to use FOR EACH statement
> to add items of range one by one in listbox.
> Attached is the solution for your reference.
>
> I hope it helps. Please let me know if
Very Good!
On Sat, Jul 3, 2010 at 2:15 PM, ashish koul wrote:
> Thanks a lot Dave.
>
>
>
> On Sat, Jul 3, 2010 at 2:22 PM, Dave Bonallack
> wrote:
>
>> Hi,
>> A1 = *United States of America*
>>
>> =FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,"
>> ",""
>> Fir
Good!
But instead of copy paste we can use bring to front by keeping all images on
same position.
On Thu, Jul 1, 2010 at 7:38 PM, ashish koul wrote:
> hi
>
>
> Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
> Boolean)
>
>
> If ActiveCell.Row = 2 And ActiveCell.Column =
Very Good!
On Tue, Jul 6, 2010 at 1:19 PM, Intelligent But Crazy
wrote:
> Hi Zaf
>
> PFA the gantt chart
>
> Thanks
> SecretShot
>
> On 7/6/10, zafnu wrote:
> > Hi,
> > Can u please help me to create a '*Gnatt Chart*' in excel. your immediate
> > action is highly appreciated.
> >
> > Thanks & re
Very Good information!
On Thu, Oct 14, 2010 at 6:30 PM, Paul Schreiner wrote:
> Do you mean to change the file associations?
>
> For that, what you do is change your own associations.
> Then go to the system registry (using run -Regedit)
> Find your .xlsx extensions, right-click and "export" the
Very Good Information!
On Fri, Oct 22, 2010 at 1:33 PM, Ashish Jain <26may.1...@gmail.com> wrote:
> Hi Omar
>
> Here is line by line description of the VBA code you provided:
>
>
> Sub OMAR_QUERY()
> 'Error Handling ON: In case of error, it will skip to next line.
>On Error Resume Next
>'
I think your solution is best.
On Wed, Dec 23, 2009 at 3:18 PM, Dilip Pandey wrote:
> Dear Gobet,
>
> Use following formula in the column B and drag it down.
>
> =RIGHT(A2,LEN(A2)-FIND("@",A2)+1)
>
> solved workbook is also attached. Thanks
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
Good!
On Sun, Dec 13, 2009 at 6:01 PM, Dilip Pandey wrote:
> Ok, The solution is revised as per your needs. One thing the data scenario
> given by you has some conflict. Explained below:-
>
> 11/1/09 123456 -> duplicate
> 10/19/09123456 -> original
> 12/1/09
Very simple! Good
On Fri, Nov 12, 2010 at 11:49 AM, NOORAIN ANSARI
wrote:
> Dear Jai...
>
> Please see attachment..
>
> =TEXT(D5-D6,"YY ")&"YEAR, "&TEXT((D5-D6),"mm")&" MONTH,
> "&TEXT((D5-D6),"dd")&" DAYS"
> Thanks,
> Noorain
> On Thu, Nov 11, 2010 at 9:47 PM, Jai wrote:
>
>> Dear Groups
>
Very Good!
On Thu, Nov 18, 2010 at 12:55 PM, johnson john wrote:
> just try this.,
>
> Sub Y_1()
> Range("a1") = Format(Now(), "HH:MM:SS")
> Application.OnTime Now() + TimeValue("00:00:01"), "Y_1"
> End Sub
>
> Best regards.,
>
> On Thu, Nov 18, 2010 at 12:50 PM, siti Vi wrote:
>
>> Anda belum s
workbook remain
unsaved. how can i determine through VBA when "send as attachment command"
save workbook temporarily.
Waiting for A Good solution.
Thanks.
Sajid Mansoor
--
--
Some important links for exce
Really Impressive!
Let me know how this formula works
On Tue, Dec 28, 2010 at 3:43 PM, Dave Bonallack
wrote:
> Hi,
> A shorter version would be:
> =MONTH(--(1&A1))
> This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended
> abbreviations (eg Sept) and also unabbreviated (eg
Good.
On Tue, Dec 28, 2010 at 7:39 PM, Daniel wrote:
> Please, see attached file.
> Regards.
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> De
> la part de Rajiv Kumar
> Envoyé : lundi 20 décembre 2010 15:11
> À : excel-macr
Good Formula! Please brief its logic especially about 2.
On Sun, Jan 16, 2011 at 10:27 AM, Ms-Exl-Learner . wrote:
> Hi John,
>
> It will work in version 2003 if you refer the cell reference to part of the
> column range instead of referring it to the whole column.
>
> =LOOKUP(2,FIND(A1,Sheet2!A
good
On Wed, Feb 23, 2011 at 11:13 AM, Harmeet Singh wrote:
> I Hope this will help.
>
>
> Warm Regards,
>
> Harmeet Singh
> IT Analyst
> McKinsey & Company
> http://www.facebook.com/Harmeeet
>
>
>
> On Wed, Feb 23, 2011 at 4:03 PM, ashish koul wrote:
>
>> you want to save blank e
Why are you using this lengthy formula?
=INDIRECT(VLOOKUP($B$15,I$2:I$6,1,0))
instead of
=INDIRECT($B$15) (Working Fine as above one)
On Sun, Feb 27, 2011 at 10:19 PM, Dilip Pandey wrote:
> Hi Naresh,
>
> Please check the attached file for required solution.
>
> I have used Name definition ma
As per my observation this is producing wrong result, please check it once
again.
On Fri, Apr 8, 2011 at 9:34 AM, §»VIPER«§ wrote:
> hi syed,
>
> find the attached without array.
>
> --
> *Thanks & Regards
>
> Thamu
> *
>
> On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim <
> hashim...@gma
19 matches
Mail list logo