View Full Version : Microsoft 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 90 91 92 93 94 95 [96] 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131

  1. Counting Worksheets, Second Verse
  2. Rounding up entire column so each item will end in .99. How?
  3. return a number from a cell based on the lastest date
  4. Life Feed character
  5. reference with variable row number ?
  6. Changing cells in solver.
  7. Anyone know how to display iterations from solver?
  8. Counting Unique Values
  9. Function across multiple worksheet
  10. Formula too long - new file path is shorter than old file path - Excel 2003
  11. create a random list of names from a list of names in EXCEL
  12. How do I dedupe 2 files in excel
  13. how do i highlight a date that is 4+ days old in excel?
  14. send data to another cell auto
  15. How to split Cell content into two resulting cells
  16. Excel Conditional Formatting color multiple cells for 1 logical
  17. Excel Conditional Formating using 'like' or wildcard logicals
  18. my mouse pointer locks on a cell in excel
  19. EDITING TOOLBAR MAIL MERGE
  20. How to Input date & Time [NOW()], then stop it updating?
  21. Formula in macro or in sheet/cells?
  22. Viewing customised menu icons o PC that they weren't created on
  23. How do I link a drop down list to other worksheets
  24. Count
  25. Adding sheets to workbook
  26. Index / Match
  27. IF Function doesn't recognize TRUE
  28. I need to repair an invalid hyperlink
  29. aging
  30. Is it a formula or a number in cell
  31. 2 Workbooks and 6 Worksheets - Need to Populate 1 Workbook
  32. sumproduct and average functions
  33. Standard Colors
  34. > and < for Array Sumif ({})
  35. if, then formula with conditional formating
  36. How to change column pixels to the standard size?
  37. Excel formula for golf score to handicap
  38. Unhide and hide columns
  39. add numbers in different cells , but ignore cell with #VALUE! to t
  40. Whats wrong with this OR formula?
  41. REVERSE SINGLE CELL TEXT STRING
  42. Lookup multiple values return one value corresponding value Excel
  43. Hyperlink using a variable destination
  44. How do I prevent entering duplicate numbers in an excel worksheet
  45. Dividing hours to give days
  46. PLEASE PLEASE INDEX MATCH OR SOMETHING ELSE ??
  47. Vlookup formula criteria
  48. Create a List by formula from other data
  49. Default to zero currency value
  50. How to determine color of a cell?
  51. Rearranging Data Within a Cell
  52. change tab colour when using conditional formatting in a cell
  53. How can I check for dupes in more than one column in excel?
  54. RE: How can I check for dupes in more than one column in excel?
  55. SUMPRODUCT, SUM(IF(...), or some combination?
  56. Round to up to a threshold
  57. Parameters question
  58. Dsum date based on selection of months
  59. how do i make negative numbers equal zero
  60. How do I match up two tables of data with one column in common
  61. How can I sort or search the sheet tabs?
  62. AND function?
  63. VBA language question.
  64. A formula to filter data and copy it from one worksheet to another
  65. Lookup value in table
  66. Copy a table from a web site, then manipulate the data?
  67. 5 minutes intervals
  68. matching two worksheets and return to different value
  69. Need to color 1 record of each set of Duplicate Records
  70. add text in a cell to trigger a calculation
  71. annual growing rate formula or funtion needed!!
  72. Formulae Help, should be easy...
  73. Possible to keep a macro seperated from a sheet?
  74. hyperlink to .png file
  75. Change Tab colour using Macro
  76. =IF(B1,"",SUMPRODUCT(--(B$1:B$5=""),--(A1<A$1:A$5))+1), Biff formula
  77. Hyperlink mailto - ref cell for mail subject
  78. what does { and } mean in an Excel formula?
  79. Criteria for datbase function in one row?
  80. conditional format range set-up in Excel 2000
  81. Unique list of entries
  82. What is evaluate formula?
  83. HOW TO ASSIGN NUMERICAL VALUES TO LETTERS IN EXCEL
  84. Can I increase the length data from a formula in a cell?
  85. Passwords in macros
  86. measure calculation time for multiplication of two matrices
  87. How do I count rows within a cell?
  88. Lookup Tables
  89. How do I summarise what I want....
  90. Need to Color Record in Duplicates
  91. advantage of Database functions
  92. Count months away betwwen a strat and end date by month
  93. Cell to cell hyperlinking does not work, please help
  94. Warning message if one column contains any text and another column is blank
  95. Counting multiple values within single cells
  96. Keep cursor in 1 cell
  97. Extract Symbol
  98. Calculating time increments from dates during working hours
  99. How to make userform work publically with hidden sheets?
  100. Multicondition If with And function (TEXT)
  101. how do I caluclate return on investment, compounded quarterly?
  102. Worksheet function: last saved date
  103. meaning of : IF(Switch; Average(array A, array B); array A)
  104. Formula Help
  105. Excel VBA bug?
  106. copy unique data
  107. sequential number code
  108. Function within a function?
  109. Forecast using 2 data sets
  110. Is there a way to name tabs so that they will ascend in order?
  111. Reforecast budgets
  112. Column label ref in formula
  113. How to search a column that is not the first of the table
  114. Keep non-duplicates only
  115. find number in multiple columns and rows
  116. autocomplete in dropdown list in Excel as I begin typing
  117. Fill color not functioning in newly installed version of excel.
  118. copy workbook files without losing data that was in the org. work
  119. NETWORKDAYS
  120. total the column anyway
  121. Multiple criteria for lookup table
  122. How do I set up a "Random Number" button in Excel?
  123. how to create a if statement, if true turn colour
  124. I need an amortization schedule with the first 6mo no payment?
  125. standard deviation
  126. Excel Formula
  127. Calculate time within time
  128. if statements in sumproduct formula
  129. Amortization with up front skips
  130. sort subtotal groups
  131. DAILY WORKSHEET
  132. 16.36 convert to 16:36 (min:sec)
  133. how to reposition the dataset from top to bottom in a column?
  134. MAX, IF statements?
  135. How to print the circles in formatting audit circle invalid data
  136. pivot table, grand total no negatives
  137. Isolating single row based on date comparison
  138. COUNTIF says Null = Blank but Blank <> Null
  139. Transposing 4-row clumps of name and address in Column A to Columns A,B,C,D
  140. Countif worksheet function frustrations
  141. I Need a Formula to return a zero value
  142. WEEKNUM() Question
  143. time diffrence with 24 hour clock
  144. sum a column
  145. Copy
  146. Check if result is an integer?
  147. copying formula
  148. parse comma separated text to multiple cells and remove duplicates
  149. how do I create a football team syndicate?
  150. Excell function
  151. Add-in function - language
  152. Variable external data through a Microsoft Query
  153. why is the INDIRECT function volatile?
  154. extract first name only from full name
  155. Lock/Unlock cells
  156. Easy for the experts: Lookup,index,match....
  157. Merge/Combine address lists
  158. Finding descrete valuse
  159. Lock cells, but still be able to trace
  160. How do I merge 2 workbooks by comparing one column
  161. VBE Geeks in Volatile Functions
  162. Is it possible to sort or filter data by color of the field?
  163. if a condition is met I want an x in a cell
  164. Excel formulas
  165. Correlating items from 2 different spreadsheets
  166. Using a cell to reference sheetname in vlookup function
  167. SUMPRODUCT formula - help!
  168. How I do protect linked information if the link source is deleted
  169. Cascading macros to new workbooks
  170. find string within other string
  171. using "&" in the header (not date autofill)
  172. How do I insert a symbol as part of a formula
  173. SumIf - More then 1 criteria - Please assist
  174. check for two blank cells before populating a 3rd.
  175. Find and Replace ROUNDUP(stuff, 0)
  176. copy and paste
  177. Cell formatting
  178. How to format a cell to only allow multiples of a number
  179. look up multiple values, to return only one value
  180. dynamic range name
  181. Help picking a random number from a given distribution
  182. How do I import multiple e-mail addresses from website to excel
  183. converting julian dates
  184. SUM
  185. PivotTable - Where have the units/records gone?
  186. Lookup with Variables
  187. search/delete duplicate entries in excel '02?
  188. Calculations in Pivot Table
  189. Creating an algebraic substitution for use in formulas
  190. Excel pull data based upon one specific word between two date
  191. make heading stationairy
  192. countif within array
  193. Find Many String options in ONE String
  194. Conditions in sumproduct
  195. Calendar/Date Calculations
  196. running balance using split cells
  197. PLEASE HELP!! # of Nested If's - Have 7 but Excel Still Won't Acce
  198. Reading the Latest Value into a cell
  199. how to add a record to a pivot table
  200. Pivot table with more than 3 columns
  201. how to amend pivot table structure
  202. How can I format cells with data that meets certain criteria?
  203. Can you make a checkbox larger?
  204. what are the columns (1 2 3) which appear right of line # column
  205. OTHER EXCEL FUNCTION COUNTER SOLUTION ?
  206. Date
  207. probability density function
  208. can macro edit text?
  209. using indirect throughout a sheet
  210. Formula For Summarizing Data
  211. Ordinal Numbers
  212. How can I stop csv files converting 19-05-53 to 19/05/1953
  213. Multiple if senerio
  214. how to search a word in a excel file which appears twice
  215. Tie a Calendar week to a Scoped Projected Week
  216. =IF(AND Function
  217. How can I link and deduct one cell from a budget in another?
  218. two dimension look up table
  219. IF month and day match, then...
  220. Determining AM or PM in text string
  221. show only the subtotals and grand total in a pivot table
  222. HOW DO I ROUNDUP A RESULT OF A FORMULA TO NEAREST WHOLE NUMBER
  223. How to make negative numbers to become 0?
  224. Arrays fonctions
  225. Don't change cell content in Excel by dragging
  226. IF statement with a range
  227. Page Numbering
  228. How do I find data in separate worksheets and normalise?
  229. IF formula question
  230. Excel headings
  231. separating data in columns
  232. Formula That Totals Extracted Values
  233. Rounding Up
  234. VLookup in to columns
  235. how to change formula into value exel cells
  236. Vlookup w/sum?
  237. =IF((F6="C06"&G6="A"),E6,0) both F6 and G6 are true
  238. How To in Excel
  239. Cannot start the source application for this object
  240. SUMIF (embedded if???)
  241. password protect multiple spreadsheets in a workbook
  242. Viewing Funciton Arguments
  243. Retrieving data from another table or array ..
  244. how do I create a Date field format for mm/dd/yyyy (10 digits)
  245. Setting up a formula HELP
  246. SUMPRODUCT
  247. How do i create a template that will only allow Times New Roman?
  248. How do I accomplish this?
  249. IF function? Moving the same info from one worksheet to another.
  250. What is this symbol?
  251. In Excel, can Boolean logic be applied to conditional formatting?
  252. GETPIVOTDATA used with a central pivot table - values vanish
  253. Help with 2 formulas together
  254. Excel should let me sort by highlight color.
  255. Take a Cell and add it to the Footer or Tab
  256. Dates, Years and Seasons
  257. getting a degree symbol (celsius) in each cell
  258. How do I select the last alphanumric word in an excel column with.
  259. How to make IF function not change cell value?
  260. convert 28:55 (mm:sec) to 28.92 (mm.mm)
  261. sum cells compare cells
  262. looking for a lookup function
  263. How to calculate portfolio returns over different periods of time
  264. DateDif Problem
  265. How to caclulate porfolio returns over different time periods
  266. Removing Data
  267. how do I create a link for both content and format of the cell?
  268. How do I find and replace null values in Excel 2002 worksheets?
  269. Conditional Queries?
  270. Trunc/Pmt Different Results same formula same sheet
  271. Excel equivalent of sql group by count
  272. FirstName, LastName and vice versa
  273. Workbooks run on foreign language computers
  274. Sorting by Two Columns
  275. Excel Problems
  276. how to get zero befor no. means eg 065 in excel
  277. flipping a spreadsheet
  278. New to functions, 'If' isn't working for me
  279. Drop down boxes
  280. Sudoku hints
  281. Locked Cell - can still edit
  282. how can i transfer fourmular results as a value in a second formu
  283. Vlookup with #N/A
  284. Mathematical Problem
  285. APR - RATE Function
  286. How to create link b/n Excel worksheet (cell) and Word document?
  287. I need an Excel formula for converting hours to days?
  288. Quick help needed...
  289. How can I put Goal Seek into a cell formula?
  290. I need to link check boxes to 3 different cells
  291. excel sort problem
  292. Error 1324 during installation of addtional components
  293. match two cells from one worksheet to another
  294. Help With Dynamic Range
  295. How create my own Funtion
  296. Quick Question
  297. Transposing
  298. INSERT HORIZONTAL PAGEBREAK AFTER EACH LINE IN ENTIRE WORKSHEET .
  299. text wrap
  300. How do I get drop down pick list comments to appear over selection
  301. bottom sheet tab disappears
  302. where is the search/replace command located
  303. Adding +1 to a text
  304. Summing across Worksheets
  305. Question on setting up excell to solve a math problem
  306. Calculate with or without Symbol
  307. Auto refresh
  308. Can you make a tab entry form in excel like you can in word
  309. Using the VLOOKUP Command
  310. Advanced Filtering is Unavailable
  311. Embedded Reference
  312. How to change cell reference within formulas
  313. Embedded Reference
  314. convert string to date & time
  315. DSUM when database is part of a pivot table
  316. Copy Paste issue
  317. Link "page-by" drop-down in two pivot tables
  318. Type set amount of digits in one cell then automatically move to n
  319. A challenge: referencing cell contents in nested function formula
  320. Modify a Macro
  321. Convert a range to a 2sequence of numbers?
  322. Concatenate Problem
  323. SUMIF - Sum_Range is misleading
  324. Sorting on a protected worksheet in Excel 2000
  325. Employee Time Sheet
  326. EXcel 2007 - Unable to sort by font and cell colors
  327. APPROXIMATE SEARCH OF ANY ENTRY IN A COLUMN
  328. Topic did not show up?
  329. sum of cells until reach empty cell
  330. How to concatenate 3064 and 01 with 306401 as a result?
  331. Help - saving files
  332. List in a cell
  333. total schedules
  334. table data
  335. analysis
  336. In Excel fill & font colors not working
  337. Outlining in nested subtotals not working
  338. how do i get to top of excel page it seems to be missing
  339. Custom Cell Formatting
  340. CHAR(10) = ALT+ENTER??
  341. CELL ( )
  342. Make merged cells a feature that can be used in a shared workbook
  343. excel vlookup not working correctly
  344. I have a master spreadsheet, how do I create a copy?
  345. can excell convert a file from 'works'?
  346. Re: check for duplicate numbers
  347. How do I caculate 24 hour military times
  348. Formula Help
  349. Average if
  350. Calculate date 28 days from now if hours reduce
  351. Move curser to specific cell when closing
  352. Formatting columns with either a date OR a numerical figure
  353. TEST FOR EXACT TEXT
  354. Pivotable Columns
  355. How to write a quote formula using only the cells selected with va
  356. SUM and IF statements
  357. Using the "Count" function with filters?
  358. Calulating the number of days an employee works
  359. How to retrieve last date and amount from columns?
  360. RE: formula needed for this one...
  361. Re: formula needed for this one...
  362. change the calendar to reflect the current year
  363. change the calendar to reflect the current year
  364. Sumproduct error
  365. Text vs Number format
  366. Make Custom Macro always Available
  367. Summing cell totals across columns
  368. 2 different ?'s: Date? Macro?
  369. UK Postal codes in Excel
  370. Formula to count numbers
  371. average values in non-contiguous cells, ignoring 0 values
  372. Pulling data
  373. Writing a Marco
  374. Linking Sheets
  375. Format Cells - Hyperlink
  376. Can I set up a default footer that will appear in every spreadshee
  377. Macro problems
  378. Importing local OLAP cube in Excel 2007
  379. Excel math formula
  380. Can i set up tabs within tabs on Excel?
  381. Lookup and change to italic italic
  382. Sorting a Soccer PointsTable
  383. Link
  384. lookup on Table including blanks -
  385. Formula Too Long
  386. Re: Alphabetizing in Library Format
  387. vlookup on 3 different tables - please HELP
  388. copy formula every x rows
  389. Use custom format to add text to a text entry.
  390. "Magic" Formula
  391. Matching Quarters
  392. Quarter Dates
  393. index_match_error!
  394. formula for counting
  395. How do I get items from sheet 3 to show up on sheet 1 and 2?
  396. weighted scores
  397. How do I make JUST the header row always visible in Excel?
  398. Tracking Check Boxes
  399. conditional formatting error message
  400. refresh option of pivot table not working
  401. SMALL() on unknown length of list
  402. go to last filled cell in a column shortcut
  403. How to set up an excel formula to copy cells to another worksheet?
  404. "Replace" problems
  405. How on Earth do I use the GHK Function?
  406. Last entry in a column/row function?
  407. entering same formula in multiple sheets
  408. Formula works but formula shows in cell???
  409. IF across multiple worksheets
  410. Is there a Way to Find the Cell Row and Column From my UDF
  411. formula that sums cells yet does not round the number up or down.
  412. Quickly Review Data
  413. Yes and No
  414. auto input
  415. Drop Down List choice selecting another drop down list
  416. look up sequential cells
  417. How can I concatenate a number and preserve the formatting?
  418. MATCH FUNCTION AND SERIAL DATE CONFLICTS
  419. When I open a file in excel, I cannot open any of the sheets
  420. Help with SUM and IF
  421. text box
  422. Auto e-mail message
  423. How to concatenate an array of four stings using formulae (not UDF)
  424. Fv
  425. FV Calculation problem
  426. convert time functions to numbers
  427. Read only files? Lost tabs on worksheetstoo!
  428. cannot paste link using equal sign
  429. Any macro experts out there?
  430. Worksheet naming using visual basic
  431. Text to rows...at wits end
  432. Send e-mail from a Excel file
  433. Filtering using Formulas
  434. Stop Excel from evaluating formulae unless I want it to
  435. How do I selectand copy only subtotals in a sheet
  436. Maximum length of a number
  437. Splitting cells - please help!
  438. Move data
  439. Date Interval Predictions
  440. Format Date
  441. How do i calculate the saved amount ?
  442. Conditional formats using more than 3 conditions
  443. Show input box with cell value
  444. How do I calculate Return on Investment in Excel
  445. How do you protect Headers and Footers in MOFFICE
  446. How can I get a cell to Flash if it meets a certain criteria in Ex
  447. MATCHING DATE TO A WEEKDAY
  448. cancelling getpivot formula when setting formula outside pivot ta.
  449. Advance Sumproduct calculation
  450. Excel Group & Sum function
  451. Can the contents of a drop down box differ from what's entered?
  452. Match cells with cells on another workbook
  453. Looking up a value from one cell in another range of cells
  454. how to change the insertion point color?
  455. Soundex converter formula?
  456. How do I seperate a full name field out into three seperate columns?
  457. I need to add check boxes to my Excel spreadsheet,checked and not
  458. NULL Cells
  459. BackFill Zeros
  460. COUNTIF
  461. Same page with Different Page numbers
  462. use track changes and macros
  463. Referencing another worksheet via a cell
  464. Help please - looking for a formula
  465. Count cells in a column that has a autofilter
  466. Lookup and summing comparison
  467. how can i capitalise text in an existing workbook
  468. How to create Cascading Drop-Down Lists?
  469. Filling values in a grid
  470. Date determination and sums
  471. lotus 123 worksheet function conversion
  472. How can I use Excel to mark student's tests?
  473. Restricting a Spreadsheet so users cannot save changes
  474. Sumproduct value error
  475. Restricting rights to save a spreadsheet
  476. Array formula with a constant?
  477. Need help with COUNTIF
  478. Counting cells with multiple data
  479. Looking Up Datas when Key Values are Identical
  480. Find String in another string - only between spaces
  481. countif Column A and excule column B if it's cancelled
  482. how to use GETFORMULA() in EXCEL 2003?
  483. Function Key for Calculating Average?
  484. Does anyone know if there is a symbol for the "except" in formula?
  485. SUMPRODUCT, COUNTIF and wildcard
  486. vlookup returns bad data
  487. How to switch position of columns and rows respectively?
  488. Wildcard character inside sumproduct
  489. Ask user for information
  490. Auto Navigate Cells
  491. Array Fromula
  492. text box linked to cell
  493. Worksheet, selection macro
  494. Eliminate second browse box when right clicking for hyperlink
  495. percentage completed and colors
  496. Hi--how do I scramble a list randomly?
  497. Help - Looking for a Sumproduct formula
  498. Not getting messages in OE
  499. How do I get Excel to open email for single sheet?
  500. How do I set up for greater than 3 formats in excel?
  501. Drop down dependency stuff
  502. how can I multiply number of hours and minutes by hourly rate?
  503. cell value<>presented value
  504. I need conditional formatting to apply to maximum %
  505. Re: Formula to subtract values in one cell only...
  506. Re: Formula to subtract values in one cell only...
  507. MORE THAN 8 IF CONDITION IN A FORMULA IS NOT ACCEPTING
  508. How do I work with swedish excel 2003 that uses EDATUM
  509. how do I write an IF/other statement to cut off time data?
  510. Is there an easy way to find/display merged cells in excel
  511. Resize the Check Box ActiveX Control
  512. How do i protect specific cells in a shared workbook?
  513. Can COUNTIF be nested to search two ranges
  514. Sumproduct question
  515. Combining two work sheets using a column in both as a key
  516. How do I change hyperlink targets in a group of fields at once?
  517. Get count for a table of dates
  518. how to apply the same header or footer to all sheets in workbook
  519. How do I use the (=) symbol for cut/pasting in excel?
  520. in Excel, how to put gridline every ten rows
  521. Vlookup
  522. Fixing a Total on a page
  523. Change the "Insert Function" display for mail merge
  524. SUMPRODUCT
  525. Excel won't calculate formulas unless I press F9 - HELP!!!
  526. Paste Special Not Working
  527. combining text and numbers in a string
  528. How do I create a unique spreadsheet reference?
  529. show current value
  530. MIN function
  531. Repeating an Excel Formula
  532. Finding how many events since last occurence in a database list
  533. using IF statement to compare text
  534. How to link a cell in date format without displaying it as 0-Jan?
  535. Conditional Formatting on one cell based on value in another
  536. Searching a range with MS Query
  537. Sumproduct(N and --
  538. N/A
  539. How do I get excel to sum a range without including hidden cells?
  540. Simple excel question for newbie
  541. Link Excel to Access
  542. INDEX/MATCH Functions with row-arranged table.
  543. Calander in Spreadsheet
  544. lookup function, returning the same format.
  545. Warning text triggered by values of a cell range
  546. Offset.
  547. How do I fill mutiple cells with one pull down menu?
  548. putting a number that is greater or lesser into different cell .
  549. Need help in formula - IF + Find + Vlookup
  550. Adding rows without the links moving
  551. Automatic Update of Dropdown List Box data
  552. Restricting Duplicate Entry
  553. smart tags
  554. Add sheets using macro
  555. IF function
  556. Countif Limit
  557. each number in cell should be 10 digit
  558. Excel 2003 Functions
  559. About workbook_Open madro
  560. grouping
  561. Hyperlink Problem
  562. do not copy data to another sheet if exists
  563. function
  564. EXCEL
  565. Auto Fill from Drop Down list
  566. Factoring
  567. Re: Formula to calculate 401(k)
  568. protecting formulae!
  569. SUMPRODUCT + CSE
  570. IF Then HELP!!!!
  571. VLOOKUP problem
  572. drop down box
  573. VLookup does not work with "("
  574. Text Function
  575. Pivot Table Conditonal Format of the Grand Total
  576. Vlookup with 9E+307
  577. Hiding Specific Rows Based on Values in Other Rows
  578. Copying Formulas From One Column To Another??
  579. Pasting data with hidden columns
  580. HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL
  581. date
  582. EXCEL formula
  583. Generating random numbers with the occasional outlier
  584. Why are my formulas not adding up automatically
  585. How to copy rows that meet criteria to another sheet in Excel
  586. Rounding results by ranges
  587. how do i change row font color based on cell value in that row
  588. Calculating Mode for multiple arrays based on criteria in another
  589. dynamic vlookup?
  590. How to ALWAYS have footer automatically?
  591. Conditional Counting
  592. need help
  593. How do I change fraction to fraction characters?
  594. using nested OR
  595. I'm trying to import fields from one Excel file to another
  596. Can't Access Paste Special Anymore
  597. Most resource-hungry functions?
  598. How do I lock/protect cells so they can't be changed
  599. Create mutli-level subtotals
  600. SMALL(IF( across multiple worksheets
  601. Create a function to calculate Mean time Before Failure
  602. Paste is acting up
  603. Dates That Change
  604. Count Non-Blanks in one column based on criteria in another
  605. Time difference - again!
  606. need scenarios function to running MPS for production planning
  607. SUMPRODUCT- double unary vs. *
  608. Formula Help Needed
  609. entering a matrix that contains formulae
  610. how to do matching 2 criterias
  611. How do I copy and move selections of data to other sheets?
  612. Command Button
  613. Excell Macros
  614. Calculations based on cell value
  615. how to set column check
  616. Date To Quarter, Plus Next 3 Quarters
  617. automatic passage to next cell
  618. relative reference when creating a link to another workbook
  619. Driver Hours Of Service
  620. help on indirect()
  621. Excel 2002 - Internet Explorer Windows opening up uncontrollably
  622. Excel 2002: Merging cell content with a comma seperattor
  623. In excel can we prevent the column width from change
  624. If statement
  625. Excel File Double's in size?
  626. MSNQuotes.Function Add In
  627. Enter text and formula in a cell
  628. how do I make excell show time values greater than 24 hrs?
  629. Is there an "Appear Behind Text Function in Excel" for a picture?
  630. Numbers not adding together correctly
  631. Conditioning??
  632. Return a value
  633. Parse an email address
  634. Parse an email address
  635. If lower, highlight
  636. I want to hide values if no data in target cell
  637. Use Excel to randomly generate selections for cyle counting?
  638. Formula to detect color?
  639. Grouping with a pivot table
  640. how do I put in the IF function only integer as true values?
  641. End of Year
  642. How do you represent a=t1+t2 divided by t3+t4 in excell
  643. formula for text string
  644. Formula to extract a specific word from text string
  645. IF THIS AND THIS BUT NOT THIS!?!? HELP!
  646. 12 Month Average
  647. Find and replace numbers using a formula
  648. Worksheet function?
  649. Re: Columns to rows
  650. flaging items as "org","dup",etc.
  651. Help with Custom View
  652. Tip(s) from Excel User Conference
  653. Finding multiple values of a function
  654. How do I calculate within a range?
  655. Problem with VB string character limit.
  656. How do I show only the last portion of text in a multi line cell?
  657. How can I change 080402 to 08/04/02?
  658. ADD AN ITEM IN A FORMULA ONLY IF IT IS A NEGATIVE
  659. How can I paste a worksheet to an other program through a HYPERLIN
  660. Rounding Up in Cells With Formulas
  661. Major Goof, I deleted data HELP
  662. Conditional Format & Formula
  663. selecting using option buttons in excel
  664. Has anyone a template for a surveyors field book
  665. Excel not recognizing equal values
  666. lowest number in a set EXCLUDING zero
  667. excell search function
  668. Jump to next cell after selecting from drop down list
  669. Is there an easier way to pull URLs out of Web Query?
  670. HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE
  671. Is there a better way?
  672. How do you calculate text into numerical answers?
  673. selected extraction of cell ref in a series of cells in a row/colu
  674. How do I make a spreadsheet w/ original price and then %?
  675. Protect Sheet but allow sorting
  676. creating formula help
  677. Changing hyperlink addresses (global)?
  678. looking to create a time + text history when a button is clicked?
  679. how to collectly put data in each cell from magnetic card reader data
  680. Lost all my worksheet tabs on excel
  681. How to count occurrences where 2 columns are required to be true?
  682. Sum Cells Based on Condition (2 problems)
  683. NEWSGROUP QUESTION URGENT
  684. NEWSGROUP MESSAGE URGENT
  685. Compare
  686. Make Function ignore 0 and error values
  687. How do I prevent saving an excel file if cells are blank?
  688. Sum a range of cells starting from an offset date list from TODAY()
  689. Add sum of cell from another worksheet
  690. Counting
  691. sumif with 2 condtion
  692. Lost my built in menu bar in excel 3
  693. VLOOKUP weirdness
  694. Displaying trendlines in legend (or not)
  695. automatically move cell data in 1 workbook to another workbook
  696. Is there a way to change Lowercase or Proper to ALL CAPS?
  697. Evaluate a column and extract last value
  698. #N/A
  699. adding quotations / brackets
  700. Delete rows that are empty across columns
  701. User form problem
  702. to recover deleted work sheet from file
  703. How to skip the blank cells for calculating StdDev?
  704. Simple VLOOKUP problem
  705. I want to get remaining text after using LEFT function
  706. How to skip the blank cells for calculating StdDev?
  707. Ongoing help with dependent drop down boxes
  708. Display the source for a pivot table page field
  709. conditinal If statement with 3 outputs
  710. Create formula in VBA
  711. Generate random number from a list
  712. Help finishing array formula!
  713. Cell reference
  714. What if delete sheet is whited out?
  715. Can you write your own NETWORKDAYS function?
  716. Creating a Vendor ID from Vendor Name...
  717. Find Numeric sign in a string
  718. Any way to shorten this up?
  719. AutoSum
  720. count entries
  721. use field data from 1 pivot table in another?
  722. use field data from 1 pivot table in another?
  723. Using macro to select a range
  724. Lookup Function Referencing cells, not text values
  725. I was trying to protect a worksheet and my outlook tool bar is loc
  726. Weighted average question
  727. Getting #VALUE
  728. delete worksheet
  729. How to input 'Used time' data ?
  730. Nest vlookup within large function
  731. sumif in Excel2007 on Vista doesn't work.
  732. Automatic evaluation of custom worksheet function
  733. how to view sage tool bar
  734. MultiCriteria for Conditional Formating
  735. Conditional formating between 2 workbooks.
  736. percentages
  737. Using the MATCH formula and list the duplicates
  738. highlighting changes by color in an Excel column
  739. Average
  740. Array problem - TIA
  741. IF Date formula
  742. Calculations in Pivot Table.
  743. double match formula
  744. How does one turn off gridlines only in a group of cells?
  745. Two columns of data in pivot table?
  746. My Auto Sum Function is not Automaticlly summing the cells
  747. Automatic Calculation Turns Off Intermittently
  748. Debra Dalgleish Question
  749. Excel commands
  750. creating table of content in excel workbook
131