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. How to sum cells based on conditions
  2. Custom Number Format
  3. EXCEL Pivot Table
  4. Worksheet is not calculating
  5. Drop Down List
  6. Sumif based on value in cell
  7. Automatically insert a line
  8. conditional formatting based on different cells with more conditio
  9. What function do I use
  10. sum table
  11. Conditional Function
  12. MROUND
  13. Look Ups and Matches, Sorry if current thread exists- Clueless
  14. List Box and IF function
  15. Duplicate data entries
  16. Vlookup Different tabs based on Dates
  17. simlple question
  18. Lookup table for rates?
  19. concatenate won't work
  20. minimum value in a column, which row no?
  21. Conditional Formatting Using Min/Max
  22. Using V or H lookup
  23. "Validation" question
  24. Converting time to number, i.e. 2:32 to 2.32
  25. Countifs
  26. Concatenate Dates
  27. Sumif query
  28. Automatically add and subtract
  29. Formula behind functions
  30. Comparing 3 Columns
  31. combobox listfillrange network
  32. Re: Formula for selecting a Leap Year.
  33. Automatic add & subtract
  34. One text for particular period
  35. average with N/A
  36. Formula to count duplicates
  37. Pull cell contents from one wksh to another if condition is met
  38. Re: Formula for selecting a Leap Year.
  39. Conditional functions on portions of cell data
  40. Logging information
  41. Keep Leading Zeros in Concatenation
  42. Formula for selecting a Leap Year.
  43. Track Changes- Working Partially
  44. LOOKUP returning wrong values
  45. All my textbox disappear..
  46. IF and AND statement
  47. close match
  48. unique entry sum
  49. How do I convert 1000 to One Thousand (i.e numberic to words)?
  50. Sum if unique and another criteria
  51. insert and copy
  52. disable brian baulsom's worksheet change based on cell value.
  53. how do i open an ods file in excel?
  54. Re: Forumals not showing correct result (unless edit and enter)
  55. Forumals not showing correct result (unless edit and enter)
  56. Excel formula question...
  57. Self Population of Date Function
  58. count number of dates in a row of cel before or after a variable d
  59. VLOOKUP displaying "NO ANSWER" instead of "0"
  60. Can I use cell data for a web search & bring back in the results?
  61. vlookup???
  62. Medians of data
  63. conditional formula with lots of conditions
  64. Can't sort with Excel 2007
  65. conditional list
  66. search data and display colunm headers
  67. Vlookup and column reference problems
  68. TURN OFF AUTO-HIGHLITE
  69. change date format without retyping dates
  70. symbals
  71. Close Match
  72. Copying Cells to new row on different worksheet
  73. Link to another workbook path issue
  74. extract items from filtered list
  75. comparison function
  76. vlookup removing characters
  77. circular reference - iteration
  78. Need help with a function for a golf match spreadsheet
  79. RE: Random Sample with multiple data points
  80. How do I make a box with a check mark when clicked?
  81. INDEX MIN function?
  82. Math Functions Not Working Properly
  83. Countifs
  84. Random Sample with multiple data points
  85. Return two random lines
  86. Re: Vlookup Using a Reference as a Table Array
  87. Vlookup Using a Reference as a Table Array
  88. How can I remove the header and footer on the excel 2007 sheet?.
  89. Drop down menus
  90. Excel Formula
  91. Excel: graduating fees based on account value
  92. Viewing of protected locked or unlocked cells
  93. Count if unique
  94. RE: Need a function to match up jobs
  95. Vlookup questions
  96. how do i filter records with greater number across rows
  97. Need a function to match up jobs
  98. IF Function and pulling data across
  99. Validation I Hope
  100. Count With Multiple Criteria, please help!!
  101. Excel Conditional Formatting (Compare Vals in 2 Columns)
  102. add another subtotal row to an expense column?
  103. Copying Conditional Formatting rule
  104. Unprotect 2003 excel files when opening in Excel 2007
  105. Unprotect a worksheet
  106. Another IF statement question
  107. Return filtered values into report worksheet based on filtered valueon the data worksheet
  108. Step up or Down payments
  109. FORMAT CELL TO MILLIMETERS
  110. perpetual inventory - stock level - math flow??
  111. Auto Correct Option
  112. Searching String for phrases/multiple text strings
  113. Macros
  114. Using VLOOKUP to locate an answer in one of multiple columns
  115. RE: Count If Column A = x and Column B = y
  116. Count If Column A = x and Column B = y
  117. Concatenate N cells (where N is a worksheet value)
  118. EXCEL:HOW DO I CHANGE COLOR IN CELL BY TYPING IN ANOTHER WORD?
  119. Refer to Another Spreadsheet in a Formula
  120. Excel 2007 overwriting Hidden Rows
  121. Mulitple value lookup
  122. Automatic Macros
  123. PPMT Function
  124. how do i rearrange columns in a work sheet
  125. DCOUNT Help
  126. Hyperlink
  127. Watch Window
  128. Download free latest certification Guides & Dumps
  129. how to add date and time to a single cell in MS Excel 2007
  130. Hide Rows If Condition True
  131. To choose the best field in EXCEL
  132. Transpose Issue from Columns to Rows...
  133. Accumulated percentage calculation
  134. Copying a formula
  135. formulas do not work
  136. To extract content fo cells from many workbokks which are identica
  137. Calculation based on certain criteria
  138. Calculation of incentive
  139. Problem with >= in function
  140. Help with worksheet event
  141. Apply Conditional Formatting to other rows
  142. Value function
  143. Estimates with multiple look ups
  144. A UNIQUE FORMULA
  145. Re: 9 Assessments but want the students 7 best results
  146. 9 Assessments but want the students 7 best results
  147. IF FUnctions that produce TEXT results
  148. Conditional formatting multiple cells from one cell to another
  149. Excel formula question
  150. EXCEL 2007 - INSERT NEW WORKSHEET
  151. How to make SUMPRODUCT work over range that includes text?
  152. RE: On error
  153. RE: On error
  154. On error
  155. Naming Cells Using Relative Cell References
  156. I want to undo 'move or copy worksheet'
  157. loan to value function?
  158. Capturing Top 5 Performers
  159. I want to tally my sheet
  160. Sorting Linked Data Between Sheets
  161. how we find specific word from string in excel and compaire it.
  162. Running Total
  163. Worksheets
  164. Help with data total
  165. sort source data sheet while destination shows same data
  166. IF function using two worksheets and various data
  167. Constant in Excel Formula
  168. INDIRECT(ADDRESS) inside a VLOOKUP
  169. need sumproduct to return text values...
  170. Length of Service and Vacation Hours Accrued
  171. Grouping IF/AND/OR in a single formula
  172. Breaking down a cell to create a function
  173. IF cell contains part of text
  174. Format for a cell with a formula in it but I don't want the 0 to c
  175. Reference previous worksheet within VLOOKUP
  176. Re: Vlookup Cell Format
  177. Vlookup Cell Format
  178. PASTE DOESNT WORK
  179. RE: What is the function to randomly select a cell, like for lottery?
  180. new macro to format worksheet
  181. RE: What is the function to randomly select a cell, like for lottery?
  182. SumIf or SumIfs or something else?
  183. Lottery function - how to randomly select cells
  184. What is the function to randomly select a cell, like for lottery?
  185. Concatenating two variable fields into a static length text field
  186. use Hlookup to look up two or more values
  187. roundup with index,match,subtract,divide and add formula
  188. If Statement Question
  189. IF Formulas
  190. Apply Global Formula
  191. RE: Multi column sumproduct
  192. repeating formula on calendar
  193. Multi column sumproduct
  194. Sumif linked to different workbook
  195. FIND IF A CELL CONTAINS TEXT
  196. entering a number and having a word appear in excel
  197. RE: how do I substitute precedants in long excel formulas
  198. how do I substitute precedants in long excel formulas
  199. Macro
  200. normalize score
  201. vlookup (indirect, or sumproduct) using three tabs
  202. Data Validation
  203. matching Data
  204. Copying formulas in range and pasting in a selection
  205. Pickup the content of Cells ( in formula)
  206. RE: How to convert PDF tables into Excel??
  207. display first or second match instead of #REF in INDEX ROW formula
  208. Select data from two worksheets to the left
  209. Use Like in Vlookup
  210. Slicing Data (Alternative to SUMIFS)
  211. Sumproduct Question
  212. Formula Help
  213. sum cells with both alpha and values but...
  214. SUMIFS and dates
  215. index and match, then subtract, divide and add for my final answer
  216. Re: COUNTING
  217. "IF" function returns function instead of result
  218. Re: COUNTING
  219. RE: COUNTING
  220. RE: COUNTING
  221. Sorting Unorganized Data Into Different Spreadsheets
  222. IF function returns function statement rather than result
  223. COUNTING
  224. RE: How to convert PDF tables into Excel??
  225. Finding an item in a list & returning a specific value
  226. Help with VLOOKUP & MATCH formula
  227. Format single character
  228. Re: Alternative to using 10 V-lookup formulas
  229. RE: Current Cell location
  230. Current Cell location
  231. Alternative to using 10 V-lookup formulas
  232. Text into Columns
  233. Lookup Dynamic Value in a Table
  234. Method for creating formulas to reference different worksheets?
  235. How do I recalculate cell only if reference cell value changes?
  236. Percentage over a date range
  237. data associated with latest date
  238. data in 2nd column associated with =MAX(H1:H100) from another colu
  239. CANT INSERT CELLS, ONLY ROWS & COLUMNS
  240. how to move contents in column up one cell
  241. RE: How to count/tally entries?
  242. How to count/tally entries?
  243. Can't save Excel spreadsheets
  244. Today() function
  245. Text to rows
  246. RE: How do I complete this nested if formula
  247. How do I complete this nested if formula
  248. Lookup Function
  249. Calculate the number of hours in a date/time cell
  250. Is there a Conditional Sum Wizard in Office 07? If so Where
  251. Re: Using Indirect with an Index Match Function
  252. Time/priority problem
  253. RE: Using Indirect with an Index Match Function
  254. Errors encountered when using If & Vlookup formulas
  255. How to equal a cell in another worksheet incl fill colour
  256. Taking Average ignoring #DIV/0! in the range...
  257. EDATE Function disappears intermittently
  258. Quarters
  259. solver an uxexpected internal error ocurred, or available memory
  260. filtering or selecting data baseed on time of day
  261. displaying changes
  262. How does one use a formula to bring over the formatting as well
  263. Deleting rows or columns
  264. SUMIF formula with non contiguous cells
  265. how do I look for cells showing dates less than a certain date?
  266. Calculate Interest Rate
  267. EXCEL PASTE DOES NOT CHANGE DATA - PASTE DOESN'T WORK!
  268. Display a number in feet inches and fractions of and inch
  269. combining data from multiple workbooks
  270. Adding a pre-fix to each item in a cell
  271. Stuck on Formulas
  272. Duplicate check
  273. macro writing
  274. Split text file into Excel sheet and separate the final results intoa new sheet
  275. Return column header as solution to lookup
  276. Vlookup with multiple workbooks
  277. Cell format for an array formula containing text
  278. Re: Copy worksheet from one workbook to a master workbook
  279. Copy worksheet from one workbook to a master workbook
  280. External reference to a Column
  281. Macro to apply parsing rules for strings and list the substrings
  282. mobiles
  283. electronics
  284. world wide celebs
  285. music maestro
  286. voip
  287. Help Calculating Partial Months between 2 dates.
  288. Confirmation Security
  289. Vlookup
  290. Calculate Date
  291. Pearsons
  292. Data Validation using a table
  293. Text to Number
  294. RE: How do I only send 1 worksheet of a file in an e-mail?
  295. How do I only send 1 worksheet of a file in an e-mail?
  296. IF Statements
  297. I cannot use DIAS.LAB in my Excel (Spanish)
  298. IF(AND(OR function returns #VALUE! error
  299. Headings of columns now have numbers, need to change them to lette
  300. Pivot Table - Old remaining values for rows
  301. count formula question
  302. Help Calculating Time
  303. Date Range
  304. Flatten password file
  305. Re: Time Calculations
  306. style sheets vs cell formatting
  307. How do I ADD characters to the data for a group of cells?
  308. Time Calculations
  309. Adding values in first "X" number of rows dynamically
  310. Highest Values Comparison
  311. mean of range of dates
  312. Lookup Problem with Index and Match
  313. Vlookup Error
  314. HOW TO I GET LOOKUP TO USE THE SAME RANGE EVERYTIME
  315. Multiple results of Unique Values
  316. SUM depending on date
  317. Excel virus?
  318. How do I bracket text in cells by formatting a whole column?
  319. Check register running balance to another worksheet
  320. how do I use a cell from one worksheet in the equation of another
  321. Numbers of repeats of a string
  322. External excel file for pulldown list source
  323. Sum cells that have both alpha and numbers
  324. excel function help
  325. Increase Values by Percentage
  326. Re: Subtracting Military Time
  327. Highlighting the entire row with conditional formatting
  328. Need Function Help
  329. Subtracting Military Time
  330. Symbols
  331. RE: I need help desperately !! I need a formula that will allow me to
  332. Percntages
  333. Advanced Filter
  334. Displaying "0" Values
  335. Can't Prevent Recalculation
  336. how do I create a nonadjacent series for autofill to go by?
  337. Cell not available when inputting formula
  338. Convert numbers to words
  339. RE: Difference between 2 dates&time(format 0000), and excludes weekend
  340. Re: Concatenate unique values among duplicates
  341. Difference between 2 dates&time(format 0000), and excludes weekend
  342. Concatenate unique values among duplicates
  343. Excel Charts with Data Tables
  344. Remove e-mail address from general text field.
  345. Searching on 2 columns and putting result in third column.
  346. Macro for detect palindromes and repeats in letters/numbers string
  347. Re: I need help desperately !! I need a formula that will allow me to match cells...
  348. Conditional Format
  349. How to discover the difference
  350. RE: A conditional Sum & Count
  351. A conditional Sum & Count
  352. Concatencation and formatting
  353. Screen Size
  354. Offset function gives different answer in columns v Rows
  355. Protect an excel spreadsheet
  356. help with data labels
  357. lookup function help
  358. Area
  359. Importing Data Wizard
  360. RE: separate lastname from firstname
  361. Data Conversion - times, dates & rows
  362. Combo boxes and drop down lists
  363. SUMPRODUCT
  364. SUMIF formula using data from another file
  365. definite integral
  366. need formula help
  367. conditional formatting expiry dates
  368. Creating automated timeline
  369. Excel Functions
  370. I have lost the soft, blue borders of some cells.
  371. Bolean Logic with the Advanced Filter
  372. Calculate running average but not count a zero.
  373. SUM, AVERAGE and PRINT with #N/A cells
  374. My Worksheet Needs to Input Cell Data Automatically to Other Cells
  375. Drop Down Starting Position
  376. IF Function based on a set of numbers?
  377. Drop Functions and Sorting
  378. Forcasting question
  379. How do I use a cell format to figure out a data?
  380. Re: Is there a function to print file name/path on a spreadsheet?
  381. Count IF
  382. Sum with New Cell Reference
  383. Re: Is there a function to print file name/path on a spreadsheet?
  384. Is there a function to print file name/path on a spreadsheet?
  385. Excel 2002-7: Modifying Sub Total Function to allow insert blank r
  386. IF
  387. RE: Adding Rows
  388. IF
  389. Chart Data Table
  390. Adding Rows
  391. Using multiple IF conditions
  392. Using dropdown in protected sheet
  393. how do I add gridlines to a single cell?
  394. Help with INDIRECT
  395. Auto Sum
  396. Sum or Average with #N/A cells
  397. Cells will not clear - if I type 1 it comes up as 100 know matter
  398. How do I count just the numbers in a cell, no spaces or comas?
  399. Linking worksheets in different workbooks
  400. Import worksheets from another workbook?
  401. Vlookup from more than one Tab
  402. RE: Trying to compare the datas...
  403. Trying to compare the datas...
  404. Enter a number on different cells automatically ?
  405. number of periods function where payments(inflows) are not equal
  406. sumif error
  407. Getting a value within a range
  408. Headings to appear on next pages?
  409. RE: Quick lookup for data
  410. I think I should use absolute values to:
  411. Quick lookup for data
  412. I want to sort a column of data which is the SUM of three cols
  413. If Date Function
  414. Page Layout
  415. fiting my workbook to get the most colums and rows per page
  416. Formula for non matching items
  417. Sum of cells, where there are not errors in them
  418. creating numbered coupons using word and excel mail merge
  419. Excel file in compatibilty mode and not all sheets within the fil.
  420. Copy of realtime data.
  421. test 2 ranges
  422. Protect/unprotect a formula
  423. calculate PV of lump sum payment
  424. HELP!! VLOOKUP, INDEX or MATCH??
  425. calculation help please
  426. excel opens right justified
  427. Re: Shading specific cells
  428. Shading specific cells
  429. conditional formatting in excel 2003
  430. how can i use the = to move formatting and content between tabs?
  431. Excel: auto-repeat a value in different fields
  432. Trigger a Date & Time stamp by entering data in another field...
  433. Formula
  434. Index match combination
  435. Total price...
  436. File name Save
  437. "Global" change Pivot Value field settings
  438. Add rows depend on the number in a cell
  439. Add Rows depends on the number in a cell
  440. Help to shorten a formula
  441. Cell protection short cut button
  442. what's the function to use absolute value in excel for a macbook?
  443. Need to calculate the number of days between two dates on a 30 day
  444. Excel If statement copy only if ISNumber result is yes
  445. 3 D reference of IRR formula.
  446. Unable to create/use hyperlinks
  447. Choosing Names From a List
  448. 0.7800629 Like What Is In Here? 0.7480189
  449. Identify which column 'Large' finds a match in
  450. Date difference Average
  451. Need to stop formula and keep value on met condition
  452. Stop displaying a message because of a formula
  453. finding a number within a range
  454. Countif function with multiple column criteria?
  455. Dragging across columns: I want column constant, but row increment
  456. linked workbook cell returns 0 is source workbook cell is blank?
  457. Allow users to edit cells but not save the info
  458. Can you allow users to copy & paste protects cells
  459. Formula for week ending
  460. I need to know how to use the solver
  461. Will not give accurate totals.
  462. Get cell reference address
  463. How do I use the text content of a cell as a worksheet reference?
  464. Round up or down to $X.X9 or up to $X.X5
  465. Drop down fill box does not appear when cell clicked.
  466. formula
  467. WHETHER TO USE COUNTIF, SUMIF or SUMPRODUCT
  468. Logic If formula - multi-parameters can not get to work??
  469. Macro to insert lines
  470. sumif
  471. Goto last row of the sheet
  472. sort function
  473. Values imported from one workbook to another
  474. Multiple logics in one formula
  475. Inserting page breaks
  476. How to add hyperlink a column of URLs using Ctrl+K
  477. sum numbers in cell string array
  478. Conditional formatting.
  479. Looking for an ID number in a column
  480. I want to increase the value in cell A1 from 0 to 10 then reset
  481. Utilizng full AutoFilter features while specific cells are protect
  482. Utilizng full AutoFilter features while specific cells are protect
  483. How do I creat a math formula that remains in Excel.
  484. create a list that places data in 3 colmuns (cells) from mult row/
  485. Average every x cells
  486. Worksheet Automation and Size Limiting
  487. RE: Filtered spreadsheet performance
  488. Adding Columns with Multipliers
  489. Re: Calculate Months to Determine Length of Service
  490. Re: Calculate Months to Determine Length of Service
  491. conditional formatting question
  492. Filtered spreadsheet performance
  493. Calculate Months to Determine Length of Service
  494. IF function help
  495. if statement with date
  496. changing the vlookup col_index_num
  497. conditional drop down list problem
  498. 2003 function moved to 2007 unable to change absolute references
  499. Custom Cell Style - Shows as error and cannot be deleted
  500. Automatic Worksheet Calculation when Worksheet Name Changes
  501. Problems CONCATENATE expression
  502. Which is Better / More Functional / Accurate
  503. Using NULL in shading cells
  504. finding "Like" names in rows
  505. Countifs of prior years monthly data based on MTD today
  506. trying to match text in 2 worksheets
  507. vlookup or index for text on 2 worksheets
  508. More on Combined IF Function
  509. sum the current month
  510. How do I change fonts in a DV drop down menu
  511. Converting number of days
  512. format as a table and cannot remove formatting
  513. Date calculations resulting in negative numbers and averages
  514. Vlookup and return the value from the look up value sheet
  515. Count with multiple criteria / combination
  516. Functions
  517. If Formula - checking the same cell for different entries
  518. how to make a function to extract from to
  519. Copying data from several sheets to a front sheet
  520. Multiple criteria IF statements?
  521. how to give hyperlink to hidden excel sheet
  522. array of data and nested bits
  523. IF Statement - compare to coloured cell
  524. Customized marcos cannot save to tools-bar
  525. count a value in a date range based on a date in another workshee.
  526. merging data/worksheets
  527. Selecting a row in a worksheet
  528. Horizontal Scolling Does not Work
  529. Get value equal to final point of chart trendline [=Trend( )] ?
  530. Horizontal Scroll Bar Not Working
  531. How Accurate is Solver?
  532. Combine IF Statments
  533. function needed
  534. compare and return a value from another worksheet
  535. Multiple selection drop down list
  536. excel does not mark cell with inserted comments.
  537. I am trying to link
  538. Percentage to Get Invested Return
  539. Strip Out Four Characters, then Average
  540. Add 2 days before and after birthdate
  541. Link changes in destination workbook
  542. Rolling 12 Spreadsheet
  543. RE: Comparing text and then adding numbers if the text matches
  544. RE: Comparing text and then adding numbers if the text matches
  545. IF Formulas and Summing Results
  546. Rearranging irregular data to monthly format
  547. cell content - data entry order by enduser
  548. How can I calculate equivalent annualized cost
  549. what do you call the "button" that lets you select a single item
  550. Conditional Indexing
  551. Add $1 to a long row of #'s
  552. Can Excel 2007 copy and add worksheets based on population a cell
  553. How can I protect a sheet so the rows/columns can't be deleted?
  554. SUM'ing hours for certain workers
  555. Link format along with contents of another cell
  556. I do not want the letters and numbers on the border to show
  557. Using IF to compare ranges
  558. How to save a blank excell sheet
  559. data sorting
  560. Counting the # of values in a range ???
  561. I can not sort data - why
  562. subtotal function won't work
  563. Calculate Average with 'x' in Range of Cells
  564. AUTO HIGHLIGHT ONLY ROW WORKING IN
  565. Tabulate Survey Results in Excel 2003
  566. formula that advances
  567. how to convert list of numbers to barcode font
  568. Weighted Averages for Rankings
  569. multiple sheets 2 work books
  570. formula to work in a 3-d reference with 2 work books
  571. Conditional Formatting
  572. indirect function with r1c1 style
  573. Comparin data in cells
  574. Vlookup with part of cell text
  575. Formula With A Minimum Value
  576. Multiple Logics to be looked at
  577. Find certain text in a cell
  578. Formula for Cell address
  579. Cell Address presents in Formula
  580. Default print layout
  581. Extract Formula to Text
  582. Repeat Cell Based on the Value-Excel 2003
  583. How can i give name to the selection
  584. How can I lock formulas but allow date entry in a cell
  585. summing to defined ranges
  586. Multiple IF functions
  587. how to remove spacing in between text
  588. Seperate Name, Street Address & City, State Zip
  589. Vlookup
  590. How to find a column number using variable criteria?
  591. Multi-Worksheet Sumproduct & Listing
  592. Trying to make a SPC Chart at work......
  593. Listing multiple values in a macro
  594. copying info from one workbook to another one
  595. LOOKUP & MATCH syntax ??
  596. Conditional Formatting based on 2 criteria
  597. COPY RIGHT AND TRANSPOSE
  598. Deleting rows (with zeros) with a macro
  599. Paste Formula
  600. Remove Zero Formula
  601. how many rows away from a number to a space below
  602. Average formula for dates range - Excell 2007
  603. how do I automatically open blank workbook when Excel
  604. Lookup two factors in an array
  605. xlbgnm in remote data
  606. Input "="
  607. Truncating data in drop down list
  608. how to save worksheet with hard tabs
  609. Last Line
  610. Functions referencing a different workbook
  611. Sum when one cell is blank & another cell is not blank.
  612. Pyramid calculate
  613. Weekending Function
  614. Delete blank columns
  615. Copying a column list from one sheet to another and repeating???
  616. lock of copy command
  617. Based on data in previous column - sum of values in next column
  618. Macro !
  619. How can I add up multiple IF results.
  620. linking cells with scheduling workbook
  621. Day of week Fill down column not working
  622. Run macro on all sheets
  623. IF function question
  624. Using Sumifs
  625. VBA Code not working on Shared Workbook
  626. find the second match using the match function
  627. Excel 2003
  628. Protect Validation from Copy Paste function
  629. Macro to make multiple copies of a formatted worksheet
  630. Re: Formula question
  631. Ranking Formula
  632. match-up formula
  633. Drop Down Box in 2003
  634. SUMMATION combined with PV formula
  635. Need help finding the last cell w/data
  636. Creating an "If" Function with multiple "if"s
  637. Display of revision date in document
  638. Excel spreadsheet embedded in Word, then saved to PDF
  639. rounding numbers to the nearest dollar amount
  640. SUMIF has slowed down the workbook
  641. Multiple Rows in LOOKUP
  642. 24 hour clock formula for elapsed time between 1215 and 1630
  643. VLOOKUP ?
  644. Sumproduct array
  645. Calculate Monthly Inventory Usage
  646. Counting occurrences with 2 seperate criteria
  647. Need help with formula to search and compare data in different col
  648. Lookup Question
  649. Copy/Paste Doesn't Carry Formats
  650. Linking Data from 1 worksheet to another by using dates?
  651. concatif
  652. How do I lookup the sheetname in a workbook
  653. reference to other sheet as a string
  654. Tidy up multiple find and replace code
  655. copying conditional format in a range of cells in excel 2007
  656. converting seconds into minutes
  657. How can I test for colour format in if statements?
  658. Creating an active timeline of data from cell input
  659. Delete part of a text string
  660. function =IFERROR LOOKUP works in excel 2007 not in excel 2003
  661. roundup a month
  662. What formula do I use to copy only text on left side of a comma?
  663. Creating one formula for use in two different cells
  664. please help - Match function returns "true"
  665. Workday
  666. Wieghted average rate
  667. Formula for the calculation needed to come up with a total
  668. Displaying items from a column list in another sheet?
  669. countif with multiple functions
  670. Worksheet formula - auto populate
  671. lookup then concatenate
  672. Text from excel address
  673. IRR for monthly outflows
  674. How do you write a recursive formula in excel?
  675. Extract one character
  676. formula setup for number combinations
  677. Excel and C++
  678. Use Sum() with variable range
  679. How do I find arctanh() in exel
  680. How do I set my time and get rid of sample time using functions
  681. Separate raw data onto different worksheets
  682. from where has to access mail merge option in MS Excel 2007
  683. Finding a specific text in a cell
  684. Help with formula
  685. 0.699861 Realize The Pleasure Of It Now ... 0.8895339
  686. Concatenate HTML containing double quotes
  687. Formula correction
  688. changing array in vlookup
  689. Re: INDIRECT within VLOOKUP
  690. Help Counting 10 Columns * X Number of Rows
  691. Concantenate columns with dates and text
  692. Can Not get cell to accept any format change! Source from html
  693. Sounds simple but isn't - displaying cell text
  694. Data validation (lis) question
  695. Difficult Formula lookup
  696. Unexplainable XIRR #NUM! Error
  697. Countif and Sumif functions not working in Excel 2007
  698. Countif & Sumif fx ref data in multiple columns
  699. Can I have two conditions in a SUMIF?
  700. Figure out date from total days in year
  701. RE: Formula to Count
  702. Re: Formula to Count
  703. Does anyone konw how to set up a simple weekly household budget
  704. Re: Formula to Count
  705. Formula to Count
  706. RE: Is it possible to SUM based on value of another column?
  707. Is it possible to SUM based on value of another column?
  708. Sumproduct DIV/0 Error
  709. RE: vlookup and using single quote
  710. Re: vlookup and using single quote
  711. RE: Accept or Reject a value
  712. Adding X# of minutes to time (HH:MM:SS)
  713. vlookup and using single quote
  714. Accept or Reject a value
  715. Count functions
  716. If/Then formula looking at fallouts not between 0 to 1
  717. Difficult formula
  718. Re: Macro for Selecting Cells within a Range
  719. How do I find only number caracter in a string?
  720. Re: Using the IF fuction for multiple cells
  721. find duplicates in list
  722. Using the IF fuction for multiple cells
  723. Macro for Selecting Cells within a Range
  724. Show the formula not the result
  725. How do I turn on color banding to locate the active cell in Excel?
  726. HLookup & Match returns "TRUE"
  727. Sum fuction
  728. RE: Formula for Tab Content
  729. Formula for Tab Content
  730. multiply data in every 3rd row on a sheet
  731. Array formula SUMIF with 2D sum_range array
  732. clipboard hold how much items
  733. Set up a count and countif?
  734. Position of first number in array greater than a given number
  735. Sum of numbers in multiple columns
  736. MATCH to return row number not working in HLOOKUP
  737. RE: Amount minus VAT
  738. Amount minus VAT
  739. Index Match Problem
  740. RE: macro to list folders only, not files
  741. macro to list folders only, not files
  742. counting words and assigning a numeric value
  743. how do i convert data with miliseconds to just h:mm:ss
  744. Conditional Formatting - Comparing 2 columns
  745. Should I use VBA or can I use formulas for this task.
  746. Calculating NPV
  747. Vlookup
  748. #N/A error with Yield formula
  749. Analysising data between sheets
  750. Number format to Text