Excel Worksheet Functions - Page 24

Thread / Thread Starter	Last Post	Replies	Views
Formula for showing items per minute PoppaButch	by David Biddulph[_2_]	1	3,926
Using wildcard characters in find & replace Tola	by bala_vb	4	3,924
Conditional Formatting Based on Question Mark (NOT used aswildcard) [email protected]	by T. Valko	8	3,924
Inserting Multiple Rows with Formulas ShineboxNJ	by Dave Peterson	2	3,923
Auto insert sheetname into chart title? Ian R[_3_]	by Bob Ryan	5	3,922
rolling year attendance J Parrott	by J Parrott[_2_]	2	3,922
Using an offset formula for the reference in a relative reference Cuda	by Cuda	6	3,921
Pivot table treating numbers as text in value field Rune Wentzel Helms	by Rune Wentzel Helms	2	3,920
Using countif on non-consecutive cells Marty	by T. Valko	6	3,919
Alphanumeric custom formats May47	by Gord Dibben	3	3,917
Need a Formula for Multiplication of Feet and Inches vmohan1978	by vmohan1978	6	3,916
.CSV file format - comma or semi-colon antifashionpimp	by Bernie Deitrick	1	3,915
Find volatile cells hmm	by Charles Williams	3	3,915
how do i copy the result of a formula into another worksheet as te RaeRae	by Gord Dibben	4	3,914
how to split date and time in one cell into multiple cells Dr. Bill	by Glenn	6	3,913
Can I use a Reference inside a SUMIF or COUNTIF Function? Albie	by Glyn[_2_]	11	3,912
Check if Conditional Format is True or False / Check cell Color Kevin McCartney	by Kevin McCartney	5	3,912
if=0 then n/a if<0 leave the value in the cell Hoofnagle	by Teethless mama	2	3,911
Autosum returns 0 value on data sheet EricB	by Roger Govier	13	3,911
The clear filter from a a heading cell is grey out Mark	by Mark	2	3,909
Macro to clear checkboxes Guy[_2_]	by Guy[_2_]	5	3,909
the cell currently being evaluated contains a constant Barrie Wells	by Niek Otten	2	3,908
How do I insert a symbol as part of a formula Rhonda	by Lori	9	3,908
Convert e+ e- to number Elisabeth	by Kevin Vaughn	2	3,908
Ensure that all numbers are 8 digits long DianeG	by Pete_UK	4	3,905
Count Unique Values in 1 Column based on Date Range in another Column Brian	by Brian	14	3,903
Very Basic Problem - Merged Cell Equals Contents of a Single Cell jollynicechap	by jollynicechap	3	3,902
Formula to convert/transpose columns to rows (and vice versa) markx	by markx	5	3,902
Choose highest value duplicate mr tom	by mr tom	6	3,902
I need a productif style function Mitch	by Toppers	4	3,900
Calculating Patch Tuesday PM	by PM	6	3,899
test for upper case MusicMan	by David Biddulph[_2_]	6	3,899
Problem formatting pivot table headers Goalie35	by KD	3	3,897
Formula to calculate the difference in weeks between two dates IGG	by Mike H	3	3,896
copy formula to filtered cells only Picman	by Picman	4	3,893
splitting cells diagonally and filling with color yooper	by Nils Ejlertsson	5	3,891
Matching data in one column to another excel idiot	by David Jessop	1	3,891
function like INDIRECT to return a range? Wilba	by Wilba	4	3,886
count days from a one date to another date confused!!	by David Biddulph[_2_]	11	3,884
Excluding subtotals from SUMIF function Graeme	by Ron Coderre	5	3,883
How do I calculate pro-rata formulas? dukes	by [email protected]	3	3,883
Calculate Follow-Up Dates - Please help ASAP jewelzeyes	by Bernie Deitrick	1	3,880
unexpected file lock by user Chethan	by Jacob Skaria	1	3,879
Lookup a Canada postal code in a range of values excellsi	by Fred Smith[_4_]	2	3,879
sum product if r2rcode	by vinayp	3	3,878
Convert bytes to kilobytes or megabytes? Toney	by [email protected]	5	3,877
cannot copy in excel by dragging a cell Niliesh	by Luke M	2	3,874
VLOOKUP to return Cell Address Steve Haack	by T. Valko	3	3,872
if statement based on "starts with " Todd F.	by Todd F.	4	3,870
job costing worksheet leapyrgrl	by CLR	4	3,868
IF - Date falls between two dates, place here Driftwood	by Roger Govier[_8_]	3	3,864
How do I set up sub-headings in Excel? travel junkie	by Gord Dibben	1	3,859
Average of Years employed SGee	by T. Valko	5	3,858
There should be a keyboard shortcut for fill color in excel Jerry	by Annie	1	3,854
Manual Trend lines [email protected]	by Bernard Liengme	1	3,854
Day Number For 365 Day Year Jim J.	by Jim J.	4	3,854
why is the INDIRECT function volatile? Dave F	by Dave F	2	3,853
Excel autofit row height not working Josafa	by Josafa	0	3,853
Is it possible? DakotaNJ	by Gord Dibben	25	3,852
INDIRECT reference to another worksheet in same workbook Johan	by Johan	4	3,850
How can I sort SSNs in Terminal Digit Order using Excel? postitnote	by RagDyer	19	3,850
how to activate controls in protected sheet Novice	by Novice	2	3,849
Is there a formula to figure mortgage APR in excel? Toby	by [email protected]	6	3,849
Small Function Unique Values Basketball	by T. Valko	6	3,848
How can I add up letters or symbols in excel Terry	by Steve	3	3,847
summing an array of cells absolute value JohnJack	by exceltrader	4	3,847
SUMIF on a Calculated Field Trevor Aiston[_2_]	by Shane Devenshire[_2_]	3	3,845
=SUM returns 5.54365E-11 instead of 0 (zero) Chwan Keng Ng	by Stan Brown	6	3,843
SumIf across columns instead of rows Heather	by David Biddulph[_2_]	3	3,841
columns stop at IV rosebud3377	by Chip Pearson	2	3,840
How to multiply hours by a dollar amount Teri	by RagDyer	3	3,835
convert one column into many columns Ajay	by bj	7	3,833
Why won't my formulas work until I save the worksheet? gwwillits	by Peo Sjoblom	3	3,833
Find First Non blank cell than find column header and return that value Silver Rose	by T. Valko	10	3,829
My Find and Replace function in Excel is not working? BPeach	by John	2	3,829