PDA

View Full Version : 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

  1. Re: Use of &[Tab] in the body of a worksheet
  2. How can I transpose data from a spreadsheet into a form that does.
  3. Superposition error in Dinamics Tables
  4. sumif/countif on non-consecutive colums - array?
  5. Calculating rolling sums
  6. Average if
  7. calculate average hours and minutes
  8. EXCEL AUTOFILTER
  9. How do I set up a field in an Excel form to number it incremental.
  10. Subtracting Times
  11. SUMPRODUCT
  12. How do I calculate an age from a birthdate in excel?
  13. How do I round up or down using formulas?
  14. I cant hide a workbook
  15. Importing data from sql?
  16. Weekly Workplan Template
  17. Complex Conditional formulas
  18. Data Validation
  19. compounding of a number in excel?
  20. multiply by actual number in cell
  21. Getting 0 to equal 1
  22. how do i find the root of an equation using bisection or zooming.
  23. filter
  24. Re: How do I override fixed decimal place settings in EXcel 2003?
  25. Using =address to provide address location for =average
  26. Sum function not working correctly in Excel (Skips Cell)
  27. Shift cursor to the cell on the right
  28. Count function question
  29. SUM Function Question
  30. sorting question
  31. Password protect cells PivotTable & allow the Pivot Table to refre
  32. Using a button in a cell
  33. Wildcard Character
  34. Calculating days
  35. pivot table question, sum fields?
  36. time and date formula
  37. Equation for PMT formula
  38. Help needed
  39. Hiding #N/A
  40. Using MS fingerprint reader with Excel
  41. Grouping
  42. Newsgroup Web interface
  43. Excel error using Dinamic Table
  44. 1 file = 2 versions
  45. How to display zero values?
  46. New ? Re: Data Validation
  47. sumif help ---urgent
  48. Match values from two columns
  49. replace data
  50. Can no open workbook
  51. How do I switch arrow key commands for moving to other cells?
  52. How Do I stop Auto Unhiding Rows?
  53. Lookup Table
  54. PLEASE HELP!? Creating a simple database with excel, minor setback
  55. How can I write an if-then formula for 0 or less than 0 in cell t.
  56. Macro, select Sheet "Number", NOT Sheet Name
  57. Another puzzler
  58. Remove Hyperlink
  59. Can you add a watermark to an excel document?
  60. Help with this formi
  61. Help with this formula
  62. How do I nest an OR function within an AND function?
  63. How do I add a scroll bar to my spreadsheet?
  64. & reference answering as Date Serial # not actual text
  65. Matching Formula
  66. Access - Filling Blanks
  67. Concatenate RangeName for INDEX?
  68. Reviewing Toolbar - how to stop it from displaying
  69. Excel hyperjump to Access
  70. Suddenly Excel can't calculate formula!!!
  71. Hiding a formula error
  72. Formulas appear in cell instead of formula result
  73. Add IF or Subtract IF??
  74. how do i calculate time cards
  75. Create AutoSubtotal button which functions like the AutoSum butto.
  76. How do I find blank cells using AutoFilter's Custom feature?
  77. How do I insert a scroll bar into the excell sheet?
  78. How do I unlink cells in different worksheets when there are no a.
  79. Mailed document does not look the same
  80. Trigonometric functions
  81. Maskerr function not working on my new computer - help?
  82. Lookup values in a list and return multiple rows of data
  83. Advice needed - counting tabs
  84. how do you divide one row of data by another row and have the tot.
  85. Subtract Decimal time
  86. Comparing Arrays
  87. Totalling rows
  88. locking the scroll?
  89. VBA Code for Matching and totalling columns
  90. simple formula help
  91. Filter long Text strings
  92. formulas are reading weird
  93. How I can add categories in a pivot table?
  94. How do i auto rename a worksheet to be the same filename as save f
  95. filter on color-filled fields
  96. Summarise data on multiple sheets
  97. Rookie q
  98. Index/Match Help
  99. Does anyone have a spreadsheet tracking season long baseball stat.
  100. Countif Between
  101. Cut and Paste into spreadsheet with locked formulas
  102. 2 Questions
  103. Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW .
  104. Create an Auto Number
  105. Merging data from several workbooks
  106. Macros and Linking
  107. Sizing individual Cells
  108. Trouble with Averaging across several worksheets
  109. Conditional Format #NUM!
  110. Linked values turn to #REF! after clicking don't update
  111. Passing Cell Address to Offset
  112. Count & Sums
  113. Data Table - does it work with DDE links and Stock Tickers?
  114. Replace Please
  115. using logical functions as criteria with the SUMIF function
  116. How do I set up a header that will change for each pages based on.
  117. URGENT Please... new worksheet with copied formats but no data.
  118. Extract % from text string
  119. Count IF
  120. copy macro assigned buttons in an array
  121. Excel SUM problems
  122. Is this possible?....
  123. Is this simple I'm trying to compare values from 4 excel tables
  124. copy contains from cell to cell w/ formula
  125. Unique Records
  126. VB to erase 2 Columns from every sheet
  127. How do I make a column that calculates gross margin percentage
  128. Payment terms function
  129. Editing MS Query
  130. Highlight cells
  131. RAW MATERIALS SCHEDULE
  132. array formula help
  133. a comment plugin & copy paste directly from excel to comment ? fr.
  134. How do I ask for multiple criteria when creating a "sumif" formul.
  135. Formula to convert to month
  136. Combined date time cell to separate date & time components
  137. How do I make this formula work =if(a1=(b10:b20),"good","bad").
  138. Re: Microsoft Query Help
  139. Removing a space within a cell
  140. Words in Excel Cells
  141. Next largest value that is greater than lookup_value.
  142. DSO
  143. Logic statement returns wrong answer.
  144. is there a Not Equal symbol ?
  145. Merging Cells
  146. hide columns
  147. Macros
  148. how to sum using dates as a criteria
  149. can I use a range of dates as a criteria when using sumif?
  150. HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE.
  151. how to extract only values from an Excel worksheet?
  152. Digital Signature Gets Removed By Itself
  153. Speed of marking cells
  154. TEST - PLEASE IGNORE
  155. TEST - PLEASE IGNORE
  156. HELP ME !! PLEASE!! How do I highlight a cell when it reaches a va
  157. nesting 18 x functions
  158. automatic carriage return
  159. convert numbers to texts
  160. printing the list of wroksheets in a workbook
  161. Array If statement doesn't work
  162. Can't find macro
  163. autofill according to cell index
  164. How do I change existing shreadsheet info from vertical to horizon
  165. Pivot Tables
  166. Macro that sorts
  167. Dealing with FALSE and O responses to IF formulas
  168. time sheet
  169. Formulae to select periodic rows
  170. troubleshoot vlookup returning #N/A
  171. open Word from excel Macro
  172. How do I set up a rolling spread sheet for a six month roll out?
  173. How do I use multiple worksheets (List) in a Pivot Table Report?
  174. MS Excel should allow you to format numerical values to thousand.
  175. maximum number of worksheets
  176. formula will not enter?
  177. Why does freeze panes work on one sheet but not on another in sam.
  178. How do I make Excel automatically adjust a row's height once I in.
  179. worksheet
  180. External References not working right.
  181. Can Sales Listing from Worksheet #1 go to individual worksheets?
  182. Help add on this formula!!
  183. Help with lookup reference to other workbooks
  184. Gridlines
  185. How do I concatenate information in Excel and keep the number form
  186. ISNULL function - can't find it
  187. Alert message and special situation
  188. How do I subtract one time from another to get OT worked?
  189. comment indicators should feature lock or pw protect limiting acc.
  190. Conditional Formatting
  191. select from a fragmented list
  192. Unresolved Errors in IF Statements - Errors do not show in results
  193. AUTOMATICALLY REFERENCE SALES INFO FROM WORKSHEET #1 INTO INDIVID.
  194. sequential numbers on invoices
  195. Statement
  196. which formula or function searches for a value in a range of cell.
  197. which formula or function searches for a value in a range of cell.
  198. Not letting me import XML data
  199. Worksheet links
  200. HELP? ...a second condition in one formula
  201. How do I set up a min max program in excel?
  202. IF IF IF
  203. calculate percentage of two cells
  204. link spreadsheet with form
  205. Cannot sum values based on condition
  206. How do calculate grades in Excel?
  207. how to make the links info dialog box not appear
  208. Sorting a Xcel column
  209. How to count B if C=Bob
  210. Average using alphanumerics
  211. Excel should be able to compute the MOD of large numbers.
  212. About =bahttext()
  213. Stumped by IF
  214. Re: Roll back to previous date
  215. If statement help needed
  216. If Statement help needed please
  217. How to find highest, lowest and last cell in a row?
  218. VLookup Return Value
  219. Excel's Pivot Table & Subtotal function should have a median fie.
  220. Compare Times
  221. Combinin Columns
  222. Worksheet protection with grouped rows?
  223. custom format
  224. naming worksheets
  225. Sum values by month
  226. Delete apostrophe
  227. Formula
  228. Adding different validations based on condition
  229. Custom number format
  230. Workbook Summary Data from Sheets
  231. function years:months
  232. How do I copy subtotals to another sheet?
  233. Passworded Macro!!
  234. Date Formatted Cells
  235. excel formula that can subtract days
  236. How to sum cross two categories?
  237. Parsing Data with Formulas (vs Text-to-Columns)
  238. absolute reference
  239. Decipher Formula
  240. Function Help
  241. Average function with If
  242. autodate and datetime stamp
  243. Sumproduct function not working
  244. Parsing Data w/ a Formula (another question)
  245. Matching 2 "dates" that are formated differently
  246. How do I "turn off" cells so they are not included in autosum
  247. multiple criteria in one column
  248. Formula
  249. hyperlink question
  250. D Sum or SumIF
  251. Macros in this project are disabled????
  252. Sum using multiple criteria
  253. Standard Error
  254. How do you match up one name in excel to another name?
  255. Vlookup and Indexing in excel
  256. Custom Number Format for HEX address
  257. Stop % in red
  258. Set up barcode column in Excel
  259. multiple entries
  260. Sorting
  261. Make copy from any document into Excel a right click with a drop .
  262. Links
  263. How to get lowest value excluding blanks
  264. Circular reference/SumProduct
  265. if a13=0 then 0 if not then (a13*10%+10+a13)
  266. how do i convert the number 1 as 01 or 001 in excell cell
  267. sumproduct between dates
  268. Data Validation list selection question
  269. TO UNDO SAVE IN EXCEL
  270. Add Wilcoxon Signed Rank Test to Statistics package.
  271. Multiple questions in a formula
  272. Protecting My Macros
  273. 3-D references in charts
  274. Can I use autofilter to hide random postcodes?
  275. i want to insert a link to another sheet tab
  276. How do I name columns in Excel?
  277. Format of Numbers Q
  278. Sum based on month
  279. How can I merge 2 cells with numbers and letters?
  280. Variance calculation
  281. Add totals in different files/workbooks?
  282. How do I paste a mulitpage excel spreadsheet in Word so that is p.
  283. EXCEL 2003 "CAMERA" FUNCTION
  284. Anyone know what this means? Its strange
  285. Automatic Lookup/Fill-in
  286. Read options in more than one cell
  287. IF function with #N/A error
  288. formula correction
  289. excel should let me edit and use XML
  290. Automatic Page Sort
  291. Time Sort
  292. Excel 2003 : Group By
  293. Preventing Duplicate Entries in rows
  294. how can I hide a column that can't be unhidden in a email
  295. Getting specific data from a word document into an excel sheet
  296. PageSetup.LeftFooter only on last Page
  297. Reversing the Order of a String
  298. How do I unstack data in a worksheet?
  299. VB Find and Replace
  300. sending data from one cell to another (not using copy & paste)
  301. Need to convert text string to seperate cells
  302. Function HELP!
  303. How do I create a "List If" function.I need to search a database .
  304. change tab key behavior
  305. sorting error
  306. Excel transposing worksheets to rows
  307. Sumif range returns #NUM!
  308. multi-level subtotals are in the wrong position
  309. count in cell
  310. worksheet functions with dates
  311. View the code in a add-in
  312. VB Find and Replace
  313. Variable values in Index function
  314. Counting a range of fields with an "X"
  315. Unable to format colors on part of a large spreadsheet
  316. exporting to CSV
  317. printing
  318. Form/Highlight row
  319. i discover that i cannot scroll in each part if i simply freeze p.
  320. how do you do a sumif function on more than one worksheet?
  321. Databases for tracking work and task completion
  322. In Excel can I move the tabs to the left side of the workbook?
  323. moving data within a column
  324. Inches to Millimeters function
  325. Excel Count Formula
  326. How do I drop the lowest 2 numbers and then average?
  327. Conditional functions
  328. #Value! Returned ?
  329. Drop Down Selection fires a module?
  330. Count If Formula for multiple conditions?? How To??
  331. Checkbox to hide and unhide rows Please.
  332. Deleting custom Commands from File Menu are nor saved next time w.
  333. Paste Special in a macro
  334. How can I look up two seperate values/cells and return the value .
  335. If Statements
  336. Paste Special
  337. How do I create a geographic map in Excel 2003?
  338. Index table lookup anomaly
  339. Using Dates in Count functions
  340. Logical Text Formula
  341. Trying to sum the amount of principal paid for X number of paymen.
  342. Event hundler to control the Excel function arguments
  343. setting two conditions for countif
  344. Naming column in Index Function
  345. How do I get rid of spare lines in an excel spread sheet?
  346. Offset, indirect, match function limitation on linked worksheets.
  347. Frank, Sumproduct, it works but I am confused
  348. Excel - Formula Query: Search for and Return Value
  349. Time formatting
  350. Is date within a range?
  351. Graphics file/ How do I move it to the back of a worksheet?
  352. How can I tab between multiple XL worksheets without using the mo.
  353. Adding muliple cells.
  354. VLOOKUP trouble .. HELP!
  355. Re:Previous Post - Correct Syntax Query
  356. summarise diffrent sheet with different date on corresponding rows
  357. Vlookup between two workbooks
  358. Any way to have more than three conditional formats?
  359. Funcation to average the Time spent
  360. pickup cell value according another cell value
  361. combine 2 curves
  362. No Drop Down Tab showing
  363. VBA 'deleting row if a cell in column A is a zero.
  364. Formatting of the Returned Value of a Formula Q
  365. Highlight Row
  366. Find Protected Cells Q
  367. Offset & Match Formula Shows Duplicates
  368. Help with a formula
  369. Selecting an Item from a List and getting a different item to pop.
  370. Count or sum colored cells
  371. Text to Speech
  372. Bold date
  373. Lookup text values
  374. Can a cell be locked to prevent being typed over?
  375. Lookup/Index formula question.
  376. a way sum only columns not hidden?
  377. An OFFSET question
  378. Can 2 different hyperlinks be in the same Excel cell?
  379. Easy way to sum multiple worksheets
  380. Array with multiple results
  381. Excel 2003 - excel 97
  382. finding highest dollar amount
  383. Creating a stationary column
  384. Formatting a cell as "text" in the number catagory.
  385. problem with formatting cell to date format
  386. How do I find an asterisk * in an excel worksheet utilizing the f.
  387. bolding cells in conditional formatting
  388. Baffling problem with links
  389. Locking certain cells
  390. New Questions about Recording Macros
  391. how can i edit excel 4 macros in Excel 2003
  392. How to keep random number from changing using RANDBETWEEN?
  393. HELP - Have two lists and #1 needs #2's contents subtracted from it
  394. Scoring multiple cells
  395. Paste is is copying in formula, but display is wrong.
  396. Offset with Cell("address")
  397. Cell Count
  398. Will Excel import a spooled file to look the same every month?
  399. show only > 9 in a pivot table
  400. Replacing a number with a description in Excel
  401. Lock cell shading and size only
  402. Validation list behaving strangely in 2003
  403. excel 2003 page numbering
  404. How do I get a specific list of rows out of a much larger excel s.
  405. ok more on sumproduct
  406. How to import a path/filename when importing data into an XML list
  407. cell value as a row number in a function?
  408. Negativ value of time data
  409. Thank you for your assistance - johnb
  410. Counting multiple numbers in one cell
  411. calculating timesheet, time-in/time-out = total hours & minutes, .
  412. transpose data
  413. two way match
  414. calculating averages
  415. excel links update not working in auto, calculations in auto
  416. Adding muliple cells.
  417. Countif with AND logic
  418. Special characters
  419. Is there a function for "not isblank" (find a cell that has a val.
  420. how to enter a formula using column() function for a range
  421. New to excel - Multiply
  422. Need simple multiply formula
  423. Amortization Schedule
  424. Why text to columns is not available when there is mulipule line .
  425. How do I create formula to count numbers in a range of cells?
  426. Mutiple Workbook Summary
  427. Adding multiple cells, return specific values
  428. match or lookup?
  429. copy worksheet from closed workbook to active workbook using vba
  430. Periodic Calculating
  431. Maximum no of rows in Excel
  432. use marco to consolidate
  433. Function that gives Windows current user name?
  434. keep pivot table layout
  435. Date in Page...
  436. Sumif not Sumproduct
  437. #Name
  438. Calculating Depreciation
  439. List of Worksheets in a work book
  440. print a list of worksheets and links
  441. Tricky Question
  442. Advanced COUNTIF Function
  443. Ignoring charachter data with Product function
  444. copy only non hidden cells
  445. Find / Replace sheets vs workbook in VB
  446. Adding sales depending on 2 Criteria
  447. How do I print a new number on each page
  448. Turning off auto unhide when calculating formulas
  449. Named ranges reset.
  450. calculating the future value of a present value
  451. Duplicate
  452. Using imported Query & Calculating Dates
  453. Optimize SumProduct
  454. Column Header Problem
  455. a number as a percentage out of a total
  456. Calculate Remaining Balance
  457. How do I use a template after I've created it?
  458. Fx button in Excel 2003
  459. Enter CORRECT password, file doesn't come up? Help
  460. countif, dinamic criteria
  461. After deleting a macro, I still get the pop-up when opening file
  462. Averaging COUNTIF
  463. can formula to read sheetname from a cell?
  464. equation problem
  465. HOw do I add fields between worksheets?
  466. Adding a number to a date as workdays
  467. typing in color
  468. Help with the "IF" function
  469. drop down text is very small
  470. how to add two data validation lists to a single cell?
  471. 2003 update link when Source open
  472. COUNTIF
  473. Vlookup and Date
  474. COUNTIF
  475. Finding duplicate data
  476. How do I write my formula to automatically regenerate a RAND () i.
  477. Turning a Macro into an add-in for Excel?
  478. Which @function finds the mean of a number?
  479. Show only latest Date of Service?
  480. APR - Annual Percentage Rate
  481. Link sources not found
  482. Count unique alpha numeric "characters" in a common cell
  483. Last cell In calcualtion problem
  484. Moving numbers from one sheet to another by date
  485. Help
  486. I need to create gift certificates in excel how do I number each .
  487. To find different values in Col B corresp. to repeated vaues in c
  488. RE: Zip Code Macro
  489. add restriction in Excel
  490. Collecting phonenumbers from Yellow pages
  491. hyperlink to specific sheet in excel
  492. macro ...if command, I suppose...
  493. Draging a conditional format
  494. Excel function for FV of daily investment at compound rates
  495. lookup using only the functions
  496. Date format in spreadsheet
  497. Protect Cell if value <> 0 OR blank?
  498. conditional formatting
  499. printing sheet names
  500. Conditional formatting
  501. Vlookup with "many to many" relationship?
  502. Need to improve a formula
  503. Function Help
  504. Why does a formula change when I sort a column
  505. Detecting a color
  506. Formula for comparing text in two workbooks
  507. Ranges - Deleting
  508. conditional functions
  509. conditional functions
  510. Weekly data allocated to months
  511. copy addresses from word to excel
  512. Will not calculate average/median formulas;acts like no data in c.
  513. Stripping mixed number and text
  514. How do I sort in Excel?
  515. Significant figures (not decimal places)
  516. = sign has no significance.
  517. Setting text as a background in cell
  518. Adding rows to an array
  519. look up table
  520. match cell text with text in formula
  521. How to apply conditional formatting with incremental address for .
  522. Function to convert feet and inchs into decimal equivalents
  523. RE: Macro help
  524. Linking Excel Worksheets
  525. Macro help
  526. filling a forumla down a column from data across a row
  527. printing from different areas
  528. Formula in text boxes
  529. How do I exclude non-duplicates from an excel file?
  530. convert seconds to minutes and seconds
  531. Referring to Previous Worksheet - coding
  532. protect embeded object
  533. merge data problems
  534. How do I increment a date by a certain number of weeks?
  535. export colum to bat file
  536. Loan amortization schedule with bi-monthly payments
  537. Need help with unit formulas
  538. Combined IF statement...
  539. How to display the "values" included in a formula vs. the cells?
  540. Formula to list unique values
  541. Excel IF function
  542. test for date in column question
  543. More IF help
  544. Date Vacation Tracker
  545. How to "repeat previous entry" ?
  546. micosoft excel dates entered but changed to sequencial numbers ho.
  547. Is it possible to create a limiting value for a summation?
  548. Creating multiple hyperlinks from a column where the text in the .
  549. Creating multiple hyperlinks from a column where the text in the .
  550. match two spreadsheets
  551. Time format help needed
  552. Display references to linked information
  553. Excel: Formula worked last week but now stoppped working.
  554. Rødder
  555. How do I calculate Costs from a Time. ie 16:00 - 12:00 = 4:00hrs x £5.50rate per hour = £22.00
  556. how do i do an inline function like in matlab
  557. rapeat heading row after each alternate row
  558. Re: Another solution for multiple embeeded IF
  559. Drop Downs Menus
  560. Show value or not equal
  561. Formulas
  562. Count repeats
  563. Excel IF function for text
  564. "Calculate" note at bottom of my screen?
  565. Excel template wizard
  566. Using the MAX function with "constant increment" cell references
  567. Functions
  568. Current Cell Color
  569. MODE function
  570. How do I fill down formulas so they iterate in intervals other th.
  571. Pivot Not Updateing
  572. How do I link sorted data to other workbook sheets?
  573. Find lowest value in a range
  574. excel spreadsheet?
  575. Desplay zero if yes
  576. Vacation
  577. Count items between specific hours on a matching date
  578. How do I count these?
  579. Dynamic Year-To-Date Formula
  580. How do I copy from old drive to new?
  581. INDEX, user input?
  582. Look Up and Cell Reference - Formula Help Needed
  583. Calculating VAT (value added tax)
  584. Add "FIND LINKS" to EXCEL Audit function
  585. Need help with date & time formula
  586. Working with a large group of numbers
  587. Return non-zero cells in column
  588. How to delete duplicate records when I merge two lists (deleting .
  589. Excel: how to formulate conditional cell references
  590. selective averaging
  591. Visual Basic Code Remains in "memory"
  592. How do I use last cell w/value with Sum?
  593. problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable.
  594. Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable
  595. excel should allow to add and subtract times
  596. Is it possible?
  597. Best time question
  598. Does Excel 2000 have a 'datedif' function to calculate the number.
  599. one sheet to another, when teh lines vary
  600. pull data from sheet two, then fill in the data to sheet one (part
  601. Change the Font Color
  602. inserting row into linked cells
  603. COUNTIF function
  604. search with drop down list
  605. how do i get the names of the sheets
  606. Vertical lookup help needed
  607. insert rows
  608. time zone chart
  609. Re: time calculation excel
  610. Sorting Merged Sum Fields
  611. Creating a menu
  612. Find and Replace?
  613. How do I insert an Excel file into a PowerPoint Presentation slid.
  614. Using result from ADDRESS function as a cell reference itself
  615. isblank function
  616. name of sheet
  617. Cell References in Functiona
  618. sumif function in excel
  619. Index to determine total of values
  620. Sorting
  621. linking cells colors
  622. How do I use @choose command to add selected columns
  623. How do I insert a 'clear all' button in excel?
  624. Formula to sum and list highest to lowest
  625. What does it mean when it shows ####### in a cell on Microsoft Ex.
  626. Dragging formulas
  627. Dragging formulas
  628. How do I set up a calender in excell simiar to those on websites
  629. sumproduct formula
  630. Fill Series... Letters? Can Someone Help?
  631. using sumproduct in a range of text fields?
  632. identify data in a cell that has a number as the second character
  633. How can i filter dates based on day of month
  634. why is my "compare side by side" command greyed out
  635. Moving text in a cell
  636. reference numbers for invoices
  637. 4 different if statements, not working
  638. I need to count the occurence of text in a range of cells (which .
  639. how I can insert a "tick" symbol
  640. Fungerande schema Excel -> Outlook?
  641. Find LARGE, and th cell 3 cells to the left?
  642. Protection in Excel via email
  643. dynamic year to date formula
  644. Double entry lookup
  645. Keeping Row 1 at the top during a Data Sort...
  646. Invoice numbers?
  647. How would I calculate commisions (with a cap)?
  648. How can I automatically have 10% added to cell after typing a valu
  649. Excel 98 Invoice Template
  650. how to merge worksheets in the same workbook
  651. calculating with a time format cell
  652. Last saved date into an excel cell
  653. Roots
  654. 2 If Statements between 2 values Q
  655. Weekly data allocated to months
  656. How do I set up Excel to search nearest resource by address
  657. Excel 97 compatibility
  658. I am not able to format cells for zip codes
  659. looking to update price list, wanted to up charge list by 35% .
  660. Worksheet cell help
  661. Query questions (I think)
  662. changing comment indicator size or shape
  663. Formulas
  664. Diagram row values
  665. Excel AutoFilter
  666. color change
  667. Excel SQL.Request restricts data returned to array
  668. Excel instance not shut down
  669. Making text all CAPS in excel
  670. AUTO PAGE NUMBERING DIFFERENTLY FOR A WORKBOOK
  671. True False
  672. Creating a check box that does not require security clearance.
  673. Removing commas
  674. formula is displaying as text rather than result.
  675. Date Format
  676. Excel Workbook opens after a very very long time
  677. How do I change the color in an IF proposition.
  678. Highlight Time
  679. how to save to My Documents folder on different PCs
  680. Need help troubleshooting an array formula XLXP on Win2K
  681. Vlookup, index, match?
  682. Eliminating Single Quote Before Equals Sign
  683. Outlook vs Outlook Express
  684. Text function within Sumif
  685. Links are broken and cannot fix
  686. ranking an row of values
  687. Comma explanation
  688. File name changes to blue color
  689. Count and Sum with Conditional Formatting Problem
  690. Format text based on which of several unique lists the value belongs to?
  691. Custom Formats
  692. Getting a average from a survey
  693. "Unable to get the NormSInv property of the WorksheetFunction clas
  694. Text to columns will not shut off.
  695. sum product in an index possibly?
  696. Parsing when deliminator is a string
  697. spreadsheet for accruing interest and penalties that vary
  698. How do I check formatting in an if-then statement
  699. How do I get the nth root of a number?
  700. Another question on how to find duplicate data
  701. Pivot table field names
  702. How do I create a formula to add values from specific fields?
  703. How do I create a formula to add values from specific fields?
  704. newbie questions
  705. count data but avoid double entries
  706. Microsofts week numbering
  707. protection on excel forms
  708. Preceding Zeros...
  709. How do I reference and sort a range of numbers in Excel 97?
  710. zip+4 format
  711. Make Values Smaller Q
  712. Change the cell padding?
  713. Referencing a closed file
  714. HOW TO CONVERT EUROS TO SWISS FRANCS IN A EXCEL SPREAD SHEET
  715. Querying Access Database
  716. question about vlookup
  717. how to enter a null cell value in a formula
  718. Revision Number
  719. Coverting array data into single column
  720. countif array formula
  721. In Excel, how can I tell the program to disallow duplicate data i.
  722. Excel Menu Bar
  723. sumproduct help
  724. Max function
  725. Excel Solver Results do not show up
  726. Name Box cell reference
  727. How Delete Network Password Request-Worksheet in Website
  728. limit cell list selection based on the selection of another list
  729. How do I caluclate a function?
  730. How do I unhide multiple sheets?
  731. Trying to get formula to Do table
  732. Copying ranges of numbers
  733. Advanced Filter using Date represented as text
  734. Copy/insert copied cells when protection is on...
  735. Shaded cells won't print shaded
  736. Help, Excel Formula Needed -- Urgent
  737. cell reference in formula
  738. How do I convert from cc to teaspoons or ounces
  739. Match, Index, Vlookup, Large....Help Please
  740. Match, Index, Vlookup, Large....Help Please
  741. Can you convert 13:00 to 1:00 pm without the pm being displayed (.
  742. method and function
  743. Counting every unique text string in a column
  744. how do i get more than three conditional formats in excel
  745. My XIRR function has dropped out, analysis toolpak doesn't fix.
  746. Grouped Columns/Rows
  747. How to delete a Macro from within another Macro
  748. Can the linking ever end?
  749. CASE statement equivalent
  750. formula corruption
  751. How do I use the Gamma Function in Excel
  752. How do I unhide the cell format function in Excel 2000
  753. Duplicate data in a cell...
  754. how do i change euros into australian dollars
  755. Correlation Coefficient Issue
  756. Moving text from one cell to another.
  757. Auto fill of formula
  758. Quick Jump to end of list...
  759. Excel Date in uppercase
  760. Concatenation Help
  761. combining 3 columns of same info for a pivot table
  762. Inserting row but with formula carried down
  763. sheet tab name
  764. Formulas not working after transfering to new workbook
  765. Formulas
  766. If Between 2 Times
  767. Sheet tab name
  768. How do I delete Rows from my woorksheet?
  769. Auto Filter Counting
  770. Changing Cell References in Formulas
  771. Formula to calucate # of months based on a speificed date entered
  772. How do I get excel search through a range of numbers e.g. 1.99 - .
  773. How do I get excel search through a range of numbers e.g. 1.99 - .
  774. Hyperlink Creation in Excel X for Mac
  775. Excel: Add "dBm" and "dBW" to CONVERT worksheet function Power u.
  776. Formula to determine a future date based on criteria
  777. How do I find how many business days are between two dates
  778. macro code shortcut
  779. How do I use Range Names listed in a VLookup table in a formula?
  780. Reference a cell to get worksheet name
  781. If Greater than when a formula Results in N/A
  782. Counting data by certain years
  783. how can I insert a picture conditional on another cell
  784. Database or list range is not valid
  785. Pivot Tables multiple data fields
  786. record macros in excel and get data from webpages
  787. How do I set Excel to auto open a document into a new Window even.
  788. Locking Sheet names in formulas
  789. opening Excel
  790. I need a formula that will sum the top 3 number in a column
  791. If Function true value in Red
  792. installing sql.request help
  793. Linking Cells and applying a sort
  794. convert minutes into hours:minutes
  795. Question on LABEL Range
  796. Conditional Format
  797. a
  798. conditional format
  799. Multiple Print Ranges on one Worksheet
  800. less than another value
  801. updating excel worksheets to another workbook
  802. Using keyboard to select using excel 02 data...
  803. Formula View
  804. Database functions
  805. How to express $A:$A with formula
  806. Conditional Formating when result is text
  807. Macro to delete a macro
  808. Thank You Tom Ogilvy
  809. making a workbook into a web page.
  810. making an employee schedule in two sheets
  811. HOW CAN I FIND OUT WHO ACCESSES MY SPREADSHEETS
  812. Defining a number in a cell by text then subtracting it by the tex
  813. GET NON-ZERO RESULTS USING STDEV FOR CERTAIN NUMBERS
  814. how to increase the font size in a dropdown list?
  815. Return result from multiple criteria
  816. vlookup over multiple worksheets
  817. TEXT function to format a date in English & French
  818. If Now = A Cell Range Then Q
  819. How do I widen the Name Box Navigator in Excel?
  820. How do I ROUNDUP a Column of cells on a worksheet template?
  821. Conditional Sum
  822. Filters
  823. Macro Help
  824. how do i change the column width over a number of rows in the sam.
  825. RE: Linking Workbooks
  826. Mid,Find,Len
  827. Sum with multiple conditions in Excel 2000
  828. How do I use ">$E$5" as the criteria using SUMIF and have it work.
  829. duplicating formulas without updating
  830. Cell Lock
  831. Using SERIESSUM
  832. How do I subtract with text valued number instead of an actual num
  833. merge cells button doesn't work
  834. How do I do conditional format based on a cell with a formula?
  835. Subtotal function
  836. 2 questions, copying data from sheet to sheet and assigning macro
  837. SUMPRODUCT & COUNTIF
  838. Subtotal function (again)
  839. Searching text in a cell range
  840. Excel should let me refer to the same formula on multiple sheets
  841. conditional formatting-Date
  842. How do I get the nth root of a number?
  843. TODAY Function
  844. how can I wrap text from one line to another?
  845. Hyperlink loses reference
  846. How do I copy only sub-totalled values - without any detail?
  847. Shared worksheet
  848. help with "criterea" in the sumif function
  849. When saving workbook only the first worksheet gets saved.
  850. Getpivotdata "N/A" error
  851. trying to get excel to do a prompt with a function, can it be done
  852. autoexpanding two tables
  853. How do I put a background in a coloured spreadsheet?
  854. two quick questions on excel. please answer as soon as possible...
  855. Finding & Capturing First Occurance
  856. how do i compare 2 spread sheets if the content of a cell is avai.
  857. Update Log
  858. Random Numbers Change?
  859. Repeating header/footers for excel
  860. Random number generator
  861. Conditional Formatting Blank =white.. but 4 conditions
  862. How can I dynamically eliminate blank cells in a given range in E.
  863. Updating 1 spreadsheet from another
  864. vlookup with table_array constructed from mid formula
  865. Weeknum
  866. How to define separate Password Protection, to say 3 persons, for.
  867. How to define separate Password Protection, to say 3 persons, for.
  868. Add checking
  869. Indirect reference from one worksheet to another
  870. Linking 2 Excel Sheets, Anticipating Lines.
  871. vlookup with multiple lines of same value
  872. Radio Buttons
  873. How do I split a column having numbers and text in a random order
  874. Hello, again Help is appreciated
  875. Calculate Wages
  876. Parse text & Numbers
  877. Display value if next cell below is zero
  878. Formula Does Not Omit Criteria
  879. How do I merge individual data now in multiple cells, in to one b.
  880. concatenate values/texts corresp. to a searched repeated value/tex
  881. Re: Extract Portion of field into other fields
  882. In-cell dropdown for validation stopped working
  883. Minutes
  884. How to change the source of a link- Instructions were followed. I.
  885. How do I duplicate a sheet 20 times in an excel spreadsheet
  886. Summing vlookups?
  887. Excel indention
  888. Formula Result Correct but value in the cell is wrong
  889. JWalk EDF
  890. Finding Partial Text in a Cell
  891. automatic calculation freezes
  892. Listing Multiple Rows from Match
  893. e-mail list comes up as hyperllinks
  894. Pulling data from 2 columns for a total
  895. IF Function
  896. Is it possible to run a vlookup on font color
  897. countif statement
  898. Summing Sheets - SUMIF ?
  899. Data Validation w/ If, Match & Index Statements
  900. worksheet change and cases
  901. how do I move and activitated cell with a directional key movemen.
  902. count cells over multiple sheets
  903. how do I alphabetize items automatically in excel
  904. Beginners question: VAT Column
  905. status bar shows "filter mode"
  906. Add 2nd variable to if statement - ifAnd?
  907. 16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO
  908. Vlookup Problem
  909. RE: Convert Numeric into Text
  910. sort + & - numbers together
  911. message box
  912. Trouble writing an excel formula...
  913. formula
  914. #DIV/0 Error
  915. Match text to another worksheet and return a certain value
  916. How can I count #N/A in a column?
  917. if function in msexcel
  918. How do I change content of a cell based on date
  919. importing multiple text files URGENT!!! HELP
  920. Duplicate entries
  921. Need Vlookup help
  922. Sumproduct #num error
  923. How do I make one cell equal to another
  924. Extension of and IF & VLOOKUP statement
  925. How to print invoices for each advertiser from Excel worksheet
  926. Help creating a formula, pulling from a set of static numbers.
  927. Newbie questions on spreadsheet
  928. Time in formulae
  929. re Time in formulae
  930. Cell formatting
  931. WeekNum ISO
  932. Blank cells in a chart
  933. MIN excluding 0s
  934. auto sum in formula
  935. Excel Forumla to seach and return all values
  936. copying format of a table
  937. Time in formulae (last one)
  938. Capitalize first letter when type a name in each cell.
  939. Sorting by equations
  940. help needed with copy from one workbook to another
  941. I need a function to update sales/expenses based on previous tota.
  942. Display material and activity
  943. Automatic cell increment with data from sheet 1 to sheet 2
  944. Linking List
  945. Is there a function to caluclate convexity of bond given cash flow
  946. Transfering Info
  947. Help with fixing formula
  948. Excel funtion to find how many boxes in larger container
  949. Vlookup #N/A error due to formatting
  950. if then statement
  951. VlookUp with Multiple Criteria?
  952. Linked cell location of hyperlink
  953. Subracting Dates to come up with the # of days between them
  954. Hyperlink stops working
  955. how do I keep keep numbers in a csv format?
  956. Counting values
  957. ability to auto file column(s) on a pivot table
  958. formulas against columns not cells
  959. Macro - Skipping a line
  960. Lookup Problem
  961. Could not execute
  962. VLOOKUP ~ symbol
  963. vlookup with data on more than one sheet
  964. VLOOKUP or HLOOKUP??
  965. Curious about SUMPRODUCT
  966. 7+ nested if statement?
  967. can you merge a excel to infopath?
  968. Permutation Output
  969. Last Months Data!!
  970. Text to Columns from the Left
  971. CAN YOU HAVE THE TOP OF AN EXCEL SHEET HAVE DIFFERENT COLUMN WIDT.
  972. automatic worksheet loading
  973. show if more than one line of data
  974. Can I make a custom button in Excel for the Group feature?
  975. IF FUNCTIONS - HELP
  976. CAN I ADD NUMBERS IN ONE CELL
  977. SUMPRODUCT But With <> Criteria
  978. complex formula
  979. Date formatting when combining two cells into one
  980. Choices
  981. How do you use the explode and collapse panel to hide rows?
  982. list validation using list validation...
  983. Vlookup using a substring for evaluation?
  984. Array Formula
  985. unhide hidden window or workbook
  986. Index Match Problem
  987. How can I round an hour to the nearest 1/4 hour?
  988. drop down list default
  989. Copy a range
  990. How can i round off .10 as .50 and .51 as 1.00
  991. compare
  992. XSL to XML Help AHHHH
  993. Can the results of a formula drive color shading? How? Can it be .
  994. complex formula
  995. how can i freeze the first two sheets and scroll rest of the shee.
  996. Multiple formulas including INDIRECT
  997. How do I insert a line feed in a formula?
  998. show groups
  999. How do I set up a date cell to and 15 years in another cell?
  1000. SUMPRODUCT (Again!)
Google