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