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 enter two values in one cell
  2. Formula results.
  3. Duplicate values
  4. Countif < than var1 and > var2
  5. Is there a keyboard shortcut to center data in a cell?
  6. Text data being converted to Scientic Notation
  7. INCREASING SPACE FOR CUSTOMISE HEADER
  8. How do I concatenate text that actually contains quotation marks?
  9. Check column of dates against todays date
  10. Formula is displayed, not result
  11. Calculating totals in a column based on a lookup in another column
  12. assignment problem
  13. NETWORKDAYS function problem
  14. Syntax for Conditional Formats
  15. New to VLookUps.... please advise...
  16. Bug in .FormatConditions.Add Type:=xlExpression, Formula1:=cfExpression
  17. Excel Calculation is Incorrect
  18. find automatic page breaks
  19. How do I copy only the month from a date
  20. Automate Subtotals Insertion?
  21. macro to change numbers to names
  22. conditional formulas
  23. SumProduct/CountIf dilemna + Date Range
  24. conditional formulas
  25. validation formulas
  26. Latest date from multiple list
  27. Condtional formatting
  28. coun if
  29. Consolidate data from several workbooks
  30. Consolidate data from several workbooks
  31. Excel changes my text
  32. conditional formula
  33. HOW DO I EXCLUDED A FIGURE FROM A CONDITIONAL FORMAT????
  34. Remove the year from a date
  35. Auto-Enter Value Based on Table (EXCEL 2002)
  36. Want a number of cells to be auto completed based on entry in one.
  37. Table Lookup
  38. formula help
  39. Is there a way to compare data on 2 different workbooks to find m.
  40. shared workbook slows my computer!
  41. countif
  42. sum if
  43. can I move data from workbook A to B using a conditional formula
  44. incrementing column symbols orthogonally?
  45. Formula Works Only Sometimes???
  46. i need a function to find the highest value in a list
  47. Creating Menu to open workbook
  48. How can I print a specified page from several worksheets in Exce.
  49. Macros, Protected Books & Missing Passwords
  50. days in a year
  51. Miss-wrote previous "IF" problem
  52. Convert text to column
  53. Pivot Table Calculated Field- Help
  54. how do i get a TRUE value in a formula to change the color of the.
  55. How do you get to the last data entry in a spreadsheet using shor.
  56. How can I convert binary numbers to decimal when they are larger .
  57. using formula to compare two text lists that are not alike and ma.
  58. Sumproduct w/date criteria not working
  59. hyperlink
  60. Provide rounding tool that sums correctly
  61. How do I convert laptimes (mm:sec.ms) into seconds?
  62. How do I write a VBA code in excel that will compare two columns .
  63. How do you list the numbers in a 3d reference in excel?
  64. Pivot table error
  65. Problem defining Freese Panes setting
  66. How do I get all the options in the Format tab? I only get font op
  67. Using a SQL like query to query an excel sheet
  68. Header & Footer
  69. HELP: Data > Validation ---List ----Formula
  70. CHANGING NUMERIC FIGURES TO WORDS
  71. plot 10 data pts in least square fit to find slope and intercept
  72. New to VLookUps.... please advise
  73. COUNTIF < DATE with other data in column
  74. COUNTIF < DATE with other data in column
  75. Cleansing for CRM uploads
  76. pivot table
  77. Compare Information
  78. Import accounts data from AS400 system, how do I change 10- to (1.
  79. How do I count cells in a column of dates between date ranges?
  80. To get customer list
  81. Reference in a filename..
  82. Any formula to shorten sentence to a specific length
  83. New problem with new "IF"
  84. VLOOKUP Function using Data Ranges.
  85. DATES and AVERAGES
  86. Timesheet function in Excel
  87. Exporting delimited files
  88. Count how many different text values in an array.
  89. problem with this "IF"
  90. display values of formulas in Excel
  91. The formula to find the smallest number in a row not equal to zero
  92. Figure Payroll...
  93. Figure time multiplied by currency
  94. WeekNUM Function
  95. fixed decimals
  96. how does one convert text to a formula "average(A:A)" to =average(
  97. Summary Tally of Multiple Sheets
  98. Function to list values of last 3 non-blank cells in a vertical bl
  99. Not Calculating?
  100. adding values across worksheets in a spreadsheet
  101. Product Numbers
  102. SUMIF accross multiple columns
  103. How do I Link two worksheets?
  104. how do I create a formula to calculate sales tax using Yes & No
  105. How do I change multi-line entries to single line entries in Exce.
  106. drop down box
  107. How do I summarize totals for a list of values in Excel?
  108. when cutting and pasting to different files the year changes... w.
  109. Addition base on condition
  110. ROI analysis template?
  111. Duplex printing a multi-worksheet workbook
  112. gratis bestanden
  113. excel 97 stopped working
  114. Finding Value
  115. Comment Box Auto-sizing
  116. referencing a sheet named in a cell then using data from that sheet
  117. VLookup
  118. Add multiple excel worksheets(tabs) with jpgs
  119. How to use linest with variably sized data arrays?
  120. Date Value Funtion in Excel 2003 returns an error, but not in Exce
  121. How can I sort multiple months/years WITHOUT Alpha order taking o.
  122. excel moving average
  123. How do I remove the #div or N/A and make it 0 when using VLookup?
  124. Macro that wont go away - Help
  125. How can I extrapolate a y-value in a linear chart?
  126. Error Copying Worksheet
  127. look up tables for tax schedules
  128. How do I add up a range of times giving answer in hrs & mins >24h.
  129. In Excel, lists should be sorted.
  130. how do i remove hyphens from between numbers
  131. how do i encrypt an excel workbook/worksheet report?
  132. how to change a number to name
  133. How to combine conditional format with formula ?
  134. Header & Footer
  135. How to filter and list data based on different data.
  136. Worksheet freezes on Data>Subtotal
  137. arrow keys move entire sheet instead of cell to cell
  138. How do I count numbers in a range that are greater than and less .
  139. how to count unique values in excel based on criteria
  140. Time Format
  141. Newsgroups
  142. combining workbooks
  143. Extracting data from the current date
  144. How do I sum currency only numbers in a range?
  145. How do I set up a correlation formula?
  146. Finding the cell reference of a matching search value
  147. do not allow rows broken
  148. CLEAN Formula
  149. Multiple Condition Formula
  150. "proper" function excel wksht
  151. HOW CAN I AUTOMATICALY UPDATE STOCK PRICES
  152. Weird interger calculation
  153. bullet points
  154. Lookup values in a column and display them in order with no gaps
  155. count for percentages
  156. Excel formulas based upon the color shading of a cell?
  157. date conversion
  158. How to lookup the dates of a list that are only the first of the .
  159. NPV calc with more than 29 arguements?
  160. Sum of named ranges conditional to date?
  161. More help need with my double col lookup function
  162. how do you use named cells in the countif function
  163. Using SumIF formulas with multiple lookup values
  164. How do I change the overall size of a spreadsheet?
  165. Frequency formula
  166. How to calculate 2 standard deviation?
  167. Changing Cell formats to date fields automatically
  168. MATCH
  169. How can I copy a cell from one page to all pages of a workbook?
  170. Excel 2003 Multi-worksheet copy via drag/drop
  171. Database
  172. How can a timestamp in an Excel row be automatically updated if a.
  173. Effective rate of Interest and Copounding Interest
  174. compatibility of Excel 03 with Excel 02?
  175. How do i make a sum formula ignore #div/0! errors in the range
  176. Conditional Formatting
  177. MCONCAT only Visible Cells
  178. Lookup value
  179. How do I or can I put a vlookup or hlookup in conditional formatti
  180. why can't i enter text into merged cells in excel
  181. Hide Enable/Disable Macro pop-up when file opens
  182. MIN, MAX, AVERAGE functions
  183. time
  184. How do I convert Date serial number to date
  185. WorksheetFunction Documentation
  186. How do I hide and show all toolbars
  187. How can I create a blotter?
  188. Filling cells on a summary page
  189. excel tabs
  190. sorting a text column
  191. Tie records in RANK
  192. I get my formulas like this RC[-1]*R[-2]C[6] how could I convert .
  193. Generating business days in a calendar month, EXCLUDING holidays
  194. Generating business days in a calendar month, EXCLUDING holidays
  195. Using Air Coordinates in a Worksheet
  196. Copy GetPivotData Function
  197. NetWorkDays Function Syntax
  198. how do i find which sheets contain links?
  199. formula - sum "x" column L only when same row contains "y" columns
  200. multiple lookups - xls2003
  201. Remove zeros
  202. Splitting a cell
  203. Formatting a text box to display as currency
  204. Creating Linked Workbook file name using cell variables
  205. Trace Dependents and Precedents not working
  206. date format
  207. Function "Networkdays"
  208. How do I link a check box to a macro?
  209. Creating a linked spread sheet
  210. I have a master list can I get office to orangnize by city for me.
  211. Looking up data in a table
  212. How can I create a chart when double clicking a cell?
  213. Calculating Percentages in a Range
  214. Calculating Percentages in a Range
  215. Splitting a Cell
  216. how to enable macro
  217. How do I do a VLOOKUP from 2 ranges and add the results together?
  218. percentage of wind power
  219. Cleaning Product Code list
  220. Data Range Will Not Expand
  221. merge data
  222. Update a Database Using Excel
  223. link
  224. How do you validate listed information with comment?
  225. Reducing & increasing tabs on display
  226. How do I format cells and enter data to be valued for TIME and th.
  227. SUM if with 3 criteria
  228. Cell will not format numbers correctly for a 13 digit custom barc.
  229. How do I get a pivot table to sort based on the data items sectio.
  230. empty cell
  231. Using FREQUENCY Function to Count
  232. Pushing my luck
  233. copying data horizontally
  234. Top 25
  235. quotations form
  236. Empty Cell calculation
  237. Get date function?
  238. Excel 2003 will not display color fonts or color fill cells
  239. Change cell color dependin on date ...
  240. Stopwatch
  241. Why can't I see Analysis Toolpak functions when I have loaded it .
  242. Networkdays Function Not Working
  243. Sumif on two criteria
  244. combo box problem I am pulling my hair out about!!!!
  245. data structure and my problem
  246. split results to multiple worksheets
  247. How do I convert Arabic numbers into a spellout text
  248. vlookup error!!
  249. referring to other cells with formulas
  250. can I use data validation in pocket excel
  251. How do I lookup a table from right to left ?
  252. Copying Text to another cell/worksheet
  253. Pivot Table Row Cell (Blank)
  254. bar inventory
  255. bar inventory
  256. Embedding an "insert row" macro with data validation
  257. excel should have a function to count sheets
  258. problem with dynamic graph
  259. matching column entries
  260. MAX Function
  261. Beginner needs help w/first work project
  262. Copy GetPivotData Outside Report
  263. How do I display the number 007? It keeps changing to 7
  264. printing multiple workbooks.
  265. How can I sort many items alphabetically, ignoring page breaks??
  266. Making Blank Cells Really Blank (Zen Koan)
  267. RE: Excel Formula
  268. Macro transfer
  269. Haw to Randomized available data
  270. Day of week function needed
  271. convert cell contents to different data file format
  272. RE: formula
  273. formatting data
  274. excel formula
  275. Merging data from Excel to Word
  276. Re: Removing trailing spaces from cells ?
  277. Switch between protected worksheet by CTRL-PgDown
  278. Subtracting Time from NOW() Value
  279. PULL FUNCTION
  280. Reduced Row Echelon form
  281. can not select conditional formatting
  282. How do i put back my excel worksheet menu bar
  283. Excel =0/div
  284. Count Bold Text
  285. How to use an array or matrix to return text vs. numeric values
  286. new sheet created 'on the fly' from template in same workbook - H.
  287. Excel question.
  288. roundup - error in formula
  289. increase all values in a column by a percentage
  290. lookup tables
  291. Percentage Formula
  292. Is AUTOSAVE FUNCTION embeded in the software or do I have to inst.
  293. Date Due Reminder
  294. Re: Is it possible to search for the "?" character
  295. how do you rename columns?
  296. Palm PC, Excel
  297. Turn the Entertainment industry into your personal Cash Cow!
  298. Need Function
  299. working with references of cells
  300. Vlookup Problem
  301. RE: Beginner seeks help with IF statement
  302. Can excel read numbers in the Sexagesimal system (DMS)?
  303. how to extract a filename?
  304. spread sheet
  305. cell formating
  306. new hosting for me
  307. unhiding rows automatically
  308. networkdays() problem when deleting row or column
  309. I need this formula
  310. Heavily linked spreadsheet freezes with "calculating cells 0%" - .
  311. in excel just want to add 4 columns and total in next column
  312. SUMPRODUCT vs Text???
  313. if the value of a cell in a range is not blank, then return the v.
  314. Help me please!
  315. I have 2 columns to compare,each text. doing formulas, they don'.
  316. Restrict input if amount is exceeded
  317. dates in query
  318. Function HELP!
  319. Displaying, manipulating and printing huge lists of data
  320. Row height is not adjusting after activating Merge Cells & Wrap Te
  321. Pivot Tables: How do I show ALL field rows, including empty rows??
  322. Removing Duplcate Names
  323. how do i make a paragraph appear in one cell area?
  324. GETPIVOTDATA
  325. Assign Specific Function to Shortcut
  326. Help with formula
  327. Range Lookup? Is there such a thing like this?
  328. Protected Cell
  329. How do I switch names around in excel?
  330. Loan amortization
  331. Formula Troubles........
  332. How do I use a micro created in one workbook in other workbooks?
  333. Car assign simulation
  334. IRR calc Monthly vs Annual
  335. Sheet name in formula
  336. how do I name a cell using an entry in another cell?
  337. Cell converts a date entry to "=" and displays "01/00/00
  338. Sheet name in formula
  339. Formatting problem
  340. Yield rate
  341. weeknum function
  342. Dynamic Combo Box
  343. Recording the First Change of a Cell Value
  344. Comparing lists of map references
  345. Lookup Function - Specific Values
  346. using LOOKUP instead of IF on dynamic row
  347. Custom Cell Format
  348. Last significant row in a column
  349. up to 7 functions?
  350. Cut&Paste Macro
  351. Can I start a macro from a cell by using a formula
  352. List Function
  353. drop down list
  354. Creating a functions
  355. MIN Function
  356. Creating a formula
  357. How do I keep each week's data from the payroll calcualtor?
  358. lookup function
  359. count cells across muliple columns
  360. Formulas not calculating
  361. can you make a title page using Excel?
  362. Select header if formula
  363. Macro Help
  364. Color viewing problems-Cell
  365. Can I use conditonal sum and have results on a linked sheet?
  366. how can i subtotal on a text value - ex. every Monday?
  367. Formatting an entire row based on one cell
  368. HELP with function, possibly code!
  369. Index & Match
  370. Calculation to subtract TimeValue from Now() Value
  371. create an excel formula with contitions
  372. Jason Morin Please Respond
  373. Conditional Formatting, reference another column
  374. Can I disable the copy feature?
  375. IF statments for multiple listings.
  376. List box or combo box on an Excel spreadshee...
  377. linked objects following and leading returns
  378. Embedding Word Docs into Excel Worksheets and Then Printing The Word Docs
  379. how do i automatically insert the current author's name in a cell.
  380. concatenate
  381. Recording the first change in the value of a cell
  382. formula to calculate a column based on dates in a different colum.
  383. Formula to count number of dates in an array
  384. Unhiding rows using data validation
  385. Why can't I link a cell from worksheet to another when it has an .
  386. Lookup function
  387. Vlookup based on two lookup values
  388. Spin button in a work sheet - how do I make it work?
  389. number of days in a month
  390. What formulas are best for sorting by date?
  391. IF
  392. Re-calc. speed question
  393. unable to total a column
  394. lookup values to sum
  395. How to compare 3 numbers and return value
  396. How to count how many different items in one colum?
  397. Count cells with length not equal to 7
  398. April 1
  399. How to make a number round up/down to a set number
  400. On a excel protected worksheet, how do I change the tab order?
  401. Need help with Excel Lookup
  402. navigate in Excel worksheet without scrolling
  403. Help? start macro automatic in excel
  404. Separate Spreadsheets
  405. IF Function in incremental charges
  406. Column WE
  407. Please Help
  408. Bring Back Qualified Sum from another WB
  409. Why are the cells of my workbook not refreshing?
  410. Algorithm for computing Excel PercentRank
  411. Using ABS() in a range of cells
  412. Problem with updating values with INDIRECT.EXT
  413. excel and access
  414. count check boxes
  415. Absolute address in Workbook linking
  416. How to lookup multiple values and summing them up in one cell
  417. Put a Worksheet in a workseet?
  418. Help with code please
  419. VLOOKUP: type or paste values
  420. Combining two formulas
  421. Need formula for: if A6=100 thru 125, then "A", etc thru "S"
  422. links
  423. How to link a document to a workbook with a hyperlink in excel
  424. Hyperlink ONE word in a cell ???
  425. SUMPRODUCT using months
  426. Excel Formula WEEKNUM only works on weekdays 1 and 2, why?
  427. excel 2002
  428. Creating links to a worksheet on a network.
  429. Creating links to a worksheet on a network.
  430. Summarize Data Set
  431. concatenating numbers
  432. Re: Subtotal Excel 2003
  433. Emailing a workbook with links
  434. counting coloured cells
  435. Link to powerpoint resizing graphs
  436. Lookup function with drill down?
  437. IF Function - If the reference cell data is presently unknown
  438. Reversing First & Last Name
  439. Macro Help
  440. Effective yield rate - non level premium flow
  441. Count Check Boxes
  442. mag-text in merged cells-automatic row heigh
  443. How can I change an Excel spreadsheet that has UPPER case to PRO.
  444. Mode Function with Criteria
  445. When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)...
  446. PLEASE HELP......COPY DATA FROM ONE WORKSHEET TO ANOTHER
  447. Compounded formula using SUM & AVERAGE
  448. Excel: Additional Conditional Formatting
  449. rounding time question
  450. how do I type in a number and have it automaticly add to the exs.
  451. color cells with text
  452. $20,000 due. Pays diff $ every x. Int calc per annum. Need excel .
  453. Date functuion.
  454. Auto Update upon shifting, inserting or deleting
  455. Old Lotus Files
  456. Multiple Condition Sumif Formula
  457. INDIRECT.EXT question
  458. 'add-to-basket' function
  459. Why does it say "Filter mode" instead of "X of Y records"?
  460. time format
  461. how do I insert a geographical map
  462. Function question
  463. Binary Numbers longer than 10 characters
  464. Why won't it Excel fill in weekly dates now, changes them to daily
  465. IF Functions
  466. HELP - need to returns the current number of past month this year and ...
  467. In Excell sheet i want to insert more than 65,536 rows how i can .
  468. How to create a formula for this function.
  469. Automatic Number Creation Problem?
  470. I want 20 rows in excel to take up full A4 page
  471. Is there a way to assign a specific printer to different sheets i.
  472. Data Validation
  473. how do i set up a "balance over 30 days" field in an invoice?
  474. How To Use Cells Without Values in a Formula
  475. sumif involving another column
  476. import external data from changing file name
  477. How do I import from Quickbooks and create a link.
  478. Matrix Query Part II - lookup value
  479. How do I search for a string across multiple worksheets in Excel?
  480. how do I rank negative and positive numbers?
  481. help
  482. appending data to individual cell throug function
  483. mag-keyboard shortcut
  484. Can I create an order summary report in Excel?
  485. How do I sum and add * on each side based on value in excel?
  486. Only Reference cell with data in them
  487. Matching Data
  488. how do i use "if" in cell that ref another with text from a pulld.
  489. Sum Formula Help Please
  490. EXCEL -- want to do have ''averageif'' - like sumif function - H.
  491. How do I add an area code to a list of phone numbers in Excel?
  492. Counting days
  493. problem when saving CSV file
  494. Difficult matrix query
  495. How can I assign a number value to a letter grade in Excel?
  496. Vlookup of an if statement return
  497. Automate copy command?
  498. Finding Specific Text in a Text String
  499. Calculating differences between dates
  500. Networkdays function
  501. Bringing partial data from one cell into another
  502. Re: Networkdays
  503. Is the data validation criteria limited to a few number of items .
  504. Paste data from another worksheet
  505. Cannot enter formula in a cell after removing a circular formula
  506. Getpivotdata - referncing a data_field resulting in "REF!
  507. combining data from multiple sheets
  508. SUMING VARIOUS LINE ITEMS FROM MULTILPLE WORKBOOKS
  509. Month/ year function.
  510. Linking data that contains specific row criteria
  511. Sumproduct with Wildcard *
  512. Formatting combined Cells
  513. Repost: Vlookup Bmp
  514. "IF" formula question
  515. excel help
  516. Bring back the old help format!
  517. Help comparing data and returning information...
  518. increase conditional formatting in Excel
  519. Converting imported numbers to decimals (rather than /100)
  520. How do I remove a blanck space from the beginning of a formula?
  521. Function IF / test / Picture result
  522. auto dating after entering the first date
  523. Combine VLOOKUP, IF, AND in one formula
  524. Autocalculate
  525. Separating text
  526. access my data from my master worksheet while calculation is don.
  527. Array Function with VLOOKUP
  528. can excel draw a shape based on values entered in cells
  529. function IF / how to input pictures into this functions /
  530. Max and Min date from listing by account no.
  531. convert character to value at relative cell
  532. "IF"
  533. excel: How do I setup a function to put any numbers over 80 into .
  534. zip code entry
  535. zip code entry
  536. For Ron Bruin Please
  537. How do I find the contents of a cell using the "ADDRESS" function.
  538. How do I setup a depreciation template for all types of assets?
  539. need help with a formula in excel
  540. Automate Pivot Table Drill down
  541. YTD Budget Totals
  542. Finding dates within a date range
  543. How many values appear more than once in a range?
  544. How to countif involving another column?
  545. bringing data from one workbook to another using a date stamp func
  546. No Subject
  547. subtotaling large data set
  548. How do I get rid of duplicate text?
  549. IF and ISERROR Functions
  550. sumif vs sumproduct
  551. Decimal Time
  552. HELP with Formulas
  553. Vlookup Bmp
  554. create links for formulas
  555. sorting problems
  556. nested sumif or sumif with two criteria
  557. can't insert more rows even though not at max rows
  558. Warning message base on date
  559. WEB QUERY - HELP!!!
  560. Syntax for inferred cell references
  561. I want to return a value based on the status of a check box. If .
  562. CHAR(10)
  563. Merged Cell will initally show text from 1st worksheet but then wo
  564. Get current cell with VBA function
  565. cant add a worksheet
  566. Global Setting For All Workbooks - Filename In Footer
  567. difference between two dates in years, months and days.
  568. Excell XP (2002)
  569. =RIGHT (function)
  570. Modifying an Array Formula
  571. Automatically Insert DATE, so that DATE will NOT change
  572. How do I download install Excell 2000 Analysis Tool Pak?
  573. how can I add cells in hours and minutes, eg 1.15 +1.45 to equal .
  574. How do i count number of weekdays between two dates?
  575. Need formula for budgeting payroll taxes.
  576. HELP WITH AUTO EXPORT FROM OUTLOOK TO EXCEL
  577. HELP...PLEASE...W/ IF/THEN/COPYTO STATEMENT - THANKS!
  578. SUMIF Returns a #VALUE error when external source is closed
  579. How do I identify the 7th digit in a 13 digit number, then establi
  580. How do I export information from excel to word, ie database of na.
  581. Improper fraction format?
  582. how do I sum inserted cells in EXCEL?
  583. How do I combine multiple whooksheets with identical columns
  584. Count numbers of entries
  585. getpivotdata refresh problems
  586. IF Statement question
  587. if a cell contains certain text, cut and paste to another sheet
  588. Formula for finding the differance between two times
  589. how do I write a formula that will figure weekly overtime?
  590. How to convert columns of data to one column of text
  591. Right mouse button
  592. How do you populate the X variables in Regression analysis for mo.
  593. Microsoft Excel --> Microsoft Works Spreadsheet
  594. LONG VLOOKUP
  595. VLOOKUP
  596. Sorting names in a range
  597. Hard page break that won't allow me to scroll past? would love to find out ;)
  598. Changing display of decimal value based on the value in the cell
  599. VLOOKUP Function
  600. Two dimensional sum by week
  601. Two dimensional sum by week
  602. Mouse right button not working
  603. Excel/Access 2002 sum function
  604. How to make background grid lines disappear when viewing
  605. CSV FILE TOO LONG FOR EXCEL
  606. Effective Annual Interest Rate
  607. How can I generate number based on two measurements?
  608. apply cell names to formulas in multiple worksheets
  609. I cannot rename my excel sheet?
  610. IF functions
  611. 2 cells value to 1 cell
  612. why does my cells turn blue like I'm formatting when I try to ent.
  613. EXCEL Question???
  614. ACN to CAN
  615. Printing 2-up
  616. find a cells from a range of cell
  617. Opening an excel spreadsheet
  618. multifuntion formula
  619. How do I open a file downloading in MS Excel
  620. how do I repeat a drop down box
  621. Boolean masks
  622. Multi-If function
  623. formula help
  624. Grand total same cell in all worksheets
  625. formula help
  626. How do I convert 02/05/05 to 02, please?
  627. How do I pause a macro to select specific cells
  628. not able to convert text, or graphic number to regular number in e
  629. Points behind next rank in a fantasy league
  630. excel formula
  631. REMOVE SPECIAL CHARACTERS FROM TEXT CELLS
  632. Excel
  633. Excel
  634. How do I convert $500 to Five Hundred Dollars?
  635. Match Last Occurrence of two numbers and Count to Previous Occurence
  636. VB Code to do this....
  637. Merged cells
  638. If Statements
  639. Page margin units
  640. vlookup
  641. excel to outlook
  642. Looking for formula index/match-type that returns an array
  643. easy question
  644. HELP! Lose Database Query upon Refresh
  645. Recovering excel file
  646. Enter an Excel cell reference as part of a custom header/footer
  647. function values do not refresh
  648. conditional forming causing linking errors
  649. I have user defined functions in sprdsheet. I want to put sprdsh.
  650. Merge & Center
  651. Need to avoid a circular reference...
  652. How to keep linked cells blank until information is entered?
  653. Cell References and External Data
  654. How do I forecast monthly and annual totals from previous year's .
  655. Rounding to nearest integer
  656. Time Cards
  657. count if
  658. Averages: Exclude Rows with 0 Values
  659. how do i make overtime in my payroll sheet calculate after 42.5 h.
  660. Excel Map function
  661. Backwards lookup
  662. coloring overy other line without doing so line by line
  663. Importing from other application
  664. Summary of values from a date range
  665. Applying a currency rate that doesn't change when source updated
  666. VLOOKUP
  667. how do i change a spreadsheet into labels?
  668. Set values in functions??
  669. Data validation not showing drop down
  670. saving options along with spreadsheet
  671. Set a value, use it later (possible VBA?)
  672. How can I get a count of cells in a range that are shaded a certa.
  673. how do you calcualte a payment for a loan.
  674. match and #ref
  675. Data $9,620,320 principal, 360 # payments, 9 % rate, fv 0. Why do.
  676. save external link values
  677. How to convert entire excel document from lower to upper case
  678. initiating a macro
  679. Help with formula please
  680. How to share data between worksheets?
  681. format cells
  682. can i sum up only visible cells?
  683. Why do I get a #Name error when I use the DateDif function?
  684. Why do I get a #Name error when I use the DateDif function?
  685. how do you get excel o calculate antilogs
  686. How do I sort by complete rows in excell
  687. countif/sumproduct on multiple criteria
  688. How do I pull information from one worksheet to another using cer.
  689. simple formula with blank cells
  690. index / match function
  691. how do i make one chart that my ees can input info, and have a se.
  692. Help combine 2 formulas into 1
  693. Summing Every 40th cell?
  694. Excel question? Regarding cell formula
  695. Can VLOOKUP deliver the second occurence when target column entri.
  696. How do I sort data from various worksheets in the same workbook i.
  697. What formula do I use in Excel to determine whether one cell fall.
  698. inventory counting
  699. Find project start and end dates in a DB with many different proje
  700. SUMIF problem
  701. Remove leading Numbers from text
  702. EI_CALC Function
  703. Datbase check
  704. formula SUMIF or whichever one will work for my issue
  705. indicate whether a cell contains a formula
  706. Old, LOTUS 1-2-3 based function
  707. Cell content elimination; duplicate
  708. Only want color to show when cell is active
  709. Can Excel "slide up" rows with content thru empty rows to condense
  710. round up cells to $xx.99
  711. Microsoft excel 2000
  712. formatting date
  713. functions
  714. I need to know formula for matching retirement percents
  715. How to calculate a sum as one outcome of an IF statement
  716. Concatenate & Force argument to End of String-(spsjp)
  717. formula for calculating # of days between 2 cells
  718. delete all text that match
  719. quotation form
  720. Set Tab key
  721. dates and concatenating
  722. I need a VLOOK-UP formula that uses two look-up vaiables in seper.
  723. Working with If statements and time
  724. Returning Multiple Values Based on One Value
  725. in excel how do I show a number as an alpha eg 65 as sixty five?
  726. What are the tricks using "=(SHEET1!cell_reference)".
  727. difficulty changing cell format
  728. HOW DO I CONVERT CELLS/ROWS FROM ON FORM OF MEASURMENT TO ANOTHER
  729. Creating Drop down menus in an excel cell
  730. looking for help on....
  731. In excel pointers should be availible
  732. Absolute average
  733. Spread Sheet Tabs
  734. VLOOKUP TABLE_ARRAY
  735. Calculate time and cost
  736. Auto Update Links
  737. Home account
  738. how to write macro after autofilter is applied
  739. detect cell color and count it
  740. Extracting worksheet names....
  741. How do I add the count function to the toolbar?
  742. How do I auto-protect a worksheet?
  743. import select data from another workbook
  744. Color detection
  745. move page breaks
  746. calculate permutations of nonnumeric data
  747. Need a simple formula please
  748. sumif with two conditions
  749. sorting with data on alternating [every other] row
  750. HOW CAN I READ SPREADSHEETS CREATED BY OFFICE 2000 ON OFFICE 2003.
  751. How do I link 2 worksheets in different files?
  752. Counting within a cell
  753. TURN LOWER CASE TO UPPER CASE IN EXCEL?
  754. copy visble cells at the subtotal level
  755. EXCEL 2003: Apply Conditional Formatting to COLUMNS
  756. how do I make a heading row "float" to follow the data as I scrol.
  757. Formula linked to cell with Macro
  758. Rounding Question
  759. Transfer Items to a list with no duplicates
  760. How to convert a series of numbers
  761. Computing totals for tax and non-tax items
  762. EXCEL 2003 PROBLEM
  763. Updating master workbook from source that may/may not exist
  764. Is there a way to change text color using the Logical IF statemen.
  765. I want to select excel cells of difference colors and increase th.
  766. Excel static current date/time problem
  767. Pivot tables-multiple payments
  768. How to copy conditional formatting
  769. Need Formula for Date Conversion
  770. Separating dollars and cents
  771. Calculate Due Date
  772. Pivot table report
  773. Excel running date formula minus weekend days
  774. Auto Calc not working
  775. How can I run a macro in a protected worksheet?
  776. RUN CONSECUTIVE EXCEL DATES ON DIFFERENT PAGES IN WORD DOCUMENT
  777. How do I set up a equipment replacement reserve schedule
  778. Auto Calc not working
  779. MY WORKBOOK WON'T LET INSERT ANOTHER WORKSHEET.
  780. SUMIF/SUMPRODUCT??
  781. Totaling rows of text
  782. Can I select a worksheet based upon a cell criteria?(for printing)
  783. Working w/ non-standard Time Format
  784. How about adding a quarterly function to Excel like its EOMonth?
  785. Value to text words conversion
  786. data in empty cells
  787. Using date function in an if statement
  788. fax multiple worksheets
  789. Converting Columns to Rows
  790. how do I change case in an entire column of text in Excel
  791. IF, AND, OR conditions?
  792. IF, AND, OR Conditional formula?
  793. Formulas
  794. Sending a group email
  795. Explode Cell Data
  796. how do I assign a symbol to the result of a part of a nested IF s.
  797. I want to create a macro to where after we enter data in a spread.
  798. how do i sum 2 values that fall between date ranges?
  799. follow-up from yesterday's "creating formulas"
  800. need help finding a Date range within long list
  801. Split cell values based on content
  802. Question about financial calculation PMT
  803. Conditional Formatting
  804. Multiple minimums for the same column
  805. How can I create drop-down lists with references in other workboo.
  806. Can Excel represent formula in textural format with values substi.
  807. Cell addressing using the content of another cell.
  808. Cell addressing using the content of another cell.
  809. How can i convert Text Case in EXCEL?
  810. How do you do a culmanative frequency in excel
  811. Lookup the month in a date string 01/03/05
  812. how to brack prtection password in microsoft excell in tools men.
  813. Bahttext only display in thai?
  814. Decimals separation "." and ","
  815. Add ins for Excel 2000
  816. Re: How to format cells in Excel for time in format mm:ss.00
  817. Ptable - 2 in a workbook for the same data?
  818. How do I return dynamic lists?
  819. Replace with subtotals
  820. How do I subtract column 1 from 2 and show results in 3?HELP!
  821. How do I create a workbook that links info in cell to a calendar?
  822. Some exported records do not show on spreadsheet
  823. Insert Row
  824. time differences in a column
  825. Formula Assistance
  826. Using Indirect Function
  827. i want my excel colums to be rows
  828. autofilter problem
  829. Lookup with 3 criterias
  830. How can I trim "4|+|23.68^" into "23.68" in excel 2000?
  831. lognormdist function
  832. recognize formatting
  833. If I create a random list in Excel, does it repeat numbers?
  834. vlookup with two criteria
  835. Match Last Occurrence of two numbers and Return Date
  836. dates change to numbers
  837. Updating rows - Excel Formula or Something Else?
  838. How do I take excel data and convert to label/envelope form?
  839. Renaming Worksheets
  840. If (either of these) return this
  841. If Statement - in time not decimal minutes
  842. Worksheet Protection
  843. Insert rows
  844. Drop down list with multiple choices
  845. Help with importing from Outlook
  846. Trying to enter a range of numbers using >1 and < 5 in a formula
  847. Plotting Dates
  848. referring to other worksheet
  849. Why not nest more than 7 functions in Excel formula???
  850. Sum of a column
  851. sumif range of varying size
  852. HELP!! Need help with if/and/then/copy statement!!!
  853. Combobox/tab order
  854. Excel should allow me to freeze pane in a split window
  855. Tool > Compare and Merge Workbooks... This is not a highlighted .
  856. Cursor wil not move left in worksheet
  857. If statement help
  858. Save as not working for laptop to desktop
  859. if function errors
  860. Creating Formulas
  861. Can you make cells in Excel flash or twinkle?
  862. Precedents do not work
  863. Animate excel?
  864. Stop numbers converting to dates.
  865. Returning Multiple Values Based on One Value
  866. How can I create a formula to locate data between two dates?
  867. How can I link a cell in one worksheet to a cell in another works.
  868. How do I calculate present value of a single sum?
  869. Work books
  870. Opening two excel worksheets with dual monitors.
  871. how do i change footer settings on multiple sheets at the same ti.
  872. how do I write a formula to round up a number?
  873. MACRO
  874. Hyper Links
  875. Cell problem
  876. How do I lookup values from rows and columns Simultaneously
  877. How to calculate subtotal if a row is hidden
  878. Export from excel
  879. calculating moving average
  880. Networkdays problem
  881. HOW TO CHANGE BAHTTEXT (THAI TEXT) TO ENGLISH TEXT IN EXCEL
  882. currency convertor-travel expense
  883. rounding to closest 5 cents
  884. Fill formula question
  885. Using COUNTIF to check values in multiple columns
  886. List of repeating names
  887. Evaluating similarity of text strings
  888. how do i copy a formula's result to another cell, without copying.
  889. Comparing a value to a list of values does not work in Excel 2003.
  890. If formula
  891. ### when the number is NOT negative?
  892. How to IF dates?
  893. VLOOKUP - DOUBLE CRITERIA
  894. Worksheet database
  895. Vlookup - double criteria
  896. Adding Work Days only in a function?
  897. Vlookup - double criteria
  898. Vlookup - double criteria
  899. Count and Sum Total occurrances of two specific numbers
  900. How do I assign sequential numbers in an Excel 2003 PO template?
  901. Count cells in one range based on parameters in another range
  902. Insert characters in a text string
  903. Deleting many named ranges
  904. employee scheduling
  905. pivot tables
  906. How do you print all data in a cell?
  907. How do I convert cells containing formulas to text (value returned
  908. Need help using search functions
  909. copy every 30th cell in the column into consecutive cells in anoth
  910. Email/Save/Macro
  911. Need a ISWorkday Function -- Any Ideas
  912. Copying and PAsting using MACROS
  913. How to keep rows together when sorting columns?
  914. Constant Value in formula.
  915. IF function?
  916. TEMPLATE FOR VALUE PREMIUM
  917. HELP....Is there a way to automate copy/paste special/transpose -
  918. Look up of data in a different Sheet
  919. COUNTIF with compound comparison
  920. Formatting in IF Functions
  921. Can't find the right lookup formula for this
  922. Spreadsheet Historical Prices for European Stocks
  923. Easy formula Question
  924. can I create a formula using text made from the concentate comman.
  925. VLOOKUP...
  926. "Pleading paper" in Excel?
  927. Function/macro to relocate RxC to CxR?
  928. League Table
  929. excel formulas
  930. How do I set up a value (34.7) to value (34) in excel?
  931. Finding specific word in column
  932. Dynamic Range for Function (Vlookup etc)
  933. countif criteria
  934. I need help with random number generation
  935. Lengthy and weird, but interesting
  936. array formulas
  937. Entering Data in multiple cells on one sheet & having it auto upda
  938. Formula appears as text
  939. Tax- offsetting losses against profits
  940. Counting values containing part of a cell
  941. Formula(ae) to mimic offsetinmg of losses against profits
  942. isformula?
  943. Add a constant to data
  944. IF Statement that's conditional on multiple IF Stmts in other cell
  945. Count number of instances in sheet e.g. how many males/females
  946. Sum numbers that include #N/A
  947. How do I calculate Amount of Sales Tax from Total Amount?
  948. What function can make cells shift up when they are blank?
  949. How do I convert 00:03:54 to get 234 seconds?
  950. Cell frequency II
  951. Button to clear all entries?
  952. Simplify Vlookup function in Excel
  953. Combine date with text
  954. Delete rows not in Edit Menu
  955. setup
  956. ISEVEN
  957. Understanding this formula
  958. finding multiple MIN's
  959. How do I make a copy / paste function default?
  960. In between
  961. Converting text to numbers
  962. Expanding/Collapsing Rows?
  963. Creating a macro in excel
  964. Value of formula field
  965. RE: VLOOKUP
  966. Vlookup w/Date Function
  967. How do you calculate number of workdays from dates entered?
  968. How do you calculate number of workdays from dates entered?
  969. Appending Text to a Cell Value
  970. My formulas does not sum together
  971. Work Hours Time Question
  972. Method of selecting an area with a macro
  973. Attaching a macro to a VB button on a form
  974. how do you add vlookup results?
  975. add "X" to cell based on cell value
  976. Excel 2003, time scheduling?
  977. Formating decimal and date
  978. Export Excel Dates to Outlook Calendar?
  979. conditional formatting 24-hour clock
  980. Can I see a list of the worksheets within a workbook without scro.
  981. COUNTIF woes
  982. Pivot Table Grand Totals
  983. How to find the second most frequent number in a list?
  984. How to set different font colours in a cell?
  985. enable autofilter in a protected worksheet in Excel 97
  986. Need a 1 Column multiplication formula for 2600 cells. How?
  987. Check box
  988. I need a formula like this "@if(2000
  989. Excel Solver background in forecasting modeling
  990. Macro help
  991. Multiple Sheet workbooks
  992. how to do more than 7 if
  993. Auto filter no longer comes up
  994. How does this formula work
  995. Inverse sin
  996. HELP! Filtering and sorting lists.
  997. In excel how do you format so 09561 for example the zero does not.
  998. Select all worksheets
  999. IF Statement help...
  1000. Excel 2002 autofill and offset