matching

Hi guys, Within a workbook I've got a tab(Tab_A) with a list of "Book Tittles" sent it by an external source (20K rows approx). In another tab(Tab_B) I've got my reference list also with "Book Tittles" which I do own. In theory a relevant % of tittles included in the list provided by the...

I am using the following to calculate the mean per row where the ID's are the same. =IF(A4=A3,"",SUMIF(A:A, A4,E:E )/COUNTIF(A:A, A4)) Column A contains my ID's, Column E contains the paid amounts. This works except for the fact that if there are 2, 3, 4 matching ID's it will not populate the...

Not being a coder, I found what I would think to be a pretty simple example of code on the Microsoft support site that compares data in two columns to find duplicates but puts the matching data in the column to the immediate right of the selected column. Cool, but not quite what I need. I was...

I have the first 8 columns in my sheet (A-H) set to desired widths. Does anyone know of any easy way to assign subsequent blocks of 8 (I-P), then Q-X), etc. to widths matching the first 8? In other words, A, I, & Q... would all be 17.57. B, J, R would all be 9.43... Many thanks in...

I have thousands of rows of data that I have to look through to see if there are matching positive and negative numbers matching by ID and then move the matching pair to a different tab. (Or at the very last highlight I have been trying to find an easer way to do this then having to manually do...

Hi, I,m trying to vlookup one cell value with the other. And I got the result also. But I want only one particular result if the cell values are matching. Rest results I want to keep blank even if its matching. For example I have a list of drawing no's in first sheet and second sheet have the...

Hello all, I am trying to match 2 cells and post result of another cell. here is where I am now. I have 100 attribute labels and attribute values in one workbook. Need to extract the matching Item number I lookup and then find and match all attribute labels and values that are relevant to...

I have two sheets of data. Sheet 1 has ID's and sheet 2 has ID'sand zip codes. I need to match the zip codes to the first sheet if there is a matching ID. The two sheetsonly have some matching ID's so I can't just sort them. <colgroup><col width="64" style="width:48pt" span="2">...

I need help with vlookup, I want to be able to type the first letters of a word in and have all matching words come up in the dropdown list, any help would be appreciated thanks.

i want to use VBA to search files in Windows 10 for a keyword and return matching documents as a list. Also the windows search facility I always find buggy, but i am not sure why thank you

Hi I have a question for all that can possibly assist me.... I have a worksheet that returns, or displays unique matching values (on some, or all target columns in a range. Basically: It looks up, or searches the typed-in input value and it compares it against all existing values in another...

hello and thanks for helping Id like to put a formula in Cell E4 of worksheet 2 that shows an "X" if it finds what it is looking for, or stay blank if not found worksheet 2 cell A4 has a value Worksheet 1 range c11:c37 may have 1 matching value in that range if it is found, I would like cell...

Range("B:B,D:D").Select Range("D1").Activate Selection.FormatConditions.AddUniqueValues Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority Selection.FormatConditions(1).DupeUnique = xlDuplicate With Selection.FormatConditions(1).Font .Color...

Good Afternoon, <colgroup><col></colgroup><tbody> =IFERROR(SUMIF('Sales Index'!$C$2:$K$2,B$2,INDEX('Sales Index'!$C$3:$K$200,MATCH($A5,'Sales Index'!$B$3:$B$200,0),0)),0) </tbody> The formula is listed above that is working (index and match) but I have a matrix on another tab that has...

Hello, I am hoping someone can assist me with figuring out a formula that can add a flag in a "NoMatch" type column as displayed below based on a similar set of data. The purpose is to identify where a particular ID has a debit without a matching credit. I assume the fact that the ID can be...

I have two groups of data I am trying working with. In each group, there is a column with a unique value. I am trying to match those values together and then sort so I get a 1-to-1 match on rows. Unfortunately, there are duplicates, so when applying the formula...

Hey Gang, Wasn't sure how to properly word the subject, but let me share the unique scenario. Matching the Unique ID's, I need to check if sheet2 has a value listed. If so, then sheet1 just says "Has Value", otherwise it says "No Value" So in a way, I'm hiding the dollar amounts and replacing...

Seems like a really simple issue to be honest but I'm having a real issue getting it to work I have 2 columns 1 is simply the date as =Today()+1 The other is a vlookup column matching vehicle registrations to designated wash dates I'm trying an IF function cell, true = a vehicle wash note...

Following on from another thread, I'm working on a report with two pivot tables where I need to have some way of comparing the data from the first pivot with the second one to see if it matches or not. If I was producing this analysis for myself I would normally just paste special values both...

Hello I have tried to simplify my example as much as possible. I have a Column C containing student names. In Column D is the answer that student chose on a test, and in Column E, I have the correct answers to these questions. In A2 and A3 I have the students names In B2 and B3 I would like to...