$$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

$$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

$$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 @

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 rajanverma1...@gmail.comwrote: 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

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 rajanverma1...@gmail.comwrote: 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 lee.sar...@gmail.com wrote: This is already present

$$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,

$$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 clicking

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 prince141...@gmail.comwrote: Hi Rajan, I like your solution, But i feel you have to modify it so that it can work for the dynamic name

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

$$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

$$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 lee.sar...@gmail.com 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 value in col

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

www.excelmacroworld.blogspot.com On Mon, May 7, 2012 at 9:39 AM, Sara Lee lee.sar...@gmail.com 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 value in col h sheet 2, i need nearest 3

$$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

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

12: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 lee.sar...@gmail.com wrote: Attached is the file with 2 sheets - input and output

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

is required. For Load 0241 - there are 6 values so the formula should return 6. On Fri, Apr 27, 2012 at 1:09 PM, Darwin Chan darwin.chankaw...@gmail.comwrote: Hi Sara, Seems formula COUNTIF can solve your problem simply. 2012/4/27 Sara Lee lee.sar...@gmail.com hi i have data

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 darwin.chankaw...@gmail.comwrote: 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 lee.sar...@gmail.com

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 anil.kan...@gmail.com wrote: you can use =SUMPRODUCT(--($A$2:$A$23=AB2)) On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee lee.sar...@gmail.com wrote: yes i need count of distinct

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

, Apr 27, 2012 at 2:52 PM, Darwin Chan darwin.chankaw...@gmail.comwrote: See if you understand array formula. http://www.excelfunctions.net/Excel-Array-Formulas.html 2012/4/27 Sara Lee lee.sar...@gmail.com thee are two similar rows with same load no---this is not working On Fri, Apr 27

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 waheedb...@gmail.com wrote: Hi Sara, PFA, Hope this is what you are looking for... On Fri, Apr 27, 2012 at 4:33 PM, 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,

$$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

Re: $$Excel-Macros$$ Pivot table

, Maries talk2mar...@gmail.com 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 lee.sar...@gmail.com wrote: i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now i have added a calculation

Re: $$Excel-Macros$$ Pivot table

, MARIES. * * On Mon, Apr 16, 2012 at 12:14 AM, Sara Lee lee.sar...@gmail.com 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 automatically;; also when i delete records, that column

$$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)

$$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

$$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

$$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

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 koul.ash...@gmail.com wrote: see if it helps On Fri, Aug 19, 2011 at 6:24 AM, Sara

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

: try this we can make few changes in it On Sun, Aug 7, 2011 at 10:47 PM, Sara Lee lee.sar...@gmail.com 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 will ask for the volume , the user

$$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

$$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

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

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

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 dcolarde...@free.fr wrote: Hi, Do you want to add the rows of each sheet below the preceding ones, or do

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

:* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *De la part de* Sara Lee *Envoyé :* dimanche 31 juillet 2011 14:03 *À :* excel-macros@googlegroups.com *Objet :* Re: $$Excel-Macros$$ urgent macro required pls ** ** i would like to add rows of respective sheets to be added