Excel Worksheet Functions - Page 101

Thread / Thread Starter	Last Post	Replies	Views
COUNTIFS AND CRITERIA Eagle amongst turkeys	by David Biddulph[_2_]	3	1,098
Dropdown lists using each value only once bcbrown7	by bcbrown7	3	1,059
Update tab function Ivone	by Ivone	2	378
If then Statements in Excel Kyle	by Eva	4	579
Percentiles in Excel Jon J	by Lance	3	812
trying to get sheet 1 to recognize and move student names to pg 2 vaughn01	by Gord Dibben	1	404
split one column to multiple columns Greg	by L. Howard Kittle	4	1,018
Tab key problem in Microsoft Office Excel 2003 SFG	by Gord Dibben	3	1,068
Append values and remove text PurpleMilk	by PurpleMilk	2	443
Assign Macro to a Cell Bob Myers	by ryguy7272	2	2,811
summing results of multiple vloopups dawnecia	by Peo Sjoblom[_3_]	1	518
VLOOKUP over three spreadsheets Ksean	by Eva	8	486
format a range dependant on another cell JeremyC.	by ryguy7272	2	464
Cell referencing Beginner-Bob	by David Biddulph[_2_]	1	297
Vlookup Change in Reference Cell Lai	by Jacob Skaria	1	488
First Day of the Month Jen_T	by Ron Rosenfeld	2	426
How to format cell to get first capital letter? Patrick Znaty	by Ron Rosenfeld	5	2,421
RANK Function Terry Bennett	by Mike S.	6	1,704
2 Macros 1 Buttom Sudipta Sen[_2_]	by Don Guillett	2	368
create defined name using variable file name in reference hala	by OtÃ¡vio Alves Ribeiro	3	1,246
Logical value in time formula? geebee2k	by David Biddulph[_2_]	4	556
countif(Range,criteria) question David	by Stefi	1	498
Named Range that uses "relative" range - Possible? Johnny_99	by Charles Williams	5	544
descending order of a series of data kent[_2_]	by Kent	8	554
Pop-up box Phil	by Phil	2	489
Find variable unique text within a string Roger	by T. Valko	5	545
Array PAL	by Harlan Grove[_2_]	5	891
Keeping links Static caldog	by Harlan Grove[_2_]	4	411
Adding or to previously provided Average If Array function Diddy	by Harlan Grove[_2_]	4	431
Formatting a formula Alex	by Alex	5	505
Printing Only Rows With Values In Them robzrob	by robzrob	2	485
Vlookup with part match Rob	by T. Valko	5	934
Nesting if functions Louja	by Mike H	2	415
Excel Excle	by Teethless mama	4	603
Formula Based on Multiple Sheets Neil M	by Neil M	5	514
Termination within number of days Aging Termination Dates	by Ms-Exl-Learner	6	446
Use RANDBETWEEN form & include certain #'s in the range texas7186	by Joe User[_2_]	15	2,023
complex formula Debi	by OtÃ¡vio Alves Ribeiro	1	534
How can print A Id badge From a Excell Work Sheet sbaby	by Otto Moehrbach[_2_]	3	612
How do I keep the "tab" key from jumping over adjacent cell Srobinson2	by Gord Dibben	4	499
Question About Date Function Abradaxis	by Gord Dibben	4	526
A complex formula, help needed Mac	by Rick Rothstein	2	445
Count non-hidden rows Art	by Jacob Skaria	5	2,796
table lookup engineer	by engineer	3	489
Conversions in Exel John415	by Mike H	1	414
function help for counting text as a value.... Kris M	by David Biddulph[_2_]	1	402
Count if function Bhalchandra	by Bhalchandra	0	370
LOOKUP value in a table and return value in first column of same r Eric_G	by Eric_G	2	576
how do I make "NOW" function static chineshg	by Tom Hutchins	2	1,619
Using SUMIF with dates yowzers	by T. Valko	12	826
Sum amounts based on date field MikeK	by MikeK	6	780
Print Range not connected Tami	by Tom Hutchins	1	458
CONVERT(number,from_unit,to_unit) TKS_Mark	by Fred Smith[_4_]	3	381
Formula, Pivot Table, ??? Beats me Scott A[_2_]	by Scott A[_2_]	2	320
how do I highlight rows based on conditional formatting Honkus	by T. Valko	1	803
Macro for multiple rows sbaby	by sbaby	3	1,312
How to get rid of #Value when multiplying erika rock	by Peo Sjoblom[_3_]	1	2,709
Settign a Maximum and Minimum Row Height Stephen	by Rick Rothstein	1	1,043
Print just the list after performing a "find all" in Excel Office Minion	by Office Minion	0	418
shared workbook issue Brendan Quirk	by Brendan Quirk	0	462
Check for NON-presence of a string in another string G.P.N.L. c.v.a.	by Rick Rothstein	4	637
Subtotal level buttons easton	by easton	0	551
INDEX and MATCH PPL	by T. Valko	3	469
MedianIf multiple range and criteria C.	by T. Valko	5	1,744
Subtotals (outline) features grayed out Rubystarx	by Kelly Gates	2	4,161
Formula to return data using hyperlink? Mohamed	by Mike H	2	503
Lookup and Display Multiple Unique values based on criteria MPI Planner[_2_]	by MPI Planner[_2_]	2	1,482
Excel 2007 HeatherJ	by David Biddulph[_2_]	5	412
Subtraction Function using cells with other functions in them modemers	by Paul C	2	854
3 tier incentive matrix w/ infinite possibilities jjones	by Pete_UK	7	592
Monthly files dimitry scharff	by dimitry scharff	2	475
remove duplicates except blanks jat	by Jacob Skaria	2	1,078
Can conditional formatting be used where ..... Gotroots	by Ms-Exl-Learner	3	425
vlookup based on a different cell Scott A[_2_]	by Pete_UK	3	387
SUM A SINGLE TEXT FROM CELLS INTO ONE BigCarol	by David Biddulph[_2_]	1	551