PDA

View Full Version : 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

  1. Hyperlinks keep breaking
  2. fill in all combinations
  3. Add/Delect Macro
  4. Disappearing SERIES() forumla in chart
  5. Linking spreadsheets..
  6. Formula help in a circular reference
  7. MIN
  8. Update data by chaning date
  9. Last value in column
  10. How to calculate Compound Interest
  11. Determing Range Criteria
  12. If Statement
  13. Can you sort by most to least often recurring number in Excel?
  14. Spread Macro
  15. Consolidated Sheets
  16. Textbox and multiline text
  17. Combining Pivot Tables
  18. Nesting IF's and AND's - a bit of help please...
  19. excel 2003
  20. formatting column as text.
  21. Why if I put in a figure does it change it for me?
  22. Is there a formula to transfer the last value in a column
  23. fx="<="&B3 ??
  24. TEXT TO COLUMN FUNCTION
  25. A list of data with time stamps, how subtotal at 10 min intervals
  26. conditional format cells with formula
  27. Lock cell as reference not value
  28. Loan Estimator
  29. How do I create a calender drop-down?
  30. Calculating hours
  31. How do I changet a text telephone number (xxx) xxx-xxxx to xxxxxx.
  32. merged cells print
  33. Calculating with time
  34. COUNTIFS Formula Problem
  35. Macro help
  36. Is it possible to set up an AutoNumber in Excel?
  37. sumif with restrictions
  38. how to create sequential invoice numbers from a saved template
  39. Using COS in VBA, incorrect value returned
  40. Double Lookups
  41. How to Match to table
  42. Match Table
  43. Display cell name
  44. Find last column, move formulas over, copy/paste data
  45. MIN IF?
  46. Special Characters
  47. CountIF Q
  48. I would like to merge woorkbooks contained in a spreadsheet
  49. Count hours per month
  50. Count unique numbers
  51. Not Proper!
  52. Find volatile cells
  53. How do I set up a constant reference to a cell that moves?
  54. Array data to a report
  55. looking up data in a table using 2 criteria
  56. worksheet tabs
  57. is there an excel formula that tells what color a cell is?
  58. worksheets
  59. Option Button HEEEELPPP
  60. Excel shld allow for coment boxes w/ formulas 'mini popup sheet'
  61. Pivot table
  62. Fixed objects will move warning in excel 2003
  63. Conditional AVERAGE?
  64. Function Help
  65. change cell contents to bold
  66. Criteria
  67. Merging to data sets
  68. Address & Match
  69. Links to other workbook
  70. How to customize number to 10 digits including 2 digits after deci
  71. Timeline Start date forward
  72. What is the little green triangle???
  73. Conditional Formatting - new data
  74. two dimensional arrays
  75. Using data validation
  76. Counting # of cells with that meet criteria in two columns
  77. Cond. Formating
  78. recording a macro
  79. Repeat symbol in a cell??
  80. Odd Lookup
  81. How do I copy records with specific text from one wkbk to another
  82. Pivot tables, IF statements, vlookups?
  83. Average Time
  84. If Then
  85. extracting email
  86. sum all value
  87. Counting blank cells in a formula
  88. Pivot Table from Access DB
  89. Finding Duplicate files in Excel 2007
  90. Protecting Multiple Worksheets at the same time
  91. hyperlink - PDF file - relative reference
  92. code to delete sheets not in use based on a cell's drop down list
  93. Drop Down Menu
  94. Highlight data that doesn't fall within certaint range
  95. Creating a percentage mark up
  96. Autofill Down When Text to Left is Not Blank
  97. Need help with VBA
  98. Week Ended Friday
  99. finding values in a table using 2 criteria (changed)
  100. Count Continuous data between cells
  101. Keyboard shortcut for List Box
  102. send me the total excel question and answers with tips to mailid
  103. Rounding up values
  104. Find text and print its corresponding worksheet name and row
  105. Excel / Access User Conference - Oct 24-26, St Loiuis
  106. HOW TO LOCK THE OPENING OF AN EXCEL SHEET?
  107. Insert picture and let it automatically be copied to other sheets
  108. Auto Filter
  109. Conditional formatting compatibility with excel 2003
  110. Consolidating Data
  111. automatic age range formula
  112. PIVOT TABLE ????
  113. how to change the alphabets to numbers and numbers to alphabets in
  114. modified if equation.
  115. Formatting text within functions
  116. linking to workbooks together
  117. Complex Lookup question.
  118. Comparing similar but inexact text
  119. change negitave value to positive
  120. vlookup if statement returning a "false" answer.
  121. NEED HELP QUICK!
  122. Rank function
  123. Can I use 'CONTAINS' in an IF Logical Test?
  124. Pivot table woes
  125. Excel Formatting
  126. Counting if Something Occurred During a Time Span
  127. Do not allow negative numbers in cell
  128. Keep formulas when copying data
  129. Hide Cell based on value of other cell
  130. V lookup with 2 criteria to return results for multiple columns
  131. Complex Lookup Question - Clarification?????
  132. How would I use one cell to look at two different vlookups?
  133. Summation over a range
  134. Converting Metric to Imperial
  135. consecutive bi-monthly dates
  136. External Data - Stock Quote
  137. Starting payment when increase rate is known & total payment is kn
  138. Hide cell based on value of another cell
  139. Removing HTML from EXCEL?
  140. Function does not work in a cell. Please Help
  141. Formulas Using Words
  142. include in new column only if present in both columns
  143. Using VLOOKUP (ISNA) function to compare 2 columns on different worksheets in excel
  144. help linking information please
  145. Converting time as 7.5 (which represents 7:30 AM) to 0730
  146. Calculation using VLookup
  147. bringing data together from two worksheet for comparison
  148. Sumproduct w/ Array & criteria
  149. If statement with Vlookup - including ISNA function to compare two columns from different worksheets
  150. Help with Baseball Formula
  151. Need help with range of cells
  152. Lookup, and Return Cell Address
  153. Password Protect a single sheet using VBA
  154. VLookup Function ?
  155. COUNT CELLS WITH CONDITIONAL FORMATTING
  156. displaying pictures
  157. Sub CommandButton1 help
  158. Creating summary from a list
  159. SumIF referencing to a CELL, rather than text....
  160. AutoFill in a Column
  161. find number of occurences of text within a column
  162. I was using Excel 2007, now 2003 and my Macros won't work
  163. Counting Charaters
  164. Address Row and column Reference
  165. Question Pulling Data from another sheet
  166. from 1 work sheet to another
  167. External reference not working
  168. Additional Help with range of cells
  169. Calc
  170. Whats better Lookup or Function Formula
  171. Formatt date from text
  172. Scientific Notation Issues
  173. Trying to count differences between columns
  174. Formulas aveages in excel 2000
  175. Deleting unwanted lead spaces throughout a worksheet
  176. Selective Calculation of Mean & Mode
  177. sumproduct question
  178. Blanks counted when highlighting group of cells
  179. Vlookup with IF question
  180. league table
  181. Average If Array Formula
  182. Setting formatting for 2 places
  183. count based on selection from drop down list
  184. Copying Filtered Data in Excel 2007
  185. Complex Lookup Formula
  186. CountIf
  187. Another formula question.
  188. I need help with a Function
  189. Nested MATCH with two tables
  190. Help with if funktion
  191. Drop-down box lookup?
  192. greater than larger than
  193. weekly time sheet for the whole team?(6 members)
  194. How to find largest value "<=" when array is in descending order?
  195. Top 10 in descending order
  196. How do you enter a tick symbol into a spreadsheet cell please?
  197. HOW CREATE FORMULA TO ADD THE COLUMN CELLS THAT CONTAINING DATES
  198. How to Make cell value flashing in EXcel file
  199. soccer tournament template
  200. Counting Occurences In A Column
  201. Sumproduct to return a text
  202. Vlookup
  203. Stock Smart tag Cannot update the current sheet
  204. Input Text Upon Click Of Cell
  205. Data Validation list
  206. to sinalize not sequential number
  207. Column of negative numbers
  208. Active cell position for macro
  209. creating links in between worksheets
  210. Get Cell Address From Lookup (Alternative to Lookup)
  211. HOW DO I UNDISPLAY FRACTIONS?
  212. help to find a string for 4th occurance
  213. Excel
  214. vlookup error...
  215. How to create a countdown timer in a worksheet
  216. formula output
  217. Frequency of numbers in a range
  218. Exporting data to excel in .NET 2005 C#
  219. Can I Use a Count Function for Text?
  220. converting survey angles to decimals
  221. Numbers
  222. Find a Day in a Calendar
  223. Charting
  224. Filling Sheet numbers in a column
  225. VLookup Last Entry
  226. Link to other Worksheets - when data is added updates master works
  227. How to copy formulas between workbooks w/0 referencing source?
  228. Difficult formula! Need help quick!
  229. Negative number morphing to a cell code
  230. Leading Zeros causes rule error message
  231. Functions for manipulating arrays
  232. Macro that reformats data in excel spreadsheet
  233. XML Schema Editing
  234. Copy down a range of formulae
  235. How to auto-increase values in currency formatted cells, by 10%.
  236. How to auto-increase values in currency formatted cells, by 10%.
  237. How to auto-increase values in currency formatted cells, by 10%.
  238. MAX() and MIN()
  239. help with countif function
  240. Time-shifting information
  241. SUMIF ranges
  242. #DIV/0! How do I remove this answer?!?!?
  243. Nested IF function???
  244. Linked cells
  245. Vlookup or another function? Help!
  246. Workbook Headers
  247. Rename worksheet in macro
  248. IF, then
  249. Vlookup question
  250. Format Currency in-cell
  251. Stumped Conditional Formatting or Validation?
  252. Data validation combo box lookup
  253. linking spreadsheets
  254. Counting Consecutive Instances
  255. Filter lines containing pivot table and non pivot table data
  256. Can you link to a drop down list from another drop down list?
  257. Getting error using if then else stmt
  258. looking for a function to make it more quicker
  259. sum with multiple criteria
  260. Populate an array that is a subset of a larger array?
  261. Populate a form from a sheet in same workbook
  262. Merging Document Help
  263. how do I average cells if a cell is at #div/0!
  264. Automatically alphabetize excel worksheet
  265. Conditional Formating
  266. Counting Unique Values with Multiple Criteria
  267. number up one
  268. Hide columns and rows
  269. Macro/code to hide rows
  270. Absolute Reference to the Left Until Change in Row
  271. !
  272. Consolidation Worksheet Data Sequence.
  273. Sum If functions
  274. VB count word occurence in variable size sheet
  275. Changing the font of a cell dependant on the outcome
  276. Excel: Round formula up in $5. increments =+(M4*1.1)+M4
  277. MATCH Multiple Criteria & Return Previous / Penultimate Match
  278. Generate a formula dynamically ?
  279. Turn off auto backup copy
  280. Excel 2007 Nested Sumif's
  281. How to Disable Unhide Sheet menu option
  282. Sum up results from If statement
  283. Protected Range Not Protected
  284. FREQUENCY across multiple worksheets
  285. Table Name Autocorrect Feature Excel 2007
  286. sumif
  287. Countif cell contians a specific number (within a list)
  288. Using lookup
  289. Making a letter have a value
  290. Display a cell address
  291. help with pivot tables
  292. Complicated Cell Formula
  293. Conditional formatting question
  294. Repeat a Macro
  295. Calculate Weighted Value
  296. SUMPRODUCT Question
  297. Allowing Only Certain Entrees
  298. Error type mismatch in writing macro
  299. Cell Reference VS. Manual Input?
  300. Protect single sheets in the woorkbook
  301. Database Formula Criteria Problem
  302. Return value from column A if value in column B is in top 3 MAX()
  303. excel to return system time when I press combination of keys
  304. How do I create a checklist to auto-fill another doc using excel?
  305. Need a formula
  306. Count if all both apply
  307. Cidtional Formatting doesn't work across all cells in range
  308. How do you do a crosswalk between worksheets?
  309. Auto row insertion based on a number
  310. Find then save to different worksheet
  311. need help with running totals
  312. CF help needed with cell color
  313. Count in a variable range
  314. color fill button is not adding color to my spread sheet
  315. Using Range operator (:) In If condition
  316. SUMIF multiple criteria
  317. Calculating data within a date range
  318. counting age groups
  319. SPREED SHEET TEMPLATES IN EXEL
  320. complicated formula help
  321. Match
  322. I need help
  323. If date is in the month of Sept, then "1", otherwise "2"
  324. Countif array function not working
  325. Empty Cell Result
  326. Counting unique values and subtracting those of no interest
  327. How do I update the 2005 attendance calendar to 2007?
  328. Match Cells
  329. complex randbeween formula, Excel2007
  330. how to advance dates by one year then up to 10 yrs in Excel
  331. row color is not being retained after saving spreadsheet
  332. Leading Zeros
  333. Copying formula
  334. Need help w/ adding cells and dividing SUM by number of cells
  335. Any number above 15 returns false when it should be true
  336. How do I summarize items chosen on mulitiple worksheets
  337. How to automaticaly insert user name (login name) in excel?
  338. Text stops wrapping in cell. Tried AutoFit.
  339. zoom and scrolling with a mouse
  340. Microsoft Excel 2002
  341. Comparing 2 worksheets
  342. How to: Convert time value to a number
  343. Calculations using Times in Excel 2003
  344. User Record
  345. Adding text to the subtotal row
  346. calculating differences in a pivot table
  347. Help! creating code for time to decimal calculations
  348. Want to get last row that has value
  349. Macro - copy a range and paste it in a new sheet 12 times
  350. "If" function in multiple Cells
  351. IF AND with value between a range
  352. Auto fill Adjacent cells
  353. vlookup question
  354. Look up value
  355. formulas for multiple worksheets
  356. Help w/complex Due Date Function
  357. Lookup Help, Please!
  358. How do I truncate a text field in Excel?
  359. Automatically fill info from a list
  360. Text search within a string using formula
  361. How do I make a cashflow with pivot table?
  362. match multiple criteria ina range from multiple criteria multiplet
  363. Pivot Table Range
  364. Extract a list from master list
  365. How do i change font colors for different results in the same cel.
  366. Accessing cube functions (ie cubevalue) from VBA
  367. Match a text
  368. Optionbutton troubles
  369. check first cell in row, move entire row to sheet of that name
  370. Looking for a way to make this work.
  371. Modifying only the worksheet when draging down a cell reference
  372. How to filter only the numbers I need
  373. Either LOOKUP or INDEX Help
  374. How to hold running Macro?
  375. Can a cell defined by a formula become an exportable numeric valu.
  376. Top cell in a list to match cells below of a certain value?
  377. Average
  378. Hide/Don't Display Values
  379. Random Selection
  380. select data from a table
  381. Volume Weighted Average
  382. filtering a list to exclude 2 different dates
  383. MATCH & LOOKUP functions
  384. Finding duplicates in Excel 2003
  385. Sum of 12 cells
  386. HLOOKUP question
  387. Absolute value with a quick formula / shortcut?
  388. excel bug in Vista
  389. Command
  390. How do I change colors on the row/column active header?
  391. date in excel ?
  392. Need Help Generating a Specific Formula
  393. Modify A Macro
  394. Number of payments remaining
  395. RANDBETWEEN INSTALL
  396. Date formatting inconsistent
  397. YTD value minus prev mth value = curent month - Rolling Report
  398. A question about INDIRECT()
  399. day of month
  400. Custom Cell Format in a List
  401. showing the totals in a chart/table without charting them
  402. COUNTIF a value within a range equals any value in an array/list
  403. count percentages
  404. Multiply by a rate depending on the value
  405. forcing date to excel
  406. sum product not returning correct number
  407. How to combine "IF" functions
  408. pivot table to contains more than 1 field groups
  409. Array or range lookup per row?
  410. NPV of Cash Flow Payments
  411. formula question
  412. Hyperlink to another sheet within a workbook using formula
  413. Simple problem, simple formula, no FUNCTION !
  414. how use msexcel
  415. IF/COUNT/AVERAGE... Value returned is incorrect.
  416. SUMIF problem
  417. Criteria with cell references
  418. Subtracting 1 year from todays date
  419. AutoSum lost a penny
  420. Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul
  421. I need help - search formula
  422. Is a Pop-up Calendar Possible?
  423. Custom functions excel 2003
  424. conditional sum ??
  425. Print Gridlines only on sections of a spreadsheet
  426. lock position of Word object in protected excel spreadsheet
  427. list sheet names vertically below the active cell - need macro.
  428. copying conditional formating
  429. SUMPRODUCT trciky use.
  430. How do I select cells within a column that contain a specific word
  431. Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches
  432. Lookup??
  433. The best way forward?
  434. Fun with COUNT and AND functions.
  435. Drop Down Calendar ?
  436. Help with If Function
  437. Help with auto populating cells.
  438. macro to: Add new sheet, then rename new sheet with todays date
  439. special lookup
  440. vlookup and hlookup formula, a good challenge
  441. Too Many Nested IF Statements!
  442. List Lookup Help
  443. how do I change the letters
  444. question about ABS Function
  445. A function incoprating date and a month/monetary value.
  446. Using Excel to auto spread data
  447. COUNIFS
  448. Drop down lists that auto create and then filter the next drop down list
  449. Need help figuring out how to code this macro
  450. Limit a countif?
  451. Assets
  452. Display constant cell value based on another cell value
  453. Conditional Formatting on cell with a formula
  454. Moving a Task Pane
  455. Scanning
  456. #REF# Problem
  457. Strange thing happens...
  458. Excel Formula Learning
  459. Table_array and drop down boxes
  460. XIXtrFun.xll add-in.
  461. If null, make cell blank
  462. spreadsheet filter alerts
  463. Color of text relating to a formula
  464. I need BIG help with with formula
  465. using a function to insert symbol
  466. what is the persent formula
  467. total hours
  468. formula help
  469. Need Help with what i thought was a SIMPLE Macro
  470. walking menu
  471. Simplify formula using quarterly investment returns
  472. Help with excel Formula
  473. How do I sort a column by last character
  474. Financial Spreadsheet Help
  475. Password Strength - Excel
  476. looking for formula to identify next non-empty cell on another sheet
  477. Margin Lines
  478. create a form and find a value in one cell and replace a value in
  479. How can I use and indexed value as the name of an array for vlooku
  480. Pivot Tables
  481. Some Bug in Excel 2007?!
  482. Stationary cursor, scrolling page
  483. using more than 1 formula in the same cell in excel
  484. Can a Macro on exel be set with a password?
  485. Making wider drop down List for Filter
  486. Select specific column for auto filter
  487. Formula for spreadsheet total
  488. more than 4 if functions?
  489. strings as criteria in database function DCOUNT
  490. Calendar 2005; Attendance
  491. Pivot Table Refresh option not able to see
  492. find lowest number and return it's adjacent cell
  493. How do i add this to my formula?
  494. want to round a number to the nearest quarter 0.25-0.50-0.45-0.00
  495. String criteria in DCOUNT function
  496. Same range, same name, different worksheet
  497. SUMIF WITH MULTIPLE CRITERIA?
  498. Cell Format
  499. add 2 months and a variable number of days to a date
  500. Date and time in cell
  501. Adding data from multiple worksheets onto a total's page??
  502. Auto fill from pick list
  503. Return All Non-Blank Cells
  504. sumproduct
  505. Change Font/formatting for EXCEL Drop-Down List selector...
  506. Challenge
  507. Filter Data with formulas
  508. Conditional 2007 - Format whole row based on one cell
  509. Error using a combo box with an assigned macro in Excel
  510. Move only numbers to a new column
  511. Move/Copy Worksheet -- does not work
  512. MAX only Rows in Range where another Row is Not Blank
  513. Help
  514. Adding VBA Codes
  515. Workday Formula
  516. if formula
  517. if formula
  518. HELP - Conditional Formatting Dates & Blank Cells
  519. How can I enter a 4 in a cell & have it return 4:00 PM in Excel?
  520. Multiple Worksheet Find
  521. I need to subtract a range of numbers
  522. using multiple sheets
  523. how to remove blanc pages
  524. sort problem
  525. Figuring out a formula
  526. How do I number cells vertically in succession? Example: (1 2 3)
  527. how do i print changes as displayed on worksheet
  528. formula question
  529. Using SUMIF Function to get data from several worksheets
  530. Picking up part of a formula from another cell
  531. maximum over a non continuous range
  532. add blank rows
  533. Mail merge
  534. Excel / Access User Conference - Oct 24-26, St Loiuis
  535. header/footer for the whole workbook
  536. Looking up a maximum value that matches criteria. VLOOKUP?
  537. How do I create a reverse julian date formula?
  538. analysis of variance with lack of fit in excel
  539. =AVERAGE returning a #DIV/0! result
  540. Problem with =IF(AND........ formula
  541. Linked Files
  542. Compound Interest over the years
  543. how do you change $42.79 to an even number ($42.80)
  544. Exact formula 3 Columns
  545. If Then
  546. Subtotals Deleting Rows after removing Subtotal - 2003 Excel
  547. Printing multiple sheets at one time
  548. Condensing Rows Automatically
  549. if search formula incl date range
  550. Comparing two combos/cells to return a value
  551. too many fonts in a workbook
  552. display unabbreviated month in text, from system date?
  553. Select a customer name and have their address fill in automaticall
  554. Row Limitation in SUMPRODUCT
  555. search tabs
  556. I'd like to Sort one column without affecting the others
  557. COUNTIF with age range
  558. True and false formula
  559. Formula problem
  560. Protecting only Hidden Rows on a Spreadsheet
  561. Finding a formula
  562. Formula Is Too Long
  563. My excel formula is correct, however, my total is off by .01.
  564. how to convert #na to 0 when using vlookup
  565. Summing a binary truth list
  566. How can I give text a changeable numeric value?
  567. Look up formula
  568. Units of measure
  569. Round 1.45 down to 1.25 and 1.57 down to 1.50
  570. IF AND statement with cell range
  571. Yes or No for adjacent cells
  572. Array reference using indirect address
  573. excel 2007 sort problem
  574. V.A.T how to calculate it
  575. Result not less than 0
  576. date add 5 workdays AND 6 calendar months
  577. Need assistance with a formula - If then???
  578. counting the occurances for specific dept within a given time peri
  579. If Formula question
  580. Lookup 2 criteria across multiple worksheet (Attn: Peo Sjoblom)
  581. Microsoft Excell to Microsoft Word
  582. function to return day in the form "Monday", "Tuesday" etc given .
  583. Sumif withdates
  584. Can I have a statement like: If - Then - Otherwise ?
  585. Drop Down List
  586. why is ...xls] being added to the name on my worksheet?
  587. GetPivotData with variable criteria input? (revisited!)
  588. Editing and Moviing from 6 If's to 7 Ifs (Nested)
  589. SUMIF COMMAND WITH CONDITIONAL CRITERIA (I.E. BETWEEN CERTAIN DATE
  590. Security for a column within a sheet
  591. How can i sum up numbers which are counted on a date.
  592. Multiple nested If statements
  593. Creating a formula
  594. Something more than VLOOKUP?
  595. Displaying what column a piece of data is in
  596. Parse File Location
  597. ribbon and pivot table
  598. Workbook Security
  599. Find and delete
  600. match data in 2 sheets then display true/false from vlkup
  601. deny printing for certain blank cells
  602. IF and DATE Formula Help PLEASE
  603. Validation Procedure with a worksheet change event
  604. If statemrent
  605. I need to know which function to use.
  606. Count By Date Need Some Help
  607. 3D Stacked Bar chart
  608. How do I change a formula to accrue interest daily?
  609. Spreading an amount over a period of time based on predetermined %
  610. Novice IF and COUNT question (I think)
  611. How do I get the count in excel based on criteria in multiple col
  612. Macro that will detemine date and then check off a box
  613. Text function question.
  614. Uniquely number a set of names
  615. add number of days within a department for a given time period
  616. INDIRECT AND IF STATEMENT
  617. Not sure which function to use in this instance.
  618. How do I share a list within a book with multiple worksheets?
  619. Can you make a number in an excel cell blink?
  620. Can you email a single worksheet in a workbook in Excel 2007?
  621. Sum.If function but depending on 3 different columns?
  622. VB Code to link to website
  623. Help with Weighted Average Per Month
  624. inserting subtotals in excel file
  625. Count Week Of Month
  626. Help needed.
  627. how do you move rows onto the next page in excel
  628. I want to display this as the value, not the cell reference.
  629. How To Do This Array Function
  630. Count the number of changes to a cell
  631. how to list all active macros and their assigned keystrokes?
  632. Page Setup not functioning
  633. change a list of 2 digit years to 4 digit years?
  634. String to Variant incorrect conversion
  635. Count If Function
  636. Wonderware Active Factory Add In Problem
  637. Extracting Numbers from string
  638. Question about using MIN/MAX, INDEX with Date range
  639. Count Uniques EXCLUDING Some Entries
  640. Lookup & Match formula
  641. Need help...
  642. Auto Filter does not work with embedded objects
  643. How do I change the size of cells dynamically in Excel?
  644. Rounding to billions, millions, etc.
  645. Column subtractions
  646. Need Help in counting + sign in a cell
  647. I just don't get it
  648. help please
  649. Move sorted data from one worksheet to multiple worksheets?
  650. AutoFilter - get rid of default choice
  651. embedded pdf object
  652. Recap of Data
  653. Lookup?
  654. 2 digit years being converted incorrectly
  655. evaluate cell value with sheet name
  656. Getpivot function -
  657. challenge formula
  658. Generating Pivot Table from multiple worksheet
  659. how do I move data to a new line in a cell after a comma?
  660. filters
  661. convert from percentage of time to time using complex formula in .
  662. converting a number into text
  663. converting a number into text
  664. converting a number into text
  665. Display a 1 for the first of duplicates
  666. Keep cell reference when moving range (matter of urgency)
  667. PivotTable Drop-Down Un-Checked Item Missing
  668. Extract the row number
  669. IF - THEN - OTHERWISE -......UNLESS! ???
  670. SumProduct Need Help Please
  671. Adding the changes to only one Cell
  672. Restricting the Web Page Preview???
  673. Find text within text
  674. MOD function not returning exact zero
  675. Copying cell with input range to different worksheet
  676. grey out insert menu options
  677. Looping till condition is satisfied?
  678. Parsing Last Character in variable length text field
  679. Repeat keystrokes to delete character in column
  680. Excel 2002
  681. link text
  682. Dynamically linking subserviant worksheets to a master worksheet
  683. Macro Copy Worksheet Name into worksheet A1
  684. How can I combine two formulas Left/Mid/Right + Substitute?
  685. How to make this macro stop?
  686. How to use ActiveCell to mean a particular cell?
  687. How to in Excel? Do I need a formula for it?
  688. "aligning option buttons"
  689. Cannot enter control for drop down box
  690. Spreadsheet within a spreadsheet
  691. where is the crystal reports wizard in MS Excel 2007?
  692. address function
  693. Offset and Vlookup Question
  694. How do I summarize dates of events to a new worksheet to count ho.
  695. Sorting/Moving Data
  696. comparing 2 columns info to fill 3rd column
  697. CSE function with #VALUE errors
  698. New numbering button on toolbar
  699. options list box - larger text
  700. Compare two worksheets
  701. color of cell fill
  702. R1C1 formula question
  703. Search Multiple Worksheets by having user type in information
  704. How to create a search function
  705. Can a Macro be run as part of an IF() statement
  706. Microsoft Excel cannot find data you are searching for
  707. VLOOKUP
  708. can worksheet names be changed by changing certain cells?
  709. «æ! ¤â¾÷²M³f5§é°_
  710. Pivot table grouping question
  711. How to use Drop down list to reflect a set of fields to be filled?
  712. Text to dictate colour of the cell and/or row
  713. Is there a function/formula to retrieve the weeknumber?
  714. Stop rows that i have hidden unhidding when i filter in excel
  715. Add text to meet criteria
  716. Function Help
  717. Date Formula
  718. Pareto Chart
  719. How to send automatic email when cell value changes in excel
  720. How do I convert my old linked spreadsheets to MS2007?
  721. High = 4
  722. High = 4 take 2
  723. HOW CAN I FORMAT COLUM B TO UPDATE DAYS DELIQUENT DAILY
  724. benefit from microsoft excel
  725. If ,AND, LOOKUP, Functions
  726. search array
  727. No return for formula
  728. Cell formatting
  729. SIMPLE QUESTION need fast answer please
  730. Is there formulas which set text to equal a number?
  731. Automatically insert rows with formula
  732. Comparing two worksheets
  733. Formatting A Cell
  734. Protecting sheet that has macro
  735. Formula Countif Index Match
  736. SUMPRODUCT With External Range Name?
  737. Auto fill cells in other tabs from one master tab and protect them
  738. Finding MIN value in a column between Two Dates in different columns
  739. Lenght of a decimal part of a number.
  740. Excel 2003, how can I show my entire drop down list under file?
  741. Array to find relative position - is there a better way?
  742. Match Field Data
  743. #Value! Keeps appearing
  744. Some sort of Lookup?
  745. set a permentant print area in a multi-sheet workbook
  746. formula
  747. Subtract a max value from a row then copy that columns title?
  748. Formatting the =NOW() function ?
  749. If And Calcuation
  750. MIN and MAX across columns
  751. Is there a keyboard shortcut for using Paintbrush?
  752. Pictures in Cells
  753. excel 2000 problem
  754. The Columns...HELP!
  755. Link
  756. How do I Get rid of Excel extra left margin filter drop down box
  757. Find and Replace
  758. Insert a letter in front of number in every cell?
  759. Running a macro from an auto-refresh
  760. Finding a charcter in a text string
  761. formula to calculate a specific percent of a column of different p
  762. Urgent! I am in dire trouble - boss says it can be done - How?
  763. Excel question.
  764. Possible 2007 Bug: Match()
  765. excel: if selected, copy cell from corresponding row
  766. calculating the probablity of HBsAg contamination
  767. Vlookup Returns Wrong/No Data
  768. How do I set up a daily call out response response register?
  769. Conditional Format - MIN, IF statements
  770. Annuity Formula
  771. Date
  772. editing formula no longer outlines ranges
  773. How do I round a number after finding the average?
  774. Lookup value in range, then if that value is something do a calculation.
  775. Counting occurences of a name
  776. formulas
  777. Refer upper field
  778. How do I display number into form of text or word?
  779. vlookup or other?
  780. Excel 2007 Default Font
  781. If statement that returns data in a cell if False.
  782. Automatic calculation
  783. Compare two wk sheets with common data using copy paste macro
  784. Search and go to cell
  785. how do i calculate least-square regression analysis?
  786. Copy and Replicate exact formulas
  787. Error handling VLOOKUP. #N/A - can it be 0 to allow sumation.
  788. IF(ISBLANK) with other criteria
  789. Conditional Formatting - further assistance required
  790. HOW DO I COPY A TOTAL FIGURE FROM 1 SHEET TO NEXT ADDING RUNNING T
  791. Pictures adding & removal
  792. How do I get ending figure in proper cell?
  793. Data Sorting Query
  794. CONVERT ROMAN TO ARABIC NUMERALS
  795. Hyperlink auto-population? Please Help
  796. What does it mean when excel says "too many cell formats"?
  797. How many different numbers in an array
  798. Adding ISERROR to formula
  799. How to: Find first empty cell in column
  800. Text to columns
  801. Compare/Find Exact Date match with varying time
  802. copy in filter mode
  803. IF(ISTEXT Concatenate formula question
  804. como convertir numero de una celda, en el mismo numero-texto en o.
  805. Is it possible in Excel to have a file auto delete on a given dat.
  806. Losing previous highlighted columns when doing multiple column hi.
  807. how do I extend sub-columns into one long row?
  808. e-mails addresses
  809. Simple Formula Help?
  810. Subtotals of repeating set of data
  811. Pivot Table Template
  812. finding, sorting, put only part of a cell
  813. Create a "Send" button
  814. Macro REQ: Automatically copy a template sheet and rename
  815. Sumproduct
  816. Excel Formula Help
  817. extract text from string
  818. Alternate row shadding even when rows are hidden
  819. IF formula help..
  820. Excel2003 use fnct/conditnl fmt, hw cpy clr frm anthr source Text
  821. Excel2003 use fnct/conditnl fmt, hw cpy clr frm anthr source text
  822. COUNT formula help
  823. DCOUNTA WITH MULTIPLE FIELD CRITERIA
  824. Help! How do I return the latest of a series of dates using Vlooku
  825. general number format and VLOOKUP
  826. Formula that will record the time and date when an entry is made on a sheet
  827. Combined ROUNDUP
  828. I can't insert a worksheet into my current spreadsheet file
  829. Button to open JPG (Hyperlink)
  830. Sumif
  831. today as a function of the year to date
  832. Count based on multiple criteria
  833. Complex Summing probably using Match at some point...
  834. Find the Longest Run.
  835. Find Smallest and Largest.
  836. Find a value and count the rows back to the reference row.
  837. How do I create a list in excel 2007?
  838. formula pulling data based on 1 input on another tab.
  839. I want to double click a box and have an X inserted there?
  840. Combining 2 IF statements to make one formula.
  841. Time formulas
  842. Sum-if-product
  843. How can I compare data between two different sheets for changes?
  844. how do i set up an income and expenditure account in excel?
  845. compareing 2 columns
  846. "Too many arguements for this function"....ohh noooo....
  847. Custom Colors
  848. Re: Excel2003 use fnct/conditnl fmt, copy color&Val from ref cell
  849. need Excell to display something other than what I type
  850. Needing to rank values
  851. Excel 2007 calculation bug fix
  852. HOW DO I COPY ALL DATA (INC COMMENTS)FROM 1 WORKBOOK TO ANOTHER
  853. How to display running-down numbers with total count?
  854. PH Stat
  855. How do I do IF C5=y, then L5*.06 ?
  856. What is the correct formula for IF C5 = Y, then L5 *.06?
  857. Trying to display the number between two numbers closest to another value
  858. Display top rankings
  859. Need to IMPORT a Worksheet From another WorkBook
  860. Rankings
  861. Max Values
  862. Worksheet name
  863. #VALUE! error
  864. fromatting not possible on the cells
  865. Summerising data
  866. "Conditional" sum
  867. "Sumif" on multiple values
  868. How I prevent a "0" when a linked cell is empty?
  869. IF Function
  870. Lookup Multiple Criteria
  871. CORREL formula work on multiple dependents
  872. display a range of cells editible cells based on matching date
  873. Using Text to Columns with a function
  874. How to format a date as text?
  875. OR & IF functions
  876. Excel equation explanation
  877. Error message
  878. Find cells with data.
  879. Function for euro number format?
  880. carrying previous totals from one worksheet to another.
  881. insert another page into an existing one
  882. Create graph if value is greater that zero
  883. IF Formula
  884. Counts for Excel 2003 using multiple criteria
  885. a list of all macros and their key combinations?
  886. IF formula
  887. IF statement to long, an easier way?
  888. update linked spreadsheets w/o recreating links
  889. Sorting a Pivot Table Column that is not the first column...
  890. IF statement - multiple scenarios
  891. Office 2007-How do I copy a worksheet from one workbook to another
  892. justify text into multiple rows
  893. XIRR formula in non-normal struction
  894. Randomly sorting an Excel spreadsheet
  895. SumProduct & Countif?
  896. Split surname from end of name data
  897. Matrix
  898. percentage
  899. Routine with fuzzy logic to determine the relative comparison of two strings?
  900. Data Validation Blank Cells
  901. Sum,
  902. find the last Fred and goto cell
  903. Variables in formulas
  904. how to put quotation mark in each cell of the column
  905. Leveling Methods
  906. Counting a range to see if it encompasses a given date
  907. Data Validation List content controlled from cell
  908. sum values from the listed sheets
  909. how do I increase the length of a drop down list?
  910. IF
  911. Which function? Biggest distance to the Nearest city ...
  912. HYPERLINK Worksheet Function
  913. Create refresh button in worksheet to refresh Pivot Table Data
  914. Adding button to worksheet to refresh pivot table data
  915. PROBLEM WITH INDIRECT & VLOOKUP FORMULA
  916. How do I convert time?
  917. Summing dynamic range
  918. normal into Capital letters automatically
  919. Trying to SUM cells with links.
  920. Conditional Formatting Dates calculating 10 days and 30 days from a certain date
  921. Percentrank Function
  922. how do you flip the order of the content in a cell.
  923. Count or Sum ?
  924. If statement help
  925. what is the formula for rounding time up to 1/4 hr?
  926. Formula for selecting the second row down (Not necessarily row "2"
  927. Look up question
  928. Breaking down an excel formula
  929. Array formulas help needed
  930. Find DMIN in a column range determined by a number in another cell
  931. Highlite from A2 to Last Fred then to Column G
  932. How do I call up the Text Import Wizard via a macro.
  933. Informational Search
  934. link excel to automatically update mailbox calendar when you upd.
  935. DATE Question
  936. Display contents of cell based on criteria
  937. take values from column A for values>0 in column B
  938. Vlookup based on date specified
  939. Please help macro for save
  940. Can Database Function Criteria be a Date?
  941. Integrate OFFSET, INDIRECT and VLOOKUP?
  942. Can't find hidden worksheet xlsVeryhidden
  943. Conditional Formatting Formula
  944. using multiple vlookups confusion
  945. Counting cells with text not listed.
  946. Comparing two columns and finding matching names
  947. Adding Tags to file names
  948. Lookup with Multiple results
  949. Find minimum value in column.
  950. GEOMEAN
  951. VLOOK UP
  952. Worksheet fails to filter at times
  953. can i convert my excel tab into a word document?
  954. Calculate Start Date
  955. Data Validation
  956. Data Validation
  957. Change Format from Number to Percentage (sounds easy enough)
  958. conditonal formatting in VB
  959. I thought I would use FORECAST, but maybe I am wrong...
  960. Subtracting one list from another list
  961. Calculation using result from Index/Match
  962. Counting unique values by date
  963. Sum same cell from all sheets
  964. LOOKUP return the value from the previous row
  965. Datedif doesn't work the same in Excel 2007
  966. Using VBA
  967. Adding Cells that Contain Text
  968. Percentrank function display
  969. Help w/ a formula
  970. Matching Formula ??
  971. Matching Formula ??
  972. Sum If Formula with 3 criteria
  973. SPREADSHEET VIEW
  974. functions for if
  975. E-mail one sheet
  976. Sumproduct Question
  977. If Sheet1 column is marked complete, display entire row on Sheet2?
  978. Is there an icon to use showing visible cells only?
  979. How to insert tab name of a wrksht into a cell in that worksheet?
  980. keyboard shortcut for "paste special....."?
  981. Calculating the run rate
  982. countif function using dates
  983. Number Order
  984. Pivot Table 2003 - Creat a column using absolute cells o/s the tab
  985. Formula to group First/Last names 2 one cell
  986. how to get the random date between the start date and the end date?
  987. Adding Fractions of a Second
  988. Date function in ACCRINTM requires date format not available
  989. vb cording with excell
  990. sumproduc
  991. formatting in worksheets
  992. lookup with multiple condition, but one condition to satisfy is en
  993. How do I set up a formula to calculate a bonus?
  994. scrolling table
  995. Function based on multiple criteria from two cell references
  996. SUMIF with two or more variables
  997. HOW TO FORMAT ANOTHER CELL
  998. Match Cells, and Sum Data
  999. Option Buttons from the Forms Toolbar - Excel 2003
  1000. Pivot Table-two tables same data, can I used the same page control
Google