|
|
Can't see the open spreadsheet by
Kris
I opened an Excel file but it won't show up in Excel. When I exit Excel it
asks if i want to save changes to the file, but it still hasn't shown up as...
|
October 12th, 2009 02:39 AM
by Kris
|
6 |
120 |
|
|
MROUND time by
Colin
I am using the formula MROUND to get a time hh:mm:ss to the nearest 30seconds.
Cell T2 shows 00:11:24 and U2 shows 30.
I have fomated cell T2 and the cell I...
|
|
2 |
117 |
|
|
Dynamic Named Range by
dhstein
I have a Defined Name of "VendorList:
=OFFSET(Inventory!$KB$2,0,0,SUMPRODUCT(--(Inventory!$KB$2:$KB$200"")),1)
I want this to be a dynamic range and to go...
|
|
4 |
123 |
|
|
|
October 11th, 2009 10:39 PM
by edl
|
0 |
123 |
|
|
Opening files and folders with details by
Darlene
How do I get the Open Folders and File box to show details all the time, or
as default. I went to computer and click on a file that was showing
thumbnails...
|
October 11th, 2009 09:23 PM
by dangav
|
3 |
139 |
|
|
Excel Comment Pictures by
Rohan
Hi
I am having one excel file with Comment pictures, now i want to take those
pictures out and past some other location
how can i do this
Rohan
|
October 11th, 2009 06:08 PM
by Rohan
|
8 |
124 |
|
|
sorting locked cells by
dave
Is there a way to sort locked cells in a protected worksheet so that a user
can sort cells but cannot input data in certain cells?
|
|
2 |
91 |
|
|
How to copy Excel records? by
abc[_9_]
Hello
My Excel file has thousends of records and columns let's say
from A to Z.
In column Z there is one of numbers: 0 or 1 or 2 or 3.
The problem is how to...
|
|
7 |
121 |
|
|
Lookup by
puiuluipui
Hi, i need to search the content of C10 in range A1:L1, and to display next
cell content.
Ex:
A1 B1 C1 D1 E1 F1 G1 H1
1 222 2 333 3 444...
( 1 2)
|
October 11th, 2009 03:19 PM
by Bernd P
|
10 |
148 |
|
|
|
|
2 |
109 |
|
|
|
|
1 |
98 |
|
|
Can't install Home & Student...Help! by
aaharp
I am trying to install H&S but keep getting an error message stating that
excel can not be found & to find the location. Please help!
|
October 11th, 2009 12:54 PM
by JLatham
|
1 |
134 |
|
|
|
October 11th, 2009 12:52 PM
by driller
|
6 |
122 |
|
|
Text by
nc
a & a 24/03/09
a & a 24-26/09/09
a & a 3/06/09
a & a
I have a column of the above similar text. I would like help to write
formula to show text without the...
|
October 11th, 2009 09:55 AM
by nc
|
4 |
147 |
|
|
|
|
2 |
103 |
|
|
Formula text attn:Jacob by
mexmex
Jacob
Thanks again for the help, I am fairly new at the formula bit.
I have another woork sheet with the same issue, it is an amount divided by
the number of...
|
|
5 |
127 |
|
|
|
|
1 |
101 |
|
|
|
|
2 |
139 |
|
|
Help with a formula by
Trev
I need a formula in sheet 2 that counts if column C sheet 1 = S, and column S
sheet 1 can equal either N* or U*and column A sheet 1 does not equal CBH,
APH,...
|
October 10th, 2009 10:28 PM
by Trev
|
2 |
147 |
|
|
|
October 10th, 2009 09:42 PM
by David
|
6 |
113 |