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. Here's a doozy
  2. Formula not working
  3. Rephrased - Remove blank cells - no sorting, copy or pasting
  4. I want quarters not months
  5. please help, need to copy row to separate spreadsheet in workbook
  6. Date Question
  7. Date-Mid Function
  8. Find values on another sheet
  9. Is merging rows possible?
  10. create a spreadsheet that would insert a current date() when opene
  11. Formatting imported data
  12. How can i make a cell compulsory to complete?
  13. VLOOKUP
  14. Color doesn't display -all black & white
  15. IRR on conditional subset of cashflows
  16. Average with Criteria
  17. Set up many cells within a cell
  18. Validation with if
  19. Multiple If Statements
  20. "too many different cell format"
  21. Need to reorganize data on a separate sheet possibly using vlookup
  22. How to input data into a workbook using print command
  23. Shift Scheduler
  24. Last cell always IV4036
  25. excell
  26. SUMIF with criteria
  27. Conditional formula(s) & labelling
  28. VLOOKUP Question
  29. make VLINKUP like vlookup; smart hyperlink by data value
  30. PIVOT HELP
  31. Excel 2007 Autofilter deleting unfiltered Data
  32. My excel spreadsheet won't print or print preview all the pages?
  33. Using Text color as criteria in formula
  34. How can I display the first business day of the month?
  35. How do I display character count on the status bar?
  36. If/then formulas
  37. dates for on time delivery calc.
  38. 401k Match
  39. Plus/Minus 2*Standard Deviation IF OR Statement
  40. Labeling Grouped & Collapsed Columns
  41. Value Function
  42. How do I print grid lines?
  43. Counting items in one column based on criteria in another
  44. Multiple product selector
  45. Sum a range based on two variables
  46. Working day(s)/Time between two dats (No Weekend or Holidays)
  47. Vlookup when have 2 or more criteria to meet
  48. Counting cells in a range per multiple criteria . . .
  49. Linking Cells
  50. Linking Cells
  51. Need correct IF(ISBLANK) formula when referencing whether one of twocells (OR) is blank, returning "no value"
  52. How to hyperlink 800 documents to spreadsheet describing each docu
  53. "IF" Function
  54. help with sum if
  55. Nesting of more than 7 in an IF formula
  56. sum a set of cells based on comparing a different set of cells
  57. Compare two tables
  58. last value "greater than zero" in a range
  59. Custom number display format
  60. Notification when file changes
  61. Countif or Sumproduct
  62. Formula Help pleaseee URGENT!!!!
  63. Help needed with Formula
  64. Entering several pieces of info by typing just 1 defined name
  65. Return the row number of Median value of a column
  66. I NEED HELP PLEASE
  67. Count number of row for Particular month
  68. Custom Number Format / Color and Sign
  69. How do I change the contents of a Named List
  70. Advanced Apology
  71. HOW TO GET TRACKING SYSTEMS
  72. Reporting Highest Values
  73. Can I create more than 3 Condidtional Format conditions or can I w
  74. Compare two tables
  75. If function
  76. I want formula for multiple criteria using ih differnt column
  77. XIRR Problem
  78. Is the solution Vlookup?
  79. index & match
  80. Sumif with Multiple Criteria
  81. Return a list of cells based on data in a single cell.
  82. column headings
  83. How do I reorder sheets in excel
  84. Calculation formula
  85. How do i disable/enable "Worksheet Move or copy" option?
  86. simple Lookups in external xls files..
  87. Linking Entire Worksheet
  88. Orderign/combining data from two columns in one
  89. How to Functionally move one cell to another
  90. Anyone have spreadsheets to keep information wrt: livestock?
  91. Cell to read exactly what I put in cell
  92. Nested If statement to control format of number-type cells
  93. Copy and paste absolute reference
  94. Formula Bar F9 Result differs from cell result???
  95. comparing two lists of last names
  96. Conditional Summing
  97. Formula for Excel Worksheet
  98. Vlookup question
  99. if formula returns a weekend - move it forward to next weekday
  100. Importing/linking worksheets into different workbooks.
  101. move or copy sheets doesn't copy format
  102. Daemons Tools
  103. Don Where do I put the VBA Code?
  104. Side to Side feature
  105. Count # of times the same number shows up in Excel spreadsheet
  106. Combining SUMIFS and filter SUBTOTALS
  107. Count Colors in 2003
  108. Need VBA Code/Marcos To Hide Less than zero amounts. Not a filter
  109. RE: Functions & Formulas
  110. sum by category, by month
  111. IF statements
  112. Comparisoning Two Barcode Lists
  113. COUNTIF using formatting
  114. looking for changes in worksheets or books
  115. How do I view multiple tabs on the worksheet
  116. cell size
  117. MATCH and #N/A
  118. countif function excel 2007
  119. How do I find the month
  120. COUNTIF or COUNTIF
  121. Worksheet Reference
  122. Vlookup - using a cell to reference a named array
  123. vlookup
  124. Conditional formatting across a row
  125. Display a part of a cell in green (or red)...
  126. Excel filter won't capture everything in the column - why?
  127. IF statements
  128. Lookup formula
  129. Conditional Formatting: Logical AND fails to work with INDIRECT(..
  130. remove blank cells - no sorting
  131. Lookup Function for Non-Alphabetical
  132. Formula for average of cells that have blanks
  133. SUM IF QUESTION PLEASE HELP
  134. Searching for an additional item via an IF statement
  135. Calling an application from excel
  136. Another nested formual help request
  137. re:code to close an excel sheet without saving it .(via msgbox)
  138. Countif - extended functionality
  139. #value!
  140. I have a problem using excel
  141. Data Validation vs VLOOKUP - Linking to data in a seperate file
  142. Sluggish Performance From Excel 2007?
  143. How to remove duplicated items from a list?
  144. Faster Way To Insert Defined Names??
  145. how to link different excel file
  146. Macro creation
  147. How do I create keystroke macros in excel 2003
  148. SUMPRODUCT Help!
  149. using the countif function
  150. End if without Block If
  151. Excel File exported from Quickbooks does'nt register numbers as nu
  152. ABC Inventory Classification
  153. Mutiple Spread Sheets
  154. SumProduct Function
  155. Combining Formula and Data Validation List in a Single Cell
  156. Searching for specific text - how to
  157. how to use cubic spline
  158. Referencing Workbook Name in Formula
  159. Compile error when accessing a spreadsheet
  160. Excel 2007 Error message when trying to record Macro
  161. How do I hide a column from others in a shared workbook?
  162. how to solve multivariable equations
  163. How to order several data from different rows in one row?
  164. Lookup problem
  165. Wild card match and then count
  166. COPYING FORMULAE
  167. Referenced Cell Values
  168. Help with HLOOKUP/INDEX/MATCH
  169. Multiple IF statement
  170. linking error
  171. vlookup,IF function together
  172. Ecxel in email
  173. worksheet formulas
  174. Multiple Field Selection for Pivot table Values Section
  175. Can Anyone Help Please!
  176. Macros and If
  177. Calculate Ending time using Start Time and Elapsed Time
  178. Grouping in pivot table
  179. Linking Rows?
  180. how to create a formula with expiry condition
  181. comparing two sheet of data -- cost price increases
  182. How do I activate Recently used files? Menu route wont do it!
  183. Data Validations
  184. How to show/print guidelines over color rows & columns?
  185. delete color cells
  186. Automatic Numbering
  187. Hyperlinks have appeared in all my forms, how do I remove them?
  188. Bar Graph
  189. Excel if Functions
  190. SUMPRODUCT help
  191. How to find formula for....
  192. Help on "IF" function
  193. excel sorting functions
  194. Protection - multiple ranges at different times
  195. LOOKUP Help Using non-First Column
  196. how do i change something from CSV to XML?
  197. Selecting "odd" and "even" numbers
  198. SumIf and ranges
  199. Counting
  200. Conditional statements
  201. Conditional formatting
  202. lookup functions
  203. Need a formula to update data in 2 columns
  204. Find most recent value in data range that includes SUM formulas
  205. Goodman-Kruskal Gamma
  206. I need to know how to leave the cell blank
  207. AND function
  208. Conditional Summing
  209. How to apply a function to an entire column
  210. Covert Number to date
  211. Can't get array formula to work in MATCH function
  212. NEED EQUATION PLEASE
  213. MIN DATE from Array
  214. Returning Yesterday
  215. adding a fixed decimal within another formula
  216. Mulitiple functions in one cell
  217. calculating differentials based on dates
  218. I'm Trying to Construct a Smart Worksheet
  219. If Satement formula
  220. Converting mm/dd/yyyy to yyyy/mm/dd
  221. Sum of unique values within a range with blank cells
  222. Reporting on Top and Bottom Sales Figures
  223. Count number of values until exceeding a figure
  224. how to print the rows more than 62000 rows
  225. Calculating a sum from a given number of rows
  226. formula for 2% annual sales increases
  227. HI DOES THIS EQUATION LOOK CORRECT PLEASE
  228. How do I format cells to show date in Australian not US format?
  229. Adding numbers to text!
  230. Help on how to use the PARETOINV function!
  231. Link from a drop down list
  232. Conditional formatting puzzler
  233. how i convert "100" to "hundred"( number to text) in excel-2007
  234. Auto insert e-mail addresses
  235. move cursor on limited cells.
  236. unhide row does not unhide the hidden rows
  237. Just type the word
  238. Merge multiple row data in one cell with delimieters
  239. Calender function - time sheet - excel 2003/7
  240. MAX value matching multiple criteria
  241. pay slips
  242. Find Smallest entry but excluding zero
  243. Sorting and filtering HELP!!!!!
  244. formulas
  245. Move text
  246. IF Function formula
  247. How do I ingnore non-numeric cells in Analysis toolpak?
  248. Excel - Formulae across several sheets
  249. Formula Funtions
  250. Muti-page workbook highlight specific dates that occur throughout
  251. multiple if statements
  252. custom views troubleshoot
  253. Function to calculate total hours worked in one week.
  254. when I type 1 it is displayed as 0.01
  255. Tabbing to select fields
  256. scroll lock
  257. How do i make one cell get just the row amount from another cell?
  258. formatting in different countries
  259. Need formula
  260. duplicate an array and filter the list based on a grouping
  261. checking for Match
  262. vlookup in the row below the target row
  263. Como criar uma formula que ao atingir uma data esta muda de cor
  264. VLOOKUP using 2 Cells
  265. day increasing by 1 when i drag and drop
  266. Format Name
  267. creating sub worksheets
  268. 3 variable lookup
  269. Danish Question HÆLDNING
  270. SUM if conditions are met over multiple worksheets
  271. Conditional Result based on Multiple Columns
  272. Using Sumif On Two Columns of Data - How?
  273. Vlookup formula - help please...(soth)
  274. vlookup and Sum unique values
  275. select multiple records in database given conditions
  276. What-If Analysis
  277. Row_Calculation
  278. Summing cells containing dates
  279. REMOVE THE #DIV/0! ERROR FROM FORMULA WHEN FIGURING MULTIPLE AVERA
  280. HELP!!
  281. Comparing sets of data, where criteria met, sum certain columns.
  282. Creating multiple workbooks
  283. Merged cells withing Protected Sheets
  284. date ranges
  285. Calculating specific increments of time across days
  286. email Button
  287. Multiple functions in one cell
  288. Use formula to populate cells
  289. Conditional formatting troubleshooting
  290. Excel question
  291. Pivot table field missing
  292. Deleting duplicates in Excel
  293. Pivot table filed defaults
  294. copy cell with macro and increment down each time
  295. COUNT FUNCTION?
  296. how to search a sheet using row and column headers
  297. non match result
  298. Format>Cells>Special>Zip Code
  299. auto transfer data in sheet2 (selected data)
  300. Excel 2002 VLOOKUP in another workbook returns #VALUE
  301. If function - Add if its blank, to return blank
  302. Repeating rows and columns
  303. naming a workbook the same as a cell entry
  304. count the number of values when two conditions are met
  305. SEQUENTIAL NUMBERING OF WORKBOOKS
  306. vlookup
  307. Returning a value from the same row using two variables
  308. Create a Macro with a List
  309. Re: result of formula posted in different cell
  310. SUMIF formula while filtering
  311. Cell Format - What's wrong?
  312. Alternative formula to the vlookup formula?
  313. Excel drag down formula not working good..
  314. Excel drag down formula not working good..
  315. Excel drag down formula not working good..
  316. copy field settings of a field to other fields in same pivot tbl
  317. Database function criteria
  318. excel
  319. Pivot Table Calculated Field using Grand Total
  320. Formula Errors / #Value!
  321. sumif returns #VALUE! when linked workbook is closed
  322. is there a solution to get the result in V?
  323. Can I pull in the filename used in Vlookup from another cell?
  324. Create a macro with a list
  325. I've created an Excel worksheet using the Vlookup command.
  326. VEhicle Maintenance
  327. SUM TOTALS AT BOTTOM OF WORKSHEET
  328. Functions in Excel
  329. how can i stop formulas from displaying like this =R[-49]C+R[-25]
  330. Excel data formatting
  331. How can I create a check box in an excel template
  332. VLOOKUP the right choice?
  333. Odd result when copying functions
  334. Looking Up the Answer by Row and Column
  335. Duplicate sheet, autonumber sheet, record data on another sheet
  336. Question on breaking on cell into three seperate
  337. Why Can't I navigate Excell 2003 Worksheets via Navigation Bar
  338. Function/Formula Question
  339. How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30 time
  340. what does this forumla mean?
  341. Number Format?
  342. How can I find out what date going to be 3 month from today in ex
  343. Summarizing updated external data
  344. How do I create a staff roster in Excel?
  345. GetPivotData Question
  346. Lookup in dependent tables.
  347. tab name
  348. Conditional Formatting
  349. filers in more than 1 cell
  350. Using roundup() but on a whole spreadsheet instead of since cells
  351. sheet name
  352. Exceel formulae
  353. Comparing 2 dates and times
  354. Menu options
  355. append worksheet with data from another
  356. Shading of Multiple Rows in a Pivot Table
  357. Email files
  358. Summing a Column - Net and Absolute Values
  359. pivot table help
  360. Is it possible?
  361. count unique in non-continuous list
  362. data validation
  363. Can anyone assist me with a new workbook template for Excel 2003?
  364. Find Earliest Date
  365. Logical Test
  366. Insert a drop down list into an excel cell, linked to Access
  367. Excel queries
  368. How to get the result with IF function
  369. Pivot tbl rpt-how to return text in a field vs. a sum/count value
  370. Lookup Issue
  371. pivot table filtering not working
  372. how to keep a running tally of boxes filled with info
  373. Need to copy
  374. Invisible Formatting ? or ... ?
  375. Multiple cell value
  376. Two-variable Data Table - Problem with result/output
  377. Making formula results not visible in a cell
  378. intercept and slope functions
  379. gathering multiple spreadsheets into one
  380. VALIDATION
  381. Cell insertion if values not matching
  382. IF Function with ISBLANK
  383. lookup/match mult values
  384. Formula problem
  385. Reference sheets
  386. new cell for each day
  387. problem summing columns with dates
  388. Formula problem
  389. If Question
  390. new cell each day
  391. Calculated Fields and Pivot Tables
  392. SUMIF Criteria
  393. Single Quote use in cell reference
  394. Sum If Help
  395. Formula Halp - If or Lookup
  396. conditional formatting
  397. To count how many are in a certain age group
  398. How do I move numbers with formulas behind to new workbook?
  399. Condiitonal formatting-colored cell
  400. Find next value
  401. some worksheet columns don't update formula calculations
  402. help with formula -
  403. text for numbers
  404. Accidental Currency Converted
  405. Duplicate entries in single column w/o sorting?
  406. vlookup on multiple values
  407. Aging reports
  408. Getting Count Formula Working if Column has both number and text
  409. If results for multiple cells
  410. Arbitrary Lookups - return ALL found values
  411. Goal Seek Goes Haywire
  412. SUMPRODUCT or another function???
  413. using multiple sheets from a workbook in a formula
  414. Percentages and whole numbers
  415. Need formula like ISBLANK that returns "no value" even if there is aformula in referenced cell
  416. Referen to cell on other sheet not working
  417. Advanced Criterea in Formulas
  418. can excel alert you when a number is less than a particular value
  419. Calulate a value when date is in a range.
  420. Calulate a value when date is in a range.
  421. Insert sheet linkage
  422. Function to insert current filename into worksheet?
  423. Conditonal Formatting
  424. How to set Auto-Change letters into Uppercases for Data entry in E
  425. Which function do I use?
  426. How to change color in cell when there is input
  427. I have 2 items that are selectable in 36 ways; How do I sort 1 & 2
  428. Copy & Pasting Drop Down Boxes
  429. How to average numbers greater than zero in a pivot table
  430. How to protect cell with formula from being entering info
  431. Alternative formula for getting totals
  432. Calculate totals for a range of names
  433. Show dates based on criteria
  434. Offset/match returns #value error
  435. HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE
  436. Need help with formula
  437. Excel 2007
  438. Add number before text that matches criteria
  439. Formatting cell to show current Quarter
  440. Look up duplicate amounts with unique batch numbers
  441. Using Sum If and an array?
  442. Count for multiple text criterias
  443. copy text out of a range of cells
  444. COUNTIF counting incorrectly
  445. Sum of Vlookup
  446. Create totals for close-matching names?
  447. drop down menus and corresponding hyperlinks
  448. cell extract
  449. Formula help
  450. Formula only works on some computers
  451. Formula To Keep Certain Cells Blank
  452. H or VLookup Help
  453. Minimum Ifs Function
  454. Fill colors and high contrast
  455. Counting Dates
  456. How to supress #N/A in an array formula.
  457. needing to calculate entries, but no the spaces in some cells
  458. average by date
  459. VLOOKUP, but different
  460. Vacation Planer
  461. Finding entries across columns
  462. Macro To Remove Subtotals from ALL Worksheets
  463. Function Equivalent need
  464. CountIF Help
  465. count months between years
  466. cant insert column get error message
  467. VLOOKUP returning a #VALUE! error and I've not idea why! HELP!!!
  468. Sum Pivot Table per Unit Records
  469. Sumif multiple criteria?
  470. Source for DropDown in another workbook
  471. Different Language Settings...
  472. Pivot table - display all labels (i.e: do not summarise) how to?
  473. Duplicating/Mirror Data into another worksheet within same workboo
  474. Move to next line
  475. SUMIF with text
  476. Meaning of $ in function or formula
  477. Percentage of the occurance of a word in a date range
  478. help with functions
  479. Sumif data from multiple columns
  480. Tracking cursor location
  481. Can you create a new array based on the value in a column?
  482. conditional formatting only applies to part of cell text
  483. how do I show the arrow for dropdown menu in excel?
  484. Count the number of values in a list that meet certain criteria
  485. can you anchor an image to a cell in excel?
  486. Formula search
  487. 2 Macros running on same module
  488. Want blank cell displayed if indirectly referenced value is zero
  489. Name Box
  490. How do I combine Exel workbooks?
  491. Force excel to read dates as D/M/YYYY
  492. Gridlines dissappeared behind formated cells. Get them back?
  493. Picking up the latest text value in a column
  494. add a cell reference to the start of a formula
  495. Vlookup
  496. IF Statement not working
  497. Extract Text
  498. Help with IF function
  499. Formatting and adding cells formatted to 2 decimal places
  500. Find matching data in two workbooks
  501. Filter by Top 10 doesn't work
  502. Cal Bal Hr & Min
  503. compare two lists
  504. Sumproduct #Value! Problem
  505. Upgrade from 2002 to 2007
  506. How to set macro to Paste Special Value to next empty column
  507. How do I format cell to 0.25 resolution?
  508. countif two columns two criteria
  509. Validation_List_Formula (not sure how to title this post)
  510. Project days allocation (better mail format)
  511. Project days allocation
  512. compare 2 spreadsheets
  513. What is the formula to calculate electricity consumption
  514. vlookup i think?
  515. Set value to zero when result is 0 otherwise show actual value
  516. Excel cannot complete this task with available resources.
  517. How to set the value to zero if it negative after the substract
  518. how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0
  519. DATE function
  520. Annual Wages Sheet to pick up info from Time Sheet
  521. IF statement help
  522. "Labels as Names" stopped working
  523. If statement working only once
  524. Finding & Replacing a list of Data in Multiple Columns
  525. Trig Function seems odd.
  526. i just want to allocate $ by month, for many projects
  527. fill data automatically into another worksheet
  528. work only with value without updating
  529. Calculating STDEV and other Calcs based on another cells value
  530. Formula help
  531. Standardizing Street Addresses in a Large Address Database
  532. conditional statistics
  533. Value look up
  534. username
  535. Concatenation
  536. Adding Values
  537. Lookup order
  538. Certain Cells Appearing
  539. Vlookup or match function?
  540. Search Formula to collate BOM Data
  541. I can't autofill cells in a column if blank cells in between
  542. Lookup text in 1 column and make notations in another
  543. strange happenings with move/copy worksheet
  544. Freeze Column
  545. Lookup text in 1 column and note it in another
  546. string manipulation, pulling out last name from column
  547. Blinking text
  548. Comparing Data
  549. How do I past data into the Find and Replace box Excel 2003?
  550. how to align text to 45 angle without angale boarders
  551. a few condition
  552. Copying formula to sum multiple columns
  553. basic opertors
  554. Two subjects: Column sort and True/False in cell
  555. Guidance/Help to Highlight Cell contentts Based on Min/Max
  556. I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable
  557. Need Help: Multiple Criteria
  558. lock cells
  559. check if an entry is a multiple of another cell
  560. Copy from another sheet
  561. "Identify Label" bug when using INDEX/MATCH and VLOOKUP formulas
  562. extract data from one worksheet to another worksheet
  563. math formulaes arent working in excel
  564. Excel Typing
  565. QP formulas not working in Excel
  566. count text entries
  567. Find the lowest value in a row
  568. date computing and sum issues
  569. Average # in total group with multiple criteria?
  570. Need VBA script to auto-insert value upon row insert
  571. Inserting blank rows for missing data in order to transpose
  572. Return Time for Duplicate Files & Times
  573. conditional format, day of month
  574. Look-up and Merge
  575. Pdf hyperlink not opening in excel worksheet - nothing appears.
  576. how do I add portion of days for scheduling
  577. 3 months prior and 3 months post a date
  578. Sum a different number of items
  579. Formula within a formula
  580. transpoe with formulas
  581. formula to compose a list of values
  582. LOOKUP
  583. Comparing info on 2 spreadsheets
  584. Maximum characters in cell
  585. Help with credit Limit Summary
  586. Edit Replace the third digit only of a number
  587. freeze frames button inactive
  588. MONTH
  589. Insert rows based on value per day
  590. Condition format a row based on a formula
  591. Condition format a row based on a formula
  592. Concatenate numbers
  593. nested functions using insert function
  594. Using List details within a sum
  595. if condition doubt
  596. how to add new items to a list
  597. macros over different sheets
  598. Change value of cell automatically if entered the wrong number
  599. Help to pick string value if match happens
  600. How to determine the values?
  601. Why has my mouse pointer response slowed to a crawl speed ?
  602. pulling data in rows!
  603. Calculate interest between two date ranges
  604. Sum results from 2 columns that meet criteria
  605. Average highest 16 numbers on a column of 32 numbers
  606. OLAP Pivot Table returns #N/A for custom calc.
  607. Is It False ??
  608. Move data from one worksheet to another.
  609. Multiple formats in a single cell with multiple formulas
  610. convert length of time to minutes from hundreths
  611. Please Help with complicated SUM formula
  612. Formula Problem
  613. Find the number of the lowest filled row
  614. How do I restore the ability to see shading on screen?
  615. What is the difference between relative and absolute cell referenc
  616. Productivity
  617. beginners help...
  618. Links to password protected workbooks
  619. Countif with multiple criteria
  620. finding last number in row excluding 0's
  621. Vlookup with the result being once cell below the orginal value
  622. how to auto calculate difference between cells like c1=a1-b1
  623. Insert a cell as part of a if/then function in Excel?
  624. Indirect function
  625. 3D reference question in inventory Worksheet
  626. how do I add another item to an existing drop down.
  627. Change Boolean / Logical Operator using Input Cell
  628. Adding days to a date cell to get a new date
  629. If function with Another Function
  630. Chart with two series, one high, one low
  631. Help Wanted
  632. formula (a1*a2) filling down becomes (a2*a3) i want (a1*a3) Help!
  633. Data Grand Total in Pivot Table Row Area
  634. Adjusting numbers to nearest preferred number
  635. lige uger i excelformel
  636. Checking values in 2 columns
  637. Sumif 2 criteria - 1 in a Row and 1 in a Column
  638. Formula for cell to get information from other worksheets
  639. Total Dollar Amounts From Different Worksheet
  640. Date Function to include a day and automatically updated each new
  641. Adding Data from Date Range base on relative dates
  642. Sum based upon matching data in different columns
  643. How can I use a UDF in a SUM Function?
  644. Linking two worksheets
  645. How do I create a formula in excel to multiply two items from two
  646. Match() worksheet function
  647. Printing a page from a cell
  648. Excel into executable
  649. Formating cells
  650. Drop Down List - Select Multiple Items
  651. excel formula
  652. SUMPRODUCT excluding multiple conditions
  653. Formula needed for repetative spreadsheet
  654. Excel 7.0 - removing duplicates
  655. format function
  656. showing numbers as percentages
  657. Need help!
  658. Macro options in Excell 2003
  659. Unable to change tab color
  660. renumber automatically
  661. Formula function not opening
  662. Please help with SUM formula dependent on results of other cells
  663. calculation problem
  664. how to sum when two conditions are met, e.g. name and task number
  665. Why this SUMPRODUCT statements returns zero?
  666. how to update certain text in a cell according to thecell colour
  667. Modify dates byr referencing a cell name
  668. Function to uniformerly format different phone numbers
  669. Address List
  670. count of 'err'
  671. Hellllllp Can,t remember pasword
  672. COUNTING "ERR" IN COLUMN
  673. exact percentage of each cell
  674. COUNT IF Help with multiple conditions
  675. Unprotecting an Excel Spreadsheet
  676. Removing Hyperlink
  677. Pivot Table
  678. how to find common data from two columns of figures
  679. extracting data from a cell
  680. Copy cell value into blank cells below (full worksheet)
  681. Extracting data for address lists
  682. Weekending Saturday
  683. Complicated working days function
  684. Complicated working days calculation
  685. How to set minus value to 0
  686. Stopping Auto calculation in Part of a Worksheet
  687. Dates In Excel
  688. IF function to test whether the cell value is equal to empty nest
  689. Sum Problem requiring help
  690. Help for Appropriate Formula
  691. Populate Cell with another cell, but only if the date equals today
  692. creating a list from a few worksheets not including blanks
  693. HOW DO I PRINT CONFIDENTIAL IN THE WORKSHEET
  694. what formula for summing if two logical statements are true?
  695. conditional formula: time to expiration date becomes < 6 months
  696. chart conversion
  697. Data Validation Drop Down List Question.
  698. IF/Nesting When Calculation Involves a Date
  699. Convert ADDRESS() text result to cell reference
  700. autosum refusal to sum highlighted range
  701. format
  702. Data validation list from table
  703. Running balance from previous sheet
  704. Formula
  705. Averaging miles per gallon
  706. Excel Help
  707. translating countifs function to Excel 2003
  708. How to extract just text from cells
  709. H E L P -Excel
  710. Disecting Contents
  711. Return column heading
  712. Excel template populating from a worksheet
  713. How do I email one sheet from within an excell work book file
  714. Spreadsheet not working with filters.
  715. I want to create a function or formula
  716. How can I remove a constant from a cell?
  717. Taking formula to text
  718. Data Validation of user input
  719. conditional formatting - repeat formula
  720. Excel maximum Row number
  721. PDF e-mail
  722. Number of vehicles
  723. subtract
  724. COUNTIF with multiple criteria doesn't work
  725. conditional colour fill a row - based on cell value =100%
  726. dynamically sorted list with duplicates
  727. How do I keep from selecting multiple cells
  728. Outline using style
  729. Find and copy data
  730. Calculations with date fields
  731. Do All Cells in a Row Match?
  732. Run a macro when clicking a cell.
  733. Hey Excelbanters!!
  734. using sumifs to sum based on month, and criteria
  735. cell references-Please Help! Please Help!
  736. moving data from vertical to horizontal possition
  737. Excel formula calculating age
  738. How do I refer to the results of a function in a cell not the form
  739. Anyway to put logic into a single countif, sumif etc?
  740. COUNTIF(RANGE,"?") and search for contains
  741. Find "Look in" box does not show 'values' on 'formulas'
  742. Create macro to calculate data range for a running chart
  743. modifying countifs
  744. Max and Min in a Range
  745. sum cells based on contents of adjacent cell (validated list)?
  746. Return on a bond
  747. contents embed
  748. More effective than DAYS360?
  749. calculating populated fields from multiple workbooks
  750. How toFind the Time difference in hours
  751. Getting the formula from a cell
  752. Month based data addition to worksheet
  753. How to add "-" into 10 digit numbers
  754. Back to basics of excel 2003
  755. VLookup returning the sum of multiple values from one "code"
  756. Need help with spreadsheet.
  757. Coverting the cells into general
  758. Sum unique values based on criteria
  759. contents embed
  760. I Need Help with COUNTA and/or SUMPRODUCT
  761. Data into a data sheet from a list
  762. freezing rows and columns
  763. Macro Help
  764. Sum if
  765. calculations not working
  766. macro code required
  767. need excel formula for equation h=-16t^2+v*x+h_0, please?
  768. Sorting by date and ASAP
  769. If > #, then Highlight
  770. DAVERAGE, DMIN,etc from List
  771. REminder In Mail Box
  772. Appreciate
  773. Adding hours in Excel
  774. Conversion
  775. Alternating sort question
  776. calculation problem
  777. excel count problem
  778. Which function to use?
  779. LOTUS 123 files to load in EXCEL
  780. How do I make a cell refrence another cell based on conditions?
  781. help in formula
  782. creating a list of information from another sheet
  783. Conditional Formatting
  784. Excel Function
  785. Can you link a graphic in a formual to appear in another cell?
  786. custom footers for each page in workbook
  787. number format
  788. data filtering via vlookup or index/match/find or search withwildcard
  789. can lookup return cell reference istead of "text" for sumif?
  790. Return on a bond
  791. Excel changes decimal
  792. help with macro to export data
  793. Removing Blanks
  794. Changing the Color of Specific Characters using a Macro
  795. Using a drop down list
  796. My formulas in excel are suddenly not working. Help!
  797. link 1 sheet to another(totals)
  798. logical function bug?
  799. How do I recover the formula Bar?
  800. Creating external references to spreadsheets with changing names
  801. Number Assignment
  802. WHY DOES MY WORKSHEET MOVE WHEN I USE THE ARROW KEYS?
  803. Adding random #s in a range to equal a specific #
  804. Formula to increase value according to total
  805. Help needed with a formula, please.
  806. Protecting and Auto fill Columns
  807. COUNT occurances if criteria is met
  808. Match Multiple Columns
  809. Obtain rate for work center, depending on year
  810. Unwanted Jump to Linked Workbook
  811. Compare Columns
  812. How do I hide the Check Box number?
  813. Count occurances
  814. variable worksheet with movable cell
  815. Absolute Reference is changing
  816. Alphanumeric limitation
  817. Excel Manual Calculation
  818. Formatting a lookup
  819. Macros for invoice
  820. macro pop-up to set range?
  821. How to merge info
  822. Formula that displays the documents modified date
  823. Convert street address to zip code
  824. Find Unique Changes
  825. help!! 1000 appears as 10 in excel
  826. if statement or other methds to find similar data
  827. Macro Stop
  828. MATCH from right to left
  829. vlookup
  830. Conditional Format IF AND
  831. IF Statement?
  832. Cell reference based on variable text string
  833. Conditional Drop-down lists
  834. Can the Excel RTD function return an array (It does on Bloomberg)
  835. Data Convert Text To Number
  836. How do I sum up random cells
  837. how do I convert numeric value to its character value ex. 10=Ten
  838. Named Range REPOST
  839. Need help transferring information between work sheets!
  840. Concatenate or not?
  841. IF & AND Function
  842. MIN and IF functions return no value if there is no date
  843. Hey Scottie, re named range.
  844. Named Range
  845. V-Lookup issues
  846. Countif by match two columns
  847. Using COUNTIF forumla
  848. formula number to words
  849. help with an if statement
  850. Cell reference with variable column
  851. VBA userform
  852. Trying to use data from another worksheet
  853. Formating Cells
  854. Counting X's in a single column
  855. Formula help for Excel 97
  856. is it possible to email just one worksheet from an excel document
  857. Is there formula similar to SUMIF that will work for average?
  858. Nesting
  859. Combo Boxes Calculations
  860. I know this is simple but ans= and nothing happens
  861. Rounding up or down to specific decimal digits.
  862. moving cursor through the cells
  863. Dependant cell tracking
  864. Text to a number
  865. clicking all the way to another cell
  866. Count to end of Range
  867. worksheet name variable external data cell
  868. IF formula misbehaving with determining year of an event
  869. How to get Excel to correctly display imported UTF8-encoded data ?
  870. Condtional Formatting
  871. Function
  872. how can i set up multiple conditional formulas in excel?
  873. Can't find pictures in a referenced formula
  874. hyperlinks
  875. Split / Freeze Pane's
  876. Spreadsheet Function
  877. Notification
  878. I have my IF formula, how can i change the text colour for eachif??!! help please!!
  879. Need help with function using INDEX and MATCH.
  880. Cell address without absolute reference
  881. Problems with a formula
  882. blinking function
  883. if function to delete row
  884. INDIRECT, relative name as argument
  885. Protect individual cell and hide formula in formula bar
  886. Entering only 2 values out of 3 - throws up message as false
  887. Entering value in a cell
  888. How to select all comments in spreadsheet at once, to re-size all
  889. Text to columns
  890. Urgent
  891. VLOOKUP
  892. Pivot tables..how to change multiple information in rows ...
  893. is it posible to apply multiple and or functions in a singl cell?
  894. Linked worksheets
  895. vlookup
  896. Calculating the difference between two dates if two criteria are m
  897. Conditional Formatting Based on Cell Content
  898. COUNTIF function within SUMIF
  899. I have a multi what if:
  900. Cell Values
  901. Pivot Tables Auto Format Change
  902. Sumproduct on Dates?
  903. changing formulas
  904. Sum the difference between dates given a certain criteria
  905. Microsoft Office 2007 - Excel
  906. Subtotal with additional criteria
  907. Paste Special from Excel to PDF converted to Word Docs
  908. Can I set a cell value to a filter selection in Excel?
  909. Dependent Dropdown List - Large Scale
  910. Replace Part of a Function
  911. sigma function
  912. Use of cosinus for calculation of a triangle
  913. how do i remove page breaks in excel?
  914. Formulas
  915. vlookup - HELP
  916. how to create a macro button to exit a program
  917. How do I apply icon sets to percentage values in Excel worksheet?
  918. Disable Pasting into a Workbook
  919. update text from ons sheet to another.
  920. Help with INDEX and MATCH statements.
  921. Help with INDEX and MATCH
  922. Help with IF statement
  923. automating a control box in excel
  924. Help with this formula.
  925. Exel 2003
  926. Detect Duplicates
  927. Using Vlookup or other function can assist?
  928. Help with formula
  929. Concatenate several rows
  930. update a sheet automatically with changing values from another she
  931. Ex2003
  932. Can/Should this work?
  933. Please help Newbie
  934. =amtinwords()
  935. Convert figure to words
  936. If, Count & Array
  937. sum a subtotal
  938. IF & VLOOKUP Together
  939. Amending 1 work sheet saving in all
  940. SumIf Function
  941. Autofilter using cell reference
  942. Predict/Probability
  943. Need conditional data from 1 sheet to populate another sheet
  944. adjustable interest rate with caps
  945. compiling data from multiple Excel sheets - macro?
  946. cell reference in a formula using 2 worksheets
  947. Reference an Operator from a cell with Sumproduct
  948. Lookup or reference 3 data points
  949. Wildcard for dsum formula
  950. How do I sum cashflows in date range.
  951. How do I sum cashflows within date range given dates and cash flow
  952. Excel 2003/2007 paste special values shows bizarre results
  953. Imbedded Objects with filters on
  954. weighted averages in a pivot table - how?
  955. Filtering for more than 2+ "does contain" criteria
  956. Functions, Arrays and number/text stored as text
  957. eliminating duplicate lines
  958. Random selections
  959. sum total of hours minutes seconds in excel 2003
  960. Product by Month formula
  961. Excel file not opening when saved with Extention .html
  962. sum hours minutes seconds excel 2003
  963. change Data from column b into row based on value in column a
  964. Using named ranges in a formula
  965. Replace one number in a sequence in a group of cells
  966. IF statement with 2 array formulae
  967. MS EXcel Help
  968. EXEL 2003
  969. Formula to group into Age Ranges
  970. Formula to group into Age Ranges
  971. how can I insert lines with the help of formulas
  972. if condition
  973. excel error033160_01
  974. excel error033160_01
  975. if any cell value changes, then display in some other area that va
  976. neat trick - excel art - very nice with out functions
  977. macro; reorganize blocks of data
  978. open text file in excel
  979. Macro for Large workbook
  980. Having cells default to 0
  981. Help! I can not remember the password to an important Excel workb
  982. VLOOKUP using Fifth Column
  983. Save file as semi-colon delimited?
  984. Re: VLOOKUP using Fifth Column
  985. RE: VLOOKUP using Fifth Column
  986. Special Consultation
  987. How do I add a portion of a day to a date?
  988. How do you merge a dollar amount into a word doc and keep the $?
  989. Subtracting time
  990. Embedded OR, AND statements in an IF structure
  991. Help with a conditional formula using ranges
  992. Macro to move one cell down
  993. GETPIVOTDATA function only returns zero's
  994. Unique count formula
  995. text on worksheet with no gridlines
  996. Warning upon closing sheet
  997. count if column A is 1-2 and column B is 03/02/08 to 03/09/08
  998. Running Total per group of items
  999. Compiled data from many files
  1000. Overtime Calculation for Overtime