extract a list

I want to spill the values in Table2 that are NOT in Table1. Any value that has a "[C]" in it, I want to remove it leaving only the name. I can achieve both objectives but can't figure out how to include the names that don't have "[C]" in them as they return #VALUE. TABLE 1 Name Clark...

Guys I am Back ! I have tried CHATGPT to write the code but it is only stupid code that does not work. Now, my query is i need a code that needs to go to cell A31 then find "F57A" then find BKCH when it finds this then start extracting from BKCH till 11 digits only. Then skip to A68 and do...

In the attached workbook there is about 5 sheets, i'm using this formula to extract all unique records in column B only in sheet (5) based on a criteria in main!D2 =IFERROR(INDEX('5'!$A$1:$A$2222, SMALL(IF(ISNUMBER(MATCH('5'!$B$1:$B$2222,$D$2, 0)), MATCH(ROW('5'!$B$1:$B$2222)...

Hello, and thanks for your worthy responses. I have a PDF (words and tables) 700 pages. This has been converted successfully to an excel file. I'd like help understanding how to extract a cell contents (words) adjacent to key search phrases. For example, you'll see in the attached image, a...

Hi everyone, I have a spreadsheet containing email sender/recipient metadata (email from, to, cc, bcc) that I am attempting to normalize. Column A contains the email IDs, and column B contains the recipients values, delimited by semi-columns. Below is an example: Column A (Email ID) Column B...

I have a table as below. The goal is to extract only first two shop i.d.s from each country having the status either "Active" or "Completed" or "Discontinued". If there are no shops in the country with that status do not extract. If only one than extract only one. Finally the answer should be in...

Hello, I have two lists of places (in two Excel sheets) : cities and swimming pools. I have the lat and long of all the places (for the cities it's the center). I want to extract a list of all the pools nearby every cities. So I would have a final list like this : - Name of the city / CityLat...

Greetings! The project: I have a large set of tables in one tab that is acting as a tracking system for team participation. When a member doesn't show up, I'd like to ask the captains to indicate the missing participant with either a color or italicizing/strikeout. I would like a list to...

Hi All, Is it possible to extract data into an excel table without the use of API? For example, I would like to goto the below website, search by CUSIP (13063A7D0 if an example helps), use trading activity (one of the headers), and extract all the trades for a certain date...