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