View Full Version : Microsoft Excel Worksheet Functions


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

  1. percetile function limitation
  2. CountIf by Month-to-date
  3. Count If 3 Criteria Met
  4. INDEX and MATCH in one formula...
  5. Conditional formatting if value in cell is found in a named range
  6. Find max number of character and return cell address
  7. Values not updating
  8. Prevent user changing pivot chart layout
  9. Excel formula
  10. How can I alter the rounding rules?
  11. assigning points to rankings
  12. lloking for an easier way to count
  13. Hide used names in drop downbox.
  14. accumulating values generated daily
  15. How to define table size
  16. Adding percentage as interest to a total
  17. Filter arrows freezing!
  18. ranking with some blank spaces
  19. hyperlink using cell contents
  20. how do I use the solver to solve polynomial equations?
  21. running total from the same field on multiple sheets as i add she
  22. Mortgage calculation after a large extra payment
  23. Help! With SUMPRODUCT
  24. How do I get the largest number in a sheet to stand out on it own
  25. end result
  26. test a range of cells and return an adjacent value
  27. Relative & Absoulate both Vertical & Horizontal
  28. Deleting formula in data validation list
  29. template timer stopwatch
  30. Change source ofr edit link is greyed out
  31. Auto sum
  32. testing. do not open.
  33. How do I type this so excel recognizes it?
  34. using worksheet name
  35. exponentials
  36. How to obtain both std dev and std error mean in each y error bar
  37. Adding or combining time problem.
  38. Need a loud/bright warning before making changes.
  39. Can I use IF function in calculated fields in a pivot table?
  40. Protected worksheet with unprotected cells i.c.w. remarks
  41. How to equalise loans by ditributing funds
  42. Countif using the same cell on every sheet
  43. anti logarithm function for base 10
  44. Nested Ifs
  45. Parse data where break is a first uppercase character in a string?
  46. Recording a high price on a worksheet
  47. Fill with zero
  48. Unable to paste a formula into other cells
  49. Tables, How do I make new info push existing info to the next row?
  50. loan payment
  51. Lookups
  52. Search a random array of cells and return a value of "X"
  53. Total width of several columns.
  54. Measure length of an AutoShape Line?
  55. days between 2 dates
  56. T-Account templates can be found where?
  57. Switching Subcategories into Categories and Vice Versa
  58. Drop down categories in Excel
  59. IF Command
  60. function to populate different cell
  61. Help needed with conditional formatting and adjacent text
  62. Establish formula for multiple logical_tests
  63. Changing date from =NOW() to Creation Date
  64. Pull information based on a range of numbers
  65. How can I add 3 years to date 03/05/2003
  66. Index and match among sheets
  67. excel conditional formating decimal fractions
  68. data from 1 sheet to the next
  69. Sorting two columns (again)
  70. Text manipulation
  71. drop down lists
  72. Text to columns
  73. IF Cell Contents Start with STRING
  74. Returning a sum when looking up two different values
  75. How to best monitor threads on this site
  76. list box
  77. Display missing Part Number if Column A does not match column B
  78. formula for matching text
  79. one criteria/mult. values
  80. How to create a New system function
  81. AND in an array function?
  82. VLookup Error in Part of a Named Range
  83. Calculate 2 Standard Deviations
  84. vlookup is returning a value one cell above the correct cell.
  85. How to pull cells from other worksheets including color/comments?
  86. converting a string of information into excel cells
  87. Returning value based on input data
  88. Sum & VLookup
  89. Dragging Conditional Formatting
  90. centre across selection shortcut
  91. Finding/removing duplicate names in a worksheet
  92. IF condition
  93. Rolling Forecast
  94. returning a cell name
  95. Which formula?
  96. Summing one column if two other columns' values appear in other sh
  97. Option Button - multiple selected
  98. How can I add additional rows beyond the 65,536 in excel 2003
  99. Counting dates, within a list of dates
  100. how do you setup a table
  101. Finding the date on the 'nth' Monday in this Month in this Year
  102. calculate the p-value for a negative t-value
  103. create pivot table with master/detail data from 2 worksheets
  104. look up a value
  105. Formula to figure bonus
  106. functions/formulas
  107. Is there a fluctuating payment loan amortization template in XL?
  108. Looking-up Columns w/calc'd Values ONLY to Calculate Average
  109. LOOKUP function not returning expected value - Using vector_lookup format
  110. Correct answers like a quiz
  111. how do i create a customised numbered list in excel
  112. what is the problem, when value comes up in the total column
  113. Excel User Conference - Registration winners
  114. Subsequence of characters
  115. external data function error-MS Query
  116. how do i use excel's natural log function with negative numbers?
  117. Calculating p-value from Fisher's Exact Test for XYZ parameters
  118. Conditional Concatenate
  119. How do you dedupe a list in excel with parameter?
  120. Sum Count of Numeric Criterion for LAST 5 Rows
  121. lists
  122. How paste text from note pad to excel w/o using (Text to column) f
  123. automatically updating summary worksheet
  124. Bug in days360 function
  125. Advanced Filter w/ multiple sheet List Range
  126. Excel Help Needed......
  127. Count Records Between A-K and L-Z
  128. Please help w/ nested IF that returns a #N/A.
  129. how do I fix my 'if' statement?
  130. Vlookup referencing one column that contains part numbers in both.
  131. In Excel is there a function to change a cell's background color?
  132. Lookup in data from external datasource
  133. How do I delete extra blank pages from an excel worksheet?
  134. how can i change my sprdsht to list info from colums into rows
  135. how to catch the second or more cell with vlookup
  136. Carrying a balance forward
  137. Excel should have row column highlight indicator
  138. Excel file window won't open
  139. how do I paste without EXCEL increasing the cell number ?
  140. SUMPRODUCT
  141. Return a formula as text string to a cell
  142. transposing question...
  143. vlookup range changes
  144. in excel, can i set varying CELL widths that are in same column?
  145. Fix Simple #Div/0! error
  146. How can I create a link between cells in two separate Excel sheet
  147. Link worksheets
  148. How do I calculate the midpoint date between two dates.
  149. create links to check boxes marked "good" fair"and "bad"
  150. Excel should have unhide all worksheets selection or button.
  151. Can you ID a cell that has both Alpha AND Numeric characters?
  152. CREATE AN "IF' STATEMENT FOR CHOICES OF CHECK BOXES
  153. format cells for color
  154. Data Validation and named lists
  155. Contional Formatting - other cells
  156. text fields in pivot tables
  157. auto correct numbers with dates
  158. Counting values lower then the median.
  159. Lookup from one spreadsheet that links to matching keys in another
  160. How do I compare two values to calculate a total?
  161. Count data based on past dates
  162. Copying Data to next available empty cell in cloum
  163. Conditionals
  164. Updating links from one worksheet to another worksheet
  165. COUNTA for a cell with a formula
  166. How do I use conditional formatting to hilite weekend dates where.
  167. import txt create sheet name
  168. Re: Using a formula on cells containing results of formula – How?
  169. adding days correctly
  170. How to set the row for title to be fixed during scrolling?
  171. Sumif Command
  172. how to make formula
  173. simplify equation
  174. Function Needed! Please Help!
  175. Need help setting up a spreadsheet of some sorts.
  176. i have two days and i want the difference in days, months, year
  177. Custom functions calculating time arguments Help Desperate
  178. Re: Update Spreadsheets
  179. Concatenate two columns?
  180. minus sign
  181. VBA
  182. saved worksheet opens in new with macro error report
  183. Column picked randomly with probability relative to number of entr
  184. Where's the plain old database functionality?
  185. comments issue
  186. countif non blank cells + dates overdue
  187. Sum and Divide Formula error
  188. Copy Row based on a condition
  189. Use MOD?
  190. Keeping formulas on running total and sorts
  191. how do i lookup the value of the next cell excluding the first lookedupresult
  192. LIST DATES IN MONTH ORDER
  193. Workbooks
  194. cond format
  195. bring up list
  196. How do I format a cell so that I can only input a Y or an N
  197. lookup function
  198. Excel functions which support arrays (SHIFT-CNTRL-ENTER)?
  199. How do I count cells that contain one of several specific numbers?
  200. How do I exchange cell information; simply swap locations?
  201. Sort
  202. how do I compare two dates?
  203. school project ..please help
  204. EXcel Capture Data into one cell
  205. school project ..please help
  206. automatic calculations
  207. Excel
  208. lookup function
  209. How to trim spaces from entered text in cell using exisiting functions?
  210. SumIf
  211. Multiple Vlookups & IF statments
  212. Vlookup while pulling a cell color and comment
  213. Calculating Dates Using Different Values for NETWORKDAYS
  214. Excel: Find repeated items and be able to delete quickly, option.
  215. Need Excel Formula/Function to color cell interior
  216. conditional formatting issue
  217. How do I combine data from several sheets into one main sheet?
  218. Drop down lists and vlookup? or Match?
  219. Fractional Workday Function
  220. True or false
  221. SUM a named range
  222. IF function
  223. How can you sort a worksheet which has embedded lists?
  224. VLookup?????
  225. "NOW" or "TODAY" date function
  226. Data alchemy
  227. Using FIND function to locate space between first and last name
  228. Re: find nearest help
  229. How can I subtotal a row that gives me =SUM(Q3:X3)
  230. excel storing previous cell values in memory
  231. Hiding sheet in a workbook
  232. check boxes in the forms tool bar
  233. can someone explain function 'ara'?
  234. How do I sum totals from mulitple worksheets
  235. Why doesn't this nested IF statement work?
  236. Is there a macro or function to convert values to it written text
  237. Merge Rows depending on value of the first column
  238. Inoperative merge function
  239. How do you add a blank line automatically after the Subtotal line
  240. Combining worksheets on a unique key column
  241. Countif time is between two nominated times
  242. link with date to data worksheet
  243. What does the 0 in the formula 'Yr 3 Op'!G2,0 mean?
  244. How to create menu for listed names?
  245. Automatic filtering and coping result to a seperate sheet
  246. Summarizing data on one main sheet
  247. Check 2 different list get associated value from a column
  248. option buttons
  249. AutoFilter list problem
  250. vlookup function addressing
  251. Referencing sheet1 from sheet2
  252. How do I open worksheets in different screens, like Word??
  253. How to set a formula to convert the time zone
  254. linking data to a form
  255. Expanding on a formula
  256. How to find duplicate data in two tables,then listing it?(Excel)
  257. Value depends on comination of 2 columns
  258. Disabling an 'on load' macro
  259. How to find duplicate data in two tables,then listing it?
  260. how do i get the equal sign on my formula bar in excel
  261. Counting unique values with criteria
  262. Setting Conditional Formatting
  263. Circular:G4?
  264. VLookUp function to return multiple rows
  265. Deleting Row Macro
  266. time data as number
  267. how do i create form of yes/no answers for mass e-mail sending
  268. workbook code
  269. Lookup a value between two numbers
  270. Combining IF OR and AND functions
  271. Is this possible with a macro?
  272. How do I stop cell borders dissappearing when pasting data?
  273. What
  274. Issues copying excel charts to word documents - using Excel VBA
  275. What function/formula should I use?
  276. Conditionsl Formatting
  277. write a "if" command. day of month + remainder
  278. number rounding
  279. If, then formula to capture data?
  280. Want to change current prices in a column by a percentage
  281. vlookup
  282. vlookup with linked cell references
  283. Change fmt of a cell if number matches any in a range of cells?
  284. If function
  285. Data transfer from a template to a workbook
  286. how can you put a background in certain cells
  287. Msgbox experts please reply..
  288. Re: Combine Cells
  289. Function - counting based on criteria
  290. how do I display number in thousands; i.e diplay 123,500 as 124?
  291. Vlookup and hyperlinks
  292. In Excel - how to delete new window created from window on tool ba
  293. Re: Average Non-Adjacent Cells in Budget Spreadsheet
  294. Average Non-Adjacent Cells in Budget Spreadsheet
  295. Summing specific cells on two worksheets
  296. Median Formula In Pivot Table
  297. Help for a newbie... please
  298. How do I format a formula to recognize multiple comparison factors
  299. Template Wizard/Excel as database
  300. Multiple worksheets within a workbook
  301. Formula for determining if two date columns fall within specific date range
  302. Insert a imge to a single cell
  303. how to create a sorted summary list of counted species
  304. Index not Reurn the correct Result
  305. Worksheet button to send as attachment
  306. Pivot Table Formatting
  307. Letters and Number formulas
  308. Importing information from 2 workbooks into a 3rd one
  309. How do I stop VLOOKUP from asking what spreadsheet to look in?
  310. passing excel certification
  311. > but < subtotal (3,...) or countif
  312. Pivot needs BOTH cur/cum totals w/out extra cum cols/repeat lines
  313. IF statement problem
  314. Excel Tips
  315. Calculations
  316. Excel formula to move certain fields
  317. transposing an array converts dates into numbers
  318. How do I create a formula where a cell is automatically shaded ?
  319. Re: Combine Cells
  320. Suggestion to add Auto Filter option for columns
  321. WEEKDAY Function?
  322. Re: Counting text strings
  323. How to stop a general format cell
  324. funtion to determine the fraction portion of a number?
  325. Macros?
  326. Monthly NPV
  327. automatically making a copy of a sheet
  328. automatically making a copy of a sheet
  329. Comments box position
  330. How would i setup a breakdown method for my business?
  331. Spreadsheet formula question!
  332. Criteria Range at two different places
  333. DFunction + Print Preview = Slowdown ???
  334. Count items when specific text and date criteria are met
  335. RE: Edit and Array
  336. Can someone help with this complex formula?
  337. Pivot Table Row ?Grouping? Question
  338. how do i enter a formula in excel that will change a cell value
  339. how do you add up alpha???
  340. List from a table
  341. Anyone actually get Case statement to work ... ?
  342. Please help with a 3d formula.
  343. hyperlink to sheet in formula, can't save under new filename
  344. Need help find automate way to cross reference two GAINT excel databases!!
  345. Semi Annual Counter
  346. Years of Service Calculation
  347. conditional sum formula
  348. Working with dates
  349. If Sum Countif Function
  350. How do I convert a list of data into mailing labels?
  351. Sumif between values
  352. thin # of samples by averaging
  353. problems with vlookup
  354. INDIRECT Function
  355. Can I use the IF Function?
  356. Countif Problem
  357. Lookup and List Results
  358. Another "working with dates ?"
  359. Unable to break links
  360. Fuction that gives number of days of a given month
  361. filtering
  362. Excel Data not showing up in Query
  363. how many calculations?
  364. can you use the match formula to look for two different values?
  365. how do i retrieve overwritten Excel file
  366. Tricky comparing question
  367. Cost times amount (if populated)
  368. Average outage time?
  369. same data from one cell copy to multiple sheets
  370. Data Query will not Refresh automatically
  371. Copyin text only...not borders or shading
  372. sumif across multiple sheets
  373. Need a count
  374. how do i get excel on my loptop
  375. calculation to ignore a 0 (zero) value
  376. How do I create a tip calculator chart?
  377. if function
  378. if function
  379. Please Help...
  380. When I SaveAs, the hour glass does not go away, nothing happens
  381. How to extract value from a different file?
  382. can i prevent duplications in cells
  383. Re: Uppercase
  384. Selectively Clearing cell contents
  385. Multi-Column Dynamic Named Range...Is there an easier way?
  386. VLOOKUP Returns Erroneous Value When Control Data is Variable
  387. Lookup function not doing the job Help please
  388. FIFA World Cup 2006 Office Pool
  389. How to create a 'dynamic' formula?
  390. Could any one Explain this Formula
  391. how can I add a picture into protected worksheet?
  392. Inserting new rows
  393. How do I copy only values of cells when they are enterd?
  394. engineering functions
  395. rolling average
  396. referring entire page
  397. sumproduct doesn't work
  398. If function
  399. Auto calculate for date + days forward to yield new date
  400. Conditional Formatting Q
  401. Using the answer IF "true" in another formula?
  402. Zero Values in Charts
  403. Dialog box with worksheet information
  404. Add items to context menu
  405. Change hrs&minutes into mins
  406. merge 2 spreadsheets info to 1
  407. can we convert "2 days 16 hrs" to " 64hrs" using excel functions
  408. Deriving mathematical equations
  409. Simultaneously updating Charts in Multiple sheets
  410. copy value of cell from last entry in column
  411. I want any date 90 days or older from current date change color
  412. Auto Filter with Protected Worksheet
  413. Insert new row in 2 worksheets
  414. Oooh, I guarantee you are going to have fun with this one.
  415. Dont include in sum if cell contains this value
  416. shortcut key to move to beginning of new row
  417. Transferring contents and color of cell
  418. inserting a space in a number
  419. Chop off parts of the statement
  420. Take fraction out of the figure
  421. Formula not Return Required Answer Q
  422. Fill in Date problem
  423. Transfer only information under todays date
  424. Transfer data relevent to date
  425. Invalid Formula with the use of Indirect
  426. retrieving old messages from this newsgroup
  427. How do I get a combo box to calculate percentages in Excel?
  428. Formula to look for value in a row depending on unknown value?
  429. I want data to show in the cell only when the info is inserted
  430. Conditional Formatting
  431. lookup value and return result in column to left
  432. Excel Coding Error!
  433. Splitting firstName from Surname
  434. Removing The N/A from showing in open fields
  435. Change font/cell color by Formula
  436. Do I need a macro or just a function?
  437. need formula advice
  438. Excel sheet scroll bar options
  439. Timesheet
  440. Normal Text in Formula
  441. counting problems
  442. how can i recover an old saved spreadsheet
  443. Need difference between two dates/times in hours
  444. Excel - filtering, sorting?
  445. How to use a very big formula
  446. Last non-blank cell in a row?
  447. Combining Pivot Table Source Data
  448. Speed up calculation of a worksheet that contains formula
  449. HOW TO PREPARE SUMMARY OF DIFFERENT ITEMS IN ANOTHER WORKSHEET?
  450. Trendline
  451. Index? Match? Function to sort and return value fr diff column in
  452. to compare sales plan vs actuals from two different worksheets?
  453. Displaying pivot table detail
  454. Create a conditional formula to replace
  455. Querying 2 Excel files
  456. Remove content of last visited pages in "Insert Hyperlink" dialog
  457. Round near to Zero
  458. Analyze with Excel from Access
  459. Use VLookup for range of cells, but with a twist
  460. How do I add (=Sum) the same cell for multiple sheets (103)
  461. How do I print a filename at the end of the file (not every page)
  462. VLookup across Workbooks?
  463. SumIf Help
  464. Excel Workbook Problem
  465. How can I use spell checking in a protected worksheet?
  466. Fillable form loses fillable fields when emailed - how do I fix
  467. Another zero question
  468. Vlookup "Value Not Available" (#N/A) Error
  469. how can I make this work? =LOOKUP(A2,{any number},{5,6,7,10})
  470. Format a cell to recognize data and change font colors accordingly
  471. ranking over a sum
  472. Variable worksheet name
  473. creating checkboxes from forms tool bar
  474. Multiple If/Or Statements
  475. If/Then Forumla to create blank cell???
  476. keeping a running time for tv program
  477. Numbers of boxes of fruit to buy
  478. How My If Or Statements
  479. Moving from unlocked cells to unlocked cells in an excel form
  480. 1st Monday of a month in date range??
  481. Formula Will Not Evaluate
  482. Correct Format for formula
  483. Why does formula show rather than results (not in text format)
  484. Comparing against first non-blank cell
  485. weeknum for month
  486. Data Validation - Drop Down
  487. Need how-to or example for data consolidation
  488. Excel and Word
  489. Re: replace "." with "/"
  490. CountIF columnH2-H101 the number of time between ages 20-29 occurs
  491. Vlookup Function Arguments are correct but nothing in cell
  492. Formula help!!
  493. Formula question
  494. best and worst outcomes
  495. Count Non-Blank Rows
  496. Formula for % of "yes" in range of cells?
  497. Filtered Cell Question
  498. what happened to =networkdays(a1,a2) in office 2003?
  499. Arrangement problems.
  500. And,if,true Help
  501. Excel "mode" function returns different results based on sort orde
  502. Taking age group Ie ages 20-29 and picking out net sales for group
  503. "IF,THEN, DO) any help
  504. Formula HELP!!
  505. Hyperlinks
  506. Number of character in one cell.
  507. Can excel alphabetize a list of names?
  508. SUMPRODUCT vs. COUNTIF -- Why does one work?
  509. 'null reference' when trying to use WorksheetFunction from C#
  510. Sorting a Worksheet using Capital letters
  511. if then /lookup function
  512. What does ! do in an Excel formula
  513. struggling with index/match
  514. HOW TO CREATE DIFFERENT GROUP AND OUTLINE IN EXCEL
  515. How do I apply color in cells ..color now shown only in print prev
  516. Formula help needed
  517. what is the formula to convert time (3:46) to total seconds?
  518. Summing all BUT one...
  519. logical test, array, text and numbers
  520. Data and the "IF" formula
  521. Filter function
  522. Hyperlink
  523. VLOOKUP? Or another function?
  524. Use Vlookup to find less than today
  525. vlookup in excel have alternative result than #N/A selectable
  526. Countif, two criterias need help
  527. How to combine milliseconds with date/time reference and display?
  528. multi conditional searching
  529. Counting cells if special criterias are true
  530. convert military time to regular hours
  531. Workbook protection
  532. How do I write a formula to convert numbers to written text?
  533. Problem with VLookUp Function
  534. Text to value
  535. how to locate local excel expert
  536. auto numbering macro
  537. day of the week dates
  538. Quickbooks exports to Excel, cleaning up the mess afterwards
  539. How do I sum data in worksheet 1 to be placed in worksheet 2?
  540. Finding 13 character codes in text strings
  541. min function
  542. How can I create a customer database to use with an invoice?
  543. perform calculations using time arguments
  544. How to find a row since I found a value in a column? see example
  545. Excel formula?
  546. Average data with date and if constraints
  547. How do I use vlookup with two lookup values?
  548. Random Matching
  549. If(and(function help)
  550. Convert data into proper time format
  551. How do I perform a concatenate?
  552. Lower case
  553. How to create a constant total column in Excel?
  554. How do pivot table source fields automatically create tabs
  555. Count # days
  556. INDIRECT !@%?
  557. show the sum of an arbitary selection of cells
  558. i have to add cells evenly spaced, eg a1 + a11+a21+...+a991
  559. SUMIF Question
  560. more help with min
  561. SUMIF((U:U,"ITEM#")AND(A:A,>4/01/06 AND <6/31/06),V:V)
  562. Hide previously used items from multiple drop lists
  563. Excel needs to be able to cascade in multiple windows like word!
  564. How do I create a Macro to sort data and insert blank rows & subto
  565. How can i protect...
  566. Adding columns of times
  567. How can user move in locked worksheet but not copy cell contents?
  568. INDIRECT function
  569. How do you divide two cells in a pivot table to equal a %?
  570. excel payments functions
  571. Help with SUMIF formula Please
  572. Data depiction/transpose and retain formulas
  573. deleted work sheets - Excel
  574. Formatting cells in Excel does not work
  575. Setting up columns based on a date
  576. autosort
  577. Copy formula
  578. Optimal material layout
  579. Copying links
  580. Divide selected cells by 1000
  581. Option Button Help PLEASE!!
  582. I need a formula in excel
  583. writing a greater than/less than formula
  584. how do i link merged cells to a merged cell in another worksheet.
  585. Why is the scroll bar way too big for my document?
  586. Calculations Based on Format
  587. can you tell me how to embed a pic for paint into an excel cell
  588. what function best to use
  589. Excel help (time and 1/2)
  590. macros
  591. generate a random number and use if function to generate new data
  592. Code to get text from part of a cell
  593. Creating shapes from given criteria
  594. sheet line bottom of page missing
  595. A letter to generat a number when entered into anywhere on the spr
  596. How to know Rank Of FieldName ??
  597. Date Question
  598. Matching and calculating 2 worksheets
  599. Function THat wIll Add COntents Acorss Worksheets
  600. Insert Excel hyperlink to word document
  601. How to perform 2SLS with excel
  602. How can I move several columns of words into one column in Excel?
  603. Looking up text...
  604. Searching for codes in text strings
  605. Another Conditional format question
  606. Increase with condition
  607. increase number with 1%
  608. MMULt Worksheet Function
  609. Increase excel worksheet vlaues by a percentage
  610. my password quit working in an excel workbook, help!
  611. How do I save a custom footer to use in other worksheets
  612. How do I define a range using values in cells?
  613. Need to convert date to "day of the week only"
  614. Formula
  615. chart wizard
  616. validating
  617. data
  618. How do I dsiplay changes in my cell
  619. Matching a value that appears multiple times
  620. I am doing a calculation in excel, I am multiplying a figure by a
  621. CANT USE MY FAST KEYS EG CRTL+` TO FIND FORMULAS
  622. How do I display negative time values in excell?
  623. how to change figure to words
  624. CONCATENATE Cells Formated as fractions
  625. Replace ^ in web query result
  626. Automatically updating a formula
  627. maximum number from a text range
  628. MEDIAN, STDEV of a range IF another range = specific value
  629. Where can I go to learn how to create excel formulas?
  630. problem with ISNA and VLOOKUP
  631. Can someone help with this formula?
  632. CSV file
  633. excel, automatic date and time when info gets entered
  634. Subtotal
  635. Worksheet_Change - NEW to VBA
  636. Remove empty cells from named list / validation list
  637. INDEX / MATCH with SUMIF/COUNTIF/SUMPRODUCT Statements?
  638. If error function
  639. How to addthe last cell in the last column across multiple workshe
  640. Combine and sort
  641. Finding, Replacing and Cut & Paste
  642. Displaying unique entries from a filtered list
  643. Dollar Ranges
  644. How do I make a "Worksheet_Change event" to show any changes to cells?
  645. Using Vlookup in a string search of a cell
  646. why don't my totals change when I enter additional data?
  647. datevalue()
  648. Counting dates greater than a certain time period
  649. Paste and Paste Special command are not enabled in Excel
  650. IF formula
  651. Big Sumif
  652. hyperlink
  653. how to display numbers in thousands i.e display 10,000 as 10
  654. Creating Formulas
  655. select cell value based on value in adjacent cell
  656. Clear History
  657. creating formula
  658. one step update
  659. Find Numeric Criterion in Column & Return the Numeric Value from Row above
  660. adding name values
  661. Count Unique Values
  662. aps3 calculate diff in time and cinvert into another format
  663. VLOOKUP
  664. formula between worksheets
  665. vlookup and a function field input
  666. VLOOKUP Issue
  667. we need to make it print one copy, not three
  668. Data Tables
  669. Proctecting certain cells
  670. Muliple formulas
  671. Links not updating in shared workbook
  672. Convert column to row
  673. average
  674. Filtering Data with Rank Function
  675. Re: how to convert single digit to month name
  676. Average
  677. auto recover - can this be set on a Global basis?
  678. HOW TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER?
  679. Match, Find?
  680. Complicated Question
  681. Counting dates in a RANGE (yargh!) :)
  682. What function would move a closed record to another worksheet?
  683. average function
  684. Need help calculating formulars
  685. Improved Excel functions curve fitting in sheet
  686. Return blank cell if 'find' statement not true
  687. Moving data between sheets using buttons
  688. Sorting of References for Formulas
  689. How do I convert Numeral to text
  690. Can I auto insert a worksheet when I insert a value in a cell.
  691. How to give function by cell color to sum two value in Excel
  692. automatically insert formula when new rows are inserted
  693. Need help on counting text within certain criteria
  694. filtering unique data
  695. Extract data from one worksheet
  696. Forumula help using Countif
  697. How do I solve the error this #VALUE! error
  698. countif
  699. Calculating Current Age from DOB
  700. Dynamically set a range?
  701. Two pivot tables on the same worksheet? I need help...
  702. IF protection then skip sub.
  703. Worksheet - Quote log
  704. Hyperlink- relative reference
  705. Averaging Text vs. Numbers
  706. countif = < > AND value in adjacent columns match criteria
  707. Graphing Normal Distribution Functions
  708. How can I play a .WAV file in Excel if a condition is met?
  709. How do I use the "if" and "round" function in the same formula ?
  710. How do I add multiple conditions to a formula?
  711. How do you run a Macro from an IF statement in Excel 2000?
  712. add Trend Line to Pivot Table Chart
  713. excel quotes
  714. Settiing up spellcheck in a protected Excel document
  715. Track changes
  716. Unable To OPen Excel 2003
  717. CONCATENATE TWO DIFFERENT CELLS
  718. Excel copying with link cells
  719. Can I use more complex logical expression for sumif as creteria?
  720. How can I invert a column's contents
  721. count a number range and a letter in a cell
  722. Match - Exact - Lookup?
  723. Date calculation
  724. If Question
  725. Find minimum value greater than a particular value
  726. Summing lookup values
  727. How to display a numeric field showing all 5 characters.
  728. VLOOKUP not working anymore
  729. How do I make a compound function?
  730. Submit Button
  731. Will the COUNTIF function work with auto-filtering?
  732. Split Profits to different partners based on hurdle rates
  733. COUNTIF using # ranges, and referencing 2 other columns
  734. Need a Formula
  735. sumif #value
  736. Ask for password after certain date?
  737. My Excel formala is not returning the correct value
  738. formula to count cells containing #'s in a specific range
  739. Help! [Group] in the caption and I can't use auto filter anymore.
  740. worksheet help
  741. Coverting text to numeric
  742. How do I set up a formula using same field in pivot table?
  743. Pop-up/hyperlink in a cell
  744. How do I bold just the totals when using Subtotals?
  745. How do I create a certain equation in Excel spreadsheet?
  746. How do I sort columns with IF formulas in them?
  747. IF formula for 13 plus variables
  748. Using Rank with If
  749. SUMPRODUCT formula returning #VALUE! error
  750. Inserting check boxes
133