Most common number that follows a specified value in a list

[D_Spark]

I want to enter a formula in cell B1


This formula will show the MODE of the values in a range that follows a specified number in C1

E.g.

If C1=10

Then B1 will show the mode of numbers that follow 10 in a range B2:B10. Which would be 5.

If C1=5 then B1 would equal 4

eg
B2=10
B3=5
B4=4
B5=10
B6=1
B7=5
B8=4
B9=10
B10=5

 

[Rick Rothstein]

*** duplicate thread ***

Original thread located here...

https://www.mrexcel.com/forum/excel...mon-number-proceeds-specified-value-list.html

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).