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. how do i link dates between worksheets?
  2. Random Timetable Generation
  3. is there anyway to flip a column in excel?
  4. PROTECTING SHEET WITH PIVOT
  5. Can you help me to install on explorer, in order to retrieve our .
  6. Can you help me to install on explorer, in order to retrieve our .
  7. Can you help me to install on explorer, in order to retrieve our .
  8. Can you help me to install on explorer, in order to retrieve our .
  9. Can you help me to install on explorer, in order to retrieve our .
  10. Functions referencing unopened workbooks
  11. Filters and Check Boxes
  12. RE: VLOOKUP : problems !
  13. hiding error message
  14. Use of the DSUM formula to find exact matches in datatables
  15. Warn if data is in range
  16. Why does Excel XP say that 25-25.08+0.08 = 1.706975E-15 instead o.
  17. Formula Arrays VERY SLOW in Excel 2002
  18. Summary worksheet referencing multiple worksheets
  19. can't insert row in shared workbook
  20. Sum cell numbers that have certain text within the cell
  21. How do I use a rounded calculation result in another calculation?
  22. How do I use a rounded calculation result in another calculation?
  23. Calculating tvl time in Excel 2000 Rev.9.2720
  24. Empty space in formulas.
  25. Formula returning #N/A
  26. changing value in a cell
  27. Worksheet links
  28. Return a picture using IF formulas
  29. count a group of numbers but do not count duplicates
  30. Find a duplicate value within a list?
  31. Difference between ExcelXP and Excel 2003
  32. How to move cell to cell with tab key
  33. Calculating Percentages with Variables
  34. Printing switches focus off proper sheet
  35. How do I copy page set up attributes from one worksheet to anothe.
  36. lookup array
  37. Formula help for using a range of cells!
  38. How can I automatically update column index number in VLookup whe.
  39. Eliminate creating list that returns blank cells
  40. Cell Reference Math
  41. Update second worksheet with changes in original worksheet
  42. overtime on timesheet
  43. Formatting Fields
  44. division and decimal points
  45. splitting and rejoining text in cells
  46. Counting specific text in a cell
  47. Is there a keyboard shortcut that takes you to the next workbook .
  48. Function to look at two cells and return a third
  49. Combo Charts
  50. How can I make Excel return the text in column A only if there is.
  51. How do I change how PivotChart data is summarized, from sum to av.
  52. Changing the Color of a Word in Formula
  53. Is there a template for rapid debt repayment in Excel?
  54. How to monitor productivity within departments using Microsoft Exc
  55. Is VLOOKUP the right function?
  56. Currency in cell ref
  57. Error Return Value from and INDEX(A:2,MATCH()) function
  58. Variable validation-password protect sheet
  59. Date format within a text syntex?
  60. Macros and different lengths of files
  61. Pivot table. Calcualting % from subtotals.
  62. How to write IF function in Excel 2000 when there are two conditi.
  63. Comparing 2 Customer Lists to Identify Shared Customers
  64. Date
  65. COUNTIF
  66. Is IF the best choice
  67. How to : SUM - IF formula
  68. multiple spreadsheets in Excell
  69. vlookup data hidden within worksheet
  70. Vlookup not returning correct value
  71. 'IF' FUNCTION for 2 columns
  72. How do I test a cell for part of text
  73. RE: Summarising table entries
  74. text and numbers
  75. Subtotal Macro
  76. Formula help please
  77. index,match + 1 cell below?
  78. EVERY Chord, Scale and Mode for GUITAR.. Literally!!
  79. mass change table_array Name in VLOOKUP formula
  80. How do I lock hidden columns?
  81. How do I prevent incorrect formula results appearing in cell?
  82. keep a cell used in a formula constant when pasteing into another.
  83. keep a cell used in a formula constant when pasteing into another.
  84. add cell a to cell b on worksheet ( both cells linked to other cel
  85. Drop subsequent ref rows if(condition)
  86. Excel Rule/Formula
  87. IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP(
  88. Custom Validation
  89. Does font affect indent spacing?
  90. Worksheet template variables
  91. copy/print specific data
  92. Totalling values across columns
  93. Hiding or changing #N/A value
  94. Excel 2003 is changing my date formats
  95. Copy & Paste Visible Cells with Formulas
  96. Building list based on condition
  97. Multiple rows converted to one row
  98. find replace ??*
  99. Creating a calendar in a cell for a date-picker
  100. timesheet with running total of overtime
  101. missing deadline
  102. Lookup names to get data
  103. Count Unique Names in list w/ Additional Criteria?
  104. Data Validaion Challenge
  105. Autofiltering multiple tables on a spreadsheet
  106. Need a Macro
  107. please help save me some time!
  108. Custom Number Format...
  109. Comment Boxes
  110. Lotus @xindex equivelant in Excel
  111. Looking for an easy way to replace letters with acutes
  112. converting days to months
  113. Set "print all text as black" as default in Excel
  114. Using the Control Toolbar
  115. Sorting after subtotaling
  116. Comparing two List that a "Close" but not Identical
  117. Does the cell have a number?
  118. How do I format the date to show mm/dd NOT m/dd?
  119. How do I find a mode while disregarding a specific cell value?
  120. Separating data ( 1 time range) in one column
  121. minimum greater than zero
  122. dynamic combo boxes
  123. Using large excel files
  124. change date function format in footer
  125. Trim function doesn't clean out ASCII Code 160 (Space)
  126. Run-Time Error: You must select a shape
  127. Format spreadsheet so no input allowed if certain cell is =<0
  128. how to use vlookup formula
  129. Changes to Mulitple Worksheets
  130. When updating a worksheet, how do I create a link updating the sa.
  131. Calculate time difference to the half hour
  132. Active cell blinks for no reason while running inside of Citrix XP
  133. PULL function
  134. how do i calculate my mortgage payments
  135. PMT Function
  136. How do I auto increment cell value on print in Excel
  137. Please Help...How can I do this? Select a cell
  138. RE: Unable to unlock protection, Option Grayed out
  139. FIXED formula problem
  140. IF(ISNA formula problem
  141. Date Formatting change
  142. conditional formula
  143. is there a forumla to hide rows?
  144. Formulars
  145. How to copy VBA project?
  146. Re: VLOOKUP (?)
  147. Re: Sum If Multiple Conditions
  148. Data Validation
  149. vlookup when data is not all in same row
  150. Do you have instructions for making check boxes?
  151. Do you have instructions for making check boxes?
  152. social security sorting
  153. The impossible?
  154. VLookup ... Left side?
  155. Trim function
  156. RE: Procurar resultado de array com duas variáveis
  157. Vlookup info being used without vlookup table attached?
  158. How can i create pivot table from different worksheets with diffe.
  159. Help with Complex SUMPRODUCT formula
  160. Vlookup datatype(?) issue
  161. Count number to reach a cumulative value
  162. how do I adjust working calendar (6 day work week) in excel that .
  163. How to compile marketing survey form result into a chart
  164. delete all text to the left of???
  165. MOD function
  166. RE: rounding to a specific number
  167. validation of times
  168. Getting an exact match
  169. RE: formula to combine cells using if/then
  170. How sort dates just by day/month and NOT year if all 3 given in ce
  171. Re: No Gridlines
  172. How do I format a column to automatically make it a negative numbe
  173. Function question
  174. Re: Why does excel use different denominator for variance and covarian
  175. Using SUMPRODUCT...but prolly not correctly
  176. Re: Dialing from Excel
  177. RE: Adding values for prior date intervals
  178. How do I auto fill formulas
  179. Renaming a column or heading?
  180. Re: timesheet with running totals of overtime
  181. Re: Increase the number of the invoice
  182. RE: sumif and array formulas
  183. No Subject
  184. Date calculations before 1900 do not work
  185. How do I hide a column based on a condition (option not available.
  186. Re: # of Functions per cell >> for Harlan Grove
  187. vlookup to other files
  188. Function to return the latest non-zero value in a range of cells .
  189. #n/a
  190. Calculating percentages
  191. How do I retain print setup when copying a worksheet?
  192. Using VLLOKUP
  193. inventory in excel
  194. Empty Cells in validation List
  195. Validation List and VLookup are ackting strange
  196. Data validation
  197. Import - blank cell problem.
  198. Templates for Imported data
  199. How to use IF
  200. Customer Number Format
  201. meaning of -- in the formulas
  202. how do i link a number of worksheets to one master worksheet?
  203. How to remove hidden grapics from copied web page pasted in Excel.
  204. Function equations
  205. Sumproduct, By Quarters and Amount
  206. Using Worksheets in Windows XP
  207. what allows me to select cells for use in a formula by using a mo.
  208. workshhet variable
  209. How to recover worksheets lost when I opened an Excel file in Wor.
  210. Best technique to perform multiple calculations ?
  211. Formula for Sequencing Totals
  212. Graph Linking
  213. How do I create a daily spending spreadsheet in Excell?
  214. Counting for two criteria - brain drain
  215. Using CONCATENATE function to create email addresses from a list
  216. Replicate right from A2,A3,A4 TO B1,B2,B3 etcetera
  217. combining VLOOKUP and IF
  218. Lookup from another sheet
  219. Office 2003 Purchaser can't add in the add in's. Why?
  220. Combobox creates error
  221. Basic Formula rules
  222. protect cells in csv
  223. Missing commas
  224. paste excel table to word
  225. how do I set up a total amount automatically in excel
  226. CONVERT HEXADECIMAL CELL TO DECIMAL NUMBER
  227. How do I graph normal probability distributions in excel?
  228. # of Functions per cell >> More
  229. Totaling Cells in Worksheets
  230. Cursor highlighting
  231. What is the formula to sum the last ten entries in a row in an Ex.
  232. If functions with Text << Response to Karen
  233. How do i number pages in a header consequently
  234. # of Functions per cell
  235. How can I calculate the difference between times without using th.
  236. Pasting links
  237. How to Calculate Dates without counting the weekends
  238. removing duplicates testing in 2 coloms
  239. Counting days worked
  240. =Cell( , )
  241. Wash Sale Formula
  242. how do I get AVERAGE to ingore a zero value cell
  243. how do I get AVERAGE to ingore a zero value cell
  244. convert cm to inches
  245. Weekend days other than Sat Sun
  246. Buttons
  247. Comparison Function
  248. How to publish excel sheet to web with autofilter functionality?
  249. copy a sheet in same workbook temporary block excel
  250. automatically resorting of new entries
  251. Vlookup query
  252. Order ranking. Any suggestions?
  253. Excel 97 - Adding Every 8th Row - Formula should work, but doesn't
  254. Paste table from excel to word
  255. Indirect and dynamic ranges
  256. Find (Ctrl +F) not searching all open sheets
  257. getting a percentage
  258. return header as result in excel
  259. Formula to Calculate Age
  260. FIND formula that searches from right?
  261. Average Function help
  262. 43 Columns
  263. Can't paste cell copied from hyperlinked file
  264. how to make a title always on the page on excel 2003
  265. How do I calculate IRR?
  266. How do I round up the result of a sum
  267. Lbs and Ounces
  268. user defined date
  269. 7+ Nest If's
  270. Linking Workbooks
  271. Excel 2003 Hide PivotItems
  272. Pivot Tables
  273. pivot table, functions for subtotals
  274. Simple #DIV/0! error
  275. jumps cells
  276. Data Validation
  277. SUMIF problem
  278. mouse selects area
  279. how do i copy formula and change worksheet instead of cell
  280. how to sum cells and ignore the #div/0! 's ?
  281. How can I count cells that meet two criteria within a filtered co.
  282. percentile
  283. Paste table
  284. Count formula
  285. Cannot get border line on right of table to show.
  286. SUMIF PROBLEM
  287. How do I make the custom headers and footer repeat on every works.
  288. Return a date 6 months from a date in another cell
  289. 2 condition Duplicates
  290. Problem with named formula's
  291. How would I make a calendar template in Excel for the year 2006??
  292. Formula
  293. Display another cell have a cell containing its location.
  294. Question
  295. Time In Decimals
  296. Creating Excel bookmarks
  297. How do I sort by row instead of by column?
  298. I need to have only the values show in a spreadsheet.
  299. What Functions should be used
  300. return a " " for null values
  301. is there a formula to generate a calendar month date rather than .
  302. how do I add data validation dropdown lists to a Form
  303. IF(SUM) help please
  304. Conditionally formating weekends
  305. #N/A
  306. Check if table contains text
  307. EMBED Function with AutoCAD
  308. How do i change all numbers in my worksheet
  309. Excel workbook crashed
  310. EDATE &EOMONTH problem
  311. I want to use Vlookup function and AND function in a single formu.
  312. Add up Plus & Minus Figures separately by Location
  313. Vlookup
  314. dynamic ranges
  315. Count function in excel with different conditions
  316. Why won't colums add if new infor mation is added?
  317. Add a formula to Pivot Table
  318. automatic color change in cells using a drop down list
  319. How do I secure borders, make them unaffected by copying or draggi
  320. Rank Formula
  321. Replace Letter "E" with Letter "C" for 200 Different Sums in a Col
  322. Pivot Tables..I give up...
  323. Find number of days between to dates
  324. Dynamic Formulas with Dynamic Ranges
  325. Vlookup
  326. toolbar
  327. Use DocProps in a change declaration
  328. Another Date Formula Request
  329. How read and calculate data from one worksheet to another?
  330. Help needed with priority list
  331. Date?
  332. number of week
  333. conditional formatting adjacent cells
  334. Hyperlinks between versions
  335. VLOOKUP
  336. Total of differing dates
  337. Average Non-Contiguous numbers
  338. Exam scores
  339. VLookup? Or something else
  340. Is there a way to display when a document was last saved in a foot
  341. GetPivotData
  342. CELL PROTECTED IN 2000, UNPROTECTED IN 2003
  343. Unique count of text
  344. How do I convert dollars and cents to text, and prefill the cell .
  345. Formulas
  346. What is the quickest method to insert & name multiple worksheets .
  347. How do I change the colour of/remove the Freeze Panes line in Exce
  348. What is the quickest method to insert & name multiple worksheets .
  349. Conditional Formatting and ISBLANK
  350. nesting sum if and
  351. How to update multiple links in multiple spreadsheets followin mo.
  352. daily average
  353. Can one still create a graph using data in the worksheet?
  354. Pasting formulas to different rows
  355. Conditional Formatting Cell and Row
  356. If function display
  357. How do I place an excel worksheet name in a cell?
  358. How do I use vlookup to point to an external file that changes nam
  359. Worksheet reference (i.e placing worksheet name in a cell)
  360. Holiday chart
  361. Convert entire columns of text email addresses to hyperlinks
  362. EXCEL FORMULA
  363. if function display
  364. copy subtotal information to new sheet
  365. Help with array formula
  366. Data isn't being recognized.
  367. limit a value using discounts
  368. tab delimited files
  369. password for worksheets cont...
  370. IF statement based on data type
  371. Building a table with formulas rather than a macro
  372. Exctracting Data
  373. Change workbook sheet reference using cell A1 to change a vairable
  374. save excel spreadsheet as a csv file
  375. The Help on the Excel Edate worksheet function contains an error:.
  376. if isna and vlookup together
  377. Is there a way to make a drop down list in Excel that lets you se.
  378. resize worksheet
  379. Converting months to years
  380. Need absolute time from yesterday
  381. Error in SERIESSUM
  382. Problem with wrap text format
  383. No VBA help for Worksheetfunctions available
  384. Worksheet Buttons (Save, Save As, Cut, Paste, etc.) Not Working
  385. Incrementing rows (or columns) to a reference in another worksheet
  386. SUMPRODUCT HELP
  387. COUNTIF text where there is more than one word in a cell
  388. Formula won't reflect new cell data
  389. Inserting Columns
  390. Copy and Paste Formula Without the linked file path
  391. Show a time from one calculated cell as a decimal in another cell.
  392. Newbie needs a function (how sad)
  393. ? on "date last saved" in cell
  394. Need conditional formatting formula to highlight top ten values i.
  395. Determining number of days between dates
  396. How do I calculate sum based on 3 conditions?
  397. How do I use MINVERSE in Excel?
  398. Sheet Names and Cell References
  399. Comparing Two Sheets
  400. HELP!? Passwords are driving me crazy.
  401. IF function using a dates as the qualifier..
  402. Cells displays formula, not results
  403. Counting Data From A Query
  404. Is there a formula that will place the sheet name in a cell?
  405. How do I get a table from IE into excel?
  406. Calculation Method for Quartiles
  407. Date Function
  408. skipping columns part 2
  409. How do I set a mimimum quotient value?
  410. Total two pivot tables into one
  411. sum values between today and 6 months prior
  412. Excal Concatination of cells that are not empty
  413. Turn off warnings in Macro
  414. IRR
  415. Edate problem
  416. SumIf function in Excel
  417. Extract text
  418. How to express this in an if statement.
  419. how to disregard the DIV in a range
  420. Input Control
  421. How do I use a pivot table value to reference a worksheet
  422. can't change sheet name on tab
  423. skipping columns
  424. Calculating current age from 2 date cells
  425. Geomean range
  426. change text color based on logical test
  427. Having a due date flag in a different colour 30 days from current.
  428. Add more lines and more columns in Excel
  429. I want to update the formula in a spreadsheet from 04 to 05. Is .
  430. How can I combine text and a function in a single cell
  431. In Excel, how to sum top 10 greatest values in a row of numbers?
  432. exporting data to a secondary spread sheet
  433. SUM values between dates
  434. SumIf(values of non calculated cells in a row...)
  435. Changing Colors in Bar Charts
  436. Sumproduct sheet reference
  437. Shared Workbooks
  438. Converting text to a number
  439. Page Breaks
  440. Sum If with two or more conditions
  441. HOW CAN I FILL AN EMPLOYEE CARD WITH EXACT DAYS CALENDAR
  442. Count based on color
  443. Limited amount of labels in exces
  444. how do i get numbers in arabic not hindi?
  445. Bernie Deitrick
  446. Date conversion
  447. Can I use Print in an if formula?
  448. Can it be done
  449. Is there a VLOOKUP substitute when data is not in ascending order
  450. Multiple Data Validation Criterias
  451. Using wild card characters in array formulas
  452. How do I nesting subtotal function within average function in Exc
  453. can you prevent viewing of specific columns in a worksheet
  454. Option Buttons move after placing on sheet
  455. Finding the maxium value of a column
  456. Separating text
  457. Scenarios tutorial
  458. LOOKUP and COUNTIF
  459. To data apearing in other sheets I can use =SUM(. How I can have .
  460. convert to seconds
  461. In Excel, I need to now how to pick the second highest number in .
  462. Can this be done...
  463. Calculating an AVG from data on another sheet
  464. How do I auto-fill consecutive dates ?
  465. SUMIF FUNCTION
  466. Weekly Transaction Processing
  467. sum of the result from the formula?
  468. Posting in the next row
  469. If statement and Isblank statement
  470. n or U Revised ?
  471. Creating a Formala
  472. Frank Kabel: A Sad Day for the Excel Community
  473. ADD TIME IN EXCESS OF 24 HOURS
  474. An easy macro question and one I believe to be a little more diffi
  475. Running Macros in protected workbook
  476. Odd numbers
  477. Replicating Worksheet References in Formulas
  478. Replicating Formulas with Various Worksheet References
  479. Large() with twist
  480. Define Name and SUMIF
  481. Create formula
  482. auto zip code
  483. Cell encryption
  484. SUMIF
  485. Q207 is the problem
  486. Re: Formulas not working
  487. Repeat Cell Data
  488. N or U
  489. Display row numbers of a range
  490. When I "Save As" I cannot get
  491. How can I show hours of more than 24 & negative hours?
  492. Fill dates with weekdays/workdays only
  493. Formula to a Cell Reference
  494. List ? - How do I make information in one cell determine list to u
  495. In Excel 2003 SP1, "sort" on the Data drop-down menu is grayed ou.
  496. Is is possible to run macros on a protected worksheet
  497. If function
  498. Geo mean extended
  499. Converting text to a number
  500. french accents in excel
  501. How can I attach a custom toolbar to only appear on one specific .
  502. Help with a formula please
  503. Extracting just the color words
  504. How to show negative time (e.g. -10 hours)
  505. Microsoft excel changes the hyperlink in 2003 from 2000 automatic.
  506. Dates before 1900
  507. Count/
  508. Sumproduct help needed!
  509. Adding Range Names
  510. Ron de Bruin Copy2 Macro - troubleshooting
  511. How do I calculate interest on actual date?
  512. I cant get this to work:(
  513. Data association
  514. How to add page breaks to embedded spreadsheet
  515. Find Max after a date
  516. formula for "coefficient of variation"
  517. Sorting with underlying formulas.
  518. Calculating interest on number of days in the period
  519. Multiple Work Sheets
  520. Max value in formula/function
  521. formula to copy last positive number in range of cells
  522. Insert value of a cell as a filename
  523. setting cell color
  524. Keyboard Shortcuts combinations of function keys, c...
  525. Conditional summing with large amounts of data
  526. Linking and/or macros
  527. Formatting dates in the future
  528. Macro to sum array by date
  529. How do I find highest number in a row and change color?
  530. formula to calculate a time sheet
  531. formula to calculate a time sheet
  532. lookup misses the first entry in table
  533. Sum Function sometimes displays incorrect answer
  534. Help With Expanding A Formula
  535. Subtotal results in new column and then sorting subtotals
  536. how do I sort a column with several categories (ie red and blue)
  537. need help w/formula for calculating overtime hours
  538. 2 way lookups
  539. Hiding columns based on user/password
  540. How do I SUMIF with two criteria in two different columns?
  541. Need Macro to copy specific sheet
  542. Conditional Formatting based on Formula
  543. Geo average
  544. RE: Pivot tables, external data sources and ODBC links
  545. How do you copy a cell formula down a column without displaying n.
  546. Average (geometric)
  547. How do I change my DSN without recreating the odbc connection?
  548. How do I make a cell equal to another cells value and not it's fo.
  549. self-building dropdown list
  550. Pivottable Wizard Syntax
  551. concatenate a text string if two different cells contain the sam.
  552. in excel totaling weekly hours military time
  553. Using IF function to copy.
  554. comments in Excel 2002
  555. Not Sure Which Function to Use for This
  556. how do i multiply hours:minutes by a cash value?
  557. hyperlink error: "Cannot open the specified file"
  558. Error being returned
  559. Alternative window size?
  560. Time calculation.
  561. Conditional operation
  562. Re: How to calculate days:Hours:Minutes:
  563. Filter arrow colour in Excel
  564. Multiple VLOOKUP
  565. Help on Prompt
  566. Wekk numbers and dates
  567. Lookup List to Index
  568. formula and cell link movements
  569. Formula to return cell contents based on multiple conditions
  570. formula won't work
  571. formula won't work
  572. VLOOKUP
  573. merge data from multiple columns to single column
  574. how do I hide cell value
  575. How can empty cells automatically highlight after 24 hours?
  576. Analysis Toolpak add in
  577. Calculating for number of days when values are in dates
  578. How do I write a conditional statement in Excel to count if two c.
  579. select multiple cell ranges in "sumif" formula?
  580. Adding times together
  581. Conditional formatting
  582. Hiding Sheets
  583. How do I change a number from 700.00 to 70000 without having to re
  584. Re: "Conditional" summing
  585. hex to decimal convert
  586. Excel 2003 REDO Button
  587. text and formula justify??
  588. Offset() relative addressing Row parameter
  589. Greater then/less then
  590. Print increment by 1
  591. Need formula for sheet & cell reference
  592. How do I sum cells containing formulas ?
  593. Re: How To Suppres #N/A Values
  594. Formula help
  595. Problem using 'PROPER' with apostrophes
  596. automatic date
  597. Autosum ignores cell values
  598. Several Dates -Verify
  599. Save as or export with values only
  600. userform textbox
  601. Can I change the font size in a Combo Box ?
  602. What's the simplest way to copy data from another workbook
  603. Validation
  604. How can you find duplicate numbers in a column?
  605. Use Conditional Formats to highlight blanks?
  606. Problem with IF condition or vector lookup?
  607. automatically change nvoice # on template
  608. Calculating Age
  609. How do I change certain cells to Uppercase
  610. How to create mandatory cells in a worksheet
  611. Add up a Dynamic Range with 2 Variables
  612. Add up a Dynamic Range with 2 Variables
  613. Add up a Dynamic Range with 2 Variables
  614. Prompt before updating values
  615. #VALUE ! errorr for links to other workbook
  616. Finding decreased value PLEASE HELP ASAP!
  617. Edit Hyperlinks
  618. populate cells with data from another sheet
  619. Add an XML map to a workbook
  620. countif
  621. HELP ON IF
  622. Link to specific sheet
  623. How do I display the h:mm minutes in hundreds?
  624. can i make a formula to search keywords in a excel workbook?
  625. convert a nine digit number to base 32
  626. invoice auto numbers
  627. how do I download TVM(time value of money) tables
  628. formulas for employee time sheets
  629. Re: MANY ESTATE INVETMENTS BY A GROUP
  630. Can you conditional format based on information in cell comments?
  631. Copying worksheet from workbook to another
  632. average of spaced cells
  633. insert a space in a phone #. change (123)456-7890 to (123) 456-78
  634. Is there any way for me to allow or restrict individual users' ab.
  635. How do you add gridlines?
  636. SumProduct help
  637. How can I get "Insert copied cells..." to not be grayed-out?
  638. Area Under Curve
  639. Number formatting
  640. checkbox and macros
  641. Changing Dates in Excel
  642. i want to share a workbook, but not all of the worksheets.
  643. VLOOKUP from a file on another server
  644. FIND or LEFT or MID to swap first name with last name?
  645. increase a cell reference by increments greater than one...
  646. In Excel 2000, can I print the header on the first page only?
  647. Hyperlink Length
  648. Sumproduct - Blanks
  649. How do I copy formula cells from one worksheet to another?
  650. Automatic formatting problem in Excel
  651. Converting $60,000 to "Sixty thousand"
  652. Find and copy??
  653. How can I remove a formula from a cell and still have the value?
  654. Cell shows formula and not the result of the formula.
  655. Cell shows formula and not the result of the formula.
  656. copy and paste formulas
  657. Shuffling Data To Make Lists Match
  658. Column headings
  659. ARRAY FORMULA-RETURN 0 INSTEAD OF #DIV/0
  660. LEAVE BLANK IF NEGATIVE
  661. 2003= negative number&2004= negative number How Do I Calculate gro
  662. Excel worksheet tabs navigation
  663. Rounding a number down to the nearest 5?
  664. For Microsoft Excel: Consider including the Format-Change Case fe.
  665. VLOOKUP problem
  666. tally
  667. Global formula
  668. Global formula
  669. In excel, can I format a cell to automatically take the curser to.
  670. 插入*檔日期
  671. OFFSET function to pick up monthly groups of data
  672. how do I convert numbers to a different base in Excel?
  673. smallest
  674. List incrementally?
  675. need to show date countdown
  676. How do I add help text to an excel function I have created
  677. AND OR formulae
  678. ENTER EXCEL FORMULA WITH MORE THAN 7 NESTED FUNCTIONS
  679. Parts Stock controller...
  680. Selecting shaded cells in a row
  681. networkdays
  682. How do I enter a date before 1900 in excel?
  683. How do I enter a date before 1900 in excel?
  684. Numbers from seperate worksheet to common sheet
  685. Help adding text values
  686. autofilters
  687. Is it possible to change colors of cells based on value in cell (.
  688. SUMPRODUCT more help
  689. Changing Upper case to Proper Case
  690. % of Schedule Calculation
  691. How do I view the actual numeric value of a formula in Excel 2002.
  692. Extracting and using Text from external sources
  693. =IF Statement formula or conditional formatting
  694. displayed cell values
  695. Multiple OR function
  696. Matching data in one column to another
  697. Row numbers blues
  698. SUMPRODUCT help
  699. Pivot Table % calculation
  700. Validation
  701. Question for Peo
  702. how can I skip weekends in excel?
  703. excel
  704. concatenating cell references
  705. Highlighting(coloring) totals in a pivot table
  706. COPY TEXT BOX
  707. how do i insert a combobox in excel
  708. in excel - i have a row of cells i need to make 'unique' and do n.
  709. how do you share an open excel file
  710. multiple vlookups
  711. Count the occurance of upper or lower case letters
  712. Vlookup Error
  713. Userform
  714. YIELDDISC
  715. More than 65536 to new sheet
  716. excel
  717. What is the formula for dividing a number by 4 in excel
  718. Converting "ADDRESS" Results to data referanced
  719. Should Merging workbooks pick up new data or only edited data?
  720. Sum if certain criteria is met
  721. total same cell in all worksheets
  722. Cash Flow Set-Up
  723. =SUMPRODUCT and =IF
  724. How to convert a decimal number to a non-decimal number?
  725. Losing numbers
  726. Shared Workbook - Defining Access Rights
  727. How do I create a formula to calculate the average percentage rat
  728. How do I save sheets in a workbook to separate files?
  729. Links Cannot Be Edited
  730. Networkdays
  731. I have a permanant footer. I have deleted it several times but i.
  732. VLOOKUP is not sufficient
  733. count weekdays in a date range
  734. calculate difference in time to hours
  735. Min & Max Averages
  736. Re: SUMPRODUCT ON TIMES
  737. Rounding up the result
  738. how can I use a function to find out if an individual cell is par.
  739. Formula needed
  740. Currency conversion
  741. order worksheet alphabeticly
  742. Nested if, sum & vlookup Function
  743. Sum per month
  744. Q: compare and replace in a workbook
  745. DATE SORT BY COLUMNS
  746. Average
  747. fourmla with result no less than assigned value
  748. SUBTOTAL and then count with criteria
  749. Data Validation
  750. Can you keep column (field) names visible while scrolling downwar.
  751. Find if value in column A exists in Column B
  752. Edit/Find/Options/Look In/Values
  753. How Can I copy a sheet that has hidden rows without copying the h.
  754. Convert one row and 50 columns of info to a single printable page
  755. Pivot table tutorial..helpppp!
  756. Naming a cell
  757. returns calculation using sumproduct
  758. Excel 2002 help
  759. How do I find where a column value and row value intersect?
  760. VLOOKUP across all sheets in a workbook
  761. looking to assign different numbers in column B to different words in column A
  762. Formatting cells Auto fill color using “If”
  763. hide/unhide cells
  764. how to link an entire worksheet to another
  765. have 3 worksheets, 1 is a form, the other 2 data for the form-wan.
  766. geomean ignoring blank cells and chars
  767. What formula is used for subtracting a range of different cells f.
  768. Vlookup Function Problem
  769. Hard Page Break
  770. Array Help
  771. pivot table row vs column headings
  772. multiple vlookups
  773. Rank() based on category
  774. datevalue
  775. INDEX,VLOOKUP HLOOKUP ?
  776. can the negative numbers in an IF statement be in a diff color th.
  777. can the negative numbers in an IF statement be in a diff color th.
  778. CountIf Function - require range of criterea
  779. Calculate work hours between two dates
  780. Can there be a third choice in an IF statement?
  781. In COUNTIF function, how do I count the number of cells which con.
  782. How can I automate a 16 man wrestling bracket in Excell.
  783. Array Functions - Two Questions
  784. Formatting Cells
  785. IF Function Help due to 7 limit
  786. Worksheet name
  787. Are there too many arguments
  788. Averaging Numbers when 2 numbers in one cell
  789. “Use of more then 7 nested if statement”
  790. “Use of more then 7 nested if statement”
  791. Worksheet name
  792. Pulling data from 1 sheet to another
  793. Duplicates
  794. solver
  795. Datevalue if born before 1930
  796. Calculation II
  797. How can I add non-adjacent cells with a formula
  798. “Use of more then 7 nested if statement”
  799. How do I calculate difference in days & hours between two dates e.
  800. formula to count numbers of certain values
  801. Colors Dont match
  802. Excel Miscalculates simple formula..Help!!
  803. Date function
  804. excel templates for gradebook
  805. Comparing dates in an IF function
  806. Can't get simple macro to run
  807. indication of empty cell
  808. Font too small in Incell drop down list
  809. Calculation within IF function
  810. Fourier Analysis
  811. Re: SUMPRODUCT ON DATES
  812. Conditional formatting refering to another cells' value
  813. Formula for name of Sheet
  814. How do I replace a worksheet with another worksheet in excel
  815. How do I ROUND() round off decimals of a column dataset?
  816. Counting Cells with multiple criteria.One criteria supporting wild
  817. Counting Cells with multiple criteria.One criteria supporting wild
  818. How do I unhide rows 1 through 28 on an Excel worksheet?
  819. Add same set of formulae at defined intervals to list of row data
  820. sorting the row by numbers
  821. sorting the row by numbers
  822. How to make empty cells as zero in excel add-ins for SQL Server an
  823. Invoicing
  824. Average If
  825. >> IRR function
  826. Include several choices in an IF statement.
  827. Data tables using variables
  828. Conditional formatting based on if statement.
  829. countif a date is greater than today
  830. Need a formula for this problem
  831. How do I give all access to one worksheet but not to other worksh.
  832. Counting Dates less then today
  833. When copying dates to another sheet the dates are different
  834. Help to fix formula ="Yes"
  835. functions
  836. Compound interest calculation
  837. I want to chage a whole rows text color based on single cell valu.
  838. Notequal(Char(252) Help!
  839. SUMIF - Range name to used for the "sum_range" portion of a SUMIF function
  840. Cell lock help
  841. Trouble with Excel 2000 not calculating/performing formulas
  842. Complex Sales Tax
  843. I cannot open a hyperlinked file
  844. Validating random numbers
  845. remove external addins
  846. Vlookup
  847. If statment
  848. Adding a month
  849. It looks and acts like a Comment but it's not.
  850. Lookup
  851. An in between lookup function
  852. Dates
  853. Does cell contain formula without using UDF
  854. Paste functions into a new XLS
  855. one more thing
  856. How can I change decimal amounts to end with .95
  857. after calculating, round a cell value
  858. Write formula to add "1" to each number in a column
  859. table
  860. Excel: How to import numbers from one spreadsheet onto another.
  861. OR function into a IF function
  862. Using a grouping of cells to check one cell against another...
  863. removing part of a #
  864. removing firsts two numbers from a list of #s
  865. Looking for a function that will add value to another cell
  866. Can I print an excel worksheet w/o A, B, C on top and 1,2,3 on si.
  867. Share Excel worksheet custom header/footer throughout workbook.
  868. Drop Down List
  869. Excel 2003: Match one list against another and highlight differenc
  870. refresh pivot tables through a macro
  871. conditional formatting conflict?
  872. getting multiple data to populate another worksheet
  873. Sumif, 2 criteria
  874. Date in descending order to come up automatically in a column?
  875. Formula to Sum a definable range of workbooks
  876. Moving columns with VLOOKUP formulas
  877. Missing Row
  878. Increase prices accross the board
  879. problem with adding columns of numbers
  880. templates
  881. dating problems!
  882. Showing the column of current day
  883. How do I cut & paste non-adjacent rows or columns ONLY in auto-fil
  884. Date Calculation
  885. How to run the Hodrick Prescott test with solver?
  886. Can I change the 15-digit limit in Excel for numbers ?
  887. calculations from data in other worksheets
  888. Updating links
  889. Removing Hard Borders from Excel Spreadsheet
  890. When VLOOKUP returns a #N/A How can you get it to replace #N/A wi.
  891. merge excel form with excel datadase how can i do
  892. Re: Function Formula is displayed not results
  893. Enter Data Into Another Excel File Automatically
  894. Dropdown menu
  895. #VALUE
  896. SUMPRODUCT TO CALCULATE VISIBLE CELLS ONLY
  897. time format multiplied by hours worked ?
  898. percentage of sales
  899. Worksheets
  900. how to reuse formatted worksheets from 2004 in 2005
  901. In Microsoft Excel, how to I enable the arrow keys?
  902. excel tests
  903. how do i locate a template for late payment fee
  904. Vlookup & Lookup function error
  905. How do I use a function in a footer?
  906. Excel Date Format - Stop?
  907. Using The Average Function if a cell has NA
  908. Percent formatting
  909. Array look and Sum
  910. How do I use solver to find which cells add up to a certain amoun.
  911. Setting up a macro to print?
  912. Stop % showing in outcome of formula
  913. If Then statement help needed
  914. Break a link/formula but keep the data?
  915. VLOOKUP function in Excel 97
  916. If contains specific alpha
  917. adding total business....how to?
  918. Merge Pages for printing
  919. Dynamic Worksheet Names
  920. Can VLOOKUP return multiple answers based on several identical lo.
  921. Calculation
  922. Converting a date in Excel 2002 to a Year/Quarter format
  923. conditional Summing
  924. 2 Criteria Counting
  925. Finding last entry in column
  926. how to change the h:mm format to number?
  927. How do I multipy a range of cells by a common number?
  928. How do I use the Match and Index functions to look up a value tha.
  929. Trying to build a formula
  930. Indirect another wookbook
  931. Formulas (If linked data is not null, then insert "Complete" in ce
  932. Bolding with formulas and "if/thens"
  933. how to use lookup a value by date for criteria in Excel sheet
  934. Macro "1 tall/1 wide" not working properly
  935. COUNTIF BOLD
  936. Accrued Vacation
  937. How do I copy a template in Excel?
  938. how do I name a worksheet after a cell
  939. how to hide rows in a protected sheet
  940. hide #VALUE!
  941. How to lookup data in a row and column
  942. Move column values w/o formula
  943. VBAProject
  944. Parsing words in excel cells
  945. excel worksheet
  946. lookup nonzerovalues
  947. nonzero value
  948. find first nonzero value in column
  949. find first nonzero value in column
  950. Notification to Netscape 7.1
  951. find first nonzero value in column
  952. "if" statements
  953. How can I change the colour of cells using an IF function?
  954. How to display zero in numbers?
  955. How do I autofill combo boxes with their destination cell?
  956. ZeroInterp function
  957. lowercase to uppercase
  958. Help
  959. Insert worksheet
  960. Statistical functions
  961. Find a word and then take certain action, else
  962. I want cell entry to be identical on another sheet
  963. long formula
  964. Link - deactivate being sent to source when click on linked cell?
  965. How do you get excel to spell out the amount (ie $5.55 = five dol.
  966. Why is the subtotal function in excel 2003 very slow compared to .
  967. sumproduct formula
  968. RATE returns the #NUM! error value
  969. formula too long, not sure how to shorten
  970. Sumproduct formula
  971. sum next two non-empty cells in a range
  972. Adding hours and minutes
  973. Convert multiple columns to rows
  974. cell formating based on value
  975. Is it an If statement?
  976. Formula not working
  977. header or footer
  978. Date
  979. how do I do a formuls in excel such as (if a1=somthing then b1=a .
  980. Formula help
  981. Relate from one worksheet to another
  982. Spreadsheet to do annual investment gain$, % gain, for list
  983. In MS Excel, after you input an USD amount, an option for automat.
  984. sum
  985. 1st, 2nd, 3rd Place etc.....
  986. Application.WorksheetFunction.Match problem
  987. longet Win streak
  988. why do numbers not add correctly in excel
  989. Range names and their associated addresses
  990. Changing a cell
  991. Wildcard Not Working in IF statement
  992. Relative worksheet reference in 3-D formulas?
  993. How do I reference the last 3 cells in a row as cells are added
  994. Time - converting HH:MM:SS to Minutes
  995. How to use TRIM function
  996. How to create a lookup table with an added varable?
  997. Open Access Database under and Excel window using a Macro
  998. Using Validation List from Another Workbook with Dependent Data
  999. How do I format email addresses as Text only?
  1000. Change cell according to date