Excel Worksheet Functions - Page 516

Thread / Thread Starter	Last Post	Replies	Views
SUMIF function Steve 51	by Steve 51	0	321
Randomly sort a set group of integers Justin Peckner	by Bernd Plumhoff	3	640
How do I use VLOOKUP to find part of string? niatpac	by Peo Sjoblom	3	2,192
IF Clause dpal	by dpal	8	976
Shorten the Excel Sheet nabanco	by nabanco	7	3,478
Finding max and min in column mikebres	by mikebres	3	651
change "true" and "false" to "availble" and "out of stock" inthestands	by Peo Sjoblom	2	4,428
Cubesets LB[_2_]	by LB[_2_]	0	440
How do I delete everything after a / in a column? henderson	by Harlan Grove[_2_]	17	4,075
Error.Type or IsError to trap #VALUE! and #NUM! Ms. AEB	by Jim Cone	1	1,440
Automating data movement dhunter43	by dhunter43	0	428
Obi Wan Kenobi: You're My Only...HELP!!!!!! [email protected]	by JonOfAllTrades	5	672
My Problem - Help Please Launchnet via OfficeKB.com	by Launchnet via OfficeKB.com	10	987
interest only loan amortization schedule rldoan	by [email protected]	2	3,615
Freeze Function Results in Cells Tyler Shillig	by John Bundy	1	520
Matching 2 columns JJ44	by PCLIVE	3	620
Error Trying to add Calculated Items to a pivot table runsrealfast	by runsrealfast	0	888
Average Selected Cells From a Range pdberger	by Peo Sjoblom	3	1,326
How to set One value from Multiple Lookup Value Shibly	by Bob Phillips	3	584
AND, IF, and SUM IF Functions hotelmasters	by Peo Sjoblom	3	417
ROI formula Lucio	by pdberger	1	748
Excel Problem ID10T	by Harlan Grove[_2_]	3	334
How do a set a parameter in cell - choose A or B options? cara8236	by Peo Sjoblom	3	374
Excel Formulas Aravind	by Aravind	4	288
sheet tab Libby	by Libby	3	310
Data Validation SamIAm	by SamIAm	2	329
vlookup swati	by swati	3	272
compare a list of numbers Lucio	by Toppers	1	405
compare a list of numbers Lucio	by Max	2	394
Is there a way to make a link to a specific tab in excel? Carlee	by Send2Steph	6	732
IF, between two numbers ADK	by Bob Phillips	2	4,460
Counting Staffs Reports Greenwich_Man	by Bernard Liengme	1	413
Import data from 1 cell on 1 worksheet to othr cell(s) in another BCassedy	by Arvi Laanemets	1	353
count pieces of records meet conditions in different columns Amy	by Arvi Laanemets	1	521
Can the conditional format box be locked to the cell petite pied	by NickHK	1	362
Data Lost While Using a Shared Workbook WLP70	by WLP70	0	637
How do I add more than 30 arguments in a formula wilsocm	by T. Valko	5	1,169
Financial functions in excel Abhi	by Dave Thomas	1	690
How do I set up spreadsheet for breakdown costs &quotes kattrans	by kattrans	0	937
can no longer insert new columns & unhide hidden columns em2	by Dave Thomas	1	681
how do i keep a total down a column , ie. say start with julie	by JLatham	2	400
Getting more than one lookup results in array Alex	by T. Valko	6	700
Delete a Column when in a Macro-Worksheet Event? jeannie v	by jeannie v	2	796
How do you multiple, subtract and divide in the Excel program? Andrea	by SamIAm	3	568
How to count(if) column B IF column A says "x" ONJNo1	by Dave Thomas	16	987
counting x instances of a string across columns... [email protected]	by Ron Rosenfeld	9	623
Calculating to add years - including leap year MareskiCP	by Teethless mama	4	4,676
Importing Data Batmancd	by Batmancd	2	454
Categories & Drop down boxes Shawna	by beginner here	1	435
Comparing Text beginner here	by Sandy Mann	7	422
How can i make numbers have text format without insering ' at each Numbers into text format in excel	by Gord Dibben	3	394
How do I make cells subtract? Robert[_3_]	by Gord Dibben	3	712
Date Randy	by Gord Dibben	3	402
how to make value whole (remove decimal point) Roger	by Sandy Mann	1	4,677
help on averaging function ( 1 2) Treesy	by Harlan Grove[_4_]	41	4,638
Excel Function IF AND Indigo	by Indigo	19	1,101
Lookup help (I think) [email protected]	by Mike H	2	316
Need help please-SUMPRODUCT and Dynamic Range Tasha	by Tasha	11	1,227
How to assign a formula to a letter? Judy	by Arvi Laanemets	4	462
search for data matching some condition Michael Hahn	by Michael Hahn	2	485
sumproduct a whole column steve	by Bob Phillips	11	3,362
I, too, am having problems with SUMPRODUCT Leonhardtk	by [email protected]	5	437
again driller	by driller	8	446
Loan Amortization Schedule oscramx1l3sc4	by Dave Thomas	1	858
Get highest value and adjacent cell value Ardy	by Ardy	12	1,445
Do not paste in hidden cells GIORGOS	by Arun	9	4,419
Repeat title to top of each worksheet Starla	by Starla	4	1,358
Drag multiple fields into data of pivot table maplesugarsnow	by maplesugarsnow	0	1,201
Pivot Tables lehigh46	by Peo Sjoblom	1	394
VLOOKUP pfa	by pfa	0	299
How do I replace text within a formula with a diff cell value? Eric_G	by Peo Sjoblom	1	660
VLOOKUP and OFFSET PJ	by Mike H	2	597
Advanced filter dates and nulls JoHickey	by [email protected]	2	608
why can't i share my workbook Lanki	by Lanki	0	1,126
Cannot Refresh Pivot Tables Babs in Ohio	by Babs in Ohio	0	1,152