Last edited by Gerhard.Angeles; 04-13-2014 at 10:35 PM.
Put in F2:
Array Formula, you need to press CTRL-SHIFT-ENTER button together when implemented the formula...
and copied down to F3...
Last edited by azumi; 04-14-2014 at 04:26 AM.
Here's another possibility.
This array formula** entered in F3 and copied down as needed:
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)