PDA

View Full Version : Excel Worksheet Functions


Pages : 1 |  2 |  3 |  4 |  5 |  6 |  7 |  8 |  9 |  10 |  11 |  12 |  13 |  14 |  15 |  16 |  17 |  18 |  19 |  20 |  21 |  22 |  [23] 24 |  25 |  26 |  27 |  28 |  29 |  30 |  31 |  32 |  33 |  34 |  35 |  36 |  37 |  38 |  39 |  40 |  41 |  42 |  43 |  44 |  45 |  46 |  47 |  48 |  49 |  50 |  51 |  52 |  53 |  54 |  55 |  56 |  57 |  58 |  59 |  60 |  61 |  62 |  63 |  64 |  65 |  66 |  67 |  68 |  69 |  70 |  71 |  72 |  73 |  74 |  75 |  76 |  77 |  78 |  79 |  80 |  81 |  82 |  83 |  84 |  85 |  86 |  87 |  88 |  89 | 

  1. Unprotecting worksheet/workbook in Excel 2007
  2. Formatting and IF Statements
  3. Remove space in front of number in a cell?
  4. Find value within a range and extrapolating....(tiered commission)
  5. Summing multiple account #s in one cell, by referencing
  6. How do i edit links automatically?
  7. Expire count down
  8. conditional formating If A1 or B1 is blank then C1 (Font Colour Ch
  9. why does when i drag a formula in excel gives the same value?
  10. working on a cell formula
  11. Identify numbers that only occur once in a column.
  12. Hyperlink Update
  13. Excel 2007 Combining two tables
  14. Attempting to Copy a IF Function
  15. Multiple Vlookup
  16. What does this formula mean?
  17. Using SMALL Function with select data
  18. nested subtotal with sumproduct
  19. Pulling partial information from a cell
  20. Fill Down reference of even number rows
  21. SumProduct with Date Range and One Condition that is Text
  22. unsorted lookup
  23. Combining functions: Subtraction and IF
  24. VLookup multiple values - sum returned values into single cell
  25. value error
  26. Vlookup
  27. Help in color index function
  28. Number of days in a quarter between two date ranges
  29. Linking Workbooks
  30. Unable to activate "total row" in design tab
  31. Average time values
  32. How do I add a control check box to control other checkboxes?
  33. sumif or sum production - 3 or more criteria
  34. Mix text and numbers with leading zeros
  35. need formula to count non-zero items in an array based on a vlooku
  36. text as a number
  37. Conditional Formatting of Checklist with several date variables
  38. In a formula or function, what do the symbols "" mean.
  39. How to use OFFSET to determine DUPLICATES in a list?
  40. Last Friday of the month
  41. Hybrid vlookup - sum function
  42. converting vertical inches in tank to gallons (have manual chart)
  43. return first value greater than zero
  44. A mysterious if function to return a specific balance?
  45. Using Conditional Format/Icon Set With Dates
  46. sum a range based on criteria in rowdata and column name
  47. Shading Cells based on Date
  48. Formula Query
  49. Toggle Button
  50. Why result = 4
  51. Vlookup with either/or
  52. named range link
  53. Address can not be more than 30 characters
  54. how do i convert a flat rate into a reducing rate?
  55. Looking for alpha characters in a field
  56. Last closing stock number
  57. IF and SUM functions
  58. Average formula
  59. Drop down tabs that can auto fill certain information?
  60. URGENT: Can you insert a formula into a reference ie $B4:$C(row(x
  61. Vlookup returning a YES or NO
  62. Using LOOKUP without values in ascending order
  63. Concatenate with carriage return- how to remove blanks?
  64. counta and or if
  65. How can make a formula to add add the nominators and denominators
  66. looking a value in an array text values
  67. Conditional formating formula
  68. Match based on calculated value
  69. summing times
  70. COUNTIF Across multiple worksheets for "x"
  71. VLOOKUP returns unwanted/wrong values
  72. Create a drop down that adds up a price
  73. Formula to search for a word and put that entire row in a list
  74. Vlookup problem
  75. Complicated Countif application
  76. VLOOKUP using FALSE returning blanks and #N/A
  77. Data Validation w/o Cell Content Deletion
  78. how to lookup a value in a list and return multiple corresponding
  79. Array Formulas
  80. IF question or MACRO ? Which to use
  81. Assigning a word to a number
  82. HLookup help
  83. Detailed Function (or Macro) Needed... Help
  84. COUNTIF with OR
  85. Calculate days in a month
  86. nested vlookups
  87. number
  88. Showing the cell to the Left when certain criteria are met
  89. Conditional formula using MIN function doesn't work
  90. VLookup help Office 2003 Professional
  91. Getting "Creat List" function on excel 2002
  92. Compatibility Mode to Excel 2007
  93. named range and link
  94. how do I lock the first tab of multiple worksheets
  95. MS Excel, Location: Defined Names
  96. Count/Sum based on mutiple criteria
  97. Saving a value in another cell
  98. Match using array of column and row references to match with
  99. Financial Numbers not properly adding
  100. Function needed
  101. Worksheet Total and Macro
  102. Text Formula
  103. Dividing multiple cells by 1000
  104. INDEX MATCH formula
  105. Frequency Question
  106. Condtional formatting in Excel
  107. Find Feature with Macro
  108. Rounding in Excel
  109. Assign a number to a word
  110. Find and Replace one row only
  111. How to create multiple lists each comprising data from previous li
  112. Alternate Row Shading (Visible Rows Only)
  113. HOW DO I CREATE MULTIPLE LISTS
  114. Formula to sum up customers totals from other sheets
  115. Sum Indirect Using R1C1 Style
  116. Display a cell to the left with some changes
  117. Sorting and maintaining formula integrity
  118. Setting Preferences for Multiple Worksheets
  119. HEADER and FOOTER
  120. if questions
  121. Need an Excel formula
  122. Blocking/Disabling selected worksheet
  123. cross referencing
  124. Count values from Pivot Table
  125. IF Statement
  126. Adding up a column of percents
  127. Average formula limitation
  128. Update Source data in a formula
  129. some type of IF function
  130. Adding Cell to the left
  131. ASSIGN NUMBER SCORES TO LETTER GRADES
  132. Format Time as Text
  133. Using SUMPRODUCT with a VLOOKUP
  134. Text entry into excel
  135. Help with If statement to subtract time (follow up)
  136. sum of info in a range based on dates
  137. allow a user to edit ranges in a protected worksheet
  138. What is the formulae to find out a %
  139. Paste Special Comments
  140. IF formula returning a colored cell
  141. Nested IF too long - other suggestions?
  142. Lookups???
  143. To list down all SN (Serial Number)
  144. Help with if then function
  145. Help with a formula and cell referencing.
  146. Average values in date range
  147. exel formula for numbers to text
  148. Excel - viewing hidden rows
  149. Find top 5 highest values/percentage within a table
  150. Vlookup - maybe?!
  151. DELET PERTICULER WORD FROM THE EXCEL SHEET
  152. HEADER & FOOTER
  153. Creating DDE link to DDE server in Excel 2007
  154. How I find specific character??
  155. Need help with function please
  156. checkbox to work when emailed
  157. calculate cells over multiple worksheets
  158. RE: using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours
  159. Display File Name in Cell
  160. Excel Warning
  161. subtraction issues
  162. using if statement to subtract 24 hours from time
  163. Milenko Kindl pulls out
  164. Sales Report
  165. Cells w/ user defined function do not auto update
  166. ιηƒσямαтινє αη∂ ιηтєяєѕтιηg !!!
  167. The FV function
  168. Top 10 Things To Look For In A Web Host
  169. Formula Needed
  170. VBA Password
  171. Excel Formula Needed
  172. Strange Problem in EXCEL
  173. Please help with Column to row formatting
  174. How to match 2 prices
  175. vlookup from another worksheet
  176. How do I Keep a Combo Box "Focused" on difrferent cells.
  177. Convert 29.08 hours (shown in decimal form) to time shown in "hh:m
  178. Volunteer scheduler
  179. Finding and Isolating Duplicates
  180. now that i have formatted the text to "proper" ...
  181. Linking 2 excel workbooks
  182. Placing external data in a worksheet
  183. Compare 2 worksheets all 6 columns in each worksheet
  184. how to count blanks before today's date?
  185. Lookup and copy multiple values
  186. CHOOSE e MAIL SERVICE
  187. Circular Reference Error
  188. Exclude Lines in the calculations on a spread sheet
  189. compare cells and sum if equal
  190. 3 LookUp Variables One Result
  191. IFERROR
  192. Turn a four digit number into pounds & pence
  193. Two dimensional look up
  194. checkbox, then taking information from one sheet to another sheet
  195. Globally available defined names?
  196. Help Please calculating date range - Other posts didn't help
  197. Reference a variable declared in VBA
  198. How do I create a time trend summary from monthly worksheets?
  199. User is not prompted to update links when opening spreadsheet
  200. Conditional formatting excluding empty cells
  201. Formating text in a calculation
  202. Multiple Level "and" fucntion help!
  203. Binary integer non-linear programming excel solver
  204. How to keep Status count visible?
  205. Function disappearing in spreadsheet
  206. Transpose Column to Row
  207. How can you search by column or row within a spreadsheet?
  208. How do I Go To a Row or Column?
  209. Excel 2007 tmp files filling up drive with XLSM files
  210. Highlight Cell Based Upon Referenced Cell Data
  211. Performing calculations if a value is between A and B
  212. Date format diplays incorrectly
  213. How do I count MTD coloms?
  214. how to return the latest result...
  215. To make the excel file in shared folder to be editable by every us
  216. autofill button is not appearing when I select cells in Excel 2007
  217. Help needed with function
  218. Formula to pick up blank cell names
  219. comparing 3 columns
  220. I can't insert column in Excell file! Help please
  221. V-Look up copy problem-PLEASE HELP
  222. LookUp (Date) Value from Forecast Data
  223. Help with Conditional Formatting
  224. formula for "on time" departure.
  225. Hard coded formula fix, VBA for column ordering
  226. If to determine lessor of three values
  227. SumProduct
  228. Comment Function
  229. Summing a number only once...
  230. Hyplinking Question
  231. HOW TO CREATE A MACRO!!!
  232. looking up multiple values in an arrray
  233. Spreadsheet reference in formula?
  234. Function returns itself vice results
  235. Formula help!
  236. cells
  237. Help!Excel will not calculate formulas- Not in manual calculation
  238. auto sum feature
  239. Gathering Count by date
  240. Counting non blanks different from ""
  241. Summing a number only once
  242. cannot Move or Copy a worksheet
  243. wraping columns
  244. Adding a percentage to a figure
  245. Simple Addition Function
  246. Can't subtotal data from query
  247. Combining MATCH & LOOKUP formulas
  248. Freeze Panes
  249. Turn off or not include lines in a calculation
  250. Most current date
  251. Pulling Data that falls within a specific date range?
  252. Filter & Sort
  253. CONDITIONAL FORMATTING
  254. Replace nonprinting character
  255. VLOOKUP Tables
  256. Rolling YTD/YTD Dynamic Function
  257. Sum Formula based on color
  258. Rate formula in Excel
  259. Concatenate Text... with spaces
  260. MATCH Function - 2 Dimension Arrays
  261. excel 2007 getting errors with mround
  262. Tracker
  263. Excell word formula
  264. Excel 2007 conditional formatting & cell colour.
  265. Vlookup limitation
  266. Date returns always returns: 00 January 1900
  267. Text Formula Error
  268. Help need formula for working out date overlaps
  269. No Data Analysis item in Excel Tools menu. Now what?
  270. Need a Sum but involves Text & multiple functions
  271. sumproduct formula on steroids
  272. Converting time into military time
  273. Vlookup help
  274. Password Protection for Individual Worksheets ???
  275. if function error
  276. Search multiple worksheets and return value based on phone number
  277. Line Charts - Is this possible?
  278. Colouring text in VLOOKUP formula
  279. Function Values Not Refreshing
  280. Search range
  281. search worksheets in same book to return value matching criteria?
  282. Can I copy my protection settings from 1 workbook to another?
  283. look up functions
  284. SumIf with OR criteria
  285. SUMIF nesting an AND function
  286. drop downs and hyperlinks
  287. Consolidate Data From Vertical Format to Horizontal.
  288. Cap Sensitive Countif
  289. Re: Lotus 123 @Regression the equivalent in Excel?
  290. loan repayment calculation for 101 months
  291. calculate average date
  292. COUNT function
  293. Finding the position of the i-th non blank cell in a vertical range
  294. Special Date Function
  295. Binary integer non-linear programming excel solver premium
  296. Binary integer non-linear programming excel solver premium
  297. Changing the color of the data auto filter buttons
  298. I have a question
  299. Copying a row based on date
  300. Spreadsheet help --
  301. Formula Question
  302. Complex Sales Evaluation
  303. Workbook - Read Only
  304. Toggle Cell Colour Conditionally
  305. timed events
  306. MS SQL Server Joins Concept
  307. 2008 East Coast U S Excel User Conference
  308. lookup two arguments
  309. How do I delete existing data from a drop down menu list?
  310. Copying Sheets
  311. Adding Times
  312. Converting Numbers to Months
  313. how to clear data
  314. MIN Function with arguments
  315. How to work with Many Worksheets
  316. List
  317. SUMPRODUCT
  318. Comparing lists of data
  319. Complex Sumif
  320. how to set up formula with more than 1 result
  321. Pivot Table Unique ref
  322. how do i winsorize data in excel
  323. calculate difference between 2 dates
  324. Separate Text into numbers and alphabets
  325. Excel help
  326. Character limit in textbox
  327. Interpolation/vlookup question.
  328. Interpolation/vlookup question.
  329. If formaula ODD and EVEN
  330. Sum every 6th cell in a row.
  331. Alphanumeric Sorting - numeric alpha numeric
  332. Data Validation Restriction Referencing other Workbook
  333. I am trying to create a formula
  334. Average formula
  335. Cell Conditions
  336. workday calendar
  337. listing permutations
  338. Hide function: "Cannot shift objects off screen"?
  339. horizontal scroll bar
  340. Moving data from one worksheet to another...
  341. If statements
  342. need to set up a formula to pick random numbers
  343. SUMPRODUCT....and then some!
  344. If Cell = "XXX" Then clear all other cells formula
  345. sheet reference
  346. Divide a range by a corresponding range
  347. Is there a way
  348. sorting data
  349. Why Link updates option in Edit menu is disactive?
  350. Calculate Payback Period
  351. Sumproduct Issue
  352. Formula to Compute Overtime hours
  353. protecting cells by password
  354. Calculate Accrual Date
  355. 如何*總算出sigma(1到n)
  356. autofill
  357. fill data across worksheets
  358. Default value in Drop down menu and automatic selections
  359. Changing cell addresses to recently added names in existing formul
  360. IF function to return date content of another cell
  361. Taking a total number of employees that meet certain conditions
  362. Leading Apostrophe
  363. VLOOKUP Range
  364. Information match formula
  365. Right function to use
  366. Making a date go red, if date passes todays date.
  367. VLOOKUP MATCH INDEX two conditions / criterias text and date
  368. I need to change 4/21/1998 dates to 21/4/1998 HOW?
  369. working with multiple consolidation ranges.
  370. Pivot Table with Multiple Consolidation ranges
  371. Random Values
  372. Workdays
  373. #NAME? error for no apparent reason...
  374. Auto Numbering Test Scores and want ties to count the same
  375. converting numbers
  376. Formula between sheets.
  377. Excel Help
  378. My comments on my excel spreadsheets print as black squares why?
  379. Time Format Help Needed (Excel)
  380. Calculate a Date
  381. 4 digits required for a number
  382. How can I show and print repeated row labels/data in a Pivot?
  383. How delete to end of file; comp keeps adding rows; over 3000!
  384. Bi-weekly date dilema
  385. Counting dates with Conditional Formatting
  386. YEAR TO DATE SUM
  387. i lost my worksheet in excel
  388. How to keep font color when referencing Sheets in the same workboo
  389. List and subtotal selected items, then print separate item list
  390. how can I start and stop a sum formula?
  391. Is there an easy way to delete empty columns?
  392. Excel Function Question??
  393. Help with Sumproduct Formula with Pivot Table Data
  394. subtract 2 cells and get blank instead of 0.0
  395. 360-day Year Based Payment & Amortization Calculations?
  396. How to I sum data from one sheet based off mulitple variables?
  397. drop down list function help
  398. VLOOKUP and OFFSET
  399. Rounding in VBA - Any ideas?
  400. Filter Data using a drop-down list
  401. I am trying to create a formula
  402. Calculate number of Mondays betweeb 2 dates
  403. Hide Drop Down Arrows in Table Headers
  404. Excel 07 / Data Validation / List /
  405. Autofill Format
  406. sumproduct basic help
  407. how to know the original creator of one excel?
  408. Excel macro which prompts for input and moves to a cell - repeated
  409. IF function question
  410. IN EXCEL: R1,243.00 CONVERTING TO ONE THOUSAND, TWO HUNDRED AND FO
  411. More Conditional Formatting in Excel 2007
  412. financial spreadshee
  413. how do I add a row when the second last one is used
  414. Arrow keys scroll the page instead of navigating through boxes
  415. Calculating quarters of a year.
  416. Average weekly maximum
  417. Multiple State and product based analysis project
  418. Conditional Formating?
  419. Allow "List" to work in a locked sheet
  420. Add adjacent cell value to existing CountIF formula
  421. If Array EDATE formula help
  422. SumIf and CountIf Multiple Criteria
  423. How sum numbers in the same cell and entry
  424. AutoFilter Cut/Copy not working with Name Range
  425. IF function
  426. Script Not working
  427. countif criteria sg
  428. Why doesn't the alignment dialog box come up like the book shows?
  429. Print 100 Sheets
  430. Sorting in locked sheets
  431. Auto formatting
  432. Adding up the number of times a month is in a column
  433. Rank then sort then pastelink
  434. named ranges question
  435. Similiar data on two different sheets - how to ID what is differen
  436. copying a date into a text string
  437. Problem with HLookup. Not sure if it is a bug or not
  438. How do you use multiple if formulas with multiple choices?
  439. split single cells
  440. Viewing formulas for Print in Microsoft Office 2007
  441. Performing date functions after getting cell address
  442. Side to side scroll slide missing
  443. text substitution
  444. Conditional formatting on 2nd cell
  445. SHOW AUDIT ARROWS
  446. vba constant value for "Unicode Text" in PasteSpecial function
  447. Find if value exits in array
  448. text substitution
  449. sumif formulas
  450. How do I show amount of time in minutes and seconds?
  451. How to consolidate multi-row data into a single row?
  452. Workbook Name Edited in Cell
  453. How do I match using partial or approximate values?
  454. Creating new worksheets using data from a single sheet
  455. Totaling cells in multiple worksheets
  456. multiple validations
  457. Calculating the distance customers live from a branch office
  458. Add "/" to a date string
  459. Substitutions
  460. sumif with a second condition
  461. conditional if statement
  462. Dates and SumProducts
  463. Count number of 2008 invoices for customers
  464. Budget Set Up
  465. Excel statistics
  466. Repost: Copy and Offset cell reference
  467. Formula Result is "V6", need Excel to use cell "V6", not the resul
  468. cell formula for using progressive information in other cells
  469. Cell format to use for calculation
  470. Can I use copy function in an if statement?
  471. boolean question
  472. date boolean function
  473. Lookup duplicate items in a list
  474. Filter Data
  475. How to auto insert date in one cell when another is changed
  476. notify of entered criteria
  477. averageif (XL2007)
  478. Using a combo box for more than one group of cells
  479. How to verify selected data from drop-down list?
  480. Statistical - text function (counting)
  481. Lookup Conditional Scenario - urgent (I have can't figure this out
  482. Combine 2 formulas
  483. allow insert rows = false for only some of the worksheet
  484. Protect formulas which reference to unlocked cells in protected s.
  485. copy formula as is to new cell in an if statement
  486. Custom HEX or BASE 33 Sequence
  487. How to populate a cell with numeric value based on textselected from pull down in adjacent cell?
  488. multiple value lookup
  489. Workbook Name in Cell
  490. Clearing Cell Contents / Worksheet_Change Event
  491. 3d References
  492. adding a percentage to a column of numbers
  493. consecutive numbering
  494. range of numbers
  495. When you hit Save on a template, how can you save as worksheet?
  496. SUMIF within a range
  497. Duplicates
  498. I need something similar to an IF formula
  499. lookup specific value in a column and show it in a new cell
  500. How to set "alignment wrap" as default?
  501. Using STDEV to evaluate a subset of a population
  502. Emailing an Excel Worksheet
  503. Count instances based on two criteria
  504. Deleting Rows Between Empty Cells
  505. If and Then
  506. Referencing Last Cell
  507. SUMIF with two condition from two ranges
  508. Macro or formula for dates
  509. Excel formula questin
  510. Find a theme in a article in a single cell
  511. age
  512. change dob
  513. randomize a set of numbers in 1 column that are located in another
  514. how do i add commas in a single cell?
  515. Insert a specific address from a list if the contents of cell A1=x
  516. Calculating Average Length of Service
  517. Match and return functions
  518. SumProduct or sumif
  519. Formula - stop the update
  520. Matching error
  521. Changing formula totals
  522. Return Last Value in a Row formula
  523. Time countdown...
  524. drop-down list
  525. Test if a date falls within a given range of dates in Excel?
  526. duplicate dates
  527. Index backwards
  528. Conditional averaging gives wrong result
  529. Problem with Copying a Simple formula
  530. Removing blank cells in rows of data
  531. Summing large number of non contiguous cells evenly distributed
  532. Conditional formatting
  533. Header Scroll
  534. Percentile Analysis Across 2 Columns
  535. Unable to highlight an unprotected cell on a protected sheet.
  536. copy one macro to another workbook
  537. SUMPRODUCT - Count Various criteria in same column (exclude other)
  538. XIRR #NAME? error - Toolpak IS installed
  539. Very easy question! (But not sure what to call it - maybe transpos
  540. Random help please
  541. DCOUNT Question
  542. Counting text cells then multiplying by a value in another column
  543. Transposing multiple columns to rows
  544. countifs Text and Dates
  545. scroll with arrow keys problem
  546. CountIF() & SumIF() with multiple criteria
  547. Data Entry with forms
  548. Please HELP!!!!
  549. can't roundup sum
  550. How to group e-mail adresess based on domain name?
  551. Excel formula question
  552. Need help with a formula
  553. Annuity Payments From A Present Amount
  554. Please help with vlookup function
  555. Please help with vlookup function
  556. Search Excel form (Formula?)
  557. Where can I get a template for 3-column (green) ledger paper?
  558. Check number within a range
  559. I've forgotten the password to unprotect a workbook in Excel.
  560. Linking Question
  561. conditional formatting
  562. dynamic vlookup
  563. Macro_AND function
  564. Protect cells
  565. time tracking formula (trying again)
  566. I need to switch currencies based on a pull-down selection
  567. Finding and extracting text in a cell, splitting into smaller chun
  568. View Locked Cells?
  569. how do Excel options need to be set to make formulas convert
  570. Import Spreadsheet w. Formulas/Functions into SharePoint List
  571. Excel 2007 External Data Links and Subtotals
  572. lookup function to meet two conditions
  573. look ups
  574. Function works in one cell but not another
  575. Round up whole sheet
  576. countif or sumproduct?
  577. excel 2007 right click edit query
  578. 2008 East Coast US Excel User Conference
  579. Changing font colors
  580. Replace input cell data using Vlookup
  581. sumif? countif?
  582. Reference to a Variable Part of a Cell
  583. I NEED TO USE A LOOKUP FUNCT. TO RETRIEVE A PICTURE FROM A HYPERL
  584. area of a rectangle having two sides equal and two sides diffferen
  585. Change lower case to upper case
  586. Sorting Information
  587. how to extract digits from a row of numbers
  588. Calculate minutes between dates based on 9hr work days
  589. match formula question with isna
  590. Excel 2007 Ribbon
  591. match formula question
  592. Recommended solution
  593. Formula copies when only answer is wanted
  594. Help with Formula
  595. Combine daily data from different worksheets
  596. sums of range within sumproduct
  597. Conditional Function
  598. is there a formula for FV with UNEQUAL payments
  599. Novice user trying to use variables including text and numbers
  600. date formula
  601. Non Prinatble fill
  602. Combining duplicate row data
  603. automatically Add numbered rows in sequence from a given number
  604. Formatting Excel
  605. projecting time and date from hours entered
  606. Menu Delete greyed out
  607. Have worksheet changes cascade down?
  608. Formula to determine 10 business days
  609. Sort by even and odd digits and copy to separate worksheet
  610. How can I sort & print specific information from table.
  611. Formulas
  612. Removing an alpha characture from a column of numbers
  613. Summing based off different columns
  614. Need Help to Select certain Data from my spread sheet.
  615. Sum only if cells are not blank in adjacent column
  616. Sorting with Sheet Protection On
  617. How can i get 1 value to display another value when selected
  618. instruction on how to make a 24 HOUR TIME COLUMN
  619. time tracking formula needed
  620. PivotTable Rank - Excel 2007
  621. Counting with more than one criteria
  622. unable to open workbook
  623. Pivot table active dropdown
  624. Count if with multiple column criteria
  625. Compare two columns
  626. Auto Filter - Add visible cells
  627. Copy/paste from many worksheets in the same spreadsheet into one r
  628. Evaluate boolean values as 1 or 0
  629. COUNTIF Function with variables
  630. how to unproctect the sheet if password is not remember?
  631. lookup function
  632. Lists
  633. Paste Link between Worksheets
  634. I need a Line of Credit Calculator
  635. 2007 Conditional Formatting
  636. Excel Cell Reference
  637. Finding the solution to an Exel problem.
  638. Excel Round
  639. Calculating Information
  640. Sum values in one row dependent on a value in a different row
  641. How do I omit a blank cell from a calculation??
  642. Why is my Excel chart printing as a 1.5 inch rectangle?
  643. If function
  644. cannot convert text string into value
  645. sumproduct text
  646. For Each Sheet in Range - Sort Descending
  647. Trouble in Dragging the cell
  648. Cell Formatting
  649. ME, STRANGE SUMMATION
  650. Cell formatting
  651. Date Format
  652. Data Validation Lists
  653. Run macro according to value of a cell
  654. Index/Match or Vlookup
  655. Need Help with Highlighting duplicates across several sheets
  656. Command Button
  657. Help
  658. How to add (sum) a row cells with letter(s) aside or without numbe
  659. indirect formula question
  660. Can Anyone Help me with this
  661. Monday Following
  662. Auto run macro
  663. How to count number of characters in xl cell for publisher merge
  664. Redefining the $ icons format
  665. formula to find "missing" data
  666. Is a cell a formula or value?
  667. Create a conditional formula that results in another calculation
  668. How can excel generate every unique pair from a set of numbers?
  669. Formatting xl cells
  670. How to retain last number in a cell
  671. Subtotal Formula
  672. How can I change an #N/A error to display other text?
  673. Index Match 2 columns 1 row
  674. how do I place an image (jpeg) onto an Excel worksheet?
  675. PUTTING VBA'S TOGETHER
  676. How do I use NOW so that each cell displays a different time?
  677. Problem with Self signed Certificate
  678. define cell
  679. Pivot table
  680. How to expand Index/Match formula
  681. round up (ends with...)
  682. Add-In Program
  683. Drop down list
  684. Protecting Code in Visual Basic Editor (Excel 2003)
  685. Look up a value from a row after verifying two other values
  686. Change formula based upon value of a different cell
  687. function result losing leading zeros
  688. Counting Formula
  689. Exclude $ Amount from sum based on how many months its been
  690. Date to Pre Fill
  691. How do I copy numeric section of cell from alpha-numeric cell
  692. Can anyone help - I am sure there is a easy way to do this
  693. Formula problem with decimal
  694. Save a cells selection as a set, group, or block
  695. Formula not working and I am extremely confused
  696. Count but with conditions
  697. visible rowindex
  698. Excel Automatic Date Insert
  699. How do I copy exact page counts in Excel?
  700. Counting Multiple Addresses
  701. EXCEL 2000
  702. Format of cells for VLOOKUP
  703. Formatting cells
  704. SUMIF where CRITERIA is looking for a string occurence in the value,not the whole value
  705. count instance
  706. Macro - Whats wrong?
  707. Optimize a sumproduct function (or find another solution)
  708. how if and vlook up is used
  709. 2008 East Coast US Excel User Conference - Regular registration ends
  710. Formula constants?
  711. Looking up multiple values and returning one corresponding value
  712. Using excel as a database
  713. Group a set of 'time'
  714. Vlookup/match?
  715. Match and Index for Tables
  716. Make a cell display the contents of a shape
  717. Lookup_returning any value..
  718. Need help with Excel Formula
  719. sum of range containing formula in blanks
  720. VLOOKUP
  721. problem solver question
  722. 2003 macro generates compiler error on 2007
  723. returning multiple cell values from a vlookup
  724. IF
  725. Formatting Time
  726. IF + IF?
  727. Lookup based on two variables and return a third
  728. too many cell formats
  729. Excel check box making list
  730. using a formula to create an ordered purchase order
  731. Working an If formula
  732. #Missing
  733. Calendar List to Calendar format
  734. similar names - two spreadsheets
  735. Number of days in overlapping date ranges (using array formula?)
  736. updating cell data and keep from overwriting
  737. Choose 2 of 6 optional units for grade - formula question
  738. Offset formula
  739. vlookup returning zeros
  740. Conditional Page Break
  741. if formula - multi criteria
  742. #NAME?
  743. Add cell "50+55+50+50" to give answer 205
  744. follow up to nested subtotal/sumproduct
  745. =SUMPRODUCT Col E = B, Col F = blank
  746. Cumulative labor calculation
  747. splitting and formating a number series into date/time
  748. hyperlink to other sw(exe) and open with parameters
  749. If formula with two conditions to meet
  750. "move tab sheets"
  751. How do you rename table headers in a query using Offic 07?
  752. Validation on cell
  753. How to restrict user to input only one of multiple cells
  754. Calculate hours worked minus a half hour for lunch
  755. Hyperlink Relative Reference
  756. Complex SUMPRODUCT/VLOOKUP/SUMIF
  757. Need blank if no values in range getting value at the mo'
  758. Keep all cells in a column unique? No cells identical
  759. IF question
  760. add If to formula to blank #n/a
  761. sumif maybe?
  762. how to find out if a row is hidden
  763. =SUMPRODUCT(--(TRIM(A1:A10)<>"")), what does the "--" mean?
  764. NEED INFO to the left of rqd cell
  765. Lookup_finding all the corresponding cell...
  766. fromula to get data from multiple sheets
  767. weighted average
  768. URGENT! how count how often a vlaue occurs within a range of value
  769. amortization schedule / Mortgage payments
  770. Excel
  771. Percentage formula needed
  772. Validation List 27.08.08
  773. Alphanumeric udf question.
  774. Sumif function?
  775. What are the COUNT or other options ...
  776. Max function
  777. Non-Array Play to Eliminate Blank Cells
  778. Creating pivot table to Existing worksheet
  779. VLOOKUP and "-" characters
  780. Finding last cell with a value and then adding to another
  781. how do I apply formatting from one worksheet to a whole workbook?
  782. Seperating hyperlink address from viewable text
  783. Concatenate a VLOOKUP
  784. Worksheet calculation different from calculator's
  785. SUMIFS including hidden rows
  786. Pricing - Sliding Scale Price Markup
  787. Convert to Binary and Break out results
  788. HELP - I think I need a macro???
  789. Searching A List
  790. what formula can i use to find a specific value?
  791. Consolidating a Matching List
  792. Just a bad day in Excel
  793. Calling Bernie Deitrick
  794. SUMIF and SUMIFS
  795. how do i do interest roll up calculation in excel
  796. Adding numbers based on date
  797. Calendar resizes when workbook is closed
  798. IF and Then Formula Help Needed Please
  799. Copying Named Range
  800. Multiple IF Formula Question
  801. Reference a number from one cell in the text of another cell?
  802. Macro - How to not copy blank criteria?
  803. Replace Link
  804. Finding a calculated Value across Columns
  805. lookups
  806. nesting sumproduct with subtotal
  807. LOOKUP/IF Formula Help!!
  808. Hyperlink link_location error
  809. Changing conditional sum format to "Sum If"
  810. Look up, not down
  811. Formula Help
  812. find max..
  813. Finding lowest price
  814. Creating a Calculated Field From a Running Total Field
  815. Curious Phenomenon...Vlookup not matching
  816. Keep data in fields if no update while updating
  817. Simple IF , maybe, for names in columns
  818. Active Cell Color
  819. free movies
  820. Cell Reference
  821. countaif
  822. soma gebraica
  823. Existing spreadsheet program
  824. Index/Match
  825. Row Protection
  826. Lookup question
  827. HLOOKUP
  828. Pivot Table filters, especially DATE filters
  829. Find the last number entered
  830. Timesheet Function
  831. Count the number of times specific text appears in a column
  832. How do I set a static date?
  833. Average
  834. if statements returning dates
  835. Time in Excel
  836. How to extract capitalized group in text string
  837. Forumla that Looks up a range of output from one cell
  838. vlookups and if statement
  839. Pivot Table Format
  840. Multiple "IF"'s
  841. Pivot Table Design
  842. How do I compute effective yield in Excel when there is a balloon
  843. Sorting information
  844. Using CTRL to select cells for a formula
  845. Referencing another worksheet
  846. Basing a range for a linked spreadsheet on internal criteria
  847. RANDBETWEEN
  848. please advise the solution
  849. Beginning of Year
  850. Help on formula for autosum on 2 criteria in 2 ranges
  851. working around blank value in IF statements
  852. Copy a formula to the right increasing the rows from another works
  853. Drop Down List
  854. Variable Range for NPV
  855. Need ideas on which formula(s) to use in this situation
  856. Moving / Emailing Macro Workbooks with Custom Toolbars
  857. need help with a formula
  858. Ignore blanks in multiplication formula
  859. Ignore NA in a formula when I type it in a cell
  860. Count range of data
  861. Using less than "<" in formula
  862. RE: Using less than "<" in formula
  863. Stock quotes in Excel
  864. SUMIF & MEDIAN with blanks & text
  865. Need to rename table columns in excel from a query
  866. returning a text value using a formula
  867. Import External Data by Date
  868. Adding Multiple Lines when the Function is Satisfied
  869. Column reference in Vlookup formula
  870. cell fill
  871. Nd help, Vlookup/formula
  872. Conditional format row based on percentile
  873. Not sure what is going to be best
  874. single entry across multible sheets in workbook
  875. Protecting Functions within a cell
  876. Call Center Talk Times
  877. Wouldn't know what to call it!
  878. match with isna formula question
  879. Conditional formula containing text and wildcard
  880. Fill in a formula within a worksheet
  881. Save Prompts
  882. What does "Cannot empty the clipboard" mean?
  883. Return top ten amounts
  884. Counting cells with multiple criteria
  885. Calculating Sortino Ration (Downside Deviation)
  886. SUMPRODUCT Function Compare Date
  887. Mix/Max/Avg Help based on dynamic ranges
  888. Prevent data from typing in another cell in a saved template?
  889. No Subject
  890. Take part data from two fields and auto fill into 3rd field
  891. Selecting data by date differences
  892. i want to create an IF formula to bring back one of four results .
  893. 2 criteria lookup of text. Return text form column 3. SUMPRODUCT t
  894. Indirect
  895. Restricted Access
  896. How do I use lookup for this case ?
  897. Using the IF Command
  898. Dealing with column headers
  899. Creating a Questinaire with filtered responses
  900. Percentage and copying formula
  901. Fill a word form clicking on an excel cell
  902. Using values from macro to userform
  903. How do I stop "global" hyperlinks changing to "local" links?
  904. Split text to compare
  905. Creating checkable boxes w/o the check box forms tool
  906. Row header
  907. COUNT IF
  908. Lookup question
  909. NETWORKDAY + Excel 2007 + Excel 2003
  910. duration
  911. Help with IF function
  912. Use of CELL("protect") in conditional formatting in Excel 07
  913. Incrementing numbers in cells
  914. Rows to Columns
  915. Dividing a list into thirds
  916. How to Create % cell and apply changes to worksheet
  917. SUMPRODUCT or SUMIF and INDIRECT, with Relative cell refs
  918. How do i create formula in words from amounts
  919. trying to create a way to link summary page to subsequent workshee
  920. Can't figure out a formula
  921. Conditional Formatting for an entire row or column?
  922. Rest of the Year Calculation
  923. Indirect(NamedRange) inside Sumproduct
  924. Subtract 30 minutes from Formula
  925. Changing Multiple Formulas
  926. How to change a date from 19990812 to 08-12-1999?
  927. Modify a Formula
  928. Excel Formula using colors
  929. link from other source file is not working
  930. Uploading ASCI
  931. Can you subtotal data in rows?
  932. Sorting columns alphabetically
  933. Sumproduct/SumIf
  934. IF Formula Help Please
  935. array formula
  936. How do I link with certain aspects?
  937. HOW PUT WORD-ART IN THE BACKGROUND AND WRITE OVER IT
  938. Wrong result from formula - please evaluate
  939. Workbook will not update after pasting data
  940. Format Cell contents as MM
  941. What is the formula for compounding interest with annual additions
  942. Compare column in 2 documents
  943. MAtch drop down list selection to data sheet
  944. Un protect sheet
  945. Vlookup question
  946. Rank Tie
  947. //autoaverage.
  948. Start, Finish including break time
  949. When inserting column I get "cannot shift object off sheet"
  950. payback period for a 10 years investment
  951. Automatically Entering Values
  952. Question on create chart
  953. Sum
  954. Help with changing a formula
  955. Simple Formula Help
  956. formula help
  957. Adding results from a If formula-Short in time
  958. auto step sum
  959. Using If then to change cell colors in Excel 2007
  960. Need a formula to cut rows from a validation list
  961. Sorting data in columns
  962. Multiple criteria
  963. Autofill link to another sheet
  964. how can I disable "cutting cells" and "drag and drop "in excel ?
  965. //pivot - unique records .
  966. Sorted Data
  967. Formula to enter names in a column specific # of times
  968. Excluding Repeating Numbers Help!1
  969. Autofill Question
  970. Search for tabs from a cell value
  971. sumifs criteria
  972. How do I use x as a variable in a sine function and then graph it
  973. Worksheet Functions
  974. CountIF or Sum IF Questin
  975. avoid nested IFs with another function
  976. Comparing/Matching two columns
  977. vlookup doesn't work
  978. Locking worksheet labels and box sizes
  979. How do I auto complete a cell with text from another worksheet?
  980. sum cells
  981. a formula to search for names in columns and then add the figures
  982. excel 2007 pivot table wizard
  983. Repeating Asterisk
  984. Asterisk
  985. vlookup not working
  986. Is there a time zone conversion function in Excel?
  987. Unique Random List
  988. Multiple Worksheet reference in a formula
  989. find a correspond betwen the same words in two sheets diferents
  990. creating a popup answer for an average range of cells
  991. Date if before or after 15th of month
  992. comment
  993. Protection of single cell
  994. Scroll bar not responding
  995. Validate a total of a row
  996. predetermined answer in next cell
  997. Average Time - With a Twist
  998. Find data in worksheet area that constantly changes
  999. SUMPRODUCT or COUNTIF
  1000. If, then Formulas