Excel Worksheet Functions - Page 194

Thread / Thread Starter	Last Post	Replies	Views
MedianIf multiple range and criteria C.	by T. Valko	5	1,837
Concatenate Cells peterh	by ryguy7272	5	681
If or conditional formatting? Twiggy	by Twiggy	5	518
Driving an address LiAD	by Pete_UK	5	383
How to format cell to get first capital letter? Patrick Znaty	by Ron Rosenfeld	5	2,473
Named Range that uses "relative" range - Possible? Johnny_99	by Charles Williams	5	579
Array PAL	by Harlan Grove[_2_]	5	915
Formatting a formula Alex	by Alex	5	599
Formula Based on Multiple Sheets Neil M	by Neil M	5	548
Count non-hidden rows Art	by Jacob Skaria	5	2,868
Formula Problem cherman	by T. Valko	5	533
Vlookup with part match Rob	by T. Valko	5	963
Adding if to Average If Array function Diddy	by Diddy	5	722
Find variable unique text within a string Roger	by T. Valko	5	599
Excel 2007 HeatherJ	by David Biddulph[_2_]	5	480
Concatenate LWilson	by LWilson	5	627
Counting Individuals NOT Occurrences with than one criteria Royegg	by Royegg	5	483
remove blanks using formula Gotroots	by Gotroots	5	1,491
Changing formating Kimti	by David Biddulph[_2_]	5	431
Can anyone answer this question? Frustrated	by Ron Rosenfeld	5	493
adding numbers in a column with dates piklelila	by trip_to_tokyo[_3_]	5	494
SUM cells in column based upon criteria in two others. JT	by JT	5	858
Averageif year=2000 MitzDriver	by Teethless mama	5	5,486
formula for excel sheet. BVG	by David Biddulph[_2_]	5	600
Literal based on Week end Umar	by T. Valko	5	541
help with datedif function please bill gras	by T. Valko	5	662
Sumproduct usage? Destrachan	by Ashish Mathur[_2_]	5	550
Complex 2 table formula JD	by JD	5	510
how do I get a function formula cell to format as a number? Kristin	by T. Valko	5	589
addding/omitting "x" tleehh	by David Biddulph[_2_]	5	420
Date and Formatting Ray	by David Biddulph[_2_]	5	588
is 3rd character in a cell a space? Rick[_10_]	by Rick[_10_]	5	676
#VALUE! in cell datub	by David Biddulph[_2_]	5	562
Preventing hyperlinks and vlookups from breaking jane	by Pete_UK	5	915
Average cyclic error Kent	by kent[_2_]	5	547
I want to save a copy of a wksht. but without any of the formulas ms_gebhart	by Pete_UK	5	730
Decimal Sky[_2_]	by Joe User[_2_]	5	356
How can I do this ?? Eric_in_EVV[_2_]	by Max	5	508
modified vlookup help tjb	by David Biddulph[_2_]	5	555
Can I use AVERAGEIFS? JRD	by Joe User[_2_]	5	776
Comparing text strings Comparing columns with text	by Rick Rothstein	5	905
Counting with conditions based on another range stephanie	by Pete_UK	5	500
Text Box with conditional formula Keyrookie	by MRT	5	627
formula to add a number to a long string ** MMangen	by minyeh	5	500
Display file name without the file type extension NAHolmes	by ryguy7272	5	3,682
using row number or column letters in formula Chris	by Chris	5	751
SUMPRODUCT John	by John	5	391
Sumproduct or ????? John	by David Biddulph[_2_]	5	453
help with date formula Victoria	by Ron Rosenfeld	5	398
Sumifs (I think) Jeff	by Jeff	5	457
How to count with values from multiple columns? PF	by Jacob Skaria	5	1,651
Price Comparison formula TJC	by JBoulton	5	2,224
Can cells be split ? Steve	by Otto Moehrbach[_2_]	5	497
Converting 0 values to Blanks kepetersen3405	by minyeh	5	1,521
Range with 2 validations Freshman	by Herbert Seidenberg	5	616
Max Cell Value Saskatoon Jerry	by T. Valko	5	509
how to use a function to average all the numbers except 8 in a col dreamer	by T. Valko	5	1,870
a quick way of inserting and naming multiple worksheets in Excel? Sue[_4_]	by Gord Dibben	5	3,177
How to delete all duplicate records - without keeping one of them Aviva B	by Ashish Mathur[_2_]	5	610
CountIf in Even Rows only Otto Moehrbach[_2_]	by Bob Reynolds	5	695
Help with suming muliple columns Natalie	by Ashish Mathur[_2_]	5	426
Counting occurences with multiple entries Chuckles	by Ashish Mathur[_2_]	5	479
Stripe out duplicate data Gotroots	by Bob Phillips[_4_]	5	400
COUNTIF with or + and variables Dancest˜†r	by Jacob Skaria	5	636
Complex function needed? JRD	by Lars-Åke Aspelin[_2_]	5	430
Finding the 3 best values Santafe	by Santafe	5	523
Multiple If Then Statement based on ranges Multiple If, Then statements	by T. Valko	5	2,332
Stripping out characters Stephanie	by Ron Rosenfeld	5	373
how to attach file vmohan1978	by T. Valko	5	495
Copying formulas in Columns and transpose to rows? Terri	by Gord Dibben	5	2,081
Macro to Clean Special characters for a Range Satish[_2_]	by Satish[_2_]	5	5,681
Return result when condition is met Gotroots	by Gotroots	5	424
trying to use Indirect function Eric_in_EVV[_2_]	by T. Valko	5	766
count number of weeks missing for each individual in a database pumpkin	by David Biddulph[_2_]	5	624
Room Occupied Checker Formula Help Dax Arroway	by Dax Arroway	5	588