Sort them then add and of formula? =if(b1,a1,1,0) then paste values and sort by that column anything with a 0 won't be duplicated.
Is that what you mean?
@spenceey 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.
Sort them then add and of formula? =if(b1,a1,1,0) then paste values and sort by that column anything with a 0 won't be duplicated.
Is that what you mean?