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. Customizing a worksheet size
  2. Countif w/ Criteria
  3. counting text cells
  4. help with round function
  5. what is the ? used for in a formula in excel?
  6. format control of a list box
  7. calculating strings (excel 2002)
  8. automatic macro update
  9. Lookup or Match
  10. Data - Sort Options
  11. How do I create an invoice so every time I need a new one a new i.
  12. Use numbers in CONCATENATE formula without getting error
  13. Fiscal year total from running 12 months
  14. How do i know differences between two versions of the same documen
  15. lookup (v,h,index,match)
  16. Conditional Formatting
  17. Removing parentheses
  18. help with excel
  19. Conditional Formating
  20. I want to be able to look up a cell in excel then go to another c.
  21. Document, if supported, operations with text arrays. i.e: count i.
  22. excel quick find format
  23. #Value
  24. How do I flip a column in excel (top becomes bottom)?
  25. USING A GOTO COMMAND IN EXCEL
  26. How do I return the unique entries from a column to a listbox
  27. Duplicate Data
  28. sumproduct
  29. specifying file name in v lookup
  30. Sort Function Without Using VBA
  31. Function required to extract cell info from an unopened file.
  32. how do you copy hyperlinks from one worksheet to another
  33. How do I add hours and minutes eg 4.50 + 2.30 = 7.20
  34. Can you add a vertical scroll bar to an inserted comment?
  35. How to add "IF" statements?
  36. search for same text
  37. Excel Work Sheet Comments
  38. Conditional Formatting ... Today() & More
  39. Formula
  40. database criteria
  41. Is there a work around to use the indirct function with a closed .
  42. static time including seconds
  43. Validation Tables For Drop Down list on a Separate Worksheet.
  44. Comparing Cells and Displaying Data
  45. Data Validation problem
  46. Dynamic (?) formula
  47. Lead Zeros to Show?
  48. Simple math calculation - 50/50?
  49. Auto-filter won't filter
  50. Calculate a work day
  51. How do you use countif for several column criteria?
  52. micros
  53. Micro
  54. In MS Excel, how do I fill in a column with the same cell from se.
  55. How to create barcodes in excel?
  56. "Randomising" "number"
  57. How do I enter a SUM(cell:cell) in pocket excel so it works prope.
  58. How do I total a column which was created using the MID function?
  59. sumif
  60. SUMPRODUCT across 9 axes
  61. Index Calculations
  62. Can I get excel to auto direct me to the source of a link?
  63. Show info in linked cells in dif workbks?
  64. How to combine 2 different SUMPRODUCT criteria into one cell?????
  65. CAN'T UNHIDE THE COLUMN
  66. Filtering
  67. More Archiving Problems
  68. How do I set up multiple if statements in Excel?
  69. Need help with formula translation please
  70. Can you insert a vertical scrolling field in excel? Not a drop dow
  71. have a summary sheet that needs to link to every ten line on the .
  72. HPageBreaks.Add
  73. How do I copy a cell (content AND format) from one worksheet to a.
  74. Formula generating a column of data?
  75. Toggle multiple values in single cell
  76. array functions and ISNUMBER()
  77. Problem with Array Formulas and ISNUMBER
  78. Dynamic Getpivotdata in Excel XP
  79. Extracting File Names and Properties
  80. Format color - darker green available?
  81. Make a Fresnel Zone Calculator
  82. Pictures in comments - Excel 2000
  83. spreadsheet formating
  84. Array formulas
  85. Formula to identify what was NOT found
  86. sequential numbering of pages in a cell
  87. Can I invert a table so row headings are now column headings etc
  88. Counting unique entries in column A but only if specific values appear in columns B and C
  89. timesheet
  90. Extracting data from other columns
  91. Financial formulae
  92. Using SUMIF with non-blank cells
  93. can you help me out with the excel xp tools what to download
  94. macro help
  95. IS FVVAR AND PVVAR EXIST IN FINANCIAL FUNCTIONS?
  96. MS Access in Excel
  97. How to consolidate/sum a list
  98. LOOKUP in Excel
  99. Setting today's date automatically in Excel.
  100. formula help
  101. formula from multiple worksheets to give a color output to one wo.
  102. Convert net tons to long tons in an Excel Spreadsheet.
  103. Data Validation error ??
  104. How do I underline?
  105. Vlookup in Excel
  106. interpolate
  107. REF# error
  108. Interpolate
  109. worksheet tab name as part of a cell reference
  110. Determine Frequency in Filtered List
  111. TRIM?
  112. how to multiply 29,5 with sqrt of 12
  113. saving change in toolbar
  114. any way to make vlookup case sensitive?
  115. Get top 3 values from a list
  116. Lookup with two variable data list cells
  117. Is this impossible?
  118. Formula help!
  119. Why can't a copy and paste columns?
  120. content does not stay in page break
  121. NEED A FORMULA THAT BRINGS OUT NAME OF COLUMN (HEADER) A VALUE BE.
  122. Macro Errs when sheet is protected
  123. Calculating days between current date and a date in future NETWORKDAYS() function
  124. vlookup for a value appearing more than once
  125. Functions - Please help me
  126. Bill & Ken, Thanks for the IF & SUMPRODUCT help
  127. How can I strip a new line /nl in a cell in Excel globally
  128. making a timesheet
  129. Looking up two values
  130. Two-Column Lookup
  131. difference in 2000 and 2003
  132. How do I copy my dropdown box with data to another worksheet?
  133. I have deleted a spreadsheet in error can I recover it?
  134. Adding contents of one cell to a range of cells.
  135. More than 2 constants in Index
  136. Subtracting Times
  137. formating a column
  138. What is the easiest way to bring up data in adjacent cell after s.
  139. Trying to create repeating dates and then sort column by date
  140. formula for converting yards to meters
  141. INDIRECT function
  142. recording the date when record was entered in cell in Excel
  143. Modify the default new workbook?
  144. I need cell in A not #VALUE!
  145. Excel's Fourier Analysis should be a function, so that results upd
  146. Conditional Formatting is limited to 3 conditions, any way I can .
  147. quarterly reports
  148. What is the syntax for nesting functions such as IF AND?
  149. Complex Average
  150. MS Excel should allow you to change the color of the tabs or the .
  151. Converting EST time in IST
  152. How do I write formula to compare two values and pull the resulta.
  153. HELP WITH CODE
  154. put formula results into a different cell if it is empty
  155. how can i copy formula?
  156. cell comments
  157. Excel Limitation
  158. not updating links in excel 2003
  159. Excel
  160. HOW DO I COPY A CONDITIONAL SUM (sumif) AND EDIT IT? (THE SUM NEV.
  161. can i use an IF Statement to run a macro?
  162. Counters
  163. fill rate trends
  164. Calculate difference between two dates
  165. Formatting the Results of VLOOKUP
  166. way to automaitic sort sheet one numerical, sheet two alpha?
  167. Countif cell color is Red?
  168. Can I use a variable to call up another sheet in Excel?
  169. IF function (?)
  170. Can I use a variable to call up another sheet in Excel?
  171. Recolor Cell based on Sum of Zero
  172. grand-total of subtotals ?
  173. how do you set auto shading of cell based on percent value in exc.
  174. Using vlookup on two worksheets
  175. Footers
  176. make multiple copies of a sheet in a new workbook
  177. Date function
  178. Excel cell references to 2nd worksheet stopped working
  179. Text and min
  180. Auto filling dates on other worksheets with data from a next payme
  181. matching formula
  182. Is there no one who uses PageBreaks? HPageBreaks?
  183. How do I insert blinking or flashing numbers or text in Excel?
  184. How do I move from a cell containing the formula TO a different c.
  185. Excel - counting cells containing a text string
  186. Summing same cell/cells from multiple sheets
  187. ranking or sorting
  188. Count Distinct Values by Group Using Pivot Table (NM)
  189. Using the Find tool in EXCEL
  190. Is this a chart or a formula or something else?
  191. Hide hyperlink cell & replace with macros
  192. Is there a WorkDay() type function that count all days except tho.
  193. I subtract 1:0:26 from 1:34:54 and get 12:34:38 AM - I want total.
  194. Need help setting up a formula using perhaps the logic functions .
  195. Another ranking question
  196. Change rollover color on autofilter arrow from blue to red
  197. SumProduct Formula Error
  198. Calculate between two time formats
  199. Pivot Table Unique Count
  200. How do I set up formulas with 'if'?
  201. simultaneous v&h lookup - approaches...
  202. Countif, Sumif
  203. How do I link 12 spreadsheets without exceeding the max formula l.
  204. Delay/Slow a Macro In Excel 2003
  205. how to copy on double-click the cell value to Clipboard
  206. Can I count in an array based on a function?
  207. Re: SUMIF function
  208. Re: SUMIF function
  209. count number of cells based on TWO conditions (2 different columns
  210. When using subtotals, how do I copy and paste only the subtotals .
  211. SUMIF
  212. If statements for time format
  213. calculate hours on work sheet
  214. Conditional formatting based on text
  215. RE: SUMIF function
  216. Trouble with MINVERSE
  217. Finding common data in multiple columns and rows in Excel
  218. Help pls! Max func to display value of different cell?
  219. template for several spreadsheets
  220. how to write to other sheet if and only if?
  221. Copy info from worksheet 1 to other sheets
  222. Auto change font to 'capital letters'
  223. Macro asking "Are You Sure?"
  224. Extract a value from a table.
  225. Save & Exit
  226. date calculation
  227. calcuate bond yields
  228. Setting up a spreadsheet to calculate apportionment of service cha
  229. Is military time available in Excel? If so, how would I calculat.
  230. How do I get networkdays for a month
  231. what is the maximum columns I can have on an excel workbook
  232. Sorting
  233. Lookup function w/Text and Year
  234. How do I limit the number of complete sentences in a spreadsheet c
  235. Formula help in a monthly sales report.
  236. conditional format to show 0 value
  237. selector
  238. selector
  239. I need a formula that adds up "L" (lates to a class) over E4 to Q.
  240. How do I have headers show at the top of every page?
  241. auto formats
  242. Finding Median if a value = 1.. help!
  243. vlookup reverse// please help
  244. countif in links
  245. Comparative spreadsheets
  246. how can i locate duplicate data in an excel data table?
  247. If statement with two requirements
  248. My cell color won't print anymore.
  249. Indirect( ) function loosing values when spreadsheets are closed
  250. selected cells
  251. How do I compare 4 cells of prices and print the lowest value in .
  252. test
  253. What statement to use?
  254. Question on Conditional COUNTIF
  255. How do I find an best fit equation in the form y=Ae^kx?
  256. Hlookup to return a sum of values
  257. Working with templates on different computers
  258. calculate hours just can't figure it out
  259. How do I create an Employee weekly scheduler
  260. Table References
  261. To copy fomula
  262. Am trying to make a time sheet and having problems with a formula.
  263. Help solve a Circular Reference
  264. How to set up a column to accept changing data from 1 cell on ano.
  265. i NEED THE DIFFERENCE OF DATES DOWN TO YEARS...IE 11/1/02-4/16/85.
  266. Year Totals
  267. Excel Error Message
  268. Copy data from one worksheet to another
  269. Consolidate sheets
  270. protect cell
  271. Looking up values in a table
  272. How do I change the width of some cells but not others?
  273. filter by color or highlight
  274. If two columns match then count one. How? Tried countif and sum .
  275. Copying Abolute formulas and conditional formats
  276. lookup or table, not sure what to do
  277. subtract all numbers in an array
  278. CUMIPMT
  279. Percentage increase
  280. Comparison Operators for IF statement.
  281. INDIRECT function question
  282. Unary operators
  283. i have a rather good time sheet
  284. excel page breaks - urgent help required
  285. IMPOSSIBLE?
  286. Subtracting Times with Strang Format
  287. Help! I need to create worksheets to connect?
  288. Formatting dates
  289. How to find top five States?
  290. How do I auto-filter multiple ranges on one worksheet?
  291. MS Query - Alias syntax
  292. how can i sort excel worksheets in alphabetical order?
  293. Footnote wizard linked to cell content
  294. Headers on multiple pages
  295. DSUM and DCount when criteria values are similar
  296. CODE
  297. how do I copy excel sheets with headers
  298. How do I copy an excel sheet with headers?
  299. How do I copy an excel sheet with headers?
  300. How do I delete some words in autocomplete shortcut menu?
  301. SUM IF
  302. How do I save a copy of an excel file without the formulas?
  303. How do I add a range of numbers to sum a specific total?
  304. Lookup with multiple value return
  305. Workaround for returning month name?
  306. Time Calculation
  307. designate one cell as the variable N to be used for calc...
  308. A missing reference, maybe?
  309. summing multiple rows with like references
  310. Can you enter a formula in a cell to run a macro?
  311. IF Question
  312. Auditing Question
  313. How do I convert from U.S. currency to Canadian?
  314. Pivottable - consolidating data -
  315. deleting 4's(four)
  316. Calculating the difference between cells
  317. TODAY() and stay that date..
  318. Font size for in-cell drop-down list
  319. Nested IF statements
  320. How can I determine which cell changed as a result of a calculati.
  321. IF, AND
  322. Counting Entries in a Cell
  323. not a logical 'and' in excel?
  324. Is there a way of making data imput in to a cell mandatory before.
  325. Pasting single cells from Word to multiple cells in Excel
  326. Is there a function to convert a number to word ?
  327. In Excel how can you convert a cell formatted for time (4:30) to .
  328. Making your own trenlines
  329. Menu Bar - Tools disappeared
  330. Where can I download an Excel add-on to do MonteCarlo simulations
  331. Searching based on Text color
  332. Max charactors for 'ActiveWorkbook.SaveAs Filename'?
  333. Conditional data validation (using a filtered range?)
  334. How do I get zeros to stay in front of a # when using the concate.
  335. cell text referring to tab name
  336. Holiday information using Excel
  337. Sumif over multiple columns
  338. Warn when a cell value has changed
  339. PPMT formula that generates equal payments
  340. SUMIF
  341. Conditional Sum Rows
  342. How to validate data entries to be unique within an array
  343. random selection from a range of cells
  344. How do i put a drop down calendar in a cell?
  345. how to use the search dialog via a macro?
  346. Limit cursor range
  347. Visible cells
  348. Multiple formulas
  349. Using Find and Replace All
  350. gridlines
  351. differing results
  352. How can I cause a cell to return the sheet name i.e. sheet 1?
  353. How do you calculate rate of return on monthly cash flows
  354. How to align check boxes on an Excel sheet?
  355. How do I combine COUNTIF and AND functions in Excel
  356. IF statement, can it equal more than one number?
  357. Display dates from an Excel spreadsheet in a calendar?
  358. Correct Text Case to PROPER capitalization
  359. how do i make a list of consecutive numbers in a column?
  360. Deleting rows with blank cells
  361. macro color change
  362. if/then formula
  363. Date
  364. How to compare 2 lists and return un-matched?
  365. How to keep the value of a cell not a function of the other cell
  366. Help with #DIV/O!
  367. Help with #DIV/O!
  368. Hide Row command using if statement
  369. Count highlighted cells
  370. LINEST maximum number of predictor variables
  371. keeping worksheet title visible during scrolling
  372. mathmatical error
  373. Combo Box Control keeps changing sizes
  374. Sheet Modified date in a cell.. ?
  375. Table Array in VLOOKUP Relies on Data Validation
  376. List Box
  377. Weeknum Goes Missing
  378. problem withcell format
  379. How to add one number to a range of numbers
  380. Multiple worksheet queries
  381. Unable to Copy COUNTA() with cell references
  382. Sum of worksheets.
  383. error opening excel file
  384. formatting numbers
  385. How do I concatenate the contents of an array in Excel?
  386. Number of Occurrences between Specidied Date
  387. lookup
  388. Listbox or Combo advise
  389. VLOOKUP first numerical value (not text)
  390. Time Calculation
  391. Bug in DATEVALUE command in Excel 2002??
  392. indirect formula
  393. I really need help! Changing work period start dates
  394. Select part of a cell
  395. Any way to calculate an average for more than 30 entries?
  396. How do I install the networkdays function!
  397. Autofill question
  398. How do I create a formula that will calculate monthly changes fro.
  399. still searching for color text
  400. If cell contains...
  401. Show only Matrix result
  402. Combining duplicate records(rows)
  403. ms excel IF Statement w/pictures?
  404. if function with #No Data
  405. If And Or functions
  406. The definition of....
  407. SUM() does not work
  408. Help using Conditional Formating of Entire Rows
  409. Re: The definition of....
  410. Total hours with NETWORKDAYS
  411. cALCULATION OF DAYS
  412. IF contains over multiple worksheets
  413. count non blank cells which meet criteria in another column
  414. Is it Possible in a formula to have a formula for cell reference?
  415. spread the number 123.45 so each digit goes to a different cell
  416. how do i add numbers corresponding to same date on different work.
  417. Show "2" only if....
  418. Vlookups array function by Alan Beban
  419. How do I write a formula to color code based on dates provided or.
  420. Vlookups array function by Alan Beban
  421. Excel 97 macros to Excel 2003
  422. Comparing Data between two sheets
  423. Re: Using IF when more than one cell contains criteria
  424. Removal of characters from a range of cells
  425. lock a picture to a cell so i can mail merge
  426. Check for duplicates
  427. How do I do a MOD-10 Credit Card check in Excel?
  428. how to display formulas on the sheet
  429. VLOOKUP Help please
  430. where can I find a template for salesforecasting?
  431. Return Cell References
  432. Summing some cells
  433. Text wrapping problems
  434. Re: How to create a formula for a range of cells
  435. Go to first blank cell
  436. how do i create a journal with individual ledger pages?
  437. How can I allow users to make multiple selections from a dropdown.
  438. Count occurances of multiple values
  439. Warn if already entered
  440. Calculating number of letters in a string ...
  441. merge data from 2 Excel files
  442. set zero cell as blank cell
  443. Why does an excel worksheet default to 24 copies when printing
  444. I want to return "0" based on another cell
  445. How do I do a count sum that ignores duplicate items
  446. want to count in two columns; countif (colA=x AND colB=y)?
  447. format MM:SS without mm/dd/yyyy/hh:mm:ss?
  448. How do I append imported text down an Excel Spreadsheet?
  449. Named Range in another workbook
  450. Starting work period on a Saturday and ending on a friday
  451. allwoing protected excell sheet
  452. Rounding number to the nearest quarter
  453. Ctrl+Shift+arrow
  454. Pivot table limits
  455. If the lookup-value is a formula
  456. Extract numbers from strings
  457. switching values from positive to negative
  458. reference a repeating cell in a formula
  459. adding time zones to formatting
  460. check-mark symbol
  461. How do I perform a MOD-10 credit card check in Excel?
  462. Lookup function in Excel
  463. Re: How to create a formula for a range of cells
  464. Excel
  465. scrolling won't stop
  466. Vlookup won't work, any other ideas?
  467. Page Numbers
  468. What is the Excel 2003 syntax for linking a cell value to content.
  469. Problem with GEOMEAN - returns #NUM error
  470. Sort by last 2 digits
  471. A version of excel that doesn't have 15 limitation
  472. time add
  473. how do I show last date file saved?
  474. printing consecutive date on excel workbook
  475. File Size f(x)
  476. Excel worksheet tabs
  477. Removing Asterisks from the contents of a cell
  478. Weighted Avg - using values from multiple sheets
  479. How do i get the top 5 numbers in a range of cells?
  480. How do i get the top 5 numbers in a range of cells?
  481. MAX
  482. Date Function
  483. The description of the ATAN2 function in Microsoft Excel is not 1.
  484. question
  485. Complex Date Functions
  486. auto-calculations using calendar and dates (Excel-Office 2000)
  487. How to hyperlink from a workbook to sheets in another workbook?
  488. Counting keystrokes within a cell
  489. Bolding when subtotalling
  490. HOW DO I FORMAT DATA FROM YY/MM/DD TO MM/DD/YY?
  491. HOW DO I FORMAT DATA FROM YY/MM/DD TO MM/DD/YY?
  492. COUNTIF cell A1 is x and cell B1 is y
  493. limited conditional formatting?
  494. Autofilters in a Pivot table
  495. First Occurence of Non Blank Cell in row array
  496. Can macros output to a cell selected prior to running it?
  497. Formula to read two column come back with one value?
  498. Goal Seek on Multiple Cells
  499. solver constraint
  500. Conditional Sum weirdness . . .
  501. How do I sort a column a unique number?
  502. Moving worksheets in a book
  503. SUMIF problem
  504. Need to find oldest date in ever changing list.
  505. SUM based on multiple conditions - SORRY, URGENT!!!
  506. FTP
  507. removing text after a character
  508. Vlookup with 2 ranges in one worksheet
  509. Sumif() with criteria
  510. counting functions
  511. IF function
  512. some sort of an IF function
  513. How do you copy a formula without incrementing some constants?
  514. formulas
  515. r. venkataraman
  516. formulas
  517. Copying a formula and changing ONE value...
  518. VLOOKUP
  519. dynamic external cell reference
  520. how do I sum the same cell from multiple worksheets?
  521. R. VENKATARAMAN
  522. transfering information from one cell to another
  523. I need to do a Worksheet for my Financial Accounting Class. What .
  524. Allocate workload evenly to different staff
  525. check occurrence of items in a range
  526. Excel 97/2000 - Help with looking up external data.
  527. Excel If calculations
  528. How do you display negative numbers in the unit price column?
  529. query wizard has stopped working how do i rectify this
  530. vlookup array in excel VBA
  531. IF Function
  532. How can I get a cell locked if the condition is false?
  533. Vlookup
  534. Formula
  535. Consolidating entries from multiple worksheets
  536. Excel IF and COUNT functions
  537. Search - replace NOT in formulas
  538. Convert a Yes/No/NA response to a # value or %
  539. formula question
  540. using ranges
  541. Count Consecutive Numbers in a Row
  542. EXCEL counting calculations
  543. How do you compare text in cells
  544. changing the message in an error message
  545. Pivot Table Auto Update Data Source?
  546. When I copy a formula to another cell, I get the value of the ori.
  547. Why is Group and Outline grayed out?
  548. Calculating credit card debt, interest , and payments
  549. How do I Autosum a running column total in excel?
  550. data sorting problem
  551. Look up then insert value in next column
  552. data sorting problem
  553. how do i set up a formulas with an if date?
  554. Starting MS Excel with a worksheet other than SHEET 1
  555. find calculation function
  556. formulas
  557. A formula that is: if the sum is this, then muliply by this?
  558. Can I divide a column at the first "space" occurance
  559. Cell formats
  560. sum more than 5 cells
  561. how to create a variable column in cell reference
  562. Select same range from large number of workbooks
  563. Extracting same column from large number of workbooks
  564. How do you count number of characthers in a single cell?
  565. How do you count number of characters in a single cell
  566. Re: Populate the subject line.
  567. Re: How do I make excel startup in a specific sheet?
  568. How do you count number of characters in a single cell
  569. Sumif help please
  570. SUMIF using VLOOKUP as criteria
  571. Dynamic Print Range Help
  572. Bob Phillips, I have one more question
  573. Count in Pivot Table
  574. need to fill cells automatically
  575. Why does Excel 2003 freeze when saving a workbook that has importe
  576. Converting Numbers to Time
  577. Attaching labels when using large or small functions
  578. Help on Large Function
  579. vlookup help
  580. referencing cells that return blank results
  581. Determining calculation slowdowns
  582. How do I transfer data between Excell sheets?
  583. Trouble opening older Excel wbks - appears to becode in column A
  584. Want to change the color of a true/false logical statement with i.
  585. merging and transposing cells
  586. sumif help
  587. Find and Go to Value
  588. Purpose of the Microsoft MVP
  589. Lookup Question
  590. interpolation with forecast in a particular interval (HELP)
  591. Maximum Calculation Speed
  592. Calculate Years of Service
  593. How do I create a formula to retun a value of 0 (zero) when a VLO.
  594. How do I mark an item as paid so it is not included in a column t.
  595. How can I get a date to move from 1/1/05 to 1/7/05 -> 1/8/05 to 1.
  596. occurance of numbers in cell range
  597. How do I compare similar rows of data in same worksheet
  598. macro for "entering data"
  599. Result not being returned
  600. "Excel Function Dictionary" new URL?
  601. Excel should have a simpler subtraction formula similar to "sum".
  602. Number is in a text format
  603. How to leave the title row in MS Excel fixed?
  604. $$
  605. Using VLOOKUP with multiple first column matches
  606. how to graph a horsepower curve in excel (horsepower vs. rpm)
  607. Creditwrench
  608. How do I set up a database with Excel with connections between se.
  609. I faxed an excel worksheet and now cannot print?
  610. Vlookup from 2 different sheets
  611. Lookup Functions
  612. Want to input one character to cause related string to display in.
  613. Replace Symbol "Code(63)"
  614. How do I set up a template for calculating absorption costing met.
  615. GETPIVOTDATA to create Purchase in specified month
  616. Formula or not?
  617. what key do i use to duplicate column ?
  618. How to I get a date to go from 1/2/05 to 1/8/05 -> 1/9/05 to 1/15.
  619. Adding more than 30 numbers in a column
  620. Re: Sum values according to category (text)
  621. Buttons
  622. How to continuously update time in Excel?
  623. How do you continuously update time and date in an Excel cell?
  624. Formula to compare multiple rows values based on another column?
  625. Calculate time
  626. Condition now returns error
  627. How can I look up max of one colume and display the colume to the.
  628. How do I find the two lowest values in a range?
  629. Need help Sorting data
  630. HOW TO CALCULATE THE NUMBER OF YEARS BETWEEN TWO DATES
  631. if statement between values
  632. Word wrapping does not expand the cell, why?
  633. sumif
  634. can't open 2 excel program a once
  635. Need Further Help Sorting Data
  636. extract data from worksheet
  637. Help with Protections ASAP
  638. How can I get excel to apply values in a cell before or after date
  639. how to create a condition returning 2 different drop down lists?
  640. how to make number as text and left justified?
  641. Define a range based on another named range
  642. SUMIF
  643. keyboard shortcut
  644. extracting text only
  645. Custom lists - not following defined order
  646. How do I count data in range A:A that is dependent upon criteria .
  647. convert currency in portuguese words
  648. pivot table
  649. reports
  650. Custom lists - not following defined order
  651. =<or=> formula
  652. Round up to 100?
  653. macro recording
  654. how do I count the sum of 2 columns in excel? countif(a1:a100='op.
  655. compound interest
  656. horizontal & vertical scroll bars
  657. How do I select only specific parts of one field?
  658. Design Failure Mode and Effect Analysis
  659. dates, 1st of month
  660. totaling times past 24 hours
  661. sum of cells without #VALUE
  662. help with if statement
  663. how do i bring information from one worksheet to another in excel.
  664. How do I convert cell contents that are Hex to binary?
  665. Calculat years married or age of someone on today's date
  666. Is it possible to create one column with two different width?
  667. Is it possible to create one column with two different width?
  668. Is it possible to create one column with two different width?
  669. SUMPRODUCT???
  670. Drop Down List
  671. Automatically print all page contents in pivot table.
  672. make a macro to move specific rows to another sheet
  673. Auto number w/ different letter-number combos in same column
  674. adding cells that contain formulas that have returned error messag
  675. Last in column formula
  676. count cells with unique numbers
  677. Can auto number (or OFFSET) include letters?
  678. Matching an Array in one Tab with an Array with another Tab
  679. count
  680. Are there any balance sheet templates?
  681. My excell column letters have changed to numbers. I don't want th.
  682. Parsing a column
  683. Date formula
  684. Using formula to calculate a number.
  685. range and cells syntax
  686. Reading a text file ?
  687. Using "IF" statements
  688. copy and fuze for MOUS
  689. Remove complete row containing a single word
  690. Adding the sum of figures in one column if they meet 2 criteria
  691. How do I copy a function for comparison but keep first cell value.
  692. Multifunction for one cell
  693. Add Function to String
  694. Sort Function
  695. Need Zeros
  696. How do I select subtotal for a list when it is in grey?
  697. how to update functions in excel sheet?
  698. I want to send data from one sheet to another
  699. Automatically change text to uppercase
  700. Problem with Analysis ToolPak Add-in
  701. Get External IP and Mail It
  702. How do I set up print titles in Excel?
  703. Validate cells have data
  704. Paste Special values only
  705. My workbook is slow.
  706. Value of the actual Auto Filter
  707. COUNTIF in one colum then COUNTIF in another...???
  708. Deletion of rows where a value is satisfied
  709. count & Autofilters
  710. Re: Sum values according to category (text)
  711. print tickets with incrementing numbers in Excel ?
  712. 3D Workbook??
  713. Saving a Workbook
  714. Chart linked cells?
  715. Manually update links
  716. copying existing function
  717. use check boxes in excell
  718. Sum Criteria
  719. Using "Get External Data"
  720. Excel time/duration spreadsheet
  721. view list of worksheets contained within a workbook
  722. Blank cell criteria
  723. Automatically number invoice
  724. Compare ranges different size
  725. paste special (values)
  726. Formula changes on own accord
  727. LOOKUP??
  728. Time and date calculations
  729. Avearging columns with less than (<) text entries
  730. Adding values from one worksheet to another
  731. numbers in cells are automatically divided by 100. Not a format s.
  732. How do i transfer certain lines from one list to another
  733. If Then statement
  734. If Then statement
  735. set hypothetical values for a cell
  736. Custom re-curring values in footers
  737. Product Function in Pivot Tables from Multiple Consolidation Range
  738. iF STATEMENTS WITHIN CONDITIONAL FORMATS
  739. can i delete "lookup" from right-click in excel 2003?
  740. pivot table report
  741. settings
  742. Remove pages?
  743. Sub-Totalling Based upon a changing field
  744. Excel: Value Lookup
  745. drop down menu length
  746. Cell color change in formula
  747. Convert 20050118 to a working date field
  748. vlookup & conditional formatting
  749. Color Formatted Cells not showing color
  750. find parts of a total
133