Excel Worksheet Functions - Page 633

Thread / Thread Starter	Last Post	Replies	Views
time around midnight Mai-Britt	by bj	2	741
remove records when fields match in 2 worksheets?? [email protected]	by [email protected]	6	915
Index and Match Formula!!!!!! klafert	by klafert	0	427
which function can get the desired result? ADK	by David Biddulph[_2_]	3	614
how can I get a corresponding T-score for a P-value in excel? DQ	by ryguy7272	2	3,050
Early Login, Last Logout junoon	by Duke Carey	3	1,223
Formula Problem roxiemayfield	by roxiemayfield	2	377
Application hang with array sum(sumif... formula klubar	by Roger Govier	7	790
can I do a drop down with a calander in it ekkeindoha	by Duke Carey	2	381
Workbook Calculations set to Automatic - Excel 2007 qualitywoodworking	by qualitywoodworking	2	1,077
i think i need count function help monkeytrader	by Peo Sjoblom	1	517
Split table into smaller tables & into different worksheets each Pradeep	by Pradeep	8	3,258
max reference cooresponding cell Andy	by Andy	4	457
Referencing Filtered Cells Jorge	by Jorge	2	750
Formulae againstallodds1606	by JE McGimpsey	2	406
Sync Worksheets in Different Workbooks FP Novice	by Dave Peterson	1	2,012
Last Cell Info Ed Davis	by Ed Davis	11	824
excel 2007 formulas Anvil22	by Anvil22	6	581
how do i sum if in two different cell references - Excel blake7	by Toppers	1	459
HOW TO SUM ALL 1 YR OLDS, SUM ALL 2 YR OLDS FROM a LIST OF DOB's fairly new to excel	by Teethless mama	2	377
How can I get around 30 argument limit of SUM function? Randy	by T. Valko	4	2,110
linking worksheets SociologyStudent	by T. Valko	9	533
In a formula how can I reference the outline level of a row? Dana DeLuca	by Bob Umlas, Excel MVP	1	3,967
Schedule Randomizer LOU	by LOU	1	1,439
conditional formatting consecutive cells chris	by chris	7	1,001
Data Validation on blank cells LOU	by Peo Sjoblom	1	601
Hyperlink does not adjust or move as rows are added and deleted harvey	by Dave Peterson	2	1,247
how to formulate this simple n easy? driller	by driller	0	389
How to copy the same formulas in a spreadsheet -Macro? klafert	by Gord Dibben	3	759
=EVALUATE("{ to work in a range of cells Fin Fang Foom	by Fin Fang Foom	8	454
#Name? error message Andy	by Andy	6	399
Counting # of occurances of words in text Mike G	by Mike G	11	625
occurance in each year Anvil22	by Fred Smith	8	543
Vlookup not working Tbram	by Max	3	546
One function away! Andy	by JMB	3	378
Counting Unique Vales in a column frankjh19701	by T. Valko	4	473
Using "if" function to translate 100 scale into 4.0 scale Robert McN	by Ragdyer	2	6,382
How do i add in a last updated function for a series of cells? Tab	by pshepard	4	489
How to Automatically transfer specific Data from Sheet 1 to Sheet Jman	by Jman	12	2,645
is there any way of using a function for loan emi calculation? Ritu[_2_]	by pshepard	1	576
How do I reformat fractions that are expressed in smaller font? cwalton	by David Biddulph[_2_]	1	1,557
How do I calculate the root of a number using Excel? Arthur Yeager	by David Biddulph	4	1,562
Matrix Inverse Rosina	by Toppers	2	516
Excel Look Up Tables - Make The Table Dynamic? Ben Bruce	by Arvi Laanemets	5	703
Conditional Formating Problam and question? Jman	by Toppers	3	429
salary adjustment due to inflation,,how to ?? driller	by Toppers	1	1,444
Object error with Group & Ungroup in Excel Denis J.	by Denis J.	0	636
Insert Row and Corresponding Unique Worksheet David	by Joel	5	335
Sum Function with wrong total shown TDLambert	by Dana DeLouis	2	640
How do I update worksheet 1 from data on worksheet 2 JR	by Denis J.[_2_]	2	479
Check boxes Min	by Dave Peterson	3	336
justification Treva B	by David Biddulph[_2_]	2	460
Macro Conditional Formatting Sandy	by Sandy	2	772
Macros for checkboxes Min	by Toppers	16	987
Is there a formula that can spot duplicate reference des's Michaela	by Sebation.G[_2_]	2	485
Macro Question carl	by carl	0	357
Macro looping endlessly Sandy	by JE McGimpsey	6	475
excel seafarer	by Gord Dibben	2	331
Italic Naz	by Beege	1	329
If function - Jock	by Jock	4	414
I want to create an A5 size invoice and print 2 copies A4 sheet Libran19	by Libran19	2	1,825
Replacing all references to a file, with a new file name. Lots!! phil	by PCLIVE	1	440
# of iterations Rick	by [email protected]	1	521
combining information from several sheets into one sheet [email protected]	by Ron de Bruin	1	320
Select the most recent date dbs	by Don Guillett	4	1,214
auto format cell to enter data alphabet in column dee	by Gary''s Student	1	721
how do i use contains in an if statement Pondering	by Teethless mama	4	972
Conditional Formatting (for cells containing specific term) Matt	by David Biddulph[_2_]	7	745
format based on date Lori	by Lori	0	339
use value not formula in IF statement Soz	by CLR	2	903
SUMIF With Variable Consecutive Days Peanut	by Peanut	6	1,039
Copy Paste to another sheet SallyGirl	by SallyGirl	2	347
Need to convert Outlook Journal Duration to a number JRO Mtn Group	by David Biddulph[_2_]	3	1,114
How to locate the first digit in a cell, explained [email protected]	by T. Valko	7	611
How do I create comment boxes that appear when a cell is clicked? pickpj	by Debra Dalgleish	2	1,257