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. find number in a row
  2. Excel: Which numbers in a column equal a certain number (withou.
  3. Answer in Red in =IF function
  4. Recommend books
  5. Deleting rows programmatically
  6. Time entries
  7. what should i use
  8. Explanation Relative/Absolute Cell Reference
  9. Incorrect Japanese guidance with Excel 2003
  10. Help with a formula for concatenate and search/find with 3 columns
  11. Help with a formula involving 3 columns
  12. Text & Numbers problem
  13. Sorting Columns
  14. turning numbers into other numbers
  15. DAY FUNCTION
  16. Adding a date and time
  17. How do I automatically format subtotals in excel?
  18. help with formula
  19. how do I divide or multiply an entire column?
  20. copy link from next worksheet
  21. Help inserting a Cell Value in a Text Cell
  22. Excel 2000 Auto Save
  23. How do I create a report to monitor monthly utilities
  24. ques
  25. Calculated Field in Pivot Table
  26. Getting "printer not installed" when trying to edit page setup
  27. vba excel
  28. Formula bar disapeared !
  29. Vat input
  30. =IF logical test to search only part of a cell
  31. Hyperlinks using R[1]C[1] and offset function in its cell referenc
  32. How to identify source or location of MAX_VALUE in range
  33. MATCH function
  34. How do I protect cell formulas used for daily counts?
  35. formula for workbook showing daily income compared to goal income.
  36. How do I automatically hide columns in a worksheet based on a cell value?
  37. How do I set up a drop-down menu/list in Excel?
  38. Autofil color to a row from dropdown list choices
  39. vlookup
  40. increase increment
  41. need a formula to copy entire row to next worksheet
  42. Is there a function to show future date
  43. Increment a counter in Excel
  44. Less than Greater than function
  45. PRINT SPREADSHEET ON 1 PAGE LEGIBLY
  46. how do I convert a date and time column to a time column
  47. Auto Adjust Spread Sheet so it will print on 1 page/legal/landscap
  48. Sum of rows does not tie to sum of columns
  49. Countif Function with and Statement
  50. delete repeating rows
  51. Hiding Personal.xls Requires Exit Twice
  52. Saving excel data that is changed weekly
  53. vlookup for multiple columns
  54. Formulas
  55. How to add add'l sheet tabs in Excel
  56. Formula to return ADDRESS of cell in range that meets criteria
  57. Inserting a Space in The Same Place Formula
  58. saving page
  59. How to find if a string starts with a digit
  60. Please Help If You Can
  61. My New Macro from Bernie
  62. Function limitation
  63. Using INDEX twice??
  64. My New Macro
  65. Macro Modification Help
  66. How to simplify this IF formula
  67. Pivot table drilldown
  68. Where is DateDiff function in Excel 2002 ?
  69. loan calculator cells, P&I formulas do not copy to second cloumn
  70. Large function
  71. How to convert string to a date
  72. Count on multiple columns
  73. INSERT ROWS WITHOUT SCREWING-UP FORMULAS!
  74. how do I make a spreadsheet fit the right margin.
  75. add characters to beginning of text
  76. Can you nest a MID function within a IF function in Excel
  77. MS Querry for Excel
  78. Auto Filter in Excel
  79. Auto filter in Excel
  80. the limit on how many rows can be in one spreadsheet
  81. Re: $ added to formula automatically
  82. Re: Using excel display a roster as hourly coverage in units
  83. Backing Up
  84. Splitting Data
  85. Re: Subtotal has stopped working
  86. Re: Addendum to "Subtotal has stopped working"
  87. Training on macros in Excel97 using Windows 98
  88. LEFT function
  89. Advanced analysis tool in Excel
  90. Re: Insert $ to make address absolute
  91. AMATCH
  92. Problem of Open Office and MS Office
  93. round function in excel 2000
  94. How do I use the sumif if I have multiple criteria (i.e. greater .
  95. No Subject
  96. how do i sort?
  97. Averaging noncontiguous numbers ignoring zeros?
  98. PROPER function
  99. HELP!!! NEED formula!!!
  100. Problem using sumproduct
  101. COUNTIF > CELL VALUE
  102. Help!!!! Need help with IF statement!!
  103. How do I link the worksheet tab to a cell in the worksheet?
  104. vlookup, &, indirect
  105. Help with a formula!!!
  106. Excel formatting
  107. How do I replace the contents of a cell with its value instead of.
  108. Nesting Functions
  109. How Do I ......?
  110. Formulas link cells
  111. All formulas display zero....HELP!!!
  112. Date Math Problem
  113. =COUNTIF How to if 2 or more arguments???
  114. Timesheet
  115. average if function
  116. How get rid of these errors if cell has no vals?
  117. If statement
  118. pivot table % calculation
  119. Difference between Averages in a Pivot Table
  120. I need to copy table from one sheet to anothe
  121. Auto Update A Validation List
  122. Counting NUMBERS &/or TEXT from a column to other sheet ?
  123. pivot table jocks?
  124. Prevent duplicate entries
  125. Product Price List with 14k records, filter w/out using AutoFilter
  126. want the avg of a range BUT
  127. How come my formulas work in one cell but not the other?
  128. how can I link entire sheets?
  129. Copy cell formating as part of a formula
  130. Assign a number to a name
  131. Excel formula needed to amounts into one column pulling from 2 col
  132. Randomly choosing
  133. If Functions for Lates
  134. File not found prompting
  135. Prevent entry based on another cell value
  136. I need help with creating a special macro .
  137. Excel Error Message
  138. Count in tables
  139. Color Format
  140. Duplication in Column
  141. How do I report the filedate in an Excel2000 cell?
  142. Replacing characters
  143. Conditional Formatting if any value in the cell
  144. Seperate the data from the Cell
  145. SELECTING CURRENT DATE AT OPENING
  146. pmt function in Excel does not return correct monthly payment amou
  147. How do I stop SUM commands going into negative numbers, i.e. roun.
  148. Exporting from MYOB to Excel the date cell doesn't display as dat.
  149. Help with if function
  150. Saving question
  151. Macros in Excel
  152. Function to return value from each tab
  153. How can I get the Clip Art Banks off of the Worksheets?
  154. Trouble copying and pasting a formula
  155. Calculations Using the =IF formula
  156. IF/AND Formula seems to only be reading 1st part of formula
  157. Excell question about formula copying!!!
  158. How do I make a 5th sheet to total cells from previous sheets in .
  159. Why will solver only return the original adjustable cell values?
  160. averaging specific rows in multiple arrays
  161. make a vlookup using a variable path
  162. How do I extract numbers from many columns in excel on to one cel.
  163. Using the SUM Formula
  164. Link Worksheets
  165. error message.
  166. how do i calculate hours worked in excel?
  167. Paste from MS Word
  168. sumproduct causing memory errors?
  169. spredsheets?
  170. Allow refence in the "table_array" position of Lookup functions
  171. ALLOW A REFERENCE IN "TABLE_ARRAY" POSITION OF LOOKUP & INDEX FUN.
  172. Numbering pages
  173. is there a Function/Formula that will put the name of the workshe.
  174. SUMPRODUCT
  175. Templates Excel Payroll
  176. Protect cell but allow copy command?
  177. Link Text to an Associated Number
  178. Return a blank
  179. Formula Help With MATCH & OFFSET
  180. Finding gaps
  181. MATCH function - 2 columns w/ SIMILAR, not EXACT data
  182. Average of selected field
  183. Re: Formula correction HELP!!!
  184. Copies 02/22/2005, Pastes 02/21/2001
  185. Generate Text String
  186. Definition of a statistical function (CQC) in Excel
  187. HOW TO SORT A COLUMN THE SAME AS ANOTHER COLUMN WITH SIMILAR CONT.
  188. Macro - Copy - Email
  189. Count of days
  190. sum and current cell value
  191. Need help w/ "Weight Formula"
  192. How do I use if statement when I must refer to a cell that has te.
  193. Writing a formula
  194. stop cell entry being copied to other cell
  195. linked cell doesn't show formatting
  196. Numbering sheets in workbook
  197. Multiple FIND functions in Conditional Formatting
  198. VBA Question / Clearing out All Data
  199. We have SQRT. But what is the function for other roots - cubed ro.
  200. Keeping cells in place
  201. Getting worksheets to talk
  202. #VALUE!
  203. Pivot Table Data
  204. alt+tab between workbooks?
  205. HOw do I display text in the data field of the pivot table, inste.
  206. Simple Format Question
  207. Average If
  208. How do I return entire rows in a lookup of one sheet to another?
  209. IF & VLOOKUP FORMULA
  210. Help with a formula to copy
  211. Multiple selections in a drop down menu
  212. is statement with an empty cell as result
  213. Total formula
  214. Operations with hidden cells
  215. Excel function question
  216. Syntax Help
  217. Trying again for workbook formula updates
  218. Need Help Creating A Macro
  219. Excel Window
  220. data validation
  221. Tricky graph
  222. calculate percentage
  223. Create an AVERAGEIF function.
  224. Macro for Br.Telecom a/c
  225. consecutive numbers
  226. How do I set up an If statement to look beyond the previous cell .
  227. How can I get the Analysis Toolpak
  228. Exception report in excel
  229. Pivot Table - Calc Item Problem
  230. How to turn-on the PHStat in Excel 2003?
  231. How do I print a list of worksheet tab names in a workbook
  232. evaluate HYPERLINK()
  233. add hours & minutes to other hours & minutes to receive total hou.
  234. using colour
  235. How can I set up a formula to multiply $ x hrs? i.e. 8:30 (8hr 30.
  236. conditional option button help
  237. Two column widths for the same column
  238. Line breaks
  239. preventing duplicates
  240. Extracting Data from another spreadsheet
  241. Rounding
  242. Multiple vendors and scenarios - Excel
  243. First Sheet
  244. How do I display records using a key field in Excel?
  245. Comparing multiple lists
  246. comparing two values
  247. How do I set up a perpituity calculator?
  248. recalculate cells
  249. Calculating number of days
  250. Summarize by cell format?
  251. Matching Question
  252. Updating Old Workbooks
  253. Formula requiring two different criterias
  254. Is there a command like subtotal but with a conditional?
  255. Pivot table iteration
  256. Function to format cells???
  257. Sum and If combination formula
  258. Sumproduct error
  259. copying formulas
  260. extracting data from a cell
  261. Sum last 3 values
  262. What is the keyboard shortcut for parentheses?
  263. printobject for image objects
  264. Searching and Retrieving data from a Worksheet
  265. Merging two spread sheets
  266. maximum formula length
  267. Return 1st of the Month
  268. Formula to post data in another spreadsheet
  269. Date Conversions from UTC to EST
  270. How do I save format changes in a comma delimited file?
  271. Sorting data in Excel..
  272. Suddenly cannot calculate functions or formulas in Excel
  273. Data comparison
  274. sumproduct & indirect
  275. Data Validation
  276. excel date formats changed
  277. Data Validation
  278. Formula Help??
  279. Export simple appointments from Excel to Outlook
  280. Formatting Question
  281. RANK Function Modified?
  282. can i convert data copied as an image into data in excel ?
  283. Time Issues
  284. Invoice and Credit Notes
  285. What function would let me find Batting Averages?
  286. What function would let me find Batting Averages?
  287. What function would let me find Batting Averages?
  288. What function would let me find Batting Averages?
  289. Named list of sheets
  290. Sorting worksheets within a workbook
  291. Rounding to price points
  292. How do I remove all text to the left of the @ in an email address
  293. Text Box
  294. merging different worksheets in a workbook to one sheet
  295. indirect application to formula
  296. excel will not bold a cell, then program quits
  297. excel will not bold a cell, then program quits
  298. Golf Handicap
  299. Copying sheets with pivot tables
  300. mobile phones numbers
  301. complicated array
  302. Using Macro to Sort Names, Numbers & addresses
  303. Formulas
  304. A template for limit what is imported/
  305. Calculating the number of Fridays in a month
  306. Sum is positive value or "0" value. Negative value equals "0"
  307. countif function??
  308. Choosing a date
  309. Averaging, ignoring zeros
  310. need IF function to return 0 if it finds a one out of three words
  311. Lookup then Match and insert value from next column
  312. lookup formula help
  313. running macro at automatic time intervals
  314. elapsed time
  315. Function HELP please???
  316. Non-sequential VLOOKUP function -OR- sequential sort of web query
  317. find consecuetive means
  318. Is it possible to copy only selected items to another worksheet...
  319. pivot table field name error
  320. How do i get coloured tabs in worsheet for excel
  321. I wish to change the last digit in a list of random numbers. To a.
  322. email address hyperlink
  323. Re: Grouping Question
  324. how to delete the 1st letter form a set of rows of info.
  325. 2-Level (criteria) Lookup Function Help
  326. How do I change a text fraction. eg 1 1/2 into a decimal number, .
  327. Date related IF statement
  328. How can I take specific rows and move them to the bottom
  329. Date related IF statement
  330. DSUM vs SUMIF
  331. How do I set up some cells in a spreadsheet to be a required fiel.
  332. A cell reference in a formula changing
  333. pivot help - limit data for last 20 dates
  334. Excel formula
  335. pivot reports - limit report to last 20 dates
  336. How do I tell Excel to take a selected item and copy it to anothe.
  337. Coefficient of variance
  338. Advaced filter error 1004
  339. Inserting custom worksheet
  340. How do I copy specific items to another worksheet?
  341. Advanced Filtering - Computed Criteria
  342. moving data
  343. count &vlookup
  344. Sheet Duplication
  345. Excel Rank syntax
  346. match mix with sumif and vlookup
  347. Inventory Wash-Out sheet
  348. find duplicate entries and delete them?
  349. what is a macro?
  350. Using input to access different worksheets
  351. if a cell = a particular letter or even contains that letter
  352. How do I pull data from a previous worksheet?
  353. Adding text to the result of a formula?
  354. Using more than one subtotal with same data set
  355. Calculating hours for a timesheet
  356. Data entry
  357. countif question
  358. How do I add TextBox.values?
  359. How do I count number of cels the matches 2 conditions ?
  360. Cant find the Formatting Toolbar on my Spreadsheet.
  361. Almost got it !! but need advice
  362. how to make excel select todays date from a list
  363. How can I create a list that skips zero values?
  364. Does font color affect sorting a list in Excel?
  365. Prime number puzzle
  366. What function should I use to convert 43232- to 43232
  367. Hyperlink Problems
  368. Row = Application.Caller.Row
  369. Counting
  370. Form Caption Logo, How?
  371. interpolate missing data between points
  372. how to read number as string like '1243 = One thousand..'
  373. total of certain cells using 2 criterias
  374. My arrow changed on all spreadsheets
  375. Using paste link infromation in cell to hyperlink to source cell?
  376. New User help me
  377. Converting Weekly Data into Monthly Averages
  378. Textbox.caption to cell if empty, how?
  379. Macro -Far too Hard for me !!
  380. indirect lookup
  381. Conditional Formatting
  382. cells() and counting number or rows on spreadsheet
  383. Ho Do I create drop down menu?
  384. zero supress leading zeros when chg format from text to number
  385. "COUNTIF(AND"
  386. How can I retrieve a spreadsheet closed out of (not saved)?
  387. How can I retrieve a spreadsheet closed out of (not saved)?
  388. how to get 52 week hi/lo data for UK stocks
  389. counting
  390. Counting multiple occurances of a specific string
  391. Paste Link - Cell Comments get lost
  392. how can I rank within a subgroup?
  393. Creating a formula using absolute referencing - I think!!
  394. how do i make a chart using text information?
  395. How can i vary the width of columns in a histogram?
  396. How can I import dates from an Excel spreadsheet into a calendar .
  397. Conversion
  398. VBA Form ComboBox question
  399. Excel Macros
  400. automatic new serial number for each new sheet within one file
  401. remainder in a division
  402. min, max functions
  403. Cell 255 character limit and formula
  404. In Excel how can a number automatically display in text form
  405. Finding frequency
  406. Concatenate
  407. H2 get excel to return 6 months ahead ie input jan and it returns
  408. Compare 2 rows of text and return adj value
  409. Will pay someone to write small Excel code for me
  410. Keep Custom Menu settings - help !!
  411. How can I make cell data automatically shift up when deleting...
  412. copy a cell to another worksheet?
  413. include maximum number in fomula
  414. is there a way to Un-duplicate in excell
  415. How to code so cells or text automatically change color based on .
  416. Displaying autofilter criteria
  417. A sort of lookup or match
  418. Hex Characters
  419. Convert to Numbers
  420. Advanced Sorting/Result
  421. I'm still stuck
  422. Printing Comments in Excel 2003
  423. Finding min,max in an array using selected rows from a table
  424. Finding minimum value across selected rows of an array
  425. pls advise
  426. excel97 vs excel2000 (Find instruction)
  427. Rookie needs a macro
  428. Shadows of the Pivottable Field List while macro is running
  429. VB problem
  430. Compare cells/columns and highlight matching text strings
  431. The left function does not work when displaying times, how is thi.
  432. IF IS NULL PROBLEM
  433. Hiding a function value in a cell until function used
  434. How can I paste a formula that references a chart of data
  435. What is non-numeric data in Excel?
  436. IF and LEN and MID Problem
  437. Calculating pace
  438. Excel is not accepting any character entries
  439. stock control spreadsheet
  440. How do I combine rows, combining duplicates as well as concatenati
  441. Merge Data from Multiple Spreadsheets
  442. vlookup
  443. HLookUp Function
  444. help
  445. carry over data
  446. How can I prevent a Excel file which is set as shared being chang.
  447. Getting a named range from a cell value
  448. Defining a range
  449. Summarizing Data across Worksheets using a single reference
  450. Search list for new addition
  451. Help with the FIND function
  452. How do I export comments into another excel column as cell content
  453. Grabbing recods based on date and shift values
  454. Password Protect Worksheets
  455. Help Required With IF AND Formula
  456. Excel
  457. How do I clear cell content when excel document is closed?
  458. In Excel Auditing linking lines(blue colour) are not shown proper.
  459. Message Box - more help please !!
  460. add time and convert it to currency
  461. Money for life
  462. Howdo U copy a formula down a column, that uses data in another w.
  463. Howdo U copy a formula down a column, that uses data in another w.
  464. Percent Rank
  465. Is there a Timestamp function that does not update in Excel?
  466. Timestamp function that does not update in Excel?
  467. retain 'update remote reference' flag
  468. Excel - Discount Factors and NOV
  469. data validation
  470. Date format
  471. having problems with autofill on each sheet
  472. Add a Message Box
  473. excel pivot
  474. Updating Excel Data on Multiple Sheets
  475. how do i calculate the order quantity?
  476. geting hiperlink wiyh vlookup
  477. Change decimal format of cells depending on conditions?
  478. how to sort names and social security numbers a to z
  479. convert a numerical currency into word format
  480. Check Box
  481. extract data from a range of cells in rows or columns when a date.
  482. Using Conditional Format
  483. How can I do a "best match" for text entries?
  484. Formula to hide blank rows
  485. Capturing query table errors
  486. add list to newly created menu
  487. Formula help
  488. Rank Question
  489. Identify if a cell is referenced by other cells
  490. VLookup? Right function?
  491. how do I reference a spreadsheet in a cell
  492. phantom headers
  493. Extracting data from multiple worksheets into a list
  494. How can I include the name of the tab in a header without typing .
  495. Excel shifts to wrong worksheet automatically
  496. SUM a column with errors
  497. Sub-total feature is unavailable in Office 2003 Excel
  498. Concatenating Dates
  499. how do i open a 2003 file into an xp spreadsheet
  500. opening worksheet is "packing list"
  501. Saving a file using a specific name in a cell
  502. "count if" function based on value of another cell
  503. I entered 11/22/2004 in excel workbook and it keeps changing to ##
  504. moving formula resupts to another sheet automatically
  505. interior.colorindex used with conditional formatting
  506. Formula - Excluding weekends & holidays
  507. Formula presumes cells have data
  508. Excel should support DAYOFYEAR(year,month,day) returns julian dat.
  509. How can I write a formula or an argument to highlight a date when.
  510. Excel should allow a number formats of HEX, OCT and BIN.
  511. Check for errors
  512. why do my spreadsheet gridlines only prints half way on the page?.
  513. Can I put Pop up menus on Excel
  514. Using INDEX & AND
  515. What does ={TABLE(,J213)} in the fx Box Mean?
  516. converting to numbers
  517. unwanted number to date conversion while pasting data from web
  518. Tje opposite appears to be happening
  519. Help with Pivot Chart
  520. Protect the formula but change result.
  521. Use address function or other
  522. What's wrong with this vb?
  523. how to set a 6-day work week ?
  524. Multipart formula needed
  525. How to have multiple columns in pivot table data area?
  526. problem working with time data imported from text file
  527. Learn formulas
  528. Is there a way to automatically add columns as the data updates?
  529. Using COUNTIF with 2 criteria - SUMPRODUCT?
  530. formula to extract specific data if match occurs
  531. using sumif & countif to sort multiple cells
  532. Formula doesnt work
  533. find data from other sheet
  534. finding the largest number from the last row and look up its name.
  535. is there a more efficient formula than...
  536. sumproduct function
  537. Ref to Tab Name
  538. every nth cell by columns not rows....
  539. Can I increase row capacity beyond 65536 rows
  540. Match function selecting first value it matches on exactly
  541. Incrementing formula by two rows
  542. Bringing additional information in with combo box selection
  543. offset every nth column
  544. Summing part of an Alpha Numeric String
  545. Counting...
  546. VLOOKUP or MATCH
  547. In Excel what can I use for the XINDEX function from Lotus 123?
  548. how to develop a table to count in base numbers
  549. conditional formatting-shading
  550. I need to develop a table to count in binary using excel xp
  551. need to develop a table to count in binary using excel xp
  552. need to develop a table to count in binary, etc. using excel xp
  553. Rank fx - Fill Down?
  554. Data Table
  555. How I show, automatically, the tab name on a cell, in Excel?
  556. Worksheet Function - Find?
  557. I want to print out the sheet tabs (sheet names)
  558. Have a Pivot Table Include a "% of an item"
  559. I NEED TO SUM NUMBERS ON A COLUMN THAT HAVE TEXT AND NUMBERS
  560. If function clarification
  561. purchase order counter in excel purchase order template
  562. function needed
  563. colors in excel formulas???
  564. How to make a chart in excel
  565. Auto Protect workbook with password upon opening
  566. Vlook up or index match
  567. Is there a standard deviation calculation in Excel?
  568. What does a "plus" cursor mean (in lieu of the pointer?)? thanks
  569. Sorting data by last to digits
  570. How do I automatically (using a formula like =SHEET1!A$1) referen.
  571. insert from previous worksheets
  572. Sort or Filter option?
  573. IF function help needed
  574. Is there a way to calculate business working days between dates i.
  575. Want to return a value based on a whether a number is within a ra.
  576. What function do I use to convert "time" to minutes?
  577. Need Formula to display pivot table source data
  578. formula to set up dynamic range in names
  579. Compare cell values
  580. SUMIF question
  581. Portion of concatenate formula to have different color and font fo
  582. Checking excel for errors/inconsistencies
  583. can i get a letter to be calculated in a worksheet
  584. excel sorting
  585. how do i sort excel worksheets by alphabetical order?
  586. Pesky VLookup !!!
  587. creating a formula
  588. Match or vlookup?
  589. Calendar
  590. How to have multiple columns in pivot table data area?
  591. For the Excel Query Gurus
  592. text splits down cells
  593. create menus in excel worksheet
  594. How do I enter a formula in a cell so that letters= a number i.e..
  595. How do I join a filename and a cellreference, by just filling in .
  596. Pivot table copy and paste
  597. Formula Help...I tried but failed!
  598. What is invisible in a cell?l
  599. Complex(?) Edit
  600. can excel calculate a letter
  601. Excel Function
  602. Can I use the contents of a cell to satisfy the result_vector arg.
  603. Winnowing a list
  604. Pivot table refresh
  605. Colors as text
  606. list values equal in 2 worksheets?
  607. dynamic range / offset
  608. IF Statement
  609. How do you add one date to another? I type in 1/31/05 in A1 and I.
  610. Straighten Me Out Please
  611. Converting time figures into 24-hour format & sorting them...
  612. FIND DATA WITHIN DATA (V-OR-H LOOKUP/FIND/MATCH?)
  613. How to nest a left function within a sumif function?
  614. weight formula
  615. Combine into one please.
  616. linking excel workbooks
  617. Active sync - Contacts sub folders
  618. lookup tables in cells
  619. conditional formatting
  620. How do I sort data into 2 worksheets in excel vba?
  621. find parts of a total
  622. Color Formatted Cells not showing color
  623. vlookup & conditional formatting
  624. Convert 20050118 to a working date field
  625. Cell color change in formula
  626. drop down menu length
  627. Excel: Value Lookup
  628. Sub-Totalling Based upon a changing field
  629. Remove pages?
  630. settings
  631. pivot table report
  632. can i delete "lookup" from right-click in excel 2003?
  633. iF STATEMENTS WITHIN CONDITIONAL FORMATS
  634. Product Function in Pivot Tables from Multiple Consolidation Range
  635. Custom re-curring values in footers
  636. set hypothetical values for a cell
  637. If Then statement
  638. If Then statement
  639. How do i transfer certain lines from one list to another
  640. numbers in cells are automatically divided by 100. Not a format s.
  641. Adding values from one worksheet to another
  642. Avearging columns with less than (<) text entries
  643. Time and date calculations
  644. LOOKUP??
  645. Formula changes on own accord
  646. paste special (values)
  647. Compare ranges different size
  648. Automatically number invoice
  649. Blank cell criteria
  650. view list of worksheets contained within a workbook
  651. Excel time/duration spreadsheet
  652. Using "Get External Data"
  653. Sum Criteria
  654. use check boxes in excell
  655. copying existing function
  656. Manually update links
  657. Chart linked cells?
  658. Saving a Workbook
  659. 3D Workbook??
  660. print tickets with incrementing numbers in Excel ?
  661. count & Autofilters
  662. Deletion of rows where a value is satisfied
  663. COUNTIF in one colum then COUNTIF in another...???
  664. Value of the actual Auto Filter
  665. My workbook is slow.
  666. Paste Special values only
  667. Validate cells have data
  668. How do I set up print titles in Excel?
  669. Get External IP and Mail It
  670. Automatically change text to uppercase
  671. I want to send data from one sheet to another
  672. how to update functions in excel sheet?
  673. How do I select subtotal for a list when it is in grey?
  674. Need Zeros
  675. Sort Function
  676. Add Function to String
  677. Multifunction for one cell
  678. How do I copy a function for comparison but keep first cell value.
  679. Adding the sum of figures in one column if they meet 2 criteria
  680. Remove complete row containing a single word
  681. copy and fuze for MOUS
  682. Using "IF" statements
  683. Reading a text file ?
  684. range and cells syntax
  685. Using formula to calculate a number.
  686. Date formula
  687. Parsing a column
  688. My excell column letters have changed to numbers. I don't want th.
  689. Are there any balance sheet templates?
  690. count
  691. Matching an Array in one Tab with an Array with another Tab
  692. Can auto number (or OFFSET) include letters?
  693. count cells with unique numbers
  694. Last in column formula
  695. adding cells that contain formulas that have returned error messag
  696. Auto number w/ different letter-number combos in same column
  697. make a macro to move specific rows to another sheet
  698. Automatically print all page contents in pivot table.
  699. Drop Down List
  700. SUMPRODUCT???
  701. Is it possible to create one column with two different width?
  702. Is it possible to create one column with two different width?
  703. Is it possible to create one column with two different width?
  704. Calculat years married or age of someone on today's date
  705. How do I convert cell contents that are Hex to binary?
  706. how do i bring information from one worksheet to another in excel.
  707. help with if statement
  708. sum of cells without #VALUE
  709. totaling times past 24 hours
  710. dates, 1st of month
  711. How do I select only specific parts of one field?
  712. horizontal & vertical scroll bars
  713. compound interest
  714. how do I count the sum of 2 columns in excel? countif(a1:a100='op.
  715. macro recording
  716. Round up to 100?
  717. = formula
  718. Custom lists - not following defined order
  719. reports
  720. pivot table
  721. convert currency in portuguese words
  722. How do I count data in range A:A that is dependent upon criteria .
  723. Custom lists - not following defined order
  724. extracting text only
  725. keyboard shortcut
  726. SUMIF
  727. Define a range based on another named range
  728. how to make number as text and left justified?
  729. how to create a condition returning 2 different drop down lists?
  730. How can I get excel to apply values in a cell before or after date
  731. Help with Protections ASAP
  732. extract data from worksheet
  733. Need Further Help Sorting Data
  734. can't open 2 excel program a once
  735. sumif
  736. Word wrapping does not expand the cell, why?
  737. if statement between values
  738. HOW TO CALCULATE THE NUMBER OF YEARS BETWEEN TWO DATES
  739. Need help Sorting data
  740. How do I find the two lowest values in a range?
  741. How can I look up max of one colume and display the colume to the.
  742. Condition now returns error
  743. Calculate time
  744. Formula to compare multiple rows values based on another column?
  745. How do you continuously update time and date in an Excel cell?
  746. How to continuously update time in Excel?
  747. Buttons
  748. Adding more than 30 numbers in a column
  749. How to I get a date to go from 1/2/05 to 1/8/05 -> 1/9/05 to 1/15.
  750. what key do i use to duplicate column ?
  751. Formula or not?
  752. GETPIVOTDATA to create Purchase in specified month
  753. How do I set up a template for calculating absorption costing met.
  754. Replace Symbol "Code(63)"
  755. Want to input one character to cause related string to display in.
  756. Lookup Functions
  757. Vlookup from 2 different sheets
  758. I faxed an excel worksheet and now cannot print?
  759. How do I set up a database with Excel with connections between se.
  760. how to graph a horsepower curve in excel (horsepower vs. rpm)
  761. Using VLOOKUP with multiple first column matches
  762. $$
  763. How to leave the title row in MS Excel fixed?
  764. Number is in a text format
  765. Re: TODAY function?
  766. Excel should have a simpler subtraction formula similar to "sum".
  767. "Excel Function Dictionary" new URL?
  768. Result not being returned
  769. macro for "entering data"
  770. How do I compare similar rows of data in same worksheet
  771. occurance of numbers in cell range
  772. How can I get a date to move from 1/1/05 to 1/7/05 -> 1/8/05 to 1.
  773. How do I mark an item as paid so it is not included in a column t.
  774. How do I create a formula to retun a value of 0 (zero) when a VLO.
  775. Calculate Years of Service
  776. Maximum Calculation Speed
  777. interpolation with forecast in a particular interval (HELP)
  778. Lookup Question
  779. Purpose of the Microsoft MVP
  780. Find and Go to Value
  781. sumif help
  782. merging and transposing cells
  783. Want to change the color of a true/false logical statement with i.
  784. Trouble opening older Excel wbks - appears to becode in column A
  785. How do I transfer data between Excell sheets?
  786. Determining calculation slowdowns
  787. referencing cells that return blank results
  788. vlookup help
  789. Help on Large Function
  790. Attaching labels when using large or small functions
  791. Converting Numbers to Time
  792. Why does Excel 2003 freeze when saving a workbook that has importe
  793. need to fill cells automatically
  794. Count in Pivot Table
  795. Bob Phillips, I have one more question
  796. Dynamic Print Range Help
  797. SUMIF using VLOOKUP as criteria
  798. Sumif help please
  799. How do you count number of characters in a single cell
  800. How do you count number of characters in a single cell
  801. How do you count number of characthers in a single cell?
  802. Extracting same column from large number of workbooks
  803. Select same range from large number of workbooks
  804. how to create a variable column in cell reference
  805. sum more than 5 cells
  806. Cell formats
  807. Can I divide a column at the first "space" occurance
  808. A formula that is: if the sum is this, then muliply by this?
  809. formulas
  810. find calculation function
  811. Starting MS Excel with a worksheet other than SHEET 1
  812. how do i set up a formulas with an if date?
  813. data sorting problem
  814. Look up then insert value in next column
  815. data sorting problem
  816. How do I Autosum a running column total in excel?
  817. Calculating credit card debt, interest , and payments
  818. Why is Group and Outline grayed out?
  819. When I copy a formula to another cell, I get the value of the ori.
  820. Pivot Table Auto Update Data Source?
  821. changing the message in an error message
  822. How do you compare text in cells
  823. EXCEL counting calculations
  824. Count Consecutive Numbers in a Row
  825. using ranges
  826. formula question
  827. Convert a Yes/No/NA response to a # value or %
  828. Search - replace NOT in formulas
  829. Excel IF and COUNT functions
  830. Consolidating entries from multiple worksheets
  831. Formula
  832. Vlookup
  833. How can I get a cell locked if the condition is false?
  834. IF Function
  835. vlookup array in excel VBA
  836. query wizard has stopped working how do i rectify this
  837. How do you display negative numbers in the unit price column?
  838. Excel If calculations
  839. Excel 97/2000 - Help with looking up external data.
  840. check occurrence of items in a range
  841. Allocate workload evenly to different staff
  842. I need to do a Worksheet for my Financial Accounting Class. What .
  843. transfering information from one cell to another
  844. R. VENKATARAMAN
  845. how do I sum the same cell from multiple worksheets?
  846. dynamic external cell reference
  847. VLOOKUP
  848. Copying a formula and changing ONE value...
  849. formulas
  850. r. venkataraman
  851. formulas
  852. How do you copy a formula without incrementing some constants?
  853. some sort of an IF function
  854. IF function
  855. counting functions
  856. Sumif() with criteria
  857. Vlookup with 2 ranges in one worksheet
  858. removing text after a character
  859. FTP
  860. SUM based on multiple conditions - SORRY, URGENT!!!
  861. Need to find oldest date in ever changing list.
  862. SUMIF problem
  863. Moving worksheets in a book
  864. How do I sort a column a unique number?
  865. Conditional Sum weirdness . . .
  866. solver constraint
  867. Goal Seek on Multiple Cells
  868. Formula to read two column come back with one value?
  869. Can macros output to a cell selected prior to running it?
  870. First Occurence of Non Blank Cell in row array
  871. Autofilters in a Pivot table
  872. limited conditional formatting?
  873. COUNTIF cell A1 is x and cell B1 is y
  874. HOW DO I FORMAT DATA FROM YY/MM/DD TO MM/DD/YY?
  875. HOW DO I FORMAT DATA FROM YY/MM/DD TO MM/DD/YY?
  876. Bolding when subtotalling
  877. Counting keystrokes within a cell
  878. How to hyperlink from a workbook to sheets in another workbook?
  879. auto-calculations using calendar and dates (Excel-Office 2000)
  880. Complex Date Functions
  881. question
  882. The description of the ATAN2 function in Microsoft Excel is not 1.
  883. Date Function
  884. MAX
  885. How do i get the top 5 numbers in a range of cells?
  886. How do i get the top 5 numbers in a range of cells?
  887. Weighted Avg - using values from multiple sheets
  888. Removing Asterisks from the contents of a cell
  889. Excel worksheet tabs
  890. File Size f(x)
  891. printing consecutive date on excel workbook
  892. how do I show last date file saved?
  893. time add
  894. A version of excel that doesn't have 15 limitation
  895. Sort by last 2 digits
  896. Problem with GEOMEAN - returns #NUM error
  897. What is the Excel 2003 syntax for linking a cell value to content.
  898. Page Numbers
  899. Vlookup won't work, any other ideas?
  900. scrolling won't stop
  901. Excel
  902. Lookup function in Excel
  903. How do I perform a MOD-10 credit card check in Excel?
  904. check-mark symbol
  905. adding time zones to formatting
  906. reference a repeating cell in a formula
  907. switching values from positive to negative
  908. Extract numbers from strings
  909. If the lookup-value is a formula
  910. Pivot table limits
  911. Ctrl+Shift+arrow
  912. Rounding number to the nearest quarter
  913. allwoing protected excell sheet
  914. Starting work period on a Saturday and ending on a friday
  915. Named Range in another workbook
  916. How do I append imported text down an Excel Spreadsheet?
  917. format MM:SS without mm/dd/yyyy/hh:mm:ss?
  918. want to count in two columns; countif (colA=x AND colB=y)?
  919. How do I do a count sum that ignores duplicate items
  920. I want to return "0" based on another cell
  921. Why does an excel worksheet default to 24 copies when printing
  922. set zero cell as blank cell
  923. merge data from 2 Excel files
  924. Calculating number of letters in a string ...
  925. Warn if already entered
  926. Count occurances of multiple values
  927. How can I allow users to make multiple selections from a dropdown.
  928. how do i create a journal with individual ledger pages?
  929. Go to first blank cell
  930. Text wrapping problems
  931. Summing some cells
  932. Return Cell References
  933. where can I find a template for salesforecasting?
  934. VLOOKUP Help please
  935. how to display formulas on the sheet
  936. How do I do a MOD-10 Credit Card check in Excel?
  937. Check for duplicates
  938. lock a picture to a cell so i can mail merge
  939. Removal of characters from a range of cells
  940. Comparing Data between two sheets
  941. Excel 97 macros to Excel 2003
  942. Vlookups array function by Alan Beban
  943. How do I write a formula to color code based on dates provided or.
  944. Vlookups array function by Alan Beban
  945. Show "2" only if....
  946. how do i add numbers corresponding to same date on different work.
  947. spread the number 123.45 so each digit goes to a different cell
  948. Is it Possible in a formula to have a formula for cell reference?
  949. Automatic linewrap with formulas displayed
  950. How to create a formula for a range of cells
  951. sum values in cells according to category
  952. Help!!! Match Formula
  953. Using IF when more than one cell contains criteria
  954. Complex Averaging
  955. Linked query not expanding with new data
  956. Sum values according to category (text)
  957. problem solving
  958. Remove time from a date and time field? Format removes the displa.
  959. Populate the subject line.
  960. Bad Cell ?
  961. Array Formula
  962. Computing Sales Tax and Retail Price from a number
  963. How do I make excel startup in a specific sheet?
  964. how do i input customer information and results of meeting
  965. Need help with sorting function
  966. execute external program when cell reaches certain value
  967. Updating Links
  968. LINK ONE ROW BASED ON CONTENTS OF A COLUMN WITHIN THE ROW (DATE)
  969. insert commnets in locked cells
  970. How do you show formulas in certain cells only (not the whole she.
  971. SUMIF
  972. count non blank cells which meet criteria in another column
  973. IF contains over multiple worksheets
  974. cALCULATION OF DAYS
  975. Total hours with NETWORKDAYS
  976. Help using Conditional Formating of Entire Rows
  977. SUM() does not work
  978. The definition of....
  979. If And Or functions
  980. if function with #No Data
  981. ms excel IF Statement w/pictures?
  982. Combining duplicate records(rows)
  983. Show only Matrix result
  984. RE: Value of last non-blank cell in a column
  985. If cell contains...
  986. still searching for color text
  987. How do I create a formula that will calculate monthly changes fro.
  988. Autofill question
  989. How do I install the networkdays function!
  990. Any way to calculate an average for more than 30 entries?
  991. Select part of a cell
  992. I really need help! Changing work period start dates
  993. indirect formula
  994. Bug in DATEVALUE command in Excel 2002??
  995. Time Calculation
  996. VLOOKUP first numerical value (not text)
  997. Listbox or Combo advise
  998. lookup
  999. Number of Occurrences between Specidied Date
  1000. How do I concatenate the contents of an array in Excel?