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