|
|
Sumproduct - Return value as Blank by
Lilyput
Hi
I am using the sumproduct formula below to pull information from one work
sheet to another. However some of the values in the range ranking order
E5:E38...
|
|
3 |
433 |
|
|
averageif with 3 criteria by
Rene
Trying to average the results of this sumproduct formula. Searched the
questions already asked but only found average if for 1 or 2...
|
|
1 |
338 |
|
|
|
|
1 |
371 |
|
|
|
|
2 |
329 |
|
|
|
|
1 |
272 |
|
|
|
|
2 |
324 |
|
|
|
|
1 |
313 |
|
|
|
|
1 |
328 |
|
|
Add-Ins by
Sean Neill
I have created an Add-In, by openning the VBA, inserting code into a general
module and then saving the workbook as a Excel Add-In. I then added the file
to...
|
|
1 |
218 |
|
|
Converting NAD83 by
ShelleyW
is there a formula or add-in with Excel to convert NAD 83 to NAD 27?
|
|
1 |
212 |
|
|
How do I fill a Cell with a symbol by
Len Porter
In the past I have used a short cut to fill a cell with a symbol. Just using
two key stokes and the cell will be filled from left to right, even if you
alter...
|
|
1 |
343 |
|
|
Delete an Add-In? by
Ken
Excel2003 ...
Tools ... Add-Ins ... Automation ...
I inadvertently selected one of these that I did not want ... Now how do I
remove it from my List of...
|
|
3 |
286 |
|
|
Change default font for new entries by
Terry
I have a large spreadsheet that has a lot of different data (obviously).
Additions need to be made. Is there any way to change the font for all new...
|
|
1 |
309 |
|
|
|
|
1 |
348 |
|
|
Formatting Text to Numbers for Dates by
Tommy
I'm currently working with a column of dates. Some of the dates are text and
some are numbers. The dates are in the following format 21/6/210 or
4/12/2013...
|
|
1 |
320 |
|
|
|
|
1 |
334 |
|
|
Calculate in bottom left corner by
Lunechamps
Why doe the word "Calculate" appear in the bottom left corner when
calculation is set to Auto ?
Is there an error somewhere ? If so how do I find it ?
|
|
1 |
246 |
|
|
Date separator by
Date separator
Dear Expert,
I was wandering how to make exel separate dates.
For example:
In column A I have a date 2010 04 01; in column B I have number 23 ; in C
number...
|
|
1 |
213 |
|
|
Fix an image to a cell in Excel by
posieracer
I can add images to a s'sheet but wondered whether it was possible to fix the
images to a cell, so that when the data is sorted the images will move with
the...
|
|
1 |
317 |
|
|
Additional column formula in pivot table by
JimHa
I am a relative newbie to pivot tables. Using Excel 2003 I have, for example,
8 columns of quarterly financial data. I would like to add a 9th column...
|
May 28th, 2010 12:31 AM
by JimHa
|
0 |
265 |