|
Formula to find last used cell
I want to populate a cell in sheet1 by going to sheet 2 column F and finding
the value of the last filled cell that is not a zero
...
|
4 |
21.09.2006 05:35:19 |
|
|
Reverse text
Hi
I need a formula (or other method) to reverse the text in a cell?
Eg "Paper clip" would become "pilc repaP".
Any suggestions?
Tod
...
|
6 |
20.09.2006 22:32:39 |
|
|
importing multiple vcards into Excel
I have a large number (200) of VCARDs that I need to import into Excel.
Excel will read the files individually, importing them as simple .txt
files.
However, I need to have the import formatted -- all the data for each
contact on a separate line.
Does anyone know of a third party utility or another method of
importing them? The information is *not* currently in Outlook.
Thanks!
Lee...
|
1 |
20.09.2006 21:02:43 |
|
|
Chart plots #VALUE as 0, can this behavior be avoided?
I have an X-Y scatterplot. In some of the cells in the range for Y values,
the result is #VALUE. However, the chart plots this as if it were "0".
This seems dangerously wrong to me, seems like it should be plotted as if
that cell were blank. It is very misleading in the chart to see those
values plotted as "0". "0" is a possible true and correct value in this
particular data, but tho...
|
3 |
20.09.2006 20:57:51 |
|
|
Sorting rows by colors (categories)
Hi,
I have rows with data in different categories, identified by three colors.
(red, green and blue).
How can I sort the rows by colors?
Thanks,
SantistaS
...
|
2 |
20.09.2006 20:43:25 |
|
|
Call Center Tracking Spreadsheet
I am needing to create a spreadsheet for a call center to track
information provided by customer. I want to do it in a format that is
easy to track ie. how many had issues, did product arrive on time.
etc... Wanted to get thoughts on best how to do this. I prefer excel
and use pivot tables a lot. Any thoughts would be appreciated.
...
|
1 |
20.09.2006 20:16:46 |
|
|
clustered stacked bar chart - format question
Ok, I've googled the instructions for the side-by-side stacked bar
chart. I've gone through it, and so far the only thing I haven't
figured out is how to space the cluster of bars apart from eachother.
So I have a cluster of stacks for 1 group, and a cluster for another.
They just appear side by side, I need a good space between each
cluster. I've played with the gap of the 0 value series...
|
3 |
20.09.2006 18:06:16 |
|
|
DeltaE formula
can someone show me how to enter this formula in excel.
=[(+11.1)^2+(-6.1)^2+(-5.25)^2]1/2
The answer is 13.71 it has to do with color L*a*b*
...
|
6 |
20.09.2006 17:29:34 |
|
|
Overrule/Replace
I have a row where I will be using tally marks. I only want one
tally per row but it is based on a progression to track steps in the
process. So if they have reached the next step they can just put a
tally (an X) in the new cell and it will auto replace the previous
tally. Thank you for any help.
eg.
Step 1 Step 2 Step 3
Person 1 ...
|
2 |
20.09.2006 17:22:49 |
|
|
Formula for getting values in File-Properties-Custom
Is there a formula for retrieving values stored in the variables in
File-Properties-Custom?
Thx
...
|
1 |
20.09.2006 16:19:28 |
|
|
open + resize notepad.exe from VBA?
I'm writing a macro that would open a text file in notepad.exe and
resize the window to a certain x/y pixel size.
I can open the file in notepad, but how would you resize the window?
'Open MyFile in Notepad
Dim MyShell As Object
Set MyShell = CreateObject("WScript.Shell")
Dim MyFile as String
MyFile = "C:\Temp\File1.txt"
MyShell.Run Chr(34) & "C:\Windows\Notepad.exe " & Chr(34) & MyFil...
|
1 |
20.09.2006 16:05:26 |
|
|
Format Column by text in first row
I have multiple documents with similar data, but not always in the same
format (thanks to too many users touching them). Each document has
multiple sheets and I would like to write a Macro that will format a
particular column to a certain Date Format. I know how to write this
macro if you already know the Column, but it isn't always the same.
This particular column has a header in the first...
|
3 |
20.09.2006 15:22:36 |
|
|
Concatenate error/problem
Hi All,
Who can help me with this problem>>??
I have to concatenate 5 items (and between all items an ", " (comma)),
which I let lookup from a list containing 24 rows.
This is what I'm using:
=CONCATENATE((VLOOKUP(B28,I30:N54,6,0)),",
",(VLOOKUP(B32,I30:N54,6,0)),", ",(VLOOKUP(B36,I30:N54,6,0)),",
",(VLOOKUP(B40,I30:N54,6,0)),", ",(VLOOKUP(B44,I30:N54,6,0)),".")
In some cases my ...
|
5 |
20.09.2006 14:50:44 |
|
|
Prevent Auto Parse
This is the behavior I observe in Excel that I would like to change:
Excel 2003
1) Paste from a delimited text file (comma, tab, space, doesn't matter)
into Excel (text appears in a single column)
2) Parse using Data > Text to Columns
3) Clear all from current worksheet
4) Paste from the same delimited text file into that same worksheet,
any other worksheet in the same workbook, or even ...
|
2 |
20.09.2006 14:47:00 |
|
|
Help with SUMIF function
Hi,
I'm trying to add up a range of cells based on two IF statements, but with
no luck :(
What I was trying to do was:
=Sum(If (G3:G2224,"Home")*(M3:M2224,"Blue"),P3:P2224)
This doesn't call up the result that i want,which is the sum of the P cells
if range G = home and range M = blue.
Can anyone suggest a work around or point out to me what I am doing wrong?
All help would ...
|
5 |
20.09.2006 14:40:15 |
|
|
ExecuteExcel4Macro ...
I am using the ExecuteExcel4Macro to extract data from multiple workbooks
without having to open them first. It works very well until the routine
encounters a wb that is password protected. When this happens; the routine
prompts for a workbook password; is there a way around this? The password
for these workbooks is calculated based on the name of the workbook so the
password is always k...
|
1 |
20.09.2006 12:34:15 |
|
|
macro convert text
How can I quick convert with a macro my range text?
ex
column A B C D E F
2 row 12.54 45.28 74 33:20 1:52:35 8:45
convert "." with ","
convert ":" with "."
and if number have 2 value 74 add 00
and text time 33:20 add 0
and text time 8:45 add 0:0
result
12,54 45,28 74,00 0.33.20 1.52.35 0.08.45
many thanks
...
|
1 |
20.09.2006 10:50:43 |
|
|
Taking out domain names out of e-mail adresses
Hello,
In Excel I have a column with a few e-mail addresses. And I was wondering
if it's possible to take the domain name out of the e-mail address and put
them in the column next to it?
Thanks,
Ruben
...
|
2 |
20.09.2006 07:42:25 |
|
|
text in rows in small height
I have set up a fine grid (small row/column spacing) that I want to use
to display text at specific coordinates.
Is it possible to put normal sized text (let's say size = 10) in
'small' rows (let's say row height=3) such that the text is still
perfectly readable? Right now my text is cut so that only the bottom
part is displayed, the part of the text that extends into to rows above
is just n...
|
4 |
20.09.2006 06:16:17 |
|
|
Hello and Help with dropdown list with error control
Greetings all!!!
I am new to the group. thanks to the owner of the group for creating
it. I work for a cement company and i have made a excel sheet with
mixing of diffrent types of cements. I would like to know if anyone can
help. the problem is this i have a list of additives for each blend.
one can select them from a dropdown list. But some of the additives are
no conpatable with each ...
|
6 |
20.09.2006 05:47:51 |
|
|
Advanced Filter
I need help with my advanced filter.
I want to filter my customer list, sheet 1 to work sheet 2, with only the
customers located in Palm Springs, Rancho Mirage, Indian Wells, La Quinta &
Cathedral City, CA. In cell W43, I have inputed CITY & below that, W44:48
the cities as referenced above. How would I set up the criteria and
operators to do the advanced filter?
Thanks for you hel...
|
2 |
20.09.2006 00:16:50 |
|
|
Macro Help
I don't know very much about coding macros at all so I was wonder how I
would get one to change the content of a selected column's individual cells
based on that cell's content. For example, if have column A with either "e"
or "c" in each cell I want the macro to change the c's into 0's and the e's
into 1's. Is it possible to do something like that?
-- Bryan
...
|
3 |
20.09.2006 00:14:14 |
|
|
Excel Query Opens Source
All,
I am one of several offices supported by a purchasing group. This purchasing
group maintains the status of all purchases in an Excel workbook. They will
not open up the workbook for all. I have convinced them to let me create a
workbook that queries theirs and returns just my offices purchases. They
will have given everyone access required so that the query will work. As
long as the e...
|
1 |
19.09.2006 23:55:06 |
|
|
Excel Quering Excel
All,
I am in one of several offices supported by one purchasing office. The
purchasing office keeps all purchasing actions in one Excel workbook. The
purchasing office does not want offices to see the other offices purchases.
They have agreed to me querying their workbook from one of mine. The query
only returns our purchases. The workbook is read for all, but is buried deep
in their ...
|
1 |
19.09.2006 23:49:44 |
|
|
Excel VBA Password Vulnerability
Hi All,
I have written an Excel spreadsheet which I share with others, who may
then share with others.... I would like to keep my coding in the VBA
Project private.
Doing some research on the web, I found that password protecting the
VBA Project provides protection which is easily sidestepped by various
"Password Recovery" software packages, many of which are free.
Can I protect my c...
|
5 |
19.09.2006 22:17:32 |