I love xlookup, but I thought it stopped when it hit the first instance, rather than carrying on down the column?
isn't that where countif or sumif with xlookup becomes useful?
I'm.a bit rusty after 6 months out the game so may be wrong.
@rhb started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
I love xlookup, but I thought it stopped when it hit the first instance, rather than carrying on down the column?