|
|
Please help., by
ck13
Basically you will have a table of data. In VLookup there are 3 things,
lookup value, table array and column. Note that the lookup value has to be on
the...
|
May 27th, 2010 08:53 PM
by ck13
|
0 |
198 |
|
|
Counting occurance of empty cells by
DaveC
Perfect thanks, worked a dream
"Tom Hutchins" wrote:
Try
=SUMPRODUCT(--(LEN(J157:J2643)0),--(LEN(K157:K2643)=0))
I used column K per your...
|
May 27th, 2010 08:53 PM
by DaveC
|
0 |
192 |
|
|
Algebraic Functions by
Jpleasant
How would you solve a function with input 1 output 8.
Then input 2 output 14.
next input 3 output is blank
then input is blank Output is 24.
the input is...
|
|
0 |
235 |
|
|
|
|
0 |
278 |
|
|
|
|
0 |
240 |
|
|
Single click selects multiple cells by
Mike1558
When clicking on a single cell multiple cells are selected. The one time
solution for this is to zoom in or out. This is problematic as 60% seems to
be the...
|
|
7 |
347 |
|
|
How to access macros via tool buttons? by
Mel
Excel v2007
When using v2003, I had many macros In my Personal.xls, which I
accessed via custom tool buttons on many custom toolbars that I built.
I now have...
|
|
2 |
361 |
|
|
Macro not working correctly by
Andy_N1708 via OfficeKB.com
Hello all,
I have written a macro that looks at one column of text and depending on what
is in the cell of that column, the macro would copy a template...
|
|
3 |
374 |
|
|
Test by
T. Valko
test
--
Biff
Microsoft Excel MVP
|
|
0 |
237 |
|
|
|
|
3 |
307 |
|
|
|
|
3 |
266 |
|
|
cross-hares by
PBG
Back in the day, when you selected a cell, you were able to have a line
appear vertical and horizontal I believe with your curser. It looked like...
|
|
1 |
224 |
|
|
Past Special- Transpose Function? by
Going Crazy with excel[_2_]
I have a master data base of 20 columns of data. I want to transpose only 6
columns of that data to a different sheet, automatically recognizing the
column...
|
|
7 |
281 |
|
|
|
May 25th, 2010 10:17 PM
by MMcGee
|
5 |
283 |
|
|
Macro to Cut and paste Values by
tr
I have a workbook with many lookups to external workbooks via function.
INDIERCT.EXT This works fine.....but is very slow; as it cycles every
associated...
|
May 25th, 2010 09:58 PM
by tr
|
2 |
291 |
|
|
|
May 25th, 2010 09:55 PM
by CVinje
|
0 |
235 |
|
|
Need To Track Advertising by
clarkshvac.com
I am looking for either an Excel Ttemplate or a formula that will do the
following:
1. Enter various methods of advertising, ie, print, online, radio etc.
2....
|
|
0 |
206 |
|
|
Color differences in Mac Excel by
Vicky
Hi,
We create Excel files with conditional formatting on Windows XP pcs. The
colors depend on the value of the cell: typical formatting i.e. red = bad,...
|
|
1 |
286 |
|
|
summing two columns of different data by
Dick Scoppettone
I need to sum a dollar total from two different types of columns. One column
identifies the item and another column associates a dollar amount with that...
|
|
4 |
314 |
|
|
Best place/book to get advanced training? by
JS
I've been using excel for a long time, but my new job requires me to be more
of a power user than I currently am.
Any suggestions on online course/tutorials?...
|
|
1 |
333 |