How do I find the last occurance of a number?

[Cyankee]

The title really doesn't explain what is going on,

I am writing a story and I use Excel for keeping track of the timeline

What I am trying to do is show how much time has past between the dates in the same chapter, but I also want to see the dates in chronological order.
Some dates get repeated, that's fine, each chapter starts on the same date, but what I want to find is how many days have past between two dates in a chapter.

Example:
I need to know how many days have past from 6/5/2035 and 5/7/2035. Sure I could just point to the cell and be done with it, but, this spreadsheet will change as more chapters are written. Right now there are two lines between the dates I said in the example, but when all is said and done, there will be many more lines there.

I have seen many suggestions, but, I just cannot get them to work.

[TABLE="class: grid, width: 316, align: left"]
<tbody>[TR]
[TD]Date[/TD]
[TD] DoW[/TD]
[TD]Chapter[/TD]
[TD]Days Past[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/2035[/TD]
[TD="align: right"]Saturday[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05/05/2035[/TD]
[TD="align: right"]Saturday[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05/05/2035[/TD]
[TD="align: right"]Saturday[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05/07/2035[/TD]
[TD="align: right"]Monday[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05/07/2035[/TD]
[TD="align: right"]Monday[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05/21/2035[/TD]
[TD="align: right"]Monday[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]06/05/2035[/TD]
[TD="align: right"]Tuesday[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]06/20/2035[/TD]
[TD="align: right"]Wednesday[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]06/22/2035[/TD]
[TD="align: right"]Friday[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]06/25/2035[/TD]
[TD="align: right"]Monday[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]07/14/2035[/TD]
[TD="align: right"]Saturday[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]07/15/2035[/TD]
[TD="align: right"]Sunday[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]07/16/2035[/TD]
[TD="align: right"]Monday[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]07/20/2035[/TD]
[TD="align: right"]Friday[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]07/25/2035[/TD]
[TD="align: right"]Wednesday[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]07/26/2035[/TD]
[TD="align: right"]Thursday[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]07/28/2035[/TD]
[TD="align: right"]Saturday[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]08/23/2035[/TD]
[TD="align: right"]Thursday[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]08/25/2035[/TD]
[TD="align: right"]Saturday[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]01/10/2036[/TD]
[TD="align: right"]Thursday[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]01/23/2036[/TD]
[TD="align: right"]Wednesday[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]04/15/2036[/TD]
[TD="align: right"]Tuesday[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]04/25/2036[/TD]
[TD="align: right"]Friday[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]06/01/2036[/TD]
[TD="align: right"]Sunday[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]06/30/2036[/TD]
[TD="align: right"]Monday[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[shg]

Not sure what you're asking for -- maybe this:

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

Date​

[/td][td="bgcolor:#F3F3F3"]

Chapter​

[/td][td="bgcolor:#F3F3F3"]

Days Past​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]

Sat 05/05/2035​

[/td][td]

1​

[/td][td="bgcolor:#CCFFCC"][/td][td="bgcolor:#CCFFCC"]C2: =IFERROR(A2 - LOOKUP(9E+307, A$1:A1 / (B$1:B1=B2)), "")[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]

Sat 05/05/2035​

[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]

Sat 05/05/2035​

[/td][td]

3​

[/td][td="bgcolor:#CCFFCC"][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]

Mon 05/07/2035​

[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

2​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]

Mon 05/07/2035​

[/td][td]

3​

[/td][td="bgcolor:#CCFFCC"]

2​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td]

Mon 05/21/2035​

[/td][td]

3​

[/td][td="bgcolor:#CCFFCC"]

14​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

8​

[/td][td]

Tue 06/05/2035​

[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

29​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

9​

[/td][td]

Wed 06/20/2035​

[/td][td]

3​

[/td][td="bgcolor:#CCFFCC"]

30​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

10​

[/td][td]

Fri 06/22/2035​

[/td][td]

3​

[/td][td="bgcolor:#CCFFCC"]

2​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

11​

[/td][td]

Mon 06/25/2035​

[/td][td]

3​

[/td][td="bgcolor:#CCFFCC"]

3​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

12​

[/td][td]

Sat 07/14/2035​

[/td][td]

1​

[/td][td="bgcolor:#CCFFCC"]

70​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

13​

[/td][td]

Sun 07/15/2035​

[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

40​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

14​

[/td][td]

Mon 07/16/2035​

[/td][td]

1​

[/td][td="bgcolor:#CCFFCC"]

2​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

15​

[/td][td]

Fri 07/20/2035​

[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

5​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

16​

[/td][td]

Wed 07/25/2035​

[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

5​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

17​

[/td][td]

Thu 07/26/2035​

[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

1​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

18​

[/td][td]

Sat 07/28/2035​

[/td][td]

1​

[/td][td="bgcolor:#CCFFCC"]

12​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

19​

[/td][td]

Thu 08/23/2035​

[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

28​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

20​

[/td][td]

Sat 08/25/2035​

[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

2​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

21​

[/td][td]

Thu 01/10/2036​

[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

138​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

22​

[/td][td]

Wed 01/23/2036​

[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

13​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

23​

[/td][td]

Tue 04/15/2036​

[/td][td]

1​

[/td][td="bgcolor:#CCFFCC"]

262​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

24​

[/td][td]

Fri 04/25/2036​

[/td][td]

1​

[/td][td="bgcolor:#CCFFCC"]

10​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

25​

[/td][td]

Sun 06/01/2036​

[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

130​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

26​

[/td][td]

Mon 06/30/2036​

[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

29​

[/td][td][/td][/tr]
[/table]

 

[Cyankee]

Thank you! That is perfect! Thank you. Thank you. Thank you. Thank you. Thank you.

Had to edit it slightly since the actual spreadsheet is a bit bigger and arranged differently, but it works!

 

[shg]

You're welcome.