Hi Rune,
Am Fri, 15 Nov 2013 07:11:54 +0000 schrieb RuneVSP:
Ive tried to copypaste the minimum formula but i get an error and as i
do not understand the offset nor the match function i dont know how to
correct it. Excel mark the "$A$1,MATCH" part of the formula so guess
this is where the problem is. Do you know how to correct this.
I think that is a problem with formula translation or with the
seperators.
Have a look:
https://skydrive.live.com/#cid=9378A...121822A3%21326
for the workbook "Average"
Arguments of OFFSET
1. start cell
2. offset in rows
3. offset in columns
4. height in rows
5. width in columns
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2