I have 35 columns of data and one column that is the key column for my data that I need to sort on. The data looks like this in cell col AE, row 9 thru 11
1"-FW-A3C-32005
1/2"-FW-A3C-32005
4"-FW-A3C-32005
The problem is that I can have several entries listed above with different sizes which in this case is 1", and what I need is to get the largest size which could be 4"-FW-A3C-32005. Once I can resolve the filtering, I can copy the unique record rows to the right area in the report. I've tried For Next loops, and I cant seem to figure it out.
Im basically preparing a line list report in excel for piping. Any help is greatly appreciative.
1"-FW-A3C-32005
1/2"-FW-A3C-32005
4"-FW-A3C-32005
The problem is that I can have several entries listed above with different sizes which in this case is 1", and what I need is to get the largest size which could be 4"-FW-A3C-32005. Once I can resolve the filtering, I can copy the unique record rows to the right area in the report. I've tried For Next loops, and I cant seem to figure it out.
Im basically preparing a line list report in excel for piping. Any help is greatly appreciative.
