Want to filter same texts from 2 lists in google sheets
I have 2 lists One is equipments lists and other is summary of the equipments lists in one sheet
Summar list is sum of equipments which are repeated,
like if you have chalks 2 no, chalks 2 no, duster 1no, board 3 no
summary list is chalk 4 no, duster 1 no, board 3no.
How do I use xlookup in dynamic range?(spreadsheet)
First Sorry for the bad English.
I have a data with A, B, and date.(For exampe name, salary)
I want to search B based on A, but here’s the problem.
There are multiple Bs matched to A, and since xlookup brings the first match, sometimes it brings wrong data.
Thankfully, my data is sorted by date. And so this is what I want to do.