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. Bringing in a Union Query with excel?
  2. Autofit and merge
  3. Header
  4. excel
  5. How do I calculate in an IF
  6. How do I select a number from a specific group of numbers?
  7. sum one cell from multiple worksheets
  8. how can a two digit # be set up with 2 0's at the beginning 0025
  9. how do i add up 2 x columns separately and also do a minu
  10. SumProduct Question
  11. Re: Percentage value of amount
  12. Sum column information based on multiple criteria
  13. Insert-Name-Define How to change formula after-the-fact?
  14. this command is not available in a shared workbook
  15. Shared Workbooks
  16. how many tabs on a excel spreadsheet can you have?
  17. change the year in employee absence schedule
  18. function
  19. How do I display duplicate records in Excel without deleting?
  20. IF and VLOOKUP (maybe)
  21. sum with multiple arguments
  22. phrase to equal a number in time sheets(al=5hours)
  23. Logical test question
  24. VLOOKUP returning value when range_lookup false
  25. calculating time
  26. how do i countif on multiple criterea?
  27. Not sure which formula to use..
  28. Match fonts when inserting an excel worksheet into a word document
  29. Leading zeros lost in csv
  30. CAN YOU SORT DATES IN A/Z OR Z/A MODE? IN EXCEL
  31. Excel VBA Macro to compare 2 worksheets for same values
  32. Count unique items in groups
  33. VLookUP problem
  34. Conditional Formatting
  35. calculating a date with the CHOOSE function
  36. create multiple worksheets from a mastersheet same workbook
  37. VLookUp Tables
  38. Should be the easiest thing to do...
  39. need to compare id numbers of records in 2 workbooks
  40. remove tail spaces
  41. Date plus 1 year, but begin of month
  42. Summing up worksheets
  43. Vlookup using a formula possible?
  44. what is print to file in print dialogue box and its useage?
  45. Not all Filters made on Page Field Variables Update the Data
  46. How to separate the numbers and characters in the cell
  47. linking pivot table data to a cell in other sheet
  48. Data contains more than 65000 rows ?
  49. Display multiple lines of text within a cell from multiple column.
  50. Help Required!!! Macro to load data from version 1 to version 2
  51. Personal.xls
  52. conditional formating using dates
  53. select highest value
  54. macro help
  55. auto filter doesn't return cells containing the custom search wor.
  56. How to Manipulate formula for Binomial Distribution
  57. Countif with Two Criteria
  58. Data in cell changes then another cell data to change
  59. How do I auto-highlight a 'below limit' number in an average
  60. Rapidly Approaching Meltdown
  61. How to seperate OT and Reg. Hours from total hours
  62. How to match bits to a certain value
  63. How do I calculate the inflection point?
  64. plot graph from multiple worksheet as embedded chart object on every worksheet
  65. how do I create formula to sum hours & min's
  66. Change text based on other cell criteria?
  67. how do I combine two pivot table?
  68. Grabbing the filtered data in a list?
  69. Grabbing the filtered data in a list?
  70. Multiple field match?
  71. VLOOKUP and its properties
  72. is there anyway to use sumif using 2 criteria
  73. end number keeps changing to '0'
  74. Conditional Formatting
  75. How can I get a worksheet name appear in a cell?
  76. Conditional Count 2 Columns
  77. to convert columns to rows having mulit independent group columns
  78. keeping a running total in a single cell
  79. Help getting first column data based on criteria?
  80. add blank space in cell if first name is not blank
  81. need help with SUMIF
  82. Due Date with year using IF for several cells
  83. How to automatically create hyperlinks with excel
  84. Rows and columns in 2007 1,048,576 rows by 16,384 columns
  85. sumproduct with dates
  86. Looking for help creating dynamic list numbers
  87. Looking for help generating list numbers with reference
  88. How can I edit cell notes while track changes is turned on?
  89. how to install microsoft exel
  90. Help with Lookup Calculation
  91. CUMIPMT
  92. Vlookup, return zero if not found
  93. If function calculating date
  94. Average if is not greater than today
  95. Lookup vertically to next cell with data
  96. IF(OR Function with years
  97. USE KEYBOARD TO SELECT ALL SHEETS
  98. How do I sort records that are on two lines in a spreadsheet?
  99. Independent column widths
  100. IF function returning incorrect result
  101. How can I print a worksheet excluding blank rows?
  102. Sorting by 5 digit & 5 digit plus 4 zip codes
  103. formula won't paste from one cell to another with current cell inf
  104. How do I do a two level Vlookup?
  105. Lookup in one column
  106. IF Function
  107. IF Function
  108. lookup column label based on data in cell
  109. Counting total for multiple criteria
  110. Pivot column disappears after external data refresh
  111. Excel "IF" function
  112. Consolidating a Row of data from many worksheets
  113. countcolor
  114. alerts
  115. Need help with formula for Weekly Value
  116. Saveing workbook to a file as todays date daily
  117. calculating days + holidays
  118. Autofill a list
  119. Pivot Table Help
  120. Autofill Sequence
  121. Pivot Table Help
  122. Formula auditing inactive
  123. Sorting data within the same row.
  124. How can I get the value and the format of a cell.
  125. Counting data by week number
  126. Dropdown frustration
  127. Moving Rows to another sheet based on an entry
  128. Combining LOOKUP and COUNTIF functions
  129. Paste Special
  130. Truly Null
  131. Return all figures in a Range
  132. pick the greatest number out of a group for the total box
  133. condtional formatting not working
  134. excel formula question
  135. "IF" function, have the facility to place a colour in the cell
  136. not able to create subtotal summary report
  137. Need to automate unique identifier
  138. VLOOKUP over multiple sheets
  139. DATE STATIC
  140. how do you conditional format based upon today's date?
  141. Change results , change data in othe cells across the row
  142. Conditional cell auto fill
  143. Plesae help: Excel function
  144. Difficulty linking cells in Excel 2003
  145. creating a formula that condenses information in a cell
  146. sumif and range validation
  147. Multiples of 4 in an IF statement
  148. how do i flag a cell using background color
  149. how do i flag a cell using background color
  150. reference to other sheet doesnt work
  151. how can you autofilter a spread sheet and keep your hypelinks in o
  152. Lookup and Sum
  153. WEENUM into months
  154. validating cells in the same row has unique values
  155. How can I change all negative values in a column to = 0?
  156. Sum of visible cells only
  157. Linking Access Records to Excel
  158. Vlookup funtions
  159. Need some comments on my Utility_Move class module.
  160. Freezing cells
  161. how can I conditionally change font color, or background color?
  162. cell comments disappear in shared workbook
  163. Lookup - not sorted?
  164. Need some help
  165. Formula Referencing data on multiple worksheets
  166. Find data from one sheet in another sheet
  167. How do I add a series of cells?
  168. Request a formula!
  169. Footer exceed max characters
  170. I want to import a web query into the same cells each time
  171. =COUNT(IF(AND(K2:K20>=382,K2:K20<=383),IF(E2:E20=" x",1,0)))
  172. Time Table
  173. How can I make a clickable button to do a Key Combo?
  174. Data sorting over a large number of worksheets
  175. saving workbook to destination file automatically
  176. Insert into Header/Footer List Box
  177. VLOOKUP and logical functions
  178. Count down with auto fill?
  179. comparing data
  180. Conference pictures
  181. Inserting Blank rows after every row upto 2500 rows
  182. varying a cll value from min to max
  183. Auto size a pivot table to a page size
  184. Disable cut and paste
  185. Help me find function Datedif
  186. changing rows insted of columns
  187. How to add in increments for multiple cells
  188. Conflicking dates in formula
  189. Increasing a range of grades available
  190. Counting with date criteria
  191. excel lookup matching and value display
  192. where can i get accounting templates
  193. Making a spreadsheet for orders
  194. Auto Date in a cell if other cell is greater than 1
  195. File Format Not Valid
  196. Excell formula required. If a^b=C....... a = ?
  197. Identify a range of cells containing dates
  198. Pivot Table Layout
  199. DATE RANGES and other functions, formulas
  200. Adjusting Referances
  201. Index function and changing criteria help.
  202. Font Color Function
  203. How to make average function ignore MIN and MAX
  204. Finding test strings in a row which are missing from a column
  205. Copying Cells with Drop Down Lists
  206. link a spreadsheet to another spreadsheet
  207. need help on delimited
  208. Skip blank columns with LOOKUP formula
  209. how do i get multiple values in vlookup?
  210. Gaps In Bin Locations
  211. Searching for a value in an Array
  212. Should I use IF here? How?
  213. How do I average 4 of the last 8 golf scores to calculate a handic
  214. Scroll bars without control tabs
  215. Extracting part of Text from one cell to another
  216. Name Ranges: Function to convert special characters underscores
  217. T Vaule function
  218. indicate a number of rows to sum
  219. Using words in Formulas
  220. Combining Words
  221. Excel Drop Down!
  222. Monster Formula
  223. Vlookup
  224. line appears when deleting chart- cannot delete it
  225. This Year
  226. letters cut off in cell
  227. Change colour of cell if there is no value
  228. I need to set colums and rows to stay on the screen as I scroll
  229. RE: I need to set colums and rows to stay on the screen as I scroll
  230. How to extract the month in a Pivot Table
  231. Linking Sheets
  232. Re: Change colour of cell if there is no value
  233. SumIF through filtered data
  234. Problems appending cells together
  235. no more new fonts may be applied in this workbook...
  236. How do I subtract time?
  237. Formulas
  238. IF(AND)
  239. How to keep 0 in front of # in excel (ex: 018787766316)
  240. how can i make number to letter
  241. autofilter does not hide unwanted results
  242. sum column with na from v lookup
  243. what is the problem" TOO MANY DIFFERENT CELL FORMATS"?
  244. My girls
  245. Show values in formula instead of cell reference
  246. INDIRECT
  247. My girls
  248. My girls
  249. My girls
  250. problem saving an open excel workbook
  251. Checking the Cells in Sheet1 with Cells in Sheet2 and replace
  252. Help with Crazy Lookups
  253. link worksheet A & B
  254. Can you set up a simple address book in Excel
  255. Lonely Heart
  256. calculate loan amout
  257. Analysis Tookpak
  258. Columns Counting Function Reqd
  259. How to convert date/time to seconds
  260. The most powerful computer security tool
  261. Autofill Match Formula on different worksheets
  262. sums are wrong
  263. Creating function to insert data based on criteria
  264. Finding day of week in 2030
  265. IF logic only works 7 times
  266. updating links
  267. sumproduct in a given year
  268. Adding time [t]:mm:ss
  269. How to retreive the data entry bar to edit a sheet?
  270. Day Off schedules
  271. How to get these cells into 1 column
  272. formula bar
  273. Conditional Formatting
  274. Analyze Data
  275. PIVOT TABLES
  276. Database Function Criteria Boolean Operations
  277. Sum formula result shows "#N/A"
  278. returning value if month is January
  279. Conditional formatting similar to shading alternating rows
  280. budgeting for your home
  281. connecting multiple cells to new sheet (VLOOKUP?IF?)
  282. How do you use more than 7 arguments in a logical IF?
  283. return range of data from lookup function
  284. return range of data from lookup function
  285. Re: IF AND OR functions
  286. Lady Only
  287. When Averaging a column, exclude value based on another cell value
  288. VLOOKUP using cell reference
  289. how to convert arabic numbers to english text format in excel?
  290. Inserting a cell changes my formula values
  291. How to pull extra info into Pivot table report
  292. Adding multiple worksheets
  293. How do I calculate only visible data (not hidden rows)?
  294. Inserting Characters
  295. Calculate Based on Drop Down Item Selected
  296. Match with a Twist
  297. How to Create a file in Excel that can't be copied or printed
  298. How to Create a file in Excel that can't be copied or printed
  299. How to Create a file in Excel that can't be copied or printed
  300. Excel drop down list arrow has disappeared.
  301. Digits to text
  302. Read
  303. Worksheet name
  304. ? about COMMENTS
  305. Tab Through worksheet
  306. Read
  307. Hyperlinks
  308. help making data base to look up stuff.
  309. How can I extract name of the LONG MONTH from previous cell.
  310. Read
  311. How can I combine cells with first/last names into email addy?
  312. Logging a website information.
  313. need to link without having source workbook open
  314. Freeze first and last rows
  315. inserting a row based on a condition.
  316. Get number of rows that data takes up, including blank rows
  317. LOOKUP formula
  318. Please help: identify where an automatic link to other spreadsheet is?
  319. help on excel function
  320. Finding most common occurence of values in cells containing letters and numbers
  321. link worksheet A & B
  322. calculating hours in one cell
  323. Count occurence with user defined upper&lower limit.
  324. Formulas to speed up many manual "=()" commands
  325. SUMIF function with text color condition
  326. How can I place a formula inside another formula?
  327. Help with countif using two columns
  328. Help combining formatting in macro functions
  329. IF ? function
  330. Blow ups in spread sheet
  331. How do I change replace text in a cell for different text?
  332. My IF in Excel formula is not returning the correct value.
  333. Relative Reference Help Macros
  334. Compare data in two columns
  335. + prefix on positive numbers
  336. Sumproduct
  337. A correct formula gives an incorrect figure
  338. Customize Formula Bar
  339. help with a macro
  340. Wildcard for finding the first numeric digit in a cell?
  341. How can I generate a unique number each time a form is printed?
  342. Insert Footer into Cells
  343. how do i write a macro
  344. using linest with very small numbers
  345. how do I create a formula in excel with using 2 columns of info?
  346. how do I create a formula in excel with using 2 columns of info?
  347. RE: how do I create a formula in excel with using 2 columns of info?
  348. UDF alternative to PULL that opens external workbook and grabs val
  349. How break column formatting to vary cell widths vertically?
  350. How to format a cell to reflect a NIC's MAC Address ? (put in dash
  351. RE: how do I create a formula in excel with using 2 columns of info?
  352. Is there a way to Lock down a date formula?
  353. sum of multiple arrays?
  354. COUNTIF on an autofilter?
  355. sum multiple lookups?
  356. Mortgage calculator: finish date?
  357. Repeating a concatenate function
  358. excel 2003- verify that row used in calculation is same within 2 c
  359. COUNTIF using OR
  360. Excel Marco for IP Address
  361. AOR to APR - Truth in Lending
  362. multiple column lookup?
  363. Price Function Error?
  364. How do I add a new TAB ?
  365. IF AND OR functions
  366. auto refresh
  367. Incorporating OFFSET into Chart References
  368. Calculating number of hours accross days
  369. wrong calculation in excel? formula outcome <> cell value??
  370. How can I have data auto insert into another pg in workbook?
  371. Automatically inserting a column
  372. Cell Referencing Code Error?
  373. IF Question
  374. if and or ifthen?
  375. Newbie at this---Getting to third standard deviation
  376. median function
  377. median function
  378. How do I add data to drop down lists?
  379. how do I copy R[40]C1 references
  380. Validating certain cell
  381. How do I sort with empty rows between none empty rows?
  382. search in excel - autolookup
  383. Dsum or Sumif Help!!!
  384. Make it possible to split unmerged cells again!!!
  385. Summary Sheet
  386. format cell to place colon btw every 2 alphanumeric characters
  387. address function
  388. If/Or Clarified
  389. Sumproduct wont update properly on closed workbooks
  390. Should be able to color code or highlight Excel worksheet tabs.
  391. How to embed email link in excel document to distribution list
  392. Re: Sheet Name in Cell
  393. formula to calculate time difference crossing midnight
  394. REPEATING NUMBERS IN A ROW
  395. Circular Reference Problem Calculating Net Pay
  396. Sum of columns that vary in position
  397. How to repeat multiple rows as a header - each page of worksheet?
  398. If and Or
  399. Force a field to be completed
  400. Adding a comment column to an external datasheet
  401. Adding a Comment-Column to an external data-sheet
  402. Filter the results of a list based on a previous vlookup against the same list
  403. Microsoft Excel
  404. CREATE A LOGICAL TEST CONTAINING TEXT
  405. Stylecheck function
  406. How can I count the no. of entries in a column.
  407. How do i match simillar data between two different rows in excel?
  408. Average & median of text "time" numbers
  409. Having trouble with AVG Function
  410. cell returns wrong value
  411. Concatenate and Line Breaks
  412. Executing a formula based on criteria being met
  413. have several excel questions
  414. Hi and function help please
  415. Is there a way to make Excel 2000 dial phone numbers?
  416. password protected
  417. RUNNING BALANCE NOT SHOWING
  418. Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA
  419. Calculating numbers without using "=" sign ?
  420. Can we have cells pop up with a formula & hide if not want
  421. If between function...
  422. Random name
  423. copy data from a worksheet
  424. How do I reference an Excel filtered list in a function?
  425. DIVIDE NUMBERS EVENLY
  426. conditional subtotal function
  427. Conditional formatting - Different cell value
  428. Automatically entered decimal point.
  429. Select and adjust a value based on a total
  430. Pulling data from one worksheet to another
  431. Re: "CONTAINS" operator?
  432. Can you link 1 column in a sheet to the same column in another sh.
  433. Re: "CONTAINS" operator?
  434. Remove some text from a cell
  435. Count reports per month
  436. How do I change excel sheet from R1C1 for cells to A1 for cell?
  437. Find the 1st occurance of a number in a cell
  438. Count unique text
  439. Sub total data by year
  440. Need to insert a counter for supplies ordering.
  441. looking for information in the last column
  442. If Question
  443. Sum a vlookup
  444. Intellisense
  445. Saving a file
  446. Re: "CONTAINS" operator?
  447. Have a list of items, 285, 285-A, 36-B, 23-D, 36 and need to sort
  448. RE: Have a list of items, 285, 285-A, 36-B, 23-D, 36 and need to sort
  449. Still need help on annualized rolling sum
  450. Working days and hours calculation - request assistance please!
  451. If, Lookup
  452. Text to Speech Function
  453. Please help - sorting list of numbers
  454. ability to look up posts to discussion group by user name
  455. Can INDIRECT function reference a cell that contains a formula
  456. change 2000 cells (negative numbers) into positive numbers
  457. can vb from excel launch another program?
  458. How do i print only the comments for one person on a report?
  459. Dcount with Multiple Criteria
  460. Displaying a number with different decimals depending on a condition
  461. Excel : how do I sum costs if the they relates to the same period
  462. Need help with division, please!!!
  463. Over keying a formula - Can I set this to automatically bold ?
  464. excel
  465. Add Visual Foxpro 9 DBF import / Export to Excel 2007
  466. LA User Conference October 25-27, 2006
  467. Exclude records that start with *
  468. I need a criteria expression to not include records that start wit
  469. Carrying Detail Data to Subtotal Row
  470. order of calculations in Excel
  471. worksheet adds 1 or 2 values to totals
  472. Referencing 3 values for a lookup
  473. Intellisense
  474. Office 2003 merge questions
  475. Fill Function to next Column
  476. Vlookup Help
  477. Changing formula to a value
  478. Date sensitive cell pattern color
  479. calendar control excle 2003
  480. Solve for rate of growth on an investment
  481. Rows to repeat on each page
  482. How do I tie fields from tables of diferente files?
  483. ROWS TO REPEAT ON EACH PAGE
  484. Mid Function
  485. How to calculate something using equation from Chart' directly?
  486. Percentages and formatting cells
  487. Merge Excel multi columns into Word
  488. Vlookup value between 2 cells
  489. Embedded VLOOKUP function within IF function
  490. Dynamic cell range for functions
  491. Program error when using Compare and Merge Workbooks
  492. Hiding error values in cells
  493. Barcode 128 B Add-In
  494. Having Trouble with the RANK Function...Try LARGE or SMALL Functio
  495. Conditional summing across several sheets
  496. Assigning Name to new workbook
  497. Formula to fill a cell based on an entry in one of two worksheets
  498. How to add a variable as a parameter for a link?
  499. Data validation problems
  500. Lookup function with mulitple conditions
  501. Merging if
  502. how do i remove folder explorer side bar
  503. How do I copy/paste odd or even rows from Exel?
  504. Set up macro in Excel to choose active row?
  505. Numbers stored as text prevent calculations
  506. extract data up to a certain character
  507. DP Auto increment
  508. Switch function
  509. Move a spreadsheet to an unopened workbook
  510. Checking for subfolders and creating
  511. linking cell colors
  512. Formula help
  513. Sorting alphabetical list into multiple columns
  514. Using search when it returns #VALUE!
  515. COUNTIF values are > 0
  516. How can I list worksheet tabs as a table of contents?
  517. How do I resolve a problem with sharing a workbook
  518. Pasting values from 2 colums into 1 on a seperate workbook?
  519. problem with date sorting
  520. How to Search, Count, Match and Post Values
  521. Concatenating entire columns
  522. repeat macro until empty space in next column
  523. How can data be summed for based on corresponding dates?
  524. Printing invoices
  525. Popup boxes for dates?
  526. negative numbers
  527. Data Validation
  528. Text Color Change prompted by different columns
  529. alphanumeric sorting
  530. alternative to if statement
  531. How can I change my column references from Alpha to Numeric?
  532. Excel 2003 is missing toolbar button select visible cells
  533. Consolidation of dulpicate rows of data.
  534. HOW DO I CREATE AN AUTO RETURN IN A COLUMN THAT IS OFF MY WORKSHEE
  535. how to convert a column of numbers (monthdayyear) into dates?
  536. Using VLOOKUP in VBA code
  537. Vlookup not Resolving
  538. Excel 2003- Benefit attandance calendar
  539. I need to understand how the IRR, NPV and FPV formulas work? Thks
  540. Sumproduct Not Working
  541. vlookup and hlookup
  542. Searching a text string in a range of cells.
  543. Compare Two Columns (Exact and Wildcard)
  544. Calculate number of months between dates
  545. Using seperate sets of radio buttons in one sheet
  546. Convert from Excel to Software ?
  547. How can I get Exel to display every (eg) 35th row only?
  548. What happened to the Invoice Toolbar in Excel 2003?
  549. Overwriting prior formula
  550. How to convert Kgs to Stns, Pds & Ozs
  551. Report choosing a Pivot table data
  552. How do I match values in one spreadsheet to values in another?
  553. Where in Office 2007 can I record a macro?
  554. formula or vba code
  555. Reverse of VLookUp
  556. Do I need to combine hlookup and countif?????
  557. Enquiry Form
  558. How do I select the first cell of a filtered list?
  559. Mathematic problem solving using Excel
  560. no #VALUE! to printout
  561. no #VALUE! to printout
  562. MOre than 8 argurement
  563. Sumproduct using dates
  564. Use filename in cell to link data
  565. color code a row by expiration date?
  566. analysing sales vs price
  567. Rank Function
  568. Rate function
  569. Closing files and saving files
  570. find two (2) lowest values in a range (Excel)
  571. random sample
  572. Round Len Function Help
  573. Excel should let you select 2 rows, right click, and SWAP them
  574. Removing characters
  575. Help with Random Functions
  576. Concatenate values
  577. Ned Help W/ Custom Function
  578. Benefit attendance calendar make 2 items .5 points not 1 pt
  579. Getting wrong values
  580. where can I find the "Calculated Field" in Office 2007 version?
  581. Compare 1 column to another
  582. net present value
  583. a count formula
  584. name range from absolute to relative
  585. Index, Match or what???
  586. Excel 2002 dropdown lists
  587. Match Column B numbers to Column A numbers
  588. eliminate repeat values from a list of ascending order
  589. concatenate and hyperlink functions
  590. Sum If
  591. If function
  592. IT'S POSSIBLE TO CREATE UPC CODE IN EXCEL
  593. Calculating Geometric Mean in a Pivot Table
  594. New to this forum and yes I need help
  595. Create a reference to a sheet that changes to todays date
  596. Replace function into text
  597. How to use a cell value as operator in a worksheet reference?
  598. Moving Related Fields
  599. COUNTIF
  600. COUNTIF
  601. How can I Insert a date in a cell from a drop down calendar?
  602. Count
  603. Sort Formulas?
  604. "Fixed Objects Will Move"
  605. Search numerous spreadsheets for specific data.
  606. add vs. replace data when merging workbooks
  607. match, lookup ???
  608. Transfering Values
  609. stop changing my formula
  610. Freze panes
  611. Conditional output
  612. ISNumber - What Context?
  613. Function similar to TREND that interpolates lin. between data poin
  614. Crazy Hyperlinks
  615. Sumproduct with date range
  616. How to create a drop down button on a worksheet?
  617. I cannot reach the next cells in the xls worksheet
  618. Is there an excel funtion that retreives the last cell of a list
  619. Excel 2000 freezes when I try to Copy & Paste after start-up.
  620. How to Hyperlink from Excel to a VSS file ?
  621. excel formulas
  622. How to check valid Date value?
  623. New to this ! If Cell = less than
  624. Copy & Cut different animated boundaries
  625. Countif + Named range
  626. Loading MS Query takes a long time
  627. Minimum formula the excludes zeros
  628. Sum with two conditions
  629. Cell reference within a indirect..
  630. Can we use multiple if with VLookup function
  631. excel result return wrong calcuation result
  632. excel result return wrong calcuation result
  633. excel result return wrong calcuation result
  634. Help: SearchAndGet a value Help
  635. validation list. Scroll to top when using, how?
  636. return wrong result of the cell
  637. hyperlink a worksheet with no address
  638. Need function for one value for two criterias and two columns
  639. How do I nest IF statements to only return value if both true?
  640. Macro Function
  641. How do I set a cell to auto expand when it has a formula?
  642. How can I move from one desired cell to another in Excel using ENT
  643. automatic table to table copy
  644. Changing a Formula
  645. how do I convert a column last name first and in assending order?
  646. Conditional formatting between worksheets?
  647. Auto Updating
  648. How to specify which cells/columns macro applies to?
  649. formula problem
  650. Summing figures within letters???
  651. counting letters.
  652. Importing File greater than 65536
  653. Stop Excel 2003 auto-scrolling
  654. I need help with a simple vlookup formula
  655. data validation
  656. help with formula
  657. formala help required.
  658. Now as timestamp
  659. ascending sorting
  660. div
  661. Processing Data
  662. How to use RATE function?
  663. Another checkbook registry problem...
  664. if cell = no how to copy to another sheet
  665. % query
  666. how do i get field name from result of MAX or LARGE function
  667. How can I set excel to automatically insert rows
  668. Function or macro?
  669. How do I run the STDEV function with multiple criteria?
  670. Missing Excel commands
  671. What formula will eliminate the cell with #N/A when summing?
  672. Using conditional formatting to plot campaign dates.
  673. When I add time - Example 10 days of 8 hours each I receive 81.46
  674. RATE v. IRR: which to use?
  675. Formula or Function?
  676. Auto Update the formula values without opening the link worksheets
  677. Match 2 worksheet
  678. WEEKNUM to start on another day
  679. Formula Help
  680. how do i unlock microsoft word?
  681. Looking for a formula that will divide a column & rows by 2
  682. Current date and time when different cell = X
  683. Transposing Cells
  684. what's the command for erfc iterate integrals?
  685. Is there a formula for inches to feet and inches?
  686. Formula errors
  687. formant input
  688. HOW DO I SEPERATE INFO FROM ONE INTO TWO COLUMNS?
  689. financial calculator
  690. text and number combined in a cell
  691. how to calculate Rate when PMT, Nper & PV is known
  692. How do I make my borded automatic black instead of pink?
  693. copy multiple cells but jumpin one step at a time
  694. How do I create a formula using part of the data in 1 cell?
  695. Is This Embedded in The COUNTIF() function???
  696. Today minus 1 day
  697. Formula for excel.
  698. Validation
  699. Cell function
  700. Need set up template/function in Excel to gather survey answers
  701. adjust the range in a long column of formulas to accomodate new da
  702. How to find the largest change of values in a column
  703. breaking links between excel files when one file already deleted?
  704. I Need Help Creating or Finding an Excel Template
  705. BIG FILE SIZE??
  706. Help with creating a formula
  707. Converting numbers to longitude and latitude
  708. MSN Money Stock Quotes
  709. SUMPRODUCT
  710. How do I slant field cell in the first row of a spreadsheet?
  711. WHAT FORMULA DO I USE FOR AGING A STATEMENT
  712. Adding times
  713. Date Conversion- DATEVALUE- including minutes
  714. cell color
  715. How can I create shortcuts for the view function in Excel?
  716. Format: General - Text - General
  717. Auto Filter question
  718. How do I keep Excel temp. format on import from another program?
  719. Formatting Cell from one sheet to another
  720. user defined function
  721. Subtract 6 months
  722. Copy info IF MAX
  723. Automating entry in a cell
  724. Locking rows or Regions in Excel worksheets
  725. Sorting a six digit number by terminal digit
  726. insert blank cells
  727. Automatically changing range of functions for monthly columns
  728. diable the save function when saving a spreadsheet online?
  729. copy numbers from numbers+text cell
  730. Autofill based on a cell reference
  731. GETPIVOTDATA() with relative reference
  732. 50% formula
  733. Help! I want to fill cells as a result of selecting a value from a list in another cell.
  734. How do I get back the sum feature when I highlight cells?
  735. #REF!, TRUE or FALSE
  736. OPen .hgl files
  737. auto filter / sumif
  738. Declear which picture I want to show and not?!
  739. AutoSum
  740. i cant see my user defined functions in function list
  741. Linking worksheet to Access Tables
  742. Excel with functionallity for calculation on in more levels
  743. Multiple If and Vlookup function
  744. How to set a number number value as text in all cells ?
  745. How to calculate cumulative values
  746. require macro or code for purchase order to do the following:
  747. Days to Years ? How
  748. IF Function
  749. something more than vlookup??
  750. advanced lookup/index-match problem
  751. centering items
  752. Lock the cell once enter the data
  753. Lock the cell once enter the data
  754. Blank Print
  755. New user needs HELP
  756. IF and Date Functions
  757. hi - is there a formula that matches text in different columns?
  758. Print mutiple sheet macro
  759. Count by date and hour
  760. Degrees
  761. How do I set up a 6 day work week in Excel?
  762. Question about SumIF
  763. 2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates
  764. large page number in cenetr of sheet
  765. NETWORKDAYS calc with 3 columns of dates
  766. Copy data based on a count...
  767. Copy PasteSpecial not working
  768. Searching for duplicate numbers
  769. Updating Info from a previous worksheet
  770. median, frequency or histogram
  771. how to transpose forumlas
  772. microsoft excel
  773. Assigning consecutive dates
  774. Connecting of two data validating with each other
  775. How to hide running total in successive cells in a column
  776. #VALUE! in Time Calculation
  777. MAJOR Worksheet Dilemma
  778. Loop through folder of workbooks and add rows
  779. Rolling over the icons does not show information.
  780. Using an array range in GETPIVOTDATA
  781. Is there a way to find the address of a cell with a certain value?
  782. Function help
  783. Help on a function with Conditional Formatting
  784. Can you save add-ins information in a spreadsheet
  785. if function help
  786. if question
  787. Use an If Sum
  788. How to do a cartesian join in Excel?
  789. Wordart in Excel
  790. color page display black and white
  791. Why is Paste Formulas option is acting like Paste All option?
  792. How to add a suffix to a whole column of different part numbers?
  793. Can I use an array function to solve my question???
  794. Find the previous Weekday (thursday)
  795. Matching 2 lists
  796. Displaying Outlook toolbar in Excel
  797. Ctrl+Alt+F9 not performing Full Recalculation on some PCs
  798. date reading formula question
  799. How do I turn 'update links' back on when turned off?
  800. Link from a specific Cell in Excel to a specific para. in Word
  801. CAGR
  802. What does "No more new fonts may be applied" mean in Excel?
  803. Formulas
  804. Conditional formating a row
  805. Conditionally Formatting/Code Only One Word in a Formula
  806. When I sort an excel spreadsheet the data disappears.
  807. Merge two files and then allowing deletion of duplicate cells?
  808. Custom AutoFilter
  809. Reference workbook name
  810. Minimum Exam Score Calculator
  811. array formulas and getformula UDF
  812. page total
  813. how can I trap the change event (Tab Press key) of these controls
  814. how can I trap the change event (Tab Press key) of these controls
  815. List of Control functions
  816. what is PAR in the Yield Function
  817. Adding a date when something was created.
  818. sumif with criteria
  819. SumProduct Returns Zero
  820. importing a particular excel worksheet into another excel file
  821. Strange Data Look Up Problem
  822. MMULT
  823. Excel Throwing Circular Errors When No Errors Exist
  824. Sorting large worksheets
  825. Formula to rank cells alphabetically
  826. Links
  827. IRR function
  828. Hiding/Unhiding Columns
  829. VLookup & Case Sensitivity
  830. how do I count the number of gray-shaded cells within a range?
  831. changing x axis of column graphs
  832. How do I set up an Investments Trading and Cash Template?
  833. delete empty rows in workbook
  834. Product type function H.e.l.p
  835. Sumif Problem
  836. Multiple Lookup and CountIF
  837. Lookup between two margins / brackets
  838. number comparion function
  839. Edit Links Trouble
  840. Autocopy of data filtered by drop down list
  841. Importing a file(s)
  842. Page Break Preview Problem
  843. Extract specific value from a long text string
  844. Vlookup problem...
  845. Relative Cell Reference
  846. Help! I need multiple formulas for one cell.
  847. How can I convert a group of numbers to a group of letters?
  848. Finding Missing Data
  849. Multiple criteria
  850. Selecting Multiple Columns in a Named Selection
  851. find cell function
  852. Matching multiple columns and retrieving a value
  853. Accessing Attached xls File
  854. Index function
  855. Lookup?
  856. formula to add cells in multiple shts in the same wkbk
  857. Time sheet calculations
  858. Drop Down Box font size
  859. Changing the date format in a cell
  860. How do I add all "B1" cells on each worksheet?
  861. Add a guidebar in Excel
  862. Offset question
  863. VLOOKUP from Access Tables
  864. Fun With Functions
  865. Function that searches cell for string?
  866. getpivotdata refresh problem
  867. MATCH() and duplicate values -- is there a workaround?
  868. I want to be able to type vertical text on an excel worksheet
  869. hyperlink: back to last worksheet
  870. In Excel, conditional format (font red) referencing another cell?
  871. Lookup Array Calendar
  872. Put filename in a cell
  873. Reverse a spreadsheet reversing columns and rows?
  874. in excel 2003 a formula if cells have 0 = n 1-3 =s 4ormore=s
  875. How do I get rid of #REF error, imported Data changes
  876. Can you automatically filter for unique records?
  877. Please help iwith formula....second try....
  878. Variable column to fixed array
  879. How do I get tab to move the cursor one cell over rather than 8?
  880. Searching for the nearest value
  881. Problems with SUMPRODUCTS
  882. Conditional Sum Argument results do not equal cell results Excel
  883. how can i set more than three conditional formats to xl worksheet
  884. no comma separator for ="total"&"$ "&sum(a1:a10)
  885. named range help
  886. Is there a way MATCH() can cope with duplicate values?
  887. ﹎ 專收手機,保証最高價!
  888. vlookup Function Help Needed
  889. Look up based on Column and Row headings
  890. Can I group overdue Invoices by date from an Excel worksheet?
  891. What is the exact equation used in ToolPak t-test (unequal vari?)
  892. to-date total based on current date
  893. Or function with invalid number "zero/zero"
  894. Help with Match() function
  895. Cell Displays Formula, not result
  896. Help
  897. Lookup certain text within a cell, PLEASE HELP!
  898. formulas and decimal places
  899. text and numbers in cell
  900. Help
  901. Help
  902. How do I hyperlink from Excel to Outlook for a specific Contact na
  903. Workdays Function
  904. IF function
  905. Excel Charts
  906. Reformat A Time Value To Add/Subtract
  907. Dynamic links within workbook
  908. How do I unhide the PERSONAL.XLS worksheet?
  909. Cell Content as Header?
  910. Pivot tables - text rather than number?
  911. Provide a match from 2 cells to give a result from another
  912. type of probability distribution
  913. Formula result as real empty/blank cell
  914. Urgent enquiry
  915. Conditional Average (2 conditions)
  916. Suming selected cells based on two criteria
  917. Simple Calculator Problem
  918. hiding then printing a row
  919. MULTIPLE (X3) COUNT IF FUNCTION
  920. excel access will not update time
  921. Cell link inbetween Asterisks
  922. Something other than DATEVALUE
  923. Download excel doc from website, can this be done?
  924. Adding and subtracting dates
  925. histogram and macros
  926. Importing
  927. Using if function to show blank when cell in other sheet is empty
  928. Can a cell be *either text or the result of a formula?
  929. How do I find the cell reference that contains the minimum or maximum
  930. Accessing Attached XLS file
  931. Variable in VLOOKUP and referencing a cell another file in excel
  932. May be Explode is the correct to do this!
  933. How do I calculate employment service and display as yy/mm/dd in .
  934. Excel Formula to Calc Daily Averages?
  935. Excel Division Formula
  936. convert 7h 40.80n into time format
  937. Secret Code for Confirmation
  938. Spreadsheets
  939. Question about copying column of cells and......
  940. how do I nest 3 items?
  941. What formula figures less than & greater than?
  942. How to change empty ranges from a plot series without generating e
  943. 60% formula
  944. How do I sort locked cells in Excel?
  945. How Do I increase a date by 90 days?
  946. What does the double dash or "--" do when using it in a function? (and other questions)
  947. Need help with a Multiply Dependent One Cell Formula
  948. Macros AND Buttons
  949. How do I get the text to WRAP in my text box??? thanks...
  950. Re: error when running cut & paste macro
  951. Let me explain my problem... (Roommate Accounting)
  952. table, index, array, match, lookup?
  953. Updated Function Question
  954. copy & paste and change format
  955. how do I change cell references in a column
  956. Force "+" sign
  957. Can this formula be placed in VBA please.
  958. Return the column
  959. Repeating Columns
  960. RE: template for farmers
  961. Calculating difference between two times
  962. RE: rounding to multiples in excel ?
  963. I am trying to combine contents from 2 cells into 1
  964. Fomula (if?)
  965. Removing Blanks
  966. Bin, Distribution multiple objects???
  967. help with array
  968. Can one count cells having a certain format? i.e. using countif?
  969. Automatic Formula to Value Conversion
  970. how do i do a highlighted formula?
  971. Usernames and Passwords--Thomas Homan
  972. Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS!
  973. Can a header be applied once to a workbook & print on each page?
  974. Running Excel 2000 VBA Application on Excel 2003
  975. Multiple Correlations and Multicollinearity
  976. Importing a file
  977. Using Index Match etc. for price list
  978. VBA CODE range
  979. Choose date from drop-down calendar
  980. formula help
  981. Nested Formula?
  982. range only if A3=1
  983. range only if A3=1
  984. Split mail merge into separate headed columns
  985. Is This possible?
  986. Pivot Table Refresh
  987. Is there such a thing as an "if" command in excel?
  988. Text Import Wizard
  989. Modify array function length
  990. Auto Filter
  991. VLOOKUP example not working...
  992. I need to use the sumif for a workbook, not a worksheet
  993. Average-Range Change Each Month
  994. How to Add Rows From Active Cell with in a XLL Code
  995. Inserting new row but keeping formulae
  996. Using Comma in customise option
  997. how to calculate the number of non blank cells from any column?
  998. a problem with blank lines
  999. looking up values in 1 column based on 2 other columns
  1000. how do i enable a drop down list depending on result of "if" funct