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

  1. format for 30 years amortization?
  2. Date function in Excel that updates only when a doc is changed?
  3. Find the date for monday prior to May 25th
  4. Construction Loan Interest Formula
  5. Can you auto-trigger a sound file to play when a worksheet opens?
  6. Counting Entries by Month and Year
  7. SUMPRODUCT Question
  8. How do I remove a function?
  9. Smart Tags and Stock Symbols
  10. Convert function
  11. Propogating next available field
  12. Sort and New sheet help
  13. Combo Box Functions
  14. Active Cell when opening workbook
  15. Setting page length in Excel 2003
  16. draw a floor plan to scale in excel
  17. Problem with whats Returned
  18. Convert 1 688 090,69 to normal numeric value
  19. Group and Outline Adjacent Columns
  20. COUNTIF
  21. dependent rows
  22. sumproduct problem
  23. cell reference from hlookup
  24. Pocket Excel - Loss of formats when transferring
  25. Unique identifier
  26. Excel Help Needed
  27. Where are my gridlines?
  28. FORMULAS
  29. How do you create formulas in pivot table eg simple division?
  30. calculating the years
  31. Sumif help please
  32. Substitute Formula
  33. SPREADSHEET DATA
  34. Calculate percentage of time period
  35. automtically change ranges in formulas when new data is entered
  36. DATEVALUE & Empty cells
  37. Setting up a condtional function that....
  38. VLOOKUP Questions
  39. how do i get my spreadsheet to give me tank gage amounts.
  40. Purchase order & Invoicing
  41. XNPV vs. NPV(quarterly) different results
  42. How do I calculate a difference in work days?
  43. Lookup help
  44. how do I calculate hours spent x an hourly rate?
  45. IF / Else Format help needed
  46. Data Validation Help
  47. Use Tab key to move between tab sheets
  48. How do I update a drop down box in Excel?
  49. Validy check in one coulmn to limit input options in another?
  50. Formula Help - please
  51. i need to get totals in diff catagories
  52. Re: Need help with some data manipulation - to Biff
  53. Validation drop-down lists
  54. Bi-Weekly Timesheet Template
  55. Sort Macro to Exclude Blank Rows?
  56. How do I set up a nested SUMIF formula for a number of variables?
  57. Muliplying a number by a blank cell
  58. Removing a word
  59. Ghost numbers in blank cells
  60. Emi & Fv!
  61. How can I set a minimum value of zero or -100% in a cell?
  62. How to hide columns that are not filtered?
  63. Series Formula Help
  64. I need help desparately with PROPER formula...
  65. If statement help please
  66. left padding + blank
  67. Copying formulas to a different file without path in the formula?
  68. Excel Project rollover for 2006
  69. Summary Based on Multiple Criteria
  70. constraints
  71. Greater than formula
  72. Protect Area
  73. Locate first number that exceeds reference value
  74. sumif or sumproduct
  75. Step through a row of data
  76. HLOOKUP last match in a table
  77. Data Validation
  78. NOSMSDIST Limit
  79. Sumprodruct
  80. Complicated
  81. COUNTIF - I THINK
  82. Countif Special case
  83. Move Data from rows to columns...
  84. How do I compare two columns contents for differences
  85. Parse data with uneven lengths and different delimiters
  86. Round X.50 and less down, X.51 and greater up
  87. How do I sort a column of IP addresses ?
  88. add new value to exhisting, (cummultive)
  89. Converting All Caps to Proper casing
  90. What does the second parameter in ACCRINT do?
  91. searching for repeating text
  92. Searching a Range for a number over 40
  93. Can't install add-in
  94. lookup and show all results
  95. Selection sticks in Excel
  96. Criteria problems in the DSUM function
  97. Calculation help
  98. Validaation List
  99. How do I set a minimum result value in an Excel formula? IE >100
  100. Excel Help Needed!!!
  101. group multiple data in different sheet
  102. Validation List
  103. formula help please
  104. Calc mode display on worksheet
  105. Updating tables!
  106. print highest character number
  107. Lookup min max values
  108. merging the layout only of 2 cells
  109. I am looking for a calendar with weeknumbers.
  110. sumproduct help
  111. Time differences in excel
  112. formulas spanning overlapping years
  113. display formula instead of its values in some cells
  114. repeated use of edit/find without closing to change records
  115. Simple Function question?
  116. Autofilter SORT that Ignores Forced Blanks ("")
  117. Macro to Name Tables
  118. excel 2003
  119. flexisheet problem
  120. Indirect does not recognize full server path?
  121. calculate month
  122. Averaging the top 2/3 highest numbers
  123. Conditional Formatting not giving correct answer...
  124. Weighted Average - Copy Function
  125. rounding down another cell with a formula
  126. can excel automatically enter the date data in a cell was entered
  127. How do I populate a cell with another cell's value based on condit
  128. How do I use an "IF" formula using dates in excell?
  129. Changing multiple formulas at one time
  130. Basic VLOOKUP Help
  131. CONCATENATE text formula
  132. Links in Excel
  133. vlookup and microsoft access
  134. GetFormula function- Need help showing formulas only-
  135. making drop box in excel sheet
  136. Sumproduct Help
  137. Save Worksheet vs Workbook
  138. How do I copy a formula to another cell
  139. Running a query and/or 3D Referencing
  140. how can i do a conditional format in a PivotTable?
  141. VLOOKUP
  142. conditional formatting to multiple cells
  143. looking for name of cell
  144. Using and IF functio between 2 worksheets.
  145. What is the formula used to keep track of totals for a column?
  146. Web Link in Cell
  147. How do I set up a price sheet in excel.
  148. Search Word
  149. I'm not even sure if this is possible anymore!
  150. Averages from 2 columns
  151. AUTOMATIC UPDATES
  152. Rounding Up or down to 1/2 Units
  153. Can you call functions between sheets in the same book in excel?
  154. Please Help! vlookup & match with multiple variables
  155. find&replace macro
  156. splitting data from 1 column into multilple?
  157. Is there a way to...
  158. trying to open a lotus file in excel, it won't work
  159. random number generation
  160. How to sum a row of cells containing an error message to overlook
  161. Subtotals
  162. Selective summing of table items?
  163. I need function that can list the "top ten" highest results
  164. Finding Asymptotes from a set of data in Excel
  165. How do I repeat rows that are not connected?
  166. I cant see my excel spreadsheet but only in Print Preview?
  167. Copy variable ranges fron difernte shets
  168. Lookup cross Drop down/scroll box
  169. replace value in excel?
  170. total a time column that is formatted as ddd:hh:mm:ss .ddd=days
  171. How do I create multiple worksheets from Page Pivots
  172. move one cell up from result cell
  173. Can I create a drop-down list that will reference other drop-down
  174. Formula to add top 4 entries in a column and total them at the bot
  175. GMT/UTC considerations
  176. formula help
  177. Merge two form to One
  178. credit calculations
  179. Format\Conditional ? help
  180. Excel Question
  181. convert number to letters
  182. Worksheets
  183. Excel cash flow formulas
  184. Re: Conditional Formatting when inserting a row
  185. sheet with dates
  186. Keeping the exponent at a fix value in Excel
  187. sort
  188. Using an "IF" Function between 2 Worksheets
  189. Keeping an acculumative total in a row and only that row.
  190. Staying it its own directory.
  191. Hiding zero values
  192. Re: Maybe VLOOKUP ??
  193. how do i do this?
  194. Web Query: Obtaining source link from a cell
  195. Currency, Percent and Comma Style buttons
  196. Re: how do i do this?
  197. Re: how do i do this?
  198. Need macro to copy a list of named cells between worksheets
  199. Cannot Reference "Array" in Subtotal Function
  200. Re: Maybe VLOOKUP ??
  201. A URGENT problem about the array functions =TABLE
  202. How to show negative in cell?
  203. Need help with A 3-D reference type formula (real novice here)
  204. CAN I GET MY ANSWER THROUGH E-MAIL IF YES WAHT IS THE E-MAIL ID
  205. Re: Vlookup with multi values
  206. One workbook file will not open in Excel
  207. Re: Looking for another way
  208. IF formula question
  209. How to use HLOOKUP or other command to find a value within a range
  210. To add a name of label on several sheets.
  211. To add a label name on several sheets
  212. Keeping the exponent at a fix value in Excel
  213. Converting Rows into colums(Urgent)
  214. Lookup in one column, and return value from another column
  215. How do you delete a List?
  216. SUMIF non-contiguous range
  217. How come I only get 4 variables shown on my data table in chart?
  218. Lookup word and value
  219. Combining Data from Multiple Columns
  220. How Do I Add Dates in a formula?
  221. How to show zero for #DIV/0!
  222. Losing the #DIV/0!
  223. Totals based on meeting multiple criteria
  224. Dialogue with Java
  225. Sunday to Saturday weekly foreward planner
  226. How to combine data from two columns into one column?
  227. RE: Resource Planning - How to Model?
  228. Excel Sort Tie Breaker
  229. Keeping the exponent at a fix value in Excel
  230. Totals by type between dates
  231. Count between dates by type
  232. Enter Comment for an Entire Column
  233. How to show negative percentage?
  234. Pivot Tables
  235. Date help please
  236. average and stdev from groups of data
  237. Help with a complicated search function in Excel
  238. MODE() is there a way to return bi-modal or multimodal results?
  239. Strange Vlookup problem
  240. Formula to pick out number values
  241. validation
  242. Client list price update
  243. Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?
  244. Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?
  245. vlookup formats
  246. Conditional Formatting x Draw (Circle)
  247. Split email address into seperat columns
  248. COUNT IF - MULTIPLE CRITERIA
  249. D1: '=A101', D2: '=A201', D3: '=A301' how to do this...
  250. Help me write a function please?
  251. Countif Function, complex criteria
  252. Pivot Table Field Data
  253. How can you remove a redudant Excel link
  254. How to autofill strings
  255. Generating a report
  256. Need help calculating overtime to date
  257. jbf frylock
  258. Nested SumIf statement
  259. Why can't I use SUM when pasting HTML code into new sheet.
  260. UPDATING IMPORTED DATA
  261. Compiling Data
  262. Helper Formula To Identify 1st Instance of a Value
  263. Working Weeks
  264. How do I count items within a date range in Excel?
  265. Simple interest, multiple payments, loan balance
  266. Macro to move a row from one table to another
  267. Date function
  268. Rounding error in Stdev function result.
  269. stop insert from changing cell reference
  270. Finding days between cells C and L where the cells may be empty
  271. formulas
  272. How do I find the largest in a column
  273. Counting cells not containing specific text
  274. a sort of GROUP BY data extraction question...
  275. formulas\conditional formating
  276. formula references vertical cells in a separate worksheet
  277. When I select from drop down menu I would like the next column to populate a specific cost.
  278. template to use to track employees
  279. Data ranges within a column
  280. automatically updating "school event record" formula
  281. Counting occurrences over range of sheets
  282. Automated Reporting
  283. Creating a table based on rank
  284. Averaging excluding min and max numbers
  285. Auto Coloring a Row
  286. Copying a formula to multiple worksheets
  287. combining cells
  288. Re: Find LARGE, and th cell 3 cells to the left?
  289. Function to find only exact matches in spreadsheets?
  290. how to extract a specific range of days (7 or 30) to make a chart
  291. Rounding Subtotals
  292. Reference External Worksheets & Protect Worksheet / Workbook
  293. taking out lowest 2 values
  294. copy down an indirect formula
  295. Something Along The Lines of a SumIf, but not
  296. How do I count values across multiple columns?
  297. Leap year date problem
  298. need help with functions
  299. how to get column totals on each page?
  300. can I lock just the formular in a cell
  301. Add protect worksheet password in macro
  302. Grand total in Pivot-Table
  303. IF/WHEN forumla fo when a cell is between two numbers
  304. IF/WHEN forumla fo when a cell is between two numbers
  305. IF/WHEN forumla fo when a cell is between two numbers
  306. How do I sort a range of cells via a worksheet function
  307. Create a Value for a cell
  308. How do I generate a new sheet based on date/week/month?
  309. location of cell
  310. locating the top 5 number (in a col)
  311. If they are or not?
  312. Convert Hours to Decimal
  313. Conditional MS Query
  314. Lookup Two Columns - Again
  315. pivot tables
  316. formula gives 2 different answers
  317. Looking for the truth !!
  318. File reference
  319. Please help with enclosed schedule of duty
  320. Nested IF.. is it the right one to use?
  321. how do i convert weight (stones+llbs) to llbs?
  322. import von konstanten workstation - daten
  323. Using INDIRECT in INDEX(LINEST.. ) function
  324. Determine number of days
  325. importing fixed machine data to excel
  326. exporting e mail adresses from Excel into Outlook
  327. Character Count
  328. Formulas, question for Roger Govier
  329. How do I format tabs to automatically go to next cell I want
  330. Edit/Move or Copy Creating .xls on Tab
  331. =If() results based on cell color?
  332. Excel Formula with two clauses
  333. Double lookup count
  334. Sort referenced sheets together!
  335. In Excel, how do I look for the last number either 0 or 5
  336. In Excel, how do I look for the last number either 0 or 5
  337. RE: Divide Monthly Sales Budget to Day Budget
  338. Re: Divide Monthly Sales Budget to Day Budget
  339. help with an if statement
  340. basically want to go from mm/dd/yyyy to yyyymmdd
  341. Excel Charts - Time line for random points on X axis
  342. Macro with Array Function Problems
  343. Lookup
  344. How do I change the Tab spacing in Excel 2003?
  345. How do I find a % difference between two numbers (comparing 2005 .
  346. Comparing Birthdate to specific date in the future
  347. Freeze pane
  348. Fill Sum of months by quarter
  349. How can I add rows inbetween?
  350. Cumulative Sums in Pivot Tables
  351. Need to revise formula
  352. Need to revise formula
  353. Need to revise formula
  354. count colored cells?
  355. COUNTIF with Logic?
  356. can conditional formatting on one cell value to another cell valu
  357. how do you find a excel spreadsheet that you replaced with a new
  358. need a template for quilters/crafts for things to make
  359. I need help with the IF Statement
  360. Overline the sum instead of underline the number
  361. I want to print at 100% but prints only at 60%
  362. Is there a simple solution?
  363. Recorded Macro to Copy Format
  364. Conditional Worksheet Access Question
  365. Why does Excel change the dates I input?
  366. COUNTA
  367. How do I make the Stop Recording bar pop up when recording macros
  368. excel 2003 right-click function not working
  369. Can this be done...?
  370. Auto Calculation not working
  371. adding/subtracting time
  372. Create drop down box with the formatting of range cells colors ect
  373. do you know how i can find the f(x) of the arctan?
  374. I can't drag a worksheet to sort
  375. Formula to retrieve range of dates from a worksheet to calculate d
  376. conditional formatting with four conditions
  377. Excel
  378. Need help with a formula
  379. IF Function!?
  380. is there a problem with hyperlink in excel 2003
  381. How can I copy and paste an entire workbook?
  382. Unclear about hot to automate searchs
  383. How do globally clear pre-marked cells
  384. Linking two "total" pages to create a "Complete Total" page
  385. How do I copy just the "web page name"?
  386. to search for a string and affect data if it finds the string?
  387. SumIF
  388. Copying formulas referencing multiple sheets
  389. New a little help
  390. Conditional count of rows dependent on multiple columns
  391. Working with Arrays
  392. Formatting in Excel
  393. Finding Maximum
  394. Auto Fill Cells, When Choosing From Drop-Down List...
  395. solve a inverted matrix
  396. Add 15 minutes
  397. time sheet that takes out taxes
  398. Mode - getting bi- and multi-modal results??
  399. Want to compare two columns and then fill with data from the match
  400. Solving sets of equations
  401. List Object and Protection
  402. Iterating files in folder
  403. How to make drop-down menu of months in schedule,when сhoose it - columnes are added?
  404. Matching Data in Columns
  405. COUNTIF multiple crietria
  406. PivotTable -adding more than one function
  407. #VALUE in formula as opposed to result
  408. How do I get the unique values from a range?
  409. Formula question
  410. Is there a simple way of removing duplicate data in Excel?
  411. Grouping in Pivot Table
  412. How can I make a formula in Excel showing when the file modified?
  413. how do I setup a formula for a same range of cells on 12 sheets
  414. formulas producing unjustified results
  415. How do I delete rows with negative values all at once i.e. 47,000.
  416. Text box acting as a notifier?
  417. COUNTIF-how do I count the quantity of 'H', as opposed to 'h'?
  418. Does such a function exist ?
  419. Combo box from MSQuery
  420. CARET or ^, as in CTRL but CTRL !!! ???
  421. DCOUNT? DSUM?
  422. Change the text format for weekend days (Sat, Sun)
  423. import excel data into existing excel report
  424. Shortcut for wrapping text
  425. Vlookup return 0 when cell is blank
  426. Autofill a series
  427. Copying all formats from worksheet to worksheet
  428. Precision in formulas?
  429. Seeking help from a GURU
  430. Day / Date Formula
  431. how to add many cells on diff. sheets and put in 1 cell in excel
  432. Problem with Subtotals
  433. conditional fields in a picote table (I think)
  434. automatic list
  435. Graph
  436. Macro that filter data
  437. Mathematical elimination
  438. EAN/UCC-14 Barcode: set Excel column widths based on a cell value?
  439. business days - trade date plus 3
  440. Please Help!! Macro error
  441. How do I copy a column into a row and keep the links?
  442. Take a list from one workbook and apply asdropdown in another work
  443. How do I change the default folder when I import data?
  444. Apology
  445. if cell has been changed...
  446. Is there a SUMPRODUCT-like function that I can use on text?
  447. Fv & Emi!
  448. Different print page setups on one worksheet?
  449. Need Help
  450. way to get jus the number off the cells that have functions in them
  451. Finding All but Last Word
  452. can lookup return err if no match found
  453. what is the underlying formula for the percentrank function
  454. Protecting Worksheets
  455. Is there a Function for Appreciation
  456. Totals of calculated field in pivot table give incorrect results
  457. RE: Tex Dates to numerical Dates
  458. Count Cells if diff cell meets conditions
  459. Lookup and paste as value
  460. importing csv files, problem with date formats
  461. the name tabs at the bottom of each page, how can they be made big
  462. Conditional Auto-Population
  463. Keeping track of Sickdays, Vacation days, and hours for each.
  464. is there a way to auto copy cells similar to auto sum?
  465. Average function question
  466. Repeating Rows
  467. color coding
  468. making changes
  469. Comparing two lists and return specified data
  470. Comparing two lists and extracting data from one to another
  471. sorting by date
  472. Number value based on date function
  473. I'd like to make a formula that does this..
  474. Return value if cell greater then 0
  475. linking cells in one worksheet to cells in another worksheet
  476. Help With Formulas Needed
  477. Repeating a Macro For Each Selected Worksheet
  478. Excel Link problem
  479. time problem or excel mistake
  480. How do I make items repeat on a pivot table?
  481. Insert times including seconds?
  482. IF formula - evaluation shows it should work but...
  483. Added new columns - Pivot Table not refreshing - why?
  484. SORTING DATA TO ANOTHER SHEET
  485. SORTING DATA TO ANOTHER SHEET
  486. help comparing two sets od data to find the odd data
  487. Boolean comparison: range vs. single cell
  488. return multiple corresponding values in excel
  489. Duplicating cell value between worksheets
  490. How do I select all values within a category in Excel?
  491. Posting date
  492. How to convert an excel spreadsheet into a Powerpoint page?
  493. Sum column based on column heading
  494. Extract the first few characters
  495. IF statement help
  496. conditional minimum value of various cells?
  497. selecting columns in a worksheet
  498. Worksheet has turned
  499. My worksheet has turned grey and is not working
  500. VLOOKUP help needed!
  501. File copy
  502. How can I protect cells and allow users to insert/delete
  503. how to restore worksheet's gridlines & attributes
  504. How do I protect the cell from users entering values in Excel?
  505. Need help in conditional formatting
  506. How do I tell a price list to round up and down to the nearest 25
  507. 5 highest then list names
  508. LOOKUP question
  509. Calling macros in another workbook
  510. "In Today's Dollars" help needed...
  511. Making cells "unavailable"
  512. Having a Macro Prompt Me For Input
  513. Calculating number of instances occuring in an hour for 24 hours
  514. how do i format a cell in Excel to 3 significant numbers
  515. Re: Show + beside positive number?
  516. How do I use an Excel interactive calendar?
  517. Format cell to show colon
  518. Substitute for Dragging
  519. how do i do this?
  520. How to name cells?
  521. if formulas
  522. Pivot Table Totals Incorrectly Summed
  523. My excel document is opening two versions.
  524. Any quick key for entering Current Date and Time?
  525. formulas in excel are not working
  526. Array
  527. How do I add a second criteria to the SUMIF or DSUM function?
  528. Calculating Time Past Midnight
  529. Transpose Reletive Cell References?
  530. Modify a Macro to Repeat for all Selected Worksheets
  531. Using the paste link function in Excel 2003
  532. How do I insert manual line breaks in excel?
  533. Problems shading a cell!
  534. Cell Reference Question
  535. excel, i want to add 20 in increments to the number 101+20
  536. Time format to number while keeping value
  537. How to use an index number in a search range
  538. Quick answer please!
  539. RE: Macro Problem
  540. EXCEL LOOKUP
  541. Counting Formulas -- Re-explained
  542. Help! data from pasted table is not included in sum
  543. Return SEARCHED Column Number of Numeric Label and Value
  544. How do I set up multiple logical conditions on one result cell
  545. Print unique values
  546. Excel: How do I change all upper case ss to proper case?
  547. Need formatting help
  548. re: how do i do this
  549. Importing Workbooks into a Master Workbook
  550. Copy info in a range that always changes.
  551. Is there an array function or something like it?
  552. Can unmerged cell contents be split to another cell
  553. Collecting weekly and monthly totals from daily data
  554. Pivot tables
  555. HELP! Single cell formula to calculate weeks cover of stock on forward sales.
  556. identifying a string of positive numbers
  557. Formula to display last few entries
  558. grab detail when = > 1
  559. sum, lookup, and date range
  560. Is it possible to have a formula for the following scenario please
  561. sequential numbers
  562. Max number of named ranges
  563. menus don't work
  564. How do I bulletize in Excel, analogous to Word?
  565. I need a formula
  566. Converting Dates to 8 digits
  567. How do I create a sheet in Excel that updates itself from other sh
  568. Testing for Cell Fill Color
  569. Trasnsposing or copying filtered data from one sheet to another
  570. how to loose all numbers after decimal (not rounding)
  571. SUMPRODUCT or COUNTIF?
  572. HOW DO I DRAG AND DROP W/O TAKING CELL BORDER?
  573. Using AND function to evaluate cells
  574. unwanted date conversions
  575. insert colons in time automatically when input to cell
  576. Math Experts - Function to compare where salary is compared to others have 800 rows of data
  577. conditional date formula
  578. countif based on fill color
  579. creating an hourly matrix (scheduling)
  580. How to return a single value for a range of numbers
  581. Mixed Cell
  582. Infinite Updating Column
  583. Moving data from from one worksheet to another
  584. password protected page not opening by web query
  585. Nested Loop Link
  586. Pivot table - Custom calculation question
  587. How to create a formula 5 to 10% based on given list of price
  588. advanced filter
  589. bold part of cell unavailable at time
  590. Re: Fill colours
  591. Formula to see if a cell has an entered value
  592. Cell format changing on the fly
  593. DSUM Switched Off?
  594. More elegant method?
  595. Sumif function does not add up cells, even when criteria is blank
  596. Help Tidying up formula
  597. Rename Defined Names
  598. Error Messages
  599. Cell problems - need a quicker way.
  600. calculating date intervals
  601. date intervals
  602. Vlookup over multiple sheets
  603. Circular Reference... Help!
  604. Formula to copy text from a column in different workshhets
  605. Zero Suppression in Excel barcode fonts
  606. How do I use the "SUMIF" function using dates as a condition
  607. How many formula
  608. Changes in date functions between excel 2002 and 2003
  609. Totaling amounts based on duration
  610. sumif less than 11/30/2005
  611. Using subtotaling and protecting a sheet at the same time
  612. Nested IF question
  613. how do i find palindromes using excel?
  614. Spreadsheet protection password
  615. When February 29 is date?
  616. Counting or Total Formulas -- Further Explanation
  617. VLOOKUP bug?
  618. repeat rows for add'l pages for tabs on a multi-tab worksheet
  619. Formula to recognize Duplicates
  620. loan amount pay per share
  621. Problem with link
  622. COUNTIF Function
  623. index or filter?
  624. Exceeding the limit for Nested IFs
  625. Data Validation with Defined Name
  626. How can I get the value of a cell to increase in steps?
  627. How many business days were in 2005?
  628. Re: Help writing a lookup formula
  629. How can I Lock Formatting?
  630. Currency format within an equation...
  631. Average when No Data
  632. How to do I convert angles from radians to degrees in Excel?
  633. =countif (h3:h16">=01 01 2006") how to substitute cell for date
  634. How do I make longer a drop-down list (the window) in excel?
  635. Right Function
  636. How to estimate a future service date?
  637. Counting blanks, either 1, 2 or 3
  638. data query
  639. RE: Help typing formula
  640. formula to calulate length of time
  641. SUM formula - using variable values
  642. date formula for extracting unique dates
  643. Re: date formula for extracting unique dates
  644. casing
  645. Re: Help typing formula
  646. Problem with SUMPRODUCT and Arrays
  647. Why can't I scroll down?
  648. vlookup - i think
  649. filter by frequency
  650. return value based on two criteria
  651. Holidays
  652. Projecting sales dollars based on actual history
  653. How clear the cut/copy blinking boxes after macro
  654. Formulas
  655. Formula to extract digits from a text string?
  656. How to set highlight for the column&row header of the active cell
  657. IF/AND used with SUMPRODUCT?
  658. Excel 2003 has wrong timing using the worksheet_change macro
  659. If Statement linked to cell with VLOOKUP problem - getting wrong v
  660. Vlookup for range, help
  661. Sorting a column to use with an INDEX function
  662. Use lookup or ??
  663. Find, Lookup, Match, can't figure it out.
  664. Looking up several number
  665. Sumif question
  666. Looking up several number
  667. How to switch column headers from numbers back to letters?
  668. HOW DO I REDUCE THE SIZE OF A WORKSHEET TO THE CURRENT USED CELLS
  669. Insert row to EXACT function
  670. How does Excel Sheet with combo box show it when used projector?
  671. Refer to a url and retreive info for a spreadsheet
  672. The 7 nested If() function Limitation. Is there anouther way?
  673. Excel Formulas
  674. IF it will work?
  675. what does the symbol "^" mean and how can it be represented in a f
  676. How prevent email address from being hotlinked to open send msg wi
  677. Multiple condition help needed
  678. Calculate the closest day
  679. Templete question...I hope there is an answer
  680. How do I exit a macro subroutine?
  681. HELP WITH EXCEL SPREADSHEET
  682. Function needed????
  683. Convert Values to formulas
  684. How to perform two actions ?
  685. Creating Array formulas with multiple criteria
  686. parentheses
  687. Unique values
  688. mortgage formulas etc..
  689. Sum Cells within each date.
  690. how to consolidate large worksheets w/ 800~1000 rows by category?
  691. IF function using dates ?
  692. back date calculation?
  693. DATEVALUE works on one sheet, not another
  694. EXCEL SPREADSHEET SET-UP QUESTION
  695. How to insert random phrases
  696. conditional formula: return 1 of 4 values
  697. turning student scores into a level???
  698. Turning a negative into a positive
  699. Functions
  700. template
  701. Perpetual calander
  702. How to translate excel function names from english to local langua
  703. Common Text Entries
  704. add non-contiguent sums in one column to a Grand Total
  705. How to link an Image to a cell value
  706. HOW DO I ADD AMOUNTS FOR DIFERENT VALUES
  707. Average function with #VALUE! error in reference cells
  708. How do I get cell data in multiple Excel files into one summary fi
  709. Store Functions by a name
  710. How do I count like dates in a column with format "January-05"?
  711. Print range names and how know if have too many?
  712. Conditional math using AND, Average
  713. Checking 2 sets of values to provide True False
  714. Multiple conditions...why wont this work?
  715. how Excel can copy the data in a row of worksheet to other?
  716. Running macros automatically-AutoFit
  717. Loopy?
  718. Multiple V Lookups
  719. Cut/Copy and Paste Functions without old links
  720. Weighted Average
  721. formula suggestion please
  722. Add a warning popup to a Macro Button
  723. lookup multiple values
  724. Count if Multiple columns
  725. Computing Mutual Fund Diversification
  726. date updated conditionally based upon other cells
  727. Index/Match from multiple columns
  728. Help with INDIRECT function.
  729. i want to import data from one workbook to another and add a row
  730. How to lookup the value next to a lookup result
  731. Counting again
  732. how do i convert a column of minutes into hours
  733. what are the uses of merging?
  734. how to seperate into columns?
  735. nesting conditional formulas
  736. Calculating Bond Price
  737. Get the reference from a referenced cell
  738. Extracting All But Last Word
  739. Unicode
  740. count if
  741. Date programming
  742. Transfering Data from Several Sheets to another
  743. How do I insert a comment in unlocked cell of a protected workshee
  744. help creating a formula using IF and AND
  745. How can I add a fixed value to all cells in a table?
  746. Excel 2003-color coded reference cells has stoppped on a spreadsh
  747. Can I lock cell contents after current date is past?
  748. Need help with this formula...
  749. number sequence gap
  750. How do I use Lookup to return a row of values eg. 6 cells
133