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. If statement
  2. Parameter "TwoDimension" on RowVector function
  3. Restricting entry
  4. Listing only the workdays of a month
  5. Lookup functions-V lookup
  6. CONCATENATE FUNCTION
  7. Conditional Format based on Month of Date in Cell
  8. transform formula
  9. Calculating the number of entries between 2 times
  10. If date in range is before today
  11. Count if equal to first non error cell
  12. count if equals first non error cell
  13. Same Date a year ago
  14. Same cell but different worksheet
  15. VLookup with multi-condition
  16. Excel Converson
  17. array frequency data search
  18. freeze pane option not available
  19. count the presence of a date as 1
  20. AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK
  21. Trying To Put IFs into a Function
  22. How can I add the new record from another list to current one?
  23. Automatic Sorting?
  24. get an average of 3 cells, if they all have numbers, in excel.
  25. FORMULA FOR CALCULATING MIN MAX INVENTORY LEVELS
  26. Editing time that has its colon removed
  27. hyperlinking email addresses
  28. auto sum
  29. formula for local time and GMT?
  30. 6 Day working week (friday holiday)
  31. FYI: MSDG not displaying posts; expects duplicates :-(
  32. any method of keyboard remapping?
  33. How do I keep the "today()" function from updating
  34. Can I increase the view of a drop down list beyond 8 in Excel?
  35. SIMPLE CONCATENATE FUNCTION
  36. Fill Handle
  37. How To Protect Sheet For SHIV
  38. howcanprotectmysheet
  39. Array - conditionally sum the 1st occurence in non-contiguous rang
  40. Vertical page breaks - one per column
  41. Eliminating cells with a zero
  42. Excel 2007: Vlookup - Results without #N/A
  43. linking to formula template on different tab
  44. SumProduct not right
  45. Excel 2007: Vlookup Problem
  46. calculating a minimum fee
  47. If Then Help
  48. Remapping keyboard on Excel
  49. @which function to use when
  50. Arranging words in a column in dictionary wise order
  51. Need a formula
  52. If >0, count various codes in a range on another sheet
  53. Two types of Data Validation in a cell?
  54. Copy contents of a cell into a blank cell
  55. Creating a Formula in Excel
  56. Data extract
  57. Copy contents of one cell into another if cell is blank
  58. How to return a range of values in a drop-down.
  59. Formulas & Dates not working in .xls file
  60. Nested Conditional Functions
  61. copy between workbooks
  62. Help with colour formula
  63. Cross Referencing
  64. Inserting symbol
  65. attach files
  66. trouble copying a cell from one workbook to a new one
  67. Refresh - F2
  68. Need to create rows from columns
  69. How can I automatically color a row based on cell content
  70. Excel - IF formula with range of cells
  71. Lookup or an alternative
  72. Vlookup not working to merge workbooks?
  73. I want to copy the same image into worksheet with a function
  74. Importing Access DB into Excel changes my calculated fields in Exc
  75. Auto Calculate Question / HELP!
  76. How to average values based on time period
  77. New Drop-Down Functionality in 2007?
  78. Hide/lock worksheets
  79. contitional formating with more then three options
  80. calculate date of birth with an end date and age
  81. lookup over several columns
  82. count text occurance in range
  83. number times a value appears in a column beside it chronological
  84. countif using other cell values for 'range' and 'criteria'
  85. convert numbers
  86. How can you attach an e-mail into an excel worksheet?
  87. Lookup cell for documents in a folder
  88. Hide Raws even the Auto Filter is active
  89. Custom Format Cell with Reference to another sheet
  90. How can I number rows based on unique values in another column?
  91. Locking comments
  92. Multiple Users - Different PC/Locations
  93. Indirect function
  94. fomula required
  95. subtracting 28 days from a date
  96. text fragment comparison
  97. Dynamic chart
  98. Fill color
  99. Variance Analysis and Excel
  100. my formated column is displaying one cell incorrectly
  101. Excel Formula and Variance Analysis
  102. Search for Employee Names
  103. Need help with formula to weed out duplicates
  104. Create a button to insert a new row.
  105. random integer with sum constraint
  106. Can I show a number like 1,935,674,923 as 1.9B?
  107. Concatenate including a date so that the date appears as a date
  108. dates in VLOOKUP
  109. print area Excel 2007
  110. matching data in 2 worksheets
  111. Decision tree
  112. Consolidating Redundant Text
  113. Count based on date criteria
  114. drag a formula downa column keeping one value the same?
  115. Calculating a date
  116. Extracting text from right to left using MID and FIND
  117. Extracting Text From Right To Left - MID & FIND
  118. Extracting Text From Right To Left - MID & FIND
  119. how do i create a divisible formula
  120. ISERROR function
  121. Match values in more than one column
  122. VLOOKUP/HLOOKUP Query
  123. Display result depending on value entered
  124. Working with time calculations
  125. Traspose Column data into Row
  126. Excel worksheets won't all print
  127. How can I lookup when match has more than one value?
  128. sumif wildcard criteria
  129. Linking data from the Internet
  130. sumif wildcard criteria
  131. Date to Day
  132. Creating dynamic ranges which are named.
  133. Logical Test: Text Against Number
  134. how do I copy only visble cells in office10
  135. Date formulas
  136. How to use the search in an if statement
  137. Lookup Text and Receive Other Text in Return
  138. Help with Formatting Number as Text
  139. Problems with ngs
  140. Help Formating Numbers to Text
  141. rolling 12 month date filter for pivot table?
  142. Formatting Numbes to Text
  143. Modify Formula
  144. Formatting Numbers as Text!!!
  145. Formatting Numbes as Text!!!!
  146. Need help comparing 2 columns of number to find unique numbers
  147. Excel Worksheet does not save
  148. Count cells
  149. help with sumproduct
  150. Carriage return in same cell without using alt-enter
  151. Countifs function equivalent for Excel 2002 (XP)
  152. Lookup Values, return multiple.
  153. Matching and combining information on two separate worksheets
  154. If - Then question
  155. Check Box Question
  156. Lookup one value, return multiple values,
  157. Time Sheet Summary
  158. Error: Value in Formula of wrong data type
  159. sumproduct
  160. Modify a Formula
  161. Checking data in 2 columns against a further 2 columns....
  162. use Find without hardcoded value but a value from a cell
  163. Is 4th January 2010 = Week 2??
  164. validation controls in excel
  165. IF & VLOOKUP
  166. Excel changing date format after VB has run
  167. Sending data to tabs
  168. Using "Verifiers"
  169. when setting a cell to equal a blank cell it displays 0
  170. Generating random numbers
  171. Tick mark
  172. looking for a function that hopefully exist
  173. Copy from worksheet 1 to worksheet 2, 3 , 4 etc..
  174. count unique values with auto-filter on
  175. cell formattiing
  176. Paste Special/Format
  177. Problem with a Array formula, Please help !!
  178. Help
  179. Pivot table for worksheet text fields?
  180. Autofill problem in Excel Office 2007 using Windows 7
  181. non-numeric in a calculation
  182. This should not be so difficult but it is to me re: dates for medi
  183. formula help - subtracting numbers in two colums but using a specificnumber if one column is greater than another
  184. Creating a duplicate workbook without values
  185. Weekly Time Sheet Summary
  186. calc. an anniversary date(50 years) after marriage date in excel
  187. Weekly Time Sheet Consolidate
  188. How do I get a macro to be non worksheet specific?
  189. CHANGE TEXT DATE TO NUMERIC DATE
  190. Converting hour/minutes to hours/hundredths
  191. Timetable problem
  192. Lookup and return next value
  193. clueless where to start.
  194. Lookup problem Excel capabilities
  195. Statistical question
  196. matching and entering data
  197. Is there a simple formula to convert time in hundredths to minute
  198. How do I tally numbers, of a specific expense category?
  199. Look up if a value from an array "A" is in either array "B" or "C"
  200. Summing and Averages with non-numeric cells
  201. Focus On Open - Goto
  202. Formula returning an error
  203. First non-blank row in WS after hyperlinking
  204. change default table style
  205. Cell update delay
  206. blank cell instead of x
  207. How do I extract the decimal places from a number in excel?
  208. bsval
  209. Exclude Weekends
  210. Incrementing Part of an Address
  211. No of Days between two dates and offset formula
  212. Pivot Table (behind the scene)
  213. A macro for deleting lines of text
  214. issue with IF and text
  215. deleting numbers in a column
  216. Nested IF Statements
  217. FORMULA HELP
  218. Hyperlink text from linked workbook
  219. check box
  220. How to insert lines into a workbook without changing references?
  221. Excel Formula Help?
  222. Linking computer dates (time) to spreadsheet dates that have formu
  223. Xindex
  224. Help with a predictive analytic
  225. I'm unable to change font size on a excell sheet
  226. Why do I get #### when I Autosum in Excel?
  227. Multiple Values
  228. How to make different cells fill in automatically from one entry?
  229. Lookup one value, Return matching correspnding values
  230. Real time function
  231. need help with creating a formula which checks more than 40 cells
  232. nested ifs
  233. Excel - count if a number falls within an array in a column & add
  234. EXCEL07 CELL FORMULAS WILL NOT COMPUTE TO A VALUE
  235. scoring multiple ski meets from one master list
  236. Excel 2007 / right-click / pick from drop down list
  237. sumproduct including previous years
  238. Why messages fail to appear on MSNews server
  239. Break Calculation
  240. Need Help with Percentrank formula
  241. Using INDIRECT within functions
  242. CONCATENATE text to create a formula to be evaluated
  243. graphic in excel based upon result
  244. How to count the maximum number of consecutives?
  245. Office 2010 beta exel
  246. Totalling seperate cells from a HLOOKUP function
  247. one cell in a row contains a number
  248. Smallest to Largest
  249. Can I find the last value in a column of cells?
  250. Fill date series in table
  251. Round Up and Round Down Time
  252. How do I set up inverse Gaussian error function in Excel?
  253. Calling name of Sheet as a Variable?
  254. #NAME? Error With User Defined Functions
  255. how do i retrieve the largest value from several records/rows in e
  256. Excel Question - Last Twelve Month Calculation
  257. Can a macro be paused to allow input, then continue?
  258. Logical Test: Text Against Number
  259. Statistical Analysis: Pass/Fail Correlation
  260. Exclude Hidden Row Values
  261. SUM and Frequency for Multiple SHeets
  262. IF Statement Help - Not seeing whole cell
  263. Unusual VLookup in 2007
  264. How to use numeric keypad in 7 Excel-(raw beginner)
  265. Create sublist in new worksheet
  266. How do I print a one page spreadsheet multiple time, each with i.
  267. Changing Cell Color Based on Value
  268. Sum Products with VLOOKUP
  269. inserting a picture into unprotected cells in a protected excelworksheet
  270. Amortization schedule with veriable payments
  271. Timesheet formula problem
  272. I need help matching spreadsheets
  273. Comment with date stamp, again
  274. Using names referencing a cell in another workbook
  275. Protect Sheet - But have button to add more lines
  276. Quicker calculations -- storing huge equations or cutting and past
  277. I am repeating the same procedure and cpt codes
  278. Multiple row comparison to sum potentially multiple values.
  279. Conditional formatting based on format in a different cell
  280. Table question
  281. UDF Function
  282. adding numbers in a column with dates
  283. SUM cells in column based upon criteria in two others.
  284. Sort unique data from a colum
  285. Tricky Macro Question
  286. Averageif year=2000
  287. Using ISNA on more than one column within an If Function
  288. Add one
  289. Format date
  290. Total a column contingent upon the cell to the right being non-bla
  291. a if calculation help
  292. Good example of the use of Vlookup
  293. HOW DO I TURN MY UNDO REDO FUNCTIONS BACK ON IN MICROSOFT EXCEL
  294. concatenate within an excel formula
  295. How to paste data to alternating cells down a column?
  296. Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell)
  297. Need Help
  298. Autosum returns zero balance - why?
  299. Countif Formula
  300. COUNTIF?
  301. offset formula
  302. SUMIF with criteria being a specific cell
  303. sum of mutiple entries on another workbook
  304. Formatting cells to show two dates in one cell
  305. Product Formula
  306. Printing Dates on One Sheet
  307. Auto calculating not working
  308. Forms--Vista--2007 Excel
  309. Separating data
  310. Error with Copy function
  311. formula for excel sheet.
  312. In Excel can sheet tabs be placed along a side margin?
  313. hello please help i really should have payed more attention in class
  314. Variable Pay-rate after 5pm
  315. extracting quarterly data and having it update daily
  316. Auto filter custom filter
  317. financial function default format
  318. change column to rows with a match
  319. Extracting Data with in Brackets [ ...... ]
  320. Two Calculations in one column
  321. Count Consecutive string of same number
  322. subtracting ranges
  323. Trouble adding timesheet formulas
  324. -/+ forumla
  325. Help converting a 10 digit number 2223334444 to 222-333-4444
  326. How do I Modify Julian calendar restriction of 1900
  327. HowCanIselectAtextBoxIf theExcelFileIs saved in (group) format?
  328. Vlookup
  329. excel formula
  330. Remove holidays from calculation
  331. once only pop up
  332. draw smaller boxes within designated cells for checkmarks
  333. excel 2003 allowed addition of cell color anywhere on the page?
  334. Which Function(s) should I use?
  335. Init Caps
  336. Remove Duplicate with 'Caveat'
  337. Can I Rotate with a Condition -or- Can I Display Graphics with aFormula
  338. S- Curve Calculation and chart
  339. N/A Error with VLOOKUP Formula - Excel 2007
  340. Min Match Function needed
  341. Need Help with Excel and Flagging Outcomes!
  342. Calculating Elapsed Time Over a Set Period
  343. Alternate row comparison
  344. Offset, sum down to the first blank row
  345. Literal based on Week end
  346. SERIES function disappear
  347. Excel 2007 AutoSaves
  348. Find and replace for cells with certain number of characters.
  349. Strip Flat File Table into less entries
  350. XMAS
  351. repeat code remove
  352. Reverse Text in Cell before and after comma (not just Word1, Word2
  353. adding every third column
  354. Multiple If Function
  355. vlookup help linking data between worksheet
  356. COUNTIF
  357. adding every other column
  358. Margins within a worksheet
  359. remove columns which show "0" as sum
  360. Search box for text
  361. Sorting a protected set of cells
  362. drawing org charts
  363. VLOOK with Index - How to get results across instead of down?
  364. Counting number of worksheets in a Excel 2007
  365. help with datedif function please
  366. Getting data from 2 differant colums
  367. Index Function Problem
  368. IRR
  369. Create a chart of totals over time?
  370. On Calculate question
  371. Sorting the first text in a row
  372. V-lookup and Countif
  373. Condtional Formatting - Inserting Rows
  374. Duplication of Counts
  375. Using Dependents - what does the small "Table" symbol mean?
  376. Sum of yes answers
  377. Sumproduct usage?
  378. Totaling Volume within a range of dates
  379. CHAR(10) does not create new line in excel 2007
  380. counta formula that doesn't count duplicates
  381. Question about a Formula
  382. Removing protections that prevent me from editing formulas.
  383. If statements??
  384. Restoring Gridlines
  385. Single Weekly Time Sheet
  386. adding ever other column
  387. Text search and "Go To"...
  388. convert repeated sheet 1 names to once in sheet2
  389. OFFSET
  390. How to assign unique number to column duplicates?
  391. convert vertical to horizontal
  392. Trim and Substitute not working
  393. numbertowords
  394. Formula For Sorting Part Numbers
  395. Sumif or sumproduct with multiple & difficult criteria
  396. Complex 2 table formula
  397. Format Cells Dialog Box Missing
  398. How to sort data from one worksheet into other worksheets?
  399. Row position of specified column and value
  400. Add AVERAGE column to Pivot Table
  401. Adding values with like information
  402. Help with complex formula
  403. how do I get a function formula cell to format as a number?
  404. comparing two worksheets
  405. comparing columns in two spreadsheets
  406. Can anyone answer this question?
  407. Change "FALSE" to "NO DATA"
  408. World Cup 2010 spreadsheet
  409. Cannot open text workbook
  410. conditional formating: ifs and highlighting rows
  411. VLOOKUP Returning a copy of a cell
  412. VLookUp and DropDown List in the same cell
  413. isblank
  414. changing cell value makes the formula plain text
  415. Have Excel Enter Decimal Place
  416. SUMIF/COUNTIF with missing data
  417. How can i join these two formulas?
  418. Any way to test whether rows are empty or contain the word Pass ?
  419. Conditional formating a cell containing a date
  420. Cell References
  421. All CAPS to Caps
  422. urgent...convert sum into max
  423. prevent cell overwriting
  424. formula to add number comined with text
  425. convert unix epoch seconds to yyyy:mm:dd in excel
  426. FUNCTION THAT SEARCHES DATA AND RETURNS INFO ON A DIFFERENT WORKSH
  427. Match (1 of 3 cell values) in a range?
  428. combine text & date formula to show mmmm dd, yyyy?
  429. Date and Formatting
  430. MSN Stock Quotes not working
  431. Goto Cell With Today's Or Other Date
  432. Finding second-to-last workday of month
  433. Variable Value Function Help?
  434. extract last 2 characters from the right?
  435. Changing contents of cell based on Cell Format
  436. Difficult function question for columns
  437. is 3rd character in a cell a space?
  438. What formula to use?
  439. Changing my functions to use subtotals?
  440. Test to see if cell contains a space?
  441. Comment with date stamp
  442. APR Fee Calculation
  443. How do I generate randum numbers between zero and .495
  444. combination IF- and VLOOKUP-function fails
  445. SUMIF start/stop
  446. Simple totals
  447. copy column to another file
  448. I Need Help With A Complex Formula
  449. Count/Sum rows of a column depending on criteria from drop-down li
  450. Link 2 files
  451. Return data from catagory
  452. Adding time
  453. Calculate How Long Funds Will Last
  454. Replacing multiple instances of character
  455. Count cells based upon criteria in other cells
  456. For you high bandwidth folks to download and evaluate...
  457. conditional formatting
  458. keep the title fixed while scrolling
  459. conditional formatting
  460. Ctrl+C
  461. #Div/0 error, can't get rid of it
  462. Reference to cell with external spreadsheet
  463. How can I stop the end user License agreement from popping up
  464. Date Conditional Formatting
  465. Tough Question
  466. Case Sensitive Counting & Filtering
  467. Arrange to present in continuous format
  468. Find the cell content
  469. evnet code, checking for entry
  470. application.goto
  471. Seperate info in a cell
  472. #VALUE! in cell
  473. Display excel formula values
  474. Select multiple adjacent cells of multiple cells without selecting
  475. Return a range based on a variable
  476. FInd common data in one column then add number in adjacent column
  477. consolidating data by date
  478. copy value calendar control
  479. Find and Return the Non-Blank entry
  480. dependent drop down list
  481. Pivot Table GETPIVOTDATA
  482. Calculating gross when net is known
  483. is there an integration function in excell?
  484. i have a file with 50 worksheets, how can I print these names
  485. if formula for time sheet. - help
  486. Slow file with INDIRECT.EXT
  487. Preventing hyperlinks and vlookups from breaking
  488. Data in columns convert to single line
  489. Return value based on certain criteria
  490. Using Macro how to create email link for the email addresses in aRange or Selection
  491. Search Ranked items
  492. Mode Function combined with a filter
  493. What is hubscore?
  494. Average cyclic error
  495. HIKE %
  496. Conditiona format based on format of another cell
  497. Deleting rows
  498. macro to disallow shading in certain columns
  499. Data Validation Question
  500. Compare my list to an existing list
  501. selecting every other data point in a column
  502. .numberformat Q
  503. Separate first name, middle name and last name
  504. Counting while diminishing
  505. Extract portion of cell contents
  506. combining data from multiple worksheets into one
  507. How to use SumProduct to count reference or something else?
  508. counting the number of consecutive days 12-17-09
  509. List of All Workbook's Worksheets
  510. LOOKUP across a whole table and not just first row or column
  511. How do I add an integer to an existing integer?
  512. weight loss
  513. Excel Protect Function, while allowing macros
  514. I want to save a copy of a wksht. but without any of the formulas
  515. Column
  516. Averaging data across a date range
  517. Complex Lookup Question
  518. % in Pivot Tables
  519. Count number of dates between a specified period of time
  520. Decimal
  521. And function into If function
  522. Conditions
  523. DSUM with dates
  524. vlookup
  525. match dates in two columns get value from third
  526. Q on LARGE function
  527. How can I do this ??
  528. Formula mismatch in Excel 2003 & 2007
  529. How do I insert a check box in Excel Vista? I'm a novice
  530. Excel 2010 to be able to embed like Google Apps?
  531. NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT
  532. Formula Problem
  533. Subtotals in Excel 2007 TABLES
  534. Excel VLOOKUP hyperlink to mailto function on different worksheet
  535. autofill down won't work!!!!
  536. Simple Question Complicated Formula
  537. Pivot Table Layout
  538. Dynamic Range Defined by Value of Cell
  539. Conditional Formatting
  540. excel scheduling
  541. References
  542. Calculating length of time with conditions
  543. 'developer reference' help window font size...
  544. Concatenate By Selection
  545. Expand/Collapse in Pivot Tables
  546. copy dates, events and times into a montly calendar
  547. Comparing fields in an excel worksheet
  548. Place Date in One column when entry is made in another column.
  549. Help with determining instructor class location.
  550. calculate shipping costs in excel 2007
  551. conditional formatting and coloring cells.
  552. How do I delete excess pages from a file?
  553. Condense a formula
  554. COUNTIF Non Contiguous Cells Q
  555. If Statement ? Seperate cost over years of project
  556. multiple range in SUM,IF
  557. CONCATENATE TWO COLUMNS
  558. Display date in spanish
  559. counting the number of occurences
  560. Copy data from one workbook to another
  561. I cannot highlight a whole row or column
  562. weekday in pivot table
  563. Formula Needed for Corresponding Blank Cell
  564. Look up Data by Row criteria and column criteria
  565. Replacing spaces with data from another cell
  566. AVERAGEIF in pivot tables
  567. Conditional format question
  568. look up, match index? multi variable formulas
  569. Dsum excluding blanks
  570. Show formula result in another sheet
  571. Concatenate Cells
  572. How to put back ZIGMA icon on the toolbar?
  573. Sorting a text strings but omitting preceding "A" or "The"
  574. Count occurences of same zip codes
  575. vlookup backward
  576. SUMIF date criteria
  577. calculation taking too long
  578. Pivot Tables - get a total different than the summarize field sett
  579. how do a create a lookup using first and last name
  580. If or conditional formatting?
  581. Dynamic range
  582. Combining spreadsheets
  583. BIN2DEC conversion for large binary numbers
  584. How do I prevent duplicate entry of a sku in a data table?
  585. Why the minus result
  586. IF Function and Concatenation
  587. Worksheet several pages, Want name to show up on each page
  588. conditional formatting problem
  589. Array Formula + Indirect Reference
  590. Countifs with "or" embedded?
  591. IF formula
  592. proper formula or function
  593. sum cells to reach a specific value and return corresponding value
  594. Click "Yes"
  595. Macros will not run with shortcut keys
  596. help with dynamic tables
  597. Update tab function
  598. COUNTIFS AND CRITERIA
  599. Parsing data within parentheses
  600. if function
  601. If then Statements in Excel
  602. Percentiles in Excel
  603. excluding column headers from formulas
  604. Multiple Formulas
  605. summing results of multiple vloopups
  606. Assign Macro to a Cell
  607. Dropdown lists using each value only once
  608. Excel 2003 calculation sequence
  609. Append values and remove text
  610. calculating longest winning/losing streak and totals
  611. format a range dependant on another cell
  612. Driving an address
  613. Vlookup Change in Reference Cell
  614. Cell referencing
  615. First Day of the Month
  616. 2 Macros 1 Buttom
  617. create defined name using variable file name in reference
  618. countif(Range,criteria) question
  619. DashBoard Summary to contol output
  620. Logical value in time formula?
  621. How to format cell to get first capital letter?
  622. trying to get sheet 1 to recognize and move student names to pg 2
  623. Tab key problem in Microsoft Office Excel 2003
  624. Name Scope
  625. Adding or to previously provided Average If Array function
  626. Subtotaling
  627. split one column to multiple columns
  628. Named Range that uses "relative" range - Possible?
  629. Nesting if functions
  630. Keeping links Static
  631. Array
  632. Excel
  633. Formatting a formula
  634. Printing Only Rows With Values In Them
  635. complex formula
  636. descending order of a series of data
  637. Formula Based on Multiple Sheets
  638. Count non-hidden rows
  639. Conversions in Exel
  640. Countdiff with more criteria
  641. A complex formula, help needed
  642. function help for counting text as a value....
  643. Count if function
  644. Termination within number of days
  645. how do I make "NOW" function static
  646. Print Range not connected
  647. how do I highlight rows based on conditional formatting
  648. CONVERT(number,from_unit,to_unit)
  649. How to get rid of #Value when multiplying
  650. Formula, Pivot Table, ??? Beats me
  651. Print just the list after performing a "find all" in Excel
  652. shared workbook issue
  653. Subtotal level buttons
  654. VLOOKUP over three spreadsheets
  655. Macro for multiple rows
  656. Question About Date Function
  657. Settign a Maximum and Minimum Row Height
  658. Formula to return data using hyperlink?
  659. table lookup
  660. Check for NON-presence of a string in another string
  661. Can conditional formatting be used where .....
  662. Search cell value in more than one workbook
  663. remove duplicates except blanks
  664. Extract Supplier Name
  665. Text function
  666. Subtotaling
  667. LOOKUP value in a table and return value in first column of same r
  668. Subtraction Function using cells with other functions in them
  669. SUM A SINGLE TEXT FROM CELLS INTO ONE
  670. Pop-up box
  671. vlookup based on a different cell
  672. MedianIf multiple range and criteria
  673. Vlookup with part match
  674. how do i resize column letters in excel 2007
  675. Getpivotdata....showing filter
  676. Monthly files
  677. Unstring in excel
  678. Find & replace window
  679. Return Names From List
  680. How do I convert dd/mm/yy date format to yyddd Julian date format
  681. Boolean Math
  682. Counting only displayed cells in the column
  683. Data Lost in Microsoft Query
  684. Lookup value off by one row
  685. Returning A Minimum Figure
  686. Sumproduct with conditions
  687. 3 tier incentive matrix w/ infinite possibilities
  688. Vlookup return Zero if not there
  689. Adding if to Average If Array function
  690. Formula to equal a maximum of 100%
  691. Date Format
  692. Opening Files - Macro
  693. Distribution
  694. Spredsheet problem
  695. IF/VLOOKUP between multiple worksheets
  696. sum only if a certain cell contains a date
  697. Find variable unique text within a string
  698. Excel Formulas
  699. "Alert" only if 'not contained in'
  700. Data lost
  701. calculating subtotals for sequential blank cells in 1 column
  702. using button to clear contents
  703. Microsoft Querry
  704. Help with difficult formula requirement
  705. Changing number to mins/seconds
  706. RE: Changing number to mins/seconds
  707. COUNT
  708. Copy down formula macro
  709. Excel 2007
  710. adding/omitting/all the values prior to todays date
  711. Re: how do I copy format (eg colour of cells) in a drop down list
  712. Excel 2007 Won't Paste Formulas
  713. How do I create a combo box that is tied to another combo box?
  714. Multi-condition SUMIF
  715. MACRO - I think.
  716. Print Macro - PDF Issue
  717. Concatenate
  718. Comment with date stamp
  719. forecast a financial value at year end
  720. Conditional Formatting
  721. Subtotal function is greyed-out - can't insert
  722. Conditional Formatting
  723. Protecting Cells In A Worksheet
  724. Copy data ONLY from a function cell
  725. Excel 2007, pivot table format issue
  726. Sumif Deviation is positive
  727. Return nothing if criteria is not met
  728. pivot table - get the average of a field
  729. an I get a cell value throught posted hyperlink to another excel s
  730. Counting Individuals NOT Occurrences with than one criteria
  731. help needed to add values with conditions
  732. Modify to eliminate #NUM! error
  733. Excel conditional formatting
  734. & combine two array statements
  735. remove blanks using formula
  736. Formulas
  737. Automatic Record Transfer
  738. copy text with comma eliminated
  739. E2561412.CAB using a 2003 Excel in 2007 Excel
  740. If function using cell format as the condition
  741. My excel 2003 does not have engineering functions.
  742. Changing formating
  743. Turn on Automatic Formula Fill in Table
  744. Compare two files and update data from another file base on words ina cell separated by commas
  745. Build a sheet name in an Excel formula
  746. Lookup assistance needed
  747. addding/omitting "x"
  748. Excel function - countif
  749. Help with function
  750. Excel dates
  751. addding/omitting "x"
  752. Sum amounts based on date field
  753. Eliminating particular numbers from a column help!
  754. Is there a formula that can do this?
  755. How to use multiple lookups or if statements
  756. Countblank
  757. Look up a text value then count records < a date
  758. change date format dd/mm/yyyy to Julian date format?
  759. Using Roundup in an IF Statement
  760. Excel spreadsheet
  761. Summing a range within a range
  762. checkbox
  763. Help with Nested IF Statements
  764. Excel dynamic calendar
  765. Creating Average IF
  766. XL2002 SUM with a twist...
  767. Why did I use array formula - help
  768. How can print A Id badge From a Excell Work Sheet
  769. Icons on Customized Toolbar
  770. Look-up
  771. Coloured backgrounds using IF
  772. How do I display numbers as Degrees Centigrade?
  773. Counting Individuals not Occurrences in Excel 2007
  774. Leaving a total sum cell blank until other cells are filled
  775. Retain INDIRECT() Data
  776. How to delete all duplicate records - without keeping one of them
  777. Autotext Query in Excel 2007
  778. problem about count text
  779. How can i copy a 16 digit number to excel from another software(HT
  780. Ascending
  781. File Creation Date
  782. get a list of sequence number that meet 3 criteria
  783. INDEX and MATCH
  784. Macro functions in a protected sheet
  785. formula/version 2007
  786. Syschronizing cells across worksheets
  787. Emulating older pivot table "engine" in Excel 2007? Need help...
  788. Pivot table results error
  789. How do I save data in shared spreadsheet?
  790. lookup help
  791. Grouping sheets copies Header across to all sheets
  792. Calendar Text Box all the same
  793. CountIf in Even Rows only
  794. Function Help
  795. Change the name of an auto save
  796. Grouped sheets page formatting will copy the header
  797. Help with suming muliple columns
  798. Pivot Table Summary Error?
  799. Use RANDBETWEEN form & include certain #'s in the range
  800. Lookup Help
  801. Counting occurences with multiple entries
  802. Sheet Protection / Edit Objects
  803. IF function possible?
  804. Lookup Help... Again.
  805. calculated field in pivot - how to edit
  806. Excell protection
  807. Stripe out duplicate data
  808. File Path
  809. File Path
  810. LOOKUP HELP PLEASE
  811. formula in excel
  812. Date Format
  813. get a list of sequence number that meet 3 criteria
  814. File Path
  815. File Path
  816. COUNTIF with or + and variables
  817. Flip/Flop
  818. calculator creation, find missing value
  819. forecasting
  820. looking for a function for recurrence of a number in excell
  821. Can lookup do this?
  822. Search for matches in two columns
  823. Inserting text in column dependant on another column
  824. Excel 2003 + Solver
  825. Help with Lookup
  826. adding digits with moving decimals
  827. Average in a month/year
  828. Defind Dynamic named Range up to first error
  829. How do I get the last 7 characters of a no. to another column?
  830. Sorting on 2 values
  831. Probability help
  832. Stop Excel Changing Format
  833. File Path - Macro
  834. Which functions and Procedure to use to have desired result?
  835. Sort a coloum on one worksheet according to another coloumn on ano
  836. Sort one coloumn according to another coloumn on another worksheet
  837. Complex function needed?
  838. Turn off auto adjust of row heights
  839. Conditional Formatting within a Time Sheet
  840. Calculating text as values in a row
  841. Counting dates with specific criteria
  842. Populate Text based on conditions
  843. excel pivot trables
  844. Find data in two ranges
  845. Pivot Tables
  846. Need Help Fast! How to Calculate a sales percentage
  847. Colors according to the month
  848. Calculating current grade percentage
  849. HELP please... easy function
  850. Finding the 3 best values
  851. Row Colors
  852. Lookup Function Help
  853. Sheet Protection / Edit Objects
  854. command button to move data
  855. Need greater than = .. less than = combined with index/match state
  856. Formula to copy related information from sheet 1 to sheet 2
  857. Remove blank cells from data validation drop down box
  858. referencing multiple worksheets in macro
  859. Time question
  860. Complex day of the month calandar
  861. Read specific time in NOW() function
  862. macro will not run with shortcut keys
  863. Lookup Results Problems
  864. Combine sheets into one
  865. get back a deleted column in error in excel, please help
  866. Compare 2 columns and delete duplicate text
  867. IF statement inside a SUMIF statement.... or alternative method
  868. conditional formatting
  869. aging calendar days
  870. referencing text in an IF statement
  871. When do I use quotation marks in an Excel formula?
  872. Static current date based on when data in another column was enter
  873. Match and combine multiple rows into one
  874. Testing for an Integer result in a formula
  875. How do search a range to generate a value?
  876. Help with Formula in Excel 2003
  877. can you have sub parts relating to a line
  878. Showing 0 after decimal with ROUND
  879. Summing the last 200 days
  880. Excel file saved as txt with justified column numbers when viewed ina txt viewer
  881. Count
  882. a quick way of inserting and naming multiple worksheets in Excel?
  883. If Function
  884. Problem with AND function
  885. How to reverse an Excel formula?
  886. How to set a cell to expand to fit text in Excel not shrink fit
  887. VBA for document formatting - HELP.
  888. How to reference cell that changes locations.
  889. Excel 2007 - Change link source requiring multiple entry of passwo
  890. Calculation / Format Error
  891. Excel Rounding of Formular results
  892. show ink on an excel file.
  893. sum accross worksheets using names
  894. Using SUMIF with dates
  895. ??? can u put a word doc into a excel worksheet
  896. Is autofilter & sort disabled in protected cells?
  897. CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS
  898. Conditional formula with text
  899. using conditional formatting with dates
  900. more than 15 numbers in a cell?
  901. how to format a column to corespond with another
  902. I have a column of many many numbers how can i split them up auto
  903. Postive # converted to Negative #
  904. macros vba question
  905. Get part of field name for highest value
  906. Why are my numbers disappearing in excel yet it totals them?
  907. Have the need to sort text code-values within same Excel cell
  908. Function that meets table requirement then multiplies by table fac
  909. If formula with table look up
  910. How toEmail a spreadsheet and preserve the Data List format
  911. Extract names from string based on value list
  912. Excel spreadsheets
  913. Scroll Lock for selected multiple sheets
  914. How to edit text for check boxes
  915. Stripping out characters
  916. 2007 not auto update 2003 links
  917. Can I use the NOW() function in a formula?
  918. Complete Tax Years
  919. Counting calendar days
  920. How to make list of Items displayed in AutoFilter? Any Function?
  921. Hyperlink problems
  922. Pivot Table and External Data
  923. How do I retrieve data from 1 hour ago?
  924. Buy KING EDWARD CIGARILLOS Online
  925. Data validation dependant drop down on unsorted list
  926. how to attach file
  927. Return last and second last "populated" cell in column
  928. counting words
  929. Column header for Max value? Index/array function?
  930. Autofilter unavailable
  931. Copying formulas in Columns and transpose to rows?
  932. Distribution of a Value
  933. Use Formula from another worksheet
  934. Web Excel and Excel Functions
  935. Outlook CPM and Excel
  936. return value from range of worksheets
  937. Help with creating a formula
  938. COUNTIF or SUMIF question
  939. Changing the font of text in a check box
  940. Excel links in Word
  941. How can I make a cell red if number is not greater than needed?
  942. Format date with specific regional format
  943. Deifine range ignoring duplicates
  944. Count values once no matter how often they appear
  945. Sumproduct/match problem
  946. Average Function that ignores zeros
  947. Ignore duplicates
  948. Conditional Formatting with range
  949. Need help with formula!!!!
  950. Conditional formulas
  951. I have a column of 32 numbers,
  952. Macro to Clean Special characters for a Range
  953. SUMIF ERROR
  954. Return result when condition is met
  955. COUNTIF
  956. Why does the word REG change to Rag when typed into a cell?
  957. Choose best values in a list
  958. insert new row and copy formula
  959. Problem with Formulas changing to it's actual value
  960. Sum(indirect(Address......
  961. Data Comparison
  962. Weekly Returns
  963. trying to use Indirect function
  964. trying to use Indirect function
  965. IF Function
  966. consective numbering
  967. hyperlink not working in excel 2007, if worksheet is hide or hidden
  968. how to customize the x axis in scatter plot?
  969. copy data for match word from one file to another file
  970. Referencing column to row across worksheets
  971. Count based on string in cell
  972. Conditional format SUMPRODUCT
  973. Cut, copy & paste functions in Excel 2007 are extremely slow.
  974. CF to Color-Fill Row B:G w/Specific Text in One of the Cells
  975. Sum If formula
  976. I'd like to know how we can count coloured cells?
  977. Adding numerals with moving decimals
  978. Counting coloured cells?
  979. Notepad or .txt file to excel
  980. Count if or Sum Product
  981. if meets criteria add 1
  982. Macros
  983. SumIf Formula
  984. Can't Get Formula to work
  985. Count if or SumProduct
  986. Formula to calculate interest only on a short term loan?
  987. Import all txt files macro
  988. links in protected workbooks
  989. trying to remove phone: from the column = [phone: 4253331212]
  990. Embed a 'match' statement in sumproduct?
  991. Vlookup to the left ?
  992. Worksheet Filtering by UserName
  993. How to extract text from number/text cell
  994. EXCEL 2007 Formula to calculate INTEREST only on a 3 month bridge
  995. Formula
  996. Always show Jan of current year
  997. IF
  998. how do I use only 2 characters in a field in a formula
  999. Changing worksheet references
  1000. Row height