PDA

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 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160

  1. Novice Needs Help with Formulas
  2. References and links.
  3. monthly total
  4. adding formula to existing database
  5. lookup finding the next value that is GREATER
  6. Hyperlink.
  7. In Excel Sheet any digit repeat
  8. filter 400 names from list 1 from list 2 with 4000 names
  9. students grades, formulae to calculate what grade is needed based.
  10. auto fill a number
  11. Re: calculate the number of words in a row whose length is greater than 2
  12. IF function with 14 nested levels
  13. list 1 has 400 names List 2 has 4000. find manes from list 1 on 2
  14. find names on list 1 in list 2. list 1 4000 names list 2 400 name
  15. AND/OR FUNCTIONS
  16. how do i add 1 year to a date formatted cell?
  17. SUBTOTAL(9,range) Does NOT work in AutoFilter
  18. calculate the number of words in a row whose length is greater than 2
  19. Column formating help!
  20. Set value for a cell basd on another cells value using an incremen
  21. type 020104 and get 02/01/04
  22. Need help with automating functions
  23. List
  24. calculating positive and negative formulas
  25. How do I copy a new module to 200 workbooks with a macro?
  26. How do I add cells from sheet to sheet?
  27. How do I start Excel Footer on 2nd page?
  28. grayed out options
  29. advanced filtering in XLS
  30. Creating a nested COUNTIF????
  31. COUNTIF for a partial value
  32. How do I change the range?
  33. find then sort formula
  34. Change percentages to numbers
  35. can conditional formulas be used in or with pivot tables
  36. How do I fix my arrow keys? They are no longer moving cell to cel.
  37. How do I change a blank ("") value to a cell with no value?
  38. Help PLEASE! Not sure what answer is: Match? Index? Other?
  39. Running Count
  40. How do I count cells that have are highlighted a certain color?
  41. Can I use HEX2DEC with cell references vs. numbers?
  42. check if worksheet exists
  43. Sum column if multiple criteria are met in adjacent cells
  44. I need help quick! Formula
  45. How can I use the NOW function and keep it from auto updating?
  46. help with excel
  47. reference to sheets without using sheet names
  48. Drawing a line in Excel 2003
  49. A list of Consecutive Integers, can I search for missing integers
  50. HOW DO I CHANGE ABSENCE TEMPLATE 2005, TO 2006
  51. Automatically date cell in Excel
  52. AutoFill w/formulas
  53. Excel toolbar commands
  54. Interesting Workbook formula problem
  55. edit across mult. wkbooks
  56. VLOOKUP seems correct, still getting #N/A
  57. function
  58. date functions for previous 60/90/180 days
  59. SUMIF?
  60. Unable to read File
  61. How do you convert text to rows?
  62. Worksheet keeps reverting to portrait when landscape is selected.
  63. how do I link purchase order dates from one excel workbook to ano.
  64. I'm stuck on and "function Activities" worksheet its due on MONDAY PLEASE HELP,
  65. Working in Excel
  66. keep cell blank
  67. How is real and imaginary time data entered for fourier analysis?
  68. Indirect Help
  69. hiding and showing graphs
  70. how to calculate the sum of the data copied from the net?
  71. Picking Values from a list
  72. text to dates?
  73. How do I check repeating sets of number in a range
  74. Can adjust Format Rows Autofit to ensure WYSIWYG when printing
  75. how can i enable or disable the paste option in excel 2000
  76. colour problems
  77. urgent ......problems on group
  78. working with excel
  79. formula based on text information
  80. excel
  81. please help
  82. Using Student Attendance Record template in Excel 2003
  83. Re: Conditional Formatting
  84. Printing Question
  85. Excel formula
  86. how do I auto name worksheets in Excel?
  87. How can I work in excel 2000 with the find window open?
  88. is there a way to change formulas to values for sorting purposes?
  89. counting the number of printed spreadsheets
  90. lookup functions
  91. blank cells
  92. reference blank cell in formula
  93. Pivot Tables
  94. vlookup argument type
  95. Add numbers depending on other cells
  96. analyzing survey date
  97. Help with Excel Functions...
  98. I need help with a formula
  99. Page breaks
  100. leave cells blank #2
  101. Leave Cells Blank
  102. Writing a Macro to add decimal
  103. concatenating and formatting area code and phone number columns
  104. Need similar formulas to do the job
  105. Why do functions not allow commas to seperate arguments
  106. how can hide and show columns using macro?
  107. Count number of items by month
  108. column won't unhide
  109. IF Question
  110. Adding large minute and second values
  111. concatenate function/convert military to AM/PM
  112. VLookUp with Dates
  113. How do I use ISNA on this formula
  114. Auto-fill
  115. Locate max value of one column based on criteria in another colum
  116. IF(AND Question
  117. Concatenate/Time Functions
  118. VLookup Formula Excel Version 2002
  119. HELP!! Linked Cells
  120. vlookup function return all values
  121. copying the function contained within a cell to anouther cell.
  122. comparing columns of data
  123. Automatically filling in cells based on another cell's content
  124. IF statement when formula result is blank
  125. Sorting rows with alphanumeric starter cells
  126. Setting up spreadsheet
  127. Lookup the 1st 5 digits
  128. Mail a different files to each person in a range
  129. NPV Calc appears incorrect with a large # of negative cash flows
  130. Track Changes
  131. Using Offset with named ranges
  132. unable to open hyperlinks in chart
  133. #Name error
  134. Formulas
  135. Adding up Times
  136. if/then changing text format to Bold
  137. EXACT comparison formula
  138. I would like to open a new instance of Excel each time I double-click on a xls file
  139. Remove cells with text not relevant
  140. Selecting data within a date range
  141. Automating using VBA
  142. Replace formula with current value
  143. dependent drop down boxes and dynamic ranges
  144. If statement - 2 tests
  145. Splitting up a cells contents
  146. Replacing commas with carriage return
  147. need some help
  148. AND and OR in a single formula
  149. Input cell reference is not valid (One Variable Data Table)
  150. How do you insert an "or" operator in an "IF" statement.
  151. Find out first Friday every month
  152. Excel Formula to determine if cells contain certain data
  153. How to set up an IF formula in Excel
  154. copy worksheet to another worksheet
  155. Formula Causing a Save Error Message
  156. Opposite of Concatenate
  157. hide the returned value "false" I have submerged zero values
  158. Another Try
  159. can not imput data on saved worksheet
  160. If function
  161. Referring to function in another workbook
  162. Is there any way to disable the "getpivotdata" automatic formula?
  163. Conditional Formatting
  164. 1-7 Columns, to find last column with figure in
  165. semi-complicated nested IF statement
  166. Internal Database Query
  167. Formula to delete blank cells across multiple columns?
  168. How to count dates within a certain range in a column with mutiple date range entries
  169. MAX -1
  170. Omit blank cells from function results
  171. rows with formulas
  172. multiple if/than in one cell
  173. Excel should let me group rows of info and then sort them
  174. formula for decreasing $420.00 by 4 percent
  175. VBA Sum Function??
  176. setup reminder to a cell
  177. Date Calculation
  178. Re: vlookup help
  179. Selecting a cell in a range
  180. Creating mandatory fields(cells)...
  181. Macro
  182. vlookup help
  183. I know this is an easy one... filling in values from a master list (2 dif sheets)
  184. Embedding a Sumif in a sumif
  185. Function for characters
  186. Formula to Text
  187. Problem with IF function/circular/HELP!
  188. Re: Condensing my worksheet
  189. Time Sheet turmoil.
  190. Condensing my worksheet
  191. help parsing multiple text sets from one cell
  192. What does the + in '=+IF(...' do in an excel function
  193. Auto-Insert "Last Saved By"
  194. Last cell in an array
  195. IF value
  196. Have "IF,Then" to get data from multiple columns--can I nest add'l IF,THENs?
  197. IF function
  198. IF statement with logical_value that is similar to this 0<a1<10
  199. type information in one column and second coloumn will know respo
  200. EDATE
  201. how do i do this ?
  202. selecting multiple sheets
  203. Put an if statement according to cell format
  204. Show values from other sheet
  205. Timecards, hours & minutes
  206. duplicate words
  207. SumIf function
  208. Extend series using ref cell formula transposed
  209. If statements with validation lists
  210. How can I print a drop down list
  211. IRR weekly basis cashflow
  212. validation list with drop down list of options??
  213. dropdown with validation??
  214. file creation date
  215. Update Links problem
  216. Deleting Lead Zeros
  217. Sumif
  218. Excel: Add/subtract to existing value in same cell
  219. how i make the excel send data or save it to another bad file
  220. Excel 2000 VLOOKUP returns #N/A unless press F2 return on source?
  221. USCASCII characters
  222. Look for the first non-blank cell above!
  223. move to another cell within a subtotal report within a macro
  224. sort
  225. Frequency Array and Bin Array
  226. rolling 12 months
  227. automatic numbering of rows in excel, how to?
  228. Sample selection in Excel
  229. I need help converting a column from "cm" to "mm".
  230. Excel convert 1 row 5 words INTO 1 row 5 columns
  231. Pivot, Sumproduct or both?
  232. Information Rights Management
  233. Saving into 1 workbook as a different worksheet
  234. Re: Rank based on criteria
  235. Re: Rank based on criteria
  236. select a file name for a link?
  237. Advanced filter does not filter
  238. Formulas when dividing with negative numbers
  239. Are there functions that perform robust statistics in Excel?
  240. validate input of cell A1 to either 8 or 0 based on cell B > 0
  241. Formulas not showing results
  242. Open separate window
  243. Find data using three variables, all of which may repeat.
  244. not sure what formula to use
  245. Recap Worksheet
  246. Data Validation Manipulation
  247. If function
  248. #Name? Error in User Defined VB Function
  249. Excel 2003 - How do I set up a short cut key for the cent symbol?
  250. Rounding/Significant figures
  251. having a table in excel
  252. How can I put result of If worksheet function into a different cel
  253. Referencing Cells Using If Functions
  254. How do I save as a web page without losing comments box with pictu
  255. Input Cell in One variable data table
  256. separating numbers and letters from alphanumeric cell contents
  257. Date Problem's
  258. Formula for If Term is on Certain Date then Count
  259. Use a cell's value to set the source file name in link
  260. share excel document
  261. Create AVGIF function
  262. Have I exceeded nesting limit
  263. IF, AND Formulas
  264. How do you split one document into two columns?
  265. Macro virus
  266. complex date function
  267. How can I retrieve multiple rows that match one criteria, i.e. a d
  268. what formula do I use to count right-justified cells in a row?
  269. HOW DO I CREATE LISTS WITH CELL REFERANCE RULES
  270. Protecting Columns when another is used
  271. Nested Subtotal Formula
  272. how do i pull all subtotals from a spreadsheet
  273. cell fill colors in excel 2002 sp3
  274. How can I copy and paste the text of a formula?
  275. 3D formulas in Excel
  276. Date format when using a vlookup
  277. Changing data within one row
  278. FU: Distribute info from "summary" page to separate pages under condition
  279. Date function
  280. Pivot Table -- Add column to average Grand Total
  281. Distributed retrival
  282. How can I calculate columns?
  283. Help with formula that unexpectedly returns an answer
  284. ActiveCell giving blank value in vbscript
  285. x axis labels/scale move to middle of chart w/neg & pos line cht
  286. Distribute info from "summary" page to separate pages under condition
  287. Sorting Dates
  288. Vlookup on multiple similar entries / NO VBA
  289. Re: I need help calculating dates?
  290. I need help calculating dates?
  291. A number of days into weeks and days
  292. Find duplicate
  293. Hyperlink problem
  294. cell value change event
  295. Cannot Print From Excel
  296. Help with Ledger/accounting formulas
  297. Setting up hyperlinks automatically
  298. Input to populate report worksheet
  299. getting excel to switch to a new row
  300. total a colum using data from another column
  301. Count unique entries
  302. Change number to text formula
  303. worksheet is locked on highlight how do I unlock it
  304. Merging new data
  305. Solver returns non binary answer in binary constrained cells
  306. GETPIVOTDATA - return cell reference, not value
  307. Is there a Division funtion in Excel?
  308. SUMPRODUCT Help
  309. convert date of birth to mos. old now, 30 and 60 days
  310. How do I find address of cell containing maximum value
  311. how can i rank a column in excel
  312. Re: Excel Lookup with If
  313. CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH
  314. Worksheet Selections in Macros
  315. Exl: how to? If column N value =R, then copyentir rowto sheet 2
  316. RE: CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH
  317. RE: Worksheet Selections in Macros
  318. words means numbers
  319. How do I display a graph from one workbook to another
  320. How do I return a blank for VLOOKUP instead of #N/A?
  321. HYPERLINK
  322. is there a blank drlling AFE available
  323. Linking Spreadsheets
  324. Calculating Percentage
  325. Can I sum only highlighted cells in a worksheet?
  326. Excel Lookup with If
  327. How to protect sheet but allow grouping to work
  328. How...?
  329. Comments Help
  330. function vba
  331. Sum of a row minus two smallest numbers
  332. Combining worksheets
  333. Adding columns to a worksheet
  334. Comparing Cells
  335. SUMPRODUCT Help
  336. Round function that rounds down if 5
  337. how to change formula bar settings
  338. Add more than 65536 rows?
  339. Counting rows containing data (both numbers and text)
  340. Figuring hours
  341. functions with nonadjacent cells
  342. Drop down lists show button?
  343. Reference an identical cell on a different page using copy/paste?
  344. SUMIF with multiple criteria
  345. Offset And Vlookup Combo Help!!
  346. Comments
  347. Hightlighting Numbers & then all Cells to the right of these Numbers.
  348. Paste Link
  349. Sort function or macro for the first 4 letters
  350. Database type Formulas
  351. how to save/copy data in cell to a series of cells on another pg
  352. graphing algebra equations
  353. Making a drop down list/column
  354. Overtime Hours
  355. Paste question
  356. Re: Excell Check Digit Formula
  357. Creating a formula for down and distance
  358. Formula does not work with 13 digit numbers
  359. Countif
  360. Need Help
  361. Count down formula
  362. Excel 2004 Mac Version - INSERT LINE BREAK IN INFORMULA
  363. Complicated sort function with sort and sum
  364. Figuring hours
  365. How to consolidate data from multiple worksheets.
  366. Any MVP to try this ..
  367. import text and sort data into excel
  368. import text and sort data into excel
  369. Auto Sorting
  370. I cannot edit a graph
  371. STPCScut STPCScopy macro missing??
  372. can i store percentage formulas to reuse them?
  373. validation-list
  374. how do I calculate hours using one cell only
  375. How do you reference another cell in the criteria of a SUMIF funct
  376. IF function trouble
  377. Finding text within text
  378. Less i column
  379. "tomorrow worksheet function"
  380. sum / lookup w error correction
  381. um... im lost
  382. Index function works in A2, but not in A10, Why is that? Cant figure it out.
  383. Complicated Formulas
  384. How do a lock a picture to the rest of the spread sheet row entry
  385. variable as a cell reference?
  386. Creating a league in excel
  387. IfSum
  388. counting decimal places
  389. how to count the number of decimal places in a cell?
  390. Automatically copy values
  391. How do I sort (or group?) a spreadsheet by similar rows?
  392. add leading "0"
  393. Please help me...!
  394. joing (merge) tables by key field
  395. how to get the name of the sheet in a cell?
  396. how to spell out number using function in Excel
  397. if/then statements
  398. How to insert a picture with IF-function
  399. How do I calculate if a date is in a certain time frame?
  400. Invoice Numbering
  401. Selecting from a Validation Drop Down Box aborts macro
  402. IF Statements-Circular Reference
  403. Get other sheet names into a column
  404. making the range a set of data within a column
  405. selecting certain text in long row of text
  406. Re: IF statement
  407. copy certain data from one row
  408. Adding superscript in text function
  409. Can I auto fill a cell in one worksheet by typing a code number
  410. formula for linear regression
  411. conditional formula
  412. Adding numbers to a running total
  413. IF Function Help
  414. Lookup across multiple worksheets
  415. How can I replicate a conditional sum formula?
  416. Help with IF Function
  417. Help needed with Adapting complex INDEX formula
  418. Use of iteration function
  419. how to share spreadsheed in excel with a person at another comput.
  420. Is there a way to copy multiple worksheets into one, row by row?
  421. In Use Message
  422. How to make excel not to compute formula
  423. Changing dates entered in 2005 to previous years
  424. How do I specify more than one argument for the SUMIF function?
  425. posting 20050826
  426. Please make it easier to access the IS functions (e.g., isblank) .
  427. how to find returns for lump sum & yearly investments
  428. Count the occurence of more than one condition
  429. Compound interest rate of return on investments
  430. Drop down List
  431. Formula requireing the system time
  432. COUNTIF criteria using date ranges?
  433. Linking Spreadsheets
  434. is date can be filtered to a different cell?
  435. autosend for excel worksheets for distribution list option
  436. Can You Translate This Function Into Excel Format?
  437. Hit enter in cell & move text down in cell, not go to cell below.
  438. Signifcant digits
  439. how do i convert 536 seconds to 8minutes 56seconds
  440. Lookup value throughout an array_return adjacent value and summing
  441. Opening workbook in user-defined folder
  442. Concatenation with leading zeros
  443. I lost the box on the top of Excel that you can type text in???
  444. my output appears very small
  445. fill series is incorrectly copying result
  446. sort rows in alphabetical order and move the corresponding data
  447. EXCEL 2000 AVERAGE function
  448. How to move characters to the end of the string
  449. Hyperlink probelm
  450. Exponential values
  451. IF ranges for multiple columns greater then less then
  452. Linest function: data selection problems
  453. Linest function: data not being selected in formula
  454. Collapse rows with duplicates
  455. Can Excel operate a function based on a true or false result?
  456. look up
  457. EXCEL WORKSHEET
  458. Select updated data from a range of columns
  459. opslag
  460. Difficult Time equation
  461. Inserting a row with functions
  462. Find last occurance of text in range
  463. overtime formula based on dynamic date range?
  464. Linking information between workbooks
  465. Summing a variably-sized range
  466. creating macros in multiple worksheets
  467. SUMIF with 2 conditions
  468. Advanced Auto Filtering
  469. How do I find the last number in a column of numbers?
  470. Is this possible please if so How. Thankyou.
  471. Dynamic VLOOKUP function
  472. Showing a unique random number w/o duplicates
  473. Vlookup using a range condition
  474. Select unused number
  475. 'SUM' Tables
  476. Combine into one please
  477. Hourglass comes up when going between split screens.
  478. TWO IF
  479. EXCEL should be able to split times especially second fractions
  480. Eliminate empty rows when extracting info from 1 wrksht to another
  481. if amount <0, put the all line in red
  482. Array formula needed
  483. Converting text to numbers
  484. How do I filter out data by font color in a spreadsheet?
  485. VLOOKUP Help Needed
  486. Default font for Comments
  487. Formula for Ratios
  488. how combine multiple tables into one
  489. Having trouble printing selected columns on one sheet.
  490. SUMIF Function?
  491. Counting Months
  492. HELP!! I need help w/Conditional Formatting
  493. Average of numbers within a range meeting certain criteria
  494. Pivot Table - if Formula
  495. Inserting Pictures with IF function
  496. Not Sorting Problem?
  497. Problem, again
  498. Autofilters-Remove (Top 10...) and (Custom) options from the drop-
  499. i can not fliter unique records
  500. Copy and Pasting Every Third Row
  501. Modifying Macro
  502. Retrieving Unique Values From A List - TIP
  503. Re: Please Help: Adding an equation to a range
  504. Please Help: Adding an equation to a range
  505. Color change - Cell Pointer
  506. Excel function to countif a criteria is matced within to columns
  507. Count a value if next to another value...
  508. Help with Excel Formula VLOOKUP
  509. Conditional Formatting Pbm
  510. Referencing worksheet names
  511. Sum the results of an equation through a series of Cells
  512. Complex Macro to perform an operation as it steps down cells?
  513. How do I convert time (2:30) to a number (2.5) in a formula?
  514. Drop down list button hidden
  515. Comparing a list to a Calendar worksheet.
  516. conditional copying of sheets
  517. Re: How to update links between wk sheets
  518. put the index back into excel help - I want pop-down of functions
  519. Saving Version Control
  520. How do I get Excel date to change from 1/1/1900?
  521. Counting a range
  522. How to update links between wk sheets
  523. Conditional Format to highlight entrire Row
  524. Function-formula help
  525. In Excel,how do I lookup a value and assign it to a list?
  526. formula for named cell/range using cell values
  527. Subtracting date:hour from date:hour
  528. Please add an INTERPOLATE function. For vector or array data.
  529. Index and match functions help needed.
  530. Hiding text so it doesn't print
  531. finding matching cells in worksheets
  532. Validation Problems
  533. Duplicates
  534. Returning a Value dependant on a cell which could have different d
  535. font colour change within a IF formula - Help!!
  536. wildcard use in formulas
  537. function/formula help
  538. Interest calculation
  539. Date problems
  540. Cell Offset
  541. Parse text & numbers & format
  542. Parse text & numbers & format
  543. Parse text & numbers & format
  544. Help!! with a formula
  545. how to enter numbers value for calculation?
  546. HOW TO FIND DIFF. BETW. 2 DATES, IT SHOULD BE IN YRS, MONTH & DAY
  547. multiple cell editing
  548. International Language Functions
  549. Conditional Format to Highlight entire Row?
  550. how can i filter data from one sheet and copy to another via formu
  551. combine text of multiple cells
  552. mass cell data editing
  553. Return Single Instance of Numeric Values from a Column
  554. Re: Check if cell contains certain text
  555. Automatically insert row and copy formula
  556. How to print detailed instructions for all functions in Excel?
  557. trying to add text
  558. SUMIF for Dates / Months ?
  559. Real Value of .UsedRange.Rows.Count
  560. How do I add time (in mm:ss) from multiple worksheets?
  561. How can I match data about countries drawn from two database queries?
  562. Searching Excel for a value
  563. Data Validation dependant and unique
  564. Another Reason to Hate Insurance Companies (as if you needed one)
  565. Change color to red when fraction is negative
  566. Help with Excel formula
  567. IF Function or Countif
  568. Entering same data, two worksheets
  569. Duplicates
  570. Changing a Link Mid-way Across Worksheets
  571. cell custom format
  572. =ppmt
  573. Re: VB Error, combining rows if...
  574. Refreshing drop down cell values...
  575. Millionare!!
  576. fill a series of dates excluding holidays
  577. Re: DATA > TABLE -- 2 variable data tables?
  578. assigning ranks to number ranges
  579. Ability for Excel to find and replace graphic objects (like Word)
  580. do I have to manually change PER to amortize a loan out 40 years?
  581. "BLANK" - need to delete
  582. do I have to manually change PER to amortize a loan out 40 years?
  583. Formulas requiring a time stamp
  584. Conditional formating help needed
  585. ATTN: Mr. Bob Phillips
  586. can not enable macros
  587. RE: How do I separate a text value with dashes?
  588. Can an IF formula result in a color filled cell in Excel?
  589. Carying Forward data with specific information
  590. Source Data in Pivot Tables
  591. formula stays same in cell when new row is inserted
  592. RE: Quick and easy
  593. vlookup, but ignore errors if #n/a
  594. How do I input zeroes in a zip code for a mail merge?
  595. subtact between times
  596. Combo Box
  597. Nested functions HELP!
  598. Formatting Cells - color based
  599. IF - need to insert a cell value
  600. ISERROR
  601. Excel - open a new workbook with "own" macro
  602. How to autofill data from one sheet into another
  603. Automatic Sort with VLOOKUP/LARGE Functions
  604. HOW DO I MOVE A DESCRIPTION OR NAME INTO A SUBTOTAL LINE
  605. Opening excel spreadsheets via excel.application object w/o prompts
  606. Update worksheet by comparing two cells
  607. Sort defaults
  608. copying formulas to another cell
  609. cover #s to text
  610. Data entry for two worksheets
  611. RE: SUMIF Returns a #VALUE error when external source is closed
  612. RE: SUMIF Returns a #VALUE error when external source is closed
  613. Nested If with And
  614. date shows 1/1/1900
  615. Array Formula help pls.
  616. Nesting Problem
  617. Excel Worksheet crashes when changes are made.
  618. Average of the minimum+50 in a row
  619. lookup function bringing in wrong info
  620. pivot table to sheets
  621. Copy Formula to Different Workbook
  622. COMPARE DATA FOR CHANGES
  623. Reading data in onther Excel document
  624. Final week - 2005 Excel User Conference - Ft. Worth, Texas - Sept 16/17
  625. I want to convert 10,000 to "Ten Thousand" using Excel Function
  626. moving cell
  627. How do i make a range of cells change colour
  628. IF STATEMENT in multiple workbooks.
  629. Autosum returns an incorrect zero value on the selected cells
  630. LookupV
  631. Simple Copy from Worksheet to Worksheet
  632. Error using "IF" in Microsoft Excel
  633. Sumproduct / Max array formula problem
  634. plz help
  635. print bottom row repeat on every page
  636. Date Language setting
  637. How do I set up an automatic running average in Excel
  638. QUOTE NUMBERS
  639. Calculating the right formula
  640. backing sales tax out of a total including sales tax
  641. Using Sheet names in formulas
  642. working with dates
  643. convert a PDF file on the Web to Excel
  644. Matching a sampling # to it's row #number
  645. Newbe Help with count/countif function
  646. how can I blank out columns that are not being used
  647. Cleaning up data from Crystal Report
  648. Lookup - Pro-rate formula
  649. How do you format a cell for % varience for multiple answers
  650. IF Statement??
  651. inserting a VISIO drawing into a worksheet
  652. Product formula help
  653. Formula for appending data
  654. Caculating a "staircase" discount
  655. column to column conditional formatting won't work, need formula
  656. Results in a column
  657. How to transfer info from PDF file to excel (lists)????????
  658. how do I write the date in an if statement
  659. Freeze frame printing
  660. Drop Down List Autofill
  661. Vlookup then OFFSET over and down
  662. Do Loop
  663. Drop - Down Box
  664. Date Function
  665. create default cell value
  666. Formula Problem
  667. Exclude non-numeric data from calculation
  668. Counting Match Pairs In Rows
  669. formula to identify weekend dates
  670. combine date one column, with time another column into third?
  671. Is it possible to split a cell within a cell?
  672. Sorting from last Digit
  673. Create a master worksheet based on 2 different worksheets
  674. moving the formula "average" over one column in a macro
  675. formula with changing cell ranges
  676. IF statements/formula problem
  677. Help with a formula
  678. Excel for inventory aging?
  679. Lookup function help
  680. display Calendar for Excel field entry?
  681. Do I have a corrupt shared Excel 2003 File?
  682. Help with formula...please
  683. create a multivariable regression in excel without using array
  684. Payment formula Question
  685. Cell reference
  686. how do you count checkboxes in excel2003
  687. use replace to edit a formula with wildcards
  688. Pivot Tables - Named Range
  689. School assignment: Excel worksheets.
  690. minimum along rows
  691. How do I total amounts on various sheets in excel?
  692. Function to return the active sheet name
  693. excel, printing data in columns
  694. Identifying bottom of list
  695. Range Changes with the Months
  696. Re: Counting Blanks
  697. page numbering
  698. Counting Blanks
  699. Editing Array Formula
  700. Countif using dates
  701. How do I delete the same item from all pages of a workbook?
  702. Re: cover #s to text
  703. Best 8
  704. Not including blank fields in pivot tables
  705. coutif with 3 criteria including brackets
  706. randomly select value WITHOUT changing
  707. How can I merge and link workbooks into one summary workbook?
  708. Time format in excel
  709. Could you help me to calculate overtime
  710. CREATE A SUM BASED ON DATES
  711. Re: cover #s to text
  712. RE: cover #s to text
  713. how to change colour of text in true or false formula
  714. How do I calculate time
  715. Struggling Again With A VLOOKUP
  716. Worksheet VBA function - not recognized
  717. Numbers converted into amount in words in English?
  718. Formula for Calculating a Floating Date
  719. importing data into a workbook
  720. Help with IF & Average Functions
  721. Function Help Please ....
  722. No Match
  723. Is there a way to reverse the layout of your colums?
  724. How to get pivot table Time field to appear correctly
  725. Question about Emailing
  726. How can I get fonts bigger on my dropdown list?
  727. counting filtered items
  728. How do I do this?
  729. Tracking calculation progress
  730. Find certain text in a column and return statement
  731. Need a help with the IF/ IFCOUNT function
  732. Update of cell values after insert row?
  733. IF - Nesting... almost got it - need a bit of help
  734. Need insert a dash in between last 4 digits in text string
  735. Target.Address syntax
  736. How can perform a summation?
  737. drop down lists/validation tables
  738. Automatic Date Entry
  739. How do I calculate operating expense
  740. Nested IF AND OR function Inexplicable error
  741. sumproduct w/horizontal range not working
  742. Spell Check an Unlocked Cell in a Protected Spreadsheet
  743. Selecting a Worksheet Range
  744. How do I calculate operating expense
  745. Links
  746. Logic Tree, MS help = useless
  747. I need to insert a drop down menu in a cell?
  748. Create a print macro that would automatically select print area?
  749. Make an =if show - instead of 0
  750. Can I modify Excel 2003 color palette to accept Pantone colors?