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] 88 |  89 | 

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