$$Excel-Macros$$ formula help

[Kamal Ganeshan]

Dear All,

I have attached one files need your help to applied correct formula

Kindly help.

Regards,
Ganeshan

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Formula help require (1).xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Formula help needed

[kenyattafreed via MS EXCEL AND VBA MACROS]

On Wed, 2/8/17, storeythomas725 via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Formula help needed
 To: excel-macros@googlegroups.com
 Date: Wednesday, February 8, 2017, 8:30 PM
 
 
 
 On Wed, 2/8/17, mintaspriggs via MS EXCEL AND VBA MACROS
 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Formula help needed
  To: excel-macros@googlegroups.com
  Date: Wednesday, February 8, 2017, 3:01 PM
  
  
  
  On Wed, 2/8/17, Paul Schreiner 
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Formula help needed
   To: "excel-macros@googlegroups.com"
  
   Date: Wednesday, February 8, 2017, 2:29 PM
   
   The
   Match() function will return the relative column for
 the
   date matching the header.So:
   Your array of data is in E1:AI1 and if you're
 looking
   for the date in cell C1, you would
  use:MATCH(C$1,$E$1:$AI$1)(the "$" will be necessary for
 when
  you
   copy the formulas)
   In this case, the function
   returns 31, which is the number of columns beginning
 from
   column E.The index() function starts
   with the entire array of data (E1:AI7)and
   uses a row,column offset into this array.
   In cell C2,
   use the
  formula:=INDEX($E$1:$AI$7,ROW(),MATCH(C$1,$E$1:$AI$1))
   the row()
   function returns the current row.You
   can then copy this function to the rows in column C
 and
   D.
   Paul-
   “Do
   all the good you can,
   By all the means you
   can,
   In all the ways you can,
   In all the places you can,
   At
   all the times you can,
   To all the people you
   can,
   As long as ever you can.” - John
   Wesley
   -
   
   
   
      On Tuesday, February
   7, 2017 10:34 AM, Amit Desai (MERU)
   
  wrote:
     
   
    
   
    
    
   #yiv0040706336 #yiv0040706336 --
     
    filtered  {font-family:Calibri;panose-1:2 15 5 2
  2 2 4 3 2
   4;}
   #yiv0040706336 filtered 
  {font-family:Tahoma;panose-1:2 11 6
   4 3 5 4 4 2 4;}
   #yiv0040706336   
    p.yiv0040706336MsoNormal, #yiv0040706336 
   li.yiv0040706336MsoNormal, #yiv0040706336 
   div.yiv0040706336MsoNormal
      
  {margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;}
   #yiv0040706336  a:link, #yiv0040706336 
   span.yiv0040706336MsoHyperlink
       {color:blue;text-decoration:underline;}
   #yiv0040706336  a:visited, #yiv0040706336 
   span.yiv0040706336MsoHyperlinkFollowed
      
  {color:purple;text-decoration:underline;}
   #yiv0040706336  p.yiv0040706336MsoAcetate,
  #yiv0040706336 
   li.yiv0040706336MsoAcetate, #yiv0040706336 
   div.yiv0040706336MsoAcetate
      
  {margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}
   #yiv0040706336  span.yiv0040706336EmailStyle17
       {color:windowtext;}
   #yiv0040706336  span.yiv0040706336BalloonTextChar
       {}
   #yiv0040706336  .yiv0040706336MsoChpDefault
       {}
   #yiv0040706336 filtered  {margin:72.0pt 72.0pt
 72.0pt
   72.0pt;}
   #yiv0040706336  div.yiv0040706336WordSection1
       {}
   #yiv0040706336 
   
   
   
   Dear Friends, 
      
   I am stuck while
   preparing a dashboard. I need auto pickup of data
 based
  (in
   cell highlighted yellow) on model & date from
 the
  right
   side. If I change date (from 31-Jan-17 to 27-Jan-17)
 the
   data should change..
    
      
   I think Index/Match with
   vlookup should work.. but not sure how to use it..
 please
   help. 
      
    
      
      
      
   Best
   Regards, 
   Amit
   Desai 
   Contact: -
   09867232534 
      
   
   Disclaimer: This message and its attachments contain
   confidential information and may also contain
 legally
   privileged information. This message is intended
 solely
  for
   the named addressee. If you are not the addressee
  indicated
   in this message (or authorized
    to receive for addressee), you may not copy or
  deliver any
   part of this message or its attachments to anyone or
 use
  any
   part of this message or its attachments. Rather, you
  should
   permanently delete this message and its attachments
 (and
  all
   copies) from your
    system and kindly notify the sender by reply e-mail.
  Any
   content of this message and its attachments that does
 not
   relate to the official business of Meru Cab Company
 Pvt.
   Ltd. must be taken not to have been sent or endorsed
 by
  any
   of them. Email communications
    are not private and no warranty is made that e-mail
   communications are timely, secure or free from
 computer
   virus or other defect.
   
   
   
   
   
   -- 
   
   Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
 do you
   wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
   Facebook page of this forum @ https://www.facebook.com/discussexcel
   
    
   
   FORUM RULES
   
    
   
   1) Use concise, accurate thread titles. Poor thread
  titles,
   like Please Help, Urgent, Need

Re: $$Excel-Macros$$ Formula help needed

[storeythomas725 via MS EXCEL AND VBA MACROS]

On Wed, 2/8/17, mintaspriggs via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Formula help needed
 To: excel-macros@googlegroups.com
 Date: Wednesday, February 8, 2017, 3:01 PM
 
 
 
 On Wed, 2/8/17, Paul Schreiner 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Formula help needed
  To: "excel-macros@googlegroups.com"
 
  Date: Wednesday, February 8, 2017, 2:29 PM
  
  The
  Match() function will return the relative column for the
  date matching the header.So:
  Your array of data is in E1:AI1 and if you're looking
  for the date in cell C1, you would
 use:MATCH(C$1,$E$1:$AI$1)(the "$" will be necessary for when
 you
  copy the formulas)
  In this case, the function
  returns 31, which is the number of columns beginning from
  column E.The index() function starts
  with the entire array of data (E1:AI7)and
  uses a row,column offset into this array.
  In cell C2,
  use the
 formula:=INDEX($E$1:$AI$7,ROW(),MATCH(C$1,$E$1:$AI$1))
  the row()
  function returns the current row.You
  can then copy this function to the rows in column C and
  D.
  Paul-
  “Do
  all the good you can,
  By all the means you
  can,
  In all the ways you can,
  In all the places you can,
  At
  all the times you can,
  To all the people you
  can,
  As long as ever you can.” - John
  Wesley
  -
  
  
  
     On Tuesday, February
  7, 2017 10:34 AM, Amit Desai (MERU)
  
 wrote:
    
  
   
  
   
   
  #yiv0040706336 #yiv0040706336 --
    
   filtered  {font-family:Calibri;panose-1:2 15 5 2
 2 2 4 3 2
  4;}
  #yiv0040706336 filtered 
 {font-family:Tahoma;panose-1:2 11 6
  4 3 5 4 4 2 4;}
  #yiv0040706336   
   p.yiv0040706336MsoNormal, #yiv0040706336 
  li.yiv0040706336MsoNormal, #yiv0040706336 
  div.yiv0040706336MsoNormal
     
 {margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;}
  #yiv0040706336  a:link, #yiv0040706336 
  span.yiv0040706336MsoHyperlink
      {color:blue;text-decoration:underline;}
  #yiv0040706336  a:visited, #yiv0040706336 
  span.yiv0040706336MsoHyperlinkFollowed
     
 {color:purple;text-decoration:underline;}
  #yiv0040706336  p.yiv0040706336MsoAcetate,
 #yiv0040706336 
  li.yiv0040706336MsoAcetate, #yiv0040706336 
  div.yiv0040706336MsoAcetate
     
 {margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}
  #yiv0040706336  span.yiv0040706336EmailStyle17
      {color:windowtext;}
  #yiv0040706336  span.yiv0040706336BalloonTextChar
      {}
  #yiv0040706336  .yiv0040706336MsoChpDefault
      {}
  #yiv0040706336 filtered  {margin:72.0pt 72.0pt 72.0pt
  72.0pt;}
  #yiv0040706336  div.yiv0040706336WordSection1
      {}
  #yiv0040706336 
  
  
  
  Dear Friends, 
     
  I am stuck while
  preparing a dashboard. I need auto pickup of data based
 (in
  cell highlighted yellow) on model & date from the
 right
  side. If I change date (from 31-Jan-17 to 27-Jan-17) the
  data should change..
   
     
  I think Index/Match with
  vlookup should work.. but not sure how to use it.. please
  help. 
     
   
     
     
     
  Best
  Regards, 
  Amit
  Desai 
  Contact: -
  09867232534 
     
  
  Disclaimer: This message and its attachments contain
  confidential information and may also contain legally
  privileged information. This message is intended solely
 for
  the named addressee. If you are not the addressee
 indicated
  in this message (or authorized
   to receive for addressee), you may not copy or
 deliver any
  part of this message or its attachments to anyone or use
 any
  part of this message or its attachments. Rather, you
 should
  permanently delete this message and its attachments (and
 all
  copies) from your
   system and kindly notify the sender by reply e-mail.
 Any
  content of this message and its attachments that does not
  relate to the official business of Meru Cab Company Pvt.
  Ltd. must be taken not to have been sent or endorsed by
 any
  of them. Email communications
   are not private and no warranty is made that e-mail
  communications are timely, secure or free from computer
  virus or other defect.
  
  
  
  
  
  -- 
  
  Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
  Facebook page of this forum @ https://www.facebook.com/discussexcel
  
   
  
  FORUM RULES
  
   
  
  1) Use concise, accurate thread titles. Poor thread
 titles,
  like Please Help, Urgent, Need Help, Formula Problem, Code
  Problem, and Need Advice will not get quick attention or
 may
  not be answered.
  
  2) Don't post a question in the thread of another
  member.
  
  3) Don't post questions regarding breaking or bypassing
  any security measure.
  
  4) Acknowledge the responses you receive, good or bad.
  
  5) Jobs posting is not allowed.
  
  6) Sharing copyrighted material and their links is not
  allowed.
  
   
  
  NO

Re: $$Excel-Macros$$ Formula help needed

[mintaspriggs via MS EXCEL AND VBA MACROS]

On Wed, 2/8/17, Paul Schreiner  wrote:

 Subject: Re: $$Excel-Macros$$ Formula help needed
 To: "excel-macros@googlegroups.com" 
 Date: Wednesday, February 8, 2017, 2:29 PM
 
 The
 Match() function will return the relative column for the
 date matching the header.So:
 Your array of data is in E1:AI1 and if you're looking
 for the date in cell C1, you would use:MATCH(C$1,$E$1:$AI$1)(the "$" will be 
necessary for when you
 copy the formulas)
 In this case, the function
 returns 31, which is the number of columns beginning from
 column E.The index() function starts
 with the entire array of data (E1:AI7)and
 uses a row,column offset into this array.
 In cell C2,
 use the formula:=INDEX($E$1:$AI$7,ROW(),MATCH(C$1,$E$1:$AI$1))
 the row()
 function returns the current row.You
 can then copy this function to the rows in column C and
 D.
 Paul-
 “Do
 all the good you can,
 By all the means you
 can,
 In all the ways you can,
 In all the places you can,
 At
 all the times you can,
 To all the people you
 can,
 As long as ever you can.” - John
 Wesley
 -
 
 
 
On Tuesday, February
 7, 2017 10:34 AM, Amit Desai (MERU)
  wrote:
   
 
  
 
  
  
 #yiv0040706336 #yiv0040706336 --
   
  filtered  {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2
 4;}
 #yiv0040706336 filtered  {font-family:Tahoma;panose-1:2 11 6
 4 3 5 4 4 2 4;}
 #yiv0040706336   
  p.yiv0040706336MsoNormal, #yiv0040706336 
 li.yiv0040706336MsoNormal, #yiv0040706336 
 div.yiv0040706336MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;}
 #yiv0040706336  a:link, #yiv0040706336 
 span.yiv0040706336MsoHyperlink
{color:blue;text-decoration:underline;}
 #yiv0040706336  a:visited, #yiv0040706336 
 span.yiv0040706336MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
 #yiv0040706336  p.yiv0040706336MsoAcetate, #yiv0040706336 
 li.yiv0040706336MsoAcetate, #yiv0040706336 
 div.yiv0040706336MsoAcetate
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}
 #yiv0040706336  span.yiv0040706336EmailStyle17
{color:windowtext;}
 #yiv0040706336  span.yiv0040706336BalloonTextChar
{}
 #yiv0040706336  .yiv0040706336MsoChpDefault
{}
 #yiv0040706336 filtered  {margin:72.0pt 72.0pt 72.0pt
 72.0pt;}
 #yiv0040706336  div.yiv0040706336WordSection1
{}
 #yiv0040706336 
 
 
 
 Dear Friends, 
    
 I am stuck while
 preparing a dashboard. I need auto pickup of data based (in
 cell highlighted yellow) on model & date from the right
 side. If I change date (from 31-Jan-17 to 27-Jan-17) the
 data should change..
  
    
 I think Index/Match with
 vlookup should work.. but not sure how to use it.. please
 help. 
    
  
    
    
    
 Best
 Regards, 
 Amit
 Desai 
 Contact: -
 09867232534 
    
 
 Disclaimer: This message and its attachments contain
 confidential information and may also contain legally
 privileged information. This message is intended solely for
 the named addressee. If you are not the addressee indicated
 in this message (or authorized
  to receive for addressee), you may not copy or deliver any
 part of this message or its attachments to anyone or use any
 part of this message or its attachments. Rather, you should
 permanently delete this message and its attachments (and all
 copies) from your
  system and kindly notify the sender by reply e-mail. Any
 content of this message and its attachments that does not
 relate to the official business of Meru Cab Company Pvt.
 Ltd. must be taken not to have been sent or endorsed by any
 of them. Email communications
  are not private and no warranty is made that e-mail
 communications are timely, secure or free from computer
 virus or other defect.
 
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discussexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.
 
 --- 
 
 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 
 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscr...@googlegroups.com.
 
 To post to this group, send

Re: $$Excel-Macros$$ Formula help needed

[Paul Schreiner]

The Match() function will return the relative column for the date matching the 
header.So: Your array of data is in E1:AI1 and if you're looking for the date 
in cell C1, you would use:MATCH(C$1,$E$1:$AI$1)(the "$" will be necessary for 
when you copy the formulas)
In this case, the function returns 31, which is the number of columns beginning 
from column E.The index() function starts with the entire array of data 
(E1:AI7)and uses a row,column offset into this array.
In cell C2, use the formula:=INDEX($E$1:$AI$7,ROW(),MATCH(C$1,$E$1:$AI$1))
the row() function returns the current row.You can then copy this function to 
the rows in column C and D.
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
- 

On Tuesday, February 7, 2017 10:34 AM, Amit Desai (MERU) 
 wrote:
 

  Dear 
Friends,    I am stuck while preparing a dashboard. I need auto pickup of data 
based (in cell highlighted yellow) on model & date from the right side. If I 
change date (from 31-Jan-17 to 27-Jan-17) the data should change..    I think 
Index/Match with vlookup should work.. but not sure how to use it.. please 
help.              Best Regards, Amit Desai Contact: - 09867232534    
Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


   

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Formula help needed

[Amit Desai (MERU)]

Dear Friends,

I am stuck while preparing a dashboard. I need auto pickup of data based (in 
cell highlighted yellow) on model & date from the right side. If I change date 
(from 31-Jan-17 to 27-Jan-17) the data should change..

I think Index/Match with vlookup should work.. but not sure how to use it.. 
please help.

[cid:image001.png@01D28185.9A2A90C0]



Best Regards,
Amit Desai
Contact: - 09867232534

Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Excel help.xlsx
Description: Excel help.xlsx

Re: $$Excel-Macros$$ Formula Help !

[Vaibhav Joshi]

Check this if it helps...


Cheers!!

+
*I did not do this for you. God is here working through me for you.*

On Sat, Nov 8, 2014 at 6:10 PM, Ajay AJ  wrote:

> ​​
> Hey,
>
> So the basic concept is that he dates are for PPM Schedule so which means
> whenever it was left off, it has to be done in 2015, and the ones which
> have not been taken care off needs to begin on 15th Jan 2015
>
>
> if you look at the column,
>
> some dates are in 2014
> some dates are before 2014
> some dates do not exist
>
> what I want is a formula so that
>
> the dates in 2014 should become 2015 and
> dates before 2014 should also have the year 2015
> and the ones with no dates to show 15 Jan 2015
>
> Could you help me please asap... I have so many of these columns to
> fill
>
>
> Thanks in advance
> Ajay
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


DATES.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Formula Help !

[Ajay AJ]

​​
Hey,

So the basic concept is that he dates are for PPM Schedule so which means
whenever it was left off, it has to be done in 2015, and the ones which
have not been taken care off needs to begin on 15th Jan 2015


if you look at the column,

some dates are in 2014
some dates are before 2014
some dates do not exist

what I want is a formula so that

the dates in 2014 should become 2015 and
dates before 2014 should also have the year 2015
and the ones with no dates to show 15 Jan 2015

Could you help me please asap... I have so many of these columns to fill


Thanks in advance
Ajay

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


DATES.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Formula help

[Abhishek Jain]

=IF(AND(C7>=C2,C7<=D2),E2,IF(AND(C7>=C3,C7<=D3),E3,IF(AND(C7>=C4,C7<=D4),E4,0)))


On Mon, Jan 20, 2014 at 11:08 AM, Shaikh Iqbal wrote:

> Thx sir. I need IF condition formula.
>
>
>
>
>
>
> On 18 January 2014 21:17, Kantilal Badale wrote:
>
>> PFA
>>
>> CA Kantilal Badale
>> 9822250393
>>
>>
>>
>> On Sat, Jan 18, 2014 at 5:08 PM, Shaikh Iqbal wrote:
>>
>>> Dear Export,
>>>
>>>
>>> I want a formula as per attached 3 slab condition wise earning.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> Regards,
>>>
>>> Iqbal
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any securit

Re: $$Excel-Macros$$ Formula help

[Shaikh Iqbal]

Thx sir. I need IF condition formula.






On 18 January 2014 21:17, Kantilal Badale  wrote:

> PFA
>
> CA Kantilal Badale
> 9822250393
>
>
>
> On Sat, Jan 18, 2014 at 5:08 PM, Shaikh Iqbal wrote:
>
>> Dear Export,
>>
>>
>> I want a formula as per attached 3 slab condition wise earning.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Regards,
>>
>> Iqbal
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Formula help

[Kantilal Badale]

PFA

CA Kantilal Badale
9822250393



On Sat, Jan 18, 2014 at 5:08 PM, Shaikh Iqbal  wrote:

> Dear Export,
>
>
> I want a formula as per attached 3 slab condition wise earning.
>
>
>
>
>
>
>
>
>
>
>
>
>
> Regards,
>
> Iqbal
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


earning Solved.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Formula help

[Shaikh Iqbal]

Dear Export,


I want a formula as per attached 3 slab condition wise earning.













Regards,

Iqbal

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


earning.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ formula help

[André D'Avila]

Hey!

Look at the file,

Good luck!

2012/3/7 Avinash 

> hi all can anyone help me to get the desired result in this sheet
>
> i have attached the sheet please see the attachment for better
> understanding.
>
> Regards
>
> Avinash
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


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

Re: $$Excel-Macros$$ formula help

[dguillett1]

Macro solution for summary

Sub getuniqueandcount()
Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row) _
.AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range("G1"), Unique:=True
Range("h2:H" & Cells(Rows.Count, "g").End(xlUp).Row).Formula = _
"=VLOOKUP(G2,A:B,2,0)&""--""&COUNTIF(A:A,G2)"
End Sub

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com

From: NOORAIN ANSARI 
Sent: Wednesday, March 07, 2012 10:20 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ formula help

Dear Avinash,

Please use it..

=B2&"--"&COUNTIF($A$2:A2,A2)

or
=$B2&"--"&SUMPRODUCT(--($A$2:$A2=$A2))

See attached sheet.

-- 

Thanks & regards,
Noorain Ansari
http://noorainansari.com/
http://excelmacroworld.blogspot.com/
On Wed, Mar 7, 2012 at 9:30 PM, Avinash  wrote:

  hi all can anyone help me to get the desired result in this sheet 

  i have attached the sheet please see the attachment for better understanding.

  Regards

  Avinash
  -- 
  FORUM RULES (986+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com







-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ formula help

[NOORAIN ANSARI]

Dear Avinash,

Please use it..

=B2&"--"&COUNTIF($A$2:A2,A2)

or
=$B2&"--"&SUMPRODUCT(--($A$2:$A2=$A2))
See attached sheet.
-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.com/*
On Wed, Mar 7, 2012 at 9:30 PM, Avinash  wrote:

> hi all can anyone help me to get the desired result in this sheet
>
> i have attached the sheet please see the attachment for better
> understanding.
>
> Regards
>
> Avinash
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


Copy of formula help(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ formula help

[Avinash]

hi all can anyone help me to get the desired result in this sheet

i have attached the sheet please see the attachment for better 
understanding.

Regards

Avinash

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


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

Re: $$Excel-Macros$$ Formula Help

[hemant]

Thanks to all for the Prompt reply.

The problem is solved.

Regards
Hemant Dange

On Dec 7, 9:55 pm, "dguillett1"  wrote:
> A macro to populate column B
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
> -Original Message-
> From: hemant
> Sent: Wednesday, December 07, 2011 2:30 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Formula Help
>
> Hi all
>
> I need help on the following in EXCEL 2007:
>
> Compare the values of sheet 1:column A with Values of Sheet2:column A
>
> If the CELL values in sheet1 column matches with Range of values in
> Sheet2 column.
>
> copy that CELL VALUE from sheet1 and paste it adjacent column (Column
> B) of sheet2. Or COLOUR that particular cell background.
>
> Thanks and Regards
> Hemant Dange
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> ---­---
> To post to this group, send email to excel-macros@googlegroups.com
>
>
>
>  cfmacro.xls
> 50KViewDownload- Hide quoted text -
>
> - Show quoted text -

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Formula Help

[dguillett1]

A macro to populate column B



Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: hemant

Sent: Wednesday, December 07, 2011 2:30 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Formula Help

Hi all

I need help on the following in EXCEL 2007:

Compare the values of sheet 1:column A with Values of Sheet2:column A

If the CELL values in sheet1 column matches with Range of values in
Sheet2 column.

copy that CELL VALUE from sheet1 and paste it adjacent column (Column
B) of sheet2. Or COLOUR that particular cell background.

Thanks and Regards
Hemant Dange


--
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.


2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security 
measure.


4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


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


--
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


cfmacro.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Formula Help

[rajan verma]

hi
please see the attached File..
Hope this will help

Rajan.

On Wed, Dec 7, 2011 at 2:00 PM, hemant  wrote:

> Hi all
>
> I need help on the following in EXCEL 2007:
>
> Compare the values of sheet 1:column A with Values of Sheet2:column A
>
> If the CELL values in sheet1 column matches with Range of values in
> Sheet2 column.
>
> copy that CELL VALUE from sheet1 and paste it adjacent column (Column
> B) of sheet2. Or COLOUR that particular cell background.
>
> Thanks and Regards
> Hemant Dange
>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


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

Re: $$Excel-Macros$$ Formula Help

[NOORAIN ANSARI]

Dear Hemant,

You can use below function with Conditonal Formating..

=MATCH($A1,Sheet2_range,0)

Sheet2_range is name range of Sheet2 B Column.


-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Wed, Dec 7, 2011 at 2:00 PM, hemant  wrote:

> Hi all
>
> I need help on the following in EXCEL 2007:
>
> Compare the values of sheet 1:column A with Values of Sheet2:column A
>
> If the CELL values in sheet1 column matches with Range of values in
> Sheet2 column.
>
> copy that CELL VALUE from sheet1 and paste it adjacent column (Column
> B) of sheet2. Or COLOUR that particular cell background.
>
> Thanks and Regards
> Hemant Dange
>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

** 

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Formula Help

[Aindril De]

Dear Hemant,

It can be achieved using the vlookup formula.
Suppose you have a data set in Sheet 1 from A1 to A9, which you need to
compare with the values present in column A in Sheet 2
Then in Column B, please type:

=VLOOKUP(A1,Sheet1!$A$1:$A$9,1,0)

and drag the formula down.

You will get some #N/A values for the values not matching with Sheet 1.
You can further refine the formula, to suppress the #N/A values as follows:

=IF(ISERROR(VLOOKUP(A1,Sheet1!$A$1:$A$9,1,0)),"",VLOOKUP(A1,Sheet1!$A$1:$A$9,1,0))

This will suppress the #N/A values and replace them with blank.
Hope this helps

Cheers,
Andy


On Wed, Dec 7, 2011 at 2:00 PM, hemant  wrote:

> Hi all
>
> I need help on the following in EXCEL 2007:
>
> Compare the values of sheet 1:column A with Values of Sheet2:column A
>
> If the CELL values in sheet1 column matches with Range of values in
> Sheet2 column.
>
> copy that CELL VALUE from sheet1 and paste it adjacent column (Column
> B) of sheet2. Or COLOUR that particular cell background.
>
> Thanks and Regards
> Hemant Dange
>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

$$Excel-Macros$$ Formula Help

[hemant]

Hi all

I need help on the following in EXCEL 2007:

Compare the values of sheet 1:column A with Values of Sheet2:column A

If the CELL values in sheet1 column matches with Range of values in
Sheet2 column.

copy that CELL VALUE from sheet1 and paste it adjacent column (Column
B) of sheet2. Or COLOUR that particular cell background.

Thanks and Regards
Hemant Dange


-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Formula Help Required Urgent

[Venkatesan c]

Dear Andy,

Thank u




On Fri, Jun 4, 2010 at 3:55 PM, Aindril De  wrote:

> Hi Venkat,
>
> This can be achieved using array formulas in Excel.
> Suggest you to look into the discussion in the attached link that should
> resolve your issue:
> http://www.mrexcel.com/forum/showthread.php?t=312142
>
> Regards,
> Andy
>
>   On Thu, Jun 3, 2010 at 6:57 PM, Venkatesan c wrote:
>
>>  Dear Group,
>>
>>
>>
>> Can i have UNIQUEIFS Function its some thing like SUMIFS
>>
>>  Best Regards,
>> *
>>
>> Venkat
>> *
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Formula Help Required Urgent

[Aindril De]

Hi Venkat,

This can be achieved using array formulas in Excel.
Suggest you to look into the discussion in the attached link that should
resolve your issue:
http://www.mrexcel.com/forum/showthread.php?t=312142

Regards,
Andy

On Thu, Jun 3, 2010 at 6:57 PM, Venkatesan c  wrote:

>  Dear Group,
>
>
>
> Can i have UNIQUEIFS Function its some thing like SUMIFS
>
>  Best Regards,
> *
>
> Venkat
> *
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Formula Help Required Urgent

[Venkatesan c]

Dear Group,



Can i have UNIQUEIFS Function its some thing like SUMIFS

 Best Regards,
*

Venkat
*

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ formula help

[watmatt]

Can you help me please?  I have a bit of a situation and I need some
fresh eyes and brain power. I am trying to set up a spreadsheet for my
dad in excel and I have run into a formula snag. This is the last
formula I need to complete this worksheet and I need to get it right.
My brain hurts from trying to figure this out!  Any help would be
greatly appreciated!

Here is what I am trying to do.

If A1 is less than 50 then add 50% to B2, But if A1 is more than 50
but less than 100 then add 40% to B2. If A1 is more than 500 then
subtract 3% from B2, or if A1 is more than 1000 then subtract 5% from
B2.

So far I can get the first part to work with:=IF
(A1<50,B2*0.5+B2)

I can also get it to calculate correctly with:  =SUM(A1<50)*SUM
(B2*0.5+B2)

BUT I can't seem to figure out how to fit in the rest

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit & Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~--~~~~--~~--~--~---