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

  1. can we round time in excel
  2. How can I add data analysis function in tool?
  3. Can someone give me a hand with this formula please?
  4. keep active sheet view and cursor position
  5. How to AUTO SORT A-Z new data in a column (not menual sorting)
  6. Autofilter stops responding
  7. Excel Crashes
  8. How to display weeknumber with year code
  9. Worksheet Names
  10. Help with schedule layout
  11. how to automatically convert a number to words in Excel
  12. Function IN VBA
  13. Consolidating data??
  14. assigning rows
  15. two cases for countif
  16. Need a Formula for DATES
  17. What function can I use
  18. STRING functions
  19. Worksheet tabs in a Macro
  20. western australian payroll templates
  21. vlookup, multiple values, sum values into one cell??
  22. How to copy 98-97 excel macros to excel 2000 (XP)
  23. Can't make Excel "if" Formula work
  24. Using Autofilter with Protection on
  25. Counting the days worked in a month by employee
  26. how can you copy cells from one book to a shared file
  27. How do I clear data values wthout losing the formulas?
  28. Help with Date Functions
  29. Get tab name formula
  30. excel 2003
  31. SSN Format not showing
  32. Copied nubers is not possible to add
  33. Using excel 2003 cannot see Canadian Postal Codes
  34. How do you count data that matches more than one condition?
  35. How can I change dafault color in excel from black to another?
  36. How do I change my cell reference columns from number to alphabet?
  37. sum
  38. Help matching entries in two sheets???
  39. macro button in all my workbooks
  40. Access data base is able to store any number of records
  41. Protected sheets
  42. SUMIF function question
  43. How do I set up an IF function with text and numbers?
  44. If Function
  45. How can I generate correlated standard normals?
  46. 2nd attempt ~ complicated formula
  47. Re: How to I get a warning message box
  48. Another #N/A Result question...Sorry
  49. strange error calculations provides errors until i add any new one
  50. Using Two Worksheets To Capature Data
  51. Is there a function to auto-sort 2 columns?
  52. Weighted avg of numbers not in contiguous row-ie array w lookup?
  53. Conditional Formatting
  54. Can I create a random order within a series of numbers in Excel?
  55. Excel multiline formulas
  56. how to apply one function to an entire column of numbers
  57. How do I convert time (38:30) to decimal (38.5) format?
  58. LOOKUP
  59. New Auto Selecting Cell Question
  60. Nested IF's with Rank Problem
  61. formula to look up in an application
  62. using the same function to convert a column of numbers
  63. populate data valadation list by criteria
  64. Value error
  65. Re: Creating Combinations
  66. function problem
  67. is it possible to make a spreadsheet display '0' when negative
  68. Taking data from another worksheet and converting
  69. hyperlink to files
  70. How do I select & use contents of first non-blank cell in row?
  71. How do I turn off the solver results dialog box
  72. Showing the contents of a cell based on another cell
  73. editing spreadsheet
  74. Expanding data
  75. ... I would like to apply more than 3 conditional formats ...
  76. Excel data base
  77. shortcut for merging selected cells would be nice.
  78. Concatenation in a CountIf
  79. Macro?
  80. How to change reference to other worksheet by changing one cell?
  81. Excel
  82. How do I have a data table display cell names rather than values?
  83. Substitute ,replace and delete in a cell.
  84. skipping every second cell
  85. Seting up an Indirect Formula
  86. include INDIRECT function into SUMPRODUCT formula
  87. Borders Functionailty
  88. how to create a conditional formula for a range of cells?
  89. "s Appear in files saved as Text (MS-Dos)
  90. i need info from the top workbook to be read in multiple workbooks
  91. How do I sum percentages calculated from IF statements?
  92. Excel find the content of cell using row and column header
  93. Dissappearing formula
  94. comparing many cols of data to one col
  95. trend for polynomial curve fitting by regressing
  96. How do I change hexadecimal number to binary in excel
  97. Transpose rows to columns w/varying numbers of lines per record
  98. Function for interest rate over several years
  99. LOOKUP function
  100. Footage to seconds (# to mm:ss).
  101. Referencing cell in another sheet yields null?
  102. the answer to appear in more than one cell
  103. templates
  104. Excel should have multiple window splits .
  105. RE: Search for instances of X in a sheet
  106. Dynamic range - is there a better way?...
  107. IF/AND/OR/DATEIF Issue...sorry...long post...
  108. add page number to entire workseet
  109. No Excel Function Wizard on Mac-Office 2004?
  110. how do i add every fifth row in a spreadsheet?
  111. Sub-Totaling
  112. Formula is entering a default time when it comes across an empty cell..
  113. How can you convert the false/true into 1/0 in Excel?
  114. RE: Search for instances of X in a sheet
  115. Blank Printouts and Print Preview
  116. max and lookup
  117. Delete rows listed less than 8 times???
  118. Conditional Formatting
  119. Warning! Time has expired....
  120. Inserting Copied Row To Always Insert Above Sub Total
  121. Multiple SUMIF Criteria
  122. Should have ability to right click to accept autosum, not Enter.
  123. RE: CONCATENATING DATE AND TIME
  124. This is so silly...
  125. Date/Time Question
  126. Count number of different entries?
  127. RANK Funciton
  128. RE: CONCATENATING DATE AND TIME
  129. using sumproduct on subtotals meeting certain conditions
  130. VLookup function to search an entire workbook
  131. How do I calculate pro-rata formulas?
  132. how do you have rows automatically insert in excel?
  133. time/date calculation
  134. Cell reference to current cell minus 1
  135. Can I limit the amount of characters in a cell?
  136. in excell the cell only displays formula, not the number
  137. CONCATENATING DATE AND TIME
  138. password protection
  139. function problem regarding cell range
  140. How do I get LINEST to show all stats?
  141. Counting similar text
  142. Change event fails to work
  143. Re: Select random cell
  144. How do I create a list from a large spreadsheet without headings
  145. Drop-Down Menus in Created Lists
  146. COMPUTING TWO COLUMNS
  147. how can I have Excel total a column of # that were derived by form
  148. formula QUESTION
  149. PIVOT Table
  150. Format cell to show numbers in words
  151. Help I am going crazy with this formula.
  152. Index/ Lookup formulas and fuzzy matching
  153. transposing links
  154. Showing + and - (show and hide) for rows in the sheet
  155. combobox not working
  156. Calender Help
  157. I have alot of text in a cell, I just want to see the top line
  158. IF statements and moving data to different columns
  159. options to update automatic links
  160. pivot % or column tinkering
  161. Alternative to multiple IF limits
  162. Replacing Values in Cells Via Formula
  163. How can I keep a fraction from being reduced?
  164. Hour Sum
  165. trying to link but not lose info
  166. How do i count numbers and letters to find a total count of all
  167. Worksheet template
  168. Width of drop-down menus
  169. width of drop-down menus in lists
  170. Excel student/teacher edition 2003
  171. Problem with adding time values
  172. Is there a function that gives us the last day of a month
  173. mail merge. interest rate numberic format not working
  174. Is there a function to give us the highest value in a list of tex
  175. cheapest price
  176. Can I write each row to a separate file?
  177. How do i compare data fields and assign values?
  178. In Excel can you add cell A2:A10 that only have text
  179. UDF Add-in New category in "Paste Function Dialog Box"
  180. Macro With IF Function
  181. Can "IF" function display calculated data as bold?
  182. Reverse numerical values
  183. Need faster/shorter formula
  184. linkiing a worksheet
  185. CF in a filter
  186. SUMPRODUCT
  187. IF STATEMENT PROBLEM
  188. How do I change how cells are sorted in an excel file?
  189. Confusing VLOOKUP with Indirect reference
  190. Formula for markup won't change when the initial value is changed.
  191. Checking for duplicate items in list
  192. Changing Cell Color
  193. countif condition problem
  194. Using IF Function with EDATE Function
  195. Formula to compare two lists and separate non-recurring items?
  196. How to set the "to value" in GOAL SEEK as a cell reference?
  197. autofilter freeze
  198. SUMIF question with multiple criteria
  199. Columns in excel 2003
  200. how do I insert a blank row when a value changes, automatically
  201. spreadsheet spanning 4 weeks
  202. IF COMMAND WITH TEXT
  203. How do I compare excel spreadsheets, tracking the differences?
  204. prevent empty rows from printing
  205. Running Query
  206. IF/THEN Average Problem
  207. how to perform a deduplication of names on large mailing list
  208. Spreadsheet will not sort
  209. ##value error
  210. Preventing new worksheets when drilling down in PIVOTs
  211. sum>1 --> count = count +1
  212. RE: matching and lookup??
  213. questions being addressed
  214. how do I count the numbers of row that meet 2 criteria
  215. Timesheet maximum hours problem
  216. FIND FORMULA SIMILAR TO VLOOKUP FOR NON-ASCENDING VALUES
  217. matching and lookup??
  218. X axis break
  219. Formulas across worksheets do not update
  220. Location of the last "s" in a text string
  221. RE: saving documents with macros
  222. AVERAGE(IF()) problem
  223. Spreadsheets with multiple entries
  224. Need some assistance
  225. regression
  226. linest r-squared bug when calculating forced through zero?
  227. Conditional Statement in Charts
  228. Printing problem
  229. Building Formulas
  230. With formulas does anyone know the order of precedence BOMDAS
  231. Add seperate Items.
  232. Match help
  233. Linked Combo Boxes
  234. 2nd attempt ~ Faster/Shorter formula
  235. ISNA(MATCH...) and IF functions - can they be combined?
  236. forumal does not work
  237. need help with determining a formula
  238. Extract Unique Records from two lists
  239. a formula that leaves cell "empty"?
  240. creating hyperlinks
  241. Show timesheet time in and out in regular time versus military tim
  242. SUMPRODUCT
  243. Matching data from seperate excel files
  244. workday date function
  245. Excel Function returning negative 0
  246. Reformatting dates as text
  247. Colour full row in CF
  248. cell values not updating
  249. Conditional SUMIF???
  250. various values and listing them
  251. filter arrows showing when copy and paste to powerpoint
  252. best way to get reference to all used cells
  253. How to delete all defined names from a workbook?
  254. I need to link only certain cell...
  255. Validate drop down box
  256. extract year
  257. How to print from consecutive numbers in excel w/o typing all?
  258. Multiple Range Pivot Table
  259. Input Range for a List Box
  260. Using formulas/functions
  261. How do I copy information to the ascending by LName worksheet?
  262. Excel dates change
  263. Lock and unlock cells conditionally depending on input in another
  264. Formula Question
  265. Nesting SUMIF formulas
  266. Alternate Menu Shortcut
  267. How to use "CONCATENATE" function in VBA
  268. Auto recalculate?
  269. drop down for excel?
  270. Linking worksheets
  271. how to calculate overtime automatically on Excel timesheets
  272. Grouped Worksheet and Protection
  273. Help with date formulas in Excel
  274. Excel subtotals cells with a formula - HELP
  275. How do I convert an entire sheet from columns to rows?
  276. How do you use the > < funjctions when calculating negative numbe
  277. Creating a Formula
  278. IRR Calculation issues
  279. Change cell colour
  280. Re: Pivot Table Question
  281. Time Accrual; Negative balance
  282. How do I select every 5th row within a list?
  283. percentage
  284. Workbook copies itself when opened
  285. VB??.tmp error with multiple excel worksheets in 1 book
  286. Sorting data by Date
  287. Finding last value greater than 0
  288. Reference question
  289. In excel spreadsheet my comment boxes change sizes randomly why?
  290. Count Text in a Cell
  291. Swapping rows and columns
  292. Custom Menu Help
  293. Preventing Macro Flash
  294. Newbie needs help with incrementing a series of cells
  295. How do I add a symbol between numbers in a column?
  296. Can I randomise the order of a number of rows?
  297. how to add 17.5% vat formula
  298. Individual calendars for 30 employees
  299. Dynamic Range and arrays
  300. plot
  301. Find a character to sort on in an Excel cell if not the 1st charac
  302. Footer... Entering Serial Nos and incremnting daily
  303. Excel CELL bug
  304. Financial Functions
  305. £1.5m to 1.5
  306. Formula to copy rng of cells where (value is met) to anther sheet
  307. VLOOKUP function
  308. looking for latest selling price..
  309. Add excel horizontal & vertical ruler
  310. Re: VLOOKUP? Need to have value returned when select from drop-down list
  311. replace a sheet with link
  312. How to connect two columns in Excel VBA??
  313. Function newbie
  314. text to number
  315. How can I use autosave from excel2000 in excel2003
  316. is there a function for getting the content of a cell?
  317. Re: Recalculation taking a massive 11 seconds
  318. sum of last 7 numbers
  319. using particular positions within an array
  320. IF Function to test formula in a cell
  321. formulating a balance when a loan payment is made
  322. Display text > 1024 characters in a cell
  323. Counting text across multiple sheets with a specific criterion
  324. help me getting value of column based on condition
  325. Formula problem.
  326. Performing Math with Time over 24 hours
  327. How can I sort one column and have the entire row sort. (binding)
  328. frequency formula with criteria
  329. Auto Sort using Macro
  330. Q - Excel 2000: How to refer to worksheet in the same book?
  331. Using the RATE function in Excel, I get a NUM error.
  332. Excel, turn off the hyperlink format when formula is @sum
  333. If function for workday & weekend
  334. Macro Help
  335. How do I subtract using formulas?
  336. Renaming Sequential Rows to create serial numbers
  337. Conditional Functions
  338. Conditional Functions
  339. Conditional Functions
  340. Average to date
  341. combining a Vlookup and Mid formula
  342. auto insert invoice number that increases by one each time opened
  343. sequence of numbers
  344. Help formatting cells
  345. part number with 'E'
  346. help me please on if function
  347. Is it Possible
  348. What is a function in VBA EXCEL witch finds a string like "not" in cell and then deletes a row with this cell?
  349. Countif with more than one criteria
  350. An Inquirey on the Round function
  351. combo Box
  352. Help!!! Vlookup!!
  353. Date format
  354. Summing large numbers...
  355. in excel tel diff. b/w 01/05/2006 and 28/02/2002 date wid formula
  356. formula that compares different ranges
  357. Re: World Clock
  358. Re: World Clock
  359. Working with data?
  360. count G4:G51 for critera only if D4:D51 contains text data
  361. How to make an input in one column determine dropdown list in anot
  362. can you use countif function for noncontiguous cells
  363. Spinner Control Properties
  364. Suppress array formula #NA
  365. Auto Inserting numbers
  366. Can I use a Reference inside a SUMIF or COUNTIF Function?
  367. How to repair 2005-2006 student attendance record?
  368. Macro to replace data within a worksheet
  369. if data in one cell, then date in adjacent cell
  370. hyperlink changes when doc emailed
  371. Time Card Show Up Time
  372. How to convert 250minutes into the format of hh:mm:ss in Excel?
  373. extract numbers from cell containing text & numbers
  374. Re: Text string and sum
  375. Re: Text string and sum
  376. Force format change in excel
  377. Multiple countifs
  378. Select rows based on criteria
  379. Write cell info to external file
  380. macros
  381. Condense formula
  382. Multiple if or multiple vlookup
  383. how do you make negative numbers show up as 0 in Excel?
  384. Re: Text string and sum
  385. Combining SUMPRODUCT and RANK functions
  386. Excel Ranges & LEFT
  387. how do I sort email address by ISP?
  388. Averaging Values between Two Dates/Times
  389. Autofilter Locks???
  390. Autofilter Lists across Multiple Sheets, Maintain Correct Referenc
  391. Unable to sort data in excel with cells containing if & hlookup
  392. Count excluding Duplicates
  393. Can I make rows of an excell spreadsheet 'selectable' (on/off)?
  394. Creating Formulas In Excel To Calculate Time Intervals
  395. spell out amount?
  396. How do I JUMP from pane 1 to Pane 2?
  397. why does the toolbar have a button, $ and is said currency,it giv.
  398. PLEASE HELP--going crazy with a simple calculation
  399. EXCEL OPENS THE SAME FILE TWICE, HELP!
  400. how do I autofill an excel worksheet with contacts from outlook?
  401. Merging worksheets
  402. sort in excel using end of email address
  403. Conversion Fee Rate Calculator with cap
  404. I want xl to look up postalcodes and compare them with another she
  405. Not to sure
  406. Referencing cells in different worksheets
  407. Limitations od Excel Sheet
  408. how use range to bottom of filled cells?
  409. Scheduling employees by dates... LOOKUP or FILTER?
  410. formatting date-time values in macro
  411. todayif??
  412. How do I get cells on a sheet to automatically fit data?
  413. Simple Formula (I thought)
  414. Can I apply a "score" based on multiple cell values?
  415. formula needed to track dates event happened
  416. can an array do this.....
  417. Comments in cells
  418. Formula in a writable field
  419. Automate a date referenced in a formula pointing to another sheet
  420. extracting data
  421. Number of work sheets
  422. Adding a formula within a formula
  423. Computing a date range
  424. Digital Signature Visual Evidence
  425. Comparing 2 columns if they are the same
  426. help me on tough sum on conditions issue
  427. Formula
  428. One line of list show up in different sheet
  429. Excel Help
  430. " / " Changing Decimal number format to Fraction on Protected Cell
  431. need help righting script to sort rows alphabetically then seperate them to line up
  432. looking up names in a list
  433. " / " Changing Decimal number format to Fraction on Protected Cell
  434. Roundup or rounddown
  435. how to use sumproduct
  436. Converting column & row numbers to a cell reference
  437. multiple formulas in one cell
  438. wrong year
  439. make custom formatting permanent
  440. removing unnecessary spaces from multiple cells
  441. Column A = X, Column B =y count = count +1
  442. To copy values in a column relevant to text in an adjacent column?
  443. Is there a function?
  444. Compare range with another range in other workbook
  445. Sorting on cells containing HLOOKUP
  446. Calculating elapsed time
  447. multiple criteria ifcount()
  448. Hyperlink problem to cell in same workbook
  449. Another Date issue.
  450. How do I calculate a formula once
  451. 2.3345 I want to find out what the last 2 digits are, i.e. 45
  452. Matching when spaces are involved
  453. Forms Toolbar in Excel 2003
  454. Count rows if date is between two specified dates
  455. search funtion
  456. Count multiple occurances in a column
  457. limit cell value by date
  458. my sumif statement brings back mutiple answers, how do I fix it?
  459. If a cell is modified after a date; font color change indicate
  460. Conditional Formatting-can a "then" be placed with the "if".
  461. How to generate #'s that excludes certain numbers?
  462. In EXCEL 2000, when using the Filter feature
  463. sales tax
  464. How do i set up a running balance on one row?
  465. How do I create a formula for a quiz in Excel?
  466. Value in cell refers to value in another cell
  467. how can you convert hours into minutes?
  468. want highlight when all cells in range are equal
  469. find same amount in different workbooks
  470. Lookup
  471. What formula do I use if I need to look at the column and row?
  472. What causes a workbook sharing violation?
  473. Re: vlookup problem, possibly due to "noise"
  474. Help with complex VLOOKUP
  475. if command for yes or no
  476. How to sum data that is only within a specific number range?
  477. Can I use SUMPRODUCT for this?
  478. Averaging a Value Between Two Serial Dates
  479. Formula Workdays-Holidays-adjustments
  480. I would love to be able to put a wrap text button on my toolbar.
  481. How can I sort in groups of 3 rows?
  482. How to correctly write a cross-sheet "IF" formula in Excel
  483. Is there a macro to convert times between 2 places dep. on date?
  484. Identify missing record numbers
  485. removing pre-set characters from comments
  486. How do I sort and put a space between each sorted choice
  487. Multiple worksheets
  488. Transferring data between worksheets
  489. Excel filter dropdown shows all data
  490. How do I prepare a debt acceleration worksheet in Excel?
  491. Entering Same Formula to A Full Staring from Say Row 5 Column.....
  492. Cell text based on 4 condition test
  493. how do i name a excel worksheet and make it appear in cell a1
  494. How to get date averages
  495. conditional fraction - sumif?
  496. countif problem - am I bonkers?
  497. countif followup
  498. Discrete "Normal" Curve Function?
  499. How can I call a macro or form. in the moment that enable any shee
  500. Icon for "Wrap" and for "Centre Across Selection"
  501. How Can I call any form or macro..
  502. vergelijken tabblad naam met waarde uit cel
  503. how to change a list of possitive numbers to negative
  504. how to change a list of possitive numbers to negative
  505. Multiple Criteria for COUNTIF and SUMIF
  506. Holiday Dates
  507. How to change number to text in new column from another worksheet?
  508. how do i set up an auto format in MS Excel
  509. Select cell containing specific text &return value from another ce
  510. Find and copy part of a cell
  511. Totals
  512. Conditional Formatting
  513. Display Part of the cell value
  514. Inserting rows into worksheets that are protected
  515. How to project usage.
  516. How do I set up an "IF" formula?
  517. How to add a column of accumulated data in pivottable?
  518. Date(Y,M,D) 'feature' or problem?
  519. Macros
  520. Significant digits
  521. Formula help
  522. How can I delete source links and change the current sheet accord.
  523. Nesting Index and Match Functions
  524. Conditional Lookup?
  525. formula that will go up one space if no value in specified space
  526. Selecting the i-th element from a range
  527. Problems losing changes in shared workbook
  528. Keeping A SpreadSheet in Front
  529. Excluding cells
  530. Running a macro if any data is entered in a range of cells
  531. Sorting and Adding Space
  532. "IF"- "THEN" type Formula based on Null value
  533. Constructing range address given row and col numbers of boundaries
  534. Vlookup and forecast
  535. If formula result is false, how do I auto-delete that rows?
  536. FLOATING CELLS
  537. how do i set up a template with noise Assessments cross ref R/A
  538. Text is being converted to Date
  539. =SUM(A1:A5)*24 for totalling hours and minutes is not working
  540. Referancing differant sheets
  541. is there a memory plus (like a calculator) fucntion in excel?
  542. Counting cells base on a predetermined range
  543. How can I calculate user input from a combo box into a formula?
  544. countif
  545. Formulas
  546. RE: Does anyone know how to turn off the GetPivotData function?
  547. change values globally
  548. Selecting specific row/column from a named range
  549. MAX function for a given Position Title
  550. Formula Needed...
  551. data sorting
  552. Bug in help for Excel SUMIF function
  553. How do I write the formula to calculate someones time worked
  554. Return Array with Array
  555. Sumif or Sumproduct
  556. copy and paste between cells that have data
  557. Merg Worksheets
  558. Converting decimal calculation to h:mm format
  559. RE: DateDif problem
  560. Help summarizing data needed
  561. If ? maybe.....
  562. DateDif problem
  563. how do I count the number of times text in column A matches text i
  564. Does anyone know how to turn off the GetPivotData function?
  565. RE: Converting a number to a letter in Excel
  566. INVOICE COUNTERS
  567. INVOICE COUNTERS
  568. RE: Replace cells with blank
  569. Converting a number to a letter in Excel
  570. VLOOKUP issue
  571. VLOOKUP issue
  572. Replace cells with blank
  573. merge worksheets
  574. Search for record with specific name in a cell
  575. "FIX" is displayed on status bar
  576. Return entry in column above/below cell
  577. how do you link rows of cells to other work pages?
  578. I would like to print the titles of files inside a folder.
  579. lookup & match solutions
  580. how to diferentiate integers with decimals in the IF formulas
  581. vlookup and match combined?
  582. program to open excel sheets without excel
  583. How do I find....
  584. Is there a logical test for a cell's format instead of contents
  585. Having trouble with vlookup and match
  586. Function determine if date is even or odd
  587. Using Excel in different countries
  588. TEN OLDEST DATES
  589. problem with FIND
  590. IF NOT FOUND
  591. How do I bring totals from one worksheet onto the second worksheet
  592. Date format issue
  593. how do i list the name off all my worksheets on a sheet
  594. How can I globally set "error message" parameters in Excel
  595. excel help
  596. Re: Logical formula problem
  597. Excel Cell Criteria Effect
  598. sumproduct
  599. trying index match
  600. liked workbook
  601. calculations in excel
  602. Problem with Slow ReCalculation of Dynamic Range Using OFFSET
  603. formula
  604. Shipping price, maybe challenge of the day
  605. Re: Database
  606. LIST function
  607. calender drop down in an exel sheet
  608. challenging "share stock" average prices
  609. how do I make rows and columns appear when I print a spreadsheet
  610. averging prices real problem
  611. Use Index to get range
  612. text modification
  613. Lock cell entry
  614. how can i ignore blank cells when multiple cells?
  615. Dates in Excel
  616. eliminate partial content from the cell
  617. Inserting graphics in protected worksheets
  618. SUMIF question (I think)
  619. How can I automate something to be added to a formula in excel?
  620. Converting numbers to text
  621. DEMMAGE FILE
  622. How do I highlight duplicate data on a spreadsheet?
  623. help on lookup functions
  624. Formula that sums the values if you have 2 criteria and 2 differe.
  625. Problem with random inputs
  626. How can you add an "&" in a footer?
  627. How do I copy comments into cells
  628. Checking a number of sheets
  629. search for text within text
  630. Count Function
  631. Formula for inserting blank row
  632. How do I convert hours and mins into just minutes in excel?
  633. Date from text to Date format
  634. Summarizing worksheets
  635. separate name and address
  636. IF formula
  637. function to insert a picture
  638. Automatic Date Update
  639. multiple Lookup
  640. Validation Help
  641. SUMIF 2 conditions are met???
  642. Combine 2 formulasinto 1.
  643. import with locked cells?
  644. comparing columns
  645. Are different column widths possible on the same worksheet?
  646. Conditional Formatting
  647. find all combinations of cells that add up to certain number
  648. Match and sort
  649. Protection of worksheet / merging Cells
  650. Count According to Date
  651. lottery drawing
  652. Count nonblank cells with multiple criteria
  653. why does sorting large columns create errors in top selection?
  654. Refresh Button
  655. Globally change relative-addressed hyperlinks to absolute-addr
  656. Can I do this?
  657. Reference Cell Content
  658. RE: Seperation of prime and sub inventory units
  659. Lookup values in one column to return another
  660. What is the formula to average alpha?
  661. Count if a number is between X and Y
  662. how do I calculate a monthly payment based on a variable rate?
  663. colour due to conditional formatting & hyperlink/shortcut to a directory
  664. LOGICAL FUNCTIONS WITH MULTIPLE VARIABLES
  665. In excel, how can i delete 1 digit and the decimal point?
  666. Mode between two serial dates/times
  667. Delete first two digits in column
  668. drop down option in a cell
  669. drop down box in cell
  670. Drop Down List
  671. Is there a way to automatically change the location of a formula?
  672. Cascade Validation
  673. Look Up Values Within a Range
  674. How do I fix a link
  675. Formulas
  676. ??SUMPRODUCT? other solution?
  677. counting number of times value is greater than previous week
  678. How to convert minutes to fractional hours
  679. Using worksheet functions in macros in Excel2000
  680. IF statements with more than 7 variables
  681. getting active cell value in another cell
  682. countif and concatenate
  683. How do you write an excel formula to sum data in every second cell
  684. tagging / tracing / referencing duplicate values
  685. drop down list in Excel
  686. Dropdown list with named cells
  687. Identifying #N/A cells
  688. Allow more than 7 nested IF THEN tests in EXCEL. Allow 30 or more
  689. display words in a formula result in Excel
  690. Append instead of Replace in Merge Workbook?
  691. Need help with Excel formulas
  692. another sumproduct question
  693. count on condition / Formula
  694. networkdays
  695. $ definition
  696. Calculation within Text
  697. VLookup Issue
  698. How do I save my 'sort criteria' in an Excel file?
  699. Can a calculation ignore text if it occurs in formula's cell range
  700. formula to insert picture
  701. Macro to delete rows with same data
  702. Purge or transfer old data automatically?
  703. link spreadsheets together to summarize
  704. Multiple Vlookups
  705. nested if functions in Excel 2002
  706. Effective interest paid - need formula/function
  707. Help please
  708. Combining columns?
  709. Auto-copy the last entry in a column to a new cell
  710. IRR Logic
  711. vLOOKUP
  712. Updating the Sum of a cell
  713. Inserting fillable Rows within a Protected Worksheet
  714. How to show sheet tabs in Microsoft Excel
  715. Arrow color on Autofilter
  716. How do I convert text to time
  717. Insert-Subtotals makes Column Outlines disappear
  718. barcode scan changes last 2 digits in excel 2003
  719. Why does Excel 2003 convert JPG pictures into PNG format?
  720. vlookup
  721. EXCEL FORMULA
  722. Why am I able to type in a cell that is locked and protected?
  723. How do I create a function to search a range for a number and...
  724. Excel 2002 Lookup formula returning wrong results?
  725. It is some functions who insert rows?
  726. total a range of cells in Excel into a different worksheet
  727. I want to be able to count the number of checked boxes in a form?
  728. vlookup and calculation questions
  729. Counting based on values in two columns?
  730. vLOOKUP
  731. Updating the Sum of a cell
  732. Help with a f(x) formula
  733. Why can't I write in a document that is not read only?
  734. I get 0:00 when I format cells 4 time no matter what # I enter
  735. Adding hrs
  736. Linking Data
  737. Summing Arrays
  738. delete series of letter in spreadsheet
  739. how do I lookup data based on two columns of data
  740. Dates
  741. Linking Webpage to Excel Data
  742. Regression - Standard Error X Variable 1
  743. SUMIF with two conditions?
  744. How to add all positive and negative numbers?
  745. 2005 to 2006 calendar?
  746. Finding values
  747. Help on getting data from two worksheets
  748. working
  749. double records
  750. Drop Down Lists - assign a value based on selection
133