hi there,
if you are satisfied with azumi's Method 1 approach, then here is a much simpler way of achieving that, with far fewer moving parts. pay attention to the notes within.
UPDATED for extended ranges, without need for Conditional or General formatting...
Last edited by icestationzbra; 04-20-2014 at 02:26 PM.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks