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. Working Weeks
  2. Helper Formula To Identify 1st Instance of a Value
  3. Compiling Data
  4. UPDATING IMPORTED DATA
  5. Why can't I use SUM when pasting HTML code into new sheet.
  6. Nested SumIf statement
  7. jbf frylock
  8. Need help calculating overtime to date
  9. Generating a report
  10. How to autofill strings
  11. How can you remove a redudant Excel link
  12. Pivot Table Field Data
  13. Countif Function, complex criteria
  14. Help me write a function please?
  15. D1: '=A101', D2: '=A201', D3: '=A301' how to do this...
  16. COUNT IF - MULTIPLE CRITERIA
  17. Split email address into seperat columns
  18. Conditional Formatting x Draw (Circle)
  19. vlookup formats
  20. Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?
  21. Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?
  22. Client list price update
  23. validation
  24. Formula to pick out number values
  25. Strange Vlookup problem
  26. MODE() is there a way to return bi-modal or multimodal results?
  27. Help with a complicated search function in Excel
  28. average and stdev from groups of data
  29. Date help please
  30. Pivot Tables
  31. How to show negative percentage?
  32. Enter Comment for an Entire Column
  33. Count between dates by type
  34. Totals by type between dates
  35. Keeping the exponent at a fix value in Excel
  36. Excel Sort Tie Breaker
  37. How to combine data from two columns into one column?
  38. Sunday to Saturday weekly foreward planner
  39. Dialogue with Java
  40. Totals based on meeting multiple criteria
  41. Losing the #DIV/0!
  42. How to show zero for #DIV/0!
  43. How Do I Add Dates in a formula?
  44. Combining Data from Multiple Columns
  45. Resource Planning - How to Model?
  46. Lookup word and value
  47. How come I only get 4 variables shown on my data table in chart?
  48. SUMIF non-contiguous range
  49. How do you delete a List?
  50. Lookup in one column, and return value from another column
  51. Converting Rows into colums(Urgent)
  52. Keeping the exponent at a fix value in Excel
  53. To add a label name on several sheets
  54. To add a name of label on several sheets.
  55. How to use HLOOKUP or other command to find a value within a range
  56. IF formula question
  57. One workbook file will not open in Excel
  58. CAN I GET MY ANSWER THROUGH E-MAIL IF YES WAHT IS THE E-MAIL ID
  59. Need help with A 3-D reference type formula (real novice here)
  60. How to show negative in cell?
  61. Looking for another way
  62. A URGENT problem about the array functions =TABLE
  63. Cannot Reference "Array" in Subtotal Function
  64. Need macro to copy a list of named cells between worksheets
  65. Re: how do i do this?
  66. Re: how do i do this?
  67. Currency, Percent and Comma Style buttons
  68. Web Query: Obtaining source link from a cell
  69. how do i do this?
  70. Hiding zero values
  71. Staying it its own directory.
  72. Keeping an acculumative total in a row and only that row.
  73. Using an "IF" Function between 2 Worksheets
  74. sort
  75. Maybe VLOOKUP ??
  76. Vlookup with multi values
  77. Keeping the exponent at a fix value in Excel
  78. Showing today’s date when the Excel value is zero
  79. Excel cash flow formulas
  80. Worksheets
  81. convert number to letters
  82. Excel Question
  83. Format\Conditional ? help
  84. credit calculations
  85. Merge two form to One
  86. formula help
  87. GMT/UTC considerations
  88. Formula to add top 4 entries in a column and total them at the bot
  89. Can I create a drop-down list that will reference other drop-down
  90. move one cell up from result cell
  91. How do I create multiple worksheets from Page Pivots
  92. total a time column that is formatted as ddd:hh:mm:ss .ddd=days
  93. replace value in excel?
  94. Lookup cross Drop down/scroll box
  95. Copy variable ranges fron difernte shets
  96. I cant see my excel spreadsheet but only in Print Preview?
  97. How do I repeat rows that are not connected?
  98. Finding Asymptotes from a set of data in Excel
  99. I need function that can list the "top ten" highest results
  100. Selective summing of table items?
  101. Subtotals
  102. How to sum a row of cells containing an error message to overlook
  103. random number generation
  104. trying to open a lotus file in excel, it won't work
  105. Is there a way to...
  106. splitting data from 1 column into multilple?
  107. find&replace macro
  108. Please Help! vlookup & match with multiple variables
  109. Can you call functions between sheets in the same book in excel?
  110. Rounding Up or down to 1/2 Units
  111. AUTOMATIC UPDATES
  112. Averages from 2 columns
  113. I'm not even sure if this is possible anymore!
  114. Resource Planning - How to Model
  115. Search Word
  116. How do I set up a price sheet in excel.
  117. Web Link in Cell
  118. What is the formula used to keep track of totals for a column?
  119. Using and IF functio between 2 worksheets.
  120. looking for name of cell
  121. conditional formatting to multiple cells
  122. VLOOKUP
  123. how can i do a conditional format in a PivotTable?
  124. Running a query and/or 3D Referencing
  125. How do I copy a formula to another cell
  126. Save Worksheet vs Workbook
  127. Sumproduct Help
  128. GetFormula function- Need help showing formulas only-
  129. vlookup and microsoft access
  130. Links in Excel
  131. CONCATENATE text formula
  132. Basic VLOOKUP Help
  133. Changing multiple formulas at one time
  134. How do I use an "IF" formula using dates in excell?
  135. How do I populate a cell with another cell's value based on condit
  136. can excel automatically enter the date data in a cell was entered
  137. rounding down another cell with a formula
  138. Weighted Average - Copy Function
  139. Averaging the top 2/3 highest numbers
  140. Conditional Formatting not giving correct answer...
  141. calculate month
  142. Indirect does not recognize full server path?
  143. flexisheet problem
  144. excel 2003
  145. Macro to Name Tables
  146. Autofilter SORT that Ignores Forced Blanks ("")
  147. Simple Function question?
  148. repeated use of edit/find without closing to change records
  149. display formula instead of its values in some cells
  150. formulas spanning overlapping years
  151. Time differences in excel
  152. sumproduct help
  153. I am looking for a calendar with weeknumbers.
  154. merging the layout only of 2 cells
  155. Lookup min max values
  156. print highest character number
  157. Updating tables!
  158. Calc mode display on worksheet
  159. formula help please
  160. Validation List
  161. group multiple data in different sheet
  162. Excel Help Needed!!!
  163. How do I set a minimum result value in an Excel formula? IE >100
  164. Validaation List
  165. Calculation help
  166. Criteria problems in the DSUM function
  167. Selection sticks in Excel
  168. lookup and show all results
  169. Can't install add-in
  170. Searching a Range for a number over 40
  171. searching for repeating text
  172. What does the second parameter in ACCRINT do?
  173. Converting All Caps to Proper casing
  174. add new value to exhisting, (cummultive)
  175. How do I sort a column of IP addresses ?
  176. Round X.50 and less down, X.51 and greater up
  177. Calculated Pivot table field on YTD £(subract Mar-feb)=month
  178. Parse data with uneven lengths and different delimiters
  179. How do I compare two columns contents for differences
  180. Move Data from rows to columns...
  181. COUNTIF - I THINK
  182. Complicated
  183. Sumprodruct
  184. NOSMSDIST Limit
  185. Data Validation
  186. HLOOKUP last match in a table
  187. Step through a row of data
  188. sumif or sumproduct
  189. Locate first number that exceeds reference value
  190. Protect Area
  191. constraints
  192. Greater than formula
  193. Summary Based on Multiple Criteria
  194. Excel Project rollover for 2006
  195. Another Series polulate question
  196. Copying formulas to a different file without path in the formula?
  197. If statement help please
  198. I need help desparately with PROPER formula...
  199. Series Formula Help
  200. How to hide columns that are not filtered?
  201. How can I set a minimum value of zero or -100% in a cell?
  202. Emi & Fv!
  203. Ghost numbers in blank cells
  204. Removing a word
  205. Muliplying a number by a blank cell
  206. How do I set up a nested SUMIF formula for a number of variables?
  207. Sort Macro to Exclude Blank Rows?
  208. Bi-Weekly Timesheet Template
  209. Validation drop-down lists
  210. Re: Need help with some data manipulation - to Biff
  211. i need to get totals in diff catagories
  212. Formula Help - please
  213. Validy check in one coulmn to limit input options in another?
  214. How do I update a drop down box in Excel?
  215. Use Tab key to move between tab sheets
  216. Data Validation Help
  217. IF / Else Format help needed
  218. how do I calculate hours spent x an hourly rate?
  219. Lookup help
  220. How do I calculate a difference in work days?
  221. XNPV vs. NPV(quarterly) different results
  222. Purchase order & Invoicing
  223. how do i get my spreadsheet to give me tank gage amounts.
  224. VLOOKUP Questions
  225. Setting up a condtional function that....
  226. DATEVALUE & Empty cells
  227. automtically change ranges in formulas when new data is entered
  228. Calculate percentage of time period
  229. SPREADSHEET DATA
  230. Substitute Formula
  231. Sumif help please
  232. calculating the years
  233. How do you create formulas in pivot table eg simple division?
  234. FORMULAS
  235. Where are my gridlines?
  236. Excel Help Needed
  237. Unique identifier
  238. Pocket Excel - Loss of formats when transferring
  239. cell reference from hlookup
  240. sumproduct problem
  241. dependent rows
  242. COUNTIF
  243. Group and Outline Adjacent Columns
  244. Convert 1 688 090,69 to normal numeric value
  245. Problem with whats Returned
  246. draw a floor plan to scale in excel
  247. Setting page length in Excel 2003
  248. Active Cell when opening workbook
  249. Combo Box Functions
  250. I’m trying to remove blank rows in an Excel spreadsheet Printout
  251. Sort and New sheet help
  252. Propogating next available field
  253. Convert function
  254. Smart Tags and Stock Symbols
  255. How do I remove a function?
  256. SUMPRODUCT Question
  257. Counting Entries by Month and Year
  258. Can you auto-trigger a sound file to play when a worksheet opens?
  259. Construction Loan Interest Formula
  260. Find the date for monday prior to May 25th
  261. Date function in Excel that updates only when a doc is changed?
  262. format for 30 years amortization?
  263. Sumif?
  264. View formula results
  265. How do I get the cell address of a VLOOKUP reference?
  266. I need to enter > 10 chars to left of decimal and > 5 to right.
  267. How to Destoy Links
  268. Merge and sort two pages
  269. Excel Byte Calculation
  270. Can I create a hyperlink to another page and then FILL series?
  271. reverse vlookup
  272. Sort by conditional formats?
  273. List Validation and Format
  274. =now()
  275. Conditional Formatting For A Cell Other Than The One With The Form
  276. "Can I create a subtab in a tab in Excel worksheet?"
  277. Lookup based on fractional value
  278. Find first threshold violation
  279. Need help with some data manipulation
  280. Pivot Tables Sum of Unique Text Entries
  281. Hidden Values
  282. How can you identify duplicate entries in a singe column?
  283. Count certain months
  284. Compare Sheet Cell to Sheet Column
  285. moving a macro to a new workbook
  286. Adding an OR to SUM(IF....
  287. Re: find sum in list of of numbers
  288. Hide cell value conditional on its value
  289. How to replicate 1 range to muptiple ranges at once?
  290. New data will not sort with existing data from copied file
  291. drop-down list changing according to choice made
  292. Re: find sum in list of of numbers
  293. Adding relevant sheets
  294. Total TIme worked
  295. A function to make date red if it is over 30 days old
  296. RE: find sum in list of of numbers
  297. Function to calculate the interest of a mortgage
  298. Search range of cells, find a value, output adjoining cell. How?
  299. want to ask salutation on a mailing list.
  300. Excel 2003 - SUM Formula - exclude cell
  301. Sorting Data Automatically
  302. Sheet Protection Status
  303. custom worksheet functon is changed to lowercase
  304. how to change a date format
  305. Microsoft Map Object
  306. List Dropdowns Disapeared
  307. Rounding Up Decimals
  308. DIFFERENT NAMED CELLS IN COLUMN,HOW DO I GET LAST ONE ON BOTTOM?
  309. How do I get Exel to return # of hrs. worked, start time is enter
  310. help please
  311. Format\Formula Help
  312. Convert $ amount from excel to access? No decimals but 00 at end
  313. conditioned functions
  314. conditioned functions
  315. How do I get rid of the Page # on screen
  316. TIME
  317. Date Text
  318. Defining Cell namse after they are used in a function
  319. I get error with "ROWS" in the formula - nested formula question
  320. How do I add using several worksheets
  321. Offset formula
  322. how to get left or right cell info after getting the result for ma
  323. countif, sumif, sumproduct - I dont know which to use
  324. Maintain mutliple original formats in a formula result
  325. Return alternate value if VLookup can't find match
  326. Can I delete multiple blank rows collectively?
  327. SUMIF with 2 conditions
  328. Ms Excel coursework
  329. ISNUMBER
  330. Lookup array?
  331. Vlookup problem
  332. how do write the amount of a number in text?
  333. Comparing scenarios/forecasts in Excel
  334. IS THERE ANY PIVOT TABLE DROP LIST FUNCTION?
  335. =SUMPRODUCT formula help
  336. Adding to a column of numbers
  337. Matching Values from an Array
  338. help
  339. help
  340. help needed
  341. How can I identify the two lowest values in a row?
  342. Summary of multiple spreadsheets:
  343. Help with a combination of formula's
  344. how do i copy only the coloured filled rows in excel to new sheet
  345. Update Chart Source (w/macro?)
  346. Maintain Relative Reference After Inserting a Column
  347. How to calculate CAGR for mutual fund performance using XIRR
  348. How do I create a commission chart based on dates worked?
  349. Summing part of a string excluding cells
  350. Repairing link roots when moving worksheets
  351. summing part of a string, excluding cells
  352. How do I compare two lists and choose the items that are in both?
  353. Countif - Buying Frequency
  354. Using Excel for a Mail Merge
  355. Counting Using Multiple Criteria
  356. If it's not a space, return the cell contents.
  357. How do I assign a value to check box in excel
  358. subtotal question?
  359. Adding a date to calender to automatially generate another date?
  360. piviot table
  361. customized template w/formulas
  362. Find Macro across workbook
  363. Formula for determining sales commission
  364. Emailed a "shared workbook" but it never came why? (AOL?)
  365. Creating Tables From Multiple Worksheets
  366. If/Then calculate the average
  367. Will a Nested IF/SUMIF function instead of VBA?
  368. rounding up after SUM
  369. formula is not working
  370. Chart pop-up
  371. TRUE/FALSE
  372. My worksheet menu bar has disappeared?
  373. Naming cells...
  374. Search, Copy, Paste Macro in Excel
  375. Limiting Entries in A List Box
  376. Positioning Numeric Values Resulting from 6 Column Array Formula
  377. userforms broblem
  378. When I type a constant number I want another number to appear.
  379. Copying A Worksheet From Each Open Workbook to an new Workbook
  380. Print Macro Error
  381. If/Then Statement
  382. printen userform problem
  383. How do I copy a cell all the way down a column w/o mouse?
  384. Conditional based on error
  385. Randomize rows
  386. Output in Column A based on Input in Column B
  387. advenced filter (yardım)
  388. Copy Value not formulas
  389. cannot shift objects off sheet after using Subtotals
  390. Lookup Two Columns
  391. Excel COUNTIF function
  392. Insert a footnote or endnote in Excel
  393. Protect cells
  394. counting consecutive absences
  395. Decimels conversion
  396. Highlight birthdays
  397. 2D sumif loop?
  398. Array Formula?
  399. Turning off date formatting
  400. Change over time fornula
  401. Countif formulas change after doing a sort
  402. Fill cells with color based on criteria in two cells
  403. change font to validation drop lists
  404. Font change for dop down validation lists in excel 2003
  405. Absolute formula moving
  406. bug in dates?
  407. countif
  408. formula help, sorting information
  409. Time Formula
  410. Office 2003 Stock Action Add-In - Stock Handling Capacity/Numbers
  411. In several cells I have =?+423.55 I want total w/o the 423.55.
  412. Is it Possible
  413. sumif more conditions
  414. A little help with a conditional formula, please.
  415. Pivot tables
  416. I need help setting up a financial formulain in Excell
  417. Lookup
  418. Fill Cell to the right
  419. summing columns
  420. How do I convert excel xp worksheet to excel 2000?
  421. enumerate sheet
  422. Index, Lookup and Vectors/Arrays
  423. can I change the $ sign to a £ sign in an MS template?
  424. How can I add more than 800 days to a given date
  425. Formula Guidance
  426. Formula help - please !
  427. New question, Old problem
  428. Sales tracking report
  429. Formula Help
  430. cell display sheet name
  431. How do I add one to a number everytime I open the same workbook
  432. How to show the formula of another cell
  433. changing colors of font in functions
  434. Copy hyperlink from one cell to/as hyperlink in another cell
  435. Matrix to single column
  436. Nesting of sumif formula.
  437. if =0 ""
  438. time again
  439. Circular Reference
  440. Refer to more than one worksheet in a workbook
  441. Copy worksheet & maintain cell reference across worksheets
  442. Trending Formula Results by Date
  443. creating an aging report
  444. Need help with functionality more complex than VLOOKUP offers
  445. Integration/area under a curve VBA code?
  446. auto move cursor after entering number in excel
  447. Minimum Date Range from other cells
  448. Find the closest match to a reference number in a row of unsorted
  449. A logical test in the If function for blank, i.e., If blank?
  450. Pasting constant formula where referral sheet changes
  451. How do I stop the "Too many different cell formats" ?
  452. Assigning a value to a character (?)
  453. Converting hours to minutes
  454. Is it possible to make a cell flash between 2 colours?
  455. To Rank on two Criteria
  456. Shifting Calculated Result - Re-Issued
  457. Shifting Calculated Result
  458. Min Function Excluding Zero Values & More
  459. REPAIR COLOR FILL
  460. Happy New Year to All
  461. years change to current year
  462. Dates change the next day.
  463. Re-post Standard Deviation
  464. how to limit amount of numbers in cells in excel
  465. Modify Cell Sizes
  466. Modify Cell sizes
  467. HAPPY NEW YEAR !!!
  468. converting Dates
  469. change range of cells to another currency
  470. I sort a column, how can I have all the data skip every other row
  471. Convert MS Excel data to MS Access database
  472. Sumproduct
  473. Implied Compound Interest?
  474. What function to select the last 3 smallest integers?
  475. use of vlookup in case of multiple column check
  476. Inserting another currency rather than $ on excel
  477. Excel worksheet functions.
  478. can I execute and 'substring' function in Excel
  479. Calculating Differences Uniformly
  480. Delete A Word That Exceeds X Number Of Characters
  481. Does True Have a Numerical Value
  482. How can I protect Excel Worksheet and allow users to UnGroup Data
  483. What function to select the last 3 small values from a list ?
  484. How do I hide a value in my totals worksheet ?
  485. SUM OF TIME
  486. Array formulas
  487. Which function to check any value existed withing a list?
  488. Incorrect Counting of IF function
  489. Microsoft Excel should allow layers that can be turned on and off.
  490. Time formatiing
  491. how do i get $ signs out of a column in excell
  492. TIME function
  493. Return list of uncleared checks
  494. Using the Indirect function with a sheet number instead of a sheet name
  495. Comparing 2 arrays
  496. pivot tables
  497. Worksheet formulars
  498. When copying a cell to another cell the information is duplicated.
  499. Subtotals do not group
  500. How to refresh data analysis tool results
  501. how to compute a range of cells based on another range of cells?
  502. Conditional Formatting
  503. how to compute a range of cells based on another range of cells?
  504. Matching the same amount of records in one value to another column
  505. SUMPRODUCT - How can I use does not equal in an array?
  506. Excel Workbook Search
  507. Matching one column against another column of data to show the same amount of data.
  508. RANDBETWEEN Not working
  509. ListBox Question
  510. BLANK SPACE TO A NUMBER
  511. Pinewood deby sort
  512. look up a list and return a value
  513. What is the roundoff error in the subtraction function?
  514. Hyperlinks doing weird things when adding columns or rows
  515. How to paste COUNTIF function from cell to cells ?
  516. sum absolute values of a column of numbers in Excel
  517. Match Single Numeric Criteria and Return Multiple Numeric Labels
  518. formula displays, not the text
  519. What function to determine the second small integer from a list?
  520. Another COUNTIF
  521. how do i make a drop down list of selected names no repeatition
  522. difficult array formula
  523. COUNTtIF
  524. Easy entries short procedure required
  525. Standard Deviation
  526. Multiple row
  527. Multiple row
  528. =CELL("filename") VOLATILE?
  529. how to check if date falls within range
  530. Why does the right 'Alt' key not work in Excel?
  531. help needed with "if" statement
  532. Copying Charts and graphs to another worksheet with formulas
  533. Conditional hiding of entire rows
  534. Merge the data
  535. trim function
  536. Merging data
  537. Formula for selecting the greater of two values?
  538. This formula needs to be more compact.
  539. how do i recover a consolidated worksheet that i sorted/subtotale
  540. If Cell Value < 0, Change Value to 0
  541. Excel should let me use hidden text (like MS Word) - Thanks
  542. Lookup and Change
  543. Find, Cut, Paste and Delete
  544. Insert row number into a cell?
  545. vlookup data in a dynamic pivot table?
  546. conditional formatting
  547. Form List Box
  548. Recognizing #VALUE! as a condition in an IF Function Argument
  549. how can I sort sheets within a workbook in excel
  550. Count or Sum based on more than 1 criteria
  551. how can I use excel to automatically generate routine report?
  552. Modified Duration
  553. Match Single Numeric Criteria and Return Multiple Numeric Labels
  554. Increasing numbers in a column by percentage
  555. Want to have accumulative totals in each row
  556. Time calculations and additional 24 hour days
  557. check box function?
  558. subtract hours
  559. SUMPRODUCT USING WORDS AS WELL AS NUMBERS FOR CRITERIA
  560. Convert random numbers to text..
  561. how to use sumif function to check date in 1 sheet is < 2 sheet
  562. Add insurance to loan payments
  563. Text to Columns Question
  564. How do I keep multi-subtotals in the same order within the report
  565. Have a 6 day schedule in word 2003, can it be put into excel 2003
  566. ex.=($B$4+C4) in macros for row why adding rest
  567. ex.=($B$4+C4) in macros for row why adding rest
  568. substitute ","
  569. i want to add increments of time not time & date
  570. Can a style be applied using a function?
  571. formula for negative and positive numbers in different columns
  572. if a:a (range) equals january and c:c equals gas then add g:g ($)
  573. How do I import cells from seoerate sheets?
  574. How can I insert a drop down date picker to worksheet cells?
  575. How do I use multiple worksheets as input for a single pivot tab
  576. How do I add times that were creted with "=TEXT(A2-A1,"h:mm")"?
  577. Does excel support multi-value picklists?
  578. Is this possible
  579. Re: Merging data looking up (Account) numbers in a coloumn
  580. Greater than formula!
  581. Top 10 Text Values
  582. Terminal Digits
  583. Count rows that match 3 sets of criteria?
  584. forcing UDF to run
  585. Find and Length
  586. Special function
  587. Vlookup on a worksheet with similar values
  588. sumif wrong result
  589. multiple nested IF statements
  590. Array input in one single cell
  591. LINKED WORKBOOKS - TOTAL CONFUSION
  592. To return value that provide data to a formula
  593. separate whole words
  594. how to convert decimal numbers to words
  595. function to convert whole numbers to written text
  596. CardText
  597. Lookup One Column - Sum Another
  598. Counting Dates
  599. Compare month to month data
  600. Check boxes linked to other cells?
  601. Need help with nested function...please
  602. Making a letter equal 1 formula
  603. Look At Two Dates
  604. how can I insert a macro into a boolean statement
  605. Can I use a condition/formula to move a row to a different workshe
  606. Worksheet Locked
  607. I want to change the selected print area but it will not allow me
  608. SUMIF exluding text
  609. DesearÃ*a incluir un archivo para hacer Contabilidad en Excel
  610. automatic underlining and blue color of email addesses
  611. How do I compare 2 text columns & show differences in 3rd?
  612. Excel
  613. Multiple Sums Depending on a description.
  614. Combo Box Properties
  615. Move Data Up One Row and Add On to Existing
  616. excel function reduce and increase numbers
  617. Formula to capture historical data from data that changes daily
  618. How to delete rows using formulas
  619. Using a nested Address function for a reference
  620. Remove the paste function in a worksheet
  621. Can I automatically sort worksheets in excel?
  622. Scanning paper spreadsheet into excel
  623. Validation Help....
  624. IS IT POSSIBLE?
  625. IS THERE A FORMULA TO MAKE E=6:00PM ETC SHIFT TIMES AND HOURS
  626. HELP! need a top 10 from a list of 100
  627. Difficult (at least to me) formula question
  628. Is there a way to compare two excel files for repetitious cells?
  629. change font color on search
  630. Useing a Logrithmic y=intercept in a cell
  631. Sorting with formulaically "empty" cells
  632. COUNTIF Help
  633. Insert drop-down into a cell?
  634. is it possible ot use two or more columns as criteria in VLOOKUP?
  635. Simple, but not for me...help
  636. how do I get 8 Conditional Formats for 1 Cell
  637. Adjust Range in Function
  638. IF Statement
  639. Vlookup with 3 or more conditions
  640. What's the difference between 2000 and 2003 when using subtotals?
  641. too many characters in formula
  642. converting seconds into minutes
  643. Web Query settings
  644. Excel; how do I print titles in 'Setup' when option greyed out?
  645. Formula produces picture file...?
  646. LOOKUP Problem
  647. Vlookup in a second worksheet
  648. how do i sum day of the week without counting sats and sundays?
  649. =if or not?
  650. How to get nth distict value in a column
  651. how 2 use if/then, if/else function.
  652. How do I display time in a negative format?
  653. Loop for VBA code?
  654. IFMAX Formula
  655. Text subsequences
  656. Text subsequences
  657. Text manipulation
  658. Autofill
  659. 3D Scatter plot
  660. Multivariate statistics
  661. Timeclock Calculation
  662. FIND DIFFERENCE BETWEEN >50 AND <60
  663. Excel copy and paste
  664. how do i link specefic cells?
  665. 2 different macro questions
  666. Consolidate of data using formula in Excel
  667. Divide Column A by Column B multiply Column C
  668. re-arrange data in date order
  669. Extract sub-string of number from field of long series of numbers
  670. Sorting Text by color
  671. MS Excel
  672. Linking Merged Cells
  673. Sort Excel Column on Fifth Character
  674. MATCH function through multiple worksheets
  675. Macro VBA code to name Save-As file
  676. Can you do calculation for Row or Column for link reference first?
  677. replace a range of #'s e.g. 1.25 to 100 with text in excell
  678. MATCHing through multiple worksheets
  679. Can you do an IF function whether a cell has a fill color of Rose
  680. remove leading zero from a string..
  681. Updating Functions (Vlookup)
  682. How to sort an Excel spreadsheet by more than 3 columns?
  683. Concatenate or "&" problem
  684. url
  685. SUMIF on multiple sheets
  686. How can I get excel to show ALL lines of wrapped text?
  687. excel spreadsheet
  688. cell formula
  689. Sorting data in a cell alphabetically
  690. Sum Unique values from 31 pages
  691. Copy workbook- Validation function
  692. How do i replace #deel/0! in excel
  693. Page set up
  694. indirect returns #REF! regardless of where it is used.
  695. Linked Names in a Formula
  696. Help with formula IF
  697. Formula in Excell
  698. In a table produce an value by column heading and row heading
  699. Error messages on all programs
  700. Vlookup and #N/A error
  701. excel
  702. How do I write an Excel formula to calculate my working time?
  703. macro saving problem
  704. macro problem
  705. HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT()?
  706. Cell Address Matching
  707. Trouble with formula on Student 2006 learning essentials template
  708. can i use a cell value as another sheet's cell reference
  709. Networkdays & future months
  710. I would like to set a value for a range
  711. VLOOKUP show all results
  712. My Formula Changes on it's own?
  713. Urgent help needed!
  714. How to insert same header/footer across multiple worksheets?
  715. Merge Row Data
  716. Partial String Match Using VLOOKUP
  717. Checklist
  718. sum up the ROW values with ref to COLUMN values!
  719. How Do I Ad Columns and Rows?
  720. how do I convertext in cells a1, a2, a3 and covert to a1, b1, b2
  721. Excel dropdown with text and value
  722. match problem
  723. #VALUE! error
  724. using linest excel function from msaccess with multidimensional ar
  725. RUNNING TOTAL
  726. Basic If
  727. Searching for the presence of specific words
  728. what is the keyboard shortcut for generating a sequence
  729. Match function in a two input table
  730. Reference Cell if Found in a IF function
  731. special row in excel
  732. Open Hyperlinks at the same browser
  733. How to convert Number into words in EXCEL same or a new cell ?
  734. Convert Gig to Meg
  735. Saving worksheet so that merge cells work in previous versions
  736. calculating return in a range
  737. A:1 now R1C1
  738. lookup function
  739. How can I get a postal code in a cell - from the internet?
  740. Filter unique random number
  741. I ACCIDENTIALLY SAVED A BLANK PAGE OVER A FILE HOW DO I GO BACK T
  742. How do I highlight a cell using conditional formatting and dates
  743. excel - sort, selected rows??
  744. random number with text
  745. please i need an answer
  746. Allowing for variable cell reference in macro
  747. Need to link/combine 5 worksheets into 1 (inventory nightmare)
  748. Drop down box of names with fixed values?
  749. Can I break and restart a link in a macro
  750. COMPARE CELL CONTENTS
  751. compare cell contents
  752. Excel recalculates on startup?
  753. wHAT AM i DOING wrong
  754. Importing data, and need formatting advice
  755. Reference a workbook with only a partial name
  756. Correlation Matrix
  757. Importing relative positoin information
  758. how do i model discounts in excel solver
  759. Conditional Formatting
  760. Date formula
  761. totalizer formula
  762. Error formula too long
  763. how do i set up a calendar selection in excel
  764. Duplicate rows forever...
  765. Designating a workbook reference base on a cells contents
  766. Formatting web imported data correctly
  767. min or max results
  768. How do I create a random sample from a list?
  769. How to count several non-adjacent cells
  770. Keeping cursor in same place on all worksheets in a workbook
  771. generate word file from excel
  772. Escape character for double quotes
  773. Crossreferencing values between 2 spreadsheets
  774. use of "if" based on text in another column
  775. Is there a function to copy an entire worksheet?
  776. New Worksheets in a template to be pre-formatted.
  777. random numbers
  778. Insert file name in cells
  779. How do I create a worksheet within a worksheet in Excel?
  780. character limit in hyperlink function
  781. How do I show the low-price supplier from seven different quotes?
  782. THE > SUPER-MONEY-SOURCE <
  783. How to avoid duplicate characters if only typed once?
  784. Lookup help, please
  785. Countif Question
  786. Allow Edit Prevent Delete
  787. Can't add pay rates
  788. Time calculation
  789. Criteria in SUMIF
  790. Determine if Cell Address is within a Range
  791. keyboard equivilent of the right-click
  792. Pivot Table Question
  793. Tab Stops / Tab Order
  794. Text to value
  795. how do i use the vlookup with two references ?
  796. functions
  797. Run macro based on time
  798. CAPITALIZONG FIRST LETTER OF EACH WORD IN A TITLE
  799. IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003
  800. Data Validation Function Help
  801. Hyperlinks in a drop down menu
  802. Multiple Sum, based on criteria
  803. networkdays problem
  804. Changing today's date to the first of the month
  805. Formula to use to count instances of in Excel
  806. How do I count rows in a filtered list when using AutoFilter?
  807. Conditional Formula
  808. DUPLICATE RANKS
  809. How to get auto change of name (word rama should be ram automati)
  810. Average a set of figures which ignores 0 entries
  811. martrix help
  812. Pivot Table data source
  813. can you put radio buttons into an excel work sheet? and how?
  814. Multiple criteria LOOKUP
  815. Function triggering a macro
  816. Conditionally formatting highest valued cell?
  817. In Excell-2000, database how do you extract unique records
  818. adding accross sheets in a workbook
  819. Data Validation w/ exceptions msg box
  820. sorting
  821. links in excel change destination after sort
  822. formula linking "like" text
  823. Coments
  824. lookup serch term and return sum of all values
  825. Averages
  826. How do I calculate the root of a number using Excel?
  827. Importing Data
  828. Column Width
  829. Average of a >, < range
  830. Letter Counting Function
  831. CountIf formula results in the formula itself being displayed.
  832. How can I change 255 character limit in 'hyperlink' function?
  833. Code to protect sheet
  834. lookup? list data into summary table
  835. Index and Row
  836. how to do normality test in excel
  837. Pivot Table formatting
  838. How do I enter formula that adds a range if less than a number or
  839. Excel System Error???
  840. How to Sum Up sales data by a product category from anther sheet
  841. Protect Sheet with Marcro
  842. Conditional formatting
  843. Two cell Comparison with three different Criteria
  844. How to Sum Up sales data by a product category from another sheet
  845. Excel should have a formula to convert number into words
  846. Week/month/year rollovers with PivotTable
  847. Counting cells with formula CF (not value CF)
  848. Getting the Check Register Balance to show on another Sheet
  849. Greater than, smaller than formula
  850. Need help in numbering a column while skipping lines
  851. Daily Totals on a summary sheet
  852. vlookup
  853. Transfering colours
  854. how do i transfer an excel file from one computer to another
  855. Excel passwords are changing when two workbooks are open.
  856. Counting consecutive periods
  857. HOW DO YOU INSERT A MACRO INTO A FORMULA
  858. How can I automatically highlight a cell that has changed value
  859. Trying to move a number in every 2nd column into a new worksheet into one colum, how would u do that? thanks
  860. Data Validation
  861. Matching data from 2 columns
  862. multiple individual comments in one cell
  863. Month day confusion
  864. Hoe krijg ik = i.p.v. fx / werkte vh met oudere versie van Excel
  865. Suming values from a xls file
  866. Average if
  867. Excell-How to add the number of cells containing text? = a sum
  868. I forgot my password in a protected column, is it hidden somewhere
  869. Drop-down list & auto-population of cells
  870. count duplicate records in a group
  871. Sum multiple text
  872. How do I add totals up from different sheets? A running total.
  873. Random search
  874. Conditionally calculate formula in spreadsheet.
  875. New Year
  876. How can I use a defined name in a header or footer?
  877. Extending Row()
  878. How change "535?4090" to "535-4090" using replace
  879. convert number in cell to text in another cell
  880. synchronization ?
  881. the numbers are always in text and i cant seem to change them???
  882. Conditionally ignoring certain cells in columnar calculations
  883. Format monetary amount to 9 digits with No decimals without rounding
  884. Copyright in Footer
  885. Vacation accrual based on hours worked - Excel 2003
  886. Can i "filter" in excel by words in Bold?
  887. Splitting an Excel cell
  888. Restructuring records into a list
  889. Find the Cell Reference Resulting from MAX function
  890. Using Max & keeping other data
  891. How do I track dates?
  892. Truncating a text string
  893. group same
  894. Excel - print 2 pages on 1 sheet of paper
  895. Calculating a colmun to total a 40 hour work week
  896. sum calculation
  897. If statement to avoid Creating Circular Reference
  898. get back to day one based on current date
  899. Conditionally formatting other cells?
  900. replace formula
  901. test for "special characters" in text
  902. How do I Hide frozen panes when printing?
  903. Adding a Baseline Value into my existing column graph.
  904. show a block of info from a list on another worksheet
  905. How do I use cell contents as an address in a formula
  906. conditional formatting and timelines
  907. find the value of the last digit in a cell
  908. Calculate Term
  909. Calculating total work week hours
  910. Linking Data from 1 sheet to another sheet
  911. Syntax for IF with multiple criteria
  912. Calculated fields in pivot tables
  913. Copying text from a free form field
  914. Index Row
  915. Summarizing data based on ID
  916. Pivot Table Summaries
  917. worksheets
  918. Need to rebuild formula using the value entered into a cell on the
  919. Calculating market growth rates
  920. Rank by flight
  921. Urgent! Somebody Pleez help!! Inventory Valuation
  922. clear all except formulas, conditional formatting and validations
  923. Watermark
  924. summing characters in a string
  925. vLookup - display multiple rows
  926. Correcting a #REF!
  927. Changing Imported Date Formats
  928. Changing Imported Date Formats
  929. Gaussian Elimination
  930. European Average Weight Legislation Formula
  931. creating a date column from seperate data
  932. worksheet linked to a cell
  933. Protect hide worksheet
  934. Vlookup accross multiple worksheets
  935. Wildcards
  936. How do I get rid of formulas?
  937. empty cell equivalent value
  938. lookup with a formula
  939. reset option buttons
  940. Assigning values to letters
  941. Autofill Date/Time
  942. formatting number value to text value in excel
  943. Add/Replicate Text In Cell Entry
  944. Select from List of names to equal a specific rate
  945. Multiple Functions In One Column
  946. Sumif across multiple worksheets
  947. how do I find my old questions
  948. Value returned from Formula changes with the Date
  949. How to write the formula for time accounting for a work schedule
  950. count records meeting three criteria
  951. Excel Macro Question
  952. Division by Zero Error
  953. Auto Filter Subtotals
  954. time stamp
  955. Returning next value from a list
  956. Conditional Formatting when inserting a row
  957. Locking A Formula In A Cell
  958. Select Largest 5 in A, AVG values in B
  959. Advanced Filter criteria (formula)
  960. Adding numbers in a column results in zero: why?
  961. Get rid of the zeros?!
  962. help.. too difficult to put into words
  963. Spreadsheet performance is slow
  964. Can Excel count the number of scores within a range?
  965. What is the Formula to find the Media of a number of cells?
  966. How to find if a date falls between 2 dates
  967. If columns match
  968. Multiple sheets as data for a single sheet
  969. synchronizing (?) two worksheets
  970. Simple Question
  971. When using Autofilter on Excel, how do I ignore 1st 1 or 2 rows
  972. Lookup function or something like it...
  973. Cascading Lookup Functions?
  974. VLOOKUP result is not showing up - only the formula
  975. Sort text list alphabetically using a formula
  976. static data consolidation
  977. sum limit and marking
  978. Removing "Save As" Command from an excel file.
  979. If Statement and Dates
  980. valuing a labelled odds formula '15/8 I want result 1.875 ??????
  981. date format and the RIGHT function
  982. date format and the RIGHT function
  983. date format and the RIGHT function
  984. Combine 2 Data Validations Q
  985. HOW CAN I CONVERT NUMBER IN A CELL TO TEXT EG: 100 TO ONE HUNDRED
  986. inserting sheets into existing workbooks w/o external references
  987. Columns and Rows
  988. How I sort data in Excel, it keeps saying "merged cells must be ID
  989. Link to Cell Not Updating
  990. Allow to "wrap" columns of data in Excel.
  991. how do i use more than 3 conditional formats settings???
  992. Totalling Collumns
  993. Suppressing zero value display in print-out
  994. find selling price of bonds
  995. getting value 1 column to right of cell selected in pulldown
  996. count and display unique values
  997. I am trying to match 2 lists
  998. [R2]*-1 HELP
  999. Cant Get IF(ISBLANK) to work
  1000. IIF issue