PDA

View Full Version : Microsoft Excel Worksheet Functions


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

  1. Logical functions with dates and TODAY()
  2. Find value in a Range of Cells and perform Conditional Formatting
  3. Formula
  4. Lookup function
  5. how to delete recent cocuments
  6. Calculating Service Fill Rate
  7. colour cells, same numbers different worksheets
  8. a cell contain formula, how to extract value of that cell
  9. Using the VLOOKUP function to find an Average
  10. Countif(and
  11. Sum a column is criteria in two in column and other column are met
  12. Popup File
  13. Function doesn't work
  14. How do i use sumproduct if my lookup table is alpha or alpha num?
  15. Data Matching
  16. easy if statement formula
  17. Counting Multiple Text Cells
  18. Excel
  19. Looking up a date
  20. S Curves
  21. Conditional Formatting - Formula to fill cell using >%
  22. HOW I WRITE 12=10 OR 16=20 in excel
  23. Counting number of rows based on mutiple criteria
  24. Emailing worksheet
  25. Lotus/Excel questions
  26. If statement conversion from Lotus to Excel2007
  27. extracting R-squared value from a chart
  28. INDEX MATCH AND ??
  29. Two question on working with text
  30. Modify a Formula
  31. Formula needed
  32. Ignoring Blank cells in 'IF' formula
  33. IF Statements
  34. Synchronize data across 2 sheets
  35. Week
  36. How can I autohide rows that have "zero" values?
  37. Sum of different value in different worksheet & cell number
  38. count between dates
  39. Exporting data using Pulldown List & VLOOKUP
  40. Pop up Box
  41. Copy Paste Financial Years
  42. Formula
  43. help creating a time function
  44. hide columns on a protected sheet
  45. Separating equal values
  46. Links in Excel
  47. Transpose & offset data from a table
  48. #N/A result because data is on another worksheet
  49. Paste Hyperlink result as working hyperlink
  50. compare 5 columns of text and highlight duplicates based on repeti
  51. Count Customers by Account Size
  52. Using the Question Mark With COUNTIF
  53. amortization of a mortgage
  54. multiple columns and row table and finding the answer
  55. Entering an If formula using conditional formatting
  56. Excel copy + paste
  57. Re: Help needed on date matching and cell reference.
  58. Is there a function in excel where you can the beginning of the mo
  59. SUMPRODUCT
  60. join imported Excel 2007 files
  61. Calculate weighted average for 1 column
  62. can i give a number an automatic colour on spreadsheet
  63. Lookup data in the list
  64. weighted average - 1 column
  65. Relative Reference in Conditional Formattin
  66. remove headers & Footers Excel 2007
  67. Problem with Refresh all external data
  68. AND formula
  69. count values in range based on value in same row
  70. Creating Visual Excel Cell Alerts
  71. Compatibility Mode error w/ Defined Names
  72. Looking up both row and column to give a third value
  73. offset, transpose funcion
  74. HOW TO DO ENABLE ENABLE THE QUERY PARAMETER BUTTON?
  75. Selecting items
  76. Multilayered Spreadsheet Function
  77. Auto fit row height
  78. subtracting 2 cells but only if 1st cell is greater than 0
  79. Vlookup and rounding
  80. shared workbook in excel 2007
  81. Calculate percent on numbers in different sheets
  82. Highlight rows if duplicates are found
  83. Formula To Bring The Best Name 2
  84. calculate percentage from cells in different worksheets
  85. Need Formula to "Adjust" to New Column Assignment
  86. simple formula help for matching information
  87. calculate percent between 10.0 and 12.0 for data in multiple sheet
  88. Offet?
  89. Vlookup and retrieve values 1 row below the normally retrieved val
  90. Excel - Ignoring the contents of cells when there are letters in thecell
  91. IF THEN copy & paste macro
  92. using two cells 1 with total time n 1 with date how can i put the.
  93. Removal of Zero
  94. Negative Standard Deviation?
  95. SUMIF/AVERAGEIF with mulitle range and sum ranges
  96. Copy and move check box (check boxes) with new cell link?
  97. how to trigger data
  98. Rounding dollar amounts in half dollar increments
  99. How do I calculate a specific formula for price increases?
  100. if function?
  101. Unhide, Unprotect, Enter Password
  102. Max function
  103. 90 day Running total
  104. VLOOKUP to return Cell Address
  105. Comparing two spreadsheets
  106. multiple match
  107. typing in a new cell and carrying the formatting of the previous c
  108. sumif to aggregate month to quarter
  109. Password Userform
  110. Vlookup
  111. writing a formula in Excel spreadsheet to track how long data has
  112. Change listbox text size in Excel 2007
  113. Formula To Bring The Best Name
  114. Counting number of cells
  115. Macro Fill
  116. Macro Fill Formula
  117. Search
  118. DSUM - SUMIF - or something else?
  119. Conditional unlock for cells
  120. Multiple data returning initial hit
  121. Delete a sheet
  122. Conditionally formatting numeric data and text differently
  123. Display tabs for all worksheetts at bottom
  124. Number Formatting Issue
  125. Why can't I repeat a sort on another range of a worksheet?
  126. SUMIF and multiple criteria
  127. Data Matching
  128. create list based on criteria
  129. Multiple Variables in Conditional Formatting with Excel 2003
  130. can't save changes to workbook; ready only
  131. Splitting data from one spreadsheet into multiple spreadsheets
  132. Does date in Cell A1 occur between the date in M1 and Date in X1
  133. Collated Survey Analysis Finding Average
  134. Count my Customers
  135. Correcting Multiple Div#0s
  136. Increase cell value by 1 based on another cell change
  137. testing for left 2 characters in set of 3 choices
  138. Countif function
  139. Unique Records
  140. If over 60, then show all detail
  141. if(iserror()) question
  142. When entering formula it does not show the value but the formula
  143. Counting cases between dates
  144. Contatenate folder path strings, how ?
  145. Time Format
  146. Count if between date parameters
  147. Formula to bring in the header
  148. Where best to place an instruction in a VBA script
  149. Is there a more efficient way to write this SUMPRODUCT
  150. Sumifs with data and dates - I can not figure out the dates
  151. How do I not count cells that have formulas in them
  152. how do I format numbers as text
  153. The blank cells i need to count have formilas in
  154. COUNTIFS function
  155. conditional formatting??
  156. Merge Problems
  157. If Then formula w/ alphanumeric listbox
  158. I don't want row 1 as the column headings
  159. Excel Formulas look different
  160. Excel 2003 - A macro to exit excel
  161. Possibly an IF function?
  162. Database argument in Excel 2007
  163. vLookup
  164. SUMPRODUCT COUNTIF Problem
  165. numbers in numerical order
  166. Removing text in combo with anther FIND function
  167. Nested IF Function problem for Excel 2003
  168. How?
  169. Copy first row to alternate rows
  170. Adding text values in Excel
  171. IF clause for a range of cells
  172. Generate Payment Due Date to exclude Weekends and Public Holiday
  173. How do i count the number of text Entries of one word over a range
  174. Location of the first greater than cell
  175. Check if Duplicate with Exceptions
  176. Excel hyperlinks and Windows 7
  177. View 2 workbooks to compare
  178. Importing etc.
  179. #DIV/0! ERROR
  180. VLOOKUP: Referencing worksheets whose names contain commas
  181. Converting pounds and ounces in worksheet for a recipe
  182. counting instances of predefined text in a row
  183. Sorting with merged cells in the worksheet
  184. TITLE FOR A ROW GROUP
  185. TITLE FOR A ROW GROUP
  186. Need RANK Function for Text
  187. HOW CAN I EXTRACT TEXT TO THE RIGHT OF A THIRD SPACE FROM THE LEFT
  188. How to convert hyperlink in Excel to show hyperlinked address?
  189. XML Element mapping
  190. Scorekeeping Formula
  191. Copying a Conditional Formatting Formula
  192. How do I make headers for columns in which their are 6 columns?
  193. Y Axis labels: How to make them different to figures used to plot.
  194. Creating an Income & Expenditure Sheet
  195. how do you do reduce ratios in a spreadsheet
  196. emailing autofilter results
  197. Excel Formula for adding training times.
  198. Check if Time falls between ?
  199. Auto Fill function in Excel 2007 not working properly
  200. row number of last non-blank cell
  201. Rounding hh:mm to nearest 15, 30, 45 minutes
  202. Spell Check in Protected Work Book
  203. div/0!
  204. Overwriting a cell with a formula without deleting the formula
  205. Format Time
  206. Formula to go into sub folders of main folder and get values from
  207. How to Sum a column if reference column is blank
  208. excel 2003 (11.8307.8221) SP3 - custom cell formatting question
  209. Copying Date and pasting special - DATE CHANGES?!?
  210. LOOKUP VALUE OCCURS >ONCE IN TABLE ARRAY - RETURN LAST OCCURRENCE
  211. Macros and security
  212. COUNTIF ?
  213. return a value in one cell based on multiple formulas
  214. Mark Up
  215. IF in formula
  216. SUMPRODUCT and INDIRECT
  217. adding a "relationship code" to a worksheet
  218. How can I select the first blank cell
  219. Formula Question
  220. SUMPRODUCT and INDIRECT
  221. Reading Multiple Files
  222. If
  223. Excel basic quiz
  224. Format date in header
  225. Counting current streak
  226. Simple Count of certain cells
  227. Vlookup in multiples columns
  228. conditional formatting in excel 2007
  229. How to seperate ALPHANUMERIC data in a cell in an excel sheet.
  230. Different Passwords for different worksheets in one workbook
  231. Retriving column header for non empty cells in a row
  232. Sum with a slash "/"
  233. Divide two cells and if the number is negative display is as zero
  234. Shared Workbook User had unsaved information disappear
  235. Extracting data from multiple new workbooks via one master workboo
  236. round result of sumif formula
  237. excell formulas
  238. how to delete and insert in a two cells merge using Access 2003?
  239. Re: Sumproduct or ????
  240. Newbie question - column letter displayed instead of number
  241. Days Count Sheet Help
  242. Right function
  243. Embeded IF - between ranges
  244. Formula that will not return "0" from a blank line
  245. import data from several spreadsheets into one spreadsheet
  246. RE: Parameters for Random Numbers
  247. Parameters for Random Numbers
  248. Populating worksheets from source worksheet
  249. I need to populate different worksheets from a source worksheet.
  250. Transpose stacked lists of values
  251. Indexing Sheets in Referenced Workbook within formula
  252. Maintain cell reference after value is moved
  253. Turning numbers into Dates
  254. Using VLOOKUP wrong?
  255. Random Numbers and Me
  256. Random Numbers and Me
  257. Maintain cell reference after value is moved
  258. Need a function
  259. Random Numbers
  260. IF Statement with Dates & Calculations
  261. Lookup & return multiple rows based on cell value
  262. excel problem
  263. Worksheet to Worksheet skip blanks
  264. Spin Box Date and Sumproduct
  265. Nested IF Function help
  266. E2007 formulas display as formulas, not results
  267. I can't seem to find anything with regards to this.. sorry
  268. Excel lookups should have a return paramater if not found
  269. data validation fonts differ in drop down box
  270. Any Way to Save Eons of Typing? Automating 3D Reference to Sheet N
  271. Average number excluding 0 and blanks with text criteria
  272. Sumif Format Equals
  273. #Adding new worksheet problem
  274. Spin Box with Dates and Lookup
  275. Count text with specific criteria ignoring N/A and blanks
  276. Paste Values Based on Conditional Value
  277. Conditional Format Q
  278. if and and calculations
  279. What Formula to use when looking for text over multiple worksheets
  280. @How to add new worksheet on right side....
  281. Excel formula request
  282. Rounding date field up to next first of month, with existing formu
  283. Entering a dollar amount w/out having to enter the decimal
  284. If Formula??
  285. Tab Key
  286. Using the Address Function
  287. Calculate hours, past midnight etc
  288. linking a range of cells (=) to another range
  289. Excel 14.0 - higher frequency of (Not Responding) & screen going W
  290. % Change in reverse (algebra)
  291. Determine if 2 cells share a common word
  292. #NUM!
  293. How do I add the formula bar?
  294. Need help with formula
  295. Not just remove dup rows but combine columns
  296. summary
  297. COUNTIF for date and amount
  298. What if analysis icon is not available
  299. how to calculate brokerage in execl
  300. Sorting and grouping data with varying number or rows
  301. Fast fourier transforms
  302. Strange Function Copy
  303. having issues converting from 97-07 with conditional formatting
  304. Is there a one button shortcut for "copy cell above & paste here"
  305. Macro code behind button
  306. If Statement
  307. convert time to decimal
  308. I cannot enter information in excel sheet, info bounces to top
  309. Calculating turaround time using IF function
  310. Display results of formula
  311. Nested MID and FIND - OR?
  312. Sum function changes arguments
  313. Calculate pivot table items in 2007
  314. Adding data to a 2007 pivot table
  315. search for text "beginning with" "containing" wildcards
  316. convert 13.11.2009 general to 13/11/2009 date, how to
  317. Between dates
  318. Copy or Move
  319. linking worksheets and files
  320. SUMPRODUCT or COUNTIF FOR TEXT VERIFIED LIST
  321. Trim
  322. date and time difference
  323. Date and Time
  324. How to Color a Cell Based on a Range of Cells with Colors
  325. Excel to Word
  326. DateRange Lookup no exact match, can't use lesser
  327. Counting Text Occurances - HELP PLEASE
  328. counting dates <= 7 days ago based on criteria in a diff column
  329. Condition formulas for multiple columns
  330. Sumif and Specified Ranges
  331. cell displays 0 when formula is valid
  332. Column Width
  333. how do I get a php code
  334. Summing Up My Time (minutes)
  335. how do I dropdown list
  336. Summing Cells with Text and Numbers
  337. If statement
  338. RE: CAN YOU SOLVE THIS!!!!!!!
  339. =I34*H34 without N/A
  340. If sign of sum is negative change to positive
  341. Excel 2007 Linking Cells
  342. What's wrong in this Eqn?
  343. multiple V-lookup
  344. IF, THEN SYNTAX
  345. Comments
  346. Excel 2007 CF Multiple criteria
  347. Network drive
  348. Refernce 2 sheets & same columns & rows
  349. Summing over multiple worksheets
  350. Indent
  351. Auto fill
  352. Can you solve this????
  353. Test
  354. Mapped vs Network drives
  355. Total weekly worksheets to quarterly
  356. Insert a new Worksheet AFTER the existing (Active) sheet
  357. What formula is needed to return the number of spaces indented?
  358. Removing Macros
  359. How do I get my data back in excel after hiting F11 by mistake?
  360. excel formula syntax
  361. Cell Reference
  362. Combo Box text and Controls changing size on Monitor change
  363. Functions
  364. Caps Lock vs Lower Case
  365. Sig Figs
  366. Re: How I convert a numbers to tex --10 to ten
  367. How to convert numbered cells into blank
  368. Previous Posts
  369. vlookup
  370. Dynamic Range in Offset Help Request
  371. Dynamic Range for Offset
  372. Re: Averageif puzzle
  373. PivotTable/Chart - Statistics (Excel 2007)
  374. Determine if a month falls between two dates.
  375. Re: How I convert a numbers to tex --10 to ten
  376. Use extract into a condition
  377. Excel Worksheet
  378. How to Control a formula by a character in adjacent column on same
  379. formula finds values in apparently blank cells
  380. how to calculate a projected date
  381. In Excel ,
  382. Counting Consecutive Numbers in a List
  383. Counting consecutive numbers in a list
  384. Using time functions to give a warning
  385. Counting consecutive numbers in a list
  386. Formula displaying don't know why
  387. Count Blank Cells & Letter P
  388. Re: Auto Sum range with multiple columns.
  389. adding a toolbar function to an excel cell
  390. assign numeric value to letters and sum with other numbers
  391. How can I change the row height of specified rows?
  392. Drivers for percentage increase
  393. Format within a Function
  394. Write formula for simple copy and paste to another cell
  395. What If or conditional formatting?
  396. Specific word - font color change
  397. Vlookup with more than 15 digits
  398. Unable to see custom Ad-Ins ribbon tab in Excel 2007 + Windows 7
  399. MULTIPLE PRINT AREA
  400. test posting calculations formula tab
  401. test1 v-2masa
  402. sum letters with values and numbers
  403. Help with a formula
  404. conditional function?
  405. Totaling YTM on a group of loans
  406. Excel Function in UDF
  407. WHAT DOES 'DATA SOURCE REFERENCE NOT VALID' MEAN?
  408. If statement
  409. Parameter "TwoDimension" on RowVector function
  410. Restricting entry
  411. Listing only the workdays of a month
  412. Lookup functions-V lookup
  413. CONCATENATE FUNCTION
  414. Conditional Format based on Month of Date in Cell
  415. transform formula
  416. Calculating the number of entries between 2 times
  417. If date in range is before today
  418. Count if equal to first non error cell
  419. Dates not honoring Regional/Language Options
  420. count if equals first non error cell
  421. Same Date a year ago
  422. Same cell but different worksheet
  423. VLookup with multi-condition
  424. Excel Converson
  425. array frequency data search
  426. freeze pane option not available
  427. count the presence of a date as 1
  428. Re: Trying To Put IFs into a Function
  429. Re: Trying To Put IFs into a Function
  430. AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK
  431. How can I add the new record from another list to current one?
  432. Automatic Sorting?
  433. get an average of 3 cells, if they all have numbers, in excel.
  434. FORMULA FOR CALCULATING MIN MAX INVENTORY LEVELS
  435. Editing time that has its colon removed
  436. hyperlinking email addresses
  437. auto sum
  438. formula for local time and GMT?
  439. 6 Day working week (friday holiday)
  440. FYI: MSDG not displaying posts; expects duplicates :-(
  441. any method of keyboard remapping?
  442. Can I increase the view of a drop down list beyond 8 in Excel?
  443. SIMPLE CONCATENATE FUNCTION
  444. tongle between cells
  445. Fill Handle
  446. How To Protect Sheet For SHIV
  447. howcanprotectmysheet
  448. Array - conditionally sum the 1st occurence in non-contiguous rang
  449. Vertical page breaks - one per column
  450. Eliminating cells with a zero
  451. Excel 2007: Vlookup - Results without #N/A
  452. linking to formula template on different tab
  453. SumProduct not right
  454. Excel 2007: Vlookup Problem
  455. calculating a minimum fee
  456. If Then Help
  457. Double Match (one with less than or equal to)
  458. Remapping keyboard on Excel
  459. @which function to use when
  460. Arranging words in a column in dictionary wise order
  461. Need a formula
  462. If >0, count various codes in a range on another sheet
  463. Two types of Data Validation in a cell?
  464. Copy contents of a cell into a blank cell
  465. Creating a Formula in Excel
  466. Data extract
  467. Copy contents of one cell into another if cell is blank
  468. How to return a range of values in a drop-down.
  469. Formulas & Dates not working in .xls file
  470. Nested Conditional Functions
  471. copy between workbooks
  472. Help with colour formula
  473. Cross Referencing
  474. Inserting symbol
  475. attach files
  476. trouble copying a cell from one workbook to a new one
  477. Refresh - F2
  478. Need to create rows from columns
  479. How can I automatically color a row based on cell content
  480. Excel - IF formula with range of cells
  481. Lookup or an alternative
  482. Vlookup not working to merge workbooks?
  483. I want to copy the same image into worksheet with a function
  484. Importing Access DB into Excel changes my calculated fields in Exc
  485. Auto Calculate Question / HELP!
  486. How to average values based on time period
  487. New Drop-Down Functionality in 2007?
  488. Hide/lock worksheets
  489. contitional formating with more then three options
  490. calculate date of birth with an end date and age
  491. lookup over several columns
  492. count text occurance in range
  493. number times a value appears in a column beside it chronological
  494. countif using other cell values for 'range' and 'criteria'
  495. convert numbers
  496. How can you attach an e-mail into an excel worksheet?
  497. Lookup cell for documents in a folder
  498. Hide Raws even the Auto Filter is active
  499. Custom Format Cell with Reference to another sheet
  500. How can I number rows based on unique values in another column?
  501. Locking comments
  502. Multiple Users - Different PC/Locations
  503. Indirect function
  504. fomula required
  505. subtracting 28 days from a date
  506. text fragment comparison
  507. Dynamic chart
  508. Fill color
  509. Variance Analysis and Excel
  510. my formated column is displaying one cell incorrectly
  511. Excel Formula and Variance Analysis
  512. Search for Employee Names
  513. Need help with formula to weed out duplicates
  514. Create a button to insert a new row.
  515. Re: matching data in 2 worksheets
  516. random integer with sum constraint
  517. Can I show a number like 1,935,674,923 as 1.9B?
  518. Concatenate including a date so that the date appears as a date
  519. dates in VLOOKUP
  520. print area Excel 2007
  521. Re: matching data in 2 worksheets
  522. RE: Extracting Text From Right To Left - MID & FIND
  523. Decision tree
  524. Count based on date criteria
  525. drag a formula downa column keeping one value the same?
  526. Calculating a date
  527. Extracting text from right to left using MID and FIND
  528. how do i create a divisible formula
  529. ISERROR function
  530. Match values in more than one column
  531. VLOOKUP/HLOOKUP Query
  532. Using multiple if statements
  533. Display result depending on value entered
  534. Working with time calculations
  535. Traspose Column data into Row
  536. Excel worksheets won't all print
  537. How can I lookup when match has more than one value?
  538. sumif wildcard criteria
  539. Re: Linking data from the Internet
  540. sumif wildcard criteria
  541. Date to Day
  542. Creating dynamic ranges which are named.
  543. Logical Test: Text Against Number
  544. how do I copy only visble cells in office10
  545. Date formulas
  546. How to use the search in an if statement
  547. Lookup Text and Receive Other Text in Return
  548. Help with Formatting Number as Text
  549. Problems with ngs
  550. Help Formating Numbers to Text
  551. rolling 12 month date filter for pivot table?
  552. Formatting Numbes to Text
  553. Modify Formula
  554. Formatting Numbers as Text!!!
  555. Formatting Numbes as Text!!!!
  556. Need help comparing 2 columns of number to find unique numbers
  557. Excel Worksheet does not save
  558. Count cells
  559. help with sumproduct
  560. Carriage return in same cell without using alt-enter
  561. Countifs function equivalent for Excel 2002 (XP)
  562. Lookup Values, return multiple.
  563. Matching and combining information on two separate worksheets
  564. If - Then question
  565. Check Box Question
  566. Lookup one value, return multiple values,
  567. Time Sheet Summary
  568. Error: Value in Formula of wrong data type
  569. sumproduct
  570. Checking data in 2 columns against a further 2 columns....
  571. Modify a Formula
  572. use Find without hardcoded value but a value from a cell
  573. Is 4th January 2010 = Week 2??
  574. validation controls in excel
  575. IF & VLOOKUP
  576. Excel changing date format after VB has run
  577. Sending data to tabs
  578. Using "Verifiers"
  579. when setting a cell to equal a blank cell it displays 0
  580. Generating random numbers
  581. Tick mark
  582. looking for a function that hopefully exist
  583. Copy from worksheet 1 to worksheet 2, 3 , 4 etc..
  584. count unique values with auto-filter on
  585. cell formattiing
  586. Paste Special/Format
  587. Problem with a Array formula, Please help !!
  588. Help
  589. Pivot table for worksheet text fields?
  590. Autofill problem in Excel Office 2007 using Windows 7
  591. non-numeric in a calculation
  592. This should not be so difficult but it is to me re: dates for medi
  593. formula help - subtracting numbers in two colums but using a specificnumber if one column is greater than another
  594. Creating a duplicate workbook without values
  595. Weekly Time Sheet Summary
  596. calc. an anniversary date(50 years) after marriage date in excel
  597. Weekly Time Sheet Consolidate
  598. How do I get a macro to be non worksheet specific?
  599. CHANGE TEXT DATE TO NUMERIC DATE
  600. Converting hour/minutes to hours/hundredths
  601. Timetable problem
  602. Lookup and return next value
  603. clueless where to start.
  604. Lookup problem Excel capabilities
  605. Statistical question
  606. matching and entering data
  607. Is there a simple formula to convert time in hundredths to minute
  608. How do I tally numbers, of a specific expense category?
  609. Look up if a value from an array "A" is in either array "B" or "C"
  610. Summing and Averages with non-numeric cells
  611. RE: First non-blank row in WS after hyperlinking
  612. Focus On Open - Goto
  613. Formula returning an error
  614. change default table style
  615. Cell update delay
  616. blank cell instead of x
  617. How do I extract the decimal places from a number in excel?
  618. bsval
  619. Incrementing Part of an Address
  620. Exclude Weekends
  621. No of Days between two dates and offset formula
  622. Pivot Table (behind the scene)
  623. A macro for deleting lines of text
  624. Re: issue with IF and text
  625. deleting numbers in a column
  626. Nested IF Statements
  627. FORMULA HELP
  628. Hyperlink text from linked workbook
  629. check box
  630. How to insert lines into a workbook without changing references?
  631. Email Extraction
  632. Excel Formula Help?
  633. Linking computer dates (time) to spreadsheet dates that have formu
  634. Xindex
  635. Help with a predictive analytic
  636. I'm unable to change font size on a excell sheet
  637. Why do I get #### when I Autosum in Excel?
  638. Multiple Values
  639. How to make different cells fill in automatically from one entry?
  640. Lookup one value, Return matching correspnding values
  641. Real time function
  642. need help with creating a formula which checks more than 40 cells
  643. nested ifs
  644. Excel - count if a number falls within an array in a column & add
  645. EXCEL07 CELL FORMULAS WILL NOT COMPUTE TO A VALUE
  646. scoring multiple ski meets from one master list
  647. Excel 2007 / right-click / pick from drop down list
  648. sumproduct including previous years
  649. Why messages fail to appear on MSNews server
  650. Break Calculation
  651. Need Help with Percentrank formula
  652. LOOKUP function does not work with row vector of numbers
  653. Using INDIRECT within functions
  654. CONCATENATE text to create a formula to be evaluated
  655. graphic in excel based upon result
  656. How to count the maximum number of consecutives?
  657. Office 2010 beta exel
  658. Totalling seperate cells from a HLOOKUP function
  659. one cell in a row contains a number
  660. Smallest to Largest
  661. Can I find the last value in a column of cells?
  662. Fill date series in table
  663. Round Up and Round Down Time
  664. How do I set up inverse Gaussian error function in Excel?
  665. Calling name of Sheet as a Variable?
  666. #NAME? Error With User Defined Functions
  667. how do i retrieve the largest value from several records/rows in e
  668. Can a macro be paused to allow input, then continue?
  669. Logical Test: Text Against Number
  670. Statistical Analysis: Pass/Fail Correlation
  671. Exclude Hidden Row Values
  672. SUM and Frequency for Multiple SHeets
  673. IF Statement Help - Not seeing whole cell
  674. Unusual VLookup in 2007
  675. How to use numeric keypad in 7 Excel-(raw beginner)
  676. Create sublist in new worksheet
  677. How do I print a one page spreadsheet multiple time, each with i.
  678. Changing Cell Color Based on Value
  679. Sum Products with VLOOKUP
  680. inserting a picture into unprotected cells in a protected excelworksheet
  681. Amortization schedule with veriable payments
  682. Timesheet formula problem
  683. I need help matching spreadsheets
  684. Comment with date stamp, again
  685. Using names referencing a cell in another workbook
  686. Protect Sheet - But have button to add more lines
  687. Quicker calculations -- storing huge equations or cutting and past
  688. RE: I am repeating the same procedure and cpt codes
  689. Multiple row comparison to sum potentially multiple values.
  690. Conditional formatting based on format in a different cell
  691. Table question
  692. UDF Function
  693. adding numbers in a column with dates
  694. SUM cells in column based upon criteria in two others.
  695. Sort unique data from a colum
  696. Tricky Macro Question
  697. Averageif year=2000
  698. Using ISNA on more than one column within an If Function
  699. Add one
  700. Format date
  701. Total a column contingent upon the cell to the right being non-bla
  702. a if calculation help
  703. Good example of the use of Vlookup
  704. HOW DO I TURN MY UNDO REDO FUNCTIONS BACK ON IN MICROSOFT EXCEL
  705. concatenate within an excel formula
  706. How to paste data to alternating cells down a column?
  707. Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell)
  708. Need Help
  709. Need help. Conditional formatting problems
  710. Autosum returns zero balance - why?
  711. Countif Formula
  712. COUNTIF?
  713. offset formula
  714. SUMIF with criteria being a specific cell
  715. sum of mutiple entries on another workbook
  716. Formatting cells to show two dates in one cell
  717. Product Formula
  718. Printing Dates on One Sheet
  719. Auto calculating not working
  720. Forms--Vista--2007 Excel
  721. Separating data
  722. Error with Copy function
  723. formula for excel sheet.
  724. In Excel can sheet tabs be placed along a side margin?
  725. hello please help i really should have payed more attention in class
  726. Variable Pay-rate after 5pm
  727. extracting quarterly data and having it update daily
  728. Auto filter custom filter
  729. financial function default format
  730. change column to rows with a match
  731. Extracting Data with in Brackets [ ...... ]
  732. Two Calculations in one column
  733. Count Consecutive string of same number
  734. subtracting ranges
  735. Trouble adding timesheet formulas
  736. -/+ forumla
  737. Help converting a 10 digit number 2223334444 to 222-333-4444
  738. How do I Modify Julian calendar restriction of 1900
  739. HowCanIselectAtextBoxIf theExcelFileIs saved in (group) format?
  740. Vlookup
  741. excel formula
  742. Remove holidays from calculation
  743. once only pop up
  744. draw smaller boxes within designated cells for checkmarks
  745. excel 2003 allowed addition of cell color anywhere on the page?
  746. Which Function(s) should I use?
  747. Init Caps
  748. Remove Duplicate with 'Caveat'
  749. RE: Another Issue With A Function
  750. Re: Another Issue With A Function