Hi Kalyan,
PFA the file updated with formula . I use index and Match Function to get
the results.
thanks,
Sarva
Thanks & Regards,
*Saravanan Raju*
Mob: +91 8807708842
+91 9449716334
On Tue, Nov 15, 2016 at 4:24 PM, Kal xcel wrote:
> Dear Experts,
>
> Please help
Please have a look
On Thu, Oct 27, 2016 at 4:41 AM, Kal xcel wrote:
> Dear Experts,
>
> Please help me to solve the query.
>
> --
> *Kalyan Chattopadhyay*
>
>
> *Executive Corporate MIS*
>
> *Joy Cosmetics*
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Thank you Sanjeev for solving my query.
On Mon, Sep 19, 2016 at 5:32 PM, Sanjeev Tyagi
wrote:
> Dear Kalyan,
>
> Pls see the formula below. I hope it helps.
>
> =ABS(TRIM(MID(A2,SEARCH("gX",A2,1)-3,3)))&"g"
>
> Regards
> Sanjeev Tyagi
>
> On Mon, Sep 19, 2016 at 4:47
Dear Kalyan,
Pls see the formula below. I hope it helps.
=ABS(TRIM(MID(A2,SEARCH("gX",A2,1)-3,3)))&"g"
Regards
Sanjeev Tyagi
On Mon, Sep 19, 2016 at 4:47 PM, Kal xcel wrote:
> Dear Experts,
>
> Please help me to solve the query
>
> Thanks in advance
>
> --
> *Kalyan
Wow.Ashish,
After a long time
You are still in this group.Helping peopleGr8 yaar
How are you??
Where are you now??
Thanks a lot brother...Formula working perfectly
On Fri, Sep 16, 2016 at 9:57 PM, Ashish Koul wrote:
>
Welcome back Ashish!.
--
On Fri, Sep 16, 2016 at 9:57 PM, Ashish Koul wrote:
> =IF(COUNTIFS($A:$A,$G9,$B:$B,$F9,$C:$C,H$4)=1,"Y","N")
>
> On Fri, Sep 16, 2016 at 9:47 PM, Kal xcel wrote:
>
>> Dear Experts,
>>
>> Please help me to solve the attached
=IF(COUNTIFS($A:$A,$G9,$B:$B,$F9,$C:$C,H$4)=1,"Y","N")
On Fri, Sep 16, 2016 at 9:47 PM, Kal xcel wrote:
> Dear Experts,
>
> Please help me to solve the attached query.
>
> --
> *Kalyan Chattopadhyay*
>
>
> *Executive Corporate MIS*
>
> *Joy Cosmetics*
>
> --
> Are you
Hi Sachin,
use below excel function.
=LOOKUP("ZZZ",$M$3:M3)
thanks
satendra
On Tue, Aug 16, 2016 at 2:10 PM, सचिन शर्मा
wrote:
> Dear All,
>
>
> Please help to resolve below query.
>
>
> Share the function to get the same result which in yellow cells
>
> **
PFA & Confirm
On Thu, May 5, 2016 at 2:54 PM, wrote:
> Hello
>
> PFA
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM
http://www.techrepublic.com/blog/windows-and-office/excels-auto-outline-quickly-hides-data-details-to-simplify-viewing/
go to the above url or watch the following url on youtube
https://www.youtube.com/watch?v=8j6KX6WDgEM
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
Did anybody knows the answer
On Tue, Mar 22, 2016 at 3:32 PM, Muhammad Arslan
wrote:
> Hi
> Hope you are doing well. I have query regarding auto hide of rows in
> excell, sample file is attached in this mail. If anybody knows how it
> works, kindly teach me. This file
Thanks AshishI was making mistake while freezing the cells.
Thanks for the support.
Regards,
Pooja
On 21 Mar 2016 19:58, "Ashish Koul" wrote:
> see attachment
>
> On Mon, Mar 21, 2016 at 7:54 PM, Pooja Sharma
> wrote:
>
>> Hi Ashish,
>>
>>
see attachment
On Mon, Mar 21, 2016 at 7:54 PM, Pooja Sharma
wrote:
> Hi Ashish,
>
> This is not working.It is giving 0 value.
>
> Regards,
> Pooja Sharma
> On 21 Mar 2016 19:30, "Ashish Koul" wrote:
>
>>
Hi Ashish,
This is not working.It is giving 0 value.
Regards,
Pooja Sharma
On 21 Mar 2016 19:30, "Ashish Koul" wrote:
> =VLOOKUP($A16,$A$2:$H$10,MATCH(B$15,$A$2:$H$2,0),0)
>
> On Mon, Mar 21, 2016 at 7:27 PM, Pooja Sharma
> wrote:
>
>> Hi All,
=VLOOKUP($A16,$A$2:$H$10,MATCH(B$15,$A$2:$H$2,0),0)
On Mon, Mar 21, 2016 at 7:27 PM, Pooja Sharma
wrote:
> Hi All,
>
> Hi All,
>
> I have a query, if there is any possibility to apply Vlookup and Hlookup
> together to achieve results as required in the attached sheet.
>
m: Mandeep Baluja <rockerna...@gmail.com>
To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
Cc: schreiner_p...@att.net
Sent: Monday, November 9, 2015 8:12 AM
Subject: Re: $$Excel-Macros$$ Query for Excel
Thanks Paul :)
The thing I am already aware about workbook_open ev
What format are the original (5) files in?Are they text, csv, or excel files?
What is the relationship between the 90,000 records and the other 5 files?That
is, do the records show up once in the list of 90,000 and show up multiple
times in the 5 files?What are the "key" field? (those in common
In VBA:Go to the "ThisWorkbook" module.
In the programming pane, on the top left, use the pull-down to select
"Workbook".
If it doesn't already exist, a
Private Sub Workbook_Open()event macro will be created.
This macro runs once the workbook is open.
BTW: At the top-right of the pane, the
-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query for Code
Also, based on your statement:in the summary sheet we want to see total of all
centres based on the month of selection which is a respective start date
implies that, if you have 30 centres:let's say 10 started in May, 10 started
-
From: gargee singh garge...@hotmail.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Tuesday, July 28, 2015 1:05 AM
Subject: RE: $$Excel-Macros$$ Query for Code
!--#yiv8905106271 .yiv8905106271hmmessage
P{margin:0px;padding:0px;}#yiv8905106271
you can.” - John Wesley
-
From: gargee singh garge...@hotmail.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Tuesday, July 28, 2015 1:05 AM
Subject: RE: $$Excel-Macros$$ Query for Code
!--#yiv8905106271
So, you're saying that if you select May 1, 2016 on the Summary Sheet,only the
column for May 1, 2016 on the Summary sheet (column G) will be populated?and
it will be a sum of all sheets in which the first column matches the date
selected?In your example, even though sheets A and C have a
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query for Code
So, you're saying that if you select May 1, 2016 on the Summary Sheet,only the
column for May 1, 2016 on the Summary sheet (column G) will be populated?and
it will be a sum of all sheets in which the first column matches
Hi Soumyendu,
PDF
--
Thanks Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Sat, Jul 11, 2015 at 8:48 AM, Soumyendu Paul soumyendu...@gmail.com
wrote:
Dear All,
My query for attached file When we select data from drop down A cursor to
move A6;when we select B from drop down
http://www.excelvbamacros.in/2014/02/loop-through-all-outlook-emails-saved.html
On Wed, Jun 3, 2015 at 4:20 PM, Soumyendu Paul soumyendu...@gmail.com
wrote:
Hi,
I have an outlook message stored in hard drive folder. Want to read this
file for extracting data into excel. Please help!!
little mistake,, but now done
=IFERROR(TRIM(CONCATENATE(MOC
,MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,),
,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,),
,)))+3),2+(IF(AND((CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,),
This will work
=IFERROR(IFERROR(MID(A2,FIND(MOC,A2,8),7),UPPER(MID(A2,FIND(moc,A2,7),8))),UPPER(MID(A2,FIND(Moc,A2,7),8)))
However may of the cases it is written like MOC 9 or MOC - 08 hence some
garbage is appearing. you can remove by text to coloumn command.
Prashant
On Wed, May 20, 2015
Dear Kalyan,
It’s Done!!!
PFA
=IFERROR(TRIM(CONCATENATE(MOC ,MID(SUBSTITUTE(SUBSTITUTE(A1351,-,),
,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(A1351,-,),
,)))+3),2+(IF(AND((CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(A1351,-,),
,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(A1351,-,),
Excel 2010 and file is on the same machine. Vabz I know the procedure to
get the data from excel file but here my file is always large and opening
will take a lot of time .
On Tuesday, April 28, 2015 at 11:59:45 AM UTC+5:30, Vabz wrote:
Which version of excel you are using?
Are both file
Which version of excel you are using?
Are both file on same machine or they are on Network?
On Tue, Apr 28, 2015 at 11:34 AM, Mandeep Baluja rockerna...@gmail.com
wrote:
My mmaster file is large and i just want to do lookup on my sheet from
master file without opening my master file as it is
Hello,
Please solve this query!!!
--
Thanks Regards
*Sunil Kumar Yadav*
* Sr. Executive - *MIS (Billing Deptt.)
Skype ID: sunil.yadav7186
On Tue, Mar 24, 2015 at 5:27 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com
wrote:
Dear
Team,
PFA file and check my query.
--
Thanks Regards
can you explain one example..
On Wed, Mar 25, 2015 at 1:45 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com
wrote:
Hello,
Please solve this query!!!
--
Thanks Regards
*Sunil Kumar Yadav*
* Sr. Executive - *MIS (Billing Deptt.)
Skype ID: sunil.yadav7186
On Tue, Mar 24, 2015 at 5:27 PM,
check formula in col E, If there are more than 2 case of overlap then 1st
will be shown as ok second will be as error.
In case it is more than 2 case of overlap then 1st will be shown as ok
rest all will be shown as error..
Cheers!!
On Wed, Mar 25, 2015 at 2:01 PM, Vaibhav Joshi v...@vabs.in
Awesome Sir :-) and thanks
--
Thanks Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Wed, Mar 25, 2015 at 2:13 PM, Vaibhav Joshi v...@vabs.in wrote:
check formula in col E, If there are more than 2 case of overlap then 1st
will be shown as ok second will be as error.
In case it
Replace .addattachment rngAttach1.Value with
If Dir(rngAttach1.Value) Then
.addattachment rngAttach1.Value
End If
Cheers!!
On Tue, Mar 24, 2015 at 9:05 AM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
When value of path is null, function by default set 0 in cell F2, so I
tried below
Before adding att check if attachment exists or not, if its null then you
will get error...
Cheers!!
On Mon, Mar 23, 2015 at 5:00 PM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
Dear experts,
See the attached file of email sending from excel. Normally mail send
successfully to all
When value of path is null, function by default set 0 in cell F2, so I
tried below code to avoid error on path not written in cell. but though
same error is occur, pls do something in coding.
If ws.Range(F2) Chr(48) Then
.addattachment rngAttach1.Value
End If
On Mon,
Check this..
Cheers!!
On Thu, Mar 12, 2015 at 1:43 PM, Mandeep baluja mandeepbal...@gmail.com
wrote:
Quuery for autofit
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Hi Mandeep,
Please check the attached file. let me know if I am missing something.
Regards
Gaurav Devrani
On Thu, Mar 12, 2015 at 1:43 PM, Mandeep baluja mandeepbal...@gmail.com
wrote:
Quuery for autofit
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Not working Range(C8).CurrentRegion.Columns.AutoFit this line will unhide
the hide columns in between the range. i have tried visible columns
property but its not working.
On Thursday, 12 March 2015 14:37:51 UTC+5:30, Gaurav Devrani wrote:
Hi Mandeep,
Please check the attached file. let
Okay. .I got it.
On Thu, Mar 12, 2015 at 2:41 PM, Mandeep baluja mandeepbal...@gmail.com
wrote:
Not working Range(C8).CurrentRegion.Columns.AutoFit this line will
unhide the hide columns in between the range. i have tried visible columns
property but its not working.
On Thursday, 12
Hi Kal Excel,
PFA resolved query of yours.
Regards,
Waseem Saifi
On Thu, Nov 13, 2014 at 5:11 PM, Kal xcel kalx...@gmail.com wrote:
Dear Experts,
Please help me to solve my query.
Thanks in advance
--
*Kalyan Chattopadhyay*
*Executive Corporate MIS*
*Joy Cosmetics*
--
Are you
nice, thanks ravinder
Thanks Regards,
Prabhu R
On 18 March 2014 11:16, Ravinder ravindervbacli...@gmail.com wrote:
pfa
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Prabhu Pinky
*Sent:* Sunday, March 16, 2014 8:02 AM
*To:*
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhu Pinky
Sent: Sunday, March 16, 2014 8:02 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ query need help
Hi experts,
please find the attached file. my query is.
i want
Sub TES()
Dim i As Long
Dim cl As Range
For Each cl In Sheets(Sheet1).Range(c1:c31)
If Weekday(cl.Value, vbMonday) 6 Then
With Sheets(Sheet2).Range(XFD2).End(xlToLeft).Offset(0, 1)
.Value = cl
.NumberFormat = DD-MMM-
End With
End If
Next
End Sub
On Sun, Mar 16, 2014 at 8:03 AM,
sorry,
in sheet 1 dates will be in vertical, but in sheet 2 i want to fill in
horizontal.
Thanks Regards,
Prabhu R
On 16 March 2014 08:02, Prabhu Pinky prabhupin...@gmail.com wrote:
Hi experts,
please find the attached file. my query is.
i want to fill dates in sheet2 from sheer1.
Hi Team,
Can you help me to fix this small thing.
Regards
Atul
On Sun, Mar 9, 2014 at 7:04 PM, Atul Kesaria atul.kesa...@gmail.com wrote:
Hi Team,
Thanks for the help. However just found one bug in macro. If the status is
N in the AE column then the macro stops at that row and does not
Hi Team,
Thanks for the help. However just found one bug in macro. If the status is
N in the AE column then the macro stops at that row and does not processed
over to the next row even if the status is Y.
Please help in solving that.
Regards
Atul
On Mon, Feb 17, 2014 at 3:53 PM, mrExcel4u
Hi Prafull,
Try this if you want to use In Cell formulas, paste bellow code in module
Function IsOK(CRef As Range) As String
Dim Str As String
Str = UCase(CRef.Value)
If InStr(1, Str, YES) Or InStr(1, Str, NO) Or InStr(1, Str,
CORRECT) Then IsOK = OK
End Function
Then just type in
Try this
Sub query()
Dim rng As Range
Dim cel As Range
Set rng = Range(A1:a10)
For Each cel In rng
If cel = Yes Or cel = No Or cel = Correct Then
cel.Offset(0, 1) = Ok
End If
Next cel
End Sub
Thanks regards,
www.MrExcel4U.com http://mrexcel4u.blogspot.com/
On Wed, Feb
Hi Atul,
PFA...
Thanks regards,
www.MrExcel4U.com http://mrexcel4u.blogspot.com/
On Mon, Feb 17, 2014 at 1:15 PM, Atul Kesaria atul.kesa...@gmail.comwrote:
Hi Team,
Can some one help.
Regards
Atul
On Wed, Feb 12, 2014 at 1:46 PM, Atul Kesaria atul.kesa...@gmail.comwrote:
Hi
Hi Team,
Can some one help.
Regards
Atul
On Wed, Feb 12, 2014 at 1:46 PM, Atul Kesaria atul.kesa...@gmail.comwrote:
Hi Team,
I need a help in creating a macro for attached sheet
Process Brief:-
1) Need to send email to people based of status as per column AE. If
status is Y: then mail
Thanks Ravinder. This works perfect for me. :-)
Also, can you guide me with material/ website from which i
can learn dashboard from scratch to end.
Regards,
Ashwani
On Thu, Oct 3, 2013 at 12:40 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
PFA, I think u r looking for this.
** **
Hi All,
Any update on this?
Regards,
Ashwani
On Wed, Oct 2, 2013 at 7:20 PM, ashwani agnihotri
ashwani.agniho...@gmail.com wrote:
Hi All,
I have attached an excel for reference I want to know if I can create a
dashboard werein if I select a team , the rest of the data about the team
@googlegroups.com [mailto:
excel-macros@googlegroups.com]
On Behalf Of De Premor
Sent: Saturday, September 14, 2013 10:03 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query on vlookup
Try this formula
=VLOOKUP(H3,A3:G13,MATCH(TOTAL,$A$2:$G$2,0),0)
On 14-09-2013 11:28
,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of De Premor
Sent: Saturday, September 14, 2013 10:03 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query on vlookup
Try this formula
=VLOOKUP(H3,A3:G13,MATCH(TOTAL
=VLOOKUP(F3,A:E,MATCH(Total,$2:$2,0),0)
On Sat, Sep 14, 2013 at 9:58 AM, Shrinivas Shevde shrinivas...@gmail.comwrote:
Dear All
Query on vlookup
Please look at the attached sheet.
Thanks in advance
--
Shrini
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
Try this formula
*=VLOOKUP(H3,A3:G13,MATCH(TOTAL,$A$2:$G$2,0),0)*
On 14-09-2013 11:28, Shrinivas Shevde wrote:
Dear All
Query on vlookup
Please look at the attached sheet.
Thanks in advance
--
Shrini
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
It’s
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query on vlookup
Try this formula
=VLOOKUP(H3,A3:G13,MATCH(TOTAL,$A$2:$G$2,0),0)
On 14-09-2013 11:28, Shrinivas Shevde wrote:
Dear All
Query on vlookup
Please look at the attached sheet.
Thanks in advance
--
Shrini
--
Are you =EXP(E:RT
: $$Excel-Macros$$ Query on vlookup
** **
Try this formula
*=VLOOKUP(H3,A3:G13,MATCH(TOTAL,$A$2:$G$2,0),0)*
On 14-09-2013 11:28, Shrinivas Shevde wrote:
Dear All
Query on vlookup
Please look at the attached sheet.
Thanks in advance
--
Shrini
Yes, it is possible via Multipal consolidate ranges
Just press Alt+D+P then select Multipal consolidate ranges
.
Enjoy
Team XLS
On Sat, Aug 24, 2013 at 12:36 PM, Waseem Saifi waseemsa...@gmail.comwrote:
Dear Experts,
Is it possible to make a pivot table basis
Thanx
[?]
On Sat, Aug 24, 2013 at 2:09 PM, xlstime xlst...@gmail.com wrote:
Yes, it is possible via Multipal consolidate ranges
Just press Alt+D+P then select Multipal consolidate ranges
.
Enjoy
Team XLS
On Sat, Aug 24, 2013 at 12:36 PM, Waseem Saifi
thank you so much ravinder.
it's working absolutely fine.
On Thu, Aug 1, 2013 at 11:15 AM, ravinder negi ravi_colw...@yahoo.comwrote:
you can use
=SUM(INDIRECT(CELL(address,INDIRECT(r7cMATCH(B2,F6:M6,0)+5,FALSE)):CELL(address,INDIRECT(rMATCH(B3,E7:E10,0)+6cMATCH(B2,F6:M6,0)+5,FALSE
You can also use this
=SUM(OFFSET(E6,1,MATCH(B2,F6:M6,0),MATCH(B3,E7:E10,0)))
Pada 01/08/2013 13:00, Waseem Saifi menulis:
thank you so much ravinder.
it's working absolutely fine.
On Thu, Aug 1, 2013 at 11:15 AM, ravinder negi ravi_colw...@yahoo.com
mailto:ravi_colw...@yahoo.com wrote:
de premor, it's too easy !
thank you so much
On Thu, Aug 1, 2013 at 11:33 AM, De Premor d...@premor.net wrote:
You can also use this
=SUM(OFFSET(E6,1,MATCH(B2,F6:M6,0),MATCH(B3,E7:E10,0)))
Pada 01/08/2013 13:00, Waseem Saifi menulis:
thank you so much ravinder.
it's working
you can use
=SUM(INDIRECT(CELL(address,INDIRECT(r7cMATCH(B2,F6:M6,0)+5,FALSE)):CELL(address,INDIRECT(rMATCH(B3,E7:E10,0)+6cMATCH(B2,F6:M6,0)+5,FALSE
From: Waseem Saifi waseemsa...@gmail.com
To: excel-macros excel-macros@googlegroups.com
Sent: Thursday,
Dear Expert ,
Can you expline the bold line as i want to know deeply.
Function Reverse(Text As String) As String
Dim i As Integer
Dim StrNew As String
Dim strOld As String
strOld = Trim(Text)
For i = 1 To Len(strOld)
* StrNew = Mid(strOld, i, 1) StrNew*
Next i
Hi,
It is working fine. In Cell A3 data is 958321.1 which is reversed
as 1.123859.
Pl check confirm.
Thanks!!
On Mon, Jul 22, 2013 at 10:55 AM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear VbA,
thanks for your help. but this formula is not working properly.
Dear VBA,
Thanks for your help and valuable support. this is woking fine.
Thanks,
Ashish
On 22 July 2013 11:44, vba v...@vabs.in wrote:
Hi,
It is working fine. In Cell A3 data is 958321.1 which is reversed
as 1.123859.
Pl check confirm.
Thanks!!
On Mon, Jul 22,
Dear Seniors,
Thank to all of you. Your help means a lot for me. thanks.
thanks,
Ashish
On Monday, July 22, 2013 11:44:56 AM UTC+5:30, Vabz wrote:
Hi,
It is working fine. In Cell A3 data is 958321.1 which is reversed
as 1.123859.
Pl check confirm.
Thanks!!
Respected Ashish,
Simply use the attached add-in.
On Mon, Jul 22, 2013 at 12:00 PM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear Seniors,
Thank to all of you. Your help means a lot for me. thanks.
thanks,
Ashish
On Monday, July 22, 2013 11:44:56 AM UTC+5:30, Vabz wrote:
Sent: Monday, July 22, 2013 11:21 AM
Subject: Re: $$Excel-Macros$$ Query - How to make reversal string.
Dear Expert ,
Can you expline the bold line as i want to know deeply.
Function Reverse(Text As String) As String
Dim i As Integer
Dim StrNew As String
Dim strOld As String
Dear Ashish sir,
thanks for your quick response, but this is not working i want solve this
query only from excel formula not VbA. coz, i want to reverse string in
some columns not whole excel sheet. please suggest me how to resolve this
query from excel formula.
Thanks,
Ashish
On Sunday,
Hi Ashish,
Try this
Function Reverse(Text As String) As String
Dim i As Integer
Dim StrNew As String
Dim strOld As String
strOld = Trim(Text)
For i = 1 To Len(strOld)
StrNew = Mid(strOld, i, 1) StrNew
Next i
Reverse = StrNew
End Function
Dear Vabs,
Thanks for you reply, the formula is working but when I change this formula
accordingly this is not working properly. please find attached excel sheet
for query data.
On 21 July 2013 21:20, vba v...@vabs.in wrote:
Hey,
Try this, this works up to 12 character.
PFA
Thanks
On Sun, Jul 21, 2013 at 11:10 PM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear Vabs,
Thanks for you reply, the formula is working but when I change this
formula accordingly this is not working properly. please find attached
excel sheet for query data.
On 21 July 2013
Dear VbA,
thanks for your help. but this formula is not working properly.
Thanks,
Ashish
On 22 July 2013 10:27, vba v...@vabs.in wrote:
PFA
Thanks
On Sun, Jul 21, 2013 at 11:10 PM, Ashish Kumar
kumar.ashish...@gmail.comwrote:
Dear Vabs,
Thanks for you reply, the formula is
hi priti,
very nice formula.. very useful. thank you.
Thanks Regards,
Prabhu R
On 16 July 2013 14:57, priti verma pritiverma1...@gmail.com wrote:
PFA
On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E emuralidha...@gmail.comwrote:
Dear Friends good afternoon,
I need help reg. lookup
PFA
On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E emuralidha...@gmail.comwrote:
Dear Friends good afternoon,
I need help reg. lookup values
1.It is possible to vlookup the values for the left side
2.Vlookup for the second value(occurence), third value
Is their any other ways or
Dear Murlidhar,
Please visit here..
http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html
On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E emuralidha...@gmail.comwrote:
Dear Friends good afternoon,
I need help reg. lookup values
1.It is possible to vlookup the values for the
Respected Muralidhar,
You can use Index,Match,Indirect functions for accomplishing some look up
tasks which are not possible by VLookup.
Regards,
VijayKumar
On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Murlidhar,
Please visit here..
Hi,
ThanksVijay. can u present me with an example,it is better to understand me.
Thanks in advance.
On 16 July 2013 15:07, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Muralidhar,
You can use Index,Match,Indirect functions for accomplishing some look up
tasks which are not possible
Thanks mr, Ansari,
I cant understand the 9E+307 in the below formula
=LOOKUP(9E+307,1/(C3:C9=E9),B3:B9)
plz, help me on this with an example,it is help me more.
Thanks in advance
Warm Regards,
Muralidhar
On 16 July 2013 15:37, Muralidhar E emuralidha...@gmail.com wrote:
Hi,
Dear Muralidhar.
it's the largest number that Excel can store. This Big number is used to
look up the last number in a range.
On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E emuralidha...@gmail.comwrote:
Thanks mr, Ansari,
I cant understand the 9E+307 in the below formula
Respected Muralidhar,
You can see the following links for Examples
http://exceluser.com/blog/465/excels-best-lookup-method-index-match.html
http://www.youtube.com/watch?v=IX2TZ3OlOlA
http://www.randomwok.com/excel/how-to-use-index-match/
Regards,
Vijaykumar
On Tue, Jul 16, 2013 at 3:37 PM,
Thank u
On 16 July 2013 16:34, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Muralidhar.
it's the largest number that Excel can store. This Big number is used to
look up the last number in a range.
On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E emuralidha...@gmail.comwrote:
Dear Vijay Kumar.
Thank u
On 16 July 2013 16:40, Muralidhar E emuralidha...@gmail.com wrote:
Thank u
On 16 July 2013 16:34, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Muralidhar.
it's the largest number that Excel can store. This Big number is used
to look up the last
Repected Vijay Kumar and Noorain Ansari.
Both of u and the team Thank u very much.
On 16 July 2013 16:46, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Muralidhar,
See the following link and attached File.
http://chandoo.org/wp/2010/11/02/multi-condition-lookup/
Regards,
Vijaykumar
Dear Rakesh,
please see attachment.
in case of place months in ascending order. you have to do it manually.
right click on any month and move it to left, right, to beginning or to end.
Regards,
Waseem Saifi
On 7/11/13, Rakesh Kumar Sharma rakeshks@gmail.com wrote:
Dear Experts,
I have a
use this formula in c2 =DATE(YEAR(B2),MONTH(B2),1)
and fill it down then try to sort the columns of pivot table
On Thu, Jul 11, 2013 at 6:36 PM, Waseem Saifi waseemsa...@gmail.com wrote:
Dear Rakesh,
please see attachment.
in case of place months in ascending order. you have to do it
Thanks Sir.
On Wed, Jul 3, 2013 at 10:52 AM, Vabs VBA v...@vabs.in wrote:
Hi
X refer to each cell in range A1 to D5.
Thanks
On 3 Jul 2013 10:41, Prafull Jadhav prafulltjad...@gmail.com wrote:
Dear All,
Good Morning..
I got below macro from net ..Can you explain me what x stand
Hi
X refer to each cell in range A1 to D5.
Thanks
On 3 Jul 2013 10:41, Prafull Jadhav prafulltjad...@gmail.com wrote:
Dear All,
Good Morning..
I got below macro from net ..Can you explain me what x stand here...
*Sub Upper_()*
*For Each x In Range(A1:D5)*
*'For Each x In
Shortest is this
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: 15 February 2013 4:34
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query
Hi Chauan
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
-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query collation of data ignoring #n/a
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
--
*From: * vijayajith VA vijayajith...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date: *Fri, 15 Feb 2013 15:08:39 +0530
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ Query collation of data ignoring #n
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,
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
1 - 100 of 218 matches
Mail list logo