I have a list of companies A1:A100, and I have a table b1:c5000 that has
companies and industries.
目前分類:title (5957)
- Aug 28 Tue 2007 20:38
Lookup based on fractional value
- Aug 28 Tue 2007 20:38
Edit Built in Footer
- Aug 28 Tue 2007 20:38
password protected page not opening by web query
i created a web query for accessing a password protected page. now after
closing and restarting excel, that query says -quot;web query did not return any
- Aug 28 Tue 2007 20:38
30 Day Moving Average Ignoring Blank Cells
I have a column of data covering 365 days, some of the cells have data and
some don't. I am trying to figure out how to calculate a 30 day moving
- Aug 28 Tue 2007 20:38
sort source workbook data, maintain formulas in destination workb.
I am setting up a workbook that has cell formulas linked to data in 2 other
workbooks. I want to know if there is a way that I can sort the data in the
- Aug 28 Tue 2007 20:38
How can I set up week to date report?
I have applied a previous workbook that utilizes two worksheets. Now
everyone in my department would like me to do the same but I am having some
- Aug 28 Tue 2007 20:38
Nested IF statements
- Aug 28 Tue 2007 20:38
'Different' kind of Stack-up chart
I would like to plot a stack-up chart.
CountryModelVolume
- Aug 28 Tue 2007 20:38
Document Not Saved Error Message
I was emailed an Excel workbook. When I make changes and then try to save
the file, I get a pop-up saying quot;Document Not Saved!quot;. The file properties
- Aug 28 Tue 2007 20:38
Why when I enter 1234 do I see 12.34 in Excel ?
My cat stood on my keyboard and now all the numbers I input seem to be
divided by 100 when entered. If I add a decimal point it is entered
- Aug 28 Tue 2007 20:38
Format Cell to show quot;-1quot; in subscript
I want to format a number to quot;-1quot; in subscript.
- Aug 28 Tue 2007 20:38
how to have result field blank
In a workbook, have a data entry sheet that is protected except for fields
for answers. These fields (shaded yellow) are formatted as accounting. The
- Aug 28 Tue 2007 20:38
Hiding carriage return
I have an Excel spreadsheet that contains carriage returns in some of the
cells. This is necessary to get the lines to wrip where I want them to. On
- Aug 28 Tue 2007 20:38
How do I change the ROW HEIGHT in one column?
I am trying to create an excel sheet for my bowling to make calculations
easier. I want to make all the cells from A2- say A25 have a height of 16,
- Aug 28 Tue 2007 20:38
Use worksheet name
Hi
- Aug 28 Tue 2007 20:38
More then 7 IF functions?
- Aug 28 Tue 2007 20:38
UK Excel User Conference
- Aug 28 Tue 2007 20:38
Condition 1 overules condition 2?
In a cell I have specified two conditions for formatting:
1. If the cell is in the quot;Decemberquot;-column, I want a border on the left side.
- Aug 28 Tue 2007 20:38
add one to cell below
I am trying to create an inventory sheet -
- Aug 28 Tue 2007 20:38
return a list