Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get {} woking
I tried
CTRL, Shift and Enter and t doesnt add the command that is required is there something I missing? Thanks ahead! Rob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get {} woking
On Fri, 22 Jun 2007 16:04:01 -0700, Killer
wrote: I tried CTRL, Shift and Enter and t doesn’t add the command that is required is there something I missing? Thanks ahead! Rob What formula are you committing? --ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get {} woking
Hey Ron
Here's the formula =IF(ROWS(1:$1)<=COUNTA(B$13:B$45),INDEX(B$13:B$45, MATCH(LARGE(AM$13:AM$45-ROW(AM$13:AM$45)/10^10,ROWS(1:$1)),AM$13:AM$45-ROW(AM$13:AM$45)/10^10,0)),"") It woks I know this much but if I edited anything at all I get a #VALUE! error. Thanks ahead! Rob "Ron Rosenfeld" wrote: On Fri, 22 Jun 2007 16:04:01 -0700, Killer wrote: I tried CTRL, Shift and Enter and t doesnt add the command that is required is there something I missing? Thanks ahead! Rob What formula are you committing? --ron |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get {} woking
Whenever you edit an array formula you *must* re-enter it as an array with
the key combo of CTRL,SHIFT,ENTER. I've never heard of Excel *not* applying the array brackets if this is done properly. Hold down both the CTRL key and the SHIFT key then hit ENTER. Biff "Killer" wrote in message ... Hey Ron Here's the formula =IF(ROWS(1:$1)<=COUNTA(B$13:B$45),INDEX(B$13:B$45, MATCH(LARGE(AM$13:AM$45-ROW(AM$13:AM$45)/10^10,ROWS(1:$1)),AM$13:AM$45-ROW(AM$13:AM$45)/10^10,0)),"") It woks I know this much but if I edited anything at all I get a #VALUE! error. Thanks ahead! Rob "Ron Rosenfeld" wrote: On Fri, 22 Jun 2007 16:04:01 -0700, Killer wrote: I tried CTRL, Shift and Enter and t doesn't add the command that is required is there something I missing? Thanks ahead! Rob What formula are you committing? --ron |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get {} woking
On Fri, 22 Jun 2007 16:24:00 -0700, Killer
wrote: Hey Ron Here's the formula =IF(ROWS(1:$1)<=COUNTA(B$13:B$45),INDEX(B$13:B$45 ,MATCH(LARGE(AM$13:AM$45-ROW(AM$13:AM$45)/10^10,ROWS(1:$1)),AM$13:AM$45-ROW(AM$13:AM$45)/10^10,0)),"") It woks I know this much but if I edited anything at all I get a #VALUE! error. Thanks ahead! Rob "Ron Rosenfeld" wrote: On Fri, 22 Jun 2007 16:04:01 -0700, Killer wrote: I tried CTRL, Shift and Enter and t doesn’t add the command that is required is there something I missing? Thanks ahead! Rob What formula are you committing? --ron If you are entering the formula properly, and Excel is placing the {...}'s after you strike <enter while holding down <ctrl<shift, then there may be a problem with your data, compared with the data upon which the formula was based. Or there may be a problem with your references. Do you see the {...} brackets after you enter the formula? (Don't type them in yourself; let Excel add them). --ron |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get {} woking
I understand anytime I edit anything regarding array formula that I need to
use the CTRL,SHIFT,ENTER command. The problem is I'm doing that and it's not working. The formula is correct as it works but even when I'm checking the formula in the box area it gives that error afterwards and that because the array formula is not there now. So then I try to activate it by clicking CTRL,SHIFT,ENTER and isn't applying the array formula. Is there something else that could be stopping me from getting this array formula command working like key commands? Take Care! Rob "T. Valko" wrote: Whenever you edit an array formula you *must* re-enter it as an array with the key combo of CTRL,SHIFT,ENTER. I've never heard of Excel *not* applying the array brackets if this is done properly. Hold down both the CTRL key and the SHIFT key then hit ENTER. Biff "Killer" wrote in message ... Hey Ron Here's the formula =IF(ROWS(1:$1)<=COUNTA(B$13:B$45),INDEX(B$13:B$45, MATCH(LARGE(AM$13:AM$45-ROW(AM$13:AM$45)/10^10,ROWS(1:$1)),AM$13:AM$45-ROW(AM$13:AM$45)/10^10,0)),"") It woks I know this much but if I edited anything at all I get a #VALUE! error. Thanks ahead! Rob "Ron Rosenfeld" wrote: On Fri, 22 Jun 2007 16:04:01 -0700, Killer wrote: I tried CTRL, Shift and Enter and t doesn't add the command that is required is there something I missing? Thanks ahead! Rob What formula are you committing? --ron |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get {} woking
Click in the cell that contains the formula, where you see the actual
formula in the formula bar. Look below, at the status bar, just above the Windows <Start button. You'll see "READY"! For you to enter this formula as an array formula, the status bar *MUST* first say "EDIT". To get into "Edit Mode", you do one of two things. Either: Click in the formula bar, OR Hit <F2. With the status bar displaying "Edit", NOW ... hit CSE (<Ctrl <Shift <Enter)! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Killer" wrote in message ... I understand anytime I edit anything regarding array formula that I need to use the CTRL,SHIFT,ENTER command. The problem is I'm doing that and it's not working. The formula is correct as it works but even when I'm checking the formula in the box area it gives that error afterwards and that because the array formula is not there now. So then I try to activate it by clicking CTRL,SHIFT,ENTER and isn't applying the array formula. Is there something else that could be stopping me from getting this array formula command working like key commands? Take Care! Rob "T. Valko" wrote: Whenever you edit an array formula you *must* re-enter it as an array with the key combo of CTRL,SHIFT,ENTER. I've never heard of Excel *not* applying the array brackets if this is done properly. Hold down both the CTRL key and the SHIFT key then hit ENTER. Biff "Killer" wrote in message ... Hey Ron Here's the formula =IF(ROWS(1:$1)<=COUNTA(B$13:B$45),INDEX(B$13:B$45, MATCH(LARGE(AM$13:AM$45-RO W(AM$13:AM$45)/10^10,ROWS(1:$1)),AM$13:AM$45-ROW(AM$13:AM$45)/10^10,0)),"") It woks I know this much but if I edited anything at all I get a #VALUE! error. Thanks ahead! Rob "Ron Rosenfeld" wrote: On Fri, 22 Jun 2007 16:04:01 -0700, Killer wrote: I tried CTRL, Shift and Enter and t doesn't add the command that is required is there something I missing? Thanks ahead! Rob What formula are you committing? --ron |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get {} woking
Thanks Ragdyer that did the trick.
"Ragdyer" wrote: Click in the cell that contains the formula, where you see the actual formula in the formula bar. Look below, at the status bar, just above the Windows <Start button. You'll see "READY"! For you to enter this formula as an array formula, the status bar *MUST* first say "EDIT". To get into "Edit Mode", you do one of two things. Either: Click in the formula bar, OR Hit <F2. With the status bar displaying "Edit", NOW ... hit CSE (<Ctrl <Shift <Enter)! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Killer" wrote in message ... I understand anytime I edit anything regarding array formula that I need to use the CTRL,SHIFT,ENTER command. The problem is I'm doing that and it's not working. The formula is correct as it works but even when I'm checking the formula in the box area it gives that error afterwards and that because the array formula is not there now. So then I try to activate it by clicking CTRL,SHIFT,ENTER and isn't applying the array formula. Is there something else that could be stopping me from getting this array formula command working like key commands? Take Care! Rob "T. Valko" wrote: Whenever you edit an array formula you *must* re-enter it as an array with the key combo of CTRL,SHIFT,ENTER. I've never heard of Excel *not* applying the array brackets if this is done properly. Hold down both the CTRL key and the SHIFT key then hit ENTER. Biff "Killer" wrote in message ... Hey Ron Here's the formula =IF(ROWS(1:$1)<=COUNTA(B$13:B$45),INDEX(B$13:B$45, MATCH(LARGE(AM$13:AM$45-RO W(AM$13:AM$45)/10^10,ROWS(1:$1)),AM$13:AM$45-ROW(AM$13:AM$45)/10^10,0)),"") It woks I know this much but if I edited anything at all I get a #VALUE! error. Thanks ahead! Rob "Ron Rosenfeld" wrote: On Fri, 22 Jun 2007 16:04:01 -0700, Killer wrote: I tried CTRL, Shift and Enter and t doesn't add the command that is required is there something I missing? Thanks ahead! Rob What formula are you committing? --ron |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get {} woking
You're welcome, and thanks for the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Killer" wrote in message ... Thanks Ragdyer that did the trick. "Ragdyer" wrote: Click in the cell that contains the formula, where you see the actual formula in the formula bar. Look below, at the status bar, just above the Windows <Start button. You'll see "READY"! For you to enter this formula as an array formula, the status bar *MUST* first say "EDIT". To get into "Edit Mode", you do one of two things. Either: Click in the formula bar, OR Hit <F2. With the status bar displaying "Edit", NOW ... hit CSE (<Ctrl <Shift <Enter)! -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Killer" wrote in message ... I understand anytime I edit anything regarding array formula that I need to use the CTRL,SHIFT,ENTER command. The problem is I'm doing that and it's not working. The formula is correct as it works but even when I'm checking the formula in the box area it gives that error afterwards and that because the array formula is not there now. So then I try to activate it by clicking CTRL,SHIFT,ENTER and isn't applying the array formula. Is there something else that could be stopping me from getting this array formula command working like key commands? Take Care! Rob "T. Valko" wrote: Whenever you edit an array formula you *must* re-enter it as an array with the key combo of CTRL,SHIFT,ENTER. I've never heard of Excel *not* applying the array brackets if this is done properly. Hold down both the CTRL key and the SHIFT key then hit ENTER. Biff "Killer" wrote in message ... Hey Ron Here's the formula =IF(ROWS(1:$1)<=COUNTA(B$13:B$45),INDEX(B$13:B$45, MATCH(LARGE(AM$13:AM$45-RO W(AM$13:AM$45)/10^10,ROWS(1:$1)),AM$13:AM$45-ROW(AM$13:AM$45)/10^10,0)),"") It woks I know this much but if I edited anything at all I get a #VALUE! error. Thanks ahead! Rob "Ron Rosenfeld" wrote: On Fri, 22 Jun 2007 16:04:01 -0700, Killer wrote: I tried CTRL, Shift and Enter and t doesn't add the command that is required is there something I missing? Thanks ahead! Rob What formula are you committing? --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto filter using msgbox in macro not woking | Excel Discussion (Misc queries) | |||
Auto filter using macro not woking | Excel Discussion (Misc queries) |