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. a number is replaced by text when inserted anywhere in the sheet
  2. visible formula
  3. VB Code and Excel
  4. add column using dates as argument
  5. Values in a Table
  6. how do i subtract and divide
  7. Sum of data between two dates - tried SUMIF and it returned "0"
  8. Using excel to "scrub" lists
  9. Help...Need to modify data within a column in a .csv file
  10. subtract and divide
  11. SUMIF meets a criteria
  12. Conditional Fromatting and Formulas
  13. custom function not recalcing on sheet with outline view
  14. Links auto update on some workbooks but not others
  15. Pivot table displays data differently, Excel 2003
  16. subtract year and divide
  17. compare info in 4 worksheets and highlight fields that are the sam
  18. write value to another cell in excel
  19. If a time is between 2:00PM and 11:00PM enter 1 otherwise blank
  20. Header--looks like one but appears to be embedded.
  21. Excel Startup
  22. Sum if is only calculating one column
  23. Need Help w/Formula's
  24. How to: Pass Command Line Parameter ???
  25. Macro Printing
  26. Time sheets
  27. invisible macro commands?
  28. Allow user to fill in on-line form without changing formatting
  29. Nesting more than 7 variables in IF equations
  30. Pulling a date in the current month
  31. lower case to upper case
  32. Sorting function button
  33. Editing an existing formula
  34. Format Numeric data in Textbox
  35. drag multiple data items into pivot
  36. Monthly Totals
  37. How to automatically number an index column
  38. Help with IF Formula
  39. ccalulate interest %
  40. Sheet Reference
  41. VLOOKUP keeps saying #NAME?
  42. Changing Date Format
  43. Consolidating function
  44. Copy WITHOUT adjusting values
  45. Active windows "overlapping'
  46. Subscript and Superscript with the TEXT function
  47. Linking cells in different spreadsheets
  48. PERCENTILE with an IF Clause
  49. forms in excel
  50. Is there a good book that would help me learn functions and formul
  51. Web Queries
  52. nonsequential cell references
  53. Indirect reference (again?)
  54. Extract sub string
  55. Match Index
  56. Conditional Formatting not applied to data exported from Access
  57. irr, xirr, npv frustrations
  58. NORMAL DISTRIBUTION
  59. Please Help with GRID LINES Problem - Urgent
  60. custom dependent list validation
  61. Remove leading space
  62. want to 'share' a workbook but Says Read only'when others try save
  63. Cannot use formula
  64. The drawing tools in MS office should include an erase tool bar
  65. Putting computer date in cell
  66. todays date formula
  67. Does anyone have a formula for zipf's law?
  68. how to change one cell height not the row
  69. how to change one cell height not the row
  70. Is there a way to find the order of how the data is put in origina
  71. How do I insert a leading zero?
  72. how to include a cell reference that is contained in a cell withi.
  73. is it possible to have more than 3 colours in conditional format
  74. Web Query
  75. Problem converting Hours to Days, Hours, Minutes
  76. GRID LINES PROBLEM iN EXCEL 2003
  77. Strange "Format>Cells" behaviour
  78. How To: Link worksheet data to pre-existing chart tables
  79. Syntax for referencing totals of grouped data in a pivottable
  80. Make inventory sheet to track, order & reduce quantity from master
  81. Excel - auto freeze list headers
  82. quickly create extra copies of a worksheet template in a workbook
  83. shading a rowwhen a time is entered but no shading when 0 is enter
  84. how to find and add multiple entries
  85. FORMULA AUDITING
  86. Date+ returns #Num
  87. Sorting two columns
  88. number of times
  89. Isolating Email addresses
  90. count of records with 2 or more "options" selected
  91. Test for a negative #
  92. excel errors
  93. Creating a graph
  94. Working days left in the month compared to previous months
  95. Making an Excel Sheet Available Online
  96. Convert text numbers to numbers
  97. why won't logo print in colour on invoice in microsoft excel
  98. adding a button to a tool bar
  99. value in words against the value in numbers- help needed
  100. Help with Time Sheet
  101. How to delete values of a cell if it is found in another coloumn
  102. What is a CSV file in EXCEL
  103. try to convert letter grades into GPA grade points
  104. How do I subtract block N19 from L19.
  105. Text Splitting easier? (Tokeniser?)
  106. java script pop ups
  107. vlookup
  108. Adding Hyperlink to Pivot Table data
  109. conditional format for duplicates
  110. LOOKUP function -help!
  111. need help again please
  112. percentage formula
  113. row shading when a value of 0 is entered at the end of the row
  114. Formatting
  115. Formatting
  116. Problem organizing text data into new excel page
  117. How do I get Excel to tell me the angle of a line
  118. How do I copy only cells with formulas in another row?
  119. Excel time formula
  120. I wish to make a formula that adds dollars in 1 column if a date .
  121. How to save sheets in new excel files, automatically?
  122. Making a button to sort
  123. Can you reference a cell that is sorted in excel 2002?
  124. Place a "" around ALL values in a cell
  125. How to take a cell that has 3 values and make 2 more new lines
  126. Need help with TRIM function
  127. Consecutive data in different sheet
  128. My program
  129. Text Strings Conversion
  130. cell reference
  131. Widening Validation Box
  132. Retrieving information for a day of the week...
  133. Excel should include flashing cells/block and marching ants like W
  134. Conditional reference on average interest calculation
  135. WHEN DOWNLOADING A TEXTFILE EXCEL DELETES BLANK ROWS - STOP THIS?
  136. Sum total formula for adding 2 columnson time sheet
  137. Make a scrolling windows?
  138. How to project the due date according to a number of working hours
  139. converting text in cell to a date time
  140. Wild card *
  141. #NAME when I open up my spreadsheet
  142. Formula to calculate number of days between Dates
  143. Calculating number of hours between two days
  144. Is it possible to do a Find/Replace on Conditional Formats?
  145. Auto Record Transfer
  146. Find links add-in
  147. average numbers in sequence
  148. time sheet to calculate 2 different columns
  149. Converting Date to Day of Week
  150. insert add-in in a spreadsheet??
  151. need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No.
  152. How can I get rid of the ' single quote sign in excel worksheet
  153. Need Better Examples for VLOOKUP and the like
  154. student needing help w/vlookup function grading criteria
  155. 'Save As' menu disabled in Excel
  156. Any MP3 audio instructions on Excel Macros??
  157. How do I sort in Excel by the no. of characters in a cell?
  158. How do I set up vlookup formula.
  159. List Box with dynamic list - Help
  160. How do you set up two formulas in one cell? 1+2=3 or 4+5=6
  161. result of formula not displaying
  162. Returning Results Based on Two Criteria
  163. if one cell has "X" textin contents, then pull cell "Y"...
  164. nested funtions (IF OR)
  165. Sequential formula
  166. Search for a character subsequent to its first appearance
  167. Convert word table to Excel with bullets
  168. Counting number of time a character appears in a string
  169. Counting text criteria
  170. how to type this funtion
  171. How do I move certain Cell data from one worksheet to another?
  172. Proper way to convert numbers to text
  173. Remove hyphens in text
  174. Protecting Sheet
  175. display last date document saved
  176. count no. of dates in a column that falls on certain month & year
  177. Is this cell protection?
  178. Comparing two spreadsheets
  179. Column Width
  180. Column Widths
  181. networkdays function help
  182. Filtering Records
  183. Returning row # using match or index of repeated text in a complex table
  184. Can excel recognize a word and auto format a formula, on diffe she
  185. Can I turn the #N/A result from a lookup function to a zero?
  186. Help with multiple workbooks
  187. Resize Range - Macro
  188. Display only certain cells
  189. How do I matchup this criteria?
  190. Average If Adejecent Cells Greater Than Zero
  191. Formula & functions intermittently fail to calculate
  192. VLOOKUP
  193. Getting around Worksheet_Change()
  194. Some 'Names' cannot be deleted by Insert|Name|Define-Delete button
  195. What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out.
  196. excel/some text auto repeats in same columb others don't why.
  197. How do I keep blank pages from being included in header count?
  198. How to apply rounding across a range of cells with other formulae
  199. Set up a formala to refer to a cell in a different sheet
  200. simple formula
  201. 6 months of working days
  202. Find and replace with a lookup
  203. Running Tab using Quarterly Payments
  204. Flashing cell color
  205. hyperlink - link one cell to another in a worksheet. how?
  206. Pivot Table Lay Out
  207. Pivot Table Integrity problems
  208. How do I copy conditional formats so it changes cell references?
  209. If statements...
  210. extract numbers from cell problem
  211. Changing "returned" values from "0" to "blank"
  212. Increase number of macro names
  213. Convert time into integer
  214. Help with a formulae
  215. Growth
  216. Div error help
  217. How to create a formala in one sheet for a cell in another sheet?
  218. SUMIF SUBTOTAL OR SUMPRODUCT?
  219. Formula to separate text in cell
  220. Help please
  221. Copying Tick Boxes
  222. Assigning scores to a date range
  223. conditional formating: dates
  224. Using cell information in formula?
  225. How to do the exact copy of a formula
  226. create a team meeting planner
  227. Ineed help with arrays (I think)
  228. Change case setting from lower to upper with current complete doc
  229. match index?
  230. how to contruct formula
  231. Help I Am Ready To Give Up
  232. If formula using 2 or more columns
  233. Dates
  234. Modifying Cell Addresses and operating on them
  235. Consolidating from Several Workbooks
  236. 3 different discounts help !
  237. excel
  238. Date Range -- Weekly
  239. negative percentage in parenthetical format
  240. formula "next month same day"
  241. Need formula to have date in cell B2 rounded to first of next mont
  242. Date Range
  243. Rankif?
  244. Stumped on Formula
  245. Modify cell size in worksheet
  246. vlookup formula
  247. Rank - Specific match only
  248. How do I change uppercase to proper case in entire worksheet?
  249. Formulas
  250. Remove data from certain rows and place in new row or spreadsheet
  251. advanced filtering
  252. Multiple vlookup arguments
  253. Converting Currency
  254. Lookup function (maybe)
  255. Proper way to enter array formula
  256. sum function not summing???
  257. Help with two formulas
  258. Formuls updating
  259. add rolls automatically at top
  260. Macro
  261. Why do my rows automatically hide in Excel?
  262. date format
  263. Reference the same row from another sheet after inserting a new ro
  264. Macro thing?
  265. Highlight Range - wrong macro, please edit.
  266. Need help with finding duplicate entries
  267. Formula help
  268. insert scrollbar into a cell in Excel
  269. Sort, Copy, Paste..without Autofilter..Anyone???
  270. Conditional Formatting Using If Statement On Opening Of Workbook
  271. Problem with Calculating Worksheets
  272. Array... Sort of...
  273. I've protected a wksht and now I can't tab from column to column
  274. Dealing with worksheet groups
  275. How can I keep my cell borders permanent?
  276. Repeat Macro
  277. assigning macro to toolbar button
  278. Can I link single cells in a spreadsheet to another worksheet?
  279. calculating percentages
  280. Multiple Reference Lookup
  281. conditional sum - number of arguments problem
  282. Unlock formulas and unhide sheets
  283. replace macro?
  284. conditional unlocking of cells
  285. Automatic shading of cells based on dates???
  286. count with 2 conditions for many rows ?
  287. desperate measures
  288. smallest right margin on excel spreadsheet
  289. headache! :) unique_id's
  290. Data Issues
  291. Need help with arrays (I think)
  292. Formula help
  293. grinds
  294. "BVE as text entry"
  295. On Excel what does ##### mean when it is in a cell?
  296. how can I check a worksheet for duplicate entries or numbers?
  297. Finding the average across multiple sheets
  298. How do I add items within the last 12 months?
  299. Can I format a cell to round a number by 50 basis points (0.5)?
  300. Recognizing #N/A
  301. can't make it work, I need help
  302. multiply
  303. Linking one worksheet to another?
  304. Groupings within PivotTables
  305. Make sequential numbers each time sheet is opened
  306. Display Last Entry in Excel
  307. how to average and use sum min and count within one cell
  308. Counting number of incidents of a month
  309. I need a formula: " If this cell is blank, then 0"
  310. Frequency & Time
  311. if statement based on "starts with "
  312. Trend using the same formula as the fill handle does
  313. IF Statement
  314. linking text cells
  315. The "IF" Statement
  316. Array formula
  317. Re: How to count the number of times something occurs within a certain month
  318. Insert a row
  319. Extract Unique entries in a column
  320. Excel Time Sheet - Rounding To Quarter Hours
  321. How to count the number of times something occurs within a certain month
  322. SumIf Problem
  323. How do I compare customer mailing lists?
  324. change first-name-last to last-name-first in a single cell?
  325. Macro to delete pictures ?
  326. can you insert a comment into a protected worksheet?
  327. Project planning with Excel
  328. Adding Multiple low values
  329. Custom Date & Time format
  330. Reset a caption for a Pivot Table
  331. Using the AND function with fractions
  332. enter data into multiple formulas at once
  333. Incremental formula problem
  334. Excel Fourier analysis paramèters ?
  335. Excel Solver
  336. How to sort number with text in large function?
  337. how to extract data based on date
  338. highlight/color cells with specific character inside
  339. Insert menu...Define
  340. SUM returns wrong result
  341. Find Last Row in Column
  342. countif greater/less than argument
  343. loan/lease repayment using IPMT/CUMIPMT
  344. How to set up alarm for cell has entry as date when it expires?
  345. VLOOKUP is very limited
  346. How to insert a value in one cell into many cells
  347. Conditional format numbers
  348. Moved data to new sheet based on list selection
  349. 2 Formulae 1 Cell
  350. vlookup
  351. vlookup
  352. Random Numbers
  353. Large formulas
  354. Date stamp spreadsheet in excel to remind me of completion date
  355. What function do i use?
  356. multiple regression
  357. Points Ranking Formulas
  358. pictures inserted using exceXP do not show when i open using exce
  359. Re: function please
  360. Re: function please
  361. Re: function please
  362. Formula is entered but will not display result
  363. Auto-fill cell based on adjacent cell information..
  364. Help with IF function
  365. sum using multiple criteria across 2 worksheets
  366. advanced filters
  367. conditional counting with Excel
  368. Simplify my life with if...
  369. lookup
  370. Possible to wrap text in combo box?
  371. Shading or Choosing closest
  372. Linking error
  373. only use formula if > than 0
  374. How to find the first nonzero cell in a row
  375. Average Wind Direction
  376. How can I toggle between sheets in Excel without using a mouse?
  377. I can not use the financial formulas.
  378. Indirect reference to another sheet that can be dragged
  379. How to export to fixed width text file?
  380. Footer
  381. Can this be done / how?
  382. Excel Pivot Table errors
  383. Automatic Calendar in excel
  384. How do i set up data validation to only enter yes or no?
  385. DDE Coomand
  386. conditional formatting with numbers and text
  387. 2nd part of formula not working
  388. help with formula
  389. Automatically select empty rows
  390. Difference
  391. Interrupt find and replace
  392. Excel question...
  393. Capture and list data from a column or row
  394. collapsable menu
  395. GetPivotData ???
  396. Excel Trace Formula
  397. if statement with date range
  398. extracting numbers from alphanumeric cells
  399. scanning a table?
  400. how to extract data from a cell in a formula in another cell
  401. concatenate and then execute?
  402. copy named range to powerpoint
  403. Aligning similar rows
  404. Array Formulas for Geometric Standard Deviation and Sharpe
  405. named range with filter
  406. copying dynamic size to ms powerpoint
  407. wildcard in sumproduct?
  408. Links to other Workbooks lost
  409. cannot load Excel 2002 Analysis ToolPak add-in
  410. Correlation Tables -- Setup
  411. difference betwwen two dates in days
  412. RETURN TO C
  413. Conditional drop-down lists
  414. monte carlo simulation
  415. Split one cell into many
  416. Pivot tables and Standard Deviation
  417. Only need to PivotChart to show one or two data fields (not all of them)
  418. "Array" problem?
  419. Write once cells
  420. I don't have a List option in the Data menu
  421. You should design a way of doing algebra calculus on a computer
  422. create a macro to save excel sheet
  423. How can I double space in Excel w/o going2 each indiviudal cell?
  424. Function problem
  425. excel array formula
  426. Worksheet Tabs
  427. Random Selection
  428. HOW DO I COPY THE LAST NON BLANK CELL IN A COLUMN
  429. EXCEL FORMS CHECKBOX
  430. Combining mutiple columns into one column
  431. Can I add equation editior to my toolbar in EXCel as an icon?
  432. apply changes to all sheets
  433. How to concatenate adjacent cells in a range without using &?
  434. PRINT IF in VBA
  435. Ping Chip Pearson
  436. sum in colors
  437. Calculating average scores from multiple sheets' information
  438. Move data from one sheet to another using drop down lists.
  439. Clearing #VALUE
  440. payroll system
  441. Sending Info
  442. Lookup: Multiple Occurances
  443. Solver help-advertising problem
  444. Set up: automatically send data to another XL sheet (invoicing)
  445. Create A List From A List
  446. Trying to copy text from 4 columns into 1 column with HTML?
  447. Hide formula
  448. How do I find the amount of hours between 6:00 PM to 12:30 AM?
  449. How do I convert 8:30 to 8.5 hours?
  450. Eliminating every 25th row
  451. Parsing a alpha character out of a cell
  452. Need the cell to show blank
  453. Vlookup with function in table_array
  454. Lists in 2003
  455. SUM
  456. Printdate
  457. Drop down list
  458. Can a formula be used in the Criteria field of SUMIF??
  459. How to use #AND# in an if or sumif
  460. Xyz(--(
  461. date problem
  462. Why #Name??
  463. Sigma Function?
  464. Vlookup Help needed ASAP
  465. what is a dumb or smart formula
  466. pivot table created from another pivot table
  467. String Extraction...
  468. Pivot - need to recount based on results
  469. sports draw
  470. sports draw
  471. Analysis Toopak
  472. My cell formula is generating an unwanted e-mail message.
  473. Sheet Protection
  474. Find first numeric value in text string
  475. large formula question - Max nested functions
  476. Is there a way to count higher than 511 in binary in excel?
  477. =cell("filename",a1)
  478. Summarize times in a pivot table
  479. What is the formula to display a negative time results?
  480. PROPER function
  481. Array
  482. New custom % formats are only in XL file they are set up in. WHY?
  483. Lock Columns and Hide Formula's
  484. Pivot Tables
  485. Formating a cell conditionaly
  486. How do I capture a text cell as a value to be able to sum?
  487. How do I only get valid "answers" in a VLOOKUP function (no #N/A's
  488. Linking multiple worksheets
  489. creating a function with multiple criteria
  490. Need info pulled from worksheet
  491. Replacing spaces in text, with another character
  492. Find the first value in a row and sum n columns
  493. VBA Code - NAME SEVERAL VARIABLE cells
  494. excel formula
  495. Multiple CountIf Criteria
  496. Sort a column (specifically email data) by end of text, not beginn
  497. trying to match more than 1 text value in a row to show end value
  498. Export data saving page set ups
  499. Problem with updating links in Excel 2003
  500. create a formula in excel to prevnt negative
  501. highlighting cells with cursor
  502. Problem with updating links in Excel 2003
  503. copied formula has correct cell reference, but result of original
  504. Keep formula from changing?
  505. Can you match records from two different worksheets
  506. How:iserror vlookup & count no. times value shows with conditions
  507. Reversing rows of information
  508. Subtotal
  509. formatting numbers beginning with zero
  510. Copy shortcut causes error
  511. Formula for Returning values in another spreadsheet
  512. Need open ended cell for Sum range.
  513. Problems with an If function
  514. IF positive/If negative????
  515. formula's
  516. How do I look up a number within a string of text
  517. find Row
  518. input value from weight scales
  519. Compare parts of two sheets
  520. Choosing Data and skipping other
  521. Hyperlink to Excel Chart tab
  522. vlookup??
  523. need some tips!
  524. formula: First and last day in month
  525. First and last entry
  526. problem with summing
  527. Countif array formula
  528. Print more then one page in excel from a word object
  529. Make invoice take items off stocklist in excel workbook
  530. SKIPPING A COLUMN
  531. NEED A COST SHEET TO TRACK TIME AND BUDGET -CONTRACTOR
  532. form that calls hidden worksheets
  533. How do I find value of "x" (col A) when I know "f(x)" (B)?
  534. If condition is true return sumproduct of two arrays
  535. What is the formula to reference a cell in a different worksheet?
  536. number formats after concatenate
  537. Name a Range - Macro
  538. RE: If condition is true return sumproduct of two arrays
  539. RE: How do I find value of "x" (col A) when I know "f(x)" (B)?
  540. function help
  541. formula help
  542. How to change cell colour, X no days from inserted date in Excel?
  543. referencing Excel sheet name in cell
  544. Search multiple worksheets
  545. auto working week-ending date for timesheet
  546. RE: number formats after concatenate
  547. Algebra
  548. remove " $ " from formula
  549. show page breaks
  550. Shades of Gray
  551. Enable macros?
  552. Please help, i need a fomula
  553. How do I count the # of unique occurences of a text in a column?
  554. UDF Raising an error
  555. Excel formula
  556. Removing errant apostrophes
  557. compute insulin doseage with carb consumed & BS readings
  558. Add "left align across selection" cell formatting
  559. Automating hyperlink creation
  560. Bowling Game
  561. Linking worksheets
  562. HOW DO MATCH AND ELIMINATE AMOUNTS IN TWO COLUMNS IN EXCEL
  563. SUMIF with rows and columns
  564. linking file equation...
  565. Spliting the contents of a cell to other cells
  566. SumIf in Visible Cell Range
  567. Updating links monthly...
  568. remove a year from date value in mulitple cells
  569. Excel help
  570. Is there such worksheet functions...
  571. Color Change
  572. Define Name in active cell
  573. Missing Sheet Tabs
  574. How do I add increment a text field value?
  575. Unable to access Internet from Excel
  576. Rank
  577. Trouble copying worksheets between books - is there size limit?
  578. IF formula problem
  579. EXCEL Sum column based on time range in different column?
  580. Limit the number of characters that a cell contains
  581. How do I link to other worksheets
  582. Return Sundays date of current week
  583. Cell Content Greater than 24 Characters.
  584. Excel Formula
  585. what is the max number of factors in Linest function
  586. Loading Column Data with blank Rows into Data Validation Box
  587. how to count records in a sorted list
  588. In excel I wish to copy the value from a cell.
  589. Time conversion
  590. Using a UNC
  591. How to see columns from which values were not returned by HLOOKUP functions?
  592. Updating different worksheet with value on current worksheet
  593. vlookup gives me a #N/A
  594. copy and paste hidden rows
  595. format cells for currency 2450 and have it format to $24.50?
  596. Median ignoring Zero Values
  597. Compare Two Data Files
  598. Combined VLOOKUP AND BETWEEN FUNCTION
  599. formula for putting points into groups
  600. How do I set up a conditional function in Excel
  601. highlight/unhighlight (or color/uncolor) cells containing a specific character
  602. How do I centre rows top to bottom?
  603. How to replace a function with its resulting reference in a formula?
  604. vlookup with more than number to be retrieved
  605. VLOOKUP not returning correct value
  606. Subtotal function for hidden row
  607. Date Count
  608. How to replace a function with its result or resulting reference in a formula?
  609. Two columns
  610. Asking for user input if there is no data for the function
  611. How to change column letters to correct ones in many formulas automatically?
  612. get all row nos
  613. Workbook Sharing
  614. vlookup returning multiple values
  615. combining countif with AND function
  616. Days Within Months
  617. Compound array question - what am I doing wrong?
  618. How do i lengthen an existing VLOOKUP table array?
  619. Trying to plot two lines onto a single graph in excel
  620. formula that gives me a random number less than other number
  621. Value_If_true - Question
  622. Relative Ranges in excel macro
  623. Excel and ranges
  624. Can Solver solve this?
  625. IF (table)
  626. Match Each Numeric occurrence and Return Individual Rows of Data
  627. Using MAX with OFFSET and MATCH
  628. Help .... sum function
  629. SUMIF
  630. Can a macro erase it's self after a set criteria?
  631. how to delete duplicated content from 2 cells
  632. sumif with or
  633. Sorting not getting what I want
  634. How do you count (not sum) cells containing special formatting?
  635. How do I NOT round off in a formula
  636. Format cell window size
  637. prtect linked worksheet
  638. Combine multiple cells into one cell range.
  639. Integrations/differentiations in Excel?
  640. how do i automatically change the day and date
  641. IF function....testing against values in multiple cells
  642. Percentage of amounts and profits of individual sales
  643. Need a formula that finds the last used cell in a range
  644. how can i stop excel from automatically creating copies of workbo.
  645. Convert Formula Result
  646. identify duplicate enteries
  647. Link in the same w/s is pulling a different number.
  648. Multiply one value by many factors
  649. INDIRECT.EXT problem with missing worksheets
  650. =IF
  651. Compounding payments
  652. Multiple Columns & VLookup??
  653. Multiple Column AutoFiltering
  654. DUPLICATE VALUES
  655. Transpose Color Formatting to Seperate Worksheet
  656. Countif ?
  657. Create Excel Log automatically from Template
  658. preserving format in a formula
  659. Paste Special - All but formulas
  660. how do I convert a number to number of years, months and days
  661. IF function and speech recognition
  662. Advanced Transposing?
  663. How do I share my auto correct file with other users?
  664. Check for duplicates in excel file
  665. finding values and displaying adjacent values
  666. How to make LOOKUP give zero if it can't find the lookup_value?
  667. autosum on the taskbar?
  668. Does Ctrl + F works in protected file with formulas?
  669. Negative Number put in a certain column in a different sheet.
  670. Date-orientated update of cells in different spreadsheets
  671. Finding MACROs and FUNCTIONs
  672. Formula for "highlighting" data
  673. How do I download a personal blank wage deduction sheet
  674. Get Vlookup to look at multiple Rows for the answer
  675. How to replace column letter in refferences with a function using the old column letter?
  676. Crystal & Excel
  677. how can I extend the condictional format to nine conditions?
  678. Sum function which ignores hidden rows
  679. ctrl+F in Excel 2003
  680. Adjusting prizes to cater for ties
  681. Counting the number of formulas on a sheet
  682. VB Script in Ecell
  683. Filtering numbers????
  684. PrintDate "as in MS Word"
  685. Excel function same description but different result
  686. How do I create a worksheet function for polynomial data fit
  687. Formula Help
  688. Simple Question
  689. Excel macro to multiply by same value
  690. look up formula
  691. selecting data from a list box
  692. Formula to capture data on a date and preserve it
  693. function
  694. HOW DO I MOVE ONE ROW TO ANOTHER PAGE USING A FORMULA.
  695. If(and spread sheet syntax
  696. Hide (limit viewers) to column(s) on a protected worksheet.
  697. MEDIAN() as array function?
  698. Hour() function
  699. Can I group data on different rows together and then sort the grou
  700. Text size in validation drop-down list box
  701. Using Auto Filter
  702. Removing a FIXED Function
  703. Can I email a single sheet in a workbook?
  704. Easier Way?
  705. Excel Math Wizards
  706. If correct, add 1
  707. reformat columns to rows?
  708. Pivot Sort ???
  709. Custom number format - Accounting
  710. List Box Multi Select Option
  711. Cell Fomula
  712. An icon on the forms toolbar is unavailable?
  713. How do I concactinate two columns of digits?
  714. HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT
  715. How can I use a circular function to add 4 to a column of cells?
  716. Blank field formatted as date
  717. In Excel allow freeze pane in any column plus any row
  718. need to calculate time multiplied
  719. assign value to text
  720. Making Array Formula, please assist!
  721. HELP!!
  722. How do I change numbers from positive to negitive
  723. Excel expression {=SUm(if(istext(c8:k8),1,0))}
  724. Drop data from workbook after specified time
  725. Schedule/Date Calculation
  726. Can I search the whole workbook and not just a sheet?
  727. Limit on number of conditions?
  728. Excel - matching data
  729. auto row insert
  730. Formula chooser?
  731. Calculating the maximum value in a range of cells in a closed work
  732. Copying a column to a new sheet so that cells match.
  733. How to select cells (located in a column) for formulas in a row automatically?
  734. Unique Value without using FILTER
  735. Compare Side by Side with 3 simulatanous sheets scrolling
  736. Converting decimals into hh:mm
  737. return a range of cells from a vertical lookup
  738. Multiple protections
  739. Defined Named cells lined to a Function Procedure
  740. Calculate difference (mins) between 2 Times
  741. another sumproduct question
  742. Excel should be able to map which cells reference each other.
  743. How do I search for specific text and sum the cell to the right?
  744. Date entry gone haywire in Excel!
  745. Wroking with rounded or trunc calculation
  746. Countif a small or capital letter
  747. Index/Match question Need help!
  748. LOOKUP question
  749. Scrolling Cells
  750. Help, how to find a range of data?
  751. Bonuses and Penalties in Grade Books
  752. Re: Average Grades and drop the lowest score
  753. How do I keep the zeros in front of numbers when i split a cell
  754. cannot open files
  755. "Cannot empty Clipboard"
  756. How do I use a range of numbers in an if statement?
  757. About User Defined Functions
  758. How do I "show pages" in pivot tables in Excel 2002
  759. Getting a running total?
  760. RE: Countif function for instances of text string contained
  761. Countif function for instances of text string contained
  762. calculate using rolling calendar
  763. Return a cell value based on specific combinations of cells in an array
  764. .csv file - excel 2003
  765. outline & groups
  766. Lookup Functions
  767. sumproduct?
  768. Find duplicates and append
  769. INT Function
  770. populating multiple cells
  771. Using scientific notation in TEXT() function
  772. how can I make a form number change everytime the form is opened
  773. Distributing values from rows to columns for Access import
  774. sequential numbering of copies printed
  775. Sorting columns
  776. Populate multiple columns
  777. Please help!
  778. HELPPPP!!!!!
  779. need a roster that 3 kids can work to day by day?
  780. Drop down to diplay info from another sheet
  781. ROUNDUP copy/paste and fill handle not working
  782. between - function?
  783. Change formula to Indirect
  784. compare two groups of data
  785. Is there a function to consolidate multiple records into one recor
  786. If statement w/ rounding but not all numbers
  787. 3D Arrays
  788. Dynamic range for Table_array in a VLOOKUP.
  789. Lookup Hi / Lo
  790. distribution of durations
  791. User Group Meeting Ideas
  792. How do I move information between worksheets?
  793. Convert Numbers to Text
  794. Mulitplie workbooks - known duplicate records - need to consolidat
  795. Complile Error with Date
  796. use range name in formula
  797. grouping and give colours
  798. Sumproduct?
  799. How to use a cell value to reference a worksheet name
  800. Conditional formula - language needed
  801. Why #NAME?
  802. How can I select one checkbox and have it unselect other ones?
  803. for SUMIF function, how do I use 2 sets of range & criteria
  804. Calculating an Activities During Periods Of Natural Months and/or Dates
  805. Grade book average formula
  806. sumproduct , array or countif?
  807. Question about counting recent cells
  808. Adding indicators on a line chart.
  809. Equal to or less than formula
  810. SUM C IF B=Cap... Till Next B=Cap...
  811. Problem with IF function
  812. SUM C IF B=Cap...TILL NEXT B=Cap...
  813. Help with using the IF and Mid functions
  814. Corporated into the same fromula please.
  815. shortcuts in Excel
  816. Range of Worksheets Sum
  817. Create an external reference link with embedded variable
  818. I'm having trouble with my windows, they won't expand full
  819. "Sort" help
  820. How can I format number into thousand?
  821. vlookup does not find data
  822. How can I do a lowess fit in Excel?
  823. GENERATE HYPERLINKS
  824. returning blank cell
  825. Subtotals by month
  826. I need a conditional formula
  827. Sum with 2 criteria
  828. Several function questions (nested functions)
  829. Email worksheet error ".tmp"
  830. How to get pointer in new cell on Open?
  831. calculator Errors
  832. How do I calculate the final pmt required to meet a target IRR?
  833. Cant get totals to work with IF statements
  834. freeze horizontal and vertical panes at the same time in Excel
  835. Can I check if a date falls between a range then sum other # if tr
  836. Condtional Quartile statement
  837. How to use FV function to find a payment to reach a specific goal
  838. How do I get price calculations to always end in 9?
  839. cell text completion
  840. vlookup returns column to the left
  841. How do I sum a range if the date is is greater than today's date?
  842. how do I use Goal Seek in a Pivot Table?
  843. compare two lists
  844. How do I import a list of names into a separate form that prints .
  845. Excel needs to let the user set the sort default to "NO HEADER ROW
  846. How do I convert word data (not in tables) into excel format?
  847. How NOT to extend formula/refrence to a cell
  848. How do I hide the zero in the "sum" cell until numbers are put in the cells that are being added?
  849. file commands
  850. How to copy the hyperlink of a list of cells in another column
  851. How can I display a number as a ratio of x:1 in Excel?
  852. Calculation on SUMIF Results
  853. sum with 2 criteria
  854. Unary + Operator
  855. Time calculations Urgent please help
  856. Transfers
  857. Drop down lists - thanks (and one more query)
  858. sum with 2 criteria
  859. drop down lists
  860. sum with criteria
  861. Need help with formula in Excel XP
  862. logic test
  863. Array formula on Pocket PC
  864. Need Help with a formula
  865. How do I protect formulas in a worksheet and allow data entry
  866. excel worksheet function
  867. feat_funkyeva#7
  868. Highest Score for each Test
  869. Invoice numbers
  870. Compare 2 columns, and create a list of items that are in both lists
  871. create a conditional formula
  872. Can logical formulas be used to build accounts receivable workshe.
  873. Conditional Formatting & Dynamic Range
  874. How to Copy a Password Protected Excel Worksheet
  875. 2 Columns - Show extra items in Column B
  876. elapsed time displayed as a decimal
  877. Help with command buttons
  878. Need help on formulating ordering
  879. using countif in isolated cells not a range
  880. excel help please!!!!!
  881. Use conditional formating to incicate blank cells in excel
  882. counting results of a list
  883. Friends: Please guide me
  884. How do I calculate dates backwards from a project end date
  885. How do I share data in different worksheets?
  886. Grouping
  887. Help with Grouping the numeric data stored in one column.
  888. Pull Down menu's
  889. Find an empty cell and put a dash in it?
  890. Is there a way to determine which cell the function =min() used?
  891. Lotto Number Checker
  892. need help with function and formulas
  893. Can I delete blank rows from excel without selecting them?
  894. I don't know if this is even possible...
  895. SELECT FROM 2 COULMNS + 1 ROW
  896. URGET VLOOKUP HELP!
  897. Assign a Macro feature not showing
  898. Need help with two Bowling Formulas
  899. When I open my past invoice it keeps changing date to todays date
  900. Forecasting Sales using the Forecast Function
  901. Vlookup with multiple criteria
  902. Summing partial strings.
  903. Referencing Sheet Tabs
  904. HOW DO YOU MAKE FORECAST FUNCTION WORK IN EXCEL?
  905. Pull information from a Web page to Excel file
  906. IF Statement W/3 Parameters ?
  907. fitting route numbers to drivers names
  908. How do I Edit Fill Down a Cell Reference to Multiple Worksheets
  909. Using a range as value_if_true in IF function
  910. help with multiple function from drop down box
  911. Multiple Date/Time Formats
  912. LInking problems
  913. How can I "RANK" time in Excel 2003?
  914. Data Forms
  915. IF function
  916. When value is NOT Null
  917. variable in a link where the variable is the name of the sheet
  918. value lookup help
  919. TOOL BARS AND THEIR USAGE
  920. Summing a column of Numbers
  921. IFSum(Vlookup...
  922. macro to compare multiple cells to determine value
  923. Simplify syntax of a Sum(IF... Array
  924. how to count weeks from date "X" then calculate
  925. Help for old macros with Excel 2002
  926. back ground color doesn't work in cell.
  927. How do i make my 'daily report' form into a functional spreadshee.
  928. automatic sequential number on invoice or shippers
  929. IF Statement Question 0 values & blank cells
  930. Conditional Formatting Issues
  931. Cursor Shapes for Excel 2003
  932. How to sort and keep formulas
  933. DateDif Average? Damn DateDif
  934. COUNTIF using Dates
  935. How can I calculate weekly totals of daily data in Excel
  936. COUNTIF across sheets
  937. averaging averages?
  938. how do i unstring text in an excel cell?
  939. Denoting recurring numbers in formulas
  940. Year-to-date year to date formula
  941. Sorting Dates
  942. probably easy but....
  943. How do I use look up function in excel?
  944. NESTED IF STATEMENT
  945. Case Sensitivity problem with data validation
  946. How can I set a input range for entrying data.
  947. Looking up a column value versus another column value
  948. how to do it?
  949. reference a blank cell
  950. Multiple formats for a single cell value.
  951. compare data in the same column on separate worksheets
  952. how do i set up round function
  953. Formatting minutes and seconds to calculate a total average
  954. COUNTIF - everything excluding a string
  955. How to open up 50 text files in 1 worksheet in fewest moves?
  956. advanced: synchronizing data value across two worksheet drop boxes
  957. Add-ins function in Excel 2003
  958. I need to input daily cost codes would exceli calculate my totals
  959. Splitting Cell Contents with a comma
  960. how to count the number of text frequencies and copy to other cell
  961. Matrix Multiplication
  962. HOW DO YOU SUMIF THE NUMBER IS GREATER THAN BUT LESS THAN A #
  963. combine multiple worksheets & files into 1
  964. Summing Columns
  965. Joining letters from different cells
  966. Lookup and Reference
  967. ALT+ENTER IN A FUNCTION
  968. Change Text Case
  969. weird problem with LOOKUP function
  970. Multiple Criteria in SumProduct, N/A Result
  971. deleting hidden rows so i can print only the rows showing??????
  972. Links to other workbooks
  973. how to use networkdays returning fractions of days (4.3 days)
  974. Define a range containing the first 10 rows of a filtered list
  975. Too difficult for me, please help.
  976. Help with getting text from "Merged Cell"
  977. Importing a part of a big comma delimited csv-file
  978. How do I delete every seventh row?
  979. limkning images
  980. Update a formula based on date worksheet was saved
  981. Sharing Worksheet cannot complete task
  982. vLookup ... help please
  983. sumif based on vlookup array
  984. Not all data in AutoFilter pull down
  985. Delete row wise duplicates & colomun wise simultaneously excel
  986. How to calculate loan instalment daily rest
  987. Why is my formula appearing in the cell not the value?
  988. How to change text format .126 to number format 0.126 ?
  989. Automatically updating Graphs
  990. challenging question
  991. Automatically Converting Formula in a Cell to its Value at the End of the Day
  992. Excel and VB
  993. IF ...only it would work
  994. how to apply template in excel ? or can I create a autoformat in e
  995. Lookup in raw and column concurrently
  996. Help on creating a linked workbook.
  997. Surely a simple solution exists
  998. forecast production
  999. Create a list range
  1000. Evaluating multiple ranges for a count function