Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Array Formula

  Asked By: Adelfried    Date: Sep 21    Category: MS Office    Views: 1013
  

My hobby in Excel is producing League tables,a little time ago in
order to use a Vlookup function I needed Rank my League table
Sequentially (no duplicate values). I used an Array formula I found on
the Microsoft Knowledge base. I won't bore you with the actual formula
which is a long one which works wonderfully, but the answer always
comes up in the function box as "Volatile".anyone knows what this
means? as I say I use this formula often but I don't understand it,so
I decided to use the formula audit so it would take me through it bit
by bit, this caused excel to shut down. I tried it again, same result,
I presume tis is some thing to do with the answer being "Volatile" but
can anyone explain?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Array Formula Or get search suggestion and latest updates.




Tagged: