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

  1. Conditional Formatting Using Min/Max
  2. minimum value in a column, which row no?
  3. concatenate won't work
  4. Lookup table for rates?
  5. simlple question
  6. Duplicate data entries
  7. Vlookup Different tabs based on Dates
  8. List Box and IF function
  9. Look Ups and Matches, Sorry if current thread exists- Clueless
  10. MROUND
  11. Conditional Function
  12. sum table
  13. What function do I use
  14. conditional formatting based on different cells with more conditio
  15. Automatically insert a line
  16. Sumif based on value in cell
  17. Drop Down List
  18. Worksheet is not calculating
  19. EXCEL Pivot Table
  20. Custom Number Format
  21. How to sum cells based on conditions
  22. Data Validation
  23. Multiple formulas in a single cell referencing a drop down box.
  24. Counting rows that meet multiple criteria
  25. Counting rows that meet multiple criteria
  26. Sumif based on criteria on another cell
  27. Drop down list from another worksheet
  28. Custom Toolbar from Excel 2000 to Excel 2003
  29. I need a lookup function using range names!
  30. Not Counting cells that have a formula with ""
  31. Average a group of numbers within an date range.
  32. calculating percentage of year passed (for sales reports)
  33. Date open file with date saved
  34. Lookup Question
  35. create table of selected rows
  36. Cleaning a list in Excel
  37. Compare ranges
  38. compare two or more ranges
  39. Define cell value in a matrix to add up 2 constraints value
  40. Start Day of Bi-Monthly Pay Period
  41. linked data
  42. RANK ABSOLUTE NUMBER AND WITHOUT GAP
  43. How to get text which is inside the brackets in excel sheet
  44. first and last occurance
  45. Formula for Multiple Variables.
  46. Matching & adding text in the respective column
  47. Want a trace a same values exist in two different sheet
  48. bug in excel 2007 for sorting function?
  49. How to consolidate 580 file's data in 1 sheet without oppening all
  50. Conditional formula with multi tasks
  51. SUMIF, wrong result, strange behaviour
  52. Conditional Formatting
  53. create a automatice invoice from a data extract
  54. Check Box
  55. Custom date fields for pivot tables
  56. Find and replace *
  57. If - Then statement
  58. 2007/macros not working
  59. Transfer Information
  60. Check for a word
  61. Dependant drop down list with more than two words in the options
  62. Nesting IF funtions
  63. Nesting IF to correct #VALUE! Error Message
  64. SUMPRODUCT - Creating a weighted score in column with subtotals
  65. how to create an absolute value
  66. Is there a formula for....
  67. per centages and sums error
  68. Max number in list of duplicates
  69. Converting decimals to Time
  70. Row increments -
  71. Average function
  72. Problem with Vlookup
  73. Format text in formula line
  74. Accumulator
  75. Data Sort header row
  76. index and match on 2 criteria
  77. Top 25 List of Times
  78. Duplex Printing Macro
  79. If formula
  80. 1 Vlookup multiple results in different columns
  81. Multiple If Statements
  82. Returning multiple values that are NOT in a single column or row
  83. Autofill column from data (code) in column next to it
  84. Transpose columns into continuous rows
  85. Consolidate 3 lists with duplicates into one list
  86. Variable Symbol
  87. Date Prompt for 1 day
  88. Formula Help
  89. comparing columns to find dup's
  90. Formula Help for Counting categories in a column
  91. Average by Multiple Criteria.
  92. Update a hyperlink in excel spreadsheet
  93. Euro symbol displays as dollar symbol in Excel
  94. Getting wrong answer with Match Function
  95. Convolution
  96. SUM Formula and Logical Values
  97. Need Improved String Formula
  98. array formulas counting substrings across rows
  99. PARTIAL MONTH DISTRIBUTION
  100. COLUMN() problem with array formula
  101. EXCEL Help please
  102. Revome blank spacing from ending Numbers
  103. conditional formating if and And
  104. Is there a formula that doesn't change current cell if false?
  105. Locate data from 1 column in another
  106. in the worksheet, a1 to a10 have numbers. I want to calculate to a
  107. Formula Help data match up
  108. Formula suggestions
  109. IF Help
  110. PPMT Function Repost
  111. Hyperlink
  112. Finding duplicate cells within a worksheet automatically
  113. Locking Columns in excel
  114. Linked workbooks
  115. VLookup?
  116. IF value in a cell, return another cell's value to original cell
  117. Cell flashing
  118. moving several columns into 1 continuous column
  119. How do you use a blank in a formula in Excel - If a1 is blank
  120. What does 'floating dollar sign' mean?
  121. SUMPRODUCT usage
  122. Delete All Links to Worksheet
  123. IF value in Y cell = X color Z cell
  124. Values Distribution Across Months
  125. Synchronize the Pivot table page field selection in 2 tables?
  126. Office 2003 Excel funtion - data table
  127. Re: Outline/group data below
  128. compare date and perfom calculation
  129. Counting cells that have a checkbox that is marked
  130. Insert a cell value into a link to another worksheet.
  131. Extracting certain text from text string
  132. Vlookup, Column Index Num and Autofill
  133. Open Workbook Formula
  134. view excel in full screen view
  135. Text Search
  136. Macro with sum function
  137. linking between spreadsheets
  138. Count Num of Unique items in col ?
  139. Count Num of unique items in col? by 3 criteria
  140. calculate percentage??
  141. Trying to randomly choose a number from a set list of numbers
  142. Trying to randomly choose a number from a set list of numbers
  143. Trying to randomly choose a number from a set list of numbers
  144. finding top 80% line from a descending list
  145. HYPERLINK
  146. How do I move addresses in my contacts into an excel format?
  147. Variable reference in a function
  148. comparing and isolating duplicates in two columns
  149. why does worksheet require two different forms of same formulas
  150. returning a SUM from text.
  151. Flashing cells
  152. Extracting all matches
  153. Trapping errors in a VLOOKUP function
  154. How to refresh links across workbooks
  155. Flow Chart
  156. link data from several speadsheets
  157. Vlookup using a dropdwn list, check different tables based on drop
  158. Having trouble printing without the cell gridlines on new system
  159. Excel formula help
  160. random between function
  161. view excel worksheet & freeze internet window synchronously
  162. Excel to inport data
  163. two column lookup
  164. Long Date Format
  165. scrolling
  166. Function to display text
  167. Copy functions from one file to another file
  168. combining vlookup and hlookup functions
  169. Function to autofill remaining width of a cell
  170. I need a self calculating time sheet for Excel 2000
  171. Coutn specific cell with specific value
  172. How do I find the distribution of a sample mean????
  173. Conditional Formatting
  174. Challenging SUMING situation!
  175. to pull out information from certain cells of hundred identical wo
  176. How can I transpose cells associated with a merged cell?
  177. Tranfer of data via v &/or h lookup
  178. Excel 2002 count color
  179. Pick up some text in a cell
  180. Filtering based on Value
  181. Creating new worksheets
  182. Open XL - A Powerful Excel Addin
  183. Open XL - A Powerful Excel Addin
  184. Hyperlink to cell in separate workbook
  185. Conditional formatting, change row to certain color
  186. Formula to count the number of unique dates
  187. Column Number of a cell with text
  188. Multiple Instances in a Column
  189. Missing info on worksheet
  190. How to change the row1 content of the existing excel file automically
  191. Time difference btwn entries
  192. Finding Multiple Instances in a List
  193. data alteration
  194. Please HELP!
  195. Return first date populated
  196. Need to get Address() to Average Function Range argument
  197. Differences between columns
  198. Excel 07 worksheet problem - HELP!!
  199. help with vlookup and return based on a formula
  200. Formula Help
  201. How do I calc the time difference in hh:mm for shift work?
  202. flashing cells
  203. Flashing cells
  204. Posted in excel.public.programming ... Count only theformula/function find the same value ...
  205. If fomula
  206. How do I carry the calculations over to the various worksheets
  207. Consolidate Multiple Workbooks - Excel 2007
  208. Macro for Proper function
  209. YTD Calculation using SUM and OFFSET
  210. using COUNTIF I want to count multiple values
  211. Duplicate Rows
  212. Cell Reference Issue
  213. Max Value of conditional list
  214. Countif IsErr
  215. Currently using '97 version.... Should I buy Office 2007 or 2003??
  216. SUMPRODUCT formula help??
  217. Help with formula to round up to next higher multiple of 5
  218. Vlookup across several sheets
  219. Help! Rounding Up Formula
  220. How to check the whole column at the same time?
  221. sumif function
  222. From multiple reporting people able to indentify next due report
  223. How do i create a drop down list from information on another works
  224. CountIf Condition based on lookup in a list of values
  225. Conditional lookup
  226. Automatic notifications of changes?
  227. Hyperlink
  228. Is there a formula to calculate the least common denominator?
  229. Substitute
  230. Can't merge info from Excel onto address labebls
  231. LOOKUP between two columns of diff. size
  232. If Unction with text
  233. How do I create a custom button that combines format settings?
  234. Calculating Dates
  235. Multiple selection criteria
  236. Benford law option available in Microsoft Excel
  237. Due date - change cell color
  238. how do I merge multiple csv files in one Excel file?
  239. conditional formatting is not avaible
  240. How do I get numbers to foot across rows and colums?
  241. How do I get numbers to foot across rows and colums?
  242. Formula
  243. Data Tools - Consolidate Excel 2007
  244. Calculating Time
  245. Duplicate Difficulties
  246. Text to number value
  247. Change Color on rows, after an IF Funtion is answered
  248. Bold a line
  249. Highlight Cell Changes When Using Data Connections to Access
  250. Need a fresh pair of eyes
  251. Help with Average formula
  252. count month when date is in day/month/year format
  253. HOW to built a IF formula , if any test fails, none of the other onesto be done ?
  254. combining COUNTIF and OR functions
  255. HOW to built a IF formula , if any test fails, none of the other onesto be done ?
  256. Equation Efficiency?
  257. Stat testing %s between 2 groups
  258. Help with automatically sorting data
  259. Excel conditional format only if all cells contain values?
  260. Vlookup & return multiple unique values
  261. Countif
  262. Display time in text
  263. count number of dates falling in the next seven days
  264. V LOOKUP
  265. Pivot Tables: Excel 2003 vs Excel 2007
  266. Summarize & Delete
  267. Summarize & Delete
  268. Leap Year
  269. Excel is seeing the date as dd/mm/yyyy
  270. VLOOKUP PROBLEM
  271. Fill Color related to % complete
  272. Multiple cells to look up and return values to another spreadsheet
  273. Split screens
  274. Largest number
  275. How do I create an Inventory list using Excel
  276. calculate fractions using dates
  277. Largest number 2
  278. Hide Alternate Rows temporarily to Edit worksheet
  279. Function =Trim()
  280. Function =Trim()
  281. How to convert "read only" to a working sheet?
  282. handle error in IF ELSEIF statement
  283. Advanced Filter - Named Ranges
  284. Nested formula Value error
  285. date & time
  286. Combining use of Check Box and Option Button
  287. Extract value from a text string
  288. Sum a range that IS NOT NULL
  289. formulas
  290. Automatically add a column to summary sheet if another worksheet i
  291. How to return unique values only
  292. How do I lock a section of cells in place
  293. Getting data by calling out date
  294. How to get rid/hide #NUM! error in Excel 2003?
  295. VLOOKUP Errors with Date formats
  296. Allow Delete cells but not rows
  297. How to get timein hh:mm format
  298. Mark certain cells
  299. Sumproduct - multiple Sum ifs
  300. how do i add same prefix any text or number to the large datas?
  301. Regex Syllables, Harlan Grove?
  302. 2 conditions for IF function?
  303. CF to grey out the two unused options
  304. Conditional formatting - case sensitive text
  305. filter imported data to columns
  306. Invalid outside procedure (creating a PDF button as a macro)
  307. How does a module of VB work in a Worksheet?
  308. expandable Text Box
  309. Excel Function
  310. Convert a 8X3 table to a vertical range of the Unique strings only
  311. How to average random cells with out counting zero?
  312. Drop down menus
  313. Number of days in a specific month between various start and end d
  314. Trailing zeros
  315. Why would a vlookup function stop working in excel 2003?
  316. worksheet
  317. Excel
  318. Conditional Formatting HELP
  319. Multiple values for LOOKUP? Maybe add IF clause?
  320. compare rows for a match and sum the matches
  321. Countif – Multiple column criteria – with “does not contain”
  322. How do you reference another worksheet without using its name
  323. How do you reference another worksheet without using its name
  324. How do you reference another worksheet without using its name
  325. Vlookup with Match - no results issue
  326. if then statements
  327. Excel work book
  328. COUNTIF or SUMPRODUCT
  329. How to calculate worked weekend days
  330. Customise a Date to display as something else
  331. Number to word
  332. Formula to get
  333. Formula to get the Ans
  334. Sumproduct not works
  335. Sumproduct not works
  336. Can't edit worksheet
  337. VBA Sheets.Add disabled
  338. Data sorting formula
  339. If statement to copy an entire row to other worksheet w/ in same b
  340. variable in data validation
  341. Need multiple IF questions & return a value from another worksheet
  342. what is the purpose of . bars
  343. How do I?
  344. my excel spread printed the cell numbers and letters/what's wrong
  345. Re: my excel spread printed the cell numbers and letters/what's wrong
  346. Combine IF function with manual entry
  347. comparing two columns
  348. Embed Data from a named Range into a text box
  349. Determine decimal
  350. sorting data
  351. Conditional Formatting Problem - Dynamic Formula??
  352. comparing two columns revisited
  353. Counting values in column B in condition of A
  354. Another table lookup question
  355. help with date funciton
  356. have an entire row populate with a link when the data in a cell ca
  357. have an entire row populate with a link when the data in a cell ch
  358. information automatically changes
  359. Ties using Rank Function
  360. change feet and inches to decimal inches
  361. return second or third word in a cell
  362. counting in columns
  363. Need additional coding help
  364. Formatting Cells and then deleting the reference column
  365. How do I weight numbers when some are zero without getting DIV0
  366. Background and Calendar
  367. looking for a rental property expense income worksheet
  368. GETPIVOTDATA Excel 2000
  369. Displaying Cell Formulas (without using Tools/Options/View-Formula
  370. Display Multiple Worksheets
  371. Help IfBlank use data from next cell
  372. Exce Formating
  373. workbook totals
  374. When there is a tie for "MAX" values...
  375. Help on IF (i think)
  376. Sheet direction, extract data from comment
  377. convert [h]:mm:ss to real number that I can use as a multiplier
  378. counting in columns
  379. Can users perform a reverse lookup
  380. Problem with VLOOKUP
  381. How to set up a devilery schedule calendar from excel database
  382. COUNTIF Function Provides Text Feedback, Not Values
  383. Can anyone
  384. count across 3 columns
  385. How do I get my shortcuts to stay on the Quick Access Toolbar?
  386. countif question
  387. Duplicating check boxes with formulas
  388. How to reference last non-blank cell value from a column cells?
  389. address of first and last number in a row
  390. Counting the number of occurrences...
  391. Column Titles
  392. COUNT and SUM
  393. Formula/Sum Question
  394. copy conditional format without using format painter
  395. unions, intersections or array constants
  396. Search a name in one sheet and entry it into another sheet
  397. Removing Mulitple Carriage Returns Within a Concantenate Formula
  398. Is there a way to use Formula to resolve
  399. hlookup value within a range
  400. COUNT and SUM (please help!)
  401. To work out how many days, weeks, months to I retire on 20 Sep 201
  402. Approximate match on string of text
  403. days and time functions
  404. =sum
  405. ifblank function
  406. How can I stack worksheets (I have 30 worksheets)
  407. Conditional formula based on 2 pre-conditions
  408. How do I get my Excel 2007 worksheet to go beyond 65536 rows?
  409. AUTOMATICALLY ADJUST COLUMN WIDTHS TO CONTENT
  410. Countif range contains part of a value
  411. Hiding sum formula answers in select cells
  412. Auto-adjust formulas
  413. how do I reverse alphabetizing?
  414. Hiding Formula Answers in Specific Cells
  415. running macro's in Excel 2007
  416. More than one variable for Countif
  417. Getting the "0" out of an auto populate cell.
  418. Std Dev of Aged Inventory
  419. Developing Aging report-problem with 'if' statement
  420. How do I sum the last 5 nonzero numbers in a row?
  421. How do I locate cells that contain a certain text?
  422. Export row depending on column to various sheets
  423. Cell reference within array
  424. Lookup 2 values and return a third
  425. CountIf Functions
  426. repeat row labels in pivot table
  427. "Go Back" Feature and hyperlink
  428. Financial Functions, in particular, the INTRATE function
  429. repeating the answer in A2 cell to A3:A20
  430. Using COUNTIF and OR
  431. Percentage of Multiple Rows
  432. sumif any text is criteria
  433. Help with 'If' function
  434. Edit formula over a range
  435. VBA code for find function (reference cell value)
  436. partial match in vlookup with table array
  437. IF Statements using previous cell references
  438. I enter a formula but the results are not displayed
  439. Calculate score from Scale
  440. Deleting rows
  441. Updating a Formula Based on Multiple sheets
  442. GETPIVOTDATA on Excel 2000
  443. how can you add attachment at the spread sheets
  444. Search of particular combinations
  445. AVARAGE TIME
  446. Formula or Macro
  447. Upper case to Lower case
  448. Highlight selected cells only
  449. How do I use vlookup to return a formula not a result
  450. Vlookup Question
  451. sumproduct formula help
  452. Learn Macro & VB Code that usually put in Excel.
  453. Using Indirect for conditional Formating
  454. List to Table - formula
  455. vlookup lookup_value text
  456. Need an expression that's larger than my skill
  457. COUNTIF on NonContiguous Cells?
  458. while entering credit card numbers last number changes to zero
  459. Generate reports on separate tabs from data in file
  460. in range?
  461. "copy"
  462. setting up networkdays
  463. fix #N/A error
  464. Formula for attendance record
  465. Assigning a Worksheet Name to a Cell
  466. lock cell whit first value
  467. Splitting data from cells into multiple lines
  468. how can I isolate the data in a worksheet from the rest of the pa
  469. Go to cell address
  470. counting the number of rooms
  471. Count NonBlank Rows with Criteria in another column
  472. Copy last cell with data in column E on one sheet to cell on anoth
  473. Converting Minutes and Seconds ([mm]:ss) to Decimal
  474. dragging formulas across rows
  475. If Function returning 0 instead of cell value
  476. How do I set a maximum value (e.g. cap at 200)
  477. Question about condition formatting?
  478. RE: Converting Values to Columns??
  479. Number of characters in a cell for a Index/match function
  480. Excel Formulas
  481. Sum Across Multiple Sheets
  482. using the address referenced in a linked cells
  483. Fill down not working in Excel 2007
  484. How to use formula to the Ans
  485. Conditional Format
  486. Multiple variable lookup tables
  487. Change Row Colour if certain criteria is met
  488. Fill Series function question
  489. can we count words in a row which has links from other file
  490. How can I get a drop down to update the range of a formula
  491. Vlook up with if statement
  492. Displaying multiple non-adjacent cells with 1 criteria
  493. Solution for if x = 1 and Y =2 goto C3
  494. Weeknum
  495. auto/coditional format
  496. push result from one cell to another
  497. Vlookup in multiple columns
  498. IF Statement using several columns
  499. In Excel 07, how do I merge two sprdshts with a common column?
  500. Help with LOOKUPS
  501. Hide Blank Rows
  502. IF Statement
  503. Excel - Check Box Functions
  504. convert seconds to hours and days
  505. how to count charactors in a cell
  506. sort and blank cells problem
  507. Subtotals in Excel 2007
  508. Help with Lookups
  509. PDF macro button
  510. Cell Protection
  511. Find and copy for inventory
  512. Dynamic List of names?
  513. decrease integers to zero
  514. How do I link 2 spreadsheets to insert amounts on a defined date?
  515. Text from a comment box into a cell
  516. Como alterar o cabeçalho das coluna de algarismo para letras
  517. Calculate End Date (excluding weekends and holidays)
  518. VLookup - find new items
  519. Please help - Find & copy Macro
  520. Calculate items based on calendar year ending today
  521. ISTEST Function
  522. if formula
  523. calendar control for week day
  524. CountIf on Date / Time
  525. Conditional Testing of an array
  526. got #REF! with fomula PRICE()
  527. Sum of constant decrement
  528. Lookup for a word in a table
  529. copy cells daily and automatically
  530. Text from a comment box into a cell
  531. Attendance formula
  532. Formula for giving point to particular no.
  533. adding TIME through midnight calculates ok, but subtract doesn't
  534. EXCEL function;find string in entire column & return cell referenc
  535. countif = to
  536. IF Formula Question
  537. Conditional formula
  538. how do i see my whole document in the workbook
  539. Data is not printing inside cells in excel
  540. If cell not null use that value
  541. Temp vaiables in formulas?
  542. Adding cells of same conditional formatting
  543. stop error message "too many different cell formats"
  544. Is this function supposed to work?
  545. Row Number of VLOOKUP result
  546. If Function
  547. INFO("directory") function
  548. Counting text in two different columns
  549. SUMPRODUCT formula
  550. How do I remove auto filters from a file I exported out of Salesfo
  551. If I am within the time specified..?
  552. Conditional Formating
  553. Sharing data from one worksheet to another
  554. Transferring CERTAIN Data from one worksheet to another
  555. change a group of cells to absolute
  556. Conditional Formatting
  557. Rapidly Create a Large Number of Named Ranges
  558. Flagging dates with conditional formatting
  559. Assign password to "Very Hidden" worksheet
  560. Excel 2007-SUMMING from different worksheet conditional to the dat
  561. Sum of Price Given Specific Dates
  562. Can the Excel cell fill color be changed using "IF" statements?
  563. Cannot verify XNPV with PV or HP-12C
  564. IF with and OR
  565. Can Excel's field fill colors be changed using "IF" statements?
  566. weighted exams, predicting what the final exam needs to be to pass
  567. Typing in a list to locate name (Excel 2003)
  568. conditional formatting using formulas
  569. Conditional formating based on multiple comparisons
  570. COUNTIF greater than one column and less than another
  571. Many possible variations
  572. How do you assign a Workbook Location Path to a cell?
  573. what does the & symbol do in a formula?
  574. Vlookup issue
  575. permutations
  576. Lookup or Vlookup?
  577. Trying to HLOOKUP a value from another sheet and display all the d
  578. One less than Max
  579. moving from one sheet to another from a cell of a sheet
  580. how format date with TEXT() function for international usage?
  581. Coding Custom Date Functions in Excel
  582. macro protection
  583. Sum values in string in a cell
  584. Absolute Reference Changes
  585. Conditional format Order
  586. Combinations - multiplied sum of doubles, triples, quadruples.....
  587. EXCEL: find string in vector & return cell reference
  588. Selecting data in a specific date range using COUNTIFS function
  589. transpose data
  590. Format Cell using letter & number to use in mail merge
  591. Adding a zero to the front of numbers
  592. Difficulty cleaning some char(63) characters
  593. Nearest Month
  594. creating tabs with sub tabs
  595. Cell color changes when date gets closer
  596. TOTAL OF A RANGE SHOULD BE
  597. Importing CSV Data from Web?
  598. Count If trouble
  599. DATEDIF function in excel
  600. How to display result of 3 possible outcomes
  601. How can I create multiple tables of figures?
  602. Click and drag a formula
  603. Link from 2007 to 2003 Version
  604. Item Lookup
  605. Time & Date Formulas
  606. Links won't update if file is closed
  607. Eliminating duplicated data completely or something similar
  608. can I write a function that automatically changes over time
  609. 0.5883698 Does This Look Good? ... 0.7272271
  610. sumif - if the text has LCI in it
  611. workbook_open() does not execute if there are conditional formats
  612. fromula error
  613. convert number to intext
  614. Time difference function
  615. Need help with formula in excel
  616. Hep with Find and Replace
  617. Find the Date of the Next Friday
  618. page numbering of worksheet
  619. difference of 2 dates
  620. Find amount in row.
  621. Cell referencing
  622. Using MIN & MAX
  623. corrupted excel files
  624. data entry problem after upgrade to Excel 07
  625. Function Question
  626. Find column letter of the first unused cell
  627. First Time Macro
  628. Repaymen of loan excel sheet with grace period etc...
  629. Moving formula results to blank line
  630. How do I count cells with specific value?
  631. Insert Date
  632. Repayment of loan excel sheet with variables of principal free pay
  633. Help!!! - logical function for someone not very logical
  634. Create A Master List From Several Lists
  635. reporting with pivot table?
  636. Show in another cell only >0 from a range?
  637. Calculation of Quarter
  638. IF Function
  639. Formula not working
  640. exam marks into grades
  641. How do I select cells for a specific month in Excel 2003?
  642. Counting Cells With Text
  643. Protection Macro
  644. Printing different work sheets in colour when the default is b&W
  645. Using range names in functions
  646. VLOOKUP results is duplicating first value
  647. Copy cell contents depending on font colour
  648. divide column b by column a
  649. why does excel 2007 subtract 2009 from 2015 = 1900?
  650. data return using multiple conditions
  651. Conditional Formatting, multiple conditions
  652. Formula (not adv. filter) to list unique values from list
  653. Print first column on each page
  654. forecast using a four parameter logistic equation
  655. Multiple criteria in 2 different columns for a sum in a 3rd column
  656. Sumproduct excluding multiple criteria
  657. Conditional Formula
  658. Excel Office 2007
  659. Nesting the roundup Function in a larger formula
  660. How to paste phase and seperate into another cell by a symbol of.
  661. Evaluate based on Actual Month
  662. Creating an if then function to manage deductions from different c
  663. Drop Down List Question
  664. Copy only letters, not numbers
  665. sum of every 4th cell in a row.
  666. specific percentage formula
  667. subtotals in excel
  668. Subtract 10 months from a Speficic Date
  669. How will hyperlink cell reference update after copy paste?
  670. how to create row with data
  671. Formula to run report
  672. IF Statement, multiple criteria
  673. i want to count how many times an entry occurs in an array
  674. HELP! Need to divide all columns by same number to get sell price
  675. help with calculating average prices and profit/loss
  676. HELP! Need to sum columns where credit balances are shown as ###CR
  677. How to get 2003 Excel pivot table to work correctly?
  678. Filtering the Column headers that contains data for resources
  679. Can a formula tie the fill colours of two cells?
  680. 3 zero instead 1 zero
  681. IF Function in Excel
  682. To Calculate the qty b/w two dates
  683. how to find cubed root of a number
  684. Copy format
  685. Value of particular column
  686. ROUNDUP to nearest 1/16 (in decimals)
  687. 4 IFs
  688. DSUM to pull data from Access DB
  689. Forecast Formula
  690. Survey Form And Tracking Results
  691. Reverse SumProduct function
  692. If Month?
  693. New row(s) macro
  694. finding the earliest date in an array of cells
  695. SUMPRODUCT Help
  696. Format Cell
  697. Vlookup for multiple results
  698. CALCULATE PROFIT/LOSS
  699. Pivot Tables (Sumif)
  700. Function to return the last value in a contiguous set of data
  701. Delete a toggle button overlaying data
  702. EXCEL FIND A SPECIFIC TOTAL
  703. excell big dilemma
  704. Excell< another dillemmmmaaaa please help!!!
  705. how to display my cursor cell content in another cell....
  706. Linking data?
  707. Header/Footer on entire workbook
  708. auto filter
  709. COUNTIF Question
  710. Renaming worksheets
  711. Derive Average
  712. Refer to a named range indirectly
  713. Data manipulation help
  714. I need help with a formula........please
  715. replaces formula to its value
  716. Two search arguments in array formula
  717. RANKINGS
  718. Check for error.type in same cell
  719. Can't get email addresses to be "hot" when using lookup
  720. Eliminating Blank rows
  721. Round formula
  722. Using the information from a pivot table
  723. I want to count the total number of date
  724. Postcode Area extract first alpha letters
  725. Mutliple Function Query - probably using Countif
  726. Estimating Stock Trading Range From Historical Volatility
  727. unable to access the commands on the data tab.
  728. i NEED TO GET A FORMULA FOR (x-AVERAGEX) ?
  729. How do I get a index% of two numbers when they are negative or pos
  730. Visit Calculation
  731. How a cell having name of lookup_vector be used in lookup function
  732. Calculating a value but omitting cells with empty data
  733. help calculated total for each month
  734. How to use time in an IF formula
  735. Lastrow
  736. Row height will not auto format
  737. Birthdate 01/01/2000 Remove Slashes
  738. sumarize minutes and get the result in hours
  739. Lookup and return any missing numbers if applicable
  740. Need formula creation
  741. Sort w/o header row - change default
  742. Keeping a text box on the worksheet
  743. how to select the first character in a cell and delete the rest
  744. VLookup multiple spreadsheets
  745. Sorting Dates in format "01/19/09"
  746. Formula for counting and dividing
  747. Can I delete the data and keep formulas for a whole worksheet?
  748. Normalizing Excel data across rows
  749. Excel, two text fields equal the number 1 per occurance
  750. SUMIF or SUMPRODUCT?
  751. Find the first or last populated column in a range
  752. Summing Values/Outputs of IF formulae
  753. SumIf statement: incrementing
  754. Convert numbers to date: "586" to read "May 1986"
  755. Find the lowest4 numbers of the last 6 in a range
  756. mortgage payment calculation
  757. How to copy formulas sheet to sheet in excell
  758. Returning a value if false
  759. lookup formula unexpected results
  760. lookup formula unexpected results
  761. Separate names into columns
  762. GL Codes
  763. Round to .05 or .09
  764. How do I get a cell to highlight when a deadline date approaching
  765. Supplier list
  766. Convert figures to Hours and minutes
  767. Vlookup inside a formula
  768. VLOOKUP - search key is more than once available
  769. Sort two tables of data
  770. Sequence of Weeks in a month
  771. how do i sum the same cell in numerous sheets behind a main
  772. Return Formula
  773. Excel Table Conditional formatting not doing what I want
  774. Error moving from 2003 to 2007
  775. Conditional formatting from one sheet to another
  776. Conditional Formatting
  777. Count Number of Rows
  778. Excel: Last non zero value in a row
  779. Use cell to determine column in formula
  780. Inserting a comment box in a protected worksheet
  781. cursor movement wrong
  782. Vlookup
  783. Macros
  784. Using INDEX & MATCH to VLOOKUP prior column
  785. I Need a Tearoff Color Palette
  786. Toolbar built for 2003 not loading in 2007
  787. Applying users to site/names
  788. sorting ranges of various column lengths, lookup values in columns
  789. Disabling copy/paste hidden cells
  790. Count based on two different criteria
  791. Summing a column
  792. How do I format every 140th row?
  793. Convert european foreign date format to US date format
  794. How do I find a match for three variables to determine the result?
  795. Entering a formula using excel 2003
  796. XL07 create data validation list containing the names of each shee
  797. Anniversary of a date is due - conditional formatting
  798. stacking if functions
  799. Define variable range input for SUM() function
  800. Creating cell names from cell contents en masse
  801. how do i retrieve an excel spreadsheet i was working on
  802. COUNTIF: criteria is a format
  803. How do I locate a circular formula?
  804. VBA to ask for file location and use to open DB
  805. Sum on multiple columns with search criteria
  806. Macro to select Range to protect and unprotect ranges
  807. Use string value for database location - VBA
  808. customize date
  809. Increased percentage question
  810. Sum based on date greater than and a specific status adding to a t
  811. How to enable the Unprotected Worksheet menu
  812. Transferring only certain rows to seperate worksheet
  813. numbers and macros
  814. Sumif / Countif
  815. VLOOKUP
  816. replacing zeros with blanks but leaving dates alone
  817. How can I sort a list of numbers by the last 4 digits?
  818. using multiply if function
  819. Sorting
  820. sorting
  821. Cell to return a specific value if left blank
  822. How can I ge tmy sum to show the + sign for positive sums?
  823. Excel formulas become cell contents
  824. is there an AND logical ?
  825. importing data from a txt file
  826. Re: is there an AND logical ?
  827. Help with SUMPRODUCT
  828. Finding the current year
  829. ='[master workbook.xls]3108'!K25 trying to use value of cell for 3
  830. Define Name - same name for multiple cells on multiple sheets
  831. Count based on two criteria.
  832. Return Top values with changing criteria
  833. Why do people use =+A2 or =+d3? What does the "+" reference?
  834. Count Unique Values in a entire column, not just range
  835. Rich Text Boxes
  836. Formula assistance for gymnastic scoresheet
  837. Text Separation Function
  838. matching 2 worksheets
  839. bank recon
  840. Macro:- Find first blank cell and write text
  841. how do i select which data to use depending on the date?
  842. need one formula for % change in TY vs LY revenue
  843. how do i get excel text to change colour at a certain limit
  844. year - 1
  845. matching texts in 2 columns
  846. Summarize range
  847. Count Unique Values in 1 Column based on Date Range in another Column
  848. Calculating a dollar-weighted return
  849. Problem working with Vlookup
  850. Formula help in Excel 2007
  851. Countif question
  852. Index/Matching in combination w/Right()
  853. Find MAX number with criteria
  854. I'd like to change my column markers from numbers to letters
  855. automatically fill a cell in excel by pressing a key
  856. sumproduct and weekday?
  857. how to represent x,y coordinate in single column?
  858. need qualifier statement
  859. timestamp
  860. Formula to automatically show running total
  861. embedded static time & date
  862. If error #NUM! or less than 1
  863. autosum and page breaks
  864. Extract data from emails
  865. In column B:B and D:D I've a Formula
  866. Vlookup sum total
  867. autofilters on worksheets within workbook
  868. How do i doconsecutive numbering on invoices automatically?
  869. data from excel worksheet update with another excel worksheet
  870. How to make a number starting with 0 to keep showing it in Excel?
  871. different result with excel and calculator
  872. Data Analysis
  873. add-ins
  874. Look up functions
  875. Correct Function to Use
  876. Polynomial Trendline
  877. refer some letter from one cell(pipe/mech or mech/pipe (reqd: pi)
  878. Format Axis
  879. Unable to Spell Check in Excel
  880. how can i convert digit to words in excel
  881. count unique values if 2 variables
  882. Excel 2007 Conditional Formatting
  883. HOW TO AVERAGE 6 OUT OF 10 NUMBERS IN A ROW, ALWAYS CHANGING CELL
  884. formulas
  885. Template Instructions
  886. Spreadsheet columns are displayed numerically instead of alpha
  887. Find unique values using 2 variables
  888. Copy linked worksheets formula to long
  889. How do I link each cell to each worksheet to change as I enter dat
  890. The last word
  891. How to combine, IF, AND, OR Functions
  892. Group under Data > Group and Outline Data not working. Help.
  893. Making a row blink as a warning.
  894. Re: Separating data from cells
  895. Count letter"B" in one column based on unique value among duplicat
  896. How do you change single digits to recognized double digits?
  897. Ending in Macros
  898. Links Between Folders
  899. IF formula
  900. VLOOKUP not returning data in some (but not all) records
  901. Getting a percentage
  902. Sort anomoly
  903. How do I test a condition in one cell and write to another.
  904. Concatenate many cells
  905. How to select the best 2 values
  906. SUMPRODUCT
  907. Hiding Page Breaks
  908. SUM DATE on two worksheets
  909. Total amount By word
  910. date and time format
  911. IF, Else functions
  912. RANK dates from the middle of the month.
  913. Insert a new line, without destroying the consistency of the formu
  914. Count the number of times a specific date appears in a range of ce
  915. What function to use for filter of data?
  916. How to filter data in a table onto another worksheet?
  917. Macro
  918. Max if less than, Non-continuious array
  919. Refer to current row in formula
  920. Linking two VLOOKUP functions - Excel 2003
  921. Hiding Column Issue
  922. If funcion on big formula
  923. Trouble with permissions to shared excel files when using import q
  924. Excel Pivot Table How to Sort data as Percent of Row
  925. conditional formula
  926. calculating
  927. Cells Appear Blank but aren't
  928. distributing days
  929. Overriding formula
  930. overriding formulas
  931. Hi Could you please help?
  932. Track Changes Not Working Properly
  933. How to make a range of cells react to changes in one cell
  934. COUntif AND...
  935. calculating
  936. Principle and interest formula - Help
  937. Excel 2007: complex COUNTIFS()
  938. Lock a formula to a column of cells
  939. Rank and Sort
  940. I need a february 29th row, but only if the day of year actually exists
  941. SUMIF & INDIRECT Returns #Value!
  942. Conditional
  943. Crazy Hard Function
  944. How to perform logistic regression in Excel 2003
  945. CAN I HAVE TWO IF FUNCTIONS
  946. How to remove non-exist values in pull-down list in pivot table
  947. Password security
  948. Macor Button Dissapears
  949. IF Function
  950. Vlookup
  951. lookup
  952. how to copy cell formatting in formula
  953. Linking to combo box selection
  954. lookup more than one value across a table
  955. How can I calculate the numbers?
  956. Return a column value from a horizontal search
  957. I think it is a lookup question???
  958. NESTED IF FORMULA - IGNORE BLANK CELLS
  959. i want to change a date on a document automatically
  960. Move data - what happens to formula's
  961. If Cell Contains specific UPPERCASE text
  962. format cells semi automatic
  963. linking two worksheets in the same workbook
  964. Conditional Replace without macros
  965. Sorting data in one sheet
  966. Way to hide rows when a cell contains numbers less than a value?
  967. Randbetween help
  968. calculating days
  969. History of Workbooks opened
  970. Pivot table help for excel 2003
  971. Pivot Table Row Totals
  972. sumif multiple columns
  973. Macro auto fill formula
  974. Find occurance of a part number?
  975. Merging data from Excel form
  976. Conditional Formatting
  977. Automating Inventory data via e-form
  978. Vlookup
  979. Alloting days
  980. Is there an XLS function to convert std time to Military time?
  981. Adance Filter that "CONTAINS"
  982. Calculate a date based on values in other cell, worksheet
  983. A mathematical formula question???
  984. Help simplifying IF OR formula
  985. SUMIF using two criteria to count
  986. Bathroom Sink Plug
  987. Clean Fish Tank
  988. Compare and count if data elements on two worksheets are similar
  989. Double Bowl Undermount Kitchen Sink
  990. Creating a Automatic Alpha transfer from other sheets?
  991. Help with identifying time and time zones in a formula
  992. Formula help please.
  993. Help on complex multi-column sum is appreciated
  994. Help on complex multi-column sum is appreciated
  995. Help in calculating tax % for Co2 emissions?
  996. vlookup count?
  997. linking/updating multiple wksht comments
  998. How do I keep the cell blank?
  999. Sum if and with multiple criteria
  1000. Line Continuation issue
Google