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 161

  1. How to record changing value of a cell
  2. Re: Dragging a formula down isn't working - where am I going wrong?
  3. Unhide column difficulty
  4. Re: Searching for text and returning text
  5. Re: IF Statement Table Help
  6. finding repeating numerical pattern using array functions?
  7. Re: Function or Sub to help with text string
  8. Re: Formula for calculating target hours against actual hours
  9. Re: Formula for calculating target hours against actual hours
  10. Questionnaire using Excel
  11. How do you Combine Two IF formulas
  12. Re: Macro to change referenced column to the next one
  13. if and replace function?
  14. Re: Advanced Drop-down Menu
  15. Re: Varying cell ranges in formulas according to number of cells with certain value
  16. Re: Automatically populate value of cell dependent on adajecent cell
  17. Re: Automatically populate value of cell dependent on adajecent cell
  18. Formula to add two spaces into a number stored as text
  19. Re: Generate series according to range and increment
  20. Re: Dynamic Ranges Adding Extra Row
  21. CONDITIONAL FORMATTING IN EXCEL 2010
  22. Re: Text Dates/times to d:hh:mm:ss
  23. Comparing two lists
  24. Re: Multiple VLOOKUP lookup values
  25. Removing #N/A from an "If/Then" statement
  26. Nameing a function
  27. Re: Converting a number into a cell reference
  28. Re: Converting a number into a cell reference
  29. Pulling From Multiple Sheet
  30. SUMIF with criteria "<>" & "="
  31. using duplicate function
  32. Re: Look up one value and return multiple corresponding values
  33. Re: Problems with conditional average
  34. Re: adding a forumla to cells with formula in them already
  35. Re: Help with an if then scenario
  36. Re: Excel PMT Function Help
  37. Re: Conditional Formatting
  38. Re: Conditional Formatting
  39. Re: Finding a Name
  40. Re: problem with time subtraction
  41. Re: Custom Autonumber with Prefix and Category Grouping
  42. Re: problem with time subtraction
  43. Re: Displaying Returns from another worksheet that change?
  44. weekday last year
  45. Curly Brackets
  46. Re: Counting multiple occcurrences between date range
  47. drag formula down from columns that go acros
  48. calculating volatility
  49. separating date and time
  50. Re: Multiple IF conditions
  51. Re: How do I combine 2 data sets using date?
  52. Re: linest internals
  53. Re: linest internals
  54. Re: linest internals
  55. Excel Formula question
  56. Re: Easter day formula.
  57. Re: Dividing after a long formula
  58. Re: Dividing after a long formula
  59. Re: Lower case date
  60. Re: If then formula with multiple Ifs
  61. Formula to tell day of week
  62. Re: 2 Formulas needed!!! :)
  63. Re: 2 Formulas needed!!! :)
  64. Re: Multiple column scroll
  65. Re: Multiple column scroll
  66. Help needed regarding calculating time
  67. Re: Can I disable the Save As Function?
  68. Sumproduct Help!
  69. Conditional Time Calculation
  70. Re: Sort by placement value from left to right & adding trailingzeros for short
  71. Re: Sort by placement value from left to right & adding trailingzeros for short
  72. Re: LOOKUP trouble
  73. Hlookup 3 criteria??
  74. Formatted cell column in drop down list
  75. Re: need help in creating a formula
  76. Re: CheckBox Control Copy and Paste
  77. Conditional formatting
  78. Macro to open CSV files
  79. SUM Q
  80. Hyperlinks with lookups
  81. Re: Combing a V Lookup result with ("00"&A2)*1 in same formula
  82. Financial Time Value of Money calculations
  83. Re: Needs help combining functions.
  84. Mick & Clause & Experts Please help me on this issue one more time
  85. VBA code for Sum and diff
  86. Gears
  87. Re: Delete Text in Multiple Cells
  88. Re: Count Word in long string
  89. Re: Delete Text in Multiple Cells
  90. Countifs bites again
  91. counting repeats.
  92. Re: Getting sum of values in another sheet while using condition
  93. Re: Help with lots of formulas
  94. INDEX return multiple columns
  95. Sumproduct?
  96. Re: calculate average values for 100 records in the shortest way?
  97. Re: Excel Countif Function - Calculating Between Two Sets of Values
  98. Re: Identifying text in a string
  99. Re: Identifying text in a string
  100. Re: Cell Auto Lock After Entering
  101. Changing Pivot Table Value Field Labels with VBA
  102. Combining an IF with another formula
  103. Calculate elapsed time excluding specific timeframe
  104. Absolute References and worksheets
  105. Re: Using a vlookup to search multiple criteria for one result?
  106. Re: Using a vlookup to search multiple criteria for one result?
  107. Re: Returning a value from a range
  108. Proprietary text on popup buttons
  109. Ms Excel Multiple Logical Test Function
  110. Re: I need a lot of help with MS Excel 2010
  111. Re: Multiple Columns in Sum Range using SUMIFS
  112. Numerals conversion
  113. workbook opens to the same sheet every time not the one it was saved as?
  114. Get percentage of whole
  115. New group but no Star to click...?
  116. Vlookup to reference offset
  117. Re: Problem using IF statement with dates as part of the formula
  118. Re: Problem using IF statement with dates as part of the formula
  119. Ttest across multiple worksheets
  120. Re: Excel help needed: Skipping cell without skipping cell reference
  121. Dragging a formula in a column
  122. Re: Excel 2010 Conditional Formatting
  123. Re: If Function
  124. Excel 2010 If Then logic - with time
  125. Function for summing or counting cells based on a specified fill color
  126. Go To a Named Range (2nd posting)
  127. Auto Change Formulas - Please Help.
  128. Conditional Formatting
  129. Re: help to remove space before the data
  130. Limit to MOD function
  131. Re: Time Calculation
  132. check value in cell
  133. Re: help to remove space before the data
  134. Re: help to remove space before the data
  135. Re: Index/Match Functions to Return Concatenated Response
  136. Re: Help with IF Function for times.
  137. Re: Help with IF Function for times.
  138. using mid find to either extract a number with 2 decimals or excludeFROM A STRING
  139. Excel check value i cell
  140. LINEST multiple known_x's separated arrays
  141. Re: Counting unique instances of a text string
  142. Re: Inequalities Function
  143. Re: Inequalities Function
  144. Can UDF return a customized hyperlink?
  145. Re: Excel Function Help
  146. Re: Why is excel rounding my numbers in VBA?
  147. Re: Why is excel rounding my numbers in VBA?
  148. Re: Divide a # into 3 #'s rounded to a whole #
  149. somewhat complex if statement help PLEASE!!!!
  150. Re: Divide a # into 3 #'s rounded to a whole #
  151. How Do I Avoid #REF! In Formulas?
  152. Re: Define a Range based on Cell Values
  153. Re: text to number graph
  154. Re: Variable interest rate loan calculations- PLEASE HELP!!!
  155. SUMIF "value if false" not working
  156. Data Validation - Complex Q
  157. Re: Looking up other sheet for value X depnding on sheet Y and Z colums
  158. If - Then Fields
  159. vlookup formatting problem
  160. product code a value
  161. Go To a Named Range
  162. lookup two different variables
  163. Re: Show value from one cell in another cell if today falls between a date range
  164. Re: Show value from one cell in another cell if today falls between adate range
  165. Re: Elementary SUMPRODUCT Question
  166. Re: Formula to predict future data
  167. Length cutting optimizer
  168. Calculating weighted average of Percent Change
  169. Re: Autosize Merged Cell
  170. Re: Sum Function has small remainder
  171. Generating a cut list
  172. Re: Auto populate date VBA code
  173. Re: =sum with a filter
  174. Rounding cents
  175. Index Match on Columns and Rows
  176. Re: Sumproduct giving #Value error
  177. Re: Sorting problem. My header rom is getting sorted with the rest.
  178. Re: Concatenate cells with line breaks in them
  179. Re: Year End totals
  180. Re: Rolling 12 month
  181. Re: Recurring Items in Spreadsheets
  182. Copying formulas across columns
  183. Re: Concatenate cells with line breaks in them
  184. Numbers in word
  185. Re: Rolling 12 month
  186. How Do I Find Different Values In A String?
  187. Line chart based on 3 columns
  188. complex sort search and replace macro
  189. Re: sumproduct
  190. Re: Can XIRR Work on Dates That Move Backwards in Time?
  191. Re: Can XIRR Work on Dates That Move Backwards in Time?
  192. Yes or blank, depending if value equals or exceeds value found inVLookup table.
  193. CountIf with And
  194. Re: sumproduct by year
  195. Percentage Increase
  196. Re: Help with a running total on multiple sheets
  197. Re: Vlookup doesn't work: results are wrong
  198. Macro to concatenate with previous bold cell
  199. How can I count deviations between two rows?
  200. multiple SUMIF help/advice
  201. Formula help needed please
  202. Re: Control F
  203. Find partial text and retrun value in corresponding column
  204. Re: Smoothing Data in Columsns in Excel 2012
  205. Copying a cell value to another sheet by using If statement
  206. TIME CALCULATION
  207. Re: Comparing MONTH and YEAR inside Formula ??
  208. Re: IF validation for time totaling
  209. Re: Drop Down List Dependant Formula
  210. Re: YTD SUMIF based on current date
  211. Testing a cell value for a specific weekday.
  212. How to ignore a column of numbers in Grand Total for rows
  213. COMPARING TWO COLUMNS AND DISPLAYING MSGBOX
  214. Re: How to calculate time percentage of number of parts being pick in a timeframe
  215. Copy columns, but not hidden ones
  216. Can I add a range and then divide that sum by a specific value?
  217. VLOOKUP, a table with text and numerics
  218. Re: Lookup in multiple & separate cells
  219. sum character
  220. Re: If value between 2 numbers
  221. Re: If value between 2 numbers
  222. How to reset excel worksheet form lilstbox and combo box
  223. Re: Multiplying a Number Found in an Alphanumeric String
  224. count not-overlapping days in a "Table" with Beginning and EndingsDates Specified
  225. Re: Antilog
  226. Re: excel formulas
  227. 2 dimensional date sort
  228. Calculate total by row number
  229. Re: Match/Index/Sum function with date range
  230. Re: Calendar Logic: Recurring Dates
  231. Learning arrays.
  232. Countifs with different restrictions
  233. Re: Index and match if field contains specific text in it
  234. Re: *Issue* Concatenate dates in a large range of cells in a row.
  235. Re: *Issue* Concatenate dates in a large range of cells in a row.
  236. How do I assign "Apple" to a cell reference in this evaluate code?
  237. Need help writing VBA module
  238. NumberFormat for small non-zero numbers?
  239. NumberFormat instead of an IF
  240. Re: Replace data to right of string problem
  241. Re: Replace data to right of string problem
  242. date & Time
  243. COUNTING THE SAME VALUES IN A SHEET
  244. Protect and Edit Object
  245. sorting noncontiguous data with exceptions
  246. Re: Matching two columns of data
  247. Re: Matching two columns of data
  248. Re: Simplifying multiple IF statements?
  249. Re: return a value depending on two previous values
  250. Vlookup and return sheet name also
  251. Re: Bitwise Functions?
  252. Re: Identifying common data between 2 cells
  253. Re: Multiple VLOOKUP in an IF statement
  254. Re: Evaluate Multiple Cells for any Value
  255. Re: Multiple VLOOKUP in an IF statement
  256. Re: Need help finding a substring in a array of strings.
  257. copying column multiple times
  258. Re: Validation of cell based on Drop down list
  259. Return Column Header from an Index/array, finding Large with a userinput date
  260. Re: Need formulas for searching for a value in a table and returning row/column name
  261. Re: Using IF, AND and OR functions together
  262. Re: Need help calculating probabilities
  263. Re: Month Calculation
  264. Re: Search Text and Add a Blank Line
  265. Re: Month Calculation
  266. Re: Pls Help - blank cell/formula issue
  267. Re: Help. Trying to do the opposite of VLOOKUP
  268. names dates & amounts stated multiple times in document
  269. Re: Help on the Sumif Function
  270. Re: Excel Template required for Daily managing daily income andexpense at Mobile shop
  271. Remove punctuation mark, Split cells & average accross column
  272. Re: Median Formula not working properly
  273. Help Needed : how do i compute this?
  274. Re: Copy values for every nth cell
  275. Re: Date reformatting question
  276. Countif with two criteria
  277. Re: Date reformatting question
  278. Re: Date reformatting question
  279. Re: Vlookup
  280. Re: Copy values for every nth cell
  281. Calculating Future Value
  282. LOOKUP function??
  283. Re: Generate 1 or 0 in xls with input probability
  284. Re: Simple COUNTIF function help
  285. Re: Help Needed! Using complex IF function
  286. Convert Number to Text for Index/Match
  287. Re: Help needed: Minimum value based upon either/or criteria
  288. Re: Help needed: Minimum value based upon either/or criteria
  289. Sort column beginning with blank?
  290. INDEX MATCH SMALL
  291. Re: Name break into half and reverse to upper case
  292. Re: help w indirect and index,match
  293. Re: Please Help! Delete all cells in range except "1934 - 1934"
  294. Re: how to count rows if 2 columns partially match
  295. Extract the 2 Lowest %
  296. Calculating time for 3rd shift
  297. Computer Properties
  298. Club Accounts
  299. Re: Extract Alphabets and Numbers from a Cell
  300. Re: Possible Sumproduct with Or Function
  301. preserving zeros in spreadsheet
  302. Re: coding descriptors
  303. Re: Extract Alphabets and Numbers from a Cell
  304. Re: Lookup Value From Sheet2
  305. range definition by cells numbers
  306. Logical formatting for multiple values
  307. Preserving trailing zeros for a fixed width file
  308. Re: Multiple Criteria Lookup
  309. Re: Conditional Formatting Formula
  310. Re: Conditional Formatting Formula
  311. VLOOKUP return cell location and hyperlink
  312. Re: Formulas won't function
  313. Re: Automatically sort alphabetically ignoring header
  314. Re: need help with Formula
  315. Re: Simple (maybe) percentage forumla
  316. Re: percentage calculation
  317. #value error for sumproduct using RIGHT cmd
  318. Re: percentage calculation
  319. Re: Series command grayed out
  320. Convert number to text as displayed
  321. Extract first and last login time for each day only
  322. Add time when working 3rd shift
  323. Re: help!
  324. Re: Nested If Statement help
  325. Re: Detailed Countdown
  326. Excel 2010,Voice Win7
  327. Re: Counting cells with SUMPRODUCT and conditionals...?
  328. Re: help!
  329. Distribution of capital contribution
  330. Re: VLookup sum multiple matches
  331. Re: Vlookup Returning Zero For Every Cell
  332. Re: Vlookup a subtotal
  333. Re: Display next available number
  334. Re: Vlookup Returning Zero For Every Cell
  335. Show latest date
  336. Re: Search for string based on two columns
  337. Re: Help with complex IF statement
  338. Re: Return a value if a range of cells contain text
  339. Re: Search a range for instances of a text string, return neighboringcell values each ti
  340. Extract Date formula Only
  341. Re: Complex Lookups
  342. Re: Complex Lookups
  343. Re: Problem with formula for finding last greater than/less thanor equal to value
  344. Re: Unable to nest my IF statements properly
  345. Re: Problem with formula for finding last greater than/less than orequal to value
  346. Calculating aggregate donation sums for a list of names
  347. Re: Unable to nest my IF statements properly
  348. Return the value from one range that does not exist in another
  349. Re: Complex Lookups
  350. Re: Using IF and VLOOKUP for range of cells
  351. Re: Using IF and VLOOKUP for range of cells
  352. Re: Using IF and VLOOKUP for range of cells
  353. Re: Using IF and VLOOKUP for range of cells
  354. Re: display Column Header based on cell value in a range
  355. Wage Calculator Q
  356. Re: Calculating days spent to complete a task
  357. Re: Deriving several lists from a master list
  358. Re: Deriving several lists from a master list
  359. Re: Sum of values in column A based on 0/1 of column B
  360. Re: How to calculate difference between two date & time along withworking hours and days
  361. Re: How to calculate difference between two date & time along with working hours and days
  362. Display data for rows where cell consists of whole number
  363. Re: Trying to count based on multiple criteria & cell comparisons
  364. Re: Trying to count based on multiple criteria & cell comparisons
  365. Compare 2 lists and return value
  366. Help! Is this possible
  367. Excel time leading 1st ZERO
  368. Solve for a number (x)
  369. Sorting by frequency
  370. Re: Urgent help with Excel formula. Please please help
  371. Re: Findiing highest and lowest in rows and columns
  372. Re: Findiing highest and lowest in rows and columns
  373. Re: Making data in appear in one worksheet from another
  374. Re: Conditional concatenating!!!
  375. Command Button to create a folder
  376. Re: Joining VLookups with line breaks but ignoring blanks
  377. conditional formatting update issue
  378. Re: Compressing multiple functions across an array into one cell
  379. Re: Multiple Nested If Function
  380. Re: Multiple Nested If Function
  381. Re: Multiple Nested If Function
  382. Re: One lookup option
  383. Re: Function to Combine Names and Middle Initital In Various Formats
  384. putting number against certain words formula
  385. Re: Countif year = help needed
  386. Solver Compiler issue
  387. Re: Conditional Formatting discarding zeros
  388. Re: Sum of Variable Cells in a fixed Row
  389. Re: Sum of Variable Cells in a fixed Row
  390. Re: Help in Median of a quartile
  391. Re: Index Match function for lookup HELP
  392. Re: Index Match function for lookup HELP
  393. Re: How do I convert cubic feet to cubic meters?
  394. Re: VLOOKUP Help
  395. Re: Lookup function to return highest value
  396. Re: Totaling Categories - Monthly and YTD
  397. Re: consolidation data in one row
  398. Re: consolidation data in one row
  399. Re: Excel Template required for Daily managing daily income andexpense at Mobile shop
  400. Re: 12 columns by 8 rows to one row
  401. Array formula lock-up
  402. Re: Use an "OR" around nested IF statements
  403. Re: Use an "OR" around nested IF statements
  404. Re: calulation
  405. Re: Help with count/sumif
  406. Run-time error 1004: Unable to set the left property of the OLEObject class
  407. is there a way to cut and paste text into excel with each paragraphimporting to it's own cell / row?
  408. Conditional Formatting in Excel when data changes
  409. Lookup Across Multiple Rows / Columns
  410. Don't know if it's possible, but...
  411. dynamic data copying between worksheets
  412. COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION
  413. Re: Over time?
  414. Re: Randomize numbers
  415. Re: match some character in b1 to c1 and display on d1
  416. How to Count Strike throughs
  417. Re: Looking up Duplicate values in table
  418. Re: combine three if functions
  419. Informal invite to "Excel Blackbelts"
  420. Re: Help with IF function
  421. Re: Remove numbers from text cells
  422. Re: Remove numbers from text cells
  423. Re: Help with IF function
  424. Help on randomly selecting cells to SUM
  425. Re: Formula Help on Interpolation
  426. FV when compounding occurs every 30 months
  427. Re: Get sum of values in a cell based on unique values in another cell
  428. Re: sumif issues
  429. Re: the specified form cannot be entered because it uses more levelsof nesting
  430. Countif formula perhaps
  431. Re: SUMIF with broken range
  432. Re: If formula producing #VALUE Error
  433. Re: Comparing 2 columns from 2 different Worksheet and Returing Valueof a 3rd column
  434. Re: Match Array returning #NA, Works individually
  435. Re: Returning next item in list
  436. Re: Condtional Formatting or LOOKUP ?
  437. Sumif to multiple tabs
  438. Re: Highlighting duplicates on different sheets
  439. Re: Matching people to skills.
  440. Re: Counting Text
  441. Re: sumproduct
  442. Re: Have the SUMIF result (formula) on a separate sheet/tab
  443. Re: Blank until data is entered
  444. formula issues.
  445. countif and sumif
  446. Re: Help decipher this code PLEASE!!!
  447. Re: IF and IF and IF
  448. Re: Help decipher this code PLEASE!!!
  449. Re: Countifs with error #Value!
  450. Re: IF and IF and IF
  451. Re: Formula not being Friendly
  452. Re: freeze first colums and hide one colums
  453. How to extract separated text by many commas in Excel?
  454. Re: Calculated % completed by date
  455. Re: formula to work from data column
  456. Re: Date Format
  457. Re: Date Format
  458. Re: Date Format
  459. stock remaining..
  460. First row where a cell is zero
  461. Re: Enabling Macros message when NO macros in workbook
  462. Re: Enabling Macros message when NO macros in workbook
  463. split range address into individual cell addresses
  464. Variable to rename a tab in a worksheet via VBA
  465. Re: Using formula to convert date result to text
  466. Re: Representing letters (and symbol) to different numbers
  467. Re: vertical and horizontal lookup?
  468. Re: How do I sort data
  469. Referring to a cell by using another cell for the row number
  470. I need help with a Function
  471. Re: IF ARRAY with multiple conditions.
  472. Re: Needing help with a Function on Excel.
  473. Re: Calculating an average of data between two dates
  474. I need Help with a date calculator
  475. Re: Need to extract text between numbers in a string
  476. Re: Need to extract text between numbers in a string
  477. Re: Here is Mortgage Calculator with Amortization
  478. Re: Need urgent help with Excel formula
  479. Re: Here is Mortgage Calculator with Amortization
  480. Re: Excel formula not able to work this out
  481. Re: Date Range and Time Range IF Statment
  482. Re: Getting text or numerical data from the formula
  483. Show date based on conditions
  484. Re: Lookup and Vlookup
  485. Secondary axis alignment
  486. Re: Separating data in a row into new rows
  487. Re: What's wrong with this IF?
  488. Re: complicated lookups?
  489. Re: Keeping cells blank even though formula is input
  490. Re: Keeping cells blank even though formula is input
  491. Count data in adjacent cell if criteria met
  492. Re: Change Color of Cell based on Date and today's date.
  493. Re: Returning values listed under multiple conditions
  494. Re: Auto Sum not working correctly
  495. Saving as UTF-8
  496. Re: Date Range Formular
  497. Re: Date Range Formular
  498. Re: Date Range Formular
  499. Standard Deviation from one sheet to another
  500. Re: Group & Sort with formulas (HTML)
  501. Re: Calculating the difference, in hours, between two date/time intwo different time zon
  502. Re: Formula help needed
  503. Re: How to get a formula result to return either "+", "- ", or "="
  504. Re: Counting # of entries for each month, in a specific status
  505. Re: averageif cell doesn't contain "text"
  506. Using 'indirect' function with full network path
  507. Re: Zero Occurance
  508. How to search and replace cells
  509. CountIf previous cell formula
  510. Re: Return a Header Value with 2 vlookup criteria
  511. Formula to choose from the last column of a given row
  512. Re: Need conditional formatting help!!!
  513. IF formula error
  514. Re: Ambiguous name detected: worksheet_change
  515. Re: Linking data from one worksheet to another using ookup functions
  516. Re: What does this formulea mean?
  517. Re: Regression Analysis on Excel
  518. Re: What does this formulea mean?
  519. Re: Count Dates in a range based on Column Header Id without using sum-product
  520. Re: What does this formulea mean?
  521. Re: Function to pull a single cell from a column into another cell
  522. Re: SUMIF over multiple spreadsheets
  523. blank cell return vs. a 0
  524. HELP!!!!!!!!!
  525. Re: Sliding Commission Formula
  526. Converting Text
  527. Select a range not equal to:
  528. Re: Automatic Number Increase
  529. Function to sum values across rows with certain features
  530. Function to Return a Date Value Q
  531. Re: Lock Cell After Data is Entered on Particular Cell
  532. Re: Lock Cell After Data is Entered on Particular Cell
  533. Re: Lock Cell After Data is Entered on Particular Cell
  534. Re: HELP!!! I have written my 1st ever VBA code and need more advice....
  535. Re: Find next Sunday
  536. Re: Find next Sunday
  537. Re: VLOOKUP text vs number issues returning value
  538. Re: Duplication
  539. Re: Function for returning quarter based on current date?
  540. Excel Text Sequences
  541. Excel PRICE function: How does it compute Issue Date of the Security
  542. "Save As" to XML file macro using a cell's value
  543. Re: HELP!!! I have written my 1st ever VBA code and need more advice....
  544. Re: HELP!!! I have written my 1st ever VBA code and need more advice....
  545. I need serious help Worksheet functions
  546. Re: Help on "Highlighting" and "Font Colour" functions
  547. match formula
  548. Re: Index / Match Formula Problem
  549. Re: LOOKUP function help
  550. Re: partial text vlookup or lookup
  551. Re: Formula Help Please
  552. Re: IF statement reference
  553. Re: Time formatting - Excel 2003
  554. Re: What regular savings, increasing every year to reach goal
  555. Re: Formula Help Please
  556. Re: Formula Help Please
  557. Calculating percentage growth rate from a cumulative figure
  558. Re: Date Conditional Formatting
  559. Re: Formula
  560. Cell interpreted as mailto
  561. Re: Copy the content of a cell with Formula
  562. Automatic creation of rows with various permutations of few columnvalues list
  563. Re: Auto populate
  564. Automatic rows creation with various permutation of column values
  565. Re: Average Time Not Calculating
  566. Comment in protected sheet
  567. Re: using an IF or AND function to get next largest value in list
  568. Re: Average Time Not Calculating
  569. Re: sum columns only if date
  570. Re: Only Calculating Numerics
  571. Re: sum columns only if date
  572. Re: sum columns only if date
  573. Re: =IF, If only I knew the answer
  574. Re: =IF, If only I knew the answer
  575. Re: =IF, If only I knew the answer
  576. refresh?
  577. Re: Using SUM(INDIRECT())
  578. Re: Look Up Multiple Values And Returning One Value
  579. Re: SUMIF with Certain Criteria
  580. Re: Counting with multiple criteria in multiple columns
  581. Re: COnverting Weeks into Month (text data)
  582. Re: adding multiple values from matched search results
  583. Re: Function help
  584. Re: Creating an Excel Freight Calculator
  585. Re: I can't paste from one cell to multiple cells anymore.
  586. Re: Dragging down Formulas
  587. Sumproduct in matrix means
  588. Re: Dragging down Formulas
  589. Re: Advanced Countif/H/VLOOKUP Function
  590. Re: Dragging down Formulas
  591. Re: Dragging down Formulas
  592. deleting numbers prefix
  593. Quick way for monthly linking of Excel sheets
  594. Re: Autofilling Alpha-Numeric numbers with column headers
  595. Re: Applying Number to Range.
  596. Re: Applying Number to Range.
  597. Re: Applying Number to Range.
  598. Re: Value of the first day of a year in a list
  599. Re: Formula to return a value in column B conditional upon the value in Column A
  600. Using =RANDBETWEEN(a,b) in a paers of a whole colume
  601. Calculate interest & withdrawals
  602. Sumproduct Ignore Text
  603. Re: Calulating future Age
  604. Multiple Challenging Excel needs....
  605. Re: Using a CONCATENATE function with an IF function.
  606. Re: Averaging times that cross midnight?
  607. Ranking Q
  608. Re: Combine files
  609. Re: Automatically populating cells down a row
  610. Re: INDEX_MATCH or VLOOKUP with multiple criteria?
  611. Add Values that Match 2 Criteria Q
  612. Re: How do I combine/join multiple formulas
  613. Re: How do I combine/join multiple formulas
  614. Re: averaging multiple items from one list
  615. Re: Different Functions in One Cell Cancel Each Other Out - How can I fix this?
  616. Re: averaging multiple items from one list
  617. create manufacturing demand based on customer delivery
  618. Cell reference in formula string displays abbreviated value
  619. Re: correcting #value! problem
  620. Re: How do I highlight past dates
  621. Re: How do I highlight past dates
  622. Assistance in modifying a formula
  623. Cumulative time calculation in Excel 2003
  624. Re: Conditional Formatting based on cell text
  625. Re: Conditional Formatting based on cell text
  626. Re: IRR vs XIRR
  627. Re: IRR vs XIRR
  628. Re: "Repeat Rows" - selected printed pages only
  629. Spurious Formula Omits Adjacent Cells
  630. Checkboxes within a list
  631. Spurious Formula Omits Adjacent Cells
  632. Weighted Average Calc for duplicated values only
  633. Retreive data for same agent
  634. Rank Formula
  635. Rank Formula
  636. Finding dates without attention to data formats
  637. Re: Drop down box w/contents of different worksheet? is this possible
  638. Re: Is there some kind of memory reference limit in excel?
  639. Re: Is there some kind of memory reference limit in excel?
  640. Re: Creating list from values that meet multiple criteria from other sheet
  641. If function across sheets prints value of cell
  642. Re: Counting instances of Specific column entry combinations
  643. Re: reduce data points and average?
  644. Re: reduce data points and average?
  645. Conditional Formatting for 6 month intervals (ignoring day and year)??
  646. Re: Pulling Multiple Vales From Multiple Cells & Displaying them in one cell.
  647. Multiple List Analysis
  648. Re: vlookup issue
  649. Re: How to Sort and Address
  650. Re: Forecast of Inventory - Explaination of Calcuations
  651. Re: Capitilize last word in cell
  652. Re: Spread values across fields
  653. credit intrest on intrest
  654. Re: Calculate duty payable
  655. Macro/Forumula to SUM values from Sheet that does not always exist
  656. Compare identifier columns from 2 sheets - remove rows that are dups
  657. display repeating row information in columns
  658. Re: rounding a number up to a certain ending digit
  659. Re: rounding a number up to a certain ending digit
  660. Re: Need Help With YIELDMAT
  661. Re: median array help
  662. Randbetween Range Problem
  663. Re: SumIf equation question
  664. Re: SumIf equation question
  665. Re: Excel macro for row selection
  666. Re: Excel macro for row selection
  667. If statement based on time ranges
  668. How to check if time falls between two ranges
  669. Re: If equation with a VLookUp
  670. Re: Data (group And Outline)
  671. Re: Using the IF and IFBLANK functions
  672. Re: Horizontal and Vertical lookup
  673. Re: VLookup Won't Copy down (#REF! error)
  674. Re: Combining two separate lists and creating new values
  675. Re: Help on multiple criteria for formula and return a date
  676. Re: Count if data falls within a range AND that has a certain criteria
  677. Re: End Date/Time adding business hours
  678. Allocate an income payment over a date range (tax years)
  679. Re: Need to know give matrixes a name...
  680. Function to establish mortgage bond size.
  681. I need to add spaces to the beginning of my texts which are numbers
  682. Re: Data Validation - Custom question (multiple conditions)
  683. Re: search cell for specific text.
  684. Re: Change the colour of a cell if another named cell is blank
  685. Re: Change the colour of a cell if another named cell is blank
  686. Re: Formula for multiple rows of same value...
  687. Re: Formula for multiple rows of same value...
  688. Re: Conditinal formatting blank output cell
  689. Re: Conditional formatting code
  690. Re: attempting complicated IF comparison with end goal easy for future users
  691. Dsum Help
  692. Re: Excel Formula or VBA Code
  693. Re: check if or not time lies between a time interval
  694. Re: Longtitude and Latitude Question
  695. matching columns to find differences.
  696. Percentile on Aggregate data with multiple criteria
  697. Re: INDIRET fill
  698. Conversions of Decimal Feet to Decimal Inches - Formula??
  699. Re: INDIRET fill
  700. Re: Formula for looking up and copying from another worksheet?
  701. Re: COUNT IF with unconditional AND on cell dates
  702. Re: How do I unhide a row when ENTER is pressed in a certain cell?
  703. Re: How do I unhide a row when ENTER is pressed in a certain cell?
  704. Re: how to link horizontal data to vertical cells in a new sheet
  705. Naming cells
  706. Data validation help
  707. Function to establish the mortgage bond based on a monthly payment
  708. Changing cell content on n auto-filtered column
  709. Re: Adding Periods at Specified intervals
  710. Re: Adding Periods at Specified intervals
  711. #REF issue with links
  712. Dropboxes and VBA code in Excel 2007
  713. Re: Yield to Maturity
  714. Re: Yield to Maturity
  715. Adding days to a date - changed in Excel 2010
  716. Re: Populating entire rows of data from a master sheet?
  717. Re: Inserting a string in a cell reference
  718. Re: Inserting a string in a cell reference
  719. countif
  720. countif
  721. Data Validation
  722. Re: Excel import from PeopleSoft; formulas dont work
  723. Re: Determine Resource Allocations by evaluating available time andrequired time.
  724. Re: If, And Or
  725. Match function: error due to format?
  726. Re: Conditional Formatting
  727. Re: error message "#VALUE!" due to blank cells
  728. Re: error message "#VALUE!" due to blank cells
  729. Re: error message "#VALUE!" due to blank cells
  730. Auto Filter Multiple Criteria
  731. Re: Conditional Formatting Conundrum
  732. can I make an equation to count how many cells are filled below acertain cell?
  733. Re: Cutting out a process
  734. Re: Wildcard issue for Index/Match Function when searching numbers
  735. Re: Select minimum with duplicate values to return column headings
  736. Triple IF?
  737. Re: Change row colors based on a cell value
  738. Re: IF Function not working as I want
  739. Re: Balance Depreciation - how many years?
  740. Re: incrementing batches of numbers
  741. Search and Combine Rows
  742. Re: VLOOKUP FOR COMPANY AND EMPLOYEE
  743. Re: Excel VBA Formula Help
  744. Re: Excel VBA Formula Help
  745. Re: Combine Rows Based on Capitalization
  746. Re: Excel VBA Formula Help
  747. Re: Combine Rows Based on Capitalization
  748. Re: Combine Rows Based on Capitalization
  749. Re: Combine Rows Based on Capitalization
  750. Re: Combine text under different condition