View Full Version : Microsoft Excel Worksheet Functions

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 [98] 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160

  1. Help with LARGE formula with multiple worksheets
  2. Copying formulas too smart for itself...
  3. How do I formula a percentage with text values in the data field
  4. Calc End Date
  5. using ============
  6. Describe high/low range with CountIf (ex. count if >90 and <100
  7. Describe high/low range with CountIf (ex. count if >90 and <100
  8. Why is data automatically copying to all worksheets?
  9. how do I count a rota with no dates and using 24 hours clock
  10. SUM cells together based on 2 criteria
  11. linking sheets in workbook
  12. Problem with Formula
  13. Pivot table limit
  14. first positive value return date
  15. Can changes to a worksheet be applied to all wksheets in wkbook?
  16. sumproduct
  17. find partial values in cell
  18. macro or function
  19. Autorecovery
  20. This will test you!!
  21. data analysis option not visible
  22. asking again, macro to insert rows
  23. Searching an Alphabetized list for data, then RESORT
  24. How do I enter cell references in "Equal to" box in solver
  25. Drop Down LIsts
  26. vlookup
  27. Multiple functions per cell?
  28. How do you ...
  29. data tables in Excel
  30. Sum Count of Two Numbers in the same Row
  31. Excel Formula please
  32. How to sum items from column A only if Column B row equals X
  33. Inserting rows
  34. Count matching cells
  35. Quick-keys for FILL color?
  36. SUMIF Function Inside SUMPRODUCT Function
  37. cell to show ' 0 ' , or nothing at all, if the sum is a negative number
  38. Text Functions,
  39. Copying formats - column widths, formats, outlining to worksheets
  40. Excel Templet purchase order multiable pages
  41. Compile list of same cell from multiple worksheets
  42. Multiple Substitutes
  43. LOOKUP command
  44. Sum of Range of Cells
  45. What does @SUM mean?
  46. Enable Macros
  47. Exclude certain cells from printing.
  48. Conditional format of minimum number
  49. HYPERLINK IF referencing the cell of the function..
  50. Using MATCH() for an exclusive find?
  51. What does a $ in an excel formula do?
  52. Excel-Master
  53. Date Formula
  54. excel help
  55. COUNTIF - multiple conditions
  56. List of property names and values for a given object.
  57. SUMPRODUCT Acting Quirky
  58. creating and moving hyperlinks - Please help!!!!
  59. Automating Worksheet Names
  60. Return employee name when the employee's number is entered
  61. transfer information from one worksheet to another using a butto.
  62. Vlookup function question
  63. Macro Template File
  64. Custom menu
  65. lookup help
  66. Excel Solver violates constraints
  67. Help With HLOOK
  69. VLOOKUP on separate file: Works fine for a while....
  70. A bit of a Stumper
  71. Macro Help - Copying and appending data
  72. Collapsable Rows?
  73. How do I increment a formula?
  74. changing cell colors with formula
  75. Formula to determine whether number falls within range??
  76. Separate address column to Five columns
  77. Permutation in excel
  78. Rational exansion of a decimal number
  79. COUNTIF With Non-Continuous Cells
  80. Time Sheet to show hours owed
  81. Protecting Cells
  82. Permutation in excel
  83. Some help needed
  84. Percentage formula's
  85. Software to create color coded maps from excel?
  86. Finding Duplicates
  87. multiple pivot ranges
  88. need 360-day loan amortization excel spreadsheet template
  89. Rolling Balance after 30 days
  90. Re: Find function
  91. Need date to appear 90 days later than initial date entered
  92. Creating Scenarios and Scenario Manager
  93. freeze content
  94. Validation from Database (not sorted)
  95. How do you update links
  96. filters logics
  98. Countif function
  99. Find function
  100. use if function to change cell color
  101. create an array with unique items IN MEMORY
  102. dynamic connections in excel?
  103. random combination of letters
  104. Counting with Array Formula
  105. How to find MATCH numbers ?
  106. fill handle + query
  107. Can I get excel to auto save details from a cell into the doc nam.
  108. multiply the value of a cell
  109. How can I get rid this value "#VALUE!" in the cell
  110. Excel formulas
  111. Worksheet terminology
  112. how can i change the row from 123 to ABC
  113. If Then Statement in Excel
  114. Excel, Need some help
  115. Copy and paste from one spreadsheet to another
  116. Vlookup to find Second INstance
  117. blank cells
  118. Max Lookup formula
  119. Need to find 200 students from column of 1000
  120. Format a cell for hours ' minutes "
  121. Can Excel send alerts when due dates are not met?
  122. How to identify entries in a matrix also present in another list
  123. help locating first empty cell in a Column
  125. Indirect function - Limitations
  126. Please help....
  127. In excel, how can I create a towards column in a single box?
  128. A calendar calculator template that reflects remaing weeks in a ye
  129. Formulas not recalculating when values change on another sheet
  130. Counting number of occurrences
  131. Autofilter - can I increase the drop down font
  132. Cell value & hyperlink
  133. Another IF question
  134. How did excel get de-installed? Got error mssg: CiceroUIWndFrame
  135. I can't delete columns - help!
  136. Macros for the AR Aging Workbook template?
  137. converting number string to number with decimal
  138. Auto populating fields
  139. Re: Help
  140. lookup returns row number-why?
  141. The number of hours in a day cannot exceed 24...
  142. Allow unprotected cells to spell check after sheet is protected
  143. Summing on multiple conditions
  144. Sumproduct question
  145. Re: IF statement
  146. Moving Around a Blank Spreadsheet
  147. IF statement
  148. If Or?
  149. Using Sumif with 2 conditions
  150. Locating Last Nonzero Cell in a Row
  151. Populating several cells
  152. Limits of MINV matrix function
  153. Problems with an IF statement
  154. Ranked list
  155. HELP - Date Range In 1 Cell Calculation
  156. Downloading documents
  157. concatenate strings
  158. How can I use like a mail merge feature in excel to create a form
  159. How do you calculate CAGR In Excel 2003 with no initial cost?
  160. count unique phrases in a word table or spreadsheet
  161. Columns
  162. counting comments
  163. Average based on Hour
  164. Compare Side by Side in Office XP Excel
  165. lookup based on a row number
  166. select lines from multiple worksheets and write to new worksheet
  167. Hiding a row if date is filled
  168. Help to adapt Formula syntax to work with Visible Filtered Cells
  169. How generate trendline equations for Power, Exp and Log trendlines
  170. how to get rid of #N/A
  171. combining data
  172. Conditional Formatting
  173. Date Creation in Cell
  174. COUNTIF or not to COUNTIF on a range in another sheet
  175. how could I import a text file with comma separated values into ex
  176. how to use input formula from several worksheets in excel?
  177. combining 2 pieces of text from 2 columns
  178. Formula error in merged cells
  179. data validation list should have opt. to select based on criteria
  180. Print only cells with values
  181. Linkage data between two spreadsheet
  182. How do you add a-z (alphabetically) to your toolbar in micr works
  183. Make boxes apear on paper?
  184. output based on data in a graph
  185. Page Header
  186. Search feature in workbook
  187. Getting the first 3 digits out of 6 digit cells?
  188. Can't get list in Document Contents for workwheet
  189. drop-down list validation won't allow a different worksheet
  190. options under tools dose not come up
  191. Formula Assistance Required
  192. How do I define "contains' as the default custom filter?
  193. how do i get this
  194. Finding DUplicate Data set in Worksheets
  195. Locking a table
  196. Formula to determine number of Standard Deviations based on % of population
  197. Opening multiple Excel files that contain varied selected sheets
  198. What is wrong on the fomular: Offset(MIN(A1:A10),,-1)?
  199. Sales League table
  200. Comparing Two Spreadsheets
  201. Locking cells after one answer
  202. Re: Help with formula please...
  203. Help with formula
  204. calculating number of months from today
  205. countif
  206. Date functions
  207. how do I keep the dropdown list button visible continuously
  208. Excel 2003 Subtotals not working correctly
  209. Using countif with 2 conditions
  210. Can I use Excel to create this text file?
  211. Locking format
  212. ranking
  213. Re: Help with formula please...
  214. Re: Couple of hopefully easy questions
  215. Value of a Cell by Time
  216. Forecasting weekday occupancy between two years
  217. matching numbers in col a and col b
  218. Preceding a number by zeros, that is still a number
  219. using linest to generate 3rd order polynomial coefficients
  220. looping through a set of calculations
  221. I cannot convert using HEX2DEC formula? i need a plug in i think?
  222. Calculating Month Average Exch Rate from Exchange Rates Calendar!!!
  223. Adding Cells
  224. drop_down_box
  225. What is the shortcut key for adding $ to a cell reference eg $c$3
  226. =max(range includes #N/As)
  227. Changing positive figures to minus figures
  228. Optimizing mortage payback
  229. How do I get it to insert addresses instead of Next Record?
  230. When I move a vertical border it deletes horizontal borders
  231. add a column only if 5 other cells on the row satisfy criteria
  232. Vlookup Headache
  233. search value in a table and sum another column
  234. one formula to make a multiplication table work
  235. having a two tables on the same page with different widths
  236. Filtering Columns to Align Matching Data
  237. How do I count a value if another field = a specific value? Excel
  238. tab scrolling buttons not responding
  239. tab scrolling buttons
  240. Very Frustrating - Please Help!
  241. Converting CSV files into Excel files
  242. I Need Help with complex formula ?
  243. Avoiding #NUM!
  244. freeze other columns when columns have been frozen already
  245. dynamic defined ranges
  246. Vlookup for data contained in a cell
  247. Excel chart problem
  248. mixed font styles in the output of a formula?
  249. Sorting Identical Data set in a work sheet
  250. Need to compare 2 tables to generate 3rd table
  251. Need to get rid of blank rows without sort
  252. Need help summing time
  253. Cell references
  254. HELP ASAP get rid of blank rows without sort
  255. RE: Cell references
  256. formatting dates
  257. Creation of a Generic Macro
  258. RE: Cell references
  259. RE: Excel chart problem
  260. Please Help and Thank you!
  261. Matching data using date criteria...
  262. finding name within range
  263. Re: Conditionl Format
  264. Re: Conditionl Format
  265. Word Associated Shading or Color
  266. numbers
  267. Calculating two numbers in one cell
  268. vlookup over 2 sheets?
  269. Dates Not Formatting as Dates
  270. lookup cell content in multiple files
  271. Retuning a column number for a specific value
  272. trouble shoot pointing to a cell
  273. How do I change where Excel looks for templates?
  274. tab scrolling buttons - excel 2003
  275. is there a "distinct" function native to Excel
  276. Can excel sort entire rows of data like access?
  277. Lookup question.
  278. Help One Way did not work
  280. Conditional Formatting that will display conditional data
  281. formula change
  282. Multiple If Statements
  283. Adding numbers in a single cell
  285. Look up problem
  286. European date formats
  287. Comparing ranges and deleting
  288. extract data Column 1 starting with A1, A4, A7, A10, etc.
  289. Macro
  291. How do I split a cell of 2 words into two cells
  292. Re: Count &quot;how many in a row&quot;
  293. how do i find # hrs & mins. between 2 different dates and times
  294. Contains instead of Equal
  295. Help Needed Urgently
  296. Connect columns, with restrictions
  297. Count &quot;how many in a row&quot;
  298. Re: Count &quot;how many in a row&quot;
  299. Adding time Values up in Excel
  300. format column for unique values only
  301. move from one column to another after a set condition
  302. How do I stop Excel from treating blank cells as zero?
  303. Make a formula that adds every 4th cell in a column indefinately?
  304. Copy and paste from 1 workbook to another
  305. Display "Last updated date" for the Workbook (without using a macr
  306. What is the spreadsheet function in excel
  307. Non-random numbers generated by excel's data analysis random gener
  308. Counting cells
  309. Subtotal results without word "Total"
  310. how do i calculate time in & out in excel using a formula
  311. Frequency of values with Criteria
  312. If typed 12805 then 12/8/05
  313. link help
  314. How do I sort entire spread sheet. Names w/data
  315. linked cell is displaying formula instead of the data
  316. Your online office "help" system REALLY sucks!! I'm not kidding!!
  317. vlookup almost does this but not completely...
  318. Delete repeated Cells
  319. #Value error when linking workbooks
  320. 2 different Companys. Data Sort
  321. Information from column to row
  322. finding if name within range
  323. Contents of cell
  324. error N/A
  325. Lookup
  326. organizing a workbook
  327. using getpivotdata function
  328. vlookup reverts to data from a previous report
  329. Functions not "recalculating" when input changes ???
  330. Merge & Center function is turned off...how do I turn it back on?
  331. using a checkbox for a conditional function
  332. Copy Cell Referecnces
  333. Text from Max value
  334. How do I randomize ascending data (number values) in excel?
  335. I want to add automaticaly my postponed check in my banking regis.
  336. Multiple coin flips in a single cell
  337. Sumproduct not working when summing values between two numbers
  338. Prevent Worksheet Deletions
  339. Pivot Table - 'Merge Labels' option and formatting
  340. Reformat IF(ISERROR(....) : if 1st option returns empty, look at 2nd option.
  341. Shared files
  342. How do I reconcile bank statements?
  343. How many std deviations is Excel function "STDEVP"
  344. Locate and retrivie data in table/matrix
  345. attendance sheet
  346. Frequency within date range
  347. File won't open. Error message "too many different cell formats"
  348. Pulling data from another workbook
  349. Format single column cells to be 6 characters long
  350. Pivot Table Question
  351. Use functions when cells are merged
  352. Select one of many clipboard item to paste into document
  353. using filters with the sum function
  354. how to format only a specific character or number in each cell withina range of cells
  355. Delete Rows where cells does not meet criteria
  356. How do I quickly fill a formula result into a column of cells?
  357. printing problems
  358. DATEIF Name error
  359. Arrays
  360. can you filter more than two items in excel 2000
  361. Workbook & multiple spreadsheets
  362. Pivot tables and total count
  363. =CONCATENATE() help!
  364. conditional formatting autoshapes
  365. Help with Formulas
  367. Fill handle formula
  368. Pivot tables - calculated fields
  369. Trying to freeze panes. line down and through middle of worksheet.
  370. Showing Garbagge in my File.
  371. Interpolation using GROWTH function?
  372. Fill down to nonblank rows
  373. creating function (vba) with range arguments
  374. Protection-exceptions to delete a row
  375. Copy & Paste macro
  376. Summing specific cells!
  377. Subtraction formula for consecutive cells in a column, skipping blanks
  378. Auto number invoices in Excel
  379. XIRR function not defined?
  380. Excel sheet question
  381. 1430 to 2:30pm
  382. SUMIF problem...
  383. Average Function Help Needed
  384. =(A6)!$O$14 - why won't this look for same name sheet as A6?
  385. Summing accross sheets
  386. is there a percent error function in excel?
  387. removing year from date
  388. Put comments on a locked spreadsheet even though cells not locked
  389. if function
  390. Splitting Character String
  391. Remove apostrophe
  392. Need help with formulas
  393. Dro pdown list formulas
  394. halves
  395. Excel formula for monthly interest rates
  396. Referencing worksheets
  397. Smart tags for financial symbols
  398. Re: If
  399. Re: If
  400. Re: If
  401. How do I create a weekly series?
  402. Compare two lists with two variables
  403. return a cell contents as the result of usiing "small"
  404. if statement problem
  405. Need Help Writing a Formula
  406. Delete repeated numbers in Excel
  407. delete repeated numbers
  408. comparing two columns & then perform a calculation
  409. Sort from lowest to highest
  410. Excel should have a tan^-1 Cos^-1 and sin^-1
  411. display minutes and seconds in excel
  412. Re: ifsum slows down calculations
  413. How can I count values greater than and less than certain values?
  414. Apply cell shading based on adjacent cells in EXCEL
  415. EXCEL: IF CELL B6 RED, HOW DO I GET A "W" (ie for win)to show up
  416. serial number cell
  417. Find and Concatenate
  418. Range of data within a column
  419. Another Nesting IF Statement Problem
  420. Pivot table grouping of dates in row fields will not work. Why?
  421. Formula Help with Lists
  422. nesting if statements
  423. Summing only those cells that aren't hidden
  424. Random Numbers
  425. preserve "-" when importing text field from access
  426. SUMIF excel function not working
  427. How do you convert embedded drop-down lists in Excel '97?
  428. How to replace a word with a word from other column?
  429. counting unique values and matching to quantities
  430. What formula would I use to get -2 / -2 = -100%
  431. linear interpolation function in excel
  432. How to record macro to print pages modified today
  433. Controlling text in an Excel worksheet
  434. Concatenate and Vlookup
  435. Don't know what to call what I need?
  436. Re: can you entre a bar code into a excel cell?
  437. Help with conditional format
  438. Type in letter return word
  439. Please assist
  440. Linking cells
  441. Function
  442. Count cells with condition
  443. Is it possible to put 2 splits on one page? If so... How?
  444. Using dates in formulas
  445. My DCOUNTA formula results do not display in Excel.
  446. keep date format in a Combo box
  447. Fill-in empty cells from SAP report
  448. automatically insert row at each page break
  449. Conditional Average
  450. VBA Custom function for lookup
  451. % change in the last two cells in a row
  452. 27 sets of data. Need to find zero in each set
  453. Help writing an Excel Formula
  454. converting a number to English text ( not to Baht) is needed
  455. Count the number of Cells in one ROW with conditions
  456. How Show decimal in Bar Function
  457. How to pluck out initials of a 2 or 3 word name
  458. Count occurances Problem
  459. Div/0 error
  461. return left most part of cell
  462. Index question
  463. Excel should let me sort by colour
  464. How can I get excel to look up prices in a table
  465. Conditional Formatting Reference / Inserting Rows
  466. special sum formula
  467. Evaluating Rank to determine formula
  468. commission spreadsheet
  469. IF Function??
  470. Evaluating results of a concatenate formula, as a formula
  471. Sumproduct.................
  472. Determining a specific time during the day
  473. Regression Statistics are returned as Rounded to 1 vs. several dec
  474. Close excel do not save
  475. Check box, then add current time to cell
  476. text function
  477. How do I calculate a future date in excel?
  478. delete spaces
  479. Using offset more than once on the same sheet
  480. format social security number
  481. Counting occurences of a substring in a range of cells.
  482. Complicated formula
  483. Compare two different size lists
  484. if function multiple variables
  485. Unhiding multiple worksheets in Excel 2000
  486. cut and paste subtotal from excel
  487. creating a excel spread sheet using ffinancial functions
  488. Looking for experience with counting and conditions in excel 2003
  489. Re: Using COUNTIF for Counting Words?
  490. countif OR function
  491. VBA function for "Mean" using Array as argument
  492. How do you sum just values that are bold in a list of values?
  493. separate text into different cells
  494. Refer new sheet to previous sheet
  495. How do I select on two variables in a range of data in excel
  497. how to return mulitple corresponding values
  498. Warning - "Fixed objects will move"
  499. Repeat calculations
  500. Fair Play
  501. Calculation of full hours
  502. Function for decreasing salary by 2.5%
  503. Count cells with specific values in the cells next to them?
  504. How can we see two different excel sheets on one screen?
  505. Can a UDF be used on an array of cells?
  506. Help with a Date Formula
  507. calculate payment with first payment due date variable?
  508. Counting .5 in a pivot table
  509. Count or result of matching cells
  510. Experienced any problems with nested subtotals using Windows XP
  511. List box, copy multiple Cells
  512. Moveing Data to another Worksheet
  513. How do I prevent a formula element from incrementing when copying
  514. How to highlight an Excel row by clicking on a cell
  515. Select different source data for a PivotTable
  516. How do I prompt a user to update a cell value (ie the date)?
  517. return cell reference from any column
  518. ... Count, <<< Positive Values minus Negative Values >>> ...
  519. Filtering data and replace on to an new worksheet
  520. networkdays
  521. Formulas not updating until save
  522. countif - Criterion1 OR [Criterion2 AND Criterion3]
  523. Format of CSV File in export
  524. Macro help!
  525. Weeknum & Year
  526. Insert manual line break in formula
  527. Extract each item in the list
  528. Any function for Crop/Cut Text
  529. Percent of total in Pivot tables
  530. INDEX and workbooks
  531. VLOOKUP in SUMPRODUCT array
  532. #Name? Error when using NETWORKDAYS function ......
  533. Colour (color) problems
  534. Vlookup
  535. Counting Occurrence of Text within Text in Cells in Range.
  536. How do I convert a given number into a letter?
  537. What do I need to do here please.
  538. problems with macros
  539. Asking for Formula ~ Thanks!
  540. Verifying Dates
  541. Translate WEEKNUM result into a date
  542. Getting Yahoo Stock Quotes by a USer Defined Function
  543. MODE isn't working properly.
  544. Financial Calculation Help Needed -- Annunity
  545. combine the two into a single formula please
  546. Sumproduct + Array Function?
  547. Help on Networkdays
  548. ok for the first but I would like the first 2 Left please.
  549. ok for the first but I would like the first 2 Left please.
  550. ok for the first but I would like the first 2 Left please.
  551. Excel 2000 to 2003 update links doesn't work properly any suggest
  552. How can i italicize a word via a formula?
  553. Count Occurances if two conditions true
  554. Convert Range name in cell for VLookup
  555. VLookup returns #VALUE!
  556. RE: Track changes across multiple worksheets
  557. Need Help: 'sheets' function with a variable in a formula
  558. countif >0, specific cells
  559. finding the right number
  560. Linking Columns and cells
  561. Problem with a "if" "then" situation.
  562. formula for finding a value!
  563. dates and if statement work on one sheet, not on another
  564. How do I use space provided for Company information
  565. How do I get custom views created in Excel 2K to show in Excel 200
  566. Dynamic Time Display
  567. Countif not blank
  568. Need help with lookup on text format
  569. ActiveX works in my spreadsheet but when sent to others, doesn't
  570. Counting cells that meet 2 differnet criteria
  571. Functions not "recalculating" when input changes ???
  572. Formula for rounding to the nearst eighth of one percent
  573. Excel Font Effects should include Upper Case
  574. Re: function for finding a value!
  575. Sorting by text colour
  576. Excel: Format Control: 'cell link' reamins constant. How to copy
  577. Creating Macro or Code Help?
  578. Sunrise / Sunset
  579. Import Data
  580. Formatting cells is not retained when saved as csv file
  581. Need assistance with printing macro
  582. Sorting Data
  583. Can we have custom Column headers instead of default
  584. Annual interest rate
  585. running balance in excel
  586. How do I find a name in a list of names?
  587. How can I get the domain name out a email adress?
  588. what is the formula to change 08/14/51 into 1951?
  589. Count occurances in range of cells
  590. How do I use VLOOKUP to find values across more than 1 sheet or Wo
  591. How do I keep with column widths of a pivot table when I refresh
  592. VLookup on two criteria - Not two dimensional
  593. excel function help
  594. sum using reference from other worksheet
  595. Lookup function, need help
  596. Automated file name retrieval and updates
  597. Analysis ToolPak Translator
  598. in a line of three possible answers how to prevent multiple answer
  599. excel files into money 2005
  600. How do I retrieve a date in a column of dates which > my criteria
  601. Return to individual sheets
  602. Linking total amounts
  603. sum and variable rows
  604. Disabling protected cell selection
  605. Formula which is greater tahn or equal to zero
  606. Create a single sheet from many sheets
  607. Comparing dates
  608. Can a conditional formula indicate "date added" next to a text?
  609. Vlookup Calculation Issue
  610. Cenvert dollar amount into words
  611. no formula results in cell
  612. I need a template for my supply inventory
  613. Auto convert an alphanumeric string (CIS9638S) to numbers only?
  614. RE: Auto convert an alphanumeric string (CIS9638S) to numbers only?
  615. Arithmetical Mode Value for Filtered cells in Multiple Adjacent columns
  616. If column c # is 101..then column e is $14.32 & column g is $8.00
  617. How do I calculate and show negative time in Excel?
  618. RE: Auto convert an alphanumeric string (CIS9638S) to numbers only?
  619. roundup within a formula
  620. RE: roundup within a formula
  621. i need help with a calculation formula...
  622. Sort with a List
  623. Excel 2003 - Copy Cell Reference
  624. Multiple Item Replace???
  625. How do I show negative number in brackets using excel?
  626. Add money to a sum
  627. Data Entry
  628. How to add equal values and than replace them with their sum?
  629. Formula with current Date
  630. Re: Date format
  631. Copy a cell value and add literals
  632. Multi - Level Question involving Data Mapping and Formulation
  633. Identifying Dups in different ranges
  634. Count IF problem
  635. Need to find a row in a worksheet based on the value of a cell
  636. Statistical functions query
  637. Function to ignore decimals
  638. Creating Worksheet Using Server Object
  639. If statements
  640. Transposing Data
  641. Creating Worksheet using Server Object
  642. I want to make three sub colums under an original colum
  643. How do I copy a function with a called cell constant?
  645. VLOOKUP for Zip Code Ranges
  646. Formula
  647. Is the IRR calculation based on cash flows at beginning of year?
  648. Conditional Formatting
  649. Can I show a formula's result on a worksheet tab?
  650. Ladder Help
  651. change case in excel
  652. Using boolean function for color fill
  653. Re: Truncating text before a hyphen
  654. Truncating text before a hyphen
  655. Formulas and worksheet linking
  656. IF Command conditional formating
  657. find position of a number in a string
  658. League Tables
  659. What Function to use?
  660. Require alpha-numeric entry
  661. How to share a workbook to our staffs
  662. Solution Required to prevent #Ref! when rows deleted
  663. Re: Function or number depending on input
  664. Discount rate - what to use?
  665. Filtrera Pivottabell
  666. IF formula?
  667. Calculate Date range
  668. Adding and Naming Multiple Worksheets
  669. Subtracting a Countif result from a constant
  670. Multiple Regression in Excel 2002 SP3 (Office XP)?
  671. Cell Separation
  672. Separate Column Sorting
  673. how to convert numeric into alphabet
  674. to convert Minutes into Day:Hr:min (not as fraction)
  675. box formatting
  676. how to add or subtract from two cells into one
  677. Returning the formula in another cell
  678. Exporting multiple cell contents into word document
  679. Box-Jenkins techniques & Time Series
  680. Formula to duplicate data to second sheet
  681. How can we get more columns on a spreadsheet, like 365 days/colmn
  682. I only want to print the horizontal lines in a spreadsheet
  683. conditional sum formula
  684. Re: Change to formulae
  685. Re: using text as a cell ref
  686. Option Button Help
  687. Solver, macros Excel
  688. How do I protect only formulas(functions) in a workbook?
  689. Format of one cell conditional on another
  690. Excel worksheets
  691. First part of "IF" function returns false even if true. ??
  692. Check for double entries in a row
  693. Re: Help with a Ladder
  694. Re: calculate numbers based on font color?
  695. How to change a series of positive numbers to negative numbers
  696. Sum function based on format
  697. RE: date function
  698. Re: date function
  699. Conditional sum
  700. Counting a Filtered Dataset
  701. Re: How many users can sucessfully use a shared excel workbook?
  702. Re: Colomn of strings, how to count each string with "abc" OR "def"
  703. Re: Trying to pull date from field getting error.
  704. Re: Function or number depending on input
  705. Re: Conditional Formatting
  706. spellnumber function
  708. Pls Help!
  709. Asking for formula~thanks!
  710. Increase figures in cells by a percentage (on entire workbook)
  711. average of kth largest numbers in an array of n numbers
  712. formula's in cells are not calculating
  713. how do i create range names ?
  714. Coloring certain cells
  715. Nested "if" not returning expected value
  716. Excel Idiot Needs Formula Help!!
  717. How to get the complete list Excel Worksheet Functions
  718. Complicated Index Match Offset function
  719. Hide #DIV/0!
  722. Using Name as Worksheet Reference
  723. How can I have excel sort through a data string of dates?
  724. Formula problem
  725. HELP-Can not type on Spreadsheet
  726. I cannot change spreadsheet to rewritable
  727. Carrying formatting automatically to new W/S
  728. Need help with Vlookup
  730. Different results from AVG funtion
  731. Novice Needs Help with Formulas
  732. References and links.
  733. monthly total
  734. adding formula to existing database
  735. lookup finding the next value that is GREATER
  736. Hyperlink.
  737. In Excel Sheet any digit repeat
  738. filter 400 names from list 1 from list 2 with 4000 names
  739. students grades, formulae to calculate what grade is needed based.
  740. auto fill a number
  741. Re: calculate the number of words in a row whose length is greater than 2
  742. IF function with 14 nested levels
  743. list 1 has 400 names List 2 has 4000. find manes from list 1 on 2
  744. find names on list 1 in list 2. list 1 4000 names list 2 400 name
  746. how do i add 1 year to a date formatted cell?
  747. SUBTOTAL(9,range) Does NOT work in AutoFilter
  748. calculate the number of words in a row whose length is greater than 2
  749. Column formating help!
  750. Set value for a cell basd on another cells value using an incremen