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 round last number without a decimal point
  2. Font Help!!!! Urgent!!
  3. I NEED TO FIND TWO FORMULAS
  4. Checking if a cell entry is correct before adding it to another
  5. average based on weekday
  6. Results from a combo box into a formula
  7. DAverage Function help needed
  8. How do I use DAverage in Excel?
  9. How do I use DAverage in Excel?
  10. Is it possible to do this ...
  11. help with formula
  12. how to convert text to value
  13. After using a formula how can I filter out answers I don't want?
  14. Need help with a formula
  15. Dynamic formulas including worksheet references
  16. Open as read only Problem
  17. Pivottable across network
  18. Trim and Keep the Trimmed Data
  19. Open as read-only
  20. MAKING A CONTRACT FROM DATA FROM A WORKSHEET
  21. @SUM Total Changes
  22. formula for filtering and a defaulting date
  23. Wildcard search functions within Vlookup
  24. Formatting result of Index function
  25. Vlookup help
  26. VLookup to sum cell values
  27. Incorporating Numbers into a text string
  28. Dates in Excel
  29. Calculation of Selection Group using Arrays (or VBA?)
  30. Hidden column A
  31. program excel worksheet to automatically not print blank rows
  32. countif results
  33. patterns
  34. Mode-1
  35. To save and close
  36. 'IF' Statement for a Concaterate Formula
  37. 'IF' Statement for a Concaterate Formula
  38. Using INDIRECT to refer to different workbooks
  39. How do i auto create multiple files from 1 with multiple sheets
  40. Mirror Image
  41. Converting cell contents to a formula
  42. Truncating a columns worth of cells not just a single cell.
  43. I need Help!!!!!!
  44. Clearing all Active Cells
  45. Looking for an income anutiy template
  46. Ignore Non-Alphanumerics When Comparing Text
  47. conditional formatting or vba?
  48. How to use a variable for a range
  49. Help....please.....having problems in Excel with Functions
  50. sumproduct question
  51. Newbie question: Matching data/2 wkshts copying info over
  52. cursor goto a5 in Sheet1 but
  53. automatic numbering
  54. need to find a max count without knowing what I'm counting (list of names)
  55. Updating, Deleting and inserting rows over two Excel Sheets
  56. Trying to Create a Conditional Drop down list
  57. convert text to numeric vba add-in?
  58. Formatting / Time
  59. use central formula on many worksheets, central affect allsheets
  60. How do I create a formula
  61. Formula to lookup last number in colum
  62. How do you export MathType from Word into Excel and be able to so.
  63. Offset Function works in cell, not in named range
  64. Excel not always summing correctly
  65. AVGIF
  66. How do I take a column of dates and add six months?
  67. drawdown
  68. Sales Commission calculations
  69. Not sure which function and how to use it. Help
  70. anyone know a formula?
  71. Sorting & Filtering in Shared Workbook mixing up data
  72. Erro in Formula, Pleas Help?
  73. sumproduct producing #VALUE!
  74. Tell me what to enter to Export Excel address book to Microsoft O.
  75. DATA TABLES and multiple sheets
  76. Which function can be used to Read the number in a cell ?
  77. how to use a cell reference in a formula
  78. calculating the difference between 2 numbers
  79. how i open a file XLS extension[ exelspreadsheet file]
  80. Vlookup
  81. SUBTOTALIF function
  82. concatenate
  83. COUNTIF and automatic type conversion problem
  84. Filtering dates using a formula
  85. how can i secuire Sheet Same time Update the Pivot Table
  86. Using VBA to insert Columns
  87. Text
  88. Additional Conditions for Conditional Formatting
  89. Inserting Rows
  90. changing type style and colour within a worksheet function
  91. Macro to scroll to Cell A5 please
  92. IF Help
  93. Adding Cell Range with Text
  94. Matching unsorted lookup values
  95. Spinner macro for Pivot Tables.
  96. How do I show the VALUE in a linked cell?
  97. What function allows me to compare 20 repetting text.
  98. What function allows me to compare 20 repetting text.
  99. Extract last and next-to-last entries in a range
  100. Auto Filter + subtotal
  101. Wrap text ceases to function in Excel if cell exceeds 9 lines
  102. tab name
  103. Master invoice number
  104. Average last 6
  105. ISNA
  106. date counting
  107. continuous page numbering multiple sheets of a single workbook?
  108. Excel pointer problem
  109. Find values from cells in multiple sheets
  110. How do I change phone numbers from "xxxxxxxxxx" to "xxx-xxx-xxxx
  111. Can I hide a worksheet and set a passwd to unhide it?
  112. dynamic cell reference within a text string
  113. how to close print preview
  114. Rounding time to nearest Hour
  115. create a function for Discount if qty > 50 then take 5% off total
  116. Two arrays need highlight duplicate in one of the array
  117. Passing Excel NAMED Range to VBA
  118. worksheet email address to outlook xpress contact
  119. Find last nonblank in a column
  120. How to return a dollar value for a part number entered in a cell
  121. Find first positive value in row 3 and return date from row 1
  122. Arranging columns
  123. VLOOKUP Problem
  124. How can I complete a spreadsheet using macros?
  125. copy color
  126. Copy Text Only
  127. referring a worksheet
  128. MegaStat for Excel
  129. Excel sorting problems
  130. rounding in quarter increments
  131. Excel should allow more options for formatting cells
  132. Sum If on muliple conditions
  133. Vlookup text values
  134. Formula Help
  135. Count Intervals of Filtered TEXT values in Column and Return Count across a Row
  136. Advanced Lookups
  137. Need help with Combinations, told to come here
  138. cells will not accept decimals.will not allow any retype with deci
  139. how to copy just the number that a formula creates
  140. Using autocomplete
  141. format-row-autofit not working
  142. Function to write out numbers
  143. ISBLANK Formula Help Request
  144. VARIANCE PERCENT
  145. automatically copy data from one worksheet to another
  146. Random Number Generator
  147. Question regarding dynamic range setting
  148. coping a formulas to another cell.
  149. Question for use of offset and range
  150. Digit seperator
  151. multiple and round
  152. another simple problem...
  153. How do I hide a combo_box on a condition?
  154. Template for printing-orientation, header-footer setup
  155. How do I get data to automatically flow to another sheet? excel 20
  156. Let me see if I can explain this...
  157. Returning expected dates
  158. Conditional Formatting
  159. Copying chart to another sheet
  160. Changing case on mailing lists I receive in Excel 2003?
  161. How to Use Group and Outline function when locked sheet
  162. Conditional Formatting
  163. Create Windows Directories from column entries?
  164. Cell Reference, Multiple Sheets
  165. Calculate matching cells
  166. sharing a macro
  167. collecting cell data from every 33rd row
  168. worksheet sorting
  169. cells will not calculate
  170. RE: Excel Doctor
  171. Conditional Formating
  172. sumif function with a difference
  173. Retrieving non adjacent data from other workbooks?
  174. can I make worksheet name equal a cell
  175. having the same workbook in different file
  176. width of column is zero
  177. Indirect used in an array formula
  178. what is '
  179. COUNTIF Bug in Excel 2003
  180. Excel Doctor
  181. help with spaces in funtions
  182. product calculation in excel
  183. Match function...random search?
  184. Using Wildcard characters in sumproduct
  185. How to get reult in text
  186. Move a Column of 500 Email Addresses into BCC Field of an Email
  187. Store max value of changing cell
  188. reference #value error
  189. Random Numbers
  190. Can I HIDE cells with a conditional argument?
  191. large binary numbers
  192. calculating term of financial transaction
  193. Numbers
  194. Same row different Answer.
  195. Making Font Color Changes in IF Statements
  196. Custom Cell Format Will Not Save Correctly
  197. I need to use a number in one worksheet to match text in another
  198. Finding a character type within a cell
  199. reverse week count calculations
  200. Can't get an Excel spreadshe doc. to export into Oultook Contacts
  201. summing up contents on ceratin cells depending on selection criter
  202. excel
  203. DAYS360
  204. Suming up a Lookup
  205. Autoshapes and objects disappearing
  206. How to automatic calculation and macro execution between 3 workbooks?
  207. Using Search with either vlookup or match and index
  208. Printing data validation scenarios
  209. Sum error
  210. average annual return
  211. Get Past the 7 Nested IF limit
  212. How can I copy cell formats in functions?
  213. Using cell references as text in a formula
  214. Can taxes be totalled on separate sheet when using Excel invoices
  215. PDF file into EXCEL
  216. countif function
  217. How to solve y =f(x,y) using matrices?
  218. How can I count items in a filtered list?
  219. format cell based on results of vlookup function
  220. More sumproduct/table multiplication help
  221. Dates and times with PST,PDT
  222. Dynamic reference to workbook
  223. How do I break links in a workbook?
  224. Percentage Calculation
  225. I need to count while using multiple criteria
  226. How do I get a hyperlink (entire row) to data sort alphabetically
  227. find a sum from a list of numbers
  228. Shadow current field box as it moves?
  229. Can I lock a row so that it's always the last row on the page?
  230. I want to correct a #div/0! error but the IF function doesnt work
  231. Conditional Formatting
  232. How do I copy a reference formula onto multiple worksheets
  233. Date controlled function execution
  234. Question on Vlookup
  235. How do I apply a % +/- to a range of figures please
  236. sequential numbering for invoice
  237. Probabilities, random numbers and dice throws
  238. Drop down box
  239. Help with this formula!
  240. sumif help
  241. Lookup on different sheet
  242. Pls Help Me!
  243. list to table
  244. How repeat numbering for raffle tickets eg. 000001 - 000001
  245. Lookup across 2 or more columns to match a row
  246. SumIf
  247. problem with #value!/zero
  248. Desperate Help needed with a function.
  249. Calendar template on Excel
  250. Complicated sumproduct help reqd.
  251. consecutively number cells in a column range
  252. Some formulas need file refresh in same worksheet
  253. how do i shift from tab to tab using keyboard(same file)
  254. Conditional Formatting on Whole Numbers?
  255. How do I auto change text colour in excel to reflect the value ent
  256. Drop AM and PM from date
  257. Comparing Data
  258. How do I remove a date at the bottom of an excel sheet?
  259. Conditional Formating with Checkbox
  260. Filter/find/isolate one specific term?
  261. pivot table
  262. Search for specific words
  263. Determine which cells from a specific range equal a certain sum
  264. How can I show the total sum of items in a filtered column
  265. Excel Grouping
  266. Lookup??
  267. Combo Box
  268. Average Non-Continuous Cells Without Zero's
  269. I need help with an folmula for hunting / matching names and value
  270. Insert a new worksheet after subtotal
  271. Assigning Macros to Buttons in Excel
  272. Linking Entire Worksheets
  273. can macros change cell color daily, i.e. green to red everyday?
  274. I need help with an "If" Statement
  275. Comparing 2 worksheets
  276. pivot table sorting
  277. Re: hyperlink help
  278. Average Time
  279. using a file dsn in sql.request to connect to sql server
  280. adding values based on criteria
  281. Re-Calculation on a single worksheet
  282. VLookup
  283. Is there a help on the TABLE worksheet function in Excel?
  284. text and numbers same cell and formulas still work (like lotus)
  285. Simultaneously change values in multiple cells?
  286. vlookup more than one exact match
  287. Vlookup across multiple tabs
  288. How do I get rid of the #DIV/O in a cell?
  289. lookup specific character place
  290. Cell format
  291. Function help!
  292. Index Row and return data in a Single Column
  293. Combine several spreadsheets for an emailmerge (perhaps using Acce
  294. sort by SUMIF results
  295. how do I calculate the annual interest when I know the compound
  296. conditional formatting with formula
  297. If Then Lookups - If Someone helps me, Then I will be happier!!!!
  298. #div/0 Error
  299. Sum and Skip Negative Numbers
  300. Subtract Hours
  301. How do I LOOKUP text values
  302. Date Calculations
  303. Variable Input Range for Combo Box
  304. Compare cell value
  305. numerical value of a letter
  306. Setting All Worksheets To The Same Scroll Position
  307. Avoiding the dreaded #div/0 error
  308. Change case...help please
  309. enable commentaries when is protected
  310. Excell Formula
  311. Excel If then Else function in Worksheet
  312. LOOKUP funciion giving an error
  313. using Goal Seek inside a recorded macro
  314. MS Excel Data function missing
  315. Setting up some sort of cutting and pasting loop
  316. trying to import excel database into outlook need to name ranges
  317. Finding the minimum in a selected number of rows of the same colum
  318. refresh auto filter
  319. excel spreadsheet with e-mail notification when due date arrives
  320. Automatically Enter Data
  321. if else construct
  322. random numbering
  323. Copy sheet 1 data to sheet 2 cells.
  324. If Then, not using values, or not counting blanks
  325. Can I use excel to find y = f(x,z)?
  326. Moving one workbook page to a new workbook
  327. can I add a flashing message to a spreadsheet?
  328. vlookup fails on data from a pivot table
  329. Can I add a flashing message to a spreadsheet?
  330. Formula problem
  331. truncate
  332. how do i use spreadsheets wider than 256 columns?
  333. move data from multiple cells in one row to another
  334. Excel database
  335. EXCEL worksheet
  336. I've tried Sumproduct, SumIf, Vlookup and Hlookup.
  337. Conditional Formatting, date.
  338. formula problem - UK national curriculum levels
  339. Auto Update
  340. formula help - Is this possible?
  341. find-replace box should not float but be fixed line on tool bar
  342. Creating Text lists
  343. Subtotaling based on more than one group
  344. How do I check for existence of a worksheet?
  345. Excel Function To Access
  346. Is there a function for a 'year to date' sum
  347. Referencing cells containing tab names?
  348. Looking for a way for excel to count unknown repeating values?
  349. How to automatically capture a tab name in a cell?
  350. Cell Protection
  351. Algorithm Challenge
  352. Calculations on only a selection
  353. IF, THEN statement
  354. Return data from multiple cells
  355. How do I change the number format within the concantenate function
  356. Group values
  357. excel worksheet
  358. how to combine the multiple rows into one rows?
  359. If, Then Function
  360. Question on using time in Excel
  361. How do I ignore values while copying from hidden rows?
  362. VLookup for multiple values!!
  363. index & match with links for updating to other workbooks
  364. index match formula
  365. create a list from 2 sheets
  366. What formula I should use: =ROUNDDOWN(H45*0.18;2) or =TRUNK(H45*0.18,2) ??
  367. Help with sum up or down in cells
  368. how do I set up a pricing template in excel
  369. NETWORKDAYS
  370. comments in excel
  371. replace function
  372. How to copy the data in row to column?
  373. Formular Question
  374. excel paste special should allow text
  375. Create summary based on specifc value in a different sheet
  376. Conditional format with a formula
  377. Can I Find one word in a formula
  378. Listpro
  379. Multi-condition vlookup
  380. Data parsing question
  381. Count if 2 conditions are true
  382. Tab key movement Excel 2002
  383. Making mulitple IF statements.
  384. Cells with a value between two dates
  385. vlookup in a pivot table
  386. Show in Z the last entry from A thru N
  387. Excel: match two cells in one sheet to two cells in another and return a third cells value
  388. Problem in using Vlookup (1st time user)
  389. Why are cumulative interest payment calculations different?
  390. COUNTIF temporarily missed some cells
  391. cell links
  392. using VLOOKUP to compare 2 columns to find new information
  393. How to lock worksheet and still able to click on grouped rows
  394. Totalling formulas
  395. excel formula to convert lat/lon degrees to DDD MM SS.SS?
  396. Count if number between two numbers in Excel?
  397. Conditional Formatting
  398. percent change
  399. sort list of players by team from player list on separate sheet
  400. Consecutive Numbers down a column not to Exceed 49
  401. I need to merge lots of info, w/o copy paste?
  402. Indexing a row
  403. How can I convert Euro dates into U.S. Date; e.g. dd-mm to mm-dd?
  404. first value > 0
  405. Wildcards in functions
  406. lookup help
  407. IF and MIN functions
  408. calculate the number of days from date received
  409. AVERAGE problem
  410. Problem with compound IF statement
  411. Validate Cell contents in formlua
  412. Comparison
  413. Merge text list
  414. Printing
  415. LOOKUP
  416. Macro Question
  417. Ranking
  418. Complicated lookup function
  419. Combo Box View
  420. Microsoft Excel Spinner's
  421. Counting Duplicate Entries
  422. DOnt calculate leap year
  423. trouble filtering a list. Why isn't column filtering?
  424. text formulas
  425. Can I create a dropdown that will show a 2-month calendar?
  426. SumIF is not working
  427. Array Function
  428. How do I compare data between spreadsheets?
  429. Formulae
  430. macros
  431. Multiple text boxes selection
  432. Text from text box to cell
  433. Same Name refers to local ranges
  434. CURRENCY INDEX FOR EXCEL
  435. mixing text and formulae in same cell
  436. How do I change a cell's contents to it's formula's value?
  437. How do I sort dates stored as 1-Jun-05 in order of day & month
  438. .wb3 file convertion
  439. perform calculation only if current time is after 10 am
  440. datevalue
  441. To leave the cell Blank
  442. How do I please.
  443. quatro pro to excel
  444. Issue with sumproduct
  445. My print preview is only showing one page to be printed
  446. Why does the Sort function stop recognizing Header Rows?
  447. Merge files & sorting data
  448. Thank You both! n/m
  449. Data Validation
  450. match cell in array1 with all cells in array2
  451. Help keep incompetents in business
  452. HELP!!! On SumProduct
  453. copy numbers progressively
  454. count date ranges
  455. Why help?
  456. Rounding numbers to the nearest 5 or 0
  457. Timer function needs improvement
  458. Need Formula for Last Occurance
  459. Page Numbering Function?
  460. Using non defined names from another sheet
  461. automatic filling in cells in excel
  462. returning a count if two conditions are met
  463. How do I filter names using only the first letter?
  464. my formatting changes do nothing to the data
  465. Displayed contents of cell in target row if column criteria is met
  466. Answering a question in a cell
  467. Concatenating a cell address
  468. Using Excel macros from Vision objects
  469. Need formula for a fixed cell minus last entry on ongoing log
  470. This is Weird - Dead Simple Issue with Sum Function
  471. culmulative calculations
  472. Arithmetical Mode Value for Filtered cells in Multiple Non-Adjacent columns
  473. Comment
  474. why does my excell worksheet start with only a gray view, no data
  475. can i get excel to add variables
  476. Progressive Addition Formula
  477. PIVOT TABLE?
  478. Identify Numbers
  479. HEADER ?
  480. INPUTING TIME FORMAT
  481. Help with Formula for Text Entries
  482. Quarterly tax percentages
  483. summary of customers?
  484. recursive sums
  485. Vlookup With A Twist
  486. our cost to customers cost
  487. Workday Function Question
  488. how do i set up my main categorie row to repeat on other pages
  489. Sumproduct based on substring?
  490. conditional formating....
  491. Problems using a variable as a Table_Array in VLOOKUP
  492. Sorting
  493. In Excell how do I just type in an amount w/o it inserting a $
  494. Excel fields in a row instead of column...
  495. excel formulas with text
  496. Macro help???
  497. GO FROM ONE WORKSHEET TO ANOTHER WITHOUT CLICKING
  498. VLOOKUP problem
  499. IF A CELL HAS THE VALUE OF 0, I WANT IT TO GO CHECK THE NEXT ONE
  500. hh:mm - mm formated 2 round to .25, .50, .75 & 1
  501. Countif Function
  502. Daily water meter readings
  503. ASCII extended set is different in Excel, than MS's Website?
  504. How do I format 1 column of alphabetical listings into 3 columns?
  505. Stock Update
  506. Variable Column references
  507. creating an invoice for work
  508. SUM every other 14th cell
  509. How I need correct formula, that no t rounding?
  510. return zero from a blank cell
  511. Sorting Data from 2 sheets, one sheet which is already sorted
  512. sort 2 or more rows of cells linked to one row of data
  513. Changing the color of a list entry based on a tolerance
  514. If with a range
  515. Need Help with custom function!
  516. Show Dollars in Millions
  517. What cells in a array equal my value?
  518. Formula between two worksheets
  519. Finding min/max of adjacent data in a range of cells
  520. Using average in two condition arrays...
  521. Move between worksheets
  522. RE: Question regarding how to search a column and print a row(s)
  523. Need Subtotal Help
  524. How do I display the tab name in a formula
  525. Is there a way to transpose and invert the order of data in Excel.
  526. converting from lotus 123
  527. Count the occurance of a value x a value in another cell in excel
  528. What is the purpose or why would I use watch cell?
  529. Bonus Calculation problem
  530. How to calculate a pay-back period by the accumulated cash-flow automatically?
  531. adjacent data count from a binary column
  532. common entries between 2 columns
  533. Automatically transpose when pasting data in excel
  534. Bars in a chart???????
  535. Dates
  536. Choose data from a particular column based on a specific value
  537. How to reference to the previous worksheet regardless of title?
  538. Getting timestamp from a file in Excel
  539. format method
  540. Searching TEXT in formulae, rather than results of formulae
  541. save as webpage?
  542. time subtraction problem
  543. Renaming multiple sheets
  544. A SIMPLER FORMULA TO GET A REFERENCE OF WHICH COLUMN IS POPULATED
  545. How to convert the dates from the YY:DD forma to MM/dd/YYYY format
  546. Is there a formula for IF a cell CONTAINS certain text...
  547. Sum Multiple Criteria or DcountA
  548. Finding the first blank or zero value
  549. Value 0
  550. Re: Question regarding how to search a column and print a row(s)
  551. I have forgotten my password and have no excess
  552. Function to calculate the number of years, months and days between
  553. Incrementing a worksheet number in a formula
  554. Incrementing a worksheet number in a formula
  555. Sumproduct
  556. our cost to customers cost
  557. Calculating the sum with multiple conditions
  558. lookup function 1
  559. Turn off cursor from automatically highlighting cells in Excel?
  560. To have the cell blank please
  561. get total hours from 2 dates
  562. How can I force a worsheet to recall functions.
  563. conditional autofill???please?
  564. Am I asking to much from vb codes?
  565. vlookup returning sum
  566. Create a button in excel that can open an outlook appointment?
  567. Date conversion
  568. To show blank please
  569. vlook up
  570. Recording simple macro
  571. Set a cell to have a pop-up calendar for date selection in Excel?
  572. ???is there a way to keep one row in view while scrolling down???
  573. How do I open multiple hidden worksheets all at once?
  574. Limit of # of tabs
  575. How do you...
  576. How do I Provide a specific result given multiple criteria?
  577. The # in my vector is absent from my array. Can I make it 0?
  578. Is there a way to average if in excel when looking at a range of d
  579. Is there a function that will return the page number?
  580. Can data from one ws transfer to another IF cell has text?
  581. If statement
  582. Sum func. is adding cells not in specified range
  583. Conditional Filtering
  584. I need to put text after the value of a referenced cell (=B4'MS')
  585. Calculate sum of numbers with conditions
  586. Using the autofill function but increment by certain number in function
  587. Using a Formula in a Conditional Statement?
  588. How to calculate values in multiple values with multi conditions
  589. IF function
  590. how do i keep a time/date register of every change occurred in a c
  591. compute values in a range
  592. functions 33242
  593. If a cell is blank do no let a user print or save?
  594. "." & a "+" added 2 a table reformatd as text in Word???
  595. Excel 2003, Insert Function, create full name & descriptions
  596. Date X Data
  597. mapping with excel
  598. Filter by Color
  599. Purge functions leaving only calculated data?
  600. Validation Based on a Date
  601. reduce a balance from severel cells
  602. Return first 'n' characters
  603. How can I capitalize multiple cells that were entered in lowercase
  604. Is it possible to have multiple splits in one worksheet?
  605. future dates
  606. How to Add a Calculation to a Pivot Table ?
  607. index / match /lookup ? help
  608. VLOOKUP blows up file size
  609. lookup value froma filtered list
  610. Column of check boxes
  611. funcation
  612. Sum function for non-continuous range
  613. Vlookup for 2 items
  614. Match and Index
  615. Can solver do this?
  616. two worksheet linking
  617. apply autofilter to more than one table
  618. How to fix a link in excel
  619. Transpose Macro
  620. Function help please
  621. Levels in Subtotals
  622. Conditional Sum by Row
  623. How to filter 7 columns in a 20 column spreadsheet?
  624. Time functions, how do I work out number of hours
  625. DB (depreciation) function Help question
  626. interest only
  627. How do I create ccolumn headings diagonally?
  628. vlookup returning a n/a result
  629. Filtering by criteria in two columns
  630. Help with Formula
  631. Display latest date in a column
  632. Desktop file sharing
  633. Running a Macro automatically from Excel
  634. Converting Time Data
  635. formula
  636. Linking and formatting multiple worksheets
  637. Arithmetical Mode of Criteria in Multiple Non-Adjacent columns
  638. I Need to Count Number of Entries Based on Two Criteria
  639. GETPIVOTDATA -- How do I shut it OFF!
  640. Count Not Appearing when using AutoFilter?
  641. MAX, MIN, MEAN, AVERAGE, MODE for multiple groups...how?
  642. adding values with text
  643. Concatenating Functions
  644. Second appeal for help
  645. calculating number of days (e.g., Mondays) between two dates
  646. Array Formula w/ Multiple SumIf Criteria
  647. How do I change dates in student attendance?
  648. if a1 value changed then date in b1
  649. Interest only payment
  650. Re: Finding number of particular days in a period
  651. How do I turn off automatic date function in XL?
  652. Match Formula
  653. highlighting a change in value
  654. calculation to exclude weekends
  655. comparing lists
  656. Reference
  657. Printout doesn't match screen view (columns wrap differently).
  658. How do I multiply a whole column by a number?
  659. row and cell reference
  660. Validation 'Jump To'
  661. Duplication of function
  662. VlookUp that does not return #N/A
  663. How can I use a time difference in a subsequent formula in Excel?
  664. Removing a page break from excel
  665. Plotting daily changes
  666. How can you jump to a selection in a validation drop-down?
  667. More Multiple conditions
  668. text manipulation
  669. Worksheet tabs viewing there of
  670. Change row selection
  671. How do I delete all named ranges in a sheet at one time?
  672. Figure out the hours worked for the week
  673. Date function
  674. Absolute Reference
  675. How do I limit what text is displayed?
  676. How do I remove all text in a cell after a specific character?
  677. Count names
  678. Using autofilter and excel form format
  679. a cell reference in a 3d reference
  680. Time between two dates (Excluding Non-bus Hrs)
  681. cell validation even for values pasted into cells
  682. Multiple conditions
  683. Modify a Formula to Display Blank
  684. details of month
  685. How do I make a calculation?
  686. consolidating workbooks
  687. Date range criteria and Pivot tables (again!)
  688. Help! Formula to find the address of particular value in sheet
  689. how do i convert from rands to zambian currency
  690. How many different customers in a list?
  691. Counting the number of rows
  692. How do I test for a prime number?
  693. Start spreadsheet with WinXP start
  694. Sorting into quintiles
  695. how do I test for Integer?
  696. Calculate the difference between two times
  697. Calculating a sum of various lenght
  698. How do I sort addresses in excel?
  699. Setting formula to give info from rows with certain criteria
  700. transfering numbers into teams
  701. Cse ?
  702. DSUM with External Database
  703. unrestricting drop down lists
  704. Validating email address formatting
  705. Is this POSSIBLE IN EXCEL ?
  706. Pivot -- want to use Max and Sum in same table
  707. Offsetting the Rows of a VLookup Result
  708. How can I add a percentage sign to a cell with data validation
  709. Adding times
  710. 30 Arugments limit- SUM, AVERAGE, etc.
  711. perform caculations on displayed value in Excel 2000
  712. referencing another worksheet
  713. freeze panes
  714. How do I show dates older than present date?
  715. F4 key does not toggle relative/absolute cell references.
  716. Perform the square root function in excel.
  717. Explain return of #N/A
  718. To Biff: Using Match with multiple criteria
  719. Rounding currency.
  720. searching for a space " "
  721. Need Function for Double If
  722. Help: I need a function for finding next cell vertically with value
  723. finding data
  724. EXCEL
  725. Calculating percentages in pivot tables on subtotals
  726. toolbar for "standard tickmarks"
  727. Using functions to paste from one worksheet into another
  728. label caption equal excel value
  729. can I put a note in an excel formula
  730. Lookup or Match ?
  731. Sum & copy color format...?
  732. Substitute for Pivot tables?
  733. Excel Rounding Up to Nearest Multiple
  734. I have had difficulty in creating user defined functions in Excel
  735. Excel will not add cells automatically together when selected?
  736. can it be copied instead of referenced
  737. Pivot Tables
  738. Negative Working Hours
  739. can anyone help with repeating the same action on different ranges?
  740. Copy VLookup Values
  741. Generating a table
  742. Sum product help needed with an extra variable please and thankyou
  743. In excel the sum is not calculating
  744. Count how many "name" in a column
  745. future dates
  746. Import Format Using Vlookup
  747. Can Vlookup check a cell to the left?
  748. AUTOMATIC SORTING PROBLEMS
  749. Filling excel entire row/column instead of single cell from an array
  750. autocorrelation function (ACF)
  751. dynamic cell references
  752. countif function
  753. formula to populate while skipping blank fields
  754. can't figure it
  755. Can excel give value in words of number entered in another cell?
  756. how to convert Lotus 123 to Excel directly and can running normal
  757. In a protected worksheet allow users to delete rows
  758. Function for more than 1 criteria
  759. How do i change the date 6302000 to 6/30/2000 ?
  760. I am trying to figure out how to add per 1000
  761. how to get the number of days between two date formatted fields in vba for excel?
  762. Macro's
  763. sort dates by day then month, not by year.
  764. SaveNClose
  765. Leading Zeros and decimal points
  766. how do i make it so that when a sheat is selected either via link or tab, that xlLastCell is selected. the last on the sheet.
  767. Sum Count of Single Criteria in Multiple Non-Adjacent columns
  768. PMT function
  769. renaming copied worksheets deleting .xls]
  770. Same data box on two pages?
  771. Using Match with multiple criteria
  772. is it possible to select and change the values of cells in a minimized excel spread sheet from vba?
  773. Sub SaveNClose()
  774. Duplicate P/N and sums
  775. average
  776. How do I view a JPEG file from data selected in Excel
  777. Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA
  778. Compare 2 columns to see differences
  779. countif
  780. Blank cells
  781. autofill next sheet with next set of dates
  782. how do i solve 'file not found' error when linking notebooks?
  783. how can i assign i set of numbers (1-16) without repeating them?
  784. Function for Rounding of Number
  785. Auto Filter not showing all data
  786. change data source for many queries at once?
  787. Enabling sub menu items via vba
  788. Counting months
  789. Ingoring text in a formula
  790. Text To Columns Function
  791. Can I find and replace "white space" in a cell in Excel?
  792. What function(s) to use?
  793. difficult calculation
  794. convert interval to various separate date , time, hr, minutes
  795. How can I use the random function?
  796. Using VLookup and typing in values to be "looked up"
  797. Nested Formula
  798. How to combine text from multiple cells?
  799. How to get number of rows which match criteria
  800. can excel convert number into words (like 10 to ten)?
  801. Problems with .Refresh BackgroundQuery:=False
  802. How do I produce a centroid fit to excel data?
  803. The formula Watch Window in Excel should allow more than one row
  804. Find the combination of numbers that when added equal a reqired total??
  805. Using sheet name in formula
  806. Formula is missing
  807. print area poser
  808. excel printing
  809. Adding text in formulas
  810. Un - Concatenate?
  811. histogram for time values
  812. Help with a Function
  813. Can I set more than three criteria for conditional formatting?
  814. link from one workbook to another workbook using a dropdown?
  815. Part Number Lookup
  816. Need formula that reads value and then displays value from same row, different column
  817. random number without repeating?
  818. counting diffeneces in range
  819. Confusion on adding percentage of cost to that cost.
  820. CMD Button Help!!!!
  821. FORMULAS
  822. How Do I reverse axis in a spreadsheet
  823. formulas in pivot table
  824. printing problem
  825. How to calculate and then show up as a percent?
  826. solving for all possible combinations of a set of numbers
  827. header row
  828. Function to Count Number of Consecutive Rows with a Specific Criteria?
  829. Do I need a formula or Macro?
  830. Help with drop down menu
  831. USING INDEX AND RECIEVING #VALUE ERROR MESSAGE
  832. how can i design a 2 page a day diary / appointment book
  833. compare time in IF statement
  834. protection and inserting rows
  835. VLOOKUP from another sheet, VBA
  836. List Query
  837. IF previous cell value is < 0,(neg)then add it to this cell value
  838. Help please simple drop and drag I can't make work
  839. total subtotal cells
  840. sum function for minutes and seconds in Excel
  841. sorting whole numbers
  842. totaling figures in colum
  843. how to overwrite a value without loosing the formula?
  844. Find then If then Replace
  845. Find then If then Replace
  846. INDIRECT Function impact on Copy Worksheet
  847. How to create formula to convert?
  848. calling a new function Excel gives me #NAME?
  849. sort ascending tab is not active. Why?
  850. EXCEL - Please add a date format - yyyy mmm dd (mmm being letters
  851. Help formating Cells
  852. Problem with an "if" relating to a range
  853. How to add the 10 smallest numbers out of a range of 20 numbers.
  854. a problem with if invovling a range of cells
  855. sumif depending on 2 cells matching
  856. Paste Special
  857. Excel bug?
  858. Comes up #n/a, what do I do?
  859. Help with adding certain cells using an IF function
  860. linking workbooks
  861. Auto sum does not add inserted figures in colum
  862. Help with values
  863. index match with blank entries
  864. Linking worksheet event codes
  865. how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit
  866. formatting cells
  867. retrieve text from merged cells
  868. Cell Refences
  869. why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?
  870. What does ScreenUpdating = False do?
  871. Auto date/time insert when data entered into an adjacent cell
  872. Trim cell contents
  873. Sumif with criteria list
  874. Create a function wher last digit is always set
  875. California rollover Paid Time Off tracking - any templates availa.
  876. How do I compare 2 sets of data and highlight differences?
  877. What Excel Formula = finding dup records and removing them?
  878. mailto addresses
  879. What is the correct function to use, please?
  880. How do I reverse the order (sequence) of a column of data in Excel
  881. create list of unique values from a column with repeated values?
  882. VLOOKUP and ISNA functions
  883. SumProduct or CountIf
  884. Repositioning the tabs
  885. Imported Date & Time format with calcs. managed in excel from imrp
  886. Not filtering entire Database
  887. How do I use a cell value as the filename in an external link?
  888. Excel
  889. Comments Not Always Printing At End
  890. Can I format to always AutoFilter specific cells
  891. Function Bug ?
  892. Maintaining Protection when copying
  893. using sumif formula: but requiring satisfying 2 if statements
  894. Quick Little Function Help...
  895. Counting question
  896. What does 'cell("color",A1)' do?
  897. Conditional Sum Wizard
  898. calculate future date
  899. Headers on every worksheet
  900. Establish a Branch of Clayton College here in Malaysia
  901. the value of Text?
  902. Extracting Text from the right
  903. determine if a cell changed value
  904. SUM of Hex?
  905. want blank - not #N/A
  906. How do I copy formatting from 1 sheet to next in same workbook?
  907. How do I count occurences in a date range?
  908. Sums according to the content of fields
  909. formula that if ex. G4-G5 is less than zero = zero
  910. What happened to "Tab Color" for worksheets?
  911. calender in diary format
  912. Discount calculation
  913. Select rows of data in a worksheet on one criteria in multiple co
  914. =sumproduct((f5:f498=(cp5:cq5))*(e5:e498=(cp6:ct6) )*(m5:m498))
  915. Convert "800" to "8:00" or "08:00"
  916. A Challenge
  917. Named Ranges shown (or not shown) as blue means what?
  918. Running total
  919. Can I have a progressive number in the same cell when printing?
  920. Remove Time Element of a Date
  921. [XL] Edit Mode of formulae should be improved in legibility.
  922. Why "datedif" function results sometimes negative numbers?
  923. Running Total
  924. how do I use a cell value as part of a cell refereren in a formula
  925. Format to Thousands and x-foot the sum
  926. running total
  927. force excel to run in only one process excel.exe
  928. Summarize Out of Stock List
  929. Change General Format to Currency Format
  930. How do I make hide detail buttons in Excel 2002?
  931. in vba for access how do i get the day of the week for a date field?
  932. cell hililte
  933. MSNStockQuote Function Parameters
  934. I need a Formula, Please
  935. Random Number Generator
  936. Links to other worksheets
  937. Doing a grouped search in Excel.
  938. Different quantities of a certain item...
  939. How do I make all data in the formula bar appear in the cell
  940. Shelf Life Percentage
  941. Can this be done?
  942. How do I put each member of string concatenation in its own line?
  943. CTRL and END function
  944. IF function
  945. evaluate data by week number
  946. In excel, what does the esclemation point (!) in a function mean?
  947. can I format dates older than 1900
  948. another language in MS office at home and another at work
  949. How do I copy formulas from one wkb to another w/out linkng them?
  950. Create a list in one worksheet of the other worksheets' names
  951. How do I copy formulas from one wkb to another w/out linkng them?
  952. sumproduct between two dates
  953. Consolidating sheets
  954. Advance Filter Criteria
  955. hOW DO I
  956. Can Excel recognize when data is entered and apply formulas?
  957. Add cells from a range based on 2 conditions from 2 other ranges
  958. Cell and Sheet Reference/Return
  959. Nested Funtions
  960. Rate formula
  961. Multiple IF criteria
  962. Can I have different column widths in a worksheet?
  963. filter and delete
  964. EXTRACT TEXT FROM TEXT STRING
  965. Dynamic Arrays
  966. control-tab should move between Excel sheets without a mouse.
  967. How to create summary of expense report?
  968. Macro to Modify Pivot Table for Color and Bold
  969. Data Validation
  970. Sum IF function
  971. Limit or Exclude cells in Average and Sum formula
  972. Very simple, but difficult formula question
  973. Does a highlight row comand exist for Excel conditional formulas?
  974. Formula given three answer choices
  975. Copying cell values once and then making them static
  976. how do you find the SD(standard deviation ) for the multiple reg
  977. pivot table
  978. pivot table
  979. How do I translate from 5Row/20Col to 20Row/5Col ?
  980. n/a in vlookup/index/match formula
  981. Categorize drop down list
  982. i need to be able to add #'s in a spasific column togather
  983. Drop down lists
  984. formula to change 1 to a / and still add
  985. Return cell reference of lookup value
  986. Help with countif on multiple worksheets
  987. Data Validation
  988. Confused about arrays and ranges in functions
  989. Simple function problem
  990. Insert more than 1 Row Syntax
  991. How do I refresh the formulas in Excel?
  992. Can I automatically hide or filter a row?
  993. Quick formula question
  994. help with the countif function!!
  995. How to use a conditional function to insert an autoshape?
  996. updated running total from previous pages
  997. How do I filter a number list by numbers to the right of the decim
  998. Index needs a little help
  999. how do i comment 1000 lines of code at once in vba for excel?
  1000. Can cells containing linked formulas be identified?