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