Excel Worksheet Functions - Page 153

Thread / Thread Starter	Last Post	Replies	Views
Formula referring to a dynamic range in a different workbook mr tom	by mr tom	6	590
Total last 30 days Eric	by Eric	6	3,525
user defined function ub	by Dave F	6	718
Text formula Eva	by Eva	6	346
Adding numerical values based on multiple values in another column Kazmaniac	by Harlan Grove[_2_]	6	1,126
Need help in forcing number that wants to stay in Sci. Notation fo Phil	by Phil	6	383
Guess my number game for kids. Honey	by Honey	6	2,143
Wildcard and Sumproduct kd	by David McRitchie	6	506
vlookup and dates! KneeDown2Up	by Stefi	6	791
Enable Command Button base on UserName Doctorjones_md	by doctorjones_md[_2_]	6	584
How do I round a formula generated number texasdutch	by Susan	6	533
How to format cells Chris Cornell[_2_]	by David Biddulph[_2_]	6	397
What formula can i use to add time? lili	by Sandy Mann	6	373
How can I calculate daily hours worked minus lunch to eual a decim lili	by lili	6	1,814
Disable X button on excel pano	by Mike	6	3,365
Sum Function with Error values [email protected]	by Jerry W. Lewis	6	393
Excel IF, AND, OR ?'s Randy Tingley	by Ron Coderre	6	571
Need Help: highlight all the same strings in one cell Cheng	by Don Guillett	6	353
show result of sum when summed cells are blank Sarah (OGI)	by Roger Govier	6	428
Formula to give date and time Angela1979	by BoniM	6	544
Counting occurrences on a particular date smore	by Teethless mama	6	729
EXTRACTING UNIQUE RECORD BASED ON CONDITION SSJ	by T. Valko	6	637
Separating a List onto multiple worksheets in the same workbook based off 1 criteria DMRbaxter	by Barb Reinhardt	6	496
Formatting in a Protected Spreadsheet Ang	by Harlan Grove[_2_]	6	765
can I have excel count occurrences for 10 people in 7 days grebnet	by grebnet	6	1,042
help about date & month function in Excel FOUAD	by Joel	6	351
Sumif NeedHelpFast	by NeedHelpFast	6	329
Sumif vs Text? Ken	by Ken	6	658
Conditional Rank (or rather, Conditional Range) [email protected]	by [email protected]	6	1,343
IF and VLOOKUP - how efficient? anthonyg	by Aladin Akyurek	6	905
choose a product from a drop down list i need it to insert a price Barnzy	by Barnzy	6	652
IF(FIND Formula gives #VALUE! error XR6T4GC	by XR6T4GC	6	1,346
Nesting IF/calculate percentage JN	by joeu2004	6	965
OFFSET() not working within a SUMPRODUCT() when refering to a range in a pivot table Conan Kelly	by Conan Kelly	6	996
Present value and future value Ted Metro	by joeu2004	6	1,184
counting cells by text color alberto	by alberto	6	562
How to number lines (rows) on both sides of spreadsheet crb.e4xplor	by JLatham	6	2,844
Too Many Variables Heliocracy	by Bob Phillips	6	500
Excel If/Then's [email protected]	by Dave F	6	700
sort excel worksheet Per	by Gord Dibben	6	470
functions bkk	by David Biddulph[_2_]	6	396
Array Formula Question IPerlovsky	by [email protected]	6	501
Active cell as a reference to open a worksheet LaDdIe	by Gord Dibben	6	702
Multiple Criterion in a SUMIF function IPerlovsky	by IPerlovsky	6	845
Validation Rule anomaly Bob	by Toppers	6	588
Conditional Format Wendy7	by Wendy7	6	470
Interesting Formula Problem Michael Laferriere	by Roger Govier	6	724
Test for string across multiple cells/sheets... further questions [email protected]	by Lori	6	954
text conditional formating hannatrip	by hannatrip	6	565
Formula that works like text-to-column linglc	by linglc	6	748
Counting Mark	by Mark	6	384
Inventory Macro Help sheed3k	by sheed3k	6	639
How to return data? KUKA Guy	by KUKA Guy	6	488
Macro to move files gets an error if it already exists... [email protected]	by Dave Peterson	6	1,458
Average for Grade Param	by Param	6	808
LOOKUP function yielding a #N/A result MsBeverlee	by MsBeverlee	6	706
Items in drop-down list alphabetized andy62	by T. Valko	6	708
add extra space before comma clarknv	by clarknv	6	911
help with the macro or with the formula Igneshwara reddy[_2_]	by David Biddulph[_2_]	6	491
vlookup for mutiple rows mithu	by mithu	6	655
Data Validation Jean	by Ron Coderre	6	349
SUMPRODUCT not recognising dates Del[_2_]	by Dave Breitenbach	6	909
Lookup with offset Mike K	by RagDyeR	6	636
How to run this macro [email protected]	by [email protected]	6	396
Save several copies of the same worksheet ayeshasid	by Ron de Bruin	6	413
Sumproduct with nested sum sahafi	by Max	6	794
How do I convert a list of date of births into age in Excel? Frieda	by manjunath	6	752
ToC for sheets? Zilla[_2_]	by Harlan Grove[_2_]	6	478
If total answer is over default of 160 then 160, otherwise the formula i have works great! [email protected]	by Pete_UK	6	381
Time array Richard	by Richard	6	407
Using Exact() with VLookup or Match mikelee101	by T. Valko	6	819
Count If ? Anita	by Don Guillett	6	381
Wrap text in merged cells Lena_Office	by Greg Wilson	6	872
Randomly Select Records Critzy	by Max	6	1,327
Conditional function with count anamarie30	by Teethless mama	6	763