PDA

View Full Version : Excel Worksheet Functions


Pages : 1 2 3 4 5 6 7 8 9 10 [11] 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87

  1. Import various Worksheets
  2. Computing full Months
  3. Using Combo Boxes as a function
  4. convert $ value to day values
  5. LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied.
  6. Count Position of Filtered TEXT cells in a column
  7. Stop text from stringing into next field when empty
  8. How do i convert feet and inches to a decimal value?
  9. Macro problem
  10. Help with formulae
  11. PDF button
  12. The world is really unstable these days......
  13. Sheet Name
  14. Problem with small()....I think
  15. Stop text from stringing into next field when empty
  16. How Do I Get a date reference when linking excel worksheets?
  17. How to count number of occurences in an autofilter list
  18. What is the formula for bank account row balance column
  19. vlookup with lookup value of different length
  20. cell colour change
  21. HELP: Last row of the column containing blank cells between non-blank cells
  22. Excel needs hh:mm where hh>24 for hours worked per week
  23. User cannot save excel file in workbook
  24. How do I set a result of an "if" function to NULL; not 0 or ""?
  25. shading problems
  26. How do I link a certain number to a certain word?
  27. need sample of work with senarios in excel
  28. Swap data from one cell to another
  29. VLookup not recognising numbers
  30. Numbering every second row
  31. Conditional Formatting Intermittent at best
  32. Count Position of Filtered TEXT cells in a column
  33. Now()
  34. convert a range of lowercase text to upper text or vice versa
  35. How: Functions repeating...
  36. Is Indexing the right option?
  37. caluclated field in pivot table?
  38. Form Text Boxes moving
  39. Auto Update Sheet Tab
  40. Searches
  41. Is it possible to do a vertical lookup that matches on 2 criteria
  42. Working back from IRR
  43. using multiple split cell references in linest
  44. How do I group data using defined ranges?
  45. How do I obtain the address of a cell using the vlookup function?
  46. I want data on sheet 1 to input into sheet 2 also
  47. Is there an AVERAGE IF function in Excel?
  48. How maximum different creterias for excel filter?
  49. how do i set up a cell in excel so that it shows the current date
  50. incremental years
  51. continuing dropdown lists
  52. formulas won't calculate
  53. linest won't accept multiple reference ranges
  54. Multiple Criteria IF Nesting
  55. How do I make a working calendar
  56. sumif function
  57. how do an @if formula to meet criteria where x is divisible by 12
  58. link from rows to columns
  59. Multi-level Subtotals with Excel 5.0 data
  60. Adding numbers to current numbers
  61. Same Value In Multiple Cells
  62. How get true response when numbers divisible by 12?
  63. Adding Parenthsis to a Cell
  64. Formula(s) for area with more than four sides
  65. Updating Links to Other Excel Files
  66. #VALUE error when referencing spreadsheet on sharepoint library
  67. Excel - sum a column of sales monthly and quarterly?
  68. Adding a space with =A59&B59
  69. formula request
  70. Missing keyboard shortcut - CTRL+SPACEBAR
  71. can I turn off the memory carry-over from previously typed cells
  72. Can SUMIF function include AND function
  73. Vlookup
  74. How do I move up rows below blank rows in an address?
  75. copy ranges from multiple worksheets
  76. Auto Data Transfer
  77. Link Link Link
  78. Please Help with TRANSPOSE
  79. if functions with more than 7 ifs (ranges are possible?)
  80. Automating copying of data from different worksheets.
  81. due date for payable invoice
  82. Is it possible to calculate integrals with Excel?
  83. formula won't work unless column of data is a hard number
  84. Format Number to Text
  85. Help with a COUNTIF (I think)
  86. Adding percentages in a column and automatic formating of contents
  87. How can I use an "IF" command to compile different info?
  88. Data Validation circles
  89. IF and SUM
  90. Trouble formatting
  91. Rows containing "#N/A" are messing with my formulas, please help
  92. SUMIF
  93. Linest: problems using broken reference data
  94. Formula shown as a formula rather than it's result
  95. Creating Worksheet using Server Object
  96. RE: How to apply a format to an entire workbook
  97. Enter a customer name in the invoice workbook when the names are .
  98. Using COUNTIF to find numbers within a range greater than the mean
  99. underscore between name in excel csv format to export names into o
  100. RE: How to change a formula in one cell and have these changes appear
  101. RE: Modify SumIF... Array Formula
  102. RE: Excel should have a formula for Converting Julian Dates
  103. How do I insert a symbol BEFORE text for multiple cells in Excel?
  104. How to apply a format to an entire workbook
  105. Using COUNTIF & compare 2 different #'s
  106. How do I use graphics in spreadsheet cells to look up later?
  107. How to total itmes if they fall between a date range
  108. Arrows move worksheet rather than cell selection, how fix?
  109. RE: Reverse the sign of a number in a cell
  110. Excel should have a formula for Converting Julian Dates
  111. Reverse the sign of a number in a cell
  112. How to change a formula in one cell and have these changes appear
  113. Modify SumIF... Array Formula
  114. how do I nest functions
  115. Function to reverse the sign of a cell
  116. Manipulate an excel column
  117. Copy page format into an entire workbook
  118. Hyperlinking when it shouldn't...
  119. need some help on the right function to use..
  120. pasting from one excel workbook to another
  121. list a column in alpahabetical order
  122. OR function
  123. Distribution functions
  124. Link a list of employees with hire dates to a monthly schedule
  125. How to copy without copying
  126. CAN ANYONE PLEASE HELP ME????
  127. Looking Up Value Using 2 Criteria
  128. Articles recommended to read, where can they be found?
  129. How to unprotect Grouping controls
  130. Stripping time in Pivot Table Column Header
  131. HIGHLIGHTED NUMBERS NOT SHOWING SUM AT BOTTOM WANT IT BACK
  132. vlookup
  133. counting nonblank cells
  134. Help with lookup table
  135. Tool Tip when mouse over
  136. file links - arrays???
  137. Calculations too long
  138. dates formula
  139. How can I do finacial ratios with workings using excel?
  140. Hold a value while recalculating another?
  141. tool tip to open when the cell has the focus
  142. Icon is a hand permanently
  143. Copy worksheet without absolutle references
  144. Autofilter in protected sheet
  145. how do we calculate T-bill Price in 365 days year.
  146. Re: Help! Activate worksheet from a listbox
  147. Pivot Table - Preserve Formatting
  148. vlookup only a set of values.
  149. Create a formula to remove text to the left of specified char?
  150. insert symbol
  151. formulas
  152. C1 appears blank, but ISBLANK(c1) returns false
  153. Pivot Tables - updating individual columns
  154. How to compute StDev of only nonzero entries in a range?
  155. how to imort data in to excel file from other excel file?
  156. Geil
  157. How to combine Hyperlink with Lookup function?
  158. Calculate month-end date from date in adjacent cell?
  159. I need to put 4-5 sentences into one cell.
  160. How do i round up a price to the nearest 5,10,15 etc pence
  161. Formula
  162. Height/Width measurements
  163. Consecutively Number Purchase Orders
  164. Function syntax to compare cell contents
  165. Help with a hide row macro (not using filter)
  166. RE: i want to create a simple mailing list can u help
  167. RE: LOOKUP
  168. RE: How to Insert function right on text values e.g. 0180001640
  169. How to Insert function right on text values e.g. 0180001640
  170. pivot table dates are out of order how do I correct them
  171. Filling an array with data
  172. RE: Need help setting up a >< IF formula in Excel,
  173. extra results in the MAX function
  174. Linked files
  175. i want to create a simple mailing list can u help
  176. List of start of months
  177. RE: Excel: hold a reference to a single cell when copying formulas?
  178. LOOKUP
  179. RE: separate data in a column in excel
  180. Excel: hold a reference to a single cell when copying formulas?
  181. separate data in a column in excel
  182. stopping backup of Excel spreadsheet
  183. Need help setting up a >< IF formula in Excel,
  184. How do I insert something on multiple worksheets in one workbook?
  185. Logs and Antilogs
  186. Petty Cash Log Help
  187. locking information
  188. If I have the zip code can I make it put the city in another cell
  189. deleting certain text from cells
  190. Re: Help with: ListBox1.AddItem (ws.Name)
  191. Subtracting time
  192. today's date
  193. Capture first 2 letters from a product code
  194. enable Excel to recognize Cell Colors
  195. working with dates in fiscal years
  196. Time for some help (Please!)
  197. vlookup using two table ranges
  198. How can I create a formula out of more than 7 functions in excel?
  199. Text to equal "0"
  200. Transferring info between worksheets
  201. summing an array by product category
  202. Date Calculations
  203. Help crating a formula with various arguments
  204. How do I lock footers in Excel?
  205. Macro problems
  206. How do I apply a formula to #s already typed in a series of cells
  207. How can I add more dates to the employee operations timesheet
  208. fill down array to last available row
  209. Counting the number of checkboxes on a spreadsheet
  210. How to export xls file into CSV file
  211. add 3 non-adjacent % cells visually = 99.9, total shows 100.0
  212. REPLACE outside of highlighted column
  213. UNDO - how many times can I UNDO?
  214. sort sheet tabs in Excel
  215. Saving a sum
  216. i want to delete first 11 chara in for =$C6*F6-(F6*G6*$I$2*1.15)
  217. Omit/bypass cells in column equations
  218. Possible Variable in Rate Function
  219. Date and Time Formula
  220. Clean does not remove hidden formatting on a number
  221. HOW DO I FORMAT A CELL TO COME UP WITH € £ $
  222. How do I Pick a cell with highest value from a range of cells?
  223. round up a percentage formular
  224. new speadsheets open in seperate window
  225. search for word/number in excel workbook utilizing all tabs
  226. Cell Format
  227. How Do I format an Excel sheet to have a 3D effecrt in rows?
  228. How do I delete data in a column from a certain point on?
  229. Can you extract URL values from a list of cells?
  230. How to return # characters based on 2nd instance of value
  231. Index and Match issues
  232. Can you change the base number from 100 to something else with %'s
  233. how do I copy the contents of a cell from one workbook to another
  234. How do you change a drop-down list in Excel?
  235. whiting out error messages
  236. Auto Fit
  237. Vlookup reporting #N/A's
  238. format cell from data input to output form
  239. IF function?
  240. errors using Vlookup
  241. Dates in Excel linked with Outlook Calendar
  242. How do I search for more than one text character in one cell?
  243. How do I turn off Mouse Scroll in Excel(Shift key 5-times)?
  244. How can I search for more than one text character in a cell?
  245. Paste data repeatedly from different worksheets to a template
  246. Cell Password Protection-Multiple Worksheets
  247. trace dependents
  248. How can I repeat labels in a Pivot Table?
  249. search more than one character
  250. excel 2003 questions
  251. how do I auto cut & paste from one spreadsheet to another?
  252. Trouble with formula
  253. Is there an adjustable rate amortization schedule in Excel?
  254. can I delete entire row if adjacent cell formats differ?
  255. VLookup Errors
  256. subtraction of times, convert & multiply by a conditioned rate
  257. Auto filtering & COUNTIF
  258. MODE FORMULA ERROR
  259. Access link "add in" for excel
  260. Number of years, months, days between two dates.
  261. add time to cells
  262. conditional text
  263. How can I combine the functions of a vlookup and sumif without a p
  264. How to apply the same background to many sheets simultaneously.
  265. Changing cell formatting with IF function
  266. Re: Macro: Exit active workbook without save?
  267. Cell C1 ="error" if....
  268. Using Index with text
  269. Identifying cursor in active spreedsheet
  270. different currencies
  271. calculate number of working days
  272. Time Calculation in Minutes only ?
  273. getting a formula to find named worksheets in another?
  274. Not displaying #VALUE errors
  275. How do I use find in a macro in Excel
  276. Nested subtotals don't work properly after applying recommendation
  277. validation and omitting blank vaues from list
  278. e-mail address formatting
  279. how to merge all worksheets into one
  280. Excel prompts me to save a copy or overwrite file.
  281. Allow for COPY/PASTE in the "Comment" area
  282. Time Calculation in Minutes only ?
  283. Using a Macro to clear out check box seletions
  284. Edit cell automatically takes you to cell
  285. Pivot Tables
  286. How do I set up time tracking formulas?
  287. dragging without interference
  288. OT- Need to create an 11 & 12 man Duty Roster
  289. Conditional Format Formula Needed
  290. RE: string of numbers
  291. RE: Vlookup reference a worksheet
  292. string of numbers
  293. I need an add-in for Excel 2002 to convert xml to xls
  294. average of visible cells in a filtered range
  295. RE: replace absolute references
  296. Vlookup reference a worksheet
  297. Sumproduct....I think
  298. RE: percent formulas
  299. replace absolute references
  300. copying with hidden cells
  301. pasting data over hidden cells
  302. percent formulas
  303. formula to show ranges in columns
  304. Drop down menu
  305. month to month % change
  306. printing gridlines
  307. IF forumla for time
  308. XIRR
  309. user input function
  310. finding the no. of rows in a COL filled with numbers, zeros and bl
  311. How can I create an array formula for non-sequential cells
  312. What formula can I use to get daily totals from list
  313. Keeping date format of a field inserted from an excel database
  314. Sum Activecell Offset Problem
  315. How to Reverse Contents in an Excel cell (Text or a Number)
  316. automatically adjust numbers in a column when data is deleted
  317. Entering from List box
  318. Match and index functions: corrlating data from 2 worksheets
  319. Excellent=1, Good=2, etc.
  320. Using Tab Key In Excel
  321. validation
  322. Choose between two cells the lower result of a formula
  323. how do i nest more than 15 " if " functions in a formula
  324. Bill Payments
  325. copy one to cell to another by clicking and dragging
  326. Sorting data automatically
  327. Working with Sums
  328. Match Backwards
  329. exchange data between two files
  330. arrays in excel
  331. Error Messages
  332. TESTING FOR EROR
  333. Excel Server Object won't overwrite
  334. Where do I find
  335. HELP
  336. Extract using MID function ?
  337. formula help please
  338. Different Formats for Multiple Sheets within a Workbook
  339. Combo Box conflict with 'sort' on another page
  340. Transpose unique values in one column/mult. rows into a single row
  341. two-column lookup
  342. Match two lists and return a value
  343. data validation list drop down text format too small
  344. CELL function within HYPERLINK
  345. nesting more than 15 if functions in a formula
  346. mix text and formula?
  347. MS Query grouping
  348. I'm having problems with EOMONTH
  349. Conditional Formatting
  350. HOW NOT TO CALCULATE CELLS IF ONE CONTAINS "0"
  351. Calculating a bill using a graduated rate...
  352. Formula, Help needed
  353. Numeric formatting problem
  354. if a number is less than -1000 in Excel 2003
  355. Indirect Row & cell formula
  356. need help have audit and i'm going to get slaughtered unless
  357. How do I rotate Horazontial cells vertical, so part of the chart .
  358. Help with a COUNTIF, Please
  359. Range("C9:V9").Select ==> changing the 9 to a variable
  360. sum letters ex. d+d+d=3d
  361. changing cells in multiple worksheets
  362. How to sum total automatically in more than one sales invoices
  363. Summation format
  364. how many condition for conditional sum wizard ?
  365. Time Calculation in Minutes only ?
  366. Test
  367. Formulae using range names
  368. print different row titles in one sheet w/ many pages
  369. Vlookup Sum
  370. Vlookup Sum
  371. COUNTIF
  372. Pivot tables design
  373. offset problem list not sequencial
  374. Calculation conditional on yes no
  375. Document Properties
  376. Change Text-color depenting on SUM-function
  377. user defined function
  378. Hiding zeroes in Office 2002
  379. SUMIF with 2 criteria PLEASE HELP
  380. Header or Footer to show up on multiple sheets in a document
  381. Consecutive cells
  382. RE: IsNA(match
  383. Vlookup and Now()
  384. Cell Format
  385. Excel should let you sort by subtotals
  386. IsNA(match
  387. If then syntax
  388. list all conditional formats
  389. How to combine two columns?
  390. IF with AND and OR
  391. Highest Value / Circular Reference Help
  392. sort a list/remove additional entries
  393. how to remove header in excel on second page of document
  394. convert text to a value to be used in a formula
  395. Can you substract dates?
  396. How do I insert Sunday,Monday,Tuesday, etc. to repeat in nonadjac.
  397. sumproduct
  398. Re: "OR" operator to evaluate multiple conditions
  399. how do i reference data in a file with the fname in another cell?
  400. Cell Protection
  401. sumproduct external reference
  402. Passing Variable to LINEST
  403. sumproduct external reference#2
  404. vlookup error na#
  405. Free Tool (Add-in) To Speed Up Your Data Processing
  406. Is there a way to search for info in your excel document?
  407. how do I insert a row based on a function result
  408. vlookup problem
  409. Referencing Literal Arrays
  410. Combine two spreadsheets using Macro
  411. can you use cell references from Microsoft spreadsheet in excel ch
  412. Re: Lookup + Sum multiple columns
  413. excell worksheet - how do I get the grids to show?
  414. Limited logins
  415. Fill array with fn variables that vary across and down?
  416. Taking data from 3 columns to make the fourth.
  417. Formula for Excel User Name
  418. identify even numbers with a "1" and odd numbers with a "0"
  419. why is my blank cell not a blank cell
  420. SUMPRODUCT + DATE = 0
  421. SUMPRODUCT + DATE = 0
  422. Date/time Duration
  423. I wish to save my Excell work in my work sheets
  424. cell formatting
  425. Re: Excel Function Help
  426. SUMPRODUCT or SUMIF or ...
  427. Formatting Text
  428. COUNTIF and then SUM in Same Function
  429. SUMPRODUCT or SUMIF
  430. HOW DO I LOOK UP AVALUE IN A TABLE WITH USING 2 DATA SOURCES
  431. volatility calculation
  432. Help with IF and drop down lists on a look up
  433. Sort formula
  434. offensive postings
  435. Re: HELP with this function
  436. Paste Functions and Update info
  437. Function Question
  438. Book1.xlt in XLSTART folder
  439. Hex low values
  440. EXCEL ARRAYS & IF STATEMENTS
  441. what function can i use to tell me if 2 text cells are the same?
  442. weeknum function returns name error
  443. insert rows in excel spreadsheet via macro
  444. Need a function that separates over-lapping work shift hours.
  445. Excel database
  446. SUM IF and two variables
  447. Splitting multiple cell contents containing values at end
  448. HLOOKUP FUNCTION
  449. conditional if based on a word value...
  450. Excel database
  451. How many in column
  452. Spreadsheet will not print out legibly even after scaling
  453. RE: how to automatically color a cell
  454. RE: help with offset function
  455. How do I create a ratio function in Excel?
  456. help with offset function
  457. will excel work out algerbra
  458. CALENDAR
  459. Unix Time Function
  460. how to automatically color a cell
  461. Multi Variable Formula
  462. Calendar
  463. IF Worksheet Function
  464. Conditional Formating
  465. IF function: Reference cells - Value vs Formula
  466. Counting Dates
  467. Help with my MLB Formula
  468. Excel Match value_lookup asterisk syntax
  469. CORREL formula with criteria
  470. hide errors when printing
  471. Converting number of days to years and months
  472. what is an advantage of using a model?
  473. formula to analize info in a cell
  474. Automate grading of performance test results
  475. {} SumIf and CountIf
  476. Formula that looks at two columns
  477. how to get a cell on a page to equal the bottom most cell on dif
  478. formula to standarize cell length
  479. Updateing formulas
  480. Deleting Macros
  481. Customized Formats
  482. Finding negative and positive diffrence
  483. changing value of a cell by selecting an item from a drop down list
  484. How do I create a macro, that references another excel file ???
  485. Formula including dates
  486. Re: Mode Function??
  487. How do I Double Conditional vlookup for 3 columns?
  488. conditional lookup
  489. Have Vlookup return a Value of 0 instead of #N/A
  490. Adding an accumulator for multiple cells
  491. Column A
  492. Excel - IF Formula and #DIV0!
  493. color filled cell invisible on work screen
  494. Counting dates in a column
  495. How do I Print the Results of a FIND ALL from multiple worksheets?
  496. on exel how do I can take out the ceros on the woksheet?
  497. re:Nested Function
  498. Mulitple conditonal match / Vlookup
  499. limit of 7 nested functions?
  500. how do i define a range as a list when there is no list option in.
  501. Average of an array of entries, minus the lowest entry
  502. excel not linking
  503. trying to write a formula ivolving data validation
  504. Condional formatting
  505. Forecast problem
  506. solver- maximum profit
  507. Subquery
  508. pivottable and OLAP cubes
  509. Re: removing character from field
  510. calculation of interest between two dates
  511. PASTE DOWN FUNCTIONS
  512. How can I move the comment box to the left of the cell?
  513. find the cell above any number in any range
  514. Be able to move not delete filtered records, to see the duplicats
  515. help with formula please
  516. Highlight rows as you scroll through spreadsheet
  517. Cursor movement
  518. allow macros in protected worksheet
  519. Pivot Table Field Settings
  520. Re: copy 45 rows down, repetativly, only on button click?
  521. Re: Help with Aging Report
  522. splitting text within parenthese into new column
  523. Conditional Formatiing
  524. count
  525. Excel
  526. Clearing Check Boxes and Cells
  527. Want Excel to break links between worksheets in same file
  528. creating a formula for a timecard obiding by CA OT laws
  529. Automatically scrolling to top of worksheet
  530. SumProduct?
  531. Average top 10 or bottom 10
  532. finding what numbers are in a string
  533. Where can I post Macro questions?
  534. Passing selected workbook name and values to a macro
  535. Conditional Formatiing
  536. IF Problem
  537. Searching for multiple conditions
  538. links in a cell
  539. Format from Access to Excel is busted...help...
  540. countif two variables in two different columns
  541. Excel function countif???
  542. Using data in cell for a formula
  543. Transposing a column to several rows
  544. counting only specific numbers in column
  545. adding part of a function on condition.
  546. easy DSUM question
  547. How can I make a number e.g. "14" appear as a word e.g. "fourteen.
  548. How can I convert a date into a week number...
  549. Counting a day of the week
  550. Hiding/Unhiding
  551. Wildcards in formulas?
  552. excel calculations
  553. indirect and offsetsheet
  554. generate multiple rows based on cell value
  555. Subtotal on SumIf
  556. number formatting question
  557. Space between decimal numbers
  558. convert number to text in Spanish Language
  559. How to Sort Protected Worksheet
  560. Counting a list
  561. How do I Concatenate these Dynamic Rows
  562. Consecutive Cells
  563. how to delete/clean out the row list in pivot table
  564. IF function to blank without getting #value in sum function
  565. Can series tool change formulas over time when used to copy them
  566. What is the Formula to Convert Imperial to Metric Measurements
  567. How can I use black scholes formula in Excel?
  568. Identification of "<" character at beginning of cell
  569. IF function Between
  570. Multiple lookup in a single formula ..
  571. Age-distribution graph
  572. Removing blank rows in a worksheet
  573. entering data to table
  574. VLookup with concatinated named range
  575. Microsoft Excel - Grouping and Sorting Cells
  576. Inserting rows
  577. VBA data Capture in a Form
  578. Need excel formula to sum 1+2+3...+N given a number N
  579. Print when check box checked
  580. Border lines not printing
  581. Finding a match in several columns
  582. Difference between 2 times and dates
  583. Using a single cell in multiple formulas
  584. Re: vlookup, sumif, if, countif, help
  585. Detecting Blanks and Non Text Characters.
  586. change 5523.44 to 552344 no decimals
  587. Conditional Sum and multiple conditions across different sheets
  588. Excel should let me use formulas that refer to other cells w/ form
  589. Can solver be used to make a cell equal to another cell
  590. SUMIF
  591. VLOOKUP to search multiple values?
  592. pivot tables - calculated fields
  593. VLOOKUP with more than 7 levels of IF
  594. How do I remove a list created in a spreadsheet
  595. Re: How do I sum an array with multiple condition??
  596. Cannot copy or move array entered formulas ... shared workbk
  597. Conditional Format Feature
  598. Cell Value
  599. Conditional formatting applicable to entire column
  600. Un - Concatenate ?
  601. Custom Cell Formatting and Calucations
  602. Force entry to one of three cells
  603. Need to read formulas
  604. Changing an excel spreadsheet into a text delimited file
  605. Numbers Converted to Text - Last Digit Replaced by Zero
  606. How to assign a marco to a command button
  607. AVERAGE and STDEV functions with logic
  608. Excel "Forgets" text-box text-direction
  609. What function gives the Sheet name in Excel ?
  610. how do I add a calendar function to excel as a drop down?
  611. Button sizing handles do not appear
  612. syntax to refer to a range as an array?
  613. Auto-Insert Last Date Edited
  614. Finding Value Conditional
  615. Nesting IF Statements Based on Same Cell Value
  616. How to delete rows when List toolbar's "delete" isnt highlighted?
  617. Understanding a formula
  618. Data Validation (in a range of cells)
  619. URGENT!!! shared workbooks
  620. Re: Easiest Way to have access functionality in Excel or vice-versa?
  621. Can I have a running total which begins again at 0 when dte chgs?
  622. splitting my header into two lines
  623. FORMULA CONCEPTS
  624. Countif for specific cells rather than a range ????
  625. Marking Duplicates
  626. Understanding a formula
  627. Dates
  628. finding what numbers are in a string (Day 2)
  629. excell 2000
  630. please give me an example of vlookup
  631. SUMPRODUCT issue
  632. Macro to cut/paste to last cell
  633. How do I set up a time sheet using the 7/8 rounding rule?
  634. Macro to email multiple worksheets
  635. lookup
  636. concatenate problem
  637. Save Prompt
  638. Comparing text fields
  639. Print Worksheets function needed.
  640. How do I change font attributes in a Concatenate statement?
  641. How to add data in two columns in to one column
  642. Re: Excel Cell Restrictions
  643. Count values ...
  644. Curency Conversion Dilemma
  645. Function to remove a space from text in cell WITHOUT macro??
  646. how do i calculate pay from given hours and pay rates?
  647. Problem with data from Access
  648. Copying the Editing in one file to Another opened XLS file
  649. when copying formulae from one cell to another it does not work
  650. Conditional Formating Feature in Excel
  651. Formula for This?
  652. Cell Formatting
  653. When subtotaling can Excel also calculate percentages
  654. Construct cell reference for use in formula
  655. Help please!!!
  656. Filtering
  657. Moving Decimal Places Up
  658. How can I determine the century of a date in Excel?
  659. HOW DO I SUMMARIZE A LIST OF TEXT, I WANT ONE A TO SHOW UP NOT 10
  660. How do I apply conditional formatting to a text box
  661. Paste link does not work properly
  662. Using a ComboBox for Data Entry into a Cell
  663. Comparing two columns in two different worksheets
  664. #Num Error with Rate Function
  665. Insert Hebrew Date
  666. If Statement Question
  667. File Pahtway in Cell
  668. Macro help
  669. Calculating total amount of sales for each salesman
  670. RE: If Statements and Arrays
  671. RE: Remove text leading zero in text string
  672. If Statements and Arrays
  673. Remove text leading zero in text string
  674. Counting Textual Answers
  675. Sum if type question?
  676. Ranking of cells from 1 to 20 with ties
  677. How can I erase all but every 87th row in Excell?
  678. Compound Rate Function
  679. Numbers used for Ranking
  680. Defining Ranges
  681. =mid function
  682. How do I hide columns using a button that slides back and forth
  683. External link
  684. what's the closest think to an "average if" function?
  685. How to Calculate an unknown number?
  686. Reference the worksheet from a multiple worksheet range function (
  687. How to pull data out of an excell file with multiple tabs
  688. Combinging two spreadsheets
  689. Functions
  690. How to od a combined IF and AND in a matrix formula
  691. Click please
  692. Teens4cash
  693. countif max value help!!!
  694. calculate min in col B subject to text in col A
  695. Max limit of 7 nested loops
  696. Cobining more than 30 columns of data with concatenate.
  697. How to cancel number rounding?
  698. Lookup function returning reference, not value
  699. Prefill cust info from drop list into other cells
  700. Just $19.95 to start -HOME BUSINESS
  701. How do I apply the ROUNDUP formula to a range of calculated data
  702. can I name an excel worksheet tab by linking to worksheet data?
  703. I am having trouble adding a row in Excel. What am i doing wrong?
  704. find replace
  705. Construct address as a reference not "text"
  706. Problems with Sum Function
  707. update info on 2 sheets @ same time
  708. concatenating "00"&"00"&"01" without losing the zero values
  709. How do create a formula to evalute a # to return 1 of 4 conditions
  710. How to combine dat from 4 fields into one field
  711. Decimal Question
  712. COUNTIF and Nested Functions?
  713. How do I get a spreadsheet to print to actaul size of page?
  714. if statement module use please help
  715. Stupid
  716. help with forumla needed... getting a yes/no answer to ??
  717. Horny Teen Girls
  718. Constant growth
  719. Dynamic Formula
  720. Need a formula that would make life easier
  721. same formula giving diff resutls
  722. converting hours to days,hours,minutes
  723. validation combo boxes not working
  724. How do I sort a horizontal worksheet to create a vertical table
  725. Bilingual workbook problem
  726. Login Logout Date Problem
  727. Help need with formula
  728. ACTIVATE CELLS
  729. random numbers from a data of numbers?
  730. IF AND question
  731. IF AND question corrected
  732. IF statement to check cell contents
  733. Excel should let me imbed documents and programs within its-self
  734. Help with function to add percentage to cell based on checkbox.
  735. autonumbering
  736. Formulas e Funcções
  737. pair single column to multiple column
  738. Extracting data without using database functions
  739. combining numbers into combinations
  740. Command
  741. re:Any Ideas?
  742. Rank Question
  743. Activate List of Email Hyperlinks
  744. Lookup worksheet agony
  745. Excel Calculation
  746. #N/A resutls in Vlookup when there is a match
  747. Why am I prompted for the workbook password for each worksheet?
  748. Summing up time
  749. adding a formula in a cell but when cell = 0 cell is blank
  750. How do I count the number of alpha occurences in a range?
  751. How to change a visible formula into a value? (Quickbooks download
  752. deleted w/sheet. How do I recover
  753. Sorting a sheet
  754. I'm Lost, Need Help
  755. excel compatibility
  756. Can I count cells with specific format (e.g., yellow field?)
  757. Excel takes along time to calculate
  758. Insert excel data source into word doc using currency symbols
  759. Combining specific ranges from multiple worksheets into one
  760. How to find method to cut steel coil by using excel.
  761. transferring checkbook template to excel
  762. A way to refresh a certain cell everytime wroksheet changes
  763. Fonts
  764. Even and Odd Numbers
  765. How select an item in a list box
  766. renaming problem
  767. sumif with 3 conditions
  768. How do I perform a contains function for a specific cell?
  769. Hyperlinking
  770. preventing one part of a formula from iterating
  771. Ticks or Crosses
  772. add cell across all worksheets
  773. normalizing data -- a twist
  774. NETWORKDAYS gives #NAME even though Analysis Toolpak is installed
  775. Re: Autofill date based on date in another cell
  776. Access Rights & Reports
  777. Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
  778. RE: Sumif Fucntion
  779. RE: nesting functions
  780. HOw do I set up Standard Error in a spreadsheet?
  781. Volume and pricing calculations
  782. RE: COUNTIF or SUMPRODUCT counting multiple criteria
  783. RE: Macro - formula for end of last row
  784. Column number of last column containing a number
  785. Only do Sum function if not "0", IF"0" then return "0"
  786. RE: Lookup Value is Between Range 1 and Range 2
  787. RE: COUNTIF across all sheets of a workbook
  788. nesting functions
  789. making a number be text
  790. Formulas in Excel
  791. How do I put more than one criterion in a SUMIF function?
  792. Opening Excel out of explorer or outlook attachment
  793. Recogniziting Dates in an IF function?
  794. Count the number of specific values in a cell
  795. RE: SUMIF using a multiple-column range
  796. ISERROR VLOOKUP
  797. Putting Sheet Names in a range and renaming it?
  798. Macro - formula for end of last row
  799. COUNTIF across all sheets of a workbook
  800. Empty cell control
  801. Product development requirements tracking
  802. Lookup Value is Between Range 1 and Range 2
  803. Count if not 0 or return value of 0
  804. COUNTIF or SUMPRODUCT counting multiple criteria
  805. Is there a function that allows me to list the names of excluded d
  806. SUMIF using a multiple-column range
  807. Sumif Fucntion
  808. How do I have a formula check if a value occurs within a range?
  809. Determine the location of an external source of pivot table?
  810. Sumif and autofill
  811. Linking from several cells of 1 spreadsheet to fewer of another?
  812. need to program my lists to automatically alphabetize when new ent
  813. How do i make a formula reference the last entry of a column
  814. Help with an if statement
  815. Web Services function call and data refreshing
  816. Sort data from 1 work sheet into another
  817. delete rows from multiple worksheets
  818. more conditional format conditions
  819. How do I calculate the area under the curve using Excel?
  820. subtracting hours and minutes
  821. the best prediction formula?URgent!
  822. hidden names in active workbook
  823. Converting 100 cents to 1 dollar
  824. calculate predicted sales value
  825. Filtering data to another sheet
  826. calculate interest between two dates
  827. a search function
  828. emailing
  829. How do I use 2 worksheets in 1 page
  830. Time Date Formula Problem
  831. Re: Do I need a sumif or sum of a vlookup formula?
  832. What is the use of {} before any formula?
  833. Troubles with the OFFSET function
  834. Array formulas
  835. Trying to email a spreadsheet
  836. Formula for next day based on clock
  837. daverage problems
  838. Re: can lookup a number to a 10x10 table?
  839. how do u remove default setting?
  840. VLOOKUP WITH ALPHA NUMERIC
  841. Averge time
  842. Search and Get Function Help
  843. Is there way to restart page numbering for each tab in worksheet
  844. My copy function won't work - I get error "cannot empty clipboard
  845. help needed with text to column
  846. Date Formula
  847. Length of employment
  848. warning or message before saving spreadsheet
  849. Opening Multiple Worksheets
  850. Displaying only digits after the decimal point
  851. how to make cell address reference increment?
  852. Conditional Formatting Multiple cells based on 2 cells
  853. DECIMAL PLACES IN FORMULAS
  854. counting unique instances of text in a list
  855. if statement in worksheet
  856. Excel to Access
  857. Formula for # of sales days in a month?
  858. Optimize simple macro
  859. using a slave worksheet
  860. Reference to another worksheet
  861. maximum of rolling totals - aka Rmax
  862. Gridlines into excel spreadsheet after changing background color
  863. How do I use Office 2000 & Office 2003 on a network?
  864. Hyperlinks change when Excel file is saved to a different director
  865. Return range of values on an "IF" statement
  866. vlookup
  867. How do I get rid of infinite numbers past the decimal place?
  868. Merge Worksheets
  869. help!!
  870. Why do my dates change when I copy them between Excel worksheets?
  871. Random Numbers
  872. working with IF statements
  873. No showing of cellnumbers used in formular with colour
  874. List
  875. Automatically inserting rows
  876. "COUNTU" function in Excel to count unique entries in a range
  877. Excel Statistical Functions and Routines
  878. calculate the value of a mortgage purchased at a discount
  879. Past Due - Due Dates
  880. List
  881. Separating Numbers
  882. Can I add a Warning Meassage to a Macros Designed to Delete a Row
  883. Unexpected result
  884. How do I move or copy more then one sheet at a time
  885. 16th digit changes?? Problem,16th digit changes to a zero....
  886. =B
  887. How to Calculate Time
  888. comparing a value in a cell to see if it is higher than a number
  889. the cell currently being evaluated contains a constant
  890. SUMIF??
  891. Returning an answer in an if fuction between two values
  892. Match/Lookup Statements
  893. Format Excel column to notify with a reminder
  894. Excel function problems
  895. Excel % Variance Formula........
  896. Pocket Excel/Workday Function
  897. Wildcards in other workbook cell refrence?
  898. Dependent lists
  899. Formula on nth row
  900. look up same values in coumn1 and calculate values in 2nd column
  901. stop automatically changing fomula ...
  902. Multi-layer excel spreadsheets
  903. if coum 2 has vale then populate colum1
  904. Complex If Then formulas
  905. How do I get a row to show up on every page
  906. The ExcelTip forums update this forum
  907. Logical Function
  908. Time Value of Money
  909. Is Datedif Outdated ?
  910. SumIF Formula
  911. Anagrams
  912. automatically filter out blanks in multiple columns
  913. in excel I want to set up a drop down & link that to another cell
  914. Options Button
  915. name list
  916. I cannot get Excel to put negative amounts in brackets. Help !
  917. Counting capacity based on technician schedule
  918. macro used to change colors
  919. Still need help
  920. SumIF
  921. Name list
  922. How do I count how many times a code appears in a column?
  923. cells functioning odd
  924. Advanced use of IF
  925. Use formula to hide/delete cell?
  926. Syntax for 2 AND conditions within an OR function.
  927. subrow names must appear in consolidating by category as tab name
  928. need function to sum top ranking items in list
  929. Data Valadation -
  930. SUMIF With Multiple Categories
  931. Sorting data in a master sheet
  932. 2 files, mass update comments between files
  933. Formula checking multiple worksheets
  934. Cell Height formula?
  935. Data Manipulation FUNCTION
  936. Is there any way to get an AVERAGEIF & MEDIANIF function in Exce
  937. Conditonal Format Formula
  938. vertical text
  939. Exclude data from summary totals when hidden
  940. How do I create a numbering format in excel?
  941. sequential numbering in non adjacent cells
  942. column changed from alpha to numeric
  943. extracting text data in a cell
  944. conditional value required on basis of column a
  945. Search in 2 kolumns and 1 row
  946. Further Question about Transpose
  947. Pivot Tables
  948. Please help with formula
  949. Help Userforms / Excel SUMIF
  950. HOW DO I GET THE EQUIVALENT OF MAXIF(RANGE,CRITERIA)?
  951. Average of filtered data
  952. Conditional formatting in relation to other cells
  953. MARK EVERY FOURTH ROW
  954. SUMPRODUCT vs CSE
  955. Decimal points not needed
  956. Pivot Table - Extracting specific data
  957. Pivot Table - Extracting specific data
  958. Conditional Formatting with two Spreadsheets
  959. alternate blank row
  960. problem with SUMMEWENN
  961. How do I shade cells during selection?
  962. Nested Countif
  963. "Sumif" and "DropDown" in palm
  964. move column headings from row to column
  965. How can I locate the second to last value in a range?
  966. monitoring a changing range of cells
  967. Can I use cell contents as part of a formula?
  968. find and replace links in Excel 2003
  969. "Drop the lowest" in computing average
  970. Formula checking multiple worksheets
  971. Calculating recurring date in following month, calculating # days in that period
  972. VLOOKUP works sometimes
  973. Delete columns or rows
  974. Excel Statistical Functions and Routines
  975. jump to hyperlink, extract value at specific destination in file
  976. Vlookup through entire column
  977. Font size
  978. Last Value in Column
  979. Counting Unique Cells When Spread Sheet is Filtered
  980. Sort of format Question
  981. Excel should allow calendar based spreadsheet linking.
  982. If Formula suggestion
  983. nested function to add columns
  984. MS Dialog 5.0 sheets - Accessing data elements of objects
  985. Is is possible for a cell to reference it's "sheet name"?
  986. CountIf first column range = "Word" and second column range <> 0
  987. Produtivity Formula
  988. Can anyone show me how to set up Excel for feet and inches?
  989. helpfull links
  990. how to get the rounding function off
  991. SUMPRODUCT using and INDEX function doesn't total
  992. Assign vaiable to a cell - gold
  993. Why do we start the formula with + or -
  994. Autofill/Reference Confusion
  995. Formula checking multiple worksheets
  996. IF Function
  997. Is there a way to pick the cells to add using sum?
  998. How to do more then one vlookup?
  999. How to print the column # where the max row value is located?
  1000. Automatically enter today's date as a static entry
Google