|
|
|
|
7 |
132 |
|
|
|
February 24th, 2009 04:38 PM
by ~L
|
17 |
132 |
|
|
Lookup Data based on 2 search criteria by
JW
Currently Im trying to write a formula with 2 search criteria:
1. Write a month/yr (in a validation list), which searchs for
this in another 12 month table...
|
|
2 |
132 |
|
|
Sumproduct array by
Jumbo Jock[_2_]
Hi there,
I have a vertical data array that begins in cell C5 and ends at cell C214.
Each pair of consecutive lines contains data applicable to a single...
|
|
6 |
132 |
|
|
|
|
11 |
132 |
|
|
|
|
3 |
132 |
|
|
I Need a Tearoff Color Palette by
Jonrgrover2
I my work I have over 1 million cells to individually color. The effort of
moving my mouse back and forth between the workspace and the menus in Excel
2007...
|
|
7 |
132 |
|
|
|
May 14th, 2009 10:11 PM
by ker_01
|
0 |
132 |
|
|
Data Analysis by
Rynosun
I have recently installed the data analysis add-in but it is not there under
the tab, how can i use it?
|
|
3 |
132 |
|
|
=text(a1,"dddd") question by
Dylan @ UAFC[_2_]
I am trying to auto fill or copy down this
formula, when I copy down Saturday shows up in every
cell, even if the orginal cell blank
How can I re-work the...
( 1 2)
|
|
10 |
132 |
|
|
Sumif across Multiple sheets by
beenlosteverywhere
I am having trouble summing across multiple worksheets.
I have a "Totaliser" sheet which has the relivant search info on it.
eg Cells F5:F100 hold the...
|
|
2 |
132 |
|
|
count if question by
gurmy77
I am trying to help out the office at work with this one but I seem to be
missing something. First off they are using excel 2003. I know the first
answer is...
|
|
3 |
132 |
|
|
How to decode integer timestamps? by
Ron West
I've been asked to find a simple way of decoding a numeric (integer)
timestamp (representing date only) into native Excel date format, so that it
can be...
|
|
8 |
132 |
|
|
Setting a column read figure from table by
atikah
DN SCH WEIGHT(kg/m)
10 80s ???
??? to read from this table
dn sch 5s 10s 40s 80s
6 0.00 0.28 0.36 0.48
8 0.00 0.51 0.64 0.80
10 0.00 0.64 0.86 1.12
|
December 10th, 2008 08:55 AM
by Max
|
2 |
132 |
|
|
Transfer Multiple-Font Cells ?? by
monir
Hello;
I did post this question earlier (with the same Subject) at MrExcel forum.
A single respondent DaveMeade (who has put a considerable effort and still...
( 1 2)
|
December 15th, 2008 03:19 AM
by monir
|
10 |
132 |
|
|
Super slow table array formulas by
Dylan @ UAFC[_2_]
I have a data entry sheet were
sheet 1 has the table array fromulas
built down 25000 and accross about 12 columns.
The table is about 500,000 rows of 12...
|
|
8 |
132 |
|
|
|
|
3 |
132 |
|
|
Copy conditional format to rows below by
Hoot
I have a formula for conditional format set up on columns H1 and J1. It works
great for what I need. The problem is that I would like to fill-down the...
|
|
3 |
132 |
|
|
|
|
3 |
132 |
|
|
How to combine, IF, AND, OR Functions by
Simony32567
Hi all
I need some help combining IF, AND, OR functions (if it is possible)
What I am looking to do is:
I want all the results to display in F70
I have...
|
|
2 |
132 |