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. spinner format control has no control tab
  2. Using #s in column as column #s
  3. Do formulas in a table translate when sorted?
  4. dollar amount versus Time
  5. Autocomplete from a list on the worksheet
  6. Formula Help
  7. Print Filter??
  8. custimise the "IF" formula function
  9. Re: How do I do this complicated macro???
  10. IF/then statement help.....
  11. Name Findout From a interval range
  12. combo box from data validation with source list in separate sheet
  13. Other Sum Question
  14. Please help!
  15. SUMIF or IF Function?
  16. Ratios expressed in excel? i.e. 3:7
  17. split text in one cell into multiple cells without breaking the wo
  18. How do I compare,differentiate few columns data?
  19. Looping between sheets picking up values on the way
  20. How do I prevent Crtl+End moving to a cleared cell?
  21. Formula Help Price Code
  22. WORKING OUT PERCENTAGES
  23. returning header row as a result...
  24. http://hustle.servehttp.com/
  25. ANOVAs Excel 2000
  26. Calculation with dates
  27. 2 Q's. How to add X months to a date &
  28. Rookie at linking - need a tudor!!!
  29. need help w/sequential invoice number on excel worksheet
  30. First and Last Day of the Quarter
  31. counting
  32. Pivot Table question
  33. Please help - Permutations of words
  34. Capitalizing first word only...
  35. NPV - 4 values over 60yrs
  36. Howeractivate Excel after a macro failure
  37. Count # of "alt+0242" in cell
  38. Entire contents of cell not showing
  39. How recognize sheet protected?
  40. IsNumber & Mid function
  41. How do I rerank fields in table
  42. Need formula that Counts items matching criteria using two columns
  43. formula help
  44. Keep formual intact after deleting a line
  45. excel 2003 help comparing prices for lowest
  46. How do I seperate data in one column into multi columns
  47. Multiple Range Formula
  48. Create list of text matching criteria
  49. Conditional Formatting problem
  50. Time Calculation For A Timesheet To Include Lunch
  51. Query to MSN Stock Scouter
  52. Fill down produces correct formula but wrong answer
  53. If-VLookup
  54. How can I average data from a repeating list into a unique list?
  55. How to count unique values?
  56. Protect Formula's but still be able to "Insert Copied Cells"?
  57. " invalid cell references.
  58. cannot shift objects off sheets
  59. summing multiple worksheets
  60. How do I use the criteria "is not blank" in a SUMIF formula?
  61. Return an empty or blank cell value?
  62. How do I add leading spaces to a value?
  63. Sumif function, nonadjacent cells
  64. How do I omit hidden data from autosum calculations?
  65. How do I do the inverse of tan in Excel?
  66. Re: closing & saving
  67. Link worksheet totals to a summary worksheet in the same workbook
  68. Drop Down list formatting
  69. Using data, subtotal
  70. Using Conditional Formating /
  71. sorting range changes sum??? (excel)
  72. AND NOT AND OR
  73. Lookup and Sum
  74. Text Lower Case Letter
  75. Suggestions on formula to track powerball numbers?
  76. Formula Help
  77. extract date from string
  78. Strange (?) Evaluate Method Behavior
  79. Master Worksheet populated by other Worksheets?
  80. Problems with SUMIF()
  81. Adding two columns with vlookup
  82. formula help
  83. Need Formula
  84. April 2006 - Excel User Conference
  85. Is there an Excel formula to sum color filled cells?
  86. Random numbers to make a known amount
  87. timed macro
  88. Vlookup when more than one possiblity
  89. How to cycle through each of property and its value of Class?
  90. Use of IF
  91. Locking Cells
  92. Probability function
  93. can i get the "message pane" underneath the "threads pane" instea
  94. Form & Data Sheet???????
  95. Show the defined name of cells, help with modification of this UDF
  96. Worksheet consolidation help
  97. Problem with Sumif formula
  98. Displaying the Date#2
  99. Complex Problem
  100. I have clairified some info., maybe, I can be helped now .........
  101. Any way for 2 column vlookups. i.e match last name then match firs
  102. Re: Function that determines whether a number is between two numbers
  103. Function that determines whether a number is between two numbers
  104. Converting time period in hours
  105. Displaying the date
  106. Multiple search criteria to return one response
  107. HELP - I NEED A PLAN
  108. If cell value equals zero
  109. conditional formatting
  110. Re: Trying to connect with Dave Braden
  111. how can i use excel as a vehicle dispatch program
  112. Workbook contains links to other data sources??
  113. Excel 2000 Text
  114. Excel
  115. Adding new data to existing data
  116. Add-in Macros
  117. Help please - Index and Match "like" values
  118. How do I stack worksheet tabs on an excel spreadsheet?
  119. How do I set up a clumn of days, skipping weekends?
  120. average on column if two others have given values
  121. Need a Count Formula
  122. Color filled in auto but from where
  123. Sensitivity analysis
  124. Sensitivity analysis
  125. Sensitivity analysis
  126. Disable printing a spreadsheet until assinged cells have data
  127. Required selection
  128. Date minus date=No. of days?
  129. Bug with Text function?
  130. I cannot add fill colour to any cell, or use coloured text
  131. Copy and paste between windows in excel 2003 will not work
  132. How to add the same cell on multiple spreadsheet?
  133. More then 7 IF functions?
  134. How do i get time in excel to calculate time between 20:00-03:45
  135. Conditional Sorting
  136. CountIf on Date field
  137. Locking formulas without password protecting worksheet
  138. how to display the column or cell the MIN() result came from?
  139. OR EXACT Formula Appears to not accept Arrays
  140. convert "yes" and "no" to "1" and "0", respectively
  141. Force function to show positive or negative number?
  142. How to Change List Based on Value Chosen in Another List
  143. GO TO LAST SHEET
  144. Random Name Generator
  145. How can I change column numbers back to column letters?
  146. filtering unique in multiple columns
  147. Timesheet Help. Rounding to the nearest 1/4
  148. Counting occurrences in one column based on an occurrence in anoth
  149. MegaFormula curiosity
  150. Indirect?
  151. Creating a Rankings Table
  152. match multiple criteria and highlight corresponding row in Excel
  153. Rounding
  154. Printing formulas on a worksheet
  155. formula converting number to column letter >26
  156. HOW DO I CALCULATE SEPARATE WORKBOOKS INTO ONE?
  157. how do i get a drop down pick list in a cell
  158. Name Lookup
  159. Choose function gives different results from different cells?????
  160. RE: HOW DO I CALCULATE SEPARATE WORKBOOKS INTO ONE?
  161. make macros usable! make instructions in plain english !!!!
  162. Formula Help
  163. Autosum refreshing
  164. RE: how do i get a drop down pick list in a cell
  165. import .wmf->excel 03?
  166. How do I set up Reminders in an excel spreadsheet?
  167. Dynamic Labels
  168. Position in a string
  169. Comparing 2 pivot tables data using VBA
  170. how do i print filtered rows in Excel?
  171. Newby help
  172. Export XML
  173. "DAYS 360" and the date Feb 28th as start and end
  174. Re: Variable equations help please
  175. Need help on formula
  176. data val
  177. list unique values in a column
  178. End of a Worksheet
  179. How do I count data with criteria from two separate columns in exc
  180. Need help with "if" function in Excel
  181. Need help with "if" function in Excel
  182. How to average one constant # to variable #s? A1:A2 A1:A3 A1:A4
  183. How do you add multiple spreadsheets in to one spread sheet
  184. Lookup Tables and Formulas
  185. pie symbol for math
  186. monthly growth rate
  187. how to get values from different sheet when info. matches?
  188. Possible to change the program Excel uses to open a hyperlinked file?
  189. dsum returns 0 if criteria range too large
  190. how do you set up an if, then formula in excel??
  191. Trying to forecast the future
  192. I can see a worksheet, but I can't type in it or use the tool bar
  193. Sort Groups of Cells
  194. Help with a formula - probably an "IF"
  195. gridline the next page automatically in excel 2003
  196. can you link data from word to excel
  197. Text & Date in the same Cell???
  198. Web Query With Multiple Stock Symbols & Stock Scouter
  199. auto gridline restore after a cut and paste in excell 2003?
  200. Prevent Users from Selecting Cells
  201. Question : Workbooks or Worksheets?
  202. how do I add blank pages to
  203. formula help
  204. convert string to date
  205. index match function help me
  206. Sum Formula that excludes other sum formula in range
  207. $ vs time formula
  208. Pay per hour?
  209. Referencing subtotal numbers
  210. sort in excel that sorts digikey
  211. Is there a maximum number of constraints...
  212. Worksheet Formatting
  213. Returning a blank field
  214. Formula to figure ad schedules
  215. need formula if x<a3<y, value, else
  216. How do I enter like a Word document in an Excel worksheet
  217. Link Worksheets to a Master Sheet
  218. Sum on rows column wise - Strange error
  219. Counting Frequency of Filtered Data
  220. insert rows
  221. Conditional Formatting (IF function)
  222. How do I make it add a column based on 2 different criteria?
  223. Copying information into another workbook
  224. Conditional formatting, simple question...
  225. conditional formatting
  226. Can't get Excel 2003 to open a .wav via hyperlink
  227. Sum help this is puzzling???????????
  228. Conditional formatting
  229. sum with three criteria
  230. MATCH UP DATA IN COLUMNS
  231. Round up to nearest 10
  232. change loan periods in an amortization schedule
  233. Select sheet tabs in workbook & save to separate workbook files
  234. How do I correct error using the =IF(AND(formula in excel?
  235. how do i Count with in the cell range value is >5 and <=15
  236. VLookup Question?
  237. calculation for bank interest chargeable
  238. Default a specific worksheet to be in forefront when open excel?
  239. fancy lookup
  240. VLOOKUP Limitation and Solution?
  241. autocomplete after 4000 entries
  242. Why do gridlines disappear from view when highlighted
  243. Calculate
  244. how do u set up multiple choice answer buttons/dots?
  245. Problem with crystalReportViewer
  246. showing and copying a formula in a cell
  247. Forecasting = loan planning or depreciation??
  248. Countif unique
  249. Microsoft request for slow-calculating workbooks
  250. selecting a worksheet
  251. Work Schedule
  252. incrementing mm/yy based on value in other cell
  253. Find a value in the table cell
  254. ROUND or "Precision as displayed"?
  255. Error message "formula is too long"
  256. locked out of my sheet for read only
  257. VLookup Help???
  258. how to bring an image onto a sheet
  259. Date Sorting
  260. appending and IF statement to an existing IF statement
  261. Hide Rows - copy and paste only rows that show
  262. Determine which column to use by date
  263. Countif Q
  264. Two column value match table look up
  265. Formula to Check Values between to variables
  266. Office 2003 vs. Office 97
  267. not copying correct value
  268. Re: V Look Up Function Problems
  269. Stratify Data In a Range
  270. Re: V Look Up Function Problems
  271. Help with Match Function
  272. how to convert csv format to separet columns in excel
  273. select rows
  274. Scoring/Ranking 2 Columns of Stock Symbols
  275. Extract last name and insert into a different field.
  276. How to display seconds on time stamp?
  277. Miscellaneous
  278. conditional formatting - Highest
  279. Sharing worksheet with a customer toolbar
  280. Why do some Excel cells refer to e-mail?
  281. Linking Worksheets
  282. Can't move between worksheets
  283. Lookup Problem
  284. Sumproduct
  285. forwarding cell data
  286. Countif????
  287. problem using Range Names in VLOOKUP
  288. I'm looking for an advertising layouts for a weight loss programs
  289. Sharing Violation error
  290. Why doesn't the DDB function work all the time?
  291. excel does not open up any workbook
  292. can you assign random numbers to many different lines of row?
  293. how to use cell contents as references in a formula
  294. Copy-Paste sheets - error in the dates
  295. Help With A Macro
  296. Creating a formula by using data in another file
  297. Create Lookup Table
  298. Excel 2002 formula displayed not value formula option not checked
  299. how can i multiply two columns
  300. consolidation of tables in excel with text and figures
  301. Save copy of folder with linked files
  302. VLOOKUP to return first hit
  303. Remove all formatting
  304. excel ?
  305. Formula for Excel
  306. Vlookup show #N/A
  307. Copt data with specific criteria
  308. Calculated Field/Item in a Pivot
  309. Calculated Field in A Pivot
  310. Cannot hide columns in Excel
  311. How to use if statement
  312. Close Dos from Vba?
  313. Rounding Error when adding or subtracting two cells
  314. AVERAGE DAYS OPEN IF BETWEEN DATES
  315. transferring data between 2 worksheets in same workbook
  316. Incrementing numbers
  317. Linking formulas in new sheets based on a template?
  318. pls help again!
  319. common entry reporting
  320. I have more than 6 conditions when using conditional formatting?
  321. Right click help please !
  322. How do I run Excel 95 macros in Excel 2003
  323. Drop-Down List
  324. dates into ages
  325. Complex function....not sure how if the result I want is possible
  326. Reference cell location
  327. Lookup Assistance
  328. Amending an existing function
  329. Is there a formula tutorial online ...............................
  330. How do I sum a range of data (column) that has #num! in some cells
  331. Goal Seel To get Average!?
  332. Using a Text Cell to Reference a Worksheet Name
  333. in excel worksheet, add numbers in column k2&k3
  334. format a drop-down box from a range of cell from another work...
  335. I have lost the in cell drop down in validation
  336. Can this be done with Domain Functions?
  337. Function giving a result for number within a range
  338. only printing certain rows
  339. converting julian day and year to a date?
  340. List info if criteria is met?
  341. range_lookup in lookup functions
  342. Hide previously used items from multiple drop lists
  343. How can I use numbers to define range for Max() ?
  344. Problems with formulas and sorting
  345. how can i view the range of 75% of a column
  346. Subtototal display is in different order than 2002, why?
  347. How can I make the rows go into a random order?
  348. look up functions
  349. Employees
  350. How do I correct error using the =IF(AND(formula in excel?
  351. creating macro working across multiple sheets
  352. hours and minutes multiplied by wage
  353. hours, minutes multiplied by wage
  354. How do I show True as a value in Excel B2 if Cell B1 is bold?
  355. hours multiplied by money
  356. information function - does cell contain reference
  357. Repeat Rows
  358. Dynamic Lists
  359. If Formulas
  360. Searching for mulitple strings and assigning identifying number
  361. IF function, i think??? please help.
  362. Sumproduct with 2 criteria
  363. How can i see on excel feet and inches from decimal system?
  364. Find Formula Problem
  365. sumproduct looking at multiple sheets
  366. How do I do a Reverse Find/Search in Excel?
  367. calculate number of days btw dates
  368. Extract the hour from a cell showing the date and time
  369. How do I protect multiple sheets at one time?
  370. List Box with macro
  371. How do I lock selected cells, so only I can change them?
  372. How do I get multiple matches when using the Vlookup function?
  373. copy sheet with updated dates
  374. assign macro
  375. sumproduct help
  376. how to use spellnumber formula
  377. Count Multiple Criteria
  378. Data validation
  379. Calculation on lookup
  380. counting if two columns contain the same numbers
  381. Forward looking forecast/cover help required
  382. ask 2 function
  383. Get data
  384. MACRO QUESTION
  385. How do I restore column & row cell references
  386. Labels
  387. has anybody come across this before?
  388. Checking Blank Cells
  389. Can function in one cell change value or function in another cell?
  390. Lookup Formula Help - PLEASE!
  391. Formula Help!!!
  392. Returning the last modified date to a cell in excel 2003
  393. Formatting of cells
  394. Is anyone on here with DVS Reporter???
  395. Page Break Problem
  396. pls help
  397. importing on protected sheet?
  398. Help with this formula please!
  399. Accessing the sheetname in a cell
  400. Calculating age.
  401. Looking up a value based on date and time, what's wrong?
  402. Formula to subtract a date from current date
  403. Variable criteria formula
  404. How to prevent copied data from appearing until triggered by anoth
  405. sorting with RANK/VLOOKUP (problem with equal ranks)
  406. Offset Function Trouble, Please Help
  407. Function similar to SHIFT+CTRL+DOWN KEY
  408. Excel references to other sheets
  409. Would like one cell to both count and multiply a range of cells
  410. Is there a better way of doing this?
  411. Lining Tables
  412. find a text - help
  413. Macro Question
  414. getpivotdata
  415. Counting blank cells until value is reached
  416. Date Range for my time sheet
  417. Formula question
  418. Help again please
  419. AVERAGE of the previous meaningful cells
  420. Display 10 records from same workbook but from different sheet
  421. How can I change the color of an "IF" function answer?
  422. Database
  423. Using VLOOKUP with abitlity to choose from multiple defined names.
  424. Can anyone calculate age next birthday from date field?
  425. Nested If statement revisited
  426. Information retrieval functions
  427. How to speed up Autofiltering?
  428. How can I make an excel cell equal to the value of a frame object text box
  429. Nest IF statement workaround
  430. how towrite inside margin
  431. Opening workbooks with names taken from another workbook
  432. cell protection based on a formula
  433. SUMIF
  434. Payroll equation for SS taxes
  435. Excel should automaticaly update a feild when printing ex:Version
  436. Need Help With Formula/Function
  437. How do I identify cells with matching numbers within a column.
  438. Macro - Return to starting cell
  439. Excel Euler function
  440. Find Matching Text In Col A move to Col B
  441. Htperlink in an unlocked cell but protected worksheet
  442. ACCTINTM problems after upgrading to Excel 2003
  443. How can I make an excel cell equal to the value of a text box
  444. Saved spreadsheet - now can't work on it - choices all greyed out
  445. put data from cells into other cells
  446. Counting Data
  447. Transforming Multiple Rows into 2 columns
  448. display a range of data when triggered by a specific condition
  449. I am use (=IF(A2=1,"90") in a few cell i need to then add them up
  450. LOOKUP FUNCTION
  451. Negative Percentage?
  452. auto copy only selected cells
  453. user form question: text box to display result
  454. VLOOKUP False Problem
  455. Multiple accessing of an excel file
  456. insert columns macro is putting 2 columns instead of 1
  457. Re: Run a macro automatically on workbook open
  458. Re: Run a macro automatically on workbook open
  459. pls help me
  460. How to convert VLOOPUP error value #NA to 0?
  461. Need macro to delete all text cells in an Excel range
  462. how do i use a formula count of figures between to conditions
  463. Re: Help with a read only frustration.
  464. Data validation two criteria
  465. Inserting Worksheets
  466. lookup a value and return cells
  467. Calculating sales commision HELP!!!!!!!
  468. Pivot Tables
  469. vlookup with two criteria
  470. What formula would I use?
  471. vlookup with two criteria
  472. Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet
  473. Nesting the SUBSTITUTE formula
  474. return multiple rows of data based on criteria
  475. Command Button protection problems????
  476. Number combinations
  477. Conditional formatting
  478. Can I automaticly figure "cost" and sale price in Excel?
  479. Returning Macro to Starting Cell
  480. Vlookup...
  481. Formula
  482. How can I label a worksheet based on a cell in Excel?
  483. Calculating monthly totals
  484. HELP! Making A Form
  485. how to combine text into a cell???
  486. formatting multiple worksheets
  487. Creating a master worksheet
  488. SumProduct w/WildCard
  489. Saving username into a cell
  490. linkig multiple cells in a pricesheet
  491. SumProduct With Multiple criteria
  492. Creating Array from Pivot Table
  493. sorting data by time and day of week
  494. Sorting with Multiple Rows per Entry
  495. Excel Checkbox can be regconized in a formula and be executed
  496. Formula for counting multiple variables in a spreadsheet
  497. sumif/if with conditions "HELP"
  498. links
  499. How do I change the default shape for comments in Excel?
  500. Returning Macro to Starting Cell
  501. how do i calculate over time per day
  502. Sorting List to a new sheet
  503. calculating the future value of an investment in excel
  504. autocorrect features
  505. Setting up a Macro
  506. How can I use "VLOOKUP" with cells containing both Text & Numbers?
  507. Added up # of cells containing a specified word
  508. Calculating Percentage Rent
  509. how do I format the sheet so that I may click on 1 cell at a time
  510. A function that looks for a value on a sheet on unknown column or row
  511. Why sometimes excel returns error just because function parameters are linked?
  512. Locking a Worksheet
  513. Worksheets/Forms
  514. How do I calcualte APR on Variable Rate Mortgages?
  515. SUMIF across worksheets
  516. Ensure unique solutions to random formula
  517. ISBLANK
  518. How can I prefill a text field with leading 0s?
  519. Counting Errors
  520. Difference between two months
  521. Worksheet name in a cell
  522. Conditional Formatting
  523. How do I set default folder for import
  524. Cell Formatting...
  525. How to show all formula's
  526. How to protect formula's, but allow autofilter
  527. dos from excel vba?
  528. =SUM(($C$1:$C$7>=--"10/01/2004")*($C$1:$C$7<=--"09/30/2005")*(H$1:
  529. INT((MONTH($C$1:$C$7)+2)/3)=$A$2
  530. lookup related with defined name
  531. CANNOT COLOR MY WORKSHEET TABS, TAB COLOR NOT IN FORMAT
  532. writing an "if then" macro
  533. Sum returning 0
  534. how do i concatenate a string and cell formula and use a comma?
  535. problem with replicate formula
  536. wts wrong with this statement
  537. AutoComplete not functioning correctly
  538. where can i find Formulas for excel 2000?
  539. Finding matching cell data
  540. Password protected? help!!
  541. Re: excel vertical function
  542. copying multiple selections
  543. to make a single row record become multiple row records
  544. Properties of a document, help!
  545. Sqlrequest only return one value
  546. error accessing a protected worksheet
  547. Hitting Enter to Move Cursor to the Next Entry Cell
  548. Re: Calculating an average based on 2 and 3 criteria
  549. Return Pay Date
  550. Calculation of instances a value is found in a series of cells
  551. Using last cell in a column that is not empty in a calculation
  552. Nested If Limit
  553. Nested if then else statement
  554. In excel the tabs at the bottom of the page are gone.
  555. dublication
  556. formula starts : =+ what does plus indicate?
  557. Adding a row to worksheet does not update cell references in another.
  558. indirect using name
  559. parsing a cell using |
  560. exchanging values amoung sheets
  561. diverting output
  562. Pivot Table Groups
  563. Concatenate
  564. Excel: How to choose data on two separate rows in the same column
  565. Large Function
  566. Divide a cell by 2 and then add that together
  567. Conditional Formatting
  568. Multi Level Subtotals and SP2
  569. add, multiply then divide
  570. Convert string of digits into a date
  571. how to turn positive to negative values in excel
  572. creating groups based upon correlations
  573. Multiple True's in IF Formula's
  574. Conditional formatting on overtime hours
  575. Copy Sheets Macro
  576. can you rank more than 7 items? how?
  577. How to Sum with two if statements
  578. Urgent date/scheduling calc needed
  579. Row Expansion
  580. Alpha characters problem?
  581. I need help adding cells together?
  582. MESSAGE BOX ON REQUEST
  583. I NEED HELP WITH CONDITIONAL FORMATTING
  584. Sumproduct help
  585. If/cross referencing functions
  586. Adding specific cells in column
  587. Checkbox - Unprotect - How?
  588. Auto Import OR Searching TXT Data
  589. Help with =MOD
  590. Where do I enter the PROPER formula in a spreadsheet?
  591. count number of occurances of a word in a range
  592. countif more than one sheet/tab and sumproduct
  593. Excel color functions
  594. Formatting Question
  595. Rounding
  596. List date adjacent to duplicates?
  597. Worksheets
  598. Sumproduct
  599. Finding Duplicates
  600. delete some cell formulas and leave others using code
  601. Combine functions?
  602. Multiple entries in column
  603. Why does the Pivot table iin Excel add a 2 to my name?
  604. Why is my tab key not working properly any more in Excel?
  605. lookup/vlookup for dates, please help!
  606. Totaling up a column
  607. Format a column wihtout using "Format-Cells-Number-category-etc"
  608. How do I calculate formulas for yes/no data
  609. Make Cells Text
  610. Using a column of data from 1 worksheet to extract data from another worksheet
  611. A weekly equivalent of EOMONTH
  612. Calculating % when 0 is 100%
  613. printing to pdf file
  614. subtraction formula
  615. Formula for area conversation
  616. Message Box to appear Thursday midday!
  617. moving x column values into x row values
  618. macro command
  619. How do I display "Help" Text in my own functions
  620. Formatting #N/A
  621. What if analysis, can this be DONE??
  622. Can I set up a signal in Excel to let me know when my due date is.
  623. i need to find duplicates! ASAP
  624. Throwing Out top & lower percentages
  625. VB and Excel
  626. cell A1=worksheet name
  627. automatic offset cell location when there is a value in a selected cell.
  628. getting data from another spreadsheet
  629. IF function and combo boxes
  630. How can I set up a shortcut key for Autosum?
  631. How do I include a supporting help file for a excel function?
  632. too long sumif help
  633. More help!
  634. Formula creation...if possible
  635. Sort a list with uneven row information
  636. Vlookup always gives me #NA
  637. Complicated If Equation
  638. IF statements and ranges
  639. IF statments and ranges
  640. Password Protecting Sheets in Excel So Others Can't See Certain Sh
  641. Urgent reply would be a great help
  642. selecting values from raw data
  643. Add new button to spreadsheet to print
  644. Formals with IF and Then
  645. vlookup in if
  646. Hide previously used items from multiple drop lists
  647. subtracting time
  648. Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl
  649. create a drop down list
  650. SUMPRODUCT help again!
  651. formula help
  652. Compare cells
  653. Ifs and Ands - I'm confused!
  654. function to reference all of pivottable data field array
  655. pivot table questions
  656. Differentiating data by year into columns
  657. Select all subtotal rows on Pivot Table
  658. my excel formulas are too long to execute find and replace
  659. TRIM formula
  660. I need a little help with comparing columns and indicating the mat
  661. Conditional Formatting in one column using data in two columns
  662. countif question
  663. Help with max() fonction
  664. Formula's
  665. Can you change the function of the fill handle on a cell in Excel
  666. How do I could solve a equation
  667. Formatting Charts from Pivots
  668. set all column formats to Text
  669. Help with formula statament with a MATCH.
  670. How do I set up a cell for blinking due dates
  671. Hyperlink Help Urgent
  672. change sheet name macro
  673. Summary Worksheet from Multiple Workbooks
  674. Creating my own user defined function help statements
  675. Count rows with specific attributes in VBA
  676. =AVERAGE(IF(INT(MONTH(C:C)+2/3)=4
  677. Adding Up cells in one colum IF cell in another column is yes
  678. Hours multiplied by money
  679. Workday function including sat, excluding sun
  680. what if the result of a formula is text
  681. How do you consolidate tables contianing text?
  682. Excell 2000
  683. how do i link to a pivot table to get data dynamically
  684. IF X = Reverse of Y True = 1 False = 0
  685. INDEX then MATCH
  686. "300" notfound?
  687. Urgent help
  688. COLOUR
  689. Increasing number of columns beyond IV
  690. increasing a value everytime excel is opened?
  691. Excel 2000 worksheet is off centered for viewing
  692. function to add or remove
  693. Convert real number to an h:mm:ss display
  694. If 2 cols meet a criteria then sum the 3rd column
  695. Regression intercept to 0
  696. CHITEST worksheet function - bug?
  697. inventory cells
  698. shortcutkey F9
  699. Help with a problem have tried a number of things
  700. Adding dollars
  701. VLookup using 2 worksheets, whole column reference
  702. random numbers
  703. Cannot download exel spreadsheet file with extension type xls
  704. how to group records in a new worksheet
  705. If statements
  706. How do i ignore letters in a formula?
  707. Find value grater than X but less than Y
  708. Using colors outside the standard palette
  709. calculate average for all of data field using GETPIVOTDATA?
  710. Currency to Text
  711. If then with 2 criteria, then sum
  712. =If (need 2 criterias), true, false
  713. Return Totals from Certain Criteria
  714. Adding to Summed Figures
  715. number anagram
  716. Imported Data creates blank cells that aren't really blank
  717. How to create a histogram that updates when I filter the input ran
  718. Colomn of various dates, count & give % of all under 1 year, etc.
  719. Searching a column and returning a yes or no answer
  720. Need assistance: Count non-blank within date range
  721. Mail Merge in Excel
  722. function for finding repeats in a column...
  723. Count non-contiguous cells where value is greater than 0
  724. Formula to Sum Cells that Hold If Formulas
  725. Possible index/match problem?
  726. Find
  727. Cant figure out formula?
  728. updating date!
  729. New rows at the end of a worksheet don't sort with the worksheet
  730. calculating years/months with YEARFRAC?
  731. YEARFRAC formula question
  732. Excel: can I refer to cell reference in page setup header
  733. Calculate Start Dates based on Need-By Date?
  734. Links in multiple worksheet.
  735. Perform calculation from drop down list
  736. Vlookup Question
  737. AVERAGEIF AND SUMIF AND COUNTIF
  738. Commas in indian style
  739. how do i format inserted cells in protected worksheet?
  740. view page breaks
  741. Gray vs Black Lines
  742. dynamic print area
  743. Excel should allow exchange between cells
  744. Formatting to separate dates
  745. Adding A "Timer" to a Macro
  746. Selecting Specific Data within a Table
  747. Text Error Message
  748. search string command to answer simple Yes or No
  749. Re: compare date to column data
  750. Countif