+ Reply to Thread
Results 1 to 7 of 7

Difficult excel formula required Excel 2007

  1. #1
    Registered User
    Join Date
    11-10-2014
    Location
    London
    MS-Off Ver
    2007
    Posts
    10

    Question Difficult excel formula required Excel 2007

    Hello

    Unfortunately I am not very up on Excel formulas or explaining myself..

    I have attached a excel spreadsheet trying to explain my idea, I am unsure if this is even possible as I have spent hours online trying to read through different formulas but nothing has sunk in.

    Thank you for your time.

    Gregory
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-04-2011
    Location
    UK
    MS-Off Ver
    Excel 2021
    Posts
    346

    Re: Difficult excel formula required Excel 2007

    that will work if you sorted date first and points;

    put =IF(B18<>B19,A18,IF(A18<A19,"-",A19)) into C18 and pull down

  3. #3
    Registered User
    Join Date
    11-10-2014
    Location
    London
    MS-Off Ver
    2007
    Posts
    10

    Re: Difficult excel formula required Excel 2007

    Quote Originally Posted by AlanY View Post
    that will work if you sorted date first and points;

    put =IF(B18<>B19,A18,IF(A18<A19,"-",A19)) into C18 and pull down
    Hi Alan,

    Thank you very much for taking the time to help me out.

    The only problem with that formula is that if the points in A20 than they are in A21 then the Outcome doesn't change to the highest number. Is there any way to convert this?

  4. #4
    Valued Forum Contributor
    Join Date
    08-04-2011
    Location
    UK
    MS-Off Ver
    Excel 2021
    Posts
    346

    Re: Difficult excel formula required Excel 2007

    did you mean if points for A20 is higher than A21?
    it only work if you sorted "the table first, sort by dates then by points"

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Difficult excel formula required Excel 2007

    =IF(COUNTIF($B$18:$B$23,$B18)=1,$A18,IF(COUNTIFS($B$18:$B$23,$B18,$A$18:$A$23,">"&$A18)>0,"-",$A18))
    Try this in C18 and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  6. #6
    Registered User
    Join Date
    11-10-2014
    Location
    London
    MS-Off Ver
    2007
    Posts
    10

    Re: Difficult excel formula required Excel 2007

    Quote Originally Posted by nflsales View Post
    =IF(COUNTIF($B$18:$B$23,$B18)=1,$A18,IF(COUNTIFS($B$18:$B$23,$B18,$A$18:$A$23,">"&$A18)>0,"-",$A18))
    Try this in C18 and copy towards down
    Thank you Siva that is exactly what I was trying to ask for!

  7. #7
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Difficult excel formula required Excel 2007

    Thanks G920 for your feedback and reputation points

+ 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. Replies: 6
    Last Post: 04-24-2014, 08:41 AM
  2. Queries Access 2007 records from Excel 2007 and receive "No Value ... Required parameters"
    By NewbyNewbyNew in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 06:49 PM
  3. macro adjustment required - importing file into excel 2007
    By mattyk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-26-2012, 05:49 AM
  4. Excel 2007 Unable to .pastespecial, Error 'object required'
    By CMSS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2010, 10:34 AM
  5. formula required for excel 2007 spreadshhet
    By colwyn in forum Excel General
    Replies: 1
    Last Post: 10-20-2008, 09:46 AM

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