Dear

Send a sample file to the group, hope you will get solution to your query.

Regards
Ahmed Bawazir

On Thu, Sep 30, 2010 at 8:35 PM, Shah <kmsrah...@gmail.com> wrote:

> Hi,
> I need some HELP with increment flagging.
> By flag I mean a One appears when an even happens, and a Zero appears
> when it doesn't
>
> And by incremental flags I mean that the even occurs at a fixed
> frequency but only after the event has occured.
>
> Let me explain, what I have in my excel sheet.
> Assuming in Row-2 I have my dates (In row-1 I have my inputs which I
> will explin in a minute):
> Jan 2010(in cell A2), Feb 2010(in B2), March 2010(in C2)......
> November 2050 , December 2050
>
> If I say that a certain event will occur in March 2010 and from this
> date it will reoccur after every 5 monthly increments.
> I would like to insert&drag a formula in row-3 where in cell C3 (under
> the date of March 2010) there is a 1 and then there 5 cells later in
> cell H3 under date of Aug 2010 there is a 1, then in M3 under Jan 2011
> etc etc... and there is a zero under all the other dates.
>
> Now the inputs I was talking about earlier, in Cell A1 I want to be
> able to input the date on which the event first occurs that is in
> above case this is March 2010,
> and in Cell A2 I would like to input my frequency or increments, i.e.
> in this case 5.
>
> How can I do this, any suggestions?
> I tried using the mod function but it did not work.
>
> --
>
> ----------------------------------------------------------------------------------
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Reply via email to