Excel Worksheet Functions - Page 523

Thread / Thread Starter	Last Post	Replies	Views
how do i make negative numbers equal zero benny1	by Elkar	2	1,364
change tab colour when using conditional formatting in a cell julie s	by julie s	6	1,585
Parameters question TR	by romelsb	5	413
Lookup multiple values return one value corresponding value Excel DP7	by Biff	1	6,252
VBA language question. Rob	by Sandy	1	773
my mouse pointer locks on a cell in excel teach3's	by Dave Peterson	4	1,439
matching two worksheets and return to different value dan	by smw226 via OfficeKB.com	2	810
FUNCTION STABILITY romelsb	by romelsb	5	407
automation autosave .xls as .txt jim sturtz	by JLatham	5	1,910
Copy a table from a web site, then manipulate the data? Confused Rookie	by Don Guillett	1	489
5 minutes intervals april	by Pete_UK	2	889
I need a template for my supply inventory kmatthews	by Juan	4	3,657
Formulae Help, should be easy... legs	by JMB	2	367
Dsum date based on selection of months [email protected]	by Biff	1	591
Nexted if()s are limited to Seven What other functions can I use? dan	by JLatham	8	554
hyperlink to .png file bobby binx	by bobby binx	0	1,498
add text in a cell to trigger a calculation noddy47	by Pete_UK	3	409
How do I match up two tables of data with one column in common Zman	by Ken Wright	1	742
AND function? fish	by fish	4	380
what does { and } mean in an Excel formula? Marcus Sparcus	by Pete_UK	2	1,068
annual growing rate formula or funtion needed!! Ivan	by Niek Otten	1	549
Can I increase the length data from a formula in a cell? John	by John	0	391
measure calculation time for multiplication of two matrices Rasoul Khoshravan	by Rasoul Khoshravan	0	685
Lookup Tables Craig McK	by Craig McK	0	365
How do I summarise what I want.... lee	by lee	0	350
Need to Color Record in Duplicates nirod	by nirod	0	549
Change Tab colour using Macro Rajat	by Rajat	4	550
advantage of Database functions Rasoul Khoshravan	by Rasoul Khoshravan	0	973
Hyperlink using a variable destination Christos T	by Bernie Deitrick	1	687
HOW TO ASSIGN NUMERICAL VALUES TO LETTERS IN EXCEL teacherpaul	by teacherpaul	5	1,443
SUMPRODUCT, SUM(IF(...), or some combination? [email protected]	by RobertH	2	745
Count months away betwwen a strat and end date by month JY	by Bernard Liengme	1	864
Cell to cell hyperlinking does not work, please help Trevor	by Bernard Liengme	1	315
Automatically display filter range in report header in Excel Kjetil	by Kjetil	3	622
Passwords in macros Julian Glass	by Paul B	1	400
Calculating time increments from dates during working hours S Davis	by S Davis	0	805
Rearranging Data Within a Cell LDL	by LDL	5	546
Extract Symbol Karen	by Karen	9	380
=IF(B1,"",SUMPRODUCT(--(B$1:B$5=""),--(A1<A$1:A$5))+1), Biff formula Rasoul Khoshravan	by Kevin Vaughn	1	813
How can I sort or search the sheet tabs? spippin	by Dave Peterson	3	441
Worksheet function: last saved date Tieske	by Jim Thomlinson	1	547
Formula Help Erika	by Dave F	1	408
Counting multiple values within single cells Terry Bennett	by Kevin Vaughn	5	1,237
meaning of : IF(Switch; Average(array A, array B); array A) DXAT	by Bernard Liengme	1	1,455
Keep cursor in 1 cell Greg	by Niek Otten	5	386
Excel VBA bug? markx	by Ron de Bruin	1	436
Forecast using 2 data sets goofy11	by Mike Middleton	1	408
Lookup value in table BONITA	by Biff	5	579
How to determine color of a cell? KW	by KW	2	935
HELP COUNTING Pat Brewington	by Bob Phillips	6	490
Function within a function? Stefan	by Stefan	5	489
How do I write the IF function to reflect the result in one cell? AMBO	by Trevor Shuttleworth	8	578
Unique list of entries Rasoul Khoshravan	by Kevin Vaughn	1	377
sequential number code becky42002	by Bob Phillips	5	673
Trouble With Data Validation And Filtering On A Dropdown zura04	by zura04	0	738
copy unique data Sam	by Sam	8	485
How to search a column that is not the first of the table Antonio	by Antonio	4	354
Reforecast budgets Jane	by romelsb	1	1,316
Fill color not functioning in newly installed version of excel. Vernon Antoine Brou Jr.	by Vernon Antoine Brou Jr.	2	607
copy workbook files without losing data that was in the org. work rue	by rue	0	604
total the column anyway Robb27	by Robb27	6	488
how to create a if statement, if true turn colour Yashes	by Richard Buttrey	3	1,383
IF Function doesn't recognize TRUE AMY Z.	by Biff	6	1,951
Index / Match tinman	by Biff	4	363
I need an amortization schedule with the first 6mo no payment? kmagolden	by kmagolden	0	725
Excel Formula Pat	by Teethless mama	3	358
sort subtotal groups Clair	by Clair	0	717
how do I caluclate return on investment, compounded quarterly? SAR	by [email protected]	3	3,642
Is there a way to name tabs so that they will ascend in order? madchef	by romelsb	8	613
how to determine if a series of numbers contain odd or even values Kittysaid	by RagDyeR	6	529
Calculate time within time Frigid	by Frigid	2	580
Multiple criteria for lookup table Mark	by Mark	3	971
Possible to keep a macro seperated from a sheet? [email protected]	by Gord Dibben	2	367
How do I count rows within a cell? Jouni Kananen	by Gord Dibben	3	2,308
How to print the circles in formatting audit circle invalid data Creativity	by Creativity	0	603