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. Dynamic Table
  2. How do I lock the formatting of my worksheet but still add text?
  3. Hide sheets
  4. Still problems with calculation of time
  5. Excel 2007 Conditional Formatting only copies absolute
  6. Months in Excel Chart
  7. Countif w/semicolon separated values
  8. comparing data in different rows
  9. Calculating eligibility dates
  10. Summing across multiple worksheets
  11. Tabela Dinamica
  12. spreadsheet colum combination
  13. VBE "Help"
  14. Excel problem - sumif with multiple parameters
  15. Match Data on different lines
  16. Unwanted Array Formula
  17. Complicated Lookup
  18. Text does not carries Over
  19. vlookup MAYBE???
  20. excel
  21. Searcing foran Excel event fired.
  22. Autopopulate text from multiple tabs into list.
  23. LOOKUP FUNCTION HELP
  24. Counting repeated data in a column
  25. Adding multiple cell totals
  26. Simple cell formating question
  27. Easy way to stack column data?
  28. Multiple value lookups from a table to select & sum data from colu
  29. How do I change date yyyymmdd to a Excel-supported date format?
  30. Latest Result
  31. Re: problems with formating and concatonating time [hours]
  32. If formula problem
  33. formula ending with a letter
  34. Text detector
  35. need formula for finding opposite (trigo)
  36. INDIRECT formula
  37. Trying to work out the difference in 2 cells.
  38. sorting array formula
  39. Run formula automatically
  40. Protecting worksheet
  41. Multiple Criteria to Classify groups
  42. FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA
  43. Help with a bsic formula
  44. Help with blank cells when concatenating
  45. How to get result by using CountIF, if there are 3 conditions to b
  46. the value should not be more than 0.8
  47. Searching from a table
  48. How can i use lookup for data in reverse column ?
  49. Counting incidences of surname and date of birth and rearranging s
  50. iam not able to find CONTACT PERSON collum in my exel work sheet
  51. How I unprotect my workbook if I failed to remember my password
  52. count uniques anomaly
  53. COUNTIF: unique names and values accross several columns.
  54. Wrong count of time
  55. Updating Imported Data (Excell 2003)
  56. logic test with nested IF fuctions - help
  57. Mean separation by LSD value
  58. Possible getpivotdata with offset?
  59. Calculate and display year and month
  60. Konditional Formatting
  61. Associate values in worksheet??
  62. How do I use the WORKDAY() for a 6days working wk excluding holida
  63. Column to row
  64. Lookup where column data does not match
  65. Changing the headers on an excel worksheet from Numbers back to le
  66. IF and Betwwen - how to ?
  67. Import external data, data includes Excel function
  68. Filter latest date from multiple date entries
  69. Counting specific letters in multiple cells
  70. Calendar or date formulas
  71. Removing unwanted columns in a list
  72. yes / no formulas into 1/0
  73. Stop text carries over
  74. Protect columns with password
  75. Wrap Text Problem + a little VB :)
  76. not working for me<9c4479ba-790b-444e-936e-16a8ed613aa0@w8g2000prd.googlegroups.com>
  77. How to calculate avg from various rows
  78. How to calculate an average from various rows???
  79. Worksheet design: How to allocate costs to plants?
  80. Count rows after filter
  81. May be a long-shot, but.....
  82. #value! Error
  83. Data Validation lists update orginal cell with list update
  84. Restricting cell data amount
  85. drop info auto from sheet 1 to 2
  86. Sum of visible cells with multiple filters - Office 2007
  87. Simplify Formula
  88. Pivot table formula to pick most recent value.
  89. How would I attach or assign values to a trendline?
  90. Set fixed Decimal places with no rounding
  91. VLOOKUP selecting, not highlighting
  92. Copy from another sheet but spreading the data out down the col
  93. How can I activate spell check in a protected sheet
  94. rounding decimals to nearest quarter
  95. alphabetical on column c
  96. Updating data in one Worksheet and propagating it to others
  97. if value is between two numbers
  98. How do u sort many items out a spread sheet in excel
  99. Nested IF Function not working
  100. EQUIVALENT for this FORMULA , please
  101. Insert Copied Rows or Drag/Drop Formulas While Protected
  102. Pivot Tables & Conditional Formatting
  103. FINDING THE DATE 75 DAYS AFTER A SPECIFIED DATE
  104. Isolate text immediately preceding "("
  105. Sorting text and numbers from multiple tabs
  106. Comparing Lists
  107. Change Workbook Password
  108. How Do I DO IF with DATE
  109. split data into seperate worksheets by criteria
  110. Ungroup "+" on a protected sheet
  111. Counting specific letters in a cell
  112. Figuring and adding time in Excel
  113. Calculate a ratio of two numbers to the total
  114. Automatically expanding outline section if values are present
  115. If a date range contains a leap year (date)
  116. Nested if/then or array???
  117. convert 80521 to 05/21/08
  118. Time sheet calculation of shift differntial
  119. How to find the highest name in an alphabetic list?
  120. moving objects with cell
  121. Linking cell ranges between rows and columns
  122. YTD average cust calulation
  123. copying from pdf into excel ?
  124. Understanding formula
  125. Please Help Qtr Mtch
  126. RE: Formula
  127. RE: Formula
  128. finding and replacing
  129. Moving The Decimal Point Of Existing Entries
  130. taking conditions from one spreadsheet to another
  131. work book open _ event
  132. Advice on a couple of things if possible.
  133. Copy Left Word
  134. sumbycolor formula
  135. Take first word out of cell and put it in a new cell
  136. REALLY easy question
  137. count the occurance of a particular month in a column of dates
  138. Using Tabs within the allow users to edit range while sheet protec
  139. Countif function
  140. How to convert data from Landscape to vertical
  141. If Then forumal
  142. Complicated comparison and highlighting question
  143. Summ figures that are not struck-through
  144. Charts not updating
  145. how do i substitute filename in a formula
  146. Help with Formulas
  147. Dragging Down a Formula
  148. How do I round a number to the nearest .49 in a cell that has a fo
  149. Help with if statement (more than 7)
  150. Diference between two hours in Minutes
  151. Formula to evaluate dates
  152. formula for changing a percentage
  153. Sum = to greater than, change it to 1
  154. Vlookup with Multiple like values in the reference column
  155. string lookup combined with SUM
  156. Cell Formats
  157. Combining information from rows
  158. sum of three cells
  159. IF and SUMIF
  160. excel data in list N1, N7, N13 etc want to transfer to A1, A2, A3
  161. Calculating Average
  162. sumif or vlookup help
  163. OLD PROBLEM without SOLUTION
  164. check certain cells for data before saving file
  165. Setting a sale price and rounding up
  166. how do i sort data record on two rows?
  167. count if using columns not range of cells
  168. extract number from alphanumric
  169. Copy/Past/Transpose Formulas
  170. I am having some trouble with a long formula and multiple spreadsh
  171. Find a value Using a lookup table multiple columns and rows
  172. count if, but not if
  173. calculate the the diffrence between 2 Dates and time
  174. How can I make BINGO boards using EXCEL?
  175. SUMPRODUCT containing txt string search
  176. where in excel 2007 is old file properties menu
  177. Im doing something wrong in Visual basic for sure
  178. Hyperlinks and spaces
  179. Formula
  180. =COUNTIFS(M3:M17,"=MAN",P3:P17,"=2000")+(COUNTIFS(M3:M17,"=LHR",P
  181. Searching specific record using VLOOKUP function.
  182. Comments, is there a way to export them?
  183. Counta function
  184. pull down list and single value allowed
  185. Worksheet Formula Returning Sum of a Series
  186. simple timesheet
  187. Dual income calculator help
  188. Compiling to one sheet
  189. Compiling to one sheet
  190. Is there an excel funtion to calculate Daylight Savings Time?
  191. combining worksheets
  192. SUMPRODUCT/COUNTIF
  193. IF STATEMENTS COMBINED WITH VLOOKUPS
  194. Adding a Number and Formula Text and Evaluating
  195. Countif with multiple criteria
  196. Create user id fm LName, FName
  197. How do I pull data for consecutive months in an Excel spreadsheet
  198. SUM Product formula help needed
  199. Filtering in Excel 2007
  200. Calculating of time
  201. Vlookup Function with multiple worksheets
  202. Countif versus SumProduct
  203. How to determine the max. value?
  204. How to determine the max. value?
  205. Sum when cell's value in Named List
  206. Excel - adding a picture that will pop up when I wand over it?
  207. Need help with a formula
  208. vlookup returns #n/a
  209. Advancing lookups and comparisons
  210. Excel sort ( exclude letters include hyphens)?
  211. MSOffice 2007 - Excel - Subtotal Function
  212. Need to Count the number of times a value occurs within a dt range
  213. how can i determine number of weeks between 2 dates
  214. Help with Functions & formulas
  215. On opening a worksheet move focus to a cell based on date
  216. Label Filter in Pivot Tab;e
  217. Setting up spreadsheet to calculate time
  218. excel 2003 drop-down box color changes how
  219. return cell within date range
  220. get a range corresponding to a particular col header
  221. 1st sheet being displayed
  222. Elapsed Time
  223. how do I attach a scanned pdf file to a cell so that I can bring
  224. Pivot tables
  225. Sort function
  226. pivot tables
  227. Formulas new in excel 2007 not compatible with 97-03
  228. Count a specific month in a column
  229. How to convert an address file from Word into Excel?
  230. Using v-lookup with multiple identifiers
  231. Can't find certain date in search
  232. Auto update worksheets
  233. Hyperlink function in an If function
  234. How get user input that can then be used in formula, as criteria?
  235. Search formula referencing range of keywords
  236. Dates-Conversion
  237. Use a cell to name a file to be opened.
  238. Macro to Print
  239. Hyperlink from Excel 2007 to a specific slide in PowerPoint
  240. Why is the sum formula is not adding correctly?
  241. Page Breaks in 2007
  242. FIND and dates
  243. Finding text
  244. Time Formula
  245. Excel 2003 Graphs
  246. Complex IF formula
  247. Hiding uncalculated values
  248. EXCEL 2003 Export Issue
  249. sorting datasets on two rows
  250. Vlookup / sumif (maybe....) query....
  251. Sorting
  252. Filtering based on wild card values
  253. Date formula resulting in Year, Months & days
  254. How do I set up repeating data in Excel
  255. Collapsing filtered macro
  256. IF Statements
  257. How to number excel cells automatically
  258. Conditional Formatting - workdays only
  259. Can't add a column to a specific file
  260. Date in Text String
  261. How to look up a value in a list and return multiple correspondingvalues
  262. Macro Help
  263. If, then
  264. Adding more than one maximum
  265. Count occurances of a name over previous 12 months
  266. Last Row used in calculation
  267. Lock formulas from being edited
  268. Is there a showif formula?
  269. Filter and Delete
  270. RE: Date and range
  271. Re: Date and range
  272. making excel to notifying you about expire dates on your sheet
  273. Format problem in displayed userform
  274. Calculating Max & Min in a negative numbes
  275. How to change cell value if cell contain specified word
  276. VLOOKUP From Multiple Data Sheets
  277. make a single cell always equal zero
  278. Month formula
  279. Countif in an ARRAY.
  280. excel 2003 - revising a formula to make it more accurate
  281. Compare 400 cells to one
  282. Go to cell - Query
  283. Data Validation Formulas
  284. More of IF(AND
  285. Break up a date range automatic
  286. pick from table based on row and column header
  287. Very Basic SORT question
  288. I want to get a furmula for get a percentage
  289. How do you I get the antilogarithm of a number
  290. Mathmatical functions in Excel
  291. Zero if zero yet blank if blank?
  292. Excel formula
  293. drop-down list in a workbook while the list's data's on another w/
  294. How can I recover the previous data after save change
  295. Allocate from the sum
  296. Functions
  297. Need help with DIV/0 error in an AVERAGE array formula
  298. VLOOKUP using a number as text to "lookup" a match formatted in a
  299. Vlookup return a ROW of data
  300. About Fuctions
  301. Loss of Some Functions in Excel 2003 with Vista
  302. Vlookup
  303. list data to show up on multiple sheets
  304. Counting characters in multiple rows when rows meet specific criteria
  305. Flipping a worksheets contents?
  306. MACRS depreciation formula
  307. Incorrect INDIRECT function
  308. Initiating a Macro
  309. VBE in Excel 2007
  310. I need your help guys please
  311. statistical function with range referencs
  312. How to use formulae or formula in this case?
  313. How to use formulae or formula in this case?
  314. Formula for figuring percentages of 2 numbers
  315. header/footer
  316. Template
  317. VLOOKUP Macro?
  318. multiply Hrs:Mins by £Hourly Pay
  319. RE: VLOOKUP Macro?
  320. RE: multiply Hrs:Mins by £Hourly Pay
  321. excel seach
  322. how to set data validation on cell that display a date in Excel?
  323. delete error/blank cells
  324. Limited value based on percentage of total
  325. Moving data in Excel 2003 via VBA
  326. SUMPRODUCT use of --() syntax
  327. Adding cels in a row that correspond to the heading of a column
  328. how to build DDE link with text from another cell
  329. Removing "Sum of" from pivot tables
  330. Filtering an Excel Report
  331. Vlookup, can this be done?
  332. Data Validation
  333. merging cells and not losing data
  334. Count help please
  335. What percentage of heart rate
  336. need to work across two sheets in excel 2003
  337. I want to set weekly off as Thursday instead of Saturday & Sunday
  338. Dates linked in Excel files
  339. Worksheet Tab Name from Cell C4
  340. Using dialog box
  341. Calculating total number of days
  342. Shared Workbook - Using data for those that have the book open
  343. Question regarding copying items to another worksheet.
  344. Multiple If(AND
  345. Formula in combination with pivot table
  346. Combo box in Excel?
  347. vlookup naming a range in excel 07
  348. Formula
  349. Macro, Scenario, Filtering - What should I do?
  350. Combination Sum
  351. Sumif across multiple ranges
  352. display two rows of worksheets
  353. Conditional Formatting Question
  354. Formula to change cell color
  355. copying using a macro
  356. Excell formula.
  357. Text file to Excel
  358. find time and text
  359. Userform question
  360. Duplicate data in multiple spreadsheets
  361. Reg. Change of font color in a cell
  362. sumif with two criteria on on difference worksheets
  363. How do I group numbers in a list based on contiguous/missing?
  364. Help on formula
  365. Old DSUM formula not working in Excel 2007
  366. Extracting data
  367. Search function
  368. IF function contingent upon cell not being blank
  369. Changing text color of certain "word" in cell
  370. How do I convert a table into a list in excel?
  371. Accrual of hours
  372. Excel 2003 Sheet Ptotection with Overrides to sort
  373. Extracting Text String that matches with list
  374. date formula
  375. Using NAMES in SUMPRODUCT giving error
  376. MIN will not find lowest of calculated values How?
  377. auto sum column containing words and numbers
  378. Creating A Form
  379. Countif using multiple references
  380. automatically change worksheet tab name
  381. Is this right please.
  382. Chain IF formula help
  383. Conditional formatting: same color, alternate background on same r
  384. round numbers in the millions to numbers in the thousands
  385. Extracting certain characters from a long string
  386. Need to insert blank rows
  387. Combining multiple data records
  388. COUNTIF or SUMPRODUCT
  389. Excel 2007 - Remove Name Range via Name Manager
  390. Storing Macro Results
  391. Sum column A:? where ? is a number in a cell somewhere
  392. How do I change the cursor or outline color in excel 2007?
  393. Query returned more data than will fit on a worksheet
  394. "Why make 100 charts when one will do?"
  395. I want horizontal and vertical lines
  396. Conditional Format--2 conditions need to be true
  397. Excel Paste Special Function
  398. Calculating Time
  399. Combo Box Imbedded in Cell?
  400. delete blank rows with functions
  401. Cell colour change.
  402. Pivot tables
  403. Schedule Changes based on dates
  404. Drop-down list
  405. Extracting data
  406. Conditional Sum problem
  407. Multiple IF's Using Formulas from Other Cells
  408. I need speed calculate when I filter rows.
  409. multiplication of two array in a particular way
  410. When amortising a loan based using an IRR rate, the total interestpaid fall short.
  411. IF Statements - Novice
  412. raversing an array value
  413. RE: Inverse prediction in regression
  414. excel worksheet functions-finding symbols
  415. Counting multiple cells containing text.
  416. problem with auto update of date and time
  417. Function '=Frequency' Help!
  418. reference other worksheets via variable names
  419. How can i do a frequency distribution by machine automatically
  420. how do you store real time in excel when making an entry
  421. subtracting with blank rows inbetween?
  422. SYMBOL ¦please help how do i do this symbol without copy/pasting i
  423. How do i get the ¦ symbol using the symbol?
  424. Data validation - restricting data
  425. Return unique number, skip blanks
  426. Adding up minutes
  427. Logical test IF a decimal was typed in a cell
  428. Shortcut keys in Excel 2007
  429. SUM(IF()) array formula in a separate workbook and multiple worksh
  430. If(And Multiple Conditions
  431. Cell Color Change
  432. Adding a date and name to auto update within one cell
  433. Hour Count
  434. Searching Latest Records
  435. Merging Two Worksheets
  436. Conditional Formatting with fonts
  437. Insert Rows NO FORMAT
  438. Calculate vacation days remaining from date of employment
  439. Can I create an "IF" function using cell color as a logical test?
  440. How do I create a hyperlink for individual FedEx tracking numbers.
  441. Printing "Freeze Panes"
  442. @if question
  443. How do I VLookup visible cells only?
  444. Add a Row Every Fourth Row
  445. Validation with External Data Names
  446. Strip leading zeros
  447. Find max value in one column based on another column
  448. VLOOKUP - How to Sum Multiple Cells
  449. Simple Math
  450. fill data
  451. Couting based on color and Filter
  452. Difference between dates as # of months, # of days, # of years
  453. weekdays not using NETWORKDAYS
  454. delete a duplicate in column while leaving other duplicates
  455. deleting condition after the first duplicate
  456. MS Excel 2003 - Worksheets on viewable
  457. Formula help with averages and if then statements
  458. Finding center of a distribution
  459. Shortcut to split data from one column into three? HELP!
  460. vlookup help plz
  461. Index or match?
  462. Formula based on Date
  463. Hiii.... GET PAID BY CLICKING....
  464. Question on sorting text strings
  465. Excel 2003 formula
  466. Re: how to build a "theorem prover" in Excel
  467. Converting Text to Dates
  468. Circulair error message
  469. calculating cells
  470. Countif and Date Comparison
  471. Excel Formula Query
  472. counting >=100%
  473. How do I restrict what is entered in the next cell?
  474. underscore in functions
  475. Assistance please
  476. External Reference with INDIRECT, INDEX/MATCH
  477. IF Statements
  478. curves
  479. INT Function Not Doing what I need
  480. Conditional formating based on other cells
  481. % formula
  482. counting non blank cells for "sum(if" formula
  483. Conditional Formatting Using "OR"
  484. Re: Specifing Cells to Sum on Condition
  485. Re: Specifing Cells to Sum on Condition
  486. Custom type chart
  487. Rankif Formula
  488. disable Insert Worksheet
  489. search and paste information - multiple pages
  490. Looking up values with multiple criteria
  491. New to Excel really need help
  492. Nesting Formulas
  493. Concatenate a Formula
  494. Sumproduct on multiple sheets...please help???
  495. question using "INDEX" and "IF" functions
  496. Formula help requested
  497. Re: Eligible Vacation Days Calculator
  498. Re: Eligible Vacation Days Calculator
  499. Excel-tab, spacebar etc seemed to be locked-can't repeat key stro
  500. Dynamic Updates on Compiled Worksheet
  501. Error "invalid data source reference" for pivot table
  502. Simplfying DIV/0 Error...Can you?
  503. After Filter
  504. mixed text and formula results
  505. help with lookup reference please
  506. Match text
  507. Sumif condition
  508. large & lookup function
  509. If and then statements.
  510. request formula
  511. Vlookup, replace true text result with "X"
  512. copy and paste
  513. if statement - help needed
  514. How do I calculate a weighted median?
  515. Refresh linked data
  516. Excel 2003 - function to select a value
  517. How can cell entries be based on word entries in another cell ?
  518. Reverse Concantenate?
  519. Text Extractions
  520. Protecting specific columns within a worksheet
  521. How to compare two columns of data to make sure they match
  522. help with the function
  523. Username in Excel - Paste Value?
  524. SORT BY: left to right
  525. SUMIF function with conditions
  526. Excel troubles
  527. Select Active Cells
  528. Search and translate
  529. How to add continuous 5 or 10 rows by giving number of rows to ad
  530. Carrying formulas over to new cell when old cell is deleted: possi
  531. How do I rename an Excel worksheet when the feature is grap out?
  532. Concatenation in Excel
  533. SumIf function, How set range between dates and across worksheets?
  534. position of second occurrance
  535. currency and time calculation
  536. Update database from ODBC query (or another method)
  537. overtime during weekdays and weekend ( more specified)
  538. Re: Mapped Disk Full Error Message
  539. Time attendance calculation problem
  540. Translate Formulas as Values
  541. Average Monthly Growth rate
  542. Need help reversing a formula...
  543. Array Formula Help
  544. External Links with the same filename?
  545. = one total two columns different text
  546. Can I use solver to estimate several values by changing several c.
  547. formula increment
  548. Counting Multiple columns using single criteria
  549. Using VBA to make a user input a note when making changes to a cel
  550. Rounding up @ 3 instead of 5
  551. working with dates in excel
  552. deconcatenate
  553. Vlookup Maybe??
  554. Want to unlink calculations
  555. vlook up (average)
  556. Lookup
  557. enable Right-click menu
  558. Sum if match any six numbers
  559. I'm trying to create a thematic map in Excel
  560. Sort function won't work with copied sum totals
  561. Protect worksheet - losing values
  562. Sorting Existing Totals Into A New & Separate Column
  563. Filter data in a PivotTable report in value area
  564. Counting in a spreadsheet
  565. Delete duplicate data in a single cell
  566. SUM ONLY NUMBERS IN A RANGE
  567. One for the Master Minds out there
  568. Aging Formula Help
  569. concatenate numerics and text
  570. Formula result based on Multiple IFs
  571. Dropdown list
  572. auto update of date and time whenever changes are made to a xcel s
  573. I can't get a column to automatically add up using the prescribed
  574. Filtered table using Countif
  575. OLAP Pivot Function
  576. search a string as substring and give adjacent values
  577. Check for duplicates in 2 columns
  578. VLOOKUP
  579. Count with date range
  580. calculate weighted average effective interest rate
  581. Lookup info - Really need help please
  582. SUMIF with multiple conditions
  583. filtering time
  584. Need more help with a formula
  585. Conditional If Statements
  586. Is there formula to identify the matching data in Column B?
  587. Excel formula help please
  588. Worksheet names
  589. Formula result does not match displayed result
  590. Need help with formulas
  591. Converting cells to numbers
  592. What is VBA and where can I find more info on it?
  593. Counting Ages
  594. Subtract hours from a time and get the correct time
  595. if with or condition
  596. price ticket template
  597. The function in French version DECALER is not working
  598. How to Compare between cells and choose smallest value
  599. Vlookup question
  600. Counting Items
  601. Custom Filtering - Limitations of the "Contains" option
  602. Conditional formating, match, lookups
  603. Copying to next unused row
  604. To get an average of a column of numbers not zero/blank cells
  605. What function to calculate interest on savings
  606. Password
  607. Resource Scheduling/loading
  608. auto update of date and time whenever changes are made to a xcel s
  609. Help with XDATE function add-in
  610. Statistics problem
  611. Pivot table range selection changes when opening 2003 xls in Excel2007
  612. Count Text in Columns
  613. Lookup info in one Column and then returning info in other columns
  614. Using ISNA function, but replace the blank cell with text
  615. Percentage of filled in boxes in a column formula
  616. Creating a record in one worksheet from the data in another.
  617. Re: Vlookup
  618. Re: Vlookup
  619. auto subtract
  620. Nested IF
  621. Good article on Microsoft
  622. Formula for Value
  623. VLOOKUP returns #REF using Query as source
  624. Print data filled rows only
  625. Correct syntax for IF, Then in a macro
  626. Critical requirement.
  627. How do I make DATE non-volatile?
  628. Re: Find items in one list but not in another
  629. Pivot Table field macro
  630. Excel Lookup?
  631. lotto numbers
  632. Value divided by time
  633. Vlookup , Referencing a cell to refence table array
  634. what formula for keeping balance of excess hours/minutes?
  635. Command to update data from one sheet to another
  636. Have a chart line completely disappear for a Series...
  637. calculate from time started and finished to get total time used
  638. Need help with whichever is greater formula
  639. Bedroom Requirement
  640. Adding data in columns based on criteria in more than one column..
  641. Calculate to the third decimal and round up or down in cell
  642. Pulling data from a cell in between /
  643. Countif fields with **
  644. How do I scroll in Excell 2007 with my mouse wheel?
  645. Eligibility Dates
  646. populating new cell with first populated cell to the left
  647. How do I protect Excel Workbook Structure except adding new sheets
  648. Re: False Statement won't show
  649. running totals
  650. Multiple Column Lookup in Excel 2003
  651. SumIf Formula
  652. if cell equals "a" then another cell would calculate percentage
  653. Productivity Log
  654. How can one set a value TO another cell?
  655. How do I get the IF function to work on more than one criterion?
  656. Only Print Pgs W/Info?
  657. Re: False Statement won't show
  658. RE: False Statement won't show
  659. Konsolidating tabels on diffrent sheets in one sheets
  660. Converting Dates to Week Ending time period
  661. Is there a way to do a "lookup" and change the orientation of the
  662. Formulas are displayed in Excel instead of the data
  663. Adding a counting function within SumProduct
  664. Sorting a protected worksheet
  665. Data Validation in Excel 2002
  666. How can I use a formula to calculate a running sub-total in excel
  667. Sorting Cells
  668. Auto filter question
  669. Mastersheet update problem...
  670. Protect After Saved
  671. REQ: Can I scan into Excel directly FROM Excel?
  672. ALIGNING TWO ARRAYS OF DATA VALUE
  673. Finding a minimum value in a cell that is constantly changing.
  674. I give up, trying to sum with non numeric cells.
  675. How do I add numbers to time?
  676. Find a Match in Multiple Places & Return Multiple Values
  677. Formula won't show sum
  678. Selecting Rows that meet criteria
  679. two-way variable table keeps repeating same value
  680. monthly spreadsheet- can not add date to inserted row
  681. How do I sort rows keeping columns together?
  682. how to calculate games odds
  683. Working with dates in excel
  684. Formula to calculate 4 possible answers in one cell
  685. I need a formula
  686. Percentage Help Please
  687. Formulas scrambled when sorting
  688. Not able to select Calculated Fields for Pivot Tables
  689. Updates via several stages
  690. Sum of cells based on entry of adjacent cell
  691. combine data into third sheet
  692. Count a range that matches the heading
  693. cell needs to show tab text
  694. formula involving buckets
  695. Excel: Cell Naming Bulk Delete
  696. Concatenate cells with text and numbers/decimals
  697. Yet another Average Function with mutl. Columns
  698. Sum Prodcut issue from .txt import
  699. Calculating total when multiplier varies by another criteria
  700. Copying data from 2 cells into 1
  701. How do I return a unique count where conditions exist?
  702. Copying Functions between Cells
  703. how to show whether 3 cells within a row match 3 cells in another
  704. Summing mulitple line items within date ranges
  705. Fund return v income
  706. Need help pulling percentages from all work pages
  707. TIMESHEET
  708. Copying DSUM formulas with absolute references
  709. Using Sub-Total function in locked sheet?
  710. HELP ON THREED
  711. VLOOKUP -- Table Array Problem
  712. Foot mark aka single quote mark?
  713. Average cells with #DIV/0!
  714. Conditional formatting - coloured text
  715. Print Column Heads WITHOUT Excel Column Lables
  716. I NEED SOME SERIOUS HELP =)
  717. Macro Help - Fairly Advanced.
  718. Tax Calculation
  719. need an aswer- URGENT!
  720. calculating revenue over months
  721. A formula to ponder on - I burnt myself out !
  722. Date Count
  723. Button with Hyperlink
  724. Format Prefix
  725. HOW TO RETRIVED THE PREVIOUSLY SAVED VERSION?
  726. SUMPRODUCT function for two arrays. Array 1 contains text
  727. Spreadsheet for bowling games?
  728. COUNT(IF((,,,)) function
  729. Special Print Instructions
  730. mutiple criterias formula
  731. I want to add more that 30 noncontiguous cells in Excel
  732. Shorten the formula
  733. IF formula string
  734. Sumif Function
  735. #N/A - "Value not available"
  736. spreadsheet function
  737. VLOOKUP, MATCH, INDEX HELP!
  738. Match then Vlookup
  739. Automatically Duplicate Rows based on Volume.
  740. How do I create a data source using pictures?
  741. If Function on calendar, expense report.
  742. how do I save formulas in conditional formatting without retyping
  743. Formula Question SUMIF
  744. SUMIF Function
  745. Formulas--running balance
  746. Declining balance
  747. Find the three nearest dates
  748. Replace single 0 without affecting other cells
  749. Trying to get contents of cell linked through IF function.
  750. Has @DAYS 360 function calculated differently between qtr and mon