Re: $$Excel-Macros$$ Using Small Formula

2016-08-09 Thread NOORAIN ANSARI
t post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a

Re: $$Excel-Macros$$ Vlookup Sensitive Case

2016-08-08 Thread NOORAIN ANSARI
om. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorai

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

2015-10-06 Thread NOORAIN ANSARI
o excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com <http://www.noorainansari.com> http

Re: $$Excel-Macros$$ VBA Code For Data Compiler

2014-09-09 Thread NOORAIN ANSARI
Dear Satendra, Please try it...hope it will help to you... http://www.excelvbaclinic.com/2013/12/combine-all-workbook-of-folder.html Thanks, Noorain Ansari On Tue, Sep 9, 2014 at 5:07 PM, Satendra kumar wrote: > Hi All Expert, > > please solve my query, i want Data Compiler

$$Excel-Macros$$ Re: Invitation to the Excel Modeling World Championships 2014

2014-09-06 Thread NOORAIN ANSARI
). We're also hosting free >> networking events in major Financial Centres including Hong Kong, London, >> Sydney, New York and Regional Meetups in the coming months for anyone >> interested in networking and mentoring with Excel-users in their local >> cities. Entry

Re: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread NOORAIN ANSARI
=IF(A2=9,N(1),IF(A2=10,N(1),IF(A2<=6,N(-1),IF(A2=N(7),"",IF(A2=N(8),"") On Wed, Sep 4, 2013 at 2:37 PM, NOORAIN ANSARI wrote: > Dear Savla, > > Please try it > > ** > > > On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote: > >> Hi

Re: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread NOORAIN ANSARI
group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.googl

Re: $$Excel-Macros$$ Fiscal Period calculation

2013-07-31 Thread NOORAIN ANSARI
ed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

2013-07-16 Thread NOORAIN ANSARI
shish, >>>>> >>>>> Formula is working fine. Please find the attachment. >>>>> >>>>> *Use formula with Ctrl + Shift + Enter (Select All Rows & Press Ctrl >>>>> + Shift + Enter).* >>>>> >>>>> R

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

2013-07-16 Thread NOORAIN ANSARI
end email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com&

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

2013-07-16 Thread NOORAIN ANSARI
with an example,it is better to understand >> me. >> >> Thanks in advance. >> >> On 16 July 2013 15:07, P.VIJAYKUMAR wrote: >> >>> Respected Muralidhar, >>> >>> You can use Index,Match,Indirect functions for accomplishing so

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

2013-07-16 Thread NOORAIN ANSARI
st to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorain

Re: $$Excel-Macros$$ Date conversion to other format

2013-06-13 Thread NOORAIN ANSARI
unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, vi

Re: $$Excel-Macros$$ Want to add every third row or coloumn!

2013-06-03 Thread NOORAIN ANSARI
os+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- With Regards, No

Re: $$Excel-Macros$$ Need help to fill the range between two date.(column wise)

2013-05-07 Thread NOORAIN ANSARI
e from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https:/

Re: $$Excel-Macros$$ Sum on the basis of colour formula

2013-04-11 Thread NOORAIN ANSARI
owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros

$$Excel-Macros$$ Excel-VBA QUIZ

2013-03-22 Thread NOORAIN ANSARI
orm?sid=486e6fe215af0fce&token=SFi6iD0BAAA.iWP8aZGEU1t-n4xPeRLvVA._6DD8roOh3wEObFQDYTE9w> -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelvbaclinic.blogspot.co

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] PDF to Excel

2013-03-08 Thread NOORAIN ANSARI
/ http://www.simpleocr.com/OCR_Software/Convert_Image/convert_image_to_Excel.asp On Fri, Mar 8, 2013 at 5:14 PM, Aamir Shahzad wrote: > Object Library is not reflecting as I have installed Adobe Acrobat 7.0 > > On Fri, Mar 8, 2013 at 4:27 PM, NOORAIN ANSARI > wrote: > >> Dea

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] PDF to Excel

2013-03-08 Thread NOORAIN ANSARI
Dear Aamir, Please follow below steps before run the macro Goto Tools-Reference and check *Adobe Acrobat 9.0 Object Library* On Fri, Mar 8, 2013 at 4:47 PM, Aamir Shahzad wrote: > Dear Sir, error is reflecting. Please see > > On Fri, Mar 8, 2013 at 3:34 PM, NOORAIN ANSARI

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] PDF to Excel

2013-03-08 Thread NOORAIN ANSARI
Dear Aamir, Please Press Atl+F11, goto Module and paste it then press F5 to run macro. On Fri, Mar 8, 2013 at 2:37 PM, Aamir Shahzad wrote: > Thank you Sir, but kindly also tell me the steps how I use > > On Fri, Mar 8, 2013 at 12:50 PM, NOORAIN ANSARI > wrote: > &

$$Excel-Macros$$ Re: [XL-VBA Clinic] PDF to Excel

2013-03-07 Thread NOORAIN ANSARI
unsubscr...@googlegroups.com > > For more options, visit this group at > http://groups.google.com/group/excelvbaclinic?hl=en?hl=en > --- > You received this message because you are subscribed to the Google Groups > "Excelvbaclinic" group. > To unsubscribe from

Re: $$Excel-Macros$$ max if and min if

2013-02-28 Thread NOORAIN ANSARI
up, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- With Regards, Noorain Ansari http:// <http://www.noorain

Re: $$Excel-Macros$$ Multiple Column& Rows conditions Sum

2013-02-28 Thread NOORAIN ANSARI
e from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups

Re: $$Excel-Macros$$ Is it possible to Create a macro that gives URL as output after giving the advertiser name as Input

2013-02-27 Thread NOORAIN ANSARI
Dear Abhishek, Please try through attached sheet, hope it will help to you. -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelvbaclinic.blogspot.com>excel

Re: $$Excel-Macros$$ Assignment

2013-02-25 Thread NOORAIN ANSARI
Numbers(rng As Excel.Range) Dim i As Integer For i = 1 To Len(rng) If Mid(rng, i, 1) Like "[0-9]" Then Only_Numbers = Only_Numbers & Mid(rng, i, 1) End If -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://

Re: $$Excel-Macros$$ Query

2013-02-15 Thread NOORAIN ANSARI
scr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- With Regards, Noorain Ansari h

Re: $$Excel-Macros$$ Requirement For an Android Developer in Huston, TX

2013-02-14 Thread NOORAIN ANSARI
you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com.

Re: $$Excel-Macros$$ Role for Business Analyst in San Ramon ,CA

2013-02-13 Thread NOORAIN ANSARI
, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > >

Re: $$Excel-Macros$$ formula required

2013-02-13 Thread NOORAIN ANSARI
Dear Ganesh, Pls try it.. *=SUMIF($B$6:$B$17,"*"&F8,$C$6:$C$17)* see attachment, Hope it will help to you. -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://ww

Re: $$Excel-Macros$$ Re: Count Names - Macro

2013-02-13 Thread NOORAIN ANSARI
Hi, Please explain your query, what is your exact requirement. -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclini

Re: $$Excel-Macros$$ Query: Charts

2013-02-13 Thread NOORAIN ANSARI
Dear Pankaj, Please try it.. *=OFFSET($B12,0,COUNTA($C$11:$P$11)-4,1,5)* see attached sheet for more clarity. -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelvbaclin

Re: $$Excel-Macros$$ Query

2013-02-08 Thread NOORAIN ANSARI
ooglegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<htt

Re: $$Excel-Macros$$ Sumif if criteria 2 match

2013-02-05 Thread NOORAIN ANSARI
p, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>nooraina

Re: $$Excel-Macros$$ Formula to find items between two dates

2013-02-05 Thread NOORAIN ANSARI
Hi Hilary, Please see the attachment, Hope it will meet your expectation. -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelvbaclinic.blogspot.com>excel

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13

2013-02-02 Thread NOORAIN ANSARI
p, Formula Problem, Code Problem, and Need Advice > >> will not get quick attention or may not be answered. > >> 2) Don't post a question in the thread of another member. > >> 3) Don't post questions regarding breaking or bypassing any sec

Re: $$Excel-Macros$$ Need formula

2013-02-01 Thread NOORAIN ANSARI
er post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from

Re: $$Excel-Macros$$ Macro require

2013-01-30 Thread NOORAIN ANSARI
st to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- With Regards, Noorain Ansari http:// <http://www

Re: $$Excel-Macros$$ Excel vba code to sort the userform combobox list ascending

2013-01-29 Thread NOORAIN ANSARI
>>> >>> > 3) Don't post questions regarding breaking or bypassing any >>> security >>> >>> > measure. >>> >>> > 4) Acknowledge the responses you receive, good or bad. >>> >>> > 5) Jobs posting is not allowed. >

Re: $$Excel-Macros$$ Extract information from excel

2013-01-29 Thread NOORAIN ANSARI
insurance mediation activities only. > >> > > >> > -- > >> > Join official Facebook page of this forum @ > >> > https://www.facebook.com/discussexcel > >> > > >> > FORUM RULES > >> > > >> > 1) Us

Re: $$Excel-Macros$$ Macro to delete a specific sheet by specifying

2013-01-29 Thread NOORAIN ANSARI
excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http:/

Re: $$Excel-Macros$$ Count in cell formula

2013-01-17 Thread NOORAIN ANSARI
Okay i gotbut i have not taken 30 minutes for this solution. -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclin

Re: $$Excel-Macros$$ Count in cell formula

2013-01-17 Thread NOORAIN ANSARI
If cell is non-blank you can use. it.. On Thu, Jan 17, 2013 at 4:19 PM, NOORAIN ANSARI wrote: > Dear Amar, > > You can also try... > > *=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1) > * > > -- > With Regards, > Noorain Ansari > http:// &

Re: $$Excel-Macros$$ Count in cell formula

2013-01-17 Thread NOORAIN ANSARI
Dear Amar, You can also try... *=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1) * -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelvbaclinic.b

Re: $$Excel-Macros$$ merge data

2013-01-10 Thread NOORAIN ANSARI
m. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http:/

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member December'12

2013-01-10 Thread NOORAIN ANSARI
Congrats Prince Babu... -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com> On Th

Re: $$Excel-Macros$$ Re: Vlookup for two same values

2013-01-10 Thread NOORAIN ANSARI
Dear Harshad, Please try.. -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com> On Fri, Jan 4,

Re: $$Excel-Macros$$ Conditional format & formula

2013-01-10 Thread NOORAIN ANSARI
sponses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- >

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

2013-01-10 Thread NOORAIN ANSARI
Hi Hilary, See attached sheet, Hope it will help to you.. -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.

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

2013-01-10 Thread NOORAIN ANSARI
Dear Kasper, You can also use below code for Ms. Excel All version (2003+) Sub Remove_Duplicates() With Sheet2 .Range("A1:A" & .Cells(Rows.Count, "A").End(xlUp).Row).AdvancedFilter Action:=xlFilterCopy, copytoRange:=.Range("C1"), unique:=True End With End Sub

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

2013-01-10 Thread NOORAIN ANSARI
responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macro

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

2013-01-09 Thread NOORAIN ANSARI
; excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www

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

2013-01-09 Thread NOORAIN ANSARI
ame,ROWS($A$1:A1)),"")* > > Is changed to > *=IFERROR(MID(TODAY()&INDEX(SheetsName,ROWS($A$1:A1)),6,255),"")* > > As usual needs to be dragged down > > > > On 10-01-2013 12:12 PM, NOORAIN ANSARI wrote: > > Dear Hari, > > See attache

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

2013-01-09 Thread noorain . ansari
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

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

2013-01-09 Thread NOORAIN ANSARI
AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. &

Re: $$Excel-Macros$$ Re: Happy b'day Noorain Ansari

2013-01-02 Thread NOORAIN ANSARI
Thanks to all of You... -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com> O

Re: $$Excel-Macros$$ Happy b'day Noorain Ansari

2013-01-02 Thread NOORAIN ANSARI
, 1 Jan 2013 18:43:59 > To: > Reply-To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Happy b'day Noorain Ansari > > Happy b'day Noorain Ansari > > > Regards > Ashish Koul > Sent on my BlackBerry® from Vodafone > > -- > Join official

Re: $$Excel-Macros$$ Excel Fun Video

2013-01-01 Thread NOORAIN ANSARI
; You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ How to remove error" To many different cell formats" in excel

2012-12-31 Thread NOORAIN ANSARI
Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. &g

Re: $$Excel-Macros$$ Hi

2012-12-27 Thread NOORAIN ANSARI
Dear Rajat, You have been added successfully in excel-macros group, Please check and confirm. -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelvbaclinic.blogspot.com>excel

Re: $$Excel-Macros$$ splitting the column

2012-12-27 Thread NOORAIN ANSARI
o the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.co

Re: $$Excel-Macros$$ Combine all sheets in a single sheet

2012-12-26 Thread NOORAIN ANSARI
, > > In your code the statement Exit Sub comes right before End Sub. It is also > not based on any condition being tested and no Error Handling is there so > Go To is also not being used. > Could you please explain how this code is working? > > Warm Regards, > Anand Kumar >

Re: $$Excel-Macros$$ AutoFill/Copy & Paste Across Data Range to Last Row

2012-12-20 Thread NOORAIN ANSARI
you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google

Re: $$Excel-Macros$$ Amendment in macro

2012-12-18 Thread NOORAIN ANSARI
" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- With Regards

Re: $$Excel-Macros$$ Merge entry cell

2012-12-17 Thread NOORAIN ANSARI
t; group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >&g

Re: $$Excel-Macros$$ Extract value excluding 0

2012-12-17 Thread NOORAIN ANSARI
re. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible fo

Re: $$Excel-Macros$$

2012-12-17 Thread NOORAIN ANSARI
Dear Karan, Please try =INDEX($B$2:$B$6,SMALL(IF($B$2:$B$6<>0,ROW($B$2:$B$6),""),ROW(A3))-1) with ctrl+shift+Enter see attached sheet for more clarity. -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.nooraina

Re: $$Excel-Macros$$ small query

2012-12-16 Thread NOORAIN ANSARI
gt; excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelv

Re: $$Excel-Macros$$ Multiple Values by Vlookup

2012-12-04 Thread NOORAIN ANSARI
his? >> >> >> *Paul* >> >> - >> *“Do all the good you can, >> By all the means you can, >> In all the ways you can, >> In all the places you can, >> At all the times you can, >> To all the peo

$$Excel-Macros$$ Multiple Values by Vlookup

2012-12-04 Thread NOORAIN ANSARI
Dear Group, Please find attached sample sheet, where vlookup is working on duplicate Data. Kindly suggest, how can we make it more dynamic. -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> ht

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

2012-12-03 Thread NOORAIN ANSARI
valuable knowledge with us. -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com> On Mon, Dec 3,

Re: $$Excel-Macros$$ Re: Calculation Automatically Not Updating.

2012-11-14 Thread NOORAIN ANSARI
ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MAC

Re: $$Excel-Macros$$ Find value on duplicate and two conditions

2012-11-13 Thread NOORAIN ANSARI
You can also use.. =SUMPRODUCT(($A$2:$A$8=G3)*($B$2:$B$8=H3)*($C$2:$C$8)) On Wed, Nov 14, 2012 at 1:15 PM, NOORAIN ANSARI wrote: > Dear karan, > > Please try it.. > > > =INDEX($C$2:$C$8,SMALL(IF(($A$2:$A$8=$G3)*($B$2:$B$8=$H3),ROW($C$2:$C$8),""),COUNTIFS($A$2:$A$8,G3

Re: $$Excel-Macros$$ Find value on duplicate and two conditions

2012-11-13 Thread NOORAIN ANSARI
this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Vi

Re: $$Excel-Macros$$ multiple sheet reference..

2012-11-08 Thread NOORAIN ANSARI
glegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noora

Re: $$Excel-Macros$$ multiple sheet reference..

2012-11-08 Thread NOORAIN ANSARI
group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > --

Re: $$Excel-Macros$$ Re: Magical Diwali Template (Excel Version)

2012-11-08 Thread NOORAIN ANSARI
> thanks > > -Ayush Jain > > On Thursday, 8 November 2012 17:12:23 UTC+5:30, NOORAIN ANSARI wrote: >> >> Dear Group, >> >> Please find attached template and double click on it. >> >> >> -- >> With Regards, >> Noor

Re: $$Excel-Macros$$ Required tutorials to learn Basics of Dashboards.

2012-11-08 Thread NOORAIN ANSARI
; >> ** ** >> >> *Thank you >> Regards >> >> >> Sandeep Kumar Chhajer.* >> >> * * >> >> >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf

Re: $$Excel-Macros$$ Vlookup Book

2012-11-08 Thread NOORAIN ANSARI
Dear Amit, I am still committed on my words. But I need some more time to complete it perfection and after completing it I will definitely share it with group without any further reminder. Kindly don't mark any mail to my official ID. -- With Regards, Noorain Ansari http://

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

2012-11-06 Thread NOORAIN ANSARI
Dear Sanusi, Pls use below formula =LEFT(B3,FIND(")",B3,1)) =RIGHT(B3,LEN(B3)-FIND(")",B3)) see attachment for more clarity. Please use separate thread for your fresh query instead of another thread. -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com

Re: $$Excel-Macros$$ Re: Arrow Symbol Solution in Excel

2012-11-06 Thread NOORAIN ANSARI
. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are pr

Re: $$Excel-Macros$$ Excel dashboards

2012-11-06 Thread NOORAIN ANSARI
ge because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this g

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

2012-11-06 Thread NOORAIN ANSARI
Congrats Brother. -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com> On Tue, Nov 6,

Re: $$Excel-Macros$$ how to enable macros in my system

2012-11-05 Thread NOORAIN ANSARI
; owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this grou

Re: $$Excel-Macros$$ 6 - 11 automatically changing to date formate it should display as it is

2012-10-31 Thread NOORAIN ANSARI
received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ How to delete alternate sheets faster

2012-10-31 Thread NOORAIN ANSARI
> *Thank you.* > * > * > *Pravin. > * > > > On Thu, Nov 1, 2012 at 11:04 AM, NOORAIN ANSARI > wrote: > >> Dear Pravin, >> >> >> Please try >> >> Sub delete_alternative_sheet() >> Dim i As Integer >> On Error Resume Next >> For i = 2

Re: $$Excel-Macros$$ Unhide sheet

2012-10-31 Thread NOORAIN ANSARI
ks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL A

Re: $$Excel-Macros$$ How to delete alternate sheets faster

2012-10-31 Thread NOORAIN ANSARI
oups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-m

Re: $$Excel-Macros$$ Serial no

2012-10-31 Thread NOORAIN ANSARI
@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorain

Re: $$Excel-Macros$$ Vlookup Book

2012-10-29 Thread noorain . ansari
Dear Amit, Currently i am out of station. Will share it shortly Sent from BlackBerry® on Airtel -Original Message- From: "Amit Desai (MERU)" Sender: excel-macros@googlegroups.com Date: Mon, 29 Oct 2012 14:25:27 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlo

Re: $$Excel-Macros$$ Exel hyperlink

2012-10-27 Thread noorain . ansari
Dear Ajay, Copy a blank cell and select email id and paste special as format Sent from BlackBerry® on Airtel -Original Message- From: ajay prasad Sender: excel-macros@googlegroups.com Date: Sat, 27 Oct 2012 08:26:07 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$

Re: $$Excel-Macros$$ countif in hidden rows

2012-10-23 Thread NOORAIN ANSARI
ions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. >

Re: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread NOORAIN ANSARI
, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data i

Re: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread NOORAIN ANSARI
ated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA

Re: $$Excel-Macros$$ ONLINE .NET TRAINING

2012-10-22 Thread noorain . ansari
Dear Ayush, Pls ban this email id Sent from BlackBerry® on Airtel -Original Message- From: mytrani...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 22 Oct 2012 17:33:36 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ ONLINE .NET TRAINING HI, PLEAS

$$Excel-Macros$$ Re: Pls Help Me on this

2012-10-19 Thread NOORAIN ANSARI
oftware Developer, > Abacus Software Services Pvt Ltd > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.bl

Re: $$Excel-Macros$$ Pls Help Me on this

2012-10-19 Thread NOORAIN ANSARI
"MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>n

Re: $$Excel-Macros$$ need formula

2012-10-19 Thread NOORAIN ANSARI
t; To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorai

Re: $$Excel-Macros$$ compare and highlight

2012-10-11 Thread NOORAIN ANSARI
is message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > &

Re: $$Excel-Macros$$ pls subcribe me ASAP

2012-10-10 Thread NOORAIN ANSARI
um > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this

Re: $$Excel-Macros$$ Need Help related to XML with excel

2012-10-10 Thread NOORAIN ANSARI
ail to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- With Regards, Noorain Ansari http:// <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http:// <ht

  1   2   3   4   5   6   7   8   9   10   >