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

  1. HELP: Cell Value as Filename?
  2. Cannot protect worksheet if it includes a list
  3. Address from one worksheet to another
  4. Display only surname
  5. Summary of Max Hourly entries
  6. saving the format when emailing
  7. How do i check if something non numeric is in a range & return'Y'
  8. Nested IF(AND is not working
  9. how can i get rid of duplicate records in excel?
  10. Worksheet data function
  11. is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data?
  12. What is this kind of average called?
  13. how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro.
  14. using time functions when hours are greater than 10000
  15. how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab.
  16. is there anyway to make it so the users of my excel spread sheet cant view the macro code w/o a password?
  17. Cell Combining Question
  18. ROUNDUP IN 0.2 INCREMENTS
  19. Help
  20. combination of vlookup and match question
  21. Find Median of Positive numbers only in Range
  22. Concatenate Multiple Instances in Array
  23. Transpose formula
  24. someone must how to do this. :):)
  25. lookup
  26. "E" or "O" for the first, even or odd digit in a number
  27. Generate Payment Statement
  28. automatic sort
  29. formula
  30. Update to : Pulling my hair out, need some help building formula
  31. Counting the number of cells meeting conditional formating criteria
  32. Abbreviation for "Rear Derailleur" as "RD"
  33. Sum a cell within all worksheets
  34. Can any one suggest code/formula for finding the CAGR
  35. text in formula explaining formula not to print
  36. Meeting two conditions before summing
  37. Ctrl+Y not working
  38. Referencing a cell for a row
  39. Unhide Pivot data tab
  40. Excel 97 freezes up when using hyperlink to another excel rpt file
  41. Concatenating cells to produce a cell ref from another excel file
  42. Hyperlink
  43. Adjustable Scroll Stop in Excel
  44. Excel workbook to be used by multiple users at same time....possible???
  45. need help with a simple xls equation !!
  46. Formula question
  47. Convert a number of minutes like 400 into hours and minutes
  48. sumproduct function returns #value or #ref error
  49. Sum of Categories by Record across Multiple Worksheets
  50. using dget
  51. HOW DO I DELETE A WORKSHEET IN EXCEL? NOT HIDE IT OR RENAME IT
  52. How do I use the wildcard character and the NOT function?
  53. How do I convert a list of date of births into age in Excel?
  54. Re: Convert a number of minutes like 400 into hours and minutes
  55. how do i look through worksheets in a workbook to find duplicate
  56. #VALUE!
  57. pleas help: sumproduct function returns #value or #ref error
  58. Finding Max values
  59. If statement where the logical test is a range that equals a word
  60. HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE
  61. Graphing A Time Series of Multiple Stock Prices
  62. * Character
  63. Difficult look up formula
  64. Having trouble totaling columns in excel 2003, always worked b4
  65. How do I arrange worksheet tabs In alpha order
  66. Can I use multiple criteria in SUMIF funqtion?
  67. Calling another workbook not working
  68. Is there a way to color the cells based on the numeric value?
  69. Layered "If" statement.
  70. Extract multiple records matching criteria from list
  71. contents of 1 combo box depends on choice of another
  72. Sumproduct...how to use *contain*?
  73. AutoFilter Failure
  74. Conditional Range w/Sum
  75. In Excel combine tables from multiple worksheets in to one sheet?
  76. how to analyze freight expense?
  77. counting specific words
  78. How to subtract value in one cell from aanother cell value?
  79. How do I change the colour of the 'filter arrows'
  80. Referencing Columns in a Row. PLEASE HELP!!
  81. How to Concatenate with a text & number
  82. How do I add data from two worksheets and display on the third Wks
  83. Conditional Formatting
  84. CHINITA
  85. Re: Trouble with dates......
  86. Embeded Cell / Object reference
  87. mulitple conditional formatting
  88. Separating Over/Short Amts.
  89. Problems with IF, AND + OR statment
  90. Vlookup Count confusion !
  91. Spreadsheet functions
  92. SERVICE PACK 2
  93. IF Function (I Think!)
  94. Function from sheet to sheet
  95. Looking up values
  96. Open template automatically
  97. Drop list affected by previous choice
  98. how to auto increment a number each time i open the worksheet
  99. set a date in columns 7 days apart
  100. How can I edit in the spreadsheet viewer?
  101. Time to text
  102. How do I use = command on only first few letters or so?
  103. How do I analyze data from a survey in excel
  104. How do I maintain format of worksheets when combining several?
  105. Evaluate string as a formula
  106. copy formula referencing sheet name to another sheet
  107. Symbols in Data Validation List
  108. How to subtract two numbers in excel ?
  109. Formula used to calculate daily employment hours ...
  110. Formula used to calculate daily employment hours ...
  111. Identify the contents of column in a filtered range
  112. Weekly Schedule, help create form
  113. LOOKUP VALUES
  114. Currency Converter
  115. How can I calculate flowrate?
  116. How can I calculate flowrate?
  117. Functions which can be used any number of times in excel-2003
  118. A few questions if anyone has a moment?
  119. vlookup function
  120. help NEEDED URGENTLY (I HAVE TRIED SOME SUGGESTIONS BUT THEY DONT WORK UNLESS I AM DOING THEM WRONG
  121. Need an excel amortization schedule formula with a grace period
  122. column variables
  123. Summing across multiple sheets with a twist
  124. =right and =vlookup
  125. I need information from a cell intesected by a column and row.
  126. Adding values from previous worksheets
  127. How can you use count with an array formula similar to using sum
  128. 3 Time frame
  129. Character Search.
  130. syncronize excel worksheets between laptop and main computer
  131. Importing data into excel
  132. Summing Values In Current Month Only
  133. Only calculate specific worksheet automatically?
  134. automatic printing
  135. Get MAX value according to TRUE/FALSE flag
  136. Multiple Contional Formatting
  137. assemble link from different cells and return value
  138. Problem with counting characters in a cell
  139. lookup with sheet name
  140. how do I use variable column and rows using other cell reference .
  141. Can a worksheet pull from a specific cell value in a separate wrks
  142. Problems with SUMIF function and Wildcards (* and ?)
  143. Conversion of Dec numbers to Bin, Oct and Hex and visa versa
  144. How to get the data randomnly in excel worksheet?
  145. 6 or more conditional formatting
  146. Dependent Lists in Excel
  147. 2005 Excel User Conference
  148. I am trying to use get pivot data with variable criteria
  149. IF Function maybe?
  150. Is this decent?
  151. Range Names
  152. Pull numbers from a cell
  153. Need Formulas for counting multiple conditions
  154. How can I prevent the "division by zero" error in this formula
  155. Page numbering for a whole WorkBook
  156. Can I do this? =VLOOKUP(A4,D1,2,FALSE); Where D1 has "$A$4:$B$18"
  157. Absolute Values
  158. USE CONCATENATE function to connect 2 formulas
  159. place text seperated by a space in a column into seperate columns
  160. dynamic, double vlookup, match, index, dget?? different workbooks
  161. Need "reverse" amortization; calculate loan amount
  162. Count number of times a specific number is displayed in a cell ran
  163. Worksheet to Column Distance
  164. How do I eliminate leading zeros from downloaded data?
  165. More Pilot Logbook Help....
  166. Page Number removal
  167. template for check requests
  168. SumIf help needed plz...
  169. MATCH FUNCTION?...challenge
  170. Date : =today()
  171. Using the Mid function.
  172. Returning a numeric value for text
  173. can I sum information in a list
  174. how to save and print information
  175. can I sum information in a list
  176. How do I insert a date created in a cell in excel?
  177. Help with multiconditional sumif with range
  178. clear data from workbook
  179. How to calculate/properly display significant figures ending in 0
  180. Is there a keystoke to navigate between worksheets?
  181. Why doesn't the finance rate in MIRR impact the formula result?
  182. hlookup #N/A
  183. IF statement help
  184. hilght cells at a give day
  185. Need a function
  186. Equal Sign Issue
  187. Add-In: "HPVAL"
  188. Goal Seek On Members of an Array within Array
  189. Vlookup or If statement Help
  190. Re: Vlookup or If statement Help
  191. 2 ?, Size and copying?
  192. RE: Cell shows only formula, no result
  193. Re: Sumproduct
  194. countif text formula help
  195. Excel 2003: can I insert a "last edited" date function?
  196. Help with formula
  197. how do i rename worksheet to equal cell name
  198. Positions of Comments
  199. Add on 10%
  200. pivot table selection
  201. Decimal Points
  202. Hide empty field error
  203. how do i add cells in checkbook register template with formulas?
  204. RE: Need Help With A Find Formula
  205. template
  206. Excel won't fill formulas
  207. Avoiding typing similar formula 600 times
  208. how to change margins for multiple worksheets in Excel?
  209. custom vertical footer?
  210. excel worksheets
  211. SUMIF Problem
  212. RE: Using other workbooks..
  213. Summing only coloured cells
  214. how do i cumulatively add in a single column?
  215. popup message if certain criteria met in formula result
  216. Weeknum
  217. Using ~ in VLookup function
  218. Linking multiple data into one worksheet.
  219. Use INDIRECT function to reference a value in closed file
  220. Database
  221. Changing Positive to Negative
  222. Re: Need Help With A Find Formula
  223. Autofill
  224. How do I filter based on color in Excel?
  225. How to type correctly formula in calculated field in a pivot?
  226. sorting and filtering
  227. how to count unique entries with multiple condition
  228. Complex if and mid function.
  229. sheet protection
  230. Formula with options
  231. Trying to get the next date exactly 5 years ago..
  232. I have a long equation which I need to repeat 16 times!
  233. workbook sheets into separate files
  234. Change Cell Color if in current Month
  235. Finding the 3rd largest number in a list
  236. How do I import Names of Windows files into an Excel Spread sheet
  237. Re: Complex if and mid function.
  238. sumif - multiple conditions
  239. Exporting from Access
  240. value of indirect cell
  241. How to show 2 MAX values in a list
  242. Excel 2002 "Protect Sheet", but Allow "Insert Comments"?
  243. Excel 2002 "Protect Sheet", but allow "Hide Columns"?
  244. Pivot Table Question
  245. Search for more than one word
  246. Microsoft Query
  247. MIN or DMIN ?
  248. Averaging/Rounding Equation Problem
  249. Mod 10 & 11
  250. Custom percent format needed
  251. Sum Function
  252. I need a formula to calculate shift differentials in excel
  253. advanced filter criteria "begins with" and "does not begin with"
  254. Autofill type feature.
  255. How to change a MS Word file to an Excel file
  256. IF on dates
  257. How to change negative to positive
  258. Delete all rows where Column A contains Text
  259. Divide worsheet and save as separate files
  260. Vlookup with multiple criteria
  261. Automate simple calculation/formula
  262. Migrating Locations
  263. How do I undo all Page breaks in Excel
  264. Difference between two Excel Date/Time Stamps
  265. Links between workbooks and emailing workbook
  266. to many 'IF's'??
  267. Function to return the current Worksheet name?
  268. Pass an array to Rank
  269. If function with Vlookup
  270. Pivot Table - Data Source problem
  271. How to make an exponential series?
  272. log to track mutiple jobs per day for service employee
  273. Pull data - Advance Filter
  274. SUBSTITUTE(Outward!B5,"-","0")+0
  275. Macro and Formula
  276. SUMIF positive values only from database
  277. If Statement and copying all of cell contents.
  278. Hello, Need help with time msg
  279. Defining non worksheet specific names...
  280. Time sheet problem
  281. Arrays parameters in Functions
  282. typing mistaken for date format
  283. Schedule an xl file
  284. Help with a conditional formula
  285. Blocking specific cells
  286. Pivot Table - Multiple Worksheets
  287. SUMIF using two columns in both Range and Criteria
  288. Using = sign will link data between sheets but not colour. Why?
  289. Can I conditionally format tab names in excel?
  290. VBA help please
  291. MROUND function. Getting the following error: #NAME?
  292. my mouse moves diagonally when i scroll on mouse?
  293. Table copied from Excel to powerpoint print all bold?
  294. 2005 Excel User Conference
  295. spreadsheet dropping leading zeroes when exporting from SQL Serve.
  296. placing NOW function in IF function
  297. How to place a border on every page in excel?
  298. Excell - How do I "force" cell to be filled or return error mge.
  299. How do I add one number to all cells in excel?
  300. Round a number to the Nearest .25
  301. 2 formulae to go in one cell
  302. #VALUE! Problem
  303. link formulas in excel
  304. Countif
  305. Sales Chart
  306. Trend Line - break
  307. Filter mode
  308. Count OR Sum Or if
  309. How can I get excel to mail merge zip codes plus 4 correctly?
  310. How to randomely distribute non-numerical values across rows?
  311. How do I eliminate spaces/characters from the beginning of a cell
  312. How can I convert all Caps to first letter caps in Excel?
  313. How to set up AutoFilters?
  314. Difficult conditional formatting
  315. Counting text only
  316. Allowing Data Entry ONLY???
  317. Macro / Compile Error / Duplicate Declaration
  318. how can i get excel to sequentially add numbers to new worksheets?
  319. can I use GO TO results in a formula?
  320. how to show row number in cell
  321. any way to redisplay column headings after page break?
  322. Copy Data to Another Worksheet
  323. Formula
  324. Array Question
  325. Need Function Help
  326. Using a formula to create named range reference
  327. COUNTIF 2 conditions
  328. PDF output with Cell as filename
  329. Help to condense a formula
  330. when I tab in Excel - it move two spaces instead of one
  331. extracting last name
  332. updating a column in existing excel sheet
  333. macro to change text to time
  334. Help with week day count with range
  335. If Statement Problem
  336. Sumif across columns
  337. Averaging different numbers of cells
  338. School teacher
  339. calculating with dates
  340. help??
  341. WHEN EDITING VALUES IN A FORMULA, IT DOESN'T CHANGE TOTALS
  342. How do I combine IF and OR?
  343. calculating the minimum value ignoring o
  344. Question about seriessum()
  345. Sequential numbering
  346. formatting a cell with a function (IF statement)
  347. problem tagging duplicate entries
  348. Formatting a cell with a function (IF statement)
  349. Counting
  350. Re: =Lookup()
  351. Re: =Lookup()
  352. Re: School teacher
  353. Formula please
  354. Re: Automatic Quote Numbering
  355. Re: School teacher
  356. Re: School teacher
  357. copy database to another sheet
  358. return array result in cell based on comparing dates
  359. How do I stop rows from hiding when sorting a worksheet?
  360. how do I switch from one window to another
  361. RE: Using other workbooks..
  362. Calculating working hours
  363. Lookup function problem (kg)
  364. average range function
  365. How do I print excel worksheets double sided
  366. =FORMULA(CELL(A1)) ?
  367. Can I enter a formula in a comment?
  368. Using Match function with duplicate values in an array
  369. HOW MANY 'IF CONDITIONS' CAN BE USED IN ONE SUCH USAGE?
  370. Nesting 2 If functions
  371. Re: Nesting 2 If functions
  372. RE: Nesting 2 If functions
  373. sorting in order
  374. sorting in order
  375. how do i step thru a text field looking for 6 numeric characters
  376. cell ref
  377. In Excel: Paste Special should have a "Link Value" Selection
  378. HOW TO EDIT THE UPDATE CHANGES ON ADVANCED TAB IN SHARE WORKBOOK
  379. Adding a Drop Down List to a Column?
  380. I keep getting the message "too many different cell formats"
  381. Excel should have a function to output T Stat
  382. How to copy and paste same formula in multiple cells?
  383. problem with Array Formula
  384. In Excel, change phone from 555-555-5555 to 5555555555?
  385. IF function to change color of cell?
  386. How to display hidden rows maybe defined by scenario
  387. convert time value of 14.58 to 2:35 pm
  388. Subtotal and Names
  389. FILE SHARING
  390. Subtotal and Names - Excel 2003
  391. lookup a value on a table
  392. Open A Locked Workbook
  393. Invisible Text designation in cell?
  394. Vlookup
  395. Lookup function skipping columns
  396. Major linking problems
  397. Copying a Formula into Every other Cell In a Column
  398. Telling the difference between zero and blank in IF statement
  399. Keep autofilter after macro is run
  400. List not omitting blank cells....??
  401. Sumproduct HELP
  402. Data validation
  403. countif question using 2 conditions
  404. pdf conversion
  405. multiple criteria then sum
  406. Need to remove hypens from typed in telephones (not formatted)!!
  407. is there an equal fxn for 'InStr' in excel. Not Find or Search
  408. Quick question: What does "--" in an equation do?
  409. What does this formula mean?
  410. Is there a function, if cell1=Text then cell2=#? Excel 03
  411. Re: Cell shows only formula, no result
  412. specify range name in formula with concatenated string
  413. Combobox Number Formats
  414. Conditional countif
  415. Complex query question
  416. How do I import formmail data to a custom excel template?
  417. Nested If statement
  418. SUMIF
  419. If statements
  420. check if value occurs within a range
  421. Finding the CI in t-test analysis
  422. Text in Formula bar displays vertical in Excel, How?
  423. Reversing POWER Formula
  424. Linking Pictures in Cells
  425. How do you work with drop down list to show a name, diff payment?
  426. printing cells
  427. multiple sheets vs. 1 sheet
  428. sum of a series of exponents
  429. yield function
  430. Conditional Formatting lowest # if it only appears once
  431. Ignore Blanks in Data Validation
  432. Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions
  433. Current year function
  434. scheduled hours total
  435. multiple substitutes
  436. msg box with finished time, please read
  437. trouble with date
  438. Duplicated data
  439. condensing information onto one worksheet
  440. Simple count function
  441. cell validation
  442. Calculate APR from ARY
  443. Performing a function on a column of variable length
  444. conditional formatting
  445. Finding Bottom of Sheet
  446. Changing the columns to copy
  447. create macro for learning purposes
  448. Using Vlookup with validation
  449. Help - Date Format
  450. Vlookup
  451. *URGENT*
  452. Pivot Table - Multiple consolidation Range
  453. How do I put a watermark under cells in excel and make it print?
  454. Lookup Text in Comments
  455. Number Lookup in Matrix
  456. IF, THEN formulas
  457. Equation and roundup in the formula bar
  458. How do I calculate # of weeks between 2 dates in excel?
  459. Problems with time
  460. Return Consecutive Values - Pairs
  461. counting functions
  462. Conditional Countif
  463. How do I delete data in worksheet, but not the associated formula
  464. SUMPRODUCT((A2:A210<>"")/COUNTIF(A2:A210,(A2:A210&"")))
  465. Fixing a single cell reference keeping others dynamic
  466. IF problem using Solver
  467. Help on this formula
  468. Beyond VLOOKUP
  469. How do I extract just the month
  470. Syntax problem
  471. Entering and Adding Time
  472. vlookup help needed
  473. IF with additonal Functions
  474. Eliminate Excel copies that have no file type
  475. Reset Button in Excel?
  476. TIME function used in Excel
  477. Up Arrows / Down Arrows
  478. Combine FREQUENCY and SUM of Associated Values
  479. Re: Excel Formula Help
  480. Averaging selected values
  481. Date format
  482. How do I use the TABLE worksheet function?
  483. how do i change the format for excel to day-month
  484. revealing the contents of a formula
  485. Excel Pivot tables refresh
  486. linking whole rows of cells
  487. linking ranges of cells
  488. How do I extract 3 middle results and average them in excel
  489. % error calculating grades
  490. Thanks
  491. Time: 11.45 = 11:45
  492. Mark up and Margin
  493. Dates
  494. #NA as zero value
  495. match and count words
  496. 3 stupid, simple IFs
  497. Serial number allocation - Array formula
  498. Any ideas for a more customized data entry?
  499. Using Vlookup in formula arrays
  500. Automatic column width adjustment
  501. How can I compute a kids age based on his birthdate
  502. excel dup copy of workbook
  503. Looking for how to do a double FIND formula
  504. Vlookup returning No data.
  505. Beyond VLOOKUP Clarification
  506. Please Help with format
  507. #NA
  508. Finding Links
  509. how to input a calculation in excel to find the geometric mean
  510. how many square feet to an acre
  511. Excel - return a picture or range rows as the result of a formula
  512. Reverse order in column
  513. "how to combine multiple lines into a pull down option?"
  514. Calculate running target by days in the month
  515. CountIF
  516. How to change default page size in Excel
  517. Too many arguments-VLOOKUP instead?
  518. Validation problem...
  519. how can excel recognize strikethrough?
  520. Setup Unique Records
  521. Creating combo box with different number of variables
  522. GetProperty function
  523. Counting number of grades in a row
  524. trendind data from compact flash card to excel
  525. convert numbers to words
  526. How to display as normal when workbook has been protected
  527. averages formula
  528. Search data formulas - HELP!!
  529. If Statement Question
  530. IF function - need to evaluate cell content in 2 separate files-#N
  531. excel should have a floating "custom view" toolbar
  532. VB Required??
  533. Cell Reference
  534. Tabulation order in excel
  535. Calculating Pay based on time of day hrs worked
  536. Some cells can't be formatted after converting from Quattro Pro.
  537. sumif with 2 conditions ?? can this be done??
  538. calculate problem in excel
  539. What is the formula for cube root on Excel?
  540. Creating your own reference
  541. calculate anniversary of date after specified date
  542. Something similar to sum() but ignoring error value arguments!
  543. Date, Day of week
  544. Pivot Table vs. Formulas
  545. Using Concatenate inside a vlookup
  546. Can VLookup function find and list multiple records?
  547. averages formula
  548. What can I add to a vlookup formula to give me a 0 not #n/a
  549. Again-revealing the contents of formula
  550. How do I sort a group of calculated cells in Excel?
  551. Look up Function Need
  552. Should be really easy lookup !
  553. How to link worksheets so editing one will edit others automatica
  554. Autofilter problem
  555. Help with setting up a statistical report?
  556. excel shouldnt need a symbol before the first number in an equati
  557. FORMAT NUMBERS IN CRORE FORMAT (##,##,##,###)
  558. prevent overtyping cells
  559. IF equals this OR this
  560. how do i unlock an excel document
  561. Problem with formula
  562. Lookup based on 2 criteria
  563. Sort rows across multiple worksheets - Excel 2003
  564. Condensing a list/range with blank cells to a new list/range without blanks
  565. countif across worksheets
  566. binder
  567. Sum Product Question
  568. Figuring military time for total hours
  569. referencing the value of a cell containing an array formula
  570. IF statements if the value is True it changes the cell colour?
  571. vlookup avoiding #N/A
  572. sorted
  573. Re: sorted
  574. excel [HHHHH]:mm add subtract hours mins inc lnegative
  575. a function on decimals
  576. problems with background images
  577. RE: Subtotals multiple columns
  578. Time Format Question
  579. Excel 2003 formula to calculate date
  580. How can I link cell colours from worksheet to worksheet/workbook?
  581. Reserved by - Protected
  582. Eliminating digits
  583. How do I get a macro to record selections in a dialog box?
  584. blank cells in calculations
  585. Adding an Audible Alert To A Worksheet
  586. Battleship Code
  587. Sum values between dates
  588. Copy a cell
  589. Counting using 9-key pad
  590. Automatically compare and ecit two workbooks
  591. Formula problem
  592. "Suggest a match" from a list or drop down.
  593. Need some help returning a value
  594. Sum product if value present
  595. can it be done without vb
  596. Conditional Calculation
  597. Contents of adjacent cell from a function
  598. how do I ensure that the sum of two cells does not exceed a set fi
  599. looking for a formula for a worksheet
  600. Creating a drop down list to change decimal value in another cell
  601. Forms
  602. slow replace function
  603. #N/A problem
  604. Change sheet name in formula
  605. Can't get back to Sheet 1. Seems to be lost. Tried unhide, does n
  606. sum totaling doesnt work
  607. is there anyway to create a clone of an excel sheet in vba?
  608. Use a multiplier to change List Prices to Net prices
  609. Can't pick up the Cubes from the localhost with Analysis Services
  610. Calculate weeks cover
  611. select a range using "cells()"
  612. #VALUE!
  613. sorting data in order
  614. How do I attach data to auto complete
  615. Round a number in nested function
  616. keep first row fixed
  617. Why doesn't my audit arrows show up?
  618. Subtract text in one cell from another?
  619. what is short key to move from one sheet to another
  620. Squares for carriage return
  621. Analysis Toolpak Translator - anyone got it?
  622. Analysis Toolpak Translator - Anyone got it???
  623. Autofilter after hyperlink to a page
  624. matrix multiplication
  625. Best method of cloning the contents of a worksheet.
  626. vba excel macro question...ranges
  627. Where is data analysis tool?
  628. How to print 2 worksheets (different col/rows) on the same page
  629. INDEX problem
  630. Condensing lists
  631. multiple worksheets input to one
  632. How do I increase a table values by 1.2 for example?
  633. formulas based on a date
  634. Assistance please?
  635. Pivot table help
  636. How do I use a cell's text, "A1", and put it in a formula?
  637. count unique with conditions
  638. Sound / Audible Alert in a Woksheet ?
  639. Data Validation (Specific Decimals or Whole #)
  640. HELP!I need a specification template purchasing Interior Design it
  641. toolbox controls in excel are invisble ?
  642. simple if then function
  643. Excel macro that opens new MS Word file and pastes data as a pictu
  644. Excel worksheet linking
  645. Protecting formulas in a workbook
  646. LOOKUP
  647. Problem With Reference Update
  648. Multi functions
  649. RIGHT_worksheet_function question
  650. Forcing a sum formula...
  651. CLEAR FIND BUFFER UPON CLOSING
  652. Adding multiple worksheets
  653. Deleting a rows from multiple worksheets
  654. Need help with my formula please
  655. Display Weekday Only
  656. Excel - linking cells
  657. Maximum of a formula
  658. Making a file and worksheet reference into a variable....
  659. problem with msn money stock quote add in
  660. Excel
  661. Data Validation
  662. Smart Report
  663. need help comparing data in 2 separate worksheets
  664. How do I return the highest value in a range of cells
  665. How do I insert 2 decimal places to a number in cell?
  666. Compare data on 2 separate worksheets.
  667. Calculating a date in Excel...
  668. How do I lock a formula in a cell in an Excel worksheet?
  669. Hiding rows from a formula
  670. sumproduct bombs out
  671. in VBA Sheets("mysheet").Copy Before:=Sheets(1) how do i get a reference to the newly created copy of this sheet?
  672. test forumla rather than result
  673. count function problem
  674. Easy formula question
  675. 'Alias' for file name.....
  676. formulas and cells
  677. Scenario Analysis with inputs/outputs across spreadsheets
  678. in a excel file, how to make a menu item for the .xls file that when clicked on it runs myform.show? example plz
  679. aligning two columns
  680. Can cells containing linked formulas be identified?
  681. how do i comment 1000 lines of code at once in vba for excel?
  682. Index needs a little help
  683. How do I filter a number list by numbers to the right of the decim
  684. updated running total from previous pages
  685. How to use a conditional function to insert an autoshape?
  686. help with the countif function!!
  687. Quick formula question
  688. Can I automatically hide or filter a row?
  689. How do I refresh the formulas in Excel?
  690. Insert more than 1 Row Syntax
  691. Simple function problem
  692. Confused about arrays and ranges in functions
  693. Data Validation
  694. Help with countif on multiple worksheets
  695. Return cell reference of lookup value
  696. formula to change 1 to a / and still add
  697. Drop down lists
  698. i need to be able to add #'s in a spasific column togather
  699. Categorize drop down list
  700. n/a in vlookup/index/match formula
  701. How do I translate from 5Row/20Col to 20Row/5Col ?
  702. pivot table
  703. pivot table
  704. how do you find the SD(standard deviation ) for the multiple reg
  705. Copying cell values once and then making them static
  706. Formula given three answer choices
  707. Does a highlight row comand exist for Excel conditional formulas?
  708. Very simple, but difficult formula question
  709. Limit or Exclude cells in Average and Sum formula
  710. Sum IF function
  711. Data Validation
  712. Macro to Modify Pivot Table for Color and Bold
  713. How to create summary of expense report?
  714. control-tab should move between Excel sheets without a mouse.
  715. Dynamic Arrays
  716. EXTRACT TEXT FROM TEXT STRING
  717. filter and delete
  718. Can I have different column widths in a worksheet?
  719. Multiple IF criteria
  720. Rate formula
  721. Nested Funtions
  722. Cell and Sheet Reference/Return
  723. Add cells from a range based on 2 conditions from 2 other ranges
  724. Can Excel recognize when data is entered and apply formulas?
  725. hOW DO I
  726. Advance Filter Criteria
  727. Consolidating sheets
  728. sumproduct between two dates
  729. How do I copy formulas from one wkb to another w/out linkng them?
  730. Create a list in one worksheet of the other worksheets' names
  731. How do I copy formulas from one wkb to another w/out linkng them?
  732. another language in MS office at home and another at work
  733. can I format dates older than 1900
  734. In excel, what does the esclemation point (!) in a function mean?
  735. evaluate data by week number
  736. IF function
  737. CTRL and END function
  738. How do I put each member of string concatenation in its own line?
  739. Can this be done?
  740. Shelf Life Percentage
  741. How do I make all data in the formula bar appear in the cell
  742. Different quantities of a certain item...
  743. Doing a grouped search in Excel.
  744. Links to other worksheets
  745. Random Number Generator
  746. I need a Formula, Please
  747. MSNStockQuote Function Parameters
  748. cell hililte
  749. in vba for access how do i get the day of the week for a date field?
  750. How do I make hide detail buttons in Excel 2002?
131