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