need help
目前分類:title (3013)
- Aug 14 Mon 2006 20:08
How do I set up a spreadsheet to landscape?
- Aug 14 Mon 2006 20:08
Filtering Pivot Table Data
My source worksheet has a position number, specialty rating, pay grade,
incumbent name, etc. In the past I have successfully used Pivot Tables to
- Aug 14 Mon 2006 20:08
What is a compound document?
- Aug 14 Mon 2006 20:08
Need help for a macro
Hello
I am using excel 2003 and WindowsXp Professional and Adobe Acrobat 6
- Aug 14 Mon 2006 20:08
Range and dates
I am trying to keep track of attendance. I want to be able to retrieve dates
of when a student is absent. How can I do that?
- Aug 14 Mon 2006 20:08
VLookup amp; Column Sum
I need help with a formula that will be able to lookup a part name and when
it finds it a worksheet it can sum the weekly values to return the monthly
- Aug 14 Mon 2006 20:08
VLOOKUP question
Hi
Can vlookup return more than 1 column?
- Aug 14 Mon 2006 20:08
How do I upload an Excel template file onto my Windows Smartphone
I have a Motorola Smartphone with Windows OS. One of the programs I want to
use is a 3rd party spreadsheet that is highly touted as being completely
- Aug 14 Mon 2006 20:08
vlookup returns last value in array
I'm running a vlookup on a list of customer accounts to find what store is
closest to the customer by zip codes. However, for every single customer, my
- Aug 14 Mon 2006 20:08
Need 6 Conditions / Conditional Formatting
I have a worksheet with six numbers in cells B61:G61.
- Aug 14 Mon 2006 20:08
How do I configure Analysis Services for Excel 2003 users?
Hi,
- Aug 14 Mon 2006 20:08
Automatic Calculations
I have been using a workbook for many years without problem, but it has
stopped automatically updating formulas. Is there a switch somewhere that I
- Aug 14 Mon 2006 20:08
Formula to enter to round an Excel value up to the next $0.5?
If I have a value of $10 and add 10% by dividing by 0.90, I get $11.11 which
I would like to round up to the nearest $0.5, i.e. $11.15.
- Aug 14 Mon 2006 20:08
Excel Help with pictures plzzz
I want to create an inventory and have as the first cell in each row a
picture of the product. I would be able to click on it an enlarge the image
- Aug 14 Mon 2006 20:08
Formula for Auto filter
I have a total field in a workbook. I run an autofilter, and it shrinks the
records down to a few, is there anyway to have the filtered fields total the
- Aug 14 Mon 2006 20:08
count from several worksheets
I need to count the number of times quot;Yquot; occurs on several worksheets. I keep
getting an error with COUNTIF. Help!
- Aug 14 Mon 2006 20:08
find and replace
How to I find and replace when I need to take data that is in rows and move
it all into the first row, but separated by commas?
- Aug 14 Mon 2006 20:08
Combo boxes and formulas
I have inserted several combo boxes into my form. I was able to populate the
dropdown lists by entering the name of the cells (product) in the 'List Fill
- Aug 14 Mon 2006 20:08
Calculate Difference between 2 columns in Pivot table
I would like to know if the Pivot Table can calculate the difference between
two columns of data for me. For example, I have the amount of loans in
- Aug 14 Mon 2006 20:08
Remove quot;(blank)quot; in a pivot table?
Pivot table returns quot;(blank)quot; if field is empty. Can this be shut off or
hidden?