About me
My name is Oscar Cronquist and I live in the south of Sweden. I created this website and I write articles about Microsoft Excel. I created the Excel formulas, attached workbooks, tutorials, and some of the videos on this website unless otherwise stated. Most website visitors come from the United States, UK, Australia, Canada, and India.
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, SKF 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. This is because the gulf stream brings warm water from the Gulf of Mexico into the Atlantic Ocean. The climate here would be like Siberia in Russia or northern Canada if the Gulf stream was taken away.
Interesting facts about the Swedish language that most English speaking people don't know about.
Swedish is a language that share a lot of words with English, German, Dutch, Danish, Norwegian, and more. At least, often there is some resemblance. Here are some examples between English and the Swedish language:
English - Swedish
stone - sten
tree - träd
water - vatten
blue - blå
green - grön
white - vit
ice - is
nose - näsa
finger - finger
arm - arm
foot - fot
toe - tå
ice berg - isberg
metal - metall
wind - vind
Here are some words that differ:
mountain - berg
chair - stol
party - fest
sun - sol
eye - öga
light - ljus
tarmac - asfalt
Both English and the Swedish language originate from the proto-Germanic language spoken in north Germany and Scandinavia around 2000 years ago.
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,