MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Array Formula

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

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?



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.