date:20110925

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

2011-09-25 Thread vickey

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 particuar date or day should reflect in acceding order in 
single cell.
 
EMPCodeDateTime
525/09/11 09:15:30
525/09/11 12:30:00
525/09/11 18:30:45
 
 
taking above table as an example I want result in following format.
 
EmpCode - 5
Date - 25/09/11
 
 25 (09:15:30 | 18:30:45)
 
means start time and end time for the day or date should reflect.
 
the idea behind is to creat a caleder for attendence with time for employee, 
on the basis of data which is imported from biomatix system.
 
 
kindly help me out
 
vikas daiya
 
 
 
 
 
 
 

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread Deepak Pal Singh

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 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 particuar date or day should reflect in acceding order in
> single cell.
>
> EMPCodeDateTime
> 525/09/11 09:15:30
> 525/09/11 12:30:00
> 525/09/11 18:30:45
>
>
> taking above table as an example I want result in following format.
>
> EmpCode - 5
> Date - 25/09/11
>
>  25 (09:15:30 | 18:30:45)
>
> means start time and end time for the day or date should reflect.
>
> the idea behind is to creat a caleder for attendence with time for
> employee, on the basis of data which is imported from biomatix system.
>
>
> kindly help me out
>
> vikas daiya
>
>
>
>
>
>
>
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread dguillett1

  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")&")" 


From: vickey 
Sent: Sunday, September 25, 2011 5:33 AM
To: excel-macros@googlegroups.com 
Subject: $$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 particuar date or day should reflect in acceding order in single cell.

EMPCodeDateTime
525/09/11 09:15:30
525/09/11 12:30:00
525/09/11 18:30:45


taking above table as an example I want result in following format.

EmpCode - 5
Date - 25/09/11

 25 (09:15:30 | 18:30:45)

means start time and end time for the day or date should reflect.

the idea behind is to creat a caleder for attendence with time for employee, on 
the basis of data which is imported from biomatix system.


kindly help me out

vikas daiya



 



-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread dguillett1

  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. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread Ahmed Honest

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 entered using ctrl+shift+enter
>
> *=MAX(IF(($A$5:$A$5000>C5)*($A$5:$A$5000
>  *From:* Ahmed Honest 
> *Sent:* Sunday, September 25, 2011 8:02 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Max Value Required for Each half hour
>
>  Dear Group,
>
> Please find attach and i Need Max Value for each half hour. For further
> clairifaction please revert
>
> --
>  Ahmed Bawazir
> *احمد باوزير*
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Ahmed Bawazir
*احمد باوزير*

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread dguillett1

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 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 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. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com
   
  <><><><><><><><><><><><><><><><><><><><><><>
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel

  -- 
  
--
  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
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com
   
  <><><><><><><><><><><><><><><><><><><><><><>
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel




-- 

Ahmed Bawazir
احمد باوزير

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


maxperhalfhour.xls
Description: MS-Excel spreadsheet

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

2011-09-25 Thread vickey

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 idea which I want to execute.
 
Thanks again.
 
 
Vikas | 
 

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


sample.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

2011-09-25 Thread dguillett1

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 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 idea which I want to execute.

Thanks again.


Vikas | 

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread Deepak Pal Singh

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, 2011 9:40 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* 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 idea which I want to execute.
>
> Thanks again.
>
>
> Vikas |
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


sample.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

2011-09-25 Thread dguillett1

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: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, 2011 9:40 AM
  To: excel-macros@googlegroups.com 
  Subject: 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 idea which I want to execute.

  Thanks again.


  Vikas | 

  -- 
  
--
  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
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com
   
  <><><><><><><><><><><><><><><><><><><><><><>
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel

  -- 
  
--
  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
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com
   
  <><><><><><><><><><><><><><><><><><><><><><>
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel


-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread Deepak Pal Singh

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:* 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: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, 2011 9:40 AM
>>  *To:* excel-macros@googlegroups.com
>> *Subject:* 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 idea which I want to execute.
>>
>> Thanks again.
>>
>>
>> Vikas |
>>
>> --
>>
>> --
>> 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
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>  --
>>
>> --
>> 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
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread vickey

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://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread Deepak Pal Singh

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 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread GoldenLance

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 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 entered using ctrl+shift+enter
>
>         =MAX(IF(($A$5:$A$5000>C5)*($A$5:$A$5000
>   From: Ahmed Honest
>   Sent: Sunday, September 25, 2011 8:02 AM
>   To: excel-macros@googlegroups.com
>   Subject: $$Excel-Macros$$ Max Value Required for Each half hour
>
>   Dear Group,
>
>   Please find attach and i Need Max Value for each half hour. For further 
> clairifaction please revert
>
>   --
>
>   Ahmed Bawazir
>   احمد باوزير
>
>   --
>   
> --
>   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
>   3. Excel tutorials athttp://www.excel-macros.blogspot.com
>   4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>   5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
>   To post to this group, send email to excel-macros@googlegroups.com
>
>   <><><><><><><><><><><><><><><><><><><><><><>
>   Like our page on facebook , Just follow below link
>  http://www.facebook.com/discussexcel
>
>   --
>   
> --
>   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
>   3. Excel tutorials athttp://www.excel-macros.blogspot.com
>   4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>   5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
>   To post to this group, send email to excel-macros@googlegroups.com
>
>   <><><><><><><><><><><><><><><><><><><><><><>
>   Like our page on facebook , Just follow below link
>  http://www.facebook.com/discussexcel
>
> --
>
> Ahmed Bawazir
> احمد باوزير
>
> --
> --
> 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
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel
>
>  maxperhalfhour.xls
> 32KViewDownload

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread GoldenLance

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 created a combo box (dropdown) and renamed it as ComboSchooltype
>
> I thought it might has to do with name so.. tried it without any
> change...  still getting an error message.
>
> What am I mssing..??  thank in advance
>
> Sub ComboSchooltype_Change()
>
> Select Case ComboSchooltype.Text
>     Case "All"
>        MsgBox ("All")
>     Case "Catholic"
>        MsgBox ("Cathloic")
>
> End Select
>
> End Sub

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread dguillett1

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: Deepak Pal Singh 
Sent: Sunday, September 25, 2011 11:09 AM
To: excel-macros@googlegroups.com 
Subject: 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 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
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com
   
  <><><><><><><><><><><><><><><><><><><><><><>
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel


-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread GoldenLance

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 rngCell In rngCells
rngCell.Copy rngCell.Offset(lngOffsetRow,
(rngCells.Cells.Count - ((lngCounter * 2) + 1)))
lngCounter = lngCounter + 1
Next rngCell

End Sub

OR, you could use a formula to reverse it too

Use =INDEX($A$2:$M$2,COUNTA(A2:$M$2)) and drag to the right

Regards

Sam Mathai Chacko (GL)

On Sep 23, 8:54 pm, "dguillett1"  wrote:
> Try in a macro enabled workbook (.xls or .xlsm)
>
> 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).Resize(, x - 1).Value = _
> Cells(2, 1).Resize(, x - 1).Value
>
> Cells(3, 1).Resize(, y - x + 1).Value = _
> Cells(2, x).Resize(, y - x + 1).Value
>
> Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1), Order1:=xlDescending, 
> _
> Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight
> End Sub
> ‘or
> Sub CustomSortSAS1() 'copies
> x = Application.Match(Application.Min(Rows(2)), Rows(2))
> y = Application.Match(Application.Max(Rows(2)), Rows(2))
> Cells(2, 1).Resize(, x - 1).Copy Cells(3, y - x + 2)
> Cells(2, x).Resize(, y - x + 1).Copy Cells(3, 1)
> Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1), Order1:=xlDescending, 
> _
> Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight
> End Sub
>
> From: shivashankar katageri
> Sent: Friday, September 23, 2011 1:21 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ columns data need to be in reverse order
>
> Dear all,
>
> Any body help in this matter,please have luk of the attachement,
>
> I have lot of columns data,Now I want all the data with formula in reverse 
> manner
>
> --
>
> Thanks & Regards
>
> Shivashankar.C.Katageri
>
> 9945800300
>
> --
> --
> 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
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread Sam Mathai Chacko

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 = 6 'How many rows below you want the
> reversed range
>Set rngCells = Range("A2:M2")
>
>For Each rngCell In rngCells
>rngCell.Copy rngCell.Offset(lngOffsetRow,
> (rngCells.Cells.Count - ((lngCounter * 2) + 1)))
>lngCounter = lngCounter + 1
>Next rngCell
>
> End Sub
>
> OR, you could use a formula to reverse it too
>
> Use =INDEX($A$2:$M$2,COUNTA(A2:$M$2)) and drag to the right
>
> Regards
>
> Sam Mathai Chacko (GL)
>
> On Sep 23, 8:54 pm, "dguillett1"  wrote:
> > Try in a macro enabled workbook (.xls or .xlsm)
> >
> > 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).Resize(, x - 1).Value = _
> > Cells(2, 1).Resize(, x - 1).Value
> >
> > Cells(3, 1).Resize(, y - x + 1).Value = _
> > Cells(2, x).Resize(, y - x + 1).Value
> >
> > Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1),
> Order1:=xlDescending, _
> > Header:=xlGuess, OrderCustom:=1, MatchCase:=False,
> Orientation:=xlLeftToRight
> > End Sub
> > ‘or
> > Sub CustomSortSAS1() 'copies
> > x = Application.Match(Application.Min(Rows(2)), Rows(2))
> > y = Application.Match(Application.Max(Rows(2)), Rows(2))
> > Cells(2, 1).Resize(, x - 1).Copy Cells(3, y - x + 2)
> > Cells(2, x).Resize(, y - x + 1).Copy Cells(3, 1)
> > Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1),
> Order1:=xlDescending, _
> > Header:=xlGuess, OrderCustom:=1, MatchCase:=False,
> Orientation:=xlLeftToRight
> > End Sub
> >
> > From: shivashankar katageri
> > Sent: Friday, September 23, 2011 1:21 AM
> > To: excel-macros@googlegroups.com
> > Subject: $$Excel-Macros$$ columns data need to be in reverse order
> >
> > Dear all,
> >
> > Any body help in this matter,please have luk of the attachement,
> >
> > I have lot of columns data,Now I want all the data with formula in
> reverse manner
> >
> > --
> >
> > Thanks & Regards
> >
> > Shivashankar.C.Katageri
> >
> > 9945800300
> >
> > --
> >
> --
> > 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
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below linkhttp://
> www.facebook.com/discussexcel
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Sam Mathai Chacko

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


RangeReverser.xlsm
Description: Binary data

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

2011-09-25 Thread Sam Mathai Chacko

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 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 = 6 'How many rows below you want the
>> reversed range
>>Set rngCells = Range("A2:M2")
>>
>>For Each rngCell In rngCells
>>rngCell.Copy rngCell.Offset(lngOffsetRow,
>> (rngCells.Cells.Count - ((lngCounter * 2) + 1)))
>>lngCounter = lngCounter + 1
>>Next rngCell
>>
>> End Sub
>>
>> OR, you could use a formula to reverse it too
>>
>> Use =INDEX($A$2:$M$2,COUNTA(A2:$M$2)) and drag to the right
>>
>> Regards
>>
>> Sam Mathai Chacko (GL)
>>
>> On Sep 23, 8:54 pm, "dguillett1"  wrote:
>> > Try in a macro enabled workbook (.xls or .xlsm)
>> >
>> > 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).Resize(, x - 1).Value = _
>> > Cells(2, 1).Resize(, x - 1).Value
>> >
>> > Cells(3, 1).Resize(, y - x + 1).Value = _
>> > Cells(2, x).Resize(, y - x + 1).Value
>> >
>> > Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1),
>> Order1:=xlDescending, _
>> > Header:=xlGuess, OrderCustom:=1, MatchCase:=False,
>> Orientation:=xlLeftToRight
>> > End Sub
>> > ‘or
>> > Sub CustomSortSAS1() 'copies
>> > x = Application.Match(Application.Min(Rows(2)), Rows(2))
>> > y = Application.Match(Application.Max(Rows(2)), Rows(2))
>> > Cells(2, 1).Resize(, x - 1).Copy Cells(3, y - x + 2)
>> > Cells(2, x).Resize(, y - x + 1).Copy Cells(3, 1)
>> > Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1),
>> Order1:=xlDescending, _
>> > Header:=xlGuess, OrderCustom:=1, MatchCase:=False,
>> Orientation:=xlLeftToRight
>> > End Sub
>> >
>> > From: shivashankar katageri
>> > Sent: Friday, September 23, 2011 1:21 AM
>> > To: excel-macros@googlegroups.com
>> > Subject: $$Excel-Macros$$ columns data need to be in reverse order
>> >
>> > Dear all,
>> >
>> > Any body help in this matter,please have luk of the attachement,
>> >
>> > I have lot of columns data,Now I want all the data with formula in
>> reverse manner
>> >
>> > --
>> >
>> > Thanks & Regards
>> >
>> > Shivashankar.C.Katageri
>> >
>> > 9945800300
>> >
>> > --
>> >
>> --
>> > 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
>> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
>> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>> >
>> > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > Like our page on facebook , Just follow below linkhttp://
>> www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> 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
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Sam Mathai Chacko
>



-- 
Sam Mathai Chacko

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread dguillett1

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).Resize(, x - 1).Value = _
Cells(2, 1).Resize(, x - 1).Value

Cells(3, 1).Resize(, y - x + 1).Value = _
Cells(2, x).Resize(, y - x + 1).Value

Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1), Order1:=xlDescending, _
Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight
End Sub
Sub CustomSortSAS1() 'copies
x = Application.Match(Application.Min(Rows(2)), Rows(2))
y = Application.Match(Application.Max(Rows(2)), Rows(2))
Cells(2, 1).Resize(, x - 1).Copy Cells(3, y - x + 2)
Cells(2, x).Resize(, y - x + 1).Copy Cells(3, 1)
Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1), Order1:=xlDescending, _
Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight
End Sub

From: Sam Mathai Chacko 
Sent: Sunday, September 25, 2011 11:53 AM
To: MS EXCEL AND VBA MACROS 
Subject: 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 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 = 6 'How many rows below you want the
reversed range
   Set rngCells = Range("A2:M2")

   For Each rngCell In rngCells
   rngCell.Copy rngCell.Offset(lngOffsetRow,
(rngCells.Cells.Count - ((lngCounter * 2) + 1)))
   lngCounter = lngCounter + 1
   Next rngCell

End Sub

OR, you could use a formula to reverse it too

Use =INDEX($A$2:$M$2,COUNTA(A2:$M$2)) and drag to the right

Regards

Sam Mathai Chacko (GL)


On Sep 23, 8:54 pm, "dguillett1"  wrote:
> Try in a macro enabled workbook (.xls or .xlsm)
>
> 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).Resize(, x - 1).Value = _
> Cells(2, 1).Resize(, x - 1).Value
>
> Cells(3, 1).Resize(, y - x + 1).Value = _
> Cells(2, x).Resize(, y - x + 1).Value
>
> Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1), 
Order1:=xlDescending, _
> Header:=xlGuess, OrderCustom:=1, MatchCase:=False, 
Orientation:=xlLeftToRight
> End Sub
> ‘or
> Sub CustomSortSAS1() 'copies
> x = Application.Match(Application.Min(Rows(2)), Rows(2))
> y = Application.Match(Application.Max(Rows(2)), Rows(2))
> Cells(2, 1).Resize(, x - 1).Copy Cells(3, y - x + 2)
> Cells(2, x).Resize(, y - x + 1).Copy Cells(3, 1)
> Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1), 
Order1:=xlDescending, _
> Header:=xlGuess, OrderCustom:=1, MatchCase:=False, 
Orientation:=xlLeftToRight
> End Sub
>
> From: shivashankar katageri
> Sent: Friday, September 23, 2011 1:21 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ columns data need to be in reverse order
>
> Dear all,
>
> Any body help in this matter,please have luk of the attachement,
>
> I have lot of columns data,Now I want all the data with formula in 
reverse manner
>
> --
>
> Thanks & Regards
>
> Shivashankar.C.Katageri
>
> 9945800300
>
> --
> 
--
> 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

> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com

>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>

> Like our page on facebook , Just follow below 
linkhttp://www.facebook.com/discussexcel


--

--
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
3. Excel tutorials at http://www.excel-macros.b

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

2011-09-25 Thread Sam Mathai Chacko

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*
>  ===
> 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).Resize(, x - 1).Value = _
> Cells(2, 1).Resize(, x - 1).Value
>
> Cells(3, 1).Resize(, y - x + 1).Value = _
> Cells(2, x).Resize(, y - x + 1).Value
>
> Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1),
> Order1:=xlDescending, _
> Header:=xlGuess, OrderCustom:=1, MatchCase:=False,
> Orientation:=xlLeftToRight
> End Sub
> Sub CustomSortSAS1() 'copies
> x = Application.Match(Application.Min(Rows(2)), Rows(2))
> y = Application.Match(Application.Max(Rows(2)), Rows(2))
> Cells(2, 1).Resize(, x - 1).Copy Cells(3, y - x + 2)
> Cells(2, x).Resize(, y - x + 1).Copy Cells(3, 1)
> Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1),
> Order1:=xlDescending, _
> Header:=xlGuess, OrderCustom:=1, MatchCase:=False,
> Orientation:=xlLeftToRight
> End Sub
>
>  *From:* Sam Mathai Chacko 
> *Sent:* Sunday, September 25, 2011 11:53 AM
> *To:* MS EXCEL AND VBA MACROS 
> *Subject:* 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 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 = 6 'How many rows below you want the
>>> reversed range
>>>Set rngCells = Range("A2:M2")
>>>
>>>For Each rngCell In rngCells
>>>rngCell.Copy rngCell.Offset(lngOffsetRow,
>>> (rngCells.Cells.Count - ((lngCounter * 2) + 1)))
>>>lngCounter = lngCounter + 1
>>>Next rngCell
>>>
>>> End Sub
>>>
>>> OR, you could use a formula to reverse it too
>>>
>>> Use =INDEX($A$2:$M$2,COUNTA(A2:$M$2)) and drag to the right
>>>
>>> Regards
>>>
>>> Sam Mathai Chacko (GL)
>>>
>>> On Sep 23, 8:54 pm, "dguillett1"  wrote:
>>> > Try in a macro enabled workbook (.xls or .xlsm)
>>> >
>>> > 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).Resize(, x - 1).Value = _
>>> > Cells(2, 1).Resize(, x - 1).Value
>>> >
>>> > Cells(3, 1).Resize(, y - x + 1).Value = _
>>> > Cells(2, x).Resize(, y - x + 1).Value
>>> >
>>> > Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1),
>>> Order1:=xlDescending, _
>>> > Header:=xlGuess, OrderCustom:=1, MatchCase:=False,
>>> Orientation:=xlLeftToRight
>>> > End Sub
>>> > ‘or
>>> > Sub CustomSortSAS1() 'copies
>>> > x = Application.Match(Application.Min(Rows(2)), Rows(2))
>>> > y = Application.Match(Application.Max(Rows(2)), Rows(2))
>>> > Cells(2, 1).Resize(, x - 1).Copy Cells(3, y - x + 2)
>>> > Cells(2, x).Resize(, y - x + 1).Copy Cells(3, 1)
>>> > Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1),
>>> Order1:=xlDescending, _
>>> > Header:=xlGuess, OrderCustom:=1, MatchCase:=False,
>>> Orientation:=xlLeftToRight
>>> > End Sub
>>> >
>>> > From: shivashankar katageri
>>> > Sent: Friday, September 23, 2011 1:21 AM
>>> > To: excel-macros@googlegroups.com
>>> > Subject: $$Excel-Macros$$ columns data need to be in reverse order
>>> >
>>> > Dear all,
>>> >
>>> > Any body help in this matter,please have luk of the attachement,
>>> >
>>> > I have lot of columns data,Now I want all the data with formula in
>>> reverse manner
>>> >
>>> > --
>>> >
>>> > Thanks & Regards
>>> >
>>> > Shivashankar.C.Katageri
>>> >
>>> > 9945800300
>>> >
>>> > --
>>> >
>>> --
>>> > 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
>>> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
>>> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>>> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>>> >
>>> > To post to this group, send email to excel-macros@googlegroups.com
>>> >
>>> > <><><><><><><><><><><><><><><><><><><><><><>
>>> > Like our page on facebook , Just follow below linkhttp://
>>>

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

2011-09-25 Thread Sam Mathai Chacko

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 shipments based on results to date.  I've attempted to do this in
> columns L and M without success.
>
> Could someone please help me with this formula?
>
> Thank you!
>
> Steve
>
>   --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Sam Mathai Chacko

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread Steve Weaver

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 Mathai Chacko (GL)

On Sun, Sep 25, 2011 at 11:12 PM, Steve Weaver 
mailto:steveweave...@comcast.net>> 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 shipments based on results to date. 
I've attempted to do this in columns L and M without success.


Could someone please help me with this formula?

Thank you!

Steve

-- 
--

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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com


<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




--
Sam Mathai Chacko
--
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


--
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need Help

2011-09-25 Thread dguillett1

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 Help


Hi , 
I need help can we  be automize the attached report more to look more 
attaractive i want there are so many sheets but can we add button option to 
choose sheet tab and also can we small the size of file


-- 
syed aliya
-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread aju chacko

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 correction so that once maco is executed & whenever
excel window is activated& w.shhet name is "sap vs phy" then the
following code is executed

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread Deepak Pal Singh

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
> only when the excel is opened for first time.Kindly check the code &
> give necessary correction so that once maco is executed & whenever
> excel window is activated& w.shhet name is "sap vs phy" then the
> following code is executed
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread Ankit Agrawal

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/*
>  On Fri, Sep 23, 2011 at 10:42 AM, Ankit Agrawal <
> ankit.agrawal...@gmail.com> wrote:
>
>> Dear All,
>>
>> I want to show a messge when we enter value which is more than 50k.As we
>> type 6 at that time a message show approval need.
>>
>> Could it possible?
>>
>> Regards,
>> Ankit
>>
>> --
>>
>> --
>> 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
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread aju chacko

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 correction so that once maco is executed & whenever
excel window is activated& w.shhet name is "sap vs phy" then the
following code is executed

If ActiveSheet.Name = "sap vs phy" Then
If ActiveCell.Column = 1 Then
Selection.End(xlToRight).Select
Selection.Copy
Application.WindowState = xlMinimized
'doappmon
Else
Range(Selection, Selection.End(xlToLeft)).Select
With Selection.Interior
.Color = 5287936
End With
ActiveCell.End(xlToLeft).Offset(1, 0).Select
If ActiveCell.Value Is Not Empty Then
Selection.Copy
Application.WindowState = xlMinimized
'doappmon
 Else
Exit Sub
End If
 End If
   End If

The sequence in which i made the modules are as follows
.
'***macro in personal macro workbook
Sub exceltosap()
'
' Macro1 Macro
'
   startappmon

End Sub
...
'***macro in pesonal macro workbook
Dim x As New Class11
Sub startappmon()
 Set x.app = Application
End Sub
..
'***class module in personal macro workbook
Public WithEvents app As Application
Private Sub app_WindowActivate(ByVal Wb As Workbook, ByVal Wn As Window)
If ActiveSheet.Name = "sap vs phy" Then
If ActiveCell.Column = 1 Then
Selection.End(xlToRight).Select
Selection.Copy
Application.WindowState = xlMinimized
'doappmon
Else
Range(Selection, Selection.End(xlToLeft)).Select
With Selection.Interior
.Color = 5287936
End With
ActiveCell.End(xlToLeft).Offset(1, 0).Select
If ActiveCell.Value Is Not Empty Then
Selection.Copy
Application.WindowState = xlMinimized
'doappmon
 Else
Exit Sub
End If
 End If
   End If
End Sub

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


sap vs phy.xls
Description: MS-Excel spreadsheet


PERSONAL.XLS
Description: MS-Excel spreadsheet

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

2011-09-25 Thread Amit Gandhi

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 data. I have a excel data (attached
>> file) in vertical form. I want to convert it into Horizontal form using
>> Excel Formulas.
>>
>> Pls help me here.
>>
>> Regards
>>
>> Amit
>>
>> --
>>
>> --
>> 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
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread Amit Gandhi

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 Gandhi wrote:
>>
>>> Hi Folks
>>>
>>> I am finding some problem in excel data. I have a excel data (attached
>>> file) in vertical form. I want to convert it into Horizontal form using
>>> Excel Formulas.
>>>
>>> Pls help me here.
>>>
>>> Regards
>>>
>>> Amit
>>>
>>> --
>>>
>>> --
>>> 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
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *http://www.excelvbamacros.com/*
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>   --
>>
>> --
>> 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
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Visita ; http://sites.google.com/site/chilexcel/Home
> Visita ; http://www.youtube.com/user/timextag41
>
>  --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread Sam Mathai Chacko

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$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 data. I have a excel data (attached
 file) in vertical form. I want to convert it into Horizontal form using
 Excel Formulas.

 Pls help me here.

 Regards

 Amit

 --

 --
 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
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *http://www.excelvbamacros.com/*
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>   --
>>>
>>> --
>>> 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
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> Visita ; http://sites.google.com/site/chilexcel/Home
>> Visita ; http://www.youtube.com/user/timextag41
>>
>>  --
>>
>> --
>> 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
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> 'Expecting the world to treat u fairly coz u r a good person is like
> expecting the lion not to attack u coz u r a vegetarian.
> Think about it.'
>
> Take care
>
> Amit
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Sam Mathai Chacko

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread NOORAIN ANSARI

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 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 particuar date or day should reflect in acceding order in
> single cell.
>
> EMPCodeDateTime
> 525/09/11 09:15:30
> 525/09/11 12:30:00
> 525/09/11 18:30:45
>
>
> taking above table as an example I want result in following format.
>
> EmpCode - 5
> Date - 25/09/11
>
>  25 (09:15:30 | 18:30:45)
>
> means start time and end time for the day or date should reflect.
>
> the idea behind is to creat a caleder for attendence with time for
> employee, on the basis of data which is imported from biomatix system.
>
>
> kindly help me out
>
> vikas daiya
>
>
>
>
>
>
>
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



--

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Solution-Vicky.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

2011-09-25 Thread Sam Mathai Chacko

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..
>
> 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)*
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Mon, Sep 26, 2011 at 10:33 AM, Amit Gandhi wrote:
>
>> Thanks alot Noorain
>>
>> It works fine.
>>
>> But I also want to automate Column E i.e. it automatically retrieve Co
>> Name as well. If you can help me here as well.
>>
>> Regards
>>
>> Amit
>>
>>
>> On Sat, Sep 24, 2011 at 8:54 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Amit,
>>> Please see attached sheet, hope it will help to u.
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>>  
>>> *http://excelmacroworld.blogspot.com/*
>>> *http://noorain-ansari.blogspot.com/*
>>>
>>>   On Sat, Sep 24, 2011 at 5:31 PM, Amit Gandhi wrote:
>>>
 Hi Folks

 I am finding some problem in excel data. I have a excel data (attached
 file) in vertical form. I want to convert it into Horizontal form using
 Excel Formulas.

 Pls help me here.

 Regards

 Amit

>>>
>>>
>>>
>>>
>>>
>>
>>
>> --
>> 'Expecting the world to treat u fairly coz u r a good person is like
>> expecting the lion not to attack u coz u r a vegetarian.
>> Think about it.'
>>
>> Take care
>>
>> Amit
>>
>
>
>  --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Sam Mathai Chacko

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread Amit Gandhi

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)*
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Mon, Sep 26, 2011 at 10:33 AM, Amit Gandhi wrote:
>
>> Thanks alot Noorain
>>
>> It works fine.
>>
>> But I also want to automate Column E i.e. it automatically retrieve Co
>> Name as well. If you can help me here as well.
>>
>> Regards
>>
>> Amit
>>
>>
>> On Sat, Sep 24, 2011 at 8:54 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Amit,
>>> Please see attached sheet, hope it will help to u.
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>>  
>>> *http://excelmacroworld.blogspot.com/*
>>> *http://noorain-ansari.blogspot.com/*
>>>
>>>   On Sat, Sep 24, 2011 at 5:31 PM, Amit Gandhi wrote:
>>>
 Hi Folks

 I am finding some problem in excel data. I have a excel data (attached
 file) in vertical form. I want to convert it into Horizontal form using
 Excel Formulas.

 Pls help me here.

 Regards

 Amit

>>>
>>>
>>>
>>>
>>>
>>
>>
>> --
>> 'Expecting the world to treat u fairly coz u r a good person is like
>> expecting the lion not to attack u coz u r a vegetarian.
>> Think about it.'
>>
>> Take care
>>
>> Amit
>>
>
>
>  --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-09-25 Thread Amit Gandhi

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
> 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..
>>
>> 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)*
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>>
>> On Mon, Sep 26, 2011 at 10:33 AM, Amit Gandhi wrote:
>>
>>> Thanks alot Noorain
>>>
>>> It works fine.
>>>
>>> But I also want to automate Column E i.e. it automatically retrieve Co
>>> Name as well. If you can help me here as well.
>>>
>>> Regards
>>>
>>> Amit
>>>
>>>
>>> On Sat, Sep 24, 2011 at 8:54 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Dear Amit,
 Please see attached sheet, hope it will help to u.

 --
 Thanks & regards,
 Noorain Ansari
  
 *http://excelmacroworld.blogspot.com/*
 *http://noorain-ansari.blogspot.com/*

   On Sat, Sep 24, 2011 at 5:31 PM, Amit Gandhi wrote:

> Hi Folks
>
> I am finding some problem in excel data. I have a excel data (attached
> file) in vertical form. I want to convert it into Horizontal form using
> Excel Formulas.
>
> Pls help me here.
>
> Regards
>
> Amit
>





>>>
>>>
>>> --
>>> 'Expecting the world to treat u fairly coz u r a good person is like
>>> expecting the lion not to attack u coz u r a vegetarian.
>>> Think about it.'
>>>
>>> Take care
>>>
>>> Amit
>>>
>>
>>
>>  --
>>
>> --
>> 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
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Need Help

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

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

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

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

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

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

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

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

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

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

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

35 matches

Site Navigation

Mail list logo

Footer information