PDA

View Full Version : Microsoft Excel Worksheet Functions


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 [68] 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160

  1. Vlookup and few more questions :)
  2. IS THERE A DAILY MEDICATION DOSAGE LOG TEMPLATE ?
  3. What is wrong with this formula?
  4. How do I use the IF formula to flag me 21 days after the date?
  5. How do I use the IF formula to flag dates 21 days prior to deadlin
  6. User Defined Functions - local or global?
  7. can i convert a worksheet with data into a calander
  8. how do i set up a 'rolling shift pattern' worksheet?
  9. Whatsthe formula which retrieves a # from a multiplication table
  10. look up with multiple criteria and within a range
  11. I need a specific formula in excel
  12. Match with tilda characater
  13. Limit on array formula
  14. Excel 2007 (Beta) Auto Filter
  15. How to have information auto input if cell = yes
  16. mutiply by either REG or OT hours, and SUM!
  17. an if( statement looking for a specific phrase anywhere in a cell
  18. Last column entry lookup.
  19. formulas using if parameters
  20. ADDING A PRINT CONTROL BUTTON
  21. Concatenate & Date
  22. Pull last word from a text string in Excel
  23. How to open a workbook on a specific worksheet.
  24. Need to sum "last 5" red cells
  25. Text Restrictions
  26. top ten customers by transaction count by product
  27. How to calculate time after converting 12.22 to 12:22
  28. Removing 1-2 caharacters
  29. ranking based on criteria
  30. if function and ifblank() function
  31. Formula not copying down
  32. Counting if between date range
  33. copying date from one sheet to another work sheet
  34. Re: Need big help with look up....is this possible
  35. Can I protect a document and still open / close groups
  36. Naming Cell in diffetn worksheet
  37. Naming Cell on differnt worksheet
  38. calculate the sum of characters in a cell
  39. Pivot Tables
  40. Need Help Badly!
  41. Can I position a PAGE NUMBER side of a sheet?
  42. Complicated SUMPRODUCT
  43. why doesn't this formula work?
  44. how do i use if function to different texts
  45. formula to auto populate zip when city is typed in Excel
  46. Multiple conditions for conditional formatting
  47. How do I insert a drop down list button from an excel worksheet?
  48. Adapting MAX function
  49. Nested IF functions beyond eight items?
  50. tracer arrows not visable
  51. How do I limit characters in a cell?
  52. Conditional Formatting
  53. REmid function
  54. skip errors in an average
  55. If a Row is blank
  56. formulas within a work book
  57. Countif & Sumif with Multiple criteria
  58. Insert function
  59. Tracking Date/Actual Working Time Elapsed
  60. 2006 West Coast Excel / Access User Conference
  61. How do I repair broken links that worked with Excel 2000?
  62. Lookup a row and column and return value
  63. SUMPRODUCT WITH A VARIABLE CRITERIA?
  64. Please do not remove "Address" command from Excel 2007
  65. sumproduct with one variable criteria?
  66. Calculate working hours from a start and finish time over several
  67. Helpful New Functions: ALL and ANY
  68. Dependant Data Validation not sorted
  69. formula to lookup value and return value from cell at left of target
  70. CSE formulas
  71. How to switch negative numbers to positive numbers in Excel ?
  72. how do i delete rows that end in SMPT
  73. Re: Unlocking cells
  74. formula to choose a hyperlink from a cell
  75. Coumn/Row highlight tracker
  76. Flashing cell for conditional formatting as an option
  77. Changing cell colors to correspond to different dates
  78. How do I fix loosing 1st digit in zip code in mail merge?
  79. Hlookkup/Match won't work
  80. How do you get the values of the data between data points
  81. I'm going crazy, Excel returns 0 for a simple sum
  82. Upper case text
  83. Worksheet Colour
  84. Need ability to get cell address of max value in range
  85. chart or macro problem
  86. add time
  87. Sum column based on value in each row, if two cells equal, or if date is within time period
  88. Need to sum a column if two cells in row are equal
  89. SUMIF with the Sum_range across several colums
  90. How to display month only for date format?
  91. How to code it in excel?
  92. npv calc for customer pay plans
  93. Automotive 5 Year Depreciation
  94. How do I get speed given time (hh:mm:ss) and distance in Excel?
  95. "Workdays"
  96. Need to write 3D formula averaging total sales between 3 workshee
  97. Selecting different multiple columns
  98. Inserted Comments in published workbooks
  99. After sorting the formula has the incorrect cell
  100. Protecting Cells
  101. Employee Tracking
  102. Macro for printing
  103. Create formula
  104. Need a sorting solution
  105. INDIRECT function inside AND function
  106. Text to date
  107. Using dates as function arguments in Excel
  108. Need big help with look up....is this possible
  109. How to attach a photo to Excel
  110. Quote marks in Formulas passed from VB Script in Excel
  111. summing name range in the same column with Dynamic name ranges
  112. Summing unique values
  113. compare data in 2 worksheets
  114. USING EXCEL, delete all text right of the "!" symbol
  115. the total number of "Very Satisfied" questions there are
  116. Data comparison
  117. countif across entire workbook
  118. Previously good formulas wont run. What have I done wrong?
  119. vlookup
  120. Reference previous page
  121. Re: 3 criteria
  122. sorting protected sheets
  123. Take out judges scores
  124. Pivot tables hide info drop down menu
  125. absolute value
  126. copy part of a worksheet into a worksheet in the same file/keepi.
  127. F9 Key for totals
  128. Auto Date with Manual Entry Protection
  129. My Excel cols have #s, not letters. How get letters?
  130. cannot sum time
  131. Function to move text >65 characters to next row in column?
  132. Maintain or Lookup Formats
  133. how do you hide SUM(number1,[number2],...
  134. CountIf with multiple conditions
  135. HYPERLINK - insert within a text sentence
  136. Re: Matching two lists
  137. Functions
  138. How to do formula If a<-.1 and .1, return em dash, otherwise do x
  139. I was asked to change excel spreadsheet to make multiple select
  140. How do I track recurring entries in Excel?
  141. count text strings in an entire workbook
  142. How can I install Excel Solver without the Office 2003 disk?
  143. Help in Excel creating Formula's
  144. will vlookup work for me?
  145. Evaluating One Column To Give A Answer To A Third
  146. Format external data
  147. Database function - convert flat table
  148. SUMIF - multiple criteria in different columns
  149. RE: Displaying all numbers as positive
  150. need to transpose 1422 values from a column to row
  151. SumIf across multiple worksheets
  152. Making cell reference absolute makes cell format text
  153. Loss of dropdown control when publishing
  154. How do I automatically copy data from one workbook to another?
  155. 12 month Rolling Total
  156. Help exiting function needed !!!
  157. Really need calculation help
  158. How do I get Analysis Tools in English
  159. Sheet Names w/ Wrap Text
  160. combining index with max - tried most posted solutions to no avail
  161. How do I update links from a file that hasn't yet been updated?
  162. print preview
  163. Combining two reports into one
  164. A button on one sheet to print other sheets
  165. Sheet Name in Cell
  166. find numbers in a list which sum a total
  167. Sum of a number's digits
  168. Analysis of data
  169. Total and summarise data
  170. Conditional Scenario of Text value
  171. How do I evaluate a row of cells for a character in each cell?
  172. How do I choose multiple items from a drop down box?
  173. Auto control number
  174. Formatting to show 0 as first number in a cell when input
  175. SUM(INDEX(MATCH) for a range returns different result than SUM!
  176. swapping column info between 2 columns
  177. counta - from 7th cell of a column to the last cell of that column
  178. how do i create a new check box in excel?
  179. how to make an function to list all the same records
  180. How do I link information from a large table into new table
  181. Multi-criteria lookup with Multiple results
  182. how do i merge data from specific cells to different workbooks?
  183. help with setting up dynamic name ranges
  184. How do i sort values like: #103 / 4 / 23, need to sort by 2nd #
  185. Formula Help
  186. Which Statistical Analysis Should Be Used
  187. Copying Excel Formulas
  188. excel formula
  189. Conditional Linking and Formatting across worksheets to form Summary Page - Only pull/link non-null fields
  190. Nested If statements
  191. SUM(IF(multible conditions))
  192. how can I add time in excel to determine how long something took?
  193. How do I keep someone from changing page breaks on a sheet that i
  194. Calculate Number of Months Weeks and Days Between Two Dates
  195. function to give the number of hours
  196. excel formulas
  197. My Excel 2000 Sheet never hides even after I save
  198. How do you add a group of cells by highlighting them?
  199. A formula/function to return a formula/function
  200. Conditional sum matching two columns and a row
  201. Change years to months in loan amortization template
  202. combination functions in one cell
  203. Simplify formula
  204. Problems with IF statement
  205. Underline with accounting format
  206. Underline with accounting format
  207. Formula Recalculation Error
  208. Vlookup - Identify Label - Excel Programming Bug
  209. using wildcards on text
  210. count on multiple conditions
  211. Replacing formulas with its value
  212. Which Function do I use?
  213. Summary counting
  214. I want to go to a specific not named cell.
  215. Array formula and multiplying conditions
  216. Single text file imported to multiple worksheets
  217. calc
  218. Weighted Average in Pivot table
  219. Conditional Formatting Malfunction?
  220. text and formula within the same cell
  221. EXCEL 2000 SINGLE COLUMN OF NUMBERS BREAK INTO MANY COLUMNS
  222. IF greater than Zero
  223. How do I calculate exact difference between two dates in y,m,d.
  224. Selective calculation
  225. How do I combine multiple worksheets into one worksheet?
  226. how I can Check the color of font in excel cell ?
  227. Select the last value from a list
  228. Paste into autofilter selection!
  229. Concatenate
  230. the difference about formula in two accounts
  231. Hiding error message
  232. How can I combine 2 columns into 1, Excel?
  233. HELP
  234. Combining two formulas using concatenate
  235. emailing workbooks
  236. In Excell ,formula
  237. Zero Value Ranked
  238. Complicated Problem
  239. look up formula not returning data
  240. copy cell from above with opposite sign
  241. Data Validation
  242. Naming a cell
  243. emailed content with InDesign or InCopy
  244. How do I center align a title at top of sheet.
  245. How can I count a record if it contains a date within a date range
  246. Day Number For 365 Day Year
  247. excel hyperlink to stock page
  248. CHANGE POSITIVES VALUES TO NEGATIVES
  249. Keeping Text format
  250. Zeros problem in LOOKUP?
  251. Recognizing Cell Formatting To Use In A Formula Or Conditional For
  252. Footer in XL
  253. Looking for Excel SS which calculates Mortgage Payment with PMI
  254. - sign help
  255. Lookup Formula?
  256. Vlookup and Values
  257. Birthday Calculations
  258. Rolling data
  259. Can Excel Adress Envelopes?
  260. OK tough one !
  261. Formula
  262. Format data in History Sheet in Excel
  263. By selecting cells adjacent to cells tally sheet
  264. adding several worksheet cells onto a main worksheet
  265. Unknown number format
  266. No change in result cell
  267. Cell shows formula eg ='Sheet21'!F3 instead of result
  268. How do I take a cell in one worksheet and add it into the formula in a different worksheet in the same workbook?
  269. Inverse Table Lookup
  270. I want to take a date 2006/02/10 & break it into separate columns
  271. In excel missing macro "excelprecedents"?
  272. Count Filtered Visible Items that Match Numeric Criteria between two ranges
  273. Feeds from one sheet to another
  274. changing cell background color
  275. Create macro to filter on multiple criteria
  276. compare two columns within a worksheet, then highlight duplicates
  277. need to merge 3 worksheets into 3 pages. how?
  278. Help w/formula to add 1 year to cell (date done) date due?
  279. RE: Sorting data into different format....
  280. Can anyone help, with a formla
  281. finding differences between 2 worksheets
  282. Can I add a percentage formula to an IF statement?
  283. Autofill Formula
  284. with weekly score sheet how do I column a weekly progressive aver.
  285. How do I write formula to conditional format using =if(and(or)
  286. Re: Calculating only non-empty cells...
  287. How do I create chart that show percentages for 1 and 0's?
  288. allow users to edit ranges
  289. TimeValue formula
  290. I want Excel to randomly select a name from a list
  291. how to randomly select a name in a list and then the select the ne
  292. multiple conditions
  293. "MAXIF" Equivalent function in Excel
  294. "MAXIF" Equivalent function in Excel
  295. how do i change a case to proper text in excel 2003
  296. how do i change a case to proper text in excel 2003
  297. External Data Functionality
  298. External Data Functionality
  299. Entering Formulas
  300. Entering Formulas
  301. Entering formulas
  302. Entering formulas
  303. multiplication
  304. multiplication
  305. Run time error
  306. Run time error
  307. How do you attach tabs to make one page or several pages?
  308. How do you attach tabs to make one page or several pages?
  309. adding cells
  310. adding cells
  311. How do I conditional format by referencing failure/success?
  312. How do I conditional format by referencing failure/success?
  313. Compare Two columns
  314. Compare Two columns
  315. sorting protected sheets
  316. sorting protected sheets
  317. Duplicate entries
  318. Duplicate entries
  319. Fiscal quarters for two years...
  320. Fiscal quarters for two years...
  321. function to change cell position and allows dragging
  322. function to change cell position and allows dragging
  323. Result = to 0 says false
  324. Result = to 0 says false
  325. cut and paste macro
  326. cut and paste macro
  327. Using COUNTIF on multiple fields
  328. Using COUNTIF on multiple fields
  329. How do i add a column of values based on another column in excel
  330. How do i add a column of values based on another column in excel
  331. COUNTIF by days of week
  332. COUNTIF by days of week
  333. How do I sort data?
  334. How do I sort data?
  335. Excel formula
  336. Excel formula
  337. How do I copy and paste a worksheet and maintain all formatting?
  338. How do I copy and paste a worksheet and maintain all formatting?
  339. formulas
  340. formulas
  341. Macro within a function?
  342. Macro within a function?
  343. No "Sheet" tab exists on Page Layout. Need to print gridlines.???
  344. No "Sheet" tab exists on Page Layout. Need to print gridlines.???
  345. HOW CAN I SERIALIZE SHEETS IN EXCEL
  346. HOW CAN I SERIALIZE SHEETS IN EXCEL
  347. Looking for a way to summarize data?
  348. Looking for a way to summarize data?
  349. Virus error opening all files
  350. Virus error opening all files
  351. Lookup and Replace
  352. Lookup and Replace
  353. Worksheet Link
  354. Worksheet Link
  355. LOOKUP or VLOOKUP
  356. LOOKUP or VLOOKUP
  357. MATCH?
  358. MATCH?
  359. Referencing a specific number to more general values in a table.
  360. Referencing a specific number to more general values in a table.
  361. Working night and day..... Timesheet
  362. Working night and day..... Timesheet
  363. is it possible to make certain cells required based on criteria
  364. is it possible to make certain cells required based on criteria
  365. code help please
  366. code help please
  367. Resort Column from one with blanks
  368. Resort Column from one with blanks
  369. how do I edit an embedded spreadsheet?
  370. how do I edit an embedded spreadsheet?
  371. Sumif referring to range names formulas not updating
  372. date/time calculation needed
  373. date/time calculation needed
  374. Sumif referring to range names formulas not updating
  375. Offset Question
  376. Offset Question
  377. Conditional formula
  378. Conditional formula
  379. Calculating values from multiplesheets with multiple criteria
  380. Calculating values from multiplesheets with multiple criteria
  381. How do I calculate exact difference between two dates in y,m,d.
  382. How do I calculate exact difference between two dates in y,m,d.
  383. conditional formatting
  384. conditional formatting
  385. Naming Sheets using a range in another worksheet
  386. Naming Sheets using a range in another worksheet
  387. formula that writes to a *different* cell?
  388. formula that writes to a *different* cell?
  389. Soccer betting excel
  390. Soccer betting excel
  391. Soccer betting excel
  392. Soccer betting excel
  393. Non updatable Unique Random Number
  394. Non updatable Unique Random Number
  395. Database Analysis Question
  396. Database Analysis Question
  397. Charity Auction Worksheet. - Copy a row of data - THANKS
  398. Charity Auction Worksheet. - Copy a row of data - THANKS
  399. Create user-defined function using Querytables
  400. how do I get excel to use tab to move in a sheet
  401. how do I get excel to use tab to move in a sheet
  402. COUNTIF for numbers of dates in column which are 30 days older than today
  403. COUNTIF for numbers of dates in column which are 30 days older than today
  404. Loan Compound Interest Function
  405. Loan Compound Interest Function
  406. Help with Duplicates
  407. Help with Duplicates
  408. Sharing Info between two workbooks?
  409. Sharing Info between two workbooks?
  410. Highlighting and tracking changes
  411. Highlighting and tracking changes
  412. Excel adds significant digits, resulting in errors in calculations
  413. Excel adds significant digits, resulting in errors in calculations
  414. Automatically fill info from another spreadsheet?
  415. Automatically fill info from another spreadsheet?
  416. DES Encryption functionality
  417. DES Encryption functionality
  418. Formula Error
  419. Formula Error
  420. delete a # from the value axis on a column chart?
  421. delete a # from the value axis on a column chart?
  422. adding numbers that contain ranges
  423. adding numbers that contain ranges
  424. Link from Excel cell to page in PDF
  425. Link from Excel cell to page in PDF
  426. Macro / Bob Phillips if you are out there
  427. Macro / Bob Phillips if you are out there
  428. Workbook Refreshes For Multiple Users
  429. Workbook Refreshes For Multiple Users
  430. use formatting from source cell in CONCATENATE function
  431. use formatting from source cell in CONCATENATE function
  432. Dealing with Text in a Function cell
  433. Dealing with Text in a Function cell
  434. use formatting from source cell in CONCATENATE function
  435. use formatting from source cell in CONCATENATE function
  436. Excel 2003 SP2
  437. Excel 2003 SP2
  438. SUMPRODUCT returning incorrect result
  439. SUMPRODUCT returning incorrect result
  440. Excel worksheet formatting
  441. Excel worksheet formatting
  442. Cell Calculation
  443. Cell Calculation
  444. Intelligent VLOOKUP
  445. Intelligent VLOOKUP
  446. highlight the word when excel finds text you are searching for
  447. highlight the word when excel finds text you are searching for
  448. User Form: Consecutive numbering
  449. User Form: Consecutive numbering
  450. NETWORKDAYS not working
  451. NETWORKDAYS not working
  452. RE: Text formatting
  453. RE: Text formatting
  454. criteria function using max
  455. criteria function using max
  456. Re: Can autofilter sum and average columns of numbers? Thank you
  457. Time conversions
  458. Time conversions
  459. Combining rows of like data?
  460. Combining rows of like data?
  461. Can autofilter sum and average columns of numbers? Thank you
  462. Can autofilter sum and average columns of numbers? Thank you
  463. Incorporate Laurent Longre's morefunc with Excel xcell05.free.fr/
  464. Incorporate Laurent Longre's morefunc with Excel xcell05.free.fr/
  465. multiple criteria formula
  466. multiple criteria formula
  467. How can I add functions in excel templates (XLT)
  468. How can I add functions in excel templates (XLT)
  469. If statement based on currency format
  470. If statement based on currency format
  471. How do I remove a blank separator from a number (like 2 006)
  472. How do I remove a blank separator from a number (like 2 006)
  473. How can I hyperlink from an excel cell to a page in a pdf document
  474. How can I hyperlink from an excel cell to a page in a pdf document
  475. How do I insert alternating blank rows in a list of data?
  476. Function to calculate based on a portions of a number
  477. Function to calculate based on a portions of a number
  478. Tricky Formula
  479. Tricky Formula
  480. Help with sorting
  481. Help with sorting
  482. IF Function (..........
  483. IF Function (..........
  484. How do I use 3 separate column qualifiers to sum? IF statements?
  485. How do I use 3 separate column qualifiers to sum? IF statements?
  486. how do I get rid of blue asterick in create list?
  487. how do I get rid of blue asterick in create list?
  488. Color Code Date Rows
  489. Color Code Date Rows
  490. wildcard characters, can they be used in tables to be searched?
  491. wildcard characters, can they be used in tables to be searched?
  492. Transfering a formula from one worksheet to another
  493. Transfering a formula from one worksheet to another
  494. Count consecutive absences with a limit
  495. Count consecutive absences with a limit
  496. Split non delimited data into multiple cells
  497. Split non delimited data into multiple cells
  498. How do you subtract time as in a timecard to calculate hours work
  499. How do you subtract time as in a timecard to calculate hours work
  500. add cells in several worksheets
  501. add cells in several worksheets
  502. How do I create a macro to add zeros in front of a value?
  503. How do I create a macro to add zeros in front of a value?
  504. select detail in column B if column A = date
  505. select detail in column B if column A = date
  506. Moving an Excel pivot table to access
  507. Moving an Excel pivot table to access
  508. Lookup on two criteria
  509. Lookup on two criteria
  510. how do i profile a survey?
  511. how do i profile a survey?
  512. Picture Disappear in MS Excel
  513. Picture Disappear in MS Excel
  514. formula {=TABLE(G13;)}
  515. formula {=TABLE(G13;)}
  516. How to convert Arabic number to english text (63 to SIXTY THREE)
  517. How to convert Arabic number to english text (63 to SIXTY THREE)
  518. Selecting the correct number from a range of cells
  519. Selecting the correct number from a range of cells
  520. Conditional Formatting
  521. Conditional Formatting
  522. Find and Return Numeric Label based on (Numeric Value) Criterion
  523. Find and Return Numeric Label based on (Numeric Value) Criterion
  524. cut and paste pictures in excel 2003
  525. cut and paste pictures in excel 2003
  526. Find contents of the last cell in a row
  527. Find contents of the last cell in a row
  528. Avoiding Recalculation for a function in automatic mode
  529. Avoiding Recalculation for a function in automatic mode
  530. Isolating mailadresses
  531. Isolating mailadresses
  532. how do i translate a full powerpoint presentation in one go?
  533. how do i translate a full powerpoint presentation in one go?
  534. goal seek minimize function
  535. goal seek minimize function
  536. Data validation
  537. Data validation
  538. Sum in Autofilter
  539. Sum in Autofilter
  540. Protecting Individual Sheet Visibility Using a Password
  541. indirect formula help
  542. indirect formula help
  543. Pivot table grouping
  544. Pivot table grouping
  545. what is a coupon rate and ytm of a bond?
  546. Excel: have add'l rows entered in sheet 1 always show up in sheet
  547. Excel: have add'l rows entered in sheet 1 always show up in sheet
  548. Date Wont Change in Excel??!
  549. Date Wont Change in Excel??!
  550. IF or Lookup
  551. IF or Lookup
  552. looking for assorted statistical excel templets
  553. looking for assorted statistical excel templets
  554. trying to add up disparate transaction data
  555. trying to add up disparate transaction data
  556. Annual percentage return on investment.
  557. Annual percentage return on investment.
  558. Projected annual percentage return on investment question.
  559. Projected annual percentage return on investment question.
  560. Data from two sheets make up real time list in the new sheet??
  561. Data from two sheets make up real time list in the new sheet??
  562. Adding rows?
  563. Adding rows?
  564. Convert 2 digit month to 4 digit years and months
  565. Convert 2 digit month to 4 digit years and months
  566. special formatting?
  567. special formatting?
  568. Match duplicate data in 2 columns
  569. Match duplicate data in 2 columns
  570. FIND PERCENTAGE AMOUNT FOR 5 DEPT. FROM ONE WHOLE AMT XCL
  571. FIND PERCENTAGE AMOUNT FOR 5 DEPT. FROM ONE WHOLE AMT XCL
  572. Find and Count Frequency of Numeric Value in Non-Contiguous Rows
  573. Find and Count Frequency of Numeric Value in Non-Contiguous Rows
  574. Caluclation of depreciation
  575. Caluclation of depreciation
  576. If statement
  577. If statement
  578. Cells are selected but aren't displayed as selected
  579. Cells are selected but aren't displayed as selected
  580. can a1 reference style and r1c1 style be used in same formula?
  581. can a1 reference style and r1c1 style be used in same formula?
  582. I need a formula to do some calculations with time.
  583. I need a formula to do some calculations with time.
  584. make a spreadsheet with diagnal column headings
  585. Help with Excel
  586. Help with Excel
  587. Make a cell show the name of the sheet tab
  588. Make a cell show the name of the sheet tab
  589. Progressive numbering of Excel worksheets
  590. Progressive numbering of Excel worksheets
  591. Creating summary table from detail table
  592. Creating summary table from detail table
  593. display the cell value in the next 33rd cell
  594. display the cell value in the next 33rd cell
  595. Not listing more than a range of rows
  596. Not listing more than a range of rows
  597. Need dynamic name range in Excel for Outlook interface
  598. Need dynamic name range in Excel for Outlook interface
  599. Inserting columns & rows in worksheets
  600. Inserting columns & rows in worksheets
  601. Formula
  602. Formula
  603. TimeSheet! Working PM to AM
  604. TimeSheet! Working PM to AM
  605. Microsoft EXCEL 2000 Formula
  606. Microsoft EXCEL 2000 Formula
  607. How can I get Excel to print dashes right across a cell
  608. How can I get Excel to print dashes right across a cell
  609. one cell does not reflect a sum
  610. one cell does not reflect a sum
  611. Counting Rows - Fill ???
  612. Counting Rows - Fill ???
  613. If then else....
  614. Macro Modification - Bob Philips Are You Out There ?
  615. Shading alternate "groups" of rows?
  616. Sum Function Problem!!
  617. Sorting UK Postcodes
  618. Pull cell format across sheets as part of the fomula? Is it poss?
  619. merging sheets
  620. Record changing cell data into a column or range
  621. Spillting a cel
  622. Superb new financial services. Track and Manage ALL of your wealth
  623. Sumproduct values from two ranges
  624. increment operator?
  625. Amount to text
  626. Adding a % value to a column of numbers
  627. Nested ifs within a row
  628. If statements
  629. Calcualtion of renewal
  630. Calcualtion of renewal
  631. Calcualtion of renewal
  632. Data Validation Lists
  633. Return position for each matching value in entire workbook?
  634. Information changes daily
  635. Drop and drag is copying values instead of formulas
  636. How do I count something in one column = to info in another
  637. Subtotal by Account (cash, liability, revenue, expense) in Excel?
  638. Permutation combinations and multiplying them
  639. Field List in Pivot Table Not updating
  640. truncate numbers from millions to thousands
  641. Editing scenarios
  642. Bold
  643. Saving a worksheet to csv with different separator
  644. Re: Formula and or data entry into cell?
  645. Q. How can I change this date
  646. Data from two sheets make up a list in a third sheet (real time)
  647. headers
  648. VLOOKUP RETURN BLANK
  649. how do i copy various sheets date to one sheet in the same excel .
  650. I cannot get hyperlinks set up in Excel 2003 to work in Excel 98
  651. Count Only Empty Cells AFTER Cells with Data
  652. Active range/selection?
  653. Excel Worksheets
  654. IF statement formula
  655. importing SDF
  656. Keeping the format of a date
  657. Not a lottery success with Excel
  658. Selective linking items between two worksheets
  659. Pivot Table Filter
  660. highlight formulas
  661. Attachment files
  662. formula-add 2 numbers of cell a1 and a2 of sheet1 ans-b9in sheet2
  663. Function Arguments
  664. i need the sheetname in my cells
  665. Pull in a colum of financial data based on the month
  666. Nested array functions?
  667. how to set auto protect workbook on exit?
  668. add color or picture to a cell using a formula
  669. Searching for text & counting how many times it appears
  670. VLOOKUP - return 0 instead of "#N/A"
  671. Relinking Pivot Tables to Main Table
  672. linking points
  673. Pivot table with added columns for evaluating results
  674. Hiding a ComboBox with a Checkbox
  675. how do I calculate probability of winning a raffle
  676. What does the "--" do in an Excel formula
  677. How I know if a file is using a custom addin
  678. Excel Web Page
  679. Dynamic multiple-condition array function with more than one name
  680. VLOOKUP - unable to highlight cell range
  681. Calc. Avg. Instead of SUMPRODUCT
  682. Advanced filter formula for "contains="Sept"
  683. Cannot format cells
  684. RE: Average
  685. Re: Average
  686. Possbile for non-contiguous vlookup?
  687. What formula is used to replace blanks in spreadsheet with zeros?
  688. protect worksheets in workbook
  689. My addin in other computers
  690. sum a countif
  691. Can i pull text with a Getpivottable formula?
  692. HLookUp combined with a VLoopkUp...
  693. Formatting for Indian Rupees
  694. Macro help
  695. Search and lookup
  696. nested if statements
  697. Countif from an offset column
  698. Range of a merged cell
  699. Setting up a worksheet for LOG LOG analysis
  700. Countif using criteria in multiple columns
  701. Function question
  702. This is DRIVING ME INSANE!
  703. Time Calculation
  704. Formatting for and adding thousandths of a second
  705. Getting Sums of Values
  706. Three questions on hyperlinking and conditional formatting
  707. I have tried & can't get rid of the decimal point in an Excel
  708. aging of invoices
  709. Analyze Survey Questions
  710. SUMPRODUCT
  711. Creating and editing scenarios
  712. Fill down formulas in cells to the LEFT of external data range?
  713. Two Formulas for One Cell Using IF
  714. How to Delete Rows in Excel In a Do Loop
  715. USING DATA VALIDATION ACROSS SPREADSHEETS
  716. Formula for calculating a running balance up to a maximum limit
  717. Ignoring error values in a formula
  718. How can I add numbers such as 1.5R + 2.5R?
  719. change Excel column headings from numbers to alpha characters
  720. how do i assign a value to a cell containing text
  721. How to get a formula result in a "whatif" situation
  722. Repeating a sort
  723. Borders
  724. Creating Id
  725. Serial Numbers converted to text string
  726. what is the formula to convert 5513 seconds into minutes 00:00:00
  727. Replacement of Testdirector( Test Managment Tool -Mercury Interact
  728. Displaying the date a file was modified in a cell
  729. Truncate within a cell
  730. How do I formate cells in excell to show inputed date as 09/13/
  731. check for repetition of cell contents
  732. how do i enable multiple entries in the same cell under a label?
  733. array product formulas
  734. enter a value, excel pulls information and places in new spreadshe
  735. Formula request
  736. How do I copy a formula from one work sheet to another?
  737. I can not find the list command from the data dropdown menu?
  738. Information from one column then filtered(?) from another
  739. How do I prevent rows from duplicating when sending a worksheet?
  740. Formula help
  741. VLookUp or HLookUp Plus Index - Match, I think???
  742. cell fill color not showing
  743. Looking for a formula to calculate date intervals
  744. counting records
  745. I want user form to display when opening a work book
  746. remove figures from a cell without removing the formulas
  747. Chart
  748. Updating Linked Excel Document
  749. how can you insert a picture in a protected excel file
  750. Can I nest Max in HLOOKUP?