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. Formulas
  2. VBC 'Contains' Check
  3. Finding Duplicate Entries
  4. Weird VBA Behaviour
  5. Check for # of Words in Function
  6. Write a Formula
  7. Duplicate value address search - apologies for cross post
  8. Write a formula for a penalty for status of TRUE?
  9. LookUp Function
  10. How do I have excel highlight days before & after a date on a cale
  11. Trying to get a blank cell presented if B26=0
  12. Sum Data if Column B = Q
  13. Restrict Number of Columns
  14. What function need to be used
  15. Rolling average
  16. How do I calculate Track and Distance from two sets of coordinate
  17. Comparing 3 columns?
  18. Matching names and inserting spaces
  19. Arrey Formula
  20. AVERAGE - Disregard zero and numbers over 60?
  21. Tab Control
  22. Dynamically load DataValidation List through Source field?
  23. Match second occurance of value
  24. Conditional formatting Icons
  25. advanced search for excel not producing data
  26. Lickert Scale Formula Help Needed!
  27. Automatic updating
  28. 2007 Excel - GETPIVOTDATA
  29. Excel -
  30. Incrementing Formula by Column Instead of by Row
  31. Have data with multiple records associated to same ID
  32. Modyfy table data
  33. Help needed for Excel formula using if, iserr, match and vlookup!
  34. 1st Wed, 1st Sat, 1st Sun
  35. format cell for keyboard short cut entry only?
  36. Selecting a range of cells based on the date.
  37. Update to formula
  38. A Percentile IF function
  39. How do I color one cell and have another cell get same color
  40. Lookup Cell Address
  41. all cells in 2 workbooks have automaticlly changed to date format
  42. count all text values except a certain one
  43. Return cell content in a matched range
  44. Excel work sheets
  45. how turn off brief or repeated keystroke filter
  46. time blocking calendar
  47. RE: Auto update information in footer
  48. Formula for changing cell format based on more than 3 values
  49. Need assistance with how or even if this is possible (function)
  50. search for match
  51. Conditional Format
  52. Autofill data based on an assigned code/prefix
  53. Subtracting positive amts from negative and positive from positive
  54. finding duplicate addresses across 2 worksheets in the same workbo
  55. Importing data with tabs
  56. Delete ROW on Sheet#1 corupts data on Sheet#2
  57. IF statement that yields a value based on a formula
  58. IF THEN Statement
  59. Changing cell colors from a function command
  60. Format 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minute
  61. Can I 'embed' a formula to affect numbers as they're entered?
  62. WORKDAY Function
  63. AutoFill with Reference incrementing BUT able to delete!
  64. Calculate days help
  65. Function updating all worksheets in workbook
  66. Indirect function
  67. can I autopopulate from a long drop down list in Excel?
  68. Count Vaules in a range that appear in another range
  69. Vlookup formula
  70. Number of days
  71. Comment Box
  72. multiple work sheet data to link in one worksheet
  73. how do i set up a user prompt at the start of an excel workbook ?
  74. How can I define date range criteria in SUMIF formula?
  75. How can I stop format change when copying data into unlocked cells
  76. Copy to another worksheet IF
  77. Formula to find last different value in a column?
  78. Excel formula help
  79. 'Reverse' Concatenate
  80. How to use conditons within a LOOKUP function?
  81. Calculate # of years
  82. Excel cube functions
  83. Modify SUMIF to find data range in addition to value
  84. A Concatenate Formula Question
  85. Finding duplicates
  86. Sorting data field
  87. Using the Icon Set for Conditional Formatting
  88. Switched up to Excel 2007 lost functionality in my array equations
  89. Lookup
  90. Solar cells for less than 1 USD per Watt
  91. Drop down box issue
  92. Empty Cell-conditional formatting
  93. MSexcel creating index linking subjects to page nubers in footer
  94. Make a product that works
  95. Text to Columns
  96. Lookup / Index/Match
  97. Why wont my right click functions work?
  98. Cell Color Recognition and Summing of Data Within a Specified Colo
  99. EXCEL
  100. Change How Tab Operates
  101. formula to subtract from inventory total
  102. Vlookup of specific text, then in consecutive rows
  103. Cant type on line E31.
  104. Turn off speak cells
  105. Conditional Formatting with Partial name search
  106. formula help
  107. Custom views in Excel
  108. How do I multiply ALL CELL in spreadsheet at once by .5 ?
  109. TransferSpreadsheet to colored fields
  110. how do I convert date format yyyymmdd to mm/dd/yyyy
  111. How to count cells that are highlighted by conditional formatting
  112. Excel - Calculate age from DOB in years, months days
  113. Re: Data Validation Lists
  114. Array Formula
  115. How format SUMIF formula for matching date range and column value?
  116. In excell 2003, increasing number of items shown in drop down list
  117. Calculating working hours to complete a task
  118. Extracting elements of a string cell
  119. Date format problems after csv import
  120. auto highlighting x#of days prior to & after any given date
  121. Conditional Formatting
  122. how to vlookup of one cell by starting 2 digits of another cell?
  123. Stock control question
  124. vba to delete rows
  125. User controlled Freeze Pane while protected
  126. How do I find how many of a certain day are in a given month
  127. How do I get the MSNStockQuote function in Excel?
  128. Offset with scrollbar
  129. maximum nested IFs
  130. Macro to delete any control box and pictures
  131. toolbar "button" for hiding/unhiding sheets
  132. VBA to count colored cells
  133. Convert number to text
  134. How can I?
  135. Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA)
  136. Adding totals in columns
  137. Set "ALWAYS CREATE BACKUP" Option
  138. Help with an array and SUMPRODUCT
  139. Inconsistance Formula?
  140. Button apperance
  141. Multiple lookup between two dates
  142. If Function??
  143. Auto Populating & Name Recognition between Worksheets
  144. Running Total
  145. RE: Count with multiple criteria in multiple cells
  146. Condional Formatting with Percents
  147. Find Last Item Entered in Row
  148. Looking up any match, returning data
  149. copying data
  150. if statement
  151. Insert Data From Multiple Worksheets Into One (With Criteria)
  152. Creating a Macro to autofill and save
  153. Extract portions of text
  154. Stock control spreadsheet
  155. Stock control formula
  156. Consolidation if a least one criteria is met
  157. How convert Numeric number in words
  158. Function needed?
  159. duplicate numbers being given different rankings
  160. 5th Char in a cell
  161. how do I convert an imported number to text
  162. Check inputdate, then retrieve data to fill in chart from dated co
  163. If count
  164. Getting a formula to do the following:
  165. Calcs & Data Validation
  166. retrieve data from different workbook
  167. If,Then Statement
  168. Concatenate numbers and text while holding a custom number format.
  169. Data Validation Lists
  170. Is there a formlula to replace cell shade color with another color
  171. Arrange Footer
  172. stop view and lock columns
  173. insurance renewal formula flag needed
  174. excel 2007 set a row or column to not recalculate
  175. General question
  176. Index and Match
  177. Where was I???
  178. Sum a column if two criteria are met
  179. Conditionally Formatting a Range
  180. FORMULA
  181. symbol definition
  182. Done. Done. Done.
  183. Date minus work days
  184. data in single column split to multiple col's based on header
  185. count unique values in one column for a set value in another col.
  186. Automatic filling of cells within a certain date range
  187. End/Beginning of Cell Search/Replace?
  188. Excel autofit row height not working
  189. E-mail notification of answers to my posts
  190. Removal Date
  191. vlookup to another worksheet
  192. Count the number of hours/durations
  193. best config
  194. excel duplicated a sheet. how do i delete one
  195. re: sum cells containing text
  196. IF FUNCTION
  197. Retaining conditonal formats
  198. Formulae Help
  199. Merge Cells?
  200. Lookup a value that fits two (2) criterion
  201. Conditional formatting-Date range
  202. Conditional format on adjacent cells
  203. lookup formula not picking up correct data
  204. Same Image appear on all sheets from first page single
  205. Running Total Column
  206. I want to change a "No" to a "Yes" i
  207. Perpetual 1st Wed
  208. Count if 2 criteria are met
  209. Hyperlink not working
  210. How to link the content of a cell with a related list of items
  211. formula needed
  212. COUNT CONSECUTIVE ENTRIES IN COLUMNS
  213. Set print area
  214. Sorting cells with a string formulas
  215. Any way to sort rows of data with merged cells????
  216. Code in certain sheets
  217. VLookUp Question
  218. Comparison Formula
  219. "Disclaimer"
  220. selecting data in a row
  221. need a search/find/lookup function
  222. what could cause numbers to appear as row names and column names
  223. lookup and match
  224. automaticely highlight the row that I am working on
  225. Link cells with text not numbers
  226. How to add data from cells based on different criterias?
  227. specify non-contiguous cell range as arguments to TTEST()
  228. Sorting Alphabetically
  229. Using wildcards with logical (IF, AND) conditional formatting
  230. formula question
  231. circling a number
  232. repost of question from 2/4 "Using drop-down lists"
  233. DMax with No Criteria
  234. Lookup columns (varying qty), then find MIN
  235. count how many different numbers in the column and return to the n
  236. Auto Fill-Down?
  237. Formula anomaly
  238. combining =SEARCH & =IF statements
  239. Function needed to search and pull data from 1 table to another
  240. IF Formulas
  241. Track Changes History Worksheet
  242. Conditional Formatting Not Working As Intended
  243. limited cell movement
  244. Formula to count data in a column that falls between a range
  245. Adding text to an IF statement effeciently
  246. Formula for if name begins with and date is less than or equal to.
  247. Nested subtotals in incorrect order on large worksheets
  248. Finding the combination that appears more times
  249. Function needed
  250. Sumif with an array for criteria
  251. Frequency
  252. Search for data in Excel and hide rows
  253. Excluding a column from range in COUNTIF function
  254. Stopping duplication within Data validation
  255. Find the cell ID of last row in the column and use it in SUMIF for
  256. data consolidation
  257. Question About Sorting
  258. Formula in dropdown list
  259. Excel 2007 drop down lists
  260. Using drop-down lists
  261. printing
  262. printing
  263. Formaula for less than date and name begins with...!!! HELP!!!
  264. Countif - problem counting text, other text
  265. simple countif formula
  266. multiply criteria in a range using sumifs
  267. I wish to group my worksheets under group tabs
  268. indirect function
  269. if is error then "No Data", if not then average range
  270. Switch First and Last Names
  271. calculating the "mean" for a group of numbers
  272. Calculations in filtered columns
  273. Password
  274. Value list
  275. edit a comment while protect sheet is on the cell is unprotected
  276. HELP
  277. How do I force the y-intercept value
  278. Turning =E13 to =$E$13
  279. list in data validation
  280. SUMIF and text
  281. Convert variable #'s in a gen. format to a # that can be used w/ma
  282. Lookup function for two variables and return another cell?
  283. need a formula
  284. Count rows based on multiple criteria
  285. Sumproduct cell reference vs embedded "values"
  286. Stoping Excel from Calculating?
  287. If Function
  288. Averaging with IFs
  289. Cell =Now() << Can I get this to auto-update?
  290. Lookup
  291. selecting an item at random for QA sampling
  292. First column of range in VLOOKUP contains formula
  293. percentages
  294. Hightlight cells that contain special characters
  295. Percentage format
  296. Pivot Tables: Don't show data for detail, but still show subtotals
  297. Could someone please help me with a solution to my problem?
  298. How do i stop functions?
  299. Statistical functions on non-consequtive columns
  300. Autofilter
  301. Pivot Table-Running Total
  302. look up
  303. Vlookup across 3 worksheets
  304. Dependent dropdowns
  305. Function to lookup date on tab in excel and populate date on calen
  306. Sorting in Custom Alphabetical Order
  307. Transfering a changing cell value progressively through a workbook
  308. vlookup issue
  309. Hyperlinks not moving with cells when data is sorted
  310. Combine Sumif and Countif
  311. need help with a solution - maybe vlookup?
  312. SUMIFS
  313. Extract emails from cells with text
  314. Another SUMPRODUCT Question
  315. Deleting Duplicates
  316. Delete duplicates
  317. Returning a Value from Another Worksheet
  318. How do you extract day/time/month/year information
  319. Conditional Format Tracker by Date
  320. If statement
  321. Duplicate Function Help
  322. count cells in a table that meet multiple criteria
  323. Extract the month name from a month
  324. How can I get =Clean and =Proper Case to run on all cells in a col
  325. Formula for adding a cell in multiple workbooks
  326. Formula Help Please?
  327. match and sort two different tables
  328. Index lookup change data
  329. Calculating over multiple tabs
  330. Sumproduct Search, Sum Durations
  331. Column total is wrong
  332. best breakdown
  333. Changing initials into numbers
  334. Formula Help
  335. Reference shows zero
  336. Finding pairs of numbers
  337. Using paste link
  338. put a legend in the footer of microsoft office 2003
  339. Worksheet linking
  340. match
  341. Data changes in advanced filter
  342. How to vlookup and summing value?
  343. transposing across different worksheets
  344. LOOKUP A VALUE IN A TABLE AND RETURN VALUE OF FIRST ROW IN THATCOLUMN
  345. Advanced filter
  346. CountIf or leave blank
  347. Adjust text to fit within an Excel Cell using C#
  348. Selecting nonadjacent columns?
  349. enter data in 1 cell and produce a number in another cell
  350. Sum data in a column if multi creteria met
  351. Month Function on UK dates formats (dd/mm/yyy)
  352. date extraction
  353. how do i find data from worksheets in excel
  354. How to use two parameters in input of popup Variables - Gary's Student
  355. How do I set up sub-headings in Excel?
  356. convert dd/mm/yy hh:mm AM IST
  357. help with formulas
  358. what is ^ function
  359. Formula Help
  360. IF formula is greater than X use it, if not use X
  361. Subtotal percents in pivot table
  362. countif strikethrough
  363. Flexible formula for linking to externa Files
  364. Running Total, Opening & Closing Acct Balance in Cash Book
  365. Trimming letters in an Excel field
  366. bold text of referenced cell show in formula cell
  367. How do you do an IF statement in Excel comparing three columns
  368. How can you show the new items in a refreshed document?
  369. Establishing most common word in an Excel column
  370. How do I markup a column of numbers without adding a column?
  371. Print Dialog Box
  372. Is Vlookup the correct way to do this?
  373. Advancing the Date Function?
  374. Cursor color
  375. Converting text format of time/date into Excel time/date for subtr
  376. Re: Average of more than 30 numbers
  377. How do I modify a database in Excel 2007?
  378. FIND A VALUE FROM CROSPONDING COLUM AND MULTIPLE CROSSPENDING ROW
  379. Result based on two criteria
  380. Count backwards N cells
  381. Save changes source - weird !!
  382. cell resizing
  383. Count a value excluding duplicates depending on a set criteria
  384. Count text cells if condition in row is true, over many rows.
  385. keeping conditional formatting after paste
  386. Merging Excel Sheet with Excel Sheet (Just like in MS Word!)
  387. VLOOKUP Returning a #N/A
  388. VLookup #VALUE! error help needed to resolve
  389. Pulling Tab Name of a Different Tab Than What I'm Working In
  390. Convert Month, Week, Year to date
  391. Prevent formula calculation from overriding validation
  392. CELL("filename") doesn't work on shortcut workbook link?
  393. 2007 Excel Protecting a cell
  394. when i type 5 then it shows.006
  395. can not see anything in drop down list
  396. Find position number of third space
  397. Day formula
  398. Please help me -urgent
  399. fill color a protected cell without unprotecting worksheet
  400. Lookup and return value
  401. vlookup with result TRUE not updating cell
  402. countifs criteria includes date range
  403. Macro formatting last row
  404. Choose amount appears at first coloums
  405. dynamic chart- curve drops to zero ( Line)
  406. IF statement
  407. Formula help needed
  408. Find last entry in row based on matching value
  409. SUMPRODUCT formula help
  410. = LOOKUP(9.99999999999999E+307,A1:H1)
  411. date help
  412. moving entries between workbooks
  413. Pivot table fields missing on all computers
  414. CAN A VALUE BE RETURNED WHEN TEXT IS ENTERED IN A DIFFERANT CELL?
  415. Excel 2007 ate my fields
  416. Compare Best WIN and worst LOSS in Columns
  417. Permutations
  418. Using Popups to supply variables
  419. if/true/false help
  420. Copying & dragging vlookup cells?
  421. Simple VLOOKUP with NON ascending order
  422. How to filter a coulered cell range?
  423. sales process template
  424. EveryDay Online sessions at hyderabadtechies.info from 8:30 P.M onVarious Microsoft Technologies
  425. #REF! error with Multiple Documents
  426. SUMPRODUCT COUNTIF (Again)
  427. Excel 2007 Function Qt
  428. Copy sheet to new sheet
  429. Insert file last save date into excel 2007 footer
  430. Rows to repeat getting cut off on 2nd page
  431. deleting repeated rows
  432. search for a particular string in cells
  433. how to create weekly totals
  434. repeat entry from previous column
  435. how do I unmerge an entire spread sheet in excel?
  436. conditional format rage based on entries within range
  437. help with formula and multiple associated data sets
  438. Can I use an "=" in Excel 2007 cell without making it a function?
  439. How to fill cell references from several worksheets in one?
  440. Multiple IF statements in equation
  441. Why this formulo not working
  442. Best 3 Consecutive Months
  443. If formula with Yes or No
  444. Go To the next empty cell in Column A
  445. difference of 2 cells from 2 sheets to appear on sheet 3?
  446. Copy and Paste from One SS to Another
  447. Return Text based upon text matching
  448. UDF Not recognized
  449. Switch lookup function to another sheet
  450. Problem - hidden cell names in worksheet
  451. Function Help!
  452. VBLookup - need help
  453. Converting Rows to Columns
  454. How to get SUMPRODUCT on filtered cells
  455. Summarizing with multiple conditions - Formula solution needed
  456. Vlookup in multiple sheets
  457. Excel date intervals look up
  458. pivot table calculated field or item
  459. Index and Match Function Help
  460. Vlookup Plus...?
  461. Deleting worksheets in a macro
  462. Need Formula to solve my problem
  463. Sum
  464. Vlookup, sumproduct, if, sumif... erggg!
  465. Inserting Lines Makes Formula Inactive
  466. dates from a data validation
  467. NEED FORMULA HELP
  468. Opening multiple templets in two monitors
  469. reference sheet number not name
  470. Function for odd even numbers
  471. Formula for Dates and CF Colour then convert to Text
  472. Import external data into Excel 2007 so I can subtotal it
  473. Counting Multiple Records by specific criteria
  474. SEARCH
  475. I have a file that is 4mb. Cleared all formating...still big
  476. move a row of data from one work sheet to another using a formula
  477. USING "IF" STATEMENTS FOR MONTHS OF YEAR(IF 1=JANUARY)
  478. How to add time from multiple cells & date Cells & machine type c
  479. Max number of consectutive blanks in a range
  480. Use if functions with dates
  481. help with Conditional formatting pairs of cells
  482. Re: Find last cell in a column, Delete its contents and make it ac
  483. How do I reference a worksheet name through a formula?
  484. protect cells in excel, but also allow a search in those cells?
  485. Calculated Item in Pivot table
  486. HOW TO USE BAHTTEXT FORMULA
  487. Excel 2002 always rounds up automatically
  488. Can I invert a matrix in Excel 2007?
  489. Summing weekly values to fall into correct month
  490. cannot change datasource of pivotchart
  491. Calculate total metric based on sum of metric over specific time f
  492. Need help to change a cell color based on conditions
  493. Eliminating empty rows in Pivot table
  494. HOW CAN I IMPLEMENT SUMIF(D1:D6,">AVERAGE(D1:D6)")
  495. MATCH search with text and numbers
  496. Assigning a macro to a button
  497. Combo List in Excel
  498. Time Calculation and formulas needed (2 questions)
  499. excel function to give the area of a circle?
  500. remove contain from rows B thur J
  501. Pivot Table Fields not showing
  502. Find last cell in a column, Delete its contents and make it active
  503. Preventing double entry formula
  504. parent/child relationship between rows?
  505. Why doesn't "Replace" function find value I know exists?
  506. exclude certain cells from series fill
  507. command to move to different sheet
  508. bitwise functions
  509. Auto Calculate Monthly Time Pace
  510. Summing Data
  511. FIND text within text then sum
  512. how do I sumif on a font color in excel 2007?
  513. Reversing a column
  514. Conditional formatting based upon due dates
  515. Usage of Data Validation with If Condition
  516. LOOKUP problem
  517. Copying a cell if dates match
  518. countif with time
  519. Spreadsheet - Deleting Duplicate Records - Self Checking
  520. Limitations on Sumif Calculation
  521. repeatedly extract a field to create a new list in another file?
  522. time delay refresh on random number
  523. Error message needed if incorrect Date Of Birth (DOB) entered
  524. Inserting a blank row between rows of data
  525. SUM Fuction
  526. Is it possible to count the no. of characters in a cell in Excel?
  527. Bond premium amortization using the constant yield method
  528. Conditional Formula Help Please!
  529. Matching data in 2 different work sheets
  530. Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM
  531. Select a range of rows to delete
  532. Addition Error
  533. I need a different formula that can be copied down
  534. formula to calculate amount of hours downtime spent in days
  535. Fixing time of last update
  536. RE: I want to use LOOKUP to average multiple values for a single crite
  537. Formula Copying
  538. Adding column data based on match in 2nd column - Help
  539. excel is calculating wrong again
  540. excel is calculating wrong again.
  541. automatic insertion of row
  542. some kind of Conditional format? - Baffled :(
  543. format cell custom Number format
  544. What formula do I use to show the last cell with text in a colum
  545. how do i count text cells in excel based on variable criteria?
  546. RANK - Remove repeated ranks for sorting
  547. keep manual recalculation mode on
  548. Month wise Sum
  549. Lookup and tables
  550. excel formula
  551. Match similar names
  552. COUNTIF with adjacent columns
  553. Average % - this should be easy?
  554. If statements
  555. lookup function
  556. AFTER I SORT AND FILTER A WORKSHEET CAN I DELETE THE FILTERS
  557. Conditional Format - If day = 24 or 25
  558. How can I keep a zero (0) at the front of a set of numbers.
  559. Can't get vlookup nor advance filter to give the desired solution.
  560. Return to next row in first column when entering data in Excel
  561. Help with formula trowing a #value! result
  562. Excel formula
  563. Help with Formula Please
  564. Formula bar needing refreshing ??
  565. Creating a Macro the right way?
  566. Using icon sets with relative references
  567. Locking Cells
  568. Conditional Formulas
  569. Conditional Formulas
  570. Create two Data validation lists that are linked(Both change toget
  571. Define cell as a condition
  572. HOW DO I INSERT A CALENDAR INTO A DROP DOWN MENU FOR A COLUMN ?
  573. Data Matching
  574. Sorting dates, ignoring year
  575. How do you use the equivalent of NOT in text?
  576. Weeknum in 2010 incorrect
  577. Countif problems
  578. Sum Workdays
  579. MID / LEN
  580. Name Ranges...
  581. formatting excel date list
  582. Change positive number to negative number
  583. Error Alert for Invalid Data doesn't work for data selected in col
  584. Sumproduct across mutliple columns
  585. Filter by multiple colors
  586. Delete Row ABOVE
  587. Deleting Worksheet in excel = 2003 / 2007
  588. Conditional count
  589. Current Time subtract a specific amount every second
  590. Delete Void Invoices
  591. How do I count only if either/ or exist
  592. ranking with 2 parameters of inverse relation
  593. Editing Lookup Formula Error
  594. Concatenate 4 cells
  595. Help on combining two IF statements
  596. Binary NOT?
  597. Macro Script help
  598. Re: Column To Rows
  599. Sum of Highlighted values
  600. if & And condition
  601. Insert Paste
  602. Lookup or Match with rows and column together
  603. Date Functions & Formatting
  604. Column To Rows
  605. separate contents of one cell into multiple cells
  606. Find value in a Range of Cells and perform Conditional Formatting
  607. Formula
  608. Lookup function
  609. how to delete recent cocuments
  610. Calculating Service Fill Rate
  611. colour cells, same numbers different worksheets
  612. a cell contain formula, how to extract value of that cell
  613. Countif(and
  614. Sum a column is criteria in two in column and other column are met
  615. Popup File
  616. Function doesn't work
  617. How do i use sumproduct if my lookup table is alpha or alpha num?
  618. Data Matching
  619. easy if statement formula
  620. Counting Multiple Text Cells
  621. Excel
  622. Looking up a date
  623. S Curves
  624. Conditional Formatting - Formula to fill cell using >%
  625. HOW I WRITE 12=10 OR 16=20 in excel
  626. Counting number of rows based on mutiple criteria
  627. Emailing worksheet
  628. How do I change date that is in All Caps to proper format?
  629. Lotus/Excel questions
  630. If statement conversion from Lotus to Excel2007
  631. extracting R-squared value from a chart
  632. INDEX MATCH AND ??
  633. Two question on working with text
  634. Modify a Formula
  635. Formula needed
  636. IF Statements
  637. Synchronize data across 2 sheets
  638. Week
  639. How can I autohide rows that have "zero" values?
  640. Sum of different value in different worksheet & cell number
  641. count between dates
  642. Exporting data using Pulldown List & VLOOKUP
  643. Pop up Box
  644. Copy Paste Financial Years
  645. Formula
  646. help creating a time function
  647. hide columns on a protected sheet
  648. Separating equal values
  649. Links in Excel
  650. Transpose & offset data from a table
  651. #N/A result because data is on another worksheet
  652. Paste Hyperlink result as working hyperlink
  653. compare 5 columns of text and highlight duplicates based on repeti
  654. Count Customers by Account Size
  655. Using the Question Mark With COUNTIF
  656. amortization of a mortgage
  657. multiple columns and row table and finding the answer
  658. Entering an If formula using conditional formatting
  659. Excel copy + paste
  660. Is there a function in excel where you can the beginning of the mo
  661. Help needed on date matching and cell reference.
  662. SUMPRODUCT
  663. join imported Excel 2007 files
  664. Calculate weighted average for 1 column
  665. can i give a number an automatic colour on spreadsheet
  666. Lookup data in the list
  667. weighted average - 1 column
  668. Relative Reference in Conditional Formattin
  669. remove headers & Footers Excel 2007
  670. Problem with Refresh all external data
  671. AND formula
  672. count values in range based on value in same row
  673. Creating Visual Excel Cell Alerts
  674. Looking up both row and column to give a third value
  675. offset, transpose funcion
  676. HOW TO DO ENABLE ENABLE THE QUERY PARAMETER BUTTON?
  677. Selecting items
  678. Multilayered Spreadsheet Function
  679. Auto fit row height
  680. subtracting 2 cells but only if 1st cell is greater than 0
  681. Vlookup and rounding
  682. shared workbook in excel 2007
  683. Calculate percent on numbers in different sheets
  684. Highlight rows if duplicates are found
  685. Formula To Bring The Best Name 2
  686. calculate percentage from cells in different worksheets
  687. Need Formula to "Adjust" to New Column Assignment
  688. simple formula help for matching information
  689. calculate percent between 10.0 and 12.0 for data in multiple sheet
  690. Offet?
  691. Vlookup and retrieve values 1 row below the normally retrieved val
  692. Excel - Ignoring the contents of cells when there are letters in thecell
  693. IF THEN copy & paste macro
  694. using two cells 1 with total time n 1 with date how can i put the.
  695. Removal of Zero
  696. Negative Standard Deviation?
  697. SUMIF/AVERAGEIF with mulitle range and sum ranges
  698. Copy and move check box (check boxes) with new cell link?
  699. how to trigger data
  700. Rounding dollar amounts in half dollar increments
  701. How do I calculate a specific formula for price increases?
  702. if function?
  703. Unhide, Unprotect, Enter Password
  704. Max function
  705. 90 day Running total
  706. VLOOKUP to return Cell Address
  707. Comparing two spreadsheets
  708. multiple match
  709. typing in a new cell and carrying the formatting of the previous c
  710. sumif to aggregate month to quarter
  711. Password Userform
  712. Vlookup
  713. writing a formula in Excel spreadsheet to track how long data has
  714. Change listbox text size in Excel 2007
  715. Formula To Bring The Best Name
  716. Counting number of cells
  717. Macro Fill
  718. Macro Fill Formula
  719. Search
  720. DSUM - SUMIF - or something else?
  721. Conditional unlock for cells
  722. Multiple data returning initial hit
  723. Delete a sheet
  724. Conditionally formatting numeric data and text differently
  725. Display tabs for all worksheetts at bottom
  726. Number Formatting Issue
  727. Why can't I repeat a sort on another range of a worksheet?
  728. SUMIF and multiple criteria
  729. Data Matching
  730. create list based on criteria
  731. Multiple Variables in Conditional Formatting with Excel 2003
  732. can't save changes to workbook; ready only
  733. Splitting data from one spreadsheet into multiple spreadsheets
  734. Does date in Cell A1 occur between the date in M1 and Date in X1
  735. Collated Survey Analysis Finding Average
  736. Count my Customers
  737. Correcting Multiple Div#0s
  738. Increase cell value by 1 based on another cell change
  739. testing for left 2 characters in set of 3 choices
  740. Countif function
  741. Unique Records
  742. If over 60, then show all detail
  743. if(iserror()) question
  744. When entering formula it does not show the value but the formula
  745. Counting cases between dates
  746. Contatenate folder path strings, how ?
  747. Time Format
  748. Count if between date parameters
  749. Formula to bring in the header
  750. Where best to place an instruction in a VBA script
  751. Is there a more efficient way to write this SUMPRODUCT
  752. Sumifs with data and dates - I can not figure out the dates
  753. How do I not count cells that have formulas in them
  754. how do I format numbers as text
  755. The blank cells i need to count have formilas in
  756. COUNTIFS function
  757. conditional formatting??
  758. Merge Problems
  759. If Then formula w/ alphanumeric listbox
  760. I don't want row 1 as the column headings
  761. Excel Formulas look different
  762. Excel 2003 - A macro to exit excel
  763. Possibly an IF function?
  764. Database argument in Excel 2007
  765. vLookup
  766. SUMPRODUCT COUNTIF Problem
  767. numbers in numerical order
  768. Removing text in combo with anther FIND function
  769. Nested IF Function problem for Excel 2003
  770. How?
  771. Adding text values in Excel
  772. IF clause for a range of cells
  773. Generate Payment Due Date to exclude Weekends and Public Holiday
  774. How do i count the number of text Entries of one word over a range
  775. Location of the first greater than cell
  776. Check if Duplicate with Exceptions
  777. Excel hyperlinks and Windows 7
  778. View 2 workbooks to compare
  779. Importing etc.
  780. #DIV/0! ERROR
  781. VLOOKUP: Referencing worksheets whose names contain commas
  782. Converting pounds and ounces in worksheet for a recipe
  783. counting instances of predefined text in a row
  784. Sorting with merged cells in the worksheet
  785. TITLE FOR A ROW GROUP
  786. TITLE FOR A ROW GROUP
  787. Need RANK Function for Text
  788. HOW CAN I EXTRACT TEXT TO THE RIGHT OF A THIRD SPACE FROM THE LEFT
  789. XML Element mapping
  790. Scorekeeping Formula
  791. Copying a Conditional Formatting Formula
  792. How do I make headers for columns in which their are 6 columns?
  793. Y Axis labels: How to make them different to figures used to plot.
  794. Creating an Income & Expenditure Sheet
  795. how do you do reduce ratios in a spreadsheet
  796. emailing autofilter results
  797. Excel Formula for adding training times.
  798. Check if Time falls between ?
  799. Auto Fill function in Excel 2007 not working properly
  800. row number of last non-blank cell
  801. Rounding hh:mm to nearest 15, 30, 45 minutes
  802. Spell Check in Protected Work Book
  803. div/0!
  804. Overwriting a cell with a formula without deleting the formula
  805. Format Time
  806. Formula to go into sub folders of main folder and get values from
  807. How to Sum a column if reference column is blank
  808. excel 2003 (11.8307.8221) SP3 - custom cell formatting question
  809. Copying Date and pasting special - DATE CHANGES?!?
  810. LOOKUP VALUE OCCURS >ONCE IN TABLE ARRAY - RETURN LAST OCCURRENCE
  811. Macros and security
  812. COUNTIF ?
  813. return a value in one cell based on multiple formulas
  814. Mark Up
  815. IF in formula
  816. SUMPRODUCT and INDIRECT
  817. adding a "relationship code" to a worksheet
  818. How can I select the first blank cell
  819. Formula Question
  820. SUMPRODUCT and INDIRECT
  821. Reading Multiple Files
  822. If
  823. Excel basic quiz
  824. Format date in header
  825. Counting current streak
  826. Simple Count of certain cells
  827. Vlookup in multiples columns
  828. conditional formatting in excel 2007
  829. How to seperate ALPHANUMERIC data in a cell in an excel sheet.
  830. Different Passwords for different worksheets in one workbook
  831. Retriving column header for non empty cells in a row
  832. Sum with a slash "/"
  833. Divide two cells and if the number is negative display is as zero
  834. Shared Workbook User had unsaved information disappear
  835. Extracting data from multiple new workbooks via one master workboo
  836. round result of sumif formula
  837. excell formulas
  838. how to delete and insert in a two cells merge using Access 2003?
  839. Newbie question - column letter displayed instead of number
  840. Days Count Sheet Help
  841. Right function
  842. Embeded IF - between ranges
  843. Formula that will not return "0" from a blank line
  844. import data from several spreadsheets into one spreadsheet
  845. Parameters for Random Numbers
  846. Sumproduct or ????
  847. Populating worksheets from source worksheet
  848. I need to populate different worksheets from a source worksheet.
  849. Transpose stacked lists of values
  850. Indexing Sheets in Referenced Workbook within formula
  851. Maintain cell reference after value is moved
  852. Turning numbers into Dates
  853. Using VLOOKUP wrong?
  854. Random Numbers and Me
  855. Random Numbers and Me
  856. Maintain cell reference after value is moved
  857. Need a function
  858. Random Numbers
  859. IF Statement with Dates & Calculations
  860. Lookup & return multiple rows based on cell value
  861. excel problem
  862. Worksheet to Worksheet skip blanks
  863. Spin Box Date and Sumproduct
  864. Nested IF Function help
  865. E2007 formulas display as formulas, not results
  866. I can't seem to find anything with regards to this.. sorry
  867. Excel lookups should have a return paramater if not found
  868. data validation fonts differ in drop down box
  869. Any Way to Save Eons of Typing? Automating 3D Reference to Sheet N
  870. Average number excluding 0 and blanks with text criteria
  871. Sumif Format Equals
  872. #Adding new worksheet problem
  873. Spin Box with Dates and Lookup
  874. Count text with specific criteria ignoring N/A and blanks
  875. Paste Values Based on Conditional Value
  876. Conditional Format Q
  877. What Formula to use when looking for text over multiple worksheets
  878. @How to add new worksheet on right side....
  879. Excel formula request
  880. Rounding date field up to next first of month, with existing formu
  881. Entering a dollar amount w/out having to enter the decimal
  882. If Formula??
  883. Tab Key
  884. Using the Address Function
  885. Calculate hours, past midnight etc
  886. linking a range of cells (=) to another range
  887. Excel 14.0 - higher frequency of (Not Responding) & screen going W
  888. % Change in reverse (algebra)
  889. Determine if 2 cells share a common word
  890. #NUM!
  891. How do I add the formula bar?
  892. Need help with formula
  893. Not just remove dup rows but combine columns
  894. summary
  895. COUNTIF for date and amount
  896. What if analysis icon is not available
  897. Sorting and grouping data with varying number or rows
  898. Fast fourier transforms
  899. Strange Function Copy
  900. having issues converting from 97-07 with conditional formatting
  901. Is there a one button shortcut for "copy cell above & paste here"
  902. Macro code behind button
  903. If Statement
  904. convert time to decimal
  905. I cannot enter information in excel sheet, info bounces to top
  906. Calculating turaround time using IF function
  907. Display results of formula
  908. Nested MID and FIND - OR?
  909. Sum function changes arguments
  910. Calculate pivot table items in 2007
  911. Adding data to a 2007 pivot table
  912. search for text "beginning with" "containing" wildcards
  913. convert 13.11.2009 general to 13/11/2009 date, how to
  914. Between dates
  915. Copy or Move
  916. linking worksheets and files
  917. SUMPRODUCT or COUNTIF FOR TEXT VERIFIED LIST
  918. Trim
  919. date and time difference
  920. Date and Time
  921. Excel 2003 Pivot Table Problem - Can No Longer Create Calculated Field
  922. How to Color a Cell Based on a Range of Cells with Colors
  923. Excel to Word
  924. DateRange Lookup no exact match, can't use lesser
  925. Counting Text Occurances - HELP PLEASE
  926. counting dates <= 7 days ago based on criteria in a diff column
  927. Condition formulas for multiple columns
  928. Sumif and Specified Ranges
  929. cell displays 0 when formula is valid
  930. Column Width
  931. how do I get a php code
  932. Summing Up My Time (minutes)
  933. how do I dropdown list
  934. Summing Cells with Text and Numbers
  935. If statement
  936. RE: CAN YOU SOLVE THIS!!!!!!!
  937. =I34*H34 without N/A
  938. If sign of sum is negative change to positive
  939. What's wrong in this Eqn?
  940. multiple V-lookup
  941. IF, THEN SYNTAX
  942. Comments
  943. Excel 2007 CF Multiple criteria
  944. Network drive
  945. Refernce 2 sheets & same columns & rows
  946. Summing over multiple worksheets
  947. Indent
  948. Auto fill
  949. Can you solve this????
  950. Test
  951. Mapped vs Network drives
  952. Total weekly worksheets to quarterly
  953. Insert a new Worksheet AFTER the existing (Active) sheet
  954. What formula is needed to return the number of spaces indented?
  955. Removing Macros
  956. How do I get my data back in excel after hiting F11 by mistake?
  957. excel formula syntax
  958. Cell Reference
  959. Combo Box text and Controls changing size on Monitor change
  960. Functions
  961. Caps Lock vs Lower Case
  962. Sig Figs
  963. Previous Posts
  964. vlookup
  965. Dynamic Range in Offset Help Request
  966. Dynamic Range for Offset
  967. Averageif puzzle
  968. PivotTable/Chart - Statistics (Excel 2007)
  969. Determine if a month falls between two dates.
  970. Use extract into a condition
  971. Excel Worksheet
  972. How to Control a formula by a character in adjacent column on same
  973. formula finds values in apparently blank cells
  974. how to calculate a projected date
  975. In Excel ,
  976. Counting Consecutive Numbers in a List
  977. Counting consecutive numbers in a list
  978. How I convert a numbers to tex --10 to ten
  979. Using time functions to give a warning
  980. Counting consecutive numbers in a list
  981. Formula displaying don't know why
  982. Count Blank Cells & Letter P
  983. adding a toolbar function to an excel cell
  984. Auto Sum range with multiple columns.
  985. assign numeric value to letters and sum with other numbers
  986. How can I change the row height of specified rows?
  987. Drivers for percentage increase
  988. Format within a Function
  989. Write formula for simple copy and paste to another cell
  990. What If or conditional formatting?
  991. Specific word - font color change
  992. Vlookup with more than 15 digits
  993. Unable to see custom Ad-Ins ribbon tab in Excel 2007 + Windows 7
  994. MULTIPLE PRINT AREA
  995. test1 v-2masa
  996. sum letters with values and numbers
  997. Help with a formula
  998. conditional function?
  999. Totaling YTM on a group of loans
  1000. WHAT DOES 'DATA SOURCE REFERENCE NOT VALID' MEAN?