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 by
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 by
pls chk
On Fri, Feb 15, 2013 at 3:03 PM, vatspoojav...@gmail.com 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.
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, vatspoojav...@gmail.com wrote:
Hi All,
I seek your guidance in the attached sheet, wherein, currently I am
updating manually the column: I Correct Cost Centre
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 todhavals...@gmail.comwrote:
Dear Friends
pls refer my sheet
Hi Vijay and Dhaval,
This is not giving the right solution.
Regards
Pooja
Sent from BlackBerry® on Airtel
-Original Message-
From: vijayajith VA vijayajith...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 15 Feb 2013 15:08:39
To: excel-macros@googlegroups.com
Reply-To:
=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, vatspoojav...@gmail.com wrote:
**
Hi Vijay and Dhaval,
This is not giving the right solution.
Regards
Pooja
Sent from BlackBerry® on Airtel
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
neerajchauhan...@gmail.comwrote:
Dear Experts,
kindly find the attached sheet and send the formula in excel for reverse
value
--
Are you
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
neerajchauhan...@gmail.comwrote:
Dear Experts,
kindly find the attached sheet
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
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
Hi,
solved your query. see the attachment.
On Fri, Feb 15, 2013 at 2:20 PM, vatspoojav...@gmail.com 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
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
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 be
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 amartak...@gmail.com wrote:
Dear Sekar,
Great!
Thanks a lot,extact which work
Thanks Sekar,I will wait for your reply
On Sat, Feb 16, 2013 at 8:40 AM, RAJA SEKAR apkra...@gmail.com 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
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*
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 naukrikuld...@gmail.comwrote:
Hi Experts,
What is *Ylookup in Excel*. I know only Vlookup, Hlookup
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
looks typo
On Sat, Feb 16, 2013 at 12:52 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
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,
@ 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
Thanks a ton David, finally got it working..
On Sat, Feb 16, 2013 at 3:42 AM, David Grugeon da...@grugeon.com.au 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
22 matches
Mail list logo