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. how can i calculate uk apr with excel
  2. Hyperlinks
  3. Unique Dynamic Validated List
  4. Can I protect a range of worksheets in a book with one action?
  5. Get Column Letter from Column Number
  6. I need to do a sumif on data that [contains] a specific string.
  7. photos on excel webpage
  8. Can I place a formula/cell reference in the Header/footer Excel
  9. Replaceable parameter in formula
  10. CopyCellContents
  11. Concatenate and Mail Merge
  12. How do I create columns that expand and collapse in Excel?
  13. excel
  14. list comparison
  15. worksheet functions
  16. Select top 5 in column A, sum values in B
  17. Not Lookup
  18. Lookup Table Dilemma
  19. Grouping
  20. Setting dynamic range in a formula
  21. question re: macros
  22. How can I DISPLAY Filter Criteria
  23. forms and functions
  24. How do i format a 5 to 6 digit number into the correct date?
  25. How can I add values to a closed excel file?
  26. Suming 2 cells if 1 = #N/A
  27. worksheet functions2
  28. How do you change the color of a hyperlink after you click on it?
  29. FV Function Problem
  30. LookUp Type Question
  31. Excel formula
  32. "IF" function: Can a calculation be an answer? help plz
  33. Hide AutoShapes On Excel Worksheet
  34. Multiple Conditions in a cell
  35. Vlookup that does not return #N/A
  36. How can I prevent email addresses from automatically hyperlinking.
  37. Formula to identify cell with different value in list
  38. "Delete sheet" not an available option on File menu.
  39. Count help
  40. The formula to operate in shhet2 please.
  41. Add new inventory list to existing list
  42. macros security settings on Excel 97?
  43. How do I tab within a column using the tab key?
  44. Incremental comparison
  45. Nesting functions in the functions dialog box
  46. Re: Wildcards in Functions
  47. Lists
  48. multiple possible result in one cell...
  49. A formula to show Next month
  50. How do I create a Map with an Excel worksheet?
  51. Combinations
  52. adding summed cells in a conditional sumif
  53. Re: Transpose Arrays with variable row counts
  54. Change sheet name on linked cell by dropdown box
  55. how do i automatically sort data in a pivot table
  56. How to copy paste from Excel and leave the pasted data editable?
  57. A Function for Counting Since Last Time
  58. Losing data on copy and paste functions
  59. Re: Transpose Arrays with variable row counts
  60. arrays and pivot table
  61. SUMPRODUCT with Wildcard
  62. Re: Transpose Arrays with variable row counts
  63. coloring every other row in a range
  64. Looking up a value in a different file
  65. how do i subtract a negative number
  66. Macro Help
  67. Vlookup with to parameters
  68. Sort
  69. Excel to automatically enter a date
  70. need help in correcting the formula
  71. correction of formula please............
  72. skus in columm a for each sale, qty. of skus sold, each sale in co
  73. Password protect a workshhet on the net?
  74. Pictures in a worksheet
  75. between dates
  76. Combine 3 Columns on Sheet2 to Display in 1 Column on Sheet1
  77. From x date To x date you have earned x$ (dates are not the same)
  78. From x date To x date you have earned x$ (dates are not the same)
  79. +1, Alpha *and* Numeric
  80. Re: Is there a function to change a number to text?
  81. Multiple criterion including wildcards to sum in a range
  82. Venting
  83. calculate no. of years between a date and today's date
  84. SCurve function in Excel
  85. Sorting two columns of data
  86. keep totals from month to month?
  87. How do I make all pie charts identical in size
  88. Can you paste values on multiple worksheets at one time?
  89. Entered text value equals a number I specify in another cell
  90. sumproduct in a range
  91. how can I activate a 'numbers' duplicating prompt (help)
  92. Change character while copy
  93. How do I copy Page Setups from one Sheet to Another sheet?
  94. automating get external data (from web)
  95. substitute
  96. SUMPRODUCT help needed
  97. Counting within a filtered range
  98. Replace "-" with "0"
  99. 6.00 to this 0600 please
  100. How do I make a blank cell with a date format blank?
  101. Date Format Inside of a SUMIF Statement
  102. Conversion of Figure in Words
  103. Text number to number value for calculating
  104. Re: Text number to number value for calculating
  105. Lookup Formula - but have a formula if it can't find/match a value
  106. print different worksheet by pressing visible button on worksheet
  107. How I can built combo box step by step
  108. Need formula to find and sum values in a different spreadsheet
  109. Need help with creating a text file via excel
  110. formula/function question
  111. Question when Copying an Existing Worksheet
  112. How do I use the Transpose Function
  113. How can I turn auto correct on or off for one column only?
  114. CHANGE "C" TO 100 TO FIGURE EXTENDED COST
  115. Extract Text--Hopefully Easy!
  116. Update cells formula
  117. Consolidation
  118. Pivot Table not Updating
  119. if blank cell, don't calculate
  120. Lookup formula - treat no-registered cells as blank
  121. IF Statement Question
  122. need to make a cell with numbers ascend when printed in multiple?
  123. date calculation issues
  124. Exporting from Excel to a Fixed Length Flat File
  125. DSum problems
  126. automatic input of cell values
  127. HLOOKUP improvement?
  128. Subtotals & Filters
  129. Number of semi-monthly periods between 2 dates
  130. VLOOKUP question
  131. Can wildcards be used in SUMPRODUCT conditions
  132. Pivot Table Grand Total - Calc Item
  133. Excel Auto Shortcuts
  134. lookup question
  135. Lookup , match, not sure !?
  136. I cannot see my worksheet I think I restricted it somehow
  137. Formula Please
  138. If/Then formula help
  139. How do I conditionally delete rows based on cell contents?
  140. excel consolidating
  141. AUTO COUNT IN A CELL WITH EACH TIME USED/ OPENNED
  142. formula to round up?
  143. Output of expired dates
  144. A counting formula that won't count multiple instances of same val
  145. Macro for autofilter using variables declared in worksheet
  146. indirect reference
  147. Neeeed Help!!
  148. how do I convert copied Text numbers into values in Excel?
  149. Excel formula
  150. Excel - Find & Replace text in a string
  151. formula to lookup table in another Worksheet please
  152. Links in Excel
  153. Number to words literal
  154. Macro avoiding circular reference
  155. Changing Worksheet Name in Link
  156. find *
  157. Macro Solution for Link Problem?
  158. cell character extension
  159. Custom Auto Filter default setting should be contains
  160. Lookup or similar
  161. How can I count strings within strings
  162. Querying data from Access
  163. Picking data
  164. Formula equivalent of CurrentRegion
  165. Macro to search for and display data in another worksheet
  166. What is mathematical equation for NORMDIST (x,mean,standard_dev,TR
  167. how do I set up a machine service schedule
  168. IF/AND Statements
  169. Populate a combo Box
  170. Pivot Table Data Field Query
  171. Can I randomize whole numbers in my excel sheet?
  172. percentiles?
  173. Nested Lookup !! ?
  174. Sorting data by date
  175. using wildcards in vlookup
  176. Nested Functions
  177. help with date and time
  178. RANK bug: same values get different ranks
  179. Copy Address Bar Functionality
  180. can a revision # be updated across multiple worksheets in the head
  181. Conditional Sum and DATEVALUE function
  182. Re: countif help for multiple criterias
  183. How to transpose linked data and keep it linked?
  184. PATH SHOW UP - HOW DO I DO THAT
  185. OFFSET command and linked documents
  186. Can I create a formula in Excel that evaluates form information?
  187. Re: countif help for multiple criterias
  188. Pulling larger numbers from group
  189. MAX text
  190. MAXIMUM VALUE
  191. Add two IF statements together
  192. Sales budget
  193. line break in a cell
  194. How do I create a COUNTIF function with more than one criteria?
  195. Rounding Question
  196. Pivot Tables- Total the Subtotals?
  197. Column Chart Question
  198. Set up global custom header and footer in Excel worksheets?
  199. Can Excel do this?
  200. IF Statements
  201. Adding Borders
  202. Excel date function
  203. move spread sheet
  204. worksheet malfunction
  205. change format for phone numbers automatically
  206. HLOOKUP
  207. Delete duplicates
  208. ALL CAPS to regular text?
  209. Counting Unique Values
  210. Formula to spread number across
  211. Array formula not working
  212. How to add only certain rows in a spreadsheet
  213. Selective deletion of rows containing certain text.
  214. Counting unique text/number cells from a range
  215. lookup within a cell
  216. calculation error
  217. indirect cell reference using copies of worksheets in same workboo
  218. Rounding Time Calculations
  219. Need help looking up value based on criteria
  220. need formula
  221. PLEASE help with IF function...
  222. how do I cut and paste into a protected worksheet?
  223. Can I combine the text from multiple cells automatically
  224. how do I cut and paste into a protected worksheet?
  225. how do you copy the same cell reference on different worksheets
  226. How do I convert a net $ to a gross $ in excel
  227. display multiple lines of text within a merged cell automatically
  228. IF Scenario
  229. COUNTIF for 2 conditions
  230. Using Offset to name a range
  231. Counting Unique text entries in a sheet with a condition
  232. re-selection of Chart data range using keyboard
  233. create a top 10 list of sales figures
  234. how do i display numbers in lacs
  235. HELP ME, PLEASE!!!
  236. HELP ME, PLEASE!!!
  237. COUNTIF FUNCTION
  238. Formula related Crash on Opening File
  239. dealer evaluation
  240. How to round up the result in a cell containing formula
  241. nested IF maximum?
  242. sorting two columns together
  243. How do I lookup a value in a array that is not in ascending order
  244. SUMPRODUCT and search string
  245. EXCEL:NUMBER TO GREEK WORDS
  246. EXCEL HEX2DEC conversion error
  247. Accessing WorksheetFunction.XX from regular C# Forms application
  248. A new sequence number in file everytime it is opened
  249. SUMIF function help
  250. Copy and Paste between 2 worksheets with VBA
  251. How to convert numbers with apostrophe's (ex. 219'2) to decimals?
  252. How to input Jan & have a series filled in for the rest of months
  253. Workbook Links
  254. Sorting, Merging, and Re-merging
  255. how do you delete a name in the the open box
  256. Execel Question
  257. Why are my cell being divided by 100?
  258. Combining Text from multiple cells under multiple conditions
  259. countif conditional
  260. How can I use replace(alt+H) for mutiple items needing replace
  261. Automatically changing stock tick quotes to decimal-price format.
  262. multiple pivots updated with selection in one table
  263. pivot field of fields
  264. pivot zero values
  265. what is the excel equivalent to lotus backsolve
  266. pivot date sort/show
  267. forecast function
  268. Modify A SumProduct Formula
  269. Creating a blank when links can't update
  270. How can we formular a dynamic cell? i.e. =B2 as ="B"&"2"??
  271. SUMIF function not working
  272. drop down box calendar
  273. Setting character attributes in a text string
  274. Define list of worksheets
  275. Protect Format OF Worksheet
  276. Reformatting formula
  277. Cant find it!
  278. Calculation in a Row
  279. Save as Dialog Box Mysterious " "
  280. Auto fill in cells
  281. Can I empty the cell who has formula in it
  282. How to protect the cell's formula not be deleted
  283. RE add cells together if value has a formula
  284. subtotal - pivot table - or better function
  285. formula help please
  286. Earliest Date to populate?
  287. My formula Is giving me a #NAME!
  288. Decimal Subtractraction
  289. What is the formula for converting farenheit to celsius?
  290. simple formula
  291. SUMIF problem
  292. Cumulative Sum
  293. Letter/Number Split
  294. array formulas
  295. Cash Flow by Week
  296. PLEASE HELP with the SPELLNUMBER function
  297. SEPERATE NUMBERS IN A CELL
  298. SumProduct Question
  299. Help with what should be a simple formula
  300. Creating norms
  301. Lookup values in multipul sheets and show value in another sheet
  302. pivot date sort/show
  303. con't paste merged cells
  304. How Do I Hide A Row (if a condition is true) using a Macro ?
  305. Creating a certain number of entries based on a number in a cell
  306. Auto Numbering Each Cell In A Column
  307. search in the entire sheet for different letter and cal.
  308. Concatenate in Pocket Excel
  309. making controls transparent
  310. check a checkbox in a formula
  311. How do I link multiple cells at the same time?
  312. Making an ouput file
  313. how do I convert text in excel to 1st letter capital,only
  314. Ttest
  315. how to I refer to current workbook without using its name?
  316. Using Excel's XML mapping/export with data organized in columns
  317. vlookup
  318. ttest function
  319. how do I calculate an input "c" to add certain cells?
  320. Could the "Criteria" in COUNTIF function be a cell reference?
  321. Modifying sumif formulas.
  322. Excel 2003 worksheet name function?
  323. NETWORKDAYS() not avaialbe after reopening
  324. How many IF's can you have in a nested IF function?
  325. Please Explain Formula
  326. dates
  327. Please Explain in Lamen's Terms
  328. Past date in column to change color
  329. i,
  330. IF Statement Problem
  331. Look up Problem withion Excel
  332. variable to refer to "this worksheet"?
  333. Micosoft Query does not export result set to excel
  334. Macro needed
  335. Fraction in 16ths format reduced to LCD
  336. Finding a Value and inserting a value in another cell
  337. Nested IF and MID functions
  338. I want to show all comments on cells in one cell in the worksheet
  339. create autosum macro along with notation on the side
  340. Sumif help
  341. Counting Functions
  342. vlookup weird error
  343. sumif formula returns incorrect value
  344. Formual help needed
  345. Pivot table Data refresh
  346. Formual help needed
  347. vlookup using a constant value
  348. how do I total hours and mins in excel
  349. functions do not calculate
  350. sumif issues over multiple colums
  351. Returning all values from a lookup - not just the first/last one
  352. sqlrequest in excel 2003
  353. In Excel the total is off by a penny.
  354. Finding char within a cell
  355. Number of Conditional Formats
  356. finding char within a cell
  357. Data Source Name Not Found
  358. I can't get the forecast formula to work?
  359. please ignore
  360. If statement for text
  361. Date Conversion
  362. Variable VB to assign new sheet name
  363. Sorting Worksheet Tabs
  364. How to use complex no. functions that have cell references?
  365. Combining rows
  366. doubling a number X number of times
  367. Variable ranges
  368. IF scenario for a range
  369. Eliminate formatting dulication in multiple worksheets
  370. improve formula offset and indirect
  371. How do I display more than one mode in a cell?
  372. margin trouble in excel,bottom always default to .62
  373. Recover earlier version of sheet?
  374. How do I bin numbers by a date in an Excel sheet
  375. How do i convert years to months (formula)
  376. Doing Sums on existing numbers
  377. how to change path name of html source folder ?
  378. triadic combinations of words
  379. Cell value = tab name?
  380. date/time
  381. Setup Accounts Receivable functions in Excel til we get new syst?
  382. Getting Count field to recognise rows with negative values in Exc.
  383. Help in getting external data needed please
  384. OFFSET using ADDRESS for the reference argument
  385. filter list of text for unique entries using formulea
  386. how do i protect an Autofilter funtion on Excel 2000
  387. extrapolate data from series
  388. Tab in a cell?
  389. Difficulties with COUNTIF.
  390. Sum Product Problem
  391. How do I do multi VLOOKUP's based on certain criteria per cell?
  392. Problem
  393. sorting data by date
  394. Can specific cells on a worksheet be hidden & password protected?
  395. Formula for Continuous Services Dates
  396. Absolute References in cell formula
  397. Restricting Multi-user access
  398. Calculating non-financial rates
  399. RE: help with simple formula
  400. RE: help with simple formula
  401. Starting a macro with the IF function
  402. Merging 2 different pivot tables
  403. help with simple formula
  404. Auto-update with multi-users
  405. Find and delete part of formula for multiple formulas?
  406. Mode Function with 2 Criteria
  407. Help Please - Dates in Excel
  408. Adding excluding zero
  409. Use Cell Content to Build Link
  410. hide a worksheet so that a macro can still find it
  411. If function help
  412. Sorting an Address List
  413. Filter range of only active cells???
  414. SUMIF over multiple columns
  415. How can I add up how often certain text occurs?
  416. Cross workbook referencing based on cell input
  417. Did not see any reply from yesterday. Need data formatting help
  418. font size changes w/ control focus
  419. Problem Assigning Macros
  420. help please - complex countif, etc. functions
  421. The { formula } type of formula
  422. hiding worksheets
  423. More time questions and IF function problem
  424. Worksheetfunction.vlookup and #value error
  425. Re: Need Help Computing Workdays for a project
  426. Re: Need Help Computing Workdays for a project
  427. Re: Need Help Computing Workdays for a project
  428. Removing Duplicates
  429. help please - trouble with sumproduct function
  430. HyperLink Function
  431. Sum if statements with conditions
  432. Drop down lists are displaying end of list, how to make it top?
  433. use sumif with array
  434. hyperlink functions
  435. Cannot get CUMIPMT to work in Excel
  436. formula to find and flag dates older than 30 days
  437. Adding an AND Statement to COUNTIF
  438. Using color in lookup
  439. Excel Formula/Worksheet maybe Macro Question
  440. how can i calc averageif
  441. formulas
  442. if then statement color coding (or another function???)
  443. how do i setup a running invoice number in excel
  444. SUMIF function retrieves "0"
  445. VLOOK
  446. Match Function
  447. How do I assign a text value to a variable number of rows?
  448. download will not open in usable form
  449. Windows cant open excel spreadsheet.xls?
  450. how to use the Prob function in a list of averages to find the le
  451. Conditional Validation - Using a "part-time" drop-down list
  452. General Question
  453. " "
  454. date/time stamp
  455. prevent more than one value in a cell
  456. Search/lookup/cell reference
  457. Need Excel Function that will return # of char in preceding cell
  458. soduko
  459. How to tell if cell contains a FORMULA or user-entered number?
  460. Excel Analysis Add-in EOMONTH generates #NAME? error
  461. how can convert 15 to Fifteen
  462. filtering dates
  463. AutoFill with Non-sequential Cell References ?
  464. Copying into ranges
  465. round up in own cell
  466. how do you use the text function?
  467. Dynamic reference to a sheet
  468. Need help with reverse phone lookup
  469. Fill down error for Vlookup
  470. SUMIF Alternative?
  471. Another rounding issue
  472. how to set up one cell that assigns a value based on the value of another cell
  473. How do I compare in between two worksheets?
  474. CREATE LIST OBJECT IN EXCEL
  475. Getting External data
  476. SUMPRODUCT help
  477. locking cells based on results at runtime
  478. Checking for empty cells in a range
  479. Filter Indicator on Column top should be white, not dark blue
  480. Copying selected rows to another sheet
  481. Hyperlink referencing
  482. Creating a bar graph manually
  483. automatic printing
  484. How do I count two variables in different columns in excel?
  485. Calculate 52 weeks
  486. Brake & Move Columns
  487. Sorting Account Numbers
  488. Exce Hide / Unhide function
  489. Countif for multiple criteria
  490. i want to use the =if function to apply a colour to other cells
  491. PRINT MORE THEN ONE WORKSHEET
  492. Largest Value
  493. Non zero weighted average
  494. Formula syntax {;;;}
  495. concatenating cells with their formats
  496. Checking that any cells are null
  497. &[Tab] is available as data in headers but not cells?
  498. Underlines with autosum
  499. have value in A1 & want value after 20 cells is it =a1+20 ????
  500. Formulas dealing with text data
  501. Compound Rate of Return
  502. IF statement with lists and dropdowns
  503. XIRR function
  504. ytd sum by selecting month
  505. Excell Workbook problem
  506. Combo Box
  507. Adding a fixed date to a cell
  508. Links to 2nd closed worksheet fail when using offset function ??
  509. Nested if
  510. Delete rows if Col C has a 0 value in it.
  511. Is there such a function?
  512. How do you copy RANK w/o it changing the range?
  513. Is there a (non-binary) "if x then enter y" forumula?
  514. Random Name Generation
  515. Averaging and Rounding problem
  516. My formula won't work
  517. Multi Criteria then sum
  518. How to input additional text to multiple of existing cells that has text
  519. OR & IF Functions Together
  520. intellimouse
  521. filename pointer
  522. My formula does not work!
  523. Why is XL lying to me??
  524. More- AutoFill with Non-Seqeuntial Cell References ?
  525. for each problem
  526. Summing with multiple criteria
  527. Currency format
  528. getting name value in cell from If formula
  529. EXCEL: FLOOR/SPACE RATIO CALCULATION
  530. Lookup data from multiple sheets
  531. Need help with RANK function
  532. CHI SQUARE TEST
  533. I NEED HELP with the SPELLNUMBER Function
  534. Problem writing Excel formulas via ODBC
  535. Need Help with an IndexMatch
  536. formula to calculate the average of a range basing on condition
  537. validation rule
  538. Sheet(Array( Won't print as I expect it to
  539. How do you convert (change) a column into a row?
  540. Problem with Frequency() formula
  541. Function or formula needed
  542. convert numbers to text.
  543. Find first data
  544. List Unique Occurences and Count
  545. select records with a specific value
  546. Out of Ideas, need help with Auto Fill
  547. Formula to count number of days in range which are less than today
  548. Rounding
  549. Date calculation
  550. match multiple criteria & return value from array
  551. i change a source and the other cells wont change
  552. convert 500.00 to Five Hundred
  553. add "0" to the beginning of each value
  554. EXCEL
  555. cell pointer content Info
  556. Re: Loosing Zeros
  557. Re: Loosing Zeros
  558. Indirect, Concatenate, & ?
  559. How to change outline when tracking changes in Excel?
  560. Finding possible sums to match a figure
  561. Macro to omit blank cells needed
  562. Re: Problem writing Excel formulas via ODBC
  563. Transfer A Row From Sheet 1 To 2
  564. How to filter on a date field during mail merge
  565. finding an answer
  566. how can i test whether cell contains keyed constant or a formulae
  567. How do I hide rows in excell 2003, and see the + sign to open?
  568. remove a drop-down list
  569. Using the IF function
  570. Can this be done?
  571. how do u copy a formula in over 100 cells and have it adjust
  572. IF Functions
  573. Need to Count number of occurrences and get percentage of total
  574. how to merge 2 worksheets and highlight differences
  575. summing up daily data in a monthly compilation
  576. HOW DUPLICATE TEXT ON ALL PAGES OF WORKSHEET FROM ONE CELL
  577. Pivot Tables
  578. Sharing a workbook
  579. CountIf function
  580. if function that i dont get
  581. HELP - Room booking spreadsheet hell
  582. Lookup Issues / List Auto-Adjust
  583. LookUp and Concatentate
  584. How to sum the last 5 non-blank cells in a row?
  585. Pivot Table
  586. Conditional Lookup on Multiple Criteria
  587. Simple formula help
  588. Simple formula help
  589. Sharing of one single Excel file/workbook
  590. How to write a formula that will prevent appearance ERROR MESSAGE
  591. countif
  592. HOW DO I CORRECT A CONDITION IN WHICH ALL FORMULAS ACT LIKE TEXT?
  593. skip blank rows when pasting formulas
  594. Pulling my hair out, need some help building a formula
  595. number increase by 1
  596. Copy Code Needed
  597. Formula indicator in cells???
  598. How do I get stock quotes in Excel without text?
  599. count no. of entries in range for a day
  600. export excell data as xml
  601. Return a unique value
  602. totaling difficulties
  603. merged cells ???
  604. Insert Animated picture like GIF
  605. VLOOKUP function
  606. Attachments
  607. Excel Function to Match Power Trendline in Chart?
  608. =IF(TRIM(RIGHT(D4,1))="X",MID(D4,1,LEN(D4)-1),D4) ? remove error
  609. If OR Vlookup???
  610. Formating the text of a formula?
  611. function to show if two fields in a column have the same data.
  612. How do i unlock protected worksheets?
  613. large spreadsheet
  614. Array Formula, noncontigous range
  615. How can i count pasted values in Excel?
  616. Still could use help on a tough VLOOKUP
  617. IF from a range of cells
  618. Match and Concatenate ??
  619. Help! Need Product: Feet/InchesXFeet/Inches=DoubleDecimal SQ.FT.
  620. Problem with nested IF_OR statement
  621. problem lookup function
  622. Get aveages for last few days
  623. How can I convert an 8 character Hex word to binary for a lookup?
  624. How can i get autoformat name of range in excelsheet?
  625. How do I setup criteria in DSUM to sum values NOT equal (<>)
  626. Data from closed workbooks (pull func, indirect.ext, etc ....)
  627. Compare List and Show Mismatched
  628. Calculating starting balance
  629. Comparing data on 2 workbooks
  630. Prevent A Macro From Running If SpreadSheet is Filtered
  631. countif question
  632. Year-to-date return
  633. Problem adding a range using Sumif function.
  634. RIGHT of character
  635. Lookup Match
  636. Problems with PULL function, INDIRECT.EXT and so forth
  637. Auto increment over multiple worksheets
  638. format cell to capitlize
  639. VLookup
  640. Limit to the number of items in a cell
  641. Hiding columns using a formula
  642. Cond Format:re color 2 cols, skip 2 cols
  643. SumIf based on two criteria
  644. Auto dates
  645. Need formula to count number of books sold
  646. Copy down
  647. Global Replacement of Test to Display
  648. Extending a balance sheet
  649. IF Function returns False instead of 0
  650. How can I put the median on a pivot table?
  651. I want to use if based on two cells (if... and)
  652. Hyperlink-Programable replacement of Text with Its Actual Address
  653. Pivot Tables
  654. Appending excel worksheets
  655. Find min/max in 2 combined columns
  656. Function to find row with most current date
  657. Lookup help needed
  658. Is there a template for creating outline in Excel as opposed to W
  659. Counting Across Multiple Ranges, Based on Condition
  660. Array Function Question
  661. Compare 2 columns & format row
  662. Adding cells based on condition
  663. Converting a link to values to multiple cells.
  664. Improve visibility of Excel AutoFilter Filter selections
  665. How to link cells in seperate spreadsheets without the $
  666. IF function
  667. how do I customize product sales pipeline management template
  668. format cell to recall client name
  669. conditional formatting
  670. Cell Calculations
  671. Worksheet e-mailing
  672. How to dynamically reference a dynamic named range
  673. how do i MAX to display the person who got MAX
  674. left click on a cell and more cells are highlighted
  675. Another of Excel's idiosyncrasis
  676. Semi transparent chart fill
  677. HOW DO YOU CREATE DROP DOWEN MENUS IN EXCEL?
  678. Sorting dates
  679. Help creating single cell Pop-up
  680. Matching Date From Two Groups
  681. julian dates in Exel
  682. Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number)
  683. How to match sort and lineup 2 sets of data
  684. Ref from table to cell
  685. Ref from table - complete
  686. How do I allow users to make a choice in a worksheet?
  687. How do I calculate APR for interest-only loans
  688. I need to return the name of a worksheet in another worksheet cell?
  689. Help with Excel Macro.
  690. find and replace cell reference to a new worksheet
  691. Display count of rows
  692. Autoexec Macro
  693. How to setup a hyperlink to an indirect function?
  694. Sumif where sum range is more than one column?
  695. Problem with function "Worksheet_Change"
  696. an error.type test
  697. How to represent an empty cell in excel formulae?
  698. Conditional Format to highlight blank cell
  699. Setting a reminder up
  700. Realtime Automatic sorting of data in rows in new work sheet
  701. COUNT IF NOT EQUAL TO ZERO
  702. "E" for even numbers. "O" for odd numbers.
  703. Help with Formulas please!!!
  704. not equal to zero
  705. Trend Forecast Help
  706. The ROUND function
  707. lists and validation
  708. Moving formulas
  709. If (cell a2 is greater than 1, but less than B2 - C2, "X") how do
  710. calculating hours
  711. Excell linked to outlook contacts
  712. How can I make a cell mandatory and only accept a Y or N?
  713. Formula for Colin F
  714. need Excel function like INDIRECT but can't open all spreadsheets
  715. Result in Cell is Wrong
  716. Dynamic Formula?
  717. Control Toolbox
  718. Conditional Formating
  719. Create a pick list to use to go to a text cell in Excel
  720. Excel subtotal group sort
  721. RE: IF Function
  722. Copy data in other sheet
  723. Re: IF Function
  724. RECORDED MACRO PASTE'S DATE DIFFERENTLY TO MANUAL PASTE
  725. if greater then 99 then 1 if greater then 199 then two
  726. Help creating dynamic refrence cells
  727. highlighting required fields
  728. I need an Excell formula that will add x$'s every 30 days
  729. copying subtotals in Pivot tables
  730. How can a formula in a cell automatically update when inserting a.
  731. Sumproduct
  732. dget function
  733. automate creation of sheets in excel
  734. in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell?
  735. is there anyway in an excel macro to reorder the sheet tabs from left to right?
  736. Format text in one cell based on value in another cell
  737. Counting cells with intervals
  738. Extracting from a text string
  739. how do i get the name of a newly added sheet that i add with Sheets.Add in a vba macro in excel?
  740. Need a formula that counts orders
  741. Scenarios
  742. HELP: Cell Value as Filename?
  743. Cannot protect worksheet if it includes a list
  744. Address from one worksheet to another
  745. Display only surname
  746. Summary of Max Hourly entries
  747. saving the format when emailing
  748. How do i check if something non numeric is in a range & return'Y'
  749. Nested IF(AND is not working
  750. how can i get rid of duplicate records in excel?
133