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