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: printout with auto date
  2. Excel lookup on multiple rows and columns
  3. Passing data to fix cell
  4. I really need help with a rule
  5. How to appy the formular with different cell parameters~kindly hel
  6. Greater than AND Less than Time Q
  7. limit number of rows in worksheet from 6000+ to 600
  8. Is this even possible??
  9. Scoring rank change and corresponding point difference
  10. disappearing spreadsheets
  11. How do I print the data stored in my Excel database?
  12. Inerting name of current worksheet into fuction
  13. Extend search results in a form
  14. Complex problem in Lookup
  15. Friday as weekend in Workday Function
  16. Elapsed Time Formula
  17. Print Area as dynamic range?
  18. Parse cell contents to new columns
  19. Cell reading Balanced problem
  20. Need macro to post data from user input
  21. Download #1: World's Major Stock Exchanges Tracker Chart
  22. lunch break!! well..how to figure
  23. how to insert tally mark in excel
  24. sort not working
  25. Think I need an Array; not sure
  26. Nested Formula
  27. how to stop array from superimposing itself over excel 2007 worksh
  28. 2 validation lists for the same value on another cell
  29. subtracting 2 dates and put the result in difference in months ?
  30. data entry problems in excel
  31. Kakuro Killer Sudoku solving formula
  32. How to get the cell reference of the value selected from name list
  33. How do I add an equals sign to a cell that already has numbers in
  34. How to check whither a text is existed
  35. How do I create a list that will copy the entire row?
  36. Excel Formulas
  37. Compare & highlight changes between two worksheets?
  38. VALUE ERROR RETURNED FROM FORMULA
  39. Inserting and Deleting Rows in Excel
  40. Formula to create a list of people who qualify
  41. Seeing only answers in Google group -- no questions
  42. Coppy formula using OFFSET
  43. Determine year over year date for comparison
  44. Excel hyperlink to another open Excel file - wants to reopen file
  45. Alternative to the limitations of the 'IF' function in Excel?
  46. Combine Pivot tables - confused about 'how-to'
  47. Formula for adding values that have a letter at the end in Excel 2
  48. How do I add sequential numbers to existing data in excel?
  49. count nonblank cells with conditions
  50. Count values in one column only if criteria is met in the next column.
  51. greater than forumla
  52. Excel formula
  53. Satisfying Multiple Criteria in an "IF" Function
  54. Mercantile Plumbing calcs
  55. COUNT
  56. How to create daily calendar for reservations ?
  57. Need a total count for various numbers in a column
  58. IS BLANK checking 2 Cells
  59. combine multiple workbooks? overcome 255 character limit?
  60. Protect
  61. least prefix matching in a lookup list
  62. lookup (match?) & average
  63. Delta E(cmc) formula
  64. Summing multiple validated sheets into a summary sheet
  65. Negative number format
  66. BLANK CELL
  67. Nested if statements
  68. date range
  69. Display number only if entered in a cell
  70. Summing values for split groups
  71. Cell Protection
  72. Avoid #div/0!
  73. How do I collapse rows in Excel?
  74. Match !
  75. calender
  76. leve chart
  77. Excel Template (Creating a Function in the template)
  78. Excel template Help
  79. what is the best way to learn MACRO for MS-Excel
  80. Macro / function text time to 24hr excel time passed midnight fortotaling hr's
  81. Formula help
  82. The formula works if I copy from Auckland Kilometres
  83. How to determine the cell location?
  84. How can I reformat all comments to a larger font?
  85. Countif
  86. Combining all tabs into 1 master w/o copy&paste
  87. Return 0 when if statement with VLOOKUP returns#N/A
  88. SUM function on multiple worksheet
  89. COUNTIF FUNCTION
  90. Eliminate Negatives
  91. Formula and worksheet will not working properly
  92. How do I get a macro or excel function copy a value on date
  93. Copy formula question
  94. copy paste to first first open row
  95. how do I delete a new window in excel?
  96. Match !
  97. alpha characters in a formula
  98. Formula help again, Please
  99. Average Times by Possible Named Ranges
  100. What formula do I use?
  101. function doesn't run, just returns function
  102. How do I use functions that I have written in Excel formulas
  103. ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH
  104. Multiple conditions
  105. COUNTIF
  106. Counting unique text that meets several criteria
  107. can I use information from another sheet modify it, into a formula
  108. Re: expand alist of time stamps
  109. vlookup
  110. Formula to count based on multiple criteria fields w/duplicates
  111. Rounding formula when using conditional formatting?
  112. Formula needed for counting
  113. Conditional Protection question
  114. Calculating hours
  115. TAB out of a combo box
  116. Formatting string in groups of letters...
  117. Non-actual external links remain
  118. "Delocalized" date format
  119. How do I write an "if" formula??? See below......
  120. sheetname
  121. rounding
  122. Sumproduct with filters
  123. Arknavn
  124. Conditional Formatting in Excel 2007
  125. pivot table
  126. Return the logarithm stats for a line of best fit
  127. Formula - Budgeting
  128. Editing Weekly Inventory
  129. Count unique values across two columns with multiple conditions
  130. count number of unique values in column
  131. Searching for a string of text inside a column
  132. Sumproduct thru blank cells
  133. Populate days of the month in a column by checking on date
  134. How to calculate run rates in sales for last 6 months with excel
  135. Delete colomns and rows
  136. multiple formual'a that equal the same thing
  137. FILTERS
  138. Need LOOKUP to find the number above not below the specified numbe
  139. Predefined Cell Character Length
  140. Advance Filter
  141. Comparing two spreadsheets with pricing information
  142. Omitting blank cells until filled in?
  143. I can't get the lower margin to zero in Excel
  144. Equation...help needed!
  145. Using COUNT for text occurances in unusual worksheet?
  146. highlight cell
  147. Copy and paste
  148. COUNTIF(range,>=range_name)
  149. HELP PLOTTING
  150. How do I find a macro in Excel?
  151. Limitation to % of column in PT?
  152. Formula assitance needed
  153. Excel Formula Help
  154. refresh advance filters
  155. How to calculate # of days
  156. function stumped
  157. how can i set up changing invoice numbers in excel?
  158. "If" function question
  159. function question
  160. Calculation completion date/time
  161. Date Calculation
  162. Custom number format via formula
  163. Link updates Excel 2007
  164. count of max occcurances
  165. Cursor to upper left of frozen cells (in macro)
  166. Lookup and return range of values
  167. IF Statement calculating Average if you have numeric & text respon
  168. Evaluating more than 30 conditions using a formula
  169. how i do this in EXCEL
  170. Using Match to find value on worksheet
  171. Index Match
  172. Function to extract data from a list
  173. How can we run FIFO Inventory in excel?
  174. FICA Formula
  175. I want to help you pass your Microsoft certification exams.
  176. value vs formula
  177. multiple formula's in one row
  178. Entering 6 digit numbers into a cell with zeros at the beginning
  179. How to divide a number with "less than" sign? ie: <1/1000 = <0.001
  180. Freefloating?
  181. information between multiple workshheets
  182. TEXT Formula
  183. CONCATENATE
  184. Why are my functions not executing?
  185. Cell Value must be zero
  186. Copy formula with row automatically modified not column
  187. How do I sum here using criteria there?
  188. Correct Count
  189. Lookup expiration dates by calendar month
  190. Where do I find & how do I embed Harvey Balls
  191. Delete duplicate cell
  192. Search one worksheet to pull data into another worksheet
  193. Drop Down list predicated on other drop down lists
  194. RE: formula not working properly
  195. Auto populate
  196. TRIM, LEFT, RIGHT
  197. Concatenating two text strings, formula is right, cell output is w
  198. Need Text columns to pull into subtotal lines
  199. SUMIF
  200. Count problems
  201. Select lowest value from 3 columns
  202. Difference between times. Start time: 11:30PM End time: 5 AM
  203. IF with substraction
  204. Help to calculate Drinking Fountains
  205. Need Formula
  206. Does structure of data affect speed of vlookup?
  207. If Formula
  208. How can I use the SUMIF function using multiple criteria
  209. Prevent refresh in certainpivot tables in workbook
  210. Text box in chart won't appear in print preview
  211. SUMPRODUCT or COUNTIF - Multiple Criteria
  212. How do I format all comments in an Excel worksheet?
  213. Vlookup combined with LEFT function
  214. Paste values only from a pivot but keep the pivot design when pas.
  215. link formulas sheet 1 to same cells for sheet 1,2,3 etc
  216. how do I create a templet?
  217. Automatic email addresses
  218. Button to set different currencies
  219. add two criteria that should not be met to sumproduct
  220. return date from range of dates with if statement
  221. Is there a better way?
  222. SUMPRODUCT NON-CONTINOUS CELL
  223. How do I get a function to execute on a specific date in Excel?
  224. count if the two cells are equal
  225. Help generating score from finishing position
  226. I need to count numbers in cells
  227. Averaging numbers in a column while excluding blank spaces and zer
  228. making NT user/login user appear in a cell
  229. how do I attach spreadsheet in email
  230. RE: Pivot Table Hide Zero Subtotals - Excel 2007
  231. Data Sort
  232. Excel 2003, how to convert gallons to cubic feet?
  233. Time punch data from rows to columns
  234. same range names in different worksheets
  235. How to applying a ratio (whilst keeping total the same!)
  236. Nested If-Then statement with number range.
  237. Realigning
  238. use functions on defined multiple range
  239. What function do I use to subtract two cells in the same row?
  240. Printing cells continuously
  241. summing difference cell values across worksheets
  242. nesting functions
  243. VLOOKUP and #N/A
  244. How can I use the SUMIF function using multiple criteria
  245. OFFSET equation not working
  246. Work center hours
  247. Function writing help
  248. How to get the numbers above and below a number
  249. Can I clear UNDO list?
  250. Splitting cells
  251. How do I use the IF function with info that contains a date?
  252. COUNTIF with multiple text criteria
  253. Counting words in column
  254. if & ands and either indirect or offset - need help fast please
  255. Sumproduct with text values
  256. Critical Counitif formula
  257. Calculating Average Time
  258. Lookup in multple worksheets
  259. Date calculation function?
  260. how to lookup if value exists in a range of data?
  261. Applying formula to variable number of rows
  262. add a row after every unique number
  263. opening new csv file in existing xls file's worksheet
  264. RE: functions similar to filter
  265. insert number or text
  266. (IF FUNTION )HOW TO SHORT THIS FORMULA??
  267. Re: summing the number of dates
  268. RE: summing the number of dates
  269. RE: summing the number of dates
  270. CountIF or COUNTA for specific text
  271. Need fucntion to reference cell on worksheet referenced by known n
  272. IF Function Question
  273. Making User defined functions available in all new workbooks
  274. Sumifs and Countifs
  275. Subtract frim a static total
  276. Set automatic currancy decimal without entering the decimal?
  277. Highlighting matching cells in two different worksheets
  278. Exporting
  279. Date range condition on multiple rows to get a tally
  280. when we open microsoft office excel 2007 it show to fill purduct
  281. Conditional Formatting Text based on a formula
  282. Twin cells
  283. Additions of Round Function and Minus Sign at Once
  284. Autosum automatically enters zero
  285. if every 3rd cell is > 0
  286. Scrolling
  287. How can I calculate Ker and Kei using Excel
  288. Vlookup problem
  289. Ref of First Non blank cell
  290. drop down box
  291. gain and loss
  292. Excel changes spelling of word
  293. how to compare times of events btwn worksheets
  294. How do I multiply (1 cell) times a rge of cells to a rge of cells
  295. Column to row
  296. numbers, text
  297. Erisson FREE Laptop
  298. Sorting Data
  299. Autofilter not allways working Excel 2003
  300. RE: lock cell font
  301. SUMPRODUCT calculating difference between column values
  302. how can I flag the same data from two different column
  303. Excel 2002 Analysis ToolPak Regression Analysis Help Requested
  304. Conditional Formating for dates beyond 30, 60, 90 to be high light
  305. Tabbing Question....
  306. lookup and Replace with value
  307. reference another cell in conditional formatting
  308. Combine the contents of 2 cells
  309. view the formula
  310. RE: value not recognized as a formula
  311. Link to another worksheet
  312. Multiple Columns for SUMIF formula?!?!
  313. Count the number of colored cells in a column
  314. RE: value not recognized as a formula
  315. Return an array of data based on range of date
  316. How do I use DCOUNT with evaluation of multiple columns?
  317. RE: Ignoring formula results of #N/A
  318. Re: Creating a worksheet/template for Mileage
  319. RE: copy a sum in cell on sheet 1 (not formula) to cell on sheet 2
  320. Re: Prompt value in formula
  321. lock cell font
  322. value not recognized as a formula
  323. Summing data between two date criteria
  324. Right function variable length
  325. Ignoring formula results of #N/A
  326. Sort Macro
  327. copy a sum in cell on sheet 1 (not formula) to cell on sheet 2
  328. RE: Arrays and Averages
  329. locate first value greater than
  330. how do I transfer a balance sheet to a worksheet in Excel?
  331. Combo Box
  332. Hlookup & Vlookup
  333. multiple ifs & ands indirect/offset...need help desperately please
  334. CountIf or another function
  335. Insert Named Range Into a Cell
  336. inserting rows affecting formulas on other wkshts
  337. RE: Arrays and Averages
  338. Interpolation within a data table
  339. Arrays and Averages
  340. RE: Prompt value in formula
  341. for Email address format
  342. Query content of merged cells
  343. how do i find the earliest entry in a table
  344. Data Validation for dates
  345. Multiple Sheet copying
  346. how can subtact or add Week 07/2009 in one column & Week 10/2009 .
  347. < > question for multiply cells.
  348. Name Ranges
  349. problem with circular calcs
  350. Re: Table help Please!?!?!?!
  351. Cell Locking Question
  352. QUÉ FUNCIÓN
  353. Combining data from different cells and more...
  354. Help with formula with Named Ranges
  355. how to convert number to text
  356. add on date specfic
  357. Count formula
  358. Date Range Drop Down Menu
  359. workng bet wrksheets
  360. Add certain cells given specific criteria
  361. slecting all entries to appear once
  362. conditional format
  363. Time required to 'save as' a large file
  364. How do I keep a running total of people I contact as a percentage
  365. multiple ifs ands & indirect or offset?
  366. RE: Creating a worksheet/template for Mileage
  367. convert digit to text in excel
  368. Time Completed
  369. how do i unhide a header in excel 2007
  370. IF Function
  371. Countif with a Range of criteria
  372. Condition Format with 2 cell
  373. how to convert number to text
  374. Conditional Formats to Find Words in Text String
  375. RE: sumproduct with text
  376. Count Uniques with a Couple Conditions
  377. Condition Format with value of other column
  378. RE: sumproduct with text
  379. lookup and worksheet name and then do formula
  380. Copy Indirect down a column
  381. sumproduct with text
  382. Count function without double counting
  383. validation list or combo box dependant on cell value
  384. In MS Excel 2003, need to do conditional formating on HLOOKUP
  385. Conditional Formatting
  386. Combinations in a string of data
  387. Working out a capped point score using LARGE function
  388. Excel Formula to calculate wages
  389. countif with multiple conditions
  390. RE: UserForm
  391. How do I add and subtract engineering stations in Excel?
  392. #VALUE! error when trying to add cells (VLOOKUP)
  393. RE: Quick way to "Shrink to Fit"
  394. Hightlighted Worksheets Hard to See
  395. Quick way to "Shrink to Fit"
  396. UserForm
  397. Marking cell; totaling all # between marked cell & next marked cel
  398. Help with IF formula
  399. Excel 2007 Pivottable Rank
  400. how can i reset excel to its default values?
  401. Macro for importing text files but the file name changes
  402. How do I shorten an IF formula?
  403. XIRR Error
  404. COUNTBLANK function when column lenght grows
  405. Count Advanced Filtered Rows
  406. split cell data?
  407. split cell data?
  408. Multiple isnumber
  409. Format for making date calculations
  410. Can system time & date be nested in conditional formula?
  411. help with formula
  412. What is the Qur’ân?
  413. Please - help with formula
  414. If two criteria match then sum matching values in another column
  415. Ignoring dates when calculating differences in time
  416. Minimum without zeros or negatives
  417. I need my template to show more than one months results
  418. Countif against a range of text entries
  419. Histograms
  420. Using Multiple sets of Option Buttons (Form Control) In Excell
  421. How can I display the footer on first page only?
  422. Finding Data
  423. 3d countif
  424. How can I set a limit in a cell
  425. Calendar Control with some VB help required
  426. Automatically Refresh Pivot Table Data
  427. display differences between two worksheets
  428. Re: Format to show leading zero
  429. Re: Format to show leading zero
  430. RE: Format to show leading zero
  431. Re: Format to show leading zero
  432. RE: Format to show leading zero
  433. How to find exact differences between two worksheets
  434. how to change language of Excell 2007 functions
  435. COMPARING TEXT IN A RANGE OF CELLS AND DISPLAY IT IN ANOTHER.
  436. Return sum of values based on lookup-function
  437. reporting newest/highest value
  438. Find second highestsalesprice
  439. Index function
  440. Total of Females in a worksheet
  441. conditonal formatting
  442. Macros 07
  443. Transferring data
  444. help creating a question sheet
  445. rearranging rows from a single column
  446. IF function to grab data
  447. Excel User Form
  448. divide cells
  449. Formula for success... corny I know
  450. triangular distribution
  451. Stumped on adding 3 cells
  452. Relative Link remembers absolute path??
  453. cell reference question
  454. calculate the stdev of an array using text as the criteria
  455. Sum by Cost Center
  456. loading descriptive analysis toolpak-HELP
  457. How can I return zero after a max value has been met?
  458. Lookup value with multipe Results
  459. linked workbook (cells) does not show entire length of original te
  460. automatically populate worksheet
  461. Nesting MATCH functions? Or other solution?
  462. Protection of certain cells or columns
  463. Convert Effective Annual ROR into quarterly ROR
  464. Lumping dates into quarters by year
  465. how do i just print a sheet in excell
  466. Working with worksheet protection
  467. How to calculate the difference between two different times.
  468. How to calculate the difference between two different times.
  469. column width
  470. I have lost the ability to auto Sum...
  471. How do I delete multiple of wooksheets
  472. Time and Vlookup Problem
  473. I have lost the ability to auto Sum my columns....
  474. Changing entire row based on 1 MAX cell value (Conditional Formatt
  475. How do I count a range of dates in a column?
  476. If condition for Blank Cell
  477. if function or lookup??? across a range of cells in a row.
  478. IF Statement
  479. How do I find the cell/data the closest/nearest to another data?
  480. Adding only part of a column
  481. Help With Cell Function
  482. greater/lesser than
  483. Count cells with a date in them
  484. Duplicate files
  485. Advanced Filter for Text String
  486. Change Alignment Defaults
  487. Making a vertical list from a rectangular range, with no empty lines
  488. Excel 2007 - VLOOKUP always returns #N/A
  489. Change operator from cell value
  490. macros
  491. Time function
  492. Time functions
  493. Macros
  494. Print Range Setup
  495. increasing or decreasing a cell
  496. Conditional validation with only two columns
  497. Conditional formatting Max to a entire row A1:D1 with E1 being Ma
  498. fx for vacation
  499. I need a fx for counting numbers between numbers (between 18 - 59
  500. Applying Max Conditonal Formatting to an entire row when condition
  501. Applying Conditional Formatting to a Max number in range
  502. Drop down list from another worksheet
  503. Removing first 10 characters of text
  504. Making a budget
  505. Cell value with multiple values to vlookup
  506. Sum of two offset cells
  507. VBA question
  508. Using list choices to use as headers
  509. Tabbing Question
  510. Finding most recently entered number within a column
  511. Using one sheet to complete information in another sheet
  512. how do you de-dup an address list in Excel?
  513. Linking to pages within a workbook?
  514. How could I return to the first row after I finish the last entry?
  515. VLOOKUP
  516. my vlookup path changes when I open the file
  517. RAND()
  518. Data Analysis Tool
  519. Tabbing Question
  520. decimal values create inequality
  521. 2 Criteria Summing
  522. Conditional Format Font Color for more than 3 conditions
  523. most used value
  524. Formula:
  525. Formulas
  526. Conditional Formatting to Show Red Highlight in Text Field
  527. Hours and minutes
  528. Consistantly average 180 data cells
  529. Inventory Months Supply Question
  530. Pivot Table Field based on two data area fields
  531. sorting 4 columns
  532. "Cannot shift objects off sheet" in Excel when inserting row/col?
  533. Sort by town name, which follows first name and initial; period; andcomma.
  534. What If, Count - totally confused......
  535. Vlookup using concatenated values - Excel 2000
  536. Macro error - cant work it out...
  537. VBA macro pausing
  538. Formula help please!! IF(OR
  539. need to make 4 typical entries regularly in excel
  540. entering formula using cells notation
  541. Simplify this formula
  542. Convert Turn Rate to Weekly Supply
  543. Count numbers of Month in a cell
  544. Drop Down List Question
  545. gain-loss
  546. What Function to use?
  547. SumProduct problem
  548. Excel 2003 Worksheet
  549. Which function do I use?
  550. calculations - table, if, or, >, < etc etc
  551. Matching data in two columns
  552. Questionnaire
  553. Counting cells that contain a substring
  554. Name Sheet Tab to Reflect Edit Date
  555. Function With Lookup
  556. mixing SumIf and Subtotal Functions
  557. Sum within a column, according to another column
  558. SUMIF formula required to search for 2 diff values in 2 diff colum
  559. COUNTIFS-Want to remove several words in one column w/multi criter
  560. How do I save only active worksheet without save all of worksheet
  561. Cross tab table
  562. editable cell in a dropdown list
  563. Copying summed cells
  564. Excel Pivot 2007 Report Format
  565. SUm
  566. Excel 2007 - toolbar for Text to speech
  567. Data Validation Q
  568. how do i set up if cell content repeat, warn given
  569. Auditing excel for everyday tasks
  570. Auditing excel sheets for everyday task
  571. week update formula
  572. count
  573. Return the cell reference of the drop down list selection.
  574. Compare multiple rows for duplicated values in individual columns
  575. Need Help in Excell Formula
  576. PeopleSoft report spits out 1 row into 2 rows -how to make 1 row
  577. how do I get a simple #"123" from 1 2 3 ? Spaces between numbers
  578. I need to create a fill in form
  579. matching or lookup functions
  580. Nested formula to search a text string and return specific text
  581. Re: Extracting row with lagest amount
  582. auto populate different cells when selecting from drop down list.
  583. use check box created in Excel 2003 opened in Excel 2007
  584. Comparing two different columns - looking for similar data
  585. drop-down list
  586. How do I apply a rounding rule
  587. RE: Extracting row with lagest amount
  588. How do I retreive the last # in a column?
  589. RE: Extracting row with lagest amount
  590. copy formula to filtered cells only
  591. Re: Extracting row with lagest amount
  592. Re: Extracting row with lagest amount
  593. Re: Extracting row with lagest amount
  594. Re: Extracting row with lagest amount
  595. XIRR problem
  596. Linking Checkboxes/Drop Down Lists to a Formula
  597. Showing data unigue to multiple columns in a pivot table
  598. Alphanumeric custom formats
  599. if- then statements
  600. Hiding Formulas
  601. Sharing
  602. Need MAX value if condition is met
  603. OMG Help!
  604. 2 formulas in 1 cell
  605. I am getting an error when I try to group data in a pivot table.
  606. Subtotaling
  607. VBA guys needed
  608. How do you easily add rows to check register template
  609. Counting dates
  610. Formula help - rounding up and round down?
  611. Formula help please!
  612. Moving sheets to new books
  613. printing blank forms with auto generated numbers
  614. Add working days to a date
  615. Shortcut key for comma format?
  616. How do I set a start and expiration date using IF function
  617. pick list location
  618. Can selection from text drop-down dictate value in another cell
  619. Sumproduct Subtotal #Value! error
  620. ISERR
  621. how do I format numbers to ordinal i.e. 1st, 2nd etc
  622. Using count function for multiple columns
  623. formulas
  624. VBA - Data Validation (Looking for NERD help)
  625. Combining arrays for a Lookup function
  626. Month
  627. workgroup
  628. RE: count cells, then reset count when value in another cell changes
  629. Re: count cells, then reset count when value in another cell changes
  630. Countif for 2003
  631. How to SUM for indeterminate number of rows?
  632. Moving cells
  633. Formula to a sheet name that is text in another cell
  634. Re: HOW TO FIND A LAST NAME IN COLUMN OF LAST NAMES?
  635. Too many characters in formula?
  636. I want to merge two side by side colomns
  637. how do i make a dobble bar graph
  638. Lookup missing number(s) in column w/blanks & duplicates
  639. Nested if statement or Nested if OR statement
  640. 11 digits
  641. RE: Sum of named ranges conditional to date?
  642. Formula for names
  643. how do i insert roman numberals in the middle of a sentence
  644. Linking value of cell on one worksheet to a column on another work
  645. Formatting a cell to print or not to print
  646. Array Formulas
  647. VlookUp or may be Match Function
  648. Parse A String into Two
  649. Formula help please
  650. Excel: VLOOKUP returns #N/A for a sorted value that exists?? WHY?
  651. Re: CONCATENATE not producing any results
  652. Year or ROI
  653. CONCATENATE not producing any results
  654. Worksheet(s) open to last used row
  655. Sumif on columns with logical answers
  656. How do I set up a multiple condition formula?
  657. Rounding column of #s down so each cell is a multiple of 5
  658. SUMIF to sum multiple columns of data?
  659. Currency formula
  660. Help With Sumif
  661. Date Change
  662. Conditional Formating
  663. Worksheet settings
  664. How can run a macro ( call a macro) on selection of any filtercriteria?
  665. Copying Conditional formating in a List of text and values.
  666. Auto complete
  667. FORMULA
  668. Auto Removal Of Duplicate Rows
  669. Todaysdateminus1and2
  670. problem accessing Pivot table Excel 2007
  671. If Condition Confusion
  672. Long Formula
  673. Formula question
  674. How do I count once, multiple duplicate values?
  675. How do I copy a range of data to another sheet?
  676. Linking worksheets
  677. Nested IF statements
  678. Re: HOW TO FIND A LAST NAME IN COLUMN OF LAST NAMES?
  679. How To Stop Excel Copying Named Functions When A Worksheet Is Copied?
  680. formula question
  681. Delete rows in a workbook that contain the same information
  682. CountIfs
  683. Sorting
  684. Allow for multiple selections from a list
  685. Drop Down Box
  686. Need an Equation
  687. Lookup Problem
  688. frequency function and letters [HOW?]
  689. VLOOKUP question
  690. Function Question
  691. need help with a formula
  692. Looking for an alternate solution
  693. Select used range
  694. Sumproduct and Vlookup
  695. Converting Text to Number
  696. excel 2003 date notification formula
  697. Writing formula to include quote marks in result
  698. joining worksheets
  699. How To Create a Value Based Upon The Contents of A List
  700. Can Sumproduct return Text values
  701. Calculating a percent decrease
  702. Networkdays two years
  703. Conditional Formatting
  704. Data Validation w/an If Statement
  705. How do I lookup from a table
  706. does a value exist in another workbook
  707. Cell formatting won't work
  708. converting text into years
  709. Average
  710. Goal Seek
  711. List of workbook tabs
  712. ~Time Calculation
  713. Need help giving a response a number value
  714. Need a program to make a work shift schedule that is staggerered
  715. Count Numbers
  716. How to extract specific text from a string of characters
  717. Excel 2003: Match Names; View Unfound Matches?
  718. auto extend formulas
  719. TODAY() function problem
  720. Round up
  721. Addition of 2 cells is not correct
  722. Nested IF & MAX Function
  723. AVG or Return 1 value from either of 2 cells if one is blank
  724. Data gathering and reporting
  725. Using = Named range
  726. Correct #N/A Value
  727. Subtotal by 2 different criteria
  728. Subtotal by Month and supplier
  729. Reverse Lookup question
  730. RE: Column and Row labels are numeric
  731. Re: Column and Row labels are numeric
  732. INA help
  733. add color to a cell
  734. Cross matching .
  735. looking for the next value
  736. How do I autosum a filtered column
  737. Re-post as I still can't seem to get this to work 100%
  738. Compare cells in different worksheets
  739. RE: if formula with variables
  740. find a value in a table based on 2 different criteria
  741. Count Unique Values
  742. Vlookup between two sheets
  743. Re: Build a reference to another worksheet from cell values incurrent
  744. if formula with variables
  745. Build a reference to another worksheet from cell values in currentsheet
  746. Templates
  747. Re: db count if...
  748. RE: db count if...
  749. RE: Here again for help
  750. db count if...