View Full Version : Microsoft Excel Worksheet Functions


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

  1. summing problem!!!!!!
  2. How can I use dcount to total the number of columns with entries?
  3. Is there function to check and list data?
  4. Does anyone have a weekly schedule that computes total hours work
  5. Does anyone have a weekly schedule that computes total hours work
  6. how to convert julian date to general date
  7. NPV IRR MIRR
  8. GETPIVOTDATA Bug
  9. Function Help
  10. sumif based on partial match
  11. Calculated Fields in Pivot Tables
  12. Check my IF function
  13. trivial problem
  14. How do I do a sumif function not including hidden rows?
  15. if statements
  16. Formulae containing more than 7 arguments?
  17. How do I select price from sheet.b where sheet.a part no = sheet.b
  18. Adding Tax in excel
  19. Retrieving values from a specified sheet of a different file.
  20. Date format problem
  21. Create a Formula to display the sheet name.
  22. Newbie problem need formula help
  23. Formula help
  24. Exporting Excel spreadsheets with functions
  25. Advance function of excel to get sorted data
  26. Date formula that adds 7 days to a cell when sheet is copied
  27. how do i have beginning balance take away an amount auto total
  28. Subtracting From 2 Cells
  29. how do I put 'c' in () in excel & not get copyright symbol
  30. Match 3 Criteria and Return Lowest Numeric Value
  31. incremental counter
  32. RE: Sorting names in Name box
  33. How to prevent warning messages on protected work sheet.
  34. Importing .txt file
  35. Sorting names in Name box
  36. Suggestion
  37. running balance in Excel
  38. convert number to time
  39. Comparison result changes font color
  40. Vary column to sum in SumIf
  41. Conditional Formating
  42. Offset
  43. Changing Color Palette
  44. Help for sumif / sumproduct
  45. How to count after 2 conditions are met
  46. Help with Excel formulas
  47. skip blanks
  48. how do I get access to the datedif function?
  49. Some help needed?
  50. prevent data entry into cell?
  51. Copy data from one worksheet to another using a function or a macr
  52. if statements
  53. Help with formating cells (decimal places)
  54. Sorry for the 3 threads! My bad...
  55. copy only unique values
  56. Drop-down Lists
  57. =If - how to tell it to calc certain %'s only
  58. Change the width of a column by using a cell reference
  59. Can you write a formul that will put multipal answers in multipal.
  60. Can you write a formul that will put multipal answers in multipal.
  61. Help with vlookup
  62. copy formulas without associated values
  63. Function for copying color formatting
  64. Using Lookup function
  65. Index-Match from a range
  66. point to a cell in another workbook
  67. How to populate prices in sheet two based on cost in sheet one
  68. Dynamic Ranges and Lists
  69. Don't think it's possible, but I thought I would ask.
  70. Array, circular reference problem
  71. Not sure which function - Maybe IF
  72. Date Value
  73. sum if conditions in two columns are met?
  74. excel formular
  75. How to format 39.5 to 39.5%
  76. remove partial data from cell
  77. Sorting Colums
  78. keeping cells aligned when data is updated
  79. trying to lookup a value and return if true or fals
  80. excel formular update
  81. 'Copy to' Advance Filter depend only on sheet ID not start sheet
  82. =bahttext(A1) please tell me about language in english how can i
  83. =bahttext(A1) please tell me about language in english how can i
  84. =bahttext(A1) please tell me about language in english how can i
  85. =bahttext(A1) please tell me about language in english how can i
  86. Can a cell be set to accept input only once?
  87. Excel 2003's autosum does not update data in real time
  88. show customer based on Weekday
  89. What is quickest way to insert 4000 hyperlink documents?
  90. protected document loses all protection(hidden columns) when manually copy-pasted
  91. paste special values
  92. Mortage Calculations
  93. Highest value in column b returning column a
  94. Retriving Values from a separate sheet of a different file
  95. Prefixing a selection of cells with zeros
  96. Forgot my pass word for excel sheet
  97. Number Transform to Date
  98. Using Check boxes in Excel
  99. LOOK AT THE CONFERENCE- INTERESANT
  100. calendar help
  101. Help with formula
  102. Does Excel contain a decision tree analysis?
  103. Is there a way to write an equation that ignores cells that have .
  104. i maintain DB of URLs in Excel. how can i avoid duplicate entry?
  105. Track Changes
  106. How do I add a column of cells, but IF a row has (), subtract?
  107. Rounding up/down problems ?
  108. Conversion of Numercials to Figure
  109. Excel links
  110. How can I use one formula to change case on an entire worksheet?
  111. sum column containing both text and numbers
  112. DIV/0!
  113. recognize formula
  114. Stumped: If a cell contains a formula, can you make text color automatically change?
  115. Comments in Excel
  116. Can't see sheet, and have tried unhide, etc?
  117. find a value in a table, go to the previous column and add that co
  118. Can I lock worksheet reference?
  119. annual percentage return
  120. how do i change an incorrect amount in a cloumn after download
  121. Cumulative Average
  122. Rank a changing row
  123. Formula to a number can you tell
  124. macro security too high in excel, I can not get into input data
  125. What has happened to "Save As" in Excel 2003
  126. I need a payroll sheet that can auto update figures each week
  127. Formatting
  128. How do I get the MAX value of adjoining columns then SUM range?
  129. formula to add dates.
  130. Cell reference between worksheets
  131. number lookup
  132. Select Distinct Maximums
  133. How do I circle a number in excel
  134. ReCalc'ing for almost everything I do
  135. Conditional Expression in cell
  136. stuck with macros
  137. Re: ReCalc'ing for almost everything I do
  138. Re: Conditional Expression in cell
  139. Re: Conditional Expression in cell
  140. RE: ReCalc'ing for almost everything I do
  141. edate function
  142. unable to grasp SUMPRODUCT
  143. how do I update the scenario summary sheet?
  144. how to do a dynamic ranges?
  145. how to retrieve information that was saved on a floppy disk?
  146. Can I freeze column A and scroll down the other columns in Excel?
  147. elapsed time problems
  148. How to Share & "Un-Share" Worksheets
  149. Invoice Comparison
  150. Excel Form and Data Retrieval
  151. Spreadsheet Function
  152. cell painting
  153. adding to different totals dependant upon selection from drop down
  154. Macros
  155. Macros
  156. Separating text and data in a column
  157. Excel Conditional sum, lookups and functions help PLEASE!!
  158. hyperlink in combo box/data validation
  159. return value other than #N/A
  160. Conditional Formatting
  161. can this function do this?
  162. use Now() in two cells for start and finish times
  163. look up formulas
  164. making gains or losses appear red or black in formula
  165. Ranking on basis of 3 Parameters
  166. How to split worksheet to make smaller
  167. Ranking on basis of 3 Parameters
  168. Navigation
  169. I'm having a really strange problem with 3 if statements.
  170. Formula needed for 2 criteria
  171. Vlook up and if statements (I think)
  172. I want to be able to create a dynamic reference in excel, for exam
  173. Bug Report for Excel
  174. min value
  175. how to use list in excel 2002
  176. Adding up data in multiple cells for a single criteria.
  177. how do I add a drop-down calendar in excel?
  178. Excel Cell References are different to normal
  179. Help Please! - Creating Function Calculated Fields within Pivot Tables
  180. Using Countif when column A=Num and Column B=Yes
  181. UK Excel User Conference - July 19-21, 2006
  182. How to Convert Figures into Text in Excel
  183. Indexing of Name
  184. Look UP Formula
  185. I need help with Excel
  186. How do I hide a formula so it will not show on the spreadsheet?
  187. fractions and decimals!
  188. Counting unique text entries in a filtered list...
  189. Summing cells in array
  190. Calculation of Gross Margin in a pivot table
  191. Pulling my hair out here
  192. Obtain Easter date?
  193. I'm desperate I posted earlier about "If" statements that don't work but are correct. Now...
  194. Gauss elimination / linear algebra. Please help.
  195. use vlookup or other to find the nearest values (<>) or interpola
  196. how do I sum time difference
  197. Working with =IF(ISNA,(myformula),0,(myformula)
  198. Lease term dates
  199. Excel - allow cell margins similar to Word table cells
  200. EXCEL
  201. Conditional Appending in Excel
  202. Problems with IF statement
  203. priority naming
  204. Advanced filter a dynamic date range
  205. Date calculation
  206. Can I modify the YIELD formula to use a monthly frequency?
  207. Deleted column
  208. can a conditional formulas be setup using text to get a numerical
  209. Problem with Excel worksheet in Word file
  210. Formula Assistance
  211. I NEED A HELP IN EXCEL
  212. Cell reference update when copied and pasted
  213. Count entries in columns and rows
  214. Figuring Grades
  215. Subtract Dates based on 24 hour system
  216. imbedding picture
  217. Countif Across the Midnight Hour
  218. Date - greater than and less than
  219. "THIS" Row Reference
  220. IF statements with lists
  221. Format date in destination cell
  222. Is it possible to insert a function within a sentence in Excel 200
  223. When i try to filter information, excel returns a blank page?
  224. Finding a "Between" function
  225. Macro help
  226. Conditional formatting, looking for changes in date
  227. Cell Formatting Conditional On Other Cells Fill Color?
  228. follow hyperlink?
  229. equal sign in front of date in formual bar
  230. Excel 2003 multilevel subtotals in wrong positions
  231. How do I compare two simular excel documents
  232. Sum range auto update
  233. Can List or Combo Box have multiple selections?
  234. I want to relocate a column, save the figures, and erase formula
  235. multiple regression
  236. Date function
  237. Problem with foumula
  238. Formula Combination
  239. combining ratios
  240. How do I set cells to sum/average/etc time? e.g. 1 minute 30 secs
  241. Nil in Place Off #N/A
  242. Tracking Errors
  243. how do I relace words in new ones in certain cells in Excel
  244. How do I count letters and numbers in a formula?
  245. Between? Is there a way?
  246. How do you calculate workdays if Saturday is a workday?
  247. Excel should let me link one cell to another.
  248. printing columns
  249. Creating Drop Down lists
  250. how to express > dan < using excel?
  251. Auto copy of Numbers or date
  252. Picking values out
  253. how to use trigonometric functions in Excel?
  254. Summing values from array
  255. Possible to combine VLOOKUP and IF(AND) functions?
  256. Formating cell
  257. Sorting or if statements reliant on formatting
  258. best in series macro
  259. How do i set up a sheet to count the years to retirement?
  260. MS Query error
  261. Quarter End Date
  262. Why does not Excel 2003 Replace comand romove spaces from cell contents?
  263. MS Query takes along time to open
  264. Fixing multiline cell
  265. Random Matrixing Problem
  266. how do you enter more than 7 "if" functions in a formula?
  267. nested fnctions
  268. Inconsistent Array Count results
  269. Single Function to Analyze Two Columns?
  270. Help make a date = Day 1 of the next month ie. 20060501, 20060601
  271. Counting Conditional Filtered (By Color) Cells
  272. VLOOKUP Question
  273. Re: Help make a date = Day 1 of the next month ie. 20060501, 20060601
  274. Retrieve xml data from SharePoint
  275. How do you add the three lowest numbers in a column?
  276. spreadsheet for tracking reports daily, monthly, yearly and graph
  277. Vlookup help
  278. challenging formula(for me), counting days between dates for multipleyears
  279. Nested Functions with OR
  280. Improving formula
  281. Pivot Tables - how do I add in calculated fields?
  282. Vlookup maybe???
  283. Need an OR Function that will allow for Text vales.........
  284. Find sum across all worksheets
  285. Why does this Formula work?
  286. entering formulas
  287. how to print a page many times but add a unique reference on each
  288. Match and Lookup problems
  289. Writing Macros
  290. How do I calculate the cost of credit figured as a yearly rate?
  291. After rounding/formatting to whole numbers...
  292. how do i create hyperlinks
  293. Does excel acept arguments
  294. system won't allow a conditional format
  295. Error message #NAME from formula
  296. Using A Public Function /
  297. Shortcut Key for Text Changing Color in MS- Excel
  298. formula
  299. Required Field
  300. Conditional Formatting based on other cells
  301. Formulas
  302. Over my head on this one...
  303. Should I use a macro to copy and paste value?
  304. sumif with multiple conditions
  305. LEFT / RIGHT functions
  306. FTP Reference
  307. Sorting Numerical Values...
  308. dropdown lists
  309. Searching rows with multiple columns criteria
  310. Formula for duplicate entry
  311. Display Row label covering multiple lines in Excel Pivot Table
  312. Preserve existing data whilw using external links
  313. Averages based on dates
  314. Same entry on multiple sheets
  315. Excel Formula - Add column of numbers but ignore negative numbers
  316. cut and paste or something more elaborate?
  317. Automatically multiply be a number.
  318. How do recover from DATA Error [47 of 94 93 F4 K5] in Word/Excel
  319. looking up data in another column
  320. Adding buttons to a new menu bar
  321. excel
  322. Counting by a Range of Values?
  323. msg box
  324. How to get Excel to work faster
  325. Remove text from cell
  326. Counting Values
  327. excel status bar says "double-click to edit PBrush"
  328. uk wage calculator
  329. Hyperlink function fails when using variable row number
  330. Repeating headings
  331. Rank function not showing consecutive
  332. sorting scores
  333. Limitations of RANK
  334. Subtotals by grouping
  335. Vlookup & Find
  336. .0 is creating #VALUE! Error
  337. Blank Cell
  338. excel formula formatting result
  339. If statement to cover range
  340. Excel Spreadsheet - Mandatory fields
  341. Access to Excel
  342. my filter is stuck !
  343. Adding data in a list that meets a specific criteria
  344. Please help with Statistics Functions
  345. Conditional Filtering
  346. Re: Custom Functions saved as addin
  347. Re: Custom Functions saved as addin
  348. Using Match & Offset
  349. Named formulas in CHOOSE need to be Relative references when paste
  350. Table array in VLOOKUP (EXcel 2003)
  351. If than copy function / Macro
  352. RE: Table array in VLOOKUP (EXcel 2003)
  353. RE: Table array in VLOOKUP (EXcel 2003)
  354. Public Function - Color Index
  355. Return A Range of All Cells With Links
  356. How do I stop making the spreadsht move when I move up/dwn/lt/rt?
  357. Re: How do I stop making the spreadsht move when I move up/dwn/lt/rt?
  358. Help with looking the nearest Sunday
  359. Complex or Conditional Countif(s)
  360. Circular reference mistake
  361. In Excel a cell formatted "currency" shows "######" help!
  362. Autofilter grayed out - why?
  363. how do i use vlookup to search for a value on another sheet?
  364. combining multiple sheets
  365. Conditional Formatting
  366. Problem analyzing my data
  367. increase/decrease decimal
  368. How do I optimaly distibute a number (whole values) into a range
  369. Dragging & incrementing cell values
  370. Need formula to jump from one column to the next
  371. conditional formating
  372. Transpose Function
  373. duplicate numbers in column a and diferent values in b
  374. Subtotals adding a description next to the subtotals
  375. Help! Formula that can Ref. hidden data & Populate Cells with desired text
  376. How to enter a range address using data elsewhere on the sheet?
  377. Desperately trying to build a paid time off accrual worksheet...
  378. using a master reference
  379. Easily convert all formulas in 3d spreadsheet to values?
  380. divide by zero
  381. Finding specific text in a string
  382. Randomly Generated List / Macro
  383. Finding specific text in string - Part II
  384. results on sheet 2
  385. annualized return calculation for the purpose of portfolio performance evaluation
  386. repeating columnar data
  387. Why do i have blank lines in my subtotals results
  388. i'm trying to put a value with a number but its not working.
  389. All of a sudden none of my Excel formulas are working...
  390. sort 2 or more occurrences
  391. sum a range between two given dates.
  392. Sum function not working, help please!
  393. Getting rid of helping columns
  394. Function question
  395. use "if" and "max" in the same function
  396. Re: use "if" and "max" in the same function
  397. How do i create a countif formula in excel?
  398. Smart Tags and Stock Quotes
  399. use "if" and "max" in the same function
  400. Transpose Row by Row
  401. NEED TO MAKE THE PRINT BUTTON FUNCTION IN WORKSHEET
  402. validation list
  403. multi-conditional expense tracking problem
  404. Can this be done
  405. Excel - How to select the last x entries in a column?
  406. using a formula, no's 1-443 deleting (116-124) in serval cells
  407. Missing rows ?
  408. Download An Open Letter From Al-RASHEDEEN Army To The American President
  409. COUNTIF function query for multiple colums
  410. Querying a range returned by another function
  411. Multi-sheet mapping problem
  412. Excel ? Formula for moving average
  413. Tab Stop with a protected Spreadsheet
  414. auto fill from another sheet in excel
  415. HOW DO I CALULATE A OVERTIME FORMULA
  416. Need Countif to work like Sumif
  417. formatting cells
  418. Re: How I can find breaks in continuity
  419. how do i only get negative values
  420. Auto Filling one sheet from another
  421. Where do I find MegaStat ?
  422. How Can I Do This?
  423. the value of a box in excel if entered data is a certain value
  424. Finance Formula Help
  425. Improve Excel Help Text - Make easier to Find Function Refs
  426. Simplicity is Desired
  427. Column names
  428. Replacing Linked Cell Values w/ Current Values
  429. how can i highlight dupplicated in 2 sheets at a time?
  430. Run out of nested Ifs
  431. Sort by column inside a worksheet
  432. COUNTIF across multiple sheets
  433. Code to raise Directory request box
  434. Protecting Workbook!..
  435. CONDITIONAL FORMATING FINDING TEXT CONTAINING SPECIFIC NUMBERS
  436. checkbox
  437. checkboxes
  438. Can Named ranges be used in file link formulae?
  439. plus and minus sign in cells
  440. Adding or pasting a row, but having info shift upwards not down??
  441. subtotals
  442. i have a excell for with data entered in and need to enter new da.
  443. Vlookup for multiple selections
  444. Count function applied to a time period
  445. Sumif Formula
  446. hyperlink reference not valid
  447. excel
  448. Percentages
  449. complex excel formula Array how do I convert it to a vba Function
  450. Rounding or not rounding
  451. Filling Blank Cells
  452. Return Summed Count of Multiple Consecutive Numeric Values
  453. Sum Values Question
  454. How to fix lower and upper bounds for data
  455. Re-Post - Any Help Appreciated
  456. Combo box with data to use as hyperlinks
  457. Deleting unwanted colums on a worksheet
  458. how protec cell in excel?
  459. PPMT Function with varies interest rate
  460. Function to count unique items in list
  461. Fixing Hyphens
  462. Identifying First Instance of a Value Given a Criteria
  463. IF formula doesn't work with certain numbers
  464. grouping rows with blank cells
  465. Find 2nd Largest Value
  466. 3.02 PM ( Decimal Point )to 1502
  467. Protection will not allow me to insert a comment
  468. How do I make a letter represent a number?
  469. How Do I Do an Exclude Filter based on a Named Range?
  470. vlookup
  471. How do I stop a Macro from running?
  472. transfer data from sheet1 to sheet 2
  473. list box
  474. MRound and Roundup
  475. Address for Linked Files in Formula
  476. Match name not exact
  477. Creating formulas
  478. Auto Fill
  479. Average only cells that contain numbers
  480. Count down clock
  481. Excel Functions
  482. what's the formula for finding 401(k)?
  483. How can I use Excel to solve an equation?
  484. Function that compares dates
  485. How to do nothing if @IF returns FALSE?
  486. Easy question: Sort ascending in a row?
  487. Loan Amortization
  488. multiple worksheets
  489. Centering comments
  490. How do I format default cells in a template
  491. Exporting data from access to excel
  492. Convert Excel 4 formula to Excel 2003 format
  493. Split the date & time in one cell to be 2 colums.
  494. Expected end of Statement
  495. If Statements
  496. Is this possible , screen captures with a macro?
  497. Build an array constant with DATE function
  498. variable Addition and substraction
  499. Comapring fields that have TXT and No's
  500. Variable VLOOKUP source and target
  501. "Looking Up" Access from Excel using SQL.REQUEST
  502. hit F2, want the color coded formula to appear in formula bar not
  503. vlookup not found
  504. Merging Columns
  505. Spreadsheet won't print changes I made, only what was prev. saved.
  506. Formula help
  507. my first 'IF' formula
  508. Merging and unmerging cells
  509. how to stop xl from showing hidden colomns
  510. Need to link excel "cell" to a pre saved PDF file?? How do I do th
  511. font problme
  512. Adding Time
  513. Displaying time - Error in formula (I think?)
  514. Formula auto-fill help!!
  515. Data Range Question.
  516. Finding the Monday date based on a different date in same week
  517. create a formula
  518. Excel function glitch?
  519. assign numbers a value, then get percentage
  520. Stripping text before a number (alpha or numeric)
  521. Drop Down List Error
  522. How do I enter a formula that will delete a line when a cell = 0?
  523. When I open a workbook, how can I choose which worksheet opens?
  524. vlookupand #na
  525. reference multiple tabs
  526. how to freez more five columns without splitting the panes?
  527. Gathering Data from Option Buttons
  528. matching
  529. Need Formula! Look for box selected and do certain function
  530. Conditional format lowercase
  531. IF formula
  532. Excel conditional sum
  533. proper way to nest AND & OR with IF?
  534. If - Then Formula
  535. How to add characters to all existing values in a given column
  536. HOW DO I BLOCK DUPLICATE NUMBERS IN EXCEL
  537. Drop Down Value & Length Dependent
  538. Calculate with codes and times
  539. How to convert Email into Mailto Email Addresses
  540. Ranking within in ranges
  541. Schedule help: formula based on 3 choices of data?
  542. Generate Report
  543. Is there a function Countif that operates like Sumif?
  544. Copying formulas from multiple worksheets
  545. Totaling the number of comma delimited numbers in a column
  546. Adding/Subtracting Dates & Times
  547. making subtotals and grandtotal from multiple pages excel2000
  548. Multiple Formulas in same cell
  549. Using sum with cells containing text
  550. Pivot Table - creating % of Totals
  551. Vlookup updates
  552. sort, 2 row header
  553. Unable to find values of SQRT(0)
  554. find exact values of SQRT
  555. If stmt and assigning a value to another cell
  556. why is "sum" displaying zero?
  557. Nested Vlookups
  558. Wildcard IF formula
  559. How to calculate "number of months" between two given date?
  560. Need help with multiple argument formula
  561. IF statement too long, need another way
  562. car loans
  563. How to prepare Multi Stock Valuation on Fifo Basis in Excel
  564. WEEKNUM
  565. PIVOT TABLE
  566. Linking sheets into one major sheet?
  567. Offset function help
  568. can someone translate this formula pls
  569. SUMPRODUCT Criteria Via Cell Reference??
  570. London Excel User Conference - July 19-21
  571. Matching multiple columns
  572. Multiple Subtotal levels in Excel 2003
  573. How to total rows in Excel with non-value cells like "included"?
  574. Changing Decimal to Hours
  575. Formula to add two cells when one or both cells are text
  576. GetPivotData need help
  577. Automated Popups
  578. vlookup returns last value in array
  579. Can anyone tell me what's wrong with this formula?
  580. get text from another worksheet
  581. Look up to return a true/false value
  582. Re: Look up to return a true/false value
  583. copying a reference
  584. PHONE NUMBER formatting
  585. Formula doesn't update when rows are inserted
  586. RE: get text from another worksheet
  587. Rounding to a specific value (up or down)
  588. Vlookup Displays Blank
  589. Adding columns in Pivot Table having coomon description
  590. OFFSET function returning #VALUE when using external references
  591. deleting line item in import function causes REF# error
  592. lookup with more then one codition
  593. How do I anchor a cell/create absolute ref. while clicking on it?
  594. How do you set up the data to perform a Anova 2 Factor/w reps?
  595. An "If" statement coded in a macro
  596. columns on worksheet2 don't sort with worksheet1
  597. Validating non-blank cells in workbook
  598. Conditional page break if merged rows won't fit on the page.
  599. How to extract multiple cells based on one value
  600. Adding columns in Pivot Table having common description
  601. Combo boxes and formulas
  602. Multiple conditions in a formula
  603. Re: Deleting info from all cells at once
  604. How do I set up a formula for parts (or units) per hour?
  605. LINKING WORKSHEETS
  606. Choosing which sheet opens
  607. Can a linked hyperlink be updated
  608. count double occurences
  609. Address of Maximum value in Cell
  610. How to display two worksheets from the same workbook side-by-side
  611. Average range including blank cells: #DIV/0!
  612. extend my formula with increments of 4 cells
  613. time addition to predict finish time
  614. stumped ??
  615. Using Concatenate operator to overcome > 7 nested IF's
  616. Truncate words
  617. Formula w/negative no.s & Percentage
  618. Using Mode in Excel, need more than 1st most frequent number.
  619. Need Help with formula
  620. How to evaluate a 'dotted' number using formulae (not UDF)
  621. parsing text in a multiple column count
  622. get date with now() today() but dont update with recalc
  623. Need a function to convert value in its name
  624. Summing every other cell in a column?
  625. How do I speed up recalcs when using lots of SUMPRODUCT formulas
  626. Password
  627. Arrange numbers in a sequence
  628. Which formula should I use?
  629. How to make excell ignore non-whole numbers
  630. Make cells flash.
  631. Hiding Rows if Blank cell
  632. Sheet Names
  633. How to draw a circle in excel with specific radius
  634. Pop up windows in excel
  635. Intergrate data area in a function
  636. To get values into an array
  637. skip rows
  638. How do i populate a text box according to selection in combobox?
  639. How do I make out an invoice using Excel that has two pages
  640. need macro to check part# and sum
  641. formula to sort size
  642. Formula to return a value if any numbers in a group meet a criteri
  643. Import data into my workbook
  644. Count Names in One Col if 2nd Col Isn't Blank
  645. Compare one Column to a Second Column Formula Help Needed
  646. Highliting Duplicate Cells across multiple rows
  647. Need help with formula
  648. counting instances of specific times in fields with date and time
  649. How do I format to currency when number includes cents?
  650. Formula Help
  651. Copy a formula down a column
  652. Conditional Format Issue
  653. Formula for cells that contain a specific letter
  654. Convert Total Hours and Minutes to Whole Number
  655. If Statement???
  656. updating a spreadsheet in 1 field w/ out changing values in anoth
  657. How do I condense 3 columns into 1 in Excel?
  658. use the current row in a list to populate a report
  659. How do I make the true return a drop down list in the IF function?
  660. if "a" selected from dropdown menu then show "K" in other cell
  661. lookup single value in entire worksheet
  662. functions
  663. VLOOKUP works in some cells but not others.
  664. Merging data from Multiple Worksheets
  665. Can you print indicators when inserting a comment?
  666. Conditional Format - 3 conditions
  667. pivot table field list
  668. How do i calculate the total revenue in Excel?
  669. My Datedif function only returns 0's in the cell what's wrong?
  670. Nesting Networkdays function inside and If function
  671. Is there a way for Excel to create a task in Novell Groupwise
  672. Public Macro Help (CFColorindex)
  673. Can the "Date Picker" from Infopath be used in Excel?
  674. combining two lists
  675. Importing data into excel
  676. I NEED A FLEXIBLE FORMULA
  677. Ranking based on two columns
  678. Nest a referenced formula in excel
  679. Is there a way to post a file to show an example?
  680. Can you make a cell = 0 if original function is creating a"#ref!"?
  681. ADDRESS Function
  682. Is there a go to function in excell
  683. Duplicate listing
  684. sumproduct/countif function help
  685. Questionnaire sheet: Select "yes" or "no," and only one can be selected
  686. Can sumproduct do two {x,y,z} arguments?
  687. Vlookup Q
  688. Sum if 2 conditions are met
  689. Chart from different worksheets
  690. Count Unique Entries
  691. Stake calculator
  692. Convert text in cell to a range name for formula
  693. 2 column lookup - match to date range
  694. Formula for rounding a column of currency to a multiple
  695. Sumproduct Date clarification
  696. changing the year of a date
  697. formula link to a file
  698. how do I round numbers in .125 increments
  699. data entry in excel by linking to other word doc. or excel sheets
  700. Copying problem
  701. Can't get CUMPRINC to work. Have Installed Analysis Toolpak
  702. Excel Programming
  703. Lookup and compare rows
  704. Excel Programming
  705. How can I set up a milestone report with red/green/amber alerts
  706. Little help with weibull function needed
  707. Comparing and counting occurences in 2 columns
  708. seeking of array
  709. how do i use import to consolidate data from multiple sheets
  710. MSN Stock Quotes Excel plugin broken?
  711. Copy Mutiple worksheets to single Workbook
  712. Answers needed for challenging formula
  713. Formula too long - Shorter version?
  714. how can update the data in an excel workbook without opening it
  715. increasing and decreasing a value in a cell
  716. TRIMMEAN with different percentiles?
  717. SQL.REQUEST not working in EXCEL 2003
  718. Copy cells, preserve cell size
  719. need to ONLY display worksheets that have had recently changed
  720. Macro help
  721. Excel Formula or tool to compare two columns of data
  722. Data consolidation from Multiple Sheets
  723. copy data from various sheets into one sheet
  724. Viewing data in Excel while scrolling. Instead of the cell count?
  725. CountIF() in Worksheet B while referencing cells in Worksheet A
  726. order formulas are updated..
  727. Changing Text format in a function
  728. sumproduct question - kind of...
  729. Create number format for 4 digit integer preceded by zero
  730. Another time addition problem
  731. Insert Subtotal button
  732. VLOOKUP - 2 Questions
  733. count function help
  734. Lookup different sheets and get the value from the sheet specified
  735. Match/Index Returning #N/A
  736. Sum if need help
  737. address() function
  738. RE: CountIF() in Worksheet B while referencing cells in Worksheet A
  739. Screening one list for data
  740. Help with a function button within a cell
  741. cell format changes when formula copied?
  742. find and replace - replace data in rows to separated by commas
  743. why am I getting a #VALUE! error?
  744. Check for Duplicates
  745. Insert blank line macro
  746. percetile function limitation
  747. CountIf by Month-to-date
  748. Count If 3 Criteria Met
  749. INDEX and MATCH in one formula...
  750. Conditional formatting if value in cell is found in a named range
133