GAH! I really need to stop attempting to do things when I'm sick. thanks. I will have a question in a minute.
Last edited by Cyberpawz; 02-03-2012 at 10:05 AM.
Ok, I need to know one thing, why do the {} work? Also, why do they disappear when I click to edit? I'm just glad it works thanks.
Hi
Disappear: When you go into edit mode, you have the raw formula to work with. If you want to remove things from array mode, then you just press enter. Otherwise you have to specificall enter array mode.
Why work: Hmm. Its not the {} that make it work. That is just how the array formula is displayed. Not sure I can really explain it. When the formula processes, it brings back multiple results. In normal mode, only the first result is available. There are some instances where a formula will work on the first result whether it is array entered or not. To access the subsequent entries, you need to array enter the formula. That said, there are various base formulas that do action multiple results without being array entered. SUMPRODUCT is one. COUNTIFS is another (2007). If you write your own function (ie a UDF), you can action multiple items, and bring back a single result, without the function being array entered. A common one is written if you have multiple items that match your criteria, and you want to concatenate the results.
There will be more qualified / knowledgeable posters out there that may be able to give a more technical answer. Hopefully some of them will read the post and respone.
Did a quick google search and amongst the many results came back with this from Chip Pearson.
Does that help?
rylo
Last edited by rylo; 02-03-2012 at 03:14 PM.
Somewhat, thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks