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