Re: $$Excel-Macros$$ Re: Retrieving data in horizontal form

Hi Sam solution provided by chilexcel is OK, but i want to go further in full automation using excel formulas. Thanks Amit On Mon, Sep 26, 2011 at 11:49 AM, Sam Mathai Chacko wrote: > Nicely done by Noorain. > > Shouldn't the solution provided by ChilExcel suffice? Pivot tables as it is > dyn

Re: $$Excel-Macros$$ Re: Retrieving data in horizontal form

thanks Noorain. On Mon, Sep 26, 2011 at 11:40 AM, NOORAIN ANSARI wrote: > Dear Amit, > > Please see attached sheet.. > > and use > * > =INDEX($B$4:$B$150,SMALL(IF($D$4:$D$150=1,ROW($B$4:$B$150),""),ROW(A3))-3) > =Offset($B$4,SMALL(IF($D$4:$D$150=1,ROW($B$4:$B$150),""),ROW(A3))-3,0)* > > -- > Than

Re: $$Excel-Macros$$ Re: Retrieving data in horizontal form

Nicely done by Noorain. Shouldn't the solution provided by ChilExcel suffice? Pivot tables as it is dynamic in nature, you just need to pass the source range. Regards, Sam Mathai Chacko (GL) On Mon, Sep 26, 2011 at 11:40 AM, NOORAIN ANSARI wrote: > Dear Amit, > > Please see attached sheet.. >

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Dear Vicky, See attached sheet if it help to u.. Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Sun, Sep 25, 2011 at 4:03 PM, vickey wrote: > can I ge

Re: $$Excel-Macros$$ Retrieving data in horizontal form

And take out the Grand Totals for rows and columns :) On Mon, Sep 26, 2011 at 10:37 AM, Amit Gandhi wrote: > thanks dear > > > On Sat, Sep 24, 2011 at 11:22 PM, ChilExcel wrote: > >> Please see attachment >> >> >> 2011/9/24 ashish koul >> >>> try this >>> >>> >>> cell f5 = SUMPRODUCT(($A$4:$A$

Re: $$Excel-Macros$$ Retrieving data in horizontal form

thanks dear On Sat, Sep 24, 2011 at 11:22 PM, ChilExcel wrote: > Please see attachment > > > 2011/9/24 ashish koul > >> try this >> >> >> cell f5 = SUMPRODUCT(($A$4:$A$150=F$3)*($B$4:$B$150=$E5)*($C$4:$C$150)) >> >> and drag the formula right >> >> >> On Sat, Sep 24, 2011 at 5:31 PM, Amit Gand

Re: $$Excel-Macros$$ Retrieving data in horizontal form

thanks. On Sat, Sep 24, 2011 at 8:53 PM, ashish koul wrote: > try this > > > cell f5 = SUMPRODUCT(($A$4:$A$150=F$3)*($B$4:$B$150=$E5)*($C$4:$C$150)) > > and drag the formula right > > > On Sat, Sep 24, 2011 at 5:31 PM, Amit Gandhi wrote: > >> Hi Folks >> >> I am finding some problem in excel d

$$Excel-Macros$$ Trap window activate event from personal macro workbook

Dear friends, I have created the following code to to trap "windowactivate" event and execute a code from personal macro workbook when the activate sheet name is "sap vs phy".But it works only when the excel is opened for first time.Kindly check the code & give necessary correc

Re: $$Excel-Macros$$ Message on Cell

Thanks to all. Ankit On Fri, Sep 23, 2011 at 4:46 PM, NOORAIN ANSARI wrote: > Dear Ankit, > > Please see attached sheet with solution. > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorain-ansari.blogspot.com

Re: $$Excel-Macros$$ Trap window activate event from personal macro workbook

Where is the code.?? On Mon, Sep 26, 2011 at 10:07 AM, aju chacko wrote: > Dear friends, > I have created the following code to to trap > "windowactivate" event and execute the code from personal macro > workbook when the activate sheet name is "sap vs phy".But it works

$$Excel-Macros$$ Trap window activate event from personal macro workbook

Dear friends, I have created the following code to to trap "windowactivate" event and execute the code from personal macro workbook when the activate sheet name is "sap vs phy".But it works only when the excel is opened for first time.Kindly check the code & give necessary cor

Re: $$Excel-Macros$$ Need Help

Simply deleting the un-needed rows and columns reduced the file by one half. Combining like sheets with an extra column and using autofilter would help. Etc. From: syed aliya raza hashim Sent: Sunday, September 25, 2011 1:32 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need Hel

Re: $$Excel-Macros$$ Need help with forecast formula

Thank you Sam for your suggestion but I still can't get the formula to work. In case it makes a difference, I'm using Excel 2002 with SP3 installed. What am I missing? Steve On 9/25/2011 2:48 PM, Sam Mathai Chacko wrote: Try =FORECAST(O8,$E$6:E7,$O$6:O7) in M8 and drag down HTH, Sam Ma

Re: $$Excel-Macros$$ Need help with forecast formula

Try =FORECAST(O8,$E$6:E7,$O$6:O7) in M8 and drag down HTH, Sam Mathai Chacko (GL) On Sun, Sep 25, 2011 at 11:12 PM, Steve Weaver wrote: > Each day I update the attached spreadsheet with with our previous days > shipments. I would like to use the daily ship data to forecast the total > monthly

Re: $$Excel-Macros$$ columns data need to be in reverse order

You are right! Shiva, would be still interested to know. Did you really want to exclude the character values from being reversed, or was it a miss from your side? Sam On Sun, Sep 25, 2011 at 10:54 PM, dguillett1 wrote: > You guys apparently missed a stated > ** *x* *y* *z* > === >

Re: $$Excel-Macros$$ columns data need to be in reverse order

You guys apparently missed a stated x y z === instead of zyx, so I offered 2 varieties Sub CustomSortSAS() 'converts to values Rows(3).Clear x = Application.Match(Application.Min(Rows(2)), Rows(2)) y = Application.Match(Application.Max(Rows(2)), Rows(2)) Cells(3, y - x + 2).Resiz

Re: $$Excel-Macros$$ columns data need to be in reverse order

Also, on second thought, the column count should be more sure than the value count. So *=INDEX($A$2:$M$2,COLUMNS(A2:$M$2))* would be better than *=INDEX($A$2:$M$2, COUNTA(A2:$M$2))* Regards, Sam Mathai Chacko (GL) On Sun, Sep 25, 2011 at 10:20 PM, Sam Mathai Chacko wrote: > Here's the working

Re: $$Excel-Macros$$ columns data need to be in reverse order

Here's the working example. Regards, S On Sun, Sep 25, 2011 at 10:18 PM, GoldenLance wrote: > This short and simple macro should reverse the range for you > > Sub RangeReverser() > >Dim rngCell As Range >Dim rngCells As Range >Dim lngCounter As Long >Const lngOffsetRow As Long

Re: $$Excel-Macros$$ columns data need to be in reverse order

This short and simple macro should reverse the range for you Sub RangeReverser() Dim rngCell As Range Dim rngCells As Range Dim lngCounter As Long Const lngOffsetRow As Long = 6 'How many rows below you want the reversed range Set rngCells = Range("A2:M2") For Each rngCel

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Another way without the need for the start/stop column. ARRAY formula entered with ctrl+shift+enter =MIN(IF(($A$2:$A$5000=$H$11)*($B$2:$B$5000=H$13),$C$2:$C$5000)) =Max(IF(($A$2:$A$5000=$H$11)*($B$2:$B$5000=H$13),$C$2:$C$5000)) From: Deep

$$Excel-Macros$$ Re: object required error message

Ensure this code is in the same parent sheet code module On Sep 24, 6:49 pm, Markkim wrote: > Hi > > The following code is a testing code before creating more codes.. > > when I run the code below, I'm getting an error message "Object > required".. then Comboschooltype.Text is highlighted.. > > I

Re: $$Excel-Macros$$ Max Value Required for Each half hour

Ahmed, use this in F5 in your original file, and drag down =SUMPRODUCT(MAX((A5:A1032>=VALUE(D5))*(A5:A1032 wrote: > I deleted your original but here is a sample > > From: Ahmed Honest > Sent: Sunday, September 25, 2011 9:20 AM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Max

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Sure. :-) On Sun, Sep 25, 2011 at 9:35 PM, vickey wrote: > Yes, great its working can I raise more query/issues in case I face > during the operation... > > > > -- > > -- > Some important links for ex

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Yes, great its working can I raise more query/issues in case I face during the operation... -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twit

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Yeah... B'coz one year back I'd to prepare a similar kind of template.. with BiomatriX data... :-) :-) On Sun, Sep 25, 2011 at 9:21 PM, dguillett1 wrote: > It appears that you properly understood the question. > > *From:* Deepak Pal Singh > *Sent:* Sunday, September 25, 2011 10:32 AM > *To:*

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

It appears that you properly understood the question. From: Deepak Pal Singh Sent: Sunday, September 25, 2011 10:32 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria Try this one... :-) On Sun, Sep 25, 2011 at 8:

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Try this one... :-) On Sun, Sep 25, 2011 at 8:36 PM, dguillett1 wrote: > I sent a solution to what I thought was your request. Now, you have an > entirely different question. Please give examples and clear logic on how to > get the result. > > *From:* vickey > *Sent:* Sunday, September 25,

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

I sent a solution to what I thought was your request. Now, you have an entirely different question. Please give examples and clear logic on how to get the result. From: vickey Sent: Sunday, September 25, 2011 9:40 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vlookup for

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Thanks a lot I got the idea but however I am trying somthing diffrent as per attached forward, I have used your suggested code in the field, but there is problem of updation of values if I enter employee code highlited in yellow as per sample file attached. Pleaes have a sample copy of the ide

Re: $$Excel-Macros$$ Max Value Required for Each half hour

I deleted your original but here is a sample From: Ahmed Honest Sent: Sunday, September 25, 2011 9:20 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Max Value Required for Each half hour Dear Dguilett, the formula is not working please can you see in the attachment and do

Re: $$Excel-Macros$$ Max Value Required for Each half hour

Dear Dguilett, the formula is not working please can you see in the attachment and do it for me pleas. Regards Ahmed Bawazir On Sun, Sep 25, 2011 at 5:12 PM, dguillett1 wrote: > If you are actually looking the highest value within the time frame, > use this array formula that must be

Re: $$Excel-Macros$$ Max Value Required for Each half hour

If you are actually looking the highest value within the time frame, use this array formula that must be entered using ctrl+shift+enter =MAX(IF(($A$5:$A$5000>C5)*($A$5:$A$5000http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Ex

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Assuming data in columns b:d and requests in cols f&g, This is an ARRAY formula that must be entered using ctrl+shift+enter =DAY(G2) & " ("&TEXT(MIN(IF(($B$2:$B$22=F2),($C$2:$C$22=G2)),$D$2:$D$22),"hh:mm:ss")& " | " &TEXT(MAX(IF(($B$2:$B$22=F2),($C$2:$C$22=G2)),$D$2:$D$22),"hh:mm:ss

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Just ask your vendor to publish data in your required format, he'll do it because your organization is paying him monthly maintenance... On Sun, Sep 25, 2011 at 4:03 PM, vickey wrote: > can I get values (time) of two same values in accedning order with two > Criteria. > for example I have emplo

$$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

can I get values (time) of two same values in accedning order with two Criteria. for example I have employee code / date & time now employee code repeates two or more times in a day with diffrent times. now what I want if I select parcticular date with particular empoyee ID then time of that