Re: $$Excel-Macros$$ Re: WEEKDAY function of excel - need character day

On 9/24/2012 11:52 AM India Time, _Vabz_ wrote: hi use following formula.. =TEXT(A1, "") Where cell A1 contains date. Superb, Vabs, Thanks a lot. It was the easiest way to do it. :-) Thanks again. Rgds//Vabs -- Rawat On Monday, September 24, 2012 11:46:07 AM UTC+5:30, Rawat wrot

Re: $$Excel-Macros$$ WEEKDAY function of excel - need character day

On 9/24/2012 11:58 AM India Time, _Swapnil Palande_ wrote: And if you don't want to use formula then use custom format of cell as "ddd" oh, that is even more easy. but, as the main date is visible in other cell, from which i want to show cdow in this cell, I guess the other formula sent by y

Re: $$Excel-Macros$$ Macro required for powerpoint...

my requirement is pending please help... On Mon, Sep 24, 2012 at 12:34 PM, Manoj Kumar wrote: > Dear Expert, > > i am making my presentation, i use macro to do same size of all picture > after i want all picture show in center of slide... > > > Please help me.. > > Sub PictureSizer() > For NumSli

$$Excel-Macros$$ Re: All time high Price

Hi Hilary please use this formula hope this will helpe u. =MAX(INDEX('Monthly End Prices'!C2:AK169,,MATCH(Sheet2!B1,'Monthly End Prices'!C1:AK1,0))) Regards Prince dueby On Thursday, September 20, 2012 9:28:51 PM UTC+5:30, hilary lomotey wrote: > > Hello Experts, > > i need a formula to cal

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

Provide a meaningful workbook. So that one could understand what's going on. Kris ExcelFox -- 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,

Re: $$Excel-Macros$$ Macro required for powerpoint...

I don't know exactly because I do not program powerpoint. This is an Excel Macros grou, after all. However it would be something like Picture.left = (slide.width - picture.width)/2 picture.top = (slide.height - picture.height)/2 It may need ActiveWindow.width rather than slide.width hth Regar

Re: $$Excel-Macros$$ Re: All time high Price *

thanks Prince, Effort appreciated On Mon, Sep 24, 2012 at 10:10 AM, Prince Dubey wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (prince141...@gmail.com) Add cleanup > rule

$$Excel-Macros$$ Vlookup Required

-- 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 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will n

Re: $$Excel-Macros$$ Please shorten the signature message

I'm not sure I agree. People... Don't... Read For the most part, when people sign up, they don't even bother to READ the rules. You could EASILY put some jargon in there that basically says that if you violate the rules, you owe a penalty, and they'd never even notice. At least with it on e

Re: $$Excel-Macros$$ Vlookup Required

is there a question here?   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ---

Re: $$Excel-Macros$$ Vlookup Required

Pual Sir, This is not question.Actually I need Vlookup solution for Data Arrange. So I post my query for solution to my excel group users. Regards Amar On Mon, Sep 24, 2012 at 5:23 PM, Paul Schreiner wrote: > is there a question here? > > > *Paul* > > - > *

Re: $$Excel-Macros$$ Vlookup Required

It is not possible to tell from the file what you want to achieve. Please describe the problem in the body of your email. Regards David Grugeon On 24 September 2012 21:51, amar takale wrote: > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM R

Re: $$Excel-Macros$$ Vlookup Required

Sorry, I must've jumped into the discussion mid-way. I didn't find any question or request, and the subject is a simple statement. I didn't realize that it was responding to something else, not an initial request for assistance. Sorry for the confusion.   Paul

Re: $$Excel-Macros$$ Vlookup Required

Hi Paul I don't think it is a question or an answer. I think it is a mindreading test. Regards David Grugeon On 24 September 2012 22:08, Paul Schreiner wrote: > Sorry, I must've jumped into the discussion mid-way. > I didn't find any question or request, and the subject is a simple > statement

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

Hi Put this code in Userform module. Dim wbkActive As Workbook Private Sub CommandButton1_Click() Dim FilePathAs String Dim FileNameAs String Dim wbkOpen As Workbook Dim LastRow As Long If wbkActive Is Nothing Then Set wbkActive = ThisWorkbook FilePath =

$$Excel-Macros$$ Help Need for Vlookup Solution

Dear Group Members, Please Solution Need! I need to apply Vlookup+Match formula to get value in sheet1 (C5 to F5) cell But it show same Output below. Sheet1 (C5 to F5) cell& Below cell is the result cell where I want to use the formula to get the output from sheet2. Best Regards,

Re: $$Excel-Macros$$ Help Need for Vlookup Solution

Pls find attached below file See Attached file. On Mon, Sep 24, 2012 at 6:43 PM, amar takale wrote: > Dear Group Members, > > > > Please Solution Need! > > > > I need to apply Vlookup+Match formula to get value in sheet1 (C5 to F5) > cell But it show same Output below. > > > > > > Sheet1 (C5 to

Re: $$Excel-Macros$$ Help Need for Vlookup Solution

Hi Amar Why do you need to use Vlookup and Match, rather than VBA? Is this homework? If so you will need to find out about array formulas to work out the solution. If not, can you explain a bit more about the application, how it will be used, who will use it (Just you or other people?) whether

RE: $$Excel-Macros$$ Sum() formula considering multiple values!

Dear, Ashish & David thank u friends both of u. Regards, Muneer, CC -- 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 Pl

RE: $$Excel-Macros$$ Sum() formula considering multiple values!

=SUMPRODUCT(--($A$3:$A$85=G5),--($B$3:$B$85=H5),--($C$3:$C$85=I5)*($D$3: $D$85)) [your's] =SUMPRODUCT(--($A$3:$A$85=F5),--($B$3:$B$85=G5),--($C$3:$C$85=H5)*($D$3: $D$85)) [mine] Small change is made. The only difference as per the attachment, is F5 in place of G5 and as follows for all the

$$Excel-Macros$$ Pyramid Chart

Hi All, Just want to know is there any way in excel to prepare Pyramid chart like below. If Yes please let me know how to prepare. [cid:image001.jpg@01CD9A8E.265E9A20] Regards, Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EPI

Re: $$Excel-Macros$$ Re: Calculated Field not Working

hi Vabz, Still i'm not able to find the difference.Though i have also used the same formula in calculated field in my sheet. Plz let me know...so that i would be able to help it in other sheets. On Thursday, September 20, 2012 6:59:33 PM UTC+5:30, Vabz wrote: > Hi, > > Just use formula insert

$$Excel-Macros$$ OFF TOPIC: Please suggest a similar active group for MS WORD Macros?

Sorry for OFF TOPIC post. Please suggest to me a similar active group for MS WORD Macros issues that I have to ask? Thanks. -- Rawat -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise,

Re: $$Excel-Macros$$ OFF TOPIC: Please suggest a similar active group for MS WORD Macros?

http://www.excelfox.com/forum/f5/ Sam Mathai Chacko On Mon, Sep 24, 2012 at 10:30 PM, V S Rawat g wrote: > Sorry for OFF TOPIC post. > > Please suggest to me a similar active group for MS WORD Macros issues that > I have to ask? > > Thanks. > -- > Rawat > > -- > Join official facebook page of t

Re: $$Excel-Macros$$ OFF TOPIC: Please suggest a similar active group for MS WORD Macros?

On 9/24/2012 11:24 PM India Time, _NOORAIN ANSARI_ wrote: Dear VS, You can also learn MS Word macro through attached tutorials. wow. good. thanks. I can study it offline also. :-) -- Rawat On Mon, Sep 24, 2012 at 10:30 PM, V S Rawat g mailto:vsra...@gmail.com>> wrote: Sorry for OFF TO

Re: $$Excel-Macros$$ OFF TOPIC: Please suggest a similar active group for MS WORD Macros?

On 9/24/2012 11:09 PM India Time, _Sam Mathai Chacko_ wrote: http://www.excelfox.com/forum/f5/ Joined. Thanks. Any mailing list for that, just like this one is for excel? Sam Mathai Chacko -- Rawat On Mon, Sep 24, 2012 at 10:30 PM, V S Rawat g mailto:vsra...@gmail.com>> wrote: So

Re: $$Excel-Macros$$ OFF TOPIC: Please suggest a similar active group for MS WORD Macros?

Yeah, when you go to a particular forum in the site, like Word Help, on the top of the table, you'll find Forum Tools > Subscribe to this Forum Regards, Sam Mathai Chacko On Tue, Sep 25, 2012 at 1:09 AM, V S Rawat g wrote: > On 9/24/2012 11:09 PM India Time, _Sam Mathai Chacko_ wrote: > > http

Re: $$Excel-Macros$$ Sum() formula considering multiple values!

Hi Muneer, could you please share your understanding for my benefit. Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: "Mohammed Muneer" Sender: excel-macros@googlegroups.com Date: Mon, 24 Sep 2012 17:19:12 To: Reply-To: excel-macros@googlegroups.com Subject:

$$Excel-Macros$$ Same Excel file and diffrent format

I am sharing a spread sheet in excel 2007 (.xlsx) format with one my colleague and it is automatically getting formatted at his end. Does anybody has any idea about that? Thanks for your help in advance! Avinash Daga -- Join official facebook page of this forum @ https://www.facebook.com/discus

Re: $$Excel-Macros$$ Same Excel file and diffrent format

You are using Excel 2007 Which version of Windows or are you on a Mac?. Is your colleague also using the same versions of Excel and operating system? What format changes are happening? Some formats like date formats depend on the local machine settings. Others (such as the default color set)

Re: $$Excel-Macros$$ OFF TOPIC: Please suggest a similar active group for MS WORD Macros?

http://tech.groups.yahoo.com/group/Word_VBA/ Regards David Grugeon On 25 September 2012 03:00, V S Rawat g wrote: > Sorry for OFF TOPIC post. > > Please suggest to me a similar active group for MS WORD Macros issues that I > have to ask? > > Thanks. > -- > Rawat > > -- > Join official facebook

$$Excel-Macros$$ Rank the bars in the chart

Hi, Can we rank the bar as per the value in the chart, i know that data can be sorted but i dont need, is there any ways show bar A,C B, & D. Please help. Regards, Vin -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNE

RE: $$Excel-Macros$$ Sum() formula considering multiple values!

Dear Joseph, I haven't done any research on this; I will give u simple idea about. I don't have perfect understanding (but I can say, there are 2 arguments that form one entity here-"come under single bracket". Broadly that might be the reason we use the (--) like this. sorry not now w

Re: $$Excel-Macros$$ Sum() formula considering multiple values!

Hi For more understanding on sumproduct with real life examples please refer following link: Link Rgds//Vabs On Tuesday, September 25, 2012 1:58:32 AM UTC+5:30, Joseph wrote: > > Hi Muneer, could you please share your understandi

Re: $$Excel-Macros$$ Sum() formula considering multiple values!

pl use =SUMPRODUCT((B3:B85=H8)*(C3:C85=I8)*(D3:D85=J8)*(E3:E85)) Regards Gawli Anil On Tue, Sep 25, 2012 at 9:58 AM, Vabz wrote: > Hi > > For more understanding on sumproduct with real life examples please refer > following link: > > Link

$$Excel-Macros$$ Serial Number with Duplicate Values

Dear All, I need your assistance to create Serial Numbers (Applicant Number) of Duplicate Values. Below is the numbers & result I want. I'v also attached a test sheet. Please suggest your ideas & logics. *Number S.No.(App. No.)* 10453 = 1 10453 = 2 10453 = 3 25623 = 1 5882 = 1 5856 =

Re: $$Excel-Macros$$ Hiiiiiiiiiii

Excellent Creativity Amit. On Tue, Sep 25, 2012 at 10:41 AM, Amit Desai (MERU) wrote: > To all my dear friends, > > ** ** > > Nice Excel filewith ABCD on Friendship... > > Please see the attachment and click on flowers. > > Best Regards, > > Amit > >

RE: $$Excel-Macros$$ Serial Number with Duplicate Values

Try this 10453 =COUNTIF($A$1:A1,A1) 10453 =COUNTIF($A$1:A2,A2) 10453 =COUNTIF($A$1:A3,A3) 25623 =COUNTIF($A$1:A4,A4) 5882 =COUNTIF($A$1:A5,A5) 5856 =COUNTIF($A$1:A6,A6) 2556 =COUNTIF($A$1:A7,A7) 2556 =COUNTIF($A$1:A8,A8) From: excel-macros@googlegroups.com [

RE: $$Excel-Macros$$ Hiiiiiiiiiii

Well thanks.. thats not mine.. it was aforwarded file, which I think so good for group. Infact I have an inspiration to learn this.. Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 25 September 2012 11:39 To: excel

Re: $$Excel-Macros$$ Help Need for Vlookup Solution

Dear Amar You can use sumproduct for your query Rgds On Monday, September 24, 2012 7:01:25 PM UTC+5:30, amar takale wrote: > > Pls find attached below file > > See Attached file. > > On Mon, Sep 24, 2012 at 6:43 PM, amar takale > > wrote: > >> Dear Group Members, >> >> >> >> Please Solution

Re: $$Excel-Macros$$ OFF TOPIC: Please suggest a similar active group for MS WORD Macros?

On 9/25/2012 4:36 AM India Time, _David Grugeon_ wrote: http://tech.groups.yahoo.com/group/Word_VBA/ Regards David Grugeon Thanks, David. Joined. -- Rawat. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for v

Re: $$Excel-Macros$$ OFF TOPIC: Please suggest a similar active group for MS WORD Macros?

On 9/25/2012 1:14 AM India Time, _Sam Mathai Chacko_ wrote: Yeah, when you go to a particular forum in the site, like Word Help, on the top of the table, you'll find Forum Tools > Subscribe to this Forum not finding "Forum Tools > Subscribe to this Forum" option. Thanks. -- Rawat Regards,