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. price higher than...
  2. Re: vlookup formula
  3. Automated summaries/conversion
  4. COUNT IF <> ""
  5. Autofilter and Subtotals
  6. easy
  7. How do you get the function of a pivot column to not appear
  8. Double and Multiple Lookup Using the MATCH Function
  9. protection de-activating tab-naming code
  10. how can I highlight a cell if it meets year and month criteria
  11. pls help with IF formula
  12. Make a formula to calculate the avarage of baseball stats
  13. is it possible to apply template to a existing worksheet
  14. Forms controls
  15. Excel extending result to multiple decimals
  16. Does protecting a workbook shut off VBA code?
  17. combine 111 in one column & .jpg in another thru out entire works
  18. Results of conditional formatting not what desired. How do I corr
  19. fill in data range knowing start and end values
  20. vlookup vs. if, help needed
  21. vlookup vs if, help required
  22. sumif function
  23. SUM of INDEX lookups
  24. How do I show numbers in Excel as 48K instead of 48000?
  25. Rounding issue with Goal Seek for IRR
  26. Is there any way to rotate the a field or cell 180 in excel?
  27. NVL type function
  28. How does Excel allow for leap years?
  29. IF Statements-call private sub
  30. How can I sum data on a row from certain named columns?
  31. Using nested IFs with CountIf
  32. Find a value and return a corresponding number
  33. How can I use an IF statement to find out if the cell is shaded?
  34. UserForm Save Issue
  35. Array formula using two columns and countif
  36. Gas Mileage
  37. Index function using multiple values in one cell
  38. Multiple sheet
  39. Several Countif criteria
  40. How can I count the number of times a letter repeats in a string?
  41. Excel
  42. count number of letters in a string
  43. IF Statement help please
  44. Copy a Workbook Automatically
  45. Match and merge on new worksheet
  46. How can I change the color of the comment indicators?
  47. Re: Is this formula going to work?
  48. Copying Sum Formulas
  49. FORMULA for COUNTING #S STARTING WITH A 4 IN A RANGE 1 TO 100,000
  50. IF Statement help please - again - got it wrong last time!
  51. Trnasferring/ Copying Data Between Sheets
  52. sum only visible cells
  53. Extract information from the list
  54. 2nd to MAX
  55. If's conditions about matching
  56. IRR formula for monthly cash flows
  57. Returning a Value if 3 Conditions are True
  58. How do I make hyperlinks?
  59. Summing every third cell
  60. V-LookUp help
  61. "000" + number + "."
  62. Create my own formula?
  63. linking to a cell within a text cell or comment
  64. If Match Part of Text Within Cell, Then Blank
  65. assign formula to another cell
  66. can you count data in a cell to give a value?
  67. Simple Circular Reference Problem
  68. How do I input a minus time in an excel spreadsheet
  69. Modified /advance "Max function "may help!!
  70. How do I get a line break when using a formula to combine cells
  71. How to incorporate cell data in a worksheet header
  72. Calculate Elapsed Date and Time
  73. in data/filter/auto filter
  74. Sort Problem - Please Hurry!!
  75. Unlocking "check box" control function
  76. Time calculations
  77. Break Even Analysis Help --dza
  78. COUNT and OFFSET
  79. Excel, how do I count cell with data within a range?
  80. using IF function to copy, but leave populated cell alone
  81. How to auto hide and unhide columns using 1 and 2 icons
  82. Reference to Worksheet name
  83. Macro command control by date
  84. Seperate cell string into individual cells
  85. Copy all records matching "Text" criteria to new worksheet
  86. Arrows And Formulas
  87. Validation List
  88. Need help with two cell accumulator
  89. Tick Boxes
  90. Multiple IFs prior to Count function
  91. "IF" Formula Query
  92. Help - Auto update from multiple spreadsheets
  93. Ascribing Values to Symbols
  94. Using a macro to create a macro in another workbook
  95. IF Date range formula
  96. Data Filter and AutoSum
  97. compare adjacent cells and calculate averages
  98. Filter record on color scheme
  99. template for taking customer food order
  100. How do I vary the conditional formatting?
  101. How to select automaticly the last cell not empty of a area?
  102. Adding Text from seperate columns
  103. Most Current Date
  104. big list of values to averaged smaller list?
  105. Need help with possible formula
  106. How can I link sheet to the certain Excel document
  107. INDEX / MATCH problem
  108. About Sheets
  109. Is This Possible? - Data matching
  110. Merging 2 cells together and prefixing
  111. SUMIF with 2 conditions
  112. excel export
  113. min and max in a sequence
  114. Macro Help for Saving a file
  115. Is it possible to merge data from two worksheets?
  116. trouble with viewing fill color and font color
  117. IRR for 2 cash flows
  118. Right-click inside of a cell
  119. Several worksheet tally by name
  120. Choosing data based on Match to several items
  121. Increasing values in Price column
  122. How do I create a formula that makes text in a cell = 0
  123. Finding duplicates in 2 worksheets
  124. Find
  125. Capital
  126. RE: Otto M. - Data Matching
  127. Split 2 words
  128. select all worksheets in formula (wildcard)
  129. change display format for excel folders and files
  130. new romanian currency (ron)
  131. =TEXT(I21,"MMYY")
  132. Filtering numbers in a column?
  133. Macro - Auto Run
  134. age formula
  135. Formula Fill help
  136. eXCEL ENGINEERING TO ARCHITECTURAL MEASUREMENTS
  137. How do I setup dynamic linking between worksheets ie. T-O-C
  138. Three new functions that should be part of your standard set
  139. floor function
  140. Insert Criteria Based on Current Month
  141. Finding last used
  142. COUNTIF Formula in Excel with two conditions
  143. Compare name and copy from closed .csv files
  144. Count ; in cell
  145. How delete formula bar and retain the computed number in a cell?
  146. Excel: How to import multiple XML "Repeating child elements" same.
  147. Formula Help
  148. if column 1=>3 then column 2, if not return no value-Help?
  149. Ranking
  150. Employee Performance based ratios
  151. Running averages and time stamping
  152. Running averages
  153. deconcatenate
  154. How to make only the cells i need active
  155. ActiveDocument object not recognized
  156. weird recalculation of user defined function
  157. Formula for totaling column
  158. In a column of numbers I need a function to find the last entry
  159. 3-D References and Link Updates
  160. ASSIGN NUMERICAL VALUES FOR LETTERS in EXCEL 2003
  161. Manual AutoFilter - Vlookup, Index, Match, Array???
  162. How to return zero for an equation = < 0/
  163. Break up my URLs? Can't figure it out...
  164. Help with Date Formula
  165. text & number sequence
  166. Newbie, Countif Question
  167. help with vlookup, wildcards, multiple searches
  168. Newbie Date cells so most recent is on top
  169. Cell Reference in formula
  170. INDIRECT lookup of sheet names
  171. how do I apply 10% gray shade to a cell in Excel?
  172. HOW DO I FORMAT WORKSHEETS IN A WORKBOOK TO NUMBER IN A SEQUENCE?
  173. columns reversed
  174. Polynomial equations
  175. Graph orientation
  176. Cross Reference between sheets
  177. Auto Virus Scan
  178. calculating moving average
  179. excel symbols
  180. Modified Average Function
  181. min and if again
  182. Tagging a column
  183. tagging info
  184. from Excel to TXT file
  185. Nested Vlookup and IF function????
  186. My first macro - doesnt work - function not recognised
  187. What buttons do I need to push in order to switch between sheets?
  188. comparing a cell to a block off cels
  189. On excel, my formula will not calculate and add info into cell
  190. Formula
  191. how can I split one cell's data into two cells?
  192. VLOOKUP from closed file using INDIRECT function
  193. Deleting/rasing a column of numbers??
  194. How do I autofill conditional formatting?
  195. Creating a formula
  196. aa ab ac....ax ay az....ba bb bc....zx zy zz ?
  197. How do I auto fill an entire spreadsheet at once?
  198. Matching numbers witin a series
  199. How do I get the last number from a specific column
  200. Excel Linear Regression by set slope (not intercept)
  201. ROUNDDOWN but calculate actual numbers
  202. "IF" Formula Query...
  203. copying adjacent cells with formula
  204. SUMIF using 2 Criteria in 2 columns
  205. ranking in a dynamic range help needed??
  206. Combine all the data's from different sheet to one sheet.
  207. Help with Date Formula
  208. Deleting the same character automatically in each cell
  209. Importing Problem
  210. I want to add up the amounts from 1 cell in a folder of files
  211. sort and return column numbers
  212. Solver problems
  213. Changing the case of text data
  214. error message: merged cells must be same size
  215. function question
  216. How can you save a spreadsheet with a date stamp.
  217. Recalculation
  218. Sumproduct Question
  219. SAVING DATA TO CLOSED WORKBOOKS
  220. Show data dependant on selection from drop down box
  221. How can I isolate a lookup vectors but not values from autofill?
  222. if/and statements
  223. vlookup and subscript text formatting
  224. Formala to find the best/latest signal
  225. Consolidate multiple workbooks into a single worksheet
  226. Lines around cells
  227. Function that returns the page number a cell falls on
  228. How can I save xls files to 'E:\'? I have no floppy disc
  229. running total by date (not sorted by date though...)
  230. Moving Data Question
  231. Mode
  232. HELP WITH FORMULA
  233. Splitting cells using formula; RIGHT/LEFT not applicable
  234. data validation: formula for validating only multiples of 10
  235. Excel In-cell Enhancements
  236. Excel Grouping Enhancement
  237. How do i retreive data from another worksheet to a current one?
  238. Between Function
  239. VLOOKUP problem
  240. Macro or function
  241. Merging a full column into a single cell
  242. Automatically Refreshing Data at 12am
  243. Combining Ranges
  244. How can I bring forward formats with Vlookup?
  245. vlookup display
  246. If then statements?
  247. Counting
  248. How do I convert run time(45,502h 30m) to number 45,502.5 ??
  249. How do I find the earliest dates in a range of dates?
  250. Finding the Last Working Day
  251. vlookup returning a #N/A value
  252. Conditional sum
  253. shortcut to insert cells
  254. combining two formulas
  255. How Do I Combine Rankings for Multiple Categories?
  256. History worksheet - can it remain viewable after saving?
  257. Averaging Golf Scores
  258. checkbox event handling function
  259. open a query automatically
  260. Search array and return element No
  261. Refreshing when opening a file from the "File" Menu
  262. Countif with range name
  263. Help please!
  264. how to name the selected cells in a sheet?
  265. Compare 4 columns?
  266. Formulas
  267. formula
  268. Count Specific word in specific range
  269. Count coloured cells in a range
  270. NUMBER OF YEARS BETWEEN TWO DATES - HOW TO GET
  271. How to simplify "multiple if" formula
  272. SUMPRODUCT with two criteria and range
  273. Lookup using more than one criteria
  274. Re: Is there anybody who can hlp in the function making!!!
  275. Re: Is there anybody who can hlp in the function making!!!
  276. Can a VLOOKUP use two items to search
  277. subtracting (extracting non-duplicate items)HELP!!
  278. If question I think
  279. July - UK Excel User Conference
  280. strange behaviour with matrix formulas
  281. Removing Spaces from string
  282. Automatically Refreshing Data at 12am
  283. Is conditional formatting only blank, unused cells possible?
  284. OnTime VB
  285. Re: multi column of sumif
  286. Formula Help
  287. function help-keeping data from true when false
  288. Microsoft Excel
  289. date function
  290. Dynamic reference to another sheet?
  291. how to set number of characteres on a cell
  292. Range Name C
  293. Excel functions names should be in English for all Localized versi
  294. how to maintain hyperlink between worksheets after sorting
  295. Assign number to every value in a data range???
  296. Conditional formatting based upon array
  297. In Office 2000, How do I delete multiple blank rows at one time?
  298. pattern matching possible?
  299. check boxes from the forms tool bar
  300. data validation
  301. Format new Lines into Columns
  302. vlookup with variable col_index_num
  303. DCOUNT WITH MULTIPLE CRITERIAS
  304. ifsum function question
  305. Columns A - BY and 336 rows.Too much to filter&sort?Lose info.
  306. Columns A - BY and 336 rows.Too much to filter&sort?Lose info.
  307. Vlookup problem
  308. How do I countif the criteria is a nonblank?
  309. How do I create a running total (balance) in a pivot table?
  310. Can Excel add working days to a date to result in another date?
  311. Locating First and Last Cell Containing a Specific Value
  312. Average
  313. Trim file name only
  314. keeping cell format with formula
  315. Dynamic Hyperlink
  316. 3D formulas
  317. How do I set up a spreadsheet where it will automatically update?
  318. finding last row in a fixed section then sort
  319. Worksheet Command Button will not work
  320. sumif and then regular equation to non selected cells
  321. I put in 19 the formula is ok but if i put in a566 it returns #N/A
  322. Slow Calculation
  323. Excel solver should allow "equal to" value to be a selected cell.
  324. To XIRR or Not To XIRR
  325. nested IF w/ LEN and ROUNDUP??
  326. excel exact command should not be case sensitive
  327. Changing relative to absolute for a column
  328. CUMPRINC workaround for Excel users without feature installed?
  329. I want to place a "x" in a cell and give it a value of 1 (Excel)
  330. Reference Cell Color From Other WorkSheets
  331. Help extract numerous text files and how to use avg formula
  332. If formula
  333. Setting up dates
  334. Find duplicate entries within mulitple worksheets, then listing th
  335. Refusal to calculate
  336. Divide numbers and distribute evenly.
  337. Sumif & Dates
  338. Not sure how to ask
  339. MS Excel 2003
  340. Reverse lookup
  341. Converting Getpivotdata function in Excel '03 to Excel '00??
  342. Help me please. How do I delete custom number formats?
  343. copy range from one workbook to other in C#
  344. need help creating a Worksheet_Change code
  345. No. of digits accepted in one cell
  346. Want a serious muslim match?Join our club and start searching now!!!
  347. Want a serious muslim match?Join our club and start searching now!!!
  348. Complicated formulas
  349. working out quarters (three-month periods) between two dates
  350. Formated Print Area in WEB page.
  351. Offset Function
  352. Combining formula and cell reference
  353. Double IF - is this possible
  354. Sumproduct question?
  355. Is this formula 100*(PRODUCT(1+C3:N3/100)-1) recognised by Excel
  356. How to use complex criteria in SUMIF()
  357. calling up cells from a table.
  358. Summing range that contains text
  359. insert formula
  360. how to insert month date year and day of week
  361. Help with Formula
  362. prepaid/depreciation formulas
  363. MIN function
  364. formula help
  365. Need a shaded row in Excel that doesn't move as data changes
  366. Lookup Funtion
  367. Excel Dates
  368. A Challenge: Detection of first and Last +ve number in a range
  369. Can I get Excel to calculate hours:minutes when sum exceeds 24?
  370. Lookup Question
  371. Format 000-00000-00000-000 and recognize leading zeros in Excel?
  372. save/copy wb
  373. How to Limit Cell Values to Multiple of 10?
  374. change lower-case to upper-case
  375. Column of Data - Set Next Column Value Conditionally
  376. RE:Column of Data - Set Next Column Value Conditionally
  377. Macro Auto Run(2)
  378. Incremental Formulae in Excel
  379. Lookup based on two conditions
  380. Lookup dates, fiscal period table
  381. convert formulas to values
  382. Removing the last two digits of a cell
  383. lookup data in array
  384. How do I determine who will be age 55 by 12/31/2007 and 6/30/2009?
  385. Excel Formula, who will be age 55 by 12/31/2007 and 6/30/2009?
  386. How do write a formula so that only rows with info prints?
  387. sumproduct
  388. Center text across rows?
  389. Phantom documents saved from shared workbook
  390. REF# error using VLOOKUP
  391. Subtracting Date/Time pairs
  392. How to consolidate worksheets (1 file) with different headers?
  393. set up a link that updates page one from all other page entries?
  394. Can CELL Return Multiple Data Locations?
  395. Merging worksheets into one
  396. How do I conditionally format only some of the text in a cell?
  397. Existe un error en la nomenclatura de las formulas financieras:
  398. Can I import a .xls spreadsheet into my wordperfect address book
  399. sum of if formula
  400. Drill Down Formatting
  401. Match
  402. How can I insert a new information between two rows?
  403. Conditional Formatting - Thick Border?
  404. Excel pivot table field settings
  405. Averaging letters
  406. How to copy several wkshts into one worksht with formulas?
  407. protect excel wrkst but still be able to use grouping and lists
  408. Automatic League Sort
  409. Hide Blank Rows
  410. How to convert a repeating row of information to fit in 3 columns
  411. How to convert a repeating row of information to fit in 3 columns
  412. WHY DO FORMULAS STOP WORKING IN EXCEL
  413. Add to Summed Figures
  414. Re: Add to Summed Figures
  415. V-Lookup, column index number indicator in table array
  416. Vlookup between two workbooks
  417. If I have my sheets protected will that prevent me running a macro to hide certain sells?
  418. counting cells in two columns that have the same results
  419. Alternatives to GET.CELL and VB?
  420. Cell Additions
  421. Sort & Show Data
  422. incerting calender in a spread sheet cell
  423. Formula!!!!
  424. Date/Time Calculations
  425. Re: Date/Time Calculations
  426. ABS of cell on another page??
  427. Drop Down List
  428. SUMPRODUCT FORMULA
  429. how do I make an excel comment box bigger?
  430. compling info from multiple pages onto one page?
  431. Combine 2 cells without using the CONCATENATE function
  432. how can i make macros to work when in tools, costumize and option.
  433. more than one lookup value
  434. How do I use VLookup Function effectively?
  435. IF Statment across Multiple Sheets
  436. Sort function on Pivot Table
  437. Absolute function
  438. Re: Quickest alternative for shortcut of PasteSpecial then Values
  439. Disable Page setup
  440. How do I highlight cells on a worksheet that contain formulas
  441. NETWORKINGDAYS
  442. merging two worksheet
  443. copying macros
  444. Using COUNTIF and AND functions together
  445. Expand/Collapse Rows
  446. workbook name
  447. Newbie post - help with Subtotal please!
  448. how to insert day of the week
  449. Creating a form
  450. Workbook_open : Putting in message in titlebar (Visual Basic)
  451. how 2sum values in column C, IF 'X' & 'Y' in colums A & B =TRUE
  452. transpose links from a column to a row
  453. transpose links from a column to a row
  454. Break links automatically changes graph's date format
  455. IF statement colored results
  456. Function to Convert dollar to text?
  457. PivotTable
  458. Vacation Accrual formula
  459. How do I convert cubic centimeters to ounces in Excel?
  460. Can you perform Math functions with ActiveX Checkbox controls?
  461. I want to get a value from an array, row 1 and column 1 known.
  462. Sumproduct-multiple criteria for same range "OR"
  463. Lookup Formula???
  464. excel "Networkday" function
  465. Sumproduct with #N/A in range
  466. divide by zero
  467. Max of a defined function
  468. US states
  469. Excel Woes - Formula bug (I guess)
  470. help using lookup and some kind of ranking criteria
  471. if then function
  472. new staff
  473. adding more than one value to cells
  474. Single formula to 'sort' a list onto a second sheet?
  475. List all filenames & tab names
  476. Incorporating Cell color fill in an "if" logical function?
  477. count of tab characters in a single cell
  478. Sum and rounding functions
  479. Sorting By Row
  480. Hidden Sheets
  481. Please Help me with VLOOKUP function
  482. Replicating Text Using "=".
  483. locking column widths within a pivot table
  484. Macro wiping out worksheet
  485. convert cubic centimeters to fluid ounces and cubic centimeters
  486. How do I get the true path to server (not mapped drive letter)?
  487. Simultaneous entry of data between 2 different worksheets
  488. summary report with duplicates
  489. how do i sort a complete worksheet by sorting columns
  490. Function-Date Problems
  491. How to include data on the same sheet some in database some not
  492. Excel Web Queiries should work with protected web sites.
  493. Problem with data from cells in merge fields
  494. Need help...
  495. The formula for NORMSDIST is wrong?
  496. How do I create an "outline summary" - please see message for deta
  497. Can you convert a excell sheet to a word document
  498. cell ref in function formula change when inserting additional colu
  499. The word "calculate" is at the bottom of my spread sheet. why?
  500. Vlookup
  501. zip code to city, state function
  502. xirr value error
  503. CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY
  504. using formula with several possible answers
  505. How can I prevent someone from deleting a shared workbook?
  506. Function: cell contents formula or value?
  507. too many different formats on excel 2000
  508. Relative Value to a Vertical Lookup Result?
  509. Leap year indicator
  510. How do I combines data from multi-worksheets into one in ascendin
  511. AutoFitMergedCellRowHeight - Jim Rech
  512. Single Excel function to sort a list and eliminate dupes
  513. Counting occurance of text values across multiple worksheets
  514. How to link data from one drop-down list to another
  515. COUNTBLANK function
  516. Sheet Protection
  517. Lookup
  518. function to convert number to words [ 21 = "twenty one " ]
  519. Excel Calculation of After tax Cost of debt Plz Help
  520. Excel Formulas getting information from 1 workbook to another
  521. In excel counting cells in a range which meet condition ">Xand<X"
  522. Deleting rows from a worksheet automatically
  523. how do I add new data and have it added to existing data
  524. In Excel , How do I turn off the math funtions?
  525. have different row lables calculate formula
  526. VLOOKUP error
  527. Using Vlookuop and then calculating
  528. create template with certain fields to input information only
  529. Reference Worksheet Name
  530. Need a Formula
  531. Excel using dollars instead of sterling
  532. Automatically Re-Size Row Height
  533. Adding a space in text
  534. Displaying data from seperate sheet upon drop down box entry
  535. Validation Issues
  536. Reference Worksheet Name
  537. Pull data from multiple sheet
  538. Formula behaves differently
  539. limiting rows of text in a textbox object?
  540. Is there a formula that will add only highlighted rows?
  541. Copy data in one cell to blank cell immediately below, repeat
  542. Too many variables?
  543. Selecting alternate cells
  544. IS there a mathematical formula for NORMSINV?
  545. Selecting Cells
  546. conditional formatting for currency
  547. Conditional formatting and formula
  548. need to work out bonuses
  549. How to create a ranked list
  550. Index/Match not working
  551. Purchase order...
  552. What function will find a value in a table with X & Y Values
  553. cell data not validated if navigating cell to cell with mouse
  554. conditional moves
  555. Bubble Charts with two non-numerical variables
  556. Change a cell color based on a certain value (green or red)
  557. Conditional formatting works, is there a better way?
  558. INDEX MATCH formula
  559. Print each record per page
  560. How do add time/hours to get answer in hours if Ans>24
  561. weekly sales
  562. VB Script
  563. How do I hide the Worksheet menu bar
  564. Nested IF in this situation
  565. sum problem
  566. changing numbers into a barcode using excel
  567. countif function doesnt work
  568. formula to lookup & sum totals, given a start inv.# & finish inv.#
  569. ENTER DATA INTO 2 CELLS AT THE SAME TIME
  570. NOW function question
  571. Editing an Excel Spreadsheet
  572. seperat.buys from sells.on spreadsheet
  573. Single statement database/range processing with criteria
  574. OpenOffice Download
  575. hiding columns or rows not using the hide function
  576. Generating Simple Reports From A Master Spreadsheet
  577. sumproduct & average
  578. Conditionally formatting rows
  579. Where can I find a journal for accounting purposes?
  580. How do I bring back my worksheet tabs in Excel. Options doesn't
  581. Multiple criteria help...
  582. Conditioning Formatting - Thicker Borders
  583. How to do a basic formula for Xcel?
  584. edit bar is missing, where is it
  585. Linking and Query, Please help
  586. summary data sheet from worksheet to worksheet
  587. COUNTBLANK function
  588. using text wrap how can I type over the page break point
  589. import a variable number from a web page
  590. Sum function
  591. Where can I find a simple paying in and out with Totals sheet
  592. find minimum of range based on multiple criteria
  593. Split One Work book into several based on content
  594. month plus one - excel 2003
  595. Macro - select and paste
  596. Macro - select and paste
  597. Dynamic finding and replacing via functions
  598. Cut and paste
  599. what is formula for cubed root
  600. Linked cells refer to source one row off.
  601. find the largest value in column, put in a cell
  602. Goal Seek on PMT function give different answer than a mortgage ca
  603. Need formula help!!!
  604. drop down formulas
  605. Pivot table and counting totals
  606. edit excel pdf hyperlink using find replace
  607. changing from relative to absolute cell reference in multiple form
  608. Golf Formula
  609. can a function do this?
  610. referencing non-blank cells
  611. formula help
  612. what function to be used
  613. transferring formats
  614. HELP! countif
  615. Exist a function to...
  616. Vlookup
  617. Any function to ...
  618. inserting zero
  619. Why is that happen ?
  620. Forgot password on protected Excel spreadsheet . . change?
  621. VLOOKUP
  622. Create an increase or decrease formula with zero %
  623. HELP: MsgBox takes 99% CPU usage... why?
  624. Combo Box properties problem
  625. named range into formula?
  626. How do I hide spreadsheet range from data entry?
  627. how to use the active cell in an Excel formula
  628. how to erase all spaces in text cell?
  629. VLookUp problem
  630. VLOOKUP and MATCH w/ name search?
  631. VLOOKUP and LEN/ISNA to match names?
  632. how do I calculate the time service minus holidays?
  633. Shade a cell on one wrksht if another wrksht cell is occupied
  634. HOW DO I ALPHABETIZ A SELECTED COLUMN
  635. Summing where values
  636. countif using a range
  637. Sum total from other worksheets
  638. macros and protection
  639. Copy down
  640. How do I use indirect when referring to a named range in a closed
  641. drop down list value changes
  642. if function checking for numerical data vs alpha characters
  643. No headers & footers in the worksheets
  644. How do I sort rows w/o losing a picture
  645. Last Modification Date
  646. Exel
  647. Email and Excel Problem
  648. I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns.
  649. can an array formula do this?
  650. How to set up a formula with two false values?
  651. IF function for cell color
  652. only calculate if >100
  653. How do I hide rows in a pivot table with zero values?
  654. VLOOKUP and LEFT to match text?
  655. lookup?
  656. Excel Chessboard problem, boarders and cell shading
  657. Can I password protect worksheets?
  658. crazy triple array formula
  659. How do I parse columns?
  660. Number of Weekdays
  661. Im sure this question is elementary...
  662. SumIF - problem with Criteria
  663. Remove Characters from a cell
  664. Toggle Button
  665. Sheet 2 name is "BTB_TACTIMESHT_578162"
  666. From 1001 to 1001-1
  667. Pastable function using VLOOKUP?
  668. Counting the items
  669. Sheet Name Function
  670. Re: Macro help
  671. I want a box with the total number of times ORDER appears!
  672. Question on Format in Hour & Minute
  673. Cumulative Return
  674. Excelshouldletmechoose the format of the numberwhen I use
  675. Can I create an input bar?
  676. conditional MIN() function
  677. Re: Formula with ranges
  678. How to create independent worksheets using data in columns in a s.
  679. VLOOKUP stops working with pasted values
  680. Vlookup is displaying the formula in its cell not the result??
  681. Drawing print-out
  682. E-mail notifications from Excel based on dates in speadsheets
  683. Count non consecutive columns
  684. Help with Forecasting function?
  685. miricle lookup formula???
  686. Making Macros Available in All Workbooks
  687. DSUM or SUMPRODUCT?
  688. Random List Generation
  689. Multi Column Sum and conditions
  690. How do I make a productivity report?
  691. Macro preparing numbers to be booked (columns to be chosen conditionally)
  692. How can I calculate amount of time left based on amount spent?
  693. Retrieve values from 2 worksheets.
  694. highlighting cells beginning with certain numbers
  695. VLOOKUP
  696. Excel Help
  697. Highlight if Data entered appears in another workbook
  698. Does Excel 2000 have an undo function after using a macro?
  699. How do I automatically convert $1,234,555,678.05 to $1.5 billion?
  700. Day Of Week Formula
  701. Help with a protected shared workbook
  702. Excel worksheet Menu Toolbar
  703. Bold doesn't work
  704. formula
  705. Vlookup with variable worksheet reference
  706. Cannot chg. part of an array
  707. How do I write an auto macro to undo filtering at statup in Excel
  708. Counting the number when you have a number and text
  709. conditional formating cells i Excel based on other cells values
  710. Using CountIf with 2 conditions - help!
  711. Excel Vlookup Problems Help!
  712. Share a workbook and be able to edit drawing?
  713. Help with linked formulas & multiple worksheets
  714. If Range has certain value, add corresponding value from other col
  715. Need a 'last updated' timestamp for a web query
  716. Pulling the largest numbers
  717. Index function help
  718. Formula
  719. offset example wanted
  720. formula help please....
  721. Filling cells with absolute columns but "nth" rows
  722. How do I do this: If A+B = D+E, make RED.
  723. A formula that is too complex for Excel?
  724. Use find with Index and Match
  725. How can you change excel macros from absolute to relative?
  726. subtraction off time after midnight
  727. continue VLOOKUP to next value
  728. RE: Logical functions to calculate points
  729. Intranet Excel File...Changing Name
  730. How to sum data based on font or cell color?
  731. Re: Logical functions to calculate points
  732. Vlookup in a named range
  733. modify a template that is protected
  734. How come Word is adding zeros to a mail merge number from Excel?
  735. ERROR.TYPE formula problem
  736. wk19!$A:$O => SOME_FUNCTION!$A:$O
  737. Covariance for 3D coordinates
  738. get to a particular point in a dropdown list
  739. Comments box
  740. Re: Logiacl function with multiple conditions
  741. SEND button in Excel
  742. DateValue Problem...
  743. paste formula to each cell in a column without changing values
  744. conditional formatting
  745. Create a condition and allows a automatic comment
  746. counting with multiple criteria
  747. Offset Function
  748. IF statement with multiple values...
  749. Locate numbers in a row and send them to a cell
  750. If one cell given value others in row be made blank automatically?
133