I need help building a formula
I have a sheet where I have different alpha numerical items listed such as F556 L, and F557 G, as these are completed I want the completed alpha numerical placed in a second column and then a third column that subtracts the second column from the first leaving only the items that are not in the completed column.
My current formula is (=[Outstanding Tags]@row, "Text"-[Cleared tags]@row, "Text"). which is unparseable. This is because it is subtracting mixed numerical and alpha text but I want it to show only F551 A when it works correctly. Do I use a collect formula for this or is there another way?
Help Article Resources
Check out the Formula Handbook template!