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. Pasting onto filtered cells
  2. Using the Indirect.Ext function
  3. To me this is huge, need some assistance
  4. Average Range
  5. Pasting onto filtered cells
  6. HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ?
  7. Need to sum values of columns 1 - 13 and 4 - 15
  8. Excel
  9. Count cells with the red color
  10. copy worksheet ... formulas do not update
  11. Insert rows based on specific value
  12. MIN >0
  13. index match and sum
  14. How do I create a column that has a 'drop box'
  15. How do I create a column that has a 'drop box'
  16. vlookup
  17. how do I get a calculation to repeat various number of times?
  18. how do you subtract military time? example 12:00 - 07:00 = 5 hour.
  19. SUMPRODUCT CAPTURING DATA FROM ANOTHER SPREADSHEET
  20. Conditional Formatting
  21. How do I hide a formula message?
  22. extracting numbers with no more than 8-digits using advanced filtering
  23. Please help create a formula
  24. There should be a Refresh All feature, enabling all pivot tables .
  25. continuous cell function
  26. How do I create a crosstab process to determine patterns in surve.
  27. Use MATCH to find position of max in 2D range?
  28. Conditional Sum
  29. Using the Indirect.Ext function
  30. Feed text from one cell to another no cut & Paste
  31. Calculating commission schedule (will pay for help!)
  32. vlookup and IF function
  33. Need to find Min value based on date range entered
  34. How can set how a number rounds up in excel
  35. Get cell value from 2 lists
  36. formula simplification
  37. how to get name of worksheet in a workbook?
  38. Conditional Sum
  39. how do I get excel 2003 to round up
  40. end of worksheet question
  41. SUM function over infinite number of sheets?
  42. Changing number in same cell
  43. SUM function over infinite number of sheets?
  44. end of worksheet question
  45. How to plot B2:B11 versus A2:A11
  46. Calculating commission schedule (will pay for help!)
  47. Calculating commission schedule (will pay for help!)
  48. Calculating commission schedule (will pay for help!)
  49. Add a string to a cell
  50. Need find cell b3 value on another worksheet!
  51. Need formule which would find cell (exmp b3) value on another worksheet! please help!
  52. Date formula by decade
  53. Need find cell b3 value on another worksheet!
  54. Using ROUND formula to calculate tax
  55. Need find cell b3 value on another worksheet!
  56. Add a string to a cell
  57. Editing Multiple E-Mail Addresses...
  58. matching problem using VBA
  59. Need find cell b3 value on another worksheet!
  60. is there a instrRev function in excel functions?
  61. Customise Right Click Menu
  62. Lookup Function
  63. Increase the max characters allowed in excel formula to much >102
  64. counting
  65. is there a instrRev function in excel functions?
  66. Conditional Hide function for Excel
  67. VBA: Return Searched Value Inputed by End-User
  68. How to enable grouping in a protected sheet
  69. Report on data in worksheet?
  70. vlookup
  71. Changing a Parameter Of A Formula
  72. Changing a Parameter Of A Formula
  73. lookup in colum a and compare values in colum b
  74. Lookup Function
  75. Timings, need assistance
  76. counting
  77. IF and ISODD Formula Help
  78. Attempt to register XLODBC32.DLL failed when trying to load SQL-R.
  79. Excel: Need Nper
  80. What formula should I use
  81. How do I change the appearance of my drop down lists?
  82. Hyperlinks in Excell
  83. Validation - List - Separate Worksheet
  84. How can i unprotect a workbook in Excell when I forgot the passwo.
  85. end of worksheet question
  86. Creating a summary from existing spreadsheet data ...
  87. If cellA is blank or 0 then cellB is blank
  88. Dependent List Query
  89. Copying formulas
  90. Is there a formula that can be used here
  91. Why can't my macro use Auto Filter when I told the Sheet Protecti.
  92. Can i automatically format cells to be a certain color if the val.
  93. How can I make autofilter show the filtered number of rows
  94. How do i set up if function with more than level limits?
  95. What formula do I use to link worksheets together within one spre.
  96. Problem with array and msgbox
  97. time-clock calculation
  98. Return the end of month date from a date
  99. Macro for formulas
  100. If cellA is blank or 0 then cellB is blank
  101. extracting comments
  102. Excel & Copying Formulas
  103. How to link endings balances to beginning balances on different sh
  104. sort numbers in EXCEL?
  105. SUMIF based on 2 conditions
  106. Can Formula Change the Font Color?
  107. Need to find Min value based on date range entered
  108. Creating a list from an existing list.
  109. Creating a dynamic list
  110. Creating a dynamic list
  111. Right margin will not change.
  112. Pivot Table Limitations in 2000
  113. Sum a range across multiple sheets
  114. time-clock calculation
  115. Insert column entries from a master list
  116. Insert column entries from a master list
  117. Insert column entries from a master list
  118. How do I insert a selectable circle in Excel?
  119. Can I use SUMIF with < and >?
  120. How do I insert a circle in Excel?
  121. Sorting a list with subtotals
  122. VLookup resulting in a blank cell...
  123. Sum function on multiple date fields
  124. Calculating using data from another worksheet
  125. How do I stop other circles in other boxes to stop selecting?
  126. end of worksheet question
  127. trendline - request power --> get linear
  128. Removing Spaces in a Cell
  129. need to save values from a function before it changes
  130. How can I add a numeric value to a TIME cell?
  131. IF Statement
  132. How do I ensure dates inputted are during the work week?
  133. Cell Shift
  134. How do I create a button or control that will automatically go to
  135. How do I automatically shade cells depending on data entered?
  136. How to populate column with formula based on value in cell
  137. Function / formula to be used if cell contains a letter.
  138. How do I create a formula that will multiply a 5% of a value >$150
  139. vlookup help!!!
  140. Problem with Sum of Sums in Excel
  141. Finding and Showing the Largest
  142. print a specific area within a worksheet by clicking on print?
  143. How do you embed an input form into excel?
  144. Display selected rows from one worksheet to another
  145. Finding and Showing the Largest
  146. how to accumulate value and put in other sheet
  147. Date Question
  148. PRIME FACTOR
  149. How to shade a row of cells using conditional formatting
  150. sum difference cells on multiple sheets
  151. Vlookup - indexing
  152. Conditional Formatting Work around?
  153. Hire purchase interest
  154. Problem with array and msgbox
  155. Exceptions to Validation Rules
  156. How to Make the text blink in Excel?
  157. how to add up number of columns based on month eg feb = 2 oct = 1.
  158. Insert\Name\Apply.... problem
  159. Smart subtotals
  160. Pro rata calclation
  161. get count of row without duplicate entries
  162. Major cost of time.
  163. Help with Formula
  164. Add apostrophe
  165. Average Formula
  166. CountIF across multiple sheets in a workbook
  167. Look Up Function
  168. Formula for Extracting Alphabetic Part of a Product Code
  169. Reference
  170. How do I shade cells using the "IF" function?
  171. How Do I sort an IP address by the 3rd Octet?
  172. I am having trouble deleting sheets in Excel
  173. VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True
  174. Finding duplicate nuumbers in a column
  175. end of worksheet question
  176. help please <d :D
  177. VBA: Looked up data / now how do I change it?
  178. Percentage format
  179. Using the Month function to sum another column
  180. Conditional Format With SUMIF
  181. Can Excel add a set percentage to a cell automatically when you type in a number
  182. Formula for Extracting Alphabetic Part of a Product Code
  183. How do I "Wrap Text" & "Autofit" within Merged Cells in Excel?
  184. How to use Proper formula?
  185. lookup and copy
  186. =data!c23
  187. Formula for Extracting Alphabetic Part of a Product Code
  188. is there a way?
  189. How do you change the color of the cell hi-lite border
  190. How to look up and return multiple values
  191. finance charge on credit card
  192. Calculating Net Position and Average Price
  193. How do I stop other circles in other cells to stop selecting?
  194. Formulas not calculating
  195. Days of the Month
  196. How do you keep the date using =TODAY() from changing?
  197. Cut and Paste
  198. How do I use conditional formatting for multiple rows?
  199. find top 25 codes
  200. compacting UPPER/LOWER & column reference
  201. filename with folder
  202. How do I transfer the format of one worksheet into another?
  203. calculate with dates before 1-1-1900
  204. random alphanumeric string
  205. Is there a short cut to switch between worksheets?
  206. works 6.0 spreadsheet
  207. Sorting dates
  208. calculating weeks worked
  209. IF Statement
  210. Nesting If Statement with "AND", "OR" conditions
  211. pasting formulas into a selection
  212. Finding real values of a function
  213. If both dates are entered into a cell then answer is yes
  214. Algebraic functions
  215. count the no.of records between two dates
  216. populate one worksheet from another
  217. How do I email selected excel cells to multiple recipients?
  218. Grayed Out Worksheet Tabs
  219. sorting
  220. Statistical Excel Function Question within Excel 2000...
  221. Worksheet Reference
  222. Whats Wrong with this??
  223. Sumproduct on filtered cells
  224. open ended multi page sum
  225. Lookup value in colA whos row matches row of index value in colB
  226. Why is it important to check the range placed in the SUM function.
  227. Highlite a row
  228. Lookup value in colA whos row matches row of index value in colB
  229. Stumbling with IF THEN in Excel.
  230. Help w/ algebra equations (wrong formula used in my first 2 posts!
  231. How do I create automatic cell movement when using excel
  232. Deleting Zero after Subtotal
  233. How to control worksheet initialization upon opening a workbook
  234. Help with Interpolating for a value.
  235. Is there a way to link a received outlook email to a cell?
  236. Autofilter - Return a Value
  237. Graphs and sheet referencing?
  238. How do I stop automatic page breaks in excel
  239. Lookup, IF, Then help
  240. How to use a table index from a formula
  241. How to lock a worksheet and enable the PivotTable refresh data opt
  242. Workaround for LOWER(A1:A100)
  243. COUNTIF Question
  244. Workaround for UPPER(F31:F10000)
  245. open ended multi page sum
  246. Have a question on scrolling sum with Excel.
  247. Have a question on scrolling sum with Excel.
  248. How Do I created a nested sumif - if this column has this and thi.
  249. COUNTIF Question
  250. open ended multi page sum
  251. sorting automatically
  252. Web Tool Bar
  253. sort automatically
  254. How do I set this up?
  255. Workaround for UPPER(F31:F10000)
  256. How do I set up a formula in excel that is the tenth root of 7 ve.
  257. How do I create complex functions?
  258. function about hyperlink
  259. Circular reference
  260. COUNTIF Question
  261. <<Question From New User>>
  262. open ended multi page sum
  263. Average determination
  264. Counting a Running Column
  265. vlookup to see 2 values?
  266. Static Dates in Footers
  267. Random
  268. Excel Programming help
  269. help please <d :D
  270. Outlook with excel
  271. Problem with array and msgbox
  272. =SUM Then insert word.
  273. vlookup
  274. Display result as Yes or No
  275. Hiding rows based on date
  276. excel won't work with peachtree
  277. No value entered
  278. Grading Function Question...
  279. Why do the ActiveX text boxes move when I print preview?
  280. Function to return colour of formatted cell
  281. dynamic 3d sum
  282. Data from one tab to another
  283. Combine & Display “Fixed” & “Automatically Updated” Date Parts
  284. grouping
  285. Stumped! Collecting values into one cell.
  286. random number generation
  287. VBA: Update worksheet when txtBox data changes.
  288. Formulas with If/ and results
  289. #REF error
  290. Conditional Formatting "OR" function
  291. Summing a Column wit errors?
  292. multiple vlookup
  293. Data from one tab to another
  294. What is the formula to calculate Age when I have Date of Birth?
  295. What is the formula to calculate Age when I have Date of Birth?
  296. variation on countif?
  297. Stumped! Collecting values into one cell.
  298. VBA: Update worksheet when txtBox data changes.
  299. counting entries between two dates?
  300. Formula results in font color change
  301. Save Excel file - prompts to save - no Volitile functions used
  302. combining countif formulas
  303. How can I use count function in excel where I have several criter.
  304. Count certain changes between columns
  305. A different "Fill Color" problem
  306. count if
  307. Automatic date change when spreadsheet changes
  308. XIRR Function Error
  309. If statements
  310. Formula for date function
  311. Need help with a formula
  312. countif, again
  313. count based on two fields - need quickly
  314. count based on two fields- need as quick as possible
  315. Data Sorting
  316. record count using two different cells
  317. How do I stop the autopaste function in Excel?
  318. Sumproduct #N/A elminate?
  319. accessing worksheets
  320. solver can not solve polynomial eq. where one variable is five di.
  321. how do I make a function to count days?
  322. Lookup a date between other dates
  323. Macro for sorting different rows
  324. copying conditional formats to a whole column
  325. COPYING CONDITIONAL FORMATTING TO A COLUMN
  326. Upgrading Problems: Excel from 2000 to 2003
  327. high lite a row
  328. Sum and Count Function
  329. Excel Formula Question
  330. Excel can't find the end of the spreadsheet (Ctrl+end)
  331. Saving Charts to .htm
  332. copy and paste
  333. Subtotals
  334. IF Statement
  335. making variables constant
  336. making a column of formuls constant
  337. making calculated fields constant.
  338. Web Saving Help
  339. When do you use 3-D reference?
  340. Deleting content in a column
  341. Grading Function Question...
  342. Calculating due date?
  343. Import file names into cells
  344. SUMPRODUCT using offset from ROW if X marks the spot
  345. Identify if Cell is Formula or written number
  346. Calculating due date?
  347. generate random numbers
  348. Using Pick Lists
  349. Excel-value in a range of cells for two cross references
  350. search multiple worksheets for an item and return the Wsheets name
  351. dynamic 3d sum
  352. A different "Fill Color" problem
  353. functions: 4 Millions Domains data with Category
  354. Cell Validation.
  355. Find & Replace questions
  356. Where can I see VBA code for financial functions?
  357. find and match the max
  358. find and match the max
  359. Address
  360. listing linked cells
  361. Excel row headings
  362. Archive
  363. Re: Grouping data within intervals
  364. find and match the max
  365. How do I calculate the hours spent on a project by entering a sta.
  366. CHOOSE Function
  367. Add numbers for duplicate entries then delete
  368. Automatic date change when spreadsheet changes
  369. dynamic 3d sum
  370. why are nested subtotals coming out below outer subtotals?
  371. Concatenate and make uniform
  372. How do I find downloads for workbooks for Accounting homework?
  373. RANDBETWEEN query
  374. If..then quesiton.
  375. Getting rid of curly brackets within formula
  376. How do I prevent tied results when ranking data?
  377. how do i create a blank cell in excel using a formula
  378. How do I protect one cell in a spreadsheet?
  379. how to display heading of column corresponding to the cell
  380. COUNTIF
  381. Getting rid of curly brackets within formula
  382. first week of year - according to european standard
  383. repeated numbers
  384. differentiating between "and"/"or" in a formula
  385. Linking Data between worksheets in a workbook
  386. Deleting content in a column
  387. Counting problem again!
  388. parse cell and insert rows?
  389. Getting rid of curly brackets within formula
  390. Excel to Access
  391. Concatenate and make uniform
  392. CHIINV error
  393. How do I conditional format for data that's repeated
  394. CHIINV error
  395. FORMULA
  396. CHIINV error
  397. how do i display formulas in only certain cells?
  398. Forced Distribution
  399. Can you create an administrator for an excel file that is not sub.
  400. returning a text cell based on a number cell
  401. How do I put a graphic behind the grid in Excel?
  402. Help!
  403. Calculation Question
  404. HOW DO I CREATE MULTIPLE CURRENCY
  405. How I use SUMIF & AND
  406. Re: IF statements
  407. Re: IF Statement difficulty
  408. If Statement
  409. Referring to Pivot Table in Excel 2003
  410. How I use SUMIF & AND
  411. How I use SUMIF & AND
  412. Copy/paste Subtotals
  413. Function Macro for Nested IF
  414. Formulas
  415. Identifying exact values in alternate rows
  416. Use of Exact(or other) function for alternate rows?
  417. Workaround for UPPER(F31:F10000)
  418. If and (and) formula to allow a zero answer
  419. real estate formulas
  420. How Do I (Macro Function)?
  421. Using Countif
  422. Lookup Function
  423. Returning the Week Number of a Specific Date on a Month
  424. Another Lookup function, please
  425. How do I set up a min and max function in the same caluclation?
  426. Need to learn about formulas
  427. Deleting/IDing Rows that Don't Meet Criteria
  428. Import file names into cells
  429. Extracting data
  430. Returning the Week Number of a Specific Date on a Month
  431. How to Set a fix # of days per month
  432. variable range countif
  433. Drop Down List not Appearing
  434. #div/0! problem - please help
  435. How to Concatenate Time with some operator?
  436. data validation on sth else
  437. RANDBETWEEN query
  438. Maps.........Having Trouble Loading things
  439. Lookup with logic
  440. vlookup.
  441. do we have semilog paper
  442. conditional format for text
  443. Count data entries and date problem
  444. Adding TR to the end of each value in a column..formula
  445. #N/A In Max min Average Formula
  446. Seriessum is not quite it...need help, please
  447. How can I format a cell to accept feet and inches and add them
  448. Do any newer versions of Excel (2003 or XP) offer more than 65,53.
  449. How do I set up a worksheet to let me know when a birthday is comi
  450. sort option is greyed out in excel
  451. Edit Hyperlinks Globally
  452. If statement needed
  453. Duplicate fields does not match up! If statement
  454. Deleting/IDing Rows that Don't Meet Criteria
  455. Extract date from cell
  456. How do you delete one cell from a range of protected cells
  457. Activating the Send As Attachment option
  458. Countif, Sumif, If - help!
  459. Help! - with a formula please
  460. Convert text to dates
  461. Display excel formula on worksheet
  462. Is it possible to send a worksheet without the unhidden data?
  463. Is there a way to use the space bar to delete?
  464. If Formula
  465. Freezing panes
  466. macro to not print blank value rows in invoice
  467. How do I reference multiple rows
  468. If's and Isna's and stuff
  469. Adding text before a function
  470. Date Alert
  471. Calculating Average Values Using Arithmetic Equations
  472. Double-Click a Hyperlink
  473. 2-Dim Lookup
  474. need a formula for cumulative grade
  475. Calculating Average Values Using Arithmetic Equations
  476. Sorting problem
  477. how do I 'count' the number of cells with a text in red or black?
  478. Count distinct
  479. Pivot table, how do you exclude counting cells with formulas as a
  480. What's wrong with this?
  481. format numbers into feet / inches
  482. How can i get my whole workbook highlighted in the page break pre.
  483. no repeats in a column
  484. getpivotdata() by position
  485. Sorting merged cellsHow do I sort merged cells not identically siz
  486. Comparing Data in two columns
  487. Excel 2003 isn't updating my cells
  488. unrecognized fuctions evapp etc
  489. Need help on Select Case
  490. countif
  491. Copying Rows when hiding other rows
  492. Parsing text in Excel
  493. Help-IF Function
  494. Using Cell references in VLookUp
  495. Need to learn about formulas
  496. What is the easiest way to learn math functions in excel .
  497. Navigating between worksheets.
  498. How do I build a feature into a cell that would send an email rem.
  499. How do I limit the number of rows in an Excel worksheet.
  500. lookup problems
  501. Combining Defined Names to New Name For Validation
  502. remote data query and sum not working
  503. Create a total based on multiple conditions is not giving correct.
  504. < and > functions aren"t working for me
  505. Conditional Formatting for dates
  506. Summing Formula
  507. TRANSPOSE()
  508. can I merge two different workbooks, with the same format, just d.
  509. Hlookups + Vlookups
  510. Count Comments
  511. consoildate all the worksheet(example sheet1,sheet2 and sheet3 etc
  512. Comment associated with a cell
  513. Excel Function
  514. forming a new column by using the other column
  515. Countif Problem
  516. convert numeric to text
  517. Look up or Index?
  518. how to count the nr of occurrences of a text string in a cell rang
  519. What function or formula do I use to calculate ROI with this data?
  520. Adding column data
  521. GradeBook
  522. How do I delete duplicate entries?
  523. Not quite the same lookup?
  524. unique records
  525. Re: Vlookups and multiple returns (again!)
  526. Linking an entire worksheet from a restricted drive?
  527. Linking an entire worksheet from a restricted drive?
  528. Average Column, but Skip Null and 0?
  529. Why does Excel freeze and have to close when I hold Alt down and .
  530. Average/Min column of numbers, but skip 0's and Null's in the form
  531. Find AVG/MIN of a Column, excluding 0's and NULL's?
  532. Using Workday syntax
  533. Importing Data Into Formula Based Cells
  534. The Auto Filter button lost the column specified option.
  535. can i colour a cell on basis of results of a formula e.g clour bl.
  536. Alphabetizing
  537. GetPivotData
  538. "Is Between" function?
  539. Excel Time Duration Formula
  540. Can Excel be pre-formatted to apply "double quotes" to data enter.
  541. Needing to know how to use a "and" in a formula....
  542. Vector lookup function
  543. single quote 10-digit number that has leading zeroes & then conca.
  544. Number Format Issues-Decimal Places
  545. "Is Between" Function Solution --- Many Thanks
  546. Lookup a date between other dates
  547. HOW TO USE CONDITIONAL FORMATTING FROM ONE RANGE TO ANOTHER RANGE
  548. Calculate the number of workdays between 2 dates
  549. An instant sorting problem
  550. Adding column data
  551. Chart question insert
  552. How to use Vlookup
  553. Decimal places in Excel 2003
  554. How do I find the first value in a column less than a number?
  555. Can I use a cell reference in the criteria for the sumif function.
  556. help
  557. formula
  558. If function
  559. Calculate the number of workdays between 2 dates
  560. import problem on huge xls file
  561. formula help
  562. Getting Speech to work
  563. Text to Speech toolbar problems
  564. make list of information from different cells
  565. Importing Data Into Formula Based Cells
  566. cell reference show cell name (ie. D45) and not cell value
  567. IF-SEARCH
  568. How to do consecutive numbers in separate docs
  569. how do i create drop down menu in excel
  570. ?odd results for =left(F#,2)
  571. Select or Filter by Fill Color
  572. Excel, problem with hiding formulas.... please help!
  573. Summing values of corresponding columns
  574. Unknown Character removal
  575. 30 Day Aging Report Using Conditional Formating
  576. Summing values of corresponding columns
  577. last data entry in column
  578. How do I modify a row depending upon what a cell value is?
  579. Sending Text Messages with Excel???
  580. Apply formuls to whole row (multiply ColumnC*.00274)?
  581. Extract Pixel Values to Excel?
  582. Modify Row based upon cell value
  583. find LAST match in column
  584. Price rounding - exception formula required
  585. how to remove label formatting (eg label to number)
  586. blank cells that include text
  587. How to return min, mean, max using criteria?
  588. I have an "IF"Statement problem...please help!!
  589. Returning the Week Number of a Specific Date on a Month
  590. average by operand
  591. Excel should allow "select all" and also "insert bookmark" as Wor.
  592. Calculated fields-Pivot tables
  593. Creating Links
  594. Formula to Extract Data from a Table
  595. Pivot table : Excel cannot complete this task with available resou
  596. vba to sort group copy paste to another sheet
  597. count function
  598. Countif/Sumif function question
  599. IF/ LOOKUP FUNCTION - Excel 2000
  600. sumif calculate
  601. Help with function
  602. Using Indirect & Creating a worksheet Macro
  603. auto update
  604. Value Increase/Decrease/No Change
  605. How to add up a number of colums (posted on 29/10/04)
  606. How to sum-up alternate rows ?
  607. Count If Formula
  608. Excel: How to return count for each cell within date range criter.
  609. Difference between two dates in months with decimals
  610. Macro did not run after download file from net
  611. projecting growth
  612. Vector lookup function
  613. auto update
  614. Tabs on Excel 2000
  615. Another date function question
  616. Difference between two dates in months with decimals
  617. Naming Sheets Tabs
  618. How do I get a pivot table to sum instead of giving me a count?
  619. Lookup Functions
  620. HOW DO I REMOVE DUPLICATED NAMES ON SPREADSHEET EXCEL97 3900 ROWS.
  621. find LAST match in column
  622. How to return min, mean, max using criteria?
  623. to express degrees & power of a number in excel
  624. auto update
  625. Syntax For Conditional Formula
  626. How do i change the numbering shceme of my rows?
  627. Multi pick into database
  628. Data Validation List Option Affecting Other Cells?
  629. removing green triangle in cell
  630. Countif
  631. Timesheet calculation
  632. import data protection
  633. Excel 2000 - Advanced IF AND ELSE COUNTIF??
  634. generating Unique ID numbers for students
  635. links not linking
  636. links not linking
  637. UPPER Function
  638. Using a worksheet name in a formula
  639. How do I get the COUNTIF criteria to recognize only month and yea.
  640. Auto color change to tabs in worksheet
  641. Need to add the same cell from several workbooks
  642. Do I need nested IF statements?
  643. How do I insert a line break when using the CONCATENATE function?
  644. Modify Row & Cell based on Multiple Data
  645. offset and vlookup
  646. Data Validation List Option Affecting Other Cells?
  647. Help With The Upper Function
  648. Goal Seek - reference a cell for "To value" field?
  649. Autofill Questio
  650. Worksheet names
  651. Formula not updating
  652. countif
  653. Comparing Date Fields
  654. countif
  655. Nesting A Function
  656. Why do formulas turn to values wen copying in Excel 2003...
  657. vlookup function in excel referencing an access table
  658. Keeping Array values?
  659. IF function displays wrong amount
  660. Using Average function when number is zero
  661. Another date function question
  662. Distinct Value With Countif
  663. vlookup returns n/a
  664. Data manipulation help required !
  665. Is there a way to use the space bar to delete?
  666. Time Calcs
  667. How can I group a bunch of cells together, so I can sort by colum.
  668. binomial distribution
  669. Date & Time function
  670. increment cell value automatically
  671. Place a set value in a cell from a drop down list name reference
  672. reformulation question
  673. generate serial number
  674. Conditional Format Advanced
  675. generating Unique ID numbers for students
  676. SUMPRODUCT - HIERARCHY
  677. Need help!!!
  678. letter Validation
  679. conditional formulas in excel
  680. How do I Delete a file from the drop down file menu?
  681. Problem with time calc
  682. Years when 1 April occurs on a Saturday
  683. 00-jan-00
  684. 00-jan-00
  685. Excel 2003 - referenceing the active worksheet page in vlookup
  686. Macro did not run after download file from net
  687. ANY FORMULA FOR CHECK =ISBOLD(A1)
  688. letter Validation
  689. letter Validation
  690. letter Validation
  691. selecting and listing data
  692. letter Validation
  693. How do i increase the size of numbers in a text in Excel.
  694. Formula Recalculation after using AutoFilter
  695. Modify Row & Cell Contents based upon Cells Values
  696. First column that does not contain "Cucumber"
  697. Conditional formating in excel
  698. Delete contents of unprotected cells in workbook
  699. Vlookup
  700. excel 2003
  701. How can I subtract 111 from a number like 097 and get 987, using .
  702. Problem with Pivot Table Drop-Down Menus
  703. PASSWORD
  704. Help Needed With - If-Function
  705. Summing cells in Excel
  706. Summing cells in Excel
  707. Parttime¡°¡@¡D¡@No.1 Work from home¡@¡D¡@¡°
  708. Modify Row & Cell Contents based upon Cells Values
  709. Appl need that VLOOKUP will not handle
  710. RIGHT Function
  711. Modify Row & Cell Contents based upon Cells Values
  712. Countif ???
  713. SUM array formula question
  714. How do I disable text-to-speech in excel?
  715. I have a password problem
  716. lookup function?
  717. Summing values of corresponding columns
  718. IF Function or IF then else
  719. Using two separate scenarious in one IF function
  720. hide "#VALUE!"
  721. How do I count how many times x appears in a column?
  722. looking up a value between two numbers and returning a related value
  723. Modify Row & Cell Contents based upon Cells Values
  724. Can you run a macro from an if statement in excel?
  725. Conditional Formatting
  726. conditional formatting
  727. How do I change a date in a cell
  728. Naming & renaming a sheet tab
  729. Conditional Formatting
  730. help please with conditional format problem
  731. error checking reports a value in the formula is of the wrong dat.
  732. Indexing/Referencing
  733. Group by count formula
  734. Formula help on a cell
  735. combining several individual cells of numbers into one cell
  736. How to calculate the data in excel 2002 including only the last 9.
  737. Only using the correct cell for the sum
  738. change function variable prompts??
  739. Only using the correct cell for the sum
  740. Newbie: How to round down to the lowest 5
  741. Change Color on an IF statement
  742. COUNTA Function not working =COUNTA(C3:C69,"NH")
  743. Cell Formula Help
  744. I am entering data but it appears as a date in excel
  745. Insert Month and Year in my worksheet
  746. How do I set up a dropdown list in excel? The instructions given .
  747. Advanced Window Split & Freeze Question
  748. GCD Function doesn't work in some cases
  749. SUMIF or SUMPRODUCT or something else?
  750. Change Color on an IF statement
131