matching cells

I’m building a tool for users to check their own performance on QA/QC samples without revealing the true values to them (Tbl.Grp1.entry and Tbl.Grp2.entry). Right now I do this manually for each instance. I’m getting stuck on how best to compare values when the TYPEs are mismatched, and when...

I am trying to pull the data from the first row (E1, F1, G1 ...) based on a certain condition. If col D - "Penetration limit" is equal or greater than the data between row E to V, i need the row name(E1, F1, G1 ...) to show up under the respective col C. Example: in Row 4 ---- D4= 40% and N4...

First of all, thank you very much if you can help me solve the below Excel formula. :) As you can see there are 2 sets of data. First we need to match the part number, second, we need to insert the commit number (G2) into the fulfilled QTY (D2). Now, here's the first issue I'm having, as you...

Hello Excel Experts, I have 2 Excel files, the first has cells with the following data: [Name] [Cost] [Date] The second file has: [Name] [SKU] [Serial Numbers (can be more than 1)] I'm trying to combine these into a new file with: [Name] [SKU] [Serial Numbers] [Cost], based on the...

Hi Everyone, First time posting so hopefully this is clear. I need a formula that can help find and populate an entry when 2 consecutive cells in the same row match 2 other consecutive cells in other columns. i.e. Cell A2 = John Cell B2 = Smith Cell C2 = Blue Cell D13 = John Cell E13 =...

If my title caught your attention, please read further. I am not looking for elegance, but I am looking for a fast way to go through the data. I have 19914 lines (yes 19914 rows) of data that are separated into 3 columns Column A: Known Depth Column B: Known Age Column C: Known Depth (but points...

Hi guys, I am a total newbie at this programming lark. Basically in a previous employment we had a macro to compare cell values. So for instance: Column A contains product codes Column B contains the sales relating to each product code Column C contains column codes Column D contains the...

Hi all, I have the following information in sheet1: Col A | Col B aaaaa | Leeds bbbbb | Leeds cccccc | London And in sheet 2 i have Col A | Col B aaaa | 1234 cccc | 4567 bbbb | 2345 If cell A1 in in sheet 2, copy cell B1 into sheet 1 C1. an example of the results would be: Col A | Col B...