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