matching

'********** Step Through Rows Backwards ***************** lastrow = Cells(Rows.Count, "C").End(xlUp).Row For myrow = lastrow To 6 Step -1 Columns("B:C").Select Selection.FormatConditions.AddUniqueValues Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority...

I have two lists of coordinates, X,Y,Z. One list is significantly longer than the other as has additional non matching X,Y values. The Z values are purposely different. At the end of the day I want to compare the different Z values between matching X,Y coordinates What I want to do is find the...

I have to sheet. Sheet1 with list of values in Column A Sheet 2 has Value range as below Sheet1: COLA 1 3 4 6 8 Sheet2 COLA COLB 1 2 3 7 How do I do vlookup which will tell me all matching and non matching values from Sheet 1 and sheet 2 on both side ?

Hi there...see below that I am computing the time interval from a series of timestamps. If the series covers midnight, I get a negative value which screws me up. How can I get a column matching the blue one? Note, there are 1440 minutes in a day. Also, other sets of data used in this...

Hi, I am using the following array formula to retrieve data from a Table on a sheet. {=IFERROR(INDEX(MasterTable!$C$2:$C$564,SMALL(IF(MasterTable!$A$2:$A$564=$BR$2,ROW(MasterTable!$A$2:$A$564)-1),ROW(MasterTable!1:2))),"")} $BR$2 contains the matching criteria. The formula works absolutely...

Hello all, I have this # range in cell A1 101>123. I'm using the > symbol as a thru statement. My question is; if I put 105 in B1; can a formula or VB return a true by looking at A1 and matching 105. I would like conditional formatting in B1 to turn green if 105 is in the range of numbers in...

I would like to scan a barcode label and input the value into cell A1. this input will be a 9 digit unique number. I would like to find the matching value in column B (about 9000 entries already entered) and highlight the row the matching value is found in. then, automatically return to cell A1...

HI all, Today I had some hard time with this: I have three sheets: first has id's, second has Id and names and third has some names. I need to create a flag in the first sheet that calculates if an ID from first sheet is matching with the id from second then match the names from second sheet...

Good evening! I have multiple sheets in my workbook. Sheets("Setup") and Sheets("Data") are the two sheets I'm looking to compare to find matching values. If any of the the values in Column C of the "Setup" sheet are found in Column E of the "Data" sheet, I'd like to highlight the cell green...

Hey guys, So what I'm looking to do i pretty simple. I basically want to populate column T with values corresponding to matching cells in column Y and column X. For example, I would like to first match Q1 to any value that may exist in 973 rows of column Y. Then if there is a match, I would...

Hello. In columns A and B there is a product no. and product list in my sheet. The last matching value I have found with formula ... =lookup(2,1/(B2:B10=C2),A2:A10) How can I find Second to Last matching value? example. <tbody> A B C 1 Product no. List Matching text in cell C2...

hi guys, i have some data which i need help in matching it with which sheet it comes from into a master copy. All the data comes from column D and i need to match and combine all the data together into Column A of a master copy and have their corresponding sheet name on column B. thanks for...

Hi Excel Experts! I am trying to manipulate a multi staff timesheet for easy data entry and I've reached the point of the coding that is way beyond my vba abilities and am hoping for some help. The timesheet can cover between 1 week to 1 month of data, dates of the month are at I21:AM21. Each...

This should be very simple, but I'm stumped. I want to add a column by matching the current value of [Last Year-Week] and pulling in the associated [Sales] value <tbody> Year-Week Last-Year-Week Sales 2017-01 2016-01 100 2017-02 2016-02 200 2017-03 2016-03 300 2017-04 2016-04...

Hello, <tbody> Column 1 Column 2 Column 3 B 1 24 A 2 22 A 2 28 C 1 21 B 2 18 A 2 32 A 1 20 </tbody> Say if I have 3 columns as above, I want to get the minimum value of column 3 among the matching sets in column 1 AND 2 only. i.e. result should only get 22 (min. of A-2) Any...

Hi all, Needing help I am not a super excel user but just wondering if someone could help me with a formula to extract data from a pivot table. I currently have a formula that works by matching and picking up data but i am trying to pick up data from 2 cells. so i am needing to get my formula to...

Hello, I have a database that tracks a list of contracts on one tab and contract modifications on another tab. Both tabs have different columns, but also have some matching column names. What I'm trying to accomplish is to consolidate the information into one tab. For every "Contract ID"...

I need to reference another document, to complete the information in a particular cell. Document #1 "Manufacturers" (information source) Manufacturer ----- ID ABC --------------- 12345 DEF --------------- 23456 GHI --------------- 34567 Document #2 "Parts" (information target) Part...

Hi All, I have column headers in 1 sheet and a set of matching column headers with data underneath in another sheet. I'm looking for a formula that will search for the value in 'Sheet 1' A1 inside 'Sheet 2' A1:Z1, and then return the 'Sheet 2' matching columns data ('Sheet 2' A2:A???, or...

Hi All, I have a formula that works perfectly well, but it's a little sluggish: ={SUM(IF(MONTH('Entries'!$C$2:$C$50000)=MONTH(L$34),IF(YEAR('Entries'!$C$2:$C$50000)=YEAR(L$34),'Entries'!$H$2:$H$50000,0),0))} I thought i might use EOMONTH to speed up rather than evaluating the date twice...