Excel Worksheet Functions - Page 49

Thread / Thread Starter	Last Post	Replies	Views
Auto scroll down event andy62	by andy62	6	1,271
Multi-criteria lookup with Multiple results andy62	by Biff	3	551
Compare two strings andy62	by Ron Rosenfeld	8	2,916
range inside RANK formula based on contents of other cells andy62	by Biff	3	762
get a single count after looking up a set of values andy62	by Roger Govier	3	587
get a count from multiple lookups andy62	by Max	10	1,003
Error when insering a "Right" function andy62	by Franz Verga	1	354
Wildcard character inside sumproduct andy62	by Lori	4	1,808
Why does this formula clog my spreadsheet? andy62	by Charles Williams	3	374
Items in drop-down list alphabetized andy62	by T. Valko	6	705
display current cell contents in another worksheet andy62	by andy62	2	1,284
Data validation list limit? andy62	by T. Valko	3	1,413
Make hyperlink arrive at top of page andy62	by andy62	0	1,035
pop up calendar using MS DateTime Picker andy62	by andy62	4	1,105
Bubble Charts with two non-numerical variables andy62	by andy62	2	2,182
Prevent cut and paste over a range andy62	by andy62	0	525
Sumproduct with OR andy62	by andy62	7	656
Protect Workbook andy62	by Gord Dibben	4	576
Copy worksheet with internal hyperlinks andy62	by andy62	9	542
Data Validation source = destination? andy62	by Bernie Deitrick	7	937
Extract uniques from filtered range andy62	by Herbert Seidenberg	3	630
COUNTIF across multiple sheets with unknown names andy62	by ryguy7272	1	685
format text inside Concatenate andy62	by Dave Peterson	1	833
Need to condense my formula summing many values over many sheets Andy777	by CLR	5	650
CTRL and END function Andy787878	by Anne Troy	1	382
Vlookup Count confusion ! Andy787878	by Andy787878	15	928
Match Cells Andy920	by Dave Peterson	1	391
Linking formulas from seperate workbook Andy@cmk	by David Biddulph	1	408
Auto fill from pick list AndyB	by T. Valko	3	786
Need Help with custom function! AndyB	by Blink	5	341
Ignore calculation if text AndyB	by Pete_UK	4	634
Copy rows if greater than zero AndyB	by Max	3	1,401
Button to open JPG (Hyperlink) AndyB	by Gord Dibben	1	588
2 IF statements looking at two cells AndyB	by AndyB	2	389
Combining (nesting) 2 formulae AndyB	by AndyB	3	331
Relation betwn 2 sets of data, user to input one, sheet returns ot AndyB	by AndyB	4	466
Help on VLOOKUP with currencies AndyB	by AndyB	10	815
Lookup or similar Andycleos	by Bob Phillips	7	548
Looking up a maximum value that matches criteria. VLOOKUP? AndyCotgreave	by Max	4	1,538
GetPivotData with variable criteria input? (revisited!) AndyCotgreave	by Bijoy Mathew	4	1,755
Using average in two condition arrays... andyd2k	by Dave Peterson	1	397
help needed andyd358	by andyd358	0	360
function to count the amount of cells depending on part of the cell entry Andyd74	by Roger Govier	5	786
counting with multiple criteria Andyd74	by	3	383
matching part of an entry in a cell Andyd74	by Pete_UK	1	590
Searching TEXT in formulae, rather than results of formulae AndyE	by Niek Otten	1	862
finding value from table andyell	by paul	4	471
creating a quote looking up from tables andyell	by Max	1	401
hiding blank cells when no results andyell	by Max	2	697
Code to raise Directory request box ANDYGM	by ANDYGM	2	519
Counting blank cells between non-blank cells AndyH	by Shane Devenshire[_2_]	4	816
Total all instances of an entry for analysis AndyHanson	by AndyHanson	3	425
how to get a total to add up a range andyhofer	by Peo Sjoblom	1	372
Formulae for Tolerence andyhofer	by JMB	2	279
Hlookup, how di I get it to return more than one cell andyhofer	by JE McGimpsey	1	673
Function to Spread Costs andyhofer	by bj	1	329
Finding Closest Match andyiain	by Herbert Seidenberg	1	837
Conditional formatting to test blank text cell Andyjim	by Gord Dibben	4	1,013
Adding criteria to loop Andyjim	by Andyjim	0	565
Problem with formula showing in cell andyK	by andyK	2	449
Seperating information in a cell andyK	by Rick Rothstein \(MVP - VB\)[_1034_]	9	506
Summ figures that are not struck-through AndyKC	by Gord Dibben	2	377
Use of conditional formatting to remind of forthcoming birthdays AndyL82	by Franz Verga	3	924
Excel as relational database - data rows AndyLucia	by kassie	1	1,067
AutoFill in a Column Andym	by MartinW	3	472
Transpose to break up one long row to many? Andym	by Luke M	2	952
Totals of each product in a new worksheet andymaw11	by Scoops	2	410
creating Multiple If Statements depending on specific cell entry [email protected]	by [email protected]	0	496
Code modification help AndyMP	by Don Guillett	1	371
From multiple reporting people able to indentify next due report Andynwell	by Andynwell	0	370
Sum VLOOKUP? andyoftheg	by Ashish Mathur[_2_]	4	1,711
Date Calculation AndyO_UK	by Roger Govier	2	426
Sum or Countif over Multiple Columns AndyO_UK	by AndyO_UK	3	487
Sumif query AndyO_UK	by Don Guillett	4	474
Sumproduct Help AndyO_UK	by Bob Phillips	4	442