Good Afternoon. Your videos have nice practical and applicable topics! Can you advise on the formula / process for this problem. I am trying do create a sheet to track accepted quotes for a project. ie. if I receive a quotation for a product, and add the details to one column in my spreadsheet, I input the quote total in another column. In another column I have a drop down list with options 'accepted / rejected / pending'. Only when accepted is chosen will he amount reflect in the total column. Thanks, Brenda
Hello, I have to compare two separate sheets for reconciliation. (Invoice number & amount) in sheet 1 vs (Invoice number & amount) in sheet 2 Do you know any formulas for that?
Good Afternoon.
Your videos have nice practical and applicable topics!
Can you advise on the formula / process for this problem.
I am trying do create a sheet to track accepted quotes for a project. ie. if I receive a quotation for a product, and add the details to one column in my spreadsheet, I input the quote total in another column. In another column I have a drop down list with options 'accepted / rejected / pending'. Only when accepted is chosen will he amount reflect in the total column.
Thanks, Brenda
Hello,
I have to compare two separate sheets for reconciliation.
(Invoice number & amount) in sheet 1 vs (Invoice number & amount) in sheet 2
Do you know any formulas for that?
For MS 365 can't you spill the results by selecting all the criteria values?