hi
I have a formula that works for displaying the largest defect which is as follows:
{=LARGE($D$2:$D$325*IF($C$2:$C$325=F2,1,0),1)}
It works well, but I also want to display the cell that is one column to the left of the displayed number. Any thoughts?
jordie
I have a formula that works for displaying the largest defect which is as follows:
{=LARGE($D$2:$D$325*IF($C$2:$C$325=F2,1,0),1)}
It works well, but I also want to display the cell that is one column to the left of the displayed number. Any thoughts?
jordie