|
|
|
|
2 |
150 |
|
|
Index/Lookup Function? by
jackie
Hi All- I need help returning a list of names on a separate sheet. I'll
enter "manager 1" in an input cell, and i want to return a list of
corresponding...
|
March 15th, 2010 10:25 PM
by Max
|
4 |
190 |
|
|
Replace Function that uses lookup table? by
msnyc07
I have a large (50k+records) spreadsheet I've been 'cleaning' using some
basic cell functions that look for specific strings and then remove or
substitute,...
|
March 15th, 2010 10:05 PM
by Eva
|
1 |
189 |
|
|
EXCEL COUNTING HELP by
EXCELably Challenged
I need to count the number of occurances of a date range from a column of
dates spanning from December 1, 2009 - March 15, 2010. (how many dates in
column C...
|
March 15th, 2010 09:26 PM
by Bernd P
|
3 |
145 |
|
|
cube functions by
Robert
Hello everyone,
in Excel 2007 we have the new cube functions described in this blog for...
|
March 15th, 2010 09:16 PM
by Robert
|
0 |
186 |
|
|
OFFSET and LOOKUP Error by
Jim
I'm using Excel 2007
I'm using this formula in cell F11 to lookup a payment amount, which works
fine.
=HLOOKUP($I$3,Mortgage_Pay_Table,A11+2)
In Cell E11 I...
|
|
2 |
150 |
|
|
|
|
3 |
180 |
|
|
Counting independent items in a list by
Brad E.
This formula is meant to count independent entries in A1:A20.
=ROUND(SUMPRODUCT(1/COUNTIF(A1:A20,A1:A20)),0)
Can anyone make this better? I am not talking...
|
March 15th, 2010 07:39 PM
by Mike H
|
3 |
159 |
|
|
Dynamically Adding Textbox To Frame by
sarndt
How do I add a textbox control to a frame object (declared as OLEObject) in
vba code behind a worksheet?
For example, I have tried the following that doesn't...
|
March 15th, 2010 06:19 PM
by sarndt
|
0 |
154 |
|
|
Get location of match in another worksheet by
AZSteve
"Workbook A/worksheet A" contains a reference cell with a date (formatted
date number). I need a formula for this worksheet that gives the cell
address in...
|
March 15th, 2010 05:01 PM
by AZSteve
|
0 |
122 |
|
|
left/right or center ? by
Steve
I have days off in the P column in this format: Sat/Sun
I'm using them in another column in this format SatSun, so I'm using this...
( 1 2)
|
March 15th, 2010 04:30 PM
by Steve
|
13 |
461 |
|
|
|
|
0 |
152 |
|
|
Setting special format for a cell by
Ruslan
Dear All,
Could you please tell me how can I can set special format to a column?
To be precise, I'd like to set such a format to the column of cells that it...
|
|
6 |
174 |
|
|
|
|
4 |
244 |
|
|
Problem with LARGE function by
mickjjuk
I am trying to sum the best 2 scores from a total of 4 scores using the LARGE
function. the 4 scores are immediately above the cell containing the
function....
|
|
3 |
146 |
|
|
Determining number of entries in a table by
smaruzzi
I want to dynamically calculate the number of entries in a list of text
strings. Surprisingly COUNTA returns a number not corresponding to the actual
number...
|
|
3 |
167 |
|
|
Autofill from Data Validation by
JPDS
I have a list of staff in sheet 1, along with where they work in the company
i.e. their geographic location, their department name, their section and
their...
|
March 15th, 2010 11:56 AM
by JPDS
|
2 |
154 |
|
|
ms excel by
vinay
how to change uppercase to lowercase in ms excel
|
March 15th, 2010 11:14 AM
by Mike H
|
1 |
146 |
|
|
Index from TM by
Dave
Hi,
Looking at an answer from Teethless Mama to someone else's question, raised
yet another question. (what a surprise)
The formula was:...
|
|
8 |
252 |
|
|
Starting drop down lists at the top by
test123
I have several drop down lists on sheet 1 where the data sets are on sheet 2. Some of my drop down lists start at the first entry and others start at the...
|
|
1 |
140 |