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	405
sequential numbering of copies printed brian	by Jay	2	546
Making Array Formula, please assist! Macinslaw	by Biff	3	471
Limit on number of conditions? Amy F.	by Amy F.	3	318
Using Auto Filter Stealy Dan 1	by Debra Dalgleish	3	515
Pivot Sort ??? Eric	by Eric	4	636
reformat columns to rows? RickyDee	by CLR	1	370
Text size in validation drop-down list box Jon	by Biff	1	870
Cell Fomula Ninfa	by Peo Sjoblom	3	372
Blank field formatted as date Emily8	by Dave Peterson	5	680
If correct, add 1 sparky3883	by BenjieLop	2	479
Removing a FIXED Function Amy Sandlin	by Peo Sjoblom	1	379
Can I email a single sheet in a workbook? mjdbus00	by Ron de Bruin	1	937
How to select cells (located in a column) for formulas in a row automatically? Dmitry Kopnichev	by Herbert Seidenberg	3	487
Excel expression {=SUm(if(istext(c8:k8),1,0))} Mike	by Mike	2	589
How can I use a circular function to add 4 to a column of cells? Tricia	by Niek Otten	3	454
need to calculate time multiplied scheins	by Niek Otten	6	355
Custom number format - Accounting [email protected]	by [email protected]	0	1,028
Converting decimals into hh:mm Shandy720	by Arvi Laanemets	4	682
How do I change numbers from positive to negitive Debi	by comotoman	2	661
Drop data from workbook after specified time yardcow	by Ian	1	429
List Box Multi Select Option ann_nyc	by ann_nyc	0	785
grouping and give colours cjjoo	by David McRitchie	6	492
How do I concactinate two columns of digits? OMKP	by Duke Carey	2	490
Formula chooser? JKG	by JKG	3	412
In Excel allow freeze pane in any column plus any row vlado	by Dave Peterson	1	1,720
assign value to text shellie	by Bob Phillips	1	419
Excel - matching data Peter	by Peter	2	464
Schedule/Date Calculation lkoyne	by Ron Rosenfeld	3	351
How can I do a lowess fit in Excel? Klara	by Klara	3	1,272
Conditional Formatting & Dynamic Range james	by james	2	1,543
Lookup Functions nick	by nick	3	498
Can I search the whole workbook and not just a sheet? Kitty	by Ron de Bruin	2	564
Unique Value without using FILTER Amit Dhawan	by Ron Rosenfeld	3	715
Calculating the maximum value in a range of cells in a closed work Barb Reinhardt	by Barb Reinhardt	1	493
auto row insert Tsurphr	by Tsurphr	0	618
Copying a column to a new sheet so that cells match. Nadeem	by Nadeem	0	656
Mulitplie workbooks - known duplicate records - need to consolidat triniti	by triniti	2	369
Multiple protections GuyB	by GuyB	2	357
Sumproduct? cjjoo	by Sandy Mann	9	779
Compare Side by Side with 3 simulatanous sheets scrolling John Louis	by John Louis	0	654
Date entry gone haywire in Excel! umtraveller	by Paul B	3	401
return a range of cells from a vertical lookup vickyb_au	by Alvin	2	623
Defined Named cells lined to a Function Procedure swiftcode	by swiftcode	4	487
Countif function for instances of text string contained Garbunkel	by Paul Sheppard	1	835
Calculate difference (mins) between 2 Times Max	by Max	6	683
.csv file - excel 2003 giddne	by giddne	2	368
INT Function Dan (WA)	by Dan (WA)	6	373
sumproduct , array or countif? cjjoo	by duane	5	600
Wroking with rounded or trunc calculation Wendy - Payroll	by Wendy - Payroll	3	739
another sumproduct question cjjoo	by duane	1	561
Return a cell value based on specific combinations of cells in an array rmcnam05	by Ashish Mathur	2	1,296
Excel should be able to map which cells reference each other. URCHE	by Peo Sjoblom	1	1,132
How do I keep the zeros in front of numbers when i split a cell tom	by Ashish Mathur	3	971
Drop down to diplay info from another sheet debinnj	by Alvin	4	724
Countif a small or capital letter hodkd	by RagDyer	5	1,078
Lookup Hi / Lo chrisabberton	by Domenic	8	322
Excel 2003 links are not updating between workbooks Tami C	by Max	3	1,373
LOOKUP question DJ	by DJ	5	431
Index/Match question Need help! Brian H	by Brian H	5	589
Help, how to find a range of data? jub366	by RagDyer	3	425
Scrolling Cells William Kim	by Alok	1	968
Conditional formula - language needed gamebird	by Aladin Akyurek	7	951
Average Grades and drop the lowest score Kahlan	by Kahlan	0	661
Equal to or less than formula Angie	by Bob Phillips	3	581
What is the syntax for the IF formula in Excel? Christina	by Richard Buttrey	5	426
How do I use a range of numbers in an if statement? pbeattie	by Richard Buttrey	2	1,222
"Cannot empty Clipboard" tiff	by tiff	0	1,424
How do I "show pages" in pivot tables in Excel 2002 simon	by Debra Dalgleish	1	654
Countif function for instances of text string contained David Billigmeier	by David Billigmeier	2	1,336
Getting a running total? Tami	by Tami	0	612
calculate using rolling calendar Martha	by Bob Phillips	1	755
How do I share data in different worksheets? Debbie L.	by Debbie L.	4	613
Please help! morrison	by musicbox.4	2	336
Distributing values from rows to columns for Access import Petterq	by Petterq	2	783