Excel Worksheet Functions - Page 38

Thread / Thread Starter	Last Post	Replies	Views
Formula Question Lefty33	by tarquinious	1	2,056
Trying to add column headings to array formula Pierre	by Pierre	0	681
Basic Probabilities UDF Function Help Joe Smith03	by Joe Smith03	3	2,008
Help with Xecel Sheets Markzas	by tarquinious	2	2,011
consecutive blank cells old coach	by tarquinious	2	4,311
Hide/Unhide Cells eddysmith	by tarquinious	1	3,305
Print Title AngieS	by AngieS	0	1,874
module problem robert Vetrano	by robert Vetrano	2	1,675
Calculating Weighted Average sfmoored	by sfmoored	7	4,433
export colum to bat file CB	by TheManWho	3	2,340
Adding Text if Value of Cell = 0 MrMeth	by Mazzaropi	2	3,029
Best functions/formulas to use for a sales quotation? colgor	by colgor	1	1,534
Countif function Issue justkar4u	by wickedchew	10	4,049
Desperately seeking ACTIVE.WORKBOOK function for XLM arcibald tuttle	by arcibald tuttle	0	1,451
How to supply Week values dynamically? justkar4u	by wickedchew	1	1,268
Rosters/Sorting Alt255	by Alt255	4	1,394
Fixing function results SBodman	by SBodman	0	932
IQR of a frequency Lonehunter	by Lonehunter	1	1,478
how to look up a colum or row in an array mdawn	by mdawn	4	1,422
Presentation file gundesvan	by gundesvan	0	1,138
Some cells can't be formatted after converting from Quattro Pro. slock@muccipac	by Red90	2	1,758
Prep for pivot table papahoosier	by papahoosier	0	1,098
Polynomial HELP becca boop	by becca boop	0	963
A pasted formula won't calculate? PaulaJ	by ItWontBreak	6	6,486
how to apply conditional formula over large range of cells macasst	by Mazzaropi	1	2,083
Match Columns junkanu	by junkanu	1	901
Returning Cell Value if Matches Another cell frankjh19701	by frankjh19701	5	5,000
Excel: match two cells in one sheet to two cells in another and return a third cells value Spence	by sudarshan1026	3	4,897
text function JimB99	by JimB99	0	1,241
Help with Geomean kebab	by kebab	0	977
Function returns different results in different rows thedunedan	by thedunedan	0	966
Problem with Custom Categories for UDF EEL1966	by EEL1966	0	1,109
Accrue & Calculate pd leave across sheets hixnstix	by wickedchew	1	1,843
Lookup and match multiple columns bh06als	by bh06als	0	1,292
Calculating and concatenating from absolute to unit coordinates AnnieMa	by AnnieMa	7	1,436
Count if with Multiple criteria SVS	by SVS	2	1,626
Generate list of soon to expire courses freesie101	by freesie101	0	930
Total Mining frost240z	by Mazzaropi	1	891
Counting categories artytac	by Mazzaropi	3	1,451
Loop through drop down list mcousin	by mcousin	0	1,582
How to get text to automatically appear in a cell. Katiejames	by Mazzaropi	1	1,715
Count including up to n duplicates dan_boisvert	by dan_boisvert	0	1,009
Find Replace loses text properties/formatting no1jimmyman	by DeFautT	1	1,844
Formula auto fill issue DeFautT	by DeFautT	0	1,158
compare 2 column cells and return the adjacent columns cells data of the cell trebor57	by trebor57	1	2,483
Saving a workbook by creating a folder & subfolder Gaura215	by Gaura215	0	1,260
copy n paste special in filtered data Balkrishna	by Balkrishna	0	1,402
Reference Column m2c2	by m2c2	2	1,044
Multiplication of cells returns value error bbheli	by wickedchew	1	2,313
Transpose multiple groups of columns to multiple rowsrow Billy_McSkintos	by Billy_McSkintos	3	2,404
Easy question (I think) (dependent cells) Beverly Jackson	by wickedchew	2	1,167
Help - If statement will not work Randy Mis	by wickedchew	1	1,186
getting data out of a table trebor57	by wickedchew	4	1,480
Don't run formula if cell is blank Randy Mis	by wickedchew	1	5,393
getting data from a table trebor57	by trebor57	0	966
Conditional Formatting - saving in a seperate worksheet Simon Gammon	by Simon Gammon	0	956
Create HTML code for a hyperlink from cell contents Billy_McSkintos	by Billy_McSkintos	1	2,091
Adding letter P to Cell chrisjack001	by chrisjack001	0	883
Formatting Field chrisjack001	by chrisjack001	0	847
If / Match in a IF / Match Cosacoruso	by Cosacoruso	2	2,386
Creating a total percentage from coloured cells 1cainr	by maxpaayne	1	1,867
Auto-Populating Separate Sheets melotron	by melotron	0	1,140
Wonderware Active Factory Add In Problem Joe	by Dplumlee12	1	4,756
Excel 2003: Transpose (flip, swap, rotate) rows and cells. BJ Martens	by BJ Martens	0	3,038
Excel 2003: Swap or flip or rotate rows and columns (instructions didn't work) BJ Martens	by Mazzaropi	1	3,092
Excel 2007: complex COUNTIFS() David Aukerman[_2_]	by mikekep	9	3,541
DProduct question ModernBeat	by ModernBeat	1	1,087
deleting takes too long Howiek1	by evrentuskan	2	1,944
mr eric4pep	by eric4pep	0	913
NEED TO FILL BLANK CELLS IN DATA WITH TEXT STRING Stewcrew	by nandu05	8	3,701
How to Keep Text format and Grouping when Referencing Cells Dredegr	by Dredegr	0	1,501
=sumshifts adketcham	by adketcham	0	816
Countif array LearningHorse	by LearningHorse	0	1,156
Strange FreedomHillFarm	by Wilco	1	1,137
new data with autofilter on joanneed	by joanneed	0	1,024