PDA

View Full Version : 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

  1. Inserting a row
  2. I want vlookup gets value once
  3. getting unique records similar to the primary key in access
  4. point protect
  5. Sorting
  6. Date formula and if function
  7. compare 2 columns
  8. Continuous Alphabetization
  9. Sorting
  10. Help With If Statement
  11. APR Rate on a Loan
  12. RE: Equivalent of Minus in Excel. Also Union, Intersect.
  13. Q About Macro Security
  14. Matching Items
  15. nearest match
  16. Worksheet Problem
  17. Q about: IfAnd or is it AndIf?
  18. how do i add seconds (time)?
  19. Access to hidden cells
  20. Help needed with function
  21. Excel User Conference in Atlantic City - April 19-21
  22. Splitting Column Data into 2 fields
  23. access or XL!
  24. delete duplicate record but only determine 1 column data
  25. Custom formatting not functioning in Excel
  26. Macro Save As Code???
  27. Workspace opening issue
  28. Page Header concern
  29. How do I show a surplus number in an entry (on the plus side)
  30. appending text to existing values
  31. How Do I Autofit To Screen Size
  32. How do i keep it like this, A1:c1/b1, A2:c2/b1, A3: c3/b1?
  33. Guidance needed wrkng with a wrksht
  34. Formatting Upper Case letters
  35. Need Help Please
  36. Macro to open new sheet??????
  37. Need help merging worksheets
  38. Pivot Table - How Do I Convert Data?
  39. How do i add multi-spreedsheets together
  40. I want vlookup gets the value once
  41. serial numbers excel
  42. Tab question
  43. Help to write a formula using a letter value and a number value
  44. syntax question
  45. Weekday
  46. text cuts off in cell
  47. adding rows to ALL worksheet (all in one)
  48. i need a templet to add and subtract
  49. DSUM : what am I doing wrong?
  50. formulas
  51. group comment format on text
  52. return a list
  53. Dynamic Range, Data Validation and Address, Match and Offset Funct
  54. show a column of numbers also as percentages
  55. Help :Circular References
  56. Random cell generator
  57. Why am i getting #VALUE! in a cell?
  58. What is the -- in formulas?
  59. Time card template
  60. Excel gridlines not printing
  61. Auto filtering vs Date> List > Create List
  62. How do I multiply 1 cell x 1 cell and answer in 3rd cell?
  63. Can I have multiple freeze panes in one worksheet?
  64. How do I freeze more than one location on my worksheet?
  65. undo auto symbol
  66. Sumproduct Will Not Find Date
  67. How do you trim characters?
  68. Display total in more than one cell...
  69. How do I convert a cell(s) from the formula to it's contents?
  70. Color rows if
  71. multiple vlookup
  72. Slow data filtering
  73. I NEED OLL BROG IN BOX
  74. Ranking based on frequency
  75. Catentate or cotentate
  76. IF functions
  77. Daily time sheets
  78. Using AutoFilter to Sort Data Pulled in by INDEX / MATCH
  79. Complex Formula to Find Doubles
  80. using If statement to change values in a range
  81. Cell Displayed Does Not Equal Cell Copied
  82. Excel Formula
  83. function wizard excel 2000 not calculating in worksheet
  84. how to insert calander control in excel?
  85. TEXT SEARCH
  86. Filterered list to new worksheet
  87. CountIf Function Help Needed
  88. Formula/Macro to copy into a cell
  89. Assessing unconventional projects
  90. Autofilter - on select columns
  91. Q: how to create summary daily lists from another, and reverse
  92. Wild Card Search
  93. nest functions in CELL function
  94. How can I test if a Macro if firing?
  95. How do i link w/sheets to increase value without just overwriting
  96. how to match data of one column with other
  97. Problem calculating weekly costs
  98. run macro when cell is selected
  99. Formula not evaluated automaticly in Office 2003
  100. Subtotal Range of Alphanumeric References
  101. VBA
  102. worksheet tabs automatically change?
  103. Check if a value exist in a column
  104. automatically number every other row
  105. Can individual cell boundaries be changed?
  106. Change Cell properties by Function
  107. How do I use countif to count values excluding blank cells
  108. retaining functions or formulas in cells
  109. Average Array help with a formula
  110. show difference between weights with correct pos and neg values
  111. FORMULA NEEDED TO COUNT DAYS IN EXCEL BETWEEN DATES
  112. Display worksheet protection status in a cell?
  113. COUNTIF not counting properly!! Character limit?
  114. YEAR function name not found
  115. Problem with Vlookup array selection
  116. add a ruler to use on spreadsheets
  117. help for an excel newbie
  118. adding individual cells in a column
  119. index/index
  120. Where?Worksheet code module or Worksheet_SelectionChange event han
  121. unknown - maybe grouping
  122. How do I delete a lookup table array name?
  123. Help Please with %
  124. Forcing Alignment Options
  125. How to copy records containing a specific date range to new sheet?
  126. Can Excel Data be simultaneously entered in seperate category list
  127. V Lookup
  128. How do I avoid getting "too many different cell formats" error?
  129. I need a Lookup to return more than 1 result
  130. SUMPRODUCT is broken (I swear!)
  131. V Lookup and return cell address
  132. If function with date; if sale is Oct place sale $ amount here
  133. AutoFill over 30,000 rows
  134. Quick Question
  135. multiple sheets when importing into excel
  136. Can you search for common results in many wrksheets?
  137. Formulas that don't compute
  138. Access import query list incomplete
  139. Outlook Calender to Excel Spreadsheet
  140. Reporting results of pivot table
  141. COUNT SEVERAL TEXT VALUES AUTOMATICALLY
  142. Help with Formula
  143. how do I create a macro to auto insert rows?
  144. Excel - let search for more than one disconnected word in a cell
  145. check cell val, increment val
  146. Reference is not valid
  147. How do I round to the nearest $5.00 in Excel? $74.03=$75
  148. ms works question
  149. Easy Nested IF formula question, please help
  150. Comparing worksheets in Excel and highlighting changes
  151. help with VBA.Financial.rate error
  152. How to I past the exact copy of a form without it shrinking
  153. Saving transfered data
  154. Formula With Dates
  155. Average Values / Multiple Worksheets
  156. Elements and Arrays in Excel
  157. Array formula lookup
  158. SUM(COUNTIF(range,NOT Criteria))
  159. Will Excel's time function do this?
  160. Cannot use Data Analysis tools on Excel worksheet embedded in PwrP
  161. workdays formula ends on weekend date
  162. rounding values in in array before sum
  163. Number of pages
  164. count cells since last non-zero value
  165. sorting data into separate worksheets
  166. Permutations of an array element <> to a value
  167. Trimmean for limited array
  168. Refresh Pivottable last 4 weeks data from today
  169. CountIF Range
  170. Functions not working in Spreadsheet
  171. RE: Creating ODBC link within SELECT statement
  172. Calculating Month To Date Revenue
  173. Mode or frequency
  174. concatenate
  175. Presentation errors with multi-level sub-totalling
  176. causing macros to run at insertion point
  177. Using '=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}) )'
  178. how do i add 2 columns to make the answer apper on the 3rd column
  179. Request
  180. How do I return True False
  181. multiple IF's ?
  182. Absolute Named Ranges????
  183. help with sumif formula with multiple critera
  184. Match and Copy
  185. Splitting single column data into two
  186. operations on arrays
  187. =DATEVALUE("7/1/20"&MID(C3,13,2)) creates error
  188. Compare two Numbers - Determine Decrease, Increase, Same
  189. Excel - remaining wks in a year formula
  190. How do I create a List in Excel 2000
  191. =DATEVALUE
  192. Need an advanced "if" function: if 2<x<2.9 then y, if 3<x<3.9 then
  193. how do i sort a proceted work sheet
  194. Color background with Matching cells in row
  195. How to programatically control a 3D-sum?
  196. Calculating timesheet with overtime
  197. Re: IF Function
  198. Averging non-zero cells only
  199. Excel List & Format
  200. How do I query a future date?
  201. Using INDEX and MATCH to find data in 2 different sheets
  202. autofill dragging result rather than formula, why?
  203. Feynman Experiment
  204. Question about merging data
  205. Data Validation
  206. index/match
  207. sumproduct returns zero
  208. =Average(if( formula using different worksheets
  209. SumProduct Formula
  210. Macro code error; machine dependent
  211. Refreshing OLAP cube by date using VBA
  212. Writing macro in Excel
  213. hyperlinks
  214. Autofill cels based on two dates in adjacent cels
  215. Help! Complete text in cell not showing
  216. Counting lines that meet TWO criteria
  217. How can I copy text from one worksheet to another
  218. braincramp
  219. Extracting certain information from cells
  220. Counts/Percents Multiple Criteria
  221. Adding hours minutes and seconds
  222. How to Update a link within a workbook
  223. Linked Worksheets
  224. How do I convert text to numbers in an old version of excel
  225. How to make autosum update totals in excel
  226. Web scraping
  227. Freeze and split panes in Excel 2003
  228. How do you create page numbers on excel worksheets?
  229. *****Upgrading Calendar for Office Manager*****
  230. IF functions
  231. Barcodes
  232. Copying a worksheet witrh protected cells to a new worksheet
  233. Use "PROPER" to change UPPERCASE text to Title Case on worksheet
  234. Extend Excel Workbook Columns to 366
  235. HELP!!!!!!!!!!!!please!!!!!!!!
  236. Double lookup formula
  237. EARN OVER 9850 DOLLAR in 3 WEEKS !!!
  238. EARN OVER 9850 DOLLAR in 3 WEEKS !!!
  239. EARN OVER 9850 DOLLAR in 3 WEEKS !!!
  240. EARN OVER 9850 DOLLAR in 3 WEEKS !!!
  241. EARN OVER 9850 DOLLAR in 3 WEEKS !!!
  242. EARN OVER 9850 DOLLAR in 3 WEEKS !!!
  243. EARN OVER 9850 DOLLAR in 3 WEEKS !!!
  244. EARN OVER 9850 DOLLAR in 3 WEEKS !!!
  245. EARN OVER 9850 DOLLAR in 3 WEEKS !!!
  246. EARN OVER 9850 DOLLAR in 3 WEEKS !!!
  247. EARN OVER 9850 DOLLAR in 3 WEEKS !!!
  248. EARN OVER 9850 DOLLAR in 3 WEEKS !!!
  249. Effective method to paste array formula
  250. why does auto sum get wrong totals?
  251. YTD average - How do I create a formula?
  252. How do i combine duplicate column headings
  253. how can I use the NOW() function without it updating thetime?
  254. HOW DO I DO SIMPLE DIVISION?
  255. Excel should have case changing menu items like Word.
  256. Rank & Match Problem
  257. Extracting entries from long list
  258. subtotal of sum and count in one spreadhseet?
  259. how to put the subtotal of the sum and count in one spreadhseet?
  260. Color Code Date Checking
  261. Combining "AND" with "OR" Statements
  262. need help with a payroll formula
  263. Conditional Format - Outline Border
  264. Updating inventory quantity
  265. Adding months to dates should account for 28-30-31 day months
  266. chart types
  267. Postman
  268. If Function - Multiple Arguements?
  269. quirky array not working
  270. Sumproduct question
  271. Dates and Quantity sort
  272. Macro to highlight cells based on content
  273. workbook1 data to workbook2 data
  274. color of filter arrows
  275. re-produce/loate auto filter list
  276. How do I get a count of dates within a range..?
  277. paste special - formulas
  278. Totaling some hours but not others HELP!
  279. EC Excel User Conference This week registration giveaway
  280. Error when opening Excel workbook
  281. I NEED TO IMPORT MORE THAN THE 65,536 LINES EXCEL ALLOWS
  282. How do I sum increments of minutes and seconds
  283. Including Environ Username in Cell
  284. Difficult for me, probably basic to you
  285. how to hide raws and use password
  286. PivotTable - Calculated Field
  287. Vlookup for two value
  288. 3D Interpolation
  289. special formatting adds extra zeroes
  290. Dsum will not work
  291. highlighting duplicates
  292. Capitalization?
  293. help with a table
  294. How do I advance filter to multiple locations at once?
  295. Conditional DAY
  296. Setting borders for two rows and all columns on spread sheet
  297. Tabbing to the next cell
  298. How do you convert an entire column into absolute value?
  299. How do I find the last instance of data in a column
  300. Limit drop down list and linking to other info
  301. How to format a number cell to auto count 1 up on file open
  302. how do I count with multiple arguments
  303. Nested function - what key strokes to save and return a value?
  304. Random Number generator
  305. How can I view color coordinated formulas
  306. "New Web Query" always refreshes data from website (3 times)
  307. COUNTIF according to presence of string within text
  308. isnumber multiple criteria.
  309. exporting summary data for pivot table!
  310. Convert text string to date
  311. Automate Spreadsheet
  312. Is there a function to extract the URL part of a hyperlink in another cell?
  313. COUNTIF Question
  314. Vlookup problem
  315. How can I set up week to date report?
  316. why doesn't sort work when it's choosen before protecting sheet
  317. INFORMATION ON FUNCTIONS IN EXCEL (EX. "IF", VALUE LOOKUP)
  318. Modifying an If Statement
  319. Is there an AVERAGEIF function similar to COUNTIF - how do I do i.
  320. Querying a range within Excel
  321. calculate percent met (comparing 2 date columns)
  322. how to activate controls in protected sheet
  323. MSOffice Excel 2003-Validation Listbox takes only 47 values
  324. Please Help! - Need Help pulling data from one spreadsheet to anot
  325. Time function
  326. I used Lotus Help for regressions in MS Excel 99. Now what?
  327. Forecasting
  328. Need help with formula to give 0 if value is negative or answer is
  329. copying specific data from 1 wrksht to another
  330. HOW CAN I RECOVER MY OVERWRITTEN DOCUMENT?
  331. vlookup into 2 shhets
  332. problem with macro on Excel
  333. Text and Function Formulas
  334. Finding unique data between 2 columns
  335. intercept graph vs. function
  336. Use InStr function in formula?
  337. Combining Worksheets into one
  338. Removing unwanted rows
  339. Conditional Formatting for Array containing Text
  340. Sum rows if two columns = specific criteria.
  341. time elapsed formula
  342. dynamically select a range of cells for use in a formula
  343. Summed Cell won't update as I add data into the cell range...
  344. Mortgage calculations
  345. Returning Multiple Text or Address Locations
  346. How do I sum cells' values over 30+ worksheets?
  347. Not able to access certain Excel functions
  348. Calling a specific worksheet from a hyperlink in a seperate file.
  349. The Top Toolbar Min,Max,Cancel is NOT showing in Excel
  350. Time Display ?
  351. How to update one manually-entered value from another?
  352. Smart tags
  353. How do I add time abouve 10000 hours in excel?
  354. life contingencies
  355. Disable auto-formatting dates.... GRRR!
  356. Custom formats to round numbers such as 465,123 to 465,000
  357. product from k= 0 to n
  358. Repeat in functions?
  359. cell address
  360. Countif in VBA
  361. trigger help
  362. SUM returns #VALUE! error
  363. Circular references
  364. sorting cells
  365. not printing lines?
  366. A counting question...
  367. average with mulitple ciriteria
  368. if equation
  369. Can excel limit the characters in a cell to 28 automatically?
  370. Need excel password cracker.
  371. calculated field - Pivot Table
  372. unique order number according to criteria
  373. RE: Extract certain parts of string
  374. Extract certain parts of string
  375. NPV
  376. Counting Cell with Quotation
  377. Solver question
  378. Sorting by number of ocurrences!
  379. if equation
  380. automatically move results from a calculation to a specific cell
  381. My If+If+If etc.. is too long! Anyone know a better way?!
  382. COUNTIF using exclusions
  383. Using the AVERAGE Function
  384. Hiding a Worksheet
  385. Why doesn't this work "=IF(C2>= "13:00",C2+"16:00",C2+"4:00")
  386. sum multiple rows based on progressing date field on each row
  387. vlookup
  388. COUNTIF using exclusions
  389. vlookup
  390. Conditional Formatting for more than 3 conditions
  391. Combining 2 Formulas
  392. Basic Solver Problem
  393. If+if+if+if... Does anyone know a better way?
  394. enter date(A) and have (B) total to current day?
  395. Fill in contents based on another column
  396. Embedded IF Fuction
  397. any good reference books on building excel formulas?
  398. Between Dates
  399. Sum like items
  400. ... round a time entry to the next "30 minute increment"...
  401. Resorting full names
  402. Auto Insert/Auto Formula?
  403. converting text to negative numbers!
  404. Sheet Protection
  405. formula help need to get current row
  406. how do Import data tab delimited text?
  407. how do I import tab delimited data?
  408. create a separate backup file in excel when exiting
  409. Look up/math text
  410. =SUMIF(B8:B38,"<"&TODAY(),D8+H8+L8+P8+U8+Y8)
  411. Conditional Sum problem
  412. Need formula help setting a range for calculations
  413. macros
  414. =DATEDIF
  415. Vlookup refs a cell that has a worksheet name
  416. Sumif Function
  417. vlookup
  418. attach a label to number, like validation but follows the number
  419. Groups of numbers
  420. dates and vlookup
  421. SQL Queries
  422. Macro for Subtotals
  423. Date Function
  424. Vlookup not working because of duplicate matches
  425. invoice toolbar
  426. comission split based on 365 days
  427. FillDown Macro
  428. Concatenation question
  429. Read-only access by SHEET (not workbook). Is it possible?
  430. How do you extend the number of blank columns in a worksheet?
  431. user defined function help
  432. complex count
  433. Formula or Function to accomplish this?
  434. summing values appearing in col B when col A has been filtered
  435. Finding Maximum value while excluding some values
  436. Finding a name with biggest number
  437. trouble with seeing formula in formula bar
  438. populating spreedsheet with data from access
  439. Adding a constant to a formula. Problems w/filling in
  440. FOrmulas in MS Excel
  441. Copy data into/from textbox
  442. Digits in ascending order ?
  443. keyboard shortcut for zoom
  444. RE: Average every 20 rows
  445. Average every 20 rows
  446. Spinboxes In MS Excel 2003
  447. Change Date without Opening the Workbook
  448. RE: summing previously ranked values
  449. Using Countif to count occurences of time?
  450. Can I display comments in a validation list
  451. vlookup in several sheets
  452. I am trying to round a list of numbers (prices) to xx.95. Is the
  453. summing previously ranked values
  454. joining worksheets
  455. SUMPRODUCT?
  456. Nested IF error
  457. In a linked calculation how do I lose the '0' in the linked file?
  458. Data compiling formula
  459. currency Problem
  460. Protect "signature" cell
  461. Week Number
  462. How to use month() and day() without considering year()?
  463. count with filter
  464. Linking to a closed workbook
  465. Calculating Overtime
  466. Combo Boxes for data entry
  467. Conditional Formatting Formula
  468. Enter 1 in a cell, excel change to 0.001, WHY?
  469. NA()
  470. Difficult for me, probably basic to you
  471. Protection and Spell check
  472. INDIRECT EXTERNAL DATA
  473. Using Logical Function in Pivot Calculation
  474. Current cell position
  475. How to place parenthesis around a negative percentage calculation.
  476. Change Last Cell
  477. Formula to Link to Specific List on Another Worksheet
  478. Due date excluding weekend days
  479. #N/A conditional format
  480. change cursor to highlight cell I'm in
  481. Conditional Formatting in Excel
  482. How can you use multiple ranges in a function?
  483. Function that will copy sheet to sheet IF...
  484. sumproduct?
  485. How do I allow multiple choices in a list-box?
  486. reference
  487. Totals sheet - deal with employee names
  488. Office 2000 vs 2003
  489. copy, insert and add digits
  490. Vlookup - no match
  491. Compare cells and Create a new File
  492. Random numbers function
  493. Vlookup problem with Date Time
  494. Need to get rid of 0's and replace with Blanks
  495. Fiscal Year Calculation
  496. Countif or Vlookup
  497. Auto update to "tab" in a reference link
  498. Find numeric value at end of string
  499. Column Labels (A, B) are showing us as numbers (1,2). Please Help
  500. Formula to ignore negative numbers in a column?
  501. Comparing Entries to a list
  502. Counting and Summarizing Data
  503. Edit Query
  504. Text to Number Value.
  505. New user with a question
  506. 'if' and 'and'
  507. RE: Run macros on protected worksheet
  508. options custom list
  509. RE: Is there a macro for Canadian compounding
  510. Hyperlink from one cell to another
  511. Excel subtotals should subtotal "blanks" separately.
  512. RE: Check Boxes
  513. RE: Converting to Decimal degree's
  514. MIN to get three lowest
  515. RE: Setting Tab Names To Dates In Spreadsheet
  516. using the equation of a polynomial
  517. Re: Extracting information from records to another sheet automatic
  518. Setting Tab Names To Dates In Spreadsheet
  519. Formaula to multiply and add
  520. Time Functions
  521. Re: Extracting information from records to another sheet automatically
  522. Question regarding formula
  523. Create a spreadsheet to budget
  524. Formulas in are turning into values for no reason
  525. stock quote lookup query for Excel 2000
  526. Check Boxes
  527. filtering pivot table!
  528. Is their any Function to convert no. in figure to in words
  529. help interpreting expression
  530. Extracting information from records to another sheet automatically
  531. general syntax
  532. changing to two place decimal
  533. replacing value between sheets!
  534. Loan Amoritization Spreadsheet Issue
  535. Sumif or Sumproduct? Maybe neither?
  536. Spreadsheet Summary Report
  537. Run macros on protected worksheet
  538. RE: Numbers stored as text causes problem with VLOOKUP
  539. How do I expand the checkbook register to more than 98 entries?
  540. Excel 2003 - paste special option
  541. how to format time
  542. "how to make data lineup from 1st to 2nd page for printing?
  543. date and time updated automatically
  544. linking worksheets
  545. Keyboard Shortcut for Zooming
  546. Converting to Decimal degree's
  547. DSUM
  548. Sumif or Sumproduct
  549. Why do I have certain raw data disappearing in my pivot table
  550. Is there a macro for Canadian compounding
  551. Numbers stored as text causes problem with VLOOKUP
  552. Bi weekly payments per month
  553. Insert Photo into a protected worksheet
  554. How do I set up conditional formulas
  555. Loan Amoritization Spreadhsheet Issue...please help
  556. Set up Tax planning sheet by week/monrth- Income/deductions
  557. Confidence function
  558. Reference
  559. Reference range of cells and perform subtraction or nothing depending on contents
  560. Date dif
  561. Conditional Sum Wizard with dynamic named ranges
  562. EXCEL LOOKUP FISCAL YEAR WITH DATE
  563. CountIf Conditions / Occurrences
  564. MORE THAN ONE LOGIC TEST
  565. How to delete in batch the same color format letters in a cell
  566. help on excel formula
  567. returning macro value to starting cell (different each time)
  568. template error
  569. Yahoo + "Get External Data"
  570. Why won't my formulas work until I save the worksheet?
  571. quotation marks
  572. extracting numbers
  573. First occurance greater than or equal to a specified value
  574. Link Data from Multiple Worksheets
  575. how to copy displayed value only?
  576. Ignoring negative number
  577. Transpose and link Multicolum matrix in 2 colum array
  578. How to show data from other sheet depend on value??
  579. financial functions dll
  580. Color Coding Cells
  581. Working out age from "Day" "Month" "Year"
  582. Registration drawing ending - Excel User Conference
  583. Blocking entry of data in a cell
  584. Index / Hlookup
  585. Using the results of formulae between different spreadsheets.
  586. Finding a minimum value and selecting the cell containing this val
  587. Case Sensitive w/ IF
  588. Conditional formatting--simple question
  589. excel formula calculations are wrong
  590. multiple conditions
  591. A Sheet Error for dates I can't explain
  592. sumproduct
  593. Help with workbook updates
  594. timer Macro
  595. How do I put days of the week into a multiple regression model?
  596. track unpaid invoices
  597. Calling procedure when leaving cell
  598. naming tabs
  599. Another Multiple Conditions Query
  600. matching value of top 20 in a list!
  601. How to extract data from a wooksheet in a closed workbook
  602. Subsequence value
  603. Splitting text to columns
  604. Help!!!! Strange things are happening to a Shared Workbook!!
  605. Populate worksheets based on a master sheet
  606. Why won't Excel let me copy and paste my concantenate formula now
  607. vlookup for multiple columns
  608. V-lookup and summing values if more than 1 matches criteria
  609. YTD formula help
  610. Advanced Filtering Extract Range Missing,etc
  611. RE: Selected cell highlighting has vanished...no shading now.
  612. Lookup problem
  613. How do I paste horizontal references in large array
  614. Formula/Equation
  615. #ref to equal zero
  616. What is Excel keyboard shortcut for adding column?
  617. Multiple IF
  618. Lookup nearest value (Index & Match)
  619. Lookup nearest value (Index & Match)
  620. use address function to indicate range in calculation
  621. HELP: Comparison IF statement
  622. Date the input, then tell if over 7th off month
  623. Calculating Rolling Peak to Valley in a Column
  624. Matching two columns and their data
  625. Using variables as first and last cells in range statement
  626. Question about decimal places
  627. Worksheet controller
  628. Excel spreadsheet
  629. RE: Formula Displays in One Cell
  630. Dragging a formula correctly?
  631. RE: REPLACE or ??, Help please
  632. RE: multiple column lookups
  633. RE: seperate words in a cell
  634. RE: Excel formulas
  635. How to Set Worksheet Name to a cell Value in WorkSheet?
  636. REPLACE or ??, Help please
  637. RE: multiple column lookups
  638. using functions to compare multiple columns for mismatch of cells
  639. RE: Count # of A's in a Cell
  640. RE: Can I change the default sheet name?
  641. formatting cells
  642. seperate words in a cell
  643. Can I change the default sheet name?
  644. RE: Count # of A's in a Cell
  645. RE: WorkSheet Function Help
  646. Count # of A's in a Cell
  647. Formula to show all items with an "x" next to them
  648. Formula to return cell position
  649. first saturday in a month
  650. WorkSheet Function Help
  651. How to stop "Synchronized Scrolling" in Excel Workbook comparing
  652. Excel formulas
  653. Pivot Table using "LIKE" code
  654. RE: multiple column lookups
  655. multiple column lookups
  656. How to delete footer & header history in Excel?
  657. lookup mutliple values to return one value
  658. Formula Displays in One Cell
  659. Sort is turned off. How do I turn it on?
  660. last 20 items in a list
  661. Refresh workbook automatically
  662. Urgent help needed
  663. Function Question
  664. What formula can I use to sum only certain colored cells in an exc
  665. Automatically starting code
  666. averages
  667. buttons?
  668. Help with 'named' functions
  669. Interpolation with VLOOKUP
  670. how do i enter a function in a sentence
  671. Printing Spreadsheets
  672. Is there a way to autoinsert current row into a formula
  673. help with personal budget spreadsheet
  674. filtering excel worksheet column by color of text
  675. ANYONE GOT THE TIME?
  676. LISTS OF BILLS TO BE PAID
  677. Activating a worksheet through use of a variable
  678. AUTO CASE
  679. add hex numberings together in excel 2003
  680. How do I use a wildcard or multiple of a cell value in a formula?
  681. v function
  682. How do I do running Totals in a Pivot Table
  683. combining text
  684. Auto rename and save prompt needed.
  685. How do I view formula results intead of formula in excel?
  686. Two Logic tests in an IF Statement
  687. data not viewable after installing Java JRE version 1.5.0_06
  688. How to populate a table?
  689. change cell color based on cell value
  690. Why does my sheet have 60,000 rows when only 60 rows have data?
  691. Cell Reference Embedded in Formula
  692. How do I sort multiple worksheet pages to list in numerical order?
  693. Finding the value of a cell in an entire worksheet
  694. Sum of cell on numerous worksheets in a workbook
  695. Forecast
  696. IF Statement
  697. Errors in COUNT, COUNTA, COUNTIF when counting merged cells
  698. Merging multiple worksheets
  699. How do I pull a merged cell from another workbook?
  700. RE: How can I change the settings on the row headers/
  701. How to set up single Header/Footer for all tabs in Excel Workbook.
  702. Some function problems
  703. I would like to copy & "paste special" an entire book
  704. How do I set up a calculation to exclude weekends?
  705. COUNT IF BETWEEN DATES
  706. Histogram from multi-page info
  707. Formula that 'contains' a specific word
  708. Rounding up results to meet minimum order quantities.
  709. Background on Worksheet
  710. Replace a long list of abbreviations with full words in Excel
  711. Look Up Function
  712. Some tabs not visible in Hyperlink list
  713. Calculate employee hours for employee evaluation?
  714. Hyperlink ? - forgot to add it's a chart
  715. how do you select multiple minima in Excel
  716. How can I create a fill that increments based on worksheet numbers
  717. Non-Static table/sheet referencing
  718. combination of functions?
  719. Convert units should include USFt (39.37/12)
  720. Increment Page Numbers for multiple tabs in Excel
  721. Search Help
  722. Help finding dates July thru June
  723. Help finding dates July thru June
  724. How can I invoke running a macro from within an "IF" function.
  725. Run a macro if a certain value is entered in a cell
  726. sumproduct vs dsum
  727. Advanced Lookup w/Dates
  728. Formula Bar
  729. Subtract times and let result go negative
  730. Updating Excel Worksheet
  731. Average Function that Counts
  732. =DSUM(DIVOH,$CX$1,$DG$2:$DG$20)
  733. Automatically running code
  734. How do I save printing option for all in a shared Excel workbook?
  735. Any way to get calculations over a range of two sheets?
  736. Extending a nested IF function.
  737. Eurotrip?
  738. I need an autosum for each box where employees use x's of 1's
  739. sliding hours payment
  740. Hyperlink to an image in other worksheet, displaying entire image.
  741. Colour recognition by master sheet
  742. Cell function required
  743. Which Function to Use?
  744. How can I change what is in the "name box" in Excel?
  745. Mysterious formatting - cannot fix
  746. How do I search a text string in many excel worksheets (files)?
  747. Formula = Today's date + 1 month
  748. Matching/merging data from two worksheets
  749. How to do TI83 2-SampTTest (hypothesis testing)?
  750. SUMIF Question Re:Criteria
  751. Date question
  752. Use the only the last value in a column in a formula
  753. Dynamic Data Distribution
  754. simplify procedure to get rid of 0 error values in a spreadsheet
  755. ?? Auto go to link source
  756. grouping field in pivot table!
  757. arrange excel worksheets Alphabetically
  758. DATE FORMAT issue
  759. excel charts, simple question
  760. Auto time freezed
  761. How to 'freeze' the output generated by RAND()?
  762. Lookup Postage Price [min & max weight]
  763. Adding values for selected years
  764. Workseet Colaberation
  765. Formula displays result in formula box but not in cell
  766. Problem with spaces
  767. math formula with upper and lower limits on data but also ranges
  768. Conditional formatting is unavaiable in worksheet, what can I do?
  769. MIN to find specific lowest value
  770. HELP, I'VE FORGOTTEN
  771. Worksheet Tab Name
  772. Unique RANDOM NUMBERS within specified range
  773. How to put pictures into an excel document for merging in Word?
  774. Split field based on number of characters and space
  775. excel data automation to/from jsp page
  776. How do i delete duplicate rows in an Excel Spread Sheet
  777. Help on Pivot Table Format
  778. Hard returns in a formula?
  779. Advanced Filter
  780. search list for values
  781. =SUMPRODUCT not working
  782. Check for duplicate data
  783. I would like to see a few new features in Excel
  784. Column list search
  785. need help with count formula..
  786. Replacing ascii characters
  787. keeping a sum array static
  788. If formula with score total
  789. Analysis Toolpak Add-In?
  790. Having to key the equal sign to start a formula
  791. Excel's Undo Function
  792. Need help with formula
  793. Changing a value to a letter
  794. What formula can I use
  795. HLOOKUP with multiple conditions
  796. Looking at several columns with Indirect
  797. finding out missing entries!
  798. How do I use my excel program to total up columns ex. e3 to e155
  799. If Statement based on blank fields
  800. Need help with automating the updating of a function in worksheet
  801. copy entire excel book
  802. Hyperlink to a CD
  803. DSUM returns #VALUE!
  804. How to increase font size in drop downs within workbook
  805. looking for a value in a collumn
  806. Advanced Lookup problem
  807. Data count with two worksheets
  808. Need help with a formula
  809. Subtracting 2 Now() Cells
  810. If Formula Question
  811. Conditional formating based on text
  812. Formula automatically changing cell references
  813. "unique" forumla in excel
  814. Have 2 Vlookup
  815. Rolling Average
  816. "Format" function in Excel
  817. =MAX-Return Cell info
  818. FIND and REPLACE characters needed
  819. Adding a period to the "=LEFT()" function.
  820. Can I return multiple columns from a vlookup?
  821. cell lock does not work ?!
  822. Is there a function for this?
  823. Counting distinct entries based on meeting month & year criteria
  824. keyboard shortcut question
  825. adding comments to unprotected cell/range in protected worksheet
  826. Copying values but skipping empty cells
  827. Excel comment box should stay in same position
  828. Tab-naming macro only works once :-(
  829. Smart Tags
  830. Workbook Popup note
  831. Find when a value in a column changes
  832. Gridlines
  833. use lotus 1-2-3 commands in excel 2003
  834. Can this be done....?
  835. How to read CSV lines into different Worksheets depending on a date field?
  836. Copy & paste special
  837. code for showing a sheet has been printed
  838. How do i hide a solution until data is entered
  839. Merging data
  840. Nesting more than 7 conditions?
  841. Vlookup using variable path name for range value
  842. IF(AND) function?
  843. Formula if a number is between 2 amount than answer will be x
  844. IF VLOOKUP
  845. cumulative totals in a workbook
  846. Cells populate on specific dates
  847. Filtering External Data
  848. How do i subtract cells in an IF function?
  849. time trouble
  850. How do you make it so you can see Your table in word?
  851. How do u emulate nesting seven IF functions in a cell?
  852. Excel
  853. List of items appeared in range
  854. conditional formating colours to stay when numbers are deleted?
  855. data changes to date format
  856. what is perequi function?
  857. apply arithmetic functions on special multiple cells
  858. Simple problem?
  859. Drop down menu and two dimensional lookup in Excel 2003
  860. LOOK UP INFORMATION
  861. IF Function
  862. How to change the default 000 to indian standards in 00,00,000?
  863. Sumproduct Problem
  864. SUMIF Function
  865. Macro Msg. when file has no macros
  866. Array Formula
  867. Entering the same data on more than one worksheet
  868. SUMIF with two contraints?
  869. find text
  870. finding unmatched data
  871. median excluding 0's
  872. Mail Merge
  873. How can I sort multiple times
  874. how do I write a formula to copy text from one cell to another?
  875. Greater Than Less Than Question
  876. Macro buttons disappeared
  877. Multiple conditions data analysis
  878. how to keep previous months' data
  879. How do I limit sorting a column to the column?
  880. Pull latest date data - ignore the rest
  881. Can some one help me with a formula please?
  882. form/subform with buttons
  883. using solver to complete a table
  884. How can I get inserted lines to automatically appear in a linked .
  885. Can I convert hh:mm to mm in Excel
  886. Summary formula help
  887. How can find a value using two different matching criteria?
  888. nesting issue in functions
  889. Worksheet function for range of numbers
  890. adding specific cells based on a corresponding date
  891. VLOOKUP in a dynamic setting
  892. time calculations
  893. Small help with vlookup and sum
  894. Page Setup Across Multiple Worksheets
  895. Countif - refer to another sheet
  896. How can I copy a custom toolbar & put it on another pc?
  897. Generating numbers & submitting details from one sheet to another
  898. Copy If Ability for Excel Data
  899. Rank in Pivot Table
  900. RE: QUERY & HELP: so slow executing VBA code... :S
  901. converting a number to time formatted as minutes
  902. count it
  903. conditional formatting when entering a date
  904. Inserting an image or line
  905. How do I link 'tab names' to a cell in Excell spreadsheets
  906. Lookup when values located in a row across bottom of table of data
  907. Merge =( formula should retain fraction type numbers after merge.
  908. stoke market accounting buy brokrej amount sell brokrej amount
  909. How do you hide column and row headings in Excel?
  910. How do I keep the color fonts in my cells when I use drop down?
  911. Can you replace "TRUE" with " " in an exact formula?
  912. Complex countif of array elements
  913. How 2 sum the abs values of several cells w 1 func in XL.
  914. How 2 sum the abs values of several cells w 1 func in XL.
  915. Shared workbooks
  916. automatically filter for unique records... or other suggestions
  917. Calculation Problem
  918. Sumproduct with two criteria
  919. SUM Arrays needing an "OR" statment (but no duplicates)
  920. Column Values Re-Order Bottom to Top
  921. how to create my own functions??
  922. Can I use character masks within a function?
  923. Help with IF statement on taxes
  924. Calculate the difference between two times
  925. Calculate the difference between two times
  926. Text String - Specific Characters
  927. shortcut for transfering info from one worksheet to another?
  928. Speedy way to create IF Function
  929. File Open Box Suddenly Maximized
  930. Using COUNTIF to find how many times 2004 occurs
  931. convert decimal numbers to a fraction of an hour for payroll hour
  932. how to use * wildcard in a sum(if((cond),range)) array formula
  933. How do I change the ROW HEIGHT in one column?
  934. Time Increments
  935. when I use Ctrl+D to copy a formula, it does not compute right.
  936. Copy # fm one list to matching id in list 2?
  937. Min/Max help needed with a SumProduct
  938. Excel User Conference - Registration Drawing
  939. Nesting VLOOKUP & HLOOKUP
  940. Array formula expertise needed
  941. would like to know how to convert 2 hours and 30 minutes into 2.5
  942. filter ?
  943. To find duplicated values in a range
  944. multiple worksheet help
  945. highlighting duplicate values
  946. stuck
  947. generate a chart with asp.net
  948. Excel formula to increment the month by 2?
  949. How to show all the possible combination of a set of numbers?
  950. Find the earliest date in a range of dates?
  951. How do i Print Multiple Names on the same Timesheet?
  952. convert $ to £ or £ to $ function how?
  953. ???Refer to a specifc cell in a named range
  954. Count Function help required
  955. Using Lookup on an expanding list
  956. Enhancement request for showing the selection of rows in MS Excel
  957. Excel sort application should work with Project WBS
  958. How do I SUM several worksheet to a final worksheet?
  959. Import a Code to a paragraph using a formula or macro!
  960. =HYPERLINK function and Excel 2003 problem.
  961. OS language and Office language conflicts
  962. Count Duplicates Order numbers for one Customer
  963. Decimal Formual
  964. Dates Formats in Pivot Table Help
  965. repost: Min/Max help needed with a SumProduct
  966. Time Formula?????
  967. Format cell to show duration of phone calls
  968. Decimal Places - Settings for Auto Rounding Up/Down
  969. Divide Problems
  970. SUM IF Formuale
  971. Data filter total
  972. How do you compute partial year depreciation using DDB, SYD, SLN,V
  973. IF ARRAY LOOKUP ??? Help Please
  974. formula
  975. Combining 4 lists of data
  976. Chronolize dates with varying days minus weekends
  977. powers to negative numbers
  978. Time Fomat
  979. Days360 problem
  980. Excel cell properties
  981. Why does my color palette automatically change?
  982. Extracting Numeric Data from a Delimited Text String
  983. How do I link a row of cells in wks 1 to update diff cells wks 2
  984. Using arrays or range in IF function - HELP PLS
  985. IF, AND, OR Function help needed
  986. Can I use SUMIF and AND together
  987. How do I use a referenced cell's formula instead of formula output?
  988. calculate using last four digits of number in cell
  989. Automatically step a formula?
  990. Making column reference in INDIRECT non-static
  991. including current date in formula
  992. Excel Randoming Becoming More Efficient
  993. numerical data sort
  994. Help with a Formula
  995. date function
  996. worksheet copying, changing source link
  997. Training: More on how to use macros in Excel: Recording Macros
  998. using auto fill edit or fill handel
  999. Sumif and a range
  1000. >> Need help with a simple formula
Google