Excel Worksheet Functions - Page 358

Thread / Thread Starter	Last Post	Replies	Views
Nested Limitations _Bigred	by George	3	504
INDIRECT.EXT Stephan	by Stephan	0	574
Vlookup problem.. Neo1	by Gizmo63	5	527
Highlight a row automatically if a cell meets certain criteria simonvrowley	by [email protected]	5	3,378
1000+$K$5/1000 -what does $ indicate in formula Coolbhims	by Paul B	1	875
Final Week for Standard Registration - Excel User Conference Book Drawing - April 2006 Damon Longworth	by Damon Longworth	0	458
spreadsheet protection? chrissywhittle	by	3	449
the function =cell() s	by s	2	379
Hours and minutes in excel [email protected]	by Thunder	5	597
pivot table not showing field list bobteixeira	by bobteixeira	0	1,205
How do I make a text box accessible in a protected Excel sheet? JWarnick-SHH	by SteveG	5	1,084
Summary of hyperlink info on spreadsheets domdom8754	by domdom8754	0	506
Calculate a quantity rebate Sige	by Sige	1	636
Can a function return a Null (blank ) value? Maybe a custom functi colin_e	by colin_e	2	1,879
=SUMPRODUCT formula is counting the blank cells as well as zero's JR	by	1	650
Function(s) that return multiple separated references akullen	by akullen	2	446
count labels in a given range john516	by	1	640
Array constant issue Sige	by Sige	16	1,374
address help (similar to trim or transpose) Aaaaa	by colin_e	1	370
vlookup formula not working with data on separate sheet akee	by Cutter	18	2,013
Can array formulas work if rows are inserted? Chris	by Ron Coderre	1	489
Function Help Erika	by CLR	2	369
=SUMPRODUCT formula is counting the blank cells as well as zero's JR	by Sloth	2	809
??? get "#NUM" doing 190^190 Jaylin	by Dave Peterson	3	407
how do i set different margins within document Marykate	by Dave Peterson	1	1,674
if then else Sandy	by Sandy	2	438
How do I collate (match-up) one column's data with another? Mark	by Mark	2	3,600
Add a criteria to sumproduct JR	by bpeltzer	1	424
Linking large worksheets Kirstin	by Kirstin	0	419
Looking up a table Gary	by Gary	3	283
Is there a way to count cells in a range based on fill color? eehinmd	by eehinmd	2	1,163
Fill Colors JackD	by JackD	2	350
invoices toll	by via135	2	446
Updating a named range joala	by joala	2	485
Identification of duplicate records Uma Ravishankar	by Tom Ogilvy	2	603
"Array Formula?" kermitforney	by Domenic	1	372
Sumproduct ?? Question carl	by Herbert Seidenberg	3	335
Data entry - Copy contents of cell typed in one cell to another ce danie	by danie	2	935
Changing a cell referance on multipule cells CES	by Gary''s Student	3	728
Alphabetizing Worksheets Dave	by Sloth	3	690
Another Conditional Formating Question RalphSE	by RalphSE	2	449
hash function for large strings jheby	by jheby	22	3,367
Convert days in decimal to days:hours:minutes Todd F.	by Todd F.	7	4,209
Formula to sum every 4th cell returns #DIV/0! error in some column Brent	by Domenic	5	902
Checking Two Fields Nick	by Nick	2	310
Extracting Text Michael	by Michael	3	485
locking formula cell references Superchikn	by Sloth	3	537
Splitting a cell David	by CLR	2	472
lookup table with specific criterea joala	by SteveG	6	415
can countif function look at 2 separate columns for criteria blake7	by Daniel CHEN	2	562
Target Param	by Daniel CHEN	1	467
Comparing Cells gdeleos	by Domenic	2	489
"File" has disappeared from my menu bar Steffi	by Gord Dibben	5	1,169
share specific columns with other users BeckyS	by BeckyS	0	479
Making N/A become a zero Jaye	by Jaye	4	543
why after mailmerged the data can not be read? Bell Wan	by Gord Dibben	1	397
Text To Columns JR	by JR	2	380
Compare values, display date DeejGCK	by DeejGCK	2	507
Can Excel do this? (Template?) kermitforney	by Gord Dibben	2	321
Slow Calculation speeds in big spreadsheet MichaelC	by Pete_UK	1	631
How do I replace negative numbers with zero in Excel. Sloth	by Sloth	0	1,087
How do I replace negative numbers with zero in Excel. A Blaylock	by A Blaylock	0	902
Logical Test Lance	by Trevor Shuttleworth	1	714
How do I create a formula to always add 1 to a quote id # field? Matt	by Matt	0	452
Tracking Change Date TJ	by NikkiB	6	539
"find and replace" negative numbers pk	by Kevin Vaughn	5	1,960
two workbooks with extension .xls1 and .xls2 Mar	by Mar	9	1,104
Merging list into a form tammyj	by tammyj	0	548
VLOOKUP(lookup_value, ___ ,col_index_num,range_lookup) RICKY	by Biff	3	733
Formula for displaying in 1 cell Lowest value from multiple other cells [email protected]	by Beege	1	878
change the negative sign to brackets but no choice is available the old guy	by Beege	1	817
Excel 12 should have text annotations (as Business Scorecards) BjÃ¸rn Tingstadengen	by Peo Sjoblom	1	478
NPV vs. XNPV Robert	by [email protected]	2	2,434
Pivotable Sum of Cost times Quantity Jim Pockmire	by Jim Pockmire	0	607
Nesting VLOOKUP & HLOOKUP tuph	by tuph	5	1,408