目前分類:title (5957)

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

I want to create 55,000 randomised numbers between 10,001 and 65,000. Each
number must appear only once. Is this possible?

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


I am trying to average a range of cells which sometimes includes blank

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

Can somebody help me please?
I.

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

Does anyone know how to use a vlookup, or any kind of lookup formula when
there are more than one result?? ie if I am searching the name of a client,

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

I have 2 combo boxes on the same sheet and both have Combobox_Change() event
code associated with them. This code resides in the sheet object (same

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


I need to get the values of the pair (x,y) in an YY chart with a click

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

if cell g1=YES then I want the entire row (row1) to be shaded grey.
if cell g1=blank or no then I want entire row (row1) to have no format

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

I want to be able to run an advance filter on an input range and have a
histogram that automatically updates to reflect the filtered range. This

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

How can I set the row height to automatically increase for text wrapping?

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



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

I'm using Office 2000 and have a problem labeling major ticks on the
horizontal axis (years).

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


I would like to analys following:

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

We are having a problem trying to email a single worksheet since we have
installed Exhcange 2003. We are running Office 2000. We can email the whole

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

using excel 2000 pro

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

I am using Excel 2000

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

Hi tj, that works a treat.you are right about the date changing each time the
sheet recalculates,a static date would be better.i will the the web address

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

We need to list times in 'minutes' and 'seconds' as recorded on a stopwatch
and then have excel perform simple calculations such as SUM or AVERAGE.

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


I have the formula below, which takes the date from a cell(G8) and finds

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

Hi,
is there a way to automatically fill in the blank cells between two numbers

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


is there a method in excel where I can convert a row of entires into a

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