7 New Messages
Digest #2921
Messages
Thu Jan 9, 2014 8:00 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Amen, I, to, have spent a lifetime answering questions that one could easily answer with a little effort.
Unfortunately, I am now guilty of doing that to Randy. I promise to try harder to solve my problems before taking the easy way out.
I have been using EXCEL since it first hit the street. The HELP facilities in the earlier releases of EXCEL were not very good.
However, the current versions 2007 and later have fantastic HELP content. That is my first place I go for EXCEL assistance.
I learn a lot just reading the hits even if they are not exactly what I was looking for.
The really nice thing is the help is not limited to Microsoft.
So Let's give Randy a little help and try to answer our own questions related to EXCEL. Then Randy will have more time to answer SMF-ADDIN questions.
For example, ask the question in HELP - This is one Randy answers at least once a week.
how do I concatenate in EXCEL - You get this returned in EXCEL 2007 plus a lot more responses,
Just look below at all the places you can get help. Just like any search not all the hits are exactly what you were looking for.
<http://office.microsoft.com/redir/XT023215509991.aspx?client=1&Ver=12&NS=EXCEL&lc=en%2DUS&respos=0&CTT=1&queryid=ddab540f%2Ddb8b%2D4c6c%2D9995%2Da83de1d783c3> Join cells by using the CONCATENATE function
LinkThis article shows you how to join cell contents by using the CONCATENATE function in Excel.
<http://office.microsoft.com/redir/XT022876089991.aspx?client=1&Ver=12&NS=EXCEL&lc=en%2DUS&respos=0&CTT=1&queryid=ddab540f%2Ddb8b%2D4c6c%2D9995%2Da83de1d783c3> Concatenate text and date cells in Excel
LinkThis article shows you how to preserve the formatting of a date cell when you concatenate it with a text cell.
<http://office.microsoft.com/client/helppreview.aspx?AssetId=HP100791869990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=ddab540f%2Ddb8b%2D4c6c%2D9995%2Da83de1d783c3> Excel functions (by category)
ArticleExcel 2007 functions are categorized by their functionality. If you know the category of the function that you are looking for, you can click that category.
<http://office.microsoft.com/client/helppreview.aspx?AssetId=HA102369939990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=ddab540f%2Ddb8b%2D4c6c%2D9995%2Da83de1d783c3> Use the COUNTIFS function in Excel 2007 to analyze data
ArticleLearn about the COUNTIF function syntax and view examples of criteria Excel accepts for COUNTIF.
<http://spreadsheets.about.com/b/2009/06/29/excel-2007-concatenate-function-2.htm> Excel 2007 CONCATENATE Function - About.com Spreadsheets
LinkExcel's CONCATENATE Function© Ted French Excel's CONCATENATE function can be used to join together data from two or more cells in a spreadsheet.
<http://spreadsheets.about.com/b/2009/06/29/excel-2007-concatenate-function-2.htm> spreadsheets.about.com
<http://office.microsoft.com/client/helppreview.aspx?AssetId=HA102368409990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=ddab540f%2Ddb8b%2D4c6c%2D9995%2Da83de1d783c3> Display numbers as credit card numbers
ArticleWhen you type a number that contains more than 15 digits in a worksheet cell, Microsoft Office Excel changes any digits past the fifteenth place to zeros. In ad...
<http://www.excelforum.com/excel-formulas-and-functions/794486-undoing-concatenate.html> Undoing concatenate - Excelforum
LinkExcel 2007 Posts 113. Undoing concatenate ... although it doesn't really make sense to concatenate with a formula and then unconcatenate with another formula, ....
<http://www.excelforum.com/excel-formulas-and-functions/794486-undoing-concatenate.html> www.excelforum.com
<http://office.microsoft.com/client/helppreview.aspx?AssetId=HP103422849990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=ddab540f%2Ddb8b%2D4c6c%2D9995%2Da83de1d783c3> Combine two or more columns by using a function
ArticleYou can merge columns by using a function so that the data in two or more columns is combined into a single column.
<http://www.excelforum.com/excel-programming-vba-macros/784503-concatenate-text-files-in-excel.html> Concatenate text files in excel - Excelforum
LinkExcel 2007 Posts 2. ... I have been googling and found a number of codes that do this but dont seem to concatenate the description in to a single cell.
<http://www.excelforum.com/excel-programming-vba-macros/784503-concatenate-text-files-in-excel.html> www.excelforum.com
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Wednesday, January 08, 2014 6:34 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] A Modest Proposal for Randy (apologies for the length)
Part of the problem is that some of the most frequent questions have the same answer -- learn how to use EXCEL.
Being a typical programmer, the thing I hate most is writing up documentation, so it gets a short straw. :(
But it doesn't help that many of the questions asked are already answered somewhere, either on the front page of the group, the email welcoming someone to the group, or in the LINKS area of the group. Even in the documentation folder. But people don't take the time to read them. It's easier for them, to ask.
I see that on other groups as well. Someone will ask a question that could easily have been answered in 30 seconds with a quick visit to Google. Or a quick search of the group. Yet they will spend more time writing up a message to the group asking the question, and then wait hours, even days, for someone to answer.
When I was a professional programmer, I was the guru of the group. You don't know how many times someone would come and ask me a question and the first thing I would do is pull the Programmer's Guide or Language Reference off my shelf, look it up in the index, and then read it through with them.
Unfortunately, I am now guilty of doing that to Randy. I promise to try harder to solve my problems before taking the easy way out.
I have been using EXCEL since it first hit the street. The HELP facilities in the earlier releases of EXCEL were not very good.
However, the current versions 2007 and later have fantastic HELP content. That is my first place I go for EXCEL assistance.
I learn a lot just reading the hits even if they are not exactly what I was looking for.
The really nice thing is the help is not limited to Microsoft.
So Let's give Randy a little help and try to answer our own questions related to EXCEL. Then Randy will have more time to answer SMF-ADDIN questions.
For example, ask the question in HELP - This is one Randy answers at least once a week.
how do I concatenate in EXCEL - You get this returned in EXCEL 2007 plus a lot more responses,
Just look below at all the places you can get help. Just like any search not all the hits are exactly what you were looking for.
<http://office.
LinkThis article shows you how to join cell contents by using the CONCATENATE function in Excel.
<http://office.
LinkThis article shows you how to preserve the formatting of a date cell when you concatenate it with a text cell.
<http://office.
ArticleExcel 2007 functions are categorized by their functionality. If you know the category of the function that you are looking for, you can click that category.
<http://office.
ArticleLearn about the COUNTIF function syntax and view examples of criteria Excel accepts for COUNTIF.
<http://spreadsheets
LinkExcel'
<http://spreadsheets
<http://office.
ArticleWhen you type a number that contains more than 15 digits in a worksheet cell, Microsoft Office Excel changes any digits past the fifteenth place to zeros. In ad...
<http://www.excelfor
LinkExcel 2007 Posts 113. Undoing concatenate ... although it doesn't really make sense to concatenate with a formula and then unconcatenate with another formula, ....
<http://www.excelfor
<http://office.
ArticleYou can merge columns by using a function so that the data in two or more columns is combined into a single column.
<http://www.excelfor
LinkExcel 2007 Posts 2. ... I have been googling and found a number of codes that do this but dont seem to concatenate the description in to a single cell.
<http://www.excelfor
From: smf_addin@yahoogrou
Sent: Wednesday, January 08, 2014 6:34 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] A Modest Proposal for Randy (apologies for the length)
Part of the problem is that some of the most frequent questions have the same answer -- learn how to use EXCEL.
Being a typical programmer, the thing I hate most is writing up documentation, so it gets a short straw. :(
But it doesn't help that many of the questions asked are already answered somewhere, either on the front page of the group, the email welcoming someone to the group, or in the LINKS area of the group. Even in the documentation folder. But people don't take the time to read them. It's easier for them, to ask.
I see that on other groups as well. Someone will ask a question that could easily have been answered in 30 seconds with a quick visit to Google. Or a quick search of the group. Yet they will spend more time writing up a message to the group asking the question, and then wait hours, even days, for someone to answer.
When I was a professional programmer, I was the guru of the group. You don't know how many times someone would come and ask me a question and the first thing I would do is pull the Programmer&#
Thu Jan 9, 2014 9:02 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The issue there is most probably don't even know that "concatenate" would
be the search term.
You know the saying, "The first step to solving a problem is to define the
problem."? Same concept. I don't know how many times I've searched for
something on Google or Amazon and got few or no hits, UNTIL I found the
correct thing to be looking up.
When I'm looking for something that I'm ignorant about, I find it best to
do a Google search with a question. For example, something like:
-- how do I combine cells in EXCEL
-- how do I join strings in EXCEL
What concerns me more is that the people that ask basic questions about
EXCEL probably shouldn't be using something like the add-in. I worry
because anyone using the add-in really should be familiar with the data it
is retrieving. It's not just a number going into a worksheet cell. It's
(hopefully) a meaningful piece of data. And if they don't know what that
data is, its context, and what it represents, how can they try to interpret
the collection of data they retrieve?
For example, someone reads an article that indicates beta may be useful in
selecting stocks. Suddenly they want something called "beta". But they have
no idea that "beta" can be calculated a number of different ways. And
different data services do calculate it differently -- 1-year is most
common, but some have 3-year and 5-year, or some other time period.
On Thu, Jan 9, 2014 at 9:00 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:
>
>
> For example, ask the question in HELP - *This is one Randy answers at
> least once a week.*
>
>
>
> *how do I concatenate in EXCEL - You get this returned in EXCEL 2007 plus
> a lot more responses,*
>
> *Just look below at all the places you can get help. Just like any search
> not all the hits are exactly what you were looking for.*
>
be the search term.
You know the saying, "The first step to solving a problem is to define the
problem."
something on Google or Amazon and got few or no hits, UNTIL I found the
correct thing to be looking up.
When I'm looking for something that I'm ignorant about, I find it best to
do a Google search with a question. For example, something like:
-- how do I combine cells in EXCEL
-- how do I join strings in EXCEL
What concerns me more is that the people that ask basic questions about
EXCEL probably shouldn'
because anyone using the add-in really should be familiar with the data it
is retrieving. It's not just a number going into a worksheet cell. It's
(hopefully) a meaningful piece of data. And if they don't know what that
data is, its context, and what it represents, how can they try to interpret
the collection of data they retrieve?
For example, someone reads an article that indicates beta may be useful in
selecting stocks. Suddenly they want something called "beta"
no idea that "beta" can be calculated a number of different ways. And
different data services do calculate it differently -- 1-year is most
common, but some have 3-year and 5-year, or some other time period.
On Thu, Jan 9, 2014 at 9:00 AM, Kermit W. Prather
<kermitp@tampabay.
>
>
> For example, ask the question in HELP - *This is one Randy answers at
> least once a week.*
>
>
>
> *how do I concatenate in EXCEL - You get this returned in EXCEL 2007 plus
> a lot more responses,*
>
> *Just look below at all the places you can get help. Just like any search
> not all the hits are exactly what you were looking for.*
>
Thu Jan 9, 2014 10:12 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Randy, you are right on. I work with folks everyday that have no idea what they are doing in the stock market.
Most people won't spend the money to learn how to trade or invest. For some it is because it cost too much.
I Spent thousands learning how and what to trade/invest in. But I always believed that stock market education had to be expensive.
That is why I sell on my website www.tradingourway.com a seminar CD normally $249. Now available for only $97 until Feb 1st that covers the entire trading process.
I still get calls and emails everyday from folks asking very basic questions. When all they needed to do is watch the Seminar CD.
Like you, I don't get frustrated. I just answer their question and refer them to which part of the Seminar CD to watch. The reason I do this is because it may be basic to me but to them it can be confusing as hell.
You are absolutely right though - folks don't know what they don't know and don't even know what to ask.
Keep up the good work and we'll get through it.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, January 09, 2014 12:03 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] A Modest Proposal for Randy (apologies for the length)
The issue there is most probably don't even know that "concatenate" would be the search term.
You know the saying, "The first step to solving a problem is to define the problem."? Same concept. I don't know how many times I've searched for something on Google or Amazon and got few or no hits, UNTIL I found the correct thing to be looking up.
When I'm looking for something that I'm ignorant about, I find it best to do a Google search with a question. For example, something like:
-- how do I combine cells in EXCEL
-- how do I join strings in EXCEL
What concerns me more is that the people that ask basic questions about EXCEL probably shouldn't be using something like the add-in. I worry because anyone using the add-in really should be familiar with the data it is retrieving. It's not just a number going into a worksheet cell. It's (hopefully) a meaningful piece of data. And if they don't know what that data is, its context, and what it represents, how can they try to interpret the collection of data they retrieve?
For example, someone reads an article that indicates beta may be useful in selecting stocks. Suddenly they want something called "beta". But they have no idea that "beta" can be calculated a number of different ways. And different data services do calculate it differently -- 1-year is most common, but some have 3-year and 5-year, or some other time period.
On Thu, Jan 9, 2014 at 9:00 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
For example, ask the question in HELP - This is one Randy answers at least once a week.
how do I concatenate in EXCEL - You get this returned in EXCEL 2007 plus a lot more responses,
Just look below at all the places you can get help. Just like any search not all the hits are exactly what you were looking for.
Most people won't spend the money to learn how to trade or invest. For some it is because it cost too much.
I Spent thousands learning how and what to trade/invest in. But I always believed that stock market education had to be expensive.
That is why I sell on my website www.tradingourway.
I still get calls and emails everyday from folks asking very basic questions. When all they needed to do is watch the Seminar CD.
Like you, I don't get frustrated. I just answer their question and refer them to which part of the Seminar CD to watch. The reason I do this is because it may be basic to me but to them it can be confusing as hell.
You are absolutely right though - folks don't know what they don't know and don't even know what to ask.
Keep up the good work and we'll get through it.
Kermit
From: smf_addin@yahoogrou
Sent: Thursday, January 09, 2014 12:03 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] A Modest Proposal for Randy (apologies for the length)
The issue there is most probably don't even know that "concatenate&q
You know the saying, "The first step to solving a problem is to define the problem."
When I'm looking for something that I'm ignorant about, I find it best to do a Google search with a question. For example, something like:
-- how do I combine cells in EXCEL
-- how do I join strings in EXCEL
What concerns me more is that the people that ask basic questions about EXCEL probably shouldn'
For example, someone reads an article that indicates beta may be useful in selecting stocks. Suddenly they want something called "beta"
On Thu, Jan 9, 2014 at 9:00 AM, Kermit W. Prather <kermitp@tampabay.
For example, ask the question in HELP - This is one Randy answers at least once a week.
how do I concatenate in EXCEL - You get this returned in EXCEL 2007 plus a lot more responses,
Just look below at all the places you can get help. Just like any search not all the hits are exactly what you were looking for.
Thu Jan 9, 2014 12:31 pm (PST) . Posted by:
"flyspv" flyspv
It is great to support Randy, but I am not sure it is professional or proper to self promote while doing so. Commercials everywhere. If the trading program is so good, I doubt you need shamelessly self promote.
On Thursday, January 9, 2014 1:13 PM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
Randy, you are right on. I work with folks everyday that have no idea what they are doing in the stock market.
Most people won't spend the money to learn how to trade or invest. For some it is because it cost too much.
I Spent thousands learning how and what to trade/invest in. But I always believed that stock market education had to be expensive.
That is why I sell on my website www.tradingourway.com a seminar CD normally $249. Now available for only $97 until Feb 1st that covers the entire trading process.
I still get calls and emails everyday from folks asking very basic questions. When all they needed to do is watch the Seminar CD.
Like you, I don't get frustrated. I just answer their question and refer them to which part of the Seminar CD to watch. The reason I do this is because it may be basic to me but to them it can be confusing as hell.
You are absolutely right though - folks don't know what they don't know and don't even know what to ask.
Keep up the good work and we'll get through it.
Kermit
From:smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, January 09, 2014 12:03 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] A Modest Proposal for Randy (apologies for the length)
The issue there is most probably don't even know that "concatenate" would be the search term.
You know the saying, "The first step to solving a problem is to define the problem."? Same concept. I don't know how many times I've searched for something on Google or Amazon and got few or no hits, UNTIL I found the correct thing to be looking up.
When I'm looking for something that I'm ignorant about, I find it best to do a Google search with a question. For example, something like:
-- how do I combine cells in EXCEL
-- how do I join strings in EXCEL
What concerns me more is that the people that ask basic questions about EXCEL probably shouldn't be using something like the add-in. I worry because anyone using the add-in really should be familiar with the data it is retrieving. It's not just a number going into a worksheet cell. It's (hopefully) a meaningful piece of data. And if they don't know what that data is, its context, and what it represents, how can they try to interpret the collection of data they retrieve?
For example, someone reads an article that indicates beta may be useful in selecting stocks. Suddenly they want something called "beta". But they have no idea that "beta" can be calculated a number of different ways. And different data services do calculate it differently -- 1-year is most common, but some have 3-year and 5-year, or some other time period.
On Thu, Jan 9, 2014 at 9:00 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
For example, ask the question in HELP - This is one Randy answers at least once a week.
how do I concatenate in EXCEL - You get this returned in EXCEL 2007 plus a lot more responses,
Just look below at all the places you can get help. Just like any search not all the hits are exactly what you were looking for.
On Thursday, January 9, 2014 1:13 PM, Kermit W. Prather <kermitp@tampabay.
Randy, you are right on. I work with folks everyday that have no idea what they are doing in the stock market.
Most people won't spend the money to learn how to trade or invest. For some it is because it cost too much.
I Spent thousands learning how and what to trade/invest in. But I always believed that stock market education had to be expensive.
That is why I sell on my website www.tradingourway.
I still get calls and emails everyday from folks asking very basic questions. When all they needed to do is watch the Seminar CD.
Like you, I don't get frustrated. I just answer their question and refer them to which part of the Seminar CD to watch. The reason I do this is because it may be basic to me but to them it can be confusing as hell.
You are absolutely right though - folks don't know what they don't know and don't even know what to ask.
Keep up the good work and we'll get through it.
Kermit
From:smf_addin@yahoogrou
Sent: Thursday, January 09, 2014 12:03 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] A Modest Proposal for Randy (apologies for the length)
The issue there is most probably don't even know that "concatenate&q
You know the saying, "The first step to solving a problem is to define the problem."
When I'm looking for something that I'm ignorant about, I find it best to do a Google search with a question. For example, something like:
-- how do I combine cells in EXCEL
-- how do I join strings in EXCEL
What concerns me more is that the people that ask basic questions about EXCEL probably shouldn'
For example, someone reads an article that indicates beta may be useful in selecting stocks. Suddenly they want something called "beta"
On Thu, Jan 9, 2014 at 9:00 AM, Kermit W. Prather <kermitp@tampabay.
For example, ask the question in HELP - This is one Randy answers at least once a week.
how do I concatenate in EXCEL - You get this returned in EXCEL 2007 plus a lot more responses,
Just look below at all the places you can get help. Just like any search not all the hits are exactly what you were looking for.
Thu Jan 9, 2014 4:17 pm (PST) . Posted by:
"Kermit W. Prather" kermitpra
Sorry, I did not consider it a promotion just trying to provide complete information.
I seriously doubt anyone on this group would even consider purchasing the Seminar-CD.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of flyspv
Sent: Thursday, January 09, 2014 3:32 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] A Modest Proposal for Randy (apologies for the length)
It is great to support Randy, but I am not sure it is professional or proper to self promote while doing so. Commercials everywhere. If the trading program is so good, I doubt you need shamelessly self promote.
On Thursday, January 9, 2014 1:13 PM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
Randy, you are right on. I work with folks everyday that have no idea what they are doing in the stock market.
Most people won't spend the money to learn how to trade or invest. For some it is because it cost too much.
I Spent thousands learning how and what to trade/invest in. But I always believed that stock market education had to be expensive.
That is why I sell on my website www.tradingourway.com <http://www.tradingourway.com/> a seminar CD normally $249. Now available for only $97 until Feb 1st that covers the entire trading process.
I still get calls and emails everyday from folks asking very basic questions. When all they needed to do is watch the Seminar CD.
Like you, I don't get frustrated. I just answer their question and refer them to which part of the Seminar CD to watch. The reason I do this is because it may be basic to me but to them it can be confusing as hell.
You are absolutely right though - folks don't know what they don't know and don't even know what to ask.
Keep up the good work and we'll get through it.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, January 09, 2014 12:03 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] A Modest Proposal for Randy (apologies for the length)
The issue there is most probably don't even know that "concatenate" would be the search term.
You know the saying, "The first step to solving a problem is to define the problem."? Same concept. I don't know how many times I've searched for something on Google or Amazon and got few or no hits, UNTIL I found the correct thing to be looking up.
When I'm looking for something that I'm ignorant about, I find it best to do a Google search with a question. For example, something like:
-- how do I combine cells in EXCEL
-- how do I join strings in EXCEL
What concerns me more is that the people that ask basic questions about EXCEL probably shouldn't be using something like the add-in. I worry because anyone using the add-in really should be familiar with the data it is retrieving. It's not just a number going into a worksheet cell. It's (hopefully) a meaningful piece of data. And if they don't know what that data is, its context, and what it represents, how can they try to interpret the collection of data they retrieve?
For example, someone reads an article that indicates beta may be useful in selecting stocks. Suddenly they want something called "beta". But they have no idea that "beta" can be calculated a number of different ways. And different data services do calculate it differently -- 1-year is most common, but some have 3-year and 5-year, or some other time period.
On Thu, Jan 9, 2014 at 9:00 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
For example, ask the question in HELP - This is one Randy answers at least once a week.
how do I concatenate in EXCEL - You get this returned in EXCEL 2007 plus a lot more responses,
Just look below at all the places you can get help. Just like any search not all the hits are exactly what you were looking for.
I seriously doubt anyone on this group would even consider purchasing the Seminar-CD.
From: smf_addin@yahoogrou
Sent: Thursday, January 09, 2014 3:32 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] A Modest Proposal for Randy (apologies for the length)
It is great to support Randy, but I am not sure it is professional or proper to self promote while doing so. Commercials everywhere. If the trading program is so good, I doubt you need shamelessly self promote.
On Thursday, January 9, 2014 1:13 PM, Kermit W. Prather <kermitp@tampabay.
Randy, you are right on. I work with folks everyday that have no idea what they are doing in the stock market.
Most people won't spend the money to learn how to trade or invest. For some it is because it cost too much.
I Spent thousands learning how and what to trade/invest in. But I always believed that stock market education had to be expensive.
That is why I sell on my website www.tradingourway.
I still get calls and emails everyday from folks asking very basic questions. When all they needed to do is watch the Seminar CD.
Like you, I don't get frustrated. I just answer their question and refer them to which part of the Seminar CD to watch. The reason I do this is because it may be basic to me but to them it can be confusing as hell.
You are absolutely right though - folks don't know what they don't know and don't even know what to ask.
Keep up the good work and we'll get through it.
Kermit
From: smf_addin@yahoogrou
Sent: Thursday, January 09, 2014 12:03 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] A Modest Proposal for Randy (apologies for the length)
The issue there is most probably don't even know that "concatenate&q
You know the saying, "The first step to solving a problem is to define the problem."
When I'm looking for something that I'm ignorant about, I find it best to do a Google search with a question. For example, something like:
-- how do I combine cells in EXCEL
-- how do I join strings in EXCEL
What concerns me more is that the people that ask basic questions about EXCEL probably shouldn'
For example, someone reads an article that indicates beta may be useful in selecting stocks. Suddenly they want something called "beta"
On Thu, Jan 9, 2014 at 9:00 AM, Kermit W. Prather <kermitp@tampabay.
For example, ask the question in HELP - This is one Randy answers at least once a week.
how do I concatenate in EXCEL - You get this returned in EXCEL 2007 plus a lot more responses,
Just look below at all the places you can get help. Just like any search not all the hits are exactly what you were looking for.
Thu Jan 9, 2014 1:20 pm (PST) . Posted by:
nanastasakis
I've wanted to represent my allocation in Cash/Money Market with a ticker that will return a $1.00 closing price or something similar, perhaps a name, etc. I've had no luck so far. When using MSN Money in the past, I was able to use RYMXX and it would consistently return $1.00 close prices, but RYMXX doesn't return any data with any of the SMF queries that I've tried.
Does anyone have any ideas or thoughts that have worked? Thx.
Does anyone have any ideas or thoughts that have worked? Thx.
Thu Jan 9, 2014 1:27 pm (PST) . Posted by:
"Randy Randall" randyr_cds
If you wanted it to consistently return $1,00, why not just put $1.00 in
the cell, instead of going to the internet to return $1.00?
Randy
On Thu, Jan 9, 2014 at 4:20 PM, <nanastasakis@yahoo.com> wrote:
>
>
> I've wanted to represent my allocation in Cash/Money Market with a ticker
> that will return a $1.00 closing price or something similar, perhaps a
> name, etc. I've had no luck so far. When using MSN Money in the past, I
> was able to use RYMXX and it would consistently return $1.00 close prices,
> but RYMXX doesn't return any data with any of the SMF queries that I've
> tried.
>
> Does anyone have any ideas or thoughts that have worked? Thx.
>
>
the cell, instead of going to the internet to return $1.00?
Randy
On Thu, Jan 9, 2014 at 4:20 PM, <nanastasakis@
>
>
> I've wanted to represent my allocation in Cash/Money Market with a ticker
> that will return a $1.00 closing price or something similar, perhaps a
> name, etc. I've had no luck so far. When using MSN Money in the past, I
> was able to use RYMXX and it would consistently return $1.00 close prices,
> but RYMXX doesn't return any data with any of the SMF queries that I've
> tried.
>
> Does anyone have any ideas or thoughts that have worked? Thx.
>
>
Tidak ada komentar:
Posting Komentar