PDA

View Full Version : 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 | 

  1. Macro assistance
  2. Date/Time concatenation
  3. Nested If Statements
  4. Expanding Grouped Rows when sheet is Protected
  5. If statements query
  6. Data merging with 2 worksheets
  7. Sort automatically
  8. If A1 = 4, cut and paste a2:a227 to a specific worksheet
  9. vlookup 2 arguments
  10. Count every group of numbers whose sum is zero & put formula next toeach number
  11. Refresh pivot table in workbook A when changing a cell in workbook
  12. How do I do A repeated measures ANOVA on Excel 2007???
  13. Euroconvert function in Excel 2000 returns a #NAME?
  14. MOREFUNC
  15. Summing based on values in other worksheets
  16. Comparing Excel Dates
  17. Re: Outline/group data below
  18. #DIV/O! Error
  19. Making COUNTIF update in real time
  20. Whats wrong with this function?
  21. Conditional Formatting
  22. Formula/Function for Counting Characters in a cell
  23. Return 3D array?
  24. Linking cells within workbook with ALL formating
  25. basketball bracket
  26. Even or Odd Year Function
  27. Sum of total from other worksheet with that meets one criteria
  28. Attach code
  29. Function to count clock reaching 24 hours
  30. Cell not showing all letters in text
  31. How do I delete a Hyperlink in a cell
  32. Concatenate With Criteria
  33. Pivot Table multiple grand totals
  34. Wrong output returned during IF function
  35. Vlookup to find a match in a string
  36. DATE AND TIME CONVERSION HELP
  37. format ?
  38. Concatenate: in an IF Function
  39. Clear contents of cells if a condition is met
  40. Mystery links in a shared workbook
  41. Counting if a time is within a specified range
  42. Lookup closest to
  43. Nesting Functions
  44. Match consolidate multiple rows data into one row
  45. command line options/switches to print excel file
  46. Lookup Value from Table erratic
  47. Doubt on Functions Index and Match
  48. Formula to identify text into columns
  49. call external function
  50. how do I get color to show on desktop
  51. How do you wrap larger quantites of text?
  52. Excell 2007, Page Problem
  53. checkbox in dropdown question
  54. alternate for Trace precedent
  55. Re: slecting all entries to appear once
  56. SUMPRODUCT
  57. random cell selection from a column of cells
  58. Add data if column Match
  59. sum inaccurate
  60. Sorting
  61. Import File Data
  62. Who's up for a Challenge?
  63. creating a drop down box using names from a different workbook
  64. Conditional Hide
  65. Using the OFFSET function within SUMXMY2
  66. comparing two columns for partial values
  67. how to run a command from a cell
  68. nightmare formula
  69. Matching !!
  70. How do I count the number of items that meet 2 criteria?
  71. Formula Question for Excel 2003
  72. excel 2007 developer tab
  73. How to password Protect when WORKSHEET is Very HIDDEN
  74. Lookup and find all to sum results in another column
  75. Pivot table refresh problem
  76. Displaying Multiple Values without using Macros or ROWS function
  77. How do I make mouse scroll wheel work in excel
  78. Excel sum with variable start column
  79. I would appreciate some help with a formula
  80. HOW TO COMPARE THREE NUMBER AND USE THE HIGHER NUMBER IN A FORMUL.
  81. countif only when an exact match occurs
  82. How to make Friday as weekend instead of Sat/Sun in Workday Functi
  83. #NAME error with Workday function
  84. Function to change $1,000.00 into One thousand dollar
  85. i want to assign a cell to save a worksheet
  86. Excel worksheet
  87. Friday as weekend instead of Saturday & Sunday
  88. Pivot Table Percentage of Sub-Total
  89. How to apply date range criteria
  90. using Spell check on protected sheet
  91. Vlookup
  92. DUE DATE FORMULA QUESTION
  93. Conditional Formatting
  94. Having problems with formula nested tables in Excel
  95. Excel 2007 - not updating formulas
  96. keeping initial zeros
  97. INDIRECT Help
  98. How do I create a formula that references a specific tab in Excel?
  99. Complex Formula Help Required
  100. Calculating combination of text occurances
  101. text size in embed cell
  102. How do I unlock excel worksheet with lost password?
  103. Outline/group data below
  104. VLOOKUP Function to return values in multipal Columns
  105. Protect Sheet but allow pictures
  106. Username in path
  107. Formula Request
  108. Quintile Returns
  109. How do I round a formula result to the next integer?
  110. Last Value in a Range
  111. Sorting a worksheet with multiple columns
  112. I need the percentage of objects used in a drop-down box
  113. Undo and redo no longer work. how can I fix this. Excel 2003
  114. Help with Index/Match function or similar
  115. selecting randomly specific value in a list
  116. Estimates
  117. Sum a value
  118. Making name of worksheet a function
  119. Activate cell in protection mode
  120. convert formal from excel to access
  121. Drop Down based on a condition
  122. Count text on certain date
  123. Insert Sheet
  124. Using a worksheet function to create an unusual cell reference pat
  125. EXCEL 1997 FORMULA QUESTION
  126. Isolate text in a long url
  127. Monthly Breakdown
  128. match or lookup
  129. Match or Look up
  130. Can I sort data used in formulas on a different workbook?
  131. I am getting incorrect answers in adding and subtraction
  132. Force required entry in cell before leaving that cell
  133. use v lookup from a drop down list
  134. autoupdate a reference to a cell on another worksheet
  135. How do I reverse tabs and worksheet from reading right to left?
  136. Need to count on two columns
  137. Locating a Worksheet from another Workbook
  138. Vlookup Offset help
  139. RE: Addition of identical numbers to cells with different values.
  140. LAST TIME, Adding in multiple numbers
  141. Complicated If Function Question
  142. Average of difference between dates greater than zero
  143. Zero in cell where it is linked to a blank cell
  144. Another Hyperlink question
  145. adding in multiple numbers when on cell is Blank
  146. AVERAGESIFS Function - average cells that fall within a date rangeand meet additional criteria
  147. Excel
  148. Using validation and a default value
  149. click on a cell to make an object appear
  150. Function Question
  151. Hyperlink cell references
  152. Formatting Part of Text String a Different Size
  153. multiple sheet macro
  154. Function to determine current cursor position?
  155. SumProduct
  156. Excel 2007 - Conditional Formatting Problem with Percentages
  157. Copy rows between different sheets if condition met
  158. Help required on week function
  159. INDIRECT and ADDRESS
  160. Add date condition
  161. relative offset to a named cell
  162. How to change text in cell when entering "Y"
  163. Lookup / Match ?
  164. countif number of nights not days using dates
  165. How do I create startup boxes that once answered appear in a form
  166. VBA Combo-Box
  167. Count no of nights between dates
  168. Lookup
  169. countif when the criteria is a formula
  170. URGENT lookup Problem
  171. Header/Footer Date Format
  172. Multiple Sheets / Pivot
  173. need help with custom validation drop down lists.
  174. vlookup and #n/a due to formatting
  175. unsnap
  176. What kind of formula would I use for an annual amount for rent?
  177. Change 18-digit dec number to hex
  178. How do I change default font/pitch of text in Excel's comments?
  179. Page Break View
  180. Sorting data linked to other spreadsheets
  181. help with complicated formula
  182. Adding entry in one cell to a running total in another cell
  183. Conditional Formatting - Number Format
  184. help with choosing formula
  185. Dates not showing up as dates
  186. VLOOKUP values
  187. I need to evalute two cells and return a result
  188. CPSCount
  189. Formula needed: argument changes as more data is added
  190. Formula not working, help
  191. week number
  192. SUMPRODUCT with trying to create array of non-blanks
  193. char(10) and double quotes
  194. Conditional Formatting Between Worksheets
  195. Formula needed
  196. validation - list option
  197. Worksheet Lists
  198. Length of Employment
  199. 1st name last name to last name, 1st name
  200. sumproduct alternative
  201. Uploading reports into excel
  202. Converting date to text
  203. Unique Counting With Multiple Criteria
  204. Is this possible
  205. Counting dates
  206. Searching sheets
  207. Error message 'This book has been made exclusive by jdoe'
  208. Average top third with criteria
  209. I want excel to input data in a cell from multiple cell choices
  210. Keeps grabbing more than one cell/column
  211. Cumlative Counting Question
  212. Sumproduct Help
  213. Need help for macro
  214. Rounding to nearest 250 by 125s
  215. Conditional Formatting
  216. IF and Round
  217. sheet 1 to sheet 2 conditional
  218. Sorting a Workbook w/ Links
  219. Help with Array Formula
  220. drop down lists
  221. If formula with two condition
  222. diferent names
  223. Filling down text in increments of three
  224. I CANNOT HIDE COLUM & I GOT ERROR MASSAGE "CANNOT SHIFT PBJECTS O.
  225. Storing an array in a cell
  226. rows and columns
  227. MYSTERY: NESTED INDEX AND MATCH FUNCTIONS
  228. Simultaneous calls
  229. Formula Help to Extract Partial Data from a String
  230. Concatenate a date and name
  231. Lookup function
  232. Excel Formulas (Insert Define Name)
  233. Last Saved By
  234. Checking a cell's format in a function
  235. Min+Max from other Tabs
  236. Remove an extra space after a number.
  237. NETWORKDAYS
  238. Count if statement
  239. DAYJOB KILLER presents GOOGLE SHADOW
  240. Help with formula
  241. date formula issues
  242. Date functions
  243. Incrementing cell references slower than by 1
  244. VLOOKUP issue with #N/A - linked workbook
  245. If Then Formula Question
  246. COUNTIF STATEMENTS
  247. How do I join 3 separate columns of dates
  248. HOW CAN I COMBINE SUBTOTALS?
  249. Disappearing text in Callouts Excel 2007
  250. Map of used names?
  251. Searching quicker within long dropdownlist
  252. Has SORT changed from 2003 to 2007?
  253. Formula question
  254. Password protected macro
  255. VLOOKUP
  256. Automatic Email forward error
  257. Excel 2003
  258. OT : Does anyone know of support groups for the ERP called IFS
  259. can excel add worksheets based on cell population in another works
  260. Second item in list using array
  261. Data Validation
  262. Adding extra criteria
  263. Questionnaire
  264. Counting characters
  265. Excel formula is calculating wrong total number on some of cells
  266. Reformattng EMAIL addresses incolumn
  267. Variable sum from defined input
  268. Worksheet Jump
  269. Extract Worksheet Title/Refence
  270. In Pivot table sort
  271. Calculating Annual % Increase that occurs mid month
  272. TIMECALC Formulas
  273. transfering information
  274. I asked for the maximimum value in a colum how can I highlilight
  275. delete cells column. Delete empty cells
  276. combine if(and statement
  277. vlookup?
  278. cumulative
  279. How to capture Username into specific cells
  280. Sumproduct or Countif - Counting Occurances within a Date Range
  281. sorting data in another sheet
  282. Linking Tabs w/ formulas
  283. Lookup Data based on 2 search criteria
  284. Yet another question about my timesheet
  285. Trouble with a Formula I need help with???
  286. Error when using Yield in Excel 2007 VBA
  287. Sheet to Sheet info transfer
  288. How do I create a "SUMIF" based upon a Date Range?
  289. How do I round times to 15 minute increments?
  290. Amount with two conditions
  291. if Functions
  292. Convert number to Million Currency format
  293. COMBIN
  294. Reference the 2nd and 3rd highest in range.
  295. Excel Time
  296. FORMULA READING DATA FROM PIVOT TABLE TO SPREADSHEET
  297. Text with repeating trailing spaces
  298. If formula
  299. How do I paste in sorted area?
  300. How do I keep my formatting when linking cells in diff. sheets?
  301. sum daily production data to monthly
  302. If function with text & wildcards
  303. Excel forumulas not recalculating
  304. conditionally format cell in a range, based on value in other rang
  305. Work Sheets with Dates
  306. Conditonal formatting
  307. Formula for multiple cells if they say a certain thing
  308. "="preceding text
  309. Data entry on filtered rows.
  310. Negative Dates and/or Times
  311. How can I assign button/buttons to XL 2007 by Macro for different
  312. How to use "OR"
  313. VLOOKUP
  314. Excel 2007 - If function meeting two criteria
  315. Formulas
  316. SELECT DUPLICATE IN SELECTION
  317. printout with auto date
  318. Passing data to fix cell
  319. I really need help with a rule
  320. How to appy the formular with different cell parameters~kindly hel
  321. Greater than AND Less than Time Q
  322. limit number of rows in worksheet from 6000+ to 600
  323. Is this even possible??
  324. Scoring rank change and corresponding point difference
  325. disappearing spreadsheets
  326. How do I print the data stored in my Excel database?
  327. Inerting name of current worksheet into fuction
  328. Extend search results in a form
  329. Complex problem in Lookup
  330. Friday as weekend in Workday Function
  331. Elapsed Time Formula
  332. Print Area as dynamic range?
  333. Parse cell contents to new columns
  334. Cell reading Balanced problem
  335. Need macro to post data from user input
  336. Download #1: World's Major Stock Exchanges Tracker Chart
  337. lunch break!! well..how to figure
  338. how to insert tally mark in excel
  339. sort not working
  340. Think I need an Array; not sure
  341. Nested Formula
  342. how to stop array from superimposing itself over excel 2007 worksh
  343. 2 validation lists for the same value on another cell
  344. subtracting 2 dates and put the result in difference in months ?
  345. data entry problems in excel
  346. Kakuro Killer Sudoku solving formula
  347. How to get the cell reference of the value selected from name list
  348. How do I add an equals sign to a cell that already has numbers in
  349. How to check whither a text is existed
  350. How do I create a list that will copy the entire row?
  351. Excel Formulas
  352. Compare & highlight changes between two worksheets?
  353. VALUE ERROR RETURNED FROM FORMULA
  354. Inserting and Deleting Rows in Excel
  355. Formula to create a list of people who qualify
  356. Seeing only answers in Google group -- no questions
  357. Coppy formula using OFFSET
  358. Determine year over year date for comparison
  359. Excel hyperlink to another open Excel file - wants to reopen file
  360. Alternative to the limitations of the 'IF' function in Excel?
  361. Combine Pivot tables - confused about 'how-to'
  362. Formula for adding values that have a letter at the end in Excel 2
  363. How do I add sequential numbers to existing data in excel?
  364. count nonblank cells with conditions
  365. greater than forumla
  366. Excel formula
  367. Satisfying Multiple Criteria in an "IF" Function
  368. Mercantile Plumbing calcs
  369. COUNT
  370. How to create daily calendar for reservations ?
  371. Need a total count for various numbers in a column
  372. IS BLANK checking 2 Cells
  373. combine multiple workbooks? overcome 255 character limit?
  374. Protect
  375. least prefix matching in a lookup list
  376. lookup (match?) & average
  377. Delta E(cmc) formula
  378. Summing multiple validated sheets into a summary sheet
  379. Negative number format
  380. BLANK CELL
  381. Nested if statements
  382. date range
  383. Display number only if entered in a cell
  384. Summing values for split groups
  385. How can I create a button in Macro (2007 XL)
  386. Cell Protection
  387. Avoid #div/0!
  388. How do I collapse rows in Excel?
  389. Match !
  390. calender
  391. leve chart
  392. Excel Template (Creating a Function in the template)
  393. Excel template Help
  394. what is the best way to learn MACRO for MS-Excel
  395. Macro / function text time to 24hr excel time passed midnight fortotaling hr's
  396. Formula help
  397. The formula works if I copy from Auckland Kilometres
  398. How to determine the cell location?
  399. How can I reformat all comments to a larger font?
  400. Countif
  401. Combining all tabs into 1 master w/o copy&paste
  402. Return 0 when if statement with VLOOKUP returns#N/A
  403. SUM function on multiple worksheet
  404. COUNTIF FUNCTION
  405. Eliminate Negatives
  406. Formula and worksheet will not working properly
  407. How do I get a macro or excel function copy a value on date
  408. Copy formula question
  409. copy paste to first first open row
  410. how do I delete a new window in excel?
  411. Match !
  412. alpha characters in a formula
  413. Formula help again, Please
  414. Average Times by Possible Named Ranges
  415. What formula do I use?
  416. function doesn't run, just returns function
  417. How do I use functions that I have written in Excel formulas
  418. ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH
  419. Multiple conditions
  420. COUNTIF
  421. Counting unique text that meets several criteria
  422. can I use information from another sheet modify it, into a formula
  423. vlookup
  424. Formula to count based on multiple criteria fields w/duplicates
  425. Rounding formula when using conditional formatting?
  426. Formula needed for counting
  427. Conditional Protection question
  428. Calculating hours
  429. TAB out of a combo box
  430. Formatting string in groups of letters...
  431. Non-actual external links remain
  432. "Delocalized" date format
  433. How do I write an "if" formula??? See below......
  434. R4 ds/dsi firmware-drivers de R4 Sdhc. R4 ultra, R4 new, R4 III upgrade, R4 v3
  435. sheetname
  436. rounding
  437. Sumproduct with filters
  438. Arknavn
  439. Conditional Formatting in Excel 2007
  440. pivot table
  441. Return the logarithm stats for a line of best fit
  442. Formula - Budgeting
  443. Editing Weekly Inventory
  444. Count unique values across two columns with multiple conditions
  445. count number of unique values in column
  446. Searching for a string of text inside a column
  447. Sumproduct thru blank cells
  448. expand alist of time stamps
  449. Populate days of the month in a column by checking on date
  450. How to calculate run rates in sales for last 6 months with excel
  451. Delete colomns and rows
  452. multiple formual'a that equal the same thing
  453. FILTERS
  454. Need LOOKUP to find the number above not below the specified numbe
  455. Predefined Cell Character Length
  456. Advance Filter
  457. Comparing two spreadsheets with pricing information
  458. Omitting blank cells until filled in?
  459. I can't get the lower margin to zero in Excel
  460. Equation...help needed!
  461. Using COUNT for text occurances in unusual worksheet?
  462. highlight cell
  463. Copy and paste
  464. COUNTIF(range,>=range_name)
  465. HELP PLOTTING
  466. How do I find a macro in Excel?
  467. Limitation to % of column in PT?
  468. Formula assitance needed
  469. Excel Formula Help
  470. refresh advance filters
  471. How to calculate # of days
  472. function stumped
  473. how can i set up changing invoice numbers in excel?
  474. "If" function question
  475. function question
  476. Calculation completion date/time
  477. Date Calculation
  478. Custom number format via formula
  479. Link updates Excel 2007
  480. count of max occcurances
  481. Cursor to upper left of frozen cells (in macro)
  482. Lookup and return range of values
  483. IF Statement calculating Average if you have numeric & text respon
  484. Evaluating more than 30 conditions using a formula
  485. how i do this in EXCEL
  486. Using Match to find value on worksheet
  487. Index Match
  488. Function to extract data from a list
  489. How can we run FIFO Inventory in excel?
  490. FICA Formula
  491. I want to help you pass your Microsoft certification exams.
  492. value vs formula
  493. multiple formula's in one row
  494. Entering 6 digit numbers into a cell with zeros at the beginning
  495. How to divide a number with "less than" sign? ie: <1/1000 = <0.001
  496. Freefloating?
  497. information between multiple workshheets
  498. TEXT Formula
  499. CONCATENATE
  500. Why are my functions not executing?
  501. Cell Value must be zero
  502. Copy formula with row automatically modified not column
  503. How do I sum here using criteria there?
  504. Correct Count
  505. Lookup expiration dates by calendar month
  506. Where do I find & how do I embed Harvey Balls
  507. Delete duplicate cell
  508. Search one worksheet to pull data into another worksheet
  509. Drop Down list predicated on other drop down lists
  510. Auto populate
  511. TRIM, LEFT, RIGHT
  512. Concatenating two text strings, formula is right, cell output is w
  513. Need Text columns to pull into subtotal lines
  514. SUMIF
  515. Count problems
  516. Select lowest value from 3 columns
  517. Difference between times. Start time: 11:30PM End time: 5 AM
  518. formula not working properly
  519. IF with substraction
  520. Help to calculate Drinking Fountains
  521. Need Formula
  522. Does structure of data affect speed of vlookup?
  523. If Formula
  524. How can I use the SUMIF function using multiple criteria
  525. Prevent refresh in certainpivot tables in workbook
  526. Text box in chart won't appear in print preview
  527. SUMPRODUCT or COUNTIF - Multiple Criteria
  528. How do I format all comments in an Excel worksheet?
  529. Vlookup combined with LEFT function
  530. Paste values only from a pivot but keep the pivot design when pas.
  531. link formulas sheet 1 to same cells for sheet 1,2,3 etc
  532. how do I create a templet?
  533. Automatic email addresses
  534. Button to set different currencies
  535. add two criteria that should not be met to sumproduct
  536. return date from range of dates with if statement
  537. Is there a better way?
  538. SUMPRODUCT NON-CONTINOUS CELL
  539. How do I get a function to execute on a specific date in Excel?
  540. count if the two cells are equal
  541. Help generating score from finishing position
  542. I need to count numbers in cells
  543. Averaging numbers in a column while excluding blank spaces and zer
  544. making NT user/login user appear in a cell
  545. how do I attach spreadsheet in email
  546. Data Sort
  547. Excel 2003, how to convert gallons to cubic feet?
  548. Time punch data from rows to columns
  549. same range names in different worksheets
  550. How to applying a ratio (whilst keeping total the same!)
  551. Nested If-Then statement with number range.
  552. Realigning
  553. use functions on defined multiple range
  554. Pivot Table Hide Zero Subtotals - Excel 2007
  555. What function do I use to subtract two cells in the same row?
  556. Printing cells continuously
  557. summing difference cell values across worksheets
  558. nesting functions
  559. VLOOKUP and #N/A
  560. How can I use the SUMIF function using multiple criteria
  561. OFFSET equation not working
  562. Work center hours
  563. Function writing help
  564. How to get the numbers above and below a number
  565. Can I clear UNDO list?
  566. Splitting cells
  567. How do I use the IF function with info that contains a date?
  568. COUNTIF with multiple text criteria
  569. Counting words in column
  570. if & ands and either indirect or offset - need help fast please
  571. Filter or Query Between Worksheet
  572. Sumproduct with text values
  573. Critical Counitif formula
  574. Calculating Average Time
  575. Lookup in multple worksheets
  576. Date calculation function?
  577. how to lookup if value exists in a range of data?
  578. Applying formula to variable number of rows
  579. add a row after every unique number
  580. opening new csv file in existing xls file's worksheet
  581. insert number or text
  582. functions similar to filter
  583. (IF FUNTION )HOW TO SHORT THIS FORMULA??
  584. CountIF or COUNTA for specific text
  585. summing the number of dates
  586. Need fucntion to reference cell on worksheet referenced by known n
  587. IF Function Question
  588. Making User defined functions available in all new workbooks
  589. Sumifs and Countifs
  590. Subtract frim a static total
  591. Set automatic currancy decimal without entering the decimal?
  592. Highlighting matching cells in two different worksheets
  593. Exporting
  594. Date range condition on multiple rows to get a tally
  595. when we open microsoft office excel 2007 it show to fill purduct
  596. Conditional Formatting Text based on a formula
  597. Twin cells
  598. Additions of Round Function and Minus Sign at Once
  599. Autosum automatically enters zero
  600. if every 3rd cell is > 0
  601. Scrolling
  602. How can I calculate Ker and Kei using Excel
  603. Vlookup problem
  604. Ref of First Non blank cell
  605. drop down box
  606. gain and loss
  607. Excel changes spelling of word
  608. how to compare times of events btwn worksheets
  609. How do I multiply (1 cell) times a rge of cells to a rge of cells
  610. Column to row
  611. numbers, text
  612. Erisson FREE Laptop
  613. Sorting Data
  614. Autofilter not allways working Excel 2003
  615. RE: lock cell font
  616. SUMPRODUCT calculating difference between column values
  617. how can I flag the same data from two different column
  618. Excel 2002 Analysis ToolPak Regression Analysis Help Requested
  619. Conditional Formating for dates beyond 30, 60, 90 to be high light
  620. Tabbing Question....
  621. lookup and Replace with value
  622. reference another cell in conditional formatting
  623. Combine the contents of 2 cells
  624. view the formula
  625. RE: value not recognized as a formula
  626. Link to another worksheet
  627. Multiple Columns for SUMIF formula?!?!
  628. Count the number of colored cells in a column
  629. RE: value not recognized as a formula
  630. Return an array of data based on range of date
  631. How do I use DCOUNT with evaluation of multiple columns?
  632. RE: Ignoring formula results of #N/A
  633. RE: copy a sum in cell on sheet 1 (not formula) to cell on sheet 2
  634. lock cell font
  635. value not recognized as a formula
  636. Summing data between two date criteria
  637. Right function variable length
  638. Ignoring formula results of #N/A
  639. Sort Macro
  640. copy a sum in cell on sheet 1 (not formula) to cell on sheet 2
  641. RE: Arrays and Averages
  642. locate first value greater than
  643. how do I transfer a balance sheet to a worksheet in Excel?
  644. Combo Box
  645. Hlookup & Vlookup
  646. multiple ifs & ands indirect/offset...need help desperately please
  647. CountIf or another function
  648. Insert Named Range Into a Cell
  649. inserting rows affecting formulas on other wkshts
  650. RE: Arrays and Averages
  651. Interpolation within a data table
  652. Arrays and Averages
  653. for Email address format
  654. Query content of merged cells
  655. how do i find the earliest entry in a table
  656. Data Validation for dates
  657. Multiple Sheet copying
  658. Prompt value in formula
  659. how can subtact or add Week 07/2009 in one column & Week 10/2009 .
  660. < > question for multiply cells.
  661. Name Ranges
  662. problem with circular calcs
  663. Cell Locking Question
  664. QUÉ FUNCIÓN
  665. Combining data from different cells and more...
  666. Help with formula with Named Ranges
  667. how to convert number to text
  668. add on date specfic
  669. Count formula
  670. Table help Please!?!?!?!
  671. Date Range Drop Down Menu
  672. Add certain cells given specific criteria
  673. workng bet wrksheets
  674. slecting all entries to appear once
  675. conditional format
  676. Time required to 'save as' a large file
  677. How do I keep a running total of people I contact as a percentage
  678. multiple ifs ands & indirect or offset?
  679. convert digit to text in excel
  680. Time Completed
  681. how do i unhide a header in excel 2007
  682. IF Function
  683. Creating a worksheet/template for Mileage
  684. Countif with a Range of criteria
  685. Condition Format with 2 cell
  686. how to convert number to text
  687. Conditional Formats to Find Words in Text String
  688. RE: sumproduct with text
  689. Count Uniques with a Couple Conditions
  690. Condition Format with value of other column
  691. RE: sumproduct with text
  692. lookup and worksheet name and then do formula
  693. Copy Indirect down a column
  694. sumproduct with text
  695. Count function without double counting
  696. validation list or combo box dependant on cell value
  697. In MS Excel 2003, need to do conditional formating on HLOOKUP
  698. Conditional Formatting
  699. Combinations in a string of data
  700. Working out a capped point score using LARGE function
  701. Excel Formula to calculate wages
  702. countif with multiple conditions
  703. RE: UserForm
  704. How do I add and subtract engineering stations in Excel?
  705. #VALUE! error when trying to add cells (VLOOKUP)
  706. RE: Quick way to "Shrink to Fit"
  707. Hightlighted Worksheets Hard to See
  708. Quick way to "Shrink to Fit"
  709. UserForm
  710. Help with IF formula
  711. Marking cell; totaling all # between marked cell & next marked cel
  712. Excel 2007 Pivottable Rank
  713. how can i reset excel to its default values?
  714. Macro for importing text files but the file name changes
  715. How do I shorten an IF formula?
  716. XIRR Error
  717. COUNTBLANK function when column lenght grows
  718. Count Advanced Filtered Rows
  719. split cell data?
  720. split cell data?
  721. Multiple isnumber
  722. Format for making date calculations
  723. Can system time & date be nested in conditional formula?
  724. help with formula
  725. What is the Qur’ân?
  726. Please - help with formula
  727. If two criteria match then sum matching values in another column
  728. Ignoring dates when calculating differences in time
  729. Minimum without zeros or negatives
  730. I need my template to show more than one months results
  731. Countif against a range of text entries
  732. Histograms
  733. Using Multiple sets of Option Buttons (Form Control) In Excell
  734. How can I display the footer on first page only?
  735. Finding Data
  736. 3d countif
  737. How can I set a limit in a cell
  738. Calendar Control with some VB help required
  739. Automatically Refresh Pivot Table Data
  740. display differences between two worksheets
  741. How to find exact differences between two worksheets
  742. Format to show leading zero
  743. how to change language of Excell 2007 functions
  744. COMPARING TEXT IN A RANGE OF CELLS AND DISPLAY IT IN ANOTHER.
  745. Return sum of values based on lookup-function
  746. reporting newest/highest value
  747. Find second highestsalesprice
  748. Index function
  749. Total of Females in a worksheet
  750. conditonal formatting
  751. Macros 07
  752. Transferring data
  753. help creating a question sheet
  754. rearranging rows from a single column
  755. IF function to grab data
  756. Excel User Form
  757. divide cells
  758. Formula for success... corny I know
  759. triangular distribution
  760. Stumped on adding 3 cells
  761. Relative Link remembers absolute path??
  762. cell reference question
  763. calculate the stdev of an array using text as the criteria
  764. Sum by Cost Center
  765. loading descriptive analysis toolpak-HELP
  766. How can I return zero after a max value has been met?
  767. Lookup value with multipe Results
  768. linked workbook (cells) does not show entire length of original te
  769. automatically populate worksheet
  770. Nesting MATCH functions? Or other solution?
  771. Protection of certain cells or columns
  772. Convert Effective Annual ROR into quarterly ROR
  773. Lumping dates into quarters by year
  774. how do i just print a sheet in excell
  775. Working with worksheet protection
  776. How to calculate the difference between two different times.
  777. How to calculate the difference between two different times.
  778. column width
  779. I have lost the ability to auto Sum...
  780. How do I delete multiple of wooksheets
  781. Time and Vlookup Problem
  782. I have lost the ability to auto Sum my columns....
  783. Changing entire row based on 1 MAX cell value (Conditional Formatt
  784. How do I count a range of dates in a column?
  785. If condition for Blank Cell
  786. if function or lookup??? across a range of cells in a row.
  787. IF Statement
  788. How do I find the cell/data the closest/nearest to another data?
  789. Adding only part of a column
  790. Help With Cell Function
  791. greater/lesser than
  792. Count cells with a date in them
  793. Duplicate files
  794. Advanced Filter for Text String
  795. Change Alignment Defaults
  796. Making a vertical list from a rectangular range, with no empty lines
  797. Excel 2007 - VLOOKUP always returns #N/A
  798. Change operator from cell value
  799. macros
  800. Time function
  801. Time functions
  802. Macros
  803. Print Range Setup
  804. increasing or decreasing a cell
  805. Conditional validation with only two columns
  806. Conditional formatting Max to a entire row A1:D1 with E1 being Ma
  807. fx for vacation
  808. I need a fx for counting numbers between numbers (between 18 - 59
  809. Applying Max Conditonal Formatting to an entire row when condition
  810. Applying Conditional Formatting to a Max number in range
  811. Drop down list from another worksheet
  812. Removing first 10 characters of text
  813. Making a budget
  814. Cell value with multiple values to vlookup
  815. Sum of two offset cells
  816. VBA question
  817. Using list choices to use as headers
  818. Tabbing Question
  819. Finding most recently entered number within a column
  820. Using one sheet to complete information in another sheet
  821. how do you de-dup an address list in Excel?
  822. Linking to pages within a workbook?
  823. How could I return to the first row after I finish the last entry?
  824. VLOOKUP
  825. my vlookup path changes when I open the file
  826. RAND()
  827. Data Analysis Tool
  828. Tabbing Question
  829. decimal values create inequality
  830. 2 Criteria Summing
  831. Conditional Format Font Color for more than 3 conditions
  832. most used value
  833. Formula:
  834. Formulas
  835. Conditional Formatting to Show Red Highlight in Text Field
  836. Hours and minutes
  837. Consistantly average 180 data cells
  838. Inventory Months Supply Question
  839. Pivot Table Field based on two data area fields
  840. sorting 4 columns
  841. "Cannot shift objects off sheet" in Excel when inserting row/col?
  842. Sort by town name, which follows first name and initial; period; andcomma.
  843. What If, Count - totally confused......
  844. Vlookup using concatenated values - Excel 2000
  845. Macro error - cant work it out...
  846. VBA macro pausing
  847. Formula help please!! IF(OR
  848. need to make 4 typical entries regularly in excel
  849. entering formula using cells notation
  850. Simplify this formula
  851. Convert Turn Rate to Weekly Supply
  852. Count numbers of Month in a cell
  853. Calculat an expiration date
  854. Drop Down List Question
  855. gain-loss
  856. What Function to use?
  857. SumProduct problem
  858. Excel 2003 Worksheet
  859. Which function do I use?
  860. calculations - table, if, or, >, < etc etc
  861. Matching data in two columns
  862. Questionnaire
  863. Counting cells that contain a substring
  864. Name Sheet Tab to Reflect Edit Date
  865. Function With Lookup
  866. mixing SumIf and Subtotal Functions
  867. Sum within a column, according to another column
  868. SUMIF formula required to search for 2 diff values in 2 diff colum
  869. COUNTIFS-Want to remove several words in one column w/multi criter
  870. How do I save only active worksheet without save all of worksheet
  871. Cross tab table
  872. editable cell in a dropdown list
  873. Copying summed cells
  874. Excel Pivot 2007 Report Format
  875. SUm
  876. Excel 2007 - toolbar for Text to speech
  877. Data Validation Q
  878. how do i set up if cell content repeat, warn given
  879. Auditing excel for everyday tasks
  880. Auditing excel sheets for everyday task
  881. week update formula
  882. count
  883. Return the cell reference of the drop down list selection.
  884. Compare multiple rows for duplicated values in individual columns
  885. Need Help in Excell Formula
  886. PeopleSoft report spits out 1 row into 2 rows -how to make 1 row
  887. how do I get a simple #"123" from 1 2 3 ? Spaces between numbers
  888. I need to create a fill in form
  889. matching or lookup functions
  890. Nested formula to search a text string and return specific text
  891. auto populate different cells when selecting from drop down list.
  892. use check box created in Excel 2003 opened in Excel 2007
  893. Comparing two different columns - looking for similar data
  894. drop-down list
  895. How do I apply a rounding rule
  896. How do I retreive the last # in a column?
  897. copy formula to filtered cells only
  898. XIRR problem
  899. Extracting row with lagest amount
  900. Linking Checkboxes/Drop Down Lists to a Formula
  901. Showing data unigue to multiple columns in a pivot table
  902. Alphanumeric custom formats
  903. if- then statements
  904. Hiding Formulas
  905. Sharing
  906. Need MAX value if condition is met
  907. OMG Help!
  908. 2 formulas in 1 cell
  909. I am getting an error when I try to group data in a pivot table.
  910. Subtotaling
  911. VBA guys needed
  912. How do you easily add rows to check register template
  913. Counting dates
  914. Formula help - rounding up and round down?
  915. Formula help please!
  916. Moving sheets to new books
  917. printing blank forms with auto generated numbers
  918. Add working days to a date
  919. Shortcut key for comma format?
  920. How do I set a start and expiration date using IF function
  921. pick list location
  922. Can selection from text drop-down dictate value in another cell
  923. Sumproduct Subtotal #Value! error
  924. ISERR
  925. how do I format numbers to ordinal i.e. 1st, 2nd etc
  926. Using count function for multiple columns
  927. formulas
  928. VBA - Data Validation (Looking for NERD help)
  929. Combining arrays for a Lookup function
  930. Month
  931. workgroup
  932. count cells, then reset count when value in another cell changes
  933. Countif for 2003
  934. How to SUM for indeterminate number of rows?
  935. Moving cells
  936. Formula to a sheet name that is text in another cell
  937. Too many characters in formula?
  938. I want to merge two side by side colomns
  939. how do i make a dobble bar graph
  940. Lookup missing number(s) in column w/blanks & duplicates
  941. Nested if statement or Nested if OR statement
  942. 11 digits
  943. Formula for names
  944. how do i insert roman numberals in the middle of a sentence
  945. Linking value of cell on one worksheet to a column on another work
  946. Formatting a cell to print or not to print
  947. Array Formulas
  948. VlookUp or may be Match Function
  949. Parse A String into Two
  950. Formula help please
  951. Excel: VLOOKUP returns #N/A for a sorted value that exists?? WHY?
  952. Re: CONCATENATE not producing any results
  953. Year or ROI
  954. CONCATENATE not producing any results
  955. Worksheet(s) open to last used row
  956. Sumif on columns with logical answers
  957. How do I set up a multiple condition formula?
  958. Rounding column of #s down so each cell is a multiple of 5
  959. SUMIF to sum multiple columns of data?
  960. Currency formula
  961. Help With Sumif
  962. Date Change
  963. Conditional Formating
  964. Worksheet settings
  965. How can run a macro ( call a macro) on selection of any filtercriteria?
  966. Copying Conditional formating in a List of text and values.
  967. Auto complete
  968. FORMULA
  969. Auto Removal Of Duplicate Rows
  970. Todaysdateminus1and2
  971. problem accessing Pivot table Excel 2007
  972. If Condition Confusion
  973. Long Formula
  974. Formula question
  975. How do I count once, multiple duplicate values?
  976. How do I copy a range of data to another sheet?
  977. Linking worksheets
  978. Nested IF statements
  979. How To Stop Excel Copying Named Functions When A Worksheet Is Copied?
  980. formula question
  981. HOW TO FIND A LAST NAME IN COLUMN OF LAST NAMES?
  982. Delete rows in a workbook that contain the same information
  983. CountIfs
  984. Sorting
  985. Allow for multiple selections from a list
  986. Drop Down Box
  987. Need an Equation
  988. Lookup Problem
  989. frequency function and letters [HOW?]
  990. VLOOKUP question
  991. Function Question
  992. need help with a formula
  993. Looking for an alternate solution
  994. Select used range
  995. Sumproduct and Vlookup
  996. Converting Text to Number
  997. excel 2003 date notification formula
  998. Writing formula to include quote marks in result
  999. joining worksheets
  1000. How To Create a Value Based Upon The Contents of A List