PDA

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