Re: $$Excel-Macros$$ Showing 65536 Rows

2013-03-11 Thread The Viper
you should choose .xlsx format while saving your workbook On Tue, Mar 12, 2013 at 11:35 AM, Chaya wrote: > Sir, i am using Ms office 2010. > > -Chaya > > > On Tue, Mar 12, 2013 at 11:28 AM, The Viper wrote: > >> what version of excel are you using? >> Ëx

Re: $$Excel-Macros$$ Showing 65536 Rows

2013-03-11 Thread The Viper
did save as than, please suggest > experts.. > > Thanks, > Chaya > > > On Tue, Mar 12, 2013 at 11:19 AM, The Viper wrote: > >> you cannot view more than 65536 rows in prior versions of excel. >> if your excel version is 2007 or above, choose .xlsx file forma

Re: $$Excel-Macros$$ Showing 65536 Rows

2013-03-11 Thread The Viper
you cannot view more than 65536 rows in prior versions of excel. if your excel version is 2007 or above, choose .xlsx file format while saving your workbook. On Tue, Mar 12, 2013 at 11:05 AM, Chaya wrote: > Dear Experts, > > I have a data base which contains more than 1 lacs rows

Re: $$Excel-Macros$$ Remove All Enter..............

2013-03-06 Thread The Viper
=SUBSTITUTE(A1,CHAR(10)," ") On Wed, Mar 6, 2013 at 3:30 PM, Kuldeep Singh wrote: > > Hi, > > I want to remove all enter. > > Regards, > Kuldeep Singh > > -- > 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 for

Re: $$Excel-Macros$$ hyperlink issue

2013-03-01 Thread The Viper
Thanks a lot everybody who give time for my solution. >> Regards >> Amar >> >> >> On Fri, Mar 1, 2013 at 9:33 AM, The Viper wrote: >> >>> I don't understand Mr.Bé Trần Văn >>> >>> >>> On Thu, Feb 28, 20

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

2013-02-28 Thread The Viper
Hello xlstime! Your formula won't work Values in the array will be multiplied by 0 if it dose not meets the criteria. It will be multiplied by 1 if it meets the criteria. So using MIN function in SUMPRODUCT will give 0, if there is any value in the array which does not meets the criteria. O

Re: $$Excel-Macros$$ hyperlink issue

2013-02-28 Thread The Viper
I don't understand Mr.Bé Trần Văn On Thu, Feb 28, 2013 at 10:18 PM, Bé Trần Văn wrote: > Learn test. > > > 2013/2/28 The Viper > >> can't get throuh formula? >> >> pfa >> >> >> >> On Thu, Feb 28, 2013 at 5:30 PM, Divaker Pandey

Re: $$Excel-Macros$$ hyperlink issue

2013-02-28 Thread The Viper
can't get throuh formula? pfa On Thu, Feb 28, 2013 at 5:30 PM, Divaker Pandey wrote: > solved . > > > On Thu, Feb 28, 2013 at 3:41 PM, amar takale wrote: > >> Dear All, >> >> I have facing some hyperlink issue in sheet,I attached sheet in detailed >> information,Pls tell me It is possible? >

Re: $$Excel-Macros$$ Data Validation issue

2013-02-27 Thread The Viper
"Maruti Kadam" is available in a9. but the original named range is "Maruti_Kadam". an underscore is missing. On Thu, Feb 28, 2013 at 12:54 PM, amar takale wrote: > Dear All, > I have Data validation sheet in which In output sheet cell B6,I put data > validation with Indirect formula that time I

Re: $$Excel-Macros$$ PDF attachment in Excel Cell

2013-02-25 Thread The Viper
you can attach it as an object On Tue, Feb 26, 2013 at 9:40 AM, अनिल नारायण गवली wrote: > Dear Amar, > > Yes it is possible with hyperlink > > just give the right url and save it. > > Pl see the attached sheet. > > Warm Regards, > Gawli Anil. > > On Mon, Feb 25, 2013 at 7:28 PM, Anil B wrote: >

Re: $$Excel-Macros$$ Date hour value problem!

2013-02-22 Thread The Viper
s written it is not working. Again for strange reason where 2.30 was > written after converting it become 2:03. Don't know why! Pls suggest! > > > Sandeep Chhajer. > Sent on my BlackBerry® from Vodafone > ---------- > *From: * The Viper > *Sender: *

Re: $$Excel-Macros$$ Date hour value problem!

2013-02-22 Thread The Viper
select the data and press ctrl+h put .(dot) in "Find what" and put ":" in "Replace with" click Replace all On Fri, Feb 22, 2013 at 3:41 PM, wrote: > Dear excel guru, > I have a problem...I want my hour to be written as 4:45. But I entered > 2 data as 4.45. Now if I am changing it to [h]:mm f

Re: $$Excel-Macros$$ Date Format query.......

2013-02-21 Thread The Viper
on't print this e-mail unless > you really need to.* > > On Thu, Feb 21, 2013 at 3:57 PM, The Viper wrote: > >> assuming your date is in a1 >> =a1+7 >> >> >> On Thu, Feb 21, 2013 at 3:52 PM, Kuldeep Singh >> wrote: >> >>>

Re: $$Excel-Macros$$ Date Format query.......

2013-02-21 Thread The Viper
assuming your date is in a1 =a1+7 On Thu, Feb 21, 2013 at 3:52 PM, Kuldeep Singh wrote: > > Hi All, > > One instant query. my format is 18/02/2013 & I want to add 7 days. Please > help > > Regards, > Kuldeep Singh > Info Edge India Limited (naukri.com) > Phone.: +91-0120-4841100, Extn.: 2467,

Re: $$Excel-Macros$$ Minimum Value of particular columns to be highlighted

2013-02-13 Thread The Viper
pfa and check formula in conditional formating On Wed, Feb 13, 2013 at 4:45 PM, Amit Gandhi wrote: > Hi Experts > > I want to highlight minimum value of some particular columns say columns > D,H,L in attached file through Conditional Formatting. How it can be > possible? Pls help me here. > > Re

Re: $$Excel-Macros$$ Count

2013-02-07 Thread The Viper
did you try =SUM(1/COUNTIFS(A2:A10,A2:A10,B2:B10,B2:B10,C2:C10,C2:C10)) with CSE ??? On Thu, Feb 7, 2013 at 2:44 PM, Smitha S R wrote: > Hi, > Required is : > > > Count of names matching product 'A' and Id '1S' is 4 > and count of names matching product 'A' and ID '2B' is 4 > > > On Thu, Feb 7,

Re: $$Excel-Macros$$ Count

2013-02-07 Thread The Viper
use =SUM(1/COUNTIFS(A2:A10,A2:A10,B2:B10,B2:B10,C2:C10,C2:C10)) with CSE On Thu, Feb 7, 2013 at 2:09 PM, Aamir Shahzad wrote: > You can use: > > =COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2) > > Aamir Shahzad > > On Thu, Feb 7, 2013 at 1:36 PM, Smitha S R wrote: > >> Hi, >> >> Please help me in findin

Re: $$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value

2013-02-05 Thread The Viper
pfa you can modify the range on formula as desired. On Wed, Feb 6, 2013 at 9:34 AM, John A. Smith wrote: > Paul, > > #1) By using conditional formatting, highlight any row the EXACT target > value is in regardless of the column it's in > #2) Has to be an EXACT match > #3) Helper columns are okay

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

2013-01-18 Thread The Viper
Dear Excel Learner, *"You can also try"* Google stats will show you in active posters list and you will get more counts. On Fri, Jan 18, 2013 at 4:39 PM, Ms-Exl-Learner wrote: > Hm... No one is understanding what I am trying to say... > > It's not only about this post, I am also talking about

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

2013-01-10 Thread The Viper
What you're asking is not possible without helper column. here is my openior. PFA On Thu, Jan 10, 2013 at 5:39 PM, Hilary Lomotey wrote: > Thanks Noorain, > > for what am trying to do, i need a formula instead. But that is the exact > principle of what i was explaining. thanks > > > On Thu, Jan

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

2013-01-10 Thread The Viper
=MAX(IF(A1:A8=D1,ROW(A1:A8),"")) with CSE On Thu, Jan 10, 2013 at 4:41 PM, Hilary Lomotey wrote: > Hi Experts, > > In the attached, i have a list of items, some are repetitive in the list, > if i want to find the relative position of each item what formula can be > helpful, the normal match will

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

2013-01-09 Thread The Viper
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

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

2013-01-04 Thread The Viper
ignore previous one. pfa On Sat, Jan 5, 2013 at 11:49 AM, The Viper wrote: > pfa > > > On Sat, Jan 5, 2013 at 11:43 AM, ravinder negi wrote: > >> Here is the anwser, I have attached a file with solution. Please reply if >> you want this? >> >> ---

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

2013-01-04 Thread The Viper
pfa On Sat, Jan 5, 2013 at 11:43 AM, ravinder negi wrote: > Here is the anwser, I have attached a file with solution. Please reply if > you want this? > > --- On *Fri, 1/4/13, harshad shukla * wrote: > > > From: harshad shukla > Subject: $$Excel-Macros$$ Vlookup for two same values > To: excel-m

Re: $$Excel-Macros$$ how to lock worksheet

2013-01-04 Thread The Viper
apply the filter before protecting the sheet. select the options "use filters" in sheet protection dialogue box On Fri, Jan 4, 2013 at 3:17 PM, अनिल नारायण गवली wrote: > Dear Dhaval, > > Hide the formula bar which is availabale in options tab of workbook. > > > Thanks & Regards, > Gawli Anil > >

Re: $$Excel-Macros$$ Re: Remove Duplicate Email ID

2013-01-04 Thread The Viper
Still finding the necessity for the lengthiest code from prince. It can be achieved in few clicks through excel built in option called "Remove Duplicates". Assuming OP is using excel 2007 or later versions as he is working with 6 lakh records. The below code is enough, even if we want to write in

Re: $$Excel-Macros$$ بضائع جنسية +18

2013-01-04 Thread The Viper
Ayush, Nowadays lots of spam in group. Moderators should be cautious 2013/1/4 سمية صفار > اول موقع سكس شوب عربي > يتميز المتجر بالمصداقية العالية و الموثوقية الكبيرة > الاسعار المنافسة و الجودة العالية > توفير كل طرق الدفع السهلة و المتاحة > ضم الاف المنتجات الجنسية المتنوعة > شحن الى الدول ال

Re: $$Excel-Macros$$ How to find special characters in a cell

2013-01-02 Thread The Viper
""),"?",""),"<",""),">",""),"|",""),"""","")) ask me if you have any doubts in this On Thu, Jan 3, 2013 at 12:27 PM, The Viper wrote: > place the name on a1 > belo

Re: $$Excel-Macros$$ How to find special characters in a cell

2013-01-02 Thread The Viper
place the name on a1 below formula should work with CSE =IF(SUM(IFERROR(FIND({"/","\","?","<",">","|","*",},A1),""))>0,"Wrong","Ok") On Wed, Jan 2, 2013 at 8:34 PM, wrote: > In excel 2012 I'm using the name typed in a cell as a part of the filename > when saved via a macro. > Because the fol

Re: $$Excel-Macros$$ Lookup and Replace

2013-01-02 Thread The Viper
slightly modified your code. check the attachment On Thu, Jan 3, 2013 at 8:47 AM, Awal wrote: > Hello, > I would like to wish y'all a Happy New year... > I am still learning VBA and I really need help: > I want to be able to look up for an item and change its price. > See attached file.Can some

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

2013-01-02 Thread The Viper
Hi lalit I don't find any need for that. just working as required by OP On Wed, Jan 2, 2013 at 3:15 PM, Lalit Mohan Pandey wrote: > Nice formula viper but the last space is missing. > > > On Wednesday, 2 January 2013 15:07:20 UTC+5:30, §»VIPER«§ wrote: > >> =LEFT(A1,MIN(IFERROR(FIND({0,**1,2,3,

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

2013-01-02 Thread The Viper
=LEFT(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),""))-1)&SUBSTITUTE(MID(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),"")),255)," ","") this should work with CSE On Wed, Jan 2, 2013 at 2:55 PM, Pravin Gunjal wrote: > It's absolutely working fine. > > Pravin Gunjal > > > -- Forwarded

Re: $$Excel-Macros$$ HIGH LOW QUERY

2012-12-24 Thread The Viper
for low value date its not working psl chk > > thanks > > > On Mon, Dec 24, 2012 at 5:17 PM, The Viper wrote: > >> use >> >> =INDEX($C$2:$C$3000,MATCH(F2&MAX(IF($A$2:$A$3000=F2,$B$2:$B$3000,0)),$A$2:$A$3000&$B$2:$B$3000,0)) >> with CSE >

Re: $$Excel-Macros$$ HIGH LOW QUERY

2012-12-24 Thread The Viper
use =INDEX($C$2:$C$3000,MATCH(F2&MAX(IF($A$2:$A$3000=F2,$B$2:$B$3000,0)),$A$2:$A$3000&$B$2:$B$3000,0)) with CSE On Mon, Dec 24, 2012 at 4:24 PM, Dhaval Shah wrote: > *Hello Prince *, > > pls help me out lastly u send me one file as per my requirement but some > how i facing problem with your fil

Re: $$Excel-Macros$$ Pl Solve my date query

2012-12-10 Thread The Viper
another approach works even if dates are not sorted pfa On Tue, Dec 11, 2012 at 10:21 AM, Pravin Gunjal wrote: > *Good one. Thanks Anoop.* > > -- Forwarded message -- > From: Anoop K Sharma > Date: Tue, Dec 11, 2012 at 8:19 AM > Subject: Re: $$Excel-Macros$$ Pl Solve my date que

Re: $$Excel-Macros$$ NEED HELP

2012-12-09 Thread The Viper
other ways for shortening the formula =IF(A2=FALSE,B2,A2) or =SUBSTITUTE(A2&B2,"FALSE","") On Mon, Dec 10, 2012 at 10:28 AM, Anoop K Sharma wrote: > Hi Dhaval, > > PFA... > > Regards, > Anoop > Sr. Developer > > > On Mon, Dec 10, 2012 at 9:12 AM, Dhaval Shah wrote: > >> >> -- >> Join of

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

2012-12-04 Thread The Viper
below is the solution if i understood your requirement correctly =IFERROR(INDEX(G$5:G$11,SMALL(IF(F$5:F$11=I$5,ROW(F$5:F$11),""),ROW()-4)-4),"") with CSE pfa On Tue, Dec 4, 2012 at 6:19 PM, Paul Schreiner wrote: > Noorain, > > In what way do you wish to make it more "dynamic"? > > How do you use

Re: $$Excel-Macros$$ Calendar - Quarterly

2012-10-27 Thread The Viper
pfa On Sat, Oct 27, 2012 at 3:06 AM, Viswanathan Yoganathan < viswanathan.yoganat...@asia.xchanging.com> wrote: > HI, > > ** ** > > In the first column we have is year, based upon the month of the year it > should fix into 4 quarters as shown in the below example. > > ** ** > > *Year*

Re: $$Excel-Macros$$ St id Reqd on Max Date

2012-10-04 Thread The Viper
pfa On Fri, Oct 5, 2012 at 10:58 AM, Manoj Kumar wrote: > Dear Expert, > > > Request you to kindly help me on this matter... > Please find the attachment.. > > I want id witch has on max dateeg:- if "name1" max date is 3-Oct it show > 9564 > > > > > Regard > Manoj > > -- > Join official facebook

Re: $$Excel-Macros$$ Hours Calculation Project

2012-10-03 Thread The Viper
here is my co-operation on your project pfa On Wed, Oct 3, 2012 at 1:38 PM, SAJID MEMON wrote: > Dear Expert, > > I require your co-operation to complite my project. I have attached a > require file in excel 2003. Please give me details with code to complite my > project. > > Awiting your posit

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)

2012-06-04 Thread The Viper
well done rajan... On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain wrote: > Hello Everyone, > > Rajan Verma has been selected as 'Most Helpful Member' for the month of > May'2012 > He has posted 147 posts in May 2012 and helped many people through his > expertise. > > I truly appreciate his consist

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

2012-05-02 Thread The Viper
Congrats Rajan.. On Thu, May 3, 2012 at 10:58 AM, Maries wrote: > *Congrats Brother.* > > > On Wed, May 2, 2012 at 8:15 PM, xlstime wrote: > >> Congratulation Rajan >> >> On Wed, May 2, 2012 at 9:30 PM, Ayush Jain wrote: >> >>> Hello Everyone, >>> >>> Rajan Verma has been selected as

Re: $$Excel-Macros$$ pls help with sum if formula

2012-04-08 Thread The Viper
also you can use the below formula if you are using ms office 2007 or later versions =sumifs(d3:d409,g3:g409,">350", g3:g409,"<450") On Mon, Apr 9, 2012 at 10:11 AM, Maries wrote: > Hi, > > Try Below Formulas, > > =SUMPRODUCT(--((G3:G409>350)*(G3:G409<450))*D3:D409) > > =SUM(IF(--(G3:G409>35

Re: $$Excel-Macros$$ count formula problem...

2012-04-07 Thread The Viper
=COUNTIF($A$2:$A$1393,A2) or =COUNTIF(A:A,A2) in a2 and copy down On Sat, Apr 7, 2012 at 12:32 PM, Mohammed Muneer wrote: > Please find the attachment. > > ** ** > > ** ** > > Regards, > > Muneer, > > CC... > > ** ** > > ** ** > > -- > FORUM RULES (986+ members already BANNED

Re: $$Excel-Macros$$ count formula problem...

2012-04-06 Thread The Viper
attachment?? On Sat, Apr 7, 2012 at 12:08 PM, Mohammed Muneer wrote: > Dear friends can u please check the attached for the above subject. > > ** ** > > ** ** > > Regards, > > Muneer, > > CC... > > ** ** > > ** ** > > -- > FORUM RULES (986+ members already BANNED for violation)

Re: $$Excel-Macros$$ NEED SOME ATT.

2012-04-06 Thread The Viper
in b2 =--LEFT(A2,FIND("+",A2)-1) in c2 =IF(ISNUMBER(--(A2)),0,RIGHT(A2,LEN(A2)-FIND("+",A2))) or =iferror(RIGHT(A2,LEN(A2)-FIND("+",A2)),0) On Sat, Apr 7, 2012 at 10:51 AM, anil kumar wrote: > > > On Sat, Apr 7, 2012 at 10:50 AM, anil kumar wrote: > >> Hi Friends, >> >> can anybody solve th

Re: $$Excel-Macros$$ Deletion of files on specific path

2012-02-16 Thread The Viper
if your file name is exactly sample.xlsx then use C: CD "C:\Documents and Settings\priyanka\desktop\sample" DEL /q /s /f "sample.xlsx" On Thu, Feb 16, 2012 at 6:07 PM, The Viper wrote: > is "C:\Documents and Settings\priyanka\desktop\sample" the right path of

Re: $$Excel-Macros$$ Deletion of files on specific path

2012-02-16 Thread The Viper
ords need to change ? > > > > CLS > C: > CD "C:\Documents and Settings\priyanka\desktop\sample" > DEL /q /s /f "sample.xlsx" > > change the path and you can use the wildcards like below > > DEL /q /s /f "*sample.xlsx" > or > DEL /q /s /

Re: $$Excel-Macros$$ Deletion of files on specific path

2012-02-16 Thread The Viper
paste the below code in notepad and save it with .bat extension and run CLS C: CD "C:\Documents and Settings\priyanka\desktop\sample" DEL /q /s /f "sample.xlsx" change the path and you can use the wildcards like below DEL /q /s /f "*sample.xlsx" or DEL /q /s /f "sample*.xlsx" On Thu, Feb 16

Re: $$Excel-Macros$$ VBA to return to Previous Sheet used

2012-02-15 Thread The Viper
try this Sub GetColumnRef() Dim mSht mSht = ActiveSheet.Name Dim MyInput MyInput = InputBox("Enter Column to Search eg D:5") Sheets.Add.Name = MyInput Sheets(mSht).Activate End Sub On Thu, Feb 16, 2012 at 12:09 PM, NOORAIN ANSARI wrote: > Dear Cab, > > Please try it.. > > Sub GetColumnRef() >

Re: $$Excel-Macros$$ plz, check how many categories are there in the column A totally by formula that is applied in single cell to display the result?

2012-02-15 Thread The Viper
in addition to noorain formula you can use =sumproduct(1/COUNTIF(A1:A356,A1:A356) without ctrl+shift+enter On Wed, Feb 15, 2012 at 1:56 PM, NOORAIN ANSARI wrote: > Dear Muneer, > > Please use.. > > =SUM(1/COUNTIF(A1:A356,A1:A356) > with ctrl+shift+ENter. > > See attached sheet. > On Wed, Feb 1

Re: $$Excel-Macros$$ Formula to find Maximum number from list

2012-02-08 Thread The Viper
its working fine. now i have wrote two types of formulas go through the attachment. On Wed, Feb 8, 2012 at 4:53 PM, Ashish Bhalara wrote: > Maximum number is 1003, not display in your formula > > > On Wed, Feb 8, 2012 at 4:49 PM, The Viper wrote: > >> hi ashish >>

Re: $$Excel-Macros$$ Formula to find Maximum number from list

2012-02-08 Thread The Viper
hi ashish use =MAX(--REPLACE(A2:A41,1,9,"")) with CSE On Wed, Feb 8, 2012 at 4:18 PM, Ashish Bhalara wrote: > Dear expert, > > I want to formula of maximum number find from a different list which > example attached herewith. > > Thanks & regards > > Ashish Bhalara > > -- > FORUM RULES (986+ m

Re: $$Excel-Macros$$ formula in rate column

2012-02-03 Thread The Viper
hi check the attachment On Sat, Feb 4, 2012 at 12:02 AM, raghu gr wrote: > Hi experts, > > I have a invoice file and summary file, i want the formula in rate column, > which has to pick from rate sheet. > please help me in this regard > > Attached sample file > > Thank you > > with regards >

Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

2012-02-03 Thread The Viper
please find the attached On Fri, Feb 3, 2012 at 1:28 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > > Dear Experts, > > Please See the attachment and Help me regarding VLOOKUP FUNCTION > > Thanking you in Advance > > Sanjib > > > > > > > > > > -- > - > > -- > FORUM RULES (986+ m

Re: $$Excel-Macros$$ Need help

2012-02-02 Thread The Viper
go through the attachment On Thu, Feb 2, 2012 at 9:25 PM, sriram ji wrote: > > > > Dear Excel Guru, > > Kindly provide the solution for the attached file. > > Thanks & Regards, > Sriram G > Chennai > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate th

Re: $$Excel-Macros$$ Values before "_"

2012-02-02 Thread The Viper
see the attached =IF(ISERROR(LEFT(A2,FIND("_",A2)-1)),A2,LEFT(A2,FIND("_",A2)-1)) On Thu, Feb 2, 2012 at 3:59 PM, Saurabh Madhusudan Patel < saurabh.pa...@in.aegisglobal.com> wrote: > Hi, > > ** ** > > I have list with the values. I need only text which comes before “*_*”. > Please find a

Re: $$Excel-Macros$$ Match in Rows

2012-02-02 Thread The Viper
in ab1 =if(countif(a1:t1,aa1)>0,countif(a1:t1,aa1),"") On Fri, Feb 3, 2012 at 10:30 AM, qcan wrote: > Hi, > > Not sure how to do this. > > Looking for a formula (preferably) or a macro to find a number in a > row. Kind of like a "loto checker". > > In this case. > > - There are 20 columns

Re: $$Excel-Macros$$ Forrmula need

2012-02-01 Thread The Viper
check the attachment. it may help providing sample file better than showing the data in message body On Thu, Feb 2, 2012 at 9:55 AM, chandra sekaran wrote: > Dear all > Here is my dataitem & Make is same then first item amount X 10 % > should come same items and same make below formula

Re: $$Excel-Macros$$ Password protect hidden sheets

2012-01-31 Thread The Viper
dear priyanka better you can hide data range and protect your sheet. instead of hiding whole sheet. or as sam said you can protect the workbook structure. @rajan & other folks if the macros or disabled? if the codes are modified or deleted? On Tue, Jan 31, 2012 at 6:55 PM, Rajan_Verma wrote: >

Re: $$Excel-Macros$$ Create Uni Code

2011-12-27 Thread The Viper
see the attachment if you want to do it with combination of functions On Wed, Dec 28, 2011 at 11:57 AM, Aamir Shahzad wrote: > thanks for your response Dguillett1 & Rohan but when I run the macro its > shows attached error. Please see the issue. And I don't want to remove the > duplicates if na