PDA

View Full Version : Microsoft Excel Worksheet Functions


Pages : [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160

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