|
|
|
May 3rd, 2010 08:44 PM
by ecap
|
22 |
511 |
|
|
Vlookup but with multiple results by
ORLANDO VAZQUEZ
Thank you for your support.
Can someone please help me with the following array? type of question.
What formula can I use to return a list of results when...
( 1 2 3)
|
February 24th, 2010 08:36 PM
by slf
|
22 |
432 |
|
|
Active cell highlight by
E
Hi,
I would like to know if there was a way to have an active cell always in
yellow or any color.
Example: If the active cell is moved around, the active...
( 1 2 3)
|
|
21 |
471 |
|
|
Adding top 10 numbers from 100 by
Frustrated
How do I add the top 10 numbers out of 100 numbers that are not in a row or
column but scattered throughout a spreadsheet. For instance, the first number...
( 1 2 3)
|
|
21 |
244 |
|
|
one row won't calculate by
Rick
I use a grade book which I downloaded from the Microsoft site. It works
great, except when I had to add a new student. The grades do not calculate
like in...
( 1 2 3)
|
|
21 |
324 |
|
|
Dates into percentages by
CelticCharmer
Hi,
I was wondering if you could help me out. I train students and when a
student completes an element of their course work I input a completed date
into a...
( 1 2 3)
|
|
21 |
198 |
|
|
|
|
21 |
315 |
|
|
Workbook_BeforeClose by
Ed Davis[_2_]
Posted in another news group but no response.
I have a situation where I have 7 workbooks open at any given time.
I have created macros that saves, backups...
( 1 2 3)
|
September 26th, 2009 01:01 AM
by JLatham
|
21 |
295 |
|
|
|
|
21 |
354 |
|
|
Require input in a cell before saving file by
Patrick Riley[_2_]
I want to require the user to enter his/her name in a cell (E59) before the
user can save the file.
I tried using Data Validation where I specified Text...
( 1 2 3)
|
|
21 |
308 |
|
|
Why doesn't INSTREV work for me? by
dsimcox
I'm using INSTREV to retrieve the location of a character in a string by
searching from the end of the string.
When I type the following in the immediate...
( 1 2 3)
|
|
21 |
210 |
|
|
Blank cells by
Antonio
Hi all
Have numbers on column D, that are placed there by using the following
formula:
=IF(B14=2,C14,0). This formula is copied down until the 400th row...
( 1 2 3)
|
March 13th, 2008 06:58 PM
by Antonio
|
21 |
179 |
|
|
apostrophes by
teepee[_4_]
I have a formula with an apostrophe, but it's not a leading apostrophe.
='results.csv!$B1
I wrote it this way for reasons I won't bore you with, but there is...
( 1 2 3)
|
|
21 |
154 |
|
|
1st and 2nd.... positions by
gorro
assuming i want to arrange student positions, how do i get excel to
automatically add say st, nd, rd, th, to 1st, 2nd, 3rd, and 4th positions?
thaks for...
( 1 2 3)
|
|
21 |
158 |
|
|
Convert test to date by
GKW in GA
I have a cell, F5, that has 20071225 in it. I want to convert this to a date
field that displays as 12/25/2007
When I use the function =DATEVALUE(F5) , I get...
( 1 2 3)
|
|
21 |
180 |
|
|
|
|
21 |
333 |
|
|
find a number in a cell by
Jambruins
In cell B239 I have the following text
Carolina 3 at Pittsburgh 4 (SO)
All of column B is like this except with different team names.
I would like a formula...
( 1 2 3)
|
|
21 |
205 |
|
|
Prevent Duplicate Records by
Kenny
I have a spreadsheet Column A is the account number. I want to write a
procedure that if the user enters the same account number in column a that
already...
( 1 2 3)
|
|
21 |
233 |
|
|
|
February 26th, 2010 06:36 PM
by vemory
|
21 |
406 |
|
|
|
January 8th, 2010 03:02 PM
by Stefi
|
21 |
259 |