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 |  88 |  89 | 

  1. Can a Macro be run as part of an IF() statement
  2. How to create a search function
  3. Search Multiple Worksheets by having user type in information
  4. R1C1 formula question
  5. color of cell fill
  6. Compare two worksheets
  7. options list box - larger text
  8. New numbering button on toolbar
  9. CSE function with #VALUE errors
  10. comparing 2 columns info to fill 3rd column
  11. Sorting/Moving Data
  12. How do I summarize dates of events to a new worksheet to count ho.
  13. Offset and Vlookup Question
  14. address function
  15. where is the crystal reports wizard in MS Excel 2007?
  16. Spreadsheet within a spreadsheet
  17. Cannot enter control for drop down box
  18. "aligning option buttons"
  19. How to in Excel? Do I need a formula for it?
  20. How to use ActiveCell to mean a particular cell?
  21. How to make this macro stop?
  22. How can I combine two formulas Left/Mid/Right + Substitute?
  23. Macro Copy Worksheet Name into worksheet A1
  24. Dynamically linking subserviant worksheets to a master worksheet
  25. link text
  26. Excel 2002
  27. Repeat keystrokes to delete character in column
  28. Parsing Last Character in variable length text field
  29. Looping till condition is satisfied?
  30. grey out insert menu options
  31. Copying cell with input range to different worksheet
  32. MOD function not returning exact zero
  33. Find text within text
  34. Restricting the Web Page Preview???
  35. Adding the changes to only one Cell
  36. SumProduct Need Help Please
  37. IF - THEN - OTHERWISE -......UNLESS! ???
  38. Extract the row number
  39. PivotTable Drop-Down Un-Checked Item Missing
  40. Keep cell reference when moving range (matter of urgency)
  41. Display a 1 for the first of duplicates
  42. converting a number into text
  43. converting a number into text
  44. converting a number into text
  45. convert from percentage of time to time using complex formula in .
  46. filters
  47. how do I move data to a new line in a cell after a comma?
  48. Generating Pivot Table from multiple worksheet
  49. challenge formula
  50. Getpivot function -
  51. evaluate cell value with sheet name
  52. 2 digit years being converted incorrectly
  53. Lookup?
  54. Recap of Data
  55. embedded pdf object
  56. AutoFilter - get rid of default choice
  57. Move sorted data from one worksheet to multiple worksheets?
  58. help please
  59. I just don't get it
  60. Need Help in counting + sign in a cell
  61. Column subtractions
  62. Rounding to billions, millions, etc.
  63. How do I change the size of cells dynamically in Excel?
  64. Auto Filter does not work with embedded objects
  65. Need help...
  66. Lookup & Match formula
  67. Count Uniques EXCLUDING Some Entries
  68. Question about using MIN/MAX, INDEX with Date range
  69. Extracting Numbers from string
  70. Wonderware Active Factory Add In Problem
  71. Count If Function
  72. String to Variant incorrect conversion
  73. change a list of 2 digit years to 4 digit years?
  74. Page Setup not functioning
  75. how to list all active macros and their assigned keystrokes?
  76. Count the number of changes to a cell
  77. How To Do This Array Function
  78. I want to display this as the value, not the cell reference.
  79. how do you move rows onto the next page in excel
  80. Help needed.
  81. Count Week Of Month
  82. inserting subtotals in excel file
  83. Help with Weighted Average Per Month
  84. VB Code to link to website
  85. Sum.If function but depending on 3 different columns?
  86. Can you email a single worksheet in a workbook in Excel 2007?
  87. Can you make a number in an excel cell blink?
  88. How do I share a list within a book with multiple worksheets?
  89. Not sure which function to use in this instance.
  90. INDIRECT AND IF STATEMENT
  91. add number of days within a department for a given time period
  92. Uniquely number a set of names
  93. Text function question.
  94. Macro that will detemine date and then check off a box
  95. How do I get the count in excel based on criteria in multiple col
  96. Novice IF and COUNT question (I think)
  97. Spreading an amount over a period of time based on predetermined %
  98. How do I change a formula to accrue interest daily?
  99. 3D Stacked Bar chart
  100. Count By Date Need Some Help
  101. I need to know which function to use.
  102. If statemrent
  103. Validation Procedure with a worksheet change event
  104. IF and DATE Formula Help PLEASE
  105. deny printing for certain blank cells
  106. match data in 2 sheets then display true/false from vlkup
  107. Find and delete
  108. Workbook Security
  109. ribbon and pivot table
  110. Parse File Location
  111. Displaying what column a piece of data is in
  112. Something more than VLOOKUP?
  113. Creating a formula
  114. Multiple nested If statements
  115. How can i sum up numbers which are counted on a date.
  116. Security for a column within a sheet
  117. SUMIF COMMAND WITH CONDITIONAL CRITERIA (I.E. BETWEEN CERTAIN DATE
  118. Editing and Moviing from 6 If's to 7 Ifs (Nested)
  119. GetPivotData with variable criteria input? (revisited!)
  120. why is ...xls] being added to the name on my worksheet?
  121. Drop Down List
  122. Can I have a statement like: If - Then - Otherwise ?
  123. Sumif withdates
  124. function to return day in the form "Monday", "Tuesday" etc given .
  125. Microsoft Excell to Microsoft Word
  126. Lookup 2 criteria across multiple worksheet (Attn: Peo Sjoblom)
  127. If Formula question
  128. counting the occurances for specific dept within a given time peri
  129. Need assistance with a formula - If then???
  130. date add 5 workdays AND 6 calendar months
  131. Result not less than 0
  132. V.A.T how to calculate it
  133. excel 2007 sort problem
  134. Array reference using indirect address
  135. Yes or No for adjacent cells
  136. IF AND statement with cell range
  137. Round 1.45 down to 1.25 and 1.57 down to 1.50
  138. Units of measure
  139. Look up formula
  140. How can I give text a changeable numeric value?
  141. Summing a binary truth list
  142. how to convert #na to 0 when using vlookup
  143. My excel formula is correct, however, my total is off by .01.
  144. Formula Is Too Long
  145. Finding a formula
  146. Protecting only Hidden Rows on a Spreadsheet
  147. Formula problem
  148. True and false formula
  149. COUNTIF with age range
  150. I'd like to Sort one column without affecting the others
  151. search tabs
  152. Row Limitation in SUMPRODUCT
  153. Select a customer name and have their address fill in automaticall
  154. display unabbreviated month in text, from system date?
  155. too many fonts in a workbook
  156. Comparing two combos/cells to return a value
  157. if search formula incl date range
  158. Condensing Rows Automatically
  159. Printing multiple sheets at one time
  160. Subtotals Deleting Rows after removing Subtotal - 2003 Excel
  161. If Then
  162. Exact formula 3 Columns
  163. how do you change $42.79 to an even number ($42.80)
  164. Compound Interest over the years
  165. Linked Files
  166. Problem with =IF(AND........ formula
  167. =AVERAGE returning a #DIV/0! result
  168. analysis of variance with lack of fit in excel
  169. How do I create a reverse julian date formula?
  170. Looking up a maximum value that matches criteria. VLOOKUP?
  171. header/footer for the whole workbook
  172. Excel / Access User Conference - Oct 24-26, St Loiuis
  173. Mail merge
  174. add blank rows
  175. maximum over a non continuous range
  176. Picking up part of a formula from another cell
  177. Using SUMIF Function to get data from several worksheets
  178. formula question
  179. how do i print changes as displayed on worksheet
  180. How do I number cells vertically in succession? Example: (1 2 3)
  181. Figuring out a formula
  182. sort problem
  183. how to remove blanc pages
  184. using multiple sheets
  185. I need to subtract a range of numbers
  186. Multiple Worksheet Find
  187. How can I enter a 4 in a cell & have it return 4:00 PM in Excel?
  188. HELP - Conditional Formatting Dates & Blank Cells
  189. if formula
  190. if formula
  191. Workday Formula
  192. Adding VBA Codes
  193. Help
  194. MAX only Rows in Range where another Row is Not Blank
  195. Move/Copy Worksheet -- does not work
  196. Move only numbers to a new column
  197. Error using a combo box with an assigned macro in Excel
  198. Conditional 2007 - Format whole row based on one cell
  199. Filter Data with formulas
  200. Challenge
  201. Change Font/formatting for EXCEL Drop-Down List selector...
  202. sumproduct
  203. Return All Non-Blank Cells
  204. Auto fill from pick list
  205. Adding data from multiple worksheets onto a total's page??
  206. Date and time in cell
  207. add 2 months and a variable number of days to a date
  208. Cell Format
  209. SUMIF WITH MULTIPLE CRITERIA?
  210. Same range, same name, different worksheet
  211. String criteria in DCOUNT function
  212. want to round a number to the nearest quarter 0.25-0.50-0.45-0.00
  213. How do i add this to my formula?
  214. find lowest number and return it's adjacent cell
  215. Pivot Table Refresh option not able to see
  216. Calendar 2005; Attendance
  217. strings as criteria in database function DCOUNT
  218. more than 4 if functions?
  219. Formula for spreadsheet total
  220. Select specific column for auto filter
  221. Making wider drop down List for Filter
  222. Can a Macro on exel be set with a password?
  223. using more than 1 formula in the same cell in excel
  224. Stationary cursor, scrolling page
  225. Some Bug in Excel 2007?!
  226. Pivot Tables
  227. How can I use and indexed value as the name of an array for vlooku
  228. create a form and find a value in one cell and replace a value in
  229. Margin Lines
  230. looking for formula to identify next non-empty cell on another sheet
  231. Password Strength - Excel
  232. Financial Spreadsheet Help
  233. How do I sort a column by last character
  234. Help with excel Formula
  235. Simplify formula using quarterly investment returns
  236. walking menu
  237. Need Help with what i thought was a SIMPLE Macro
  238. formula help
  239. total hours
  240. what is the persent formula
  241. using a function to insert symbol
  242. I need BIG help with with formula
  243. Color of text relating to a formula
  244. spreadsheet filter alerts
  245. If null, make cell blank
  246. XIXtrFun.xll add-in.
  247. Table_array and drop down boxes
  248. Excel Formula Learning
  249. Strange thing happens...
  250. #REF# Problem
  251. Scanning
  252. Moving a Task Pane
  253. Conditional Formatting on cell with a formula
  254. Display constant cell value based on another cell value
  255. Assets
  256. Limit a countif?
  257. Need help figuring out how to code this macro
  258. Drop down lists that auto create and then filter the next drop down list
  259. COUNIFS
  260. Using Excel to auto spread data
  261. A function incoprating date and a month/monetary value.
  262. question about ABS Function
  263. how do I change the letters
  264. List Lookup Help
  265. Too Many Nested IF Statements!
  266. vlookup and hlookup formula, a good challenge
  267. special lookup
  268. macro to: Add new sheet, then rename new sheet with todays date
  269. Help with auto populating cells.
  270. Help with If Function
  271. Drop Down Calendar ?
  272. Fun with COUNT and AND functions.
  273. The best way forward?
  274. Lookup??
  275. Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches
  276. How do I select cells within a column that contain a specific word
  277. SUMPRODUCT trciky use.
  278. copying conditional formating
  279. list sheet names vertically below the active cell - need macro.
  280. lock position of Word object in protected excel spreadsheet
  281. Print Gridlines only on sections of a spreadsheet
  282. conditional sum ??
  283. Custom functions excel 2003
  284. Is a Pop-up Calendar Possible?
  285. I need help - search formula
  286. Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul
  287. AutoSum lost a penny
  288. Subtracting 1 year from todays date
  289. Criteria with cell references
  290. SUMIF problem
  291. IF/COUNT/AVERAGE... Value returned is incorrect.
  292. how use msexcel
  293. Simple problem, simple formula, no FUNCTION !
  294. Hyperlink to another sheet within a workbook using formula
  295. formula question
  296. NPV of Cash Flow Payments
  297. Array or range lookup per row?
  298. pivot table to contains more than 1 field groups
  299. How to combine "IF" functions
  300. sum product not returning correct number
  301. forcing date to excel
  302. Multiply by a rate depending on the value
  303. count percentages
  304. COUNTIF a value within a range equals any value in an array/list
  305. showing the totals in a chart/table without charting them
  306. Custom Cell Format in a List
  307. day of month
  308. A question about INDIRECT()
  309. YTD value minus prev mth value = curent month - Rolling Report
  310. Date formatting inconsistent
  311. RANDBETWEEN INSTALL
  312. Number of payments remaining
  313. Modify A Macro
  314. Need Help Generating a Specific Formula
  315. date in excel ?
  316. How do I change colors on the row/column active header?
  317. Command
  318. excel bug in Vista
  319. Absolute value with a quick formula / shortcut?
  320. HLOOKUP question
  321. Sum of 12 cells
  322. Finding duplicates in Excel 2003
  323. MATCH & LOOKUP functions
  324. filtering a list to exclude 2 different dates
  325. Volume Weighted Average
  326. select data from a table
  327. Random Selection
  328. Hide/Don't Display Values
  329. Average
  330. Top cell in a list to match cells below of a certain value?
  331. Can a cell defined by a formula become an exportable numeric valu.
  332. How to hold running Macro?
  333. Either LOOKUP or INDEX Help
  334. How to filter only the numbers I need
  335. Modifying only the worksheet when draging down a cell reference
  336. Looking for a way to make this work.
  337. check first cell in row, move entire row to sheet of that name
  338. Optionbutton troubles
  339. Match a text
  340. Accessing cube functions (ie cubevalue) from VBA
  341. How do i change font colors for different results in the same cel.
  342. Extract a list from master list
  343. Pivot Table Range
  344. match multiple criteria ina range from multiple criteria multiplet
  345. How do I make a cashflow with pivot table?
  346. Text search within a string using formula
  347. Automatically fill info from a list
  348. How do I truncate a text field in Excel?
  349. Lookup Help, Please!
  350. Help w/complex Due Date Function
  351. formulas for multiple worksheets
  352. Look up value
  353. vlookup question
  354. Auto fill Adjacent cells
  355. IF AND with value between a range
  356. "If" function in multiple Cells
  357. Macro - copy a range and paste it in a new sheet 12 times
  358. Want to get last row that has value
  359. Help! creating code for time to decimal calculations
  360. calculating differences in a pivot table
  361. Adding text to the subtotal row
  362. User Record
  363. Calculations using Times in Excel 2003
  364. How to: Convert time value to a number
  365. Comparing 2 worksheets
  366. Microsoft Excel 2002
  367. zoom and scrolling with a mouse
  368. Text stops wrapping in cell. Tried AutoFit.
  369. How to automaticaly insert user name (login name) in excel?
  370. How do I summarize items chosen on mulitiple worksheets
  371. Any number above 15 returns false when it should be true
  372. Need help w/ adding cells and dividing SUM by number of cells
  373. Copying formula
  374. Leading Zeros
  375. row color is not being retained after saving spreadsheet
  376. how to advance dates by one year then up to 10 yrs in Excel
  377. complex randbeween formula, Excel2007
  378. Match Cells
  379. How do I update the 2005 attendance calendar to 2007?
  380. Counting unique values and subtracting those of no interest
  381. Empty Cell Result
  382. Countif array function not working
  383. If date is in the month of Sept, then "1", otherwise "2"
  384. I need help
  385. Match
  386. complicated formula help
  387. SPREED SHEET TEMPLATES IN EXEL
  388. counting age groups
  389. Calculating data within a date range
  390. SUMIF multiple criteria
  391. Using Range operator (:) In If condition
  392. color fill button is not adding color to my spread sheet
  393. Count in a variable range
  394. CF help needed with cell color
  395. need help with running totals
  396. Find then save to different worksheet
  397. Auto row insertion based on a number
  398. How do you do a crosswalk between worksheets?
  399. Cidtional Formatting doesn't work across all cells in range
  400. Count if all both apply
  401. Need a formula
  402. How do I create a checklist to auto-fill another doc using excel?
  403. excel to return system time when I press combination of keys
  404. Return value from column A if value in column B is in top 3 MAX()
  405. Database Formula Criteria Problem
  406. Protect single sheets in the woorkbook
  407. Cell Reference VS. Manual Input?
  408. Error type mismatch in writing macro
  409. Allowing Only Certain Entrees
  410. SUMPRODUCT Question
  411. Calculate Weighted Value
  412. Conditional formatting question
  413. Repeat a Macro
  414. Complicated Cell Formula
  415. help with pivot tables
  416. Display a cell address
  417. Making a letter have a value
  418. Using lookup
  419. Countif cell contians a specific number (within a list)
  420. sumif
  421. Table Name Autocorrect Feature Excel 2007
  422. FREQUENCY across multiple worksheets
  423. Protected Range Not Protected
  424. Sum up results from If statement
  425. How to Disable Unhide Sheet menu option
  426. Excel 2007 Nested Sumif's
  427. Turn off auto backup copy
  428. Generate a formula dynamically ?
  429. MATCH Multiple Criteria & Return Previous / Penultimate Match
  430. Excel: Round formula up in $5. increments =+(M4*1.1)+M4
  431. Changing the font of a cell dependant on the outcome
  432. VB count word occurence in variable size sheet
  433. Sum If functions
  434. Consolidation Worksheet Data Sequence.
  435. !
  436. Absolute Reference to the Left Until Change in Row
  437. Macro/code to hide rows
  438. Hide columns and rows
  439. number up one
  440. Counting Unique Values with Multiple Criteria
  441. Conditional Formating
  442. Automatically alphabetize excel worksheet
  443. how do I average cells if a cell is at #div/0!
  444. Merging Document Help
  445. Populate a form from a sheet in same workbook
  446. Populate an array that is a subset of a larger array?
  447. sum with multiple criteria
  448. looking for a function to make it more quicker
  449. Getting error using if then else stmt
  450. Can you link to a drop down list from another drop down list?
  451. Filter lines containing pivot table and non pivot table data
  452. Counting Consecutive Instances
  453. linking spreadsheets
  454. Data validation combo box lookup
  455. Stumped Conditional Formatting or Validation?
  456. Format Currency in-cell
  457. Vlookup question
  458. IF, then
  459. Rename worksheet in macro
  460. Workbook Headers
  461. Vlookup or another function? Help!
  462. Linked cells
  463. Nested IF function???
  464. #DIV/0! How do I remove this answer?!?!?
  465. SUMIF ranges
  466. Time-shifting information
  467. help with countif function
  468. MAX() and MIN()
  469. How to auto-increase values in currency formatted cells, by 10%.
  470. How to auto-increase values in currency formatted cells, by 10%.
  471. How to auto-increase values in currency formatted cells, by 10%.
  472. Copy down a range of formulae
  473. XML Schema Editing
  474. Macro that reformats data in excel spreadsheet
  475. Functions for manipulating arrays
  476. Leading Zeros causes rule error message
  477. Negative number morphing to a cell code
  478. Difficult formula! Need help quick!
  479. How to copy formulas between workbooks w/0 referencing source?
  480. Link to other Worksheets - when data is added updates master works
  481. VLookup Last Entry
  482. Filling Sheet numbers in a column
  483. Charting
  484. Find a Day in a Calendar
  485. Numbers
  486. converting survey angles to decimals
  487. Can I Use a Count Function for Text?
  488. Exporting data to excel in .NET 2005 C#
  489. Frequency of numbers in a range
  490. formula output
  491. How to create a countdown timer in a worksheet
  492. vlookup error...
  493. Excel
  494. help to find a string for 4th occurance
  495. HOW DO I UNDISPLAY FRACTIONS?
  496. Get Cell Address From Lookup (Alternative to Lookup)
  497. creating links in between worksheets
  498. Active cell position for macro
  499. Column of negative numbers
  500. to sinalize not sequential number
  501. Data Validation list
  502. Input Text Upon Click Of Cell
  503. Stock Smart tag Cannot update the current sheet
  504. Vlookup
  505. Sumproduct to return a text
  506. Counting Occurences In A Column
  507. soccer tournament template
  508. How to Make cell value flashing in EXcel file
  509. HOW CREATE FORMULA TO ADD THE COLUMN CELLS THAT CONTAINING DATES
  510. How do you enter a tick symbol into a spreadsheet cell please?
  511. Top 10 in descending order
  512. How to find largest value "<=" when array is in descending order?
  513. weekly time sheet for the whole team?(6 members)
  514. greater than larger than
  515. Drop-down box lookup?
  516. Help with if funktion
  517. Nested MATCH with two tables
  518. I need help with a Function
  519. Another formula question.
  520. CountIf
  521. Complex Lookup Formula
  522. Copying Filtered Data in Excel 2007
  523. count based on selection from drop down list
  524. Setting formatting for 2 places
  525. Average If Array Formula
  526. league table
  527. Vlookup with IF question
  528. Blanks counted when highlighting group of cells
  529. sumproduct question
  530. Selective Calculation of Mean & Mode
  531. Deleting unwanted lead spaces throughout a worksheet
  532. Formulas aveages in excel 2000
  533. Trying to count differences between columns
  534. Scientific Notation Issues
  535. Formatt date from text
  536. Whats better Lookup or Function Formula
  537. Calc
  538. Additional Help with range of cells
  539. External reference not working
  540. from 1 work sheet to another
  541. Question Pulling Data from another sheet
  542. Address Row and column Reference
  543. Counting Charaters
  544. I was using Excel 2007, now 2003 and my Macros won't work
  545. find number of occurences of text within a column
  546. AutoFill in a Column
  547. SumIF referencing to a CELL, rather than text....
  548. Creating summary from a list
  549. Sub CommandButton1 help
  550. displaying pictures
  551. COUNT CELLS WITH CONDITIONAL FORMATTING
  552. VLookup Function ?
  553. Password Protect a single sheet using VBA
  554. Lookup, and Return Cell Address
  555. Need help with range of cells
  556. Help with Baseball Formula
  557. If statement with Vlookup - including ISNA function to compare two columns from different worksheets
  558. Sumproduct w/ Array & criteria
  559. bringing data together from two worksheet for comparison
  560. Calculation using VLookup
  561. Converting time as 7.5 (which represents 7:30 AM) to 0730
  562. help linking information please
  563. Using VLOOKUP (ISNA) function to compare 2 columns on different worksheets in excel
  564. include in new column only if present in both columns
  565. Formulas Using Words
  566. Function does not work in a cell. Please Help
  567. Removing HTML from EXCEL?
  568. Hide cell based on value of another cell
  569. Starting payment when increase rate is known & total payment is kn
  570. External Data - Stock Quote
  571. consecutive bi-monthly dates
  572. Converting Metric to Imperial
  573. Summation over a range
  574. How would I use one cell to look at two different vlookups?
  575. Complex Lookup Question - Clarification?????
  576. V lookup with 2 criteria to return results for multiple columns
  577. Hide Cell based on value of other cell
  578. Keep formulas when copying data
  579. Do not allow negative numbers in cell
  580. Counting if Something Occurred During a Time Span
  581. Excel Formatting
  582. Pivot table woes
  583. Can I use 'CONTAINS' in an IF Logical Test?
  584. Rank function
  585. NEED HELP QUICK!
  586. vlookup if statement returning a "false" answer.
  587. change negitave value to positive
  588. Comparing similar but inexact text
  589. Complex Lookup question.
  590. linking to workbooks together
  591. Formatting text within functions
  592. modified if equation.
  593. how to change the alphabets to numbers and numbers to alphabets in
  594. PIVOT TABLE ????
  595. automatic age range formula
  596. Consolidating Data
  597. Conditional formatting compatibility with excel 2003
  598. Auto Filter
  599. Insert picture and let it automatically be copied to other sheets
  600. HOW TO LOCK THE OPENING OF AN EXCEL SHEET?
  601. Excel / Access User Conference - Oct 24-26, St Loiuis
  602. Find text and print its corresponding worksheet name and row
  603. Rounding up values
  604. send me the total excel question and answers with tips to mailid
  605. Keyboard shortcut for List Box
  606. Count Continuous data between cells
  607. finding values in a table using 2 criteria (changed)
  608. Week Ended Friday
  609. Need help with VBA
  610. Autofill Down When Text to Left is Not Blank
  611. Creating a percentage mark up
  612. Highlight data that doesn't fall within certaint range
  613. Drop Down Menu
  614. code to delete sheets not in use based on a cell's drop down list
  615. hyperlink - PDF file - relative reference
  616. Protecting Multiple Worksheets at the same time
  617. Finding Duplicate files in Excel 2007
  618. Pivot Table from Access DB
  619. Counting blank cells in a formula
  620. sum all value
  621. extracting email
  622. If Then
  623. Average Time
  624. Pivot tables, IF statements, vlookups?
  625. How do I copy records with specific text from one wkbk to another
  626. Odd Lookup
  627. Repeat symbol in a cell??
  628. recording a macro
  629. Cond. Formating
  630. Counting # of cells with that meet criteria in two columns
  631. Using data validation
  632. two dimensional arrays
  633. Conditional Formatting - new data
  634. What is the little green triangle???
  635. Timeline Start date forward
  636. How to customize number to 10 digits including 2 digits after deci
  637. Links to other workbook
  638. Address & Match
  639. Merging to data sets
  640. Criteria
  641. change cell contents to bold
  642. Function Help
  643. Conditional AVERAGE?
  644. Fixed objects will move warning in excel 2003
  645. Pivot table
  646. Excel shld allow for coment boxes w/ formulas 'mini popup sheet'
  647. Option Button HEEEELPPP
  648. worksheets
  649. is there an excel formula that tells what color a cell is?
  650. worksheet tabs
  651. looking up data in a table using 2 criteria
  652. Array data to a report
  653. How do I set up a constant reference to a cell that moves?
  654. Find volatile cells
  655. Not Proper!
  656. Count unique numbers
  657. Count hours per month
  658. I would like to merge woorkbooks contained in a spreadsheet
  659. CountIF Q
  660. Special Characters
  661. MIN IF?
  662. Find last column, move formulas over, copy/paste data
  663. Display cell name
  664. Match Table
  665. How to Match to table
  666. Double Lookups
  667. Using COS in VBA, incorrect value returned
  668. how to create sequential invoice numbers from a saved template
  669. sumif with restrictions
  670. Is it possible to set up an AutoNumber in Excel?
  671. Macro help
  672. COUNTIFS Formula Problem
  673. Calculating with time
  674. merged cells print
  675. How do I changet a text telephone number (xxx) xxx-xxxx to xxxxxx.
  676. Calculating hours
  677. How do I create a calender drop-down?
  678. Loan Estimator
  679. Lock cell as reference not value
  680. conditional format cells with formula
  681. A list of data with time stamps, how subtotal at 10 min intervals
  682. TEXT TO COLUMN FUNCTION
  683. fx="<="&B3 ??
  684. Is there a formula to transfer the last value in a column
  685. Why if I put in a figure does it change it for me?
  686. formatting column as text.
  687. excel 2003
  688. Nesting IF's and AND's - a bit of help please...
  689. Textbox and multiline text
  690. Combining Pivot Tables
  691. Consolidated Sheets
  692. Spread Macro
  693. Can you sort by most to least often recurring number in Excel?
  694. If Statement
  695. Determing Range Criteria
  696. How to calculate Compound Interest
  697. Last value in column
  698. Update data by chaning date
  699. MIN
  700. Formula help in a circular reference
  701. Linking spreadsheets..
  702. Disappearing SERIES() forumla in chart
  703. Add/Delect Macro
  704. fill in all combinations
  705. Hyperlinks keep breaking
  706. copy the same format to a cell using =
  707. Concatenate data that includes dates
  708. How to marry two working countif formulas?
  709. IF Statement Problem
  710. Offset
  711. Truncating cells
  712. Need to remove unused rows and columns to minumize size
  713. turn off 'save' prompt when closing Excel
  714. What's wrong with this formula?
  715. copy Data selection from one workshhet into an existing worksheet
  716. Custom format num > 0 with a "+"
  717. Lookup
  718. Number of days in month counted from shortened name of month & yea
  719. lookuppictures
  720. How can I get a count of specifc words in a range?
  721. Excel 07 Conditional Formatting Help!
  722. grade sheet
  723. Can I create multiple formats of text in a formula?
  724. A table within an excel cell?
  725. How to permanently set margins
  726. Excel 2007 "Find" option won't work.
  727. Working backwards-matching names
  728. Replacing a corrupt worksheet
  729. Drop Down List Help
  730. IF Command Help
  731. Alternative IF Statement
  732. SUM Problems
  733. Combining Lists/Summary Page
  734. Vlookup across worksheets.
  735. with multiple option buttons on my form how do I isolate groups
  736. Hyperlink two sheets in a Excel Workbook
  737. FALSE value
  738. Counting Occurences Formulas
  739. Counting rows from columns on multiple worksheets?
  740. SUMIF and text with decimals
  741. DSUM Not Very Convenient
  742. Array selections
  743. How do I use integration to work out the area under a curve?
  744. Return value from a list
  745. Opening a Microsoft Word 2003 Document.
  746. How to Unlock Worksheets with a Macro?
  747. COUNTIF headscratcher
  748. "False"
  749. Fill blank cells with an if formula?
  750. using indirect to sum range
  751. Function time
  752. Linking cells in different worksheets
  753. Basic question...sorry
  754. Extract single occurence of order number from list
  755. adding up number of people present at certain times
  756. Pivot table & weeknum query
  757. Pivot table & weenum query
  758. EXCEL 2003 HELP
  759. Calculate negative hours (time)
  760. sorting by character
  761. Finding Average with Criteria
  762. how to transport bold and italicized text from other programs
  763. Statistic Functions- 30 value cap???
  764. Conditional Formatting Rules Manager Excel 2007
  765. Multiple "source" workbooks linked to single "destination" workboo
  766. Match Cells
  767. vlookup column index number argument
  768. Check Boxes
  769. MAX across different worksheets
  770. Help - linking and/or formulas.
  771. Creating a formula for two columns with Criteria
  772. vlookup results in different cell
  773. Save & next
  774. Date Conversion Formula Needed
  775. If match function
  776. Regressions using dates
  777. Values from 3 separate drop-down lists entered into single cell
  778. Data Validation List created from a text in a Cell
  779. What is Run Time Error 6028?
  780. Cell Comments
  781. Hiding functions
  782. formula to throw out high number and low number
  783. How to get Countif to work this out?
  784. sheet! functions
  785. Difference between dates
  786. if function
  787. how to use functions.
  788. Mind-numbing simple data validation ... string from 1 to 64 chars
  789. auto number formatting
  790. Autofilter Wildcards Not Working on Number Column
  791. Please assist...
  792. Finding the difference between two numbers
  793. Dependent Lists from multiple values
  794. combine vlookup and copy function
  795. Getpivotdata behaving flaky
  796. Excel 2007
  797. Using named ranges in dynamic charts (excel 2007)
  798. Move Worksheet to other File
  799. Macro to add row between list of data...
  800. Vlookup - Is there a Maximum number of entries?
  801. Excel lookup
  802. Re: Question on this conversion code switching between r1c1 to A1 format tia sal2
  803. import stock prices from discount broker acct
  804. Pulling info 2 cells and putting it in one
  805. percentage
  806. Formula
  807. Question on this conversion code switching between r1c1 to A1 format tia sal2
  808. Refering to a named range in a chart: 2007
  809. adding leading zero in Excel
  810. Excel memory not working
  811. comparing two list and need to find exact in both lists
  812. Match function problem
  813. Percentages
  814. Lookup function one row at a time
  815. Lookup based on 1st non-blank cell
  816. Formula returning wrong answer
  817. Re: Formula returning wrong answer
  818. RE: Formula returning wrong answer
  819. Print worksheet
  820. EOMONTH problem File error: data may have been lost
  821. Now function
  822. How do I remove a forgotten password from an Excel Worksheet?
  823. Excel 2003 Add-ins - Assign Number
  824. Expanded view of Validation List
  825. Earliest date using WEEKNUMBER
  826. sum numbers of a different colur in a row of data
  827. Auto Fill isuue...
  828. Create a printable FORM
  829. freezing dates
  830. Visual basic editior
  831. Calculating data between two given parameters
  832. starts with decimal point only if number is like 0.###...
  833. changing August 31, 2007 into 31.08.2007
  834. Macro for checking duplicate entries
  835. Is there a formula to hide/ display row based on cell value in Exc
  836. How to remove multiple hyperlinks at once
  837. Summing up times by key words in diff column
  838. Change cell color from yellow to blue
  839. Using a date (datevalue) to trigger adding a value to a cell
  840. Ranking by multiple Criteria
  841. Need formula to calculate subtotal before sales tax
  842. VLOOKUP error
  843. convert date to yyyyddd format
  844. write formula that icludes data from sheet 1 to sheet 2 of my spr
  845. Keeping the correct cells when making a formula?
  846. sumproduct contains
  847. Linking two spreadsheet, pulling data from one cell to another, data is being truncated
  848. VBA Project - Second opinion please!
  849. How do I create a total sheet
  850. How to make a Let statement in Excel?
  851. Merge data in two worksheets based on key data value (like databas
  852. combo box
  853. Naming a non-blank range from a col containing non-consec. blank c
  854. Monthly, Quarterly formulas
  855. How to determine if year is a leap year
  856. Popup based on selection from list
  857. Statistics and Excel
  858. Formula Help
  859. How do you use sumproduct to return specific cell data?
  860. Losing Formulas in Excel
  861. Row Formatting
  862. Apologies , but I STILL need help with reversing content
  863. IF and
  864. live instant updaate
  865. Solver giving solutions with decimals
  866. Looking up data with varying Lookup_value
  867. Subject: How to Reverse Contents in an Excel cell (NUMERIC VALUE)
  868. Subject: How to Reverse Contents in an Excel cell (NUMERIC VALUE)
  869. Subject: How to Reverse Contents in an Excel cell (NUMERIC VALUE)
  870. NEW QUEST/REQ in "How to Reverse Contents ..." Pls Respond? TIA
  871. How can I extract characters from inside a cell?
  872. Checkboxes
  873. countif with two sets of non consectutive ranges at the same time
  874. Finding Source of DropDown Field
  875. Data Validation list sort order
  876. Need help with "blank" in formula
  877. Add content of hyperlink cells
  878. Macro to add row with sequential numbers
  879. Headers/Footers
  880. Headers/footers
  881. Copying cell colours
  882. Not sure what function to use?
  883. IF statement with AND or OR?
  884. how compear two or more values into the same function
  885. Match & Index
  886. Excel / Access User Conference - Oct 24-26, St Loiuis
  887. Please keep is simple.
  888. Worksheet name
  889. A problem with the function "NOW"
  890. help with formula
  891. using cell contents in a formula
  892. Calculating from values in pivot tables
  893. help on Converting R1C1 to A1 and A1 to R1C1..tia sa2
  894. sumif array function
  895. have cell in sheet 1 look up last row of column 'x' in sheet 2
  896. to get value
  897. dialog box to input data?
  898. Defaulting test to Upper case
  899. Clearing cells when selecting from a drop down list
  900. Condition formatting & Formulas
  901. Round time to quarter hour
  902. if then formula for total time ;overtime hours versus regular
  903. Decimal Places
  904. Multiple Password
  905. Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2
  906. Macro HELP!
  907. I have 4000+ rows in a worksheet, how to delete 100's at a time?
  908. How do I build a sensitivity analysis table?
  909. Excel headers
  910. Can cells be formatted so that if A2 says "Joan", G2 says "$25"
  911. minimum and the corresponding value
  912. Limitation on MID function? - very large string
  913. Subtotals Nesting Error - Totals Above
  914. Copy of data from word into excel
  915. Help with Dates
  916. Rank formula
  917. how can i choose the highest number in excel range
  918. how to put three columns into one dialog box?
  919. Conditional Formating
  920. Count Occurance
  921. comments in cell and web pages
  922. Prevent duplication across sheets
  923. Link to Workbook(s) received by email
  924. Help with formula
  925. Warning Message
  926. Date reporting in cell
  927. percentage negative values in column
  928. distinct
  929. Data insertion
  930. incrementing
  931. Conditional formatting
  932. Probability & Profit
  933. how do i turn on view side by side
  934. Date Stamp
  935. Date format
  936. sumif-sumproduct
  937. Function to change cell color
  938. Validating & Error checking function
  939. Rounding time
  940. creating a formula for racing
  941. using value of cell to differentiate 3 group of testing sequences
  942. RANDOM # around a MEAN with STANDARD DEVIATION
  943. How to format number and not return ######
  944. what is the excel formula for market volatility?
  945. Muliple lookup in one cell
  946. excel won't print boarders
  947. Display "this week" column headers w/date & day of week?
  948. Conditional printing based on cells greater than zero
  949. Help with look up formula
  950. Adding cells that have varying contents
  951. Compare worksheets for duplicates and copy data to 1st worksheet
  952. If Then Else Formula for Excel Worksheet
  953. Formulas "PPMT", "IPMT
  954. Fast Fourier Transform outputs in Excel
  955. Calculation results as static data not formula.
  956. macro
  957. Multiple references
  958. How do I set up a counter cell?
  959. excel formula's
  960. Counting number of times data matches
  961. Update Date Cell when any of target cells change
  962. Nested IF, reports incorrectly, can't find anything like it to ref
  963. Time
  964. Formula
  965. How can I insert rows without getting error"cannot shift objects o
  966. numbering folders
  967. Data Validation list order
  968. IF formula to highlight?
  969. Statistical Funtion
  970. Formula help
  971. Data Validation Update Validation Selection
  972. If/Then
  973. Link excel comments to cells
  974. Problem with dates
  975. Using VLOOKUP with a 3D range
  976. Returning a range using IF
  977. run programme error occuring
  978. how do I print only horizontal gridlines in an excel worksheet?
  979. Averages
  980. display 0 instead of #DIV/0!
  981. A Microsoft Excel recall spread sheet using calendar dates.
  982. Negative number formats?
  983. Degrees of Freedom in TTest
  984. Breaking out data in a cell
  985. Ranking
  986. Day Conversion
  987. Rerouting connectors
  988. Calculating time from a specific paycheck period
  989. Paste visible cells?
  990. present value of a future amount
  991. Complex Time Window / date based calculation
  992. average that includes estimates if data not available
  993. Find Function
  994. Função Logaritimica
  995. Can not access small cross to pull-down data
  996. Count number of sheets
  997. Change Day to Month - VBA
  998. How can I evaluate whether a trend is positive or negative?
  999. Character limit when retrieving indirect text from external sheet
  1000. Embedded pdf file stack when Autofilter is applied