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. excel- formula
  2. How do I insert a drop down list in a cell using
  3. Border
  4. Common Spacing of Rows
  5. compare cell a1 & b1. if dig 1<2 ina1 &dig 1<2 in b1 then val = 1
  6. problem with the command - method "UpdateFromFile"
  7. Dynamic reference to sheet name
  8. How do I correctly multiply rounded cells in Excel?
  9. #VALUE!, #N/A
  10. changing sign
  11. time differences in a column
  12. shipping costs using if then
  13. how i can use functions for each value in a column by one proces.
  14. limit column entries
  15. data validation
  16. convert text & multiply
  17. IF Statement question
  18. Negative percent formula
  19. which function to use?
  20. If Formula ??
  21. Lookup Function?
  22. Array bug?
  23. Vlookup formula
  24. Help
  25. VLOOKUP Anomaly
  26. help with a function
  27. Getting rid of new line command between 2 sets of info
  28. had works xp, lost spreadsheets, get back???
  29. formatting of comments
  30. Scenario Results all the same
  31. Copy cell format to cell on another worksht and update automatical
  32. how fill adatabasein domino designer with information of excel
  33. Using Sumproduct with multiple Criteria
  34. Increasing payment in future value formula?
  35. Search a Column by text length
  36. Date formula
  37. Error Embedding Row() within Indirect()
  38. min function from different columns
  39. how do I remove a link between worksheeta?
  40. formulas in spreadsheet do'nt resond to changes
  41. How to lock worksheet formatting?
  42. How to create a worksheet to accelerate debts
  43. merging two excel spreadsheets - track changes from original
  44. vlookup file specification
  45. How do I set an automatic date stamp into a cell in Excel?
  46. Lookup tables
  47. COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN
  48. Countif with cell reference
  49. How do I determine automatically that a sheet is empty?
  50. Random Times
  51. Dates/Amounts calcs
  52. Conditional Average Ignoring Blanks
  53. Printing from email without Word/Excel
  54. why does ON = Ambiguous in substitution formula?
  55. 3d Graph Show Values at Bottom
  56. Trailing spaces in Pivot tables
  57. PIVOT TABLE - Summary Table into a Databasae Table.
  58. Lookup problems
  59. Number anagram
  60. Working time and days
  61. Simple statistical analysis
  62. Countin Dates
  63. using cells.numberformat
  64. Undo a array
  65. how to convert rpt files to xls
  66. Retrieving a Reference
  67. Subtracting numbers
  68. Unwanted character
  69. Unwanted character
  70. DCOUNT in Excel
  71. Enable Automatic Update for Web Query
  72. Enable Automatic Update for Web Query
  73. Show detail
  74. Can you AVERAGE IF and not null?
  75. How do I set up formulas with letters and numbers?
  76. M/S Visual C++ Run Time Error when attempting to use functions
  77. Sumproduct with a vLookup, multiple criteria
  78. how do I get excel to ignore blank cells in formulas
  79. formula auditing toolbar
  80. # of occurrences
  81. Automatically shifting data, part II
  82. protect from printing
  83. Conditional Formatting Error
  84. Formula/function
  85. Visual Basic code available for all open workbooks
  86. sort by more than 3 columns
  87. Please see posting on 05/04/05 does anyone know how to group post?
  88. Need to insert row with enter key
  89. Calculation for Ebay worksheet.
  90. Search string with multiple criteria
  91. Deleting ALL duplicates using Pearson's code
  92. compute days between dates
  93. Excel 2002: I get formulae displaying in cells rather than value
  94. compare two columns and remove duplicates
  95. Indent within a row
  96. RE: Excel macro
  97. Averages and Counts from different columns
  98. Excel add-in
  99. What formula will sort data in a separate worksheet%3f
  100. Using VLOOKUP to match similar text?
  101. How do I create a formula using data from another page?
  102. convert Julian date
  103. Count and convert text
  104. Block entries
  105. how do i create a timesheet
  106. Excel VB Run-time error '50290'
  107. how to write 'not equals blank' criteria in SUMIF
  108. Creating random passwords
  109. Excel formulas are slow to update
  110. Question
  111. Help required in merging two formulas into one
  112. how to use Excel to generate alphabet serially
  113. Can Excel compare 4-ABC-SS to 4 ABC-SS and see them as the same
  114. Countif for numbers between x and y
  115. Annualised interest rate
  116. WHY WAS THE CONVERT FUNCTION DROPPED IN EXCEL 2003???
  117. how to convert julian date to regular calendar date
  118. Sum if or some sort of match formula
  119. VB find (true false)
  120. formatting colors
  121. Formatting Time with Hundredths of Seconds
  122. vlookup
  123. Solver and dynamic ranges
  124. Opening different files in excell
  125. nonsequential cell references
  126. data in cells
  127. No entry in cell J10 if cell J7 is empty
  128. another text to column problem
  129. Fomatting part of a formula to be Bold font
  130. How do i create a conditional sum?
  131. How do I modify row column format of Excel sheet?
  132. VLOOKUP
  133. Entering multiple formulas in one cell
  134. I need help with the Sumif Function
  135. text to columns
  136. How to use functions in one cell to get text in another cell
  137. ="Z" dual use?
  138. does anyone know how to group post?
  139. Var function or something like it
  140. how do I resize the text in a validated list?
  141. Comparing prospect and buyers lists
  142. COUNTIF functions
  143. Moving data
  144. TEST
  145. Filtering by Columns
  146. Making a cell's contents lower case
  147. moving data
  148. Can Excel automatically insert current date in a cell?
  149. Convert Sub routine to Function
  150. sub totals don't work properly since upgrading excel 2003
  151. How do I empty the clipboard, when nothing is in it?
  152. assigning a unique value
  153. Can I "CORREL" statistical funtion with three or more Arrays?
  154. Read data from anohter XLS file
  155. Sumproduct Help
  156. Sum numbers based on the contents of another cell
  157. help on excel reports for anaylsis and trending
  158. Random Times
  159. How do you format a row to break accross pages in Excel?
  160. if month is less than halfway over subtract 1
  161. count number of months year to date
  162. Clearing Contents of Cell
  163. count dates within range by year and month
  164. how 2 Count number of cells that have specific condition format?
  165. excel formula counting date to date in 4 columns
  166. CountIf Function
  167. Calculate the intersection of supply and demand curve
  168. Can you convert a number to word equivalent ?
  169. equation editor
  170. chitest and interpretation of the result
  171. Combining text strings
  172. adding worksheets with conditions
  173. sum if
  174. Count using complex criteria
  175. Lookup in Matrix
  176. DIV/0! and business application
  177. opening a user form
  178. having 0 as a min when running mina or average
  179. How to Find Weekend date
  180. How do I use 'And' or "Or" in an If statment
  181. What is the formula for adding a number of days to an existing dat
  182. Insert New Row When Column Amount Changes
  183. Wildcard MATCH() breaks on long (?) strings
  184. Calculated Item
  185. i need a template to carry out vat returns in excel
  186. Excel
  187. password to open Excel file option does not exist
  188. Import External Data
  189. Using MIRR, if cash flows are monthly, should rate be / 12?
  190. Shading Cells
  191. Strange Thing Happening
  192. how do I create a if-then formula?
  193. how do I create a if-then formula?
  194. Change cell referance based on value
  195. Countif W/ 2 Criteria
  196. How do I add (auto text) to a paragraph?
  197. How do I protect formula cells on multiple sheets?
  198. Last name first first name last
  199. Logical AND function
  200. Time zone Time difference
  201. count number of years 2003 in a range of dates
  202. Copy a number from one cell to another depending on first number
  203. Identify text in uppercase
  204. How do I sum rounded values from two seperate formulas in Excel?
  205. Deleting duplicate entries in an Excel list
  206. Lookup Function?
  207. Importing data from a different workbook
  208. How do I import/convert tab delimited text files into Excel?
  209. How do I validate data from another validation cell?
  210. Need help with complex IF-THEN fomulas/functions
  211. Cell Formatting
  212. How can I use HYPERLINK in a conditional statement between sheets
  213. same data colums
  214. referencing named formula using INDIRECT function
  215. Conditional Formatting with Dates
  216. data storage from one worksheet to another
  217. What is a Conditional pull down menu?
  218. Is there a template that helps to manage condo association budget?
  219. Workbook is now Extremely Slow
  220. Data Export
  221. how do I insert a function that chooses between two text values?
  222. Conditional formatting
  223. Get info from Matrix
  224. COUNTIF with nestled IF?
  225. Data Validation
  226. Show weighted average value after filter.
  227. Sumif = and between
  228. Color a cell and a value is automatically assigned to that color.
  229. Lookup function
  230. MIRR Function sensitivity to Finance Rate
  231. how do I use the forecast function in Excel?
  232. sum errors
  233. Conditional Format Question
  234. Links in templates
  235. Max Value
  236. Formatting Cells
  237. special function help needed
  238. Inserting Rows w/formulas question
  239. combo box
  240. How do I put more than 7 IF formula in a single cell?
  241. Is there a way to have different fonts and/or formats in a combo b
  242. Update Field
  243. Returning active cell
  244. Formula to sum of every nth row
  245. Idea for an Excel function called "Spread"
  246. How do I delete blank numbered sheets after my report?
  247. data validation
  248. Dynamic sumif function
  249. Formulas for telephone numbers: finding duplicates, autoformat
  250. Visible Cells Only!
  251. Multiple If and Else if
  252. printing - creating new files on each page break
  253. Populate Drop Down List
  254. Would be nice to download templates w/o needing activeX
  255. Automatic Calendar
  256. Formulas in Excel
  257. Save worksheets to different files
  258. Complex LookUp / Match Problem ??
  259. How do I change a column in Excel from upper case to lower case?
  260. First Lower Case
  261. Production CLock
  262. Simple formulas in existing Excel 2002 no longer working.
  263. Military Time
  264. Excel Function in what appears to be an array
  265. need a formula
  266. how to calculate number ranges
  267. Control+End takes me to J2088 but the last cell is I219. Fix how?
  268. Emulate Index/Match combo function w/ VBA custom function
  269. Can distance be calculated using latitude and longitude?
  270. Multiple charts
  271. Lookup data
  272. Inserting Columns and Formulas updating
  273. Sumif - FastExcel
  274. unique occurences in list
  275. unique occurences in list
  276. Parameter description
  277. Lookup Help
  278. Subtotal excl errors
  279. Using If function
  280. how i can call the function
  281. Automatic updating of Conditional Formats using dates
  282. How do I add the sum of a series numbers generated by Rnd gen?
  283. Data Validation - Custom - Formula
  284. Referencing a newly created worksheet
  285. Convert minutes into hours and minutes
  286. count the number of times data appears on the same row from two c.
  287. Add to my Function / formula
  288. How do I nest these 3 IF functions?
  289. enter a time into a cell, have the cell show two times the entry
  290. How to create specific formula
  291. How do I make a sound as a result of an "if" statement in excel
  292. Create a sheet name, won't let me, says already sheet named that
  293. How do I insert A drop down dialog box as a 'list to choose from'?
  294. I want to sort everything but my validation list
  295. question on excel Solver
  296. Conditional format
  297. How do I get 1 cell calculate only if another cell has an "x"
  298. Add mailto (email) as function to a button in excel
  299. datafeeds
  300. How can I choose top two numbers in a column?
  301. Remove Numbers from text
  302. cell drop and drag
  303. excel msoffice97 files will not work in excel msoffice2000
  304. Merge, update, and add only new entries into a list from other she
  305. Simplify formula
  306. Loan Schedule with Balloon Payment
  307. excel function
  308. Auto Date
  309. Matching cells
  310. sumif? lookup?
  311. Sheet Tab Names
  312. Lookup cell contents in on sheet based on a formula in second sheet
  313. simplify function
  314. Negative numbers in parenthesis if not shown in drop down box
  315. How do i create a command button or macro to exit Microsoft Excel
  316. Referencing a formula (as text)
  317. SUMIF(O18:O500,"=b21"Q18:Q5) i want to do this not "=001690"
  318. Average of ...
  319. Sum Formula
  320. vlookup from multiple columns
  321. Does excel have a 'cubed root' function? How can it work it out?
  322. Solver Problems
  323. Drop down text too small
  324. redistribute a column by a groups of rows
  325. CORRELATION / COVARIANCE MATRIX
  326. data fill question
  327. a way to limit the characters allowed in a cell?
  328. overtime templates
  329. Auto Date Fill-in
  330. How do I auto copy text in a cell from one sheet to another
  331. Vlookup for part of a word
  332. excel macros
  333. How do I set the order of calculation of Data Tables in Excel?
  334. Counting Entries
  335. Calculating Overtime from Hours total
  336. the target cannot handle this type of document
  337. Concatenation using IF AND - Possible?
  338. Custom Function
  339. Default comment location
  340. How do I filter a list using a greater than todays date function?
  341. dates
  342. Conditional Formatting
  343. How do I automatically calculate YTD numbers by changing a date?
  344. LOOKUP function
  345. Lookup baseball scores in 1 worksheet and have them display in ano
  346. Enable hyperlinks
  347. RTD Problem
  348. Work with list to make 3rd column
  349. How do I lookup numbers with a MIN and MAX?
  350. Need to Escape from Excel Forumla Hell!
  351. Create Total based on lookup value
  352. Formula Problem - If Statement
  353. how do i transpose rows to clumns?
  354. date and bond calculations
  355. Track info from one w/sheet onto another.
  356. Extracting/look up data from a list and select multiple instances
  357. If function with blank cells
  358. Reveal cell formats and extendable range in tool/statusbar/icon.
  359. SUMIF function referring to values on different Worksheet
  360. XIRR function input parameters
  361. Round Up to Nearest 10
  362. Copy a formula
  363. Yes or No buttons,list,or Combo box
  364. buttons & macros
  365. Unhiding multiple rows simutaneously
  366. Finding a range from a column using VBA.
  367. Match a name to all clients?
  368. Change format to landscape for whole workbook at once
  369. Excel: Add time to a date and time column?
  370. how to add another conditional formatting
  371. How do I enter formula using % > or < = number?
  372. Format Cols
  373. Worksheet linking
  374. Protect sheet and allow grouping of columns
  375. Maintain cell links when renaming directory containing multiple f
  376. Time Formula
  377. .csv file Text to Columns
  378. Condensing one column to another without spaces.
  379. Scrolling in Excel
  380. Empty Cell ( blank Cell )
  381. Absolute Statements in Excel
  382. Can I link Contact info into an Excel doc?
  383. Advanced Filtering
  384. Summing 2 columns
  385. Average
  386. Column Reference Copy
  387. IRR data in different ranges
  388. Macro to save
  389. Command not recognized
  390. Conditional Formating Extreme Question
  391. Adding characters
  392. using a function based on the value of a function
  393. synchronize multiple worksheets
  394. adding color to the results of IF statements
  395. Conditional Formating
  396. count number of items in a row? help *file included*
  397. sum by cell color
  398. moving minus sign from right to left
  399. Can an Excel formula be created to paste a picture in a cell?
  400. Formula for YTD total of Vac. Hrs. used for spec. employee
  401. SumIF Multiple Ranges
  402. How can I make Excel Macros created on PC work on Macintosh?
  403. If function that calculates
  404. How do I create a print button?
  405. Matching
  406. <,> formula
  407. SUMIF help needed
  408. VB Stopped Working
  409. Vlookup formula using tax yables
  410. Custom Views Grayed Out
  411. How can I convert entire columns of text to Uppercase in Excel?
  412. I made a terrible mistake and need help
  413. Row reference increment but preserve column reference
  414. Excel not updating when figures are changed
  415. Excel not updating when figures are changed
  416. how do I recover a file where I accidently saved it as the wrong f
  417. Pence field to currency?
  418. How can I fit an accurate trendline and formulae
  419. Linking workbooks in 2003
  420. trimming blank cells
  421. find Max value in row--return value in same column, different row
  422. Data Validation Cell - Move to UserForm
  423. Random alpha generator
  424. how do I use vlookup for multiple occurrences of the same value
  425. Subtract entire sheet?
  426. subtotaling and manipulating a list of data
  427. Trying to count specific values
  428. Need formula to count specific cells in a row
  429. Change Text to a number
  430. Currency question
  431. HOW TO HAVE MORE THAN THREE CONDITIONS IN CONDITIONAL FORMATS ?
  432. Look in shortcuts.
  433. Sorting data in a workbook across multple worksheets
  434. Forms and Conditional Formatting
  435. RE: how do I use vlookup for multiple occurrences of the same value
  436. RE: subtotaling and manipulating a list of data
  437. Formula for pulling column I ttl in column I for each "e" row that
  438. Pivot Table
  439. Excel to acrobat
  440. Variable Link to Workbooks
  441. how do I link radio button selection to another page
  442. only last cell on page to have bottom border (cell area outline)
  443. User Defined Functions
  444. VLookUp
  445. RE: HOW TO HAVE MORE THAN THREE CONDITIONS IN CONDITIONAL FORMATS ?
  446. UnKnown Character Removal
  447. RE: Random alpha generator
  448. RE: Change Text to a number
  449. IF Function with formatting condition
  450. converting PDF file to readable excel format
  451. Help to adapt Formula syntax to work with Dynamic Named Ranges
  452. Urgent help! how to automatically resize all the charts?
  453. SQL.REQUEST help needed
  454. Excel Function lessons Needed!
  455. Sum for lines equal to criteria
  456. How do I delete 2000 pages created by Excel from my one page doc.
  457. How can I create an XML map (2003) to import to workbook
  458. excel query
  459. Function for Roman Numerals
  460. How do I Compare worksheet columns
  461. Finding or creating correct formula
  462. Can I format a cell to fill red when clicked with mouse (Excel)?
  463. INSERT LINE after Vendor name change
  464. Changeing cell size in the middle of a worksheet
  465. Sort on a protected sheet
  466. CUMIPMT #NAME error
  467. Copying data without hidden rows.
  468. How to insert logo in Outlook from Excel
  469. Static cell reference
  470. HELP required: Insert -> Hyperlink -> ???(no CHART sheet name)!!!
  471. Linking across worksheets not working as desired
  472. solve quadratic equation system
  473. how do I transpose and paste a link in excel
  474. trying to find max date
  475. Time to number
  476. Convert PivotTable data into a worksheet list
  477. HOW DO I NEST MORE THAN 1 IF FUNCTION?
  478. blank cell returned
  479. hOW TO USE EXCEL TO CALCULATE BASEBALL BATTING AVERAGE
  480. Can I propagate a date from one worksheet to another
  481. Looking for something similiar to MIN
  482. Average non continguous cells, excluding zero's
  483. Can I establish a link based on a date?
  484. LOOKUP functions?
  485. Can the =CELL formula be used to determine the worksheet tab name.
  486. Hyperlinks / server / cd
  487. Help with SUMIF function criteria
  488. How do I sum using relative cell positions?
  489. I need help w/ data on one sheet to be used on several others
  490. Counting Unique Records with multiple conditions
  491. How do I import data and display zeros?
  492. linking cells
  493. Formula for calculating time
  494. Formula
  495. Remove Line Breaks ALT + ENTER
  496. trying link row on one sheet into column on another sheet
  497. Time Sheet Calculation Help Needed!
  498. Counting rows with 3 columns
  499. autofilter in excel bug ?
  500. How can I delete similar rows in excel workbook with many sheets?
  501. how do i hide value errors until data can be entered?
  502. how do i hide value errors until data can be entered?
  503. complex if statements in excel
  504. microsoft excel
  505. COUNTIF Statement with Multiple Conditions in Different Ranges
  506. Copy/Insert rows with formulas
  507. How secure is the "lock cells" function?
  508. How to get an exact mactch with Vlookup
  509. How do I use Excel Built-In Functions in Code?
  510. IF NESTED Question
  511. Stationery Column and Row
  512. Deleting 3 Text characters from the right
  513. scenario analysis-multiple variables
  514. How do I delete a row from a spreadsheet if criteria is not met i.
  515. EDIT FORMULA BAR in excel 2003? why not? where is it?
  516. Progressive summing
  517. Solver help
  518. Common spacing
  519. Rows to repeat at the bottom
  520. Count Distinct Values?
  521. Consolidate different sheets to different workbooks
  522. i want to display the month from a date into another cell
  523. quick selection drop down list
  524. Msgbox
  525. Running code on a drop down selection change
  526. Using a Vlookup to return values in a data list?
  527. clock
  528. Excel data ( VFP )
  529. help again
  530. Removing columns (not hide or white-out).
  531. Simple lookup
  532. How to merge columns
  533. How do I set a ratio using two cells in Excel?
  534. Ignore #DIV/0!
  535. Divison by 0
  536. COUNTIF COMBINATION??
  537. how do I freeze the time in the NOW() function?
  538. How can I add the same data to every worksheet in a workbook all .
  539. I need help inserting and composing a drop down menu for individu.
  540. Excel: Solver
  541. How do I unlock a spreadsheet that is password protected?
  542. Need a good template for a phone list
  543. Summing non-contiguous cells
  544. COUNTIF with multiple criteria?
  545. Vlookup(?)
  546. What is the BEST way to add values residing in two non-consecutiv.
  547. Lookup thinks data isn't sorted
  548. If the SUM of a list is 32.2 what formula to round it up to 32.5?
  549. Sharing woorksheets
  550. ENTER A FORMULA IN A CELL TO UTILIZE THE IMPORT DATA FUNCTIONS?
  551. How do I create a reusable template
  552. Protection
  553. How do I convert figures to text?
  554. How do I convert an Excel workbook that has mulitple sheets into .
  555. Return number of current sheet
  556. Formula For Multiple Breaks In Calculations
  557. Sheet Protection Unlock
  558. Formula for displaying the lowest number of a range?
  559. Error message
  560. Letter and numeral separation
  561. How to get 'top 10' text values from a range
  562. How to find returns in cells
  563. Joining Multiple filters with OR rather than AND
  564. Conditional Format based on contents of cell.
  565. Using EXACT to Deduplicate
  566. How do you divide all values in the worksheet by 1000000
  567. Subset of one sheet on another sheet
  568. Macro or Formula to remove Text from Cells
  569. SUMIF function
  570. Show the Last entry
  571. Using function results as parameters in another function
  572. help extracting data from an excel sheet
  573. Keep the left column revealed
  574. Strip carriage return, add row
  575. Dowloading internet data to worksheet form a ".ccv" file
  576. How can I download and install ERROR FUNCTION in Excel 2003? ERF.
  577. Dates and times again
  578. XIRR function on Excel 2003
  579. Incorporating cell content into a message in a formula
  580. selecting non adjacent cells
  581. Number formatting
  582. Cell to Show "Continued" only if > Page 1
  583. IF fuction and format ...
  584. I need a daily sales sheet to pull from monthly figures sheet
  585. Apply to next X cells to the right...
  586. Concatenate text and numbers?
  587. Date & < sign I want to Conc.
  588. The reference changes when I insert a row?!?! Help
  589. Why does the macro not work?
  590. Adding numbers in a column that have 3 decimal places
  591. Excel If function alternative
  592. Please help me.
  593. math
  594. Removing house numbers from addresses
  595. Why is coditional formatting not accessable?
  596. Want VLookup to Return the row above
  597. Not summing a columns?
  598. VLOOKUP with 2 Criterias
  599. Quasi Transpose / Stacking Columns
  600. I want to use the MATCH function with the AVERAGE function but I .
  601. SUMIF with 2 criterias
  602. Golfsheet function
  603. VLOOKUP Help
  604. Is the a better way than LOOKUP?
  605. Function to set borders of cell
  606. entering rates five % higher
  607. selecting days of week using a formula in spreadsheets
  608. Last weekend of month
  609. Changing the Row_index_num via HLOOKUP
  610. divide by 0
  611. HELP SVP- EIYHER OR ENTRY OR LOOKUP
  612. Need to switch 2 columns with each other...please help
  613. Time Calculations
  614. How can I get automatic row height for merged cells with text wra.
  615. Help with using a cell in function
  616. Comparison / Check Off between 2 excel sheets. HELP NEEDED!
  617. VLOOKUP - results do not appear in cell
  618. IF statement
  619. Accumulation
  620. need help with a simple time formula
  621. Re: I would like to apply the same calculation to an entire row
  622. Autofill data in specific blank cells
  623. Date Defaulting
  624. Is there a way to import a pdf file in to Excel
  625. auto change number entries
  626. Populate 120 cell column with successive months entering only firs
  627. Protected Worksheets
  628. Sumif function with two criteria from different columns
  629. Sum only last X cells
  630. SumIf Help??
  631. Copy cells into range of cells until cell change
  632. How to remove duplicates from a list and copy new list to new colu
  633. Sum of dates
  634. .pdf hyperlink
  635. vlookup for multiple columns
  636. Default to beginning of month
  637. compare the first column and concatenate the second column
  638. Sorting a portion of a range
  639. Allow (validation) except
  640. looping a calculation until workbook closes
  641. Insert rows, keep a formula?
  642. IF function
  643. If function
  644. countif question
  645. Inserting/Deleting Spaces
  646. Change the font case of all cells in the worksheet to uppercase?
  647. Count If Function
  648. Display Format with Text & Formula
  649. Help with OR statement
  650. Cells not updating
  651. Autofilter hangup
  652. Print Rows to repeat at the bottom
  653. Replace a ; with a , and a space
  654. Same cell added to master summary sheet
  655. Stripping out imbedded spaces in a cell/row
  656. Replacing MCONCAT with CONCAT_RANGE (UDF)
  657. Excel2000 A working formula has {braces} which disappear. Why?
  658. Divide by Zero
  659. How to get difference in hours
  660. Formula for button name
  661. How can I sort this:
  662. How can I protect cells in Excel 2000?
  663. How to lookup a value from a ramge of data. Eg Column C Row D?
  664. Pivot ranges and INDIRECT
  665. Excel database - merge to Word
  666. Combining SUMIF and SUBTOTAL functions
  667. Can you combined the SUMIF and SUBTOTAL functions in a formula?
  668. function to check numeric value
  669. Need to have multiple worksheets use a single worksheet
  670. Putting numbers in excel without it changing into a formula?
  671. How can I do a "Save As" on a protected excel worksheet
  672. In Excel how do I put variables in links to other workbooks?
  673. autofilter
  674. How do I compare two lists of numbers?
  675. COUNTIF Function
  676. Fitting individual measurements into a specific length
  677. i am unable to link between two files in Excel, why?
  678. Calculation based on a condition
  679. How do I keep from repeating total on spreadsheet in excel.
  680. How do I create a Calendar Drop Down menu for a Validation cell
  681. Selecting ALL names when using Insert/Names/Apply
  682. INDIRECT syntax?
  683. text to formula
  684. Converting sum of time
  685. how do i extend the series of a portion of a formula?
  686. comare and copy
  687. Re: Add two cell values, retain it, and add another value
  688. Counting issues
  689. Array brackets
  690. subtotal by page
  691. What does "," mean in a formula?
  692. Unsure about which functions to use
  693. Need help Returning the cell addy/index of the first non-zero number
  694. Status bar totals
  695. Status bar totals
  696. Microsoft Excel CHART question
  697. How do I automatically increment worksheet number when pasting a .
  698. Unique Entries
  699. Formula that will allow you to add one to cell's value by clickin.
  700. Replacing MCONCAT with CONCAT_RANGE (in a complicated formula)
  701. Formatting issue
  702. CF for over/under mean unit
  703. Divde by zero Error
  704. RE: Unique Entries
  705. Font and size are in Excel has gone shaded. Will not let me type.
  706. need function help
  707. I cannot type in my Excel program. The Font and size area is shad.
  708. what does "," mean in an excel formula
  709. Automated Hyperlinking
  710. exel spread sheets
  711. count if function with if statements
  712. Reverse Concatenate
  713. Excel formula
  714. CONVERTING NUMBER TO TEXT
  715. Re: Function Mal-Functioning
  716. prehistoric time series
  717. Dates to number in edit line
  718. Date & time assistance
  719. Can I add blank space instead of 'FALSE' in VLookup?
  720. Calculates Qty Received
  721. ADDITIONAL FIGURES IN COLUMN DON'T ADD TO TOTAL IN EXCEL
  722. How do I conditionally insert an image (.bmp file)?
  723. Editing text after concatenate
  724. Auto Scoring
  725. command button properties
  726. remove blank lines from an entire spreadsheet
  727. Using Excel convets number to english text
  728. Can someone please help?
  729. function does not work properly
  730. function does not recalculate sum
  731. Record hh:mm:ss on click of cell
  732. Need to find the 1st two characters of the 1st two words
  733. Alert for errors on a worksheet
  734. condition statements
  735. Desperate NEED!!!!
  736. Using Excel converts number to english text
  737. Isolate rows based on highlight (Excel 2003)
  738. Re: Independently Summing Multiple Text Options Within a Cell
  739. Change caption on a macro button
  740. INDIRECT Function and Autofill
  741. Nested IF - Work Around for 7 nest Max
  742. Products
  743. Calculating net profit
  744. Vlookup and Hlookup
  745. find smallest number not equal to 0
  746. How can I make a checkbox create a value?
  747. In excel, importing from anouther sheet background colors will no.
  748. Organizing Data
  749. Check box formatting
  750. Build in Code
  751. Function Help!
  752. if sum
  753. How do I merge information from sheets on other files into the ma.
  754. Choices made available dependent on another selection?
  755. How can I merge multiple sheets from different Excel files workbo.
  756. Need help with Formula
  757. Multiple selections from a drop down list in Excel...
  758. Excel 2003 Referencing multiple workbooks via single variable
  759. bar graphs
  760. Excel renames sheet (repaired) when trying to change data from a .
  761. Excel 2003 versus 2002 seem incompatible related to the EDATE fun.
  762. sum if
  763. How do I generate random numbers using dates in excel?
  764. time/distance calculation
  765. Concatenate columns, separated by double quotes
  766. HOW DO I HIDE THE ABC ( TOP ROW ) AND MAKE MY HEADDINGS PERMANENT
  767. The UNPROTECT option
  768. More than 7 IF statements in one arguement
  769. Find and REPLACE within a selection, or column- not entire sheet/.
  770. set a yearly alert for information in cells
  771. macro vba relative references
  772. Date Conversion
  773. place empty cell with zero
  774. NUMBER OF COMMANDS
  775. column headings
  776. Run-time Error in Excel?
  777. In Excel 2003 how do you get a table to update based on lookup cr.
  778. NEED 30 -31 days for data for each month.
  779. Help to Modify these guys
  780. Vlookup and Hlookup
  781. Euro conversion
  782. Golf League Schedule
  783. reduce # of charachters in same cell
  784. Excel should allow sorting and filtering based on cell color.
  785. Input pages
  786. It's better to have it and not need it then...
  787. Counting occurences of a specific day between two dates
  788. return groups of components
  789. User Defined Functions
  790. increase my worksheet by 1.04.
  791. MACRO LEARNING
  792. Why do long hyperlinks get truncated on save in Excel?
  793. Excel Formula's
  794. DIFFERENT CURRENCY FORMATS IN FORMULA
  795. array formular
  796. How do I create a new symbol to enter as a character?
  797. Named SUM Formula with relative refernce(s)
  798. Function needed please
  799. ??
  800. does the =COUNTIF have to be a range?
  801. decimal place and merging to word doc.
  802. Countif using format criteria not number criteria?
  803. How do I use a function to return the address of a cell?
  804. Countif using format criteria....not number criteria?
  805. Excel 2000
  806. MS Excel Question
  807. Re: #NAME?
  808. Three levels of protection in one worksheet
  809. RE: How do I apply footers to every worksheet (like Word)? I don'
  810. Is there a way to go to next empty cell in a formula
  811. How to password protect a cell but still be able to sort ?
  812. Text Function
  813. Combine query to count products with similar names
  814. convert date of birth to current age
  815. IF statement
  816. Automatic Tabbing?
  817. How do I do a file compare of one excel spreadsheet to another?
  818. Can you have mulitple drop boxes on 1 worksheet?
  819. Total a Combination of Numbers
  820. A COUNTIF function Challenge
  821. formula to alert if expiring within 40 days
  822. Relocating info using Data Validation
  823. Last text value in a column
  824. Adding Data Using Multiple Worksheets to Total into a Grand Total
  825. lookup
  826. Concantenate Text with numbers with fixed form
  827. SumIf or SumProduct or If statements
  828. how do i convert payroll calculator in U K format
  829. How do I link one TEXT cell to others in a worksheet and workbook.
  830. Help with 2 values
  831. How to caculated total due on taxes
  832. Link workbooks-C drive to network drive
  833. Excel should have an unlimited number of columns available.
  834. formula to determine if cell is merged?
  835. Max Date and Item - How to get in one sheet ?
  836. Can a conditional cell formula reference data selection in a comb.
  837. MCONCAT only Visible Cells
  838. How can I format a "cell" so it come out as " /64"? Example 10/64.
  839. Can I retain a formula in the cell pasted to?
  840. conditional coloring
  841. Converting Letter Grades to Numeric
  842. Creating fixture lists
  843. Using Symbols in Drop Down Lists
  844. Using symbols for drop down list boxes?
  845. Replacing #N/A with a '0' (zero)
  846. pounds multiplied by hours
  847. vlookup problem
  848. how i can aarange names in alphabetical odders
  849. I want to check for a text value, not numerical
  850. Lookup function
  851. Macro Button
  852. intersection of row and column
  853. offset function
  854. Formula Help?
  855. AutoCorrect
  856. AutoCorrect
  857. Nested IF functions and 3 conditions
  858. how to use Ms Excel if()
  859. need help with excel
  860. i want to edit the same information in ten different files
  861. data validation
  862. sum if
  863. conditional validation formula
  864. how can I get all worksheets to print at one time?
  865. cumipmt
  866. change numbers to text
  867. Lookup Problem
  868. Macro - to copy duplicate rows to another sheet
  869. Function Help
  870. using excell to caculated taxes due on salaries
  871. finding the row index for the last value > than some value
  872. Assign numerical values to text codes
  873. Alternative to Vlookup/Hlookup to return a value.
  874. Display name that is on the list
  875. Function HELP!!!
  876. Hyperlink
  877. pulling text into a sum formula
  878. Printing
  879. hyperlinks
  880. how to add bullets in excel cells
  881. MVP...Formula expert needed!!!
  882. Lookup Problem
  883. how do i calculate CAGR for a series of years of revenues?
  884. Convert hours and minutes in time format into fractions of hours..
  885. I have a dropdown in a cell, how can I get corresponding data for.
  886. Help with functions!!!
  887. Last value in a column
  888. Vertical Scroll Bar
  889. Sheet Column Headings and Row Labels
  890. How do I clear a worksheet of values, but leave formulas intact?
  891. sumproduct question
  892. How do I insert a city map?
  893. lookup information in a row like a record
  894. Excel - pivot table - how do i format cells with data mm/dd/yyyy .
  895. lookup and replace data
  896. Lookup Troubles Again
  897. What is the best template to use to keep a log of the customers I.
  898. Saving worksheets
  899. Excel could not save all the data and formatting you recently ad..
  900. Disable Scientific Notation conversion
  901. Multilevel Sorting?
  902. Hiding cells on condition
  903. date function ...
  904. Using "IF"
  905. countif
  906. Skip holidays falling between two dates
  907. converting an arabic number into a spellout text
  908. want to remove all text characters equal to one character in length from text string
  909. Cell lock
  910. Combo Box Font
  911. need formula to get % between 2 numbers
  912. Keeping duplicate rows
  913. trying to add a complicated mess to my worksheet... :)
  914. Exporting single or double quote delimited files
  915. complicated function in excel
  916. Page breaks when using subtotals
  917. Data Valadation help
  918. How do I use VLOOKUP to search for text?
  919. How do I change months into years?
  920. ChangingNumbersToText
  921. count an entry if ????
  922. want to remove all text characters equal to one character in length from text string
  923. One More Try: Names/Apply on other worksheet
  924. Excel Row & Column Labels
  925. can i copy a tab name into a field
  926. external database file into excel formula
  927. prevent users from overwriting other users data
  928. check if 2 cells are equal but only if they contain numbers not i.
  929. check if 2 cells are equal but only if they contain numbers not i.
  930. {SUBTOTAL(2, IF(This = That, LIST))}
  931. warn me when text appears
  932. Using trim feature
  933. can i get excel to warn me if text appears in 3 different cells
  934. coditional formatting
  935. Return quantity outstanding
  936. Formula for adding a comma in front of text in a cell
  937. Referencing cells text output if it meets specific conditions
  938. OR Operator
  939. SPACING
  940. any idea??
  941. I want to make all of j equal h plus i.
  942. formula in a cell or not?
  943. how can i fix one entire column after putting my formula there so.
  944. how can i hide digit 0 after putting any equation
  945. What formula is used to add or subtract minutes from a time in a .
  946. How do I correct the #DIV/0! error?
  947. Hyperlinks from a List, Excel 2000
  948. Macro to Copy Worksheets
  949. keep the 0 as the fiirst number in a set
  950. input sheet
  951. Excell 2000 worksheet
  952. Copy row sheet-sheet skipping unqualified cells
  953. how eliminate zeros in blank cells using paste link
  954. new cell with changes
  955. Using "IF" and "AND" statements with current time
  956. I had template that when you changed date of the event, it automa.
  957. if statement
  958. Open dialog box size
  959. Excel
  960. Formula help. Different result dependent on answer
  961. Formula changes while inserting a row !!!!
  962. howto select distinct values from list
  963. How do I run a Macro on basic of a value in a specific cell
  964. Return Count for LAST NonBlank Cell in each Row
  965. Lookup Problem
  966. Compile numbers from multiple worksheets
  967. Hyperlinks from a List, Excel 2000
  968. Dates Again!
  969. Find percentage Trend
  970. Help with Dates!
  971. How do I create a formula in Excel that finds the value of the la.
  972. Thank You
  973. Can I display the file properties of a workbook in a custom headi.
  974. split cells with Alt+Enter
  975. Is there a way to retain a formula while performing cut/paste?
  976. Open Excel files in seperate windows
  977. Copy sheets with more than 255 chars in a cell?
  978. hyperlink question
  979. Subtracting Time
  980. Lookup help
  981. How do I create a combo drop down list in Excel?
  982. DATE FORMULA
  983. Summing Returned Positions using MATCH
  984. Modifying a Formula To display only Unique Values
  985. deleting internet links
  986. Alt+ #s
  987. linking problem with closed documents
  988. calculate monthly average percentage of change
  989. change excel row height without showing hidden rows
  990. Hints And Tips For New Posters In The Excel Newsgroups
  991. countif
  992. How do I calculate dates?
  993. Birthdate Formula
  994. Birthday Formula
  995. How do I enter functions for an amortization schedul for IPMT and.
  996. Checking if value is in a list
  997. How do I print vertically? (example A-T)
  998. Quartile / Quintile Function
  999. Using a MACRO to sort data
  1000. Importing data into an existing workbook