Subtracting dates for days of rest for a player

[mdean32]

I have an ongoing database with multiple players. I need a formula to sort days of rest in between games (Column C) without sorting the players. I can get this to work if I sort the player ascending, but this causes extra work with the daily feed. I was wondering if there was a way to do this without sorting? Thanks for your help

PLAYER DATE REST DAYS

PlayerA	1-1-19
PlayerB	1-3-19
PlayerA	1-4-19	2
PlayerB	1-4-19	0
PlayerA	1-8-19	3
PlayerB	1-14-19	9
PlayerA	1-9-19	0
PlayerB	1-16-19	1

<tbody>
</tbody>

 

[Eric W]

Try:

Excel 2012

	A	B	C
1	PLAYER DATE REST DAYS
2	PlayerA	1/1/2019
3	PlayerB	1/3/2019
4	PlayerA	1/4/2019	2
5	PlayerB	1/4/2019	0
6	PlayerA	1/8/2019	3
7	PlayerB	1/14/2019	9
8	PlayerA	1/9/2019	0
9	PlayerB	1/16/2019	1

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula C2 =IFERROR(B2-LOOKUP(2,1/($A$1:$A1=A2),$B$1:$B1)-1,"") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[mdean32]

Wow! Thank you so much Eric! It worked to perfection.

 

[Eric W]

I'm glad it works for you!