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. copy many sheets into one
  2. Convert Seconds to Minutes
  3. index/match or vlookup or similar
  4. CSE formula disregard blank cells
  5. Link from 1 worksheet to 4 different worksheets
  6. Moving Info from onw sheet to another
  7. Confused about setting up functions based on variables?
  8. Using the CountIf function with multiple criteria?
  9. IF, AND, OR Function
  10. Automatically update spreadsheet from another spreadsheet
  11. Opening an .mdb file in Excel
  12. auto-complete from a drop down list and from a different workbook
  13. Macro is not responding
  14. how to extract duplicated data from two seperate worksheets?
  15. Re: IF, AND, OR Function
  16. How do I use moving averages in Excel 2007?
  17. Conditional Formatting =IF($B1>0, TEXT("dddd"))?
  18. How do I Propogate Cell Selection Pattern?
  19. If / And / Or Macro
  20. Can u put an "IF" inside of another "IF"??
  21. How can I sort when the worksheet is locked?
  22. excel 2000
  23. Ordering Columns in Pivot Tables - Excel 2000
  24. Set line color in a spread sheet
  25. Conditional Formatting for more than 3 conditions
  26. Multiple Criteria, Count If, Sum Product to get count across range
  27. CountIf, SumIf formula ques.
  28. edit directly in cell - scroll with mouse
  29. Advanced Filter By Cell Contents
  30. Can I get Excel to automatically BOLD dates 30d before expiration?
  31. Transpose array sum
  32. How do I modify database criteria at formula level?
  33. Excel automatically updates inserted date
  34. if formula
  35. SumIf Problem...trying to sum multiple columns
  36. Subtotal - Based on DATE
  37. I need help with a formula.
  38. Formula Help
  39. Retaining cell reference in destination, when sorting source file
  40. Multiple Variable Formula Help
  41. SUM odd/even Rows?
  42. Control + Grave accent doesn't show formula result, format is gene
  43. SUMPRODUCT question
  44. Vlookup plus other function/s combinations required?
  45. range usage question
  46. How can I count data after I apply a Filter in MS Excel
  47. Travesing to one cell value based on other cell value!!
  48. Result of Multiplication is comming up as zero
  49. remove convert/extract the number from'12345.56; ie remove ' sign
  50. Get data between two values
  51. Linking Excel Worksheets
  52. Copy links between excel workbooks using citrix?
  53. Pivot Tables to summarise a column in one row?
  54. referencing a 3D Named Range
  55. short cut for inserting rows
  56. Keeping formulas that reference a tab that changes daily?
  57. adding up sheets that arent there yet
  58. I want to link an Excel cell to a contact record in Outlook
  59. How could I flag a cell. Ex. Cell B is less than Cell A. Flag B
  60. Missing sum bottom of excel window
  61. Auto Copy Text from one work sheet to another
  62. How do you merge worksheets
  63. How can I transfer formulas between 2 Excel workbooks?
  64. Conditional formatting to test blank text cell
  65. If Then Or Statement
  66. Excel
  67. how do I tie multiple worksheets to one sheet in Excel?
  68. how do I tie multiple worksheets to one sheet in Excel?
  69. help with lookup and range
  70. Count with condition range
  71. merging 2 excel sheets
  72. what do the brackets { } mean around a formula?
  73. Long "IF" formula
  74. Linking text
  75. Highlight a cell with a specific word in it
  76. Sorting by colors
  77. index and match closest
  78. checkbox in a protected worksheet
  79. Embed an array?
  80. Copying data based on filter criteria
  81. INDIRECT & SUMPRODUCT QUESTION
  82. How do I fix a YMD format?
  83. linking worksheets
  84. Autofill Array Functions
  85. Upper and Lower Case "within" a formula
  86. Excel - disable automatic function
  87. Excel - disable automatic function
  88. Conditional formatting
  89. transferring data between sheets
  90. Formula to match 7 columns of non adjacent data
  91. SUBTOTAL with a condition
  92. actual/360 and 30/360 amortization?
  93. How do I turn off format painter so it doesn't keep popping up?
  94. 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
  95. How do i consolidate 13 spreadsheets onto one
  96. final return!
  97. How to repeat cell downwards in a column?
  98. PLEEEEEASE HELP
  99. Conditional formatting
  100. Naming working sheets
  101. Create new worksheets per pivot page field
  102. Editing Comments
  103. Equal formula keeping both content and format
  104. Replaced a file but need the old file back
  105. How do I average only if data in another column = "X"?
  106. Importing into excel PROBLEMS
  107. Value from List Box?
  108. match function for 2 values
  109. Column question...
  110. Formula Error #value
  111. Custom Functions
  112. Automating a printing of pages that are Hyperlinked to external so
  113. Row reference in a formulas
  114. Formula for "counting" numbers - bot cells!
  115. col heading help
  116. Help me with a pdf converted into excel
  117. Adding a yearly calendar to excel spreadsheet
  118. Using auto-fill to populate a table using data from several tabs
  119. Function for stopwatch times
  120. Not enough conditional formatting
  121. Drop Down menu w/ info in other columns
  122. Bold the number only in a concatenated with text formula...
  123. AUTOMATIC SPELL CHECK
  124. Conditional Formatting across worksheets
  125. disable Warnings in Excel
  126. "Date Format" v.s. "##/##/####"
  127. conditional headings
  128. Re: Printing a specific area containing data and not formulas
  129. How do you automate cells to poplulate fields in separate workshee
  130. Conditional Proctection?
  131. Drop Down List Size
  132. Transpose and Paste Link
  133. Auto column insertion based on a number
  134. Accumulating Attendance Base upon Age Group
  135. Transaction Classifications in Checkbook
  136. Auto Populate from a Mater List into Sub Sheets
  137. hiding error message when dividing by 0
  138. Creating a new "record"
  139. Wrapping cell data to a new column or page in Excel
  140. open file in current directory
  141. VLOOKUP
  142. Automatically extracting unique values
  143. change event macro to add cells
  144. What is ;
  145. Criteria field in dsum formula
  146. Service Charge Allocation
  147. autocomplete from specific list
  148. Automatic Drop Down List
  149. Need hyperlink function to obtain range name from a cell (contents
  150. how to enable formula auditing in a protected worksheet?
  151. summarizing data
  152. Omitting right part of text string
  153. how to I determine frequency
  154. custom add formula
  155. problem data validation and copy/paste
  156. automatically update hours
  157. Count occurences from one worksheet to another with "IF" Criteria
  158. Basic Statistics - which function?
  159. Formula for "counting" numbers - not cells!
  160. VLOOKUP IF
  161. Compare two lists; return only unique records
  162. convert text to number in excel
  163. Vlookup -Difference between 2 versions
  164. Extract part of a text string
  165. Excluding cell in formula
  166. "SUM" DOESN'T RE-CALCULATE WHEN A ROW IS INSERTED ABOVE IT
  167. Can I VLOOKUP in 7 different worksheets in 1 formula?
  168. how can i write an equation in polar form in excel
  169. large database with multiple rows
  170. Macro HELP
  171. Autocomplete combo box
  172. Adding criteria to loop
  173. need a function or property to extract the hyperlink from a cell
  174. New version of Excel doesn't show my other worksheets!
  175. Edit Multiple Cells
  176. Conditional Formatting with Percentages - only 2 of 3 working
  177. How do i use a 24 hour clock format on my timesheet?
  178. Problem encountered when saving worksheet as a text file
  179. Express a Formula that is + or - 20% from a Value Q
  180. Is there a way to turn off the auto save function?
  181. how do i bring back excel sheet ?
  182. Converting a Formula stored as String to real Formula
  183. If Then Or Statement
  184. how to sum only specific coloured cells
  185. Macro error
  186. "Grouping" based on value in a column
  187. average(if not working properly
  188. No. of Saturdays between 2 dates
  189. Probelm with macro
  190. constant date
  191. Duplicates in a spread sheet
  192. date entry
  193. Nesting SUMIF with Wildcard
  194. how do I change a date to show the year only?
  195. Writing a macro
  196. 6 cell sum
  197. Not sure which function to use - need multiple lines of data
  198. converting .html to regen lost .xls file
  199. Excel macro spreadsheet that is rejected by other firewall. Why?
  200. Paste from clipboard only
  201. reference first cell in a named range
  202. SUMPRODUCT, INDIRECT, dates...
  203. What function do i use?
  204. Consolidating worksheets
  205. Color cell if spell check finds an error
  206. Array or SumProduct or other?
  207. Explode field
  208. I have the checkmark beside print gridlines and they won't print
  209. Not all words in sentence prints - row is set autofit HELP?
  210. NOT equal to
  211. DCOUNTA question
  212. Capitalize first letter in sentence
  213. Extracting List of Occurrences
  214. Bill Payment Form
  215. Get Values from another Worksheet
  216. Leave Cell BLANK if no criteria met
  217. add file extensions to a column
  218. DATE() Month in Letter NOT Number
  219. Editing formula results so zeros appear blank
  220. count(if(... using array formula: can I use a named range in my ca
  221. Calculating time
  222. Remove Negative Signs from Formula Results
  223. Problem w/formula referencing another sheet
  224. Average & Deviation
  225. how do I enter a reoccuring event like once every 9 days
  226. nested MATCH within Array formula?
  227. Convert Number to Words
  228. Convert numbers to words
  229. How to reference a cell depending on the value in another cell??
  230. Returning an array of unique values?
  231. Copy specific records from a worksheet to another
  232. #VALUE! from SUMPRODUCT
  233. Ranking with Duplicates
  234. Find value in more than 100 worksheets at once
  235. Auto populate data from a table into cells after a match is found
  236. Using COUNTIF for multiple text data creating a logic statment
  237. copy and paste.
  238. Use Formula to sort two strings
  239. Difficulties with date in conditional calculations
  240. Challenge: Return the rightmost 12 values (rolling 12 months)
  241. Running a macro
  242. How Can i use the cell colors as logical tests?
  243. Is it possible to save only a specific sheet within a workbook
  244. formula
  245. Replacing a Table-array with a cell reference in vlookup
  246. Adding single cell in multiple worksheet then averaging
  247. find all same numbers in a column without dropdown listing
  248. conditionally format anumber format
  249. Return cost with 2 criteria
  250. Show the top three items in a list
  251. Auto fill icon...
  252. Data Validation Fail
  253. Need Help..
  254. "background" formatting possible?
  255. Identify if a cell contains a numerical string
  256. Between one number and another
  257. conditional format help please
  258. Date Question
  259. How to delete an repeatitive entry from a worksheet
  260. statistical process control
  261. What would Excel Assume if DATE left blank
  262. Combining columns?????
  263. Is solver different between Office versions?
  264. Sorting "State" Column onto separate worksheets in same workbook.
  265. Creating a proprer macro in Excel
  266. Copying Data from Multiple Sheets to One sheet
  267. HOW DO I SYNC EXCEL FILES ON A LAPTOP?
  268. Driving me nuts trying to figure this formula
  269. Count names and occurrences
  270. networkdays function
  271. Number Formatting in a concatenated cell
  272. dates older than 1900
  273. loan amortization schedule
  274. Selecting data from cells that are 5 rows apart and groung in 1 co
  275. Fun Place
  276. Find Formula
  277. drap copy without increasing the value
  278. Link to Pivot
  279. uncombining columns
  280. Need help with formula
  281. Drag Copy
  282. Populate an order form with Data
  283. Collapse and expand data
  284. Have code check cell contents on edit.
  285. calculate formula of another cell
  286. Concatenate Question
  287. VLOOKUP
  288. Copying data to a different row
  289. Splitting the characters in the cell
  290. 3 column lookup within range
  291. excel search formula
  292. WORK HOURS DIFFERENCE BETWEEN TWO DATES
  293. How do I select more than one item from a drop down pick list?
  294. Duplicates Formula
  295. Adding a Custom Column based on an existing Column (EXPERT)
  296. Find and count (sumproduct)
  297. Delete a row without dirupting the formulas in the following rows
  298. Date format
  299. Data inputting question
  300. new
  301. Count consecutive cells then start over
  302. META Tags Explained And How To Use Them For Ranking
  303. Fill cell with a worksheet name?
  304. Freeze pane works in some workbooks but not others
  305. sumif
  306. Changing the value in a cell (but a bit more complex than that <G>)
  307. Column has emails & other stuff. Want to create a column w/ just e
  308. New to functions. Is this possible???
  309. Can I separate two words in a column?
  310. Create Acronym (Extract first letter of each word)
  311. Create a macro to eliminate certain words from several columns
  312. Cycle Time if in a Specific Year
  313. Vlookup DETAILED directions
  314. Grayed Out Columns
  315. Merge data from xcel to word
  316. Vlookup plus
  317. sorting imported data
  318. Excel color-formatted cells printing in black
  319. FYI - Microsoft Acknowledges XL Flaw
  320. Count Blocks of Data
  321. VLOOKUP
  322. Sales Commission Calculation
  323. not sure how to do a formula
  324. Can you save 1 sheet from a large file into another file?
  325. naming cells
  326. web query
  327. Different font characteristics in concatenated cell
  328. How to show original comment in cell when using Vlookup in Excel?
  329. How can I count the frequency that a number is repeated?
  330. SubTotal function to return number of rows returns only zero
  331. (V)LOOKUP question
  332. complicated excel formula
  333. Returning a Cell Value
  334. Validation look-up lists showing in 8 point, too small read easily
  335. how do i sort an excel spreadsheet by column
  336. Formula VLOOKUP I think
  337. cancelling copy command after reactivating workbook
  338. you are help me
  339. need help on excel sheet formula
  340. Working with the forms in different workbooks...
  341. Year & Month format
  342. Count the number of AutoFiltered records
  343. Linkage File
  344. Conditional format issue
  345. Keyboard Shortcut for Drop Down List
  346. vlookup formula
  347. Filtered field
  348. Numbering different products
  349. Linking Files
  350. creating a report with macros
  351. Display if cell contains data
  352. problem trying to change page breaks
  353. Excel formula reference question
  354. Create alternate line of data
  355. Worksheet change Event
  356. Sumproduct but exclude labels
  357. IF Error
  358. adding function- can you hide the 0.00 in the total column
  359. IF function
  360. IF function question
  361. Count If And Contains
  362. GETPIVOTDATA with date in referenced cell
  363. Protect borders only excel spreadsheet
  364. Insert a row with simaler data using a function
  365. Validation - e-mail
  366. Total A Range
  367. How to return a number into letters?
  368. Formula or function displays after edit and not its result
  369. More Planned and Actual Cycle Times
  370. Autofill dates not in contiguous cells
  371. scatter plot
  372. Formatting color and font to a logical statement result?
  373. I can't get Excel to caluate dates in the 1800's. #VALUE!
  374. How can I create one column (stacked) from a large table of data..
  375. question re: SUMPRODUCT format
  376. Need cell to equal another cell if certain criteria is met?
  377. Help with spreadsheet
  378. How can I delete all matches in a workbook?
  379. Copy first few letters from a cell
  380. VB file renaming.
  381. Making a list of numbers with 16 digits
  382. need to move cursor to specific fields
  383. UDF that returns a date
  384. keyboard short cut for highlighting a field
  385. Queries, extracting
  386. Queries/Extracting
  387. Cell Shading
  388. Removing #N/A from formula results
  389. How do I count occurances of a specific character in a range?
  390. Assign a date
  391. Automating excel with outlook
  392. Disable Excel Print
  393. Find one character or another and display
  394. Assigning A Macro to A Button
  395. Function To Lookup Unique Records In 2 Sets Of Data
  396. How to check for a date range match in one column and then count thevalues equal to in another
  397. Extract data from database
  398. Check Date Range and Multiply Stock Qty
  399. How-to create a list from a summary table? (Office 2007)
  400. why does my "TAB" key skip a column in excel spread sheets?
  401. Help Vlook up returning N?A
  402. Excel 2003; using a date in a formula
  403. vlookup / index / match?
  404. Finding duplicate numbers in a spreadsheet
  405. Why does my print preview (and print) not reflect the chosen margi
  406. Too much data?
  407. "add parenthesis"
  408. Excel formulas
  409. Array Functions
  410. changing dates and years with less keystrokes
  411. how do I lock formulas, but still allow rows to be added or delet.
  412. Defined Names in Workbook
  413. Sumif for groups and subgroups / Excel 2003
  414. Economical grouping of lengths out of much longer lengths
  415. Sum column based on text of another
  416. amortization table
  417. how do I write the formula to find the mean in a column of number
  418. Conditional Formatting help, please
  419. Can you use multiple SEARCH functions in one cell
  420. Regression with zero intercept
  421. Year to date sales
  422. Worksheet Protection
  423. If Statement
  424. Hyperlink
  425. vlookup?
  426. Borders and conditional formating
  427. can I find the area under a plotted curve?
  428. How do you determine a total number of worksheet entries?
  429. Urgent help needed
  430. formula for pairing 60 different products into 5 price groups
  431. Functions
  432. Move Specific Data to Another Worksheet
  433. Recover Excel file that was saved over
  434. How to determine the value?
  435. SUMPRODUCT gives incorrect total
  436. how do I add a solid color fill to a photo inserted into excel
  437. 2003/XP Macros in 2000
  438. Excel Sequential Numbering of cell within worksheet
  439. index/large..help please
  440. Cond Format - C6 when G6 contains any text
  441. Macro to Move Specific Data to Another Worksheet
  442. Can I convert a number(1-365) to a month and day of a year?
  443. How do I use the LOOKUP feature in Excel
  444. Create a rule>
  445. auto filtering?
  446. retrieve data from worksheet
  447. whole price sheet change
  448. Do I use "IF" or something else?
  449. Negative time calculations
  450. excel spreadsheet
  451. Can I link/lock rows so they move together in a sort?
  452. totalling phone minutes
  453. Help with adding pages
  454. Interpolate two or more data points
  455. referencing mult drop down list
  456. Functions
  457. Text lookup array and match specific data
  458. phone number format
  459. Output of the =IF(COUNTA) Function
  460. Delete all data on a worksheet
  461. Count of entries meeting criteria
  462. How to get text
  463. Somewhat Complex: Allocation of Payments
  464. I have a DB of auction items sold, how can I create receipt?
  465. Hyper link between excel worksheets
  466. dropdown list within IF statement?
  467. Pivot Table Wizard Fails to Recognize New Rows of a Named Range
  468. millisecond
  469. SUMIF? Question
  470. choose table_array in VLOOKUP from list of multiple worksheets?
  471. Date stamp when a value is entered in a cell on another worksheet
  472. Editing an Office 2003 Document using Office 2007
  473. index\large help....UPDATE
  474. Custom number code [conditional] help
  475. if then
  476. Populate order sheet with data from work sheet
  477. Data Validation 2003, Named Ranges/Formulas
  478. How can I set up a dynamic data entry form?
  479. adjacent cells?
  480. Combining AND, MID, and OR
  481. changing date format
  482. Date stamp when a value is entered in a cell
  483. Using list functionality
  484. How to
  485. Hide a row and set print area
  486. Formula apparently successful but #VALUE displayed
  487. HELP: Sort of AutoComplete feature or i don't know
  488. Sum Count of Numeric Duplicates: appears x2 in any Row
  489. E-mail Sort
  490. Filter Across Multiple Sheets
  491. How to find a third true-false relationship between three groups ofvariables knowing two
  492. counting numbers??
  493. getting 3% from a work sheet
  494. Populate Order worksheet from Quote worksheet
  495. Automatically move to next cell...
  496. format cells
  497. Syntax help with date calculation
  498. Can't Access Add-Ins
  499. How do I hlookup a text document object and then display it?
  500. Use an If function to result in more then one answer
  501. A somewhat complex (to me at least) Nested IF issue
  502. Excel Chart
  503. More help on a UDF please. Urgent!
  504. A problem with nested IF's
  505. Replace the Find Function with a formula
  506. Modify a UDF please?
  507. Page Filters
  508. Exclude Unique Values
  509. A problem with nested IF's
  510. Modify a UDF please?
  511. A problem with Nested IFs
  512. Find unique data by row
  513. MVP Published articles
  514. EXCEL 2003
  515. how do i make a formula to multiply two values?
  516. Can't paste cells between sheets and have formulas follow
  517. MVP articles
  518. This should be easy, but can't find an answer...requesting your in
  519. Referencing Cells on Another Sheet
  520. time seperation
  521. Question about COUNTIFS
  522. More help with a UDF
  523. Referencing Cells
  524. Referencing Cells
  525. Test
  526. test
  527. only returning 1st matching entry in table, need to find next matc
  528. Advanced Array Formula Problem
  529. Date format
  530. auto change font color in formula/cell
  531. insert worksheet order
  532. need to return next match of table, only finding first match...HEL
  533. How Can I Insert A Column in A Spreadsheet With This Error Message
  534. Cells changes colour if....
  535. Mode Statistic Function
  536. trying to get worksheet to automaticcaly update form row to row
  537. Cell content
  538. Calculate number days + hours to complete a project
  539. Multiple Logical Functions in one Formula
  540. Help w/Validation List & VLOOKUP
  541. Getting a list of returned values from an array
  542. Need help with a worksheet
  543. Excell
  544. I want to count the cell if contains 111 or 1111
  545. Date changes mysteriously
  546. countif with variabel criteria?
  547. CALCULATE THE ACTUAL AGE IN TERMS OF YEARS, MONTHS AND DAYS
  548. SUMIF Question
  549. create yearly subtotals in pivot table
  550. SUMIF Question
  551. Formula Help
  552. How to delete blank worksheets
  553. Add worksheets in excel
  554. Need help with formula
  555. Cell value when conditions are met
  556. how do I have a heading row repeat on each page while working?
  557. FORMULA
  558. FORMULA
  559. Filters using multiple sheets
  560. I have doubt regarding the find a result with two criteria's!!
  561. Date format
  562. What function-bring me the info in the next column-same row?
  563. Can't remove formatting from copied data in Excel worksheet
  564. Why does this code not do what I want
  565. How to count occurrence when there is an "AND" relation?
  566. Macro for Copying
  567. Remove #VALUE! from ConCat Range Function
  568. Conditonal lay-out
  569. MS Excel Nested Functions
  570. How do i get more then 3 colours conditions in one sheet in excel
  571. INDEX error
  572. Adding code to a macro
  573. excel worksheet export into access table
  574. Column with repeated numbers
  575. My Excel Spreadsheet now has numbers on both axes - why?
  576. Hot Fragrances For The Holidays
  577. Easy Calculator
  578. results of value_if_false = no change to cell
  579. Attrition
  580. Having Trouble Inserting a Column
  581. Bug or wrong approach
  582. Interpret a squence of cells as an array
  583. SUM function across multiple worksheets within one workbook
  584. IF Function Question
  585. Sumproduct with 2 criteria.
  586. Incremental forumla needed
  587. Copying only selected items to another worksheet
  588. MAX Array?
  589. How do I transfer data with hyperlinks to a pivot table without l.
  590. Error Handling for xlCellTypeFormulas
  591. How to insert rows based on change in data
  592. Automatically change case is Excel when typed
  593. Hot To Copy Pivot Table formats
  594. Notify when cell value changes - Excel 2007
  595. Dynamic Row Formula
  596. importing data form access
  597. Allow no action to be taken
  598. Merge and remove duplicates?
  599. Counting unique entries across two or three columns
  600. Lookup a value in a row and the sum the corresponding rows in colu
  601. Auto-fill formulas Excel 2003
  602. sum column based on multiple criteria
  603. Automate adding in a reference number if the adjacent cell contains text...
  604. time guru needed
  605. Connecting Worksheets
  606. if range b6:n6 has no content, return A6
  607. Solving Sudoku with EXCEL
  608. Running total for inventory
  609. Seeking advice for complex charting algorithm (16K attachment)
  610. Formulas in 2007 not working in 2003
  611. I am in search of formula
  612. lookup problem
  613. remove leading spaces
  614. Copying the sum from the lower right hand side of the excel window
  615. Average time between 2 dates
  616. Auto copy data from another database
  617. conditional formatting for <= +- 1.0%
  618. Insert>Name>Define
  619. Re: Seeking advice for complex charting algorithm (16K attachment)
  620. CONCATENATE Date formatting
  621. Insert Columns in multiple sheets
  622. SUMPRODUCT against rows, columns
  623. Formula Problem For Checkbook Register
  624. Looking for formula to place score in a range of scores
  625. Lists
  626. can I compute the bounds of a 3D reference
  627. Trying to get a value using two conditions
  628. I need to Write a Formula
  629. Formatting Code for SI Units in Excel
  630. Formula
  631. Compare value in current cell to previous cell
  632. Retrieving data based on most recent date
  633. Auto Sum Function
  634. Drop down menu and validation over mulitiple sheets
  635. How do I freeze a data range when I drag it to a new cell?
  636. If in specific cell in any worksheet but worksheet one add to spec
  637. calculate remaining pay periods
  638. Cell without its own format?
  639. Copy Data from Worksheet1 to Worksheet2 IF Worksheet1 Column D = Y
  640. link to web
  641. COPY DATA FROM ACCESS - PASTE IN EXCEL
  642. exel 2007 process
  643. IF formula using a range of values in a cell
  644. SUMIF with two conditions
  645. export information from excel to word doc template
  646. Cell coloring according to the other cell's value
  647. How do I add hours and minutes without 24 hour limit
  648. Dynamic Ranges
  649. What function tests for whole number (no decimals)?
  650. can i put in numbers and have the computer randomly draw 1?how?
  651. Monthly Change Using Nested IFs?
  652. Trying to do a Lookup
  653. Copying cells from one workbook to another
  654. VLOOKUP
  655. Inserting a picture or chart into one cell in Excel
  656. formula to reference cell on previous worksheet
  657. EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS
  658. Macro to Extract Template Data to New Worksheet
  659. Value of String used in Calculation?
  660. VLOOKUP WITH RANGES
  661. summing the same cell in multiple workbooks
  662. excel 2000 images
  663. Email one worksheet to email address on worksheet
  664. Cell names = sheet names
  665. Need HELP! Solve for mortgage interest rate with following variabl
  666. counting unique names - again
  667. Skipping Cells
  668. Save one worksheet as PDF?
  669. How do I find multiple text in diff cells in another worksheet?
  670. Commas in Excel textbox moves my sentence to the next row
  671. Wildcard Searches across Worksheets
  672. How do I set up a validation list?
  673. how do I do conditional formatting for absolute values?
  674. Fill Down Formulas
  675. FORMULAES
  676. Formula for counting more than one criteria
  677. How do I get full tab color?
  678. worksheet protection
  679. How to add 30 days to date in another column, including Sat/Sun?
  680. Min Year in an Array
  681. VLOOKUP - recover missing data source
  682. Referencing cells according to date
  683. Results table help please
  684. calculating working hours between 2 dates
  685. create two lines in one cell
  686. NezkopÃ*rujÃ* se vzorce v konting. tab. z jednoho seÅ¡itu do druhého
  687. Allocation formula
  688. How to calculate the total area under a curve in excel?
  689. Using "Non-Empty Cell"
  690. use sub-totals and average in same calculation
  691. change sign of a column of figures from + to -
  692. EOMONTH Formula
  693. Combining Hlookup and vlookup
  694. vlookup and match functions
  695. Using date format in the cells how determine percent complete
  696. Rectangle Box
  697. Sum cells
  698. Using pop up boxes to supply a variable within a macro
  699. Duplicate Numbers when using the Large Function.
  700. finding total from 2 seperate columns
  701. how do i autofill a cell a certain colour based on it's value?
  702. ALPHANUMERIC
  703. How do I calculate variance between numbers?
  704. auto sum from multiple worksheets
  705. Names with If function
  706. Postcode distances
  707. turning a string of cells into a work shift (eg. 9am-7pm)
  708. using a result of a formula to generate text in Excel 2003
  709. Creating Lists from attendies of a Conference
  710. how to check More than one criteria and get the value
  711. Average
  712. Name - relative reference doesn't calculate
  713. sumif and contains
  714. Work Week, Excel 2000 & 2003
  715. Finding matching values
  716. [Excel 2000] Saving to .csv
  717. Data validation lists help?
  718. Subtract Date Q
  719. If (M1>0,M1)
  720. Display of formula result
  721. How to copy variable data from 2 worksheets into a seperate 3rdworksheet
  722. Set Defaults in File Import of a Text File
  723. Seperate out rows to make a new page in a workbook
  724. "table of contents" senario
  725. Where no value, display "NA" - if statement?
  726. variable column
  727. IF function OK to use?
  728. Record entry by date
  729. validation
  730. Adding weight measures
  731. how do I interpolate numbers
  732. external refs and dropdown validation
  733. IF statement
  734. Calculating Dates
  735. Text to the left and right of a character
  736. Running macro depending on cell value
  737. If Statement
  738. Word & Excel - Nice question
  739. How do I locate a circular reference error?
  740. Offsetting and HLOOKUP
  741. sum cells that meet a specific condition
  742. copy data of two cells from Sheet 2 into one cell in Sheet 1
  743. Averageif function
  744. Is a Match ?
  745. Averaging
  746. Numerous criteria in sumproduct
  747. Statistical Calculation
  748. Assigning macro to toolbar - only works sometimes!
  749. Paramater driven value
  750. Paste value from a formula
  751. How to create a multi column lookup list?
  752. Pulling cell information from one workbook to another
  753. SUMIF or SUMIFS
  754. vlookup or index match function
  755. VLookup not working
  756. need help with IF
  757. finding multiple non-zero values in a column
  758. STEP MULTIPLY FUNCTION
  759. Same Worksheet, want to transfer information from one tab to anoth
  760. Stop baby eating in CHINA
  761. multiple subtraction from one field
  762. help
  763. >4.5
  764. Summarizing Date and Time
  765. Excel 2003 SQL-Query
  766. Count of a time range
  767. Determine Value of Cell?
  768. Converting hours, minutes, seconds, to hours
  769. Networkdays between columns
  770. Sumif range?
  771. How to copy formula with one cell constant
  772. comparing one to one cell within range
  773. change header for each worksheet
  774. Different comparison criteria in sumproduct
  775. when autofiltering a spreadsheet need to know number of records
  776. Crazy If
  777. interpolation
  778. lookup one value in list and return multiple results
  779. Please help on array search & result
  780. Before Save code
  781. Date value content format
  782. default format for remarks
  783. Telenet nieuwsgroepen mededeling: nieuwsserver adres aanpassen/Attention: modification de l'adresse du serveur de newsgroup
  784. LARGE 1, LARGE 2, LARGE 3, LARGE 4
  785. is TEXT function appropriate?
  786. Formula to record the date
  787. The right formula is?
  788. Absolute $ for a number
  789. Pivot Table Formatting
  790. avoid embedded if statements
  791. Automatic cell input on separate sheet
  792. Looking for certain months and summing the totals
  793. how to tighten up unwieldy formula
  794. multiple vlookups in one statement
  795. Data Validation error message
  796. Formula to point to another cell if an option is chosen.
  797. VBA Function
  798. Linkage problem between spreadsheets
  799. IF Function to enter background colour and border to a cell
  800. Convert minutes into hours
  801. vlookup and sorting and references.
  802. Adding workdays
  803. Function to populate cells??
  804. Assign period to date based on rules.
  805. chart from drop down list of ranges
  806. Multiple Scenario Condition Formula
  807. Multiple IF function (maybe OR)
  808. Updating columns in worksheet based on values from another worksh.
  809. update excel
  810. SUMPRODUCT problem
  811. VLOOKUP WITH 2 CRITERIAS...
  812. is blank AND is error
  813. Lookup function
  814. Can we create a viewport in Excel like Autocad?
  815. Condl formtng of range of cells based on one value
  816. Am trying to autofill a formula and it will not increment down?
  817. compare data from two tables with varying record numbers
  818. Run time error '1004'
  819. SUMIF question
  820. Compare 1st 8 digits of rows in three worksheets
  821. why can't I change the date with find and replace in this formula
  822. Duplicate entries in more than one column
  823. AutoFilter does not include ascending or descending options
  824. Work Hours
  825. Search for value in a range
  826. Nesting sumif functions
  827. Importing from Access
  828. Combo Box
  829. need help with lookup formula
  830. Countif Function Using "AND"
  831. if zero, then return blank/empty
  832. Valided alphanumeric value
  833. How to open Chinese text input task bar.
  834. Green arrow in cells
  835. Problem using Import External Data
  836. Conditional Lookup
  837. Dates on a worksheet
  838. selecting specific rows with a algorithym!?
  839. How to enable Macro automatically
  840. calculating time difference
  841. Trying to transfer info from one worksheet to another
  842. A formula to AVERAGE IF but only average a set number of values
  843. How to count array with OR condition
  844. Pivot Table vanishes when refreshed
  845. how to match data
  846. Sumproduct across worksheets
  847. VBA Help
  848. Macro to close workbook with prompt
  849. VLOOKUP
  850. How can I concatenate text with leading zeros
  851. How do I show what the percentage is of one figure to another?
  852. Counting dates in columns in a linked spreadsheet
  853. Linking data from multiple spreadsheets into one
  854. Multiple data forms in a column
  855. When Using VLOOKUP With MATCH How Do I Handle #NA OnData Retrieval?
  856. macros
  857. When Using VLOOKUP With MATCH How Do I Handle #NA OnData Retrieval?
  858. When Using VLOOKUP With MATCH How Do I Handle #NA OnData Retrieval
  859. When Using VLOOKUP With MATCH How Do I Handle #NA OnData Retrieval
  860. How to vlookup and bring over fill colors as along with the data
  861. Referencing a series of cells
  862. SumIF to summarize amount in different sheets by date
  863. Help me write a conditional formula - please!
  864. Subtracting Time using mm:ss.00 format
  865. Combining Data from several different workbooks into a master work
  866. Excel to pull data from web
  867. How to find next value in upper row?
  868. look up formula
  869. Using Trim with wildcards possible?
  870. How do I extract the numerical value of '325.00' to next column
  871. saving as an add-in?
  872. showing an empty cell instead of a zero in a formulated cell.
  873. Nesting Address function in Offset without Quotes???
  874. Need to seperate
  875. searching for just the month
  876. Combining VLOOKUPS?
  877. Tab in a Tab?
  878. index and offset functions
  879. organizing data imported via xml
  880. Vlookup that checks against two values
  881. Can this be done«?
  882. HOW DO I CALCULATE THE NUMBER OF RESULTS FROM AN ENTIRE ROW
  883. Invest smart
  884. Trailing 3 month sales
  885. excel sorunu
  886. displaying text in a cell if a another cell falls in a range
  887. remove #NA from index match formula.
  888. Sumproduct
  889. Count Dates?
  890. IF formula
  891. INDIRECT function to reference values in another worksheet
  892. I need ur help urgently
  893. Text fraction to fraction format
  894. Moving from range to range
  895. NETWORKDAYS() saved as =#N/A in XL2007
  896. nesting formulas
  897. formula question
  898. CTRL+select Excel 2007
  899. sums with several conditions
  900. Help with this formula
  901. Compare dates with lag
  902. find combination of cells that equal a sum
  903. if x then autofill a color
  904. E-mailing Master Summary only in
  905. Lookup I think
  906. E-mailing Master Summary only
  907. Delete part of a cell
  908. Drop Down with Range names
  909. COUNTA counting formulas as well.
  910. Is there a formula to round a number to the nearest .09?
  911. Calculating the number of minutes between days
  912. Date comparison
  913. Creating Spreadsheet that pull Names that have a pop. of 10+
  914. Index Problem
  915. VLOOKUP with IF
  916. data format
  917. excel 2007
  918. Function IF statement
  919. One change makes many changes
  920. addup up a dynamic range of numbers in a column
  921. Growth Trend
  922. Excel Bugs
  923. Blinking Text
  924. Opening an EXCEL 2003 file in VISTA
  925. how do I get excel to add,then average numbers with two decimals?
  926. Formula
  927. Invest smart
  928. help with subtracting time excluding weekends and non-working hour
  929. Cannot copy the merge cells
  930. Need help with Excel 2000 text-related functions
  931. "A+" convert to "4," "A-" to "3.7" etc...
  932. Sort columns
  933. How do I stop mouse from automatically selecting multiple cells
  934. Understanding SUMPRODUCT()
  935. adding up vlookup values in one column and in between them
  936. How do I add "accrued vacation days" column to the Employee Attend
  937. Formula compaction
  938. named ranges
  939. split cells with each having a formula possible?
  940. Re: split cells with each having a formula possible?
  941. sumif
  942. how do we get gaussian distributuion parameters of a sequence
  943. using two functions in the same cell
  944. 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
  945. table formula
  946. sum year to date totals for particular month
  947. Advanced filter
  948. VLOOKUP problem (N/V)
  949. Problem with Data Validation
  950. Multiple if functions with sum
  951. Conditional Validation
  952. Time series calculation
  953. Excel Function
  954. Adding formulas across Worksheets
  955. IF Statement Help
  956. Using cell content as reference in formula
  957. how do I get cells to automaticly change colour on data input?
  958. Adding number within a cell
  959. counting data in columns with linked cells
  960. Changing number in cell when printing
  961. ISNA with VLOOKUP against 2 locations
  962. Conditional
  963. How can I SUM all values in a column where the rows...
  964. Macro question
  965. auto-filter image
  966. Help with a Lookup formula ?
  967. Use dynamic column reference without R1C1
  968. Pivot Table and Calulated Field
  969. Sum Cell Values of one column based on Another Cell Value in a different column
  970. Work days difference between 2 dates.
  971. Counting on two separate values
  972. Using formulas for survey
  973. custom addin gives #name? errors
  974. Time Calc > 24 hrs
  975. how do i use averageifs function?
  976. Moving Macros
  977. Using intermediate results in Worksheet functions
  978. Formula
  979. Sumproduct with Match and Vlookup?
  980. Copy from one named cell to another dependent on content of a third.
  981. Search/Lookup-Copy Help!
  982. Stock Market Calculation
  983. How to create a formula to calculate a sum of cells from a date ra
  984. named range in sum formula (indirect, offset, worksheet name)
  985. Embedded If Limitation
  986. Have problem in Manipulating Workbook Object and make macro shortest as possible
  987. synchronize 2 worksheets to preserve functions
  988. Countif
  989. Need to average clock times
  990. I want to compare old and new datasheets and highlight changes
  991. Marco Editing Help
  992. test
  993. date intervals calculation
  994. SUMIF Multiple Criteria in different ranges.
  995. Entry takes 1 min, Office 2007. Large sheet
  996. networkdays and holidays
  997. Locate negative number
  998. Easy Input
  999. Link Password Protected Worksheets to Master
  1000. Less than or equal to
Google