Excel Worksheet Functions - Page 826

Thread / Thread Starter	Last Post	Replies	Views
can countif function look at 2 separate columns for criteria blake7	by Daniel CHEN	2	568
lookup table with specific criterea joala	by SteveG	6	428
Splitting a cell David	by CLR	2	493
locking formula cell references Superchikn	by Sloth	3	570
Extracting Text Michael	by Michael	3	504
Checking Two Fields Nick	by Nick	2	339
Formula to sum every 4th cell returns #DIV/0! error in some column Brent	by Domenic	5	921
Convert days in decimal to days:hours:minutes Todd F.	by Todd F.	7	4,252
hash function for large strings jheby	by jheby	22	3,393
Another Conditional Formating Question RalphSE	by RalphSE	2	472
Alphabetizing Worksheets Dave	by Sloth	3	699
Changing a cell referance on multipule cells CES	by Gary''s Student	3	745
Data entry - Copy contents of cell typed in one cell to another ce danie	by danie	2	964
Sumproduct ?? Question carl	by Herbert Seidenberg	3	361
"Array Formula?" kermitforney	by Domenic	1	378
Identification of duplicate records Uma Ravishankar	by Tom Ogilvy	2	618
Updating a named range joala	by joala	2	500
invoices toll	by via135	2	453
Fill Colors JackD	by JackD	2	354
Is there a way to count cells in a range based on fill color? eehinmd	by eehinmd	2	1,188
Looking up a table Gary	by Gary	3	288
Linking large worksheets Kirstin	by Kirstin	0	429
Add a criteria to sumproduct JR	by bpeltzer	1	440
How do I collate (match-up) one column's data with another? Mark	by Mark	2	3,631
if then else Sandy	by Sandy	2	443
how do i set different margins within document Marykate	by Dave Peterson	1	1,688
??? get "#NUM" doing 190^190 Jaylin	by Dave Peterson	3	411
=SUMPRODUCT formula is counting the blank cells as well as zero's JR	by Sloth	2	852
Function Help Erika	by CLR	2	373
Can array formulas work if rows are inserted? Chris	by Ron Coderre	1	515
vlookup formula not working with data on separate sheet akee	by Cutter	18	2,049
address help (similar to trim or transpose) Aaaaa	by colin_e	1	380
Array constant issue Sige	by Sige	16	1,399
count labels in a given range john516	by	1	669
Function(s) that return multiple separated references akullen	by akullen	2	470
=SUMPRODUCT formula is counting the blank cells as well as zero's JR	by	1	679
Can a function return a Null (blank ) value? Maybe a custom functi colin_e	by colin_e	2	1,907
Calculate a quantity rebate Sige	by Sige	1	646
Summary of hyperlink info on spreadsheets domdom8754	by domdom8754	0	540
How do I make a text box accessible in a protected Excel sheet? JWarnick-SHH	by SteveG	5	1,111
pivot table not showing field list bobteixeira	by bobteixeira	0	1,240
Hours and minutes in excel [email protected]	by Thunder	5	602
the function =cell() s	by s	2	385
spreadsheet protection? chrissywhittle	by	3	463
Final Week for Standard Registration - Excel User Conference Book Drawing - April 2006 Damon Longworth	by Damon Longworth	0	473
1000+$K$5/1000 -what does $ indicate in formula Coolbhims	by Paul B	1	888
Highlight a row automatically if a cell meets certain criteria simonvrowley	by [email protected]	5	3,400
Vlookup problem.. Neo1	by Gizmo63	5	545
INDIRECT.EXT Stephan	by Stephan	0	591
Nested Limitations _Bigred	by George	3	528
Use of Text Phrases in Excel Functions Girija	by Girija	0	436
Inventory Brought Foward jvq	by jvq	0	402
equals the actual number...not text ???? JcR	by Biff	7	936
Inventory and Date Ranges TK	by jvq	1	453
List cumulative values in a column danie	by Biff	1	406
Number of work days/month Vanna	by MarkN	1	725
if then formula kdw	by kdw	4	504
Formula for Reading A Non-Existent Reference pskwaak	by pskwaak	0	482
Formula to read non-existant reference? pskwaak	by pskwaak	0	450
create an autofill series! via135	by via135	2	620
Why does excel calculate difference in days from February - March TennCare Technician	by TennCare Technician	3	529
Data Validation question anny	by Biff	8	458
how do I reference tab labels from a worksheet in a cell in the wb keri	by Max	1	472
How can I check if any of the entires is True in a range? Tetsuya Oguma	by Peo Sjoblom	1	420
DATE SET jgregory	by davesexcel	5	374
Complex Sort Question Chas	by Chas	2	372
how can I find out a total as a percentage using absolute cell JoJo	by Fred Smith	1	867
Possible? bonzai18	by Max	1	305
Macro to stop at a certain tab and does not go to the next one. [email protected]	by Dave Peterson	3	561
Multimodal Madness Rothman	by Rothman	0	447
count cells containing text Lisa W	by Gary''s Student	5	1,331
Hide all values in a row if value is 0 Erik T	by Otto Moehrbach	1	413
Tieing in the Company and the products steppie70	by Otto Moehrbach	1	346
Rounding off problem..! Neo1	by daddylonglegs	3	518
Cell Limitations ? Formatting and Size when exporting to Tab based Text file? PaulH_1980	by wjohnson	1	900