|
|
|
June 10th, 2009 09:08 PM
by Donna
|
2 |
99 |
|
|
Auto Assigning Number to Excel Invoice by
Angela Rose
I have been using a template created in Excel 2000 for my business invoices
for 7 years. This template had a tool box which allowed me to assign a...
|
|
5 |
154 |
|
|
undo feature non-functioinal in Excel by
Bonnie P
Why is the undo feature not working in Excel? Both it and the forward
feature are "greyed out" on my toolbar. Undo only appears functional if I
have not...
|
|
0 |
85 |
|
|
IF _Different Values- by
Rick.[_2_]
I'm working on a formula for Split Shift (SS), Having different hourly rates
and different hours worked.
For example, Rate 1: @ $8.25/hr if the employee (EE)...
|
|
1 |
102 |
|
|
Percentage of a count data in Pivot table by
Krish
I have a pivot table pulled from a database. The database has Invoice
number, line number, product number, customer number and operator code
taking the order....
|
June 10th, 2009 07:32 PM
by Krish
|
0 |
83 |
|
|
|
|
4 |
95 |
|
|
how to use data table by
steve
I've used it in previous versions, but not in 2007. I have 2 input cells
that I would like to vary. I assume the top and left side of highlighted
area will...
|
June 10th, 2009 07:04 PM
by steve
|
3 |
79 |
|
|
|
|
3 |
97 |
|
|
|
|
4 |
142 |
|
|
Please help by
Nina
I'm working with a spreadsheet that has +/- on the far leftside of the page.
Once you click on the icons they collapse the row. How do i do that with
other...
|
|
2 |
74 |
|
|
Ranking Question by
PJFry
I am dealing with a dataset that has a many ties in it. This is a list of
sales from 2008 to current, by customer and I need to rank on total sales.
In...
|
|
3 |
75 |
|
|
Entering time by
C
Is there a way I can enter various times and have the colon automatically
inserted for me instead of having to manually enter it every time?
|
|
1 |
85 |
|
|
What type formula to use? by
CE
Hi,
I need a formula that takes into account todays date before it adds the row
range.
The spreadsheet I'm working with has 2 tabs. On the second tab are...
|
|
6 |
116 |
|
|
Help with this formula by
Nelson
Here is what I have
=SUMIFS((L8:L23, B8:B23),"=D03KHLL",year(A8:A23),=2008))
L8:L23 are the amounts
Criteria 1
B8:B23 (which are the part numbers...
( 1 2)
|
|
14 |
158 |
|
|
Formula question by
Kristal_81
I am trying to find a formula to copy the rows that contain "suzanne" in
column C and "open" in column B to another worksheet...anyone have any
ideas???
|
|
2 |
77 |
|
|
getting rid of blanks by
thislibrarian
Is there a way to automatically remove blanks from my colums of text data. I
want to remove the blank cells and move the others up without having to
select...
|
|
1 |
87 |
|
|
Page setup stuck on portrait mode by
bobtex
Excel 2003 SP3
Vista Ulimate SP1
Page Setup is not changing from portrait to landscape mode. Landscape
selection button works, but it will not change from...
|
|
3 |
171 |
|
|
|
June 10th, 2009 02:50 PM
by Luke M
|
1 |
105 |
|
|
Lookup multiple values by
willemeulen[_31_]
A need to retrieve a price depending on three values
Material, class and size
Material = B5
Class = C5
Size = D5
Vlookup column table
Sheet1 A4:H69
|
|
3 |
116 |
|
|
how do i use the roundup function by
Leprechan
I have prepared salary scales using simple formulas where the calculations
are based on a % increase. I would like the answers to be rounded up eg:
$27.997...
|
June 10th, 2009 02:30 PM
by Luke M
|
8 |
86 |