winner

  1. A

    Where to start with a Speadsheet for calculating what points a person has accumulated

    Hi All, my first post so sorry if its in the wrong place! Im looking to make a spreadsheet for a local club which im involved with that will track their points throughout a season and show who is the winner at the end. Basically its a horse riding club and they have around five events a year...
  2. rinneii

    VBA for next loops

    EDIT: I meant VBA !!! I tried doing VBA: but I ended up putting an L instead >_> For one of my assignments I need to do as follows: Obtain winning numbers through last row in column G: Type Winner in column G for any row you choose. Write a macro to capture the six winning numbers in that...
  3. U

    OFFSET Help

    I have 100 cells with different names. I have the following formula to tell me who the winner is by the two numbers entered in two cells... =IF(OR(W9="",X9="")," ",INDEX($F$8:$O$17, MATCH(Z9,$B$8:$B$17,0),MATCH(AA9,$F$4:$O$4,0))) This populates a winner who has the two matching numbers. What...
  4. M

    Selecting and copying a value, but if cell blank go to next cell

    Hi all, Having a slight issue in trying to achieve what I would like with the following data: <tbody> <tbody> Federer Serving Djokovic Serving Winner Error Shot type Winner 1 Unforced error 0 Winner 1 Unforced error 0 Winner 1 Winner 0 Winner -1...
  5. B

    Lookup/Reference Help - Multiple lookup ranges

    Not sure I am on the right track - let me try to explain what I am trying to do. I am running a "survivor" pool (person picks a team each day - if they win - they keep going - if the pick a loser, they are out). What I want to do - is look at the pick they made on the day, check to see if...
  6. A

    Calculation Winner by fulfilling multiple conditions

    Hi, I want to calculate the winner by fulfilling these following conditions. For example I gave a Winner list at the bottom of this page. Conditions: 1. The Winner will be he, who achieved maximum Sales 2. Department "A" winners cannot exit 6 <tbody> <tbody> 3. Department "B" winners cannot...
  7. K

    Populate a table with unique names only, VLookUp attributes

    Hello all, I'm trying to take an arranged set of competitors and a) source their names uniquely into a one-column leaderboard, and b) display any entries associated into the contest that received honorable mention or were selected by our editors for other features. I have a main contest title...
  8. T

    And the winner is...

    Once the cells are filled for columns "1,2,3,4,5 and 6" I'd like a check mark (or any selected illustration) to automatically appear under the "Winner" column for the team with the most points. In the example below Team A defeats Team B 4.5-1.5. All cells are filled so can we get a check mark...
  9. D

    Score Prediction Template

    I am trying to make a sports prediction quiz. I would like the scoring to be <tbody> Margin Points Draw 40 Winner 20 Exact 10 1 9 2 8 3 7 4 6 5 5 6 4 7 3 8 2 9 1 </tbody> The selection will be pick, winner, or draw and the points margin of...
  10. M

    Lookup Problem

    CAn you please have a look on my code and tell me what is missing? Private Sub cmdProcess_Click() Dim z As Long Dim UserName As Variant Dim NameLookup As Variant Dim strPName As String Dim sFindIt As String Dim iFoundPass As Integer sFindIt = PayoutFrm.txtSerial.Value If...
  11. R

    Cell Recognise Whole Word from its Initial

    Hello there, I require in Column R & S only in “DataInput” sheet, when I wrote in cell. w then automatic comes Winner & l for Looser. Require VBA coding. Regards, Rahul

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top