I have a need for suggestion on a VBA that I want to create
I have a series of cells (A1:A200), each cell contains: a blank, or a
string of phrases (like: I don't like this, Things could be better, Use
Word, Excel, but never Notes, ...)
I need to parse the content of the cell and fill columns C
This may not be the right place to post this question, however, you have
been great at helping me recently and I really appreciate it.
I have a data table in an Excel sheet. I imported 106 records into columns
A - G. I then highlighted them and created a table using the icon that
shows up at
OK, people, I like a good dialog as much as anyone else. But will you
please stop using this thread for your conversation!
Thanks,
Greg Della-Croce
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum
Paul, That is an excellent idea! All my survey results are on one page of
on workbook. So this should be fairly simple to write.
Thanks!!
Greg Della-Croce
Skype: gdellacroce55
Cell: 407-408-2572
greg_della-cr...@sil.org
"If you assume you know the answer, you will miss having a breakth
I have a sheet of responses to a short survey. The survey asked 4
questions with range answers (1 to 5, 5 being best), and then two
open-ended questions. I would like to count up the number of each
combination of answers with the range answers. So for all of the surveys,
I would like to
,
vbTextCompare) the function worked.
Greg Della-Croce
Skype: gdellacroce55
Cell: 407-408-2572
greg_della-cr...@sil.org
"If you assume you know the answer, you will miss having a breakthrough.
It’s okay to do what you did yesterday, but it will never be amazing again.".
- *Rod Favar
Vicky, thanks for the idea. I will see how it works for me. I appreciate
the time/effort you put in to help me!
Greg
Greg Della-Croce
Skype: gdellacroce55
Cell: 407-408-2572
greg_della-cr...@sil.org
"If you assume you know the answer, you will miss having a breakthrough.
It’s okay to do
I am trying to create a very simple function that will take a string of
text and read a range of texts to see if I have any that string in any of
the ranges of the texts. Should be a 10-minute problem to solve. I am
however getting a #VALUE back.
I call the function with this:
=Contains(F2,'
I have what I hope is a very simple question about why my new function is
not working. I rarely create UDF so I suspect that I have done something
wrong in the setup. I am using Excel 2013 on a PC.
I have a spreadsheet Row A:1-9 has values for weighting results (1-10)
Row B:1-9 has the value
l the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
> --
> *From:* Greg Della-Croce >
> *To:* MS EXCEL AND VBA MACROS >
> *Sent:* Sat
Since I do no see a way to do this with just functions, I think I am going
to have to write some code to do this myself, but I would appreciate a word
from the experts (aka you people)
I have a table with just shy of 50,000 rows that looks something like this:
Key1 Key2 MinDateMaxD
Never mind found my error. Must be in a Module not Sheet2. My bad.
GregDC
On Friday, October 2, 2015 at 5:09:03 PM UTC-4, Greg Della-Croce wrote:
>
> OK, I know that this is a very simple error on my part. I put the
> Function code in the Sheet2 General of the Project. I save th
OK, I know that this is a very simple error on my part. I put the Function
code in the Sheet2 General of the Project. I save the file, I save the
spreadsheet. I go to use it in a cell and it does not show up on the
function list. Yes I saved it as .xlsm, and Yes I enabled content. When I
g
13 matches
Mail list logo
