hi all.
This been stumping me for a while. i have two reports that i can put on one sheet.
left report has a list of time, invoice number and amount for that invoice and on the right i have a list of data credit card entries
i can write a xlookup that takes data from right and check it on the left , but . if there is a gap between the invoices and day, i dont
know how to write the formula to skip the blank and to manually adjust the size of the query everytime for xlookup takes ages.
i will attach sample.
Running business 365 excel. so items like uniquee will work.
Thanks
chris.
Bookmarks