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. Hiding columns without usimg a macro
  2. how to create function
  3. How do I post a picture into a cell and have it stay there?
  4. vlookup help....PLEASE!
  5. How to create a function
  6. Formula to count numbers past a specified limit
  7. Working days left in a month.
  8. Sequential numbering with Subtotals
  9. summating vlookup or index formulas
  10. Adding to current cells
  11. IF Formula Help
  12. Help With DATEVALUE
  13. How to sum a column from not the first cell
  14. how to put 0 instead of #n/a
  15. Budget
  16. degree or angle
  17. Selection AutoFill, Excel 2000 & 2003
  18. In spread sheet the numbers entered as whole numbers become decim
  19. exluding missing data values from equation
  20. Last non blank cell in selected cells
  21. Sum within a date range meeting one other criteria
  22. Excel Formula Help
  23. SUMIF and AND function
  24. Vijay 1
  25. Help: Formula for calculating Baseball League Age?
  26. how to add a value based on a date change in Excel?
  27. COUNTIF Function with mulitple criteria?
  28. Using cell as worksheet name to return data on that sheet
  29. Nested IF function Revisted
  30. Help with a formula. Lookup? referance?
  31. Looking for a macro/function in an excel spreadsheet (Help)
  32. Help with Vlookup and if
  33. Do not paste in hidden cells
  34. different text colours in the same cell in excel
  35. cmdbarmenu focus problem
  36. ASC() does not convert full-width to half-width letters (Exel 2003
  37. Conditional Formatting - 2 Worksheets one Named Range
  38. Date Formulas
  39. sumproduct multiple selections
  40. if function
  41. Excel 2007: Suggestion on for a full screen page reference menu
  42. Ratio - How To Create Your Own Function/Formula
  43. Calculating averages (olympic style)
  44. Sumif w/ 2 conditions in in different rows
  45. IF AND OR functions
  46. signing in
  47. Look up unique value over several columns of data
  48. Conditional sums for adjacent cells
  49. What is an Excel function that will calculate rebates?
  50. RE: What is an Excel function that will calculate rebates?
  51. Array functions
  52. If Statement and a List
  53. ranking by mutliple categories
  54. I need a sort to descend and ascend simultaneously
  55. Excel 2007 Documents
  56. Returning value of active cell
  57. linking workbooks
  58. Trying to move photo behind text. "Send back" doesn't work.
  59. Sorting and Blank Cells
  60. How to activate drop down box using keystrokes not mouse
  61. Advanced cell function. is it possible
  62. English Currency Types
  63. How to extract email address in hyperlink
  64. Cross Reference 2 columns in seperate workbooks
  65. Macro that converts xls to csv
  66. excel
  67. Want to compare data in two numeric column
  68. auto transfering info between work sheets
  69. adding multiple vlookup results
  70. ROUNDUP MONEY VALUE IN SAME CELL AS % INCREASE
  71. F- Keys
  72. countif bigger than zero fractions
  73. Second Friday
  74. Saving a file as CSV, not inserting "
  75. case sensetive data validation
  76. Formuals not working in existing workbooks
  77. Excel All formula.....Req
  78. how do I convert a value into timevalue on excel?
  79. Probability Win x Races, Win Exactly x Races, Etc.
  80. Data Validation when a list is already in place
  81. Lookup multiple lines
  82. Insert a BLANK value
  83. Cell shatracter length limiting.
  84. How do i set up a drop down list and hide my list data.
  85. Paste Special - Formulas - Add
  86. Exporting to excel from SAP
  87. Help with Vlookup
  88. Pivot table
  89. VLOOKUP post UDF (#DigitsFirstID) creates error
  90. Find in string
  91. How to copy a cell with an if-function?
  92. help with functions
  93. Total sum based on different costs for each new quantity group
  94. Worksheet Naming Options
  95. I need to return the lowest time value in a range of cells.
  96. Adding to and subtracting from with no true value?
  97. Name ranges and Lookup
  98. Can I make excel 2003 use 1-2-3 commands (like in excel 2000)?
  99. division symbol in sas
  100. division symbol in sas
  101. LINKING A PICTURE FROM ANOTHER WORKBOOK
  102. Formula in excel to run a tally
  103. Offset Help
  104. Items in Workbook won't calc
  105. XIRR
  106. Vlookup for multiple criteria, multiple worksheets
  107. Calculating daily hours (as text) in the weekly total formula
  108. How am i able to view the formula bar as I am typing in a cell?
  109. Drop down list
  110. Inventory Control
  111. if/and formulas
  112. How do I set the contents of cell to Null in Excel 2007?
  113. Why won't the SUMIF function in Excel add time?
  114. Variable worksheet name in offset
  115. Days in a month as of today
  116. Automatic job id number once enter a row
  117. Unable to unhide any Rows beyond Row 1022 in excel
  118. If, Then formula - Multiple levels
  119. Do I want to create a Circular references
  120. Conditional format oddity in Excel 2007
  121. Spellcheck function in Protected Sheet
  122. Discerning data by the date
  123. How do I round a number to the nearest 600 in Excel?
  124. formula for Canadian Postal Codes
  125. Hide Duplicate Rows
  126. Macros and protect sheet
  127. Enter current date automatically in filename
  128. If Statement
  129. If Date Null Show Nothing
  130. sumproduct for multiple sheets
  131. Conditional Fomarting
  132. Runtime error prevents Excel 2000 to save file
  133. Sumproduct assistance
  134. Printing variable length pages
  135. v look up and if statement
  136. the "0" number is lost when combining multiple columns
  137. V LOOK UP AND IF STATEMENT
  138. Sum only positive
  139. Error calculating date
  140. indirect function
  141. how do i set up automatic number generating
  142. insert records
  143. Sort list
  144. How to apply a 25% price increase to a column of rates.
  145. Vlookup on Multiple Sheets
  146. Postings without questions in the body of the message causes an er
  147. HOW CAN I INCORPORATE A YES/NO CHECK BOX IN EXCEL CELLS
  148. Copying data - Excel 2007
  149. Why did text in entered formula change to red in Spreadsheet
  150. How do I interpret Regression alanysed data ?
  151. lookup when there is multiple same numbers
  152. Stuck on Nested IF Function
  153. IF or similar but true result to display in consecutive row
  154. Moving Cell Information from one workbook into another workbook
  155. Complicated Date formula
  156. Replacing ?
  157. macro to copy worksheet
  158. Formula for High Value
  159. Count each entry of a day
  160. calculating payback of an investment
  161. Excell spreadsheet formula
  162. In Excel linked values turn to #REF! after clicking don't update
  163. simple macro question
  164. Highting rows based on content of cells
  165. Return cell name
  166. I'm trying to count sick and vacation days
  167. if cell CONTAINS xyz, then abc
  168. How do I make a column of data sort into rows?
  169. I am trying to create a spreadsheet for businesses within zip code
  170. How to determine if a cell has a value, then copy it to a new loca
  171. Report Date - Date Recv = Days Late, but how to rid completed date
  172. Changing 123456 to $1234.56
  173. for mayer: very fantastic news server - ag ruc - (1/1)
  174. Assigning rank or appearance
  175. report date - date rec.ved=days late, but how to rid dates complet
  176. Conditional formatting
  177. Bulk vlookup?
  178. Count formula problem
  179. Finding, searching, and comparing cells to another sheet
  180. Count If
  181. How do I get the current column's data from that cell to another?
  182. merge certain columns from worksheets
  183. SumProduct and MatchingProblem
  184. Find all possible Difference between two sets of numbers
  185. Rounding
  186. I need to select rows that have red text or are high lighted?
  187. Change Row Color
  188. Job Number Lookup and Match with Job Name
  189. selecting text area
  190. use of ISERROR
  191. How to setup a ratio
  192. Select multiple names from drop down list
  193. How can I average 2 curves? y=10x+3 and y=11x-2
  194. Dynamic List in a Report More options
  195. How do I generate a list of the tabs/worksheets from a workbook?
  196. formulas
  197. VLOOKUP and LARGE
  198. Can I use OR function here
  199. How to convert text into date format?
  200. Need help about logical formula
  201. Excel cell must be hidden and not calculated
  202. Find the bottom cell that contains a specific val in a range?
  203. My number shows as text
  204. can wildcard characters be used in IF functions
  205. Function that returns the month name
  206. Keeping contents of cell A1 showing when scrolling.
  207. Macro: Updates a formula or value when a data is entered.
  208. How to calculate the maturity value
  209. exporting to excel 2003
  210. How do I make a Coupon Book for payment from another party?
  211. Working with 3-D functions across worksheelts
  212. Blank Value not recognized?
  213. probability
  214. Comments on a Pivot Table
  215. conditional format for if month(today) = xxx
  216. Tabs in alphabetical order
  217. How do I create a multi-worksheet pivot table?
  218. Multiple reference through multiple worksheets
  219. SumIf Function
  220. Condition formating and copying
  221. Nested IF statement
  222. Changing whole numbers into decimals
  223. Save Column when importing from Access
  224. Count Saturdays in a List
  225. Can you link text from one worksheet to another?
  226. DELIVERY NOTES
  227. Formula That Counts First Value Only In Array As A Condition
  228. "edit query" button in Excel 2007 has been hidden
  229. If Statement
  230. http to text
  231. Re: function to find the row number of the maximum value in a coll
  232. VLOOKUP and IF Functions
  233. VLookups - too long to re-calculate
  234. Excel Pivot Tables-How to put two Data Varibles side by side
  235. simplify VLOOKUP with conditions
  236. Bizarre behavior in VLOOKUP function
  237. Re: conditional formula with multiple conditions and answers.
  238. displaying output of a formula to be in double quotes
  239. importing data into excel
  240. create new variable
  241. #NAME? error associated with UDF
  242. Creating tables based on looking down a column and back across a row
  243. Creating tables based on looking down a column and back across a row
  244. equation / function question
  245. Colllecting Comments in a survey
  246. count unique values & filter
  247. conditional formatting question
  248. Formula
  249. Finding a text box
  250. Can excel tell me what numbers in a given column sum to X?
  251. How to delete duplicates between workbooks?
  252. How to delete duplicates between workbooks?
  253. Counting Characters
  254. pro-rated formula
  255. Workbook sharing
  256. Run on open macro
  257. formula for colour
  258. Pick which sheet to put a wordart stamp on
  259. If or not
  260. Which formula?
  261. Help required about vlook fomula
  262. VLOOKUP or not
  263. help required about vlookup formula
  264. help required about vlookup formula
  265. Printing Macro how do I
  266. Share Workbook Function
  267. colour changingusing VBE
  268. IRR & #DIV0!
  269. Countif Using Multiple Columns
  270. Really strange issue with simple formula
  271. Close worksheet by means of a macro
  272. Currency sum not correct Excel 2003
  273. Compare columns, count matches
  274. Data auto sorting
  275. Can you do this with a list???
  276. Can you add the number of conditionally formatted cells??
  277. Trying to use Lookup with Named Columns
  278. Calculate % of events based on days worked
  279. cells react different on 2 computers
  280. incrementing a date that the user has entered?
  281. How do I arrange a formula between cells that are not together?
  282. Outlook contact info link to Excel
  283. range calculation help
  284. assigning value to letters
  285. HOW DO I CALCULATE ACCURATE HUMAN AGES ON A SPREADSHEET ?
  286. Excel Workday Function
  287. IF Statement in excel for a date
  288. Calculate a date based on a weeknumber
  289. page numbers in workbooks
  290. Formula Adjustment - Help
  291. worksheet reference
  292. how can i round a dollar amount to the nearest thousand?
  293. comparing 3 s/s to make up a master
  294. Trying to List data that is being entered into an Invoice
  295. There is a spline interpolation function?
  296. Subtact 2 dates to get the number without counting weekends?
  297. IF Statement with 3 parameters
  298. Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et
  299. Formula or Macro to insert Data in Cell when having more than 7 Functions
  300. Calculating Finance Charges
  301. Cutting and Pasting cells from horizontal to multi vertical column
  302. Specify what worksheet to open first
  303. Suppress a row
  304. find an original worksheet file before changes were made
  305. Help with array lookup and max
  306. Insert a day on change of other cell
  307. How do I solve for x?
  308. vlook
  309. Clear list from weekends
  310. Running total question
  311. Greater than formula
  312. serial numbers with hidden rows
  313. Get Date of Birth from a ID Number
  314. Finding last receipt number in a column ?
  315. How can I match a calculated date to closest date from a list?
  316. Automatic Numbering
  317. detecting duplicate input in a cell
  318. detecting duplicate input in a cell
  319. detecting duplicate input in a cell
  320. replacing text within a formula
  321. Show Null As %0
  322. formula returns a blank
  323. Highest 12-Month Period Average Over Range of Months
  324. match and large fumction
  325. Check dates in spreadsheet against expiry years column and change colour
  326. Buttons
  327. description of countif criteria?
  328. How to return 1 with #VALUE!?
  329. Formula won't adjust after sorting data
  330. How do I add up time and minutes in a spreadsheet?
  331. Re: Cut and paste options
  332. formula that works in a different workbook
  333. Does anyone see this .xls]sheetname?
  334. Cut & Paste visible cells on same row
  335. Lookup Formula help
  336. apply different prices to different quantities (variable pricing?)
  337. Adding random noise to data
  338. Cells Slide Under
  339. Can I compute the eigenvectors of a matrix in excel?
  340. find all the possible differences equals to 3
  341. How do I highlight data differences in workbook
  342. COUNTIF cannot count decimal number occurences
  343. RE: How does one make data in a cell blink
  344. Need formula to add a set amount to a balance on a specific date
  345. Labor costs for estimates
  346. Count unique if text
  347. Return Unique Duplicate Numeric Values across Single Row
  348. Formula problems
  349. Automatic Quote Number Creator
  350. Find max Row() number for a value in column
  351. Re: Most recent price per item
  352. Re: NA
  353. Need Help about vlook
  354. how do I paste range name list?
  355. Vlookup on partially sorthed lists
  356. DSUM - non contiguous criteria range
  357. Rows not formatting all the way down
  358. linking 12 monthly workbooks to one year to date workbook
  359. Pivot Table - Problems when using Calculated Item
  360. Converting a formula to a date
  361. Re: Find the top Scores per School
  362. Re: NA
  363. Re: NA
  364. RE: What is the problem with this formula?
  365. How do I hide a divide by zero error from an average formula?
  366. RE: Array formula for unique values
  367. Re: Array formula for unique values
  368. Re: How to return to a cell after sorting a spreadsheet.
  369. Get Macro warning, but can't find Macro
  370. Re: saving filters
  371. [=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2')
  372. counting check boxes
  373. My SUM function is totalling to 0
  374. replace results from list with corresponding list
  375. coloured fonts in cells
  376. RE: counting check boxes
  377. $ for VLOOKUP functions
  378. RE: Data Validation Problem
  379. Conditional formatting date ranges
  380. LOOKUP and #N/A Error
  381. LOOKUP with 2 or more criteria
  382. RE: remove links when pasteing formulas from one workbook to anoth
  383. why a excel file,one sheet only, take 23 Mb ?
  384. = in cell does not upadate
  385. RE: My SUM function is totalling to 0
  386. Can I save custom headers and footers to use in other files?
  387. RE: LOOKUP and #N/A Error
  388. RE: columns like in word
  389. adding data to existing data cell
  390. Calling cell values from random sheets from a base sheet
  391. Display Months by looking at the dates
  392. another array question
  393. WORKDAY Function in an IF statement
  394. Function to detect type of cell contents
  395. Conditional IF statements
  396. Joining text in one cell
  397. Excel Function - Please help
  398. Same dates in Sheet1 put as one date in Sheet2
  399. embarrassed
  400. sales invoice
  401. How can I interpolate values off a table?
  402. excel, multiply problem
  403. Conditional formatting a range of cells
  404. Fit scores
  405. Changing numbers/percentages to letter grades
  406. Vlookup problem is killin me.
  407. If, Then Values
  408. why won't my cells format correctly?
  409. how do I create random blocks of letter and words in excel?
  410. Simplifying VBA code
  411. If function
  412. min & max values
  413. hiding zero values on all sheets & by default on new sheets
  414. How do I make a pop-up window that displays a range in Excel??
  415. When exporting a report from Access to Excel columns misaligned
  416. Combining Two Files
  417. CAR LEASE CALCULATION WITH RESIDUAL
  418. Counting specific character in text string
  419. SUMPRODUCT Formula Help
  420. run time error 1004
  421. Keyboard Arrows
  422. how to creat a formula to advance date by one year
  423. function to display contents of a cell
  424. Count the number of times a hyperlink is viewed
  425. Why do columns zero out when I try to re-sort two spreadsheets
  426. Creating drop down box with worksheet names
  427. formula returns blank
  428. Selecting Hyperlinked data
  429. Vlookup/Pivot table question
  430. HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007)
  431. Assistance with Alphabetizing a Library Worksheet
  432. using sumif to sum a range of values
  433. Locking Cells or worksheets
  434. Copying Worksheets
  435. Find Duplicate Values and Return Another Value
  436. sumif
  437. HOW DO I CREATE A SUBTRACTION FORMULA
  438. Order of Cell Advancement
  439. Dynamic Rolling Average
  440. Picture in scaled page
  441. Array formula fill down problem
  442. Vijay
  443. WEEKDAY in Conditional Formatting?
  444. Multiple If Then Statement based on ranges
  445. Totalling up a Filtered List
  446. Can I create new sheets automatically in a formula?
  447. SUMPRODUCT is OK for a while and later a similar formula returns 0
  448. Drop-down lists with colours or pictures
  449. Sumproduct with wildcards
  450. how to set default column function
  451. Shadow to cell how?
  452. MSDN article on Excel Limitations in Pivot Tables for Multiple consolidation ranges
  453. split email id list into 1 extra list with everything after "@"
  454. How to specific the cell format?
  455. Count no of cells containing data for more than one criteria
  456. How to look for value?
  457. how do I use a file list to recall data from listed files?
  458. Formula won't run
  459. How do I get data automatically entered into a cell?
  460. Array using MIN
  461. how to compare data in two different work sheets
  462. message box text
  463. Subtotals not working correctly when 2nd subtotal added
  464. excell windows 03 cond format help
  465. Making a Call to an external sheet using a variable...
  466. hi, new value formula question
  467. (INDEX($T3:$T4849,MATCH($D3,$P$3:$P$4849),FALSE))
  468. Copying changes from one worksheet to other worksheets
  469. Vlookup problem
  470. calculate
  471. Cell content is based on other cell value
  472. data analysis addin in Excel 2007
  473. MORE THAN ONE CONDITION IN A FORMULA
  474. Complex Look Up Problem
  475. value expression
  476. How do you alphabetize a whole spreadsheet ?
  477. How to paste exact value into another cell?
  478. SUM OFFSET COLUMNS
  479. naming sheet tab
  480. USING DATA FROM AN EXCEL FILE TO IMPORT INTO ANOTHER
  481. Custom number format problem
  482. Creating Nested Functions
  483. Formula needed for too much inventory
  484. Right Justifing in Excel
  485. first number after zeroes in sequence
  486. Change Multiple Page Fields in two independent Pivot Tables
  487. filter for even numbers in Excel
  488. Conditional format based on entire row
  489. Looking for Bi-Weekly CDN Amortization Schedule
  490. Repeating colors in Excel 2000
  491. Autofilter multiple columns
  492. how to I make member list that indicates when subs due
  493. How do I treat row 1 in my worksheet as a header for each page?
  494. {} in formel
  495. cells that "contain" values
  496. Cell changes from General format to Scientific
  497. How to calculate the diference of times in excel?
  498. SUMPRODUCT returns 0, when I know it shouldn't
  499. addition returns a number followed by E-15
  500. Copy function across autofilter
  501. Sum of every 6th column and recurring
  502. "general" cells turned into "accounting" - why and how to reverse
  503. Cannot see formula descriptions in worksheet as I type a formula.
  504. IF and lookup functions combined?
  505. IF and lookup functions combined?
  506. Formula to average the last 4 non-blank numerical cells of a row?
  507. Match
  508. number/time format
  509. LIFO inventory method?
  510. If, then statement troubles
  511. Default date and time in the comment.
  512. Querying Access for QTD and YTD Sales totals
  513. Multiple formats in the same cell
  514. Need help with a date check formula
  515. Excel Spreadsheet Assistance (Match, Compare)
  516. Workday Date Calculation
  517. formula/autocomplete to link data from other worksheets
  518. PRODUCT RESULTS/VALUE ARE NOT CALCULATING CORRECTLY
  519. help with the substitute and trim functions
  520. Formula question - does anybody have the answers?
  521. Need help with recording a macro, attaching a button
  522. Changing Comment Box Position - Any solutions?
  523. Spread sheet calculating/not calc from opening file differently
  524. time and if statements
  525. no rounding
  526. Array to meet conditions
  527. Count formel. Dont like the new year
  528. Excel
  529. SUMPRODUCT - comma versus semicolon
  530. Comments Format Help
  531. Incremental Numbering
  532. form check box
  533. Assigning X-axis to graph
  534. Email on a condition
  535. time
  536. Combination of formulas, if, and, or
  537. Count working days by week
  538. Prevoiusly posted message: Unable to remove objects pasted into Excel from HTML grid
  539. How do I split my data into ranges
  540. how to read the data from Excel sheet
  541. how to read the data from -- >> Excel sheet
  542. convert a numeric number in text format in another cell?
  543. Duplicates
  544. vlookup with a sum of array
  545. Multiple conditional formula
  546. Conditional Formating
  547. background color
  548. Date/Time formula
  549. Another data across multiple worksheets question (ugh..)
  550. SUMIF MULTIPLE ARRAY CRITERIA
  551. match two items to table for result
  552. Expanding and Collapsing Groups within a Protected Workbook
  553. Expand and Collaps Groups while Protected
  554. Excel
  555. sort & match
  556. Value or formula?
  557. countif
  558. calculating cells hangs when filtering ranges in a sheet
  559. Copy a column dependant on a the contents of a cell
  560. Grouping
  561. Concantenate numeric fields
  562. formula to convert raw data from several sources into relative tot
  563. HOW DO I CREATE A SUMMARY LIST FROM 200 SPREADSHEETS?
  564. Interpreting "comma" where an optional argument is
  565. MACRO AND MULTIPLE WORKSHEETS
  566. if or statements to get three possible outcomes
  567. Converting Excel Columns
  568. Named Range name problem in validation
  569. How to sum data from another sheet using date ranges?
  570. Excel-Match 1st text character in a string to a known character?
  571. conditional Formatting based on cell formatting
  572. conditional Formatting based on cell formatting
  573. Multiple Selection of Non-Continuous Data
  574. Adding something to a column
  575. how to auto fill information from a table to another sheet
  576. Only calculate data table
  577. Can you link index keys between sheets for purchase/sales purpsose
  578. Pivot Table Source
  579. reference and replace data from one sheet to another
  580. how to read the data from Excel sheet
  581. Using information in one excel file in another
  582. work out compound intrest payments
  583. Convert XLS to XML without XLS Properties
  584. Another "combine list" question
  585. All cells shud contain a unique ref how do i check 4 duplicates?
  586. define nonblank in a formula
  587. Adding only positive numbers
  588. Data Validation with IF and Max. Possible?
  589. Can you find the cubed root on excel
  590. how do I insert a variable amount of blank spaces in a formula?
  591. Excell convert formula row to formula column
  592. Drop down list with different values.
  593. mental block
  594. Number of DDE links
  595. comparing worksheet and Marking the difference
  596. date + working days
  597. Synconizing Worksheets
  598. Find Max Value in WorkSheet
  599. ?formula
  600. dates
  601. Last value in row
  602. Extract Rows for UNIQUE and MAX
  603. Countif funtion
  604. IF and or function
  605. using IF function with AND/OR
  606. referencing active cell works in a sub but not in a custom function
  607. Conditional Formatting: Excel 2003 vs. 2007
  608. Lookup using multiple sheets and multiple criteria, sorry if 2 pos
  609. clear range of cells if another becomes blank
  610. referencing active cell works in a sub but not in a custom function
  611. COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made
  612. If Function?
  613. Count how many Rows ago a particular number was hit
  614. not sure what is wrong
  615. Prefacing a Copy/Paste Special formula with text
  616. Counting how many rows since a new value was made
  617. FIND, CLEAN, REPLACE question
  618. Using cell data as file name
  619. Formula to stop adding at a positive number
  620. Re: FORMULA THAT LIMITS WHAT IT CALCULATES VS WHATS ACTUAL
  621. FORMULA THAT LIMITS WHAT IT CALCULATES VS WHATS ACTUAL
  622. Median calculation of grouped data.
  623. Summing all cells containing the letter K
  624. Counting numbers with a letter attached in excel
  625. how to combine formulas to.........
  626. Averaging across all worksheets except one
  627. How can I create list of degrees,minutes,seconds
  628. Embedded If Function in a Vlookup Function
  629. Cell Column Comparison
  630. Button for bring up chart
  631. Count time to time
  632. Input Masks or equivilent
  633. message box when file is opened
  634. counting occurrences in another sheet based on several criteria
  635. Drop down list linking
  636. Setting up an If-Then Statement that will pull from a valdiated li
  637. Why do column widths change in Excell?
  638. Rename sheet with NOW date
  639. Using TAB vs ENTER for data entry in a protected sheet
  640. Question on Validation
  641. How do I save an autofilter selection as a new file?
  642. COUNT or COUNTIF using wildcard text?
  643. Automation
  644. if statement with a range without a cell reference ie, #s 1100 to
  645. Searching in another workbook for a string and returning with the contents of the cell next to it.
  646. range in an IF statement
  647. Future Value of Money
  648. Hyperlink function not working properly
  649. Paste Specific Cell to Selected Cell
  650. ARrow Keys
  651. Permanent formula?
  652. if statement
  653. Color Conditional Formatting
  654. Opening/converting other spreadsheet programs' files
  655. generating random number list
  656. function
  657. how do I insert a picture using a formula?
  658. Custom Calculated Items in a PivotTable
  659. how do I insert a picture using a formula?
  660. Drop down menus
  661. empty cells in a vlookup list
  662. Viewing an entire named range
  663. conditional formating #N/A
  664. Lookup function Closed files Excel
  665. Sum \ Count
  666. Sumproduct + wildcard
  667. SUMIF ?
  668. Transpose from Col to row
  669. How to automatically goto to today's date
  670. Checkbox values?
  671. A question about the Count/CountIf function
  672. Counting certian rows to sum them
  673. Cell returns blank result...
  674. How do I arrange worksheets alphabetically in Excel?
  675. Conditional formating using today() +/- 180 days
  676. re: elkar respons
  677. Link inserted rows throughout the worksheet.
  678. stacking multiple column data into a single column
  679. re: price comparison
  680. Formula Help
  681. List of functions contained in the add-ins, esp. Analysis Toolpak
  682. Need help extracting data....
  683. What formula to use?
  684. I need to combine an "if" formula & an "and" formula, pls help ;)
  685. dynamic Validation List
  686. Macro needed for inserting blank rows
  687. Flipping Data in Excel
  688. indirect formula
  689. Comparing data
  690. How do I place Range text into a header?
  691. calculating double time on a workorder
  692. I need help creating a formula
  693. Expand columns
  694. Modellingwith Excel
  695. I can't get custom number formatting to "take"
  696. Search table for string return next columns value
  697. How do I re-set the tab stops in Excel to move 1 cell at at time?
  698. matching cells and transfering data
  699. SumProduct Help
  700. Using Excel as an actively linked workbook in Access
  701. Automating Address Information based on selecting data via a validation list
  702. COUNTIF for criteria in two separate columns (Excel 2003)
  703. Calculate needed gallons of water, based on weight of person
  704. SUBSTITUTE patterns?
  705. Copying data from one worksheet to another from rows to columns
  706. Function that returns worksheet name?
  707. Another formula question
  708. Generate Random numbers from a pre-defined set
  709. Generate Random numbers from a pre-defined set
  710. How can I output VBA function results (array's for example) to spreadsheet
  711. formula
  712. How do I convert a month-date format to day number of the year?
  713. data sheet formulas
  714. Spread Sheet Employee Hours Issue
  715. Calculating a formula
  716. Errors on Functions with many arguments
  717. Unable to select an Excel cell
  718. why does excel DELETE rows of data when removing subotals?
  719. Find the row number with a date in it
  720. How can you assign a bmp. file to a formula or macro?
  721. Auto suggest entries?
  722. Not sure how to title this
  723. "Additonal Numbers adjacent to it"
  724. Using an Array to calculate the number of days between dates and..
  725. Two TRUE to one FALSE statement
  726. Can we add a blinking text / figure in spreadsheet.
  727. ??Calculate week number of a month
  728. look for row
  729. formulas
  730. formulas
  731. Can you please hel me to find the correct formulas
  732. formula result blank
  733. How do I add/count numbers in the same cell in excel worksheet?
  734. conditional formatting
  735. how do I show the fractions shown on a ruler?
  736. Data validation & indirect
  737. Links between workbooks
  738. Totalling Values From The Same Cell In 12 Worksheets Onto New Shee
  739. ComboBox code
  740. using countif
  741. Max # Of Stocks That Can Be Updated using MSN Stock Quotes Add-in?
  742. how do i create a formula in excel
  743. Create formula to choose price based on previous choice.
  744. COUNTIF in between rows
  745. CountDays? need to count days in range by month
  746. embed an object that links to a specific worksheet or range
  747. HOW MANY CELLS ARE IN EXCEL?
  748. Sum of numbers help...
  749. performing conditional averages.
  750. Can IF function return an empty cell? (not "")
  751. NetWorkdays Calculation isn't working
  752. find last cell in a column but not a formula
  753. IF with SUMIF ? Or ??
  754. Using text instead of number. e.g. If(E10=C,1,0)
  755. Operator
  756. Calculating Monthly Payroll Taxes
  757. I have lost the office assistant
  758. using formulae in excel
  759. Question
  760. Re: Excel CountIfs() and SumIfs() question
  761. how to recover my passward when i forgot
  762. delete zero's from numbers
  763. Index / Match in formula
  764. Need statistics help!
  765. Re: Unprotecting a Protect Worksheet
  766. If with Vlookup
  767. COUNT IF FUNCTION
  768. Total 'x' in a certain column
  769. Vlookup using cell for tab name
  770. Identifying updated cells
  771. Help with Characters limiting
  772. Find a worksheet and extract data
  773. Going CRAZY with INDEX and Match Function
  774. Auditing
  775. ROW()
  776. Macros Not In Toolbars
  777. How can i get formatted data from outlook to excel?
  778. add up negative numbers
  779. Holidays
  780. How to control calculation of specific cells
  781. Conditional Formatting for ddd hh:mm
  782. How to count the odd or even in an excel area?
  783. Want to create functions for Child maths
  784. number formatting
  785. Excel>Excel 2002 display formula in another cell as text
  786. Problems with LOOKUP
  787. how to decompose the data in excel ?
  788. RE: figure to date totals based on month
  789. Text in Pivot Tables
  790. How to get Blank into a cell as a result of a formula
  791. Re: inserting a row into a column that is read on another worksheet
  792. Re: Array formula for SUMPRODUCT
  793. Re: Advance to predetermined cell
  794. RE: Advance to predetermined cell
  795. RE: Date trouble
  796. Re: macro to copy a value multiple times depending on value in adj
  797. Re: Advance to predetermined cell
  798. RE: Advance to predetermined cell
  799. How do I link a print header to variable data in multiple workshee
  800. how to make excel automaticly jump to next cell?
  801. mapping values of one array into another
  802. How do I show only the whole number w/o eliminating four decimals?
  803. Linking Worksheets and Workbooks
  804. SUMIF
  805. IF_AND Formula Help
  806. hide rows where cell condition is not met
  807. vLOOKUP
  808. Defining Names in Excel
  809. Conditional Formatting? Not sure
  810. Using the If or lookup statement to find matches
  811. Conditional format a cell based on another range of cells
  812. Drop TB into Financial Statements formula?
  813. compare date to various date ranges and sum value
  814. sumproduct and colored cell as a condition to be met
  815. using two drop downs with a vlook up formula
  816. Variable worksheet name (tab) linked to cell in same worksheet
  817. Filters
  818. Minuts and Seconds to only seconds???
  819. How to apply funcation
  820. Excel / Word Merge Feature
  821. copy/paste scenario
  822. Data Validation
  823. How do I tranfer the print settings to all worksheets?
  824. Excel formula to extract a group of data from another list
  825. Excel opens hyperlinked jpg in IE, no matter what
  826. Sumif problem
  827. Save-As Option Disable
  828. Saving Totals Only
  829. that damned IF function
  830. sumif / sumproduct for number of coincidences
  831. Weekday + Time Calculation in Cell
  832. Regional settings independent list separator in arrays
  833. cant change the cell format it shows too many different cell form
  834. Formula for a 4 day work week
  835. Vlookup for data comparison/validation?
  836. counting the # of unique values
  837. Dropping Trial Balance into Financial Statements
  838. Multiple Nested IFs, ORs, Ands
  839. Excel 2003 c++ automation problem.
  840. anyway around this, easily?
  841. Rounding up to the nearest dollar
  842. How do I...
  843. Sorting
  844. Set Windows Freeze Panes
  845. SUM not working
  846. formula
  847. Minimum value after select case
  848. Lookup, Match, something like this
  849. Functions in Excel 2003
  850. Alpha & Numerical Help Needed
  851. versions / scenarioes
  852. Linking to Workbooks that Change Name Daily
  853. Statistical Information
  854. HYPERLINK to a doc with a "#" in the name
  855. Sick time accumulation
  856. Max using Index/Match Help
  857. Mandatory Cells
  858. Date Function and Color Code
  859. Linking Combo Boxes (Please Help)
  860. SUMPRODUCT - (amended) Exclude LAST Row of Matched Criteria (Month & Year)
  861. Variable interest rate
  862. I want to round Int to quarter
  863. Counting formula
  864. Averaging two if statements
  865. How do I compute hours times hourly rate?
  866. Zeros in cells
  867. sorting cells with formulas
  868. format adjacent cells
  869. Function or formula
  870. Create a formula based on date
  871. Excel Conditional Statement Help
  872. Using cell value in formula
  873. Validation
  874. display formulas as text
  875. signed over-punch
  876. Option Buttons in Excel 2000
  877. Finding row # of last cell containing contents
  878. DCount help
  879. FORMULA SHOWING AS ####
  880. How do I export files to microsoft money ?
  881. Spaces
  882. Sum of selected cells from different sheets in a new workbook
  883. changing a Sumproduct formula please
  884. convert weekday date to the next sunday date
  885. How to calculate how many meet min and max criteria
  886. How do I count words in a column if they are inexact?
  887. ??conditional formatting??
  888. Rolling 12 week calculations
  889. horizontal sumif help
  890. Save-As Restriction
  891. Excel Formula
  892. How do I count values w/ criteria located in more than one column
  893. How do I return a mileage value from a row and column value
  894. array formula with if and hlookup
  895. Calcing DOB
  896. Can Excel headers automatically look to a cell for data? &[B2]
  897. Setting up MS Excel form
  898. downloading megastat software
  899. Cells and formulas
  900. Formula too long
  901. Problem with sorting 19th century dates
  902. Subtracting cells and getting a null return
  903. Ensure LOOkUP does not return #N/A
  904. How do i assign value to 3 cells =E41, =H41, = B41 by typing 41
  905. only INTEGER INPUT IN CELL
  906. Save Date & Time
  907. Conditional Formats for formulae and values
  908. How do I deal with a "Too many different cell formats".
  909. Fixing the number of Col and rows.
  910. Linking cells between worksheet - from column to row
  911. Multiple Condition Text Return
  912. Why does conditional formatting remain static?
  913. formula series (newbie)
  914. SUMPRODUCT - Exclude LAST Row of Matched Criteria (Month & Year)
  915. Shorten Formula
  916. how to force a lookup
  917. Values Returning Text
  918. Formula to return lowest value of 3 datapoints
  919. Index and Match Formula
  920. CUBE Functions in Excel 2007
  921. Days between
  922. Formula Replication
  923. adding numbers shown in cells, not what is actually in cell - help!!!
  924. Importing specific data into an Excel workbook
  925. Filtering sheet data in another sheet
  926. Filtering data in a database
  927. Netflix Que
  928. Is there anyway to simplify this formula?
  929. If statements and conditions - again!! new prob
  930. comparing data in two spreadsheet
  931. Set the time and date for editing a cell
  932. Place a Dynamic Date + a Certain Time in a Cell
  933. Timesheet Validation
  934. print area across the freeze panes area
  935. How to replace ... with a 0
  936. If function returns #REF!, want it to return 0
  937. help with formula
  938. Opening to a default sheet every time
  939. Inspection report templates
  940. Formula Didn't work how i needed
  941. How do I count the number of filtered rows
  942. PLEASE HELP
  943. Iserror nested within a conditional vlookup
  944. INT Function
  945. Repost (Comparing two ranges)
  946. New Running Total for each worksheet
  947. Why isn't the drop down showing using data validation?
  948. Auto fit text in cells
  949. formula viewing format
  950. cutting characters from a cell
  951. i NEED TO PULL OUT THE MOST RECENT DATE FROM A COLUMN-
  952. Count entries in one column based on values in another column
  953. Need a Formula
  954. Excel A3 paper size ????
  955. How do I get data validation to disallow specific entries
  956. Won't give correct answer
  957. I need to create a drop down for notes in excel
  958. SUMPRODUCT question
  959. #NUM! being returned instead of 0 or blank
  960. Workbooks consoaldation
  961. How do I count cells with different criteria in excel?
  962. Need formula
  963. V- Look UP
  964. Dynamicaly create/copy a new row in another worksheet
  965. When I edit the cells referenced in my formula, the result does ch
  966. display content of linked cell
  967. sumif and countif nested?
  968. Query SQL Server from Excel
  969. How do I delete a column that has been used for a function?
  970. Sum problems
  971. Financial function requested, please
  972. Formula in comments?
  973. filtering entries in an excel costs schedule?
  974. DATES auto update in Outlook
  975. How do I create calculated items on pivot table reports?
  976. Excel Error
  977. Dynamic table array using Hyperlink
  978. Autosum returns 0 value on data sheet
  979. Conditional Formatting across Sheets
  980. RGB values
  981. Sum same cell/range of multiple worksheets within a workbook...
  982. How can you use IF looking at a column, not just a single cell?
  983. Average function
  984. expenses and monies recieved
  985. Can I use Sum Product across multiple tabs within a workbook?
  986. need formula to reference a cell in previous worksheet
  987. Count cells that meetin conditional formatting criteria
  988. Excel and Email/Outlook
  989. Formatting Text
  990. find a 12 month cash flow worksheet
  991. <!Excel and Arrow Keys!>
  992. COPY A PAGE
  993. Return Matched Numeric Labels across Single Row
  994. Create a row listing based on a lookup value
  995. Re: Excel csv spreadsheet-How to save info exceeding 20 columns
  996. Want a percentages of a single cell divided by a column of cells
  997. Count/average function with filters
  998. Need a Function to Remove Text
  999. MODE Function
  1000. match week, count rows, sum rows?