|
Array function does not seem to work
Over the last few days, I have sought and received help from the community.
The help has been with formulas requiring array answers. Each time I try the cntr-shift-enter, an error appears in the middle of the formula. e.g Mike gave me this fomula =INDEX(C1:C1000,LARGE(IF(C1000<"",ROW(C1:C1000)), 2)) I used the ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. I then went on to the array learning module, and entered an array formula for part of that study, and again an error message appeared with a similar part of their function highlighted as an error. Anyone suggest solution? |
Array function does not seem to work
Not sure what you are doing but I wonder if the formula should be
=INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "dartanion" wrote in message ... Over the last few days, I have sought and received help from the community. The help has been with formulas requiring array answers. Each time I try the cntr-shift-enter, an error appears in the middle of the formula. e.g Mike gave me this fomula =INDEX(C1:C1000,LARGE(IF(C1000<"",ROW(C1:C1000)), 2)) I used the ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. I then went on to the array learning module, and entered an array formula for part of that study, and again an error message appeared with a similar part of their function highlighted as an error. Anyone suggest solution? |
Array function does not seem to work
Thanks Bernard, but no the same error appeared, which suggests to me its not
the formula, but something in excel, what do you think, and any ideas what I can test? "Bernard Liengme" wrote: Not sure what you are doing but I wonder if the formula should be =INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "dartanion" wrote in message ... Over the last few days, I have sought and received help from the community. The help has been with formulas requiring array answers. Each time I try the cntr-shift-enter, an error appears in the middle of the formula. e.g Mike gave me this fomula =INDEX(C1:C1000,LARGE(IF(C1000<"",ROW(C1:C1000)), 2)) I used the ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. I then went on to the array learning module, and entered an array formula for part of that study, and again an error message appeared with a similar part of their function highlighted as an error. Anyone suggest solution? |
Array function does not seem to work
See my post in your other thread, I should have updated it to continental
separators =INDEX(C1:C1000;LARGE(IF(C1:C1000<"";ROW(C1:C1000 ));2)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "dartanion" wrote in message ... Thanks Bernard, but no the same error appeared, which suggests to me its not the formula, but something in excel, what do you think, and any ideas what I can test? "Bernard Liengme" wrote: Not sure what you are doing but I wonder if the formula should be =INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "dartanion" wrote in message ... Over the last few days, I have sought and received help from the community. The help has been with formulas requiring array answers. Each time I try the cntr-shift-enter, an error appears in the middle of the formula. e.g Mike gave me this fomula =INDEX(C1:C1000,LARGE(IF(C1000<"",ROW(C1:C1000)), 2)) I used the ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. I then went on to the array learning module, and entered an array formula for part of that study, and again an error message appeared with a similar part of their function highlighted as an error. Anyone suggest solution? |
Array function does not seem to work
Thanks Sandy, I changed all the , to ; and the array works. WHY??
"Sandy Mann" wrote: ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. Do you use semi-colon separator or comma? If so change the , to ; -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "dartanion" wrote in message ... Thanks Bernard, but no the same error appeared, which suggests to me its not the formula, but something in excel, what do you think, and any ideas what I can test? "Bernard Liengme" wrote: Not sure what you are doing but I wonder if the formula should be =INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "dartanion" wrote in message ... Over the last few days, I have sought and received help from the community. The help has been with formulas requiring array answers. Each time I try the cntr-shift-enter, an error appears in the middle of the formula. e.g Mike gave me this fomula =INDEX(C1:C1000,LARGE(IF(C1000<"",ROW(C1:C1000)), 2)) I used the ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. I then went on to the array learning module, and entered an array formula for part of that study, and again an error message appeared with a similar part of their function highlighted as an error. Anyone suggest solution? |
Array function does not seem to work
Because you have a continental version of Excel which uses comma as the
decimal separator, so semi-colon is used as the list separator. Our English version is dot and comma. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "dartanion" wrote in message ... Thanks Sandy, I changed all the , to ; and the array works. WHY?? "Sandy Mann" wrote: ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. Do you use semi-colon separator or comma? If so change the , to ; -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "dartanion" wrote in message ... Thanks Bernard, but no the same error appeared, which suggests to me its not the formula, but something in excel, what do you think, and any ideas what I can test? "Bernard Liengme" wrote: Not sure what you are doing but I wonder if the formula should be =INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "dartanion" wrote in message ... Over the last few days, I have sought and received help from the community. The help has been with formulas requiring array answers. Each time I try the cntr-shift-enter, an error appears in the middle of the formula. e.g Mike gave me this fomula =INDEX(C1:C1000,LARGE(IF(C1000<"",ROW(C1:C1000)), 2)) I used the ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. I then went on to the array learning module, and entered an array formula for part of that study, and again an error message appeared with a similar part of their function highlighted as an error. Anyone suggest solution? |
Array function does not seem to work
I thought that you had adequately explained the reason in the other thread
Bob so I did not respond. However, because it was in *another thread* I suppose that for completeness in the archives it did require an answer. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Bob Phillips" wrote in message ... Because you have a continental version of Excel which uses comma as the decimal separator, so semi-colon is used as the list separator. Our English version is dot and comma. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "dartanion" wrote in message ... Thanks Sandy, I changed all the , to ; and the array works. WHY?? "Sandy Mann" wrote: ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. Do you use semi-colon separator or comma? If so change the , to ; -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "dartanion" wrote in message ... Thanks Bernard, but no the same error appeared, which suggests to me its not the formula, but something in excel, what do you think, and any ideas what I can test? "Bernard Liengme" wrote: Not sure what you are doing but I wonder if the formula should be =INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "dartanion" wrote in message ... Over the last few days, I have sought and received help from the community. The help has been with formulas requiring array answers. Each time I try the cntr-shift-enter, an error appears in the middle of the formula. e.g Mike gave me this fomula =INDEX(C1:C1000,LARGE(IF(C1000<"",ROW(C1:C1000)), 2)) I used the ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. I then went on to the array learning module, and entered an array formula for part of that study, and again an error message appeared with a similar part of their function highlighted as an error. Anyone suggest solution? |
Array function does not seem to work
Hi sandy,
I thought you were watching Inverness Cali <bg. I wondered if he actually read that thread anymore after he got his answer here. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sandy Mann" wrote in message ... I thought that you had adequately explained the reason in the other thread Bob so I did not respond. However, because it was in *another thread* I suppose that for completeness in the archives it did require an answer. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Bob Phillips" wrote in message ... Because you have a continental version of Excel which uses comma as the decimal separator, so semi-colon is used as the list separator. Our English version is dot and comma. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "dartanion" wrote in message ... Thanks Sandy, I changed all the , to ; and the array works. WHY?? "Sandy Mann" wrote: ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. Do you use semi-colon separator or comma? If so change the , to ; -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "dartanion" wrote in message ... Thanks Bernard, but no the same error appeared, which suggests to me its not the formula, but something in excel, what do you think, and any ideas what I can test? "Bernard Liengme" wrote: Not sure what you are doing but I wonder if the formula should be =INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "dartanion" wrote in message ... Over the last few days, I have sought and received help from the community. The help has been with formulas requiring array answers. Each time I try the cntr-shift-enter, an error appears in the middle of the formula. e.g Mike gave me this fomula =INDEX(C1:C1000,LARGE(IF(C1000<"",ROW(C1:C1000)), 2)) I used the ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. I then went on to the array learning module, and entered an array formula for part of that study, and again an error message appeared with a similar part of their function highlighted as an error. Anyone suggest solution? |
Array function does not seem to work
It was only lately that I found out that *Celtic* is actually an acronym.
Yes it's true, it stands for: Can Even Lose To Inverness Cali <G -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Bob Phillips" wrote in message ... Hi sandy, I thought you were watching Inverness Cali <bg. I wondered if he actually read that thread anymore after he got his answer here. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sandy Mann" wrote in message ... I thought that you had adequately explained the reason in the other thread Bob so I did not respond. However, because it was in *another thread* I suppose that for completeness in the archives it did require an answer. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Bob Phillips" wrote in message ... Because you have a continental version of Excel which uses comma as the decimal separator, so semi-colon is used as the list separator. Our English version is dot and comma. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "dartanion" wrote in message ... Thanks Sandy, I changed all the , to ; and the array works. WHY?? "Sandy Mann" wrote: ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. Do you use semi-colon separator or comma? If so change the , to ; -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "dartanion" wrote in message ... Thanks Bernard, but no the same error appeared, which suggests to me its not the formula, but something in excel, what do you think, and any ideas what I can test? "Bernard Liengme" wrote: Not sure what you are doing but I wonder if the formula should be =INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "dartanion" wrote in message ... Over the last few days, I have sought and received help from the community. The help has been with formulas requiring array answers. Each time I try the cntr-shift-enter, an error appears in the middle of the formula. e.g Mike gave me this fomula =INDEX(C1:C1000,LARGE(IF(C1000<"",ROW(C1:C1000)), 2)) I used the ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. I then went on to the array learning module, and entered an array formula for part of that study, and again an error message appeared with a similar part of their function highlighted as an error. Anyone suggest solution? |
Array function does not seem to work
Will the Sun rerun what must be widely regarded as the best headline of all
time? -- David Biddulph "Sandy Mann" wrote in message ... It was only lately that I found out that *Celtic* is actually an acronym. Yes it's true, it stands for: Can Even Lose To Inverness Cali <G "Bob Phillips" wrote in message ... Hi sandy, I thought you were watching Inverness Cali <bg. I wondered if he actually read that thread anymore after he got his answer here. "Sandy Mann" wrote in message ... I thought that you had adequately explained the reason in the other thread Bob so I did not respond. However, because it was in *another thread* I suppose that for completeness in the archives it did require an answer. "Bob Phillips" wrote in message ... Because you have a continental version of Excel which uses comma as the decimal separator, so semi-colon is used as the list separator. Our English version is dot and comma. "dartanion" wrote in message ... Thanks Sandy, I changed all the , to ; and the array works. WHY?? "Sandy Mann" wrote: ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. Do you use semi-colon separator or comma? If so change the , to ; "dartanion" wrote in message ... Thanks Bernard, but no the same error appeared, which suggests to me its not the formula, but something in excel, what do you think, and any ideas what I can test? "Bernard Liengme" wrote: Not sure what you are doing but I wonder if the formula should be =INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes .... |
Array function does not seem to work
Hi David,
I don't read the Sun, (I don't think that the Sun readers do either do they? <g). What was the headline? -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Will the Sun rerun what must be widely regarded as the best headline of all time? -- David Biddulph "Sandy Mann" wrote in message ... It was only lately that I found out that *Celtic* is actually an acronym. Yes it's true, it stands for: Can Even Lose To Inverness Cali <G "Bob Phillips" wrote in message ... Hi sandy, I thought you were watching Inverness Cali <bg. I wondered if he actually read that thread anymore after he got his answer here. "Sandy Mann" wrote in message ... I thought that you had adequately explained the reason in the other thread Bob so I did not respond. However, because it was in *another thread* I suppose that for completeness in the archives it did require an answer. "Bob Phillips" wrote in message ... Because you have a continental version of Excel which uses comma as the decimal separator, so semi-colon is used as the list separator. Our English version is dot and comma. "dartanion" wrote in message ... Thanks Sandy, I changed all the , to ; and the array works. WHY?? "Sandy Mann" wrote: ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. Do you use semi-colon separator or comma? If so change the , to ; "dartanion" wrote in message ... Thanks Bernard, but no the same error appeared, which suggests to me its not the formula, but something in excel, what do you think, and any ideas what I can test? "Bernard Liengme" wrote: Not sure what you are doing but I wonder if the formula should be =INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes ... |
Array function does not seem to work
I don't read the Sun, either, but this dates back to the days when lowly
Caley knocked Celtic out of the Scottish FA Cup in 2000, and the famous headline was: "Super Caley Go Ballistic Celtic Are Atrocious". -- David Biddulph "Sandy Mann" wrote in message ... Hi David, I don't read the Sun, (I don't think that the Sun readers do either do they? <g). What was the headline? "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Will the Sun rerun what must be widely regarded as the best headline of all time? -- David Biddulph "Sandy Mann" wrote in message ... It was only lately that I found out that *Celtic* is actually an acronym. Yes it's true, it stands for: Can Even Lose To Inverness Cali <G "Bob Phillips" wrote in message ... Hi sandy, I thought you were watching Inverness Cali <bg. I wondered if he actually read that thread anymore after he got his answer here. "Sandy Mann" wrote in message ... I thought that you had adequately explained the reason in the other thread Bob so I did not respond. However, because it was in *another thread* I suppose that for completeness in the archives it did require an answer. "Bob Phillips" wrote in message ... Because you have a continental version of Excel which uses comma as the decimal separator, so semi-colon is used as the list separator. Our English version is dot and comma. "dartanion" wrote in message ... Thanks Sandy, I changed all the , to ; and the array works. WHY?? "Sandy Mann" wrote: ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. Do you use semi-colon separator or comma? If so change the , to ; "dartanion" wrote in message ... Thanks Bernard, but no the same error appeared, which suggests to me its not the formula, but something in excel, what do you think, and any ideas what I can test? "Bernard Liengme" wrote: Not sure what you are doing but I wonder if the formula should be =INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes ... |
Array function does not seem to work
|
Array function does not seem to work
Damn. You beat me to it, I was lining that one up <G
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... I don't read the Sun, either, but this dates back to the days when lowly Caley knocked Celtic out of the Scottish FA Cup in 2000, and the famous headline was: "Super Caley Go Ballistic Celtic Are Atrocious". -- David Biddulph "Sandy Mann" wrote in message ... Hi David, I don't read the Sun, (I don't think that the Sun readers do either do they? <g). What was the headline? "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Will the Sun rerun what must be widely regarded as the best headline of all time? -- David Biddulph "Sandy Mann" wrote in message ... It was only lately that I found out that *Celtic* is actually an acronym. Yes it's true, it stands for: Can Even Lose To Inverness Cali <G "Bob Phillips" wrote in message ... Hi sandy, I thought you were watching Inverness Cali <bg. I wondered if he actually read that thread anymore after he got his answer here. "Sandy Mann" wrote in message ... I thought that you had adequately explained the reason in the other thread Bob so I did not respond. However, because it was in *another thread* I suppose that for completeness in the archives it did require an answer. "Bob Phillips" wrote in message ... Because you have a continental version of Excel which uses comma as the decimal separator, so semi-colon is used as the list separator. Our English version is dot and comma. "dartanion" wrote in message ... Thanks Sandy, I changed all the , to ; and the array works. WHY?? "Sandy Mann" wrote: ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. Do you use semi-colon separator or comma? If so change the , to ; "dartanion" wrote in message ... Thanks Bernard, but no the same error appeared, which suggests to me its not the formula, but something in excel, what do you think, and any ideas what I can test? "Bernard Liengme" wrote: Not sure what you are doing but I wonder if the formula should be =INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes ... |
Array function does not seem to work
They can't!
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sandy Mann" wrote in message ... Hi David, I don't read the Sun, (I don't think that the Sun readers do either do they? <g). What was the headline? -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Will the Sun rerun what must be widely regarded as the best headline of all time? -- David Biddulph "Sandy Mann" wrote in message ... It was only lately that I found out that *Celtic* is actually an acronym. Yes it's true, it stands for: Can Even Lose To Inverness Cali <G "Bob Phillips" wrote in message ... Hi sandy, I thought you were watching Inverness Cali <bg. I wondered if he actually read that thread anymore after he got his answer here. "Sandy Mann" wrote in message ... I thought that you had adequately explained the reason in the other thread Bob so I did not respond. However, because it was in *another thread* I suppose that for completeness in the archives it did require an answer. "Bob Phillips" wrote in message ... Because you have a continental version of Excel which uses comma as the decimal separator, so semi-colon is used as the list separator. Our English version is dot and comma. "dartanion" wrote in message ... Thanks Sandy, I changed all the , to ; and the array works. WHY?? "Sandy Mann" wrote: ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. Do you use semi-colon separator or comma? If so change the , to ; "dartanion" wrote in message ... Thanks Bernard, but no the same error appeared, which suggests to me its not the formula, but something in excel, what do you think, and any ideas what I can test? "Bernard Liengme" wrote: Not sure what you are doing but I wonder if the formula should be =INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes ... |
Array function does not seem to work
|
Array function does not seem to work
Well you have to admit, the two do go hand in hand.
So tell me, where/what is St Johnston? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sandy Mann" wrote in message ... Just to set the record straight I support St Johnston. That is St Johnston FC not, as many people think, St Johnston Nil <g -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Bob Phillips" wrote in message ... Damn. You beat me to it, I was lining that one up <G -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... I don't read the Sun, either, but this dates back to the days when lowly Caley knocked Celtic out of the Scottish FA Cup in 2000, and the famous headline was: "Super Caley Go Ballistic Celtic Are Atrocious". -- David Biddulph "Sandy Mann" wrote in message ... Hi David, I don't read the Sun, (I don't think that the Sun readers do either do they? <g). What was the headline? "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Will the Sun rerun what must be widely regarded as the best headline of all time? -- David Biddulph "Sandy Mann" wrote in message ... It was only lately that I found out that *Celtic* is actually an acronym. Yes it's true, it stands for: Can Even Lose To Inverness Cali <G "Bob Phillips" wrote in message ... Hi sandy, I thought you were watching Inverness Cali <bg. I wondered if he actually read that thread anymore after he got his answer here. "Sandy Mann" wrote in message ... I thought that you had adequately explained the reason in the other thread Bob so I did not respond. However, because it was in *another thread* I suppose that for completeness in the archives it did require an answer. "Bob Phillips" wrote in message ... Because you have a continental version of Excel which uses comma as the decimal separator, so semi-colon is used as the list separator. Our English version is dot and comma. "dartanion" wrote in message ... Thanks Sandy, I changed all the , to ; and the array works. WHY?? "Sandy Mann" wrote: ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. Do you use semi-colon separator or comma? If so change the , to ; "dartanion" wrote in message ... Thanks Bernard, but no the same error appeared, which suggests to me its not the formula, but something in excel, what do you think, and any ideas what I can test? "Bernard Liengme" wrote: Not sure what you are doing but I wonder if the formula should be =INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes ... |
Array function does not seem to work
St Johnston is Perth's football team. Perth is *Saint John's Town*
http://en.wikipedia.org/wiki/Perth,_Scotland also says why I say in my signature the Perth is the ancient capital of Scotland and the crowning place of kings. -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Bob Phillips" wrote in message ... Well you have to admit, the two do go hand in hand. So tell me, where/what is St Johnston? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sandy Mann" wrote in message ... Just to set the record straight I support St Johnston. That is St Johnston FC not, as many people think, St Johnston Nil <g -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Bob Phillips" wrote in message ... Damn. You beat me to it, I was lining that one up <G -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... I don't read the Sun, either, but this dates back to the days when lowly Caley knocked Celtic out of the Scottish FA Cup in 2000, and the famous headline was: "Super Caley Go Ballistic Celtic Are Atrocious". -- David Biddulph "Sandy Mann" wrote in message ... Hi David, I don't read the Sun, (I don't think that the Sun readers do either do they? <g). What was the headline? "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Will the Sun rerun what must be widely regarded as the best headline of all time? -- David Biddulph "Sandy Mann" wrote in message ... It was only lately that I found out that *Celtic* is actually an acronym. Yes it's true, it stands for: Can Even Lose To Inverness Cali <G "Bob Phillips" wrote in message ... Hi sandy, I thought you were watching Inverness Cali <bg. I wondered if he actually read that thread anymore after he got his answer here. "Sandy Mann" wrote in message ... I thought that you had adequately explained the reason in the other thread Bob so I did not respond. However, because it was in *another thread* I suppose that for completeness in the archives it did require an answer. "Bob Phillips" wrote in message ... Because you have a continental version of Excel which uses comma as the decimal separator, so semi-colon is used as the list separator. Our English version is dot and comma. "dartanion" wrote in message ... Thanks Sandy, I changed all the , to ; and the array works. WHY?? "Sandy Mann" wrote: ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. Do you use semi-colon separator or comma? If so change the , to ; "dartanion" wrote in message ... Thanks Bernard, but no the same error appeared, which suggests to me its not the formula, but something in excel, what do you think, and any ideas what I can test? "Bernard Liengme" wrote: Not sure what you are doing but I wonder if the formula should be =INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes ... |
Array function does not seem to work
I got your place of residence, but I never knew that St Johnston was located
in Perth. I always assumed it was one of those Glasgow peripheral teams. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sandy Mann" wrote in message ... St Johnston is Perth's football team. Perth is *Saint John's Town* http://en.wikipedia.org/wiki/Perth,_Scotland also says why I say in my signature the Perth is the ancient capital of Scotland and the crowning place of kings. -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Bob Phillips" wrote in message ... Well you have to admit, the two do go hand in hand. So tell me, where/what is St Johnston? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sandy Mann" wrote in message ... Just to set the record straight I support St Johnston. That is St Johnston FC not, as many people think, St Johnston Nil <g -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Bob Phillips" wrote in message ... Damn. You beat me to it, I was lining that one up <G -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... I don't read the Sun, either, but this dates back to the days when lowly Caley knocked Celtic out of the Scottish FA Cup in 2000, and the famous headline was: "Super Caley Go Ballistic Celtic Are Atrocious". -- David Biddulph "Sandy Mann" wrote in message ... Hi David, I don't read the Sun, (I don't think that the Sun readers do either do they? <g). What was the headline? "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Will the Sun rerun what must be widely regarded as the best headline of all time? -- David Biddulph "Sandy Mann" wrote in message ... It was only lately that I found out that *Celtic* is actually an acronym. Yes it's true, it stands for: Can Even Lose To Inverness Cali <G "Bob Phillips" wrote in message ... Hi sandy, I thought you were watching Inverness Cali <bg. I wondered if he actually read that thread anymore after he got his answer here. "Sandy Mann" wrote in message ... I thought that you had adequately explained the reason in the other thread Bob so I did not respond. However, because it was in *another thread* I suppose that for completeness in the archives it did require an answer. "Bob Phillips" wrote in message ... Because you have a continental version of Excel which uses comma as the decimal separator, so semi-colon is used as the list separator. Our English version is dot and comma. "dartanion" wrote in message ... Thanks Sandy, I changed all the , to ; and the array works. WHY?? "Sandy Mann" wrote: ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. Do you use semi-colon separator or comma? If so change the , to ; "dartanion" wrote in message ... Thanks Bernard, but no the same error appeared, which suggests to me its not the formula, but something in excel, what do you think, and any ideas what I can test? "Bernard Liengme" wrote: Not sure what you are doing but I wonder if the formula should be =INDEX(C1:C1000,LARGE(IF(C1:C1000<"",ROW(C1:C1000 )),2)) the change being just after IF( best wishes ... |
| All times are GMT +1. The time now is 06:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com