This is probably pretty standard but how to I sort columns containing the
same data but in different orders. eg. Column A has 1-10 listed in ascendinf

software 發表在 痞客邦 留言(0) 人氣()

I have a row of cells, some with data and some blank. How do I count the
number of blank or non-blank cells and display the total in a cell?

software 發表在 痞客邦 留言(0) 人氣()

I have a cell that has a formula entered into it. At certain times in the
month of operations this cell with the formual needs to be replaced with a

software 發表在 痞客邦 留言(0) 人氣()

I would like to put a warning in the spreadsheet. It should start flashing at
the moment the user opened the spreadsheet. Is it possible to flash in

software 發表在 痞客邦 留言(0) 人氣()

Hi,
I have been able to do a formula that provides a random number in a cell

software 發表在 痞客邦 留言(0) 人氣()

I use Excel 2000. A few weeks ago I began to have a problem when I would
highlight a cell, right click copy, select a long column, and then paste. It

software 發表在 痞客邦 留言(0) 人氣()

I have a worksheet that has 5 columns and approximately 20,000 rows.
Only one cell in each row has a value other that zero. I want to

software 發表在 痞客邦 留言(0) 人氣()

After i save the file my hyperlink does not work in excel 2003.
I have tried right click as well as the insert hyperlink methods. It work

software 發表在 痞客邦 留言(0) 人氣()

In Cell A1 I have the which for example is 1-21-06.
In Cell B1 I have the Weekday that represents, for this lets say it is

software 發表在 痞客邦 留言(0) 人氣()

The workaround (multiply range by quot;1quot;) is rediculous and impacts cells in
range with other types of formating.

software 發表在 痞客邦 留言(0) 人氣()