Ok here is one for you guys and gals. It might be easy however it is
just not coming to me. I have a excel spreadsheet of 6 columns and

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

I am doing a travel itinery with start and finish points...I can estimate my
average speed between these two points (and I know the distance), but my

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

I want some cells to change with the source cells, including a change in
formatting (font color, bold, italic, etc.).

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

I have created four lists. List A is the main type list and List B, C and D
are the sub-types. Is it possible that by selecting a value in List A in a

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

  • May 16 Wed 2007 20:37
  • *Hi

Anyone that can help me create a excel file such as this

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


Hey, is there a way to set the max() function to find for like the

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

Hi. Is there a way to list, on a separate sheet, only rows of data with a
value in a specific column? I want to list inventory items (and all data in

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

I would like to use the IF function to return a grade value for a score. Ex:

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

I am trying to link 2 spreadsheets in a workbook and have the second one
automatically sort when changes are made to the first. Is this possible?

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

May I know how to use the offset function with lookup or index/match functions. Please show me an example with thanks.

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