Excel Formula or VBA???
 

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

Excel Formula or VBA???
 

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/

Excel Formula or VBA???
 

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/

Excel Formula or VBA???
 

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

Excel Formula or VBA???
 

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/

Excel Formula or VBA???
 

The formula is in the top of this post

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

Excel Formula or VBA???
 

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/

Excel Formula or VBA???
 

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