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. Count based on multiple criteria
  2. Formula in CF
  3. Marking new names
  4. Cell Referencing
  5. Conditional Format - using 3 different cells conditions together
  6. Conditional Format - using 3 different cells conditions together
  7. Conditional Format - using 3 different cells conditions together
  8. Conditional Format - using 3 different cells conditions together
  9. Conditional Format - using 3 different cells conditions together
  10. How to select blank cells only whilst using sumproduct
  11. SUMPRODUCT
  12. Sumif, unique counts,
  13. Fill cell colour based on input in another cell
  14. Formula for converting xx/xx/xxxx dates to a number between 1 and
  15. if, and, Vlookup functions - mutiple matchng
  16. Hidden cells expanding when completing calculation
  17. Hidden cells
  18. Need help with formula to count the number of times each date appe
  19. Complex VLookup Formula
  20. What formula is used to find Target Spots?
  21. Alert in Microsoft Excel
  22. Using two hyphens in front of an Excel function.
  23. Calculating Phone Bills Help Please
  24. Match & Vlookup Function
  25. Sum If on multiple columns with range of criteria
  26. Dmax formula
  27. How do I create multiple workbooks within one workbook
  28. changes not being saved in 2007
  29. assign a number to the same date & start over with 1 on new date
  30. index, Match statement
  31. subtract entries from allocated total until it reaches zero
  32. How do I add an apostrophy to a range of existing cells?
  33. logical functions
  34. Re: Not sure what formula or array to use
  35. help needed with lookup and related functions
  36. IF Lookup Formula
  37. If And using dates
  38. functioning of formulas
  39. I want to set up theatre seat booking system...
  40. Adding column when number exist
  41. Referencing text in merged cells
  42. RE: Excel2003 MAX and MIN with <>
  43. How to do summation of unique counts based on another variable?
  44. Re: Excel2003 MAX and MIN with <>
  45. Hyperlink to more than one file
  46. Sum of a column from nth row to end
  47. Open file if cell date is less than today+30 day?
  48. CF, MACRO???
  49. Calculate 60 days from Start Date - including weekends
  50. Nesting SumIf and CountIf
  51. Using VLookup when text isn't an exact match
  52. formula
  53. formula
  54. How can i import data from a cell in another sheet, into a textbox
  55. Short question on Datedif
  56. Copy/Fill Down in increments
  57. Count if cell value
  58. Concatenate and Multiply
  59. concatenate and multiply problem
  60. automate delete rows without data
  61. How to update multiple worksheets
  62. converting word mailing labels to Excel
  63. Formula Problem
  64. Extract text from cell
  65. Defining cells that macro will change
  66. Copy Data from One Spreadsheet to Another ??????
  67. Automate date & time entry
  68. Forgot password to worksheet
  69. SUMIF Function
  70. Formulas not working
  71. CountIf & multiple criteria
  72. count unique elements
  73. Keep text matching a wildcard spec in replace/substitute
  74. Macro for HEAT chart - THANKS IN ADVANCE!
  75. formula
  76. Maintaining formula consistancy when copying formulas
  77. formula
  78. Finding a Name on a list and returning all matching rows
  79. vlookup or sum product
  80. Referring to specific cell in named range in Excel formula
  81. #NAME Error message
  82. Function Problem
  83. Page Break View
  84. Sum Product based on value
  85. sumif?
  86. Autofill reference series
  87. use other cell information to put formula in current cell
  88. Showing information according to a selection in a drop down box
  89. counting entries
  90. Adding based on multiple criteria
  91. How do I count the number of entries of specifc criteria is met
  92. VLOOKUP to ignore lines which do not meet criteria
  93. Speed of array formula
  94. Carrying out calculations on segments of data from within a workbo
  95. Conditional formatting Excel 2007
  96. Help
  97. How to link two cells and when you update one it updates the other
  98. Question about Sum
  99. Requiring multiple cells to be populated before allowing Save
  100. Week Number - Fiscal Year
  101. how do I stop payroll tax deductions once FUTA limit is met?
  102. Subtotals in a Pivot Table
  103. CountIf Formula
  104. No plus or minus signs to left of subtotals
  105. Pivot Table categories
  106. Moving data from CSV to Excel sheet
  107. How do I insert a counter?
  108. Using Dates in Conditional Formatting
  109. Using solver
  110. Inventory Formula
  111. Linked cells - why '0' when blank?
  112. custom number format code using letters and numbers
  113. vlookup and bring the "font color" of the cell across?
  114. What function or array to use? help please :o)
  115. Can VLOOKUP return a formula??
  116. nested if statements - multiple variables
  117. Count based on multiple criteria
  118. what excel function to use
  119. Average more than 30 numeric arguments
  120. Value error with this formula
  121. SUMPRODUCT Problem
  122. can't find marco button
  123. vlookup with different col_index_num
  124. Sumif And Countif
  125. conditional formatting on sales percentage
  126. How can I calculate the future value with multiple cash flows?
  127. Convert to text
  128. Multiple Table Query
  129. Offset a formula result
  130. Make Columns A&B on Sheet2 always equal Sheet1 table columns A&B
  131. How do I transfer a contact list from Microsoft Excel to outlook.
  132. Percentage according to Weightage
  133. lost alignment tool; how restore?
  134. Coping Cross Tab Formulas
  135. what group for "bug" finds
  136. adding up sums only if condition is met
  137. Need Help With Writing Concatenate Function
  138. Web Traffic
  139. vlookup - find an alternative approximate match
  140. Filling in blank cells with cell above
  141. Excel Formula Formatting - How to Add a STOP Statement
  142. Two Criteria = 1
  143. sumif + right question
  144. Re: Forumla Question for Excel2003
  145. RE: Forumla Question for Excel2003
  146. copy rows to new sheet based on specific cell value
  147. Creating worksheet reports from a pivot table
  148. Re: Forumla Question for Excel2003
  149. Count unique dates within each unique ID
  150. Using the IF function
  151. Pivot Table Report Formula
  152. F Function help! I have two cells!!
  153. Conditional Cell Formatting
  154. Subject: showing cell address' per ans from Ron Coddere - still st
  155. function problem
  156. Generating Functions with "Concatenate"
  157. MAX Function Issue
  158. Match Text return a value from the row
  159. How do pull data from more than one excel wookbook to one?
  160. can't see top of spreadsheet
  161. Excel equation problem
  162. Excel equation question
  163. Multiple Spreadsheet Print problem
  164. Use macro to sort column
  165. 3-Cell Conditional Formatting
  166. Excel UPPER function
  167. Nesting more than 7 IF statements (Excel 2003)
  168. match and display
  169. Simplify formula please
  170. How to find: formulas containing invalid references?
  171. Problem with file link
  172. Deleting Rows based on a Value
  173. References that move down as formula moves across - and vice versa?
  174. round figures
  175. Filtering data from a pivot table to a graph
  176. Vlookup for a minimum value
  177. Making part of a formula a variable
  178. calculate square feet
  179. Date Update on New Page
  180. STDEV in a Formula for Calculated Field in Pivot Table
  181. Formulas--NEED HELP!
  182. How do I find a dash in a cell with numbers in it in excel.
  183. If function
  184. Returning a value when 2 other values are true
  185. TREND and OFFSET
  186. date formatting
  187. Value on horizontal axis
  188. Anyone developed a template for employee span of control?
  189. how can you convert an entry of 1 to first, 2 to second, etc.?
  190. IF function that searches a range of cells for data and provide tr
  191. If a specified cell has any text entered in it, this cell will ent
  192. How can I get a cursor location to use in a formula (e.g. IF A1,"Y
  193. Sumproduct help
  194. Re: How do I remove a flash graphic from a work sheet?
  195. Showing the function in the active cell
  196. RE: How do I remove a flash graphic from a work sheet?
  197. Difference between dates
  198. Re: Function Problem
  199. SUMIFs across multiple sheets
  200. Excel 2007 Formula troubles
  201. officelive for office 2007
  202. Excel Formula
  203. Sorting zip codes
  204. SUMIF or HLookup
  205. Re: Simplify equation
  206. How do I convert a number in Excel such as 1001-1 to 1001-01?
  207. Re: Simplify equation
  208. How to find: formulas containing invalid references?
  209. how to create data cubes in data mining using excel 2007?
  210. RE: Simplify equation
  211. RE: Simplify equation
  212. RE: Simplify equation
  213. countif not finding all the required data
  214. Custom Headers
  215. number to fit the best
  216. RE: Need Formula Help
  217. Date Comparison
  218. Mathematical Integration
  219. Averaging values in column A when certain criteria are met in colu
  220. Is this possible ?
  221. Excel to Word
  222. Index Match Help
  223. Re: Need Formula Help
  224. Re: Need Formula Help
  225. Excel formulas - comparing adjacent cells
  226. conditional formating with dates
  227. Goodness of fit test
  228. Each .5 increases 5% but <.5 doesn't increase anything.
  229. Formula for more than one criteria
  230. Lengthy Vlookup Values
  231. How do I combine multiple tabs into one?
  232. My numbers turn into # signs, when I move to the next block
  233. Copying and inserting lines
  234. How to record time in Excel in military (0730) format?
  235. in excel, pressing shift+ctrl+arrow no longer works? any idea why
  236. SUMIF with multiple variables HELP!!!!
  237. how to calculate productivity over hours spent
  238. Display part of list dependant on Validation list selection
  239. IF and OR Function
  240. Need to display price in $ or £ dependant on supplier
  241. Copy entire row to different worksheet
  242. Conditional format cell containing hyperlink
  243. How to pass variables as arguments of a function
  244. creating summary table of input from other worksheets
  245. How to count cells which contain a formula that returns TRUE
  246. Help!
  247. Count fuction
  248. Trouble merging data in shared workbooks...
  249. the decimals extends after the sum function
  250. Matching data
  251. Finding one word in a Column
  252. A Mirroring Spreadsheet...
  253. Printing a Different Row Heading Mid-way through a Spreadsheet
  254. Counting rows based on the contents of multiple cells
  255. One part number with several substitute numbers
  256. Conditional Format limitations
  257. HS Golf All League scoring help
  258. Applying a formula for daily percentages
  259. .Copy partial value
  260. Decimal point in general format
  261. Formula doesn't copy correctly
  262. compair
  263. Splitting contents of column into 4
  264. print a new page for each group
  265. autofill results appear as "$ -" with no error, why?
  266. Christmas Tree charts
  267. Using Formulas for Data Validation
  268. SAVED CHANGES CAN NOT FIND SHEET WHERE WOULD IT BE
  269. Help with Vlookup and MAX functions
  270. Excel 2003 Conditional Formatting w/ 3 Conditions and a value = to
  271. conditional format
  272. Copy Row if Column A matches between different worksheets
  273. How can I make a sequential number list that will print 1 per pg.
  274. Problem with this formula
  275. Rolling Week
  276. Linking two cells of text together
  277. FInding Min Value with Criteria
  278. Counting unique numbers
  279. Help With Formula
  280. Lookup data from multiple columns/rows
  281. Vlookup based on Drop down fails
  282. Need help to match
  283. how do i add hours on a timesheet?
  284. variable page name
  285. how do i set a column as a month in a function
  286. Find values in table and return row/column name
  287. Count continuous duplicates
  288. copy one row at a time to different worksheets
  289. sumproduct
  290. FORMULA TO ADD ROW
  291. If Formula
  292. When synchronising my Cassiopeia E-125 loses the formula.
  293. Linking to too many pages in a formula, how do I get around this?
  294. Worksheet tab font
  295. Invalid References
  296. Copying Select Repeating Cells in a Column
  297. Re: INDEX useing Dynamic Range
  298. Display Worksheet title in cell
  299. summing up values with in date intervals
  300. Vlookup multiple criteria
  301. Sum formula across multiple tabs and fields
  302. if then statement to return text from cells satisfying condition
  303. Help with Macro for sorting
  304. Calcuate totals based on specific criteria
  305. format for phone numbers?
  306. conversion from 2003 to 2007
  307. IF date formula
  308. Formula as text in cell
  309. Vookup related query
  310. Sum visible negative cells using formula
  311. PivotTable auto-refresh with external data
  312. Many ifs....
  313. Userinterfaceonly
  314. Conditional Format
  315. DCounta doesn't work
  316. Find the last row using 2 to 20 criteria
  317. Re: Creating Contact List
  318. Excell 2003
  319. Extracting week number from Today() function
  320. Count everything in a Column "except"
  321. Send keys with user input
  322. pivot table
  323. HD Family Club -- download HD DVD Movies with rapidshare, megaupload,torrent link ... 100% free?
  324. column of times, such as 2:30, 2:14, etc. how do I sum them?
  325. Is this a bug in excel?
  326. Concatenate with hyphens answer
  327. index/Match Misbehaving
  328. Employee Scheduling Worksheet
  329. How do I avoid #NA result in a VLOOKUP
  330. Convert number to word in indian currency
  331. how do I get a result if one cell is X and the 2nd cell is Y where
  332. Match Function
  333. Find & Replace Help
  334. Count only Letters in cells that contain both letters and numbers
  335. How to sum the 3 best scores for every country in an contest?
  336. Concatenate with hyphens
  337. Formula for summing addresses within a single cell
  338. Help with graphs
  339. area under the graph
  340. NETWORKDAYS ADD-IN PROBLEMS
  341. insert a function so all the cells hat have crown molding in them
  342. Condition Formatting for Tabs
  343. How to keep the drop down arrow on data lists when not selected?
  344. Conditional Formatting if cell is Blank
  345. Count formula across tabs
  346. Hyperlink from one.xlsx cell to another two.xlxs cell & click back
  347. Answers to questions posing more questions in a workbook
  348. Is it posible to jump to or search for a certian worksheet?
  349. 2003 functions no longer functional in 2007
  350. Dates in a Financial Year
  351. Excel Formula Help
  352. Calculating Percent Change - Comparison Result is Negative
  353. Custom Toolbars
  354. Index formula and VLookup w/ Multiple Values
  355. summarizing conditional formats
  356. Looking up a value in a list & returning multiple corresponding va
  357. Formula not including a cell
  358. Is there a Hyperlink fxn - To 'seperatefile.xlsx' - worksheet - ce
  359. Excel Formula Formatting
  360. LookUp/Match Question
  361. countifs/or
  362. Using corresponding value of a Cell in a formula
  363. run rate
  364. Complex if
  365. Vlookup challenge
  366. Double Dash
  367. When Format data with merged cells, How to keep it with 1 header?
  368. Compare sheet 1 column A numbers with sheet 2 column A number
  369. formatting a text file imported into excel
  370. How do I find/replace data in selected cells only
  371. Counting occurance of >0 in two columns
  372. IF and Date
  373. Question for Mr. T Valko
  374. Merging excel tables & more, countif, macro line insert etc
  375. Max if variable begins with
  376. Auto Fill help. Thanks in advance
  377. How do I return a text string when a calculation returns a non who
  378. How do I search a whole workbook using the =INDEX function?
  379. I just had to tell someone...
  380. VLOOKUP
  381. formula errors
  382. excel function
  383. Average of cells that exclude conditional formats?
  384. Combined cells to a singel cell
  385. Freezed margins of page break preview
  386. Problem with calculating date 6 months into the future
  387. How do I change weekends from Sat, Sun to Fri, Sat in networkdays
  388. FUNCTION arguments
  389. IF just STOPS WORKING
  390. Selecting random subset of values from one column into another
  391. I need to add this...
  392. I need to add this...
  393. multiple subtotals
  394. Comparing Tabs
  395. Can I update a date formula only if checkbox changes?
  396. Totalling sequential worksheets
  397. Lookup Help
  398. Repeating Rows at top
  399. Vlookup ?
  400. averaging from different sheets and folders
  401. Averaging two ranges on the same column (excluding zeros)
  402. SUMPRODUCT on filtered rows
  403. Search Function
  404. Conditional Formatting Help
  405. Average of time spent monthly getting DIV/0 error
  406. Re: CountA function - Data Validation
  407. two-dimensional frequency question
  408. Conditional Format
  409. Excel Function
  410. Creating Pricelists from product list in Excel 2003
  411. help with formula...
  412. RE: CountA function - Data Validation
  413. #DIV/0! error with DAVERAGE Function
  414. Excel Office 2007 Password protect worksheet
  415. Parsing text
  416. CELL LOCATION
  417. Hyperlinks - change destination to over 2000 links!!!!
  418. Conditional Formatting Formula?
  419. Compare cells and copy columns after match
  420. using countif in a filtered range
  421. average out of bottom 10 values
  422. values greater than and including
  423. paste linking
  424. paste linking
  425. Adding letters instead of numbers and an additonal criteria
  426. Adding letters instead of numbers
  427. convert
  428. Excel filter
  429. If And statement
  430. Count rows where a specific value appears in any of 4 columns
  431. Could this be accomplished with an if, then statement
  432. Sum
  433. =sumif function
  434. Extracting part of a cell
  435. Adding letters instead of numbers
  436. average from multiple worksheet using if is number
  437. insert 780 into phone list XL workbook
  438. How do I expand a funtion's maximum character length? eg CUBESET
  439. use a function for filtered data
  440. multiple conditions
  441. sorting linked worksheets
  442. Using multiple NOW functions
  443. SUMProduct Part II
  444. excell
  445. Forecast combinations
  446. Convert time to text
  447. adding more data to pivot table.
  448. Time Sheet Formula
  449. Adding the last 8 days of data
  450. Automatically insert date
  451. How do I link any new information from another work book
  452. formula referring to a worksheet
  453. How do you assess the state of a form-checkbox in a logic statemen
  454. Equal Cells
  455. if statement for number of digits
  456. INDEX and MATCH help
  457. SUMPRODUCT, MAX, Few Criteria
  458. INDEX and MATCH help
  459. Pivot table: How do I make a monthly breakdown of daily data?
  460. multi-level indexing?
  461. using the macro in Worksheet function
  462. Auto Formatting
  463. Naming Worksheet Tabs?
  464. Making a "summary worksheet"
  465. Using the value of one cell to refer to another cell
  466. Cell result dependant on a word
  467. the change does not take effect
  468. Conditional Multiply and Sum
  469. filtering to separate upper & lower case
  470. Re: Cell display
  471. Sorting by Number
  472. Re: Cell display
  473. FALSE statement?
  474. Combining several cells into single equasion?
  475. RE: Why does Selection.PasteSpecial toggle Application.ScreenUpdat
  476. Changing part of cell reference in INDEX - MATCH formula
  477. If or
  478. Hlookup a value in a column and display the data 12 rows below.
  479. sumif in a template
  480. Find and Replace
  481. Need assistance with creating spreadsheet to keep track of $ colle
  482. Move cell and maintain reference
  483. Exclude certain text from =COUNTA
  484. IF/SUMIF function
  485. Wild Card Search
  486. Re: Need help with an IF formula
  487. Pull data from different worksheets/tab into one Pivot Table
  488. List any duplicates once - no pivot tables
  489. What would be the most effective way to do this?
  490. SUMPRODUCT
  491. Pivot Table Unique Cnts
  492. Lookup ?
  493. Inserting "true" blanks with functions
  494. How can I fill blank cells in a list with previous filled value?
  495. IFs with VLOOKUPs
  496. Conditional IF function help ??
  497. how could i extract data from another sheet like list box
  498. Complex If/Then
  499. How do I create a function that counts number of cells in a series
  500. Re: Create an ordered list from 2d array
  501. SUMIF formula where the colour of the cell is the criteria
  502. Advanced expiry date calculations
  503. RE: Create an ordered list from 2d array
  504. COUNTIF and similar formulas
  505. setting up a inputbox with a number value
  506. Sum totals
  507. Max Value, Sum Product, Between Date Range
  508. Problem with "IF" function
  509. Blank cell with average formula
  510. Sum with #N/A listed
  511. Blank cell from another page within a worksheet?
  512. MONTH function
  513. Problem with downloaded template
  514. how do I control autofill to do my progression?
  515. return value from table
  516. To combine various cell formulae in to the final cell
  517. atomatically fill in cells
  518. Trying to find which function to use
  519. Paste all sheets into one master sheet
  520. Nested functions using array/range names
  521. "IF" confusion
  522. How would I edit this formula to do what I want?
  523. VLookup vs. Match/Index
  524. recurrence
  525. conditional formatting a cell that has a formula
  526. Vlookup
  527. Inserting formula in the cell below
  528. Inserting formula in the cell below
  529. Re: add zeros to fill in and
  530. Eliminating blank rows
  531. Multiple Criterias to Count for Headcounting
  532. Need formula in excel sending sum over 25000 to another column
  533. Conditional Formatting (Dates)
  534. Need Year-To-Date Sum Function with nested Vlookup and offset
  535. concatenate with arrays
  536. Re: add zeros to fill in and
  537. Re: add zeros to fill in and
  538. calculating moving averages..
  539. Average formula
  540. Matching times and classes
  541. copy transpose function?
  542. Thanks!
  543. Array Average - Multiple Conditions?
  544. select from list and get value from another list
  545. Sorting table of numbers with different place values
  546. Conditional Formatting for multiple cells
  547. conditional formatting
  548. Can you lock cells so data can't be referenced?
  549. Extract number from cell when specific format is found
  550. Conditional Formatting
  551. sumproduct
  552. Printing formulas in worksheet
  553. Multiple returns from vlookup
  554. How to filter a few thousand contacts
  555. Lookup next item with dates
  556. array formula using product funtion
  557. copy transpose and paste error!?
  558. How do I create a formula to turn 2.58 into 2.35
  559. using a defined Name in a function
  560. click a button create an X
  561. How do I sum hours with multiple criteria
  562. UDF's & puzzling recalculation behavior
  563. Another Greater Than Less Than onditional problem.
  564. How do I sum columns separating out the dates
  565. VBA Autohide Help
  566. XL2000 Array Function Problem
  567. Showing latest date in Pivot chart with total for all dates
  568. how to delet the blank rows in whole sheet at a time
  569. Convert decimals into mm in excel spreadsheet
  570. count formula
  571. from a set start date and end date what % will be left in a year
  572. Sum the results of a vlookup
  573. Arrange results in ascending order accross a row
  574. Transposing Array
  575. Transposing Array
  576. Can I keep linked cells between sheets when using tables?
  577. Slow VBA code....Hide/Unhide Loop
  578. If function with 3 different outcomes
  579. Spell Checker
  580. Sorting data in new sheet.
  581. How to Find Data in another Worksheet without activating it?
  582. 12 hour shift timesheet calculation
  583. Formula Help needed?
  584. MERGING DATA FROM SEVERAL WORKSHEETS
  585. Use a formula with 2 arguments
  586. How to add a formula using a macro
  587. List any duplicates once
  588. CALCULATE DAYS PER MONTH BETWEEN 2 DATES
  589. if statement
  590. CountIF
  591. hopefully a simple solution for Macro quesion
  592. WORK SHEET
  593. formula
  594. Question on formula of matching Project Workload vs Resource Capac
  595. Re: Replacing cell referance with value in INDIRECT-formula
  596. COUNTIF Function issue
  597. Comparing Lists of text using colors or by other means
  598. if and vlookup functions
  599. Re: Replacing cell referance with value in INDIRECT-formula
  600. RE: Replacing cell referance with value in INDIRECT-formula
  601. RE: Replacing cell referance with value in INDIRECT-formula
  602. If Then Logic
  603. Concatenate and Bold
  604. an iterative calculation -- sort of
  605. Copying text with more than one line
  606. formula pick up formula from another cell automatically
  607. formula for two worksheets
  608. date to time formula
  609. Range sort with numerical ranking
  610. tab order for multi-range selections
  611. IF and Vlookup
  612. number of week days in a period of time
  613. Macro to calculate, merge, and delete
  614. Excel Delete VB Macro
  615. Worksheet set-up/programming
  616. Select and move two NON-ADJACENT Excel cells simultaneously ?
  617. A Lotto Numbers generator
  618. Extract characters from Right of string
  619. Split a sheet in Excel
  620. Counting text using different criteria & resulting in different va
  621. Lookup and average data in an unsorted list
  622. Lookup values if Value 1 is x or y and Value 2 is a,b,c,d.
  623. confused
  624. # Value error and how to ignore blank cells
  625. Commision Rate by margin
  626. Using Excel Data in Notes Views
  627. SumProduct with dates
  628. Cell formatting
  629. Entries per year
  630. Calculate Revenue based on dates within a month
  631. Help getting 2 formulas into one
  632. How do I delete alternating rows in excel
  633. Count ??
  634. Using a variable in the Range function
  635. Format Change in Shared Workbook
  636. what is the difference between Now() and Today()
  637. (B2-A2)=0; How to get a blank and NOT '0'
  638. Web Query
  639. percentage calculation
  640. # of recent documents
  641. Auto Fill Down Macro
  642. conditional formatting of dates
  643. worksheet formulas
  644. Countif Formula
  645. Determine Most/Least Frequent Date from List
  646. matching from an unsorted list
  647. rounding numbers
  648. making multiple lists from one, with uniqueness
  649. Need to Pull Those that Start with Letter P
  650. Spell Check in Text Boxes
  651. "DCOUNTA-ING" too many items...
  652. Project Time in a year formula
  653. Re: How to start week numbering (WEEKNUM) on a certain day?
  654. Reverse a function to return the array?
  655. Dynamic Range Setup...
  656. Counting results from a lookup
  657. Macro & VB101 and Excel
  658. Date Format
  659. How to do this formula???
  660. How do I split a sheet so I can have different amount of columns?
  661. How to round down a value to the inferior multiple of 5
  662. I would like to change numbers in a cell automatically
  663. Multiple count if
  664. Insert Column, Keep Average range
  665. IF column contains certain text return value of corresponding row
  666. Excel spreadsheet Password is lost
  667. match and extract
  668. Indirect/match formula - array
  669. multi-array sumproduct
  670. =sign(--counta(range)) not working righ t
  671. How do I protect cells or a range of cells in excel spreadsheet?
  672. parsing a full name out into Last, First, Middle
  673. Average of Years employed
  674. Ok how about this formula using days :-/
  675. Help with SUMIF formula
  676. set default value for a cell
  677. countif with 2 criteria
  678. Merging of multiple lists
  679. State names into abbreviations
  680. Differenec formula: Dnt need '0' as a result;Rather have a blank c
  681. I need Help with a count cell text formula
  682. Re: trim everything from left of first underscore in the text?
  683. Re: trim everything from left of first underscore in the text?
  684. RE: trim everything from left of first underscore in the text?
  685. Sum formula help
  686. Count Number of occurences of several texts in a range of cells
  687. Vlookup for a max value ?
  688. Range
  689. Create a text based count with criteria from two differnt workbook
  690. Go To Button on a spreadsheet.
  691. consolidate multiple worksheets
  692. CF help please
  693. CF help please
  694. Can you save each sheet in a workbook separately?
  695. Excel and Citrix fragmentation question
  696. how do I convert sq. meters to hectares in a batch
  697. Countif contains a word in a reference cell
  698. Display text source in multiple sheets
  699. %RSD
  700. Validation Against another Cell
  701. Cells only display a maximum number of text characters
  702. Unhide column if range of cells contain data
  703. Send keys from command button
  704. Conditional formatting using text and exceptions
  705. Re: Formula
  706. How to write a formulae
  707. Formula
  708. Border Cells
  709. Average Function
  710. count if the cell contains a word found in another cell
  711. my data is bundled. how do I isolate in separate cells?
  712. Calculate the first monday of a month in the future or in the past
  713. Calculate workdays for irregular work patterns
  714. How to calculate the number of Workdays for irregular work pattern
  715. customized toolbar issue
  716. char(10) does not work to form a new line in my formula
  717. Need benefit budget projections template
  718. how to add comment in cell using excel 2007
  719. Tracking Active Projects
  720. Can I unstack multiple spread sheets in Windows XP?
  721. How to calculate dates
  722. References to external workbooks
  723. Conditional Sum function does recognise %
  724. How do you make Data move into another cell??
  725. find and delte duplicates
  726. Formular for refrencing two referances
  727. Counting using data from 2 columns
  728. file path displays incorrectly
  729. what is the wrong?
  730. App activate issue
  731. Help with MAX / MIN formula (I think)
  732. Return a Value in Vlookup Q
  733. Formula using data from 3 separate columns
  734. Help with Editing VB (a really beginner question)
  735. Rounding
  736. save as , and dellete botton after saving one page.
  737. Find LAST date when corresponing min value became available
  738. Selecting random names from lists
  739. Hlookup row 5
  740. Validation Sum
  741. Any sugguestion to set up this Calculation?
  742. ConditionalFormatCellValue
  743. Mail sheet template for Excel 2007 and 2010
  744. Validation list from Named Ranges
  745. IF Statement
  746. function
  747. Find numbers in a range that sum up to a specified number
  748. Referencing text from another cell for criteria in functions
  749. Formula corresponding to row it is in?
  750. RE: scroll down today () with weekdays only