+ Reply to Thread
Results 1 to 8 of 8

help for calculate times of occurs start from 0 with name & date

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    help for calculate times of occurs start from 0 with name & date

    Dear experts

    help on this!!! hurry

    i have data in two column one is company name is A:A and B2B Date in B:B column

    i want find the result in C:C column from values nesting A:B column ,,

    company name "A" assiged to date B2B if A Assiged to first earlier data in range should result "0"
    if its company name "A" assigned to second date B2B is result "1"
    if its company name "A" assigned to again second date B2B is result "1"

    it should get result from earlist dates in range with consideration of company name towards date

    FIND THE ATTACHMENT
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: help for calculate times of occurs start from 0 with name & date

    find the code
    Please Login or Register  to view this content.
    check this code can you make changes this code to my requirement!!!
    Last edited by breadwinner; 08-29-2013 at 08:05 AM. Reason: code

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: help for calculate times of occurs start from 0 with name & date

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: help for calculate times of occurs start from 0 with name & date

    any experts help on this?

  5. #5
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: help for calculate times of occurs start from 0 with name & date

    dude can u help on this?

  6. #6
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: help for calculate times of occurs start from 0 with name & date

    You could Sort the data by Company (column A) and then by B2B Date (column B) and then use this formula in cell C2 and copied down:
    Please Login or Register  to view this content.
    If it has to be VBA, here's a macro version:
    Please Login or Register  to view this content.

    Your sample file doesn't use column A, so the code will only work if you delete column A from the sample file.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  7. #7
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: help for calculate times of occurs start from 0 with name & date

    Thanks Tigeravatar!!! Great excelavatar It works perfectly One question will it work for alpha numberic values in column B:B !!!

  8. #8
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: help for calculate times of occurs start from 0 with name & date

    Yeah, just move all column references over by 1. So references to column "A" become "B", "B" becomes "C", etc

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Counting the number of times a date occurs in multiple start and end date ranges.
    By Grizz in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-05-2013, 04:41 PM
  2. [SOLVED] Reposition data on sheet and calculate how many times it occurs
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-17-2013, 05:45 PM
  3. [SOLVED] Count # of times a date range occurs in the last two years
    By ddthomps in forum Excel General
    Replies: 2
    Last Post: 08-02-2012, 01:41 PM
  4. Replies: 0
    Last Post: 11-14-2011, 05:40 PM
  5. [SOLVED] How do I calculate times each word occurs in a column of cells?
    By MTSusce in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-18-2006, 08:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1