look ups
Wed, 3 Sep 2008 06:23:01 -0700
hi
im looking for a formula that will let me look up two values in one table
array and return one value.
For example: How would i look up a numerical value for product c that is in
the column for 15/01/08
DATE
01/01/08 08/01/08 15/01/08 22/01/08 29/01 ...
|
Function works in one cell but not another
Wed, 3 Sep 2008 06:21:01 -0700
Good Morning!!
I am running Excel 2003
I have a function of: =AVERAGE(IF(G17:G21<>0,G17:G21,"")) in M11 that is
just calculating numbers and it works fine.
However, I put a similar function of =AVERAGE(IF(G22:G25<>0,G22:G25,"")) in
N11 and it is giving an error of a value used in the formula is of the wro ...
|
Round up whole sheet
Wed, 3 Sep 2008 05:44:01 -0700
How can I roundup the whole sheet? ...
|
countif or sumproduct?
Wed, 3 Sep 2008 05:44:00 -0700
i have a column with over 2000 alpha character rows that i'm trying to count.
I have a the one of the following letters hmyubsqzvtgxce in the rows of the
column.
I'm trying to count the total number of hmyu when listed in this column?
...
|
excel 2007 right click edit query
Wed, 3 Sep 2008 05:26:02 -0700
Hi Folks
New to Excel 2007, seasoned at Excel 2003.
I have set up an ODBC query, run it in MS Query and returned the data to
Excel 2007. On my previous version (2003) I could right click anywhere on
the returned data, select Edit Query from the pop up menu and get back to MS
Query to amend the query a ...
|
2008 East Coast US Excel User Conference
Wed, 3 Sep 2008 07:18:46 -0500
Hello
Atlantic City, New Jersey will once again host the Microsoft Excel /
Access
User Conference (Trump Taj Mahal) - On September 24-26, 2008. This year the
conference will add Microsoft Access topics to bring spreadsheet and
database users together to learn and share their knowledge with each other.
...
|
Changing font colors
Wed, 3 Sep 2008 05:06:01 -0700
Is there a way to save the colors I use from the pallet? ...
|
|
|
Replace input cell data using Vlookup
Wed, 3 Sep 2008 05:04:11 -0700
I have a number of employees who each have a unique 8 digit folio number. I
have a spreadsheet that my boss wants filling in every day detailing where
each employee is and what they are doing, unfortunately he is only interested
in the folio number and not the name of the individual. With over 130 people
rep ...
|
sumif? countif?
Wed, 3 Sep 2008 11:51:18 +0100
Hello,
I need some help with the following:
I require cell K3 (in worksheet named 'brokers') to count the number of
times the data in A3 matches those in mar!B:B.
I have acheived this by using formula: =COUNTIF(mar!B:B,Brokers!A:A)
However, i now need to insert another arguement, where in addition to the ...
|
Formula won't show sum
Wed, 03 Sep 2008 02:59:21 -0700
Try going to 1. excel option 2. formulas right side
calculation options click on Automatic
...
|
