Could anyone walk me through the functions needed for creating a matrix

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

I am trying to merge data from 3 different worksheets into one master sheet
For example:

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

Hi

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


My Pivot Charts always reset the formats whenever I refresh or add

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

I am using a work sheet that links by DDE to a machine PLC.
It is updating once a second. I have a time of day clock built into the sheed.

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

I have protected a sheet in Excel. I want to unprotect several columns and a
couple of cells. What is the procedures for doing that?

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

When I open excel and then try to open an excel file from the pull down it
won't respond. The file can be opened directly if excel is not opened before

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


formula'{=OFFSET(A42,MATCH(A2,LEFT($A$42:$A$658,LE N($A$2)),0) -1,0)}'

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

Hi,
I want to create a list of dates one month apart from cell A1 thru

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

how can I get a screenshot of a page in excel to put into word?

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