Excel Worksheet Functions - Page 956

Thread / Thread Starter	Last Post	Replies	Views
% of calculated field in pivot table sc	by sc	0	638
How can I populate an Excel cell based on the data in another cell JerseyBoy	by JerseyBoy	3	3,874
summing subtotals BigTim	by Domenic	1	461
adding numbers with a label NETTA	by Duke Carey	3	435
prove/audit SUMPRODUCT? gpie	by gpie	2	365
Cell Format Changes When Data Is Entered - Not Conditional Formatt SundanceKidLudwig	by SundanceKidLudwig	2	973
How cell ranges are handled by worksheet functions/row column matc Martin	by Bernard Liengme	1	549
Match Geir	by Bernard Liengme	1	404
Nested If's Cletus Stripling	by Cletus Stripling	4	440
Coloring Active Cell Carroll	by Carroll	8	439
opening different programs with excel macro buttons shrek	by shrek	0	556
how to protect a word art in excel from edit sancbey	by sancbey	0	1,269
removing everything from the left after 10 digits tri_p	by tri_p	3	563
conditional formula Warrain	by Warrain	2	364
Sumproduct..help please Terry	by Terry	6	504
Get Past the 7 Nested IF limit Palencia1978	by Ron Moore	2	634
vlookup tjh	by RagDyer	3	388
IRR PC	by Fred Smith	3	436
VLOOKUP 2 text columns Brent	by D Hilberg	5	324
Excel CHARI	by Ron Moore	2	341
COUNTIF doesnt work! jjj	by Ashish Mathur	2	554
Simplifying array formula which evaluates as error. Richard Buttrey	by Ashish Mathur	5	648
Database type formula exploringtrails	by Ron Moore	1	316
EXCEL - Auditing - TRACE to show source from another page Tuba Joe	by RagDyer	1	955
Convert SERIAL date back into dd/mm/yy format? Aussie CPA	by Ron Rosenfeld	6	1,431
how to creat a selection pull down window? accountant2005	by Paul B	1	481
Excel formula entmjs	by Gord Dibben	4	321
IF functions conaway	by Trevor Shuttleworth	3	271
SUMIF not working #VALUE! Scorpvin	by JMB	1	393
dates in year MLD	by Ron Rosenfeld	3	379
Mode() & Large() cheshire191	by Aladin Akyurek	2	336
Reference the document properties in a cell McVeigh	by Gord Dibben	1	588
EXCEL - LINKS cannot easily get list of all links & names in book Tuba Joe	by Gord Dibben	1	1,332
Update Query (minutes into hours) CP	by Roger Govier	1	468
smart tags Cary	by Cary	0	631
How do you randomly sort a RANGE latturne	by [email protected]	4	644
have a calendar pop up in a cell to pick & insert a date in excel helevansen	by Gord Dibben	3	2,724
How do I transfer a keyboard function key to a terminal emulator? covington	by covington	0	638
Sum unique with conditions Brian D via OfficeKB.com	by Domenic	8	447
Database functions should use criteria in formula, as 1-2-3 does 123user	by 123user	8	1,819
Pivot Table data source "data source contains no visible tables" Jane	by Jane	0	2,593
Count names in column once Lorraine	by Alan	3	702
how to display remaining rows as blanks Demetrios13	by Duke Carey	3	353
Rounding Data Question sheabones	by Ron Rosenfeld	1	496
Find 7.... laly	by Harlan Grove	8	325
countif problem SLKPM	by Aladin Akyurek	2	424
how to delete unused footer dialogs in excell Jaycee	by Jaycee	0	622
Sum Dates riseazufall	by Aladin Akyurek	3	466
cell shading Shooter	by Richard Buttrey	2	357
Pivot Table Question carl	by Richard Buttrey	1	486
How do I add a cell with a label behind it NETTA	by Richard Buttrey	1	327
ROUNDING susan slate	by Ron Rosenfeld	5	504
How do I retrieve deleted information from an Excel worksheet? CatLover	by Paul B	1	407
blank cells datadude1959	by datadude1959	2	307
Find data in columns, then place in rows couriced	by couriced	2	620
countif JTee	by Ron Moore	3	385
How to create list on another tab by selecting qty from big list? Rob	by Gary L Brown	1	519
drop down list (repost from miscellaneous) wimpe	by wimpe	0	348
Remove last character of text string Grant	by BenjieLop	2	4,484
How do I calculate the difference between 2 dates (m,d,y) ? ady_sandu	by Myrna Larson	8	1,239
How do I change fill color in excel based on data in the cell Jason Southco	by Gord Dibben	1	1,646
Changing orientation of pages Louise	by Myrna Larson	1	590
Create different workbooks from only one workbook Emece	by Gord Dibben	2	424
how can I combine multiple worksheets into one? Deb Bagby	by Ron de Bruin	1	641
random number function junecol	by Bernie Deitrick	1	463
conditional formatting nique012	by nique012	2	273
Data range to names Erik B	by Arvi Laanemets	3	400
SUMif or SUMproduct across multiple worksheets? Eric Shamlin	by Roger Govier	1	1,654
List of Names, Dates, Durations ... Biff	by Roger Govier	2	425
GREATER OR EQUAL TO BUT LESS THAN Problem using Sumproduct Ragdyer	by Ragdyer	0	961
vlookup to provide row reference instead of value Graham Tritton	by Biff	2	704
repeating a character across the width of a column gvm	by gvm	4	504
Help with averages please amerkarim	by Max	5	590
Text won't wrap if row height is over 200 cms2004	by Dave Peterson	1	557
sum values in a data group BigTim	by Dave Peterson	1	706