|
|
vLookup by
BillJ.
Are the lookup values in column A sorted in ascending
order? That's usually where I find a problem. The other
possibility (another frequent source for me) is...
|
|
5 |
107 |
|
|
Remove Green symbol on formatted TEXT cells by
redhatter
I can't find anything on how to remove the little green
corner on a text cell except one cell at a time. I changed
all cells to a number format and want to...
|
|
2 |
384 |
|
|
"Formula omits adjacent cells" Error. by
John Prendergast
I have started using Excel 2002 on a XP Pro system. I use
excel to chart stock values. With this ver of excel, the
range of cells that are refereneing data...
|
|
3 |
518 |
|
|
|
|
2 |
407 |
|
|
Renaming data in a new column by
CLR
I'm not sure what to tell you because I don't really understand how to
determine who is #2, #3 etc at each position.........but I think I would
just...
|
February 7th, 2004 09:01 PM
by CLR
|
0 |
460 |
|
|
dependent combo box by
R
Hi,
I am looking for a solution to create a few dependent combo boxes, once 1st
combo box is defined, the list in the 2nd combo box would adjusted
accordingly...
|
|
1 |
155 |
|
|
Excel'97 Macro with functions Problem by
Bob Phillips
Joe,
Try something like
Sheets("3
Historical").Cells.Find(What:=Worksheets("Sheet1").Range("B6").Value, _
After:=ActiveCell, +
LookIn:=xlFormulas,...
|
|
1 |
277 |
|
|
Cell Row - Last Cell Entry Reference by
auntj
I have tried to figure this out by reading some manuals, but just can't.
Perhaps someone here knows the answer. I am doing a weekly report. I
have a row of...
|
February 8th, 2004 04:26 PM
by auntj
|
6 |
260 |
|
|
address of SMALL function result by
MT
I need to use a function that gives me the lowest value, and the K lowest value from a bunch of cells/values.
However, getting the k lowest value is not...
|
February 8th, 2004 06:16 PM
by MT
|
1 |
472 |
|
|
Keeping Records by
Frank Kabel
Hi
have a look at the following site for datestamps
http://www.mcgimpsey.com/excel/timestamp.html
Frank
ok, I have two columns...
names go in column A,...
|
|
1 |
360 |
|
|
address of SMALL function result by
Frank Kabel
Hi MT
if column A stores your lookup values and column B the value you want
to retrieve try
=INDEX(B1:B1000,MATCH(SMALL(A1:A1000,k),A1:A1000,0),1)
Note: If you...
|
|
2 |
383 |
|
|
|
|
1 |
109 |
|
|
Excel by
Cullison
I want to set a simple formula in Excel, cost, resale=%
profit, times quanity = dollars profit. Cant make it work
any ideas?
|
February 9th, 2004 09:07 AM
by JulieD
|
1 |
91 |
|
|
Time Functions by
Allan
I have been toying around with almost all of the time functions. I don't
seem to have an answer.
I am building a weighted score for a set of data that gets...
|
February 9th, 2004 01:35 PM
by Allan
|
3 |
423 |
|
|
subtracting multi-valued times in one cell by
Scott
I use a program that exports times into an excel document to allow additional analysis. It exports X number of start times for the first group with each value...
|
|
2 |
512 |
|
|
Excel Convert Text to Formula by
Salvador Garcia
I have a formula that changes every day because is
related to another spreadsheet that it is changed every
day. I was able to create a...
|
|
1 |
385 |
|
|
|
|
3 |
448 |
|
|
sheetname by
peter
Hi,
After saving a test file...
I put this formula in a cell on sheet1, it returns the
proper info.
=cell("filename")
I then go to sheet2 and hit f9.
If I...
|
|
2 |
149 |
|
|
Section Breaks by
Brand33
Is there a function for section breaks in Excel as there is in Word that gives you the ability to changes fonts, margin sizes, etc. in the new section?
|
|
2 |
402 |
|
|
Indirect range not changing by
Pat
When using Indirect in the following formula IV11 will not change to IV12
when filled down.
=$AS11+$BF11+$CU11-$DT11-INDIRECT("IV11")
Anyone know how this...
|
|
6 |
329 |