Excel Worksheet Functions - Page 462

Thread / Thread Starter	Last Post	Replies	Views
Create Comments Vinod[_2_]	by Dave Peterson	1	446
Conditional formatting in a table is lost on table refresh Steve Huckett	by Steve Huckett	0	1,567
automatic capital letter in a cell capital letter	by Gary''s Student	1	947
Problem with COUNTIF ... Mac	by Roger Govier[_3_]	1	440
Vlookup+ Select Next Earliest Value (Array formula?) [email protected]	by RagDyeR	1	738
Display formulae instead of showing values in cells Kent	by Kent	3	805
Is there a Best Of Function in Excel? VipinK	by Peo Sjoblom	2	1,557
VLOOKUP data missed Thomas	by T. Valko	3	582
(Max - Min) for a dynamic range within a table [email protected]	by Pete_UK	4	738
Hyperlink formula with destination in same worksheet thexdane	by Dave Peterson	1	753
mortgage payment england26	by joeu2004	2	768
VLOOKUP a	by Gord Dibben	3	384
Summing WRC	by Pete_UK	4	470
summing non-contiguous array cells WRC	by Pete_UK	10	1,503
Finding duplicates in distinct ranges... Mac	by Mac	2	599
Formula in cell albericht	by CLR	2	356
matching/comparing lists Mortir	by Pete_UK	1	505
Vesting Formula cjyardley	by cjyardley	7	4,092
Different Results in each time I click on F9 Simone	by Myrna Larson	3	598
Help with Logical Formula talltom	by talltom	4	467
Filters Clint Eastwood	by Dave Peterson	3	344
Large Time totals not summing. Brik	by T. Valko	3	385
conditional format question - I think... simon	by Sandy Mann	3	486
How do I ??? - two drop down lists Jock	by Pete_UK	3	512
VBA help for functions JC	by JC	5	422
minimum stock level Ylevco	by bj	1	974
Large Time values not summing Sam	by Brik	2	562
Disable dropdown list (Combo box -"Form control") Vinod[_2_]	by Texas Aggie	1	3,201
Calculating and posting when a qty will go negative. Gene Haines	by Gene Haines	0	507
Pivot on a shared workbook nabanco	by Roger Govier[_3_]	1	331
Pivot Table Calculations CherylC	by Roger Govier[_3_]	2	492
DocumentProperty Peter KarlstrÃ¶m	by Gary''s Student	5	332
Replicating worksheet references SueG	by Max	5	459
How do I allow users to edit links in a protected worksheet? Shere	by Shere	0	792
minif Andes2U	by JP[_3_]	5	644
Remove headers in file Hilton	by Hilton	0	395
Formula and values stay with row/cell after sort Margo	by Margo	0	688
IF Statement: cell referencing Mike	by Gav123	5	636
using 3 tables in one spreadsheet and utilising index formula to retrieve information Aaron Hodson \(Coversure\)	by Aaron Hodson \(Coversure\)	2	378
Vvlookup and count Freddy[_2_]	by Mike H	5	541
Comparing data in 2 cells to create an output for a 3rd cell [email protected]	by [email protected]	2	570
Protect cell range Sanjiv	by Gav123	2	396
Populating a Range Dependant on a List [email protected]	by Pete_UK	9	580
Autofiltering Thapelo	by Thapelo	3	497
using the if command I think steve	by steve	2	327
How to define and select the last (bottom) number in a column? BrendaN_at_Welke_Customs	by T. Valko	24	2,800
formula help yshridhar	by yshridhar	8	485
percentage formula101	by formula101	2	567
counting the number of events in a year Mytmini	by Ron Coderre	2	492
RTD Function Joseph A. Zupko	by Chip Pearson	2	433
Help with a formula Funkyfido	by Roger Govier[_3_]	6	436
Exponential escapeman	by Stan Brown	9	780
please help with lookup function Carl Pro	by Gord Dibben	3	431
How do I get rid of #DIV/0! part 2 [email protected]	by joeu2004	3	473
Any good excel websites? Crackles McFarly	by Crackles McFarly	11	1,014
Function for finding a cell with Anumber in it steve	by Teethless mama	3	398
cell referencing Michael	by JLatham	3	445
Trying to check 2 columns for text and add a 3rd col to total RickR	by JE McGimpsey	1	367
Weighted average of Assets Under management YTD per portfolio Vladimir	by Vladimir	0	869
SUMPRODUCT & INDIRECT? lou031205	by T. Valko	4	626
Advanced Sum or marco needed???? JMK	by Pete_UK	4	389
search for any lowercase immediately followed by an UPPERCASE [email protected]	by Ron Rosenfeld	9	1,757
Circular Margo	by Gord Dibben	7	1,079
formula adjustment Candace	by Ian[_4_]	2	489
TECHNICS U EVER DREAMED OF .... TECHNICS U EVER DREAMED OF ....	by TECHNICS U EVER DREAMED OF ....	0	264
TECHNICS U EVER DREAMED OF .... TECHNICS U EVER DREAMED OF ....	by TECHNICS U EVER DREAMED OF ....	0	374
TECHNICS U EVER DREAMED OF .... TECHNICS U EVER DREAMED OF ....	by TECHNICS U EVER DREAMED OF ....	0	360
Problem with using INDIRECT with SUMPRODUCT and ROW() JB99	by RagDyeR	11	1,437
How do I separate wrap text in excel spreadsheet? separate wrapped text	by Gord Dibben	2	1,439
How can I clear all cells containing #n/a on a spreadsheet? haynheart	by Gord Dibben	4	4,379
Formula Help needed Krish	by Roger Govier[_3_]	2	404
How do I get rid of #DIV/0! [email protected]	by Teethless mama	4	574
Macros to cells, formula only not data locked Margo	by Margo	4	520
Maximum Number of Blank Cells between Non Blank Cells in a Range Mal	by Bernd P	5	1,829
i need help with a function application with multiple arguments tarabull	by JE McGimpsey	3	419