Excel Worksheet Functions - Page 956

Thread / Thread Starter	Last Post	Replies	Views
% of calculated field in pivot table sc	by sc	0	635
How can I populate an Excel cell based on the data in another cell JerseyBoy	by JerseyBoy	3	3,856
summing subtotals BigTim	by Domenic	1	461
adding numbers with a label NETTA	by Duke Carey	3	431
prove/audit SUMPRODUCT? gpie	by gpie	2	363
Cell Format Changes When Data Is Entered - Not Conditional Formatt SundanceKidLudwig	by SundanceKidLudwig	2	960
How cell ranges are handled by worksheet functions/row column matc Martin	by Bernard Liengme	1	538
Match Geir	by Bernard Liengme	1	402
Nested If's Cletus Stripling	by Cletus Stripling	4	438
Coloring Active Cell Carroll	by Carroll	8	436
opening different programs with excel macro buttons shrek	by shrek	0	554
how to protect a word art in excel from edit sancbey	by sancbey	0	1,266
removing everything from the left after 10 digits tri_p	by tri_p	3	562
conditional formula Warrain	by Warrain	2	363
Sumproduct..help please Terry	by Terry	6	501
Get Past the 7 Nested IF limit Palencia1978	by Ron Moore	2	632
vlookup tjh	by RagDyer	3	387
IRR PC	by Fred Smith	3	434
VLOOKUP 2 text columns Brent	by D Hilberg	5	323
Excel CHARI	by Ron Moore	2	340
COUNTIF doesnt work! jjj	by Ashish Mathur	2	552
Simplifying array formula which evaluates as error. Richard Buttrey	by Ashish Mathur	5	644
Database type formula exploringtrails	by Ron Moore	1	313
EXCEL - Auditing - TRACE to show source from another page Tuba Joe	by RagDyer	1	954
Convert SERIAL date back into dd/mm/yy format? Aussie CPA	by Ron Rosenfeld	6	1,429
how to creat a selection pull down window? accountant2005	by Paul B	1	480
Excel formula entmjs	by Gord Dibben	4	320
IF functions conaway	by Trevor Shuttleworth	3	270
SUMIF not working #VALUE! Scorpvin	by JMB	1	390
dates in year MLD	by Ron Rosenfeld	3	377
Mode() & Large() cheshire191	by Aladin Akyurek	2	335
Reference the document properties in a cell McVeigh	by Gord Dibben	1	581
EXCEL - LINKS cannot easily get list of all links & names in book Tuba Joe	by Gord Dibben	1	1,230
Update Query (minutes into hours) CP	by Roger Govier	1	466
smart tags Cary	by Cary	0	627
How do you randomly sort a RANGE latturne	by [email protected]	4	642
have a calendar pop up in a cell to pick & insert a date in excel helevansen	by Gord Dibben	3	2,716
How do I transfer a keyboard function key to a terminal emulator? covington	by covington	0	637
Sum unique with conditions Brian D via OfficeKB.com	by Domenic	8	446
Database functions should use criteria in formula, as 1-2-3 does 123user	by 123user	8	1,743
Pivot Table data source "data source contains no visible tables" Jane	by Jane	0	2,576
Count names in column once Lorraine	by Alan	3	701
how to display remaining rows as blanks Demetrios13	by Duke Carey	3	352
Rounding Data Question sheabones	by Ron Rosenfeld	1	495
Find 7.... laly	by Harlan Grove	8	323
countif problem SLKPM	by Aladin Akyurek	2	423
how to delete unused footer dialogs in excell Jaycee	by Jaycee	0	622
Sum Dates riseazufall	by Aladin Akyurek	3	465
cell shading Shooter	by Richard Buttrey	2	356
Pivot Table Question carl	by Richard Buttrey	1	485
How do I add a cell with a label behind it NETTA	by Richard Buttrey	1	326
ROUNDING susan slate	by Ron Rosenfeld	5	502
How do I retrieve deleted information from an Excel worksheet? CatLover	by Paul B	1	407
blank cells datadude1959	by datadude1959	2	305
Find data in columns, then place in rows couriced	by couriced	2	614
countif JTee	by Ron Moore	3	384
How to create list on another tab by selecting qty from big list? Rob	by Gary L Brown	1	517
drop down list (repost from miscellaneous) wimpe	by wimpe	0	348
Remove last character of text string Grant	by BenjieLop	2	4,469
How do I calculate the difference between 2 dates (m,d,y) ? ady_sandu	by Myrna Larson	8	1,237
How do I change fill color in excel based on data in the cell Jason Southco	by Gord Dibben	1	1,565
Changing orientation of pages Louise	by Myrna Larson	1	588
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	640
random number function junecol	by Bernie Deitrick	1	462
conditional formatting nique012	by nique012	2	271
Data range to names Erik B	by Arvi Laanemets	3	396
SUMif or SUMproduct across multiple worksheets? Eric Shamlin	by Roger Govier	1	1,651
List of Names, Dates, Durations ... Biff	by Roger Govier	2	424
GREATER OR EQUAL TO BUT LESS THAN Problem using Sumproduct Ragdyer	by Ragdyer	0	957
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	502
Help with averages please amerkarim	by Max	5	589
Text won't wrap if row height is over 200 cms2004	by Dave Peterson	1	550
sum values in a data group BigTim	by Dave Peterson	1	704