excel - fuzzy matching

Hi, Thanks for your videos. I have a question as below. I have a table containing some products. RCCO NK-3325 TRD 633 PL 1 KG NK IN RCCO NK-3325 TRD 633 PL 2 KG NK IN RCCO NK-5251 TRD 633 PL 1 KG NK IN RCCO NK-5251 TRD 633 PL 2 KG NK IN RCCO NK-6302 TRD 633 PL 1 KG NK IN Brand is NK-3325...

Hi all, I've got two spreadsheets from which I have to compare and then copy data. But I'm talking about 25.000+ rows, so most of the task should be done automatically. The problem is that it's text data that doesn't match 100% and that there are duplicates involved. On sheet 1 I have, a.o...

hi guys, i need your help. cut the craps. i need to transfer the days to second corresponding cells. what kinds of functions i should to use thanks

Looking at the headers below I want to build a look up formula that will result in the latest (most recent date in list) transaction date (A) for a specific transaction type (B) for the MedID (D) for Station (E) and return the associated information in the desired results format listed below the...

Hi all, I would like to do the following functions in the excel.. the function should compare two values in a same column and if the two values are same, it should compare two dates in a particular column and insert lowest date in a new column.. In the following examples, if the search finds...

I have DAta in Col A (Med ID ) and B has number of events assocaited with the unique ID. The Unique ID is also in Col C from another data source. I wnat to return the value from Col B in in Col C that mathces the MD ID if available. There are several more col in the sheet that have other...

I have over a thousand rows of records where I not only am trying to find duplicates, but also records that are very similiar. I know that I can use the 'Conditional Formatting' - 'Duplicate Values' option to highlight 'duplicates.' But I also want to highlight records that maybe matches 80% or...