Excel Worksheet Functions - Page 198

Thread / Thread Starter	Last Post	Replies	Views
Calculate the number of hours in a date/time cell richardwo	by Jacob Skaria	1	428
Time/priority problem sonic-the-mouse	by Jacob Skaria	2	352
how do I use a cell from one worksheet in the equation of another jpw	by mclwlg	3	380
Stuck on Formulas megsmom85	by JudithJubilee	1	454
Numbers of repeats of a string Luciano Paulino da Silva	by macropod[_2_]	11	1,409
Taking Average ignoring #DIV/0! in the range... Astro	by T. Valko	1	885
EDATE Function disappears intermittently Wendy	by T. Valko	1	467
Pivot Table - Old remaining values for rows ZorionK	by ZorionK	3	520
solver an uxexpected internal error ocurred, or available memory Jorge A.	by Jacob Skaria	1	618
Quarters PAL	by Jacob Skaria	1	377
filtering or selecting data baseed on time of day TBA	by Jacob Skaria	1	2,051
displaying changes Kackels	by Tom Hutchins	1	482
Help Calculating Partial Months between 2 dates. sirscottyog	by Ashish Mathur[_2_]	2	5,997
SUMIF formula with non contiguous cells Billy B	by Ashish Mathur[_2_]	2	783
Importing Data Wizard John L[_2_]	by John L[_2_]	6	498
Multiple results of Unique Values VickiMc	by Ashish Mathur[_2_]	3	446
Deleting rows or columns Darrell[_2_]	by Alan	1	477
How does one use a formula to bring over the formatting as well Bud	by Alan	1	439
Calculate Interest Rate Mark Parent	by JoeU2004	2	894
how do I look for cells showing dates less than a certain date? Annie and Naseem @ Ecojustice	by Bernie Deitrick	1	425
Display a number in feet inches and fractions of and inch Michael Peace[_2_]	by Glenn	1	700
Adding a pre-fix to each item in a cell nasadell	by Glenn	1	392
Help Calculating Time tech1NJ	by tech1NJ	5	429
Calculate Date brownmre	by T. Valko	6	600
Return column header as solution to lookup Tessa	by Tessa	3	2,799
Cell format for an array formula containing text Pete	by Pete	2	590
Vlookup with multiple workbooks Sally	by Luke M	1	1,766
Copy worksheet from one workbook to a master workbook mvannatta	by mvannatta	3	583
Pearsons skimball	by skimball	4	315
External reference to a Column AshMorK	by AshMorK	0	455
Confirmation Security Babs in Ohio	by Babs in Ohio	0	379
IF Statements Ben Joseph[_2_]	by Ben Joseph[_2_]	2	380
Adding values in first "X" number of rows dynamically MattyP	by T. Valko	3	1,149
Data Validation using a table JBranter	by JBranter	3	750
Headings of columns now have numbers, need to change them to lette JeffL	by David Biddulph[_2_]	3	532
IF(AND(OR function returns #VALUE! error Linda	by Linda	3	534
Concatenate unique values among duplicates Toby	by Herbert Seidenberg	6	2,990
How do I only send 1 worksheet of a file in an e-mail? JeffL	by Luke M	1	521
I cannot use DIAS.LAB in my Excel (Spanish) User VB Excel[_2_]	by User VB Excel[_2_]	0	507
Weekending Function Tracey	by Tracey	5	1,221
count formula question mcook	by mcook	2	345
excel function help [email protected]	by Charles Williams	4	402
Advanced Filter dicko1	by Herbert Seidenberg	2	380
Date Range msguirt	by David Biddulph[_2_]	2	438
How do I bracket text in cells by formatting a whole column? tywlam	by Sheeloo[_5_]	3	883
function =IFERROR LOOKUP works in excel 2007 not in excel 2003 David Ryan	by Steve	4	2,032
Lookup Problem with Index and Match Mike B	by Mike B	3	424
Time Calculations jacsdad	by Bob Phillips[_3_]	2	356
style sheets vs cell formatting Exceluser1	by Exceluser1	0	431
How do I ADD characters to the data for a group of cells? PatPatt	by PatPatt	2	446
Vlookup Error Farooqi	by Ashish Mathur[_2_]	2	434
mean of range of dates leot	by Jarek Kujawa[_2_]	3	906
Highest Values Comparison Darren	by Mike H	4	547
Excel virus? NZuser	by NZuser	8	500
SUM depending on date Espen Rostad[_2_]	by Espen Rostad[_2_]	1	458
HOW TO I GET LOOKUP TO USE THE SAME RANGE EVERYTIME Colm	by Jacob Skaria	1	527
Count functions Jalal	by Jalal	4	367
Repeat Cell Based on the Value-Excel 2003 Elaine	by Stefi	3	1,205
External excel file for pulldown list source Alan Lindner	by Sheeloo[_5_]	2	1,119
Convert numbers to words wins007	by Bernd P	4	507
Symbols Crissy	by Ron Rosenfeld	8	715
Vlookup Networking Issues Error 0X80070005	by Networking Issues Error 0X80070005	6	417
Check register running balance to another worksheet Marysam67	by T. Valko	1	1,586
Data Conversion - times, dates & rows Sara	by joel	5	400
percentage formula David Wilson[_2_]	by T. Valko	3	880
SUM, AVERAGE and PRINT with #N/A cells PaulinaDi	by T. Valko	11	907
Difference between 2 dates&time(format 0000), and excludes weekend YY san.[_2_]	by YY san.[_2_]	2	655
Screen Size [email protected]	by Dave	2	346
how do I create a nonadjacent series for autofill to go by? BoyGenius	by Sheeloo[_5_]	3	442
Sum cells that have both alpha and numbers Bluthjen	by Gord Dibben	3	1,977
Can't Prevent Recalculation [email protected]	by Charles Williams	4	450
IF Statement - compare to coloured cell LinLin	by LinLin	7	677
Percntages Adam	by Gord Dibben	9	471
Need Function Help TechieGirl	by T. Valko	8	404
I have lost the soft, blue borders of some cells. Gerald	by Gerald	6	6,365