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