data matching

The initial part of my query is similar to some other posts (although I am not adept enough at VBA to modify the code as needed to suit my purposes), but because the second part goes beyond what I've been able to find already on the forum, I thought I'd post the whole question here. I'm working...

Hi there, I am attempting to separate values for the same ID from different dates. Basically on the earlier date the delivery failed and was redelivered on a later date. Obviously this means the details of the delivery are different for each date. I have tried vlookup but am only able to...

Hello, I had a question that I was hoping to get some help with. I have a spreadsheet that has dates in Column A and dates in Column J. I would like to Match the Dates in Column J with the dates in Column A. When the match is found, I would like the contents of the Adjacent cells to...

Hi friends, Trying to do partial data match of ColumnA and ColumnB in ColumnC for example Here is the sample file with result and highlighted what text have to be partial match. I am not good in VBA macros. Tought that it is only possible VBA macro. https://spaces.hightail.com/space/Gf86h0pqLW

Hi Gurus, I've been struggling with an issue here all day and I'm wondering if anyone has a good solution. I have two data sources, one is an OLAP data cube the other is an excel sheet. I'm wondering how I can create a slicer that will filter both pivots on "Country" the countries are nearly...

Hi, <tbody> Column A Column B I go market I am going market I go hospital I go park I am going park I go market I go office I go park </tbody> I want to know a formula to pick data in cell B2 and B4 under cell B5 and B6 since A2=A5 and A4=A6 respectively. Appreciate if...

Hi, I'm currently using excel 2010 & possibly upgrade to a later version in a near future. My question is that I currently have a large excel sheet with data look like below (Please note that the common fields are the member id & dependent associate id): <tbody> member Id name dependent...

Hi, I have a problem that I can't wrap my head around: My data looks like this: print screen windows 7 What I want is to allocate the "year founded" to the corresponding "Buyer/investor". So for the values/strings in "year founded" I need to a) allocate each to the corresponding value in...

Hi All, I have been working with large excel files ranging from 500,000 to 800,000 plus rows of data. Cleaning, matching and merging data is time consuming. I am wondering if you have an good approach of dealing with large data files? Any good data cleaning and matching tools to recommend...

Hi All, I am having an issue. I have 2 datasets in worksheets in the same workbook say worksheet 1 and worksheet 2. Both Data sets are date and time stamped in columns A and B respectively. I would like to be able to write a macro to search for the matching row of time stamped data in worksheet...

Hello Friends Could you please let me know the best approach to deal with the following issue? I have two sets of data with fields “MANUFACTURER NAME” and “MANUFACTURER PN”. I have to compare them and find discrepancies between them. The problem is that in these two data sets there are some...