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. HLookup? or an array function??
  2. How do I make a row or information, follow as you scroll down..?
  3. How to enter current static time in Excel in 00:00:00.0 format?
  4. how do i copy format which refers to every OTHER cell
  5. IF Issue
  6. IF (AND) help..
  7. Comparing two lists in excel that don't match exactly
  8. Force refresh of custom functions
  9. Trying to compare data in two columns...
  10. formula bar
  11. formula bar
  12. formula bar
  13. Count rows not in sequence
  14. Why am I getting #NAME?
  15. Which function do I need?
  16. How do I look up values from a range of values?
  17. Combining COUNTIF and LEN
  18. sumif date is in certain month
  19. How do I freeze a row in Excel 2003 ?
  20. Calculated formula using 'COUNTIF' ??
  21. not urgent
  22. I need a Palm PDA address template to convert Excel spreadsheets
  23. "IF" Function . . . PLEASE HELP!!
  24. formula
  25. formula
  26. Insert Fuction
  27. Place the caption of a toggle button into a cell
  28. How to make excell automatically select every other role for shadi
  29. lookup table
  30. Suppress First Page Header
  31. Excel opens saved workbook without tabs or scroll bars showing?
  32. Attach comment to object
  33. How do I convert functions that are zero into a null ?
  34. Msgbox based on If statement
  35. Pivot Table Help
  36. if formulas
  37. Edit query takes a long time
  38. Fundamental problem with IF statement
  39. I need to measure hours between two events(time/date) to give me .
  40. If Statement Criteria
  41. "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du
  42. why am I getting "#N/A"?
  43. display the value of a cell adjacent to the cell with max value
  44. Protection for formulas
  45. Why don't my latest changes get save in my backup
  46. Summarising scores
  47. Can I use excell to draw a rectangle and come up with square feet
  48. Can you Auto fill address in excell with a data base?
  49. 3 highest values indicated using formatting
  50. Cursor not to move when hitting the enter key
  51. Pivot Table Page field link to cell
  52. Look up dates
  53. Protect sheet with outline
  54. Great discovery?
  55. Formula query
  56. IF function with multiple formilae
  57. help with formula
  58. Fast Fourier Transform
  59. Re: Jesus said, "I am the way, the truth and the life: no one can come to the Father(God)(in Heaven), but by me." (John 14:6) This means that if you die without trusting in Jesus Christ as your Lord and Saviour you will die in your sins and
  60. how to set up a vlookup table with 2 search terms?
  61. How to make worksheet names dynamic?
  62. looking up a value
  63. countif?
  64. Excel should allow me to repeat bottom rows on every page.
  65. Maintaining numerical data with <'s in pivot tables
  66. Formula for placings, using 4 times and greater than minimum time
  67. excel
  68. Counting cells, similar values
  69. Aggregating categorized information from several worksheets
  70. macro to run series of reports to PDF
  71. Changing Numbers
  72. How do I have a macro format cells while recording?
  73. Use quotation marks in a formula to display a qty in feet and inc.
  74. Calculate Minimum numbers
  75. APR - Annual Percentage Rate to Actual Interest Rate
  76. SUMPRODUCT that bring Text
  77. Convert a column in Amount in Word
  78. Unique Count sensitive to hidden/filtered rows
  79. remote functions
  80. Can I create a formula from text in several cells?
  81. PivotTables in Excel 2004 calculate incorrect standard deviations
  82. Function to Rearrange Name
  83. my data truncates when ported from access to excel
  84. Forcing an Excel spreadsheet to print only selected groups of cel.
  85. If
  86. Excel options disabeled
  87. DV Issue
  88. drop down list?
  89. trying to create an (almost) circular formula between cells and data validated cells with lists
  90. Cell Reference of Max Num. or Min Num.
  91. Insert macro into formula
  92. Re: Fundamental problem with IF statement-None worked
  93. best formula to match across sheets?
  94. Return text found in a search
  95. Fundamental problem with IF statement
  96. Golf Handicap Using Last 5 Scores
  97. The 'Recently used file list' does not show up under the 'File' menu.
  98. entering advanced formulae
  99. Excel to create codes using the 321 system
  100. Lookup Oldest date from previously selected Group Data
  101. Removing numbers from the beginning of a text string
  102. Replacing specific characters with spaces
  103. How do I sum Column F if Column B = "DEPOSIT"
  104. Search formula
  105. excel is adding cell numbers randomly into other cells
  106. functions/formulas
  107. calculate APR on ARM
  108. Email hyperlink changes not showing in excel
  109. lsit value and skip blanks
  110. XIRR and IRR
  111. lookup second character
  112. What query isused to add up the credits until it matches a debit?
  113. how to Import data in excel office2003 with data more 65000 rows
  114. How to deploy custome toolbar/Menu commands in Excel?
  115. Another SUMPRODUCT array anomaly
  116. Rounding
  117. 3D reference with multiple criteria
  118. cell addresses
  119. how do i find data in multiple sheets in excel
  120. I cannot remove a link in excel 2000?
  121. Stock Reconciliation
  122. Re: Print Range
  123. Lookup's for and totals
  124. IF/AND FORMULA
  125. add hours (calculated by functions) on a timesheet
  126. Look up part of a date
  127. Change date to quarter of a year
  128. Refering to a tab using data from a cell
  129. Add images or logos to the Header in Ms- Excel Sheets
  130. Improve autofilter combine conditionals with filter criteria
  131. Sum every 10th cell in a range of cells?
  132. how do i use a formula to work a precentage of a percentage
  133. How to auto arrange the worksheet in a excel 2002 file?
  134. Allocate a value to a cell from an if statement
  135. Dropdown boxes (box 1 result = box 2
  136. conditionally format cells
  137. pulling certain data out of a cell
  138. checkbox
  139. macro help
  140. Can I compare 2 lists to combine duplicate entries in new list?
  141. HOW DO I ADD CLOCK TIMES, WHEN DIRIVED FROM A FORMULA?
  142. how can I remove seasonality from my data
  143. How do I use multiple "Does not contain" function in excel?
  144. room schedule
  145. exporting a lot of data
  146. SUMPRODUCT
  147. Finding min and max date of a given month
  148. Name Range with three requirements
  149. Drop down menu for page references
  150. Can you save a single sheet directly to a new file
  151. Re: Excel Macro to insert rows in a list
  152. Re: Need to add a certain percentage to a column of prices
  153. Enable Automatic Refresh
  154. Finding Time difference
  155. Can this be done...?
  156. special characters
  157. CHANGE LOWER TO UPPER CASE IN EXCEL FOR WHOLE SPRDSHT
  158. Convert $12.00 to text (Twelve dollars) like you would on a chec..
  159. SUM or COUNT and adding a row
  160. stop excel from rounding a result
  161. How do I change rows content to column & vice versa Excel spread s
  162. Game score without game being played
  163. How can i set up a MONTE CARLO SIMULATION macro in Excel? thx
  164. How to pull numbers from two tables with conditions?
  165. data validation and using hyperlink to email
  166. Deleting a file from within Excel
  167. How can you set a value in one cell from another cell in Excel?
  168. VLOOKUP-How do I get answers pulled from different appropriate col
  169. How do I Change column labels to ABC from 123 ?
  170. Underline % format
  171. Is there a function that will return info of the cursor location?
  172. round numbers to the nearest quarter?
  173. Replacing #N/A response when obtained in Lookup function
  174. Installed Analyst Toolpak but not working for files used at work?
  175. Jesus said, "I am the way, the truth and the life: no one can come to the Father(God)(in Heaven), but by me." (John 14:6) This means that if you die without trusting in Jesus Christ as your Lord and Saviour you will die in your sins and be
  176. Does excel recognise names rather than cells?
  177. Excel 2003 - Find records
  178. were can i find a beginners guide to pub bookeeping
  179. How do I use 3 cells to create the string for a lookup function?
  180. vehicle fleet maintenance
  181. how does excel read only odd numbered rows of data froma column?
  182. Re: Stop text from stringing into next field when empty
  183. Import various Worksheets
  184. Computing full Months
  185. Using Combo Boxes as a function
  186. convert $ value to day values
  187. LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied.
  188. Count Position of Filtered TEXT cells in a column
  189. How do i convert feet and inches to a decimal value?
  190. Macro problem
  191. Re: Stop text from stringing into next field when empty
  192. Help with formulae
  193. PDF button
  194. Sheet Name
  195. Problem with small()....I think
  196. How Do I Get a date reference when linking excel worksheets?
  197. Re: Stop text from stringing into next field when empty
  198. How to count number of occurences in an autofilter list
  199. What is the formula for bank account row balance column
  200. vlookup with lookup value of different length
  201. cell colour change
  202. HELP: Last row of the column containing blank cells between non-blank cells
  203. Re: Stop text from stringing into next field when empty
  204. Excel needs hh:mm where hh>24 for hours worked per week
  205. User cannot save excel file in workbook
  206. How do I set a result of an "if" function to NULL; not 0 or ""?
  207. shading problems
  208. How do I link a certain number to a certain word?
  209. need sample of work with senarios in excel
  210. Swap data from one cell to another
  211. VLookup not recognising numbers
  212. Numbering every second row
  213. Conditional Formatting Intermittent at best
  214. Count Position of Filtered TEXT cells in a column
  215. Now()
  216. convert a range of lowercase text to upper text or vice versa
  217. How: Functions repeating...
  218. Is Indexing the right option?
  219. caluclated field in pivot table?
  220. Form Text Boxes moving
  221. Auto Update Sheet Tab
  222. Searches
  223. Is it possible to do a vertical lookup that matches on 2 criteria
  224. Working back from IRR
  225. using multiple split cell references in linest
  226. How do I group data using defined ranges?
  227. How do I obtain the address of a cell using the vlookup function?
  228. I want data on sheet 1 to input into sheet 2 also
  229. Is there an AVERAGE IF function in Excel?
  230. How maximum different creterias for excel filter?
  231. how do i set up a cell in excel so that it shows the current date
  232. incremental years
  233. continuing dropdown lists
  234. formulas won't calculate
  235. linest won't accept multiple reference ranges
  236. Multiple Criteria IF Nesting
  237. How do I make a working calendar
  238. sumif function
  239. how do an @if formula to meet criteria where x is divisible by 12
  240. link from rows to columns
  241. Multi-level Subtotals with Excel 5.0 data
  242. Adding numbers to current numbers
  243. Same Value In Multiple Cells
  244. How get true response when numbers divisible by 12?
  245. Adding Parenthsis to a Cell
  246. Updating Links to Other Excel Files
  247. #VALUE error when referencing spreadsheet on sharepoint library
  248. Excel - sum a column of sales monthly and quarterly?
  249. Adding a space with =A59&B59
  250. formula request
  251. Missing keyboard shortcut - CTRL+SPACEBAR
  252. can I turn off the memory carry-over from previously typed cells
  253. Re: Need to add a certain percentage to a column of prices
  254. Can SUMIF function include AND function
  255. Vlookup
  256. How do I move up rows below blank rows in an address?
  257. copy ranges from multiple worksheets
  258. Auto Data Transfer
  259. Re: Formula(s) for area with more than four sides
  260. Please Help with TRANSPOSE
  261. if functions with more than 7 ifs (ranges are possible?)
  262. Automating copying of data from different worksheets.
  263. due date for payable invoice
  264. Is it possible to calculate integrals with Excel?
  265. formula won't work unless column of data is a hard number
  266. Format Number to Text
  267. Help with a COUNTIF (I think)
  268. Adding percentages in a column and automatic formating of contents
  269. How can I use an "IF" command to compile different info?
  270. Data Validation circles
  271. IF and SUM
  272. Trouble formatting
  273. Rows containing "#N/A" are messing with my formulas, please help
  274. SUMIF
  275. Linest: problems using broken reference data
  276. Formula shown as a formula rather than it's result
  277. Creating Worksheet using Server Object
  278. RE: How to apply a format to an entire workbook
  279. Enter a customer name in the invoice workbook when the names are .
  280. Using COUNTIF to find numbers within a range greater than the mean
  281. underscore between name in excel csv format to export names into o
  282. RE: How to change a formula in one cell and have these changes appear
  283. RE: How to change a formula in one cell and have these changes appear
  284. RE: Modify SumIF... Array Formula
  285. RE: Excel should have a formula for Converting Julian Dates
  286. How do I insert a symbol BEFORE text for multiple cells in Excel?
  287. How to apply a format to an entire workbook
  288. Using COUNTIF & compare 2 different #'s
  289. How do I use graphics in spreadsheet cells to look up later?
  290. How to total itmes if they fall between a date range
  291. Arrows move worksheet rather than cell selection, how fix?
  292. RE: Reverse the sign of a number in a cell
  293. Excel should have a formula for Converting Julian Dates
  294. Reverse the sign of a number in a cell
  295. How to change a formula in one cell and have these changes appear
  296. Modify SumIF... Array Formula
  297. how do I nest functions
  298. Function to reverse the sign of a cell
  299. Manipulate an excel column
  300. Copy page format into an entire workbook
  301. Hyperlinking when it shouldn't...
  302. need some help on the right function to use..
  303. pasting from one excel workbook to another
  304. OR function
  305. Distribution functions
  306. Link a list of employees with hire dates to a monthly schedule
  307. How to copy without copying
  308. CAN ANYONE PLEASE HELP ME????
  309. Looking Up Value Using 2 Criteria
  310. Articles recommended to read, where can they be found?
  311. How to unprotect Grouping controls
  312. Stripping time in Pivot Table Column Header
  313. HIGHLIGHTED NUMBERS NOT SHOWING SUM AT BOTTOM WANT IT BACK
  314. vlookup
  315. counting nonblank cells
  316. Help with lookup table
  317. Tool Tip when mouse over
  318. file links - arrays???
  319. Help! Activate worksheet from a listbox
  320. Calculations too long
  321. dates formula
  322. How can I do finacial ratios with workings using excel?
  323. Hold a value while recalculating another?
  324. tool tip to open when the cell has the focus
  325. Icon is a hand permanently
  326. Re: list a column in alpahabetical order
  327. Copy worksheet without absolutle references
  328. Autofilter in protected sheet
  329. how do we calculate T-bill Price in 365 days year.
  330. Pivot Table - Preserve Formatting
  331. vlookup only a set of values.
  332. Create a formula to remove text to the left of specified char?
  333. insert symbol
  334. formulas
  335. C1 appears blank, but ISBLANK(c1) returns false
  336. Pivot Tables - updating individual columns
  337. How to compute StDev of only nonzero entries in a range?
  338. how to imort data in to excel file from other excel file?
  339. How to combine Hyperlink with Lookup function?
  340. Calculate month-end date from date in adjacent cell?
  341. I need to put 4-5 sentences into one cell.
  342. How do i round up a price to the nearest 5,10,15 etc pence
  343. Formula
  344. Height/Width measurements
  345. Consecutively Number Purchase Orders
  346. Function syntax to compare cell contents
  347. Help with a hide row macro (not using filter)
  348. RE: i want to create a simple mailing list can u help
  349. RE: LOOKUP
  350. RE: How to Insert function right on text values e.g. 0180001640
  351. How to Insert function right on text values e.g. 0180001640
  352. pivot table dates are out of order how do I correct them
  353. Filling an array with data
  354. RE: Need help setting up a >< IF formula in Excel,
  355. extra results in the MAX function
  356. Linked files
  357. i want to create a simple mailing list can u help
  358. List of start of months
  359. RE: Excel: hold a reference to a single cell when copying formulas?
  360. LOOKUP
  361. RE: separate data in a column in excel
  362. Excel: hold a reference to a single cell when copying formulas?
  363. separate data in a column in excel
  364. stopping backup of Excel spreadsheet
  365. Need help setting up a >< IF formula in Excel,
  366. How do I insert something on multiple worksheets in one workbook?
  367. Logs and Antilogs
  368. Petty Cash Log Help
  369. locking information
  370. If I have the zip code can I make it put the city in another cell
  371. Help with: ListBox1.AddItem (ws.Name)
  372. deleting certain text from cells
  373. Subtracting time
  374. today's date
  375. Capture first 2 letters from a product code
  376. enable Excel to recognize Cell Colors
  377. working with dates in fiscal years
  378. Time for some help (Please!)
  379. vlookup using two table ranges
  380. RE: Need to add a certain percentage to a column of prices
  381. RE: Need to add a certain percentage to a column of prices
  382. How can I create a formula out of more than 7 functions in excel?
  383. Text to equal "0"
  384. Transferring info between worksheets
  385. summing an array by product category
  386. Date Calculations
  387. Help crating a formula with various arguments
  388. How do I lock footers in Excel?
  389. Macro problems
  390. How do I apply a formula to #s already typed in a series of cells
  391. How can I add more dates to the employee operations timesheet
  392. fill down array to last available row
  393. Counting the number of checkboxes on a spreadsheet
  394. * * * Important Please Read * * * May 18, 2005 7:07:02 pm (Best Viewed at 1024x768) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
  395. add 3 non-adjacent % cells visually = 99.9, total shows 100.0
  396. Re: How to export xls file into CSV file
  397. RE: How to export xls file into CSV file
  398. REPLACE outside of highlighted column
  399. UNDO - how many times can I UNDO?
  400. sort sheet tabs in Excel
  401. Saving a sum
  402. i want to delete first 11 chara in for =$C6*F6-(F6*G6*$I$2*1.15)
  403. Omit/bypass cells in column equations
  404. Date and Time Formula
  405. Clean does not remove hidden formatting on a number
  406. How do I Pick a cell with highest value from a range of cells?
  407. round up a percentage formular
  408. new speadsheets open in seperate window
  409. search for word/number in excel workbook utilizing all tabs
  410. Cell Format
  411. How Do I format an Excel sheet to have a 3D effecrt in rows?
  412. How do I delete data in a column from a certain point on?
  413. Can you extract URL values from a list of cells?
  414. How to return # characters based on 2nd instance of value
  415. Index and Match issues
  416. Can you change the base number from 100 to something else with %'s
  417. how do I copy the contents of a cell from one workbook to another
  418. How do you change a drop-down list in Excel?
  419. whiting out error messages
  420. Auto Fit
  421. Vlookup reporting #N/A's
  422. format cell from data input to output form
  423. IF function?
  424. errors using Vlookup
  425. Dates in Excel linked with Outlook Calendar
  426. How do I search for more than one text character in one cell?
  427. How do I turn off Mouse Scroll in Excel(Shift key 5-times)?
  428. How can I search for more than one text character in a cell?
  429. Paste data repeatedly from different worksheets to a template
  430. Cell Password Protection-Multiple Worksheets
  431. trace dependents
  432. How can I repeat labels in a Pivot Table?
  433. search more than one character
  434. excel 2003 questions
  435. how do I auto cut & paste from one spreadsheet to another?
  436. Trouble with formula
  437. Is there an adjustable rate amortization schedule in Excel?
  438. can I delete entire row if adjacent cell formats differ?
  439. VLookup Errors
  440. subtraction of times, convert & multiply by a conditioned rate
  441. Auto filtering & COUNTIF
  442. MODE FORMULA ERROR
  443. Access link "add in" for excel
  444. Number of years, months, days between two dates.
  445. add time to cells
  446. conditional text
  447. How can I combine the functions of a vlookup and sumif without a p
  448. How to apply the same background to many sheets simultaneously.
  449. Changing cell formatting with IF function
  450. Cell C1 ="error" if....
  451. Using Index with text
  452. Identifying cursor in active spreedsheet
  453. different currencies
  454. calculate number of working days
  455. getting a formula to find named worksheets in another?
  456. Not displaying #VALUE errors
  457. How do I use find in a macro in Excel
  458. Nested subtotals don't work properly after applying recommendation
  459. validation and omitting blank vaues from list
  460. e-mail address formatting
  461. how to merge all worksheets into one
  462. Excel prompts me to save a copy or overwrite file.
  463. Allow for COPY/PASTE in the "Comment" area
  464. Using a Macro to clear out check box seletions
  465. Edit cell automatically takes you to cell
  466. Pivot Tables
  467. How do I set up time tracking formulas?
  468. dragging without interference
  469. Re: Time Calculation in Minutes only ?
  470. OT- Need to create an 11 & 12 man Duty Roster
  471. Conditional Format Formula Needed
  472. RE: string of numbers
  473. RE: Vlookup reference a worksheet
  474. RE: Vlookup reference a worksheet
  475. string of numbers
  476. I need an add-in for Excel 2002 to convert xml to xls
  477. average of visible cells in a filtered range
  478. RE: replace absolute references
  479. Vlookup reference a worksheet
  480. Sumproduct....I think
  481. RE: percent formulas
  482. replace absolute references
  483. RE: Time Calculation in Minutes only ?
  484. copying with hidden cells
  485. pasting data over hidden cells
  486. percent formulas
  487. Re: Time Calculation in Minutes only ?
  488. formula to show ranges in columns
  489. Drop down menu
  490. month to month % change
  491. printing gridlines
  492. IF forumla for time
  493. XIRR
  494. user input function
  495. finding the no. of rows in a COL filled with numbers, zeros and bl
  496. How can I create an array formula for non-sequential cells
  497. What formula can I use to get daily totals from list
  498. Keeping date format of a field inserted from an excel database
  499. Sum Activecell Offset Problem
  500. How to Reverse Contents in an Excel cell (Text or a Number)
  501. automatically adjust numbers in a column when data is deleted
  502. Entering from List box
  503. Match and index functions: corrlating data from 2 worksheets
  504. Excellent=1, Good=2, etc.
  505. Using Tab Key In Excel
  506. validation
  507. Choose between two cells the lower result of a formula
  508. how do i nest more than 15 " if " functions in a formula
  509. Bill Payments
  510. copy one to cell to another by clicking and dragging
  511. Sorting data automatically
  512. Working with Sums
  513. Match Backwards
  514. exchange data between two files
  515. arrays in excel
  516. Error Messages
  517. TESTING FOR EROR
  518. Excel Server Object won't overwrite
  519. Where do I find
  520. HELP
  521. Extract using MID function ?
  522. formula help please
  523. Different Formats for Multiple Sheets within a Workbook
  524. Combo Box conflict with 'sort' on another page
  525. Transpose unique values in one column/mult. rows into a single row
  526. two-column lookup
  527. Match two lists and return a value
  528. data validation list drop down text format too small
  529. CELL function within HYPERLINK
  530. nesting more than 15 if functions in a formula
  531. mix text and formula?
  532. MS Query grouping
  533. Conditional Formatting
  534. HOW NOT TO CALCULATE CELLS IF ONE CONTAINS "0"
  535. Calculating a bill using a graduated rate...
  536. Formula, Help needed
  537. Numeric formatting problem
  538. if a number is less than -1000 in Excel 2003
  539. Indirect Row & cell formula
  540. need help have audit and i'm going to get slaughtered unless
  541. How do I rotate Horazontial cells vertical, so part of the chart .
  542. Help with a COUNTIF, Please
  543. Range("C9:V9").Select ==> changing the 9 to a variable
  544. sum letters ex. d+d+d=3d
  545. changing cells in multiple worksheets
  546. How to sum total automatically in more than one sales invoices
  547. Summation format
  548. how many condition for conditional sum wizard ?
  549. Formulae using range names
  550. print different row titles in one sheet w/ many pages
  551. Vlookup Sum
  552. Vlookup Sum
  553. COUNTIF
  554. Pivot tables design
  555. offset problem list not sequencial
  556. Calculation conditional on yes no
  557. Document Properties
  558. Change Text-color depenting on SUM-function
  559. Hiding zeroes in Office 2002
  560. Re: user defined function
  561. Header or Footer to show up on multiple sheets in a document
  562. Consecutive cells
  563. Re: user defined function
  564. RE: IsNA(match
  565. Vlookup and Now()
  566. Cell Format
  567. Excel should let you sort by subtotals
  568. IsNA(match
  569. If then syntax
  570. list all conditional formats
  571. How to combine two columns?
  572. IF with AND and OR
  573. Highest Value / Circular Reference Help
  574. how to remove header in excel on second page of document
  575. convert text to a value to be used in a formula
  576. Can you substract dates?
  577. Re: sort a list/remove additional entries
  578. How do I insert Sunday,Monday,Tuesday, etc. to repeat in nonadjac.
  579. sumproduct
  580. RE: sort a list/remove additional entries
  581. RE: sort a list/remove additional entries
  582. RE: sort a list/remove additional entries
  583. RE: SUMIF with 2 criteria PLEASE HELP
  584. how do i reference data in a file with the fname in another cell?
  585. Cell Protection
  586. sumproduct external reference
  587. Passing Variable to LINEST
  588. sumproduct external reference#2
  589. vlookup error na#
  590. Free Tool (Add-in) To Speed Up Your Data Processing
  591. Re: sort a list/remove additional entries
  592. Is there a way to search for info in your excel document?
  593. how do I insert a row based on a function result
  594. vlookup problem
  595. Referencing Literal Arrays
  596. Combine two spreadsheets using Macro
  597. can you use cell references from Microsoft spreadsheet in excel ch
  598. Re: Lookup + Sum multiple columns
  599. excell worksheet - how do I get the grids to show?
  600. Limited logins
  601. Fill array with fn variables that vary across and down?
  602. Taking data from 3 columns to make the fourth.
  603. Formula for Excel User Name
  604. identify even numbers with a "1" and odd numbers with a "0"
  605. why is my blank cell not a blank cell
  606. SUMPRODUCT + DATE = 0
  607. SUMPRODUCT + DATE = 0
  608. Date/time Duration
  609. I wish to save my Excell work in my work sheets
  610. cell formatting
  611. Re: Excel Function Help
  612. SUMPRODUCT or SUMIF or ...
  613. Formatting Text
  614. COUNTIF and then SUM in Same Function
  615. SUMPRODUCT or SUMIF
  616. HOW DO I LOOK UP AVALUE IN A TABLE WITH USING 2 DATA SOURCES
  617. volatility calculation
  618. Help with IF and drop down lists on a look up
  619. Sort formula
  620. offensive postings
  621. Re: HELP with this function
  622. Paste Functions and Update info
  623. Function Question
  624. Book1.xlt in XLSTART folder
  625. Hex low values
  626. EXCEL ARRAYS & IF STATEMENTS
  627. what function can i use to tell me if 2 text cells are the same?
  628. weeknum function returns name error
  629. insert rows in excel spreadsheet via macro
  630. Need a function that separates over-lapping work shift hours.
  631. Excel database
  632. SUM IF and two variables
  633. Splitting multiple cell contents containing values at end
  634. HLOOKUP FUNCTION
  635. conditional if based on a word value...
  636. Excel database
  637. How many in column
  638. Spreadsheet will not print out legibly even after scaling
  639. RE: how to automatically color a cell
  640. RE: help with offset function
  641. How do I create a ratio function in Excel?
  642. help with offset function
  643. will excel work out algerbra
  644. CALENDAR
  645. Unix Time Function
  646. how to automatically color a cell
  647. Multi Variable Formula
  648. Calendar
  649. IF Worksheet Function
  650. Conditional Formating
  651. IF function: Reference cells - Value vs Formula
  652. Counting Dates
  653. Help with my MLB Formula
  654. Excel Match value_lookup asterisk syntax
  655. CORREL formula with criteria
  656. hide errors when printing
  657. Converting number of days to years and months
  658. what is an advantage of using a model?
  659. formula to analize info in a cell
  660. Automate grading of performance test results
  661. {} SumIf and CountIf
  662. Formula that looks at two columns
  663. how to get a cell on a page to equal the bottom most cell on dif
  664. formula to standarize cell length
  665. Updateing formulas
  666. Deleting Macros
  667. Customized Formats
  668. Finding negative and positive diffrence
  669. changing value of a cell by selecting an item from a drop down list
  670. How do I create a macro, that references another excel file ???
  671. Formula including dates
  672. Re: Mode Function??
  673. How do I Double Conditional vlookup for 3 columns?
  674. conditional lookup
  675. Have Vlookup return a Value of 0 instead of #N/A
  676. Adding an accumulator for multiple cells
  677. Column A
  678. Excel - IF Formula and #DIV0!
  679. color filled cell invisible on work screen
  680. Counting dates in a column
  681. How do I Print the Results of a FIND ALL from multiple worksheets?
  682. on exel how do I can take out the ceros on the woksheet?
  683. re:Nested Function
  684. Mulitple conditonal match / Vlookup
  685. limit of 7 nested functions?
  686. how do i define a range as a list when there is no list option in.
  687. Average of an array of entries, minus the lowest entry
  688. excel not linking
  689. trying to write a formula ivolving data validation
  690. Condional formatting
  691. Forecast problem
  692. solver- maximum profit
  693. Subquery
  694. pivottable and OLAP cubes
  695. Re: removing character from field
  696. RE: removing character from field
  697. calculation of interest between two dates
  698. PASTE DOWN FUNCTIONS
  699. How can I move the comment box to the left of the cell?
  700. find the cell above any number in any range
  701. Be able to move not delete filtered records, to see the duplicats
  702. help with formula please
  703. Highlight rows as you scroll through spreadsheet
  704. Cursor movement
  705. allow macros in protected worksheet
  706. Pivot Table Field Settings
  707. Re: copy 45 rows down, repetativly, only on button click?
  708. Re: Help with Aging Report
  709. Re: copy 45 rows down, repetativly, only on button click?
  710. splitting text within parenthese into new column
  711. Conditional Formatiing
  712. count
  713. Excel
  714. Clearing Check Boxes and Cells
  715. Want Excel to break links between worksheets in same file
  716. creating a formula for a timecard obiding by CA OT laws
  717. Automatically scrolling to top of worksheet
  718. SumProduct?
  719. Average top 10 or bottom 10
  720. finding what numbers are in a string
  721. Where can I post Macro questions?
  722. Passing selected workbook name and values to a macro
  723. Conditional Formatiing
  724. IF Problem
  725. Searching for multiple conditions
  726. links in a cell
  727. Format from Access to Excel is busted...help...
  728. countif two variables in two different columns
  729. Excel function countif???
  730. Using data in cell for a formula
  731. Transposing a column to several rows
  732. counting only specific numbers in column
  733. adding part of a function on condition.
  734. easy DSUM question
  735. How can I make a number e.g. "14" appear as a word e.g. "fourteen.
  736. How can I convert a date into a week number...
  737. Counting a day of the week
  738. Hiding/Unhiding
  739. Wildcards in formulas?
  740. excel calculations
  741. indirect and offsetsheet
  742. generate multiple rows based on cell value
  743. Subtotal on SumIf
  744. number formatting question
  745. Space between decimal numbers
  746. convert number to text in Spanish Language
  747. How to Sort Protected Worksheet
  748. Counting a list
  749. How do I Concatenate these Dynamic Rows
  750. Consecutive Cells
133