jcurtis260
New Member
- Joined
- Jan 21, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi All,
I have a power Automate flow setup that pulls an excel spreadsheet and then inserts data into the "import" Tab, However, on the other sheets I have formulas that change values. Is there a way to lock these down?
This formula in Excel seems to move when data gets added to the import tab.
It was orginially set to "=UNIQUE(FILTER(Import!$D$2:D10053,Import!$D$2:D10053<>""))"
I have a power Automate flow setup that pulls an excel spreadsheet and then inserts data into the "import" Tab, However, on the other sheets I have formulas that change values. Is there a way to lock these down?
This formula in Excel seems to move when data gets added to the import tab.
It was orginially set to "=UNIQUE(FILTER(Import!$D$2:D10053,Import!$D$2:D10053<>""))"