Microsoft's senior product manager for Excel acknowledges that "Throughout Excel's 40-year history, you've only been able to put one value per cell." But that's now changing with arrays in cells (as well as nested arrays) and lists.
"You can create a list by selecting Insert > List or pressing Ctrl+J, then typing or pasting items separated by commas or semicolons, depending on your regional settings. Selecting the icon in the cell shows the individual values..."
"With lists, you can filter by one or more individual items instead of whole text entries. Referencing a list returns all its values for calculations. For example, =B2 spills those values into separate cells..."
"For the first time in Excel, arrays can exist natively in cells as values or as formula results. They can be any size or shape and can even contain other arrays. You can now keep the result of any spilling formula in a single cell by "wrapping" the formula body with braces { }."
"Since the introduction of dynamic arrays, array results have spilled across cells — for example ={1;2;3}. Wrapping the original array with braces creates a 1x1 array around it, so instead of spilling to multiple cells, the array stays in a single cell. Braces have long been used to describe arrays in Excel and this extends that behavior by allowing multiple layers of braces. This gives you more flexibility when building spreadsheets. Instead of leaving room for a formula to spill, you can keep the result in one cell."
"Arrays can now also 'nest' inside other arrays... Previously, a formula that produced an array of arrays would return a truncated result or #CALC! error. Now, supported formulas return the complete nested result... FLATTEN(array, [pad_value], [levels]) simplifies nested arrays by removing one or more levels of nesting..."
Three HAS functions check whether values are in an array:
— HAS(array, value) returns TRUE if value appears anywhere in array, and FALSE otherwise.
— HASANY(array, values) returns TRUE if any of the values appear anywhere in array, and FALSE otherwise.
— HASALL(array, values) returns TRUE if all of the values appear anywhere in array, and FALSE otherwise.
DE WILP (ANP) - Bij een buurtbarbecue in het Groningse De Wilp zijn zaterdagavond meerdere mensen gewond geraakt door een steekvlam. Volgens omstanders die met Dagblad van het Noorden spraken, liepen acht mensen brandwonden op. Twee van hen zijn naar het ziekenhuis gebracht.
De twee zouden ernstig gewond zijn. Andere slachtoffers werden in nabijgelegen woningen onder de douche gekoeld. Op beelden is te zien dat meerdere ambulances en politie-eenheden ter plaatse kwamen. Ook werd een traumahelikopter ingezet.
De steekvlam ontstond volgens de krant mogelijk nadat iets op het vuur was gegooid. De politie heeft een jerrycan in beslag genomen.
TEHERAN (ANP/RTR) - Iran houdt vol dat alleen diplomatie een einde kan maken aan het conflict met de Verenigde Staten en Israël. De Amerikaanse president Donald Trump zei zaterdag een Iraans voorstel voor heropening van de Straat van Hormuz en beëindiging van de gevechten te hebben afgewezen.
"Onze voorwaarden zijn duidelijk en elke stap richting heropening van de Straat van Hormuz hangt af van het voldoen aan die voorwaarden", schreef de Iraanse minister van Buitenlandse Zaken Abbas Araqchi op sociale media. Volgens hem kan alleen een onderhandelde oplossing de impasse doorbreken.
Iran presenteerde deze week tijdens de Algemene Vergadering van de VN een vredesvoorstel, dat via Qatar aan de VS zou zijn overgebracht. Trump zei dat Iran een akkoord wil omdat het land er slecht voorstaat.
Volgens Araqchi hebben bemiddelaars Iran nog geen officiële Amerikaanse afwijzing meegedeeld. Iran wacht daarop voordat het een besluit neemt.
NEW YORK (ANP) - De Europese Commissie trekt bijna 710 miljoen euro uit voor ontheemden in Afrika en mensen die elders in de wereld door crises zijn getroffen. Commissievoorzitter Ursula von der Leyen maakte dat zaterdag bekend in New York, waar de Algemene Vergadering van de Verenigde Naties bijeen is.
Van het bedrag gaat 380 miljoen euro naar onder meer de bescherming van migranten, vrijwillige terugkeer en opvang van vluchtelingen in Afrika. Daarnaast is 10 miljoen euro bestemd voor vredesinitiatieven in het Grote Merengebied en 7,5 miljoen euro voor de bestrijding van ebola in Congo.
Brussel wil ook 252 miljoen euro uit de noodhulpreserve vrijmaken: 97 miljoen voor Afrika, 103 miljoen voor de Palestijnse gebieden en Libanon en 52 miljoen voor Oekraïne. Daarvoor is nog goedkeuring nodig van de begrotingsautoriteit. Ethiopië krijgt verder 60 miljoen euro om de eerstelijnszorg te verbeteren.
Weer voor de stad Rotterdam
Deze bot wordt beheerd door het FediMeteo-project.
Voor informatie en contact kunt u de pagina https://fedimeteo.com raadplegen.
Demi Vollering (29) is de beste wielrenster ter wereld, maar de regenboogtrui winnen lukte haar nog nooit. In een van de mooiste en spannendste koersen van de afgelopen jaren maakte de Nederlandse kopvrouw in Montreal dan eindelijk haar status als topfavoriet waar. „Ze wilde het afmaken voor de ploeg.”
Welcome back to the Abstract! Here are the studies this week that sailed alien seas, beat the heat, went retro, and got caught in the food web.
First, scientists make the case that Saturn’s moon Enceladus could resolve one of humanity’s greatest questions—are we alone in the universe?—if only we would just send a spacecraft there already. Then: an amoeba in hot water, a backwards-ass planet, and the prandial ouroboros we call life on Earth.
In a double-whammy pair of studies, scientists have offered more proof that Enceladus—the tiny moon of Saturn—might host alien life, and that it would be relatively easy to find out for sure.
Enceladus is only 300 miles in diameter, but it contains marine multitudes. Underneath its outer ice shell, the moon hosts a subsurface ocean and hydrothermal vents on its seafloor, which are hotspots of life here on Earth.
What’s more, Enceladus squirts out watery plumes from its ocean through geysers on the surface, which can be sampled by passing probes. Indeed, the Cassini spacecraft—which orbited Saturn from 2006 to 2017—ran through this space sprinkler several times, providing our first taste of an extraterrestrial sea. However, that mission was not equipped to detect signs of life, known as biosignatures.
In the first of two new studies, researchers created a simulated version of Enceladus’s “soda ocean” (meaning it is alkaline and carbonate-rich). The team then dropped the heat-loving microbe Methanothermococcus okinawensis to live in this earthly ersatz Enceladus. This species was selected because it lives on deep-sea hydrothermal vents on Earth.
Plumes on the surface of Enceladus. Image: NASA/ESA/Cassini
It turned out that M. okinawensis fared even better in this habitat than expected, a discovery that potentially widens “the habitability window of Enceladus’ subsurface soda ocean,” said researchers led by Vanessa Helmbrecht of Ludwig-Maximilians-Universität München.
In the other study, a team revisited Cassini’s observations of ice grains sprayed out into space by Enceladus. They discovered that the ocean droplets freeze slowly in space, causing organic molecules to separate out into concentrations of similar compounds. If these droplets contain biosignatures, they may be conveniently pre-sorted for any instrument that captures them.
“In the plume grains, each separated compound can then be found at strongly elevated concentrations in a relatively small fraction of ice grains,” said researchers co-led by Frank Postberg and Zenghui Zou of Freie Universität Berlin. “This is good news for future plume sampling missions investigating Enceladus’ promising habitability provided that they can sample and analyze ice grains individually.”
For years, mission concepts to Enceladus have been floated but never formally greenlit, including NASA’s Enceladus Life Finder or the European Space Agency’s L4 mission. Hopefully, something gets off the drawing board and into space eventually, because Enceladus is low-hanging fruit, astrobiologically speaking.
Speaking of weird heat-loving microbes, meet Incendiamoeba cascadensis, a newly discovered amoeba that has shattered the heat tolerance record for eukaryotic life.
Incendiamoeba cell undergoing mitosis at 63ºC. DNA is colored blue, tubulin is pink, and membrane is gray. Image: Felix Mikus
Scientists found this novel species simmering in water temperatures exceeding 64°C (147°F) inside Hot Springs Creek at Lassen Volcanic National Park in California (for reference, the average hot tub is around 100°F). While simple “procaryotic” organisms can survive much hotter water—the microbe Methanopyrus kandleri tops out at a balmy 252°F—the upper thermal limit for more complex “eukaryotic” lifeforms was previously thought to be 60°C (140°F).
“Incendiamoeba cascadensis proliferates at temperatures beyond what was thought possible for any eukaryote,” said researchers led by Beryl Rappaport of Syracuse University. “This discovery raises questions about the true maximum temperature a eukaryotic cell can endure.”
If a human were exposed to these water temperatures, they would suffer third-degree burns in seconds—so let the amoebas have their win and leave the deadly hot springs to them.
If you’ve been feeling like the vibes are off, it’s probably because the planet GJ 3090 b is in retrograde—permanently. This world, which is about 4.5 times as massive as Earth, is the “first planet on a retrograde orbit discovered around an M dwarf,” a type of small star more commonly known as a red dwarf, according to a new study.
In our solar system, the concept of a planet being “in retrograde” refers to the optical illusion of planets appearing to move backwards in their orbits from our perspective on Earth. But GJ 3090 b is actually orbiting in the opposite direction of the rotation of the star, which is located 60 light years away.
Exoplanets with similar retrograde orbits have been observed before, but GJ 3090 b is distinct because there is no massive object (a star or planet) in the system that seems to have set it into reverse. Most retrograde orbits are caused by gravitational disruptions from such colossal companions, but this exoplanet may have just been born this way—meaning that it formed from a disk of material that was out-of-whack from the jump.
“Whereas highly misaligned orbits are commonly attributed to gravitational interactions with a massive companion, the architecture of the GJ 3090 system instead favors a primordial misalignment of the protoplanetary disk,” said researchers led by Yann Carteret of the University of Geneva.
The discovery is a reminder that star systems take on a wild variety of configurations shaped by countless interactions and factors. Contrary to the proverb, there is something new under every sun.
From the simplest microbe to the mighty blue whale, all life on Earth has one thing in common—we gotta eat. But given the dazzling complexity of food webs around the world, it can be tough to track what species end up in what bellies (or belly-equivalent) out in the wild.
That’s a problem that scientists are now inviting the public to help solve with the new online database: Who Eats Whom? In a partnership with the popular platform iNaturalist, the tool has catalogued some 14,000 observations of food-web interactions captured by nearly 2,000 observers from more than 100 countries, according to a new study about its progress.
“Who Eats Whom is, to our knowledge, the first attempt to create a global food web derived specifically from verifiable citizen science photographs,” said researchers led by Bradley C. Allf of Colorado State University. “Beyond our scientific goals, we are designing the project as a tool for education and public engagement in science.”
You can search for specific animals in the database (for example, searching for the red fox reveals a brave Australian python-eater, as well as this excruciating picture of the last moments of an Eastern chipmunk in Ontario with the caption: “not a great day”). I was also delighted to learn that coyotes, in addition to chasing down prey, apparently go on persimmon binges that leave behind seed-filled scat.
To get a sense of the bigger picture, you can check out this interactive global food web of species. We are, after all, what we eat—and what we eat eats, and so on forever.
Preparation begins for extreme conditions as Nolo bears down on areas still recovering from previous storms
Heavy rain and powerful winds are expected to bring flash floods and extreme surf to the Hawaiian islands over the weekend as Hurricane Nolo bears down on areas still recovering from previous storms.
Nolo was churning slowly south of Hawaii’s Big Island on Saturday with maximum sustained winds of 105mph (165km/h). The storm’s center was about 145 miles (235km) south of Hawaii’s southern-most point and could strengthen into a potentially life-threatening and catastrophic storm through the weekend.
Alex de Minaur recovers from match point down to beat Alexander Zverev
Carlos Alcaraz launches comeback of his own to leave event level at 5-5
For much of his afternoon on court against Alexander Zverev, Alex de Minaur seemed destined to end his day with an excruciating defeat. De Minaur had rapidly found himself down a set and a break, then Zverev served for the match at 6-2, 5-4. After miraculously giving himself another lifeline, De Minaur finally faced a match point at 8-9 in the final set tie-break.
No matter how grim the scoreline appeared, though, every effort he made was punctuated by roars of approval from one person in particular. There were loud screams of encouragement, pounding of chairs and stamping of feet. At one point, as doubt had crept into Zverev’s game during the second set tie-break, that unmistakable voice from the sidelines yelled out: “Check his oil! Check his oil!”
ScienceBites' mission is to build a network of bites sites.
Every bites site shares the same concept. They publish short digestible bites posts about individual research papers, making cutting-edge science accessible to a wide audience.
Through its role in science communication, ScienceBites also wants to clearly state its core values of tolerance and anti-racism.
Dear Lazyweb, please help me figure out why OBS keeps doing this crazy thing where sometimes audio goes into slo-mo dubstep glitch mode. Sometimes switching inputs fixes it. Sometimes only "sudo killall coreaudiod" fixes it. Here's what it sounds like. It seems to be doubling the spacing of the frames, and the buffer is infinite.
Even worse is that my check-volume.pl script fails to detect it much of the time. On this particular TS file it reports "glitchy: 27.4 dropouts/sec over 6.2 secs" but when scanning the live .m3u8 stream it often misses it.
Macmini9,1 macOS 14.8.7, OBS 32.2.2. OBS is reading audio and video from a Kiloview E1 NDI. Audio Hijack 4.6.0, but it "shouldn't" be involved in this?
/s3/static.nrc.nl/wp-content/uploads/2026/09/26221109/Wielrennen-WK-v_77099763.jpg)
