目前分類:title (3013)

瀏覽方式: 標題列表 簡短摘要

My sheets are named 1,2,3....100
at any time i may be located at any sheet.

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

Does anyone know what function Excel uses to create smooth lines connecting
the points in a scatter plot? Is it a cubic spline?

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

I am trying to use the formula =Sumif(B7:B203,quot;Paul
Gquot;,(COUNTIF(C7:C203,quot;*quot;))) to count the number of cells in the quot;Cquot; column

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

My spreadsheets open with numbers both along the rows and at the top of
the columns. I was copying and pasting a pivot table when this

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


hey guys,

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

I have a spreadsheet that has 29 numbers with up to 2 decimal place precision
(44.29, 36.89, etc). I am taking the 1st number and subtracting the other 28

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

I am using Excel 2003

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

Hi all, I am trying to create a global exclusion list and then import it to a
registry file. I have no problems importing this in excel so that I can edit

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

How do I stop and restart macro after selecting item from an autofilter list

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

Reviewing excel spreadsheet, what function is being formed by the following
formula = AD11/$Z$20 perform i.e, what does it mean?

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

I found this same question on a Jan. 27 post, but my response there was too
late so I am posting my experience again. The fix did not work for me....

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


I am in the middle of a HUGE excel spreadsheet that has titles of names

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


How do I round to the nearest whole 5? Example 6.6 needs to be rounded

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


Im currently using the formula

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


I have used a simple IF formula to pull data from another file, but once i

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

I am simply trying to enter/change data in cells in an excel worksheet. There
are no formulas involved. The data is simply a number representing a grade 1

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

I've just been asked if I could write some code and
provide worksheet functions or UDFs to a client of a

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

Is there another way to create a kind of fold/unfold without using the
subtotal function in Excel?

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

I have a string of numbers, 25 characters long which is in a cell. Iam
looking to find a function/solution so that I can place each individual value

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


Does anyone know of an add-in that will return a valid zip code when

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