I’m trying to create a VBA formula and not macro that picks the “ID’s” instead of “-” (dashes). The image below is an example of what I’m trying to do, for each row I want to pick the ID (number or text, written in cells where there aren't dashes).
In other words, I need a formula that picks ID from a selected row (i.e. [F17:P17]). The formula will delivery the value of the cell that doesn't contain “-”.
IF(logical_test;”pick a ID (number or text)”;”-”)
Unfortunately there’s not a formula that does the opposite job as
IF, kind of
IFNA doesn't help either.