I have 2 spreadsheets in a work book. I need to compare the part numbers and remove the part numbers that are not in both list. Any suggestions on the quickest easiest way? Thank you Robin12
I was hoping that excel would have native tools where you could say in worksheet 1, combination of columns 1 and 2 (and 3 and 4 if needed) provide a unique identifier - perhaps it would tell you how many you needed to pick for unique values. You...
How do you refresh Excel spreadsheets using SSIS? How do you remove leading zero's from a string? How do you unzip a file in an SSIS package? How does DTExec get installed? How dynamically fetch cell range data from excel source in ssis? HOW i can Perform Transaction rollback in SSIS ...
Copying Cells 2 dik Mar 23, 2024 -Engineering spreadsheets Replies 6 Views 900 Mar 23, 2024 dik Locked Question Need a rename macro for excel BhagyeshVashi May 8, 2024 -Engineering spreadsheets Replies 11 Views 1K Jun 6, 2024 sdz Locked Question Python now integrated into Exc...
I am trying to compare columns from two different sheets in two columns that matches to get a value from a 3rd column on the first sheet. Example, Sheet 1 has Column D and E and I want to search S... Sheet2!$F$:$F$25&Sheet2!$G$1:$G$25),0)) ...
Sheet 1 has Column D and E and I want to search Sheet 2 in columns F, G and H. D and E from sheet 1 must match the Row for F and G in sheet 2. If they match then I need the number that is in H for that same Row. Can I get some help on what to use, a for...
Sheet 1 has Column D and E and I want to search Sheet 2 in columns F, G and H. D and E from sheet 1 must match the Row for F and G in sheet 2. If they match then I need the number that is in H for that same Row. Can I get some help on what to ...