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. FORMULA'S
  2. Sort data separated by commas
  3. Replacing one text with three in IF(ISERROR(FIND.......Max
  4. Changing a formula to read a general value?
  5. Re: convert matrices to table
  6. count of number of rows within a range with a certain text
  7. RONA Spreadsheet
  8. Formulas to Numbers
  9. Average with Conditions
  10. Re: convert matrices to table
  11. Conditional formating dates
  12. Re: convert matrices to table
  13. Variable Sumproduct Range
  14. Lookups and ifs!
  15. Adding VLOOKUPS across multiple worksheets
  16. How to look up a value?
  17. How DEC2BIN Function to display 13bits ?
  18. Using Custom Views with Protected Worksheets
  19. sumif across multiple sheets in excel 2007 based on a condition
  20. runtime error code 1004
  21. Ziping excel 2007?
  22. Cell Function/Font Color
  23. Zero and Null Sum Function
  24. SD03*10 -how do I just get the numbers at the end in cell after *
  25. Finding next number in a series
  26. Match Formula for three fields to produce result
  27. Combination of IF, AND, and COUNTIF; need help
  28. Conditional Formats, how to scroll and view all formats?
  29. Time Format Question
  30. Need help to create a macro
  31. IF formula help?
  32. Formula Help
  33. If date matches and formula hasn't already been calculated previou
  34. VLOOKUP
  35. How to calculate diffrence in dates in days and Hours
  36. Shading in cells is not printing....HELP!
  37. Worksheet Function required
  38. i enter value in one column the next column existing value turn 0
  39. Grouping and sorting details
  40. Receive data in column with pull down
  41. populate month-yyyy when compare 2 cells
  42. Nesting IF Statement in excel 2007
  43. Function Error IF Statement
  44. formula to subtract 60 days from a date (05/25/2010) 2003excel
  45. Excel File Size
  46. Copy If rows to another worksheet
  47. YTD with conditions
  48. Copy Top 10 conditional formatting down 1000+ rows
  49. Average range of discontinuous cells
  50. VLOOKUP use column name not number
  51. Forecasting
  52. How do I limit formula results to positive only?
  53. How can I set a "page end" point on a large worksheet?
  54. Auto fill Cells with text
  55. Countif help needed
  56. vlookup across multiple pages
  57. Average Length of Stay
  58. sheet protection with links
  59. horizontal scroll bar
  60. Excel 2003 worksheet tabs missing at bottom of my laptop display
  61. Automatic sequential numbering where a value changes
  62. Excel auto accumulation formulas
  63. Remove Text From AlphaNumeric
  64. Ranking from one sheet to another
  65. How do I average every 3rd cell in a column of a spreadsheet?
  66. =SUBSTITUTE(C4,"~?#","") will this work to remove multiple string
  67. lookup to see if multiple values exist
  68. Index and Match
  69. Pivot Table from 2 worksheets
  70. How to Auto Reference Worksheet Tab ID's in Formulas?
  71. how do i format sub sections in a pivot table
  72. Data Validation - Conditional List
  73. How to make "X" have the value of 1?
  74. update the hyperlink in file after changing the file name
  75. Match 2 Columns, Return 3rd, Differing Match Types
  76. Adding to a SUMPRODUCT formula
  77. matching & combining data from seperate worksheets
  78. Where does Max keep his files now ?
  79. MS office 2003
  80. how to increase row capacity than allowed in basic EXCEL workbook?
  81. custom format changes to special
  82. Global Warming and what you can do to against it
  83. Re: Auto insert sheetname into chart title?
  84. Re: Auto insert sheetname into chart title?
  85. Method of viewing/naming columns or conversions for same
  86. In Excel how do you rearrange a list of address's in alphaetical o
  87. Data Validation
  88. COUNT unique letter in a column
  89. Another Sumif problem
  90. VBA data validation
  91. Colour code specific name if it appears in a group of names
  92. update vlookup formula sheet reference for multiple sheets
  93. Lookup when value is between 2 columns
  94. worksheet set up
  95. Math help
  96. Question using countif
  97. How do you add a number from a different worksheet into a formula.
  98. Need suggestions on layout to report/pivot
  99. Is there a way to format a cell to show aging?
  100. sumifs multiple columns help
  101. How do you make the results of a concatenate permanent text?
  102. How to SUM entire column, but only when adjacent cell is not empty
  103. What type of "lookup"
  104. Graphs in Excel 2007
  105. vlookup
  106. Select Month, get the dates
  107. Excel
  108. RE: Two IFS
  109. RE: Two IFS
  110. Combobox has no arrow, just a line on the right, what's wrong?
  111. SUMIFS question
  112. Immediate HELP please Window of circadian low
  113. Columns
  114. in excel how can we put formula to convert numericalfigureto word
  115. time format
  116. Is there a way to conditionally hide rows in Excel?
  117. vba for color coding
  118. Logical function with multiple cells
  119. using a time format in a count function
  120. If Function Function
  121. Site for some reason, and forbidden
  122. How to create a formula to remove multiple . in a numbers?
  123. Sum with 2 if's
  124. VLOOKUP IS ERROR
  125. Make all dates display 01 as the day
  126. Nested If Statements
  127. Edit Excel file
  128. Difference between two numbers
  129. Conditional Formatting
  130. COUNTIF not counting properly
  131. How do I hide multiple rows under one row IN EXCEL?
  132. Removing disabled Macro
  133. Calc staff vacation time based on more than 1 criteria
  134. Vlookup formula
  135. assign a macro to send email in lotus notes from Excel spreadsheet
  136. Multiple condition data validation
  137. two condition formula
  138. Formula Help Needed . .
  139. how to remove page breaks from an existing document
  140. Excell - two conditions count if factors are true when negative nu
  141. Using SUM + INDEX in array formula
  142. formula to return value from a matrix - I know hor and vert values
  143. Re: Time calculations over 24hrs
  144. Re: Time calculations over 24hrs
  145. Re: Time calculations over 24hrs
  146. Re: Time calculations over 24hrs
  147. Formula help please
  148. how do i copy the result of a formula into another worksheet as te
  149. sorting numbers
  150. Worksheet Functions
  151. IF AND question
  152. Why does this confuse me?? -- ? on Offset function
  153. Present Value of equal payments of a future value
  154. expand row to fit
  155. Using external query (mdb) for dynamic date range
  156. Conditional Formatting
  157. How to clear all checkboxes on a form?
  158. Why wont 'autofit' and 'wrap text' remain in tact?
  159. time format from hh:mm:ss to h:mm
  160. Prevent Some/Allow Some cells to update on F9
  161. Percentages breakouts for Ranking
  162. How do I apply print settings to all worksheets
  163. Pivot Table Columns
  164. validation
  165. Calculate next workday after adding calendar days to date in cell
  166. Convert text entered as minutes/seconds to minutes
  167. Auto-lock a cell once it's updated
  168. Linking data from one worksheet to another...
  169. hr worksheet counting days missed
  170. How do I set up a botton on Excel 2003 to go to the next sheet?
  171. Shortening text in a cell
  172. vlook on different tabs based on value
  173. VLOOKUP
  174. Basic help needed using sumproduct to do a league table
  175. Duplication
  176. Pivot Table Help - Gross Margin % & % of Sales
  177. I want a footnote number (small number) at end of sentence?
  178. Referencing a cell in other worksheet that is using autofit row he
  179. How do I write a formula in excel where 1 = .05 and 2 = .75 etc.
  180. Save As csv Carraige Return issue
  181. insert blank row and formulas
  182. WEEKNUM function not working
  183. sum 2 values in diffnt cells with dup values, and sum if not dup
  184. Copying info from worksheet to worksheet if info matches
  185. Counting for frequency
  186. right syntax
  187. count similar text with using filters
  188. Help with SUMPRODUCT & converting date to value
  189. Conditional Formatting
  190. Match - not sure how to use this function
  191. activate formula when adjacent cell populated
  192. Re: conditional formatting
  193. Compare
  194. Excel 2007 Pivot Tables compatible with 2003
  195. Changing cell colours on a pie chart
  196. Top 10 in pivot - show rest as other or similar
  197. formula to copy from a cell
  198. How to insert Checkbox in excel to simply click and tick it?
  199. Index, match, multiple IFs query
  200. About Data Validation
  201. inventory
  202. Count If equals x AND y
  203. Graph Paper
  204. Combining cells with text
  205. Regression Formula
  206. make a check form, and then have info go to a check register
  207. In Excel need to have a sub worksheet inserted into each row
  208. Pivot Excel 2007
  209. Count blanks by date
  210. lookup?
  211. set flashing alarm by a date for a text box
  212. Match data
  213. LOOKUP formula when term may not be present
  214. Trending Function?
  215. formula for month that is prior to actual
  216. Latest Purchase Price
  217. RE: conditional formatting
  218. averaging a range
  219. How to freeze one column vertically, one horizontal in same sprdsh
  220. formula for visible cells
  221. Identifying a label.
  222. Count, Sum, Index,Match or other formula needed
  223. Counting results of a formula
  224. Auto update worksheets
  225. copied from web page to excel sheet and cant remove from sheet
  226. Excel Security
  227. Vlookup?
  228. Macro Help
  229. SumIf AND
  230. Formula for competition pairing
  231. change text color when the value become lower than a certain value
  232. Vlookup and match part of text in a cell
  233. Increment a number based on four adjoing cells
  234. keep formula delete contents
  235. how do I achieve my xl spread sheet in Alphabetical order
  236. How can I reference a worksheet in a formula based on a cell value
  237. Find latest date from list and corresponding info
  238. Help with Conditional Format Formula
  239. Aggregating data among multiple workbooks
  240. random number generator
  241. Conditional Formatting - stuck on formula
  242. Formula to sum based on a change in another column
  243. Lookup / Summary Table
  244. filtering subtotals and if functions
  245. counting occurences of month on a specific worksheet
  246. counting how many times a certain month appears
  247. Simple calculation where values change to letters?
  248. Lookup / Summary Table
  249. countif/sumproduct + month
  250. counting occurences specific month appears
  251. how to change the pivot chart automaticaly as values in the worksheet change
  252. conditional format help
  253. code to copy range
  254. formatting a spreadsheet help
  255. Format Ratio Q
  256. IF function
  257. sort 2 column in the same time "" as dictionary ""
  258. Using Fill command in Editing Group
  259. how do i use format cells to alpha / numeric values
  260. Macro for Time Recording
  261. Excel and consecutive number
  262. Maximum number of cells for 'SUM' ?
  263. Copy formula from one worksheet to another to get value in 2nd wks
  264. IF Function Help
  265. Logical Test for blank and then for score
  266. summary values across worksheets within the same workbook
  267. Drop list and redirect
  268. Having problem with referencing
  269. Sumif Function
  270. Conditional Formatting on Index,Match formula
  271. Count Multiple Text Entries
  272. YES or NO formulas
  273. Conditional formatting problem
  274. Need some help with auto-fill
  275. Nested formular to give a word answer based on 2 cells
  276. determine a range using a formula
  277. VBA to autofill from relative location
  278. SAMPLE EXCEL DATA
  279. extracting data from one cell to another
  280. Multiple AND OR functions
  281. IF formula help
  282. Pick List + Alphabetical Skip To or Auto Complete
  283. Rank order with conditions
  284. VLOOKUP help (possible format issue)
  285. need to install DVZXLAddin.xla
  286. protection error
  287. counting unique text values in an array of data
  288. Dynamic sheet reference in Name formula
  289. Vlookup return 2nd match
  290. Finding most recent date for each customer - XL 2007
  291. Average IF Function
  292. Adding fill to cells only when value is "No" in another cell
  293. Counting Results of Formulas
  294. search excel for overpopulated cells
  295. Dynamic pivot table linked to dynamic excel spreadsheets
  296. Insert Lines
  297. Formula to calculate Latest Cost (inventory valuation)
  298. complex lookup
  299. ActiveX from 2003 in 2007
  300. How do I remove data in a row in excel without losing all data in
  301. SUMIF? or not?
  302. I want to conditionally format an entire column after 1 year from
  303. Count Text to get a Percentage
  304. Formula issue.
  305. IF, THEN HELP
  306. RE: Format a dollar amount to text
  307. RE: Format a dollar amount to text
  308. Help with lookup
  309. using GETPIVOTDATA feature and need to keep formatting
  310. negative value
  311. Re: Copy is criteria met
  312. Combine an And OR function
  313. Re: Copy is criteria met
  314. dates on worksheets
  315. When I search on my name "Meenie" I don't get 2010 posts
  316. need formula to add two different criteria in a range
  317. Copy is criteria met
  318. sumif formula
  319. result given from content of selected cells.
  320. Dragging values down a range using a colum to determine its length
  321. How does one put a watermark in an Excel worksheet?
  322. Imperial Weights in Excel
  323. Counting Characters In A String
  324. if statement, change cell only if true
  325. Build 'show 0 as -' into existing formula
  326. Advanced Data Filter
  327. Adding data from multiple cell and linking to a new worksheet
  328. Slope??? help please!!!
  329. Adding Fractions and Displaying as a percentage.
  330. Vlookup - Returning 2nd match
  331. Record time by formula
  332. formula help
  333. adding time in a work schedule
  334. HOW CAN i DEVELOP A FORMULA THAT RESTRICY SYMBOLS CHARACTERS TO B
  335. Which (logical) function?
  336. Sorting a portion of a worksheet
  337. Running calculation of a frequency
  338. Excel Workbook with Multiple worksheets
  339. count text with * wildcard and date range
  340. Reverse $String1, String2 to $String2 $String1?
  341. splitting cell content from 1st column into 4 columns
  342. Average formula where blank cells are counted as zeros
  343. taking numbers in vertical cells putting them in horizontal cells
  344. Formula Help
  345. Average IFS (Multiple Criteria)
  346. Average IFS (Multiple Criteria)
  347. Possible to have various sections of worksheets print on 1 page?
  348. Average IFS (Multiple Criteria)
  349. Pull info from one excel file to another depending on values of O.
  350. Index Match Problem
  351. Pivot Table Comparison
  352. How to remove a bunch of zero's
  353. How do I get warpped data to auto fit in merged cells?
  354. Default Cell Values at Change
  355. date from sheet name
  356. Deleting/Clearing duplicate range of cells
  357. Using wildcard characters in find & replace
  358. HOW DO I COLLECT TEXT DATA FROM A COLUMN
  359. Keeping the format but update the data
  360. Calculate Accrued Time
  361. SUMIF Help
  362. If column A = B then pick up value in D.
  363. Using cell reference with logical operator in DGET expression
  364. Establishing a Time Window
  365. Increase PF Usage
  366. SUMPRODUCT with conditions
  367. Help with Vlookup
  368. To deal with #NA
  369. How to find the custom xml tags in a workbook
  370. Drop Down Menu AutoPopulate Contact Info?
  371. Average Unique
  372. Average If...
  373. How do I set a constant multiplier in an equation?
  374. How can I merge unprotected cells in a protected worksheet?
  375. if function help
  376. How do I delete a calendar function from a spreadsheet
  377. compound if equation?
  378. FDIST Function
  379. Removing items on Sheet1 that are common to Sheet2
  380. auto format
  381. FAO Mike H - Formula Answer provided
  382. How to use autofilter in excel with formula reference changing
  383. "Can not empty the clipboard"
  384. Need solution for wildcard use in array
  385. Formula to fill one cell from another
  386. Correlation tool says Input range must be contiguous reference.
  387. How to?
  388. MSN Stock Quote
  389. Significant digit causing wrong value?
  390. Using VBA to find a value and select a range
  391. Formula help
  392. Worksheet relative reference
  393. Counting dates within a range
  394. Missing values from a pivot table field
  395. add two cells from seperate work sheets into a cell on seperate wo
  396. is it possible to insert a pdf document into a excel worksheet
  397. Ctrl V paste coding was lost
  398. Date formula needed
  399. Identifying the top five values in multiple groups
  400. how do I double check that there are no formulas
  401. Calendar
  402. error alert for invalid date
  403. Cell Formatting of a Conditional Statement
  404. Modify general format to date format.
  405. Index using a defined name array
  406. Nested IF & AND functions
  407. Suppress First Page Numbering
  408. What is the formula to Round an average to the nearest 100
  409. Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible
  410. excel: How to set up a formula for a range of numbers ie. 3.5-5..
  411. Can Excel trigger Outlook reminder?
  412. Formula Help
  413. Formula addition causes random #REF!
  414. Fill/Extend Series adding decimal points to some numbers
  415. colating data from a table - for bespoke report
  416. Is there a function to solve for an unknown in an equation?
  417. what should be simple
  418. question related to merging multiple statements
  419. Date + relative number reference
  420. Help Needed with Dynamic CountIF
  421. Referencing relative to a formula reference
  422. limit comments to only 600 words
  423. Excel Formulas
  424. IF function
  425. Finding matches in two columns
  426. Show matching data in several worksheets
  427. RE: Can I SUM column C IF Column A=X AND Column D=Y?
  428. Find second to last value in cell
  429. Referencing formula using Indirect
  430. SUMPRODUCT
  431. how do I copy the last 20 entries in an expanding list
  432. Head scratchin for hours.... Help with a formula please...
  433. Drill down via page fields
  434. Satisfying two conditions?
  435. Format Data Labels
  436. INDIRECT reference or ?
  437. Excel formula help needed!
  438. Vlookup and Indirect
  439. Reference: forum discussion dated 17-18April2010
  440. List the UNIQUE certain fields from the database
  441. Count the frequency for every change in numbers
  442. Daily totals from a monthly log
  443. Links not working in Excel 2007
  444. Creating a formula
  445. problem with lookup function
  446. How do I use a percentage formula?
  447. Locking Worksheet Security Name
  448. Pre-Populating Fields
  449. Word lists
  450. Dynamic DropDown list from Unsorted vector
  451. Calculate number of days
  452. COUNTIF Formula
  453. Change a cells value with a function
  454. Need a code
  455. Shared Excel File
  456. VLookup between date ranges ?
  457. Excel Formula for years and months
  458. ODBC Query
  459. Despite formula I use (for example SUM) result is always zero.
  460. VLOOKUP and IF together
  461. How to select other random cells
  462. Can not copy a sheet to another book
  463. Formulas do not update
  464. Lookup
  465. Automatically hide/unhide rows
  466. Help me (Vlookup)
  467. how can i transfer data from one sheet to another without blank li
  468. Count first and last characters
  469. Import underscore in coding every after 2 digits
  470. How to Sum infinite formula
  471. GETPIVOTDATA and (blank)
  472. 11 months and 1 day from a given date
  473. how to remove all formatting
  474. Copying Cells with Fill Handle
  475. background colour of sheet gone gray need to change to whit
  476. "#VALUE!" Cell Value
  477. Conditional Formatting in Excel 2007
  478. How do I use sumifs -
  479. Sumproduct with 4 variables
  480. Counting by color
  481. why this strange result with vlookup
  482. Percentages in Pivotal
  483. looking for a function that will populate opening a worksheet or t
  484. Grouping on protected worksheets
  485. When refreshed, some Pivot Table columns retain formatting, some d
  486. multiple IF calculations
  487. Excel - How to get tab to go to next unlocked cell across columns
  488. Default Cell value in changing environment
  489. identify the numbers cancelling by amounts
  490. Centreing Text In Excel Cells
  491. copy paste value
  492. I want to compare two coloumn particular text, then count total
  493. More than 7 If Functions Example is IF(A2="Bongaigaon", B2*40, ..
  494. vlookup with two recors
  495. Reference different lines in the same cell
  496. Which formula combination will solve my anticipation
  497. How do I search for the second largest value in the array?
  498. combine multiple spreadsheets into one workbook
  499. Installing service reminder popup windows in excel
  500. How do I get the formula icon back on my toolbar?
  501. Conditional Formula Words
  502. logical (if a1=specific word, can c1 = value entered in a2?)
  503. Excel 2003 make 1 date cell automatically change another date cell
  504. Keep lines when one column equals certain criteria
  505. how do i create a repeating student certificate using excel
  506. Text to values
  507. How do i set up a concecutive numbers in Microsoft excel sheet?
  508. GETPIVOTDATA and Date-type field (Excel 2007)
  509. Categorizing Data Question
  510. Rounding Seconds in 4/21/2010 4:30:23 PM
  511. Conditional more than one iif
  512. How do I update links from .xls sheets to .xlms sheets
  513. Logic Formula using colors in the formula?
  514. Formatting question with Round
  515. COUNTIF: everything in a row larger than zero over multiple worksh
  516. Vlookup + sumif , but how????
  517. Display formula Excel uses for internal functions (STDEV...)
  518. Conditional format will not work without $ (removed to allow copyi
  519. Conditional Formatting Question with 'OR'
  520. Reorder $String1, $String2 to $String1 $String2?
  521. Excel 2007 Page Break Adjustments causes a page break each cell
  522. Excel 2007 on Vista
  523. Combine two sets of overlapping Date/Time data into 3 columns.
  524. Help with Date Function
  525. VLOOKUP in VBA
  526. Search Macro
  527. Counting values in an array where value in one column is not null
  528. Count values in array of data where no blanks in one column
  529. Pulling/Collating Data from Workbooks
  530. Range Vlookup
  531. Return cell characters after space
  532. multiply value based on quantity
  533. Convert times to text string
  534. comparing more then one column with numbers and letters
  535. combining columns and using concatenate
  536. Filter
  537. excel - horizont line above font X
  538. Open multiple spreadsheets and pull data
  539. How to hide infromation in Excel?
  540. If then
  541. Text to Date
  542. Total a column (or row0 by highlighting cells
  543. Lookup value that falls between two values in a range and then som
  544. pulling a list of hyperlinks from a worksheet
  545. transfer cell value from 1 sheet to another without copy/paste?
  546. Calculating daily totals from multiple worksheets (Excel 2003)
  547. Charting the Sum of Two, or More, Series of Data
  548. Count If.....help
  549. Automatic update to SUM formula cell references.
  550. Vlookup issue
  551. IF and Right Functions
  552. Sum Function Visible Cells only
  553. Avg % above 0%
  554. Changing the range for averages with out changing the formula.
  555. Functions / Drop Downs won't calculate
  556. Show zero values in specific area
  557. Saving & Removing VB Code from WB
  558. worksheet
  559. Reconciling Invoice & Credit
  560. Conditional formula
  561. Re: Re:COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard"
  562. Getting the average from a column using date constrants
  563. Counting consecutive negative value
  564. Excel corrupts when asking to update vlookups
  565. Re: COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard"
  566. Formula Excel
  567. conditional formula needed
  568. how do I drag and fill hyperlinks?
  569. Averaging times that are not in a range
  570. Data Encryption
  571. Getting a value by comparing 2 columns
  572. Id'ing tabs that contain #REF!'s
  573. COUNTIF Function
  574. Dynamic formula
  575. revised q on report from tables
  576. Custom Functions Available for all Workbooks
  577. Re: Text from Referenced cell truncated
  578. Function to Use when compare sums another column
  579. Pivot table to calculate variance showing budget and actual.
  580. formula similar to "countifs" function in excel 2007
  581. Help with formula
  582. Too Few Rows to copy sheet to another book
  583. single report on data in 20 tables
  584. Drop Downs and lookups from other sheets
  585. Excel Toolbar
  586. i dont know if sumif ,,,,, please help
  587. Automatically insert rows/copy formula
  588. Date refrencing
  589. finding 10 smallest numbers from last 20 input
  590. Formula assistance please . .
  591. COUNTIF PROBLEM
  592. Check the lasta character
  593. hiden cells copied automatically to another workbook, can I stop .
  594. Compare two columns with different codes
  595. need help with formula
  596. Finding duplicate addresses
  597. Deleting Row
  598. compare 2 columns, enter data from other column
  599. Re: multi-worksheet sum
  600. Conditional Copy from one worksheet to another
  601. Re: multi-worksheet sum
  602. Complex functions
  603. How do I match 3 different workbooks information for similar data?
  604. how do I perform an interpolation analysis using Excel?
  605. Multi NetWorkDays Calculation
  606. Vlookup and Data Validation Q
  607. What does this formula mean [$-F400]h:mm:ssAM/PM
  608. Top half of covariance matrix
  609. Linking to other worksheets
  610. Sorting
  611. m4=b4 only if
  612. Lookup Question
  613. What happened to setting up a constant using F4?
  614. Linking Totals Across Multiple Worksheets
  615. to CONCATENATE from the smallest date with at least 2 criteria
  616. Font by way of function?
  617. Store formulas in Vlookups? (another try ;)
  618. SUM determined by drop-down list
  619. Validation of UK VAT Number
  620. Date question
  621. Function to seacrh for a word across multiple columns
  622. Add text automatically by recognized value
  623. Sumproduct with mixed data?
  624. Re: multi-worksheet sum
  625. counting groups of words
  626. formatted cells
  627. Converting PDF or HTML to Excel
  628. Count if past today () - 30 days
  629. If 3 If's, then sum
  630. Dynamic Filtering...Need Help
  631. Finding the lowest cost for a product from a list
  632. RE: multi-worksheet sum
  633. Using text and formatting sum function in formula
  634. Identify the windows just below the menu
  635. Can you sum the amount of type a word appears?
  636. Formula
  637. RE: Week ending Thursday formula
  638. excel 2007 macro recorded pivot table
  639. Re: Average numbers in noncontiguous columns ignoring 0's.
  640. concatenate
  641. Re: Week ending Thursday formula
  642. networkdays issue
  643. Sum of retuned valus as digits
  644. search a row for a word and if found
  645. Concentration Analysis
  646. Finding NEXT to last, non zero numeric value in a row
  647. copy formula
  648. Conditional Formatting Date Range
  649. SUM
  650. If function help
  651. copy/paste malfunction
  652. Maybe too hard to do?
  653. Re: Average numbers in noncontiguous columns ignoring 0's.
  654. Interval between now and next birthday
  655. Function similar to "LEFT"
  656. annuity calculation for monthly payments but quarterly compoundin
  657. spreadsheet
  658. Need function to return numbers at beginning of text
  659. VLOOKUP returning formula
  660. Can excel data be encrypted?
  661. CONCATENATE
  662. comparing data in excel
  663. Add no. of days to a workday to get new workday?
  664. Compare 1 cell to column of cells returning adjacent cells info?
  665. Sort
  666. Pulling a cell reference--clickable cells?
  667. Logical function please
  668. #N/A help please
  669. copying a formula down wards
  670. Rounding Up question
  671. Add values based on text color with the criteria of a date
  672. rounded # to correct #
  673. Sumproduct with a twist
  674. creating a report from a table, pivot table not suitable
  675. Pivot table show all days of a month even if no data
  676. VLOOKUP & IF
  677. Convert percentage into margin
  678. pounds shillings pence format in excel
  679. Help with If Sum statement - i think....
  680. Can I combine a Vlookup with an IF formula?
  681. Sumif with multiple sum ranges in a sheet
  682. Setting up an electrical register in Excel with expiry dates
  683. Re: How I convert a numbers to tex --10 to ten
  684. directing cell contents dependent on its value
  685. Directing cell contents to one of two cells dependent on its value
  686. Vlookup
  687. How do I recover a forgotten password?
  688. Countif/SumProduct
  689. Excel IF Formulas
  690. how do I import data in excel form SQL server?
  691. How can I add the values based the color of font and the date
  692. Filldown starting from F2 instead of F1
  693. Changing Source Data using V-lookup
  694. data links on subsequent worksheets
  695. Excel 2003 - deleting Duplicates under conditions
  696. Protecting Sheets with drop down boxes
  697. Adding a value to a customer ID?
  698. Show time as a negative figure
  699. multiple dependent drop down lists
  700. If argument
  701. Contract Value Formula
  702. workday, networkday or something else?
  703. Auto Calculate Keeps Resetting to Manual
  704. 2 worksheets--3 questions
  705. Vlookup and if formula
  706. Ad-In Rowliner
  707. SumIf
  708. Icon sets - conditional formatting - in Excel 2003
  709. Sumproduct with sumif over mutiple worksheets
  710. Multiple section for one answer
  711. Use Vlookup to store formulas?
  712. Vlookup & relative cell reference?
  713. Re: Countif for finding a Time input
  714. RE: Countif for finding a Time input
  715. Days in Text to Dates SPECIAL
  716. Formula referencing a changing range??
  717. Conditional Formatting based on match to external list
  718. General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY
  719. How do i convert dates to text but keep the date format
  720. Help needed with If & Today function
  721. changing formula
  722. If & Vlookup statement
  723. Validation list with formula?
  724. Change the weekends
  725. Rounding
  726. vlook up w- multiple variables
  727. Date Diff - excluding working days
  728. Median with Criteria
  729. using CountIF function or Array?
  730. Conditional IF formula using multi-dimensional arrays
  731. stock control template
  732. Auto-insert same value each Monday in cashflow worksheet?
  733. Adding totals from different columns
  734. Hyperlink won't open in excel
  735. Find and Replace
  736. Pulling/Collating Data
  737. Array Formula Help Needed
  738. Sum amount of days in another coloumn
  739. Urgent help needed - hyperlinks
  740. Vendor List
  741. Help with formula
  742. Conditional formatting with expired dates after current
  743. I want to add formulas from multiple sheets to master form
  744. row height issue
  745. Lose Formatting
  746. Average using Sumproduct
  747. vlookup and match first value greater than
  748. Need to extract specific data from a text column
  749. Combining text from multiple cells
  750. data validation using named range from another file