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

  1. Highliting Duplicate Cells across multiple rows
  2. Need help with formula
  3. counting instances of specific times in fields with date and time
  4. How do I format to currency when number includes cents?
  5. Formula Help
  6. Copy a formula down a column
  7. Conditional Format Issue
  8. Formula for cells that contain a specific letter
  9. Convert Total Hours and Minutes to Whole Number
  10. If Statement???
  11. updating a spreadsheet in 1 field w/ out changing values in anoth
  12. How do I condense 3 columns into 1 in Excel?
  13. use the current row in a list to populate a report
  14. How do I make the true return a drop down list in the IF function?
  15. if "a" selected from dropdown menu then show "K" in other cell
  16. lookup single value in entire worksheet
  17. functions
  18. VLOOKUP works in some cells but not others.
  19. Merging data from Multiple Worksheets
  20. Can you print indicators when inserting a comment?
  21. Conditional Format - 3 conditions
  22. pivot table field list
  23. How do i calculate the total revenue in Excel?
  24. My Datedif function only returns 0's in the cell what's wrong?
  25. Nesting Networkdays function inside and If function
  26. How do i find a correlation between 2 data point or sets?
  27. Is there a way for Excel to create a task in Novell Groupwise
  28. Public Macro Help (CFColorindex)
  29. Can the "Date Picker" from Infopath be used in Excel?
  30. combining two lists
  31. Importing data into excel
  32. I NEED A FLEXIBLE FORMULA
  33. Ranking based on two columns
  34. Nest a referenced formula in excel
  35. Is there a way to post a file to show an example?
  36. Can you make a cell = 0 if original function is creating a"#ref!"?
  37. ADDRESS Function
  38. Is there a go to function in excell
  39. Duplicate listing
  40. sumproduct/countif function help
  41. Questionnaire sheet: Select "yes" or "no," and only one can be selected
  42. Can sumproduct do two {x,y,z} arguments?
  43. Vlookup Q
  44. Sum if 2 conditions are met
  45. Chart from different worksheets
  46. Count Unique Entries
  47. Stake calculator
  48. Convert text in cell to a range name for formula
  49. 2 column lookup - match to date range
  50. Formula for rounding a column of currency to a multiple
  51. Sumproduct Date clarification
  52. changing the year of a date
  53. formula link to a file
  54. how do I round numbers in .125 increments
  55. data entry in excel by linking to other word doc. or excel sheets
  56. Copying problem
  57. Can't get CUMPRINC to work. Have Installed Analysis Toolpak
  58. Excel Programming
  59. Lookup and compare rows
  60. How can I set up a milestone report with red/green/amber alerts
  61. Little help with weibull function needed
  62. Comparing and counting occurences in 2 columns
  63. seeking of array
  64. how do i use import to consolidate data from multiple sheets
  65. MSN Stock Quotes Excel plugin broken?
  66. Answers needed for challenging formula
  67. Formula too long - Shorter version?
  68. how can update the data in an excel workbook without opening it
  69. increasing and decreasing a value in a cell
  70. TRIMMEAN with different percentiles?
  71. SQL.REQUEST not working in EXCEL 2003
  72. Copy cells, preserve cell size
  73. need to ONLY display worksheets that have had recently changed
  74. Macro help
  75. Excel Formula or tool to compare two columns of data
  76. Data consolidation from Multiple Sheets
  77. copy data from various sheets into one sheet
  78. Viewing data in Excel while scrolling. Instead of the cell count?
  79. CountIF() in Worksheet B while referencing cells in Worksheet A
  80. CountIF() in Worksheet B while referencing cells in Worksheet A
  81. order formulas are updated..
  82. Changing Text format in a function
  83. sumproduct question - kind of...
  84. Create number format for 4 digit integer preceded by zero
  85. Another time addition problem
  86. Insert Subtotal button
  87. VLOOKUP - 2 Questions
  88. count function help
  89. Lookup different sheets and get the value from the sheet specified
  90. Match/Index Returning #N/A
  91. Sum if need help
  92. address() function
  93. Screening one list for data
  94. Help with a function button within a cell
  95. cell format changes when formula copied?
  96. find and replace - replace data in rows to separated by commas
  97. why am I getting a #VALUE! error?
  98. Check for Duplicates
  99. Insert blank line macro
  100. percetile function limitation
  101. CountIf by Month-to-date
  102. Count If 3 Criteria Met
  103. INDEX and MATCH in one formula...
  104. Conditional formatting if value in cell is found in a named range
  105. Find max number of character and return cell address
  106. Values not updating
  107. Prevent user changing pivot chart layout
  108. Excel formula
  109. How can I alter the rounding rules?
  110. assigning points to rankings
  111. lloking for an easier way to count
  112. Hide used names in drop downbox.
  113. accumulating values generated daily
  114. How to define table size
  115. Adding percentage as interest to a total
  116. Filter arrows freezing!
  117. ranking with some blank spaces
  118. hyperlink using cell contents
  119. how do I use the solver to solve polynomial equations?
  120. running total from the same field on multiple sheets as i add she
  121. Mortgage calculation after a large extra payment
  122. Help! With SUMPRODUCT
  123. How do I get the largest number in a sheet to stand out on it own
  124. end result
  125. test a range of cells and return an adjacent value
  126. Deleting formula in data validation list
  127. template timer stopwatch
  128. a h.s.l.@ £3.80 mtr & 10sq m are fitted whats the formula help
  129. Change source ofr edit link is greyed out
  130. Auto sum
  131. testing. do not open.
  132. How do I type this so excel recognizes it?
  133. using worksheet name
  134. exponentials
  135. How to obtain both std dev and std error mean in each y error bar
  136. Adding or combining time problem.
  137. Need a loud/bright warning before making changes.
  138. Can I use IF function in calculated fields in a pivot table?
  139. Protected worksheet with unprotected cells i.c.w. remarks
  140. How to equalise loans by ditributing funds
  141. Countif using the same cell on every sheet
  142. anti logarithm function for base 10
  143. Nested Ifs
  144. Parse data where break is a first uppercase character in a string?
  145. Recording a high price on a worksheet
  146. Fill with zero
  147. Unable to paste a formula into other cells
  148. Tables, How do I make new info push existing info to the next row?
  149. loan payment
  150. Lookups
  151. Search a random array of cells and return a value of "X"
  152. Total width of several columns.
  153. Measure length of an AutoShape Line?
  154. days between 2 dates
  155. T-Account templates can be found where?
  156. Switching Subcategories into Categories and Vice Versa
  157. Drop down categories in Excel
  158. IF Command
  159. function to populate different cell
  160. Help needed with conditional formatting and adjacent text
  161. Establish formula for multiple logical_tests
  162. Changing date from =NOW() to Creation Date
  163. Pull information based on a range of numbers
  164. How can I add 3 years to date 03/05/2003
  165. Index and match among sheets
  166. excel conditional formating decimal fractions
  167. data from 1 sheet to the next
  168. Sorting two columns (again)
  169. Text manipulation
  170. drop down lists
  171. Text to columns
  172. IF Cell Contents Start with STRING
  173. Returning a sum when looking up two different values
  174. How to best monitor threads on this site
  175. list box
  176. Display missing Part Number if Column A does not match column B
  177. formula for matching text
  178. one criteria/mult. values
  179. How to create a New system function
  180. AND in an array function?
  181. VLookup Error in Part of a Named Range
  182. Calculate 2 Standard Deviations
  183. vlookup is returning a value one cell above the correct cell.
  184. How to pull cells from other worksheets including color/comments?
  185. converting a string of information into excel cells
  186. Returning value based on input data
  187. Sum & VLookup
  188. Dragging Conditional Formatting
  189. centre across selection shortcut
  190. Finding/removing duplicate names in a worksheet
  191. IF condition
  192. Rolling Forecast
  193. returning a cell name
  194. Which formula?
  195. Summing one column if two other columns' values appear in other sh
  196. Option Button - multiple selected
  197. How can I add additional rows beyond the 65,536 in excel 2003
  198. Counting dates, within a list of dates
  199. how do you setup a table
  200. Finding the date on the 'nth' Monday in this Month in this Year
  201. calculate the p-value for a negative t-value
  202. create pivot table with master/detail data from 2 worksheets
  203. look up a value
  204. Formula to figure bonus
  205. functions/formulas
  206. Is there a fluctuating payment loan amortization template in XL?
  207. Looking-up Columns w/calc'd Values ONLY to Calculate Average
  208. LOOKUP function not returning expected value - Using vector_lookup format
  209. Correct answers like a quiz
  210. how do i create a customised numbered list in excel
  211. what is the problem, when value comes up in the total column
  212. Excel User Conference - Registration winners
  213. Subsequence of characters
  214. external data function error-MS Query
  215. how do i use excel's natural log function with negative numbers?
  216. Calculating p-value from Fisher's Exact Test for XYZ parameters
  217. Conditional Concatenate
  218. How do you dedupe a list in excel with parameter?
  219. Sum Count of Numeric Criterion for LAST 5 Rows
  220. lists
  221. How paste text from note pad to excel w/o using (Text to column) f
  222. automatically updating summary worksheet
  223. Bug in days360 function
  224. Advanced Filter w/ multiple sheet List Range
  225. Excel Help Needed......
  226. Count Records Between A-K and L-Z
  227. Please help w/ nested IF that returns a #N/A.
  228. how do I fix my 'if' statement?
  229. Vlookup referencing one column that contains part numbers in both.
  230. In Excel is there a function to change a cell's background color?
  231. Lookup in data from external datasource
  232. How do I delete extra blank pages from an excel worksheet?
  233. how can i change my sprdsht to list info from colums into rows
  234. how to catch the second or more cell with vlookup
  235. Carrying a balance forward
  236. Excel should have row column highlight indicator
  237. Excel file window won't open
  238. how do I paste without EXCEL increasing the cell number ?
  239. SUMPRODUCT
  240. Return a formula as text string to a cell
  241. transposing question...
  242. vlookup range changes
  243. Hi people views once what I received:
  244. Hi people views once what I received:
  245. in excel, can i set varying CELL widths that are in same column?
  246. Fix Simple #Div/0! error
  247. How can I create a link between cells in two separate Excel sheet
  248. Link worksheets
  249. How do I calculate the midpoint date between two dates.
  250. create links to check boxes marked "good" fair"and "bad"
  251. Excel should have unhide all worksheets selection or button.
  252. Can you ID a cell that has both Alpha AND Numeric characters?
  253. “Count” occurrences of two conditions on the same row
  254. CREATE AN "IF' STATEMENT FOR CHOICES OF CHECK BOXES
  255. format cells for color
  256. Data Validation and named lists
  257. Contional Formatting - other cells
  258. text fields in pivot tables
  259. auto correct numbers with dates
  260. Counting values lower then the median.
  261. Lookup from one spreadsheet that links to matching keys in another
  262. How do I compare two values to calculate a total?
  263. Count data based on past dates
  264. Using a formula on cells containing results of formula How?
  265. Copying Data to next available empty cell in cloum
  266. Conditionals
  267. Updating links from one worksheet to another worksheet
  268. COUNTA for a cell with a formula
  269. How do I use conditional formatting to hilite weekend dates where.
  270. import txt create sheet name
  271. adding days correctly
  272. How to set the row for title to be fixed during scrolling?
  273. Sumif Command
  274. how to make formula
  275. simplify equation
  276. Function Needed! Please Help!
  277. Need help setting up a spreadsheet of some sorts.
  278. i have two days and i want the difference in days, months, year
  279. Custom functions calculating time arguments Help Desperate
  280. Update Spreadsheets
  281. Concatenate two columns?
  282. minus sign
  283. VBA
  284. saved worksheet opens in new with macro error report
  285. Column picked randomly with probability relative to number of entr
  286. Where's the plain old database functionality?
  287. comments issue
  288. countif non blank cells + dates overdue
  289. Sum and Divide Formula error
  290. Copy Row based on a condition
  291. Use MOD?
  292. Keeping formulas on running total and sorts
  293. how do i lookup the value of the next cell excluding the first lookedupresult
  294. LIST DATES IN MONTH ORDER
  295. Workbooks
  296. cond format
  297. bring up list
  298. How do I format a cell so that I can only input a Y or an N
  299. lookup function
  300. Excel functions which support arrays (SHIFT-CNTRL-ENTER)?
  301. How do I count cells that contain one of several specific numbers?
  302. How do I exchange cell information; simply swap locations?
  303. Sort
  304. how do I compare two dates?
  305. school project ..please help
  306. EXcel Capture Data into one cell
  307. school project ..please help
  308. automatic calculations
  309. Excel
  310. lookup function
  311. How to trim spaces from entered text in cell using exisiting functions?
  312. SumIf
  313. find nearest help
  314. Multiple Vlookups & IF statments
  315. Vlookup while pulling a cell color and comment
  316. Calculating Dates Using Different Values for NETWORKDAYS
  317. Excel: Find repeated items and be able to delete quickly, option.
  318. Need Excel Formula/Function to color cell interior
  319. conditional formatting issue
  320. How do I combine data from several sheets into one main sheet?
  321. Drop down lists and vlookup? or Match?
  322. Fractional Workday Function
  323. True or false
  324. SUM a named range
  325. IF function
  326. How can you sort a worksheet which has embedded lists?
  327. VLookup?????
  328. "NOW" or "TODAY" date function
  329. Data alchemy
  330. Using FIND function to locate space between first and last name
  331. How can I subtotal a row that gives me =SUM(Q3:X3)
  332. excel storing previous cell values in memory
  333. Hiding sheet in a workbook
  334. check boxes in the forms tool bar
  335. can someone explain function 'ara'?
  336. How do I sum totals from mulitple worksheets
  337. Why doesn't this nested IF statement work?
  338. Is there a macro or function to convert values to it written text
  339. Merge Rows depending on value of the first column
  340. Inoperative merge function
  341. How do you add a blank line automatically after the Subtotal line
  342. Combining worksheets on a unique key column
  343. Countif time is between two nominated times
  344. link with date to data worksheet
  345. What does the 0 in the formula 'Yr 3 Op'!G2,0 mean?
  346. How to create menu for listed names?
  347. Automatic filtering and coping result to a seperate sheet
  348. Summarizing data on one main sheet
  349. Check 2 different list get associated value from a column
  350. option buttons
  351. Validation Data
  352. AutoFilter list problem
  353. vlookup function addressing
  354. Referencing sheet1 from sheet2
  355. How do I open worksheets in different screens, like Word??
  356. How to set a formula to convert the time zone
  357. linking data to a form
  358. Expanding on a formula
  359. How to find duplicate data in two tables,then listing it?(Excel)
  360. Value depends on comination of 2 columns
  361. Disabling an 'on load' macro
  362. How to find duplicate data in two tables,then listing it?
  363. how do i get the equal sign on my formula bar in excel
  364. Counting unique values with criteria
  365. Setting Conditional Formatting
  366. Circular:G4?
  367. VLookUp function to return multiple rows
  368. Deleting Row Macro
  369. time data as number
  370. how do i create form of yes/no answers for mass e-mail sending
  371. workbook code
  372. Lookup a value between two numbers
  373. Combining IF OR and AND functions
  374. Combine Cells
  375. Is this possible with a macro?
  376. How do I stop cell borders dissappearing when pasting data?
  377. What
  378. Issues copying excel charts to word documents - using Excel VBA
  379. What function/formula should I use?
  380. Conditionsl Formatting
  381. write a "if" command. day of month + remainder
  382. number rounding
  383. If, then formula to capture data?
  384. Want to change current prices in a column by a percentage
  385. vlookup
  386. vlookup with linked cell references
  387. Change fmt of a cell if number matches any in a range of cells?
  388. If function
  389. Data transfer from a template to a workbook
  390. how can you put a background in certain cells
  391. Msgbox experts please reply..
  392. Function - counting based on criteria
  393. how do I display number in thousands; i.e diplay 123,500 as 124?
  394. Vlookup and hyperlinks
  395. In Excel - how to delete new window created from window on tool ba
  396. Re: Average Non-Adjacent Cells in Budget Spreadsheet
  397. Average Non-Adjacent Cells in Budget Spreadsheet
  398. Summing specific cells on two worksheets
  399. Median Formula In Pivot Table
  400. Help for a newbie... please
  401. How do I format a formula to recognize multiple comparison factors
  402. Template Wizard/Excel as database
  403. Multiple worksheets within a workbook
  404. Formula for determining if two date columns fall within specific date range
  405. Insert a imge to a single cell
  406. how to create a sorted summary list of counted species
  407. Index not Reurn the correct Result
  408. Worksheet button to send as attachment
  409. Pivot Table Formatting
  410. Letters and Number formulas
  411. Importing information from 2 workbooks into a 3rd one
  412. Counting text strings
  413. How do I stop VLOOKUP from asking what spreadsheet to look in?
  414. passing excel certification
  415. > but < subtotal (3,...) or countif
  416. Pivot needs BOTH cur/cum totals w/out extra cum cols/repeat lines
  417. IF statement problem
  418. Excel Tips
  419. Calculations
  420. Edit and Array
  421. Excel formula to move certain fields
  422. transposing an array converts dates into numbers
  423. How do I create a formula where a cell is automatically shaded ?
  424. Suggestion to add Auto Filter option for columns
  425. WEEKDAY Function?
  426. How to stop a general format cell
  427. funtion to determine the fraction portion of a number?
  428. Macros?
  429. Monthly NPV
  430. automatically making a copy of a sheet
  431. automatically making a copy of a sheet
  432. Comments box position
  433. How would i setup a breakdown method for my business?
  434. Spreadsheet formula question!
  435. Criteria Range at two different places
  436. DFunction + Print Preview = Slowdown ???
  437. Count items when specific text and date criteria are met
  438. Can someone help with this complex formula?
  439. Pivot Table Row ?Grouping? Question
  440. how do i enter a formula in excel that will change a cell value
  441. how do you add up alpha???
  442. List from a table
  443. Anyone actually get Case statement to work ... ?
  444. Please help with a 3d formula.
  445. hyperlink to sheet in formula, can't save under new filename
  446. Need help find automate way to cross reference two GAINT excel databases!!
  447. Semi Annual Counter
  448. Years of Service Calculation
  449. conditional sum formula
  450. Working with dates
  451. If Sum Countif Function
  452. How do I convert a list of data into mailing labels?
  453. Sumif between values
  454. thin # of samples by averaging
  455. problems with vlookup
  456. INDIRECT Function
  457. Can I use the IF Function?
  458. Countif Problem
  459. Lookup and List Results
  460. Another "working with dates ?"
  461. Unable to break links
  462. Fuction that gives number of days of a given month
  463. filtering
  464. Excel Data not showing up in Query
  465. how many calculations?
  466. can you use the match formula to look for two different values?
  467. how do i retrieve overwritten Excel file
  468. Tricky comparing question
  469. Cost times amount (if populated)
  470. Average outage time?
  471. same data from one cell copy to multiple sheets
  472. Uppercase
  473. Data Query will not Refresh automatically
  474. Copyin text only...not borders or shading
  475. sumif across multiple sheets
  476. Need a count
  477. how do i get excel on my loptop
  478. calculation to ignore a 0 (zero) value
  479. How do I create a tip calculator chart?
  480. if function
  481. if function
  482. Please Help...
  483. When I SaveAs, the hour glass does not go away, nothing happens
  484. How to extract value from a different file?
  485. can i prevent duplications in cells
  486. Selectively Clearing cell contents
  487. Multi-Column Dynamic Named Range...Is there an easier way?
  488. VLOOKUP Returns Erroneous Value When Control Data is Variable
  489. FIFA World Cup 2006 Office Pool
  490. How to create a 'dynamic' formula?
  491. Could any one Explain this Formula
  492. how can I add a picture into protected worksheet?
  493. Inserting new rows
  494. How do I copy only values of cells when they are enterd?
  495. engineering functions
  496. rolling average
  497. referring entire page
  498. sumproduct doesn't work
  499. If function
  500. Auto calculate for date + days forward to yield new date
  501. Conditional Formatting Q
  502. Using the answer IF "true" in another formula?
  503. Zero Values in Charts
  504. Dialog box with worksheet information
  505. Add items to context menu
  506. Change hrs&minutes into mins
  507. merge 2 spreadsheets info to 1
  508. can we convert "2 days 16 hrs" to " 64hrs" using excel functions
  509. Deriving mathematical equations
  510. Simultaneously updating Charts in Multiple sheets
  511. copy value of cell from last entry in column
  512. I want any date 90 days or older from current date change color
  513. Auto Filter with Protected Worksheet
  514. Insert new row in 2 worksheets
  515. Oooh, I guarantee you are going to have fun with this one.
  516. Dont include in sum if cell contains this value
  517. shortcut key to move to beginning of new row
  518. Transferring contents and color of cell
  519. inserting a space in a number
  520. Chop off parts of the statement
  521. Take fraction out of the figure
  522. Formula not Return Required Answer Q
  523. Fill in Date problem
  524. Transfer only information under todays date
  525. Transfer data relevent to date
  526. Invalid Formula with the use of Indirect
  527. retrieving old messages from this newsgroup
  528. How do I get a combo box to calculate percentages in Excel?
  529. Formula to look for value in a row depending on unknown value?
  530. I want data to show in the cell only when the info is inserted
  531. Conditional Formatting
  532. lookup value and return result in column to left
  533. Excel Coding Error!
  534. Splitting firstName from Surname
  535. Removing The N/A from showing in open fields
  536. Change font/cell color by Formula
  537. Do I need a macro or just a function?
  538. need formula advice
  539. Excel sheet scroll bar options
  540. Timesheet
  541. Normal Text in Formula
  542. counting problems
  543. how can i recover an old saved spreadsheet
  544. Need difference between two dates/times in hours
  545. Excel - filtering, sorting?
  546. How to use a very big formula
  547. Last non-blank cell in a row?
  548. Combining Pivot Table Source Data
  549. Speed up calculation of a worksheet that contains formula
  550. HOW TO PREPARE SUMMARY OF DIFFERENT ITEMS IN ANOTHER WORKSHEET?
  551. Trendline
  552. Index? Match? Function to sort and return value fr diff column in
  553. to compare sales plan vs actuals from two different worksheets?
  554. Displaying pivot table detail
  555. Create a conditional formula to replace
  556. Querying 2 Excel files
  557. Remove content of last visited pages in "Insert Hyperlink" dialog
  558. Round near to Zero
  559. Analyze with Excel from Access
  560. replace "." with "/"
  561. Use VLookup for range of cells, but with a twist
  562. How do I add (=Sum) the same cell for multiple sheets (103)
  563. How do I print a filename at the end of the file (not every page)
  564. VLookup across Workbooks?
  565. SumIf Help
  566. Excel Workbook Problem
  567. How can I use spell checking in a protected worksheet?
  568. Fillable form loses fillable fields when emailed - how do I fix
  569. Another zero question
  570. Vlookup "Value Not Available" (#N/A) Error
  571. how can I make this work? =LOOKUP(A2,{any number},{5,6,7,10})
  572. Format a cell to recognize data and change font colors accordingly
  573. ranking over a sum
  574. Variable worksheet name
  575. creating checkboxes from forms tool bar
  576. Multiple If/Or Statements
  577. If/Then Forumla to create blank cell???
  578. keeping a running time for tv program
  579. Numbers of boxes of fruit to buy
  580. How My If Or Statements
  581. Moving from unlocked cells to unlocked cells in an excel form
  582. 1st Monday of a month in date range??
  583. Formula Will Not Evaluate
  584. Correct Format for formula
  585. Why does formula show rather than results (not in text format)
  586. Comparing against first non-blank cell
  587. weeknum for month
  588. Data Validation - Drop Down
  589. Need how-to or example for data consolidation
  590. Excel and Word
  591. CountIF columnH2-H101 the number of time between ages 20-29 occurs
  592. Vlookup Function Arguments are correct but nothing in cell
  593. Formula help!!
  594. Formula question
  595. best and worst outcomes
  596. Count Non-Blank Rows
  597. Formula for % of "yes" in range of cells?
  598. Filtered Cell Question
  599. what happened to =networkdays(a1,a2) in office 2003?
  600. Arrangement problems.
  601. And,if,true Help
  602. Excel "mode" function returns different results based on sort orde
  603. Taking age group Ie ages 20-29 and picking out net sales for group
  604. "IF,THEN, DO) any help
  605. Formula HELP!!
  606. Hyperlinks
  607. Number of character in one cell.
  608. Can excel alphabetize a list of names?
  609. SUMPRODUCT vs. COUNTIF -- Why does one work?
  610. 'null reference' when trying to use WorksheetFunction from C#
  611. Sorting a Worksheet using Capital letters
  612. if then /lookup function
  613. What does ! do in an Excel formula
  614. struggling with index/match
  615. HOW TO CREATE DIFFERENT GROUP AND OUTLINE IN EXCEL
  616. How do I apply color in cells ..color now shown only in print prev
  617. Formula help needed
  618. what is the formula to convert time (3:46) to total seconds?
  619. Summing all BUT one...
  620. logical test, array, text and numbers
  621. Data and the "IF" formula
  622. Filter function
  623. Hyperlink
  624. VLOOKUP? Or another function?
  625. Use Vlookup to find less than today
  626. vlookup in excel have alternative result than #N/A selectable
  627. Countif, two criterias need help
  628. How to combine milliseconds with date/time reference and display?
  629. multi conditional searching
  630. Counting cells if special criterias are true
  631. convert military time to regular hours
  632. Workbook protection
  633. How do I write a formula to convert numbers to written text?
  634. making a list ?¿
  635. Problem with VLookUp Function
  636. Text to value
  637. how to locate local excel expert
  638. auto numbering macro
  639. day of the week dates
  640. Quickbooks exports to Excel, cleaning up the mess afterwards
  641. How do I sum data in worksheet 1 to be placed in worksheet 2?
  642. Finding 13 character codes in text strings
  643. min function
  644. How can I create a customer database to use with an invoice?
  645. perform calculations using time arguments
  646. How to find a row since I found a value in a column? see example
  647. Excel formula?
  648. Average data with date and if constraints
  649. How do I use vlookup with two lookup values?
  650. Random Matching
  651. If(and(function help)
  652. Convert data into proper time format
  653. How do I perform a concatenate?
  654. Lower case
  655. How to create a constant total column in Excel?
  656. How do pivot table source fields automatically create tabs
  657. Count # days
  658. INDIRECT !@%?
  659. show the sum of an arbitary selection of cells
  660. i have to add cells evenly spaced, eg a1 + a11+a21+...+a991
  661. SUMIF Question
  662. more help with min
  663. SUMIF((U:U,"ITEM#")AND(A:A,>4/01/06 AND <6/31/06),V:V)
  664. Hide previously used items from multiple drop lists
  665. Excel needs to be able to cascade in multiple windows like word!
  666. How do I create a Macro to sort data and insert blank rows & subto
  667. How can i protect...
  668. Adding columns of times
  669. How can user move in locked worksheet but not copy cell contents?
  670. INDIRECT function
  671. How do you divide two cells in a pivot table to equal a %?
  672. excel payments functions
  673. Help with SUMIF formula Please
  674. Data depiction/transpose and retain formulas
  675. deleted work sheets - Excel
  676. Formatting cells in Excel does not work
  677. Setting up columns based on a date
  678. autosort
  679. Copy formula
  680. Optimal material layout
  681. Copying links
  682. Divide selected cells by 1000
  683. Option Button Help PLEASE!!
  684. I need a formula in excel
  685. writing a greater than/less than formula
  686. how do i link merged cells to a merged cell in another worksheet.
  687. Why is the scroll bar way too big for my document?
  688. Calculations Based on Format
  689. can you tell me how to embed a pic for paint into an excel cell
  690. what function best to use
  691. Excel help (time and 1/2)
  692. macros
  693. generate a random number and use if function to generate new data
  694. Code to get text from part of a cell
  695. Creating shapes from given criteria
  696. sheet line bottom of page missing
  697. A letter to generat a number when entered into anywhere on the spr
  698. How to know Rank Of FieldName ??
  699. Date Question
  700. Matching and calculating 2 worksheets
  701. Function THat wIll Add COntents Acorss Worksheets
  702. Insert Excel hyperlink to word document
  703. How to perform 2SLS with excel
  704. How can I move several columns of words into one column in Excel?
  705. Looking up text...
  706. Searching for codes in text strings
  707. Another Conditional format question
  708. Increase with condition
  709. increase number with 1%
  710. MMULt Worksheet Function
  711. Increase excel worksheet vlaues by a percentage
  712. my password quit working in an excel workbook, help!
  713. How do I save a custom footer to use in other worksheets
  714. How do I define a range using values in cells?
  715. Need to convert date to "day of the week only"
  716. Formula
  717. chart wizard
  718. validating
  719. data
  720. How do I dsiplay changes in my cell
  721. Matching a value that appears multiple times
  722. I am doing a calculation in excel, I am multiplying a figure by a
  723. CANT USE MY FAST KEYS EG CRTL+` TO FIND FORMULAS
  724. How do I display negative time values in excell?
  725. how to change figure to words
  726. CONCATENATE Cells Formated as fractions
  727. Replace ^ in web query result
  728. Automatically updating a formula
  729. maximum number from a text range
  730. MEDIAN, STDEV of a range IF another range = specific value
  731. Where can I go to learn how to create excel formulas?
  732. problem with ISNA and VLOOKUP
  733. Can someone help with this formula?
  734. CSV file
  735. excel, automatic date and time when info gets entered
  736. Subtotal
  737. Worksheet_Change - NEW to VBA
  738. Remove empty cells from named list / validation list
  739. INDEX / MATCH with SUMIF/COUNTIF/SUMPRODUCT Statements?
  740. If error function
  741. How to addthe last cell in the last column across multiple workshe
  742. Combine and sort
  743. Finding, Replacing and Cut & Paste
  744. Displaying unique entries from a filtered list
  745. Dollar Ranges
  746. How do I make a "Worksheet_Change event" to show any changes to cells?
  747. Using Vlookup in a string search of a cell
  748. how to convert single digit to month name
  749. why don't my totals change when I enter additional data?
  750. datevalue()
  751. Counting dates greater than a certain time period
  752. Paste and Paste Special command are not enabled in Excel
  753. IF formula
  754. Big Sumif
  755. hyperlink
  756. how to display numbers in thousands i.e display 10,000 as 10
  757. Creating Formulas
  758. select cell value based on value in adjacent cell
  759. Clear History
  760. creating formula
  761. one step update
  762. Find Numeric Criterion in Column & Return the Numeric Value from Row above
  763. adding name values
  764. Count Unique Values
  765. aps3 calculate diff in time and cinvert into another format
  766. VLOOKUP
  767. formula between worksheets
  768. vlookup and a function field input
  769. VLOOKUP Issue
  770. we need to make it print one copy, not three
  771. Data Tables
  772. Proctecting certain cells
  773. Muliple formulas
  774. Links not updating in shared workbook
  775. Convert column to row
  776. average
  777. Filtering Data with Rank Function
  778. Average
  779. auto recover - can this be set on a Global basis?
  780. HOW TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER?
  781. Match, Find?
  782. Complicated Question
  783. Counting dates in a RANGE (yargh!) :)
  784. What function would move a closed record to another worksheet?
  785. average function
  786. Need help calculating formulars
  787. Improved Excel functions curve fitting in sheet
  788. Return blank cell if 'find' statement not true
  789. Moving data between sheets using buttons
  790. Sorting of References for Formulas
  791. How do I convert Numeral to text
  792. Can I auto insert a worksheet when I insert a value in a cell.
  793. How to give function by cell color to sum two value in Excel
  794. automatically insert formula when new rows are inserted
  795. Need help on counting text within certain criteria
  796. filtering unique data
  797. Extract data from one worksheet
  798. Forumula help using Countif
  799. How do I solve the error this #VALUE! error
  800. countif
  801. Calculating Current Age from DOB
  802. Dynamically set a range?
  803. Two pivot tables on the same worksheet? I need help...
  804. IF protection then skip sub.
  805. Worksheet - Quote log
  806. Hyperlink- relative reference
  807. Averaging Text vs. Numbers
  808. countif = < > AND value in adjacent columns match criteria
  809. Graphing Normal Distribution Functions
  810. How can I play a .WAV file in Excel if a condition is met?
  811. How do I use the "if" and "round" function in the same formula ?
  812. How do I add multiple conditions to a formula?
  813. How do you run a Macro from an IF statement in Excel 2000?
  814. add Trend Line to Pivot Table Chart
  815. excel quotes
  816. Settiing up spellcheck in a protected Excel document
  817. Track changes
  818. Unable To OPen Excel 2003
  819. Random Number response
  820. CONCATENATE TWO DIFFERENT CELLS
  821. Excel copying with link cells
  822. Can I use more complex logical expression for sumif as creteria?
  823. How can I invert a column's contents
  824. count a number range and a letter in a cell
  825. Match - Exact - Lookup?
  826. Date calculation
  827. If Question
  828. Find minimum value greater than a particular value
  829. Summing lookup values
  830. How to display a numeric field showing all 5 characters.
  831. VLOOKUP not working anymore
  832. How do I make a compound function?
  833. Submit Button
  834. Will the COUNTIF function work with auto-filtering?
  835. Split Profits to different partners based on hurdle rates
  836. COUNTIF using # ranges, and referencing 2 other columns
  837. Need a Formula
  838. sumif #value
  839. Ask for password after certain date?
  840. My Excel formala is not returning the correct value
  841. formula to count cells containing #'s in a specific range
  842. Help! [Group] in the caption and I can't use auto filter anymore.
  843. worksheet help
  844. Coverting text to numeric
  845. How do I set up a formula using same field in pivot table?
  846. Pop-up/hyperlink in a cell
  847. How do I bold just the totals when using Subtotals?
  848. How do I create a certain equation in Excel spreadsheet?
  849. How do I sort columns with IF formulas in them?
  850. IF formula for 13 plus variables
  851. Using Rank with If
  852. SUMPRODUCT formula returning #VALUE! error
  853. Inserting check boxes
  854. Find all numbers in database that end in...
  855. Beginner with Excel Here: Need Help with Cell Formatting Function
  856. I don't want all NOW() cells to recalculate
  857. How do I undo a list I've created in Excel 2003?
  858. Mutilpe sheet , multiple formula help please.
  859. Formula for running total
  860. Conditional End Date in Data Validation Settings
  861. Calculating a tiered 401k Match
  862. Formula to return an answer using a calculation
  863. Could someone tell me the difference in these formulas?
  864. Help with Formula
  865. "If this, multiply by this" type of equation
  866. Count dates for previous month
  867. File size xls
  868. Moving up / down in a macro
  869. Help with IF
  870. Adding Products
  871. Sharing Data by Keyword
  872. What function?
  873. How do I set repeating text for a specific cell.
  874. multiple sumif formula
  875. For Niek Otten and Toppers custom function calculating time
  876. Negative Values
  877. copying data to different Cells
  878. Trying to do a auto number generater
  879. Function to lookup largest value
  880. Formula has to take Monday if due date falls on a Sunday
  881. Counting Formula
  882. Need Help With A Formula Please
  883. Specifiying the worksheet name in a cell
  884. speech recognition
  885. Range Name affecting speed of macro
  886. Help with a formula
  887. Function INDIRECT
  888. How do I see the formula calculation used in Excel functions box
  889. Pivot table
  890. HELP!!!! on formula PLEASE!!!!!!!!!!!!
  891. Using SumProduct and Count To Calculate % Ranks
  892. averaging & ???
  893. Where does "a,$B!I(B come from?
  894. How do I round to the nearest 5?
  895. I WANT DATA TO LINK WITH OTHER WORKBOOKS ACORDING TO CELL CONTENT.
  896. Sumproduct based on Date range
  897. Need Help: Summing Multiple Criteria
  898. How to get the Excel to calculate the exact date from a given date
  899. Pivot Table Row Formatting
  900. links in Excel
  901. Excel 2003 sum figures without formula
  902. Listing data without blank rows
  903. BIN2HEX function will convert '511', but not '512'
  904. Conditional Formatting based on Upper case
  905. Activating a Checkbox
  906. EASY: Format NOW as mm/dd/yyyy
  907. Values In Links Not Being Saved
  908. "Mail Recepient" feature does not work!! Why?
  909. Gathering Data from various tabs
  910. Splitting one column into multiple columns
  911. Format for degrees
  912. Run a macro automatically at a certain time
  913. Help with AVERAGE function
  914. Values from website turned into useable number values
  915. Protection of identical cells on multiple worksheets
  916. Stop a List Box from resizing
  917. need help with lookup function
  918. Excel Formula
  919. MAX Function not returning correct value
  920. Where to find complex matrix math add-ins for Excel 2003?
  921. Inserting new employees
  922. Excel: Using DSUM, I need to evaluate 2 criteria that are not toge
  923. The team who designed Excel insert cut cells was a genius
  924. how to use a variable for the criteria in a sumif function?
  925. Can I use more than three conditions for conditional formating?
  926. Can search by cell format like fill color?
  927. IF function for blank cell
  928. How do I compare string values in one column to another column?
  929. I cannot find Invoice toolbar
  930. help on match function
  931. macro
  932. data change color automatically
  933. Reply for Macropod
  934. Macros in a cell function
  935. Degrees Minutes Seconds
  936. Sort info
  937. How do I associate word cells to equations?
  938. Excel formula to calculate % gain when adding cash equity to accou
  939. average price
  940. Down arrow moves cursor to top of worksheet when sheet protected
  941. Sort a column automatically
  942. Go To last blank cell
  943. Floating CommandButton
  944. counif greater or less than
  945. Calculate the Days
  946. "Empty" values in holiday parameter for NETWORKDAYS() function
  947. running macros from IF
  948. Securing A Workbook For Individual Distribution
  949. Comparing two spreadsheets
  950. Help needed on Date formulas
  951. how do I convert cell 'Street,#' to '# Street' these are addresse
  952. Help with prompting Replace Screen
  953. How do I invert text (abc-->cba)
  954. Probabilty - Binomial - a simulation game?
  955. storing data
  956. Delete row by time/date?
  957. How do I enter a blank, not "", into a cell with a conditional for
  958. #NUM errors when calculating IRR
  959. Dynamic Ranges--Multiple TableData??
  960. IF function for multiple answers?
  961. min and if
  962. Excel IF Function
  963. partial/absolute text match
  964. Add and Subtract functions
  965. I've never seen this symbol before
  966. can't delete worksheet--grayed out!
  967. Why does paging down skip ten rows?
  968. Mind Gone Blank!!
  969. Can this be done using Sumproduct?
  970. Find name in list and get dept # enter dept # on work sheet
  971. use concatenate function to put carrage returns in a text string
  972. formating inputbox result in excel
  973. spread sheets vlookup
  974. Pivot Tables-2 Questions
  975. Re: Count across worksheets with two criteria
  976. sales data how i can list weekly,monthly yearly etc..etc...
  977. function to fill all days of month to end of month
  978. UK Excel User Conference - July 19-21
  979. Restrictions On Merged Cells?
  980. Auto Fill/Sequential Numbering
  981. Certificate of Deposit calculator
  982. update a cell by one, trying to count a survey a quick way
  983. Sum if or sum product?
  984. Using Morefunc - Indirect.Ext when Offline
  985. Need to keep some info from formulas, but then change the formula
  986. Lookup Help
  987. Ignoring text and errors with Sumproduct
  988. IF statement does not work with "=" sign
  989. Problems comparing data from multiple blank cells
  990. Help with matching formula
  991. Are there any inventory forms that change quantities as needed?
  992. formula auto input
  993. How do I allow for multiple values in VLOOKUP?
  994. Function that will automatically display the User Name?
  995. Using ISNA with OR
  996. Find first numer in a Column
  997. Is there a way to link Auto Filter values to a Cell
  998. How do I program the cells in Excel to add, subtract, etc?
  999. help to open excel file
  1000. VLOOKUP PullDown Menus Connected
Google