Excel Worksheet Functions - Page 161

Thread / Thread Starter	Last Post	Replies	Views
how to replace #N/A with my Vlookup [email protected]	by Claus Busch	1	1,283
Keeping cells blank even though formula is input Bootface	by Bootface	5	1,283
Excel prompts me to save a copy or overwrite file. Vinny	by Vinny	0	1,283
Calculate the number of workdays between 2 dates Tegid77	by Myrna Larson	2	1,282
Trying to average the contents of a cell across multiple worksheet ErikVegas	by T. Valko	12	1,282
Sending Fax Using Fax Numbers in Excel Spreadsheet FredK	by FredK	0	1,282
VLOOKUP format issues? Craig4321	by Bassman62	4	1,282
Copy paste non merged to merged cells [email protected]	by Pete_UK	1	1,282
How to use the rownumber of the current cell in a formula Wim Goelen	by Michael	3	1,282
Returning 0 instead of #N/A when no value is found RobertSD	by Dave Peterson	8	1,282
How keep Excel from counting empty cells when calculating formula Excel Noob	by Pete_UK	6	1,282
SumifS Multiple Sum Ranges dee	by dee	2	1,282
Combining data from multiple cells into one cell. Steelsilk	by Gord Dibben	4	1,282
If function - move to cell below [email protected]	by [email protected]	4	1,282
Finding a name with biggest number Handyy	by Max	11	1,282
Combine contents of multiple workbooks into one worksheet EMG03	by Anne Troy	1	1,282
How do I set the order of calculation of Data Tables in Excel? Charles Easton	by David McRitchie	1	1,282
How can i set up a MONTE CARLO SIMULATION macro in Excel? thx MonteUser	by Alok	4	1,282
Percentile function Vincdc	by Vincdc	2	1,282
Formula window displays correct answer while cell displays incorre MMV	by Frank Kabel	3	1,282
Date Range within a date range - try again MoonBlosm	by Luke M	2	1,281
VBA coding for expiry dates alert threw email Tia[_3_]	by Eduardo	1	1,281
consolidate multiple worksheets se7098	by Ron de Bruin	13	1,281
In Excel how do i get the cursor to tab down without the keyboard DHeckler	by pub	2	1,281
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0 tiffa	by MartinW	4	1,281
text box in Excel 2007 Simon Minder	by Simon Minder	1	1,281
Footing rounded numbers G-man	by JE McGimpsey	4	1,281
SUMIF with two or more variables B Benton	by Peo Sjoblom	1	1,281
compare date to various date ranges and sum value al	by al	2	1,281
generate multiple rows based on cell value Theresa	by Theresa	0	1,281
Lookup returns wrong value motorjobs	by motorjobs	5	1,281
transpose links from a column to a row Tim	by Tim	4	1,281
hyperlink reference not valid Dannycol	by Dannycol	0	1,281
"E" or "O" for the first, even or odd digit in a number jenn	by Ron Rosenfeld	2	1,281
Automatically pasting worksheet data to new worksheet with formulas COntactJason	by COntactJason	0	1,281
ISNUMBER and VLOOKUP Help Needed lrbest4x4xfar	by Bob Phillips	1	1,281
DesearÃ*a incluir un archivo para hacer Contabilidad en Excel Arturo EfraÃn Ortiz	by Arturo EfraÃn Ortiz	0	1,281
how do i set up employee performance database in excel mcg	by Frank Kabel	1	1,280
How do I use multiple worksheets (List) in a Pivot Table Report? Robert	by Frank Kabel	1	1,280
dynamic external cell reference bg.itdept	by Harlan Grove	4	1,280
SUMIF Returns a #VALUE error when external source is closed ghynes	by Domenic	7	1,280
conditional formatting with numbers and text Daniel	by Peo Sjoblom	1	1,280
VLOOKUP(sorta) againts SQL Server table - HELP! cpa-mcse.net	by cpa-mcse.net	2	1,280
How do I Autosum a running column total in excel? JR5280	by Keith	2	1,280
VBA Monty	by Monty	2	1,280
.XLS to .CSV Macro Conversion Carl	by Dave Peterson	3	1,280
sumif to return an intersection? EllenG	by Franz Verga	17	1,280
How to replace spreadsheet cells with data from another sheet? Sailor JP	by Sailor JP[_2_]	2	1,279
Vlookup doesn't work in new workbook kleivakat	by Allllen	1	1,279
linking clip art to a formula in excel yusuf	by CLR	2	1,279
convert number to month and year in formula Soth	by Soth	3	1,279
Vlookup - using a cell to reference a named array Ronin	by Teethless mama	3	1,279
CountIf on Date field sarjak	by Duke Carey	3	1,279
Networkdays Function Ron Bridgeman	by Ron Bridgeman[_2_]	11	1,279
Add Company Holidays to Formula Calculation tb	by tb	0	1,279
Fill down error for Vlookup MC	by MC	2	1,279
Pivot Table Data Field Query Pepikins	by Debra Dalgleish	1	1,279
FIND FORMULA SIMILAR TO VLOOKUP FOR NON-ASCENDING VALUES Kir	by Harlan Grove	2	1,279
Does Excel have a @grandtotal function like Lotus 123 daedconc04	by Me Haney	2	1,279
cant pass array to excel from c++ using xloper structure malayhk	by malayhk	0	1,278
COUNTIF? Malcolm Austin	by Claus Busch	2	1,278
Help with an Excel formula problem rdjohnsons	by SUDHIR VERMA	5	1,278
Finding duplicate nuumbers in a column Johnny the hat	by Johnny the hat	2	1,278
Formating output. JustSomeGuy	by Peter T	12	1,278
convert [h]:mm:ss to real number that I can use as a multiplier Dean	by Fred Smith[_4_]	3	1,278
WeekNum ISO RPitoyo	by Ron Rosenfeld	4	1,278
Excel F9 error KCM Andrea	by Jim Cone	6	1,278
Outline Numbering Dr. Sachin Wagh	by Dr. Sachin Wagh	2	1,278
How do I model a Paretian Distribution in Excel? NickPadgett	by Jerry W. Lewis	4	1,278
allocate different colors to each number Juliana	by Bob Phillips	2	1,278
Paste and Paste Special command are not enabled in Excel mcalder219	by mcalder219	0	1,278
OFFSET to include blank cells GMCN	by GMCN	2	1,278
Count the how many different values in a range beechum1	by beechum1	3	1,278
change first-name-last to last-name-first in a single cell? [email protected]	by CLR	2	1,278
How do i auto create multiple files from 1 with multiple sheets Kathy	by Kathy	0	1,277