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

  1. Re: autofilter
  2. Can you combined the SUMIF and SUBTOTAL functions in a formula?
  3. Combining SUMIF and SUBTOTAL functions
  4. Excel database - merge to Word
  5. Pivot ranges and INDIRECT
  6. How to lookup a value from a ramge of data. Eg Column C Row D?
  7. How can I protect cells in Excel 2000?
  8. How can I sort this:
  9. Re: function to check numeric value
  10. Formula for button name
  11. Re: Putting numbers in excel without it changing into a formula?
  12. How to get difference in hours
  13. Divide by Zero
  14. Excel2000 A working formula has {braces} which disappear. Why?
  15. Replacing MCONCAT with CONCAT_RANGE (UDF)
  16. Stripping out imbedded spaces in a cell/row
  17. Same cell added to master summary sheet
  18. Replace a ; with a , and a space
  19. Print Rows to repeat at the bottom
  20. Autofilter hangup
  21. Cells not updating
  22. Help with OR statement
  23. Display Format with Text & Formula
  24. Count If Function
  25. Change the font case of all cells in the worksheet to uppercase?
  26. Inserting/Deleting Spaces
  27. countif question
  28. =?iso-8859-1?q?Good_morning_or_good_evening_depending_upon_your_location._I_want_to_ask_you_the_most_important_question_of_your_life._Your_joy_or_sorrow_for_all_eternity_depends_upon_your_answer._The_question_is:_Are_you_saved=3F_It_is_not_a_question
  29. If function
  30. IF function
  31. Insert rows, keep a formula?
  32. looping a calculation until workbook closes
  33. Allow (validation) except
  34. Sorting a portion of a range
  35. compare the first column and concatenate the second column
  36. Default to beginning of month
  37. vlookup for multiple columns
  38. .pdf hyperlink
  39. Sum of dates
  40. How to remove duplicates from a list and copy new list to new colu
  41. Copy cells into range of cells until cell change
  42. SumIf Help??
  43. Sum only last X cells
  44. Sumif function with two criteria from different columns
  45. Protected Worksheets
  46. Populate 120 cell column with successive months entering only firs
  47. auto change number entries
  48. Is there a way to import a pdf file in to Excel
  49. Date Defaulting
  50. Autofill data in specific blank cells
  51. Re: I would like to apply the same calculation to an entire row
  52. need help with a simple time formula
  53. Accumulation
  54. IF statement
  55. VLOOKUP - results do not appear in cell
  56. Help with using a cell in function
  57. How can I get automatic row height for merged cells with text wra.
  58. Time Calculations
  59. Need to switch 2 columns with each other...please help
  60. HELP SVP- EIYHER OR ENTRY OR LOOKUP
  61. divide by 0
  62. Changing the Row_index_num via HLOOKUP
  63. Last weekend of month
  64. selecting days of week using a formula in spreadsheets
  65. entering rates five % higher
  66. Is the a better way than LOOKUP?
  67. Re: Comparison / Check Off between 2 excel sheets. HELP NEEDED!
  68. VLOOKUP Help
  69. Golfsheet function
  70. SUMIF with 2 criterias
  71. I want to use the MATCH function with the AVERAGE function but I .
  72. Quasi Transpose / Stacking Columns
  73. VLOOKUP with 2 Criterias
  74. Not summing a columns?
  75. Re: Function to set borders of cell
  76. Want VLookup to Return the row above
  77. Why is coditional formatting not accessable?
  78. math
  79. Please help me.
  80. Excel If function alternative
  81. Adding numbers in a column that have 3 decimal places
  82. Why does the macro not work?
  83. Re: Removing house numbers from addresses
  84. The reference changes when I insert a row?!?! Help
  85. Re: Comparison / Check Off between 2 excel sheets. HELP NEEDED!
  86. Re: Comparison / Check Off between 2 excel sheets. HELP NEEDED!
  87. Date & < sign I want to Conc.
  88. Concatenate text and numbers?
  89. Apply to next X cells to the right...
  90. I need a daily sales sheet to pull from monthly figures sheet
  91. IF fuction and format ...
  92. Cell to Show "Continued" only if > Page 1
  93. Number formatting
  94. Re: Removing house numbers from addresses
  95. selecting non adjacent cells
  96. Incorporating cell content into a message in a formula
  97. XIRR function on Excel 2003
  98. Dates and times again
  99. How can I download and install ERROR FUNCTION in Excel 2003? ERF.
  100. Dowloading internet data to worksheet form a ".ccv" file
  101. Strip carriage return, add row
  102. Keep the left column revealed
  103. help extracting data from an excel sheet
  104. Using function results as parameters in another function
  105. Show the Last entry
  106. SUMIF function
  107. =?iso-8859-1?q?Re:_Good_morning_or_good_evening_depending_upon_your_location._I_want_to_ask_you_the_most_important_question_of_your_life._Your_joy_or_sorrow_for_all_eternity_depends_upon_your_answer._The_question_is:_Are_you_saved=3F_It_is_not_a_ques
  108. Macro or Formula to remove Text from Cells
  109. Subset of one sheet on another sheet
  110. How do you divide all values in the worksheet by 1000000
  111. Using EXACT to Deduplicate
  112. Conditional Format based on contents of cell.
  113. Joining Multiple filters with OR rather than AND
  114. How to find returns in cells
  115. Letter and numeral separation
  116. Error message
  117. Formula for displaying the lowest number of a range?
  118. Sheet Protection Unlock
  119. =?iso-8859-1?q?Re:_Good_morning_or_good_evening_depending_upon_your_location._I_want_to_ask_you_the_most_important_question_of_your_life._Your_joy_or_sorrow_for_all_eternity_depends_upon_your_answer._The_question_is:_Are_you_saved=3F_It_is_not_a_ques
  120. Formula For Multiple Breaks In Calculations
  121. Return number of current sheet
  122. How do I convert an Excel workbook that has mulitple sheets into .
  123. How do I convert figures to text?
  124. Protection
  125. How do I create a reusable template
  126. ENTER A FORMULA IN A CELL TO UTILIZE THE IMPORT DATA FUNCTIONS?
  127. Sharing woorksheets
  128. If the SUM of a list is 32.2 what formula to round it up to 32.5?
  129. Lookup thinks data isn't sorted
  130. What is the BEST way to add values residing in two non-consecutiv.
  131. Re: How to get 'top 10' text values from a range
  132. Vlookup(?)
  133. COUNTIF with multiple criteria?
  134. Summing non-contiguous cells
  135. Need a good template for a phone list
  136. How do I unlock a spreadsheet that is password protected?
  137. Excel: Solver
  138. Re: Comparison / Check Off between 2 excel sheets. HELP NEEDED!
  139. I need help inserting and composing a drop down menu for individu.
  140. How can I add the same data to every worksheet in a workbook all .
  141. how do I freeze the time in the NOW() function?
  142. COUNTIF COMBINATION??
  143. Divison by 0
  144. Ignore #DIV/0!
  145. How do I set a ratio using two cells in Excel?
  146. How to merge columns
  147. Simple lookup
  148. Removing columns (not hide or white-out).
  149. help again
  150. Excel data ( VFP )
  151. clock
  152. Using a Vlookup to return values in a data list?
  153. Running code on a drop down selection change
  154. Msgbox
  155. quick selection drop down list
  156. i want to display the month from a date into another cell
  157. Consolidate different sheets to different workbooks
  158. Count Distinct Values?
  159. Rows to repeat at the bottom
  160. Common spacing
  161. Progressive summing
  162. EDIT FORMULA BAR in excel 2003? why not? where is it?
  163. How do I delete a row from a spreadsheet if criteria is not met i.
  164. scenario analysis-multiple variables
  165. Deleting 3 Text characters from the right
  166. Stationery Column and Row
  167. IF NESTED Question
  168. How do I use Excel Built-In Functions in Code?
  169. How to get an exact mactch with Vlookup
  170. How secure is the "lock cells" function?
  171. Copy/Insert rows with formulas
  172. COUNTIF Statement with Multiple Conditions in Different Ranges
  173. microsoft excel
  174. complex if statements in excel
  175. how do i hide value errors until data can be entered?
  176. how do i hide value errors until data can be entered?
  177. How can I delete similar rows in excel workbook with many sheets?
  178. autofilter in excel bug ?
  179. Counting rows with 3 columns
  180. trying link row on one sheet into column on another sheet
  181. Remove Line Breaks ALT + ENTER
  182. Formula
  183. Formula for calculating time
  184. linking cells
  185. Re: Time Sheet Calculation Help Needed!
  186. Re: Time Sheet Calculation Help Needed!
  187. How do I import data and display zeros?
  188. Counting Unique Records with multiple conditions
  189. I need help w/ data on one sheet to be used on several others
  190. How do I sum using relative cell positions?
  191. Help with SUMIF function criteria
  192. Hyperlinks / server / cd
  193. Can the =CELL formula be used to determine the worksheet tab name.
  194. LOOKUP functions?
  195. Can I establish a link based on a date?
  196. Average non continguous cells, excluding zero's
  197. Looking for something similiar to MIN
  198. Can I propagate a date from one worksheet to another
  199. hOW TO USE EXCEL TO CALCULATE BASEBALL BATTING AVERAGE
  200. blank cell returned
  201. HOW DO I NEST MORE THAN 1 IF FUNCTION?
  202. Convert PivotTable data into a worksheet list
  203. Time to number
  204. trying to find max date
  205. how do I transpose and paste a link in excel
  206. solve quadratic equation system
  207. Linking across worksheets not working as desired
  208. HELP required: Insert -> Hyperlink -> ???(no CHART sheet name)!!!
  209. Static cell reference
  210. Copying data without hidden rows.
  211. CUMIPMT #NAME error
  212. Sort on a protected sheet
  213. Changeing cell size in the middle of a worksheet
  214. INSERT LINE after Vendor name change
  215. Can I format a cell to fill red when clicked with mouse (Excel)?
  216. Finding or creating correct formula
  217. How do I Compare worksheet columns
  218. Function for Roman Numerals
  219. excel query
  220. How can I create an XML map (2003) to import to workbook
  221. How do I delete 2000 pages created by Excel from my one page doc.
  222. Sum for lines equal to criteria
  223. SQL.REQUEST help needed
  224. Urgent help! how to automatically resize all the charts?
  225. Help to adapt Formula syntax to work with Dynamic Named Ranges
  226. converting PDF file to readable excel format
  227. IF Function with formatting condition
  228. RE: Change Text to a number
  229. RE: Random alpha generator
  230. RE: Change Text to a number
  231. UnKnown Character Removal
  232. RE: HOW TO HAVE MORE THAN THREE CONDITIONS IN CONDITIONAL FORMATS ?
  233. VLookUp
  234. User Defined Functions
  235. only last cell on page to have bottom border (cell area outline)
  236. how do I link radio button selection to another page
  237. Variable Link to Workbooks
  238. Excel to acrobat
  239. Pivot Table
  240. Formula for pulling column I ttl in column I for each "e" row that
  241. RE: subtotaling and manipulating a list of data
  242. RE: how do I use vlookup for multiple occurrences of the same value
  243. Forms and Conditional Formatting
  244. Sorting data in a workbook across multple worksheets
  245. Look in shortcuts.
  246. HOW TO HAVE MORE THAN THREE CONDITIONS IN CONDITIONAL FORMATS ?
  247. Currency question
  248. Change Text to a number
  249. Need formula to count specific cells in a row
  250. Trying to count specific values
  251. subtotaling and manipulating a list of data
  252. Subtract entire sheet?
  253. how do I use vlookup for multiple occurrences of the same value
  254. Random alpha generator
  255. Data Validation Cell - Move to UserForm
  256. find Max value in row--return value in same column, different row
  257. trimming blank cells
  258. Linking workbooks in 2003
  259. How can I fit an accurate trendline and formulae
  260. Re: Excel Function lessons Needed!
  261. Pence field to currency?
  262. how do I recover a file where I accidently saved it as the wrong f
  263. Excel not updating when figures are changed
  264. Excel not updating when figures are changed
  265. Row reference increment but preserve column reference
  266. I made a terrible mistake and need help
  267. How can I convert entire columns of text to Uppercase in Excel?
  268. Custom Views Grayed Out
  269. Vlookup formula using tax yables
  270. VB Stopped Working
  271. SUMIF help needed
  272. <,> formula
  273. =?iso-8859-1?q?Good_morning_or_good_evening_depending_upon_your_location._I_want_to_ask_you_the_most_important_question_of_your_life._Your_joy_or_sorrow_for_all_eternity_depends_upon_your_answer._The_question_is:_Are_you_saved=3F_It_is_not_a_question
  274. How do I create a print button?
  275. How can I make Excel Macros created on PC work on Macintosh?
  276. If function that calculates
  277. SumIF Multiple Ranges
  278. Formula for YTD total of Vac. Hrs. used for spec. employee
  279. Can an Excel formula be created to paste a picture in a cell?
  280. moving minus sign from right to left
  281. sum by cell color
  282. count number of items in a row? help *file included*
  283. Conditional Formating
  284. adding color to the results of IF statements
  285. synchronize multiple worksheets
  286. using a function based on the value of a function
  287. Adding characters
  288. Conditional Formating Extreme Question
  289. Command not recognized
  290. Macro to save
  291. IRR data in different ranges
  292. Column Reference Copy
  293. Average
  294. Summing 2 columns
  295. Advanced Filtering
  296. Can I link Contact info into an Excel doc?
  297. Absolute Statements in Excel
  298. Empty Cell ( blank Cell )
  299. Scrolling in Excel
  300. Condensing one column to another without spaces.
  301. .csv file Text to Columns
  302. Time Formula
  303. Maintain cell links when renaming directory containing multiple f
  304. Protect sheet and allow grouping of columns
  305. Worksheet linking
  306. Format Cols
  307. How do I enter formula using % > or < = number?
  308. how to add another conditional formatting
  309. Re: Solver help
  310. Excel: Add time to a date and time column?
  311. Change format to landscape for whole workbook at once
  312. Match a name to all clients?
  313. Finding a range from a column using VBA.
  314. Unhiding multiple rows simutaneously
  315. buttons & macros
  316. Copy a formula
  317. Round Up to Nearest 10
  318. XIRR function input parameters
  319. SUMIF function referring to values on different Worksheet
  320. Reveal cell formats and extendable range in tool/statusbar/icon.
  321. Re: Yes or No buttons,list,or Combo box
  322. Re: Yes or No buttons,list,or Combo box
  323. If function with blank cells
  324. Extracting/look up data from a list and select multiple instances
  325. Re: Yes or No buttons,list,or Combo box
  326. Track info from one w/sheet onto another.
  327. date and bond calculations
  328. how do i transpose rows to clumns?
  329. Formula Problem - If Statement
  330. Create Total based on lookup value
  331. Need to Escape from Excel Forumla Hell!
  332. How do I lookup numbers with a MIN and MAX?
  333. Work with list to make 3rd column
  334. RTD Problem
  335. Enable hyperlinks
  336. Lookup baseball scores in 1 worksheet and have them display in ano
  337. LOOKUP function
  338. How do I automatically calculate YTD numbers by changing a date?
  339. Conditional Formatting
  340. dates
  341. How do I filter a list using a greater than todays date function?
  342. Default comment location
  343. Custom Function
  344. Concatenation using IF AND - Possible?
  345. the target cannot handle this type of document
  346. Calculating Overtime from Hours total
  347. Counting Entries
  348. How do I set the order of calculation of Data Tables in Excel?
  349. excel macros
  350. Vlookup for part of a word
  351. How do I auto copy text in a cell from one sheet to another
  352. Auto Date Fill-in
  353. overtime templates
  354. a way to limit the characters allowed in a cell?
  355. data fill question
  356. CORRELATION / COVARIANCE MATRIX
  357. redistribute a column by a groups of rows
  358. Drop down text too small
  359. Solver Problems
  360. Does excel have a 'cubed root' function? How can it work it out?
  361. vlookup from multiple columns
  362. Sum Formula
  363. Average of ...
  364. SUMIF(O18:O500,"=b21"Q18:Q5) i want to do this not "=001690"
  365. Referencing a formula (as text)
  366. How do i create a command button or macro to exit Microsoft Excel
  367. Negative numbers in parenthesis if not shown in drop down box
  368. simplify function
  369. Lookup cell contents in on sheet based on a formula in second sheet
  370. Sheet Tab Names
  371. sumif? lookup?
  372. Matching cells
  373. Auto Date
  374. excel function
  375. Loan Schedule with Balloon Payment
  376. Simplify formula
  377. Merge, update, and add only new entries into a list from other she
  378. cell drop and drag
  379. Remove Numbers from text
  380. How can I choose top two numbers in a column?
  381. datafeeds
  382. Add mailto (email) as function to a button in excel
  383. How do I get 1 cell calculate only if another cell has an "x"
  384. Conditional format
  385. question on excel Solver
  386. I want to sort everything but my validation list
  387. How do I insert A drop down dialog box as a 'list to choose from'?
  388. Create a sheet name, won't let me, says already sheet named that
  389. How do I make a sound as a result of an "if" statement in excel
  390. How to create specific formula
  391. enter a time into a cell, have the cell show two times the entry
  392. How do I nest these 3 IF functions?
  393. Add to my Function / formula
  394. RE: Matching
  395. count the number of times data appears on the same row from two c.
  396. Convert minutes into hours and minutes
  397. Referencing a newly created worksheet
  398. Data Validation - Custom - Formula
  399. How do I add the sum of a series numbers generated by Rnd gen?
  400. Automatic updating of Conditional Formats using dates
  401. how i can call the function
  402. Using If function
  403. Subtotal excl errors
  404. Lookup Help
  405. Parameter description
  406. unique occurences in list
  407. unique occurences in list
  408. Sumif - FastExcel
  409. Inserting Columns and Formulas updating
  410. Lookup data
  411. Multiple charts
  412. Can distance be calculated using latitude and longitude?
  413. Emulate Index/Match combo function w/ VBA custom function
  414. Control+End takes me to J2088 but the last cell is I219. Fix how?
  415. how to calculate number ranges
  416. need a formula
  417. Excel Function in what appears to be an array
  418. Military Time
  419. Simple formulas in existing Excel 2002 no longer working.
  420. Production CLock
  421. First Lower Case
  422. How do I change a column in Excel from upper case to lower case?
  423. Complex LookUp / Match Problem ??
  424. =?iso-8859-1?B?SW1wb3J0YW50IHBsZWFzZSByZWFkIHRoaXMgVGhhbmsgeW91IGCwurcuLi63urBgsLq3Li4ut7qwYLC6ty6GLi63urBgsLq3Li4ut7qwYLC6ty4ut7qwYCBgsLq3Li4ut7qwYLC6ty4uLre6sGCwurcuhi4ut7qwYLC6ty4uLre6sGCwurcuLre6sGAgYLC6ty4uLre6sGCwurcuLi63urBgsLq3LoYuLre6sGCwurc
  425. Save worksheets to different files
  426. Formulas in Excel
  427. Automatic Calendar
  428. Would be nice to download templates w/o needing activeX
  429. Populate Drop Down List
  430. printing - creating new files on each page break
  431. Multiple If and Else if
  432. Visible Cells Only!
  433. Formulas for telephone numbers: finding duplicates, autoformat
  434. Dynamic sumif function
  435. data validation
  436. How do I delete blank numbered sheets after my report?
  437. Idea for an Excel function called "Spread"
  438. Formula to sum of every nth row
  439. Returning active cell
  440. Update Field
  441. Is there a way to have different fonts and/or formats in a combo b
  442. How do I put more than 7 IF formula in a single cell?
  443. combo box
  444. Inserting Rows w/formulas question
  445. special function help needed
  446. Formatting Cells
  447. Max Value
  448. Links in templates
  449. Conditional Format Question
  450. sum errors
  451. how do I use the forecast function in Excel?
  452. MIRR Function sensitivity to Finance Rate
  453. Lookup function
  454. Color a cell and a value is automatically assigned to that color.
  455. Show weighted average value after filter.
  456. Data Validation
  457. COUNTIF with nestled IF?
  458. Re: Sumif = and between
  459. Get info from Matrix
  460. Conditional formatting
  461. how do I insert a function that chooses between two text values?
  462. Data Export
  463. Workbook is now Extremely Slow
  464. Is there a template that helps to manage condo association budget?
  465. What is a Conditional pull down menu?
  466. data storage from one worksheet to another
  467. Conditional Formatting with Dates
  468. referencing named formula using INDIRECT function
  469. same data colums
  470. How can I use HYPERLINK in a conditional statement between sheets
  471. Cell Formatting
  472. Need help with complex IF-THEN fomulas/functions
  473. How do I validate data from another validation cell?
  474. How do I import/convert tab delimited text files into Excel?
  475. Importing data from a different workbook
  476. Lookup Function?
  477. Deleting duplicate entries in an Excel list
  478. How do I sum rounded values from two seperate formulas in Excel?
  479. Identify text in uppercase
  480. Copy a number from one cell to another depending on first number
  481. count number of years 2003 in a range of dates
  482. Time zone Time difference
  483. Logical AND function
  484. Last name first first name last
  485. How do I protect formula cells on multiple sheets?
  486. How do I add (auto text) to a paragraph?
  487. Countif W/ 2 Criteria
  488. Change cell referance based on value
  489. how do I create a if-then formula?
  490. how do I create a if-then formula?
  491. Shading Cells
  492. Using MIRR, if cash flows are monthly, should rate be / 12?
  493. Import External Data
  494. password to open Excel file option does not exist
  495. Excel
  496. i need a template to carry out vat returns in excel
  497. Calculated Item
  498. Wildcard MATCH() breaks on long (?) strings
  499. Insert New Row When Column Amount Changes
  500. What is the formula for adding a number of days to an existing dat
  501. How do I use 'And' or "Or" in an If statment
  502. How to Find Weekend date
  503. having 0 as a min when running mina or average
  504. opening a user form
  505. DIV/0! and business application
  506. Lookup in Matrix
  507. Count using complex criteria
  508. sum if
  509. Re: IF Statement question
  510. adding worksheets with conditions
  511. Combining text strings
  512. chitest and interpretation of the result
  513. equation editor
  514. Can you convert a number to word equivalent ?
  515. Calculate the intersection of supply and demand curve
  516. CountIf Function
  517. excel formula counting date to date in 4 columns
  518. how 2 Count number of cells that have specific condition format?
  519. count dates within range by year and month
  520. Clearing Contents of Cell
  521. count number of months year to date
  522. if month is less than halfway over subtract 1
  523. How do you format a row to break accross pages in Excel?
  524. Random Times
  525. help on excel reports for anaylsis and trending
  526. Sum numbers based on the contents of another cell
  527. Sumproduct Help
  528. Read data from anohter XLS file
  529. Can I "CORREL" statistical funtion with three or more Arrays?
  530. assigning a unique value
  531. How do I empty the clipboard, when nothing is in it?
  532. sub totals don't work properly since upgrading excel 2003
  533. Convert Sub routine to Function
  534. Can Excel automatically insert current date in a cell?
  535. moving data
  536. Making a cell's contents lower case
  537. Filtering by Columns
  538. TEST
  539. Moving data
  540. COUNTIF functions
  541. Comparing prospect and buyers lists
  542. how do I resize the text in a validated list?
  543. Var function or something like it
  544. does anyone know how to group post?
  545. ="Z" dual use?
  546. How to use functions in one cell to get text in another cell
  547. text to columns
  548. I need help with the Sumif Function
  549. Entering multiple formulas in one cell
  550. VLOOKUP
  551. How do I modify row column format of Excel sheet?
  552. How do i create a conditional sum?
  553. Fomatting part of a formula to be Bold font
  554. another text to column problem
  555. No entry in cell J10 if cell J7 is empty
  556. data in cells
  557. nonsequential cell references
  558. Opening different files in excell
  559. Solver and dynamic ranges
  560. vlookup
  561. Formatting Time with Hundredths of Seconds
  562. formatting colors
  563. VB find (true false)
  564. Sum if or some sort of match formula
  565. how to convert julian date to regular calendar date
  566. WHY WAS THE CONVERT FUNCTION DROPPED IN EXCEL 2003???
  567. Annualised interest rate
  568. Countif for numbers between x and y
  569. Can Excel compare 4-ABC-SS to 4 ABC-SS and see them as the same
  570. how to use Excel to generate alphabet serially
  571. Help required in merging two formulas into one
  572. Question
  573. Excel formulas are slow to update
  574. Creating random passwords
  575. how to write 'not equals blank' criteria in SUMIF
  576. Excel VB Run-time error '50290'
  577. how do i create a timesheet
  578. Block entries
  579. Count and convert text
  580. convert Julian date
  581. How do I create a formula using data from another page?
  582. Using VLOOKUP to match similar text?
  583. What formula will sort data in a separate worksheet%3f
  584. Excel add-in
  585. Averages and Counts from different columns
  586. RE: Excel macro
  587. Indent within a row
  588. compare two columns and remove duplicates
  589. Excel 2002: I get formulae displaying in cells rather than value
  590. compute days between dates
  591. Deleting ALL duplicates using Pearson's code
  592. Search string with multiple criteria
  593. Calculation for Ebay worksheet.
  594. Need to insert row with enter key
  595. Please see posting on 05/04/05 does anyone know how to group post?
  596. sort by more than 3 columns
  597. Visual Basic code available for all open workbooks
  598. Formula/function
  599. Conditional Formatting Error
  600. protect from printing
  601. Automatically shifting data, part II
  602. # of occurrences
  603. formula auditing toolbar
  604. how do I get excel to ignore blank cells in formulas
  605. Sumproduct with a vLookup, multiple criteria
  606. M/S Visual C++ Run Time Error when attempting to use functions
  607. How do I set up formulas with letters and numbers?
  608. Can you AVERAGE IF and not null?
  609. Show detail
  610. Enable Automatic Update for Web Query
  611. Enable Automatic Update for Web Query
  612. Re: excel msoffice97 files will not work in excel msoffice2000
  613. DCOUNT in Excel
  614. Unwanted character
  615. Unwanted character
  616. Subtracting numbers
  617. Retrieving a Reference
  618. how to convert rpt files to xls
  619. Undo a array
  620. using cells.numberformat
  621. Countin Dates
  622. Simple statistical analysis
  623. Working time and days
  624. Number anagram
  625. Lookup problems
  626. PIVOT TABLE - Summary Table into a Databasae Table.
  627. Trailing spaces in Pivot tables
  628. 3d Graph Show Values at Bottom
  629. why does ON = Ambiguous in substitution formula?
  630. Printing from email without Word/Excel
  631. Conditional Average Ignoring Blanks
  632. Dates/Amounts calcs
  633. Random Times
  634. How do I determine automatically that a sheet is empty?
  635. Countif with cell reference
  636. COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN
  637. Lookup tables
  638. How do I set an automatic date stamp into a cell in Excel?
  639. vlookup file specification
  640. merging two excel spreadsheets - track changes from original
  641. =?iso-8859-1?q?Good_morning_or_good_evening_depending_upon_your_location._I_want_to_ask_you_the_most_important_question_of_your_life._Your_joy_or_sorrow_for_all_eternity_depends_upon_your_answer._The_question_is:_Are_you_saved=3F_It_is_not_a_question
  642. How to create a worksheet to accelerate debts
  643. How to lock worksheet formatting?
  644. formulas in spreadsheet do'nt resond to changes
  645. how do I remove a link between worksheeta?
  646. min function from different columns
  647. Error Embedding Row() within Indirect()
  648. Date formula
  649. Search a Column by text length
  650. Increasing payment in future value formula?
  651. Using Sumproduct with multiple Criteria
  652. how fill adatabasein domino designer with information of excel
  653. Copy cell format to cell on another worksht and update automatical
  654. Scenario Results all the same
  655. formatting of comments
  656. had works xp, lost spreadsheets, get back???
  657. Getting rid of new line command between 2 sets of info
  658. help with a function
  659. VLOOKUP Anomaly
  660. Help
  661. Vlookup formula
  662. Array bug?
  663. Lookup Function?
  664. If Formula ??
  665. which function to use?
  666. Negative percent formula
  667. IF Statement question
  668. convert text & multiply
  669. data validation
  670. limit column entries
  671. how i can use functions for each value in a column by one proces.
  672. shipping costs using if then
  673. time differences in a column
  674. changing sign
  675. #VALUE!, #N/A
  676. How do I correctly multiply rounded cells in Excel?
  677. Dynamic reference to sheet name
  678. problem with the command - method "UpdateFromFile"
  679. compare cell a1 & b1. if dig 1<2 ina1 &dig 1<2 in b1 then val = 1
  680. Common Spacing of Rows
  681. Border
  682. How do I insert a drop down list in a cell using
  683. excel- formula
  684. "Not enough memory"
  685. keep cells together
  686. Text not all displaying in a cell, what is max that can be inserted?
  687. How to use "or" in an if function: If C1=C2 OR if
  688. I cannot format pictures.
  689. how to setup formula?
  690. HELP REQUEST:Golf Scoresheet question
  691. Help with closing down a workbook??
  692. What do I use to find the last liste information in a row?
  693. How do I sum a range which includes the "#N/A" VLOOKUP return valu
  694. Append the data given in diff sheets of an Excel File to one sheet
  695. how to quickly toggle or switch to next worksheet
  696. How can VLOOKUP identify between multiple choices for > 1 batch?
  697. Non-signed Difference between 2 cells
  698. Can the offset worksheet function reference another worksheet
  699. COUNTING TEXT CELLS IN A COLUMN
  700. How do I insert a clock in excel worksheet?
  701. Can't freeze panes
  702. How do I retrieve data into a cell from a web site?
  703. How do I delete a character from a list of item numbers?
  704. tab-function to a new textbox.
  705. tab between several textboxes
  706. Identifying Overlapping Dates within a range
  707. Cannot hide cells
  708. Multiple matches on VLOOKUP
  709. delete columns and rows-cells equalling zero or any selected value
  710. Formula for random shuffle between a range (example) b4,b78
  711. counting more than one criteria in one cell
  712. Excluding cells with no value in calculation
  713. Updating a league table.
  714. I want to split containt of a cell and copy in seprate cells
  715. California Overtime Calculation
  716. Fairly Complex IF Statement
  717. Application.ScreenUpdating function question
  718. calculating debtor days (DSO)
  719. Excel formula to make AAA-BBB equal to/consistent with BBB-AAA
  720. How do I change the default number format in excel?
  721. lookup function HELP!
  722. The Worday Function
  723. Getting the last value of an incrementing sheet
  724. Insert worksheet is greyed out, is there an option to turn it on?
  725. look up if Criteria
  726. grouping of cells in protected sheets
  727. Need Time Sheet that calculates hours/mins from input of times
  728. How do you subtract negative numbers?
  729. color gradient in a worksheet (not a chart), Is it Possible?
  730. IF function
  731. Code Question - Calculate eBay Fees Automatically
  732. Repeat characters to cell width
  733. Excel bug?
  734. execute stored procedure from excel
  735. Copying formulas (relative) give always original value
  736. Using IF Function
  737. How to create a fill down that increments based on the worksheet n
  738. Re: How to create a fill down that increments based on the worksheet n
  739. what do you use to enhance financial data?
  740. Check Boxes
  741. Calculate In-Between Numbers
  742. Series fill of "patchy" Data set or some Programming fix
  743. Displaying names only once
  744. Find Function
  745. How do I let only one box be chosen when there are several?
  746. IF function?
  747. freezing cell values
  748. Splitting Data in a Cell
  749. Calculate change in blood pressure
  750. Rounded numbers do not add properly.
131