PDA

View Full Version : Microsoft 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 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160

  1. changing formula
  2. If & Vlookup statement
  3. Validation list with formula?
  4. Change the weekends
  5. Rounding
  6. vlook up w- multiple variables
  7. Date Diff - excluding working days
  8. Median with Criteria
  9. using CountIF function or Array?
  10. Conditional IF formula using multi-dimensional arrays
  11. stock control template
  12. Auto-insert same value each Monday in cashflow worksheet?
  13. Adding totals from different columns
  14. Hyperlink won't open in excel
  15. Find and Replace
  16. Pulling/Collating Data
  17. Array Formula Help Needed
  18. Sum amount of days in another coloumn
  19. Urgent help needed - hyperlinks
  20. Vendor List
  21. Help with formula
  22. Conditional formatting with expired dates after current
  23. I want to add formulas from multiple sheets to master form
  24. row height issue
  25. Lose Formatting
  26. Average using Sumproduct
  27. vlookup and match first value greater than
  28. Need to extract specific data from a text column
  29. Combining text from multiple cells
  30. data validation using named range from another file
  31. Counting with 2 criteria
  32. Nested IF(OR(AND) Statement with Two AND Conditions
  33. Can I color a cell with "If" formula
  34. I need to write a PRODUCT formula that mimics a SUMIF
  35. Average For Filtered Cells
  36. Averaging many non-contiguous cells if they are blank
  37. Can I use Sumproduct with the LEFT Function?
  38. visible cell only
  39. Combining Cells
  40. Duplicates formula
  41. Ignore Hidden Rows and Count of distinct values
  42. Re: Counting Array element
  43. sumif - with 2 conditions - rows and columns
  44. Sum VLOOKUP?
  45. formating
  46. Count if if
  47. Invoice: customer database and billing information
  48. If function with calculation
  49. Merge Cells
  50. using if in a range
  51. Consolidate excel 2007
  52. Look for Min and second Min
  53. Look for Max and second Max
  54. Counting frequency in unsorted data
  55. Basic Question on autocomplete function
  56. how to key in a1 information on e1 wil appear at b1
  57. excel formula
  58. Adding dates in columns
  59. Non-contiguous range and Sumproduct to average
  60. Find 2 highest point to form resistance line
  61. Find 2 lowest point to form a trendline
  62. date Concatenation
  63. Extract if 1 shows up
  64. Delete 3 end row
  65. Removing multiple duplicate events
  66. Unprotect problem
  67. Customize accounting format
  68. different colour font in same cel
  69. Countif using cell refences
  70. Summing based on dates
  71. Summing based on dates
  72. Pivot table field list missing
  73. Macro - onAction arguments
  74. List from a Table
  75. Running total based upon current date
  76. separate text and number
  77. Help Creating Excel Formula
  78. Searching based on text
  79. vlookup formula error
  80. How do I set up a formula to give me an average based on IF?
  81. How to set up a conditinal formula w/letters vs numbers?
  82. Average with Conditions
  83. Excel 2007 - AVERAGEIF on rows that are non-continuous
  84. =INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR)
  85. Format cell based on cell color
  86. Return 0 if cell has data, of copy if it doesn't
  87. Time elapsed calculation
  88. sum column based on single cell match?
  89. Help for Medical Records sorting
  90. Counting Merged Cells
  91. Excel
  92. return 0 if cell has data?
  93. #VALUE error-- some cells?
  94. How do I truncate linked text?
  95. IF Formula
  96. Help with function, not sure which one
  97. Using VLookup with 2 Workbooks
  98. Clearing fields when differnt function selected
  99. Help With A Spreadsheet for a silent auction
  100. Format custom number: C-0000-L
  101. How do I stop Excel from automatically resizing my row height?
  102. Return column header based on last value in row
  103. Excel is reading formula as a value
  104. Protecting sheets with drop down boxes
  105. open workbook to specific sheet
  106. Help to resove this problem.
  107. Combine several spreadsheets with multiple worksheets into 1 file
  108. COUNT BLANK AND ZERO AS THE SAME THING
  109. Save As Macro
  110. Help with N/A in formulas
  111. Checking the results of a number of IF formula
  112. Sum with 3 conditions
  113. Include CDF to workbook
  114. Multiple variables to sort and sum, return values<0 with sum refer
  115. Calculation of weighed average
  116. How do I filter cells based on character case in Excel
  117. How do I write an IF function using dates?
  118. sumif..
  119. SUMIF with OFFSET
  120. hyperlink help
  121. Alphabetizing
  122. Conditional Formatting Confusion...
  123. How to count merged cells
  124. SUMIF Function
  125. Match a value to multple criteria both in rows and columns
  126. Excel 2003 formula
  127. How enter time DURATIONS mm:ss (not clock times), then sum?
  128. Summing Data based upon a condition
  129. How to copy & paste a worksheet but change 1 bit of the formula?
  130. Sorting
  131. Making it harder than it is?
  132. complicated drop down menu question
  133. Automatic refresh in linked worksheet if row is added
  134. change multiple links at once
  135. .csv to .txt
  136. Multiple IF statement
  137. Hiding rows and printing
  138. Date chart formula question?!?1
  139. Return of value when copying a formula
  140. to Sohail
  141. how to count#cells w/= value in other column and not count blank c
  142. how to convert amount into text automaticaly in excel
  143. Hostname from IP address
  144. Pivot Table Totals
  145. How do i compare and remove common names from 2 excel work sheets
  146. Depreciation Spreadsheet
  147. Better Workday function.
  148. excel crashes when changing web query
  149. how do I change number format from 3,999.89 to 399989
  150. How do I count # of cells with same value other column?
  151. Formula to Return age
  152. Hyperlink to the meat of a cell
  153. copy data from one sheet to another using a combo box
  154. trouble with closed workbook
  155. How do I write this logical argument?
  156. Function Lookup
  157. Formatting does not follow when copying from one cell to another
  158. Printing problems with hidden rows
  159. RE: Counting text within an Entire Workbook
  160. Excel data disappeared after getting message about compatibility M
  161. Changing coler of tracking cells
  162. conditional formatting?
  163. @Count
  164. RE: Return a quarterly month, based on a cell (3 months from cell date
  165. Why won't text show in SOME cells?
  166. What is the most straightforward (elegant) way to write this formu
  167. Countifs
  168. editing a hyperlink
  169. Summing 2 columns based on variables
  170. IF equation will not calculate
  171. Remove Arrow
  172. speeding up calculation: replacing array formula with databasefunction?
  173. Formula for counting frequency then sorting
  174. Using Worksheet Name
  175. Formatting background colors
  176. How do I sum cells that have values from a text formula?
  177. shared workbook is set up is not 'shared' on network
  178. Sumif weekday
  179. Excel Beginner-need help creating speeding fines system with butto
  180. Need to copy and match data from one workbook to another workbook
  181. Inserting a calculated field in a Pivot Table in Excel 2003
  182. cell selection
  183. H and V lookup or match?
  184. my paste special function won't let me copy formulas
  185. data
  186. Leading zero's trail Number
  187. Sumif across a table
  188. excel 2007 filter 3 text values at the same time from the same co.
  189. Auto fill
  190. How to stop time format changing when I merge cell contents?
  191. summarising_data..!
  192. Creating macro
  193. Explain INDEX MATCH
  194. Calculating Time?
  195. Need to bring back 2 vlookup values
  196. Ending Macro in Last Row within a column of Printable Items
  197. Repeating rows not wanted
  198. Sumproduct error
  199. numbers in a column are not sorting ascending
  200. RE: Sum Indirect
  201. Count Unique text in 3 different columns
  202. Re: Sum Indirect
  203. Sumif for unique values
  204. Help with interpolating values
  205. Formula assistance required
  206. How do I use 'between' 95% and 100% for a nested IF function?
  207. count identical values in 2 rows
  208. How do I find the minimum value in a range while ignoring zeros?
  209. VLOOKUP not working with data from PeopleSoft
  210. Automatic Sumning of Same Cell from Different Sheets
  211. Vlookup formula combining two columns
  212. Trying to calculate # of times text string is displayed
  213. Match Account ID from combining street names and numbers
  214. Date Format
  215. calculate diffence between old salary and new salary
  216. Need help with ISNA, INDEX, MATCH
  217. Style worksheets differently
  218. copy excel spread sheet & graph to word doc without formulas
  219. VLOOKUP & Hyperlinks
  220. How to use VLookup with a range of numbers?
  221. Using multiple IF statements
  222. Excel 2007 - Personal Macros
  223. Complex If
  224. Weeknum formula
  225. Coloring
  226. Excel's COMBIN and integers
  227. Data moving 3
  228. Cell selection - turn it off
  229. Time difference calculation
  230. WHEN ENTER NUMBER , DISPLAY IN WARDS ?
  231. Address of cell in VBA
  232. How to combine Combo Box function with Vlookup function
  233. How to consolidate data from different files?
  234. lookup help. lookup result based on data in 2 columns
  235. Automate calculation...
  236. VLOOKUP
  237. Multiple IF statment help
  238. Calculations
  239. Multiple table lookup
  240. SUMIF returns no value
  241. hiding rows with an if statement
  242. Time Functions
  243. referencing in tables
  244. function to populate a cell where formula is NOT located
  245. Dynamic Table Problem
  246. Re: rearranging_names
  247. total point
  248. Re: rearranging_names
  249. Drop down list
  250. MS excell 2007 Data verification list
  251. Excell mistake in addition
  252. rearranging_names
  253. I have a complex formula where I need to build in a MAX function
  254. Data moving 2
  255. Working Days of Week and DUE DATE for PAYMENT
  256. New to VLOOKUP ...merge addresses?
  257. don't know what function to use
  258. Calculating a Target time from an Actual Time...
  259. references rename!
  260. Compare text in 2 different files
  261. NONFUNCTIONING FORMULA
  262. first some general questions about populating...
  263. Custom Zeros
  264. Count dates until complete or Cancel
  265. Index, Match help
  266. Formula Assistance - Vlookup
  267. COUNTIFS BETWEEN WORKSHEETS HELP
  268. How do I change the format to allow a zero as a first digit?
  269. Weeknum function help
  270. numbers need to be numbers
  271. Countifs for multiple worksheets
  272. Text to Number format
  273. eliminate duplicates on a sheet
  274. Printing Forms
  275. shortcut has change or move so this shortcut can not open
  276. Simple Consolidation of Worksheets
  277. Measure on the date different
  278. Rules for locking controls
  279. vlookup returns na
  280. vlookup doesn't return value
  281. can i short data with excel formula
  282. Conditional formatting with formula (multiple criteria)
  283. How do I reference the cell which returned a lookup value?
  284. Counting Filtered Results Using Autofilter
  285. Calculating new date by entering number of additional workdays
  286. Conditional Formatting 4th Condition
  287. Conditional Formatting: comparing cell values
  288. Need to separate and rearrange names
  289. Figuring Dates quit working!
  290. Help for sharing a worksheet from a excel sheet
  291. RE: rearranging_names
  292. HOW DO I CALCULATE WEEKLY PAYMENTS THAT VARY BY LENGTH OFTHE MONT
  293. VBA to sidestep popups...
  294. See if cell value appears within a value range given by another cell.
  295. Absoute Cell Ref Changes When Inserting New Row in Referenced Shee
  296. Formula/Function for parsing data
  297. I want to show only the first three columns
  298. Conditional
  299. Re: rearranging_names
  300. Dup check 2 columns - need it to delete correct one
  301. How do I make first row sort in table
  302. how do I sort by picked-up date in Excel
  303. Change formulas in a column based on a selection.
  304. counting colored data
  305. Sorting in Excel
  306. help with formula
  307. In Excel, changing a range of cells to all caps.
  308. How do I create a drop down box within a drop down box?
  309. Round formula
  310. IF - Date falls between two dates, place here
  311. Problem with Excel getting correct # of records back from Access
  312. Think I need a MAX / MIN formula here (help needed)
  313. Adding an aditional forumla to this one
  314. how can you freeze links in excel? no #Ref upon opening the file?
  315. Handling Dashes in IF statement
  316. Range of values
  317. Consecutive numbering
  318. problem with linked workbook
  319. save by & date, time
  320. Autosum problems
  321. Unique filtering to another sheet ?
  322. IF formula not working
  323. Lookup within a 2 dimensional array
  324. Looking a value up for a
  325. multiple cells are often selected when I click in only one cell
  326. Macro to get rid of #DIV/0!
  327. Relative Range Reference in a sumifs formula
  328. I have a workaround
  329. Data Range with more than value
  330. Additonal info into newly created Subtotal row
  331. Count Data in Series
  332. Automatically copy formula in column when adding new row....
  333. sum if one or another criteria
  334. Really need some help with a tricky formula
  335. VBA Macro help
  336. Return Value from a Range (depends on input to determind month)
  337. Data moving
  338. Looking up whether one item has a certain matching item
  339. Frequency Counting
  340. Removing duplicate records based off of date
  341. Populating Row with dates
  342. Custom Formating Letters to Numbers while Displaying Letters
  343. Re: How to convert 115:14 into hours? ( 115 stands for hrs, 14 is minu
  344. excel conditional formatting
  345. Adding certain cells in one column
  346. Maintain lowest value in an "external connection" cell
  347. index, match in array setup question
  348. Return range of cell values based on current date
  349. UNABLE TO SAVE FORMATTING
  350. Automatic recognition of a starting point for a column calculation
  351. Checkbox - Output results to a csv file
  352. Sumif with a or condition.
  353. Make copy of workbook based on selected criteria
  354. another sumifs plea
  355. Tabs Names
  356. Force entry in one cell due to the value in the other
  357. GETPIVOTDATE Funtion
  358. Formatting Phone Numbers in Excel 2007 Help
  359. Countif function to show how often numbers within a range are pres
  360. Need Help
  361. IF statement help please
  362. Conditional Formating Highlight Results
  363. Protected Sheets
  364. Need a type of lookup / find formula PLEASE
  365. Lookup function question
  366. Programming style with worksheet functions - discussion invited
  367. Unique Rank with Duplicate Entries
  368. Array function - I think!
  369. Formula for counting cells with value 'x' provided Col U = 'y'
  370. setting cell values based on a 3rd cell
  371. Unique Rank with Duplicate Entries
  372. 1-4-1 is not a date how do I stop excel from changing whats enter
  373. Rows to table
  374. copy formulas with fill handle
  375. to lookup data for 'today()'
  376. cell vlue based on cell back colour
  377. EXCEL
  378. Alert Message After Somthing Changed
  379. Folder listing
  380. Calculating column A * column B = Results in another column
  381. how to number cells (1,2,3...) w/o having to manually type them al
  382. Automatic selecting and sharing of data accross worksheets
  383. Dates changing colors
  384. Writing an IF statement in Microsoft Query
  385. Conditional Formatting on Range of Cells
  386. Share a workbook
  387. Sumproduct with more than one valid criteria
  388. INDEX and MATCH with range
  389. Unique Rank with Duplicate Entries
  390. ISERROR on VLOOKUP
  391. Adding A Date To Adjacent Cell
  392. RE: how do I create independent results?
  393. Excel Functions
  394. Auto fill text columns based on rows
  395. If-Then logics
  396. Grouping and percentage calculations
  397. Networkdays and misleading results from blank column
  398. Need some help BAD with conditional formatting
  399. Doing a countif against a substring of the range to be scanned
  400. SUMIF with NAME RANGE
  401. Count # items in ColA if blank in ColB
  402. How do I page break in the middle of a row in Excel?
  403. MSNstockquotes option quotes
  404. I need to copy half of the info in a cell...
  405. Trim varying decimals from column of numbers
  406. count if for blanks with 'or'
  407. VALUE appearing (referencing blank cell)
  408. Creating column
  409. Help with IF stament (getting result FALSE in some cases)
  410. Using rank to rate the winners in a competition
  411. Table Data Missing
  412. =vlookup(A1:A835,"bbb",AI7:AL165,C7:C165) giving #value! ????????
  413. Generating Possible Combinations and Assigning ID Number
  414. excel
  415. datevalue returns #value
  416. how to copy 3 spreadsheets and get the formulas to work
  417. Why can't I use the MONTH function within the SUMIFS statement?
  418. Conditional Sum - Moving Average
  419. Conditional Sum - Moving Average
  420. Help? with extracting unsorted data from a worksheet, no blank lin
  421. Re: Copying rows down into cells across until row=false ?
  422. HOW CAN I USE "MODE" ON WORDS (NAMES OF PEOPLE)?
  423. Excel's COMBIN and integers
  424. Worksheets are stuck on default text format with left align
  425. How specify number format of cell value in concatenate function?
  426. how do i set an alarm to work on excel
  427. Multiple Conditionals in MS Excel 2007
  428. Hello,everybody,the good shoping place,the new year approaching,
  429. change position of data
  430. someone please shorten this formula...
  431. Combine Two Arrays Into One. Tough.
  432. Changing Content in one coulumn using given content in another
  433. Copying rows down into cells across until row=false ?
  434. If and Vlookup
  435. Excel formula
  436. sorting in Excel 2007 problem
  437. SUMPRODUCT with two valid criteria
  438. Collating copier reports
  439. How can I figure square footage for 2 or 3 numbers in a row?
  440. Help with Value in one column...
  441. Color Me Red
  442. using a IF statement to return a value
  443. show pages on a pivot in 2007
  444. vlookup, indexing, oh my....
  445. Multiple conditional formating for one cell
  446. FORMULA BAR DISAPPEARED IN 2007, HOW DO I RESTORE PLEASE?
  447. I need to indicate a missing # in a series
  448. creating macros
  449. Adding and then sorting data into an already existing Excel 2007 w
  450. Date Function
  451. How do I get functions added within EXCEL?
  452. how do i find out what data is hidden i excel
  453. Is there some 'secret' to getting 'End' to work when stopping func
  454. Unable to Unlock Workbook
  455. IF with function as false return
  456. Using DCOUNT
  457. Toolbar question
  458. IF or VLOOKUP
  459. Button, now too thin, cannot select to delete
  460. How to carry Excel balance on 1 w/s to another?
  461. ISERROR and INDEX Funcion question
  462. List the last amount that is state
  463. Using VLOOKUP to find colours
  464. Filter formula
  465. Calculating percent of times a value is in a column and total #
  466. Imposs? Speed up
  467. Re: Calculating greatest number in a range
  468. RE: Complicated Excel Forumal (to me!)
  469. Round
  470. can't use append xml results. Its always grayed out
  471. Drag Mouse and Add-up
  472. Ageing dates
  473. excel dates
  474. COUNTIF for 2 columns
  475. data not carrying over from access to excel
  476. feet and inches to meters
  477. Calculate the number of days to exclude Sunday & Holidays
  478. Combining data
  479. sorting data
  480. convert vertical to horizontal
  481. Trying to match 1 value to multiple columns
  482. Repost - Functions on filtered data
  483. Sumproduct with Multiple Criteria
  484. First Day of the month
  485. Array formula to find date
  486. Print Preview Different than What I see in the Excel File
  487. reference cell from advanced filter
  488. Removing ''VALUES''
  489. Functions on filtered data
  490. SUMPRODUCT help
  491. Formula for multiple countifs
  492. Count Occurences of Dates Between Two Dates
  493. How can I use a pivot table as source for a second table?
  494. IF - more than seven arguments
  495. General Calculator
  496. counting based on two conditions in excel 2003
  497. How can I count values in multiple non-consecutive cells?
  498. Entering Formula - Cannot select cell as it is hidden by formula
  499. Missing Record in Table Lookup
  500. How can I allow users to sort a protected table using dropdowns?
  501. find
  502. Filling formulas with specific cell references remaining the same
  503. Use vlookup within offset?
  504. Sorting Function
  505. Segrigation of different datas from one colum
  506. Formula Question
  507. Last cell with data in a range
  508. Sumproduct, but errors in column
  509. Excell Spreedsheets
  510. Excel data from spreadsheet to database
  511. count values in a column, but. . .
  512. group/ungroup protected sheets?
  513. Row Height Adds Blank Space at End of Text
  514. Select 'Sort By' column by simply typing heading letter
  515. Vlookup possibly ?
  516. Circular Reference Warning ???
  517. mark up
  518. adding result of "if" statement..
  519. count number of dates in range
  520. SELECT SUM(h) WHERE e = 'eBay Payment Sent'
  521. Count filled cells in range if they are one after the other
  522. adding figures that match 2 true and 1 false if statement conditio
  523. Date Formatting
  524. Excel not pasting the formula or reference
  525. Too many rows highlighted
  526. Sumproduct?
  527. Complicated IF statement - desperately need some help
  528. HELP!
  529. In new Office 2007 EXCEL, can more the 8 IF statements be used?
  530. Looking for Text strings
  531. Pivot Table - Calculated Field
  532. Excel 2007 - Autocomplete Alpha List
  533. Downward column
  534. Data Connection Wizard
  535. Hidden column
  536. formula question...
  537. Collecting data from Excel form
  538. Hello,everybody,the good shoping place,the new year approaching,
  539. Convert Date in Text to month and Year
  540. file names
  541. Data Validation drop-down width, with named range source (XL03 and
  542. Calculate Number of Days worked in Each Month by Project
  543. Matching two sets of data?
  544. VLookup with Search for in String
  545. Calculating Resolution Rates
  546. Indirect and Sheet Name
  547. "AND FUNCTION" RETURNS FALSE WHEN CRITERIA IS TRUELY MET. HELP!!!
  548. Multiple IF function
  549. Nesting Lookup Functions
  550. Using Sumproduct when some of the values are null
  551. Justify across selection
  552. Data Validation List from a Dynamic Named Range on Another Workshe
  553. SUMIFS using a text range
  554. SUMIFS using a text rage
  555. SUMIFS using a text rage
  556. Date Format
  557. macro shortcut help
  558. counting function with weekdays only
  559. Lookup on a combo box
  560. How do I create a travel expense report by employee, by campus, b.
  561. Pivot Table Refresh
  562. IF Multiple Conditions
  563. date format error in cell
  564. Column Average Given 2 Criteria
  565. How do I validate / verify the output from a spline curve
  566. Link an entire Row with a Key Word
  567. testing range of cells for part of cell content
  568. Lookup 2 values to return 1
  569. DATEDIF FUNCTION NOT LISTED IN HELP
  570. Excel 2003 Macro - Finding rows with data to copy
  571. A link to a collection of videos and tutorials on MS excel:Data mining Add-in
  572. Publish interactive data to the Web using Excel (Problem)
  573. How to sort duplicates?
  574. formula for multiple criteria inc. date range
  575. Data Validation List - Can I have multiple ranges displayed?
  576. How to generate a cell reference from multiple cells
  577. Conditional Formatting
  578. Last number in a column shows in the total/summay line cell
  579. combo box
  580. Trying to convert mm/yy in text to Dec-07, it adds day & current y
  581. Create an automatic worksheet with two variables
  582. Need help with macro for conditional formatting using number forma
  583. Removing Special Characters
  584. find all instances of a search item and put result in a single cel
  585. How to know if a worksheet was unlocked
  586. Way do do search/replace on beginning/end of cell w/o functions?
  587. annualize sales for remainder of year
  588. Help with a IF formula
  589. Redistribution of values after reaching maximum
  590. Counting for multiple situations
  591. Is this an Index/Match formula?
  592. HLOOKUP into another xls file
  593. Sumproduct using 1/ and DIV#0
  594. multiple correlations with one click?
  595. EOMonth function
  596. convert vcf to xls
  597. Conditional Formatting Help when a Cell is Blank
  598. how to get rid of default dates in Excel?
  599. the criteria pane and table panes have disappered.
  600. formula for displaying only the last entry of a group of cells
  601. IF, INDEX and MATCH
  602. How do I stop text from disappearing when I wrap text in Excel?
  603. Question about syntax for conditional formatting
  604. Using match but data needs to be split.
  605. Staff Overtime Form
  606. Line Feed in Formula Adds Double Quotes?
  607. Using Mid Function with Pivot Table Calculated Item
  608. Freeze the side column/top row & scroll others
  609. no respond/answer from formula entry
  610. Excel "data base engine failure"?
  611. Formula help for beginner
  612. Automating a Worksheet
  613. Automating a worksheet in Excel 2003
  614. How do I copying data from a cell on sheet to a diff cell/sheet
  615. RE: Cell Formats & Hiding
  616. Conditional Formatting Assistance
  617. Combine macros variable help
  618. How to get repeatable Excel RAND sequence?
  619. Re: Convert Array Formulas to Regular Formulas
  620. Help with conditional formatting...
  621. Warning when in another cell after entering a formula.
  622. Shade a Cell
  623. calculate a date, 10 weeks after a set date & return a specific da
  624. comparing two colums ? countif
  625. Help to display chosen columns and rows
  626. Re: Variable Labor percentage based off of fixed sales +/-
  627. Indirect formulas in cells not holding cell format after copy
  628. Validate data but then change the entry to upper case
  629. wildacrds
  630. vlookup function returning "na" even though the vlaues are present
  631. Excel Logical IF function
  632. formula to a minimum value of zero if a negative number
  633. Counting formula
  634. Moving Cell Formula
  635. Vlookup problem
  636. Making an excel sheet so formulas can not be deleted in the sum to
  637. Weeknum Within a Range
  638. sumproduct with 4 conditions
  639. If then between two dates
  640. Posting the workbook
  641. AVERAGE last 4 Mondays?
  642. Vlookup with variable column reference
  643. Is there a function that counts distinct number od records in a ra
  644. Vlookup with If condition
  645. Row Height or Column Width not Showing
  646. Recurring header.
  647. combining dates and text in a cell
  648. No Balance Owed Flag Help!
  649. Multiple sheet querries
  650. formula required
  651. what does the size 1/72 means
  652. Messy Formuula Needs Clean up Help: Part 2 (Clarification Please)!
  653. Two digit number with one decimal, or three digit number
  654. Trying to collapse a table, what Function should I use?
  655. how do i create a formula to give a workday date?
  656. cell to have comma-delimited values based on text
  657. a Counting question
  658. Extracting the last word from a string.
  659. How to check if the values in a range of cells are greater than 0
  660. Excel 2007 Countifs macro with multiple criteria (OR)
  661. Move or Copy function does not work
  662. IF statement based on True/False that activates a certain list box
  663. Electricity Bill Sheet
  664. Addition to a working formula
  665. Lookup 2nd & last match with two conditions
  666. What caused my paste function not to work?
  667. Messy Formula needs clean up help!
  668. insert rows--->protected sheet
  669. Countif Function??
  670. loan amortization template
  671. Use CountIf for a literal string
  672. Hlookup with Merged cell as look up value
  673. T.Valko function
  674. Auto Filter - It's broken! Help! (Office '03)
  675. COUNTIF over 2 columns
  676. Conditional Formatting with 3 Criteria Options
  677. Restrict data entry in a cell
  678. Conditions Not Accurate when subtracting time
  679. subtraction returning incorrect calue
  680. formula patterns with a gap of two
  681. LookUP function with multiple variables and worksheets
  682. Conditional Formatting for a dashboard with a drop down menu
  683. paste values Excel 2007
  684. Count with two criteria
  685. Sumproduct but only first time corresponding value is seen e.g. un
  686. Average with Conditions
  687. Conditional Format for Blank Cells
  688. =AND($B$12<>"",$B$12<TODAY()+60) What does the <> mean in this?
  689. How to calculate text according to multiple months?
  690. multiple worksheets
  691. VLOOKUP with HLOOKUP
  692. retrieving current data
  693. salary defined by slab table
  694. How to enable auto height with merged cells?
  695. Microsoft 2007
  696. Macros
  697. Can I use "*xyz" in a formula
  698. Hide formula in list
  699. Formula Result is different from the shown result
  700. I think I need a multiple IF statement, or is there another way?
  701. lookup second / last match with two conditions
  702. Changing Defined Names
  703. column corresponding to row number
  704. Degrees Minutes Decimal Minutes to Decimal Degrees.
  705. SumProduct not Working in a Macro
  706. Formulas that recognise data from two worksheets
  707. Vlookup, IF, concantenate, Right -- can all these be in one formu
  708. How do I find a value in a table without using the labels?
  709. sumif concatenate formula
  710. Multiple functions
  711. Excel merging and automatic edit of worksheets
  712. Auto calculate
  713. Average with Condition
  714. Moving cell formula
  715. IF INDEX and MATCH function together
  716. Access to a series, when it is assigned to an empty range
  717. How to combine data from 2 separate workbooks onto 1 worksheet
  718. Print to file
  719. Add comment in protected worksheet
  720. Problem with subtotal function
  721. Excel 2007: Conditional Formatting and Ribbon Data
  722. Microsoft Excel Total Values
  723. text as value in pivot table
  724. countif with a condition and contains @
  725. Search Entire Sheet instead of 1?
  726. Formulas
  727. Insert Picture
  728. leave sum of j7 at 40 or less put excess in k7
  729. Replace Cells with Column names in functions?
  730. negative time summation calculation for a standard day
  731. How to return to the previous active sheet after hyperlink?
  732. implementing formulas in excel
  733. summaries on alternative sheets
  734. i can't get this formula to work
  735. How do I recover the autosaved file?
  736. How to replace formula with its result
  737. actual row number
  738. Highlight date nearest to TODAY()
  739. RE: If and LOOKUP - results in multiple columns
  740. How do you search within a document?
  741. How can I test the text content of a cell
  742. Help needed with a formula for dates in excel 2007
  743. Help with formula: finding text
  744. hiding an image
  745. Re: Using a cell's value to copy another cells info to another workshe
  746. Summing a crosstab
  747. Cash Statement- Accruing balances
  748. Re: SUMIF with multiple criteria
  749. RE: If and LOOKUP - results in multiple columns
  750. don't want to have to change font in header and footer each time?