PDA

View Full Version : 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 | 

  1. Refer to a named range indirectly
  2. Derive Average
  3. Renaming worksheets
  4. COUNTIF Question
  5. auto filter
  6. Header/Footer on entire workbook
  7. Linking data?
  8. how to display my cursor cell content in another cell....
  9. Excell< another dillemmmmaaaa please help!!!
  10. excell big dilemma
  11. Delete a toggle button overlaying data
  12. EXCEL FIND A SPECIFIC TOTAL
  13. Function to return the last value in a contiguous set of data
  14. Pivot Tables (Sumif)
  15. CALCULATE PROFIT/LOSS
  16. Vlookup for multiple results
  17. Format Cell
  18. SUMPRODUCT Help
  19. finding the earliest date in an array of cells
  20. New row(s) macro
  21. If Month?
  22. Reverse SumProduct function
  23. Survey Form And Tracking Results
  24. Forecast Formula
  25. DSUM to pull data from Access DB
  26. 4 IFs
  27. ROUNDUP to nearest 1/16 (in decimals)
  28. Value of particular column
  29. Copy format
  30. how to find cubed root of a number
  31. To Calculate the qty b/w two dates
  32. IF Function in Excel
  33. 3 zero instead 1 zero
  34. Can a formula tie the fill colours of two cells?
  35. Filtering the Column headers that contains data for resources
  36. How to get 2003 Excel pivot table to work correctly?
  37. HELP! Need to sum columns where credit balances are shown as ###CR
  38. help with calculating average prices and profit/loss
  39. HELP! Need to divide all columns by same number to get sell price
  40. i want to count how many times an entry occurs in an array
  41. IF Statement, multiple criteria
  42. Formula to run report
  43. how to create row with data
  44. How will hyperlink cell reference update after copy paste?
  45. Subtract 10 months from a Speficic Date
  46. subtotals in excel
  47. specific percentage formula
  48. sum of every 4th cell in a row.
  49. Copy only letters, not numbers
  50. Drop Down List Question
  51. Creating an if then function to manage deductions from different c
  52. Evaluate based on Actual Month
  53. How to paste phase and seperate into another cell by a symbol of.
  54. Nesting the roundup Function in a larger formula
  55. Excel Office 2007
  56. Conditional Formula
  57. Sumproduct excluding multiple criteria
  58. Multiple criteria in 2 different columns for a sum in a 3rd column
  59. forecast using a four parameter logistic equation
  60. Print first column on each page
  61. Formula (not adv. filter) to list unique values from list
  62. Conditional Formatting, multiple conditions
  63. data return using multiple conditions
  64. why does excel 2007 subtract 2009 from 2015 = 1900?
  65. divide column b by column a
  66. Copy cell contents depending on font colour
  67. VLOOKUP results is duplicating first value
  68. Using range names in functions
  69. Printing different work sheets in colour when the default is b&W
  70. Protection Macro
  71. Counting Cells With Text
  72. How do I select cells for a specific month in Excel 2003?
  73. exam marks into grades
  74. Formula not working
  75. IF Function
  76. Calculation of Quarter
  77. Show in another cell only >0 from a range?
  78. reporting with pivot table?
  79. Create A Master List From Several Lists
  80. Help!!! - logical function for someone not very logical
  81. Repayment of loan excel sheet with variables of principal free pay
  82. Insert Date
  83. How do I count cells with specific value?
  84. Moving formula results to blank line
  85. Repaymen of loan excel sheet with grace period etc...
  86. First Time Macro
  87. Find column letter of the first unused cell
  88. Function Question
  89. data entry problem after upgrade to Excel 07
  90. corrupted excel files
  91. Using MIN & MAX
  92. Cell referencing
  93. Find amount in row.
  94. difference of 2 dates
  95. page numbering of worksheet
  96. Find the Date of the Next Friday
  97. Hep with Find and Replace
  98. Need help with formula in excel
  99. Time difference function
  100. convert number to intext
  101. fromula error
  102. workbook_open() does not execute if there are conditional formats
  103. sumif - if the text has LCI in it
  104. 0.5883698 Does This Look Good? ... 0.7272271
  105. can I write a function that automatically changes over time
  106. Eliminating duplicated data completely or something similar
  107. Links won't update if file is closed
  108. Time & Date Formulas
  109. Item Lookup
  110. Link from 2007 to 2003 Version
  111. Click and drag a formula
  112. How can I create multiple tables of figures?
  113. How to display result of 3 possible outcomes
  114. DATEDIF function in excel
  115. Count If trouble
  116. Importing CSV Data from Web?
  117. TOTAL OF A RANGE SHOULD BE
  118. Cell color changes when date gets closer
  119. creating tabs with sub tabs
  120. Nearest Month
  121. Difficulty cleaning some char(63) characters
  122. Adding a zero to the front of numbers
  123. Format Cell using letter & number to use in mail merge
  124. transpose data
  125. Selecting data in a specific date range using COUNTIFS function
  126. EXCEL: find string in vector & return cell reference
  127. Combinations - multiplied sum of doubles, triples, quadruples.....
  128. Conditional format Order
  129. Absolute Reference Changes
  130. Sum values in string in a cell
  131. macro protection
  132. Coding Custom Date Functions in Excel
  133. how format date with TEXT() function for international usage?
  134. moving from one sheet to another from a cell of a sheet
  135. One less than Max
  136. Trying to HLOOKUP a value from another sheet and display all the d
  137. Lookup or Vlookup?
  138. permutations
  139. Vlookup issue
  140. what does the & symbol do in a formula?
  141. How do you assign a Workbook Location Path to a cell?
  142. Many possible variations
  143. COUNTIF greater than one column and less than another
  144. Conditional formating based on multiple comparisons
  145. conditional formatting using formulas
  146. Typing in a list to locate name (Excel 2003)
  147. weighted exams, predicting what the final exam needs to be to pass
  148. Can Excel's field fill colors be changed using "IF" statements?
  149. IF with and OR
  150. Can the Excel cell fill color be changed using "IF" statements?
  151. Cannot verify XNPV with PV or HP-12C
  152. Sum of Price Given Specific Dates
  153. Excel 2007-SUMMING from different worksheet conditional to the dat
  154. Assign password to "Very Hidden" worksheet
  155. Flagging dates with conditional formatting
  156. Rapidly Create a Large Number of Named Ranges
  157. Conditional Formatting
  158. change a group of cells to absolute
  159. Transferring CERTAIN Data from one worksheet to another
  160. Sharing data from one worksheet to another
  161. Conditional Formating
  162. If I am within the time specified..?
  163. How do I remove auto filters from a file I exported out of Salesfo
  164. SUMPRODUCT formula
  165. Counting text in two different columns
  166. INFO("directory") function
  167. If Function
  168. Row Number of VLOOKUP result
  169. Is this function supposed to work?
  170. stop error message "too many different cell formats"
  171. Adding cells of same conditional formatting
  172. Temp vaiables in formulas?
  173. If cell not null use that value
  174. Data is not printing inside cells in excel
  175. how do i see my whole document in the workbook
  176. Conditional formula
  177. IF Formula Question
  178. countif = to
  179. EXCEL function;find string in entire column & return cell referenc
  180. adding TIME through midnight calculates ok, but subtract doesn't
  181. Formula for giving point to particular no.
  182. Attendance formula
  183. Text from a comment box into a cell
  184. copy cells daily and automatically
  185. Lookup for a word in a table
  186. Sum of constant decrement
  187. got #REF! with fomula PRICE()
  188. Conditional Testing of an array
  189. CountIf on Date / Time
  190. calendar control for week day
  191. if formula
  192. ISTEST Function
  193. Calculate items based on calendar year ending today
  194. Please help - Find & copy Macro
  195. VLookup - find new items
  196. Calculate End Date (excluding weekends and holidays)
  197. Como alterar o cabeƧalho das coluna de algarismo para letras
  198. Text from a comment box into a cell
  199. How do I link 2 spreadsheets to insert amounts on a defined date?
  200. decrease integers to zero
  201. Dynamic List of names?
  202. Find and copy for inventory
  203. Cell Protection
  204. PDF macro button
  205. Help with Lookups
  206. Subtotals in Excel 2007
  207. sort and blank cells problem
  208. how to count charactors in a cell
  209. convert seconds to hours and days
  210. Excel - Check Box Functions
  211. IF Statement
  212. Hide Blank Rows
  213. Help with LOOKUPS
  214. In Excel 07, how do I merge two sprdshts with a common column?
  215. IF Statement using several columns
  216. Vlookup in multiple columns
  217. push result from one cell to another
  218. auto/coditional format
  219. Weeknum
  220. Solution for if x = 1 and Y =2 goto C3
  221. Displaying multiple non-adjacent cells with 1 criteria
  222. Vlook up with if statement
  223. How can I get a drop down to update the range of a formula
  224. can we count words in a row which has links from other file
  225. Fill Series function question
  226. Change Row Colour if certain criteria is met
  227. Multiple variable lookup tables
  228. Conditional Format
  229. How to use formula to the Ans
  230. Fill down not working in Excel 2007
  231. using the address referenced in a linked cells
  232. Sum Across Multiple Sheets
  233. Excel Formulas
  234. Number of characters in a cell for a Index/match function
  235. RE: Converting Values to Columns??
  236. Question about condition formatting?
  237. How do I set a maximum value (e.g. cap at 200)
  238. If Function returning 0 instead of cell value
  239. dragging formulas across rows
  240. Converting Minutes and Seconds ([mm]:ss) to Decimal
  241. Copy last cell with data in column E on one sheet to cell on anoth
  242. Count NonBlank Rows with Criteria in another column
  243. counting the number of rooms
  244. Go to cell address
  245. how can I isolate the data in a worksheet from the rest of the pa
  246. Splitting data from cells into multiple lines
  247. lock cell whit first value
  248. Assigning a Worksheet Name to a Cell
  249. Formula for attendance record
  250. fix #N/A error
  251. setting up networkdays
  252. "copy"
  253. in range?
  254. Generate reports on separate tabs from data in file
  255. while entering credit card numbers last number changes to zero
  256. COUNTIF on NonContiguous Cells?
  257. vlookup lookup_value text
  258. Need an expression that's larger than my skill
  259. List to Table - formula
  260. Using Indirect for conditional Formating
  261. Learn Macro & VB Code that usually put in Excel.
  262. sumproduct formula help
  263. Vlookup Question
  264. How do I use vlookup to return a formula not a result
  265. Highlight selected cells only
  266. Upper case to Lower case
  267. Formula or Macro
  268. AVARAGE TIME
  269. Search of particular combinations
  270. how can you add attachment at the spread sheets
  271. GETPIVOTDATA on Excel 2000
  272. Updating a Formula Based on Multiple sheets
  273. Deleting rows
  274. Calculate score from Scale
  275. I enter a formula but the results are not displayed
  276. IF Statements using previous cell references
  277. partial match in vlookup with table array
  278. VBA code for find function (reference cell value)
  279. Edit formula over a range
  280. Help with 'If' function
  281. sumif any text is criteria
  282. Percentage of Multiple Rows
  283. Using COUNTIF and OR
  284. repeating the answer in A2 cell to A3:A20
  285. Financial Functions, in particular, the INTRATE function
  286. "Go Back" Feature and hyperlink
  287. repeat row labels in pivot table
  288. CountIf Functions
  289. Lookup 2 values and return a third
  290. Cell reference within array
  291. Export row depending on column to various sheets
  292. How do I locate cells that contain a certain text?
  293. How do I sum the last 5 nonzero numbers in a row?
  294. Developing Aging report-problem with 'if' statement
  295. Std Dev of Aged Inventory
  296. Getting the "0" out of an auto populate cell.
  297. More than one variable for Countif
  298. running macro's in Excel 2007
  299. Hiding Formula Answers in Specific Cells
  300. how do I reverse alphabetizing?
  301. Auto-adjust formulas
  302. Hiding sum formula answers in select cells
  303. Countif range contains part of a value
  304. AUTOMATICALLY ADJUST COLUMN WIDTHS TO CONTENT
  305. How do I get my Excel 2007 worksheet to go beyond 65536 rows?
  306. Conditional formula based on 2 pre-conditions
  307. How can I stack worksheets (I have 30 worksheets)
  308. ifblank function
  309. =sum
  310. days and time functions
  311. Approximate match on string of text
  312. To work out how many days, weeks, months to I retire on 20 Sep 201
  313. COUNT and SUM (please help!)
  314. hlookup value within a range
  315. Is there a way to use Formula to resolve
  316. Removing Mulitple Carriage Returns Within a Concantenate Formula
  317. Search a name in one sheet and entry it into another sheet
  318. unions, intersections or array constants
  319. copy conditional format without using format painter
  320. Formula/Sum Question
  321. COUNT and SUM
  322. Column Titles
  323. Counting the number of occurrences...
  324. address of first and last number in a row
  325. How to reference last non-blank cell value from a column cells?
  326. Duplicating check boxes with formulas
  327. countif question
  328. How do I get my shortcuts to stay on the Quick Access Toolbar?
  329. count across 3 columns
  330. Can anyone
  331. COUNTIF Function Provides Text Feedback, Not Values
  332. How to set up a devilery schedule calendar from excel database
  333. Problem with VLOOKUP
  334. Can users perform a reverse lookup
  335. counting in columns
  336. convert [h]:mm:ss to real number that I can use as a multiplier
  337. Sheet direction, extract data from comment
  338. Help on IF (i think)
  339. When there is a tie for "MAX" values...
  340. workbook totals
  341. Exce Formating
  342. Help IfBlank use data from next cell
  343. Display Multiple Worksheets
  344. Displaying Cell Formulas (without using Tools/Options/View-Formula
  345. GETPIVOTDATA Excel 2000
  346. looking for a rental property expense income worksheet
  347. Background and Calendar
  348. How do I weight numbers when some are zero without getting DIV0
  349. Formatting Cells and then deleting the reference column
  350. Need additional coding help
  351. counting in columns
  352. return second or third word in a cell
  353. change feet and inches to decimal inches
  354. Ties using Rank Function
  355. information automatically changes
  356. have an entire row populate with a link when the data in a cell ch
  357. have an entire row populate with a link when the data in a cell ca
  358. help with date funciton
  359. Another table lookup question
  360. Counting values in column B in condition of A
  361. comparing two columns revisited
  362. Conditional Formatting Problem - Dynamic Formula??
  363. sorting data
  364. Determine decimal
  365. Embed Data from a named Range into a text box
  366. comparing two columns
  367. Combine IF function with manual entry
  368. Re: my excel spread printed the cell numbers and letters/what's wrong
  369. my excel spread printed the cell numbers and letters/what's wrong
  370. How do I?
  371. what is the purpose of . bars
  372. Need multiple IF questions & return a value from another worksheet
  373. variable in data validation
  374. If statement to copy an entire row to other worksheet w/ in same b
  375. Data sorting formula
  376. VBA Sheets.Add disabled
  377. Can't edit worksheet
  378. Sumproduct not works
  379. Sumproduct not works
  380. Formula to get the Ans
  381. Formula to get
  382. Number to word
  383. Customise a Date to display as something else
  384. How to calculate worked weekend days
  385. COUNTIF or SUMPRODUCT
  386. Excel work book
  387. if then statements
  388. Vlookup with Match - no results issue
  389. How do you reference another worksheet without using its name
  390. How do you reference another worksheet without using its name
  391. How do you reference another worksheet without using its name
  392. Countif ā€“ Multiple column criteria ā€“ with ā€œdoes not containā€
  393. compare rows for a match and sum the matches
  394. Multiple values for LOOKUP? Maybe add IF clause?
  395. Conditional Formatting HELP
  396. Excel
  397. worksheet
  398. Why would a vlookup function stop working in excel 2003?
  399. Trailing zeros
  400. Number of days in a specific month between various start and end d
  401. Drop down menus
  402. How to average random cells with out counting zero?
  403. Convert a 8X3 table to a vertical range of the Unique strings only
  404. Excel Function
  405. expandable Text Box
  406. How does a module of VB work in a Worksheet?
  407. Invalid outside procedure (creating a PDF button as a macro)
  408. filter imported data to columns
  409. Conditional formatting - case sensitive text
  410. CF to grey out the two unused options
  411. 2 conditions for IF function?
  412. Regex Syllables, Harlan Grove?
  413. how do i add same prefix any text or number to the large datas?
  414. Sumproduct - multiple Sum ifs
  415. Mark certain cells
  416. How to get timein hh:mm format
  417. Allow Delete cells but not rows
  418. VLOOKUP Errors with Date formats
  419. How to get rid/hide #NUM! error in Excel 2003?
  420. Getting data by calling out date
  421. How do I lock a section of cells in place
  422. How to return unique values only
  423. Automatically add a column to summary sheet if another worksheet i
  424. formulas
  425. Sum a range that IS NOT NULL
  426. Extract value from a text string
  427. Combining use of Check Box and Option Button
  428. date & time
  429. Nested formula Value error
  430. Advanced Filter - Named Ranges
  431. handle error in IF ELSEIF statement
  432. How to convert "read only" to a working sheet?
  433. Function =Trim()
  434. Function =Trim()
  435. Hide Alternate Rows temporarily to Edit worksheet
  436. Largest number 2
  437. calculate fractions using dates
  438. How do I create an Inventory list using Excel
  439. Largest number
  440. Split screens
  441. Multiple cells to look up and return values to another spreadsheet
  442. Fill Color related to % complete
  443. VLOOKUP PROBLEM
  444. Excel is seeing the date as dd/mm/yyyy
  445. Leap Year
  446. Summarize & Delete
  447. Summarize & Delete
  448. Pivot Tables: Excel 2003 vs Excel 2007
  449. V LOOKUP
  450. count number of dates falling in the next seven days
  451. Display time in text
  452. Countif
  453. Vlookup & return multiple unique values
  454. Excel conditional format only if all cells contain values?
  455. Help with automatically sorting data
  456. Stat testing %s between 2 groups
  457. Equation Efficiency?
  458. HOW to built a IF formula , if any test fails, none of the other onesto be done ?
  459. combining COUNTIF and OR functions
  460. HOW to built a IF formula , if any test fails, none of the other onesto be done ?
  461. count month when date is in day/month/year format
  462. Help with Average formula
  463. Need a fresh pair of eyes
  464. Highlight Cell Changes When Using Data Connections to Access
  465. Bold a line
  466. Change Color on rows, after an IF Funtion is answered
  467. Text to number value
  468. Duplicate Difficulties
  469. Calculating Time
  470. Data Tools - Consolidate Excel 2007
  471. Formula
  472. How do I get numbers to foot across rows and colums?
  473. How do I get numbers to foot across rows and colums?
  474. conditional formatting is not avaible
  475. how do I merge multiple csv files in one Excel file?
  476. Due date - change cell color
  477. Benford law option available in Microsoft Excel
  478. Multiple selection criteria
  479. Calculating Dates
  480. How do I create a custom button that combines format settings?
  481. If Unction with text
  482. LOOKUP between two columns of diff. size
  483. Can't merge info from Excel onto address labebls
  484. Substitute
  485. Is there a formula to calculate the least common denominator?
  486. Hyperlink
  487. Automatic notifications of changes?
  488. Conditional lookup
  489. CountIf Condition based on lookup in a list of values
  490. How do i create a drop down list from information on another works
  491. From multiple reporting people able to indentify next due report
  492. sumif function
  493. How to check the whole column at the same time?
  494. Help! Rounding Up Formula
  495. Vlookup across several sheets
  496. Help with formula to round up to next higher multiple of 5
  497. SUMPRODUCT formula help??
  498. Currently using '97 version.... Should I buy Office 2007 or 2003??
  499. Countif IsErr
  500. Max Value of conditional list
  501. Cell Reference Issue
  502. Duplicate Rows
  503. using COUNTIF I want to count multiple values
  504. YTD Calculation using SUM and OFFSET
  505. Macro for Proper function
  506. Consolidate Multiple Workbooks - Excel 2007
  507. How do I carry the calculations over to the various worksheets
  508. If fomula
  509. Posted in excel.public.programming ... Count only theformula/function find the same value ...
  510. Flashing cells
  511. flashing cells
  512. How do I calc the time difference in hh:mm for shift work?
  513. Formula Help
  514. Excel 07 worksheet problem - HELP!!
  515. help with vlookup and return based on a formula
  516. Differences between columns
  517. Need to get Address() to Average Function Range argument
  518. Return first date populated
  519. Please HELP!
  520. data alteration
  521. Finding Multiple Instances in a List
  522. Time difference btwn entries
  523. How to change the row1 content of the existing excel file automically
  524. Missing info on worksheet
  525. Multiple Instances in a Column
  526. Column Number of a cell with text
  527. Formula to count the number of unique dates
  528. Conditional formatting, change row to certain color
  529. Hyperlink to cell in separate workbook
  530. Open XL - A Powerful Excel Addin
  531. Open XL - A Powerful Excel Addin
  532. Creating new worksheets
  533. Filtering based on Value
  534. Pick up some text in a cell
  535. Excel 2002 count color
  536. Tranfer of data via v &/or h lookup
  537. How can I transpose cells associated with a merged cell?
  538. to pull out information from certain cells of hundred identical wo
  539. Challenging SUMING situation!
  540. Conditional Formatting
  541. How do I find the distribution of a sample mean????
  542. Coutn specific cell with specific value
  543. I need a self calculating time sheet for Excel 2000
  544. Function to autofill remaining width of a cell
  545. combining vlookup and hlookup functions
  546. Copy functions from one file to another file
  547. Function to display text
  548. scrolling
  549. Long Date Format
  550. two column lookup
  551. Excel to inport data
  552. view excel worksheet & freeze internet window synchronously
  553. random between function
  554. Excel formula help
  555. Having trouble printing without the cell gridlines on new system
  556. Vlookup using a dropdwn list, check different tables based on drop
  557. link data from several speadsheets
  558. Flow Chart
  559. How to refresh links across workbooks
  560. Trapping errors in a VLOOKUP function
  561. Extracting all matches
  562. Flashing cells
  563. returning a SUM from text.
  564. why does worksheet require two different forms of same formulas
  565. comparing and isolating duplicates in two columns
  566. Variable reference in a function
  567. How do I move addresses in my contacts into an excel format?
  568. HYPERLINK
  569. finding top 80% line from a descending list
  570. Trying to randomly choose a number from a set list of numbers
  571. Trying to randomly choose a number from a set list of numbers
  572. Trying to randomly choose a number from a set list of numbers
  573. calculate percentage??
  574. Count Num of unique items in col? by 3 criteria
  575. Count Num of Unique items in col ?
  576. linking between spreadsheets
  577. Macro with sum function
  578. Text Search
  579. view excel in full screen view
  580. Open Workbook Formula
  581. Vlookup, Column Index Num and Autofill
  582. Extracting certain text from text string
  583. Insert a cell value into a link to another worksheet.
  584. Counting cells that have a checkbox that is marked
  585. compare date and perfom calculation
  586. Re: Outline/group data below
  587. Office 2003 Excel funtion - data table
  588. Synchronize the Pivot table page field selection in 2 tables?
  589. Values Distribution Across Months
  590. IF value in Y cell = X color Z cell
  591. Delete All Links to Worksheet
  592. SUMPRODUCT usage
  593. What does 'floating dollar sign' mean?
  594. How do you use a blank in a formula in Excel - If a1 is blank
  595. moving several columns into 1 continuous column
  596. Cell flashing
  597. IF value in a cell, return another cell's value to original cell
  598. VLookup?
  599. Linked workbooks
  600. Locking Columns in excel
  601. Finding duplicate cells within a worksheet automatically
  602. Hyperlink
  603. PPMT Function Repost
  604. IF Help
  605. Formula suggestions
  606. Formula Help data match up
  607. in the worksheet, a1 to a10 have numbers. I want to calculate to a
  608. Locate data from 1 column in another
  609. Is there a formula that doesn't change current cell if false?
  610. conditional formating if and And
  611. Revome blank spacing from ending Numbers
  612. EXCEL Help please
  613. COLUMN() problem with array formula
  614. PARTIAL MONTH DISTRIBUTION
  615. array formulas counting substrings across rows
  616. Need Improved String Formula
  617. SUM Formula and Logical Values
  618. Convolution
  619. Getting wrong answer with Match Function
  620. Euro symbol displays as dollar symbol in Excel
  621. Update a hyperlink in excel spreadsheet
  622. Average by Multiple Criteria.
  623. Formula Help for Counting categories in a column
  624. comparing columns to find dup's
  625. Formula Help
  626. Date Prompt for 1 day
  627. Variable Symbol
  628. Consolidate 3 lists with duplicates into one list
  629. Transpose columns into continuous rows
  630. Autofill column from data (code) in column next to it
  631. Returning multiple values that are NOT in a single column or row
  632. Multiple If Statements
  633. 1 Vlookup multiple results in different columns
  634. If formula
  635. Duplex Printing Macro
  636. Top 25 List of Times
  637. index and match on 2 criteria
  638. Data Sort header row
  639. Accumulator
  640. Format text in formula line
  641. Problem with Vlookup
  642. Average function
  643. Row increments -
  644. Converting decimals to Time
  645. Max number in list of duplicates
  646. per centages and sums error
  647. Is there a formula for....
  648. how to create an absolute value
  649. SUMPRODUCT - Creating a weighted score in column with subtotals
  650. Nesting IF to correct #VALUE! Error Message
  651. Nesting IF funtions
  652. Dependant drop down list with more than two words in the options
  653. Check for a word
  654. Transfer Information
  655. 2007/macros not working
  656. If - Then statement
  657. Find and replace *
  658. Custom date fields for pivot tables
  659. Check Box
  660. create a automatice invoice from a data extract
  661. Conditional Formatting
  662. SUMIF, wrong result, strange behaviour
  663. Conditional formula with multi tasks
  664. How to consolidate 580 file's data in 1 sheet without oppening all
  665. bug in excel 2007 for sorting function?
  666. Want a trace a same values exist in two different sheet
  667. Matching & adding text in the respective column
  668. Formula for Multiple Variables.
  669. first and last occurance
  670. How to get text which is inside the brackets in excel sheet
  671. RANK ABSOLUTE NUMBER AND WITHOUT GAP
  672. linked data
  673. Start Day of Bi-Monthly Pay Period
  674. Define cell value in a matrix to add up 2 constraints value
  675. compare two or more ranges
  676. Compare ranges
  677. Cleaning a list in Excel
  678. create table of selected rows
  679. Lookup Question
  680. Date open file with date saved
  681. calculating percentage of year passed (for sales reports)
  682. Average a group of numbers within an date range.
  683. Not Counting cells that have a formula with ""
  684. I need a lookup function using range names!
  685. Custom Toolbar from Excel 2000 to Excel 2003
  686. Drop down list from another worksheet
  687. Sumif based on criteria on another cell
  688. Counting rows that meet multiple criteria
  689. Counting rows that meet multiple criteria
  690. Multiple formulas in a single cell referencing a drop down box.
  691. Data Validation
  692. How to sum cells based on conditions
  693. Custom Number Format
  694. EXCEL Pivot Table
  695. Worksheet is not calculating
  696. Drop Down List
  697. Sumif based on value in cell
  698. Automatically insert a line
  699. conditional formatting based on different cells with more conditio
  700. What function do I use
  701. sum table
  702. Conditional Function
  703. MROUND
  704. Look Ups and Matches, Sorry if current thread exists- Clueless
  705. List Box and IF function
  706. Duplicate data entries
  707. Vlookup Different tabs based on Dates
  708. simlple question
  709. Lookup table for rates?
  710. concatenate won't work
  711. minimum value in a column, which row no?
  712. Conditional Formatting Using Min/Max
  713. Using V or H lookup
  714. "Validation" question
  715. Converting time to number, i.e. 2:32 to 2.32
  716. Countifs
  717. Concatenate Dates
  718. Sumif query
  719. Automatically add and subtract
  720. Formula behind functions
  721. Comparing 3 Columns
  722. combobox listfillrange network
  723. Automatic add & subtract
  724. One text for particular period
  725. average with N/A
  726. Formula to count duplicates
  727. Pull cell contents from one wksh to another if condition is met
  728. Conditional functions on portions of cell data
  729. Logging information
  730. Keep Leading Zeros in Concatenation
  731. Formula for selecting a Leap Year.
  732. Track Changes- Working Partially
  733. LOOKUP returning wrong values
  734. All my textbox disappear..
  735. IF and AND statement
  736. close match
  737. unique entry sum
  738. How do I convert 1000 to One Thousand (i.e numberic to words)?
  739. Sum if unique and another criteria
  740. insert and copy
  741. disable brian baulsom's worksheet change based on cell value.
  742. how do i open an ods file in excel?
  743. Forumals not showing correct result (unless edit and enter)
  744. Excel formula question...
  745. Self Population of Date Function
  746. count number of dates in a row of cel before or after a variable d
  747. VLOOKUP displaying "NO ANSWER" instead of "0"
  748. Can I use cell data for a web search & bring back in the results?
  749. vlookup???
  750. Medians of data
  751. conditional formula with lots of conditions
  752. Can't sort with Excel 2007
  753. conditional list
  754. search data and display colunm headers
  755. Vlookup and column reference problems
  756. TURN OFF AUTO-HIGHLITE
  757. change date format without retyping dates
  758. symbals
  759. Close Match
  760. Copying Cells to new row on different worksheet
  761. Link to another workbook path issue
  762. extract items from filtered list
  763. comparison function
  764. vlookup removing characters
  765. circular reference - iteration
  766. Need help with a function for a golf match spreadsheet
  767. How do I make a box with a check mark when clicked?
  768. INDEX MIN function?
  769. Math Functions Not Working Properly
  770. Countifs
  771. Random Sample with multiple data points
  772. Return two random lines
  773. Vlookup Using a Reference as a Table Array
  774. How can I remove the header and footer on the excel 2007 sheet?.
  775. Drop down menus
  776. Excel Formula
  777. Excel: graduating fees based on account value
  778. Viewing of protected locked or unlocked cells
  779. Count if unique
  780. Vlookup questions
  781. how do i filter records with greater number across rows
  782. Need a function to match up jobs
  783. IF Function and pulling data across
  784. Validation I Hope
  785. Count With Multiple Criteria, please help!!
  786. Excel Conditional Formatting (Compare Vals in 2 Columns)
  787. add another subtotal row to an expense column?
  788. Copying Conditional Formatting rule
  789. Unprotect 2003 excel files when opening in Excel 2007
  790. Unprotect a worksheet
  791. Another IF statement question
  792. Return filtered values into report worksheet based on filtered valueon the data worksheet
  793. Step up or Down payments
  794. FORMAT CELL TO MILLIMETERS
  795. perpetual inventory - stock level - math flow??
  796. Auto Correct Option
  797. Searching String for phrases/multiple text strings
  798. Macros
  799. Using VLOOKUP to locate an answer in one of multiple columns
  800. Count If Column A = x and Column B = y
  801. Concatenate N cells (where N is a worksheet value)
  802. EXCEL:HOW DO I CHANGE COLOR IN CELL BY TYPING IN ANOTHER WORD?
  803. Refer to Another Spreadsheet in a Formula
  804. Excel 2007 overwriting Hidden Rows
  805. Mulitple value lookup
  806. Automatic Macros
  807. PPMT Function
  808. how do i rearrange columns in a work sheet
  809. DCOUNT Help
  810. Hyperlink
  811. Watch Window
  812. how to add date and time to a single cell in MS Excel 2007
  813. Hide Rows If Condition True
  814. To choose the best field in EXCEL
  815. Transpose Issue from Columns to Rows...
  816. Accumulated percentage calculation
  817. Copying a formula
  818. formulas do not work
  819. To extract content fo cells from many workbokks which are identica
  820. Calculation based on certain criteria
  821. Calculation of incentive
  822. Problem with >= in function
  823. Help with worksheet event
  824. Apply Conditional Formatting to other rows
  825. Value function
  826. Estimates with multiple look ups
  827. A UNIQUE FORMULA
  828. 9 Assessments but want the students 7 best results
  829. IF FUnctions that produce TEXT results
  830. Conditional formatting multiple cells from one cell to another
  831. Excel formula question
  832. EXCEL 2007 - INSERT NEW WORKSHEET
  833. How to make SUMPRODUCT work over range that includes text?
  834. On error
  835. Naming Cells Using Relative Cell References
  836. I want to undo 'move or copy worksheet'
  837. loan to value function?
  838. Capturing Top 5 Performers
  839. I want to tally my sheet
  840. Sorting Linked Data Between Sheets
  841. how we find specific word from string in excel and compaire it.
  842. Running Total
  843. Worksheets
  844. Help with data total
  845. sort source data sheet while destination shows same data
  846. IF function using two worksheets and various data
  847. Constant in Excel Formula
  848. INDIRECT(ADDRESS) inside a VLOOKUP
  849. need sumproduct to return text values...
  850. Length of Service and Vacation Hours Accrued
  851. Grouping IF/AND/OR in a single formula
  852. Breaking down a cell to create a function
  853. IF cell contains part of text
  854. Format for a cell with a formula in it but I don't want the 0 to c
  855. Reference previous worksheet within VLOOKUP
  856. Vlookup Cell Format
  857. PASTE DOESNT WORK
  858. new macro to format worksheet
  859. SumIf or SumIfs or something else?
  860. Lottery function - how to randomly select cells
  861. What is the function to randomly select a cell, like for lottery?
  862. Concatenating two variable fields into a static length text field
  863. use Hlookup to look up two or more values
  864. roundup with index,match,subtract,divide and add formula
  865. If Statement Question
  866. IF Formulas
  867. Apply Global Formula
  868. repeating formula on calendar
  869. Multi column sumproduct
  870. Sumif linked to different workbook
  871. FIND IF A CELL CONTAINS TEXT
  872. entering a number and having a word appear in excel
  873. how do I substitute precedants in long excel formulas
  874. Macro
  875. normalize score
  876. vlookup (indirect, or sumproduct) using three tabs
  877. Data Validation
  878. matching Data
  879. Copying formulas in range and pasting in a selection
  880. Pickup the content of Cells ( in formula)
  881. display first or second match instead of #REF in INDEX ROW formula
  882. Select data from two worksheets to the left
  883. Use Like in Vlookup
  884. Slicing Data (Alternative to SUMIFS)
  885. Sumproduct Question
  886. Formula Help
  887. SUMIFS and dates
  888. index and match, then subtract, divide and add for my final answer
  889. "IF" function returns function instead of result
  890. Sorting Unorganized Data Into Different Spreadsheets
  891. IF function returns function statement rather than result
  892. COUNTING
  893. Finding an item in a list & returning a specific value
  894. How to convert PDF tables into Excel??
  895. Help with VLOOKUP & MATCH formula
  896. Format single character
  897. Current Cell location
  898. Alternative to using 10 V-lookup formulas
  899. Text into Columns
  900. Lookup Dynamic Value in a Table
  901. Method for creating formulas to reference different worksheets?
  902. How do I recalculate cell only if reference cell value changes?
  903. Percentage over a date range
  904. data associated with latest date
  905. data in 2nd column associated with =MAX(H1:H100) from another colu
  906. CANT INSERT CELLS, ONLY ROWS & COLUMNS
  907. how to move contents in column up one cell
  908. How to count/tally entries?
  909. Can't save Excel spreadsheets
  910. Today() function
  911. Text to rows
  912. How do I complete this nested if formula
  913. Lookup Function
  914. Calculate the number of hours in a date/time cell
  915. Is there a Conditional Sum Wizard in Office 07? If so Where
  916. Time/priority problem
  917. Using Indirect with an Index Match Function
  918. Errors encountered when using If & Vlookup formulas
  919. How to equal a cell in another worksheet incl fill colour
  920. Taking Average ignoring #DIV/0! in the range...
  921. EDATE Function disappears intermittently
  922. Quarters
  923. solver an uxexpected internal error ocurred, or available memory
  924. filtering or selecting data baseed on time of day
  925. displaying changes
  926. How does one use a formula to bring over the formatting as well
  927. Deleting rows or columns
  928. SUMIF formula with non contiguous cells
  929. how do I look for cells showing dates less than a certain date?
  930. Calculate Interest Rate
  931. EXCEL PASTE DOES NOT CHANGE DATA - PASTE DOESN'T WORK!
  932. Display a number in feet inches and fractions of and inch
  933. combining data from multiple workbooks
  934. Adding a pre-fix to each item in a cell
  935. Stuck on Formulas
  936. Duplicate check
  937. macro writing
  938. Split text file into Excel sheet and separate the final results intoa new sheet
  939. Return column header as solution to lookup
  940. Vlookup with multiple workbooks
  941. Cell format for an array formula containing text
  942. Copy worksheet from one workbook to a master workbook
  943. External reference to a Column
  944. Macro to apply parsing rules for strings and list the substrings
  945. Help Calculating Partial Months between 2 dates.
  946. Confirmation Security
  947. Vlookup
  948. Calculate Date
  949. Pearsons
  950. Data Validation using a table
  951. Text to Number
  952. How do I only send 1 worksheet of a file in an e-mail?
  953. IF Statements
  954. I cannot use DIAS.LAB in my Excel (Spanish)
  955. IF(AND(OR function returns #VALUE! error
  956. Headings of columns now have numbers, need to change them to lette
  957. Pivot Table - Old remaining values for rows
  958. count formula question
  959. Help Calculating Time
  960. Date Range
  961. Flatten password file
  962. style sheets vs cell formatting
  963. How do I ADD characters to the data for a group of cells?
  964. Time Calculations
  965. Adding values in first "X" number of rows dynamically
  966. Highest Values Comparison
  967. mean of range of dates
  968. Lookup Problem with Index and Match
  969. Vlookup Error
  970. HOW TO I GET LOOKUP TO USE THE SAME RANGE EVERYTIME
  971. Multiple results of Unique Values
  972. SUM depending on date
  973. Excel virus?
  974. How do I bracket text in cells by formatting a whole column?
  975. Check register running balance to another worksheet
  976. how do I use a cell from one worksheet in the equation of another
  977. Numbers of repeats of a string
  978. External excel file for pulldown list source
  979. Sum cells that have both alpha and numbers
  980. excel function help
  981. Increase Values by Percentage
  982. Highlighting the entire row with conditional formatting
  983. Need Function Help
  984. Subtracting Military Time
  985. Symbols
  986. Percntages
  987. Advanced Filter
  988. Displaying "0" Values
  989. Can't Prevent Recalculation
  990. how do I create a nonadjacent series for autofill to go by?
  991. Cell not available when inputting formula
  992. Convert numbers to words
  993. Difference between 2 dates&time(format 0000), and excludes weekend
  994. Concatenate unique values among duplicates
  995. Excel Charts with Data Tables
  996. Remove e-mail address from general text field.
  997. Searching on 2 columns and putting result in third column.
  998. Macro for detect palindromes and repeats in letters/numbers string
  999. I need help desperately !! I need a formula that will allow me to match cells...
  1000. Conditional Format