If text is blue I want the value in another cell to equal 0

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

Anyone have a possible explaination as to why I seem to be getting an
inconsistent format on a column of times. I am downloading data from a

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

I have two columns. Both have a time format of NN:NN:NN. I would like
to calculate the difference. For example, if I have 10:02:01 and

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



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

I have a workbook that has 15 sheets. Is there a quicker way of moving from
Sheet one to Sheet 15 without using the mouse or Ctrl Page Down ten times??

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

I've got an Excel document that always opens two copies of itself when I open
it.It does this if I double click the document to open it or if I browse to

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


You can make the x-axis cross at the maximum Y-value, but is it possible

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

How can I create a macro quot;buttonquot; over a series of columns that will cause a
formula in another part of the sheet to ignore the value that the column

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

I have 3 sheets which I am constantly adding to and then sorting in date
order as cars are rented- they have the same headings but different car

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


I'm using MS Excel 2000 with Windows 98SE. My question is:

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