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. RE: scroll down today () with weekdays only
  2. CC130 Hercules Payload Distribution and Wt and Balance
  3. Searching several items from one document to another
  4. Re: Pivot Table
  5. Combine text from multiple cells into one cell - =(A1&","&A2","&A3
  6. Summing +30 Non-adjacent cells
  7. Date Validation and Cell Data
  8. Sort Excell cells that have each their own Validation criteria
  9. Re: scroll down today () with weekdays only
  10. tiny texas houses, tiny houses, tumbleweed tiny house company, tinyhouse, small houses, tiny texas houses of luling
  11. Format duration in mm/dd hh:mm
  12. Average members are making tens of thousands of dollars each monthwith this system. Apply now!
  13. Can I expand a cell without expanding the whole column in Excel?
  14. if cell is blank then calculate how many days?
  15. VLOOKUP and using a Name in the col_index_num
  16. Re: Pivot Table
  17. Need formular to use with dates
  18. Dynamic Date Drop-down List
  19. Blank Cell
  20. FV function
  21. vlookup?
  22. Saving for College
  23. Pivot Table column total not working (Excel 2007)
  24. hyperlink
  25. Sumif or Better Alternative?
  26. Adding Round funciton to handful of numbers
  27. replace state names with state code abbreviations
  28. Counting same names in excel (Coulums)
  29. Comparing columns with repeating data
  30. Comparing columns with repeating data
  31. Excel Formula
  32. Allowing sort of protected cells
  33. Re: VLookup+ Monthly Data
  34. countig of nonblank cells with speciffic condition
  35. Using Networkdays with negative numbers
  36. Summing values for a range of dates
  37. Change Picture based on cell value
  38. Auto expanding charts
  39. How do I get multiple Vlookup responses?
  40. Assign Macro with Hidden Sheet
  41. how do i set up an inventory work sheet
  42. COUNTIF not including something in both columns
  43. Formula to Increment by Letter not Number
  44. A formula to choose the correct table for my template
  45. Comparing 2 sets of data to fill in gaps
  46. Sumproduct of date range
  47. Help with tweaking formula
  48. Mutliple Sumproduct criteria
  49. Average of time each month
  50. calculate tax based on y or N
  51. Sum cells based on number of months
  52. Vlookup or use another formula
  53. Wrong Result with an IF function
  54. Conditional Formatting Question
  55. Rank in ascending order in Excel 2003
  56. How do get the LOOKUP function to not read empty cells as zeros
  57. lookup value if multiple matches are met
  58. help with IF and VLOOKUP combined
  59. reference cells on one tab by value of cell on other tab
  60. Count function
  61. Sum if Critea 1 and critera 2 are met
  62. Delete extra pages in Excel 2007
  63. Fill across worksheet pages
  64. Validation of input against the active directory
  65. Re: All data disappears when using autofilter
  66. Time x Rate
  67. using worksheet name in a formula but not current worksheet
  68. countif adding AND
  69. If statements
  70. I need to simplify this...
  71. I know I should know this
  72. Need a Formula , please help
  73. Count based on 2 conditions
  74. If, then
  75. relative address or reference
  76. column information moves to the next column
  77. Convert numbers to words: Revisited
  78. Function or If statement help
  79. counting duplicates and uniques comparing two columns
  80. How do I set up a function in excel to give either a <> or =?
  81. countif with AND comparing 3 columns
  82. The date in a excel worksheet is wrong. =now() responds 1-0-1900
  83. SumProduct meeting two criteria
  84. Rows to Repeat at Top - Formatting Multiples
  85. if condition combined with SMALL
  86. alternatives to embedded ifs
  87. Formatting
  88. Function returning unexpected value
  89. Formula to link a few cell to Calculate
  90. SUMIF criteria in different column is met?
  91. Help with complex "IF" formula !!!
  92. Return date if in range, else return blank
  93. Help using autofilter & Sumproduct
  94. Indirect reference
  95. find last populated cell in range of cells
  96. Indirect reference causes statistical function to throw up a #NUM!
  97. Unique values
  98. Pie charts - showing % & values
  99. Excel File corrupted
  100. Add Range If Q
  101. Comparing, counting, if, sum... help...
  102. Excel file link with two worksheet calculation
  103. Random Numbers excluding Previous Numbers
  104. LOOKUP function reversed?
  105. countif/sumproduct = criteria with weeknum
  106. Geometric Standard Deviation
  107. Calculate Future Date but don't want
  108. vlookup column based on user input
  109. Lookup Formula
  110. Re: Date field from text field
  111. Displays wrong result
  112. Copying formula vertically, to pick up horizontal cell values
  113. Conditional format stoplight based on worst color
  114. Vlookup - multiple tabs
  115. Re: Date field from text field
  116. Re: Date field from text field
  117. Include email dist. list into a Excel macro - how?
  118. CORREL w/ condition
  119. cond. formating quesiton
  120. automatically update a field only when data has changed
  121. Max with Multiple Ifs
  122. Alarm function, disable sound if data is erased
  123. I need to format a count in a pivot table
  124. How calculate exact # of months between two dates?
  125. Array Function?
  126. Remove Password
  127. How the data may stay on top with scroll ?
  128. Looking for BOOLEAN ALGEBRA functions (specifically XOR)
  129. Formating a cell
  130. Different twist on ISNUMBER
  131. Custom Format or use function?
  132. Conditional Formatting - Looking for Red/Yellow/Green Icons, w/ wo
  133. Drop Down Lists: Allow option of adding own data if not in drop do
  134. Cross Reference
  135. Sums
  136. Searching multiple fields and then print the entire row from resul
  137. Count Columns, Return Content
  138. Micro
  139. why does the dateif function result in an error in Excel 2003?
  140. Counting Column
  141. Display yesterday's date but only for weekdays?
  142. Cross referencing, fidning matching data
  143. Formula for calculator Table
  144. Named Array
  145. Please help VBA code not working properly send email when due dates
  146. Split astring using Capital letter as identifier
  147. auto scrol doune for hyperlink.
  148. format number to date
  149. Working on a big spreadsheet
  150. Adding a letter to the start of each cell
  151. RE: Showing the entire text within a cell.
  152. permanent conversion of 1904 date format to 1900 date format
  153. Ignoring Text using the AND OR IF function
  154. Lookup dates and values
  155. IF #N/A ( in a range), "ALERT","OK"
  156. 'Smart worksheet'
  157. Cell preservation or previous value.
  158. Excel 2007 worksheet to WEB page
  159. proper writing of a formula
  160. Create new workbook and new worksheet and close. Worksheet not sav
  161. Return result of IF logical test in a different cell
  162. using the Cell function
  163. Highlight a row with the current date.
  164. contest
  165. How do I copy the page set up from one worksheet to another?
  166. MACRO: Selecting "Cancel" from a drop down to copy and paste entirerow to another sheet
  167. =SUMPRODUCT((C481:C507<>"")/COUNTIF(C481:C507,C481:C507&""))
  168. Need to Speed Up A Code
  169. 2003 colors in 2007?
  170. Determine Value based on criteria
  171. Identifying correct elements with Countif
  172. Multiple lookups and SUM function
  173. Formula updates with SAVE AS
  174. Selecting rows within a range
  175. VLOOKUP or MATCH and/or INDEX to extract value on a given date
  176. Fred Smith - Extracting data
  177. copy & pasting automatic formulas
  178. Extract data from worksheet to worksheet
  179. Sum sheets based on criteria
  180. Re: NETWORKDAYS formula
  181. National language function names
  182. Counting number of rows between date range and meeting 2 string criteria
  183. VBA coding for expiry dates alert threw email
  184. ALPHABETIZING!
  185. Using Lookup
  186. how do i change cell text colour based on value in other cell
  187. Spliting dimensions down
  188. Siva and surya
  189. Sum If with two ranges
  190. Unique data
  191. countif comparing two columns
  192. Is it possible to choose a certain amount of rows and have them ex
  193. display actual value
  194. using dates for lookup
  195. Formula for calculating YTD values
  196. Show only future Dates
  197. Won't copy formulas
  198. excel
  199. How to read value of a cell in a relative location
  200. Change positive to negative number
  201. Why doesn't it print the colours?
  202. Give a sheet name from a Cell
  203. Excel
  204. How do I do an e-mail mail merge using an Excel spreadsheet?
  205. Structured reference does not return correct value
  206. formula for work rosters to deduct for different breaks
  207. VLookup needed to search one value and return multipe results
  208. Equal column widths
  209. Want more 256 column in 2007
  210. Excel
  211. Pivot table in 2007 with bytes
  212. Figuring total # of hours between multiple times
  213. How do I automatically select a Excel record randomly?
  214. Help with formula
  215. Macro start and finish date from rows
  216. Re: Extracting Data
  217. Want to open docs in two seperate windows..not the same screen.
  218. Extracting Data
  219. Conditional Formatting
  220. excel formula
  221. =TEXT(L9-K9,"h:mm") How can I sum the results to a total value
  222. how do I delete cells concatenanted w/out loosing combined info
  223. Calculation automatically
  224. Finding the largest match
  225. Using SUMIF with a drop down.
  226. Define a generic name
  227. How do I set a formula, that add next cell reference in a Formula
  228. vlookups
  229. Rank and Sort
  230. Run a macro in active cell only. Want to place current date/time.
  231. Excel 2003 - Help writing a formula to get time (w, d, h, m)
  232. Tracking changes that occur when links have been updated
  233. formula will only recalculate when i hit the save button -
  234. Multiple Lookups
  235. Getting the out put from different cells
  236. Forgot Password on a sheet and tab - how do I copy and paste
  237. Help with large texts in excel spreadsheets
  238. How do I get cursor to move left and right in excel?
  239. summing only certain numbers in calumn
  240. Copy rows based on parameters
  241. Worksheet to Worksheet
  242. linking data from one worksheet to another
  243. selecting the penultimate cell from a column of data
  244. How do I add up the last 12 cells (containing values) in a column.
  245. colum is not found thats missing a column B how to find it
  246. Re: Retrieve formula instead of value
  247. insert
  248. Omitting whole numbers when formatting decimals
  249. Lock Unlock Cell Protection
  250. Conditional Formatting and cloring cells and date calculations
  251. Saving workspaces (.xlw) Get error message
  252. If Formula When Contains Partial Word
  253. RE: jpg pictures in cells
  254. --(a1:a4)
  255. VLOOKUP with two sheets
  256. compare cells, copy, loop
  257. SORTING WORKSHEET TABS
  258. If any cell in a range has a value, return "True"
  259. sum if with an and
  260. formula setting cell type to blank and conditional formatting
  261. Data Verification between worksheets
  262. How do I make worksheet into fillable form?
  263. Data validation against seperate worksheet
  264. Recover columns in a worksheet
  265. Expanding beyond "Very Hidden"
  266. Lookup in External Worksheet
  267. Data Validation-pick from dropdown and next cell auto fills in inf
  268. Vlook-up in report with column Expansion
  269. Calculating 10 Business Days from the Last Business Day of the Mon
  270. Sumproduct formula not working
  271. text string
  272. SUMIF FORMULA?
  273. Index lookup with multiple match criteria
  274. Conditional Formatting on several sheets of the same file
  275. I need help creating a score sheet with weighted values. Help Plea
  276. Search
  277. vlookup in different workbooks with dynamic ranges
  278. Ifs
  279. How to do a lookup using multiple values
  280. Saving sheet data to another sheet automatically
  281. Sorting on multiple worksheets in Excel
  282. Can I format one cell so that it affects another cell?
  283. Format of cells Changing on thier own
  284. How to insert infinity symbol in excel?
  285. Date Range within a date range - try again
  286. Send Key to open a particular internet browser
  287. Dissabling Error when editing formula with Find+Replace
  288. OFFSET Function
  289. Covversion of date formats
  290. Coping a Coloured cell
  291. duplicate entries accross a workbook?
  292. How to concatenate cells that meets a specific criteria in threecolumns
  293. XL 2003: How do I get every possible combination?
  294. Excel range lookup formula
  295. savings yearly earnings ; 6.000.00 annual at 5.5%
  296. insert refreshable stock price no longer an option
  297. Get Cell Style
  298. Need to set character limit in cells of a worksheet.
  299. Adding text to cell
  300. Counting data that meets 3 different Criteria
  301. Is there a way to view multiple excel spreadsheets side by side?
  302. Sumproduct
  303. Comparing worksheets & input data
  304. conditional format of entire row based on a single cell in row
  305. Duplicates-to id when occurs in 3 columns for unique dup in 4th co
  306. Vlook not returning text value of cell
  307. IF and SUM formula
  308. SUMPRODUCT with Date Range
  309. Weighted Average of Variance
  310. Index formula-change cell range
  311. Conditional Formatting
  312. getting gridlines to show up on printed document
  313. date range within a date range
  314. Conditional Formatting
  315. How do I change the direction when pressing ENTER? (dn, rt, etc.)
  316. Multiple Criteria for Sumproduct
  317. Getting rid of Macro and Update Prompt
  318. SUMPRODUCT or SUMIF if any values in a range equal any values in another range
  319. How can I select the arrows in my spreadsheet?
  320. Excel formatting dates
  321. comparing times in excel
  322. how do i get datedif function downloaded into excel
  323. change text format dependant on formula result
  324. Need formula to prevent typing in duplicate numbers
  325. Count IF
  326. Hyperlink to cells in other workbooks keep changing
  327. can I make a macro to print?
  328. If, then, vlookup
  329. Apply Conditional formating to all cell
  330. Excel Formula
  331. Formula Required
  332. cell data in fixed position
  333. Should I be using IF to find how many times a word occurs in a ran
  334. Count records where date is within the last week
  335. How to add traffice light
  336. IF statement help please
  337. If, VLookup, Index, or a combination of all of them?
  338. Combining Uneven Columns
  339. Running two formulas as one
  340. All functions that use commas aren't working!
  341. Conditional Formating
  342. What is wrong with this nested function?
  343. Oracle import
  344. SUMPRODUCT Issue
  345. Complex formula assistance please.
  346. AVERAGE
  347. Duplicates in Excel 2007
  348. Rounding Negative Numbers to Zero
  349. Formula result and displayed result are different
  350. How can I use circular references that are allowed in Lotus 123?
  351. DSum - criteria in different row than value to sum
  352. Saving a file as a PDF
  353. Searching for text
  354. change date from 20-Mar-1920 to 20/03/1920 format
  355. Template or Excel ?
  356. Calculation using a date
  357. Paste solution
  358. highlight cells different colors in row
  359. font in drop down
  360. to fetch the rebate from another worksheet using itemcode
  361. Copy line if
  362. count function ???
  363. Working with Date/Time
  364. text as number
  365. I want to create an IF statement that leaves a cell blank if....
  366. Adding Days and Hours
  367. Showing date as day of week
  368. Excel Column Summation
  369. Averaging to-date lists???
  370. Array formulas/selecting data
  371. Totals of different worksheets.
  372. Is there a function that will return/copy an entire row?
  373. how do I get to cursor to stay on the cell when I press enter
  374. Age Date Between Two Dates to Return Value as 30, 60, 90 day
  375. Copy Paste in Excel 2007
  376. LINEST and Dynamic Regression
  377. Lookup Sizes and Concatenate
  378. Changing case
  379. sumif function or something else needed?
  380. adding a percentage for COLA to Payroll worksheet
  381. Comment in formula
  382. Lookup Across Multiple Columns - Return Category names
  383. string contra VBA code
  384. make a sound when a certain value is reached in a specific cell
  385. strike through
  386. Vlookup with changing columns
  387. customer Name against Unique customer number count
  388. Double Lookup
  389. UPDATE Query
  390. Sumifs function
  391. Using =MAX() or =MAXA() on Pivot results doesn't work
  392. Inserting Rows and the affect on Functions
  393. Circular Error
  394. header row
  395. If logical function with text and numbers
  396. what is the meaning of <>?
  397. Can you combine Hyperlink and Vlookup in Excel?
  398. CONDITIONAL FORMATING
  399. Letters with uniqe adress when printing
  400. delete a range
  401. how to merge execel sheets in excel 2003
  402. using pulldown list with a list and autocompleet function
  403. Rate vs. IRR
  404. Price time to cost
  405. Does complicated sumproduct formula crashes excel?
  406. Merge base on same code number
  407. How do I get the week in month from a date?
  408. Run Excel macro from Scheduled Task
  409. Time and Date populates automatically
  410. determining best data using functions?
  411. Average IF?
  412. IF formula returns blank cells--only want values to show
  413. Copy from one page to another
  414. Filtering / Dynamic Dashboard Question
  415. Array Help?
  416. Combining Lookup function and Sum function
  417. VLOOKUP question concerning population a price
  418. Formula Help-returning False
  419. excell 2003 result in t
  420. Averages with conditions....
  421. keeping same-row(or column) cell constant in a formula while drag-
  422. HLookup
  423. How do I see all previous posts
  424. If statements using less than or equal with dates
  425. formula to insert time of day in excel cell
  426. How do I use ColorRank()?
  427. formula to insert time of day in excel cell
  428. formula to insert time of day in excel cell
  429. How to arrange worksheets in alphabetical order?
  430. How to arrange worksheets in alphabetical order?
  431. Change Names to E-Mail addresses Q
  432. how convert cell formula value to text
  433. How do I do this?
  434. ImageShack Hacked - Popular Image Hosting Website Vandalized
  435. calculate overtime at 2 different rates
  436. TRANSPOSE results in zero values for blank cells
  437. TRANSPOSE results in zero values for blank cells
  438. Format based on cell contents being a formula or not
  439. TRANSPOSE results in zero values for blank cells
  440. using the ROUND function in a cell that already has AVERAGE functi
  441. Conditional Formatting (I think?)
  442. formula for sorting mailing lists for multiple records per sheet
  443. Formula to calculate differently based on original value
  444. countenvenate
  445. Count based on single number in string
  446. Sum used in macro where range stops at first non numerical cell
  447. Replace formula with calculated value
  448. Obama Checking out girl pics photos and video
  449. Calculating a percentage
  450. Update values from one column to another
  451. reporting value from other sheet
  452. maxa function results in value error in worksheet
  453. Excel Formula
  454. Modifying column references
  455. Replace formula with value automatically.
  456. Rounding off time
  457. Excel Spreadsheet Functions
  458. Master Form to Database
  459. In what way has excel 2007 improved on Array functions?
  460. COUNTIFS formula question
  461. How to hide 0.00 on spreadsheet with formula?
  462. Need help with "if" formula
  463. is there a way to type a number and have it translated into text?
  464. VLOOKUP and Return Last 2 Values
  465. Unique value list
  466. ProgressBar control displays erratically on Open
  467. =today()-3/7/2009 = 4?
  468. Capturing excel insert/delete events.
  469. Capturing Insert/Delete Events in Excel Sheet using c#
  470. inserting in wrong location
  471. Method Add of object Validation Failed - please help
  472. Excel 2007 XML Export
  473. Help With ADDRESS Function
  474. RE: Counting Days of the Week
  475. Re: Counting Days of the Week
  476. Re: Counting Days of the Week
  477. make copies of sheet and name them from list
  478. Match and copy
  479. Seperate date and time
  480. Formula If statement.
  481. Rounding Of Concatenated Costs Field
  482. complex CountIf situation
  483. How to copy Formatting Attributes from Source Workbook when Linkin
  484. IF, INDIRECT, & Wild cards
  485. Concatenate If
  486. Re: NPV - when does the first year start?
  487. look-up in a range
  488. Need help with end results Microsoft Office Excel 2003
  489. Live at Michael Jackson Memorial Concert -- All Videos here???
  490. Time Keeping Spreadsheet (Need not to Exceed Formula & subtracting
  491. Double SUMPROD
  492. Link to Access & Named Range
  493. How do I combine ISNA and IF functions
  494. Combining ISNA and IF formulas
  495. No including ZERO'S when using Average fucntion
  496. TAB to enter data, it skips one or more cells
  497. Check 3 cells, only one of the cells my be filled
  498. How to compare worksheets so differences are identified
  499. Easy for you...add % increase column?
  500. Re: NPV - when does the first year start?
  501. Conditional formatting and what if function
  502. Formulaic range with CountIf
  503. average using two criteria
  504. Sort with Link
  505. Search for inverted commas
  506. Excel functions
  507. If Formula Help
  508. sheet name in cell that is used by other formulas
  509. Inserting data from one worksheet to another
  510. SUMPROD and OTHER FUNCTIONS!!! VERY URGENT
  511. find text from 1 col in 2nd col & return value from 3rd col
  512. Hyperlinks
  513. Autosum and formulas that result in text
  514. vlookup vs sum
  515. "excel "macros may be disabled" message using an xlam file
  516. Excel 2003 - Relocating an entire row of from one worksheet to ano
  517. Convert Date to Another Format
  518. Countif, multiple criteria
  519. Expiration dates
  520. Can't unshare workbook
  521. multiple IF Formula help, Please
  522. Hiding/Exposing Rows based on a cell value
  523. Excel 2003 - Protecting Cells but allowing external data updates
  524. Freezing a row
  525. Unhiding rows in Excel 2007
  526. Using SUMPROD and trying SUBSTITUTE, ELIMINATE or TAKE the last VE
  527. MID, LEFT, RIGHT help
  528. Re: add a value to the cell value itself
  529. RE: Average only if ALL cells filled.
  530. Count if text meets given criteria
  531. Non Numeric String Lookup Issue
  532. how do I seperate information in one cell and make it into 2?
  533. Average with specific criteria
  534. Eliminating blanks
  535. Counting text problem - formula works initially
  536. return the price of an item in a cell
  537. Re: Lookup on multiple values
  538. Need Correct Function
  539. Calculate Minutes elapset between two cells
  540. Sorting columns on weekdays
  541. Conditional if formula.
  542. SUMIF on a Calculated Field
  543. Create a drop-down list from a range of cells
  544. count for multiple conditions in multiple columns
  545. I have a very specific question about excel, please help!
  546. How do I insert hyperlinks in blank cells
  547. Database questions, giving text a numerical value
  548. why does my excel change the print options of another user's file
  549. Re: Simple problem complex solution?
  550. Re: Sumproduct question
  551. Sumproduct question
  552. One validation drop-down populates another?
  553. How do I edit several formulas at one time in a worksheet?
  554. row and cell highlighted
  555. Series number changes for default colors
  556. TOTAL AND AVARAGE
  557. Maxifs
  558. significant figures
  559. Data Validation
  560. Re: Working with 2 worksheets
  561. using the "&" function
  562. Compare A&B columns with C&D columns
  563. Match
  564. SUMIF data that falls within a range
  565. Count Distinct Values based on criteria
  566. Sharing workbook from the server 2003
  567. locking multiple rows in excel 03
  568. Linking more then one cell to a Check Box
  569. scheduling
  570. CONCATENATE zeros
  571. EOMONTH, TODAY() and Conditional Formatting (Excel 2003)
  572. Count with multiple conditions
  573. I need and and/or statement
  574. Max amount of "IF" statements
  575. Sum Product values meeting 2 criteria
  576. Looking for a solution
  577. ytd totals for multiple years
  578. Conditional Counting of Duplicated Names
  579. can i automatically copy subtotals in excel to another s/sheet?
  580. Min Date againsts unique customer list
  581. maximum value (for a calendar date)
  582. Scroll with the mouse while editing a cell
  583. Hopefully an easy question
  584. =Text(n,"mmm") always returns "Jan" when n=1..12
  585. Which function/formula?
  586. Conditional Formatting Traffic Light System
  587. Need a number format.
  588. Calculation options change arbitrarily
  589. Sorting a spreadsheet and having it continue
  590. negative time in Hours and mins
  591. How to format a number.
  592. PivotTableWizard help with VB
  593. new summary function in pivot table
  594. RE: AutoSum and text
  595. RE: AutoSum and text
  596. Future Value Function (FV)
  597. Cell Content via Secondary Formula
  598. Dat. Validaation - simple ques
  599. Sorting a list
  600. how do i set up salse report for 24 filling station
  601. FILES IN excel
  602. Time format
  603. Creating child worksheet from parent
  604. giving me #Value!
  605. Identifying Duplicate data between 2 columns
  606. Trying to count the number of times a name appears / table
  607. Looking up same value
  608. Minimum IF Statements
  609. Need Help to repeat a symbol in each cell in a column
  610. Copy data from one worksheet to another
  611. test for upper case
  612. Any way to change generic icons in quick access toolbar?
  613. conditionals statements
  614. How do I add a column of numbers (auto sum)??
  615. Need assistance
  616. Assign Color to a Cell based on another Cell on a diff Sheet
  617. Sorting after my worksheet has input I want to save
  618. Nesting If and And
  619. Conditional Formatting #n/a
  620. Filling empty cell with value from the cell above
  621. Conditional formatting
  622. Drop Down Lists
  623. Too Many Conditions for IF Function - Help Please!
  624. Formula Based on Tables
  625. Custom auto filter (Dates)
  626. When editing a formula, how do I get the mouse wheel to work?
  627. Hide unused rows based on column info
  628. Add a row and totals based on changing cell values
  629. Calculated Fields in Pivot Table
  630. Counting Values amongst #N/As
  631. conditional statement =IF(A1<B1,"<",IF(A1=B1,"=",">")) <--- don't
  632. Hyperlink worksheet data to a index in a workbook?
  633. conditional formatting adjacent cells
  634. using =COUNTIF() in a variable range on a different worksheet?
  635. Aging Dates in Cond. Formatting
  636. Product Code and Product Description setup
  637. excel 2003 zero as last decimal again
  638. using worksheet.change function
  639. USe Contents of cell as name of worksheet in a function
  640. how do I sort four colunms date order different headings
  641. How to customize defaults in Pivot Table Values
  642. Programmatically add a Formula in a worksheet?
  643. Pivot table calculated field: multiply Sum of FieldA with Max ofFieldB
  644. Months not appearing in grouped dates in Pivot table
  645. how do I save and close multiple files in excel 2007
  646. PEASE ADVISE EASY WAYS TO CREATE VLOOKUPS in excel
  647. Convert Text to Formula
  648. Search and present lists
  649. paste special not working
  650. Wat formula shuld i use to find the details in the cell?
  651. How to combine text and numbers in exel
  652. 3D Array Problem
  653. [0]
  654. Macro for Insert/ Copied Cells
  655. How do I delete an already previously saved Excel spreadsheet?
  656. Message Box: Delete row x?
  657. RE: sumif with two conditions,current financial year date
  658. vlookup
  659. vlookup
  660. Cummulative sum against Condition
  661. Re: sumif with two conditions,current financial year date
  662. SORT data containing formula
  663. display a date
  664. Date Incorporation Frustration (sorry for the re-post)
  665. Find Function
  666. How to weave in Date Information please?
  667. How do I weave in "date" information to my formulas?
  668. Extracting Address data from single cells
  669. Transpose
  670. Same contents but not equaled
  671. Formula for Range area within VLookup?
  672. ADD 2 COLUMNS USING 1 LETTER AND 1 NUMBER
  673. microsoft excel 2007 keyboard shortcut for file menu
  674. Sumifs, averageifs, countifs
  675. DSUM with criteria:blank OR > some value
  676. Ole Automation and Excel 2007 footer
  677. sumifs in linked workbook
  678. Is there a maximun number of cells allowed in a name range?
  679. delete row formula changes array range on related sheet
  680. how to zoom into excel line chart with about 2000 point tia sal22
  681. if statement issues.
  682. Hide Columns based on a cell value
  683. macro that adds formula to replace text
  684. Merged cells disturb autofilter indicator
  685. Best site for freelancer work
  686. SUM of areas
  687. Conditional formatting
  688. 1. Is it possible to do this excel?
  689. File name from cell
  690. How to reference another cell based on what row a certian header i
  691. Writing Macro in Excel 07
  692. Using " " in If functions
  693. combining or "flattening" rows
  694. Specifying comparision criteria with SUMIF()
  695. Modifying several worksheets simultaneously
  696. plus 6 months
  697. can't find the right formula
  698. conditionals formulas
  699. Conditional Formulas
  700. calculate percentage of pay based on days old
  701. if function help
  702. Max date only against met criteria
  703. Update Links
  704. Excel 07 - converting pivot to formulas gives #N/A
  705. Fractions
  706. conditional formatting highlight dates 90 days or less
  707. CountIf function on combo-box entries
  708. Deriving Exactly XXX Amount of Weekdays
  709. Multiple Conditional Sum Help
  710. Need Help with formula writing
  711. Inserting a worksheet
  712. hiding the popup control calendar after clicking a merged cell??
  713. conditional formatting
  714. Pivot table treating numbers as text in value field
  715. Worksheet help
  716. How to compare a row data from one worksheet to another worksheet
  717. Macro's
  718. count based on single number
  719. excel interaction with Windows Desktop Search (WDS4.0)
  720. workbooks transfer from 2000 to 2007
  721. How to join word in one cell
  722. Reference to worksheet in chart
  723. Linked cell shows ######
  724. Find and return name of worksheet tab for referenced cell
  725. how can i use form/skjema tool for meny list spred in dif arks
  726. excel 2003 zero as last decimal
  727. Advice/best practice needed maybe some complex VB aswell
  728. Getting SUMIF to work in Excel 2007 filtered tables?
  729. Using Macros To Perform Multiple Averages
  730. what is the formula for mean?
  731. Sharing Worksheet
  732. Colour cell
  733. RE: From a list select the name with the most occurences
  734. New 2007 Sumifs formula - Is there a new 2 criteria vlookup?
  735. can I use the sumif function with cell formatting as the criteria
  736. Find & and delete everything following
  737. How do I set up a format to round whole numbers into hundredth?
  738. RE: From a list select the name with the most occurences
  739. I need a formula PLEASE HELP
  740. Combining If and Concatonate
  741. Adding the total # of characters in multiple cells
  742. adjust curser movement
  743. Triggering an action when an item is selected from a dropdown menu
  744. AUTOMATICALLY CHANGING DATA FROM CELLS ON DIFF SHEETS
  745. Find/Replace
  746. Find Text Within Text
  747. External link lag
  748. Update Date
  749. Unique Count
  750. VLOOKUP plus IF