Excel Worksheet Functions - Page 31

Thread / Thread Starter	Last Post	Replies	Views
How to transpose and concatenate long list in one column? CSchwass	by Gord Dibben	12	3,376
comparing times in excel CJ	by NBVC[_115_]	2	3,375
How can I double space in Excel w/o going2 each indiviudal cell? VNOLAN	by Gord Dibben	1	3,374
Using single cell reference as table array argument in Vlookup CornNiblet	by BlueDaze	3	3,373
Excel 2007 - not updating formulas MistyOki	by laser squadron	6	3,371
Is there an Excel formula to sum color filled cells? Alfred Kingfisher	by Bob Phillips	3	3,368
hash function for large strings jheby	by jheby	22	3,367
removing commas from numbers etc. Excel ??[_2_]	by Arvi Laanemets	2	3,367
If date in cell falls between date range... Keep It Simple Stupid	by John Lyons[_2_]	4	3,365
Disable X button on excel pano	by Mike	6	3,365
How do I make worksheet into fillable form? Tiana Herrera	by Dave Peterson	1	3,364
sumproduct a whole column steve	by Bob Phillips	11	3,364
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 mh	by Ashish Mathur[_2_]	5	3,363
Excel Time Duration Formula Jackson	by Myrna Larson	2	3,362
Formula checking multiple worksheets sonic-the-mouse	by Domenic	2	3,359
Using COUNTIF to search for existence Epinn	by Epinn	31	3,356
Excel Question - Last Twelve Month Calculation joseph jordan	by joseph jordan	3	3,356
Pivot Table Percentage of Sub-Total Michelle	by Herbert Seidenberg	7	3,354
how do i create funciton values_entered in excel Tamaboy	by Ken Johnson	1	3,354
Activex controls in Excel 2003 Tom Stewart	by William Horton	2	3,351
Can a column of numbers be set to mix up in random order KayD	by N harkawat	1	3,351
Adding a period to the "=LEFT()" function. Stilla	by Stilla	8	3,350
Change positive number to negative number Angie M.	by Jacob Skaria	1	3,350
HyperLink to a folder on other drive on the same network (LAN) klj	by klj	6	3,350
Excel - how do I use drop down list to filter data Donna	by Roger Govier	3	3,349
Ignore errors in range hmm	by Arvi Laanemets	3	3,349
if a cell has data, add suffix "N" Barnet Gill	by Barnet Gill[_2_]	4	3,349
What is DBRW as used in Excel cell formula ie =DBRW( Carlos	by Gary''s Student	1	3,347
How to get text which is inside the brackets in excel sheet arun	by David Biddulph[_2_]	2	3,346
How can I find all possible combinations of words? Yvonne	by ytayta555	4	3,345
Formatting Phone Numbers in Excel 2007 Help MrMike	by MrMike	15	3,345
Add "left align across selection" cell formatting Monty Analyst	by Spiky	2	3,345
display Calendar for Excel field entry? John Paul	by Ron de Bruin	2	3,344
How to feed master W/S into two JasonL	by Claus Busch	8	3,343
Conditional Formats to ignore blank cells mnwankpah	by Teethless mama	1	3,340
Displaying all combinations of a range of numbers Mally	by mpokos	5	3,337
Text from one sheet cell to appear in another sheet cell mduck	by Hellbent706	6	3,337
can lookup return err if no match found Kim Greenlaw	by Pete	12	3,337
Excel Pivot Tables-How to put two Data Varibles side by side BillyBob	by Debra Dalgleish	2	3,336
Transfer data from a cell to another workbook if certain criteria breezy	by mdrizwan81	15	3,333
COUNTIFS with a date for criteria... LUSN	by Fred Smith[_4_]	1	3,333
Different password for different worksheet Freshman	by GS[_6_]	16	3,333
Get Data From Closed Workbook Minitman	by T. Valko	20	3,332
Formula for a 4 day work week tamarade	by T. Valko	17	3,332
Excel - Copy and Paste Footer Data GMc	by GMc	6	3,331
How do I compare 2 text columns & show differences in 3rd? Kelli Freeman	by darkwood	2	3,330
FINDING THE DATE 75 DAYS AFTER A SPECIFIED DATE vikkib	by Gary Brown[_4_]	2	3,329
Font of drop down list is too small seng via OfficeKB.com	by Gary Brown	2	3,329
need to convert list of dates to count no. of dates by week neowok	by neowok	13	3,328
Cash Flows Inflation Adjusted Jes Johansen	by Shane Devenshire[_2_]	2	3,328
How do I add a symbol between numbers in a column? Deb	by Sloth	7	3,327
Hyperlink to a specific worksheet in another workbook Romileyrunner1	by Jacob Skaria	5	3,327
Create A GUID Derek Hart	by headly	3	3,326
How do I copy formulas from one wkb to another w/out linkng them? tomcat	by [email protected]	10	3,326
Excel file size too large skoolmarm	by Arvi Laanemets	1	3,325
IF checkbox is checked/unchecked, Cell.value = yes/no James	by John C[_2_]	3	3,325
How to extract email address in hyperlink Brossyg	by Dave Peterson	6	3,325
How to activate drop down box using keystrokes not mouse Lesliec4000	by Gord Dibben	4	3,324
Automatically hide column or row if a cell value meets criteria [email protected]	by Gord Dibben	3	3,323
MACRS depreciation formula Maxine	by Maxine	2	3,322
Lookup in one column, and return value from another column fdebelo	by Niek Otten	2	3,322
CONVERT ROMAN TO ARABIC NUMERALS JOHN	by Ron Rosenfeld	7	3,321
subtract entries from allocated total until it reaches zero kirbydog	by Max	1	3,321
Plus/Minus 2*Standard Deviation IF OR Statement sm416	by David Biddulph[_2_]	4	3,321
How to separate text and numbers in one cell or column? novastar	by Bibhu Bag	13	3,319
How to design microsoft Excel subnet calculator Fred msumeno	by Gary''s Student	1	3,318
VBA data validation KK[_2_]	by Rick Rothstein	6	3,316
DCOUNTA WITH MULTIPLE FIELD CRITERIA galsaba	by Peo Sjoblom	3	3,315
#N/A in VLookup - Can I use another function that will return 0? Arla	by Gills	9	3,315
Excel - if cells = 0, how to conditionally hide rows in chart fineimage	by Frank Kabel	1	3,315
How do you copy a formula without incrementing some constants? JohnT	by Ken Wright	2	3,313
how to calculate the difference between two bearings carmanah_bc	by carmanah_bc[_2_]	2	3,312
find for non zero values in a column Median,Mode,STDEV Billp	by Bassman62	2	3,312
How do I copy a template in Excel? Heather Rossi	by Tom Ogilvy	1	3,312
How do I calculate the 3 sigma of a number? OGWONE	by David Biddulph[_2_]	1	3,311