View Full Version : Microsoft 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 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133

  1. Lottery exercise
  2. I moved a file from work to home and now my color macro does not w
  3. IF this and IF that
  4. Error: Number of query values and destination fields are not the s
  5. Re: Restricting entry in B1 on the basis of entry in A1
  6. Keeping a cell value constant trhoughout a list of values
  7. checking that cells have a value before the workbook will close
  8. matrix calculations
  9. Interest Functions
  10. how do i set up a weighted factor model in excel?
  11. Re: Data>Validation>Input message
  12. Improvement Percentage Formula Help
  13. IF Formula
  14. changing values in speadsheet
  15. worksheets
  16. locate and change hidden lines
  17. Sum values in multiple sheets using Lookup to find a text match
  18. External Link Shows Formula Not Info
  19. The negative brackets in Excel 2002 version do not appear. Why?
  20. Is the Pivot Table the right tool to do?
  21. complicated sum formula question
  22. Lookup with multiple conditions
  23. Summation from a to b
  24. finding part of fole path
  25. Genetics with Excel: Determining ratios from Punnett Square Crosses
  26. Mail merge
  27. Constraints in Excel Solver
  28. converting a decimal number to hours and seconds
  29. input mask in excel sheet
  30. protecting the worksheet
  31. Recently used files
  32. input mask in excel
  33. Moving from worksheet to worksheet
  34. Re: Please HELP: Checking data
  35. Index function error
  36. can't remember password
  37. can't remember password
  38. Calculatin NPV for a range of numbers.
  39. solver problem
  40. Copy Paste Failure
  41. view fonts and size as you change them on the screen like corel
  42. printing on 3 x 5 cards
  43. concatenate in combination
  44. Array Calculation Error
  45. Question Please.
  46. Excel Project
  47. what is chidist and how to calculate it?
  48. Conditional Display
  49. how do i make excel do this a*b=c then add the c colum up
  50. how do I insert user name into a cell
  51. Advancing Down A List
  52. Appending Random Results?
  53. Countif with conditions
  54. Link and formula question
  55. empty cells
  56. Drop Down Lists
  57. automatic move row from sheet to another
  58. vlookup based on random result returns incorrect result
  59. how to get the middle name
  60. Date function/Text issue
  61. CountIf & null values problem
  62. how to get the middle name
  63. Combining 2 or more worksheets
  64. Calculate projected figure
  65. IF Function
  66. How do i analyse visible rows only in excel?
  67. lookup
  68. Tracking worksheet names in functions
  69. Locked spreadsheet, move cursor only to unlocked cells?
  70. Coloring rows in excel
  71. Arrays - Horizontal or Vertical
  72. Indirect formula using Data Validation List of Worksheet Tabs
  73. need enter key to move to the next column beginning
  74. Long Time Delay To Paste From UserForm To Sheet
  75. Combining Text and Date for VLOOKUP
  76. Concatenate in a formula
  77. Nested Formula help
  78. Pulling in Information from a worksheet
  79. Problem with pasting dates - year mysteriously changes
  80. Calculating a dollar value of the result between 2 different times
  81. count conditionally across two columns?
  82. SUMIF function?
  83. what is syntax for if(between range of dates,"Q1","Q2")?
  84. Australian currency question...
  85. Auto Filter Status Bar
  86. formatting time in excel
  87. Using "$" to reference same column in every row
  88. Modifying VLookUp
  89. RATIO number format
  90. Formula Color
  91. DSUM for date range
  92. Center text in dialog box
  93. emailing a single worksheet from a workbook
  94. Count Mondays worked in Month
  95. Time Calculations
  96. I want a formula to find age of person
  97. GetpivotData returns a #REF! error
  98. Tricky 'Find Maximum' problem seeks formula
  99. year function and financial years
  100. custom formatting??
  101. Today function is driving me nuts
  102. In Excel find characters when multiple characters exist w/i a cel
  103. Finding Cell Address for Use as Formula Argument
  104. Year row removal
  105. Random question / data selection
  106. If formula ?
  107. Custom Number Display
  108. Need 2 add second then third code with first code in the Tab View
  109. Sumproduct to ignore text and ""
  110. =cell("filename") in multiple places
  111. Comparing files and extracting info.
  112. Date/Time Function
  113. Relative standard deviation in Excel
  114. Creating a Pivot Table with data in more than one worksheet
  115. hidden element
  116. hidden element
  117. hidden element
  118. Using COUNTIF with visible rows only
  119. Re: Filter based on Pivot table
  120. Converting 24 hr clock to GMT
  121. how to protect excel worksheet and still use the outline buttons?
  122. Link the format of one cell to another's
  123. using the name of the worksheet as argument
  124. Calculation of hourly rate times hours times 1.5
  125. Count if date is between two dates and value in another column equ
  126. Sorting rows to a another sheet
  127. How can I see custom formula code?
  128. Duplicate Cells
  129. Deleting cells with repeated data
  130. Conditional Formating won't work
  131. Issue with zero/# issue!!
  132. Complex formula vs. simpler
  133. "MEDIANIF" Array combining two ranges
  134. Paste Special - Values - Transpose
  135. Datedif incorrect month count - February problem??
  136. Dynamic External Workbook Formula
  137. A one page per view year planner
  138. 3 values, show which ones are same
  139. Auto-Fill in List Fields?
  140. VBA error - End If without Block If
  141. cell reference?
  142. Function for generating monthly & weekly averages
  143. Linked cell displays 0
  144. formula for month that is prior to actual
  145. Complicated If Then / V Lookup / Match Statement...
  146. XML date formatting
  147. If Function containing VLook up
  148. Graphs
  149. vlookup returns list?
  150. Shortcut for referring to tab names in formulas
  151. Capture the Workbook Name
  152. Report by two categories.
  153. Rounding
  154. Index multiple cells
  155. How can I use the tab button after protecting the worksheet?
  156. Retry: VLOOKUP nested in IF Statement
  157. Can I do this with built in functions?
  158. basic sumif function help (urgent)
  159. Match more than 1 value
  160. Nesting-Don't use Blanks inside formula
  161. cannot use ISEVEN or ISODD functions in Conditional Formatting
  162. Maximum Drawdown Function
  163. Calculating days & time left from start date/time to end date/time
  164. How do I copy a worksheet's print parameters to other worksheets?
  165. 79% Doesn't like Me
  166. Counting dates for a the present month but not future months
  167. formula to look up a date and add x, y, z columns to x, y, z row
  168. sort by highlite color
  169. formula that includes a maximum amount
  170. Array issues
  171. How do I effeciently share text from two different sheets?
  172. Can I use a drop down list to navigate to other spreadsheets
  173. stopping code from looping
  174. How can I make a range "dynamic"?
  175. Hyperlinks to .pdf files
  176. =COUNTIF across Worksheets
  177. protect specific cell but allow edit on other cell
  178. federal tax tables
  179. Formual to Lookup and Transpose
  180. convert negative numbers to positive numbers and vice versa
  181. Re: Investment FV
  182. HOW TO REVERSE THE ROW OR COLUMN HEADINGS
  183. if fuction
  184. Rows & Columns in Excel
  185. RE: Investment FV
  186. An FAQ that never seems to be answered: autofiltering with protection on...
  187. Re: Maybe I need help with Lookups??
  188. Limited byrows propagate a value via macro to all cells in column
  189. Complicated question...
  190. Updating Excel forecasts into an Access Database
  191. Count
  192. links for formulas between two worksheets, payroll carryover acrossmonths
  193. Dynamic External Workbook reference
  194. Weighed Average
  195. Missing cells, But they're NOT hidden
  196. Instead of a negative number, I'd like to show zero...
  197. Track Annual Inspection Due Dates Using Conditional Formatting
  198. Prevent selection of cells, based on value of another?
  199. Excel - create button to replace cell content with cell value
  200. how do get the frequency
  201. Clipboard
  202. when I wrap text in excel it disappears? autofit does not work
  203. Help me help a user in our office
  204. Erase Duplicates
  205. Re: Syntax for using "IF"...
  206. Grouping By Date in Pivot Table
  207. SUMIF - Can I total the value of cells if three other cells = set
  208. formula for month(s) prior to actual
  209. Dividing the value of a cell if another cell equals a set value
  210. Sum Multiple Criteria
  211. Is there a way to build a timeline PPT spread sheet from excel
  212. Bonus formula help needed
  213. Microsoft Excel 2003
  214. Sum Multiple Criteria
  215. Using the "IF" function?
  216. FIND is not "finding" a number in a column which contains the numb
  217. Can Excel Calculate a Jensen Alpha?
  218. averaging on an "if" or "sumproduct"
  219. Countif, then multiply??
  220. How do I go from one page to another in excel without scrolling?
  221. Multiple Criteria
  222. Multiple conditions
  223. adding IF statement to subtotal for autofiltered data
  224. Calculations in pivot table
  225. Can actual size of CHECK BOX be increased?
  226. Word wrapping in Text Box Control feature
  227. add to an existing function
  228. How not to show #N/A when using vlookup formula
  229. How do I compare two Excel columns of numbers and see non-matches
  230. conditional format by comparing to current date
  231. Help with if statement.....
  232. Grids
  233. Time Intervals
  234. Looking up Top N using criteria
  235. Macro to Protect OK, Unprotect now messed up!
  236. I would like to extract some text in my WorkSheet Tab and enter it
  237. formula to look up and return smallest date from a range of dates
  238. formula for a pension
  239. Multiplying two rows together
  240. keystroke to close active workbook window
  241. Add missing rows
  242. Overtime computation and lunch break formula with IF and AND
  243. Complex overtime calculation
  244. GETPIVOTDATA function
  245. Show blank cell when not Closed or Open
  246. How do I capitalize and parse in the same formula?
  247. how do I set up a inventory sales template?
  248. Sum different departmnt
  249. Is there a way to calulate M-T-D or Y-T-D in Excelt?
  250. why is excel so slow
  251. Search engine in excel
  252. How can I change the font on a Sales Invoice Template?
  253. formula I can't figure it out?! ARGH
  254. What does this function do =+IF(ISERR(F27/G27),0,F27/G27)
  255. To create formula to add 3 years and subtract 1 day from a date?
  256. finding redundant data
  257. Continue formula but without showing last total
  258. Data Validation Source Box
  259. warning: cannot change part of an array. how do I by pass this?
  260. Hide cell to printer
  261. Continue formula to LINE 1000 without showing FALSE
  262. US dates to UK??
  263. I want to create and name 365 worksheets...
  264. What am I doing wrong?
  265. Each New Excel to open in another session
  266. why does =GAMMAINV(0,5;389;1) return #NUM! ?
  267. R1C1 Formula in Excel
  268. Default cursor/selected cell position after protecting
  269. size of data validation dropdown list
  270. Count Mondays worked in Month
  271. macro
  272. Changing the colour of a logic expression
  273. Function not working
  274. If Statements - Multiple formulae
  275. Excell help
  276. How do I set up a range within a IF function?
  277. You have money coming to you!
  278. pivot table
  279. Comparative Formulas
  280. Multiple V Look up help?
  281. How to change positive numbers to negative numbers without re-ente
  282. Sequence Formula
  283. Update a cell with a specific value related to a date.
  284. COUNTIF: 2 criteria: Date Range Column & Text Column
  285. Excel If Statements, please help!
  286. How do I lock a column in EXCEL to prevent changes-can add input
  287. Subtotaling list of different items
  288. Position of cursor when protected file is opened
  289. How do I link a folder to a cell in an Excel spreadsheet
  290. Function to add multiple "."s with a cell?
  291. Entry into check box dependent on other check box.
  292. Change the right click menu on cells with imported data?
  293. Lists help
  294. Conditional Formatting
  295. How can you insert a picture in a protected Excel Sheet?
  296. COUNT formula need two conditions
  297. 3.10 PM to 24 hour time please ( 1510 )
  298. Formula help for counting,with a column of dates and a column of n
  299. Question to Bob Phillips (or whoever...)
  300. Splitting the contents of a cell?
  301. restricted values that can be entered
  302. Splitting Up Text in One Cell To Many
  303. Conditional Formating issue.....
  304. Delete rows that contain blank columns
  305. SUMPRODUCT Question....
  306. dependent dropdown boxes
  307. Count if match any of 3 strings
  308. Sales V commission
  309. format cell based on previous one
  310. How to get leading zeros using DEC2BIN
  311. Add numbers in column b if date is between certain criteria
  312. count values in one column based on their realtionship with anoth.
  313. Problem Referencing Multiple Lists
  314. Comparing One Range and Adding Another
  315. I would like to count the # of times a value occurs in Col B base
  316. vlookup function
  317. Nested If/Then statements
  318. Yes, No, N/A in formula
  319. Conditional Formating
  320. Creating a single vertical array from multiple column arrays
  321. Conditional Formating
  322. COUNTIF nonblanks
  323. list data of same cell on different worksheets.
  324. Connecting data in different pages and make calculations
  325. Unique numbers if between dates
  326. combining conditional formatting and functions
  327. Sum formula of cells with specific color value
  328. Date formula needed
  329. Group function while using Pivot tables
  330. How to count uniques of a SUMPRODUCT subset?
  331. Want to offset found value using Index
  332. Convert letters into numbers. i.e. ABCD = 52
  333. Range efficiency
  334. how do get the frequency in 2 columns
  335. Count Question
  336. Creating a schedule
  337. Don't know how
  338. Formulas in Excel XP
  339. Formatting Numbers
  340. Macro for cell selection starting with Last Cell
  341. value of #'s in column if between dates
  342. Vlookup using two columns
  343. Counting Unique Part Numbers In A Range
  344. How do I manually calculate this formula PV(P3/1200,Q3,-N3*M3/100
  345. Sumif
  346. Is it possible to build macro that compares diff workbook columns
  347. Count Characters
  348. "last modified date"
  349. Help with a complicated array formula
  350. Count number of items in one column that have a value in another?
  351. Looking for best fit
  352. Need help updating my macro to include a 2nd worksheet.
  353. mid and find
  354. Find first occurence in a list that's greater than a specific num
  355. Matching Question
  356. how do i set the enter key to give a horizontal movement
  357. Nested function
  358. How do I specifly text lenth if the text is words instead of #'s
  359. Still trying to figure it out
  360. Sumproduct
  361. IF command, limit to number of entries?
  362. Is it possible?
  363. how do I keep column titles on subsequent pages of a pivot table
  364. how to add a drag-down list box in Excel
  365. How to Highlight the date if it is within 3 months from now
  366. When merging information not merging correctly
  367. Rank where lowest value is highest rank
  368. Sum Count of Criteria Every 3rd Row
  369. Still stumped
  370. I need to consolidate data from 3 different worksheets?
  371. Nesting or new column?
  372. Macro for Hyperion
  373. search box in excel 2003?
  374. excel - autonumber feature
  375. formula to find the filter criteria
  376. Calculate date
  377. Finding Matching (ContraSide) Transactions
  378. Will Excell 2003 convert numbers to words?
  379. Concatenate shortcut?
  380. Update rows with new pricing
  381. Find percentage ???
  382. sumif only for unhidden rows
  383. Macro time out error
  384. Sum a row of multiple vlookups
  385. delete column heading for print
  386. gcTCPObjLib.dll use as Excel function library
  387. Ruler in excel for draw
  388. filtering between spreadsheets
  389. another data calculation
  390. How can I sort a group of numbers automatically as data is entere
  391. Macro required
  392. Indentify value from multiple values in a single cell
  393. sumproduct?
  394. Excel: How do I sum a row if one cell has #n/a in it?
  395. dragging a formula down a column
  396. count problem
  397. STDEVPA question
  398. Conditional subtotals
  399. How do I use multiple functions?
  400. Merge pages of data
  401. Sum doesn't work automatically
  402. how insert same text in empty cells in column (10000 rows)
  403. Counting Starting Digits
  404. Function to find the address of a cell
  405. Drill Down Function Office 2000/2003
  406. How to set condition: A1=A2=A3= ... =A10
  407. Insert manual line break in formula
  408. Extract each item in the list
  409. Dynamically-linked formula, cell reference in the string
  410. #VALUE!
  411. How do I set up automatic sequentially numbering for worksheets?
  412. How do I change my typing from horizontal to vertical
  413. round up numbers to next highest "4"
  414. Excel 2003 - Shared Workbook NOT Saving Changes
  415. add data to combo box in excel then invoke macro
  416. YIKES! All Validation functionality DISAPPEARED!
  417. Today's Due Date in Colour
  418. Copying Formulas
  419. Divide date into separate columns
  420. Exportin to xl
  421. match and if then
  422. Mileage calculator in EXCEL
  423. Not Sure if HLOOKUP, VLOOKUP or LISTLOOKUP..Help!
  424. Excel Help Please
  425. can i recover a file i didnt save nor have i closed out?
  426. How to calculate average from large dataset in several sheets?
  427. All pictures disappear from my whole excel file when I use 'hidden
  428. Conditional formatting
  429. Problems with Sumproduct formulas
  430. How to interpolate in an array forX and Y values to get Z?
  431. How do I change the end cell (Ctrl end) in a excel spreadsheet?
  432. =VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)>6,MONTH(date)-6, MON
  433. re-arrange text
  434. how to draw a chart using x,y axis not the date with x-axis?
  435. spell number
  436. MODE Function
  437. Buyer Vs Seller Matching Formula
  438. Time function
  439. Data Validation (Multiple Choice)
  440. Returning specific cell if zero
  441. Copying Formulas to Other Worksheets
  442. Worksheet tabs on multiple lines?
  443. Format & formula retained
  444. using the fill handle All the cells return the value of the first
  445. Text Extract
  446. How can I password protect a hidden column in Excel?
  447. Copying information and calculations from one sheet to another she
  448. cell reference math
  449. HOW DO i CHANGE THE FONT IN A CHECK BOX?
  450. How do I hide a TAB?
  451. How to reference cell in other worksheet
  452. if statements with colors?
  453. mail merge with Excel data source
  454. Calculation with IF functions
  455. The last column in my word document contains both text and number
  456. Test plus date and time
  457. I want to copy a formula n Excel but skip any blank cells
  458. Hyperlinks
  459. how do I set up multiple (3,000) hyperlinks in excel quickly?
  460. Using copy/paste after subtotalling
  461. How do I make a search sheet?
  462. How do I convert numbers to words writing checks with Excel?
  463. downloading an attachment
  464. Is this possible??
  465. identify first date a record appears
  466. Question about this formula...
  467. Forcing data into a cell
  468. retain formatting as an actual value
  469. copying an entire worksheet - need absolute values
  470. Summing values if conditions are true
  471. Excel ISERROR function
  472. need to change num key pad from moving the mouse pointer
  473. Using absolute cell refernce and inserting rows
  474. If Statement and two metrics
  475. Nested IF Function and VLookup Alternatives
  476. Urgent appeal; Please get us out of here.
  477. Question regarding wildcard in multi-criteria IF formula
  478. how do i insert a code bar or link to a adobe designer file
  479. Can you use the validate function in a data form in Excel?
  480. average w IF
  481. "Best Practices" Use of GetPivotData Function
  482. I would like page setup to always be in landscape not portrait
  483. Re: Using a cells contents to reference a sheet.
  484. Re: Using a cells contents to reference a sheet.
  485. Calculate time in a cell
  486. References to Blank Cells turn into Zeros
  487. How do I highlight three cells in a row with speech recognition u.
  488. Match function
  489. Re: Match function
  490. Create a list based on single shared criteria
  491. Re: Create a list based on single shared criteria
  492. How to turn a spreadsheet into a function?
  493. Re: Match function
  494. Re: Match function
  495. header/footer from page
  496. Help with Combination function
  497. Help with Combination Function
  498. If Function
  499. Vlookup in different worksheets
  500. EXCEL FILTERING - aghh!
  501. Hide tab sheet in webpage (Excel)
  502. lookup in MATRIX
  503. Extracting month as text
  504. Can I allow cell merging in a protected sheet
  505. Extracting Data from a list
  506. How to find hidden names on an Excel worksheet ?
  507. IF statement
  508. If Formula
  509. feet, inches
  510. Does SUMIF in Excel, take multiple criteria input?
  511. Round/Ceiling on an IF function returning numerical value or text
  512. Column Width and Row Height
  513. How do I separate worksheets in a workbook into individual files?
  514. countif
  515. greyed out menu items
  516. Linking 2 workbooks
  517. Multiple Workbooks Summary
  518. Countif on multiple dates
  519. Why aren't the exceptions I selected in WS Protection working?
  520. How to make Horizontal data go Vertical
  521. POP-UP MESSAGE IN EXCEL
  522. Is there a formula that will convert h:mm:ss into seconds?
  523. auto expand rows
  524. DSUM with Criteria containing non-hardcoded values?
  525. Set color of cell based on info on another sheet?
  526. count if with two references
  527. need to remove a comma from end of test in cells
  528. Can't change cell value with unusual font.
  529. Can I format a cell to include quotes " "
  530. Copy subtotals without hidden rows
  531. SUMIF and Dates
  532. Whey is Excel 2003 calculating take so long - sometimes 20 minute
  533. Find Replace for whole file
  534. Combining Nested IF statement with Between operator
  535. how do I =if(any one of 20 specified cell=1," ",1)
  536. How do I use the concatenate function to add a date into a sentenc
  537. How do I combine If and VLookup function?
  538. Sorting Data in Tables
  539. Extract From Cell
  540. Autopopulate with zero
  541. Formula Help
  542. Value Return
  543. HOW DO I USE TWO IF FUNCTIONS IN ONE CELL?
  544. Formula to compare a cell to find same value in a column in Excel
  545. INSERT COMMENTS WONT SAVE
  546. Re: Create a list based on single shared criteria
  547. How do I unhide a column when format/column/unhide won't work
  548. creating a complex cell
  549. Sum numbers only; no text
  550. is there any excel founction for Cramer's V
  551. Need formula for: IF K1 = y then M1= the date in A1 + 15 days
  552. Checking for a zero value in multiple columns
  553. On the last day of each month, insert a static value
  554. I want to creat automatically new work sheets
  555. hiding cells from others
  556. Re: Need your suggestions
  557. microsoft.public.excel.worksheet.functions
  558. Help with find in Excel ...
  559. Lookup top 5 values (MAX function?)
  560. Matching problem
  561. Help - Separating numbers appearing on the right of a text string
  562. is there a formula for changing h:mm:ss to seconds?
  563. Test display until value
  564. stroll bar
  565. Data Validation
  566. Printing
  567. how do i create a macro for putting a check in a box?
  568. auto update of copy of workbook
  569. OR or conditional format
  570. Keeping Control Buttons Still
  571. Need Help with a Date Sum Product
  572. How do I format list of names formatted last,first to first last?
  573. Excel formula-cell reference not working
  574. Advanced Filtering.....
  575. How do I show file creation date in a cell in Excel?
  576. Ignoring highlighted cells
  577. create pivot table from excel table
  578. adding and divideing by a the number of cells!
  579. =IF(logical test,value if true,value if false) always backwards!
  580. Excel Help
  581. Eliminating #N/A
  582. Ignoring weekends & holidays-NETWORKDAYS?
  583. Data Validation drop down for multiple worksheets
  584. How do I increase the font of my drop-down menu options?
  585. WORKDAY formula in excel
  586. Sharing sheet
  587. How do I get the quick key commands to work in excel?
  588. Macros???
  589. Combine information about products from 2 spreadsheets
  590. How do I get the quick key commands to work in excel?
  591. Help with using filter criteria with date
  592. How do I build a reference to an external worksheet?
  593. Making this formula work
  594. Matching and aranging data form two sources
  595. make a negative number zero
  596. How do I Find links in worksheets - not in any formula
  597. Problem with VLOOKUP formula
  598. Can I add a graphic to a cell in Excel
  599. how to compare text fields in 2 different columns in excel
  600. Sum function
  601. Excel And Multiple CPU
  602. RE: Converting text into Date Value
  603. Is it possible to insert a picture using formulas?
  604. Converting text into Date Value
  605. RE: Countif question
  606. Multiple Count Criteria
  607. If, but, and still but, all in one formula?
  608. Summing Rows with Multiple Criteria
  609. Wrap Text
  610. How do I search excel spreadsheets using multiple search criteria.
  611. Copy Comments
  612. Macro - Delete Comments - What if there's none?
  613. 2 wkshts showing different views with same fonts & zooms
  614. Countif question
  615. IS there a way to find the name of GIF file over Excel cell
  616. Find and Replace
  617. sumproduct
  618. sumproduct with 0/blank cells
  619. Ok In One Column - #VALUE In the Next
  620. I want to combine the totals from several workbooks to one summar
  621. Problem with criteria when using it from VBA Code
  622. EXCEL.SUM OF DIFFERENT COLUMS AND LINES ON DIFFERENT SHEET REPEAT
  623. Nested IF statement with cell range reference
  624. Can excel total up the same cell reference across several workshee
  625. grouping data
  626. link cell in 1 wk-sht to another & keep it regardless of sorting
  627. Can I use a header or footer more than 255 characters in Excel?
  628. find averages not including 0's for values not in contiguous rows or columns
  629. change cell size from page to page on the same worksheet
  630. Lookup against pivot table with multiple instances
  631. Add total number of rows (text) in a column
  632. vlookup does not work between 71% to 79% refernceing roundup numb
  633. Can I make a list, on one summary sheet, of data collected from ma
  634. Set View to 75% upon Workbook open
  635. #Div/01
  636. Changing Formula elements to values
  637. conditional data validation
  638. Macro to convert hyperlinks to text
  639. COUNT OR SUM OR IF?
  640. No refresh in copied cell
  641. Count Problem between dates
  642. =if returning 0
  643. couting transactions for same time
  644. Hide Fonts
  645. Gregorian to Islamic Hijri date conversion
  646. Floating Total Row
  647. autotransfer data from different pages to balance sheet
  648. How do I change a name to titlecase in Excel?
  649. How do I set up an Human resources task planner
  650. Sumproduct: Formula is finicky
  651. ISNUM ????
  652. MSFT Excel
  653. Gathering and Combinging Data in 2 Spreadsheets
  654. XLSTART doesn't open PMW
  655. How do I protect hidden rows from being unhidden?
  656. Statistical smoothing a range of numbers - match average more clos
  657. Creating lookup formulas for material cost spreadsheet
  658. Is there a way to lock two or more rows together?
  659. How do I keep border permenant in a worksheet template?
  660. How do I copy subtotaled data without the underlying details?
  661. Importing External Data function
  662. can't change font
  663. Vlookup a column then a row
  664. how to copy cells data in every 7th row?
  665. Auto-Filter Intermittently Disables
  666. Combo box list w/ data in 2nd workbook without opening both files
  667. Range of numbers in a formula...PLEASE HELP!!!
  668. Macro Help
  669. TAN different to a calculator? Please help would be appreciated lo
  670. "Cumulative" column based on a pivot table sum column?
  671. Inserting a string seach within a complex function
  672. Anyway to set numerical column name as Exel convention?
  673. Using Index(A:A,.........)
  674. Add a number button
  675. Re: Lookup (multiple variables)
  676. How do I change one repeated word in the spreadsheet to another?
  677. If Statement
  678. hidden worksheet?
  679. Trend Line constants
  680. Restarting a macro
  681. Cell Reference
  682. need to count/average if...
  683. merge
  684. How to lock a row in a spreadsheet based on the value in a cell
  685. Data in cell to reference a worksheet page
  686. Linking WorkBOOKS across directories
  687. Macro to open workbook and copy and paste values in to orig workbo
  688. How to run a macro as soon a a workbook (.xls) is opened?
  689. vlookup:same lookup_value, different returns
  690. Look for match on two worksheets
  691. How to use distribution functions?
  692. Depriciation Matrix
  693. How do I combine the contents of multiple cells in one cell?
  694. Re: Please Help !!!
  695. TOTAL NUMBER OF ENTRIES
  696. how to write function to find max deviation from specific number .
  697. how to cover the formula
  698. Formula for determing average based on weighting
  699. Help with Formula,reulsts show in Function, not in Spreadsheet?
  700. Excel Formula - Reg
  701. ? Link attached - How to validate SIN (Social Insurance Number)
  702. Look for values on another sheet.
  703. IF function for scheduling tool with outlook integration
  704. How to auto activate macro when file open ?
  705. sumif criteria
  706. Separate records from Vertical to Horizontal
  707. How do I change the font color based on results of an IF stateme
  708. Use networkdays INCLUDE weekends, Exclude holidays
  709. formatting a cell with text from other cells
  710. Graphing error using Time as X axis.
  711. What is the formula for blinking a cell with a value in Excel
  712. Nett Date Calculation
  713. how to sort date in excel
  714. Change Cell Color Based on IF Statement
  715. Zip codes that begin with a zero...
  716. Calcualted Fields in Pivot Tables
  717. HOW TO: In a formula, how to change the format of the resulting te
  718. Excel won't update/calculate a single cell in a workbook
  719. Help Please-Counting Filtered Rows
  720. Override save as Dialog box
  721. Can't change font
  722. hide unnecessary sheets when emailing to others
  723. Setting Cell Number Format With A Worksheet Function
  724. Looking up information based on Columns and Rows
  725. Validation of Postal Code
  726. SUMPRODUCT question
  727. UDF's using other UDF's
  728. Excel 2003 - Ctrl-End selects last cell. How chg last cell addr?
  729. Hide #div/0 Error When Averaging
  730. Return Single Row of Numeric Data to Single Column
  731. Generate an Absolute Date in a Cell
  732. Stock monitoring work sheet.
  733. In excel my find a value in a cell won't work. Why?
  734. Locking a cell
  735. Array formula needed
  736. formatting end of month on a monthly sheet
  737. Hyperlink
  738. Any software for charting moving averages?
  739. How to auto activate macro when file opened
  740. Complicated Vlookup/count problem
  741. Re: If false skip to next
  742. Function help please!
  743. Including objects based on a condition
  744. Counting # of Times an Item Shows Up in a Table
  745. Time conversion
  746. Moving a Selection of data???
  747. Using cell contents within a formula
  748. Can i move scanned jpeg text to excel spreadsheets
  749. Worksheet name in cell
  750. How can I create a field indicating a persons age by using bd inf
133