Excel Worksheet Functions - Page 145

Thread / Thread Starter	Last Post	Replies	Views
How do I use the concatenate function to add a date into a sentenc Ken Janowitz	by John Michl	6	682
Query Sumit	by Arvi Laanemets	6	318
Complicated Vlookup/count problem swjtx	by swjtx	6	726
Looking up information based on Columns and Rows Sally J	by Sally J	6	616
need to count/average if... Need Help 123	by Need Help 123	6	635
conditional data validation RickS	by RickS	6	881
EXCEL.SUM OF DIFFERENT COLUMS AND LINES ON DIFFERENT SHEET REPEAT mark d davis	by Ron Coderre	6	1,122
Excel Help nate.lyon	by nate.lyon	6	274
Data Validation John	by John	6	458
Value Return Frick	by rsenn	6	406
IIF issue Scott	by Herbert Seidenberg	6	473
Countif on multiple dates Jim	by JE McGimpsey	6	598
Match function David	by David	6	455
Count Characters sjs	by sjs	6	673
If Statements - Multiple formulae Ms MIS	by Kleev	6	444
What does this function do =+IF(ISERR(F27/G27),0,F27/G27) Trying To Excel	by Trying To Excel	6	937
Using the "IF" function? Ruff	by Bob Phillips	6	603
Instead of a negative number, I'd like to show zero... Dr. Darrell	by Ron Rosenfeld	6	2,695
Dynamic External Workbook reference Co-op Bank	by Roger Govier	6	837
Anyway to put logic into a single countif, sumif etc? BlueWolverine	by Zack Barresse	6	1,713
HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE des-sa	by des-sa[_2_]	6	2,873
Function Equivalent need ytayta555	by ytayta555	6	539
countif two columns two criteria Doris[_2_]	by Doris	6	490
How to set the value to zero if it negative after the substract TSK	by TSK	6	900
How to determine the values? Eric	by Lori	6	611
Adding days to a date cell to get a new date Pete Derkowski	by Rick Rothstein \(MVP - VB\)[_368_]	6	907
Formating cells Adrian	by Adrian	6	379
showing numbers as percentages MELCHAUV	by T. Valko	6	406
Sum Problem requiring help NoodNutt	by Spiky	6	582
=COUNTIF across Worksheets Trevor Shuttleworth	by Trevor Shuttleworth	6	730
Vlookup and #N/A error hrsdias	by Patti	6	995
How do I highlight a cell using conditional formatting and dates shane561	by Max	6	982
totalizer formula KARIM	by Gord Dibben	6	693
Duplicate rows forever... Namras	by Namras	6	532
use of "if" based on text in another column Gary D.	by Rikki Ward	6	409
martrix help memotronic	by Pete	6	427
lookup? list data into summary table Joe	by Ron Coderre	6	555
HOW DO YOU INSERT A MACRO INTO A FORMULA blopreste3180	by William Horton	6	595
meaning of this function afdmello	by afdmello	6	1,364
VLOOKUP? [email protected]	by vezerid	6	343
Is there a "rank" like feature for alpha? jshrader	by bpeltzer	6	583
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row Sam via OfficeKB.com	by Sam via OfficeKB.com	6	1,789
How do I pull a random sample of people from a list in excel? PM	by Alan	6	2,364
formula help Titanium	by Titanium	6	444
adding a ' ie 'xxxx instead of xxxx cclambie	by cclambie	6	651
Help With Formula roy.okinawa	by Dave Peterson	6	538
Employee Rate % Myrna	by Myrna	6	550
Increment column by column from data row by row Jonah	by Jonah	6	562
Cube root? Scott	by Charles Andrews	6	441
How many rows have I selected ? Paul Ho	by Bob Phillips	6	1,284
Nested Formula MichaelS	by Biff	6	643
linked worksheet formulas Laura Wild	by Biff	6	409
Variable Links to tabsheets Alberto Pinto	by Max	6	400
DROP DOWN LISTS eternal_cat via OfficeKB.com	by Gord Dibben	6	605
Using a 'Select' (Data Validation) List? [email protected]	by [email protected]	6	822
I don't Understand elusiverunner	by elusiverunner	6	538
vlookup gives me a #N/A dave	by Dave Peterson	6	456
average if, multiple if, divide if 0-0 Wai Wai ^-^	by Jerry W. Lewis	6	884
cannot use ISEVEN or ISODD functions in Conditional Formatting Scott Paine	by Scott Paine	6	1,885
Sorting rows to a another sheet Dataminer	by Dataminer	6	641
Sumproduct to ignore text and "" Ricky Pang	by Ricky Pang	6	2,582
Tricky 'Find Maximum' problem seeks formula tx12345	by Biff	6	998
Count Mondays worked in Month harnagel	by Bob Phillips	6	434
RATIO number format Jane	by Jane	6	1,485
Advancing Down A List Minitman	by Max	6	545
input mask in excel Osama Mira	by Mark	6	1,261
how many if statements are allowed per cell? DallasM	by Linda	6	429
Formula using 2 points of reference to return a value from a table MrvinGover	by Biff	6	715
"IF" formula returns zero or other incorrect number Pat K.	by Pat K.	6	1,167
Filling Text from Another File lost in charts	by lost in charts	6	924
Opposite of Concatenate shane24	by Ron Rosenfeld	6	1,550
Date Command to Get the Sunday Before the First of the Month Minitman	by Minitman	6	1,662
How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only? Wesley Accellent	by Bernie Deitrick	6	4,347
Countif and hidden rows. andyw	by Bob Phillips	6	1,629
Longest string in a column Jeff Kantner	by Biff	6	1,171