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. How to create compounded int table?
  2. Statement of Account
  3. Subtracting Hours - Eastern to Pacific/Central
  4. THE CUMIPMT() IS NOT PRESENT?
  5. Query
  6. Hlookup/max value?
  7. how do i get a set of pieces from a given # with standard lengths
  8. VLOOKUP range lookup
  9. Pivot tables
  10. vlookup question
  11. How torecord the highest value in a set of constantly changing num
  12. Merge and sort pages of data
  13. IIF issue
  14. Cant Get IF(ISBLANK) to work
  15. [R2]*-1 HELP
  16. I am trying to match 2 lists
  17. count and display unique values
  18. getting value 1 column to right of cell selected in pulldown
  19. find selling price of bonds
  20. Suppressing zero value display in print-out
  21. Totalling Collumns
  22. how do i use more than 3 conditional formats settings???
  23. Allow to "wrap" columns of data in Excel.
  24. Link to Cell Not Updating
  25. How I sort data in Excel, it keeps saying "merged cells must be ID
  26. Columns and Rows
  27. inserting sheets into existing workbooks w/o external references
  28. HOW CAN I CONVERT NUMBER IN A CELL TO TEXT EG: 100 TO ONE HUNDRED
  29. Combine 2 Data Validations Q
  30. date format and the RIGHT function
  31. date format and the RIGHT function
  32. date format and the RIGHT function
  33. valuing a labelled odds formula '15/8 I want result 1.875 ??????
  34. If Statement and Dates
  35. Removing "Save As" Command from an excel file.
  36. sum limit and marking
  37. static data consolidation
  38. Sort text list alphabetically using a formula
  39. VLOOKUP result is not showing up - only the formula
  40. Cascading Lookup Functions?
  41. Lookup function or something like it...
  42. When using Autofilter on Excel, how do I ignore 1st 1 or 2 rows
  43. synchronizing (?) two worksheets
  44. Multiple sheets as data for a single sheet
  45. If columns match
  46. How to find if a date falls between 2 dates
  47. What is the Formula to find the Media of a number of cells?
  48. Can Excel count the number of scores within a range?
  49. Spreadsheet performance is slow
  50. help.. too difficult to put into words
  51. Get rid of the zeros?!
  52. Adding numbers in a column results in zero: why?
  53. Advanced Filter criteria (formula)
  54. Select Largest 5 in A, AVG values in B
  55. Locking A Formula In A Cell
  56. Returning next value from a list
  57. time stamp
  58. Auto Filter Subtotals
  59. Division by Zero Error
  60. Excel Macro Question
  61. count records meeting three criteria
  62. How to write the formula for time accounting for a work schedule
  63. Value returned from Formula changes with the Date
  64. how do I find my old questions
  65. Sumif across multiple worksheets
  66. Multiple Functions In One Column
  67. Select from List of names to equal a specific rate
  68. RE: Simple Question
  69. Add/Replicate Text In Cell Entry
  70. RE: Simple Question
  71. formatting number value to text value in excel
  72. Autofill Date/Time
  73. Assigning values to letters
  74. reset option buttons
  75. lookup with a formula
  76. empty cell equivalent value
  77. How do I get rid of formulas?
  78. Re: Conditional Formatting when inserting a row
  79. Re: Wildcards
  80. Vlookup accross multiple worksheets
  81. Protect hide worksheet
  82. Re: Wildcards
  83. worksheet linked to a cell
  84. creating a date column from seperate data
  85. European Average Weight Legislation Formula
  86. Gaussian Elimination
  87. Changing Imported Date Formats
  88. Changing Imported Date Formats
  89. Correcting a #REF!
  90. vLookup - display multiple rows
  91. summing characters in a string
  92. Watermark
  93. clear all except formulas, conditional formatting and validations
  94. Urgent! Somebody Pleez help!! Inventory Valuation
  95. Rank by flight
  96. Calculating market growth rates
  97. Need to rebuild formula using the value entered into a cell on the
  98. worksheets
  99. Pivot Table Summaries
  100. Summarizing data based on ID
  101. Index Row
  102. Copying text from a free form field
  103. Calculated fields in pivot tables
  104. Syntax for IF with multiple criteria
  105. Linking Data from 1 sheet to another sheet
  106. Calculating total work week hours
  107. Calculate Term
  108. find the value of the last digit in a cell
  109. conditional formatting and timelines
  110. How do I use cell contents as an address in a formula
  111. show a block of info from a list on another worksheet
  112. Adding a Baseline Value into my existing column graph.
  113. How do I Hide frozen panes when printing?
  114. test for "special characters" in text
  115. replace formula
  116. Conditionally formatting other cells?
  117. get back to day one based on current date
  118. If statement to avoid Creating Circular Reference
  119. sum calculation
  120. Calculating a colmun to total a 40 hour work week
  121. Excel - print 2 pages on 1 sheet of paper
  122. group same
  123. Truncating a text string
  124. How do I track dates?
  125. Using Max & keeping other data
  126. Find the Cell Reference Resulting from MAX function
  127. Restructuring records into a list
  128. Splitting an Excel cell
  129. Can i "filter" in excel by words in Bold?
  130. Vacation accrual based on hours worked - Excel 2003
  131. Copyright in Footer
  132. Format monetary amount to 9 digits with No decimals without rounding
  133. Conditionally ignoring certain cells in columnar calculations
  134. the numbers are always in text and i cant seem to change them???
  135. synchronization ?
  136. convert number in cell to text in another cell
  137. How change "535?4090" to "535-4090" using replace
  138. Extending Row()
  139. Auto Updating Charts
  140. How can I use a defined name in a header or footer?
  141. New Year
  142. Conditionally calculate formula in spreadsheet.
  143. Random search
  144. How do I add totals up from different sheets? A running total.
  145. Sum multiple text
  146. count duplicate records in a group
  147. Drop-down list & auto-population of cells
  148. I forgot my password in a protected column, is it hidden somewhere
  149. Excell-How to add the number of cells containing text? = a sum
  150. Average if
  151. Suming values from a xls file
  152. Hoe krijg ik = i.p.v. fx / werkte vh met oudere versie van Excel
  153. Month day confusion
  154. multiple individual comments in one cell
  155. Matching data from 2 columns
  156. Data Validation
  157. Trying to move a number in every 2nd column into a new worksheet into one colum, how would u do that? thanks
  158. How can I automatically highlight a cell that has changed value
  159. HOW DO YOU INSERT A MACRO INTO A FORMULA
  160. Excel passwords are changing when two workbooks are open.
  161. how do i transfer an excel file from one computer to another
  162. Transfering colours
  163. Daily Totals on a summary sheet
  164. Need help in numbering a column while skipping lines
  165. Re: Counting consecutive periods
  166. Greater than, smaller than formula
  167. Getting the Check Register Balance to show on another Sheet
  168. Counting cells with formula CF (not value CF)
  169. Week/month/year rollovers with PivotTable
  170. Excel should have a formula to convert number into words
  171. How to Sum Up sales data by a product category from another sheet
  172. Two cell Comparison with three different Criteria
  173. Conditional formatting
  174. RE: vlookup
  175. Protect Sheet with Marcro
  176. How to Sum Up sales data by a product category from anther sheet
  177. Excel System Error???
  178. How do I enter formula that adds a range if less than a number or
  179. Pivot Table formatting
  180. how to do normality test in excel
  181. Index and Row
  182. lookup? list data into summary table
  183. Code to protect sheet
  184. How can I change 255 character limit in 'hyperlink' function?
  185. CountIf formula results in the formula itself being displayed.
  186. Letter Counting Function
  187. Average of a >, < range
  188. Column Width
  189. Importing Data
  190. Averages
  191. How do I calculate the root of a number using Excel?
  192. lookup serch term and return sum of all values
  193. Coments
  194. formula linking "like" text
  195. links in excel change destination after sort
  196. sorting
  197. Data Validation w/ exceptions msg box
  198. adding accross sheets in a workbook
  199. In Excell-2000, database how do you extract unique records
  200. Conditionally formatting highest valued cell?
  201. Function triggering a macro
  202. Multiple criteria LOOKUP
  203. can you put radio buttons into an excel work sheet? and how?
  204. Pivot Table data source
  205. martrix help
  206. Average a set of figures which ignores 0 entries
  207. How to get auto change of name (word rama should be ram automati)
  208. DUPLICATE RANKS
  209. Conditional Formula
  210. How do I count rows in a filtered list when using AutoFilter?
  211. Formula to use to count instances of in Excel
  212. Changing today's date to the first of the month
  213. networkdays problem
  214. Multiple Sum, based on criteria
  215. Hyperlinks in a drop down menu
  216. Data Validation Function Help
  217. IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003
  218. CAPITALIZONG FIRST LETTER OF EACH WORD IN A TITLE
  219. Run macro based on time
  220. functions
  221. how do i use the vlookup with two references ?
  222. Text to value
  223. Tab Stops / Tab Order
  224. Pivot Table Question
  225. keyboard equivilent of the right-click
  226. Determine if Cell Address is within a Range
  227. Criteria in SUMIF
  228. Time calculation
  229. Can't add pay rates
  230. Allow Edit Prevent Delete
  231. Countif Question
  232. Lookup help, please
  233. How to avoid duplicate characters if only typed once?
  234. How do I show the low-price supplier from seven different quotes?
  235. character limit in hyperlink function
  236. How do I create a worksheet within a worksheet in Excel?
  237. Insert file name in cells
  238. random numbers
  239. New Worksheets in a template to be pre-formatted.
  240. Is there a function to copy an entire worksheet?
  241. use of "if" based on text in another column
  242. Crossreferencing values between 2 spreadsheets
  243. Escape character for double quotes
  244. generate word file from excel
  245. Keeping cursor in same place on all worksheets in a workbook
  246. How to count several non-adjacent cells
  247. How do I create a random sample from a list?
  248. min or max results
  249. Formatting web imported data correctly
  250. Designating a workbook reference base on a cells contents
  251. Duplicate rows forever...
  252. how do i set up a calendar selection in excel
  253. Error formula too long
  254. totalizer formula
  255. Date formula
  256. Conditional Formatting
  257. how do i model discounts in excel solver
  258. Importing relative positoin information
  259. Correlation Matrix
  260. Reference a workbook with only a partial name
  261. Importing data, and need formatting advice
  262. wHAT AM i DOING wrong
  263. Excel recalculates on startup?
  264. compare cell contents
  265. COMPARE CELL CONTENTS
  266. Drop down box of names with fixed values?
  267. Need to link/combine 5 worksheets into 1 (inventory nightmare)
  268. Allowing for variable cell reference in macro
  269. please i need an answer
  270. random number with text
  271. excel - sort, selected rows??
  272. How do I highlight a cell using conditional formatting and dates
  273. I ACCIDENTIALLY SAVED A BLANK PAGE OVER A FILE HOW DO I GO BACK T
  274. Filter unique random number
  275. How can I get a postal code in a cell - from the internet?
  276. lookup function
  277. A:1 now R1C1
  278. calculating return in a range
  279. Saving worksheet so that merge cells work in previous versions
  280. Convert Gig to Meg
  281. How to convert Number into words in EXCEL same or a new cell ?
  282. Open Hyperlinks at the same browser
  283. special row in excel
  284. Reference Cell if Found in a IF function
  285. Match function in a two input table
  286. what is the keyboard shortcut for generating a sequence
  287. Searching for the presence of specific words
  288. Basic If
  289. RUNNING TOTAL
  290. using linest excel function from msaccess with multidimensional ar
  291. #VALUE! error
  292. match problem
  293. Excel dropdown with text and value
  294. how do I convertext in cells a1, a2, a3 and covert to a1, b1, b2
  295. How Do I Ad Columns and Rows?
  296. sum up the ROW values with ref to COLUMN values!
  297. Checklist
  298. Partial String Match Using VLOOKUP
  299. Merge Row Data
  300. How to insert same header/footer across multiple worksheets?
  301. Urgent help needed!
  302. My Formula Changes on it's own?
  303. VLOOKUP show all results
  304. I would like to set a value for a range
  305. Networkdays & future months
  306. can i use a cell value as another sheet's cell reference
  307. Trouble with formula on Student 2006 learning essentials template
  308. Cell Address Matching
  309. HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT()?
  310. How do I write an Excel formula to calculate my working time?
  311. excel
  312. Vlookup and #N/A error
  313. Error messages on all programs
  314. In a table produce an value by column heading and row heading
  315. Formula in Excell
  316. Help with formula IF
  317. Linked Names in a Formula
  318. indirect returns #REF! regardless of where it is used.
  319. Page set up
  320. How do i replace #deel/0! in excel
  321. Copy workbook- Validation function
  322. Sum Unique values from 31 pages
  323. Sorting data in a cell alphabetically
  324. cell formula
  325. excel spreadsheet
  326. How can I get excel to show ALL lines of wrapped text?
  327. url
  328. Concatenate or "&" problem
  329. How to sort an Excel spreadsheet by more than 3 columns?
  330. Updating Functions (Vlookup)
  331. Re: SUMIF on multiple sheets
  332. remove leading zero from a string..
  333. Can you do an IF function whether a cell has a fill color of Rose
  334. MATCHing through multiple worksheets
  335. replace a range of #'s e.g. 1.25 to 100 with text in excell
  336. Can you do calculation for Row or Column for link reference first?
  337. Macro VBA code to name Save-As file
  338. MATCH function through multiple worksheets
  339. Sort Excel Column on Fifth Character
  340. Linking Merged Cells
  341. MS Excel
  342. Sorting Text by color
  343. Extract sub-string of number from field of long series of numbers
  344. re-arrange data in date order
  345. Divide Column A by Column B multiply Column C
  346. Consolidate of data using formula in Excel
  347. 2 different macro questions
  348. how do i link specefic cells?
  349. Excel copy and paste
  350. FIND DIFFERENCE BETWEEN >50 AND <60
  351. Timeclock Calculation
  352. Multivariate statistics
  353. 3D Scatter plot
  354. Autofill
  355. Text manipulation
  356. Text subsequences
  357. Text subsequences
  358. IFMAX Formula
  359. Loop for VBA code?
  360. How do I display time in a negative format?
  361. how 2 use if/then, if/else function.
  362. How to get nth distict value in a column
  363. =if or not?
  364. how do i sum day of the week without counting sats and sundays?
  365. Vlookup in a second worksheet
  366. LOOKUP Problem
  367. Formula produces picture file...?
  368. Excel; how do I print titles in 'Setup' when option greyed out?
  369. Web Query settings
  370. converting seconds into minutes
  371. too many characters in formula
  372. What's the difference between 2000 and 2003 when using subtotals?
  373. Vlookup with 3 or more conditions
  374. IF Statement
  375. Adjust Range in Function
  376. how do I get 8 Conditional Formats for 1 Cell
  377. is it possible ot use two or more columns as criteria in VLOOKUP?
  378. Simple, but not for me...help
  379. Insert drop-down into a cell?
  380. COUNTIF Help
  381. Sorting with formulaically "empty" cells
  382. Useing a Logrithmic y=intercept in a cell
  383. change font color on search
  384. Is there a way to compare two excel files for repetitious cells?
  385. Difficult (at least to me) formula question
  386. HELP! need a top 10 from a list of 100
  387. IS THERE A FORMULA TO MAKE E=6:00PM ETC SHIFT TIMES AND HOURS
  388. IS IT POSSIBLE?
  389. Validation Help....
  390. Scanning paper spreadsheet into excel
  391. Can I automatically sort worksheets in excel?
  392. Remove the paste function in a worksheet
  393. Using a nested Address function for a reference
  394. How to delete rows using formulas
  395. Formula to capture historical data from data that changes daily
  396. excel function reduce and increase numbers
  397. Move Data Up One Row and Add On to Existing
  398. Combo Box Properties
  399. Multiple Sums Depending on a description.
  400. Excel
  401. How do I compare 2 text columns & show differences in 3rd?
  402. automatic underlining and blue color of email addesses
  403. SUMIF exluding text
  404. I want to change the selected print area but it will not allow me
  405. Worksheet Locked
  406. Can I use a condition/formula to move a row to a different workshe
  407. how can I insert a macro into a boolean statement
  408. Look At Two Dates
  409. Making a letter equal 1 formula
  410. Need help with nested function...please
  411. Check boxes linked to other cells?
  412. Compare month to month data
  413. Counting Dates
  414. Lookup One Column - Sum Another
  415. CardText
  416. function to convert whole numbers to written text
  417. how to convert decimal numbers to words
  418. separate whole words
  419. To return value that provide data to a formula
  420. LINKED WORKBOOKS - TOTAL CONFUSION
  421. Array input in one single cell
  422. multiple nested IF statements
  423. Vlookup on a worksheet with similar values
  424. Re: sumif wrong result
  425. Special function
  426. Re: sumif wrong result
  427. Find and Length
  428. Re: sumif wrong result
  429. forcing UDF to run
  430. Count rows that match 3 sets of criteria?
  431. Terminal Digits
  432. Top 10 Text Values
  433. Greater than formula!
  434. Is this possible
  435. Does excel support multi-value picklists?
  436. How do I add times that were creted with "=TEXT(A2-A1,"h:mm")"?
  437. How do I use multiple worksheets as input for a single pivot tab
  438. How can I insert a drop down date picker to worksheet cells?
  439. How do I import cells from seoerate sheets?
  440. if a:a (range) equals january and c:c equals gas then add g:g ($)
  441. formula for negative and positive numbers in different columns
  442. Can a style be applied using a function?
  443. i want to add increments of time not time & date
  444. substitute ","
  445. ex.=($B$4+C4) in macros for row why adding rest
  446. ex.=($B$4+C4) in macros for row why adding rest
  447. Have a 6 day schedule in word 2003, can it be put into excel 2003
  448. How do I keep multi-subtotals in the same order within the report
  449. Text to Columns Question
  450. Add insurance to loan payments
  451. how to use sumif function to check date in 1 sheet is < 2 sheet
  452. Convert random numbers to text..
  453. SUMPRODUCT USING WORDS AS WELL AS NUMBERS FOR CRITERIA
  454. subtract hours
  455. check box function?
  456. Time calculations and additional 24 hour days
  457. Want to have accumulative totals in each row
  458. Increasing numbers in a column by percentage
  459. Match Single Numeric Criteria and Return Multiple Numeric Labels
  460. Modified Duration
  461. how can I use excel to automatically generate routine report?
  462. Count or Sum based on more than 1 criteria
  463. how can I sort sheets within a workbook in excel
  464. Recognizing #VALUE! as a condition in an IF Function Argument
  465. Form List Box
  466. conditional formatting
  467. vlookup data in a dynamic pivot table?
  468. Insert row number into a cell?
  469. Find, Cut, Paste and Delete
  470. Lookup and Change
  471. Excel should let me use hidden text (like MS Word) - Thanks
  472. If Cell Value < 0, Change Value to 0
  473. how do i recover a consolidated worksheet that i sorted/subtotale
  474. This formula needs to be more compact.
  475. Formula for selecting the greater of two values?
  476. trim function
  477. Re: Merging data
  478. Conditional hiding of entire rows
  479. Copying Charts and graphs to another worksheet with formulas
  480. help needed with "if" statement
  481. Why does the right 'Alt' key not work in Excel?
  482. how to check if date falls within range
  483. =CELL("filename") VOLATILE?
  484. Multiple row
  485. Multiple row
  486. Standard Deviation
  487. COUNTtIF
  488. difficult array formula
  489. how do i make a drop down list of selected names no repeatition
  490. RE: Easy entries short procedure required
  491. I LOVE THIS JOB !!!
  492. Another COUNTIF
  493. What function to determine the second small integer from a list?
  494. formula displays, not the text
  495. Match Single Numeric Criteria and Return Multiple Numeric Labels
  496. sum absolute values of a column of numbers in Excel
  497. How to paste COUNTIF function from cell to cells ?
  498. Hyperlinks doing weird things when adding columns or rows
  499. What is the roundoff error in the subtraction function?
  500. look up a list and return a value
  501. Pinewood deby sort
  502. BLANK SPACE TO A NUMBER
  503. ListBox Question
  504. RANDBETWEEN Not working
  505. Matching one column against another column of data to show the same amount of data.
  506. Excel Workbook Search
  507. SUMPRODUCT - How can I use does not equal in an array?
  508. Matching the same amount of records in one value to another column
  509. how to compute a range of cells based on another range of cells?
  510. Conditional Formatting
  511. how to compute a range of cells based on another range of cells?
  512. How to refresh data analysis tool results
  513. Subtotals do not group
  514. When copying a cell to another cell the information is duplicated.
  515. Worksheet formulars
  516. pivot tables
  517. Comparing 2 arrays
  518. Using the Indirect function with a sheet number instead of a sheet name
  519. Return list of uncleared checks
  520. TIME function
  521. how do i get $ signs out of a column in excell
  522. Time formatiing
  523. Microsoft Excel should allow layers that can be turned on and off.
  524. Incorrect Counting of IF function
  525. Which function to check any value existed withing a list?
  526. Array formulas
  527. SUM OF TIME
  528. How do I hide a value in my totals worksheet ?
  529. What function to select the last 3 small values from a list ?
  530. How can I protect Excel Worksheet and allow users to UnGroup Data
  531. Does True Have a Numerical Value
  532. Delete A Word That Exceeds X Number Of Characters
  533. Calculating Differences Uniformly
  534. can I execute and 'substring' function in Excel
  535. Inserting another currency rather than $ on excel
  536. use of vlookup in case of multiple column check
  537. What function to select the last 3 smallest integers?
  538. Re: Excel worksheet functions.
  539. Implied Compound Interest?
  540. Sumproduct
  541. Convert MS Excel data to MS Access database
  542. I sort a column, how can I have all the data skip every other row
  543. change range of cells to another currency
  544. converting Dates
  545. HAPPY NEW YEAR !!!
  546. Modify Cell sizes
  547. Modify Cell Sizes
  548. how to limit amount of numbers in cells in excel
  549. Re-post Standard Deviation
  550. Dates change the next day.
  551. years change to current year
  552. Happy New Year to All
  553. REPAIR COLOR FILL
  554. Min Function Excluding Zero Values & More
  555. Shifting Calculated Result
  556. Shifting Calculated Result - Re-Issued
  557. To Rank on two Criteria
  558. Is it possible to make a cell flash between 2 colours?
  559. Converting hours to minutes
  560. Assigning a value to a character (?)
  561. How do I stop the "Too many different cell formats" ?
  562. Pasting constant formula where referral sheet changes
  563. A logical test in the If function for blank, i.e., If blank?
  564. Find the closest match to a reference number in a row of unsorted
  565. Minimum Date Range from other cells
  566. auto move cursor after entering number in excel
  567. Integration/area under a curve VBA code?
  568. Need help with functionality more complex than VLOOKUP offers
  569. creating an aging report
  570. Trending Formula Results by Date
  571. Copy worksheet & maintain cell reference across worksheets
  572. Refer to more than one worksheet in a workbook
  573. Circular Reference
  574. time again
  575. if =0 ""
  576. Nesting of sumif formula.
  577. Matrix to single column
  578. Copy hyperlink from one cell to/as hyperlink in another cell
  579. changing colors of font in functions
  580. How to show the formula of another cell
  581. How do I add one to a number everytime I open the same workbook
  582. cell display sheet name
  583. Formula Help
  584. Sales tracking report
  585. New question, Old problem
  586. Formula help - please !
  587. Formula Guidance
  588. How can I add more than 800 days to a given date
  589. Index, Lookup and Vectors/Arrays
  590. enumerate sheet
  591. How do I convert excel xp worksheet to excel 2000?
  592. summing columns
  593. Fill Cell to the right
  594. Lookup
  595. I need help setting up a financial formulain in Excell
  596. Pivot tables
  597. A little help with a conditional formula, please.
  598. sumif more conditions
  599. Is it Possible
  600. Office 2003 Stock Action Add-In - Stock Handling Capacity/Numbers
  601. Time Formula
  602. formula help, sorting information
  603. countif
  604. bug in dates?
  605. Absolute formula moving
  606. Font change for dop down validation lists in excel 2003
  607. change font to validation drop lists
  608. Fill cells with color based on criteria in two cells
  609. Countif formulas change after doing a sort
  610. Change over time fornula
  611. Turning off date formatting
  612. Array Formula?
  613. 2D sumif loop?
  614. Highlight birthdays
  615. Decimels conversion
  616. counting consecutive absences
  617. Protect cells
  618. Insert a footnote or endnote in Excel
  619. Excel COUNTIF function
  620. Lookup Two Columns
  621. cannot shift objects off sheet after using Subtotals
  622. Copy Value not formulas
  623. Output in Column A based on Input in Column B
  624. Randomize rows
  625. Conditional based on error
  626. How do I copy a cell all the way down a column w/o mouse?
  627. printen userform problem
  628. If/Then Statement
  629. Print Macro Error
  630. Copying A Worksheet From Each Open Workbook to an new Workbook
  631. When I type a constant number I want another number to appear.
  632. userforms broblem
  633. Positioning Numeric Values Resulting from 6 Column Array Formula
  634. Limiting Entries in A List Box
  635. Search, Copy, Paste Macro in Excel
  636. Naming cells...
  637. My worksheet menu bar has disappeared?
  638. TRUE/FALSE
  639. Chart pop-up
  640. formula is not working
  641. rounding up after SUM
  642. Will a Nested IF/SUMIF function instead of VBA?
  643. If/Then calculate the average
  644. Creating Tables From Multiple Worksheets
  645. Emailed a "shared workbook" but it never came why? (AOL?)
  646. Formula for determining sales commission
  647. Find Macro across workbook
  648. customized template w/formulas
  649. Adding a date to calender to automatially generate another date?
  650. piviot table
  651. subtotal question?
  652. How do I assign a value to check box in excel
  653. If it's not a space, return the cell contents.
  654. Counting Using Multiple Criteria
  655. Using Excel for a Mail Merge
  656. Countif - Buying Frequency
  657. How do I compare two lists and choose the items that are in both?
  658. summing part of a string, excluding cells
  659. Repairing link roots when moving worksheets
  660. Summing part of a string excluding cells
  661. How do I create a commission chart based on dates worked?
  662. How to calculate CAGR for mutual fund performance using XIRR
  663. Maintain Relative Reference After Inserting a Column
  664. Update Chart Source (w/macro?)
  665. how do i copy only the coloured filled rows in excel to new sheet
  666. Help with a combination of formula's
  667. Summary of multiple spreadsheets:
  668. How can I identify the two lowest values in a row?
  669. help needed
  670. help
  671. help
  672. Matching Values from an Array
  673. Adding to a column of numbers
  674. Excel Web Query not working!
  675. =SUMPRODUCT formula help
  676. IS THERE ANY PIVOT TABLE DROP LIST FUNCTION?
  677. Comparing scenarios/forecasts in Excel
  678. how do write the amount of a number in text?
  679. Vlookup problem
  680. Lookup array?
  681. ISNUMBER
  682. Ms Excel coursework
  683. SUMIF with 2 conditions
  684. Can I delete multiple blank rows collectively?
  685. Return alternate value if VLookup can't find match
  686. Maintain mutliple original formats in a formula result
  687. countif, sumif, sumproduct - I dont know which to use
  688. how to get left or right cell info after getting the result for ma
  689. Offset formula
  690. How do I add using several worksheets
  691. I get error with "ROWS" in the formula - nested formula question
  692. Defining Cell namse after they are used in a function
  693. Date Text
  694. TIME
  695. How do I get rid of the Page # on screen
  696. conditioned functions
  697. conditioned functions
  698. Convert $ amount from excel to access? No decimals but 00 at end
  699. Format\Formula Help
  700. help please
  701. How do I get Exel to return # of hrs. worked, start time is enter
  702. DIFFERENT NAMED CELLS IN COLUMN,HOW DO I GET LAST ONE ON BOTTOM?
  703. Rounding Up Decimals
  704. List Dropdowns Disapeared
  705. Microsoft Map Object
  706. how to change a date format
  707. custom worksheet functon is changed to lowercase
  708. Sheet Protection Status
  709. Sorting Data Automatically
  710. Excel 2003 - SUM Formula - exclude cell
  711. find sum in list of of numbers
  712. want to ask salutation on a mailing list.
  713. Search range of cells, find a value, output adjoining cell. How?
  714. Function to calculate the interest of a mortgage
  715. A function to make date red if it is over 30 days old
  716. Total TIme worked
  717. Adding relevant sheets
  718. drop-down list changing according to choice made
  719. New data will not sort with existing data from copied file
  720. How to replicate 1 range to muptiple ranges at once?
  721. Hide cell value conditional on its value
  722. Adding an OR to SUM(IF....
  723. moving a macro to a new workbook
  724. Compare Sheet Cell to Sheet Column
  725. Count certain months
  726. How can you identify duplicate entries in a singe column?
  727. Pivot Tables Sum of Unique Text Entries
  728. Hidden Values
  729. Need help with some data manipulation
  730. Find first threshold violation
  731. Lookup based on fractional value
  732. "Can I create a subtab in a tab in Excel worksheet?"
  733. Conditional Formatting For A Cell Other Than The One With The Form
  734. =now()
  735. List Validation and Format
  736. Sort by conditional formats?
  737. reverse vlookup
  738. Can I create a hyperlink to another page and then FILL series?
  739. Excel Byte Calculation
  740. Merge and sort two pages
  741. How to Destoy Links
  742. I need to enter > 10 chars to left of decimal and > 5 to right.
  743. How do I get the cell address of a VLOOKUP reference?
  744. View formula results
  745. Sumif?
  746. format for 30 years amortization?
  747. Date function in Excel that updates only when a doc is changed?
  748. Find the date for monday prior to May 25th
  749. Construction Loan Interest Formula
  750. Can you auto-trigger a sound file to play when a worksheet opens?
133