it's confidential and it's a pretty big file to change the content. I did try the formula in a small table of data and it works, but I'm working with close to 100,000 rows of data and for some reason it's not capturing the Max Value "1" in column D.