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. worksheet is locked on highlight how do I unlock it
  2. Merging new data
  3. Solver returns non binary answer in binary constrained cells
  4. GETPIVOTDATA - return cell reference, not value
  5. Is there a Division funtion in Excel?
  6. SUMPRODUCT Help
  7. convert date of birth to mos. old now, 30 and 60 days
  8. How do I find address of cell containing maximum value
  9. how can i rank a column in excel
  10. CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH
  11. Worksheet Selections in Macros
  12. Exl: how to? If column N value =R, then copyentir rowto sheet 2
  13. RE: CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH
  14. RE: Worksheet Selections in Macros
  15. words means numbers
  16. How do I display a graph from one workbook to another
  17. How do I return a blank for VLOOKUP instead of #N/A?
  18. HYPERLINK
  19. is there a blank drlling AFE available
  20. Linking Spreadsheets
  21. Calculating Percentage
  22. Can I sum only highlighted cells in a worksheet?
  23. Excel Lookup with If
  24. How to protect sheet but allow grouping to work
  25. How...?
  26. Comments Help
  27. function vba
  28. Sum of a row minus two smallest numbers
  29. Combining worksheets
  30. Adding columns to a worksheet
  31. Comparing Cells
  32. SUMPRODUCT Help
  33. Round function that rounds down if 5
  34. how to change formula bar settings
  35. Add more than 65536 rows?
  36. Counting rows containing data (both numbers and text)
  37. Figuring hours
  38. functions with nonadjacent cells
  39. Drop down lists show button?
  40. Reference an identical cell on a different page using copy/paste?
  41. SUMIF with multiple criteria
  42. Offset And Vlookup Combo Help!!
  43. Comments
  44. Hightlighting Numbers & then all Cells to the right of these Numbers.
  45. Paste Link
  46. Sort function or macro for the first 4 letters
  47. Database type Formulas
  48. how to save/copy data in cell to a series of cells on another pg
  49. graphing algebra equations
  50. Making a drop down list/column
  51. Overtime Hours
  52. Paste question
  53. Creating a formula for down and distance
  54. Formula does not work with 13 digit numbers
  55. Countif
  56. Need Help
  57. Count down formula
  58. Excell Check Digit Formula
  59. Excel 2004 Mac Version - INSERT LINE BREAK IN INFORMULA
  60. Complicated sort function with sort and sum
  61. Figuring hours
  62. How to consolidate data from multiple worksheets.
  63. Any MVP to try this ..
  64. delete command macro's
  65. import text and sort data into excel
  66. import text and sort data into excel
  67. Auto Sorting
  68. Compare two cells to evoke a response
  69. Compare to cells to evoke a response
  70. I cannot edit a graph
  71. STPCScut STPCScopy macro missing??
  72. can i store percentage formulas to reuse them?
  73. validation-list
  74. how do I calculate hours using one cell only
  75. How do you reference another cell in the criteria of a SUMIF funct
  76. IF function trouble
  77. Finding text within text
  78. Less i column
  79. "tomorrow worksheet function"
  80. sum / lookup w error correction
  81. um... im lost
  82. Index function works in A2, but not in A10, Why is that? Cant figure it out.
  83. Complicated Formulas
  84. How do a lock a picture to the rest of the spread sheet row entry
  85. variable as a cell reference?
  86. Creating a league in excel
  87. IfSum
  88. counting decimal places
  89. how to count the number of decimal places in a cell?
  90. Automatically copy values
  91. How do I sort (or group?) a spreadsheet by similar rows?
  92. add leading "0"
  93. joing (merge) tables by key field
  94. how to get the name of the sheet in a cell?
  95. how to spell out number using function in Excel
  96. if/then statements
  97. How to insert a picture with IF-function
  98. How do I calculate if a date is in a certain time frame?
  99. Invoice Numbering
  100. Selecting from a Validation Drop Down Box aborts macro
  101. IF Statements-Circular Reference
  102. Get other sheet names into a column
  103. making the range a set of data within a column
  104. selecting certain text in long row of text
  105. copy certain data from one row
  106. Adding superscript in text function
  107. Can I auto fill a cell in one worksheet by typing a code number
  108. formula for linear regression
  109. conditional formula
  110. Adding numbers to a running total
  111. IF Function Help
  112. Lookup across multiple worksheets
  113. How can I replicate a conditional sum formula?
  114. Help with IF Function
  115. Help needed with Adapting complex INDEX formula
  116. Use of iteration function
  117. how to share spreadsheed in excel with a person at another comput.
  118. Is there a way to copy multiple worksheets into one, row by row?
  119. In Use Message
  120. How to make excel not to compute formula
  121. Changing dates entered in 2005 to previous years
  122. How do I specify more than one argument for the SUMIF function?
  123. posting 20050826
  124. Please make it easier to access the IS functions (e.g., isblank) .
  125. how to find returns for lump sum & yearly investments
  126. Count the occurence of more than one condition
  127. Compound interest rate of return on investments
  128. Drop down List
  129. Formula requireing the system time
  130. COUNTIF criteria using date ranges?
  131. Linking Spreadsheets
  132. is date can be filtered to a different cell?
  133. autosend for excel worksheets for distribution list option
  134. Can You Translate This Function Into Excel Format?
  135. Hit enter in cell & move text down in cell, not go to cell below.
  136. Signifcant digits
  137. how do i convert 536 seconds to 8minutes 56seconds
  138. Lookup value throughout an array_return adjacent value and summing
  139. Opening workbook in user-defined folder
  140. Concatenation with leading zeros
  141. I lost the box on the top of Excel that you can type text in???
  142. my output appears very small
  143. fill series is incorrectly copying result
  144. sort rows in alphabetical order and move the corresponding data
  145. EXCEL 2000 AVERAGE function
  146. Random numbers
  147. How to move characters to the end of the string
  148. Hyperlink probelm
  149. Exponential values
  150. IF ranges for multiple columns greater then less then
  151. Linest function: data selection problems
  152. Linest function: data not being selected in formula
  153. RE: Converting text to numbers
  154. Collapse rows with duplicates
  155. Can Excel operate a function based on a true or false result?
  156. look up
  157. EXCEL WORKSHEET
  158. Select updated data from a range of columns
  159. opslag
  160. Difficult Time equation
  161. Inserting a row with functions
  162. Find last occurance of text in range
  163. overtime formula based on dynamic date range?
  164. Linking information between workbooks
  165. Summing a variably-sized range
  166. creating macros in multiple worksheets
  167. Re: Array formula needed
  168. SUMIF with 2 conditions
  169. Advanced Auto Filtering
  170. How do I find the last number in a column of numbers?
  171. Is this possible please if so How. Thankyou.
  172. Dynamic VLOOKUP function
  173. Showing a unique random number w/o duplicates
  174. Re: Formula for Ratios
  175. Vlookup using a range condition
  176. Select unused number
  177. Re: Default font for Comments
  178. 'SUM' Tables
  179. Combine into one please
  180. RE: SUMIF Function?
  181. Re: if amount <0, put the all line in red
  182. Hourglass comes up when going between split screens.
  183. Counting Months
  184. Average of numbers within a range meeting certain criteria
  185. Pivot Table - if Formula
  186. Inserting Pictures with IF function
  187. Not Sorting Problem?
  188. Problem, again
  189. Autofilters-Remove (Top 10...) and (Custom) options from the drop-
  190. i can not fliter unique records
  191. Copy and Pasting Every Third Row
  192. Modifying Macro
  193. Retrieving Unique Values From A List - TIP
  194. Please Help: Adding an equation to a range
  195. Color change - Cell Pointer
  196. Excel function to countif a criteria is matced within to columns
  197. Count a value if next to another value...
  198. Help with Excel Formula VLOOKUP
  199. Conditional Formatting Pbm
  200. Referencing worksheet names
  201. Sum the results of an equation through a series of Cells
  202. Complex Macro to perform an operation as it steps down cells?
  203. How do I convert time (2:30) to a number (2.5) in a formula?
  204. Drop down list button hidden
  205. Comparing a list to a Calendar worksheet.
  206. conditional copying of sheets
  207. put the index back into excel help - I want pop-down of functions
  208. Saving Version Control
  209. How do I get Excel date to change from 1/1/1900?
  210. Counting a range
  211. How to update links between wk sheets
  212. Excel doesn't add up
  213. Conditional Format to highlight entrire Row
  214. Function-formula help
  215. In Excel,how do I lookup a value and assign it to a list?
  216. formula for named cell/range using cell values
  217. Subtracting date:hour from date:hour
  218. Re: Bug in Excel's (not VBA's) MOD function
  219. Please add an INTERPOLATE function. For vector or array data.
  220. Index and match functions help needed.
  221. Hiding text so it doesn't print
  222. finding matching cells in worksheets
  223. Validation Problems
  224. Duplicates
  225. Returning a Value dependant on a cell which could have different d
  226. font colour change within a IF formula - Help!!
  227. wildcard use in formulas
  228. function/formula help
  229. Interest calculation
  230. Date problems
  231. Cell Offset
  232. Parse text & numbers & format
  233. Parse text & numbers & format
  234. Parse text & numbers & format
  235. Help!! with a formula
  236. how to enter numbers value for calculation?
  237. HOW TO FIND DIFF. BETW. 2 DATES, IT SHOULD BE IN YRS, MONTH & DAY
  238. multiple cell editing
  239. International Language Functions
  240. Conditional Format to Highlight entire Row?
  241. how can i filter data from one sheet and copy to another via formu
  242. combine text of multiple cells
  243. mass cell data editing
  244. Return Single Instance of Numeric Values from a Column
  245. Automatically insert row and copy formula
  246. How to print detailed instructions for all functions in Excel?
  247. How to print detailed instructions for all functions in Excel?
  248. trying to add text
  249. SUMIF for Dates / Months ?
  250. Real Value of .UsedRange.Rows.Count
  251. How do I add time (in mm:ss) from multiple worksheets?
  252. How can I match data about countries drawn from two database queries?
  253. Searching Excel for a value
  254. Data Validation dependant and unique
  255. Another Reason to Hate Insurance Companies (as if you needed one)
  256. Change color to red when fraction is negative
  257. Help with Excel formula
  258. IF Function or Countif
  259. When using SUMIF won't worj with crieria = cell referrence
  260. Entering same data, two worksheets
  261. Duplicates
  262. Changing a Link Mid-way Across Worksheets
  263. cell custom format
  264. =ppmt
  265. Refreshing drop down cell values...
  266. fill a series of dates excluding holidays
  267. assigning ranks to number ranges
  268. Ability for Excel to find and replace graphic objects (like Word)
  269. do I have to manually change PER to amortize a loan out 40 years?
  270. "BLANK" - need to delete
  271. do I have to manually change PER to amortize a loan out 40 years?
  272. Formulas requiring a time stamp
  273. Conditional formating help needed
  274. ATTN: Mr. Bob Phillips
  275. Check if cell contains certain text
  276. can not enable macros
  277. Can an IF formula result in a color filled cell in Excel?
  278. International Equivalents
  279. How do I separate a text value with dashes?
  280. Carying Forward data with specific information
  281. VB Error, combining rows if...
  282. Re: Excel finds a value that is not in the lookup range
  283. IF statement
  284. Source Data in Pivot Tables
  285. puzzled
  286. formula stays same in cell when new row is inserted
  287. vlookup, but ignore errors if #n/a
  288. Quick and easy
  289. Lookup and return
  290. errors and printing
  291. How do I input zeroes in a zip code for a mail merge?
  292. DATA > TABLE -- 2 variable data tables?
  293. subtact between times
  294. Combo Box
  295. Nested functions HELP!
  296. Formatting Cells - color based
  297. IF - need to insert a cell value
  298. ISERROR
  299. Excel - open a new workbook with "own" macro
  300. How to autofill data from one sheet into another
  301. Automatic Sort with VLOOKUP/LARGE Functions
  302. HOW DO I MOVE A DESCRIPTION OR NAME INTO A SUBTOTAL LINE
  303. Opening excel spreadsheets via excel.application object w/o prompts
  304. Update worksheet by comparing two cells
  305. Sort defaults
  306. copying formulas to another cell
  307. Data entry for two worksheets
  308. Nested If with And
  309. date shows 1/1/1900
  310. Array Formula help pls.
  311. Nesting Problem
  312. Excel Worksheet crashes when changes are made.
  313. Average of the minimum+50 in a row
  314. lookup function bringing in wrong info
  315. pivot table to sheets
  316. Copy Formula to Different Workbook
  317. COMPARE DATA FOR CHANGES
  318. Reading data in onther Excel document
  319. SUMIF Returns a #VALUE error when external source is closed
  320. Final week - 2005 Excel User Conference - Ft. Worth, Texas - Sept 16/17
  321. I want to convert 10,000 to "Ten Thousand" using Excel Function
  322. moving cell
  323. How do i make a range of cells change colour
  324. IF STATEMENT in multiple workbooks.
  325. Autosum returns an incorrect zero value on the selected cells
  326. LookupV
  327. Simple Copy from Worksheet to Worksheet
  328. Error using "IF" in Microsoft Excel
  329. Sumproduct / Max array formula problem
  330. plz help
  331. print bottom row repeat on every page
  332. Date Language setting
  333. How do I set up an automatic running average in Excel
  334. QUOTE NUMBERS
  335. Calculating the right formula
  336. backing sales tax out of a total including sales tax
  337. Using Sheet names in formulas
  338. working with dates
  339. convert a PDF file on the Web to Excel
  340. Matching a sampling # to it's row #number
  341. Newbe Help with count/countif function
  342. how can I blank out columns that are not being used
  343. Cleaning up data from Crystal Report
  344. Lookup - Pro-rate formula
  345. How do you format a cell for % varience for multiple answers
  346. IF Statement??
  347. inserting a VISIO drawing into a worksheet
  348. Product formula help
  349. Formula for appending data
  350. Caculating a "staircase" discount
  351. column to column conditional formatting won't work, need formula
  352. Results in a column
  353. How to transfer info from PDF file to excel (lists)????????
  354. how do I write the date in an if statement
  355. Freeze frame printing
  356. Drop Down List Autofill
  357. Vlookup then OFFSET over and down
  358. Do Loop
  359. Drop - Down Box
  360. Date Function
  361. create default cell value
  362. Formula Problem
  363. Exclude non-numeric data from calculation
  364. Counting Match Pairs In Rows
  365. formula to identify weekend dates
  366. combine date one column, with time another column into third?
  367. Is it possible to split a cell within a cell?
  368. Create a master worksheet based on 2 different worksheets
  369. moving the formula "average" over one column in a macro
  370. formula with changing cell ranges
  371. IF statements/formula problem
  372. Help with a formula
  373. Excel for inventory aging?
  374. Lookup function help
  375. display Calendar for Excel field entry?
  376. Do I have a corrupt shared Excel 2003 File?
  377. Help with formula...please
  378. create a multivariable regression in excel without using array
  379. Payment formula Question
  380. Cell reference
  381. how do you count checkboxes in excel2003
  382. use replace to edit a formula with wildcards
  383. Pivot Tables - Named Range
  384. School assignment: Excel worksheets.
  385. minimum along rows
  386. How do I total amounts on various sheets in excel?
  387. Function to return the active sheet name
  388. excel, printing data in columns
  389. Identifying bottom of list
  390. Range Changes with the Months
  391. page numbering
  392. Counting Blanks
  393. Editing Array Formula
  394. Countif using dates
  395. How do I delete the same item from all pages of a workbook?
  396. Best 8
  397. Not including blank fields in pivot tables
  398. coutif with 3 criteria including brackets
  399. randomly select value WITHOUT changing
  400. How can I merge and link workbooks into one summary workbook?
  401. Time format in excel
  402. Could you help me to calculate overtime
  403. CREATE A SUM BASED ON DATES
  404. cover #s to text
  405. how to change colour of text in true or false formula
  406. How do I calculate time
  407. Struggling Again With A VLOOKUP
  408. how to convert numerical figure into text
  409. Worksheet VBA function - not recognized
  410. Numbers converted into amount in words in English?
  411. Formula for Calculating a Floating Date
  412. importing data into a workbook
  413. Help with IF & Average Functions
  414. Function Help Please ....
  415. No Match
  416. Is there a way to reverse the layout of your colums?
  417. How to get pivot table Time field to appear correctly
  418. Question about Emailing
  419. How can I get fonts bigger on my dropdown list?
  420. counting filtered items
  421. How do I do this?
  422. Tracking calculation progress
  423. Find certain text in a column and return statement
  424. Need a help with the IF/ IFCOUNT function
  425. Update of cell values after insert row?
  426. IF - Nesting... almost got it - need a bit of help
  427. Need insert a dash in between last 4 digits in text string
  428. Target.Address syntax
  429. How can perform a summation?
  430. drop down lists/validation tables
  431. Automatic Date Entry
  432. How do I calculate operating expense
  433. Nested IF AND OR function Inexplicable error
  434. sumproduct w/horizontal range not working
  435. Spell Check an Unlocked Cell in a Protected Spreadsheet
  436. Selecting a Worksheet Range
  437. How do I calculate operating expense
  438. Links
  439. Logic Tree, MS help = useless
  440. I need to insert a drop down menu in a cell?
  441. Create a print macro that would automatically select print area?
  442. Make an =if show - instead of 0
  443. Can I modify Excel 2003 color palette to accept Pantone colors?
  444. formulas using text
  445. IF is not carrying out the FALSE part
  446. Getpivotdata - Excel 2000 vs. Excel 2002 and later
  447. VLookup and HLookup at the same time
  448. Check to see if cell data is within a range
  449. move one row to another in excel (worksheet)
  450. merging sheet1 to sheet2
  451. If Statement Using Wild Cards
  452. custom cell number
  453. Editing countif formulae
  454. Generalised version of LINEST using QR Decomposition
  455. counting date entries by month & year
  456. I want to use the same function as SUMIF, but for two criterias
  457. Max number of IF statements
  458. I'm Having Problems with EOMONTH
  459. Date Range and calculation
  460. Copy Formula - EXACTLY
  461. Recalculating a Regression Output in Data Analysis
  462. Selecting Rows
  463. save as macro/for password
  464. Automatically Sort By Reference Amount?
  465. Lookup and return multiple Values
  466. Workbook formulas
  467. Next Row
  468. In Format>Cell>Numbers>currency>Symbol Please add "Rs. India"
  469. Convert Text (letter) To Number Excel
  470. Large function
  471. Weeknum Function
  472. Splitting a Target Figure
  473. Help! Formula between the sheets
  474. #N/A! to be blank please.
  475. Age with mont in decimal
  476. unbalanced data in ANOVA
  477. Sum of comma seperated values in cell(Reposting)
  478. Help with VLookup function
  479. Referencing data in different worksheet based on month name
  480. How to insert picture and automatically size to cell?
  481. How to insert a picture that automatically sizes to size of cell?
  482. Excel formula help?
  483. creating a rate schedule
  484. Help with IF function
  485. Conditional Average
  486. Is it possible to place a stopwatch in Excel
  487. this may be simple, sumif question
  488. what exactly are relational operators in Excel? All math symbol?
  489. Countif based on 2 criteria
  490. pivot tables reports - altering display of (blank) cells
  491. I need help
  492. Help using the 'If' function to automatically fill in other cells
  493. Moving data in financial forecast
  494. How do I calculated total hours per week
  495. use only the first 3 letters of cell data
  496. excel does not open file in network
  497. Convert numbers into its equivalent in words?(12 to Twelve)
  498. Formula to lookup Multiple Column Text and then Count Result
  499. Lookup Function Problems
  500. Modify A Formula To Include AND
  501. Naming Worksheets
  502. cell format limits
  503. Conversion of Cell Contents into a Functional Worksheet name ?
  504. Conform a total to a list of results?
  505. how do I add minutes and seconds together in excel
  506. Customizing MSOffice 2K Format toolbar.
  507. need assistance with merging cells
  508. #REF! help
  509. Subtracting cell contents - I can't believe it's not working!
  510. IF RESULT OF FORMULA IS 0 WRITE EXTIMATOR
  511. have a date cell pop up a monthly calendar to choose a date
  512. VLOOKUP using a cell calculated with NOW returns Error
  513. web page numbers
  514. totals from a tabel
  515. Calulating Age Formula
  516. macros in personal.xls file
  517. Nesting excel greater than 7 arguments
  518. macros in personal.xls file
  519. copying data
  520. I am trying to set a letter grade for my students, HELP
  521. VLOOKUP, INDEX, MATCH... What to choose
  522. number to text
  523. How to auto number cells that have colour
  524. using item#s to link cells
  525. Need if Statement
  526. How to make repeat long numbers shortcut ?
  527. Counting Multiple Values In A Cell
  528. MOD function computation error
  529. Unprotect Cells depending on Cell value
  530. Need Help on Lookup function
  531. accessing an address stored in another cell
  532. complex conditional formulas in excel using "IF"
  533. Keep all cells in one row together?
  534. sumif with similar cells
  535. Value between 2 dates
  536. Help with SumIf
  537. Excel sumif functions?
  538. Counting Unique Values Given Criteria
  539. In Excel, how do I setup sequential numbering on an invoice?
  540. Will Excel produce invoices from a spreadsheet?
  541. Min and Max
  542. Hide Empty Rows When Printing
  543. cell values
  544. double vlookup in same function
  545. coverting rows to columns
  546. countif criteria only one word of few doesn't work
  547. function CELL() to return the formula in the referenced cell
  548. binary bit word
  549. Can you sort a column in Excel that's different by colored font?
  550. Pivot Table - Average of counts
  551. how do i replace ( with / without changing format to fraction
  552. filtered values can displayed in certain cell
  553. Do Loop
  554. LOOKUP problem!!!
  555. range names or check box
  556. how do I place the sheet tab name in my spreadsheet by formula?
  557. Group Contraction/Expansion in Protected Worksheet
  558. Large Index Match Lookup
  559. Average function and two criteria
  560. Convert Zip Code to County
  561. Help needed in finding specific series via row.
  562. Do Loop
  563. Sorting Data question
  564. Can I make the data_field in the getpivotdata formula a cellrefere
  565. can u use formulas between tabs in a worksheet?
  566. Lookup ADDRESS of GETPIVOTDATA Subtotal/Cell
  567. Password Protect
  568. Do Loop
  569. Positive Results
  570. having one more than one column index number
  571. Text spacing in drop down lists
  572. Inventory Control
  573. need information
  574. Required fields with comments
  575. Match - #N/A
  576. How do I create a pivot table from multiple pages of data?
  577. Number of paychecks in a month?
  578. update cell in other worksheet based...
  579. excel
  580. How do I use a "check(ed) box" as a criteria in an "=if" statement
  581. Insert blank row and issue a sum
  582. URGENT - Help with choice of formula
  583. calculate a MEDIAN using multiple criteria?
  584. DGet vs VLookup
  585. flag date within a cell after 15 days have past?
  586. Check to see if a cell is populated
  587. Format not Really What It Pretends to Be
  588. Conditional formatting wth more than 3 conditions
  589. plot graph and place it in a cell possible?
  590. why does undo feature not work after value entered?
  591. aging formulas
  592. Subtract number of Working Days
  593. Update a Date Quarterly
  594. how do I protect a worksheet and still use a checkbox control
  595. Lookup min & column heading
  596. Find duplicates then calculate..???
  597. Maps of countries of the World.
  598. indirect function to reference cell on different sheet
  599. Can this be done? Conditional formatting
  600. Maximum If Help
  601. Control function for copy/paste
  602. Trouble with Image Control on a worksheet
  603. Average if Help
  604. Find the sum of Comma Seperated Values In a Cell
  605. DATE (MOD) Function
  606. Function to convert Time String to Time
  607. Need to be done in 2 hours!!!! VLOOKUP returning #REF for unique I
  608. Hyperlink function without openening new Explorer every time
  609. HOW TO CONVERT NUMERICAL VALUE IN TO ENGLISH TEXT
  610. How to protect different cells by diff. passwords?
  611. Using Vlookup to compare and validate data
  612. negative sumif
  613. woorkbook
  614. Triple occurence formula
  615. Function 2 divide a number (ie $1.00) by % (ie 25%) to = ($4.00)?
  616. My Quest with Time!!
  617. Validation for a cell
  618. Visible rows and functions that work
  619. Dedrie, FORMATTING SUBTOTALS
  620. Excel Formula help
  621. how do i copy rows using critera in a formula?
  622. Apostrophes instead of equals in Excel
  623. Identifying an item in one col/row and searching an entire spreads
  624. mailing labels
  625. RE: how to auto assign po numbers in Excel
  626. Work Schedule - Automaticaly filling name?
  627. Why cant I use =countif(Jan:Mar!$b3)
  628. How do I change the format of a cell based on what I input?
  629. Auto repeate parts of functions
  630. I have 12 scores over 12 weeks . I want to average the highest 5
  631. What do I need so I can open an Excel worksheet for editing?
  632. How do I convert a number of minutes into hours and minutes?
  633. Column Headers Not Fixed
  634. Can a worksheet date itself?
  635. Scrolling an Excel worksheet embedded in a Visio diagram with VBA
  636. links to same files in different folders
  637. SUMPRODUCT by Date (numeric) value
  638. Rank based on Totals
  639. filter/lookup question
  640. Formula needed
  641. USING NAMES IN FORMULAS
  642. Excel should calculate exponentials properly (right to left)
  643. Linking cells
  644. Nested If with VLOOKUP's and AND function
  645. complex?? Q about Conditional formatting
  646. transfer one worksheet to another worksheet without losing format.
  647. VLOOKUP - problem in stock request
  648. is there a way to add single digits within a single cell?
  649. how to auto assign po numbers in Excel
  650. text search help please?
  651. Finding a function in Excel
  652. HOW DO I ADD A PRINTABLE BACKGROUND IN EXCEL
  653. How to make "common factor" formula ?
  654. number cell increment +1 when dragging down box
  655. Formatting Subtotals
  656. How do you make calculations between different tabs?
  657. Please help!! Vacation Accrual Formula
  658. Hide Rows / Columns - complex question
  659. Problems with Copy and Paste in Excel
  660. Tricky maybe
  661. How can I convert a scanned PDF paper document into EXCEL format.
  662. MERGING COLUMNS WITH DUPLICATE INFO.
  663. wild cards in formulas and functions
  664. Hide columns & rows that contain "0" or blank in a range of cells
  665. How do i link Excel chart to Outlook automatic emails?
  666. Drop down list
  667. Formula help ... moving to next cell everyday
  668. Linking spreadsheets
  669. Formula to combine text?
  670. Pull down cell to access n&a spreadsheet
  671. Formula for incremental increase
  672. Need help adding :
  673. Vlookup problem
  674. How do I print two sheets in same workbook duplex?
  675. Formula to activate macro
  676. Setting Purely BLANK Cell
  677. Fourier Analysis
  678. Simple selection, but hey, I'm no guru!!
  679. hyperlink
  680. blocking cells
  681. copy text between 2 open workbooks via macro
  682. Selecting Random Data
  683. Help on ifsum
  684. Help - basic formula question
  685. Autofilter - Link to 2nd worksheet?
  686. how to reference external refereces from a list
  687. Excel Function With Multiple Criteria
  688. Adding the same cell in different worksheets. Can that cell be variable?
  689. time sheet calculations
  690. Whats the best way to...
  691. Problem with Find and Replace
  692. Vacation Accrual Formula
  693. Nested "If" Function
  694. Help for a newbie?
  695. sumproduct wildcats
  696. column won't sum
  697. Linking with equals sign doesn't always work
  698. sharing rows of data across multiple worksheets within a workbook
  699. Return unique fields only - but not a filter?
  700. re: Rand function
  701. Can I Somehow load a Spread Sheet thru a Scanner
  702. Average of count in pivot tables
  703. Linking changing values (cells) between worksheets.
  704. Tools - Option - "move selection after enter"
  705. GPA formula
  706. Formula to get Relative Folder Reference to data in another file?
  707. sum product problem
  708. Linking arrays and Worksheet names
  709. worksheets lookups
  710. Counting weeks
  711. Overlapping or Duplicate Date & Time
  712. How can I do a lookup and get multiple row results?
  713. count function not working, keeps displaying 0
  714. sumif function
  715. Drop Down button with functions?
  716. formula results take up to 2 lines if needed, but keep border
  717. How do I get the color format to follow the data when referencing.
  718. lookup with offset?
  719. VLookup
  720. How do I stretch the height of a font in Excel 2003
  721. Count nonblank AND fill color
  722. how to find duplicate cells in large array of numbers
  723. copy text from 1 workbook to another by macro
  724. How do I use the "Proper" function? The instructions are vague.
  725. Sort columns by content
  726. formula to divide a monthly bill...
  727. Conditional formatting a full row triggered by a single cell
  728. If formula evaluating 2 cells contents
  729. #Value must be 0
  730. worksheets vlookups
  731. Can I import a folder's contents as a dropdown list?
  732. Converting negative/positive numbers to a CSV (Comma-delimited .TX
  733. SUM, OFFSET and CELL("address")
  734. How can I copy a row as result of an IF function
  735. formula suggestion
  736. Is there an opposite function to "Concatenate" in Excel?
  737. Which function?
  738. Pay Stub Problem help PLEASE
  739. Reverse false and combine with true true value
  740. Need to merge columns
  741. formula to use when number of rows changes dynamically
  742. Saving onto Floppy Disk
  743. Row Sequencing
  744. Formula for incremental increase
  745. Create conditional IF to format cells using 6 different colours
  746. Conditional Formating
  747. Assign values to text
  748. How do I sort worksheets in excel? i.e. Order them by date
  749. sumif on 2 criteria with worksheetprotection enabled
  750. Formula for incremental increase
  751. Finding an Excel value using one repeating & another value?
  752. Finding an Excel value using one repeating & another value?
  753. customising toolbar.
  754. subtotal - multiple criteria
  755. Look up a value as close as possible to ....
  756. Conditional formatting
  757. formulas
  758. Can I make the number in one cell automatically appear elsewhere?
  759. Conditional formatting a full row triggered by a single cell reference...
  760. Month Counter
  761. Sum product -Is column value in range/list
  762. Conditional functions
  763. Missing linked file - can still be referenced but can't find it!
  764. the option to send an exle file as an attachment is not there
  765. excel, how do I get sumif with two criterias?
  766. how do I convert euro values to GBP in excel
  767. cell formatting?? and making it so that it will move to the first option on a listing
  768. How do I create an equivalent VLOOKUP function using FIND?
  769. Pivot style return
  770. cell equation ?
  771. New Data Consolidation Question
  772. time conversion frustration
  773. finding end of document
  774. data analysis on fields with words not numbers
  775. Using Excel link (hyper?) and list functions
  776. Find Min of a row, but only greater than zero?
  777. calculate odd days interest
  778. How do I calculate total hours by rate of pay?
  779. How do I convert Meters to Feet and Inches?
  780. Sumif with a twist?
  781. lookup and sum
  782. watermark
  783. Absoluet Reference
  784. text has numerical values
  785. 'vlookup' and/or 'if' help!
  786. Excel
  787. how do i use the proper command
  788. HELP HELP HELP HELP HELP
  789. IF STATEMEMNTS
  790. Unwanted rounding of large number
  791. Adding Column in an Excel Sheet by Command
  792. why formulas have stopped working in Excel?
  793. filter 15 worksheets so i can print all on one page
  794. day/month/year in incorrect format for date format
  795. Grouping
  796. all worksheets have 2 descimals
  797. when editing a comment box
  798. Combine functions into one cell
  799. Excel help
  800. circular drop down list on different pages
  801. product function
  802. MsgBox with condition and showing details
  803. How can i get an If formula in excel to edit another cell?
  804. Select by multiple criteria (Excel 2003)
  805. count and limit radio button selections
  806. I need a system for keeping up with church members and finances?
  807. unique alpha's in order
  808. a question of differences
  809. Sumproduct Problem
  810. EXCEL: Is there a way to insert a picture into a comment?
  811. results display in filter function
  812. Purge macros
  813. select a string of characters
  814. Running filters using a macro
  815. multiple results when using filter function
  816. collect data from different worksheet
  817. Copying formulas with mixed references
  818. conditional sum question
  819. Future Value
  820. Using COUNTIF
  821. Sum If or DSUM help?
  822. re auto cloring of cells
  823. IF on the cell that contains it ?
  824. CSV file importing to other software
  825. sum or similar with conditions
  826. I have saved an incorrect worksheet over the right one.
  827. Averaging across worksheets
  828. can an excel spreadsheet be set to remove all hyperlinks
  829. cell equation ?
  830. Using LARGE Function
  831. Can conditional sum use wildcards in the formula?
  832. Two cell accumulator
  833. Illinois Personal Information Protection Act
  834. how would I count dates (not # of days) in cells that fall betwee.
  835. date criteria to select range
  836. Can Conditional Sum use wildcards?
  837. if statement
  838. Remove variable text in cells
  839. vlookup
  840. I cannot edit my excel. How do I do it
  841. IF function?
  842. 1 will be City, 2 will be Roskill and so on please.
  843. Validation List, Automatic Colors
  844. 1=City, 2=Roskill
  845. Hiding Rows using conditions
  846. Minimum Value & Cell Cross Referencing
  847. help
  848. vlookup backwards
  849. Need help with a function I'm not sure exists
  850. How do I undo an action when multiple sheets are selected?
  851. Using certain data from lists in other cells in Excel.
  852. Compare Data
  853. DATE Format
  854. simultaneous entry lookup problems
  855. Data Validation
  856. Kilometres Calculator
  857. insert verticle lines between columns
  858. Email only the filtered data
  859. Creating & Combining Macro to Functions
  860. Calculation
  861. How can I rank numbers based on other numbers?
  862. sumif and colored fonts..
  863. Multi-conditions with SUMPRODUCT and COUNTIF
  864. How can I get the XIRR funct to work for a positive first number?
  865. Look up function and Max function
  866. How can I return a cross referenced cell value?
  867. Thanx David
  868. V-Lookuo
  869. Count values in a cell
  870. filling information from one cell and filling another.
  871. Automate the Text Import Wizard (Fixed Width)
  872. Unique Values
  873. Delete text while numbers remain intact
  874. Array index, match problem
  875. colors
  876. substitute for =
  877. Compare Text in 2 worksheets where verbiage is slightly different
  878. How do I use the PROPER function?
  879. =concatenate With A Space
  880. Add items in column 3 if column 1 and 2 conditions are met
  881. Extract data from one Worksheet to another
  882. AND function in Excel
  883. Timesheet Date Calculation
  884. VLookup Problems
  885. Can wildcards be used in the Logic Test of an Excel "IF" function?
  886. NUF schedule
  887. IFSUM
  888. How prevent formulas to get external references/path to current workbook?
  889. excel date problem
  890. How do I change the number on copy sheet so I don't have to renam
  891. How to do matrix operation with complex number elements in Excel
  892. if functions
  893. Formula to determine shift
  894. Subtracting dates?
  895. formula
  896. Problem with formula in Excel
  897. NEED HELP! Cannot figure out complex function
  898. "IF" Function limited to 7 in a formula.... need 14
  899. Question about {}
  900. colums in uppercase only
  901. Payment formula problem..
  902. how do i count how many people are working between two times in e
  903. DSUM gives a #VALUE! error and I can't work out why!
  904. SUM.IF...probable fingertrouble
  905. Sum function across multiple sheets
  906. How do I set up an automated numbering system For my "Invoice Num
  907. First Number in a Cell
  908. PorductLog
  909. HD I build funct @if cell=AorBorC then ...else if cell=DorE then
  910. Dividing by unknown to get a number
  911. Microsoft Excel 2000 Subtotals with Group Name
  912. How can i swap between the tabs in excel?
  913. cell equation ?
  914. Complex =mid formula
  915. Excell:Move from any Cell Sheet 1 to any cell Sheet 2 etc.
  916. Displaying info in a new tab in excel
  917. time math
  918. countif question
  919. Data From One Worksheet To Be Used In A Cell In A Different Worksheet
  920. Array Formula? Lists?
  921. formula that will subtract a number that relates to text
  922. Removing Duplicates from a list
  923. Look up function
  924. Whats the best way to...
  925. Need help with Excel formula!!
  926. Test IF Two Numeric Values Match (from two separate Dynamic Ranges)
  927. How do i keep a running balance without adding rows each time?
  928. IF(ISBLANK)
  929. If(ISBLANK)
  930. Whether 3 diff fields are blank determines several different resul
  931. How to hide unused cells when running accumulated totals
  932. Modifying A Formula
  933. Future Value of single investment
  934. Display single value for multiple ranges?
  935. Adding an ongoing value to an Average
  936. I there a way to not print a cell(s)?
  937. How do I expand columns in a table and auto change vlookup in wrks
  938. Stumped by a lookup scenario
  939. adding zero's to a text cell
  940. how do I format a cell reference to move as source changes
  941. Summing a column
  942. Removing $$ Reference in cells
  943. Excel & MINITAB generated regression equations are different
  944. Array formula returning terminated employees
  945. ENTER DATA EXCELL SO RELATED DATA APPEARS
  946. need help with formula
  947. Setting up page template
  948. adding day (sunday, Monday) to date
  949. How do I set up an array using countif for 2 separate arguments.
  950. How do I use a conditional (IF) statement in Data Validation?
  951. Consecutive numbers in 1 cell
  952. editing custom dialog boxes
  953. Use Range Name in Macro
  954. variable across all worksheets?
  955. MATCH Formula
  956. I want to link, not just copy,Word source text to a text box in Ex
  957. Using a cell reference of a sheet in Vlookup
  958. Sumproduct Formula
  959. Vlookup question
  960. Auto Filter
  961. Changing the max length of a worksheet name
  962. excel function cumipmt
  963. "END mode?"
  964. how do i maintain one worksheet from data from multiple worksheet
  965. Step value
  966. Need Address Formula
  967. differences in groups of numbers
  968. HELP: How to Repeat Cell Content into a Second Worksheet ?
  969. Listing data from multiple worksheets
  970. cell shows 20. Formula shows 20. why not 540/27
  971. How do I use wild cards in nested array formulas?
  972. Troubleshoot resetting hyperlink base to a network drive
  973. Line adherence
  974. Running a Daily MTD average.
  975. INDIRECT(ADDRESS... Across worksheets
  976. How do I remove hyphens from a product UPC?
  977. How to save a custom header/footer on ea. sheet of a workbook?
  978. How to use the "Fr" function, what is agrument
  979. Identifying Cells with formulas
  980. Date Function
  981. Conditional Formatting?
  982. Create a Macro to jump to next cell
  983. Functions
  984. merge multiple row cells of text corresponding to one row of data
  985. Count blank cells since last entry
  986. sorting cells according to all cells in column A
  987. Can I change a cell and cause an automatic change in other cells
  988. VLOOKUP
  989. Pivot Tables
  990. Help to find duplicate #'s
  991. Adding dates to get a date
  992. DATA/VALIDATION/SETTINGS
  993. Stock qoute quiry in Excel 97 doesn't work
  994. Macro Help
  995. Display each row as one recrd per page
  996. How to convert DATE and TIME to text
  997. Excel worksheet function that will return the currency for a cell
  998. Look up for all sheets
  999. Excel help!
  1000. Working with Lists in Excel 2003