excel 06-05-1011002 (6/5/2010 5:57:02 PM) UtfI have a spread sheet and in it i have data validation tables when i finish
picking from them and email the sheet i then want to clear the info in the
tables but not the data validation table and not usr ma...

what tab for calculating percent and decimal?1856 (6/5/2010 5:16:05 PM) UtfI want to find the percent for each column. Which tab do I click to get the
drop down choice for percent. I found it once and forgot to remember it. I
also remember seeing the dropdown had decimal as wel...

sum by rows in Pivot1622 (6/5/2010 4:44:48 PM) UtfHi,
see table below.
Col A Col B Col C
a 1 7
s 4 9
x 8 4
d 9 3
v 4 2
b 3 5
n 6 6
m 9 8
r 2 9
d 4 1
a 6 9
f 7 5
See Excel 2007 Pivot table result below.
Values
Row Labels Sum...

Simplify Weighted Average Formula41576 (6/5/2010 4:04:38 AM) UtfI have a s/s that has the months of the year across the top and below 3
categories for each month and I want a weighted avg for each product. eg:
A B C D E F G H I
Jan...

How to Convert 24/03/2010 as text into 03/24/2010 date format3704 (6/5/2010 4:34:29 AM) UtfHi ,
I’m using Ms Excel 2003 and in my excel sheet there is a column in which
dates are entered as DD/MM/YYYY (e.g. 24/03/2010 as a text) format and I
wanted to convert it into MM/DD/YYYY (e.g. 03/24/201...

How can i protect a formula and still allow copy and move data?1980 (6/4/2010 12:03:04 PM) Utfi have 12 columns with data on days and each new day i want to add a new day
to the set of 12 columns without adding a 13th one. So the oldest day are
removed and the view is still 12 days.
In these colum...

Create Formula for Weighted Average in non-consecutive cells01029 (6/5/2010 4:04:37 AM) UtfI have a spreadsheet which across the top has the months Jan to Dec and
Total. Under each month is 4 categories Days/oil/gas and would like to
simplify a formula for a weighted avg. eg.
A ...

Fill in Column with a series of repeating numbers22085 (6/4/2010 10:53:41 PM) UtfI am trying to fill in an amortization years column. The first 12 rows are
"1", the next 12 rows are "2", the next twelve rows are "3" and so on. I've
got 360 rows to fill. Any suggestions?
...

Keeping Formulas Not Data1957 (6/4/2010 11:21:23 PM) UtfI input my formula, but would like to fill in the data later. How do I save
the Formula without there being data. I am trying to create time sheet that
will be filled out weekly so the data will change. I w...

F4 no longer automatically creates absolute reference21557 (6/4/2010 7:46:18 PM) UtfI select the text of a cell name (A1, for example), hit F4, an nothing
happens. I have to go in and type my $. How do I reset F4 to work?
...

Data Labels in Excel Pie Charts01134 (6/4/2010 10:53:41 PM) UtfHow do I get the data labels to stay where I put them in pie charts. I have
a series of pie charts set up and update the data they are based on monthly.
I find that most of the time when I go to the pie c...

COUNTA or COUNTIF or COUNT4771 (6/4/2010 7:48:28 PM) UtfTrying to count the times "YES" occurs in column C3:C5 for each time "Bill"
indicated in column B3:B5?
--
Thanks - liz
...

Formula to pull the lowest supplier name3704 (6/4/2010 5:04:08 PM) UtfI need assistance creating a formula to extract the supplier name associated
with the lowest supplier bid. A sample of the data looks like this. I need
to be careful as some quotes will be zero and I do no...

Lookup values based on column headers?4896 (6/3/2010 9:37:10 PM) UtfI have a data validation dropdown list box in "sheet1" cell $J$1. Depending
on what I have selected in that dropdown list I would like it to match or
lookup the data with the respective columns the heading ...

Racking my brain on sumif4598 (6/3/2010 9:19:47 PM) UtfI have a report download that roughly looks like this:
Part # Date Qty
1234 6/1/10 25
1234 6/3/10 50
1234 6/7/10 100
4567 6/1/10 75
4567 6/3/10 45
4567 6/7/10 20
I ...

vendor matches61124 (6/4/2010 2:03:51 AM) UtfThis is my first question on this site, so I hope I hope this makes sense.
I have vendor numbers in Col A-each vendor number would only be listed one
time and not in numeric order. In Col B-- I assigned...

Size of file with pivot table21229 (6/3/2010 11:57:01 PM) UtfI have a file that was 8MB when I started. I created a pivot table pulling 7
fields from a worksheet. Now the size is 20MB. Any ideas why this one pivot
table would cause the file to be so large when the...

iserror and ifs nested formulas4692 (6/4/2010 5:05:25 PM) UtfPlease help!
I am trying to get the formula below to return a value to the cell ONLY if
the answer to ((c30-$30)/g$30) is greater or less than 20%.
I am using the below formula.
=IF(ISERROR((C30-$G30...

Looking up next available number31168 (6/3/2010 10:52:19 PM) UtfI have columns numbered for payments. A PO can have any number of payments.
A PO can be shown on any number of rows as the resource being billed against
the PO can be any umber of resources.
I need to writ...

barecode command0644 (6/4/2010 8:10:54 PM) Utf customize toolbar , all commands, barecode cammand,
after barecode command has been placed in toolbar, it has not funtion, i am
unable to click on it , under help it states that one the stand alone version...