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

  1. Excel Should Have a History Function.
  2. Cell color when selected
  3. how to turn off design mode
  4. Multiple IF conditions
  5. counting unique numbers in filtered data
  6. I need to make 111-11-1111 into 111111111
  7. Sumif using wildcard
  8. Formula Help
  9. how can i make 2500 urls in an excel file hyperlinked quickly?
  10. This query returned no data
  11. summing data
  12. How can I get a row # to stay when I delete a row?
  13. Another way to lookup data
  14. Auto change defined name ranges on Jan 1st annually
  15. Every 28 days
  16. help with vlookup spreadsheet
  17. Conditional Formatting
  18. Formula with mulitple condtions
  19. How can I use Goal Seek in multiple cells?
  20. alt+enter does not work
  21. How do I display contents of an adjoining cell?
  22. Rows to Repeat at bottom
  23. getting info into a new tab and changes when entering in other tab
  24. Newbie: worksheet function help
  25. Trying to make multiple formula cell
  26. Condition sum
  27. anybody?
  28. Freezing Autofilters
  29. There should be a keyboard shortcut for fill color in excel
  30. Matching and aligning columns
  31. need Lookup table to return null or zero
  32. Conditional formattind with dates
  33. question
  34. nested formula
  35. Using XML
  36. Statistics using dates in excel
  37. Is there a "concatenateif" type function? (>30 options) in Excel
  38. Saving as web page v publishing a worksheet
  39. Count Intervals of 2 Numeric values in same Row and Return Count across Row
  40. function - if
  41. Any cell containing formula seen as data instead of formula
  42. yearfrac
  43. if then statement
  44. I want to customize a text depending of anwers in a lookup table
  45. errors in worksheet functions
  46. Matching Multiple Sheets
  47. Run Time Error '1004'
  48. Excel Help!!!
  49. would like help in Excess
  50. Same Content, 2 spreadsheets with different size
  51. How do you "freeze" an excel worksheet?
  52. Is this possible......?
  53. How to count how many cells a linked cell group occupies
  54. find the lowest value in a row and add a number to it
  55. Using min and max function XL2002
  56. Need sorted validation list
  57. HOW CAN I LIMIT QUTITY OF LETTERS IN A CELL?
  58. return a blank cell
  59. Copy a formula down a set number of times
  60. Calculting SUM of cells with IF functions inside
  61. Newbie: worksheet function advise (huge please)
  62. Excel Help!!!
  63. smart tags
  64. copy-paste as Values automatically
  65. Excel error message ???
  66. INDEXing Question
  67. AVERAGE more than 30 arguments?
  68. Excel
  69. Sorting help
  70. Using Count function with a conditional range
  71. =today()
  72. Countif, Index, Match... not sure which to use
  73. Validation - Weekend Or text
  74. Spanish/english Formula Equivalences
  75. Formula returning #N/A Error---why???
  76. index,match,match on un-sorted data
  77. Need Help
  78. Worksheet and Word
  79. Mixing up the arguments
  80. cumbersome sheets on Word
  81. nested formula with if condotion
  82. Copying Data
  83. Advanced unique cell count with multiple conditions ... help!
  84. I PUT A FORMULA IN A CELL BUT I DON'T GET NUMBERS BUT THE FORMULA
  85. quick way to copy-paste a formula linked to cells in another file
  86. now() sumproduct.
  87. An Excel Formula Question
  88. transferring files
  89. How do you unlock a pivot table on a protected excel sheet?
  90. removing a space from starting of the text
  91. Searching
  92. Apportioning revenue
  93. how do i combine three columns in excel.
  94. count cells in a coloumn with letter x in it
  95. Function To Convert Liters To Imperial Gallons & Vice Versa
  96. How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied?
  97. Custom Number Formats
  98. hOW CAN I CONVERT NUMERICAL POINTS INTO A LETTER GRADE(SCHOOL)
  99. How do I create a number format mm:ss:th (tenths and hundreths)
  100. insert two formulas one cell
  101. How do you make a countif formula with 2 or more critera?
  102. Excel won't save
  103. Permutations
  104. Permutations
  105. Conditional Formatting
  106. SUMIF help!
  107. a unique cell value returns multiple cell values from another shee
  108. how do I make single character as a variable in an array
  109. Saving as a web page
  110. How do I make FORMULA TO SOLVE CURVE OR 2ND ORDER EQUATION?
  111. I TELL A CELL =B1 BUT I ALSO WANT IT TO TAKE THE TEXT COLORS
  112. Permutation in excel
  113. maxium worksheet on a workbook?
  114. Apportioning revenue
  115. Advanced Filter is grayed out
  116. Re: Traffic needed. Can anyone help?
  117. return value based upon another
  118. Sharing Information Between Workbooks
  119. Pivot table page filter not accepting multiple values. Workaround?
  120. sharing entire columns
  121. formula ignores last infor - please help
  122. HOW DO YOU ADD & SUBTRACT IN ONE COLUMN
  123. count cell if value present in every other cell + criteria
  124. Excel 2000 Question
  125. VLOOKUP - computed go to
  126. How do I use Excel to do a Gage Repeatability and Reproducibility.
  127. Converting cell ref. w/num to currency
  128. Problem with nested logical formula.
  129. Insert New Row without shifting formula
  130. A borrowing dvd spreadsheet
  131. "B/."
  132. HOW DO I CHANGE QUERY DATA TO A DATE RANGE?
  133. how can I match numbers from two columns?
  134. how can I match numbers from two columns?
  135. New Worksheet
  136. Advanced Filters
  137. Interrogating cells by cell formatting
  138. y i cannot solve it ?
  139. Help please
  140. How to set a column to accept only a specified number of digits
  141. bahttext
  142. Straight forward idiot question!!!
  143. Help me!!!!!!!!
  144. How do I create conditional formatting to track due dates
  145. Index and Match Help Needed
  146. Prevent entry in a column
  147. Excel Macro Hide
  148. simplify a vlookup function
  149. Importing csv file all data is in first column
  150. How to sum cells with a certain letters sequence
  151. Include Subtotal in SumIf
  152. Req: How to create multiple mutually exclusive filters
  153. adding lots of cells from different sheets
  154. CONVERTING TIME (DAYS) TO ONTHS,YEARS, ETC.
  155. Returning Descending Values
  156. Array Formula Calendar
  157. feet and inches
  158. Excel Function
  159. Last cell entered
  160. Return Value
  161. Pulling info into another sheet
  162. Conditional SUMIF
  163. date in file name
  164. How do I change a range name back to the underlying data range?
  165. combine 2 columns
  166. IF formulas
  167. Range of Cells to create body of email
  168. Division By Zero
  169. Vlookup formula - Excel Version 2002
  170. Formula format for Count or Countif funtion with two criterias
  171. Is there a way to stop fractions from being simplified?
  172. How can I sort check boxes in excel?
  173. Excel-read a table
  174. How do I clear the contents of one cell from another cell?
  175. How do I rename the A B C cell range along the top of excel
  176. excel crashes when I email
  177. cell on one page equals cell on another page in excel?
  178. Comparing columns iin 2 sheets to generate one
  179. Count and Count if funtions
  180. have a calendar pop up in a cell to pick & insert a date in excel
  181. Countif statement
  182. Just need to know what type of formula i would use for this
  183. Can Excel2002 determine if a calculated date is a business day?
  184. Can a date be used for conditional formatting?
  185. How do I display more than one match in a Index/Match formula?
  186. percentage increase
  187. Sumproduct..help please
  188. IF Statement - Excel Version 2002
  189. Can I put more than 65536 rows in one Excel sheet?
  190. enter month end date
  191. format optional parameter
  192. Need help w/dates
  193. Amount of Increase of Wages
  194. Formula
  195. If functions for dates
  196. Is there any easier way to do this formula?
  197. radio button help
  198. real-time countdown
  199. What is ROW(INDIRECT("1:40")) doing? (array formula)
  200. Excel, renaming columns
  201. Scenarios
  202. Position of a cell in a range
  203. Return value of the cell to the right...
  204. Delete Define names across workbook
  205. spell check excel
  206. How do I show a timestamp when an adjacent cell changes in value?
  207. Display the results not the formula in the task bar
  208. Budget
  209. formula for cell merging
  210. How to insert a barcode into an Excel sheet cell?
  211. is there an easy formula to creating a golf skins game
  212. hyperlink
  213. Parsing 124A into 124
  214. Parsing 124A into 124
  215. Getting value of Option button
  216. Coloring Active Cell
  217. Please help!
  218. Looking up text - help
  219. formula for debits and credits in EXCEL spreadsheet
  220. How do I repeat a value in a pivot table in Excel?
  221. radio button help
  222. How do I eliminate the leading zero when concatenating?
  223. Is there a way to isolate individual cells?
  224. Counting unique records with additional criteria
  225. VLOOKUP loop multiple times
  226. Match/Index return #N/A
  227. Help with a function
  228. How do I identify cell color for comparison?
  229. Automatic update to cashflow spread sheet
  230. Macros? drop downs?
  231. Advanced IF function
  232. Excel 2003 Mouse Right Click
  233. countif date range
  234. my date range does not work in an = ifsum
  235. IF #REF1 = ERROR then #REFBLANK
  236. i want to calculate the houers of workers 21:00 - 05:00 =8
  237. holiday planner
  238. How do I display a formula on the worksheet
  239. LOOKUP(?) Challenge
  240. Protecting Macro's
  241. Protecting Macro's
  242. Excel should let me change case in the cell the text is in.
  243. How do I delete a drop list button
  244. Cellphone tariff checker
  245. macro to hide columns
  246. linking data from one workbook into another
  247. IP Address in cells
  248. how to change a formula for a large group of cells
  249. AutoSave: How can I get it to save every 5 minutes & NO prompt?
  250. VLOOKUP across merged cells
  251. Find 7....
  252. I need to protect cells that contain formulas but on a huge scale.
  253. Database functions should use criteria in formula, as 1-2-3 does
  254. Calendar 1st month ok but 2nd to 12th how.
  255. date ?
  256. autosave
  257. how do i create a formula for selected range?
  258. Help with averages please
  259. array formula problem
  260. Data Automation Transfer
  261. Improrting Text file to a matrix when things are not constant.
  262. calculating entries
  263. Is there a macro which adds selected/highlighted cells?
  264. problem with print data in the all column
  265. if (and) question
  266. COUNTIF and multiple conditions
  267. how to do it without rounding off
  268. Re: Calculating p-value from Fisher's Exact Test
  269. any function or mechanism to get in a cell the name of the sheet?
  270. calculation with minutes
  271. How am i able to populate a sumation for multiple sheets
  272. Counting by multiple criteria
  273. convert dates to number of days
  274. Print "Landscape" in Explorer
  275. password
  276. use keys instead of mouse to use the drag function
  277. Autofilter number of records
  278. Link not updated everytime spreadsheet opened
  279. sumproduct resulting in #N/A
  280. How can I round up a fraction?
  281. how do i tranpose one row to multiple column?
  282. CountIf Question
  283. Summing a Range Omitting the Occasional #N/A
  284. Extracting integers from a text string.
  285. SUM Querie
  286. How do you have the file path print on all pages?
  287. form on one worksheet and the list on different worksheet
  288. How do I calculate and display ratio ( format 3.5:2)
  289. Networkdays
  290. I can't get the Erlang formula in Excel 2002 to populate...help
  291. How do you randomly sort a RANGE
  292. Help with vlookup formula
  293. Logical Function Question
  294. return a value based on a range
  295. Any tips besides ALT+ENTER?
  296. Indirect Range
  297. SUMIF function with 2 conditions
  298. Need to calulate a sum for once a month X #days X #times used per.
  299. visual basic
  300. Apportioning revenue
  301. need to show when date is past due
  302. pasting formula doesn't work
  303. VLOOKUP results on last names
  304. conditional formatting
  305. How do I create a unique identifier # when open excel file?
  306. Can I use Excel to match text data from 2 separate columns ?
  307. Copy formatted in several sheets of a workbook
  308. Is it possible to use a wild card in a =COUNT(IF equation?
  309. percentage
  310. what is the maximum no of formula's in 1 spreadsheet?
  311. cannot delete contitional formatting
  312. Most simple formula to calculate date+ 30 months?
  313. summarize data sheet
  314. simple
  315. Does 2003 excel have training on V Lookup
  316. Get Past the 7 Nested IF limit
  317. how do I hide data elements in pivot in excel 2003 ?
  318. Sum unique with conditions
  319. Find data in columns, then place in rows
  320. macro to hide rows if cell is blank
  321. dropdown in excel
  322. dropdown in excel
  323. repeating functions
  324. Database type formula
  325. how can I eliminate the first 3 characters from a cell
  326. How do embbed a cell within a sentence
  327. How do I insert OR in imbedded formulas?
  328. countif
  329. cell color
  330. sum values in a data group
  331. VLOOKUP 2 text columns
  332. Sumif and base it on font color of cell
  333. Excel
  334. Text won't wrap if row height is over 200
  335. Need Elapsed Time Help
  336. repeating a character across the width of a column
  337. column from ABC to 123
  338. Re: List of Names, Dates, Durations ...
  339. Error when opening a saved worksheet
  340. keeping certain values the same when copying
  341. Convert SERIAL date back into dd/mm/yy format?
  342. vlookup to provide row reference instead of value
  343. Re: GREATER OR EQUAL TO BUT LESS THAN Problem using Sumproduct
  344. How do I calculate the difference between 2 dates (m,d,y) ?
  345. Data range to names
  346. SUMif or SUMproduct across multiple worksheets?
  347. COUNTIF doesnt work!
  348. vlookup with more than number to be retrieved
  349. conditional formatting
  350. Random numbers generation with conditions.
  351. how can I combine multiple worksheets into one?
  352. Excel-comments entered by users disappear in a shared excel-sheet
  353. Simplifying array formula which evaluates as error.
  354. IF + AND string - Help!
  355. random number function
  356. decimal to binary conversion
  357. ROUNDING
  358. IRR
  359. cell shading
  360. How to create list on another tab by selecting qty from big list?
  361. Create different workbooks from only one workbook
  362. Changing orientation of pages
  363. random number generation
  364. Remove last character of text string
  365. How do I change fill color in excel based on data in the cell
  366. how to display remaining rows as blanks
  367. drop down list (repost from miscellaneous)
  368. How do I add a cell with a label behind it
  369. How do I retrieve deleted information from an Excel worksheet?
  370. countif problem
  371. days caculation
  372. Sum Dates
  373. Pivot Table Question
  374. Rounding Data Question
  375. Count names in column once
  376. Update Query (minutes into hours)
  377. how to delete unused footer dialogs in excell
  378. Make new column using partial text in another cell
  379. Pivot Table data source "data source contains no visible tables"
  380. dates in year
  381. how many if statements are allowed per cell?
  382. allow multiple users on excel spreadsheet
  383. daily output list of employees
  384. EXCEL - Auditing - TRACE to show source from another page
  385. prove/audit SUMPRODUCT?
  386. How do I transfer a keyboard function key to a terminal emulator?
  387. EXCEL - LINKS cannot easily get list of all links & names in book
  388. Problem with dynamic ranges
  389. smart tags
  390. Mode() & Large()
  391. Reference the document properties in a cell
  392. Nested If's
  393. SUMIF not working #VALUE!
  394. Excel formula
  395. Cell Format Changes When Data Is Entered - Not Conditional Formatt
  396. Why do my formulas work in some cells but not others?
  397. IF functions
  398. Excel Worksheets
  399. adding numbers with a label
  400. Countif function
  401. how to creat a selection pull down window?
  402. Help with dynamic sum formula
  403. Inputting SAME formula within EVERY (ALL) Worksheet
  404. How can I populate an Excel cell based on the data in another cell
  405. vlookup
  406. conditional formula
  407. Vlookup
  408. removing everything from the left after 10 digits
  409. How do I read info from different worksheets into a summary sheet?
  410. Excel 2003
  411. excel worksheet function
  412. Autofil a cell in the same row.
  413. What is wrong with this formula?
  414. HOW DO I REMOVE MARKERS IN A COMPLETE COLUMN?
  415. how to protect a word art in excel from edit
  416. opening different programs with excel macro buttons
  417. Match
  418. add a row after every unique number
  419. Leaving a cell blank. Not NA(), not "".
  420. How cell ranges are handled by worksheet functions/row column matc
  421. maximum value and associated labels
  422. reverse text
  423. Add formula based on a fixed number
  424. vlookup error - recognition of value
  425. Generating truly blank cells
  426. worksheet print format
  427. Drop Down - Jump to selection
  428. I have a question regarding countif formula.
  429. summing subtotals
  430. return significant digits of a cell
  431. How do I use COUNTIF if I am combining 2 columns?
  432. can you create a macro to compare two different doc side by side
  433. select two cells from workbook and have them join in another workb
  434. % of calculated field in pivot table
  435. Lookup values
  436. How do I lookup two cells and return a third.
  437. how do you add in a new function?
  438. Print other worksheet by changing a Letter/# on another page.
  439. using last available row in a formula
  440. using last available row in a formula
  441. How do I calcuate an IC50 from analyze it?
  442. Help with lookup function
  443. how to do a correlation of numbers?
  444. Assigning a cell the value of a cell in a range
  445. Data Validation
  446. Value_if_true
  447. How do I use the TODAY function with the SUMIF function?
  448. How do Multiply whole numbers by decimals
  449. Copy and Paste
  450. Using returned values as part of another formula
  451. How do I add dates (mo/day/yr + 6 wks) in Excel ?
  452. Calculating Dates not always working
  453. Additional Sumproduct Criterias
  454. Every time I try to use EOMonth I get #Name?
  455. find and copy
  456. Multiple line deletion in excel
  457. IF FORMULAS
  458. How can I open an excel spreadsheet if I forgot the password?
  459. #value!
  460. what happens when the right shift key is held down for 8 seconds?
  461. updating one spreadsheet with another problem
  462. Newbie: Help with OFFSET function
  463. Function giving Error
  464. sumif function
  465. Can I use IF statement with a formula?
  466. count number of cells
  467. How do I sum with 3 reference columns?
  468. tools helping understand calculations
  469. addind a new row
  470. How do I delete the formula but keep the results
  471. how do I sumif using 3 reference columns?
  472. HOW TO SUBTRACT A YEAR+MONTH AND SHOW DIF IN MONTHS?
  473. Transpose and order array numbers
  474. Need formula help please....
  475. MIN/MAX functions and reporting from a different column
  476. Weighted Average Standard Deviation
  477. If
  478. formula for blank cell
  479. Format Telephone Cell Range
  480. Can I make a formula in Excel to display result in same cell?
  481. ISERR
  482. reset to zero
  483. Pull-down text in a cell
  484. how do you calculate the 5th square root in MS Excel?
  485. CountIF and changing ranges
  486. SUMIF function in "Price quote with tax calculation" templae
  487. Which function should I use to ....
  488. help!
  489. Help me!!!
  490. countif challenge
  491. Formula to extract a phone# from a cell of text (eg classified)?
  492. if - then dates formula in differant cells in other worksheets
  493. How can I remove hidden empty text cells from Excel?
  494. Count Intervals of 1 Numeric value in a Row and Return Count down Column
  495. In excell 2003 I select a cell and try to refill with any color
  496. Allow the use of the fx wizard within the fx wizard for nesting
  497. How to copy worksheets
  498. how do I set up excel sheet for meal break down cost,labor,meat
  499. Index - Offset - Match Issues
  500. Adding a Single Cell total from Seperate sheets
  501. function to fill all days of month to end of month
  502. How do I sort a column of computed variables in EXCEL?
  503. How to return top 5 scores?
  504. Sumproduct
  505. Calculate terms in a Series
  506. how do I sum using 3 reference columns?
  507. Re: headers across printed pages
  508. optimization plug-in for Excel 2003.
  509. Excel should let me switch between worksheets using ctrl-tab
  510. Tab Color from cell value?
  511. Criteria - Automatic Change Font or Fill Colour
  512. Finding data by dates
  513. Range function
  514. How to go back to last selected cells?
  515. Protecting Multiple Sheet
  516. Hide/unhide
  517. Validation to force entry in a cell
  518. Time calculations Urgent please help
  519. Automatically incrementing number for each print
  520. why does undo feature not work after value entered in cell in exce
  521. Fourier Series
  522. TOTALS
  523. how do i transfer a spreadsheet list of names onto an document
  524. help with sheets
  525. Finding (Multiple) Highest Values in Column
  526. CONDITIONAL FORMAT
  527. Cell change
  528. EXCEL - need help with IF for dates on schedule
  529. with Autofilter on, display count results in lower left corner wit
  530. Why is worksheet being saved as scrap? why does it have the .shs?
  531. how can i get formulas in excel to copy and paste?
  532. Populate multiple cells using the same reference
  533. Help, need to make field go red or green
  534. How could I create an outline of my drivers hours on Excel?
  535. brackets { } in excel formulas
  536. Combine cells
  537. Cell Format
  538. How to select a range whose name is entered in a cell.
  539. External Data and Pivot Tables
  540. INSERTING AN OPTION BOX
  541. filter unique data using functions
  542. Is there a way to protect individual cells in a worksheet?
  543. Concatenate cells with carriage returns
  544. Concatenate columns with cell data containing Carriage Returns
  545. Link Worksheet to other worksheets
  546. How can I remove cell reference when calculating outside of the pi
  547. Replace a number with text
  548. Looking up a value from an array table
  549. Combo Box
  550. How do I purge data in Excel 2003
  551. pulling numbers from hhh:mm:ss
  552. giving points by a result (function)
  553. Lookups
  554. How do I use an if statement with Find and Replace
  555. Conditional Formatting - Formula based
  556. =SUM((B7+2),IF($D7>0.Workday,($D7+E$8,Holidays!$C4:$C11$),''''))
  557. How do I calculate an employee timesheet in Excel?
  558. PERMUT function
  559. Find and match totals Genius Req.
  560. "Average" function query
  561. Footer
  562. How do I automatically drop totals from one worksheet into another
  563. Find and match totals Genius Req. this should be easier to read
  564. conditional formulas
  565. copy rows meeting criteria to another worksheet
  566. Pull data from yyyymmmmdd.xls
  567. Why are lines scrambling in my excel worksheets?
  568. looking up figures in a column and selecting next highest match
  569. count cells that contain text entries
  570. removing digit or calc LEN fields
  571. Removing Volatility
  572. format row of cells to highlight least amount
  573. Security Certificate
  574. Multiple team "All-Play" Won, loss, tie records
  575. Function Vlookup, Match or Index?
  576. A general question regarding Financials Formulas in Microsoft Exce
  577. Function Vlookup, Match or Index?
  578. Formula does not show as I entered it.
  579. Can I have multiple pages for a Hyperlink
  580. what is maxdiff?
  581. How do I sum within a set time frame from the current date?
  582. produce a formulate to produce assigned seats for dinner
  583. Function
  584. How to display selected table entries from another worksheet?
  585. copy page setup from worksheet to another within workbook
  586. Conflicting date ranges
  587. Generation of random numbers and sum of those with a condition
  588. Is it possible to use some pictures in an IF function?
  589. Evaluating Today() function only once in a worksheet
  590. How to calculate Date & Time differences
  591. How can I add a new formula to Excel formula list
  592. word count in Excel
  593. RE: How do I get info from a cell based on criteria from another cell
  594. Keyboard shortcuts for time in Pocket Excel
  595. excel to powerpoint
  596. Sumproduct
  597. Automatic Totals/Coloured Cells
  598. MATCH, INDEX, LOOKUP - Help!
  599. Can this be simplified
  600. Sumproduct
  601. Grades
  602. cell shows 0 when referenced cell is null
  603. Working in a Worksheet that has protection on
  604. How can I break values apart that are in the same cell?
  605. LOOKUP Help!!!!
  606. Conditional formating
  607. INDIRECT and Named Ranges referencing closed workbook
  608. add 1 count to a column of numbers
  609. Comparing Columns
  610. How do I change all cells to Proper text in Excel
  611. My worksheet doesn't display correctly
  612. Need an Expanding array formula
  613. Plotting a binomial distribution formulae in excel?
  614. Using ABS
  615. Fill down
  616. Match or Index Question
  617. Edit / Move or copy sheet stopped working in Excel 2003
  618. Hyperlinks
  619. Relative Hyperlinks are not saved correctly
  620. Count number of values
  621. Using a Cell Value in another Cell Address
  622. HELP!!!! Cell Value in a Cell Address
  623. I want to sum a column and exclude those ending with cr
  624. Linking One Source to Two Workbooks
  625. reversing numbers to create dates
  626. SHOW GRIDLINES ON SPREADSHEETS IN EXCEL?
  627. Removing links
  628. drop down cells and put the bottom at the top in a new sheet
  629. Delete Spaces and Join Text in Cell
  630. Trouble with nested IF formula
  631. Cell formatting
  632. How do I create multiple columns from a one-column list in Excel?
  633. excel unsort
  634. Lookup Table help
  635. Noob question
  636. copy values generated by conditional formula in one sheet to the other work sheet as values
  637. LOOK FOR LATEST SELLING PRICE
  638. Getting close but need some more heip
  639. Number in cell convert in word
  640. Excel - Linking to other WBs
  641. Reference Previous Sheet
  642. Deducting breaks from time measurements
  643. how can i get equations of various conbinations using surface
  644. Formula Auditing Bug ? (Excel 2003)
  645. return largest number of a list of numbers in the same cell
  646. How to link cells so that if one is not answered then the other cannot be filled in
  647. Problem with Dynamic Named Ranges
  648. Show the contents of certain cells if....
  649. VLookup problem
  650. summing values for the same cell in 36 different worksheets
  651. Conditional formatting with more than 3 conditions.
  652. Change GETPIVOTDATA cell reference to A1 style
  653. Update Worksheet to Worksheet
  654. How do I close a link in Excel 2000?
  655. Remove a password
  656. In excell be able to Sum values based on the color of the cell
  657. LookUp/Match Question
  658. Add kilobytes to megabytes in the convert function
  659. Frequency and Time
  660. .csv incompatible message after saving
  661. 4 condition conditional formatting
  662. Data Validation list disappears
  663. formatting problem with functions
  664. Using Order in Excel Pivot Tables
  665. Automatic Hyperlinking
  666. Hold format from excel to data source for mail merging
  667. Sum based on value in another field
  668. Percentage of "yes" or "no"
  669. FIND or SEARCH Returning Erroneous #VALUE?
  670. Return a block of text based on a single "short name" entry
  671. Using a Macro to paste into Blank Cells
  672. IF/COUNTIF
  673. Using the NOW function
  674. How to keep sheets displayed(arranged) when moving between them?
  675. Customized Date Format
  676. hpw do I logic test a cell then copy the row to diff. SS
  677. Typing text
  678. seperating days of week in a database
  679. Password protecting a worksheet
  680. Replace nth place with colon
  681. Find nth occurrence and replace with ":"
  682. How do I link cells from one excel worksheet to another?
  683. vlookup
  684. Can I contol Tab Order in a worksheet?
  685. Converting date to numerical and doing calculations
  686. retrieve a column I hid for printing
  687. sort alphabebically ignoring preceeding symbols or numbers
  688. Excel vs. calculator multiplication product discrepancy...
  689. Character limit in an Excel Row
  690. SumIf - Linked Workbook - #VALUE
  691. Excel should speak results of logical formula
  692. Filtering a list with duplicates
  693. IF Formulas
  694. What is the syntax for the IF formula in Excel?
  695. Creating a form on a worksheet - Can I make a button for "notes"
  696. Address is in separate fields
  697. Need a Formula ASAP
  698. help with VBA/Macro
  699. How do I convert a row of cells into a two-dimensional array?
  700. How do I print my tracked changes in Excel?
  701. Evaluating multiple ranges for a count function
  702. Create a list range
  703. forecast production
  704. Surely a simple solution exists
  705. Help on creating a linked workbook.
  706. Lookup in raw and column concurrently
  707. how to apply template in excel ? or can I create a autoformat in e
  708. IF ...only it would work
  709. Excel and VB
  710. Automatically Converting Formula in a Cell to its Value at the End of the Day
  711. challenging question
  712. Automatically updating Graphs
  713. How to change text format .126 to number format 0.126 ?
  714. Why is my formula appearing in the cell not the value?
  715. How to calculate loan instalment daily rest
  716. Delete row wise duplicates & colomun wise simultaneously excel
  717. Not all data in AutoFilter pull down
  718. sumif based on vlookup array
  719. vLookup ... help please
  720. Sharing Worksheet cannot complete task
  721. Update a formula based on date worksheet was saved
  722. limkning images
  723. How do I delete every seventh row?
  724. Importing a part of a big comma delimited csv-file
  725. Help with getting text from "Merged Cell"
  726. Too difficult for me, please help.
  727. Define a range containing the first 10 rows of a filtered list
  728. how to use networkdays returning fractions of days (4.3 days)
  729. Links to other workbooks
  730. deleting hidden rows so i can print only the rows showing??????
  731. Multiple Criteria in SumProduct, N/A Result
  732. weird problem with LOOKUP function
  733. Change Text Case
  734. ALT+ENTER IN A FUNCTION
  735. Lookup and Reference
  736. Joining letters from different cells
  737. Summing Columns
  738. combine multiple worksheets & files into 1
  739. HOW DO YOU SUMIF THE NUMBER IS GREATER THAN BUT LESS THAN A #
  740. Matrix Multiplication
  741. how to count the number of text frequencies and copy to other cell
  742. Splitting Cell Contents with a comma
  743. I need to input daily cost codes would exceli calculate my totals
  744. Add-ins function in Excel 2003
  745. advanced: synchronizing data value across two worksheet drop boxes
  746. How to open up 50 text files in 1 worksheet in fewest moves?
  747. COUNTIF - everything excluding a string
  748. Formatting minutes and seconds to calculate a total average
  749. how do i set up round function
  750. compare data in the same column on separate worksheets
  751. Multiple formats for a single cell value.
  752. reference a blank cell
  753. how to do it?
  754. Looking up a column value versus another column value
  755. How can I set a input range for entrying data.
  756. Case Sensitivity problem with data validation
  757. NESTED IF STATEMENT
  758. How do I use look up function in excel?
  759. probably easy but....
  760. Sorting Dates
  761. Year-to-date year to date formula
  762. Denoting recurring numbers in formulas
  763. how do i unstring text in an excel cell?
  764. averaging averages?
  765. COUNTIF across sheets
  766. COUNTIF using Dates
  767. How can I calculate weekly totals of daily data in Excel
  768. DateDif Average? Damn DateDif
  769. How to sort and keep formulas
  770. Cursor Shapes for Excel 2003
  771. Conditional Formatting Issues
  772. IF Statement Question 0 values & blank cells
  773. automatic sequential number on invoice or shippers
  774. How do i make my 'daily report' form into a functional spreadshee.
  775. back ground color doesn't work in cell.
  776. Help for old macros with Excel 2002
  777. how to count weeks from date "X" then calculate
  778. Simplify syntax of a Sum(IF... Array
  779. macro to compare multiple cells to determine value
  780. IFSum(Vlookup...
  781. Summing a column of Numbers
  782. TOOL BARS AND THEIR USAGE
  783. value lookup help
  784. variable in a link where the variable is the name of the sheet
  785. When value is NOT Null
  786. IF function
  787. Data Forms
  788. How can I "RANK" time in Excel 2003?
  789. LInking problems
  790. Multiple Date/Time Formats
  791. help with multiple function from drop down box
  792. Using a range as value_if_true in IF function
  793. How do I Edit Fill Down a Cell Reference to Multiple Worksheets
  794. fitting route numbers to drivers names
  795. IF Statement W/3 Parameters ?
  796. Pull information from a Web page to Excel file
  797. HOW DO YOU MAKE FORECAST FUNCTION WORK IN EXCEL?
  798. Referencing Sheet Tabs
  799. Summing partial strings.
  800. Vlookup with multiple criteria
  801. Forecasting Sales using the Forecast Function
  802. When I open my past invoice it keeps changing date to todays date
  803. Need help with two Bowling Formulas
  804. Assign a Macro feature not showing
  805. URGET VLOOKUP HELP!
  806. SELECT FROM 2 COULMNS + 1 ROW
  807. I don't know if this is even possible...
  808. Can I delete blank rows from excel without selecting them?
  809. need help with function and formulas
  810. Lotto Number Checker
  811. Is there a way to determine which cell the function =min() used?
  812. Find an empty cell and put a dash in it?
  813. Pull Down menu's
  814. Help with Grouping the numeric data stored in one column.
  815. Grouping
  816. How do I share data in different worksheets?
  817. How do I calculate dates backwards from a project end date
  818. Friends: Please guide me
  819. counting results of a list
  820. Use conditional formating to incicate blank cells in excel
  821. excel help please!!!!!
  822. using countif in isolated cells not a range
  823. Need help on formulating ordering
  824. Help with command buttons
  825. elapsed time displayed as a decimal
  826. 2 Columns - Show extra items in Column B
  827. How to Copy a Password Protected Excel Worksheet
  828. Conditional Formatting & Dynamic Range
  829. Can logical formulas be used to build accounts receivable workshe.
  830. create a conditional formula
  831. Compare 2 columns, and create a list of items that are in both lists
  832. Invoice numbers
  833. Highest Score for each Test
  834. feat_funkyeva#7
  835. excel worksheet function
  836. How do I protect formulas in a worksheet and allow data entry
  837. Need Help with a formula
  838. Array formula on Pocket PC
  839. logic test
  840. Need help with formula in Excel XP
  841. sum with criteria
  842. drop down lists
  843. sum with 2 criteria
  844. Drop down lists - thanks (and one more query)
  845. Transfers
  846. Time calculations Urgent please help
  847. Unary + Operator
  848. sum with 2 criteria
  849. Calculation on SUMIF Results
  850. How can I display a number as a ratio of x:1 in Excel?
  851. How to copy the hyperlink of a list of cells in another column
  852. file commands
  853. How do I hide the zero in the "sum" cell until numbers are put in the cells that are being added?
  854. How NOT to extend formula/refrence to a cell
  855. How do I convert word data (not in tables) into excel format?
  856. Excel needs to let the user set the sort default to "NO HEADER ROW
  857. How do I import a list of names into a separate form that prints .
  858. compare two lists
  859. how do I use Goal Seek in a Pivot Table?
  860. How do I sum a range if the date is is greater than today's date?
  861. vlookup returns column to the left
  862. cell text completion
  863. How do I get price calculations to always end in 9?
  864. How to use FV function to find a payment to reach a specific goal
  865. Condtional Quartile statement
  866. Can I check if a date falls between a range then sum other # if tr
  867. freeze horizontal and vertical panes at the same time in Excel
  868. Cant get totals to work with IF statements
  869. How do I calculate the final pmt required to meet a target IRR?
  870. calculator Errors
  871. How to get pointer in new cell on Open?
  872. Email worksheet error ".tmp"
  873. Several function questions (nested functions)
  874. Sum with 2 criteria
  875. I need a conditional formula
  876. Subtotals by month
  877. returning blank cell
  878. GENERATE HYPERLINKS
  879. How can I do a lowess fit in Excel?
  880. vlookup does not find data
  881. How can I format number into thousand?
  882. "Sort" help
  883. I'm having trouble with my windows, they won't expand full
  884. Create an external reference link with embedded variable
  885. Range of Worksheets Sum
  886. shortcuts in Excel
  887. Corporated into the same fromula please.
  888. Help with using the IF and Mid functions
  889. SUM C IF B=Cap...TILL NEXT B=Cap...
  890. Problem with IF function
  891. SUM C IF B=Cap... Till Next B=Cap...
  892. Equal to or less than formula
  893. Adding indicators on a line chart.
  894. Question about counting recent cells
  895. sumproduct , array or countif?
  896. Grade book average formula
  897. Calculating an Activities During Periods Of Natural Months and/or Dates
  898. for SUMIF function, how do I use 2 sets of range & criteria
  899. How can I select one checkbox and have it unselect other ones?
  900. Why #NAME?
  901. Conditional formula - language needed
  902. How to use a cell value to reference a worksheet name
  903. Sumproduct?
  904. grouping and give colours
  905. use range name in formula
  906. Complile Error with Date
  907. Mulitplie workbooks - known duplicate records - need to consolidat
  908. Convert Numbers to Text
  909. How do I move information between worksheets?
  910. User Group Meeting Ideas
  911. distribution of durations
  912. Lookup Hi / Lo
  913. Dynamic range for Table_array in a VLOOKUP.
  914. 3D Arrays
  915. If statement w/ rounding but not all numbers
  916. Is there a function to consolidate multiple records into one recor
  917. compare two groups of data
  918. Change formula to Indirect
  919. between - function?
  920. ROUNDUP copy/paste and fill handle not working
  921. Drop down to diplay info from another sheet
  922. need a roster that 3 kids can work to day by day?
  923. HELPPPP!!!!!
  924. Please help!
  925. Populate multiple columns
  926. Sorting columns
  927. sequential numbering of copies printed
  928. Distributing values from rows to columns for Access import
  929. how can I make a form number change everytime the form is opened
  930. Using scientific notation in TEXT() function
  931. populating multiple cells
  932. INT Function
  933. Find duplicates and append
  934. sumproduct?
  935. Lookup Functions
  936. outline & groups
  937. .csv file - excel 2003
  938. Return a cell value based on specific combinations of cells in an array
  939. calculate using rolling calendar
  940. Countif function for instances of text string contained
  941. RE: Countif function for instances of text string contained
  942. Getting a running total?
  943. How do I "show pages" in pivot tables in Excel 2002
  944. About User Defined Functions
  945. How do I use a range of numbers in an if statement?
  946. "Cannot empty Clipboard"
  947. cannot open files
  948. How do I keep the zeros in front of numbers when i split a cell
  949. Re: Average Grades and drop the lowest score
  950. Bonuses and Penalties in Grade Books
  951. Help, how to find a range of data?
  952. Scrolling Cells
  953. LOOKUP question
  954. Index/Match question Need help!
  955. Countif a small or capital letter
  956. Wroking with rounded or trunc calculation
  957. Date entry gone haywire in Excel!
  958. How do I search for specific text and sum the cell to the right?
  959. Excel should be able to map which cells reference each other.
  960. another sumproduct question
  961. Calculate difference (mins) between 2 Times
  962. Defined Named cells lined to a Function Procedure
  963. Multiple protections
  964. return a range of cells from a vertical lookup
  965. Converting decimals into hh:mm
  966. Compare Side by Side with 3 simulatanous sheets scrolling
  967. Unique Value without using FILTER
  968. How to select cells (located in a column) for formulas in a row automatically?
  969. Copying a column to a new sheet so that cells match.
  970. Calculating the maximum value in a range of cells in a closed work
  971. Formula chooser?
  972. auto row insert
  973. Excel - matching data
  974. Limit on number of conditions?
  975. Can I search the whole workbook and not just a sheet?
  976. Schedule/Date Calculation
  977. Drop data from workbook after specified time
  978. Excel expression {=SUm(if(istext(c8:k8),1,0))}
  979. How do I change numbers from positive to negitive
  980. HELP!!
  981. Making Array Formula, please assist!
  982. assign value to text
  983. need to calculate time multiplied
  984. In Excel allow freeze pane in any column plus any row
  985. Blank field formatted as date
  986. How can I use a circular function to add 4 to a column of cells?
  987. HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT
  988. How do I concactinate two columns of digits?
  989. An icon on the forms toolbar is unavailable?
  990. Cell Fomula
  991. List Box Multi Select Option
  992. Custom number format - Accounting
  993. Pivot Sort ???
  994. reformat columns to rows?
  995. If correct, add 1
  996. Excel Math Wizards
  997. Easier Way?
  998. Can I email a single sheet in a workbook?
  999. Removing a FIXED Function
  1000. Using Auto Filter
Google