Formula To Determine Last Entry

VinceF

Board Regular
Joined
Sep 22, 2007
Messages
220
Office Version
  1. 2016
Platform
  1. Windows
Greetings,
Hopefully I can explain this clear enough.
I have a worksheet with column A1:A40 where players names are inserted.
Column E1:E40 I enter a number representing the corresponding players score.

In this instance there are only 10 players which would place that players name in cell H10.
Once the last players score from column H (H10 in this example) is entered in the corresponding cell (E10) the condition (formula) would be met and is considered the last entry.
Once the condition is met, via CF I would have it highlight cell C1.
Hopefully this can be done with helper cells.

Very much appreciate your assistance.
VinceF
Win10
Office365
 
Can you show this in a screenshot or a file? It is very confusing how you explained it. One example:
In this instance there are only 10 players which would place that players name in cell H10.
All the name are placed in one cell or in cell H1 to H10?

Try to explain in a way we can understand and give you a solution.

Regards,
GB
 
Upvote 0
GB,
Thank you for the reply...I will try to take a screenshot and post here.
In the meantime to answer your question...
In this example there are 10 players, Player #1 is in cell H1, Player# 2 is in cell H2, and so on.
Player#1's score would be place in cell E10, Player#2's score is placed in cell E11 and so on.
 
Upvote 0
Mr. Excel .jpg


In my previous attempt to explain this I simply used random Columns..
This is the actual spreadsheet and the players names are in column H11:H51 and the last score entry is in column AI11:AI51
The cell I want to highlight via CF is cell T2

Hope this helps
 
Upvote 0
What "CF" means?
And AI column I see it "Individual Bets", still all this is unclear for me.

Please make me understand how you determine the last score entry.

Regards,
GB
 
Upvote 0
Like this?

25 02 09.xlsm
HTAI
1
2
3
4
5
6
7
8
9
10
11Name 16
12Name 25
13Name 33
14Name 44
15Name 55
16Name 63
17Name 78
18Name 85
19Name 94
20Name 10
21
CF
Cells with Conditional Formatting
CellConditionCell FormatStop If True
T2Expression=COUNTA(H11:H51)=COUNTA(AI11:AI51)textNO


When the last score is entered.

25 02 09.xlsm
HTAI
1
2
3
4
5
6
7
8
9
10
11Name 16
12Name 25
13Name 33
14Name 44
15Name 55
16Name 63
17Name 78
18Name 85
19Name 94
20Name 105
21
CF
Cells with Conditional Formatting
CellConditionCell FormatStop If True
T2Expression=COUNTA(H11:H51)=COUNTA(AI11:AI51)textNO
 
Upvote 0
Solution
Peter,
Thank you for the solution, I was able to make it work exactly as needed.
Very much appreciated.
 
Upvote 0
You're welcome. Thanks for the follow-up. :)
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,917
Members
453,766
Latest member
Gskier

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