Excel Worksheet Functions - Page 38

Thread / Thread Starter	Last Post	Replies	Views
Formula Question Lefty33	by tarquinious	1	2,060
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,010
Help with Xecel Sheets Markzas	by tarquinious	2	2,011
consecutive blank cells old coach	by tarquinious	2	4,314
Hide/Unhide Cells eddysmith	by tarquinious	1	3,307
Print Title AngieS	by AngieS	0	1,874
module problem robert Vetrano	by robert Vetrano	2	1,676
Calculating Weighted Average sfmoored	by sfmoored	7	4,451
export colum to bat file CB	by TheManWho	3	2,340
Adding Text if Value of Cell = 0 MrMeth	by Mazzaropi	2	3,031
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,452
How to supply Week values dynamically? justkar4u	by wickedchew	1	1,270
Rosters/Sorting Alt255	by Alt255	4	1,397
Fixing function results SBodman	by SBodman	0	933
IQR of a frequency Lonehunter	by Lonehunter	1	1,479
how to look up a colum or row in an array mdawn	by mdawn	4	1,423
Presentation file gundesvan	by gundesvan	0	1,144
Some cells can't be formatted after converting from Quattro Pro. slock@muccipac	by Red90	2	1,760
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,487
how to apply conditional formula over large range of cells macasst	by Mazzaropi	1	2,086
Match Columns junkanu	by junkanu	1	902
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,918
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	967
Problem with Custom Categories for UDF EEL1966	by EEL1966	0	1,112
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,439
Count if with Multiple criteria SVS	by SVS	2	1,627
Generate list of soon to expire courses freesie101	by freesie101	0	932
Total Mining frost240z	by Mazzaropi	1	893
Counting categories artytac	by Mazzaropi	3	1,451
Loop through drop down list mcousin	by mcousin	0	1,583
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,846
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,513
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,404
Reference Column m2c2	by m2c2	2	1,046
Multiplication of cells returns value error bbheli	by wickedchew	1	2,314
Transpose multiple groups of columns to multiple rowsrow Billy_McSkintos	by Billy_McSkintos	3	2,405
Easy question (I think) (dependent cells) Beverly Jackson	by wickedchew	2	1,168
Help - If statement will not work Randy Mis	by wickedchew	1	1,187
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,394
getting data from a table trebor57	by trebor57	0	967
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	884
Formatting Field chrisjack001	by chrisjack001	0	848
If / Match in a IF / Match Cosacoruso	by Cosacoruso	2	2,387
Creating a total percentage from coloured cells 1cainr	by maxpaayne	1	1,868
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,039
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,543
DProduct question ModernBeat	by ModernBeat	1	1,087
deleting takes too long Howiek1	by evrentuskan	2	1,945
mr eric4pep	by eric4pep	0	913
NEED TO FILL BLANK CELLS IN DATA WITH TEXT STRING Stewcrew	by nandu05	8	3,705
How to Keep Text format and Grouping when Referencing Cells Dredegr	by Dredegr	0	1,501
=sumshifts adketcham	by adketcham	0	817
Countif array LearningHorse	by LearningHorse	0	1,159
Strange FreedomHillFarm	by Wilco	1	1,137
new data with autofilter on joanneed	by joanneed	0	1,025