I have a worksheet where I have to extract the quantity from column H to E based on column K .
The criteria to extract to column E are U,m2,m,2U from column K , others to be disregarded
There are the word EA with the numeric DATA with trailing space in hundreds and thousand figures EA of COLUMN H (1 8000.00EA)which need to be removed if condition is met.
Looking a formula to to achieve this on a spreadsheet of 7000 rows
Bookmarks