Excel Worksheet Functions - Page 730

Thread / Thread Starter	Last Post	Replies	Views
if statement [email protected]	by Dave	1	316
Sumif with two criterias gibz	by gibz	3	650
Using "xxx" in an array formula man4mac	by a7n9	7	449
The Row Height Autofit command does not work. rstrefry	by Gord Dibben	4	1,194
How do I link 4 columns to each other B's Space	by Gord Dibben	5	322
This is kinda urgent. Need help with matrix stuff. Betts	by a7n9	1	301
Adding Worksheet Lisa	by Jim Thomlinson	3	429
Cannot autosum after import DavidB	by Gord Dibben	3	552
How to count the number of Excel cells with text formatted Italic phausman	by phausman	3	2,254
Cut &paste clears numbers after the decimal point SLUred	by SLUred	0	846
Complicated work! Any idea?? craig@help	by craig@help	0	597
Real time in worksheet Andri	by Andri	0	515
Formula Assistance Please yukon_phil	by yukon_phil	8	550
how do I automatically jump to the present date in a roster? awvanheerde	by Toppers	3	435
Remove Specific Text - HELP! LastHair	by LastHair	6	567
About Data Table & Scenario Manager. JOBY JOHN NEERIYANKAL	by JOBY JOHN NEERIYANKAL	0	472
nper function calculation bigfella	by Tushar Mehta	5	583
=LOOKUP(MONTH) SS	by SS	3	638
SUMIF - counting across different spreadsheets JoFo	by JoFo	2	620
Conditional Formatting Cheryl	by Toppers	1	464
items disappearing from pivot dropdown when not selected confused	by confused	1	564
How do I copy and paste a formula I create to subtotals only? octoberskyy	by octoberskyy	0	555
Simple If formula but can't get my head around it! Cheryl	by Cheryl	3	488
Need Formula HELP Sandi	by Sandi	5	338
Finding current week and if any item has somthing due Robert Brown	by Robert Brown	2	522
3 logical condition if statement Mikehughes	by Mikehughes	3	749
INDIRECT.EXT Help Required Mike McLellan	by Danny Lewis	6	775
PIVOT LEARNER - Field Entry billy_bags	by Dave Peterson	1	412
Double Clicking on link w/i workbook does't bring me to souce. tfranc	by tfranc	2	550
Creating a complicated formula Cheryl	by Cheryl	3	576
enter item code in one column, automatically get description in ne Shelley Kingston	by Vikky	2	1,136
Simple AND formula digital21st	by digital21st	5	469
Stamp Duty Mr Stanley (UK)	by Mr Stanley (UK)	4	1,710
dynamic summary table confused	by Toppers	1	528
If formula - got myself confused! JoFo	by JoFo	5	496
How to copy a row with transposing to a column retaining links to input cells? Dmitry	by Dmitry	2	571
Formula Mike	by Dav	1	364
Comparing and sum'ing data danuk2006	by danuk2006	3	376
Selecting Multiple Results JAD	by Toppers	2	475
Why does a simple frequency distribution count out of range data? [email protected]	by Harlan Grove	3	1,043
Column of Text Shown = Total Times Shown? philcassell	by philcassell	3	906
Needing Help Very Bad Mike	by Toppers	6	456
Counting Values Barb Miles	by Biff	3	448
Can I set up where Employee types name and computer records time? gator	by davesexcel	1	458
How I can set all cell in the worksheet rounddown automatically? Poh Yong	by Poh Yong	0	401
[Pivot Table] Add Value Sphenix	by Sphenix	0	667
Converting Getpivotdata function in Excel '03 to Excel '00?? MK	by FPL	4	911
Copy worksheet to another worksheet and the date is plus 1 day. Steved	by Steved	0	646
Compare two cells and return certain value in third cell hurairah	by hurairah	3	2,130
Excel performance calculation JE McGimpsey	by George	3	630
Formula Assistance Please lorig_2000	by lorig_2000	0	557
Setup Purchase Order Template to have a automatic number system? LynnB	by LynnB	2	1,878
Currency vs. Accounting Format zippy	by zippy	0	1,533
I have to change a bunch of formula that need to reference a different workbook. Marc	by Marc	5	775
Help needed Gary	by CLR	5	523
Complex Date Formula kermitforney	by Ron Rosenfeld	2	469
How do I calculate times each word occurs in a column of cells? MTSusce	by RagDyeR	3	1,632
Split a Cell? inveni0	by RagDyeR	6	763
highlighting problem in excel bookkeeperiam	by Gord Dibben	1	459
Linking dates to different workbook, then data. Drew	by Drew	0	563
Extract Date from Right Formula [email protected]	by daddylonglegs	3	433
Workday calculation - not working LOK	by Ron Rosenfeld	5	1,192
Holiday Planner show holiday taken? Mac5	by Mac5	0	1,081
Data validation Henk	by Karen	5	568
HELP: can no longer open protected file in XP [email protected]	by [email protected]	0	510
NOW() and SECOND() not refreshing tgmjf	by tgmjf	2	514
How do I round off times in Excel? Andrew	by Biff	5	643
Workbook Create Date fx clowns	by clowns	0	406
Restricted value sequences in rows yukon_phil	by vezerid	11	927
How do I get a value returned when I require 2 criteria to be met yukon_phil	by yukon_phil	3	412
How Do I format Background pictures? David Marinez	by David Marinez	4	712
Moving Data Clueless	by Clueless	0	353
help with formula Brian	by Gord Dibben	5	364
A formula for monthly tracking? Jlabbe	by VBA Noob	1	417
Relative references for condtional formatting within a Pivot Table Matt X	by Matt X	0	672