Excel Worksheet Functions - Page 284

Thread / Thread Starter	Last Post	Replies	Views
Changing font colour depending on cell value RunRonnyRun	by Alan Moseley	1	606
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,259
Default Number Jodie	by Gary''s Student	1	492
Data in excel wont autosum Frusterated	by Glenn	2	636
Writing a rule in excel... I think BVZ	by Gord Dibben	5	1,201
create multiple worksheets from cells in one worksheet Kathy	by Gord Dibben	4	1,535
Format part of text in concatenated field jday	by Gord Dibben	4	1,005
COUNTIF by date range problem LoriB	by LoriB	12	879
advanced filter dialog box, "List Range" list two ranges? Excel_Kiwi	by Peo Sjoblom[_2_]	1	597
If, Or function or macro to compare 3 columns of numbers AuthorizedUserPF	by AuthorizedUserPF	3	1,698
Counting steps in a scale DirkG	by David Biddulph[_2_]	4	562
COUNTIF with Dates SRL	by ShaneDevenshire	3	1,321
1900 vs 1904 date functions Mary Lou	by ShaneDevenshire	1	1,136
Pivot Table Excel 2003 & Excel 2007 Heera	by Heera	3	589
Excel - when make cell bold some txt disappears NikkiO	by ShaneDevenshire	3	2,076
Excel cash book: formula to duplicate amt in relevant exp column quilta	by Pete_UK	1	1,516
formula Louise[_2_]	by Louise[_2_]	9	508
how can i set up rand or rand between to give only -1 or 1? Uesiet	by David Biddulph[_2_]	8	877
Evaluate on multiple columns and return a value CynthiaF	by CynthiaF	5	1,312
How do I combine 50 spreadsheets into 1 workbook with 50 sheets [email protected]	by Barb Reinhardt	1	757
Cell number replacement red	by Mike H	3	430
Excel Macro Centrol	by Bob Phillips[_3_]	2	444
Excel Database or Access?? Centrol	by Bob Phillips[_3_]	1	555
Wildcards in SUMPRODUCT Terry Bennett	by Terry Bennett	3	538
Excel compare names chesjak	by chesjak	4	786
CALCULATE GST AMOUNT FROM AMOUNT IN OTHER CELL Cruisie Suzie	by Max	1	2,473
Updating Sum Total Yossy	by Sheeloo[_3_]	1	460
Sumproduct and ISTEXT? Sandy	by Harlan Grove	4	1,462
Blank Cells Again Josh Hendrickson[_2_]	by Ashish Mathur[_2_]	4	386
Decimal places Tricia	by Ashish Mathur[_2_]	2	609
Autofilter in protected worksheets JL	by JL	0	474
Substitute letters by others in a word [email protected]	by Ron Rosenfeld	4	672
Sumif w/Text conversion on a range of cells WRH	by T. Valko	5	774
I need a cell (to show Mar-09) it automatically goes to Mar-08 Nat	by Max	3	431
How to substitute whole word with different designated letters? [email protected]	by Max	4	1,117
SUMPRODUCT Steven	by Steven	2	490
Search for a value that repeats several times in another table RobertoB	by ShaneDevenshire	3	435
Calculating hours between 35 and 40 Nucera	by ShaneDevenshire	3	636
keyboard shortcut entee	by ShaneDevenshire	3	479
IFs and ORs DavidT	by Ron Rosenfeld	8	604
or(Exact) - problem markholt	by T. Valko	2	1,460
Offset function [email protected]	by [email protected]	5	615
remove or adding spacing [email protected]	by Max	2	515
SUMIF cells in Column B are blank Josh Hendrickson	by Max	9	1,337
Nested IF Jo	by Peo Sjoblom	2	439
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	692
How do I summarize total hours over multiple days DavidT	by ShaneDevenshire	5	1,023
#DIV/0! Kati	by ShaneDevenshire	4	603
Lookup MH	by ShaneDevenshire	4	527
How to MATCH or VLOOKUP & copy using 2 excel files Sandeep	by muddan madhu	3	1,482
Separate name and numbers SherryScrapDog	by T. Valko	6	837
Enter data into a cell that already has a function. alwayslearning	by Mike H	2	833
Autofilter in 2007 limits view in 2003 RFP330	by RFP330	4	885
Priority (with macro??) Alonso[_2_]	by Barb Reinhardt	4	620
applying a formula to an entire spreadsheet michelle	by Max	3	3,148
How do I enter a formula that will update as more rows are added? ChuckT12624	by Gord Dibben	3	900
( ) instead of - xlouisedoll	by Gord Dibben	4	359
Lookup + Max [email protected]	by T. Valko	9	551
Can't get any of my functions to run in Excel 2007 0to60	by CmK[_2_]	2	1,385
Minimun values in a list edwgolz	by Gord Dibben	14	850
on and off button to populate data in a excel dashboard Cryckett	by ShaneDevenshire	2	453
Formula for Dates Daren	by ShaneDevenshire	18	1,012
Transpose and Fill? susan	by Herbert Seidenberg	7	621
setting the default printer for this workbook only mikecoxffbb	by ShaneDevenshire	1	6,397
LOOKUP+IF+??? Connie Martin	by Pete_UK	6	450
Sum Vlookup / Match Formula across 8 workbooks kurt	by kurt	2	705
Help with IF function JKA	by Ashish Mathur[_2_]	3	435
increase a sheet full of numbers lpeterson	by Keith Faulconer	2	496
Need to copy data from 1 workbook to another based on an invoice # Patty C.	by JP[_4_]	3	508
partial word match for conditional formatting Maureen	by Spiky	9	5,288
counting totals based on certain criteria - Excel 2K tech1NJ	by tech1NJ	9	661
Reference a file by concatenating cell variables Michael	by Peo Sjoblom[_2_]	13	1,165
Need help for data mining johnnyk	by johnnyk	4	1,167