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