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. Conditional Formating
  2. Combine two Column without Duplicate
  3. Countif (no duplication)
  4. Skip weekends
  5. Opposite of Countifs
  6. using index cards
  7. Spreadsheet or database? No contest
  8. IF statement with time over midnight
  9. Fill color in shape
  10. Reminder
  11. INT defect: Please try this on 2007 for me
  12. How Can i Link With one sheet to another sheet in Row to Column
  13. "If function" works in Excel 2000 but not in 2007
  14. Applying function after filter is applied
  15. simple excel file for tracking time segments in seconds...
  16. countifs
  17. Overwrite All Cells in Column
  18. RANDBETWEEN()
  19. what are the different excel bar names in excel 2000
  20. Cell matching and further cell replacing
  21. Finding a Workbook based on a Cell information in another Workbook
  22. Automatic Update in Multiple Worksheets
  23. Counting # of Formulas in a column with formulas and entered data
  24. Trying to SUM variable number of VLOOKUPs
  25. If then
  26. How do I write an array to include all worksheets in a workbook?
  27. Vertical Growth Percentage?
  28. vlookup
  29. Time Calculation
  30. help filtering for unique records - urgent :)
  31. Conditional Drop Down boxes
  32. Checking cells for part of a text string
  33. Removing a quotation mark from a cell through a function.
  34. SUM formula (sort of)
  35. How can i invert the selection of cells in Microsoft Excel 2007
  36. Days in a month
  37. countif two conditions met
  38. IF and VLOOKUP formula combined together
  39. Date
  40. Add numbers with a DATE as one of the conditions
  41. HOW CAN I SHOW Rs.125000 as 1.25 (RS. IN LAKHS)
  42. dates from inhouse system download as text.Convert back to date?
  43. saved hyperlinks don't open
  44. Rolling totals
  45. How do I move multiple tabs in multiple workbooks to a master?
  46. Add space between numbers
  47. Using SUM & VLOOKUP together??
  48. How To Sum Rows
  49. How to convert Word ot Text Article to Excel?
  50. 25#Data Validation
  51. Date formula
  52. leading and ending space
  53. Create a help hint for a UDF
  54. Change background colour
  55. Comparing data from two columns
  56. match total with fees
  57. create formula to calculate depreciation using units of activity
  58. how to conditional format a cell if the cell contains a formula (U
  59. A row of values
  60. saving a file with a date
  61. vlookup error even though data available
  62. Using SumIf Across Multiple Worksheets - Excel 2003
  63. difference in numbers displayed as a +/- percentage
  64. Cell Address
  65. Need to use text typed in a cell C27 in formula Ex:Vlookup(C27..
  66. insert calendar for drop down box
  67. How LOOK UP and SUM the values from several spreadsheets in one.
  68. Number of copies to print keep defaulting to 12 copies why?
  69. More if then logic
  70. More if then logic
  71. Clean Macro that WORKS...
  72. Edit the range of a pivot table
  73. Identify duplicates in row with conditional formatting
  74. Conditional Max
  75. allow multiple formulas in one cell
  76. SUM formula after HLOOKUP result true
  77. Pivot tables
  78. Count if
  79. get rid of a paintbrush in an excel box
  80. RE: Find latest value in a series.
  81. Solution to DATEDIF Function
  82. How to Edit Lists
  83. Finding 2 different letters in a range
  84. Finding a number within a range of numbers
  85. Offset
  86. Filter & sort a list
  87. Help needed on a function for multiple workbooks from 1 main workb
  88. A change in date will reschedule all other dates
  89. Clear empty space inside every cell in excel 2003 and 2007
  90. How to roll mouse in formula
  91. Vlookup - exclude a blank cell
  92. Formula for time.
  93. Why do some of my messages get deleted?
  94. Count Number of Rows
  95. Adding row to sheet; having hyperlinks follow
  96. Massive link update
  97. Value in Next Row
  98. Using a template shared by Steve and can't figure it out
  99. hiding sheets
  100. how can I include more than 8 if functions in a cell?
  101. table lookup
  102. If value matches criteria, return formula
  103. Reconcile Bank statement & Credit card statement & accounting data
  104. need to match two totals from two different list
  105. Increment by 18
  106. presenting data on multiple sheet on one consolidated sheet
  107. v lookup multilple columns
  108. Creating Function to Reference Cells that Contain Certain Values
  109. Lookup
  110. criteria form in excel with a hidden worksheet
  111. Help with a formula
  112. HyperLink to a folder on other drive on the same network (LAN)
  113. String Formula
  114. how to split date and time in one cell into multiple cells
  115. Extracting dates from a String
  116. SUMPRODUCT with condition FIND(text) is false
  117. if a cell has data, add suffix "N"
  118. Sumproduct gives #value
  119. VLOOKUP function with embedded LEFT
  120. NETWORK DAYS AND LIST OF DATES
  121. Cell Colours
  122. Copy data that matches criteria in one worksheet to another worksh
  123. formula to make the value in a cell, to a row in a sum function
  124. Lookup/Match Formula
  125. Re: Shortcut Key for Merging Cells
  126. Is there a function that will evaluate a text string in a cell?
  127. Bring values in a column into a row
  128. EXCEL INVOICE TEMPLATE THAT UPDATES DATA AS I INPUT ITEM#
  129. How to calculate projected sales for 2011?
  130. Needing to know what formula to use
  131. getpivotdata doesn't like certain numbers??
  132. "IF" help
  133. Reference cell ID in CUBEVALUE tuple instead of actual value
  134. How to count responses? Possibly use COUNTIF?
  135. Re: Shortcut Key for Merging Cells
  136. Loan Principal Payments
  137. DECREASE CELL VALUES BY 50%
  138. Using MIN function
  139. RE: Shortcut Key for Merging Cells
  140. RE: Formula Help
  141. Vlookup not returning information
  142. 16 diffetent if functions for 2 criteria
  143. freeze pane doesn't work in my excel 2007
  144. Removing statistical outliers
  145. DATE FORMAT NOT WORKING
  146. problem with the formula?
  147. Excel -- Data Validation -- Create Dependent Lists
  148. Countif with numbers and words
  149. Count of remaining months
  150. PivotTable Tools -> Options/Design tabs
  151. V Lookup
  152. Medianif with 2 conditions
  153. SUMIF
  154. Re: Find specific words in a cell containing a conversation
  155. take sheet name from a cell in VLOOKUP
  156. Payroll calculations for real time
  157. Re: Find specific words in a cell containing a conversation
  158. i have info many times duplicated and need to make a list of just.
  159. how do I fill series on different sheets
  160. Breaking Numereous Links
  161. Find Duplicates Across Two Sheets, Delete Everything else.
  162. IF Formula with AND added (I think)
  163. Formula help
  164. Find Max Date and the value
  165. join data in multiple cells when adjoining cells match criteria ??
  166. how can i bring a colum related to another colum?
  167. Column Widths
  168. Time date stamp
  169. Excel formula
  170. Calculated Pivot Table Columns
  171. Count help
  172. vertical scroll bar scale
  173. Master sheet data HELP!(please)
  174. Mod Function
  175. Syntax for 'search' in Horizontal range? XL2007
  176. Leaving Cell Blank
  177. Concatenating results of Conditional statement
  178. Nested if
  179. 2007-Delete only 1 row of objects on worksheet, not all of them.
  180. Formula
  181. Re: Automatic chart colours
  182. How do I strip just numbers from an alphanumeric cell?
  183. Problems saving Workbook as webpage with interactivity (Excel 2002
  184. Excel formula for linking two workbooks.
  185. filtering data within data
  186. Function or Formula help - get data from another sheet
  187. function to vlookup and put between?
  188. Copying worksheets?
  189. Sumif Help
  190. deming excel function
  191. Link to external worksheet merged cell returns a #VALUE
  192. IF Statement or nested IF
  193. Why is my OFFSET function not working?
  194. concatenate problem
  195. 'Volatile' OFFSET function not giving correct answer
  196. Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ?
  197. Delete Rows Without Specific Text
  198. Lookup or?
  199. Conditional format formula problem
  200. Links to other worksheet not updated or showing #VALUE!
  201. Multiple column search and Copy
  202. Conditional Formating
  203. Giving me a error ( =REF! )
  204. Validation of blank cells
  205. #Value Error
  206. Random generation of employee assignments
  207. Can data be sorted by the length in a field
  208. Is there a way to restrict the view of a worksheet
  209. formula help
  210. Work sheets tab names only replace part ot the present name
  211. Calculate within a time range with only start date and end date
  212. An old chestnut: finding the last cell in a range
  213. NEED HELP WITH EXCEL FORMULA
  214. How to write an `IF` and an `OR` formula
  215. Compare two worksheets with "contains" and not "exact" values
  216. find first occurance of certain value in grid
  217. How to match to any value
  218. Sum of rows in different columns
  219. Data Validation
  220. Selecting a Keyword for Macro:
  221. Import data from another sheet that matches to a class list?
  222. Budget vs Spend Reporting
  223. Pivot Table - Format Columns based on Criteria
  224. I need a formula
  225. Moving the second row with a macro
  226. find average of values from multiple sheets?
  227. If this post helps click Yes
  228. Reuters Link
  229. Capture lines with entries?
  230. Suggestions on what function - staff record hours sheet
  231. Get rid of #DIV/0! without repeating denominator?
  232. Sum if two conditions met
  233. Filling a reference series in alphabetical order, not numerical
  234. Logical Test - Returning Value
  235. List that brings up another List
  236. yearfrac function
  237. Averageif Error
  238. subtotal greyed out when in column
  239. Extract Text with Left, Mid, etc
  240. Recalculation
  241. Multiple Criteria & Count if Equals 0
  242. Formula, Macro, or VBA code to find and insert
  243. how do I referance a data valuation cell from another worksheet
  244. Pivot table data source
  245. Help - error entering data into cell
  246. Formula to count text string in column cells of filtered rows
  247. Filtering from left to right?
  248. sort part of a filtered spreadsheet
  249. Pivot tables
  250. cannot copy in excel by dragging a cell
  251. Retuyrning a single entry when multiples of the same
  252. If Statement to display 3 different outputs instead of 2
  253. Return text between look up function.
  254. Min/Max of Numbers as Text
  255. Sorting Spreadsheet Help
  256. yearfrac
  257. IF TYPE FUNCTION
  258. Find the top 10 from multiple groups.
  259. Add Data to Workbook with information from another
  260. Weeks of Supply Calculation
  261. Maintain - AutoFilter and Subtotals selection/layout?
  262. SUMIF for text
  263. 3D worksheet question
  264. Special count.,,
  265. How do I limit rows and columns in all of my excel 2007 worksheets
  266. VLookup Function & Data Source
  267. How do you convert a fraction to a decimal with 3 places
  268. How to subtract with 3D between 3 worksheets
  269. RE: How to subtract with 3D between 3 worksheets
  270. Pivot Table Format Default
  271. Re: Countif: Multiple Columns
  272. If a range contains
  273. Countif: Multiple Columns
  274. Lock/Protect Grouping Feature in Excel
  275. All “General” values changed to “Date” format
  276. Countif Question
  277. Excel: pivot from large data
  278. Formula uses previous saved spreadsheet data!
  279. Countif looking at many sheets
  280. saving info in drop down boxes
  281. SUMPRODUCT and "--"
  282. Deleting Rows on condition
  283. Lookups & match ????
  284. MOVE TAB DOWN COLUMN INSTEAD OF ACROSS ROW
  285. safeguarding document
  286. Is it possible to create a customised conditional format icon in e
  287. Selecting a Keyword
  288. Count no. of occurance in 2 dynamic columns within a data period
  289. copy data while skipping a predetermined number of cells
  290. Conditional formatting - getting input from another cell
  291. how to round up in exel to nerest cent
  292. Identical Cells in Multiple Worksheets in one Workbook.
  293. If formula
  294. the sum of a row based on condition of a dropdown box
  295. "rolling up" numbers
  296. random draw from list of names
  297. countif formula using named cells
  298. getting an average while excluding high and low input
  299. Multiple If and Large functions in formula don't handle all circum
  300. Combining all rows of two colums together into one column
  301. Why is a descending sort putting blank cells first?
  302. Two Criteria COUNTIF
  303. Find a column of data in a table
  304. formula to switch last/first name around?
  305. Linking sheets how do I display the zeros (0) as blank cells
  306. Help! Forgot formula for auto copy of cell value...
  307. IF, OR and SUM function
  308. Need x-Axis Pivot Chart Help
  309. How to protect a column or columns
  310. Average over autofilter results
  311. Multiple Answers From Drop Down List
  312. Why do Excel cells not calculate until I hit "save"
  313. RE: Creating a Formula with conditions
  314. Advanced use of WORKDAY function
  315. Working with arrays as arguments
  316. Unique data
  317. How to filter unique entires in a column when differnet entires in
  318. existing connections
  319. Automating a computation process
  320. Formula to Increment a number upon a match in an adjacent cell
  321. Need Packing Slip
  322. RE: creating a "date selector box" or "pull down box" in a cell
  323. Re: creating a "date selector box" or "pull down box" in a cell
  324. Count rows that meet 2 conditions in Excel 2007
  325. Protecting sheet but keeping list functionality in 2003
  326. cursor buttons seem to stick
  327. Replacing special characters in Excel 2007
  328. Conditioanl Sum Help with Multiple Sheets in a Workbook
  329. sumproduct excel 2007
  330. =IF(ISERROR(GB18-FC18),"",(GB18-FC18)) returning zero instead of b
  331. Excel Formula Help
  332. Concatenation help
  333. combining multiple columns using ", " seperations..
  334. conditional formatting based on relative cell value
  335. Sumproduct
  336. Possible?
  337. Functions
  338. Allocating Intergers based on Relative Percentage
  339. Reset Cells Value
  340. sort rank
  341. vlookup returns more than one value??
  342. Duplicate Values in Excel 2007
  343. Atomatic subtotal in every pages.
  344. Compare and sum
  345. Links from word to excel
  346. failure to update conditional formatting
  347. How do I acess the printer variable "number of copies"?
  348. Work oiut a persons age at a given date
  349. automatically locked cells
  350. Pivot Table - copy specified Grand Totals
  351. How do I access the printer variable "number of copies"?
  352. why my Excel Columns become numbering from alphabet?
  353. Finding the date of the previous Thanksgiving Day
  354. Formula for number combinations.
  355. Index Match to add employee number
  356. =COUNTIF(range, select items highlighted with specific color)
  357. help with sales formula
  358. macro to sort is missing top row out???
  359. The best way to create a Keyword Seach field in excel
  360. Looking up a worksheet and value
  361. DROP DOWN MENU "source"
  362. Need to Sort #'s in Column B,C&D in the order from Column A
  363. FORMULAR REDIRECT
  364. How to automatically set print area in Excel template?
  365. Using the $
  366. help with sum / count formula
  367. Excel Bank Statement reconciliation templates or???
  368. Highlighting dates in a cell relative to the TODAY()
  369. obtaining info from multiple cells from different workbooks.
  370. Help with INDEX, MATCH
  371. help with sales formula
  372. What formula would I use?
  373. vlookup with more than one reference with the same name
  374. Count number of indirect connections between airports
  375. Combo box showing row number only
  376. Select sheets ina workbook based on radio buttons and move them
  377. How do I keep the headings visible while scrolling down in Excell
  378. Stubborn cell formatting.
  379. Mail Merge
  380. #N/A error with VLOOKUP function
  381. cell value functioning as whole number in formulas
  382. Re: xldynamic is back
  383. Return the first Wednesday of each month
  384. Trend line for each
  385. How do I color code comments in cells on Excel spreadsheet?
  386. need one PERMANENT FORMAT but format changes row to row
  387. How can I automatically color a cell based upon a condition being
  388. Worksheet page numbering
  389. Counting word types in a cell
  390. Count based on criteria
  391. remove some but not all internal spaces
  392. Calcuting sum of specific word "P" within specific cell range (A5:
  393. Countif for 2 columns
  394. Add a number sequence based on criteria in another column
  395. Dropdown menu help
  396. How to divide numbers in Excel?
  397. trouble with lookup in a range of cells.
  398. how to divide numbers
  399. How do I create a graph from a worksheet?
  400. Formula that compares Cells and formats if not equal
  401. Lose Relative reference on sort
  402. Calculating End Date - Given working 4, 5, 6, or 7 day workweek.
  403. calculating number of prior pay periods in year when given specificdate.
  404. Need help with INDEX lookup
  405. Solve for X and Y
  406. When a cell is blank, add another
  407. Shortcuts
  408. Duplicate lines in spreadsheet
  409. Text to Time conversion
  410. Keeping Rows Together
  411. Messages
  412. Save value of cell prior to change
  413. copying cell to a range
  414. How many days fall in each month?
  415. Edit REplace String
  416. return array formula lookups in to one single cell
  417. Split apart list of part numbers into different columns
  418. Filenames and formulae
  419. Search a sheet for a date then delete the row, repeat until the lastrow of the table.
  420. Moving the second row to the last row
  421. Returning the result of a vlookup in the same cell
  422. how to find #ref! invalid cell references within cell formula
  423. Convert decimal days to hours and minutes
  424. Formula required
  425. Formula required
  426. //sk - Max length of a numeric field.
  427. Need Formula For Data Summary
  428. Pvt Tables - Custom Calculations - HELP ME!!
  429. name sorting
  430. Insert a Decimal
  431. I need to add something onto the formula...Can anyone help?
  432. Match,Update & insert new data - Please HELP!
  433. Conditional Countif
  434. vlookup with merged cells
  435. How do I assign a number to a name in another column?
  436. #value! error in sum function
  437. Using Average
  438. Can I combine Excel COUNTBLANK with another function?
  439. Trying to enter a formula to sum a colum based on 2 condition
  440. Don't show all Pivot table subtotals
  441. xldynamic is back
  442. Conditional Formatting
  443. Date function
  444. Parse a Cell value using another listing showing criteria
  445. Is there a way to toggle between sheets within a workbook?
  446. Macro for Shading and Unshading
  447. Complex If then?
  448. countif where condition should be met
  449. about comma style
  450. grouping numbers together
  451. How many 'unique' customers has everyone been involved with?
  452. Return value from specific column if not in new column previously
  453. Multiple IF functions
  454. calculating p value for a 2*2 table
  455. add 10,0015:15 hours to 03:53 Hours to a total time
  456. hide collumn function is giving error message
  457. Package Quanity Moves Help with formulas
  458. lookup on range (A2 and D2:D30)
  459. multi functions
  460. Subtotal based on a range of data in Pivot Table
  461. Using a macro to enter a formula
  462. conditional formatting refferencing another cell
  463. Find Sum of Values corresponding to each value type
  464. Creating Data Validation Dependent Lists
  465. Auto Capital - (Further Question)
  466. How to change cell background color as part of the If statement?
  467. How do I use formulas using dynamic names
  468. Average Base on Multiple Columns
  469. Re: Enable Macro Alert Box
  470. Need help in showing future purchases over a period of time and atset intervals
  471. #VALUE using SUMPRODUCT function
  472. Sum = B3 if B1= Marketing
  473. Increments less than one in format control box for spinner
  474. Conditional Formatting
  475. Combine date from multiple Workbooks into one worksheet
  476. nested "If" fuction
  477. "IF" question
  478. Insert a watermark...
  479. RE: Enable Macro Alert Box
  480. Re: Enable Macro Alert Box
  481. Sumproduct with mulitple criteria containing equals and or's
  482. Copying cells from one sheet to another
  483. COS H (Trigonometry)
  484. Excel 2003 - open work book useage agreement
  485. COUNTIF - USING WITH TIME VALUE RANGES
  486. Worksheet setting error...
  487. Worksheet functions plot and #NA's
  488. PivotTable PageFields c# / api changes from Excel 2003 to Excel 20
  489. Conditional Formatting with COUNTIF
  490. LOOKUP function
  491. COUNTIF with a range of time values
  492. vLookup a portion of a no. in a cell
  493. #DIV/0 ERRORS IN PIVOT TABLES
  494. When I link blank cell in one sheet registers as 0 for averaging
  495. Location Oriented Formula
  496. The clear filter from a a heading cell is grey out
  497. Row Height Adjustment on data Imported into excel
  498. I have the following issue with COUNTIF
  499. How can I copy multiple formulas between workbooks at once?
  500. Vacation accrual based on years with rollover
  501. Countif
  502. Generating different numbers of rows depending on data
  503. Sumif based within non blank cells
  504. create "IF" formula ?
  505. MERGE 3 columns into 1 all text
  506. Return a value based on 2 or more columns of information
  507. Formatting numbers
  508. validate # of decimal
  509. averaging a column of letter grades into a numeric GPA
  510. retrieve duplicate information from two reports to create new rep.
  511. Automatically move text from one document to another
  512. Auto Capitalising an active cell
  513. If then request
  514. Calculating
  515. Sorting characters, ignoring numbers
  516. How can I show up and down arrows when a value changes?
  517. Spreed cost usig integral numbers (whole numbers)
  518. remove fill in text from a cell from an unpopulated fill-in cell
  519. Re: Runtime 9 error Check.
  520. Transfering information form one cell to another work sheet
  521. Add criteria to sumproduct Greater than or equal to
  522. In Cell Formula to mimic text to columns.
  523. Create formula to; sum the lowest 10 cells in a column
  524. Conditional formatting based on max in range of other columns
  525. inserted comment not displays in the cell it displays on top row
  526. IF formula can't figure out, please help
  527. 2002 Hyperlink issues
  528. Need an Excell function that can lookup vertical AND horizontal
  529. Sheets have different size in typing
  530. How does one ADD to a dropdown list?
  531. Function with unknown quantities?
  532. Function with unknown quantities?
  533. Page layout problems after moving worksheet
  534. SUMPRODUCT with INDIRECT
  535. Convert text string to IP address
  536. does Excel 07 allow User Defined functions?
  537. VLOOKUP - columnar sheet with multiple matches - need to return a
  538. Sorting data with a formula
  539. place array at calculated position
  540. How to work out 3 different %
  541. How can i do this???
  542. When Does Excel Do The Linking?
  543. INDEX AND MATCHING FUNCTIONS
  544. Can I add values of a column that are only in bold format?
  545. PAGE VIEWS
  546. Urgent:Find match between two worksheets and copy to another sheet
  547. FORMULA
  548. how many rows do I get in 2007
  549. Data Validation - On_Error messaging
  550. Open Second Workbook Hidden?
  551. Conditional Formating and Recalc
  552. Material List
  553. Time function =Now formula
  554. Formula
  555. Sort each line horizontally and separately
  556. another sumproduct with #value error...
  557. how do i sort my excel worksheet in
  558. sumif formule using headers as criteria
  559. How to replace a zero with "Not Available"
  560. vlookup function
  561. Assigning a set value to a cell that has a percentage?
  562. Save spreadsheet as webPage with interactivity
  563. Cell reference in VBA
  564. Retrieving old file
  565. drag down
  566. Validation drop-down boxes
  567. #REF error!
  568. Averaging only populated cells
  569. Transpose
  570. How to pop out individual data from cluster of data
  571. highlighting cells with formulas
  572. How to calculate with formula results after formatting with =TEXT
  573. How to Run a Macro from clicking a cell
  574. Active cell coloured
  575. I cant unprotect my shared document??
  576. Lookup in Tables
  577. Return Tab Name
  578. Presentation
  579. All data in my worksheet was lost how do I retrieve it
  580. lookup
  581. lookup help
  582. Do not sum until cell has a value
  583. vlookup
  584. why can't I change the color of a cell?
  585. #VALUE error
  586. Adding Hours & Minutes
  587. List of VBA Commands/Operators for Excel 2003 SP3
  588. Compare 2 lists of random numbers - Excel 2007
  589. date notifications from spread sheet
  590. Sorting Macro
  591. How do I start a new sequence of radio buttons?
  592. Need help with DGET function
  593. Extracting Terms and Exponents of a Text Poly Formula ??
  594. Excel 2003: VLOOKUP not refreshing
  595. Linked cells not refreshing
  596. Excelerator
  597. Want to display value in chart
  598. data in drop down list is limiting number of entries
  599. Excel 2007
  600. Grouping a timeline in a pivot table by months.
  601. Return actual range not cell value in variable
  602. Rounding
  603. Add sheet name into a variable.
  604. Is there any programming tool which can calculate single worksheet
  605. vlookup
  606. Subtract 1 random no. in col from another without naming cells?
  607. Evaluating a DDE formula created by strings
  608. Data validation - critical
  609. remove 'click to add data' page?
  610. UDF causes #VALUE! error
  611. Formula to Embed a file object in my excel sheet.
  612. lookup time value
  613. Schedule Formula - Please Help - Thanks
  614. help returning the same values from two different cells
  615. Trying to count the number of buyers or sellers for a given month.
  616. Re: Average Last 100 Filtered Visible rows
  617. text converts to scientific
  618. Need help in how to filter data
  619. How do I exclude the HIGH and LOW values in the =AVERAGE function
  620. One # out of many
  621. link worksheets by proper identificaton from master
  622. Sorting Directory City/Street/Number
  623. How do I
  624. Formula Error
  625. Adding checkmarks to an excel spreadsheet
  626. Check IF statement please
  627. Counting in Excel
  628. Excel 2007 - Pivot Table - field calculation help
  629. Hovering over a cell to show all data used in that cell
  630. Protected worksheet no longer
  631. Sort by setting two conditions
  632. Showing all data related to the quantity in one cell
  633. Adding Regressive Months Totals
  634. Calculating a Formula Subject to a Maximum and Minimum Value
  635. IF FUCTION WITH 2 SETS OF CRITERIA
  636. Match worksheet Function displays wrong data on calculation
  637. If cel in next colum same row = less color red
  638. Formula with dates in COLOR
  639. Function to evaluate function as string
  640. Adding Progressive Months Totals
  641. nth row or column counting
  642. 2 Conditions in VLookup
  643. How do I create a drop down list that fills multiple cells?
  644. Counting latest date in two columns
  645. my vlook up is not pulling the correct info from column 2
  646. Using Validation Ref # within LOOKUP
  647. nested if function
  648. RE: Macro Amendment.
  649. RE: Moving Value Sheet to Sheet
  650. use time functions inside if loop
  651. Help required with complex Removing of Duplicates
  652. Loop based on number entered in userform
  653. Re: Display an Array of Data Based on Other Data
  654. Visual basic functions
  655. Am I missing some easy solution to my problem?
  656. Expanding formula to look in several sheets
  657. comment enclosed using vlookup
  658. 255 Characters
  659. Function for 2nd and third low or Max
  660. problem with a function to calculate weighted test score
  661. Excel 2007 Creating a chart
  662. Schedule Formula, please help...last problem to overcome....thanks
  663. Re: List Disctinct Strings from Range of Cells
  664. Re: List Disctinct Strings from Range of Cells
  665. lookup last nth number of items in a list
  666. I need a cell to be blank.
  667. Re: List Disctinct Strings from Range of Cells
  668. Count if dates meet certain criteria
  669. My Excel 2007 won't multiply. (ex. =C3*D3 enter) ... nothing !
  670. Exclude days
  671. Indirect? or Match? ??
  672. how to return data from a right hand side/and one cell down
  673. Excel 2007
  674. Counting rows
  675. countif or sumproduct ?
  676. PLEASE ALWAYS INDICATE YOUR VERSION OF EXCEL
  677. Combining Data from 2 worksheets
  678. SUMIFS with an OR criteria
  679. Count if two arguments are true
  680. Changing Validation List
  681. vLookup returns formula and not result
  682. MOving Data to the next line
  683. RE: List Disctinct Strings from Range of Cells
  684. if function with multiple criteria
  685. Nested If with VLookup result a 0
  686. how do I change the date format from yyyymmdd to mm/dd/yyyy
  687. IF statement to check for numerical value
  688. Concatenate range (without UDF)
  689. Sum and subtract columns when one cell contains preceding text
  690. vlookup i think
  691. Format row using date
  692. Find match between cells and copy data
  693. Data cleanup
  694. Combining Macros and if function
  695. Conditional Format 2007
  696. Macro to Reset data input form
  697. How to use: (ERR) a form.contains 1 or more invalid refs.?
  698. dates and text in excel
  699. Multi area Array using IRR function
  700. Store array ???
  701. Formula Suggestion
  702. Userform Refresh on Worksheet change
  703. I want to secure a column from have the same number entered twice
  704. Add COUNTIF TO USERFORM TEXTBOX
  705. Sum with matrix functions?
  706. how do i select all cells in a worksheet
  707. Cell Validation> Lists
  708. Where is the list function in the data menu?
  709. Maximum number of data validation cells?
  710. I WANT TO INSERT A LETTER IN FRONT OF A NUMBERS
  711. I need to divide multiple cells by a single control cell in order.
  712. Spaces at the end of data
  713. Spreadsheet usage
  714. Looking up data.
  715. CLEAN function - macro??
  716. change appearance of cell being used so it stands out
  717. function to reference value selected with autofilter
  718. Tough formula to cause auto-updates in multiple cells
  719. Looking up first and last
  720. Contact Us link is broken
  721. Remove data in a cell
  722. STDEV Limited Number of Arguments
  723. Extract data from a cell
  724. formula date range
  725. Re: Designing master schedule
  726. Data Connection Parameter Issue
  727. Want to display day and month in date and hide the formula
  728. Return blank cell if data cell is blank
  729. Excel Function to Count
  730. Calculating Cell Occupation
  731. Create a List Output from a Horizontal Array Input
  732. Help with Excel if function and macros
  733. countif using multiple if statements
  734. Calculating the days between two dates
  735. functions/Formulas
  736. add apostrophe to text in cell
  737. filter and relations between fields
  738. Excel Entering Identical Data in a Designated New Cell
  739. Formatted Result from an IF function
  740. Formulas and clip art
  741. If cell contains a value, multiply...
  742. Pivot Tables by Macro
  743. XIRR non adjacent cells
  744. vlook
  745. Dates format
  746. Count If
  747. How to get it
  748. Formula to subtotal monthly expense
  749. RE: How do I lookup and compare cells?
  750. retrieving multiple corresponding values with variable rows/column