Forum Discussion
Data sorting
Hello everyone, I have a very long list of data showing image file path names from multiple folders. I want to be able to sort this data into five columns (CAM1,CAM2,CAM3,CAM4 and Sphere). I am ab...
If you have Excel in Microsoft 365, you can use the new FILTER function for this.
Otherwise, Advance Filter (Data tab of the ribbon > Advanced) is a quick way to do this.
First, insert a header in A1. I used File, but it can be anything.
Set up a criteria range: File in cell C1 (spelled exactly as in A1) and *CAM1* in C2.
Also set up a copy-to range: File in cell D1 (as in A1).
Select A1 and click Advanced.
Ignore the warning that Excel puts up.
Specify the criteria range, select 'Copy to another range' and specify the Copy to range:
Click OK.
Do the same for the other cameras. It took me less time to execute than to write this down.
See the attached version.
See the attached version. The macro FixNumbers will now do it all.
thank you Hans!
