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. dash
  2. How do I delete an excel list?
  3. Cross referencing
  4. reverse or invert column data
  5. 15+ digit numbers
  6. How do I balance a chckbook? what is the formula?
  7. make worksheets sortable
  8. Formula help
  9. Lookup/Date Question
  10. How do I enable the tab function between text boxes?
  11. sort tables
  12. Multiple Criteria Lookup
  13. Run multiple excel files off of one macro.
  14. Replacing Data
  15. SUMPRODUCT Help
  16. Dual ranges in Excel formulas
  17. Find first row with given value
  18. Conditional formating to highlight dates 30, 60, and 90 days out?
  19. how do the details in an excel spreadsheet move to a summary page
  20. how can i convert an email address to a web address
  21. How do you convert $100M into a whole number?
  22. Count?
  23. Damse in Distress Need Help!!!
  24. Time Format
  25. using the subtotals (data) can you use muliple functions(sum,max)
  26. Need help with vlookup.
  27. moving source cell in excel
  28. emailing tabs from a workbook
  29. Excel 2002 Autofilter
  30. I cannot hide a sheet in a workbook. Why?
  31. Array lookup
  32. Weakness in the Cut / Copy Paste function of Excel 2007 Beta
  33. Need to condense my formula summing many values over many sheets
  34. Exporting time from cell in 24 hr format
  35. moving filtered data between worksheets automatically
  36. Top 10 values for each value in column X
  37. How to convert numbers to text (e.g 10 = Ten)
  38. Auto Filter does not show all the data in the column
  39. Bring back lowercase values
  40. sum every other cell in a row if next cell meets certain criteria
  41. Sorting with data validation applied
  42. how do i copy n paste one cell to another in different worksheets
  43. MOD
  44. working with dates
  45. Counta function question
  46. percentage return on charcters not numbers
  47. Multiple Matches
  48. Reshaping squares and circles
  49. formula for copying values from one workbook to another
  50. Counting the appearance of a String in a Row
  51. How do I protect a Work sheet so a user can only alter certain cel
  52. Triple lookup?
  53. Calculate age
  54. Forms - Checkboxes
  55. How to sum and substract hours, minutes and seconds
  56. MATCH function in a VLOOKUP
  57. Lookup returns blank if no match
  58. SUMPRODUCT with Max Function Help
  59. If statement
  60. Trouble with IF
  61. Multi IF statament
  62. How to edit the link?
  63. Address block carriage returns not correct
  64. How to edit the link?
  65. How do I set one cell to equal another if its contents are empty?
  66. If Then Question Regarding Dates
  67. get the VLOOKUP function to return the "contents" of a cell?
  68. Is there a formula that can find the cell corresponding to a trans
  69. Lookup and Display Using Multiple Criteria
  70. suming in add-ins
  71. How to fill out a table (a row) with data from another worksheet
  72. Macro upon opening
  73. autocomplete
  74. AutoComplete
  75. How to Express a Multi IF Statement Q
  76. Two questions, how do I disable ver 4 macros and how do I make radial buttons like this?
  77. Freezing an auto update field
  78. VLookup & Nested Functions
  79. Worksheets
  80. how to randomly select data in excel
  81. how to randomly select data in excel
  82. divide total over linked cell
  83. IF then statements-Tiered PRicing
  84. Dividing linked cells
  85. hidng formulas without using protect sheet
  86. Find a Value by interpolation from a table of x and y values
  87. How do I model a Paretian Distribution in Excel?
  88. distribution of dates via HIST Function
  89. Creating a formula which multiplies by two seperate %'s
  90. Format % Question
  91. How to convert string to date
  92. Row_Index_Num Increment
  93. If Then Formulas
  94. HOW I MARGE THE COLUMNS FOR EXAMPLE 1 2 3 4 5 PUT IN ONE COLUMNS .
  95. validation with two specific formats
  96. Worksheet Macros for All Worksheets in a Workbook?
  97. Having the current time inserted w/o updating the current time
  98. Can you put the same header/footer on the entire workbook?
  99. Hiding row and column letters and numbers...
  100. Hiding vlookup message #N/A
  101. who done it in a shared workbook
  102. Sum
  103. How do I have a cell highlight when selected?
  104. How do I have a cell highlight when selected?
  105. How do I have a cell highlight when selected?
  106. count if (possibly?!)
  107. HOW DO I DUPLICATE SHEET TO BOOK???
  108. Looking for the smallest number that isn't less than zero
  109. Convert e+ e- to number
  110. Return value from list based on criteria
  111. LOOKUP I think!
  112. copy name from active sheet to cell - using macro or function
  113. Matching two cells
  114. My "IF FUNCTIONS" on excel worksheet do not work
  115. How to:Find the row of the first cell not equal to several values
  116. Automatically display filter range in report header in Excel
  117. Reverse output of the Linest function
  118. Auto data fill in
  119. Auto cell move
  120. Problem with Data Validation and limiting characters
  121. ROUNDUP and -1
  122. formula to roundup to the nearest 9
  123. Auto-cell problem using "@" sign.
  124. How do I Select Multiple Non Adjacent Rows based on a cell value?
  125. Extracting Workbook name
  126. Excel VBA coding - Outlook and Shut down issue
  127. Running Frequency Table
  128. How can I insert and delete rows within a locked cell range column
  129. Solver whole numbers
  130. Flip Values in Single Column
  131. to calculate the difference between sign in and signout time in minutes.
  132. Location of space in a text in a cell
  133. revised: help with calculating 3 part function in excel
  134. Excel spreadsheet problem
  135. help with calculating 3 part function in excel
  136. Subtracting Hours
  137. Excel needs to allow infinite rows and columns.
  138. Formula to auto fill in following month.
  139. How do I run a regression on data that is not numerical?
  140. Search Column Data and Return Multiple Values across Row
  141. Reverse NETWORKDAYS function?
  142. How can I set up names to automatically copy from a spreadsheet?
  143. Average Function and dynamic cell address
  144. array formula does not work
  145. Range of Values Returns One Result
  146. VLOOKUP function returning data from ranges
  147. Trig functions
  148. Sorting by Row Number?
  149. Freqencies over Time, in Columns -- Easy Question
  150. how do i get exact matches in a vlookup fomrula
  151. how do i get exact matches in a vlookup fomrula
  152. count text in column a if column b >= 25
  153. Conditional formatting based on text within a formula
  154. Count and Sum data in same Pivot table
  155. PRINTING
  156. hyperlink
  157. Something more than Conditional Formatting
  158. match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw
  159. EXCEL Books
  160. How to add previous sums in a column to current sums in a column?
  161. Matching Multiple Columns
  162. Shortened formula
  163. lost the ability to bracket negative numbers
  164. How do I calculation vacation accrual?
  165. need formula for % of times text appears in row.
  166. Formula
  167. Counting rows based on multiple columns
  168. Help with complex average/if statement
  169. Copying figures from Access to Excel
  170. Want average sales numbers for last 12 months.
  171. Display Month - 1
  172. Day of the week
  173. Pulling multiple values from a list based on a wildcard search value?
  174. macros for autofill
  175. Edit Drop Down List
  176. Should I use COUNT IF? from one sheet to another
  177. Reference a list to perform a function in Excel
  178. too many nested IF functions
  179. table lookup
  180. If Function Assistance
  181. Need blank formula cells rather than 0's
  182. How can I set up a series with letters and numbers together?
  183. Vlookup not working
  184. Naming same cell in different worksheet with 2 value changing on e
  185. Lookup Closest Value
  186. need help with MY FORMULA
  187. More than 16 nested IFs!!!!
  188. sorting a column with numbers and text
  189. SUMPRODUCT - Count Previous Month
  190. Array Formula with Concatenate and If
  191. =ROUNDUP(INT(0.xxx))
  192. SUMPRODUCT question
  193. Flaging Dates
  194. Issue with a formula to help generate a report.
  195. array function
  196. Add VLOOKUP
  197. Large excel file
  198. Disable Search Function In Excel Worksheet
  199. Combining multiple worksheets
  200. SUMIF with external data
  201. Converting text to formulas
  202. count many with COUNTIF?
  203. RAND FUNCTION
  204. SUMIF Function
  205. Adding VLOOKUP
  206. Search / Mid function
  207. Dynamically Changing HLOOKUP table
  208. Using VLOOKUP, IF and RIGHT functions together
  209. Error dialog box meaning and how to find error
  210. VLOOKUP MULTIPALS
  211. Link multiple worksheets while extracting data
  212. array functions
  213. SMALL function if > 0
  214. calculate count on 2006 total, 2005 total, etc...
  215. Worksheet Protection status
  216. array manipulation
  217. Help with formula/function
  218. AVERAGE(with complicated range -blanks..)
  219. Help with formula/function
  220. Automating a series of dates for two columns?
  221. How do I convert dates (09/15/06 or 09/20/06) to month (Sept 06)?
  222. Formulas
  223. Start/End Date Calcs
  224. can I auto fill zip code column when city is typed
  225. Finding the last cell to enter a string and/or a sum formula
  226. sorting
  227. HOW TO COMPARE COLUMN VALUES IN EXCEL?
  228. HELP
  229. Can columns be hidden accross multiple sheets in an Excel workboo
  230. How to do one cell accumulation
  231. SUMIF Question
  232. How do i change quantities into letters ?
  233. Hide rows
  234. IRR: is there a quickest way?
  235. Change part of formula
  236. What function(s) are best to use and when?
  237. dependent drop down - repeat values
  238. locked cells
  239. Hide Rows
  240. One-time NOW() function
  241. can I sort names in a column by the last name if it is typed last
  242. SUM IF, Month
  243. Hide the rows
  244. Rearranging cells into certain columns
  245. consolidate data using 3d function AND indirect
  246. Delete cell on 1 page: automatically delete on another page?
  247. Find value in array
  248. count of different type records
  249. eliminate access to page break
  250. Absolute Value
  251. Re: 2006 West Coast Excel / Access User Conference
  252. Link cells to worksheets
  253. Can Excel show changes between two separate spreadsheets?
  254. VLOOKUP return text not date
  255. demand planning templates
  256. help needed
  257. Exporting data (Data Table) to Excel
  258. DATA SORT REQUIRES IDENTICALLLY MERGED CELLS???? HELP PLEASE
  259. Packing characters
  260. Conditional Underline
  261. Problems Sorting
  262. Sorting Numerically
  263. Excel should let me unhide all sheets at once.
  264. conversion of book bar code to ISBN
  265. Help with Excel Function
  266. If & Index & Match
  267. Need Help Editing this Function...
  268. Concantenate Social Security numbers currently parsed out
  269. excel searching
  270. How do I round time
  271. Dropdown box
  272. Conditional use of formulas
  273. XIRR 0.00% Return with Small First Deposit
  274. SUMPRODUCT ---> semicolon (;) vs. plus sign (+)
  275. excel conditional formuals
  276. IF Function Problem Excel 2000
  277. RE: Need big help with look up....is this possible
  278. SET UP AUTOFILL! Pleae HELP!!
  279. Select End of list in formula?
  280. Eliminating Duplicate GROUPS of Styles
  281. Time Differential Error???
  282. Color code cells
  283. complex excel situation
  284. In a function, How do I copy the cell color as well as text
  285. copying worksheets in a workbook limit?
  286. Urgently need help with a formula!!!
  287. Multiple lists with repeated values for dependet drop down lists
  288. Office Assistance: VLOOKUP, Example 3- Row headers 1-7 are wrong?
  289. Can open the spreadsheet, but won't let me enter anything in it?
  290. why does the vlookup function not work using time?
  291. Custom Validation Not Accepting Valid Data Revision
  292. filter help
  293. Opposite to CONCATENATE function
  294. name an active worksheet
  295. the countA function is counting everything even empty cells
  296. Problem with VLOOKUP in 2003.
  297. Excel X for Mac - show formulas
  298. To delete rows when more than one cell is blank
  299. Grouped columns & rows
  300. Reminder in Excel?
  301. I would like to find the last day of a month
  302. how do I format data from access to work in excel calculations?
  303. SORTING PROBLEM
  304. How can I count amount of Days I worked per year on Excel ?
  305. Pls Help
  306. How to convert 120608 in Excel into 12 Feet 6 inches 8 sixteenths
  307. How do I stop graphs reading zero in Excel from cells with ""?
  308. Color Tabs
  309. Pasting Values between sheets in VBA
  310. referencing selected cells
  311. Named Range Question
  312. Convert a text file to columes
  313. drop-down calendar
  314. Simple lookup - or maybe not so simple - help!
  315. Protecting Cetain Cells in Excel
  316. Re: Vlookup Frustration
  317. RE: Comparing data
  318. RE: Vlookup Frustration
  319. Re: Vlookup Frustration
  320. Want to choose last filled line, but dont know how?
  321. fined all same word in one text and sum number of repeat within d.
  322. IF statement query
  323. What is the keyboard shortcut 2 bring up the excel sheet tab menu?
  324. index match
  325. find a worksheet and extract data
  326. Capture RS232 data
  327. Using cells to refer to worksheets
  328. Using "@" unrelated to email address
  329. Index Match for 2 columns and one Row
  330. Help on Adding the same cell in different sheets.
  331. Count text based on multiple (2) conditions
  332. SUMPRODUCT help
  333. How do I get labels to repeat in a pivot table?
  334. sumproduct of two categories
  335. How do i place a roundup functoin at the end of a formula?
  336. Can a formula find a comment in a cell
  337. Copy and Paste help needed - tia!
  338. macro needed for non-blank cells
  339. [VBA] How to highlight rows in PivotTable
  340. SEARCH A NAME ON COL A & SUM THE VALUES ON COL B
  341. what does the +1 do in =INT(6*A2)+1?
  342. Activating Function
  343. [VBA] Hiding rows in PivotTable
  344. and function
  345. Cell in Excel spreadsheet will not accept entry of specific data v
  346. worksheet to worksheet . . .
  347. ISMPT compared to Amortization
  348. Auto advance after scanning
  349. excel worksheets
  350. Adding Time Function
  351. Can I get multiple trend data on one curve?
  352. displaying a formula's answer into a separate cell
  353. How do I sort by entry date?
  354. getpivottable function?
  355. Excel Dates w/ No Slashes
  356. Error with SUMIF but not SUM(IF)
  357. Formula/Function to insert month by name in a cell
  358. Dynamic Cell Lables? Or better solution....
  359. Pulling Data in Excel
  360. 3 level sort, last special order
  361. Displaying Document Properties in Excel
  362. VLookup or Something Else?
  363. Calculating Networkdays and Business Hours
  364. pasted column splits at spaces
  365. Relative vs Absolute referencing of Workbooks
  366. lookup data
  367. Time Sheet list linkage
  368. Pasting Excel data into Word doc.
  369. user cannot access his share workbook on network drive.
  370. Protect a worksheet with a password
  371. Consolidate data from multiple sheets
  372. COUNTIF with two criteria's
  373. Average Error
  374. vLookup with multiple lookup value in table array
  375. vlookup for maximum value
  376. Strange problem with Code
  377. HOW TO CHANGE BETWEEN THE SHEETS AND ONE MENU
  378. IF VLOOKUP Nested function
  379. Importing CSV-File with formatting informations
  380. Excel 2003 Linest Function Bug
  381. Lookup text then copy over to new cell
  382. How to code it in excel?
  383. present value formula
  384. LOOKUP two data sets for match - return 1 or 0 - Please help!
  385. CHANGE SHEET
  386. SumIf two axes
  387. Query Problem
  388. How to save my VBA-code
  389. Creating Dialogue Box
  390. Unlocking protected cells
  391. Vlookup and few more questions :)
  392. IS THERE A DAILY MEDICATION DOSAGE LOG TEMPLATE ?
  393. What is wrong with this formula?
  394. Add a line in different places?
  395. How do I use the IF formula to flag me 21 days after the date?
  396. How do I use the IF formula to flag dates 21 days prior to deadlin
  397. User Defined Functions - local or global?
  398. can i convert a worksheet with data into a calander
  399. how do i set up a 'rolling shift pattern' worksheet?
  400. Whatsthe formula which retrieves a # from a multiplication table
  401. look up with multiple criteria and within a range
  402. I need a specific formula in excel
  403. Match with tilda characater
  404. Limit on array formula
  405. Excel 2007 (Beta) Auto Filter
  406. How to have information auto input if cell = yes
  407. mutiply by either REG or OT hours, and SUM!
  408. an if( statement looking for a specific phrase anywhere in a cell
  409. Last column entry lookup.
  410. formulas using if parameters
  411. ADDING A PRINT CONTROL BUTTON
  412. Counting data over multiple worksheets
  413. Concatenate & Date
  414. Pull last word from a text string in Excel
  415. How to open a workbook on a specific worksheet.
  416. Need to sum "last 5" red cells
  417. Text Restrictions
  418. top ten customers by transaction count by product
  419. How to calculate time after converting 12.22 to 12:22
  420. Removing 1-2 caharacters
  421. ranking based on criteria
  422. if function and ifblank() function
  423. Formula not copying down
  424. Counting if between date range
  425. copying date from one sheet to another work sheet
  426. Re: Need big help with look up....is this possible
  427. Can I protect a document and still open / close groups
  428. Naming Cell in diffetn worksheet
  429. Naming Cell on differnt worksheet
  430. calculate the sum of characters in a cell
  431. Pivot Tables
  432. Need Help Badly!
  433. Can I position a PAGE NUMBER side of a sheet?
  434. Complicated SUMPRODUCT
  435. why doesn't this formula work?
  436. how do i use if function to different texts
  437. formula to auto populate zip when city is typed in Excel
  438. Multiple conditions for conditional formatting
  439. How do I insert a drop down list button from an excel worksheet?
  440. Adapting MAX function
  441. Nested IF functions beyond eight items?
  442. tracer arrows not visable
  443. How do I limit characters in a cell?
  444. Conditional Formatting
  445. REmid function
  446. skip errors in an average
  447. If a Row is blank
  448. formulas within a work book
  449. Countif & Sumif with Multiple criteria
  450. Insert function
  451. Tracking Date/Actual Working Time Elapsed
  452. 2006 West Coast Excel / Access User Conference
  453. How do I repair broken links that worked with Excel 2000?
  454. Lookup a row and column and return value
  455. SUMPRODUCT WITH A VARIABLE CRITERIA?
  456. Please do not remove "Address" command from Excel 2007
  457. sumproduct with one variable criteria?
  458. Calculate working hours from a start and finish time over several
  459. Helpful New Functions: ALL and ANY
  460. Dependant Data Validation not sorted
  461. formula to lookup value and return value from cell at left of target
  462. CSE formulas
  463. How to switch negative numbers to positive numbers in Excel ?
  464. how do i delete rows that end in SMPT
  465. formula to choose a hyperlink from a cell
  466. Coumn/Row highlight tracker
  467. Flashing cell for conditional formatting as an option
  468. Changing cell colors to correspond to different dates
  469. Unlocking cells
  470. How do I fix loosing 1st digit in zip code in mail merge?
  471. Hlookkup/Match won't work
  472. How do you get the values of the data between data points
  473. I'm going crazy, Excel returns 0 for a simple sum
  474. Upper case text
  475. Worksheet Colour
  476. Need ability to get cell address of max value in range
  477. chart or macro problem
  478. add time
  479. Sum column based on value in each row, if two cells equal, or if date is within time period
  480. Need to sum a column if two cells in row are equal
  481. SUMIF with the Sum_range across several colums
  482. How to display month only for date format?
  483. How to code it in excel?
  484. npv calc for customer pay plans
  485. Automotive 5 Year Depreciation
  486. How do I get speed given time (hh:mm:ss) and distance in Excel?
  487. "Workdays"
  488. Need to write 3D formula averaging total sales between 3 workshee
  489. Selecting different multiple columns
  490. Inserted Comments in published workbooks
  491. After sorting the formula has the incorrect cell
  492. Protecting Cells
  493. Employee Tracking
  494. RE: Text to date
  495. Macro for printing
  496. Re: INDIRECT function inside AND function
  497. Create formula
  498. Need a sorting solution
  499. RE: Using dates as function arguments in Excel
  500. RE: Text to date
  501. Need big help with look up....is this possible
  502. How to attach a photo to Excel
  503. Quote marks in Formulas passed from VB Script in Excel
  504. summing name range in the same column with Dynamic name ranges
  505. Summing unique values
  506. compare data in 2 worksheets
  507. USING EXCEL, delete all text right of the "!" symbol
  508. the total number of "Very Satisfied" questions there are
  509. Data comparison
  510. countif across entire workbook
  511. Previously good formulas wont run. What have I done wrong?
  512. vlookup
  513. Reference previous page
  514. sorting protected sheets
  515. Take out judges scores
  516. Pivot tables hide info drop down menu
  517. absolute value
  518. copy part of a worksheet into a worksheet in the same file/keepi.
  519. F9 Key for totals
  520. Auto Date with Manual Entry Protection
  521. My Excel cols have #s, not letters. How get letters?
  522. cannot sum time
  523. Function to move text >65 characters to next row in column?
  524. Maintain or Lookup Formats
  525. how do you hide SUM(number1,[number2],...
  526. CountIf with multiple conditions
  527. HYPERLINK - insert within a text sentence
  528. Re: Matching two lists
  529. 3 criteria
  530. Functions
  531. How to do formula If a<-.1 and .1, return em dash, otherwise do x
  532. I was asked to change excel spreadsheet to make multiple select
  533. How do I track recurring entries in Excel?
  534. count text strings in an entire workbook
  535. How can I install Excel Solver without the Office 2003 disk?
  536. Help in Excel creating Formula's
  537. will vlookup work for me?
  538. Evaluating One Column To Give A Answer To A Third
  539. Format external data
  540. Database function - convert flat table
  541. SUMIF - multiple criteria in different columns
  542. need to transpose 1422 values from a column to row
  543. SumIf across multiple worksheets
  544. Making cell reference absolute makes cell format text
  545. Loss of dropdown control when publishing
  546. How do I automatically copy data from one workbook to another?
  547. 12 month Rolling Total
  548. Help exiting function needed !!!
  549. Really need calculation help
  550. How do I get Analysis Tools in English
  551. Sheet Names w/ Wrap Text
  552. combining index with max - tried most posted solutions to no avail
  553. How do I update links from a file that hasn't yet been updated?
  554. print preview
  555. Combining two reports into one
  556. formatting issues
  557. A button on one sheet to print other sheets
  558. Sheet Name in Cell
  559. find numbers in a list which sum a total
  560. Sum of a number's digits
  561. Analysis of data
  562. Total and summarise data
  563. Conditional Scenario of Text value
  564. How do I evaluate a row of cells for a character in each cell?
  565. How do I choose multiple items from a drop down box?
  566. Second last number in list
  567. Displaying all numbers as positive
  568. Auto control number
  569. Formatting to show 0 as first number in a cell when input
  570. SUM(INDEX(MATCH) for a range returns different result than SUM!
  571. swapping column info between 2 columns
  572. counta - from 7th cell of a column to the last cell of that column
  573. how do i create a new check box in excel?
  574. how to make an function to list all the same records
  575. How do I link information from a large table into new table
  576. Multi-criteria lookup with Multiple results
  577. how do i merge data from specific cells to different workbooks?
  578. help with setting up dynamic name ranges
  579. How do i sort values like: #103 / 4 / 23, need to sort by 2nd #
  580. Formula Help
  581. Copying Excel Formulas
  582. Re: HELP! Transfering files to Excel
  583. excel formula
  584. Conditional Linking and Formatting across worksheets to form Summary Page - Only pull/link non-null fields
  585. Nested If statements
  586. SUM(IF(multible conditions))
  587. how can I add time in excel to determine how long something took?
  588. How do I keep someone from changing page breaks on a sheet that i
  589. Calculate Number of Months Weeks and Days Between Two Dates
  590. function to give the number of hours
  591. excel formulas
  592. My Excel 2000 Sheet never hides even after I save
  593. How do you add a group of cells by highlighting them?
  594. A formula/function to return a formula/function
  595. Conditional sum matching two columns and a row
  596. Change years to months in loan amortization template
  597. combination functions in one cell
  598. Simplify formula
  599. Problems with IF statement
  600. Underline with accounting format
  601. Formula Recalculation Error
  602. Vlookup - Identify Label - Excel Programming Bug
  603. using wildcards on text
  604. count on multiple conditions
  605. Replacing formulas with its value
  606. Which Function do I use?
  607. Summary counting
  608. I want to go to a specific not named cell.
  609. Array formula and multiplying conditions
  610. Single text file imported to multiple worksheets
  611. calc
  612. Weighted Average in Pivot table
  613. Conditional Formatting Malfunction?
  614. text and formula within the same cell
  615. EXCEL 2000 SINGLE COLUMN OF NUMBERS BREAK INTO MANY COLUMNS
  616. IF greater than Zero
  617. How do I calculate exact difference between two dates in y,m,d.
  618. Selective calculation
  619. How do I combine multiple worksheets into one worksheet?
  620. how I can Check the color of font in excel cell ?
  621. Select the last value from a list
  622. Paste into autofilter selection!
  623. Concatenate
  624. the difference about formula in two accounts
  625. Hiding error message
  626. How can I combine 2 columns into 1, Excel?
  627. HELP
  628. Combining two formulas using concatenate
  629. emailing workbooks
  630. In Excell ,formula
  631. Zero Value Ranked
  632. Complicated Problem
  633. look up formula not returning data
  634. copy cell from above with opposite sign
  635. Data Validation
  636. Naming a cell
  637. emailed content with InDesign or InCopy
  638. How do I center align a title at top of sheet.
  639. How can I count a record if it contains a date within a date range
  640. Day Number For 365 Day Year
  641. excel hyperlink to stock page
  642. CHANGE POSITIVES VALUES TO NEGATIVES
  643. Keeping Text format
  644. Zeros problem in LOOKUP?
  645. Recognizing Cell Formatting To Use In A Formula Or Conditional For
  646. Footer in XL
  647. Looking for Excel SS which calculates Mortgage Payment with PMI
  648. - sign help
  649. Lookup Formula?
  650. Vlookup and Values
  651. Birthday Calculations
  652. Rolling data
  653. Can Excel Adress Envelopes?
  654. OK tough one !
  655. Formula
  656. Format data in History Sheet in Excel
  657. By selecting cells adjacent to cells tally sheet
  658. adding several worksheet cells onto a main worksheet
  659. Unknown number format
  660. No change in result cell
  661. Cell shows formula eg ='Sheet21'!F3 instead of result
  662. How do I take a cell in one worksheet and add it into the formula in a different worksheet in the same workbook?
  663. Inverse Table Lookup
  664. I want to take a date 2006/02/10 & break it into separate columns
  665. In excel missing macro "excelprecedents"?
  666. Count Filtered Visible Items that Match Numeric Criteria between two ranges
  667. Feeds from one sheet to another
  668. changing cell background color
  669. Create macro to filter on multiple criteria
  670. compare two columns within a worksheet, then highlight duplicates
  671. need to merge 3 worksheets into 3 pages. how?
  672. Help w/formula to add 1 year to cell (date done) date due?
  673. Can anyone help, with a formla
  674. finding differences between 2 worksheets
  675. Can I add a percentage formula to an IF statement?
  676. Autofill Formula
  677. with weekly score sheet how do I column a weekly progressive aver.
  678. How do I write formula to conditional format using =if(and(or)
  679. Re: Calculating only non-empty cells...
  680. How do I create chart that show percentages for 1 and 0's?
  681. allow users to edit ranges
  682. TimeValue formula
  683. I want Excel to randomly select a name from a list
  684. how to randomly select a name in a list and then the select the ne
  685. multiple conditions
  686. "MAXIF" Equivalent function in Excel
  687. how do i change a case to proper text in excel 2003
  688. External Data Functionality
  689. Entering Formulas
  690. Entering formulas
  691. multiplication
  692. Run time error
  693. How do you attach tabs to make one page or several pages?
  694. adding cells
  695. How do I conditional format by referencing failure/success?
  696. Compare Two columns
  697. sorting protected sheets
  698. Duplicate entries
  699. Fiscal quarters for two years...
  700. function to change cell position and allows dragging
  701. Result = to 0 says false
  702. cut and paste macro
  703. Using COUNTIF on multiple fields
  704. How do i add a column of values based on another column in excel
  705. COUNTIF by days of week
  706. How do I sort data?
  707. Excel formula
  708. How do I copy and paste a worksheet and maintain all formatting?
  709. formulas
  710. Macro within a function?
  711. No "Sheet" tab exists on Page Layout. Need to print gridlines.???
  712. HOW CAN I SERIALIZE SHEETS IN EXCEL
  713. Looking for a way to summarize data?
  714. Virus error opening all files
  715. Lookup and Replace
  716. Worksheet Link
  717. LOOKUP or VLOOKUP
  718. MATCH?
  719. Referencing a specific number to more general values in a table.
  720. Working night and day..... Timesheet
  721. is it possible to make certain cells required based on criteria
  722. code help please
  723. Resort Column from one with blanks
  724. how do I edit an embedded spreadsheet?
  725. date/time calculation needed
  726. Sumif referring to range names formulas not updating
  727. Offset Question
  728. Conditional formula
  729. Calculating values from multiplesheets with multiple criteria
  730. How do I calculate exact difference between two dates in y,m,d.
  731. conditional formatting
  732. Naming Sheets using a range in another worksheet
  733. formula that writes to a *different* cell?
  734. Sorting data into different format....
  735. Soccer betting excel
  736. Soccer betting excel
  737. Non updatable Unique Random Number
  738. Database Analysis Question
  739. Charity Auction Worksheet. - Copy a row of data - THANKS
  740. how do I get excel to use tab to move in a sheet
  741. COUNTIF for numbers of dates in column which are 30 days older than today
  742. Loan Compound Interest Function
  743. Help with Duplicates
  744. Sharing Info between two workbooks?
  745. Highlighting and tracking changes
  746. Excel adds significant digits, resulting in errors in calculations
  747. Automatically fill info from another spreadsheet?
  748. DES Encryption functionality
  749. Formula Error
  750. delete a # from the value axis on a column chart?
  751. adding numbers that contain ranges
  752. Link from Excel cell to page in PDF
  753. Macro / Bob Phillips if you are out there
  754. Workbook Refreshes For Multiple Users
  755. use formatting from source cell in CONCATENATE function
  756. Dealing with Text in a Function cell
  757. use formatting from source cell in CONCATENATE function
  758. Excel 2003 SP2
  759. SUMPRODUCT returning incorrect result
  760. Excel worksheet formatting
  761. Cell Calculation
  762. Intelligent VLOOKUP
  763. highlight the word when excel finds text you are searching for
  764. User Form: Consecutive numbering
  765. NETWORKDAYS not working
  766. criteria function using max
  767. Time conversions
  768. Combining rows of like data?
  769. Can autofilter sum and average columns of numbers? Thank you
  770. jump to 1st blank cell
  771. Incorporate Laurent Longre's morefunc with Excel xcell05.free.fr/
  772. multiple criteria formula
  773. How can I add functions in excel templates (XLT)
  774. If statement based on currency format
  775. How do I remove a blank separator from a number (like 2 006)
  776. How can I hyperlink from an excel cell to a page in a pdf document
  777. How do I insert alternating blank rows in a list of data?
  778. Function to calculate based on a portions of a number
  779. Tricky Formula
  780. Help with sorting
  781. IF Function (..........
  782. How do I use 3 separate column qualifiers to sum? IF statements?
  783. how do I get rid of blue asterick in create list?
  784. Color Code Date Rows
  785. wildcard characters, can they be used in tables to be searched?
  786. Transfering a formula from one worksheet to another
  787. Count consecutive absences with a limit
  788. Split non delimited data into multiple cells
  789. How do you subtract time as in a timecard to calculate hours work
  790. add cells in several worksheets
  791. How do I create a macro to add zeros in front of a value?
  792. select detail in column B if column A = date
  793. Moving an Excel pivot table to access
  794. Lookup on two criteria
  795. Text formatting
  796. how do i profile a survey?
  797. Picture Disappear in MS Excel
  798. formula {=TABLE(G13;)}
  799. How to convert Arabic number to english text (63 to SIXTY THREE)
  800. Selecting the correct number from a range of cells
  801. Conditional Formatting
  802. Find and Return Numeric Label based on (Numeric Value) Criterion
  803. cut and paste pictures in excel 2003
  804. Find contents of the last cell in a row
  805. Help with formula – too many nested IFs
  806. Avoiding Recalculation for a function in automatic mode
  807. Isolating mailadresses
  808. how do i translate a full powerpoint presentation in one go?
  809. goal seek minimize function
  810. Data validation
  811. Sum in Autofilter
  812. indirect formula help
  813. Pivot table grouping
  814. what is a coupon rate and ytm of a bond?
  815. Excel: have add'l rows entered in sheet 1 always show up in sheet
  816. Date Wont Change in Excel??!
  817. IF or Lookup
  818. looking for assorted statistical excel templets
  819. trying to add up disparate transaction data
  820. Annual percentage return on investment.
  821. Projected annual percentage return on investment question.
  822. Data from two sheets make up real time list in the new sheet??
  823. Adding rows?
  824. Convert 2 digit month to 4 digit years and months
  825. special formatting?
  826. Match duplicate data in 2 columns
  827. FIND PERCENTAGE AMOUNT FOR 5 DEPT. FROM ONE WHOLE AMT XCL
  828. Find and Count Frequency of Numeric Value in Non-Contiguous Rows
  829. Caluclation of depreciation
  830. If statement
  831. Cells are selected but aren't displayed as selected
  832. can a1 reference style and r1c1 style be used in same formula?
  833. I need a formula to do some calculations with time.
  834. make a spreadsheet with diagnal column headings
  835. Help with Excel
  836. Make a cell show the name of the sheet tab
  837. Progressive numbering of Excel worksheets
  838. Creating summary table from detail table
  839. display the cell value in the next 33rd cell
  840. Not listing more than a range of rows
  841. Need dynamic name range in Excel for Outlook interface
  842. Inserting columns & rows in worksheets
  843. Formula
  844. TimeSheet! Working PM to AM
  845. Microsoft EXCEL 2000 Formula
  846. How can I get Excel to print dashes right across a cell
  847. one cell does not reflect a sum
  848. Counting Rows - Fill ???
  849. If then else....
  850. Macro Modification - Bob Philips Are You Out There ?
  851. Shading alternate "groups" of rows?
  852. Sum Function Problem!!
  853. Sorting UK Postcodes
  854. Pull cell format across sheets as part of the fomula? Is it poss?
  855. merging sheets
  856. Record changing cell data into a column or range
  857. Spillting a cel
  858. Superb new financial services. Track and Manage ALL of your wealth
  859. Sumproduct values from two ranges
  860. increment operator?
  861. Amount to text
  862. Adding a % value to a column of numbers
  863. If statements
  864. how to calculate 5‰ of 1250
  865. Calcualtion of renewal
  866. Calcualtion of renewal
  867. Calcualtion of renewal
  868. Data Validation Lists
  869. Return position for each matching value in entire workbook?
  870. Information changes daily
  871. Drop and drag is copying values instead of formulas
  872. How do I count something in one column = to info in another
  873. Subtotal by Account (cash, liability, revenue, expense) in Excel?
  874. Permutation combinations and multiplying them
  875. Field List in Pivot Table Not updating
  876. truncate numbers from millions to thousands
  877. Editing scenarios
  878. Bold
  879. Saving a worksheet to csv with different separator
  880. Re: Formula and or data entry into cell?
  881. Q. How can I change this date
  882. Data from two sheets make up a list in a third sheet (real time)
  883. headers
  884. VLOOKUP RETURN BLANK
  885. how do i copy various sheets date to one sheet in the same excel .
  886. I cannot get hyperlinks set up in Excel 2003 to work in Excel 98
  887. Count Only Empty Cells AFTER Cells with Data
  888. Active range/selection?
  889. Excel Worksheets
  890. IF statement formula
  891. importing SDF
  892. Keeping the format of a date
  893. Not a lottery success with Excel
  894. Selective linking items between two worksheets
  895. Pivot Table Filter
  896. highlight formulas
  897. Attachment files
  898. formula-add 2 numbers of cell a1 and a2 of sheet1 ans-b9in sheet2
  899. Function Arguments
  900. i need the sheetname in my cells
  901. Pull in a colum of financial data based on the month
  902. Nested array functions?
  903. how to set auto protect workbook on exit?
  904. add color or picture to a cell using a formula
  905. Searching for text & counting how many times it appears
  906. VLOOKUP - return 0 instead of "#N/A"
  907. Relinking Pivot Tables to Main Table
  908. linking points
  909. Pivot table with added columns for evaluating results
  910. Hiding a ComboBox with a Checkbox
  911. how do I calculate probability of winning a raffle
  912. What does the "--" do in an Excel formula
  913. How I know if a file is using a custom addin
  914. Excel Web Page
  915. Dynamic multiple-condition array function with more than one name
  916. VLOOKUP - unable to highlight cell range
  917. Calc. Avg. Instead of SUMPRODUCT
  918. Advanced filter formula for "contains="Sept"
  919. Cannot format cells
  920. Average
  921. Possbile for non-contiguous vlookup?
  922. What formula is used to replace blanks in spreadsheet with zeros?
  923. protect worksheets in workbook
  924. My addin in other computers
  925. sum a countif
  926. Can i pull text with a Getpivottable formula?
  927. HLookUp combined with a VLoopkUp...
  928. Formatting for Indian Rupees
  929. Macro help
  930. Search and lookup
  931. nested if statements
  932. Countif from an offset column
  933. Range of a merged cell
  934. Setting up a worksheet for LOG LOG analysis
  935. Countif using criteria in multiple columns
  936. Function question
  937. ???
  938. This is DRIVING ME INSANE!
  939. Time Calculation
  940. Formatting for and adding thousandths of a second
  941. Getting Sums of Values
  942. Three questions on hyperlinking and conditional formatting
  943. I have tried & can't get rid of the decimal point in an Excel
  944. aging of invoices
  945. Analyze Survey Questions
  946. SUMPRODUCT
  947. Creating and editing scenarios
  948. Fill down formulas in cells to the LEFT of external data range?
  949. Two Formulas for One Cell Using IF
  950. How to Delete Rows in Excel In a Do Loop
  951. USING DATA VALIDATION ACROSS SPREADSHEETS
  952. Formula for calculating a running balance up to a maximum limit
  953. Ignoring error values in a formula
  954. How can I add numbers such as 1.5R + 2.5R?
  955. change Excel column headings from numbers to alpha characters
  956. how do i assign a value to a cell containing text
  957. How to get a formula result in a "whatif" situation
  958. Repeating a sort
  959. Borders
  960. Creating Id
  961. Serial Numbers converted to text string
  962. what is the formula to convert 5513 seconds into minutes 00:00:00
  963. Replacement of Testdirector( Test Managment Tool -Mercury Interact
  964. Truncate within a cell
  965. How do I formate cells in excell to show inputed date as 09/13/
  966. check for repetition of cell contents
  967. how do i enable multiple entries in the same cell under a label?
  968. array product formulas
  969. enter a value, excel pulls information and places in new spreadshe
  970. Formula request
  971. How do I copy a formula from one work sheet to another?
  972. I can not find the list command from the data dropdown menu?
  973. Information from one column then filtered(?) from another
  974. How do I prevent rows from duplicating when sending a worksheet?
  975. Formula help
  976. VLookUp or HLookUp Plus Index - Match, I think???
  977. cell fill color not showing
  978. Looking for a formula to calculate date intervals
  979. counting records
  980. I want user form to display when opening a work book
  981. remove figures from a cell without removing the formulas
  982. Chart
  983. Updating Linked Excel Document
  984. how can you insert a picture in a protected excel file
  985. Can I nest Max in HLOOKUP?
  986. Insert Multiple Page Breaks
  987. Best source for instruction on using "ifthen" formulas in excel?
  988. Average with more than one IF statement
  989. IF-AND-OR?
  990. CommandButton in Excel to open another Application
  991. functions derived from cell contents
  992. how to auto "copy & paste" (or filter) from a Master spreadsheet?
  993. When I do an @sum, is there anyway to make the sum a constant ?
  994. table data
  995. Summary of data - multi sheets
  996. Search and Replace
  997. How do I format text in a label in Excel?
  998. Can something like this be accomplished?
  999. Copy function
  1000. Calculations using a start and end date: