|
|
Conditional max. number by
Biff
Hi Dennis!
If the "values" are in fact numeric numbers formatted to
include the leading zeros:
=MAX(IF(A1:A6=201,B1:B6))
If the "values" are actually text...
|
July 31st, 2004 12:47 PM
by Max
|
8 |
164 |
|
|
Who can explain this LOOKUP formula? by
Basz
I posted a question on the Excel Worksheet Functions forum the other day
and received a formula that works just fine. However, I don't understand
why it does...
|
July 31st, 2004 10:16 AM
by Basz
|
6 |
276 |
|
|
Display Leading Zeros by
Excel Boy
How do I keep Excel from truncating leading zeros in cells? For example how do I keep 0000304 from becoming 304?
( 1 2)
|
|
11 |
429 |
|
|
|
|
2 |
469 |
|
|
[GROUP] by
Egnarts
at the top of my screen beside my file name is this,
. i don't know how it got there but now every
time i change a cell in one worksheet it changes that
cell...
|
|
5 |
150 |
|
|
sort by date problem by
scudooder
Hello
I am having this problem where I converted a flat text file into an
excel worksheet. There is a column for date and the format of the date
is:
Nov 01...
|
|
6 |
410 |
|
|
text import wizard by
philtyler
I'm migrating a huge database out of our current business software into
new software. I'm exporting into an Excel file so I can adjust info
before mapping to...
|
|
4 |
315 |
|
|
|
|
2 |
660 |
|
|
Pivot Table - fix column size by
Melanie H
I can select a column and set the width after
using "enable selection", and the new width sticks as
long as I only refresh the pivot table with the...
|
July 31st, 2004 12:13 AM
by Melanie
|
3 |
602 |
|
|
|
July 30th, 2004 10:53 PM
by
|
4 |
574 |
|
|
Enter key not working in Excel by
Dana
How do I unlock my 'enter' key in Excel. It works in other programs but has stopped working in Excel. The arrow keys are fine, but I can no longer "return"...
|
|
1 |
415 |
|
|
|
July 30th, 2004 10:02 PM
by pboost1
|
5 |
157 |
|
|
Converting Worksheet to all 'Upper' by
ADArnold
Hi All,
I know how to change lower case columns to upper case with the
=upper(cell) function. Then once the new 'upper' column is complete,
copy, then paste...
|
|
3 |
169 |
|
|
[URGENT] Linking Dates to a Data Worksheet by
jamesjustinaaron
I have a control sheet with hire dates and values for these hires. I have another worksheet with week ending dates on it. I need to find a way to link these...
|
|
5 |
258 |
|
|
auditing limitations? by
Glenn
I have a fairly complex spreadsheet that I inherited and
I'm trying to use the auditing tools to study the
spreadsheet. I've found that some fairly simple...
|
July 30th, 2004 07:34 PM
by
|
1 |
349 |
|
|
CONVERTING 1-2-3 WORKBOOKS by
LIO2004
HOW CAN I CONVERT LOTUS 1-2-3 WORKBOOKS TO EXCEL WITHOUT
HAVING TO OPEN THE FILE IN LOTUS AND THEN SAVING AS EXCEL
FILE? I HAVE MANY FILES TO CONVERT TO EXCEL...
|
July 30th, 2004 07:22 PM
by hgrove
|
3 |
171 |
|
|
Show leading 0s for binary formatted cell? by
David
How does one format a cell to display the leading zeros of
binary data (or of data of any format other than decimal,
for that matter)? In my case the binary...
|
July 30th, 2004 06:43 PM
by hgrove
|
2 |
233 |
|
|
|
|
2 |
328 |
|
|
Long txt data import in cell by
geodesy
Hi there,
May I ask for your expertise of how to import a long data into excel.
Normally I can import a txt data, "text to column" it and it will be
laid out...
|
|
3 |
204 |
|
|
Sorting Dates as Numbers by
Hi
You could use a helper column alongside your data with this in:
=TEXT(A2,"dd/mm")
which you can then fill down.
--
Andy.
|
|
1 |
511 |