WORKSHEET FORMULA TIPS

Excel allows you to make 3D formulas based on the following syntax:

However, the functions that can actually use that syntax are limited

(although not as limited as the Excel documentation would lead you to

believe). I put together the following list of functions that represent

most, but probably not all, of those that are 3D-enabled:

AVERAGE, AVERAGEA, COUNT, COUNTA, MAX, MAXA, MIN, MINA, PRODUCT, STDEV,

STDEVA, STDEVP, STDEVPA, VAR, VARA, VARP, VARPA, SMALL, LARGE, RANK,

MEDIAN, PERCENTILE, QUARTILE, TRIMMEAN, SKEW, AND, OR, AVEDEV, DEVSQ,

SUMSQ

BTW, If you create a defined name for this type of 3D range, be sure to

group all of the sheets in that range if you decide to insert any rows

into the area bounded by that range (if you want your 3D range to reflect

the insertion of that row).

**Editor’s Note:** See Summing in 3D for an example.

You left out NPV. The fact that NPV also accepts 3D references as 2nd or subsequent arguments implies that Excel has a well-defined iteration order between cells in 3D ranges.

That said, it’s truly bizare that MODE doesn’t accept them.

need to make a 3d or bar graph with excel tipe of read i get 0.001

0.002

0.001

if this is the source file;

apple 1

apple 2

apple 3

banana 2

banana 1

orange 1

orange 3

than using formula in excel,i want the result;

apple 1 2 3

banana 1 2

orange 1 3

someone help please…