Excel Worksheet Functions - Page 5

Thread / Thread Starter	Last Post	Replies	Views
looking up nearest value geooil	by geooil	0	371
How do I build a free text note from a template? docben	by docben	0	741
How do I force a hyperlink in a spreadsheet to open a new window? sq246	by sq246	0	1,787
Is there an easy way to do this? chuttt	by chuttt	0	404
Copy worksheet with Pivot Table and break link to original workshe setter-lover	by setter-lover	0	3,303
How to call worksheet functions from Access ? Martin Plamondon	by Martin Plamondon	0	840
Format Cell Colour scottymelloty	by scottymelloty	0	526
Format Cell Colour scottymelloty	by scottymelloty	0	493
Populate embedded combo box Jahunga	by Jahunga	0	614
OLAP write back via formulas (functions), not read only pivot tab BISability	by BISability	0	1,358
Repeat Paste of Data SiouxieQ	by SiouxieQ	0	704
Formula error Chris	by Chris	0	516
average, array and offsets Darin1979	by Darin1979	0	913
Create a formula that determines a date-sensitive File-Name from w stan-the-man	by stan-the-man	0	649
How to populate formula in range of vertical cells to next colum Robert	by Robert	0	1,174
Controlling Linked Data to Workbooks Myrna	by Myrna	0	895
Problems with Excel formulas when 2002 upgraded to XP Kathi McGraw	by Kathi McGraw	0	1,195
vlookup and named ranges Domenic	by Domenic	0	731
need array of true/false if text exists alex	by alex	0	877
How to insert date last saved into the sheet (not the footer) Crispin Morton	by Crispin Morton	0	979
showing the contents of a consolidated cell Ken	by Ken	0	471
making a workbook into a web page. Brian	by Brian	0	668
How to import a path/filename when importing data into an XML list cxparker	by cxparker	0	902
VBA Code for Matching and totalling columns Bricktop	by Bricktop	0	738
Mailed document does not look the same joromoca	by joromoca	0	607
& reference answering as Date Serial # not actual text Kevin M	by Kevin M	0	1,122
New ? Data Validation Mike	by Mike	0	454
Using MS fingerprint reader with Excel jabax	by jabax	0	1,429
Superposition error in Dinamics Tables IvÃ¡n	by IvÃ¡n	0	476
Minutes to seconds - how to convert? Tony Moffat	by Tony Moffat	0	863
Scroll Messy	by Messy	0	329
Consolidate list from multiple worksheets VT	by VT	0	748
need help COMPLEX SUM /w conditions Seller	by Seller	0	614
HYPERLINK Marc	by Marc	0	361
Excel files on local drives running from internet FillyFriend	by FillyFriend	0	971
How do I password protect cells in a spreadsheet created in Excel [email protected]	by [email protected]	0	1,781
Use SQL statements in Excel VBA to query SQL Server Data Problem Thank You	by Thank You	0	1,521
Printing in Excel Bobby	by Bobby	0	356
Grouping data within intervals Cartesio	by Cartesio	0	1,160
Summing values of corresponding columns lanceg	by lanceg	0	757
Edit Hyperlinks Globally Rick@Stonybrook	by Rick@Stonybrook	0	1,326
CHIINV error Amy Bass	by Amy Bass	0	648
Concatenate and make uniform JYowler	by JYowler	0	779
Getting rid of curly brackets within formula Hardy	by Hardy	0	963
Getting rid of curly brackets within formula Hardy	by Hardy	0	864
dynamic 3d sum Avner	by Avner	0	660
Automatic date change when spreadsheet changes RobertSP	by RobertSP	0	958
find and match the max buffyslay	by buffyslay	0	938
Sending Text Messages with Excel??? sh0t2bts	by sh0t2bts	0	738
find and match the max buffyslay	by buffyslay	0	749
Printing Problem MFB	by MFB	0	701
Calculating due date? Loyalise	by Loyalise	0	916
Web Saving Help drvortex	by drvortex	0	700
Saving Charts to .htm drvortex	by drvortex	0	742
Sum and Count Function Daniell	by Daniell	0	1,037
copying conditional formats to a whole column Markitos	by Markitos	0	927
Macro for sorting different rows ciscopena	by ciscopena	0	1,256
countif() help for multiple rows ob3ron02	by ob3ron02	0	527
Using the results from two seperate cells to create cell reference DarrenWood	by DarrenWood	0	818
Lookup with search range start based on position of last blank lin rcmodelr	by rcmodelr	0	1,151
Circular functions arkansooner	by arkansooner	0	611
Sort/Link Worksheets Debby	by Debby	0	797
DSUM frustrations Paul Adams	by Paul Adams	0	568
Help on automatically ending a calculation Jim	by Jim	0	678
lookup help with multiple hits O'C	by O'C	0	702
Link & Update Two Workbooks o1darcie1o	by o1darcie1o	0	863
Data Sorting daniel	by daniel	0	772
Req Formula to place 1 into next columns stge	by stge	0	689
Conditional Formatting Graham Warren	by Graham Warren	0	996
Difference between two dates in months with decimals effem	by effem	0	895
Excel: How to return count for each cell within date range criter. Louisa	by Louisa	0	1,567
Count If Formula Mimi	by Mimi	0	1,068
Returning the Week Number of a Specific Date on a Month arjcvg	by arjcvg	0	1,072
how to remove label formatting (eg label to number) sikkiekaka	by sikkiekaka	0	1,607
Modify Row based upon cell value Brett Patterson	by Brett Patterson	0	1,054