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

  1. IF ISNA HELP, please..I cant add #N/A but 0 is another story
  2. Another Friday Question
  3. VLOOKUP ISSUE - Take II
  4. I want tool which finds duplicate date in excel 2003
  5. blank cells showing up as a month 1
  6. Excel financial function: PMT
  7. Vlookup
  8. CAGR
  9. Is there a formula for conditional concatenating?
  10. Help needed with IF function
  11. attendance sheet to add time but not.....
  12. how do I lock column and row names on spreadsheet
  13. PLEASE PLEASE HELP
  14. complex count question
  15. Can I set up the formula to update automatically?
  16. Consolidate data from several worksheets via pivottable
  17. using treater than and replacing numbers
  18. Excel only calculates the confidence interval for a population .
  19. Excel only calculates the confidence interval for a population .
  20. greater than replace numbers
  21. Converting EST to PST
  22. RTD Links, how to start and stop them
  23. Consolidate data from several worksheets via pivot table
  24. Excel should remember sort criteria
  25. Micro that checks if file exists
  26. Referencing a worksheet name
  27. Time Card
  28. IRR # NUM
  29. can you place an alarm or tickler mechanism within excel based on.
  30. can you place an alarm or tickler mechanism within excel based on.
  31. Cell Frequency
  32. Find a non-blank cell and bring back text a in same row
  33. LookUP Function Help!
  34. time card excel sheet
  35. There is no freeze/unfreeze panes option in the windows menu
  36. How do I remove repeating line in Excell - Top line on each page..
  37. Formula to figure credit card payments
  38. SORT MIXED DATA
  39. Most repeated number
  40. Can i find Spearman's correlation number with excel?
  41. Rounding criteria within a nested vlookup and hlookup
  42. If is blank= conditional formating
  43. Move rows to columns
  44. Linking workbooks
  45. INDIRECT, OFFSET et. al.
  46. Possible? formula in one cell can fill another cell
  47. Weird Problem
  48. Numeric cell but shows as string?
  49. CORREL versus r-squared
  50. Excel formulas
  51. how to convert 357646 seconds into hh:mm:ss format?
  52. Concatenate and then limit # of characters
  53. Standard sumif formula not recognised
  54. formula for calculating 401k if over or equal to 1 yr of service .
  55. how do you get (end down) to work in a macro?
  56. VLOOKUP
  57. How Can I track changes in a Work Sheet?
  58. Can I fill colour in a excel cell from a return from an "IF" test.
  59. Sort Worksheets
  60. Month always displays as Jan
  61. Pick certain rows from database to use statistical functions on th
  62. Matching Cells/columns
  63. moving last row
  64. If function
  65. Times in Excel 2000
  66. Help!! Formulas
  67. How do I get a date changed automatically
  68. Exporting Data
  69. Excel n'actualise pas le calcul des fonctions quand je modifie le.
  70. How to detect if sheet is hidden?
  71. Hyprtlink to protected worksheet
  72. (if or) function
  73. how do i get a list of different formulas
  74. How do I use conditional formatting to change subtotals row format
  75. Separate last word in cell with more than 2 words?
  76. ACCRINT formula gives incorrect result
  77. ACCRINT formula yields incorrect result
  78. Excel: How do I type a letter in a column and make a check mark a.
  79. IF function... not equal to
  80. IF function... not equal to
  81. IF function... not equal to
  82. IF function... not equal to
  83. Formula Trouble
  84. Min Formulas in #VALUE! Cells
  85. how can I get the last value entered into an excel column to disp.
  86. Combo box question
  87. Tab Color - Excel 97
  88. Question about sorting in protected worksheet
  89. sum calculation
  90. Remember a previous cell's value
  91. Embedded Excel Spreadsheet in MS Word Corrupted
  92. In Excel, can I shade entire rows based on the value of a single .
  93. moving text
  94. Macros in Excel
  95. YTD Budget Sum if Actual Month has activities
  96. LOOKUP or VLOOKUP
  97. statistical functions
  98. Formula Template
  99. need if-then formula-If a number is > /< something, then place a .
  100. Explain these please
  101. calculating SUM with two conditions
  102. How do you get Info to show on Every Page when Printing
  103. How do I get an IF statement to pull a date range??
  104. Autofill
  105. How do I sort sheets in an excell spreadsheet?
  106. find previous row for an item
  107. Can you password an Excel worksheet, if so how?
  108. Links Problem
  109. filter and keep same information.
  110. Re: Mod-10 Check Digit
  111. designing and saving predefined pivot table formats?
  112. hOW DO I GET THE XCELL FUNCTION CUMPRINC TO WORK?
  113. How to sum a column of hours & minutes in format TEXT(C5-B5,"h:mm"
  114. How can I make a timesheet to figure my hours and payrate?
  115. How do I set up IRR and NPV functions in Excel?
  116. insert rows
  117. Sort Data by Frequency
  118. calculate totals of 5 sheets on to 6th sheet.
  119. Push/write data into an unopened file
  120. Excel 2002 autofill and offset
  121. IF Statement help...
  122. Select all worksheets
  123. In excel how do you format so 09561 for example the zero does not.
  124. HELP! Filtering and sorting lists.
  125. Inverse sin
  126. How does this formula work
  127. Auto filter no longer comes up
  128. how to do more than 7 if
  129. Multiple Sheet workbooks
  130. Macro help
  131. Excel Solver background in forecasting modeling
  132. I need a formula like this "@if(2000<page2:D3,(page2:d5),@if(2000.
  133. Check box
  134. Need a 1 Column multiplication formula for 2600 cells. How?
  135. enable autofilter in a protected worksheet in Excel 97
  136. Pivot Table Grand Totals
  137. COUNTIF woes
  138. Can I see a list of the worksheets within a workbook without scro.
  139. conditional formatting 24-hour clock
  140. Export Excel Dates to Outlook Calendar?
  141. Formating decimal and date
  142. Excel 2003, time scheduling?
  143. add "X" to cell based on cell value
  144. how do you add vlookup results?
  145. Attaching a macro to a VB button on a form
  146. Method of selecting an area with a macro
  147. Work Hours Time Question
  148. My formulas does not sum together
  149. Appending Text to a Cell Value
  150. VLOOKUP
  151. How do you calculate number of workdays from dates entered?
  152. How do you calculate number of workdays from dates entered?
  153. Vlookup w/Date Function
  154. Value of formula field
  155. Creating a macro in excel
  156. Expanding/Collapsing Rows?
  157. Converting text to numbers
  158. In between
  159. How do I make a copy / paste function default?
  160. finding multiple MIN's
  161. Understanding this formula
  162. ISEVEN
  163. setup
  164. Delete rows not in Edit Menu
  165. Combine date with text
  166. Simplify Vlookup function in Excel
  167. Button to clear all entries?
  168. Cell frequency II
  169. How do I convert 00:03:54 to get 234 seconds?
  170. What function can make cells shift up when they are blank?
  171. How do I calculate Amount of Sales Tax from Total Amount?
  172. Sum numbers that include #N/A
  173. Count number of instances in sheet e.g. how many males/females
  174. IF Statement that's conditional on multiple IF Stmts in other cell
  175. Add a constant to data
  176. isformula?
  177. Formula(ae) to mimic offsetinmg of losses against profits
  178. Counting values containing part of a cell
  179. Tax- offsetting losses against profits
  180. Formula appears as text
  181. Entering Data in multiple cells on one sheet & having it auto upda
  182. array formulas
  183. Lengthy and weird, but interesting
  184. I need help with random number generation
  185. countif criteria
  186. Finding specific word in column
  187. Re: Dynamic Range for Function (Vlookup etc)
  188. How do I set up a value (34.7) to value (34) in excel?
  189. excel formulas
  190. League Table
  191. Function/macro to relocate RxC to CxR?
  192. "Pleading paper" in Excel?
  193. VLOOKUP...
  194. can I create a formula using text made from the concentate comman.
  195. Easy formula Question
  196. Spreadsheet Historical Prices for European Stocks
  197. Can't find the right lookup formula for this
  198. Formatting in IF Functions
  199. COUNTIF with compound comparison
  200. Look up of data in a different Sheet
  201. HELP....Is there a way to automate copy/paste special/transpose -
  202. TEMPLATE FOR VALUE PREMIUM
  203. IF function?
  204. Constant Value in formula.
  205. How to keep rows together when sorting columns?
  206. Copying and PAsting using MACROS
  207. Need a ISWorkday Function -- Any Ideas
  208. Email/Save/Macro
  209. copy every 30th cell in the column into consecutive cells in anoth
  210. Need help using search functions
  211. How do I convert cells containing formulas to text (value returned
  212. How do you print all data in a cell?
  213. pivot tables
  214. employee scheduling
  215. Deleting many named ranges
  216. Insert characters in a text string
  217. Count cells in one range based on parameters in another range
  218. How do I assign sequential numbers in an Excel 2003 PO template?
  219. Count and Sum Total occurrances of two specific numbers
  220. Vlookup - double criteria
  221. Vlookup - double criteria
  222. Adding Work Days only in a function?
  223. Vlookup - double criteria
  224. Worksheet database
  225. VLOOKUP - DOUBLE CRITERIA
  226. How to IF dates?
  227. ### when the number is NOT negative?
  228. If formula
  229. how do i copy a formula's result to another cell, without copying.
  230. Comparing a value to a list of values does not work in Excel 2003.
  231. Re: How to set different font colours in a cell?
  232. Evaluating similarity of text strings
  233. List of repeating names
  234. Using COUNTIF to check values in multiple columns
  235. Fill formula question
  236. rounding to closest 5 cents
  237. currency convertor-travel expense
  238. HOW TO CHANGE BAHTTEXT (THAI TEXT) TO ENGLISH TEXT IN EXCEL
  239. calculating moving average
  240. Export from excel
  241. How to calculate subtotal if a row is hidden
  242. How do I lookup values from rows and columns Simultaneously
  243. Cell problem
  244. Hyper Links
  245. MACRO
  246. how do I write a formula to round up a number?
  247. how do i change footer settings on multiple sheets at the same ti.
  248. Opening two excel worksheets with dual monitors.
  249. Work books
  250. How do I calculate present value of a single sum?
  251. How can I link a cell in one worksheet to a cell in another works.
  252. How can I create a formula to locate data between two dates?
  253. Returning Multiple Values Based on One Value
  254. Stop numbers converting to dates.
  255. Animate excel?
  256. Precedents do not work
  257. Can you make cells in Excel flash or twinkle?
  258. Creating Formulas
  259. if function errors
  260. Save as not working for laptop to desktop
  261. If statement help
  262. Tool > Compare and Merge Workbooks... This is not a highlighted .
  263. Cursor wil not move left in worksheet
  264. Excel should allow me to freeze pane in a split window
  265. Combobox/tab order
  266. Re: Networkdays problem
  267. HELP!! Need help with if/and/then/copy statement!!!
  268. sumif range of varying size
  269. Sum of a column
  270. Why not nest more than 7 functions in Excel formula???
  271. referring to other worksheet
  272. Trying to enter a range of numbers using >1 and < 5 in a formula
  273. Help with importing from Outlook
  274. Drop down list with multiple choices
  275. Insert rows
  276. Worksheet Protection
  277. If Statement - in time not decimal minutes
  278. If (either of these) return this
  279. Renaming Worksheets
  280. How do I take excel data and convert to label/envelope form?
  281. Updating rows - Excel Formula or Something Else?
  282. dates change to numbers
  283. Match Last Occurrence of two numbers and Return Date
  284. vlookup with two criteria
  285. If I create a random list in Excel, does it repeat numbers?
  286. recognize formatting
  287. lognormdist function
  288. How can I trim "4|+|23.68^" into "23.68" in excel 2000?
  289. Lookup with 3 criterias
  290. autofilter problem
  291. i want my excel colums to be rows
  292. Using Indirect Function
  293. Formula Assistance
  294. time differences in a column
  295. Insert Row
  296. Some exported records do not show on spreadsheet
  297. How do I create a workbook that links info in cell to a calendar?
  298. How do I subtract column 1 from 2 and show results in 3?HELP!
  299. Replace with subtotals
  300. How do I return dynamic lists?
  301. Ptable - 2 in a workbook for the same data?
  302. Add ins for Excel 2000
  303. Decimals separation "." and ","
  304. Bahttext only display in thai?
  305. how to brack prtection password in microsoft excell in tools men.
  306. Lookup the month in a date string 01/03/05
  307. Re: Plotting Dates
  308. How do you do a culmanative frequency in excel
  309. How can i convert Text Case in EXCEL?
  310. Cell addressing using the content of another cell.
  311. Cell addressing using the content of another cell.
  312. Can Excel represent formula in textural format with values substi.
  313. How can I create drop-down lists with references in other workboo.
  314. Multiple minimums for the same column
  315. Conditional Formatting
  316. Question about financial calculation PMT
  317. Split cell values based on content
  318. need help finding a Date range within long list
  319. follow-up from yesterday's "creating formulas"
  320. how do i sum 2 values that fall between date ranges?
  321. I want to create a macro to where after we enter data in a spread.
  322. Explode Cell Data
  323. how do I assign a symbol to the result of a part of a nested IF s.
  324. Sending a group email
  325. Formulas
  326. IF, AND, OR Conditional formula?
  327. IF, AND, OR conditions?
  328. how do I change case in an entire column of text in Excel
  329. Converting Columns to Rows
  330. fax multiple worksheets
  331. Using date function in an if statement
  332. data in empty cells
  333. Value to text words conversion
  334. How about adding a quarterly function to Excel like its EOMonth?
  335. Working w/ non-standard Time Format
  336. Can I select a worksheet based upon a cell criteria?(for printing)
  337. Totaling rows of text
  338. MY WORKBOOK WON'T LET INSERT ANOTHER WORKSHEET.
  339. SUMIF/SUMPRODUCT??
  340. How do I set up a equipment replacement reserve schedule
  341. RUN CONSECUTIVE EXCEL DATES ON DIFFERENT PAGES IN WORD DOCUMENT
  342. How can I run a macro in a protected worksheet?
  343. Excel running date formula minus weekend days
  344. Pivot table report
  345. Calculate Due Date
  346. Separating dollars and cents
  347. Need Formula for Date Conversion
  348. How to copy conditional formatting
  349. Pivot tables-multiple payments
  350. Excel static current date/time problem
  351. I want to select excel cells of difference colors and increase th.
  352. Is there a way to change text color using the Logical IF statemen.
  353. Updating master workbook from source that may/may not exist
  354. EXCEL 2003 PROBLEM
  355. Computing totals for tax and non-tax items
  356. How to convert a series of numbers
  357. Transfer Items to a list with no duplicates
  358. Rounding Question
  359. Formula linked to cell with Macro
  360. how do I make a heading row "float" to follow the data as I scrol.
  361. EXCEL 2003: Apply Conditional Formatting to COLUMNS
  362. copy visble cells at the subtotal level
  363. TURN LOWER CASE TO UPPER CASE IN EXCEL?
  364. Counting within a cell
  365. How do I link 2 worksheets in different files?
  366. HOW CAN I READ SPREADSHEETS CREATED BY OFFICE 2000 ON OFFICE 2003.
  367. sorting with data on alternating [every other] row
  368. sumif with two conditions
  369. Need a simple formula please
  370. calculate permutations of nonnumeric data
  371. move page breaks
  372. Color detection
  373. import select data from another workbook
  374. How do I auto-protect a worksheet?
  375. How do I add the count function to the toolbar?
  376. Extracting worksheet names....
  377. detect cell color and count it
  378. how to write macro after autofilter is applied
  379. Home account
  380. Auto Update Links
  381. Calculate time and cost
  382. VLOOKUP TABLE_ARRAY
  383. Spread Sheet Tabs
  384. Absolute average
  385. In excel pointers should be availible
  386. looking for help on....
  387. Creating Drop down menus in an excel cell
  388. HOW DO I CONVERT CELLS/ROWS FROM ON FORM OF MEASURMENT TO ANOTHER
  389. difficulty changing cell format
  390. What are the tricks using "=(SHEET1!cell_reference)".
  391. in excel how do I show a number as an alpha eg 65 as sixty five?
  392. Returning Multiple Values Based on One Value
  393. Working with If statements and time
  394. I need a VLOOK-UP formula that uses two look-up vaiables in seper.
  395. dates and concatenating
  396. Set Tab key
  397. quotation form
  398. delete all text that match
  399. formula for calculating # of days between 2 cells
  400. Concatenate & Force argument to End of String-(spsjp)
  401. How to calculate a sum as one outcome of an IF statement
  402. I need to know formula for matching retirement percents
  403. functions
  404. formatting date
  405. round up cells to $xx.99
  406. Microsoft excel 2000
  407. Can Excel "slide up" rows with content thru empty rows to condense
  408. Only want color to show when cell is active
  409. Cell content elimination; duplicate
  410. Old, LOTUS 1-2-3 based function
  411. indicate whether a cell contains a formula
  412. formula SUMIF or whichever one will work for my issue
  413. Datbase check
  414. EI_CALC Function
  415. Remove leading Numbers from text
  416. SUMIF problem
  417. Find project start and end dates in a DB with many different proje
  418. inventory counting
  419. What formula do I use in Excel to determine whether one cell fall.
  420. How do I sort data from various worksheets in the same workbook i.
  421. Can VLOOKUP deliver the second occurence when target column entri.
  422. Excel question? Regarding cell formula
  423. Summing Every 40th cell?
  424. Help combine 2 formulas into 1
  425. how do i make one chart that my ees can input info, and have a se.
  426. index / match function
  427. simple formula with blank cells
  428. How do I pull information from one worksheet to another using cer.
  429. countif/sumproduct on multiple criteria
  430. How do I sort by complete rows in excell
  431. how do you get excel o calculate antilogs
  432. select variables ranges, copy to array, paste the array in new workbook
  433. Why do I get a #Name error when I use the DateDif function?
  434. Why do I get a #Name error when I use the DateDif function?
  435. can i sum up only visible cells?
  436. format cells
  437. How to share data between worksheets?
  438. Help with formula please
  439. initiating a macro
  440. How to convert entire excel document from lower to upper case
  441. save external link values
  442. Data $9,620,320 principal, 360 # payments, 9 % rate, fv 0. Why do.
  443. match and #ref
  444. how do you calcualte a payment for a loan.
  445. How can I get a count of cells in a range that are shaded a certa.
  446. Set a value, use it later (possible VBA?)
  447. saving options along with spreadsheet
  448. Data validation not showing drop down
  449. Set values in functions??
  450. how do i change a spreadsheet into labels?
  451. VLOOKUP
  452. Applying a currency rate that doesn't change when source updated
  453. Summary of values from a date range
  454. Importing from other application
  455. coloring overy other line without doing so line by line
  456. Backwards lookup
  457. Excel Map function
  458. how do i make overtime in my payroll sheet calculate after 42.5 h.
  459. Averages: Exclude Rows with 0 Values
  460. count if
  461. Time Cards
  462. Rounding to nearest integer
  463. How do I forecast monthly and annual totals from previous year's .
  464. Cell References and External Data
  465. How to keep linked cells blank until information is entered?
  466. Need to avoid a circular reference...
  467. Merge & Center
  468. I have user defined functions in sprdsheet. I want to put sprdsh.
  469. conditional forming causing linking errors
  470. function values do not refresh
  471. Enter an Excel cell reference as part of a custom header/footer
  472. Recovering excel file
  473. HELP! Lose Database Query upon Refresh
  474. easy question
  475. Looking for formula index/match-type that returns an array
  476. excel to outlook
  477. vlookup
  478. Page margin units
  479. If Statements
  480. Merged cells
  481. VB Code to do this....
  482. Match Last Occurrence of two numbers and Count to Previous Occurence
  483. How do I convert $500 to Five Hundred Dollars?
  484. Excel
  485. Excel
  486. REMOVE SPECIAL CHARACTERS FROM TEXT CELLS
  487. excel formula
  488. Points behind next rank in a fantasy league
  489. not able to convert text, or graphic number to regular number in e
  490. How do I pause a macro to select specific cells
  491. How do I convert 02/05/05 to 02, please?
  492. formula help
  493. Grand total same cell in all worksheets
  494. formula help
  495. Multi-If function
  496. Boolean masks
  497. how do I repeat a drop down box
  498. How do I open a file downloading in MS Excel
  499. multifuntion formula
  500. Opening an excel spreadsheet
  501. find a cells from a range of cell
  502. Printing 2-up
  503. ACN to CAN
  504. EXCEL Question???
  505. why does my cells turn blue like I'm formatting when I try to ent.
  506. 2 cells value to 1 cell
  507. IF functions
  508. I cannot rename my excel sheet?
  509. apply cell names to formulas in multiple worksheets
  510. How can I generate number based on two measurements?
  511. Effective Annual Interest Rate
  512. CSV FILE TOO LONG FOR EXCEL
  513. How to make background grid lines disappear when viewing
  514. Excel/Access 2002 sum function
  515. Mouse right button not working
  516. Two dimensional sum by week
  517. Two dimensional sum by week
  518. VLOOKUP Function
  519. Changing display of decimal value based on the value in the cell
  520. Hard page break that won't allow me to scroll past? would love to find out ;)
  521. Sorting names in a range
  522. VLOOKUP
  523. LONG VLOOKUP
  524. RE: =RIGHT (function)
  525. Re: Automatically Insert DATE, so that DATE will NOT change
  526. Re: HELP WITH AUTO EXPORT FROM OUTLOOK TO EXCEL
  527. cant add a worksheet
  528. RE: Need formula for budgeting payroll taxes.
  529. RE: How do I identify the 7th digit in a 13 digit number, then establi
  530. Re: how can I add cells in hours and minutes, eg 1.15 +1.45 to equal .
  531. RE: Global Setting For All Workbooks - Filename In Footer
  532. Re: Global Setting For All Workbooks - Filename In Footer
  533. Get current cell with VBA function
  534. Merged Cell will initally show text from 1st worksheet but then wo
  535. CHAR(10)
  536. I want to return a value based on the status of a check box. If .
  537. Syntax for inferred cell references
  538. WEB QUERY - HELP!!!
  539. Warning message base on date
  540. can't insert more rows even though not at max rows
  541. RE: HELP...PLEASE...W/ IF/THEN/COPYTO STATEMENT - THANKS!
  542. Re: How do you populate the X variables in Regression analysis for mo.
  543. nested sumif or sumif with two criteria
  544. sorting problems
  545. create links for formulas
  546. Vlookup Bmp
  547. HELP with Formulas
  548. Decimal Time
  549. sumif vs sumproduct
  550. IF and ISERROR Functions
  551. How do I get rid of duplicate text?
  552. subtotaling large data set
  553. Re: how do I write a formula that will figure weekly overtime?
  554. Re: getpivotdata refresh problems
  555. bringing data from one workbook to another using a date stamp func
  556. How to countif involving another column?
  557. How many values appear more than once in a range?
  558. Finding dates within a date range
  559. YTD Budget Totals
  560. Automate Pivot Table Drill down
  561. need help with a formula in excel
  562. How do I setup a depreciation template for all types of assets?
  563. How do I find the contents of a cell using the "ADDRESS" function.
  564. For Ron Bruin Please
  565. zip code entry
  566. zip code entry
  567. excel: How do I setup a function to put any numbers over 80 into .
  568. "IF"
  569. convert character to value at relative cell
  570. Max and Min date from listing by account no.
  571. function IF / how to input pictures into this functions /
  572. can excel draw a shape based on values entered in cells
  573. Array Function with VLOOKUP
  574. access my data from my master worksheet while calculation is don.
  575. Separating text
  576. Autocalculate
  577. Combine VLOOKUP, IF, AND in one formula
  578. auto dating after entering the first date
  579. Function IF / test / Picture result
  580. How do I remove a blanck space from the beginning of a formula?
  581. Converting imported numbers to decimals (rather than /100)
  582. Re: How to convert columns of data to one column of text
  583. increase conditional formatting in Excel
  584. Help comparing data and returning information...
  585. Bring back the old help format!
  586. excel help
  587. "IF" formula question
  588. Repost: Vlookup Bmp
  589. Formatting combined Cells
  590. Sumproduct with Wildcard *
  591. Linking data that contains specific row criteria
  592. Month/ year function.
  593. SUMING VARIOUS LINE ITEMS FROM MULTILPLE WORKBOOKS
  594. combining data from multiple sheets
  595. Getpivotdata - referncing a data_field resulting in "REF!
  596. Cannot enter formula in a cell after removing a circular formula
  597. Is the data validation criteria limited to a few number of items .
  598. Re: Networkdays
  599. Bringing partial data from one cell into another
  600. Networkdays function
  601. Calculating differences between dates
  602. Finding Specific Text in a Text String
  603. Automate copy command?
  604. Vlookup of an if statement return
  605. How can I assign a number value to a letter grade in Excel?
  606. Difficult matrix query
  607. problem when saving CSV file
  608. How do I add an area code to a list of phone numbers in Excel?
  609. EXCEL -- want to do have ''averageif'' - like sumif function - H.
  610. Sum Formula Help Please
  611. how do i use "if" in cell that ref another with text from a pulld.
  612. Matching Data
  613. Only Reference cell with data in them
  614. How do I sum and add * on each side based on value in excel?
  615. Can I create an order summary report in Excel?
  616. mag-keyboard shortcut
  617. appending data to individual cell throug function
  618. help
  619. Re: =RIGHT (function)
  620. how do I rank negative and positive numbers?
  621. Re: =RIGHT (function)
  622. How do I search for a string across multiple worksheets in Excel?
  623. Matrix Query Part II - lookup value
  624. How do I import from Quickbooks and create a link.
  625. import external data from changing file name
  626. sumif involving another column
  627. How To Use Cells Without Values in a Formula
  628. how do i set up a "balance over 30 days" field in an invoice?
  629. Data Validation
  630. Is there a way to assign a specific printer to different sheets i.
  631. I want 20 rows in excel to take up full A4 page
  632. Re: Counting days
  633. Automatic Number Creation Problem?
  634. How to create a formula for this function.
  635. In Excell sheet i want to insert more than 65,536 rows how i can .
  636. HELP - need to returns the current number of past month this year and ...
  637. IF Functions
  638. Why won't it Excel fill in weekly dates now, changes them to daily
  639. Binary Numbers longer than 10 characters
  640. Function question
  641. how do I insert a geographical map
  642. time format
  643. Re: Counting days
  644. Why does it say "Filter mode" instead of "X of Y records"?
  645. 'add-to-basket' function
  646. INDIRECT.EXT question
  647. Multiple Condition Sumif Formula
  648. Old Lotus Files
  649. Auto Update upon shifting, inserting or deleting
  650. Date functuion.
  651. $20,000 due. Pays diff $ every x. Int calc per annum. Need excel .
  652. color cells with text
  653. Vicodin No Prescription Needed! Free UPS Shipping!!! 2YE5Yy
  654. how do I type in a number and have it automaticly add to the exs.
  655. rounding time question
  656. Excel: Additional Conditional Formatting
  657. Compounded formula using SUM & AVERAGE
  658. PLEASE HELP......COPY DATA FROM ONE WORKSHEET TO ANOTHER
  659. When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)...
  660. How can I change an Excel spreadsheet that has UPPER case to PRO.
  661. Re: Mode Function with Criteria
  662. Re: Max and Min date from listing by account no.
  663. mag-text in merged cells-automatic row heigh
  664. Count Check Boxes
  665. Effective yield rate - non level premium flow
  666. Macro Help
  667. Reversing First & Last Name
  668. IF Function - If the reference cell data is presently unknown
  669. Lookup function with drill down?
  670. Link to powerpoint resizing graphs
  671. counting coloured cells
  672. Emailing a workbook with links
  673. concatenating numbers
  674. Summarize Data Set
  675. Creating links to a worksheet on a network.
  676. Creating links to a worksheet on a network.
  677. excel 2002
  678. Excel Formula WEEKNUM only works on weekdays 1 and 2, why?
  679. SUMPRODUCT using months
  680. Hyperlink ONE word in a cell ???
  681. How to link a document to a workbook with a hyperlink in excel
  682. links
  683. Need formula for: if A6=100 thru 125, then "A", etc thru "S"
  684. Counting days
  685. Combining two formulas
  686. VLOOKUP: type or paste values
  687. Help with code please
  688. Put a Worksheet in a workseet?
  689. How to lookup multiple values and summing them up in one cell
  690. Absolute address in Workbook linking
  691. count check boxes
  692. excel and access
  693. Problem with updating values with INDIRECT.EXT
  694. Using ABS() in a range of cells
  695. Algorithm for computing Excel PercentRank
  696. Why are the cells of my workbook not refreshing?
  697. Bring Back Qualified Sum from another WB
  698. Please Help
  699. Column WE
  700. IF Function in incremental charges
  701. Separate Spreadsheets
  702. navigate in Excel worksheet without scrolling
  703. Need help with Excel Lookup
  704. On a excel protected worksheet, how do I change the tab order?
  705. How to make a number round up/down to a set number
  706. April 1
  707. Count cells with length not equal to 7
  708. How to count how many different items in one colum?
  709. How to compare 3 numbers and return value
  710. lookup values to sum
  711. unable to total a column
  712. Re: Help? start macro automatic in excel
  713. Re-calc. speed question
  714. IF
  715. What formulas are best for sorting by date?
  716. number of days in a month
  717. Spin button in a work sheet - how do I make it work?
  718. Vlookup based on two lookup values
  719. Lookup function
  720. Why can't I link a cell from worksheet to another when it has an .
  721. Unhiding rows using data validation
  722. Formula to count number of dates in an array
  723. formula to calculate a column based on dates in a different colum.
  724. Recording the first change in the value of a cell
  725. concatenate
  726. how do i automatically insert the current author's name in a cell.
  727. Embedding Word Docs into Excel Worksheets and Then Printing The Word Docs
  728. linked objects following and leading returns
  729. List box or combo box on an Excel spreadshee...
  730. Can I disable the copy feature?
  731. Conditional Formatting, reference another column
  732. create an excel formula with contitions
  733. Jason Morin Please Respond
  734. Calculation to subtract TimeValue from Now() Value
  735. Index & Match
  736. HELP with function, possibly code!
  737. Formatting an entire row based on one cell
  738. how can i subtotal on a text value - ex. every Monday?
  739. Can I use conditonal sum and have results on a linked sheet?
  740. Color viewing problems-Cell
  741. Macro Help
  742. Select header if formula
  743. can you make a title page using Excel?
  744. Formulas not calculating
  745. count cells across muliple columns
  746. lookup function
  747. How do I keep each week's data from the payroll calcualtor?
  748. Creating a formula
  749. MIN Function
  750. Creating a functions
131