|
Need Help Editing Cells
I am using W XP and Excel 2003. I have an XLS file that was created
from a CSV file. Column D of the Xls file containd a great deal of data
that is still comma seperated. For example a row may have Ford, Chevy,
Dodge... Another row in the same column may have Dodge, Honda,
Toyota...
What I want to do is delete the contents of any cell in Column D that
does not contain Honda. Any cell that ...
|
8 |
19.09.2006 07:56:26 |
|
|
Averaging Columns based on a Text String
Hello: I am attempting to average columns that have headings of
Inventory. My spreadsheet consists of the following column headings:
Inventory, Sales, Purchases. Each week I run a query that posts
Inventory, Sales and Purchases for 450 Inventory items.How can I
average the column heading of Inventory for the 52 weeks across these
column headings. I tried using average(if(a1:a52 ="Inventory", a2:...
|
10 |
19.09.2006 02:16:01 |
|
|
Why won't inserted objects print in excel?
When inserting object or clip art into Excel they do not print in the
finished document.
Bob...
|
4 |
19.09.2006 01:54:02 |
|
|
countif but have two criteria
I have a cell range that has 3 different types of cells in it. It's about
training, some have date or period when training was completed, some have
"due" plus date or period, and some are blank, yet to be filled. I need to
add the blank cells to the due ones, tried countif but only one criteria
allowed, tried sumproduct (--(A1:A500="*due*"),--(A1:A500="")) didn't work
(value error in par...
|
15 |
18.09.2006 20:28:02 |
|
|
Need help inserting picture into header/footer
I am using Excel 97 and I am trying to insert a picture file into a custom
header. I see when the header box opens up that you can insert file but yet
it doesn't show me how to insert the actual file.
Any help is appreciated.
Thanks
...
|
3 |
18.09.2006 20:22:09 |
|
|
How do I draw a circle around a cell I want to highlight
How do I draw a circle around a cell I want to highlight - I want to
see the text within the cell and colour the circle red. I tried
inserting a circle from the 'drawing toolbar' but I couldn't see the
text in the cell.
i have seen Excel worksheets with this feature and would like to
emulate it.
Thanks,
Janev...
|
4 |
18.09.2006 20:17:15 |
|
|
Excel 2003 Accountibility
I am in need of some experts to guide me in my spreadsheet. I am trying to
put an accountibility sheet together and I would like to do this. I have a
subject in A1 cell. that is constant. And I have given B1 a constant value.
Now In cells C1-H1 I will be inserting a daily count. What I would like to do
is put in the count yet I would like for It to total in the cell automaticly.
Example....
|
4 |
18.09.2006 17:59:02 |
|
|
colomns got swoeched
Hello. I think a certain colome of cells got swieched some how. with out
movingthem by hand how can I re swotch them? thanks. example
13b is where 12b is supposed to be. Thanks.
...
|
12 |
18.09.2006 17:02:01 |
|
|
Grouping patters of numbers in cell
Sir ,
i want to numbers written in cells be displayed as grouped in indian format
i.e. a number of 123456.00 can how be automatically group as 1,23,456.00
instead of 123,456.00...
|
10 |
18.09.2006 10:58:54 |
|
|
Select NON blank cells
I want to click on a cell and have only the cells that contain data in that
colum to be visible.(Lets assume I click in cell b5, then I want only the non
blank cells in col 5 to be visible)(ie the same as using "SELECT all NON
BLANK cells)
But I want a macro to do this. Any help will be appreciated
Thanks
Ian ...
|
9 |
18.09.2006 09:55:02 |
|
|
Vlookup multiple
We have invoices by company name how can we select all the invoices with 1
vlookup ex:row a1 A10 A13 A17 all are for (john)
all of them are for for the same customer we want to have several lines on
invoice for each invoice automatically filled itemized with vlookup, or what
is if we need only invoice from a10?...
|
4 |
17.09.2006 03:59:01 |
|
|
i forgot the password used for the exel sheet
I had used a password as a security in the excel sheet n now i have forgotten
my password so what should i do its an important data.
...
|
3 |
15.09.2006 16:09:52 |
|
|
Formatting help needed
I have started an extremely basic sheet and only want to put opening times of
buildings, eg.. 2 - 5 but cannot get rid of 2-May. I've tried using general
in category but still get 2-May instead of 2 - 5. Can you help?
--
Lynne Mawson
Manchester...
|
5 |
15.09.2006 14:25:18 |
|
|
How do I get the focus on a check box?
I've built a form in Excel. I've protected it. When the user is tabbing
down through the form I want it to stop at the check box so the person can
check it. Also, how do I change it from checking it with the mouse to just
hitting the space bar and having it check?...
|
2 |
15.09.2006 13:52:02 |
|
|
i renamed a file i needed and lost the info how do i get it back?
I had 2 files with the same name in excel. After I excited excel, I wanted to
rename my new file, and I thought I was renaming the new file, but I actually
renamed the old file I was working in and when it said this file exists do
you want to change I said yes. I lost all my work. How do I get it back?...
|
2 |
15.09.2006 13:14:06 |
|
|
Stopping spreadsheet save
Hi
We have a spreadsheet that we share among users by keeping it on a shared
location on server. The problem is that we want everyone to be able to
modify the sheet but we want to stop users making copies of the sheet to
avoid versioning issues. Is there a way to do that?
Thanks
Regards
...
|
3 |
15.09.2006 08:19:11 |
|
|
Putting a word into a cell.
I would like to put a word into a cell depending on the value in another
cell.
Example:
Cell A1=399
Cell B1=401
Cell C1=400
Cell D1= Pass or fail
So if C1 is within or equal to A1 and B1 I would like D1 to say Pass.
If C1 is outside the range of A1 and B1 I would like D1 to say Fail.
Also if its Pass I would like it to be Green text and Fail to be Red
text.
Thanks in advanc...
|
3 |
15.09.2006 07:03:07 |
|
|
Find replace
Here's an easy one for you clever people, how do I find and replace on a
single sheet or column? please.
D R
...
|
6 |
15.09.2006 02:59:36 |
|
|
Lottery check
We buy 35 tickets twice a week and always the same numbers. Can I make a
spreadsheet that will check our tickets against the winning numbers? ...
|
14 |
15.09.2006 01:13:01 |
|
|
Two excel problems
I am using Excel 2000, I have two problem, one small, one big
Small problem
I have a worksheet with just under 5000 rows and half a dozen columns. Two
of the columns contain telephone numbers. Unfortunately in the conversion
of the data to get it into a format that excel could use the leading "0"
was stripped from the phone number, how can I put the "0" back in again (I
don't have access...
|
6 |
15.09.2006 01:09:02 |
|
|
Problem Importing Fixed Width Data
I have a data set of about 700 entries from an old Pascal program that
was exported to a text file in this fomat:
ID # : 10106
Sex : Female
Raw Scores : 1 4 1 0 3 6 3
T Scores : 53 114 65 43 64 83 42
I need the headers to be ID#, Sex, Raw Scores 1-7 and T Scores 1-7 and
then to pick up the data and place it in the appropriate cell. Since
the format is inverted, ...
|
8 |
15.09.2006 00:42:44 |
|
|
How do i set up a budget with self totalling column
I have made a basic budget with columns
Date, Money in, Money out, Balance
what I want to know is if there is a way for me to put a formula in the
Balance column which will recognise if there is a number in the in r out
column and if it is in the IN to add it to te previous balance and if it is
in the OUT to minus it from the previus balance
Thanks I hope someone can help
Kristie...
|
3 |
14.09.2006 23:40:07 |
|
|
highlight color in cells
I am very new to Excel, but I know this just isn't right. Whenever I fill a
cell with a color it doesn't show up colored in my workbook sheets. It does
in print preview. I have tried just highlighting and filling a cell wil
color, using conditional formatting and coloring them that way. Nothing
seems to work, my Excel pages stay white....
|
6 |
14.09.2006 21:55:02 |
|
|
How can I move Excel to my new computer?
I bought a new computer. I have Excel 2002 (10.6501.6714) SP3 on my old
computer. I need it on my new computer. How can I move it from my old
computer to my new computer? Both computers are running Windows XP, Version
2002, Service Pack 2. ...
|
4 |
14.09.2006 18:44:49 |
|
|
Adding numbers in a column
I've been noticing that Excel 2003 is incorrectly adding up the numbers in a
column. Anyone know why this is and is there a fix for it?...
|
10 |
14.09.2006 18:14:02 |