Formula Issues - Trying to show oldest figure in 'Days Old'.

[DaveMTR]

Hello all, and thank you in advance for your help.

So I am trying to make a spreadsheet to fill in daily email totals for work.

I have attached an image of a small section of the spreadsheet I am struggling with.

I'm looking for column C7 to display the oldest day from the range in C8 - C14 (which I would manually enter), so for example, in the image I have entered the amount of emails at each 'day old'. In my example, the oldest would 5 days old, and I'm looking for C7 to display '5' or '5 Days Old' or something similar.

The formula I am currently trying is:

=IF(ISBLANK(C8)," ",">5"),IF(ISBLANK(C9)," ","5"),IF(ISBLANK(C10)," ","4"),IF(ISBLANK(C11)," ","3"),IF(ISBLANK(C12)," ","2"),IF(ISBLANK(C13)," ","1"),IF(ISBLANK(C14)," ","0")

but this is returning '#VALUE!'

I would assume I am using the wrong formula (I assumed it would work left to right, so if C8 was blank it wouldn't display anything and move to the next IF for C9 etc).

Again, any help is much appreciated before I start to tear my hair out.

Kind regards.
Dave

 

[DaveMTR]

 

[DaveMTR]

Apologies, trying to add my image, but won't let me from this PC, It's uploaded at https://imgur.com/a/ichb3

 

[Marcelo Branco]

Welcome to Mr Excel forum

Try
=INDEX(B8:B14,MATCH(1,INDEX(--ISNUMBER(C8:C14),),0))

Hope this helps

M.