As per my observation this is producing wrong result, please check it once
again.
On Fri, Apr 8, 2011 at 9:34 AM, §»VIPER«§ viper@gmail.com wrote:
hi syed,
find the attached without array.
--
*Thanks Regards
Thamu
*
On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim
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 dilipan...@gmail.com wrote:
Hi Naresh,
Please check the attached file for required solution.
I have used
good
On Wed, Feb 23, 2011 at 11:13 AM, Harmeet Singh harmeet.hew...@gmail.comwrote:
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
Good Formula! Please brief its logic especially about 2.
On Sun, Jan 16, 2011 at 10:27 AM, Ms-Exl-Learner . ms.exl.lear...@gmail.com
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.
Really Impressive!
Let me know how this formula works
On Tue, Dec 28, 2010 at 3:43 PM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi,
A shorter version would be:
=MONTH(--(1A1))
This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended
abbreviations (eg Sept) and
Good.
On Tue, Dec 28, 2010 at 7:39 PM, Daniel dcolarde...@free.fr 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
À :
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 excel users:
1
Very Good!
On Thu, Nov 18, 2010 at 12:55 PM, johnson john johnsond...@gmail.comwrote:
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
Very simple! Good
On Fri, Nov 12, 2010 at 11:49 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
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 jaihumtu...@gmail.com wrote:
Good!
On Sun, Dec 13, 2009 at 6:01 PM, Dilip Pandey dilipan...@gmail.com 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 -
I think your solution is best.
On Wed, Dec 23, 2009 at 3:18 PM, Dilip Pandey dilipan...@gmail.com 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
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
'Error
Good!
On Tue, Jul 6, 2010 at 8:55 AM, WizExcel ssw...@gmail.com wrote:
This is just too good Ayush ,
thanks for the explanation.
On Jul 5, 8:16 pm, Ayush jainayus...@gmail.com wrote:
Thanks Ankit.
As the running count was required, The formula should have running
range. I have used
it's not working...
On Sun, Jul 4, 2010 at 3:03 PM, ayush jain jainayus...@gmail.com 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
Very Good!
On Sat, Jul 3, 2010 at 2:15 PM, ashish koul koul.ash...@gmail.com wrote:
Thanks a lot Dave.
On Sat, Jul 3, 2010 at 2:22 PM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi,
A1 = *United States of America*
=FIND(CHAR(1),SUBSTITUTE(A1,
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 koul.ash...@gmail.com wrote:
hi
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If ActiveCell.Row = 2 And
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.
--
17 matches
Mail list logo