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. recording more than 2 changing values in Excel at a time???
  2. Hexidecimal lookup
  3. Automate Excel report to place certain data into existing report?
  4. Re: Date Calculation
  5. lock only one cell
  6. how to enter negative amounts in the unit price column of excel
  7. Protection using the subtotal function
  8. sum column when it meets certain conditions
  9. Linking one cell to another
  10. Drag formula down
  11. Unable to remove objects pasted into Excel from HTML grid
  12. External hyperlink to a specific page in a workbook
  13. Find max value in a row and return column title
  14. vlookup for exchange rate
  15. Drag Formula copies values instead
  16. Function help
  17. Concaenate formula- text diff lines?
  18. Weeks and dates
  19. Sorts
  20. Unable to read file
  21. Adding time
  22. Ignoring Formulas within cells
  23. pulling back dates that meet certain criteria
  24. Display Age
  25. If referencing drop-down list
  26. turn the letters N and Y into numbers just for totals
  27. Looking up multiple values for a single name
  28. Summing periodic sales on a rolling basis
  29. CANNOT GET SECOND CHECKBOOK REGIATER TO DO MATH, wHY?
  30. sort column by colour
  31. excel should allow me Indian number grouping ##,##,##,###.##
  32. Search text within cell
  33. Round one cell depending on value of another
  34. Excel, function, result to be returned in another designated cell
  35. Replacing value in cell with answer of same cell
  36. Average Formula
  37. My excel spread sheets are dividing all numbers input by 100.
  38. help in nested if formulas
  39. how do i...
  40. Excel help
  41. Time difference calculation
  42. Extend Formulas
  43. Using the subtotal function on a prtected sheet
  44. How do I return a value based on multiple possible conditions?
  45. Need Help with Formula
  46. Excel
  47. How to average a column of numbers that are greater than 0?
  48. How do I use line guides
  49. Merge multiple cells
  50. Need Function for Text To Columns
  51. IF Statements using BUT - is there such a thing
  52. What gets XNPV to calculate correctly if initial values are zero?
  53. Help quick
  54. Scheduling task for Excel
  55. Sumproduct function?
  56. Days by month and IF statement.
  57. Lookup? Match? pulling rows from one spreadsheet to match a text f
  58. Hyperlink to a subprocedure in an other workbook
  59. How do I use more than one value in Conditional Formatting?
  60. work days function
  61. How do you remove the numbers from a street address in EXCELL?
  62. I was looking to get assistance with a formula in Excel 2002
  63. How do I create a hyperlink to a cell with the hyperlink function
  64. Cell value - detecting change
  65. Count coloured cells in range
  66. tally a range of dates
  67. Count date in every 4th cell down column
  68. Formatting Remooval
  69. How do I close excell worksheet without closing others still open
  70. Combining AND/OR in an IF statement
  71. pivot table not reading date formats
  72. delete extra space
  73. excel protection
  74. Merging cells in the center of a worksheet
  75. Last Modified
  76. Date Conversion
  77. Count cells that contain "Y" in columnA IF contains"X" in columnB
  78. item limit for a combobox?
  79. Working out interest lost on a loan
  80. Counting Non Blank Cells that Contain Formulas
  81. making copied cells change with change in original cell
  82. Summing based on criteria
  83. function
  84. Sorting to get the latest of a kind
  85. separating names
  86. Multiple lookup function
  87. CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA
  88. RE: Multiple lookup function
  89. Insert Signature
  90. How do I pick up only the rows with a non-null key column on a separate sheet?
  91. copy cell from one workbook to another
  92. how to sum a repeated val only once and meet a certian criteria?
  93. Converting Dates to Weeks
  94. Lookup formula in excel
  95. "formula too long"
  96. How can I evade the limit of 30 arguments in a function?
  97. Validation list that also allows user entry?
  98. Help with Networkdays Calculation
  99. IF(AND(etc., etc. ... problem
  100. How to sort the data entered in different columns (columnwise)
  101. Excel should have 300 columns, for use aluminium smelter industry
  102. Criteria for Countif
  103. convert yards
  104. a formular to remove spaces in a numeric cell (Phone No)
  105. Variable range in MAX-function
  106. Please help... only have 20 mins
  107. Default Tab Stops for Template
  108. Adding Color to a Cell
  109. insert a picture based on a formula
  110. Vertical Lookup from a List
  111. Problem with formulas
  112. Summing HLookup Values
  113. Fiveif statements in a formula
  114. Reference external worksheet whose name is in a cell
  115. Using an Excel VB-made form in cell-specific conditions.
  116. Creating a highlighting formula
  117. Summing Unique data values
  118. combine two macros
  119. What formula!?!?!
  120. how to use work date function
  121. How do I create a random number generator in excel?
  122. Dependent drop-down list??
  123. format cells
  124. How do I get correct results when LOOKUP with calculated numbers
  125. 2 different workbooks into one new book
  126. How do I uniformly change the values (numbers) of many cells? Exce
  127. Conditional Formats - Forumlas
  128. Formula question
  129. Negative numbers in an IF formula
  130. Populate current active cell - Help Please!!
  131. LINKING TOGETHER FOR TOTAL
  132. Simple Game and Puzzle - Very Difficult to Implement
  133. Turn vertical data to horizontal data automaticaly
  134. Filling Cells with one Static Cell
  135. Question on functions various Excel versions support
  136. determining & returning least and greatest dates
  137. array formula: return next date from list
  138. return previous date from list
  139. If then color of cell
  140. Top 5 plus Other in Pivot table
  141. MS Query
  142. conditional format for text
  143. Sumif with multiple criteria
  144. Giving value to a letter
  145. How do I count nonblank cells that meet criteria in another cell?
  146. How do i print roman letters in the foot note
  147. Help please, cell formatting only works after I double click the cell
  148. Concatening a text and a date
  149. convert number to month and year in formula
  150. My Find and Replace function in Excel is not working?
  151. Excel If Statements with more than one Solution
  152. Lookup_Validation
  153. showing multiple results to a formula
  154. roll up a calendar in excel
  155. Round Problems
  156. Excel, how to count every 4th cell in column to see if occupied?
  157. if statement
  158. Combining information from multiple tabs
  159. Average of a row of numbers not counting 0's
  160. Shortening a formula
  161. Sumif with two criterias
  162. Vlookup returns value in the adjacent row
  163. HOW DO I APPLY A FORMULA FOR AND ENTIRE ROW?
  164. How do I use a formula to create a new line of text in a cell?
  165. =if statement
  166. cells
  167. Searching and adding a value.
  168. The Row Height Autofit command does not work.
  169. Cut &paste clears numbers after the decimal point
  170. Complicated work! Any idea??
  171. Real time in worksheet
  172. Using "*xxx*" in an array formula
  173. How do I calculate the mode of a column of IP addresses?
  174. How to count the number of Excel cells with text formatted Italic
  175. Cannot autosum after import
  176. Copying a linked worksheet
  177. About Data Table & Scenario Manager.
  178. The picture is too large and will be truncated
  179. Automatically insert a date value based on the value from another cell
  180. Lookup with multiple criteria... please help!
  181. sumproduct of columns
  182. This is kinda urgent. Need help with matrix stuff.
  183. How do I copy and paste a formula I create to subtotals only?
  184. IF Function and msgbox
  185. items disappearing from pivot dropdown when not selected
  186. =LOOKUP(MONTH)
  187. Cell protection
  188. Conditional Formatting
  189. Simple If formula but can't get my head around it!
  190. match in excel
  191. Need Formula HELP
  192. How do I link 4 columns to each other
  193. 3 logical condition if statement
  194. Finding current week and if any item has somthing due
  195. Creating a complicated formula
  196. SUMIF - counting across different spreadsheets
  197. enter item code in one column, automatically get description in ne
  198. Double Clicking on link w/i workbook does't bring me to souce.
  199. Stamp Duty
  200. Simple AND formula
  201. dynamic summary table
  202. LOOKUP 2 DIFFERENT VALUES AT ONE TIME AND RETURN A VALUE
  203. PIVOT LEARNER - Field Entry
  204. Comparing and sum'ing data
  205. how do I automatically jump to the present date in a roster?
  206. Column of Text Shown = Total Times Shown?
  207. How I can set all cell in the worksheet rounddown automatically?
  208. [Pivot Table] Add Value
  209. Copy worksheet to another worksheet and the date is plus 1 day.
  210. Refering to Cells
  211. Formula
  212. nper function calculation
  213. Counting Values
  214. Formula Assistance Please
  215. Selecting Multiple Results
  216. Currency vs. Accounting Format
  217. Can I set up where Employee types name and computer records time?
  218. Needing Help Very Bad
  219. how do I find the last value of a range....
  220. Complex Date Formula
  221. Why does a simple frequency distribution count out of range data?
  222. Linking dates to different workbook, then data.
  223. Adding Worksheet
  224. Holiday Planner show holiday taken?
  225. Unable to get examples to work for lookup etc
  226. highlighting problem in excel
  227. HELP: can no longer open protected file in XP
  228. Split a Cell?
  229. NOW() and SECOND() not refreshing
  230. Workbook Create Date fx
  231. How do I round off times in Excel?
  232. Moving Data
  233. Convert HTML to number
  234. Formula Assistance Please
  235. Workday calculation - not working
  236. Relative references for condtional formatting within a Pivot Table
  237. Simplify changing directories
  238. A formula for monthly tracking?
  239. SUMIF ??
  240. help with formula
  241. How do I calculate times each word occurs in a column of cells?
  242. How do I setup a formula to insert the rate?
  243. Conditional Validation
  244. Extremely Vlookup, help me pls, ths much
  245. How do I permanently remove Template Help?
  246. How to create data tables and is there a payback period function
  247. work with multiple workbooks on separate monitor for 2003 edition
  248. Duplicate Value warning
  249. Performance IF(IF or IF(AND
  250. Keyboard shortcut or selecting entire column
  251. calculating
  252. Restricted value sequences in rows
  253. ISERROR
  254. HELP WITH FORMULAS
  255. Forecast and Trends
  256. CountIf Function
  257. view 2 different worksheets within the Wrkbk
  258. If functions and dates
  259. Run when exit
  260. Extracting tab names
  261. Using cell value in filenames
  262. Display multiple tabs in current worksheet
  263. repeating a formula
  264. Sorting on columns
  265. how can I group information from more than one worksheet
  266. A goto function for Mobile Excel
  267. If formula - got myself confused!
  268. Excel should have a function for last date and time file was saved
  269. Probably a vlookup type ? not sure
  270. How to copy a row with transposing to a column retaining links to input cells?
  271. pivot table formatting
  272. format pivot table
  273. Help with Formula
  274. Help with Formula
  275. Compare two cells and return certain value in third cell
  276. How can we convert number in to english text?
  277. Help with function involving if then else?
  278. similar text matches vlookup
  279. Sorting by columns
  280. SUMIF/SUMPRODUCT Between Dates
  281. Remove Specific Text - HELP!
  282. =IF(B44>14*B44<24*D44>44*D44<88*F44>999*F44<1276," $75.00",IF(B44>1
  283. =IF(B43>14*B43<87,"$50.00","$0.00")
  284. =IF(D43>=45*D43<=87,"5.00","0.00")
  285. Re: Excel performance calculation
  286. Extract Date from Right Formula
  287. Elapsed Time over 24 hours
  288. Iteration problem (Excel 2002)
  289. Count Formula
  290. Converting hours:minutes:seconds to just minutes
  291. How do I change the font size of a pull down menu in MS Excel
  292. How do I get a value returned when I require 2 criteria to be met
  293. Countif with nested function not working?
  294. Comment Indicators
  295. How do I get a cell to give a result based on the month we are in?
  296. publishing worksheet to the web
  297. What's the easiest way
  298. sum the values of a range based upon multiple ranges and criteria
  299. Subtract time between certain days/work hours?
  300. Very large complex workbook is now giving me the wrong results :(
  301. select multiple items from a dropdown list
  302. To leave a blank cell
  303. irr
  304. How do I link password protected files to a master spreadsheet?
  305. Length of Service
  306. Convert time format to a decimal
  307. Lookup mulitple tabs
  308. The mark is bugging me! LOL
  309. How Do I format Background pictures?
  310. Concatenation
  311. There has to be a formula for this....
  312. There has to be a formula for this....
  313. Help with Formula
  314. Function - Counting Years in range
  315. interogating a worksheet
  316. Time Calculations
  317. using SUMPRODUCT
  318. Return array from worksheet function
  319. How to write a count-if-not function?
  320. how do I count the occurrences of multiple conditions
  321. Inquire
  322. Inquire
  323. Gradesheet formula needed
  324. Converting positive numbers to negative numbers
  325. Data referencing and auto fill across worksheets in one workbook..
  326. About loking cells..
  327. Data Verification Problem
  328. calculate time
  329. calender for spreadsheet
  330. List items in column
  331. What is the function to calculate standard errors of the mean?
  332. How to separate id and name from column
  333. Trimming Data
  334. formula CENTILE
  335. need help in the code
  336. Countif
  337. Using Excel for mail merge
  338. what does IF(D3="," mean please
  339. INDEX AND MATCH QUERY ?
  340. Want a muslim match?Want a muslim brother/sister?why not join our site and start your searching?
  341. Function to give value of a BLANK cell based on another
  342. analysis of data entered on excel questionnaire format
  343. Help needed
  344. multiple function in formula
  345. Excel Functions
  346. Regarding updating 1000 values using vlookup from another worksheet
  347. Array Formula with AND operator
  348. Add 4-bit Binary-Coded-Decimal function to Excel
  349. vlookup
  350. Changing number format
  351. How to hide Sheet tab Bar & status Bar for a excel file
  352. subtotal(9,....
  353. what formula converting number to text in english or hindi in exl
  354. Pls add browse button for Hyperlink function
  355. Using Countif on multiple columns
  356. Convert cell contents to range
  357. Convert from number to word in excel
  358. Comma
  359. how to return multiple results in vlookup?
  360. access query to import to excel
  361. access database (adodb)from excel vba
  362. Using AVERAGE with conditions in different worksheets?
  363. I need a document to calculate an ongoing balance.
  364. Fill in form to type Item descrictions and costs and fill in funct
  365. Can I run setup Office 2003 for office 2000 installed?
  366. Sort text list by character length - how?
  367. linking worksheets
  368. How do I get a cell to update itself based on the month we are in?
  369. A function to return the value of a blank cell
  370. linking a formula with different worksheet
  371. If Function
  372. Printing multiple worksheet areas in a single page
  373. How do I total a series of checked boxes?
  374. How do I add all values in a given row (not colum)?
  375. Subtotal
  376. Question about Word export to excel?
  377. formula - excell
  378. listing unmatched items!
  379. How do I add a duration time value and a clock time value?
  380. help is require with this
  381. Formula not working for me now
  382. I can't find why my formula is inconsistant - please help
  383. =COUNTIF(D4:D29,">0")
  384. KEEP CELL VALUE UNLESS IT IS -0.15 THEN ENTER 0.00
  385. I have to change a bunch of formula that need to reference a different workbook.
  386. Comparing specific date and hour with NOW()
  387. Date 13 Weeks from now
  388. =COUNTIF(D4:D29,">0")
  389. averaging 32 fields
  390. Sumproduct & Indirect Functions
  391. how can i average more than 30 fields?
  392. link excel data to word document template
  393. countif both conditions in a row of 2 cells exists
  394. Returning Numeric Results across a Single Row in Consecutive Cells
  395. how can i put a web page in a worksheet?
  396. sumproduct formula
  397. Working with sheets in Excel 2003
  398. Joining Worksheets
  399. how do I move data in prexisting rows to columns?
  400. multiple criterion to give sum
  401. Dynamically Generated Range using Macro
  402. How do I save a single spreadsheet in a workbook in excel
  403. Using a listbox to show every unique record in a range
  404. Unhide multiple work sheets at once
  405. Staffer at work with problem...
  406. How do I put a company logo in the background of an Excel document
  407. Conditional Excel formula
  408. holding the result constant
  409. Vlookup
  410. Multiple IFs
  411. converting vertical data list to horizontal data list
  412. consolidation link template?
  413. How Do I Write over Pictures?
  414. NUMBER OF ROWS IN A DYNAMIC RANGE
  415. Reference to cells using autofilter problem
  416. formula
  417. An oddity if not a bug
  418. highlight largest number in a row
  419. Number of IF statements exceeded...
  420. Conditional Formating
  421. How do I remove a comment, note, or ?
  422. Why does Excel return a : when I insert a .
  423. Cell input into formula
  424. How do I avoid referencing hidden values in formulas like OFFSET?
  425. Date arithmetic: adding 1 month to prior end of month date
  426. I need help with a formula values
  427. How do I create a formula using cells from multiple worksheets?
  428. List with auto filters
  429. Excell, print the tiles on all pages
  430. Format different worksheets automatically
  431. Inserting blank entries for missing values
  432. Overtime Calculation???
  433. Atpvbaen.xls
  434. PivotTable Question
  435. Countif statement doesn't work on some rows
  436. Consolidate information / Summing
  437. insert page break when there is a change in the row value
  438. Indicate the location file on the work sheet
  439. "IF AND" statement
  440. Extracting a number in a text string
  441. How can I edit the year in a date field in Excel?
  442. Count the number of rows where more than one column meets set crit
  443. CONCATENATE
  444. Find date query and Display issue
  445. data reentry for ferification
  446. Extracting data from a cell
  447. web query+vba
  448. User defined function detects font colour
  449. How do I get my Validation Lists to keep their formatting?
  450. Confused on what to use ????? vlookup with different criteria
  451. =offset ???
  452. hiding blank cells when no results
  453. Copy content of cell to another depending on value of third cell(between worksheets)
  454. Macro to make a cum list
  455. sorting in excel
  456. PING within Excel Cell
  457. INDIRECT.EXT
  458. calculating age
  459. How to Extend Range Automatically
  460. Macro to lookup duplicates
  461. Sort multiple columns with multiple formulas without returning #R
  462. Why can I open only the last pdf file hyperlink created?
  463. inputBox calculations and msgbox or "outputBox"
  464. functions
  465. creating functions
  466. Linking to other sheets (depending of a cell)
  467. IF & OR functions
  468. Autocorrect Question?
  469. If Function. How to Add more criteria
  470. Automatically add date into a cell
  471. SumIf
  472. Position Cursor to same address on another tab
  473. how do i get only the decimal value in excel
  474. Conditional Problem Solving
  475. fixing column width
  476. use of wildcards
  477. Need formula to count spinoffs
  478. Change Shape Text
  479. extract number and use in formula from text & numbers in cell
  480. Search Multiple columns for criterion asterisk (*) and Return Numeric Label
  481. Is there a way to have two different sheets work in one document?
  482. How to Evaluate Dynamic DDE Formulas
  483. countif statement
  484. Navigating between worksheets using a drop down menu
  485. How to identify text from a autofiltered list using formulas
  486. need advice on 0, "" , " "
  487. How do I use a pivot table to present data, not sum or count it.
  488. how do I show a value = a value in a range (A1 = any(b1:b35)?
  489. Automatically printing psted text over 250 characters to another cell
  490. I am trying to calulate total time
  491. Can I compile data in sequentially numbered worksheets easier?
  492. Dependant Lists in Excel
  493. HELP! Can't see my form in form view!!
  494. can I format a workbook so that every sheet has the same footer
  495. Concatenating and transposing a row of numbers
  496. Formula result not displaying in cell
  497. Create Dropdown menu without using the Validation on the Data Menu
  498. from a cell which has numbers how to get it spelled
  499. Help with Conditional Formating Time
  500. Using a PasteSpecial within a Destination:= line
  501. Run Macro on Mouse Click
  502. calculating a 2-log drop
  503. Sorting rows
  504. Can I change my default settings to never show gridlines ?
  505. Hyperlink - Passing a cell reference
  506. Cells only display formula
  507. Can an Excel cell value be used in a Custom Footer?
  508. Why can't Conditional Formatting do other formating such as number
  509. Can you use INDIRECT in 3-D references?
  510. worksheets
  511. macro takes 30+ seconds to do an autofit on only 1 of 3 sheets it is autofitting
  512. How Do I add/sum the numbers in one cell...((More Info Below))
  513. How to Copy a Cell from one worksheet and return
  514. Stumped....Matching Columns
  515. Sorting in Shared Workbook
  516. how do I open a publisher file in front page
  517. formulas/function require (2)
  518. Calculating cells with text only
  519. Here's a good one!
  520. Macro to capture worksheet names
  521. help making formulation
  522. index/match/replace
  523. =NETWORKDAYS not working as expected and as it once did
  524. cells visable and following. Not freeze
  525. Excel formula Q
  526. Stumped with an IF function
  527. Help With Formulas
  528. formula to remind me of an appointment 3 months in the future
  529. Help..... with formula
  530. DATEDIF
  531. IF in combination with larger than
  532. list of sheets
  533. How do I do a vlookup that links to file paths within a cell ref
  534. how to expand the autofilter range 1000 to 10000?
  535. Need help with dividing and using ISERROR for Div/0!
  536. Sumif with two conditions?
  537. Repeat last action
  538. Using the lookup Function for similar items to add together
  539. Need to find a formula
  540. Conditional Average Array with Dates, <blanks>, 0
  541. How do I embed a two page word document in excel
  542. Conditional Average across worksheets
  543. Using IF in an array
  544. "IF" function with multiple truths
  545. PMT question
  546. matching values that are not in order with conditional formatting
  547. how to start using vlookup, match & index formulas, examples
  548. Hyperlinking problems
  549. Set solver constraints so variables are either 1 OR 0.
  550. Auto Numbering System
  551. How do you create a list & data validation in same cell?
  552. WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
  553. I can't change colors in certain Excel cells
  554. Why are formulas not updating when changing a value in the range?
  555. How do I keep the font color with VLOOKUP?
  556. get a single count after looking up a set of values
  557. How can I find comon values in seperate spreadsheets?
  558. Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA?
  559. Complex Nesting
  560. How to track inventory?
  561. How do I make excel not prompt before deleting worksheets?
  562. Please tell me this is possible
  563. Delete Macro
  564. How can I find duplicates in one column of an exel spreadsheet?
  565. formula help
  566. How can I covert dates to ccyymmdd?
  567. Average Time Difference
  568. Formula non specific lookup
  569. How do I write a comlicated conditional statement?
  570. Average calcs - ignore sheets
  571. How do I set up a transport cost with mulit origins, destin,svcs
  572. How do I get ONLY new info from 1 Worksheet to another automatical
  573. separating text
  574. How do you copy a border down the page?
  575. how can I compare two excel spreadsheets?
  576. add leading zeros
  577. Converting US Dates to UK Formats
  578. How do I retrieve & view multiple matches from another workbook?
  579. Formula/Macro to delete rows that do not meet criteria from a list?
  580. no password for protected sheet
  581. Horizontal arrow on cell edge and double-click, no matches found.
  582. date problem in excel
  583. How do I highlight a column depending on other column value?
  584. Count, Countif, Sumif??
  585. If statement
  586. How to format cells to show dates as the week-ending date of that
  587. Extracting Data for a Formula from a List
  588. Import External Data -- Fill down formulas Issue
  589. Simplification help
  590. Time * Rate = Amount Billed Formula?
  591. Excel
  592. Sorting Data From One Column into Multiple Columns
  593. auto updating list
  594. Tabs v.Pages
  595. calculating a date using the day of the week as a starting point?
  596. Converting data in one cell to 3 different cells
  597. Date Last Modified
  598. Forcing DIV/0 to display "0"
  599. Cell structure not copying to 3rd party app
  600. how to hide a list of macros without password protection
  601. How do I setup multiple lists
  602. Reverse worksheet data by columns
  603. Add worksheet Lookup based on date
  604. average formula ingoring empty cells
  605. set filename to <filename-date> on open
  606. How to create a fill down that increments based on the workbook name
  607. If statement to compare for wildcard value in another cell.
  608. noamal curve and cumulative distribution graph
  609. Incremental Numbering
  610. Simple Question but need urgent help pls...
  611. Formula to search for given term, and if not found in column to add it to list
  612. get a count from multiple lookups
  613. Please help me... with Case Structure
  614. How do I extract a single value from the linest array result?
  615. Formula problem with different sheets
  616. I want to turn off Text Import Wizard
  617. COUNTIF - Multiple Criteria
  618. remove a drop-down list in excel
  619. Need to create a error message box
  620. How to "auto fit"
  621. Referencing a column across worksheets
  622. Can I add a drop-down list to a Vlookup?
  623. Can I add a drop-down list to a Vlookup?
  624. Copy, return and paste.
  625. Solver Question
  626. how do I skip blank cells when writing formulas
  627. how i recover my excel file
  628. combining fields on a pivot table
  629. Retrieve Data from one sheet to another
  630. hidden columns
  631. How do I find best fit out of a set of options by ranking criteri
  632. Hidden worksheet
  633. Is it possible to format a cell w/ 2 font sizes by formula?
  634. SUMIF across multiple worksheets workaround help
  635. Why can't I see the Protection tab on cell format dialogue box?
  636. Using linest for flow rate calculation
  637. Return info based on Date Range
  638. Custom Filter
  639. how do you do an average for percent without putting in the perce.
  640. Transpose row to read to column
  641. 2007 insert button/icon
  642. funtions for colors for fonts or cell backgrounds?
  643. Excel Sheets
  644. LARGE with text string
  645. Can anyone figure a formula for this?? Please?
  646. Look up date on another sheet and do count of active cells (column
  647. not sure which function to use for this summary
  648. How to autofill a column if criteria is met for Excel 2003
  649. Question on some homework I have to do
  650. Compare times : IF time < time2 then
  651. Countif with a changing range
  652. How do I resort names
  653. Add reference to DDE Link formula
  654. Converting Dates
  655. I wish to separate city, state, and zip into 3 separate columns
  656. How do I sort Library of Congress call numbers in Excel?
  657. Linking a Specific Word to a Specific Number
  658. oldest incomplete job
  659. Linking a Specific Word to a Specific Number
  660. Linking a Specific Word to a Specific Number
  661. how can I insert rows in part of worksheet
  662. Setting Dates
  663. Adding up multiple cells
  664. Copy cells to neighbor column after leaving the cell
  665. Re: Last Day Of Month Calculation...
  666. Nested IF
  667. cond formatting ?
  668. Tracking Time
  669. Counting cells with text
  670. EXCEL SPREADSHEET FORMAULS
  671. How do I shade the active cell in excel
  672. hyperlinks
  673. Why is a row's total rounding up?
  674. Leauge Table....Help!!!
  675. value from cell x according to cell Y
  676. Formula Query - Using Time & Text
  677. While using networkdays function, how can define weekly off days
  678. Excel question
  679. sound or speech the value of the cell if value > 10
  680. VLOOKUP question
  681. Logic Test ?
  682. Plus or Minus
  683. referencing todays date.
  684. Value within a range
  685. feasibility study
  686. How to count the number of 'values' in a cell
  687. Distinct
  688. Complex Formula
  689. count number occurring within specific date range
  690. select date range in column
  691. Concatenate Nightmare!
  692. Different Number of Workbooks each week
  693. change position of filter button
  694. Workday Function in Excel 2007
  695. More sort options - do they exist?
  696. lookup and add a value
  697. couldn't find "solver" in Excel 2007
  698. simple formula
  699. row= cell's row
  700. Need help with linking a file to a picture.
  701. How do I reformat my database from all uppercase to proper?
  702. Floating Cells
  703. "Excel Could Not Save All the Data and Formatting"
  704. sending macros
  705. Excel Formula Help!
  706. format to a desired style and order
  707. This is more complicated than it looks.
  708. Values in spreadsheets do not update
  709. SUMPRODUCT with AND's and OR's?
  710. How do I set up a needs assessment result template in Excel?
  711. Can I sort worksheets based on the tab name?
  712. compare 2 books in excel??
  713. Need Help w/ Index and Match Formula
  714. Formula in Excel to show greater than 50, but less than 250?
  715. Advanced use of LARGE function
  716. Excel is totaling wrong
  717. Can you do inverse trigenometry on excel - i.e Tan-1
  718. Graphing a dynamic range that automatically picks up the most recent entry.
  719. Always on top? Alway the same size?
  720. How to: COUNTIF when ISTEXT is True?
  721. How do I create a list inside a single cell?
  722. SUMPRODUCTS
  723. how do i change formulas in a wookbook to the results
  724. Summation Operator
  725. What does -- do?
  726. VLookup Formula
  727. formula question
  728. How do I Minus 10% discount On my Excel Invoices On the Sub Total
  729. COUNTBLANK function
  730. Sum Column Entries that fall within Date Range Listed In Rows
  731. users on shared worksheet
  732. Count number of textual values in a row
  733. requiring a field
  734. Row() function returns wrong row and more..
  735. Excel FUNCTIONS stop working
  736. Sorting SumIF
  737. Separate a String of #'s
  738. formula to extract text out of a paragraph
  739. How to calculate return from uneven cash inputs over time?
  740. How do I reinstall the autosum button? I cannot find it on Excel
  741. multiple selections from drop down list
  742. change text case
  743. SUMPRODUCT and OR operator
  744. adding conditional rows
  745. Excel limit that stops pivot table processing at column IV??
  746. why does Excel add more rows than I have selected
  747. Help with a SUM function...
  748. different column size in a table
  749. stuck on option buttons
  750. Placing a Variable Properly
  751. How to Activate Vlookup Function?
  752. How can I round in quarter points?
  753. V-Lookup
  754. lookup formulas to obtain multiple results
  755. Sum based on two conditions
  756. percentages
  757. V-LOOKUP
  758. link a range of cells
  759. How do I use functions and calculations?
  760. flagging unmatched items!!!
  761. How to make worksheet always open in same place?
  762. conditional formatting
  763. Double Entry table
  764. I would like to convert digits (eg. 16) to text SIXTEEN in Excel
  765. Occurance Counting
  766. How do I set NETWORKDAYS to regard friday and saturday as weekend
  767. Format of Cell an Issue
  768. evaluate two cells and calculate based on criteria
  769. use a function to look up a result in a spreadsheet
  770. Sum of individual digits (just for fun)
  771. EXCEL CELL PROTECTION
  772. Divide x/y should give Ratio x:y,How to express ratio in excel
  773. Vlookup HELP
  774. How can I script formula?
  775. If Cell Contains Put in another Cell
  776. simple formula not working
  777. *HELP* time formulas
  778. Excel - how do I use drop down list to filter data
  779. Repeated data into flat file format
  780. How do I find the 12 highest numbers in a row of 52 numbers
  781. choosing off various lists
  782. CELL Function and Worksheet Name in a Cell
  783. Three Variables
  784. how can i get EXcel to add up letters in a specific color?
  785. How do I compare two dBs(spreadsheets) based on multiple criteria?
  786. recording a data entry date
  787. RE Excel: Once a list is created, how do you delete it if needed?
  788. return payoff after "X" amount of payments
  789. Lookup functions
  790. Adding numbers in rows results in zero. help!
  791. search column of text cellto identify those cells with specific w
  792. How do I convert values in figures to words in EXCEL 2000?
  793. Seting the minimum value in a cell
  794. VLOOKUP formulas
  795. Combin
  796. create report in worksheet
  797. create report in excel sheet
  798. =SUMIF Problem
  799. Lookup Function
  800. how do i put a formula in a macro to run a program
  801. Can I flag numbers that are higher/lower than a range of #'s
  802. how do I copy a worksheet with formulas to another workbook?
  803. Using MATCH with dates
  804. Help with military problem...
  805. Getting column number from HLOOKUP?
  806. Excel cell alignment
  807. Using text for the range in AVERAGE function
  808. I need a formula can you help?
  809. Difference between 2 dates, incl weekends, with variable work days
  810. Please Help!
  811. Macro help.
  812. Depreciation Formula
  813. Calendar control on cell enter?
  814. Having a formula provide a running total from multiple worksheets
  815. solved problem
  816. Diff two excel spreadsheets
  817. Formatting Cell
  818. How can I count the # of times the word "Yes" appears in a range
  819. excel numbers in general format i cant add cant change format
  820. conditional calculations
  821. Search /Filter vertical Numeric pattern (down single column)
  822. create a timesheet that calculates hours per person per day and to
  823. Collecting data from worksheets.
  824. Error when insering a "Right" function
  825. Relative addressing
  826. Unable to Evaluate Formula
  827. If formula
  828. Why does Excel say this formula contains an error?
  829. Can you create form in Excel & text wraps across several columns?
  830. Joining/Linking nested formulas
  831. Calculate the difference between two cell entries using NOW() func
  832. newbie question
  833. Using Hide, Unhide, and auto filter - select all on a protected sh
  834. Can anyone see a problem with this?
  835. Correlation formula/function question.
  836. How do I display all conditional formatting in Excel?
  837. If(If statement?
  838. excel 2003 wont sort when shared
  839. How do I link filter results into another sheet?
  840. Formulas in Excel
  841. How can I use the & symbol as text in the header of spreadsheet?
  842. Vlookup from 2 columns
  843. vlookup, add parameter, on error return user defined value
  844. Pivot Tables - Missing Data after refresh
  845. combine 2 cells but keep formating of each individual cell
  846. Perhaps VBA?
  847. Problems saving a worksheet with links to a New Location
  848. Excel - Hyperlink, the link gets Corrupted
  849. Excel in a Browser and Security
  850. Best way to populate worksheet from 2 combo boxes
  851. formula for populaing other cells
  852. text continuing in next row in a merge cell
  853. adding value only if criteria is true
  854. textbox font size
  855. Add up worksheets
  856. Using a lookup to return multiple values in one cell??
  857. Multple criteria dilemma
  858. Copy from worksheet to worksheet help
  859. Importing diagram from Excel to Word
  860. Number of years/months/days between 2 dates
  861. copy active cell value,find the pasted value in different worksheet
  862. How do I insert new work sheets in numerical sequence?
  863. Avg Times in MOD fx using selected rows
  864. Convert arial text field to barcode
  865. How do I look up one worksheet and insert in another?
  866. Calculating dynamic moving averages
  867. Sheets Tabs moved to Right Side of Page. How to get back to Left ?
  868. find hidden data in worksheet
  869. SubMenu .action argument
  870. find hidden data in worksheet
  871. Excel Change sign of displayed # to - #
  872. Large Spreadsheet - Freeze On Recalculate
  873. How do I make excel pivot table count blank cells?
  874. Create a message upon opening of Spreadsheet
  875. Excel: ADDRESS cannot be used in CELL. How stupid is this?
  876. Secant function
  877. Print Preview icon behaves like Print
  878. If statement hwelp
  879. Fix Break Link Dialogue Box
  880. keystroke to go to first worksheet cell from anywhere in notebook
  881. if "x" days is more fall on weekend return following monday
  882. named range row offset
  883. Page Setup protection
  884. Please Help A Newbie - running balance
  885. Find & Replace a link to another worksheet in the same workbook
  886. Is there a version of MSN Money Stock Quotes for Office 2007
  887. Pretty easy If loop - help!!
  888. How can i have a drop-down menue in a cell of an Excel preadsheet
  889. Conditional Sum
  890. IF THEN function help needed!!
  891. Date to Days of the year
  892. More math than excel, but a fun problem
  893. Header and Footer
  894. function to change metric measurements
  895. Advanced function to remove specific rows
  896. Display ranked data in order from a range
  897. how do i copy down x number of times
  898. Counting unique values
  899. Can't highlight a single cell. Creates a range when I move curso
  900. Sumproduct
  901. Chart with dual Y axis data
  902. Complicated Lookup Function
  903. Index/match question.
  904. Calculating dates
  905. "Average" questions
  906. Solver Binary Contraints problem
  907. How can I change the data in columns into headers?
  908. Can I use more than two conditions in custom autofilter?
  909. 2 copies of my spreadhseet open!
  910. How can I use conditional formatting to hide or delete rows?
  911. formula bar deception
  912. Formula to convert resulting #N/A to 0
  913. IRR (or MIRR?)
  914. Complicated query
  915. Copying parts from a series of worksheets to a master
  916. Carriage returns in the formula bar?
  917. Moving data based on date ranges
  918. Convert rows to columns
  919. interpolate
  920. How to extract email address and place into a new column
  921. How do i use a cell contents to reference to a name in excel?
  922. Advice re: long path names in formulas....
  923. Assigning Points in a Weighted Scale (HELP!)
  924. Developing macro event to allow multiple choices on drop down menu
  925. Automatically updating cells in a different tab? Possible?
  926. Re: Automatically updating cells in a different tab? Possible?
  927. IF-THEN Formula help needed
  928. Running Macros
  929. Automate MTD summation
  930. Using variables in a cell/formula
  931. Formulas
  932. Difficult Average Calculation <HELP>
  933. Its always the simple ones....Basic Circular Reference Problem.
  934. generate bates numbers on labels
  935. Excel automatically inserts a formula in my sheet
  936. Need help in rounding answers to nearest multiple
  937. if in conditional formatting
  938. Excel vba to call Access Macro
  939. Total on a different page
  940. Insert new date once.
  941. Separate First Name MI and Last Name into three Cells
  942. Reference a cell containing a Reference
  943. how do i run an autoexecute macro in excel
  944. How do i set up date in excel mobile in this format dd/mm/yyyy?
  945. Adding # of days to a date
  946. How do I calculate CAGR other than using XIRR function?
  947. fill down multiple cells in the same column
  948. FUNCTION GETPIVOTDATA MICROSOFT EXCEL 2003 VS EXCEL 2004 FOR MAC
  949. Putting sums on your spreadsheet
  950. Using IF function for many many cells, and using more than one IF function
  951. FUNCTION GETPIVOTDATA EXCEL 2003 v EXCEL 2004 FOR MAC
  952. Sheet name/number
  953. Use cell value as reference to sheet in formula?
  954. IRR and NPV
  955. How to find valuse in cells.
  956. Insert formula automatically with new entry
  957. Timesheet
  958. Generating points from 2 tables (IF funtion limited)
  959. Digits spell it out in english using smart tag
  960. Combining COUNTIF and AND functions
  961. create date
  962. I want to add 6 months to a certain date in a formula (Excel)
  963. Disable automatic GETPIVOT
  964. How do I keep a running 'Top five' in Excel?
  965. IF function which returns the text from a cell
  966. Compare two worksheets for missing information
  967. leave the decimal fraction
  968. Help! Reports
  969. Compare Old & New Product List (i.e. VLOOKUP)
  970. How do I find all items with the same value without using filters
  971. 1,4,1,3,3,1,2=>1,4,3,2
  972. Matching and Aligning Cells Formula/Function? Macro?
  973. FInding Duplacates & correcting addresses automatically
  974. perform a calculation when a certain phrase appears in a cell
  975. Multiple Conditional @IF Statement Method
  976. Formula to return under-budget store locations
  977. change minutes to hours and minutes
  978. Lookup in Multiple Columns, Return Multiple Values
  979. ?IF function for preventing a cell being filled by formula
  980. Simplifying my previous Request for Assistance
  981. Calculate a 30-day moving average based on the last x number of entries and date
  982. Calculation of a number in a range
  983. Return Row Number of LAST Numeric Consecutive Duplicate in Column
  984. Database function criteria
  985. Protect IF statement AND allow data entry
  986. Protect IF statement AND allow data entry
  987. Can a user select more than one entry in a drop down list?
  988. repeating months
  989. Hide rows that meet certain criteria in an excel template
  990. Time Totals in a Workbook
  991. Show the last # in a column
  992. NEED HELP in Writing a FORMULA in colum D
  993. how do i truncate text-- create cell with only 125 charecters
  994. SumProduct for multiple WORKBOOKS
  995. Get the formula
  996. Advanced Question (that I really can't describe!)
  997. Give RELEVANT responses to questions. DO NOT give usless list
  998. macro
  999. In need of a formula
  1000. if function