|
|
Text comparison in adjacent cells by
Andy
Can Excel show the differences in text strings which appear in different cells
eg changes of wording in similar phrases
--
Thank you very much
Andy
|
|
3 |
75 |
|
|
If Statement - Basic by
Portuga
Bit of basic question.
If A1 = 0 then B1=No, else B1=Yes
How can I do this using an if statement?
Thanks
--
|
|
2 |
88 |
|
|
Checking & Forcing Data Entry in Cells by
robertguy
Hi,
Can anyone help me please ?
What I’m trying to do is to ensure a user inputs data into a series of
cells correctly e.g.
If the user inputs data (numbers...
|
|
1 |
84 |
|
|
Parsing Problem by
Gloria Lewis
I need to be able to parse my records into seperate columns: Size, Material,
#ofColors, Coating, Finishing, Custom Specs.
The delimiter is ||. I tried using...
|
|
6 |
113 |
|
|
Macro Print Numbers by
dah
Hi:
I have a macro written but the enter value does not print. . .any
thoughts?
When the user enter an order number into the message box I want the
following...
|
|
1 |
106 |
|
|
|
|
2 |
112 |
|
|
Matrix formatting by
Corey
I have a matrix similar to below. I'd like for those amounts that agree to be
shaded and those that do not, to not be shaded. For example, everything in
the...
|
January 23rd, 2006 06:20 PM
by Corey
|
9 |
102 |
|
|
Help, experts needed! Auto notification by
Melanie
I have an excel spreadsheet with five columns. On column D I have a drop
down list with four choices ("n/a" , "Grp1" , "Grp2" , "Grp3"). When a row
is filled...
|
January 23rd, 2006 06:22 PM
by Melanie
|
1 |
57 |
|
|
|
January 23rd, 2006 06:42 PM
by Kassie
|
2 |
71 |
|
|
How to sort in excell by
Crosscom
Have a large excell file and when trying to sort the entire file w/o the
heading rows, an error comes up "this operation requires the merged cells to
be the...
|
|
2 |
83 |
|
|
Excel 2003 to PDF/X-1a by
Mapgirl
I have been trying to convert some Excel "graphics" into PDF/X-1a files so I
can place them in Adobe InDesign.
When we used regular PDFs, it didn't embed the...
|
January 23rd, 2006 07:07 PM
by Mapgirl
|
2 |
85 |
|
|
Date Formatting problem by
laralea
Seems simple enough, but how do I change the formatting of the first two to
match the 2nd two. I've already tried various ways to reformat the date
including...
|
|
5 |
70 |
|
|
|
|
3 |
92 |
|
|
Not Sure How to Fix by
Phil
http://www.officialenter.com/excel_.jpg
This shows a picture of the issue I am having.
How do I make this spreadsheet look the way that I am used to?
With...
|
January 23rd, 2006 07:12 PM
by Pete
|
8 |
102 |
|
|
Hyperlink updates within same worksheet by
laralea
I have several hyperlinks in Sheet1 to cells within the same worksheet. Is
there a way to update all the hyperlinks at once? I tried Edit Links
update...
|
|
1 |
74 |
|
|
|
|
3 |
71 |
|
|
Multi-State Sales Tax Computation by
CraigR53
We sell products to about 20 states. I need to compute the sales tax for each
sale based on the state in which it is sold. I propose to set up a table --
Col...
|
|
3 |
72 |
|
|
Denying access by
cware
While at lunch or vacation day, or whenever, I have a file clerk who gets
into my computer to use Excel and changes my defaults or in general screws up
my...
|
January 23rd, 2006 07:37 PM
by Nick B
|
1 |
64 |
|
|
Excel is creating "files" with every save. by
shannonvds
Everytime I or anyone else (shared spreadsheet) makes a change and then saves
the spreadsheet, it creates a "file" with no properties or extension. These
are...
|
|
5 |
74 |
|
|
date function by
Pam Coleman
If I have dates listed in a column as 06-0101 etc, how can I format it to
be: 20060101? I have 7000 rows where I need to reformat the date.
Help.
|
|
5 |
111 |