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

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