Excel Worksheet Functions - Page 948

Thread / Thread Starter	Last Post	Replies	Views
Hide (limit viewers) to column(s) on a protected worksheet. RAINCITY.1788	by Henrik	1	404
sequential numbering of copies printed brian	by Jay	2	531
Making Array Formula, please assist! Macinslaw	by Biff	3	461
Limit on number of conditions? Amy F.	by Amy F.	3	308
Using Auto Filter Stealy Dan 1	by Debra Dalgleish	3	502
Pivot Sort ??? Eric	by Eric	4	628
reformat columns to rows? RickyDee	by CLR	1	364
Text size in validation drop-down list box Jon	by Biff	1	860
Cell Fomula Ninfa	by Peo Sjoblom	3	372
Blank field formatted as date Emily8	by Dave Peterson	5	666
If correct, add 1 sparky3883	by BenjieLop	2	467
Removing a FIXED Function Amy Sandlin	by Peo Sjoblom	1	363
Can I email a single sheet in a workbook? mjdbus00	by Ron de Bruin	1	936
How to select cells (located in a column) for formulas in a row automatically? Dmitry Kopnichev	by Herbert Seidenberg	3	477
Excel expression {=SUm(if(istext(c8:k8),1,0))} Mike	by Mike	2	576
How can I use a circular function to add 4 to a column of cells? Tricia	by Niek Otten	3	439
need to calculate time multiplied scheins	by Niek Otten	6	349
Custom number format - Accounting [email protected]	by [email protected]	0	1,021
Converting decimals into hh:mm Shandy720	by Arvi Laanemets	4	671
How do I change numbers from positive to negitive Debi	by comotoman	2	658
Drop data from workbook after specified time yardcow	by Ian	1	426
List Box Multi Select Option ann_nyc	by ann_nyc	0	774
grouping and give colours cjjoo	by David McRitchie	6	487
How do I concactinate two columns of digits? OMKP	by Duke Carey	2	477
Formula chooser? JKG	by JKG	3	411
In Excel allow freeze pane in any column plus any row vlado	by Dave Peterson	1	1,718
assign value to text shellie	by Bob Phillips	1	406
Excel - matching data Peter	by Peter	2	451
Schedule/Date Calculation lkoyne	by Ron Rosenfeld	3	340
How can I do a lowess fit in Excel? Klara	by Klara	3	1,271
Conditional Formatting & Dynamic Range james	by james	2	1,528
Lookup Functions nick	by nick	3	488
Can I search the whole workbook and not just a sheet? Kitty	by Ron de Bruin	2	561
Unique Value without using FILTER Amit Dhawan	by Ron Rosenfeld	3	702
Calculating the maximum value in a range of cells in a closed work Barb Reinhardt	by Barb Reinhardt	1	481
auto row insert Tsurphr	by Tsurphr	0	617
Copying a column to a new sheet so that cells match. Nadeem	by Nadeem	0	653
Mulitplie workbooks - known duplicate records - need to consolidat triniti	by triniti	2	364
Multiple protections GuyB	by GuyB	2	353
Sumproduct? cjjoo	by Sandy Mann	9	775
Compare Side by Side with 3 simulatanous sheets scrolling John Louis	by John Louis	0	651
Date entry gone haywire in Excel! umtraveller	by Paul B	3	396
return a range of cells from a vertical lookup vickyb_au	by Alvin	2	613
Defined Named cells lined to a Function Procedure swiftcode	by swiftcode	4	474
Countif function for instances of text string contained Garbunkel	by Paul Sheppard	1	823
Calculate difference (mins) between 2 Times Max	by Max	6	680
.csv file - excel 2003 giddne	by giddne	2	368
INT Function Dan (WA)	by Dan (WA)	6	359
sumproduct , array or countif? cjjoo	by duane	5	587
Wroking with rounded or trunc calculation Wendy - Payroll	by Wendy - Payroll	3	725
another sumproduct question cjjoo	by duane	1	556
Return a cell value based on specific combinations of cells in an array rmcnam05	by Ashish Mathur	2	1,287
Excel should be able to map which cells reference each other. URCHE	by Peo Sjoblom	1	1,122
How do I keep the zeros in front of numbers when i split a cell tom	by Ashish Mathur	3	960
Drop down to diplay info from another sheet debinnj	by Alvin	4	722
Countif a small or capital letter hodkd	by RagDyer	5	1,078
Lookup Hi / Lo chrisabberton	by Domenic	8	321
Excel 2003 links are not updating between workbooks Tami C	by Max	3	1,365
LOOKUP question DJ	by DJ	5	427
Index/Match question Need help! Brian H	by Brian H	5	575
Help, how to find a range of data? jub366	by RagDyer	3	410
Scrolling Cells William Kim	by Alok	1	956
Conditional formula - language needed gamebird	by Aladin Akyurek	7	937
Average Grades and drop the lowest score Kahlan	by Kahlan	0	661
Equal to or less than formula Angie	by Bob Phillips	3	580
What is the syntax for the IF formula in Excel? Christina	by Richard Buttrey	5	420
How do I use a range of numbers in an if statement? pbeattie	by Richard Buttrey	2	1,210
"Cannot empty Clipboard" tiff	by tiff	0	1,415
How do I "show pages" in pivot tables in Excel 2002 simon	by Debra Dalgleish	1	644
Countif function for instances of text string contained David Billigmeier	by David Billigmeier	2	1,326
Getting a running total? Tami	by Tami	0	602
calculate using rolling calendar Martha	by Bob Phillips	1	747
How do I share data in different worksheets? Debbie L.	by Debbie L.	4	613
Please help! morrison	by musicbox.4	2	329
Distributing values from rows to columns for Access import Petterq	by Petterq	2	768