|
|
|
April 22nd, 2010 05:48 AM
by Scotty
|
0 |
257 |
|
|
|
|
2 |
303 |
|
|
|
|
5 |
532 |
|
|
|
|
2 |
240 |
|
|
|
|
2 |
208 |
|
|
Text to values by
Nadine
I need to convert cells of data to values. The data is the result of the
following formula: =LEFT(D2,SEARCH(" ",D2)-1). Example of data results:
1099r,...
|
April 22nd, 2010 02:11 AM
by Nadine
|
4 |
237 |
|
|
|
|
2 |
309 |
|
|
|
|
3 |
214 |
|
|
|
|
0 |
184 |
|
|
Id'ing tabs that contain #REF!'s by
Steve
I have a workbook with quite a few sheets, many having formulas that refer to
other sheets. Sometimes when I make changes to some of the cells in certain...
( 1 2)
|
April 21st, 2010 09:00 PM
by Steve
|
14 |
328 |
|
|
|
|
2 |
172 |
|
|
|
|
4 |
175 |
|
|
|
April 21st, 2010 05:29 PM
by Mike H
|
1 |
195 |
|
|
Pulling/Collating Data from Workbooks by
chrisk
Hi,
I have a workbook with 31 sheets a diary called April for this month
AX to FX is the info I want relating to the employee's initials in the G
column of...
|
|
6 |
304 |
|
|
|
|
2 |
176 |
|
|
|
|
3 |
158 |
|
|
|
|
1 |
199 |
|
|
Excel 2007 on Vista by
Mary Hitt
avoid this? When I minimise my excel 2007 worksheet I lose the ribbon. How
can I
|
|
1 |
180 |
|
|
Text to Date by
PAL
I have been given a database dump (thousands of rows) that put the dates in a
text format like this:
Aug/11/2009
Is there any way to put this into a date...
|
|
8 |
151 |
|
|
If then by
PAL
I have a multi column (10), multi row(1000s) table. I am trying the
following formula, with if two conditions are...
|
|
8 |
224 |