helens0

I wonder if someone could help, I have found on a number of occasions that when I use captions for tables and figures in a word document and then cross reference them in the text of the document when I print (or save) the document a page break is inserted imediately before the crossreference in the text. This does not always serve to put the cross reference and the caption on the same page (which was my initial reasoning) Any suggestions gratefully received many thanks Helen

Apologies, my initial posting seems to have failed. I am looking to find a formula that will return the highest value from a list that is lower than another value which is specified in a different cell. e.g Find the highest number in the list below that is greater than a number in (eg) cell A1 : 60 57.576 57.778 58.113 58.261 58.364 58.371 58.389 58.636 60.000 60.082 60.140 61.189 Any help greatly appreciated. Many thanks Helen