|
|
vlookup function returning #n/a by
brian
This is been difficult. If I reference a value within
A10 that is not located in the table, #N/A is returned.
How can I make it so that the cell remains blank...
( 1 2)
|
|
14 |
376 |
|
|
SUMIF & MEDIAN with blanks & text by
Brian
I had some help putting together this formula, but it has been giving me some
grief for some reason after it seemed to work ok to start...
( 1 2)
|
September 2nd, 2008 06:37 PM
by T. Valko
|
10 |
236 |
|
|
How do I make the status bar bigger? by
Brian
How do I make the status bar larger so it is easier to read the sum number in
the status bar.
Or... is there a way to display the sum of highlighted cells in...
|
|
1 |
77 |
|
|
|
January 23rd, 2009 07:18 PM
by Brian
|
4 |
70 |
|
|
formula to add year to date figures by
Brian
cells A1:L1 represent monthly expense totals from January to Dec. cell M1 is
the sum of the 12 months. I am trying to create a formula for cell N1 that...
|
February 3rd, 2009 04:26 PM
by Brian
|
3 |
63 |
|
|
formula to add year to date figures by
Brian
This was previously discussed but needs additional clarification,
sheet1 (WS1) represents 2008 monthly expense figures from Jan-Dec in cells
A1:L1 and M1 is...
|
February 2nd, 2009 07:08 PM
by Brian
|
0 |
82 |
|
|
nesting more than 7 functions? by
Brian
I am using the following formula but it will involve nesting 12 functions. I
understand the limit is 7. Is there a way to write the formula to avoid the...
( 1 2)
|
|
11 |
84 |
|
|
|
|
3 |
51 |
|
|
|
February 5th, 2009 09:38 PM
by Brian
|
5 |
54 |
|
|
|
February 7th, 2007 09:50 PM
by Brian
|
0 |
68 |
|
|
locking cells by
Brian
after locking and then protecting cells, how can i prevent these cells from
being selected. What i means is usually when you place the pointer over the
cell...
|
|
1 |
133 |
|
|
save setting for print entire workbook by
Brian
every time I choose print entire workbook and then hit ok
the next time I go to print, the button moves back to
print active sheet.
how can I keep it on...
|
November 3rd, 2003 04:32 AM
by brian
|
2 |
654 |
|
|
EXCEL 2002 INVOICE TEMPLATE by
BRIAN
IM SWICHING TO EXCEL 2002 FROM 2000 AND CANT SEEM TO FIND
THE INVOICE FUNCTION UNDER TOOLBAR TO BRING UP THE BOX
FOR AUTOMATIC NUMBERING OF THE INVOICE NO. ARE...
|
|
2 |
1,562 |
|
|
|
January 6th, 2004 11:25 PM
by Jane
|
1 |
291 |
|
|
|
January 19th, 2004 09:14 AM
by Paul
|
3 |
453 |
|
|
Vlookup across multiple sheets by
Brian
I am trying to build a formula that will do a vlookup
across multiple sheets and give me the sum of the results
in a summary page.
Here is what I have...
|
|
6 |
499 |
|
|
linking data to create a graph by
Brian
Hi
I am trying to create a graph on sheet 5 of a workbook for
exapmle.
How do I link the data from other sheets on the same
workbook to create this graph...
|
April 19th, 2004 07:09 PM
by Brian
|
0 |
374 |
|
|
validation list by
Brian
column A contains numerous numbers. i want to create a validation list in another cell using this list.
i know how to create the list but i would like to know...
|
April 27th, 2004 11:41 PM
by Brian
|
0 |
72 |
|
|
WorkSheet / ActiveSheet Question by
Brian
I have an Excel 2002 workbook which has many worksheets.
One of these worksheets is a TOTAL of the other worksheets.
One cell in the TOTAL worksheet is using...
|
August 25th, 2004 08:51 PM
by hgrove
|
1 |
353 |
|
|
Calculate Monthly Inventory Usage by
Brian
I'm trying to calculate monthly inventory usage from data retrieved from
daily usage reports. The formula below works, but not sure how to ignore rows
with...
|
April 9th, 2009 04:08 PM
by Brian
|
5 |
50 |