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. Help with a bsic formula
  2. Help with blank cells when concatenating
  3. How to get result by using CountIF, if there are 3 conditions to b
  4. the value should not be more than 0.8
  5. Searching from a table
  6. Counting incidences of surname and date of birth and rearranging s
  7. How I unprotect my workbook if I failed to remember my password
  8. count uniques anomaly
  9. COUNTIF: unique names and values accross several columns.
  10. Wrong count of time
  11. Updating Imported Data (Excell 2003)
  12. logic test with nested IF fuctions - help
  13. Mean separation by LSD value
  14. Possible getpivotdata with offset?
  15. Calculate and display year and month
  16. Associate values in worksheet??
  17. How do I use the WORKDAY() for a 6days working wk excluding holida
  18. Column to row
  19. Lookup where column data does not match
  20. Changing the headers on an excel worksheet from Numbers back to le
  21. IF and Betwwen - how to ?
  22. Import external data, data includes Excel function
  23. Filter latest date from multiple date entries
  24. Counting specific letters in multiple cells
  25. Calendar or date formulas
  26. Removing unwanted columns in a list
  27. yes / no formulas into 1/0
  28. Stop text carries over
  29. Protect columns with password
  30. Wrap Text Problem + a little VB :)
  31. How to calculate avg from various rows
  32. How to calculate an average from various rows???
  33. Worksheet design: How to allocate costs to plants?
  34. Count rows after filter
  35. May be a long-shot, but.....
  36. #value! Error
  37. Data Validation lists update orginal cell with list update
  38. Restricting cell data amount
  39. drop info auto from sheet 1 to 2
  40. Sum of visible cells with multiple filters - Office 2007
  41. Simplify Formula
  42. Pivot table formula to pick most recent value.
  43. How would I attach or assign values to a trendline?
  44. Set fixed Decimal places with no rounding
  45. VLOOKUP selecting, not highlighting
  46. Copy from another sheet but spreading the data out down the col
  47. How can I activate spell check in a protected sheet
  48. rounding decimals to nearest quarter
  49. alphabetical on column c
  50. Updating data in one Worksheet and propagating it to others
  51. if value is between two numbers
  52. How do u sort many items out a spread sheet in excel
  53. Nested IF Function not working
  54. EQUIVALENT for this FORMULA , please
  55. Insert Copied Rows or Drag/Drop Formulas While Protected
  56. Pivot Tables & Conditional Formatting
  57. FINDING THE DATE 75 DAYS AFTER A SPECIFIED DATE
  58. Isolate text immediately preceding "("
  59. Sorting text and numbers from multiple tabs
  60. Comparing Lists
  61. Change Workbook Password
  62. How Do I DO IF with DATE
  63. split data into seperate worksheets by criteria
  64. Ungroup "+" on a protected sheet
  65. Counting specific letters in a cell
  66. Figuring and adding time in Excel
  67. Calculate a ratio of two numbers to the total
  68. Automatically expanding outline section if values are present
  69. If a date range contains a leap year (date)
  70. Nested if/then or array???
  71. convert 80521 to 05/21/08
  72. Time sheet calculation of shift differntial
  73. How to find the highest name in an alphabetic list?
  74. moving objects with cell
  75. Linking cell ranges between rows and columns
  76. YTD average cust calulation
  77. copying from pdf into excel ?
  78. Understanding formula
  79. Please Help Qtr Mtch
  80. Formula
  81. finding and replacing
  82. Moving The Decimal Point Of Existing Entries
  83. taking conditions from one spreadsheet to another
  84. work book open _ event
  85. Advice on a couple of things if possible.
  86. Copy Left Word
  87. sumbycolor formula
  88. Take first word out of cell and put it in a new cell
  89. REALLY easy question
  90. count the occurance of a particular month in a column of dates
  91. Using Tabs within the allow users to edit range while sheet protec
  92. Countif function
  93. How to convert data from Landscape to vertical
  94. If Then forumal
  95. Complicated comparison and highlighting question
  96. Summ figures that are not struck-through
  97. Charts not updating
  98. how do i substitute filename in a formula
  99. Help with Formulas
  100. Dragging Down a Formula
  101. How do I round a number to the nearest .49 in a cell that has a fo
  102. Help with if statement (more than 7)
  103. Diference between two hours in Minutes
  104. Formula to evaluate dates
  105. formula for changing a percentage
  106. Sum = to greater than, change it to 1
  107. Vlookup with Multiple like values in the reference column
  108. string lookup combined with SUM
  109. Cell Formats
  110. Combining information from rows
  111. sum of three cells
  112. IF and SUMIF
  113. excel data in list N1, N7, N13 etc want to transfer to A1, A2, A3
  114. Calculating Average
  115. sumif or vlookup help
  116. OLD PROBLEM without SOLUTION
  117. check certain cells for data before saving file
  118. Setting a sale price and rounding up
  119. how do i sort data record on two rows?
  120. count if using columns not range of cells
  121. extract number from alphanumric
  122. Copy/Past/Transpose Formulas
  123. I am having some trouble with a long formula and multiple spreadsh
  124. Find a value Using a lookup table multiple columns and rows
  125. count if, but not if
  126. calculate the the diffrence between 2 Dates and time
  127. How can I make BINGO boards using EXCEL?
  128. SUMPRODUCT containing txt string search
  129. where in excel 2007 is old file properties menu
  130. Im doing something wrong in Visual basic for sure
  131. Hyperlinks and spaces
  132. Formula
  133. =COUNTIFS(M3:M17,"=MAN",P3:P17,"=2000")+(COUNTIFS( M3:M17,"=LHR",P
  134. Searching specific record using VLOOKUP function.
  135. Comments, is there a way to export them?
  136. Counta function
  137. pull down list and single value allowed
  138. Worksheet Formula Returning Sum of a Series
  139. simple timesheet
  140. Dual income calculator help
  141. Compiling to one sheet
  142. Compiling to one sheet
  143. Is there an excel funtion to calculate Daylight Savings Time?
  144. combining worksheets
  145. SUMPRODUCT/COUNTIF
  146. IF STATEMENTS COMBINED WITH VLOOKUPS
  147. Adding a Number and Formula Text and Evaluating
  148. Countif with multiple criteria
  149. Create user id fm LName, FName
  150. How do I pull data for consecutive months in an Excel spreadsheet
  151. SUM Product formula help needed
  152. Filtering in Excel 2007
  153. Calculating of time
  154. Vlookup Function with multiple worksheets
  155. Countif versus SumProduct
  156. How to determine the max. value?
  157. How to determine the max. value?
  158. Sum when cell's value in Named List
  159. Excel - adding a picture that will pop up when I wand over it?
  160. Need help with a formula
  161. vlookup returns #n/a
  162. Advancing lookups and comparisons
  163. Excel sort ( exclude letters include hyphens)?
  164. MSOffice 2007 - Excel - Subtotal Function
  165. Need to Count the number of times a value occurs within a dt range
  166. how can i determine number of weeks between 2 dates
  167. Help with Functions & formulas
  168. On opening a worksheet move focus to a cell based on date
  169. Label Filter in Pivot Tab;e
  170. Setting up spreadsheet to calculate time
  171. excel 2003 drop-down box color changes how
  172. return cell within date range
  173. get a range corresponding to a particular col header
  174. 1st sheet being displayed
  175. Elapsed Time
  176. how do I attach a scanned pdf file to a cell so that I can bring
  177. Pivot tables
  178. Sort function
  179. pivot tables
  180. Formulas new in excel 2007 not compatible with 97-03
  181. Count a specific month in a column
  182. How to convert an address file from Word into Excel?
  183. Using v-lookup with multiple identifiers
  184. Can't find certain date in search
  185. Auto update worksheets
  186. Hyperlink function in an If function
  187. How get user input that can then be used in formula, as criteria?
  188. Search formula referencing range of keywords
  189. Dates-Conversion
  190. Use a cell to name a file to be opened.
  191. Macro to Print
  192. Hyperlink from Excel 2007 to a specific slide in PowerPoint
  193. Why is the sum formula is not adding correctly?
  194. Page Breaks in 2007
  195. FIND and dates
  196. Finding text
  197. Time Formula
  198. Excel 2003 Graphs
  199. Complex IF formula
  200. Hiding uncalculated values
  201. EXCEL 2003 Export Issue
  202. sorting datasets on two rows
  203. Vlookup / sumif (maybe....) query....
  204. Sorting
  205. Filtering based on wild card values
  206. Date formula resulting in Year, Months & days
  207. How do I set up repeating data in Excel
  208. Collapsing filtered macro
  209. IF Statements
  210. How to number excel cells automatically
  211. Conditional Formatting - workdays only
  212. Can't add a column to a specific file
  213. Date in Text String
  214. How to look up a value in a list and return multiple correspondingvalues
  215. Macro Help
  216. If, then
  217. Adding more than one maximum
  218. Count occurances of a name over previous 12 months
  219. Last Row used in calculation
  220. Lock formulas from being edited
  221. Is there a showif formula?
  222. Filter and Delete
  223. Date and range
  224. making excel to notifying you about expire dates on your sheet
  225. Format problem in displayed userform
  226. Calculating Max & Min in a negative numbes
  227. How to change cell value if cell contain specified word
  228. VLOOKUP From Multiple Data Sheets
  229. make a single cell always equal zero
  230. Month formula
  231. Countif in an ARRAY.
  232. excel 2003 - revising a formula to make it more accurate
  233. Compare 400 cells to one
  234. Go to cell - Query
  235. Data Validation Formulas
  236. More of IF(AND
  237. Break up a date range automatic
  238. pick from table based on row and column header
  239. Very Basic SORT question
  240. I want to get a furmula for get a percentage
  241. How do you I get the antilogarithm of a number
  242. Mathmatical functions in Excel
  243. Zero if zero yet blank if blank?
  244. Excel formula
  245. drop-down list in a workbook while the list's data's on another w/
  246. How can I recover the previous data after save change
  247. Allocate from the sum
  248. Functions
  249. Need help with DIV/0 error in an AVERAGE array formula
  250. VLOOKUP using a number as text to "lookup" a match formatted in a
  251. Vlookup return a ROW of data
  252. About Fuctions
  253. Loss of Some Functions in Excel 2003 with Vista
  254. Vlookup
  255. list data to show up on multiple sheets
  256. Counting characters in multiple rows when rows meet specific criteria
  257. Flipping a worksheets contents?
  258. MACRS depreciation formula
  259. Incorrect INDIRECT function
  260. Initiating a Macro
  261. VBE in Excel 2007
  262. I need your help guys please
  263. statistical function with range referencs
  264. How to use formulae or formula in this case?
  265. How to use formulae or formula in this case?
  266. Formula for figuring percentages of 2 numbers
  267. header/footer
  268. Template
  269. VLOOKUP Macro?
  270. multiply Hrs:Mins by £Hourly Pay
  271. RE: VLOOKUP Macro?
  272. RE: multiply Hrs:Mins by £Hourly Pay
  273. excel seach
  274. how to set data validation on cell that display a date in Excel?
  275. delete error/blank cells
  276. Limited value based on percentage of total
  277. Moving data in Excel 2003 via VBA
  278. SUMPRODUCT use of --() syntax
  279. Adding cels in a row that correspond to the heading of a column
  280. how to build DDE link with text from another cell
  281. Removing "Sum of" from pivot tables
  282. Filtering an Excel Report
  283. Vlookup, can this be done?
  284. Data Validation
  285. merging cells and not losing data
  286. Count help please
  287. What percentage of heart rate
  288. need to work across two sheets in excel 2003
  289. I want to set weekly off as Thursday instead of Saturday & Sunday
  290. Dates linked in Excel files
  291. Worksheet Tab Name from Cell C4
  292. Using dialog box
  293. Calculating total number of days
  294. Shared Workbook - Using data for those that have the book open
  295. Question regarding copying items to another worksheet.
  296. Multiple If(AND
  297. Formula in combination with pivot table
  298. Combo box in Excel?
  299. vlookup naming a range in excel 07
  300. Formula
  301. Macro, Scenario, Filtering - What should I do?
  302. Combination Sum
  303. Sumif across multiple ranges
  304. display two rows of worksheets
  305. Conditional Formatting Question
  306. Formula to change cell color
  307. copying using a macro
  308. Excell formula.
  309. Text file to Excel
  310. find time and text
  311. Userform question
  312. Duplicate data in multiple spreadsheets
  313. Reg. Change of font color in a cell
  314. sumif with two criteria on on difference worksheets
  315. How do I group numbers in a list based on contiguous/missing?
  316. Help on formula
  317. Old DSUM formula not working in Excel 2007
  318. Extracting data
  319. Search function
  320. IF function contingent upon cell not being blank
  321. Changing text color of certain "word" in cell
  322. How do I convert a table into a list in excel?
  323. Accrual of hours
  324. Excel 2003 Sheet Ptotection with Overrides to sort
  325. Extracting Text String that matches with list
  326. date formula
  327. Using NAMES in SUMPRODUCT giving error
  328. MIN will not find lowest of calculated values How?
  329. auto sum column containing words and numbers
  330. Creating A Form
  331. Countif using multiple references
  332. automatically change worksheet tab name
  333. Is this right please.
  334. Chain IF formula help
  335. Conditional formatting: same color, alternate background on same r
  336. round numbers in the millions to numbers in the thousands
  337. Extracting certain characters from a long string
  338. Need to insert blank rows
  339. Combining multiple data records
  340. COUNTIF or SUMPRODUCT
  341. Excel 2007 - Remove Name Range via Name Manager
  342. Storing Macro Results
  343. Sum column A:? where ? is a number in a cell somewhere
  344. How do I change the cursor or outline color in excel 2007?
  345. Query returned more data than will fit on a worksheet
  346. "Why make 100 charts when one will do?"
  347. I want horizontal and vertical lines
  348. Conditional Format--2 conditions need to be true
  349. Excel Paste Special Function
  350. Calculating Time
  351. Combo Box Imbedded in Cell?
  352. delete blank rows with functions
  353. Cell colour change.
  354. Pivot tables
  355. Schedule Changes based on dates
  356. Drop-down list
  357. Extracting data
  358. Conditional Sum problem
  359. Multiple IF's Using Formulas from Other Cells
  360. I need speed calculate when I filter rows.
  361. multiplication of two array in a particular way
  362. When amortising a loan based using an IRR rate, the total interestpaid fall short.
  363. IF Statements - Novice
  364. raversing an array value
  365. excel worksheet functions-finding symbols
  366. Counting multiple cells containing text.
  367. problem with auto update of date and time
  368. Function '=Frequency' Help!
  369. reference other worksheets via variable names
  370. How can i do a frequency distribution by machine automatically
  371. how do you store real time in excel when making an entry
  372. subtracting with blank rows inbetween?
  373. SYMBOL ¦please help how do i do this symbol without copy/pasting i
  374. How do i get the ¦ symbol using the symbol?
  375. Data validation - restricting data
  376. Return unique number, skip blanks
  377. Adding up minutes
  378. Logical test IF a decimal was typed in a cell
  379. Shortcut keys in Excel 2007
  380. SUM(IF()) array formula in a separate workbook and multiple worksh
  381. If(And Multiple Conditions
  382. Cell Color Change
  383. Adding a date and name to auto update within one cell
  384. Hour Count
  385. Searching Latest Records
  386. Merging Two Worksheets
  387. Conditional Formatting with fonts
  388. Insert Rows NO FORMAT
  389. Calculate vacation days remaining from date of employment
  390. Can I create an "IF" function using cell color as a logical test?
  391. How do I create a hyperlink for individual FedEx tracking numbers.
  392. Printing "Freeze Panes"
  393. @if question
  394. How do I VLookup visible cells only?
  395. Add a Row Every Fourth Row
  396. Validation with External Data Names
  397. Strip leading zeros
  398. Find max value in one column based on another column
  399. VLOOKUP - How to Sum Multiple Cells
  400. Simple Math
  401. fill data
  402. Couting based on color and Filter
  403. Difference between dates as # of months, # of days, # of years
  404. weekdays not using NETWORKDAYS
  405. Inverse prediction in regression
  406. delete a duplicate in column while leaving other duplicates
  407. deleting condition after the first duplicate
  408. MS Excel 2003 - Worksheets on viewable
  409. Formula help with averages and if then statements
  410. Finding center of a distribution
  411. Shortcut to split data from one column into three? HELP!
  412. vlookup help plz
  413. Index or match?
  414. Formula based on Date
  415. Hiii.... GET PAID BY CLICKING....
  416. Question on sorting text strings
  417. Excel 2003 formula
  418. Converting Text to Dates
  419. how to build a "theorem prover" in Excel
  420. Circulair error message
  421. calculating cells
  422. Countif and Date Comparison
  423. Excel Formula Query
  424. counting >=100%
  425. How do I restrict what is entered in the next cell?
  426. underscore in functions
  427. Assistance please
  428. External Reference with INDIRECT, INDEX/MATCH
  429. IF Statements
  430. curves
  431. INT Function Not Doing what I need
  432. Conditional formating based on other cells
  433. % formula
  434. counting non blank cells for "sum(if" formula
  435. Conditional Formatting Using "OR"
  436. Custom type chart
  437. Specifing Cells to Sum on Condition
  438. disable Insert Worksheet
  439. search and paste information - multiple pages
  440. Looking up values with multiple criteria
  441. New to Excel really need help
  442. Nesting Formulas
  443. Concatenate a Formula
  444. Sumproduct on multiple sheets...please help???
  445. question using "INDEX" and "IF" functions
  446. Formula help requested
  447. Excel-tab, spacebar etc seemed to be locked-can't repeat key stro
  448. Eligible Vacation Days Calculator
  449. Dynamic Updates on Compiled Worksheet
  450. Error "invalid data source reference" for pivot table
  451. Simplfying DIV/0 Error...Can you?
  452. After Filter
  453. mixed text and formula results
  454. help with lookup reference please
  455. Match text
  456. Sumif condition
  457. large & lookup function
  458. If and then statements.
  459. request formula
  460. Vlookup, replace true text result with "X"
  461. copy and paste
  462. if statement - help needed
  463. How do I calculate a weighted median?
  464. Refresh linked data
  465. Excel 2003 - function to select a value
  466. How can cell entries be based on word entries in another cell ?
  467. Reverse Concantenate?
  468. Text Extractions
  469. Protecting specific columns within a worksheet
  470. How to compare two columns of data to make sure they match
  471. help with the function
  472. Username in Excel - Paste Value?
  473. SORT BY: left to right
  474. SUMIF function with conditions
  475. Excel troubles
  476. Select Active Cells
  477. Search and translate
  478. How to add continuous 5 or 10 rows by giving number of rows to ad
  479. Carrying formulas over to new cell when old cell is deleted: possi
  480. How do I rename an Excel worksheet when the feature is grap out?
  481. Concatenation in Excel
  482. SumIf function, How set range between dates and across worksheets?
  483. position of second occurrance
  484. currency and time calculation
  485. Update database from ODBC query (or another method)
  486. overtime during weekdays and weekend ( more specified)
  487. Re: Mapped Disk Full Error Message
  488. Time attendance calculation problem
  489. Translate Formulas as Values
  490. Average Monthly Growth rate
  491. Need help reversing a formula...
  492. Array Formula Help
  493. External Links with the same filename?
  494. = one total two columns different text
  495. Can I use solver to estimate several values by changing several c.
  496. formula increment
  497. Counting Multiple columns using single criteria
  498. Using VBA to make a user input a note when making changes to a cel
  499. Rounding up @ 3 instead of 5
  500. working with dates in excel
  501. deconcatenate
  502. Vlookup Maybe??
  503. Want to unlink calculations
  504. vlook up (average)
  505. Lookup
  506. enable Right-click menu
  507. Sum if match any six numbers
  508. I'm trying to create a thematic map in Excel
  509. Sort function won't work with copied sum totals
  510. Protect worksheet - losing values
  511. Sorting Existing Totals Into A New & Separate Column
  512. Filter data in a PivotTable report in value area
  513. Counting in a spreadsheet
  514. Delete duplicate data in a single cell
  515. SUM ONLY NUMBERS IN A RANGE
  516. One for the Master Minds out there
  517. Aging Formula Help
  518. concatenate numerics and text
  519. Formula result based on Multiple IFs
  520. Dropdown list
  521. auto update of date and time whenever changes are made to a xcel s
  522. I can't get a column to automatically add up using the prescribed
  523. Filtered table using Countif
  524. OLAP Pivot Function
  525. search a string as substring and give adjacent values
  526. Check for duplicates in 2 columns
  527. VLOOKUP
  528. Count with date range
  529. calculate weighted average effective interest rate
  530. Lookup info - Really need help please
  531. SUMIF with multiple conditions
  532. filtering time
  533. Need more help with a formula
  534. Conditional If Statements
  535. Is there formula to identify the matching data in Column B?
  536. Excel formula help please
  537. Worksheet names
  538. Formula result does not match displayed result
  539. Need help with formulas
  540. Converting cells to numbers
  541. What is VBA and where can I find more info on it?
  542. Counting Ages
  543. Subtract hours from a time and get the correct time
  544. if with or condition
  545. price ticket template
  546. The function in French version DECALER is not working
  547. How to Compare between cells and choose smallest value
  548. Vlookup question
  549. Counting Items
  550. Custom Filtering - Limitations of the "Contains" option
  551. Conditional formating, match, lookups
  552. Copying to next unused row
  553. To get an average of a column of numbers not zero/blank cells
  554. What function to calculate interest on savings
  555. Password
  556. Resource Scheduling/loading
  557. auto update of date and time whenever changes are made to a xcel s
  558. Help with XDATE function add-in
  559. Statistics problem
  560. Pivot table range selection changes when opening 2003 xls in Excel2007
  561. Count Text in Columns
  562. Lookup info in one Column and then returning info in other columns
  563. Using ISNA function, but replace the blank cell with text
  564. Percentage of filled in boxes in a column formula
  565. Creating a record in one worksheet from the data in another.
  566. Vlookup
  567. auto subtract
  568. Nested IF
  569. Good article on Microsoft
  570. Formula for Value
  571. Print data filled rows only
  572. Correct syntax for IF, Then in a macro
  573. Critical requirement.
  574. How do I make DATE non-volatile?
  575. Pivot Table field macro
  576. Excel Lookup?
  577. lotto numbers
  578. Value divided by time
  579. Vlookup , Referencing a cell to refence table array
  580. what formula for keeping balance of excess hours/minutes?
  581. Command to update data from one sheet to another
  582. Have a chart line completely disappear for a Series...
  583. calculate from time started and finished to get total time used
  584. Need help with whichever is greater formula
  585. Bedroom Requirement
  586. Adding data in columns based on criteria in more than one column..
  587. Calculate to the third decimal and round up or down in cell
  588. Pulling data from a cell in between /
  589. Countif fields with **
  590. How do I scroll in Excell 2007 with my mouse wheel?
  591. Eligibility Dates
  592. populating new cell with first populated cell to the left
  593. How do I protect Excel Workbook Structure except adding new sheets
  594. running totals
  595. Multiple Column Lookup in Excel 2003
  596. SumIf Formula
  597. if cell equals "a" then another cell would calculate percentage
  598. Productivity Log
  599. How can one set a value TO another cell?
  600. How do I get the IF function to work on more than one criterion?
  601. Only Print Pgs W/Info?
  602. Konsolidating tabels on diffrent sheets in one sheets
  603. False Statement won't show
  604. Converting Dates to Week Ending time period
  605. Is there a way to do a "lookup" and change the orientation of the
  606. Formulas are displayed in Excel instead of the data
  607. Adding a counting function within SumProduct
  608. Sorting a protected worksheet
  609. Pastelink
  610. Data Validation in Excel 2002
  611. How can I use a formula to calculate a running sub-total in excel
  612. Sorting Cells
  613. Auto filter question
  614. Mastersheet update problem...
  615. Protect After Saved
  616. REQ: Can I scan into Excel directly FROM Excel?
  617. ALIGNING TWO ARRAYS OF DATA VALUE
  618. Finding a minimum value in a cell that is constantly changing.
  619. I give up, trying to sum with non numeric cells.
  620. How do I add numbers to time?
  621. Find a Match in Multiple Places & Return Multiple Values
  622. Formula won't show sum
  623. Selecting Rows that meet criteria
  624. two-way variable table keeps repeating same value
  625. monthly spreadsheet- can not add date to inserted row
  626. How do I sort rows keeping columns together?
  627. how to calculate games odds
  628. Working with dates in excel
  629. Formula to calculate 4 possible answers in one cell
  630. I need a formula
  631. Percentage Help Please
  632. Formulas scrambled when sorting
  633. Not able to select Calculated Fields for Pivot Tables
  634. Updates via several stages
  635. Sum of cells based on entry of adjacent cell
  636. combine data into third sheet
  637. Count a range that matches the heading
  638. cell needs to show tab text
  639. formula involving buckets
  640. Excel: Cell Naming Bulk Delete
  641. Concatenate cells with text and numbers/decimals
  642. Yet another Average Function with mutl. Columns
  643. Sum Prodcut issue from .txt import
  644. Calculating total when multiplier varies by another criteria
  645. Copying data from 2 cells into 1
  646. How do I return a unique count where conditions exist?
  647. Copying Functions between Cells
  648. how to show whether 3 cells within a row match 3 cells in another
  649. Summing mulitple line items within date ranges
  650. Fund return v income
  651. Need help pulling percentages from all work pages
  652. TIMESHEET
  653. Copying DSUM formulas with absolute references
  654. Using Sub-Total function in locked sheet?
  655. HELP ON THREED
  656. VLOOKUP -- Table Array Problem
  657. Foot mark aka single quote mark?
  658. Average cells with #DIV/0!
  659. Conditional formatting - coloured text
  660. Print Column Heads WITHOUT Excel Column Lables
  661. I NEED SOME SERIOUS HELP =)
  662. Macro Help - Fairly Advanced.
  663. Tax Calculation
  664. need an aswer- URGENT!
  665. calculating revenue over months
  666. A formula to ponder on - I burnt myself out !
  667. Date Count
  668. Button with Hyperlink
  669. Format Prefix
  670. HOW TO RETRIVED THE PREVIOUSLY SAVED VERSION?
  671. Re: #N/A - "Value not available"
  672. SUMPRODUCT function for two arrays. Array 1 contains text
  673. Spreadsheet for bowling games?
  674. COUNT(IF((,,,)) function
  675. Special Print Instructions
  676. mutiple criterias formula
  677. I want to add more that 30 noncontiguous cells in Excel
  678. Shorten the formula
  679. IF formula string
  680. spreadsheet function
  681. VLOOKUP, MATCH, INDEX HELP!
  682. Match then Vlookup
  683. Automatically Duplicate Rows based on Volume.
  684. How do I create a data source using pictures?
  685. If Function on calendar, expense report.
  686. how do I save formulas in conditional formatting without retyping
  687. Formula Question SUMIF
  688. SUMIF Function
  689. Formulas--running balance
  690. Declining balance
  691. Find the three nearest dates
  692. Replace single 0 without affecting other cells
  693. Trying to get contents of cell linked through IF function.
  694. Has @DAYS 360 function calculated differently between qtr and mon
  695. Rank Function with Multiple Criteria
  696. Foramulas
  697. Lookup help
  698. Help with Look-up Function!
  699. Locate duplicates in column A, then, delete the row
  700. Complicated SUM IF formula
  701. Clarification on Find Text, then Calculate
  702. How to get a user's user id in an Excel macro
  703. print worksheet
  704. #REF! Error
  705. Use of 'INDIRECT
  706. group
  707. display unique data into third sheet
  708. formula question
  709. Vlookup- Closest match that contains the exact lookup value?
  710. Please help on IF formula
  711. IF Formula
  712. color few records based on data in another sheet
  713. Progress bar in spreadsheet?
  714. Different results: Networkdays versus date subtraction
  715. Counting Days
  716. Match data then comapre and return new data
  717. help with dates & calculations
  718. From SUMIF to COUNTIF
  719. Calculating results from cells containing formulas
  720. count cells that meet 2 criteria
  721. Multiple IF Statements with Three Variables
  722. salto de lÃ*nea
  723. Copying from our finance system I get the - on the back og the fig
  724. Convert a number to a text
  725. Data pick-up
  726. Dynamic Search
  727. Trouble trying to do a 'Count IF'
  728. Converting :mm:ss to ss
  729. Count Records
  730. Using Dates in Excel 2007
  731. Saving and Closing
  732. Search a column for values, return a value from adj column
  733. mutilple column formula
  734. Formulas
  735. Calculation Using "Most Current Data Entered"
  736. problem with excel formula
  737. Removing Space
  738. mutiple if formulas
  739. Overlay/backgrounds
  740. How do I hyperlink text in a cell to an embeded object
  741. In Excel, can I use the VALUE() function or similar for text?
  742. How do I obtain the average age of our members?
  743. Find & Replace: find part cell, replace whole cell
  744. Ho Do I write this IF function for calculation of soil moisture?
  745. Tidy lookup
  746. lookup table
  747. Making a Nonconsecutive range of data consecutive
  748. Skipping every other column for an Average.
  749. Consecutive dates in each excel worksheet?
  750. return multiple cells meeting a condition
  751. determine lowest number in several columns and replace lowest numb
  752. keeping a "floating cell"'s value
  753. Formula using "lesser of"
  754. lock command button
  755. Microsoft Office Excel
  756. CountIF
  757. How do I conditionally hide a worksheet
  758. Connecting Worksheets using and "if" "then" formula
  759. Do nothing if False!
  760. If then formula
  761. Formula questions
  762. Finding Zeros
  763. My Hyperlink function is greyed-out in Excel, how do I enable?
  764. Pivot Tables - Text From Source Being Truncated
  765. Counting date occurances
  766. How to increment budget automatically when entering a date?
  767. How can I import a picture on a protected worksheet
  768. Find text, then calculate
  769. How calculate difference between [t]:mm-format and general format
  770. if isblank question
  771. Macro based on Cell Value
  772. Form on Excel
  773. How do I format alphabetically in a column?
  774. Username upon Entry
  775. Averaging excluding blanks--Multiple Tabs
  776. Capturing average turn around time with constraints
  777. Issue Tracker Counts
  778. conditional maximums
  779. Formatting numbers with leading and trailing zero's
  780. Lookup Q
  781. transposing postal addresses
  782. Count Longest Consecutive Sequence of zeros
  783. Offset/COUNTA problems
  784. Simple Adding/Subtraction and format of cell. - HELP!!!
  785. Subtotal
  786. Networkdays including Saturday?
  787. sumproduct for numeric range
  788. VLOOKUP
  789. Data Input Date
  790. change cell event using circular reference - not VBA!
  791. HIGHLIGHTING DULPICATES WITH TWO COLUMNS & DELETING DUPLICATE
  792. Cell Reference
  793. REQUEST FORMULA FOR COUNTING & SUM IN DUPLICATES
  794. change cell event using circular reference
  795. Comments question
  796. Summarizing doubles
  797. Use of Vlookup vs Index-Match (workbook size)
  798. How do I make a section break in Excel
  799. VLookup
  800. Disbaling Error in formula notification
  801. Is there a way to save header that repeats from worksheet to works
  802. Make manually changed pivot table column headings work for other u
  803. how do I return a value between two other values from a table
  804. Calculating Dates
  805. Filter for unique value
  806. Find value in column, return value in same position of other colum
  807. Need to format varying zip codes...
  808. Characters in cell.
  809. Index/Match Formula across 2 worksheets
  810. count unique values in a filtered range
  811. Update
  812. macro averages number above and below
  813. Hide dimensions in a pivot table in 2007
  814. regression- estimated output table extend beyond bounds wksht
  815. Multiple workbook data imported into single workbook
  816. Conditional Formatting
  817. Need to assign new codes
  818. SUMIF [sum_range] / sorting question
  819. match or If
  820. What formula would transpose stale dated cells?
  821. What formula would transpose stale dated cells?
  822. Counting Days
  823. Using text to lookup different table arrays in vlookup.
  824. Can I insert 'carriage/line returns' in text string?
  825. Lookups...
  826. Compare and delete duplicate records
  827. Cost Charge Conundrum
  828. Subtotal Function
  829. Reference cell above in a subtotaled sheet
  830. Pivot Table
  831. How to limit the characters in a cell
  832. CONDITIONAL FORMATTING
  833. Rotational Date Changes
  834. SUMPRODUCT formula
  835. IF an array..
  836. BAG_DEG_DOLU_SAY (COUNTA)
  837. 2008 East Coast US Excel User Conference
  838. austrian number formats
  839. Referencing several cells with IF?
  840. Conditional Formatting (Icon sets - 3 Arrows)
  841. Can I use the IF function to display a message
  842. Grades to Marks
  843. help on vlookup
  844. Autoshow whole word when typing one item in the data validation bo
  845. how can i read the first row when i pull down the page??
  846. worksheet LOCKED
  847. asign the next 10th as the due date.
  848. Formatting a cell
  849. sop for excel in pharmaceutical industry
  850. Set day of week to display in date field
  851. Gathering rows of data from multiple wrkbks to single column
  852. countif
  853. compress a potentially long concatenate
  854. When applying a theme to an Excel workbook and it will not change
  855. Auto-numbering
  856. Nest IF function
  857. What function to use to return the no. of same value by mths
  858. How does one auto-change values?
  859. GET PAID FOR INCOMMING!!!!-FREE VIRGIN CONNECTION!!!
  860. Using a named range as a data source for a chart
  861. Sorting data in multiple columns
  862. Making this simple formula
  863. Sum / Sumif
  864. a cell in excel will not display the formula total
  865. "Custom" Data Validation
  866. More Fantasy Sports
  867. Data Validation, Custom
  868. days in a month
  869. Need to reference another sheet for two variables
  870. test
  871. Vlookup Problem
  872. merge excel into word and email
  873. How do I write the proper Formula for the following?
  874. Drop down menu problem
  875. Help! Need to lookup referencing 2 variables
  876. Text Color on Display
  877. Add/Revise data in separate spreadsheets all at once
  878. How to format range of cells using Conditional Formatting-Excel?
  879. Question regarding dates
  880. Total Number of Dups in 2 columns
  881. Count Dups in Two Columns
  882. HELP! selection box to display charts
  883. Sorting issues
  884. Formula to lookup product name and add qty's of all that are found
  885. concatenate
  886. Error Bars on Graph - Need help!
  887. How do I import data from 1 excell workbook to another?
  888. VLOOKUP returns a 0 and I want a blank
  889. Microsoft Word
  890. drop down list with auto suggestions
  891. merge four sheets containing one form each to one sheet
  892. Hide Group Boxes Around Option Buttons
  893. writing a formula to distinguish a letter and a number
  894. How do I calculate maximum with variables.
  895. How to change syperlink from single click to double click
  896. Excel insert question
  897. compounding years and months
  898. Drop Down Menus
  899. Selecting mutliple ranges
  900. if function with extras.
  901. How do I post specific dates into a colums labled only by Year?
  902. formula needed... IF, SUMIF, or SUM ???
  903. Help!
  904. Awkward sumif/sumproduct with three criteria over two ranges
  905. SUMIF Function
  906. sort with custom list
  907. Help with the first sheet to be automated.
  908. excel, what if function referencing another cell
  909. How do I use the HandleNA fomula?
  910. too many different cell formats
  911. Adding Random Numbers
  912. How do I disable the "insert" function in excel?
  913. Date related Problem
  914. WRITING A WHAT IF FUNCTION
  915. file locked for editing
  916. copying a row
  917. Difference between last date of month and given date
  918. Formula help - possible vlookup/hlookup combination with IF or oth
  919. formulas needed .. thanks
  920. To generate Numbers in Excel
  921. CountIF
  922. Remembering lookups
  923. Graph of 2nd serious in the Line type graph is not connected
  924. Finding the interest rate.
  925. Drop down list help
  926. Column I:I blue
  927. De-dup and retain new records only
  928. VLOOKUP
  929. Copy protection from one worksheet to another
  930. How do I make the data sheet appear in my power point presentation
  931. Data Validation, Custom
  932. How to compare a cell containing a date in sumif criteria
  933. How can I conditionally hide or display data in a cell?
  934. Breaking links
  935. Refresh Pivot Table when Sheet is PW Procted
  936. Counting items in one column based on criteria in another column
  937. Formatting
  938. cell - wrap
  939. Multiple Excel files
  940. Weeknum Issue
  941. Help...Office Excel 2003 IF Function
  942. Add a letter "E"
  943. Incremental References
  944. linking data from sharepoint to excel spreadsheet?
  945. CODE FOR (DURING TYPING IN CELL RUN MACRO)
  946. multiple subtotals
  947. Controls on Spreadsheet
  948. Conditional Sum
  949. Worksheet function needed
  950. Help Optimizing a Sheet to improve performance
  951. Formatting
  952. error message in excel. can someone explain
  953. return next highest number in range
  954. Need a Match formula
  955. Macro filldown
  956. Deducting from a total!! HELP!!!!!!!!!!!!!
  957. When inserting date , how do I have the month spelled out
  958. MY FORMULA WILL NOT WORK
  959. Help to copy multiple columns to a spreadsheet
  960. Help! tabbing in worksheet causes excel to freeze
  961. Formula To Sum Up Daily Food Exchanges
  962. Document won't view
  963. Excel Formula
  964. Discount Formula Question
  965. repeating values
  966. Conditional Formulas
  967. excel 2003 will not open CSVs parsed
  968. Excel Textbox
  969. Shared File Issues
  970. linking footer to a cell
  971. Complicated Table Functions
  972. Either percentage or dollar discount formula
  973. ASSESSMENT FORMULA
  974. Highlighting chances in shared worksheets
  975. FTP information retrieval
  976. Complicated lookup
  977. Help needed for excel formulas!!!
  978. Formula, text and currency in same cell
  979. Getting round the sensitivity of "sumif" formula
  980. Conditional maximum
  981. rulers in excel
  982. DAYS360 + 2 If Functions
  983. referencing worksheet tabs
  984. Excel link with Word
  985. Data Validation, Custom
  986. Excel
  987. excel formula
  988. SUMIF
  989. Adding text columns
  990. SumIf
  991. Worksheet showing # col headings. How to chg to letters?
  992. Lookup
  993. Formula for showing items per minute
  994. Date formula
  995. count only certain cells
  996. Conditional format -> another cell
  997. Comparing Model Numbers without a giant IF statement
  998. Conditional Formatting Function for Anniversary Dates
  999. Hlookup and sum noncontiguous numbers
  1000. Summing across multiple sheets using a changeable reference cell