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. Help me!
  2. Function for tax?
  3. Sorting in Pivot Table
  4. Using formula to find out a Date 90 prior to a particular date
  5. excel formulas
  6. Spell Check
  7. Data in columns. Which formula will identify last completed colu.
  8. Text file import
  9. Time Situation
  10. HELP with conditional formatting and a max time
  11. How do i stop Excel from turning a value into a formula?
  12. Protect selected settings in 'options'
  13. "AverageIf"
  14. How can I use a formula to return the first number in a range?
  15. Conditional Currency
  16. runtime error 2147221005(800401f3)
  17. repeated values
  18. repeated numbers or value
  19. SumProduct Query
  20. Extracting information to automatically find previous value.
  21. Sorting Rows
  22. Formula Help
  23. Sum Of Last Two Entries in Rotating Columns
  24. Adding to numbers
  25. max value from multiple rows of similar information
  26. 2003 Excel
  27. If part of a cell = "NVA" then insert "Norfolk" in return cell
  28. Excell rank= I need to reverse the order
  29. Number of total calculation functions
  30. YEAR MONTH DAYS COUNTER
  31. YEAR MONTH DAYS COUNTER
  32. Divide by the minimum non-zero number in a range of cells
  33. Using Cell Contents to Select Worksheet with Same Name as Cell Con
  34. cell formulas
  35. convert hours and minutes into days
  36. how do you auto populate tasks into a calendar
  37. Data comparison for duplication
  38. Sumif or Sumproduct?
  39. SUMPRODUCT Difficulty
  40. Conditional Formatting
  41. Need Help Developing Formula
  42. IF formula for time
  43. Count Unique Values
  44. Difference between date and time
  45. SUMIFS
  46. Dependent List "Index" Problem
  47. Delete BOTH sets duplicate data in columns (debits/credits)
  48. change cell colour according to date.....
  49. how do I view up to 120,000 rows in office excel 2003
  50. Countif or Sumif with frequency
  51. Can't analyze web data
  52. Excel 2007 -->> SUMIFS v SUMPRODUCT
  53. Excel cannot complete this task with available resources
  54. Tab naming from a Reference cell
  55. Naming a worksheet tab from a reference cell
  56. Naming worksheets tabs from another cell reference
  57. Go to a chosen worksheet
  58. Cell value determined by the current time and date
  59. Help: Assigning a "word" a numerical value
  60. Problem with Syntax?
  61. Countif cell is conditionally formatted
  62. inverse weighted average
  63. Inverse wieghted average/ratio
  64. VLOOKUP: Wont return value
  65. Max Min Differnce in a Range
  66. Sums including #NAME?
  67. Hiding columns in Excel 2003
  68. count number of occurances between 2 values
  69. Pasting charts to Word without Gridlines
  70. How to import PDF into Excel?
  71. How can I convert many rows of hyperlinks to BASE links?
  72. How do I copy subtotaled data without underlying details in Excel
  73. Eliminating Duplicates in Excel 2007
  74. Index with mulitple value returns and muliple column returns
  75. macro to grab current workbook filename
  76. Excell 2007 Pivot Table Calculation changes decimal places
  77. Need help with formula
  78. Importing
  79. Sort Block of Data
  80. Combo box selection will not calculate
  81. How do I change date format m/d/yyyy to mmddyyyy toremove the dash
  82. VBA Converter for Excel 2007
  83. Remove last n rows
  84. Trying to highlight cells that have the same value as the active c
  85. standings
  86. Sumproduct with blanks
  87. Pivot across several tabs
  88. DSUM - Need dynamic functionality
  89. Subtotals from Named Range on other worksheet
  90. IF with #N/A
  91. Summing data based on certain cells
  92. delete numbers in each cell in same column
  93. Using Multiple Criteria to filter for multiple users
  94. Restrict data entry to specified cells
  95. How do I create a VERY complicated spreadsheet?
  96. Internet Explorer opens jpeg from a hyperlink ???
  97. Reference to next non-blank cell
  98. IF or VLOOKUP - help please .....
  99. Give me a Function
  100. Less than, Greater Than, equal to conditional formatting
  101. If or VLOOKUP
  102. HOW CAN CREATE THE PRICE RANGE IN EXCEL 2003?
  103. use sumif / Sumproduct for year data
  104. Filter in Rows not columns
  105. Conditional formatting from Dates
  106. How to replace a formula string with * in the leading position?
  107. Formula Help Needed
  108. Display 2 worksheets simultaneously
  109. Re: Fitting data with a negative exponential
  110. How to create one additional warning flag into my logic?
  111. Conditional Formatting Based on Due Dates
  112. excel
  113. how do i count using two criteria
  114. Problem with Using "Multiply by 1"
  115. lookup same or similar
  116. SUMPRODUCT
  117. How do I change the default header date format in Excel 2007?
  118. undo feature non-functioinal in Excel
  119. Bin Array--Frequency
  120. Percentage of a count data in Pivot table
  121. need lookup help
  122. IF _Different Values-
  123. Formula for rating results
  124. One workbook with 62 worksheets
  125. If specific # of certain characters in a range, "OK", if not "Aler
  126. excel
  127. Entering time
  128. Updating & Archiving Records
  129. ENTERING TIME
  130. Formula question
  131. getting rid of blanks
  132. Match multiple values
  133. Please help
  134. Page setup stuck on portrait mode
  135. Help neededin adding an additional "Warning Flag" to my current lo
  136. how do i use the roundup function
  137. how to use data table
  138. Can I set AutoFit to Excel cels
  139. Time Calculations and Conditional Formating
  140. Counting in columns
  141. index function - ascending order
  142. vlookup_surya_siva
  143. Remove hyperlink, web link, and using Advanced filter
  144. Auto Assigning Number to Excel Invoice
  145. Working with 2 arguments over 4 columns (countif ??)
  146. Setting cell selections in form spreadsheet
  147. Conditional Formatting & Data Validation?
  148. If_Then question
  149. Help with MATCH function
  150. Helo there - Help with showing deviation (+/-) from a set number...
  151. What type formula to use?
  152. Excel template for youth softball statistics
  153. Copy updating column to another workbook
  154. How do I turn on the automatic date function
  155. Count w/ multiple variables & text values
  156. YTD budget formula based on current actual input
  157. sumproduct/sum not working with multiple variables
  158. Cell formular
  159. Vlookup from another tab
  160. Various dates returned for variable situations, +
  161. Ranking Question
  162. remove duplicate rows but keeping all columns
  163. Test whether formula in cell is an expression or a number/text
  164. Pivot table - deducting sub-totals of income and expenditure
  165. Locking Worksheets, Copy and Paste Question
  166. Re: Determine last cell in a row
  167. protecing hidden columns
  168. Extract numbers from a code
  169. SUMPRODUCT with AVERAGE result
  170. Help with this formula
  171. Format text color
  172. Analyze with excel (change access date format)
  173. excel: set up so when I click on a cell it goes to the reference
  174. excel start directory
  175. how can I et excel to add number of hours to a certain time?
  176. Past due function
  177. help with criteria and sum
  178. Search between dates & return other column
  179. Finding Repeated Words
  180. Count Function
  181. Trim with Country code leading
  182. If formula
  183. vlookup error
  184. GETPIVOTDATA Question
  185. Trim cells
  186. Median in pivot tables
  187. How do I combine worksheets w/o enough rows to combine?
  188. Automatically Increase Grade every School Year
  189. Locking a Workbook, but Inserting Rows
  190. RE: Conditional formula to highlight dates (and that entire row)
  191. Simplify a large nesting string to use in Excel 2003
  192. Combining IF with VLOOKUP
  193. Convert Square Feet to Gallons
  194. I have 2 columns in Excel "yes" and "no" can I add them up?
  195. Help w/simple Date Formula please
  196. Help Please: Need an Average for 16 Weeks according to Month
  197. Comparing data in multiple spreadsheets with the first being the m
  198. file path changes when emailed
  199. Unique count is criteria is met
  200. 100 + tabs need to pull data if criteria is met
  201. Copying multiple records for the same vendor
  202. structured references with externally linked excel tables
  203. Name Range Help
  204. Copying and pasting links within the same workbook
  205. sum for match criteria
  206. Help obtaining value of defined names when concatenating text with formula
  207. Filter - not =
  208. Time factor
  209. how to find the right most cell in a row with a value in it ?
  210. PRODUCE A PRODUCT THAT WILL LIST A STRING OF VALUES FOR A MATCH
  211. Date calculation
  212. SUM Condition
  213. Merging cells in a Protected Sheet
  214. help list rooms by service owner
  215. Removing text from cells
  216. Comparing two ranges and get true or false in one cell depending onresult
  217. Why are my dates show up as (example) 39538 in formula?
  218. If Function
  219. INSERTAR FUNCION MES
  220. Calculating a date
  221. Factorial question
  222. Countif left and alphanumberical data
  223. Pointing Finger Mouse
  224. update data from internet
  225. Lookup multiple values
  226. AutoFilter: custom filter hides all
  227. Autofilter Hides All...
  228. =SUM(IF help please
  229. Conditional Format Help
  230. Time Span calculations
  231. RE: Nested conditional statements
  232. count if
  233. pivottable bug
  234. how do i format
  235. Re: Nested conditional statements
  236. Re: Nested conditional statements
  237. How to retrieve Named Range name?
  238. How do I populate text from one page to several others?
  239. Totals Lookup by month and year
  240. Comparing a date with a range of dates
  241. Using VLOOKUP to look up info from Access
  242. Conditional Formula, counting one criteria in a range based on ano
  243. Why is my drag and fill not following the pattern?
  244. Problem Please Help Me
  245. Return a Specific Value
  246. Sum until hit blank
  247. 0.1 to 0.99 not recognised or calculated when results from formula
  248. Vlookyp fails due to space at the end
  249. How to divide array formula?
  250. Multiple IF formulas
  251. Excel 2007 - Multiple If Then or Lookup
  252. resources & rates importation into MS Project
  253. need to subtract one cell from each cell in a row
  254. Nesting Limit 2007
  255. Opening an Excel workbook with VBA from Access
  256. Virus Check
  257. how do I duplicate the Lotus 123 @rate function in Excel?
  258. Refering back to a spreadsheet saved on the internet
  259. Formula To Show Which Cell Has The Highest Rate
  260. Avoiding answer zero by multiply
  261. How can I edit the formula without changing the format? {=SUM(if.
  262. 0.1 to 0.99 not recognised or calculated when results from formula
  263. Which formula to use?
  264. Multipling 2 columns
  265. Excel Table Help
  266. Conditional Format to display text alert
  267. How do I include names in formula by picking up names from rows
  268. Vlookup and get the maximum value
  269. excel not recognising numbers containing 0.1calculated by formulas
  270. Count # of classes by month by local
  271. OMIT BLANK LINES WHEN FORCING A CARRIAGE RETURN --- PLEASE HELP!
  272. Adding 2 for every multiple of 5
  273. How do I move from cell A 10 to cell B1 with one move or click
  274. Pictures in Headers and Footers
  275. Conditional Formatting
  276. How do I retrieve Cost from a grid using text drop down lists?
  277. How can I use the ROUNDOWN and ROUNDUP functions in an "IF" functi
  278. how do calculate elasped time
  279. Average IF
  280. Vlookup to include conditional formats
  281. identifying cells representing certain value and assigning name to
  282. Autopopulate cell name with tab name
  283. struggling with if logical test function
  284. Find address
  285. Sum/multiply function
  286. Question on looking up data
  287. Count pricing associated to year
  288. filter text
  289. Macro to HIDE blank rows
  290. Using Index and Match Formula
  291. Paste transpose and link at the same time
  292. Give a cell a name that is variable
  293. reference table automation
  294. creating a survey and gathering the data
  295. Convert the series to a formula
  296. IF OR Help
  297. Pivot - can we set criteria?
  298. Formula convert date to month format
  299. text alignment settings
  300. Fill Series
  301. Finding muliple duplicate records in spreadsheet
  302. Need to have an index sheet but all other sheets should be hidden
  303. Index match to return all values
  304. VBA for form check boxes
  305. Formula
  306. Averaging question
  307. ComboBox
  308. Creating Drop-down menus with subset drop-down menus
  309. Question on Named range with formula
  310. Multiple function queries in same cell
  311. default border color
  312. Top 10 Publications and Matching Text Values
  313. adding cells then sorting
  314. highlight dependent cells
  315. Pivot tables - new columns
  316. Using worksheet template create tabs against customer list
  317. Help With Sum
  318. Vlookup & 2 variables
  319. Worksheet tabs to turn colors against criteria
  320. Integrating Networkdays() Into Formula
  321. Conditional Formatting for Changing a Formula
  322. Excel invoke REST service function with Xpath fn parse result!
  323. Search row of numbers, find highest value.
  324. I am trying to set up a formula to show a subsequent IP Address.
  325. Linked spreadsheets created in 2003 but not working in 2007
  326. Vlookup not calcuting correctly
  327. IF formula and date fields
  328. FIle link
  329. VBA code to count rows
  330. auto save function
  331. cummulative ditribution functions
  332. SumIF with condition and exception
  333. indirect with wildcards
  334. zero denominator
  335. Subtotals in very large datasets
  336. Multiple CountIfs
  337. recognizing words as numbers...for a formula
  338. CountIF and Sum in one formula?
  339. consolidating or totaling info
  340. Highlight rows based on '1' or blank in all columns on a row
  341. indirect / vlookup help
  342. SUM key
  343. If/Vlookup override
  344. Mapping distances with postal codes in an excel spreadsheet
  345. Mulitiple Count of occurrences in different columns
  346. How to prevent each item date from changing after "TODAY" formula
  347. Average except for something lower...
  348. Click on cell (or "button"), takes you to appropriate information
  349. VLOOKUP and SUMPRODUCT
  350. Excel 2003 - Lookup type of question
  351. fill down sequentially
  352. Calculate hours of work substracting non-working time
  353. Conditional MAX
  354. Advanced Filter, Copy to another location
  355. Sheet Referencing - autofilling sheet names
  356. Cell locking based on domain user
  357. Day Off Formula
  358. Search dates
  359. formula for transpose
  360. Nested Functions Limit
  361. BLANK CELLS ARE NOT ACTUALLY BLANK
  362. conditional format date range
  363. Check Boxes / Collapsing
  364. using cell contents to link to other tabs
  365. formula to link to other tabs
  366. Formula Question
  367. Pivot table summary functions
  368. Event Schedule
  369. Matching data
  370. Help with a nested IF statement containing AND and OR funtions
  371. Need formula
  372. Count Unique Values but not Filtered or Hidden Values
  373. Replace text with text
  374. Counting patient check in
  375. when i pick a cell, it picks cells below also, how do i stop this
  376. Multiple Functions of a Cell
  377. In Format - General-How do I change it to an even number like 24
  378. Button for Hyperlink
  379. Lookup question and iferror compatibility
  380. Save Date
  381. Lookup function
  382. I need to calculate hours worked from 11pm to 7am minus a lunch
  383. Count if with partial text match (edited X2)
  384. Index and Match?
  385. Count if with partial text match (edited)
  386. Count if with partial text match
  387. back transforming log10 standard error
  388. data matchin
  389. How to automatically calculate totals within a Y-N-N/A column
  390. How can I unfreeze curser in Excel 2007?
  391. Counting Dates
  392. Function or Formula to show the value from above cell
  393. MAX/MAXA – Formula not returning required value
  394. Vlook match
  395. Vlookup function
  396. How to VLOOKUP multiple sheets and each sheet have 65536 rows?
  397. Solver or Other?
  398. how can i perform multivariate analysis in excel 2007?
  399. I cannot copy the columns of formulas in this Workbook::: AHHHHHHHHHHHHHHHH
  400. color
  401. Complex Conditional Sum
  402. Lookup within a range
  403. getting totals mutiply cell by another cell then adding all togeth
  404. past special
  405. spanner function in excel
  406. Copy from sheet to sheet when matches criteria
  407. How to write an Or statement inside Sumproduct?
  408. Comparing Text between Columns
  409. Find function??
  410. VB script for Current time
  411. Data set filtation
  412. Dates and IF Functions
  413. Eliminate #N/A in Vlookup formulas
  414. With a Function, how can I get rid of formating codes like <div> ?
  415. automatic numbering as in invoicing but for certificates
  416. Sumproduct Wildcards
  417. Count the number of occurances in a cell
  418. does any one know to copy cells within an IF statement in Excel
  419. Hyperlink
  420. Sumproduct query
  421. Adding mm:ss values
  422. HELP......I am going insane....
  423. Unknown Number Format
  424. cell formats
  425. Calling Roger Govier or anyone else that can help with numbers to
  426. Set cell value if adjecent cell value is greater than 0
  427. help with formula
  428. How to extract a character from a string then VLOOKUP a table?
  429. I have a formula question. Can someone help me?
  430. Auto filling Forms
  431. Formula
  432. Really challenging lookup situation.
  433. How To Stop Chart Sizing With Cells?
  434. Blank cell fromula
  435. Formula returning "A value used in the formula is of the wrong dat
  436. How to add a cell value to VLOOKUP?
  437. 7 Day Pacing Formula Help
  438. Another VLOOKUP Problem
  439. Median Calculation
  440. VLOOKUP within VLOOKUP
  441. Using a popup to affect a column of numbers
  442. Now date
  443. Logical test of text?
  444. military time set up
  445. Revisit an older post, looking for SQL help on adding range data frommany sheets to a single sheet
  446. custom field with custom formula in pivot table!
  447. Calculate a formula when enter text
  448. 24 hr format
  449. remove muliplication function and see the original figure
  450. Problems
  451. variable consolidation ending tab name
  452. consolidation sum where ending tab value is changeable
  453. Protecting Sheets
  454. Re: What Formula to use?
  455. How do I sort alpha neumeric fields that have an alpha suffix?
  456. Calculation Between 2 Dates
  457. Hiding and locking formulas
  458. What Formula to use?
  459. Dates
  460. automatically updating chart
  461. how to get a text/letters to equal to a percentage
  462. Click a cell and all related cells are colour highlighted
  463. when I protect a worksheet, user cannot use check boxes
  464. Imported time text to seconds
  465. cell value based on selection from drop box
  466. Lookup function?
  467. To Mr. T. Valko
  468. Counting Blank Cells until end of Column
  469. Is NETWORKDAYS Supported in Excel to Web Page?
  470. Array If formula
  471. Formula for IF a total goes to 3 pages do not have on 2nd page
  472. Formula for IF a cell contains value
  473. Need help with converting CUSTOM format/TEXT format to DATE format
  474. Deleted Data
  475. Need help with Hlookup - need to return values below the matched c
  476. sorting with custom data
  477. Auto fill in forms
  478. worksheet function (Formatting)
  479. calculations of weekends only
  480. Create an edit field
  481. Changing $ format to a written format
  482. Protect sheet but be able to merge cells
  483. Counting
  484. restrict access to individual users - excel tabs
  485. Creating Serial Additions of Numbers Formatted "M-N" In Merged and Unmerged Cells
  486. How to input pictures automatically based on cell input?
  487. Convert 0 value cells to "text"
  488. Printing and emailing query
  489. 360/365, etc.
  490. Formula
  491. How to use keyboard to enter the drop down list?
  492. Calculating different values and percentages in rows
  493. Worksheet Tabs
  494. Rounding Errors in 2007
  495. Posting problem
  496. How to get the caliculation process Window in Excel
  497. using percentages in conditional formatting
  498. Alpha-sort addresses, ignoring first 1-3 numerals
  499. Using greater than and lesser than formula
  500. AutoFit Row Height - How to use so there is no space after text?
  501. open and close files
  502. Formula in Excel Help Please
  503. LOOKUP or IF-THEN stmt - which one?
  504. unique values among duplicates without considering specific words
  505. auto complete
  506. Conditional Formating in Blank Cells
  507. Count number of occurences in a list
  508. easy formula question
  509. lookup cell reference and copy contents and comment from a range
  510. Max Price and Min Price paid for an item - Rephrsed
  511. How do I allow data entry to one column only?
  512. How to enter a database function to average the annual salary?
  513. DATA SUMMARY
  514. show or Hide cell comment when mouse hovers in Excel?
  515. Max Price and Min Price paid for an item
  516. How to remove double data?
  517. way to view excel workbook only by password protection
  518. macro Protection
  519. Conditional Formatting
  520. keeping formula the same in a workbook when adding a row to one sh
  521. Automating change via popup to a column of numbers
  522. Retrieve Data to Pivot Table "On Demand"
  523. OFFSET function
  524. Stop cell changing
  525. SUMIFS Issue
  526. Summary sheet auto update
  527. IF function
  528. lookup to bring back multiple values
  529. How to delete duplicates and also count them
  530. Excel doing strange things
  531. i want to automatically save the data after every 2 mins in excel
  532. Extracting a month name forom a date
  533. transfer macro
  534. Count cells with a date falling within a 30 day period.
  535. Check result if same as other cell on row
  536. Calculating
  537. Embeded picture in Excel
  538. RANDBETWEEN problems
  539. search through dates
  540. trouble with Names on multiple sheets
  541. Computing the item age
  542. Pivot Table Question
  543. Sumif Function
  544. Why copying the sheet to diff file changes font color?
  545. Validation List Question, Text in Cell DIffers to that Selected
  546. add multiple numbers in one cell with those numbers remaining visi
  547. Logical operators not working with text???
  548. Separating text in one cell into two cells
  549. Error in VLOOKUP
  550. excel 2007
  551. Text File Question
  552. calculating
  553. IF function
  554. How do I keep 3-D reference the same when inserting one row on one
  555. Complex sum required
  556. Zero in cell where it is linked to a blank cell - repost
  557. If...rows and columns
  558. Using more than one list in a drop-down
  559. display filter selection from menu
  560. Filter
  561. Calculating someone's age at a given date
  562. How do I make coloured drop down lists in Excel?
  563. How to change the number of rows in a worksheet.
  564. How to add only the adding filtered result using SUM function?
  565. INDEX - MATCH - OFFSET By Reference
  566. how do I use array references in VLOOKUP()?
  567. TIMESHEET
  568. "Remembering" Cell Values
  569. direction of delta using arrows
  570. How to populate a cell based on font color/threshold
  571. Tricky problem - auto-sorting without VBA
  572. Adding problem in excel
  573. Turning #value into a blank cell
  574. Turning N/A cells to blank Cells
  575. turning N/A cells to blank Cells
  576. How do I update all worksheets at startup?
  577. Sales Commission Rates
  578. Need Countifs Formula Help
  579. Re-post Formula
  580. OFFSET Problems
  581. Problems
  582. Excel 2007?
  583. Excluding "0" in standard deviations
  584. Unable To Read File - Sumproduct error
  585. IF OR ???
  586. IF OR ???
  587. Count Formula
  588. multiple find and replace
  589. Help for Date counting.
  590. More than 3 Conditions???
  591. Ping Jacob Skaria
  592. How to remove space from a cell.
  593. how to delete a file that was recovered by system?
  594. Max IF
  595. i need a formula
  596. Last 7 days
  597. HELP PLEASE
  598. vlookup ignoring empty cells
  599. Unique/Distinct Dropdown List
  600. Worksheet Name
  601. formulas
  602. SUM(IF(OR
  603. Aging by netting negatives in other age buckets for the customer
  604. Formula to display text depending upon date entered in a cell
  605. IF(OR - Help!
  606. Formula for Counta
  607. max number of spaces/letters
  608. Calculating number of periods
  609. How to convert excel 2003 file in excel 2000
  610. Help for Time tracker updation
  611. Does anyone have a template to convert Kilos to Pounds & Ounces
  612. If on an If
  613. Function & paste special values
  614. VLOOKUP
  615. Calculating Difference Between Two Times in General Format
  616. find in multi
  617. Split cell
  618. Split by characters
  619. Macro Filter
  620. Timesheet help
  621. Excel Data Validation/Lookup function does function correcty
  622. Date format in the cell
  623. Screen Size
  624. Excel 2003 function??????
  625. Sumproduct and filters
  626. worksheet function in event macro
  627. Get "Large" from list
  628. if function
  629. 4 "-" cells" help
  630. Median with Quantity Column
  631. Rounding up decimals
  632. Formula/functions
  633. Min excluding zero values, without an array fomrula
  634. sumif, countif, datedif formula
  635. copy 10 workbooks to a combined workbook
  636. Cell text and background colour dependant on result
  637. paste cells (and reduce font size) from excel into outlook
  638. Update one worksheet tab to automatically update all other tabs?
  639. Formula in Excel
  640. Delete from Listbox
  641. Formula
  642. Dates and If Function
  643. How can "=LOOKUP(I4,I2:I11)" POSSIBLY return #N/A??
  644. How do I utilize excel to create a hypothetical financial plan?
  645. Look Up challenge
  646. Recurring Date
  647. Sub or function not defined
  648. My Mystery Formula that needs an adjustment (Help)!
  649. Aggregating months over periods
  650. Edit formula in pivot table
  651. Get Data from Word to Excel
  652. Get Data from Word to Excel
  653. IF, AND combinations
  654. Compare columns of numbers
  655. Comparing columns
  656. Date issue
  657. Incrementing numbers problem
  658. Formula to use date in file name link reference
  659. concatenate contents of cells whose contents resemble cell referem
  660. Help please - warning messages
  661. Help please - warning messages
  662. How do you set a cell to increase numerical sequence?
  663. auto populate masterlist from 3 other lists
  664. Conditional Format a Range Name
  665. can colors be used in if test results eg red for minus amounts
  666. Test
  667. Why won't my spreadsheet SUM??? Help
  668. Extracting Table Data
  669. Naming of tabs from data in a worksheet
  670. Sumproduct syntax question
  671. Ghost in the Machine - 1004 Vlookup & On Error Duo Trouble
  672. import excel 2003 dates & notes to Julian calendar format?
  673. From portrait to landscape
  674. Complex matching with ranges
  675. Modifying Data in Drop Down Menu
  676. concatenate values
  677. Links
  678. Help with Formula
  679. Auto-Fill Column based on data in each row
  680. automatic colour change of cells.
  681. Average days between dates
  682. Answer an Outlook Express message box
  683. External xls reference error
  684. Email code
  685. Functions/formula
  686. Lookup help needed
  687. Lookup help needed
  688. Lookup help needed
  689. =hour formula
  690. Function isn't recalculating
  691. Transfer a name from one cell to another but leave clear if clear?
  692. square root
  693. FREQUENCY Formula Question
  694. Macro repeat
  695. Sumproducct question
  696. Macro relative cell reference
  697. Problems
  698. Not sure which formula to use
  699. Help required in Formula for date
  700. What's Wrong: Concatenation and Function
  701. populate duplicate data into a spreadsheet
  702. Need help with a chart in Excel
  703. Stopping a CountIf
  704. Unknown error in function, and how to return value?
  705. hyper link to another file
  706. Help
  707. How to count letter B based on data in other columns
  708. show a customised message when a trying to edit a locked cell
  709. Macros Automatically Sort
  710. copy a protected worksheet
  711. If function with Calculation
  712. Run-time error: '1004'
  713. Line Continuation issue
  714. Sum if and with multiple criteria
  715. How do I keep the cell blank?
  716. linking/updating multiple wksht comments
  717. vlookup count?
  718. Help in calculating tax % for Co2 emissions?
  719. Help on complex multi-column sum is appreciated
  720. Help on complex multi-column sum is appreciated
  721. Formula help please.
  722. Help with identifying time and time zones in a formula
  723. Creating a Automatic Alpha transfer from other sheets?
  724. Double Bowl Undermount Kitchen Sink
  725. Compare and count if data elements on two worksheets are similar
  726. Clean Fish Tank
  727. Bathroom Sink Plug
  728. SUMIF using two criteria to count
  729. Help simplifying IF OR formula
  730. A mathematical formula question???
  731. Calculate a date based on values in other cell, worksheet
  732. Adance Filter that "CONTAINS"
  733. Is there an XLS function to convert std time to Military time?
  734. Alloting days
  735. Vlookup
  736. Automating Inventory data via e-form
  737. Conditional Formatting
  738. Merging data from Excel form
  739. Find occurance of a part number?
  740. Macro auto fill formula
  741. sumif multiple columns
  742. Pivot Table Row Totals
  743. Pivot table help for excel 2003
  744. History of Workbooks opened
  745. calculating days
  746. Randbetween help
  747. Way to hide rows when a cell contains numbers less than a value?
  748. Sorting data in one sheet
  749. Conditional Replace without macros
  750. linking two worksheets in the same workbook
  751. format cells semi automatic
  752. If Cell Contains specific UPPERCASE text
  753. Move data - what happens to formula's
  754. i want to change a date on a document automatically
  755. NESTED IF FORMULA - IGNORE BLANK CELLS
  756. I think it is a lookup question???
  757. Return a column value from a horizontal search
  758. How can I calculate the numbers?
  759. lookup more than one value across a table
  760. Linking to combo box selection
  761. how to copy cell formatting in formula
  762. lookup
  763. Vlookup
  764. IF Function
  765. Macor Button Dissapears
  766. Password security
  767. How to remove non-exist values in pull-down list in pivot table
  768. CAN I HAVE TWO IF FUNCTIONS
  769. How to perform logistic regression in Excel 2003
  770. Crazy Hard Function
  771. Conditional
  772. SUMIF & INDIRECT Returns #Value!
  773. I need a february 29th row, but only if the day of year actually exists
  774. Rank and Sort
  775. Lock a formula to a column of cells
  776. Excel 2007: complex COUNTIFS()
  777. Principle and interest formula - Help
  778. calculating
  779. COUntif AND...
  780. How to make a range of cells react to changes in one cell
  781. Track Changes Not Working Properly
  782. Hi Could you please help?
  783. overriding formulas
  784. Overriding formula
  785. distributing days
  786. Cells Appear Blank but aren't
  787. calculating
  788. conditional formula
  789. Excel Pivot Table How to Sort data as Percent of Row
  790. Trouble with permissions to shared excel files when using import q
  791. If funcion on big formula
  792. Hiding Column Issue
  793. Linking two VLOOKUP functions - Excel 2003
  794. Refer to current row in formula
  795. Max if less than, Non-continuious array
  796. Macro
  797. How to filter data in a table onto another worksheet?
  798. What function to use for filter of data?
  799. Count the number of times a specific date appears in a range of ce
  800. Insert a new line, without destroying the consistency of the formu
  801. RANK dates from the middle of the month.
  802. IF, Else functions
  803. date and time format
  804. Total amount By word
  805. SUM DATE on two worksheets
  806. Hiding Page Breaks
  807. SUMPRODUCT
  808. How to select the best 2 values
  809. Concatenate many cells
  810. How do I test a condition in one cell and write to another.
  811. Sort anomoly
  812. Getting a percentage
  813. VLOOKUP not returning data in some (but not all) records
  814. IF formula
  815. Links Between Folders
  816. Ending in Macros
  817. How do you change single digits to recognized double digits?
  818. Count letter"B" in one column based on unique value among duplicat
  819. Re: Separating data from cells
  820. Making a row blink as a warning.
  821. Group under Data > Group and Outline Data not working. Help.
  822. How to combine, IF, AND, OR Functions
  823. The last word
  824. How do I link each cell to each worksheet to change as I enter dat
  825. Copy linked worksheets formula to long
  826. Find unique values using 2 variables
  827. Spreadsheet columns are displayed numerically instead of alpha
  828. Template Instructions
  829. formulas
  830. HOW TO AVERAGE 6 OUT OF 10 NUMBERS IN A ROW, ALWAYS CHANGING CELL
  831. Excel 2007 Conditional Formatting
  832. count unique values if 2 variables
  833. how can i convert digit to words in excel
  834. Unable to Spell Check in Excel
  835. Format Axis
  836. refer some letter from one cell(pipe/mech or mech/pipe (reqd: pi)
  837. Polynomial Trendline
  838. Correct Function to Use
  839. Look up functions
  840. add-ins
  841. different result with excel and calculator
  842. Data Analysis
  843. How to make a number starting with 0 to keep showing it in Excel?
  844. data from excel worksheet update with another excel worksheet
  845. How do i doconsecutive numbering on invoices automatically?
  846. autofilters on worksheets within workbook
  847. Vlookup sum total
  848. In column B:B and D:D I've a Formula
  849. Extract data from emails
  850. autosum and page breaks
  851. If error #NUM! or less than 1
  852. embedded static time & date
  853. Formula to automatically show running total
  854. timestamp
  855. need qualifier statement
  856. how to represent x,y coordinate in single column?
  857. sumproduct and weekday?
  858. automatically fill a cell in excel by pressing a key
  859. I'd like to change my column markers from numbers to letters
  860. Find MAX number with criteria
  861. Index/Matching in combination w/Right()
  862. Countif question
  863. Formula help in Excel 2007
  864. Problem working with Vlookup
  865. Calculating a dollar-weighted return
  866. Count Unique Values in 1 Column based on Date Range in another Column
  867. Summarize range
  868. matching texts in 2 columns
  869. year - 1
  870. how do i get excel text to change colour at a certain limit
  871. need one formula for % change in TY vs LY revenue
  872. how do i select which data to use depending on the date?
  873. Macro:- Find first blank cell and write text
  874. bank recon
  875. matching 2 worksheets
  876. Text Separation Function
  877. Formula assistance for gymnastic scoresheet
  878. Rich Text Boxes
  879. Count Unique Values in a entire column, not just range
  880. Why do people use =+A2 or =+d3? What does the "+" reference?
  881. Return Top values with changing criteria
  882. Count based on two criteria.
  883. Define Name - same name for multiple cells on multiple sheets
  884. ='[master workbook.xls]3108'!K25 trying to use value of cell for 3
  885. Finding the current year
  886. Help with SUMPRODUCT
  887. Re: is there an AND logical ?
  888. importing data from a txt file
  889. is there an AND logical ?
  890. Excel formulas become cell contents
  891. How can I ge tmy sum to show the + sign for positive sums?
  892. Cell to return a specific value if left blank
  893. sorting
  894. Sorting
  895. using multiply if function
  896. How can I sort a list of numbers by the last 4 digits?
  897. replacing zeros with blanks but leaving dates alone
  898. VLOOKUP
  899. Sumif / Countif
  900. numbers and macros
  901. Transferring only certain rows to seperate worksheet
  902. How to enable the Unprotected Worksheet menu
  903. Sum based on date greater than and a specific status adding to a t
  904. Increased percentage question
  905. customize date
  906. Use string value for database location - VBA
  907. Macro to select Range to protect and unprotect ranges
  908. Sum on multiple columns with search criteria
  909. VBA to ask for file location and use to open DB
  910. How do I locate a circular formula?
  911. COUNTIF: criteria is a format
  912. how do i retrieve an excel spreadsheet i was working on
  913. Creating cell names from cell contents en masse
  914. Define variable range input for SUM() function
  915. stacking if functions
  916. XL07 create data validation list containing the names of each shee
  917. Anniversary of a date is due - conditional formatting
  918. Entering a formula using excel 2003
  919. How do I find a match for three variables to determine the result?
  920. Convert european foreign date format to US date format
  921. How do I format every 140th row?
  922. Summing a column
  923. Count based on two different criteria
  924. Disabling copy/paste hidden cells
  925. sorting ranges of various column lengths, lookup values in columns
  926. Applying users to site/names
  927. Toolbar built for 2003 not loading in 2007
  928. I Need a Tearoff Color Palette
  929. Using INDEX & MATCH to VLOOKUP prior column
  930. Macros
  931. Vlookup
  932. cursor movement wrong
  933. Inserting a comment box in a protected worksheet
  934. Use cell to determine column in formula
  935. Excel: Last non zero value in a row
  936. Count Number of Rows
  937. Conditional Formatting
  938. Conditional formatting from one sheet to another
  939. Error moving from 2003 to 2007
  940. Excel Table Conditional formatting not doing what I want
  941. Return Formula
  942. how do i sum the same cell in numerous sheets behind a main
  943. Sequence of Weeks in a month
  944. Sort two tables of data
  945. VLOOKUP - search key is more than once available
  946. Vlookup inside a formula
  947. Convert figures to Hours and minutes
  948. Supplier list
  949. How do I get a cell to highlight when a deadline date approaching
  950. Round to .05 or .09
  951. GL Codes
  952. Separate names into columns
  953. lookup formula unexpected results
  954. lookup formula unexpected results
  955. Returning a value if false
  956. How to copy formulas sheet to sheet in excell
  957. mortgage payment calculation
  958. Find the lowest4 numbers of the last 6 in a range
  959. Convert numbers to date: "586" to read "May 1986"
  960. SumIf statement: incrementing
  961. Summing Values/Outputs of IF formulae
  962. Find the first or last populated column in a range
  963. SUMIF or SUMPRODUCT?
  964. Excel, two text fields equal the number 1 per occurance
  965. Normalizing Excel data across rows
  966. Can I delete the data and keep formulas for a whole worksheet?
  967. Formula for counting and dividing
  968. Sorting Dates in format "01/19/09"
  969. VLookup multiple spreadsheets
  970. how to select the first character in a cell and delete the rest
  971. Keeping a text box on the worksheet
  972. Sort w/o header row - change default
  973. Need formula creation
  974. Lookup and return any missing numbers if applicable
  975. sumarize minutes and get the result in hours
  976. Birthdate 01/01/2000 Remove Slashes
  977. Row height will not auto format
  978. Lastrow
  979. How to use time in an IF formula
  980. help calculated total for each month
  981. Calculating a value but omitting cells with empty data
  982. How a cell having name of lookup_vector be used in lookup function
  983. Visit Calculation
  984. How do I get a index% of two numbers when they are negative or pos
  985. i NEED TO GET A FORMULA FOR (x-AVERAGEX) ?
  986. unable to access the commands on the data tab.
  987. Estimating Stock Trading Range From Historical Volatility
  988. Mutliple Function Query - probably using Countif
  989. Postcode Area extract first alpha letters
  990. I want to count the total number of date
  991. Using the information from a pivot table
  992. Round formula
  993. Eliminating Blank rows
  994. Can't get email addresses to be "hot" when using lookup
  995. Check for error.type in same cell
  996. RANKINGS
  997. Two search arguments in array formula
  998. I need help with a formula........please
  999. replaces formula to its value
  1000. Data manipulation help