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	420
Time/priority problem sonic-the-mouse	by Jacob Skaria	2	339
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	447
Numbers of repeats of a string Luciano Paulino da Silva	by macropod[_2_]	11	1,393
Taking Average ignoring #DIV/0! in the range... Astro	by T. Valko	1	877
EDATE Function disappears intermittently Wendy	by T. Valko	1	456
Pivot Table - Old remaining values for rows ZorionK	by ZorionK	3	512
solver an uxexpected internal error ocurred, or available memory Jorge A.	by Jacob Skaria	1	606
Quarters PAL	by Jacob Skaria	1	374
filtering or selecting data baseed on time of day TBA	by Jacob Skaria	1	2,037
displaying changes Kackels	by Tom Hutchins	1	470
Help Calculating Partial Months between 2 dates. sirscottyog	by Ashish Mathur[_2_]	2	5,984
SUMIF formula with non contiguous cells Billy B	by Ashish Mathur[_2_]	2	777
Importing Data Wizard John L[_2_]	by John L[_2_]	6	486
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	889
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	589
Return column header as solution to lookup Tessa	by Tessa	3	2,786
Cell format for an array formula containing text Pete	by Pete	2	578
Vlookup with multiple workbooks Sally	by Luke M	1	1,760
Copy worksheet from one workbook to a master workbook mvannatta	by mvannatta	3	583
Pearsons skimball	by skimball	4	312
External reference to a Column AshMorK	by AshMorK	0	445
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,136
Data Validation using a table JBranter	by JBranter	3	738
Headings of columns now have numbers, need to change them to lette JeffL	by David Biddulph[_2_]	3	526
IF(AND(OR function returns #VALUE! error Linda	by Linda	3	524
Concatenate unique values among duplicates Toby	by Herbert Seidenberg	6	2,979
How do I only send 1 worksheet of a file in an e-mail? JeffL	by Luke M	1	510
I cannot use DIAS.LAB in my Excel (Spanish) User VB Excel[_2_]	by User VB Excel[_2_]	0	501
Weekending Function Tracey	by Tracey	5	1,209
count formula question mcook	by mcook	2	333
excel function help [email protected]	by Charles Williams	4	389
Advanced Filter dicko1	by Herbert Seidenberg	2	370
Date Range msguirt	by David Biddulph[_2_]	2	431
How do I bracket text in cells by formatting a whole column? tywlam	by Sheeloo[_5_]	3	871
function =IFERROR LOOKUP works in excel 2007 not in excel 2003 David Ryan	by Steve	4	2,018
Lookup Problem with Index and Match Mike B	by Mike B	3	412
Time Calculations jacsdad	by Bob Phillips[_3_]	2	343
style sheets vs cell formatting Exceluser1	by Exceluser1	0	422
How do I ADD characters to the data for a group of cells? PatPatt	by PatPatt	2	433
Vlookup Error Farooqi	by Ashish Mathur[_2_]	2	422
mean of range of dates leot	by Jarek Kujawa[_2_]	3	894
Highest Values Comparison Darren	by Mike H	4	539
Excel virus? NZuser	by NZuser	8	488
SUM depending on date Espen Rostad[_2_]	by Espen Rostad[_2_]	1	445
HOW TO I GET LOOKUP TO USE THE SAME RANGE EVERYTIME Colm	by Jacob Skaria	1	516
Count functions Jalal	by Jalal	4	354
Repeat Cell Based on the Value-Excel 2003 Elaine	by Stefi	3	1,190
External excel file for pulldown list source Alan Lindner	by Sheeloo[_5_]	2	1,112
Convert numbers to words wins007	by Bernd P	4	501
Symbols Crissy	by Ron Rosenfeld	8	714
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,576
Data Conversion - times, dates & rows Sara	by joel	5	387
percentage formula David Wilson[_2_]	by T. Valko	3	877
SUM, AVERAGE and PRINT with #N/A cells PaulinaDi	by T. Valko	11	893
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,965
Can't Prevent Recalculation [email protected]	by Charles Williams	4	438
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	392
I have lost the soft, blue borders of some cells. Gerald	by Gerald	6	6,365