PDA

View Full Version : Microsoft Excel Worksheet Functions


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

  1. yield on bond priced over 100
  2. Get different numbers to return text??
  3. filling up data in blankrows!
  4. How can I fix values in cells calculated by formula in Excel
  5. Sum
  6. Protected Row-Oriented Data Entry
  7. Compare and match names and extract a cell content
  8. Heading at the top of page...
  9. Cannot group by date in a pivot table
  10. countif, multiple criteria...
  11. Non Leap Years I want to show 28, leap years show 29 in an"IF"
  12. Show DateValue as Text not decimel
  13. Have 2 columns of names - need to filter out names not duplicated
  14. Is there a simple worksheet method to determine a cube root?
  15. Conditional Population in separate Worksheets?
  16. Formatting month values
  17. SumIF
  18. Using a MODE formula in a Pivot Table
  19. list formula for dates
  20. Inserting a revision date to an Excel document
  21. formulas / rounding
  22. Text "comparison" operator for "contains" used in an "IF" Function
  23. help please
  24. help please
  25. How do I look at two worksheets in same workbook at same time?
  26. How can I group formating, not data on worksheets?
  27. Does how #s are listed affect IRR calc- same #s vertically vs. hor
  28. pivot Table
  29. Calculated cells in Excel
  30. How do I save Filters, so that they appear when I open a sheet?
  31. conditional formula
  32. How do I combine 2 COUNTIF formulas??
  33. I have a problem fillling series with indirect function
  34. pivot table option is greyed out
  35. Fold / unfold without subtotals function
  36. In Excel, what do the dollar signs mean in $A$1
  37. Can I add and IF function to a SUMIF function?
  38. Nested ifs and conditional population
  39. Workday function
  40. Excel should allow more than 65536 lines.
  41. Conditional auto-filtering to summarize data
  42. is excel really what I should be using?
  43. Make cells negetive amount
  44. How do you cause a cell to flash in Excel?
  45. Excel should let its worksheets be arranged (tiled) in a workbook
  46. How can I retreive rows from one column?
  47. calculating formulas in excel
  48. Copy Values in a cell (derived from formulas)
  49. Repost: Summing clock in and out by date
  50. how i do to make a self filter in more than 3000 lines?
  51. data subtotalling isnt working properly on my spreadsheet
  52. Software Update INVENTORY Query
  53. MsgBox alerts
  54. Calc RSQ and exclude zeros
  55. "Insert Function" pop-up in Excel 2003, has anyone figured out ...
  56. modulus 11 formula
  57. Creating input messages or comments
  58. Find the first Sunday for a given year?
  59. Cells color automatically dependant on value
  60. Re: =average
  61. Can't open a png file when hyperlinking through Excel. How to do?
  62. Category Labels(X) axis on a chart:
  63. AutoFilter
  64. msg box
  65. Copy/Cut and paste
  66. I have a list1 and a list2, I want to remove list2 from list1
  67. Moving data between worksheets ...
  68. make multiple cells in 1 worksheet equal multiple cells in another
  69. Column Merging
  70. Allow header/footer to copy to other worksheets in 1 spreadsheet.
  71. HELP? nested, complex, vlookup? The impossible!
  72. MIN IF
  73. Concatenate and remove blanks
  74. xnpv with actual/360
  75. how do I turn ON auto REcalculate for formulas if new data enter?
  76. If(And for Conditional Formating
  77. IF, OR, AND function
  78. Summing clock in and out by date
  79. Need A Formula
  80. Adding same cells across multiple worksheets
  81. Cell just shows formula after named region var change
  82. column truncated due to width constrain
  83. Combine text and formula?
  84. consolidate totals
  85. Inventory and Date Ranges
  86. Can an if then formula be done for this?
  87. need if formula for 12 months
  88. formulas
  89. LOOKUP problem
  90. Searching a range of numbers for a specified total
  91. Funtion or Pivot Table?
  92. How do you use countif for values in every four cell in a row
  93. Formula nesting
  94. Lookup or Summing problem
  95. How do i separate full names appearing in single cells?
  96. IF sum is GreaterThan 0... why wont this work!?
  97. How can I find duplicate numbers within a column?
  98. Basic formula for linking data
  99. Date and Time formula
  100. How to return first 3 digits of a number?
  101. List "OPEN" orders based on a status column
  102. Comments in Excel saved to HTML
  103. count col-A if col-B = condition
  104. Lookup function
  105. Trying to get an IF/AND average to work
  106. How do I link cells from a workbook, to talley one one sheet?
  107. Forcing Input from a user
  108. remove read only - not showing up in properties
  109. proper syntax order
  110. A question about VLOOKUP / any other helpful formula
  111. INTERformula precendence
  112. nesting another formula
  113. can I use IF as a GO TO command?
  114. My formula returns a result but the cell displays a zero?
  115. using a selection box and moving the accepted data
  116. Meal Break on Time Sheet in Excel
  117. Workday - Saturdays Included - Holidays Excluded
  118. Printing only certain rows?
  119. Combining Row Contents!
  120. Copy based on conditions
  121. Different column widths
  122. Adding then dividing
  123. graphics placement
  124. Rounding
  125. Replacing last digit with Zero
  126. Still need help on outstanding question
  127. Workday With Weekends Excluding Holidays
  128. Total an array
  129. GOLF Spreadsheet problem
  130. How to enter data in one row cell only in a cell range
  131. Excel Count Formula?
  132. Auditing
  133. Countdown formula
  134. Autorun macro
  135. cHARACTERS BEFORE THE SPACE
  136. 20 yr Replacement plan for assets
  137. ISODD and EVEN formula
  138. Excel Macro - Merge Cells unavailable - Unable to figue out why.
  139. wrapping text in excel
  140. formula to calculate a 401K company match?
  141. Troubleshooting Template Wizard in Excel
  142. Excel 97 date diff
  143. Need some help
  144. Matrix in cells
  145. VLOOKUP & Dates: Why is this Formula working?
  146. how do I create a formula to convert kilograms to pounds
  147. need a formula for setting colour target cells
  148. Price Function - Difficulty in understanding the formula
  149. combining and sorting 2 lists
  150. need help to create a formula
  151. Using Column in Sumproduct
  152. Auto-Numbering Occurrences Question
  153. Date Comparison and IF statement
  154. Is it possible to save work on the clipboard and reuse ?
  155. Hypertext Links
  156. Column Problem Help Please!
  157. Copying Pivot Tables from one workbook to another
  158. Counting occurrances
  159. cell format for date/time in same cell excel 2003
  160. If I have two reoated data-sets and a common code, how can I get i
  161. Formula
  162. in workbook, where is delete worksheet
  163. Sort by date - just not getting it all the way there
  164. Page numbering multiple worksheets in a file without affecting set
  165. Formula Help
  166. chart help
  167. Formula
  168. Formula please to highlite every second Row.
  169. "Indirect" refs to other workbooks
  170. If, then
  171. Count if ('true) does not work
  172. IF Formulas
  173. VBA Function that ignores dates in a Holiday Table
  174. =OFFSET(cell("address"),-1,0)
  175. Determining which cells are locked.
  176. How can I calculate hours in a Hourly schedule in Excel?
  177. Subtract/divide answer/add in one cell
  178. Filling in a number x, y times in y cells
  179. Store an image inside a cell?
  180. Need a formula that will turn a date red if that over 60 days
  181. search and export multiple records
  182. HELP! Hyperlink Recovery Problem
  183. Combo Box sorting
  184. calculate years worked by 3% * salary in excel
  185. How do I generate a "blank" value?
  186. Finding Names
  187. Formula error
  188. Sortin method advice please
  189. RE:GRIDLINES ON SOME OF SHEET AND NOT ON OTHR PARTS EXCEL
  190. Re: Want Vlookup to list multiple items with the same key?
  191. Re: Want Vlookup to list multiple items with the same key?
  192. Difficult Two Column Lookup
  193. Need formula or Function to sum value of every other cell in a col
  194. Difficult Two Column Lookup
  195. Adding 6 Months to a Date
  196. #N/A in VLookup - Can I use another function that will return 0?
  197. using muliple functions to return one result
  198. Help with Countif
  199. "sumif" With Multiple Criteria!
  200. How can i keep formulas in a spread sheet when it is saved over?
  201. cummulative sum
  202. Summary total from another worksheet?
  203. Compare worksheets
  204. Converting Negative Number to Postive number
  205. Formula Help... Thanks Tom
  206. Calculating time interval (some across midnight)
  207. Formulae in spreadsheet no longer update with new data
  208. IF AND Function problems
  209. Linking clip art
  210. Re: Excel - WsF - Dan B
  211. Re: Excel - WsF - Dan B
  212. COUNTIF 2 Conditions using Defined Names
  213. Formula Help
  214. Help, too difficult for me.
  215. refer to drop down item as a sheet reference in a formula
  216. COUNT IF
  217. Issues in Opening a file
  218. STOP BLANK CELLS
  219. excel 2000 worksheet
  220. VLOOKUP using date problem
  221. need to change writing to bold by only typing, not changing cell
  222. auto filter not working on all data
  223. offset a lookup in excel
  224. Renaming Column
  225. Renaming Column
  226. Re: Want Vlookup to list multiple items with the same key?
  227. RE: Want Vlookup to list multiple items with the same key?
  228. Days calculation between months
  229. How can i add a print-and save-date field in Excel as in Word?
  230. Macro's
  231. Price function difference in Output formula vis a vis Manual Calculation
  232. Re: What function to use
  233. Checking names on correct line across sheets
  234. Mulitple conditional formatting
  235. Copy Pivot graph
  236. vlookup working sometimes, sometimes not
  237. 30 Day Moving Average Ignoring Blank Cells
  238. Newbie needs help deciphering formula.
  239. FIND THE LAST CELL ENTRY IN A ROW
  240. was working, now :(
  241. Summing weekending dates
  242. How to create a link including all formatting from origin cell?
  243. select numbers from a list and add to optimise result
  244. excel division formula question
  245. How can I use DGET in Excel with criteria that changes each line?
  246. How to enter numerical numbers in rows where value is same
  247. Changing other fields using IF Function!?
  248. To fix a sheet in MS Office to be opened first always
  249. Conditional Formatting
  250. How to manipulate controls added at run-time
  251. Input Mask
  252. Having trouble sorting numerical data from SQL analysis cube
  253. how do I multiply dollars by networkdays for forcasting run rates
  254. Remove duplication from validation list?
  255. validation/list properties
  256. Paste link problem
  257. Which function to use?
  258. Autofill problem
  259. Rounding to nearest 5 cents in excel
  260. one column on my excel spreadsheet will NOT format the date
  261. Need to align text around a symbol???
  262. Help with formula, IF, AND, OR, etc.
  263. Color Excel Spreasheet print previews in black/white. Reason?
  264. Looking up a value using a range
  265. Using the NOW() function without it recalculating
  266. cell calculation check if result is negative and zero out if not l
  267. Copy Function Without Range Update
  268. setting up a pricelist?
  269. labels
  270. =SUMPRODUCT
  271. "Between" function?
  272. automatically numbering rows
  273. Fix Excel'S Proper() So It Won'T Miscapitalize Contractions
  274. How do I use Lookup to return a row of values eg. 6 cells
  275. number sequence gap
  276. Need help with this formula...
  277. Can I lock cell contents after current date is past?
  278. Excel 2003-color coded reference cells has stoppped on a spreadsh
  279. How can I add a fixed value to all cells in a table?
  280. help creating a formula using IF and AND
  281. How do I insert a comment in unlocked cell of a protected workshee
  282. Transfering Data from Several Sheets to another
  283. Date programming
  284. count if
  285. Unicode
  286. Extracting All But Last Word
  287. Get the reference from a referenced cell
  288. Calculating Bond Price
  289. nesting conditional formulas
  290. how to seperate into columns?
  291. what are the uses of merging?
  292. how do i convert a column of minutes into hours
  293. Counting again
  294. How to lookup the value next to a lookup result
  295. i want to import data from one workbook to another and add a row
  296. Help with INDIRECT function.
  297. Index/Match from multiple columns
  298. date updated conditionally based upon other cells
  299. Computing Mutual Fund Diversification
  300. Count if Multiple columns
  301. lookup multiple values
  302. Add a warning popup to a Macro Button
  303. formula suggestion please
  304. Weighted Average
  305. Cut/Copy and Paste Functions without old links
  306. Multiple V Lookups
  307. Loopy?
  308. Running macros automatically-AutoFit
  309. how Excel can copy the data in a row of worksheet to other?
  310. Multiple conditions...why wont this work?
  311. Checking 2 sets of values to provide True False
  312. Conditional math using AND, Average
  313. Print range names and how know if have too many?
  314. How do I count like dates in a column with format "January-05"?
  315. Store Functions by a name
  316. How do I get cell data in multiple Excel files into one summary fi
  317. Average function with #VALUE! error in reference cells
  318. HOW DO I ADD AMOUNTS FOR DIFERENT VALUES
  319. How to link an Image to a cell value
  320. add non-contiguent sums in one column to a Grand Total
  321. Common Text Entries
  322. How to translate excel function names from english to local langua
  323. Perpetual calander
  324. template
  325. Functions
  326. Turning a negative into a positive
  327. turning student scores into a level???
  328. conditional formula: return 1 of 4 values
  329. How to insert random phrases
  330. EXCEL SPREADSHEET SET-UP QUESTION
  331. DATEVALUE works on one sheet, not another
  332. back date calculation?
  333. IF function using dates ?
  334. how to consolidate large worksheets w/ 800~1000 rows by category?
  335. Sum Cells within each date.
  336. mortgage formulas etc..
  337. Unique values
  338. parentheses
  339. Creating Array formulas with multiple criteria
  340. How to perform two actions ?
  341. Convert Values to formulas
  342. Function needed????
  343. HELP WITH EXCEL SPREADSHEET
  344. How do I exit a macro subroutine?
  345. Templete question...I hope there is an answer
  346. Calculate the closest day
  347. Multiple condition help needed
  348. How prevent email address from being hotlinked to open send msg wi
  349. what does the symbol "^" mean and how can it be represented in a f
  350. IF it will work?
  351. Excel Formulas
  352. The 7 nested If() function Limitation. Is there anouther way?
  353. Refer to a url and retreive info for a spreadsheet
  354. How does Excel Sheet with combo box show it when used projector?
  355. Insert row to EXACT function
  356. HOW DO I REDUCE THE SIZE OF A WORKSHEET TO THE CURRENT USED CELLS
  357. How to switch column headers from numbers back to letters?
  358. Looking up several number
  359. Sumif question
  360. Looking up several number
  361. Find, Lookup, Match, can't figure it out.
  362. Use lookup or ??
  363. Sorting a column to use with an INDEX function
  364. Vlookup for range, help
  365. If Statement linked to cell with VLOOKUP problem - getting wrong v
  366. Excel 2003 has wrong timing using the worksheet_change macro
  367. IF/AND used with SUMPRODUCT?
  368. How to set highlight for the column&row header of the active cell
  369. Formula to extract digits from a text string?
  370. Formulas
  371. How clear the cut/copy blinking boxes after macro
  372. Projecting sales dollars based on actual history
  373. Holidays
  374. return value based on two criteria
  375. filter by frequency
  376. vlookup - i think
  377. Why can't I scroll down?
  378. Problem with SUMPRODUCT and Arrays
  379. Re: Help typing formula
  380. casing
  381. Re: date formula for extracting unique dates
  382. date formula for extracting unique dates
  383. SUM formula - using variable values
  384. formula to calulate length of time
  385. RE: Help typing formula
  386. data query
  387. Counting blanks, either 1, 2 or 3
  388. How to estimate a future service date?
  389. Right Function
  390. How do I make longer a drop-down list (the window) in excel?
  391. =countif (h3:h16">=01 01 2006") how to substitute cell for date
  392. How to do I convert angles from radians to degrees in Excel?
  393. Average when No Data
  394. Currency format within an equation...
  395. How can I Lock Formatting?
  396. Re: Help writing a lookup formula
  397. How many business days were in 2005?
  398. How can I get the value of a cell to increase in steps?
  399. Data Validation with Defined Name
  400. Exceeding the limit for Nested IFs
  401. index or filter?
  402. COUNTIF Function
  403. Problem with link
  404. loan amount pay per share
  405. Formula to recognize Duplicates
  406. repeat rows for add'l pages for tabs on a multi-tab worksheet
  407. VLOOKUP bug?
  408. Counting or Total Formulas -- Further Explanation
  409. When February 29 is date?
  410. Spreadsheet protection password
  411. how do i find palindromes using excel?
  412. Nested IF question
  413. Using subtotaling and protecting a sheet at the same time
  414. sumif less than 11/30/2005
  415. Totaling amounts based on duration
  416. Changes in date functions between excel 2002 and 2003
  417. How many formula
  418. How do I use the "SUMIF" function using dates as a condition
  419. Zero Suppression in Excel barcode fonts
  420. Formula to copy text from a column in different workshhets
  421. Circular Reference... Help!
  422. Vlookup over multiple sheets
  423. date intervals
  424. calculating date intervals
  425. Cell problems - need a quicker way.
  426. Error Messages
  427. Rename Defined Names
  428. Help Tidying up formula
  429. Sumif function does not add up cells, even when criteria is blank
  430. More elegant method?
  431. DSUM Switched Off?
  432. Cell format changing on the fly
  433. Formula to see if a cell has an entered value
  434. Re: Fill colours
  435. bold part of cell unavailable at time
  436. advanced filter
  437. Pivot table - Custom calculation question
  438. How to create a formula 5 to 10% based on given list of price
  439. Nested Loop Link
  440. password protected page not opening by web query
  441. Moving data from from one worksheet to another
  442. Infinite Updating Column
  443. Mixed Cell
  444. How to return a single value for a range of numbers
  445. creating an hourly matrix (scheduling)
  446. countif based on fill color
  447. conditional date formula
  448. Math Experts - Function to compare where salary is compared to others have 800 rows of data
  449. insert colons in time automatically when input to cell
  450. unwanted date conversions
  451. Using AND function to evaluate cells
  452. HOW DO I DRAG AND DROP W/O TAKING CELL BORDER?
  453. SUMPRODUCT or COUNTIF?
  454. how to loose all numbers after decimal (not rounding)
  455. Trasnsposing or copying filtered data from one sheet to another
  456. Testing for Cell Fill Color
  457. How do I create a sheet in Excel that updates itself from other sh
  458. Converting Dates to 8 digits
  459. I need a formula
  460. How do I bulletize in Excel, analogous to Word?
  461. menus don't work
  462. Max number of named ranges
  463. sequential numbers
  464. Is it possible to have a formula for the following scenario please
  465. sum, lookup, and date range
  466. grab detail when = > 1
  467. Formula to display last few entries
  468. identifying a string of positive numbers
  469. HELP! Single cell formula to calculate weeks cover of stock on forward sales.
  470. Pivot tables
  471. Collecting weekly and monthly totals from daily data
  472. Can unmerged cell contents be split to another cell
  473. Is there an array function or something like it?
  474. Importing Workbooks into a Master Workbook
  475. Copy info in a range that always changes.
  476. re: how do i do this
  477. Need formatting help
  478. Excel: How do I change all upper case ss to proper case?
  479. Print unique values
  480. How do I set up multiple logical conditions on one result cell
  481. Return SEARCHED Column Number of Numeric Label and Value
  482. Help! data from pasted table is not included in sum
  483. Counting Formulas -- Re-explained
  484. EXCEL LOOKUP
  485. RE: Macro Problem
  486. Quick answer please!
  487. How to use an index number in a search range
  488. Time format to number while keeping value
  489. excel, i want to add 20 in increments to the number 101+20
  490. Cell Reference Question
  491. Problems shading a cell!
  492. How do I insert manual line breaks in excel?
  493. Using the paste link function in Excel 2003
  494. Modify a Macro to Repeat for all Selected Worksheets
  495. Transpose Reletive Cell References?
  496. Calculating Time Past Midnight
  497. How do I add a second criteria to the SUMIF or DSUM function?
  498. Array
  499. formulas in excel are not working
  500. Any quick key for entering Current Date and Time?
  501. My excel document is opening two versions.
  502. Pivot Table Totals Incorrectly Summed
  503. if formulas
  504. How to name cells?
  505. how do i do this?
  506. Substitute for Dragging
  507. Format cell to show colon
  508. How do I use an Excel interactive calendar?
  509. Re: Show + beside positive number?
  510. how do i format a cell in Excel to 3 significant numbers
  511. Calculating number of instances occuring in an hour for 24 hours
  512. Having a Macro Prompt Me For Input
  513. Making cells "unavailable"
  514. "In Today's Dollars" help needed...
  515. Calling macros in another workbook
  516. LOOKUP question
  517. 5 highest then list names
  518. How do I tell a price list to round up and down to the nearest 25
  519. Need help in conditional formatting
  520. How do I protect the cell from users entering values in Excel?
  521. how to restore worksheet's gridlines & attributes
  522. How can I protect cells and allow users to insert/delete
  523. File copy
  524. VLOOKUP help needed!
  525. My worksheet has turned grey and is not working
  526. Worksheet has turned
  527. selecting columns in a worksheet
  528. conditional minimum value of various cells?
  529. IF statement help
  530. Extract the first few characters
  531. Sum column based on column heading
  532. How to convert an excel spreadsheet into a Powerpoint page?
  533. Posting date
  534. How do I select all values within a category in Excel?
  535. Duplicating cell value between worksheets
  536. return multiple corresponding values in excel
  537. Boolean comparison: range vs. single cell
  538. help comparing two sets od data to find the odd data
  539. SORTING DATA TO ANOTHER SHEET
  540. SORTING DATA TO ANOTHER SHEET
  541. Added new columns - Pivot Table not refreshing - why?
  542. Insert times including seconds?
  543. IF formula - evaluation shows it should work but...
  544. How do I make items repeat on a pivot table?
  545. time problem or excel mistake
  546. Excel Link problem
  547. Repeating a Macro For Each Selected Worksheet
  548. Help With Formulas Needed
  549. linking cells in one worksheet to cells in another worksheet
  550. Return value if cell greater then 0
  551. I'd like to make a formula that does this..
  552. Number value based on date function
  553. sorting by date
  554. Comparing two lists and extracting data from one to another
  555. Comparing two lists and return specified data
  556. making changes
  557. color coding
  558. Repeating Rows
  559. Average function question
  560. is there a way to auto copy cells similar to auto sum?
  561. Keeping track of Sickdays, Vacation days, and hours for each.
  562. Conditional Auto-Population
  563. the name tabs at the bottom of each page, how can they be made big
  564. importing csv files, problem with date formats
  565. Lookup and paste as value
  566. Count Cells if diff cell meets conditions
  567. RE: Tex Dates to numerical Dates
  568. Totals of calculated field in pivot table give incorrect results
  569. Is there a Function for Appreciation
  570. Protecting Worksheets
  571. what is the underlying formula for the percentrank function
  572. can lookup return err if no match found
  573. Finding All but Last Word
  574. way to get jus the number off the cells that have functions in them
  575. Need Help
  576. Different print page setups on one worksheet?
  577. Fv & Emi!
  578. Is there a SUMPRODUCT-like function that I can use on text?
  579. if cell has been changed...
  580. Apology
  581. How do I change the default folder when I import data?
  582. Take a list from one workbook and apply asdropdown in another work
  583. How do I copy a column into a row and keep the links?
  584. Please Help!! Macro error
  585. business days - trade date plus 3
  586. EAN/UCC-14 Barcode: set Excel column widths based on a cell value?
  587. Mathematical elimination
  588. Macro that filter data
  589. Graph
  590. automatic list
  591. conditional fields in a picote table (I think)
  592. Problem with Subtotals
  593. how to add many cells on diff. sheets and put in 1 cell in excel
  594. Day / Date Formula
  595. Seeking help from a GURU
  596. Precision in formulas?
  597. Copying all formats from worksheet to worksheet
  598. Autofill a series
  599. Vlookup return 0 when cell is blank
  600. Shortcut for wrapping text
  601. import excel data into existing excel report
  602. Change the text format for weekend days (Sat, Sun)
  603. DCOUNT? DSUM?
  604. CARET or ^, as in CTRL but CTRL !!! ???
  605. Combo box from MSQuery
  606. Does such a function exist ?
  607. COUNTIF-how do I count the quantity of 'H', as opposed to 'h'?
  608. Text box acting as a notifier?
  609. How do I delete rows with negative values all at once i.e. 47,000.
  610. formulas producing unjustified results
  611. How can I make a formula in Excel showing when the file modified?
  612. Grouping in Pivot Table
  613. Is there a simple way of removing duplicate data in Excel?
  614. Formula question
  615. How do I get the unique values from a range?
  616. #VALUE in formula as opposed to result
  617. PivotTable -adding more than one function
  618. COUNTIF multiple crietria
  619. Matching Data in Columns
  620. How to make drop-down menu of months in schedule,when сhoose it - columnes are added?
  621. Iterating files in folder
  622. List Object and Protection
  623. Solving sets of equations
  624. Want to compare two columns and then fill with data from the match
  625. Mode - getting bi- and multi-modal results??
  626. time sheet that takes out taxes
  627. Add 15 minutes
  628. solve a inverted matrix
  629. Auto Fill Cells, When Choosing From Drop-Down List...
  630. Finding Maximum
  631. Formatting in Excel
  632. Working with Arrays
  633. Conditional count of rows dependent on multiple columns
  634. New a little help
  635. Copying formulas referencing multiple sheets
  636. SumIF
  637. to search for a string and affect data if it finds the string?
  638. How do I copy just the "web page name"?
  639. Linking two "total" pages to create a "Complete Total" page
  640. How do globally clear pre-marked cells
  641. Unclear about hot to automate searchs
  642. How can I copy and paste an entire workbook?
  643. is there a problem with hyperlink in excel 2003
  644. IF Function!?
  645. Need help with a formula
  646. Excel
  647. conditional formatting with four conditions
  648. Formula to retrieve range of dates from a worksheet to calculate d
  649. I can't drag a worksheet to sort
  650. do you know how i can find the f(x) of the arctan?
  651. Create drop down box with the formatting of range cells colors ect
  652. adding/subtracting time
  653. Auto Calculation not working
  654. Can this be done...?
  655. excel 2003 right-click function not working
  656. How do I make the Stop Recording bar pop up when recording macros
  657. COUNTA
  658. Why does Excel change the dates I input?
  659. Conditional Worksheet Access Question
  660. Recorded Macro to Copy Format
  661. Is there a simple solution?
  662. I want to print at 100% but prints only at 60%
  663. Overline the sum instead of underline the number
  664. I need help with the IF Statement
  665. need a template for quilters/crafts for things to make
  666. how do you find a excel spreadsheet that you replaced with a new
  667. can conditional formatting on one cell value to another cell valu
  668. COUNTIF with Logic?
  669. count colored cells?
  670. Need to revise formula
  671. Need to revise formula
  672. Need to revise formula
  673. Cumulative Sums in Pivot Tables
  674. How can I add rows inbetween?
  675. Fill Sum of months by quarter
  676. Freeze pane
  677. Comparing Birthdate to specific date in the future
  678. How do I find a % difference between two numbers (comparing 2005 .
  679. How do I change the Tab spacing in Excel 2003?
  680. Lookup
  681. Macro with Array Function Problems
  682. Excel Charts - Time line for random points on X axis
  683. basically want to go from mm/dd/yyyy to yyyymmdd
  684. help with an if statement
  685. Re: Divide Monthly Sales Budget to Day Budget
  686. RE: Divide Monthly Sales Budget to Day Budget
  687. In Excel, how do I look for the last number either 0 or 5
  688. In Excel, how do I look for the last number either 0 or 5
  689. Sort referenced sheets together!
  690. Double lookup count
  691. Excel Formula with two clauses
  692. =If() results based on cell color?
  693. Edit/Move or Copy Creating .xls on Tab
  694. How do I format tabs to automatically go to next cell I want
  695. Formulas, question for Roger Govier
  696. Character Count
  697. exporting e mail adresses from Excel into Outlook
  698. importing fixed machine data to excel
  699. Determine number of days
  700. Using INDIRECT in INDEX(LINEST.. ) function
  701. import von konstanten workstation - daten
  702. how do i convert weight (stones+llbs) to llbs?
  703. Nested IF.. is it the right one to use?
  704. Please help with enclosed schedule of duty
  705. File reference
  706. Looking for the truth !!
  707. formula gives 2 different answers
  708. pivot tables
  709. Lookup Two Columns - Again
  710. Conditional MS Query
  711. Convert Hours to Decimal
  712. If they are or not?
  713. locating the top 5 number (in a col)
  714. location of cell
  715. How do I generate a new sheet based on date/week/month?
  716. Create a Value for a cell
  717. How do I sort a range of cells via a worksheet function
  718. IF/WHEN forumla fo when a cell is between two numbers
  719. IF/WHEN forumla fo when a cell is between two numbers
  720. IF/WHEN forumla fo when a cell is between two numbers
  721. Grand total in Pivot-Table
  722. Add protect worksheet password in macro
  723. can I lock just the formular in a cell
  724. how to get column totals on each page?
  725. need help with functions
  726. Leap year date problem
  727. How do I count values across multiple columns?
  728. Something Along The Lines of a SumIf, but not
  729. copy down an indirect formula
  730. taking out lowest 2 values
  731. Reference External Worksheets & Protect Worksheet / Workbook
  732. Rounding Subtotals
  733. how to extract a specific range of days (7 or 30) to make a chart
  734. Function to find only exact matches in spreadsheets?
  735. Re: Find LARGE, and th cell 3 cells to the left?
  736. combining cells
  737. Copying a formula to multiple worksheets
  738. Auto Coloring a Row
  739. Averaging excluding min and max numbers
  740. Creating a table based on rank
  741. Automated Reporting
  742. Counting occurrences over range of sheets
  743. automatically updating "school event record" formula
  744. Data ranges within a column
  745. template to use to track employees
  746. When I select from drop down menu I would like the next column to populate a specific cost.
  747. formula references vertical cells in a separate worksheet
  748. formulas\conditional formating
  749. a sort of GROUP BY data extraction question...
  750. Counting cells not containing specific text