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	384
sequential numbering of copies printed brian	by Jay	2	513
Making Array Formula, please assist! Macinslaw	by Biff	3	438
Limit on number of conditions? Amy F.	by Amy F.	3	293
Using Auto Filter Stealy Dan 1	by Debra Dalgleish	3	492
Pivot Sort ??? Eric	by Eric	4	612
reformat columns to rows? RickyDee	by CLR	1	344
Text size in validation drop-down list box Jon	by Biff	1	843
Cell Fomula Ninfa	by Peo Sjoblom	3	351
Blank field formatted as date Emily8	by Dave Peterson	5	620
If correct, add 1 sparky3883	by BenjieLop	2	456
Removing a FIXED Function Amy Sandlin	by Peo Sjoblom	1	346
Can I email a single sheet in a workbook? mjdbus00	by Ron de Bruin	1	911
How to select cells (located in a column) for formulas in a row automatically? Dmitry Kopnichev	by Herbert Seidenberg	3	455
Excel expression {=SUm(if(istext(c8:k8),1,0))} Mike	by Mike	2	545
How can I use a circular function to add 4 to a column of cells? Tricia	by Niek Otten	3	425
need to calculate time multiplied scheins	by Niek Otten	6	337
Custom number format - Accounting [email protected]	by [email protected]	0	974
Converting decimals into hh:mm Shandy720	by Arvi Laanemets	4	653
How do I change numbers from positive to negitive Debi	by comotoman	2	638
Drop data from workbook after specified time yardcow	by Ian	1	405
List Box Multi Select Option ann_nyc	by ann_nyc	0	713
grouping and give colours cjjoo	by David McRitchie	6	483
How do I concactinate two columns of digits? OMKP	by Duke Carey	2	465
Formula chooser? JKG	by JKG	3	400
In Excel allow freeze pane in any column plus any row vlado	by Dave Peterson	1	1,676
assign value to text shellie	by Bob Phillips	1	399
Excel - matching data Peter	by Peter	2	438
Schedule/Date Calculation lkoyne	by Ron Rosenfeld	3	330
How can I do a lowess fit in Excel? Klara	by Klara	3	1,259
Conditional Formatting & Dynamic Range james	by james	2	1,501
Lookup Functions nick	by nick	3	475
Can I search the whole workbook and not just a sheet? Kitty	by Ron de Bruin	2	538
Unique Value without using FILTER Amit Dhawan	by Ron Rosenfeld	3	679
Calculating the maximum value in a range of cells in a closed work Barb Reinhardt	by Barb Reinhardt	1	456
auto row insert Tsurphr	by Tsurphr	0	582
Copying a column to a new sheet so that cells match. Nadeem	by Nadeem	0	624
Mulitplie workbooks - known duplicate records - need to consolidat triniti	by triniti	2	349
Multiple protections GuyB	by GuyB	2	342
Sumproduct? cjjoo	by Sandy Mann	9	732
Compare Side by Side with 3 simulatanous sheets scrolling John Louis	by John Louis	0	630
Date entry gone haywire in Excel! umtraveller	by Paul B	3	382
return a range of cells from a vertical lookup vickyb_au	by Alvin	2	590
Defined Named cells lined to a Function Procedure swiftcode	by swiftcode	4	456
Countif function for instances of text string contained Garbunkel	by Paul Sheppard	1	805
Calculate difference (mins) between 2 Times Max	by Max	6	656
.csv file - excel 2003 giddne	by giddne	2	321
INT Function Dan (WA)	by Dan (WA)	6	349
sumproduct , array or countif? cjjoo	by duane	5	571
Wroking with rounded or trunc calculation Wendy - Payroll	by Wendy - Payroll	3	709
another sumproduct question cjjoo	by duane	1	544
Return a cell value based on specific combinations of cells in an array rmcnam05	by Ashish Mathur	2	1,269
Excel should be able to map which cells reference each other. URCHE	by Peo Sjoblom	1	1,104
How do I keep the zeros in front of numbers when i split a cell tom	by Ashish Mathur	3	942
Drop down to diplay info from another sheet debinnj	by Alvin	4	707
Countif a small or capital letter hodkd	by RagDyer	5	1,059
Lookup Hi / Lo chrisabberton	by Domenic	8	310
Excel 2003 links are not updating between workbooks Tami C	by Max	3	1,319
LOOKUP question DJ	by DJ	5	415
Index/Match question Need help! Brian H	by Brian H	5	562
Help, how to find a range of data? jub366	by RagDyer	3	389
Scrolling Cells William Kim	by Alok	1	953
Conditional formula - language needed gamebird	by Aladin Akyurek	7	900
Average Grades and drop the lowest score Kahlan	by Kahlan	0	637
Equal to or less than formula Angie	by Bob Phillips	3	566
What is the syntax for the IF formula in Excel? Christina	by Richard Buttrey	5	406
How do I use a range of numbers in an if statement? pbeattie	by Richard Buttrey	2	1,179
"Cannot empty Clipboard" tiff	by tiff	0	1,349
How do I "show pages" in pivot tables in Excel 2002 simon	by Debra Dalgleish	1	617
Countif function for instances of text string contained David Billigmeier	by David Billigmeier	2	1,291
Getting a running total? Tami	by Tami	0	576
calculate using rolling calendar Martha	by Bob Phillips	1	729
How do I share data in different worksheets? Debbie L.	by Debbie L.	4	589
Please help! morrison	by musicbox.4	2	318
Distributing values from rows to columns for Access import Petterq	by Petterq	2	744