目前分類:title (4957)
- Jul 25 Fri 2008 20:45
refering to previous sheet
- Jul 25 Fri 2008 20:45
formula help please
I have this formula thta looks at cells A8:A427 for a date which is the same
as that in cell D1, and then sums all the coresponding cells from cells
as that in cell D1, and then sums all the coresponding cells from cells
- Jul 25 Fri 2008 20:45
Ensure unique solutions to random formula
I am developing a math lesson worksheet for my homeschool lessons. One way
it's working quite well is to use the solutions of problems to find a letter
it's working quite well is to use the solutions of problems to find a letter
- Jul 25 Fri 2008 20:45
Microsoft Excell '97
I am trying to combine my Access Database into Excell. The problem is when I
try to get the information out the Acces Database I am not able to find the
try to get the information out the Acces Database I am not able to find the
- Jul 25 Fri 2008 20:45
Hyperlink on different verisons of excel
I am using Excel 97 upwards, I have created some hyperlinks in Office XP
which link to another workbook for example:
which link to another workbook for example:
- Jul 25 Fri 2008 20:45
finding out the combination of letters!
- Jul 25 Fri 2008 20:45
Can someone help with this complex formula?
- Jul 25 Fri 2008 20:45
show a block of info from a list on another worksheet
I have a large list of information (sheet1)showing lorry movements in several
columns as follows:
columns as follows:
- Jul 25 Fri 2008 20:45
Why does this Formula work?
I have the following formula in cell I2 (copied down as far as needed and
copied across to AA2):
copied across to AA2):
- Jul 25 Fri 2008 20:45
filter by frequency
I have a huge list of telephone numbers and I need to filter out the numbers
that appear more than 5 times.
that appear more than 5 times.
- Jul 25 Fri 2008 20:45
Formula to read non-existant reference?
- Jul 25 Fri 2008 20:45
can't remove training frame when opening excel
After saving a training/practice worksheet, it keeps causing the training
frame to open every time I open this worksheet....how do I prevent this from
frame to open every time I open this worksheet....how do I prevent this from
- Jul 25 Fri 2008 20:45
How to Filter cells and save the file with certain criteria?
- Jul 25 Fri 2008 20:45
Change colour of data when changed
- Jul 25 Fri 2008 20:45
My Excel document won't open
- Jul 25 Fri 2008 20:45
Protect formatting amp; formula
I need to protect the formatting amp; formula in each cell to avoid accidental
changes during update by different users. However, if I protect them, any
changes during update by different users. However, if I protect them, any
- Jul 25 Fri 2008 20:45
Track time
Hi everybody, I created a spreadsheet (Office XP) with all my music
collection and it includes the time for every tracks. I just can't find the
collection and it includes the time for every tracks. I just can't find the
- Jul 25 Fri 2008 20:45
Auto Shapes
I would like to be able to setup an Auto Shape with text and color, which I
can do fine. Next, I want to beable to use the Auto Shape on my website. If
can do fine. Next, I want to beable to use the Auto Shape on my website. If
- Jul 25 Fri 2008 20:45
format comment indicator
Can anyone tell me if it is possible to do any of the following:
1) change the colour of a comment indicator
1) change the colour of a comment indicator