Why second line need to be restructured in different format. Like Pos3
pos 5
Please let me know. I will work on that.
On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant eugenio.gr...@gmail.com
wrote:
I have a Excel Sheet lile this:
type Begin End Text Var
Variables identified as type = double should be treated differently in
order to adjust to a expected format...
On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani gauravdev1...@gmail.com
wrote:
Why second line need to be restructured in different format. Like Pos3
pos 5
Sorry, EXCEL functions cannot act on other cells.
If you wanted to write a VBA macro, then this could be done.
You could even make it an event macro on Worksheet one
such that when the values in the two cells change,
worksheet two automatically updates.
Paul
Hi,
Thank you Paul for the response. It is what I was looking out for. Just one
more question, could the formula fill up the cells without having to drag
it? If one exists, will much appreciate.
Cheers.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
I have a Excel Sheet lile this:
type Begin End Text Var
simple 1 2 Car v43
double 3 5 Ball v50
I want to reestructure and save to Word, (via VBA or Macro) reestructured
like this:
[v43] Car
simple
POS 1 to 2
[v50]
The code itself isn't difficult.
But it would be a VERY specific solution.
If you decide to change the row to output the result,
or starting column,
or even where you put the values you're using,
it would require you to find someone to modify the code.
Unless you're wanting to invest the time
I have no VBA coding experience. Could you refer me to a resource that
I can use to write the command or a better alternative.
On 2/11/15, Paul Schreiner schreiner_p...@att.net wrote:
Sorry, EXCEL functions cannot act on other cells.
If you wanted to write a VBA macro, then this could be
Hi
Share excel file for more clarity..
Cheers!!
On Wed, Feb 11, 2015 at 11:26 AM, Enock Wangila ekwang...@gmail.com wrote:
Hi Guys,
Please help me find a solution to this challenge. I need a formula that
helps me fill multiple cells in a different worksheet by entering a value
in a single
It is more clear now...
Cheers!!
On Tue, Feb 10, 2015 at 7:00 PM, Christos Alekopoulos
christosalekopou...@gmail.com wrote:
Thanks Vabz but I don't want just a function that replaces any value. My
post explains fully what I needed!
Cheers
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Hi all.
I am looking for a formula to count duplicate records for a specific
class/field in excel. Please help. Thanks
--
Regards,
Ahmad Mustafa
+44 7768197568
--
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
Hi,
The user name to be picked up by formula in the column *L* once the value
is entered in column *K*
I have entered few names manually. Please help.
*Regards, Pravin Gunjal*
--
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
Hi Vabs
Following is the code:
Function savedbf() As Boolean
Dim filename As Variant
Dim temp As Variant
Dim currentFile As String
Dim defaultFile As String
currentFile = ActiveWorkbook.Name
temp = Split(currentFile, .)
temp(UBound(temp)) = dbf
defaultFile =
Here is an illustration of what I am requesting for. I hope it helps make
the case clearer.
Cheers
--
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 @
https://www.facebook.com/discussexcel
FORUM
Splendid Paul, exactly how i want it. thanks very much
On Tue, Feb 10, 2015 at 9:33 AM, Paul Schreiner schreiner_p...@att.net
wrote:
[image: Boxbe] https://www.boxbe.com/overview This message is eligible
for Automatic Cleanup! (schreiner_p...@att.net) Add cleanup rule
Where do the names come from?
what does the value in column K have to do with these names?
I see JKD lsted for case 48 and 12, so it evidently isn't some form of unique
index...
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways
REALLY need more infomation.
I was tempted to leave it at that:
ask for more info, but not say what info is needed.
There ARE functions that CAN be used (or used in combination) to count
duplicate records.
But it REALLY depends on the format of the data and what is considered
Hmm.. your question and expectations are unclear.
a formula technically is an equation that may or may not contain functions.
=TODAY() + 3
is a formula that uses the TODAY() function to calculate the date 3 days from
the current date.
From your question, you want to insert a specified value
17 matches
Mail list logo