cross-reference

I was given a cross-reference matrix, a section of it is copied below. The numbers in Row 2 and Column C are unique identifiers. Test IDT_001T_002T_003T_010C_001Activity TitleCold Gas Blow DownBottle Piercer CharacterizationCG Assy CharacterizationGG HydrostaticSys...

Hey guys, I am trying to set up a spreadsheet to fill in time slots based on day and time information. There are two sheets in the workbook (Calendar and Log) Here is how I have it set up: The name of this sheet is Calendar A B C 1 Wednesday (August 19, 2020) Thursday (August 20...

I have a list of part numbers, descriptions and cross-reference numbers. The cross-reference numbers are stored in a comma delimited field. Sometimes there are 40+ cross-reference numbers, sometimes there are none. In a new sheet, I would like to make a new line for each cross-reference number...

Hello All, I'm attempting to create a personal profile. The link to this personal profile will be on a contents page which will just be hyperlinking each individuals profiles. There is information on one workbook which shows if staff are current or able at a certain skill. Please note: there...

Hey Guys, thanks for accepting me here. I am quite new in Excel and I face a, in my opinion, quite tricky question. I have one Excel file with two sheets. Sheet 1: <tbody> Brazil Bolivia Colombia Chile JPM EMBI Global JPM EMBI+ </tbody> Sheet 2 ("JPM EMBI Global"): <tbody>...

I need to transfer data (values) from Sheet1, listed as Stock #’s to Sheet2, listed as Inventory #’s, using the cross-reference table on Sheet3. The number of columns of data in each row could range from around 10 columns to about 50 columns, so it would be nice if the VBA could copy from the...

We're trying to find a pipe size in a row, that corresponds to a value of flow within a table (which is found by matching an input flow with a table), see example below. For example, a value for kvs and DN are input by user, the user then inputs desired flow rate which needs to match...

Hi, I have two columns with text in the cells on the same sheet (Columns A and B in my example below). Some words appear in both columns and I need to find out which words are common between them. I don't need to know how many times they appear in both columns. How can I do this in excel? If...