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

  1. excel cells are merging onto the next cell
  2. Text to Columns - Only want to split SPECIFIC NUMBER of times
  3. IF Functions
  4. SUNIF with 2 criteria cells
  5. Function to find duplicate values, then delete
  6. logarithmic graphs are these possible?
  7. VB syntax help requested
  8. hyperlink in drop-down list
  9. In Excel, how can I type a number with a circle around it?
  10. Cell Value Changing
  11. Excel User Conference - Atlantic City, New Jersey - April 19-21, 2006
  12. shrink to fit in excel
  13. Merging data from mulitple worksheets
  14. Ratio function
  15. Formula Help
  16. Delete syntax problem
  17. What is the function opposite of LOG
  18. What is the function opposite of LOG
  19. Opening Excel with no workbook open
  20. getting data from another worksheet
  21. "Save as template" option
  22. Multiple Lines in List Box?
  23. easy if statement
  24. Re: Is it possible to lock cells together while organizing?
  25. Match formula
  26. Macro recording?????
  27. Continuous Averages Formula
  28. I need to add a range of cells until I reach a cell with a zero va
  29. what if
  30. Someone moved my linked file
  31. Iserror and vlookup
  32. Date of expiry - warning?
  33. Macro puts #REF in VLOOKUP formula
  34. arrow across, up and down etc in an excel row? How ?
  35. concatenating rows from different sheets
  36. Tab Names
  37. sorting concern
  38. Complex data referencing - too many for nested IF's
  39. How I can use the same graph in multiple worksheets?
  40. HelpNeed to know what formulas I need to use to move names in a co
  41. need to convert list of dates to count no. of dates by week
  42. shrink to fit and wrap text
  43. New to charts help
  44. Copying formula to another workbook
  45. How do I get a cell to show the result instead of the formula?
  46. Formula to replace invalid filename characters
  47. isolating a string containing a % symbol
  48. enter doesn't work with sumif
  49. Re: Using a worksheet name from a range
  50. Add additional info to multiple fields
  51. Populating Multiple Worksheets with one entry
  52. Enter dates and return availability
  53. HOW DO I ADD A LETTER BEFORE AN EXISTING NUMBER IN A CELL?
  54. how to sort my whole sheet
  55. write a formula to calculate age in yrs; 04/30/06 minus birthdate
  56. vlookup
  57. Couple of vlookup queries
  58. How to add one column if 2 other columns have a specific value
  59. + and - "hide" icons
  60. in excel, how do i get an average without including the zeros?
  61. Vlookup not recognizing field
  62. Incorporating HTML
  63. How to I exclude GETPIVOTDATA from formulas?
  64. can I use =if with vlookup statements
  65. conditional formula to show "open" or "closed"
  66. month worksheet function returns wrong value
  67. Excel GURUs help. (How to make program parse more than 1 forumla within a cell)
  68. Inserting a row
  69. I want vlookup gets value once
  70. getting unique records similar to the primary key in access
  71. point protect
  72. RE: Using a worksheet name from a range
  73. RE: Using a worksheet name from a range
  74. Sorting
  75. Date formula and if function
  76. compare 2 columns
  77. Continuous Alphabetization
  78. Sorting
  79. Help With If Statement
  80. Equivalent of Minus in Excel. Also Union, Intersect.
  81. Q About Macro Security
  82. Matching Items
  83. nearest match
  84. Worksheet Problem
  85. Q about: IfAnd or is it AndIf?
  86. how do i add seconds (time)?
  87. Access to hidden cells
  88. Re: APR Rate on a Loan
  89. Help needed with function
  90. Excel User Conference in Atlantic City - April 19-21
  91. Splitting Column Data into 2 fields
  92. access or XL!
  93. delete duplicate record but only determine 1 column data
  94. RE: APR Rate on a Loan
  95. Custom formatting not functioning in Excel
  96. Macro Save As Code???
  97. Workspace opening issue
  98. Page Header concern
  99. How do I show a surplus number in an entry (on the plus side)
  100. appending text to existing values
  101. How do i keep it like this, A1:c1/b1, A2:c2/b1, A3: c3/b1?
  102. Guidance needed wrkng with a wrksht
  103. Formatting Upper Case letters
  104. Need Help Please
  105. Macro to open new sheet??????
  106. Need help merging worksheets
  107. Pivot Table - How Do I Convert Data?
  108. How do i add multi-spreedsheets together
  109. I want vlookup gets the value once
  110. serial numbers excel
  111. Tab question
  112. Help to write a formula using a letter value and a number value
  113. syntax question
  114. Weekday
  115. text cuts off in cell
  116. adding rows to ALL worksheet (all in one)
  117. i need a templet to add and subtract
  118. DSUM : what am I doing wrong?
  119. formulas
  120. group comment format on text
  121. return a list
  122. Dynamic Range, Data Validation and Address, Match and Offset Funct
  123. show a column of numbers also as percentages
  124. Help :Circular References
  125. Re: How Do I Autofit To Screen Size
  126. Random cell generator
  127. Why am i getting #VALUE! in a cell?
  128. What is the -- in formulas?
  129. Time card template
  130. Excel gridlines not printing
  131. Auto filtering vs Date> List > Create List
  132. How do I multiply 1 cell x 1 cell and answer in 3rd cell?
  133. Can I have multiple freeze panes in one worksheet?
  134. How do I freeze more than one location on my worksheet?
  135. undo auto symbol
  136. Sumproduct Will Not Find Date
  137. How do you trim characters?
  138. Display total in more than one cell...
  139. How do I convert a cell(s) from the formula to it's contents?
  140. Color rows if
  141. multiple vlookup
  142. Slow data filtering
  143. I NEED OLL BROG IN BOX
  144. Ranking based on frequency
  145. Catentate or cotentate
  146. Daily time sheets
  147. Using AutoFilter to Sort Data Pulled in by INDEX / MATCH
  148. Complex Formula to Find Doubles
  149. using If statement to change values in a range
  150. Cell Displayed Does Not Equal Cell Copied
  151. function wizard excel 2000 not calculating in worksheet
  152. how to insert calander control in excel?
  153. TEXT SEARCH
  154. Filterered list to new worksheet
  155. CountIf Function Help Needed
  156. RE: Excel Formula
  157. Formula/Macro to copy into a cell
  158. Assessing unconventional projects
  159. Autofilter - on select columns
  160. Q: how to create summary daily lists from another, and reverse
  161. Wild Card Search
  162. nest functions in CELL function
  163. How can I test if a Macro if firing?
  164. help with format inserting referenced value
  165. How do i link w/sheets to increase value without just overwriting
  166. how to match data of one column with other
  167. Problem calculating weekly costs
  168. RE: IF functions
  169. RE: IF functions
  170. run macro when cell is selected
  171. Formula not evaluated automaticly in Office 2003
  172. Subtotal Range of Alphanumeric References
  173. VBA
  174. worksheet tabs automatically change?
  175. Check if a value exist in a column
  176. automatically number every other row
  177. Can individual cell boundaries be changed?
  178. Change Cell properties by Function
  179. How do I use countif to count values excluding blank cells
  180. retaining functions or formulas in cells
  181. Average Array help with a formula
  182. show difference between weights with correct pos and neg values
  183. FORMULA NEEDED TO COUNT DAYS IN EXCEL BETWEEN DATES
  184. Display worksheet protection status in a cell?
  185. COUNTIF not counting properly!! Character limit?
  186. YEAR function name not found
  187. Problem with Vlookup array selection
  188. add a ruler to use on spreadsheets
  189. help for an excel newbie
  190. adding individual cells in a column
  191. index/index
  192. Where?Worksheet code module or Worksheet_SelectionChange event han
  193. unknown - maybe grouping
  194. How do I delete a lookup table array name?
  195. Help Please with %
  196. Forcing Alignment Options
  197. How to copy records containing a specific date range to new sheet?
  198. Can Excel Data be simultaneously entered in seperate category list
  199. V Lookup
  200. How do I avoid getting "too many different cell formats" error?
  201. I need a Lookup to return more than 1 result
  202. SUMPRODUCT is broken (I swear!)
  203. V Lookup and return cell address
  204. If function with date; if sale is Oct place sale $ amount here
  205. AutoFill over 30,000 rows
  206. Quick Question
  207. multiple sheets when importing into excel
  208. Can you search for common results in many wrksheets?
  209. Formulas that don't compute
  210. Access import query list incomplete
  211. Outlook Calender to Excel Spreadsheet
  212. Reporting results of pivot table
  213. COUNT SEVERAL TEXT VALUES AUTOMATICALLY
  214. Help with Formula
  215. how do I create a macro to auto insert rows?
  216. Excel - let search for more than one disconnected word in a cell
  217. check cell val, increment val
  218. Reference is not valid
  219. How do I round to the nearest $5.00 in Excel? $74.03=$75
  220. ms works question
  221. Easy Nested IF formula question, please help
  222. Comparing worksheets in Excel and highlighting changes
  223. help with VBA.Financial.rate error
  224. How to I past the exact copy of a form without it shrinking
  225. Saving transfered data
  226. Formula With Dates
  227. Average Values / Multiple Worksheets
  228. Elements and Arrays in Excel
  229. Array formula lookup
  230. SUM(COUNTIF(range,NOT Criteria))
  231. Will Excel's time function do this?
  232. Query from within Excel
  233. Creating ODBC link within SELECT statement
  234. Cannot use Data Analysis tools on Excel worksheet embedded in PwrP
  235. workdays formula ends on weekend date
  236. Get Rich
  237. rounding values in in array before sum
  238. Number of pages
  239. count cells since last non-zero value
  240. sorting data into separate worksheets
  241. Permutations of an array element <> to a value
  242. Trimmean for limited array
  243. Refresh Pivottable last 4 weeks data from today
  244. CountIF Range
  245. Functions not working in Spreadsheet
  246. Calculating Month To Date Revenue
  247. Mode or frequency
  248. concatenate
  249. Presentation errors with multi-level sub-totalling
  250. causing macros to run at insertion point
  251. Using '=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}))'
  252. how do i add 2 columns to make the answer apper on the 3rd column
  253. Request
  254. How do I return True False
  255. multiple IF's ?
  256. Absolute Named Ranges????
  257. help with sumif formula with multiple critera
  258. Match and Copy
  259. Splitting single column data into two
  260. operations on arrays
  261. =DATEVALUE("7/1/20"&MID(C3,13,2)) creates error
  262. Compare two Numbers - Determine Decrease, Increase, Same
  263. Excel - remaining wks in a year formula
  264. How do I create a List in Excel 2000
  265. =DATEVALUE
  266. Need an advanced "if" function: if 2<x<2.9 then y, if 3<x<3.9 then
  267. how do i sort a proceted work sheet
  268. Color background with Matching cells in row
  269. How to programatically control a 3D-sum?
  270. Calculating timesheet with overtime
  271. Re: IF Function
  272. Averging non-zero cells only
  273. Excel List & Format
  274. How do I query a future date?
  275. Using INDEX and MATCH to find data in 2 different sheets
  276. autofill dragging result rather than formula, why?
  277. Feynman Experiment
  278. Question about merging data
  279. Data Validation
  280. index/match
  281. sumproduct returns zero
  282. =Average(if( formula using different worksheets
  283. SumProduct Formula
  284. Macro code error; machine dependent
  285. Refreshing OLAP cube by date using VBA
  286. Writing macro in Excel
  287. hyperlinks
  288. Autofill cels based on two dates in adjacent cels
  289. Help! Complete text in cell not showing
  290. Counting lines that meet TWO criteria
  291. How can I copy text from one worksheet to another
  292. braincramp
  293. Extracting certain information from cells
  294. Counts/Percents Multiple Criteria
  295. Adding hours minutes and seconds
  296. How to Update a link within a workbook
  297. Linked Worksheets
  298. How do I convert text to numbers in an old version of excel
  299. How to make autosum update totals in excel
  300. Web scraping
  301. Freeze and split panes in Excel 2003
  302. How do you create page numbers on excel worksheets?
  303. *****Upgrading Calendar for Office Manager*****
  304. Re: Freeze and split panes in Excel 2003
  305. Barcodes
  306. Copying a worksheet witrh protected cells to a new worksheet
  307. Use "PROPER" to change UPPERCASE text to Title Case on worksheet
  308. Re: Copying a worksheet witrh protected cells to a new worksheet
  309. Extend Excel Workbook Columns to 366
  310. Re: Extend Excel Workbook Columns to 366
  311. HELP!!!!!!!!!!!!please!!!!!!!!
  312. Double lookup formula
  313. RE: Double lookup formula
  314. RE: IF functions
  315. Effective method to paste array formula
  316. why does auto sum get wrong totals?
  317. YTD average - How do I create a formula?
  318. How do i combine duplicate column headings
  319. how can I use the NOW() function without it updating thetime?
  320. HOW DO I DO SIMPLE DIVISION?
  321. Excel should have case changing menu items like Word.
  322. Rank & Match Problem
  323. Extracting entries from long list
  324. subtotal of sum and count in one spreadhseet?
  325. how to put the subtotal of the sum and count in one spreadhseet?
  326. Color Code Date Checking
  327. Combining "AND" with "OR" Statements
  328. need help with a payroll formula
  329. Conditional Format - Outline Border
  330. Updating inventory quantity
  331. Adding months to dates should account for 28-30-31 day months
  332. chart types
  333. Postman
  334. If Function - Multiple Arguements?
  335. quirky array not working
  336. Sumproduct question
  337. Dates and Quantity sort
  338. Macro to highlight cells based on content
  339. workbook1 data to workbook2 data
  340. color of filter arrows
  341. re-produce/loate auto filter list
  342. How do I get a count of dates within a range..?
  343. paste special - formulas
  344. Totaling some hours but not others HELP!
  345. EC Excel User Conference This week registration giveaway
  346. Error when opening Excel workbook
  347. I NEED TO IMPORT MORE THAN THE 65,536 LINES EXCEL ALLOWS
  348. How do I sum increments of minutes and seconds
  349. Including Environ Username in Cell
  350. Difficult for me, probably basic to you
  351. how to hide raws and use password
  352. PivotTable - Calculated Field
  353. Vlookup for two value
  354. 3D Interpolation
  355. special formatting adds extra zeroes
  356. Dsum will not work
  357. highlighting duplicates
  358. help with a table
  359. How do I advance filter to multiple locations at once?
  360. Conditional DAY
  361. Setting borders for two rows and all columns on spread sheet
  362. Tabbing to the next cell
  363. How do you convert an entire column into absolute value?
  364. How do I find the last instance of data in a column
  365. Limit drop down list and linking to other info
  366. How to format a number cell to auto count 1 up on file open
  367. how do I count with multiple arguments
  368. Nested function - what key strokes to save and return a value?
  369. Random Number generator
  370. How can I view color coordinated formulas
  371. "New Web Query" always refreshes data from website (3 times)
  372. COUNTIF according to presence of string within text
  373. isnumber multiple criteria.
  374. exporting summary data for pivot table!
  375. Convert text string to date
  376. Automate Spreadsheet
  377. Is there a function to extract the URL part of a hyperlink in another cell?
  378. COUNTIF Question
  379. Vlookup problem
  380. How can I set up week to date report?
  381. why doesn't sort work when it's choosen before protecting sheet
  382. INFORMATION ON FUNCTIONS IN EXCEL (EX. "IF", VALUE LOOKUP)
  383. Modifying an If Statement
  384. Is there an AVERAGEIF function similar to COUNTIF - how do I do i.
  385. Querying a range within Excel
  386. calculate percent met (comparing 2 date columns)
  387. how to activate controls in protected sheet
  388. MSOffice Excel 2003-Validation Listbox takes only 47 values
  389. Please Help! - Need Help pulling data from one spreadsheet to anot
  390. Time function
  391. I used Lotus Help for regressions in MS Excel 99. Now what?
  392. Forecasting
  393. Need help with formula to give 0 if value is negative or answer is
  394. copying specific data from 1 wrksht to another
  395. HOW CAN I RECOVER MY OVERWRITTEN DOCUMENT?
  396. vlookup into 2 shhets
  397. problem with macro on Excel
  398. Text and Function Formulas
  399. Finding unique data between 2 columns
  400. intercept graph vs. function
  401. Use InStr function in formula?
  402. RE: Capitalization?
  403. Combining Worksheets into one
  404. Removing unwanted rows
  405. Conditional Formatting for Array containing Text
  406. Sum rows if two columns = specific criteria.
  407. time elapsed formula
  408. dynamically select a range of cells for use in a formula
  409. Summed Cell won't update as I add data into the cell range...
  410. Mortgage calculations
  411. Returning Multiple Text or Address Locations
  412. How do I sum cells' values over 30+ worksheets?
  413. Not able to access certain Excel functions
  414. RE: Capitalization?
  415. Calling a specific worksheet from a hyperlink in a seperate file.
  416. The Top Toolbar Min,Max,Cancel is NOT showing in Excel
  417. Time Display ?
  418. How to update one manually-entered value from another?
  419. Smart tags
  420. How do I add time abouve 10000 hours in excel?
  421. life contingencies
  422. Disable auto-formatting dates.... GRRR!
  423. Custom formats to round numbers such as 465,123 to 465,000
  424. product from k= 0 to n
  425. Repeat in functions?
  426. cell address
  427. Countif in VBA
  428. trigger help
  429. SUM returns #VALUE! error
  430. Circular references
  431. sorting cells
  432. not printing lines?
  433. A counting question...
  434. average with mulitple ciriteria
  435. if equation
  436. Can excel limit the characters in a cell to 28 automatically?
  437. calculated field - Pivot Table
  438. unique order number according to criteria
  439. RE: Extract certain parts of string
  440. Extract certain parts of string
  441. NPV
  442. Counting Cell with Quotation
  443. Solver question
  444. Sorting by number of ocurrences!
  445. if equation
  446. automatically move results from a calculation to a specific cell
  447. My If+If+If etc.. is too long! Anyone know a better way?!
  448. COUNTIF using exclusions
  449. Using the AVERAGE Function
  450. Hiding a Worksheet
  451. Why doesn't this work "=IF(C2>= "13:00",C2+"16:00",C2+"4:00")
  452. sum multiple rows based on progressing date field on each row
  453. vlookup
  454. COUNTIF using exclusions
  455. vlookup
  456. Conditional Formatting for more than 3 conditions
  457. Combining 2 Formulas
  458. Basic Solver Problem
  459. If+if+if+if... Does anyone know a better way?
  460. enter date(A) and have (B) total to current day?
  461. Fill in contents based on another column
  462. Embedded IF Fuction
  463. any good reference books on building excel formulas?
  464. Between Dates
  465. Sum like items
  466. ... round a time entry to the next "30 minute increment"...
  467. Resorting full names
  468. Auto Insert/Auto Formula?
  469. converting text to negative numbers!
  470. Sheet Protection
  471. formula help need to get current row
  472. how do Import data tab delimited text?
  473. how do I import tab delimited data?
  474. create a separate backup file in excel when exiting
  475. Look up/math text
  476. =SUMIF(B8:B38,"<"&TODAY(),D8+H8+L8+P8+U8+Y8)
  477. Conditional Sum problem
  478. Need formula help setting a range for calculations
  479. macros
  480. =DATEDIF
  481. Vlookup refs a cell that has a worksheet name
  482. Sumif Function
  483. vlookup
  484. attach a label to number, like validation but follows the number
  485. Groups of numbers
  486. dates and vlookup
  487. SQL Queries
  488. Macro for Subtotals
  489. Date Function
  490. Vlookup not working because of duplicate matches
  491. invoice toolbar
  492. comission split based on 365 days
  493. FillDown Macro
  494. Concatenation question
  495. Read-only access by SHEET (not workbook). Is it possible?
  496. How do you extend the number of blank columns in a worksheet?
  497. user defined function help
  498. complex count
  499. Formula or Function to accomplish this?
  500. summing values appearing in col B when col A has been filtered
  501. Finding Maximum value while excluding some values
  502. Finding a name with biggest number
  503. trouble with seeing formula in formula bar
  504. count workweeks or work hours
  505. populating spreedsheet with data from access
  506. Adding a constant to a formula. Problems w/filling in
  507. FOrmulas in MS Excel
  508. Copy data into/from textbox
  509. Digits in ascending order ?
  510. keyboard shortcut for zoom
  511. RE: Average every 20 rows
  512. Average every 20 rows
  513. Spinboxes In MS Excel 2003
  514. Change Date without Opening the Workbook
  515. RE: summing previously ranked values
  516. Using Countif to count occurences of time?
  517. Can I display comments in a validation list
  518. vlookup in several sheets
  519. I am trying to round a list of numbers (prices) to xx.95. Is the
  520. summing previously ranked values
  521. joining worksheets
  522. SUMPRODUCT?
  523. Nested IF error
  524. In a linked calculation how do I lose the '0' in the linked file?
  525. Data compiling formula
  526. Protect "signature" cell
  527. Week Number
  528. How to use month() and day() without considering year()?
  529. count with filter
  530. Linking to a closed workbook
  531. Calculating Overtime
  532. Re: currency Problem
  533. Conditional Formatting Formula
  534. Enter 1 in a cell, excel change to 0.001, WHY?
  535. NA()
  536. Difficult for me, probably basic to you
  537. Protection and Spell check
  538. INDIRECT EXTERNAL DATA
  539. Using Logical Function in Pivot Calculation
  540. Current cell position
  541. How to place parenthesis around a negative percentage calculation.
  542. Re: currency Problem
  543. Change Last Cell
  544. Formula to Link to Specific List on Another Worksheet
  545. Due date excluding weekend days
  546. #N/A conditional format
  547. change cursor to highlight cell I'm in
  548. Conditional Formatting in Excel
  549. How can you use multiple ranges in a function?
  550. Function that will copy sheet to sheet IF...
  551. sumproduct?
  552. How do I allow multiple choices in a list-box?
  553. reference
  554. Totals sheet - deal with employee names
  555. Office 2000 vs 2003
  556. copy, insert and add digits
  557. Vlookup - no match
  558. Compare cells and Create a new File
  559. Random numbers function
  560. Vlookup problem with Date Time
  561. Need to get rid of 0's and replace with Blanks
  562. Fiscal Year Calculation
  563. Re: currency Problem
  564. Countif or Vlookup
  565. Auto update to "tab" in a reference link
  566. Find numeric value at end of string
  567. Column Labels (A, B) are showing us as numbers (1,2). Please Help
  568. Formula to ignore negative numbers in a column?
  569. Comparing Entries to a list
  570. Re: Combo Boxes for data entry
  571. Counting and Summarizing Data
  572. Edit Query
  573. Reposting....Compare cells and Create a new File
  574. Text to Number Value.
  575. New user with a question
  576. 'if' and 'and'
  577. RE: Run macros on protected worksheet
  578. options custom list
  579. RE: Is there a macro for Canadian compounding
  580. Hyperlink from one cell to another
  581. Excel subtotals should subtotal "blanks" separately.
  582. RE: Check Boxes
  583. RE: Converting to Decimal degree's
  584. MIN to get three lowest
  585. RE: Setting Tab Names To Dates In Spreadsheet
  586. using the equation of a polynomial
  587. Re: Extracting information from records to another sheet automatic
  588. Setting Tab Names To Dates In Spreadsheet
  589. Formaula to multiply and add
  590. Time Functions
  591. Re: Extracting information from records to another sheet automatically
  592. Question regarding formula
  593. Create a spreadsheet to budget
  594. Formulas in are turning into values for no reason
  595. stock quote lookup query for Excel 2000
  596. Check Boxes
  597. filtering pivot table!
  598. Is their any Function to convert no. in figure to in words
  599. help interpreting expression
  600. Extracting information from records to another sheet automatically
  601. general syntax
  602. changing to two place decimal
  603. replacing value between sheets!
  604. Loan Amoritization Spreadsheet Issue
  605. Sumif or Sumproduct? Maybe neither?
  606. Spreadsheet Summary Report
  607. Run macros on protected worksheet
  608. RE: Numbers stored as text causes problem with VLOOKUP
  609. How do I expand the checkbook register to more than 98 entries?
  610. Excel 2003 - paste special option
  611. how to format time
  612. "how to make data lineup from 1st to 2nd page for printing?
  613. date and time updated automatically
  614. linking worksheets
  615. Keyboard Shortcut for Zooming
  616. Converting to Decimal degree's
  617. DSUM
  618. Sumif or Sumproduct
  619. Why do I have certain raw data disappearing in my pivot table
  620. Is there a macro for Canadian compounding
  621. Numbers stored as text causes problem with VLOOKUP
  622. Bi weekly payments per month
  623. Insert Photo into a protected worksheet
  624. How do I set up conditional formulas
  625. Loan Amoritization Spreadhsheet Issue...please help
  626. Set up Tax planning sheet by week/monrth- Income/deductions
  627. Confidence function
  628. Reference
  629. Date dif
  630. Conditional Sum Wizard with dynamic named ranges
  631. EXCEL LOOKUP FISCAL YEAR WITH DATE
  632. CountIf Conditions / Occurrences
  633. Re: Reference range of cells and perform subtraction or nothing depending on contents
  634. MORE THAN ONE LOGIC TEST
  635. How to delete in batch the same color format letters in a cell
  636. help on excel formula
  637. returning macro value to starting cell (different each time)
  638. template error
  639. Yahoo + "Get External Data"
  640. Why won't my formulas work until I save the worksheet?
  641. quotation marks
  642. extracting numbers
  643. First occurance greater than or equal to a specified value
  644. Link Data from Multiple Worksheets
  645. how to copy displayed value only?
  646. Ignoring negative number
  647. Transpose and link Multicolum matrix in 2 colum array
  648. How to show data from other sheet depend on value??
  649. financial functions dll
  650. Color Coding Cells
  651. Working out age from "Day" "Month" "Year"
  652. Registration drawing ending - Excel User Conference
  653. Blocking entry of data in a cell
  654. Index / Hlookup
  655. Using the results of formulae between different spreadsheets.
  656. Finding a minimum value and selecting the cell containing this val
  657. Case Sensitive w/ IF
  658. Conditional formatting--simple question
  659. excel formula calculations are wrong
  660. multiple conditions
  661. A Sheet Error for dates I can't explain
  662. sumproduct
  663. Help with workbook updates
  664. timer Macro
  665. How do I put days of the week into a multiple regression model?
  666. track unpaid invoices
  667. Calling procedure when leaving cell
  668. naming tabs
  669. Another Multiple Conditions Query
  670. matching value of top 20 in a list!
  671. How to extract data from a wooksheet in a closed workbook
  672. Subsequence value
  673. Splitting text to columns
  674. Help!!!! Strange things are happening to a Shared Workbook!!
  675. Populate worksheets based on a master sheet
  676. Why won't Excel let me copy and paste my concantenate formula now
  677. vlookup for multiple columns
  678. V-lookup and summing values if more than 1 matches criteria
  679. YTD formula help
  680. Advanced Filtering Extract Range Missing,etc
  681. RE: Selected cell highlighting has vanished...no shading now.
  682. Lookup problem
  683. How do I paste horizontal references in large array
  684. Formula/Equation
  685. #ref to equal zero
  686. What is Excel keyboard shortcut for adding column?
  687. Multiple IF
  688. Lookup nearest value (Index & Match)
  689. Lookup nearest value (Index & Match)
  690. use address function to indicate range in calculation
  691. HELP: Comparison IF statement
  692. Date the input, then tell if over 7th off month
  693. Calculating Rolling Peak to Valley in a Column
  694. Matching two columns and their data
  695. Using variables as first and last cells in range statement
  696. Question about decimal places
  697. Worksheet controller
  698. Excel spreadsheet
  699. RE: Formula Displays in One Cell
  700. Dragging a formula correctly?
  701. RE: REPLACE or ??, Help please
  702. RE: multiple column lookups
  703. RE: seperate words in a cell
  704. RE: Excel formulas
  705. How to Set Worksheet Name to a cell Value in WorkSheet?
  706. REPLACE or ??, Help please
  707. RE: multiple column lookups
  708. using functions to compare multiple columns for mismatch of cells
  709. RE: Count # of A's in a Cell
  710. RE: Can I change the default sheet name?
  711. formatting cells
  712. seperate words in a cell
  713. Can I change the default sheet name?
  714. RE: Count # of A's in a Cell
  715. RE: WorkSheet Function Help
  716. Count # of A's in a Cell
  717. Formula to show all items with an "x" next to them
  718. Formula to return cell position
  719. first saturday in a month
  720. WorkSheet Function Help
  721. How to stop "Synchronized Scrolling" in Excel Workbook comparing
  722. Excel formulas
  723. Pivot Table using "LIKE" code
  724. RE: multiple column lookups
  725. multiple column lookups
  726. How to delete footer & header history in Excel?
  727. lookup mutliple values to return one value
  728. Formula Displays in One Cell
  729. Sort is turned off. How do I turn it on?
  730. last 20 items in a list
  731. Refresh workbook automatically
  732. Urgent help needed
  733. Function Question
  734. What formula can I use to sum only certain colored cells in an exc
  735. Automatically starting code
  736. averages
  737. buttons?
  738. Help with 'named' functions
  739. Interpolation with VLOOKUP
  740. how do i enter a function in a sentence
  741. Printing Spreadsheets
  742. Is there a way to autoinsert current row into a formula
  743. help with personal budget spreadsheet
  744. filtering excel worksheet column by color of text
  745. ANYONE GOT THE TIME?
  746. Help with excel date fill to exclude weekends
  747. LISTS OF BILLS TO BE PAID
  748. Activating a worksheet through use of a variable
  749. AUTO CASE
  750. add hex numberings together in excel 2003
153