Excel Worksheet Functions - Page 38

Thread / Thread Starter	Last Post	Replies	Views
Formula Question Lefty33	by tarquinious	1	2,043
Trying to add column headings to array formula Pierre	by Pierre	0	670
Basic Probabilities UDF Function Help Joe Smith03	by Joe Smith03	3	1,995
Help with Xecel Sheets Markzas	by tarquinious	2	1,997
consecutive blank cells old coach	by tarquinious	2	4,284
Hide/Unhide Cells eddysmith	by tarquinious	1	3,294
Print Title AngieS	by AngieS	0	1,864
module problem robert Vetrano	by robert Vetrano	2	1,662
Calculating Weighted Average sfmoored	by sfmoored	7	4,391
export colum to bat file CB	by TheManWho	3	2,322
Adding Text if Value of Cell = 0 MrMeth	by Mazzaropi	2	3,009
Best functions/formulas to use for a sales quotation? colgor	by colgor	1	1,522
Countif function Issue justkar4u	by wickedchew	10	4,031
Desperately seeking ACTIVE.WORKBOOK function for XLM arcibald tuttle	by arcibald tuttle	0	1,438
How to supply Week values dynamically? justkar4u	by wickedchew	1	1,258
Rosters/Sorting Alt255	by Alt255	4	1,385
Fixing function results SBodman	by SBodman	0	923
IQR of a frequency Lonehunter	by Lonehunter	1	1,465
how to look up a colum or row in an array mdawn	by mdawn	4	1,407
Presentation file gundesvan	by gundesvan	0	1,126
Some cells can't be formatted after converting from Quattro Pro. slock@muccipac	by Red90	2	1,740
Prep for pivot table papahoosier	by papahoosier	0	1,090
Polynomial HELP becca boop	by becca boop	0	956
A pasted formula won't calculate? PaulaJ	by ItWontBreak	6	6,467
how to apply conditional formula over large range of cells macasst	by Mazzaropi	1	2,066
Match Columns junkanu	by junkanu	1	893
Returning Cell Value if Matches Another cell frankjh19701	by frankjh19701	5	4,986
Excel: match two cells in one sheet to two cells in another and return a third cells value Spence	by sudarshan1026	3	4,860
text function JimB99	by JimB99	0	1,231
Help with Geomean kebab	by kebab	0	969
Function returns different results in different rows thedunedan	by thedunedan	0	950
Problem with Custom Categories for UDF EEL1966	by EEL1966	0	1,100
Accrue & Calculate pd leave across sheets hixnstix	by wickedchew	1	1,833
Lookup and match multiple columns bh06als	by bh06als	0	1,283
Calculating and concatenating from absolute to unit coordinates AnnieMa	by AnnieMa	7	1,424
Count if with Multiple criteria SVS	by SVS	2	1,577
Generate list of soon to expire courses freesie101	by freesie101	0	918
Total Mining frost240z	by Mazzaropi	1	873
Counting categories artytac	by Mazzaropi	3	1,439
Loop through drop down list mcousin	by mcousin	0	1,565
How to get text to automatically appear in a cell. Katiejames	by Mazzaropi	1	1,706
Count including up to n duplicates dan_boisvert	by dan_boisvert	0	996
Find Replace loses text properties/formatting no1jimmyman	by DeFautT	1	1,823
Formula auto fill issue DeFautT	by DeFautT	0	1,151
compare 2 column cells and return the adjacent columns cells data of the cell trebor57	by trebor57	1	2,471
Saving a workbook by creating a folder & subfolder Gaura215	by Gaura215	0	1,237
copy n paste special in filtered data Balkrishna	by Balkrishna	0	1,392
Reference Column m2c2	by m2c2	2	1,022
Multiplication of cells returns value error bbheli	by wickedchew	1	2,293
Transpose multiple groups of columns to multiple rowsrow Billy_McSkintos	by Billy_McSkintos	3	2,391
Easy question (I think) (dependent cells) Beverly Jackson	by wickedchew	2	1,151
Help - If statement will not work Randy Mis	by wickedchew	1	1,172
getting data out of a table trebor57	by wickedchew	4	1,467
Don't run formula if cell is blank Randy Mis	by wickedchew	1	5,383
getting data from a table trebor57	by trebor57	0	961
Conditional Formatting - saving in a seperate worksheet Simon Gammon	by Simon Gammon	0	942
Create HTML code for a hyperlink from cell contents Billy_McSkintos	by Billy_McSkintos	1	2,072
Adding letter P to Cell chrisjack001	by chrisjack001	0	872
Formatting Field chrisjack001	by chrisjack001	0	837
If / Match in a IF / Match Cosacoruso	by Cosacoruso	2	2,367
Creating a total percentage from coloured cells 1cainr	by maxpaayne	1	1,843
Auto-Populating Separate Sheets melotron	by melotron	0	1,124
Wonderware Active Factory Add In Problem Joe	by Dplumlee12	1	4,734
Excel 2003: Transpose (flip, swap, rotate) rows and cells. BJ Martens	by BJ Martens	0	3,006
Excel 2003: Swap or flip or rotate rows and columns (instructions didn't work) BJ Martens	by Mazzaropi	1	3,068
Excel 2007: complex COUNTIFS() David Aukerman[_2_]	by mikekep	9	3,521
DProduct question ModernBeat	by ModernBeat	1	1,079
deleting takes too long Howiek1	by evrentuskan	2	1,926
mr eric4pep	by eric4pep	0	896
NEED TO FILL BLANK CELLS IN DATA WITH TEXT STRING Stewcrew	by nandu05	8	3,685
How to Keep Text format and Grouping when Referencing Cells Dredegr	by Dredegr	0	1,490
=sumshifts adketcham	by adketcham	0	800
Countif array LearningHorse	by LearningHorse	0	1,143
Strange FreedomHillFarm	by Wilco	1	1,124
new data with autofilter on joanneed	by joanneed	0	1,011