PDA

View Full Version : Excel Worksheet Functions


Pages : 1 |  2 |  3 |  4 |  5 |  6 |  7 |  8 |  9 |  10 |  11 |  12 |  13 |  14 |  15 |  16 |  17 |  18 |  19 |  20 |  21 |  22 |  23 |  [24] 25 |  26 |  27 |  28 |  29 |  30 |  31 |  32 |  33 |  34 |  35 |  36 |  37 |  38 |  39 |  40 |  41 |  42 |  43 |  44 |  45 |  46 |  47 |  48 |  49 |  50 |  51 |  52 |  53 |  54 |  55 |  56 |  57 |  58 |  59 |  60 |  61 |  62 |  63 |  64 |  65 |  66 |  67 |  68 |  69 |  70 |  71 |  72 |  73 |  74 |  75 |  76 |  77 |  78 |  79 |  80 |  81 |  82 |  83 |  84 |  85 |  86 |  87 |  88 |  89 | 

  1. Excel/Web
  2. create a formula based on cell color
  3. Help on Array and Index function
  4. replace always opens a window
  5. Pop up menus in cells fed by lists in another workbook
  6. Averaging Time
  7. Averaging Time
  8. Moving to a new sheet.
  9. add multiple returns using vlookup
  10. Format issue to linked cells
  11. Calculating the Median Price Sold
  12. conditional format on column based on cell value
  13. Making a new master comment
  14. Averaging Time
  15. Function to take today's date less someone's b-day to get their ag
  16. Averaging Time
  17. how do i get columns in Excell to auto-adjust
  18. average with 2 criteria
  19. I am new to pivot tables..
  20. confining workspace to a limited number of columns
  21. Color of tracked changes
  22. "OR" Function in an Array Formula
  23. ActiveX combobox
  24. SUMIFs for particular cells in blocks of data
  25. Returning Data to an empty Cell
  26. Sumif with Conditionale formatting of a cell
  27. Custom Formatting
  28. Find the First of the Month after 60 days
  29. More Help
  30. Macro - Next blank row
  31. scroll bars
  32. Numbering Worksheets
  33. how to split data where line breaks are the delimiter
  34. Convert time in number of seconds
  35. Calculate the difference between two times and show dd:hh:mm:ss
  36. can i link an exel cell to outlook alarm
  37. Donot allow user to change name of the worksheet
  38. Sorting array function explanation please
  39. VLOOKUP formula
  40. Workbook open event
  41. Complex Formulas possibly using IF
  42. formula to enter data into a blank cell
  43. Calculating an average
  44. Return values from table
  45. Reference the last cell in a column
  46. How do I combine 2 sets of dates using concatenate function?
  47. Left Function Question Help!
  48. counting items within a date range
  49. nested IF statements
  50. Unique Records Help
  51. Vlookup issue
  52. Logical AND with SUM
  53. How do I recover excel 2002 files after a system recovery ran
  54. vlookup
  55. Populate a cell if values in cell 1 and cell 2 match cell 3 and 4
  56. How to count cells that do not contain "-"
  57. Returning data
  58. Formula Help
  59. CountIf cell referencing
  60. Conditional Formating Using Office 2007
  61. Fill down function not working correctly and producing weird resul
  62. Multiple ifs and formulas
  63. ActiveX Combobox and LinkedCell
  64. Hyperlink to another worksheet to a absolute cell
  65. Formula to total text in range, if true to condition
  66. #N/A Error unexplained
  67. Sum Function not working right
  68. Finding the next dayof the week after a certain date.
  69. Excel 2007 - Outline not displaying all nested subtotals
  70. 'TABLE' array function
  71. Text to Columns wizard greyed out
  72. formula Help
  73. IF Function and ignore if
  74. j
  75. Equally combining two unequal groups
  76. data swap
  77. Merging Date Columns
  78. macro confusion
  79. number and text in cell for formula
  80. work sheet
  81. Need possible combinations of 7 unique characters.
  82. how to convert a numeric value in text
  83. Vlookup on long threads
  84. Help with Nested Range counts
  85. Time-table
  86. Filling in a cell based on another cells date criteria
  87. If, Contains
  88. RE: If, Contains
  89. Multiple Conditional Format
  90. Calculation of an UDF
  91. Countif()
  92. Haw to delete or edit Customize List in Option window in Excel
  93. macro to recalculate every 10 seconds
  94. Merge cells time format
  95. Adding a second formatting condition.
  96. Unable to query ASC and JIS function
  97. How I can create a Pivot table by selecting two Different Pivot
  98. How to count the number of letters in a cell?
  99. cell display
  100. Vlookup or IF statement
  101. Comparing 2 tables
  102. How can I change like this?
  103. Need formula and not sure where to start! Matching criteria.
  104. Return with an "OK" if the value falls between -10 and 30
  105. Autofill cell based on todays date
  106. Linking images
  107. Auto Sum returns #REF instead of total
  108. help with INDEX function
  109. future value function for compound interest
  110. Translating a letter to a number within an array
  111. Button will not start macro
  112. Visual Basic language
  113. When clicked, the Button needs to create a number in another cell
  114. Dynamic formula
  115. Don't use cells that have a 0 value
  116. sort by numbers of digits in cells
  117. How to sum number values, excluding data returned #N/A during Vloo
  118. Can I show totals from sheets 2 &.3 on sheet 1
  119. symbol "^" mean when using in a formula?
  120. AutoFill of Numbers
  121. Auto-Hide Rows Macro
  122. =IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1
  123. date after another date
  124. how do I get the percentage of a group of cells
  125. Returning Data
  126. Calculating inside a cell?
  127. Split screen
  128. SUMIFS with 3 criteria instead of just 2
  129. Populating a cell based on a specific date/combo
  130. Webquery
  131. Calculating Dates
  132. "REF" error how can i get it off my worksheet
  133. copying
  134. Calculate toal hours
  135. Argument limitation
  136. Lookup between multiple columns
  137. DropDowns and/or ComboBoxes
  138. ¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656
  139. ¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656
  140. ¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656
  141. ¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656
  142. ¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656
  143. ¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656
  144. ¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656
  145. ¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656
  146. ¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656
  147. ¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656
  148. ¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656
  149. ¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656
  150. ¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656
  151. ¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656
  152. Adding 1 year and keeping time as well
  153. multifunction formula
  154. How do I get a checksum of a range of cells?
  155. LOOKUP, FREQUENCY etc - what's the best way
  156. when adding row in linked workbooks, data in receiver loses a row
  157. Clock
  158. Having trouble getting MATCH to work with a variable lookup array
  159. Conditional format
  160. DATA FOLLOWING SORTS
  161. macros
  162. Moving columns with formulas gives #REF!
  163. Grouping - + and - not showing attop of sheet.
  164. Invalid LOOKUP Function Results
  165. Using the same macro on different sheets
  166. Is there a function or format to remove 'oz' from '12oz' in Excel?
  167. How can I rearrange worksheets?
  168. can't open drawing function
  169. IF Function
  170. multiple formula
  171. How do I extend the range of the data used in a PivotTable?
  172. Blank Cell
  173. Print the first page only of multiple worksheets in excel
  174. find & select
  175. My underlining isnt showing when i print??
  176. Two different criterias in one formula?
  177. Breaking notepad file with 1000000 lines to smaller excel files
  178. freeze multiple columns
  179. UNABLE TO DRAG BOUNDARY IN PAGE BREAK VIEW
  180. how do i reformat text size in all comment boxs to a default size
  181. Link Drop Down Box to Look up Values in another sheet
  182. Name of named formula used in an INDIRECT function
  183. Creating a work sheet
  184. Need to give a letter a value and sum
  185. counting of consecutive days over a certain value
  186. Finance Functions
  187. My formulas will not calculate
  188. Sum X Number of Columns
  189. Aging formula with unknown dates
  190. What do I need to do to perform a sensitivity analysis
  191. VLOOKUP, IF, SUMPRODUCT...oh my!
  192. New Worksheets Macro
  193. PERCENTAGES
  194. macro help
  195. and/if statement
  196. Blank Columns
  197. How do i keep my formatting when linking from one sheet to another
  198. Row # of successful vlookup
  199. Match
  200. match formula question
  201. Nested If Statement
  202. Working with excel sheets
  203. Pivot tables and blank cells
  204. Circular Reference-tax value on total expense
  205. Ratio Function
  206. Invalid Cell Reference error
  207. Excel Question....Deleting Numbers In a Set
  208. Sub - Subtotals
  209. Can i configure excel 2007 to order pictures like excel 2003?
  210. Matrix Lookup Count
  211. Alignment: Center text but Right numbers.
  212. Excel column width
  213. SUMIF for texts
  214. Share Document
  215. Hyperlink Redirect
  216. Individual Validation for multiple values in single cell
  217. Ignore Blank or 0 cells
  218. How do I Lookup next values in Excel?
  219. an error in a formula in annual leave
  220. Age for date
  221. Displaying text.
  222. Excel 2003 unites csv file row contents in a column A with squares
  223. convert higlighted days inexcel calendar to value, then sum
  224. Complicated One -- Get all app versions & sum each
  225. How to convert digits into text
  226. Fill
  227. what it mean by (=$AB$35 )
  228. multiple value lookups
  229. COUNT IF
  230. Sum Every 4th column in a range tied to a control cell
  231. Adding space to postal code in excel
  232. VLOOKUP & non-contiguous table array
  233. instering rows in one worksheet that reflect another worksheet
  234. Method to Capitalize Existing Data
  235. Need help with SUMPRODUCT
  236. Help with a sum formula
  237. truncation of fields inported from access
  238. Entering digits in a cell with numbers already inside cell
  239. Is there a way to sort worksheets within a folder?
  240. Basic formula
  241. Displaying value from two lists
  242. Coding for a specific day
  243. formatting text
  244. Vertical Lines in Cells - Delimited???
  245. 'only created connection' grayed out
  246. HYPERLINK!!!
  247. 1 Shhet
  248. Updateable drop-down menu for an item database?
  249. Using Macros
  250. Selecting Cells
  251. Product & Price lists
  252. Can I do this in Excel 2007?
  253. Save Workshetts as Separate Files
  254. if cell falls within range of number (i.e. 2500 to 4999)
  255. Find data to the Right of...
  256. Multiple Sumif conditions
  257. Do not let a percentage be greater than 100
  258. Split Alpha Field
  259. Convert/rewrite SUMIFS formula to work in Excel 97
  260. toolbuttons
  261. VLOOKUP...help please!
  262. Sumproduct gives #VALUE
  263. Unhiding Sheets
  264. Summing values, x rows deep, depending on a criterion
  265. in words
  266. how to express number "9" to "Nine"
  267. Counting number of cells that match name AND number
  268. Can I Skip a row in my formula?
  269. Login Name and now function
  270. password protect certain cells change
  271. Header or Footer - Reference a Cell
  272. How do I use the excel function "funformula"?
  273. coloring a cell if blank
  274. Formatting an Excel number cell
  275. New Built in Functions 2007
  276. GET QTY in column J
  277. help with formula
  278. Word size for each cell
  279. circular reference
  280. Need help adding hours exceeding 24 hours
  281. How to copy cells from one worksheet to another if the value in ra
  282. Average for times using minutes and seconds
  283. HYPERLINK
  284. Finding second value?
  285. Conditional Formatting Question
  286. Count occurrents based on criteria in different column
  287. Conditional formatting & decimal part of a number in cell
  288. in ms excel how to count the no of cells
  289. Summarising Data
  290. tabs are missing even though 'tools-options-view-sheet tabs' ok?
  291. change data of entire column from small case to upper case
  292. Store sorting argument in Excel
  293. Multiple question requiring asistance please
  294. Advanced Filter how to include columns
  295. Deleting entire row if cell contains "value" - how to review everytime?
  296. Formula - HHHHHEELLLPP
  297. Making a cell change time to hours
  298. Visual Basic Erro 400
  299. Converting Millitary Time to Hours worked and OT hours
  300. Multiplying Arrays
  301. Help with UDF to search through a table
  302. Vlookup in 2007 is now case sensitive
  303. Conditional arrays within SUMPRODUCT
  304. Changing text colors for editing
  305. COUNTIF a cell value is between two numbers
  306. today functions
  307. Use of IF with arrays
  308. help with adding up hours and mins please
  309. Automatic Time and Date
  310. SEARCH and IF
  311. EXCEL CELL MERGE
  312. Eliminating Values from a worksheet
  313. ColorIndexOfOneCell
  314. More conditional formatting...
  315. Using Vlookup where the Lookup Value also uses Vlookup
  316. plus-minus buttons in far left column (1)
  317. Automatic Date and Times
  318. referring to a total in a cell that varies each month
  319. Data trapping
  320. excel functions
  321. Conditional formatting referencing date of expiration
  322. Sort by color: Is there an easy way to sort columns or rows in EX
  323. Sum worksheets - w/o updating formula for new worksheets which are
  324. How to schedule an auto "Save As" of an Excel spreadsheet daily...
  325. Sort Worksheets (without VB)
  326. Trying to calculate end date using order date and lead time variab
  327. Unhide/Ungroup Problem
  328. Forumla to count the number that fall betwee 13-25 in a column
  329. Data pick-up 02
  330. Checking Filled Columns and Adding up value above
  331. Linera fill formula
  332. Check box logic question
  333. Vlookup using a partial text match
  334. How to copy large block of cells but paste into one column
  335. vlookup with offset?
  336. Combining two list of data
  337. Trading On The Forex Market With Forexautomoney
  338. Is this weird or what?
  339. doubt
  340. #num error using IRR
  341. Take a 3 or for digit time and convet it to time in one cell
  342. Formula result not displayin in cell
  343. How can i do a frequency distribution by machine automatically?
  344. SUMPRODUCT formula compare then count
  345. Copy/Paste Greyed out
  346. How do I get a "link-to" cell to appear in upper left (Excel)
  347. Sum if value above is X
  348. Custom Sort Order - Wildcard?
  349. formula references two embedded excel objects in Word doc
  350. count if for more than one criteria
  351. Find Exact Match using INDEX, MATCH
  352. macro to automatically update dates
  353. Working Between Excell 2003 & 2007
  354. removing non duplicate data
  355. I can no longer move from cell to cll with my arrow keys, help?
  356. automatically change the worksheet reference when new sheet added
  357. I can no longer move from cell to cll with my arrow keys, help?
  358. excel formula
  359. Bizarre Custom Views behavior
  360. Transposing One Column to Multiple Rows
  361. conditional formula
  362. Comparing 2 Dates
  363. how do you use formulas in a drop down box
  364. Assigning times to shift
  365. Macros and Formulas
  366. Vlookup with multiple variables
  367. Formula between worksheet tabs
  368. what do the "" mean in a formula
  369. Today() and IF Function
  370. Empty rows count
  371. formula for adjusting price
  372. Copying worksheets with formulas in hidden columns
  373. data lookup
  374. Data lookup
  375. Counting text in a column
  376. Sheet Names
  377. Returning calculation status
  378. PIVOT TABLE-SOURCE RANGE
  379. If, and, or conditional formulas together
  380. "COUNT IF BELONGS" formula?
  381. Conditional Formatting
  382. How to reference or redirect a formula in a base row?
  383. work hours calculation Excel 2003
  384. Advanced Criteria for SUMIF
  385. floor formula features - help.
  386. Conditional SUMPRODUCT or SUMPRODUCT with Filters
  387. DGET function can't update unless linked file is open
  388. Counting unique values
  389. SUM IF SUB TOTAL Problem
  390. Alligning two columns
  391. Vlookup multiple lookup values and sumation
  392. how to give an automatic number
  393. PROBLEM WITH LINKS
  394. Auto Publishing
  395. EXCEL 2007 WORKSHEET LAYOUT
  396. nested lookups ??
  397. Vlookup #n/a
  398. replacing a range of numbers
  399. Problem Maintaining Cell Format After Query
  400. Protection in Tools menu not there.
  401. How can I have a false Vlookup give a blank instead of #N/A?
  402. Conditional format if cell contains formula
  403. MACRO PROBLEM ???
  404. MOVE FROM SPECIFIC CELL TO ANOTHER SPECIFIC CELL
  405. Function that can return the row number
  406. Vlookup, sumif, multiple criteria
  407. Seperate worksheets
  408. Insert hyperlink - Existingfile.. "Browse for" - existing, or web
  409. Conditional format if cell = blank
  410. Vlookup Fixed reference but move on colums Ref#
  411. Delete duplicate lines on spreedsht w/o goin thru the whole thing
  412. VLOOKUP with multiple columns or worksheets
  413. Formulas?
  414. I believe this is a SUMPRODUCT issue
  415. How can I calulate 3/25 x 3,124.11 in excel?
  416. Convert Numbers to Dates
  417. Counting TRUE or FALSE
  418. USE A WILDCARD CHARACTER IN A FORMULA
  419. deleting certain rows
  420. Help with Date calculations
  421. Covert Text String Data
  422. Entering Formulas
  423. For RagDyeR : Lookup in multiple columns
  424. Validating a resultant number against a number
  425. COUNTIF help
  426. How do I create labels of spreadsheets/worksheets?
  427. find the < within 3 rows
  428. summing every other entry in excel
  429. Lookup formula with dynamic sheet reference
  430. Is this possible: =counta(a1:a30) behind "text" same cell?
  431. Countif for more than one criteria
  432. counting different dates
  433. Really need help with formula(Excel Office 2003)
  434. Lookup in multiple columns
  435. convert negative numbers to a zero
  436. Using VLOOKUP with a reference to a different file...
  437. EXCEL: wordcount within cell
  438. sumproduct and sumif
  439. Progress Bar
  440. COUNTIFS Function
  441. IF function
  442. How can I insert data into my spreadsheet without the page breaks.
  443. Copying data and increasing formula
  444. Auto Update a list
  445. how to copy data
  446. Update link value
  447. COUNTIF value columnA > columnB
  448. How can I remove a formula from an entire column?
  449. WORKDAY
  450. Splitting information in cells
  451. Macro Button or Auto Protect Formula
  452. In Need of proper conditional formula
  453. SORT UPC IN ONE COLUMN BY LIKE NUNBERS
  454. Copying rules set on a range of cells
  455. Cutoff score for acceptance
  456. Import data from Access and doesnt recognize numbers in left func.
  457. Rank function with Pivot
  458. Editing a list of names that have numbers- Can i take out the numb
  459. extract date, networkdays and sumproduct
  460. If/Then Formulas
  461. Inserting last non-blank cell into a text box
  462. LEFT and PROPER
  463. now() reformat in spreadsheet
  464. To Count or not to Count
  465. how do I sum columns with cells that contain alphanumeric data?
  466. Re: serial value to date in excel
  467. how to merge a non shared workbook
  468. Key/Legend
  469. MAX & MIN - Can Column Header be returned with these?
  470. caop / paste formula
  471. copy / paste format
  472. Add totals based on more than one criteria
  473. exclude formulas when counting cells
  474. Conditional format; if statement
  475. Help w/ simple calculator formula
  476. Why does Conditional Formatting highlight "n/a" as a number?
  477. Date Calculations
  478. How to do Pairwise comparison in Excel
  479. If formula help
  480. Format Bold - Only Part of a Function
  481. Is Cell a formula or a value
  482. How do I select the column cursor jumps to when I hit end enter?
  483. Here's a challenge...
  484. Worksheet and workbook question
  485. Formula/ Macro that will copy and paste
  486. How do I replace the hyperlinks on many cells at once?
  487. if statement on a pivot table
  488. Go to row number
  489. Nested IFs
  490. Suggestion needed
  491. comparing 2 workbooks automatically in Excell
  492. Count Multiple Criteria
  493. Data base function
  494. How can I calculate the average of a list of time values in excel
  495. Calculating Anniversary years
  496. Find and remove row
  497. How to use number in some cell as a part of other cells reference?
  498. Excel Problem
  499. Data Between Workbooks
  500. Excel help needed
  501. countif on cells with formula's won't work correctly
  502. using SUM to add up only some numbers in a column
  503. Negative numbers
  504. Date/Time
  505. Count Unique Occurrences
  506. Counting from the Bottom Up
  507. Counting dates but excluding weekends
  508. Sumif using Arrays
  509. Copy Worksheet and Exclude Hidden fields
  510. Sums divisible by 12
  511. Apply a heading to two different rows
  512. DGET Function - using a split criteria range? (Excel 2007)
  513. A formula to auto-update a classification ONLY if it goes UP
  514. Using VLOOKUP with partial search values
  515. couting consequetive months
  516. How do you select multiple characters in a drop down list to appe.
  517. Laser Skin Treatment – A Popular Way Of Curing Various Skin Problems
  518. Use the custom filter dialog in a macro
  519. Splitting contents of a cell from one column into 2
  520. Average only the last 3 cells in a row and self-update as added
  521. formula that will reference another worksheets info. same book
  522. Formula Problems
  523. Help with calulating Null fields
  524. Multiple inputs from "Input Box"
  525. Calulate Sales for Previous Year
  526. Table Lookup using two data elements
  527. Fill in rows with Information from Drop Down list
  528. Inventory control
  529. need code for hiding/unhiding sheets using checkboxes
  530. I only Want the Data from certain parts of the col. to be returned
  531. How do I keep the first letter of each word in that column.
  532. Nested If returns error (too many arguments)
  533. Help with displaying data
  534. How do i combine 2 cells contain date in one cell,
  535. Changing groups of cells in Excel
  536. Calculating Time with Date/Time checking in formula
  537. setting up a4 demarcation lines or markers in a worksheet
  538. Summing the best 8 scores in a column
  539. Paste Special
  540. Help
  541. How to replace single cell references with row names?
  542. add up column of figures to exclude hidden decimal amounts
  543. Selecting business hours via date / if function?
  544. Counting dates in cells
  545. what is the best function for counting rows?
  546. help password
  547. Excel Function???
  548. How to add (sum) a row cells with letter
  549. Mon Wed Mon Wed Mon Wed Copy
  550. would like Seperate Excel Windows
  551. Deleting data
  552. How can I sum just numbers in a cell using letters or others symbo
  553. AVERAGE
  554. Promote Your Website 72865
  555. How do I change a minutes and seconds as a 2400 time to seconds?
  556. bedroom requirement
  557. check book auto increment
  558. how to count the total number of employee?
  559. Using an Excel sheet for batch delete
  560. Conditional Formatting Based on vlookup Value
  561. multiple conditions
  562. reconiling spreadsheets
  563. VBA For Excel - Copy Paste Values only.
  564. IS A TIME BETWEEN TWO TIMES EG 12:00 & 8:00
  565. How can I join two formulas?
  566. Can i use the IF condition to import an image or change a cell col
  567. how do i create a cd calculator
  568. How to get qty discount
  569. Picture format
  570. How to return the average of the LAST 3 numbers in a row
  571. Compare Rows and delete duplicate records
  572. Offset formula
  573. COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERATE
  574. Cell value in text box
  575. Question #2 of ???
  576. Excel spin box - no Control tab in Format Control dialong box
  577. If & Count Statement
  578. Computing mortgage APR
  579. if statement when cell is blank
  580. circular reference
  581. Avoid counting #N/A filled cells, or avoiding #N/A altogether
  582. Sumproduct with cells >0
  583. highlight subtotal rows with a fill color
  584. tab key in Excel jumps cursor cells
  585. Try to change font size on home menu it throws me out
  586. Using Indirect to set a range
  587. I need spreadsheet formula help PLEASE!!!
  588. Question 1 of ???
  589. If And Help?
  590. how can i update links in destination workbook when source workbo.
  591. How can I transpose nXm matrix to mXn Matrix
  592. Subtotal question
  593. Pls help with Excel Function
  594. Record dates based on criteria
  595. Can I use an IS function with Vlookup
  596. Extract file name
  597. Counting number of pay period dates between 2 numbers
  598. Putting my Computer in Standby with EXCEL open.
  599. Cleaning Specific Data withing a range from a cell
  600. Another Macro Question
  601. Transferring formulas from older excel versions
  602. How do I convert an excel worksheet into a word document?
  603. How do I create a formula
  604. Data Items go missing once unchecked
  605. Yesterday
  606. Macro help
  607. Challenge with target output
  608. how do i retrieve data from multiple parameters?
  609. Problem using average or sum formulas
  610. Filtering duplicate information
  611. Conditional formatting
  612. What does Show Ink in Excel, Review Tab, comment, do?
  613. text to column
  614. Comparing Lists
  615. simple grouping question
  616. CONDITONAL SUM DATE RANGE ISSUE
  617. Subrange
  618. Formula changes to answer within the cell or some variation
  619. Linking to a graph
  620. Conditional Formatting
  621. Enable Macro message
  622. TYPE function
  623. match error
  624. How can I generate a list of random dates from dates I specify
  625. Help?
  626. How to appy range names to formulas which use single cells in rang
  627. three conditional foramats
  628. Conditional format an entire row based on one cell
  629. Specify target cell
  630. Unable to update data from pivot table
  631. Drop down menu
  632. HOW TO RECORD A MICRO
  633. Count for the same serial of characters
  634. Database price updating
  635. functions do not calculate correctly
  636. IF function with too many arguments
  637. Referencing Error
  638. Adding a blank row after a new record changes in excel
  639. what does this mean (PI-DL>Error1004)
  640. Nested IF confusion!
  641. How do I go into Standby without closing Excel?
  642. Drop-Down Lines
  643. Reducing File Size
  644. match
  645. min in a subgroup
  646. Extracting Data from a string of text in a cell
  647. lookup based on 2 criteria
  648. Another one!
  649. Conditional Formatting of numbers, but not text, in recurring rows
  650. Counting days comparing 2 dates excluding empty cells
  651. link to a cell in an external spreedsheet
  652. Which function?
  653. extract numbers from a string
  654. excel colors
  655. Returning multiple cells
  656. Calculating towards a target number
  657. Vlookup matching conditions
  658. SUM PRODUCT FUNCTION
  659. formula
  660. Impact of many VLOOKUPs in a spreadsheet
  661. Mixing text and alpha in sumproduct arrays
  662. Formula Creation
  663. Excel Worksheet Password Protection
  664. stop macro if cell does not equal zero
  665. Pivot Table Grouping
  666. How do I activate and inactivate worksheets?
  667. how do I unmerge data in a column and distribute in rows?
  668. Excel 3-D Reference
  669. Conditional Format for one cell based on range
  670. Multiple pivot tables, based on same source data tab; disable refreshon 1st tab?
  671. PivotTable lookup
  672. Automatic Selection of Multiple Rows
  673. Percentage of Ownership Formula
  674. Formula for x & y calculation
  675. Add different values that equal 1 on a row
  676. RE: Address of last nonzero value
  677. Difficult Formula
  678. Calculate discount amt with conditions
  679. look for missing element
  680. RE: Address of last nonzero value in a range
  681. Problem Solver
  682. How to name many rows by values in a column on the same sheet at o
  683. how do i create a scroll option presenting a changeable figure?
  684. Subtotal Function is Inconsistent
  685. How to convert all 3d references to normal references in a workboo
  686. Conditional Format based on value of another cell
  687. validation data
  688. How to delete a hundred range names at once?
  689. macro - how to move to a specific cell and repeat
  690. Problem with formula showing in cell
  691. Error: Undefined or non-rectangular name
  692. How do I switch form annual events list to my orginal calender
  693. INCREASE COST COLUMN BY A PERCENTAGE
  694. Re: Function displays but not the result - cause?????
  695. Keeping linked sheets relative... help!
  696. Display Zero only in Selected Cells using a formula
  697. problem: "You entered too many arguments for this function"
  698. Working with Functions on French Computer
  699. Counting colored cells
  700. If Function With A Time
  701. transfering data in another column entering more sorted data
  702. NETWORKDAYS
  703. Lookup best case based on varying input????
  704. Formulas/References
  705. 3-dimensional matrix
  706. VLOOKUP
  707. Vlookup not returning correct value
  708. How to keep a set range in a Search function
  709. Keep Dependent Value While Deleting Precedents
  710. remove duplicate rows from specific data in a column; excel 2007
  711. Rounding Up
  712. adding function to an existing formula
  713. Formula Error
  714. copy down
  715. convert yyyy-ww date to actual date
  716. Compare data from two worksheets and display difference into 3rd s
  717. Counting numbers in an array
  718. How do I increase the font size when creating a drop down list?
  719. column subtotal
  720. SUMIF
  721. Using two formulae
  722. Cross-sheet formula and sort data
  723. Filtering totals - Reps per Province
  724. IF Statement
  725. sort when using VLOOKUP
  726. Excel 2003
  727. formula drag down when using filter in 2007
  728. Multiple Vlookup
  729. precentage formula
  730. How do I create a formula to add to a cell value, up to a set maxi
  731. password protects different worksheets n upload on the web
  732. Re: Lookup or...?
  733. Sort of subsheet
  734. Get vaçues in multiple sheets
  735. return 4 lots of data when a corresponding number is entered
  736. Automaticcly insert rows
  737. update workbook
  738. Formulas showing as correct but not working
  739. Finding a value or the one next to it in a range NOT array
  740. Vlook Up
  741. Shift Differential TimeSheet Formulas
  742. Fill Mon-Wed-Fri dates?
  743. YTD Average Formula to continue on new worksheet
  744. Can Tab name in worksheet change automatically by referencing a ce
  745. My rounding error in a simple IF
  746. Validation question
  747. format color without conditoinal formating
  748. Why would an Excel worksheet scroll at 45 degree angle?
  749. formula to drive plus or minus as operator
  750. reference a closed filed from a cell and formula in an open file
  751. show value of row one based on min of row two
  752. Fill Color If Statement
  753. Copy custom footer across multiple sheets
  754. Create a drop-down list from a range of cell
  755. How do I reference a cell to another in the preceding worksheet
  756. Multiple Fonts in Excel Equation
  757. How can I make an excel doc 'un'-Shared?
  758. Compound Average Annual Growth Rate
  759. Formula to figure an average on a range of cells with an "if" form
  760. Sorting a Pivot Table
  761. How to make up an excel book that I can import other programs in
  762. VLookup
  763. Multi funtion worksheet
  764. Picking a cell that is next to a cell
  765. Calculate flying times using 24hour clock and 0000 general format
  766. Please help me with this function? I am struggling..
  767. FIND function does not return ZERO when text is not found
  768. Summing differences with multpile criteria
  769. How do I place the word VOID across and Excel spreadsheet?
  770. Extracting Data from another worksheet based on user input
  771. How do I add (say 13) working days to an existing date?
  772. OFFSET Formula Question
  773. Formula using worksheet names 2
  774. Dropdown box display only data dependent on another dropdown box?
  775. How do i find a sequence
  776. How can I format a cell to have the same text with a number
  777. Countif - shown blank cell
  778. how do i send an automated email from excel using an if statement
  779. Copying formulas between sheets and keeping original ref
  780. How do I find out date of birth from an age?
  781. Replacing cell reference on multiple sheets in one go....
  782. Logical IF statements
  783. How to protect a cell with conditional format?
  784. smpte time code
  785. Merge & Sort Dynamic Lists w/ Data Validation
  786. Track Changes in Excel
  787. SUMIF criteria
  788. how do i use symbol of degree in excell work sheet using key board
  789. Simple Worksheet Protection
  790. automatically show modified date?
  791. formula to add six months to date
  792. Hyperlink to a chart
  793. Lookup Multiple Values from a variable table size
  794. counting frequency using multiple ranges/criteria
  795. Linking worksheets, but exceptions
  796. How can I password protect a particular column?
  797. Seperating information in a cell
  798. 2 VLookups
  799. Concatenate with leading zeros
  800. How to pull in rows based on Column A data?
  801. using solver question
  802. Tracking inventory in excell or access
  803. Array formula
  804. Problem calculating Using a Percentage
  805. adding an amount to each cell
  806. Proctected cell - Lost password
  807. Sumproduct range changing with deletions
  808. Moving / sharing Macros between workstations
  809. conditional formatting
  810. How to delete a 'return' symbol in cell for data thats been import
  811. Duplicate Worksheet
  812. Setting a minimum currency value
  813. Excel Formula Help
  814. Auto Lookup and Populate
  815. Re: Hide all "except" the visible selected range(s)?
  816. Summing a variable range
  817. If I draw a shape in Excel (say a triangle), can I colour it?
  818. Using lookup formula
  819. INDEX OR INDIRECT
  820. is there a formula for rounding down time to nearest 1/2 hr
  821. Turn off auto sequence in fill down?
  822. please try this
  823. SUM function settings
  824. Printout using MFC
  825. dynamic range and chart - big help!!
  826. Total of a certain currency
  827. How to convert fractions from linear to diminuative in Excel?
  828. Autosum of various cells
  829. compare and merge workbooks
  830. how do i use vlookup and add all the results in pulls?
  831. Need help creating formula to sum tables
  832. Lookup formula & an error to find the match
  833. find and add vaules
  834. edate missing - still stumped
  835. Complex formula
  836. edate missing
  837. Need Help with Formula-urgent
  838. HELP - If and but's formulas?
  839. Using the if function in a formula,
  840. how do i allign worksheet of excel to left.
  841. Lock after entering
  842. SUM COUNTIF problem
  843. SumProduct CountIF issue
  844. Copying and updating formulas
  845. Copying and updating formulas
  846. Copying and updating formulas
  847. Copying and adjusting formulas
  848. Re: Hide all "except" the visible selected range(s)?
  849. Need help with formula
  850. Summation Operator
  851. Conditional Formatting Q
  852. Adding Multiple Excel Spreadsheets To One Another From Saved HTML Pages
  853. How do I append 20 worksheets in single sheet.
  854. Need to add to nested IF
  855. Conditional Sum based on independent evaluation
  856. Re: Chart and date data
  857. Re: averaging in a pivot table
  858. Notes and Coinage for Wages
  859. is this possible ?
  860. % of Subtotal In Pivot Table
  861. index match
  862. Subject: how to convert 112" to 9'4" with a formula in Excel
  863. how to convert 112" to 9'4" with a formula in Excel
  864. Automatically Populating a Worksheet
  865. Automatically populating fields in excel
  866. Can images be incorporated into a lookup formula?
  867. Figure future date
  868. Copy a range of cells repeatedly
  869. Restrict Data Values Allowed
  870. Hyperlink
  871. Conditional Formatting in XL2007
  872. How do I one larger column into 3 subcolumns?
  873. Index/Match Amateur Question
  874. Find & Replace
  875. Hide all "except" the visible selected range(s)?
  876. What formula do i use?
  877. Re: Email hyperlink
  878. Re: Lookup MIN Date
  879. How to check previous cells for same data and return Y/N
  880. trying to use the index function when #N/A can be part of data ran
  881. I need to add one more criteria to this function
  882. Nested IF with >= and <= choices
  883. RE: find a sequence
  884. Excel Page orientation
  885. Re: find a sequence
  886. RE: find a sequence
  887. Re: data analysis/comparison
  888. Countif Range not working
  889. RE: Vacation Calculator
  890. COUNT IF but not if 'X' IS NULL
  891. Add a checkbox to a spreadsheet
  892. How can Excell automatically fill in a default function for a colu
  893. What purpose is the INDIRECT function?
  894. Security Warning Message Bar to update External Links in Excel 200
  895. Cumulative totals
  896. what is the role of *.
  897. Drop Down & V Lookup
  898. Conditional Cell Lock
  899. Need Formula
  900. Delete only specific fill colored rows?
  901. Need help creating a function
  902. IF with Search/Find???
  903. Rounding Numbers.
  904. IF function
  905. Look for duplicates within a range
  906. Two "IF" functions in one cell
  907. IF Formula Not Working
  908. Data/Validate/List
  909. FORMULA, DAYS WORKED TO VACATION DAYS
  910. Activate second macro only after the first macro is run
  911. Another Cool Macro
  912. Another Cool Macro
  913. Excel worksheet
  914. Mann-Whitney U test
  915. Additional Columns past IV?
  916. Difference between 2 cells (growing column)
  917. Using Autofilter to exclude dates
  918. Percentage ranges within data range - help needed
  919. if formula
  920. Min Values minus 18 months
  921. Lookup formula?
  922. skipp blank cell
  923. For Mr. RagDyer please
  924. Analysing data imported from MS Money
  925. Find Function
  926. This function returns incorrect value sporadically
  927. Using LARGE function with criteria
  928. V_Lookup question!
  929. Pivot Table Calculations
  930. Conditional format when text contains using cell reference
  931. SumProduct with optional conditions
  932. Excel PERCENTRANK help
  933. Networkdays to open previous day's file
  934. I Need get work this formula
  935. vlookup
  936. Can I use solver for this?
  937. VBA code to hide blank rows
  938. Sum multiple worksheet sales data by month
  939. Sumproduct calculation for January 09
  940. need help mutiple worksheets to create monthly report sheet
  941. Filter on more than one cells (text)
  942. Formula using worksheet names
  943. macro help to change row colour automatically
  944. Complex cost allocation formula
  945. Counting time
  946. Formula
  947. If conditional + Vlookups
  948. Quick way to change file name
  949. VLOOKUP - MULTIPLE RETURNS
  950. Need help with an IF formula
  951. Identify missing numbers in list
  952. Cell offset issue
  953. Data Base Functions
  954. Filtered Data-Linking
  955. How do you Position WordArt behind data
  956. Formula with multiple variables
  957. Count a range of cells using an IF
  958. Sum Time.
  959. Rounding Time.
  960. How to check previous entries in column for same contents
  961. Løbende nummerering
  962. Need help with this formula
  963. How do I count sets of cells in two columns?
  964. Using a function/formula for copying text
  965. Decimal to Time Format.
  966. Summing Problem In A Pivot Table
  967. Picking up data from workbooks which may not exist yet
  968. VLookup worksheet name
  969. VLOOKUP question
  970. Dates And Pivot Tables
  971. averages on grades, how to input formula when it has a percentage
  972. List of when functions where added
  973. left and right functions
  974. Conditional Format to Highlight the Active Cell
  975. Product - Conditions - Edited Results
  976. Delete row 1 based on condition in cell on row 2
  977. Need button to add rows on protected worksheet
  978. Can a page number be displayed in a cell?
  979. filter in a filter
  980. Need Function for Year-to-Date spent total
  981. Can be here some changes for a faster speed ?
  982. NETWORKDAYS formula
  983. match values in two column and return value in
  984. Averages
  985. Pulling Data from External Worksheets
  986. Conditionnal Formatting
  987. Vlookp-matching names between sheets
  988. Need function that will work in Excel 2003 like "Countifs" in 2007
  989. Determining work hours between dates / hours
  990. putting help text in the animated bubble
  991. formula for unique values
  992. iferror
  993. Add days to a date, but exclude holidays
  994. Determining the text mode from a variety of data types
  995. Excel showing files as read only , when they aren't.....
  996. Conditional Formatting in Pivot tables
  997. Work Sheet Association
  998. Pop Up Message
  999. Min Function
  1000. Enter a User Name When Changes are Made