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. Colour full row in CF
  2. Reformatting dates as text
  3. Excel Function returning negative 0
  4. workday date function
  5. Matching data from seperate excel files
  6. SUMPRODUCT
  7. Show timesheet time in and out in regular time versus military tim
  8. creating hyperlinks
  9. a formula that leaves cell "empty"?
  10. Extract Unique Records from two lists
  11. need help with determining a formula
  12. forumal does not work
  13. ISNA(MATCH...) and IF functions - can they be combined?
  14. 2nd attempt ~ Faster/Shorter formula
  15. Linked Combo Boxes
  16. Match help
  17. Add seperate Items.
  18. With formulas does anyone know the order of precedence BOMDAS
  19. Building Formulas
  20. Printing problem
  21. Conditional Statement in Charts
  22. linest r-squared bug when calculating forced through zero?
  23. regression
  24. Need some assistance
  25. Spreadsheets with multiple entries
  26. AVERAGE(IF()) problem
  27. Location of the last "s" in a text string
  28. Formulas across worksheets do not update
  29. X axis break
  30. matching and lookup??
  31. FIND FORMULA SIMILAR TO VLOOKUP FOR NON-ASCENDING VALUES
  32. Timesheet maximum hours problem
  33. how do I count the numbers of row that meet 2 criteria
  34. questions being addressed
  35. RE: matching and lookup??
  36. sum>1 --> count = count +1
  37. saving documents with macros
  38. Preventing new worksheets when drilling down in PIVOTs
  39. Spreadsheet will not sort
  40. ##value error
  41. how to perform a deduplication of names on large mailing list
  42. IF/THEN Average Problem
  43. Running Query
  44. prevent empty rows from printing
  45. How do I compare excel spreadsheets, tracking the differences?
  46. IF COMMAND WITH TEXT
  47. spreadsheet spanning 4 weeks
  48. how do I insert a blank row when a value changes, automatically
  49. Columns in excel 2003
  50. SUMIF question with multiple criteria
  51. autofilter freeze
  52. How to set the "to value" in GOAL SEEK as a cell reference?
  53. Formula to compare two lists and separate non-recurring items?
  54. Using IF Function with EDATE Function
  55. countif condition problem
  56. Changing Cell Color
  57. Checking for duplicate items in list
  58. Formula for markup won't change when the initial value is changed.
  59. Confusing VLOOKUP with Indirect reference
  60. How do I change how cells are sorted in an excel file?
  61. IF STATEMENT PROBLEM
  62. SUMPRODUCT
  63. CF in a filter
  64. linkiing a worksheet
  65. Need faster/shorter formula
  66. Reverse numerical values
  67. Can "IF" function display calculated data as bold?
  68. Macro With IF Function
  69. UDF Add-in New category in "Paste Function Dialog Box"
  70. In Excel can you add cell A2:A10 that only have text
  71. How do i compare data fields and assign values?
  72. Can I write each row to a separate file?
  73. cheapest price
  74. Is there a function to give us the highest value in a list of tex
  75. mail merge. interest rate numberic format not working
  76. Is there a function that gives us the last day of a month
  77. Problem with adding time values
  78. Excel student/teacher edition 2003
  79. width of drop-down menus in lists
  80. Width of drop-down menus
  81. macro save a workbook whilst increasing file no
  82. Worksheet template
  83. How do i count numbers and letters to find a total count of all
  84. trying to link but not lose info
  85. Hour Sum
  86. How can I keep a fraction from being reduced?
  87. Replacing Values in Cells Via Formula
  88. Alternative to multiple IF limits
  89. pivot % or column tinkering
  90. options to update automatic links
  91. IF statements and moving data to different columns
  92. I have alot of text in a cell, I just want to see the top line
  93. Calender Help
  94. combobox not working
  95. Showing + and - (show and hide) for rows in the sheet
  96. transposing links
  97. Index/ Lookup formulas and fuzzy matching
  98. Help I am going crazy with this formula.
  99. Format cell to show numbers in words
  100. PIVOT Table
  101. formula QUESTION
  102. how can I have Excel total a column of # that were derived by form
  103. COMPUTING TWO COLUMNS
  104. Drop-Down Menus in Created Lists
  105. How do I create a list from a large spreadsheet without headings
  106. Change event fails to work
  107. Counting similar text
  108. How do I get LINEST to show all stats?
  109. function problem regarding cell range
  110. password protection
  111. CONCATENATING DATE AND TIME
  112. in excell the cell only displays formula, not the number
  113. Can I limit the amount of characters in a cell?
  114. Cell reference to current cell minus 1
  115. time/date calculation
  116. how do you have rows automatically insert in excel?
  117. How do I calculate pro-rata formulas?
  118. VLookup function to search an entire workbook
  119. using sumproduct on subtotals meeting certain conditions
  120. RE: CONCATENATING DATE AND TIME
  121. RANK Funciton
  122. Count number of different entries?
  123. Date/Time Question
  124. This is so silly...
  125. RE: CONCATENATING DATE AND TIME
  126. Should have ability to right click to accept autosum, not Enter.
  127. Multiple SUMIF Criteria
  128. Inserting Copied Row To Always Insert Above Sub Total
  129. Select random cell
  130. Warning! Time has expired....
  131. Conditional Formatting
  132. Delete rows listed less than 8 times???
  133. max and lookup
  134. Blank Printouts and Print Preview
  135. How can you convert the false/true into 1/0 in Excel?
  136. Formula is entering a default time when it comes across an empty cell..
  137. Sub-Totaling
  138. how do i add every fifth row in a spreadsheet?
  139. No Excel Function Wizard on Mac-Office 2004?
  140. add page number to entire workseet
  141. IF/AND/OR/DATEIF Issue...sorry...long post...
  142. Dynamic range - is there a better way?...
  143. Excel should have multiple window splits .
  144. templates
  145. the answer to appear in more than one cell
  146. Referencing cell in another sheet yields null?
  147. Footage to seconds (# to mm:ss).
  148. LOOKUP function
  149. Function for interest rate over several years
  150. Transpose rows to columns w/varying numbers of lines per record
  151. How do I change hexadecimal number to binary in excel
  152. trend for polynomial curve fitting by regressing
  153. Search for instances of X in a sheet
  154. comparing many cols of data to one col
  155. Dissappearing formula
  156. Excel find the content of cell using row and column header
  157. How do I sum percentages calculated from IF statements?
  158. i need info from the top workbook to be read in multiple workbooks
  159. "s Appear in files saved as Text (MS-Dos)
  160. how to create a conditional formula for a range of cells?
  161. Borders Functionailty
  162. include INDIRECT function into SUMPRODUCT formula
  163. Seting up an Indirect Formula
  164. skipping every second cell
  165. Substitute ,replace and delete in a cell.
  166. How do I have a data table display cell names rather than values?
  167. Excel
  168. How to change reference to other worksheet by changing one cell?
  169. Macro?
  170. Concatenation in a CountIf
  171. shortcut for merging selected cells would be nice.
  172. Excel data base
  173. ... I would like to apply more than 3 conditional formats ...
  174. Expanding data
  175. editing spreadsheet
  176. Showing the contents of a cell based on another cell
  177. How do I turn off the solver results dialog box
  178. How do I select & use contents of first non-blank cell in row?
  179. hyperlink to files
  180. Taking data from another worksheet and converting
  181. is it possible to make a spreadsheet display '0' when negative
  182. function problem
  183. Value error
  184. populate data valadation list by criteria
  185. using the same function to convert a column of numbers
  186. formula to look up in an application
  187. Creating Combinations
  188. Nested IF's with Rank Problem
  189. New Auto Selecting Cell Question
  190. LOOKUP
  191. How do I convert time (38:30) to decimal (38.5) format?
  192. how to apply one function to an entire column of numbers
  193. Excel multiline formulas
  194. Can I create a random order within a series of numbers in Excel?
  195. Conditional Formatting
  196. Weighted avg of numbers not in contiguous row-ie array w lookup?
  197. Is there a function to auto-sort 2 columns?
  198. Using Two Worksheets To Capature Data
  199. strange error calculations provides errors until i add any new one
  200. Another #N/A Result question...Sorry
  201. 2nd attempt ~ complicated formula
  202. How can I generate correlated standard normals?
  203. If Function
  204. How do I set up an IF function with text and numbers?
  205. SUMIF function question
  206. Protected sheets
  207. Access data base is able to store any number of records
  208. macro button in all my workbooks
  209. Help matching entries in two sheets???
  210. sum
  211. How do I change my cell reference columns from number to alphabet?
  212. How can I change dafault color in excel from black to another?
  213. How do you count data that matches more than one condition?
  214. Using excel 2003 cannot see Canadian Postal Codes
  215. Copied nubers is not possible to add
  216. SSN Format not showing
  217. excel 2003
  218. Get tab name formula
  219. How to I get a warning message box
  220. Help with Date Functions
  221. Renaming and saving workbooks but macro still deletes
  222. How do I clear data values wthout losing the formulas?
  223. how can you copy cells from one book to a shared file
  224. Counting the days worked in a month by employee
  225. Using Autofilter with Protection on
  226. Can't make Excel "if" Formula work
  227. How to copy 98-97 excel macros to excel 2000 (XP)
  228. vlookup, multiple values, sum values into one cell??
  229. western australian payroll templates
  230. Worksheet tabs in a Macro
  231. STRING functions
  232. What function can I use
  233. Need a Formula for DATES
  234. two cases for countif
  235. assigning rows
  236. Consolidating data??
  237. Function IN VBA
  238. how to automatically convert a number to words in Excel
  239. Help with schedule layout
  240. Worksheet Names
  241. How to display weeknumber with year code
  242. Excel Crashes
  243. Autofilter stops responding
  244. How to AUTO SORT A-Z new data in a column (not menual sorting)
  245. keep active sheet view and cursor position
  246. Can someone give me a hand with this formula please?
  247. Re: Excel macro
  248. How can I add data analysis function in tool?
  249. can we round time in excel
  250. Vlookup doesn't work until i edit(but not change) the lookup cell
  251. Statistical help file
  252. Average with a 0 in the equation
  253. Count and Sum cells with certain format (e.g. color)
  254. Need help creating a formula to summarize data!
  255. dynamic summed range based on a variable
  256. Detecting when a user deletes a row
  257. lookup tables
  258. Is it possible to insert a macro command in an "IF" function?
  259. Formula Help
  260. Autofilter with Subtotal Sumif
  261. How to Count Rows with defined values in multiple columns
  262. extract name when a date in another cell gets near
  263. Re: splitting names can't see whats going wrong (Save My Sanity )
  264. splitting names can't see whats going wrong (Save My Sanity )
  265. Can an Excel Spreadsheet automatically sort new data?
  266. how do I use if formula using dates?
  267. Time Sheet frustrations
  268. Calendar - vlookup based on dates
  269. How can I display a "sliding" range?
  270. Worksheet name in function
  271. Excel columns do not add correctly.
  272. Comparing Lists
  273. IF statement containing OR
  274. Searching for a particlar value and matching to a name..
  275. Delete Formula
  276. Can you create a formula to add 1 to the # you enter
  277. Protect Workbook vs Worksheet??
  278. Logon Screen
  279. Drop-down boxs
  280. Calc Diff Between Two Julian Date
  281. Protected sheets and cells
  282. Help w/ counting multiple columns based on IF criteria
  283. Complicated counting of cells (based on other cells contents)
  284. Multiple IF
  285. Change text within multiple functions
  286. How many IF are authorized?
  287. Text moving
  288. Counting te days worked in a month
  289. Need to derive combinations for 4 elements each with 3 possible va
  290. Non-Blank Cells: Conditional Counting
  291. How to generate a list of randomly selected numbers within a range
  292. counting text
  293. Consolidate Woorksheets
  294. Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(.
  295. rows that need deleting
  296. Formula which splits principal & interest pmts on P&I Loan
  297. VLOOKUP Problem (limitation)?
  298. "Rows to repeat at top" option under page setup
  299. {=AVERAGE(IF((C3:C325<M4), C3:C325))}
  300. CHK file in excel link files
  301. import external data too many rows for one worksheet
  302. HELP ME PLEASE
  303. Columns with "zero" width
  304. How do I lookup a corresponding value in another table
  305. Complicated IF Formula
  306. Formula Help
  307. Re: Combobox to fit the size of a cell
  308. need a function to calculate a mortgage payment
  309. conditional subtotal counting
  310. RE: need a function to calculate a mortgage payment
  311. Conditional Equations in Excel
  312. pricing problems
  313. Look up a list of prices
  314. Counting Age
  315. counting 0 in a row
  316. Need cells to show as zero or empty
  317. How do I merge 2 excel spreadsheets containing some common info?
  318. How to add auto remender in worksheet
  319. conditioning
  320. Conditionally Fill a sheet row if cell value in another sheet >0
  321. Vlookup worksheet function
  322. I WANT TO ADD A TWO RANDOM CHARACTER SEQUENCE TO A SET OF ROWS
  323. Average, IF
  324. How to Append the Data to the Master Table
  325. event macros - xl 2003
  326. Merging Text Help
  327. How can I use the same validation for an entire column?
  328. Why have my Excel Macro Shortcuts stopped working?
  329. In 2 Excel worksheets, I am trying to eliminate duplicate entries
  330. E-mail sent for a cell in a sheet that lists a birthday as today
  331. want sumif function's range to evaluate 2 columns
  332. range of cells from + to -
  333. Creating a league table based on results
  334. mortgage calculator formula
  335. How to make data in one workbook appear automatically In another
  336. MATCH Limitation?
  337. Dynamic Average
  338. Finding Bad Web Queries
  339. Setting up a fiile/template to generate a new number when opened?
  340. Bessel function/directivity function
  341. Percentages
  342. change the colour of text in cell for minus figure
  343. Lock row in Excel
  344. New Menus - attaching but menus are reset
  345. Auto Selecting Cells
  346. Problem sorting cells containing hyperlinks
  347. HELP on COUNTIF
  348. How to add date format into if statement?
  349. how do i sort by numerical prefix ? 1423 would come before 850
  350. Workingday Calculations
  351. how to lookup a value and return multiple corresponding values
  352. Data from one sheet to another
  353. How to highlight a row containing specific phrase?
  354. How to return a value Referring to the other cell.
  355. I need to combine 30 columns into 1 or 2
  356. After adding Analysis Tool Pack, still no PRICE function, why?
  357. linking columns
  358. Reference Formulas
  359. Finding Min Cell values excluding zero in alternate columns
  360. YEAR and MONTH confusion
  361. RE: Finding Min Cell values excluding zero in alternate columns
  362. how can I fix a #value! error?
  363. Some rows sort incorrectly in Excel. How do I correct the problem.
  364. excel input 0 when cell blank or deleted by key or spacebar
  365. Converting functions into numbers
  366. don't allow users to assign the cntrl+s as a short cut for macro
  367. IRR Guess Problem
  368. column and row headings
  369. Function to return last entry in a column series?
  370. Formula writing problem
  371. Hide text in shaded cell
  372. unable to open file
  373. question about SUMPRODUCT
  374. Conditional Protection of Cells
  375. Beyond Conditional Formatting...
  376. Conditional Formatting
  377. Cell reference in diff worksheets
  378. NETWORKDAYS question
  379. right function on pasted link
  380. subtotal
  381. separate worksheet into multiple worksheets by grouping
  382. Hyperlink Formula to call up browser
  383. problem using "<=" with SUMPRODUCT - PLEASE HELP
  384. adding rows of hours and minutes to get a total
  385. Excel puts a 0 at the end of my number
  386. Confused beginner
  387. Using MAX to reference a row
  388. Find a "9" within a range using a function (T/F)
  389. sumproduct based on format
  390. Getting Excel to Calculate All Combinations of a Set of Data?
  391. The conditional format function
  392. Sumif
  393. Today() & Now() function
  394. how to do a spread sheet
  395. I am trying to set up a spread sheet to enter some real estate dat
  396. Converting numbers to text
  397. Replace on a password protected sheet
  398. how to calculate commissions
  399. Excel: custom header - is it possible to paste into header?
  400. How to calculate the RATE in annuity?
  401. How do I count a named range for a specific word or acronym?
  402. Conditional Format (month and year) = Today()
  403. how to change a color of cell 2a to blue if 2b contains a value?
  404. linking sheets
  405. Array formula help please
  406. How to blank a cell with a formula
  407. Average given criteria, HELP!
  408. Creating a list in sequential order
  409. How do I get my worksheets to print in the right order?
  410. How do you Stop Entering Duplicate Data in a Column?
  411. How can I include bmp file in excel 2000 header?
  412. Pulling in the path to a filename
  413. Ordering fields formatted YYYY Mth in a Pivot
  414. date format
  415. Excel Holiday Roster Calender
  416. Range used in a macro needs to be variable
  417. How can I correct this Time formula
  418. Link A Cell In O ne Workbook To A Formula In Another Workbook
  419. excel formula to enter "0" if cell blank
  420. Count cells with strikethrough font?
  421. Excel formula that sums if meets two requirements.
  422. Mathematical explanations/equations for Excel functions in "Help"
  423. How to add an ActiveX control in Excel?
  424. RSQ function gives incorrect result
  425. Want #VALUE! to show as blank cell
  426. simple MAX + comparison formula
  427. could someone help!
  428. Number of hours worked between 18:00 and 06:00
  429. drop down box
  430. Is there a pull down Box to alert for minus balance such as ($5.00
  431. create reference formula that looks through all sheets for matchin
  432. Comparing and Merging data
  433. Limiting the range of a lookup function
  434. =if(and(....
  435. Referring to Cells in a forumula using a function
  436. how can I get the name of the active worksheet?
  437. PLEASE HELP
  438. isolating different aspects of worksheets...as objects? through section breaks?
  439. excel spreadsheet into address labels
  440. overcoming nested IF limitations...with VBA?
  441. Add a unique formula
  442. create a list of single values from multiple values
  443. IF formula works one way and not the other
  444. Dates in Excel
  445. How do I display colour on my EXCEL spreadsheet?
  446. macro for new sheets
  447. external import of multiple worksheet data & create pivot table
  448. Links only update when external workbook is open
  449. Help with IF Statement
  450. Is there any "autonumber" in Excel?
  451. Update one spreadsheet and reflect on another
  452. what is the maximum number of vlookups in a given workbook that E.
  453. How do you link 2 drop-down menus?
  454. How can I using Excel custom document properties in the header?
  455. Income Tax Payable from table with escalating marginal percentage rates.
  456. Has anyone successfully used NETWORKDAYS with arrays?
  457. IF Function
  458. matching the column b(sku)c(count)with A
  459. how to format Doe,John to Doe, John (space after a comma)
  460. checkbox?
  461. Can I set up a sort by clicking on table a heading
  462. VBA Code To have a macro repeat on all sheets in a workbook
  463. Locking linked cells
  464. Counting the number of times a specific character appears in a cell
  465. "IF" function - 7 nested limit
  466. Printing in Excel2000?
  467. Time stamp that does NOT update
  468. Finding a value within two rows
  469. Adding a column that used X's
  470. significant digits for decimals
  471. How do I fill the upper or lower half of a cell with color?
  472. Eliminating blank cells in a list on a ROW
  473. How copy Excel macros from Excel XP (or before) to Excel 2003?
  474. search all tabs for tab name specified & lookup reference?
  475. how do I include advance payments in the PMT function
  476. How do you create an Excel Gantt chart with double bar per line item ?
  477. countif function
  478. how can i do a (fx) visible in a cell
  479. Navagating issue
  480. Locked & protected cells still can be changed
  481. Reflecting info between an excel file and a word one or two excel file.
  482. Payroll analysis
  483. Using VLOOKUP across multiple files
  484. Countif using Wildcard * and number 1
  485. Multi column Drop-down tables.
  486. Calculate Total Sales from a Database
  487. listing and selecting data
  488. Hide 0% figures in Pivot Table
  489. Editing Repeated Text
  490. Moving a sheet from one work book to another?
  491. Moving week numbers
  492. Charting
  493. How do I read a file name into =[BookA.xls]Sheet1!$a$1?
  494. useform autosize to fullscreen problem
  495. Just a test message to be deleted
  496. Convert mins:secs to seconds only
  497. following a hyperlink
  498. multiple hits in random sequences
  499. formula cut and paste
  500. Sorting imported .txt data in Excel
  501. dividing columns
  502. Unusual data format
  503. Complicated conditional formatting if numbers match across a data set..How?
  504. formula that calc the diff in time, with a less than function?
  505. Formula to predict a future date
  506. help with vlookup across multiple worksheets
  507. formula to calculate future date from date in cell plus days
  508. Split data in column
  509. How do I write a formula in Excel
  510. Vlookup based on designated occurrence of value
  511. Conditional format combined with functions
  512. Compare worksheets and generate list of missing data?
  513. Why doesn't my resized worksheet have a minimize or close box in .
  514. SUMIF With Multiple Criteria
  515. How do I always insert last cell from a increasing array ?
  516. How do I hide #N/A, ### in cells not yet worked on?
  517. trying to archive need suggestions
  518. Translating an IF formula from Lotus 1-2-3 to Excel
  519. hide sheets use data
  520. Can I retrieve a value and its format using the minimum function?
  521. Text to Number
  522. why does this appear when i hit the = sign : =[ or[=
  523. How can the count of filtered records always display?
  524. Cell Validation
  525. subtotal a range of cells on a different worksheet
  526. Formula Constant
  527. Copy data to another column Macros
  528. can't find custom function code
  529. convert excel spreadsheet to a calendar?
  530. edate function
  531. Extract Fractional Numbers as Numbers NOT Date
  532. IF Statement Help please
  533. Getting corresponding test value to a MIN function
  534. sort worksheet without affecting workbook
  535. Convert weeknr to a date
  536. Extrapolate numeric values from text string
  537. len function
  538. Is there a formula in Excel to calculate a loan amount?
  539. Sumproduct
  540. double lookup
  541. excel formulas not copying
  542. Creating a Web Query
  543. Excel XP - Printing multiple worksheet in a workbook
  544. Random Date Generation
  545. Size of a Worksheet
  546. how do I print address labels from an Excel Spreadsheet
  547. Formula for a time card
  548. Currency button
  549. Conditional Formatting
  550. Text displays as ### in a cell.
  551. Extract Numbers from Alpha-Numeric String
  552. Interpolation
  553. Data Validation or Conditional Format (or combo of)
  554. Changing a Formula in Conditional Formatting
  555. Blanking out a field
  556. Calculating Cells n% displayed in a cell?
  557. Estimating costs
  558. multiplying with excell
  559. Formatting Question
  560. Using a cell value for row in R1C1
  561. 2003 compatibility with earlier versions
  562. Excel-links in worksheet shows #Ref
  563. Need to Sum Mon-Sat each seven days; Average Sunday
  564. Distribution of reporter cells according to a specified column
  565. Returning one text value in a long list?
  566. Why does / key act like Alt+F and highlight file menu not type /
  567. how to let the userform autosize depending on the screen resolution
  568. color the interior of a range
  569. embeding a picture into a cell
  570. Range Lookup in VLookup ?'s
  571. Hourly rates
  572. numbers to time
  573. function
  574. Excel should let me change the form data arrange direction
  575. Activex Text Box Protection
  576. deducting the same percent in a column
  577. how to I make an excel spreadsheet into a label format?
  578. formula or macro
  579. Convert Text to Number
  580. format combobox in userform to accept dates
  581. SUMPRODUCT as array formula?
  582. redistributing figures based on %
  583. Simple find with right function
  584. Has anyone had formulas change automatically with no explanation?
  585. Counting Expression in a Single formula
  586. excel formulas
  587. create formula to add 15 minutes to previous time value
  588. Pull and store a value on specific date in another cell
  589. Vlookup using text
  590. how do i sort a column numerically going from 01-01 to 225-99
  591. How do I write an 'if exist" statement
  592. toclearasell
  593. j2thea
  594. I need a " IF THIS THEN _" formula
  595. Yup - another question!
  596. Mortgage Calculation Question/s
  597. Function or Formula
  598. Formatting data within an equation
  599. formula to differenciate whether a cell contains a funtion or numb
  600. Lookup Value between 2 ranges
  601. how to fourth root a number on excel
  602. Find a "date" in a column of dates in Excel 2000
  603. # of Worksheets
  604. Historical Quotes
  605. Can excel take content from another cell and add information either side??
  606. Need Help with Replace Function
  607. Week ending
  608. sumproduct
  609. Vlookup returning Hyperlinks
  610. Setting to Keep a Spreadsheet in Front Window
  611. How do I auto fit when the cells are merged together?
  612. index / match ?
  613. blank cells with auto fill in excel
  614. Hyperlinks change path on save in Excel 2003
  615. UK Postcode formula
  616. Countif with star operator in criteria
  617. Uge nummer
  618. anova post-hoc analysis: tukey test
  619. How do I connect 2 Excel Sheets to give auto answer on the 3rd
  620. Showing Mininum $ for items
  621. adding color to cells based on a formula
  622. large / sumproduct combo
  623. Can Excel calculate the effect of extra principal on loans?
  624. Combining sheets on one
  625. blank values
  626. Loading Office 2003 Service Pack 2 conflicts with Excel Subtotal
  627. Goodness of fit function
  628. If True Concatenation
  629. Progressive Calculation
  630. Excel worksheets
  631. How to create a combination chart?
  632. Custom export with multiple rows for each row in original spreadsh
  633. Cut command
  634. How do I ignore cells with errors when calculating an average?
  635. update multiple worksheet in single book
  636. Sum YTD Budget
  637. Can I apply Cond. Formatting to a Formula result?
  638. Max and MIN question
  639. RE: Max and MIN question
  640. RE: Max and MIN question
  641. linking cells
  642. 12 digit code sorting
  643. IF text statements
  644. DIAS.LAB function poblem
  645. Text to columns delimited by carriage return
  646. How do I set up a notification for expired items in Excel?
  647. formula returns error in version 2003 only
  648. Begins with as criteria in function
  649. Indirect in combination with ROW
  650. Radio Buttons
  651. Monthly Totals
  652. Commission Calculation
  653. Data Validation List Length
  654. How do I display the user details in a XLS sheet?
  655. Permanant button for macro
  656. understanding dash dash in a excel formula
  657. Conditional formatting depending a range of cell
  658. Templates in Spanish
  659. Sum box at bottom toolbar of Excel
  660. GO TO
  661. substract cell F from cell H and total into cell I
  662. different tables
  663. Date Format
  664. Test
  665. How to extract the data
  666. I have several old WQ! files - how can I open them in Excel?
  667. How to merge one cell from many workbooks to one cell on one work
  668. valid formula doesn't work in 2003 version
  669. How do I set a rule to add a number, but only if it is positive?
  670. IF Formul
  671. Conditional Formatting - Can I select a select with Conditional Formatting?
  672. Moving cells
  673. How do I show number of resources by hour in excel?
  674. Separating names
  675. Extracting specific data from a cell
  676. I dont think there is a formula to do this
  677. how do I prevent a RAND number from changing
  678. link between sheets get messed when master sheet is sorted
  679. sorting master sheet messes up cells in other sheets linked to it
  680. sorting master sheet messes up cells in other sheets linked to it
  681. how would you do A40-20 = aA20, the value 20 is in another cell
  682. Multiple IF functions
  683. Chart Help Needed
  684. list generating
  685. PV of uneven stream of cash flows
  686. if function constains date
  687. calculating data
  688. Help with PV calculations
  689. How do I write a formula in excel that calculates payroll?
  690. Headers getting lost in multiple sort
  691. Formulas and/or formating
  692. Opened Autosave but when closing workbook Autosave closes itself
  693. Calculating the number of cells containing dates within the last m
  694. COUNT.IF, how to include single cells
  695. simple find
  696. how to calulate time in hours cbetween two different dates?
  697. How to Specify a range using another cell vale instead of row number
  698. Preventing Duplication
  699. Display row number of the last value in a column
  700. Is there an Excel function to shade cells?
  701. how do i stop excel from changing a dash to a zero in a cell?
  702. How to LOOKUP the last value in a column on another worksheet?
  703. IF(<criterion across sheets>,1,0)?
  704. Formula help for complex formatting.
  705. Return Numerical Label for LAST value Subtracted to reach Sum Target Value
  706. duplex print after each total page only
  707. duplex print after each total page only
  708. rows 1-2 missing from excel worksheet
  709. OWC - Saving An WorkSheet As Web Page
  710. Copying & pasting formulas
  711. book selection when using move or copy tab in excel
  712. hours to fractions
  713. deleting values in a worksheet without deleting the formulas
  714. Lookup Problem
  715. Need know what are valid SUMPRODUCTS arguments and functions
  716. Sharing and Solver
  717. Real RATE of return using =RATE illusive, inflation adjusted inflo
  718. I Need a formula to evaluate a cell with + or - values
  719. bibliography cards for research paper
  720. SUM OF GROUPS
  721. Need help with this function
  722. Using CountIf with criteria on another sheet
  723. Selecting Worksheet by it's value originally given
  724. Using CountIf with criteria on another sheet?
  725. Absoulte referencing between worksheets
  726. Strip text before character
  727. Choices for User
  728. Get cell value with multiple criteria lookup
  729. Worksheet IF Functions
  730. How do you assign clip art to a cell?
  731. Need No Blanks List based on two conditions
  732. Project Management Schedule
  733. How can I cross reference 2 excel docs to look for duplicate info
  734. How can I Lookup and sum payments for cash flow forecast?
  735. Excel Cell Format - 2
  736. In the worksheet_change event, how do I determine what occured?
  737. MS Excel Cell Formatting
  738. IF with OR Question
  739. Looku values
  740. looking for ideas for calendar in sheet with separate months
  741. when i delete a row in one worksheet, how do i...
  742. Lookup help!!
  743. trouble with documents after upgrade
  744. How do I replace a return value of #N/A in a vlookup with zero?
  745. Nested Vlookup or alternative?
  746. Alphabetically reorder a text string with multiple words
  747. How to get the values using a condition refering to the other column
  748. Alphabetically reorder a text string with multiple words
  749. 2 or more lookup values
  750. Multiple Criteria
  751. How to convert numeric value to mins and addimg mins to Hrs.
  752. Formula to give 5%rise in a figure if it occurs b/wn 2 dates
  753. What Formula Q
  754. Is it possible to combine MATCH & IF to search an excel sheet
  755. How can I share information between multiple sheets in Excel?
  756. datedif problem
  757. random number question
  758. Something like CEILING or FLOOR
  759. print files & subfiles fo we can organize them
  760. merging columns - one date, one time
  761. Pivot calculated field not summing correctly
  762. Estimating figures
  763. How to get a row consecutive from a sheet to another
  764. adding amounts according to labels
  765. combo boxes
  766. Excel 2000
  767. conditional search
  768. drop down list and row extraction
  769. Proper Function not working
  770. conditional search
  771. Overtime Question Unlike Others (Pictures Included)
  772. How do I round up fractions to the next whole number?
  773. Sumproduct and offset
  774. Sorting by Scripture
  775. Spinner box in Excel to adjust date
  776. Sum Product
  777. Section Breaks
  778. Multiple Column Index Number in VLookup
  779. Macro Save File (Unique file name)
  780. How do I delete or remove additional blank pages of a worksheet?
  781. I can see th formula result in the dialog box but not in the cell
  782. Function or VBA Help Needed
  783. another interesting thing...
  784. Freezing panes--splitting spreadsheet into quarters
  785. Conditional formulas: color code text populated cells?
  786. feel that the STANDARD DEVIATION formula on Excel is incorrect !!
  787. Clear Cell based on event w/o macro?
  788. convert time imported as text to time format for calculations
  789. Data Validation Error Does Not Work?
  790. the scroll wheel button should have an optional pan feature
  791. Text from one sheet cell to appear in another sheet cell
  792. cell format in Excel 2002 SP3 will not accept long numbers
  793. populating a list box with weekly dates
  794. how can I sort alphanumeric entries by number in excel
  795. 3D Count in all worksheets
  796. Sumif() help
  797. Updated cells
  798. IF statement using multiple criteria
  799. Copy complete row
  800. How do you enter a ratio e.g. 100:1 into a cell?
  801. Clear Contents Macro
  802. is there a macro which will allow me to copy/paste another documen
  803. troubleshoot absolute value
  804. Lookup? for more than one criteria
  805. Button in Excel that will save the form?
  806. SUMPRODUCT question
  807. Excel 2000
  808. Deleting links to other spreadsheets
  809. How do I multiply cell value by percentage?
  810. What is wrong with this formula?
  811. Fiancial Calendar
  812. How can I get Excel to find the first number in a list greater tha
  813. Search multiple values & return single value - seperate worksheets
  814. Sumif - double columns
  815. Unique value in a list
  816. Repositioning a cell based on its value
  817. Excel Formula Error
  818. My view has changed, I want same view as when opening excel
  819. Is there a way I can autofilter columns instead of rows
  820. Advanced Filters
  821. Remove single spaces
  822. Search multiple values to return single values
  823. HOW CAN DUPLICATES BE DELETED,NOT FILTERED?
  824. Match Infomation
  825. Joint ranking (never seen a satisfactory answer!)
  826. loosing test fomat after using replace command
  827. Summing large columns
  828. Difference between Cells
  829. Vlookup is not enough ... can OFFSET be used ?
  830. Conditional formating using formulas
  831. Across a worksheet, which cells I have formatted as locked?
  832. Omit the first word from a cell contain text
  833. text as an argument of SUM function
  834. How to see macro code of a password protected macro without a password?
  835. Average Calculation
  836. how do you split a cell within the same column?
  837. Finding constants in formulas
  838. zeros generated by a calculated item in pivot table
  839. i want to find a value in a refference array
  840. Cell reference problem
  841. Sum values Col.A w/ indntcal values in Col.B, w/o naming Col.B val
  842. how to hide the formula
  843. Here's an EASY one for you, not me :(
  844. Last value & if,then
  845. how do i only see subtotals in a pivot and hide the detail
  846. Converging two lookups? (would save me AEONS of time!)
  847. auto cut and paste...
  848. Need crosstab function in excel
  849. Multi-lookups on variable data
  850. What formula/fn would I use to count multiple condition records?
  851. subtraction in a list of numbers that resets with a label.
  852. My formula in Excel 2002 reads: =12.08*85.60 result 1034.048
  853. Importing CSV data into a template or?
  854. I'm sure this is an easy one, but....
  855. Formula using IF, AND and OR Arguements
  856. how can I get analysis toolpack for anova calculations
  857. look up one value and return a corresponding value using lists
  858. How can I sort by the value of my formula and not actual formula
  859. Pivot Table Fields
  860. Consolidating spreadsheets
  861. In Excel, can a function yield a drop-down list?
  862. How many similar functions can be put in one cell?
  863. find an average from a range, utilizing all data > 0
  864. Count multiple data by date
  865. how get filename with worksheet function?
  866. Can I copy the formatting of a cell in a IF Fucntion "VLOOKUP"?
  867. Repeating data in a Pivot table
  868. Auto sort a linked sheet
  869. Need a Formula
  870. Deleting Duplicates
  871. Last cell used in SUM IF formula
  872. shorten formula
  873. Status Bar Autocalculate Width
  874. Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA
  875. Can you copy multiple tabs from formulas to values w/o paste spec?
  876. How to have a the liist items appear at the top, not bottom
  877. Protected sheet to unprotected sheet
  878. Need to indirectly reference columns >26 using A1 notation based on numeric column number- how to?
  879. Data Validation and Blanks in List
  880. In Excel, option to enter text in cells the same as text boxes
  881. Advanced Date Functions
  882. Not sure if question is "if-then".....
  883. COUNTA with IF trouble...
  884. A simple listing desire...
  885. Macros/Formulas
  886. now()
  887. How to produce(move) an embedded image using a formula?
  888. How do I calculate IRR using monthly cash flows, not annual?
  889. Index and Match - the next step
  890. Capturing a date field once only
  891. Getting data from another worksheet
  892. moving cells
  893. ISNUMBER and VLOOKUP Help Needed
  894. DATEDIF Simple request
  895. How do I put in more than 7 validations in IF FORMALA in EXCEL
  896. how to identify
  897. Populate List Box
  898. my comments are disappearing from a shared excel workbook
  899. Page Number of a cell
  900. How do I print out selected worksheets one after the other
  901. Validation
  902. Data Validation
  903. Generate random numberes using reference to the other cell.
  904. Sumproduct #N/A! error issue
  905. offset? match index? sumif? 2way look-up?
  906. How do I multiply a unit measurement?
  907. Which lookup should I use?
  908. HOW TO EXTEND A NAMED RANGE
  909. conditional formating??
  910. Re: Problem occur in sum function while deleting the rows
  911. Return Range of Numerical Values in Single Column based on Frequency Percentage
  912. Sort Columns in Protected Worksheet, etc.
  913. List Box Selections
  914. calculation
  915. ranking
  916. URGENT need help with if/then stmt.
  917. How to print everything in a cell
  918. if function
  919. Excel IRR calculation
  920. Lookup a value using two columns
  921. Summing hours
  922. #REF!
  923. how to run a macro when a calculation equals a certin number
  924. how to run a macro when a calculation equals a certin number
  925. Split data from one cell to two separate cells
  926. Sumproduct if column begins with text
  927. last four digits of a social security number
  928. How do I sequentially number every third page of my workbook?
  929. REPLACE Function
  930. Templates
  931. Help! How can I get data from one sheet to another
  932. HELP! Nesting IF Statements/Dependent Dropdown List
  933. Delete Row Macro - if cell > $5000
  934. Combine Indirect and Sumif
  935. formula to transpose
  936. How do center headings across columns in excel
  937. max value
  938. Concatenation Problem / VBA ?
  939. Link To Drop Down Menu
  940. using =COUNTIF to count two text values
  941. Picking one column of info
  942. Newbie - Need help with zipcode format- no options for cell
  943. formula in excel to skip cells having - number and add only +
  944. filtering row data
  945. formula(excel) to skip cells having - number and add + one
  946. lookup and if?
  947. How can I sum every third cell in a row in Excel
  948. Counting unique records based on date range
  949. Unique records of matching pairs
  950. Formula
  951. Referencing Corresponding Values
  952. Intervals as logical statements
  953. Issues with saving text file
  954. Commission formula
  955. Multiple Criteria using countif
  956. Can you link an excel spreadsheet to an outlook calendar
  957. How do I sort the data in 8 columns by two of the columns?
  958. How do I show the contents of a dropdown without showing the box?
  959. Re: Automatic List Grab?
  960. Formatting Columns
  961. Count If
  962. Can I change the font/shading of a cell by moving the mouse over i
  963. lookup formula
  964. How can I type Excel numbers to show as a barcode?
  965. Re: Conditional formula date
  966. How to compare two cells for the same numbers
  967. CountIf
  968. Re: Conditional formula date
  969. RE: rounding off month
  970. Re: rounding off month
  971. RE: Automatic List Grab?
  972. multiple selections in a sumif functions
  973. Sorting a Concatenated Range
  974. If Function Help Please!
  975. Pivot table problem...
  976. is there a conflict between afxdisp.h and atlbase.h
  977. Use of pre-defined lists
  978. Lookup Array Formula
  979. cell address of occurence of a vlookup formula
  980. conditional formula in every third row and last row.
  981. creating formula using if function
  982. sum from many worksheets
  983. If I don't have MS equation installed in my MS excel how should I
  984. An array and countif based on criteria in each column
  985. Create a summary list without using PivotTables?
  986. Auto Record Transfer (2)
  987. I need to create an array formula combined with a countif
  988. Microsoft Press book - Data Analysis and Business Modeling
  989. Warning message on file close
  990. Shortcut to refresh format cells
  991. Excel Won't Calc?
  992. How to lookup row # based on content of another column's cell
  993. Combine contents of multiple workbooks into one worksheet
  994. data validation using vlookup
  995. Excel to COUNTIF if number greater than one but less than another
  996. Calculate Interest Rate when payment changes!
  997. Auto color-shading of rows
  998. Excel Timesheet template
  999. Macro recording problem.
  1000. latest entry