$$Excel-Macros$$ macro required for finding uniques

I have a excel file which has 3 tabs by name A,B,C and then another excel file with tab D - both the files are in server in same location. All 4 tabs in both the files have one common column called as Chas Can any one help me please to get a macro which can create a unique(no duplicates) list of

$$Excel-Macros$$ excel modelling and simulation

hi Can somebody help me with excel modelling assignment... some simulation required immediately -- 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 RULES 1)

$$Excel-Macros$$ excel VBA solution - offered at reasonable price

Does any one need help in Excel VBA project or may be entire project to be completed? Let me know. You will get the solution at a reasonable price whether u in US or in India. I am in US right now. -- 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

$$Excel-Macros$$ excel macro help on regular basis required- on weekly payment/hourly basis

I neeed excel macro help on a regualr basis...can pay in dollars every week. if you have time this week, can you pleas reply to me? -- 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

Re: $$Excel-Macros$$ Re: bubbel chart help required.

it worked for me with my data set. On Fri, Mar 22, 2013 at 10:07 AM, rajan verma wrote: > do you really think that will work what you have in excel?? think again. > > On Fri, Mar 22, 2013 at 9:02 AM, Sara Lee wrote: > >> This is already present in excel on tool bar

Re: $$Excel-Macros$$ Re: bubbel chart help required.

This is already present in excel on tool bar.. no need of code actually On Fri, Mar 22, 2013 at 7:49 AM, Rajan_Verma wrote: > I have ready code for this > > http://excelpoweruser.wordpress.com/2012/09/03/bubble-chart/ > > > > On Thursday, 21 March 2013 00:46:03 UTC-6, midhun wrote: >> >> hi all;

$$Excel-Macros$$ add in for chart

hi is there a macro or add in for an CONTROL Charts in Excel? please advise -- 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 RULES 1) Use concise, accurat

$$Excel-Macros$$ pivot need macro

i have a pivot in excel. this pivot table in current format displays data in plain number format. I want to display the numbers as "% of row" format. i know there is an excel feature under options. but i want to add a toggle which can have users change between number and %of row format, by clickin

Re: $$Excel-Macros$$ Re: Highlight Worked Cells only if the Employee has worked in both areas

Rajan can u please explain this code in detail? becuase $b1 is a column heading and can never be ec ? right? On Sun, Sep 16, 2012 at 7:07 AM, Prince Dubey wrote: > Hi Rajan, > > I like your solution, But i feel you have to modify it so that it can work > for the dynamic name ranges as rasid ment

Fwd: $$Excel-Macros$$ FW: macro for pivot

---** *From:* Sara Lee [mailto:lee.sar...@gmail.com] *Sent:* 09 September 2012 7:41 *To:* Rajan_Verma *Subject:* Re: macro for pivot ** ** once i copy and paste into a new module, how to run this macro? how do i link this code to the spreadsheet i am working on? Can you please give exact

Fwd: $$Excel-Macros$$ pls help urgent- need data in the format as required

Please advise a formula to get the data in the attached format. i need a transpose to the data attached. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor th

$$Excel-Macros$$ pls help urgent- need data in the format as required

example attached. i have multiple columns and rows. Please advise a formula to get the data in the attached format. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread tit

$$Excel-Macros$$ Re: pls help with matching postal codes

pls help with this-- can you put in the formula? On Mon, May 7, 2012 at 12:09 AM, Sara Lee wrote: > > > -- > > *col i *in Sheet 2 needs to be filled up > > by looking up *col h *in sheet 2 in sheet 1 *col c* value- either exact > or next closest- i.e for every v

Re: $$Excel-Macros$$ pls help with matching postal codes

t; Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Mon, May 7, 2012 at 9:39 AM, Sara Lee wrote: > >> >> >> -- >> >> *col i *in Sheet 2 needs to be filled up >> >> by looking up *col h *in sheet 2 in sheet 1 *col c* value

$$Excel-Macros$$ match 2 columns

hi i would like to have wgt column in sheet 1 updated based on whenever there is a match on ozip and dzip columns in sheet1 and sheet 2. Can u pls give exact formula? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Plea

Re: $$Excel-Macros$$ data needed in this format

:25 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ data needed in this format > > *Hi Sara * > * > * > *PFA* > > *Regards,* > *Lalit Mohan* > > > > On Sun, Apr 29, 2012 at 12:38 PM, Sara Lee wrote: > >> Attached is the fi

$$Excel-Macros$$ data needed in this format

Attached is the file with 2 sheets - input and output. output i require is based on input tab--- i need every reference value to be listed as columns and then list down the load nos in which these reference values exist in the input tab.example reference7151865O is in 2 load nos below load 0

Re: $$Excel-Macros$$ formula required for count or count if

no but this takes duplicates into consideration.. I would need count of only unique values for every load no On Fri, Apr 27, 2012 at 7:39 AM, Shaik Waheed wrote: > Hi Sara, > > PFA, Hope this is what you are looking for... > > On Fri, Apr 27, 2012 at 4:33 PM, Sara Lee w

Re: $$Excel-Macros$$ formula required for count or count if

113784 > > On Fri, Apr 27, 2012 at 2:52 PM, Darwin Chan > wrote: > >> See if you understand array formula. >> >> http://www.excelfunctions.net/Excel-Array-Formulas.html >> >> >> 2012/4/27 Sara Lee >> >>> thee are two similar rows with s

Re: $$Excel-Macros$$ formula required for count or count if

thee are two similar rows with same load no---this is not working On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote: > you can use > > =SUMPRODUCT(--($A$2:$A$23=AB2)) > > > > > On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee wrote: > >> yes i need count of

Re: $$Excel-Macros$$ formula required for count or count if

should i paste in AB2? On Fri, Apr 27, 2012 at 4:52 AM, Darwin Chan wrote: > sara, > > the formula should workfirst highlight the range you want to implement > this formula, then you should try Ctrl + Shift + Enter. > > > 2012/4/27 Sara Lee > >> it is not w

Re: $$Excel-Macros$$ formula required for count or count if

it is not working-- anybody else can help here On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote: > you can use > > =SUMPRODUCT(--($A$2:$A$23=AB2)) > > > > > On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee wrote: > >> yes i need count of distinct records for each l

Re: $$Excel-Macros$$ formula required for count or count if

d. For Load 0241 - there are 6 values so the formula should return 6. > > > > On Fri, Apr 27, 2012 at 1:09 PM, Darwin Chan > wrote: > >> Hi Sara, >> >> Seems formula COUNTIF can solve your problem simply. >> >> 2012/4/27 Sara Lee >> >>

$$Excel-Macros$$ formula required for count or count if

hi i have data as in the attached data. i need count of unique values of column A i.e i need output as in column AB, AC... pls advise a formula thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Ur

Re: $$Excel-Macros$$ Pivot table

)) > * > Regards, > > MARIES. > * > * > On Mon, Apr 16, 2012 at 12:14 AM, Sara Lee wrote: > >> thanks it is good but one change required--- when i add more records into >> my base sheet , and then refresh the pivot, that column % does not get >> updated automa

Re: $$Excel-Macros$$ Pivot table

, Maries wrote: > Hi, > > Try this formula, > > =B4/OFFSET($A$3,COUNTA(A:A)-1,2) > > Regards, > > MARIES. > > > On Sun, Apr 15, 2012 at 10:20 PM, Sara Lee wrote: > >> i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now >> i hav

$$Excel-Macros$$ Pivot table

i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now i have added a calculation column - right most column of the pivot... now when i delete the row of the data in sheet 1 say mumbai row, and then refresh the pivot... then the last column gets messed up showing div/0 error is

$$Excel-Macros$$ pls fill up this sheet with this pattern

i have two columns... zip code and the weights... i need to complete this sheet . i.e zip codes with starting from 1001 to 9 should come up in the sheet and for each zip code, those five weights should come up. please advise -- FORUM RULES (934+ members already BANNED for violation) 1) Us

$$Excel-Macros$$ formulas to get the week in the month and week of the year

hi i have a column in excel with the following date format-- ship date 20110801 20110823 20110903 I need another column adjacent to it which gives me the following results for every respective date above-- basically calcualate month and the week in that particular month in below format... Also t

$$Excel-Macros$$ access query to run into excel

hey is there a macro to run access query inside excel 2007. and excel data should refresh with any change in access query data. -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pr

Re: $$Excel-Macros$$ filter out the cells with a particular formula

Thanks Ashish... but how do i filter out column I such that i extract values similar to a ( which use 0) and not b. Say suppose column I has 2cell records ... ? On Thu, Aug 18, 2011 at 9:05 PM, ashish koul wrote: > see if it helps > > > On Fri, Aug 19, 2011 at 6:24 AM, Sar

$$Excel-Macros$$ filter out the cells with a particular formula

hi how do i filter out those cells in a column which has a particular vlookup formula in them... for example in one column in a table, i have vlook up fomula set up for the entire column ... some of the cells have vlook up( with true parameter) and some with (false parameter) How do i filter o

$$Excel-Macros$$ Re: assistance needed; open to pay a fees

> we can make few changes in it > > On Sun, Aug 7, 2011 at 10:47 PM, Sara Lee wrote: > >> Hi Ashish >> >> i think you got me wrong. user does not have to enter new values. he will >> select one of the values from the table i sent you. >> >> excel wil

Re: Fwd: $$Excel-Macros$$ urgent macro or template r eq

hello Haseeb thanks but 1) how would i change this if user has to enter five different inputs instead of just two... where should i change in formula? can you give a five input formula.. just assume any 3 more columns as inputs.. 2) also can i get a button where in user can click on the button t

Fwd: $$Excel-Macros$$ urgent macro or template r eq

i have a table in excel like below volumeships parameter savings 1x 20 T1200 2x 25 L 1500 3X 67 T 1400 i need a macro or a form or template where user is asked to enter volum

$$Excel-Macros$$ urgent macro or template r eq

i have a table in excel like below volumeships parameter savings 1x 20 T1200 2x 25 L 1500 3X 67 T 1400 i need a macro or a form or template where user is asked to enter volum

$$Excel-Macros$$ urgent help on the excel macro or dashboard

hello i have the table in the below format and 4 columns as below in excel volumelocation builds saving Now i want the user to be prompted for three values which will be volume, location, builds and the excel should give the user corresponding savings and the o/p shou

Re: $$Excel-Macros$$ urgent help needed.

This helps . Thank you much. On Sun, Jul 31, 2011 at 1:18 AM, ashish koul wrote: > Try this see if it helps > > > On Sun, Jul 31, 2011 at 12:18 AM, Sara Lee wrote: > >> hello >> >> i need to combine multiple excel files(15) into one excel file. Each file &g

Re: $$Excel-Macros$$ urgent macro required pls

w.Copy > > ThisWorkbook.Sheets(sh).Cells(Rows.Count, > 1).End(xlUp).Offset(1).PasteSpecial xlPasteValues > > End If > > End With > > Next sh > > ActiveWorkbook.Close False > > strFile = Dir >

Re: $$Excel-Macros$$ urgent macro required pls

i would like to add rows of respective sheets to be added below one another. i have never run a macro. Can you please give step by step instruction. On Sun, Jul 31, 2011 at 5:27 AM, Daniel wrote: > Hi, > > Do you want to add the rows of each sheet below the preceding ones, or do > you intend to

$$Excel-Macros$$ urgent help needed.

hello i need to combine multiple excel files(15) into one excel file. Each file has 2 sheets... R and S and data from both needs to consolidated into respective sheets. .. so i need a macro which can give one file with two sheets that consolidate data from all the files... All the files have sam