+ Reply to Thread
Results 1 to 10 of 10

March fishing XLS hpe needed

  1. 06-12-2024, 06:36 AM #1
    philaltimas
    philaltimas is offline
    Registered User
    Join Date
    11-24-2022
    Location
    solihull
    MS-Off Ver
    356
    Posts
    11

    March fishing XLS hpe needed

    hi guys , i was sent this spread sheet by an old mate, i think he got it of here
    it works well for me BUT I need some help with an issue

    so in fishing mathes if you dont weight in Known AS DNW you should get the lowest value points ( 1 )
    the current spread sheet gives points from first down to ten fishing i cant get it to give 1 point to anyone that has DNW
    so idealy i want to be able to type DNW into the LBS column and for it to assign 1 point to that person even if five are fishing, currenelty that angler gets 5 points which is wrong

    all advice and help gratfully received
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-12-2024, 06:57 AM #2
    Eeza Goodun
    Eeza Goodun is offline
    Forum Contributor
    Join Date
    02-12-2024
    Location
    Australia
    MS-Off Ver
    365
    Posts
    181

    Re: March fishing XLS hpe needed

    I think this is what you mean. Change the formula in E4 to

    =IF($B4="DNW",1,IFERROR(VLOOKUP(RANK($D4,$D$4:$D$300),INTERIM!$A$2:$B$11,2,TRUE),""))
    Reply With QuoteRegister To Reply
  3. 06-12-2024, 06:58 AM #3
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: March fishing XLS hpe needed

    How many points for someone who took part, but caught nothing?
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  4. 06-12-2024, 07:23 AM #4
    philaltimas
    philaltimas is offline
    Registered User
    Join Date
    11-24-2022
    Location
    solihull
    MS-Off Ver
    356
    Posts
    11

    Re: March fishing XLS hpe needed

    i will give it a try , Thank you so much
    Reply With QuoteRegister To Reply
  5. 06-12-2024, 07:37 AM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: March fishing XLS hpe needed

    Can you also answer my question?
    Reply With QuoteRegister To Reply
  6. 06-12-2024, 07:40 AM #6
    philaltimas
    philaltimas is offline
    Registered User
    Join Date
    11-24-2022
    Location
    solihull
    MS-Off Ver
    356
    Posts
    11

    Re: March fishing XLS hpe needed

    sorry had to take a call, if they dont weight in ( DNA ) they get one point
    Reply With QuoteRegister To Reply
  7. 06-12-2024, 07:51 AM #7
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: March fishing XLS hpe needed

    Does DNW mean that "I took part, but I caught nothing" or does it mean something else?

    Are you looking for a maximum 10 ranking numbers (from 10 down to 1, and DNW's counting as 1)... and if 6 people take part, with one DNW... 10, 9, 8, 7, 6 ,1

    EXPECTED results for a all possible scenarios make it easier for us to provide answers. There are at least two possible scenarios.

    1. 5 people taking part, 1 DNW

    2. 12 people taking part 1 DNW

    If the offered solution does not work... provide expected answers for BOTH of the above scenarios in an Excel file.
    Reply With QuoteRegister To Reply
  8. 06-12-2024, 07:59 AM #8
    philaltimas
    philaltimas is offline
    Registered User
    Join Date
    11-24-2022
    Location
    solihull
    MS-Off Ver
    356
    Posts
    11

    Re: March fishing XLS hpe needed

    Hi so DNW = Did not weigh that means they took part but either caught nothing or left early and they get one point for talking part


    Are you looking for a maximum 10 ranking numbers (from 10 down to 1, and DNW's counting as 1)... and if 6 people take part, with one DNW... 10, 9, 8, 7, 6 ,1

    EXPECTED results for a all possible scenarios make it easier for us to provide answers. There are at least two possible scenarios.

    1. 5 people taking part, 1 DNW

    2. 12 people taking part 1 DNW

    you have it spot on Sir
    Last edited by philaltimas; 06-12-2024 at 08:10 AM.
    Reply With QuoteRegister To Reply
  9. 06-12-2024, 10:09 AM #9
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: March fishing XLS hpe needed

    OK. I think this does it. Refer to sheet 1. If it is OK, all the other weekly sheets can be similarly treated.

    HOWEVER, you did not explain what happens on a weekly sheet for ties. Is what I have done OK?

    I can then probably HUGELY simplify the overall sheet.

    1. Convert the table to a range.

    2. Delete ALL expected results for weight and rank.

    3. In D4 (no copy paste needed):

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    To see what any of the sub-formulae are doing replace the red H with any of the letters a-h.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 06-12-2024, 10:59 AM #10
    philaltimas
    philaltimas is offline
    Registered User
    Join Date
    11-24-2022
    Location
    solihull
    MS-Off Ver
    356
    Posts
    11

    Re: March fishing XLS hpe needed

    thank you so much , i will have a look tonight, You're a Gent
    Last edited by philaltimas; 06-13-2024 at 01:55 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Fishing match calcs - help needed please
    By philaltimas in forum Excel General
    Replies: 5
    Last Post: 06-05-2024, 02:27 AM
  2. Sorting fishing data in 2 sectors
    By Catvisser in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-22-2024, 01:10 PM
  3. [SOLVED] Multiple formulas needed for March Madness Stats Workbook
    By RachelMads02 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-14-2017, 03:03 AM
  4. fish or fishing rod?
    By tony h in forum The Water Cooler
    Replies: 14
    Last Post: 09-13-2013, 04:17 PM
  5. Fishing weights
    By ged u field in forum Excel General
    Replies: 16
    Last Post: 06-06-2011, 10:39 AM
  6. March 2005 Actual Info vs March 2006 Plan Info
    By Al in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2005, 03:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1