Easiest way I can think of is with helper columns, like in the attached. If you really need it all in one formula, that formula will be long (unless someone else comes up with a better idea), but it is possible.
Easiest way I can think of is with helper columns, like in the attached. If you really need it all in one formula, that formula will be long (unless someone else comes up with a better idea), but it is possible.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks