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