PDA

View Full Version : Microsoft 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 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160

  1. Can I Rotate with a Condition -or- Can I Display Graphics with aFormula
  2. VLOOKUP with partial match
  3. S- Curve Calculation and chart
  4. N/A Error with VLOOKUP Formula - Excel 2007
  5. Re: Alternate row comparison
  6. Min Match Function needed
  7. Need Help with Excel and Flagging Outcomes!
  8. Calculating Elapsed Time Over a Set Period
  9. Re: Alternate row comparison
  10. Re: Alternate row comparison
  11. Offset, sum down to the first blank row
  12. Literal based on Week end
  13. SERIES function disappear
  14. Excel 2007 AutoSaves
  15. Find and replace for cells with certain number of characters.
  16. Strip Flat File Table into less entries
  17. XMAS
  18. repeat code remove
  19. RE: vlookup help linking data between worksheet
  20. Reverse Text in Cell before and after comma (not just Word1, Word2
  21. adding every third column
  22. Multiple If Function
  23. Re: Problem with a Function
  24. Re: Problem with a Function
  25. COUNTIF
  26. adding every other column
  27. Margins within a worksheet
  28. remove columns which show "0" as sum
  29. Search box for text
  30. Sorting a protected set of cells
  31. drawing org charts
  32. VLOOK with Index - How to get results across instead of down?
  33. Counting number of worksheets in a Excel 2007
  34. help with datedif function please
  35. Getting data from 2 differant colums
  36. Index Function Problem
  37. IRR
  38. Create a chart of totals over time?
  39. On Calculate question
  40. Sorting the first text in a row
  41. V-lookup and Countif
  42. Condtional Formatting - Inserting Rows
  43. Duplication of Counts
  44. Using Dependents - what does the small "Table" symbol mean?
  45. Sum of yes answers
  46. Sumproduct usage?
  47. Totaling Volume within a range of dates
  48. CHAR(10) does not create new line in excel 2007
  49. counta formula that doesn't count duplicates
  50. Question about a Formula
  51. Removing protections that prevent me from editing formulas.
  52. If statements??
  53. Restoring Gridlines
  54. Single Weekly Time Sheet
  55. adding ever other column
  56. Text search and "Go To"...
  57. convert repeated sheet 1 names to once in sheet2
  58. OFFSET
  59. How to assign unique number to column duplicates?
  60. convert vertical to horizontal
  61. Trim and Substitute not working
  62. numbertowords
  63. Formula For Sorting Part Numbers
  64. Sumif or sumproduct with multiple & difficult criteria
  65. Complex 2 table formula
  66. Format Cells Dialog Box Missing
  67. How to sort data from one worksheet into other worksheets?
  68. Row position of specified column and value
  69. Add AVERAGE column to Pivot Table
  70. Adding values with like information
  71. Help with complex formula
  72. how do I get a function formula cell to format as a number?
  73. comparing two worksheets
  74. comparing columns in two spreadsheets
  75. Can anyone answer this question?
  76. Change "FALSE" to "NO DATA"
  77. World Cup 2010 spreadsheet
  78. Cannot open text workbook
  79. conditional formating: ifs and highlighting rows
  80. VLOOKUP Returning a copy of a cell
  81. VLookUp and DropDown List in the same cell
  82. isblank
  83. changing cell value makes the formula plain text
  84. Have Excel Enter Decimal Place
  85. SUMIF/COUNTIF with missing data
  86. How can i join these two formulas?
  87. Any way to test whether rows are empty or contain the word Pass ?
  88. Conditional formating a cell containing a date
  89. Cell References
  90. All CAPS to Caps
  91. urgent...convert sum into max
  92. prevent cell overwriting
  93. formula to add number comined with text
  94. convert unix epoch seconds to yyyy:mm:dd in excel
  95. FUNCTION THAT SEARCHES DATA AND RETURNS INFO ON A DIFFERENT WORKSH
  96. Match (1 of 3 cell values) in a range?
  97. combine text & date formula to show mmmm dd, yyyy?
  98. Date and Formatting
  99. Goto Cell With Today's Or Other Date
  100. Finding second-to-last workday of month
  101. Variable Value Function Help?
  102. extract last 2 characters from the right?
  103. Changing contents of cell based on Cell Format
  104. Difficult function question for columns
  105. is 3rd character in a cell a space?
  106. What formula to use?
  107. Changing my functions to use subtotals?
  108. Test to see if cell contains a space?
  109. Comment with date stamp
  110. APR Fee Calculation
  111. How do I generate randum numbers between zero and .495
  112. College Football IF Formula
  113. combination IF- and VLOOKUP-function fails
  114. SUMIF start/stop
  115. Simple totals
  116. copy column to another file
  117. I Need Help With A Complex Formula
  118. Count/Sum rows of a column depending on criteria from drop-down li
  119. Link 2 files
  120. Return data from catagory
  121. Adding time
  122. Calculate How Long Funds Will Last
  123. Replacing multiple instances of character
  124. Count cells based upon criteria in other cells
  125. For you high bandwidth folks to download and evaluate...
  126. conditional formatting
  127. keep the title fixed while scrolling
  128. conditional formatting
  129. Ctrl+C
  130. #Div/0 error, can't get rid of it
  131. Reference to cell with external spreadsheet
  132. How can I stop the end user License agreement from popping up
  133. Date Conditional Formatting
  134. Tough Question
  135. Case Sensitive Counting & Filtering
  136. Arrange to present in continuous format
  137. Find the cell content
  138. evnet code, checking for entry
  139. application.goto
  140. Seperate info in a cell
  141. #VALUE! in cell
  142. Display excel formula values
  143. Select multiple adjacent cells of multiple cells without selecting
  144. Return a range based on a variable
  145. FInd common data in one column then add number in adjacent column
  146. copy value calendar control
  147. Find and Return the Non-Blank entry
  148. dependent drop down list
  149. Pivot Table GETPIVOTDATA
  150. Calculating gross when net is known
  151. is there an integration function in excell?
  152. i have a file with 50 worksheets, how can I print these names
  153. if formula for time sheet. - help
  154. Slow file with INDIRECT.EXT
  155. Preventing hyperlinks and vlookups from breaking
  156. Data in columns convert to single line
  157. Return value based on certain criteria
  158. Using Macro how to create email link for the email addresses in aRange or Selection
  159. Search Ranked items
  160. Mode Function combined with a filter
  161. What is hubscore?
  162. Average cyclic error
  163. HIKE %
  164. Conditiona format based on format of another cell
  165. Deleting rows
  166. macro to disallow shading in certain columns
  167. Data Validation Question
  168. Compare my list to an existing list
  169. RE: .numberformat Q
  170. selecting every other data point in a column
  171. Separate first name, middle name and last name
  172. Counting while diminishing
  173. Extract portion of cell contents
  174. combining data from multiple worksheets into one
  175. How to use SumProduct to count reference or something else?
  176. counting the number of consecutive days 12-17-09
  177. List of All Workbook's Worksheets
  178. LOOKUP across a whole table and not just first row or column
  179. How do I add an integer to an existing integer?
  180. weight loss
  181. Excel Protect Function, while allowing macros
  182. I want to save a copy of a wksht. but without any of the formulas
  183. Column
  184. Averaging data across a date range
  185. Complex Lookup Question
  186. % in Pivot Tables
  187. Count number of dates between a specified period of time
  188. Decimal
  189. And function into If function
  190. Conditions
  191. DSUM with dates
  192. vlookup
  193. match dates in two columns get value from third
  194. Q on LARGE function
  195. How can I do this ??
  196. Formula mismatch in Excel 2003 & 2007
  197. NEED FORMULA TO PICK UP TOP OF A COLUMN WHEN CERTAIN CRITERIA MET
  198. How do I insert a check box in Excel Vista? I'm a novice
  199. Excel 2010 to be able to embed like Google Apps?
  200. NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT
  201. Formula Problem
  202. Subtotals in Excel 2007 TABLES
  203. Excel VLOOKUP hyperlink to mailto function on different worksheet
  204. autofill down won't work!!!!
  205. Simple Question Complicated Formula
  206. Pivot Table Layout
  207. Dynamic Range Defined by Value of Cell
  208. Conditional Formatting
  209. excel scheduling
  210. References
  211. Calculating length of time with conditions
  212. 'developer reference' help window font size...
  213. Concatenate By Selection
  214. Expand/Collapse in Pivot Tables
  215. Comparing fields in an excel worksheet
  216. Place Date in One column when entry is made in another column.
  217. Help with determining instructor class location.
  218. calculate shipping costs in excel 2007
  219. conditional formatting and coloring cells.
  220. How do I delete excess pages from a file?
  221. Condense a formula
  222. COUNTIF Non Contiguous Cells Q
  223. If Statement ? Seperate cost over years of project
  224. multiple range in SUM,IF
  225. CONCATENATE TWO COLUMNS
  226. Display date in spanish
  227. counting the number of occurences
  228. Copy data from one workbook to another
  229. I cannot highlight a whole row or column
  230. weekday in pivot table
  231. Formula Needed for Corresponding Blank Cell
  232. Look up Data by Row criteria and column criteria
  233. Replacing spaces with data from another cell
  234. AVERAGEIF in pivot tables
  235. Conditional format question
  236. look up, match index? multi variable formulas
  237. Dsum excluding blanks
  238. Show formula result in another sheet
  239. Concatenate Cells
  240. How to put back ZIGMA icon on the toolbar?
  241. Sorting a text strings but omitting preceding "A" or "The"
  242. Count occurences of same zip codes
  243. vlookup backward
  244. SUMIF date criteria
  245. calculation taking too long
  246. RE: Pivot Tables - get a total different than the summarize field sett
  247. Pivot Tables - get a total different than the summarize field sett
  248. Re: how do a create a lookup using first and last name
  249. RE: how do a create a lookup using first and last name
  250. how do a create a lookup using first and last name
  251. If or conditional formatting?
  252. Dynamic range
  253. Combining spreadsheets
  254. BIN2DEC conversion for large binary numbers
  255. RE: conditional formatting problem
  256. How do I prevent duplicate entry of a sku in a data table?
  257. Why the minus result
  258. IF Function and Concatenation
  259. Worksheet several pages, Want name to show up on each page
  260. RE: conditional formatting problem
  261. Array Formula + Indirect Reference
  262. Countifs with "or" embedded?
  263. IF formula
  264. proper formula or function
  265. sum cells to reach a specific value and return corresponding value
  266. Re: DashBoard Summary to contol output
  267. Click "Yes"
  268. Macros will not run with shortcut keys
  269. help with dynamic tables
  270. Update tab function
  271. COUNTIFS AND CRITERIA
  272. Parsing data within parentheses
  273. if function
  274. Re: DashBoard Summary to contol output
  275. If then Statements in Excel
  276. Percentiles in Excel
  277. excluding column headers from formulas
  278. Multiple Formulas
  279. summing results of multiple vloopups
  280. Assign Macro to a Cell
  281. Dropdown lists using each value only once
  282. Excel 2003 calculation sequence
  283. Append values and remove text
  284. calculating longest winning/losing streak and totals
  285. format a range dependant on another cell
  286. Driving an address
  287. Vlookup Change in Reference Cell
  288. Calculate cumulative elapsed time in Excel?
  289. Cell referencing
  290. First Day of the Month
  291. 2 Macros 1 Buttom
  292. create defined name using variable file name in reference
  293. countif(Range,criteria) question
  294. Logical value in time formula?
  295. How to format cell to get first capital letter?
  296. trying to get sheet 1 to recognize and move student names to pg 2
  297. Tab key problem in Microsoft Office Excel 2003
  298. Name Scope
  299. Adding or to previously provided Average If Array function
  300. Subtotaling
  301. split one column to multiple columns
  302. Named Range that uses "relative" range - Possible?
  303. Nesting if functions
  304. Keeping links Static
  305. Array
  306. Excel
  307. Formatting a formula
  308. Printing Only Rows With Values In Them
  309. complex formula
  310. descending order of a series of data
  311. Formula Based on Multiple Sheets
  312. Count non-hidden rows
  313. Conversions in Exel
  314. Countdiff with more criteria
  315. A complex formula, help needed
  316. function help for counting text as a value....
  317. Count if function
  318. Termination within number of days
  319. how do I make "NOW" function static
  320. Beyond the VLOOKUP Limitation: Extracting records after the 1st re
  321. Print Range not connected
  322. how do I highlight rows based on conditional formatting
  323. CONVERT(number,from_unit,to_unit)
  324. How to get rid of #Value when multiplying
  325. Formula, Pivot Table, ??? Beats me
  326. Countif question
  327. Print just the list after performing a "find all" in Excel
  328. shared workbook issue
  329. Subtotal level buttons
  330. VLOOKUP over three spreadsheets
  331. Macro for multiple rows
  332. Question About Date Function
  333. Settign a Maximum and Minimum Row Height
  334. Formula to return data using hyperlink?
  335. table lookup
  336. Check for NON-presence of a string in another string
  337. Can conditional formatting be used where .....
  338. Search cell value in more than one workbook
  339. remove duplicates except blanks
  340. Extract Supplier Name
  341. Text function
  342. Subtotaling
  343. LOOKUP value in a table and return value in first column of same r
  344. Subtraction Function using cells with other functions in them
  345. SUM A SINGLE TEXT FROM CELLS INTO ONE
  346. Pop-up box
  347. Finding and copying whole rows
  348. vlookup based on a different cell
  349. MedianIf multiple range and criteria
  350. Vlookup with part match
  351. how do i resize column letters in excel 2007
  352. Getpivotdata....showing filter
  353. Monthly files
  354. Unstring in excel
  355. Find & replace window
  356. Return Names From List
  357. How do I convert dd/mm/yy date format to yyddd Julian date format
  358. Boolean Math
  359. Counting only displayed cells in the column
  360. Data Lost in Microsoft Query
  361. Lookup value off by one row
  362. Returning A Minimum Figure
  363. Sumproduct with conditions
  364. 3 tier incentive matrix w/ infinite possibilities
  365. Vlookup return Zero if not there
  366. Adding if to Average If Array function
  367. Formula to equal a maximum of 100%
  368. Date Format
  369. Automatic Go to
  370. Opening Files - Macro
  371. Distribution
  372. Spredsheet problem
  373. IF/VLOOKUP between multiple worksheets
  374. sum only if a certain cell contains a date
  375. Find variable unique text within a string
  376. Excel Formulas
  377. "Alert" only if 'not contained in'
  378. Data lost
  379. calculating subtotals for sequential blank cells in 1 column
  380. using button to clear contents
  381. Microsoft Querry
  382. Help with difficult formula requirement
  383. RE: Changing number to mins/seconds
  384. Changing number to mins/seconds
  385. RE: Changing number to mins/seconds
  386. COUNT
  387. Copy down formula macro
  388. Excel 2007
  389. adding/omitting/all the values prior to todays date
  390. Excel 2007 Won't Paste Formulas
  391. How do I create a combo box that is tied to another combo box?
  392. Multi-condition SUMIF
  393. MACRO - I think.
  394. Print Macro - PDF Issue
  395. Concatenate
  396. Comment with date stamp
  397. forecast a financial value at year end
  398. Conditional Formatting
  399. Subtotal function is greyed-out - can't insert
  400. Conditional Formatting
  401. Protecting Cells In A Worksheet
  402. Copy data ONLY from a function cell
  403. Excel 2007, pivot table format issue
  404. Sumif Deviation is positive
  405. Return nothing if criteria is not met
  406. pivot table - get the average of a field
  407. an I get a cell value throught posted hyperlink to another excel s
  408. Counting Individuals NOT Occurrences with than one criteria
  409. help needed to add values with conditions
  410. Modify to eliminate #NUM! error
  411. Excel conditional formatting
  412. & combine two array statements
  413. remove blanks using formula
  414. Formulas
  415. Automatic Record Transfer
  416. how do I copy format (eg colour of cells) in a drop down list
  417. how do I copy format (eg colour of cells) in a drop down list
  418. copy text with comma eliminated
  419. E2561412.CAB using a 2003 Excel in 2007 Excel
  420. If function using cell format as the condition
  421. My excel 2003 does not have engineering functions.
  422. Changing formating
  423. Turn on Automatic Formula Fill in Table
  424. Compare two files and update data from another file base on words ina cell separated by commas
  425. Re: Autotext Query in Excel 2007
  426. Build a sheet name in an Excel formula
  427. Building a Sheet Name in a Formula
  428. Lookup assistance needed
  429. addding/omitting "x"
  430. Excel function - countif
  431. Help with function
  432. Excel dates
  433. addding/omitting "x"
  434. Sum amounts based on date field
  435. Eliminating particular numbers from a column help!
  436. Is there a formula that can do this?
  437. How to use multiple lookups or if statements
  438. Countblank
  439. Look up a text value then count records < a date
  440. change date format dd/mm/yyyy to Julian date format?
  441. Using Roundup in an IF Statement
  442. Excel spreadsheet
  443. Summing a range within a range
  444. checkbox
  445. Help with Nested IF Statements
  446. Excel dynamic calendar
  447. Creating Average IF
  448. XL2002 SUM with a twist...
  449. Why did I use array formula - help
  450. How can print A Id badge From a Excell Work Sheet
  451. Icons on Customized Toolbar
  452. Look-up
  453. Coloured backgrounds using IF
  454. How do I display numbers as Degrees Centigrade?
  455. Counting Individuals not Occurrences in Excel 2007
  456. Leaving a total sum cell blank until other cells are filled
  457. Retain INDIRECT() Data
  458. How to delete all duplicate records - without keeping one of them
  459. problem about count text
  460. How can i copy a 16 digit number to excel from another software(HT
  461. Ascending
  462. File Creation Date
  463. get a list of sequence number that meet 3 criteria
  464. INDEX and MATCH
  465. formula/version 2007
  466. Syschronizing cells across worksheets
  467. Emulating older pivot table "engine" in Excel 2007? Need help...
  468. Pivot table results error
  469. How do I save data in shared spreadsheet?
  470. lookup help
  471. Grouping sheets copies Header across to all sheets
  472. Calendar Text Box all the same
  473. CountIf in Even Rows only
  474. Function Help
  475. Change the name of an auto save
  476. Grouped sheets page formatting will copy the header
  477. Help with suming muliple columns
  478. Pivot Table Summary Error?
  479. Use RANDBETWEEN form & include certain #'s in the range
  480. Lookup Help
  481. Counting occurences with multiple entries
  482. Sheet Protection / Edit Objects
  483. IF function possible?
  484. Lookup Help... Again.
  485. calculated field in pivot - how to edit
  486. Excell protection
  487. Stripe out duplicate data
  488. dj
  489. File Path
  490. File Path
  491. LOOKUP HELP PLEASE
  492. formula in excel
  493. Date Format
  494. get a list of sequence number that meet 3 criteria
  495. File Path
  496. COUNTIF with or + and variables
  497. Flip/Flop
  498. calculator creation, find missing value
  499. forecasting
  500. looking for a function for recurrence of a number in excell
  501. Can lookup do this?
  502. Search for matches in two columns
  503. Inserting text in column dependant on another column
  504. Excel 2003 + Solver
  505. Help with Lookup
  506. adding digits with moving decimals
  507. Average in a month/year
  508. Defind Dynamic named Range up to first error
  509. How do I get the last 7 characters of a no. to another column?
  510. Probability help
  511. Stop Excel Changing Format
  512. File Path - Macro
  513. Which functions and Procedure to use to have desired result?
  514. Sort a coloum on one worksheet according to another coloumn on ano
  515. Sort one coloumn according to another coloumn on another worksheet
  516. Complex function needed?
  517. Turn off auto adjust of row heights
  518. Conditional Formatting within a Time Sheet
  519. Calculating text as values in a row
  520. Counting dates with specific criteria
  521. Populate Text based on conditions
  522. excel pivot trables
  523. Find data in two ranges
  524. Pivot Tables
  525. Need Help Fast! How to Calculate a sales percentage
  526. Colors according to the month
  527. Calculating current grade percentage
  528. HELP please... easy function
  529. Finding the 3 best values
  530. Row Colors
  531. Lookup Function Help
  532. Sheet Protection / Edit Objects
  533. command button to move data
  534. Need greater than = .. less than = combined with index/match state
  535. Formula to copy related information from sheet 1 to sheet 2
  536. Remove blank cells from data validation drop down box
  537. referencing multiple worksheets in macro
  538. vlookup help pls...
  539. Time question
  540. Complex day of the month calandar
  541. Read specific time in NOW() function
  542. macro will not run with shortcut keys
  543. page breaks and printing
  544. Lookup Results Problems
  545. Combine sheets into one
  546. get back a deleted column in error in excel, please help
  547. Compare 2 columns and delete duplicate text
  548. IF statement inside a SUMIF statement.... or alternative method
  549. conditional formatting
  550. aging calendar days
  551. referencing text in an IF statement
  552. When do I use quotation marks in an Excel formula?
  553. Static current date based on when data in another column was enter
  554. Match and combine multiple rows into one
  555. Testing for an Integer result in a formula
  556. How do search a range to generate a value?
  557. Help with Formula in Excel 2003
  558. can you have sub parts relating to a line
  559. Showing 0 after decimal with ROUND
  560. Summing the last 200 days
  561. Excel file saved as txt with justified column numbers when viewed ina txt viewer
  562. Count
  563. a quick way of inserting and naming multiple worksheets in Excel?
  564. If Function
  565. Index & Match Question
  566. Problem with AND function
  567. How to reverse an Excel formula?
  568. How to set a cell to expand to fit text in Excel not shrink fit
  569. Index match issue
  570. VBA for document formatting - HELP.
  571. How to reference cell that changes locations.
  572. Excel 2007 - Change link source requiring multiple entry of passwo
  573. Calculation / Format Error
  574. Excel Rounding of Formular results
  575. show ink on an excel file.
  576. sum accross worksheets using names
  577. Using SUMIF with dates
  578. ??? can u put a word doc into a excel worksheet
  579. Is autofilter & sort disabled in protected cells?
  580. CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS
  581. Conditional formula with text
  582. using conditional formatting with dates
  583. more than 15 numbers in a cell?
  584. how to format a column to corespond with another
  585. I have a column of many many numbers how can i split them up auto
  586. Postive # converted to Negative #
  587. macros vba question
  588. Get part of field name for highest value
  589. Why are my numbers disappearing in excel yet it totals them?
  590. Have the need to sort text code-values within same Excel cell
  591. Function that meets table requirement then multiplies by table fac
  592. If formula with table look up
  593. How toEmail a spreadsheet and preserve the Data List format
  594. Extract names from string based on value list
  595. Excel spreadsheets
  596. Scroll Lock for selected multiple sheets
  597. How to edit text for check boxes
  598. Stripping out characters
  599. 2007 not auto update 2003 links
  600. Can I use the NOW() function in a formula?
  601. Complete Tax Years
  602. Counting calendar days
  603. How to make list of Items displayed in AutoFilter? Any Function?
  604. Hyperlink problems
  605. Pivot Table and External Data
  606. How do I retrieve data from 1 hour ago?
  607. Buy KING EDWARD CIGARILLOS Online
  608. Data validation dependant drop down on unsorted list
  609. how to attach file
  610. Return last and second last "populated" cell in column
  611. counting words
  612. Column header for Max value? Index/array function?
  613. Autofilter unavailable
  614. Copying formulas in Columns and transpose to rows?
  615. Distribution of a Value
  616. Use Formula from another worksheet
  617. Web Excel and Excel Functions
  618. Outlook CPM and Excel
  619. return value from range of worksheets
  620. Help with creating a formula
  621. COUNTIF or SUMIF question
  622. average text value for a ranage of cells
  623. Changing the font of text in a check box
  624. Excel links in Word
  625. calculating time in excel
  626. How can I make a cell red if number is not greater than needed?
  627. Format date with specific regional format
  628. Deifine range ignoring duplicates
  629. Count values once no matter how often they appear
  630. Sumproduct/match problem
  631. Average Function that ignores zeros
  632. Ignore duplicates
  633. Conditional Formatting with range
  634. Need help with formula!!!!
  635. Conditional formulas
  636. I have a column of 32 numbers,
  637. Macro to Clean Special characters for a Range
  638. SUMIF ERROR
  639. Re: COUNTIF
  640. Return result when condition is met
  641. Why does the word REG change to Rag when typed into a cell?
  642. Choose best values in a list
  643. insert new row and copy formula
  644. Problem with Formulas changing to it's actual value
  645. Sum(indirect(Address......
  646. Data Comparison
  647. Weekly Returns
  648. trying to use Indirect function
  649. trying to use Indirect function
  650. IF Function
  651. consective numbering
  652. hyperlink not working in excel 2007, if worksheet is hide or hidden
  653. how to customize the x axis in scatter plot?
  654. copy data for match word from one file to another file
  655. Referencing column to row across worksheets
  656. Count based on string in cell
  657. Conditional format SUMPRODUCT
  658. Cut, copy & paste functions in Excel 2007 are extremely slow.
  659. Re: CF to Color-Fill Row B:G w/Specific Text in One of the Cells
  660. CF to Color-Fill Row B:G w/Specific Text in One of the Cells
  661. Sum If formula
  662. I'd like to know how we can count coloured cells?
  663. Adding numerals with moving decimals
  664. Counting coloured cells?
  665. Notepad or .txt file to excel
  666. Count if or Sum Product
  667. if meets criteria add 1
  668. Re: trying to remove phone: from the column = [phone: 4253331212]
  669. Re: links in protected workbooks
  670. Macros
  671. Re: links in protected workbooks
  672. SumIf Formula
  673. Re: Worksheet Filtering by UserName
  674. Re: Import all txt files macro
  675. Can't Get Formula to work
  676. Count if or SumProduct
  677. RE: Formula to calculate interest only on a short term loan?
  678. RE: Import all txt files macro
  679. Formula to calculate interest only on a short term loan?
  680. Import all txt files macro
  681. links in protected workbooks
  682. trying to remove phone: from the column = [phone: 4253331212]
  683. RE: Vlookup to the left ?
  684. Re: Embed a 'match' statement in sumproduct?
  685. Re: Embed a 'match' statement in sumproduct?
  686. Re: Vlookup to the left ?
  687. Embed a 'match' statement in sumproduct?
  688. Vlookup to the left ?
  689. Worksheet Filtering by UserName
  690. How to extract text from number/text cell
  691. EXCEL 2007 Formula to calculate INTEREST only on a 3 month bridge
  692. Formula
  693. Always show Jan of current year
  694. IF
  695. how do I use only 2 characters in a field in a formula
  696. Changing worksheet references
  697. Row height
  698. Microsoft Visio templates - Stencil for Visio to create IT diagrams &network design
  699. count number of weeks missing for each individual in a database
  700. =IF(NOT(ISNA(VLOOKUP Function
  701. Offset 2nd ref.
  702. Workbooks&Cells
  703. Summary by Months
  704. totaling data from a drop down list
  705. Creating a Sheet Index of all Excel Worksheets
  706. Another Question regarding Multiple Criteria
  707. Calculating total number of days in rolling year
  708. Prevent functions from changing when new rows are added
  709. Double Entry Posting
  710. autofill limits
  711. Validation list based on criteria
  712. Current Month with real date
  713. Need to alphabetize data from separate cells within same row
  714. Room Occupied Checker Formula Help
  715. Printing issues
  716. PRINTING ISSUES
  717. Pull data from one worksheet and place in a new worksheet
  718. Comparing 2 worksheets in Excel 2007
  719. I need a statemnt to identify sales during each month
  720. Can I use the subtotal function while a worksheet is protected?
  721. what does the "carat" character mean in Excel - answer
  722. Re: attendance with sorting
  723. creating data points within collected data
  724. empty arguments recalculation
  725. Totaling VLookup
  726. what does the character ^ mean in an excel formula
  727. Adding a copy of an open window to an excel worksheet
  728. RE: attendance with sorting
  729. SumProduct - With Or Function
  730. INDIRECT doesn't retain data from external worksheets
  731. Importing data to Excel using a keyboard shortcut
  732. How can I do this ?
  733. Countif over a range of cells for various codes.
  734. Calculate from another sheet - special
  735. Sum Number of Rows based on Value in Another Cell
  736. Selcting data from table without repeating plus calc's
  737. need to input alternate blank rows in spreadsheet
  738. Calculate Average in pivot item
  739. Need help on scoring
  740. Not to inlcude zero in COUNT
  741. Linking worksheet and multiple cells
  742. convert text to formula using VLookup
  743. Don't Display #N/A
  744. Dealing with blank cells
  745. RE: How To?????
  746. help with date formula
  747. returning the value in Colunm C using Colunm A as Ref
  748. Conditional IF Or Format
  749. multipule calculations in a single column
  750. Precedent lines