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. If Statement to subtract “time” if condition met
  2. Automatically merge mulitiple cells to one cells
  3. Printing
  4. Data Validation
  5. Please Help with this formula...Thanks
  6. Averageifs where subgroups are used
  7. Database in Excel
  8. Import Issues
  9. Finding multiple data values in a column
  10. Add monthly totals of months forward
  11. Using cell contents in Vlookup formula
  12. Working from oldest date
  13. Copying selected contents in one cell to another cell
  14. Cosine of 90 degrees
  15. How create a formula series with series inside
  16. Freeze Panes Button Greyed Out
  17. IF with multiple options alphanumeric
  18. Simple - F9, then K9, then, P9, then U9, etc...
  19. Possibly Too Many Arguments
  20. IRR & Address Formulas
  21. Home ownership
  22. Real Estate Investors
  23. Buy or sell
  24. Sum Column above current cell dynamically using function call
  25. When I try to do something in Excel, why is it greyed out
  26. How do I save multiple worksheets as individual documents?
  27. Date Calculation question
  28. Engineering Functions
  29. Deleting Cell Information Automatically
  30. Retrieving values from another sheet
  31. Adding formulas via macro
  32. Copying Worksheets From Different Workbooks using Marco
  33. Linking labels in a pivot table
  34. Vlookup in a vlookup
  35. Re: Designing master schedule
  36. Conditional Formatting
  37. Repeat Row at Top of Worksheet
  38. formatting colour in cells when one cell contains a character
  39. counting
  40. Conditional Formatting
  41. Finding a single word match in a text string and assigning a code
  42. Blanking cells with formulas
  43. sum two col one of which is a date.
  44. How can I create a page by page yearly diary to record bookings
  45. SUMIF or COUNTIF
  46. vlookup with 2 results the same
  47. Excel2003 (CZ) - funkce Zpět (UNDO) přestala fungovat
  48. Displaying month or year as text
  49. sumif with multiple criteria
  50. Help with a Sum and an Array
  51. function to take info fromseveral worksheets and put into a master
  52. How to update the label of the column header in an excel 2007 table.
  53. Classic Excel 2003 Style Menu in Excel 2007 (Free Download)
  54. Matching criteria and summing
  55. Help with microsoft excel
  56. excel replacing my text
  57. Circular Reference
  58. insert document into single cell
  59. Problem with VLOOKUP function
  60. Array-friendly functions
  61. formula
  62. Simple IF problem
  63. Call popup box with pre-programmed input
  64. greater of two values
  65. Re: Why hyperlink does not work after been copied to another file?
  66. RE: Why hyperlink does not work after been copied to another file?
  67. How to look up a value in a list and sum multiple corresponding va
  68. Formular to count occurence of a number or letter in a column
  69. vlookup help
  70. return the Cell address of a value
  71. Weekending Date w/Less Than 3 days Assoc. with Prior Month
  72. how to fill radar charts with different colors
  73. RE: How do I remove the #div or N/A and make it 0 when using VLookup?
  74. Compare against three columns and paste from a fourth
  75. Add-In Ribbon will not display
  76. Tangents
  77. automatically link cells with a certain result to another workshee
  78. How do I find & replace pieces of a formula?
  79. count cells
  80. Date/time difference
  81. how to eliminate duplicate numbers
  82. DATA VALIDATION/DROP DOWN LIST
  83. Linking combo box to another
  84. Sumproduct help again
  85. IF Formula Porblems
  86. "IF" formula problem
  87. RE: I'm a leaner wiht a headache!!
  88. RE: I'm a leaner wiht a headache!!
  89. Nesting workday and if
  90. Lose relative connection in formula on sort
  91. Sumif based on cell format
  92. Building Dynamic SUMIF statement
  93. Can you have to many arguements in a formula
  94. Alert if the travel activity is after the work activity
  95. Looking up in a table
  96. Create a drop down list which automatically inputs linked informat
  97. Should I trust XIRR or Legal & General?
  98. Date and Time Conversion
  99. Interest and Payment Calculations
  100. Missing Variables
  101. order of opening files with sumproduct returning #REF!
  102. missing data w/ advanced filter
  103. multiple sheet looks up and match
  104. add data in column related to cell in another column - see full de
  105. Formatting text
  106. Using formula-generated figures in excel in mail-merging
  107. How do I repeat rows at the top of SOME of the pages in Excel
  108. #Ref on Sumproduct
  109. Restricting Number of characters in a cell
  110. Using "COUNTIF" and "AND" functions together
  111. multiple sheet lookup or match
  112. Pivot Table Issue
  113. Need to replace one dynamic variable with another dynamic variable
  114. Convert bytes to kilobytes or megabytes?
  115. Variable used in a =SUMIF() function?
  116. SORT/FILTER ISSUE
  117. How can I have Excel conditionally copy a cell
  118. Insert subtotal in a query database Excel 2007
  119. Sum and percent in differrent worksheet and file
  120. Help with year to date comparison
  121. rota calculations
  122. Change workbook TAB text colour in excel Office 2000
  123. Excel 2007: =DSUM not working as expected
  124. Formula to add depending upon value entered
  125. "This cell is inconsistent with the column formula" error
  126. Help with parameter substitution in formula (&value), vbScript
  127. VBA Shapes
  128. Count values in column only if value of another column is true
  129. Small Function Unique Values
  130. MATCH to ignore blank cells in array
  131. Moving data from one tab to other tab automatically
  132. Customizing a dictionary
  133. Search adjacent cells in Column for sequence
  134. Sum formulas
  135. Hide a worksheet
  136. Is this formula possible in Excel 2003?
  137. Translating Dates to a Visual
  138. Is there a character paste limit per cell?
  139. Need help tedious work...
  140. How do I check if a cell is formatted as a date in Excel VB?
  141. Re: Truncate a series of numbers
  142. Re: Truncate a series of numbers
  143. ADODB Connection
  144. Create a complex formula
  145. Can you have a value created by a function replace the function?
  146. calculate percentage of month passed
  147. Mutliply rows in big amounts
  148. date/time average
  149. IF(M2="","",(NETWORKDAYS(F2,M2))+TIME(17,0,0)-F2+M2-TIME(8,0,0))
  150. Select Case ignored
  151. Multiple sheets!!!
  152. Excel - How do I make a cell calculate from another page or tab
  153. How to transpose and concatenate long list in one column?
  154. LOOK UP AND SUM
  155. formula
  156. Running total in blank cells
  157. How do I perform a calculation on a 20 digit number in an excel ?
  158. If and Lookup
  159. Find last column matching criteria
  160. Calculating hr/min format
  161. Advanced Filter Wildcard
  162. Use match function to add different item in Combobox
  163. why does a sumproduct formula return a #div/0!
  164. A little VBA help please: collect row value not column
  165. Circular reference, Indirect, and Sum
  166. File error: data may have been lost
  167. if statements
  168. =IF(ISNUMBER(SEARCH("ELB", and more than one text
  169. Printing a large worksheet
  170. Percentage
  171. Moving one cell with macros
  172. how do i delete spaces in multiple cells thoughout the workbook?
  173. Getting 2 different answers for simple count
  174. Referencing
  175. Re: format of cells
  176. Default page
  177. How do I copy and paste only the sub-total from a list
  178. Re: Formula Help for Novice User - Lookup Option maybe
  179. Need Help to do the following - new to references
  180. Placing a graphic into a doc for use in a data merge?
  181. Why do i sometimes get the answer -1.84741E-13 instead of zero
  182. Prevent Tab from User Delete
  183. sum and if
  184. Question: How many occurences in date range?
  185. IRR, with cash flows in non-adjacent cells
  186. Vlookup v. drop down box for mailing addresses
  187. SUMPRODUCT by Date
  188. Links
  189. Adding multiple numbers in one cell
  190. Hours to Minutes Formula
  191. time calculations
  192. How to copy, edit then paste a macro.
  193. Please explain YIELDMAT function
  194. Hiding tabs for just some sheets.
  195. Conditional Formats with ABS
  196. Paste Link function
  197. sorting using letters , but not alphabetically.
  198. Creating a Function in Excel 2003
  199. Offsetting a formulas result.
  200. Merging Workbooks into Tabs
  201. accounts receivable spreadsheet
  202. VLOOKUP and Concatenation
  203. Pivot table 'Too Many Row or Column Items...'
  204. Formula won't recognize data
  205. IF ISERROR INDIRECT MATCH Formula Question???
  206. Sheet won't reference a named cell
  207. conditional formating adjacent rows
  208. Excell
  209. Yieldmat function
  210. Help with Excel
  211. "If" function or similar
  212. Why is there a plus for eg. =+F39, =+G22?
  213. Normalizing data?
  214. Excel 2007: Custom Filter
  215. formula help
  216. Import values from a cell or a range of cells
  217. Coordinates
  218. Character Encoding
  219. If statement
  220. Determining the Sunday date of the third "full" weekend of a month
  221. How to make a spreadsheet idiot-proof
  222. How to make a cell show average of the last 5 entries in a column?
  223. HELP PLEASE!!!
  224. check data from different cells
  225. Moving Rowes based on Date value with a macro
  226. have B column turn red on conditional formatting of E column:
  227. Complicated!! - Conditional formatting with nested function
  228. How to reference entire worksheet in new worksheet
  229. Saving TODAY function to keep the date accurate. (when it was done)
  230. Format painter
  231. Recurring date formula
  232. text in linked cell (between workbooks) wont transfer
  233. checking two different cells
  234. cursor mvmt w/in Excel 2007 using arrows
  235. How to extract data from one column into two separate columns
  236. Stock Maintence
  237. Sub total
  238. Particulars data Filter from sheet 1 to sheet 2 automatically
  239. SUMPRODUCT across several sheets
  240. Sub total
  241. Total Gratuity Leave Please help
  242. Deleting Rows with a macro based on a date value
  243. Format Cell
  244. Getting a cell to state 1 thing if another cell states something
  245. Unique Footer for each page in worksheet with a page number
  246. Unique Names w/ Conditions
  247. Fixing the date format in a macro or VBA
  248. report.!
  249. Unique values
  250. List Management Question- Combining into one
  251. I am using a macro and it cancels my formula
  252. How do I make GRID LINES print LIGTHER
  253. RE: Total numbers in column where the row cell matches the search crit
  254. Total numbers in column where the row cell matches the search crit
  255. Complex SUM *** Variant of previous post
  256. Netwrokdays in VBA
  257. Two columns Data Validation and Password Recovery
  258. Complex SUM
  259. =IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") add more like "ELB" "FLG"
  260. DGET lookup failing
  261. SUM only Cells where there is text in Another cell
  262. Vlookup Match Problem
  263. Wild Cards in Vlookup
  264. index, sumproduct, or other
  265. accessing a date cell adjacent to an Max field
  266. List Management ???
  267. max-ing excel out
  268. Sort Columns of data at the same time, without regard to order.
  269. Obtain Middle vlaue of text with unknow length
  270. page break with auto sub total
  271. copy an exact formula without changing cell reference
  272. Coloring the row and column numbering bars in Excel 2003‏
  273. Pivot Table from linked spreadsheets
  274. Question on my Case of grouping the SW
  275. Conditional Format based upon if statement and max
  276. Vlookup
  277. How do I group text from cells into categories
  278. PUTTING YOUR OWN TEXT IN EXCEL 2007 COLUMN HEADINGS
  279. Conditional formatting based on Cell Value and another cell's valu
  280. RANDBETWEEN
  281. MRound Formula
  282. Line copy - Not just a simple copy paste
  283. Search for specific text within last non blank cell in a range
  284. Combining If, Vlookup in formula
  285. Why won't target cell data changes trigger formula evaluation?
  286. Is it possible to change the normal excell icon on an excell file?
  287. Is it possible to sort data within a password protected worksheet
  288. linking data from 2 wrksheets using a common cell value
  289. formula help needed
  290. Need reference for max and [#this row] functions
  291. Need reference for max and [#this row] function
  292. referencing a range in Sumproduct function
  293. ISERROR on GETPIVOTDATA
  294. Need different formula in table cells
  295. Average Calculation
  296. count
  297. Extend the number of arguments of a function
  298. Coloring the row and column numbering bars in Exce2003
  299. Combine and display values in range in 1 cell but skip blank cells
  300. Can SUMPRODUCT be made to ignore text
  301. Search for number after specific text in string
  302. Time lines, Gantt charts and auto-populating cells: possible?
  303. dispay numbers as minutes and seconds in excel
  304. Bug when hiding a table column and filtering
  305. Sumproduct - range as criteria
  306. Identifying non-returning formula (blank Cell)
  307. Create new sheet for each row and include header
  308. Convert worksheet string name to date format in cell
  309. Weighted Averages
  310. Formula for dividing work
  311. Synchronous scrolling in all sheets of a wokbook.
  312. Re: Macro help: moving specific cells based upon content
  313. Re: Preventing data input until a particular cell is used
  314. Averaging Times
  315. XIRR versus IRR help!
  316. Percentage Formula in Excel
  317. Sumproduct error caused by too many curly brackets?
  318. Excel 2003 Data Analysis - Sampling
  319. Return Results of a cell based on cell referenced in a cell
  320. Summary Help - Multifunction...
  321. Sum values if date is before today
  322. E-mail Addresses Won't Hyperlink in Excel 2007
  323. Checking one cell, if number is a range then this
  324. Naming Tabs
  325. Data Summary Automation Help!!!
  326. COnfidence Intervals in Multiple Regression
  327. MTD / YTD
  328. If Statement with Wildcards not Working
  329. LOOKUP Function
  330. COUNTIF
  331. Identifying the presence of a randomly ordered text string in a cell
  332. Track Changes - User / Time / Date
  333. RE: Excel Formulas
  334. Text Box - Custom Formatting
  335. Re: Excel Formulas
  336. RE: Excel Formulas
  337. Hyperlink button is greyed out.
  338. Should I save a new query for each report or use the same and modi
  339. Nested IFs and multiples
  340. How do I sequentially number indvidual worksheets?
  341. Resizing cells to fit text returned by VLOOKUP
  342. Basic Percentage issue: HELP!!!
  343. How do I round time down to the nearest half hour?
  344. Count with various type
  345. Is there a shorten way to increase the value
  346. Sum of check boxes that have been checked
  347. How calculate end time with beginning time plus formula minutes
  348. Indirect function help
  349. Automatic filter for unique records
  350. Percentage Calculation
  351. entering data in a row and then tabbing to the next row
  352. If And or If Then Statement
  353. specialized formatting
  354. How to use ERROR.TYPE in an IF function?
  355. Converting Rows into Columns
  356. Formula Issue
  357. Conditional formatting based on character count
  358. Re: ounces to decimal format
  359. turn on right click menu in excel 2003
  360. Re: ounces to decimal format
  361. Maximum value within a time range
  362. drop down
  363. Count most common answer.
  364. Display Current Date & Time in a cell: Everytime I open the workbo
  365. Conditional Formatting with the cell above
  366. I AM TRYING TO STOP BEING PROMPTED TO SAVE EVERYTIME I USE EXCEL
  367. How to Reverse Text in Excel without VBA
  368. In Office 07, how do I format my pivot table data?
  369. Vlookup & exact match
  370. The result of a formula referring to a cell with formula as text?
  371. Highest Date based on a number of criteria
  372. Transfer info to new sheet by date
  373. Count on conditions for two Columns
  374. change the default worksheet to always format formulas blue?
  375. sumifs between 2 specific dates entered.
  376. Conditional Formatting by Date (Month)
  377. Equation Editor & Excel
  378. Empty Cell
  379. how to scroll while in formula bar (Excel 2007)
  380. Returning a value when two columns are compared
  381. Lookup data in multiple cell range
  382. if function, how?
  383. SUMPRODUCT that contains multiple criteria
  384. Over complicated Calculation?
  385. Closing off threads
  386. My Duplicate formula is not functioning as it should
  387. Sumproduct(match range of values in 2+ cols)
  388. Conditional Formatting Pivot Table Excel 2007
  389. how do I add round to a IF statement
  390. how do I add round to a IF statement?
  391. Sum Column Based on Cell Color
  392. auto-insert colon when entering times
  393. need a function (UDF) return X if 2 dates fall between 2 other dates
  394. How to enter a formula in a cell?
  395. how do i make a footer on second page only?
  396. Date Calculation Formula- Calendar days minus Holidays
  397. RE: combining column content
  398. Extracting data from Excel
  399. Summing a range of cells with criteria
  400. Count Format Types
  401. Cell Format Overrides to Date Format
  402. why does Excel convert 63781403840072 to 6.37814E+13 & how prevent
  403. ? IF and GOTO ?
  404. How create a continuous date range: 9/14-9/20/09, 9/21-9/27/09
  405. TAB down then right instead of right then down?
  406. Combine information from two pages, two changing locations.
  407. ? IF & GOTO ?
  408. A specific method for conditional averaging?
  409. How do I - Strip last letter from field
  410. how do i make a sheet number relative in a formula
  411. copy sheets
  412. Vlookup from series of tabs
  413. auto filter on columns
  414. Using Three Conditions in CF
  415. Sharing Data Between 2 .XLS Files
  416. Seperating Text from Numbers in a cell
  417. Finding last used column
  418. delete a spread sheet
  419. Generating date from day, month year
  420. Incremental charges
  421. Can't change part of an array
  422. Project formula
  423. convert number into word
  424. check box question
  425. Formula to find requested number
  426. Highest alphanumeric
  427. conditional formating
  428. Condition Format where no formula present
  429. Find Text
  430. MIN/MAX and Lookup
  431. How do I combine data from multiple worksheets into one master lis
  432. combining column content
  433. Format a number
  434. Using Hlookup and If Statments Simultaneously
  435. columns
  436. Trimming text from the end of cell contents.
  437. Location of a the second biggest number in a range
  438. Extract address data
  439. Vlookup finding subtotals only
  440. How to Shorten a repetitive formula to include more references.
  441. MY INVOICE NUMBER IS IN RED AND IT DOES NOT PRINT ON PAPER
  442. RANK sublist
  443. copying only selected data from Sheet 1 to Sheet 2
  444. Vlookup and #N/A
  445. wild card in SUMPRODUCT formula
  446. MINIMUM
  447. RE: FIND 2nd character in a string
  448. sumproduct help
  449. backing up shared workbook
  450. RE: vba code to select sheet without a name
  451. Re: vba code to select sheet without a name
  452. Re: vba code to select sheet without a name
  453. finding words in the cell
  454. Re: FIND 2nd character in a string
  455. RE: FIND 2nd character in a string
  456. how do i get excel to use data in a table based on the result of a
  457. FIND 2nd character in a string
  458. Data matching
  459. Total Gratuity days to pay
  460. VLOOKUP
  461. Summing #N/A occurrences
  462. Cannot paste column data from one worksheet to another
  463. Index function
  464. vlookfunction help
  465. Excel Dates
  466. formula for adding cells in different rows and different columns
  467. How can I have an access to XL Start folder?
  468. 45 Day Count Down Timer
  469. Vlookup and images placed into cell locations
  470. using strings in vlookup function calls
  471. OFFSET with a condition
  472. How to add a .wdb file to my Excel workbook
  473. Relative worksheet reference for multiple worksheets in a workbook
  474. Count and Sum Functions based on multiple column criteria
  475. Lookup
  476. Using SUMIF inside SUMPRODUCT => complex problem (suite)
  477. If, then, true, false
  478. excel question
  479. Is this for real?
  480. Drop Down List Conditional Formating
  481. Copying a formula containing the INDIRECT function
  482. why is conditional formating grayed out
  483. Using VLOOKUP inside SUMPRODUCT => complex problem
  484. We need to add 1 to a specific field on every raffle
  485. HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE
  486. Report webiste problems here
  487. Copying cells in a protected worksheet
  488. Help with my Lotto code please
  489. Index with multiple values
  490. Comparing the values in two cells, then counting how many differ
  491. Matching check to payment amounts
  492. How to convert imported Access Hyperlinks to Excel and KEEP the li
  493. Too many IF functions
  494. Paired Quote marks in Excel IF statement
  495. Excel - Countif
  496. RE: Extracting data
  497. Need sum of top values in a range based on criteria
  498. Sumproduct - meet multiple criteria from a list
  499. VLOOKUP and MID Function
  500. Fill cells automatically from 2 variables
  501. excel-count a value in 1 column if a value in a 2nd is true
  502. sumif with a lookup formula
  503. Sumproduct using wildcard for month only
  504. Insert Page Number in a cell
  505. Remove duplicates
  506. Mid or Right
  507. Calculate Average and dispaly in another worksheet
  508. Autofill cell reference forumula not working
  509. Return value if two data points match
  510. HELP WITH EXEL
  511. Convert time to a number
  512. Color a row once a "x" is entered
  513. COUNT question
  514. formula help - avtive early
  515. Calculating the difference between 2 percentages (Ratios)
  516. Matching two numeric values
  517. Which is better? LOOKUP or INDEX?
  518. Quarterly inputs
  519. Data Validation List
  520. Deleting (almost) duplicates in Excel
  521. Multiple value if function using dates
  522. Conditional Format for font color using font color
  523. Max function for row with named cells
  524. Data Validation With Date Range
  525. FORMULAR TO INSERT DATA FROM ONE CELL TO ANOTHER
  526. Multiple COUNT criteria, same row
  527. How to properly cross-post
  528. SUMPRODUCT Error
  529. Isolating string combinations
  530. Combining sumIF statements with other functions?
  531. Formular
  532. Automatically insert lines
  533. display a value from Sheet1-A1:A10 in Sheet2-B1
  534. Automatically adding lines
  535. Excel 2003 Counting multiple number entries in a single cell
  536. List comparisons and ISNA
  537. INDEX function (array type)
  538. Counting in Pivot Tables w/o "0"
  539. Conditional Formatting color doesn't show up: 90%
  540. formulas to count dates
  541. Need help with sumproduct formula
  542. How do I write formula to check a range of cells?
  543. conditional if or lookup
  544. #DIV/0!
  545. FULL SCREEN WITH TOOLBAR ACCESIBILITY
  546. ordering a column by incidence
  547. How to find and move a value based on multiple criteria
  548. Display text automatically
  549. I can not create an external link between two Excel 2007 workbooks
  550. How do I export a row of data into its own workbook
  551. Pivot table column help
  552. Simple? View named range from sheet1 on sheet2
  553. Search multiple workbooks
  554. conditional formatting
  555. Worksheet compatability
  556. Excel is crashing when making a pdf of my workbook
  557. How to reverse data of a single column?
  558. How do I average cells that contain #DIV/01?
  559. Display formula on the cell
  560. Countif multiple items
  561. Search a named range
  562. Using lookup function on multiple rows and columns
  563. Subtotal Multiple Columns
  564. Count with two criteria in a second worksheet
  565. CountA or DcountA, that is the question??
  566. Go to cell below last entry in column and total
  567. RE: Extracting data
  568. Rolling date looking 30 Days past
  569. date function
  570. Need Excel count of 1 word if found in multi-word cells of column
  571. Excel Template naming option.....
  572. Converting Text into Values
  573. RE: Extracting data
  574. CountIf Formula
  575. Inserting curly brackets within a formula
  576. Ouch! Inconsistent TEXT("hh:mm") rounding
  577. count the # of times "name" is in E and "x" in F are in the same r
  578. SUM IF question (daily rainfall totals)
  579. SUMIF question
  580. Conditionally Formatting Cells based on Values in a Range (2007)
  581. Subtracting an absolute value
  582. How do I merge all sheets in workbook to one document
  583. vlookup cells thAT are `NOT EQUAL` to a value / text
  584. coefficient of determination
  585. sum cells based upon color of text
  586. Function shows repeating decimal?
  587. cells are automatically dividing each # I put in by 10!!!
  588. To return a blank cell rather than 0% in a vlookup.
  589. Real teaser!
  590. Create a new sheet dependant on values
  591. Rounding in the Same Cell
  592. Vlookup - Update Path
  593. Averaging
  594. avoid Descending Sort putting error cells uppermost in collumn
  595. Sundays
  596. SORT DATA ON A PROTECTED WORKSHEET!
  597. Ignoring #VALUE! errors and MORE!!!!!
  598. Conditional formating
  599. how to use the number format
  600. How to change text/font colour, using formula
  601. will a function do this for me?
  602. SUMIF with "OR" criteria
  603. vlookup with multiple values
  604. How do I turn on Paste Special for linked data?
  605. Drop down list - color coding
  606. vlookup by the lengh
  607. Sending Fax Using Fax Numbers in Excel Spreadsheet
  608. Row protection
  609. how to check for days of the week
  610. Attendance formula for payroll please help
  611. Attendance formula for payroll please help
  612. calculating months between dates
  613. Does Excel have a @grandtotal function like Lotus 123
  614. Help with Excel VBA
  615. calculated fields in pivot tables
  616. Pivot Table Calculate Field
  617. Straight line depreciation
  618. Inserting pictures into unprotected range in a protected worksheet
  619. Creating a function to auto hide rows
  620. Link to word document
  621. Nght shift allowance
  622. I'm trying to include a cell reference as part of an ext. link
  623. Is there a way...
  624. Merging sheets
  625. Return the text before a | in a text string
  626. Formula for elapsed time
  627. Row Height-expand if text wraps in a cell
  628. Using a variable to point to a location
  629. what function to use
  630. How do I get cell="complete" to move user to date cell?
  631. #NAME? Error
  632. If C2 = East AND D2 < 20,000.00 then multiply D2 by 8%
  633. sum across range of sheets for a cost code
  634. Use vlookup to bring back data from second occurrence of the value
  635. Matching 2 columns
  636. excel IF formula
  637. Using Hyperlink Function
  638. Partial background
  639. concatenate dynamic ranges
  640. Total Working hours If
  641. Using IF statements in conjunction with other function
  642. Paste values all cells in a region which refers to out of region
  643. Database Lookup
  644. Countif and sumif combination problem
  645. Find end of column and paste formula in range
  646. Conditional Formatting Error
  647. VLookup with 2 criteria
  648. Re: HELP w/ auto calcualting timesheet
  649. stop for moment
  650. COMBINING TWO COLUMNS THAT ARE CURRENCY
  651. Matching dates to cells
  652. Paste Special Menu
  653. Paste Special Menu
  654. Data Validation & If function
  655. conditional formatting
  656. ctrl+shift+arrow keyboard shortcut issue when typing function
  657. ctrl+shift+arrow does not highlight but ends formula when typing
  658. Auto go to beginning of next row after "n"th cell is populated??
  659. Calculate a value between 2 times
  660. VLookup
  661. 12 month total in Excel - by worksheet - need a formula
  662. Multiple cells for IF function
  663. Sumproduct in Excel 2003
  664. find the cell reference for the next occurrance of entry in array
  665. if one cell were to equal __ what would the value in another cell
  666. Can I run a Query or Pivot Table against this dataset?
  667. help with format change of date part of concatenate formula
  668. Allocated amount rounded to nearest .25 without exceeding total
  669. Comparing columns
  670. Updated Formula question
  671. RE: HELP w/ auto calcualting timesheet
  672. Re: HELP w/ auto calcualting timesheet
  673. Clear recently used file list
  674. Excel conditional formatting
  675. How fix a too long array function
  676. Currency list in Excel
  677. Need a Formula!
  678. text if negative value
  679. Unnamed Macro Error
  680. Lookup Values
  681. finding case numbers
  682. A better way than nested IF?
  683. % formula info
  684. Formula Help
  685. I need to do a calculation based on the values in two cells
  686. Formula help
  687. excel 2003: how do I fix: "Style 'Comma' not found"
  688. Multiple criteria - count if or sumproduct?
  689. Multiple Criteria Sum
  690. SCANNED DOCUMENTS INTO EXCEL
  691. residual plots in multiple regression
  692. Adjust line spacing when printing address labels in Excell ?
  693. Excel Sort Doesn't Work
  694. Mirror Wildcard?
  695. Repeat formula for all cells in whole column
  696. How do I calculate future date after number of days
  697. Lookup an exact Value with a range
  698. Using 2 cell CF conditions from different cells together
  699. Counting Colors on a worksheet
  700. IF Function (Possibly) to Apply a Value Depending on Value
  701. Logical Function
  702. How can I change the formula for multiple cells at once?
  703. number or working days
  704. Count the number of dates less than a given date
  705. getting #N/A when vlookup is a negative number
  706. Calculating number of workdays between 2 dates
  707. Formulas with dates
  708. Re: add leading zeros within a formula
  709. RE: add leading zeros within a formula
  710. Time and the Max Function
  711. =counta() unless row is hidden
  712. formulas copying from sheet to sheet
  713. Data Validation
  714. How to separate text and numbers in one cell or column?
  715. Re: converting a text column to a number column & removing the '
  716. Conditional Formula with Words and different columns
  717. 2 part lookup question
  718. RE: converting a text column to a number column & removing the '
  719. Accessing Other Sheet Tabs from within Excel
  720. Fomrulae to Hyperlink to cell in another tab with the same value/n
  721. Extracting and replacing the first word in a String of text
  722. Sumproduct in Excel 2003
  723. Creating a drop down which causes information to appear.
  724. hybrid formula H&Vlookup????
  725. Nested formula...I think
  726. Does Not Equal
  727. Date Range
  728. Matching dates to cells
  729. Formula
  730. Returning row and column headers of a value
  731. Is there a better way to do this?
  732. same picture different sheet
  733. same picture different sheet
  734. Copy Formula ONLY
  735. How to turn a number range into a date
  736. Countdown days In Excel with conditional formating
  737. Return a Value between dates based on another Value
  738. Nested If problem
  739. Nested If problem
  740. Name Badges
  741. determining running counts
  742. emailing a file
  743. locking formulas in Excel 2007 so users can't change but can vieworiginal formula?
  744. editing a form and emailing without saving
  745. If statement 08/20/09
  746. formula error
  747. Deleting recuring data
  748. XNPV Function
  749. worksheet tabs are cut off and can't see status bar
  750. Another Formula