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. A formula to filter data and copy it from one worksheet to another
  2. VBA language question.
  3. AND function?
  4. How can I sort or search the sheet tabs?
  5. How do I match up two tables of data with one column in common
  6. how do i make negative numbers equal zero
  7. Dsum date based on selection of months
  8. Parameters question
  9. Round to up to a threshold
  10. SUMPRODUCT, SUM(IF(...), or some combination?
  11. How can I check for dupes in more than one column in excel?
  12. change tab colour when using conditional formatting in a cell
  13. Rearranging Data Within a Cell
  14. How to determine color of a cell?
  15. Default to zero currency value
  16. Create a List by formula from other data
  17. Vlookup formula criteria
  18. PLEASE PLEASE INDEX MATCH OR SOMETHING ELSE ??
  19. Dividing hours to give days
  20. How do I prevent entering duplicate numbers in an excel worksheet
  21. Hyperlink using a variable destination
  22. Lookup multiple values return one value corresponding value Excel
  23. REVERSE SINGLE CELL TEXT STRING
  24. Whats wrong with this OR formula?
  25. add numbers in different cells , but ignore cell with #VALUE! to t
  26. Unhide and hide columns
  27. Excel formula for golf score to handicap
  28. How to change column pixels to the standard size?
  29. if, then formula with conditional formating
  30. > and < for Array Sumif ({})
  31. Standard Colors
  32. sumproduct and average functions
  33. 2 Workbooks and 6 Worksheets - Need to Populate 1 Workbook
  34. Is it a formula or a number in cell
  35. aging
  36. I need to repair an invalid hyperlink
  37. IF Function doesn't recognize TRUE
  38. Index / Match
  39. Adding sheets to workbook
  40. Count
  41. How do I link a drop down list to other worksheets
  42. Viewing customised menu icons o PC that they weren't created on
  43. Formula in macro or in sheet/cells?
  44. How to Input date & Time [NOW()], then stop it updating?
  45. EDITING TOOLBAR MAIL MERGE
  46. my mouse pointer locks on a cell in excel
  47. Excel Conditional Formating using 'like' or wildcard logicals
  48. Excel Conditional Formatting color multiple cells for 1 logical
  49. How to split Cell content into two resulting cells
  50. send data to another cell auto
  51. how do i highlight a date that is 4+ days old in excel?
  52. How do I dedupe 2 files in excel
  53. create a random list of names from a list of names in EXCEL
  54. Formula too long - new file path is shorter than old file path - Excel 2003
  55. Function across multiple worksheet
  56. Counting Unique Values
  57. Anyone know how to display iterations from solver?
  58. Changing cells in solver.
  59. reference with variable row number ?
  60. Life Feed character
  61. return a number from a cell based on the lastest date
  62. Rounding up entire column so each item will end in .99. How?
  63. Counting Worksheets, Second Verse
  64. Logarithmic Retail Markup Worksheet
  65. how do i move a row of cells when they're fully complete?
  66. how do I set up the following formula in excell.
  67. Microsoft Excel Formula Help
  68. How can I change 0's in the data set to do a LOG with base 2?
  69. how to format a cell to display October 21st, 2006
  70. Whole number from fractions
  71. Excel 2003 SP2 computes the power of a negative number wrong.
  72. SUMIF
  73. addin for analysis tool pak for excel 2003
  74. Return across Row Numeric Values Matching EXACT Month & Year for Criteria
  75. counting numbers not formulas
  76. Adding Time
  77. USERS - NESTED IFs
  78. automation autosave .xls as .txt
  79. Look up function best place
  80. CONDITIONAL FORMATS
  81. FUNCTION STABILITY
  82. How do I find more than two digits at the same time?
  83. IF statement for time based data
  84. match, lookup or array?
  85. CountIf should work across sheets
  86. exel help
  87. HELP ABOUT FUNCTIONS
  88. Data Matching Button for MS Excel 2007 or later
  89. Excel Date Format
  90. search for Index+average in threads
  91. How do I write the IF function to reflect the result in one cell?
  92. Need help with Email Code (PLEASE)
  93. Function is displayed as text rather than giving a value
  94. Can I use INDIRECT.EXT for this?
  95. VB in Excel
  96. BIFF - Help!! lookup numbers in multiple columns and return one nu
  97. How to return value from functions in other sheets?
  98. Date formating
  99. Date Range displayed in header
  100. how to split abc123 into abc 123?
  101. Can you enter a function or format to add a row to a work sheet?
  102. in Excel: how can I make excel count 5 as 15 (5+4+3+2+1)
  103. IF statements - use to insert/delete rows?
  104. Formula for Increasing a Cell Reference by a Given Number
  105. Standard Colors
  106. Excel 2003 - How to display 761000 in a cell as 761
  107. 256 ways to make hamburger
  108. Return Numeric Values Matching EXACT Date for Criteria
  109. Index with 2 arrays returns error
  110. @ROUND
  111. Excel lookup in multiple areas
  112. how to determine if a series of numbers contain odd or even values
  113. vlook
  114. SUMIF for Multiple Criteria
  115. Help with MATCH function
  116. How to Define a named Formula at the Worksheet level?
  117. how do I have a cell that does the date plus 7?
  118. Match Offset by more than one value
  119. Named Formula reference problem
  120. Alter Duplicate Product ID Entries
  121. delete part of text from a cell
  122. I am trying to add time, 10:15 + 15:30= 5:45, could you help
  123. CHECK BOX ALIGNMENT
  124. VLOOKUP Between Sheets
  125. Automatic closedown of Excel 2000 after a period of activity
  126. Viewing customised menu icons on at
  127. Formula that references another reference
  128. Convert decimal to fractions
  129. Finding a vlookup table
  130. Cell Formating
  131. Function that returns symbols as formula result eg up/down arrow?
  132. Vlookup and datamatching
  133. Return Result If Number Is Within Range
  134. conditional formatting help
  135. my excel worksheet printout not straight
  136. Conditional formatting
  137. Matching Data in Excel 2002
  138. Alpha Numeric tab not showing only numeric.
  139. Create a "cell button" to hide selected cells.
  140. my excel printout not straight
  141. More conditions
  142. Using SUMPRODUCT...
  143. countif in many worksheets
  144. Cell reference in vlookup not working
  145. Check if 2 cells match on another sheet then lookup value
  146. =IF(Form!$B$2="B6",Form!$B$5," ")
  147. Hiding rows
  148. highlight dups in one of two columns
  149. Worksheet disappearing
  150. Return True/False to check duplicate items in a range with one for
  151. Formatting the color of a range of cells based on the value of one cell
  152. Sum for multiple criteria
  153. How do I add cell values using conditional criteria?
  154. Conditional Formatting
  155. Highlighting Cells
  156. Simple Calculation within pivot table
  157. finding earliest date within a range by employee
  158. how can I create repeating horizontal menus
  159. moving a row to a column
  160. Figuring time worked, and then separating it into regular time an.
  161. CELL ADDRESS
  162. how do I turn off automatic spelling correction
  163. How do I count frequency based on 2 criteria (including month)
  164. ranking problem
  165. Count within pivot table
  166. How to pick data from different sheets conditionally?
  167. Excel 2000 pivot HELP!!!!
  168. how do i link up 2 sets of data into 1 set of data in excel
  169. Weird format to formula transition excel 2003
  170. Using the current row in a formula
  171. HELP COUNTING
  172. Nexted if()s are limited to Seven What other functions can I use?
  173. Function error
  174. date function
  175. How do I get Excel filename using a single keystroke
  176. Using the "IF" function (I think)
  177. Help with creating a search engine in excel vba
  178. IF function which can find a blank cell
  179. How do I 'Add-In' Hex2Dec formula?
  180. Macro for reformatting cells
  181. Creating a List of Loan Periods Dynamically
  182. What graphing technique can you use to show correlation
  183. to reverse a column
  184. VLOOKUP
  185. Simple Formula Help
  186. IF statement problem with IMAGINARY
  187. Check box formatting
  188. I wish to group my worksheets under group tabs
  189. Max conditional formats in a spreads...
  190. Record Counts
  191. Cell variable in formula
  192. Macro help
  193. average low 10 of last 20 entries
  194. Removing Text
  195. Export Conditional Formatting Values
  196. XL2003: Count formatted cells (not coloured)...
  197. "Delete" greyed out
  198. Entering date and time with a formula
  199. hide duplicate addresses in Excel
  200. SET A COLOUR
  201. separate a Capital starting word from a sentence
  202. SAveAs worksheet
  203. Name of worksheets in one worksheet
  204. delete a word from end of a text
  205. Using SUMPRODUCT to count values in separate columns
  206. How can i split combined number and text in excel using formula?
  207. Hyperlinks in Excel
  208. Calculating age when person born before 1900
  209. Please help with SumIf
  210. IF Statements (Mutliple Statements)
  211. Recording Time & Date based on data input
  212. Wireless Network Use
  213. lookup or countif
  214. Separating invoices by invoice date then summing by quarter
  215. conditional formula
  216. Please put a remittance advice template online
  217. INQUIRE FOR SOLVER CIRCULAR FORMULATION - money wizards
  218. Excel 2000 - Autofilter Limit
  219. Assign auto numbers based on a condition
  220. sumif() using range name
  221. How do I return the curser home
  222. index and match on 2 largest value
  223. Using COUNTIF to search for existence
  224. insert data
  225. how to keep the total colum
  226. How to use SUMIF function with non-adjacent cells
  227. excel 2000 - array formulas
  228. Extract duplicate rows to another worksheet
  229. Timestamping a cell with a Link already attached to it.
  230. how to access a cell value in a different workbook. HELP!
  231. Search a FAQ file
  232. Macro question
  233. attaching an image to Excel spreadsheet cell
  234. SUMPRODUCT help
  235. how can i apply labels (or category names) to columns?
  236. index,match - how to avoid same lookup when duplicates present
  237. Civil/Survey/Structural/Costing Engg Templates Available
  238. Is it possible to protect multiple worksheets at the same time
  239. Finding maximum qty of items to reach given limit
  240. Changing Mailing labels from rows to columns
  241. Conditional IF to use or / and
  242. Button to sort a range, and sorting 12 columns
  243. Greater Than but Less than
  244. Multiple If Statement
  245. Show Cell Reference
  246. Inserting data between cells
  247. Excel: Having more than 3 conditional formats would be helpful.
  248. Need additional help
  249. Text to column and selecting values based on a different column
  250. Frequency Function question
  251. Adding time data
  252. what formula to get total from two different columns
  253. Lists referencing lists...is it possible?
  254. How can I set the column that excel returns to when I hit Enter?
  255. How to do multiple IF checks with dates AND text
  256. Rounding Time?
  257. Copying a formula with a pattern
  258. How do I get GETPIVOTDATA to work?
  259. inserting lines throughout a spreadsheet
  260. Text to column and selecting values based on a different column
  261. All text disappears when wrap text in excel is used
  262. Display a value between certain dates
  263. Can you cell reference for the title of the worksheet tab?
  264. Find a value in a table and return the cell reference
  265. Find cell reference in an column of numbers?
  266. Importing from Access
  267. Why are some imported cells changing to zero?
  268. How to get Solver to target array rather than cell?
  269. Formula Auditing Arrows Not Visible
  270. Help with negative number please
  271. Autofill Formula
  272. How to give access to certain cells in the protected worksheet ?
  273. "save as" in Excel
  274. Can an Excel workbook number sheet pages sequentially?
  275. OR in a SUMPRODUCT formula
  276. Refer to a Single cell in a name range
  277. Excel: Is it possible to count the number of "yes" answers?
  278. SUMPRODUCT to establish whether turnaround date was achieved
  279. Sorting by date order
  280. paste locked cells and unlocked cells in protected sheet
  281. Alt+F4
  282. Hiding formula
  283. comment
  284. Lookup across columns
  285. Lookrow
  286. how to get the doted printing area as default
  287. Unable to Add Values
  288. Help with Vlookup
  289. Multiple Consolidation Ranges in pivot tables
  290. Cell colors or text color changing when date in cell gets closer.
  291. calculate the difference between negative and positive values
  292. Lookup problems
  293. Adding "0" as leading digits into cells in Excel
  294. combine cells date time
  295. Match Function
  296. How do I number columns based on adjacent cells?
  297. Using Index to Transpose, Update Reference Cells as you Drag Down
  298. Sorting Right to Left
  299. Option button and Highlighting an area
  300. excel: monthly download of 1000 members, need to update quickly
  301. Cell contents changing to date and not date
  302. locate and SUM values from LOOKUP rows?
  303. wild cards in SUMIF
  304. How to get the leading zero's added in a document
  305. Nested IF function
  306. Set Print Area
  307. web query in Mac...
  308. GETPIVOT DATA HELP - PLEASE!!!!
  309. Sum totals based on product name
  310. if less then zero put zero if greater then zero state number
  311. Stop an in-process subtotals calculation
  312. VLOOKUP results displays ##### in some. Why?
  313. Avoid special characters
  314. compare different workbooks
  315. Relating cells
  316. keyboard shortcut for switching between worksheets??
  317. How can I have have one column's input depend on the variables in a second one?
  318. Ways to fix the problems of MS Office 2007 Beta 2 Technical Refre
  319. Want to find "2006 QTY" & insert 3 rows...
  320. working with multiple worksheets
  321. number of spaces...
  322. I want to sort by month, date, year. Birthdates. How do I do it
  323. Shared workbook and print formatting.
  324. How to find the most recent date in a column based on other column
  325. read only alfabethical
  326. rounding formulas
  327. IF statement
  328. IF OR functions
  329. how do I 'shadow rank' a number into a field it isn't a part of
  330. Can I stop Excel auto entering GETPIVOTDATA functions into formula
  331. Create 52 sheets and carry all formulas and figures forward?
  332. Sum in list
  333. How can i color the fonts
  334. how can i convert a value quoted in hrs,mins,secs to just mins
  335. Links in Excel not good anymore after upgrade
  336. Countif array formula
  337. CAN'T INSERT SYMBOL?
  338. How to have Excel cells return age (Y/M/D) based upon DOB
  339. Format cells to display ordinal numbers ex 21st
  340. Int Iserror Len Mid Find formula
  341. I need more than 8 IF functions
  342. Damnit. I need SOLVER.
  343. How do I set up a multiplication table using formulas?
  344. get file name inside a macro on Excel
  345. Need a Function
  346. Problem calculating percent change
  347. Counting Help
  348. Summing vlookup cells
  349. Force Excel To Treat A Cell As Blank
  350. Display negative results
  351. what is the formual for calculating running pace?
  352. Sorting Ranges of Data
  353. Program Buttons in EXCEL
  354. sequential numbering across multiple worksheets
  355. Copy from a Cell to a text box.
  356. WORKSHEET NAME = CELL REFERENCE
  357. WORKSHEET NAME = CELL REFERENCE
  358. Set tab
  359. Set tab
  360. Get final non-blank cell in range
  361. Vlookup with If Statement
  362. I want to duplex a workbook
  363. Why can't I use more than 3 conditional formats per cell?
  364. Formulas
  365. Filtering Multiple Columns
  366. Excel Sheet Timestamp
  367. Algebra
  368. COUNTIF with multiple conditions?
  369. Vlookup question.
  370. VLOOKUP help!
  371. COUNTIF question
  372. Formula
  373. Counting number of instances before a certain date
  374. Select certain values in a field, then drag it up to lock it in
  375. SUMPRODUCT with 3 arrays not working
  376. Repetitive Data in Excel
  377. change the check in check box
  378. convert a value to a text incl apostrophe within the cell
  379. How to hide/unhide sheet Tabs in Excel 2007?
  380. calculate time
  381. Worksheet protection
  382. Max of % nembers in column WITHOUT counting dates
  383. Lookup in Two Columns, Help needed with formula
  384. Pasting a URL or search info unto EXCEL Internet query
  385. Dynamic tabs
  386. multiple answers
  387. how do I set up a validation rules with two data rules
  388. how do i keep running ytd salary totals?
  389. LOOKUP ( )
  390. Add one until 171 is reached
  391. Finding volume per hour
  392. Finding volume per hour
  393. How do I automatically zero out a cell when another cell changes
  394. Combining two or more drop down menus
  395. How do I get a normal curve in Excel with values 0-200000?
  396. How do I set up a daily analyasis of cash handling of employees
  397. excel remake whit shadow all the row where i am edit
  398. Complex Analysis
  399. track employee on daily shortages of money
  400. Merging text from 3 columns to create a URL
  401. how to show the same calculated column total to multiple spreadshe
  402. calculation of Determinant of a matrix
  403. Matrix multiplication using sumproduct
  404. Formula results inconsistent.
  405. How to roll up columns or rows for summary purposes?
  406. Don't want to constantly update Random numbers
  407. countdown updating
  408. HOW DO I ENLARGE THE FONT ON A DROP-DOWN LIST
  409. need formula help
  410. linking worksheets into a pivot table
  411. Auto sum with maximum value in a cell. Please help!
  412. Auto sum with Max Totals in Cells. Please help!
  413. Auto sum with Max Totals in Cells. Please help!
  414. Mac vs Windows
  415. Does EVALUATE( ) still exist in V. 2003?
  416. =OFFSET(!$A$1,,,,) - global range naming
  417. Frequency Formula
  418. Create Month Timetable on a worksheet different month each works
  419. compare and take out duplicate data
  420. spin boxes
  421. how do I count only lower case "x" and exclude upper case "X"
  422. Drop Down List
  423. Complex lookup
  424. Need to set up interest tracker in Excel
  425. Crash when inserting a template
  426. Can I use a macro to autofilter in excel
  427. Conditional average of time
  428. Naming Areas on Worksheet (Excel 2002)
  429. Is it possible to convert numeric figures in to words like (1,200.
  430. ISNA help
  431. SumIF problem
  432. how do I disable the option that keeps incrementing cells by 1?
  433. I want to count the highest number of equal cells
  434. extend formula when data is entered
  435. I am not able to extend formulas to successive rows
  436. Inserting day with date automatically - how?
  437. Can I use a macro to autofilter in excel
  438. Adding up whole dollars only
  439. find last value in list
  440. show the last value in a list
  441. Concatenate a reference to named ranges in other workbook
  442. rowwise query
  443. Save AS
  444. SUM, COUNT and SUMPRODUCT
  445. Merging cells on a protected work sheet
  446. How do I create drop-down list boxes from multiple lists/headers
  447. FORECAST function in simple terms, plz...
  448. NETWORKDAYS
  449. how can I count if column A="active" and column E="Job"?
  450. how can I count if column A="active" and column E="Job" in a list?
  451. Format Painter Error
  452. Moving Macro's to Citrix
  453. copy formla that refers to another worksht down
  454. merge list while removing duplicates
  455. Formula needed to create grand totals
  456. How do I insert rows in more than one worksheet at a time?
  457. How to change color of cell as dates pass
  458. What does "Too many cell formats" mean?
  459. Workdays Formula
  460. Prompt message when opening a file
  461. Prompt Message when opening a file
  462. Show +/- totals in formulas in green vs. red colors
  463. Can you count the number of cells that are highlighted in a column
  464. COUNTIF
  465. "SHEET TAB FONT SIZE"?
  466. Can anyone help with this tough question? Format Conditional
  467. Imputting an angle degree. Degree, minute, second
  468. Tab name in a cell?
  469. Worksheet formula problem - serving sizes!
  470. Daverage function with rows instead of colums.
  471. How do I find a macro in a worksheet?
  472. Cut and Paste entire row from one worksheet to another
  473. Use of $ symbol while writing a formula?
  474. Cut and Paste entire row from one worksheet to another
  475. How do I delete only part of the data in a row of cells?
  476. Which worksheet function would I use?
  477. hyper links stop working
  478. Report function?
  479. Combined Cells
  480. does excel that a dynamic "slide" feature for IRR calculations
  481. does excel that a dynamic "slide" feature for IRR calculations
  482. inventory control
  483. Date format from excel to CVS file wont. Change in CVS wont stay.
  484. Help me parsing Data and Organizing
  485. Conditional Formatting
  486. Vlookup formula with a twist
  487. Conditional Formatting
  488. ?
  489. SUMIF Non-Continuous Range
  490. Is there a formula to figure mortgage APR in excel?
  491. HOw do I use Track Changes and Macros together?
  492. Calculate a SUMIF if criteria is between 2 date ranges
  493. Excel Formula Question
  494. Cut / Copy Paste to F2 Cell for MS Excel 2007
  495. Formula Question
  496. what formula do I use to make a color in another field
  497. vlookup question
  498. How can i sort data according to the color of the background?
  499. Data Validation
  500. Data Validation
  501. Change part of string to lower
  502. I want to merge data from 2 different workbooks
  503. What IF - formula question
  504. What IF - formula question
  505. Find last Sunday
  506. Change from mixed caps and upper lower to all upper lower case
  507. convert number to hh:mm
  508. How do I remove a text character from an excel cell?
  509. Display date when worksheet last updated?
  510. HELP ME!!!!!
  511. HELP ME!!!!!
  512. Time calculation
  513. Reference closed files in formula
  514. Reference closed files in formula
  515. Decimal function
  516. how do I expand collapsed rows in excel
  517. what IF - formula question
  518. change the width of a specific cell
  519. Macro To Change a Formula to A Value
  520. unable to read file
  521. LookUp Problem
  522. how do I create a probability distribution in excel?
  523. How do I perform multiple formating within a single line of text?
  524. Filtering slows down a macro
  525. Count if on Single Criteria with multiply conditions
  526. How do I set a column to list entries in Alphabetic order?
  527. fx shows correct value but not cell
  528. Date Format "stuck"
  529. Date Format "stuck"
  530. Date Format "stuck"
  531. Help with Formula Reference Point
  532. Calculate how many customers take SKU's
  533. PPMT & IPMT
  534. sorting in excel 2003
  535. Tab Naming
  536. Tab Naming
  537. Tab Naming
  538. Referencing data using the SMALL function
  539. Changing the form of a name
  540. Can I create an entry form that will feed a data sheet
  541. macro
  542. VLOOKUP Help
  543. Counting the number of Worksheets in a Workbook
  544. Format Issue
  545. Calculate call cost in seconds
  546. I cannot edit cell borders or text in certain cells.
  547. Auto Calculating in the same cell
  548. If Statement with VLookup
  549. Paste Special Formula
  550. need help with excel formula
  551. How do I remove "VSync" in Excel windows?
  552. sorting on a date field
  553. Variable Addresses in Links
  554. Conditional formatting - mutlple formats
  555. Using a certain cell based on the value of another cell
  556. How to type 123 & have it print 1.23 without using Options..edit?
  557. Removing dashes from ISBN's while still keeping 1st number (zero)
  558. Random number generator
  559. How do you convert decimal in to numbers
  560. IF Statement???
  561. COUNT MONTHS
  562. How do I use a variable in a sort macro
  563. List Formatting Lost
  564. Lookup on multiple criteria and max
  565. Remove Civic numbers in Street Address, move to previous blank cell
  566. Pulling data from grid
  567. Excel data comparing
  568. How to transpose formulas from column content to row content.
  569. Counting and Suming based on multiple criteria
  570. No autofill VLookup function
  571. Find the RANGE in MOUSE CLICK
  572. formulas do not copy to destination cells, but as existing totals
  573. Writing Macro with easyfilter
  574. COUNTIF with wildcards
  575. Total weekly wages by month
  576. Counting conditionally formatted cells
  577. Total Date data entries by Month
  578. Sometimes formuli in workbook don't auto update with auto-recal on
  579. how can i make invoice numbers seqential in 2000
  580. Editing scenarios
  581. How do i get the last position of a char (space) in a string?
  582. Finding a link source.
  583. Designing a spreadsheet to track workflow
  584. Designing a spreadsheet to track workflow
  585. Count unique items in range
  586. Referencing Across Sheets Based On Condition
  587. Problem with format function in excel VBa
  588. vlookup
  589. Where can I get a ODCB driver for Microsoft query?
  590. no scroll bars or tab sheets
  591. Re: Excel
  592. Excel should return feature of highlighted cells as totals
  593. How do I add together time and hours in Excel?
  594. count errors
  595. Date Formulas
  596. Question about using VLOOKUP with Data validation
  597. View, scroll and select a cell value from another Excel sheet?
  598. arbitrage
  599. If Statement + LEN
  600. If Formula
  601. Workdays Function
  602. error when refreshing pivot table
  603. How to enter data in one form & populate several others w/same.
  604. My discovery on DATEDIF and leap year
  605. Formulas
  606. formula to sum the prior 12 cells regardless of added columns?
  607. Hiding worksheets based on user selection
  608. Linking statements between spreadsheets
  609. Why does blank text equal > 0?
  610. Formulas spontaneously convert to numbers
  611. Troubleshooting "Fill Down/Right" with a formula
  612. char(160) - &nbsp;
  613. Annuallize and Continuous Percentage
  614. Opening sheets
  615. I am looking for help on how to create a specific formula
  616. named dynamic range that ends with first text entry
  617. How do I set viewing passwords for worksheets in excel
  618. Automatic Links in Excel
  619. How do I find the average time?
  620. 3D function with dynamic reference
  621. drop down box
  622. formula rounds differently in 2 spreadsheets
  623. Count of Number Values Greater Than, Less Than
  624. VLOOKUP - or a better solution
  625. Can I sort a list to match a previously existing order?
  626. How do I maximize a workbook within excel 2003 that was created i.
  627. Sending Email through a macro
  628. Total all instances of an entry for analysis
  629. "variable interest rate"
  630. conditional formatting date
  631. Count unique entries...
  632. sales chart
  633. Excel 2000
  634. how can I average more cells only in a column by a criteria?
  635. How do I assign a formula to an entire column?
  636. How do assign formulas to an entire column?
  637. Target cell coloured based on whether one cell has a greater value
  638. Formatting a cell with colour based on whether another cell's valu
  639. Tricky question with grouping and sorting
  640. Adding data from multiple rows
  641. format addresses
  642. format addresses
  643. Filtering Problem
  644. Sorting Question
  645. automatic sorting
  646. Excel
  647. formaula used to abstract portion of a cell to another cell
  648. GROUPWORK IN EXCEL
  649. EXCEL: Protect a cell depending on another cell value
  650. chart automatic update
  651. Product Selection order form
  652. Why MS Excel produce diffrent result for the function "Quartile"
  653. How do I create a certain type of Excel formula?
  654. Tab order with check boxes
  655. combining 2 excl wksht together top w/bottom different column widt
  656. Formula doesn't work this morning, but worked for 2 years now
  657. SUMPRODUCT formula challenge
  658. How should I get the # of quarters in a year.
  659. creating drop down lists from source on another page
  660. formula is too long
  661. Need Formula Help Pls
  662. How to use months in formula.
  663. How to reference C5, D5, E5 from sheet2 in A1, A2, A3 of sheet1?
  664. spellnumber formula in ms excel
  665. conditional formulas
  666. Office table autocalculating ?
  667. I am not able to apply names in already created Vlookup formula.
  668. Extract text string using MID
  669. Shortcut key strange behaviour
  670. Hide Combo Boxes
  671. how to score replies
  672. VLOOKUP Function
  673. Linked cells from master data sheet and sorting
  674. how
  675. extract " " space from middle of a string
  676. Dynamic territory list
  677. Matching 2 figures if not =0 rtn true
  678. selecting cells without certain value
  679. Comand line or Vb
  680. Formulas
  681. worksheet function for aggregating information
  682. Named Ranges
  683. How to stop creating an new email msg when I click on a data cell
  684. merged cells and hyperlinks
  685. Spreadsheet to compute the swing weight of a golf club...
  686. How do I return the vale of multiple cells into a single cell
  687. Count only if another column has data in Pivot Table?
  688. Identify by color border the cells in a formula
  689. Perform a "Conditional Substitute/Replace"
  690. Protecting a Shared Workbook
  691. spreadsheet to work my wages out.tax and insurance
  692. How do I get my column titles to print at the top of 2nd page?
  693. First initial + Last Name in external imported data
  694. calculate age from 2 dates in yy,mm,dd format in excel
  695. calculate age from 2 dates in yy,mm,dd format in excel
  696. Conditional Formating with a formula referencing other cells
  697. SUMIF problems
  698. Following in one cell. Need separate cells DE SOTO, TX, 75115, US
  699. Change font colour for whole row
  700. How do I sort multiple names within one cell?
  701. Why won't the text wrap expand cells when the pages are secure?
  702. Time Lapse Calculation
  703. Using axSpreadsheet
  704. Excel problem: Cant hide column.
  705. Rounding
  706. data changes when entered into a cell
  707. Edit created worksheet function
  708. How to Prevent Duplicate Data from inputing using input application?
  709. Index match formula works in for one worksheet reference but not another
  710. Re: IM ASKING FOR DONATIONS FOR HEART SURGERY
  711. Vlookup beginning with 3, 4 or 5 specific values
  712. How do I apply conditional formatting?
  713. covert 72.8 to 72:48
  714. Conditional formatting for shared worksheet?
  715. Calculating a sum with running total and replacement
  716. store inventory sheet(ex:sports equipment store)
  717. remove -, keep 0 in phonenumber
  718. replace - by blank, keep 0 in phonenumber
  719. WB Not Calculating Automatically
  720. Shortcut key strange behaviour
  721. Use of Paste Special - Operation
  722. Disgusting cross-post
  723. Concatenate
  724. Trying to MATCH a value out of a cell on an ARRAY - help pls
  725. How do I copy data range of the same name to another tab?
  726. Fire Macro from Cell Change
  727. I need to recover a spreadsheet.
  728. hide values and display a decimal point that fills the cell
  729. Re: Retrun "" (blank)
  730. CTRL+SPACEBAR
  731. COUNTIF in a range (and parts of cells)
  732. combining data from two worksheets
  733. How do I combine two EXCEL columns?
  734. Increasing the Source Data range for an existing Pivot Table
  735. How do I display both a sum total and an average in pivot table?
  736. Function for missing data in a series?
  737. Countif
  738. Counting occurances in one column if another col. meets a certain
  739. Sending information from one worksheet to another
  740. IF Function
  741. Can I make array position A(12) into a variable A(12*n) ?
  742. How do I display text in the data field of a pivot table?
  743. compare and combine data with in one workbook
  744. sumproduct help
  745. Combine data - Please help
  746. Loop thru rows to copy to another excel spreadsheet
  747. date format
  748. date format
  749. Sum Cells with colors
  750. Sum Color coded cells
  751. how do i count how many times x in column a = 1 or 2 in column b
  752. Dynamic file referencing?
  753. Putting columns back in alpha order
  754. First negative number
  755. Page numbering dilemma
  756. copy select characters from specified cells.
  757. Read how to two-way link cells, now can't find the example!?
  758. My autofilter is dimmed in one worksheet only in Excel 2003 how d.
  759. enter formula once for entire column
  760. excel worksheet tabs to be organized vertically in outline format
  761. Linking worksheets
  762. if statements
  763. deleting unused space at the end of a worksheet
  764. Formulas with conditions
  765. Formula
  766. formulas
  767. #ref error with Sumproduct
  768. Returning text using a formula
  769. Looking up previous data in column within an IF statement
  770. Range Names & Auto Fill
  771. navigating between worksheets
  772. Navigate between worksheets
  773. auto sum
  774. Excel formula - should this be a macro?
  775. vlookup to include text
  776. any way to tell the last day of the month? when the month is a var?
  777. Cell contents in header/footer
  778. Determine next Saturday based on a given date
  779. Out of memory. Why?
  780. WORKDAY() Function Equivalent with SUMPRODUCT()
  781. Feedback and Suggestion on MS Excel 2007 (Beta 2) Worksheet Functi
  782. Tournament Template?
  783. How do you save an excel file to be read as IBM-type text file ?
  784. Need statistical help
  785. Extracting information from large worksheet
  786. How do i add up every other coloumn in a linked sheet
  787. how can I count (countif) the character: *
  788. generating dates
  789. I NEED HELP!
  790. Need help with complicated Vlookup, or possibly other function
  791. Box Plot in Excel
  792. need Excel cell to show value, not formula
  793. Formulas stop calculating
  794. Using IF based on an LEN field
  795. Find > Replace Textual Values across entire records
  796. Assign Macro
  797. how do i automate an index function with a data table
  798. How do I combine five Excel 2003 workbooks?
  799. Dividing range of numbers automatically
  800. Dynamic reference to another tab name
  801. Macro for TEXT and DP
  802. My discovery on adding months and days to a date!
  803. how do i sort rows and maintain cell references
  804. how do i sort rows and maintain cell references
  805. Excel
  806. Chart data won't accept text functions in series name
  807. how to copy same percentage to complete worksheet
  808. getting data from a database into a form
  809. DECIMAL function
  810. too advanced to do? or can u help me??
  811. Pulling info off a list from another sheet
  812. calling up information from a different worksheet.
  813. Convert columns to rows
  814. Excel should have a QUARTER formula for DATE calculations
  815. how do i use LOOKUP and AND function
  816. timevalue function
  817. How do I sum values in a row if the value in a row above = text
  818. How do I enter a cell value into the Timevalue() function?
  819. cannot enter correct numbers in cells
  820. Can an Excel logic function change the color of a cell or text?
  821. Colour cell when number changes
  822. Force overlap of cell wen row is full, how to?
  823. Can I use a different worksheet for my database using DSUM?
  824. How to make and ADT tree of a table
  825. Excel Formula
  826. Removing a hyperlink when right click doesn't open shortcuts?
  827. I cannot remove a hyperlink (mail to) in a cell
  828. Sum Question
  829. One of lifes little mystery?
  830. 2 workbooks but how to update - MS Excel ?
  831. Vlookup or Hlookup Uses for my 2 workbooks
  832. how to use the argument funcation
  833. how to add rows
  834. Sumproduct help
  835. Vlookup Question
  836. How do I jump from the 1st worksht in a workbk 2 the very last
  837. How to Show month as text??
  838. How do I query a List to generate source data for a chart?
  839. How do I transfer data from multiple sheets to one without pasting
  840. Multiple Conditions within an IF Function
  841. Index Match
  842. Need A Guru Please! Click on Cell - Go there
  843. Text and Today() function in VBA
  844. Sumproduct problem...
  845. Lookup, Sum or Calculate
  846. Formula involving a letter that has to have a numeric value
  847. automatic unhide when editing problem
  848. Search and Copy
  849. number of cells
  850. How do I use auto sum with hidden cells?
  851. Auto Update validated list wording?
  852. Auto Update validation list?
  853. Percentages
  854. If statement
  855. Can you protect a sheet so that no one else can print, only view?
  856. Converting feet to yards within a column
  857. hyperlink problem
  858. Index and match
  859. format/concatenation
  860. Change date to number
  861. How do I go from read only to full access worksheet
  862. Formula for: If b6 is > or = to 8333 then b6 should be 8333 HELP
  863. What is the right approach?
  864. Download Excel?
  865. delte multiple blank rows in excel
  866. Alert date
  867. Sum formula
  868. Sum formula
  869. Splitting appointment records in to 15 minute time bands
  870. Subtotal problem. Very strange!
  871. increasing a cell by 1
  872. Searching for multiple strings and return multiple solutions
  873. How do I use conditional formatting to colour rows of data?
  874. conditional format max
  875. Help!
  876. why does this formula have to be entered as an array formula?
  877. How do I keep my cell reference from moving even when I use the $.
  878. Copy/Paste Rows
  879. VLOOKUP and IF
  880. IF & VLOOKUP
  881. 1000 to 1 and 1 to 1000
  882. count unique with mulitple criteria
  883. Formatting subtotals?
  884. enter ~ in spanish name
  885. Setting default number of iterations within ALL my excel spreadshe
  886. number of iterations as default
  887. Nested Ifs
  888. How do I delete Connectors?
  889. Formula Formating
  890. Re: Formulas will not calculate
  891. how can i subtract AAAA1234 - AAAA1220?
  892. I want a formula to list months, from any given month, forward
  893. How do I calculate cells without losing the milliseconds?
  894. Excel If statement that is supposed to return a "" instead returns a 0
  895. Testing for sig. differences between percentages in Excel
  896. end - start less one hour for lunch
  897. need a formula for this scenario
  898. copying conditional formats (2007 Beta)
  899. Looking for a way to search for specific text across columns
  900. while printing multiple worksheets and stapling
  901. Copying data based on a condition
  902. Using the "Fill" function
  903. Solver Problem Definition
  904. How to format date cells, Excel template Project scorecard matrix
  905. vlookup issue
  906. Insert description into own Formulas
  907. If & and problem?
  908. FIND VALUE IN COLUMN
  909. custom views
  910. how do I count occurrences of multiple conditions
  911. my spreadsheet is too far up on the excel screen and I cannot cli.
  912. lock a font in an order form
  913. Range Matrix
  914. OFFSET oddity
  915. IF and VLookup
  916. function results shows 0
  917. numbers in text format
  918. If A1=dog or A2=cat in wrkbk1 sheet1, then copy row to wrkbk2 shee
  919. Months are being duplicated in a conditional if statements
  920. Nested "IF" Statement
  921. Array formula
  922. Finding the last unused row in a column
  923. can you assign two formulas in one cell
  924. sumproduct range question
  925. how do i calculate inverse tan?
  926. "IF" Statement Problem
  927. "IF" Statement Problem
  928. how to concatenate operations
  929. WOrkday function - change working days
  930. SUMIF and LEFT and Named Ranges
  931. SUMIF and LEFT and Named Ranges
  932. SUMIF and LEFT and Named Ranges
  933. "No more new font may be applied in this workbook"
  934. Remove single quote
  935. SUMIF or SUMPRODUCT to total cells containing multiple texts
  936. move between worksheets using the keyboard
  937. display 1 line of multiple worksheets into multiple lines on 1 wks
  938. How to find cells containing exact text, and separate them
  939. Networkdays function doesn't find true difference between two dat
  940. subtotals
  941. Formatting of numbers in a cell on another sheet
  942. Text & Date Formatting
  943. if=0 then n/a if<0 leave the value in the cell
  944. vlookup, match? what do I use?
  945. how do you calculate compound interest with multiple payments?
  946. formulas
  947. Automatic update of date once, then remains static
  948. Error when using Indirect
  949. "Make a table"
  950. Divide the total in one cell into up to 6 others
  951. Excel-only average cells if two cells in same row, meet two condit
  952. Sumproduct wildcard or "all" condition
  953. How do I not show certain Letters in a range of cells in excel?
  954. How do I use a linking formula in cell with many words?
  955. I have a date 51231 (2005,dec,31) -I want to change to 2005/12/31
  956. convert dollars to pounds using a lookup formula
  957. How do I hide a row in excel if a certain other cell is populated
  958. What formula do I use to add totals between workbooks?
  959. copying workbooks
  960. Conditional format if cell match found in another range of cells
  961. Can you use CountA to add multiple items within one cell?
  962. VDB Depreciation Question
  963. COMPARE TWO COLUMNS AND GET THE VALUE IN THIRD COLUMN
  964. Shortcut toggle between worksheets in the same workbook?
  965. Still need help: filtering data bewteen worksheets
  966. Control Sheet
  967. Match function problem
  968. sort alpa descending 'cell size' error
  969. How do I make the 1st column constant in viewing a wide spreadshee
  970. Min Max What's Wrong?
  971. How do I convert from Euros to USDollars? It's not in EUROCONVERT
  972. Spreading 1 large number evenly into several cells
  973. Creating a Warning window
  974. Copying a region in excel results in the entire worksheet being pa
  975. cell format question
  976. How do you set up range names, name formulas
  977. seperate a value in a text string
  978. How can I color only subtotal lines in Excel 2002?
  979. Help! How do I copy/paste formulas without automatic progression?
  980. adding like items from different sheets
  981. Running total within a cell
  982. Need help with LEN? function
  983. Ability to arrange tabs in a worksheet in chronological order
  984. Moving to Previous Worksheet
  985. Formula for comparing a date to today's date
  986. Using INDEX function to return array row.
  987. embedded presentation graphs in excel don't update, tables do
  988. Show forecast accuracy of customer schedules as a percentage
  989. view value instead of formula
  990. Vlookup/Match/Index/Small - I think
  991. Weakness in the Drag Function of Excel 2007 (Beta)
  992. View formula result instead of formula
  993. URGENT HELP PLEASE
  994. Scales
  995. help needed urgently
  996. Median array formula
  997. Comparing Data from two excel sheets!
  998. Automating Polynomial Order Selection in Linest
  999. Sorting by Sections Problem
  1000. Reporting using PivotTable