Forum Discussion
Data Triggers
I'm relatively new to spreadsheets and excel. I'm working with a spreadsheet for mileage allocation. The mileage is funded from a single source but allocated to several people. In the spreadsheet, ...
I asked Copilot and it gave me a formula that works perfectly. I must say I am surprised, Copilot worked right in my spreadsheet to fix my request. For anyone who wants to know, the formula I ended up with is
=IF(TRIM($G6)=H$1,$E6,"")
no further responses needed. thank you.