|
|
|
|
9 |
225 |
|
|
|
|
3 |
94 |
|
|
Displays wrong result by
FirstVette52
For the following formula:
=MAX(VALUE(RIGHT($A$1:$A$22,8)))
....for a list of numbers
L00000001, L00000002, L00000003, L00000004, L00000005 ... ...
|
|
2 |
108 |
|
|
Lookup Formula by
BAD
I have worksheet #1 that has Name and Email Address.
I have worksheet #2 that has Name and Employee ID number.
I want to add a cell next to Employee ID...
|
|
2 |
114 |
|
|
Date field from text field by
Jack Deuce
I have 2 sheets containing two dates that I need to compare. One date
is in the serial date format, ie, shows as 07/21/04 (internal 39650).
The other date...
|
|
3 |
143 |
|
|
|
|
1 |
92 |
|
|
|
|
1 |
119 |
|
|
Max with Multiple Ifs by
ChrisWWiese
Hello All,
I need a Max statement with multiple ifs.
Take for instance the example below, I need only the Max IF A=1 and C
= 1. I've tried formulas like...
|
|
3 |
90 |
|
|
Array Function? by
Johnnie[_2_]
A B C
1 Company 1 10 Company 1
2 Company 2 10
3 Company 3 10
4 Company 2 8
5 ...
|
|
4 |
99 |
|
|
|
July 21st, 2009 08:30 PM
by Mike H
|
5 |
130 |
|
|
|
|
1 |
109 |
|
|
Remove Password by
Zita
I want to remove a password from a workbook so it opens without one. It is
unshared file.
|
|
3 |
73 |
|
|
|
|
8 |
105 |
|
|
How the data may stay on top with scroll ? by
Vladimir Nikolov
So I want when i scroll my worksheet, the data that i am insert into the
first row, still be on the top of the worksheet.
I am sorry for my bad english and i...
|
July 21st, 2009 07:16 PM
by Eduardo
|
1 |
105 |
|
|
Formating a cell by
Smiley
Hi! I am working on a spreadsheet where I have 5 columns of time. I need to
reformat all 5 columns to be the same. My time reads for example, 11:55 -...
|
|
5 |
80 |
|
|
|
|
3 |
106 |
|
|
Custom Format or use function? by
Lisa W[_2_]
I inserted numbers into a column and now want to format this column so that
it changes the numbers to appear as: 196-24-0-00-00-001-00-0-01 (ie, the -
appear...
|
|
4 |
105 |
|
|
|
|
0 |
71 |
|
|
Cross Reference by
fgwiii
Hello,
I have a need to associate several lists of 5 digit numbers with to a user
on another spreadsheet.
For instance I use a hidden workbook to store all...
|
July 21st, 2009 05:06 PM
by Eduardo
|
1 |
81 |
|
|
Count Columns, Return Content by
Leah G
I need a function to return the contents of a cell based on a number given in
column F. Here it is:
A B C D E F
* $ @ % # 3 (I would...
|
July 21st, 2009 05:02 PM
by Mike H
|
6 |
130 |