| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a list of job numbers, missing out irrelevant items
I have a table with the headings; job number, title, and option (A/E).
I want to pull in the jobs which are only option A into a new worksheet table. So my first table may have Job No Title Option 1234 Site 01 A 2345 Site 02 E 3456 Site 03 E 4567 Site 04 A My new table should only have: Job No 1234 4567 Kind regards Dylan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find missing numbers in a list | Excel Discussion (Misc queries) | |||
| creating a reconciling list of items not matched between two files | Excel Worksheet Functions | |||
| Find Missing Numbers in a List | Excel Discussion (Misc queries) | |||
| MISSING NUMBERS IN LIST | Excel Discussion (Misc queries) | |||
| How do i identify missing numbers in a sequential list | Excel Discussion (Misc queries) | |||
Threaded Mode
