I did use that formula, but I do not understand what you mean b
(entered using control shift enter.) When I copy that formula into th
spreadsheet, it gives me a #value error. When I changed the cel
references to the cells I actually am using in my real spreadsheet, i
gives me this error. And when I press the control, shift and enter key
nothing happens. I am not a novice using Excel, but I am a novic
understanding an array, and an array formula. Can you be more specifi
with your instructions??? If not, I do appreciate what you did tell me
And thank you Frank from Germany

--
Message posted from http://www.ExcelForum.com

Hi
copy this formula in your formula bar but instead of hitting ENTER in
your formula bar to finish the formula entry hit CTRL+SHIFT+ENTER
together.

See
http://www.cpearson.com/excel/array.htm
for more information about array formulas


--
Regards
Frank Kabel
Frankfurt, Germany


I did use that formula, but I do not understand what you mean by
(entered using control shift enter.) When I copy that formula into
the
spreadsheet, it gives me a #value error. When I changed the cell
references to the cells I actually am using in my real spreadsheet,
it
gives me this error. And when I press the control, shift and enter
key, nothing happens. I am not a novice using Excel, but I am a
novice
understanding an array, and an array formula. Can you be more
specific
with your instructions??? If not, I do appreciate what you did tell
me. And thank you Frank from Germany.


---
Message posted from http://www.ExcelForum.com/

Normally, you type the formula in, and then press the Enter key to commit
it.

But with an array formula, you type it in, and then commit it by pressing
Ctrl-Shift=Enter (all 3 keys) at the same time.If you have done it
correctly, in the formula bar the formula will look like

{=IF(A1=17,"Yes","No")}

that is with the curly braces around it (but with your formula of course).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"union865kri " wrote in message
...
I did use that formula, but I do not understand what you mean by
(entered using control shift enter.) When I copy that formula into the
spreadsheet, it gives me a #value error. When I changed the cell
references to the cells I actually am using in my real spreadsheet, it
gives me this error. And when I press the control, shift and enter key,
nothing happens. I am not a novice using Excel, but I am a novice
understanding an array, and an array formula. Can you be more specific
with your instructions??? If not, I do appreciate what you did tell me.
And thank you Frank from Germany.


---
Message posted from http://www.ExcelForum.com/

When I use your formula, it does not give me the answer that I get whe
doing it manually. For example, starting in cell A1, when I have
blank cell, and then another blank cell, and then a 40, then a blan
cell, then a 41, then a 45, then a 42, and then a 48, it should not us
the 40, nor the 48 and then calculate the other 3 numbers. If you d
this, it should give me a 5.4 answer. Do you have any idea why thi
happens???? Also, if those are the only numbers in this cell reference
such as the rest of the cells are blank also, then I get a #num erro
answer. And, remember, I do thank you for helping me

--
Message posted from http://www.ExcelForum.com

Without seeing your formula, it's hard to comment.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"union865kri " wrote in message
...
When I use your formula, it does not give me the answer that I get when
doing it manually. For example, starting in cell A1, when I have a
blank cell, and then another blank cell, and then a 40, then a blank
cell, then a 41, then a 45, then a 42, and then a 48, it should not use
the 40, nor the 48 and then calculate the other 3 numbers. If you do
this, it should give me a 5.4 answer. Do you have any idea why this
happens???? Also, if those are the only numbers in this cell reference,
such as the rest of the cells are blank also, then I get a #num error
answer. And, remember, I do thank you for helping me.


---
Message posted from http://www.ExcelForum.com/

The formula is in the top of this post

--
Message posted from http://www.ExcelForum.com

Sorry, but not in the thread I see. The thread starts with a reply to Frank,
not with your original posting. It would have been very easy to re-post.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"union865kri " wrote in message
...
The formula is in the top of this post.


---
Message posted from http://www.ExcelForum.com/

It does show up in the posts that I read, but since it isn't in the on
you ar reading, I'll add it.

=((LARGE(OFFSET(R1,0,0,1,-(COLUMN(R1)-LARGE(IF(A1:R1<"",COLUMN(A1:R1))
,5)+1)),2)+LARGE(OFFSET(R1,0,0,1,-(COLUMN(R1)-LARGE(IF(A1:R1<"",COLUMN
(A1:R1)),5)+1)),3)+LARGE(OFFSET(R1,0,0,1,-(COLUMN(R1)-LARGE(IF(A1:R1<"
",COLUMN(A1:R1)),5)+1)),3))/3 -36)*0.9

If you have any ideas, I do appreciate it. Thanks again

--
Message posted from http://www.ExcelForum.com