with your examples you made clear what you meant with "before", that's the information which was neededthe value in the cell that is immediately before the cells with the "x" record
as you have over 1000 posts, we can consider you would know how to browse this site (search), how to use the helpfiles + how to experiment with basic formulas to get the results you needthis is a little confusing, however the solution works when I modified it to the following: =AND(ISNUMBER(U4),U5="x") and copied for the entire range u4:u1003
How do I find the highest numeric value in the range U4:U1003, using CF
1. check out the helpfiles for MAX
2. when using it as a CF-formula (I suppose you want it for the enitre range, think about using absolute cellreferences, else it won't work
You're WELCOME !!!Thanks for help, this problem is solved!!!