Excel Worksheet Functions - Page 526

Thread / Thread Starter	Last Post	Replies	Views
Locked Cell - can still edit philcud	by philcud	2	905
Help With Dynamic Range Big H	by Big H	2	378
Transposing Deena	by Anne Troy	2	556
INSERT HORIZONTAL PAGEBREAK AFTER EACH LINE IN ENTIRE WORKSHEET . KNPALIA	by Bernard Liengme	1	609
Quick Question Brian Hamilton	by Brian Hamilton	2	417
Quick help needed... BAW	by Otto Moehrbach	2	404
FirstName, LastName and vice versa Bob	by Biff	3	908
bottom sheet tab disappears kaistix	by Niek Otten	1	697
Adding +1 to a text Myriam	by Myriam	0	389
I need an Excel formula for converting hours to days? Sharon Tischner	by David Biddulph	4	1,461
Calculate with or without Symbol Karen	by David Biddulph	1	497
look up multiple values, to return only one value DP7	by Biff	7	1,056
Using the VLOOKUP Command Glen Disteafno	by Biff	2	547
Auto refresh [email protected]	by JMB	1	568
How create my own Funtion Alejandro Garcia	by Alejandro Garcia	7	581
text wrap kaye2681	by Gord Dibben	2	357
where is the search/replace command located docdon	by Gord Dibben	5	451
sum cells compare cells KenB	by Domenic	4	421
DSUM when database is part of a pivot table Carlos	by Carlos	0	573
Embedded Reference Heather	by Carlos	1	415
Can you make a tab entry form in excel like you can in word lmart	by KePaHa	1	832
Type set amount of digits in one cell then automatically move to n mulligbo	by Dave Peterson	2	619
Error 1324 during installation of addtional components Herbert Chan	by Dave Peterson	5	385
What is this symbol? Steve B	by Dave Peterson	11	935
A challenge: referencing cell contents in nested function formula Needs Assistance	by RagDyeR	3	559
Multiple if senerio RaY	by romelsb	6	492
IF formula question sssspro	by romelsb	6	590
show only the subtotals and grand total in a pivot table Wanna Learn	by Debra Dalgleish	3	3,789
Link "page-by" drop-down in two pivot tables [email protected]	by Debra Dalgleish	1	903
Sorting on a protected worksheet in Excel 2000 RS	by RS	0	507
Concatenate Problem aisos12	by Debra Dalgleish	2	519
I need to link check boxes to 3 different cells Jose M.	by Debra Dalgleish	1	810
APPROXIMATE SEARCH OF ANY ENTRY IN A COLUMN arun_bhilai	by JMB	1	421
Employee Time Sheet suntzu	by Biff	2	573
Modify a Macro Carl	by Bob Phillips	1	697
IF month and day match, then... RS	by RS	5	559
APR - RATE Function Jonathan Rigley	by Jonathan Rigley	2	1,172
Help - saving files MSL	by Ron de Bruin	1	482
Embedded Reference Heather	by Debra Dalgleish	2	539
EXcel 2007 - Unable to sort by font and cell colors Mr. Low	by Dave F	1	1,016
List in a cell Bob McCloskey	by Otto Moehrbach	1	386
How to caclulate porfolio returns over different time periods tfrentz	by tfrentz	6	393
analysis Joe	by Ron Coderre	1	390
Sudoku hints Rob	by Rob	3	1,048
Topic did not show up? Jason Sands	by Jason Sands	3	528
total schedules Joe	by Domenic	3	436
Outlining in nested subtotals not working Debi C	by Dave Peterson	1	468
In Excel fill & font colors not working Novusvir	by Novusvir	2	2,148
how do i get to top of excel page it seems to be missing Shattered and confused	by RagDyeR	10	853
2 Workbooks and 6 Worksheets - Need to Populate 1 Workbook MichelleS	by Roger Govier	15	1,826
CELL ( ) Epinn	by Ron Coderre	3	431
Custom Cell Formatting tom	by tom	4	591
Formula Help Curtis	by Curtis	0	390
CHAR(10) = ALT+ENTER?? Epinn	by [email protected]	13	1,134
PivotTable - Where have the units/records gone? Epinn	by Epinn	8	824
can excell convert a file from 'works'? ed leard	by Ken Wright	1	375
I have a master spreadsheet, how do I create a copy? Kat	by Ken Wright	2	459
SUMIF - Sum_Range is misleading Epinn	by Leo Heuser	3	577
Formatting columns with either a date OR a numerical figure Terry Winter	by Ken Wright	1	353
Move curser to specific cell when closing Richard	by Gary''s Student	1	398
excel vlookup not working correctly Steve	by Ken Wright	3	1,202
Make merged cells a feature that can be used in a shared workbook The Happy Helper	by Ken Wright	2	559
table data Joe	by Herbert Seidenberg	2	308
Calculate date 28 days from now if hours reduce watty	by watty	2	722
SUM and IF statements Bob	by Ron Coderre	5	391
Pivotable Columns Jim Pockmire	by Debra Dalgleish	1	375
Convert a range to a 2sequence of numbers? Christine	by Christine	10	755
formula needed for this one... ozwunder321	by Ron Rosenfeld	2	350
change the calendar to reflect the current year pippinkitty	by pippinkitty	0	422
change the calendar to reflect the current year pippinkitty	by Niek Otten	1	427
Text vs Number format Curtis	by Bob Phillips	1	354
Sumproduct error Curtis	by Curtis	2	482
TEST FOR EXACT TEXT Phil B	by RagDyeR	8	385
Make Custom Macro always Available bookman3	by bookman3	2	794
average values in non-contiguous cells, ignoring 0 values RWormdahl	by JMB	3	1,612