目前分類:title (5957)

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

I want to use the same formula in another workbook e.g. A1 sheet2!b1, however
when I copy it it links to the other workbook e.g. when I paste I get

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

I am wondering if it is possible to merge two worksheets, that have the exact
same column headings, into one document, eliminating duplicate data based on

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

how do i save a file based on a predetermined value in a cell.

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

please could I have a formula or function to enter start time-end time and
show total hours/mins for excel

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

  • Sep 10 Mon 2007 20:39
  • and

How do I get rid of the and - icons on the left hand side of the screen
that hide my rows?

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

I would like to update a spreadsheet as follows:
I have a master spreadsheet in which I use different codes to each record. The second spreadsheet is modified with additional records or some records deleted. Both spreadsheets have each record with the same unique id number. The task I want to perform is to automatically update the master spreadsheet.

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

Hi All

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

I'm want to use an quot;IFquot; formula to compare the values in two cells and return
the following...

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

Greetings

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

I just wondered if it was possible to check time availavilty within a
spreadsheet.

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

Hi, this might be difficult for me to explain, so I'll use an example.
I have several columns that look like this:

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

Pls let me know if there is any way to zip my working folder (cotaining 35
files) e.g user entering data, after click maybe macro button - the action

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

Hi,

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


Hello

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

It keeps adding all the totals in all of the column. Don't want that. I want
to keep an individual cumulative total for each row for inventory of that

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

have a csv file that in one column has years 89-99, 99-04 can I format that
column so that it changes those years to 1989-1999, 1999-2004

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

hi,could anyone tell me how to cover the formula in the column, so that people
unable see what the formula i have put in.

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

Somehow we have amended an Excel worksheet so that both the row and column
headings are numbers! As you can imagine, to the less clever of us, this can

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

Hi there,

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


Hello Excel Tippers,

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