Excel Worksheet Functions - Page 900

Thread / Thread Starter	Last Post	Replies	Views
#DIV/0! Kati	by ShaneDevenshire	4	559
How do I summarize total hours over multiple days DavidT	by ShaneDevenshire	5	993
Time Calculations over a week Sara	by ShaneDevenshire	5	673
Can I make all worksheets in a workbook alike at once? jmsdvdp	by Ragdyer	3	778
Nested IF Jo	by Peo Sjoblom	2	413
SUMIF cells in Column B are blank Josh Hendrickson	by Max	9	1,328
remove or adding spacing [email protected]	by Max	2	498
Offset function [email protected]	by [email protected]	5	591
or(Exact) - problem markholt	by T. Valko	2	1,451
IFs and ORs DavidT	by Ron Rosenfeld	8	599
keyboard shortcut entee	by ShaneDevenshire	3	454
Calculating hours between 35 and 40 Nucera	by ShaneDevenshire	3	621
Search for a value that repeats several times in another table RobertoB	by ShaneDevenshire	3	419
SUMPRODUCT Steven	by Steven	2	461
How to substitute whole word with different designated letters? [email protected]	by Max	4	1,106
I need a cell (to show Mar-09) it automatically goes to Mar-08 Nat	by Max	3	422
Sumif w/Text conversion on a range of cells WRH	by T. Valko	5	752
Substitute letters by others in a word [email protected]	by Ron Rosenfeld	4	648
Autofilter in protected worksheets JL	by JL	0	466
Decimal places Tricia	by Ashish Mathur[_2_]	2	586
Blank Cells Again Josh Hendrickson[_2_]	by Ashish Mathur[_2_]	4	377
Sumproduct and ISTEXT? Sandy	by Harlan Grove	4	1,421
Updating Sum Total Yossy	by Sheeloo[_3_]	1	442
CALCULATE GST AMOUNT FROM AMOUNT IN OTHER CELL Cruisie Suzie	by Max	1	2,453
Excel compare names chesjak	by chesjak	4	763
Wildcards in SUMPRODUCT Terry Bennett	by Terry Bennett	3	520
Excel Database or Access?? Centrol	by Bob Phillips[_3_]	1	527
Excel Macro Centrol	by Bob Phillips[_3_]	2	416
Cell number replacement red	by Mike H	3	411
How do I combine 50 spreadsheets into 1 workbook with 50 sheets [email protected]	by Barb Reinhardt	1	737
Evaluate on multiple columns and return a value CynthiaF	by CynthiaF	5	1,274
how can i set up rand or rand between to give only -1 or 1? Uesiet	by David Biddulph[_2_]	8	846
formula Louise[_2_]	by Louise[_2_]	9	496
Excel cash book: formula to duplicate amt in relevant exp column quilta	by Pete_UK	1	1,499
Excel - when make cell bold some txt disappears NikkiO	by ShaneDevenshire	3	2,016
Pivot Table Excel 2003 & Excel 2007 Heera	by Heera	3	546
1900 vs 1904 date functions Mary Lou	by ShaneDevenshire	1	1,094
COUNTIF with Dates SRL	by ShaneDevenshire	3	1,301
Counting steps in a scale DirkG	by David Biddulph[_2_]	4	535
If, Or function or macro to compare 3 columns of numbers AuthorizedUserPF	by AuthorizedUserPF	3	1,672
advanced filter dialog box, "List Range" list two ranges? Excel_Kiwi	by Peo Sjoblom[_2_]	1	573
COUNTIF by date range problem LoriB	by LoriB	12	860
Format part of text in concatenated field jday	by Gord Dibben	4	977
create multiple worksheets from cells in one worksheet Kathy	by Gord Dibben	4	1,522
Writing a rule in excel... I think BVZ	by Gord Dibben	5	1,180
Data in excel wont autosum Frusterated	by Glenn	2	601
Default Number Jodie	by Gary''s Student	1	480
Year-over-year percentage of change lstreet	by Glenn	3	4,246
Difference in needed and delivered time with workdays only Prema	by Glenn	8	739
Changing font colour depending on cell value RunRonnyRun	by Alan Moseley	1	580
Sumif date=date red	by T. Valko	3	400
HyperLinkDumbIam NotGood@All	by Dave Peterson	2	360
time difference Linda	by Peo Sjoblom[_2_]	5	427
How can I bolden H8 in the formula =(I8)&UPPER(H8)&CHAR(10)&B8? tonyanj	by David Biddulph[_2_]	1	404
conditional formula DiazFamily	by Sheeloo[_3_]	1	443
Returning 0 instead of #N/A when no value is found RobertSD	by Dave Peterson	8	1,282
SumIf - when I fill down the Range, Criteria & sum range changes markholt	by Sheeloo[_3_]	3	1,837
Add-in analysis gm66	by Gord Dibben	5	499
Bonus/Absence/Timesheet workbook help needed. klg	by Herbert Seidenberg[_3_]	6	557
how do i require text in a cell how to make a cell require text	by Peo Sjoblom	4	434
Seperating hyperlink address from viewable text Aominay	by EXCEL HELP	5	574
compare 2 tables of dates to find the preceding dates Babi	by Max	3	1,064
automatically insert salary based on job title [email protected]	by ShaneDevenshire	2	768
Help Please! CountIf Function using 2 criteria? AlexisLovesLife	by ShaneDevenshire	4	483
logical formula mike	by ShaneDevenshire	2	453
run macro after paste K	by K	3	2,946
How to find out how long it's been since a link updated GuinnessT	by Gary''s Student	1	652
VLookUp - Does the VLookUp return the exact information? Cpviv	by Cpviv	2	1,510
Diplaying results of a formula instead of the formula itself DirtyBadger	by Mike H	1	412
How do you connect worksheets,input data in one place&it shows on excel	by Max	2	1,113
Month as a value DaveKid	by Ron Rosenfeld	1	363
Excell Sue Parsons	by Roger Govier[_3_]	6	397
how to move data from single to multible collums in excel Don	by Roger Govier[_3_]	2	456
Function for getting cell ID and the last row with value [email protected]	by Roger Govier[_3_]	2	544
Can you perform calculations w/ cells that have both numbers and t BWP	by Max	5	511