Re: $$Excel-Macros$$ find doubling

Hi suman, I have a address software in which data enterd by other opprters and I think some data is double so i want to export data from there in excel short out double data than i will remove that data from software. so i wanted to printout that double address. Anil --

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

Hello everyone, I have recognised the achievement on discussexcel.com as well. Here is the link Regards Ayush Jain On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain wrote: > Hello Ev

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

Hi Noor, Congratulation Thanks On Sun, Oct 2, 2011 at 10:17 AM, Nikhil Shah wrote: > Hi Noorain > > Excellent work Noorain. > > Regards > > Nikhil > > On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain wrote: > >> Hello Everyone, >> >> Noorain Ansari has been selected as 'Most Helpful Member' for the

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

Hi Noorain Excellent work Noorain. Regards Nikhil On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Sept'11 > He has posted 140 posts in sept 2011 and helped many people through his > expertise

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

Hi Noorain, Congrats *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Sept'11

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

Fabulous work Noorain. You make a difference, and all of us in the forum appreciate your contribution. Carry on the excellent work. Sam Mathai Chacko (GL) On 10/2/11, suryaprasad...@gmail.com wrote: > Hip Hip Hurry.. For sure you deserve that NOORAIN u rock dear ...keep > rocking way to go i

$$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

hi i Need VB lines codes for Alert MsgBox Pair duplicate entry in row Column D function account and duplicates alerts (NO Problem!) Attach File , thank you all -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- --

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

Hip Hip Hurry.. For sure you deserve that NOORAIN u rock dear ...keep rocking way to go in this group Thanks Surya Sent from BlackBerry® on Airtel -Original Message- From: Ayush Jain Sender: excel-macros@googlegroups.com Date: Sun, 2 Oct 2011 00:43:24 To: excel-macros Reply-To: exc

Re: $$Excel-Macros$$ Help Needed.

Here is one I like to use for setting variables (Options) in a file that is used by other Macros. Using the Macro below; I can toggle between True and False on the Options and Colors for specific cells. Available Options Star Font Size =16 Label Fo

Re: $$Excel-Macros$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST

very very thanks sir for helping me. On 10/1/11, Sam Mathai Chacko wrote: > Shorter one... > > =IF(ROW($A1)>COUNTIF(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9"),"*"&$C$3&"*"),"",INDEX(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$A$2:$A$9"),SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(SEARCH!$D$1,"MMM

Re: $$Excel-Macros$$ Splitting of files

Hi Shrinivas Try : Sub Mtest() Dim Rng As Range Dim ws As Worksheet Dim shname As String Dim i As Integer Dim shn As Long Dim mx As Variant Dim x As Integer Dim LR As Long Dim sPath As String, sFileName As String On Error Resume Next Application.DisplayAlerts = False Sheets("Temp").Delete Applica

Re: $$Excel-Macros$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST

Shorter one... =IF(ROW($A1)>COUNTIF(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9"),"*"&$C$3&"*"),"",INDEX(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$A$2:$A$9"),SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9"))),ROW(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9"))-MIN(RO

Re: $$Excel-Macros$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST

Interesting!!! Here you go... =IF(ISERROR(SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9"))),ROW(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9"))-MIN(ROW(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9")))+1,""),ROW(A1))),"",INDEX(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"

Re: $$Excel-Macros$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST

I HAVE CHECKED ITS WORKING BUT PROBLEM IS THAT THIS FORMULA IS ON MY TIPS . SO THAT'S WHY I WANT ERROR HANDLER ON THIS On Sat, Oct 1, 2011 at 10:18 PM, Sam Mathai Chacko wrote: > Well, I haven't used error handler in the first post, but if you use one of > the formulas from my second post, you w

Re: $$Excel-Macros$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST

Well, I haven't used error handler in the first post, but if you use one of the formulas from my second post, you will not get that #NUM error. Check the attached file in my previous post. Sam On Sat, Oct 1, 2011 at 10:12 PM, Sourabh Salgotra wrote: > VERY VERY THANKS SIR FOR HELPING ME I HAVE O

Re: $$Excel-Macros$$ date format in Excel

Hi Sanjib, If it is real date then sir dguillett suggestion will work fine... --- Ms.Exl.Learner --- On Fri, Sep 30, 2011 at 11:03 AM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear > > I like to put the date format in Excel as "dd/mm/yyy

$$Excel-Macros$$ Solver solution, Monte Carlo simulation through a macro

I am running a multivariate mixing model to estimate the relative contributions of the suspended sediment source areas to a particular sediment sink on the basis of measured geochemical properties of the sink and the potential sources. For each property, a linear equation is constructed that

Re: $$Excel-Macros$$ Computer moving average hrs of play per day

I solved it with a combination of VLookup to get the date that is X days (X is the number of days of play that I want to average) prior to the current date (VLookup by default picks the value in the data that is less than the specific number/date if no match is found, if I did not play on a specif

Re: $$Excel-Macros$$ Splitting of files

This is easy enough to do with a macro. However, please consider leaving all in one file and simply use data>filter>autofilter. -Original Message- From: Chidurala, Shrinivas Sent: Saturday, October 01, 2011 6:04 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Splitting o

Re: $$Excel-Macros$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST

By the way, replace "SINGH" with $C$3 On Sat, Oct 1, 2011 at 4:14 PM, Sam Mathai Chacko wrote: > Don't seem like you tried my suggestion. > > Anyway, since there were posts sharing two examples with HLOOKUP and > OFFSET, I have included that also in my suggestion. > > HLOOKUP and OFFSET will work

Re: $$Excel-Macros$$ Extract (%) Numbers from the text

Hi ur %ages are in ascending order in a cell try this formula IFERROR(MID(A2,FIND("%",A2)-2,3),"") On Sat, Oct 1, 2011 at 3:08 PM, karan 1237 wrote: > Hello All, > > Hope you all are doing well. I'm here as usual, need your assistance. I'v > text data which have percentage numbers (50% or 60

$$Excel-Macros$$ Extract (%) Numbers from the text

Hello All, Hope you all are doing well. I'm here as usual, need your assistance. I'v text data which have percentage numbers (50% or 60%), I need to extract minimum percentage number. Kindly help me to sort out this problem. Text is : minimum qualification pcm with 50% or MCA 60% Result should be

Re: $$Excel-Macros$$ Help Needed.

Thanks rajan babu, for that link.Can anybody quote some more examples in detail.I just got a little understanding of the function with arguments.But to enhance my knowledge i would like to study more examples...Pls provide me with any other examples. On Sat, Oct 1, 2011 at 12:18 PM, rajan verm

Re: $$Excel-Macros$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST

not working On Sat, Oct 1, 2011 at 10:40 AM, Sam Mathai Chacko wrote: > USE > > > =INDEX(INDIRECT(TEXT(D1,"MMMYY")&"!$A$2:$A$65536"),SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(D1,"MMMYY")&"!$B$2:$B$65536"))),ROW(INDIRECT(TEXT(D1,"MMMYY")&"!$B$2:$B$65536"))-MIN(ROW(INDIRECT(TEXT(D1,"MMMYY")&"!$B$

Re: $$Excel-Macros$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST

On Sat, Oct 1, 2011 at 1:23 PM, Sourabh Salgotra wrote: > thanks for help > > but in this sheet all the data returned from the selected sheet searching > not working. > > i want 2 solutions > > 1 choose sheet > 2 search data (which is in c3 cols) if u type singh in c3 then result > generated t