|
|
count number of dates in range by
Sunflower
In column A, various contractor names are listed. In column B, completion
dates have been entered for when their projects were completed thoughout the
year....
|
March 24th, 2010 06:07 PM
by Francis
|
2 |
150 |
|
|
Excel not pasting the formula or reference by
Lindsey[_4_]
I am trying to take a worksheet "apple" and copy it to a new workbook
"banana".
It works for another worksheet but not this one.
I am highlighting the whole...
|
|
1 |
137 |
|
|
Date Formatting by
DaveMoore
With the help of Biff yesterday I entered the formula
="Closing Balance at "&TEXT(E4,"dd-mmm-yyyy")
which returned
Closing Balance at 31-Mar-2010
exactly as I...
|
|
2 |
125 |
|
|
Sumproduct? by
Hannah
Good Afternoon
Please could someone help....
I have a monster spreadsheet that tracks recruitment numbers and as part of
our monthly reporting i need to...
|
|
1 |
168 |
|
|
Too many rows highlighted by
RLD
When I click on a row, multiple rows are automatically selected. This
happens to all of my sheets in my workbook. Do I have a bug? How do I fix
this?
|
March 24th, 2010 04:33 PM
by Mike H
|
1 |
177 |
|
|
|
|
4 |
171 |
|
|
Date Calculation problem by
petedacook
Hello,
I have a work sheet with "JIRA" priority levels and dates the JIRA was
created. Each priority leve allows a certain number of days to be complete...
|
|
3 |
160 |
|
|
|
March 24th, 2010 01:58 PM
by Mike H
|
1 |
157 |
|
|
|
March 24th, 2010 11:46 AM
by Jim
|
4 |
168 |
|
|
Data Connection Wizard by
Richard Horn[_2_]
Need some help with the Data Connection Wizard. We have a database which is
on one of our internal servers and it is accessed by a url. Can I, or how do
I...
|
|
0 |
147 |
|
|
Hidden column by
showiesg
A column is hidden. I can only see this column in the print preview mode.
I tried to unhide it using the usual method of Format , Column and Unhide
but its...
|
|
1 |
104 |
|
|
formula question... by
000ani
Just wondering if this is a valid formula...
=(B5*C5)+(B6*C6)
--
curiouscash
|
|
2 |
144 |
|
|
Convert Date in Text to month and Year by
Excellency
I am trying to convert text to month and year. In the cell it displays as
07/09 i want it show Jul-2009 or 2009-Jul. When i use DATEVALUE or DATE it
adds...
|
|
3 |
149 |
|
|
Matching two sets of data? by
Zuo
Hi,
I have two sets of data, one in A1:A450 and the other in D1:D700. I want
the matching data (reference) of the array in column A to appear in Column C...
|
March 24th, 2010 02:25 AM
by Zuo
|
5 |
138 |
|
|
file names by
Mr Widget[_2_]
Is there a way I can collect multiple file names from within a folder and get
them to display within a excel. If it involves using a macro I haven't been...
|
|
3 |
175 |
|
|
|
|
5 |
188 |
|
|
Automating a Worksheet by
hankb
I have a lengthy worksheet which requires a single numerical input on A1 and
it produces a single numerical output on F30. It has numerous formulas.
I would...
|
March 23rd, 2010 10:48 PM
by Max
|
6 |
139 |
|
|
Calculating Resolution Rates by
Rhonda Urbanczyk
I'm trying to calculate resolution rates from our help ticketing system in
Excel - I've tried several recommendations from here and they're not counting...
|
|
4 |
115 |
|
|
|
|
5 |
149 |
|
|
Justify across selection by
bfloyd
I found the "center across selection" formatting function but I really need
to "justify across selection." Any ideas?
--
bfloyd
|
March 23rd, 2010 08:02 PM
by Ziggy
|
1 |
145 |