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. Conditional Formatting
  2. getting gridlines to show up on printed document
  3. date range within a date range
  4. Conditional Formatting
  5. How do I change the direction when pressing ENTER? (dn, rt, etc.)
  6. Multiple Criteria for Sumproduct
  7. Getting rid of Macro and Update Prompt
  8. SUMPRODUCT or SUMIF if any values in a range equal any values in another range
  9. How can I select the arrows in my spreadsheet?
  10. Excel formatting dates
  11. comparing times in excel
  12. how do i get datedif function downloaded into excel
  13. change text format dependant on formula result
  14. Need formula to prevent typing in duplicate numbers
  15. Count IF
  16. Hyperlink to cells in other workbooks keep changing
  17. can I make a macro to print?
  18. If, then, vlookup
  19. Apply Conditional formating to all cell
  20. Excel Formula
  21. Re: Separate text and replace characters
  22. cell data in fixed position
  23. Should I be using IF to find how many times a word occurs in a ran
  24. Count records where date is within the last week
  25. How to add traffice light
  26. IF statement help please
  27. If, VLookup, Index, or a combination of all of them?
  28. Combining Uneven Columns
  29. Running two formulas as one
  30. All functions that use commas aren't working!
  31. Conditional Formating
  32. What is wrong with this nested function?
  33. Oracle import
  34. SUMPRODUCT Issue
  35. Complex formula assistance please.
  36. AVERAGE
  37. Duplicates in Excel 2007
  38. Rounding Negative Numbers to Zero
  39. Formula result and displayed result are different
  40. Calculations from tab to tab not automatically updating
  41. How can I use circular references that are allowed in Lotus 123?
  42. DSum - criteria in different row than value to sum
  43. Saving a file as a PDF
  44. Searching for text
  45. change date from 20-Mar-1920 to 20/03/1920 format
  46. Template or Excel ?
  47. Calculation using a date
  48. Paste solution
  49. highlight cells different colors in row
  50. font in drop down
  51. to fetch the rebate from another worksheet using itemcode
  52. Copy line if
  53. count function ???
  54. Working with Date/Time
  55. text as number
  56. I want to create an IF statement that leaves a cell blank if....
  57. Adding Days and Hours
  58. Showing date as day of week
  59. Excel Column Summation
  60. Averaging to-date lists???
  61. Array formulas/selecting data
  62. Totals of different worksheets.
  63. Is there a function that will return/copy an entire row?
  64. how do I get to cursor to stay on the cell when I press enter
  65. Age Date Between Two Dates to Return Value as 30, 60, 90 day
  66. Copy Paste in Excel 2007
  67. LINEST and Dynamic Regression
  68. Lookup Sizes and Concatenate
  69. Changing case
  70. sumif function or something else needed?
  71. adding a percentage for COLA to Payroll worksheet
  72. Comment in formula
  73. Lookup Across Multiple Columns - Return Category names
  74. string contra VBA code
  75. make a sound when a certain value is reached in a specific cell
  76. strike through
  77. Vlookup with changing columns
  78. customer Name against Unique customer number count
  79. Double Lookup
  80. UPDATE Query
  81. Sumifs function
  82. Using =MAX() or =MAXA() on Pivot results doesn't work
  83. Inserting Rows and the affect on Functions
  84. Circular Error
  85. header row
  86. If logical function with text and numbers
  87. what is the meaning of <>?
  88. Can you combine Hyperlink and Vlookup in Excel?
  89. CONDITIONAL FORMATING
  90. delete a range
  91. how to merge execel sheets in excel 2003
  92. using pulldown list with a list and autocompleet function
  93. Rate vs. IRR
  94. Price time to cost
  95. Does complicated sumproduct formula crashes excel?
  96. Merge base on same code number
  97. How do I get the week in month from a date?
  98. Run Excel macro from Scheduled Task
  99. Time and Date populates automatically
  100. determining best data using functions?
  101. Average IF?
  102. IF formula returns blank cells--only want values to show
  103. Copy from one page to another
  104. Filtering / Dynamic Dashboard Question
  105. Array Help?
  106. Combining Lookup function and Sum function
  107. VLOOKUP question concerning population a price
  108. Formula Help-returning False
  109. excell 2003 result in t
  110. Averages with conditions....
  111. keeping same-row(or column) cell constant in a formula while drag-
  112. HLookup
  113. How do I see all previous posts
  114. If statements using less than or equal with dates
  115. Re: Update values from one column to another
  116. formula to insert time of day in excel cell
  117. How do I use ColorRank()?
  118. formula to insert time of day in excel cell
  119. formula to insert time of day in excel cell
  120. How do I set up my data extraction
  121. How to arrange worksheets in alphabetical order?
  122. How to arrange worksheets in alphabetical order?
  123. Change Names to E-Mail addresses Q
  124. how convert cell formula value to text
  125. How do I do this?
  126. ImageShack Hacked - Popular Image Hosting Website Vandalized
  127. seksi djevojka
  128. seksi djevojka
  129. calculate overtime at 2 different rates
  130. seksi djevojka
  131. seksi djevojka
  132. TRANSPOSE results in zero values for blank cells
  133. TRANSPOSE results in zero values for blank cells
  134. Format based on cell contents being a formula or not
  135. TRANSPOSE results in zero values for blank cells
  136. using the ROUND function in a cell that already has AVERAGE functi
  137. Conditional Formatting (I think?)
  138. formula for sorting mailing lists for multiple records per sheet
  139. Formula to calculate differently based on original value
  140. countenvenate
  141. Count based on single number in string
  142. Sum used in macro where range stops at first non numerical cell
  143. RE: maxa function results in value error in worksheet
  144. RE: reporting value from other sheet
  145. Excel Formula
  146. Replace formula with value automatically.
  147. Rounding off time
  148. Excel Spreadsheet Functions
  149. Master Form to Database
  150. In what way has excel 2007 improved on Array functions?
  151. COUNTIFS formula question
  152. How to hide 0.00 on spreadsheet with formula?
  153. Need help with "if" formula
  154. is there a way to type a number and have it translated into text?
  155. VLOOKUP and Return Last 2 Values
  156. Unique value list
  157. ProgressBar control displays erratically on Open
  158. =today()-3/7/2009 = 4?
  159. Capturing excel insert/delete events.
  160. Capturing Insert/Delete Events in Excel Sheet using c#
  161. inserting in wrong location
  162. Method Add of object Validation Failed - please help
  163. locking a cell value for continuous additions updating (YTD incom.
  164. Excel 2007 XML Export
  165. Help With ADDRESS Function
  166. Counting Days of the Week
  167. make copies of sheet and name them from list
  168. Match and copy
  169. Seperate date and time
  170. Formula If statement.
  171. Rounding Of Concatenated Costs Field
  172. complex CountIf situation
  173. How to copy Formatting Attributes from Source Workbook when Linkin
  174. IF, INDIRECT, & Wild cards
  175. Concatenate If
  176. look-up in a range
  177. Need help with end results Microsoft Office Excel 2003
  178. Time Keeping Spreadsheet (Need not to Exceed Formula & subtracting
  179. Double SUMPROD
  180. Link to Access & Named Range
  181. How do I combine ISNA and IF functions
  182. Combining ISNA and IF formulas
  183. No including ZERO'S when using Average fucntion
  184. TAB to enter data, it skips one or more cells
  185. Check 3 cells, only one of the cells my be filled
  186. How to compare worksheets so differences are identified
  187. Easy for you...add % increase column?
  188. Conditional formatting and what if function
  189. NPV - when does the first year start?
  190. Formulaic range with CountIf
  191. average using two criteria
  192. Sort with Link
  193. Search for inverted commas
  194. Excel functions
  195. If Formula Help
  196. sheet name in cell that is used by other formulas
  197. Inserting data from one worksheet to another
  198. SUMPROD and OTHER FUNCTIONS!!! VERY URGENT
  199. find text from 1 col in 2nd col & return value from 3rd col
  200. Hyperlinks
  201. Autosum and formulas that result in text
  202. vlookup vs sum
  203. "excel "macros may be disabled" message using an xlam file
  204. Excel 2003 - Relocating an entire row of from one worksheet to ano
  205. Convert Date to Another Format
  206. Countif, multiple criteria
  207. Expiration dates
  208. Can't unshare workbook
  209. multiple IF Formula help, Please
  210. Hiding/Exposing Rows based on a cell value
  211. Excel 2003 - Protecting Cells but allowing external data updates
  212. Freezing a row
  213. Unhiding rows in Excel 2007
  214. Using SUMPROD and trying SUBSTITUTE, ELIMINATE or TAKE the last VE
  215. MID, LEFT, RIGHT help
  216. add a value to the cell value itself
  217. Count if text meets given criteria
  218. Average only if ALL cells filled.
  219. Non Numeric String Lookup Issue
  220. how do I seperate information in one cell and make it into 2?
  221. Average with specific criteria
  222. Eliminating blanks
  223. Counting text problem - formula works initially
  224. return the price of an item in a cell
  225. Re: Lookup on multiple values
  226. Need Correct Function
  227. Calculate Minutes elapset between two cells
  228. Sorting columns on weekdays
  229. Conditional if formula.
  230. SUMIF on a Calculated Field
  231. Create a drop-down list from a range of cells
  232. count for multiple conditions in multiple columns
  233. I have a very specific question about excel, please help!
  234. How do I insert hyperlinks in blank cells
  235. Database questions, giving text a numerical value
  236. why does my excel change the print options of another user's file
  237. Sumproduct question
  238. One validation drop-down populates another?
  239. Simple problem complex solution?
  240. How do I edit several formulas at one time in a worksheet?
  241. row and cell highlighted
  242. Series number changes for default colors
  243. TOTAL AND AVARAGE
  244. Maxifs
  245. significant figures
  246. Data Validation
  247. using the "&" function
  248. Compare A&B columns with C&D columns
  249. Match
  250. SUMIF data that falls within a range
  251. Count Distinct Values based on criteria
  252. Sharing workbook from the server 2003
  253. locking multiple rows in excel 03
  254. Linking more then one cell to a Check Box
  255. Working with 2 worksheets
  256. scheduling
  257. CONCATENATE zeros
  258. EOMONTH, TODAY() and Conditional Formatting (Excel 2003)
  259. Count with multiple conditions
  260. I need and and/or statement
  261. Max amount of "IF" statements
  262. Sum Product values meeting 2 criteria
  263. Looking for a solution
  264. ytd totals for multiple years
  265. Conditional Counting of Duplicated Names
  266. can i automatically copy subtotals in excel to another s/sheet?
  267. Min Date againsts unique customer list
  268. maximum value (for a calendar date)
  269. Scroll with the mouse while editing a cell
  270. Hopefully an easy question
  271. =Text(n,"mmm") always returns "Jan" when n=1..12
  272. Which function/formula?
  273. Conditional Formatting Traffic Light System
  274. Need a number format.
  275. Calculation options change arbitrarily
  276. Sorting a spreadsheet and having it continue
  277. negative time in Hours and mins
  278. How to format a number.
  279. PivotTableWizard help with VB
  280. new summary function in pivot table
  281. AutoSum and text
  282. Future Value Function (FV)
  283. Cell Content via Secondary Formula
  284. Dat. Validaation - simple ques
  285. Sorting a list
  286. how do i set up salse report for 24 filling station
  287. FILES IN excel
  288. Time format
  289. how can i filter a list and display result in a new table (Excel)
  290. Creating child worksheet from parent
  291. giving me #Value!
  292. Identifying Duplicate data between 2 columns
  293. Trying to count the number of times a name appears / table
  294. Looking up same value
  295. Minimum IF Statements
  296. Need Help to repeat a symbol in each cell in a column
  297. Copy data from one worksheet to another
  298. test for upper case
  299. Any way to change generic icons in quick access toolbar?
  300. conditionals statements
  301. How do I add a column of numbers (auto sum)??
  302. Need assistance
  303. Assign Color to a Cell based on another Cell on a diff Sheet
  304. Sorting after my worksheet has input I want to save
  305. Nesting If and And
  306. Conditional Formatting #n/a
  307. Filling empty cell with value from the cell above
  308. Conditional formatting
  309. Drop Down Lists
  310. Too Many Conditions for IF Function - Help Please!
  311. Formula Based on Tables
  312. Custom auto filter (Dates)
  313. When editing a formula, how do I get the mouse wheel to work?
  314. Hide unused rows based on column info
  315. Add a row and totals based on changing cell values
  316. Calculated Fields in Pivot Table
  317. Counting Values amongst #N/As
  318. conditional statement =IF(A1<B1,"<",IF(A1=B1,"=",">")) <--- don't
  319. Hyperlink worksheet data to a index in a workbook?
  320. conditional formatting adjacent cells
  321. using =COUNTIF() in a variable range on a different worksheet?
  322. Aging Dates in Cond. Formatting
  323. Product Code and Product Description setup
  324. excel 2003 zero as last decimal again
  325. using worksheet.change function
  326. USe Contents of cell as name of worksheet in a function
  327. how do I sort four colunms date order different headings
  328. How to customize defaults in Pivot Table Values
  329. Programmatically add a Formula in a worksheet?
  330. Pivot table calculated field: multiply Sum of FieldA with Max ofFieldB
  331. Months not appearing in grouped dates in Pivot table
  332. how do I save and close multiple files in excel 2007
  333. PEASE ADVISE EASY WAYS TO CREATE VLOOKUPS in excel
  334. Convert Text to Formula
  335. Search and present lists
  336. paste special not working
  337. Wat formula shuld i use to find the details in the cell?
  338. How to combine text and numbers in exel
  339. 3D Array Problem
  340. [0]
  341. Macro for Insert/ Copied Cells
  342. How do I delete an already previously saved Excel spreadsheet?
  343. Message Box: Delete row x?
  344. vlookup
  345. vlookup
  346. Cummulative sum against Condition
  347. sumif with two conditions,current financial year date
  348. SORT data containing formula
  349. display a date
  350. THE WORLD OF INTERNET JOB IS OFFEREING U TO EARN $1000 IN ONE MINUTE
  351. Date Incorporation Frustration (sorry for the re-post)
  352. Find Function
  353. How to weave in Date Information please?
  354. How do I weave in "date" information to my formulas?
  355. Extracting Address data from single cells
  356. Same contents but not equaled
  357. Formula for Range area within VLookup?
  358. ADD 2 COLUMNS USING 1 LETTER AND 1 NUMBER
  359. microsoft excel 2007 keyboard shortcut for file menu
  360. Sumifs, averageifs, countifs
  361. DSUM with criteria:blank OR > some value
  362. Ole Automation and Excel 2007 footer
  363. sumifs in linked workbook
  364. Is there a maximun number of cells allowed in a name range?
  365. delete row formula changes array range on related sheet
  366. how to zoom into excel line chart with about 2000 point tia sal22
  367. if statement issues.
  368. Hide Columns based on a cell value
  369. macro that adds formula to replace text
  370. Merged cells disturb autofilter indicator
  371. Best site for freelancer work
  372. SUM of areas
  373. Conditional formatting
  374. 1. Is it possible to do this excel?
  375. File name from cell
  376. How to reference another cell based on what row a certian header i
  377. Writing Macro in Excel 07
  378. Using " " in If functions
  379. combining or "flattening" rows
  380. Specifying comparision criteria with SUMIF()
  381. Modifying several worksheets simultaneously
  382. plus 6 months
  383. can't find the right formula
  384. conditionals formulas
  385. Conditional Formulas
  386. calculate percentage of pay based on days old
  387. if function help
  388. Max date only against met criteria
  389. Update Links
  390. Excel 07 - converting pivot to formulas gives #N/A
  391. Fractions
  392. conditional formatting highlight dates 90 days or less
  393. CountIf function on combo-box entries
  394. Deriving Exactly XXX Amount of Weekdays
  395. Multiple Conditional Sum Help
  396. Need Help with formula writing
  397. Inserting a worksheet
  398. hiding the popup control calendar after clicking a merged cell??
  399. conditional formatting
  400. Pivot table treating numbers as text in value field
  401. Worksheet help
  402. How to compare a row data from one worksheet to another worksheet
  403. Macro's
  404. Re: Number of Specific Day within Dates
  405. count based on single number
  406. excel interaction with Windows Desktop Search (WDS4.0)
  407. workbooks transfer from 2000 to 2007
  408. How to join word in one cell
  409. Reference to worksheet in chart
  410. Linked cell shows ######
  411. Find and return name of worksheet tab for referenced cell
  412. how can i use form/skjema tool for meny list spred in dif arks
  413. excel 2003 zero as last decimal
  414. Advice/best practice needed maybe some complex VB aswell
  415. Getting SUMIF to work in Excel 2007 filtered tables?
  416. Using Macros To Perform Multiple Averages
  417. what is the formula for mean?
  418. Sharing Worksheet
  419. Colour cell
  420. New 2007 Sumifs formula - Is there a new 2 criteria vlookup?
  421. can I use the sumif function with cell formatting as the criteria
  422. RE: From a list select the name with the most occurences
  423. Find & and delete everything following
  424. How do I set up a format to round whole numbers into hundredth?
  425. From a list select the name with the most occurences
  426. I need a formula PLEASE HELP
  427. Combining If and Concatonate
  428. Adding the total # of characters in multiple cells
  429. adjust curser movement
  430. Triggering an action when an item is selected from a dropdown menu
  431. AUTOMATICALLY CHANGING DATA FROM CELLS ON DIFF SHEETS
  432. Find/Replace
  433. Find Text Within Text
  434. External link lag
  435. Update Date
  436. Unique Count
  437. VLOOKUP plus IF
  438. Can you rename an inserted word document?
  439. use of ADDRESS function within CELL function
  440. HOW CAN I INSERT DATA BTW TWO WORKBOOK
  441. formula checking if all cells are greater than x
  442. Adjusting formulas by copying across cells w/o changing the refere
  443. Remove the formulae, but keep the data
  444. Find and match funtion
  445. Automatic copy between two workbooks
  446. Need to average data if in cells, but ignore blank cells.
  447. Display multiple results based on one cell
  448. Advance Filter Problem
  449. cell matching issue
  450. SUMPRODUCT
  451. Format Number 000000 00000 000000
  452. Linking spreadsheet
  453. Using absolute functions "$" to populate a column from a row
  454. Formulas and Function Required in Banking Sector
  455. New 2007 Sumifs formula - is there a new multiple criteria vlookup
  456. sumif?
  457. Highlight the cell based on selected value
  458. what is the Function for reducing balance depriciation?
  459. conditional formatte date in a1 calculate the date in A2
  460. Formula doesn't work unless hit enter again
  461. Relationship between number
  462. Correlation between 2 variables
  463. vlookup with 2 criteria
  464. Please Help - Trouble with counting occurrences in external file
  465. calculate average from non contiguous column, ignoring (0) values
  466. how do you have 2 criterias be picked up in a lookup?
  467. Excel - text in one cell
  468. Two possible values with a lookup?
  469. need help for a beginer!
  470. COUNTIF( {local cells}, {number from other sheet})
  471. Average while using SumProduct
  472. MAX IF?
  473. Trying to make averages AND sums of one spreadsheet of information
  474. Averaging, but excluding zeros
  475. Moved workbook-File name, minimize, maximize and close are not vis
  476. RE: Number of Specific Day within Dates
  477. RE: Number of Specific Day within Dates
  478. Array formulas not working in Excel 2003.
  479. Re: Number of Specific Day within Dates
  480. FINDING AND LISTING UNIQUE DATA IN A COLUMN
  481. Combining 2 percentages into one cell and displaying as % format
  482. Function to add 3 column (of YES) to give a total % complete
  483. Combining two functions
  484. Worksheet Limit in Workbook
  485. FREQUENCY with multiple criteria
  486. Help
  487. How to return a value from another workbook
  488. How to return a value from another workbook
  489. I need a formula.........
  490. Index Formula
  491. Average of values that need to be looked up from another sheet
  492. sum function
  493. Weekends
  494. Conditional format entire column
  495. countifs
  496. Rearreng Manualy in Pivottable
  497. How to not get '0' or '#DIV/0!' in a cell with a percentage formul
  498. Need help sorting data
  499. Need help sorting data
  500. Logical Function excel 2003
  501. IF cell contains certain text return value
  502. How can i set a formula which shows 2nd last Monday of the month?
  503. How to set formula for poping up the date of next Wednesday....
  504. vlookup more then 1 match or how do I
  505. Conditional Sum in Array with wild card and between dates
  506. Make them work on the Each cell Value
  507. Assist with formula
  508. Multiple column filtering
  509. How can I group and display columns automatically?
  510. How can I get Microsoft excel to calculate increasing number again
  511. Breaking links in Excel
  512. Skip Rows in Fill Series and Filter to Two different sheets
  513. How do I apply a cell formula to an entire column?
  514. Print Menu
  515. unable to open protected document I created
  516. select max value from row of data and column containing max value
  517. how do i remove an excel link that break link won't remove
  518. Conditional formatting dates?
  519. Automatically copy from Master worksheet to others
  520. Rolling 12 month total
  521. Excel should allow at least 2 vertical and horizontal splits.
  522. SUMIF, IF ?
  523. Conditional Format and Highlighting question
  524. Sorting 2 data columns in Pivot Table
  525. Excell formula or setting to recalculate periodically.
  526. Help with SUMPRODUCT
  527. Hyperlink to a specific place in a document
  528. cell w/ drop down then reference
  529. Multiple Scenarios
  530. Multiple Scenarios
  531. Sum Value of rows based on two common fields
  532. Number of Specific Day within Dates
  533. Selecting Random Records From an Excel Sreadsheet
  534. How can I validate my Excel password against a INI file
  535. Using Advanced Filter: How do you MOVE the selected rows...
  536. COUNT function
  537. Can I use an "If, then" function here...
  538. I'm an excel beginner please help
  539. Re: How do I get my macros from an XLA file to show in Tools > Macro
  540. Re: Finding top n most frequent - 2 subtley different problems
  541. Add to a formula
  542. Re: How do I get my macros from an XLA file to show in Tools > Macro
  543. Re: Consolidate invoice data
  544. Re: Can I Assign A User Defined Function To A Cell?
  545. Update a date into the same cell?
  546. concatenate a double-quote
  547. how do I calculate a week days hours with the 24hour clock
  548. calulating a certain weekday hours within a 24 hour roster
  549. Problem with array ref (I think!)
  550. Conditional Formatting - Comparative Versus Other Cells
  551. Excel Macro
  552. More info !
  553. sorting by name
  554. logical functions utilizing percentiles
  555. How to set up countdown timer to countdown days to a specific day
  556. Function for price qoutation help
  557. Need help displaying odd numbered month
  558. TURN $6 INTO $6000 $$$$$$$$$$$$$$$$$$$$$$$$$
  559. due dates
  560. How can I lock specific cells w/o having to protect entire sheet?
  561. Creating Bell Shape
  562. count formula
  563. * instead of value
  564. Hide Selected Objects
  565. If statement - can it stop once a conditon is reached?
  566. Functions as text
  567. Problem in time calculation with specified number
  568. Too many characters in header
  569. Worksheet
  570. trouble with calculating wages to hours worked
  571. Re: Find the lowest number in a given column
  572. transfering cell values progressively through worksheets
  573. Drop Down lists and condtional formating
  574. Locking a Spreadsheet but allow inserting
  575. hiding freeze pane reference lines
  576. Dynamically sum rows
  577. Copy conditional formatting across column in the same row
  578. Duplication number with formula help
  579. use AND in ARRAY formula
  580. CAn IF compare two cells?
  581. Can't get my xlSheetVeryHidden
  582. Adding 2 columns together on 1 worksheet with sum on other.
  583. Averaging data from a range calculated using cell reference number
  584. How do I create IF function that inserts cells when condition is m
  585. Can I insert in a cell the "date revised" (in a worksheet,etc)
  586. Can I replace data in all sheets in a workbook at the same time?
  587. Odd problem with formula counting Yes and No
  588. MISSING PARENTHESIS
  589. Max with Conditional Formatting in Office 2007
  590. tracking inventory
  591. Excel 2007 - Developer tab - xml import/export functions
  592. Extracting Rows based on a number in a field
  593. AUTOMATIC CHANGES HIGHLIGHTING
  594. Conditional =CONCATENATE formula
  595. Sorting Dates by Month and Day only
  596. Nested Greater than or less than if statements
  597. Absolute value conditional formatting
  598. CONDITIONAL FORMATING FORMULA
  599. Zero's
  600. Excel2007 Conditional Formatting Slow Performance Issue
  601. Duplication of string values within a range
  602. Assigning a number value to strings
  603. How do I get a new calculated date from different date ranges?
  604. Keeping the selected font when creating charts in Excel 2007
  605. Need a formula
  606. excel hyperlink text to display and vlookup
  607. Iserror for an array
  608. Worksheet protection
  609. View sheets (pages) horizontally
  610. Doing multiple borders
  611. Relative Worksheet references
  612. If blank cell, copy information from cell above
  613. adding text to the end of a formula
  614. Pivot Table Percent Question
  615. VLOOKUP
  616. most popular keyword
  617. How do I subtotal specific / random rows from a spreadsheet?
  618. ACCRUED INTEREST (ACCRINT) Bug
  619. need complex if formula (I think)
  620. VLookup formula question
  621. SUMPRODUCT not working.
  622. Want to split 922 037 022 into 3cols and recombine without spaces
  623. Automatic Cell Copy to other worksheets
  624. forgoten password
  625. is there a formula that will subtract todays date from a hire date
  626. VB CODE
  627. Histogram Function
  628. lookup issue....
  629. Copy/Fill increments
  630. Excel Comments
  631. Sorting Coloumns that are Formula's
  632. Copying Worksheets which contain Named Ranges
  633. Isolate UNIQUE combination of Z cells from a range N that adds up
  634. Merge two columns of data with a condition
  635. i need some help in a type
  636. Extracting email address from various data
  637. Check for CAPS
  638. Track Changes
  639. How do I freeze individual cells with formulas in them
  640. how to use vlookup for more than 1line
  641. count value dependent on unique or repeated values in another colu
  642. how to make a preforated page-break insert
  643. Merge 2 datasheets into single Pivot Table.
  644. What If Scenario and/or Pivot Table
  645. Array formulas
  646. How do I get Excel to display a table on a different worksheet?
  647. Conditional Count Formula
  648. Search
  649. Woman age 40
  650. Woman age 40
  651. Conditional Format: % of total
  652. excel - outlines
  653. Auto-adding text when a certain number is input
  654. Replace hard return with a delimiter?
  655. Change Chart Data
  656. If Statements??/Conditional formatting from drop-down multiple she
  657. Copyin the greater than 15 days project rows from one sheet to ano
  658. Printing spreadsheet print area to 1 page fails to shrink image en
  659. Finding the first value that is less than zero
  660. Reconize the first digit only
  661. i need to figure 55% for a range from 300 to 499
  662. Hide row based on cell value
  663. Turn of 'Read Only'
  664. Protected worksheet/tab key
  665. How can I create a simple form where users can tab between fields
  666. Return Value using If statement or Lookup?
  667. how do i create a formula in Excel - count by a specific date
  668. Cycle Times
  669. Pulling data from Sheets in A workbook
  670. Excel lock / Notify feature malfunctioning
  671. specify data size in cell add 0's
  672. How do you update a cell after an operation on it.
  673. How to update a cell after a calculation?
  674. How do you do a calculation?
  675. Using tab key in protected worksheet
  676. Comparing two colunms
  677. how do you highlight the result of an IF statement
  678. adding a zero in front of a colon
  679. AUTOMATIC COLUMN TRACKING
  680. if statment
  681. Name
  682. ISNA Formula returning "False" instead of value
  683. How to average the last 10 numbers in a row?
  684. VLookup formula transposing table_array when copied to another cel
  685. Range - using in code
  686. Eliminating Duplicate values on a large workbook
  687. sum function
  688. Sum function
  689. sum/autosum not calculating correctly
  690. hyperlink to another doucment and open it
  691. Chart on Excel 2007
  692. Column sum will not add
  693. Excel lock / Notify feature malfunctioning
  694. Count a number in a range with cells containing more than one numb
  695. COLOUR MANAGEMENT
  696. Counting with multiple matching criteria
  697. Modification Time Update
  698. DSUM using alpha numeric codes
  699. give each NO in a drop down a different value
  700. Conditional programming
  701. Limit data entry in range of cells
  702. Sports Tipping Formula!
  703. Change cell color in protected sheet
  704. can EXACT search for text in an entire spreadsheet?
  705. Summing Data by Date
  706. Mulitiple Criteria using SUMIF
  707. Excel Maximum viewable numbers in a cell
  708. Daily compound interest
  709. Text
  710. Re: IF formula & formatting
  711. NETWORKDAYS Worksheet function
  712. Formula for 0
  713. Issue with dynamic chart mapping out blank info
  714. find for non zero values in a column Median,Mode,STDEV
  715. Vlookup function wont work for copied data
  716. Vlookup function across data copied from various sources
  717. Comparing dates from VLOOKUP functions not working right
  718. @IF Formula
  719. Paste Special Glitch
  720. Date comparisons within AND() functions
  721. Formula for Minimum/Maximum
  722. Auto Arrange
  723. Countif issue
  724. VLOOKUP FORMULA
  725. data validation drop down list format
  726. Auto Insert Data
  727. FORMAT
  728. Conditional Formatting Problem
  729. specific data
  730. Incrementing a formula within an excel cell
  731. Using If function with text values
  732. Seperate Names on Columns
  733. OFFSET and MATCH functions for cells
  734. Formula (Excel 2003)
  735. Lookup related question
  736. Automatic Date Aupdate
  737. Selecting rows to another sheet
  738. conditional formatting gliche.
  739. formula that strips the first letter of the first name in a cell
  740. Need a Function
  741. IF ERROR Formula
  742. Protected cells can't be grouped
  743. Finding Circular References
  744. Vlookup and formatting correctly
  745. Adding 2weeks and rounding up to EOM
  746. If question
  747. using autofilter data
  748. How do I take data from one workbook and enter it into another?
  749. Sumproduct - number & text
  750. "Count non blanks" if cells don't equal certain values
  751. How do you remove the page number watermark from an excel?
  752. Range - Formula
  753. how do I clear #DIV/0!but leave the formula in cell
  754. If any specific #s are present in range, show each in another cell
  755. Assigning strings number values and adding them together
  756. Rental yeild formula?
  757. Counting number of occurances of a word
  758. CountIf question
  759. Date-time updates every cell?
  760. Row Height-expand if text wraps in a cell
  761. Excel Functions - IF?
  762. How can I delete the rulers from my worksheet in 2007 Excel?
  763. select ever other line
  764. extract cusotmer name from test string
  765. Autopopulating formulass horizontally?
  766. 2 Dependent lists based on the same list
  767. Last "non-blank" value in a Row...
  768. Subtotals - is there a way to include more information on the line
  769. Formular Function
  770. Sumif based on dates
  771. If statements refering to data validated ranges
  772. desperate.. convert to number column...
  773. SumProduct
  774. sumproduct issues
  775. Why is there no Freeze Panes option in the Windows drop-down box?
  776. Autofill Colour
  777. Multiple sear criteria
  778. varying a cell and seeing the outcome
  779. Automatic Colour Control
  780. Time management
  781. Re: Auto update between two workbooks
  782. Autofill issue
  783. How to link different worksheets into the 1 menu on a septerate sh
  784. Macros
  785. Re : How to lock a cell once the value is entered
  786. Auto update between two workbooks.
  787. vlookup
  788. Need Help with "SUM" AND "ABS" in same formula
  789. Locking data between worksheets
  790. Macro??
  791. Max Value - based on a time period
  792. How do I insert a dynamic reference of a range inside VLOOKUP?
  793. Excel "Exact" Function
  794. Header Row with Option to Shrink/Expand Rows Beneath
  795. is there any built in function to draw lines
  796. Formula to auto calculate based on other variables
  797. Delet Duplicate Blanks rows
  798. Compare multiple columns-----siva and surya
  799. How do I get the sum of vlookup?
  800. Financial formula
  801. Re: Filter by Color
  802. Wrong results from MATCH function
  803. HLookUp function
  804. auto update function from workbook to another worksheet
  805. Can any help with CUBESET function?
  806. over time in a sheet
  807. Pivot table - Change default summarise value field.
  808. how can i "transfer data next row every day automatically" in XL
  809. Formula problems that keep producing a #Value! Error!!
  810. ? excel not generate the sensitivy, answer and limits report
  811. How would I eliminate the $0.00/column & keep formula
  812. Conditional Formatting - Times
  813. how to link multiple columns to multiple worksheet totals / functi
  814. Summarising information from different sheets in a summary sheet
  815. formula to lookup data in cell NEXT to another cell
  816. 含有計算公式的文*句*
  817. FAQ : Answers to show in another cell
  818. sumproduct with partial charcter matching
  819. General ledger spreadsheet continued
  820. Pasting formats and values without formulas
  821. Prepending numbers
  822. Find matching records in two tables using mulitiple criteria
  823. Return value based on another vlaue
  824. Can I use NOT with COUNTIF?
  825. How to VLOOKUP in XCEL across different workbooks each named diffe
  826. writing an formulae with variable parameters
  827. formula to limit expenses to 1 of 2 values
  828. #Value in random cells
  829. Format financial results to end in specific numbers
  830. Iteration
  831. Count, Sum, and Filter by Color
  832. Insert cells function
  833. General ledger spreadsheet
  834. Function based on blank cell and date past due
  835. Excel Spreadsheet
  836. Conditional Formulas
  837. Macro/Formula help
  838. return values based upon specific guidelines
  839. import country flag in excel
  840. Can you rotate a section of excel cell data
  841. Forecast IF Error Formula
  842. Excel 2003 worksheet
  843. Countif Criteria Reference Cell
  844. Insert Row Selection
  845. Shift roster in Excel
  846. Use custom [mm] formated value that is displayed in a calculation
  847. How to find min value in Excel text cells?
  848. Can LEFT, MID, or RIGHT be used with a COUNTIF or VLOOKUP
  849. Auto Filter Comma Dilemiation
  850. COUNTIF formula
  851. Filters
  852. Function on "Text to Columns"
  853. please your help
  854. Equals Sub Total Line
  855. How do I associate text with a number?
  856. Lookup functions
  857. How can I use the same random number twice in the same formula?
  858. Look up?
  859. write in a cell and the cell above is temporarly hidden
  860. Automtacally change entry based on value in column.
  861. Counting occurances based on multiple variables
  862. IF Statement not working
  863. Using If function for Great and less than function
  864. Use formula to remove blank entries from a column
  865. Remove MSN MoneyCentral .iqy files w/o losing data import
  866. Replace #/Div
  867. Rank - Change the Rank of a Tie
  868. Countif - Key words
  869. Adding numbers based on Range
  870. Copying conditional formatting to an entire column in Excel 2007
  871. Return a value if item does not appear on list
  872. IF AND MATCH data type issue
  873. Help with multiplication formula
  874. Excel 2003
  875. formula recalculation in Excel 2003 - oddity?
  876. Error result for link formula
  877. 3 Weeks Forecast-Excel 2003
  878. insert muliple rows, every 4th row
  879. Need to convert Minutes:Seconds format to minutes with seconds con
  880. transpose array of non-adjacent cells
  881. Numbering
  882. Conditionally format entire worksheet
  883. find duplicates with the first three digit that are the same.
  884. Looking up values in multiple rows
  885. retrieving deleted spreadsheet
  886. I forgot how to duplicate SCH 051
  887. SUMIF on a collection of individual cells
  888. Lookup to return multiple matching values
  889. Validation Data and Looking Up Cells
  890. unprotect sheet (icon is greyed out)
  891. Conditional format refers to two cells
  892. How to retrieve data from a table
  893. How do I use justify across more than 1 cell in Excel 2007
  894. margins keeping changing
  895. Conditional Formatting Colour and Text Entries
  896. Force entry into cell, based on validation selection in adjacent cell
  897. Show prior year based on date in other cell
  898. If Statement for a date
  899. Format a cell based on incremental numbers
  900. lookup number greater than
  901. lookup number greater than
  902. How can I find data in one list and add it to another sheet?
  903. How can I set the scaling in my macro?
  904. If statement comparing times
  905. Replacing only the empty cells.
  906. Excel Tables
  907. COUNTIF calculates slow (10000+ records)
  908. formula for 'If a cell is empty then insert numeric Zero'
  909. Formula Tracking
  910. changing multiple column references in a formula
  911. shared excel workbook
  912. Look Up
  913. RE: ISBLANK and OR Function
  914. Data Validation Q
  915. how do i format a cell to use text and formulas
  916. RE: ISBLANK and OR Function
  917. Help with retrieving data from a table
  918. sumproduct help
  919. Line of Characters
  920. Countif function question
  921. IF Dates
  922. Can one change shape properties conditionally?
  923. Range Name
  924. Range Names
  925. Separating data in the same cell
  926. sizing in Drop Down lists
  927. Can Excel Rtrn a Value by Referencing Multiple Rows and Columns
  928. problem sorting
  929. Excel comments
  930. del certain rows based on word search
  931. count if
  932. Excel 2007 - Pivot Table and Calculated fields?
  933. how to calculate x months from today
  934. Nested IF
  935. Need Formula to Know Percent of a row of Pass/Fail data
  936. 2007 Defined Names Is Locked!
  937. Cypher
  938. Splitting Data in Cell
  939. Grouping Data
  940. Determie Trend
  941. How can I pull Cell value from Detail worksheet into Summary sheet?
  942. using vlookup and hyperlink
  943. Spec. Sheet
  944. Embedding the value of a cell in a formula
  945. How do I automate the numbering of a purchase order form.
  946. how to format large word paragraphs into an excel file
  947. Vlook up problem
  948. Create multiple sheets and pivot tables from single source
  949. sorting problem 10 comes before 8
  950. Search / Find Function
  951. Linking Objects
  952. Last Date Modified
  953. Internal Rate of Return (IRR)
  954. yes/ No on multiple sheet
  955. COMMON NUMBERS
  956. General Excel question
  957. Error Message :A value used in the formula is of the wrong data ty
  958. EXCEL
  959. COUNTIF function for multiple criteria
  960. Autofilter query?
  961. Difference System date and Excel Date function
  962. Difference betwen Excel Date () Function and System Date
  963. Hyperlinks to many Sheets within a Workbook
  964. Lookup
  965. Message box date format macro help
  966. Excel 2007 custom views and tables
  967. surya and siva
  968. Message box date format macro help
  969. summarising a list of data from numerous times down to once
  970. Data validation
  971. Populating Data From Drop-Down Item
  972. Copy A1 into C1 if B1 contains data??
  973. Formula For Finding a Quotation Mark In a String
  974. cell or column highlights when other cell is selected
  975. Printing non-contiguous rows at the top
  976. Check boxes
  977. Conditional Formatting
  978. If functions
  979. Circular Reference : Puzzle to be solved ...
  980. Hyperlink function not going anywhere
  981. Using Functions
  982. Ranking with duplication and gaps
  983. Excel 2007 - copying filtered data to another workbook
  984. Goal Seek returning different results
  985. Sumproduct
  986. Hidden Background Data File
  987. How do I add a hyperlink (to a Word doc) to an excel spreadsheet?
  988. Pivot tables & Dynamic Ranges?
  989. Excel 2003: Count total days elapsed
  990. captcure close application event
  991. Keeping row number after inserting lines
  992. VLOOKUP format issues?
  993. Linking Date with a Worksheet
  994. Formulas refuse to update
  995. Reminder
  996. Function NOW
  997. Loan amortization schedule for variable interest rates
  998. Finding a Date 90 days previous to present date
  999. Stock Calculation
  1000. Rounding in Excel