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	740
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	403
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	525
Format Cell Colour scottymelloty	by scottymelloty	0	492
Populate embedded combo box Jahunga	by Jahunga	0	613
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	703
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,194
vlookup and named ranges Domenic	by Domenic	0	727
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	470
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	901
VBA Code for Matching and totalling columns Bricktop	by Bricktop	0	737
Mailed document does not look the same joromoca	by joromoca	0	603
& 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	862
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	360
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,779
Use SQL statements in Excel VBA to query SQL Server Data Problem Thank You	by Thank You	0	1,520
Printing in Excel Bobby	by Bobby	0	354
Grouping data within intervals Cartesio	by Cartesio	0	1,157
Summing values of corresponding columns lanceg	by lanceg	0	757
Edit Hyperlinks Globally Rick@Stonybrook	by Rick@Stonybrook	0	1,321
CHIINV error Amy Bass	by Amy Bass	0	643
Concatenate and make uniform JYowler	by JYowler	0	772
Getting rid of curly brackets within formula Hardy	by Hardy	0	963
Getting rid of curly brackets within formula Hardy	by Hardy	0	856
dynamic 3d sum Avner	by Avner	0	658
Automatic date change when spreadsheet changes RobertSP	by RobertSP	0	954
find and match the max buffyslay	by buffyslay	0	938
Sending Text Messages with Excel??? sh0t2bts	by sh0t2bts	0	733
find and match the max buffyslay	by buffyslay	0	744
Printing Problem MFB	by MFB	0	699
Calculating due date? Loyalise	by Loyalise	0	911
Web Saving Help drvortex	by drvortex	0	696
Saving Charts to .htm drvortex	by drvortex	0	737
Sum and Count Function Daniell	by Daniell	0	1,035
copying conditional formats to a whole column Markitos	by Markitos	0	926
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,150
Circular functions arkansooner	by arkansooner	0	611
Sort/Link Worksheets Debby	by Debby	0	794
DSUM frustrations Paul Adams	by Paul Adams	0	565
Help on automatically ending a calculation Jim	by Jim	0	674
lookup help with multiple hits O'C	by O'C	0	698
Link & Update Two Workbooks o1darcie1o	by o1darcie1o	0	863
Data Sorting daniel	by daniel	0	771
Req Formula to place 1 into next columns stge	by stge	0	682
Conditional Formatting Graham Warren	by Graham Warren	0	991
Difference between two dates in months with decimals effem	by effem	0	890
Excel: How to return count for each cell within date range criter. Louisa	by Louisa	0	1,566
Count If Formula Mimi	by Mimi	0	1,066
Returning the Week Number of a Specific Date on a Month arjcvg	by arjcvg	0	1,071
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,052