View Full Version : Microsoft Excel Worksheet Functions


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

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