Referencing text of a cell next to the greatest value in column
Mon, 6 Oct 2008 12:31:01 -0700
I have two columns, one with a list of names and one with a list of scores.
On a different worksheet, I use the Max function to determine the highest
value in the column of scores. Next to that cell, I want to reference the
name next to whomever has the highest score. Does anyone have a simple
function to ...
|
Copying a block of cells so that it updates automatically
Mon, 6 Oct 2008 12:30:26 -0700
I need to copy a block of cells into another worksheet so that it references
the existing file so that it will automatically update when I open the
document. I would prefer to not link each cell individually because that
will take forever and if I embed the range of cells as an object or a link,
the values ...
|
Why did excel spreadsheet stop working. Cannot record data.
Mon, 6 Oct 2008 12:24:00 -0700
I am trying to continue a checking account and it will not let me enter any
data. ...
|
IF AND ISTEXT ISBLANK formula
Mon, 6 Oct 2008 12:23:01 -0700
I have two columns EA and EB, if EA istext and EB istext then EB, AND if EA
isblank and EB istext then EB, AND if EA istext and EB isblank then EA. I
wrote the formula below but it isn't returning values as I thought I had
written it. Your help is greatly appreciated.
=IF(AND(ISTEXT(EA6),ISTEXT(EB6)),EB6,IF( ...
|
Moving linked files from one server to anoter one
Mon, 6 Oct 2008 12:18:25 -0700
I need to move a folder (F) from the old server O to a new server N with
several sub folders having excel files which are linked to another files in
the same sub folder and in others sub folders.
When I move de main folder (F), the link for the files linked to other in
other sub folders doesn´t change, I m ...
|
Count(if) formula help
Mon, 6 Oct 2008 12:18:16 -0700
I'm trying to count the number of instances a combination of parameters occur.
i.e. column a = country, column b = office type.
I want to count the number of offices types in each country...
Please help! ...
|
Linking spreadsheet
Mon, 06 Oct 2008 19:16:21 GMT
What I have is a master spreadsheet (wb_master) that has tabs for each day of
the month. The tabs are labeled 10-01 thru 10-31. What I would like to do,
is in a seperate spreadsheet (wb_summary), is have one sheet, that will look
at the value of cell (q1) on sheet1 in wb_summary, and then look at the
wb_master ...
|
|
|
Formula Query
Mon, 6 Oct 2008 12:15:01 -0700
I have a large spreadsheet with 11 columns of data. Column B is a reference
number, column F is an amount attached to the reference number. There may be
multiple amount entries attached to a reference number but they are all
individual data lines.
What I would like to do is a formula or macro that checks ...
|
formula range
Mon, 6 Oct 2008 12:13:04 -0700
Trying to set up a formula by assigning a score to a sum or result
Result is 36
Points score
20 25 or less
24 26-32
20 33-36
14 37-45
8 45-50
0 >50
...
|
Using Vlookup and If functions simultaneously
Mon, 6 Oct 2008 12:09:17 -0700
Is it possible to use Vlookup and If functions together in one formula? If
so, please give an example. ...
|
