Excel Worksheet Functions - Page 956

Thread / Thread Starter	Last Post	Replies	Views
% of calculated field in pivot table sc	by sc	0	613
How can I populate an Excel cell based on the data in another cell JerseyBoy	by JerseyBoy	3	3,811
summing subtotals BigTim	by Domenic	1	448
adding numbers with a label NETTA	by Duke Carey	3	420
prove/audit SUMPRODUCT? gpie	by gpie	2	347
Cell Format Changes When Data Is Entered - Not Conditional Formatt SundanceKidLudwig	by SundanceKidLudwig	2	937
How cell ranges are handled by worksheet functions/row column matc Martin	by Bernard Liengme	1	512
Match Geir	by Bernard Liengme	1	397
Nested If's Cletus Stripling	by Cletus Stripling	4	428
Coloring Active Cell Carroll	by Carroll	8	421
opening different programs with excel macro buttons shrek	by shrek	0	526
how to protect a word art in excel from edit sancbey	by sancbey	0	1,234
removing everything from the left after 10 digits tri_p	by tri_p	3	547
conditional formula Warrain	by Warrain	2	347
Sumproduct..help please Terry	by Terry	6	484
Get Past the 7 Nested IF limit Palencia1978	by Ron Moore	2	621
vlookup tjh	by RagDyer	3	377
IRR PC	by Fred Smith	3	423
VLOOKUP 2 text columns Brent	by D Hilberg	5	314
Excel CHARI	by Ron Moore	2	325
COUNTIF doesnt work! jjj	by Ashish Mathur	2	542
Simplifying array formula which evaluates as error. Richard Buttrey	by Ashish Mathur	5	624
Database type formula exploringtrails	by Ron Moore	1	306
EXCEL - Auditing - TRACE to show source from another page Tuba Joe	by RagDyer	1	945
Convert SERIAL date back into dd/mm/yy format? Aussie CPA	by Ron Rosenfeld	6	1,409
how to creat a selection pull down window? accountant2005	by Paul B	1	473
Excel formula entmjs	by Gord Dibben	4	317
IF functions conaway	by Trevor Shuttleworth	3	263
SUMIF not working #VALUE! Scorpvin	by JMB	1	377
dates in year MLD	by Ron Rosenfeld	3	369
Mode() & Large() cheshire191	by Aladin Akyurek	2	326
Reference the document properties in a cell McVeigh	by Gord Dibben	1	561
EXCEL - LINKS cannot easily get list of all links & names in book Tuba Joe	by Gord Dibben	1	1,210
Update Query (minutes into hours) CP	by Roger Govier	1	454
smart tags Cary	by Cary	0	613
How do you randomly sort a RANGE latturne	by [email protected]	4	604
have a calendar pop up in a cell to pick & insert a date in excel helevansen	by Gord Dibben	3	2,697
How do I transfer a keyboard function key to a terminal emulator? covington	by covington	0	625
Sum unique with conditions Brian D via OfficeKB.com	by Domenic	8	439
Database functions should use criteria in formula, as 1-2-3 does 123user	by 123user	8	1,718
Pivot Table data source "data source contains no visible tables" Jane	by Jane	0	2,545
Count names in column once Lorraine	by Alan	3	690
how to display remaining rows as blanks Demetrios13	by Duke Carey	3	340
Rounding Data Question sheabones	by Ron Rosenfeld	1	482
Find 7.... laly	by Harlan Grove	8	305
countif problem SLKPM	by Aladin Akyurek	2	410
how to delete unused footer dialogs in excell Jaycee	by Jaycee	0	613
Sum Dates riseazufall	by Aladin Akyurek	3	460
cell shading Shooter	by Richard Buttrey	2	350
Pivot Table Question carl	by Richard Buttrey	1	476
How do I add a cell with a label behind it NETTA	by Richard Buttrey	1	321
ROUNDING susan slate	by Ron Rosenfeld	5	490
How do I retrieve deleted information from an Excel worksheet? CatLover	by Paul B	1	385
blank cells datadude1959	by datadude1959	2	301
Find data in columns, then place in rows couriced	by couriced	2	597
countif JTee	by Ron Moore	3	380
How to create list on another tab by selecting qty from big list? Rob	by Gary L Brown	1	510
drop down list (repost from miscellaneous) wimpe	by wimpe	0	333
Remove last character of text string Grant	by BenjieLop	2	4,443
How do I calculate the difference between 2 dates (m,d,y) ? ady_sandu	by Myrna Larson	8	1,223
How do I change fill color in excel based on data in the cell Jason Southco	by Gord Dibben	1	1,528
Changing orientation of pages Louise	by Myrna Larson	1	557
Create different workbooks from only one workbook Emece	by Gord Dibben	2	406
how can I combine multiple worksheets into one? Deb Bagby	by Ron de Bruin	1	616
random number function junecol	by Bernie Deitrick	1	444
conditional formatting nique012	by nique012	2	266
Data range to names Erik B	by Arvi Laanemets	3	379
SUMif or SUMproduct across multiple worksheets? Eric Shamlin	by Roger Govier	1	1,618
List of Names, Dates, Durations ... Biff	by Roger Govier	2	416
GREATER OR EQUAL TO BUT LESS THAN Problem using Sumproduct Ragdyer	by Ragdyer	0	922
vlookup to provide row reference instead of value Graham Tritton	by Biff	2	695
repeating a character across the width of a column gvm	by gvm	4	485
Help with averages please amerkarim	by Max	5	566
Text won't wrap if row height is over 200 cms2004	by Dave Peterson	1	531
sum values in a data group BigTim	by Dave Peterson	1	689