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

  1. Image Named Range
  2. RE: count days from a one date to another date
  3. count days from a one date to another date
  4. serial numbers
  5. Conditionl format for 1 cellthat looks at 3 cells.
  6. Count No of Types.
  7. DIV/0 error
  8. x = 1 or a value
  9. Print with hidden rows
  10. How to format text 'exactly' as entered.
  11. Return Blank Cell in case of false If
  12. Again printing with hidden rows
  13. Copy paste non merged to merged cells
  14. Copy non merged to merged cells
  15. Find and Replace with formated data
  16. Charts don't copy with new sheet
  17. COUNTIF with multiple criteria
  18. how do i default a footer in all the excel files i open
  19. Excel 2007 - Issue moving a row of data (cut and insert)
  20. countif function
  21. Difficulty "countif"-ing number of "L1" or "L2" on an autofiltered
  22. Pivot Table Chart Drop Down Box
  23. Vendor Name Lookup
  24. copying a cell that has been formatted to cell with conditionals
  25. Conditional Formatting: Referencing from a different cell
  26. Count the number of cells that conatin a "." in a range
  27. Hyperlinks in Excel 2007
  28. formula error- ("Nesting more than 7 functions"- Feb4)
  29. 'Disable' Field?
  30. RE: subtracting dates leaves date/number or date
  31. conditional Formatting based on a value in another cell
  32. subtracting dates leaves date/number or date
  33. Worksheet Tabs
  34. Hyperlink changed???
  35. finding multiple code dates for multiple item number
  36. process order with IF statement
  37. Vlookup Multiple Matches
  38. List Box - Multi Select Issue
  39. How to reference Worksheets in VBA properly
  40. How do I set up 12 month financial report for church in Outlook
  41. newbie
  42. Newbie
  43. conditional formula
  44. Count No of days past due
  45. Cell reads "Value" without an entry
  46. Hard return in concatenate
  47. How to change picture
  48. Help with time conversions
  49. Sumproduct Help
  50. IF TODAY()<
  51. Recognize Color and Insert Symbol
  52. Formula please
  53. Error message
  54. Conditionl format for 3 cells Skipping the center cell
  55. Conditional Formatting on #VALUE!
  56. Copy non merged to merged cells again
  57. Calculating ratios: Is there a formula that can do this?
  58. Fill down without formatting macro
  59. Validating Date Format
  60. Sorting amounts in columns by due dates
  61. Count one character in a string across a range of cells?
  62. Find and replace dilemma
  63. Is it possible to offset a worksheet reference?
  64. getting excel to recognise copied data as mm:ss not hh:mm
  65. Copying a Range of Cells having data only
  66. EXcel problem
  67. how do i compare two text columns
  68. Date functions and #value!
  69. "go to" "blanks" after using a formula
  70. How can I write mm square, with 2 show up on top of mm.?
  71. VB Code
  72. Getting rid of VLOOKUP N/A
  73. SUMIF FUNCTION works in all cells but those related to one account
  74. Conditional formatting comparing times
  75. Function to find truncated entries?
  76. Partially refreshing spreadsheet
  77. Copying data across a workbook -- Office 2003 vs 2007
  78. Fill Macro II
  79. Count Unique Numbers if Names Match
  80. My current formulas in documents have quit working
  81. dividng numbers using the sumif function
  82. Compare and then copy cell to separate worksheet
  83. sum function
  84. Question on which function to use
  85. aging category calculation for open purchase order report in Excel
  86. SUMIF function
  87. How do I use countif like sumif ie (range,criteria,count_range)
  88. userform date issue
  89. Can i make text in cells c60@n60 bold & black if sum of C59 is gre
  90. Using SUMPRODUCT, 3 variables, 2 types of data in 1 column
  91. Formula Help
  92. The If function
  93. Creating a formula
  94. RE: Vlookup question
  95. RE: How to get the number from text?
  96. RE: Referenced cell change when row is blank
  97. Referenced cell change when row is blank
  98. Vlookup question
  99. Find the UPPERCASE letter in a string
  100. How to get the number from text?
  101. Excel 2007 vs 2003 menus.
  102. nice shopping plaza
  103. Test 2 numbers
  104. Trade Distributor and Store Merchandise Wanted
  105. Lookup value based on 2 cell values
  106. How do I place a picture instead of words in a hidden comment box
  107. Countif(and
  108. convert day of year to numeric value format year+day in 4 digits
  109. Data Validation with 2 criteria
  110. Time Zone, how to default to PT Time
  111. count with multiple critirea
  112. count with multiple critirea
  113. count with multiple critirea
  114. Format cells with 0 as the tenth digit
  115. Locking cells
  116. How to auto sum cells if letters are in cells?
  117. What number appears the most?
  118. Frequency
  119. What number appears the most with a certain number
  120. EXCEL
  121. Incorrect Date function
  122. Excel 2002
  123. how to I make the tabs at the bottom of excel larger (large font)
  124. Code/Function to Look at Previous Entry to Validate Data
  125. VLOOKUP help
  126. Problems with embedded merged
  127. Condition formats have $ sign problem copying
  128. copying conditon formats with $
  129. need macro from button to open selectable file
  130. HYPERLINK AND VLOOKUP help
  131. advanced filter - blanks
  132. Formula Help please
  133. inserted lines move how to place lines in proper cell?
  134. how do I lock the fill color in a cell
  135. Hep with Conditionals actions please.
  136. Lotus Notes - Unable to Copy Paste Special in macro
  137. Looking to add unique (sequential) number to already generated Use
  138. Add a unique (sequential) number at the end of usersnames
  139. Add a unique (sequential) number at the end of usersnames
  140. Add a unique (sequential) number to "usuername"
  141. Greatest Number
  142. SUMPRODUCT Formula Error, please help... ;o(
  143. Percentile formula
  144. Percentage
  145. List Box - Scroll Wheel on mouse crashes spreadsheet
  146. Eliminate Blank Columns
  147. VLOOKUP and return formula
  148. vlook up and return formula
  149. vlookup
  150. Duplicates
  151. Formulas help
  152. formulas
  153. Code modification help
  154. How to Copy Excel Workbook - Hyperlinks - Folder of Photos - to CD
  155. How to Copy Excel Workbook - Hyperlinks - Folder of Photos - to CD
  156. Sort Not Working on Column of Numbers
  157. Delete cells with 0 as the tenth digit
  158. vlookup by date
  159. How do I create colums within a colum
  160. how do I lock the fill color in a cell
  161. IF (I think!)
  162. IF (I think!)
  163. IF (I think!)
  164. VBA not working - Messy.
  165. Arabic Numbers
  166. turn a cel a color based o todays date
  167. Can you copy formulas only across a large sheet, under data?
  168. Excel Biweekly SS with Weekly Overtime totals
  169. How can I determine the modification date of a cell?
  170. In VBA Name a Table with Relative refer.
  171. IF Function
  172. IF Function
  173. Pivot Chart Dual Category Axis not Preserving Formatting
  174. Summing only numbers, not formulas
  175. & if
  176. inserting [ ] around text in a cell
  177. making numerical date return mmmm format
  178. Countif? or IF statement??
  179. Not sure what formula to use? If??
  180. not sure what formula to use? IF???
  181. Nested IF statements using AND / OR
  182. Testing for conditions with IF statement and AND function
  183. Pivot table formulas
  184. Trouble constructing IF statement
  185. if cell blank color "red"
  186. Calculating Hours
  187. searching between dates
  188. How do I format a cell based on the contents of a different cell?
  189. Test of Multiple Conditions in an IF statement
  190. Vendor Lookup
  191. Using IF to compare multiple cells to one another
  192. Using IF
  193. How to lock a photo in a cell
  194. writing text to different cell after comparing
  195. Is there an Excel formula to show the highest letter in a row?
  196. Spreadsheet Corruption?
  197. printing page # on sheets
  198. Moving Data between sheets in the same workbook and moving data between Workbooks.
  199. Units Produced / (finish time minus start time)=Units Per Hr
  200. countif
  201. Creating an auto-adding set of columns
  202. Continuos addition of two columns
  203. Formula to set color in a cell
  204. Adding Two Columns
  205. Write data from one cell to another cell
  206. Write data from one cell to another cell
  207. Write data from one cell to another cell
  208. Ooops - My Bad.
  209. Averaging
  210. Unable to obtain relative reference using conditional formatting
  211. Unable to obtain relative reference using conditional formatting
  212. Referencing a cell in another worksheet within the same workbook
  213. Referencing a cell in another worksheet within the same workbook
  214. Change the color of Selected Row, column or cells
  215. Countif
  216. formula to lookup employee name and return data from multiple rows
  217. formula to look up employee name and return reoccuring net pay
  218. Rename tab to cell contents
  219. COPY / APPEND`
  220. Using SUM with INDIRECT function
  221. perfoming calculation on randon cells
  222. Difference between NOW() and TODAY()
  223. forula needed
  224. formula needed
  225. counting multiple dates in a range
  226. needed formula
  227. compare two columns in same worksheet for similarities
  228. Worksheet to another Worksheet
  229. Sorting Several Columns/Rows Automatically
  230. Sorting Rows/Columns Automatically
  231. Sorting Rows/Columns Automatically
  232. Seperating and extracting text from parentheses
  233. Seperating and extracting text from parentheses
  234. Seperating and extracting text from parentheses
  235. Sorting Rows/Columns Automatically
  236. Seperating and extracting text from parentheses
  237. Sorting Rows/Columns Automatically
  238. countifs with multiple dates
  239. Help needed urgently..:(
  240. Linking Date range to cell Formatting
  241. dropdown entry with keyboard
  242. Sorting Columns/Rows Automatically
  243. Dropdown selection by keyboard
  244. Dropdown selection by keyboard
  245. format a cell when I type 10 it will multiply 10 by .585
  246. d
  247. Sorting Columns/Rows Automatically
  248. Counting Formula Needed
  249. Match two values
  250. Excel 2007 using arrow keys
  251. Matching two values
  252. Converting a time calculation to a value to do math with
  253. Converting a time calculation to a value to do math with
  254. Data Aligning with out cutting and pasting
  255. count day's
  256. Array Formula Help
  257. Array Formula help
  258. Array Formula Help
  259. HELP: Selecting Non-Visible (Hidden) Cells when AutoFilter is Appl
  260. cell value instead of formula?
  261. getpivotdata custom subtotal
  262. by using the if statement:have all like numbers marked in column
  263. Difference between NOW() and TODAY()
  264. Help with If and Vlookup Statement
  265. Help with IF and VLookup Match Statement
  266. Help with Vlookup Match and IF statement
  267. getpivotdata custom subtotal
  268. getpivotdata custom subtotal cell reference
  269. sumproduct using criteria from multiple columns in a separate wksh
  270. sumproduct using criteria from 2 worksheets
  271. 1hyperlinks and macros
  272. Merging data from 2 worksheets
  273. sum product with criteria from 2 wkshts
  274. Need formula to change cells from negative numbers to a zero.
  275. vlookup
  276. vlookup
  277. sum if function
  278. PMT function
  279. References
  280. Drop Down Plus Match, I think!
  281. Need assistance with calculation for leave loading
  282. Formula needed to generate report!
  283. Specify a column by the month to calculate it's data
  284. specify which month's columns to use in mtd calculation
  285. Specify MTD Diff by month's columns
  286. Specify columns to add for months MTD Diff
  287. Criteria across multiple columns and rows
  288. Multiple Criteria across multiple Columns
  289. Sumproduct across multiple rows and columns??
  290. Multiple Row and Column Criteria
  291. Cell Function Protection
  292. Forcing to recalculate
  293. Finding E-mails in different columns and trying to put them in one
  294. Finding e-mails
  295. Prevent Duplicate Records
  296. Counting sales
  297. Prevent Duplicate Records
  298. How to force the use of a specific custom list in a excel 2007 cha
  299. How to force the use of a specific custom list in a excel 2007 cha
  300. Extra string before a specific character
  301. Dropdown entry by Keyboard
  302. Test
  303. Array Formula Assistance
  304. Array Formula Help
  305. Using cell referencces as values in MDX formulas - cubemember
  306. RE: Lookup Formula
  307. RE: Lookup Formula
  308. Lookup Formula
  309. IF and ISBLANK functions
  310. IF and ISBLANK functions
  311. SUMPRODUCT using a list?
  312. Setting Up a Series of Formulas
  313. Need help witha forumla?
  314. IF and ISBLNAK functions
  315. monthly capturing of information
  316. Text Entry
  317. Extract text within two specific values within a cell
  318. extracting text between two keywords
  319. extracting text between two keywords
  320. extracting text between two keywords
  321. Apologies for multiple posts
  322. How to get a linked workbook to return a blank value?
  323. XL VBA function needed for a list of items
  324. Why can't I link to a cell that contains a date or a time?
  325. IF and ISBLANK Functions
  326. SUMPRODUCT help
  327. Data Validation Date Format
  328. color fill
  329. Creating a list of Excel formulas
  330. Data Validation and Sort
  331. Can three separate sections of rows be sorted in the same order?
  332. typing (c) in excell
  333. "Send To" Function in File Menu
  334. Creating drop downs for multiple cells
  335. Transferring data from multiple sheets in workbook to one sheet
  336. Two Matches, then Sumproduct of Values
  337. vlookup & summing
  338. vlookups
  339. How to force the use of a specific custom list in a excel 2007 cha
  340. Return a list based on +/- of a cell value
  341. Return a list based on a +/- of a cell value
  342. Return a list based on +/- of a cell value
  343. Return a list based on +/- of a cell value
  344. Return a list based on +/- of a cell value
  345. Negative Numbers
  346. Conditional Formula
  347. Problem with date - can't enter 15th!
  348. Conditional Formula
  349. Lookup value in col D when Col A & B are listed multiple times
  350. Transferring data from multiple sheets in workbook to one sheet
  351. How do I disable the date & time functions?
  352. How do I disable the date & time functions?
  353. Transferring data from multiple sheets in workbook to one sheet
  354. Splitting Year from Dates
  355. Splitting the Year from Dates
  356. Shortcut Key Creation
  357. Swapping two words around in teh one cell
  358. Swapping two words in a cell and placing them in another cell
  359. Swapping two words in one cell
  360. Swapping two word and placing them in another cell
  361. VBA isn't subtracting properly
  362. msg box for eache value
  363. Find a number on another worksheet
  364. Find cell entry contained anywhere within a text string
  365. Find Function
  366. Pick Ref# randomly on an average
  367. Shortcut key for Excel 2003 SP3
  368. return a value
  369. radius formula
  370. arithmetic on minutes and seconds without leading zero
  371. How to code macro for worksheet?
  372. Compare two datasets and extract unique records from each
  373. Formula that will increase an integer added to a value based on..
  374. Formula that will increase an integer added to a value based on..
  375. Transpose columns to rows using first columns repeated.
  376. To Refer particular Month in large datas
  377. Counting multiple criteria across columns and rows???
  378. Counting multiple criteria across columns and rows???
  379. How to force the use of a specific custom list in a excel 2007 cha
  380. How to force the use of a specific custom list in a excel 2007 cha
  381. Specific custom list in a excel 2007 chart
  382. Specific custom list in a excel 2007 chart
  383. Specific custom list in excel 2007 chart
  384. potential duplicate max values
  385. How do I change the sizes of individual cells not whole sheet?
  386. How do I change the size of one cell or groups of cells?
  387. How can I use an if formula that works on a cell with column?
  388. Using function on column?
  389. Using function on column?
  390. Using Small to return 2nd smallest value
  391. Finding 2nd smallest number in range
  392. Returning 2nd smallest value in a range
  393. Auto Lettering
  394. Auto Lettering
  395. Auto Lettering Rows
  396. Automatic entering of information from another worksheet if given
  397. Formatting cells for text and numbers
  398. Indirect alternatives
  399. unique record count with multiple criteria
  400. Ignore Blanks in Countifs statement
  401. Formatting cells for text and numbers
  402. Question for Math whizzes
  403. Formatting cells for letters and numbers
  404. Getting rid of PivotTable format
  405. VLOOKUP Reading Wrong Record
  406. unique values with multiple criteria
  407. How to remove PivotTable format.
  408. Calling the contents of a random cell
  409. Excel 2007 single cell selecting muliple cell
  410. hidden rows reappearing when using filter
  411. hidden rows reappearing when using filter
  412. Custom list in a excel 2007 chart
  413. I need calculated time in a "real number" format
  414. Cell format will not update
  415. Select which formula to use in a cell.
  416. Use formula result as the formula for another cell.
  417. Calculating payroll cost
  418. Calculating payroll $$
  419. Based on Mulipple Criteria acrossed Column count last column
  420. Sorting & sub-totaling data on an excel spreadsheet
  421. Copying first three characters of text in a cell
  422. Help
  423. Continuous calculation of a formula
  424. Continuous calculation of a formula.
  425. Filter Multiple Columns on Multiple Criteria and count the last co
  426. A formula to discount percentage
  427. if Then
  428. zeros
  429. Locating duplicates within range of time punch data
  430. Need help on this macro
  431. Please help me add something to this macro
  432. Return a given value if the value of a cell is in a given range
  433. Returning Bottom 10 Percent in another spreadsheet
  434. Returning Bottom 10 Percent in another spreadsheet
  435. no leading zero for minutes and seconds
  436. Creating Templates
  437. Auto Insert Comment box in Excel
  438. Need help comparing data in two columns
  439. Auto Insert Comment box in Excel
  440. Auto insert a comment box.
  441. Comment box
  442. need help w/ formula not very excel smart
  443. interpolation within subranges
  444. Need help not excel smart
  445. Sum of items in a column if they meet two criteria in another colu
  446. formatting numbers as 1st 2nd
  447. percentage formula
  448. count how many rows a word appears in
  449. count a word recurrent in many cells
  450. Need to add rows to entire wksht that includes a pivot table
  451. Simple formula question
  452. Dependent Validation
  453. Dependent Validation
  454. How to format Text by function
  455. Running total for actual cost
  456. Running Total for costs
  457. running total for costs
  458. Running total of Actual cost
  459. running total of actual cost
  460. running total of actual cost
  461. date range table array formula
  462. Arrays/vlookup???
  463. Date Array Problem
  464. Continuous calculation of a formula.
  465. multiple selection....
  466. concatenating
  467. Removing a picture box from an Excel 2007 spreadsheet
  468. Applying change to selected cells
  469. inter-dependency
  470. sorting question
  471. Lookup based on a date being between a range
  472. lookup based on date range
  473. remove characters on both sides
  474. Change 4 to Wiri
  475. CF
  476. Calculating Variances using formulas
  477. How do I display text when a cell value is 0 for accounting?
  478. How do I display text when a cell value is 0 for accounting?
  479. How do I display text when a cell value is 0 for accounting?
  480. How do I display text when a cell value is 0 for accounting?
  481. Dependent Validation
  482. IF Formula
  483. Date filter in weeks.
  484. Counting two columns with specific criteria
  485. Quick question...
  486. Vlookup & "space" vlookup
  487. posting problem
  488. .NET RTD on Excel 2007 & Vista
  489. Parsing Column of Numbers into 5 separate columns
  490. Nested If with Lookup
  491. on opening an existing file I get blank blue screen
  492. Hope to change order of vertical cells when pasting
  493. Not even sure this is possible.
  494. If Then And Statement
  495. Need urgent help selecting correct test!!
  496. not sure if this is possible
  497. Populate Cell Date Value with Active X Calendar Control
  498. sequential numbering
  499. If Statement
  500. Filtering/sorting question
  501. Filtering/sorting on upper/lowercase
  502. Filtering on upper/lowercase letters
  503. Lettering rows
  504. $30 Pass4Sure to pass microsoft certification exams.
  505. Vlookups to return a N/A value
  506. Arrays and Average
  507. Problem calculating
  508. Avg Arrays
  509. Arrays, averages
  510. Sumproduct Help
  511. inverse of the column function? i.e. input a number, output thecorresponding column text label
  512. arrays and avgs
  513. arrays and averages
  514. Print changeing one cell on form
  515. SUM, IF, OR, AND array
  516. SUM, IF, AND, OR array
  517. SUM, IF, AND, OR array
  518. decimal numbers to word
  519. decimal numbers to word
  520. test MS web interface to ngs
  521. Formula to lookup item for Qty?
  522. Calculating Cost Per Minute
  523. Arrays and Averages
  524. Row Title
  525. How to eliminate everything but duplicates
  526. Need a formula for time conversion
  527. formula to count sets of repeating numbers
  528. Cell Reference
  529. IF Statement Modifications
  530. AVERAGE of AVERAGEIFS problem
  531. Averageifs & median
  532. Formula Working With Positives and Negatives
  533. Using cell's contents as an index to a row ... ?
  534. Using cell's contents as an index to a row ...?
  535. Using cell's contents as an index to a row ... ?
  536. Remove Duplicates
  537. How to remove the seconds on a VB mirror = cell
  538. How to remove the seconds on a mirror = cell coded in VB?
  539. Choose from list to fill a cell
  540. Conditional frmatting issue
  541. Choose from list to fill in a cell
  542. Match function
  543. What is this function? { }
  544. Choode from list to fill a cell
  545. Choose from list to fill a cell
  546. Dynamic Cells
  547. choose from list to fill cell
  548. Re: Dynamic Cells
  549. function on date
  550. Count Unique with Multiple Criteria
  551. Ahmed Sayeed Khan
  552. Ahmed Sayeed Khan
  553. Ahmed Sayeed Khan
  554. "how do I calculate age by using date of birth details"
  555. Filter - Excel 2003
  556. XBRL Tool
  557. Date fomula not working
  558. I WANT TO CREATE MANDATORY CELLS
  559. HELP WITH EXCEL FORMULA
  560. find files from a dropdown list
  561. IF statement on a range of cells in Excel 2007
  562. Formula Help
  563. Text box does not populate linked cell
  564. LOOKUP multiple entries, return last
  565. How do I "insert copied cells"? used to be "alt i e" still work
  566. formatting the Cell color directly in an IF formula
  567. Will VLOOKUP and MATCH work to find combinations of pulley diamete
  568. protecting certain cells in Ecxel 2007
  569. auto copy total from one workbook to another workbook
  570. Count function
  571. Copy corresponding cell if value is >0
  572. Erisson FREE Laptop
  573. Calculating Military Time
  574. Another Array Mystery
  575. Pick of random ID's
  576. COUNTIF - Summing non-numerical items in cells
  577. Protect of Single Row or Column
  578. Variable Cell Reference
  579. Saving A One Off IF Result
  580. Copy Excel functions formula and auto refresh refresh
  581. display last entry into a cell automatically
  582. numbering system
  583. to Don: display last entry to cell automatically
  584. automatic display of last 2 entries in tHe column to specified cel
  585. Find next good data in a column
  586. AUTOSUM WON'T CALCULATE
  587. To move automatically right or down at the push of tab or enter?
  588. IN MICROSOFT OFFICE 2007 WHERE IS THE FORMULA FOR DOLLAR SIGN
  589. How do I reference a "range" for a specific table_array in VLOOKUP
  590. Convert 1.1B to 1,100,000.00
  591. concatenate within an Index/Match formula, or is another approach needed?
  592. Using a wild card in SUMPRODUCT
  593. how to use if formula in list (data validation list)
  594. Adjust the number of lines when pressing page down
  595. 2 columns have same data:Sort column E, but column A changes as we
  596. Combining INDIRECT
  597. Inserting new rows without inheriting protection from row above/be
  598. Simple INDEX MATCH Question
  599. Conecting Drop down lists
  600. Print Preview Spacing
  601. Does anyone have any suggesitons on how to do it for worksheet?
  602. Equity beta
  603. Count Duplicates in text values
  604. Hyperlink with a target - is it possible??
  605. TO ROUND 37.75 UP TO 38 OR DOWN TO 37.5 FOR PAYROLL
  606. Custom list in a excel 2007 chart
  607. Count unique
  608. Pivot Table Totals
  609. Conditional formatting
  610. #VALUE!
  611. Excel 2007 Is it possible to vary the column width between rows?
  612. If statment help
  613. 2003: Having trouble with conditional formatting with custom user function (Repost)
  614. Need help of you people
  615. need your help
  616. Need help of you people
  617. Vlookup and If statement help
  618. Need your help Shane
  619. Consolidating Data
  620. Count Unknown Text
  621. Grouping in Pivot Tables
  622. XML Column to Multiple Columns
  623. Using ISERROR with more than 2 cells of data
  624. sum of cells in different rows & columns & criteria
  625. Wildcard search
  626. Conditional Formatting
  627. SUM & OFFSET
  628. WORKBOOK INDEXING
  629. Functions (search within search result)
  630. Functions (search within search result) reply to this please
  631. rearrange the data with a new table
  632. Sum a column that contains if statement that reference cells with
  633. what does ^ do in a formula when used in Excel
  634. HELP PLEASE!!! "Different kinda of function"
  635. How to return a cell reference as result of a formula
  636. HYPERLINK VALUES AND REMOVING MACROS
  637. calculate filetred cells only
  638. Calculate Filtered cells with satisfying toomany arguments..
  639. Remove link to formula source
  640. Addiing Tex
  641. What does the $ sign mean in spreadsheet calculations?
  642. Help - sumif help on sales data between dates?
  643. Index Question
  644. VLOOKUP DUPLICATE VALUES
  645. How do i delete a saved rectangle in excel?
  646. Excel 2007 Freezes
  647. =HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes,
  648. =HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ?
  649. Is there a way to sum monthly or weekly reports into one report
  650. Sum multiple cells based on vlookup
  651. multiple criteria count formula with duplicate data
  652. Need help with "Function to do what auto-filter does"
  653. Import external data link disappears
  654. Custom Number Format to abbreviate to Millions
  655. Formulas between worksheets
  656. Check Boxes
  657. Calculating future values for assets & liabilities based on ror
  658. Adding entries if date entered in another column
  659. enter data simultaneously on multiple worksheets, but NOT same loc
  660. Combining 4 Conditions into 1 Formula!
  661. shortcuts to formulas
  662. Format Changes 2007
  663. Index Match Problem
  664. Counting Member numbers?
  665. =Large function returns #NUM!
  666. Here again for help
  667. db count if...
  668. Templates
  669. Build a reference to another worksheet from cell values in currentsheet
  670. if formula with variables
  671. Vlookup between two sheets
  672. Count Unique Values
  673. find a value in a table based on 2 different criteria
  674. Compare cells in different worksheets
  675. Re-post as I still can't seem to get this to work 100%
  676. How do I autosum a filtered column
  677. looking for the next value
  678. add color to a cell
  679. Cross matching .
  680. Column and Row labels are numeric
  681. INA help
  682. Reverse Lookup question
  683. Subtotal by Month and supplier
  684. Subtotal by 2 different criteria
  685. Correct #N/A Value
  686. Using = Named range
  687. Data gathering and reporting
  688. AVG or Return 1 value from either of 2 cells if one is blank
  689. Nested IF & MAX Function
  690. Addition of 2 cells is not correct
  691. Round up
  692. TODAY() function problem
  693. auto extend formulas
  694. Excel 2003: Match Names; View Unfound Matches?
  695. How to extract specific text from a string of characters
  696. Count Numbers
  697. Need a program to make a work shift schedule that is staggerered
  698. Need help giving a response a number value
  699. ~Time Calculation
  700. List of workbook tabs
  701. Goal Seek
  702. Average
  703. converting text into years
  704. Cell formatting won't work
  705. does a value exist in another workbook
  706. How do I lookup from a table
  707. Data Validation w/an If Statement
  708. Conditional Formatting
  709. Networkdays two years
  710. Calculating a percent decrease
  711. Can Sumproduct return Text values
  712. How To Create a Value Based Upon The Contents of A List
  713. joining worksheets
  714. Writing formula to include quote marks in result
  715. excel 2003 date notification formula
  716. Converting Text to Number
  717. Sumproduct and Vlookup
  718. Select used range
  719. Looking for an alternate solution
  720. need help with a formula
  721. Function Question
  722. VLOOKUP question
  723. frequency function and letters [HOW?]
  724. Lookup Problem
  725. Need an Equation
  726. Drop Down Box
  727. Allow for multiple selections from a list
  728. Sorting
  729. CountIfs
  730. Delete rows in a workbook that contain the same information
  731. HOW TO FIND A LAST NAME IN COLUMN OF LAST NAMES?
  732. formula question
  733. How To Stop Excel Copying Named Functions When A Worksheet Is Copied?
  734. Nested IF statements
  735. Linking worksheets
  736. How do I copy a range of data to another sheet?
  737. How do I count once, multiple duplicate values?
  738. Formula question
  739. Long Formula
  740. If Condition Confusion
  741. problem accessing Pivot table Excel 2007
  742. Todaysdateminus1and2
  743. Auto Removal Of Duplicate Rows
  744. FORMULA
  745. Auto complete
  746. Copying Conditional formating in a List of text and values.
  747. How can run a macro ( call a macro) on selection of any filtercriteria?
  748. Worksheet settings
  749. Conditional Formating
  750. Date Change
  751. Help With Sumif
  752. Currency formula
  753. SUMIF to sum multiple columns of data?
  754. Rounding column of #s down so each cell is a multiple of 5
  755. How do I set up a multiple condition formula?
  756. Sumif on columns with logical answers
  757. Worksheet(s) open to last used row
  758. CONCATENATE not producing any results
  759. Year or ROI
  760. Re: CONCATENATE not producing any results
  761. Excel: VLOOKUP returns #N/A for a sorted value that exists?? WHY?
  762. Formula help please
  763. Parse A String into Two
  764. VlookUp or may be Match Function
  765. Array Formulas
  766. Formatting a cell to print or not to print
  767. Linking value of cell on one worksheet to a column on another work
  768. how do i insert roman numberals in the middle of a sentence
  769. Formula for names
  770. 11 digits
  771. Nested if statement or Nested if OR statement
  772. Lookup missing number(s) in column w/blanks & duplicates
  773. how do i make a dobble bar graph
  774. I want to merge two side by side colomns
  775. Too many characters in formula?
  776. Formula to a sheet name that is text in another cell
  777. Moving cells
  778. How to SUM for indeterminate number of rows?
  779. Countif for 2003
  780. count cells, then reset count when value in another cell changes
  781. workgroup
  782. Month
  783. Combining arrays for a Lookup function
  784. VBA - Data Validation (Looking for NERD help)
  785. formulas
  786. Using count function for multiple columns
  787. how do I format numbers to ordinal i.e. 1st, 2nd etc
  788. ISERR
  789. Sumproduct Subtotal #Value! error
  790. Can selection from text drop-down dictate value in another cell
  791. pick list location
  792. How do I set a start and expiration date using IF function
  793. Shortcut key for comma format?
  794. Add working days to a date
  795. printing blank forms with auto generated numbers
  796. Moving sheets to new books
  797. Formula help please!
  798. Formula help - rounding up and round down?
  799. Counting dates
  800. How do you easily add rows to check register template
  801. VBA guys needed
  802. Subtotaling
  803. I am getting an error when I try to group data in a pivot table.
  804. 2 formulas in 1 cell
  805. OMG Help!
  806. Need MAX value if condition is met
  807. Sharing
  808. Hiding Formulas
  809. if- then statements
  810. Alphanumeric custom formats
  811. Showing data unigue to multiple columns in a pivot table
  812. Linking Checkboxes/Drop Down Lists to a Formula
  813. Extracting row with lagest amount
  814. XIRR problem
  815. copy formula to filtered cells only
  816. How do I retreive the last # in a column?
  817. How do I apply a rounding rule
  818. drop-down list
  819. Comparing two different columns - looking for similar data
  820. use check box created in Excel 2003 opened in Excel 2007
  821. auto populate different cells when selecting from drop down list.
  822. Nested formula to search a text string and return specific text
  823. matching or lookup functions
  824. I need to create a fill in form
  825. how do I get a simple #"123" from 1 2 3 ? Spaces between numbers
  826. PeopleSoft report spits out 1 row into 2 rows -how to make 1 row
  827. Need Help in Excell Formula
  828. Compare multiple rows for duplicated values in individual columns
  829. Return the cell reference of the drop down list selection.
  830. count
  831. week update formula
  832. Auditing excel sheets for everyday task
  833. Auditing excel for everyday tasks
  834. how do i set up if cell content repeat, warn given
  835. Data Validation Q
  836. Excel 2007 - toolbar for Text to speech
  837. SUm
  838. Excel Pivot 2007 Report Format
  839. Copying summed cells
  840. editable cell in a dropdown list
  841. Cross tab table
  842. How do I save only active worksheet without save all of worksheet
  843. COUNTIFS-Want to remove several words in one column w/multi criter
  844. SUMIF formula required to search for 2 diff values in 2 diff colum
  845. Sum within a column, according to another column
  846. mixing SumIf and Subtotal Functions
  847. Function With Lookup
  848. Name Sheet Tab to Reflect Edit Date
  849. Counting cells that contain a substring
  850. Questionnaire
  851. Matching data in two columns
  852. calculations - table, if, or, >, < etc etc
  853. Which function do I use?
  854. Excel 2003 Worksheet
  855. SumProduct problem
  856. What Function to use?
  857. gain-loss
  858. Drop Down List Question
  859. Calculat an expiration date
  860. Count numbers of Month in a cell
  861. Convert Turn Rate to Weekly Supply
  862. Simplify this formula
  863. entering formula using cells notation
  864. need to make 4 typical entries regularly in excel
  865. Formula help please!! IF(OR
  866. VBA macro pausing
  867. Macro error - cant work it out...
  868. Vlookup using concatenated values - Excel 2000
  869. What If, Count - totally confused......
  870. Sort by town name, which follows first name and initial; period; andcomma.
  871. "Cannot shift objects off sheet" in Excel when inserting row/col?
  872. sorting 4 columns
  873. Pivot Table Field based on two data area fields
  874. Inventory Months Supply Question
  875. Consistantly average 180 data cells
  876. Hours and minutes
  877. Conditional Formatting to Show Red Highlight in Text Field
  878. Formulas
  879. Formula:
  880. most used value
  881. Conditional Format Font Color for more than 3 conditions
  882. 2 Criteria Summing
  883. decimal values create inequality
  884. Tabbing Question
  885. Data Analysis Tool
  886. RAND()
  887. my vlookup path changes when I open the file
  888. VLOOKUP
  889. How could I return to the first row after I finish the last entry?
  890. Linking to pages within a workbook?
  891. how do you de-dup an address list in Excel?
  892. Using one sheet to complete information in another sheet
  893. Finding most recently entered number within a column
  894. Tabbing Question
  895. Using list choices to use as headers
  896. VBA question
  897. Sum of two offset cells
  898. Cell value with multiple values to vlookup
  899. Making a budget
  900. Removing first 10 characters of text
  901. Drop down list from another worksheet
  902. Applying Conditional Formatting to a Max number in range
  903. Applying Max Conditonal Formatting to an entire row when condition
  904. I need a fx for counting numbers between numbers (between 18 - 59
  905. fx for vacation
  906. Conditional formatting Max to a entire row A1:D1 with E1 being Ma
  907. Conditional validation with only two columns
  908. increasing or decreasing a cell
  909. Print Range Setup
  910. Macros
  911. Time functions
  912. Time function
  913. macros
  914. Change operator from cell value
  915. Excel 2007 - VLOOKUP always returns #N/A
  916. Making a vertical list from a rectangular range, with no empty lines
  917. Change Alignment Defaults
  918. Advanced Filter for Text String
  919. Duplicate files
  920. Count cells with a date in them
  921. greater/lesser than
  922. Help With Cell Function
  923. Adding only part of a column
  924. How do I find the cell/data the closest/nearest to another data?
  925. IF Statement
  926. if function or lookup??? across a range of cells in a row.
  927. If condition for Blank Cell
  928. How do I count a range of dates in a column?
  929. Changing entire row based on 1 MAX cell value (Conditional Formatt
  930. I have lost the ability to auto Sum my columns....
  931. Time and Vlookup Problem
  932. How do I delete multiple of wooksheets
  933. I have lost the ability to auto Sum...
  934. column width
  935. How to calculate the difference between two different times.
  936. How to calculate the difference between two different times.
  937. Working with worksheet protection
  938. how do i just print a sheet in excell
  939. Lumping dates into quarters by year
  940. Convert Effective Annual ROR into quarterly ROR
  941. Protection of certain cells or columns
  942. Nesting MATCH functions? Or other solution?
  943. automatically populate worksheet
  944. linked workbook (cells) does not show entire length of original te
  945. Lookup value with multipe Results
  946. How can I return zero after a max value has been met?
  947. loading descriptive analysis toolpak-HELP
  948. Sum by Cost Center
  949. calculate the stdev of an array using text as the criteria
  950. cell reference question
  951. Relative Link remembers absolute path??
  952. Stumped on adding 3 cells
  953. triangular distribution
  954. Formula for success... corny I know
  955. divide cells
  956. Excel User Form
  957. IF function to grab data
  958. rearranging rows from a single column
  959. help creating a question sheet
  960. Transferring data
  961. Macros 07
  962. conditonal formatting
  963. Total of Females in a worksheet
  964. Index function
  965. Find second highestsalesprice
  966. reporting newest/highest value
  967. Return sum of values based on lookup-function
  968. COMPARING TEXT IN A RANGE OF CELLS AND DISPLAY IT IN ANOTHER.
  969. how to change language of Excell 2007 functions
  970. Format to show leading zero
  971. How to find exact differences between two worksheets
  972. display differences between two worksheets
  973. Automatically Refresh Pivot Table Data
  974. Calendar Control with some VB help required
  975. How can I set a limit in a cell
  976. 3d countif
  977. Finding Data
  978. How can I display the footer on first page only?
  979. Using Multiple sets of Option Buttons (Form Control) In Excell
  980. Histograms
  981. Countif against a range of text entries
  982. I need my template to show more than one months results
  983. Minimum without zeros or negatives
  984. Ignoring dates when calculating differences in time
  985. If two criteria match then sum matching values in another column
  986. Please - help with formula
  987. What is the Qur’ân?
  988. help with formula
  989. Can system time & date be nested in conditional formula?
  990. Format for making date calculations
  991. Multiple isnumber
  992. split cell data?
  993. split cell data?
  994. Count Advanced Filtered Rows
  995. COUNTBLANK function when column lenght grows
  996. XIRR Error
  997. How do I shorten an IF formula?
  998. Macro for importing text files but the file name changes
  999. how can i reset excel to its default values?
  1000. Excel 2007 Pivottable Rank
Google