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. Formula for running total
  2. Conditional End Date in Data Validation Settings
  3. Calculating a tiered 401k Match
  4. Formula to return an answer using a calculation
  5. Could someone tell me the difference in these formulas?
  6. Help with Formula
  7. "If this, multiply by this" type of equation
  8. Count dates for previous month
  9. File size xls
  10. Moving up / down in a macro
  11. Help with IF
  12. Adding Products
  13. Sharing Data by Keyword
  14. What function?
  15. How do I set repeating text for a specific cell.
  16. multiple sumif formula
  17. For Niek Otten and Toppers custom function calculating time
  18. Negative Values
  19. copying data to different Cells
  20. Trying to do a auto number generater
  21. Function to lookup largest value
  22. Formula has to take Monday if due date falls on a Sunday
  23. Counting Formula
  24. Need Help With A Formula Please
  25. Specifiying the worksheet name in a cell
  26. Range Name affecting speed of macro
  27. Help with a formula
  28. Function INDIRECT
  29. How do I see the formula calculation used in Excel functions box
  30. Pivot table
  31. HELP!!!! on formula PLEASE!!!!!!!!!!!!
  32. Using SumProduct and Count To Calculate % Ranks
  33. averaging & ???
  34. Re: speech recognition
  35. How do I round to the nearest 5?
  36. I WANT DATA TO LINK WITH OTHER WORKBOOKS ACORDING TO CELL CONTENT.
  37. Sumproduct based on Date range
  38. Need Help: Summing Multiple Criteria
  39. How to get the Excel to calculate the exact date from a given date
  40. Pivot Table Row Formatting
  41. links in Excel
  42. Excel 2003 sum figures without formula
  43. Listing data without blank rows
  44. BIN2HEX function will convert '511', but not '512'
  45. Conditional Formatting based on Upper case
  46. Activating a Checkbox
  47. EASY: Format NOW as mm/dd/yyyy
  48. Values In Links Not Being Saved
  49. "Mail Recepient" feature does not work!! Why?
  50. Gathering Data from various tabs
  51. Splitting one column into multiple columns
  52. Format for degrees
  53. Run a macro automatically at a certain time
  54. Help with AVERAGE function
  55. Values from website turned into useable number values
  56. Protection of identical cells on multiple worksheets
  57. Stop a List Box from resizing
  58. need help with lookup function
  59. Excel Formula
  60. MAX Function not returning correct value
  61. Where to find complex matrix math add-ins for Excel 2003?
  62. Inserting new employees
  63. Excel: Using DSUM, I need to evaluate 2 criteria that are not toge
  64. The team who designed Excel insert cut cells was a genius
  65. how to use a variable for the criteria in a sumif function?
  66. Can I use more than three conditions for conditional formating?
  67. Can search by cell format like fill color?
  68. IF function for blank cell
  69. How do I compare string values in one column to another column?
  70. I cannot find Invoice toolbar
  71. help on match function
  72. macro
  73. data change color automatically
  74. Reply for Macropod
  75. Macros in a cell function
  76. Degrees Minutes Seconds
  77. Sort info
  78. How do I associate word cells to equations?
  79. Excel formula to calculate % gain when adding cash equity to accou
  80. average price
  81. Down arrow moves cursor to top of worksheet when sheet protected
  82. Sort a column automatically
  83. Go To last blank cell
  84. Floating CommandButton
  85. counif greater or less than
  86. Calculate the Days
  87. "Empty" values in holiday parameter for NETWORKDAYS() function
  88. running macros from IF
  89. Securing A Workbook For Individual Distribution
  90. Comparing two spreadsheets
  91. Help needed on Date formulas
  92. how do I convert cell 'Street,#' to '# Street' these are addresse
  93. Help with prompting Replace Screen
  94. How do I invert text (abc-->cba)
  95. Probabilty - Binomial - a simulation game?
  96. storing data
  97. Delete row by time/date?
  98. How do I enter a blank, not "", into a cell with a conditional for
  99. #NUM errors when calculating IRR
  100. Dynamic Ranges--Multiple TableData??
  101. IF function for multiple answers?
  102. min and if
  103. Excel IF Function
  104. partial/absolute text match
  105. Add and Subtract functions
  106. I've never seen this symbol before
  107. can't delete worksheet--grayed out!
  108. Why does paging down skip ten rows?
  109. Mind Gone Blank!!
  110. Can this be done using Sumproduct?
  111. Find name in list and get dept # enter dept # on work sheet
  112. use concatenate function to put carrage returns in a text string
  113. Count across worksheets with two criteria
  114. formating inputbox result in excel
  115. spread sheets vlookup
  116. Pivot Tables-2 Questions
  117. sales data how i can list weekly,monthly yearly etc..etc...
  118. function to fill all days of month to end of month
  119. UK Excel User Conference - July 19-21
  120. Restrictions On Merged Cells?
  121. Auto Fill/Sequential Numbering
  122. Certificate of Deposit calculator
  123. update a cell by one, trying to count a survey a quick way
  124. Sum if or sum product?
  125. Using Morefunc - Indirect.Ext when Offline
  126. Need to keep some info from formulas, but then change the formula
  127. Lookup Help
  128. Ignoring text and errors with Sumproduct
  129. IF statement does not work with "=" sign
  130. Problems comparing data from multiple blank cells
  131. Help with matching formula
  132. Are there any inventory forms that change quantities as needed?
  133. formula auto input
  134. How do I allow for multiple values in VLOOKUP?
  135. Function that will automatically display the User Name?
  136. Using ISNA with OR
  137. Find first numer in a Column
  138. Is there a way to link Auto Filter values to a Cell
  139. How do I program the cells in Excel to add, subtract, etc?
  140. help to open excel file
  141. VLOOKUP PullDown Menus Connected
  142. lbs ounces grams
  143. Easy question for you all
  144. Can I make certain cells required?
  145. Can insert W/S but not copy a worksheet
  146. Fill the column with the last number
  147. Running total that stays with changes
  148. if statement does not work with = sign
  149. Separte columns for neg/pos values
  150. Delete rows with duplicate values
  151. If formula to test several conditions
  152. Print Preview is normal, but numbers do not print, just narrative
  153. excel random sample with criterion
  154. out of rows
  155. Automatically adding cells from one worksheet to another
  156. sum minutes
  157. create cell formula for...
  158. Converting text from rows to columns
  159. Use Excel to make a complex IF function.
  160. delete row
  161. select list by selecting a cell
  162. How can I find/unhide hidden excel sheet tabs on a worksheet?
  163. return value in adjacent cell different workbook
  164. Each rows last cell text value could be in any columns.
  165. Unlock for Viewing
  166. Count if two columns match different criteria
  167. what formula is used to find lowest value within cells
  168. how to get last two rows??
  169. Hi all i need some help on excel transpose
  170. database over 1 worksheet
  171. Offset formula on different worksheet
  172. Can I formulaically set a cell to blank (non-Text, no value)?
  173. Cell by cell transpose
  174. multiply with - if text
  175. Finding the highest value from two columns of data
  176. Vlookup
  177. Excel - Change cell display limitations
  178. when I enter 12.50 in a column, it automatically changes to 13?
  179. Problems with a Lookup formula
  180. sorting worksheets based on a cell value
  181. Intersection, union and difference
  182. Adding sub-menus and actions to data in drop down lists in Excel 2
  183. using logic values
  184. Formula needed
  185. Combining a Vlook up with and If then statement
  186. Cannot insert row
  187. i know this is simple, but driving me nuts - formula
  188. Is it possible to run Solver using a macro?
  189. Indexing/Polulating Rows
  190. Percentage function needed
  191. graphing a range
  192. Help with date formula
  193. VLOOKUP
  194. Formula for year in school? Freshman, Sophmore
  195. How do I count the number of words in a cell?
  196. How to: average annual growth
  197. How to: average annual growth
  198. Writing Fast VBA UDFs - London july19/20
  199. Pivot Table help
  200. a few questions
  201. HLookup, IF statement, multiple sort, somehow combine all of these
  202. Creating an invoice from other worksheets
  203. Re: a few questions
  204. average of highest 48 of 52 radom numbers with duplicate low #'s
  205. Function to add different values
  206. Arrange Worksheets Alpha.
  207. Rank Function and Number that are close together
  208. Generating a repeating list of names from an ever changing roster.
  209. Problem with MID (any text) Command
  210. Formula Returning "FALSE"
  211. Does Excel 2003 have Avrami equation built-in or available?
  212. Automatic cell Formating ina VLookup formula
  213. Comparing two spreadsheets part 2
  214. Sumproduct (Range unknown, needs Search)
  215. Want to use trend() and linest() but some cells are empty, #N/A, o
  216. How do I retrieve info. from one worksheet for another in Excel?
  217. Formula Partially Works, Please Help
  218. Can't figure it out . . .
  219. Add flexibility to Criteria of DFunctions
  220. Formula fails in text formatted cell
  221. complex function
  222. Lookup function experts.. I need ascending and decending lookups of a series of data.. can you help me sort this out
  223. conditional formating for blank.
  224. The ispmt function is providing unexpected results
  225. Weighted Average Using Row Number
  226. lookup/left
  227. where text wraps in a cell, how can the row height be auto set?
  228. Sum 3 highest numbers
  229. Can I delete an entire row if condition is not met?
  230. Adding in a cell from one sheet to another
  231. sizing the Excel spreadsheet correctly on the screen
  232. "Create a drop-down list from a range of cells"
  233. CAN I FORMAT A ROW TO IMITATE A CONDITIONAL CELL?
  234. Help with cell colour
  235. Advanced formula - Return result & Show Cell Reference of result
  236. Breakdown
  237. Displaying formulae changes formatting
  238. Excel spreadsheet
  239. How can I randomize digits in Excell?
  240. SUMIF boolean?
  241. drop down box
  242. Looking in one col, counting in another. OFFSET?INDEX? Help!!
  243. vlookup must return a value that is greater than
  244. manipulate data
  245. IF and AND statement
  246. AGAIN... I need another Lookup Function to extract some data
  247. Cell sizing in a Vlookup formula to fit information.
  248. Compare two Sheets and copy value
  249. numbering pages
  250. saving a text file to excel
  251. Tried HLookup, IF statement, but I need something more....
  252. How do I change font colour in an if command?
  253. how can i tell if i have ented the same numbers twice in a column
  254. Control box
  255. conditional cell format based on cell in same row, previous column
  256. Excel buttons to print out on pdf file and printer!!
  257. HOW DO I COPY & PASTE A SMALL INFO FM AN XL TO THE CELL COMMENT
  258. autofill worksheet references?
  259. Custom number formats
  260. Working with range of numbers in a cell and searching same
  261. Determine years betwen 2 dates
  262. custom number formats
  263. Determining Date X based on Other dates
  264. INDIRECT.EXT Help Required
  265. Last number in Column
  266. Tabbing from Cell to cell
  267. Counting Cells with certain date ranges as values
  268. Excel Formula
  269. If one cell isnumber, and another has text,..
  270. Hi Dudes, Take a Look, I did it
  271. Hi Dudes, Take a Look, I did it
  272. Hi Dudes, Take a Look, I did it
  273. retain formatting when concatenating
  274. Selection Change - Data Sub Totals?
  275. rearrange text
  276. When I convert a date to a weekday, Sunday becomes Thursday?
  277. pPMT malfunction
  278. Match with or without "S" ending
  279. different passwords for each worksheets
  280. different passwords for each worksheets
  281. 64k row limit
  282. A kind of auto-filter question...
  283. Sheet-to-sheet auto-entries of text
  284. multiple ranks in one list
  285. One Sumproduct Formula works - while other returns #VALUE!?
  286. sort a cell that was highlighted by conditional formating?
  287. Automatic Calculating % for a row of numers of the total vaule
  288. Cell Formating in VLookup formula
  289. Payment in Advance/Arrears
  290. Importing Data - Macro or Script
  291. What would change the numbers of my rows to blue?
  292. prompting Replace window
  293. Excel Booklet Protection Question
  294. Calculated Field in Pivot Table
  295. Can this be done using an array formula ?
  296. IF function
  297. Data And Group Outline
  298. Excel: Allow combination of formula answer and text in one cell
  299. how to i pivot a table using various criteria
  300. SEARCH function help
  301. Calculate gross profit based on varying percentages
  302. count from several worksheets
  303. how to remove #DIV/0!
  304. Movement of cursor
  305. protect the worksheet
  306. function help
  307. Lotus to Excell
  308. convert "15000" to "Fifteen thousand" in excel cell?
  309. how do i create funciton values_entered in excel
  310. INDIRECT.EXT
  311. Wrong Week number
  312. text to columns
  313. Detecting Numbers in a cell
  314. User Defined Functions
  315. FORMULA
  316. calling variable within string
  317. HORISONTAL AND VERTICAL AREA IN SUMPRODUCT
  318. Help! importing data from other worksheets...
  319. time now
  320. excel subtotal funtion how do you get the result in bold type?
  321. Graph
  322. total cells with text and number EX: GS-5
  323. How do I convert a # into a time format in Excel, Ex.845 to 8:45
  324. Sorting
  325. array formula tutorial
  326. Need Conditional Formula
  327. Postcodes
  328. Need Help w/ VLookup Formatting
  329. Pivot Table
  330. Dealing with range of numbers in a cell
  331. sumproduct and transpose
  332. How can I update a graph with autofiltered data?
  333. Splitting a concatenated string into separate rows...
  334. countif / sumif function error
  335. averageif
  336. Number rows in a dynamic range
  337. Drop-down menus to store different data
  338. I need a productif style function
  339. array formulas disabled?
  340. How to set number of characters within a cell in Excel 2003?
  341. How do you know which function to use for a calculation?
  342. SumProduct Formula Help
  343. if I already have a Spredsheet, but I wanna add more,How?
  344. Daily Variance
  345. Need help in removing auto scroll cursor from excel
  346. Best way to copy time sensitive data to a column
  347. More elegant way to do IF ()
  348. how do i find unique avg buy prices in multiple group of buys/sell
  349. Use IF function to automatic run macro
  350. Validation Tool in Excel
  351. How do I list the most recent occrence of a purchase order?
  352. Formulas
  353. Help with date formula
  354. Displaying Percentiles
  355. Count the number of unique Numbers in a column
  356. how can I see/save a last cell value in excel?
  357. Find two values in worksheet to return one value
  358. vlookup
  359. Display values set in a range??
  360. Is it possible to add footnotes (not footers) in Excel?
  361. Can I stop Excel from seeing more than 2 digits after decimal?
  362. Tab feature no longer working on worksheet
  363. extracting numbers within text string!
  364. Pasting in visible cells only
  365. Re: Sum of Hours/mins
  366. Payroll spreadsheet function help
  367. Deleting and shifting cells and columns
  368. Conditional formatting specific phrase
  369. How can I automatically add an area code to a number in a cell?
  370. what is "source evaluates to an error"
  371. Cell Word Alphabetization
  372. Compare alpha and numeric values within a range
  373. microsoft office excel cannot paste the data
  374. Combining IF statements
  375. Size Limits
  376. Way to display filtered results from more than one autofilter per
  377. Calculate dates
  378. DO NOT Insert Row - Macro
  379. is there a way to get a cuberoot function in Excell?
  380. Special Vlookup?
  381. File Names
  382. Shaded every second row Please
  383. Have DGET return Null instead of #Value!
  384. what is CA
  385. Paste to Another Application
  386. xlDialogFormulaReplace
  387. Zero values: some on and some off
  388. Difference in two times over days
  389. Finding the closest number in column A and take the value in column B
  390. Offset to different worksheet problem
  391. formula compund rate of growth
  392. System Error
  393. formula
  394. fx duration
  395. Extending the worksheet beyond the 'IV' cell
  396. changing a cell to changing the link
  397. need help with a vlookup but returning a particular match?
  398. URGENT help with calculating time Thx
  399. MGRS to Lat/Long
  400. Transferring Information
  401. how we can use spellnumber() function in a new worksheet / file?
  402. Percentage score formula
  403. Combo box?
  404. How do I restrict entry into a cell to only alpha/numeric?
  405. using sheet-variable in function
  406. Multiple Variable Count problem
  407. excel- want to format cell formula to the file name
  408. Update should be done in different excel file
  409. Pulling from a table to make a timeline
  410. where is Sales Invoice Template?
  411. Need to exclude certain cells in a range
  412. Financial Stmt rounding issues
  413. lost option to insert comment, need it back?
  414. how do you turn an email address list into an Excel csv or txt file?
  415. How can I link from an external website to a particular worksheet
  416. Pivot Table counts instead of data
  417. CountIf trouble
  418. #N/A
  419. Automatic numbering of spreadsheets
  420. Summarize employee attendance data on a weekly basis
  421. How do I automate a majority rules?
  422. Pulling info from Goldmine into a spread sheet
  423. #N/A
  424. excel 2007
  425. Look up - i think
  426. how can I do more than 3 condition formats?
  427. How do I extract an Excel Chart as a graphics file?
  428. help me
  429. Limiting the range of AutoFilter?
  430. date formula assistance req'd
  431. RE: averageif function
  432. Re: averageif function
  433. How to turn off the popup warning when clicking on a hyperlink
  434. cost control templates
  435. 30-yr Amortization allowing 26 payments per year/780 lines vs 360
  436. formula help
  437. Merge Workbooks Grayed Out
  438. Ignoring Rows When Extracting Data From One Worksheet To Another
  439. sum based on multiple criteria
  440. Summing multiple tab using sumproduct function
  441. Thursdays dates between 04/16/06 - 05/15/06
  442. Change Month (words) to (numbers)
  443. LARGE IMPORT
  444. How to replicate a Scenario Manager Formula?
  445. Using DSUM with several criteria
  446. In Excel how can I access the Name Box value (address) in a formu.
  447. HOW DO I CHANGE THE FORMAT OF A SS# FROM 123-45-6789 TO 123456789
  448. Need a formula to create an order number
  449. Add a particular number as a running total
  450. Subtotal Error
  451. Counting when both match
  452. Importing From one Workbook to Another
  453. IF Statements and Time
  454. Can I add an IF statement
  455. How do I create a list of items in a column?
  456. How do I create a template to fill in government forms?
  457. How can i calculate the age as on aparticular date on excel
  458. using sysdate in "if" function
  459. linking four cell with multipule colums with other worksheet
  460. Not sure how to do this, not even sure how to ask the question clearly...
  461. relative information in two separate worksheets?
  462. Formula to display cell reference (ex.. B7)
  463. SUM a range of sales based on month
  464. missing worksheet
  465. Using criteria
  466. You should be able to lock individual Excel cells
  467. increasing percentage
  468. copying and pasting excel formulae
  469. Conditionally format one cell for contents of another?
  470. data inversion!
  471. when I enter an amount in the A column move the row to another she
  472. writing macros in excel sheet
  473. lowest common denominator
  474. Color format cells based on list in seperate worksheet
  475. lookup a value from multiple columns of two workbooks
  476. Error Reporting
  477. Advance Vlookup function may help!!
  478. Match or VLOOKUP
  479. Thank you Thank you Thank you
  480. How do i "lock" an array...or something...
  481. IF statement with Weekends vs. weekdays
  482. help for RAND
  483. Miles Per Hour
  484. Linking sheets in the same workbook
  485. how do I advance filter a large csv file for unique customer #'s
  486. Req help matching values across columns in Excel
  487. copying worksheets into one
  488. Referencing columns to rows
  489. Assistance with Time Keeping Formula
  490. Speed issues
  491. update data from one excel to another excel file
  492. Moving data from one sheet to another- How to?
  493. Fill color doesn't work although font color does.
  494. Can I do this??
  495. Fantasy Football Conditional Arrays
  496. Difficult formula SUMPRODUCT,MATCH,WEEKDAY
  497. weighted average formular
  498. Simple SUMIF formula gone wrong!
  499. Date Functions in Excel
  500. How do I set up stopwatch racing times in Excel?
  501. FORMULA HELP
  502. finding an entry from two criteria.
  503. How do I save a custom cell format that I created?
  504. Formulas calculate specified percentage of annual budget in Excel
  505. How to generate a function from the given data list(Y and X)
  506. nested IF in calculated field in pivot table
  507. Re: Offset Function
  508. Projection of values
  509. Is there a formula to show which cell is currently selected
  510. how can I return todays date (today() ) in an if function
  511. Lookup on 2 Values
  512. Selecting Multiple Sheets in VBA
  513. How do I copy the value from a cell without copying the formula?
  514. sumproduct ?
  515. Compare rows?
  516. Sumproduct #value!
  517. Importing from one workbook to another
  518. When i highlight cells, I USED to get total in bottom rt corner?
  519. Formatting in a list box
  520. How to calculate shipping costs based on subtotal
  521. How can I show time spent?
  522. Counting question
  523. IF/AND/OR Help
  524. If cell contains then function
  525. Urgent Help Needed please
  526. Change link in pivot table
  527. Populating Drop-Down lists
  528. vlookup with search?
  529. Truncating numbers
  530. Macros shortcuts not working from 2003 to 2000
  531. calculating cells
  532. continue adding inventory
  533. Hourly rate times hours?
  534. Sum of pivot table data
  535. How do I calculate loan balances when payments are missed?
  536. Entering numbers in a cel formula
  537. Protecting a worksheet with filters
  538. The absolute referenced cell does not move when source cell moves
  539. formula to display choices of more than one in a list box
  540. SumProduct Question
  541. How do I get a cell to flash depending on another cell's value?
  542. comparing time intervals
  543. Automatic Calculations
  544. VLOOKUP help needed PLEASE...
  545. to long if argument
  546. how do I get the columns to automatically add?
  547. How can I add hours and minutes then multiply by cost per hour?
  548. Using address function result in an array
  549. copy cells
  550. Email alert to call or view a line in a spreadsheet
  551. Data in multiple workbooks
  552. text disappers when sorting column
  553. Convert Date to number?
  554. sumproduct three conditions
  555. Sumif not criteria
  556. Function, dont know what its called
  557. Grouping & Group Totals
  558. Excel 2000 pivot table problem
  559. Help! Still looking for answer - editing unlocked cells on prtctd
  560. In Excel why does the date I enter automatically change by 1 day?
  561. In Excel why does the date I enter automatically change by 1 day?
  562. Converting Alphanumeric numbers to Numeric
  563. Compare multiple dates, can enumerate cell based on most recent date
  564. Conditional Calculations???????
  565. On-Call schedule
  566. Excel Pivot Table - Repeating Lables
  567. Embedding a macro within a formula
  568. <REQ> Can anyone help me build a function, please read....
  569. Find Multiple instances of Single Criterion in Row & Return To a Single Col
  570. e-mail form excel useing IF formula
  571. Validation List
  572. number format
  573. Formula not giving me the right result
  574. Dating local singles here for free!
  575. VLOOKUP and Multi Lists
  576. SUMPRODUCT + multi conditions
  577. Summary statistics for a golf scores spreadsheet
  578. calculate a date, 10 weeks after a set date
  579. Re: Search using multiple worksheet
  580. allow search on ranges of values
  581. conditional formatting or formula
  582. Matrix question
  583. Changing Max
  584. Data combination
  585. IF - returns name error
  586. Re: 1 cell average across multiple worksheets
  587. VLOOKUP or IF or BOTH
  588. How to make a conditional Median function?
  589. if statement format cell
  590. if function
  591. Compare named ranges
  592. Countif thats works erratically
  593. Comparing 3 dates
  594. Automatic cell colouring
  595. Subtotals/Groupings
  596. Vlookup ?
  597. Formulas won't enter into cells in Excel 2000 only as useless data
  598. Formula HELP PLEASE!!!!
  599. Date and time stamping multiple cells for multiple entries.
  600. Input Cell
  601. Number of items in a colum
  602. SUMIF problem
  603. inserting formulae
  604. can I do this w/out VBA
  605. Convert Text to Numbers
  606. VBA code help please
  607. Combining IF, OR and 3d references
  608. print data
  609. Can one VB macro write another macro?
  610. HELP!!--unable to save document
  611. Avg numbers but not #VALUE
  612. Automatically add "0" to blank cells without a formula in the cel.
  613. partial lookup/match
  614. IF AND Question
  615. Can I hyperlink in my sheet to a remote document on my server?
  616. How to be noticed/to avoid equal values in a colum
  617. Equation behind the Function
  618. How do you fill a cell with a color based on IFTHEN formula?
  619. Formula Help!!
  620. How do I build a excel sheet that counts item in an inventory
  621. Index and Match
  622. Need Function
  623. format cell to know number of another cell automatically
  624. how do I format a cell to display in degrees minutes seconds
  625. Trying to do Vlookup on multiple columns from different worksheet
  626. Sumproduct question
  627. I want to link two excel docs
  628. find cells that add up to certain value
  629. Splitting 1 cell into 2 based on underscore in text
  630. Formula for changing date format
  631. Drop down menu
  632. Pivot Table Refresh Problem
  633. How to make a null cell as 0 (Zero) so that the subtraction works
  634. Re: 1 cell average across multiple worksheets
  635. INDIRECT sheet Names
  636. how to print a complete workbook with multiple tabs on both sides
  637. Which Function To Use
  638. data extract
  639. formula help
  640. Automatically enter page breaks?
  641. omit a negative number
  642. Transfer Spreadsheet
  643. an odd question-cant figure out a formula
  644. Summing inventory by quarter and product#
  645. why do i sometimes not see the "Filter Mode" in Excel status bar?
  646. PageArea referencing a text value
  647. comparing cells
  648. Formula to reconize text or number please
  649. change birthday display from mm/dd/yyyy to HIDE the yyyy?
  650. How do you populate one spreadsheet from multiple worksheets in a.
  651. Prevent automatic random generation
  652. Prevent automatic random generation
  653. Date function returns #NUM!
  654. a little help pls
  655. Returning a Value by Matching Two Columns of Data
  656. How do I add parenthesis to my phone number list -the area code?
  657. How do I protect formulas from being deleted?
  658. Subtotal page break error?
  659. How do I pull the column header next to a Max formula?
  660. array conditional equation
  661. Microsoft Excel
  662. sun total of one column using criteria in another column
  663. How do I add 12 business hours to the current date/time?
  664. How do I add 12 business hours to the current date/time?
  665. Add 12 business hours to Time
  666. Scoring function not quite right?
  667. REPOST: Which Function to Use
  668. converting text to numeric data
  669. File Size Function
  670. discounts on LA events
  671. How to change decimal places in balance sheet template
  672. AND Function
  673. Timesheets - calculations with hours
  674. Giving different text for different numbers
  675. SUMPRODUCT troubleshooting
  676. MATCH w/ multiple answers?
  677. Extracting a number from a string and converting it into an Intege
  678. A1 value 400 I want disply in B1 "Four Hundred"
  679. Sort of VLOOKUP
  680. Lock data in a cell a specific cell based on selection on other ce
  681. cell formatting
  682. July 19-21 London Excel User Conference
  683. Late Rounding of Formula
  684. Data Validation Rules
  685. how do you use a chisquare function to analyse data
  686. SUMIF FUNCTION
  687. Blank cell in formula
  688. Help!!!
  689. Font size smaller and bigger in a formula
  690. VLOOKUP not returning correct answer
  691. Index,Match table array in separate workbook
  692. How to copy formulas to a new workbook? Paste Special is different
  693. Two functions in one cell???
  694. Finding Quotation marks in Search function
  695. Check if a cell has a formula.
  696. Formulas no longer working
  697. How do I get the checkbook register to keep a running balance?
  698. How do you create your own auto format for a pivot table
  699. Linked cells and Mapped Network Drives
  700. Cell Reference
  701. MSNStockQuote ?
  702. Relating text to a value
  703. Can I insert an email into an excel spreadsheet?
  704. VLOOKUP needing to match two cells
  705. Displaying percentage in ranges in pivot table
  706. add radio buttons to an excel document
  707. IN operator
  708. Custom function
  709. CELL function.
  710. Recursive Functio help
  711. countif with non-continous ranges
  712. Between function
  713. average every 6th cell in a column
  714. Count occurrences of values in a column??!!
  715. Help w/range-based permissions in Excel webpage
  716. Saving worksheets within workbooks as individual files
  717. Does Excel have a "sumnegative" function like Lotus?
  718. Pivot Tables
  719. Converting to Absolute Cell References - en bloc
  720. Date calculations and sum
  721. dotted leader line
  722. existing unique value formula help (index(match(countif)))
  723. Date Population
  724. Using sum(1/countif....) not returning expected result
  725. Automating Tab names
  726. complicated If condition?
  727. Counting multiple criteria involving dates
  728. Excel Worksheet Function
  729. I need to know how to 'Colour Tabs' in Excel 2000
  730. shortcut to last entry in a column
  731. sum the results of a group of formulas
  732. How do I get Auto-Fit to work correctly?
  733. copy & paste formula between spreadsheets - not working
  734. if statement with #N/A
  735. sum within a range of numbers
  736. values in IF formulas
  737. how do I calculate times in seconds and minutes using percentages
  738. Relating text to a value
  739. Sum product of many pairs of columns
  740. Query to find last saved date/Time
  741. Cell protection & Auto Filter
  742. Time between days
  743. Finding values in a list
  744. Help with time formats
  745. external data function error
  746. price higher than...
  747. Re: vlookup formula
  748. Automated summaries/conversion
  749. COUNT IF <> ""
  750. Autofilter and Subtotals
133