|
|
|
|
2 |
1,193 |
|
|
Keeping Formulas Not Data by
Jenni R
I 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...
|
|
1 |
902 |
|
|
|
|
2 |
887 |
|
|
Data Labels in Excel Pie Charts by
Marlaine
How 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...
|
|
0 |
920 |
|
|
COUNTA or COUNTIF or COUNT by
Liz
Trying to count the times "YES" occurs in column C3:C5 for each time "Bill"
indicated in column B3:B5?
--
Thanks - liz
|
|
4 |
887 |
|
|
Formula to pull the lowest supplier name by
Cassius
I 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...
|
|
3 |
957 |
|
|
Lookup values based on column headers? by
Doug
I 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...
|
June 4th, 2010 11:18 PM
by Doug
|
2 |
926 |
|
|
Racking my brain on sumif by
Victor R.
I 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 ...
|
|
4 |
910 |
|
|
vendor matches by
John
This 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...
|
June 4th, 2010 10:43 PM
by John
|
6 |
1,188 |
|
|
Size of file with pivot table by
Nadine
I 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...
|
June 4th, 2010 09:44 PM
by Nadine
|
2 |
954 |
|
|
iserror and ifs nested formulas by
Vicki
Please 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...
|
June 4th, 2010 09:34 PM
by Vicki
|
4 |
846 |
|
|
Looking up next available number by
Nadine
I 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...
|
June 4th, 2010 09:34 PM
by Nadine
|
3 |
889 |
|
|
barecode command by
bgs
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...
|
June 4th, 2010 09:10 PM
by bgs
|
0 |
762 |
|
|
Workbook causes calculation errors by
Luke M[_4_]
I've never seen this error before, and unfortunately, my Google searches
keep bogging me down with the simple "Automatic/Manual" solution...
I have Workbook...
|
|
2 |
1,031 |
|
|
|
June 4th, 2010 06:29 PM
by CBB
|
0 |
843 |
|
|
Concatenation help by
Nadine
I have 3 cells I need to merge into one. One of the cells is a number
anywhere from 1-16 or more. What I need is for the number in this cells to
always be...
|
|
8 |
1,057 |
|
|
Counting question by
John
In column A I have set of characters that are entered into the rows below
(i.e. Y, N, MRO) in column B I have another set of characters that are
entered into...
( 1 2)
|
|
16 |
1,642 |
|
|
Multiple IF's with an OR by
Nadine
Cell DQ contains a formula that pulls in the status of the item.
Here is my existing formula so...
|
|
5 |
949 |
|
|
|
|
2 |
872 |
|
|
|
June 4th, 2010 04:40 PM
by John
|
0 |
816 |