View Full Version : Microsoft Excel Worksheet Functions


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 [89] 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131

  1. Text in formula bar is red
  2. vlookup with .csv data
  3. sum and product, but not sumproduct?
  4. Conditional Formatting and Cell Color
  5. combine multiple values in a table into one cell using vlookup?
  6. Format Time
  7. read excel with a c++ program on Unix
  8. Need quick "if" function
  9. Trying to Create a Macro
  10. How do I add a .bas into excel 2003 add-in?
  11. How do I place a footnote in an Excel cell?
  12. Menu item disabled
  13. Dates
  14. Using offset within a formula dynamically
  15. Help with converting date formats
  16. Average HELP!!
  17. Concatenate question
  18. how do i get a value to appear in the cell and not the formula
  19. Copying Worksheets
  20. Need a function or formulae that will return the current date + 1
  21. Count up each day of the week
  22. Index and Match Functions
  23. How can I use the result from ADDRESS in another formula
  24. Match and Sum?
  25. Alpha/Numerical numbers
  26. Multiple Validation Lists
  27. Formula Error
  28. Need help searching another sheet and retrieving a value
  29. Copy Date on Excel Tab to Cell In Spreadsheet and Add Year, How?
  30. Lookup to the Left
  31. Lookup to the Left
  32. Input Box Help
  33. test - sorry
  34. PULL function (Harlan Grove) - can it use Named Ranges?
  35. Round Up/Down ?
  36. Vlookup, match, or sumproduct?
  37. adding + and - numbers
  38. Trevor - Round Up/Down ?
  39. Countif
  40. Coefficient of Repeatability
  41. Spell check
  42. VLOOKUP with OFFSET
  43. Dynamic range name - odd results
  44. =INFO("Type_text")
  45. Advice on sumif - more than one criteria
  46. Compare 2 similar excel worksheets
  47. data entry criteria
  48. multiple criteria with countif or sumif
  49. VLOOKUP's
  50. Re: Absolute Values in Relative Cells
  51. Weekday
  52. Creating Multiple Entrys
  53. Is there any way to export your Chart from Excel to Word
  54. Sum columns dynamically
  55. help about function
  56. How do I give different $ value to different colums in Excel?
  57. Vlookup & Hlookup
  58. roundup by 16s
  59. RETREIVING THE SMALLEST NUMBER
  60. ADDING/SUBTRACTING FROM RIGHT TO LEFT
  61. Cont'd - Offsetting within a range dynamically - But returning a sum of all instances criteria are met
  62. Excel sees cell formulas as constants, will not solve
  63. How to fix a Excel corrupt object pasted into Word?
  64. Help to sort out filtered data from the data contained in another sheet of the same workbook
  65. how to get formula content of a cell?
  66. link form combobox
  67. RE: Absolute Values in Relative Cells
  68. Working with Pivot tables with % change
  69. Formula to find last value in a range & then offset
  70. format cell to show leading zeros and make cell a three digit fiel
  71. file path: reference to other workbooks
  72. Need Ideas for My Excel Tips and Tutorials Blog
  73. Excel Add-in for SQL Server Analysis Services
  74. Passing a row to a function
  75. How do I get more color options for fill in for cells, excel 2003?
  76. Counting calls received by time range by year
  77. combined HLOOKUP (urgent for a friend)
  78. pv of annuity
  79. How do your remove ROUND function?
  80. help today and how long since day X?
  81. +40 Hours in a Week Overtime Fromula
  82. help with functions
  83. is there any way to have multiple TEXT criteria in a 'sumif' funct
  84. How do I set spreadsheet to "open for editing" automatically?
  85. if then formulas with text?
  86. Error with linked files....Macro Problem???
  87. lock formula
  88. SUMPRODUCT Assistance
  89. multiple text criteria sum if function
  90. Excel Function for max of percentage or dollar amount
  91. Excel Sum formula for timesheets.
  92. prevent blank cell in excel worksheet
  93. Finding the average time
  94. IF function comare to identical amount but inconsistent results
  95. #Ref error question
  96. save filter
  97. How do I check for duplicates across multiple worksheets
  98. Help please... Simple calculation - with unexpected results
  99. Please Help Combine to Two Lists
  100. excel puts dates instead of numbers when typed
  101. cell background cover
  102. Nested IF Function
  103. VBA Help
  104. Comment card percentage formulas
  105. Tally The award winning accounting software full with license Keys
  106. Aquiring data from one sheet to another sheet in the same workbook
  107. Help! Forgot the password the file was saved under!
  108. Linked Checkboxes
  109. Negative Numbers to Zero
  110. NAND ?
  111. financial function ..please
  112. Auto Racing Score Sheets
  113. limiting the viewable space to the data shown
  114. how can i ask the program to convert numbers to text automaticaly
  115. schedules
  116. calculate averages
  117. function for conditional value from another worksheet
  118. SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
  119. balancing check register
  120. making a formula that will display a "word" in multile cells
  121. My excel file is locked for editing. How do I get it opened.
  122. Excel Formula
  123. UDF to convert data to code 128 B
  124. Activate the top of sheet
  125. UDF problem in converting data into code 128 B
  126. UDF for Data into 128 B barcode problem
  127. HELP with the RAND() Function!!!!!!
  128. Tips and tutorials needed
  129. Entering Data into worksheets Simultaneously
  130. Cell background color update
  131. Defaulting a random number
  132. HOW CAN I APPLY A COLOR TO ENTIRE ROW USING CONDITIONAL FORMATT
  133. Changing working days
  134. When do we use -- (double minus) in a formula
  135. Adding Spaces to the end of a value
  136. Keep formatting from one worksheet to another?
  137. Searching numbers in Worksheet?
  138. Lookup function
  139. Benifit of AREAS
  140. Retrieving Amazon product data to excel, namely books!
  141. cell fill color
  142. Transpose Data from a column to several rows
  143. Copying Data from Excel to MS Outlook in Plain Text Mode
  144. Top 5 Scores
  145. Formatting b/w Worksheets
  146. Time format shows default of 12:00 AM
  147. Search & match more than one worksheet and matching cells.
  148. Looking for command help in Excel
  149. Multiple Option Controls w/in Worksheet
  150. Conditional Format based on date ranges
  151. command button
  152. auto-numbering for invoices
  153. HELP with the RAND() Function......AGAIN!!!!!
  154. Renamed tab .xls>3 receiving a error but can't fix
  155. Rate function with #Num! result
  156. XY Scatter
  157. Formula...function...how to?
  158. Simulation in operations research using Excel
  159. Disalbe the Calcuation in Excel after vaildety date
  160. Paul B
  161. Cant quite get this formula to work:
  162. What is the syntax for referencing another sheet with 'lookup'
  163. conditional formatting?
  164. sum data in column for dates until today
  165. Written values
  166. Multiple VLOOKUP
  167. Sumif & Isblank
  168. Refresh/Recalculate a Custom Function
  169. Selecting a subset of items from a list
  170. Pull in address from another worksheet
  171. Using MATCH function does not return correct answer
  172. Dynamic Formulation with lots of sheets
  173. Adding 2 Values When 3 Conditions are Met, Including an "OR"
  174. advanced search
  175. Adding time
  176. REMOVE SORT WARNING
  177. Links to closed worksheet
  178. Display a weekly summary
  179. How can I recover data from excel?
  180. Range of data in Excel
  181. Automatically copy data from one worksheet to another
  182. How to SUM cells that contain functions?
  183. help with text sorting
  184. Unlocking excel features
  185. Lookup formula help
  186. Excel search for douplications
  187. Excel drop down box
  188. linking Outlook email folders/subfolders to excell spreadsheets
  189. I am unable to unhide certain rows in my worksheet-it is locked?
  190. How do I add specific categories from several worksheets?
  191. Get Data based on Month and Year
  192. Trim
  193. INDEX function need to have col reference to be formula
  194. Help please - Data sorting
  195. Cell Colors
  196. Filtering a Drop Down List
  197. GETTING STATIC DATE CONDITIONAL TO ANOTHER CELL VALUE
  198. Converting scores i.e. 1-0 to win, draw or loss
  199. time value
  200. Repeating background images
  201. Data Validation with Blank Date
  202. IF/THAN with regards to 2 Dropdown Lists in Excel?
  203. ComboBox Question
  204. Break Even Analysis
  205. IF function...>cell ref is a formula so True is retd when False sh
  206. CELL("filename") acting Volatile? (in assoc. with PULL)
  207. =LEFT - Cannot Format
  208. Vlookup using drop downs and table
  209. Challenge: Copy across surname
  210. How can i sort a database on numbers?
  211. Growing range within a Sumproduct.
  212. How do I get a worksheet reference to increment when copied
  213. Using 8/23/2005 with INDEX, MATCH, VLOOKUP and IF
  214. Where to find Excel sheet with Pipe & Forging charts and sizes.
  215. swap
  216. Newbie on Macros
  217. how do i count the number of times criteria appears in a worksheet
  218. Insert Name Function not working
  219. Looking up the results from the function "LARGE"
  220. how can i know that my worksheet having repeated same values
  221. how do i cancel getpivotdata in excell 2003
  222. get a runing total for"curent date"or(cell)minus prev 30 days( cel
  223. Command to count number of worksheets in a workbook?
  224. MID function from right to left
  225. How can I retrieve data from the same cell, from multiple sheets?
  226. how do I get the address of a cell to calculate with it
  227. West Coast Excel User Conference - Announcement
  228. Auto sorting Help please
  229. worksheet
  230. SUM calculation bug in Excel 2003?
  231. Weeknum help
  232. can this be done?
  233. Modifying drop-down box options and formats
  234. How to change scheduled payment amount in Excel
  235. How can I make a whole number
  236. Can't Set Minimum Y Axis Values
  237. $ value formulas
  238. COUNT
  239. Excel formulas
  240. How do I fix my Autofilter in Excel?
  241. indirect and networkdays
  242. Insert a new row when the criteria is met in the cell above
  243. Use the value of a cell within a reference to another workbook?
  244. How do I group and edit multiple worksheets?
  245. VLOOKUP - 3 Table Array
  246. Change Links/SumIf function
  247. My Hyperlink bonks out after I save the file!
  248. How do I unhide column A of an excel spreadsheet?
  249. Formula to choose cell and then cell three rows down
  250. How do I set multiple parameters using VLookup
  251. how can I use excel to tabulate survey results
  252. how can I use excel to tabulate survey results
  253. how do I write a formula to pick a date or N/A?
  254. How do I reference the same cell, but in different worksheets?
  255. IF Column A contains "xyz" replace with...
  256. Making a column of numbers created from a formula permanent.
  257. Excel 2003 Macro
  258. Date Problem: Between 2 dates
  259. IF function
  260. VLOOKUP question
  261. Sum Product if? Three columns
  262. Excel should calculate large workbooks more efficiently
  263. Time formulas in Excel
  264. How to remove footers all Excel docs at once.
  265. Problem w/Array Formula
  266. How to find last filled in cell in a column?
  267. copying formulas from one file to another
  268. Look up for a range, Possible?
  269. Advanced filter
  270. summing cells with text and numbers
  271. Column Names?
  272. Searching numbers in Worksheet
  273. Excel Calculator always requires an = before a math function, can be turned off setting?
  274. Multiple dynamic ranges in a Sumproduct
  275. Multiple dynamic ranges in a Sumproduct
  276. Format number to Time in Excel?
  277. Nested And function
  278. Unique Entries with Conditions
  279. SUM if cell is Bold
  280. Spaces in cells
  281. comparing multiple columns
  282. Changing of Colour if my condition is "High"
  283. 360 day calendar function
  284. Urgent - How to using formula to compare 2 worksheets
  285. Cell identification for a 'lookup'
  286. LOOKUP?
  287. Paste special doesnt have values
  288. Conditional Formatting
  289. Change pictures in Excel?
  290. Need your help urgently
  291. Cell Custom Formatting
  292. Need field at top to float down as I scroll down?
  293. Getting a chart to stop if the formula resutls in a blank cell
  294. comparing multiple columns
  295. How do I get just 1 cell to display it's formulae not whole sheet?
  296. List when worksheet protected
  297. More Excel Tutorials/Tips Required
  298. Copying contents from multiple sheets onto one
  299. HOW TO GET A DESIRED 'SUMIF' RESULT FROM A FILTERED DATA
  300. Counting Data from Another Worksheet - Countif
  301. Simple If Statement
  302. How to use address from relative reference across worksheets?
  303. How can I count IF, then, else statements that have values?
  304. Can I pick more than 1 entry in the validation function?
  305. Help: How do I convert a text date into a real date format
  306. Compare to table
  307. Ctrl+pgup pgdn can't jump worksheets
  308. Page Protection interfering with Hiding Rows
  309. Highlighting an active cell
  310. How can I get "=TODAY()" results to be non-volatile?
  311. Microsoft Excel
  312. Look up twice
  313. Compare values on sheet 1 to values on sheet2
  314. Simple Code, I think...
  315. LOOKUP Command Issue
  316. NOW() function
  317. data verification question
  318. Is there a way to modify the DAYS360 function to accomadate a 365
  319. data in calender format
  320. Need Help with Index and Match or Vlookup
  321. IF Statements...I think
  322. Indirect and Dynamic Range
  323. Why is ther no "Convert" function available in excel?
  324. add file name to spreadsheet
  325. I would like to find a templet that does cost reduction tracking
  326. two condition for vlookup?
  327. Copying line from one sheet to another based on given criteria
  328. Keeping track of results of refreshed/updated data
  329. Is Leap Day between Date Range?
  330. RE: extracting digits to the right of a decima point
  331. extracting digits to the right of a decima point
  332. How do I summarize time that exceeds 24 hours?
  333. sort question
  334. function for pulling certain numbers from a cell?
  335. minimizing space between cell content for printing
  336. How can I match a random number with closest number from sequence?
  337. send button
  338. Rounding down from .9 in an IF stmt
  339. How do I find the cell reference for a vlookup?
  340. formula for product not working
  341. Error in Formula ??
  342. Work Rota
  343. input or copy data
  344. the drag feature in combining cells won't work
  345. How do I lock a stamp date/time formula for an entry on a row?
  346. Sum largest numbers based on condition
  347. create a rolling sum??
  348. cell contents returned
  349. Stop #N/A until data in the reference cell
  350. Conditional formatting - multi-item text list
  351. Weighted average
  352. Formula for Calendar Quarter
  353. marco that inserts rows?
  354. marco that inserts rows?
  355. rolling
  356. Locate duplicates in a work book by using conditional formatting
  357. Link to external link
  358. Re: Selecting data
  359. whats wrong with the formula?
  360. Locate duplicates in a work book by using conditional formatting
  361. get a rolling sum between current date - 30 days
  362. I came across formula: =IF(B.11>0,B14/B.11,0) what "B.11" mean?
  363. Automating charts with reference to new data and formulas
  364. Sumproduct
  365. time
  366. Numeric entry
  367. A formula, probably quite simple.....
  368. counting unique items(values or text)
  369. Search function.
  370. How can I change list into a directory format?
  371. Sumproduct giving #NA
  372. How to go to next day in fomula of Time differences ?
  373. Conditional Average
  374. I have problem with chart titles Value 'Y' Axis
  375. I need some help
  376. probability mass function
  377. How to input cellcontent within worksheets if satisfies condition
  378. Name range not updating
  379. Pasteing formula gives blank result
  380. two way lookup and cell reference
  381. Excel spreadsheets linked together
  382. delete used records from drop down list?
  383. Re: Referencing a cell including background colour...
  384. how do I format a cell to always have an ' in it?
  385. Drop down menu
  386. How to protect all sheet ?
  387. Vlookup giving #N/A
  388. how to type in 1 workbook & automatically insert in another book?
  389. M25 postcode
  390. Delete Rows where there are #N/A Values
  391. Calculating and Adding Hours, Minutes, and Seconds in a CALL LOG
  392. If Function
  393. Need Macro Help
  394. show or hide formatting marks
  395. Counting instances that 2 different columns match
  396. IF statement (non nested) that compares cell value against range
  397. help with order form function
  398. aligning decimal point in a column of figures in Excel
  399. Convert rows to Columns
  400. varible table
  401. Something is wrong with this IF statment
  402. Count unique records... with a twist... Need help!
  403. How do I set default footer setting on excel spreadsheets?
  404. How do I use the spell check on a protected sheet in Excel?
  405. Need some help with name replacement type formulas
  406. when inserting a file name in a cell how do you remove file type
  407. fraction
  408. calender display of list data
  409. How do you get Root Mean Square Error out of a column?
  410. RANK Function - Zero Value Ranked as 1 - Should be 10
  411. Help required with COUNTIF/AND function
  412. can any one tell me how to convert figures into words automatical.
  413. Using Countif with multiple criteria
  414. Import excel spreadsheet into an excel spreadsheet
  415. Vlookup to change a column
  416. Data validation
  417. RE: Dynamic naming of range needed
  418. Re: Dynamic naming of range needed
  419. Adding numbers from specific cells in a number of sheets
  420. IF Function with < & >
  421. conditional formatting for multiple lines using similar criteria?
  422. Two colors in one cell...is this possible
  423. Find text and open hyperlink
  424. Lists Problem
  425. IF AND help!
  426. Total back to w/c Monday
  427. Opening Protected EXCEL worksheets to update linked data
  428. macro- move down to empty cell & active worksheet
  429. SumIf: use of greater or less than operators in Criteria
  430. Is there a way to prevent pasting data into an Excel worksheet?
  431. nesting within vlookup
  432. "Slope" and "intercept" function help
  433. Re: Not printing rows with a zero value
  434. How do I make tab stops within a cell of Excel?
  435. How do I use LOOKUP to return a range of values, then SUM values?
  436. Random function - weighted
  437. is there a way to post dates without enetering 1 by 1 into cell
  438. Finding row & column given value in a Table
  439. Formula for Annualized percentage
  440. display different images based on cell value?
  441. copy from one workbook to another workbook
  442. Using EOMONTH displays #NAME? error
  443. Creating a complex search
  444. Variable Table Array in Lookup Function
  445. Coverting seconds, to minutes and seconds
  446. unable to hide columns -"can not shift objects off sheet" shows
  447. Excel subtotals do not show on left of row numbers
  448. fiterling merged cells
  449. Find next blank row in another spreadsheet
  450. copy data from 1 worksheet to another based on a condition
  451. A formula to count characters in an Excel cell?
  452. How do I keep the top row of a spread sheet visable?
  453. function to count project overlap
  454. How do I count only values which are over a certain amount?
  455. Replace in a currency column
  456. Flagging failed values.
  457. Absolutes in Formulas
  458. How to use the drop down date in Excel?
  459. Combining words and nums.
  460. varible table not
  461. Populating empty cells
  462. Moving Sheets within a workbook
  463. Enable Excel to Sort by IP Address
  464. My boss is crazy
  465. Return a text string when the result of VLOOKUP formula is #N/A
  466. How do i link an entire source wksheet to a dest' wksheet
  467. Search function
  468. Counting problem - newspapers
  469. My Boss is nuts
  470. Populating a field based on lookup values
  471. Some formula to add results until a given value is reached?
  472. What formula to use?
  473. Help w/ the PROPER function
  474. IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA?
  475. Write an Excel Formula Question
  476. IF Function
  477. How to use both Vlookup & data validation
  478. 2lines for tabs just like you can have 2 lines for toolbars
  479. How do i convert row array into one column using pivot table
  480. Using formula results as values in other formulae
  481. I have two columns (A) and (G) that have like product codes however
  482. Display Unique Values
  483. Missing blank in Dynamic range
  484. need help with V lookups
  485. formula problem
  486. Rounding data entered as Millions, how to please
  487. HOW DO I CHANGE A SCHEDULE USING SOLVER WITHOUT CHANGING EACH DAY?
  488. Can I use the date in conditiional formating?
  489. SUMPRODUCT calc question
  490. Lookup Function not working
  491. Help create a IF statement to look to to seperate vookup data sour
  492. Any more advice than the Excel help, on the XIRR Function?
  493. How to find how much to put aside monthly to reach savings goal
  494. Average of Multiple Calculations
  495. Linking workbooks
  496. Find across multiple worksheets
  497. need to ammend a formula
  498. How do linked worksheets exist with data on an external device
  499. Data Validation Combine Functions
  500. summarizing matched data
  501. Calculating a scoring system (issue #1)
  502. Interest amounts
  503. Calculating a scoring system (issue #2)
  504. Advanced Find and Replace Question
  505. cross worksheet
  506. using sumproduct
  507. MultiPage control
  508. INDEX() columns first
  509. software thuriam
  510. Load image from directory for custom toolbar of Excel 2000
  511. if statemant
  512. Stupid Question
  513. i want to do a vlookup but i want the table array to be changing
  514. Want to update hyperlinks through multiple sheets but can't
  515. Extracting first value of each month
  516. how do I write an "if then" statement in Excel. eg. If L47 = 0 the
  517. Add Instant Totals use what feature?
  518. How do I insert content of a2 into text string in b2 and so on?
  519. MSNStockQuote function gives #value
  520. I apologise in advance
  521. Sorting Rows
  522. surveying formula
  523. conditional formatting on If sentance
  524. Sale commissions calculations needed
  525. Help required for "between" dates formula
  526. I can't list items in the same box on the spreadsheet
  527. method for arrange items in alphabetic order in a sheet
  528. Want one cell to show hyperlink from other cell
  529. can excel insert rown based on variable data in a cell?
  530. transferring amount to particular month column
  531. MAX figure within a date range as a function of today()'s date
  532. SUMIF within date range as a function of today()'s date
  533. index and match query
  534. OLE Problems
  535. Track changes
  536. time calculating formula
  537. Converting minutes to seconds
  538. merging sheets
  539. I am looking for the author of this script
  540. Go to Special or other function to jump to vlookup source?
  541. How do I perform bitwise logical anding and oring in Excel?
  542. Copying Excel formulas between sheets
  543. Need Help Please
  544. problem with days months and years conversion
  545. HOW DO INSERT AN AUTONUMBER INTO AN INVOICE TEMPLATE IN EXCEL
  546. Adding the number of table entries by type
  547. Cell Reference issue
  548. Calculating compound interest
  549. problem of converting days months and years
  550. Excel
  551. Help Creating A Formula To Cut and Paste Text
  552. SORTING AN EXCEL SPREADSHEET ROW BY ROW
  553. SUMIF across multiple worksheets in another workbook
  554. How to setup a random matrix in Excel without repeating numbers?
  555. Surname and First names formula
  556. Drop down bar to hide column according to the content of a cell
  557. Is it possible to get formulas to equal certain object values in E
  558. my ? is this problem=E11-backword commaBikes Madeupside down comm.
  559. strange error
  560. Need assistance calculating bonus plan
  561. If A3=alpha numeric,"X", if A3=text,"Y", Blank
  562. Month Format summation
  563. Viewing comments - Filters On
  564. Problem on linking different cells from other worksheet ?
  565. Creating username and passwords
  566. Pivot : how to put more than one range of data in data area of a
  567. "if" function
  568. Pivot table for formula
  569. Multiple If function for more than 7 values
  570. Adding formula to PivotTable
  571. Fomula Problem
  572. change row colour when a value is given in a cell
  573. Multiple Countif results
  574. calculating average with blank cells
  575. Sum If Function
  576. GETPIVOTDATA with an Array
  577. copying conditional formats
  578. Update a Database From Excel
  579. Sequential numbers when printing
  580. What function?
  581. Adding minutes to Times
  582. ADD Change Case function from Word to Excel
  583. want a list of selectable names on my worksheet
  584. error running a paste macro
  585. I need a formula that change all date by putting in one date
  586. HELP!!!! DOGS IN CHINA
  587. HELP!!!! DOGS IN CHINA
  588. Help making Negative numbers to become zero
  589. how do I email amacro?
  590. VLOOKUP
  591. excell function
  592. Print 'Column A' on every page
  593. Search and return
  594. subtotal
  595. summing numbers based on 2nd column
  596. Identify and add formula - can it be done?
  597. how do i lookup and sum from serveral wkshts to a recap sht?
  598. Automatic updating of a rollup worksheet when a new worksheet is a
  599. "Identify numbers in one column and add times from another?
  600. updating phone number formatting
  601. Need help
  602. Can this be done?
  603. VLOOKUP
  604. help with functions to nest
  605. Cell Dividing
  606. RE: logical test
  607. RE: What does this mean ='FY04'!H9
  608. calculate time in the building
  609. logical test
  610. Looking for row # for highest value AND blank cell in other column
  611. Running macro x # of times with a prompt
  612. RE: FORMULA HELP
  613. FORMULA HELP
  614. Converting column to array
  615. Adding multiple vlookups
  616. Relpace entire address with street name only, searching with wildc
  617. What does this mean ='FY04'!H9
  618. usernames and passwords
  619. symbol to represent a carriage return
  620. cell object exposure outside of VBA
  621. count occurence and present results
  622. Opening a file
  623. simple formula
  624. sumif or sumproduct?
  625. Text Overflow (autoflow)
  626. Removing blanks from a spreadsheet
  627. simplify this formula
  628. Dropping the lowest score from a gradebook
  629. Pull a value from another worksheet
  630. Counting in two columns
  631. Cubic Parabola or Cubic Spiral
  632. confused by linking
  633. Thanks to all for the help
  634. Round to nearest 5000?
  635. Return all matching values
  636. HELP!!! DOGS IN CHINA
  637. HELP!!! DOGS IN CHINA
  638. how to create a repeat formula using the same multiplier?
  639. Count rows with a string in any cell
  640. Using Excel 2000 VBA Application on Excel 2003
  641. Number of sundays between two dates
  642. MID function
  643. Rows to Named Sheets
  644. Using Nested RANK functions
  645. what are the uses for Vlookup and Hlookup?
  646. Conditional Formatting : Numbers & Texts Conflict
  647. Advancing formula
  648. Side by Side Comparison Add-on
  649. Rounding up to a set of specific numbers?
  650. VLOOKUP problem
  651. VLOOKUP problem
  652. how do i enable a drop down list depending on result of "if" funct
  653. looking up values in 1 column based on 2 other columns
  654. a problem with blank lines
  655. how to calculate the number of non blank cells from any column?
  656. Using Comma in customise option
  657. Inserting new row but keeping formulae
  658. How to Add Rows From Active Cell with in a XLL Code
  659. Average-Range Change Each Month
  660. I need to use the sumif for a workbook, not a worksheet
  661. VLOOKUP example not working...
  662. Auto Filter
  663. Modify array function length
  664. Text Import Wizard
  665. Is there such a thing as an "if" command in excel?
  666. Pivot Table Refresh
  667. Is This possible?
  668. Split mail merge into separate headed columns
  669. range only if A3=1
  670. range only if A3=1
  671. Nested Formula?
  672. formula help
  673. Choose date from drop-down calendar
  674. VBA CODE range
  675. Using Index Match etc. for price list
  676. Importing a file
  677. Multiple Correlations and Multicollinearity
  678. Running Excel 2000 VBA Application on Excel 2003
  679. Can a header be applied once to a workbook & print on each page?
  680. Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS!
  681. Usernames and Passwords--Thomas Homan
  682. how do i do a highlighted formula?
  683. Automatic Formula to Value Conversion
  684. Can one count cells having a certain format? i.e. using countif?
  685. help with array
  686. Bin, Distribution multiple objects???
  687. Removing Blanks
  688. Fomula (if?)
  689. I am trying to combine contents from 2 cells into 1
  690. rounding to multiples in excel ?
  691. error when running cut & paste macro
  692. template for farmers
  693. Calculating difference between two times
  694. Repeating Columns
  695. Return the column
  696. Can this formula be placed in VBA please.
  697. Force "+" sign
  698. how do I change cell references in a column
  699. copy & paste and change format
  700. Updated Function Question
  701. table, index, array, match, lookup?
  702. Let me explain my problem... (Roommate Accounting)
  703. How do I get the text to WRAP in my text box??? thanks...
  704. Macros AND Buttons
  705. Need help with a Multiply Dependent One Cell Formula
  706. What does the double dash or "--" do when using it in a function? (and other questions)
  707. How Do I increase a date by 90 days?
  708. How do I sort locked cells in Excel?
  709. 60% formula
  710. How to change empty ranges from a plot series without generating e
  711. What formula figures less than & greater than?
  712. how do I nest 3 items?
  713. Question about copying column of cells and......
  714. Spreadsheets
  715. Secret Code for Confirmation
  716. convert 7h 40.80n into time format
  717. Excel Division Formula
  718. Excel Formula to Calc Daily Averages?
  719. How do I calculate employment service and display as yy/mm/dd in .
  720. May be Explode is the correct to do this!
  721. Variable in VLOOKUP and referencing a cell another file in excel
  722. Accessing Attached XLS file
  723. How do I find the cell reference that contains the minimum or maximum
  724. Can a cell be *either text or the result of a formula?
  725. Using if function to show blank when cell in other sheet is empty
  726. Importing
  727. histogram and macros
  728. Adding and subtracting dates
  729. Download excel doc from website, can this be done?
  730. Something other than DATEVALUE
  731. Cell link inbetween Asterisks
  732. excel access will not update time
  733. MULTIPLE (X3) COUNT IF FUNCTION
  734. hiding then printing a row
  735. Simple Calculator Problem
  736. Suming selected cells based on two criteria
  737. Conditional Average (2 conditions)
  738. Urgent enquiry
  739. Formula result as real empty/blank cell
  740. type of probability distribution
  741. Provide a match from 2 cells to give a result from another
  742. Pivot tables - text rather than number?
  743. Cell Content as Header?
  744. How do I unhide the PERSONAL.XLS worksheet?
  745. Dynamic links within workbook
  746. Reformat A Time Value To Add/Subtract
  747. Excel Charts
  748. IF function
  749. Workdays Function
  750. How do I hyperlink from Excel to Outlook for a specific Contact na
131