Hi all,
I am having trouble putting together a formula and I am hoping someone here can guide me in the right direction.
We have a sheet that we enter payments we receive from our customers. That sheet has the customer name, check date, deposit date and amount etc.
I am looking to create a sheet that can give me the latest deposit date as well as the amount of the payment. I was able to get the latest deposit date by creating a new sheet with a list of our customers and using the formula MAX(COLLECT({Posting Checks Deposit Date}, {Posting Checks Customer}, [Primary Column]1)) where primary column 1 is the list of customers I put in column A.
I am looking for a way to be able to pull the deposit date which is on a different column but the same row.
I was also wondering if there is a way to take the data from a drop-down list (the list of customers) and have it auto populate on this sheet with the latest deposit dates and check amounts so we don’t have to add it manually each time we get a new customer.
Thank you in advance!