Re: $$Excel-Macros$$ need formula

In A2 cell *=INDIRECT("'"&$D$1&"'!"&ADDRESS(ROW(),COLUMN()+1))* Drag it down and right... On 10-01-2013 1:14 PM, Rajesh Agarwal wrote: Dear Sir If I change the sheet name in column D1 all the rows of column A & B change accordingly need formula not macro -- *Rajesh Kumar Agarwal* *981106300

Re: $$Excel-Macros$$ Need Help to seperate Date & time

Dear Ashish, You can try,, For date =date(year(a1),month(a1),day(a1) and press ctrl+shift+# For time =date(Hour(a1),minute(a1),second(a1) and press ctrl+shift+@ On Thu, Jan 10, 2013 at 1:01 PM, kumar.ashish861 wrote: > Dear Seniors, > > Pls help to seperate date & time, if both are in 1 cell.

Re: $$Excel-Macros$$ Need Help to seperate Date & time

Please make it in an excel workbook and send it to us for our better understanding of your data structure. On 10-01-2013 1:01 PM, kumar.ashish861 wrote: Dear Seniors, Pls help to seperate date & time, if both are in 1 cell. 7/11/2012 13:51 Formula req..! Thanks in advance Ashish k

$$Excel-Macros$$ Need Help to seperate Date & time

Dear Seniors, Pls help to seperate date & time, if both are in 1 cell. 7/11/2012 13:51 Formula req..! Thanks in advance Ashish kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread t

Re: $$Excel-Macros$$ Index of sheets

Yes Correct MS Exl Learner, We need to press F2 in case of increase/decrease sheet. Aside to Lalit : We have create a name range as SheetsName and using it in formula. On Thu, Jan 10, 2013 at 12:41 PM, Ms-Exl-Learner wrote: > @ Noorain, > > But Change in Worksheet Name or addition of sheets

$$Excel-Macros$$ Re: Select Unique values

@Prince Instead of using dictionary or array a single line can do it If No Header ActiveSheet.Range("$A$1:$A$23").RemoveDuplicates Columns:=1, Header:=xlNo If Header ActiveSheet.Range("$A$1:$A$23").RemoveDuplicates Columns:=1, Header:=xlYes Regards, Lalit Mohan On Thursday, 10 January 2013 12:

$$Excel-Macros$$ Re: Select Unique values

If yes then please check this one I have programmed below code just cut and paste this and run Public Sub removeDuplicateId() Dim vardata As Variant Dim varRes As Variant Dim lngRow As Long Dim objDic As Object Set objDic = CreateObject("Scri

$$Excel-Macros$$ Re: Select Unique values

so do u need any macro ? regards Prince On Thursday, January 10, 2013 12:30:42 PM UTC+5:30, kasper wrote: > > Hi > > Thanks for reply,I know about duplicate removeal but I am serching for a > permanent formula . > > Regards > Rajesh > > On Tuesday, January 1, 2013 9:23:20 PM UTC+5:30, Prince w

Re: $$Excel-Macros$$ Index of sheets

@ Noorain, But Change in Worksheet Name or addition of sheets are not automatically getting added in your solution, for which the user needs to press F2 in the formula cell or close the workbook and re-open it for getting it reflected. Slight enhancement has been done Your A2 cell formula *

$$Excel-Macros$$ Re: Select Unique values

Hi Thanks for reply,I know about duplicate removeal but I am serching for a permanent formula . Regards Rajesh On Tuesday, January 1, 2013 9:23:20 PM UTC+5:30, Prince wrote: > > Hi Kasper, > > Dear instead of giving solution i just want to give the idea required to > accomplish your task.just

Re: $$Excel-Macros$$ Re: Extracting Zip Code from Address

Enjoy buddy. ;) On Thursday, 10 January 2013 12:18:12 UTC+5:30, Jai wrote: > > Thank you all Prince, Lalit, Noorain, The Viper and all if I missed > anyone... > > > > It worked!! > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Prince

Re: $$Excel-Macros$$ Index of sheets

Hi Noorain, Could you please explain the function u used *Get.workbook* * * and i think it is a UDF isn't it. Regards, Lalit Mohan On Thursday, 10 January 2013 12:12:14 UTC+5:30, NOORAIN ANSARI wrote: > > Dear Hari, > > See attached file by using only Excel Formula. > > =REPLACE(Get.workboo

RE: $$Excel-Macros$$ Re: Extracting Zip Code from Address

Thank you all Prince, Lalit, Noorain, The Viper and all if I missed anyone... It worked!! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prince Sent: Thursday, January 10, 2013 9:44 AM To: excel-macros@googlegroups.com Cc: jai_d...@msn.com Subjec

Re: $$Excel-Macros$$ How to get max number from a database ?

you can use =DMAX(database,field,criteria) --- On Thu, 1/10/13, Ms-Exl-Learner wrote: From: Ms-Exl-Learner Subject: Re: $$Excel-Macros$$ How to get max number from a database ? To: excel-macros@googlegroups.com Date: Thursday, January 10, 2013, 11:49 AM In C4 cell - N

$$Excel-Macros$$ Re: Index of sheets

i dont feel it is possible without macro. regards Prince On Wednesday, January 9, 2013 5:27:36 PM UTC+5:30, Harisha P wrote: > > > Dear excel gurus, > > Please let me know how to get the index of sheets in a given excel > workbook. > > Thanks, > Harish > > -- > Yours, > > Hari. -- Join of

Re: $$Excel-Macros$$ How to get max number from a database ?

*In C4 cell* - *Non Array Formula* =SUMPRODUCT(MAX(($A$4:$A$9567=A4)*$B$4:$B$9567)) Drag it down. On 09-01-2013 3:35 PM, karan kanuga wrote: Hi Can anyone pls let me know how do i get the max value or date (using a formula and not pivot) from the database that i have. Attached is the databas

Re: $$Excel-Macros$$ Index of sheets

Not possible without the help of Excel VBA or Third Party Addins. On 10-01-2013 10:57 AM, Hari wrote: Thanks for your help. but is there any formulae to get the same answers. Thanks, Harish On 10 January 2013 10:11, The Viper > wrote: Perhaps! He requires the

Re: $$Excel-Macros$$ Index of sheets

Thanks for your help. I got the answer for the same through below mail which i was looking for. Thanks, Harish On 9 January 2013 17:59, Paul Schreiner wrote: > What is it that you're looking for? > Are you writing VBA code and want to find out how many sheets are in a > workbook? > Are you tryi

Re: $$Excel-Macros$$ Index of sheets

Thanks for your help. but is there any formulae to get the same answers. Thanks, Harish On 10 January 2013 10:11, The Viper wrote: > Perhaps! He requires the list of available worksheet names from active > workbook > > Sub SheetIndex() > Dim i As Integer > For i = 1 To ActiveWorkbook.Sheets.Cou

Re: $$Excel-Macros$$ Passing array of shapes to udf using vba

Thanks On Wed, Jan 9, 2013 at 2:41 PM, Rajan_Verma wrote: > > Dim Shp As Shapes > Set Shp = Sheet1.Shapes > > shp object will have all shapes reference with in sheet1, you can use > shp(1) to color the first shape > > Rajan > > > On Tuesday, 8 January 2013 21:38:13 UTC-7, Amol J wrote: >> >> Tha

Re: $$Excel-Macros$$ Extracting Zip Code from Address

use =REPLACE(A1,1,FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))-1)),"") or =MID(A1,FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))-1))+1,255) On Thu, Jan 10, 2013 at 9:28 AM, Jaideep Panchal wrote: > Hi Noorain, > > ** ** > > Thanks for a quick response

$$Excel-Macros$$ Re: Extracting Zip Code from Address

Hi Jai, you can also try this =MID(SUBSTITUTE(A2," ","$",(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))+1)-2), FIND("$",SUBSTITUTE(A2," ","$",(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))+1)-2))+1, LEN(A2)) Regards, Lalit Mohan On Thursday, 10 January 2013 09:43:43 UTC+5:30, Prince wrote: > > Hi Jai, > > here is

$$Excel-Macros$$ Re: Extracting Zip Code from Address

Hi Jai, here is your solutoon =TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),510)) Regards Prince On Thursday, January 10, 2013 12:58:58 AM UTC+5:30, Jai wrote: > > Hi group, > > > > > > I need some help in extracting zip code from address and hope u all will > provide a good help as always

RE: $$Excel-Macros$$ Extracting Zip Code from Address

Hi Noorain, Thanks for a quick response but it does not work if town name have 2-3 spaces I need formula which can give text from second space of right side.. it will always work Thanks, Jaideep From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of

Re: $$Excel-Macros$$ Extracting Zip Code from Address

Hi Noorain In case of *MAIDSTONE Wells ME14 4EA* formula is not working regards prince On Thursday, January 10, 2013 8:47:59 AM UTC+5:30, NOORAIN ANSARI wrote: > > > Dear jaideep, > > Pls use > =right(A1,len(A1)-find(" ",A1)) > > > Sent from BlackBerry® on Airtel > --

Re: $$Excel-Macros$$ Extracting Zip Code from Address

Dear jaideep, Pls use =right(A1,len(A1)-find(" ",A1)) Sent from BlackBerry® on Airtel -Original Message- From: "Jaideep Panchal" Sender: excel-macros@googlegroups.com Date: Thu, 10 Jan 2013 00:58:58 To: Reply-To: excel-macros@googlegroups.com Cc: Subject: $$Excel-Macros$$ Extrac

$$Excel-Macros$$ Extracting Zip Code from Address

Hi group, I need some help in extracting zip code from address and hope u all will provide a good help as always... I need some formula to extract text after second last space because town name might have 2-3 words.. Town & Zip Code Result Required LINCOLN LN4 4SY LN4 4SY LINC

Re: $$Excel-Macros$$ Passing array of shapes to udf using vba

I like your answer Rajan. :) regards prince On Wednesday, January 9, 2013 2:41:18 PM UTC+5:30, Rajan_Verma wrote: > > > Dim Shp As Shapes > Set Shp = Sheet1.Shapes > > shp object will have all shapes reference with in sheet1, you can use > shp(1) to color the first shape > > Rajan > > > On T

$$Excel-Macros$$ Re: Fw: significance of using classes in VBA

HI Prashant, i think google will be the best place for your question.there you may get lots of description regarding your question. regards prince On Tuesday, January 8, 2013 10:18:41 PM UTC+5:30, prashant shinde wrote: > > > > > Sent from Samsung Mobile > > > Original message ---

$$Excel-Macros$$ Re: [partially OT] Struggling with a Laptop buy decision; could some1 pls suggest good windows user grp?

Hi Dear, What i believe is before purchasing any of the laptop please be sure about everything you need in it. so i would suggest you please go through below mentioned links and then decide which one suits your requirements best. http://laptops.techcrunch.com/ http://compareindia.in.com/product

Re: $$Excel-Macros$$ How to get max number from a database ?

Try max formula On Jan 9, 2013 3:35 PM, "karan kanuga" wrote: > Hi > Can anyone pls let me know how do i get the max value or date (using a > formula and not pivot) from the database that i have. > > Attached is the database. > > Thanks. > > > > -- > Join official Facebook page of this forum @ >

Re: $$Excel-Macros$$ Please Help

Your question is not that clear can you show an example about your requirement. if your looking for the difference then why don't you use Next activity - Last activity On Wed, Jan 9, 2013 at 8:23 PM, karthik N wrote: > Hi Jayseel, > > Thank you for your replay, > > But i needed the In between

Re: $$Excel-Macros$$ Please Help

Hi Jayseel, Thank you for your replay, But i needed the In between Two difference date Hour & min Thanks Karthik.N On Wed, Jan 9, 2013 at 8:17 PM, Jaysheel Bhasme wrote: > Hi Karthik, > > Please check if this your requirement, > > Regards, > Jaysheel > > > On Wed, Jan 9, 2013 at 8:07 PM, kart

Re: $$Excel-Macros$$ Please Help

Hi Karthik, Please check if this your requirement, Regards, Jaysheel On Wed, Jan 9, 2013 at 8:07 PM, karthik N wrote: > Dear Help > > Please help for below attached file. > > > -- > > *Regards* > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FOR

$$Excel-Macros$$ Please Help

Dear Help Please help for below attached file. -- *Regards* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and

Re: $$Excel-Macros$$ Index of sheets

What is it that you're looking for? Are you writing VBA code and want to find out how many sheets are in a workbook? Are you trying to use the Sheets() collection to get something to do with the sheets? The Sheets() collection is an array of sheets. The "index" of the Sheets() collection is the s

Re: $$Excel-Macros$$ Index of sheets

Dear Hari, Can you share your workbook? On Wed, Jan 9, 2013 at 5:27 PM, Hari wrote: > > Dear excel gurus, > > Please let me know how to get the index of sheets in a given excel > workbook. > > Thanks, > Harish > > -- > Yours, > > Hari. > > -- > Join official Facebook page of this forum @ >

$$Excel-Macros$$ Index of sheets

Dear excel gurus, Please let me know how to get the index of sheets in a given excel workbook. Thanks, Harish -- Yours, Hari. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, li

Re: $$Excel-Macros$$ Re: Excel file corrupt in Outlook

Hi Ashish, Find below link may be it help you http://lds.netdimensions.com/ldslive/nd/fresco/repository/html/kit/Self%20Support%20Articles/Mail/AttachmentPreviewers.pdf Regards, Lalit Mohan On Wednesday, 9 January 2013 16:17:06 UTC+5:30, Ashish_Bhalara wrote: > > Thanks for reply sir, but my p

Re: $$Excel-Macros$$ Re: Excel file corrupt in Outlook

Thanks for reply sir, but my problem is still there, i did setting as you say but there are not solve my problem, kindly suggest another solution, Regards Ashish Bhalara On Wed, Jan 9, 2013 at 3:58 PM, Lalit Mohan Pandey wrote: > Hi Ashish, > > Here is the fix > It actually isn't a "Protected v

$$Excel-Macros$$ Re: Excel file corrupt in Outlook

Hi Ashish, Here is the fix It actually isn't a "Protected view" issue, but a DCOM issue. Somehow the DCOM permission got changed, so it wouldn't allow certain applications access to simple things like Preview mode on Outlook 2010 / 2007, or opening up attachments without it saying file corrupt.

$$Excel-Macros$$ Re: How to get max number from a database ?

Hi Karan, Apply this formula with CSE in cell C4 =MAX(IF((($A$4:$A$9567)=$A4),$B$4:$B$9567,0)) and copied down Regards, Lalit Mohan On Wednesday, 9 January 2013 15:35:50 UTC+5:30, karan wrote: > > Hi > Can anyone pls let me know how do i get the max value or date (using a > formula and not pi

Re: $$Excel-Macros$$ Passing array of shapes to udf using vba

Dim Shp As Shapes Set Shp = Sheet1.Shapes shp object will have all shapes reference with in sheet1, you can use shp(1) to color the first shape Rajan On Tuesday, 8 January 2013 21:38:13 UTC-7, Amol J wrote: > > Thanks Divaker > > Regards > Amol > > On Tue, Jan 8, 2013 at 6:46 PM, Divake

$$Excel-Macros$$ Re: Question on SumProduct Formula

Sumproduct is not written in this way to use the operator as string, i did'nt saw any example like this in last 4-5 years Rajan On Wednesday, 9 January 2013 01:06:35 UTC-7, Aashish Watve wrote: > > Hi All, > > I am seeing many examples of SUMPRODUCT formula on this forum and very > interested i

Re: $$Excel-Macros$$ Pivot table

PFA.. On Wed, Jan 9, 2013 at 1:27 PM, Anoop K Sharma wrote: > > Hope the attached file can help you better. > > Regards, > Anoop > Sr. Developer > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ Fw: significance of using classes in VBA

Hi, you can find a good example of Using class module in Excel VBA here http://excelpoweruser.wordpress.com/2012/08/28/assign-event-to-a-bunch-of-controls/ Regards Rajan verma On Tuesday, 8 January 2013 20:50:16 UTC-7, Enrique Martin wrote: > > Paul described wonderfully. Class Module are ver

$$Excel-Macros$$ Question on SumProduct Formula

Hi All, I am seeing many examples of SUMPRODUCT formula on this forum and very interested in using this in my assignment. I see that this formula is very short and fast. I am presently using SUMIFS for most of my calculations, where I am creating the SUMIF formula in a cell by concatenating entri