Results 1 to 11 of 11

If Different Cells Match Then Add Value

Threaded View

jaclrsen If Different Cells Match Then... 09-09-2015, 05:39 AM
shukla.ankur281190 Re: If Different Cells Match... 09-09-2015, 06:44 AM
jaclrsen Re: If Different Cells Match... 09-09-2015, 07:08 AM
shukla.ankur281190 Re: If Different Cells Match... 09-09-2015, 07:14 AM
shukla.ankur281190 Re: If Different Cells Match... 09-09-2015, 07:17 AM
JohnTopley Re: If Different Cells Match... 09-09-2015, 07:20 AM
jaclrsen Re: If Different Cells Match... 09-09-2015, 08:06 AM
shukla.ankur281190 Re: If Different Cells Match... 09-09-2015, 08:16 AM
jaclrsen Re: If Different Cells Match... 09-09-2015, 08:29 AM
shukla.ankur281190 Re: If Different Cells Match... 09-09-2015, 08:34 AM
JohnTopley Re: If Different Cells Match... 09-09-2015, 08:35 AM
  1. #1
    Registered User
    Join Date
    09-16-2012
    Location
    Sydney
    MS-Off Ver
    Office 2003
    Posts
    47

    If Different Cells Match Then Add Value

    Hi, I've got a spreadsheet where people select the colour they think is going to win. The 'Outcome' sheet goes the outcome of the challenges and which colour won which challenge. The 'Board' sheet shows how many points someone is on. The 'Event' sheet show which colours the players selected.

    So in challenge A, C, D, James chose the correct colour. I'm trying to add two points to James' points tally for each win. So essentially James should now have six points as he won three times. I'm just unsure of the formula to use to calculate the total points for each user.

    You may notice the challenges in the 'Event' sheet are spaced apart because there is other data which goes in between and I also need this to work in Excel 2010. Please see attached. Any help would be great. Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find partial match between two columns and highlight cells that match
    By TomToms in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-18-2019, 01:07 PM
  2. Validating 2 cells goes wrong, finds first match instead of exact match.
    By EricNL in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2015, 08:38 AM
  3. [SOLVED] Match one cell with another, if match found copy adjacent cells
    By Xiophoid in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-07-2013, 05:50 AM
  4. Search a worbook, match cells, input stuff into first workbook if they match.
    By EvilErniesSK in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2012, 11:49 AM
  5. Replies: 14
    Last Post: 12-07-2010, 10:13 PM
  6. [SOLVED] Excel: match two cells in one sheet to two cells in another and return a third cells value
    By Dave Breitenbach in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  7. Replies: 0
    Last Post: 09-06-2005, 02:05 AM

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