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. re done Match formula needed
  2. Stopping a formula once a condition has been met.
  3. match formula needed
  4. How do I evaluate whether a character is present in a cell?
  5. repeating values
  6. Move data
  7. Recalling more than one cell by inputting a single command
  8. Can someone help me with this formula please????
  9. Adding digits with moving decimals
  10. Re: Can I use AVERAGEIFS?
  11. Re: How to find a particular word?
  12. ADVERTENCIA DE SEGURIDAD - SE HAN DESHABILITADO LAS CONEXIONES DE DATO
  13. Re: Can I use AVERAGEIFS?
  14. Frequency of date
  15. Re: How to find a particular word?
  16. Can I use AVERAGEIFS?
  17. RE: How to find a particular word?
  18. How to find a particular word?
  19. Re: Is there such thing as deoncantenate in excel?
  20. Is there such thing as deoncantenate in excel?
  21. USING SUMPRODUCT
  22. Access-Excel querry problem
  23. Autofilter not grabbing last row
  24. Comparing text strings
  25. Re: Conditional formatting referencing multiple cells.
  26. Custom Sort
  27. adding next years value
  28. Membership list: column for no. of over 18s?
  29. Re: Conditional formatting referencing multiple cells.
  30. More Than VLOOKUP()
  31. Conditional formatting referencing multiple cells.
  32. Excel (2003) crashes when referencing to external workbook in freezeframe
  33. Conditional Formatting with Time
  34. upgrading to office 2007
  35. Splitting text divided by carriage returns
  36. Counting with conditions based on another range
  37. Make a cell content not printable
  38. Text Box with conditional formula
  39. Re: Data validation causing problems when using a data form in Excel2
  40. summing adjacent data in a worksheet
  41. Adding one to two figures with moving decimals
  42. Number of hrs worked in a week, based on dates in a different column
  43. Blank Cells vs. Zero Values
  44. Counting blanks as zeros
  45. need help using "RANDBETWEEN" in excel
  46. Error showing up as #VALUE! in if function
  47. Conditional Format Formula Help
  48. Extracting charecter from a string
  49. Excel
  50. Prob an easy one: How do i copy a formula EXACTLY as it is
  51. Excel 2003
  52. Excel with macros to html covnersion
  53. BLANK cell as a result of IF condition
  54. Text Box with conditional formula
  55. Re: Formula
  56. Adding multiple intances from several sheets?
  57. Counting rows that satisfy multiple conditions
  58. Re: Formula
  59. Formula
  60. QTD function?
  61. Multiple selections of rows & columns by clicking in one cell
  62. SUMPRODUCT
  63. RANDBETWEEN PROBLEM
  64. Adding one to two figures with moving decimals
  65. RE: Time entry auto changes to date and then time ?
  66. SUMIF Formula
  67. How do I advance cell numbers?
  68. Time entry auto changes to date and then time ?
  69. excel formula needed
  70. RE: how do I copy the page format form one worksheet to another?
  71. how do I copy the page format form one worksheet to another?
  72. Finding values in different rows/columns
  73. RE: Trickey SumProduct with Multiple Conditions
  74. Re: Keeping references while changing worksheets
  75. Trickey SumProduct with Multiple Conditions
  76. Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet.
  77. Re: Keeping references while changing worksheets
  78. converting email address formats
  79. Excel Macro issue
  80. Re: Sum (throw out highest and lowest)
  81. How do I add a variable range of columns depending on criteria
  82. Comparing data sets with +/-1 tolerance using conditional formatin
  83. Sum (throw out highest and lowest)
  84. RE: How do I alphabetize & concatenate cells & maintain row integrity
  85. RE: How do I alphabetize & concatenate cells & maintain row integrity
  86. How to calculate a coloured cell as a number for a sum?
  87. User Defined Function returning #Value!
  88. How do I alphabetize & concatenate cells & maintain row integrity
  89. RE: Adding one to two figures with moving decimals
  90. Randomly Select cell from filtered list
  91. Sum macro
  92. Formula Problem in Excel 2003
  93. Lists, lookup, if???
  94. Vlookup, COUNTIF, IF or Nested
  95. Cutting list summary - function??
  96. HELP! Lookup, countif or if statement
  97. function help, sumif??
  98. Automatic Formula Update
  99. Subtotal of values in cells containing formula
  100. Cell entry
  101. Data validation - restrict duplicate value
  102. Excel Graph
  103. Adding one to two figures with moving decimals
  104. formula looking for an either/or solution in same column
  105. adding moving decimals in more than one cell
  106. how do i embed an editable word document into excel 2007?
  107. Conditional Formating multiple cells in 1 row based on a list of d
  108. Keeping format Data returned in IF Statement
  109. The code below worked for a few days and just totally stoppedworking.
  110. Can someone please tell me why my code stopped working???
  111. formula to add a number to a long string **
  112. xlsx will not open from Explorer, opens from Excel 07
  113. Changing Color of the Cell under Certain Conditions
  114. I am using the COUNT function to determine the
  115. Formula (off form) that completes form data based on a result
  116. Manual Calculation in Excel 2007 with Calculate mode set to Automatic
  117. Find a Value the first Time It Occurs
  118. use dates to create a summary report
  119. Formula for summary from two column
  120. Switch names
  121. Counting Duplicates Once
  122. using the 'Convert' function
  123. Another Stingconcat question
  124. Sum cells using criteria from a row and a column
  125. Re: Match Multiple Criteria and Return values positioned above the zero
  126. Is anything wrong with this formula?
  127. Change date format in Excel footer
  128. using percentile in an array formula
  129. ??
  130. Simple I think
  131. Formula needed please :-)
  132. Filldown stops abruptly
  133. collect data from mail merge
  134. Formula for extracting out text entries
  135. Cell will not format
  136. Multiple Data Ranges in this Countif
  137. RE: How to compute Frequency of non zero cells?
  138. Collating entries from multiple sheets
  139. Excel Column Widths When Printing
  140. How do I add multiple comments to a cell?
  141. Count non-unique items from list of unique items
  142. Can an "inline" hyperlink be created in a cell?
  143. Alarm
  144. Consolidation of Data from more than one worksheet file
  145. Calculate
  146. Not responding......
  147. links disabled ??
  148. Round numbers to get to the nearest 0.09
  149. Form Advice
  150. data in rows not showing in auto-filter drop down
  151. Row Number
  152. Conditionally summing data from two columns depending on their value.
  153. VLOOKUP
  154. Conditional formula drop down box
  155. Excel 2007 row markers
  156. RE: sorting
  157. Adding data only if adjacent to cell labeled "male"/"female"
  158. Re: sorting
  159. Pasting into protected cells
  160. Summ entries using a dynamic sheet name
  161. Replace data in a column
  162. Returning page-count to a cell
  163. Spreadsheets
  164. looking up cell address
  165. Re: Splitting of columns in different worksheets
  166. Display file name without the file type extension
  167. Enter data from same cell in different sheets into a new sheet
  168. Conditional count if function
  169. Re: rows disappeared
  170. Re: Splitting of columns in different worksheets
  171. Offset/Match when there is more than 1 result
  172. Excel 2003
  173. Where is the "File" menu?
  174. Repalce value
  175. Opposite direction
  176. Testing cell value for greater than 0
  177. How do I link an incrementing file name like reports1or reports2
  178. replace cell value
  179. Counting cells with specific month in
  180. How do I combine information from two separate spreadsheets
  181. How to insert the tab name in a cell
  182. using row number or column letters in formula
  183. Can I use a worksheet name in a formula?
  184. pvt table field settings!
  185. Automatically Record Date in a cell
  186. Attaching documents to Excel
  187. days calculation between dates
  188. Amortization w/ variable interest rate
  189. how do you total columns that are not adjacent
  190. Excel in Windows 7
  191. VLOOKUP would begin one row below what the first one found?
  192. how replace comma with point in import data
  193. count how long it will takes for a number to repeat
  194. count last number appear
  195. Mutiple conditions formula to assign segmentations and coverage
  196. Sumit
  197. IF calculation
  198. Validation of Employee Timesheet
  199. FIND from right to left instead of left to right
  200. Saving 2003 up to 2007 ?
  201. Calculate the function in a cell that is created with CONCATENATE
  202. If Hours >0, If Volume <= 0,(and vice-versa) then....
  203. Incremental dates based upon specifications
  204. determine formula for percentage
  205. If Statement
  206. Formulas
  207. count if condition in two columns
  208. Stopping IF command from entering zero or 1 for blank cells
  209. How to select one record of each from a column
  210. Index-Match, with Like or some other Function
  211. how to divide the number in one cell into multiple cells
  212. Converting standard time to military time
  213. Date conversion
  214. SUMPRODUCT
  215. Conditional Formatting
  216. vlookup fails, and previous ones also now fail!
  217. SUMPRODUCT Function
  218. Pivot table
  219. =today() = weeknumber
  220. count - but exclude counting cells with a formula
  221. Multiple IF Statment not working
  222. Date to close file
  223. freeze panes cannot be saved
  224. need to automate a sheet re-organization
  225. How to compress an Excel work book?
  226. SUM multiple criteria
  227. Using SUMIF to add data between a range of dates
  228. Conditional formatting on autoshapes
  229. Vlookup formula
  230. Return value from a Two Variable Data Table with Dates
  231. How long for the first group
  232. Incorrect Total in Excel 2007
  233. subtotal with sumif nested
  234. Re: Auto Fill
  235. Can columns be protecteded by an assigned user?
  236. Grouping into groups
  237. Time In-Time Out/No. of Units
  238. DB Function?
  239. format
  240. How to retrive password protected worksheet but forgot password?
  241. Nested IF functions
  242. Using SUMIF i want to say IF A=1 & B=2 then sum C any help pleas
  243. RE: projections
  244. Next-To-Last, Non-Blank, Rightmost Value in a Row
  245. Auto fill typing in cells problem
  246. Sumproduct or ?????
  247. Counting Unique Names
  248. Current Yield vs. Yield to Maturity at low prices
  249. Excel F2 not working...
  250. "Cannot shift objects off sheet"
  251. getpivotdata wildcard?
  252. modified vlookup help
  253. Macro to merge 3 rows multi times, columns A:K only
  254. Formula/calculation returning a 0 instead of actual sum
  255. Date and User restriction coding
  256. 25th percentile (cycle time)
  257. HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN
  258. Why doesnt this work?
  259. PivotTable Sum 2 Columns
  260. Count formula
  261. Sumifs (I think)
  262. Sort Date Column
  263. need help writing function
  264. vlookup and sum- to lookup a name and return and sum of all instan
  265. DATE
  266. Condense data for stock ordering
  267. How do I display results of a summation in the following format?
  268. conditonal format A2 using value in another cell C2
  269. Auto save and close
  270. VLOOKUP formula for multiple worksheets
  271. Need two different data types to give me a total
  272. Find Function behaving differently in different spreadsheets
  273. link values from same cell of 20 worksheets into column on one she
  274. Referencing the latest entry in a column
  275. Referencing the latest entry in a column
  276. Adding hours scheduled for week
  277. How to count with values from multiple columns?
  278. Conditional format to highlight only cells with formula, not const
  279. Comparing values of two charts
  280. Multiple Time Range Conditional
  281. Conditional Multiple Time Ranges
  282. Can't solve simple? problem. Can some genius out there help!
  283. have one sheet update others in workbook
  284. Hide Rows or Columns with +/- button above row/column label headin
  285. 25th percentile (cycle time)
  286. Amount Owing
  287. Lines are auto hiding in excel sheet 2003?
  288. Pricing Chart
  289. I have a column of numbers, some negative, some positive
  290. How to stop scrolling in side by side comparison?
  291. Concatenate email addresses
  292. if statements
  293. Timesheets
  294. Pivot Table Problem
  295. In excel change color of a range of cells based on a cell value
  296. Price Comparison formula
  297. drop down list
  298. RE: Multiple If Then Statement based on ranges
  299. edit, fill, justify
  300. Need formula to return exact match
  301. Return a name in the same row
  302. Vlookup when lookup criteria is not an exact match
  303. Why are the two codes below not getting the right formula for myworksheet event change formula?
  304. Excel MATCH Function
  305. Sum Multiple Criteria
  306. date text to change colour when it gets over six months
  307. Pulling data from another workbook
  308. Averageif is not working
  309. Hours and sum of hours
  310. calculating number of days belonging to each month within a given week
  311. move data from columns to rows
  312. Vlookup with AND, OR IF statements
  313. I have a worksheet
  314. i want to set conditional format to cells containing odd numbers
  315. Multiple formats in a cell
  316. Value Replacement
  317. How can I use the * wildcard in an array formula
  318. find a data in a list that have a few hit
  319. Fun with SUMPRODUCT
  320. Conditional Formatting on Autoshape
  321. COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED
  322. Excluding Cells From Avg Cals Due to Info in different col
  323. macro adjust
  324. Complex conditional summing - array COUNT works, array SUM gives#VALUE
  325. Need to separate multiple numbers in one cell
  326. Inserting a cell value from an "IF" function
  327. Conditional formatting of dates in two cells using Excel 2007
  328. Copy specific data form sheets into master sheet
  329. conditional Formatting cell wildcard
  330. Count IF Formula
  331. Combine Two Similar Arrays
  332. True false function for alpha data
  333. how do i turn on side by side in excel
  334. Greater Than
  335. Eliminate Duplicate Entries in Order to Create Labels Using Mail M
  336. Index and References within a workbook
  337. what would it take to.....
  338. I selected row 1 and row 2 to freeze and it is freezing at row 12
  339. my first excel experience (share portfolio)
  340. Copy sheets into one book
  341. If Function
  342. Which function and how?
  343. How do I roundup to .9 and rounddown to .9
  344. Re: Formula based on variable range
  345. Quick VBA Worksheet Change Event or Selection Question:
  346. Function for different array
  347. median if
  348. Rows to Columns
  349. Countif and values greater than zero for a named range
  350. Error in subtracting times
  351. Error Messages
  352. Easy eay to copy / paste a formula in column
  353. Insert row with a locked cell
  354. Fill down conditional formatting series
  355. Format single words in cells
  356. Vlookup Help
  357. multiple formats in a cell
  358. Modify and add extra condition
  359. Find the maximum value in a row or column with text and numbers
  360. separating multiples digit in a cell into individual cell
  361. Can't open excel file
  362. Function to set Date
  363. Apply CF to Row after CF was applied to Column
  364. CF to Row after CF is applied to Column
  365. CF for Row when CF is applied to Column
  366. CF Row after CF applied to Column
  367. Date is displaying 00-Jan-00 when I type in 11/16/09.
  368. Index & Match doesn't seem to work
  369. Count Formula
  370. Using Count Formual with checked boxes
  371. FVSCHEDULE
  372. Formula to count the number of boxes checked
  373. Sumif
  374. Final entry in array
  375. If (Vlookup >0) working, but what if Vlookup cell does not exist
  376. Median If Function
  377. Help with my Excel database
  378. replace
  379. Count ifs
  380. RE: Search function ono a hompage to search over multiple workshee
  381. Looking up Text as a result of a formula
  382. IF statement based on need to recalculate
  383. Index
  384. match first and last name and insert column into existing sheet
  385. Rounding down with a calculation
  386. Cell highlighting question
  387. If function confused with 0.1
  388. How to calculate standard error?
  389. how do i average the 3 max numbers in a column?
  390. Countif OR Sumproduct OR Istext????
  391. Last non-zero
  392. Find the last 4 cell entries in a row
  393. help with Linking excel
  394. how do I copy specific rows without copying each row individually
  395. IF function
  396. how do I copy every 2nd row
  397. column A matches f places the value from g in column b what funct
  398. need a formula
  399. How do I get random numbers from a certain range?
  400. Why Excel Does not increment by 2 or 3, odd/even numbers?
  401. Reduce Fie Size, Speed Up Calculation
  402. How to lock cells after a certain days
  403. formula when clicked on gets information form a percifice cell.
  404. excel help please. Urgent!!
  405. TIME X MONEY
  406. How to count rows with changing data
  407. multiplying
  408. Hpw do I delete multiple empty rows found between filled rows?
  409. Count first occurance of text
  410. Reference constant cells in different files from a master workbook
  411. Re: help functions
  412. Finding the unknown number
  413. MTD/YTD FUNCTION
  414. Overtime Calculation
  415. Help With IF INDEX AND MATCH??
  416. Help with Formula IF INDEX AND MATCH
  417. Finding Unknown number
  418. Count unique with multiple criteria
  419. clear unlocked cells macro help please
  420. FINDING THE UNKNOWN NUMBER
  421. Can cells be split ?
  422. What's happened to the Sort in 2007?
  423. Multi Criteria Countif
  424. Random -Median, finding the next number
  425. Formula
  426. inserting current windows user id into a cell
  427. Rounding up with IF
  428. how do I save my quick toolbar settings in Excel 2007?
  429. How do I insert a drop down calendar in spreadsheet?
  430. VLookup - Showing the values which DO NOT Match
  431. Converting 0 values to Blanks
  432. Date in Spreadsheet that changes to random numbers
  433. Re: help functions
  434. Copy formula down - cell references change - result is same for al
  435. ISFORMULA(Cell Referance)
  436. Vlookup Worksheet
  437. IF Function
  438. INDEX MATCH
  439. Count if?
  440. Re: help functions
  441. Invoice with Data Sheet
  442. One Formula Referenced In Many Cells
  443. Invoice
  444. Countif with multiple criteria and date range
  445. Excel 2007:Share Workbook with import live Data
  446. can hidden sheets be prevented from opening without a password?
  447. Dynamic name range for use in data validation
  448. Another Formula Question
  449. Filter or function for comparison
  450. Range with 2 validations
  451. How do I increment the row and column of a cell in a formula?
  452. Referencing External files with slightly different names
  453. Leave final cell blank
  454. How do you make the INFO("directory") function work?
  455. Looking for the correct excel formula
  456. data sort with excel 2002
  457. Resize image using macro
  458. Return the current Yearly Quarter based on date
  459. Date
  460. Consecutive date calculation involving holidays
  461. go to a particular sheet Gord Dibben
  462. Automatic deleting graph segments
  463. Trying to add numbers that include text.
  464. Create a document from a spread sheet using data from another spre
  465. Auto insert of a pivot table?
  466. I want to freeze 2 columns (not next to each other)
  467. Hi
  468. SAVE AS CSV, KEEP DATE FORMAT
  469. Pivot Table Macro
  470. Hiding a cell with a formula.
  471. How do I set up an ordering sheet based on averages of past sales
  472. Conditional formula for dates
  473. Simple Question - Sum If??
  474. Lookup for the first occurrence
  475. Lookup Formula question
  476. Concatenate and IF?
  477. StringConcat(", ",A1:A1000)
  478. vlookup against one of two options?
  479. Need formula to round number up to always end in X.X9
  480. Using solver function in a locked (protected) worksheet
  481. SUMPRODUCT & Wildcards
  482. change year in downloaded calender template
  483. RECOVERING FILES--HELP ME!!!
  484. How to find lowest points
  485. Sum same cell across multiple worksheet function does not work...
  486. Fill Formula please
  487. Formula problem
  488. OFFICE 7
  489. highlight differences
  490. Copy data to different sheets
  491. function help!
  492. How do I formulate total before Gst?
  493. Sumproduct Subtotal
  494. How do I Undo a Page-Break in excel
  495. 2003 Exxel
  496. Sorting a column that contains both text and numbers
  497. Vlookup Help please!
  498. Multiple Criteria Date Count formula
  499. histogram dynamic bin count
  500. Lookup function
  501. formula help
  502. Formula Count dates multiple criteria
  503. Copy/paste data across filtered rows
  504. Pivot Tables
  505. Formula Referencing Columns By Date
  506. Validation Drop Down List if cell meets criteria
  507. Removing check boxes (forms toolbar)
  508. Conditional Formatting Help
  509. Calculate row/column number in reference formula
  510. Old address information updated to current addressi
  511. Autofilter
  512. INDIRECT Function
  513. Hide Rows based on value, but not using autofilter
  514. Worksheet formula incorrect after copying to another worksheet
  515. Apply Filter to source of Pivot Table
  516. How can I count unique values
  517. Conditional Formula w/Lists
  518. Create Formula Using Select Values of a Cell
  519. Operation requires the merged cells to be identically sized
  520. need help with a downloaded template that was shared by steve
  521. daverage worksheet function
  522. Creating a formula
  523. How Can I ?
  524. days calculations
  525. days calculations
  526. Multiple worksheets
  527. Add In vs functions
  528. Create One Formula for Entire Column
  529. formulas
  530. Create Generic Formula for Entire Column
  531. lookups and sums?
  532. Protecting data after entering
  533. Hyperlink to a specific worksheet in another workbook
  534. Can you insert a shortcut to a different workbook?
  535. Normal distribution curve
  536. How to highlight what's different between two columns
  537. RE: Error Message when I open Workbook
  538. How to Stop calculation on one specific sheets only
  539. how many duplicates in the one column
  540. Error Message when I open Workbook
  541. Vlookup returns n/a for all lines - what am I missing?
  542. RE: Hyperlink to a specific worksheet in another workbook.
  543. RE: Hyperlink to a specific worksheet in another workbook.
  544. Hyperlink to a specific worksheet in another workbook.
  545. How to copy a spreadsheet in shared workbook
  546. Compare List Summary of Results
  547. percentage in brackets
  548. Adding cells with formulas
  549. Re: Concatentate text and insert blank line
  550. RE: Concatentate text and insert blank line
  551. RE: Concatentate text and insert blank line
  552. Concatentate text and insert blank line
  553. Excel 2007 Move or Copy worksheet
  554. adding values lists
  555. If then statement
  556. HOW TOCREATE A DROP-DOWN MENU FOR MACROS
  557. Remove Text
  558. NETWORKDAYS Formula
  559. take some data column into next column ie ABC-DEF-GHI i want DEF
  560. Advanced Filter Question
  561. Formatting cell
  562. Multiple IF/AND/OR statments
  563. Working with Excel to control stock
  564. sumproduct with multiple variables
  565. average sum of 5rows
  566. multiplying by variables based off original number
  567. 12 dependent series
  568. Limit access to range of cells
  569. simple counting gone awry
  570. Workaround no COUNTIFS in 2003
  571. Help in counting and summing cells based on multiple conditions
  572. data entry needs to be changed in multiple files
  573. The ____ qualifier references the header row in the table.
  574. Convert currency to general
  575. How do you combine a date field and a time field into one?
  576. DCOUNT - date as a field only works when entered as a number
  577. hyperlink to website and then to information in a certain cell
  578. Week ending calculation
  579. Convert table by date to array
  580. Product formula help
  581. Using Format Painter on multiple cells
  582. Sumproduct igoring hidden value
  583. Converting Pounfs to US Dollars
  584. Data validation error message not showing
  585. Lookup a location # with multiple dates
  586. Can Excel look thru column of text & derive most commone
  587. pivot table field structure!
  588. COUNTIF - across 2 columns
  589. Running total for 2 columns IF column 3.......
  590. Long list into Table to contain only ten
  591. simple sum unless blank
  592. simple formula help
  593. produce a criteria based list
  594. Account # is a known the description is not, need to create a look
  595. account # entry needs to return the account description
  596. Nested IFs
  597. If..The Statement to automatically format a name
  598. [Q] How to use Excel to show est. compounded value displayed by mo
  599. Help with a formula in an excel 2007 worksheet.
  600. How do I customize the available fraction formats to fourteenths?
  601. Can MSN Money stock quotes be used in Excel 2007. Smart tags suck
  602. RE: complex if statement
  603. complex if statement
  604. RE: nested sumif?
  605. Sum a range based on another range of cells
  606. nested sumif?
  607. PMT function and 1st payment partway through a period
  608. % Variance
  609. Lookup Wizard
  610. Re: Uneven column lookup
  611. SUMIF
  612. help simple SUM
  613. Conditional sum wizard
  614. formula for sum
  615. MIN from another worksheet
  616. AVERAGEIF
  617. One command in one cell initiating another command in another cel.
  618. Re: Uneven column lookup
  619. vlookup Function
  620. IF THEN
  621. with "show formulas" justify
  622. Summing one column based on criteria from two other columns
  623. Match with 3 criteria
  624. Summing values within a matrix who are both in a column where theheaders are within a certain numerical range and in a row where the rowheaders are specified.
  625. How do you add 1 to an invoice number in Excel.
  626. DAVERAGE, MIN, and MAX from another worksheet
  627. IF statement and text
  628. Renaming a file while maintaining links
  629. Format dates from cvf file
  630. Execel file auto save
  631. Excel cell showing Yr/Mo/Day in numbers only (09/11/06) can it b.
  632. Why can't I sum several vlookups ??
  633. exclude non numbers
  634. RE: Function that will look at letter in a column and return a number
  635. Function that will look at letter in a column and return a number
  636. Help Please - Lookup in an array that has duplicte values
  637. matching 1 to 1 and 1 with variations...
  638. Using Excel in Formatted Output
  639. Multiple levels of worksheet protection
  640. returned calculation incorrect
  641. Return a value from Chart 1 depending on the value typed into char
  642. Help Pls Copy 1 Random Result To Many On Another Sheet?
  643. Conditional formatting based on adjacent cell?
  644. Lookup values, compare and paste
  645. Why is AutoSum iinoperable w/protection when column is unlocked?
  646. Counting within groups
  647. Round Off
  648. Thanks
  649. IF statement
  650. Help with changing column reference in formula
  651. Excel Auto Filter Problem
  652. Returning a Text Value
  653. Using (SUM(IF(FREQUENCY....to determine unique values
  654. Markup/Cost formula help...
  655. Problem with Vlookup and Data Validation
  656. Sort all columns based on one colum
  657. Easily mailing list from Data File
  658. Sumproduct not working
  659. INDEX, MATCH, IF function does not work
  660. Sorting & pivot table
  661. Macro error when trying to open workbook
  662. get value of previous cell
  663. How do I repair corrupted data from a restore in Word and Excel?
  664. Counting cells only if cell X equals "yes"
  665. Trying to lookup values on another sheet
  666. Addition errors with Decimal Places
  667. Nesting Functions?
  668. Return matching value
  669. Open a worksheet by refrencing a number in 1 cell
  670. Count cell A1 only if cell B2 = Yes
  671. Worksheet print sizing/scaling without impacting a logo image
  672. add value of cells based on the formatted fill color
  673. Using the Countif, Countifs option for Excel
  674. Counting
  675. Averageif function with range that includes non-consecutive cells
  676. How do I get started using the Countif, Countifs option with Excel
  677. Excel is asking for a password while I never set one
  678. Permanently link Col A edits, inc 'insert row' in multiple workshe
  679. Is it possible to pick up formatting from range using index match?
  680. Re: Please can you help me
  681. Conditional formatting comparing two columns
  682. Permanently linking Column A in many worksheets
  683. How do I correct a header in a custom view?
  684. INDIRECT function to reference a named range
  685. Calculating a future date using system clock & time remaining
  686. My cursor is highliting 3 cells instead of just one.
  687. sequential numbering exceptions
  688. Calculating a percenatge based on dates
  689. Re: Lookup with AND i think
  690. Match date to today
  691. Adding cells but leaving blank if not populated
  692. Conditional age grouping
  693. Dynamic of Excel data
  694. Drag & Drop
  695. Picking up dates from within a string
  696. sumproduct i think
  697. Text stops wrapping within the cell
  698. How do I a calculation
  699. Summing a range of cells based on criteria in another range
  700. mmb- fiscal year calculation--
  701. If then else needed in Excel 2007
  702. =DSUM problems
  703. Macro to create date when sheet opens and then remain static when
  704. Wild characters in function?
  705. How do I find like data in multiple worksheets?
  706. Concatenate question on limitations
  707. XIRR #Num! Error
  708. Complex if
  709. Excel row height v. printed page
  710. Removing Links
  711. How do I produce consecutive invoice numbers in Excel?
  712. count
  713. Formula Help
  714. HELP. I need an "IF" formula with a lot of information
  715. Lookup date between 2 dates
  716. Excel and weird behave
  717. 2 criterias in lookup
  718. Print Multiple worksheets
  719. toolbar keeps coming back
  720. HELP! I need to make an IF Statement comparing date/time fields..
  721. VLOOKUP and Referencing a Range in a Formula
  722. Link
  723. sorting and matching in excel
  724. I need to delete the values in some cells,
  725. conditional format question
  726. Formula to get number of days excluding Fridays in a given period
  727. cant pass array to excel from c++ using xloper structure
  728. Selecting right part of text string
  729. Special Paste
  730. how do i create a dropdown box that also filters information
  731. In EXCEL - inserting box that toggles between a check mark & not.
  732. Adding/Subtracting military time
  733. Custom pivot formula
  734. Complex Count formula
  735. Conditional Format
  736. how to count if a cell value falls between two numbers
  737. sum product if
  738. combo function of adding %
  739. Format a Telephone number
  740. Posts not showing up - posted through OE
  741. Posts not showing up - posted through CDO
  742. Lookup matching two values
  743. Formula to calculate either "-" "+"
  744. IF statement and Combo Boxes
  745. How do i create an IF func to return values from another spreadshe
  746. evaluate a concatenate expression
  747. COUNTIF Function Formula Question
  748. Sumproduct not working
  749. How can I link to a chart that is a full sheet?
  750. Uk Date Format to US Date Format