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. Rank Formula
  2. Rank Formula
  3. Finding dates without attention to data formats
  4. Re: Drop down box w/contents of different worksheet? is this possible
  5. Re: Is there some kind of memory reference limit in excel?
  6. Re: Is there some kind of memory reference limit in excel?
  7. Re: Creating list from values that meet multiple criteria from other sheet
  8. If function across sheets prints value of cell
  9. Re: Counting instances of Specific column entry combinations
  10. Re: reduce data points and average?
  11. Re: reduce data points and average?
  12. Conditional Formatting for 6 month intervals (ignoring day and year)??
  13. Re: Pulling Multiple Vales From Multiple Cells & Displaying them in one cell.
  14. Multiple List Analysis
  15. Re: vlookup issue
  16. Re: How to Sort and Address
  17. Re: Forecast of Inventory - Explaination of Calcuations
  18. Re: Capitilize last word in cell
  19. Re: Spread values across fields
  20. credit intrest on intrest
  21. Re: Calculate duty payable
  22. Macro/Forumula to SUM values from Sheet that does not always exist
  23. Compare identifier columns from 2 sheets - remove rows that are dups
  24. display repeating row information in columns
  25. Re: rounding a number up to a certain ending digit
  26. Re: rounding a number up to a certain ending digit
  27. Re: Need Help With YIELDMAT
  28. Re: median array help
  29. Randbetween Range Problem
  30. Re: SumIf equation question
  31. Re: SumIf equation question
  32. Re: Excel macro for row selection
  33. Re: Excel macro for row selection
  34. If statement based on time ranges
  35. How to check if time falls between two ranges
  36. Re: If equation with a VLookUp
  37. Re: Data (group And Outline)
  38. Re: Using the IF and IFBLANK functions
  39. Re: Horizontal and Vertical lookup
  40. Re: VLookup Won't Copy down (#REF! error)
  41. Re: Combining two separate lists and creating new values
  42. Re: Help on multiple criteria for formula and return a date
  43. Re: Count if data falls within a range AND that has a certain criteria
  44. Re: End Date/Time adding business hours
  45. Allocate an income payment over a date range (tax years)
  46. Re: Need to know give matrixes a name...
  47. Function to establish mortgage bond size.
  48. I need to add spaces to the beginning of my texts which are numbers
  49. Re: Data Validation - Custom question (multiple conditions)
  50. Re: search cell for specific text.
  51. Re: Change the colour of a cell if another named cell is blank
  52. Re: Change the colour of a cell if another named cell is blank
  53. Re: Formula for multiple rows of same value...
  54. Re: Formula for multiple rows of same value...
  55. Re: Conditinal formatting blank output cell
  56. Re: Conditional formatting code
  57. Re: attempting complicated IF comparison with end goal easy for future users
  58. Dsum Help
  59. Re: Excel Formula or VBA Code
  60. Re: check if or not time lies between a time interval
  61. Re: Longtitude and Latitude Question
  62. matching columns to find differences.
  63. Percentile on Aggregate data with multiple criteria
  64. Re: INDIRET fill
  65. Conversions of Decimal Feet to Decimal Inches - Formula??
  66. Re: INDIRET fill
  67. Re: Formula for looking up and copying from another worksheet?
  68. Re: COUNT IF with unconditional AND on cell dates
  69. Re: How do I unhide a row when ENTER is pressed in a certain cell?
  70. Re: How do I unhide a row when ENTER is pressed in a certain cell?
  71. Re: how to link horizontal data to vertical cells in a new sheet
  72. Naming cells
  73. Data validation help
  74. Function to establish the mortgage bond based on a monthly payment
  75. Changing cell content on n auto-filtered column
  76. Re: Adding Periods at Specified intervals
  77. Re: Adding Periods at Specified intervals
  78. #REF issue with links
  79. Dropboxes and VBA code in Excel 2007
  80. Re: Yield to Maturity
  81. Re: Yield to Maturity
  82. Adding days to a date - changed in Excel 2010
  83. Re: Populating entire rows of data from a master sheet?
  84. Re: Inserting a string in a cell reference
  85. Re: Inserting a string in a cell reference
  86. countif
  87. countif
  88. Data Validation
  89. Re: Excel import from PeopleSoft; formulas dont work
  90. Re: Determine Resource Allocations by evaluating available time andrequired time.
  91. Re: If, And Or
  92. Match function: error due to format?
  93. Re: Conditional Formatting
  94. Re: error message "#VALUE!" due to blank cells
  95. Re: error message "#VALUE!" due to blank cells
  96. Re: error message "#VALUE!" due to blank cells
  97. Auto Filter Multiple Criteria
  98. Re: Conditional Formatting Conundrum
  99. can I make an equation to count how many cells are filled below acertain cell?
  100. Re: Cutting out a process
  101. Re: Wildcard issue for Index/Match Function when searching numbers
  102. Re: Select minimum with duplicate values to return column headings
  103. Triple IF?
  104. Re: Change row colors based on a cell value
  105. Re: IF Function not working as I want
  106. Re: Balance Depreciation - how many years?
  107. Re: incrementing batches of numbers
  108. Search and Combine Rows
  109. Re: VLOOKUP FOR COMPANY AND EMPLOYEE
  110. Re: Excel VBA Formula Help
  111. Re: Excel VBA Formula Help
  112. Re: Combine Rows Based on Capitalization
  113. Re: Excel VBA Formula Help
  114. Re: Combine Rows Based on Capitalization
  115. Re: Combine Rows Based on Capitalization
  116. Re: Combine Rows Based on Capitalization
  117. Re: Combine text under different condition
  118. Re: Combine Rows Based on Capitalization
  119. Pivot table grouping help
  120. Re: Combine Rows Based on Capitalization
  121. ranking question
  122. Re: Combine Rows Based on Capitalization
  123. Re: Transpose multiple Columns to rows
  124. Re: Transpose multiple Columns to rows
  125. Re: Lookup matching 3 values to 3 others and returning a value
  126. Please Help for IF Function
  127. Please Help for IF Function
  128. Create an array of separate cells
  129. CONCATENATE & LOOKUP Functions
  130. Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function
  131. Re: Excel automatically goes into 'Group' mode while toggling between worksheets
  132. SUMPRODUCT - Multiple Criteria
  133. Re: list box item
  134. Flat interest rate Vs Reducing interest Rate
  135. resettable, over-ridable, default cell values
  136. Select rows which satisfy 2 criteria
  137. Re: Unique Records in Column
  138. Re: Transpose multiple Columns to rows
  139. Re: Transpose multiple Columns to rows
  140. Re: If Function Greater than Less Than
  141. Re: Counting unique values based on 2 columns
  142. Re: Auto Populate Sheets by Employer
  143. Re: Command Button- Assign Macro & Sheet Protection problem
  144. conditional validation
  145. Vlookup/Hlookup confusion
  146. Hlookup/Vlookup with duplicate datas
  147. Re: How many rows are coloured
  148. Can't Copy and Paste in Excel 2003
  149. Re: how to copy the contents into another cell?
  150. Re: CONVERSION OF PA STATE PLANE COORDINATE SYSTEM TO LATITUDE & LONGITUDE
  151. Re: SUMPRODUCT formaula not working
  152. Re: Highlighting multiple triggers
  153. Re: Changing the color of a cell in excel based on due date
  154. If function help
  155. Reference to a Defined Name in another Workbook
  156. Re: Conditional Formating based on method of input
  157. Re: Date Reminder
  158. Re: Formula
  159. vba delete
  160. Re: Formula
  161. Omit empty cells?
  162. nested IF without repeating the condition?
  163. Conditionally Format Particular Dates
  164. Help with Address(), Indirect(), Offset
  165. Re: How to summarize copied data
  166. Re: How to summarize copied data
  167. Re: HLOOKUP & VLOOKUP Combinded
  168. Re: Count Blank Cells with Conditions
  169. Highlight Highest Amount
  170. Re: Auto adjustment of functions
  171. Re: HLOOKUP & VLOOKUP Combinded
  172. Re: Using text in VB Code
  173. Re: Using text in VB Code
  174. Calculations of Cell after Autofiltering
  175. Match function
  176. Re: Standardizing Addresses Help
  177. Re: Standardizing Addresses Help
  178. random of 4 names
  179. countif
  180. Worksheet Names using Macros
  181. Empty cell warning
  182. Empty cell warning
  183. Re: Function Error?
  184. Find last date of sold stock and sold price.
  185. Histogram/Frecuency for Multiple Response Questions
  186. Re: calculate last 4 data points in a column (with sometimes blank rows)
  187. Re: Login User Form
  188. Time function problem
  189. Re: Average with criteria for adjacent cells ?
  190. Re: downloading a template into a new sheet of an existing workbook
  191. Re: Not having luck with any examples of averaging...
  192. Complex formula to count cells
  193. Re: Hyperlink problems
  194. Re: Help with conditional formatting in Excel 2010
  195. Re: Help - need to consolidate workbooks
  196. Re: Help - need to consolidate workbooks
  197. Re: If then Statement for Excel Columns
  198. Re: Date Intervals
  199. Editing an "IF" function across a worksheet/excel file
  200. Complex Median Formula
  201. Sumproduct Problem
  202. Re: Help with SUMIFS
  203. Enable Slicer Data Refresh in Locked S/S
  204. Re: Function Problem
  205. Re: Split Data Series (Lookup, Index, Match references)
  206. Re: Applying macro to mulitple worksheets?
  207. Re: Many youths would appreciate your help...
  208. Re: Creating unique keys
  209. Re: Help with SUMIFS
  210. Lookup against concatenated source value
  211. Re: Function Problem
  212. Re: runtime error 9 subscript out of range
  213. Re: Keep original cell formatting when using transpose array formula
  214. sunrise/sunset calculation
  215. sunrise/sunset calculation
  216. sunrise/sunset calculation
  217. Re: Counting one Character as a String
  218. Special string convertion to date and time
  219. Help with Excel 2007 COUNTIFS!
  220. Re: Call a function within Excel VBA --- need help can't figure out syntax correctly
  221. Running Total Question
  222. Hide/Unhide with cell double click
  223. Formula Question
  224. Re: Losing Data From Formulas When Cell Variable Changes
  225. Re: Progressive pricing
  226. Get Column Header if Condition is Met
  227. Re: Sumif or vlookup
  228. Dynamically sized table compiled from unsorted rows with blank entries
  229. Average If
  230. function showing false result when it is not
  231. Re: Progressive pricing
  232. Re: Progressive pricing
  233. Cros referencing Data on Excel
  234. Sliding Scale
  235. Re: formula to disperse data to several worksheets
  236. hi al
  237. Re: using excel as a markbook
  238. Re: How to create a pivot table in a new worksheet by recording amacro
  239. IF Function -- Return Null Value Help
  240. formula displays as a formula, not as its result
  241. Large Data File Consolidation...
  242. Screening through days of the week including time
  243. VLOOKUP source values are a formula result. Getting #N/A
  244. Need VB formula to exit workbook
  245. Re: COUNTIF - help please
  246. Bugs in vlookup?
  247. Cross referencing data in Excel
  248. Re: COUNTIF - help please
  249. Re: COUNTIF - help please
  250. 2 criteria
  251. Re: Creating Palette Labels at work
  252. Need VB formula to execute form
  253. Index and Match
  254. Re: may need programming?
  255. Re: Highlighting duplicates across many sheets
  256. Re: Highlighting duplicates across many sheets
  257. Re: If statement checking list
  258. Re: If statement checking list
  259. pivot table help
  260. Re: Help with a formula (calculating totals based on individual percentages
  261. Re: Present Value Uneven Cashflows
  262. What my chart to exclude 0 data...
  263. Re: Present Value Uneven Cashflows
  264. Re: Help with a formula (calculating totals based on individual percentages
  265. Re: Tricky one
  266. help with formula for last input in column
  267. Re: SUMPRODUCT help needed
  268. Re: SUMPRODUCT help needed
  269. N/A in pivot table become 0
  270. Re: Extracting Data from Tables
  271. Formula Help
  272. open file with multiple types of delimiters
  273. Re: Lookup cell next to data
  274. Re: Show time as a bar graph
  275. can you make a cell blink?
  276. Formulas Still Not Working
  277. ANOTHER URGENT QUESTION - Sums and Ifs
  278. URGENT HELP - SUM FORMULA
  279. Re: How to save random numbers?
  280. Re: Calculating what staff worked on which product
  281. Formula Based on Values in Named Range Q
  282. Re: copy cell range in other sheet
  283. Re: Copy Cell in other sheet with condition
  284. Need VB formula to edit and save data
  285. Re: copy cell by command button
  286. Compose A Full Excel Date From Parts Elsewhere
  287. Re: Copy Cell in other sheet with condition
  288. Dates
  289. Re: Copy Cell in other sheet
  290. Modify A Formula
  291. CTRL + H doesn't go to A1
  292. Need VB formula to retrieve data
  293. Re: VLOOK UP
  294. row height
  295. Re: 1st numer in string
  296. Display relevant information from excel sheet into form
  297. I have a column of numbers, some positive and some negative.
  298. Macro or Formula Needed
  299. Calculate average in intervals
  300. grouping dates in a pivot table
  301. How to find max value in a range then give value in cell 2 rows above that max
  302. Excel and Visual Basic
  303. IF Function error #VALUE
  304. Conditional Formatting based on active Named Range; IF Function to VBA
  305. Cell Range Split into Multiple Cells
  306. What's the best way to set this formula up?
  307. Find text in N columns and one Row
  308. How to custom format a date
  309. Re: Ignoring text in cell formulas
  310. Re: Ignoring text in cell formulas
  311. Which function will work best? And how do I set it up?
  312. Re: Shared workbook error message
  313. Re: Average of cells in a column if the top cell is a color
  314. Re: Average of cells in a column if the top cell is a color
  315. Re: Ignoring text in cell formulas
  316. I do statistical work. Recording numbers in notes,
  317. I do statistical work. Recording numbers in notes,
  318. help with Sum in between dates
  319. Largest value in column A based on conditions in columns B and C
  320. Formula/Macro Question
  321. Excel Facetime Measurement
  322. SUMIF (or SUMIFS): Can I have multiple EITHER OR criteria
  323. hot to calculate peaks of an "irregular" sine wave
  324. Create A Button and Assign A Macro To It
  325. find and replace numeric strings in larger text strings
  326. Formula Error When Sorting
  327. Copy cells in Excel
  328. Returning a YES or NO if there is a value on a range of cells
  329. First, Last occurance of date in column
  330. Min Max Question
  331. Question about Combin function
  332. Conditional sum, when condition has multiple values
  333. Constructing Range Name calls with Concatenate
  334. How do I have a cell value define a dynamic named range?
  335. Global Change Of Formula Value
  336. need help extracting data from cell....
  337. Formula Using Vlookup & Match
  338. Excel Macro or Formula Question
  339. Re: Excel not totaling right amount
  340. Re: Excel not totaling right amount
  341. Re: Excel Currancy Decimals
  342. Re: Decimals on cents
  343. Re: Excel Currancy Decimals
  344. I have a column of numbers, all are positive.
  345. Re: Excel Currancy Decimals
  346. Conditional Formatting Formula
  347. Adding values for all rows in a range
  348. Highlight row
  349. Vlookup for repitative data
  350. Vlookup error
  351. Vlookup error
  352. I would like a formula that
  353. return proper match from three columns
  354. Lookup Formula
  355. Mixed numerical and textual data
  356. Cell format
  357. Re: Need Help With String Concatenation
  358. Re: Need Help With String Concatenation
  359. Lookup across a Range
  360. Listing unique values, frequency, and maintaining list order integrity
  361. Icon sets fomatting error
  362. SUMIFS, one criteria range, multiple criteria
  363. Re: List/Combo Box Issues
  364. Excel Split column data
  365. Use array/braces **WITHIN** a formula?
  366. eliminate negative value from normal random number distribution
  367. How to use If and And function in a worksheet
  368. code to unhide tabs based on cell contents
  369. divide numbers up for a paper form
  370. Possible to refer to a sheet's object name ?
  371. Does the order of worksheets matter ?
  372. Count values, excluding duplicates and specific values
  373. setting up a schedule in Excel
  374. Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS
  375. Formula for function/argument "exclude".
  376. Formula help
  377. Replace a fixed number with a variable via popup
  378. Split words in a cell
  379. SumByColor & #NAME?
  380. Skipping weekends during a count
  381. How to get range names to Apply across multiple tabs
  382. Re: Changing the color of rows - conditional formatting
  383. Auto worksheet name?
  384. Auto worksheet name?
  385. The effects of time on value
  386. activity
  387. GST
  388. Sort, simplify, duplicate rows and probably a few more steps!
  389. Activity
  390. formatting a percentage in a cell
  391. formatting as percentage
  392. monthly consolidation in separate worksheet
  393. excel "IF" function... is this possible ?
  394. vlookup or index?
  395. Copy summary data to new sheet
  396. Select 3/4 digit numbers from text
  397. Formula Problem
  398. Median If in Excel not working
  399. Using COUNTIF with criteria in an adjacent column?
  400. Convert room dimensions 13' 8" X 9' 2" to square feet
  401. Re: MATH COMPUTAION
  402. Sequencial page numbering of multiple tabs
  403. removing zeroes almost perfect
  404. counting absentees
  405. Row references
  406. Searching for text within formula
  407. Sum of squares if condition
  408. Converting time to Minutes
  409. help me please(macro codes)
  410. Changing function name in formula
  411. If cell value is between XX and XL, display B
  412. SUMPRODUCT query
  413. Why doesn't this work ?
  414. Find in a sentence diferent word
  415. Stop Macro running when I save the workbook
  416. Data validation for specific text, for example "blue"?
  417. Re: Formula Help PLease
  418. Re: Formula Help PLease
  419. Two sets of XYZ data columns comparison
  420. Taking relevant information to sheet 2
  421. Help With Formula For Cell Addresses
  422. Re: Formula Help PLease
  423. Nesting SUBTOTAL with SUMPRODUCT?
  424. VBA Question (Again)
  425. Stopping one sheet from calculating
  426. All sheets in workbook have same rows to repeat at top
  427. Re: Multiple Creteria Lookup(Between Dates)
  428. Re: Multiple Creteria Lookup(Between Dates)
  429. Combining Excel Files
  430. use cell address
  431. Re: Filter problem
  432. VBA Question
  433. custom data validation on cells with data validation values
  434. Help With Searching For Strings In Part Numbers
  435. hello i wanna help
  436. Match and Vlookup issue
  437. Add Time Q
  438. INDIRECT with Sheet Level Defined Name
  439. Formatting a two-variable data table
  440. Noncontiguous cell range
  441. Re: Any Help Appreciated
  442. Last workday
  443. Array Constants
  444. Convert Numbers to Words for UK format
  445. OR in SUMPRODUCT formula
  446. How does this formula work ?
  447. Problem with excel. Please Help!!
  448. Getting smallest number > 0 in an array constant
  449. Validation List
  450. Re: Vlookup problem
  451. Removing 2-3 characters at the end
  452. Removing 3-4 decimals
  453. Adsence account for just 250
  454. SMALL function to find X smallest number greater than Y
  455. SUMIFS with Trim
  456. Exclude worksheet from loop.
  457. Is there a way to change the color
  458. display date of today in cell X when number >0 in cell Y
  459. Has =TEXT(. . .,0) been applied?
  460. Formulas within list fail to update after sorting/filtering
  461. Problem with pivot tables
  462. Re: Bullet Points
  463. quick question on sumif
  464. User Defined Function Help
  465. SUMMING TOTALS BASING ON CHARATERS ENTERED IN CELLS OF ONE COLUMN
  466. SUMMING TOTAL BASED ON CHARATERS ENTERED IN CELLS
  467. Round Question
  468. text to column
  469. Pivot Table Help -filter with creation date
  470. Counting errors
  471. Formula help
  472. I need a help formula
  473. Converting from Decimal to Base-36 in Excel Formula
  474. Repeat formula for varying levels of data
  475. Baffeling IF statement
  476. Need a Macro
  477. Skill about VBA
  478. Fixing date of entry
  479. BOLD WORDS IN CONCATENATE FORMULA
  480. EXCEL time match
  481. data validation across multiple columns
  482. Developing invoices with transaction breakdown
  483. Using the IF and Sheets
  484. macro to call other macros
  485. Parent child relation between two rows in an excel sheet
  486. Query regarding any lookup function
  487. Conditional fomatting for cells containing a Comment
  488. How to truncate list of meaningful words greater than 15 chars tomeaningful words of 8 chars.
  489. VBA range selection question
  490. Re: Conditional format
  491. How to write an array to a range without looping
  492. compu-mania.co.cc
  493. function MATCH returns wrong value
  494. IRR formula: weird pattern
  495. COUNTIFs dates on a cloumn are within the last 30 days
  496. Indirectly us a Named Range
  497. Attendance tracker last 30 days
  498. Printing and scaling: why does Excel behave in such a way? PLZ HELP!!!
  499. Conditional Sum across WORKSHEET
  500. Excel 2007 Charts & Memory Leak??
  501. Copying a cell value from one page to another
  502. Vlookup with Dates
  503. pytanie o kopiowanie bez zmiany komórek w formule
  504. Re: Another Question
  505. COPY IF funcion???
  506. Less Excel more Math
  507. row totals in pivot table
  508. Re: Question - Please read
  509. Re: Question - Please read
  510. Turnover Report
  511. Serious Excel Challenge
  512. Want only rows with populated data
  513. Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted
  514. Is it possible to match a cell's contents from a list ?
  515. COUNTIF with 2 columns
  516. Excel - Commission using SumIF
  517. Modifying a complex date formual to count months
  518. Autofill from months
  519. How to sum x cells that are greater than zero on the right?
  520. Excel 2007 Chart Data Selection- Arrow Keys Frustration
  521. Need advice on my sumif formula (text ref.)
  522. Re: SUMIF
  523. Re: SUMIF
  524. Growth Rate for number series
  525. Parsing Question
  526. Problem with Formula
  527. Copy all text in a string prior to the last period...
  528. Extracting Data From The Right of a Cell
  529. error with countif formula on when adding linked spreadsheets
  530. Re: Finding position of last period in filename
  531. Recursive Functions...maybe
  532. Re: Finding position of last period in filename
  533. Inverse tangent in excel, please help!
  534. very complex IF function if not an alternative function of crossselection
  535. colour numbers
  536. I have a column of numbers, some positive, some negative.
  537. Countif
  538. Re: get a cell reference as a result of an If Function
  539. Consolidate two Data Sets for Making a Report
  540. Manipulating imported times
  541. Retrieve data based on 3 criteria
  542. Binary operator >> (?)
  543. Manipulating matrices of unknwon (a priori) size
  544. Image from URL
  545. Conditional formatting backwards compatibility question
  546. Dynamic CONCATENATE and LOOKUP
  547. Counting cells in a selectable date range
  548. need some beginner help with LOOKUP functions
  549. Dynamic 5-week date range & SUMPRODUCT formulas
  550. optimization
  551. Count
  552. Re: time window calculation
  553. Re: time window calculation
  554. How to reverse this formula?
  555. Protection
  556. Re: setting scale for graphs
  557. Need array formula to ignore hidden values
  558. How do I calculate age using a 12 digit social security number in MS Excel?
  559. Trying to add column headings to array formula
  560. Rounding Time to Nearest 5 Minutes
  561. How to show best and worst results over a range
  562. How do I exclude text???
  563. if and vlookup formula
  564. number to character and vice-versa
  565. Re: reconstitute date
  566. Re: reconstitute date
  567. Formula for showing Previous Year - Current Year
  568. Conditional formatting to highlight the closest value
  569. Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture
  570. Re: Conditional Formatting colums
  571. Re: Conditional Formatting colums
  572. [ask] Quartile and Frequency
  573. Need help with sorting and moving to worksheets
  574. NETWORKDAYS
  575. How to select all the cells with only ' in them
  576. Create unique list of names from list of duplicates and that arefound within another range
  577. Conditional Formatting
  578. I need my SMALL formula to ignore zero's
  579. Machine-readable passport calculations
  580. lookup values from certain text file.
  581. Summary of Unique item values
  582. Format numbers as "Number"
  583. Creating a UDF to convert ADDRESS function output as a reference
  584. vba dynamic
  585. Vlookup into 2 columns
  586. Need some help with a COUNTIF function
  587. Counting assistance
  588. Excel 2007 Paste Special Values Comment Disappears
  589. Re: Help with Autofill
  590. Re: Help with Autofill
  591. HELP
  592. Dynamic Named Range formula without using OFFSET function
  593. Append shortcut link to open a particular workbook TAB
  594. Auto sort help.
  595. Current Region in a formula
  596. Identify part number in list and tag it with characters from another list
  597. Re: Question on XIRR Usage
  598. Top 4 scores in excel
  599. Re: XIRR Function
  600. sorting problem?
  601. If , Mid or right functions or a combination thereoff.
  602. Use If & Mid or Right functions or combinations thereoff......
  603. Re: Trouble with Print Area
  604. Copy Data from Within same Workbook
  605. Top 4 scores in excel
  606. Re: Formula Suggestions/Help
  607. EXCEL FORMULA
  608. Need help in creating horizontal array using either macro or someformula
  609. grand totals in pivot table rows
  610. Help with worksheet function
  611. Re: HELP - I need some help with page numbering tabs
  612. Averaging a colume of values.
  613. Numbering a column of numbers.
  614. XL2007: I need a sumproduct formula that will transpose as I copyacross columns
  615. Hyperlinks
  616. convert date to Day of the Week
  617. Lookup and count all cells that fall between 2 dates
  618. Excel Lists
  619. Lookup multiple cell values and place contents in a single cell
  620. Array Formula for numbering similar nos (counting)
  621. matrix math in excel?
  622. Why is my tab key not working properly any more in Excel 2007?
  623. Adding days by using NETWORKDAYS 2007 formula
  624. Conditional Formatting with Icon Sets
  625. Re: Performance in year 2
  626. HyperLinks View
  627. Re: Performance in year 2
  628. Look Around Today at Online Personals Date for Free
  629. Force input & colour cells
  630. Problem with SUMIF Formula
  631. Set the Length of the Cell
  632. How to write XIRR formula on excel using different Year basis than 365.
  633. shading a cell or group of cells based on value
  634. Lookups
  635. sumifs/sumproduct
  636. Re: sum of multiple rows
  637. Need help in WORD 2007
  638. sum of multiple rows
  639. sumif or if statement, pls help
  640. IF formula for differing text within two separate columns
  641. Counting number of medals per athlete
  642. Formulas for F- and T-Test
  643. Create dates for year, allow for leap year
  644. vlookups and logical statements?
  645. Large function with if statement
  646. Summary of shipments by month
  647. Find and delete unused Defined Name References
  648. Insert/ delete row in protected worksheet
  649. Converting %
  650. Using a cell value in the headers of a print out.
  651. Re: Excel 2003 VBA Conditional Formatting Question
  652. MS Excel VBA Interview Questions & Answers
  653. Calculating the Count of Monthly Gains/Losses
  654. Count column b if column a equal cell value
  655. Print same form with different, listed data
  656. Drop Down Sort Button.
  657. can I format excel to see over 15 digits?
  658. Embedding check boxes into Excel cells
  659. Why you should convert your vehicle to flex fuel
  660. EXACT function vs. equals operator
  661. Double Equals Operator?
  662. SHRINK/REDUCE EXCEL FILE SIZE
  663. use offset function
  664. Calculating age from date of birth and ignoring if blank
  665. Relate rows (child/ parent), secure relations for sorting
  666. How to Use two search criteria in one array.
  667. How to auto-enter a date for when your sheet was last updated
  668. VLOOKUP
  669. How to limit validation list
  670. is there a simple formula that will remove all duplicates
  671. macro's name changed. prepended with worksheet's name
  672. Ron's between function in excel..
  673. forgotten password (tab)
  674. Find Last entry for Col in Multi column array using cell from another array.
  675. make a named range with an array not using a workseet cell range
  676. make a named range with an array not using a workseet cell range
  677. make a named range with an array not using a workseet cell range
  678. make a named range with an array not using a workseet cell range
  679. make a named range with an array not using a workseet cell range
  680. make a named range with an array not using a workseet cell range
  681. make a named range with an array not using a workseet cell range
  682. make a named range with an array not using a workseet cell range
  683. make a named range with an array not using a workseet cell range
  684. make a named range with an array not using a workseet cell range
  685. make a named range with an array not using a workseet cell range
  686. make a named range with an array not using a workseet cell range
  687. AVERAGEIFS Error
  688. Re: Calculate Business Hours
  689. text to date..!
  690. Excel 2007 SUMPRODUCT help
  691. Counting something
  692. Subtotal of adjacent coloumn
  693. Find/Replace Select Numbers in a Cell
  694. Re: Hi "excel formula to separation of integer "
  695. Moderator to remove spam
  696. conditional sum with date
  697. ROMANTIC SHOW
  698. OPEN EXCEL - Needs your support and enthusiasm...
  699. Formatting Dates
  700. How to copy one worksheet vith command button???
  701. Scoring a result in a cell
  702. Showing Day and Date in the same Cell
  703. HOT ACTRESS
  704. sun results of a vlookup across a range
  705. vlookup problem
  706. time converting
  707. Cut & Paste Locked Cells
  708. Creating a formula relating to several cells
  709. Userinterfaceonly
  710. Navigation Problems
  711. Profit and Loss different sections "Excel P&L template"
  712. Copy system
  713. Number fault -Help!
  714. XIRR #NUM error - help!
  715. Use Text and Cell vale to reference a named range inside a formula
  716. I have a pairs of numbers
  717. test
  718. Stock Quote into Excel 2010
  719. VLOOKUP Function Reference with illustrated examples (great!)
  720. Reserved dates
  721. vba solution for protection
  722. Standard Deviation Question
  723. Countif not counting...
  724. wizards for combi boxes
  725. Help with an IF Formula
  726. count dates
  727. Compare two datasheets and create a new one with modified and newinformation - Excel
  728. Date/Time
  729. Date Time increment with additional condition of skipping weekends
  730. #VALUE
  731. Assign each week number to corresponding month of the year
  732. Creating a high performance dynamic name
  733. Stripping selected text out from existing content
  734. Stripping out selected sections from existing cell contents
  735. vlookup question
  736. convert dates
  737. Compare dates (re-stated)
  738. Compare dates
  739. Compare dates
  740. F4 key and absolute reference
  741. Formula Problem for fantasy league
  742. Transpose a List to a Metrix
  743. A function for filtering between Dates
  744. Confused about standard deviation
  745. Re: BusSeriesQuestion
  746. countif and vlookup
  747. Return Unique Entries Only
  748. Re: BusSeriesQuestion
  749. BusSeriesQuestion
  750. Re: Formatting the Today() function