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. a number is replaced by text when inserted anywhere in the sheet
  2. latest entry
  3. Macro recording problem.
  4. Excel Timesheet template
  5. Auto color-shading of rows
  6. Calculate Interest Rate when payment changes!
  7. Excel to COUNTIF if number greater than one but less than another
  8. data validation using vlookup
  9. Combine contents of multiple workbooks into one worksheet
  10. How to lookup row # based on content of another column's cell
  11. Excel Won't Calc?
  12. Shortcut to refresh format cells
  13. Warning message on file close
  14. Microsoft Press book - Data Analysis and Business Modeling
  15. I need to create an array formula combined with a countif
  16. Auto Record Transfer (2)
  17. Create a summary list without using PivotTables?
  18. An array and countif based on criteria in each column
  19. If I don't have MS equation installed in my MS excel how should I
  20. sum from many worksheets
  21. creating formula using if function
  22. conditional formula in every third row and last row.
  23. cell address of occurence of a vlookup formula
  24. Lookup Array Formula
  25. Use of pre-defined lists
  26. is there a conflict between afxdisp.h and atlbase.h
  27. Pivot table problem...
  28. If Function Help Please!
  29. Sorting a Concatenated Range
  30. Conditional formula date
  31. Label
  32. Problem occur in sum function while deleting the rows
  33. help with nested IF statement..
  34. Automatic List Grab?
  35. rounding off month
  36. multiple selections in a sumif functions
  37. CountIf
  38. How to compare two cells for the same numbers
  39. How can I type Excel numbers to show as a barcode?
  40. lookup formula
  41. Can I change the font/shading of a cell by moving the mouse over i
  42. Count If
  43. Formatting Columns
  44. How do I show the contents of a dropdown without showing the box?
  45. How do I sort the data in 8 columns by two of the columns?
  46. Can you link an excel spreadsheet to an outlook calendar
  47. Multiple Criteria using countif
  48. Commission formula
  49. Issues with saving text file
  50. Intervals as logical statements
  51. Referencing Corresponding Values
  52. Formula
  53. Unique records of matching pairs
  54. Counting unique records based on date range
  55. How can I sum every third cell in a row in Excel
  56. lookup and if?
  57. formula(excel) to skip cells having - number and add + one
  58. filtering row data
  59. formula in excel to skip cells having - number and add only +
  60. Newbie - Need help with zipcode format- no options for cell
  61. Picking one column of info
  62. using =COUNTIF to count two text values
  63. Link To Drop Down Menu
  64. Concatenation Problem / VBA ?
  65. max value
  66. How do center headings across columns in excel
  67. formula to transpose
  68. Combine Indirect and Sumif
  69. Delete Row Macro - if cell > $5000
  70. HELP! Nesting IF Statements/Dependent Dropdown List
  71. Help! How can I get data from one sheet to another
  72. Templates
  73. REPLACE Function
  74. How do I sequentially number every third page of my workbook?
  75. last four digits of a social security number
  76. Sumproduct if column begins with text
  77. Split data from one cell to two separate cells
  78. how to run a macro when a calculation equals a certin number
  79. how to run a macro when a calculation equals a certin number
  80. #REF!
  81. Summing hours
  82. Lookup a value using two columns
  83. Excel IRR calculation
  84. if function
  85. How to print everything in a cell
  86. URGENT need help with if/then stmt.
  87. calculation
  88. ranking
  89. List Box Selections
  90. Sort Columns in Protected Worksheet, etc.
  91. Return Range of Numerical Values in Single Column based on Frequency Percentage
  92. conditional formating??
  93. HOW TO EXTEND A NAMED RANGE
  94. Which lookup should I use?
  95. How do I multiply a unit measurement?
  96. offset? match index? sumif? 2way look-up?
  97. Sumproduct #N/A! error issue
  98. Generate random numberes using reference to the other cell.
  99. Data Validation
  100. Validation
  101. How do I print out selected worksheets one after the other
  102. Page Number of a cell
  103. my comments are disappearing from a shared excel workbook
  104. Populate List Box
  105. how to identify
  106. How do I put in more than 7 validations in IF FORMALA in EXCEL
  107. DATEDIF Simple request
  108. ISNUMBER and VLOOKUP Help Needed
  109. moving cells
  110. Getting data from another worksheet
  111. Capturing a date field once only
  112. Index and Match - the next step
  113. How do I calculate IRR using monthly cash flows, not annual?
  114. How to produce(move) an embedded image using a formula?
  115. now()
  116. Macros/Formulas
  117. A simple listing desire...
  118. COUNTA with IF trouble...
  119. Not sure if question is "if-then".....
  120. Advanced Date Functions
  121. In Excel, option to enter text in cells the same as text boxes
  122. Data Validation and Blanks in List
  123. Need to indirectly reference columns >26 using A1 notation based on numeric column number- how to?
  124. Protected sheet to unprotected sheet
  125. How to have a the liist items appear at the top, not bottom
  126. Can you copy multiple tabs from formulas to values w/o paste spec?
  127. Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA
  128. Status Bar Autocalculate Width
  129. shorten formula
  130. Last cell used in SUM IF formula
  131. Deleting Duplicates
  132. Need a Formula
  133. Auto sort a linked sheet
  134. Repeating data in a Pivot table
  135. Can I copy the formatting of a cell in a IF Fucntion "VLOOKUP"?
  136. how get filename with worksheet function?
  137. Count multiple data by date
  138. find an average from a range, utilizing all data > 0
  139. How many similar functions can be put in one cell?
  140. In Excel, can a function yield a drop-down list?
  141. Consolidating spreadsheets
  142. Pivot Table Fields
  143. look up one value and return a corresponding value using lists
  144. How can I sort by the value of my formula and not actual formula
  145. how can I get analysis toolpack for anova calculations
  146. Formula using IF, AND and OR Arguements
  147. I'm sure this is an easy one, but....
  148. Importing CSV data into a template or?
  149. My formula in Excel 2002 reads: =12.08*85.60 result 1034.048
  150. subtraction in a list of numbers that resets with a label.
  151. What formula/fn would I use to count multiple condition records?
  152. Can't add page breaks to multi-sheet job except for first sheet? h
  153. Multi-lookups on variable data
  154. Need crosstab function in excel
  155. auto cut and paste...
  156. Converging two lookups? (would save me AEONS of time!)
  157. how do i only see subtotals in a pivot and hide the detail
  158. Last value & if,then
  159. Here's an EASY one for you, not me :(
  160. how to hide the formula
  161. Sum values Col.A w/ indntcal values in Col.B, w/o naming Col.B val
  162. Cell reference problem
  163. i want to find a value in a refference array
  164. zeros generated by a calculated item in pivot table
  165. Finding constants in formulas
  166. how do you split a cell within the same column?
  167. Average Calculation
  168. How to see macro code of a password protected macro without a password?
  169. text as an argument of SUM function
  170. Omit the first word from a cell contain text
  171. Across a worksheet, which cells I have formatted as locked?
  172. Conditional formating using formulas
  173. Vlookup is not enough ... can OFFSET be used ?
  174. Difference between Cells
  175. Summing large columns
  176. loosing test fomat after using replace command
  177. Joint ranking (never seen a satisfactory answer!)
  178. Match Infomation
  179. HOW CAN DUPLICATES BE DELETED,NOT FILTERED?
  180. Search multiple values to return single values
  181. Remove single spaces
  182. Advanced Filters
  183. Is there a way I can autofilter columns instead of rows
  184. My view has changed, I want same view as when opening excel
  185. Excel Formula Error
  186. Repositioning a cell based on its value
  187. Unique value in a list
  188. Sumif - double columns
  189. Search multiple values & return single value - seperate worksheets
  190. How can I get Excel to find the first number in a list greater tha
  191. Fiancial Calendar
  192. What is wrong with this formula?
  193. How do I multiply cell value by percentage?
  194. Deleting links to other spreadsheets
  195. Excel 2000
  196. SUMPRODUCT question
  197. Button in Excel that will save the form?
  198. Lookup? for more than one criteria
  199. troubleshoot absolute value
  200. is there a macro which will allow me to copy/paste another documen
  201. Clear Contents Macro
  202. How do you enter a ratio e.g. 100:1 into a cell?
  203. Copy complete row
  204. IF statement using multiple criteria
  205. Updated cells
  206. Sumif() help
  207. 3D Count in all worksheets
  208. Re: Sumif() help
  209. how can I sort alphanumeric entries by number in excel
  210. populating a list box with weekly dates
  211. cell format in Excel 2002 SP3 will not accept long numbers
  212. Text from one sheet cell to appear in another sheet cell
  213. the scroll wheel button should have an optional pan feature
  214. Data Validation Error Does Not Work?
  215. convert time imported as text to time format for calculations
  216. Clear Cell based on event w/o macro?
  217. feel that the STANDARD DEVIATION formula on Excel is incorrect !!
  218. Conditional formulas: color code text populated cells?
  219. Re: Clear Cell based on event w/o macro?
  220. Freezing panes--splitting spreadsheet into quarters
  221. another interesting thing...
  222. Function or VBA Help Needed
  223. I can see th formula result in the dialog box but not in the cell
  224. How do I delete or remove additional blank pages of a worksheet?
  225. Macro Save File (Unique file name)
  226. Multiple Column Index Number in VLookup
  227. Section Breaks
  228. Sum Product
  229. Spinner box in Excel to adjust date
  230. Sorting by Scripture
  231. Sumproduct and offset
  232. How do I round up fractions to the next whole number?
  233. Overtime Question Unlike Others (Pictures Included)
  234. conditional search
  235. Proper Function not working
  236. conditional search
  237. Excel 2000
  238. combo boxes
  239. adding amounts according to labels
  240. How to get a row consecutive from a sheet to another
  241. Estimating figures
  242. merging columns - one date, one time
  243. print files & subfiles fo we can organize them
  244. Something like CEILING or FLOOR
  245. random number question
  246. datedif problem
  247. How can I share information between multiple sheets in Excel?
  248. Re: drop down list and row extraction
  249. Is it possible to combine MATCH & IF to search an excel sheet
  250. What Formula Q
  251. Formula to give 5%rise in a figure if it occurs b/wn 2 dates
  252. How to convert numeric value to mins and addimg mins to Hrs.
  253. Multiple Criteria
  254. 2 or more lookup values
  255. Alphabetically reorder a text string with multiple words
  256. How to get the values using a condition refering to the other column
  257. Alphabetically reorder a text string with multiple words
  258. Nested Vlookup or alternative?
  259. How do I replace a return value of #N/A in a vlookup with zero?
  260. trouble with documents after upgrade
  261. Lookup help!!
  262. when i delete a row in one worksheet, how do i...
  263. looking for ideas for calendar in sheet with separate months
  264. Looku values
  265. IF with OR Question
  266. MS Excel Cell Formatting
  267. In the worksheet_change event, how do I determine what occured?
  268. Excel Cell Format - 2
  269. How can I Lookup and sum payments for cash flow forecast?
  270. How can I cross reference 2 excel docs to look for duplicate info
  271. Project Management Schedule
  272. Need No Blanks List based on two conditions
  273. How do you assign clip art to a cell?
  274. Worksheet IF Functions
  275. Get cell value with multiple criteria lookup
  276. Choices for User
  277. Strip text before character
  278. Re: Strip text before character
  279. Absoulte referencing between worksheets
  280. Using CountIf with criteria on another sheet?
  281. Selecting Worksheet by it's value originally given
  282. Need help with this function
  283. Using CountIf with criteria on another sheet
  284. SUM OF GROUPS
  285. bibliography cards for research paper
  286. I Need a formula to evaluate a cell with + or - values
  287. Real RATE of return using =RATE illusive, inflation adjusted inflo
  288. Sharing and Solver
  289. Need know what are valid SUMPRODUCTS arguments and functions
  290. Lookup Problem
  291. deleting values in a worksheet without deleting the formulas
  292. hours to fractions
  293. book selection when using move or copy tab in excel
  294. Copying & pasting formulas
  295. OWC - Saving An WorkSheet As Web Page
  296. rows 1-2 missing from excel worksheet
  297. duplex print after each total page only
  298. duplex print after each total page only
  299. Return Numerical Label for LAST value Subtracted to reach Sum Target Value
  300. Formula help for complex formatting.
  301. IF(<criterion across sheets>,1,0)?
  302. How to LOOKUP the last value in a column on another worksheet?
  303. how do i stop excel from changing a dash to a zero in a cell?
  304. Is there an Excel function to shade cells?
  305. Display row number of the last value in a column
  306. Re: Preventing Duplication
  307. How to Specify a range using another cell vale instead of row number
  308. how to calulate time in hours cbetween two different dates?
  309. simple find
  310. COUNT.IF, how to include single cells
  311. Calculating the number of cells containing dates within the last m
  312. Opened Autosave but when closing workbook Autosave closes itself
  313. Formulas and/or formating
  314. Headers getting lost in multiple sort
  315. How do I write a formula in excel that calculates payroll?
  316. Help with PV calculations
  317. calculating data
  318. if function constains date
  319. PV of uneven stream of cash flows
  320. list generating
  321. Chart Help Needed
  322. Multiple IF functions
  323. how would you do A40-20 = aA20, the value 20 is in another cell
  324. sorting master sheet messes up cells in other sheets linked to it
  325. sorting master sheet messes up cells in other sheets linked to it
  326. link between sheets get messed when master sheet is sorted
  327. how do I prevent a RAND number from changing
  328. I dont think there is a formula to do this
  329. Extracting specific data from a cell
  330. Separating names
  331. How do I show number of resources by hour in excel?
  332. Moving cells
  333. Conditional Formatting - Can I select a select with Conditional Formatting?
  334. IF Formul
  335. How do I set a rule to add a number, but only if it is positive?
  336. valid formula doesn't work in 2003 version
  337. How to merge one cell from many workbooks to one cell on one work
  338. I have several old WQ! files - how can I open them in Excel?
  339. How to extract the data
  340. Test
  341. Date Format
  342. different tables
  343. substract cell F from cell H and total into cell I
  344. GO TO
  345. Sum box at bottom toolbar of Excel
  346. Templates in Spanish
  347. Conditional formatting depending a range of cell
  348. understanding dash dash in a excel formula
  349. Permanant button for macro
  350. Re: Permanant button for macro
  351. How do I display the user details in a XLS sheet?
  352. Data Validation List Length
  353. Commission Calculation
  354. Monthly Totals
  355. Radio Buttons
  356. Indirect in combination with ROW
  357. Begins with as criteria in function
  358. formula returns error in version 2003 only
  359. How do I set up a notification for expired items in Excel?
  360. Text to columns delimited by carriage return
  361. DIAS.LAB function poblem
  362. IF text statements
  363. 12 digit code sorting
  364. linking cells
  365. RE: Max and MIN question
  366. Max and MIN question
  367. Can I apply Cond. Formatting to a Formula result?
  368. Sum YTD Budget
  369. update multiple worksheet in single book
  370. How do I ignore cells with errors when calculating an average?
  371. Cut command
  372. Custom export with multiple rows for each row in original spreadsh
  373. How to create a combination chart?
  374. Excel worksheets
  375. Progressive Calculation
  376. If True Concatenation
  377. Goodness of fit function
  378. Loading Office 2003 Service Pack 2 conflicts with Excel Subtotal
  379. blank values
  380. Combining sheets on one
  381. Can Excel calculate the effect of extra principal on loans?
  382. large / sumproduct combo
  383. adding color to cells based on a formula
  384. Showing Mininum $ for items
  385. How do I connect 2 Excel Sheets to give auto answer on the 3rd
  386. anova post-hoc analysis: tukey test
  387. Uge nummer
  388. Countif with star operator in criteria
  389. UK Postcode formula
  390. Hyperlinks change path on save in Excel 2003
  391. blank cells with auto fill in excel
  392. nested formula HELP!!
  393. index / match ?
  394. How do I auto fit when the cells are merged together?
  395. Setting to Keep a Spreadsheet in Front Window
  396. Vlookup returning Hyperlinks
  397. sumproduct
  398. Week ending
  399. Need Help with Replace Function
  400. Can excel take content from another cell and add information either side??
  401. Historical Quotes
  402. # of Worksheets
  403. Find a "date" in a column of dates in Excel 2000
  404. how to fourth root a number on excel
  405. Lookup Value between 2 ranges
  406. formula to differenciate whether a cell contains a funtion or numb
  407. Formatting data within an equation
  408. Function or Formula
  409. Re: Need Help with Replace Function
  410. Mortgage Calculation Question/s
  411. Yup - another question!
  412. I need a " IF THIS THEN _" formula
  413. j2thea
  414. toclearasell
  415. How do I write an 'if exist" statement
  416. how do i sort a column numerically going from 01-01 to 225-99
  417. Vlookup using text
  418. Pull and store a value on specific date in another cell
  419. create formula to add 15 minutes to previous time value
  420. excel formulas
  421. Counting Expression in a Single formula
  422. Has anyone had formulas change automatically with no explanation?
  423. Simple find with right function
  424. redistributing figures based on %
  425. SUMPRODUCT as array formula?
  426. format combobox in userform to accept dates
  427. Convert Text to Number
  428. formula or macro
  429. how to I make an excel spreadsheet into a label format?
  430. deducting the same percent in a column
  431. Activex Text Box Protection
  432. Excel should let me change the form data arrange direction
  433. function
  434. numbers to time
  435. Hourly rates
  436. Range Lookup in VLookup ?'s
  437. embeding a picture into a cell
  438. color the interior of a range
  439. how to let the userform autosize depending on the screen resolution
  440. Why does / key act like Alt+F and highlight file menu not type /
  441. Returning one text value in a long list?
  442. Distribution of reporter cells according to a specified column
  443. Need to Sum Mon-Sat each seven days; Average Sunday
  444. Excel-links in worksheet shows #Ref
  445. 2003 compatibility with earlier versions
  446. Using a cell value for row in R1C1
  447. Formatting Question
  448. multiplying with excell
  449. Estimating costs
  450. Calculating Cells n% displayed in a cell?
  451. Blanking out a field
  452. Changing a Formula in Conditional Formatting
  453. Data Validation or Conditional Format (or combo of)
  454. Interpolation
  455. Extract Numbers from Alpha-Numeric String
  456. Text displays as ### in a cell.
  457. Conditional Formatting
  458. Currency button
  459. Formula for a time card
  460. how do I print address labels from an Excel Spreadsheet
  461. Size of a Worksheet
  462. Random Date Generation
  463. Excel XP - Printing multiple worksheet in a workbook
  464. Creating a Web Query
  465. excel formulas not copying
  466. double lookup
  467. Sumproduct
  468. Is there a formula in Excel to calculate a loan amount?
  469. len function
  470. Extrapolate numeric values from text string
  471. Convert weeknr to a date
  472. sort worksheet without affecting workbook
  473. Getting corresponding test value to a MIN function
  474. IF Statement Help please
  475. Extract Fractional Numbers as Numbers NOT Date
  476. edate function
  477. convert excel spreadsheet to a calendar?
  478. can't find custom function code
  479. Copy data to another column Macros
  480. Formula Constant
  481. subtotal a range of cells on a different worksheet
  482. Cell Validation
  483. How can the count of filtered records always display?
  484. why does this appear when i hit the = sign : =[ or[=
  485. Text to Number
  486. Can I retrieve a value and its format using the minimum function?
  487. hide sheets use data
  488. Translating an IF formula from Lotus 1-2-3 to Excel
  489. trying to archive need suggestions
  490. How do I hide #N/A, ### in cells not yet worked on?
  491. How do I always insert last cell from a increasing array ?
  492. SUMIF With Multiple Criteria
  493. Why doesn't my resized worksheet have a minimize or close box in .
  494. Compare worksheets and generate list of missing data?
  495. Vlookup based on designated occurrence of value
  496. Re: Conditional format combined with functions
  497. How do I write a formula in Excel
  498. Split data in column
  499. formula to calculate future date from date in cell plus days
  500. help with vlookup across multiple worksheets
  501. Formula to predict a future date
  502. formula that calc the diff in time, with a less than function?
  503. Complicated conditional formatting if numbers match across a data set..How?
  504. Unusual data format
  505. dividing columns
  506. Sorting imported .txt data in Excel
  507. formula cut and paste
  508. multiple hits in random sequences
  509. following a hyperlink
  510. Convert mins:secs to seconds only
  511. Just a test message to be deleted
  512. useform autosize to fullscreen problem
  513. How do I read a file name into =[BookA.xls]Sheet1!$a$1?
  514. Charting
  515. Moving week numbers
  516. Moving a sheet from one work book to another?
  517. Editing Repeated Text
  518. Hide 0% figures in Pivot Table
  519. listing and selecting data
  520. Calculate Total Sales from a Database
  521. Multi column Drop-down tables.
  522. Countif using Wildcard * and number 1
  523. Using VLOOKUP across multiple files
  524. Payroll analysis
  525. Reflecting info between an excel file and a word one or two excel file.
  526. Locked & protected cells still can be changed
  527. how can i do a (fx) visible in a cell
  528. countif function
  529. How do you create an Excel Gantt chart with double bar per line item ?
  530. how do I include advance payments in the PMT function
  531. search all tabs for tab name specified & lookup reference?
  532. How copy Excel macros from Excel XP (or before) to Excel 2003?
  533. Eliminating blank cells in a list on a ROW
  534. How do I fill the upper or lower half of a cell with color?
  535. significant digits for decimals
  536. Adding a column that used X's
  537. Finding a value within two rows
  538. Time stamp that does NOT update
  539. Printing in Excel2000?
  540. RE: Navagating issue
  541. "IF" function - 7 nested limit
  542. Counting the number of times a specific character appears in a cell
  543. Locking linked cells
  544. VBA Code To have a macro repeat on all sheets in a workbook
  545. Can I set up a sort by clicking on table a heading
  546. checkbox?
  547. how to format Doe,John to Doe, John (space after a comma)
  548. matching the column b(sku)c(count)with A
  549. IF Function
  550. Has anyone successfully used NETWORKDAYS with arrays?
  551. Income Tax Payable from table with escalating marginal percentage rates.
  552. How can I using Excel custom document properties in the header?
  553. How do you link 2 drop-down menus?
  554. what is the maximum number of vlookups in a given workbook that E.
  555. Update one spreadsheet and reflect on another
  556. Is there any "autonumber" in Excel?
  557. Help with IF Statement
  558. Links only update when external workbook is open
  559. external import of multiple worksheet data & create pivot table
  560. macro for new sheets
  561. How do I display colour on my EXCEL spreadsheet?
  562. Dates in Excel
  563. IF formula works one way and not the other
  564. create a list of single values from multiple values
  565. Add a unique formula
  566. overcoming nested IF limitations...with VBA?
  567. excel spreadsheet into address labels
  568. isolating different aspects of worksheets...as objects? through section breaks?
  569. PLEASE HELP
  570. how can I get the name of the active worksheet?
  571. Referring to Cells in a forumula using a function
  572. =if(and(....
  573. Limiting the range of a lookup function
  574. Comparing and Merging data
  575. create reference formula that looks through all sheets for matchin
  576. Is there a pull down Box to alert for minus balance such as ($5.00
  577. drop down box
  578. Number of hours worked between 18:00 and 06:00
  579. could someone help!
  580. simple MAX + comparison formula
  581. Want #VALUE! to show as blank cell
  582. RSQ function gives incorrect result
  583. How to add an ActiveX control in Excel?
  584. Mathematical explanations/equations for Excel functions in "Help"
  585. Excel formula that sums if meets two requirements.
  586. Count cells with strikethrough font?
  587. excel formula to enter "0" if cell blank
  588. Link A Cell In O ne Workbook To A Formula In Another Workbook
  589. How can I correct this Time formula
  590. Range used in a macro needs to be variable
  591. Excel Holiday Roster Calender
  592. date format
  593. Ordering fields formatted YYYY Mth in a Pivot
  594. Pulling in the path to a filename
  595. How can I include bmp file in excel 2000 header?
  596. How do you Stop Entering Duplicate Data in a Column?
  597. How do I get my worksheets to print in the right order?
  598. Creating a list in sequential order
  599. How to blank a cell with a formula
  600. Array formula help please
  601. linking sheets
  602. how to change a color of cell 2a to blue if 2b contains a value?
  603. Conditional Format (month and year) = Today()
  604. How do I count a named range for a specific word or acronym?
  605. How to calculate the RATE in annuity?
  606. Excel: custom header - is it possible to paste into header?
  607. how to calculate commissions
  608. Replace on a password protected sheet
  609. Converting numbers to text
  610. I am trying to set up a spread sheet to enter some real estate dat
  611. how to do a spread sheet
  612. Today() & Now() function
  613. Sumif
  614. The conditional format function
  615. Getting Excel to Calculate All Combinations of a Set of Data?
  616. sumproduct based on format
  617. Find a "9" within a range using a function (T/F)
  618. Using MAX to reference a row
  619. Confused beginner
  620. Excel puts a 0 at the end of my number
  621. adding rows of hours and minutes to get a total
  622. problem using "<=" with SUMPRODUCT - PLEASE HELP
  623. RE: Average given criteria, HELP!
  624. Hyperlink Formula to call up browser
  625. separate worksheet into multiple worksheets by grouping
  626. right function on pasted link
  627. NETWORKDAYS question
  628. Cell reference in diff worksheets
  629. Conditional Formatting
  630. Beyond Conditional Formatting...
  631. Conditional Protection of Cells
  632. question about SUMPRODUCT
  633. unable to open file
  634. Hide text in shaded cell
  635. Formula writing problem
  636. Function to return last entry in a column series?
  637. column and row headings
  638. IRR Guess Problem
  639. don't allow users to assign the cntrl+s as a short cut for macro
  640. Converting functions into numbers
  641. excel input 0 when cell blank or deleted by key or spacebar
  642. RE: subtotal
  643. Some rows sort incorrectly in Excel. How do I correct the problem.
  644. how can I fix a #value! error?
  645. RE: Finding Min Cell values excluding zero in alternate columns
  646. YEAR and MONTH confusion
  647. Finding Min Cell values excluding zero in alternate columns
  648. Reference Formulas
  649. linking columns
  650. Re: subtotal
  651. After adding Analysis Tool Pack, still no PRICE function, why?
  652. I need to combine 30 columns into 1 or 2
  653. How to return a value Referring to the other cell.
  654. How to highlight a row containing specific phrase?
  655. Data from one sheet to another
  656. how to lookup a value and return multiple corresponding values
  657. Workingday Calculations
  658. how do i sort by numerical prefix ? 1423 would come before 850
  659. How to add date format into if statement?
  660. HELP on COUNTIF
  661. Problem sorting cells containing hyperlinks
  662. Auto Selecting Cells
  663. New Menus - attaching but menus are reset
  664. Lock row in Excel
  665. change the colour of text in cell for minus figure
  666. Percentages
  667. Bessel function/directivity function
  668. Setting up a fiile/template to generate a new number when opened?
  669. Finding Bad Web Queries
  670. Dynamic Average
  671. MATCH Limitation?
  672. How to make data in one workbook appear automatically In another
  673. mortgage calculator formula
  674. Creating a league table based on results
  675. range of cells from + to -
  676. want sumif function's range to evaluate 2 columns
  677. E-mail sent for a cell in a sheet that lists a birthday as today
  678. In 2 Excel worksheets, I am trying to eliminate duplicate entries
  679. Why have my Excel Macro Shortcuts stopped working?
  680. How can I use the same validation for an entire column?
  681. Merging Text Help
  682. event macros - xl 2003
  683. How to Append the Data to the Master Table
  684. Average, IF
  685. I WANT TO ADD A TWO RANDOM CHARACTER SEQUENCE TO A SET OF ROWS
  686. Vlookup worksheet function
  687. Conditionally Fill a sheet row if cell value in another sheet >0
  688. conditioning
  689. How to add auto remender in worksheet
  690. How do I merge 2 excel spreadsheets containing some common info?
  691. Need cells to show as zero or empty
  692. counting 0 in a row
  693. Counting Age
  694. pricing problems
  695. Conditional Equations in Excel
  696. RE: need a function to calculate a mortgage payment
  697. conditional subtotal counting
  698. RE: Look up a list of prices
  699. need a function to calculate a mortgage payment
  700. Formula Help
  701. Complicated IF Formula
  702. How do I lookup a corresponding value in another table
  703. Columns with "zero" width
  704. HELP ME PLEASE
  705. import external data too many rows for one worksheet
  706. CHK file in excel link files
  707. "Rows to repeat at top" option under page setup
  708. Re: {=AVERAGE(IF((C3:C325<M4), C3:C325))}
  709. VLOOKUP Problem (limitation)?
  710. Formula which splits principal & interest pmts on P&I Loan
  711. rows that need deleting
  712. Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(.
  713. Consolidate Woorksheets
  714. counting text
  715. How to generate a list of randomly selected numbers within a range
  716. Non-Blank Cells: Conditional Counting
  717. Need to derive combinations for 4 elements each with 3 possible va
  718. Counting te days worked in a month
  719. Text moving
  720. How many IF are authorized?
  721. Change text within multiple functions
  722. Multiple IF
  723. Complicated counting of cells (based on other cells contents)
  724. Help w/ counting multiple columns based on IF criteria
  725. Protected sheets and cells
  726. Calc Diff Between Two Julian Date
  727. Drop-down boxs
  728. Logon Screen
  729. Protect Workbook vs Worksheet??
  730. Can you create a formula to add 1 to the # you enter
  731. Delete Formula
  732. Searching for a particlar value and matching to a name..
  733. IF statement containing OR
  734. Comparing Lists
  735. Excel columns do not add correctly.
  736. Worksheet name in function
  737. How can I display a "sliding" range?
  738. Calendar - vlookup based on dates
  739. Time Sheet frustrations
  740. how do I use if formula using dates?
  741. Can an Excel Spreadsheet automatically sort new data?
  742. splitting names can't see whats going wrong (Save My Sanity )
  743. Re: splitting names can't see whats going wrong (Save My Sanity )
  744. extract name when a date in another cell gets near
  745. How to Count Rows with defined values in multiple columns
  746. Autofilter with Subtotal Sumif
  747. Formula Help
  748. Is it possible to insert a macro command in an "IF" function?
  749. lookup tables
  750. Detecting when a user deletes a row
131