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	419
Time/priority problem sonic-the-mouse	by Jacob Skaria	2	338
how do I use a cell from one worksheet in the equation of another jpw	by mclwlg	3	379
Stuck on Formulas megsmom85	by JudithJubilee	1	446
Numbers of repeats of a string Luciano Paulino da Silva	by macropod[_2_]	11	1,391
Taking Average ignoring #DIV/0! in the range... Astro	by T. Valko	1	876
EDATE Function disappears intermittently Wendy	by T. Valko	1	456
Pivot Table - Old remaining values for rows ZorionK	by ZorionK	3	511
solver an uxexpected internal error ocurred, or available memory Jorge A.	by Jacob Skaria	1	605
Quarters PAL	by Jacob Skaria	1	373
filtering or selecting data baseed on time of day TBA	by Jacob Skaria	1	2,034
displaying changes Kackels	by Tom Hutchins	1	469
Help Calculating Partial Months between 2 dates. sirscottyog	by Ashish Mathur[_2_]	2	5,983
SUMIF formula with non contiguous cells Billy B	by Ashish Mathur[_2_]	2	771
Importing Data Wizard John L[_2_]	by John L[_2_]	6	479
Multiple results of Unique Values VickiMc	by Ashish Mathur[_2_]	3	436
Deleting rows or columns Darrell[_2_]	by Alan	1	465
How does one use a formula to bring over the formatting as well Bud	by Alan	1	428
Calculate Interest Rate Mark Parent	by JoeU2004	2	888
how do I look for cells showing dates less than a certain date? Annie and Naseem @ Ecojustice	by Bernie Deitrick	1	410
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	380
Help Calculating Time tech1NJ	by tech1NJ	5	419
Calculate Date brownmre	by T. Valko	6	588
Return column header as solution to lookup Tessa	by Tessa	3	2,784
Cell format for an array formula containing text Pete	by Pete	2	578
Vlookup with multiple workbooks Sally	by Luke M	1	1,757
Copy worksheet from one workbook to a master workbook mvannatta	by mvannatta	3	582
Pearsons skimball	by skimball	4	312
External reference to a Column AshMorK	by AshMorK	0	443
Confirmation Security Babs in Ohio	by Babs in Ohio	0	370
IF Statements Ben Joseph[_2_]	by Ben Joseph[_2_]	2	369
Adding values in first "X" number of rows dynamically MattyP	by T. Valko	3	1,134
Data Validation using a table JBranter	by JBranter	3	736
Headings of columns now have numbers, need to change them to lette JeffL	by David Biddulph[_2_]	3	521
IF(AND(OR function returns #VALUE! error Linda	by Linda	3	523
Concatenate unique values among duplicates Toby	by Herbert Seidenberg	6	2,977
How do I only send 1 worksheet of a file in an e-mail? JeffL	by Luke M	1	508
I cannot use DIAS.LAB in my Excel (Spanish) User VB Excel[_2_]	by User VB Excel[_2_]	0	500
Weekending Function Tracey	by Tracey	5	1,209
count formula question mcook	by mcook	2	331
excel function help [email protected]	by Charles Williams	4	381
Advanced Filter dicko1	by Herbert Seidenberg	2	366
Date Range msguirt	by David Biddulph[_2_]	2	430
How do I bracket text in cells by formatting a whole column? tywlam	by Sheeloo[_5_]	3	868
function =IFERROR LOOKUP works in excel 2007 not in excel 2003 David Ryan	by Steve	4	2,015
Lookup Problem with Index and Match Mike B	by Mike B	3	411
Time Calculations jacsdad	by Bob Phillips[_3_]	2	343
style sheets vs cell formatting Exceluser1	by Exceluser1	0	421
How do I ADD characters to the data for a group of cells? PatPatt	by PatPatt	2	432
Vlookup Error Farooqi	by Ashish Mathur[_2_]	2	421
mean of range of dates leot	by Jarek Kujawa[_2_]	3	894
Highest Values Comparison Darren	by Mike H	4	537
Excel virus? NZuser	by NZuser	8	488
SUM depending on date Espen Rostad[_2_]	by Espen Rostad[_2_]	1	444
HOW TO I GET LOOKUP TO USE THE SAME RANGE EVERYTIME Colm	by Jacob Skaria	1	516
Count functions Jalal	by Jalal	4	353
Repeat Cell Based on the Value-Excel 2003 Elaine	by Stefi	3	1,189
External excel file for pulldown list source Alan Lindner	by Sheeloo[_5_]	2	1,057
Convert numbers to words wins007	by Bernd P	4	494
Symbols Crissy	by Ron Rosenfeld	8	712
Vlookup Networking Issues Error 0X80070005	by Networking Issues Error 0X80070005	6	414
Check register running balance to another worksheet Marysam67	by T. Valko	1	1,575
Data Conversion - times, dates & rows Sara	by joel	5	386
percentage formula David Wilson[_2_]	by T. Valko	3	875
SUM, AVERAGE and PRINT with #N/A cells PaulinaDi	by T. Valko	11	891
Difference between 2 dates&time(format 0000), and excludes weekend YY san.[_2_]	by YY san.[_2_]	2	649
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	429
Sum cells that have both alpha and numbers Bluthjen	by Gord Dibben	3	1,959
Can't Prevent Recalculation [email protected]	by Charles Williams	4	437
IF Statement - compare to coloured cell LinLin	by LinLin	7	668
Percntages Adam	by Gord Dibben	9	471
Need Function Help TechieGirl	by T. Valko	8	391
I have lost the soft, blue borders of some cells. Gerald	by Gerald	6	6,363