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. How do I print my tracked changes in Excel?
  2. How do I convert a row of cells into a two-dimensional array?
  3. help with VBA/Macro
  4. Need a Formula ASAP
  5. Address is in separate fields
  6. Creating a form on a worksheet - Can I make a button for "notes"
  7. What is the syntax for the IF formula in Excel?
  8. IF Formulas
  9. Filtering a list with duplicates
  10. Excel should speak results of logical formula
  11. SumIf - Linked Workbook - #VALUE
  12. Character limit in an Excel Row
  13. Excel vs. calculator multiplication product discrepancy...
  14. sort alphabebically ignoring preceeding symbols or numbers
  15. retrieve a column I hid for printing
  16. Converting date to numerical and doing calculations
  17. Can I contol Tab Order in a worksheet?
  18. vlookup
  19. How do I link cells from one excel worksheet to another?
  20. Find nth occurrence and replace with ":"
  21. Replace nth place with colon
  22. Password protecting a worksheet
  23. seperating days of week in a database
  24. Typing text
  25. hpw do I logic test a cell then copy the row to diff. SS
  26. Customized Date Format
  27. How to keep sheets displayed(arranged) when moving between them?
  28. Using the NOW function
  29. IF/COUNTIF
  30. Using a Macro to paste into Blank Cells
  31. Return a block of text based on a single "short name" entry
  32. FIND or SEARCH Returning Erroneous #VALUE?
  33. Percentage of "yes" or "no"
  34. Sum based on value in another field
  35. Hold format from excel to data source for mail merging
  36. Automatic Hyperlinking
  37. Using Order in Excel Pivot Tables
  38. formatting problem with functions
  39. Data Validation list disappears
  40. 4 condition conditional formatting
  41. .csv incompatible message after saving
  42. Frequency and Time
  43. Add kilobytes to megabytes in the convert function
  44. LookUp/Match Question
  45. In excell be able to Sum values based on the color of the cell
  46. Remove a password
  47. How do I close a link in Excel 2000?
  48. Update Worksheet to Worksheet
  49. Change GETPIVOTDATA cell reference to A1 style
  50. Conditional formatting with more than 3 conditions.
  51. summing values for the same cell in 36 different worksheets
  52. VLookup problem
  53. Show the contents of certain cells if....
  54. Problem with Dynamic Named Ranges
  55. How to link cells so that if one is not answered then the other cannot be filled in
  56. return largest number of a list of numbers in the same cell
  57. Formula Auditing Bug ? (Excel 2003)
  58. how can i get equations of various conbinations using surface
  59. Deducting breaks from time measurements
  60. Reference Previous Sheet
  61. Excel - Linking to other WBs
  62. Number in cell convert in word
  63. Getting close but need some more heip
  64. LOOK FOR LATEST SELLING PRICE
  65. copy values generated by conditional formula in one sheet to the other work sheet as values
  66. Noob question
  67. Lookup Table help
  68. excel unsort
  69. How do I create multiple columns from a one-column list in Excel?
  70. Cell formatting
  71. Trouble with nested IF formula
  72. Delete Spaces and Join Text in Cell
  73. drop down cells and put the bottom at the top in a new sheet
  74. Removing links
  75. SHOW GRIDLINES ON SPREADSHEETS IN EXCEL?
  76. reversing numbers to create dates
  77. Linking One Source to Two Workbooks
  78. I want to sum a column and exclude those ending with cr
  79. HELP!!!! Cell Value in a Cell Address
  80. Using a Cell Value in another Cell Address
  81. Count number of values
  82. Relative Hyperlinks are not saved correctly
  83. Hyperlinks
  84. Edit / Move or copy sheet stopped working in Excel 2003
  85. Match or Index Question
  86. Fill down
  87. Using ABS
  88. Plotting a binomial distribution formulae in excel?
  89. Need an Expanding array formula
  90. My worksheet doesn't display correctly
  91. How do I change all cells to Proper text in Excel
  92. Comparing Columns
  93. add 1 count to a column of numbers
  94. INDIRECT and Named Ranges referencing closed workbook
  95. Conditional formating
  96. LOOKUP Help!!!!
  97. How can I break values apart that are in the same cell?
  98. Working in a Worksheet that has protection on
  99. cell shows 0 when referenced cell is null
  100. Grades
  101. Sumproduct
  102. Can this be simplified
  103. MATCH, INDEX, LOOKUP - Help!
  104. Automatic Totals/Coloured Cells
  105. Sumproduct
  106. excel to powerpoint
  107. Keyboard shortcuts for time in Pocket Excel
  108. RE: How do I get info from a cell based on criteria from another cell
  109. word count in Excel
  110. How can I add a new formula to Excel formula list
  111. How to calculate Date & Time differences
  112. Evaluating Today() function only once in a worksheet
  113. Is it possible to use some pictures in an IF function?
  114. Generation of random numbers and sum of those with a condition
  115. Conflicting date ranges
  116. copy page setup from worksheet to another within workbook
  117. How to display selected table entries from another worksheet?
  118. Function
  119. produce a formulate to produce assigned seats for dinner
  120. How do I sum within a set time frame from the current date?
  121. what is maxdiff?
  122. Can I have multiple pages for a Hyperlink
  123. Formula does not show as I entered it.
  124. Function Vlookup, Match or Index?
  125. A general question regarding Financials Formulas in Microsoft Exce
  126. Function Vlookup, Match or Index?
  127. Multiple team "All-Play" Won, loss, tie records
  128. Security Certificate
  129. format row of cells to highlight least amount
  130. Removing Volatility
  131. removing digit or calc LEN fields
  132. count cells that contain text entries
  133. looking up figures in a column and selecting next highest match
  134. Why are lines scrambling in my excel worksheets?
  135. Pull data from yyyymmmmdd.xls
  136. copy rows meeting criteria to another worksheet
  137. conditional formulas
  138. Find and match totals Genius Req. this should be easier to read
  139. How do I automatically drop totals from one worksheet into another
  140. Footer
  141. "Average" function query
  142. Find and match totals Genius Req.
  143. PERMUT function
  144. How do I calculate an employee timesheet in Excel?
  145. =SUM((B7+2),IF($D7>0.Workday,($D7+E$8,Holidays!$C4:$C11$),''''))
  146. Conditional Formatting - Formula based
  147. How do I use an if statement with Find and Replace
  148. Lookups
  149. giving points by a result (function)
  150. pulling numbers from hhh:mm:ss
  151. How do I purge data in Excel 2003
  152. Combo Box
  153. Looking up a value from an array table
  154. Replace a number with text
  155. How can I remove cell reference when calculating outside of the pi
  156. Link Worksheet to other worksheets
  157. Concatenate columns with cell data containing Carriage Returns
  158. Concatenate cells with carriage returns
  159. Is there a way to protect individual cells in a worksheet?
  160. filter unique data using functions
  161. INSERTING AN OPTION BOX
  162. External Data and Pivot Tables
  163. How to select a range whose name is entered in a cell.
  164. Cell Format
  165. Combine cells
  166. brackets { } in excel formulas
  167. How could I create an outline of my drivers hours on Excel?
  168. Help, need to make field go red or green
  169. Populate multiple cells using the same reference
  170. how can i get formulas in excel to copy and paste?
  171. Why is worksheet being saved as scrap? why does it have the .shs?
  172. with Autofilter on, display count results in lower left corner wit
  173. EXCEL - need help with IF for dates on schedule
  174. Cell change
  175. CONDITIONAL FORMAT
  176. Finding (Multiple) Highest Values in Column
  177. help with sheets
  178. how do i transfer a spreadsheet list of names onto an document
  179. TOTALS
  180. Fourier Series
  181. why does undo feature not work after value entered in cell in exce
  182. Automatically incrementing number for each print
  183. Time calculations Urgent please help
  184. Validation to force entry in a cell
  185. Hide/unhide
  186. Protecting Multiple Sheet
  187. How to go back to last selected cells?
  188. Range function
  189. Finding data by dates
  190. Criteria - Automatic Change Font or Fill Colour
  191. Tab Color from cell value?
  192. Excel should let me switch between worksheets using ctrl-tab
  193. optimization plug-in for Excel 2003.
  194. Re: headers across printed pages
  195. how do I sum using 3 reference columns?
  196. Calculate terms in a Series
  197. Sumproduct
  198. How to return top 5 scores?
  199. How do I sort a column of computed variables in EXCEL?
  200. function to fill all days of month to end of month
  201. Adding a Single Cell total from Seperate sheets
  202. Index - Offset - Match Issues
  203. how do I set up excel sheet for meal break down cost,labor,meat
  204. How to copy worksheets
  205. Allow the use of the fx wizard within the fx wizard for nesting
  206. In excell 2003 I select a cell and try to refill with any color
  207. Count Intervals of 1 Numeric value in a Row and Return Count down Column
  208. How can I remove hidden empty text cells from Excel?
  209. if - then dates formula in differant cells in other worksheets
  210. Formula to extract a phone# from a cell of text (eg classified)?
  211. countif challenge
  212. Help me!!!
  213. help!
  214. Which function should I use to ....
  215. SUMIF function in "Price quote with tax calculation" templae
  216. CountIF and changing ranges
  217. how do you calculate the 5th square root in MS Excel?
  218. Pull-down text in a cell
  219. reset to zero
  220. ISERR
  221. Can I make a formula in Excel to display result in same cell?
  222. Format Telephone Cell Range
  223. formula for blank cell
  224. If
  225. Weighted Average Standard Deviation
  226. MIN/MAX functions and reporting from a different column
  227. Need formula help please....
  228. Transpose and order array numbers
  229. HOW TO SUBTRACT A YEAR+MONTH AND SHOW DIF IN MONTHS?
  230. how do I sumif using 3 reference columns?
  231. How do I delete the formula but keep the results
  232. addind a new row
  233. tools helping understand calculations
  234. How do I sum with 3 reference columns?
  235. count number of cells
  236. Can I use IF statement with a formula?
  237. sumif function
  238. Function giving Error
  239. Newbie: Help with OFFSET function
  240. updating one spreadsheet with another problem
  241. what happens when the right shift key is held down for 8 seconds?
  242. #value!
  243. How can I open an excel spreadsheet if I forgot the password?
  244. IF FORMULAS
  245. Multiple line deletion in excel
  246. find and copy
  247. Every time I try to use EOMonth I get #Name?
  248. Additional Sumproduct Criterias
  249. Calculating Dates not always working
  250. How do I add dates (mo/day/yr + 6 wks) in Excel ?
  251. Using returned values as part of another formula
  252. Copy and Paste
  253. How do Multiply whole numbers by decimals
  254. How do I use the TODAY function with the SUMIF function?
  255. Value_if_true
  256. Data Validation
  257. Assigning a cell the value of a cell in a range
  258. how to do a correlation of numbers?
  259. Help with lookup function
  260. How do I calcuate an IC50 from analyze it?
  261. using last available row in a formula
  262. using last available row in a formula
  263. Print other worksheet by changing a Letter/# on another page.
  264. how do you add in a new function?
  265. How do I lookup two cells and return a third.
  266. Lookup values
  267. % of calculated field in pivot table
  268. select two cells from workbook and have them join in another workb
  269. can you create a macro to compare two different doc side by side
  270. How do I use COUNTIF if I am combining 2 columns?
  271. return significant digits of a cell
  272. summing subtotals
  273. I have a question regarding countif formula.
  274. Drop Down - Jump to selection
  275. worksheet print format
  276. Generating truly blank cells
  277. vlookup error - recognition of value
  278. Add formula based on a fixed number
  279. reverse text
  280. maximum value and associated labels
  281. How cell ranges are handled by worksheet functions/row column matc
  282. Leaving a cell blank. Not NA(), not "".
  283. add a row after every unique number
  284. Match
  285. opening different programs with excel macro buttons
  286. how to protect a word art in excel from edit
  287. HOW DO I REMOVE MARKERS IN A COMPLETE COLUMN?
  288. What is wrong with this formula?
  289. Autofil a cell in the same row.
  290. excel worksheet function
  291. Excel 2003
  292. How do I read info from different worksheets into a summary sheet?
  293. removing everything from the left after 10 digits
  294. Vlookup
  295. conditional formula
  296. vlookup
  297. How can I populate an Excel cell based on the data in another cell
  298. Inputting SAME formula within EVERY (ALL) Worksheet
  299. Help with dynamic sum formula
  300. how to creat a selection pull down window?
  301. Countif function
  302. adding numbers with a label
  303. Excel Worksheets
  304. IF functions
  305. Why do my formulas work in some cells but not others?
  306. Cell Format Changes When Data Is Entered - Not Conditional Formatt
  307. Excel formula
  308. SUMIF not working #VALUE!
  309. Nested If's
  310. Reference the document properties in a cell
  311. Mode() & Large()
  312. smart tags
  313. Problem with dynamic ranges
  314. EXCEL - LINKS cannot easily get list of all links & names in book
  315. How do I transfer a keyboard function key to a terminal emulator?
  316. prove/audit SUMPRODUCT?
  317. EXCEL - Auditing - TRACE to show source from another page
  318. daily output list of employees
  319. allow multiple users on excel spreadsheet
  320. how many if statements are allowed per cell?
  321. dates in year
  322. Pivot Table data source "data source contains no visible tables"
  323. Make new column using partial text in another cell
  324. how to delete unused footer dialogs in excell
  325. Update Query (minutes into hours)
  326. Count names in column once
  327. Rounding Data Question
  328. Pivot Table Question
  329. Sum Dates
  330. days caculation
  331. countif problem
  332. How do I retrieve deleted information from an Excel worksheet?
  333. How do I add a cell with a label behind it
  334. drop down list (repost from miscellaneous)
  335. how to display remaining rows as blanks
  336. How do I change fill color in excel based on data in the cell
  337. Remove last character of text string
  338. random number generation
  339. Changing orientation of pages
  340. Create different workbooks from only one workbook
  341. How to create list on another tab by selecting qty from big list?
  342. cell shading
  343. IRR
  344. ROUNDING
  345. decimal to binary conversion
  346. random number function
  347. IF + AND string - Help!
  348. Simplifying array formula which evaluates as error.
  349. Excel-comments entered by users disappear in a shared excel-sheet
  350. how can I combine multiple worksheets into one?
  351. Random numbers generation with conditions.
  352. conditional formatting
  353. vlookup with more than number to be retrieved
  354. COUNTIF doesnt work!
  355. SUMif or SUMproduct across multiple worksheets?
  356. Data range to names
  357. How do I calculate the difference between 2 dates (m,d,y) ?
  358. Re: GREATER OR EQUAL TO BUT LESS THAN Problem using Sumproduct
  359. vlookup to provide row reference instead of value
  360. Convert SERIAL date back into dd/mm/yy format?
  361. keeping certain values the same when copying
  362. Error when opening a saved worksheet
  363. Re: List of Names, Dates, Durations ...
  364. column from ABC to 123
  365. repeating a character across the width of a column
  366. Need Elapsed Time Help
  367. Text won't wrap if row height is over 200
  368. Excel
  369. Sumif and base it on font color of cell
  370. VLOOKUP 2 text columns
  371. sum values in a data group
  372. cell color
  373. countif
  374. How do I insert OR in imbedded formulas?
  375. How do embbed a cell within a sentence
  376. how can I eliminate the first 3 characters from a cell
  377. Database type formula
  378. repeating functions
  379. dropdown in excel
  380. dropdown in excel
  381. macro to hide rows if cell is blank
  382. Find data in columns, then place in rows
  383. Sum unique with conditions
  384. how do I hide data elements in pivot in excel 2003 ?
  385. Get Past the 7 Nested IF limit
  386. Does 2003 excel have training on V Lookup
  387. simple
  388. summarize data sheet
  389. Most simple formula to calculate date+ 30 months?
  390. cannot delete contitional formatting
  391. what is the maximum no of formula's in 1 spreadsheet?
  392. percentage
  393. Is it possible to use a wild card in a =COUNT(IF equation?
  394. Copy formatted in several sheets of a workbook
  395. Can I use Excel to match text data from 2 separate columns ?
  396. How do I create a unique identifier # when open excel file?
  397. conditional formatting
  398. VLOOKUP results on last names
  399. pasting formula doesn't work
  400. need to show when date is past due
  401. Apportioning revenue
  402. visual basic
  403. Need to calulate a sum for once a month X #days X #times used per.
  404. SUMIF function with 2 conditions
  405. Indirect Range
  406. Any tips besides ALT+ENTER?
  407. return a value based on a range
  408. Logical Function Question
  409. Help with vlookup formula
  410. How do you randomly sort a RANGE
  411. I can't get the Erlang formula in Excel 2002 to populate...help
  412. Networkdays
  413. How do I calculate and display ratio ( format 3.5:2)
  414. form on one worksheet and the list on different worksheet
  415. How do you have the file path print on all pages?
  416. SUM Querie
  417. Extracting integers from a text string.
  418. Summing a Range Omitting the Occasional #N/A
  419. CountIf Question
  420. how do i tranpose one row to multiple column?
  421. How can I round up a fraction?
  422. sumproduct resulting in #N/A
  423. Link not updated everytime spreadsheet opened
  424. Autofilter number of records
  425. use keys instead of mouse to use the drag function
  426. password
  427. Print "Landscape" in Explorer
  428. convert dates to number of days
  429. Counting by multiple criteria
  430. How am i able to populate a sumation for multiple sheets
  431. calculation with minutes
  432. any function or mechanism to get in a cell the name of the sheet?
  433. Re: Calculating p-value from Fisher's Exact Test
  434. how to do it without rounding off
  435. COUNTIF and multiple conditions
  436. if (and) question
  437. problem with print data in the all column
  438. Is there a macro which adds selected/highlighted cells?
  439. calculating entries
  440. Improrting Text file to a matrix when things are not constant.
  441. Data Automation Transfer
  442. array formula problem
  443. Help with averages please
  444. how do i create a formula for selected range?
  445. autosave
  446. date ?
  447. Calendar 1st month ok but 2nd to 12th how.
  448. Database functions should use criteria in formula, as 1-2-3 does
  449. I need to protect cells that contain formulas but on a huge scale.
  450. Find 7....
  451. VLOOKUP across merged cells
  452. AutoSave: How can I get it to save every 5 minutes & NO prompt?
  453. how to change a formula for a large group of cells
  454. IP Address in cells
  455. linking data from one workbook into another
  456. macro to hide columns
  457. Cellphone tariff checker
  458. How do I delete a drop list button
  459. Excel should let me change case in the cell the text is in.
  460. Protecting Macro's
  461. Protecting Macro's
  462. LOOKUP(?) Challenge
  463. How do I display a formula on the worksheet
  464. holiday planner
  465. i want to calculate the houers of workers 21:00 - 05:00 =8
  466. IF #REF1 = ERROR then #REFBLANK
  467. my date range does not work in an = ifsum
  468. countif date range
  469. Excel 2003 Mouse Right Click
  470. Advanced IF function
  471. Macros? drop downs?
  472. Automatic update to cashflow spread sheet
  473. How do I identify cell color for comparison?
  474. Help with a function
  475. Match/Index return #N/A
  476. VLOOKUP loop multiple times
  477. Counting unique records with additional criteria
  478. Is there a way to isolate individual cells?
  479. How do I eliminate the leading zero when concatenating?
  480. radio button help
  481. How do I repeat a value in a pivot table in Excel?
  482. formula for debits and credits in EXCEL spreadsheet
  483. Looking up text - help
  484. Please help!
  485. Coloring Active Cell
  486. Getting value of Option button
  487. Parsing 124A into 124
  488. Parsing 124A into 124
  489. hyperlink
  490. is there an easy formula to creating a golf skins game
  491. How to insert a barcode into an Excel sheet cell?
  492. formula for cell merging
  493. Budget
  494. Display the results not the formula in the task bar
  495. How do I show a timestamp when an adjacent cell changes in value?
  496. spell check excel
  497. Delete Define names across workbook
  498. Return value of the cell to the right...
  499. Position of a cell in a range
  500. Scenarios
  501. Excel, renaming columns
  502. What is ROW(INDIRECT("1:40")) doing? (array formula)
  503. real-time countdown
  504. radio button help
  505. Is there any easier way to do this formula?
  506. If functions for dates
  507. Formula
  508. Amount of Increase of Wages
  509. Need help w/dates
  510. format optional parameter
  511. enter month end date
  512. Can I put more than 65536 rows in one Excel sheet?
  513. IF Statement - Excel Version 2002
  514. Sumproduct..help please
  515. percentage increase
  516. How do I display more than one match in a Index/Match formula?
  517. Can a date be used for conditional formatting?
  518. Can Excel2002 determine if a calculated date is a business day?
  519. Just need to know what type of formula i would use for this
  520. Countif statement
  521. have a calendar pop up in a cell to pick & insert a date in excel
  522. Count and Count if funtions
  523. Comparing columns iin 2 sheets to generate one
  524. cell on one page equals cell on another page in excel?
  525. excel crashes when I email
  526. How do I rename the A B C cell range along the top of excel
  527. How do I clear the contents of one cell from another cell?
  528. Excel-read a table
  529. How can I sort check boxes in excel?
  530. Is there a way to stop fractions from being simplified?
  531. Formula format for Count or Countif funtion with two criterias
  532. Vlookup formula - Excel Version 2002
  533. Division By Zero
  534. Range of Cells to create body of email
  535. IF formulas
  536. combine 2 columns
  537. How do I change a range name back to the underlying data range?
  538. date in file name
  539. Conditional SUMIF
  540. Pulling info into another sheet
  541. Return Value
  542. Last cell entered
  543. Excel Function
  544. feet and inches
  545. Array Formula Calendar
  546. Returning Descending Values
  547. CONVERTING TIME (DAYS) TO ONTHS,YEARS, ETC.
  548. adding lots of cells from different sheets
  549. Req: How to create multiple mutually exclusive filters
  550. Include Subtotal in SumIf
  551. How to sum cells with a certain letters sequence
  552. Importing csv file all data is in first column
  553. simplify a vlookup function
  554. Excel Macro Hide
  555. Prevent entry in a column
  556. Index and Match Help Needed
  557. How do I create conditional formatting to track due dates
  558. Help me!!!!!!!!
  559. Straight forward idiot question!!!
  560. bahttext
  561. How to set a column to accept only a specified number of digits
  562. Help please
  563. y i cannot solve it ?
  564. Interrogating cells by cell formatting
  565. Advanced Filters
  566. New Worksheet
  567. how can I match numbers from two columns?
  568. how can I match numbers from two columns?
  569. HOW DO I CHANGE QUERY DATA TO A DATE RANGE?
  570. "B/."
  571. A borrowing dvd spreadsheet
  572. Insert New Row without shifting formula
  573. Problem with nested logical formula.
  574. Converting cell ref. w/num to currency
  575. How do I use Excel to do a Gage Repeatability and Reproducibility.
  576. VLOOKUP - computed go to
  577. Excel 2000 Question
  578. count cell if value present in every other cell + criteria
  579. HOW DO YOU ADD & SUBTRACT IN ONE COLUMN
  580. formula ignores last infor - please help
  581. sharing entire columns
  582. Pivot table page filter not accepting multiple values. Workaround?
  583. Sharing Information Between Workbooks
  584. return value based upon another
  585. Re: Traffic needed. Can anyone help?
  586. Advanced Filter is grayed out
  587. Apportioning revenue
  588. maxium worksheet on a workbook?
  589. Permutation in excel
  590. I TELL A CELL =B1 BUT I ALSO WANT IT TO TAKE THE TEXT COLORS
  591. How do I make FORMULA TO SOLVE CURVE OR 2ND ORDER EQUATION?
  592. Saving as a web page
  593. how do I make single character as a variable in an array
  594. a unique cell value returns multiple cell values from another shee
  595. SUMIF help!
  596. Conditional Formatting
  597. Permutations
  598. Permutations
  599. Excel won't save
  600. How do you make a countif formula with 2 or more critera?
  601. insert two formulas one cell
  602. How do I create a number format mm:ss:th (tenths and hundreths)
  603. hOW CAN I CONVERT NUMERICAL POINTS INTO A LETTER GRADE(SCHOOL)
  604. Custom Number Formats
  605. How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied?
  606. Function To Convert Liters To Imperial Gallons & Vice Versa
  607. count cells in a coloumn with letter x in it
  608. how do i combine three columns in excel.
  609. Apportioning revenue
  610. Searching
  611. removing a space from starting of the text
  612. How do you unlock a pivot table on a protected excel sheet?
  613. transferring files
  614. An Excel Formula Question
  615. now() sumproduct.
  616. quick way to copy-paste a formula linked to cells in another file
  617. I PUT A FORMULA IN A CELL BUT I DON'T GET NUMBERS BUT THE FORMULA
  618. Advanced unique cell count with multiple conditions ... help!
  619. Copying Data
  620. nested formula with if condotion
  621. cumbersome sheets on Word
  622. Mixing up the arguments
  623. Worksheet and Word
  624. Need Help
  625. index,match,match on un-sorted data
  626. Formula returning #N/A Error---why???
  627. Spanish/english Formula Equivalences
  628. Validation - Weekend Or text
  629. Countif, Index, Match... not sure which to use
  630. =today()
  631. Using Count function with a conditional range
  632. Sorting help
  633. Excel
  634. AVERAGE more than 30 arguments?
  635. INDEXing Question
  636. Excel error message ???
  637. copy-paste as Values automatically
  638. smart tags
  639. Excel Help!!!
  640. Newbie: worksheet function advise (huge please)
  641. Calculting SUM of cells with IF functions inside
  642. Copy a formula down a set number of times
  643. return a blank cell
  644. HOW CAN I LIMIT QUTITY OF LETTERS IN A CELL?
  645. Need sorted validation list
  646. Using min and max function XL2002
  647. find the lowest value in a row and add a number to it
  648. How to count how many cells a linked cell group occupies
  649. Is this possible......?
  650. How do you "freeze" an excel worksheet?
  651. Same Content, 2 spreadsheets with different size
  652. would like help in Excess
  653. Excel Help!!!
  654. Run Time Error '1004'
  655. Matching Multiple Sheets
  656. errors in worksheet functions
  657. I want to customize a text depending of anwers in a lookup table
  658. if then statement
  659. yearfrac
  660. Any cell containing formula seen as data instead of formula
  661. function - if
  662. Count Intervals of 2 Numeric values in same Row and Return Count across Row
  663. Saving as web page v publishing a worksheet
  664. Is there a "concatenateif" type function? (>30 options) in Excel
  665. Statistics using dates in excel
  666. Using XML
  667. nested formula
  668. question
  669. Conditional formattind with dates
  670. need Lookup table to return null or zero
  671. Matching and aligning columns
  672. There should be a keyboard shortcut for fill color in excel
  673. Freezing Autofilters
  674. anybody?
  675. Condition sum
  676. Trying to make multiple formula cell
  677. Newbie: worksheet function help
  678. getting info into a new tab and changes when entering in other tab
  679. Rows to Repeat at bottom
  680. How do I display contents of an adjoining cell?
  681. alt+enter does not work
  682. How can I use Goal Seek in multiple cells?
  683. Formula with mulitple condtions
  684. Conditional Formatting
  685. help with vlookup spreadsheet
  686. Every 28 days
  687. Auto change defined name ranges on Jan 1st annually
  688. Another way to lookup data
  689. How can I get a row # to stay when I delete a row?
  690. summing data
  691. This query returned no data
  692. how can i make 2500 urls in an excel file hyperlinked quickly?
  693. Formula Help
  694. Sumif using wildcard
  695. I need to make 111-11-1111 into 111111111
  696. counting unique numbers in filtered data
  697. Multiple IF conditions
  698. how to turn off design mode
  699. Cell color when selected
  700. Excel Should Have a History Function.
  701. Excel toolbar?
  702. Help with a formula?
  703. linest - cubic looking for MSE Mean Square Error
  704. need help with an excel shreadsheet
  705. day of the week entry automatically
  706. Unable to see Properties in Design View for controls
  707. vlookup multiple worksheets
  708. Counter for Rows
  709. replave word in formula
  710. worksheet protection and outlines
  711. Link Updates
  712. Vlookup "crosstab"
  713. adding variable number of columns
  714. Calculations with date time interval
  715. Keep cells in two different workbooks linked after delete/insert r
  716. edate and yearfrac functions not tallying
  717. vlookup with relative paths
  718. Adding cells with similar descriptions
  719. Is this possible?
  720. Sumproduct ??
  721. conditional formula
  722. How do I make a worksheet my start page?
  723. streamline SUMPRODUCT
  724. =cell("filename")
  725. How do you create a drop down menu in excel?
  726. present market value for homes in excel
  727. I need a %age increase formula that rounds up to the nearest $10
  728. Can't get sensible clear colours in Excel 2003
  729. Formula should return a result but doesn't
  730. Need some help completing this Formula
  731. PMT Function
  732. how do i find cells that repeat the same content?
  733. IF FUCTION
  734. Excel 2003 links are not updating between workbooks
  735. PLEASE HELP - Pasting Cells to WrkSheet with Hidden Columns
  736. 2 queries: Display last cell, and compare two lists
  737. IF FUNCTION
  738. INDEX / MATCH
  739. problem with =isnumber(match(right(...
  740. Sum cells based on a row variable and seperate column variable
  741. IF FORMULA
  742. VBA / STEMP Question
  743. Filling cells depending on two conditions
  744. Help with formula please - Thanks
  745. Lookup problems
  746. HOW TO MAKE A FORMULA BETWEEN D=F*C IN THE WHOLE PAGE
  747. Totalling occurances in a column
  748. wildcards do not seem to work
  749. Data Validation - Scroll in the formula bar for a custom criteria
  750. How do I get text to flash in MS Excel
  751. sumif with multiple conditions
  752. Function to count unique values?
  753. how do i add different cell ranges using a formula
  754. assign a value to text
  755. I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES
  756. How do you move names and data between large Excel 2003 workbooks?
  757. Count If 2 Diff Values Appear on Several Worksheets w/in Workbook
  758. Display first, second, etc Nonblank Cells in a Range
  759. sum if
  760. complicated validation
  761. Ctrl "C"...CTRL "V"
  762. IF Date is then...
  763. Lookup more than one
  764. Sort a Column of Dates in Pivot Table
  765. Replacing or Substituting Text
  766. when I auto sort in excel, How do I know how many are selected?
  767. Set value
  768. Absolute cell reference question
  769. text colors
  770. SUMIF on Fill color
  771. PROTECT SHEET AND SEE MY CUSTOM VIEWS
  772. How to I create a frequency distribtuion?
  773. 2 Conditions True, Many Variables, Return Result
  774. IF FORMULA
  775. Excel will not include all of my non-adj ranges in a named range??
  776. how do I maintain my conditional formatting when filtering cells?
  777. submations ?
  778. convert measurements
  779. Delete ENTIRE row after updating info in worksheet.
  780. How to generate a random list of weekDAYS between two dates?
  781. Using single cell reference as table array argument in Vlookup
  782. cross reference two spreadsheets using MS Excel
  783. can you have randbetween not RE-calculate?
  784. How do I auto save worbook at end of line
  785. How do I conduct linear regression in Excel with more than 16 x's
  786. Using/referencing custom lists
  787. How do I bring hyperlinks forward using lookup?
  788. IF Formula
  789. IF FORMULA
  790. circular reference when using a UDF
  791. Excel should enlarge the current selected row for easy reading
  792. Dependent List- Data Validation
  793. copy and paste with 2 different workbooks problem
  794. IF Function: Lookup value needs to reference other worksheets
  795. Can Excel cell formatting be included in an IF statement?
  796. remote links
  797. Enter comments in a protected Excel worksheet
  798. How can I choose a date from list with an agrument?
  799. SOS - My formulas aren't computing down my rows but copying same
  800. UK Tax & NI calculator 2005/06
  801. Counting shaded cells
  802. Why won't my tab key work?
  803. Help
  804. Cross platform worksheet issues
  805. IF Formuala
  806. how to use if function to calculate common cost in income stateme.
  807. Incrementing a formula by X number
  808. Zero Values in worksheet functions/formulas.
  809. Median result used in formula gives incorrect result
  810. Pivot Table keep apart cells text that I've formatted as numbers
  811. Fixed Random Numbers
  812. repeat function???
  813. Sum Count of Numeric Criterion
  814. Conditional Formatting Cell < Today()
  815. Calendar
  816. Drag down method for getting data from another worksheet at every Nth cell
  817. Protect Individual Tabs Uniquely
  818. VBA Question /
  819. Help please!!!
  820. I want to put page no in a single sheet in excel while printing
  821. help with search
  822. copy and paste code problem
  823. Comparing Two Worksheets
  824. Help!!!
  825. Formula help please
  826. excel formulas
  827. Combo box using pivot tables
  828. oddlprice formula
  829. enter numbers in blank cells
  830. Count of Unique values
  831. How do I use VC++6.0 to protect a excel file to readonly
  832. How do I insert a picture in an Excel comment block
  833. I need help
  834. How batch calculations?
  835. Share workbook
  836. remove text that pops up with combo box
  837. SUMIF - 2 conditions - with references
  838. copying names to list depending on certain conditions
  839. Can Vlookup look for values in another worksheet
  840. Create Formula for calculating Little League Age...
  841. How can I prevent access to code contained within Tab
  842. Positives and Negatives
  843. Can Excel Find and Copy a row of data?
  844. How can I sort by numbers and not text?
  845. formulae have stoped working on an excel sheet
  846. Question about deleting rows from sorted linked worksheets
  847. NORMDIST(x,mean, stdev,false) vs f(x)
  848. How do I get all numbers or cells on entire sheet (/1000)?
  849. how do i filter multiple columns
  850. Highlighting row from hyperlink?
  851. reference to multiple lines
  852. HOW DO I SET UP A CHART WITH FAMILY IMPORTANT ADDRESSES, NUMBERS,
  853. compare values
  854. Increasing distance labels using drag down method
  855. How do you ignore hidden rows in a SUMIF() function?
  856. Finding number of values in a range on a per year basis
  857. sumproduct-can fill down change column reference?
  858. How do I use multiple criteria with sumif in Excel?
  859. solver problem
  860. specific date function
  861. What function to use? VLOOKUP?
  862. Excel Outlines
  863. how do I link worksheets in the same workbook?
  864. Excel Spreadsheet - Formatting Dropdown lists
  865. How to report value of zero if calculation goes negative
  866. Needed help with if function
  867. How do I set up a repeating formula in Excel?
  868. How to sum the values of a single cell from multiple worksheets
  869. VLOOKUP Mystery
  870. Looking up a string of text within a string of text
  871. Transposing Sun and Moon rise and set times...
  872. Calculating Dates in Terms of Months
  873. Help pulling info from other sheeting withing a workbook.
  874. Formula Being treated as Text
  875. #value!
  876. Using the Hyperlink Function and finding filenames
  877. sumproduct won't accept wildcards
  878. INITIAL FORMAT SETTINGS
  879. Array help please
  880. Calendar Array-formula
  881. Help required with Consolidating Data
  882. Quick Explanation
  883. How do I give a name to my group?
  884. Opening a Title Page
  885. Even more Complex COUNTIF functionality
  886. Cell phone tariff checker design help
  887. Help anyone???
  888. Formulas are getting too complicated
  889. Time Calculation
  890. Exel Worksheet Protected With A Password
  891. Coverting time
  892. Worksheets won't merge!
  893. moving the contents of a cell
  894. complex function
  895. ARRANGING DATA IN PIVOT TABLES
  896. Function Help
  897. to sum times
  898. Tabbing
  899. Combine rows clms stay the same HELP
  900. FIND - Double entry
  901. formula too long
  902. dynamic dates
  903. Calculating a Date for the Future
  904. keeping two lists synched
  905. rounding formula
  906. Moving, deleting, and concatenating text in cells.
  907. Decimal time
  908. multiple criteria in if or sumproduct
  909. how can currency be displayed as words
  910. Transposing Sun and Moon rise and set times...
  911. Spreadsheet merging problems
  912. How do I update Column #1 based on specific value of column #2?
  913. In Excel 2003, under the File menu the Permission link is missing
  914. over 65500 cells?
  915. Vlookup return multiple columns
  916. Modifying a Formula / OR Question
  917. If
  918. Copying (Master) column to another sheet to automatically update
  919. Looking for formula for lowest costs, excluding zero
  920. Inserting Automatic Date
  921. IF formula
  922. Counting filled cells in excel
  923. text editing function help
  924. Excel should let me format worksheet tabs in multiple rows.
  925. AVERAGE Row of Numbers and Return Corresponding Numeric Label
  926. dynamic worksheet reference
  927. Inserting Pictures in a protected worsheet
  928. Match function multiple items
  929. Copy/import advanced excel worksheet
  930. removing a space between words in a cell
  931. Averages that include cells with IF statements
  932. automatically close hyperlink with back button
  933. Ranking Data
  934. how can i save my macro if i want to reuse
  935. The SEARCH function and parsing data
  936. Finding people born in a given month or after a given year
  937. Prompt user to create routing slip
  938. How do I autosum text?
  939. if statements & dates?
  940. Parse a Workbook-Newbie
  941. Spreadsheet
  942. if function
  943. How do I calc interest when using multiple dates within a given ye
  944. exclude data from count
  945. How do I copy data from one column to another without overlaying?
  946. I need assistance setting up a "IF" statement
  947. Time change
  948. 401 k formula
  949. How to protect the share workbooK
  950. Formula array adaptation
  951. Sum, several different sheets in the same workbook
  952. Simple but I don't know how...
  953. VLOOKUP Returns #REF
  954. IF Function
  955. updating source cells
  956. How do I replace data in a cell in Excel?
  957. creating new functions
  958. VLOOKUP to return multiple rows
  959. how to change the default formatting of comments in excel?
  960. Please help. Very simple but I don't know. :)
  961. Locking cells in Microsoft Excel
  962. Tab/Enter key moves to next available cell in protected worksheet
  963. COUNTIF or SUM function (Multiple criteria) HELP!!
  964. cell change event
  965. Formula Help - Easy for somebody
  966. 401k formula
  967. Probably easy but I need help!
  968. set up a macro in Excel to color cells when clicked
  969. Copying a Blank Cell
  970. Error in lookup function
  971. question about a basic formula
  972. if formula
  973. how to create constaints in solver
  974. Help with LARGE formula with multiple worksheets
  975. Copying formulas too smart for itself...
  976. How do I formula a percentage with text values in the data field
  977. Calc End Date
  978. using ============
  979. Describe high/low range with CountIf (ex. count if >90 and <100
  980. Describe high/low range with CountIf (ex. count if >90 and <100
  981. Why is data automatically copying to all worksheets?
  982. how do I count a rota with no dates and using 24 hours clock
  983. SUM cells together based on 2 criteria
  984. linking sheets in workbook
  985. Problem with Formula
  986. Pivot table limit
  987. first positive value return date
  988. Can changes to a worksheet be applied to all wksheets in wkbook?
  989. sumproduct
  990. find partial values in cell
  991. macro or function
  992. Autorecovery
  993. This will test you!!
  994. data analysis option not visible
  995. asking again, macro to insert rows
  996. TImeIn-TimeOut-TimeIn-TimeOut-HoursWorked
  997. Searching an Alphabetized list for data, then RESORT
  998. How do I enter cell references in "Equal to" box in solver
  999. Drop Down LIsts
  1000. vlookup