Re: $$Excel-Macros$$ Query 3

2016-11-15 Thread saravanan R
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

Re: $$Excel-Macros$$ Query

2016-10-27 Thread sourav devrani
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

Re: $$Excel-Macros$$ Query

2016-09-21 Thread Kal xcel
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

Re: $$Excel-Macros$$ Query

2016-09-19 Thread Sanjeev Tyagi
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

Re: $$Excel-Macros$$ Query on formula

2016-09-16 Thread Kal xcel
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: >

Re: $$Excel-Macros$$ Query on formula

2016-09-16 Thread Learner Excel
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

Re: $$Excel-Macros$$ Query on formula

2016-09-16 Thread Ashish Koul
=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

Re: $$Excel-Macros$$ Query !!!

2016-08-16 Thread Satendra kumar
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 > > **

Re: $$Excel-Macros$$ Query

2016-05-05 Thread Saleem Ansari
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

Re: $$Excel-Macros$$ Query regarding auto hide rows in excell

2016-03-29 Thread GENIUS
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?

Re: $$Excel-Macros$$ Query regarding auto hide rows in excell

2016-03-28 Thread Muhammad Arslan
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

Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together

2016-03-21 Thread Pooja Sharma
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, >> >>

Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together

2016-03-21 Thread Ashish Koul
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: > >>

Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together

2016-03-21 Thread Pooja Sharma
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,

Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together

2016-03-21 Thread Ashish Koul
=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. >

Re: $$Excel-Macros$$ Query for Excel

2015-11-09 Thread Paul Schreiner
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

Re: $$Excel-Macros$$ Query for Paul

2015-11-09 Thread Paul Schreiner
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

Re: $$Excel-Macros$$ Query for Excel

2015-11-09 Thread Paul Schreiner
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

RE: $$Excel-Macros$$ Query for Code

2015-08-12 Thread gargee singh
-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

Re: $$Excel-Macros$$ Query for Code

2015-07-28 Thread Paul Schreiner
- 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

Re: $$Excel-Macros$$ Query for Code

2015-07-28 Thread Paul Schreiner
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

Re: $$Excel-Macros$$ Query for Code

2015-07-27 Thread Paul Schreiner
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

RE: $$Excel-Macros$$ Query for Code

2015-07-27 Thread gargee singh
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

Re: $$Excel-Macros$$ Query in VBA

2015-07-11 Thread Sunil Kumar Yadav
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

Re: $$Excel-Macros$$ Query (Outlook VBA)

2015-06-03 Thread ashish koul
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!!

Re: $$Excel-Macros$$ Query on Extract word

2015-05-21 Thread Pankaj Sharma
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,.,),-,),

Re: $$Excel-Macros$$ Query on Extract word

2015-05-20 Thread Prashant Pednekar
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

RE: $$Excel-Macros$$ Query on Extract word

2015-05-20 Thread Pankaj Sharma
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,-,),

Re: $$Excel-Macros$$ Query to retreive data

2015-04-28 Thread Mandeep Baluja
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

Re: $$Excel-Macros$$ Query to retreive data

2015-04-28 Thread Vaibhav Joshi
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

Re: $$Excel-Macros$$ Query for If condition or VBA

2015-03-25 Thread Sunil Kumar Yadav
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

Re: $$Excel-Macros$$ Query for If condition or VBA

2015-03-25 Thread Vaibhav Joshi
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,

Re: $$Excel-Macros$$ Query for If condition or VBA

2015-03-25 Thread Vaibhav Joshi
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

Re: $$Excel-Macros$$ Query for If condition or VBA

2015-03-25 Thread Sunil Kumar Yadav
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

Re: $$Excel-Macros$$ Query in code of email send with attachment from excel

2015-03-25 Thread Vaibhav Joshi
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

Re: $$Excel-Macros$$ Query in code of email send with attachment from excel

2015-03-23 Thread Vaibhav Joshi
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

Re: $$Excel-Macros$$ Query in code of email send with attachment from excel

2015-03-23 Thread Ashish Bhalara
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,

Re: $$Excel-Macros$$ Query for autofit columns.

2015-03-17 Thread Vaibhav Joshi
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 @

Re: $$Excel-Macros$$ Query for autofit columns.

2015-03-12 Thread Gaurav Devrani
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

Re: $$Excel-Macros$$ Query for autofit columns.

2015-03-12 Thread Mandeep baluja
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

Re: $$Excel-Macros$$ Query for autofit columns.

2015-03-12 Thread Gaurav Devrani
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

Re: $$Excel-Macros$$ Query on count

2014-11-14 Thread Waseem Saifi
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

Re: $$Excel-Macros$$ query need help

2014-03-18 Thread Prabhu Pinky
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:*

RE: $$Excel-Macros$$ query need help

2014-03-17 Thread Ravinder
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

Re: $$Excel-Macros$$ query need help

2014-03-16 Thread ashish koul
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,

Re: $$Excel-Macros$$ query need help

2014-03-15 Thread Prabhu Pinky
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.

Re: $$Excel-Macros$$- Query

2014-03-10 Thread Atul Kesaria
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

Re: $$Excel-Macros$$- Query

2014-03-09 Thread Atul Kesaria
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

Re: $$Excel-Macros$$ Query for Macro

2014-02-20 Thread De Premor
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

Re: $$Excel-Macros$$ Query for Macro

2014-02-19 Thread mrExcel4u
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

Re: $$Excel-Macros$$- Query

2014-02-17 Thread mrExcel4u
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

Re: $$Excel-Macros$$- Query

2014-02-16 Thread Atul Kesaria
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

Re: $$Excel-Macros$$ Query on Dashboard(urgent)

2013-10-03 Thread ashwani agnihotri
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. ** **

Re: $$Excel-Macros$$ Query on Dashboard(urgent)

2013-10-02 Thread ashwani agnihotri
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

Re: $$Excel-Macros$$ Query on vlookup

2013-09-16 Thread johnson john
@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

Re: $$Excel-Macros$$ Query on vlookup

2013-09-15 Thread अनिल नारायण गवली
, 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

Re: $$Excel-Macros$$ Query on vlookup

2013-09-13 Thread ashish koul
=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?

Re: $$Excel-Macros$$ Query on vlookup

2013-09-13 Thread De Premor
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

RE: $$Excel-Macros$$ Query on vlookup

2013-09-13 Thread Ravi Kumar
@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

Re: $$Excel-Macros$$ Query on vlookup

2013-09-13 Thread Shrinivas Shevde
: $$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

Re: $$Excel-Macros$$ Query Regarding Pivot Table

2013-08-24 Thread xlstime
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

Re: $$Excel-Macros$$ Query Regarding Pivot Table

2013-08-24 Thread Waseem Saifi
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

Re: $$Excel-Macros$$ Query Regarding Sum

2013-08-01 Thread 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

Re: $$Excel-Macros$$ Query Regarding Sum

2013-08-01 Thread De Premor
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:

Re: $$Excel-Macros$$ Query Regarding Sum

2013-08-01 Thread Waseem Saifi
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

Re: $$Excel-Macros$$ Query Regarding Sum

2013-07-31 Thread ravinder negi
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,

Re: $$Excel-Macros$$ Query - How to make reversal string.

2013-07-22 Thread Prafull Jadhav
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

Re: $$Excel-Macros$$ Query - How to make reversal string.

2013-07-22 Thread vba
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.

Re: $$Excel-Macros$$ Query - How to make reversal string.

2013-07-22 Thread Ashish Kumar
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,

Re: $$Excel-Macros$$ Query - How to make reversal string.

2013-07-22 Thread Ashish Kumar
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!!

Re: $$Excel-Macros$$ Query - How to make reversal string.

2013-07-22 Thread P.VIJAYKUMAR
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:

Re: $$Excel-Macros$$ Query - How to make reversal string.

2013-07-22 Thread ravinder negi
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

Re: $$Excel-Macros$$ Query - How to make reversal string.

2013-07-21 Thread Ashish Kumar
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,

Re: $$Excel-Macros$$ Query - How to make reversal string.

2013-07-21 Thread xlstime
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

Re: $$Excel-Macros$$ Query - How to make reversal string.

2013-07-21 Thread Ashish Kumar
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.

Re: $$Excel-Macros$$ Query - How to make reversal string.

2013-07-21 Thread vba
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

Re: $$Excel-Macros$$ Query - How to make reversal string.

2013-07-21 Thread Ashish Kumar
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

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-20 Thread Prabhu Pinky
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

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread priti verma
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

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread NOORAIN ANSARI
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

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread P.VIJAYKUMAR
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..

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
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

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
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,

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread NOORAIN ANSARI
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

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread P.VIJAYKUMAR
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,

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
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:

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
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

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
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

Re: $$Excel-Macros$$ Query in Pivot Table

2013-07-11 Thread Waseem Saifi
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

Re: $$Excel-Macros$$ Query in Pivot Table

2013-07-11 Thread ashish koul
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

Re: $$Excel-Macros$$ Query in For Each Next

2013-07-03 Thread Prafull Jadhav
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

Re: $$Excel-Macros$$ Query in For Each Next

2013-07-02 Thread Vabs VBA
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

RE: $$Excel-Macros$$ Query

2013-02-16 Thread Rajan_Verma
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

Re: $$Excel-Macros$$ Query collation of data ignoring #n/a

2013-02-15 Thread Dhaval Shah
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.

Re: $$Excel-Macros$$ Query collation of data ignoring #n/a

2013-02-15 Thread vijayajith VA
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

Re: $$Excel-Macros$$ Query collation of data ignoring #n/a

2013-02-15 Thread vatspoojavats
-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

Re: $$Excel-Macros$$ Query collation of data ignoring #n/a

2013-02-15 Thread vijayajith VA
-- *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

Re: $$Excel-Macros$$ Query

2013-02-15 Thread vijayajith VA
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

Re: $$Excel-Macros$$ Query

2013-02-15 Thread NOORAIN ANSARI
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

Re: $$Excel-Macros$$ Query collation of data ignoring #n/a

2013-02-15 Thread Ms Excel user
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   2   3   >