|
how do I get the comma delimited feature to work in excel
I have a .csv file that is supposed to be separated at the comma's into
columns. How do I get the comma delimited feature to work?...
|
16 |
29.09.2006 15:18:01 |
|
|
Pivot Refrest with New Data?
I have a file, including a pivot table, that I would like to use as a
"template" without having to regenerate the pivot table each time. In other
words, I would like to add to the data or replace the data and then just do
the equivalent of a refresh on the pivot table. Is this possible? From what
I've seen, the pivot table is locked into a certain range so if new data
doesn't fit the ...
|
4 |
29.09.2006 15:06:01 |
|
|
Issue w/ Autofit Row Heights
Why does the "Autofit" feature for row heights not work with merged cells?
Is there a way to get this to work....
|
13 |
29.09.2006 14:35:01 |
|
|
Selective Autofilter Application
When I apply the autofilter funtion, it does so accross all existing columns
of my worksheet. Is it possible to apply this functionality to only a few
selected columns, and how do I go about it ?
Kind regards...
|
8 |
29.09.2006 14:13:47 |
|
|
Using Filters
Hi I am using Excel 2000 and have filtered a list so my result shows for
example rows: 1 56 159 241 410 but when I copy and paste into a new
sheet I start in A1 to paste and the information goes into A1, A2, A3, A4,
A5. Is there anyway that I can get the pasted information to reflect the row
numbers from the previous sheet?
Many thanks
--
Kind regards
Ann Shaw...
|
3 |
29.09.2006 14:08:06 |
|
|
sum first 2 chars if 3rd is something...
hello,
I got a row of data formated in xx-yy, where xx represents percentage
(number), - is delimiter from and yx definition as letter+number. (e.g.
55-A1, 60-V2...)
What I want to do is sum only first two xx values, if y equals A for
the whole row.
I tested the sum finction =SUM(VALUE(LEFT(a1:a10;2))), which in
function dialog view sums the values correctly, while in the
spreadsheet...
|
14 |
29.09.2006 13:30:06 |
|
|
A tricky Excle table - Dialogue using Google spreadsheets ?
Hi,
I have an Excel problem that I would like to discuss (and hopefully solve)
with some Pivot Table and Graph experts.
It involves getting data from a list into a PT, doing some tricky
calculations, then showing the PT in a graph.
I tried to explain the problem here earlier but received no help. But it's
understandable.
I think there are two major difficulties :
1. It is a complicat...
|
2 |
29.09.2006 13:16:42 |
|
|
Counting
I need to multiply the total number of items in my column Q (e.g. POD's
delivered) by the different tonnages in column L to get a total tonnage
result? There are 186 rows. Any ideas please?...
|
2 |
29.09.2006 13:14:31 |
|
|
Refreshing calculations
I have created a workbook with several worksheets and the formulas do not
calculate unless it is changed on the computer where the workbook was created.
...
|
6 |
29.09.2006 13:09:19 |
|
|
Deleting unwanted data
Hi Guys,
I have a situation where a company has had one if its divisions closed
and all of their products need to be removed from the product listing in
Excel.
I need to remove about 150 products from the product listing which has over
2500.
Is there some way to compare the two lists and then delete the products from
the main list.
regards
Paul...
|
3 |
29.09.2006 12:43:02 |
|
|
US date (text) to AUS date
hi, we have a column of american dates which is only formatted as text. we
need to convert to australian date format, but nothing works.
any suggestions would be great
thank you...
|
5 |
29.09.2006 12:41:55 |
|
|
Saving to Sharepoint
Hello,
We have an Excel spread sheet which is links to several word documents
through hyperlinks, all the documents are stored in a single sharepoint
library.
We have found that when the word documents are opened from the spread sheet
its no longer possible to save the documents straight to the library, instead
we have to navigate back to the document library through the save menu....
|
2 |
29.09.2006 12:23:01 |
|
|
Inserting a file in a work sheet in excel
Using Excel 2003
I want to combine a number of worksheets into one. Like you can i do with
docs in Word to produce one document. Is there any other way of doing it
rather than copy and paste?...
|
2 |
29.09.2006 12:22:02 |
|
|
How do I keep my column titles when I move down the page?
I'm using Excel. When I scroll down the page the titles I put at the top of
each column dissappear off the screen,how can I keep them on sceen at all
times while useing the excel sheet?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If y...
|
3 |
29.09.2006 12:11:02 |
|
|
excel - removing duplicate entries in spreadsheet
i have a spreadsheet with over 5000 names and adresses. many of these are
duplicated. is there an easier way to delete duplicates other than re-sorting
data to appropriate column and deleting line by line?...
|
2 |
29.09.2006 12:05:02 |
|
|
In Excel can I automatically highlight the row im working on?
When Im working in excel it shere ay way to automatically highlight the
entire row im currently on? so when I moove the bow to a new row the
highlight moves too?...
|
3 |
29.09.2006 11:53:01 |
|
|
Automation Classes / Methods, overview or list
Hello,
Does anyone in this forum know where to find either a white paper providing
an overview for Excel automation services. Even better would be if anyone
could tell me where to find a list of all Excel automation classes and
services with their parameters.
In advance thank you very much,
Ole Schjoeth, Denmark...
|
1 |
29.09.2006 11:21:01 |
|
|
X-Y axis names
My X-Y axis are showing 1,2,3.. How do I change Y axis to a,b,c.....
|
2 |
29.09.2006 10:53:31 |
|
|
Column Data to Rows
I have budget information to be imported as text to my financial suite. The
date data (which remains the same) is on row 5 columns 'R' to 'AC'.
The data on rows 7 to 107 are individual ledger accounts related to the 12
months in R5:AC5.
I use =INDEX(ATWS!$5:$5,ROWS($1:$18)) to copy down the dates and
=INDEX(ATWS!$7:$7,ROWS($1:$18)) for each months budget for that line
(account).
...
|
1 |
29.09.2006 09:36:01 |
|
|
viewing newly created access queries in excel via msquery
This is hopefully something simple that I've overlooked. I'm trying to
update an existing Excel pivot table using the refresh command. The table is
refreshed from an access database containing many (30+) queries. I connect to
Access via ODBC, using MSQuery to display a list of queries from the
database. I have just created a new query in the Access database. The
problem is that MSQuery...
|
1 |
29.09.2006 09:32:02 |
|
|
Using IF in a formula
I am trying to enter multiple IF values into one cell. I enter all the values
and when I try to close out of the formula an error comes up and will not let
me. Do I have too many values? here is what I am trying to enter:
IF(C5<=0.49,"6",IF(C5<=0.99,"5.75",IF(C5<=1.49,"5.5",IF(C5<=1.99,"5",IF(C5<=2.49,"4.75",IF(C5<=2.99,"4.75",IF(C5<=3.99,"4.5",IF(C5<=4.99,"4.375",I...
|
5 |
29.09.2006 09:18:06 |
|
|
SUM VLOOKUP
Here is my formula:
=IF(A2>0,(IF(ISNA(VLOOKUP(A2,INDEX('RUNNING DATA
wkly'!$3:$3,1,MATCH($G$1,'RUNNING DATA wkly'!$1:$1,0)):INDEX('RUNNING DATA
wkly'!$6000:$6000,1,MATCH($G$1,'RUNNING DATA
wkly'!$1:$1,0)+2),3,0)),0,(VLOOKUP(A2,INDEX('RUNNING DATA
wkly'!$3:$3,1,MATCH($G$1,'RUNNING DATA wkly'!$1:$1,0)):INDEX('RUNNING DATA
wkly'!$6000:$6000,1,MATCH($G$1,'RUNNING DATA wkly'!$1:$1,0)+2)...
|
2 |
29.09.2006 09:10:02 |
|
|
Copying cell values to a external file in VBA
Im looking for a piece of code which looks through cells and exports
the text in the cell into a .txt file. on each new row, column A must
contain a 2, if not the macro stops. Also after every cell copied into
the txt file, a comma needs to separate the values in the txt file.
for example this is my data:
A B C D E
F
2 5977494A Shaw Ann ...
|
7 |
29.09.2006 08:07:27 |
|
|
How do I have the date in a spreadsheet change automically.
I have created a spreadsheet in Excel 2003. This spreadsheet lists
contractors and whether or not they have public liability or workcover
insurance. The spreadsheet shows what date their insurance expires on. I
would like to know if it is possible for the cells to change colour
automically when the date changes. For example if the date expires on the
31/8/06 can I set up a formula to hav...
|
2 |
29.09.2006 08:05:02 |
|
|
How do I group alpha numeric data in excel?
sI have been tasked with taking customer data and reviewing the minimum
threshold for all of our bulk oil products. The spreadsheet contain approx.
15 columns and 30,000 rows of data. The data I am particularly interested in
contains product codes. At the end of every alpha numeric code is a package
type descriptor. I need to have the ablility to select only the data
contianing the bulk ...
|
3 |
29.09.2006 07:42:41 |