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 |  88 |  89 | 

  1. How to discover the difference
  2. A conditional Sum & Count
  3. Concatencation and formatting
  4. Screen Size
  5. Offset function gives different answer in columns v Rows
  6. Protect an excel spreadsheet
  7. help with data labels
  8. lookup function help
  9. Area
  10. Importing Data Wizard
  11. separate lastname from firstname
  12. Data Conversion - times, dates & rows
  13. Combo boxes and drop down lists
  14. SUMPRODUCT
  15. SUMIF formula using data from another file
  16. definite integral
  17. need formula help
  18. conditional formatting expiry dates
  19. Creating automated timeline
  20. Excel Functions
  21. I have lost the soft, blue borders of some cells.
  22. Bolean Logic with the Advanced Filter
  23. Calculate running average but not count a zero.
  24. SUM, AVERAGE and PRINT with #N/A cells
  25. My Worksheet Needs to Input Cell Data Automatically to Other Cells
  26. Drop Down Starting Position
  27. IF Function based on a set of numbers?
  28. Drop Functions and Sorting
  29. Forcasting question
  30. How do I use a cell format to figure out a data?
  31. Count IF
  32. Sum with New Cell Reference
  33. Is there a function to print file name/path on a spreadsheet?
  34. Excel 2002-7: Modifying Sub Total Function to allow insert blank r
  35. IF
  36. IF
  37. Chart Data Table
  38. Adding Rows
  39. Using multiple IF conditions
  40. Using dropdown in protected sheet
  41. how do I add gridlines to a single cell?
  42. Help with INDIRECT
  43. Auto Sum
  44. Sum or Average with #N/A cells
  45. Cells will not clear - if I type 1 it comes up as 100 know matter
  46. How do I count just the numbers in a cell, no spaces or comas?
  47. Linking worksheets in different workbooks
  48. Import worksheets from another workbook?
  49. Vlookup from more than one Tab
  50. Trying to compare the datas...
  51. Enter a number on different cells automatically ?
  52. number of periods function where payments(inflows) are not equal
  53. sumif error
  54. Getting a value within a range
  55. Headings to appear on next pages?
  56. I think I should use absolute values to:
  57. Quick lookup for data
  58. Carrying last $$$ amount to another field
  59. I want to sort a column of data which is the SUM of three cols
  60. If Date Function
  61. Page Layout
  62. fiting my workbook to get the most colums and rows per page
  63. Formula for non matching items
  64. Sum of cells, where there are not errors in them
  65. creating numbered coupons using word and excel mail merge
  66. Excel file in compatibilty mode and not all sheets within the fil.
  67. Copy of realtime data.
  68. test 2 ranges
  69. Protect/unprotect a formula
  70. calculate PV of lump sum payment
  71. HELP!! VLOOKUP, INDEX or MATCH??
  72. calculation help please
  73. excel opens right justified
  74. Shading specific cells
  75. conditional formatting in excel 2003
  76. how can i use the = to move formatting and content between tabs?
  77. 35 Firmware Drivers R4 Dsi. R4i Dsi 79479
  78. 01 R4i Dsi, Drivers Firmware, R4 Dsi nintendo Dsi 45907
  79. Excel: auto-repeat a value in different fields
  80. Trigger a Date & Time stamp by entering data in another field...
  81. Formula
  82. Index match combination
  83. Total price...
  84. File name Save
  85. "Global" change Pivot Value field settings
  86. Add rows depend on the number in a cell
  87. Add Rows depends on the number in a cell
  88. Help to shorten a formula
  89. Cell protection short cut button
  90. what's the function to use absolute value in excel for a macbook?
  91. Need to calculate the number of days between two dates on a 30 day
  92. Excel If statement copy only if ISNumber result is yes
  93. 3 D reference of IRR formula.
  94. Unable to create/use hyperlinks
  95. Choosing Names From a List
  96. Identify which column 'Large' finds a match in
  97. Date difference Average
  98. Need to stop formula and keep value on met condition
  99. Stop displaying a message because of a formula
  100. finding a number within a range
  101. Countif function with multiple column criteria?
  102. Dragging across columns: I want column constant, but row increment
  103. linked workbook cell returns 0 is source workbook cell is blank?
  104. Allow users to edit cells but not save the info
  105. Can you allow users to copy & paste protects cells
  106. Formula for week ending
  107. I need to know how to use the solver
  108. Will not give accurate totals.
  109. Get cell reference address
  110. How do I use the text content of a cell as a worksheet reference?
  111. Round up or down to $X.X9 or up to $X.X5
  112. Drop down fill box does not appear when cell clicked.
  113. formula
  114. WHETHER TO USE COUNTIF, SUMIF or SUMPRODUCT
  115. Logic If formula - multi-parameters can not get to work??
  116. Macro to insert lines
  117. sumif
  118. Goto last row of the sheet
  119. sort function
  120. Values imported from one workbook to another
  121. Multiple logics in one formula
  122. Inserting page breaks
  123. How to add hyperlink a column of URLs using Ctrl+K
  124. sum numbers in cell string array
  125. Conditional formatting.
  126. Looking for an ID number in a column
  127. I want to increase the value in cell A1 from 0 to 10 then reset
  128. Utilizng full AutoFilter features while specific cells are protect
  129. Utilizng full AutoFilter features while specific cells are protect
  130. How do I creat a math formula that remains in Excel.
  131. create a list that places data in 3 colmuns (cells) from mult row/
  132. Average every x cells
  133. Worksheet Automation and Size Limiting
  134. Adding Columns with Multipliers
  135. conditional formatting question
  136. Filtered spreadsheet performance
  137. Calculate Months to Determine Length of Service
  138. IF function help
  139. if statement with date
  140. changing the vlookup col_index_num
  141. conditional drop down list problem
  142. 2003 function moved to 2007 unable to change absolute references
  143. Custom Cell Style - Shows as error and cannot be deleted
  144. Automatic Worksheet Calculation when Worksheet Name Changes
  145. Problems CONCATENATE expression
  146. Which is Better / More Functional / Accurate
  147. Using NULL in shading cells
  148. finding "Like" names in rows
  149. Countifs of prior years monthly data based on MTD today
  150. trying to match text in 2 worksheets
  151. vlookup or index for text on 2 worksheets
  152. More on Combined IF Function
  153. sum the current month
  154. How do I change fonts in a DV drop down menu
  155. Converting number of days
  156. format as a table and cannot remove formatting
  157. Date calculations resulting in negative numbers and averages
  158. Vlookup and return the value from the look up value sheet
  159. Count with multiple criteria / combination
  160. Functions
  161. If Formula - checking the same cell for different entries
  162. how to make a function to extract from to
  163. Copying data from several sheets to a front sheet
  164. Multiple criteria IF statements?
  165. how to give hyperlink to hidden excel sheet
  166. array of data and nested bits
  167. IF Statement - compare to coloured cell
  168. Customized marcos cannot save to tools-bar
  169. count a value in a date range based on a date in another workshee.
  170. merging data/worksheets
  171. Selecting a row in a worksheet
  172. Horizontal Scolling Does not Work
  173. Get value equal to final point of chart trendline [=Trend( )] ?
  174. Horizontal Scroll Bar Not Working
  175. How Accurate is Solver?
  176. Combine IF Statments
  177. Rounding up a cell to the next ¼ hour.
  178. function needed
  179. compare and return a value from another worksheet
  180. Multiple selection drop down list
  181. excel does not mark cell with inserted comments.
  182. I am trying to link
  183. Percentage to Get Invested Return
  184. Strip Out Four Characters, then Average
  185. Add 2 days before and after birthdate
  186. Link changes in destination workbook
  187. Rolling 12 Spreadsheet
  188. IF Formulas and Summing Results
  189. Comparing text and then adding numbers if the text matches
  190. Rearranging irregular data to monthly format
  191. cell content - data entry order by enduser
  192. How can I calculate equivalent annualized cost
  193. what do you call the "button" that lets you select a single item
  194. Conditional Indexing
  195. Add $1 to a long row of #'s
  196. Can Excel 2007 copy and add worksheets based on population a cell
  197. How can I protect a sheet so the rows/columns can't be deleted?
  198. Link format along with contents of another cell
  199. I do not want the letters and numbers on the border to show
  200. Using IF to compare ranges
  201. How to save a blank excell sheet
  202. data sorting
  203. Counting the # of values in a range ???
  204. I can not sort data - why
  205. subtotal function won't work
  206. Calculate Average with 'x' in Range of Cells
  207. AUTO HIGHLIGHT ONLY ROW WORKING IN
  208. Tabulate Survey Results in Excel 2003
  209. formula that advances
  210. how to convert list of numbers to barcode font
  211. Weighted Averages for Rankings
  212. multiple sheets 2 work books
  213. formula to work in a 3-d reference with 2 work books
  214. Conditional Formatting
  215. indirect function with r1c1 style
  216. Comparin data in cells
  217. Vlookup with part of cell text
  218. Formula With A Minimum Value
  219. Multiple Logics to be looked at
  220. Find certain text in a cell
  221. Formula for Cell address
  222. Cell Address presents in Formula
  223. Default print layout
  224. Extract Formula to Text
  225. Repeat Cell Based on the Value-Excel 2003
  226. How can i give name to the selection
  227. How can I lock formulas but allow date entry in a cell
  228. summing to defined ranges
  229. Multiple IF functions
  230. how to remove spacing in between text
  231. Seperate Name, Street Address & City, State Zip
  232. Vlookup
  233. How to find a column number using variable criteria?
  234. Multi-Worksheet Sumproduct & Listing
  235. Trying to make a SPC Chart at work......
  236. Listing multiple values in a macro
  237. copying info from one workbook to another one
  238. LOOKUP & MATCH syntax ??
  239. Conditional Formatting based on 2 criteria
  240. COPY RIGHT AND TRANSPOSE
  241. Deleting rows (with zeros) with a macro
  242. Paste Formula
  243. Remove Zero Formula
  244. how many rows away from a number to a space below
  245. Average formula for dates range - Excell 2007
  246. how do I automatically open blank workbook when Excel
  247. Lookup two factors in an array
  248. xlbgnm in remote data
  249. Input "="
  250. Truncating data in drop down list
  251. how to save worksheet with hard tabs
  252. Re: Figure out date from total days in year
  253. Last Line
  254. Functions referencing a different workbook
  255. Sum when one cell is blank & another cell is not blank.
  256. Pyramid calculate
  257. Weekending Function
  258. Delete blank columns
  259. Copying a column list from one sheet to another and repeating???
  260. lock of copy command
  261. Based on data in previous column - sum of values in next column
  262. Moving Calculations to a master sheet
  263. Macro !
  264. How can I add up multiple IF results.
  265. linking cells with scheduling workbook
  266. Day of week Fill down column not working
  267. Run macro on all sheets
  268. IF function question
  269. Using Sumifs
  270. VBA Code not working on Shared Workbook
  271. find the second match using the match function
  272. Excel 2003
  273. Updating embedded links in Excel
  274. Protect Validation from Copy Paste function
  275. Macro to make multiple copies of a formatted worksheet
  276. Ranking Formula
  277. match-up formula
  278. Drop Down Box in 2003
  279. SUMMATION combined with PV formula
  280. Formula question
  281. Need help finding the last cell w/data
  282. Creating an "If" Function with multiple "if"s
  283. Display of revision date in document
  284. Excel spreadsheet embedded in Word, then saved to PDF
  285. rounding numbers to the nearest dollar amount
  286. SUMIF has slowed down the workbook
  287. 24 hour clock formula for elapsed time between 1215 and 1630
  288. VLOOKUP ?
  289. Sumproduct array
  290. Calculate Monthly Inventory Usage
  291. Counting occurrences with 2 seperate criteria
  292. Need help with formula to search and compare data in different col
  293. Lookup Question
  294. Copy/Paste Doesn't Carry Formats
  295. Linking Data from 1 worksheet to another by using dates?
  296. concatif
  297. reference to other sheet as a string
  298. Tidy up multiple find and replace code
  299. copying conditional format in a range of cells in excel 2007
  300. converting seconds into minutes
  301. How can I test for colour format in if statements?
  302. Creating an active timeline of data from cell input
  303. Delete part of a text string
  304. function =IFERROR LOOKUP works in excel 2007 not in excel 2003
  305. roundup a month
  306. What formula do I use to copy only text on left side of a comma?
  307. Creating one formula for use in two different cells
  308. Workday
  309. Wieghted average rate
  310. Formula for the calculation needed to come up with a total
  311. Displaying items from a column list in another sheet?
  312. countif with multiple functions
  313. Worksheet formula - auto populate
  314. lookup then concatenate
  315. Text from excel address
  316. How do you write a recursive formula in excel?
  317. Extract one character
  318. formula setup for number combinations
  319. Use Sum() with variable range
  320. How do I find arctanh() in exel
  321. How do I set my time and get rid of sample time using functions
  322. Separate raw data onto different worksheets
  323. from where has to access mail merge option in MS Excel 2007
  324. Help with formula
  325. Concatenate HTML containing double quotes
  326. Help Counting 10 Columns * X Number of Rows
  327. Concantenate columns with dates and text
  328. Can Not get cell to accept any format change! Source from html
  329. Sounds simple but isn't - displaying cell text
  330. Data validation (lis) question
  331. Difficult Formula lookup
  332. Unexplainable XIRR #NUM! Error
  333. Countif and Sumif functions not working in Excel 2007
  334. Countif & Sumif fx ref data in multiple columns
  335. Can I have two conditions in a SUMIF?
  336. Does anyone konw how to set up a simple weekly household budget
  337. Formula to Count
  338. Is it possible to SUM based on value of another column?
  339. Sumproduct DIV/0 Error
  340. RE: AVERAGEIF
  341. Adding X# of minutes to time (HH:MM:SS)
  342. vlookup and using single quote
  343. Accept or Reject a value
  344. Count functions
  345. Difficult formula
  346. How do I find only number caracter in a string?
  347. find duplicates in list
  348. Using the IF fuction for multiple cells
  349. Macro for Selecting Cells within a Range
  350. Show the formula not the result
  351. How do I turn on color banding to locate the active cell in Excel?
  352. Formula for Tab Content
  353. multiply data in every 3rd row on a sheet
  354. Array formula SUMIF with 2D sum_range array
  355. clipboard hold how much items
  356. Set up a count and countif?
  357. Position of first number in array greater than a given number
  358. Sum of numbers in multiple columns
  359. MATCH to return row number not working in HLOOKUP
  360. Amount minus VAT
  361. Index Match Problem
  362. macro to list folders only, not files
  363. counting words and assigning a numeric value
  364. how do i convert data with miliseconds to just h:mm:ss
  365. Conditional Formatting - Comparing 2 columns
  366. Should I use VBA or can I use formulas for this task.
  367. Calculating NPV
  368. Donde hay que poner la funcion DESREF para crear un ragon dinamico ?
  369. Vlookup
  370. #N/A error with Yield formula
  371. Analysising data between sheets
  372. Number format to Text
  373. write macro code
  374. Combine HLOOKUP and MATCH
  375. Return text not excel address
  376. Linking data between spreadsheets
  377. Finding specific text in one cell and returning data from another
  378. bring info from one sheet to another sheet
  379. Why Networkdays returns 1
  380. Data Validation
  381. Excel 07/Acrobat 8.1.4
  382. Macro to Save data
  383. Formula Question
  384. Working with XML data and functions
  385. Multi worksheet protection & editing ability
  386. Excel
  387. Master Worksheets and Individual Worksheets
  388. IF function
  389. Consolidating multiple worksheets into one
  390. Can i use a reference inside Countif
  391. Using Value of a Cell in the Range Reference in VLOOKUP
  392. text format to date format ?
  393. Date Format
  394. Converting a number to hours and minutes
  395. how can i work on information copied off the web on a worksheet?
  396. Creating a summary list of larger dataset
  397. automatically update date
  398. how can I delete "*" formated as text
  399. concatenate if
  400. Sum of results of multiple criterias
  401. Filtering a Text Column based on a particular word
  402. Merging duplicate entries in Excel or deleting the duplicates (Exc
  403. Problem Pasting Data
  404. Multiple Summation. HELP!
  405. Tabs
  406. Macros
  407. Lookup returns unexpected result
  408. Excel help
  409. Look up field and auto fill the rest
  410. Sum of a Look up Value
  411. No Subject
  412. Weighted Averages?
  413. How can I have Excel determine what the last digit is in a series?
  414. Consolidate Excel Data from multiple sheets into one
  415. Formula Help
  416. function to give me cell reference
  417. NETWORKDAYS
  418. Tough question moving data (may require macro?)
  419. LOOKUP function - I think
  420. Given a date, how do I get the 1st date and the last date of theprevious month?
  421. How do I get text to speech to work in XP?
  422. Data validation list & vlookup
  423. how do I create new tabs?
  424. How to SUM on a condition?
  425. find and replace Excel 2007
  426. No Subject
  427. Macro help
  428. Need Help With Formula Please
  429. Help with Function/Formula Overloads
  430. DROP DOWN LIST
  431. show vendor that is due
  432. Need Help with a Formula
  433. How in the world!????
  434. Named Ranges and Dynamic Formulas
  435. Vlookup Problem
  436. Array formula: how to join 2 ranges together to form one array?
  437. Returning to multiple data fields pivot table view
  438. Changing size of check box
  439. NEED TO COUNTIF WITH TWO CRITERIA
  440. Rate of change
  441. Weighted Regression
  442. PERCENTAGE OF VACANCY
  443. formula result is zero but zero is not populating in cell
  444. Conversion help
  445. How do I convert mun to text in excel
  446. summing 2 to 8 separate numbers in a single cell
  447. macro apply to all worksheet
  448. Averaging Blank Cells
  449. Hierarchical outlining
  450. How to insert $ and € amounts in the same worksheet?
  451. Hierarchical outlining
  452. Sum Result of lookup in excel 2007
  453. Is VLOOKUP what I need?
  454. What function do I use to calculate a Sum of Digits?
  455. help with formulas???
  456. Macro Buttons
  457. Macro warning - how to delete macro
  458. extract row number from Pivot Table Result
  459. Freeze Pane option in Vista
  460. help with look up formula
  461. Hyperlink problem
  462. Rows to columns
  463. Formula
  464. VLOOKUP & Array
  465. add-in manager
  466. Collapsing/expanding grouped areas on multiple pages
  467. Vlookup returning NA when referencing cell data to another sheet
  468. Deleting rows (with zeros) with a macro
  469. Excel insists on adding character to formula
  470. Page break or Fit to Page Macro
  471. retriving specific data?????
  472. finding a match
  473. Need your help with formulas in excel!!
  474. Absolute Sumif
  475. Conditional SUM
  476. Date formula question
  477. extend information into cells after doing subtotal Excel
  478. how to sum quite a bit of duplicates into a cell
  479. Can't stop recalc
  480. VLOOKUP worksheet function returns zero for empty cells
  481. multiple columns applied with one picklist
  482. Changing to Proper Case
  483. narrowing down records in another worksheet
  484. Options for DIV#/0
  485. IF OR
  486. insert records?
  487. About the usage of the function
  488. Adding only part of a column of data
  489. Comment box
  490. sum cells depending on color of cell
  491. vlookup error
  492. INDIRECT - only partial variation to formula
  493. sumif
  494. Please help! Macros
  495. Solver with text
  496. Sumproduct
  497. How to show Excel Worksheets in two screens?
  498. How can I construct a league table from a list of sports results?
  499. Sheet Name Font Size
  500. Need Function/Formula that will add a column based on two conditon
  501. complex index function not working
  502. trying to update a cell with new data based on vlookup functions
  503. How can I reference a cell within a formula
  504. How to get my total back?
  505. Help with adding times to give the result as the day
  506. need a function that will work using multiple work books and sheet
  507. Link sheet with Condition
  508. File extension *OUT.XML
  509. vlookup function that returns the greates/oldest of many to one
  510. error - unreadable content in pivot table file - how do I find it
  511. Sumif by month and year
  512. why doesn't excel count "numbers" in an IF formula
  513. How can I refer to sheet number not sheet (name)?
  514. Formula works on all worksheets except for 2
  515. changing cell formula
  516. cell auto-updating
  517. Comparing Two workbooks
  518. sumproduct with dates for aging
  519. Suggestions needed
  520. Changing Default Print Quantity
  521. COUNTIF and multiple criteria
  522. Conditional Sum Error - N/A
  523. Grouping above in Excel 2007
  524. change link path when open destination file
  525. VLOOKUP multiple values
  526. Finding the cell with a specified string
  527. combine multiple rows in one column
  528. Recording macro usage
  529. how to change the link in excel easily
  530. Impossible? Condensed search results
  531. Expiry of Excel Sheet or WorkBook
  532. Expiry of Excel shee
  533. SUMPRODUCT Question
  534. excel function solve problem?
  535. Ranking to include new list
  536. Protect conditional formatting in destination cell
  537. Column Width and Row Height
  538. 0.3024606 Now Click Here To Have It ... 0.7831205
  539. 0.6651563 I Feel Curious About It ... 0.7786058
  540. Calculating largest gap in a series of consecutive numbers
  541. Calculate # days from today in a Pivot Table
  542. Excel Filter and Autopopulate
  543. Editing Queries In Excel 2007
  544. Free European Girls Chat
  545. how to get printed in high ponts in work sheet
  546. How do i strip off Upper case Characters to another cell in Excel.
  547. Specify a font from a formula?
  548. how do I do a F test (data analysisi) on excel 2007?
  549. undo and redo commands
  550. Automatic adding in a single cell w/o equal sign
  551. XNPV documentation
  552. Still stumped
  553. Copying cell into another cell but use append
  554. Horizontal bullet graph
  555. Miles per gallon spreadsheet
  556. stumped
  557. Import Text Wizard Only Returns One Row
  558. Activating object from Excel cell
  559. index match help
  560. XIRR and EDATE functions return as #NA in 2007 in compatability mo
  561. How do I format a cell to show weight in stones and pounds?
  562. Date lists
  563. Nest 3 SUMPRODUCT formulas - Possible?
  564. GRAB THE GOLDEN OPPURTUNITY TO EARN MORE MONEY IN THE WORLD
  565. how to share information between sheets in a workbook
  566. Linear Interpolation
  567. Centeroid
  568. How to swap the contents rows and columns in a spreadsheet?
  569. Macro Does not Work on Button
  570. How to get string to use IF formula only when another cell is text
  571. Excel
  572. formatting
  573. Create helper column which returns a text string based on multiplecriteria.
  574. period delimited numbering for Excel sheet?
  575. is there a formula for quarterly expenses in Excel?
  576. Name Worksheet
  577. Password for cell protection within VBA
  578. Web Hosting, Reseller Hosting, and Dedicated Hosting!!!!!!
  579. The One Formula
  580. copy cell from file with variable name
  581. Random #VALUE! error in simple SUM formula results
  582. Calculations
  583. Copy links to other locations
  584. Excel Drop Down/ Autopopulate
  585. Extracting firstname and secondname with functions
  586. Can I use 4 conditonal foamts in a column?
  587. Four macros, one main output
  588. Rounding value from millions to decimal places
  589. Timed macros
  590. Percentages
  591. !very important for your life...
  592. excel functions
  593. New Formula Idea
  594. Summing minutes and seconds
  595. Returning value in secocolumn based on selected value in first col
  596. sumif function
  597. how to get totals?
  598. not sure if i need vlookup or match/index
  599. Look up in a list of the same text
  600. Formula - IF / OR ???
  601. pivot table for multiple worksheets
  602. How to Replace ? With Space
  603. Training matrix
  604. Date format
  605. how to insert individual lines into a cell
  606. The Count Function
  607. Count
  608. How do I look up which column a value is in?
  609. Sum of values typed in a specific color
  610. How do I add numbers in a range of data from days of the week?
  611. Dynamic Worksheet Name
  612. Groping
  613. Help with Formula for.................
  614. Simplify code
  615. Multiple data entry with multiple results
  616. price list changes using conditional functions?
  617. how do i find specific data in a cell and its colocated cell data
  618. is this possible
  619. Excel EndUp button bug?
  620. Help with formula
  621. 3d Pie in Excel 2007
  622. Multiple Values
  623. search function using wildcard
  624. Another date formula
  625. deleting columns used in concatenate function
  626. Add values in "P" that fall between dates "03/01/00 and 03/31/00"
  627. Conditional Formatting Driving Me Crazy
  628. array formula (I think)
  629. IF statement
  630. How do I export multiple lines of data from a pivot table?
  631. Password protect sheet from viewing
  632. dynamic sheet name in a formula
  633. Multiplying two validation lists to get a ranking
  634. sheet tabs
  635. Count
  636. trying to subtract a range from a cell
  637. Conditional Formatting Multiple Columns
  638. Pivot Table cell size
  639. Array with multiple selection criteria
  640. Vlookup multiple criteria multiple occurrences sum values
  641. Cell has pop up box when selected. how do i edit that box?
  642. IF AND Statement Needed
  643. Conditional sum equals 0
  644. Concatenate
  645. Date formula
  646. Sum multiple criteria with a range >than and < than
  647. List Duplicates
  648. Adding up Cells Given a Condition
  649. Formula & Referencing Question
  650. Can a row containing protected & unprotected cells be copied?
  651. GRAB THE GOLDEN OPPURTUNITY TO EARN MORE MONEY IN THE WORLD
  652. summing same cell in multiple worksheets
  653. Cell will not update
  654. sum of getpivotdata()
  655. date formulas
  656. getting pivot to show finctions data calcs across columns, not down rows
  657. Pricing Analysis a bit convoluted
  658. Cell Reference
  659. Create a new sheet containing random sampler 200 rows over 2000
  660. Search function
  661. Macros
  662. Re: Comparing dates
  663. How to ungroup fields in pivot table(excel 2007)
  664. moving part of a column into another column
  665. Look up with 2 factors
  666. present value of "past" and future amounts
  667. Return a working formula from a Vlookup
  668. Rounding value in place
  669. Excel
  670. Rounding number within cell value
  671. how to create a reverse lookup after you do a vlookup in a data
  672. Formual not working when 2003 WKB saved as 2007 Macro Enabled WKB
  673. Data Validation List with Blanks that can be edited
  674. Can Excel display the ratio of two numbers?
  675. EXCEL 2007
  676. Scan directory and import file conditionaly
  677. sumproduct, multiple if, some same cell, determine number of rows
  678. Lookup Function
  679. Rounding up to next dime
  680. How to create an IF function
  681. Hiding Results when result should read blank
  682. XIRR over several years
  683. vlookup error
  684. Selecting file
  685. Charting % of Instances
  686. QUARTERLY Profit and Loss Statement
  687. live chart title and a scroll bar
  688. Time functions
  689. Comparing dates
  690. Pivot Table formating
  691. I know my password, yet it will not open my workbook
  692. IF function
  693. Morefunc 5.06
  694. How do I write an If(And( function using dates as my logical test?
  695. Conditional Sum formula
  696. Convertin hours into days, hours and minutes
  697. calculating only weekdays
  698. Vlookup and/or combing data from two worksheets
  699. Change Date
  700. Advanced if function??
  701. Adding a scroll bar
  702. Average non-consecutive cells excluding zero
  703. Agrument or if/and statement
  704. Control Box
  705. Data - Validation - List
  706. How do I reference contents of a cell at the bottom of a column?
  707. conditional formatting
  708. Countif if counted results are based on formula
  709. Find and Replace #DIV/0!
  710. sumproduct
  711. Ctrl+shift+enter
  712. How to get number of filtered records found displayed in a cell?
  713. error message that says "too many different formats" Fix?
  714. file name in a formula
  715. Data Consolidation formula
  716. formula to get number + 80 % from Previous Balance
  717. Formula to get increase by 80%
  718. SUMIF based on several criteria.
  719. Copy in order
  720. convert number to words(like 1.00 = Dollar One Only)
  721. sumif multiple criteria, some same cell
  722. how do I fix formatting mistakes: cells and contents are wavy
  723. Excel
  724. Formula for number combinations.
  725. Rental Lease Agreements
  726. Simple subtraction formula returning strange results = Excel glitc
  727. How many months between two date range
  728. How to create a function to alternate names in a cell from a list?
  729. calculate years of service
  730. SUMIF NOT #VALUE Question
  731. Need blank cells to remain empty
  732. Need to set up bckgrnd color to link to different worksheets.
  733. Seqential numbering
  734. Finding a name with partial description and deleting all occurrenc
  735. How do you Break it down by age group
  736. NUB Formula Question
  737. count no. of commas (,) in a string in a cell
  738. Open to Suggestion/s
  739. Formula help
  740. which functionalities are available in databases and not in sprea.
  741. DRAG DOWN COLOR FILL BOX 2007
  742. macro help needed
  743. how do i calculate the number of days between two dates?
  744. how can I calculate number of days based on start and end dates?
  745. Find what numbers add up to a specific number
  746. Convert numbers to letters in excel
  747. Search cell for any of 6 criteria
  748. Convert numbers to letters in excel
  749. LOOKUP function syntax across a table?
  750. Grouping data
  751. Conditional cell highlighting
  752. copy ?
  753. No Subject
  754. Which column in an array of columns
  755. w/s Formula to Automatically Create Two 2-equi-interval Tables ??
  756. Formula results don't change when it's pasted/dragged into a new c
  757. quarter
  758. What does =#N/A do in excel?
  759. Count Unique With one Condition & No ROUNDUP
  760. Lookup with parts of strings
  761. Bullet Chart – Value Y Axis
  762. Counting Formula
  763. Convert Number in to Hours....
  764. Designing Point & Figure (PNF) Charts in Excel
  765. Link text box to a cell
  766. Any formula to insert last document saved date ?
  767. Numbering Rows
  768. Numbering Rows
  769. Conditional Format Based on Date
  770. Matching values in a row
  771. Moving data from one spreadsheet to another
  772. Result not greater than .............
  773. Sorting a Worksheet
  774. Need help with Hyperlinks in Excel
  775. Conditional Format based on date
  776. If this = then that formula??
  777. How to look up 2 Cell Values
  778. Multiple Worksheet Calculation
  779. IF Function
  780. fill down empty cells at every change in value
  781. Same formula on multiple sheets
  782. How do I show number with spelling word example "89" as " eighty .
  783. Calculation using IF
  784. LOOKUP Question
  785. Calculation using IF
  786. Calculation using IF
  787. HOW TO HIDE ALL EXTRA ROW AND COLUMNS
  788. can I create a drop down list to pick a date ?
  789. How do I sort column changes in different worksheet?
  790. Can I combine IF/AND/OR statements?
  791. Averaging scores
  792. Moving object
  793. Need help with Line Chart...
  794. INDIRECT function returning REF#
  795. Alternative to WORKDAY when Analysis ToolPak not loaded
  796. Sum If function
  797. protect sheet but column width changes
  798. realtime list sorting/data exraction
  799. counting no. of times a character occurs in a cell
  800. count no. of times a character occurs in a cell
  801. Interest Calculations
  802. How to sum only Nagative or only postive values in a row ?
  803. Don't know if its possible in Excel
  804. Conditionally formatting just part of a cell contents - how?
  805. I'm not sure where to start
  806. #N/A
  807. Sumproduct function multiple sheets
  808. PRICE function, Pls help
  809. Count the numbers of a particular day
  810. Creating a Drop Down List with Step by Step Instructions for 2007
  811. Multistep formula challenge
  812. Dependent list in data validation - more than 2 columns
  813. Calculating Elapsed Time
  814. SUMIFS or COUNTIFS help !
  815. INDEX error
  816. create button to find today's date in another tab
  817. Extracting Data
  818. Changing Text in a cell
  819. incremental step
  820. Help with SUMPRODUCT Function
  821. Simplifying numerous checkbox procedures into 1 procedure
  822. How do I index the LAST occurrence of a duplicate number in a colu
  823. Worksheet with most rows
  824. VISTA working with OFFICE 2003,2007 both or which?
  825. Formula assistance column match sum
  826. SUMIF partial string criteria
  827. Tracking information sheet
  828. Getting #ref error after row / cell is this a limit in excel 2003 tia sal2
  829. Saving Interactive Excel 2007 as a web page
  830. If Then with Today formula
  831. restricting access using a macro
  832. Conditional formatting
  833. Copy data from the Status Bar
  834. How do I link data in 1 cell on 1 worksheet (WS) to another WS
  835. Proper function for a chart
  836. Sum a column
  837. SUM/COUNTIF across multiple worksheets
  838. How do I remove extra space when text wrapping?
  839. Can Autofill be used for Hyperlinks
  840. NOW and WORKDAY functions
  841. How does on report site bugs for the newsgroup sites to microsoft?
  842. Web Site Problems?
  843. How to sum a column to equal hours and minutes in Excel?
  844. How do I get worksheet to end after last entry
  845. Formulas
  846. Further to my other post....
  847. SUMIF with Multiple Criteria
  848. How do I avoid repeating calculation in IF function?
  849. sum over a date range
  850. SumIf Question
  851. Tab Key reset
  852. Creating a dropdown list
  853. Getting #ref error after row / cell is this a limit in excel 2003 tiasal2
  854. How to extract only file name from folder path string in Excel?
  855. Calculate diff. between 2 times
  856. Helppppppp
  857. function does not calculate remain as =SUM(E9:E10)
  858. Formula shows up as text in cell
  859. IF statement help
  860. automated cut and paste using regex
  861. Counting # of days between 2 dates excluding Fri & Sat)
  862. Using MATCH or ......?
  863. how do I create a formula to view a whole week
  864. how do I create a formula to view a whole week?
  865. Generating dates from a calender week value
  866. Calculate interest rate on long term investment
  867. "counting" number of entries
  868. Select Multiples from a drop down list
  869. Denomination
  870. checking return receipt
  871. number combinations.
  872. delete scripts
  873. How to parse long spaced entry into multiple cells???
  874. Date compared to today
  875. Changing Numerators but not Denominators
  876. SUMIF, MATCH, INDEX Memory Hogs?
  877. Lookup function
  878. timing function for contracts expiration dates showing a color or
  879. In Excel, how do I display a leading zero? e.g. 05 for 5 ?
  880. Escel 2003 Comma Style on Toolbar will not work
  881. how do I validate an entire colume instead of a cell
  882. Text is missing from links in excel workbooks
  883. missing links
  884. - in sumproduct
  885. Can I put a cell reference in a sumproduct formula
  886. pivot table dummy values?
  887. How to eliminate javascript requests from excel spreadsheet cells
  888. zero value cells/blank cells causing error in AVERAGE?
  889. Combining Two Columns of Data
  890. Split Cell using If or other function
  891. VLOOKUP - I think...
  892. Compare data in two worksheets
  893. Compare data in two worksheets
  894. Average across selected worksheets
  895. Auto sort
  896. Product Trends
  897. TOO MANY CHARACTERS!!!! - PIVOT TABLE
  898. Conditional Formatting
  899. XL solver macro
  900. Need help, I need to add words to each row
  901. Extracting cells from worksheet based on value of 2 cells
  902. Complex criteria in advanced filters
  903. Mass Forumla Change
  904. Sharing
  905. Excel Hangs while filtering
  906. Problem if Source field name of pivot table changes
  907. Excel - the sums are not automatically calculating
  908. Motor Query Formula Help
  909. how do I change a range of cells with - totals to positive ?
  910. Lookup between two dates
  911. Excel Calculations
  912. Formulas in excel
  913. Take a range of data and copy to another by matching a unique id
  914. using SUMIF with ISNUMBER
  915. Count words in a date sheet
  916. Cannot expand the selection to entire spreadsheet when sorting
  917. Look up formula
  918. Calculate duration (#yrs., # mos.)
  919. code to prevent users from adding new worksheets
  920. Find and return a value
  921. Pivot Table and Shared Work Book - Excel 2007
  922. Printing Problem
  923. Row Count
  924. multiple if statements
  925. what formula to use?
  926. Validation List - adding new entries
  927. Look up formula
  928. Disappearing comments
  929. Timesheets
  930. Auto-fill
  931. Leading zeroes formula
  932. Too many arguments
  933. Number of days past due
  934. returning blank cell in an if statement
  935. COUNTIF using conditions
  936. #DIVI/0 issue
  937. Counting text entries
  938. MACRO or FORMULA
  939. excel 2003 issue
  940. need help doing a vlookup and average
  941. What is this, #### and what do I do with it?
  942. Excel'de metin içinden kelime alma
  943. Condition Formats for duplicates with additional criteria
  944. countif function: how to distinguish case/make case sensitive
  945. Random sorting with restrictions
  946. Summing using dates that may or may not repeat
  947. Copy Down
  948. Count Cell that contain a word.
  949. Data Validation doesnt work with Copy/Paste
  950. help me :(
  951. refer cell value of another workbbok in formulae
  952. Demerge cells and copy data
  953. Median by groups
  954. Refer cell value as part of formula
  955. Sumif function with two criterias
  956. how can I convert numberic value to text in english?
  957. How to Spell Number in English? I mean write 1 & see One?
  958. vlook up where one column has a range of numbers
  959. can i add a header to my table?
  960. find in reverse
  961. SCREEN NOT UPDATING
  962. Using the results of the ADDRESS formula in another formula
  963. excel 2003
  964. Average Symbol
  965. SUMIF Function ?
  966. sumproduct formula work around
  967. Count frequence in one column
  968. Email message on cell change event
  969. sot data
  970. Sumproduct and Networkdays Together
  971. RE: Sort not saved across saves/reopens
  972. Finding the right function & formula
  973. Vlookup question
  974. Eliminating #DIV/O!
  975. Row 1 Deleted
  976. "IF" function query
  977. Count text within numbers
  978. Protect shared workbook
  979. Resolve Conflict error
  980. Excel Formula to evaluate multiple criteria (countif + and)
  981. Run time error
  982. #DIV/0 Error
  983. How to use RIGHT() in sumproduct
  984. Max to min for dates
  985. Modify search function
  986. ogh, why is this not working
  987. Can a column of numbers be set to mix up in random order
  988. Blank Cells showing as 0 in pivot
  989. Multiple Indexing
  990. Using formulas to count tick boxes or radio buttons
  991. az
  992. Identifying the # of cells containing data
  993. Return multiple values using a lookup function
  994. remove the cells contents (data) without removing formulas Excel 2
  995. Adding and multiplying
  996. Search for duplicate entries in a column of numbers
  997. remove space
  998. Indirect with index and match
  999. vlookup & Extrapolation
  1000. COUNT IF with multiple conditions