-
Lookup with duplicates in first column and not much to go on
We have a table with two columns A and B with lot of duplicates in the first one. We want to lookup these Id's in another table with columns E and F also with a lot of duplicates in E. For the sake of clarity I put the two tables on one sheet.
Headlines
-
Weekdays and parking ratesWe have multiple weekday abbreviations in one cell and want to SUM some parking rates of the day. -
Tekstbestand lezen en elke regel afdrukkenMet Excel kun je een tekstbestand lezen en het resultaat in het werkblad zetten. Dit doe je door VBA te gebruiken. Visual Basic for Applications (VBA) is een eenvoudige programmeertaal. Je hoeft geen verstand te hebben van die programmeertaal. Gewoon onderstaand verhaal opvolgen. Het zijn 3 uiterst simpele voorbeelden.
-
VLOOKUP & MATCH Two-Way Lookup Country & Capitals to get informationInside the VLOOKUP function, the column index argument is normally hard-coded as a static number. However, you can also create a dynamic column index by using the MATCH function to locate the right column. -
MH17: Australia and Netherlands accuse Russia of complicityForeign minister says Australia will seek financial compensation from Moscow -
'I'm not sorry I said it': Erykah Badu on music, motherhood and wildly unpopular opinionsThe neo-soul star has sold millions, raised three kids and embodied wokeness before the word was even coined. But can her reputation survive January’s ‘I saw something good in Hitler’ comment?
Spotlight
-
NBA playoffs:Record-setter LeBron James scores 44 as Cavaliers level series with CelticsCleveland beat Boston 111-102 in NBA Eastern Conference finals. Series is now square at 2-2 as teams head to Boston for Game 5. LeBron now has most field goals in NBA playoffs history -
Chloë Sevigny: ‘I didn’t want to name names. I think they’re commonly known as assholes anyway’More than 20 years ago, the actor was anointed ‘the coolest girl in the world’. As her new film opens, she talks about A-list movie stars hogging the best TV roles and why she chose not to add her voice to #MeToo
The Start
-
This site is an experimental testcase to approach The Guardian container/grid layoutRead moreUnlimited flexibility
Opinion
-
Bolts from the blue: readers' photos on the theme of stormwe asked you to share your photos on the theme of storm via GuardianWitness. Here’s a selection of our favourites -
Gig review: MARTIN TURNER – 100 Club, London, 14 October 2017Turner's only London show. He'll be performing Wishbone oldies with his new band, followed by a second set where they'll play the 1972 'Argus' LP in full.
-
This revolution in our understanding of depression will be life-transformingThe discovery of genes that are linked to the crippling condition throws up exciting new possibilities for its successful treatment -
Top 10 codes, keys and ciphersKevin Sands, author of The Blackthorn Key, picks his favourite keys, codes and ciphers throughout history, from the Caesar shift to the Enigma machine -
12 of the best beach towns in southern EuropeQuiet islands, Venetian harbours, sumptuous seafood and golden sands … these seaside towns in France, Spain, Italy, Croatia, Greece and Portugal are ingrained with the spirit of summer -
Fleetwood Mac duet album to be releasedFormer members Lindsey Buckingham and Christine McVie return with their duet album in May, which will feature John McVie and Mick Fleetwood
Sport
-
Finland to end basic income trial after two yearsGovernment rejects request for funds to expand scheme and plans stricter benefits rules -
Critics fear bequest will fuel new wave of fanaticism among those who continue to revere the German propagandist and neo-Nazi icon
-
-
Thanks to the success of Spotify, big stars from Ed Sheeran to Fleetwood Mac are cashing in, while even artists in niche genres such as Danish cloud rap are flourishing, sometimes without record labels. Is this unexpected revival here to stay? -
Modigliani sets world record with estimate in excess of $150m
-
-
Culture
-
-
Menopause I find my husband’s sexual advances off-puttingHe uses my feet to masturbate – but as it’s the only regular pleasure he gets from me, I grin and bear it -
China's Weibo reverses ban on 'homosexual' content after outcryMicroblogging site’s move to create ‘harmonious’ environment prompted protests under the hashtag #Iamgay
-
-
Lifestyle
-
Do video games make children violent? Nobody knows – and this is whyDo video games make children violent? Nobody knows – and this is why -
As Time Goes By – life in the Beatles’ magic circleA new edition of the memoir by the band’s amiable press officer who witnessed Beatlemania and took notes as the breakup happened -
Delete your account – a guide to life after FacebookPerhaps you think you can’t possibly replace the social network – but it can be done. Here’s what you need for a Zuck-free existence
Around the world
-
Want to be more assertive in life? This former dominatrix will show you howWant to be more assertive in life? This former dominatrix will show you how -
Skripals poisoned from front door of Salisbury home, police saySpecialists report highest concentration of nerve agent at home of Russian spy -
Explore
-
Pitting giant mechs against alien bugs, this winningly focused post-apocalyptic spree eschews resource management in favour of living moment by moment -
Tory links to Russia and Saudis run deep. So where’s the outrage?Never mind ‘Corbyn the spy’, our governing party pockets millions from regimes that back extremism – and gets away with it -
Europe is facing a potential crisis in the Balkans. It has to act soonThe promise of EU membership for states in the region is welcome, but Russia, China and Turkey could create instability
Securedrop
-
Jessica Jones: season two reviewThe finale of season one set the bar high – but a slow and flabby start to the second is slightly worrying. Netflix’s difficult second outing for its mould-breaking superhero. -
Is cannabis the answer to older people’s booze problems?Baby boomers and Generation X-ers, take note: mindful drinking is not the only solution to mindless drinking. -
For Gibraltar the EU was an escape hatchAs long as Britain remained in the European Union, questions of empire and identity could be fudged. Brexit changes everything. -
Monster Hunter: World review – in hot pursuit of the beast withinMonster Hunter: World review – in hot pursuit of the beast within in hot pursuit of the beast within
Monster Hunter has always been a series that offers much and more. Its games are, broadly speaking, action-RPGs built around a single gameplay loop.
In pictures
-
Picasso 1932 review – horror and beauty collide in Pablo's fastest, wildest yearFrom his wife to his lover, from phallic-faced women to Christ in a nappy, this giddying exhibition captures the furious pace Picasso worked – and lived – at. -
Farewell to NME: a rock'n'roll riot that petered into silenceThree Billboards Outside Ebbing, Missouri, the bleak, bitter, blistering comedy about injustice in small-town America, took the major honours at the 2018 Bafta film awards on Sunday night.
-
The best new Android and iPhone games for 2018Be a neighbourhood god in The Sims Mobile, a Viking hero in Oddmar or start a craft beer empire in Brew Town. Along with Fortnite, Evoland 2, Trick Shot 2 and more new mobile games to try -
Farewell Penny Dreadful, you "great fertile bitch of evil"Farewell Penny Dreadful, you "great fertile bitch of evil" -
Disillusioned with Game of Thrones? Try Penny DreadfulShowtime’s macabre Victorian yarn might not have had the same fanfare of its HBO peers but its layered pulp burlesque shtick is well worth a watch. -
Ryanair chief: we won't bow to laughable demands from pilotsThe Ryanair chief executive, Michael O‘Leary, has warned that the airline will not bow to “laughable” demands from pilots and would rather see strikes or disruptions than undermine its productivity.
Most viewed
Create a unique and dynamic list