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. How to insert formulas from four worksheets into one worksheet
  2. can I use Indirect function within range definitons for names?
  3. how to increment time & subtract time?
  4. open up a pop up window in excel 2007
  5. alphabetical sort
  6. How do I...
  7. lower case to Proper help needed in Excel Office 2007
  8. How do I sum transactions for one bank when 4 banks are listed?
  9. prorate formula
  10. Muliple Worksheet Lookup
  11. VLookup
  12. Desparate..please help
  13. SQL & Like Query function in excel
  14. IF and VLOOKUP functions for a matrix overview
  15. Comparing and removing data in different workbooks
  16. Find last name in multi-part name?
  17. COUNTIF Function
  18. SUM formula not working correctly
  19. Change colour of cells depending on entry in one cell
  20. Loss Run on Excel worksheet......Any Ideas??
  21. Need macro to start at a new line
  22. if vlookup for multiple criteria for vdata validation
  23. formatting of numbers within a string
  24. VLookup
  25. Formulas not working correctly
  26. Find Special Characters
  27. Macro to email worksheet
  28. Visual basic, form does not show date correctly....
  29. VLookup Returning last cell??
  30. Data table setup
  31. Degrees Minutes Seconds
  32. Conditional formatting and IF
  33. conditional format if cell value 0 pattern red value blank nothing
  34. How do I create a formula that continuously numbers my invoices?
  35. locate data from a chart by inserting data into a cell
  36. formatting page with VBA
  37. A Query
  38. Counting function
  39. Is there a way to create a list in excel with smilies instead of .
  40. Multiple Logical Conditions With Date and String Comparison Not wo
  41. EXCEL:Can't open any file without error saying it's ALREADY open???
  42. Column Comparison Trouble
  43. Normalize time series
  44. How can I clear all cells containing #n/a on a spreadsheet?
  45. Excel 2007 Not Responding
  46. Indicator lights
  47. Round formula
  48. Excluding Hidden Rows from calculations
  49. What is the formula behind the VDB function?
  50. How can I dynamically change a file link in a formula?
  51. Excel= can I count how many times letter a appears in 1 cell?
  52. Help please!
  53. Formula problem
  54. Linked workbooks, changing links
  55. finding duplicate cell and deleting both
  56. Excel for calculating stock cover based on a number of months sale
  57. Macro to check data from excel list against access query and return value back to excel
  58. Vlookup problem
  59. Customizing SAP Download in Excel
  60. Forecast v actual - row addition problem
  61. can one delete or change automatic page breaks?
  62. How do I switch from one worksheet to the next without using the .
  63. Conditional Data Validation
  64. Can't link cells between multiple workbooks
  65. Help with a formula
  66. Vlookup a text string
  67. Calculating a complicated formula
  68. Excel - Summing common cell over mutiple sheets within a file?
  69. GETPIVOTDATA
  70. Another formula problem
  71. Tab order help
  72. Dates
  73. Conditional Formatting on a Drawing?
  74. Compare 2 Worksheets and return differences in a third.
  75. DMAX function for Office 2007
  76. How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell
  77. formula Help
  78. Using the returned value to look up an item
  79. Pivot Table Help PLEASE
  80. working out a date for a fixed day of the week
  81. If any 3 of 5 values are 0 then 0.
  82. COUNTIF
  83. Need to update a ComboBox when selecting a sheet
  84. Sread sheet that sorts and totals as you enter new lines
  85. fill column with formula
  86. add 10 days to a date
  87. Rows to repeat at top of each page
  88. COUNTIF & SUBTOTAL
  89. 'if' formula selecting a cell from a table
  90. how do I change cell colour to show function used
  91. ROundup
  92. slide between sheets
  93. 2 Data Validations Q
  94. Rounding
  95. Applying formula on formula
  96. Auto run of macros immediately after opening the files
  97. COUNTIF and leading zeros?
  98. How do I hide a function in formula bar
  99. Calculating/displaying elapsed time TOTALS
  100. commission percentages
  101. How do I create a formula using cells from two different sheets?
  102. Returning a Value from a Table, dependant on the word Typed
  103. Display formulae instead of showing values in cells
  104. Satisfying 2 conditions and lookup from a 3rd column to return a v
  105. Counting fields on criteria in other fields
  106. Help with these formula...
  107. MATCH function not matching as expected
  108. v-look up - no results
  109. Conditional SUM Q
  110. 3601 Too Few parameters Expected 1
  111. IF with Rank
  112. Count number of cells and total in one column, based on another column suffix
  113. multiple entries in the same column in a spreadsheet
  114. if usage based on two ranges NO sum required
  115. Drop Down Menu to display a field of data
  116. consolidate info
  117. How to distinguish zeros ("0") from blank cells?
  118. how to count occurences of word in spreadsheet formula
  119. Add text to cell formulas?
  120. How to format spreadsheets in VB
  121. IF formulas
  122. In Excel trying to reference text that already is in other cells?
  123. Pop up verification when opening a sheet.
  124. Help with Excel problem
  125. Form. to ignore cells w/o value from calc from previous Form.
  126. TABLE function - not recalculating correctly
  127. Formula to return a true blank
  128. cell function to copy contents of another cell
  129. "Rows to repeat at Bottom"
  130. I need to display changing cell values in another cell.
  131. How do I drag a formula keeping cells the same but changing sheets
  132. How do I drag formulas so cells stay the same but sheets change?
  133. using vlookup for more than 1 criteria
  134. advanced find and replace help
  135. formulas
  136. Return 2nd Lowest Value Q
  137. Prevent edit of cells
  138. Naming of column index
  139. Why do I get an error message hiding excel columns
  140. MSN Money Stock Quote Problem
  141. sales reps pricing
  142. help PLEASE Urgent
  143. how to avoid duplicate entries in column
  144. Formulas
  145. Need help doing complicated formula
  146. copying formulas
  147. Automatically pu date when cell is edited
  148. consolidate data
  149. Can I do a mail merge into an excel file from another excel file
  150. Sumif date range
  151. Copy rows if greater than zero
  152. Calculating value less minimum numbers in the sequence
  153. Counting in an array
  154. Sum equal cells
  155. Summing Data Across Tabs
  156. making a # value positive or negative based on contents of another
  157. Logging info from one worksheet to another
  158. i need to extract infromation from other sheets in workbook to ma.
  159. How can I display a batting average as .333 rather than 0.333?
  160. How do I carry page numbers across sheets in Excel?
  161. SumProduct too slow
  162. IF() with #VALUE
  163. Move entire row to another sheet and deleting the old row only.
  164. End function
  165. Do not allow Copy/Paste Functionality in a Protected Sheet
  166. Conditinal Format
  167. Split data from 1 workbook into multiple workbooks based on criter
  168. Updating worksheets from master worksheet based on column value
  169. Excel VBA
  170. Date Range & Difference
  171. Counting Poll Results
  172. What is wrong with this formula?
  173. User Name Automatically Populate
  174. Using the If function for text
  175. Input data in excel
  176. insert row / insert column command buttons
  177. split coloumn
  178. Difference (weekdays) between two dates
  179. I want to count No .of same names in work sheet
  180. Dynamic SUM range
  181. Getting Logged in User Name in formula...
  182. Cursor Movement?
  183. Dates and arrays
  184. HELP with an unorthadox AM schedule
  185. Depreciation Table Formula
  186. Date Function
  187. Beam a file to a device.
  188. Formula, not the result is displayed in calculated cells - why?
  189. Copying Cell Content
  190. Print individual schedule; 1=attend class 0=don't attend
  191. Help needed please
  192. Duplicating rows help needed
  193. SUM if the conditions are met
  194. Select cells after Autofilter
  195. Freeze worksheet?
  196. Change colour in cell
  197. Macro to insert text into empty cell
  198. Entering calendar automatically
  199. copying vlookup
  200. Create a formula with conditions
  201. search across row for nearest value
  202. Time format 1/1/1900 15:20:00
  203. printing without zeros showing in a cell with formulas
  204. Exponential
  205. Cannot Exceed
  206. Copying Conditional Formatting to range of cells
  207. 7 previous days average
  208. match 1 column bringing in a value from another column
  209. Check off Box??
  210. Group data from a table
  211. Help on substitue value, by excel function
  212. Conditional auto printing in excell?
  213. Excel Formular help
  214. Multi thread in Excel
  215. Counting Within a Date Range
  216. Combinations
  217. Sumproduct
  218. IF or Array formula excel .. help !
  219. Consolidate information from Column B Based on Info In Column A
  220. Number counts within Date Range
  221. help with making a function to filter lists
  222. Excel n00b, how to do basic math functions
  223. 2 versions of the same worksheet *.xls:1 & *.xls:2 - Why ?
  224. Loan Amount
  225. find last cell in range with data, display cell address
  226. How can I merge two worksheets together
  227. Summing columns that contain letters
  228. Match a cell to something in a column and return a YES
  229. Hide Cell Information
  230. need help with nested formulas please
  231. Validation - Error message if equals Left formula
  232. Hide n' show cells in protected sheet
  233. Help on VLOOKUP with currencies
  234. How to count a range of number to a given parameter or criteria.
  235. How to do 'Nested' cell references
  236. Largest value cell
  237. Problem formating cells Weine Classification Scheme for library la
  238. How does 1 value affect the average?
  239. Protected sheet, On Enter moves next. Can I stop this?
  240. Frequency Function
  241. Time Formula
  242. Minimum and maximum date lookup
  243. Fun with text functions - search for text
  244. Filling a formula down-need correct cell reference
  245. Lists
  246. Date Formula
  247. Excel Function
  248. Cell Coloring
  249. Formula in DCounta Criteria
  250. Deleting multiple blank rows
  251. Grand totals on another worksheet.
  252. Rounding
  253. formula using dates
  254. Function to find/display the date X number of days later?
  255. Conditional Formating CF (to identify case/strikethro differences)
  256. SumIF for more than one condition
  257. Urgent Help!!!
  258. Dates
  259. formatting cells
  260. Problem of selection.delete
  261. Excel Macro- sort issue in Excel2003
  262. 24 hour time sheet
  263. Excel Formula for equalising stock to sales rate
  264. Excel 2007 - hyperlink to display external data in a pop-up?
  265. Share workbook problem
  266. Stumped - multiple lookup criteria across worksheets
  267. Breaking link within the worksheet
  268. INDIRECT & VLOOKUP functions
  269. Concatenate/ Min-Max
  270. Assign a code to a range of time
  271. Retrieving data based on more than 1 criteria
  272. Autonumbering
  273. sumproduct with multiple tab ranges
  274. Get rid of #N/A when using a vlookup
  275. date reminder
  276. Disable/ignore compatibility check during SaveAs
  277. is there a function like NORMSINV for exponential distribution
  278. Creating a new list of repeating data in a column
  279. Pop up calendar
  280. Worksheet Rank / Lookup function
  281. How to refer to external datasource in Excel domain aggregate func
  282. Functions in a work order
  283. Re: Help with Formula
  284. RE: Help with Formula
  285. Why Subtracting Two Negative Numbers Results in Positive Number
  286. COUNT returning 0?
  287. Unknown formula - not in help
  288. growth function with blanks
  289. Function to treat formula result as blank cell
  290. Lookup and Populate
  291. IF THERE ARE 9 P AND 5 A IN A ROW THEN HOW TO CALCULATE
  292. Splitting a Worksheet into Multiple Sheets
  293. Counting number of occurrences.
  294. I need to change hardcoded background color
  295. Security Excel
  296. Ref a Cell, but only certain values within Q
  297. Locked somehow
  298. Calculating Salary based on Date Range
  299. array table and vlookup
  300. DCOUNT Unique Values
  301. Link transposed data from one sheet to another for DB purposes
  302. calculating step values between 2 numbers
  303. why is it that the Share Workbook command is greyed out?
  304. STDEV of visible cells in a column
  305. get max or min number
  306. How matchup many IDdata- find matched IDdata in long columns
  307. how do I substitute text in Excel?
  308. Average of cells in a column
  309. VLOOKUP Question
  310. date validation
  311. Excel Function
  312. Filtering options are not available.
  313. Splitting a file with lookup functions into smaller parts
  314. Find
  315. Hyperlinks
  316. Custom Data Validation : Lock if MyCell = ""?
  317. Date Validation
  318. How do I display the most recent "modified" date in Excel sheets?
  319. Trying to put a dash- in my formula to separate a number&name
  320. PIVOT TABLE WITH BLANK CELLS
  321. Vesting Formula
  322. vlookup and sumproduct combine issue
  323. Check for duplicates?
  324. calcutale 2 date with round date
  325. ip address
  326. Hyperlink based on cell value in a different worksheet
  327. If\then statements in Excel
  328. workday with month functions
  329. keyboard shortcut for a macro
  330. Simple links in Excel 2007
  331. Link between workbooks within Server 2003
  332. SNMP functions?
  333. Locking cells
  334. Neative Formula
  335. Cell Data
  336. Can I generate a mX+c Trendline Formula without a graph
  337. MID formula question
  338. count all the text in red
  339. How to remove empty spaces in a cell with numbers?
  340. Which function to calculate a 401k rate of return?
  341. Excel formula
  342. Help with IF Function
  343. moving data depending on criteria
  344. VLOOKUP Copy/Paste Problem
  345. Color fill cells to be added into totals
  346. Hide menu bar control
  347. auto decimal in currency
  348. Dates formula
  349. Conditional w/ arrays
  350. When typing dates do not default to current year.
  351. Hide Negative Numbers or Display as Zero
  352. Adding workdays as part of the equation
  353. Conditional formula
  354. Simple Sum function question
  355. Sumif question - I think?
  356. How do I make this work? =IF(C11=TEXT,D11,D11-C11)*24
  357. MAX function
  358. need second answer to question posted yesterday (niek Otten)
  359. Need second answer new question niek otten
  360. Worksheet created in Office 2000 - updated computer to 2003
  361. Converting Older Dates to Current Year
  362. Please can someone look at question i posted yesterday
  363. Use both ISNA and ISERROR in a long formula
  364. how to input the data as per the quantity
  365. Merge 2 excel worksheets into one and remove duplicate entries.
  366. why can i paint a cel?
  367. Harlan - or anybody good at math
  368. Is there a way to have a timer or stopwatch function in Excel.
  369. display number in form of words
  370. vlookup or sumproduct formula for 2 columns data validtion
  371. Help with Pivottables - Excel 2003
  372. Can I write "=AVERAGE(B51:B65005)"
  373. New Service in Finland
  374. #ref appears when selecting cell in other worksheet
  375. VLOOKUP
  376. Median in pivot tables
  377. range names to cell references
  378. PARTIAL TEXT MATCH SEARCHING FOR THE FIRST 6 CHARACTERS?
  379. how can i have one cell always go up 1 number?
  380. How to undo the same document opening twice :1 and :2?
  381. Count Instances of value in two columns
  382. Count items by day
  383. Hidden sheet problem
  384. Excel 2007 Pivot Table - Group Field function is not always availa
  385. Help with Data Validation
  386. extact text string from specific cell except three last characters
  387. Lookup on two fields ....if here do this if not do that?
  388. How to alter comments in a locked cell ?
  389. Vlookup Problem
  390. Defining a custom-named Range across several worksheets
  391. Link Complete Sheet
  392. Array vocabulary
  393. absolute reference
  394. lookup
  395. calculate hours without negative
  396. Vlookup - Month Instead of Day
  397. sumproduct & dates
  398. iterations?
  399. Lookup price formula
  400. Excel 2007
  401. Midnight will not display in cell
  402. Date Function
  403. Closing excel
  404. Current date in the comment instead of the user ID
  405. vlookup, if ??????
  406. How do I count the number of cells with blue shading in Excell?
  407. Help with handling large amounts of data - determine "MIN IF" ?
  408. Numbers to Text
  409. Converting a formula for automatic formatting criteria
  410. proposal for cafeteria
  411. formula to insert a row of consective numbers in a columm (1tru 5
  412. Counting Occurences Between Dates
  413. referring to previous worksheet in workbook
  414. Need Formula
  415. Need rolling summary of data
  416. Works spreadsheet-find circular ref.
  417. N/A results on vlookup with time calculations
  418. Apply names to relative references
  419. Calculation value displays in formula
  420. Sheet name needed for formula
  421. Tab Button
  422. column width will not adjust
  423. hyperlink, macro, stored procedure?
  424. How do I create a floating column?
  425. Using myval as counter twice HELP
  426. macro
  427. How do I calculate the date an employee will reach a specific age?
  428. How to index every line
  429. Date query
  430. Update 2000 Excel hyperlinks to 2003 hyperlinks
  431. If function
  432. Insert rows: Formats & formulas extended to additonal rows
  433. Excel - stop automatically changing mixture of uppercase and lowercase to propercase
  434. Adding New Row to Excel Spread Sheet
  435. Comment boxes are shrinking and "disappearing"
  436. Excluding only leading or trailing cells from a column
  437. Pivot table hierarchy question
  438. Cell Entries show as decimal
  439. Sorting problem
  440. vlookup() error #n/a
  441. Credit Cards, time in months to payoff and payoff amount
  442. Copy cell to another cell using Macro
  443. EXCEL macro that will vary when copied
  444. Exponential equations
  445. pop up box
  446. Vlookup = #n/a to be ""
  447. warning box
  448. Need help sorting DATES please..
  449. Vlookup to transform columns to rows
  450. answer =850*77.1 formula in excel 2007 is 100000 , WHY?
  451. Count occurences and return total
  452. How can I check whether a column of dates are all before today's d
  453. How can I check whether a column of dates are all before today's d
  454. Comparing two columns of dates
  455. grouping help!!!!!!!
  456. Search for rows in one sheet and copy into another sheet based on customer id
  457. negative numbers
  458. Trim hidden characters?
  459. Data from 3 wsheets into billing invoice wsheet
  460. Name Generator
  461. Type a cost code in one cell and discription in an other
  462. Excel 2007 - Pivottable formula with COUNT
  463. Total time vs hours per shift
  464. find cell with matching text, then reference cell in same row
  465. Countif problem.
  466. Result set from SUMPRODUCT function
  467. How do I flag duplicate addresses
  468. Excel 2003 "VLOOKUP" function
  469. Convert Multiple Text entries...
  470. Taking out Emptys
  471. Adding Text to Answer
  472. border
  473. What would the formula be for...
  474. How do I copy a row depending on the content of a cell in the row
  475. Count formulas between excel files
  476. Search list for non-alpha characters
  477. Combining (nesting) 2 formulae
  478. Requiring data in certain cells
  479. I need to add columns at the end of a worksheet,
  480. Indirect function result in #REF
  481. formula to find how many cell have a number between 2 numbers.
  482. Preview Entire Workbook
  483. If statement
  484. How do I stop a file from opening in muliple windows?
  485. Yet Another 'INDIRECT' Question
  486. Max absolute number
  487. On change of key
  488. If and value between two numbers
  489. Averaging data if within a date range
  490. Problem with data validation
  491. Nested formula using WORKDAY function
  492. Displaying insignificant numbers in a cell
  493. To find duplicates in XL sheet?
  494. i can not copy and paste a photo in excel 2003
  495. Simple interest
  496. Serial number generate
  497. Circular Reference
  498. Count and/or sum data within a date span.
  499. Is it possible to create a VLOOKUP formula based on an ActiveX con
  500. nested Cell("contents", w/ cell contents reference)
  501. Automatic update of footer macro
  502. auto add data with addition of new worksheets
  503. Subtracting days from cells
  504. Random sort function for text
  505. I want to use a different cell if my date field is NULL/BLANK
  506. SUM one column based on another column repeatedly
  507. is there an easier/faster way to do what I'm doing in 3 steps
  508. SUMIF function #VALUE! error links
  509. Compare a Worksheet to another Worksheet.
  510. Save Random Number
  511. How do I protect a text box, but allow entry of data
  512. 2 IF statements looking at two cells
  513. how do I do this: today minus hire date equals how many years mo.
  514. trailing spaces
  515. Graphs - Y Axis Labels
  516. I have never been able to get a SumProduct formula to work..Help!
  517. How do I insert pages numbers in Excel 2007 worksheets
  518. Clearing out blank rows/columns
  519. Dividing hours between working weeks
  520. macro to hide data (with conditional formatting?)
  521. Help with =IF(SUM(G64:G69)<0,SUM(B64:B69),"")
  522. Max function with conditions
  523. Comparing one column of names to another
  524. How to run macro automatically from range of cells
  525. Why doesn't this work?
  526. Compare and Filter Out Large Database
  527. Conditional formatting of cell
  528. Conditional Formatting
  529. how to apply absolute cell referencing to multiple cells at once?
  530. Counting yes/no votes
  531. FILTER FUNCTION DOES NOT SHOW TOTAL RECORDS SELECTED
  532. PLEASE HELP URGENT
  533. Data Validation - Calculated Error Title
  534. lookup error???
  535. Count if not a number
  536. how to make a macro to clear multiple cells from multiple worksheets?
  537. Changing sheet reference to cell reference
  538. Summing all numeric values only in cells in a column
  539. 16-jul-07 date format to sum at quarters see example
  540. OFFSET Range
  541. Validation,........how to use a list in another sheet
  542. Result of a formula in another cell
  543. Receiving #VALUE! when using examples from Microsoft Excel, why?
  544. Graphs
  545. datedif function
  546. SUMIF formula
  547. Sum data, depending on cell content
  548. value of a cell / expression is a whole number
  549. FIND MULTIPLE TEXT FROM DATA
  550. Find the 10 lowest of 20 numbers in column and enter those 10 in a
  551. change text format to time
  552. How to use a UDF (module) across many users (embedd in worsheet)
  553. Lookup function (i think)
  554. Formatting of all sheets at a time
  555. Find a cell in skeleton data sheet
  556. Schedule
  557. Refer to Previous or Next Sheet
  558. Jeopardy
  559. Logical test on linked data
  560. Autofilter and count on filtered data
  561. Cross Reference Table Data Searching
  562. {SUM(IF((ARRRAY FORMULA)}
  563. assigning # to day
  564. Macro HELP PLEASE
  565. Conditional format if cell does not display a blank
  566. Help - Function Count, but on dates not numbers
  567. Create a simple average that does NOT include blanks cells
  568. How to embed font/size changes within Excel formula
  569. trying to create a worksheet....
  570. HELP! with long function
  571. Concatinating text plus cell containing date
  572. VLOOKUP may be?
  573. Text to equation??
  574. Imported data
  575. FIND MULTIPLE TEXT FROM DATA
  576. databases
  577. Pivot Table: Variance formula
  578. large combine max fuction issue
  579. SHARING WORKBOOK
  580. Validate Sku No in Sheet 1 against Sheet 2
  581. MACRO SAVE HELP
  582. rounding absolute zero
  583. Average not including Zeros/Blanks
  584. How do I count the number of cells highlighted a certain color?
  585. Sort Data Cross Tabs
  586. Hosur an IT hot spot?
  587. Diagonal and upwards transposing
  588. Vlookup function 2003
  589. sorting ranges with open ends
  590. How retain calculated value in a cell despite changes to inputs
  591. format a column with a function
  592. Can I create a multiple LOOKUP formula with 'then' function???
  593. Excel workbook
  594. cell pattern depening on cell content
  595. Countif function
  596. Zero's, Rounding, and Hiding
  597. Split a text
  598. Changing - to ()
  599. rounding dates
  600. Is there a way to count cells in a range with a given backcolor?
  601. Multiple LOOKUP in EXCEL
  602. doubleclick in cell to open link - how
  603. Most functions do not work and return #Name?
  604. TO Average Previous values
  605. Parseing to produce text only
  606. nested function
  607. Budget Spread methods
  608. Excel 2007 :Standard Footer
  609. CountA, Subtotal and "move to the first cell in the next column"
  610. Vlookup using dates in the lookup range
  611. Date Formula
  612. Conditional Formatting
  613. Viewing same cells at the same time in two sheets
  614. match and insert from one workbook to another
  615. Count if function
  616. Custom Number Format
  617. SUMPRODUCT not working.
  618. Macro
  619. How do I retreive a replaced excel workbook?
  620. Problem using filter property
  621. formula to find a value
  622. I have misplace my Excel 2003, 25 digit code, how do I get a repla
  623. Retrieving Stock and Mutual Fund Quotes
  624. Match Date/Time to Date list
  625. excel formula
  626. Adding columns to an Excel matrix and listing them in the PT
  627. Unwanted dash
  628. Ranking without preset Excel function.
  629. Help - Column D is missing.
  630. i need to generate a "distance" graph given x and y locations
  631. Nested if help....
  632. Deleting numerical values within a cell
  633. daily cash report
  634. Do I need to use 'IF' function?
  635. More MIN() results..?
  636. Looking up data in different sheet
  637. Find and Delete Row
  638. how do i count amount of data in a filtered list?
  639. Keep Values and Formulas
  640. Sorting / Numbering problem
  641. HELP: Averaging values if they meet certain criteria
  642. How do I find in Excel 2007 the Command Show Outline Symbols
  643. Find max value in one column and return the value of corrosponding cell in different column
  644. Conditional Formatting to Lock Cells
  645. how can figures in different worksheets can be added?
  646. Reference to a cell returned by MIN...how?
  647. complicated excel formulas
  648. Re:Zero problem
  649. Hello
  650. Lookup and Name cells
  651. date from multiple worksheets
  652. Calculating time as a percentage
  653. Sum column of vlookup
  654. =A(B2) isn't working
  655. Why doesn't my Excel '03 let me use brackets for negative numbers
  656. hardcode a column in a formula
  657. Macro needed for assigning serial numbers
  658. CREATING A FORMULA
  659. Formula
  660. Hide a row using Visual Basic
  661. Formulas
  662. Random Numbers???
  663. Top Ten highlights all
  664. Using Linest cannot get seb to work?
  665. SW STAT+
  666. How do I get rid of squares substituting as spaces in excel?
  667. Locking all but a few cells on a worksheet
  668. Best 8 from 11 results Formula Please
  669. What function does ^ perform in a formula
  670. Need SQL reference
  671. Counting based on criteria from two cells???
  672. Formula
  673. Setting formulas to pull data from a specific character spacing...
  674. Restricting Access to Parts of worksheet
  675. Conditional formatting to ignore zeros
  676. How can I enter a 'tick' automatically in a box.
  677. Formula gone bonkers!
  678. Ranges and Arrays in Excel VBA
  679. Grid
  680. List cell content without duplication or blanks
  681. What does ^ do in a formula?
  682. finding the maximum number of used cells in any column of a table
  683. Template to convert column of text to time
  684. Formula giving wrong result
  685. Help, Excel Files Being Wiped Out: Data Lost or Corrupted
  686. Invoicing using excel macro
  687. VLOOKUP, INDEX, or ....?
  688. Row to work sheet
  689. MIN with name_range?
  690. How do I calculate a person's age on a specific date? (huge roster
  691. Count Functions
  692. Check Boxes
  693. Smart calculations with Excel?
  694. how do i set up a work in progress report for a construction compa
  695. How to make a space
  696. Name Range
  697. Name Range
  698. Text to columns question
  699. Excel Mail merge two word
  700. Displaying formulas
  701. how insert printed pages counter
  702. Extending Sort Range
  703. Grading Values
  704. #DIV/0! Error......why is it ignoring the ' Otherwise "" ' ?
  705. Watch NFL Games Online
  706. Pivot Table-two tables same data, can I used the same page control
  707. Option Buttons from the Forms Toolbar - Excel 2003
  708. Match Cells, and Sum Data
  709. HOW TO FORMAT ANOTHER CELL
  710. SUMIF with two or more variables
  711. Function based on multiple criteria from two cell references
  712. scrolling table
  713. How do I set up a formula to calculate a bonus?
  714. lookup with multiple condition, but one condition to satisfy is en
  715. formatting in worksheets
  716. sumproduc
  717. vb cording with excell
  718. Date function in ACCRINTM requires date format not available
  719. Adding Fractions of a Second
  720. how to get the random date between the start date and the end date?
  721. Formula to group First/Last names 2 one cell
  722. Pivot Table 2003 - Creat a column using absolute cells o/s the tab
  723. Number Order
  724. countif function using dates
  725. Calculating the run rate
  726. keyboard shortcut for "paste special....."?
  727. How to insert tab name of a wrksht into a cell in that worksheet?
  728. Is there an icon to use showing visible cells only?
  729. If Sheet1 column is marked complete, display entire row on Sheet2?
  730. Sumproduct Question
  731. E-mail one sheet
  732. functions for if
  733. SPREADSHEET VIEW
  734. Sum If Formula with 3 criteria
  735. Matching Formula ??
  736. Matching Formula ??
  737. Help w/ a formula
  738. Percentrank function display
  739. Adding Cells that Contain Text
  740. Using VBA
  741. Datedif doesn't work the same in Excel 2007
  742. LOOKUP return the value from the previous row
  743. Sum same cell from all sheets
  744. Counting unique values by date
  745. Calculation using result from Index/Match
  746. Subtracting one list from another list
  747. I thought I would use FORECAST, but maybe I am wrong...
  748. conditonal formatting in VB
  749. Change Format from Number to Percentage (sounds easy enough)
  750. Data Validation
  751. Data Validation
  752. Calculate Start Date
  753. can i convert my excel tab into a word document?
  754. Worksheet fails to filter at times
  755. VLOOK UP
  756. GEOMEAN
  757. Find minimum value in column.
  758. Lookup with Multiple results
  759. Adding Tags to file names
  760. Comparing two columns and finding matching names
  761. Counting cells with text not listed.
  762. using multiple vlookups confusion
  763. Conditional Formatting Formula
  764. Can't find hidden worksheet xlsVeryhidden
  765. Integrate OFFSET, INDIRECT and VLOOKUP?
  766. Can Database Function Criteria be a Date?
  767. Please help macro for save
  768. Vlookup based on date specified
  769. take values from column A for values>0 in column B
  770. Display contents of cell based on criteria
  771. DATE Question
  772. link excel to automatically update mailbox calendar when you upd.
  773. Informational Search
  774. How do I call up the Text Import Wizard via a macro.
  775. Highlite from A2 to Last Fred then to Column G
  776. Find DMIN in a column range determined by a number in another cell
  777. Array formulas help needed
  778. Breaking down an excel formula
  779. Look up question
  780. Formula for selecting the second row down (Not necessarily row "2"
  781. what is the formula for rounding time up to 1/4 hr?
  782. If statement help
  783. Count or Sum ?
  784. how do you flip the order of the content in a cell.
  785. Percentrank Function
  786. Conditional Formatting Dates calculating 10 days and 30 days from a certain date
  787. Trying to SUM cells with links.
  788. normal into Capital letters automatically
  789. Summing dynamic range
  790. How do I convert time?
  791. PROBLEM WITH INDIRECT & VLOOKUP FORMULA
  792. Adding button to worksheet to refresh pivot table data
  793. Create refresh button in worksheet to refresh Pivot Table Data
  794. HYPERLINK Worksheet Function
  795. Which function? Biggest distance to the Nearest city ...
  796. IF
  797. how do I increase the length of a drop down list?
  798. sum values from the listed sheets
  799. Data Validation List content controlled from cell
  800. Counting a range to see if it encompasses a given date
  801. Leveling Methods
  802. how to put quotation mark in each cell of the column
  803. Variables in formulas
  804. find the last Fred and goto cell
  805. Sum,
  806. Data Validation Blank Cells
  807. Routine with fuzzy logic to determine the relative comparison of two strings?
  808. percentage
  809. Matrix
  810. Split surname from end of name data
  811. SumProduct & Countif?
  812. Randomly sorting an Excel spreadsheet
  813. XIRR formula in non-normal struction
  814. justify text into multiple rows
  815. Office 2007-How do I copy a worksheet from one workbook to another
  816. IF statement - multiple scenarios
  817. Sorting a Pivot Table Column that is not the first column...
  818. update linked spreadsheets w/o recreating links
  819. IF statement to long, an easier way?
  820. IF formula
  821. a list of all macros and their key combinations?
  822. Counts for Excel 2003 using multiple criteria
  823. IF Formula
  824. Create graph if value is greater that zero
  825. insert another page into an existing one
  826. carrying previous totals from one worksheet to another.
  827. Function for euro number format?
  828. Find cells with data.
  829. Error message
  830. Excel equation explanation
  831. OR & IF functions
  832. How to format a date as text?
  833. Using Text to Columns with a function
  834. display a range of cells editible cells based on matching date
  835. CORREL formula work on multiple dependents
  836. Lookup Multiple Criteria
  837. IF Function
  838. How I prevent a "0" when a linked cell is empty?
  839. "Sumif" on multiple values
  840. "Conditional" sum
  841. Summerising data
  842. fromatting not possible on the cells
  843. #VALUE! error
  844. Worksheet name
  845. Max Values
  846. Rankings
  847. Need to IMPORT a Worksheet From another WorkBook
  848. Display top rankings
  849. Trying to display the number between two numbers closest to another value
  850. What is the correct formula for IF C5 = Y, then L5 *.06?
  851. How do I do IF C5=y, then L5*.06 ?
  852. PH Stat
  853. How to display running-down numbers with total count?
  854. HOW DO I COPY ALL DATA (INC COMMENTS)FROM 1 WORKBOOK TO ANOTHER
  855. Excel 2007 calculation bug fix
  856. Needing to rank values
  857. need Excell to display something other than what I type
  858. Re: Excel2003 use fnct/conditnl fmt, copy color&Val from ref cell
  859. Custom Colors
  860. "Too many arguements for this function"....ohh noooo....
  861. compareing 2 columns
  862. how do i set up an income and expenditure account in excel?
  863. How can I compare data between two different sheets for changes?
  864. Sum-if-product
  865. Time formulas
  866. Combining 2 IF statements to make one formula.
  867. I want to double click a box and have an X inserted there?
  868. formula pulling data based on 1 input on another tab.
  869. How do I create a list in excel 2007?
  870. Find a value and count the rows back to the reference row.
  871. Find Smallest and Largest.
  872. Find the Longest Run.
  873. Complex Summing probably using Match at some point...
  874. Count based on multiple criteria
  875. today as a function of the year to date
  876. Sumif
  877. Button to open JPG (Hyperlink)
  878. I can't insert a worksheet into my current spreadsheet file
  879. Combined ROUNDUP
  880. Formula that will record the time and date when an entry is made on a sheet
  881. general number format and VLOOKUP
  882. Help! How do I return the latest of a series of dates using Vlooku
  883. DCOUNTA WITH MULTIPLE FIELD CRITERIA
  884. COUNT formula help
  885. Excel2003 use fnct/conditnl fmt, hw cpy clr frm anthr source text
  886. Excel2003 use fnct/conditnl fmt, hw cpy clr frm anthr source Text
  887. IF formula help..
  888. Alternate row shadding even when rows are hidden
  889. extract text from string
  890. Excel Formula Help
  891. Sumproduct
  892. Macro REQ: Automatically copy a template sheet and rename
  893. Create a "Send" button
  894. finding, sorting, put only part of a cell
  895. Pivot Table Template
  896. Subtotals of repeating set of data
  897. Simple Formula Help?
  898. e-mails addresses
  899. how do I extend sub-columns into one long row?
  900. Losing previous highlighted columns when doing multiple column hi.
  901. Is it possible in Excel to have a file auto delete on a given dat.
  902. como convertir numero de una celda, en el mismo numero-texto en o.
  903. IF(ISTEXT Concatenate formula question
  904. copy in filter mode
  905. Compare/Find Exact Date match with varying time
  906. Text to columns
  907. How to: Find first empty cell in column
  908. Adding ISERROR to formula
  909. How many different numbers in an array
  910. What does it mean when excel says "too many cell formats"?
  911. Hyperlink auto-population? Please Help
  912. CONVERT ROMAN TO ARABIC NUMERALS
  913. Data Sorting Query
  914. How do I get ending figure in proper cell?
  915. Pictures adding & removal
  916. HOW DO I COPY A TOTAL FIGURE FROM 1 SHEET TO NEXT ADDING RUNNING T
  917. Conditional Formatting - further assistance required
  918. IF(ISBLANK) with other criteria
  919. Error handling VLOOKUP. #N/A - can it be 0 to allow sumation.
  920. Copy and Replicate exact formulas
  921. how do i calculate least-square regression analysis?
  922. Search and go to cell
  923. Compare two wk sheets with common data using copy paste macro
  924. Automatic calculation
  925. If statement that returns data in a cell if False.
  926. Excel 2007 Default Font
  927. vlookup or other?
  928. How do I display number into form of text or word?
  929. Refer upper field
  930. formulas
  931. Counting occurences of a name
  932. Lookup value in range, then if that value is something do a calculation.
  933. How do I round a number after finding the average?
  934. editing formula no longer outlines ranges
  935. Date
  936. Annuity Formula
  937. Conditional Format - MIN, IF statements
  938. How do I set up a daily call out response response register?
  939. Vlookup Returns Wrong/No Data
  940. calculating the probablity of HBsAg contamination
  941. excel: if selected, copy cell from corresponding row
  942. Possible 2007 Bug: Match()
  943. Excel question.
  944. Urgent! I am in dire trouble - boss says it can be done - How?
  945. formula to calculate a specific percent of a column of different p
  946. Finding a charcter in a text string
  947. Running a macro from an auto-refresh
  948. Insert a letter in front of number in every cell?
  949. Find and Replace
  950. How do I Get rid of Excel extra left margin filter drop down box
  951. Link
  952. The Columns...HELP!
  953. excel 2000 problem
  954. Pictures in Cells
  955. Is there a keyboard shortcut for using Paintbrush?
  956. MIN and MAX across columns
  957. If And Calcuation
  958. Formatting the =NOW() function ?
  959. Subtract a max value from a row then copy that columns title?
  960. formula
  961. set a permentant print area in a multi-sheet workbook
  962. Some sort of Lookup?
  963. #Value! Keeps appearing
  964. Match Field Data
  965. Array to find relative position - is there a better way?
  966. Excel 2003, how can I show my entire drop down list under file?
  967. Lenght of a decimal part of a number.
  968. Finding MIN value in a column between Two Dates in different columns
  969. Auto fill cells in other tabs from one master tab and protect them
  970. SUMPRODUCT With External Range Name?
  971. Formula Countif Index Match
  972. Protecting sheet that has macro
  973. Formatting A Cell
  974. Comparing two worksheets
  975. Automatically insert rows with formula
  976. Is there formulas which set text to equal a number?
  977. SIMPLE QUESTION need fast answer please
  978. Cell formatting
  979. No return for formula
  980. search array
  981. If ,AND, LOOKUP, Functions
  982. benefit from microsoft excel
  983. HOW CAN I FORMAT COLUM B TO UPDATE DAYS DELIQUENT DAILY
  984. High = 4 take 2
  985. High = 4
  986. How do I convert my old linked spreadsheets to MS2007?
  987. How to send automatic email when cell value changes in excel
  988. Pareto Chart
  989. Date Formula
  990. Function Help
  991. Add text to meet criteria
  992. Stop rows that i have hidden unhidding when i filter in excel
  993. Is there a function/formula to retrieve the weeknumber?
  994. Text to dictate colour of the cell and/or row
  995. How to use Drop down list to reflect a set of fields to be filled?
  996. Pivot table grouping question
  997. «æ! ¤â¾÷²M³f5§é°_
  998. can worksheet names be changed by changing certain cells?
  999. VLOOKUP
  1000. Microsoft Excel cannot find data you are searching for