PDA

View Full Version : Microsoft Excel Worksheet Functions


Pages : 1 2 3 4 5 [6] 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160

  1. Excel runs slow
  2. Ignore Zero's - Percentile
  3. vlookup or index/match formula??
  4. V Lookup
  5. INDEX / MATCH HELP
  6. Smaller than 0 to return a 0 result
  7. find&select button, help?
  8. _xlfn prefix
  9. Multiple criteria search
  10. Copy tab name to a cell or opposite
  11. how do i import data from my excel worksheet into quickbooks
  12. how to calculate the difference of values (numbers) in a column?
  13. Combo boxes and AutoSum
  14. Adding formula
  15. where is tthe "read only" TOGGLE button ?
  16. Cell content capture and release
  17. IFAND then SUM
  18. How to sum the number of times answered in a single column with b.
  19. wildcards in sumproduct functions
  20. Multiple data validation criteria?
  21. Check for case of string
  22. Function for multiple tabs in one worksheet
  23. Drop down lists from multiple source lists
  24. how do I create a formula to add up time on a time sheet
  25. Extract dd and mm from text and put that plus current yy in another
  26. countif object
  27. Index/Match question
  28. SUMIF based on cell shading
  29. How do i calculate the percentage to compare two different years
  30. New free mail add-in for Excel/Outlook 2007-2010
  31. sort and select based on criteria
  32. sorting multiple columns
  33. Countif across multiple sheets - sheet NAME issue?
  34. Prevent Cut and Paste
  35. for loop with if statement
  36. highlighting different line in a cell
  37. Add total items in from another worksheet?
  38. CUBEMEMBER
  39. can someone tell me how to deselect "select all" in Excel?
  40. why do print range erase in Excel when import data from access
  41. Conditional Formatting for entire row
  42. Getting a value from large table.
  43. HELP!! Formula with different conditions
  44. Creating a dynamic IF statement
  45. Multiple name appearances
  46. Second cell in Data Validation
  47. ANOVA with 3 factors
  48. Workday function not working
  49. multiple criteria date range
  50. If function with format
  51. Nested Formulas v Named Formulas Any other solutions?
  52. Pulling Data from one worksheet into another
  53. Compound interest with premium growing
  54. Unmoveable SUM
  55. Ignore "-"
  56. Delete some column headings from an autofiltered range.
  57. Counting days from a date
  58. MS Word equation
  59. Count distinct days from two groups of days
  60. Selecting different cells each month
  61. how to automatically update a second worksheet when data inserted
  62. if statements for multiple entries
  63. Formula for unique records
  64. Not sure what type of formula to use
  65. Need Help Deleting Blank Rows
  66. Format problem
  67. Reorder String
  68. Find and Replace wildcards
  69. Excel Worksheets
  70. What's wrong with this formula?
  71. Count contiguous cells, or count cell clusters
  72. Greater than a month
  73. Whats wrong with this array formula
  74. freeze column and row on same spread sheet
  75. subtotal, match?
  76. iserror, index & if
  77. emailing from excel 2003 thru outlook 2007 is not being recieved
  78. COUNTING TEXT VALUES GIVEN MORE THAN ONE ARGUMENT.
  79. Another question regarding matching names and adding spaces
  80. Find a single value from tables by selecting two variable inputs?
  81. Conditional formatting offset reference
  82. Transpose to break up one long row to many?
  83. How can I assign a value to a cell without putting a formula in it
  84. SUMIF
  85. Counting Colors of Cells set by Conditional Formatting
  86. Counting Number of Discrepancies between 2 rows
  87. How to check a condition and write another cell
  88. input time by keybrd in locked worksheet
  89. Sum Days into Weeks
  90. hide row based on cell value
  91. how do i calculate a %
  92. Countif query
  93. Follow up on date function question
  94. Date formula
  95. Date function question
  96. Re: Who can explain the formula to calculate the date of Easter
  97. Sorting with sumif function
  98. Check if date is between two dates, then sum only those rows
  99. *****PLEASE******* FIX AUTOMATIC CALCULATION
  100. Excel Functions Problem
  101. Conditional/variable sum??
  102. Pivot Tables- SQL Alias' & Field Lists
  103. Search If on text string
  104. Macro - filter - show all data
  105. RE: Matching names and inserting spaces
  106. Complex conditions using SUMIF
  107. convert time to 1/4 hours
  108. Check Boxes
  109. Are PercentRank and Rankperc the same function?
  110. Problem in calculating the outcome
  111. CREATE A FORMULA FOR HOURS WORKED THAT SUBTRACTS LUNCH
  112. vlookup and multiple criteria
  113. Looups and multiple criteria
  114. Lookup and multiple criteria
  115. lookup to multiple rows and columns
  116. Workday function question
  117. Times
  118. UDF's via Automation Addin in Excel 2010?
  119. How could I display an excel cell contents in a page header ?
  120. Matching data
  121. Using Logical OR on text in Conditional Formatting
  122. Auto Short
  123. Array addressing question... I think
  124. Protecting is NOT working right !!!!!!!!!!!!!!
  125. How do I create the formula for this calculation?
  126. help in formula
  127. Sum of cell which use if array function
  128. Lookup function
  129. Help Please
  130. Conditional Formatting for one cell matching another with text
  131. How do I open qpw file with office 2007?
  132. Formulas
  133. VBC 'Contains' Check
  134. Finding Duplicate Entries
  135. Weird VBA Behaviour
  136. Check for # of Words in Function
  137. Write a Formula
  138. Duplicate value address search - apologies for cross post
  139. Write a formula for a penalty for status of TRUE?
  140. LookUp Function
  141. How do I have excel highlight days before & after a date on a cale
  142. Trying to get a blank cell presented if B26=0
  143. Sum Data if Column B = Q
  144. Restrict Number of Columns
  145. What function need to be used
  146. Rolling average
  147. How do I calculate Track and Distance from two sets of coordinate
  148. Comparing 3 columns?
  149. Matching names and inserting spaces
  150. Arrey Formula
  151. AVERAGE - Disregard zero and numbers over 60?
  152. Tab Control
  153. Dynamically load DataValidation List through Source field?
  154. Match second occurance of value
  155. Conditional formatting Icons
  156. advanced search for excel not producing data
  157. Lickert Scale Formula Help Needed!
  158. 2007 Excel - GETPIVOTDATA
  159. Excel -
  160. Incrementing Formula by Column Instead of by Row
  161. Have data with multiple records associated to same ID
  162. Modyfy table data
  163. Help needed for Excel formula using if, iserr, match and vlookup!
  164. 1st Wed, 1st Sat, 1st Sun
  165. format cell for keyboard short cut entry only?
  166. Selecting a range of cells based on the date.
  167. Update to formula
  168. A Percentile IF function
  169. How do I color one cell and have another cell get same color
  170. Lookup Cell Address
  171. all cells in 2 workbooks have automaticlly changed to date format
  172. count all text values except a certain one
  173. Return cell content in a matched range
  174. Excel work sheets
  175. how turn off brief or repeated keystroke filter
  176. time blocking calendar
  177. Re: Formula for changing cell format based on more than 3 values
  178. RE: Auto update information in footer
  179. Need assistance with how or even if this is possible (function)
  180. search for match
  181. Conditional Format
  182. RE: Date function
  183. Autofill data based on an assigned code/prefix
  184. Subtracting positive amts from negative and positive from positive
  185. Re: Importing data with tabs
  186. finding duplicate addresses across 2 worksheets in the same workbo
  187. Delete ROW on Sheet#1 corupts data on Sheet#2
  188. IF statement that yields a value based on a formula
  189. IF THEN Statement
  190. Changing cell colors from a function command
  191. Format 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minute
  192. Can I 'embed' a formula to affect numbers as they're entered?
  193. WORKDAY Function
  194. AutoFill with Reference incrementing BUT able to delete!
  195. Calculate days help
  196. Indirect function
  197. can I autopopulate from a long drop down list in Excel?
  198. Count Vaules in a range that appear in another range
  199. Vlookup formula
  200. Number of days
  201. Comment Box
  202. multiple work sheet data to link in one worksheet
  203. how do i set up a user prompt at the start of an excel workbook ?
  204. How can I define date range criteria in SUMIF formula?
  205. How can I stop format change when copying data into unlocked cells
  206. Copy to another worksheet IF
  207. Formula to find last different value in a column?
  208. Excel formula help
  209. 'Reverse' Concatenate
  210. How to use conditons within a LOOKUP function?
  211. Calculate # of years
  212. Excel cube functions
  213. Modify SUMIF to find data range in addition to value
  214. A Concatenate Formula Question
  215. Finding duplicates
  216. Sorting data field
  217. Using the Icon Set for Conditional Formatting
  218. RE: SEPARATING DATA - Can anyone HELP??
  219. RE: SEPARATING DATA - Can anyone HELP??
  220. Switched up to Excel 2007 lost functionality in my array equations
  221. Lookup
  222. Drop down box issue
  223. Empty Cell-conditional formatting
  224. MSexcel creating index linking subjects to page nubers in footer
  225. Make a product that works
  226. Text to Columns
  227. Lookup / Index/Match
  228. Why wont my right click functions work?
  229. Cell Color Recognition and Summing of Data Within a Specified Colo
  230. RE: formula to subtract from inventory total
  231. EXCEL
  232. Change How Tab Operates
  233. Vlookup of specific text, then in consecutive rows
  234. Cant type on line E31.
  235. Turn off speak cells
  236. Conditional Formatting with Partial name search
  237. formula help
  238. Custom views in Excel
  239. How do I multiply ALL CELL in spreadsheet at once by .5 ?
  240. TransferSpreadsheet to colored fields
  241. how do I convert date format yyyymmdd to mm/dd/yyyy
  242. How to count cells that are highlighted by conditional formatting
  243. Excel - Calculate age from DOB in years, months days
  244. Re: Data Validation Lists
  245. Array Formula
  246. How format SUMIF formula for matching date range and column value?
  247. In excell 2003, increasing number of items shown in drop down list
  248. Calculating working hours to complete a task
  249. Extracting elements of a string cell
  250. Date format problems after csv import
  251. auto highlighting x#of days prior to & after any given date
  252. Conditional Formatting
  253. how to vlookup of one cell by starting 2 digits of another cell?
  254. Stock control question
  255. vba to delete rows
  256. User controlled Freeze Pane while protected
  257. How do I find how many of a certain day are in a given month
  258. How do I get the MSNStockQuote function in Excel?
  259. Offset with scrollbar
  260. maximum nested IFs
  261. Macro to delete any control box and pictures
  262. toolbar "button" for hiding/unhiding sheets
  263. VBA to count colored cells
  264. Convert number to text
  265. How can I?
  266. Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA)
  267. Adding totals in columns
  268. Set "ALWAYS CREATE BACKUP" Option
  269. Help with an array and SUMPRODUCT
  270. Inconsistance Formula?
  271. Button apperance
  272. Multiple lookup between two dates
  273. RE: Running Total
  274. RE: Running Total
  275. If Function??
  276. Auto Populating & Name Recognition between Worksheets
  277. Re: Running Total
  278. Condional Formatting with Percents
  279. Find Last Item Entered in Row
  280. Count with multiple criteria in multiple cells
  281. Looking up any match, returning data
  282. copying data
  283. if statement
  284. Insert Data From Multiple Worksheets Into One (With Criteria)
  285. Creating a Macro to autofill and save
  286. Extract portions of text
  287. Stock control spreadsheet
  288. Stock control formula
  289. Consolidation if a least one criteria is met
  290. How convert Numeric number in words
  291. Function needed?
  292. duplicate numbers being given different rankings
  293. 5th Char in a cell
  294. how do I convert an imported number to text
  295. Check inputdate, then retrieve data to fill in chart from dated co
  296. If count
  297. Getting a formula to do the following:
  298. Calcs & Data Validation
  299. retrieve data from different workbook
  300. If,Then Statement
  301. Concatenate numbers and text while holding a custom number format.
  302. Data Validation Lists
  303. Is there a formlula to replace cell shade color with another color
  304. Arrange Footer
  305. Re: Date Validation
  306. stop view and lock columns
  307. insurance renewal formula flag needed
  308. excel 2007 set a row or column to not recalculate
  309. General question
  310. Index and Match
  311. Where was I???
  312. Sum a column if two criteria are met
  313. re: sum cells containing text
  314. Conditionally Formatting a Range
  315. FORMULA
  316. symbol definition
  317. Done. Done. Done.
  318. Date minus work days
  319. data in single column split to multiple col's based on header
  320. count unique values in one column for a set value in another col.
  321. Automatic filling of cells within a certain date range
  322. End/Beginning of Cell Search/Replace?
  323. Excel autofit row height not working
  324. E-mail notification of answers to my posts
  325. Removal Date
  326. vlookup to another worksheet
  327. Count the number of hours/durations
  328. best config
  329. excel duplicated a sheet. how do i delete one
  330. IF FUNCTION
  331. Retaining conditonal formats
  332. Formulae Help
  333. Merge Cells?
  334. Lookup a value that fits two (2) criterion
  335. Conditional formatting-Date range
  336. Conditional format on adjacent cells
  337. lookup formula not picking up correct data
  338. Same Image appear on all sheets from first page single
  339. Running Total Column
  340. I want to change a "No" to a "Yes" i
  341. Perpetual 1st Wed
  342. Count if 2 criteria are met
  343. Hyperlink not working
  344. How to link the content of a cell with a related list of items
  345. formula needed
  346. COUNT CONSECUTIVE ENTRIES IN COLUMNS
  347. Set print area
  348. Sorting cells with a string formulas
  349. Any way to sort rows of data with merged cells????
  350. Code in certain sheets
  351. VLookUp Question
  352. Comparison Formula
  353. "Disclaimer"
  354. selecting data in a row
  355. need a search/find/lookup function
  356. what could cause numbers to appear as row names and column names
  357. lookup and match
  358. automaticely highlight the row that I am working on
  359. Link cells with text not numbers
  360. How to add data from cells based on different criterias?
  361. specify non-contiguous cell range as arguments to TTEST()
  362. Sorting Alphabetically
  363. Using wildcards with logical (IF, AND) conditional formatting
  364. Index match or Sumif ???
  365. formula question
  366. circling a number
  367. repost of question from 2/4 "Using drop-down lists"
  368. DMax with No Criteria
  369. Lookup columns (varying qty), then find MIN
  370. count how many different numbers in the column and return to the n
  371. Auto Fill-Down?
  372. Formula anomaly
  373. combining =SEARCH & =IF statements
  374. Function needed to search and pull data from 1 table to another
  375. IF Formulas
  376. Track Changes History Worksheet
  377. Conditional Formatting Not Working As Intended
  378. limited cell movement
  379. Formula to count data in a column that falls between a range
  380. Adding text to an IF statement effeciently
  381. Formula for if name begins with and date is less than or equal to.
  382. Nested subtotals in incorrect order on large worksheets
  383. Finding the combination that appears more times
  384. Function needed
  385. Sumif with an array for criteria
  386. Frequency
  387. Search for data in Excel and hide rows
  388. RE: Growth rate
  389. Excluding a column from range in COUNTIF function
  390. Stopping duplication within Data validation
  391. Find the cell ID of last row in the column and use it in SUMIF for
  392. data consolidation
  393. Question About Sorting
  394. Formula in dropdown list
  395. Excel 2007 drop down lists
  396. Using drop-down lists
  397. printing
  398. printing
  399. Formaula for less than date and name begins with...!!! HELP!!!
  400. Countif - problem counting text, other text
  401. simple countif formula
  402. multiply criteria in a range using sumifs
  403. I wish to group my worksheets under group tabs
  404. indirect function
  405. if is error then "No Data", if not then average range
  406. Switch First and Last Names
  407. calculating the "mean" for a group of numbers
  408. Calculations in filtered columns
  409. Password
  410. Value list
  411. edit a comment while protect sheet is on the cell is unprotected
  412. HELP
  413. How do I force the y-intercept value
  414. Turning =E13 to =$E$13
  415. list in data validation
  416. SUMIF and text
  417. Convert variable #'s in a gen. format to a # that can be used w/ma
  418. Lookup function for two variables and return another cell?
  419. need a formula
  420. Count rows based on multiple criteria
  421. Sumproduct cell reference vs embedded "values"
  422. Stoping Excel from Calculating?
  423. If Function
  424. Averaging with IFs
  425. Cell =Now() << Can I get this to auto-update?
  426. Lookup
  427. selecting an item at random for QA sampling
  428. First column of range in VLOOKUP contains formula
  429. percentages
  430. Hightlight cells that contain special characters
  431. Percentage format
  432. Pivot Tables: Don't show data for detail, but still show subtotals
  433. Could someone please help me with a solution to my problem?
  434. How do i stop functions?
  435. Statistical functions on non-consequtive columns
  436. Autofilter
  437. Pivot Table-Running Total
  438. look up
  439. Vlookup across 3 worksheets
  440. Dependent dropdowns
  441. Function to lookup date on tab in excel and populate date on calen
  442. Sorting in Custom Alphabetical Order
  443. Transfering a changing cell value progressively through a workbook
  444. vlookup issue
  445. Hyperlinks not moving with cells when data is sorted
  446. Combine Sumif and Countif
  447. need help with a solution - maybe vlookup?
  448. SUMIFS
  449. RE: Transpose Columns of data into Rows
  450. Extract emails from cells with text
  451. Another SUMPRODUCT Question
  452. Deleting Duplicates
  453. Delete duplicates
  454. Returning a Value from Another Worksheet
  455. How do you extract day/time/month/year information
  456. Conditional Format Tracker by Date
  457. If statement
  458. Duplicate Function Help
  459. count cells in a table that meet multiple criteria
  460. Extract the month name from a month
  461. How can I get =Clean and =Proper Case to run on all cells in a col
  462. Formula for adding a cell in multiple workbooks
  463. Formula Help Please?
  464. match and sort two different tables
  465. Index lookup change data
  466. Calculating over multiple tabs
  467. Sumproduct Search, Sum Durations
  468. Column total is wrong
  469. best breakdown
  470. Changing initials into numbers
  471. Formula Help
  472. Reference shows zero
  473. Finding pairs of numbers
  474. Using paste link
  475. put a legend in the footer of microsoft office 2003
  476. Worksheet linking
  477. match
  478. Data changes in advanced filter
  479. Re: IF function turning text to number
  480. Re: IF function turning text to number
  481. How to vlookup and summing value?
  482. transposing across different worksheets
  483. LOOKUP A VALUE IN A TABLE AND RETURN VALUE OF FIRST ROW IN THATCOLUMN
  484. Advanced filter
  485. CountIf or leave blank
  486. Adjust text to fit within an Excel Cell using C#
  487. Selecting nonadjacent columns?
  488. enter data in 1 cell and produce a number in another cell
  489. Sum data in a column if multi creteria met
  490. Month Function on UK dates formats (dd/mm/yyy)
  491. date extraction
  492. how do i find data from worksheets in excel
  493. How to use two parameters in input of popup Variables - Gary's Student
  494. How do I set up sub-headings in Excel?
  495. convert dd/mm/yy hh:mm AM IST
  496. help with formulas
  497. what is ^ function
  498. RE: Formula Help
  499. Re: Formula Help
  500. Re: Formula Help
  501. IF formula is greater than X use it, if not use X
  502. Subtotal percents in pivot table
  503. countif strikethrough
  504. Flexible formula for linking to externa Files
  505. Running Total, Opening & Closing Acct Balance in Cash Book
  506. Trimming letters in an Excel field
  507. bold text of referenced cell show in formula cell
  508. How do you do an IF statement in Excel comparing three columns
  509. How can you show the new items in a refreshed document?
  510. Establishing most common word in an Excel column
  511. How do I markup a column of numbers without adding a column?
  512. Print Dialog Box
  513. Is Vlookup the correct way to do this?
  514. Advancing the Date Function?
  515. Cursor color
  516. Converting text format of time/date into Excel time/date for subtr
  517. How do I modify a database in Excel 2007?
  518. FIND A VALUE FROM CROSPONDING COLUM AND MULTIPLE CROSSPENDING ROW
  519. Result based on two criteria
  520. Count backwards N cells
  521. Save changes source - weird !!
  522. cell resizing
  523. Count a value excluding duplicates depending on a set criteria
  524. Count text cells if condition in row is true, over many rows.
  525. How to separate Excel Workbooks into new files
  526. keeping conditional formatting after paste
  527. Merging Excel Sheet with Excel Sheet (Just like in MS Word!)
  528. VLOOKUP Returning a #N/A
  529. VLookup #VALUE! error help needed to resolve
  530. Pulling Tab Name of a Different Tab Than What I'm Working In
  531. Convert Month, Week, Year to date
  532. Prevent formula calculation from overriding validation
  533. CELL("filename") doesn't work on shortcut workbook link?
  534. 2007 Excel Protecting a cell
  535. when i type 5 then it shows.006
  536. can not see anything in drop down list
  537. Find position number of third space
  538. Day formula
  539. Please help me -urgent
  540. fill color a protected cell without unprotecting worksheet
  541. Lookup and return value
  542. countifs criteria includes date range
  543. Macro formatting last row
  544. Choose amount appears at first coloums
  545. dynamic chart- curve drops to zero ( Line)
  546. IF statement
  547. Formula help needed
  548. Find last entry in row based on matching value
  549. SUMPRODUCT formula help
  550. = LOOKUP(9.99999999999999E+307,A1:H1)
  551. date help
  552. moving entries between workbooks
  553. Pivot table fields missing on all computers
  554. CAN A VALUE BE RETURNED WHEN TEXT IS ENTERED IN A DIFFERANT CELL?
  555. Excel 2007 ate my fields
  556. Compare Best WIN and worst LOSS in Columns
  557. Permutations
  558. Using Popups to supply variables
  559. if/true/false help
  560. Copying & dragging vlookup cells?
  561. Simple VLOOKUP with NON ascending order
  562. How to filter a coulered cell range?
  563. sales process template
  564. EveryDay Online sessions at hyderabadtechies.info from 8:30 P.M onVarious Microsoft Technologies
  565. #REF! error with Multiple Documents
  566. SUMPRODUCT COUNTIF (Again)
  567. Excel 2007 Function Qt
  568. Copy sheet to new sheet
  569. Insert file last save date into excel 2007 footer
  570. Rows to repeat getting cut off on 2nd page
  571. deleting repeated rows
  572. search for a particular string in cells
  573. how to create weekly totals
  574. repeat entry from previous column
  575. how do I unmerge an entire spread sheet in excel?
  576. conditional format rage based on entries within range
  577. help with formula and multiple associated data sets
  578. Re: Count cells matching two criteria (DATE & TEXT)
  579. Can I use an "=" in Excel 2007 cell without making it a function?
  580. How to fill cell references from several worksheets in one?
  581. Multiple IF statements in equation
  582. Why this formulo not working
  583. Re: Count cells matching two criteria (DATE & TEXT)
  584. Re: Count cells matching two criteria (DATE & TEXT)
  585. Best 3 Consecutive Months
  586. If formula with Yes or No
  587. Go To the next empty cell in Column A
  588. difference of 2 cells from 2 sheets to appear on sheet 3?
  589. RE: UDF Not recognized
  590. Copy and Paste from One SS to Another
  591. Return Text based upon text matching
  592. Re: UDF Not recognized
  593. Switch lookup function to another sheet
  594. Problem - hidden cell names in worksheet
  595. Function Help!
  596. VBLookup - need help
  597. Converting Rows to Columns
  598. How to get SUMPRODUCT on filtered cells
  599. Summarizing with multiple conditions - Formula solution needed
  600. Vlookup in multiple sheets
  601. Excel date intervals look up
  602. pivot table calculated field or item
  603. Index and Match Function Help
  604. Vlookup Plus...?
  605. Deleting worksheets in a macro
  606. Need Formula to solve my problem
  607. Sum
  608. Vlookup, sumproduct, if, sumif... erggg!
  609. Inserting Lines Makes Formula Inactive
  610. dates from a data validation
  611. NEED FORMULA HELP
  612. Opening multiple templets in two monitors
  613. reference sheet number not name
  614. Function for odd even numbers
  615. Formula for Dates and CF Colour then convert to Text
  616. Import external data into Excel 2007 so I can subtotal it
  617. Counting Multiple Records by specific criteria
  618. SEARCH
  619. I have a file that is 4mb. Cleared all formating...still big
  620. move a row of data from one work sheet to another using a formula
  621. USING "IF" STATEMENTS FOR MONTHS OF YEAR(IF 1=JANUARY)
  622. How to add time from multiple cells & date Cells & machine type c
  623. Max number of consectutive blanks in a range
  624. Use if functions with dates
  625. help with Conditional formatting pairs of cells
  626. Re: Find last cell in a column, Delete its contents and make it ac
  627. How do I reference a worksheet name through a formula?
  628. Conditional Sumproduct() Based on the Time of the Day
  629. protect cells in excel, but also allow a search in those cells?
  630. Calculated Item in Pivot table
  631. HOW TO USE BAHTTEXT FORMULA
  632. Excel 2002 always rounds up automatically
  633. Returning multiple instances of the same lookup value
  634. Can I invert a matrix in Excel 2007?
  635. Summing weekly values to fall into correct month
  636. cannot change datasource of pivotchart
  637. Calculate total metric based on sum of metric over specific time f
  638. Need help to change a cell color based on conditions
  639. Eliminating empty rows in Pivot table
  640. HOW CAN I IMPLEMENT SUMIF(D1:D6,">AVERAGE(D1:D6)")
  641. MATCH search with text and numbers
  642. Assigning a macro to a button
  643. Combo List in Excel
  644. Time Calculation and formulas needed (2 questions)
  645. excel function to give the area of a circle?
  646. remove contain from rows B thur J
  647. Pivot Table Fields not showing
  648. Find last cell in a column, Delete its contents and make it active
  649. Preventing double entry formula
  650. parent/child relationship between rows?
  651. Why doesn't "Replace" function find value I know exists?
  652. exclude certain cells from series fill
  653. command to move to different sheet
  654. bitwise functions
  655. Auto Calculate Monthly Time Pace
  656. Summing Data
  657. FIND text within text then sum
  658. how do I sumif on a font color in excel 2007?
  659. Reversing a column
  660. Conditional formatting based upon due dates
  661. Usage of Data Validation with If Condition
  662. LOOKUP problem
  663. Copying a cell if dates match
  664. countif with time
  665. Spreadsheet - Deleting Duplicate Records - Self Checking
  666. Limitations on Sumif Calculation
  667. repeatedly extract a field to create a new list in another file?
  668. time delay refresh on random number
  669. Error message needed if incorrect Date Of Birth (DOB) entered
  670. Inserting a blank row between rows of data
  671. SUM Fuction
  672. Is it possible to count the no. of characters in a cell in Excel?
  673. Bond premium amortization using the constant yield method
  674. Conditional Formula Help Please!
  675. Matching data in 2 different work sheets
  676. Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM
  677. Select a range of rows to delete
  678. Addition Error
  679. I need a different formula that can be copied down
  680. formula to calculate amount of hours downtime spent in days
  681. Fixing time of last update
  682. RE: I want to use LOOKUP to average multiple values for a single crite
  683. Formula Copying
  684. Re: Adding column data based on match in 2nd column - Help
  685. excel is calculating wrong again
  686. excel is calculating wrong again.
  687. automatic insertion of row
  688. some kind of Conditional format? - Baffled :(
  689. format cell custom Number format
  690. What formula do I use to show the last cell with text in a colum
  691. how do i count text cells in excel based on variable criteria?
  692. RANK - Remove repeated ranks for sorting
  693. keep manual recalculation mode on
  694. Month wise Sum
  695. Lookup and tables
  696. excel formula
  697. Match similar names
  698. COUNTIF with adjacent columns
  699. Average % - this should be easy?
  700. If statements
  701. lookup function
  702. AFTER I SORT AND FILTER A WORKSHEET CAN I DELETE THE FILTERS
  703. Conditional Format - If day = 24 or 25
  704. How can I keep a zero (0) at the front of a set of numbers.
  705. Can't get vlookup nor advance filter to give the desired solution.
  706. Return to next row in first column when entering data in Excel
  707. Help with formula trowing a #value! result
  708. Excel formula
  709. Help with Formula Please
  710. Formula bar needing refreshing ??
  711. Creating a Macro the right way?
  712. Using icon sets with relative references
  713. Locking Cells
  714. Conditional Formulas
  715. Conditional Formulas
  716. Create two Data validation lists that are linked(Both change toget
  717. Define cell as a condition
  718. HOW DO I INSERT A CALENDAR INTO A DROP DOWN MENU FOR A COLUMN ?
  719. Data Matching
  720. Sorting dates, ignoring year
  721. How do you use the equivalent of NOT in text?
  722. Weeknum in 2010 incorrect
  723. Countif problems
  724. Sum Workdays
  725. MID / LEN
  726. Name Ranges...
  727. formatting excel date list
  728. Change positive number to negative number
  729. Error Alert for Invalid Data doesn't work for data selected in col
  730. Sumproduct across mutliple columns
  731. Filter by multiple colors
  732. Delete Row ABOVE
  733. Deleting Worksheet in excel = 2003 / 2007
  734. Conditional count
  735. Current Time subtract a specific amount every second
  736. Delete Void Invoices
  737. How do I count only if either/ or exist
  738. ranking with 2 parameters of inverse relation
  739. Editing Lookup Formula Error
  740. Concatenate 4 cells
  741. Help on combining two IF statements
  742. Binary NOT?
  743. Macro Script help
  744. Re: Column To Rows
  745. Sum of Highlighted values
  746. Insert Paste
  747. Lookup or Match with rows and column together
  748. Date Functions & Formatting
  749. Column To Rows
  750. separate contents of one cell into multiple cells