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. Using multiple IF criteria
  2. cell lookup
  3. IF-OR Functions
  4. Solver/Data Tables - help pls :)
  5. How to leave the lines on my exel work sheet
  6. Using Solver with Data Table
  7. Compounding a percentage
  8. Multiple Lookup as condition in sumproduct formula
  9. display hidden rows using conditional formatting
  10. rearranging data
  11. Match data in 2 columns and return data from 3rd column
  12. Finding the last entry in a column based on criteria
  13. How can I make my entire document CAPS?
  14. Extracting information
  15. How to I calculate 180 days from any date?
  16. Help - I need to combine both a SUMIF and COUNTIF into one formula
  17. Looking for formula that selects last value entered in a column?
  18. earlest date not complete
  19. How Excel help to reproduce a form like this
  20. Extract Client Refs from pivot table into another worksheet
  21. date formula
  22. date formula
  23. basic question - how to calculate a cumulative percentage?
  24. Calculate Range
  25. QUERY data range to populate separate worksheet?
  26. Calculating moving average
  27. Question using DGET function
  28. How to use functions after sorting a range?
  29. lookup stock symbol on worksheet and return summary data
  30. Count how many persons in a month using a date
  31. Excel Chart - Require a Formula
  32. =and formulas with =if formulas
  33. Creating Buttons using the Forms Tool bar.
  34. Generating a list
  35. Change values in multiple cells from one cell
  36. sumif formula
  37. Create filename based on cell contents
  38. Load caption box on userform open
  39. Adding numerical values based on multiple values in another column
  40. Force sort before worksheet exit
  41. Excel Loan amortization Excel X for Mac 10.1.6
  42. If time Go to Function
  43. Lookups or something
  44. Printing selected parts of a list....
  45. Increasing font?
  46. 2nd lowest Value in Array
  47. Formatting Time As hhmmss Gives Me Dates Instead?
  48. Dragging Data into a new worksheet and arranging it by type
  49. Using booleans in sumproduct formulas to extract boolean range
  50. Sumproduct to SumDivide ?????????
  51. how to combine workbooks or spreadsheets in to one????
  52. Conditional Average
  53. Fiscal Quarter Conversion
  54. Copy Excel tab (worksheet) to another Excel file
  55. Pivot Table: Change dates to fiscal year
  56. My Buttons shrink with every click
  57. checking for duplicates
  58. change language setting using VBA code
  59. I want to assign a ranking number to a series of values.
  60. Hide macro's
  61. change the century
  62. Ignoring Cells with Only Spaces
  63. Merging Databases
  64. need to do a calculation.
  65. Atlantic City Excel User Conference - Registration deadline
  66. How can I convert a character string that contains letters & numbers "2,456.99 (including flights)" into a numeric?
  67. SUMPRODUCT Formula Help Please
  68. Counting two numbers
  69. Nested IF and Wizard
  70. Filter
  71. formula or vba solution
  72. How do i get figures for my maths. i am pressing enter return.
  73. adding function
  74. Difference between two dates rounded up.
  75. Change Cell Format
  76. Sheet creation and colouring the tabs
  77. is there any formula to copy??
  78. Format Cells by code
  79. simple inventory totals
  80. Filter problem
  81. sorting data
  82. copying formulas
  83. lookup the next matching record.
  84. How do I set up a new default mail client?
  85. If a cell = TRUE how do I get the cell to do a sum function
  86. Enter data, move automatically to next unprotected cell
  87. Multiple CheckBoxes can be selected require additional info if sel
  88. Row and Columns not visible - need help
  89. product between two dates and with criteria
  90. Displaying decimal places
  91. Help w/ INDEX and ROW reference using OR statements
  92. Change Cell Value from another Cell
  93. Convert Time to a Text
  94. Need help in forcing number that wants to stay in Sci. Notation fo
  95. Count cells in date range
  96. tab color change
  97. Date/Time Difference Excluding Weekends & Holidays
  98. How do I set up slider bars to input data in Excel?
  99. How do I merge/combine different workbooks with different sheets
  100. Why can't I copy this worksheet?
  101. Data Consolidation w/ Multiple List Boxes
  102. how to skip to next cell to lookup info until found
  103. Multiple cells reference
  104. sum values in cell based on another cell
  105. auto fill text
  106. Can i get advanced filter to automatically refresh
  107. Need Help with Macro
  108. Excel spreadsheet formula
  109. Rank excluding Errors
  110. Guess my number game for kids.
  111. Using Data from Drop Down Menus in Sum Formulas
  112. NUMBERING ROWS
  113. Array subtitute
  114. How do I use a formula to give me a cell reference in excel?
  115. Wildcard and Sumproduct
  116. How to Scroll through the sheet
  117. SKIP PAGE NUMBERS IN EXCEL
  118. Sumproduct Count, Allow Or Two Fields
  119. How accurate is SOLVER?
  120. sorting data
  121. formula to display Modified properties
  122. How do I edit a cell in Excel without clicking on the cell first?
  123. Format date as text
  124. Re my question on sorting
  125. WHAT IS A DELIMITED LIST
  126. Worksheets with OFFSET command always ask if I want to SAVE
  127. Counting different workinghour types
  128. Can I rename the column letters a,b,c etc. in excel 2003
  129. delete XL macro forgot name I used
  130. Student Marks Calculation
  131. Excel Search Listings
  132. VLOOKUP?
  133. keeping rows together during column sorts of linked worksheets
  134. Cross tab query
  135. Sum by company?
  136. Changing a pivot table's data range in Excel 2007
  137. counting cells?
  138. conting cells?
  139. Changing Entries to Proper and Upper Case Q
  140. Calculate next number using dates?
  141. TESTING A RANGE OF CELLS
  142. future value calculation in excel
  143. drop down button
  144. Sumproduct??
  145. Array formula with index + match
  146. Running Total
  147. Return an empty cell instead of "VALUE"
  148. month calculations
  149. Importing music titles into a spreadsheet
  150. Pivot Table - Reference is not valid
  151. Help with nested function
  152. Checking a cell against a named range
  153. Deleting rows with 11+ characters.
  154. Bringing conditional data from another Worksheet
  155. Getting a second page on a template....
  156. SUMPRODUCT I Think!!
  157. What does the "&" do in a function?
  158. Using value stored in cell in formula
  159. Sumproduct does not work after editing data
  160. Comparing multiple column values
  161. Formula help
  162. Comparing a column of names
  163. Finding a count above average
  164. naming cells using insert > name> define
  165. Not all Functions seem to be on my computer with Excel2003
  166. Basic question about what formulas look at.
  167. Compare and group like numbers and info
  168. Need page number & total pages in worksheet - not header or footer
  169. About Worksheets & Workbooks.
  170. If Statments: Want TRUE if a value = any of the given values
  171. Macro For Consolidating WorkBooks
  172. Index Match not working
  173. Problem with LOOKUP function
  174. How to Insert Columns in a big Sheet...
  175. Advanced text function
  176. count cells,containing text, based on more than one criteria?
  177. Comparing multiple columns in two sheets
  178. Row Limitations and Functions
  179. Using IF and MIN
  180. Converting numbers and number formatting to a CSV file ?
  181. Approximate matches with vlookup?
  182. How to set condition for frequency?
  183. Sumproduct (I think?)
  184. Possible to create multiple-selection drop-down box in Excel?
  185. Macros gets disabled by default
  186. Countif
  187. How do i "Sort" my Excel 2007 worksheet
  188. which function do i need?
  189. Multiple CountIF in 1 function
  190. sum/division calculation involving vlookup with array?
  191. Is it poss to have a double array in Excel 2003?
  192. oldest date not completed
  193. Max (A1:A1), relating to other cells
  194. Excel: # in a cell if a # is repeated in a row
  195. How do I calculate the interest payment manually (without using IP
  196. NETWORKDAYS
  197. how to add different picture to each contact in database in Excel
  198. ctrl + tab (first in, first out history) with excel sheets?
  199. Issue with "ToggleFormsDesign" a method of Excel workbook
  200. Keyboard Shortcut for right-click on sheet tab
  201. vlookup and dates!
  202. saving macros in personal workbook
  203. Bar Graph
  204. XIRR
  205. how do i get data from another workbook
  206. How to search my past question ?
  207. How to avoid duplicate string value input in one column?
  208. shade cells based on conditions - i have more than 3 conditions
  209. IF Logical Function & Blank Cells
  210. Multiple workbook sheet numbers!
  211. Number of Months and Days between 2 dates?
  212. referencing
  213. ROUNDUP NUMBER
  214. Insert Incremental sheet names in a workbook
  215. Multiplying specific data within a range to get column totals
  216. Convert phone to ***
  217. Price Lookup
  218. =(INDIRECT(ADDRESS(ROW(),#))) with SUMPRODUCT returning #VALUE!
  219. I need a cell to equal have of what I put in
  220. can you group multiple worksheets into a sub menu
  221. #REF! trying to white out
  222. how do i use macros to work out commissions
  223. Macro To consolidate All Open Workbooks Into One Workbook
  224. Import or link data?
  225. Inserting Comments into Cells of Protected Worksheet
  226. Anchor Doesn't work
  227. How to use trim finction in array
  228. Goal Seek Bias
  229. Vlookup slows system
  230. How can I apply a formula to all cells even those with < signs?
  231. Applying formats to graphs
  232. Counting the number of graphs
  233. how do I show 1st, 2nd, and 3rd most repeated non-numeric values?
  234. increase different prices by a certain percentage all at once
  235. To show page number in a cell
  236. Referencing another WB's cells, but not formulas/values.
  237. increasing an arguement
  238. How do I insert template in new sheet of pre-existing excel file?
  239. how to link excel worksheets with a reference (indexed) key field.
  240. Count Number of Duplicate Occurances
  241. DISPLAYING THE LINK PATHS
  242. excel how to put a print button in the document
  243. A partial transpostion
  244. how to include dash within a cell
  245. Dropdown box HELP
  246. How do i set Excel to record the date etc of info added
  247. 2007 EC Excel - Access User Conference
  248. how can I find A column when it's hiden?
  249. Sumproduct and wildcard
  250. SUM - getting #VALUE! when some cells are blank
  251. Excel fomula
  252. Condition on Time
  253. matching
  254. SumIF column A = x and Column B = x OR x
  255. Conditional formatting
  256. Combo Box in Excel 2oo3, functions missing!
  257. How to join two functions in a formula?
  258. how do i print a few excel files at the same time?
  259. find replace
  260. reset last cell in Excel
  261. How do I join two workbooks into one pivot table?
  262. Multiple find mulitple replace
  263. date formula
  264. How do i remove unused cells in excel?
  265. Looking for Mileage / MPG Tracking formula
  266. VLLOKUP AND SPACES
  267. Experiencing Difficulty with Excel
  268. formula to return date of most recent update
  269. Need help with a particular formula
  270. Finding non contiguous positive values
  271. How to Print Name's list and Names Range?
  272. Help to to create a Formula or Macro
  273. Using a field name in an IF function for a calculated field in a PivotTable
  274. Random Number Generator - Multiple, Non-repeating, results
  275. excel question
  276. Macro HELP!!
  277. 3d reference not working properly
  278. how do I write a formula for if b4 is between 1 and 100 then good
  279. Sumif on last digit
  280. If Statements
  281. List Manager
  282. sumif based on last digit of account list
  283. How do I create a drop-down list from a list I specify?
  284. Function Help
  285. Automatically fill cell value
  286. Using subtotals with a filter.
  287. Enable Command Button base on UserName
  288. Pivot tables - arranging data to appear in columns for each row it
  289. Creating and adding custom formulas
  290. project
  291. calculating number of weeks between two dates
  292. Averages
  293. Two Critera to match another spreadsheet and return single criteri
  294. Prompt user for input and utilize that input
  295. how do i ensure people use the right date format in excel?
  296. Hlookup for row 3 and 4
  297. Help with Offset/Index/Match formula
  298. Future Values
  299. copying formula
  300. Can you use a formula to edit another formula in excel?
  301. How do I make a formula automatically detect changes in values
  302. How to perform Search and Replace on "Tilde", CHAR(126), ~
  303. Invoice Numbers - Please Help!
  304. Freezing Values
  305. Search Function that returns an integer not #VALUE!
  306. Worksheet Names
  307. SUM Formula
  308. Date ranges
  309. Commision calculation
  310. VLOOKUP, SUMPRODUCT, or SUMIF?
  311. Filtering long text
  312. skip to worksheet
  313. Finding Duplicate Values
  314. Subtotal Problem
  315. Formula referring to a dynamic range in a different workbook
  316. Header in Excel
  317. Auto Average on next free cell
  318. What is Goal Seek in Microsoft Excel
  319. Automatically re-sizing merged cells
  320. Multiple logical formula
  321. how do I find and sort unique values from a column
  322. How to hide and secure ranges in worksheet
  323. IF not working
  324. lookup
  325. Function for cursor location
  326. lotus notes attachments
  327. Lookup & named cells
  328. Summarising a range in a column into a separate column
  329. IF Function - Calculation not working
  330. Get rid of #value!
  331. RE: IF Function - Calculation not working
  332. sumproduct exclude count
  333. Is there a way to create individual files from a multi sheet excel
  334. Date format
  335. WHAT IS THE MAX NUMBER OF "IF" CONDITIONS POSSIBLE IN ONE FOUMULA
  336. Re: Get rid of #value!
  337. Extracting dollars and cents
  338. How to add 3 rows with every change?
  339. Change cell colour
  340. Excel 2003 Import - Web Query - Results = Printing Version
  341. How can I automate the process of copying the first letter of a ce
  342. Linking cell A in sheet 1 with several cells in sheet 2
  343. Conditional Format <=Today()
  344. Reverse value in a column
  345. RE: sumproduct exclude count
  346. Using a Range to find text
  347. Sumif with n conditions
  348. RE: Conditional Format <=Today()
  349. i want to put a date into excel and then on that date be alerted
  350. Re: Get rid of #value!
  351. Date functions
  352. Data validation
  353. Having trouble with function.
  354. Very simple match function help
  355. AutoFilter Not Working
  356. Countif time
  357. WHAT IS THE MAX NUMBER OF "IF" CONDITIONS POSSIBLE IN ONE FOUMULA
  358. Excel paste formatting
  359. Insert a blank row after change in data
  360. Excel status bar: How did I get 65533 records.
  361. PICTURE RECOGNITION AS A ALPHA-NUMERIC CHARACTER
  362. Recalculate the IF statemtn value to a text message
  363. How to format cells
  364. Excell autofit row height function
  365. COUNTIF
  366. RE: PICTURE RECOGNITION AS A ALPHA-NUMERIC CHARACTER
  367. Sumif Syntax
  368. RE: WHAT IS THE MAX NUMBER OF "IF" CONDITIONS POSSIBLE IN ONE FOUMULA
  369. Formula Help... almost done with this project
  370. copying text
  371. RE: Vlookup accounting-style
  372. Vlookup accounting-style
  373. Use find to select entire rows with a cell with that value
  374. RE: Summarising a range in a column into a separate column
  375. RE: How to format cells
  376. how do I make my spread sheet calulate. I know nothing about excel
  377. RE: Sumif Syntax
  378. Suppress automatic formula creation?
  379. XLS to CSV Code Problem
  380. formula for commissions on a per piece bases
  381. Re: copying text
  382. Date-dependent calculation
  383. if 3 cells have data then add certain value to another cell
  384. links
  385. moving macro
  386. RE: if 3 cells have data then add certain value to another cell
  387. User Defined Function
  388. RE: Very simple match function help
  389. RE: AutoFilter Not Working
  390. How to get rid of #n/a
  391. RE: Extracting dollars and cents
  392. Nested IF error
  393. RE: how do I make my spread sheet calulate. I know nothing about excel
  394. Filtering out top & bottom 2.5% in a list
  395. subtract from numeric cell when alpha cell is occupied
  396. question on charts
  397. Re: Insert a blank row after change in data
  398. No more rows...??
  399. Ranking
  400. creating formula for subtraction and then division
  401. What formula can i use to add time?
  402. RE: Nested IF error
  403. RE: Extracting dollars and cents
  404. reverse value
  405. Help wanted for Advanced filter/sheet protection
  406. How Do i Lock individual cells?
  407. nested if statements
  408. Confused
  409. RE: Summarising a range in a column into a separate column
  410. how do i use code39 bar codes that update as a cells value chages
  411. Can you merge cells in a "list"?
  412. RE: Ranking
  413. Copying Excel Cells including Names Into Existing Spreadsheet
  414. RE: nested if statements
  415. need function/formula help!!
  416. Re: Formula Help... almost done with this project
  417. RE: Lookup & named cells
  418. Top 5
  419. RE: Excel status bar: How did I get 65533 records.
  420. RE: Data validation
  421. RE: Having trouble with function.
  422. Can I generate a report for my classroom? (I APPRECIATE YOUR HELP
  423. Vlookup
  424. RE: sumproduct exclude count
  425. Need help solving problem doing vlookup
  426. RE: Using a Range to find text
  427. RE: Need help solving problem doing vlookup
  428. Conditional Formats to ignore blank cells
  429. RE: PICTURE RECOGNITION AS A ALPHA-NUMERIC CHARACTER
  430. min IF - Bob Philips follow up
  431. Macro to send email to multiple addresses
  432. Pivot Table and Shared Workbook
  433. RE: Sumif with n conditions
  434. RE: Date functions
  435. Data Entry in a Shared Workbook
  436. RE: Ranking
  437. RE: reverse value
  438. Re: How to add 3 rows with every change?
  439. RE: Confused
  440. Auto Sum, MAX and Min
  441. Re: Get rid of #value!
  442. I want to link a cell in excel to calendar object?
  443. SUMPRODUCT Help Please
  444. Re: Conditional Formats to ignore blank cells
  445. Weekly Hire
  446. datedif challenge
  447. RE: Need help solving problem doing vlookup
  448. RE: min IF - Bob Philips follow up
  449. RE: Reverse value in a column
  450. How can I calculate daily hours worked minus lunch to eual a decim
  451. RE: Very simple match function help
  452. Updating all pivot tables at once
  453. RE: need function/formula help!!
  454. Re: SUMPRODUCT Help Please
  455. RE: Can I generate a report for my classroom? (I APPRECIATE YOUR HELP
  456. How to look up a value?
  457. Re: Formula Help... almost done with this project
  458. Wrap text doesn't wrap
  459. Can you protect a worksheet from having the columns resized,not ro
  460. Finding the date using the number of the week in a year
  461. Align Data
  462. Creating a new worksheet using predefined rows
  463. anyone know how to breakdown a paragraph to a spreadsheet
  464. Cell change, reset formula?
  465. Templates not opening up as workbooks
  466. if function?
  467. Finding duplicates based on 2 columns
  468. Pivot table sort order
  469. Calculating Projected Dates
  470. Lookup/Match Problem
  471. formula for dates
  472. Show desktop
  473. Disable X button on excel
  474. Saving a copy of excel file in macro but have it auto write
  475. ListBox with Horizontal Values
  476. Follow up area under the curve
  477. Problem with IF function....
  478. Search for & return list of values
  479. Function question:
  480. Sum Function with Error values
  481. Using a macro to control the autofilter function
  482. auto increase number if number is double or more
  483. IIf VBA Problem
  484. Using a single cell value to repopulate multiple cells
  485. Keeping records for working hours with excel
  486. BE-CAREFUL, YOU COULD BE A VICTIM OF SCAM OR FRAUD!!!
  487. How to get Excel to Recalculate a formula if the answer does not meet criteria
  488. How to get Escel to Recalculate a formula if the answer does not meat criteria
  489. The opposite of the "sort" function
  490. Any (clever) way to automate ROW:COL in copy/paste???
  491. #Value! error
  492. Excel IF, AND, OR ?'s
  493. report by DV & date criteria
  494. Multiple values (INDEX?)
  495. How do I get share prices updated in Excel?
  496. Count the blanks
  497. How to create a "cover worksheet"?
  498. Data validation list limit?
  499. Sum the ranges
  500. Template Wizard in Excel 2007
  501. match and list
  502. No place for sum
  503. Need help with a formula
  504. commission calculation
  505. Sum contents of multiple cells when the # of multiple cells is unk
  506. sum of 2 Months basis
  507. Counting on two conditions, one with a range
  508. how do i enter date and time in cell without it changing
  509. Shortcut Date entry problem
  510. How do I Auto Populate a cell with a chart based on a value
  511. manipulating dates
  512. How to determine the values from a list?
  513. forumla in dynamic ranges
  514. Timesheet - calculating hours per project type
  515. Cell Format from General
  516. formula 2 compare text in one cell to another and bring value
  517. Count Unique Text Values
  518. How do I add text to worksheet page based on intuitive formatted d
  519. Formula in a sheet reference
  520. large function help please?
  521. Numbers column help please?
  522. pre-fill cell by typing first few letters of a list
  523. multiple lists that return an answer
  524. Dreaming
  525. Solver and Goal Seek Tutorials
  526. Body Shop Calculations
  527. Creating a Purchase Order
  528. How to strip out visibly blank rows
  529. Top 5
  530. Count & Array Function
  531. Text to Speech on Excel 2007
  532. WHAT DOES IT MEAN BY "CAN NOT EMPTY THE CLIPBOARD"
  533. HTML Tags
  534. drop down lists
  535. Help with the formula to insert cells
  536. Lookup the 2nd to last cell used in a column
  537. Condition based on cell colour
  538. Address book worksheet problem
  539. Excel Formula Help take 2
  540. Excel Formula Help
  541. Need Help: highlight all the same strings in one cell
  542. Copy Sum formula to different row but use same column data
  543. Complex formula or use a macro?
  544. show result of sum when summed cells are blank
  545. Conditional Formatting for dates
  546. Colour help!
  547. Typical Problem
  548. dynamic ranges with sumproduct
  549. Add years NOT days
  550. How to determine the values from a list?
  551. count only if
  552. FORMULA HELP PLEASE!
  553. Formula to ave. last 3 months
  554. Calculate hours and minutes between times when it goes past midnig
  555. Excel functions
  556. Is there a Mileage Tracking function?
  557. Non cumbersome way to hide and protect a column?
  558. Excel "Sumproduct" Totaling formula?
  559. Excell-Protecting sheet formatting
  560. When opening an excel file in Windows Explore, it opens to a grey.
  561. excel 2007
  562. Vehicle Maintenance Workbook
  563. IF Statement---ARGGGH!!!
  564. Solve Theta
  565. SolveTheta
  566. run macro automatically when cell content is changed?
  567. Vehicle Maintenance Workbook
  568. Summary sheet with Vlookup
  569. Max if between 2 dates?
  570. IF and VLOOKUP - how efficient?
  571. Count Text Values in a filterd column
  572. Locate row based on two criteria
  573. data manipulation question
  574. Changing date and time to date only
  575. Lists and locked cells
  576. How to only incld cells that meet set condition in an Excel calc?
  577. How to calculate the rate of sale?
  578. nyway to copy static valuesAND formulas from one workbook to anothe?
  579. Sumproduct problems...
  580. put zero in blank cell using conditional formatting
  581. protect worksheet but allow copy column
  582. Cell("filename") doesn't update to new filename when do save as.
  583. Index/Match - Lookup based on multiple column criteria
  584. help with the macro or with the formula
  585. I FEEL AS IF MY BRAIN IS A CIRCULAR REFERENCE!
  586. Too Many If's
  587. Lookup function???/Linking Worksheets?
  588. Using a logical test on a date is failing
  589. spread sheet
  590. Why are the protection settings disappearing when I run my macro?
  591. Using Forms on Protected Worksheets
  592. Sum up With Macro
  593. autoshapes
  594. Standard Deviation do I use 520 (20x26) inputs or avg of each
  595. to get its k-value from percentile and array
  596. AutoFilter settings in shared workbook
  597. Pivot table - remove worksheet
  598. very strange linking problem in Excel
  599. Misunderstanding isblank
  600. Conditional formatting combined with multiple IF statements
  601. Macro to "Save As"
  602. Problem with IIf
  603. How to copy the value of cell into clipboard by double click
  604. criteria + between dates
  605. Date calculation
  606. how to convert from ° ' " to decimal °
  607. Carriage Return
  608. How do I complete a countif that dosen't include hiden cells
  609. Assigning a number value to text
  610. copy from different workbooks into one
  611. Trying to open Excel From Visual Basic 2005
  612. VLookup return validation list
  613. I want to insert a picture in an unlocked cell of a protected shee
  614. I need to count occurr. of the character "," in a single cell
  615. Auto select highest 25 scores.
  616. copy problem
  617. Automatic data entry in alternate cells based on drop-down menu se
  618. Formula to Pick Out Characters within a Text String
  619. Square a value
  620. Calculate true/false value based on array text input
  621. Will VLOOKUP help here?
  622. what does 'Subscript Out of range' mean??
  623. A week of dates and counting them using the COUNTIF function with contingencies
  624. how can I ignore or hide the #N/A when doing a sum or subtotal?
  625. Multiple Worksheet Tabs - Search Option?
  626. MS Excel 2007 file default general is changed to date, very annoying, please help?
  627. How can I hyperlink an option in a list to a different workbook?
  628. External References in Functions
  629. Only the last rows...
  630. Select a category from a list that populates related cells
  631. update subtotals based on filters
  632. Vlookup from the bottom problem
  633. CHAR and CODE
  634. Compare and delete in excel
  635. posting again -- it's urgent.
  636. vlookup for mutiple rows
  637. copy data to another sheet on condition
  638. ISNA Help
  639. Formula to ask if there is more than 10% difference between result
  640. AutoFilter settings in shared workbook
  641. Sumproduct and subtotal
  642. Sumif text is contained winthin a longer text string in a cell
  643. Cumulative sum on Condition (Horizontally) Part-2
  644. Excel Print Preview
  645. vlookup - more than one result
  646. Data sorting automatically?
  647. Search/Lookup and Place
  648. lookup 1 value and return multiple corresponding values
  649. Sum of filtered data
  650. Entering IF formula
  651. 2007 EC Excel - Access User Conference
  652. Fraktile function
  653. Array/Lookups, etc...
  654. why workbook disappear ?
  655. Scan and remove column data query
  656. Bit wise and function.
  657. Cumulative sum on Condition (Horizontally)
  658. External References - Forcing Relative File Referencing
  659. Auto Fill
  660. wildcarding text in IF statement
  661. how do I carry cell colors?
  662. Excel help
  663. Weird Problem..hoping to find a solution
  664. Data Validation
  665. Why are my formulas and vlookups not updating?
  666. CountIF-dual conditions
  667. rounding sums base on value
  668. Import Data -- External Web Query
  669. summing the values in nonblank cells
  670. Keyboard shortcuts to move between worksheets within a workbook
  671. Average Age of Population on a Specific Date
  672. OFFSET function in named range returning wrong # of rows
  673. Re-format cell to a number
  674. convert date mm/dd/yyyy to dd/mm/yyyy
  675. Is there any way of viewing the formula of a locked cell?
  676. Excel copy down changing sheet number
  677. calculation time problem
  678. Can I set up excel to use Yahoo instead of Outlook to send a workb
  679. determining latest duplicate
  680. Is this legal?
  681. SUMPRODUCT not recognising dates
  682. setting fixed decimals in only one column of worksheet
  683. histograms
  684. Links to External Workbook
  685. What is the formula for adding a group of worksheets together?
  686. Recordset.FindFirst argument not working...
  687. Lookup with offset
  688. Excel help please!
  689. Copying info from a Browser window into Excel
  690. I want to enter a figure &excel makes last two digits decimals
  691. Sum all numeric values in this formula
  692. What function will find and multiply specific values in excel?
  693. What function will find and multiply specific values in excel?
  694. Function IF or COUNTIF
  695. Median for frequency distribution
  696. IF function help
  697. MS Excel
  698. functions to use
  699. Get "#VALUE!" as result using HYPERLINK function
  700. INDIRECT
  701. functions
  702. Fixed Decimal
  703. Removing carriage returns from excel
  704. Click "Enter" move to cell to the right, not down in Excel
  705. Linking to an online map service
  706. EXCEL: How do I format a cell if value < 12 then show "LOW STOCK"
  707. EXCEL: How do I format a cell if value < 12 then show "LOW STOCK"
  708. Conditional format
  709. Zero's show as being negative numbers
  710. area under the curve of a trendline
  711. Formula result not appearing in Cell
  712. If Conditions
  713. creating hyperlinks in excel that won't lose integrity when file m
  714. comparing lunar (Hijri) day with a number
  715. Can a cell value be set equal to a spreadsheet name
  716. Conditional Count (Array Formula?)
  717. How to run this macro
  718. Zero's are showing up as negative numbers
  719. Save several copies of the same worksheet
  720. Direction combine several excel worksheets, drop down lists and da
  721. Validate format of values
  722. Need help with cells
  723. Need help with cells
  724. How do I sort an excel spreadsheet based off of subtotals?
  725. substiute formula = subing something to "
  726. insert column
  727. INDEX and MATCH w/ Drop Down Lists
  728. Return unique data from a list
  729. Mod Formula for Mileage?
  730. Lookup multiple columns
  731. How to find SECOND occurrence in a string?
  732. Macro for Adding Lines to Linked Spreadsheets
  733. if value equals whole number then ...
  734. How can I count the number of cells that have conditional formats?
  735. Rating
  736. Displaying row information in another file
  737. DisplayedText?
  738. how do i set up inventory for food?
  739. Lookup/Array Formulas
  740. how to count maximum number of lines repeated for a site
  741. Sumproduct with nested sum
  742. how do i convert numbers (25) into words (Twenty Five Only) ...
  743. Copying names and frqequency of occurrences.
  744. add extra space before comma
  745. how to insert a page number in a cell
  746. Deleting some text from a cell
  747. Select Worksheet to print Macro
  748. Options Dialog Excel 2003
  749. Count Unique Occurences
  750. analysis data into range
  751. Financial functions
  752. Move the negaive symbol from the right to the left side of a numbe
  753. is it posible to do payslips for a small business in excel
  754. relation equation between two columns
  755. pivot table
  756. Basic excel functions
  757. Help creating workbook with worksheets "linking" cells
  758. Lookup tables?
  759. how do you copy a cell without the formula?
  760. how do I type "itis" without Excel putting a space "it is"?
  761. Finding 'total' in range
  762. Auto Update in Excel
  763. MSN StockQuotes Excel add-in
  764. Dropdown list
  765. Stock Quotes
  766. If time falls within time..
  767. autofill on fixed dates
  768. Complicated question, for me anyway! :)
  769. Excel Program Error
  770. How to replicate formulas
  771. Help debugging a VLOOKUP and MATCH combo
  772. Breaking tie breakers using multiple colmns
  773. Active row cell reference
  774. Referencing cell in active row
  775. SUMPRODUCT #VALUE! problem
  776. Stock query can't pull more than 10 years of data
  777. simple recode operation
  778. Obtain CD quote with MSN Money Stock Quotes add-in?
  779. Count Q
  780. I am trying to find drafting symbols
  781. Comment Box Positioning Q
  782. ToC for sheets?
  783. Countif only col a = col b by date
  784. Add up Q
  785. Nested formula trouble
  786. Nested formula trouble.
  787. Find Last data in a column
  788. How to convert a table to list?
  789. replacing contents of a cell with data froma list/file
  790. Conditional formatting
  791. Type data in one cell - and it automatically populates another cel
  792. automatically copy formulas down columns or copy formulas all the
  793. changing average if cells populated
  794. Calculation
  795. Linking Daily Worksheet To Daily Invoice Total
  796. changing average calc if cells populated
  797. DELETE PAGE WATERMARK ON A SPREADSHEET
  798. using page break preview
  799. Set some Excel records as a fixed footer on the end of a page
  800. forecast or projection
  801. Problem with Time Addition
  802. Dependent Drop Down Boxes
  803. Sending a Picture to the back
  804. How to add either radio buttons or checkboxes to an excel sheet?
  805. Formula needed
  806. Show result of a SUM in a VLOOKUP
  807. Hyperlink to a cell, in a different sheet, that cointains a specific taxt
  808. DropDown Question
  809. Delete all macros if workbook is saved with another name
  810. Pivot Table Dates
  811. How can I separate a large spreadsheet into worksheets?
  812. Array? Put values from random columns into 4
  813. Find the nearest Christmas to a date
  814. NAMES
  815. NCAA tournament brackets template from Template gallery.
  816. isna vlookup #n/a but not false
  817. Vlookup based on valid match of mutiple columns
  818. Modifying data in excel containing 4000+ formulas
  819. How to force B1 not equal A1???
  820. Sum and Offset: to add from a point to the last entry in the colum
  821. IF Statement
  822. Replace #VALUE! with contents of cell??
  823. Random numbers
  824. Pivot table: Custom "Summarize by" functions
  825. separate alpabets & nembers
  826. كيف يمكنني ان اجعل البيانات المدخلة لا تتكرر؟
  827. How to calculate EMi?
  828. how do you create a floating row?
  829. change value across cells
  830. If total answer is over default of 160 then 160, otherwise the formula i have works great!
  831. HELP! Unknown range
  832. date calcualtion
  833. =IF(AND(OR statement needed?
  834. Determining when calculation has completed
  835. Using list values as variable in secondary formulae... best way?
  836. Count if multiple statements in two columns
  837. Transpose Maybe?
  838. Formula Help
  839. Counting cells with multiple selection
  840. text lists - begin typing names
  841. how to duplex mulitple sheets simultaneously?
  842. Only show certain columns
  843. Merging text cells from two worksheets with one shared column
  844. Trouble copying info into a spreadsheet
  845. How do I stop Excel from progressing a formula in fill down or rig
  846. Why doesn't Print Preview doesn't show everything correctly?
  847. Array or VB script?
  848. Present Value of a Continuously Compounded Annuity Payment
  849. Vlookup rounding up rather than down
  850. Blank Rows
  851. Nested Formula - HELP
  852. Unwanted spaces
  853. Sumproduct and format issues
  854. Save As - Before Save Event, VB, another name
  855. Can not insert sheet???
  856. creating list
  857. cell reference "values only"
  858. print from macro, using if formula
  859. Creating Work Weeks
  860. Check if Numer is less or great then a fixed number and return a v
  861. Conditional Formatting
  862. how do I round up to the nearest nickel?
  863. CountIF Function
  864. How can I make a column "float" as I scroll horizontally?
  865. Date to Text
  866. Time array
  867. Statement writing problem
  868. Automatic creation of worksheets
  869. Same Format!!
  870. 66,000 excel record limit
  871. Average array
  872. I want to delete duplicate in one time
  873. How do I automatically copy data from one sheet to another?
  874. How do I import external data and create two formats?
  875. Problems with HLOOKUP and VLOOKUP
  876. Automatic Filter Options
  877. eomonth
  878. Creating a formula calculates time impact on achieveing sales quota
  879. Automatic Filter Options
  880. creating an array
  881. entering 1 cell fills the worksheet
  882. Creating a formula
  883. Creating a sliding scale discount
  884. Finding Cumulative Interest
  885. need formula
  886. letter number count
  887. Count consecutive occurances
  888. synchronize between sheets
  889. GROWTH too aggressive, TREND too conservative - what to do?
  890. Help with VBA, or maybe vanilla Excel function?
  891. vba for selecting multiple sheets to save as a new book
  892. formula with multiple worksheets
  893. Sumproduct Multiple <> Conditions
  894. how do i create a drop-down list using workbooks?
  895. VLookup Functions
  896. How do I use a wildcard in an excel formula?
  897. Syntax for using variables in a cell formula to reference paths/fi
  898. Creating a long string of text...
  899. Updating info from 2 workbooks where file naness change weekly
  900. Sumproduct Function Question
  901. sorting multiple worksheets
  902. 3D References Mode() Function Excel
  903. Math Question
  904. Formatting Printer setting in a Macro
  905. compile/syntax error to save active book to new location on networ
  906. Worksheet does not copy
  907. Ranking Function
  908. using vlookup
  909. Rearranging a date
  910. Using Exact() with VLookup or Match
  911. Specific Dates
  912. Printer Settings in a macro
  913. Self propogating list
  914. install a hyperlink in a protected workbook
  915. REMOVE LEADING ZEROS
  916. Pull out numbers only in cell
  917. Conditional formatting strangeness
  918. Replacing Text for Template
  919. Always show data from "Yesterdays" date from another worksheet
  920. counting entries within a cell's formula
  921. I have 2 identical workbooks within 1 file, how do I delete 1?
  922. Printer Multiple Worksheets with a particular Printer Setting
  923. Can I save a custom sort order for a specific spreadsheet?
  924. mapping two worksheets
  925. look up table problem
  926. most often values of a column
  927. Adding/Saving Combo Additems
  928. vijay 5
  929. Nested IF
  930. Validation on E-mail address
  931. Recognise text as date
  932. conditional sorting
  933. Sumproduct, two factors, wildcard, and three dimensions... is there a way?
  934. Alternate footers
  935. Cell Reference
  936. I need to set font on comments automatically to 16
  937. Saving Prompts
  938. Excel 2003
  939. Need function to return text value
  940. How to Find Funcres.xla in Office 2007
  941. Multiple Conditions for IF statement to evaluate
  942. sum formula
  943. Basic Rounding Format question
  944. How do I set up a cell colouring formula in Excell 2003?
  945. color Banding using visual basic
  946. Highlighting using Conditional Formatting
  947. VLOOKUP & Combining Worksheets - Please HELP
  948. How can i find an X value given a Y value?
  949. Getting file name in the body of the spreadsheet
  950. Excel - Averaging Over Multiple Workbooks
  951. How can I filter on rows that are shaded in a different color?
  952. How do you "strip" a hyperlink
  953. have excel go to defined cells when pressing enter
  954. Employee Turnover
  955. Custom View
  956. vlookup - multiple lookup values
  957. If And statements -- HELP!
  958. Copying Cell information
  959. Refusing to Date Format
  960. I have a spreadsheet with conditional formatting. I would like to
  961. matching values
  962. Sumproduct with both number and text formats
  963. Excell worksheets
  964. Shared File
  965. how do I sort tabs on an excel spreadsheet
  966. Equipment checkout calendar
  967. A different look at VLOOKUP
  968. Copy text from cell to cell with one cell changing text
  969. How do I count the number of records within a date range? New issu
  970. Excel Date and Time Function
  971. template for bank charges spreadsheet
  972. Equal to previous cell and named range
  973. Harlan Grove PULL Code Help Please
  974. Advanced Filter
  975. how do I calculate the age of a person
  976. Saving without deleting previous input
  977. =TRANSPOSE: getting 0es but waste cells wanted
  978. Time interval worksheet function
  979. Count If ?
  980. Wrap text in merged cells
  981. embaralhar
  982. conditional formatting "if part of cell contents contains string"
  983. Displaying contents of 2 cells in another
  984. getpivotdata to show details as a list
  985. How can I retrieve cells which have been permanently deleted
  986. Counting repeated occurances
  987. Solver Update Issue
  988. change the payment period of amortization schedule
  989. Need Help wih an IF formula
  990. Help and description for UDFs
  991. Use of OFFSET function
  992. Conditional Formatting for Formula Cells
  993. Help with filtering...
  994. Conditional format copying
  995. display current cell contents in another worksheet
  996. Problem with wildcard in complex formula... help?
  997. Please Help
  998. Macro & Hyperlink
  999. How do I lock unclock cells to protect the data entered?
  1000. Lookup by multiple criteria?