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