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