$$Excel-Macros$$ Highlight cell values in other areas based on two colimns

Hello all! You guys have worked miracles before, so I am asking for another. I want to look at the value in Column H, if it is found in Column C and the Value of the first character is equal to either A, B or C, then I would like to highlight it in Column H and bring the term in Column I.

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

$$Excel-Macros$$ Macro and vb

I have a lot of work for dashboards and excel charting based vBA Can pay weekly or by task in hours. If any one who is an expert in VBA is interested, Pla email me only. We can talk abt tasks, hours in commitment, pay etc Thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

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$$ Pivot Table - Required percentile values

ng VBA? > > Regards, > Anoop > Sr. Developer > > > > On Tue, Nov 13, 2012 at 10:55 AM, Sheyn Lee wrote: > >> Dear Anoop, >> I need the values from a pivot table use the formula >> '=PERCENTILE(C2:C6,0.5)' >> >> Best Regrds, >> S.

$$Excel-Macros$$ Re: Your advice in promoting a new information sharing initiative

://www.sharedlist.org/ and send me your impression. Regards, Amir On Thursday, November 15, 2012 11:26:56 AM UTC+2, Prince wrote: > > Hi Amir, > > I think you should do SEO (Search Engine Optimaization) of your web site. > > Regards > Prince > > > On Tuesday, November 13, 2012

$$Excel-Macros$$ Your advice in promoting a new information sharing initiative

Hello all, My name is Amir Lee, and I am a great supporter of the Open Data and Freedom Of Information concepts. I looked at the contents raised in this group and thought you would be interested in encountering the new information sharing initiative. Since data and information are relevant to

Re: $$Excel-Macros$$ Pivot Table - Required percentile values

Dear Anoop, I need the values from a pivot table use the formula '=PERCENTILE(C2:C6,0.5)' Best Regrds, S. On Mon, Nov 12, 2012 at 12:56 PM, Anoop K Sharma wrote: > Sheyn, Please elaborate your query. > > Regards, > Anoop > > > On Sat, Nov 10, 2012 at 2:29 PM,

$$Excel-Macros$$ Pivot Table - Required percentile values

Dear MS Excel Group, Can we get percentile values from a pivot table. Best Regards, Sheyn -- 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 thread titles, li

Re: $$Excel-Macros$$ Obtain percentile values through pivot table

*Re-send* > Dear Excel group members, >>> Is there any way that I can get percentile values from a pivot table. >>> Appreciate your help. >>> S >>> >> -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation)

Re: $$Excel-Macros$$ Obtain percentile values through pivot table

please find the attached sample file. On Wed, Oct 31, 2012 at 2:29 PM, Shaik Waheed wrote: > yeah sure, can u share ur sample file > > > On Wed, Oct 31, 2012 at 2:33 PM, Sheyn Lee wrote: > >> Dear Excel group members, >> Is there any way that I can get percentil

$$Excel-Macros$$ Obtain percentile values through pivot table

Dear Excel group members, Is there any way that I can get percentile values from a pivot table. Appreciate your help. S -- 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

Re: $$Excel-Macros$$ Macro for convert to Million

Yes Sent from my iPhone On Oct 28, 2012, at 1:33 PM, "Asa Rossoff" wrote: > for -- 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 thread titles, like Ple

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

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

Yes please needs that urgently On Sep 7, 2012, at 8:46 AM, "Rajan_Verma" wrote: > Will Suggest you a Code ,if you need? > > > Regards > Rajan verma > +91 7838100659 [IM-Gtalk] > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.co

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

to enter input values pls advise thanks On Sun, Aug 7, 2011 at 7:54 PM, Haseeb Avarakkan wrote: > Hello Lee, > > See the attached with Array Formula. > > HTH > Haseeb > > For free MS product help, visit; > http://www.e

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

ou intend to consolidate the sheets like you'll do it with Data, > Consolidate menus ? > > Regards. > > Daniel > > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > De > la part de lee > Envoyé : sam

$$Excel-Macros$$ urgent macro required pls

hello i have 15 files in one folder. i need to combine two sheets called as maps and shipment of all the 15 files into one consolidated file with 2 sheets( with respective data). Structure and columns are same in sheets for all the files. Can you pls give a macro.. also can you please let m e

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

Re: RE: $$Excel-Macros$$ adding adjacent (contagious) cells only

Nice one Dave! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

$$Excel-Macros$$ Re: adding adjacent (contagious) cells only

;),0,IF(AND(M2="no",N2="yes"),1,0))+IF(AND(N2="yes",O2="yes"),0,IF(AND(N2="no",O2="yes"),1,0))+IF(AND(O2="yes",P2="yes"),0,IF(AND(O2="no",P2="yes"),1,0))+IF(AND(P2="yes",Q2="yes"),0

$$Excel-Macros$$ forecasting

does anybody have an experience in forecasting in retail industry? Need some help -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Jo

$$Excel-Macros$$ trying to hire someone very very proficient in excel

i need help on a project to convert complex spreadsheets into a more efficient model. pls advise if anybody available ASAP. We could discuss the payment offline. Thanks -- -- Some important links for excel users: 1. F

$$Excel-Macros$$

Dear All, Is there any option that when I select a cell in the sheet, the whole row corresponding to that cell is highlighted. In the attached example I have selected cell C7. Required: the whole row 7 should be highligted. Thanks and regards, Sheyn --~--~-~--~~~---~--

Re: Fwd: $$Excel-Macros$$ Need earliest record based in unique identifier

Here is the link to the file. www.progressivetel.com\~radney4\testdata.xls Thanks! Lee On Jul 24, 12:40 pm, vivek agrawal wrote: > Hi > > i would suggest you send the file so that the workaround can be figured > out... > > Thanks and Regards, > Vivek Agrawal > Sk

$$Excel-Macros$$ Need earliest record based in unique identifier

to see the earliest of the two records based on the identifier in column E. Thanks! Lee --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video