Excel Worksheet Functions - Page 284

Thread / Thread Starter	Last Post	Replies	Views
Changing font colour depending on cell value RunRonnyRun	by Alan Moseley	1	595
Difference in needed and delivered time with workdays only Prema	by Glenn	8	750
Year-over-year percentage of change lstreet	by Glenn	3	4,258
Default Number Jodie	by Gary''s Student	1	486
Data in excel wont autosum Frusterated	by Glenn	2	631
Writing a rule in excel... I think BVZ	by Gord Dibben	5	1,187
create multiple worksheets from cells in one worksheet Kathy	by Gord Dibben	4	1,532
Format part of text in concatenated field jday	by Gord Dibben	4	1,005
COUNTIF by date range problem LoriB	by LoriB	12	875
advanced filter dialog box, "List Range" list two ranges? Excel_Kiwi	by Peo Sjoblom[_2_]	1	587
If, Or function or macro to compare 3 columns of numbers AuthorizedUserPF	by AuthorizedUserPF	3	1,688
Counting steps in a scale DirkG	by David Biddulph[_2_]	4	549
COUNTIF with Dates SRL	by ShaneDevenshire	3	1,307
1900 vs 1904 date functions Mary Lou	by ShaneDevenshire	1	1,120
Pivot Table Excel 2003 & Excel 2007 Heera	by Heera	3	579
Excel - when make cell bold some txt disappears NikkiO	by ShaneDevenshire	3	2,067
Excel cash book: formula to duplicate amt in relevant exp column quilta	by Pete_UK	1	1,510
formula Louise[_2_]	by Louise[_2_]	9	506
how can i set up rand or rand between to give only -1 or 1? Uesiet	by David Biddulph[_2_]	8	869
Evaluate on multiple columns and return a value CynthiaF	by CynthiaF	5	1,300
How do I combine 50 spreadsheets into 1 workbook with 50 sheets [email protected]	by Barb Reinhardt	1	754
Cell number replacement red	by Mike H	3	422
Excel Macro Centrol	by Bob Phillips[_3_]	2	428
Excel Database or Access?? Centrol	by Bob Phillips[_3_]	1	541
Wildcards in SUMPRODUCT Terry Bennett	by Terry Bennett	3	538
Excel compare names chesjak	by chesjak	4	777
CALCULATE GST AMOUNT FROM AMOUNT IN OTHER CELL Cruisie Suzie	by Max	1	2,470
Updating Sum Total Yossy	by Sheeloo[_3_]	1	448
Sumproduct and ISTEXT? Sandy	by Harlan Grove	4	1,461
Blank Cells Again Josh Hendrickson[_2_]	by Ashish Mathur[_2_]	4	385
Decimal places Tricia	by Ashish Mathur[_2_]	2	605
Autofilter in protected worksheets JL	by JL	0	473
Substitute letters by others in a word [email protected]	by Ron Rosenfeld	4	671
Sumif w/Text conversion on a range of cells WRH	by T. Valko	5	761
I need a cell (to show Mar-09) it automatically goes to Mar-08 Nat	by Max	3	428
How to substitute whole word with different designated letters? [email protected]	by Max	4	1,114
SUMPRODUCT Steven	by Steven	2	481
Search for a value that repeats several times in another table RobertoB	by ShaneDevenshire	3	425
Calculating hours between 35 and 40 Nucera	by ShaneDevenshire	3	629
keyboard shortcut entee	by ShaneDevenshire	3	471
IFs and ORs DavidT	by Ron Rosenfeld	8	603
or(Exact) - problem markholt	by T. Valko	2	1,453
Offset function [email protected]	by [email protected]	5	603
remove or adding spacing [email protected]	by Max	2	505
SUMIF cells in Column B are blank Josh Hendrickson	by Max	9	1,334
Nested IF Jo	by Peo Sjoblom	2	429
Can I make all worksheets in a workbook alike at once? jmsdvdp	by Ragdyer	3	783
Time Calculations over a week Sara	by ShaneDevenshire	5	687
How do I summarize total hours over multiple days DavidT	by ShaneDevenshire	5	1,007
#DIV/0! Kati	by ShaneDevenshire	4	588
Lookup MH	by ShaneDevenshire	4	526
How to MATCH or VLOOKUP & copy using 2 excel files Sandeep	by muddan madhu	3	1,468
Separate name and numbers SherryScrapDog	by T. Valko	6	824
Enter data into a cell that already has a function. alwayslearning	by Mike H	2	820
Autofilter in 2007 limits view in 2003 RFP330	by RFP330	4	885
Priority (with macro??) Alonso[_2_]	by Barb Reinhardt	4	615
applying a formula to an entire spreadsheet michelle	by Max	3	3,139
How do I enter a formula that will update as more rows are added? ChuckT12624	by Gord Dibben	3	890
( ) instead of - xlouisedoll	by Gord Dibben	4	346
Lookup + Max [email protected]	by T. Valko	9	550
Can't get any of my functions to run in Excel 2007 0to60	by CmK[_2_]	2	1,383
Minimun values in a list edwgolz	by Gord Dibben	14	838
on and off button to populate data in a excel dashboard Cryckett	by ShaneDevenshire	2	445
Formula for Dates Daren	by ShaneDevenshire	18	1,002
Transpose and Fill? susan	by Herbert Seidenberg	7	617
setting the default printer for this workbook only mikecoxffbb	by ShaneDevenshire	1	6,386
LOOKUP+IF+??? Connie Martin	by Pete_UK	6	445
Sum Vlookup / Match Formula across 8 workbooks kurt	by kurt	2	700
Help with IF function JKA	by Ashish Mathur[_2_]	3	424
increase a sheet full of numbers lpeterson	by Keith Faulconer	2	493
Need to copy data from 1 workbook to another based on an invoice # Patty C.	by JP[_4_]	3	499
partial word match for conditional formatting Maureen	by Spiky	9	5,283
counting totals based on certain criteria - Excel 2K tech1NJ	by tech1NJ	9	647
Reference a file by concatenating cell variables Michael	by Peo Sjoblom[_2_]	13	1,154
Need help for data mining johnnyk	by johnnyk	4	1,163