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: downloading a template into a new sheet of an existing workbook
  2. Re: Not having luck with any examples of averaging...
  3. Complex formula to count cells
  4. Re: Hyperlink problems
  5. Re: Help with conditional formatting in Excel 2010
  6. Re: Help - need to consolidate workbooks
  7. Re: Help - need to consolidate workbooks
  8. Re: If then Statement for Excel Columns
  9. Get domain immediately
  10. Get domain immediately "Get 1 domain Rs.300/- 2 domain Rs.500/- 3domain Rs.700/- 4 domain Rs.900/- 5 domain Rs.1000/- Mobile- 09163972290Mail- siladityacool@gmail.com Don't need to have coding knowledge to create site.
  11. Re: Date Intervals
  12. Editing an "IF" function across a worksheet/excel file
  13. Complex Median Formula
  14. Sumproduct Problem
  15. Re: Help with SUMIFS
  16. Enable Slicer Data Refresh in Locked S/S
  17. Re: Function Problem
  18. Re: Split Data Series (Lookup, Index, Match references)
  19. Re: Applying macro to mulitple worksheets?
  20. Re: Many youths would appreciate your help...
  21. Re: Creating unique keys
  22. Re: Help with SUMIFS
  23. Lookup against concatenated source value
  24. Re: Function Problem
  25. Re: runtime error 9 subscript out of range
  26. Re: Keep original cell formatting when using transpose array formula
  27. sunrise/sunset calculation
  28. sunrise/sunset calculation
  29. sunrise/sunset calculation
  30. Re: Counting one Character as a String
  31. Special string convertion to date and time
  32. Help with Excel 2007 COUNTIFS!
  33. Re: Call a function within Excel VBA --- need help can't figure out syntax correctly
  34. Running Total Question
  35. Hide/Unhide with cell double click
  36. Formula Question
  37. Re: Losing Data From Formulas When Cell Variable Changes
  38. Re: Progressive pricing
  39. Get Column Header if Condition is Met
  40. Re: Sumif or vlookup
  41. Dynamically sized table compiled from unsorted rows with blank entries
  42. Average If
  43. function showing false result when it is not
  44. Re: Progressive pricing
  45. Re: Progressive pricing
  46. Cros referencing Data on Excel
  47. Sliding Scale
  48. Re: formula to disperse data to several worksheets
  49. hi al
  50. Re: using excel as a markbook
  51. Re: How to create a pivot table in a new worksheet by recording amacro
  52. IF Function -- Return Null Value Help
  53. formula displays as a formula, not as its result
  54. Large Data File Consolidation...
  55. Screening through days of the week including time
  56. VLOOKUP source values are a formula result. Getting #N/A
  57. Need VB formula to exit workbook
  58. Re: COUNTIF - help please
  59. Bugs in vlookup?
  60. Cross referencing data in Excel
  61. Re: COUNTIF - help please
  62. Re: COUNTIF - help please
  63. 2 criteria
  64. Re: Creating Palette Labels at work
  65. Need VB formula to execute form
  66. Index and Match
  67. Re: may need programming?
  68. Re: Highlighting duplicates across many sheets
  69. Re: Highlighting duplicates across many sheets
  70. Re: If statement checking list
  71. Re: If statement checking list
  72. pivot table help
  73. Re: Help with a formula (calculating totals based on individual percentages
  74. Re: Present Value Uneven Cashflows
  75. What my chart to exclude 0 data...
  76. Re: Present Value Uneven Cashflows
  77. Re: Help with a formula (calculating totals based on individual percentages
  78. Re: Tricky one
  79. help with formula for last input in column
  80. Re: SUMPRODUCT help needed
  81. Re: SUMPRODUCT help needed
  82. N/A in pivot table become 0
  83. Re: Extracting Data from Tables
  84. Formula Help
  85. open file with multiple types of delimiters
  86. Re: Lookup cell next to data
  87. Re: Show time as a bar graph
  88. can you make a cell blink?
  89. Formulas Still Not Working
  90. ANOTHER URGENT QUESTION - Sums and Ifs
  91. URGENT HELP - SUM FORMULA
  92. Re: How to save random numbers?
  93. Re: Calculating what staff worked on which product
  94. Formula Based on Values in Named Range Q
  95. Re: copy cell range in other sheet
  96. Re: Copy Cell in other sheet with condition
  97. Need VB formula to edit and save data
  98. Re: copy cell by command button
  99. Compose A Full Excel Date From Parts Elsewhere
  100. Re: Copy Cell in other sheet with condition
  101. Dates
  102. Re: Copy Cell in other sheet
  103. Modify A Formula
  104. CTRL + H doesn't go to A1
  105. Need VB formula to retrieve data
  106. Re: VLOOK UP
  107. row height
  108. Re: 1st numer in string
  109. Display relevant information from excel sheet into form
  110. I have a column of numbers, some positive and some negative.
  111. Macro or Formula Needed
  112. Calculate average in intervals
  113. grouping dates in a pivot table
  114. How to find max value in a range then give value in cell 2 rows above that max
  115. Excel and Visual Basic
  116. IF Function error #VALUE
  117. Conditional Formatting based on active Named Range; IF Function to VBA
  118. Cell Range Split into Multiple Cells
  119. What's the best way to set this formula up?
  120. Find text in N columns and one Row
  121. How to custom format a date
  122. Re: Ignoring text in cell formulas
  123. Re: Ignoring text in cell formulas
  124. Which function will work best? And how do I set it up?
  125. Re: Shared workbook error message
  126. Re: Average of cells in a column if the top cell is a color
  127. Re: Average of cells in a column if the top cell is a color
  128. Re: Ignoring text in cell formulas
  129. I do statistical work. Recording numbers in notes,
  130. I do statistical work. Recording numbers in notes,
  131. help with Sum in between dates
  132. Largest value in column A based on conditions in columns B and C
  133. Formula/Macro Question
  134. Excel Facetime Measurement
  135. SUMIF (or SUMIFS): Can I have multiple EITHER OR criteria
  136. hot to calculate peaks of an "irregular" sine wave
  137. Create A Button and Assign A Macro To It
  138. find and replace numeric strings in larger text strings
  139. Formula Error When Sorting
  140. Copy cells in Excel
  141. Returning a YES or NO if there is a value on a range of cells
  142. First, Last occurance of date in column
  143. Min Max Question
  144. Question about Combin function
  145. Conditional sum, when condition has multiple values
  146. Constructing Range Name calls with Concatenate
  147. How do I have a cell value define a dynamic named range?
  148. Global Change Of Formula Value
  149. need help extracting data from cell....
  150. Formula Using Vlookup & Match
  151. Excel Macro or Formula Question
  152. Re: Excel not totaling right amount
  153. Re: Excel not totaling right amount
  154. Re: Excel Currancy Decimals
  155. Re: Decimals on cents
  156. Re: Excel Currancy Decimals
  157. I have a column of numbers, all are positive.
  158. Re: Excel Currancy Decimals
  159. Conditional Formatting Formula
  160. Adding values for all rows in a range
  161. Highlight row
  162. Vlookup for repitative data
  163. Vlookup error
  164. Vlookup error
  165. I would like a formula that
  166. return proper match from three columns
  167. Lookup Formula
  168. Mixed numerical and textual data
  169. Cell format
  170. Re: Need Help With String Concatenation
  171. Re: Need Help With String Concatenation
  172. Lookup across a Range
  173. Listing unique values, frequency, and maintaining list order integrity
  174. Icon sets fomatting error
  175. SUMIFS, one criteria range, multiple criteria
  176. Re: List/Combo Box Issues
  177. Excel Split column data
  178. Use array/braces **WITHIN** a formula?
  179. eliminate negative value from normal random number distribution
  180. How to use If and And function in a worksheet
  181. code to unhide tabs based on cell contents
  182. divide numbers up for a paper form
  183. Possible to refer to a sheet's object name ?
  184. Does the order of worksheets matter ?
  185. Count values, excluding duplicates and specific values
  186. setting up a schedule in Excel
  187. Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS
  188. Formula for function/argument "exclude".
  189. Formula help
  190. Replace a fixed number with a variable via popup
  191. Split words in a cell
  192. SumByColor & #NAME?
  193. Skipping weekends during a count
  194. How to get range names to Apply across multiple tabs
  195. Re: Changing the color of rows - conditional formatting
  196. Auto worksheet name?
  197. Auto worksheet name?
  198. The effects of time on value
  199. activity
  200. GST
  201. Sort, simplify, duplicate rows and probably a few more steps!
  202. Activity
  203. formatting a percentage in a cell
  204. formatting as percentage
  205. monthly consolidation in separate worksheet
  206. excel "IF" function... is this possible ?
  207. vlookup or index?
  208. Copy summary data to new sheet
  209. Select 3/4 digit numbers from text
  210. Formula Problem
  211. Median If in Excel not working
  212. Using COUNTIF with criteria in an adjacent column?
  213. Convert room dimensions 13' 8" X 9' 2" to square feet
  214. Re: MATH COMPUTAION
  215. Sequencial page numbering of multiple tabs
  216. removing zeroes almost perfect
  217. counting absentees
  218. Row references
  219. Searching for text within formula
  220. Sum of squares if condition
  221. Converting time to Minutes
  222. help me please(macro codes)
  223. Changing function name in formula
  224. If cell value is between XX and XL, display B
  225. SUMPRODUCT query
  226. Why doesn't this work ?
  227. Find in a sentence diferent word
  228. Stop Macro running when I save the workbook
  229. Data validation for specific text, for example "blue"?
  230. Re: Formula Help PLease
  231. Re: Formula Help PLease
  232. Two sets of XYZ data columns comparison
  233. Taking relevant information to sheet 2
  234. Help With Formula For Cell Addresses
  235. Re: Formula Help PLease
  236. Nesting SUBTOTAL with SUMPRODUCT?
  237. VBA Question (Again)
  238. Stopping one sheet from calculating
  239. All sheets in workbook have same rows to repeat at top
  240. Re: Multiple Creteria Lookup(Between Dates)
  241. Re: Multiple Creteria Lookup(Between Dates)
  242. Combining Excel Files
  243. use cell address
  244. Re: Filter problem
  245. VBA Question
  246. custom data validation on cells with data validation values
  247. Help With Searching For Strings In Part Numbers
  248. hello i wanna help
  249. Match and Vlookup issue
  250. Add Time Q
  251. INDIRECT with Sheet Level Defined Name
  252. Formatting a two-variable data table
  253. Noncontiguous cell range
  254. Re: Any Help Appreciated
  255. Last workday
  256. Array Constants
  257. Convert Numbers to Words for UK format
  258. OR in SUMPRODUCT formula
  259. How does this formula work ?
  260. Problem with excel. Please Help!!
  261. Getting smallest number > 0 in an array constant
  262. Validation List
  263. Re: Vlookup problem
  264. Removing 2-3 characters at the end
  265. Removing 3-4 decimals
  266. Adsence account for just 250
  267. SMALL function to find X smallest number greater than Y
  268. SUMIFS with Trim
  269. Exclude worksheet from loop.
  270. Is there a way to change the color
  271. display date of today in cell X when number >0 in cell Y
  272. Has =TEXT(. . .,0) been applied?
  273. Formulas within list fail to update after sorting/filtering
  274. Problem with pivot tables
  275. Re: Bullet Points
  276. quick question on sumif
  277. User Defined Function Help
  278. SUMMING TOTALS BASING ON CHARATERS ENTERED IN CELLS OF ONE COLUMN
  279. SUMMING TOTAL BASED ON CHARATERS ENTERED IN CELLS
  280. Round Question
  281. text to column
  282. Pivot Table Help -filter with creation date
  283. Counting errors
  284. Formula help
  285. I need a help formula
  286. Converting from Decimal to Base-36 in Excel Formula
  287. Repeat formula for varying levels of data
  288. Baffeling IF statement
  289. Need a Macro
  290. Skill about VBA
  291. Fixing date of entry
  292. BOLD WORDS IN CONCATENATE FORMULA
  293. EXCEL time match
  294. data validation across multiple columns
  295. Developing invoices with transaction breakdown
  296. Using the IF and Sheets
  297. macro to call other macros
  298. Parent child relation between two rows in an excel sheet
  299. Query regarding any lookup function
  300. Conditional fomatting for cells containing a Comment
  301. How to truncate list of meaningful words greater than 15 chars tomeaningful words of 8 chars.
  302. VBA range selection question
  303. Re: Conditional format
  304. How to write an array to a range without looping
  305. compu-mania.co.cc
  306. function MATCH returns wrong value
  307. IRR formula: weird pattern
  308. COUNTIFs dates on a cloumn are within the last 30 days
  309. Indirectly us a Named Range
  310. Attendance tracker last 30 days
  311. Printing and scaling: why does Excel behave in such a way? PLZ HELP!!!
  312. Conditional Sum across WORKSHEET
  313. Excel 2007 Charts & Memory Leak??
  314. Copying a cell value from one page to another
  315. Vlookup with Dates
  316. pytanie o kopiowanie bez zmiany komórek w formule
  317. Re: Another Question
  318. COPY IF funcion???
  319. Less Excel more Math
  320. row totals in pivot table
  321. Re: Question - Please read
  322. Re: Question - Please read
  323. Turnover Report
  324. Serious Excel Challenge
  325. Want only rows with populated data
  326. Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted
  327. Is it possible to match a cell's contents from a list ?
  328. COUNTIF with 2 columns
  329. Excel - Commission using SumIF
  330. Modifying a complex date formual to count months
  331. Autofill from months
  332. How to sum x cells that are greater than zero on the right?
  333. Excel 2007 Chart Data Selection- Arrow Keys Frustration
  334. Need advice on my sumif formula (text ref.)
  335. Re: SUMIF
  336. Re: SUMIF
  337. Growth Rate for number series
  338. Parsing Question
  339. Problem with Formula
  340. Copy all text in a string prior to the last period...
  341. Extracting Data From The Right of a Cell
  342. error with countif formula on when adding linked spreadsheets
  343. Re: Finding position of last period in filename
  344. Recursive Functions...maybe
  345. Re: Finding position of last period in filename
  346. Inverse tangent in excel, please help!
  347. very complex IF function if not an alternative function of crossselection
  348. colour numbers
  349. I have a column of numbers, some positive, some negative.
  350. Countif
  351. Re: get a cell reference as a result of an If Function
  352. Consolidate two Data Sets for Making a Report
  353. Manipulating imported times
  354. Retrieve data based on 3 criteria
  355. Binary operator >> (?)
  356. Manipulating matrices of unknwon (a priori) size
  357. Image from URL
  358. Conditional formatting backwards compatibility question
  359. Dynamic CONCATENATE and LOOKUP
  360. Counting cells in a selectable date range
  361. need some beginner help with LOOKUP functions
  362. Dynamic 5-week date range & SUMPRODUCT formulas
  363. optimization
  364. Count
  365. Re: time window calculation
  366. Re: time window calculation
  367. How to reverse this formula?
  368. Protection
  369. Re: setting scale for graphs
  370. Need array formula to ignore hidden values
  371. How do I calculate age using a 12 digit social security number in MS Excel?
  372. Trying to add column headings to array formula
  373. Rounding Time to Nearest 5 Minutes
  374. How to show best and worst results over a range
  375. How do I exclude text???
  376. if and vlookup formula
  377. number to character and vice-versa
  378. Re: reconstitute date
  379. Re: reconstitute date
  380. Formula for showing Previous Year - Current Year
  381. Conditional formatting to highlight the closest value
  382. Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture
  383. Re: Conditional Formatting colums
  384. Re: Conditional Formatting colums
  385. [ask] Quartile and Frequency
  386. Need help with sorting and moving to worksheets
  387. NETWORKDAYS
  388. How to select all the cells with only ' in them
  389. Create unique list of names from list of duplicates and that arefound within another range
  390. Conditional Formatting
  391. I need my SMALL formula to ignore zero's
  392. Machine-readable passport calculations
  393. lookup values from certain text file.
  394. Summary of Unique item values
  395. Format numbers as "Number"
  396. Creating a UDF to convert ADDRESS function output as a reference
  397. vba dynamic
  398. Vlookup into 2 columns
  399. Need some help with a COUNTIF function
  400. Counting assistance
  401. Excel 2007 Paste Special Values Comment Disappears
  402. Re: Help with Autofill
  403. Re: Help with Autofill
  404. HELP
  405. Dynamic Named Range formula without using OFFSET function
  406. Append shortcut link to open a particular workbook TAB
  407. Auto sort help.
  408. Current Region in a formula
  409. Identify part number in list and tag it with characters from another list
  410. Re: Question on XIRR Usage
  411. Top 4 scores in excel
  412. Re: XIRR Function
  413. sorting problem?
  414. If , Mid or right functions or a combination thereoff.
  415. Use If & Mid or Right functions or combinations thereoff......
  416. Re: Trouble with Print Area
  417. Copy Data from Within same Workbook
  418. Top 4 scores in excel
  419. Re: Formula Suggestions/Help
  420. EXCEL FORMULA
  421. Need help in creating horizontal array using either macro or someformula
  422. grand totals in pivot table rows
  423. Help with worksheet function
  424. Re: HELP - I need some help with page numbering tabs
  425. Averaging a colume of values.
  426. Numbering a column of numbers.
  427. XL2007: I need a sumproduct formula that will transpose as I copyacross columns
  428. Hyperlinks
  429. convert date to Day of the Week
  430. Lookup and count all cells that fall between 2 dates
  431. Excel Lists
  432. Lookup multiple cell values and place contents in a single cell
  433. Array Formula for numbering similar nos (counting)
  434. matrix math in excel?
  435. Why is my tab key not working properly any more in Excel 2007?
  436. Adding days by using NETWORKDAYS 2007 formula
  437. Conditional Formatting with Icon Sets
  438. Re: Performance in year 2
  439. HyperLinks View
  440. Re: Performance in year 2
  441. Look Around Today at Online Personals Date for Free
  442. Force input & colour cells
  443. Problem with SUMIF Formula
  444. Set the Length of the Cell
  445. How to write XIRR formula on excel using different Year basis than 365.
  446. shading a cell or group of cells based on value
  447. Lookups
  448. sumifs/sumproduct
  449. Re: sum of multiple rows
  450. Need help in WORD 2007
  451. sum of multiple rows
  452. sumif or if statement, pls help
  453. IF formula for differing text within two separate columns
  454. Counting number of medals per athlete
  455. Formulas for F- and T-Test
  456. Create dates for year, allow for leap year
  457. vlookups and logical statements?
  458. Large function with if statement
  459. Summary of shipments by month
  460. Find and delete unused Defined Name References
  461. Insert/ delete row in protected worksheet
  462. Converting %
  463. Using a cell value in the headers of a print out.
  464. Re: Excel 2003 VBA Conditional Formatting Question
  465. MS Excel VBA Interview Questions & Answers
  466. Calculating the Count of Monthly Gains/Losses
  467. Count column b if column a equal cell value
  468. Print same form with different, listed data
  469. Drop Down Sort Button.
  470. can I format excel to see over 15 digits?
  471. Embedding check boxes into Excel cells
  472. Why you should convert your vehicle to flex fuel
  473. EXACT function vs. equals operator
  474. Double Equals Operator?
  475. SHRINK/REDUCE EXCEL FILE SIZE
  476. use offset function
  477. Calculating age from date of birth and ignoring if blank
  478. Relate rows (child/ parent), secure relations for sorting
  479. How to Use two search criteria in one array.
  480. How to auto-enter a date for when your sheet was last updated
  481. VLOOKUP
  482. How to limit validation list
  483. is there a simple formula that will remove all duplicates
  484. macro's name changed. prepended with worksheet's name
  485. Ron's between function in excel..
  486. forgotten password (tab)
  487. Find Last entry for Col in Multi column array using cell from another array.
  488. make a named range with an array not using a workseet cell range
  489. make a named range with an array not using a workseet cell range
  490. make a named range with an array not using a workseet cell range
  491. make a named range with an array not using a workseet cell range
  492. make a named range with an array not using a workseet cell range
  493. make a named range with an array not using a workseet cell range
  494. make a named range with an array not using a workseet cell range
  495. make a named range with an array not using a workseet cell range
  496. make a named range with an array not using a workseet cell range
  497. make a named range with an array not using a workseet cell range
  498. make a named range with an array not using a workseet cell range
  499. make a named range with an array not using a workseet cell range
  500. AVERAGEIFS Error
  501. Re: Calculate Business Hours
  502. text to date..!
  503. Excel 2007 SUMPRODUCT help
  504. Counting something
  505. Subtotal of adjacent coloumn
  506. Find/Replace Select Numbers in a Cell
  507. Re: Hi "excel formula to separation of integer "
  508. Moderator to remove spam
  509. conditional sum with date
  510. ROMANTIC SHOW
  511. OPEN EXCEL - Needs your support and enthusiasm...
  512. Formatting Dates
  513. How to copy one worksheet vith command button???
  514. Scoring a result in a cell
  515. Showing Day and Date in the same Cell
  516. HOT ACTRESS
  517. sun results of a vlookup across a range
  518. vlookup problem
  519. time converting
  520. Cut & Paste Locked Cells
  521. Creating a formula relating to several cells
  522. Userinterfaceonly
  523. Navigation Problems
  524. Profit and Loss different sections "Excel P&L template"
  525. Copy system
  526. Number fault -Help!
  527. XIRR #NUM error - help!
  528. Use Text and Cell vale to reference a named range inside a formula
  529. I have a pairs of numbers
  530. test
  531. Stock Quote into Excel 2010
  532. VLOOKUP Function Reference with illustrated examples (great!)
  533. Reserved dates
  534. vba solution for protection
  535. Standard Deviation Question
  536. Countif not counting...
  537. wizards for combi boxes
  538. Help with an IF Formula
  539. count dates
  540. Compare two datasheets and create a new one with modified and newinformation - Excel
  541. Date/Time
  542. Date Time increment with additional condition of skipping weekends
  543. #VALUE
  544. Assign each week number to corresponding month of the year
  545. Creating a high performance dynamic name
  546. Stripping selected text out from existing content
  547. Stripping out selected sections from existing cell contents
  548. vlookup question
  549. convert dates
  550. Compare dates (re-stated)
  551. Compare dates
  552. Compare dates
  553. F4 key and absolute reference
  554. Formula Problem for fantasy league
  555. Transpose a List to a Metrix
  556. A function for filtering between Dates
  557. Confused about standard deviation
  558. Re: BusSeriesQuestion
  559. countif and vlookup
  560. Return Unique Entries Only
  561. Re: BusSeriesQuestion
  562. BusSeriesQuestion
  563. Re: Formatting the Today() function
  564. deleting a file through VBA
  565. Convert Numbers to Text
  566. IF function with dates
  567. Pivot Tables - Sum then Average
  568. return blank cell if condition met
  569. Getting data into control combo boxes
  570. Open CSV as txt data
  571. adwordvouchers@yahoo.com
  572. is this possible?
  573. Re: How can I count the number of SATURDAYS in a month?
  574. How can I link PivotTables in Excel 2007?
  575. SUMIF
  576. Comment in specific place
  577. Re: How can I count the number of SATURDAYS in a month?
  578. hey
  579. Comparing contents in three cells
  580. Comparing contents in three cells
  581. compare three cells
  582. Re: Formatting the Today() function
  583. Re: Formatting the Today() function
  584. Picture Links printing problem - Help!
  585. Convert Cell Value to ASCII
  586. Macro Question
  587. Strange behavior of chart
  588. Can these countif functions all be combined in one cell?
  589. Countif until a number occurs four times in a row then return that number
  590. Macros Question
  591. Getting "0" into cell if "0" is there Options - again
  592. Need AdSense Account.
  593. Approve My Google AdSense Account.
  594. How To Get AdSense Account.
  595. vlookup across multiple tabs
  596. vlookup across multiple tabs
  597. dropdown menu ? other ideas?
  598. I have a column of 120 numbers
  599. How can you convert a text value to a numerical formula ?
  600. Counting the number of times a character occurs in a cell
  601. Conditoinal formatting
  602. How to use data from external sources
  603. Is there a way to parse multiple values in a cell and applycalculations to those cell ?
  604. Getting "0" into cell if "0" is there
  605. If this or that is not something and this is something, say this
  606. change full name to: title + initial(s) + surname
  607. Excel is being stupid - Help please!
  608. How can you replace specific characters in a string ?
  609. conditional formatting
  610. Using a wild card * with Sumproduct
  611. Re: Simple, if you know Excel !!!!
  612. How could a formula return multiple values as concatenated text ?
  613. Linked Named Ranges
  614. Re: Returning Multiple Results with Vlookup
  615. Re: Simple, if you know Excel !!!!
  616. Returning Multiple Results with Vlookup
  617. Re: Empty cell calculations
  618. Indirect function and relative references
  619. Is there a way to extract multiple values from an INDEX result ?
  620. Trying to combine formulas
  621. Re: Help with Date in SUMPRODUCT
  622. Sumproductif?
  623. Combine IF and NETWORKDAYS
  624. NETWORKDAYS
  625. Function help required... Between funtion
  626. Formula Check Please!
  627. I Need Calculate Variable Scenarios with timings
  628. NETWORKDAYS
  629. Need to Match Multiple Results and Count Text in Different Column
  630. GHD
  631. identifying data from a separate worksheet
  632. Double Click Cell to Run Macro
  633. excel dropdown question
  634. Need Google AdSense Account
  635. Re: fill multi cells with single cell
  636. i-Technosoft offers Windows Sharepoint Services for $1
  637. =COMBIN(26,3)
  638. SUMPRODUCT sum until condition changes
  639. Sumproduct between dates
  640. Sumproduct using OR
  641. MAKE UPTO $5000 MONTHLY! $2000 INYOUR FIRST 30 DAYS!
  642. Used Car Sri Lanka
  643. converting to time format
  644. Re: Comparing then populating
  645. Locations of validation lists
  646. Re: SUMIF showing wrong values
  647. AutoFit not working properly
  648. Sumproduct ??
  649. Re: Help needed with multiple column lookup
  650. Making a Pivot Table from data of a Close sheet visa Button(Macro)
  651. Save all sheets in a new workbook
  652. "if" formula
  653. Re: Can't insert a new worksheet
  654. Invarse Tan in Excel
  655. Totalling two columns of Hours and Minutes on Lotus1-2-3
  656. How can I do a lookup to a specific cell on another tab
  657. Insert blanks, but populate new blank rows in one column
  658. Importing The Excel Sheet I choose
  659. Disconnect from external database when creating a copy
  660. linking text on button to a cell
  661. IF Formula help. 2 chances for errors
  662. Dolphin Dale high School: N Naveen Chowdary
  663. Mapping auditorium seating in Excel
  664. Modify number display
  665. VLOOKUP results in problems in comparing
  666. combining content from an input box with existing cell content
  667. Start adding blank rows at row 4 (vba code)
  668. Excel Lookup
  669. Need help creating a running subtotal
  670. IP Subnet Calculator - Excel Function
  671. Resizing ActiveX check box
  672. Calculate interest on an investment
  673. SumProduct help please
  674. Consecutive values; averages and ranges by specific months
  675. Search tab using indirect for number of times in a range
  676. Need Help FAST with COUNTIF Formula
  677. Forming my own numeric representations
  678. Workbook that make good use of functions
  679. UPDATED - How to multiply arrays and get the largest number in theresulting array ?
  680. Code does as instructed, but creates and saves a Book1
  681. Function of sum
  682. How to create a similar resume in MS Excel ???
  683. How to multiply arrays and get the largest number in the resultingarray ?
  684. Copy Data from 1 Sheet to Another
  685. Truncating/ Eliminating few digits
  686. Formatting a text statement
  687. Cognos Certification Training Tools - Self Exam Engine
  688. COUNTIF & Dates
  689. drop down box event changes in different cells
  690. Re: Chronologically collate comments from several spreadsheets - helpneeded.
  691. Re: This function works for small figures but not for large
  692. Re: This function works for small figures but not for large
  693. Linking to a Chart Q
  694. Tell me what you think, guys n gals
  695. Trouble with vlookup and numbers stored as text
  696. Re: Chronologically collate comments from several spreadsheets - helpneeded.
  697. Value used is wrong data type..
  698. Troubleshooting macro to save in Compatability Mode
  699. find if row checkin date is within30 days of previous rows checkoutdate.
  700. a data validation list that contains a list of named ranges - not alist from a named range
  701. sorting coloumns
  702. concatenated value validation against list
  703. Relationship Help - Problem and Incident Database
  704. Parent/Child Hierarchy.
  705. WHAT IS THE RIGHT FUNCTION ?
  706. index_match
  707. COUNTIF and Data Validation
  708. Re: Data analysis: find average, spikes, etc.
  709. Find >cell_value with COUNTIF. Can't Refer to Cell Value in "quotemarks"
  710. Arranging dates in a single column
  711. EXcel IF function
  712. how to fill in names in cells automatically
  713. Re: Schedule Events
  714. Data Look Up
  715. find last non-zero entry
  716. Total Strength to Concentration
  717. Re: IF, dates and values
  718. Calculating Initial Payment - Excell
  719. Excel sort dialog box: Display of column header instead of columnname
  720. Where did everybody go?
  721. Re: Problem with data validation formula *** structured reference ***XL 2007
  722. Re: Problem with data validation formula *** structured reference ***XL 2007
  723. Problem with data validation formula *** structured reference *** XL2007
  724. how to use an formula to transpose a list(left) to be like the right?
  725. Find
  726. excel time stamp
  727. Re: Conditional Format a range - help needed.
  728. Re: Conditional Format a range - help needed.
  729. Re: SUMIF anomaly - Help Needed
  730. Re: Delivery lead time formulas
  731. Can you use an INDEX array in a COUNTIF formula ?
  732. DB.SUM and whole cell value
  733. Adding custom x axis labels to histogram generated from a pivot table
  734. MATCH and A:A
  735. adding data from a form
  736. Password prompting to unhide worksheet allows temporary visibility
  737. I have either a H or A in cell B5.
  738. If a cell equals another cell, then use the value in the cell to theright.
  739. Spin Button
  740. game timer
  741. Summing Like items
  742. Macro to unhide all except for. . .
  743. Re: sumproduct and subtotal but with 2 conditions
  744. excel sumproduct value error
  745. How to deal with content thieves like fixya.com?
  746. Re: Macro
  747. Split Text into Two Columns
  748. Can someone help me please? Prefix to add international diallingcodes to Uk mobile numbers
  749. [CSE] SUM Array Formula with if condition
  750. How to put same scale on X and Y axis on graph