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. Return Min & Cell address
  2. Re: non repeating Random number generation
  3. Intercept and Slope of visible rows, please.
  4. Excel Macros help
  5. Re: How do I update my worksheet? Need Help
  6. Re: Time Zone Conversions
  7. Re: What formula would i need for this??
  8. Different renderings of same pixel heights
  9. Complex search and replace macro based on input variables.
  10. change all below or equal to an input number
  11. Convert Decimal fractions to binary and vice versa
  12. Weighted average till sum of exposure reaches a threshold
  13. Really need some help with a multi conditional SumProduct
  14. Re: difference between two cells
  15. Calculate focal length from FOV on cameras
  16. TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS
  17. Sorting day names chronologically
  18. Re: return a value of specific text within a sentence
  19. Delete rows based on contents of Col A
  20. Check for two sheets. Add or subtract as necessary.
  21. want to track time while paste value in multiple column of same roe
  22. Re: Is multiple IF statements what I'm looking for?
  23. Re: Is multiple IF statements what I'm looking for?
  24. Re: Count multiple specific terms
  25. Augmenting an integer in a column to reflect duplicates in another
  26. Two spreadsheets, filling data from one to the other.
  27. Is it possible to make Excel assume a time happens after another time?
  28. How to add straight line from cell value in pivot table chart.
  29. Re: Cell Auto Lock
  30. Re: Cell Auto Lock
  31. worksheet is not open and copy
  32. Re: Converting formula from Lotus123 to Excel
  33. hidden rows problem
  34. Reference the same cell based on tab name
  35. Conditional Format Cells to Change Color when used in formula of aDIFFERENT CELL
  36. How to enter start and end date/time in excel based on some specific value.
  37. year cant change
  38. Re: Index match formula with multiple conditions
  39. VBA to Filter on variable column
  40. Finding missorted cell in range
  41. Drop Down with dynamic named range offsheet source list
  42. Re: Vlookup an array and report min, max and average as a result
  43. Find Duplicates in a Schedule (Two fields: Time and ApplicantID)
  44. Re: Help with sumproduct
  45. Re: Help with sumproduct
  46. Sum every Nth Row (almost working)
  47. Re: Help
  48. Percentage of month passed formula
  49. Copy corresponding cell in Column B if cell in A contains certain text?
  50. Need to get minimum difference
  51. Making a Sheet copy
  52. Formula than understands midnight?
  53. Finding the weighted average of text that have been given values
  54. Re: Limit drop down items based on another cell
  55. Re: Countif or other formula needed for multiple data/critera results
  56. Autofill alphanumeric prefix in Excel
  57. Re: Countif or other formula needed for multiple data/critera results
  58. Re: Using multiple Lookup Functions
  59. add pass and fails
  60. Transpose Cell Contents
  61. Date / month / year
  62. Searching the formula (not the value) for a text string
  63. Re: Testing the case of text in a cell
  64. Calculate After hours
  65. Conditional Formatting Amendment
  66. Pivot Table with Data Model Connection - getpivotdata reference issue
  67. Formula to answer YES or No
  68. How can i put text in a cell depending on colour
  69. Help With VLOOKUP
  70. Re: Using =SUM...just can't figure this simple thing out...
  71. COUNTIFS ?
  72. Re: how to copy and paste value from one sheet to another
  73. Re: Lookup or search using the * character
  74. Re: List items based on the count given
  75. copying_data_using_FillHandle
  76. time_report_date-wise_employee-wise
  77. Problem formatting dates from CSV file
  78. Hide columns based on row values
  79. Created invoices in Excel - not working in Drive
  80. Pivot Table Data Aggregation
  81. Re: Cells not updated automatically
  82. Re: IF Statement on multiple levels
  83. Re: IF Statement on multiple levels
  84. how to do data validation in excel
  85. VanillaSoft Changes
  86. Re: Excel is too complicated for me
  87. Payment calculation
  88. Re: Match issue
  89. SUMIF Help
  90. Re: VLookup + IF
  91. SUMPRODUCT formula I think w/ wild card & number vs number as text
  92. Subtracting time...again
  93. Re: Adding cells until they are greater than a lookup cell and returning a value
  94. Re: Excel is too complicated for me
  95. Re: Excel is too complicated for me
  96. How to get largest date from a Vlookup
  97. Re: Sumif apllying to all sheets in workbook
  98. Returning 1 of 4 values if conditions are met
  99. Re: Sumif apllying to all sheets in workbook
  100. Function in Excel to count and list number of entries of text valuesin a row.
  101. Excel Average dates help
  102. Expanding Date Formula
  103. Need to convert an array of numbers to two columns in excel
  104. PLS HELP ME TO SOLVE THIS PROBLEM
  105. DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET
  106. need help on either doing a loop and counting specific values orusing subtotal function
  107. work hours with different hour prices
  108. Re: Getting a formula to reflect added columns
  109. using the =page! feature to transpose a row to column
  110. Payout based on hours rate and designation
  111. Simple nested if and statement
  112. Finding location (or start cell) of highest consecutive values
  113. Multiple arguments
  114. IRR of McDonalds expansion plan
  115. Finding NROI - no return on investment and RONI - return on noinvestment in Excel
  116. Wotksheets
  117. SUMIF between 2 dates
  118. SUMIF between date range
  119. Re: State Tax Business Calculations Help
  120. Pasting a range to a single cell
  121. Excel: counting times and dates during non-traditional hours
  122. Re: Formula not working properly
  123. Re: Carry over YTD balance to next worksheet
  124. Merging cells and formats
  125. IF formula
  126. Avoiding auxiliary cells
  127. add hyperlink using sheet names and cells(i,j)
  128. Time Sum in Excel
  129. IF function says too many nested
  130. Formula to multiply numbers intervals
  131. Re: XIRR vs. IRR Function
  132. Syncing between source worksheet and dependent worksheets
  133. How to update data entry to a linked worksheet and then return thenew value back to a master worksheet?
  134. Sort Question
  135. countifs Function not giving desired result with date criteria
  136. Need a ) somewhere in ISERROR formula but don't know where to put it
  137. Depedent Dropdown and INDIRECT($P$8) with a twist
  138. Re: XIRR vs. IRR Function
  139. calculating average handling time
  140. Re: Copy 2 cells to 1 cell
  141. Re: index function
  142. Conditional formatting dates
  143. Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell.
  144. Print on only one page
  145. Conditional Highlight
  146. Adding recognised Zeros
  147. Re: Filtering data
  148. lookup vaules which are not exist in a table
  149. Calculate End Date Using Start Date and No. of Days excluding specific days.
  150. Help with time function
  151. Re: need help with function
  152. Sum Values from different column
  153. Spacing in Column headers
  154. Re: XIRR vs. IRR Function
  155. Re: create pull down menu
  156. search function
  157. Close all without saving and exit without prompts
  158. #REF!
  159. Count columns that meet criterias
  160. can a cell be both input and output?
  161. Re: Help with a formula for a Time Sheet.
  162. Re: How can i find the max value within a time range ased on two cells
  163. Freeze Panes loss
  164. Re: How to refer to a criterie in a cell using excel sum.if function
  165. Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid?
  166. Re: Protected Sheet - Using Groups without a Macro
  167. Re: simple but can't make it, delete blank pages?!?!
  168. Re: Is it Possible?
  169. Re: Is it Possible?
  170. Re: Need formula for calculating time
  171. Re: Is it Possible?
  172. Creating a template that I can reproduce every month by keying ininformation from SAP
  173. I NEED HELP
  174. Re: Merge Name List Within Excel Spreadsheet
  175. Advanced Filter return blank
  176. Re: SUMPRODUCT(SUMIF(INDIRECT...returns #N/A
  177. Nested IF AND OR statement
  178. Change Color of cell
  179. excel time function
  180. I need Time Range to return Value
  181. vlookup or some other function that counts rows
  182. Event recognition.
  183. Drop Downs, Index Match or what?
  184. Restricting Cell entry to certain letters
  185. Sports summary sheet - think I put this in wrong place originally
  186. Sumproduct formula problem
  187. Conditional Formatting from a group
  188. Re: What does this mean'=ROUND(((F8/$C$4)*($C$4-E8)),)'
  189. Re: Data Validation - Custom question (multiple conditions)
  190. Re: Data Validation - Custom question (multiple conditions)
  191. Supress DIV/0
  192. Re: Need countifs forumla to analize in a time range
  193. Re: IF(OR statement not working
  194. Re: Finding Duplicate Rows & Highlighting them
  195. Re: Email?
  196. drop down box code
  197. Re: Finding Duplicate Rows & Highlighting them
  198. Extracting just the time portion
  199. NETWORKDAYS HELP
  200. Re: vlookup not working on calculated time
  201. Re: Month days over a time period
  202. rows height
  203. Count range of cells if not next to each other
  204. Sumproduct not working
  205. Re: converting number to dollar
  206. Re: converting number to dollar
  207. Re: Reconciliation... Again
  208. Excel help separating /
  209. Re: Help calculating scaled commissions please
  210. Re: Formula's to Find/Delete Duplicates from a list
  211. Re: Formula's to Find/Delete Duplicates from a list
  212. Tiered Pricing Formulae - is this possible?
  213. Re: Import multiple photos into excel
  214. Re: Weighted ranking of a series
  215. A find formul looking at two named ranges for two strings
  216. Re: Extracting data/using COUNTIFS
  217. IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows
  218. Determining if a number got hit before another
  219. Multiple Criteria, One Answer
  220. Re: Basic Statistics
  221. Re: IF AND Function Date Range Issues
  222. Re: IF AND Function Date Range Issues
  223. Peculiar default cell format
  224. Re: Need help with average/lookup formula
  225. Re: =substitute
  226. Re: =substitute
  227. Want To Shrink Formula
  228. Avoiding redundant calculations
  229. Trying to find additional ranges outside of min, max, and average
  230. Re: What Multiple functions do I need?
  231. Re: Round Down
  232. MROUND Help
  233. Re: COUNTIFS (the numbers in a column, when subtracted meet a certain criteria)
  234. Re: return multiple values when within range (greater than and less than)
  235. Re: return multiple values when within range (greater than and less than)
  236. Application.OnTime
  237. Re: Vlookup
  238. Re: trouble with (complicated) vlookup searching another workbook
  239. Re: trouble with (complicated) vlookup searching another workbook
  240. Link To File That No Longer Exists
  241. find out specific month and year
  242. Search function
  243. move worksheet to end of another workbook
  244. Match and delete rows on two different sheets from reference numbers
  245. SUM Char
  246. Calculating Average, Count, Min & Max against a range of Values
  247. What is the "--" (double dash) in MS Excel formula?
  248. Re: Excel formula help for calculating freight.
  249. Re: date mismatching
  250. Re: comparing sheet to sheet and adding value
  251. Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geometric Series
  252. Re: Using a Date and corresponding weekday to pull amounts
  253. Re: File upload
  254. Re: File upload
  255. excel copy and paste...
  256. Complex date VBA - insert a certain weekday
  257. Re: Unable to identify appropriate formula for very simple scenario
  258. use month in cell date to sum all relevant cells
  259. Help with a basic condition
  260. Delete rows that contain duplicates
  261. Use & with two formulas
  262. Re: Excel Formula Issue
  263. Re: Excel Formula Issue
  264. Re: Referencing cells in consecutive rows
  265. #DIV error
  266. Re: Userform to update rows of data
  267. Lookup formula of some sort
  268. Re: Progressive number with Excel then print a unique Pdf file
  269. Indirect formula errors if file is closed
  270. Re: Copy text into blank rows
  271. Re: How do I make #DIV/0! error message go away?
  272. hyperlink function fails in excel 2010
  273. Lower-Case Characters
  274. Re: Find Last instance colum A and return corresponding B Value
  275. Re: Simple Macros Table Count
  276. Re: Simple Macros Table Count
  277. Re: Conditional Formatting help (2003)
  278. Mapping strings to integers
  279. adding up time over & under a specified amount
  280. Re: Alternate Row Shading with Filter
  281. Convert multiple series into single series
  282. Re: Vlookup?
  283. Mapping integers to strings
  284. Re: Help With Formula for Posting
  285. Re: Force Distribution/ Force Ranking for Bell Curve
  286. comapering two sheets in excel 2010
  287. Re: 3 IFs argument in one formula
  288. Finding dynamic maxima
  289. Re: Pulling background color from master to other sheet
  290. How to record changing value of a cell
  291. Re: Dragging a formula down isn't working - where am I going wrong?
  292. Unhide column difficulty
  293. Re: Searching for text and returning text
  294. Re: IF Statement Table Help
  295. finding repeating numerical pattern using array functions?
  296. Re: Function or Sub to help with text string
  297. Re: Formula for calculating target hours against actual hours
  298. Re: Formula for calculating target hours against actual hours
  299. Questionnaire using Excel
  300. How do you Combine Two IF formulas
  301. Re: Macro to change referenced column to the next one
  302. if and replace function?
  303. Re: Advanced Drop-down Menu
  304. Re: Varying cell ranges in formulas according to number of cells with certain value
  305. Re: Automatically populate value of cell dependent on adajecent cell
  306. Re: Automatically populate value of cell dependent on adajecent cell
  307. Formula to add two spaces into a number stored as text
  308. Re: Generate series according to range and increment
  309. Re: Dynamic Ranges Adding Extra Row
  310. CONDITIONAL FORMATTING IN EXCEL 2010
  311. Re: Text Dates/times to d:hh:mm:ss
  312. Comparing two lists
  313. Re: Multiple VLOOKUP lookup values
  314. Removing #N/A from an "If/Then" statement
  315. Nameing a function
  316. Re: Converting a number into a cell reference
  317. Re: Converting a number into a cell reference
  318. Pulling From Multiple Sheet
  319. SUMIF with criteria "<>" & "="
  320. using duplicate function
  321. Re: Look up one value and return multiple corresponding values
  322. Re: Problems with conditional average
  323. Re: adding a forumla to cells with formula in them already
  324. Re: Help with an if then scenario
  325. Re: Excel PMT Function Help
  326. Re: Conditional Formatting
  327. Re: Conditional Formatting
  328. Re: Finding a Name
  329. Re: problem with time subtraction
  330. Re: Custom Autonumber with Prefix and Category Grouping
  331. Re: problem with time subtraction
  332. Re: Displaying Returns from another worksheet that change?
  333. weekday last year
  334. Curly Brackets
  335. Re: Counting multiple occcurrences between date range
  336. drag formula down from columns that go acros
  337. calculating volatility
  338. separating date and time
  339. Re: Multiple IF conditions
  340. Re: How do I combine 2 data sets using date?
  341. Re: linest internals
  342. Re: linest internals
  343. Re: linest internals
  344. Excel Formula question
  345. Re: Easter day formula.
  346. Re: Dividing after a long formula
  347. Re: Dividing after a long formula
  348. Re: Lower case date
  349. Re: If then formula with multiple Ifs
  350. Formula to tell day of week
  351. Re: 2 Formulas needed!!! :)
  352. Re: 2 Formulas needed!!! :)
  353. Re: Multiple column scroll
  354. Re: Multiple column scroll
  355. Help needed regarding calculating time
  356. Re: Can I disable the Save As Function?
  357. Sumproduct Help!
  358. Conditional Time Calculation
  359. Re: Sort by placement value from left to right & adding trailingzeros for short
  360. Re: Sort by placement value from left to right & adding trailingzeros for short
  361. Re: LOOKUP trouble
  362. Hlookup 3 criteria??
  363. Formatted cell column in drop down list
  364. Re: need help in creating a formula
  365. Re: CheckBox Control Copy and Paste
  366. Conditional formatting
  367. Macro to open CSV files
  368. SUM Q
  369. Hyperlinks with lookups
  370. Re: Combing a V Lookup result with ("00"&A2)*1 in same formula
  371. Financial Time Value of Money calculations
  372. Re: Needs help combining functions.
  373. Mick & Clause & Experts Please help me on this issue one more time
  374. VBA code for Sum and diff
  375. Gears
  376. Re: Delete Text in Multiple Cells
  377. Re: Count Word in long string
  378. Re: Delete Text in Multiple Cells
  379. Countifs bites again
  380. counting repeats.
  381. Re: Getting sum of values in another sheet while using condition
  382. Re: Help with lots of formulas
  383. INDEX return multiple columns
  384. Sumproduct?
  385. Re: calculate average values for 100 records in the shortest way?
  386. Re: Excel Countif Function - Calculating Between Two Sets of Values
  387. Re: Identifying text in a string
  388. Re: Identifying text in a string
  389. Re: Cell Auto Lock After Entering
  390. Changing Pivot Table Value Field Labels with VBA
  391. Combining an IF with another formula
  392. Calculate elapsed time excluding specific timeframe
  393. Absolute References and worksheets
  394. Re: Using a vlookup to search multiple criteria for one result?
  395. Re: Using a vlookup to search multiple criteria for one result?
  396. Re: Returning a value from a range
  397. Proprietary text on popup buttons
  398. Ms Excel Multiple Logical Test Function
  399. Re: I need a lot of help with MS Excel 2010
  400. Re: Multiple Columns in Sum Range using SUMIFS
  401. Numerals conversion
  402. workbook opens to the same sheet every time not the one it was saved as?
  403. Get percentage of whole
  404. New group but no Star to click...?
  405. Vlookup to reference offset
  406. Re: Problem using IF statement with dates as part of the formula
  407. Re: Problem using IF statement with dates as part of the formula
  408. Ttest across multiple worksheets
  409. Re: Excel help needed: Skipping cell without skipping cell reference
  410. Dragging a formula in a column
  411. Re: Excel 2010 Conditional Formatting
  412. Re: If Function
  413. Excel 2010 If Then logic - with time
  414. Function for summing or counting cells based on a specified fill color
  415. Go To a Named Range (2nd posting)
  416. Auto Change Formulas - Please Help.
  417. Conditional Formatting
  418. Re: help to remove space before the data
  419. Limit to MOD function
  420. Re: Time Calculation
  421. check value in cell
  422. Re: help to remove space before the data
  423. Re: help to remove space before the data
  424. Re: Index/Match Functions to Return Concatenated Response
  425. Re: Help with IF Function for times.
  426. Re: Help with IF Function for times.
  427. using mid find to either extract a number with 2 decimals or excludeFROM A STRING
  428. Excel check value i cell
  429. LINEST multiple known_x's separated arrays
  430. Re: Counting unique instances of a text string
  431. Re: Inequalities Function
  432. Re: Inequalities Function
  433. Can UDF return a customized hyperlink?
  434. Re: Excel Function Help
  435. Re: Why is excel rounding my numbers in VBA?
  436. Re: Why is excel rounding my numbers in VBA?
  437. Re: Divide a # into 3 #'s rounded to a whole #
  438. somewhat complex if statement help PLEASE!!!!
  439. Re: Divide a # into 3 #'s rounded to a whole #
  440. How Do I Avoid #REF! In Formulas?
  441. Re: Define a Range based on Cell Values
  442. Re: text to number graph
  443. Re: Variable interest rate loan calculations- PLEASE HELP!!!
  444. SUMIF "value if false" not working
  445. Data Validation - Complex Q
  446. Re: Looking up other sheet for value X depnding on sheet Y and Z colums
  447. If - Then Fields
  448. vlookup formatting problem
  449. product code a value
  450. Go To a Named Range
  451. lookup two different variables
  452. Re: Show value from one cell in another cell if today falls between a date range
  453. Re: Show value from one cell in another cell if today falls between adate range
  454. Re: Elementary SUMPRODUCT Question
  455. Re: Formula to predict future data
  456. Length cutting optimizer
  457. Calculating weighted average of Percent Change
  458. Re: Autosize Merged Cell
  459. Re: Sum Function has small remainder
  460. Generating a cut list
  461. Re: Auto populate date VBA code
  462. Re: =sum with a filter
  463. Rounding cents
  464. Index Match on Columns and Rows
  465. Re: Sumproduct giving #Value error
  466. Re: Sorting problem. My header rom is getting sorted with the rest.
  467. Re: Concatenate cells with line breaks in them
  468. Re: Year End totals
  469. Re: Rolling 12 month
  470. Re: Recurring Items in Spreadsheets
  471. Copying formulas across columns
  472. Re: Concatenate cells with line breaks in them
  473. Numbers in word
  474. Re: Rolling 12 month
  475. How Do I Find Different Values In A String?
  476. Line chart based on 3 columns
  477. complex sort search and replace macro
  478. Re: sumproduct
  479. Re: Can XIRR Work on Dates That Move Backwards in Time?
  480. Re: Can XIRR Work on Dates That Move Backwards in Time?
  481. Yes or blank, depending if value equals or exceeds value found inVLookup table.
  482. CountIf with And
  483. Re: sumproduct by year
  484. Percentage Increase
  485. Re: Help with a running total on multiple sheets
  486. Re: Vlookup doesn't work: results are wrong
  487. Macro to concatenate with previous bold cell
  488. How can I count deviations between two rows?
  489. multiple SUMIF help/advice
  490. Formula help needed please
  491. Re: Control F
  492. Find partial text and retrun value in corresponding column
  493. Re: Smoothing Data in Columsns in Excel 2012
  494. Copying a cell value to another sheet by using If statement
  495. TIME CALCULATION
  496. Re: Comparing MONTH and YEAR inside Formula ??
  497. Re: IF validation for time totaling
  498. Re: Drop Down List Dependant Formula
  499. Re: YTD SUMIF based on current date
  500. Testing a cell value for a specific weekday.
  501. How to ignore a column of numbers in Grand Total for rows
  502. COMPARING TWO COLUMNS AND DISPLAYING MSGBOX
  503. Re: How to calculate time percentage of number of parts being pick in a timeframe
  504. Copy columns, but not hidden ones
  505. Can I add a range and then divide that sum by a specific value?
  506. VLOOKUP, a table with text and numerics
  507. Re: Lookup in multiple & separate cells
  508. sum character
  509. Re: If value between 2 numbers
  510. Re: If value between 2 numbers
  511. How to reset excel worksheet form lilstbox and combo box
  512. Re: Multiplying a Number Found in an Alphanumeric String
  513. count not-overlapping days in a "Table" with Beginning and EndingsDates Specified
  514. Re: Antilog
  515. Re: excel formulas
  516. 2 dimensional date sort
  517. Calculate total by row number
  518. Re: Match/Index/Sum function with date range
  519. Re: Calendar Logic: Recurring Dates
  520. Learning arrays.
  521. Countifs with different restrictions
  522. Re: Index and match if field contains specific text in it
  523. Re: *Issue* Concatenate dates in a large range of cells in a row.
  524. Re: *Issue* Concatenate dates in a large range of cells in a row.
  525. How do I assign "Apple" to a cell reference in this evaluate code?
  526. Need help writing VBA module
  527. NumberFormat for small non-zero numbers?
  528. NumberFormat instead of an IF
  529. Re: Replace data to right of string problem
  530. Re: Replace data to right of string problem
  531. date & Time
  532. COUNTING THE SAME VALUES IN A SHEET
  533. Protect and Edit Object
  534. sorting noncontiguous data with exceptions
  535. Re: Matching two columns of data
  536. Re: Matching two columns of data
  537. Re: Simplifying multiple IF statements?
  538. Re: return a value depending on two previous values
  539. Vlookup and return sheet name also
  540. Re: Bitwise Functions?
  541. Re: Identifying common data between 2 cells
  542. Re: Multiple VLOOKUP in an IF statement
  543. Re: Evaluate Multiple Cells for any Value
  544. Re: Multiple VLOOKUP in an IF statement
  545. Re: Need help finding a substring in a array of strings.
  546. copying column multiple times
  547. Re: Validation of cell based on Drop down list
  548. Return Column Header from an Index/array, finding Large with a userinput date
  549. Re: Need formulas for searching for a value in a table and returning row/column name
  550. Re: Using IF, AND and OR functions together
  551. Re: Need help calculating probabilities
  552. Re: Month Calculation
  553. Re: Search Text and Add a Blank Line
  554. Re: Month Calculation
  555. Re: Pls Help - blank cell/formula issue
  556. Re: Help. Trying to do the opposite of VLOOKUP
  557. names dates & amounts stated multiple times in document
  558. Re: Help on the Sumif Function
  559. Re: Excel Template required for Daily managing daily income andexpense at Mobile shop
  560. Remove punctuation mark, Split cells & average accross column
  561. Re: Median Formula not working properly
  562. Help Needed : how do i compute this?
  563. Re: Copy values for every nth cell
  564. Re: Date reformatting question
  565. Countif with two criteria
  566. Re: Date reformatting question
  567. Re: Date reformatting question
  568. Re: Vlookup
  569. Re: Copy values for every nth cell
  570. Calculating Future Value
  571. LOOKUP function??
  572. Re: Generate 1 or 0 in xls with input probability
  573. Re: Simple COUNTIF function help
  574. Re: Help Needed! Using complex IF function
  575. Convert Number to Text for Index/Match
  576. Re: Help needed: Minimum value based upon either/or criteria
  577. Re: Help needed: Minimum value based upon either/or criteria
  578. Sort column beginning with blank?
  579. INDEX MATCH SMALL
  580. Re: Name break into half and reverse to upper case
  581. Re: help w indirect and index,match
  582. Re: Please Help! Delete all cells in range except "1934 - 1934"
  583. Re: how to count rows if 2 columns partially match
  584. Extract the 2 Lowest %
  585. Calculating time for 3rd shift
  586. Computer Properties
  587. Club Accounts
  588. Re: Extract Alphabets and Numbers from a Cell
  589. Re: Possible Sumproduct with Or Function
  590. preserving zeros in spreadsheet
  591. Re: coding descriptors
  592. Re: Extract Alphabets and Numbers from a Cell
  593. Re: Lookup Value From Sheet2
  594. range definition by cells numbers
  595. Logical formatting for multiple values
  596. Preserving trailing zeros for a fixed width file
  597. Re: Multiple Criteria Lookup
  598. Re: Conditional Formatting Formula
  599. Re: Conditional Formatting Formula
  600. VLOOKUP return cell location and hyperlink
  601. Re: Formulas won't function
  602. Re: Automatically sort alphabetically ignoring header
  603. Re: need help with Formula
  604. Re: Simple (maybe) percentage forumla
  605. Re: percentage calculation
  606. #value error for sumproduct using RIGHT cmd
  607. Re: percentage calculation
  608. Re: Series command grayed out
  609. Convert number to text as displayed
  610. Extract first and last login time for each day only
  611. Add time when working 3rd shift
  612. Re: help!
  613. Re: Nested If Statement help
  614. Re: Detailed Countdown
  615. Excel 2010,Voice Win7
  616. Re: Counting cells with SUMPRODUCT and conditionals...?
  617. Re: help!
  618. Distribution of capital contribution
  619. Re: VLookup sum multiple matches
  620. Re: Vlookup Returning Zero For Every Cell
  621. Re: Vlookup a subtotal
  622. Re: Display next available number
  623. Re: Vlookup Returning Zero For Every Cell
  624. Show latest date
  625. Re: Search for string based on two columns
  626. Re: Help with complex IF statement
  627. Re: Return a value if a range of cells contain text
  628. Re: Search a range for instances of a text string, return neighboringcell values each ti
  629. Extract Date formula Only
  630. Re: Complex Lookups
  631. Re: Complex Lookups
  632. Re: Problem with formula for finding last greater than/less thanor equal to value
  633. Re: Unable to nest my IF statements properly
  634. Re: Problem with formula for finding last greater than/less than orequal to value
  635. Calculating aggregate donation sums for a list of names
  636. Re: Unable to nest my IF statements properly
  637. Return the value from one range that does not exist in another
  638. Re: Complex Lookups
  639. Re: Using IF and VLOOKUP for range of cells
  640. Re: Using IF and VLOOKUP for range of cells
  641. Re: Using IF and VLOOKUP for range of cells
  642. Re: Using IF and VLOOKUP for range of cells
  643. Re: display Column Header based on cell value in a range
  644. Wage Calculator Q
  645. Re: Calculating days spent to complete a task
  646. Re: Deriving several lists from a master list
  647. Re: Deriving several lists from a master list
  648. Re: Sum of values in column A based on 0/1 of column B
  649. Re: How to calculate difference between two date & time along withworking hours and days
  650. Re: How to calculate difference between two date & time along with working hours and days
  651. Display data for rows where cell consists of whole number
  652. Re: Trying to count based on multiple criteria & cell comparisons
  653. Re: Trying to count based on multiple criteria & cell comparisons
  654. Compare 2 lists and return value
  655. Help! Is this possible
  656. Excel time leading 1st ZERO
  657. Solve for a number (x)
  658. Sorting by frequency
  659. Re: Urgent help with Excel formula. Please please help
  660. Re: Findiing highest and lowest in rows and columns
  661. Re: Findiing highest and lowest in rows and columns
  662. Re: Making data in appear in one worksheet from another
  663. Re: Conditional concatenating!!!
  664. Command Button to create a folder
  665. Re: Joining VLookups with line breaks but ignoring blanks
  666. conditional formatting update issue
  667. Re: Compressing multiple functions across an array into one cell
  668. Re: Multiple Nested If Function
  669. Re: Multiple Nested If Function
  670. Re: Multiple Nested If Function
  671. Re: One lookup option
  672. Re: Function to Combine Names and Middle Initital In Various Formats
  673. putting number against certain words formula
  674. Re: Countif year = help needed
  675. Solver Compiler issue
  676. Re: Conditional Formatting discarding zeros
  677. Re: Sum of Variable Cells in a fixed Row
  678. Re: Sum of Variable Cells in a fixed Row
  679. Re: Help in Median of a quartile
  680. Re: Index Match function for lookup HELP
  681. Re: Index Match function for lookup HELP
  682. Re: How do I convert cubic feet to cubic meters?
  683. Re: VLOOKUP Help
  684. Re: Lookup function to return highest value
  685. Re: Totaling Categories - Monthly and YTD
  686. Re: consolidation data in one row
  687. Re: consolidation data in one row
  688. Re: Excel Template required for Daily managing daily income andexpense at Mobile shop
  689. Re: 12 columns by 8 rows to one row
  690. Array formula lock-up
  691. Re: Use an "OR" around nested IF statements
  692. Re: Use an "OR" around nested IF statements
  693. Re: calulation
  694. Re: Help with count/sumif
  695. Run-time error 1004: Unable to set the left property of the OLEObject class
  696. is there a way to cut and paste text into excel with each paragraphimporting to it's own cell / row?
  697. Conditional Formatting in Excel when data changes
  698. Lookup Across Multiple Rows / Columns
  699. Don't know if it's possible, but...
  700. dynamic data copying between worksheets
  701. COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION
  702. Re: Over time?
  703. Re: Randomize numbers
  704. Re: match some character in b1 to c1 and display on d1
  705. How to Count Strike throughs
  706. Re: Looking up Duplicate values in table
  707. Re: combine three if functions
  708. Informal invite to "Excel Blackbelts"
  709. Re: Help with IF function
  710. Re: Remove numbers from text cells
  711. Re: Remove numbers from text cells
  712. Re: Help with IF function
  713. Help on randomly selecting cells to SUM
  714. Re: Formula Help on Interpolation
  715. FV when compounding occurs every 30 months
  716. Re: Get sum of values in a cell based on unique values in another cell
  717. Re: sumif issues
  718. Re: the specified form cannot be entered because it uses more levelsof nesting
  719. Countif formula perhaps
  720. Re: SUMIF with broken range
  721. Re: If formula producing #VALUE Error
  722. Re: Comparing 2 columns from 2 different Worksheet and Returing Valueof a 3rd column
  723. Re: Match Array returning #NA, Works individually
  724. Re: Returning next item in list
  725. Re: Condtional Formatting or LOOKUP ?
  726. Sumif to multiple tabs
  727. Re: Highlighting duplicates on different sheets
  728. Re: Matching people to skills.
  729. Re: Counting Text
  730. Re: sumproduct
  731. Re: Have the SUMIF result (formula) on a separate sheet/tab
  732. Re: Blank until data is entered
  733. formula issues.
  734. countif and sumif
  735. Re: Help decipher this code PLEASE!!!
  736. Re: IF and IF and IF
  737. Re: Help decipher this code PLEASE!!!
  738. Re: Countifs with error #Value!
  739. Re: IF and IF and IF
  740. Re: Formula not being Friendly
  741. Re: freeze first colums and hide one colums
  742. How to extract separated text by many commas in Excel?
  743. Re: Calculated % completed by date
  744. Re: formula to work from data column
  745. Re: Date Format
  746. Re: Date Format
  747. Re: Date Format
  748. stock remaining..
  749. First row where a cell is zero
  750. Re: Enabling Macros message when NO macros in workbook