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. How do I copy columns between worksheets if the columns don't matc
  2. 3 data validations
  3. Help Need Formula for Calculator
  4. How to create a calendar view from data in Excel?
  5. Drawing on a chart
  6. Conditional Format Issue
  7. Convert Text to Columns with Excel 2007 beta does not work well
  8. Counting data between 2 values
  9. Concatenate in a string
  10. Time sheet calculations
  11. Pivot Table Question
  12. Number format in cells
  13. Req for help using INDIRECT or alt solution
  14. Maintain Formula Reference (sort of)
  15. Dissecting the contents of a cell
  16. what formula in Excel will identify the first zero in a row and...
  17. xirr - hi! i need some urgent help
  18. create & name multiple worksheets
  19. How to get the right-most word from TEXT
  20. Help with INDIRECT
  21. reset certain cells to a default value
  22. Can't add 7th IF statement to long formula.
  23. RE: How to get the right-most word from TEXT
  24. Re: Can't add 7th IF statement to long formula.
  25. Replacing a number value with text from array
  26. Macro Question
  27. retreiving cell address of vlookup value
  28. Conditional FIND and REPLACE
  29. One column with various widths
  30. PULL Function
  31. Pivot Table - Deleting data rows while maintaining them in the tot
  32. NOW Function For Time Changes With Each New Macro
  33. RE: Determine if a value in a range is close to the value of another c
  34. Determine if a value in a range is close to the value of another c
  35. How do I change the default spreadsheet size in Excel?
  36. limit text length after importing data
  37. I want to add a plus sign behind a number and keep the leading zer
  38. Sumprpoduct Help
  39. Moving automatically from one cell to another
  40. Running macros on ALL Excel tabs
  41. Text Compare Function
  42. Insert currency numbers from spreadsheet such as 48 = $48.00
  43. Converting a formula to its value
  44. A function to indicate whether a cell contains formula or value?
  45. Excel 2000 filter problems
  46. Matching Adjacent Columns?
  47. Modify database
  48. Auto Filter by Criteria
  49. visual basic (copy and paste)
  50. lookup and move rows to other workbook
  51. Formula not recalculating
  52. mileage
  53. Conditional Formula help required
  54. Formula-Cell has a letter (C=100, M=1,000) and needs to divide?
  55. How to define the 1st, 2nd and 3rd element
  56. Averaging a column with 0's
  57. Comparing columns from 2 different worksheets.
  58. How to mark down the time when entering input to a cell?
  59. Drag a Named Formula
  60. Manipulating Data Problem
  61. Percentages between two cells
  62. Percentage
  63. How can I check the "P" or "A" in the attendance sheet
  64. Inserting automatic text in Excel
  65. Add a new row under a changing list
  66. Baseball sumproduct/array formula?
  67. Converting letters to numbers
  68. dumb question
  69. Save sheets in a folder
  70. how i change thai text to english text
  71. macro to copy multiple rows to separate worksheets
  72. Data Importing?
  73. How can I lable a colomn group in Excel?
  74. 3-D reference
  75. Help in data comparison
  76. Macro Question
  77. How do I alpha short worksheets in a workbook:
  78. 2 levels of worksheet protection?
  79. Extracting the most frequently occuring text from a range
  80. How to sum cells but not show zero if cells are blank?
  81. Retrieve specific date from one row of one column that is changing
  82. Using DCOUNTA to count only Unique values
  83. Lookup function for a value that has multiple instances
  84. Two links changed on my site
  85. Returning column header as result
  86. what is the "random" function in Excel in spanish?
  87. Comments Printing Problem
  88. average function
  89. insert picture from file based on cel value/content
  90. End (bottom) of worksheet
  91. Paste Special - Values
  92. if and then formula
  93. Validation Links
  94. AUTO FILL DOES NOT WORK ON PREVIOUS EXCEL WORKBOOKS
  95. PivotTable:Using a calculated field result in another calculated f
  96. How do I retrieve the text string from the right of a cell
  97. Protecting columns?
  98. Trouble writing an excel formula.
  99. Formula too long - text
  100. Transpose Question
  101. reference in another workbook related to the name of material
  102. World cup spreadsheet help
  103. calculate the sum of hours exceeding 23:56
  104. How can i convert an ASCII character to decimal/hex in Excel?
  105. Database Functions - Strange results
  106. I'm trying to link two excel spreadsheets so they update automati
  107. how do i sum A1*B1 through to A12*B12 in one easy forumla?
  108. Formula Needed to Compare Dates and return a running total
  109. Automatic Product Functions
  110. f statistic, p value definition
  111. Macro for copying conditional data
  112. Function Question
  113. IF,And,OR Help
  114. why cond sum wizard returns diff result as when formula typed out
  115. Page TOtal
  116. Count Number of Different Cells
  117. How to import data based on a variable
  118. Hyperlink trouble
  119. Page TOtal
  120. Automatic Population?
  121. Format number using CONCATONATE
  122. How do I keep column headings from showing on a list?
  123. SUMPRODUCT and (perhaps) SUBTOTAL with AUTOFILTER
  124. Column Headings in Lists
  125. changing money
  126. count # of instances in cell (a b a) answer 2 formula if possible
  127. % or Nr
  128. Can't see all the text in a cell when using file links
  129. Rank(A1,C1:C5) - Rank using 2 ranges
  130. VLookup Multiple Data Rows
  131. Function for days between dates and an if statement (HELP)
  132. Email addresses in Excel need to format for mass email
  133. Find most recent date
  134. formula references change when data entry sheet is modified
  135. How to validate
  136. when i enter time in cell it changed, why?
  137. What's wrong with this formula?
  138. Running total array?
  139. how do I sum all of the $ payments made between two dates
  140. How do I lookup multilple criteria and return a single value
  141. Can formats follow formulas?
  142. if and function
  143. Macro Help
  144. Compare product prices from two supliers and produce report
  145. Cpk value calculation in excel
  146. paste to next blank cell/row
  147. How to change a link to another worksheet by changing a value in a cell?
  148. Count number of pages
  149. sequential invoice numbering
  150. VLookup function to right!
  151. closest match
  152. Cash Book
  153. How to calculate odds in excel (for instance matching pairofdice)
  154. Counting each time text appears in range???
  155. Final days for regular registration - London Excel User Conference - July 19-21
  156. Name
  157. Hyperlink trouble
  158. Histogram Average
  159. PERCENTAGES
  160. Printing selected sheets.
  161. How to print a selected number of sheets?
  162. Countifs and multiple columns...
  163. Hyperlink trouble
  164. How to update an external excel sheet
  165. Hyperlink trouble
  166. can i execute a calculation in a cell at a certain time of the day
  167. Desperately need help with 3 calculations
  168. Using the =NOW() Function
  169. hOW CAN i CHANGE HEADER ON ALL PAGES IN EXCEL?
  170. Formatting smallest number in a range?
  171. Help :-( - Auto Population
  172. Counting only Unique cells
  173. Worksheet not showing up in VBE
  174. Macro for column sum
  175. Formula Help
  176. calculation errors
  177. Allow user to "switch" contents of two boxes in Excel
  178. Help Excel Data manipulation Pros: Something like a Vlookup with a Sum Function
  179. I need a date stamp that doesn't change when you enter text
  180. In Excel I want to copy text from spreadsheet to spreadsheet
  181. New to Excel functions and need some help
  182. looking for another same value cell in a range and returning a coresponding value
  183. Find category value based on date range?
  184. IF Function
  185. Zero starts of a number
  186. Confused on a function
  187. Would like help with displaying data if are a certain value is pre
  188. Pivot table: sum of durations
  189. Circling cells based on a value
  190. Last Non Blank
  191. Help with 2 sheets with data to work together
  192. IF with OR and AND
  193. Does anyone have a solution for nesting an OFFSET in an HLOOKUP?
  194. finding value from table
  195. IF with OR and AND - the Sequal
  196. numbers in Excel
  197. DCOUNT / COUNT IF???
  198. Average non zero values
  199. How do I add the same dollar amount to all cells in excel?
  200. a exact string search inquiry
  201. Conditional formatting to chart
  202. I want columns of worksheet to become rows and vice-versa.
  203. Pivot Table
  204. Formula
  205. Pivot Table
  206. Need column evaluated to count total of occurrences of "Y". How?
  207. HOW CAN I CREATE A HISTOGRAM GRAPH FOR MY DATA?
  208. HOW CAN I CREATE A HISTOGRAM GRAPH FOR MY DATA?
  209. using logical functions
  210. cell reference changes and conditional formatting
  211. Basic Question on Subs
  212. what is the formula from british pounds to American dollars
  213. Date issue
  214. vlookups error message
  215. Re: Errors in "vlookups" formula
  216. Newbie question Different decimal place values for columns
  217. What Fourmula Would I use and How
  218. What Formula To Use
  219. I need to know what kinda Function to Use in A Worksheet
  220. Template & Database Question
  221. Calculate relative frequency?
  222. 5 days week date (mon to fri)
  223. create list is missing from data menu
  224. Combo Box
  225. Age from birthdate
  226. =SUMPRODUCT((Overtime!$J$6:$GY$6-DAY(Overtime!$J$6:$GY$6)+1=A25)*(Overtime!$J$7:$GY $2
  227. Excel problem trying to format columns of data
  228. Select from drop down list via typing text?
  229. Parse from the Right
  230. formula typed contains an error
  231. Compare and Merge Workbooks
  232. load one vendors prices to a master workbook
  233. counting responses - please help
  234. Ignoring Blank Cells
  235. Internet Query?
  236. CreateObject("Excel.Application")
  237. Page set up for a workbook, so each sheet gets the same format ?
  238. creating a quote looking up from tables
  239. IF formula
  240. change date format
  241. Separate two words in cell
  242. Countif Problem
  243. How to Add Restrictions to ComboBox...???
  244. Sum & two column conditions
  245. Last week for regular registration - London Excel User Conference - July 19-21
  246. vba linking Excel and Word
  247. Title in one cell covering space of 3 cells underneath
  248. nested if function
  249. Macro hangs up often but sometimes works fine
  250. HLookup and how it works
  251. Change the work sheet name in a formula by using cell reference
  252. get back a document replaced by another
  253. Is it possible to search tabs in excel?
  254. how can avoid considering of blank cells in IF function
  255. How to change a tab name with cell reference and formula?
  256. percentages
  257. serial number decode
  258. take numbers from one cell and add to another
  259. alphabetcal order
  260. How to get a cell with a zero errorto show the cell as blank
  261. Formula
  262. Spreadsheet Alarms
  263. how to add a charater in front of part number
  264. Date minus 3 months
  265. Counting cells using multiple criteria
  266. If Function with OR
  267. Vlookup returns line number
  268. Formula to count cells between dates.
  269. Prom with the DSUM function
  270. Speed fill function for MS Ecel 2007 (Beta)
  271. Arranging Names in a cell
  272. How do I open several worksheets from the same workbook on screen
  273. Excel
  274. Factorial (like =FACT) function?
  275. Determine Future Value to Meet Average
  276. Excel Data Sort in Excel2000
  277. Personally Identifying information in Excel Sheet
  278. Customise the summation function / button
  279. lookups and match
  280. Excel 2007 worksheet headers do not print
  281. Automatically number lines
  282. Date Function formula that will return the date of a specific week
  283. Compare Two Lists
  284. Stock data manipulation
  285. Can anyone help?
  286. Using vlookup - how can I obtain a sum of values, not just first v
  287. How many characters in a box..?
  288. production cost
  289. <HELP> modified reference
  290. How can I connect a word of text to a certain dollar value?
  291. How do I change the IRR formula for MONTHLY periodic payments?
  292. comparing ranges/arrays
  293. Type in Part number which pulls info from another wksheet
  294. Shrink to fit Macro Button
  295. Apply Absolute Reference to multiplie cells
  296. Trying to replace "false" in IF statement...
  297. EXCEL HELP
  298. How to smart count a table with words in it!
  299. How are empty cells referenced in Excel in IF statements?
  300. How do I covert rows to columms?
  301. Rows into Columms
  302. Datedif using cell references Excel 2000
  303. changing datas when adding row ?
  304. finding a name in a string
  305. Compare and copy unique values
  306. searching all workbook sheets
  307. using VB to read in a column of values of varying length into an array
  308. Adding A Not(IsBlank) To IF Statement(help)
  309. Complex logical/conditional formula
  310. How do I rename an Excel worksheet when the feature is grayed out.
  311. Displaying result in parentheses
  312. help. Excel shows formulas, not answers
  313. formula error
  314. Calculating Compounded Growth Rates
  315. look up a value in one column to another colum
  316. place a number in a cell
  317. copy cell from one sheet to another
  318. Passing a WorkSheet from a Function???
  319. IF Function with equation and text
  320. Excel Workbook
  321. Need a pareto of a text table
  322. making cells change relative to each other?
  323. making cells change relative to each other? cant figure it out
  324. How to parse a string with a date?
  325. Running Sum across columns but only to a certain point
  326. Selection of Drop down list that allows you to go to a particular cell
  327. RANK, duplicate ranking but no gaps in rank
  328. if specific value from list A equals one of the values from list b...
  329. if again
  330. find value one row in advance of specified value
  331. how do i save a large amount of data in a worksheet excel 4
  332. Max and lookups
  333. do loops
  334. Hyperlinks
  335. MSQuery
  336. RE-submitting of: constructing (complex) variables with worksheet functions
  337. London Excel Conference Registration giveaway
  338. Find and replace Comments
  339. query in excel
  340. Re: Moving left of a cell reference
  341. Moving left of a cell reference
  342. I need to count data in one colum based on data in another column
  343. need value from referenced cell
  344. Moving cell data and separating or deleting
  345. Web toolbar in Excel 2007 beta
  346. Xcel Formula # rows With value X in colF AND Value A or B in colJ
  347. How do I Change the value in a count function from 1 to .25
  348. IF Statement, including AND
  349. Conditional COUNTIF Function
  350. Copy Worksheets
  351. turn off convert text to date (i.e. 4-9 to April 9, 2006)
  352. Total Minutes
  353. Multiple hyperlinks from drop down box
  354. Hlookup search in more than one sheet of excell?
  355. how do I perform a lookup on an 80,000 line array?
  356. excel function
  357. Please help!
  358. Externalizing formulas.
  359. Convert a julian gregorian date code into a regular date
  360. Dare Format
  361. Help with SUBTOTAL formula
  362. Still a problem with DSUM function
  363. Compound Lookup, Large/Small, Match...
  364. how can i ignore an error in a formula
  365. User defined functions without using VBA.
  366. User defined functions without using VBA.
  367. MEGA FORMULA
  368. converting month name to number
  369. unlock a spreadsheet without password
  370. unhide rows when cell is clicked
  371. Dame: identifying duplicate numbers within a column
  372. maximum repeated value
  373. How to convert cell contents
  374. In Excel: add a Paste-Special Option to paste IN REVERSE ORDER.
  375. Have a worksheet = cell value (Time!B2 vs C2!B2 when C2 = Time)?
  376. =Now()
  377. How can I CUT and paste to convert columns to rows?
  378. Pivot table and Dsum security
  379. Create 5 unique value between 1 and 14?
  380. Help with an Excel formula please. - it is beyond me!!
  381. how do I automatically hide or suppress zero balance rows
  382. How To Lock Cells and Columns without Protecting Worksheet
  383. functions to count Yes & No
  384. How do I get the grouping dialogue box to appear in Pivot Tables?
  385. Formula to show zero if reference cell is zero? tricky!
  386. Averaging seconds
  387. Formula Help please
  388. Search for first instance of text & return the value
  389. All Capitals
  390. insert picture excel 2007 from scanner or camera
  391. Vlookup for multiple criteria
  392. Help with IF function
  393. I was creating a histogram; now i have data but no histogram.
  394. How do I compare lists in cells Excel
  395. Comparison Function
  396. how do you nest ROUNDDOWN in an IF formula?
  397. Excel worksheet functions question.
  398. What are the reasons if the "the solver" will not install?
  399. Help Please, Worksheet Change
  400. Can a function do this?
  401. dynamic print area based on cell value
  402. How to insert rows in transposed data table?
  403. vary the vlookup array depending on the value in a cell
  404. How do I select a value from a table based on 2 conditional refs?
  405. Please Help With Days Elapsed And Days Remaining Calculation
  406. How to replace a cell if value is alphabetic
  407. Check Box Macro to hide and unhide a column
  408. IF Function
  409. lookup field and copy the row across
  410. Filter isn't working with a VBA Code
  411. Worksheet numbering
  412. Matching Picture to Reference
  413. Convert cubic centimeters to fluid ounces and cubic centimeters
  414. Please help - formula works in some cells but evaluates to #value in others
  415. Using countif with a name of a range
  416. changing dates.
  417. Complicated formula please help asap!
  418. Paste Links not updating automatically.
  419. using a calculation in a list on another worksheet
  420. div/0 and #num!
  421. How do I color code the "SHEET1" Tab in Excel?
  422. "Too many different cell formats" error in Excel
  423. lbs ounces drams
  424. Using formulas to source a value based on 2 variables
  425. create 2nd list dependent on 1st list
  426. Sending automatic e-mails by date from Exel
  427. Remove dash(s)
  428. Formula Please help
  429. merge workbooks
  430. function help needed
  431. Help with cell formatting
  432. How do I break down a number by multiples in Excel?
  433. Questions should be simple please help
  434. formula question?
  435. How do I make the column & row heading bold Type
  436. How can I make the box remain empty instead of N/A#
  437. variance %
  438. IMPORTANT! HELP PLEASE! Formula
  439. Double if statement
  440. is it possable to run an macro or script at start up as you could
  441. How do i find the counts of data with a condition of other cells
  442. Yet another issue
  443. MATCH and OFFSET
  444. Networkdays formula
  445. VLOOKUP in 4 work sheets
  446. I need help with the IF function
  447. Import Cell Data
  448. locked cells with 2 different passwords?
  449. Protect my formulas!
  450. EXCEL - PASTE SPECIAL COULD HAVE AN OPERATION TO REVERSE ORDER
  451. What is the formula used to calculate the 1st and 3rd quartile?
  452. paste only subtotals, not individual date that makes up subtotal
  453. Insert Picture
  454. Need help with an embedded IF statement
  455. Migrating information into another sheet.
  456. Deleting blank worksheets
  457. IF function with date
  458. How do I avoid duplicating names in excel?
  459. how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2
  460. excel, can put name in one cell and get ther# in the next cell?
  461. matching values
  462. Copying information from 1 WB to another and loosing style
  463. lookup latest entered match
  464. Keeping the hyperlink address hidden in a cell.
  465. Difficult IF Function (For me at least) help
  466. vlookup help!!
  467. spreadsheets and auto General Journals postings
  468. count criteria excell
  469. Extend series
  470. how to hide worksheet using VB
  471. Use of IF function
  472. vlookup on non-contiguous ranges
  473. Re: holiday dates
  474. Need step by step instructions to try, not a demo. Can't remember
  475. Need step by step instructions to try, not a demo. Can't remember
  476. use the OR function inside an IF function
  477. remove #DIV/0!
  478. mohan babu
  479. Variable Cell Referencing
  480. Need to make a mark up table with more than 7 if statements
  481. Filter formula
  482. If this and this, then do a) b) or c)
  483. Need formula help!
  484. How i can create a formula that combine subtotals and sumif
  485. Is there any File Auto Save Function for Excel and Word 2007 (Bet
  486. Inserting variables within file names
  487. indirect function within sumif to reference other sheets
  488. DATE ISSUE!
  489. if or problem
  490. HELP WITH A FORMULA
  491. Simple SUMIF, I think...
  492. Need help with averaging a time but dates are messing up the result I am trying for.
  493. Assistance with Formula
  494. I AM TRYING TO USE BETWEEN IN IF THEN ELSE
  495. Re: Need help with averaging a time but dates are messing up the result I am trying for.
  496. How do I set up a formula to throw out the 2 lowest scores?
  497. convert column values
  498. Creating a formula using RAND
  499. Beetween Sheets
  500. Formula for computing day of the week and time
  501. Adding one month to noncontiguous cells
  502. Double lookup without using vlookup?
  503. using vlookup between two separate sheets
  504. RE: calculating adjacent columns in a work schedule
  505. Excel Formula or access ?
  506. RE: calculating adjacent columns in a work schedule
  507. tagging unique items in a list
  508. Sumif Across multiple worksheets
  509. Intersection of row and column based on input
  510. how do I lock values in excel
  511. calculating adjacent columns in a work schedule
  512. Working spreadsheet highlighting function for Excel 2007
  513. Excel: want neg numbers to show red/pos green via if-then formula
  514. How do I make the cell flash on and off ?
  515. Help... in excel.
  516. Nesting Functions in a worksheet
  517. how to select cells with keyboard if the arrows don't let you go out of the formula
  518. #N/A in mode worksheet function
  519. complex average formula
  520. VLOOKUP using another table for comparison values
  521. excel 2003 If function
  522. how to calculate the area under the curve in the excel?
  523. Function to sum a list of rows with different text except for one
  524. How to change data in a cell, based on the date
  525. Copy sum formula to Other columns not working
  526. time calculations
  527. lookup error!
  528. Excel should let me set print gridlines as a default
  529. Display cell based on multiple cross-references
  530. How to spread 15,000 into 12 months at 10% ?
  531. "IF" functions for Excel?
  532. Find & Search Function
  533. Contitional formatting help
  534. Adding category totals
  535. How do I make a date appear in a cell only when I mouseover it?
  536. finding duplicate rows
  537. web query help.. delay?
  538. Average of lowest 5 of 20 values?
  539. Starting another program out of Excel VB??
  540. "Show all" button not work in protected worksheet
  541. help needed for Internal rate of return
  542. Time (Hours) calculation
  543. How to find avg for step size?
  544. countif criteria
  545. Excel find/replace should allow values to be pasted in.
  546. count coloured cells
  547. custom validation
  548. Calculate due date from a starting day
  549. Data in Cells
  550. Formula using INDEX and MATCH
  551. Re:Final days - London Excel Conference Registration giveaway
  552. Counting unique records
  553. help with lookup please
  554. vlookup or #N/A
  555. Finding unique entries among two columns of alphanumeric data
  556. Using Replace command for replacing a character by an ALT+ENTER
  557. If Statement - With Formated text
  558. data validation
  559. [sorting rows]
  560. Use concatenated text as name in formulas
  561. Frequency of occurence
  562. find and paste formula
  563. delete all values in column?
  564. Lookup Value in Range/Array and Return Column Header Value
  565. Extracting multiple entries in a cell into their component pieces
  566. Using Error Message as test Criteria
  567. Linking in the same workbook
  568. Add to an IF statement
  569. Data downloaded with green triangle(indentation)
  570. Formula bar doesn't have an equal sign
  571. Merging 3 workbooks when they are not exactly the same
  572. Question about having the date autofill for schedule sheets
  573. If A1 has a #, that is displayed, if D1 has a # that is displayed
  574. condtional format to
  575. Hyperlinks in pull downs . . .
  576. Can anyone help please?
  577. Error: The text string you entered is too long.
  578. Combining spread sheets
  579. on excel file cannot acceted the password
  580. How do you add figure with a word in?
  581. excel cannot accepted the password and finily cannot open file
  582. Lookup table for two conditions
  583. Reset Worksheet Size
  584. validation from two columns
  585. comparison
  586. VLOOKUP
  587. cell math to decrement/increment a cell
  588. DATE function clarification
  589. Inventory Spreadsheet
  590. Relative references
  591. I am getting a strange round off error in excel
  592. IF Statement
  593. How do I change color pattern based upon a formula within a cell?
  594. dynamic lookup
  595. Problem understanding dependant lookups
  596. Help!!
  597. I love this forum! need help again!
  598. A Tricky One......
  599. sumif, countif, sumproduct?????
  600. Can vlookup be used to search in more than one worksheet?
  601. How do I get rid of an extra page before printing on an excel sp.
  602. how do I calculate minutes when given two times?
  603. TROUBLE RENAMING A WORKSHEET IN EXCEL 2000
  604. Extremely frusterated. 3 quick questions
  605. A "ConcatenateIF" Function in Excel
  606. Fixing some bugs
  607. Please help me (urgent)
  608. Queation about monthly and weekly averages
  609. adv filter
  610. adjusting decimal place in protected worksheet in excel 2007
  611. VLOOKUP Query
  612. how to look up values with two independent variables
  613. Formula for calcing dates
  614. add and subract in one sum
  615. SUMIF variation?
  616. Relative, absolute & mixed references in many cells
  617. Another Date related question....
  618. How do I find unknown interest rate using TVM functions
  619. IF or IF(AND Function
  620. Variable File Name
  621. Web Query (Excel 2003)
  622. Formula
  623. How do I write this formula in Excel?
  624. how do I add Drop down menues in Excel?
  625. Two Workbooks into 1 File??
  626. formula to obtain difference between two dates.
  627. Auto-create separate worksheets...
  628. Pass variable to NORMINSV function to get only mean value
  629. return a list
  630. Making formulae function throughout worksheet
  631. Diffence in 2 formulas
  632. Grouping According to Sets of Rows
  633. can i calculate the number of occurances of a partucular value?
  634. how do i setup a table of daily income and expenses
  635. dates, 1 month prior
  636. protecting ceels to copy -paste action
  637. Can I create an IF statement that looks for part of a string of te
  638. Simplifying a formula
  639. Calculating in a list
  640. Rounding up/down
  641. Use multiple criteria with COUNTIF: between dates and not blank
  642. Conditionally summing cells based on conditions in other rows
  643. Find / compare result with list
  644. Trimming cell contents?
  645. Saved excel workbook does not open from desktop icon
  646. Copying & Filling in data from One file into another.
  647. Working Merchandiser Schedule...
  648. Can't consolidate non-data (ie text) cells from worksheets
  649. CELL Function: cell reference by formula
  650. Numeric calculation
  651. Combining multiple lists into one !
  652. Help with calculations
  653. adding up several different criteria
  654. How do I insert a symbol AT THE END of text for multiple cells in Excel?
  655. sumif
  656. How to copy an array without changing relative cell refferences?
  657. How to copy an array without changing relative cell references?
  658. How to copy an array without changing relative cell references?
  659. How do I get my date to look like this in Excel (Monday June 19,.
  660. Can I have error message when formula is over value?
  661. question about Net present value way of calculation
  662. function within a function
  663. How do I separate a hyphenated word in Excel?
  664. How to automatically populate the next available invoice #
  665. How to SUM #N/A
  666. Subtotal Function
  667. word file into excel
  668. Retrieve value from a range of cells
  669. Counting and incrementing and then concatenate...
  670. Match 2 criteria with 2 criteria
  671. How do I identify who placed security on a workbook?
  672. Help with a Macro - Excel 2003
  673. Find/Replace Help
  674. Progress Tax Calculator
  675. Re: Help with a macro/formula
  676. The same formula doesn't work again?
  677. I want to change comment printing cell 3 to whats in cell 3
  678. index/ match formulas orice
  679. How do I recover an Excel worksheet that I erased?
  680. lookup a list of values for an array formula
  681. How do I add drop down choices to a spreadsheet?
  682. can "real time" be cell function in EXCELL?
  683. how can i check for #Value! ? ... or how do I do MaxIf??
  684. a note on a workbook
  685. How do I tally checked check boxes in an Excel spreadsheet?
  686. Date help
  687. DCOUNTA Complex Criteria Question
  688. Dynamic update for graph data
  689. How can i round a number to closest tenth number?
  690. my cells with email addresses ling me to the wrong ones
  691. Which Finance Function should i use to solve this
  692. VLOOKUP and DGET to find a value with multiple criterion
  693. Avoiding Duplicate entries - from a drop down
  694. convert a string to range?
  695. Compile all Worksheets in a Workbook in to a single Worksheet?
  696. if function help
  697. edit comments in locked cells
  698. Sheet copying
  699. How do I estimate the year spend if spend is $26000 as of May?
  700. Array formula to give blank
  701. Can I use a formula to filter data?
  702. How to add Restrictions to Combo Box?/
  703. TimeTables
  704. How do I find the maximum time value from a list
  705. Pulling Data off Web - Need Function Help
  706. If more than condition forumula
  707. using formula to tell when client last ordered
  708. Indirect - Why does it seem to only work sometimes?
  709. Alternative to Indirect
  710. moving column/cell data to rows/cells fails
  711. [Q] Auto filter possible on multi-value cell?
  712. Simple stuff (Probably)
  713. Re: Simple stuff (Probably)
  714. Add-in functions not available
  715. Adding zero's to Time formated cell
  716. protection - hiding worksheets
  717. Conditional formatting on Consecutive cells
  718. protecting cells against editing by copy/paste actions
  719. Problem: zeroes added to "general" format cell
  720. Filtering using ends with decimal criteria
  721. Sum & Lookup function
  722. is there a formula that remove duplicate values from a range
  723. Sorting into different worksheets from a unique value
  724. Not showing blank and non blank items in filter mode for values
  725. copy from excell to outlook
  726. equation editor toolbar
  727. Protection Copy and Paste
  728. Editing Formulas
  729. How can I set up electronic signatures in Excel?
  730. Worksheet problem
  731. Setting Up A formula For A Time Sheet
  732. Conditional Formating
  733. Retrieve text content from range with criteria
  734. =IF(AND) ASSISTANCE
  735. Copying specific rows
  736. automatic subtotal
  737. Filter unique, and then count
  738. Sort cells populated with an Indirect function.
  739. How do I change text from all caps to normal type?
  740. using =sum() to get a percentage
  741. Can I use a lookup function that pulls referenced cells in multip.
  742. date function to find most recent order
  743. Applying Offset to Range in VBA
  744. String splitting for inconsistent strings
  745. email from Excel using If function
  746. Save Changes Prompt
  747. Paste special into a filtered work sheet
  748. Setting up function is 1am between 8a-8p or between 8p-8a?
  749. [Excel 2007 Beta2] Function SUMIFS
  750. Copyin multiple sheets data into one line
131