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. Push/write data into an unopened file
  2. calculate totals of 5 sheets on to 6th sheet.
  3. Sort Data by Frequency
  4. insert rows
  5. How do I set up IRR and NPV functions in Excel?
  6. How can I make a timesheet to figure my hours and payrate?
  7. How to sum a column of hours & minutes in format TEXT(C5-B5,"h:mm"
  8. hOW DO I GET THE XCELL FUNCTION CUMPRINC TO WORK?
  9. designing and saving predefined pivot table formats?
  10. filter and keep same information.
  11. Links Problem
  12. Can you password an Excel worksheet, if so how?
  13. find previous row for an item
  14. How do I sort sheets in an excell spreadsheet?
  15. Autofill
  16. How do I get an IF statement to pull a date range??
  17. How do you get Info to show on Every Page when Printing
  18. calculating SUM with two conditions
  19. Explain these please
  20. need if-then formula-If a number is > /< something, then place a .
  21. Formula Template
  22. statistical functions
  23. LOOKUP or VLOOKUP
  24. YTD Budget Sum if Actual Month has activities
  25. Macros in Excel
  26. moving text
  27. In Excel, can I shade entire rows based on the value of a single .
  28. Mod-10 Check Digit
  29. Re: dsum with date criteria
  30. Embedded Excel Spreadsheet in MS Word Corrupted
  31. Remember a previous cell's value
  32. sum calculation
  33. Question about sorting in protected worksheet
  34. Tab Color - Excel 97
  35. Combo box question
  36. how can I get the last value entered into an excel column to disp.
  37. Min Formulas in #VALUE! Cells
  38. Formula Trouble
  39. IF function... not equal to
  40. IF function... not equal to
  41. IF function... not equal to
  42. IF function... not equal to
  43. Excel: How do I type a letter in a column and make a check mark a.
  44. ACCRINT formula yields incorrect result
  45. ACCRINT formula gives incorrect result
  46. Separate last word in cell with more than 2 words?
  47. How do I use conditional formatting to change subtotals row format
  48. how do i get a list of different formulas
  49. (if or) function
  50. Hyprtlink to protected worksheet
  51. How to detect if sheet is hidden?
  52. Excel n'actualise pas le calcul des fonctions quand je modifie le.
  53. Exporting Data
  54. How do I get a date changed automatically
  55. Help!! Formulas
  56. Times in Excel 2000
  57. If function
  58. RE: Embedding a file into an Excel spreadsheet?
  59. moving last row
  60. Matching Cells/columns
  61. Pick certain rows from database to use statistical functions on th
  62. Month always displays as Jan
  63. Sort Worksheets
  64. Can I fill colour in a excel cell from a return from an "IF" test.
  65. How Can I track changes in a Work Sheet?
  66. VLOOKUP
  67. how do you get (end down) to work in a macro?
  68. formula for calculating 401k if over or equal to 1 yr of service .
  69. Standard sumif formula not recognised
  70. Concatenate and then limit # of characters
  71. how to convert 357646 seconds into hh:mm:ss format?
  72. Excel formulas
  73. CORREL versus r-squared
  74. Numeric cell but shows as string?
  75. Weird Problem
  76. Possible? formula in one cell can fill another cell
  77. INDIRECT, OFFSET et. al.
  78. Linking workbooks
  79. Move rows to columns
  80. If is blank= conditional formating
  81. Rounding criteria within a nested vlookup and hlookup
  82. Can i find Spearman's correlation number with excel?
  83. Most repeated number
  84. SORT MIXED DATA
  85. Formula to figure credit card payments
  86. How do I remove repeating line in Excell - Top line on each page..
  87. There is no freeze/unfreeze panes option in the windows menu
  88. time card excel sheet
  89. LookUP Function Help!
  90. Find a non-blank cell and bring back text a in same row
  91. Cell Frequency
  92. can you place an alarm or tickler mechanism within excel based on.
  93. can you place an alarm or tickler mechanism within excel based on.
  94. IRR # NUM
  95. Time Card
  96. Referencing a worksheet name
  97. Micro that checks if file exists
  98. Excel should remember sort criteria
  99. Consolidate data from several worksheets via pivot table
  100. RTD Links, how to start and stop them
  101. Converting EST to PST
  102. greater than replace numbers
  103. Excel only calculates the confidence interval for a population .
  104. Excel only calculates the confidence interval for a population .
  105. using treater than and replacing numbers
  106. Consolidate data from several worksheets via pivottable
  107. RE: attendance sheet to add time but not.....
  108. Can I set up the formula to update automatically?
  109. complex count question
  110. PLEASE PLEASE HELP
  111. how do I lock column and row names on spreadsheet
  112. Help needed with IF function
  113. Is there a formula for conditional concatenating?
  114. CAGR
  115. Vlookup
  116. Excel financial function: PMT
  117. blank cells showing up as a month 1
  118. I want tool which finds duplicate date in excel 2003
  119. VLOOKUP ISSUE - Take II
  120. Another Friday Question
  121. IF ISNA HELP, please..I cant add #N/A but 0 is another story
  122. Set a formula to always select the last value present in a colum
  123. My scaling is set to print 1x1 pages. But it prints 1000's of page
  124. CF+ in X2000 and lost copy/past ability also ? about adding ranges
  125. How do you create a random number generator in Excel?
  126. Tax- offsetting losses against profits
  127. Conditional Format using value from another sheet
  128. Excel: Can I use Fill_Color Attribs to count elements?
  129. Vlookup returning #N/A
  130. Excel COM Add-in
  131. How can I look up data in a different workbook in an excel spread.
  132. need help with excel
  133. make my spreadsheet at 10% to all cells
  134. Excel: Be able to mark specifc items in the find/replace mode & a.
  135. make my spreadsheet at 10% to all cells
  136. Counting Formatting
  137. Hey can someone help me!
  138. value to a range
  139. Trouble with skipping rows
  140. pivot dropdown list
  141. Ho do I reveal the hidden format codes?
  142. Wildcards with SumProduct
  143. Deleting content
  144. How do I create a command button to jump from sheet to sheet in a.
  145. Sort not available on spreadsheet
  146. search a row to find the column
  147. how do I delete existing Excel headers/footers?
  148. If statement / Vlookup / Lookup
  149. Ignoring Lines with Errors in Pivot Tables
  150. Finding Percentages
  151. Conditional Formating - not in table
  152. Pivot tables share source data "after the fact"
  153. Start/run a macro from wherever the cursor is??? HELP!
  154. VLOOKUP ISSUE
  155. My formula will not show the result, only the formula.
  156. How do I reference every "n" cell in a column in Excel?
  157. How can I compare a number against a list of numbers
  158. How do I express a ratio (1:4 meaning 1 adult to every 4 children.
  159. Excel column/row headers
  160. linking worksheets
  161. Custom Function not being auto calculated when cells change..help?
  162. Return only if same
  163. changing a cell from date to a number
  164. Nested If statement
  165. Page Breaks
  166. merging lines
  167. Need help
  168. Font Size for Forms ComboBox in Excel
  169. Find function in a macro
  170. How do i use subtotals to display two different things within eac.
  171. Display link_location instead of friendly name
  172. VBA Password Hack
  173. Excel and Unix Question
  174. Excel problem
  175. Excedl Password
  176. how do I isolate only one row in the criteria for the dsum functi.
  177. How to protect option button?
  178. Can I make a formula such as "If c4 value > 1, then (shade pink)"
  179. Cannot insert a row in Excel spreadsheet
  180. No Subject
  181. Protect Cell Formatting
  182. Need to be able to open pdf file from Excel
  183. can't find map button in Excel in Office Standard Edition 2003
  184. WRAP a text line over several columns without merging cells
  185. WRAP a text line over several columns without merging cells
  186. How can I create an IF statement in Excel that uses the word "con.
  187. Function to Return another Worksheets Name
  188. turn off filter
  189. Better autonumbering formula?
  190. How do you sum a range of more than 30 cells. I get error each time I try.
  191. Sum of Columns with Calendar Dates and Data
  192. Setting up "Year to Date" Calculations in a Pivot Table
  193. Need Help machin up numbers
  194. My entire Excel SS is locked-up. I cannot make any changes in any
  195. ages/date of birth
  196. slow sheet change on mac excel
  197. Match with 2 Lookup_Values used as search criteria.
  198. Match with 2 Lookup_Values used as search criteria.
  199. Match with 2 Lookup_Values used as search criteria.
  200. Copying conditional formatting...HELP PLEASE!!!!
  201. Automatic Recalc
  202. How can I get existing Excel workbooks to open in separate windows
  203. I need to return "" instead of 0
  204. Jason Morin B$1 to B1 NOT working...HELP!!!
  205. I have a data list of 7,000, what is the easiest way to check for
  206. Trying to add conditional formatting to every other cell...GOING .
  207. Is clicking on the tab with my mouse the only way to move from on.
  208. Dropdown menu
  209. Unix Time in Excel
  210. Timesheet help
  211. excel-custom format using inches symbol (")
  212. date function?
  213. Calculating Working Days
  214. Chi-Squared, Komogorov-Smirnov, Anderson-Darling tests
  215. how do I set up book keeping on office
  216. How do I navigate on a click between linked worksheets in Excel?
  217. VLOOKUP ???
  218. Drop time in date/time field
  219. Can't remember My Excel Password
  220. How can I display certain results in a color font
  221. Invested 1,000 1/30/02, 4006.34 5/2/02,350/mo since 11/22/02 Valu.
  222. resize object dosen't take??
  223. Spreadsheets Links
  224. Truncate scientific notation
  225. Excel - compare function
  226. Column lines
  227. Column lines
  228. How do I fill an Excel template from a file
  229. SUM/COUNT column(s) based on specific value present within the column
  230. number format
  231. Excel file on your web
  232. Locating a value in a range from a reference.
  233. Merged Cell Row Height
  234. DateLastModified
  235. Statistics (average of multiple divisions)
  236. filtering out blanks..
  237. Time Sheets
  238. macro in excel 2003
  239. How to set a formula to count the product appear how manytime
  240. if(b2=1,b3,0) is this correct
  241. Limit access to certain worksheets (tabs)
  242. How do I use COUNTIF in a SUBTOTAL function to differentiate the .
  243. Can the find/replace function be used for worksheet headers/footer
  244. Colors and printing
  245. Formula(ae) to mimic offsetinmg of losses against profits
  246. Linking Workbooks
  247. Found Mistake can't correct.
  248. i need to add consecutive months and keep the day the same for ea.
  249. LINEST bug with cubic polynomials in Excel 2003
  250. COUNTIF with two conditions
  251. Match Function
  252. help with excel (maybe macros)
  253. Microsoft Office 2003
  254. Day number of given date in a year
  255. How do I count a row of NON-duplicate entries in Excell?
  256. min of max....
  257. Validation dos not work
  258. Multicell Array Formula and List Question
  259. Excel needs to expand text concatenation capability
  260. how do i convert a row of data into a column in another excel wor.
  261. Why " data analysis plus " override " data analysis " once instal.
  262. SUM OR SUM NOT?
  263. Re: Constructing a Cell Reference
  264. Formula
  265. need help with ms excel (possib macros)
  266. help with excel (maybe macros)
  267. Re: excel formula/function woes
  268. Re: Help w/ selectively combining data
  269. Re: Average Founction HELP
  270. How 2 rotate information in a working shift pattern
  271. Formating Hours
  272. Create a function to return text if two logical functions are true
  273. grab max date from list
  274. concatenate number format issue
  275. Invalid Validation if cell "Delete"d
  276. Convert date to length of time in months from set date
  277. How would I do this?
  278. Or operator
  279. Hide a row based on one cell's condition
  280. cusip (number and text) in same cell- How do use in excel?
  281. Text box formatting
  282. Focus
  283. insert row within function
  284. Count with 2 conditions?
  285. customizable right click menus
  286. Need Way to Automatically Select Data
  287. Look up function--HELP!
  288. Pivot tables - inserting columns
  289. Link based on worksheet name?
  290. how do you get the mouse scroll bar unlocked?
  291. Displaying YTD totals as you populate monthly information
  292. Determining the number of specific days between two dates in Excel
  293. if then else
  294. Excel gridlines
  295. Problem with VLOOKUP and drop-down lists!
  296. REPLACE
  297. COUNTIF
  298. Convert HTML into an Excel
  299. Macros in Excel X for Mac
  300. Can someone help?
  301. formula ?
  302. how do I filter for 1 variable in multiple columns
  303. Text concantenated with a link to another spreadsheet field
  304. REVISED ?? - populate limited cells w/ set value
  305. Can I create multi-level passwords for the same workbook
  306. Creating Formulas for overtime
  307. Excel MS Office 2003
  308. write a formula
  309. Can you change the PMT function tio calculate off of 365 days?
  310. IF formulas--please help!!
  311. VLOOKUP question
  312. Adding a character to the beginning and end of txt in a cell
  313. Multiple IF THEN ELSE statment
  314. Missing Library
  315. How do I set up an Excel worksheet that compiles data from other .
  316. Formula designed to reimburse employees up to a certain amt?
  317. I would like to count # of occurences but have it be dynamic when.
  318. How do I set a formula in a cell to equal the total in another ce.
  319. how do i undo deletion of sheets
  320. Add fill colors: green & red & yellow on toolbar, instead clickin.
  321. IF function?
  322. populate a limited # of cells with a set value
  323. Make Change Case in Excel a format rather than formula
  324. excessive rows when scrolling down
  325. Can't view text boxes in Excel on screen
  326. Merge & Center
  327. Making files with excel
  328. Freezing one cell
  329. edit links
  330. excel
  331. How to change the tab order for a protected worksheet
  332. My Formulas aren't automatically re-calculating
  333. Woorksheet locked on active cell
  334. Trial and error formula's
  335. MSN MoneyCentral Stock Quotes support historical price look-ups
  336. how to unlock a workbook
  337. formula for a seating chart
  338. filter sum
  339. Excel Error when copying formulas
  340. Using Wildcards in Sheet selection
  341. Embedding a reference in a cell with normal text.
  342. Time Sheets
  343. Nesting more than nine IF statements in Excel
  344. EXCEL LINK CELL FORMULA
  345. COUNTA, COUNTIF?
  346. Pivot tables - Headings
  347. Time Sheets
  348. Adding dates
  349. How do i use vlookup to find more than 1 entry
  350. IF or VLOOKUP?
  351. How do I align cells in Excel onto one line?
  352. how do I build a drop-down list in Excel?
  353. Adding Times
  354. Expondist function...
  355. Implement CSE function through VBA with parameters
  356. reserved sheet name
  357. VLOOKUP
  358. Can you delete multiple worksheets with one command?
  359. Hi Guys. First Time Poster
  360. Merging Two Rows Into One
  361. Need formula help
  362. Excel workbook
  363. XL formula - total of row = total of column
  364. How to Link 2 Sheets with different formats
  365. why am I unable to save a Excel file on a network drive%3f
  366. Excel won't calculate my formulas correctly.
  367. Array formula that alphabetizes a list
  368. Formula referencing deleted row (move up automatically)
  369. How to paste INDIRECT function to range of cells?
  370. How to pull some info into different sheet?
  371. Importing text files to Excel with big numbers
  372. keep\update sum value
  373. Help with creating Formula again
  374. Find column letter containing specific data
  375. Find combinations of numbers to equal a value
  376. how to copy an excel sheet from one xls to another without links
  377. How do I copy and paste cells incrementally?
  378. How do I forecast future payments by analyzing past payments?
  379. In Excel, I want to have all telephone numbers display in the sam.
  380. If "true" run a Macro
  381. Use Share Feature in Excel
  382. Current Month
  383. populate infomation from one worksheet to another if one of the c.
  384. Linking text columns with text and data columns
  385. Formula too long
  386. How do I change the default margins for workbooks in Excel?
  387. Calendar Links in Excel
  388. How do i group worksheets inside a workbook into subgroups?
  389. subtraction with time format cells
  390. row addition
  391. Why is the information on preview screen differnt than on normal .
  392. Multiple reference for lookup in excel
  393. Equals function
  394. Time Sheets
  395. RE: Counting (sub)totals
  396. Advice Please
  397. I am look for a formula to calculate a childs age in Years, mouth.
  398. formula in cell not showing result
  399. Formula result not showing in cell
  400. Can a cell have a drop down list and can also be auto populated
  401. line graphs in excel
  402. vlookup question please
  403. Vlookup question please
  404. How to insert a picture in the Footer (not the Header) in Excel 20
  405. Creating an custom input box
  406. Return Value from a different worksheet
  407. Move to Access?
  408. Creating Purchase Order on Excel
  409. Calculation to determine days between two dates
  410. How can one cell be autopopulated by another cell and have a drop.
  411. alpha numberic cell
  412. Total Field Always Visible
  413. Excel countif based on size of numbers in one column in Access
  414. Finding Duplicate text strings with a single column
  415. Random Assignment of Numbers
  416. Checkbox formatting.. anyway to make the checks bold or standout m
  417. COUNTIF - 2 conditions
  418. Add alternate rows
  419. Round time to nearest quarter hr
  420. GetPivotData does not return total values
  421. IF Function
  422. Filtering assistance
  423. Data validation
  424. automating a sales quote spreadsheet
  425. On click, copy text into another cell - XL2K
  426. Formula Bar
  427. Run a Macro on Startup for Specific Spreadsheet
  428. How do I sum numbers from cells that contain text
  429. Adding a column based on greater than a date
  430. If or Lookup
  431. Invoice and Credit Notes
  432. Numbering
  433. Formula pocket excel
  434. Functions
  435. help with send mail through excell
  436. functions
  437. Return the latest date from a list of dates
  438. protection of your worksheet
  439. Macro to delete data in 'green' cells only
  440. IF function
  441. replace cell contents
  442. Array functions ARGHH!
  443. Convert TRUE/FALSE results to a number
  444. GETPIVOTDATA General
  445. Amend formula to include addition condition
  446. fill or truncate to a certain number of characters in a cell
  447. Reduce columns and rows count?
  448. Left, Mid, Right
  449. Multiple reference for lookup in excel
  450. HOW DO I CHANGE THE AUTOMATIC BORDER COLOR IN EXCEL?
  451. Function or Code
  452. unique identifier for invoices
  453. how to prevent worksheet scroll bar to be bigger than working are.
  454. Average the Last Five Cells in a Column
  455. Help - Automating a file.. Adding Users , Deleting users, Changing
  456. What is wrong with this =AVERAGE(IF formula?
  457. How to aggregate values in a database
  458. Transpose date macro
  459. LEFT, MID functions?
  460. In EXCEL,How do you control the access to SHEET2, based on a value
  461. NOW() Function help
  462. Lookup
  463. how do I write a vlookup function within an iserror function so t.
  464. Time Sheets
  465. Number of columns ?
  466. Protection of many sheets
  467. unmet challenge
  468. Fortnight
  469. rows and columns won't stay resized
  470. columns and rows on my worksheet will not stay resized
  471. need to force PT to use formated number
  472. Empty Book1 workbook
  473. SUM Total
  474. If function
  475. For Ron de Bruin Please
  476. Re: Time/DateSerial Numeric Value
  477. VLookup or Index Match ?
  478. Finding the last row entered
  479. How can I share a macro with other users in the network within a .
  480. Importing Microsoft Word File Names
  481. Flash on error in result and during entry of data in excel
  482. how do I search by more than one criteria in excel?
  483. pivot tables interface with queries
  484. how do I figure the difference between two times when one is in p.
  485. How do I automatically transfer data to a 2nd worksheet page?
  486. if...or....function
  487. change value by date range
  488. How do I use an average function, not counting cells containing a
  489. Returning colours from a function
  490. how do I add/subtract time when I'm going from PM to AM (ex. 11:4.
  491. Questions on combin and permut
  492. H - SumProduct
  493. is there a way to write this function?
  494. need help using the offset function differently
  495. Excel user defined functions.
  496. I want to pull out companies without an email address?
  497. How can I enter 8 digits in excel (eg 19710625) and get it to dis.
  498. Excel: How can I freeze some of a workbook
  499. Using the average function
  500. Hours and Minutes
  501. Not printing a single cell's value.
  502. using links to show data
  503. combine columns
  504. How do I integrate a variablebased formula in excel?
  505. I need to find the Average from Column A - but Reference Column B
  506. Back-testing trade data
  507. calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets)
  508. protection issue
  509. Sumproduct with offset?
  510. Numbers after decimal point excel to word mail merge
  511. How do I insert a heading into a column
  512. Creating League tables
  513. Hours and Minutes
  514. Moving average
  515. Hours and Minutes
  516. How do I make formula in Excel from other worksheet?
  517. Scheduling
  518. External link using calculated cell value
  519. Number formatting question
  520. How do I repeat rows on the bottom of each sheet in excel?
  521. RE: HELP!!!!!
  522. can excel find the last used line in a column and display it?
  523. Excel
  524. Row counter in formula
  525. fun
  526. Worksheet references another tab in formula
  527. Indexing an Array with VLOOKUP
  528. FORMATTING CELLS
  529. External Data Source updating on open, how to turn back on prompt.
  530. 2 Question: Coloumn width, Filename
  531. What does the ! stand for in formulas?
  532. FILTER ONE MULTIPLE SHEETS
  533. how to convert GETPIVOTDATA from excel 2000 to excel 2002...
  534. Percent increase
  535. how do i set an equation that uses a cubic root in excel?
  536. how do i set an equation that uses a cubic root in excel?
  537. How do you paste OLE into Autocad without being cropped?
  538. DOS Data in Excel Format with Date and Military Time in same cell
  539. If Statements
  540. RE: If Statements
  541. Linking between worksheets- then sorting data
  542. Date difference taking into account weekends.
  543. COUNTIF Function
  544. Unique sumproduct with criteria!
  545. split a single column into 2 separate columns
  546. counting cells (COUNTIF) based on two or more criteria
  547. i cannot open excel file error Cannot access read-only document me
  548. if function, multiple characters from right
  549. calculate date differences in years and months
  550. VLOOKUP function
  551. eliminate data entered to a worksheet that copies to another work.
  552. help with excell to outlook for mail merge
  553. Transpose-relative cell references would be useful.
  554. Data Validation using a Calendar
  555. Suggestions for creating Issues Log using Excel?
  556. Excel - Addition Running
  557. How to add in an array formula if iisna index match
  558. Formula for calculating interest payments?
  559. Sum function when pasting
  560. how do I delete all rows that match a condition?
  561. hide a button
  562. Text formula
  563. SUM Function
  564. =SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF
  565. host hospedagem profissional por 2,99 ao mês
  566. Hours and Minutes
  567. macros errors
  568. ComboBox data
  569. Sum Conditional Items by date across workbooks
  570. Checkbox
  571. Unlock a spinner or scrollbar on a protected sheet
  572. Screen Updating
  573. brainteaser?
  574. Strange Format changes
  575. Check boxes
  576. Excel Fails when add-in is selected
  577. HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK?
  578. Values won't display after altering a formula.
  579. Formula for Kilometers to time Please
  580. Open two worksheets at the same time
  581. Standard Balance Sheet format in Microsoft Office Excel 2003(2)
  582. EXCEL FORMULAS
  583. how do i use > or = to in a formual for excel
  584. how do i use > or = to in a formual for excel
  585. Index and Match
  586. Quick date calculation functions
  587. Look for change next blank cell in Range
  588. Using functions to calculate multiple scores according to their level of difficulty
  589. Worksheet Changes and applying code
  590. mail
  591. How do I change a column of cells to all capital letters?
  592. Extracting Surname from within a text string
  593. Moving total
  594. Excel countif function
  595. Excell 2003 for Students & Teachers
  596. Display char 252
  597. Changing shortcut keys on macros
  598. auto protection of cells
  599. How do I add a command button on a worksheet to "paste" from the .
  600. Re: Between conversion
  601. How do I add a command button on a worksheet to "paste" from the .
  602. How do you add an Excel spread sheet to a Microsoft Word report?
  603. Userform - Printing
  604. Between calculations
  605. Multiple Functions
  606. Calculatng bowling averages
  607. Calculating % in a pivot table
  608. leading 0
  609. Decision Tree Add-In?
  610. Conditional Formating on calculated data in a pivot table
  611. Highlight automatically anything that is other than required
  612. Multiple functions in one cell
  613. Tab Stop across Columns
  614. How to match two different cells text, if the text is not in the .
  615. fill color doesn't work
  616. Select format cells Custom but Saves As Specil Why.
  617. #NUM!
  618. In Microsoft Excel 2003, when I select a color for a cell it does.
  619. Function to sort days
  620. screen capture of page
  621. message "Too many different cell formats" problem
  622. Problems with Google
  623. How can I get EXCEL formulas to work in Works?
  624. 23:00 <> 23:00
  625. Calculating percentage
  626. Converting 'General' formatted cells to Text formatted cell using.
  627. I need a formula to add the 3 lowest numbers out of 5.
  628. Copying a spreadsheet with macros
  629. How do I get the date to automatically update
  630. How do I create formula to identify duplicate cells?
  631. Occurance of data in multiple columns
  632. Looooooooooooong links.
  633. Possible And If Question
  634. How do I color cells within a formula in excel?
  635. Analysis ToolPak
  636. Re: Transfer From one to another sheet
  637. strike out feature in excel
  638. Need More Help on Dates to Months
  639. I want to select the first blank cell in column A
  640. Help with a formula
  641. still having trouble with this....
  642. When sorting info in columns, can I make it insert blank line bet.
  643. numbers not adding up correctly in spreadsheet
  644. numbers not adding up correctly in spreadsheet
  645. #NAME What does it Mean?
  646. Multiple lookup value's
  647. Can vlookup or hlookup look to other worksheets within a workbook.
  648. Excel: Use a name with external workbook reference for data valida
  649. my link menu is unavailable... I have created links and now the l.
  650. writing the columns a number is listed in
  651. Function HELP!!!
  652. Employees across midnight (2200-0100) -repost (attn: Bob)
  653. Counting differences in numbers across columns
  654. MCONCAT Question
  655. ISNA and VLOOKUP
  656. How do I spell numbers as words for writing checks in Excel?
  657. Can I format my worksheet so that the cursor goes only to cells t.
  658. Counting the events
  659. how do I set up an entry so that 3 months or one year later Excel.
  660. How can I sum only amounts that are formated B O L D?
  661. Number of times a number is shown
  662. I can't get a worksheet to copy onto the workbook
  663. NPER - Retirement Example
  664. Concatenate a range
  665. Hyper link within same workbook
  666. Auto page numbering for several worksheets
  667. Function Help
  668. Does Excel support Time Zones?
  669. Print and Print Preview don't match screen
  670. Match Function arguments
  671. Show missing data as 0
  672. Vlookup with multiple conditions
  673. Running Total
  674. How do I convert text to columns when there is a carriage return?
  675. Merging data from an excel worksheet into an excel template
  676. Excel should allow cloaking of certain cells when copying cells b.
  677. How do I create a search engine for a class schedule in Excel?
  678. Average formulas
  679. Pivot Tables
  680. Help with Pivot Tables
  681. Trying to find a max value with criteria
  682. How do you add sound file to a cell in excel
  683. How do I get my formula to stop rounding up
  684. How to sort merged cells
  685. Can this be done???
  686. How to sort merged cells
  687. What formula would I use?
  688. What function would I create?
  689. putting a number equal to writing commands
  690. Trace ALL dependent cells in any worksheet anywhere in Excel
  691. Match and add
  692. Function WEEKNUM does not show correct result for 15.2.2005
  693. counting time slots
  694. How to convert numbers to figures
  695. workbook size and calculations
  696. Ctrl & ` Grave accent not working
  697. Moving selected data
  698. Copy workbook
  699. Macro
  700. business days between 2 date feilds
  701. Is there a way to implement more than 3 conditional formats
  702. Counting Dates
  703. In Excel, have time of day appear automatically.
  704. how to: circular reference
  705. how to: circular reference
  706. offset and indirect function
  707. offset and indirect function
  708. autonumber values
  709. concatenate cell
  710. Macro
  711. Update another worksheets
  712. Multiple IF factors
  713. how can i count a number that meets a criteria?
  714. Look up function
  715. If Statement Question
  716. Unmovable absolute reference
  717. How can I copy an .xls worksheet to another worksheet
  718. Can I assign a rank based on a cells' value
  719. mistakes in the Excel functions (help on line french version at le
  720. delete a macro button is grayed out.
  721. Re: Noncontigous Cells
  722. Seperate First and Last Name into different cells
  723. Sumif or Sumproduct
  724. average cells omitting nulls
  725. Compound Interest
  726. I need help to get formula to calculate royalties recouped with sa
  727. Sorting and filtering
  728. Excel and propogating data
  729. Group
  730. Cells with functions.
  731. Coloured cells based on formula
  732. Re-Sort Worksheet tabs
  733. Text Next Line
  734. Adding Cells
  735. Text and the #VALUE error
  736. Date CONCATENATE
  737. shared file
  738. Number of employees in the appropriate time column
  739. linking workbook data
  740. Time Clock
  741. SumIf/SumProduct Formula Help
  742. Sumproduct help
  743. need a formula
  744. How to calculate a person's age taking into account their birthda.
  745. Nesting Sumif function
  746. function
  747. How do I merge two spreadsheets so it removes the duplicates?
  748. Sum with letter
  749. Can't break a link, all links are removed
  750. Re; Grouping Data?
  751. Text Color Change
  752. RE: Get "Error 1327" message when trying to run setup.
  753. change a function in a workbook without changing every cell
  754. Making list with unique columns
  755. macro to browse for workbook, pick up data and looping
  756. Duplicating Cell Information
  757. how do i work out how many hrs have passed in a 24 hr clock, in ex
  758. statistics - data analysis tool
  759. 3 questions about automated c++ com add-in worksheet functions
  760. paste sequences of different lengths
  761. tab button
  762. how to link from column to row?
  763. Comparing contents of two spreadsheets and outputting results to a
  764. formula IF returning current date
  765. add only positive numbers and avg in a column
  766. REMOVE #N/A
  767. how to merge mutliple columns vertically
  768. Iterate though all open spreadsheets
  769. Distance between zip codes
  770. Multiply one cell by a factor and make that result round
  771. How do I set up a conditional format with more than three options.
  772. breakdown a DB4 export into an excel worksheet
  773. Add parenthesis to numbers in cell
  774. Suppressing Worksheet Name When Zooming Out
  775. Lookup Lookup Lookup
  776. How can I assign a range starting cell based on a variable locati.
  777. Vlookup #value
  778. Second option button disappears when I make another column
  779. Can excel have a button to input (stamp) the systems date and/or .
  780. Average
  781. Correlation matrix
  782. Pivot table
  783. format cell
  784. contents of cells do not print
  785. Has anyone experienced problems with Macros when upgrading to Off.
  786. rounding a formula's number
  787. Highlight row given certain conditions
  788. combining an if statement
  789. Re: Date Format Structure
  790. head count on rota
  791. counting based on criteria
  792. Font Attributes
  793. Formula Question
  794. INDIRECT Help
  795. How do I use Roundup in a logical test in excel
  796. Columns in excel
  797. EXCLUDE ADDRESSES IN A SERIES SUM
  798. Last day of week
  799. VLookUp Tables
  800. How to convert hours in days?
  801. Formula to convert/transpose columns to rows (and vice versa)
  802. How do I add a printable watermark to an excel document?
  803. Excel lookup and calculation
  804. In excel my bold command doesnt work?
  805. How do I set up a stock control template?
  806. Dave My New Macro
  807. substituting two text occurances in same cell.
  808. If formulae using formats
  809. Excel 2003 V's Excel 2000?
  810. Netting off to zero
  811. One file splitted into worksheets
  812. i want to add a number to a date and get the date as an answer eg.
  813. Minutes to Hours:minutes
  814. adapt macro
  815. Listbox Question
  816. how can I select two different values for a cell?
  817. Excel Formulas and formatting
  818. i need help with the "count" function
  819. Save sheet?
  820. rogue links appear in excel
  821. How do I set a formula that indicates a if a cell value changed?
  822. How do i sum vales of sales falling between certain time periods
  823. How do I reverse the linest coefficients?
  824. Macro Question?
  825. Problems with the VLOOKUP formula
  826. hiding all data in a sheet except desired
  827. can anyone help with times not coming across correctly in pivot t.
  828. can anyone help with times not coming across correctly in pivot t.
  829. Control cursor direction in highlighted group of cells/Page setup
  830. Count the number of dates in a range that are earlier than today.
  831. Listbox Question
  832. CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS
  833. Excel workbook fails to display when selecting from my documents.
  834. Frequency of occurence
  835. Return only one instance
  836. How do I return a calculation based on several ranges?
  837. How do I autocalculate a single number?
  838. ? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching???
  839. Capital Letters
  840. Excel should display tabs on multiple rows
  841. PMT 30/365 vs 30/360
  842. How do I find a column entry closest to a particular value
  843. how do I get lookup to work
  844. Return lowest quantity
  845. Bernie My New Macro
  846. Return answer if.....
  847. Count Rows with two criteria
  848. sorting numbers more than one decimal
  849. Counting Letters
  850. Lookup Type Question
  851. Trouble opening an Excel file that contains macros
  852. Highlight a row if a specific cell is specific numbers/words
  853. user defined function row number
  854. header footer
  855. Need to find the right-most cell value in a string of cells
  856. Subtotal seem slower in Excel 2003
  857. MSExcel--words in a cell separated by comma need to be moved into.
  858. viewing seperate data within worksheet
  859. sort dates by month and day not year
  860. conditional formating of group of columns and rows
  861. pivot table logical calculation
  862. Combining today +1 and weekday function
  863. web query for Excel
  864. How do I recover a file, with info, that I did'nt Save?
  865. How do I make the fill color of a cell on one sheet follow the co.
  866. How do you calc half day annual leave on a xls spread sheet using.
  867. Hide part of Pivot Table
  868. VLookup Function
  869. how can find out what my password is if i forgot it?
  870. Lookup Function Error
  871. how do I select unique dates from a database in Excel?
  872. Pivot tables - Fonts etc
  873. count duplicate (or, inversely, unique) entries, but based on a condition
  874. page colour
  875. Lookups vs Match
  876. How do I get excell to indicate when a number is out of a set ran.
  877. Date in an IF statement
  878. excel change default column sort to current selection
  879. multiple hyperlinks
  880. Allow user to be able to create a formula to add/subtract any hig.
  881. Counting Dates
  882. At my wit's end! Use DGET or VLOOKUP to select data????
  883. Kent Hansen
  884. charting...
  885. Update Links
  886. Countif
  887. Don't update excel links
  888. Can I create a formula to find a specific value within a group of.
  889. troubleshoot custom Excel Auto Filters when the column is a # or d
  890. How do I add another name to an existing table with formulas to w.
  891. Countif multiple worksheets
  892. Find and Replace - Quickest Option?
  893. show a set of diagonal values in a matrix as a set of consecutive.
  894. functions failed in excel 2003
  895. numbers to text function
  896. stock consignment tracker
  897. conditional formula - based on 2 separate criteria
  898. Compound Interest
  899. Convert hhhh:mm:ss to hh:mm:ss (macro ?)
  900. Forecasting a figure in Excel
  901. Re: Combination of functions for a conditional format and an array
  902. identify numbers which are listed in two columns.
  903. Can a formula operate between worksheets, ie collating info from .
  904. Duplicated Spreadsheet
  905. How do i get Excel 2003 to have a progression bar in the adjacent.
  906. Using COUNTIF with text
  907. how can i subtract time from two different date?
  908. insert a formatted row in excel [office for xp 2002]
  909. Counting Values that meet another cells criteria
  910. excell
  911. Matrix multiplication with empty cells
  912. Where can I get excel worksheets for students in college
  913. How do I move data from one cell and add to another?
  914. Hyperlink question
  915. Overtime Calculations
  916. linking worksheets
  917. #DIV/0 ERROR in AVERAGING
  918. Display message based on condition
  919. allocating between positive and negative amounts
  920. format census tract numbers
  921. Looking up a sheet name
  922. Add asterisk to excel cell
  923. Mod-10 Check Digit
  924. CHR( ) request
  925. How do I replace a negative number with zero
  926. Formula that will count between dates ranges
  927. Formula that will count between dates ranges
  928. cells not printing within border
  929. csv load 64K workaround
  930. countif & and
  931. How do I use the SUM IF function with two different criteria. S.
  932. Closing the VBA Editor using code
  933. Social Security Number format
  934. social security numbers
  935. refresh all cells in column
  936. Formula for Excel: C3-AC3, then C3-C25...how do I enter it?
  937. dividing a row
  938. Excel's automatic color
  939. How do I sort row data without row fill color moving as well?
  940. Excel should find all places a particular cell is referenced
  941. subtraction with dates
  942. Macro to delete certain data
  943. How can Excel do daily timesheet, -lunch time, & not use colon in.
  944. Inserting upward pointing green triangle
  945. Compare and Merge Wookbooks
  946. pivot table date field
  947. Using Excel for Accounts Payable - Comprehensive
  948. How do i delete a row in a excel worksheet that is protected
  949. IF function problem
  950. how do you change the sign of data as you bring it in?
  951. print if
  952. How do I prevent data truncation from access to excel using MS Qu.
  953. Removing Duplicate Data
  954. Cell Reference
  955. Re: Method of running thru these
  956. Sumproduct
  957. command buttons
  958. How to search and copy cell content to another sheet?
  959. Generate random numbers between two values and with a given mean
  960. Macro working in "This Workbook", but not while in "Personal.xls"
  961. &Text &Link 2 Dec places
  962. cannot group columns - get "cannot shift objects off sheet" help!
  963. cannot group columns - get "cannot shift objects off sheet" help!
  964. I cannot extend cells using Shift+arrow keys; I cannot Autosum
  965. Please how do do this in vba
  966. Lookup Function
  967. INDEX and format of cells
  968. Clear cell contents with a button
  969. Database Information
  970. Amortization
  971. Re-Naming cells
  972. How can I freeze formulas in Excel?
  973. Page Breaks
  974. Is there a limit to the number of rows that can be filtered
  975. FILL COLORS
  976. How do I please
  977. from sumproduct to a lookup please
  978. indirect worksheet function in excel
  979. Pivot table (Running Averages)
  980. inputing formula
  981. macro help
  982. Average form cells containing formulas?
  983. Counting Date Occurances
  984. validation list blanks
  985. i push the fx and stupid insert funtion box appears
  986. Returning a blank for validation list
  987. How can the "NOW()" function be used in text.
  988. Formatting a worksheet for data entry
  989. Noob help
  990. Help with SUMIF, INDEX, LOOKUP Please !!
  991. start a macro
  992. concatenate, force new line
  993. Consolidating multiple workbooks
  994. Help w/ SUMIF ; INDEX
  995. Creating list in Excel
  996. Can I make a cell in Excell flash or blink.
  997. How do you average if your data contains a 0?
  998. Displaying all combinations of a range of numbers
  999. How to remove all hyperlinks from a worksheet in Excel?
  1000. Office XP - Excel