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. HOW DO I HAVE A CELL DISPLAY INFORMATION BASED ON 2 OTHER CELLS
  2. Freezing rows & columns
  3. Freezing rows and columns
  4. Tab Properties
  5. Need help with HLOOKUP and MATCH functions
  6. Filter not finding all cells in columns
  7. how do i unhide column after saving file
  8. Conditional Validation
  9. vlookup
  10. Equity buildup calculation
  11. Need Help with SUM function
  12. Formula ? Return value from rightmost non-blank cell in a row of
  13. Excel Help
  14. Time Calculation
  15. Indirect and Address in Reference to other sheets
  16. need help with formula
  17. conditional count
  18. How do I use turn GETPIVOTDATA function off?
  19. Sumif function with remote cell references
  20. Sum rows in groups
  21. How do I consolidate data from many pages to appear on one page
  22. function to find which cells add up to a given total?
  23. Lookup function
  24. Problem with Solver and Integer constraints
  25. How do I calculate without decimals in excel?
  26. "Saturday as a work day?
  27. CNTRL + END is not working properly
  28. How to calc percentage
  29. how to reverse a range/array?
  30. subtract 10 from every number in a column
  31. ... If - Then ...
  32. Dialog box needs to pop up (Excel)
  33. Australian "Payroll Calculator" worksheet??????
  34. return most frequent objects/numbers in large worksheet?
  35. Average from 2 unsorted lists
  36. Average MTD percentage
  37. delete #N/A's in Excel
  38. importing data from Excel worksheet to another worksheet
  39. Annual From Monthly Cashflow
  40. fiscal quarter data validation
  41. Search Function
  42. Conditional Lookup Functions
  43. Compare 2 column list across 2 sheets
  44. how do I calculate hours from a schedule
  45. What's faster? 1 workbook or multiple workbooks?
  46. is there a way to export just 1 worksheet of an entire workbook
  47. adding extra text into an existing column
  48. Can someone please help me
  49. Goto statement in an IF function
  50. Data Validation for Weekday entries only
  51. Creating an Excel TOC
  52. matrixed table out of pivot
  53. Spreadsheet sorts when saved
  54. Tournament Schedulizer?
  55. HOW DO I TOTAL A FILTERED LIST TO EXCLUDE THOSE EXCLUDED BY FILTE.
  56. add zeros
  57. How do I calculate a MTD total - yesterdays sales in Excel?
  58. Changing the Name of the Column in Excel
  59. Deleting rows based on a cell value
  60. How do I change column headings from A,B,C to actual words?
  61. Returning list values
  62. Assigning ranges for values (e.g., $1,005 the range is ">$1K to 5K
  63. Running Total with conditions
  64. Index of protected sheets
  65. sorry
  66. Date & Time problem
  67. Time Sheet Function
  68. Removing text characters
  69. Need combinations of values from a list to add up to a specific Va
  70. Converting Excel to PDF
  71. office web components
  72. QUARTILES in Excel
  73. VBA for converting data into various CASES.
  74. How Do I Get The Difference In Hours and Mins
  75. in an excell worksheet
  76. Performing a convolution in a worksheet
  77. How to average every 10 numeric values
  78. How do I find a missing number in a sequence of numbers?
  79. numbers contain hyphens to dates
  80. Need help with Converting Rows of data into 2 columns
  81. VLOOKUP, LOOKUP without repeating??
  82. how do I open a spreadsheet from excel in works?
  83. User ID's
  84. Is there a currency conversion tool in Excel XP?
  85. expanding range to reflect entries
  86. add DSum function that functions horizontally.
  87. Replacing #N/A with other text
  88. Count number of runs above or below average
  89. Printing auto-filter settings
  90. IF Function
  91. DATEIF and IF statements
  92. vlookup cell format problems
  93. Like Sumproduct, But Different
  94. how do i change the font size in a combo box?
  95. How do I search for duplicate words in a column?
  96. formula bar
  97. Insert a number of rows based on a value in a cell on active row
  98. Number of items meeting a > criterion
  99. How do i Use actual number displayed?
  100. Automatically pasting worksheet data to new worksheet with formulas
  101. Tally function in excel
  102. How to format numbers that are already entered?
  103. How do I send/email macros from my excel workbook to someone else?
  104. get pivot data formula - is it the thing to do
  105. Something akin to a C++ += or ++ for outside cell
  106. =NOW() Time Function. I want this to be live!
  107. Calculate number based on percentage
  108. NETWORKDAYS Help
  109. How do I set up a formula to capture info from many other cells?
  110. Excel: Sheet name from tab automically into a cell
  111. Formula to change rows a different colour?
  112. Using the Offset Function
  113. COUNTIF help
  114. Weeks between dates
  115. hlook function
  116. print out of worksheets
  117. Counting date cells...
  118. EXCEL FORMULA RETURN X IF VALUE IN 4 CELLS HAS VALUE
  119. Calculating Age
  120. vlookup - finding the next value that is GREATER than the lookup value?
  121. Sum by fill color
  122. opening a worksheet without showing excel components
  123. how to return a number for how many times a word is used in excel
  124. Functions across multiple worksheets
  125. can a single cell contain multiple numbers?
  126. How do I round to the nearest $250
  127. Improve SUMIF function to sum more than one column
  128. Find Lowest Bidder
  129. Find Lowest Bidder
  130. Creating a New Sheet
  131. Simple Formula?
  132. Solver - problem too large
  133. How do you ignore hidden rows in a countif() function
  134. repeat an action in different locations
  135. Does "DATEDIF" function count leap years?
  136. My date format is not as the template states
  137. How can you get a yen symbol?
  138. Excel formula for a time sheet
  139. Commission Calculation with IF Stmt.
  140. why doesnt my RANDBETWEEN function work?
  141. formatted sheets get unformatted when send via email attachment?
  142. I want to compare Purchase , Lease and rental car options.
  143. How to suggest a new feature?
  144. Unique Number
  145. Unique Number
  146. Prefix
  147. What is fastest for this? The Small VBA or many Worksheet Functions...?
  148. Formula for Hour Minute and Second
  149. Is there a function to return all Thursdays in a given month/yr
  150. need list of free math formulas in excel
  151. Chart wizard will not place (as object in) graph in same sheet
  152. #VALUE!
  153. why can i no longer protect multiple worksheets in Excel
  154. Copy shortcut
  155. Capture and Store the date that data is entered in Excel?
  156. How do i sign a author name to an excell file that I created?
  157. DataTel import limits
  158. counting columns
  159. Help with a formula
  160. Match a value from a column in worksheet
  161. Multiple matches using LOOKUP
  162. how do you subtract cells and then add those totals
  163. ISERROR Conundrum
  164. Need better understanding of TRIM so I can get rid of trailing spa
  165. conditional formatting
  166. Allocating a value from a cell
  167. ISERROR Conundrum
  168. counting a cell range within a range
  169. How to automate footers (filename/date) for all new spreadsheets?
  170. Row filtering based on input box entry (column heading)
  171. Need Macro for List of Book Titles
  172. Countif cell greater than average
  173. Countif w/ Multiple Criteria
  174. Jump to Sheet Dropdown List
  175. Sumif
  176. =min(if(
  177. How do I insert combo drop box and still be able to sort?
  178. Why would a formula stop working in an Excell spreadsheet?
  179. product function
  180. Error using dates with HLOOKUP
  181. Combining Text Strings - Complex
  182. auto adjust columns in a pivot
  183. If and Vlookup
  184. getting values from other worksheet
  185. product function
  186. Date/If function for past dues
  187. Conditional IF Statements - cumulative calc.
  188. Text data appears as 0 in my Pivot table - how do I display as tex
  189. Conditional Sum on VLOOKUP Returned Data
  190. Freeze Two Columns
  191. Pivot Tables
  192. removing syntax pop up box
  193. vba, excel, sum different ranges
  194. Searching and returning row number of a value
  195. Conditional average function
  196. function for average without zero
  197. Figures not updating on my summary sheet
  198. Minimum Value
  199. count based on multiple date criteria
  200. using more than 30 sheets
  201. multiple results display after filter function
  202. Pivoting - Problem
  203. Ability to sum data by varying dates
  204. vlookup formulas returning no values
  205. Adding numbers to several cells at one time
  206. Copying cell formats
  207. Cell References
  208. Adjusting Date Results
  209. ADDING TIMES
  210. Pivot Tables
  211. Automatically inserting rows
  212. Excel becomes slow
  213. TV station business plan
  214. Pivot Tables and Formatting
  215. Strikethrough and Underline Font Macro
  216. Strikethough and Underline Macro
  217. How to Reduce Spreadsheet Size and Speed
  218. One Sheet or More?? Help
  219. How can I rate a cell 1-5 and colour code it?
  220. Link cell is truncating text
  221. How do I set up conditional cell fill colours in Excel?
  222. Getting rid of not quite duplicate entries
  223. Duplicate & Zero Values in Lists (Excel 2003)
  224. Can you do a function like =TODAY() PLUS 1?
  225. Combination of H & Vlookup??
  226. Upper case
  227. Naming a worksheet help?
  228. The fruit problem
  229. How do I combine two functions AVERAGE and IF in Excel ?
  230. Column Formatting
  231. Combo Box Values not Numbers
  232. Range Lookup - Problem
  233. Range Lookup - Problem
  234. Range Lookup - Problem
  235. Range Lookup - Problem
  236. Extract only items not on previous list
  237. help keeping the worksheet names within formula
  238. A 13 period exercise
  239. Formula ?? Please help
  240. Drop Down Box
  241. Marcos
  242. list and combo boxes
  243. query about VALUE function
  244. Combining Cells BUT Keeping source formatting
  245. Unique and duplicate data between 2 Excel worksheets
  246. Summing moving ranges & dates
  247. How to make =MAX(IF incorporate "less than"?
  248. This formula is also summing the the value above to give 2 totals.
  249. How to merge more than one worksheet
  250. Automatically Close Dialog Boxes
  251. Why do the cells I am custom formatting save in special, polish
  252. Daily data to weekly data conversion in Excel?
  253. Sumif with multiple worksheets
  254. DMAX criteria
  255. SUM 2 Conditions
  256. Conditional formatting question
  257. Hiding formulas
  258. Currency Conversion
  259. Number formatting issue
  260. custom list does not sort
  261. Can I connect data from Outlook contacts to cells within Excell?
  262. Combine 2 formulas
  263. job costing worksheet
  264. using forms in a shared workbook
  265. Tab name / reference cell?
  266. Unhide cells when data is entered
  267. Subtotals
  268. Recognizing Numbers or names as duplicates
  269. Test~ I can't figure it out!
  270. Conditional Summing (Sumif? Countif?)
  271. Hyperlink Display problem
  272. How do I work with the "dialogs" I can insert as worksheet tabs?
  273. Forumla
  274. Vlookup - Comparing two lists in different worksheets
  275. Macro for changing text to Proper Case
  276. Two-way MATCH
  277. compare contents of two adjacent columns
  278. Sum Product help
  279. VBA, excel - find, resize and sort
  280. copy the conditional sum (SUMIF) formula
  281. Function F3 key not working
  282. sort dates
  283. vlookup on large text in cells
  284. Using 'If' refer to specific words in a cell containing text
  285. Cell Formatting for Angles
  286. Elapsed time in days
  287. Looking for Excel Formula
  288. Time Formating
  289. need help, want to remove some sheets
  290. How to calculate the accumulated payments from an annuity at yr 10
  291. assigning values by intervals
  292. How to link a daily updated table data on website to Excel?
  293. An unsorted list in vlookup
  294. Auto shading
  295. Excel for qualitative research
  296. Lookup cell value using list of worksheet names
  297. How to overcome LOOKUP function problems?
  298. Modify the official None-working days in the "NETWORKDAYS" Functio
  299. Linest/slope functions with with different data ranges
  300. DIV/0! error in SumProduct formula with no division
  301. To clear visable cells in a subtotal - can it be done?
  302. HELP me sort these
  303. How do I make a border flash, blink or otherwise?
  304. sort problem with worksheets
  305. if functions question
  306. Insert rows to linked spreadsheets
  307. Worsheet Tab Names - Question
  308. Question about merging macros
  309. Compare date of a transaction against a range of dates
  310. How do I calculate rate when pmt is made at end of periods
  311. how to put a formula in one cell and the result in a another cell
  312. New Display Problem
  313. Sum data based on 2 criteria
  314. AUTOFILTER-Totals on the left down corner marge do not appear
  315. Vlookup but also equal to and greater than?
  316. I have a quandary with print preview in Excel 2000
  317. Sort & add columns without messing up formulas
  318. Excel will be consistent with nonnumerics. either use or ignore
  319. changing #value! to 0's
  320. Display issue
  321. MS Works Spreadsheet 2000 v5.0 VLOOKUP
  322. How to have:= NOW () date/time change only if updated and saved
  323. How can i convert the rows into columns and columns into rows?
  324. Help with nesting functions in Excel
  325. clicker that advances one number per click in a cell
  326. Adjacent cell
  327. How do you do a SUMIF function with 2 different conditions?
  328. How can I work out how many hours I get premium rate?
  329. Counting char help
  330. is it possible to check
  331. LOOKUP function
  332. How do you nest the following formula to show blank cells
  333. Display a row if a cell value is greater than zero
  334. How can I protect worksheets in one go?
  335. Uniqe value counter returns #N/A error
  336. Auto Proper Case on Entry
  337. COLOUR & VALUE
  338. Help with VLookup in Excel 2003 please
  339. How to calculate an inverse of log base 10
  340. Help with vlookup in Excel 2003
  341. How do I place items in alphabetical order in a column and keep da
  342. Formula for comparing two cells
  343. imbedded if statements
  344. Need to reference existing functions in a custom function: possibl
  345. Arrays Take too long. VERY HARD QUESTION. my head hurts : /
  346. Equal "Distribution"
  347. Cell borders and fill
  348. how do I sort several columns in excel
  349. How can I find and format specific cells automatically in Excel?
  350. sumif criteria reference
  351. Lookup
  352. Pop up calendar
  353. Seperate/Split celinput
  354. VLOOKUP Limitations
  355. Formula for cell in a column
  356. Is there a way to split a cell horizontally in Excel?
  357. Array Formulas take waaaay too long...
  358. Rounding a formula result to read thousands from millions.
  359. multiple if statements
  360. Complicated Sum Product Function
  361. Multiple Conditions Setup with an Array?? Not Working??
  362. Countif
  363. Column widths
  364. Macro to copy range of formulas to equal data lines
  365. Calculating the number of days worked
  366. how to merge ranges from multiple worksheets
  367. customize colors
  368. How do I group certain data from a spreadsheet
  369. Can I rounddown a cell result from millions to thousands
  370. Margins
  371. Default Value to Zero in Pivot Tables
  372. Excel Search
  373. Date to Text
  374. Yes / No Feature
  375. Format elapsed time in days?
  376. conditional formating which reacts on nerby cells
  377. Copyingfunctions from one worksheet to another
  378. How to change numbers in entire spreadsheet from one cell?
  379. Easy one
  380. 1/0/1900 10:18:48 AM Time problem
  381. sumproduct - deduct one from another.
  382. ZIP CODES
  383. how do i get all numbers in cells to be divided by 9 at once?
  384. If(b1:B10="Apple","x","")
  385. Using Curve-fit for time-phased budget app in Excel
  386. Formula Help
  387. Running total in Excel w/2 columns
  388. Search column for value and return TRUE or FALSE
  389. Rounding of Time
  390. Adding adjacent numbers and resettiing when encountering 0
  391. Min values in a list of numbers
  392. Rounding and cell totals
  393. Cell Reference help required
  394. Vlookup Formula Limit Error ? (Reposting)
  395. Auto Filter problem
  396. Can I insert roundup command into different formulas in excel?
  397. Convert [h]:mm sum total format to number format
  398. how do i prevent a #REF! error when i delete non adjacent rows?
  399. Goal seek multiple cells
  400. cube root
  401. Print sequential page numbers on one worksheet printed multiple ti
  402. I want to stop excel deciding the number format of a cell for me
  403. IF formula to flag exp dates
  404. IF / VLOOKUP formula won't work until saved
  405. Use TREND function with nonadjacent cells
  406. Count age and gender records from two different columns
  407. Urgent! Sort function. Please help!
  408. Date Formula
  409. Function IF.
  410. Format into VLookup
  411. Conditional Formating
  412. Running total w/2 columns - Excel
  413. Conditional Formating
  414. Protection and sorting
  415. Help with complex index array issue
  416. Nested If with VLOOKUP's... I think!
  417. Searches slow for some Fast for others?
  418. Conditional formulas between multiple worksheets
  419. Pivot Table
  420. Copying a Formula To Reference Multiple Worksheets
  421. Trim Function
  422. How do I group worksheets (Lotus 123 function is "Sheet>Group Shee
  423. counting problem
  424. conditianal formulas
  425. iserror
  426. how do I include a "do nothing choice" in an IF
  427. Stripping Middle Initial from a Name
  428. Store values of a dynamically changing cell
  429. conditional formatting for Error
  430. Page Break
  431. How do I type 3 lines in one cell?
  432. How do I have a IF AND formula read 2 different cells to be true
  433. Setup Entire Workbook to print all tabs Duplex
  434. Referencing Cells
  435. lookup reference
  436. add and subtract degrees
  437. lookup and return range of cells
  438. 2nd and 4th Wednesdays formula?
  439. 2nd and 4th Wednesdays formula?
  440. logic stmt. use in a new workbook w/o refering back to original
  441. Chart to display only bars for values that are > 3 & blank cells
  442. How do I run a filter then have my countif change?
  443. dynamic named range function
  444. Lock cells without protecting sheet?
  445. Name, Date and Address Formats
  446. Update master list with other lists
  447. Automatically recalculating in Excel
  448. transpose
  449. What function will take the average of text data?
  450. If function using Index
  451. Adding currency broken in two columns?
  452. How do I make changes in all sheets within a workbook?
  453. Excel - vytvoÅ™enÃ* funkce pro zobrazenÃ* ÄÃ*sla kalend.týdne
  454. using a checkbox (or something)
  455. DATEVALUE QUESTION
  456. Sumproduct Help
  457. Save as HTML oddity
  458. Word select from a string
  459. Totaling criteria from 2 columns
  460. recognition of coloured squares
  461. Calculated Field option
  462. How do I change cell color upon entry, and exit?
  463. merging different workbook files
  464. Help Please with Conditional FOrmating
  465. Inserting time in cell to the right
  466. Pivot Tables & not printing blank rows (revisited)
  467. Counting Numbers in an Interval
  468. get rid euro conversion floating toolbar
  469. Age Avg
  470. Countif Multiple Cirteria
  471. Formula for Last Saved on outside of Header/Footer
  472. Re: Pls Help, Runtime Error using hlookup
  473. I want to use more than 7 nested if then statements
  474. How do I deselect a row in Excel when selecting w/ the ctrl key?
  475. New Question
  476. How do I change the order of choices in menu File- Send To
  477. Strange Formating problem with text and formula in same cell
  478. Table to pick out most common entries and count occurences of each
  479. vlookup inside an if statement?
  480. Re-occuring Inspection Dates
  481. Excel 2000 worksheet limitation
  482. Count # of Businesses
  483. "Formula is too long"
  484. Calculating a time sheet?
  485. Counting Help
  486. IF, IF, Concatenate?
  487. calculating dates
  488. CELL RANGE SELECTION ON EXISTING PIVOT TABLE
  489. Count unique values and create list based on these values
  490. Macro Question
  491. How can I calculate the week number from a date, eg 21/06/05 = 26
  492. Can not move/copy spreadsheet to another book?
  493. How do I sum cells that have values from a countif formula?
  494. Getting a date six months back
  495. International number separator
  496. Function to look up largest value whose record meets criteria?
  497. how do I display $1,243,597 as $1,244 and $(324,567) as $(325)?
  498. code sample for executing a VB function in Excel using perl
  499. my code too long?
  500. Due Dates Reminders
  501. a function giving the interest rate for inv x for period y & bal z
  502. breaking up a phone number
  503. I am trying to use the "Camera" function within Excel
  504. problems for counting
  505. VBA, Excel - Find Range, Sort
  506. EXCEL UNPROTECT SHEET WILL NOT DISPLAY....HELP!
  507. How do I get rid of the #/DIV/0! message
  508. changing print area in an entire workbook
  509. add a formula to Excel
  510. Counting Letters
  511. Filter not working in a protected file
  512. Automatic update of list in Excel
  513. Automatic coloring of blank cells when sheet work complete
  514. New WorkBook
  515. sumproduct from multiple sheets
  516. Scrolling within a section of an excel worksheet
  517. Adjusting Vlookup Values
  518. Analysis
  519. Averaging Values in Auto Filter
  520. Count returns for a period - year
  521. can you select rows in excel with a certain background color?
  522. How do I change the "comment" default location ?
  523. VLOOKUP returning wrong row
  524. Counting what's left in a list
  525. Excel should let me track my paychecks and salary history.
  526. How do I calculate a future date in Excel?
  527. VLookup Help
  528. DATA FILTER ARROWS DISPLAY WHILE INACTIVE
  529. View gridlines despite changing cell color
  530. Rolling Calendar
  531. help me write function?
  532. Need a formula that sums a column but could exclude some cells
  533. How do I change the plus to a negative in a column of numbers?
  534. In excel: when in print preview, 1 button to 'maximise margins'
  535. International number separator
  536. use a formula as a cell reference in a function
  537. formula to count cells not blanK
  538. How to add numbers in a column dependant on their colour
  539. Automatically update links when server names change
  540. Cumulative Time Usage in a Worksheet
  541. Combining cell information
  542. Updating excel sheet with selected data from another sheet in the same file
  543. forecast formula question
  544. how to import Ms word Table to Ms Excel for Various Calculations
  545. Formula to add up units
  546. Getting Min Value
  547. create multiple worksheet
  548. Formula to display Sheet name
  549. Dates/ Ages
  550. Mortgage functions
  551. multiplycation of money cell and time cell
  552. Empty Excel File -- Data Lost?
  553. sumproduct for latest date
  554. How to link two different worksheets together in Excel
  555. how to move worksheet thru keyboad
  556. How to : Comparing Two Ranges
  557. text to columns: is there a formula?
  558. Excel 2003
  559. Is there an easy way to count when adjacent cells contain same data?
  560. reorder function
  561. Can Excel turn % hrs worked/week put in a cell into a real number
  562. Find largest alphanumeric value matching alpha criteria in databas
  563. Return name of worksheet
  564. Run macro on exit worksheet/workbook
  565. How do I calculate an age from 2 dates?
  566. Formula stays displayed in cell
  567. Sorting - Macro or worksheet function
  568. Sorting - Macro or worsheet function
  569. Sumif function?
  570. work-around for "vlookup: with unsorted data
  571. Web-type Back and Forward navigation between Excel worksheets
  572. Which function to use?
  573. Count designated cells
  574. counting and matching
  575. get a count of numbers whose value falls within a given range
  576. Mortages Repayment
  577. Merging different quantites of labels based on Excel data
  578. vba, identifying a range
  579. Negative %
  580. VBA, identify a range
  581. show non-blank as 1
  582. How do i get the running balance from one worksheet to another?
  583. Counting Cells
  584. Need simple little macro - edit add 3 spaces
  585. Sorting
  586. subtracting based on available values
  587. Impossibility?
  588. cross referencing
  589. Formula Error
  590. How do I display fractions in small characters?
  591. Calculations
  592. Sumerize one cell and transfer the remainder to another
  593. Calculating number of periods when payment amount changes
  594. text argument in vlook up which has a ""
  595. How do I use the excel timeline function with dates in graphs
  596. Page break problems
  597. Warning!!!
  598. Consolidated Excel Sheet
  599. subtotal buttons
  600. sorting data
  601. how to get number series in excel 1 2 3 4 etc
  602. SUMIF with AND for range and criteria
  603. search for latest date
  604. can't access XML text-elements
  605. represent values from one book in another
  606. specifying currency together with a number in a single field
  607. How do I create extractstring formula?
  608. Autofilter selected arrow color
  609. sum if problem
  610. leave a cell blank
  611. Nesting VLOOKUP functions
  612. how to pick from a range of table values
  613. Delay to startup excel spreadsheet
  614. shading different rows when a value changes in col.
  615. Counting values between 70 and 140
  616. Index lookup and duplicate numbers
  617. Question re efficiency in vlookup
  618. How do I calculate 30 days later from a date
  619. Flashing Text
  620. how can I search a field for a particular word
  621. Change colour of Text if number in cell exceed limit
  622. Shortcut keys assigned to macros/functions in excel
  623. changing font style in a complex worksheet function
  624. Help writing a formula
  625. How do I unlock a protected worksheet
  626. MAX/MIN with SUMPRODUCT
  627. proteger formula de una celda de lista creada sin bloquear lista
  628. Vlookup, What is correct formula for problem below?
  629. calculating a weighted average using formula
  630. how do i set up a "raw data" spreadsheet
  631. Can I sync information on one worksheet with another worksheet
  632. A function to get a variable row reference for range in XNPV funct
  633. I need to set up a date reminder in Excel to pop-up.
  634. formulas won't maintain during sort -help please!
  635. SumIf Criteria Matches
  636. lookup going left based on function
  637. using more than 1 formula in a cell
  638. Sum formula not working
  639. Pull multiple data
  640. How to change ALL CAPS to Initial Caps only?
  641. Protect an Excel Workbook
  642. User Form That Calculates Time Length and Fills In Other Informati
  643. how do i do a vlookup?
  644. Solver error says too many arguments
  645. Using AND function within an array formula
  646. Drop down box format
  647. RIGHT & MID & LEFT
  648. protect cells based on another cell
  649. Only text values matching using index/match lookup - data type pro
  650. Replace range names with cell references?
  651. Possible IF statement?
  652. Using RAND() with Different Distributions!?
  653. Copying worksheets
  654. unable to move page breaks
  655. employee phone list template
  656. If, and, or?
  657. Graphs
  658. advanced filter a range
  659. inventory Help
  660. Date format
  661. SUMIF based on two conditions
  662. Convert text to numbers
  663. Array Formula - using LEFT("text",4) in formula
  664. Count Function
  665. Many Excels To one
  666. Round numbers THEN add them
  667. help with spaces in functions (Biff)
  668. convert value stored as text to logical refrence value!
  669. Help for Harlan's Pull
  670. hyperlinks and command buttons
  671. ...I want to display a hyphen instead of zero...
  672. deleting more than one page with macro's
  673. Include exponential (and exp-cosine-sine) integral maths functions
  674. Time Question
  675. True/False
  676. A funktion in the background....
  677. sumproduct and percentage
  678. How do I set up a PAYE monthly chart
  679. Two Conditions Function
  680. For Bob Phillips
  681. migrating cell data
  682. why won't vlookup work in a long list
  683. Which Function is use?
  684. Please help with a discount formula - Excel 2003
  685. can you use the dtpicker in an userfrom
  686. calculating a weighted average uisng formula
  687. randbetween help needed
  688. Formulas do not multiply when filled down
  689. Excel CHALLENGE...3 questions(indirect,rank,array formula)...
  690. Sales Report Grrrr
  691. How to calculate hours?
  692. excel
  693. need a fuction that can do this (or can it be done)
  694. Lookup function still not working correctly
  695. Some formula results will not show up in the cell
  696. Excel XMIRR function
  697. how do I add + G3 value
  698. Please how t
  699. nested Indirect to other WS
  700. Day Question
  701. Need help with a simple Time calculation
  702. how can i trace position in marks sheet
  703. #div/0! how do i supress?
  704. To Leave Cell blank Please
  705. How can I find items that have a certain prefix and define?
  706. Copy worksheet question
  707. What's wrong with my code ?
  708. INTRATE function
  709. Removing '0's' in cells
  710. Auto Repeat Data
  711. Auto Repeat Data
  712. More Help Needed with Count formula
  713. How to count a range of values in a single cell?
  714. count distance in column
  715. How do you add numerous subtotals in a spreadsheet?
  716. Can cell get tab value
  717. HELP!!!! sumif or sumproduct ??? :(
  718. HELP!!!! sumif or sumproduct ??? :(
  719. =Cell("color",[reference])
  720. Count number of values in a cell
  721. my tools menu does not have Letter and Mailings option
  722. how to use shift and down arrow keys in a macro?
  723. Error Handling #N/A with AVERAGE Function - Average of values in Row
  724. Strip leading spaces from cell
  725. search a series of rows for a specific formating
  726. Using text and data in formula.
  727. Excel
  728. look up number in column
  729. Link a cell to another workbook with a different path
  730. Drop-Down Colours
  731. Sumproduct and wildcards
  732. Formula pull factor from chart based on value of diff field?
  733. Extracting Text only
  734. How do I generate random lottery numbers in Excel?
  735. how can I create a ODBC database in excel
  736. info in cel needs to propt other cels to automatically enter text
  737. Automatic date
  738. sumproduct problem
  739. Clearing multiple cells in 1 click?
  740. Joining String with function in IF()?
  741. autosum problems
  742. Using the tab key...
  743. IF & AND Functions together
  744. How can I replace the path of the linked spreadsheet in a cell?
  745. How do I pull a date from a separate worksheet using the IF functi
  746. change headers from letter to number/number to letter
  747. How can I convert Text into numbers?
  748. filedialog
  749. Drop Down Boxes
  750. Indirect or Vlookup Function
  751. UPDATED - Referencing named Ranges within a Nested IF formula
  752. VLOOKUP - dealing with lookup_value differences
  753. Need a little help w/ COUNTIF
  754. Help with "IF" Formula
  755. Password protection of worksheet when copied and pasted.
  756. Excel and access should permit sorting by last character
  757. Import External Data
  758. In Excel, how do we convert text into number (value)?
  759. Can I get Excel not to save a file if certain information is not i
  760. Convert to VB
  761. Help with conditional formatiing?
  762. how do I print a page with only grid lines showing
  763. Borders in an inserted row
  764. How can I round a number to the nearest "50" or "100" in excel 200
  765. Referencing lists in a nested IF formula
  766. My needs are simple-apparently, so am I
  767. undefined function error when creating xls pivot from mdb qry
  768. Index, Match, Offset? Not sure which to use
  769. how do I add another page with different cell sizes?
  770. Quotations and blanks cells (that aren't)...
  771. Multiple conditions on a countif
  772. retrieve cell formatting with IF(HLOOKUP) formula
  773. advanced if?????
  774. HOW DO CONVERT EXCEL INTO WORDS FORMAT
  775. Totaling Hours in Standard Format
  776. How do I work with part of a cell entry?
  777. Multiple Functions IF, AND, COUNTIF, MATCH
  778. counif but not all the cells
  779. working with sub-totaled data without the detail
  780. jackh
  781. how do I create or add to a formula . . .
  782. How to change the footer only, on multiple worksheets in Excel?
  783. csv format drops a text character when reopened in Excel
  784. Summarising data from several tables
  785. How do I set view page breaks as a default.
  786. Polynomial trendline
  787. Number of Items open longer than 1 week but less than 2 weeks
  788. math problem
  789. Need help to reflect number of days in a month.
  790. Need help in calculation at specific location
  791. deleting a Text Box in a worksheet
  792. Possible to insert cell data in the middle of line of text?
  793. Easy formula, but need help please
  794. If function help
  795. List only red entries
  796. TTest with values in non-contiguous ranges
  797. Function help with Calculating Interest for two different investme
  798. How Do I Enter Data Into A Single Cell
  799. Automatic updating of 2nd sheet from first
  800. Is it possible?? If it is then please tell me how.
  801. Conversion formula (Proper Case)
  802. Creat a formula to calculate working hrs according to number of da
  803. Protection and Filters
  804. Choose From a Range
  805. Advice sought: Multiple column sorting
  806. My IF(AND passes logical, but doesn't reveal correct results
  807. IF Function
  808. problems with RATE function returning #NUM
  809. How to put color on if function
  810. automatically update links without opening file
  811. Which function do I use?
  812. 2005 Excel User Conference - Sept 16/17 - Ft Worth, Texas
  813. Which function do I use
  814. Needs to Show blank please
  815. Font in Comment Box
  816. I need help with a macro which will copy a worksheet and..
  817. Lock in formatting
  818. REALLY COMPLICATED--the sooner you can help the better
  819. How do I calculate a running balance?
  820. Returning a 0 Value
  821. text
  822. RE: Newbie With A Question
  823. HOW DO I COUNT CELLS OF A CERTAIN COLOR ONLY?
  824. countif function
  825. Re: Comma Woes
  826. Removing a matching code from another cell
  827. excel function
  828. Excel Help
  829. Do you know of a Calibration Control spreadsheet in Excel?
  830. searching
  831. Count error frequency in huge column
  832. Problem using AND()
  833. Excel formulas
  834. Negative r-squared?
  835. Help with Sumproduct with Indirect
  836. If Date=x then do y
  837. How do I pull certain data from several worksheets in one sheet?
  838. counting based ona number of variables.
  839. Text to Numeric
  840. Excel 2002 Pivot Table Date
  841. IF, Match, Index ? which One do I use
  842. Excel Functions
  843. Time Elapse Formula
  844. AUTOMATICALLY ENTER DATA FROM ONE WORKSHEET TO ANOTHER
  845. Inserting commands in Macros
  846. last number array from string
  847. I am looking for a formula for calculating APY on CDs.
  848. Field Source Error for Pivot Table
  849. format workbook
  850. how do i set up a date stamp formula in excel?
  851. indirect function?
  852. Working with sub-totaled data
  853. MAKING A CONTRACT FROM DATA FROM A DIFFERENT FILE
  854. Summing Columns
  855. help
  856. Searching for a criteria in array of cells within an IF statement
  857. HOW DO I FORMAT AN ENTIRE WORKBOOK ALL AT ONCE?
  858. using formulas in a drop down box
  859. Conditionial formatting for merged cells, function Len($A$4)
  860. Using solver with function with multiple outputs
  861. How do I get/copy the (same) layout from a linked worksheet?
  862. Count if array contains cells of a certain value
  863. Dates in a week number
  864. sharing a workbook
  865. Double lookup
  866. Date difference
  867. Creating a list of worksheet names on a Summary PAge
  868. COUNTIF / SUM problem
  869. Summing a variable range of columns
  870. counting characters issue
  871. count problem part 2
  872. yearfrac problem
  873. How do I copy cell values (derived from formula), not references?
  874. Conversion of a Number into English Text
  875. One more Argument.
  876. Accidentally converted date mm/dd/yy to a 5 digit number
  877. Text
  878. Function for Auto Populate
  879. empty cell question
  880. Name the worksheet by a formula
  881. make negative number value to zero
  882. make negative number value to zero
  883. If Then Formulas
  884. 2005 Excel User Conference - Sept 16/17 - Ft Worth, Texas
  885. Rounding off numbers in Excel 2003
  886. Edit Links - Combo Box Problem
  887. time calculation with military time
  888. Due Date Flagging
  889. Help with multiple Index
  890. How to use variable in reference
  891. Convert rows into 1 cell or 1 string
  892. count problem
  893. Conditional Formatting
  894. at, if statement with text, such as if(product), then (price)
  895. Vlookups or Match to find multiple information
  896. Update and add new row of data help?
  897. If Function Help, Please!
  898. formula to count occurence of criteria in 2 columns
  899. How do I put worksheets in alphabetical order
  900. Coloring Cells
  901. Conditional Formatting
  902. how to alter cell format if cell contains text
  903. looking up value in chart
  904. ExcelFreezePanes shoud work horizontially and vertically together
  905. why can't you move colums in Excel like in Outlook?
  906. sharing a workbook and incorporating changes from multiple users
  907. HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION
  908. Partially protect a cell?
  909. The Excel cells are not automatically calc. existing formula.
  910. currency & formulas
  911. colors
  912. Conditional color fill whole line...
  913. copy data in one sheet to multiple sheets in same workbook
  914. Ugh..another time and date problem...HELP
  915. Countif formula and then some...
  916. USING THE BALANCE SHEET TEMPLATE, ANY WAY TO EXPAND?
  917. Countif and then some...
  918. copying addresses from one workbook to another into several worksheets
  919. How do I compare two times to see if one is "late" or "on time"?
  920. calendar with scheduled projects from spreadsheet
  921. rounding numbers, with-out decimals. IE:4507 to 4510
  922. IF Statement with a range
  923. cell/range with formula not recalculating
  924. Probability calculation
  925. using OR in conditional formatting
  926. multiple conditions formula
  927. Excel needs to have the ability to insert "SUB" worksheets
  928. provide ability to undo a save - saved by mistake
  929. How do I change letters at top of excel to custom headers
  930. Conditional Formatting
  931. How do I group multiple data entries in sub-groups
  932. HOW TO MERGE TWO TABLES
  933. count date occurances in range of dates...
  934. need help with an equation in worksheet to populate numbers onto c
  935. display day
  936. Linking to workbook
  937. Time Calculation
  938. how do I copy info from one sheet to another via a formula?
  939. Is this even possible
  940. How do I change the color of the indicator cell in row and column
  941. Dependant Droplist showing distinct records
  942. excel validation, enter particular score in only one cell of a ran
  943. SUMIF where values to be summed are formula
  944. how do set a number so that it automatically changes
  945. converting formula from lotus.123 to excel
  946. How to run a macro when a worksheet is selected
  947. Worksheet function in excel only works once
  948. Excel 2003 view formula within pivot table
  949. column values to a cell with comma seperated
  950. not showing pivot values of zero
  951. compare -neg and +pos number that cancel each other in a column
  952. linked workbook updates
  953. cell = tab
  954. Is it possible to use data from different workbooks in formulas?
  955. please help!
  956. font style of worksheet functions
  957. Need formula to figure compound interest of a deposit for a year
  958. Return cell contents based on conditional lookup
  959. Max date
  960. MathText in Excel
  961. INDIRECT.EXT help needed
  962. Excel Formula
  963. calculating time with text
  964. Mode Problem
  965. Counting Values on a condition
  966. Copying files
  967. Excel calendar
  968. Adding values from several worksheets - would appreciate the help
  969. VLookUp Problems
  970. Extract one numerical value from single cell with multiple values?
  971. SEARCH IF
  972. Use CountIF with conditional formulas
  973. how to ignore hidden cells with a countif
  974. How to randomly select from a list with condition
  975. Count Function Help
  976. Urgent - Formula for incr/decrease of 5 cells
  977. Conditional Formating
  978. Dynamically compare two slightly different copies of a table
  979. How are relay leg times or driving times entered and totaled?
  980. Want to extract from a list of 4700 rows each 185th row to a new w
  981. How do I count the number of cells in a list, e.g. H6:H12, J4, J7:
  982. How do I link a cells formatting from one worksheet to another?
  983. How Do I organize sheets and clients by town?
  984. Copy a formula maintaining a constant cell
  985. How do I edit a Named Range using macro's
  986. simple chart question
  987. Selecting the 2nd highest value in a row.
  988. how do i extract a number from a cell with no spaces?
  989. copying text across sheets
  990. Building a Filename
  991. Can a single cell be protected in Excel 2003?
  992. Sumproduct help
  993. How do I count to different variables in excel
  994. Referenced cell does not automatically update
  995. sumproduct
  996. sum formula equals zero
  997. remove leading zeros from text strings
  998. Need Help With ARRAY Formula
  999. Need formula
  1000. Need formula for 5 yr high/low