+ Reply to Thread
Results 1 to 5 of 5

Formula Help

  1. #1
    Registered User
    Join Date
    12-31-2012
    Location
    bradford, england
    MS-Off Ver
    Excel 2010
    Posts
    35

    Formula Help

    I need help creating a formula in the below attached spreadsheet. I have
    to columns in Sheet 2 (YTD Visits, Recent Visit).


    Sheet 2 (YTD Visits Column) = The formula needs to look into Sheet 1,
    column F, then look at the date entries for the asset, and work out
    how many times the asset has been visited. The test data in sheet 1
    shows the asset has been visited twice on different dates.


    Sheet 2 (Recent Visit) = The formula needs to at Column H in Sheet 1,
    check the date entries for the asset and work out the recent visit at
    the asset, which should 01/08/12.


    I would greatly appreciate if anyone can help with this.

    Test.xlsx

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Formula Help

    In G2
    Please Login or Register  to view this content.
    In H2
    Please Login or Register  to view this content.
    (Array formula, confirm with Ctrl+Shift+Enter)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    12-31-2012
    Location
    bradford, england
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Formula Help

    Hi Ace,

    I've tried the formula in H2 but it doesn't show the data for "Bradford Area 1".

    Also can you explain how these formulas work. Why have you the MAX function

    Test.xlsx

  4. #4
    Registered User
    Join Date
    12-31-2012
    Location
    bradford, england
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Formula Help

    Can anyone please help with the above query.

  5. #5
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,162

    Re: Formula Help

    safir4,

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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