View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
XL comp. XL comp. is offline
external usenet poster
 
Posts: 1
Default 3-dimensional matrix

I am trying to create a 3 dimensional matrix. The following is an example.

I am trying to distribute $100,000 amognst 234 employees equitably amongst 4
levels, (VP, AVP, Director, Manager) based on 4-Performance Ratings, (1-
Excellent, 2-Very Good, 3,-Good, 4-Fair) and based 4-Market Lag buckets (Over
-50% lag, -26% to -49%, -1% to -25%, No lag).

Any tips ?
Thanks