PDA

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 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160

  1. Compile list of same cell from multiple worksheets
  2. Multiple Substitutes
  3. LOOKUP command
  4. Sum of Range of Cells
  5. What does @SUM mean?
  6. Enable Macros
  7. Exclude certain cells from printing.
  8. Conditional format of minimum number
  9. HYPERLINK IF referencing the cell of the function..
  10. Using MATCH() for an exclusive find?
  11. What does a $ in an excel formula do?
  12. Excel-Master
  13. Date Formula
  14. excel help
  15. COUNTIF - multiple conditions
  16. List of property names and values for a given object.
  17. SUMPRODUCT Acting Quirky
  18. creating and moving hyperlinks - Please help!!!!
  19. Automating Worksheet Names
  20. Return employee name when the employee's number is entered
  21. transfer information from one worksheet to another using a butto.
  22. Vlookup function question
  23. Macro Template File
  24. Custom menu
  25. lookup help
  26. Excel Solver violates constraints
  27. Help With HLOOK
  28. 'CHECK IF A CELL IN EXCEL HAS ANY TEXT IN IT'
  29. VLOOKUP on separate file: Works fine for a while....
  30. A bit of a Stumper
  31. Macro Help - Copying and appending data
  32. Collapsable Rows?
  33. How do I increment a formula?
  34. changing cell colors with formula
  35. Formula to determine whether number falls within range??
  36. Separate address column to Five columns
  37. Permutation in excel
  38. Rational exansion of a decimal number
  39. COUNTIF With Non-Continuous Cells
  40. Time Sheet to show hours owed
  41. Protecting Cells
  42. Permutation in excel
  43. Some help needed
  44. Percentage formula's
  45. Software to create color coded maps from excel?
  46. Finding Duplicates
  47. multiple pivot ranges
  48. need 360-day loan amortization excel spreadsheet template
  49. Rolling Balance after 30 days
  50. Re: Find function
  51. Need date to appear 90 days later than initial date entered
  52. Creating Scenarios and Scenario Manager
  53. freeze content
  54. Validation from Database (not sorted)
  55. How do you update links
  56. filters logics
  57. INDIRECT FUNCTION jams?
  58. Countif function
  59. Find function
  60. use if function to change cell color
  61. create an array with unique items IN MEMORY
  62. dynamic connections in excel?
  63. random combination of letters
  64. Counting with Array Formula
  65. How to find MATCH numbers ?
  66. fill handle + query
  67. Can I get excel to auto save details from a cell into the doc nam.
  68. multiply the value of a cell
  69. How can I get rid this value "#VALUE!" in the cell
  70. Excel formulas
  71. Worksheet terminology
  72. how can i change the row from 123 to ABC
  73. If Then Statement in Excel
  74. Excel, Need some help
  75. Copy and paste from one spreadsheet to another
  76. Vlookup to find Second INstance
  77. blank cells
  78. Max Lookup formula
  79. Need to find 200 students from column of 1000
  80. Format a cell for hours ' minutes "
  81. Can Excel send alerts when due dates are not met?
  82. How to identify entries in a matrix also present in another list
  83. help locating first empty cell in a Column
  84. HOW DO I SELECT ROUND NUMBERS ONLY IN EXCEL SPREADSHEET
  85. Indirect function - Limitations
  86. Please help....
  87. In excel, how can I create a towards column in a single box?
  88. A calendar calculator template that reflects remaing weeks in a ye
  89. Formulas not recalculating when values change on another sheet
  90. Counting number of occurrences
  91. Autofilter - can I increase the drop down font
  92. Cell value & hyperlink
  93. Another IF question
  94. How did excel get de-installed? Got error mssg: CiceroUIWndFrame
  95. I can't delete columns - help!
  96. Macros for the AR Aging Workbook template?
  97. converting number string to number with decimal
  98. Auto populating fields
  99. Re: Help
  100. lookup returns row number-why?
  101. The number of hours in a day cannot exceed 24...
  102. Allow unprotected cells to spell check after sheet is protected
  103. Summing on multiple conditions
  104. Sumproduct question
  105. Re: IF statement
  106. Moving Around a Blank Spreadsheet
  107. IF statement
  108. If Or?
  109. Using Sumif with 2 conditions
  110. Locating Last Nonzero Cell in a Row
  111. Populating several cells
  112. Limits of MINV matrix function
  113. Problems with an IF statement
  114. Ranked list
  115. HELP - Date Range In 1 Cell Calculation
  116. Downloading documents
  117. concatenate strings
  118. How can I use like a mail merge feature in excel to create a form
  119. How do you calculate CAGR In Excel 2003 with no initial cost?
  120. count unique phrases in a word table or spreadsheet
  121. Columns
  122. counting comments
  123. Average based on Hour
  124. Compare Side by Side in Office XP Excel
  125. lookup based on a row number
  126. select lines from multiple worksheets and write to new worksheet
  127. Hiding a row if date is filled
  128. Help to adapt Formula syntax to work with Visible Filtered Cells
  129. How generate trendline equations for Power, Exp and Log trendlines
  130. how to get rid of #N/A
  131. combining data
  132. Conditional Formatting
  133. Date Creation in Cell
  134. COUNTIF or not to COUNTIF on a range in another sheet
  135. how could I import a text file with comma separated values into ex
  136. how to use input formula from several worksheets in excel?
  137. combining 2 pieces of text from 2 columns
  138. Formula error in merged cells
  139. data validation list should have opt. to select based on criteria
  140. Print only cells with values
  141. Linkage data between two spreadsheet
  142. How do you add a-z (alphabetically) to your toolbar in micr works
  143. Make boxes apear on paper?
  144. output based on data in a graph
  145. Page Header
  146. Search feature in workbook
  147. Getting the first 3 digits out of 6 digit cells?
  148. Can't get list in Document Contents for workwheet
  149. drop-down list validation won't allow a different worksheet
  150. options under tools dose not come up
  151. Formula Assistance Required
  152. How do I define "contains' as the default custom filter?
  153. how do i get this
  154. Finding DUplicate Data set in Worksheets
  155. Locking a table
  156. Formula to determine number of Standard Deviations based on % of population
  157. Opening multiple Excel files that contain varied selected sheets
  158. What is wrong on the fomular: Offset(MIN(A1:A10),,-1)?
  159. Sales League table
  160. Comparing Two Spreadsheets
  161. Locking cells after one answer
  162. Re: Help with formula please...
  163. Help with formula
  164. calculating number of months from today
  165. countif
  166. Date functions
  167. how do I keep the dropdown list button visible continuously
  168. Excel 2003 Subtotals not working correctly
  169. Using countif with 2 conditions
  170. Can I use Excel to create this text file?
  171. Locking format
  172. ranking
  173. Re: Help with formula please...
  174. Re: Couple of hopefully easy questions
  175. Value of a Cell by Time
  176. Forecasting weekday occupancy between two years
  177. matching numbers in col a and col b
  178. Preceding a number by zeros, that is still a number
  179. using linest to generate 3rd order polynomial coefficients
  180. looping through a set of calculations
  181. I cannot convert using HEX2DEC formula? i need a plug in i think?
  182. Calculating Month Average Exch Rate from Exchange Rates Calendar!!!
  183. Adding Cells
  184. drop_down_box
  185. What is the shortcut key for adding $ to a cell reference eg $c$3
  186. =max(range includes #N/As)
  187. Changing positive figures to minus figures
  188. Optimizing mortage payback
  189. How do I get it to insert addresses instead of Next Record?
  190. When I move a vertical border it deletes horizontal borders
  191. add a column only if 5 other cells on the row satisfy criteria
  192. Vlookup Headache
  193. search value in a table and sum another column
  194. one formula to make a multiplication table work
  195. having a two tables on the same page with different widths
  196. Filtering Columns to Align Matching Data
  197. How do I count a value if another field = a specific value? Excel
  198. tab scrolling buttons not responding
  199. tab scrolling buttons
  200. Very Frustrating - Please Help!
  201. Converting CSV files into Excel files
  202. I Need Help with complex formula ?
  203. Avoiding #NUM!
  204. freeze other columns when columns have been frozen already
  205. dynamic defined ranges
  206. Vlookup for data contained in a cell
  207. Excel chart problem
  208. mixed font styles in the output of a formula?
  209. Sorting Identical Data set in a work sheet
  210. Need to compare 2 tables to generate 3rd table
  211. Need to get rid of blank rows without sort
  212. Need help summing time
  213. Cell references
  214. HELP ASAP get rid of blank rows without sort
  215. RE: Cell references
  216. formatting dates
  217. Creation of a Generic Macro
  218. RE: Cell references
  219. RE: Excel chart problem
  220. Please Help and Thank you!
  221. Matching data using date criteria...
  222. finding name within range
  223. Re: Conditionl Format
  224. Re: Conditionl Format
  225. Word Associated Shading or Color
  226. numbers
  227. Calculating two numbers in one cell
  228. vlookup over 2 sheets?
  229. Dates Not Formatting as Dates
  230. lookup cell content in multiple files
  231. Retuning a column number for a specific value
  232. trouble shoot pointing to a cell
  233. How do I change where Excel looks for templates?
  234. tab scrolling buttons - excel 2003
  235. is there a "distinct" function native to Excel
  236. Can excel sort entire rows of data like access?
  237. Lookup question.
  238. Help One Way did not work
  239. SHORT CUT KEY(S) TO SHOW OR HIDE SEETS IN EXCEL
  240. Conditional Formatting that will display conditional data
  241. formula change
  242. Multiple If Statements
  243. Adding numbers in a single cell
  244. HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES
  245. Look up problem
  246. European date formats
  247. Comparing ranges and deleting
  248. extract data Column 1 starting with A1, A4, A7, A10, etc.
  249. Macro
  250. *HELP NOW PLEASE*
  251. How do I split a cell of 2 words into two cells
  252. Re: Count "how many in a row"
  253. how do i find # hrs & mins. between 2 different dates and times
  254. Contains instead of Equal
  255. Help Needed Urgently
  256. Connect columns, with restrictions
  257. Count "how many in a row"
  258. Re: Count "how many in a row"
  259. Adding time Values up in Excel
  260. format column for unique values only
  261. move from one column to another after a set condition
  262. How do I stop Excel from treating blank cells as zero?
  263. Make a formula that adds every 4th cell in a column indefinately?
  264. Copy and paste from 1 workbook to another
  265. Display "Last updated date" for the Workbook (without using a macr
  266. What is the spreadsheet function in excel
  267. Non-random numbers generated by excel's data analysis random gener
  268. Counting cells
  269. Subtotal results without word "Total"
  270. how do i calculate time in & out in excel using a formula
  271. Frequency of values with Criteria
  272. If typed 12805 then 12/8/05
  273. link help
  274. How do I sort entire spread sheet. Names w/data
  275. linked cell is displaying formula instead of the data
  276. Your online office "help" system REALLY sucks!! I'm not kidding!!
  277. vlookup almost does this but not completely...
  278. Delete repeated Cells
  279. #Value error when linking workbooks
  280. 2 different Companys. Data Sort
  281. Information from column to row
  282. finding if name within range
  283. Contents of cell
  284. error N/A
  285. Lookup
  286. organizing a workbook
  287. using getpivotdata function
  288. vlookup reverts to data from a previous report
  289. Functions not "recalculating" when input changes ???
  290. Merge & Center function is turned off...how do I turn it back on?
  291. using a checkbox for a conditional function
  292. Copy Cell Referecnces
  293. Text from Max value
  294. How do I randomize ascending data (number values) in excel?
  295. I want to add automaticaly my postponed check in my banking regis.
  296. Multiple coin flips in a single cell
  297. Sumproduct not working when summing values between two numbers
  298. Prevent Worksheet Deletions
  299. Pivot Table - 'Merge Labels' option and formatting
  300. Reformat IF(ISERROR(....) : if 1st option returns empty, look at 2nd option.
  301. Shared files
  302. How do I reconcile bank statements?
  303. How many std deviations is Excel function "STDEVP"
  304. Locate and retrivie data in table/matrix
  305. attendance sheet
  306. Frequency within date range
  307. File won't open. Error message "too many different cell formats"
  308. Pulling data from another workbook
  309. Format single column cells to be 6 characters long
  310. Pivot Table Question
  311. Use functions when cells are merged
  312. Select one of many clipboard item to paste into document
  313. using filters with the sum function
  314. how to format only a specific character or number in each cell withina range of cells
  315. Delete Rows where cells does not meet criteria
  316. How do I quickly fill a formula result into a column of cells?
  317. printing problems
  318. DATEIF Name error
  319. Arrays
  320. can you filter more than two items in excel 2000
  321. Workbook & multiple spreadsheets
  322. Pivot tables and total count
  323. =CONCATENATE() help!
  324. conditional formatting autoshapes
  325. Help with Formulas
  326. NOT UNDERSTANDING THE FORMULA
  327. Fill handle formula
  328. Pivot tables - calculated fields
  329. Trying to freeze panes. line down and through middle of worksheet.
  330. Showing Garbagge in my File.
  331. Interpolation using GROWTH function?
  332. Fill down to nonblank rows
  333. creating function (vba) with range arguments
  334. Protection-exceptions to delete a row
  335. Copy & Paste macro
  336. Summing specific cells!
  337. Subtraction formula for consecutive cells in a column, skipping blanks
  338. Auto number invoices in Excel
  339. XIRR function not defined?
  340. Excel sheet question
  341. 1430 to 2:30pm
  342. SUMIF problem...
  343. Average Function Help Needed
  344. =(A6)!$O$14 - why won't this look for same name sheet as A6?
  345. Summing accross sheets
  346. is there a percent error function in excel?
  347. removing year from date
  348. Put comments on a locked spreadsheet even though cells not locked
  349. if function
  350. Splitting Character String
  351. Remove apostrophe
  352. Need help with formulas
  353. Dro pdown list formulas
  354. halves
  355. Excel formula for monthly interest rates
  356. Referencing worksheets
  357. Smart tags for financial symbols
  358. Re: If
  359. Re: If
  360. Re: If
  361. How do I create a weekly series?
  362. Compare two lists with two variables
  363. return a cell contents as the result of usiing "small"
  364. if statement problem
  365. Need Help Writing a Formula
  366. Delete repeated numbers in Excel
  367. delete repeated numbers
  368. comparing two columns & then perform a calculation
  369. Sort from lowest to highest
  370. Excel should have a tan^-1 Cos^-1 and sin^-1
  371. display minutes and seconds in excel
  372. Re: ifsum slows down calculations
  373. How can I count values greater than and less than certain values?
  374. Apply cell shading based on adjacent cells in EXCEL
  375. EXCEL: IF CELL B6 RED, HOW DO I GET A "W" (ie for win)to show up
  376. serial number cell
  377. Find and Concatenate
  378. Range of data within a column
  379. Another Nesting IF Statement Problem
  380. Pivot table grouping of dates in row fields will not work. Why?
  381. Formula Help with Lists
  382. nesting if statements
  383. Summing only those cells that aren't hidden
  384. Random Numbers
  385. preserve "-" when importing text field from access
  386. SUMIF excel function not working
  387. How do you convert embedded drop-down lists in Excel '97?
  388. How to replace a word with a word from other column?
  389. counting unique values and matching to quantities
  390. What formula would I use to get -2 / -2 = -100%
  391. linear interpolation function in excel
  392. How to record macro to print pages modified today
  393. Controlling text in an Excel worksheet
  394. Concatenate and Vlookup
  395. Don't know what to call what I need?
  396. Re: can you entre a bar code into a excel cell?
  397. Help with conditional format
  398. Type in letter return word
  399. Please assist
  400. Linking cells
  401. Function
  402. Count cells with condition
  403. Is it possible to put 2 splits on one page? If so... How?
  404. Using dates in formulas
  405. My DCOUNTA formula results do not display in Excel.
  406. keep date format in a Combo box
  407. Fill-in empty cells from SAP report
  408. automatically insert row at each page break
  409. Conditional Average
  410. VBA Custom function for lookup
  411. % change in the last two cells in a row
  412. 27 sets of data. Need to find zero in each set
  413. Help writing an Excel Formula
  414. converting a number to English text ( not to Baht) is needed
  415. Count the number of Cells in one ROW with conditions
  416. How Show decimal in Bar Function
  417. How to pluck out initials of a 2 or 3 word name
  418. Count occurances Problem
  419. Div/0 error
  420. NOT UNDERSTANDING THE FORMULA
  421. return left most part of cell
  422. Index question
  423. Excel should let me sort by colour
  424. How can I get excel to look up prices in a table
  425. Conditional Formatting Reference / Inserting Rows
  426. special sum formula
  427. Evaluating Rank to determine formula
  428. commission spreadsheet
  429. IF Function??
  430. Evaluating results of a concatenate formula, as a formula
  431. Sumproduct.................
  432. Determining a specific time during the day
  433. Regression Statistics are returned as Rounded to 1 vs. several dec
  434. Close excel do not save
  435. Check box, then add current time to cell
  436. text function
  437. How do I calculate a future date in excel?
  438. delete spaces
  439. Using offset more than once on the same sheet
  440. format social security number
  441. Counting occurences of a substring in a range of cells.
  442. Complicated formula
  443. Compare two different size lists
  444. if function multiple variables
  445. Unhiding multiple worksheets in Excel 2000
  446. cut and paste subtotal from excel
  447. creating a excel spread sheet using ffinancial functions
  448. Looking for experience with counting and conditions in excel 2003
  449. Re: Using COUNTIF for Counting Words?
  450. countif OR function
  451. VBA function for "Mean" using Array as argument
  452. How do you sum just values that are bold in a list of values?
  453. separate text into different cells
  454. Refer new sheet to previous sheet
  455. How do I select on two variables in a range of data in excel
  456. FITTING HEADER ON SECOND PAGE TO PRINT
  457. how to return mulitple corresponding values
  458. Warning - "Fixed objects will move"
  459. Repeat calculations
  460. Fair Play
  461. Calculation of full hours
  462. Function for decreasing salary by 2.5%
  463. Count cells with specific values in the cells next to them?
  464. How can we see two different excel sheets on one screen?
  465. Can a UDF be used on an array of cells?
  466. Help with a Date Formula
  467. calculate payment with first payment due date variable?
  468. Counting .5 in a pivot table
  469. Count or result of matching cells
  470. Experienced any problems with nested subtotals using Windows XP
  471. List box, copy multiple Cells
  472. Moveing Data to another Worksheet
  473. How do I prevent a formula element from incrementing when copying
  474. How to highlight an Excel row by clicking on a cell
  475. Select different source data for a PivotTable
  476. How do I prompt a user to update a cell value (ie the date)?
  477. return cell reference from any column
  478. ... Count, <<< Positive Values minus Negative Values >>> ...
  479. Filtering data and replace on to an new worksheet
  480. networkdays
  481. Formulas not updating until save
  482. countif - Criterion1 OR [Criterion2 AND Criterion3]
  483. Format of CSV File in export
  484. Macro help!
  485. Weeknum & Year
  486. Insert manual line break in formula
  487. Extract each item in the list
  488. Any function for Crop/Cut Text
  489. Percent of total in Pivot tables
  490. INDEX and workbooks
  491. VLOOKUP in SUMPRODUCT array
  492. #Name? Error when using NETWORKDAYS function ......
  493. Colour (color) problems
  494. Vlookup
  495. Counting Occurrence of Text within Text in Cells in Range.
  496. How do I convert a given number into a letter?
  497. What do I need to do here please.
  498. problems with macros
  499. Asking for Formula ~ Thanks!
  500. Verifying Dates
  501. Translate WEEKNUM result into a date
  502. Getting Yahoo Stock Quotes by a USer Defined Function
  503. MODE isn't working properly.
  504. Financial Calculation Help Needed -- Annunity
  505. combine the two into a single formula please
  506. Sumproduct + Array Function?
  507. Help on Networkdays
  508. ok for the first but I would like the first 2 Left please.
  509. ok for the first but I would like the first 2 Left please.
  510. ok for the first but I would like the first 2 Left please.
  511. Excel 2000 to 2003 update links doesn't work properly any suggest
  512. How can i italicize a word via a formula?
  513. Count Occurances if two conditions true
  514. Convert Range name in cell for VLookup
  515. VLookup returns #VALUE!
  516. RE: Track changes across multiple worksheets
  517. Need Help: 'sheets' function with a variable in a formula
  518. countif >0, specific cells
  519. finding the right number
  520. Linking Columns and cells
  521. Problem with a "if" "then" situation.
  522. formula for finding a value!
  523. dates and if statement work on one sheet, not on another
  524. How do I use space provided for Company information
  525. How do I get custom views created in Excel 2K to show in Excel 200
  526. Dynamic Time Display
  527. Countif not blank
  528. Need help with lookup on text format
  529. ActiveX works in my spreadsheet but when sent to others, doesn't
  530. Counting cells that meet 2 differnet criteria
  531. Functions not "recalculating" when input changes ???
  532. Formula for rounding to the nearst eighth of one percent
  533. Excel Font Effects should include Upper Case
  534. Re: function for finding a value!
  535. Sorting by text colour
  536. Excel: Format Control: 'cell link' reamins constant. How to copy
  537. Creating Macro or Code Help?
  538. Sunrise / Sunset
  539. Import Data
  540. Formatting cells is not retained when saved as csv file
  541. Need assistance with printing macro
  542. Sorting Data
  543. Can we have custom Column headers instead of default
  544. Annual interest rate
  545. running balance in excel
  546. How do I find a name in a list of names?
  547. How can I get the domain name out a email adress?
  548. what is the formula to change 08/14/51 into 1951?
  549. Count occurances in range of cells
  550. How do I use VLOOKUP to find values across more than 1 sheet or Wo
  551. How do I keep with column widths of a pivot table when I refresh
  552. VLookup on two criteria - Not two dimensional
  553. excel function help
  554. sum using reference from other worksheet
  555. Lookup function, need help
  556. Automated file name retrieval and updates
  557. Analysis ToolPak Translator
  558. in a line of three possible answers how to prevent multiple answer
  559. excel files into money 2005
  560. How do I retrieve a date in a column of dates which > my criteria
  561. Return to individual sheets
  562. Linking total amounts
  563. sum and variable rows
  564. Disabling protected cell selection
  565. Formula which is greater tahn or equal to zero
  566. Create a single sheet from many sheets
  567. Comparing dates
  568. Can a conditional formula indicate "date added" next to a text?
  569. Vlookup Calculation Issue
  570. Cenvert dollar amount into words
  571. no formula results in cell
  572. I need a template for my supply inventory
  573. Auto convert an alphanumeric string (CIS9638S) to numbers only?
  574. RE: Auto convert an alphanumeric string (CIS9638S) to numbers only?
  575. Arithmetical Mode Value for Filtered cells in Multiple Adjacent columns
  576. If column c # is 101..then column e is $14.32 & column g is $8.00
  577. How do I calculate and show negative time in Excel?
  578. RE: Auto convert an alphanumeric string (CIS9638S) to numbers only?
  579. roundup within a formula
  580. RE: roundup within a formula
  581. i need help with a calculation formula...
  582. Sort with a List
  583. Excel 2003 - Copy Cell Reference
  584. Multiple Item Replace???
  585. How do I show negative number in brackets using excel?
  586. Add money to a sum
  587. Data Entry
  588. How to add equal values and than replace them with their sum?
  589. Formula with current Date
  590. Re: Date format
  591. Copy a cell value and add literals
  592. Multi - Level Question involving Data Mapping and Formulation
  593. Identifying Dups in different ranges
  594. Count IF problem
  595. Need to find a row in a worksheet based on the value of a cell
  596. Statistical functions query
  597. Function to ignore decimals
  598. Creating Worksheet Using Server Object
  599. If statements
  600. Transposing Data
  601. Creating Worksheet using Server Object
  602. I want to make three sub colums under an original colum
  603. How do I copy a function with a called cell constant?
  604. SUMIF FUNCTION?
  605. VLOOKUP for Zip Code Ranges
  606. Formula
  607. Is the IRR calculation based on cash flows at beginning of year?
  608. Conditional Formatting
  609. Can I show a formula's result on a worksheet tab?
  610. Ladder Help
  611. change case in excel
  612. Using boolean function for color fill
  613. Re: Truncating text before a hyphen
  614. Truncating text before a hyphen
  615. Formulas and worksheet linking
  616. IF Command conditional formating
  617. find position of a number in a string
  618. League Tables
  619. What Function to use?
  620. Require alpha-numeric entry
  621. How to share a workbook to our staffs
  622. Solution Required to prevent #Ref! when rows deleted
  623. Re: Function or number depending on input
  624. Discount rate - what to use?
  625. Filtrera Pivottabell
  626. IF formula?
  627. Calculate Date range
  628. Adding and Naming Multiple Worksheets
  629. Subtracting a Countif result from a constant
  630. Multiple Regression in Excel 2002 SP3 (Office XP)?
  631. Cell Separation
  632. Separate Column Sorting
  633. how to convert numeric into alphabet
  634. to convert Minutes into Day:Hr:min (not as fraction)
  635. box formatting
  636. how to add or subtract from two cells into one
  637. Returning the formula in another cell
  638. Exporting multiple cell contents into word document
  639. Box-Jenkins techniques & Time Series
  640. Formula to duplicate data to second sheet
  641. How can we get more columns on a spreadsheet, like 365 days/colmn
  642. I only want to print the horizontal lines in a spreadsheet
  643. conditional sum formula
  644. Re: Change to formulae
  645. Re: using text as a cell ref
  646. Option Button Help
  647. Solver, macros Excel
  648. How do I protect only formulas(functions) in a workbook?
  649. Format of one cell conditional on another
  650. Excel worksheets
  651. First part of "IF" function returns false even if true. ??
  652. Check for double entries in a row
  653. Re: Help with a Ladder
  654. Re: calculate numbers based on font color?
  655. How to change a series of positive numbers to negative numbers
  656. Sum function based on format
  657. RE: date function
  658. Re: date function
  659. Conditional sum
  660. Counting a Filtered Dataset
  661. Re: How many users can sucessfully use a shared excel workbook?
  662. Re: Colomn of strings, how to count each string with "abc" OR "def"
  663. Re: Trying to pull date from field getting error.
  664. Re: Function or number depending on input
  665. Re: Conditional Formatting
  666. spellnumber function
  667. I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN 2 DATE RANGES
  668. Pls Help!
  669. Asking for formula~thanks!
  670. Increase figures in cells by a percentage (on entire workbook)
  671. average of kth largest numbers in an array of n numbers
  672. formula's in cells are not calculating
  673. how do i create range names ?
  674. Coloring certain cells
  675. Nested "if" not returning expected value
  676. Excel Idiot Needs Formula Help!!
  677. How to get the complete list Excel Worksheet Functions
  678. Complicated Index Match Offset function
  679. Hide #DIV/0!
  680. HOW DO WE SET A FORMULA TO FIGURE A YEAR TO DATE TOTAL ??
  681. HOW DO WE SET A FORMULA TO FIGURE A YEAR TO DATE TOTAL ??
  682. Using Name as Worksheet Reference
  683. How can I have excel sort through a data string of dates?
  684. Formula problem
  685. HELP-Can not type on Spreadsheet
  686. I cannot change spreadsheet to rewritable
  687. Carrying formatting automatically to new W/S
  688. Need help with Vlookup
  689. FORMULA BAR OF SPREAD SHEET
  690. Different results from AVG funtion
  691. Novice Needs Help with Formulas
  692. References and links.
  693. monthly total
  694. adding formula to existing database
  695. lookup finding the next value that is GREATER
  696. Hyperlink.
  697. In Excel Sheet any digit repeat
  698. filter 400 names from list 1 from list 2 with 4000 names
  699. students grades, formulae to calculate what grade is needed based.
  700. auto fill a number
  701. Re: calculate the number of words in a row whose length is greater than 2
  702. IF function with 14 nested levels
  703. list 1 has 400 names List 2 has 4000. find manes from list 1 on 2
  704. find names on list 1 in list 2. list 1 4000 names list 2 400 name
  705. AND/OR FUNCTIONS
  706. how do i add 1 year to a date formatted cell?
  707. SUBTOTAL(9,range) Does NOT work in AutoFilter
  708. calculate the number of words in a row whose length is greater than 2
  709. Column formating help!
  710. Set value for a cell basd on another cells value using an incremen
  711. type 020104 and get 02/01/04
  712. Need help with automating functions
  713. List
  714. calculating positive and negative formulas
  715. How do I copy a new module to 200 workbooks with a macro?
  716. How do I add cells from sheet to sheet?
  717. How do I start Excel Footer on 2nd page?
  718. grayed out options
  719. advanced filtering in XLS
  720. Creating a nested COUNTIF????
  721. COUNTIF for a partial value
  722. How do I change the range?
  723. find then sort formula
  724. Change percentages to numbers
  725. can conditional formulas be used in or with pivot tables
  726. How do I fix my arrow keys? They are no longer moving cell to cel.
  727. How do I change a blank ("") value to a cell with no value?
  728. Help PLEASE! Not sure what answer is: Match? Index? Other?
  729. Running Count
  730. How do I count cells that have are highlighted a certain color?
  731. Can I use HEX2DEC with cell references vs. numbers?
  732. check if worksheet exists
  733. Sum column if multiple criteria are met in adjacent cells
  734. I need help quick! Formula
  735. How can I use the NOW function and keep it from auto updating?
  736. help with excel
  737. reference to sheets without using sheet names
  738. Drawing a line in Excel 2003
  739. A list of Consecutive Integers, can I search for missing integers
  740. HOW DO I CHANGE ABSENCE TEMPLATE 2005, TO 2006
  741. Automatically date cell in Excel
  742. AutoFill w/formulas
  743. Excel toolbar commands
  744. Interesting Workbook formula problem
  745. edit across mult. wkbooks
  746. VLOOKUP seems correct, still getting #N/A
  747. function
  748. date functions for previous 60/90/180 days
  749. SUMIF?
  750. Unable to read File