Excel Worksheet Functions - Page 38

Thread / Thread Starter	Last Post	Replies	Views
Formula Question Lefty33	by tarquinious	1	2,061
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,023
Help with Xecel Sheets Markzas	by tarquinious	2	2,011
consecutive blank cells old coach	by tarquinious	2	4,322
Hide/Unhide Cells eddysmith	by tarquinious	1	3,318
Print Title AngieS	by AngieS	0	1,880
module problem robert Vetrano	by robert Vetrano	2	1,688
Calculating Weighted Average sfmoored	by sfmoored	7	4,478
export colum to bat file CB	by TheManWho	3	2,340
Adding Text if Value of Cell = 0 MrMeth	by Mazzaropi	2	3,039
Best functions/formulas to use for a sales quotation? colgor	by colgor	1	1,534
Countif function Issue justkar4u	by wickedchew	10	4,066
Desperately seeking ACTIVE.WORKBOOK function for XLM arcibald tuttle	by arcibald tuttle	0	1,455
How to supply Week values dynamically? justkar4u	by wickedchew	1	1,270
Rosters/Sorting Alt255	by Alt255	4	1,400
Fixing function results SBodman	by SBodman	0	934
IQR of a frequency Lonehunter	by Lonehunter	1	1,482
how to look up a colum or row in an array mdawn	by mdawn	4	1,424
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,766
Prep for pivot table papahoosier	by papahoosier	0	1,103
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,098
Match Columns junkanu	by junkanu	1	902
Returning Cell Value if Matches Another cell frankjh19701	by frankjh19701	5	5,014
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	968
Problem with Custom Categories for UDF EEL1966	by EEL1966	0	1,114
Accrue & Calculate pd leave across sheets hixnstix	by wickedchew	1	1,844
Lookup and match multiple columns bh06als	by bh06als	0	1,293
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	902
Counting categories artytac	by Mazzaropi	3	1,451
Loop through drop down list mcousin	by mcousin	0	1,590
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,857
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,522
Saving a workbook by creating a folder & subfolder Gaura215	by Gaura215	0	1,265
copy n paste special in filtered data Balkrishna	by Balkrishna	0	1,413
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,418
Easy question (I think) (dependent cells) Beverly Jackson	by wickedchew	2	1,172
Help - If statement will not work Randy Mis	by wickedchew	1	1,197
getting data out of a table trebor57	by wickedchew	4	1,481
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	964
Create HTML code for a hyperlink from cell contents Billy_McSkintos	by Billy_McSkintos	1	2,101
Adding letter P to Cell chrisjack001	by chrisjack001	0	892
Formatting Field chrisjack001	by chrisjack001	0	858
If / Match in a IF / Match Cosacoruso	by Cosacoruso	2	2,388
Creating a total percentage from coloured cells 1cainr	by maxpaayne	1	1,872
Auto-Populating Separate Sheets melotron	by melotron	0	1,140
Wonderware Active Factory Add In Problem Joe	by Dplumlee12	1	4,757
Excel 2003: Transpose (flip, swap, rotate) rows and cells. BJ Martens	by BJ Martens	0	3,047
Excel 2003: Swap or flip or rotate rows and columns (instructions didn't work) BJ Martens	by Mazzaropi	1	3,103
Excel 2007: complex COUNTIFS() David Aukerman[_2_]	by mikekep	9	3,553
DProduct question ModernBeat	by ModernBeat	1	1,088
deleting takes too long Howiek1	by evrentuskan	2	1,948
mr eric4pep	by eric4pep	0	913
NEED TO FILL BLANK CELLS IN DATA WITH TEXT STRING Stewcrew	by nandu05	8	3,712
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,169
Strange FreedomHillFarm	by Wilco	1	1,144
new data with autofilter on joanneed	by joanneed	0	1,034