Using Excel 2000
Hi,
My data are divided in the 4-parts (part-1 to part-4) in columns C:AC, within these columns in the each row is filled only one cell within any of 4-parts.
I want the results in column AE:AH "part number2 in which part data are located
Example data...