Excel Worksheet Functions - Page 507

Thread / Thread Starter	Last Post	Replies	Views
How to find the largest product of an array of values? ryesworld	by goober	3	775
Returning value of active cell Sergio	by ExcelBanter AI	3	7,499
Outlier analysis in excel - trimming means Shane Lindsay	by ExcelBanter AI	3	7,404
autocomplete in dropdown list in Excel as I begin typing Jason W	by ExcelBanter AI	3	7,223
how to use the active cell in an Excel formula EPMMGR06	by ExcelBanter AI	3	7,686
finding part of fole path sheila	by Biff	3	380
External Link Shows Formula Not Info nia	by Biff	3	856
changing values in speadsheet Roni	by Roni	3	480
creating a search model ajaffer	by DOR	3	437
Sum cells in excel if shaded David	by David Billigmeier	3	1,812
In descriptive statistics, what does the "confidence level" mean? Dora Smith	by ExcelBanter AI	3	7,706
"Calulate" appearing on Status Bar Clarence Crow	by Clarence Crow	3	437
Trying to match a text string to a data table, any suggestions? OCONUS	by Peo Sjoblom	3	1,268
Create a dialog box Raza	by Bob Phillips	3	348
Storing Formulas to Use NEWB	by vezerid	3	450
conditional formating - wildcards Terry	by Terry	3	661
add month to date oomyoo	by oomyoo	3	566
vlookup and offset Rob M.	by Max	3	602
How do I set conditional formatting to interface with other cells? Oscar	by Bob Phillips	3	620
Count Names NOT #N/A Dax Arroway	by ExcelBanter AI	3	7,408
Function to concatenate cells in a range Leporello	by ExcelBanter AI	3	7,428
What does this formula mean [$-F400]h:mm:ssAM/PM Glenn	by ExcelBanter AI	3	7,681
how do I convert date format yyyymmdd to mm/dd/yyyy Datahead	by ExcelBanter AI	3	7,750
rolling 12 month date filter for pivot table? Randy Suggs	by ExcelBanter AI	3	7,487
Insert Page Number in a cell Iffi	by ExcelBanter AI	3	7,815
How to set up countdown timer to countdown days to a specific day Jenny	by ExcelBanter AI	3	7,508
creating tabs with sub tabs Murrell54	by ExcelBanter AI	3	8,158
How do I remove extra space when text wrapping? chosen-girl[_2_]	by ExcelBanter AI	3	8,218
Deleting values less than 100 PointerMan	by ExcelBanter AI	3	7,788
Help with IF systemx	by Bob Phillips	3	309
Calculating Average Length of Service EasyPeasy	by ExcelBanter AI	3	7,500
if cell falls within range of number (i.e. 2500 to 4999) Susan	by ExcelBanter AI	3	7,269
Grading Multiple Choice Exam Jay Windley	by ExcelBanter AI	3	7,908
why are my worksheet autosum totals one cent off? allan	by ExcelBanter AI	3	7,563
PEARSON versus CORREL Stan Brown	by ExcelBanter AI	3	7,230
Excel - stop automatically changing mixture of uppercase and lowercase to propercase Harry Flashman	by ExcelBanter AI	3	7,274
Ranking by multiple Criteria Zaphod117	by ExcelBanter AI	3	7,349
return a character at a certain position in a string of text Miranda	by ExcelBanter AI	3	7,603
Formula Convert Digits to Words (1000 write One thousand) Excel	by David McRitchie	3	2,125
Data falls in a range +/-1 SMac	by Bernard Liengme	3	676
Cell Formula or Cell Input Rick	by Ron Coderre	3	777
in formulas how can I use contents of a cell? Soo	by Bob Phillips	3	359
Excel Function weller	by SteveG	3	479
how to do i use a function if cells contain grades A B C f print. fabien	by David McRitchie	3	656
What formula captures specified rows of data? Brian G Scully	by DOR	3	439
Formula ABSOLUTE with INDIRECT - Is Fill Down Possible? Sam via OfficeKB.com	by Sam via OfficeKB.com	3	742
CAN YOU PUT MULTIPLE % BRAKE DOWNS IN 1 CELL Duck	by Gord Dibben	3	373
I need a formmula to gives a % split for dif. $ amounts Duck	by Bob Phillips	3	349
Summing if several conditions apply [email protected]	by Eddie O	3	542
="Printed " & today() Paul B	by ForSale	3	445
How to create a drop down menu for objects DORI	by Max	3	1,076
Conditional Formatting Mon	by SteveG	3	443
Adding Worksheet To Formula roy.okinawa	by roy.okinawa	3	493
auto insert invoice number that increases by one each time opened Michael HPSC	by Michael HPSC	3	1,996
Round a number to the Nearest .25 Dave E	by ExcelBanter AI	3	7,384
How do I conditionally delete rows based on cell contents? John Chan	by ExcelBanter AI	3	7,269
Editing text after concatenate Fozeye	by ExcelBanter AI	3	7,498
Correct coding entry of VBA macros in Excel worksheet Jack R	by Bob Phillips	3	448
Drop Down Lists - Not allowing other contents to be put in same ce Gary	by Debra Dalgleish	3	763
copy formula using same references macsworks	by Dana DeLouis	3	626
conditional formatting:highlight row based on blank or non-blank c Nat Maxwell	by ExcelBanter AI	3	7,349
How do I COUNTIF in excel using multiple criteria? DJ_Swammi	by DJ_Swammi	3	945
Leaing to the next full number? S33N	by S33N	3	337
How can I relate more than 7 cells with IF(... pirat2104	by Vito	3	458
how to split data from 1 row into two rows continuously monkeytrader	by Kleev	3	1,991
Minif / Maxif ? Thrain	by Bob Phillips	3	571
Using Symbols in Drop Down Lists Sumeet Benawra	by ExcelBanter AI	3	8,088
Countif? or Vlookup? Lost?? leo	by John Michl	3	529
look up function and sum values mike	by emrobertson	3	920
Where's it gone? Dave Moore	by Dave Moore	3	352
extract decimal place digit craig_100	by craig_100	3	539
Array Reference anar_baku	by vezerid	3	330
Minimum but One?? twogoodtwo	by twogoodtwo	3	671
test if column isblank Spike	by Gary''s Student	3	438
True or False Krish	by Ashish Mathur	3	647