About me
My name is Oscar Cronquist and I live in the south of Sweden. We have three kids. Sweden is a small country with 10 million inhabitants in Scandinavia located in northern Europe.
Sweden is known for IKEA, Spotify, Skype, Volvo, Ericsson and Minecraft.
We live in a house near the ocean and the weather is about the same as in the United Kingdom. Rainy and foggy in the winter and beautiful in the summer.
I created this website and I write articles about Microsoft Excel. Most website visitors come from the United States, UK, Australia, Canada, and India.
Famous people from Sweden
Swedish chef
hi Oscar,
im working with data in a spreadsheet and need to identify duplicate and unique values.
There is a list of product codes which each have a system unique identifier (ABC100001)
when a product was disconnected and new one introduced, that system identifier was recycled and the product was assigned to it.
There can only be 1 product SKU to 1 System identifier.
I need a formula which will extract all 1-to-1 which is unique and show me what is left which are potential duplicates
I need to identify each system ID with multiple SKUs
Product ID System ID
SKU12345 ABC003344
SKU00001 ABC003344
This will be for very large data.
I am stuck and dont know what formula to look for, your assistance is greatly appreciated!
Thank you!
Izz
Good Morning (my time) sir. I am a frequent moocher of code, and I have used your code and your tutorials many times in the past. Today I have hit a wall, and it regards pulling similar data from 2 sheets within the same workbook. My new issue is these sheets do not have a unique identifier, or more accurately, the unique identifier I am using is date (mm/dd/yy), but there are multiple entries in each sheet for each date, potentially, and I need to match 2 columns in each sheet. Each sheet is from a different database that "should" log the same events. They have similar columns, but upon review, there is a large disparity between their content. I need to match 2 columns: date, and location. Sheet1 may have 9 entries for 1 day. Sheet 2 may have 4 entries for the same day. I want to go to new Sheet3, and if there is a match for both the date and location in a row in both sheets, import it. I have created similar queries in the past using vlookup, or index/match, using arrays, etc, but this issue has a few unique hurdles that I haven't encountered before. Can you offer advice as how to approach my problem? Is it possible?
The columns in each sheet are many, but all I’m concerned with is the “DATE” of occurrence, the “LOCATION” of occurrence, and the “REMARKS”. Like columns in both sheets.
Many thanks for your consideration,
Eric
Hi Oscar
How to retrieve information from another sheet by Name & latest 4 Max dates?
Sheet 1 is information
eg; Column A Names, Column B Dates, Column C Distance, etc.
Same Name appears 20 times
Same Date appears 100 times ; Month/Date/Year A6 - 1/01/2020 to A19500 - 5/18/2020
Sheet 3 is Formula area;
=VLOOKUP(A6,'QLD RESULTS'!A:A,1,FALSE)
=VLOOKUP(A6,'QLD RESULTS'!A:B,2,FALSE)
=VLOOKUP(A6,'QLD RESULTS'!A:B,2,INDEX($A$6:$A$20000,MATCH($A6,$B$6:$B$20000,0)))
=INDEX("RESULTS!A",MATCH(1,('QLD RESULTS'!A=A6)*('QLD RESULTS'!A=A6)*1))
Some of the above formula's tried.
Can you help in the right direction in what type of formula to start?
Regards
Tony
hi Oscar,
I m trying to find vba for copying data from (varying cells) from sheet1 to sheet2 (save all data in one row) and assign an ID number. So that i can retrieve data from sheet2 to sheet1 (same cells used for input data) using ID number.
Please help me..
Thanks and Regards,