Excel Worksheet Functions - Page 661

Thread / Thread Starter	Last Post	Replies	Views
HELP COUNTING Pat Brewington	by Bob Phillips	6	490
How to determine color of a cell? KW	by KW	2	936
Lookup value in table BONITA	by Biff	5	579
Forecast using 2 data sets goofy11	by Mike Middleton	1	410
Excel VBA bug? markx	by Ron de Bruin	1	436
Keep cursor in 1 cell Greg	by Niek Otten	5	386
meaning of : IF(Switch; Average(array A, array B); array A) DXAT	by Bernard Liengme	1	1,460
Counting multiple values within single cells Terry Bennett	by Kevin Vaughn	5	1,237
Formula Help Erika	by Dave F	1	408
Worksheet function: last saved date Tieske	by Jim Thomlinson	1	547
How can I sort or search the sheet tabs? spippin	by Dave Peterson	3	441
=IF(B1,"",SUMPRODUCT(--(B$1:B$5=""),--(A1<A$1:A$5))+1), Biff formula Rasoul Khoshravan	by Kevin Vaughn	1	816
Extract Symbol Karen	by Karen	9	380
Rearranging Data Within a Cell LDL	by LDL	5	546
Calculating time increments from dates during working hours S Davis	by S Davis	0	805
Passwords in macros Julian Glass	by Paul B	1	400
Automatically display filter range in report header in Excel Kjetil	by Kjetil	3	622
Cell to cell hyperlinking does not work, please help Trevor	by Bernard Liengme	1	315
Count months away betwwen a strat and end date by month JY	by Bernard Liengme	1	866
SUMPRODUCT, SUM(IF(...), or some combination? [email protected]	by RobertH	2	745
HOW TO ASSIGN NUMERICAL VALUES TO LETTERS IN EXCEL teacherpaul	by teacherpaul	5	1,443
Hyperlink using a variable destination Christos T	by Bernie Deitrick	1	687
advantage of Database functions Rasoul Khoshravan	by Rasoul Khoshravan	0	973
Change Tab colour using Macro Rajat	by Rajat	4	550
Need to Color Record in Duplicates nirod	by nirod	0	549
How do I summarise what I want.... lee	by lee	0	350
Lookup Tables Craig McK	by Craig McK	0	365
measure calculation time for multiplication of two matrices Rasoul Khoshravan	by Rasoul Khoshravan	0	685
Can I increase the length data from a formula in a cell? John	by John	0	391
annual growing rate formula or funtion needed!! Ivan	by Niek Otten	1	549
what does { and } mean in an Excel formula? Marcus Sparcus	by Pete_UK	2	1,068
AND function? fish	by fish	4	380
How do I match up two tables of data with one column in common Zman	by Ken Wright	1	743
add text in a cell to trigger a calculation noddy47	by Pete_UK	3	409
hyperlink to .png file bobby binx	by bobby binx	0	1,498
Nexted if()s are limited to Seven What other functions can I use? dan	by JLatham	8	554
Dsum date based on selection of months [email protected]	by Biff	1	591
Formulae Help, should be easy... legs	by JMB	2	367
I need a template for my supply inventory kmatthews	by Juan	4	3,659
5 minutes intervals april	by Pete_UK	2	889
Copy a table from a web site, then manipulate the data? Confused Rookie	by Don Guillett	1	489
automation autosave .xls as .txt jim sturtz	by JLatham	5	1,910
FUNCTION STABILITY romelsb	by romelsb	5	407
matching two worksheets and return to different value dan	by smw226 via OfficeKB.com	2	810
my mouse pointer locks on a cell in excel teach3's	by Dave Peterson	4	1,439
VBA language question. Rob	by Sandy	1	773
Lookup multiple values return one value corresponding value Excel DP7	by Biff	1	6,252
Parameters question TR	by romelsb	5	413
change tab colour when using conditional formatting in a cell julie s	by julie s	6	1,585
how do i make negative numbers equal zero benny1	by Elkar	2	1,364
How can I check for dupes in more than one column in excel? latwood	by Teethless mama	2	575
Round to up to a threshold jeffbert	by jeffbert	6	1,129
How to return value from functions in other sheets? TR	by TR	3	582
Cell contents in header/footer mdavison	by mdavison	5	733
REVERSE SINGLE CELL TEXT STRING Tammy	by Biff	2	985
Vlookup formula criteria gmunro	by Biff	3	462
Whats wrong with this OR formula? Mark	by Pete_UK	4	523
Unhide and hide columns [email protected]	by Dave Peterson	1	612
Create a List by formula from other data Kim Shelton at PDC	by Biff	1	386
reference with variable row number ? Arc_K	by Biff	7	986
Default to zero currency value SITCFanTN	by Dave F	1	463
how do i highlight a date that is 4+ days old in excel? Picodillo	by romelsb	3	1,884
Function across multiple worksheet phil	by Biff	7	380
and < for Array Sumif ({}) Kiwi Matt	by Bernie Deitrick	6	627
PLEASE PLEASE INDEX MATCH OR SOMETHING ELSE ?? MichelleS	by MichelleS	0	306
Dividing hours to give days SueJB	by SueJB	2	1,155
How do I prevent entering duplicate numbers in an excel worksheet Bran5956	by Jim Thomlinson	1	581
Adding sheets to workbook Susan	by Susan	4	518
Excel formula for golf score to handicap RFGC	by Gord Dibben	1	2,412
aging Rina	by Rina	2	2,090
How to Input date & Time [NOW()], then stop it updating? jonathandr	by Gord Dibben	3	1,692
Microsoft Excel Formula Help Munchkin 76	by Ron Coderre	6	541
if, then formula with conditional formating Rex	by Rex	4	509
add numbers in different cells , but ignore cell with #VALUE! to t Steved	by Steved	0	544
Help with MATCH function Philip	by vezerid	5	396