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. Formatting Cells
  2. how to link two worksheet with different criteria
  3. Help Required
  4. Replace VLOOKUP results with data
  5. Conditional formula miscalculating blank cells
  6. need help :D
  7. merging text and data fields without loosing zeroes ie .00l
  8. How can I create multiple random bingo cards in excel?
  9. Need a formula to 'find' word in cells of column from a long list
  10. how to sort two equal numbers
  11. Detect strings in a range
  12. How input today's date and keep that date
  13. SAME RANGE...DIFFERENT FORMULA
  14. Formula for subtracting from same number
  15. Football Pool Function
  16. Count of Names in Column A
  17. VB
  18. how do i sort a worksheet data to show repetitve data and show
  19. need a calculation for browsing centre
  20. Using MATCH
  21. How do I round a 4 digits number to it's nearest 10
  22. Sort issue
  23. Complicated Formula
  24. How can I put in Date & have the Day come up
  25. Tough Formula question
  26. help with formula
  27. in 2007, how come the sort does not default after I save a file?
  28. Tool for XBRL
  29. Help With Calculating Weeks
  30. Condtional Formatting
  31. CELL UPDATING
  32. formulas/data validation
  33. Problem with using match function
  34. Calculate month & year in between two dates
  35. Calculate month & year in between two dates
  36. how do I creat a table of medians based on a second field?
  37. What function do I use to summarize data levels on three sheets?
  38. formula to remove formula???
  39. Sumproduct 'Or' Condition
  40. Function argument not returning a value
  41. Saving Worksheet "Name" in a Macro
  42. Nested formula help
  43. Can surplus decimals be omitted when adding derived figures?
  44. searching and copying
  45. Quote Numbers in Excel
  46. if function difficulties
  47. Copy Data from Row 1 to last blank row in next worksheet
  48. How do I print preceding zeros in excel?
  49. HH:MM:SS to decimal value
  50. HH:MM:SS to decimal
  51. "Relative" Absolute Cell References in Excel 2007
  52. Reconciling two lists
  53. Algebra
  54. Conditional Formatting/Contents
  55. please help... on excel
  56. Annual Return Formula
  57. why do I get a warning when unprotecting a workbook
  58. Need Assist With Formula Creation
  59. macro checking
  60. Find Cells that do not have Formulas in them.
  61. Difference - except for Saturdays and Sundays
  62. worksheet for credit card finance charges
  63. Pivot table formulas based on text fields
  64. How do I call number values form one workbook to another workbook
  65. Conditional formatting by day of the date in Excel 2003
  66. Furniture Boxes moving Los Angeles movers
  67. locating cell info from one sheet
  68. Multiple Pivot Tables in same worksheet
  69. scwewy answerrs that don't belong
  70. Why does Concatenate formula show but not produce a cell result?
  71. strange conditional format behavior
  72. Download other functions
  73. Offset On 2 Columns
  74. Excel Manual Controls
  75. Protections
  76. Drop Down Menu ~ Source from Different Spreadsheet
  77. Need Formula Help
  78. Sharing data between worksheets
  79. sorting formulas with cells
  80. On a Excell spreadsheet how do I imput a formala in certain cells
  81. Excel
  82. automate date entry - update pls.
  83. Opening an add-in automatically
  84. excel function
  85. Time Format differences
  86. date picker help
  87. Where can I find old copies of a shared excel file?
  88. How to change the amount of rows that is effected when scrolling.
  89. Bloomberg overwrites data-need to save stream of data in a new she
  90. how do you set up a field to flash upon entering sheet
  91. The reply worked, but I still need help....
  92. if statement? Want to populate whats in cell or N/A if cell is zer
  93. Indirect Function
  94. Need help with writing formula.
  95. move picture to behind cells
  96. Formula to skip holidays
  97. Excel "Move or Copy" and "Delete" sheet functions
  98. date picker HELP
  99. VLookup Problem with Number format
  100. linking jpeg files
  101. lookup
  102. accessing excel 2003 functions with excel 2007
  103. EXCEL GURU WANTED - Time calculations
  104. Changing time and text format
  105. Converting hours to minutes
  106. Filter and copy to another worksheet
  107. Frequency and If with multiple Columns
  108. How to update a "master" spreadsheet every time I create a newworkbook or a new sheet
  109. Formula para excel
  110. #DIV/0!
  111. Formulas updating
  112. Copy cell to another as a comment
  113. date picker
  114. Thanks fs
  115. How can you limit the data entry range in Excel?
  116. date picker
  117. using a pda with excel
  118. Proble with using match function
  119. Tab Formula from diff sheets
  120. Week count
  121. Highlight Discrepancies
  122. IF
  123. Excel workbooks
  124. help to in setting up a proper Vlookup table and formula
  125. conditional formatting with blank date fields
  126. A "chessboard" problem
  127. How to: date field minus minutes equals new date
  128. Name Conflict Error
  129. Need some guidance
  130. Mulitple "IF/OR" statments
  131. Auto recovery
  132. Auto update workbooks link
  133. Merry Christmas
  134. Subtraction errors Excel
  135. Inserting a MS Word object into an Excel spreadsheet (2 questions)
  136. I want to create a check list with a count of entries at bottom.
  137. IF Function on a range of Data
  138. How do I default blank cells to "0"?
  139. Automatically Linking New Spreadsheets to Master File
  140. tenure
  141. Error in graph
  142. Is there a way to copy cells with absolute reference gettingadjusted?
  143. #VALUE!
  144. Hiding cell information
  145. Calculate central tendency tht are interval or ratio measurement?
  146. linked 3 pivot table pages ?????
  147. how to bind cells together
  148. Filling in color in a box based upon a variable .
  149. can i avoid repeating rows when adding calculated item in pivot ta
  150. Need IF/THEN formula for date present
  151. Automating text colour changes in Excel
  152. Macro To Sort By Column Header Names
  153. Fill Range With A Value
  154. Create A GUID
  155. Formatting a Cell Reference with a Formula
  156. How to change the currency Symbal
  157. how to email excel 2007 worksheet with outlook 2007
  158. IF statements with more than one date column
  159. copy specific rows using "IF" to another sheet
  160. Calander Drop Down Box
  161. expanding numbers?
  162. Sumif extrapolated
  163. Auto capital letter in a cell
  164. why is excell not updating my formula data within a workbook?
  165. Copy from worksheet to worksheet
  166. workaround for problem hyperlinks in Excel (doesn't work if pathcontains # character)
  167. synchronizing two woorkbooks
  168. Formula Help between 2 worksheets
  169. countifand
  170. Copy a Negative value to another WS
  171. LookUp and Match Question
  172. Function entry not possible
  173. How many rows in worksheet in Excel 97?
  174. Sorting results from the Index command
  175. Adding IF function to Lookup???
  176. Nesting named formulas
  177. Countif Function
  178. Excel Formula Range Limitation
  179. Label template for Excel in Avery size 8160?
  180. How do I find max then sum cells above & to the left?
  181. subtoltal
  182. How to filter a column of text for exact words
  183. Assign a letter to a number and then retrive
  184. if and conditional formulas
  185. Fill cells below until next cell is filled
  186. Pivot Table Calculation
  187. Excel
  188. where is the original data location in a worksheet stored?
  189. Create 2 sheets, from one, based upon value of one column
  190. Can I substitute a conditional parameter in every formula on page
  191. Calendar linking
  192. Excel chart categories....
  193. LookUp/Match/Index/OffSet Question
  194. column autofill question
  195. Number Conversion
  196. Footing rounded numbers
  197. How see all the text in a cell?
  198. how can I make autofilter automatically update
  199. Converting Times
  200. IF Function: Time schedules
  201. How do you restrict a cell to accepting only "Y" or "N" ?
  202. Need a formula to give me the last value in a column.
  203. Formula Question
  204. Concatenate - Excel 2003 or 2007
  205. Function for formatting?
  206. Help for multiple & variable validation function
  207. FREQUENCY HELP PLEASE
  208. SUM WITH MULTIPLE CRITERIA
  209. Formula help for choosing from a set of values
  210. dates
  211. Display and calculate 12:00 PM in Excel
  212. =TRIM and =PROPER in a nested statement?
  213. how can i stop printing extra pages?
  214. automate date entry
  215. How can I delete duplicated data
  216. combine IF, AND and OR operstors in a statement
  217. Something better than Sumproduct
  218. AUTO FILTER
  219. LookUp/Match
  220. 2008 Julian Callendar
  221. how to synchronize data value across two worksheets in one workbook?
  222. Match with Complex Lookup_array
  223. Auto link excel date to calander ener
  224. worksheets equaling other worksheets
  225. Nested if
  226. In visual basic
  227. sumproduct between date range
  228. nested IF SUMPRODUCT updating to closed workbook
  229. Text string extraction
  230. average if
  231. text to numeric
  232. Excel will not sort column
  233. Permissions
  234. How do I lock some of the worksheets in an excel 07 spreadsheet
  235. vali
  236. validation problem
  237. Validation problem
  238. Validation problem.
  239. Comparing numbers/figures
  240. Time Calculation
  241. is it possible to change excel results dependent upon result
  242. VLookup & Conditional Formatting together
  243. pivot table repport
  244. How do I get page down to move a specific # of lines in Excel?
  245. How will I get report in Excel(2003) when my data base is in Access2003
  246. Adding rows to multiple worksheets at once
  247. Convert Date to Text for Export
  248. Help - seeing formulas instead of results but only is some cells.
  249. needed formula
  250. unprotect a worksheet
  251. SUMIF, multiple criteria
  252. If/Or Formula - Which formula do I use?
  253. SQL like function?
  254. Average a List and sorting
  255. how to set up a simple variable in Excel, but cell location independent
  256. Consolidating a formula
  257. zero "0" dropping from the beginning of my serial numbers
  258. counting the number of characters in a cell
  259. Converting photos from xls. to other format
  260. Large function - Please explain
  261. Help!!!
  262. LookUp/Match/INDEXing Question
  263. 3D reference need help please
  264. If Then assistance...
  265. Cannot change text to proper case using formula
  266. Loan Payments P/Yr.
  267. SUMPRODUCT with )--
  268. Skip Weekends in date
  269. How do I compare two mailing lists. One Sent and one not sent?
  270. Moving cells without changing their formulas
  271. MACROS EFFECTED BY TABLE FORMATTING IN 2007
  272. DSUM with variable Criteria
  273. How do I jumble data in Excel 2003?
  274. Find number within two data base
  275. Masking out characters in a cell
  276. how to use vlookup/find etc to extract rows
  277. Run Code On Activate
  278. sequentially nubered worksheets automatically?
  279. Is there a single function that duplicates Solver?
  280. How to add up costs per resource per milestone for a report
  281. how do I repeatedly substitute a value in a formula
  282. IF problem
  283. Cursor problems 2007
  284. rounding to nearest 100
  285. value is "0"
  286. =+SUM(S2:S36) outputs 19190fault
  287. Help with ISERROR
  288. How do I reserve a document
  289. Always Sum a list of %'s to 100%
  290. Excel SUMIF function problem
  291. Dynamic Range
  292. basic excel formula
  293. Sumif Multiple Columns
  294. How to use a macro to copy a picture from another spreadsheet
  295. Idenfying WeekDays
  296. SUMIF with multiple criteria
  297. How to pick a value out of a table
  298. move or copy option in excel 2007
  299. Excel template for daily compound interest varying monthly paymen
  300. Call a Visual Basic Function with VLookup
  301. Resetting cells
  302. finding pairs
  303. array question
  304. How to use INDEX in an ARRAY that changes depending on a criteria
  305. searching text and conditional format with multple conditions
  306. Adding in a Date Range
  307. SUMIF to calculate units sold in a specified timeframe
  308. copy rows to other sheet
  309. Sum between Dates
  310. Dynamically Changing Named Ranges
  311. Something Missing
  312. Text to Numbers
  313. Round() problem
  314. Value Changing in an array
  315. Excel 2003 worksheet duplication -not intended
  316. Can VLookup return the LAST value in a range?
  317. Formula for every 13 cells
  318. Excel Function?
  319. min function - help
  320. SUMIF with non-adjancent cells
  321. How to ignore hidden columns
  322. Sum IF function From time to number not working??
  323. Combine columns into one column
  324. "moving average" Excel 2003 vs Excel 2007
  325. Hyperlinking from data in one sheet to matching data in another sheet
  326. Building a sales log
  327. What is the upper limit to the dependencies for Excel?
  328. Pivot Table Countdown
  329. Array fucntions
  330. database autofill
  331. Lookup based on 2 columns; return 1 value
  332. Simple formula
  333. Referencing Dancing Columns from another worksheet
  334. overtime hours formula
  335. How to minimize the formula cell memory?
  336. Update online spreadsheet`
  337. cell value based on combo box entry
  338. Excel 2007, show negative in my financial statements in brackets?
  339. visual basic. find copy row past into new sheet
  340. Look Up Problem Monthly and Yearly Totals
  341. Copying Data
  342. Retrieve cell value basis the inputs into a diff cell // sk.
  343. Workday function from Excel to Works
  344. Insert value based on color of the cell
  345. Calendar
  346. Inserir um calendário
  347. Separate Day and Time from a Date Field
  348. Excel's conditions ignored by Word in Mail-merge
  349. weekly report
  350. STRIP CHARACTERS
  351. REPT FUNCTION FROM WORKBOOK TO WORKBOOK
  352. Re: Tab Name
  353. Month from the date?
  354. Analysis Toolpack add-in gets disabled
  355. How to retrieve the number?
  356. Random Names and Command Button
  357. lookup using multiple columns
  358. Counting Dates
  359. Weird Problem
  360. Rolling Formula based on If
  361. Split DATE cell into three new cells?
  362. Question regarding HLookup (unique values)
  363. If Stmt with two colors
  364. IF????
  365. SUMPRODUCT question
  366. "DATEDIFF" LOCATION IN EXCEL 2007
  367. LookUp/Match Question
  368. Better example I hope how can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2
  369. Re: How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2
  370. Activate object
  371. Problem using Day() in a macro
  372. defined names
  373. Updating Workbooks from multiple links Workbooks
  374. Networkdays equivalent for minutes
  375. number range to equal one value.
  376. Custom Formating Cells
  377. automatic data sorting?
  378. How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2
  379. Fill function
  380. Add data based on a common field
  381. sheet index in a formula
  382. How do I calculate simultaneous equations?
  383. SUMPRODUCT
  384. Last Value Greater than Zero in a column
  385. Lookup function to take into account working days only
  386. multiple IF Statements
  387. sychronous scrolling
  388. How do I get the value of a label to be displayed in Excel?
  389. adding numbers but not letters
  390. IRR Problem
  391. How can i recreate a list without errors
  392. how to add addl rows to a reference cell while using formula in Ex
  393. how to converting numers to text
  394. index match issue
  395. Interpolate in table lookup
  396. Activate Object question
  397. Activate Object question
  398. Embedding text into formulae
  399. how to remove #n/a error in excel vlookup b/c value is not found?
  400. IF with AND function??
  401. Extract all letters from a cell sentence
  402. Copying
  403. CONCATENATE CRAZY!
  404. Match
  405. Not sure what to title this????
  406. Formula based on conditions
  407. Can a date range be used in SUMPRODUCT
  408. how do I end a worksheet columnwise.
  409. Help with converting a block of cells with Absolute and mixed references to relative references
  410. Page Break
  411. combining Formulas
  412. Insert new ROW if cell equals value
  413. Random Selection of Some Lines in Excel Worksheet
  414. Copy data from one worksheet to another
  415. Change # by 1 in a formula
  416. Header & Footer
  417. Return text in Column A if Column B and Column K match
  418. link cells
  419. Ranking if number is between 550 and 855.
  420. How do I convert a birthdate format from yyyy/mm/dd to mm/dd/yyyy
  421. iserror help
  422. how do i take somthing off the word processor and put it in a fil
  423. Tabbing on a Protected worksheet
  424. Dollars to text without loosing zeros from decimal places
  425. Highlighting rows based on one cell
  426. Ranking if number is >550
  427. SUMPRODUCT #VALUE! Error
  428. Sum Function
  429. Calculating Growth % in a Pivot Table
  430. excell 2007 moving data in cell
  431. Calculating days since a particular event
  432. Re: Unprotecting a Protect Worksheet
  433. Dynamic Assignment of a Cell Address In Formula
  434. If with Vlookup
  435. vlookup limitations?
  436. SUMIF summing multiple columns
  437. look up using 2 cells from one sheet to find a value in another...
  438. how to compare time in hh:mm format using IF function?
  439. Create summary sheet of last row of info from other sheets
  440. how can I put a number from a sequence in every row in excel?
  441. Creating a list of job numbers, missing out irrelevant items
  442. How do I put the intermitent color with conditional formatting
  443. Tab delimited to comma delimited
  444. Combo Box Limits Data Entry
  445. ako kopirovaÅ¥ a prilepiÅ¥ hodnoty s prepojenÃ*m riadok na stlpec
  446. Copy link to offset sheet
  447. entering values without changing the function in the cell
  448. how do I define spreadsheet headings for mail merge in word
  449. looking for a solution
  450. Address of Last Cell With Data
  451. Odd Concatenate problem.
  452. Correct formula for this
  453. Finding the Address of a Cell
  454. Automaticall e-mail me when cell value reaches a value
  455. Help with a formula
  456. how do i if statement for 3 variables
  457. Need help writing Excel macro when range changes
  458. Need help with grouping in Excel 2007
  459. Need help with grouping in Excel 2007
  460. Column1 and Column2
  461. Wild Card for SUMIF criteria
  462. Column1 and Column2
  463. sum/group by 2 conditions
  464. All categories to show in pivot tables for use as dataframe?
  465. date calculation
  466. Logical test in IF statement returning incorrect result
  467. Counting once more
  468. More counting!
  469. Sumproduct question
  470. formula adding range of cells that contains alpha numeric
  471. Finding Cell that changes from a Positive to a Negitive number
  472. Sum ignoring cells with error
  473. Lock spreadsheet but can sort
  474. duplicate info in cells
  475. Exel 2003 Copy Formula Problem
  476. Nesting COUNTIF for multiple criteria in multiple columns
  477. Create a custom fill series or sorting order
  478. multiplication of a blank cell
  479. Extract numerator from fraction
  480. Copy/Paste Special in Excel
  481. select multiple criteria multiple worksheets
  482. Cannot Copy/Paste Array Formula
  483. SUMPRODUCT with #VALUE error
  484. Advanced Countif
  485. Converting Text Dates to Serial Numbers
  486. Select a large range
  487. find number in a data base
  488. checking for a string & No.
  489. Array formula to display 1 if concatentaed values differ..
  490. What is the Zero Cap function in excel?
  491. Time in excel
  492. copy data and formulas from a column and paste into a row
  493. change 20071201 to date
  494. Blamk cells and 0 values
  495. Converting text to numbers
  496. counting cells containing certain ranges of dates
  497. use "countif" function to count cells by colour
  498. How to Copy single Cell into Multiple cells
  499. How can i create new function library ???
  500. display lowest values
  501. Number repeated in an array
  502. Type a number and data appears from another sheet
  503. Conditional formatting
  504. i WANT TO ADD SEVERAL WORKSHEETS(AND DIVIDE THE TOTAL) NEED ASSIS
  505. Copy File Formulas between Files w/o the link
  506. How to Highlight Two Rows With Two Columns of Duplicate Values
  507. After midnight
  508. linking a averaged cell sum to a specific spot in a word document
  509. Formulas with-an an array
  510. Adding Numbers and Changing colors
  511. Sorting 2 colums to get numbers to match ?
  512. SumIf with date range
  513. Function to show the greatest number of characters
  514. Inserting comments in Excel XP 2002
  515. Sorting for check number reconcilliation
  516. Counting for multiple conditions
  517. Averaging
  518. Excel 2003 Formulas
  519. Dates
  520. SUMPRODUCT to average
  521. Compare two columns by aligning same-values and spacing out differences
  522. how do i copy data and formula from a column to a row in another?
  523. when using a formula can I have certain values in red
  524. Formulas assignment from array to range in VSTO Excel doesn't work
  525. Why do I loose color in cells with this string?
  526. Reverse Text then combine rows
  527. ¤â¾÷²M³f¦U´Ú¦U«¬¸¹
  528. Rounding to 2
  529. Calculating return for multiple separate time periods
  530. Calculating days and hours
  531. need a formula
  532. Pivot table
  533. Frequency of Billing
  534. excel 2007 -can't move the point?!
  535. shift allocation
  536. How can I use sumproduct with different size ranges?
  537. Can't Freeze Pane in Excel, it's grayed out.
  538. Pivot Table Refresh Not Updating Drop Down List
  539. Excel Data Consolidation
  540. Adjoining Cells
  541. repited numbers in columns
  542. Zero(0) values box checked-but not displayed as a 1st digit ?
  543. How can I get a leading zero (ZIP code) to show in a LEFT() calc?
  544. Defaulting the margins
  545. How do I resize a worksheet that's stuck on 65,000 rows?
  546. counting
  547. Concatenation
  548. weeknum function
  549. lookup assistance
  550. SUMPRODUCT returning no answer
  551. copy an Excel chart into Word does not look the same
  552. Please Help!
  553. Logbook - Confirm when item not returned yet
  554. Keeping web query cells attached to other data.
  555. 14 decimals at the import from excel to word
  556. Excel Worksheet Functions
  557. Excel 2007: Pivottable and Rank
  558. IF statement needed
  559. Countif - Array Question
  560. Create auto updating data validation list from all worksheet names
  561. Addition of time
  562. Offset/Indirect Help
  563. functions with background colors
  564. MEET NEW ADULTS! 5000+ NEW PROFILES PER WEEK! FREE!
  565. Variable in if statement
  566. Difficult Calculations
  567. Fill down while skipping cells
  568. Fill down while skipping cells
  569. Format cells to General?
  570. subtotals in table
  571. If a Row is inserted or is a row is deleted then......
  572. To long formula for excel
  573. Find longest consecutive winning streaks
  574. Array & Trend
  575. update links excel 2007
  576. File properties
  577. check text in cell for at least one keyword from a list on anothersheet
  578. multiple formulas in an IF
  579. Reducing file capacity
  580. How do I set all caps as the default?
  581. Import Excel Data Brings Spaces
  582. updating Excel workbook
  583. Count with multiple criterias
  584. Search for specific number in a range
  585. Defined names
  586. Excel do not accept any comma's (,) making them unusable... Help!
  587. MEET NEW ADULTS! 5000+ NEW PROFILES PER WEEK! FREE!
  588. empty cells in calculation
  589. Lookup query
  590. Return a smallest date
  591. vlookup, same row
  592. Functions that will move info to a different location in column
  593. vlookup images within cells in another workbook
  594. Dates before 1900
  595. list of entries from a column without duplicates
  596. Finding Last number in a column
  597. conditional formatting
  598. For office labels
  599. Count Weekend Days solutions thank you very much to both of you
  600. Adding a unique identifier to a column of data
  601. Find, count and extract duplicate cells
  602. accounts payable aging report
  603. Financial functions
  604. First significant figure
  605. How do I subtract 20% from a column of prices?
  606. Count weekend days with criteria
  607. tabel formula
  608. look up value in a table
  609. Need help with Overtime formula.
  610. count & If fomula
  611. Euro Millions
  612. Sum x number of right cells after finding first cell more than 0.
  613. Excel Autocomplete
  614. Cursor does not move on one sheet in protected workbook
  615. Inserting an Item into cells with text
  616. Formulas
  617. Creating a production schedule
  618. Excel should allow clicking on a linked cell to jump to source
  619. Can't copy data from one worksheet to another in excel 2007
  620. Sum should be 0
  621. Replace SUMIF with SUMPRODUCT
  622. Get section of text from cell
  623. Update and Fill Links
  624. Conditional formatting for rows
  625. underline too close to text
  626. using a toggle button to show or hide information in several cells
  627. Lookup
  628. Macros pulling info from other worksheets
  629. Can I click on a cell and bring up an information box?
  630. Sum with conditions
  631. finding # of occurrences of information between two dates
  632. To get a true sum
  633. VLookup is not returning the first match data
  634. #N/A Error on VLOOKUP
  635. Delete row if blank in a column
  636. adding sheets based upon a template sheet
  637. Extract uniques from filtered range
  638. Extracting text from a cell
  639. Changing Folders!
  640. Formula numbers and text Trying to pull a random sampling
  641. Black and white printing
  642. Convert State abbreviations color coded cell
  643. Summing an unkown number of columns
  644. #DIV/0! error
  645. Calculate Number of years
  646. Embeded IF Statement
  647. Search number within a database
  648. Tabs with different names
  649. List on different worksheet
  650. remove unwanted spaces?
  651. Get Holidays in cell/s between star & End dates?
  652. How to get Holidays in cell/s? (Find explaination in details)
  653. Highlight Like Values
  654. Re: array formula to provide all values associated with a given value
  655. array formula to provide all values associated with a given value
  656. =if(vlookup for non-unique values
  657. How to generate random numbers from a range of cells?
  658. How can update keep an updated balance on a spreadsheet
  659. if A1<0 let B2 =A1 and if A1>=0 let B3=A1 solve PLEASE!!!!!!!!!!
  660. VLOOKUP?
  661. What formula to use?
  662. Dynamic sum
  663. Lookup function (i think)
  664. can't find function error
  665. Excel Hyperlinks
  666. LOOKUP or IF??
  667. Allow Sheets to be Connected by Rows or by Columns
  668. Gift Exchange Help!
  669. getting XL to recognize lower from upper case in IF formula
  670. Opening Excel workbooks
  671. Stop time - start time calculation
  672. vlookup
  673. if statements
  674. conditional statement using validation cell
  675. How do you get information from an Excel Web Query into Access?
  676. Showing duplicates in pivot tables
  677. Excel spreadsheets
  678. vlookup puzzle
  679. How to convert a text in a number value
  680. adding a colon to military time
  681. VLOOKUP for lookup of names in address tables
  682. delete all cells with color
  683. vlookup
  684. Multiple ifs
  685. find if there's a double entry in a list
  686. How do I make Excel drop-down list values editable?
  687. how do i auto update cell values after pasting linked references
  688. Counting unique values in a list generated with the OFFSET functio
  689. Vlookup Help
  690. search an array for possibilities
  691. How to Sum<=40, sum, if >40 sum in next column
  692. Excel Formula
  693. populate form from where the cursor is
  694. Subtotal position errors
  695. Need help with If-then statement with multiple conditions
  696. If statement to compare time cell to a time
  697. Tallying Letters
  698. Two columns only take one name for both email address
  699. Conditional formatting with a macro
  700. If then CountIf
  701. How to use Vlookup with web query data (In HTML format)
  702. dates: no weekends and no hollidays
  703. Write Holidays between two dates?
  704. Trouble with null values
  705. Repeat a formula with interval
  706. VLOOKUP linking to different files
  707. How do I retrieve a page number in Excel?
  708. In the Project window where will be the double click option
  709. Comparing data in two sheets with similar values
  710. Connect to OPC / DDE server
  711. Formula to see Top Ten performers
  712. building formulas that change frequently using named cell ranges
  713. Web Query Auto Refresh
  714. create personal macro workbook
  715. Text & formula in same cell
  716. How do I use formulars from another worksheet
  717. Re: Hour and minute
  718. copy data from sheet1 to sheet but in varying positons
  719. Conditional Format Not Working
  720. Conditional format does not work for some cells
  721. Excel formulas that repeat
  722. Replacing COUNTIFS with COUNTIF
  723. Excel Template: calc time per task fr 'start' and 'end' times
  724. Single formula to find match across four columns?
  725. When using & and a date-formatted cell in a formula I lose the for
  726. Using the numeric contents of a cell to define row number
  727. countif
  728. Countif Array
  729. Floating Text Box help
  730. How to assign values to a cell based on values in another cell?
  731. macro with sumif
  732. REVISED Nexted IF and Countif
  733. collapsing rows
  734. Nested IF and Countif ?
  735. Macro with formula
  736. Specific formula query
  737. Using a cell with a formula in it for lookup value
  738. Identify external references (in formulas) and color format
  739. Offset Function
  740. Putting subtotals in $ descending order
  741. Nested if help
  742. Vlookup help
  743. sumif as array formula
  744. Find all same values from defined range
  745. If statement
  746. FORECAST Worsheet Function
  747. help with formula for bolding font
  748. Protect / unprotect function
  749. can you calculate sheet to 2 decimal places
  750. Posting Data From 1 Wksht to Another
  751. Geomean function
  752. Excel cell Formatting
  753. How do I convert the result of a formula in a field into a value
  754. How do I sum a column with only a certain date range?
  755. how do i convert this to a formula +"sheet1!J"&(sheet2!A30)-1
  756. ISNUMBER
  757. Finding the Location within an Array
  758. how to check duplication of id numbers
  759. i WANT TO CALCULATE THE NO IN A SINGLE COLUMN WHICH ARE NOT SAME.
  760. Why do my formulas quit functioning in Excel 2007?
  761. how can i convert digists in to characters in a spread sheet
  762. while entering text excel should not accept duplicate record..?
  763. HOW DO I MAKE A WORD HAVE A VALUE IN EXCEL
  764. Free Discount Prescription Cards
  765. Carrying data over in worksheets
  766. Function on dynamicly adding rows in column
  767. Pivot tables after Excel 97
  768. Auto Filter and Merged Cells
  769. Update source link in MANY files
  770. Highlight rows
  771. display one letter of a word in a cell
  772. Countif Help
  773. funcres.xla
  774. Summarize information on another sheet
  775. Condensing data from 3D to 2D
  776. need help with a formula or conditional formatting
  777. Excel Spreadsheet
  778. Renaming tabs from particular cell contents
  779. Auto Complete (???) in Excel
  780. Find first cell in a row not equal to
  781. Referencing cells with formulas results in blank cell.
  782. if/countif for 12 different arguments
  783. how do I nest a drop down cell within a conditional statement?
  784. INDIRECT should be updated to work on closed workbooks.
  785. Rounding Help needed?
  786. If Then else using an Array
  787. VLOOKUP Problems
  788. Data Validation source = destination?
  789. Finding a numerical value within a cell
  790. Summarising Timesheets
  791. confidence limit/interval
  792. Creating Directory Structure from Cell Value
  793. textbox in excel 2003
  794. Enhance sumproduct to return unique employee code count
  795. drop down list
  796. runtime error (9)
  797. protected sheets
  798. SUM VALUES on MULTIPLE SHEETS
  799. Specific function to get the sum
  800. Summing values in a column if the date in another is of a certain month
  801. How to add a worksheet automatically using macro in xls?
  802. Convert MM to inch and add to comment
  803. Date functionality
  804. Fill Data in Excel 2002 and 2007
  805. Fill Data in Excel 2002 and 2007
  806. Insert text based on another cell's colour or font in Excel 2003
  807. TREND help
  808. Excel 2003 workbook not updating values
  809. Counting cell entries
  810. How to assign value to a textbox.
  811. In Excel 07. Copy to second cell by clicking f8irst?
  812. Sorting issue
  813. Why this code is not work?
  814. Conditional Formatting Based on Question Mark (*NOT* used aswildcard)
  815. how can we get unique values in match function for same match key.
  816. Formula question
  817. leave cell blank and continue with formula
  818. Text in last used cell in a column to another cell.
  819. if statements across worksheets
  820. Another counting question!
  821. Use Filtered Results for Data Validation
  822. how are the sheet tabs made larger
  823. Extra month shown in date count
  824. working with dates
  825. Lookup is not returning the right value.
  826. Very Simple Time/Hour Question
  827. Help w/ alternate to Countif
  828. MS Excel 2002 formulas
  829. Calendar control size trouble!
  830. IF formulas and monthly finances
  831. What value does ^ have in Excel?
  832. Macro to total values with certain criteria...
  833. Adding item in listbox
  834. Excel
  835. Adding item in listbox
  836. find next line for data entry
  837. Named Range
  838. Consolidate Worksheet Contents
  839. How to stop to adjust references automatically
  840. How can I apply a function (PROPER) to multiple cells at once?
  841. converting one data entry into another
  842. Help with nested IF function
  843. calling a value from another file using a variable in the file nam
  844. Connecting formulas
  845. macro help
  846. Conditional Sum Incorrect
  847. Match Data
  848. Using Match
  849. Sorting rows left to right numerically
  850. product function
  851. counting
  852. add a sheet button
  853. Linking the cells just won't work
  854. Please Help
  855. How to automaticly duplicate / copy a Hyperlink WITHOUT cut and pa
  856. COUNT and IF Array
  857. excel 3 gridlines.
  858. Time Format
  859. naming tabs
  860. Formula to get values between 8 and 15
  861. Formula to Return the next 1st Tuesday of a Month
  862. excel formulas
  863. How do I automatically generate an invoice number
  864. Finding a value in a Table
  865. Running balance in a checkbook worksheet
  866. Count if does not equal
  867. Countif does not equal
  868. Sum of Different Ranges Keeping Results In Sequential Columns
  869. drop down
  870. how to find sheet in a file
  871. formula1-ferrari collection
  872. Excel Restarting
  873. Running totals on Purchase Order tracking
  874. Excel Formulas
  875. Dropdown List that populates another column
  876. user defined function
  877. Data is not updating in Excel
  878. What does ^ operator mean in a formula??
  879. Excel 2007
  880. adding and subracting credits
  881. In Excel: Time Entering
  882. I NEED A FORMULA THAT TAKES THE DATE AND CONVERT IT IN A QUARTER
  883. Variable Ranges
  884. Dates - Need to display date one month prior to user-entered date
  885. Why are blanks being ignored by my MIN function?
  886. Number of non-zero values in a column
  887. conditional formatting
  888. Conditional Formatting option "Grayed Out"
  889. % achieved to a negative goal
  890. Combining data from multiple workbooks
  891. Time Sheet
  892. Compare two data in same sheet
  893. Finding the longest sequence of 0's in a row
  894. Filtering Issue
  895. How do I keep the "tab" key from jumping over adjacent cell
  896. COUNTIF/SUMIF comparing two rows of data
  897. export re-order input fields to export file [csv]
  898. if format problem
  899. Converting Time to decimals and then converting decimals to time
  900. links to a second workbook doesn't work if origin not open
  901. Drawing Sample
  902. EXCEL - formula for linking dates and prices
  903. How can I add down a list a specified number of cells?
  904. vlookup formula fails to return data search item is text
  905. IF - looking in a cell for a specific value
  906. Conditional Format
  907. Multiply CountIf in one formula
  908. Column changing
  909. how to write a number in words in excel worksheet?
  910. WORKDAY
  911. If Condition Problem
  912. converting time
  913. summing of time
  914. Create "other" filter
  915. DDE function with variables
  916. PostScript generation in c#
  917. How do I use properties window to embed shockwave flash file?
  918. How to time-limit an Excel file installation
  919. how do you use vlookup to compare values between two workbooks
  920. Calculating number of weeks between dates?
  921. Data Validation -- Dates
  922. One more step in the Formula Please
  923. Hyperlink Security
  924. Help with function
  925. find maximum and minum variables for multiple names
  926. looking for a function
  927. column width
  928. update daily sheet
  929. Colume Headings
  930. Selecting every 200th row
  931. Time format graph
  932. Random Report
  933. Format for Whole number and 1 Decimal in same Cell
  934. Substitute function yields #VALUE! when add the instance_number
  935. Cell Format
  936. Downloading files from the the Internet
  937. sumif with more than 1 criteria
  938. selecting an answer based on a 3 way logic
  939. Choose function in Excel 2003
  940. I want to accept one value only or error out cell
  941. rounding a number with a formula already in cell
  942. Query Named Range Return Single Column Value
  943. two questions, Yes/No form control, and how did they create this adjustable area on the sheet...
  944. MSN MoneyCentral Stock Quotes Add-in for excel
  945. sorting
  946. formatting issue- date format dominates
  947. Mod Function
  948. Sumif with multiple criteria
  949. Text Formula Question
  950. cannot format date at all
  951. Excel 2003/7 VBA (Un) Protection not working
  952. Conditional FOrmating
  953. round
  954. Pivot Tables
  955. Ignore calculation if text
  956. User created function not "updating"
  957. Using Data Filter
  958. Pop-up: "Too many different cell formats"
  959. Cursor position to get colour
  960. Copy content of coloums between different workgroups
  961. How do I create a formula for a Chart of Account list?
  962. if any 3 of 5 cells have 0 then 0.
  963. Excel copying heading to another cell in a selection is made
  964. Using COUNTIF to count based on multiple cell criteria.
  965. Applying a formula to a broad range of numbers.
  966. Protecting Worksheets
  967. Dragging a range
  968. HOW DO I REMOVE UNIQUE VALUES IN EXCEL?
  969. VLOOKUP(sorta) againts SQL Server table - HELP!
  970. nested If Sumproduct #VALUE! problem
  971. Cross referencing
  972. Formulas Becoming Inactive?!?
  973. Formula to pick out, cut and paste
  974. Excel Formula
  975. Combine Multiple Entries with differing amounts of entries
  976. Excel
  977. Create a function to add one to the count
  978. find number within a range
  979. Referencing Non-bold in a formula
  980. date functions
  981. Color
  982. Multiple conditions
  983. Can you link a scheduling calendar in Excel
  984. Check Boxes
  985. sum if less than and more than a time range
  986. attendance based pay for Army reserve
  987. excluding my country's weekends
  988. Locking Cell Once Data is entered
  989. Private sub problem
  990. create a formula to produce a color in excel
  991. External Data needs to be separated
  992. How can I remove extra characters from a list- phone numbers in ex
  993. COUNT based on conditions in 2 or more columns
  994. how do i sort a spread sheet and remove duplication
  995. how to fourier/laplace transform a time signal?
  996. Character limitations for excel fields
  997. NETWORKDAYS: using correct funtion?
  998. divided value by amount of rows
  999. jumping rowsand highlighting cells
  1000. how to get rid of #N/A