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. count number of instances a number occurs
  2. Better performance Vlookup or Index/Match?
  3. Delete unprotected cells in protected worksheet
  4. How to use the IF Function for 3 conditions
  5. Round to the nearest minute if more than 6 seconds
  6. Look up for a value in a s et of ranges
  7. Find duplicate, but only if an adjacent cell is identical
  8. can assign a picture to a cell ?
  9. Fill color with if function
  10. Names and addresses
  11. Import from Text dropping rows from .csv
  12. 1st sheet
  13. find and Summarize data in a table from a different sheet?
  14. Excel conditional sum
  15. Previous visible cell
  16. SumProduct?
  17. Function indicating a row have empty value on several columns
  18. Order of columns in Workbook Connections
  19. two variables to get result
  20. Macros in Excel
  21. sorting problem.
  22. display.. help
  23. Simple problem with Dates and Times is driving me nuts
  24. when I enter a number, only ###### shows?
  25. lookup and display
  26. How can I get DGET to return all records that meet the criteria?
  27. Make cell contents blank upon opening worksheet
  28. cell reference formula
  29. Calculating the value of a cell from another cell
  30. IF and ISBLANK
  31. Pivot Table with source spread across multiple worksheets
  32. Rolling Monthly Average
  33. Display row of the maximum in a list
  34. index(match) Wind Uplift Calculations (match four conditions)
  35. How to Change Column Header from numbers back to letters
  36. average formula
  37. How to Combine Cells using Other Cell
  38. Filter by Date of Birth
  39. Condensing a list with duplicates to a list with non-duplicates
  40. Short Way to Calculate Salary Increases
  41. How do I automatically delete a row, if one cell equals zero?
  42. count if with multiple criteria
  43. How can I filter just 2 columns (separated by another column)?
  44. Vacation Tracking
  45. What would I set up this formula
  46. #VALUE! error message in simple sum function
  47. Hyperlinking to Excel and the resulting cell shading displayed.
  48. How do I use the SumIF function with a criteria of a cell color?
  49. Sumproduct
  50. Autofilter with pivot table
  51. XL2002 - VLOOKUP with variable Sheet Name
  52. find the cells that represent a code in one cell
  53. How to clear data in pivot table?
  54. IF function
  55. How can I calculate total spend on items that have different values
  56. "IF" Condition
  57. Counting Records Between Two Dates
  58. Exporting list from Excel to PP, I want a new slide for each cell
  59. Summing between two dates
  60. MATCH working but not....
  61. how to make a cell mandatory in the excel sheet
  62. Functions for inventory
  63. 2008 East Coast US Excel User Conference
  64. How to check if a date falls within a range(2 cells: Start/End Dat
  65. If with multiple or
  66. Excel not correctly calculating formula
  67. Lastrow
  68. if val in col3 is one of 13 codes (list), apply factor to val in c
  69. Lookup Function Not in Ascending Order
  70. Is it possible to filter using row height in Excel
  71. convert US dates to UK dates
  72. Multiple Data Validation
  73. RE: Apply a percentage factor to a base number
  74. RE: Apply a percentage factor to a base number
  75. sumproduct help.
  76. Regarding Formula for Date and time
  77. Copy & paste block of text number of times equal to value in cell
  78. displaying the correct value.
  79. Adding sums from different worksheets
  80. Lookup Formula Question
  81. Lowest two values
  82. MS Excel 2007
  83. Formula being replaced by =#N/A
  84. HELP linking access table to excel
  85. Need to report a count that meets multiple criteria.
  86. How do I use a variable as a reference to an array in INDEX
  87. Still need help with IF and Count Function
  88. If then else
  89. Converting entered data into a different output
  90. Count if problems
  91. Creating a data entry form in excel
  92. Creating a data entry form in excel
  93. Excel worksheets
  94. How do I format cells as custom and keep text formatting?
  95. How to use the IF function to resolved more than one creteria
  96. excel 2007 formulas
  97. If Statement On Two Conditions
  98. How do I uncheck numerous Excel2003 form toolbar check boxes?
  99. tracing precedents
  100. Write a formula using two arrays, across two worksheets
  101. Deleting/Sorting
  102. SUMIF
  103. Problem with IF Statement
  104. How to combine two columns into a new column
  105. Conditional Formatting in Excel 2007
  106. Ignore blank cells when calculating date for If, Then function
  107. File Conversion - why does this appear when I open excell wk book
  108. how to delete continously data
  109. VLOOKUP()
  110. Not allow data to be entered beyond a specified row.
  111. Help required
  112. Search for data and return cell reference
  113. Lookup automatically specified arrays
  114. lookup or vlookup
  115. Sums - D4 MINUS D3 EQUALS D5
  116. Using auto filter after my worksheet is protected
  117. Calculate the time difference excluding weekends and out of businesshours ( i.e. 8AM - 5 PM)
  118. Different password for different worksheet
  119. How we convert number in to word
  120. all dates in a column have gone back four years
  121. Password
  122. hlookup
  123. Vlookup with multiple corresponding values
  124. Data List Header Row
  125. Exporting data
  126. Report Function
  127. Multiple If Statements in the same cell
  128. Adding Rows
  129. ACREDITE FUNCIONA!!!!!
  130. Drop down lists to transfer data between worksheets
  131. protecting worksheets
  132. Find & Replace - Limit search to a specific column
  133. file names
  134. Re: AVERAGEIF
  135. Freezing Panes
  136. Break a forgotten worksheet password
  137. Freeze a title only
  138. capturing all of the data
  139. Vlookup (pickup the last row...
  140. Formula
  141. finding out denominations.!
  142. Need help creating formula for given data
  143. WORKDAY() results appear to be inconsistent...
  144. How do I copy a VLOOKUP into a column and keep a constant array?
  145. Formula Not Working
  146. difference between exel 2003 and 2007
  147. discounted cash flow analysis
  148. Formula for Adding cells up
  149. TABBING BETWEEN PARTICULAR CELLS
  150. Formula for multiple cells
  151. Formula for multiple cells
  152. Alphanumeric
  153. Need Help on formal - output a sum
  154. Replacing ISERROR Formula
  155. Variable named range in worksheet function
  156. Msnstockquote
  157. INDEX using range
  158. Excel Script to Auto pick next
  159. Formula greater than
  160. Trying to get work days out of two dates
  161. Caps formular please help
  162. Need help with formulas
  163. Get External Data - Missing last row
  164. ANOVA with two factors
  165. Re: Lookup MIN Date
  166. Seperate Cell contenets in to different columns on basis of leadingspaces
  167. Lookup MIN Date
  168. Multiple Conditonal Comparison
  169. Cell Paste using cell link option Half works
  170. Moving linked data and retaining link
  171. Total rows allowed on spreadsheet 2007 version
  172. remove #n/a from the columnI've used a function
  173. Linked sheets, blank cells and adding new rows
  174. VLOOKUP for multiple colums
  175. Excel Help: tracing formulas between cells within workbopok
  176. Using Countif with multiple worksheets
  177. Multiple Lookups in one Cell
  178. Need something other than IF function
  179. Associating a STATE or TIME with a phone number
  180. Date Question
  181. Logical if more than 7
  182. Counting the ones, twos and threes - Please Help
  183. vlookup() function
  184. Excel Spreadsheet
  185. Auto Sum entries in a cell
  186. Shared Document & Hyperlinks
  187. large amount of data moving to excel
  188. EXCEL 2007 Worksheet expanding to maximum size unwanted
  189. new to excel need help with function
  190. HOW CAN I MERGE MULTIBLE SHEETS TO 1 SHEET
  191. linking a jpeg file to an excel cell
  192. Create a time-tracking sheet in Excel
  193. Simplification of IF Statement
  194. create a summary sheet
  195. Enter a value in wks1-Find that value on wks2-Auto fill cells in w
  196. alphabetize ignoring hyphen
  197. Calculating present age if date of birth is given.
  198. just wondering, do they have smthing called XMIRR
  199. Excel 2007 lookup problem continuing ...
  200. getting list of files
  201. Remove dashes from phone numbers in a spreadsheet
  202. Use Len and Left to make name 3 letters
  203. How to ID numbers in Excel sheet that add up to specific sum?
  204. How to use LEN & LEFT on last name to show only 3 letters
  205. using error type and if statement to return a value.
  206. MODE - Second most frequent value
  207. Average if and networkdays
  208. COUNTIF
  209. Using IF and date ranges
  210. Function choice
  211. If and Date Ranges
  212. DATA VALIDATION
  213. how to make an IF function that has the same result as COUNTIF?
  214. VLOOKUP
  215. need help with sumif function
  216. can i create formula to make cell PLURAL if other cell is >1?
  217. ?Advanced? Hyperlinking
  218. setting multiple conditions in one cell
  219. Filtering
  220. Hyperlink option is greyed out
  221. excel won't save the border lines
  222. =COUNTIF & how to make it apply to consecutive cells
  223. How to dealing with functions with 30+ variables?
  224. excel text formula does not calculate after editing
  225. How do I create a table on a new worksheet from other worksheet da
  226. Color coding cells
  227. Linking appointment dates
  228. have date show in cell when only entering numbers
  229. Macro to copy an image (or picture) from one workbook to a new sheetin another workbook
  230. Look up Function
  231. Scroll Bar Disappears
  232. Excel 2000
  233. column reference in an Excel spreadsheet
  234. Inserting data into next blank cell down in next sheet
  235. Sales mark up formula
  236. Query: Automatically transfer complete rows?
  237. Summary help!
  238. Counting Empty Dates within a Range?
  239. How to conditional format columns in a range based on
  240. SORTING CELLS
  241. Countif numbers fall between two values
  242. Graph and updating
  243. INDIRECT reference to another worksheet in same workbook
  244. how to extract caracters up to comma in excel cell
  245. Cell references in SUMIF formulas
  246. formulae corruption in excel
  247. Need help ( Hope i made it clear this time)
  248. VBE Error (Project unviewable)
  249. drag across multiple data sets
  250. Cannot insert worksheet in exel - not available in insert menu
  251. sumproduct _zafar
  252. sumproduct_zafar
  253. Hiii - Please help
  254. calculating Leave
  255. EXCEL - COUNT help
  256. Excel 2007 Autofilter vs Excel 2003
  257. return values in the table with multiple conditions
  258. CREATING FORMULA IN ONE WORKSHEET BASED ON MULTIPLE CRITERIA IN AN
  259. Nested Forecast Formula Help
  260. Cell Underline problem underlines across width of cell
  261. Convert int ccyymmdd to date(time)
  262. Date Calculations
  263. Getting a Count
  264. assigning grades
  265. perfoming ANOVA test
  266. How do I delete the refernce a formula when copying and pasting?
  267. Using SUMIF with RIGHT()
  268. How do I intergrate lines added so they follow in descending order
  269. Get rid of $ signs in formulas
  270. NON SEQUENTIAL DATE RANGES
  271. Re: Changing worksheet reference in a VLOOKUP
  272. Calculating dates of holidays
  273. MACRO for Matching Two List
  274. Protected Workbook, no comments?
  275. Create macro with button in excel spreadsheet
  276. Excel Function - Date evaluation
  277. Help with combining lists
  278. if statement syntax help
  279. Generate list
  280. Pivot Table data
  281. Conditional Sum of cells
  282. Separating Strings
  283. change formula in a shared worksheet without losing change history
  284. Printing with ""
  285. Expansion of COUNT if Question
  286. Adding duplicates...
  287. Insert Graphics File into Worksheet via Formula
  288. correct formula
  289. calculate percentage of numbers <= zero in a given range
  290. how to change formula in shared sheet without loss of change histo
  291. Vlookup on Dates
  292. Extracting data from Outlook to Excel using VBA
  293. Annual Leave automatic calculation
  294. IF
  295. How to Create Macro to Increase Cell Value to one and Print Worksheet
  296. how do I set up or adjust my column chart?
  297. Pivot Table Question
  298. MCONCAT
  299. Use tab name in Vlook Up
  300. Entering changing months with a cell
  301. I have year based data want to convert into weekly basis
  302. why do I lose cell format in a pivot table?
  303. Replace mutiply sign *
  304. Adding a sort to a working query asks for a parameter value
  305. sumproduct_zafar
  306. print range is gray and i cannot change
  307. Date Calculation in Conditional Formatting
  308. Removing Digit Separator
  309. Excel filtering of split panes
  310. unhiding formulas
  311. Concatenate a formula
  312. certain time
  313. format a right justified zero filled field to a prn file
  314. Collapse/Expand Buttons in a Pivot Table
  315. Multiples conditions in an array
  316. COLUMN & ROW EQUAL
  317. Question about Comparing Data
  318. Re: month text in calculation
  319. Re: month text in calculation
  320. RE: Combine 6 Worksheets to 1 Worksheet with total amounts
  321. I think I know how to ask this sumproduct question now:
  322. Formulae stop working
  323. IF function, nested with 2 source cells?
  324. Comment insert
  325. Remove Rows That Are NOT Duplicates
  326. counta
  327. invalid reference for vlookup
  328. Really large files, not sure why
  329. Case Sensitivity in Lookup Functions
  330. How to count for 3 columns
  331. VLOOKUP Question - Can I Keep the Same Aray with Drag?
  332. define name with 2 lists
  333. How to use a range name in a macro
  334. Copies From The Internet
  335. Change tracking in Excel
  336. Data Validation Question
  337. "A pivot table report cannot overlap another pivot table report"
  338. Nested if using range names
  339. Dates - Custom - Pos Pay Format
  340. Conditional Hyperlinking
  341. match, lookup two column data
  342. Copy Paste filtered column ok in 2003 not in 2007
  343. append column data
  344. Pos Pay
  345. How do I copy cells containing drop downs?
  346. Conditional Format - Hide/Unhide
  347. Retain font/cell color on lookup/copy
  348. POSTIVE PAY FILE FORMAT
  349. How best to use sumproduct instead of conditional sum:
  350. How do I copy specific information from a master sheet?
  351. Conditional Formatting Question
  352. =If(A1:D1="Pass","Y","N")
  353. Which functions do I use
  354. 3D References
  355. use source formatting with protected worksheet
  356. formulas
  357. VLOOKUP? SUMPRODUCT? not sure how to do this
  358. why do I get an error message when i try to merge cells?
  359. The hyperlink reference doesn't changes when I insert Rows and co.
  360. If, Lookup, Match or a combination of all
  361. Linking formulas between several woorkbooks
  362. I want help to fill data of sheet 2 in sheet 1
  363. Combining data from 2 sheets - advanced help please
  364. How do I compare two columns and return a number count
  365. EXCEL Formula Microsoft Product ID
  366. MATCH not working in IF statement
  367. convert feet & inches to decimals
  368. Pivot Table
  369. Autofill reference formula but repeating n times before incrementi
  370. IF Function Question
  371. Make a cell not equal less than a certain number
  372. Cell on Cell interaction help
  373. Excel 2007 Lookup
  374. TRUE/FALSE function in IF statement
  375. conditional formatting #
  376. Multiple if statements based on two columns of information
  377. Conditional Formatting
  378. Row reference formula not working with a VLookup
  379. Mid Statements
  380. Search/Match/Find ANY part of string to ANY part of Cell Value
  381. grouping cells
  382. NOTES FOR A CELL
  383. [XL07] Conditionally format fill color for entire row
  384. How do I export report and have info appear on 1 line?
  385. compare cells in column to criteria, then average next column cell
  386. If and/or Look Up function
  387. rounding problems
  388. Prevent alpha character from being entered into a numeric field
  389. VBA Help
  390. Help with Functions (IF)
  391. rounding problems
  392. Max function
  393. Filling speadsheet with INDIRECT functions?
  394. Purchase Order Form
  395. Vlookup based on 2 criteria
  396. Cells linked to another workbook with a formula.
  397. Index, Large and Match??
  398. Lotus 123 has a function called "rvbalance", does excel have?
  399. Long If Statement
  400. SumProduct Question
  401. Summarizing specific data from one worksheet on another
  402. help text for user defined formula
  403. Multiply with conditions
  404. copy and paste not functioning, think clipboard problem
  405. sumproduct
  406. Count items in range
  407. need help formating a cell
  408. Allocating the numbers from the total
  409. Sorting out negative numbers
  410. Convert Indirect row reference
  411. Lookup Function
  412. Drop down lists and macros
  413. Formula Returning Records # of Days from Today in Excel
  414. Conditional Average
  415. Returning a value based on a query
  416. Sorting columns into a table
  417. Sorting a table on 2 columns
  418. Excel Function
  419. how do I copy automatically from one worksheet to another
  420. RE: Sort
  421. Sorting
  422. RE: Sort
  423. sumproduct with wildcard for text?
  424. Letter Replace Help!!
  425. Sort excel columns as a function
  426. I Need An Argument
  427. Stuck in a Sub Loop
  428. FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLANK CE
  429. To find data
  430. Templates
  431. Any ideas why a reference that works will in 2003 has problems in
  432. Locking cells with formulas
  433. change order of 5 letter word based on another cell containing 5 numbers
  434. Excel mobile help please
  435. Sum Of Last Three Entries In Rotating Columns
  436. can you link an excel workbook to a live word doc
  437. Using IF and MAX functions together
  438. 40 sheets/Formula to advance to next worksheet
  439. separating numbers from text
  440. Want to add help file for custom function but excel 2007 is flaked
  441. Nesting if/or/and
  442. Excel Formulae
  443. Excel Formulae 'Help'
  444. Referencing Checkbox Names
  445. Scoring Formula helop
  446. conversions
  447. No question
  448. Countifs with same reference?
  449. Keyboard shortcut for Paste Special-Values
  450. VLOOKUP Keeps Returning #N/A
  451. Count instances of text in date entries
  452. Explaination of Logical If Then Statement
  453. Average of a difference between 2 cels in a table/array
  454. How do I SUM multiple results from a VLOOKUP?
  455. past cell by date
  456. Sum and If Assistance Please
  457. Counting rows that meet conditions in multiple columns
  458. Add top numbers
  459. Excel 2003 - Copy Down Function to Reference Next Worksheet
  460. LIST OF THE NUMBERS, AND HOW MANY TIMES THEY REPEAT?
  461. Date Function needed
  462. Alpha conditional statements
  463. Excel not converting file
  464. Count functions with multiple conditions/ranges
  465. Analysis Toolpak
  466. Excel - Compare spreadsheets and indicate matched data
  467. Hyperlink an excel spreadsheet to a specific Powerpoint slide
  468. COMBO BOX FOCUS
  469. Sum and If Function Problem with Excel 2007
  470. Sum from a Drop down menu using value in the cell below
  471. Help in formula
  472. Focus on a cell based on date
  473. how to combine Logical if and Vlook up
  474. how to format a complex number
  475. Excel Documents
  476. worksheet functions
  477. =If( statement for 80-90% condition then write "ME"
  478. Columns into 2 way tables
  479. Exact Precedents
  480. Blank date column return datel 00-Jan-00
  481. multiple values in column
  482. Update formula automatically for inventory
  483. Negative time numbers
  484. how to sort addresses in microsoft excel
  485. VLookup is not working correctly
  486. formula based on first two charachters of a cell
  487. emailing active sheet with macro
  488. whats the formula
  489. Hyperlinks
  490. VLOOKUP and HLOOKUP
  491. fixed asset life table
  492. Formula Question
  493. how to get the median of cells that meet a given criteria in excel
  494. Is MSNstockquote only for stocks?
  495. 1 parameter for multiple pivot tables
  496. Cant use indirect() and dynamic ranges together?
  497. Pivot Table, Calculated Field, Running Total
  498. Conditional Formatting on empty cells
  499. Connecting multiple IF THEN formulas in one cell
  500. Formula Help
  501. SUMIF sum range
  502. How do I only pull rows if the data matches a named range?
  503. Advanced sorting
  504. count occurences meeting criteria
  505. Auto updates with checkbox that affects total
  506. help with function/formula
  507. Problem with "Currency Convert to Text"
  508. SEPARAT NUMBERS FROM TEXT
  509. Changing Data Source
  510. Need to remove text with strikethrough - Excel 2007
  511. automatic inserting the values
  512. Aouto filter by macro
  513. Transposing from two dimensional to one dimensional
  514. RANGE addresses. Getting from other cells.
  515. Sliding commission rates in excel
  516. Formula help
  517. How do I insert a work sheet populated with data into another?
  518. Why QUOTIENT function is not being recognized?
  519. What is the math divide funtion in Excell?
  520. Tabs
  521. Using Table Column Data in MATCH
  522. Vlookup or getpivot? two entries
  523. Count cells based on whether another cell is blank or not
  524. semi-interquartile range function?
  525. color change after date
  526. past date cell colour change
  527. Need a formula
  528. Mutually exclusive cells - Excel 2003
  529. blank date shows up as s 1/0/00
  530. Counting a range of cells
  531. HOW TO CREATE AN ARCHITECTURAL NUMBER FORMAT
  532. Question on the countif function and times
  533. How to simplify a L O N G functional argument
  534. Vlookup problem
  535. SORTING WORKSHEETS?
  536. Macro for Edit/Copy/Paste Special
  537. Seeing Linked Information
  538. Min +1
  539. Conditional Formatting: Adding more then 3
  540. Date of worksheet comes out numbers on other linked worksheet
  541. Complex Conditional
  542. Removing a listbox from excel spreadsheet
  543. conditional format equal function
  544. Pivot Table - How to exclude info without showing?
  545. need formula to apply to entire column not just one line
  546. Sumproduct
  547. How do I create macro to add 8 rows at a time?
  548. Sumproduct with If
  549. applying formulas for all sheets selected
  550. Spreadsheet
  551. CHANGE THE HEADER NAME
  552. Selecting the latest date reference
  553. Chronological Numbering
  554. multi-if then formula i think
  555. Non-table look ups
  556. Column hidden and Auto filter
  557. how do I Count number of records beteen two dates- Excell 2007
  558. Can't view all text in a cell
  559. Data Validation - select AcctName and AcctCodes shows
  560. Macro To Make Workbook Demonstrate Itself
  561. How to set the enter key to move every 2 rows instead of one row
  562. Locking Cell through Validation
  563. how to get the answers from 3 conditions
  564. Excel still not recognising equal values
  565. Time query
  566. Count Function
  567. This formula can not work in Excel 2007
  568. Paste Special
  569. How do I automatically put like data into several worksheets?
  570. Multiple Critiera Sum Array - One critiera to be between two numbers
  571. I have a text cell and I want to inport a value into the cell
  572. Hyperlink Function
  573. Custom functions
  574. DATABASE REACHED MAXIMUM SIZE
  575. text in mm:ss to time
  576. Function for grouping range of data
  577. Sum up all up changes and down changes
  578. Combination...SumProduct, Index, Match?
  579. Sum the amount of times a number appears in a column in Excel?
  580. INDEX function
  581. how do I protect a column on a worksheet
  582. Replacing characters with numbers in cells
  583. Finding cells with a value ending in '.0'
  584. PivotTable Grand Total Error using Calculated Field
  585. Conditional formatting to a different cell and it contains a formula
  586. Match and Insert Value
  587. Define fiscal year
  588. excel formating
  589. Display a Date when a cell is Modified
  590. MIN and Year Functions
  591. Paste, Paste Special
  592. IF Formula and multiple formulas
  593. subtracting date/time
  594. Referencing Table Data
  595. can you link a text box to a cell in excel?
  596. IF Formula Error
  597. How do i convert diagonal text into horizontal text
  598. Workdays/Networkdays #Name? Error
  599. Handling cells with multiple data entries
  600. SUM ONLY CELLS INA RANGE THAT ARE NUMBERS
  601. Using the Subtotal function
  602. Anchoring Excel Cells
  603. Check box in Filters
  604. Automatically adjusting chart reference
  605. How do I calculate the mode for a column of text?
  606. Upper to Lowercase in Excel
  607. Pivot Table Help
  608. Combining date and time data
  609. date flexibility
  610. add cells together from different sheets within a workbook
  611. Pivot Table
  612. Cell Background Color
  613. how do i copy a worksheet to another work book
  614. counting two ranges for one criteria
  615. Match forst four letters
  616. Formula Error
  617. If formula error
  618. Mid Function
  619. Looking to replace "dots"
  620. Converting from 12-hour to 24-hour format
  621. Random Sampling - Please Help!
  622. vlookup in pivot table
  623. Using COUNTA for a variable array
  624. 2008 East Coast US Excel User Conference
  625. Re: SUMPRODUCT - Using Month
  626. SUMPRODUCT - Using Month
  627. Total of a specific name
  628. Re: formula alternate column call value
  629. formula alternate column call value
  630. Countif with two conditions
  631. Formula at alternate Cell Values
  632. cell color
  633. Multiple Criteria Lookup Results
  634. DP jog macro.
  635. total a column in which there are sum formula
  636. Auto filter by (ALL) custom from other sheet.
  637. auto populate dates
  638. Command Button Shades annoying
  639. Lookup Need Help fast
  640. Function to Produce a Number Pattern?
  641. Buttons
  642. I need help with an if statement that has more than 7 nested condi
  643. How do I display the result of a function on seperate worksheet e.
  644. Formula question
  645. SUMPRODUCT: dividing the formula of one cell by another.
  646. Extracting Specific Data from one sheet to another.
  647. different phrasing
  648. Creating a formula which would affect multiple cells
  649. Can I copy a field from another spreadsheet based on search?
  650. Vertical lookup of pictures
  651. Compare lists when one column contains multiple entries
  652. Fprced data entry on multiple worksheets
  653. How do I find minimum duplicated values in a range?
  654. Help with a formula
  655. Auto Fill Color Cell
  656. Validation function with helper column
  657. Filtering failed moving on...HELP
  658. Dynamic Scatter Charts
  659. If statements looking for nonblank cells
  660. Sort Chart Values
  661. Dynamic Link to Quickbooks
  662. Find matching values in two different columns
  663. count if unique entries
  664. Count IF
  665. edit data in multiple cells
  666. Sum of continous cell
  667. Counting data in a range
  668. controlling pivot table
  669. Gradient and intercept on data with errors
  670. How can I choose more than one item from list in a form in Excel?
  671. Average time
  672. PERCENTILE exceeding 8191 points
  673. an IF function that can take no action?
  674. Pivot Chart Formating
  675. counting values ignoring duplicates
  676. vlookup not returning a match even when there is one
  677. Subtotalling taking long time to complete
  678. HYPERLINK - Jump to another sheet in the same workbook
  679. countif and sum if if two condition are satisfied
  680. Selecting cells with the mouse
  681. Formulas
  682. How to print entire workbook 9 pages to a sheet?
  683. Histogram bins driving me crazy-please HELP
  684. Need Simple List...Multiple Columns and Multiple Worksheets
  685. vlookup returns wrong answer (off by one row)
  686. clear cell based on text in opposing column
  687. Weekly Totals Based on Dates
  688. how to have auto calc cells be blank unless entry made
  689. Flying Hours
  690. <>= Formula ?
  691. How do you alphabetize street addresses within a column?
  692. Lock or Unlock Range of Cells on Worksheet_Change Event
  693. Auto populate a cell by comparing lists
  694. sum between a range of dates
  695. Extact minutes from text field?
  696. Ranking
  697. how to change font in form contollers
  698. Populate cell range
  699. insert column header in cell below result of max FUNCTION
  700. INDIRECT
  701. Replacing Part of a Cell's Content
  702. Excel Loan Repayment Schedule template.
  703. sumif < date
  704. Document Specific Autocorrection
  705. keep track of phone numbers
  706. spreadsheet to keep track of phone numbers
  707. how to convert number to words
  708. test
  709. Excell Formula
  710. Test_12_07_08
  711. Return to a default state???
  712. keep old cell value and new cell value
  713. >> vlookup refering to a cell to get wookbook name
  714. Need formula to return next Monday's date
  715. Can I Use A Count If Function With A Forward Slash?
  716. VLookup in a form
  717. If statements in Data Validation
  718. Tying names to different values month to month.
  719. Inserting Function blanks adjoioning cell
  720. Calculating values based on selection from a drop-down list in Exc
  721. Finding quantity that falls within a range or Tier
  722. how to count if cell "contains" a word
  723. Multiple calculations within cell? Writing in Excel 2000, using inExcel 2003
  724. circular reference where sumif and vlookup overlap
  725. Average of Day and Time
  726. RE: Multiple pie charts in one printout?
  727. multiple IF formulas
  728. Table help
  729. Copy Info from 1 sheet to another within same workbook
  730. Hiding blank cells within a Pivot Table
  731. Compare and get the best value
  732. conditional formatting or VB
  733. Count Non-Blank Values in a Table but only for a range
  734. Formulas that refer to a cell in the last row
  735. Formula, automation turn red if value exceed a number
  736. Duplicate ramdom sampling
  737. Already exists on the destination workbook
  738. want to automatically skip certain cells when you hit enter
  739. Peak call times/hours
  740. Minutes/seconds not right ( 24 ??? %$@#$%$)
  741. Copy worksheet with named ranges to new workbook and keep names
  742. IF and dates
  743. Push updates from one workbook to others?
  744. match or vlookup function formula help
  745. CONCATENATE within SUMPRODUCT
  746. Refer to a sheet using a cell value
  747. IF function question
  748. how do I convert English (Canadian) dates to English (US) dates
  749. ?????????????????????
  750. TESTING
  751. Look Up two cells
  752. Validation in Field Lists
  753. Printing
  754. Finding Links
  755. Quday001-Conditional Formatting
  756. spreadsheet to keep track of phone numbers
  757. Vlookup in data validation???
  758. Spreadsheet to keep track of phone numbers
  759. copying formulas
  760. Quday-Conditional Formatting
  761. date problem or is it me?
  762. "in" function???
  763. tabs in excel flagged out in webpage NOT
  764. Filtering
  765. HOW CAN I FLAG A CELL IN EXCEL WHEN IT HITS A REORDER LEVEL?
  766. sumif or if or something else????
  767. Date Correction
  768. ideas needed, pls help..
  769. Password in Visual basic editor
  770. Payroll lookup
  771. Two way lookup on a table from user input
  772. Excel time calculation
  773. Can I made a cell reference variable? i.e. =sum(D4:D(4+A2))
  774. Count the Y's in a filtered column that contains Y and N
  775. web query data... missing something
  776. Saving Trace Arrows
  777. how to use my Excel 2003 DTF commands
  778. using vlookup
  779. Lookup function ~ weird is it possible?
  780. Data Validation and combination
  781. I need help with a IF(ISNA with vlookup
  782. Excel, how to edit
  783. Auto filter sort ascending not working while sheet protected
  784. password protected workbook
  785. IF STATEMENT
  786. Replacing a Range of Numbers
  787. adding a round function to an existing formula
  788. Conditinal Formation
  789. Align data in 2 column in the same row if the user id's match
  790. Searching Multiple rows using VLOOKUP with wildcard(*,?) lookup va
  791. leave cells blank until formula applied
  792. move or copy
  793. Counting dates including the beginning date.
  794. Easy to do but cannot remember how!
  795. Formula
  796. Date Formula
  797. How do I force entry in multiple cell ranges in one worksheet
  798. ACCRINTM() function
  799. What does the ! notation mean in excel financial formulas?
  800. Conditional formatting - source data from another sheet
  801. Connecting Graphs to a linked worksheet
  802. Worksheet Linked to graphs
  803. Critical - Converting Single Column Address Data into Multiple Col
  804. FONT COLOUR CHANGE
  805. lookup by multiple parameters
  806. Fill down with references to worksheets
  807. Counting on 2 criteria
  808. Average If - averaging cells based on value of another cell
  809. Data lookup function
  810. how do i get zeros to show after decimal point?
  811. Sumif function
  812. multipying a cell by a percentage
  813. 2 data sets in pivot tables
  814. SUMIF function
  815. =SLOPE(OFFSET(INDEX .... Help please
  816. Date and time stamping with a (macro) button
  817. How to split up text
  818. text outside merge cells despite clicking wrap text
  819. List or colour Cells of results
  820. Format changed when the details in cell changed
  821. More Conditional Formatting
  822. Another LINEST bug
  823. MID and FIND Function for Numbers
  824. is there any automatic colour change function?
  825. seeking help
  826. a little help?
  827. If calculations
  828. Creating a blank cell for a chart to ignore
  829. Cell resizing
  830. Text to columns with date format does not work :(
  831. can't lookup a value to the left of my variable
  832. Date Entered +7, unless another field is greater than 0
  833. Formula Based on the cell its in
  834. If statement error check
  835. Filter Data From Master Sheet Into Other Worksheets
  836. How do retrieve deleted files from excel?
  837. Re: Want to unlink calculations
  838. Test for normality of data
  839. SUM with nested VLOOKUPS - can i make it ignore N/As?
  840. name separation
  841. Finding and Adding
  842. Counting
  843. Actual Language for Nesting criteria
  844. Complex Array sorting issue
  845. Excel Calculation
  846. First Positive on Horizontal Array
  847. VLookup function
  848. Main worksheet to automatically update figures on other worksheets
  849. Finding selected numbers within a master list
  850. Separating Text
  851. the font colour icon in excell 2007 kicks me out of the programme
  852. Formula Display
  853. Excel - Min function over 4 separate cells, but ignoring negatives
  854. Photos
  855. Locking documents in Excel after a template has been created.
  856. EXCEL SHEET
  857. Dropping decimal places whern transfering to AS400?
  858. how do i calculate the average of 30+ cells over multiple workshee
  859. Separate protected worksheets feeding into one control sheet
  860. Makeing a name only show once after i pull a report
  861. Adding rows based on no of rows specified from a given position
  862. exact differnce between 2 dates & time, networkday give round off
  863. Validation in IF string
  864. COPYING FORMULA CONTAINING NAMES... ( 2ND POST)
  865. indirect formula syntax
  866. When saving, Excel prompt me for all worksheet passwords
  867. Enabling Macros
  868. Why I can copy nothing from excel to word or other programme?
  869. Excel Autoformating cells
  870. Its a toughie, not sure if its possible.
  871. What formula should I use?
  872. Selecting a diff. worksheet but same cell references using Validat
  873. Vlookup combined with Hlookup
  874. Moving rows with multiple criteria
  875. Is there an INDIRECT function for a RANGE?
  876. how do I copy and paste a drop down list in excel?
  877. Find a color value
  878. Sum below a specific row
  879. Nested if's and lookup
  880. how to copy excel carriage return to notepad w/out the quotations
  881. Hide a sheet with a variable name
  882. XIRR FUNCTION
  883. WHat is wrong with this formula
  884. Help with multi sheet workbook
  885. Summing same cells in multiple worksheets
  886. Summing same cells in multiple worksheets
  887. separate e-mail for change in name
  888. Help with dates
  889. Need Help with Lookup Formula that Also Puts in Text Where Matchin
  890. Searching Multiple sheets in excel
  891. Hyper link between spread sheets
  892. Excel 2007 nested function
  893. =IF
  894. How to show a whole worksheet on one screen?
  895. Help Me Please -
  896. how do i replace #n/a in a vlookup?
  897. IMPORTING DATA MY NUMBERS ARE NOT READ AS NUMBERS
  898. simple formula
  899. Countif with multiple criteria
  900. How do I use condiftional formatting to indicate a formula?
  901. Protecting select group of worksheets within a workbook
  902. Adding Across WorkSheets
  903. sumif with multiple conditions
  904. LOOKUP Help
  905. search text in other workbooks
  906. Formula for adding 2 worksheets
  907. XIRR Function - large IRRs
  908. Inserting rows automatically.
  909. XIRR Function - #NUM error
  910. Add numbers in a column, but exclude percentages in the same colum
  911. if then statements with calculations
  912. lookup question
  913. #n/a in table data table output
  914. exact differnce between 2 dates & time networkdays give round off
  915. match 2 columns and return value of another
  916. converting hourly values into daily values
  917. Delete duplicates in a row
  918. Code to hide sheets
  919. SUMPRODUCT question
  920. Pivot Tables - Can you just list data and not SUM
  921. VBE to hide sheets "can i share it as well"
  922. How to count zeros and not blank in selected range?
  923. Can you change normal numbers to ordinal numbers ?
  924. Comparing Addresses from 2 different Worksheets
  925. Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr
  926. Multiple Questions about adding different cells
  927. Conditional Formatting for Values in 3 cells
  928. removing duplicate entries in multiple worksheets
  929. Insert Row - Stop Automatic Formula Update
  930. Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...)
  931. OLD PROBLEM without SOLUTION , part ||
  932. Conditional Formatting, Date
  933. SUMPRODUCT AND LEFT
  934. DSUM Criteria - find exact match only
  935. returning calculation based on number
  936. Converting specific text to numbers then sum
  937. Referencing Cells in a Summary page
  938. Calculating totals of material with feet and inches
  939. Random numbers from several ranges
  940. Perform a calculation on same cell across many worksheets
  941. countif from different worksheets
  942. How to count...
  943. mutiple if statements that then compute a value
  944. Columns labeled with numbers not letters
  945. HELP!!! Text count?
  946. Graphs
  947. snf vhn gnfnfnvmfm gfvvfdmcmcmfm gjkvfcvkjbjmm .
  948. converting question; function, formula, or coding?
  949. Countif w/semicolon separated values AND Filter
  950. Linked Lists / Data Validation - Excel 97
  951. combine or if
  952. Error of slope taking into account error of the data points
  953. Differences between Dates
  954. Shared Workbooks
  955. SUMIF FUNCTION
  956. Conditional Formatting - 3 Rules - Excel 2000
  957. Drop Down Lists
  958. Percent Function Help
  959. Dynamic Table
  960. How do I lock the formatting of my worksheet but still add text?
  961. Hide sheets
  962. Still problems with calculation of time
  963. Excel 2007 Conditional Formatting only copies absolute
  964. Months in Excel Chart
  965. Countif w/semicolon separated values
  966. comparing data in different rows
  967. Calculating eligibility dates
  968. Summing across multiple worksheets
  969. Tabela Dinamica
  970. spreadsheet colum combination
  971. VBE "Help"
  972. Excel problem - sumif with multiple parameters
  973. Match Data on different lines
  974. Unwanted Array Formula
  975. Complicated Lookup
  976. Text does not carries Over
  977. vlookup MAYBE???
  978. excel
  979. Searcing foran Excel event fired.
  980. Autopopulate text from multiple tabs into list.
  981. LOOKUP FUNCTION HELP
  982. Counting repeated data in a column
  983. Adding multiple cell totals
  984. Simple cell formating question
  985. Easy way to stack column data?
  986. Multiple value lookups from a table to select & sum data from colu
  987. How do I change date yyyymmdd to a Excel-supported date format?
  988. Latest Result
  989. If formula problem
  990. problems with formating and concatonating time [hours]
  991. formula ending with a letter
  992. Text detector
  993. need formula for finding opposite (trigo)
  994. INDIRECT formula
  995. Trying to work out the difference in 2 cells.
  996. sorting array formula
  997. Run formula automatically
  998. Protecting worksheet
  999. Multiple Criteria to Classify groups
  1000. FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA