I used the paper clip to load the file - hopefully you received it.
The book opens up to the sheet I am working on.
In cell F4 is my IF statement to return the 'most recent' value within the range of 10 cells (N4:W4) checking them in reverse order.
Hi Jess, are you still working on my problem? I thought this was an easy one for you?
OK Thanks!!!! Just checking!
Obviously I can do that but it would not be easy to change at this point and it would not make as much sense to our teachers using the program. If your approach works left to right can it check the 10 cells for the first 'empty cell' and then return the value in the previous cell?
I am sorry for being a pain again but I really do not want to reverse the order of my cells if at all possible - so I am sure you have already considered this but I am going to ask anyway -
Is there a way to check in a range of 10 cells if a cell is filled (has a value from the VLOOKUP statement) and continue checking for filled cells until it encounters an empty cell, record the 'index' of the empty cell and return the previous cell (index-1)?
Hi Jess, obviously you are working on other people's problems as well as mine - just wondering where my problem status is?
That appears to work great for my mile time but it did not work for the other three categories (push ups / sit ups etc.) in my spreadsheet? The other three areas are just numbers no decimal points and no time format - is there a quick adjustment to your formula so that it works on numbers and not a time format?
As always thanks for your time and help.
Thanks everything seems to be working just as I needed!!!!
I have just one more HOPEFULLY quick question and if it is not please do not spend any time working on it as I can always work around it.
In column G I am trying to return the BEST mile time so I am using the formula below which works perfect except for when the returned time is 0.00 which of course now becomes the best time - so my question is can we add an IF statement to ignore 0.00 and return the actual lowest time skipping over any 0.00s???
I am so sorry to bother you yet again - it does exactly what you said it would do but that is not what I was hoping for - in other words if the formula encounters a '0' I need that to be ignored and continue checking for the best time that is not '0'. It returns a blank due to the '0' but I need the best time.
I have included a spreadsheet that displays what I am looking for better than the one you have. So B3 is your formula and the range of ten cells M3:V3.
If this new requirement is too much work please disregard as I am sure you have better things to do,
No it is a slightly different worksheet that I was experimenting with I just removed the first few rows so B3 is the EXACT same thing as G3 and the range is M3:V3 instead of N3:W3 this sheet just has more data is all.
Sorry for the confusion - sheet 1 actually has the 0.00 (V3) for a mile time that I would like to ignore.
I will not bother you anymore!!!!!!!