Thanks a ton David, finally got it working..
On Sat, Feb 16, 2013 at 3:42 AM, David Grugeon wrote:
> Try (c.value & ":!b9:b28")
>
>
> On Saturday, 16 February 2013, amitjha2487 wrote:
>
>> Hello everyone,
>> what i am trying to do is iterate through a range containing worksheet
>> names and if
@ Vijay:
No, is this not a typing mistake because Vlookup & Hlookup also type
correct & IIIrd Ylookup is specify in job posting in moster site.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*
looks typo
On Sat, Feb 16, 2013 at 12:52 PM, Kuldeep Singh wrote:
>
> Hi Vijay,
>
> I know Ylookup is not available in Any Excel. For more information please
> see below URL:
>
> http://jobs.monsterindia.com/details/12696222.html
>
> Same Line in URL : Knwoledge:- *V-look up, Y-look up, H-loo
Hi Vijay,
I know Ylookup is not available in Any Excel. For more information please
see below URL:
http://jobs.monsterindia.com/details/12696222.html
Same Line in URL : Knwoledge:- *V-look up, Y-look up, H-look up (in excel
master ) & SENSYS EASY PAY . & TDS.*
Regards,
Kuldeep Singh
Info Edge I
Hi Kuldeep,
Where did you got ths information. pls share. i dont have idea.
Thr is no Ylookup in excel..thanks
On Sat, Feb 16, 2013 at 12:00 PM, Kuldeep Singh wrote:
>
> Hi Experts,
>
> What is *Ylookup in Excel*. I know only Vlookup, Hlookup & Lookup. If you
> know,
Hi Experts,
What is *Ylookup in Excel*. I know only Vlookup, Hlookup & Lookup. If you
know, please give some examples of Ylookup.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consi
Thanks Sekar,I will wait for your reply
On Sat, Feb 16, 2013 at 8:40 AM, RAJA SEKAR wrote:
> Dear Amit,
>
> for min and Max for Entire Range use
>
>
> MIN(R_S1) & MAX(R_S1) @ ADJ CloseColumn
> Min (R_S2) & MAX(R_S2) @ Relative Performance Column
>
> let me to work out on rest
>
>
> On 15 Fe
Dear Amit,
for min and Max for Entire Range use
MIN(R_S1) & MAX(R_S1) @ ADJ CloseColumn
Min (R_S2) & MAX(R_S2) @ Relative Performance Column
let me to work out on rest
On 15 February 2013 14:17, amar takale wrote:
> Dear Sekar,
>
> Great!
> Thanks a lot,extact which work I want through
Try (c.value & ":!b9:b28")
On Saturday, 16 February 2013, amitjha2487 wrote:
> Hello everyone,
> what i am trying to do is iterate through a range containing worksheet
> names and if the cell is not empty then add the result of CountA function
> to the count variable. So the count variable should
Hi Dave,
I am afraid there is something weird going on. even in a blank spreadsheet,
if I try to open the VB editor, it gives me an out of memory error. I don't
believe it. I have 8 GB ram. also the macro you sent me works in excel 97
and exel 2010. but I can't open it or edit it in my accountin
Hi,
solved your query. see the attachment.
On Fri, Feb 15, 2013 at 2:20 PM, wrote:
> Hi All,
>
> I seek your guidance in the attached sheet, wherein, currently I am
> updating manually the column: I "Correct Cost Centre & Contracts".I am
> updating this from the data available in correspond
Hello everyone,
what i am trying to do is iterate through a range containing worksheet
names and if the cell is not empty then add the result of CountA function
to the count variable. So the count variable should be equal to number of
non lank cells in range B9:B28 on the worksheets I'm iteratin
Hi Dave,
it is me again! you provided a macro for me that would accumulate grocery
expenses in a column with the cursor remaning in the cell for each entry.
I would like to edit the macro but can't remember the name!! how can I see
the list of macros without knowing its name? Thanks for your inte
Dear Neeraj,
Try it..
Function Reverse_Order(rng As Range)
Dim i%
For i = Len(rng) To 1 Step -1
Reverse_Order = Reverse_Order & Mid(rng, i, 1)
Next i
End Function
On Fri, Feb 15, 2013 at 4:23 PM, neeraj chauhan
wrote:
> Dear Experts,
>
> kindly find the attached sheet and send the formula in e
Hi Chauan,
Use ths UDF..
Function RevStr(Rng As Range)
RevStr = StrReverse(Rng.Text)
End Function
On Fri, Feb 15, 2013 at 4:23 PM, neeraj chauhan
wrote:
> Dear Experts,
>
> kindly find the attached sheet and send the formula in excel for reverse
> value
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E
=IFERROR(VLOOKUP(A2,'Cost Center1'!$A$2:$A$21,1,0)," ") use iferror .&
concatenate those four cells...
On Fri, Feb 15, 2013 at 3:34 PM, wrote:
> **
> Hi Vijay and Dhaval,
>
> This is not giving the right solution.
>
> Regards
> Pooja
> Sent from BlackBerry® on Airtel
> -
Hi Vijay and Dhaval,
This is not giving the right solution.
Regards
Pooja
Sent from BlackBerry® on Airtel
-Original Message-
From: vijayajith VA
Sender: excel-macros@googlegroups.com
Date: Fri, 15 Feb 2013 15:08:39
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macro
Thanks Dear
On Tue, Feb 12, 2013 at 10:04 PM, >>Excel Beginner<< <
excelbegin...@gmail.com> wrote:
> Hi Dhaval,
>
> Find the attachment.
>
>
>
>
>
>
> --
> *Regards,*
> *
> *
> *Excel Beginner*
> On Tue, Feb 12, 2013 at 1:42 PM, Dhaval Shah wrote:
>
>> Dear Friends
>>
>> pls refer my
Hi
=IFERROR(VLOOKUP(A2,'Cost Center1'!$A$2:$A$21,1,0)," ") .if you want blank
in place of N/A
On Fri, Feb 15, 2013 at 2:20 PM, wrote:
> Hi All,
>
> I seek your guidance in the attached sheet, wherein, currently I am
> updating manually the column: I "Correct Cost Centre & Contracts".I am
> upda
pls chk
On Fri, Feb 15, 2013 at 3:03 PM, wrote:
> Hi All,
>
> I seek your guidance in the attached sheet, wherein, currently I am
> updating manually the column: I "Correct Cost Centre & Contracts".I am
> updating this from the data available in corresponding columns: D,E,F &G.
> Therefore, plea
Hi All,
I seek your guidance in the attached sheet, wherein, currently I am updating
manually the column: I "Correct Cost Centre & Contracts".I am updating this
from the data available in corresponding columns: D,E,F &G. Therefore, please
guide with a formula which can extract the required data
Hi All,
I seek your guidance in the attached sheet, wherein, currently I am updating
manually the column: I "Correct Cost Centre & Contracts".I am updating this
from the data available in corresponding columns: D,E,F &G. Therefore, please
guide with a formula which can extract the required data
22 matches
Mail list logo