How do I sort data by criteria that is not ascending or decending -- such as
greater than number in a particular cell.

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

I am sure it is operator error but all of a sudden I can't tab through my
spreadsheet cells anymore. Any ideas?

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

I have got a laptop installed with XP home SP1 , office 2003.
When i try to open any excel file , it gives me following error.

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

I am trying to calculate the average time between starting 1's. The data has
a date which is every day and a 1 or 0 next to it. When the data goes from 0

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

I have a multi user file. Some users enter data in one column others in the
same and/or other columns. I would like to allow users to edit any column

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

I am trying to copy a formula with a relative reference in one worksheet to
another worksheet but the relative reference does not change as it should.

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

How do I count if values in a table that are gt;=100 and lt;=200?

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

I have a workbook with 30 worksheets that all have approximately 100 formulas
that read =(Cell)*.0342. I want to change the formula to read

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

Why, in pivot tables, do I sometimes get quot;sumquot; and other times
quot;countquot; when putting fields in the data section? I import data

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

I would like to be able to click and drag down a group, or pattern, of
numbers in the same way that you can with letters. In other words, I can

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