Hi,
i have numerous "duplicated" rows (which i need to keep), where the only duplication is column a .....eg
a b c
1 r0010 124.14 1454
2 r0010 98.15 1455
3 s012 5.25 9852
4 s012 14.54 1045
5 s012 7.25 4876......
what would be the best solution to extract all the rows which has r0010 to another spreadsheet called "extract.xls". So i would need to extract rows 1 and 2 as they both have r0010. Vlookup does not work or i might be confused.
Jay
i have numerous "duplicated" rows (which i need to keep), where the only duplication is column a .....eg
a b c
1 r0010 124.14 1454
2 r0010 98.15 1455
3 s012 5.25 9852
4 s012 14.54 1045
5 s012 7.25 4876......
what would be the best solution to extract all the rows which has r0010 to another spreadsheet called "extract.xls". So i would need to extract rows 1 and 2 as they both have r0010. Vlookup does not work or i might be confused.
Jay