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. Counting Numbers with Text
  2. How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min o.
  3. Incorrect result using NPER worksheet function
  4. sumif columns and rows
  5. Weekly data into Calendar Weeks
  6. shortcut to chnage color of selected cell in excel?
  7. Ranges with in a LOOKUP
  8. Excel Time Displays
  9. Removing duplicate values in a column
  10. Matrix and determinant
  11. formula displayed instead of the result ???
  12. Using formulas to determine date in one cell based on date in anot
  13. Problems with Find in VBA/Excel
  14. Re: Dates prior to 1900
  15. Excel: Attempting to design a questionnaire. Can I move a typed.
  16. how to convert h:mm (46:30) to 46.5 for payroll
  17. Can I use more than one set of option buttons in a worksheet?
  18. Does anyone know how to develop forumulas or algorithms for various cells?
  19. Random list (1-45) without repeating numbers?
  20. =SUM question
  21. Why is this happening?
  22. Relative addressing using names or labels in formulas?
  23. Off Topic Messages
  24. Can you help to find the right formula?
  25. how can I set up a master template and have the changes copied to.
  26. excluding cells from the formula when empty
  27. Forget SUMIF, COUNTIF and VLOOKUP
  28. VLOOKUP help
  29. Formula for average recorded blood pressure readings in 1 column .
  30. Household Budgeting
  31. Sending E-mail
  32. Sumproduct returning #NUM!
  33. Delemited string
  34. Function to operate on ink linked to cell
  35. Has anyone created forms in Excel with drop down boxes?
  36. Determine sums based on value possibilities
  37. Re: COMPARATIVE COUNTING
  38. Windows ME and Windows XP Function of key F2 is different
  39. Publishing to web
  40. Employee review form
  41. Is there a function to determine whether a cell contains a formul.
  42. Sum of specific cells
  43. Read only
  44. How do I copy a formula?
  45. Time Analysis
  46. vlookup template -> table_array
  47. About =bahttext()
  48. Formatting cells
  49. Unique values with criteria
  50. Need Help to Prevent Copy Function Use in a Read-Only Workbook
  51. Use SQL statements in Excel VBA to query SQL Server Data Problem
  52. How can I roundup to next 0 i.e. 71 to 80?
  53. help
  54. time format and adding tiome values.
  55. Retrieve last cell with data
  56. adding if statement results
  57. use of excel for payroll
  58. Time and distance formula
  59. SUM(IF( Array to avoid #NUM! values
  60. Printing in Excel
  61. hyperlinks in an excel book
  62. Help with schedule
  63. Printing
  64. autosum problems
  65. Pivot table and counting
  66. Function DMIN?
  67. Sorting mixed up linked cells in a workbook?
  68. Printing
  69. Need formula to check values of data in several cells as criteria
  70. how do I generate an array of correlated values
  71. SUMIF HELP PLEASE
  72. Excel 2002
  73. Help with large amounts of data and formulas
  74. Simple Function Help ~ Please
  75. Error on worksheet delete
  76. SUM cell shows only #####, worked before though. HELP???
  77. Break Even Analysis
  78. Checkbox reading
  79. Google Search Add-in update
  80. Need Function for adding rows on multiple sheets... struggling rookie ;) Thanks.
  81. Unprotect Sheets
  82. Access with different users
  83. refer to other xls file
  84. Repeat Paste of Data
  85. Sum array with #N/A
  86. Make Data validation List Alphabetical??
  87. How do I use Excel's convert function for apothecary weight?
  88. How do I assign a unique tracking number in excel?
  89. when a menu option ends in.... a dialogue box will appear what ar.
  90. How do I disable links on the page?
  91. How do I format 10-12 to appear as 10; 11; 12?
  92. Can I use a formula to get the worksheet name into a cell?
  93. How to use formula auditing to change upper case to Title Case.
  94. Simplify Linking to several worksheets??
  95. Macro button colour change???
  96. Cut and Paste Data in a Pivot Table
  97. Dropdown selection crashes
  98. Total number of each month in a column of dates
  99. Nested vlookup?
  100. Worksheet Name in a Cell
  101. Count the contents in a cell
  102. How can I set up equations that if the answer is false that it sk.
  103. Finding the average by dropping the lowest
  104. Web Query Sleep for until results come
  105. Excel Help how would you
  106. manipulating formula values
  107. Concatenate two halves of a phone number
  108. How do I set up sequential numbering on labels
  109. Insert a standard character in a cell of excel.
  110. Custom Grouping on Pivot Table
  111. vlookup and named ranges
  112. Need Help Again
  113. Return File Name to cell
  114. how to incert multiple check boxes in excel
  115. How do I get the number of rows that meet an autofilter criterion.
  116. Sumif Else?
  117. Addition worksheet generator
  118. ~Recent File~
  119. RIGHT function
  120. Cells and and spaces after a string of text
  121. How to change (delivery) days and automatically the receive date in an other cell?
  122. Some kinda lookup
  123. Need formula to avoid ":" in cells with tt:mm
  124. How do I convert minutes to hours:minutes?
  125. in excel how to display results of a function and text in the sam.
  126. How do I set up a Workbook with a master compiled worksheet and o.
  127. About =bahttext()
  128. How do I build a free text note from a template?
  129. How do I enter a prefix number to a colum of numbers
  130. Decimal to Binary
  131. If Formula Help please?
  132. creating pages from an alphabetical list
  133. Horizontal Sorting
  134. how do I change the font of a cell if it meets a certain criteria.
  135. intersection formula? need help expanding on it
  136. Stacked Bar Charts
  137. Last several values in a column
  138. Iserror and Vlookup
  139. How do I force a hyperlink in a spreadsheet to open a new window?
  140. {=TABLE(,H16)} more help
  141. Count Based upon Multiple Conditions
  142. merging multiple pivot tables
  143. Is there an easy way to do this?
  144. Help with formula...
  145. Is there an easy way to do this?
  146. Copy worksheet with Pivot Table and break link to original workshe
  147. multiple IF statements
  148. Import data into a calendar
  149. carrying a hyper link when using the vlookup function
  150. Help with formula to make cell blank
  151. about worksheet function =bahttext
  152. Round Time
  153. in excel, how do I choose a column and add 20%
  154. How to calculate PMT function
  155. macro error at cell
  156. RE: Round Time
  157. concatenate and format
  158. #num! error message
  159. Office 2000 excell sheet gives error message for cell color in of.
  160. RE: #num! error message
  161. how do I keep a box as a constant in all of my calculations?
  162. How to call worksheet functions from Access ?
  163. Formula for comparing 3 numbers and resulting in the lowest of the
  164. Problem with shared workbook (history sheet)
  165. What formula can you use to compound monthly returns?
  166. Comparing 3 numbers and displaying the lesser of the three
  167. Show value anyway
  168. Column Not Calculating
  169. Formating Excel functions
  170. Format Cell Colour
  171. trying to remove a watermark on the excel sheet
  172. Format Cell Colour
  173. How do I get an anniversary date?
  174. Time Entry
  175. VLOOKUP, I think
  176. How to use SUMIF to return sums between two values located in cells
  177. time formatting and time categorizing (vlookup or data validation)
  178. I want to truncate/crop 3854502.2 into 545 in Excel. How do I do.
  179. A matching problem
  180. Password error after file opens
  181. if and lookup
  182. Locked cells
  183. if and lookup
  184. Locked cells
  185. help to show formart in reference cell
  186. Macro for multiple charts
  187. RE: How to stop #REF! on linked cells in complex spreadsheets
  188. Excel Problem: VLookup
  189. Counting values
  190. #VALUE Error
  191. Merging whole workbooks???
  192. Populate embedded combo box
  193. CONCATENATE
  194. Sample spreadsheet of using macro
  195. time formatting and time categorizing (vlookup or data validation)
  196. installing an "insert bullet" icon onto toolbar?
  197. True XYZ axis 3-D charting Add-In for Excel
  198. OLAP write back via formulas (functions), not read only pivot tab
  199. Rate of return required formula
  200. how is possible working on work sheet by two person in the netwo.
  201. sumif to add data in multiple sheets
  202. WHERE IS COUNTIF IN EXCEL 2003
  203. insert a new row by formula
  204. Counting "rows", i.e. simultaneous criteria for multiple cells
  205. Use displayed value, not stored value?
  206. want if cell containts text, then increase count by one
  207. formulating if; then; enter list
  208. Using Custom Series
  209. If/Then statements with images???
  210. Help with calculation
  211. looking up nearest value
  212. formula using both vlookup & hlookup
  213. Percentile function
  214. IF statement problem
  215. what is the formula for changing the same cell on different sheet.
  216. How do I do math on a cell name in formula?
  217. copy pivot table to multiple worksheets
  218. Help!: lead sheet data needs to fill appropriate subject sheets
  219. Formula to make Excel count business days/skip weekends?
  220. Is there a way to have a function auto correct words in ALL CAPS .
  221. How do I include cell data in subject line of email address/hyperl
  222. Cell doesn't show formula result - it shows formula (CTRL + ' doe.
  223. calculate percentages
  224. How to figure roots in Excel?
  225. Data Filter - Not all rows in spreadsheet will display in Autofilt
  226. Another scheduling question.
  227. Listing of Sheet names
  228. Weird wrapping in cell
  229. Format Cell Colour
  230. Formula error
  231. how do I use "inv sine" in a worksheet
  232. Formula to reference column heading
  233. Sorting Help
  234. average, array and offsets
  235. Populate embedded combo box
  236. carrying a hyper link when using the vlookup function
  237. drop down help
  238. How do you calculate the nth root of a number in Excel 2003?
  239. Inserting Multiple Rows with Formulas
  240. Formula to reference column heading
  241. how to increase the number by 1 from the cell above?
  242. Difference
  243. Create a formula that determines a date-sensitive File-Name from w
  244. How can a UDF be called from a formula?
  245. Finding the max of a column where values less than a specified number
  246. change one sheet, and automatically the others
  247. how to convert total hours (HH:MM) into decimal number
  248. Nested Formula
  249. I've forgot password in my worksheet,how to unprotect the sheet?
  250. VALUE issue
  251. Freez in excell
  252. compound interest
  253. logical test - within a range
  254. how to move user defined function
  255. Where's the bug?
  256. Uppercase in a whole sheet
  257. #VALUE! issue
  258. Automatically insert fill colour when data is added?
  259. Automatically insert fill colours?
  260. Excel - option to extend function in cell to column
  261. If Statement possibly?
  262. Can you average data in 1 column based on a range of values in another?
  263. HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA
  264. Daily Macro to Download Data, Order and paste in order
  265. Sumif Help Please
  266. How do I convert the result of LARGE to the cell (or column) refe.
  267. Problem with LOOKUP & VLOOKUP
  268. Problem with LOOKUP & VLOOKUP
  269. How can I combine IF, COLUMN, and LARGE formulas in a single cell?
  270. Problem with LOOKUP & VLOOKUP
  271. How do I extract the last name in Excel, from a list of names lik.
  272. displaying formula result
  273. How to populate formula in range of vertical cells to next colum
  274. formulating if; then; enter list
  275. How do I create an "IF" statement with more than 7 levels?
  276. Count and then average
  277. How can I sort an entire spreadsheet from a list
  278. How to auto-refresh Pivot data when open Excel file?
  279. I need help with a formula!
  280. Is it possible to specify multiple condition with SUMIF?
  281. SUMIF with multi-column sum_range
  282. Page break macro
  283. Why do my links break when I burn multiple Excel files to a CD?
  284. How to change text in multiple cells from Uppercase to proper cas.
  285. how do I open an excel document
  286. If I have X,Y data how do I sum the Y values using a set of bins based on x values
  287. How do I round time?
  288. Controlling Linked Data to Workbooks
  289. Replace a sheetname with a cell reference to link to another work.
  290. How do I make a formula for precentages?
  291. Totals based on dates
  292. How do I write a formula to subtract a # from a total ONLY if the.
  293. How use group and ungroup functions while worksheet is protected
  294. Template / date question
  295. How do I count my data that are between specific values?
  296. need help using count if
  297. Insert Leading Zeros
  298. Links
  299. coloring issue
  300. how do i use the sumif function in non cons cells
  301. How can I use SUMIF and AND to test for two conditons before summ.
  302. Excel
  303. RE: please help with timekeeping in excel
  304. Auto-fill won't work
  305. how do i get rid of hidden apostrophes in cells?
  306. Hmmmm Upgrade Problem
  307. Can I expand a drop down list?
  308. matching data formula?
  309. Formula Please
  310. Column #'s instead of letters
  311. How can I get a total across multiple spreadsheets?
  312. edit the buttons in right click menu
  313. Fourier analysis.
  314. Referencing Variables
  315. Help! Getting different results for the same formula.
  316. excel matrix
  317. Macro to sort by cell colour
  318. Problems with Excel formulas when 2002 upgraded to XP
  319. Formula and Conditionl Formatting Help
  320. How do I match two cells and input a value in a different cell?
  321. how do i convert numbers to words
  322. need help using count if
  323. Not
  324. excel not copying formulas/formatting to next row?
  325. How do I create a .csv file?
  326. Re: vlookup and named ranges
  327. Caculate Age
  328. Filename in a cell
  329. Enabling macros
  330. how can i get rid of the ####
  331. excel not copying formulas/formatting to next row?
  332. How do I prevent my links from breaking in Excel?
  333. DSum function
  334. Dynamic number of ROWS
  335. Invoice Numbering
  336. Invoice Numbering
  337. Add a range from elsewhere
  338. linking cells
  339. Nexsted if across 3 columns
  340. Copying the contents of a column into a chart
  341. store file saved date in cell
  342. Add condition to formula
  343. Linked sheets - URGENT!
  344. To view different sheets using a drop down list
  345. Rounding Decimals
  346. Linking dates with a calendar...
  347. Bother with a formula
  348. Count / Sum if help.
  349. Best function for my situation
  350. better/faster way than sum products?
  351. Re: need array of true/false if text exists
  352. convert string to number
  353. change operating cells dynamically according to the value of a fixed cell
  354. looking up nearest value
  355. automatic order or invoice numbers
  356. Embed command button from the control toolbox doesnt work
  357. Embed command button from the control toolbox doesnt work
  358. Urgent help needed: IF function
  359. How do I see the sum or other function in the bottom bar of my Ex.
  360. Pivot Tables
  361. How to resize a comment box, by embedding code into a function?
  362. how do you group and ungroup rows or columns in new Excel?
  363. IF or Vlookup or.... Which is best for this example:
  364. Can I hire someone to fix my spreadsheet?
  365. hyperlink cell value inserted
  366. MOREFUNC.XLL
  367. CountA formula with an IF statement
  368. Sum Up Numbers w/o Breaks
  369. Countif - Countif
  370. Freeze Pane command freezes more cells than I selected.
  371. Sum Up Numbers w/o Breaks
  372. How do I change an Excel range of cells from relative to absolute.
  373. Is it possible to do a conditional subtotal in Excel?
  374. Calculate commissions
  375. Sum ranges
  376. left worksheet function within a combo box
  377. Sum Up Numbers w/o Breaks
  378. Automatically pull data into another worksheet within the same fil
  379. Mystery Cell Properties
  380. Comparing and potentially adding two fields
  381. Re: Compounded Returns
  382. Sorting for specific words/numbers in a list
  383. Rank Function
  384. how do you create drop down menus for individual cells in excel?
  385. convert 100 minute hour to a 60 minute hour
  386. Simple, Monday morning brain function
  387. Formula Modification Help
  388. Help! I am stuck calculating Days, Hours, Mins please help
  389. Bother with a formula
  390. Help! I am stuck calculating Days, Hours, Mins please help
  391. How do I merge data from one worksheet with data from another wor.
  392. pivot table
  393. How do I calculate ages of employees in Excel?
  394. TIR.NO.PER function, where do i found it in Office 2003???
  395. Help! I am stuck calculating Days, Hours, Mins please help
  396. Reading from a closed file.
  397. under certain criteria copy data.
  398. Carriage return in macros
  399. Simple, Monday morning brain function
  400. How can I use an IF function to look for specific cell formatting.
  401. Re 'BINOMDIST' function
  402. Help Excel97 gives incorrect multiplication response
  403. Countif & ranges consisting of multiple areas
  404. Countif & ranges consisting of multiple areas
  405. Determning the ROW of a vlookup result
  406. Countif & ranges consisting of multiple areas
  407. Countif & ranges consisting of multiple areas
  408. Conditional Formats in Excel
  409. SUMIF/COUNTIF with an additional criteria
  410. I can't find the megastat ad-in in Excel
  411. find date in Col A corresponding to min value in Col B
  412. Text Help
  413. Text Help
  414. Help with IF calculation
  415. Help with IF calculation
  416. Indirect references in a linked formula
  417. Help with IF calculation
  418. Help with IF calculation
  419. Help with IF calculation
  420. reference-one cell to another
  421. Indirect references in a linked formula
  422. Calculation
  423. how to change "Find" feature
  424. Automatic Sorting of a group of columns.
  425. Minutes to seconds - how to convert?
  426. How can I see an example of the vlookup function in excel?
  427. Totalling Separate Worksheets
  428. Using the results from two seperate cells to create cell reference
  429. Using the results from two seperate cells to create cell reference
  430. Change Font Size
  431. Copy formula to every 12th cell
  432. date
  433. Tables
  434. Re: Excel Key Field option?
  435. Change format of cells
  436. insert default value
  437. RE: Increment an Invoice number
  438. Combining conditions for data entry validation
  439. Need to put data in a new cell at close of market.
  440. Protected sheets
  441. Change format of cells
  442. Cell is not responding to wordtext
  443. Lookup with search range start based on position of last blank lin
  444. Changing Colors of Cells
  445. Solver Table missing in Data Menu of Excel2003. Where is it?
  446. headings
  447. Dynamic Column VlookUps Based on Week Number
  448. How to split one column into two?
  449. Extend data range format and formulas
  450. Return A, B, C, or D depending on percentage
  451. Returning a Value to a Cell Based on a Range of Uncertain Size
  452. How can I format text in a column on a landscape worksheet?
  453. summing cell into one
  454. percentage of growth
  455. create a date from year, day and month
  456. Help with a formula
  457. VBA: Update worksheet when txtBox data changes.
  458. Change Text Colot to RED *IF cell value is positve?
  459. Text in Blue colour, but print in black colour
  460. Spellnumber
  461. Macro to hide rows with empty cells
  462. Use IF function for two conditions
  463. hyperlink images in batch form
  464. Compare List
  465. Regarding IF function or vLOOKUP function
  466. How can use IF function more than 7 times in a cell
  467. Excel file
  468. help with cell conditioning?
  469. In Excel is there a way to read the name of the sheets tab and di.
  470. Address of named range
  471. Sum of Duplicate Values
  472. Formula Question
  473. need help with time formula
  474. Is there an easy way to "exclude" an outlier datum from calculatio
  475. insert a page number into a cell?
  476. Need to put data in a new cell at close of market.
  477. Modify SUMIF and COUNTIF to work with SUBTOTALS
  478. break links in excel using Office 97 ?
  479. Extra Character in cell
  480. External reference as a condition
  481. Wild Card and Dates
  482. adding two sumproduct formulas together
  483. Circular functions
  484. nesting if > 7 or using hlookups in a vlookup
  485. Circular functions
  486. How do I link non-numerical data from one worksheet to another?
  487. Sort/Link Worksheets
  488. Help!: lead sheet data needs to fill appropriate subject sheets
  489. Why does the formula result show a number but the screen shows ze.
  490. Searchable Database
  491. External reference as a condition
  492. How do I peg 4 col in an equation so when i add one col it only l.
  493. VLOOKUP not working
  494. pulling characters out of a string
  495. Duplicate Rows
  496. Compare List
  497. I want to sort data randomly in addition to the current descendin.
  498. Automatic Calculate Worksheets
  499. Summarize by "Median" in the Pivot Table Field for Excel
  500. Sorting by color?
  501. Btwn to date entries
  502. Question about "replace"
  503. ISBLANK
  504. Display a countdown timer
  505. Sequential names on Sequential pages
  506. Can I re-number the row numbers?
  507. <>
  508. Change Path names in copied work book
  509. I want to be able to insert 1 Excel Wkbk (w mult tabs) into anothe
  510. IF statement with 3 possible outcomes
  511. Sum if w. 2 criteria
  512. What formula to use?
  513. Nested IF
  514. ISERROR Functin to Much Work!
  515. Against
  516. how to convert multiple columns of data into one single column?
  517. what is clearing an assumption?
  518. Hor to write numbers in letters in spanish
  519. Hor to write numbers in letters in spanish
  520. Transpose
  521. In Excel, can I copy Headers and Footers between Worksheets?
  522. Counting columns and specific Dates
  523. Counting in arrays
  524. Need help with SUM IF formula
  525. Worksheet re-arrangement
  526. Formula Fill properties
  527. The IF function
  528. DSUM frustrations
  529. DSUM frustrations
  530. DSUM frustrations
  531. List to array
  532. How do I create a total sheet that will pull info from all my she.
  533. How to convert Numbers to text
  534. How to convert decimal values (dd.dddddd) to degrees/minutes/seco.
  535. How do I count or display unique data in a column?
  536. Too Many Different Cell Formats
  537. Too Many Different Cell Formats
  538. Vlookup limitations
  539. Re: calculating formulas for all workbooks in a folder
  540. formula
  541. Formula
  542. Re: All functions
  543. Count of unique items meeting condition
  544. Formula
  545. Column numbering
  546. Lists: Clicking on one item in one list and getting certain info i
  547. Help with a formula
  548. Single quotes in named range
  549. name of another worksheet in cell for reference
  550. countif(a1:a12,">TODAY()") How do I get this to work?
  551. formulas are no longer calculating...what can I do?
  552. Show a date based on today
  553. Help on a formula
  554. Show a date based on today
  555. Font Size
  556. Show a date based on today
  557. HOW DO I DECONCATENATE
  558. Help on automatically ending a calculation
  559. Excel - if cells = 0, how to conditionally hide rows in chart
  560. Single list from multiple sheets
  561. Need IF statement that leaves value unchanged
  562. lookup help with multiple hits
  563. How to load Engineering Functions into the Fx function wizard?
  564. hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION
  565. Count occurences between dates
  566. Formula to extract pricing from a chart
  567. Need IF statement that leaves value unchanged
  568. Data Validation Formula Help
  569. Excell should have a sentence case function like the UPPER() and .
  570. Disable automatic date conversion feature
  571. Help on a formula
  572. Excel search results are hard to identify.
  573. finding common numbers in large lists
  574. Put an autoshape in a cell based on another cells content
  575. Between Symbol
  576. Excel Date Function
  577. Link & Update Two Workbooks
  578. Link & Update Two Workbooks
  579. Formula to Seperate data in 1 cell
  580. vlookup question
  581. UNIQUE
  582. Help with autoupdate....
  583. Count Days excluding Sundays
  584. Subtracting time in date format
  585. Test for Single Character That is in an Array
  586. sumif with 2 criteria
  587. Update dialog box
  588. Help with autoupdate....
  589. formula to sum all sum calculations in a column
  590. Update / don't update dialog box
  591. Stop rounding values
  592. show macro security setting in a cell
  593. Absolute Reference
  594. How do I delete 100 account numbers from a spreadsheet colume wer.
  595. how do i keep a value and get rid of a formula?
  596. Diff. in time
  597. Date VLookup
  598. Diff. in time
  599. cell that accepts a whole number or five place deciaml
  600. RE: re-install gridlines
  601. Calculate date of birth in Excel
  602. Selecting Data for report
  603. How do I match values?
  604. Statistical Function
  605. Diff. in time
  606. Mixing Font Sizes In A Cell Formula
  607. tell excel to operate in hexadecimal ( base 16)?
  608. how do i use the sum if formula with a date range?
  609. Replace function not working properly in Excel 2000 SP3
  610. Help with setting up a worksheet funtion
  611. Dragging formulas
  612. Protecting a sheet that includes a solver function
  613. Conversion lookup formula
  614. LEFT formula doesn't works..
  615. Add up the hours for each month
  616. Column Index
  617. if Error
  618. counting in pivot table
  619. change bahttext format to different format style
  620. up-date hyperlinks in Excel
  621. SUMIF problem
  622. Pivot Table
  623. Printing in Excel
  624. SUMIF problem
  625. Identify date in 2 rows
  626. LookUp - Exact only
  627. Sumif for lowerst value within limited to 2 numbers only
  628. LookUp - Exact only
  629. copy workbook
  630. how to insert row automatically after hitting enter at the end of.
  631. Help with Commission forumlas
  632. How do you extract numbers from a string of chacters in a cell (E.
  633. unique sorting
  634. Is there a formula to spell out a number in excel?
  635. Help on a formula
  636. Start_Day Name Help
  637. Double Lookups
  638. HELP: Access table linked to Excel - calculated fields?
  639. Help With Formula
  640. Rounding - for retail prices
  641. help with formula
  642. Number format-numbers appear as dates in Excel
  643. calculating date time ranges
  644. Duplicate fields does not match up! If statement
  645. How do I get a count when I filter an excel worksheet?
  646. help with formula
  647. Count occurences between dates
  648. Help on a formula
  649. How do I install the AMORLINC fx formula to Excel 2003?
  650. automatic delete possible?
  651. Calculate # of Days from one date to another
  652. Office 2003 will not view interactive Worksheet saved as a web pa.
  653. Help on a formula
  654. Subtracting time in date format
  655. Duplicate fields does not match up! If statement
  656. Password help please
  657. how do you use the ActiveX Calendar control in an Excel Worksheet.
  658. Adding time in Excel
  659. Subtracting time in date format
  660. How do I retrieve data (specific cells) from multiple worksheets on a shared drive
  661. Copy and dragging cells
  662. Display numbers only, no text formula
  663. Sorting Data to Different Sheets
  664. Automatic return in an excel worksheet
  665. intellectual vlookup
  666. Formula window displays correct answer while cell displays incorre
  667. Subtracting time in date format
  668. counting specified date entries
  669. Seach Column and return multiple dates to another worksheet?
  670. sum of different cells in different worksheets???
  671. sum of different cells in different worksheets???
  672. Formulas
  673. How to change single cell width
  674. How to change a single cell's width
  675. How to change the width on individual cells
  676. Help Pleasssssse
  677. Searching a column and copying rows
  678. SUMIF multiple criteria
  679. Drop List Referencing
  680. countif() help for multiple rows
  681. How can I see a list of macro key assignments in Excel 2002?
  682. print 1 long row(20 columns) in excel to one single page
  683. Highlight formulas
  684. sort in hex
  685. sum of different cells in different worksheets???
  686. Protecting a sheet that includes a solver function
  687. calculate percent from multiple criteria
  688. Requesting Help
  689. Formula looks like a label
  690. countif() help for multiple rows
  691. Sort 2 lists - one w/ last, first name // one w/ first, last name
  692. Fastest Way to Filter/Delete
  693. macro's
  694. Subtracting time in date format
  695. AND and IF Functions
  696. Need number of months or weeks passed from formula
  697. sort in hex
  698. Days of the week.
  699. Sorting using HEX
  700. Slow Computer
  701. Can I mail merge filtered data on an Excel spreadsheet to a word d
  702. How do i create a "look up" to sum values in excel?
  703. How can I convert an excel file into a list of conference attende.
  704. Rounding up and down
  705. Passwording
  706. Problem with search
  707. Re: Problem with search
  708. coverting answer from Radian mode to degree mode
  709. Subtracting time in date format
  710. vlookup
  711. showing the # of times an item is entered in a column
  712. round up ?
  713. copy group of cells to another group of cells using "IF" in third
  714. insert picture into excel
  715. How do I create a formula in Excel that will countif or sumif bef.
  716. How do i get an average that ignores blanks in the range of cells.
  717. Excel Lookup Functions
  718. VLOOKUP and AND function
  719. SUMIF or SUMNPRODUCT Help
  720. Formula help SUM(IF((...
  721. Excel Lookup Functions
  722. Saving a position dinamically
  723. Find duplicate rows then deleting them
  724. how to build a formula to match numbers in 2 columns with the equ.
  725. Impossible Formula!
  726. Is there an autofill for all row fields in a pivot table?
  727. Feature in Borland Quattro - Is this in Excel??
  728. Multiple Shipping problem
  729. Renge filtering
  730. Excel 2000 Functions
  731. Extend conditional formatting to more than 3 conditions
  732. Copy on filtered list
  733. Problems with functions
  734. .CSV file format - comma or semi-colon?
  735. .CSV file format - comma or semi-colon
  736. Problems with functions
  737. Tracking activities
  738. Is there an easy way calculate 2 variables in conditional sum wiz.
  739. How do I make a group of data (not figures) which could be collaps
  740. algebraic function
  741. Sum of cells in different worksheets
  742. Re: Worksheet Event Code
  743. How do I make an If-Then formula in Excel?
  744. Difference of date & time in minutes
  745. Select all worksheets
  746. How do I select all worksheets
  747. Color Code Filter indicators - Change from Blue to Red
  748. Conditional if statement
  749. jpeg picture always the same size
  750. Excel 2003 - Formula result shows as 0:00
  751. Need Excel Analysis toolpak - don't have CD, where to download?
  752. Sumproduct Multiple Conditions
  753. problem with countif
  754. How do I create a formula that could have two different outcomes?
  755. SUM until blank cell
  756. Report
  757. How to verify that 3 cells are equal
  758. listing data without blank rows
  759. How to verify that 3 cells are equal
  760. Removing links to other workbooks-Excel 2000
  761. formulas for transferring data validation information in excel 200
  762. SUM problem
  763. printing rather than doing
  764. Impossible Formula!
  765. calc constant date from variable date & return with ability to rn.
  766. Formula to refer to other worksheet...
  767. How do I see detail of summed cells
  768. re-naming worksheet tab adds ".xls]" to the begining of the name I entered
  769. SUM until blank cell
  770. number format
  771. How do i Match all COLUMNS?
  772. average without 0 value
  773. Convert week number into calendar month?
  774. Rounding to the next highest 1000 after a resulting formula
  775. Paste Link and Templates
  776. Impossible Formula!
  777. Excat Forumla HELP
  778. PMT formula
  779. Impossible Formula!
  780. displaying results and not formulas
  781. range names
  782. range names
  783. range name
  784. range names
  785. Unknown IF function parameter on amortization schedule
  786. String function
  787. Protected Cell Link
  788. range name
  789. Impossible Formula!
  790. How to filter by greatest of
  791. Merging Cells but have each cell counted in the range of merged c.
  792. GETPIVOTDATA - Pivot table name problem?
  793. Sorting data while the shading stays the same
  794. Re: Have negative numbers show as zero
  795. Rounding a number to a multiple quantity that adds to a fixed total number
  796. Please Help Guys!
  797. Finding last cell to contain same value as current cell?
  798. Inserting Blank Rows Macro?
  799. excel oc curve
  800. Saving Macros
  801. Isolate text following a period (".")
  802. search & replace
  803. Problems with functions
  804. Please Help Guys!
  805. Complex formula help needed
  806. How do I know if another user have inserted a web query on my wshe
  807. Complex forumula help needed
  808. search & replace
  809. Sumproduct in Excel Spreadsheet to read Access db table
  810. formula to determine the first column containing any data
  811. Generate random numbers 1-100 without any repeats?
  812. How do I define the signum function sign(x) in Excel?
  813. Re: Entering Path Name in Footer
  814. pivottable - show all not appearing
  815. Multiple Worksheets in a workbook
  816. tricky conditional formatting
  817. Remainder Zero Function?
  818. getting data from 2 different exc sheet
  819. Adding cells with numbers and text
  820. Multiple Vlookup?
  821. getting data from 2 excel sheets automatically
  822. Can I count values in column 1 if criteria in column 2 are met
  823. Req, Tricky column formula
  824. import currency rates into Excel?
  825. Scurve fomula in Excel
  826. sort data with the same result
  827. Req Formula to place 1 into next columns
  828. VLookup accesses half the text in a field?
  829. If formula help
  830. Complex lookup task for a newbies
  831. Easiest Way to do this Importing method?
  832. how do i set up employee performance database in excel
  833. stop excel from shifting cells up when a query returns no data
  834. EZ Q 4 U: How do I change a number to text, based on the number
  835. Copy macros to new computer
  836. cell info
  837. How can I make a picture of my Excel sheet?
  838. rounding again
  839. How can I get the lowest price, second lowest etc. from a range o.
  840. cell info
  841. search & replace
  842. How do I program a cell to automaticinput the current date as dat.
  843. Sorting
  844. Need Formula Help
  845. Lookup Doesn't Work
  846. rounding
  847. MATCH Question
  848. label problem
  849. RE: Printing to PDF
  850. Drop List Referencing
  851. changing a cell value depending on an If Function/Lookup
  852. Need help with a Macro
  853. running totals in a macro for each month
  854. How do I convert 300616a to show as a number 303616?
  855. Re: Conditional Formatting
  856. Can you get around the GETPIVOTDATA command when referencing a pi.
  857. Re: Hyperlinks Problems
  858. word lookup
  859. Need assistance with cell formatting
  860. Need assistance with cell formatting
  861. Delete carrots in a string
  862. Need help with cell formatting
  863. Delete carrots
  864. can you use a variable or cell reference in a getpivotdata formul.
  865. Re: Conditional Formatting
  866. How do I create a multi formula IF function in Excel?
  867. Can I hide locked cells?
  868. Find a match that;s not exact
  869. Help with formula please
  870. I need help with a formula
  871. write a formula to sum cells on different pages of the same workb.
  872. sql.request
  873. SUMPRODUCT problem
  874. How do I turn off ALL autoformat in Excel ? (I can't even type "J.
  875. Re: Random # Generator
  876. A=P(1+i)^n
  877. I can't edit excel by right clicking
  878. max and min
  879. Can you enter a formula in a cell that auto-inputs calculations a.
  880. I need to randomize a column of alphanumeric employee ID's for a .
  881. The colors should work properly in Shared Excel Workbooks.
  882. alphanumeric cells
  883. Autofill skipping cells
  884. how do I name ranges in an Excel worksheet
  885. Time / Formula to look at time difference
  886. Formula MATCH error
  887. Vlookup, Index & Match
  888. VLOOKUP dragging down
  889. Formula needed
  890. VLOOKUP dragging down
  891. Distinct Value With Countif
  892. Summation Problem
  893. how to format pull down rows
  894. Formula MATCH error
  895. Re: Pivot Table "Show All" Check Box missing in Excel 2000
  896. cells lose relativity to other WorkSheets after data sort?
  897. Setting up data to create a chart
  898. Data calculations require more than 7 nested functions
  899. Data calculations require more than 7 nested functions
  900. how to hide #N/A's?
  901. What is the "TextBridge" menu button used for?
  902. formula from Excel97 doesn't work in Excel2003,any ideas why?
  903. Too many nested functions
  904. How do I setup a list box that has several account numbers so use.
  905. How do I create a personalized heading row in excel (one that rea.
  906. Sort by Colour?
  907. hyperlinks
  908. GETPIVOTDATA - Pivot table name problem?
  909. IN EXCEL...I CANNOT COPY THE TOTAL LINE AND PASTE IT ...I GET REF.
  910. Counting Function Dilemma
  911. Is there a way to sort by color in excel? using macros?
  912. view multiple sheets from same workbook
  913. Adding column data
  914. Req Formula to place 1 into next columns
  915. Date Difference On Working Days
  916. Populating cells based on calculation
  917. SUMIF
  918. deleting second open window in a workbook
  919. Difference between two dates in months with decimals
  920. IF or SUMIF help for Overtime Formula
  921. Numbers Wont Sum
  922. Determining Dates Within A Calender
  923. <>
  924. Combining Defined Names to New Name For Validation
  925. Change Color on an IF statement
  926. SUMIF or SUMPRODUCT or something else?
  927. GCD Function doesn't work in some cases
  928. Advanced Window Split & Freeze Question
  929. How do I set up a dropdown list in excel? The instructions given .
  930. Insert Month and Year in my worksheet
  931. I am entering data but it appears as a date in excel
  932. Cell Formula Help
  933. COUNTA Function not working =COUNTA(C3:C69,"NH")
  934. Change Color on an IF statement
  935. Newbie: How to round down to the lowest 5
  936. Only using the correct cell for the sum
  937. change function variable prompts??
  938. Only using the correct cell for the sum
  939. How to calculate the data in excel 2002 including only the last 9.
  940. combining several individual cells of numbers into one cell
  941. Formula help on a cell
  942. Group by count formula
  943. Indexing/Referencing
  944. error checking reports a value in the formula is of the wrong dat.
  945. help please with conditional format problem
  946. Conditional Formatting
  947. Naming & renaming a sheet tab
  948. How do I change a date in a cell
  949. conditional formatting
  950. Can you run a macro from an if statement in excel?
  951. Modify Row & Cell Contents based upon Cells Values
  952. looking up a value between two numbers and returning a related value
  953. How do I count how many times x appears in a column?
  954. hide "#VALUE!"
  955. Using two separate scenarious in one IF function
  956. IF Function or IF then else
  957. Summing values of corresponding columns
  958. lookup function?
  959. I have a password problem
  960. How do I disable text-to-speech in excel?
  961. SUM array formula question
  962. Countif ???
  963. Modify Row & Cell Contents based upon Cells Values
  964. RIGHT Function
  965. Appl need that VLOOKUP will not handle
  966. Modify Row & Cell Contents based upon Cells Values
  967. Summing cells in Excel
  968. Summing cells in Excel
  969. Help Needed With - If-Function
  970. PASSWORD
  971. Problem with Pivot Table Drop-Down Menus
  972. How can I subtract 111 from a number like 097 and get 987, using .
  973. excel 2003
  974. Vlookup
  975. Delete contents of unprotected cells in workbook
  976. Conditional formating in excel
  977. First column that does not contain "Cucumber"
  978. Modify Row & Cell Contents based upon Cells Values
  979. Formula Recalculation after using AutoFilter
  980. How do i increase the size of numbers in a text in Excel.
  981. letter Validation
  982. selecting and listing data
  983. letter Validation
  984. letter Validation
  985. letter Validation
  986. ANY FORMULA FOR CHECK =ISBOLD(A1)
  987. Macro did not run after download file from net
  988. Excel 2003 - referenceing the active worksheet page in vlookup
  989. 00-jan-00
  990. 00-jan-00
  991. Years when 1 April occurs on a Saturday
  992. Problem with time calc
  993. How do I Delete a file from the drop down file menu?
  994. conditional formulas in excel
  995. letter Validation
  996. Need help!!!
  997. SUMPRODUCT - HIERARCHY
  998. generating Unique ID numbers for students
  999. Conditional Format Advanced
  1000. generate serial number