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. CAN'T SAVE A FILE!!!
  2. Exchanging information
  3. Excel unblock
  4. FINDING AN EXACT MATCH ON 2 DIFFERENT SHEETS THEN EXECUTING A FORM
  5. Database Functions
  6. how do I create a cell reference from ADDRESS function return?
  7. Sumproduct with multiple criteria using indirect formula
  8. add up sums in column m if column c = scott
  9. Sumproduct
  10. Criteria For SU<IF
  11. Non working time
  12. data update
  13. FOrmula Copy and Paste
  14. Adding values across a row based on a corresponding column value
  15. Buffer Overflow in Excel
  16. Help needed adding third If
  17. INDEX & MATCH find first column value in an array?
  18. Need Help Converting Hypertext GIFs
  19. Need help with a forcasting type problem
  20. Last non-blank row
  21. Pivot table help.
  22. SUM Formula
  23. IF FUNCTION QUESTION IN EXCEL 2003
  24. Return matched value 2 criteria
  25. Fact()
  26. Cash Flows Inflation Adjusted
  27. Vlookup referencing more than one worksheet
  28. Help on Pivot Table
  29. Formula to sum for different date ranges
  30. Duplicate cell information from one worksheet to another:
  31. using datedif formula
  32. Adding colums
  33. How do I vlookup
  34. Sumproduct
  35. adding a search box to a spreadsheet
  36. Embedding vlookup
  37. Page numbers on ea WS for entire workbooj
  38. EXCEL - Meet 2 criteria, then find next case of third criteria
  39. Countif function
  40. creating a form in 2007 that picks from a four column table
  41. using text from cell in lookup formula
  42. Percentage Variation - when values are zero
  43. Range Names That Move With Cell Data
  44. How to do it in Macro - 30 Nov?
  45. Lookup 3 matching values of which one is a range and return a sum
  46. Automatic Adding Daily
  47. linking a value from another page or tab in a formula
  48. Count...Sum...Faster...improvemens...; Have a good end of YEAR
  49. conditional formula based on dates
  50. IF function problems
  51. How To INCREMENT days of the week? like mon,tues,wed,etc??
  52. ROUND() to tens or hundreds (not tenth/hundredths)!
  53. Question related to "Can you help me to solve the below
  54. Cell manipulation with imaging
  55. Cell manipulation with imaging
  56. Can you help me to solve the below equation in excel ?
  57. How do I change Automatic sum setting from 17.5% to 15%
  58. remove numbers
  59. Help on IF formula
  60. Validation lists
  61. adding dropdowm boxes to fit an order
  62. hide cells
  63. Send Free SMS Worlwide to any mobile phone iphone gsm http://free4sms.info
  64. Rounding the result of two times
  65. Transpose Funtion
  66. Error message when opeing and closing excel
  67. Excel Lookup function
  68. Duplicate value causes VLOOKUP issue...
  69. Checking a cell conditional format
  70. Pasting formatting from one worksheet to another
  71. XL2000 - Linking SUMIF with Other Workbook
  72. Complex If/And Statement
  73. extract date from text
  74. alpha numeric data validation for excel
  75. COUNTIF___Visable only
  76. help creating a button
  77. Value function not working as expected in Excel 2007
  78. I am typing dates in a spreadsheet but they are showing as hatch
  79. Making an agenda (template) in Excel
  80. Send Form Results to Excel WorkSheet
  81. Using two Vlookup in one Cell
  82. Make a Yes/no cell using a single click
  83. detect when columns being written to a worksheet “cross” a vertical page break
  84. same result comes in every cell.
  85. how do i convert a text of 15h05m to number of days
  86. Pivot
  87. How do I assign a numeric value to a letter
  88. Drop down lists
  89. how to find time clashes using excel
  90. How to pop up correspoding values by clicking on drop down menu?
  91. HOW TO DO FUNCTION
  92. Autosum will not update when I add new data.
  93. Quick Scroll ?
  94. Saving in xls format
  95. One for somebody
  96. Countif on Range
  97. Which formula(s) do I need?
  98. Saving File Format
  99. Conditional Format Using A Time Figure As The Trigger
  100. How to count in month?
  101. Is there a way that I can password protect a worksheet
  102. Fill down option in conditional formatting?
  103. Trace Precedents shortcut - NORWEGIAN keyboard!
  104. Complex lookup array with 4 variables
  105. Re-calulating totals based on "days old"
  106. sheet protection in excel 2003 version
  107. Automatically fill cells when selecting from a drop down list
  108. net no of hours bewtween tow dates
  109. IF + respective Validation Dropdown List
  110. count matched cells
  111. place an "x" in D2 if E2-I2 are empty of text??
  112. Tab order
  113. Formula calculating to the 3rd decimal
  114. Populating adjacent cells
  115. moving data to multiple tabs
  116. Find a cell address from a GETPIVOTDATA() Fomula
  117. weighted average from table
  118. Average Formula for the smallest x of xx values
  119. Identify if Text is in that row and return True or False
  120. How can you convert Excel pages into worksheets?
  121. Searching for multiple numbers
  122. Questions???
  123. vlookup and lookup
  124. Multiple Formats per Cell
  125. Shift in Period of Performance
  126. How do I sum different sized ranges?
  127. zero in cell is counting as one...
  128. Reset Button
  129. PMT function question
  130. Why can I not link my workbooks in excel
  131. Way to repeat row item name on pivot table-no "indent" of repeats
  132. workbook references
  133. Question re conditional responses
  134. Calculation Formula
  135. How do I solve a vlookup when multiple records are available?
  136. sum column 3 if columns 1 and 2 meet criteria
  137. Cell Formatting by function
  138. Modify Formula
  139. How can I display a loss or gain (currency)
  140. Pivot table limitations
  141. What's the formula?
  142. sumif
  143. Concatenate text cell and formula cell result
  144. Type only .25 or .5
  145. Reset Button
  146. Pivot Table Options - Default Display Settings
  147. sumproduct while number of added fields is changing?
  148. EXCEL FORMULA , MEET 2 CRITERIA THEN SUM
  149. Summing a column based on the length of text in a cell in anothercolumn
  150. Find & replace
  151. Using the RANK function question.
  152. Excel - Geomean - Ignoring Empty Cells
  153. Counting a Region
  154. how do i drag a formula
  155. Format individual coloumn cell with corresponding coloum cell resu
  156. Trying to sum cells across different worksheets in different locat
  157. Conditional formatting
  158. Convert inches & display as Feet Inches and Fractions -- BUG FREE
  159. Sumproduct help with a difference
  160. Vlookup
  161. add & subtract time in 1 formula
  162. Automatic Highlighting of Cells
  163. INDEX w. MATCH function
  164. Converting time to decimal format
  165. Conditional Rank Troubleshooting
  166. Pivot Tables
  167. Hello Experts, I need ur help with this Vlookup Formula
  168. Please Help ~ Lookup from Multiple Pages/Tabs Huge Woorkbook..
  169. Merging worksheets within the same workbook
  170. INDEX and MATCH functions
  171. The sum of data based on words
  172. If statements
  173. Sorting on only certain characters in a cell
  174. COUNTIF or SUMPRODUCT with Mulitple Criteria
  175. COUNTIF or SUMPRODUCT with multiple criteria
  176. How to use a cell value as the ref argument in CELL"contents" form
  177. INDEX & MATCH
  178. How to create a excell document that can be filled out by other pe
  179. Date = first day of next month
  180. Multiple Tables into one
  181. Change caption of a button
  182. Data Validation & Conditional Formatting
  183. Super easy question
  184. Update all tabs, incrementing one week per tab
  185. Why is ext .xlnm inserted in formula every time I close a doc
  186. Macro to shift to next row
  187. show the date when it is later than today's date
  188. Subtoal excluding hidden columns
  189. Argument help - amounts in different rows divided by a constant
  190. Calculate autocorrelation for incomplete list of data
  191. Help with Indirect
  192. cell calculation
  193. Excel Vlookup of multiple values
  194. Sums between dates
  195. lookup and concatenate
  196. Sum referencing Conditionally Formatted Cells
  197. my workbooks will not pastelink can anybody help?
  198. IF(ISBLANK) returning #VALUE
  199. How to calculate a discount between two values?
  200. sumif
  201. Lookup multiple items
  202. Count Whole / Integer Only?
  203. Drop down lists on multiple worksheets
  204. Need help with Run Rate spreadsheet
  205. Minimum Date Greater than Today()
  206. concanate formula
  207. Subtotalling after multiple criteria has been met
  208. Excel Formula Help
  209. macro for copy-pasting from different workbooks
  210. Compound Criteria for CountIf
  211. How do you count colored cells?
  212. VBA code for search button
  213. HLOOKUP PROBLEM
  214. Cell Fill Color change for MAX value
  215. nested multiple if
  216. Office 2007 How do I change the direction of the enter key betwee.
  217. Trying to improve efficiency of array formula
  218. Mover Cell to another place in worksheet
  219. Convert Text to numeric Value
  220. Criteria Range result plus x amt of cells
  221. how do I use COUNTIF stmnt if I want to find cells that are red
  222. Removing Single Spaces
  223. Formula issue with the "OR" command
  224. Problem with IF function
  225. How to create a function
  226. COUNTIF? DCOUNT?
  227. Array Doesn't work in Excel 2003
  228. Excel formula
  229. Format - Please Help!!
  230. Object or with block not set
  231. Is there anyway
  232. SUMIF? week, month & year-to-date totals
  233. Is there anyway
  234. For Shane Devenshire
  235. Using IF function and validation/list
  236. XL2000 - Sumproduct Question
  237. Elseif?
  238. Is there any way I can do this
  239. CONCATENATE
  240. How do I count the number of cells that meet multiple criteria?
  241. SumProduct by cell color
  242. Possible Lookup
  243. Losing formula references to other sheets - HELP!
  244. formula problem
  245. Subtotal ignoring Error Values
  246. How do I delete unique numbers from a list and save duplicates?
  247. VLookup with wildcard
  248. Macro Security
  249. Formula combination
  250. Cell to the left of an Index function result
  251. VLOOKUP
  252. Minimum array formula.
  253. Lookup formula for both row and column
  254. Count, ignoring duplicates
  255. if/lookup/index/match?
  256. Sum Begin/End selectivity
  257. Excel should spell-check all the cells together.
  258. How should I do this (function or Visual basic)
  259. formula using dates as condition
  260. Find min sum from multiple categories and functions
  261. look up formula
  262. Returning the most duplicated item
  263. Conditional formating.
  264. Transfer cell values to another cell by selecting button.
  265. Multiply/Sum cells containing formulas
  266. Using Min Formula with Multiple Criteria Excluding Zeros
  267. Two functions in one formula.
  268. recipe conversion
  269. Limitations when Combining OFFSET and MATCH to return a cell refer
  270. Cell format as condition
  271. Insert select button on excel worksheet to auto transfer data.
  272. Finding MIN across worksheets while excluding blanks
  273. Formula (array?) to compute weighted average balance
  274. Need help in VLOOKUP function
  275. how can i sort on a perticular column for odd and even numbers
  276. Text Counting
  277. How do I put a variable column number in the sum() function?
  278. vlookup from a list
  279. Automatic sorting (giving max and min) based on custom sorting lis
  280. print spreadsheet
  281. How to match or look up more than two same data
  282. Can I customize a right click to find data?
  283. Resetting Keyboard Shortcuts
  284. how to do this in int x + int (frac x*100)/60 + frac (frac x*100)/
  285. how to do this in int x + int (frac x*100)/60 + frac (frac x*100)/
  286. Avoiding negative values in IF statements help needed
  287. multiple function is it even possible
  288. Alternative of Vlookup function which improves speed
  289. Desperately need help
  290. Passed Arguments to a UDF
  291. Array Formula for a Finite Series Sum ??
  292. Is there a way to chenge the default font in the Comments?
  293. Nesting SUMIF within SUMPRODUCT
  294. change cell contents when pull down menu choices change
  295. How to report a BUG?
  296. conditional sum
  297. Excell 2007 / 2003 Compatability Issue
  298. how to pull data from a specific cell on each tab as I add tabs
  299. Pivot table SUMS
  300. Formula help on HLookup / VLookup ??
  301. Chart
  302. Unprotecting a work sheet with out knowledge of pass word.
  303. Christmas Lights Los Angeles 310-925-1720
  304. create a data list by using a form
  305. How do I get year to date account of an expense listed in a colum
  306. Auto Date & Time
  307. Using offset in sumproduct, is it possible?
  308. How do I calculate a payment?
  309. Combo box for 97
  310. UPPER
  311. Automation of info
  312. dividing by 0 error
  313. How do I count a range of cells from another columns criteria
  314. Counting number of unknown numbers
  315. BIG numbers
  316. Strange behavior when calculate two or more cells
  317. sumproduct function
  318. SUMIF
  319. VLOOKUP - Hyperlinks Vanish
  320. Countifs
  321. Add data in a column
  322. quintiles
  323. Required data in one sheet
  324. How do I change the color of the MS 2007 worksheet tabs?
  325. Out Put in another Cell
  326. Floating cells
  327. AutoRecover Feature
  328. How do i apply Goal Seek to a range of cells in Excel
  329. IF OR AND
  330. Excel Challenge: Copy and pasting sheet1 to sheet2
  331. which financial function should I use?
  332. Vlookup increment No
  333. Copy Paste
  334. average of 5
  335. how do I get rid of that "security warning" at top of Exel sheet
  336. SUMIF Sum a column subject to variables in two columns
  337. Nested Ifs in 2007
  338. Sending a single worksheet as an attachment
  339. Tranpose data from columns to rows
  340. Custom Number
  341. Count if in a Range
  342. Summing data on duplicate records?
  343. condense List
  344. COUNTIFS alternative for older excel versions
  345. Spreadsheet Security
  346. how to use vlookup for tax tables state and fed
  347. altering text to other column
  348. Payback in Years
  349. Histogram in reverse order
  350. how to convert number to bearing .exp. 40.4040 to 40d 40' 40"
  351. match, Index, If
  352. How can I find a value from one cell in a char string in another?
  353. Referencing a cell where lookup value is not on same row
  354. how copy formula that contains ranges so ranges do not overlap
  355. Copying tab loses formatting
  356. Rounding Question
  357. FORMULA
  358. How to write a macro that will clear validated cells to blank?
  359. formula
  360. Vlookup
  361. How do you turn on the voice read back of excel cells in spreadshe
  362. Comparing Row by Row - A-D dollar amounts to E dollar amount
  363. Custom Filter Pop-up Box
  364. SUMIF
  365. Count the letters in the cells and sum in another cell
  366. Is this possible
  367. Number conversion to text in Ms excel
  368. Countifs -Count no of times products have been sold on particular
  369. Lookup / find value in column which changes
  370. Look-Up Function
  371. conditional format error Excel 2007
  372. Edit links - in Vlookup
  373. Horizontal Scroll Bar
  374. Questions about RAND() function
  375. Pull Data from one sheet to another
  376. Add A Line In A Text Cell
  377. I've borrowed this formula for finding duplicates
  378. Vlookup calculation
  379. excel Formula
  380. sumproduct with varying column ranges
  381. sort
  382. drop down box
  383. Wrong sum value after calculate with Percentage
  384. Highlighted cell color
  385. Access db and Excel 2007
  386. Calculating Amount to be Paid
  387. VLookup Formula help
  388. If then formulas
  389. Help with Look up questions
  390. Cell Content Lookup Function
  391. Summary using sumif
  392. Vlookup help with function
  393. Formula creation
  394. Conditional Rank
  395. ISNA Function
  396. Excel Formula
  397. Vlookup w/ AND function
  398. Trouble with function for multiple data
  399. Write a number in a cell and another number comes out in another c
  400. Formulas to Values
  401. External workbook links don't update when source file changes
  402. Insert hyperlink stopped working
  403. How to decode integer timestamps?
  404. Cell Contains Word
  405. Links to FTP
  406. Year into months
  407. Tracking Changes in Shared Worked Book
  408. Apply various percentage with sales between a & b, b & c, etc.
  409. Lookup depending upon 2 criteria
  410. Conditional Result based on Anniversary Date
  411. Sumifs - incorrect when using date in critera
  412. Vlookup Copy Formula
  413. Excel: How do you format numbers in a concatenate string?
  414. How to paste photo into merged cell
  415. Globally deleting part of the information in a cell
  416. formulas
  417. help with a vlookup and index
  418. Sumproduct Formula to counts multiple criteria in two columns?
  419. Create a procedure or function
  420. How do I connect 2 worksheets with a formula?
  421. Need a function
  422. Clipboard Toolbar Missing
  423. Number of items in a set
  424. Auto sum only adding the last few numbers in the column.
  425. Same =rand() value in two adjacent cells in column
  426. Pivot tables - how do I change default from "count of" to "sum of"
  427. Generate a special numerical sequence in Excel 97
  428. vlookup repl #/NA with 0
  429. excel formula for a reference between two numbers
  430. Count Names NOT #N/A
  431. Delete duplicates: Sum & Consolidate
  432. Protect cells with data on save/close
  433. Protect Cells After Input - help with macro
  434. Pivot Table Average Question
  435. complex vlookup function - possible? help!
  436. Meet Singles From All Over The World .. FOR FREE !!
  437. count unique in one column based on two other columns
  438. Match two criterias and give a third colums result
  439. Function to use a list box or reference a cell
  440. Sum several sheets
  441. I need help creating a formula for an excel sheet
  442. Retain cell reference after deleting rows
  443. PMT function
  444. Summing from multiple wksts - incomprehensible #VALUE error
  445. Extract first value and last value from a table
  446. How do I mask a Social Security Number ###-##-nnnn?
  447. Current Patient Count
  448. some help with an IF formual or something like it
  449. How do I delete even rows (2,4,6) in an excel?
  450. Linking Excel Files
  451. Drop down list selections creating values in adjoining cell
  452. Re: Sorting Street Numbers
  453. Re: Sorting Street Numbers
  454. how do you find a cubic polynomial using two points (4,500)?
  455. Can I display a hyperlink from one spreadsheet on another spreadsh
  456. Drop Down List Creating Prices in adjoining box
  457. Regression and the confidence intervals
  458. Sorting Street Numbers
  459. Help Otto
  460. sum of more than 30 non-adjacent cells
  461. Border not showing
  462. Repeat text a number define of times
  463. How Do I Create an Alert when two Cells Match over two worksheets?
  464. Pivot Table
  465. How to show two students have same result?
  466. Row Numbers Missing
  467. Summing up different time formats
  468. How to do COUNTIF when cells are not in a consequtive column?
  469. fill blank cells in a column
  470. Lookup populated cell before an empty one??
  471. Lookup function
  472. Find the last value <> 0
  473. OFFSET problem
  474. Error message #VALUE!
  475. How to retrive back deleted worksheets?
  476. Excel Worksheet
  477. macro to hide a row when a cell contains a value
  478. Projecting Revenues
  479. Condition for worksheet reference
  480. PLACINGS FROM HIGH TO LOW
  481. Ask about VLOOKUP or HLOOUP
  482. Conditional Formatting and Filter
  483. fractions
  484. IF AND
  485. Rank Question
  486. count values in a range of cells depending on value in adjacent ce
  487. Finding Character number for ALT-Enter
  488. How to search for "@" in text string?
  489. Display Multiple Worksheets
  490. unable to set the formula array property of the range class
  491. Autofill only copying initial value, not filling formula
  492. Trying to subtract the two lowest values from a row of numbers
  493. adding values if the same - SUMIF in range of cells?
  494. Formulas aren't updating when values change
  495. Maintaining history Data in Excel
  496. Counting Matched Values
  497. Sumif??
  498. Concatenation frustrations....
  499. Conditional Minimum formula
  500. new data
  501. Increase Speed of Calculations
  502. Look up cell content by type and copy to different cell
  503. XLA doesn't show in Add-In List
  504. Running Balance
  505. How do I calculate a time sheet correctly?
  506. if - if then? multiple cells
  507. IF formula?
  508. sum if column has similar values (cusip)
  509. check for highlite and text
  510. SUMPRODUCT returns !Value#
  511. Formatting a Calendar
  512. Hiding numbers in a Text cell.
  513. Excell 2007 Vlookup linking multiple pages
  514. How do I get Excel to automatically calculate the value of a hyper
  515. Transferring data from multiple worksheets
  516. Variable link data
  517. Data from multiple worksheets
  518. Nestled SUMIF Functions
  519. Shading
  520. Length that falls within a length interval?
  521. Insert a filename that will automatically update if changed.
  522. EXCEL DATA
  523. Combine as Date
  524. Side by Side
  525. TRIM Q
  526. Pivot Tables in Excel 2007
  527. cell links
  528. Hiding formula if cel reference is blank
  529. Automating text
  530. Newbie Q
  531. Trying to calculate percentages
  532. time conversion
  533. need help with if statement that calculate minimum figure
  534. event macros vs copy/paste
  535. Summarize Linked Data with Pivot Tables
  536. Copying info from two cells so that it is searchable later
  537. Selecting cells equals to a value
  538. YTD total between worksheets
  539. SumIf formula
  540. How can i make excel to highlight today using conditional formating
  541. cell ref
  542. Formula Calculation
  543. Complex decisions, maybe?
  544. Filter cells with non-whole numbers or comment
  545. Help me
  546. Adding up time values
  547. how many worksheets it has in MS Excel?
  548. creating bank stock
  549. If statements
  550. conditional formatting dates to change if its more than 3 days go
  551. Rounding numbers up or down in same formula
  552. Vlookup vs index
  553. VLOOKUP returning #N/A
  554. New to Pivot Tables
  555. Transpose random length series of cells
  556. Transpose random series of cells
  557. Transpose random series of cells
  558. Open One Spreadsheet from Another
  559. Excel - Calculating quantities in a hierarchy
  560. Working with Time in formulas/calculations
  561. LOOKUP function
  562. formula for numbers
  563. Excel 2007 - Edit button image
  564. how do i find out unique charecters in a colum of excel 2003
  565. materials calculations
  566. Contains a Value Cell and Sumif?
  567. Lookup-value in HLOOKUP?
  568. If a cell contains a value then sum another cell.
  569. display part 2
  570. Christmas Lights Installation Los Angeles, Beverly Hills, SantaMonica, Culver City, Marina Del Rey, Calabasas, Agoura Hills Thousand OaksHoliday Lights Installation 1-310-925-1720
  571. Can u use IF to insert a picture file?
  572. Countif compares to Countifs
  573. Navigator Window for Excel Speadsheet
  574. formula to relate last cell of info to another cell
  575. can you use multiple bin arrays in a frequency formula?
  576. Spreadsheet summary automatically referrences totals of worksheets
  577. displaying correct cell value
  578. How do I Reference another cell's content including its format
  579. Need a function to return EXACT row number of a match
  580. Crazy multi-level parsing of data
  581. Time sheet.
  582. I want sort a list but the sort is unlit on the home tab how do I
  583. Dropped password
  584. Linking to information within a cell
  585. LIMIT THE NUMBER OF CHARACTERS ENTERED IN A FIELD
  586. Importing Crystal Reports into Excel 2007 possible?
  587. I want to line up wrap around text within cell by tabbing over?
  588. if formula #value
  589. Bug in Excel?
  590. Formula expansion
  591. I want my formulas to update when I sort the data, but they dont?
  592. how do I put in two or more rows of info in one cell
  593. appending one Excel file to another ?
  594. Compare 2 sets of data
  595. GETPIVOTDATA Sum of cells
  596. Auto Populating Fields from many worksheets to one main worksheet
  597. Poll: Do you bother with Tab color feature?
  598. Multiple Worksheet in Excell Workbook
  599. Counting blank cells between non-blank cells
  600. Dynamic data ranges
  601. How to set the formula - part 2?
  602. Pivot table Help Excel 2007
  603. Randomly Generate Specific Data
  604. conditional formatting using a formula
  605. Allowing expanding and colapsing of groups in a protected workshee
  606. Check Box in Excel
  607. Pivot Table Sub Total Count Unique Dates
  608. Lookup by multiple criteria.
  609. How to set the formula?
  610. collapsing rows together
  611. conditional formating - Help
  612. Return cell address of a cell based on contents of cell.
  613. How do you bring up the calculator?
  614. Why are the scrolling buttons between worksheets not working
  615. Way
  616. Returning a selection of results using a lookup
  617. Formulas in workbook stopped working
  618. select value in table based on values entered in multiple cells
  619. Counting in multiple column
  620. Trouble with formula
  621. Convert Inserted HTML text as Hyperlink
  622. Need help averaging a range using a diff column as criteria
  623. combining formulas
  624. Countif Function w/ multiple Criteria
  625. Pulling information from multiple worksheets into one.........
  626. Lookup value with items in different rows
  627. Automatically Hide Rows
  628. SUMIF and COUNTIF Function Problems
  629. Find cells w/background color based on conditional formatting
  630. Double Lookup
  631. Need to add figures based on alpha characters in the same cell
  632. Reformat a date imported from another program
  633. Text box character limit issue
  634. automation of YTD calculation
  635. lookup values vertically in a list and return the repeats
  636. Macro to Protect Mult Sheets / but allow Pivot Tables...
  637. VLOOKUP #N/A Error
  638. borders to equal a numbers in another cell
  639. Formula for multiple criteria in a column.
  640. Reference Sheets in a Vlookup
  641. How can I link data in three different cells? ck# date amount
  642. Countif with multiple criteria (incl. calculation)
  643. Help with locating values in cells and caluculating
  644. Cell Value Plus ( or Minus) Upper (or Lower) Limit
  645. which formula? Match? IF?
  646. How do I make AutoSum really Sum, not Subtotal
  647. Sumif
  648. today function in an "if" formula
  649. Best grade using MAX ...BETTER WAY?
  650. Referencing a cell address in the Offset formla
  651. what is the best worksheet function to...
  652. Lookup value,return column heading
  653. Formula
  654. How can I adress diferent Sheets in same Book according to a cellv
  655. Formula help
  656. CREATE CUSTOM SORT IN EXCEL
  657. how do I sum currency values in a row containing currency and uni.
  658. Formula in Excel
  659. Vlookup not sufficient - suggestions for combining multiple matche
  660. Formula in excel
  661. Master
  662. Count Records
  663. Find numbers lower / further than the previous (Track & Field)
  664. How do I call current computer time to a cell?
  665. transfer data cell from another work sheet
  666. Cheap Indian Chicks
  667. SUMPRODUCT won't work on a row
  668. lookup value in table
  669. Extract street number (foreign address)
  670. Parsing one part of an address
  671. Import External data from a Website
  672. IF, ISNA & VLOOKUP
  673. First Non-Blank Cell
  674. Autofill summary worksheet
  675. VLOOKUP for this problem?
  676. Link cells to pull specific data
  677. Pivot table help
  678. Summarizing data assigned to a label
  679. how do I round a column of numbers to the nearest
  680. sumifs, sumif with dates
  681. Formula gone awry
  682. freeze panes not an option
  683. Count how many times a phrase comes up?
  684. Match criteria with an array of criteria
  685. What's causing error message?
  686. copy a cell value based on search of another cell
  687. cell lookup
  688. How do I re arrange numbers
  689. Referencing an active cell's content from another sheet.
  690. Conditional formatting if a cell contains a formula
  691. Countif with criteria
  692. Conditional format entire row from one cell
  693. CountIF(A9:A20, B9 not equal B10, B10 not equal B11, etc.)
  694. i need to get all matches in one column for one criteria
  695. Lookup between two books
  696. Count with criteria
  697. Help! Minimum Excluding zeros across multiple sheets
  698. If 5th character="-" delete everything to the left otherwise do no
  699. function for accessing a database
  700. automatic fill
  701. IF AND statements
  702. Run data analysis
  703. VLOOKUP formula
  704. Gauss Chart
  705. Help with a macro
  706. How to collapse Pivot table + icon
  707. Numerical value of logicals
  708. VLOOKUP with date ranges
  709. Macro for deleting rows and serialising the remaing rows
  710. how to sum all values of a variable that's repeated multiple times
  711. Order the names by ranking
  712. IF, AND, OR Function
  713. SUMIF and SUM.NUMBER
  714. IF... do nothing
  715. sumif and numberif
  716. Sumproduct automatically count number of rows
  717. Change format of a date field
  718. Conditional Formatting a drop down list
  719. Extracting data from large text files for beginner
  720. how to accumulat the amounts of employees monies from worksheets
  721. following the active cell address without recalc
  722. sumif function leaving a blank cell when criteria not met
  723. formula to make a running total for three different items
  724. Circular
  725. Challenge for Anyone to take it on.
  726. How do I add additional columns beyond column "IV"?
  727. Excel What Function shows value between highest and lowest number
  728. Sharepoint Linked File Causing #Value Error
  729. protect row of cells
  730. IF Formulas
  731. is this function correct?
  732. If Than Statement
  733. Solver
  734. Viewing Names
  735. using the active cell as a reference in a function
  736. Time and megabytes
  737. Conditional if a date is valid
  738. numbers convert to formula in csv
  739. Complex conditional formatting
  740. Inventory Tracking Sheet
  741. IF formulas?
  742. Working out a value within a certain month.
  743. How do I set up a counter to keep track of prited copies (2 pages.
  744. Changing font color if conditions are met
  745. Pivot pulling Multiple tabs
  746. Rolling Average
  747. How do you format a larger font for cell comments ?
  748. Isoloating particular senario from pivot table
  749. split print area in excel - One Page Print
  750. Pivottable calculated item - how to suppress zero?
  751. How do I create a drop-down menu to sort data?
  752. Hidden Sheets keep appearing
  753. Auto number Non null values
  754. Netwrokdays and EOMONTH Functions return N/A when opening Excel sh
  755. Transposing multiple rows to multiple columns
  756. Count Function
  757. distribute the collaborators in 3 groups
  758. Un-Synchronous Panes
  759. Pivot Table + Microsoft Query + Current Month
  760. Index with 0 values in range
  761. Calculating Tax %
  762. Help with a Macro
  763. Linking data between worksheets
  764. CONVERTING NUMBERS TO TEXT
  765. Match and Tables
  766. Index and Match
  767. Sum values in columns based on values in named range
  768. IF Function
  769. Average of group!
  770. How to load a worksheet from Internet into a worksheet?
  771. Problems using DMAX, DSUM, DAVERAGE with new table
  772. formula help please
  773. How to convert all words to CAPS
  774. IF and OR statements
  775. breaking a field out
  776. count if question
  777. How to determine the value?
  778. Expanding a named range
  779. formatting question
  780. Merging two spreadsheets
  781. always calculate last 5 rows even after 1 inserted
  782. event vba
  783. Average of Vlookup data
  784. IF Statement with AND Statement
  785. Lookup less than a number
  786. Pasting comma delimited data
  787. Linear Regression Analysis
  788. countif function
  789. Need to find matching criteria in 1 column, then add amounts in a
  790. If statement only shows value in first cell
  791. Can I use sumif with OR to sum based on two column criteria?
  792. IF function not working
  793. No. of columns in a Pivot Table
  794. Find suppliers
  795. count using multiple criteria including text strings
  796. Complicated If Statement - I Think!
  797. Conditional formatting
  798. Vlookup
  799. Function changed
  800. function to only show unique cells in range (e.g. B2:B20)
  801. How to find and replace with blanks or actually delete row
  802. How to sort and export just email addresses in a mixed column
  803. How to set up worksheet where cells change monthly
  804. VLookup accross multiple worksheets
  805. Funtions Not Taking Effect
  806. COUNTA Function
  807. Function for counting Worksheets?
  808. TO COPY MORE THAN INE RESULT FROM OTHER SHEET USING LOOKUP
  809. INDEX? MATCH?
  810. Function to calculate the Length of Service of an Employee
  811. Excel Master needed - Too tough to tame
  812. Counting the changes in a cell
  813. vlook up two column
  814. Do you know any formula to delete accents?
  815. sorting
  816. Currencies
  817. what to use
  818. Formula to get data when condition is satisfied
  819. merge named ranges
  820. Week No Q
  821. How to determine the value?
  822. Convert hyperlink function into hyperlink
  823. pick from letters A-Z?
  824. Help with IF statement
  825. EXCEL HYPERLINKS STOPPED WORKING
  826. How do I separate and calculate a value in a cell with an IF
  827. Identifying unique values among duplicates
  828. Counting text in two columns
  829. How to use a range in a custom function?
  830. which record is deleted when I use the "remove duplicates" functi.
  831. Need to figure out Annual Rents
  832. using wordwrap in excel for text writing
  833. Add 10 minutes to a date/time value
  834. Reference a number from a different column in a formula
  835. Query Wizard - Choose Columns
  836. EXCEL & WORK LOCKED
  837. Extract Part of a Cells Contents Q
  838. Conditional Formating question
  839. excel 2003
  840. How do I keep a excel worksheets dementions, and the cell size
  841. need formula for counting employees by hour
  842. Another sub total question
  843. Summing up values
  844. ÚÑÖ ãÏæäÉ ÇáßÇÊÈ ÍÓä ÚÌãí
  845. AUTO NUMBER
  846. SUMPRODUCT with LEFT() criteria?
  847. Format numerical value to Million
  848. Find range a value fits to, assign new value based on importance
  849. combining IF OR Functions
  850. vlookup errors #n/a
  851. why is there 256 columns and 65,536 rows in excel
  852. file links incorrect when file is re-opened
  853. Locksmith Los Angeles Lockout Service (877) 364-5264 Rekeying LocksInstallation
  854. Text Function 2nd argument
  855. Increasing number depending on input
  856. Look up data for date range
  857. Conditional Format Q
  858. Express Hours in Days Q
  859. How to count two cells occurrences in a worksheet
  860. Extract part of a cell
  861. Functions and charts
  862. Re: *** Amazing Bra Deflects Gunshot ****
  863. database extract having 3 common cell betwenn sheets
  864. Return Button on the Keyboard
  865. create new table from Multiple Criteria in multiple columns
  866. HOW TO INSERT A * BEFORE AND AFTER EACH WORD
  867. Calculate Amount Based on Year
  868. need a formula that uses a cell ref that contains a range name?
  869. Need formulas to pull date and time from 1 cell to 2
  870. Blank template for calendar
  871. Need help extracting date and time with Excel 2K
  872. How do I set the hyperlink to reference a cell for the file name?
  873. Lookup Information from Across Worksheets
  874. Count cells in range w/specific background color?
  875. how to hyperlink a column of fileserver addresses?
  876. removing single items from list
  877. Sometimes I can't see or edit comments in xcel cells. Why?
  878. function
  879. Formatting negative percent
  880. Change numeric value to it's text equivalent, ie dollar values
  881. how to enter a radio button on excel
  882. Summing the same column from many sheets with specific Row ID numbers
  883. add fill color or font color to if function
  884. Email individual worksheets??
  885. Advanced filters (+/-5%)
  886. Help with simple if statement
  887. Formulas advanced
  888. help with if statement
  889. Auto enter current date in cell when another changed
  890. Create auto numbering
  891. How do I remove carriage returns from a cell
  892. Fill Cells with same number in three rows then skip to next number
  893. Sumproduct?
  894. 11.04 forex article
  895. some forex article
  896. copy cells using formula
  897. Forum copied
  898. Oversettelse av Engelsk formel
  899. The best of 5 cells
  900. IF Formula
  901. How to use macro to set "Sum" function
  902. SUM rows
  903. Linking cells on different sheets within a workbook.
  904. How do i click on a cell for a tick symbol to appear & dissapear?
  905. complicated if function
  906. Autofill
  907. how can I compare two columns
  908. Using SUMIF with criteria of cell containing a specific character
  909. Conditional format - value of one cell greater than another cell
  910. VLookup question
  911. I found Row 14 in wksh 2, can I get the value of J14 into wksh 1?
  912. Multiple paste not allowed
  913. ignore "0"
  914. formula with increments of 6
  915. Use SUM to add time format
  916. Summing/Counting Data in One Column Based on Criteria Another Col
  917. Negative numbers in pivot table
  918. Vlookup with multiple fields that need to match
  919. Nesting IF/OR Statement
  920. Macro Needed
  921. Search a string in a cell for a list of 3 letter codes
  922. calculating total in a column
  923. How do I create a combo box of hyperlinks?
  924. statistics - guidance
  925. sumif with 2 ranges and multiple criteria
  926. Missing information in excell
  927. Changing text to number
  928. Protect Sheet Macro
  929. Is there ant way to prioritize by date?
  930. List help!
  931. formatting sheets in a workbook
  932. Linking Rows instead of just cells.
  933. sumif
  934. COUNTIF multiple criteria
  935. Conditional formatting/non blank cells
  936. how do you match data and paste result in a perticular cell?
  937. Nesting the ROW() command into a Conditional Format Formula
  938. How do I color a cell based on cell text
  939. How do I get the horizontal split box back?
  940. Random Code Generation
  941. Install Program starts when selecting formula
  942. Multiple drop down lists filtered
  943. How do I count cells that contain a number of charctors.
  944. Hyperlinks
  945. Formulating cells
  946. Round up to next .5
  947. For each change in Col. C, Count Unique Numbers in Col. G
  948. Counting Worksheet Data
  949. LARGE
  950. Dates from Text
  951. returning one arguement from several columns
  952. How do i find holiday a chart for office
  953. Display last status information
  954. Display invisible numbers in a drop down menu
  955. formula
  956. Repeat formula with inserted row
  957. Sum formula to include new rows added
  958. what are the keyboard strokes to reveal formulas in a worksheet?
  959. Help with function, if possible
  960. + or - as text, not math function
  961. Forecasting or projecting
  962. how do you use visual basic to find cross product of two vectors
  963. How to setup autoconnection between matching cells in 2 dif WSs
  964. Sum Vs. Avg
  965. Pivot Tables & Vlookups
  966. VBA Set of Calculations
  967. VLookup Data, Find 2 Adjacent Rows, Return Value in 1 Row
  968. concatenate in array formula?
  969. IF formula
  970. Function to Count Zip Code Digits With Leading Zero
  971. CONVERT A DATE TO A DAY
  972. Midpoint of times in shifts
  973. Excel worksheet problem
  974. time sheets
  975. Finding info within a data set
  976. copy formula down 1000,s of lines
  977. sort column corresponding to second column
  978. Index/Match to get Count (from Subtotals) into a Table of Names
  979. Text format for french date
  980. Paste Delimited
  981. Is there a "between" function?
  982. hidden columns
  983. "IF" formula
  984. Autosum column values, if separate column values equal certain val
  985. Text to Numbers
  986. COUNT IF
  987. LOOKUP vs IF programming question
  988. Can you lock the format of a cell and still change content
  989. Excell 2007 Vlookup linking multiple tabs
  990. Data validation
  991. Sort help
  992. Excel Formula's
  993. Multiple Dependent Drop Downs
  994. Confusing Function
  995. search value in 2 columns return value in another
  996. Complex text to Excel formatting. Urgent
  997. Formatting a Cell with a Symbol
  998. Conditional Formmating
  999. Using INDIRECT & R1C1 Ref style
  1000. Display Text in Formula Bar for certain cells