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