| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with the syntax for using range name in a formula?
I have --------=+AVERAGE(SMALL(B7:B19,{1,2,3}))-------------. I want
to replace B7:B19 with “Myrange” but I can’t seem to get the syntax right. excel says error in formula. Thks in advance for any help BRC |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with the syntax for using range name in a formula?
Hi
=AVERAGE(SMALL(Myrange,{1,2,3})) have you created Myrange? have you spelt it correctly? -- Regards Roger Govier "BRC" wrote in message ... I have --------=+AVERAGE(SMALL(B7:B19,{1,2,3}))-------------. I want to replace B7:B19 with “Myrange” but I can’t seem to get the syntax right. excel says error in formula. Thks in advance for any help BRC __________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with the syntax for using range name in a formula?
On Jan 9, 10:06*am, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote: Hi =AVERAGE(SMALL(Myrange,{1,2,3})) have you created Myrange? have you spelt it correctly? -- Regards Roger Govier "BRC" wrote in message ... I have --------=+AVERAGE(SMALL(B7:B19,{1,2,3}))-------------. *I want to replace B7:B19 with Myrange but I can t seem to get the syntax right. excel says error in formula. Thks in advance for any help BRC __________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com Thank you Roger, I thought range name had to be in quotes and needed something like...... range.("myrange")...Thk again BRC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VB Syntax to select a range | Excel Discussion (Misc queries) | |||
| Need help with creating a Range Name syntax | Setting up and Configuration of Excel | |||
| Need help with creating a Range Name syntax | Setting up and Configuration of Excel | |||
| range and cells syntax | Excel Worksheet Functions | |||
| Range.Select Using Variables - need syntax | Excel Discussion (Misc queries) | |||
![BRC[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
