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. right syntax
  2. count similar text with using filters
  3. Help with SUMPRODUCT & converting date to value
  4. Conditional Formatting
  5. Match - not sure how to use this function
  6. activate formula when adjacent cell populated
  7. Re: conditional formatting
  8. Compare
  9. Excel 2007 Pivot Tables compatible with 2003
  10. Changing cell colours on a pie chart
  11. Top 10 in pivot - show rest as other or similar
  12. formula to copy from a cell
  13. How to insert Checkbox in excel to simply click and tick it?
  14. Index, match, multiple IFs query
  15. About Data Validation
  16. inventory
  17. Count If equals x AND y
  18. Graph Paper
  19. Combining cells with text
  20. Regression Formula
  21. make a check form, and then have info go to a check register
  22. In Excel need to have a sub worksheet inserted into each row
  23. Pivot Excel 2007
  24. Count blanks by date
  25. lookup?
  26. set flashing alarm by a date for a text box
  27. Match data
  28. LOOKUP formula when term may not be present
  29. Trending Function?
  30. formula for month that is prior to actual
  31. Latest Purchase Price
  32. RE: conditional formatting
  33. averaging a range
  34. How to freeze one column vertically, one horizontal in same sprdsh
  35. formula for visible cells
  36. Identifying a label.
  37. Count, Sum, Index,Match or other formula needed
  38. Counting results of a formula
  39. Auto update worksheets
  40. copied from web page to excel sheet and cant remove from sheet
  41. Excel Security
  42. Vlookup?
  43. Macro Help
  44. SumIf AND
  45. Formula for competition pairing
  46. change text color when the value become lower than a certain value
  47. Vlookup and match part of text in a cell
  48. Increment a number based on four adjoing cells
  49. keep formula delete contents
  50. how do I achieve my xl spread sheet in Alphabetical order
  51. How can I reference a worksheet in a formula based on a cell value
  52. Find latest date from list and corresponding info
  53. Help with Conditional Format Formula
  54. Aggregating data among multiple workbooks
  55. random number generator
  56. Conditional Formatting - stuck on formula
  57. Formula to sum based on a change in another column
  58. Lookup / Summary Table
  59. filtering subtotals and if functions
  60. counting occurences of month on a specific worksheet
  61. counting how many times a certain month appears
  62. Simple calculation where values change to letters?
  63. Lookup / Summary Table
  64. countif/sumproduct + month
  65. counting occurences specific month appears
  66. how to change the pivot chart automaticaly as values in the worksheet change
  67. conditional format help
  68. code to copy range
  69. formatting a spreadsheet help
  70. Format Ratio Q
  71. IF function
  72. sort 2 column in the same time "" as dictionary ""
  73. Using Fill command in Editing Group
  74. how do i use format cells to alpha / numeric values
  75. Macro for Time Recording
  76. Excel and consecutive number
  77. Maximum number of cells for 'SUM' ?
  78. Copy formula from one worksheet to another to get value in 2nd wks
  79. IF Function Help
  80. Logical Test for blank and then for score
  81. summary values across worksheets within the same workbook
  82. Drop list and redirect
  83. Having problem with referencing
  84. Sumif Function
  85. Conditional Formatting on Index,Match formula
  86. Count Multiple Text Entries
  87. YES or NO formulas
  88. Conditional formatting problem
  89. Need some help with auto-fill
  90. Nested formular to give a word answer based on 2 cells
  91. determine a range using a formula
  92. VBA to autofill from relative location
  93. SAMPLE EXCEL DATA
  94. extracting data from one cell to another
  95. Multiple AND OR functions
  96. IF formula help
  97. Pick List + Alphabetical Skip To or Auto Complete
  98. Rank order with conditions
  99. VLOOKUP help (possible format issue)
  100. need to install DVZXLAddin.xla
  101. protection error
  102. counting unique text values in an array of data
  103. Dynamic sheet reference in Name formula
  104. Vlookup return 2nd match
  105. Finding most recent date for each customer - XL 2007
  106. Average IF Function
  107. Adding fill to cells only when value is "No" in another cell
  108. Counting Results of Formulas
  109. search excel for overpopulated cells
  110. Dynamic pivot table linked to dynamic excel spreadsheets
  111. Insert Lines
  112. Formula to calculate Latest Cost (inventory valuation)
  113. complex lookup
  114. ActiveX from 2003 in 2007
  115. How do I remove data in a row in excel without losing all data in
  116. SUMIF? or not?
  117. I want to conditionally format an entire column after 1 year from
  118. Count Text to get a Percentage
  119. Formula issue.
  120. IF, THEN HELP
  121. RE: Format a dollar amount to text
  122. RE: Format a dollar amount to text
  123. Help with lookup
  124. using GETPIVOTDATA feature and need to keep formatting
  125. negative value
  126. Re: Copy is criteria met
  127. Combine an And OR function
  128. Re: Copy is criteria met
  129. dates on worksheets
  130. When I search on my name "Meenie" I don't get 2010 posts
  131. need formula to add two different criteria in a range
  132. Copy is criteria met
  133. sumif formula
  134. result given from content of selected cells.
  135. Dragging values down a range using a colum to determine its length
  136. How does one put a watermark in an Excel worksheet?
  137. Imperial Weights in Excel
  138. Counting Characters In A String
  139. if statement, change cell only if true
  140. Build 'show 0 as -' into existing formula
  141. Advanced Data Filter
  142. Adding data from multiple cell and linking to a new worksheet
  143. Slope??? help please!!!
  144. Adding Fractions and Displaying as a percentage.
  145. Vlookup - Returning 2nd match
  146. Record time by formula
  147. formula help
  148. adding time in a work schedule
  149. HOW CAN i DEVELOP A FORMULA THAT RESTRICY SYMBOLS CHARACTERS TO B
  150. Which (logical) function?
  151. Sorting a portion of a worksheet
  152. Running calculation of a frequency
  153. Excel Workbook with Multiple worksheets
  154. count text with * wildcard and date range
  155. Reverse $String1, String2 to $String2 $String1?
  156. splitting cell content from 1st column into 4 columns
  157. Average formula where blank cells are counted as zeros
  158. taking numbers in vertical cells putting them in horizontal cells
  159. Formula Help
  160. Average IFS (Multiple Criteria)
  161. Average IFS (Multiple Criteria)
  162. Possible to have various sections of worksheets print on 1 page?
  163. Average IFS (Multiple Criteria)
  164. Pull info from one excel file to another depending on values of O.
  165. Index Match Problem
  166. Pivot Table Comparison
  167. How to remove a bunch of zero's
  168. How do I get warpped data to auto fit in merged cells?
  169. Default Cell Values at Change
  170. date from sheet name
  171. Deleting/Clearing duplicate range of cells
  172. Using wildcard characters in find & replace
  173. HOW DO I COLLECT TEXT DATA FROM A COLUMN
  174. Keeping the format but update the data
  175. Calculate Accrued Time
  176. SUMIF Help
  177. If column A = B then pick up value in D.
  178. Using cell reference with logical operator in DGET expression
  179. Establishing a Time Window
  180. Increase PF Usage
  181. SUMPRODUCT with conditions
  182. Help with Vlookup
  183. To deal with #NA
  184. How to find the custom xml tags in a workbook
  185. Drop Down Menu AutoPopulate Contact Info?
  186. Average Unique
  187. Average If...
  188. How do I set a constant multiplier in an equation?
  189. How can I merge unprotected cells in a protected worksheet?
  190. if function help
  191. How do I delete a calendar function from a spreadsheet
  192. compound if equation?
  193. FDIST Function
  194. Removing items on Sheet1 that are common to Sheet2
  195. auto format
  196. FAO Mike H - Formula Answer provided
  197. How to use autofilter in excel with formula reference changing
  198. "Can not empty the clipboard"
  199. Need solution for wildcard use in array
  200. Formula to fill one cell from another
  201. Correlation tool says Input range must be contiguous reference.
  202. How to?
  203. MSN Stock Quote
  204. Significant digit causing wrong value?
  205. Using VBA to find a value and select a range
  206. Formula help
  207. Worksheet relative reference
  208. Counting dates within a range
  209. Missing values from a pivot table field
  210. add two cells from seperate work sheets into a cell on seperate wo
  211. is it possible to insert a pdf document into a excel worksheet
  212. Ctrl V paste coding was lost
  213. Date formula needed
  214. Identifying the top five values in multiple groups
  215. how do I double check that there are no formulas
  216. Calendar
  217. error alert for invalid date
  218. Cell Formatting of a Conditional Statement
  219. Modify general format to date format.
  220. Index using a defined name array
  221. Nested IF & AND functions
  222. Suppress First Page Numbering
  223. What is the formula to Round an average to the nearest 100
  224. Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible
  225. excel: How to set up a formula for a range of numbers ie. 3.5-5..
  226. Can Excel trigger Outlook reminder?
  227. Formula Help
  228. Formula addition causes random #REF!
  229. Fill/Extend Series adding decimal points to some numbers
  230. colating data from a table - for bespoke report
  231. Is there a function to solve for an unknown in an equation?
  232. what should be simple
  233. question related to merging multiple statements
  234. Date + relative number reference
  235. Help Needed with Dynamic CountIF
  236. Referencing relative to a formula reference
  237. limit comments to only 600 words
  238. Excel Formulas
  239. IF function
  240. Finding matches in two columns
  241. Show matching data in several worksheets
  242. RE: Can I SUM column C IF Column A=X AND Column D=Y?
  243. Find second to last value in cell
  244. Referencing formula using Indirect
  245. SUMPRODUCT
  246. how do I copy the last 20 entries in an expanding list
  247. Head scratchin for hours.... Help with a formula please...
  248. Drill down via page fields
  249. Satisfying two conditions?
  250. Format Data Labels
  251. INDIRECT reference or ?
  252. Excel formula help needed!
  253. Vlookup and Indirect
  254. Reference: forum discussion dated 17-18April2010
  255. List the UNIQUE certain fields from the database
  256. Count the frequency for every change in numbers
  257. Daily totals from a monthly log
  258. Links not working in Excel 2007
  259. Creating a formula
  260. problem with lookup function
  261. How do I use a percentage formula?
  262. Locking Worksheet Security Name
  263. Pre-Populating Fields
  264. Word lists
  265. Dynamic DropDown list from Unsorted vector
  266. Calculate number of days
  267. COUNTIF Formula
  268. Change a cells value with a function
  269. Need a code
  270. Shared Excel File
  271. VLookup between date ranges ?
  272. Excel Formula for years and months
  273. ODBC Query
  274. Despite formula I use (for example SUM) result is always zero.
  275. VLOOKUP and IF together
  276. How to select other random cells
  277. Can not copy a sheet to another book
  278. Formulas do not update
  279. Lookup
  280. Automatically hide/unhide rows
  281. Help me (Vlookup)
  282. how can i transfer data from one sheet to another without blank li
  283. Count first and last characters
  284. Import underscore in coding every after 2 digits
  285. How to Sum infinite formula
  286. GETPIVOTDATA and (blank)
  287. 11 months and 1 day from a given date
  288. how to remove all formatting
  289. Copying Cells with Fill Handle
  290. background colour of sheet gone gray need to change to whit
  291. "#VALUE!" Cell Value
  292. Conditional Formatting in Excel 2007
  293. How do I use sumifs -
  294. Sumproduct with 4 variables
  295. Counting by color
  296. why this strange result with vlookup
  297. Percentages in Pivotal
  298. looking for a function that will populate opening a worksheet or t
  299. Grouping on protected worksheets
  300. When refreshed, some Pivot Table columns retain formatting, some d
  301. multiple IF calculations
  302. Excel - How to get tab to go to next unlocked cell across columns
  303. Default Cell value in changing environment
  304. identify the numbers cancelling by amounts
  305. Centreing Text In Excel Cells
  306. copy paste value
  307. I want to compare two coloumn particular text, then count total
  308. More than 7 If Functions Example is IF(A2="Bongaigaon", B2*40, ..
  309. vlookup with two recors
  310. Reference different lines in the same cell
  311. Which formula combination will solve my anticipation
  312. How do I search for the second largest value in the array?
  313. combine multiple spreadsheets into one workbook
  314. Installing service reminder popup windows in excel
  315. How do I get the formula icon back on my toolbar?
  316. Conditional Formula Words
  317. logical (if a1=specific word, can c1 = value entered in a2?)
  318. Excel 2003 make 1 date cell automatically change another date cell
  319. Keep lines when one column equals certain criteria
  320. how do i create a repeating student certificate using excel
  321. Text to values
  322. How do i set up a concecutive numbers in Microsoft excel sheet?
  323. GETPIVOTDATA and Date-type field (Excel 2007)
  324. Categorizing Data Question
  325. Rounding Seconds in 4/21/2010 4:30:23 PM
  326. Conditional more than one iif
  327. How do I update links from .xls sheets to .xlms sheets
  328. Logic Formula using colors in the formula?
  329. Formatting question with Round
  330. COUNTIF: everything in a row larger than zero over multiple worksh
  331. Vlookup + sumif , but how????
  332. Display formula Excel uses for internal functions (STDEV...)
  333. Conditional format will not work without $ (removed to allow copyi
  334. Conditional Formatting Question with 'OR'
  335. Reorder $String1, $String2 to $String1 $String2?
  336. Excel 2007 Page Break Adjustments causes a page break each cell
  337. Excel 2007 on Vista
  338. Combine two sets of overlapping Date/Time data into 3 columns.
  339. Help with Date Function
  340. VLOOKUP in VBA
  341. Search Macro
  342. Counting values in an array where value in one column is not null
  343. Count values in array of data where no blanks in one column
  344. Pulling/Collating Data from Workbooks
  345. Range Vlookup
  346. Return cell characters after space
  347. multiply value based on quantity
  348. Convert times to text string
  349. comparing more then one column with numbers and letters
  350. combining columns and using concatenate
  351. Filter
  352. excel - horizont line above font X
  353. Open multiple spreadsheets and pull data
  354. How to hide infromation in Excel?
  355. If then
  356. Text to Date
  357. Total a column (or row0 by highlighting cells
  358. Lookup value that falls between two values in a range and then som
  359. pulling a list of hyperlinks from a worksheet
  360. transfer cell value from 1 sheet to another without copy/paste?
  361. Calculating daily totals from multiple worksheets (Excel 2003)
  362. Charting the Sum of Two, or More, Series of Data
  363. Count If.....help
  364. Automatic update to SUM formula cell references.
  365. Vlookup issue
  366. IF and Right Functions
  367. Sum Function Visible Cells only
  368. Avg % above 0%
  369. Changing the range for averages with out changing the formula.
  370. Functions / Drop Downs won't calculate
  371. Show zero values in specific area
  372. Saving & Removing VB Code from WB
  373. worksheet
  374. Reconciling Invoice & Credit
  375. Conditional formula
  376. Re: Re:COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard"
  377. Getting the average from a column using date constrants
  378. Counting consecutive negative value
  379. Excel corrupts when asking to update vlookups
  380. Re: COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard"
  381. Formula Excel
  382. conditional formula needed
  383. how do I drag and fill hyperlinks?
  384. Averaging times that are not in a range
  385. Data Encryption
  386. Getting a value by comparing 2 columns
  387. Id'ing tabs that contain #REF!'s
  388. COUNTIF Function
  389. Dynamic formula
  390. revised q on report from tables
  391. Custom Functions Available for all Workbooks
  392. Re: Text from Referenced cell truncated
  393. Function to Use when compare sums another column
  394. Pivot table to calculate variance showing budget and actual.
  395. formula similar to "countifs" function in excel 2007
  396. Help with formula
  397. Too Few Rows to copy sheet to another book
  398. single report on data in 20 tables
  399. Drop Downs and lookups from other sheets
  400. Excel Toolbar
  401. i dont know if sumif ,,,,, please help
  402. Automatically insert rows/copy formula
  403. Date refrencing
  404. finding 10 smallest numbers from last 20 input
  405. Formula assistance please . .
  406. COUNTIF PROBLEM
  407. Check the lasta character
  408. hiden cells copied automatically to another workbook, can I stop .
  409. Compare two columns with different codes
  410. need help with formula
  411. Finding duplicate addresses
  412. Deleting Row
  413. compare 2 columns, enter data from other column
  414. Re: multi-worksheet sum
  415. Conditional Copy from one worksheet to another
  416. Re: multi-worksheet sum
  417. Complex functions
  418. How do I match 3 different workbooks information for similar data?
  419. how do I perform an interpolation analysis using Excel?
  420. Multi NetWorkDays Calculation
  421. Vlookup and Data Validation Q
  422. What does this formula mean [$-F400]h:mm:ssAM/PM
  423. Top half of covariance matrix
  424. Linking to other worksheets
  425. Sorting
  426. m4=b4 only if
  427. Lookup Question
  428. What happened to setting up a constant using F4?
  429. Linking Totals Across Multiple Worksheets
  430. to CONCATENATE from the smallest date with at least 2 criteria
  431. Font by way of function?
  432. Store formulas in Vlookups? (another try ;)
  433. SUM determined by drop-down list
  434. Validation of UK VAT Number
  435. Date question
  436. Function to seacrh for a word across multiple columns
  437. Add text automatically by recognized value
  438. Sumproduct with mixed data?
  439. Re: multi-worksheet sum
  440. counting groups of words
  441. formatted cells
  442. Converting PDF or HTML to Excel
  443. Count if past today () - 30 days
  444. If 3 If's, then sum
  445. Dynamic Filtering...Need Help
  446. Finding the lowest cost for a product from a list
  447. RE: multi-worksheet sum
  448. Using text and formatting sum function in formula
  449. Identify the windows just below the menu
  450. Can you sum the amount of type a word appears?
  451. Formula
  452. RE: Week ending Thursday formula
  453. excel 2007 macro recorded pivot table
  454. Re: Average numbers in noncontiguous columns ignoring 0's.
  455. concatenate
  456. Re: Week ending Thursday formula
  457. networkdays issue
  458. Sum of retuned valus as digits
  459. search a row for a word and if found
  460. Concentration Analysis
  461. Finding NEXT to last, non zero numeric value in a row
  462. copy formula
  463. Conditional Formatting Date Range
  464. SUM
  465. If function help
  466. copy/paste malfunction
  467. Maybe too hard to do?
  468. Re: Average numbers in noncontiguous columns ignoring 0's.
  469. Interval between now and next birthday
  470. Function similar to "LEFT"
  471. annuity calculation for monthly payments but quarterly compoundin
  472. spreadsheet
  473. Need function to return numbers at beginning of text
  474. VLOOKUP returning formula
  475. Can excel data be encrypted?
  476. CONCATENATE
  477. comparing data in excel
  478. Add no. of days to a workday to get new workday?
  479. Compare 1 cell to column of cells returning adjacent cells info?
  480. Sort
  481. Pulling a cell reference--clickable cells?
  482. Logical function please
  483. #N/A help please
  484. copying a formula down wards
  485. Rounding Up question
  486. Add values based on text color with the criteria of a date
  487. rounded # to correct #
  488. Sumproduct with a twist
  489. creating a report from a table, pivot table not suitable
  490. Pivot table show all days of a month even if no data
  491. VLOOKUP & IF
  492. Convert percentage into margin
  493. pounds shillings pence format in excel
  494. Help with If Sum statement - i think....
  495. Can I combine a Vlookup with an IF formula?
  496. Sumif with multiple sum ranges in a sheet
  497. Setting up an electrical register in Excel with expiry dates
  498. Re: How I convert a numbers to tex --10 to ten
  499. directing cell contents dependent on its value
  500. Directing cell contents to one of two cells dependent on its value
  501. Vlookup
  502. How do I recover a forgotten password?
  503. Countif/SumProduct
  504. Excel IF Formulas
  505. how do I import data in excel form SQL server?
  506. How can I add the values based the color of font and the date
  507. Filldown starting from F2 instead of F1
  508. Changing Source Data using V-lookup
  509. data links on subsequent worksheets
  510. Excel 2003 - deleting Duplicates under conditions
  511. Protecting Sheets with drop down boxes
  512. Adding a value to a customer ID?
  513. Show time as a negative figure
  514. multiple dependent drop down lists
  515. If argument
  516. Contract Value Formula
  517. workday, networkday or something else?
  518. Auto Calculate Keeps Resetting to Manual
  519. 2 worksheets--3 questions
  520. Vlookup and if formula
  521. Ad-In Rowliner
  522. SumIf
  523. Icon sets - conditional formatting - in Excel 2003
  524. Sumproduct with sumif over mutiple worksheets
  525. Multiple section for one answer
  526. Use Vlookup to store formulas?
  527. Vlookup & relative cell reference?
  528. Re: Countif for finding a Time input
  529. RE: Countif for finding a Time input
  530. Days in Text to Dates SPECIAL
  531. Formula referencing a changing range??
  532. Conditional Formatting based on match to external list
  533. General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY
  534. How do i convert dates to text but keep the date format
  535. Help needed with If & Today function
  536. changing formula
  537. If & Vlookup statement
  538. Validation list with formula?
  539. Change the weekends
  540. Rounding
  541. vlook up w- multiple variables
  542. Date Diff - excluding working days
  543. Median with Criteria
  544. using CountIF function or Array?
  545. Conditional IF formula using multi-dimensional arrays
  546. stock control template
  547. Auto-insert same value each Monday in cashflow worksheet?
  548. Adding totals from different columns
  549. Hyperlink won't open in excel
  550. Find and Replace
  551. Pulling/Collating Data
  552. Array Formula Help Needed
  553. Sum amount of days in another coloumn
  554. Urgent help needed - hyperlinks
  555. Vendor List
  556. Help with formula
  557. Conditional formatting with expired dates after current
  558. I want to add formulas from multiple sheets to master form
  559. row height issue
  560. Lose Formatting
  561. Average using Sumproduct
  562. vlookup and match first value greater than
  563. Need to extract specific data from a text column
  564. Combining text from multiple cells
  565. data validation using named range from another file
  566. Counting with 2 criteria
  567. Nested IF(OR(AND) Statement with Two AND Conditions
  568. Can I color a cell with "If" formula
  569. I need to write a PRODUCT formula that mimics a SUMIF
  570. Average For Filtered Cells
  571. Averaging many non-contiguous cells if they are blank
  572. Can I use Sumproduct with the LEFT Function?
  573. visible cell only
  574. Combining Cells
  575. Duplicates formula
  576. Ignore Hidden Rows and Count of distinct values
  577. Re: Counting Array element
  578. sumif - with 2 conditions - rows and columns
  579. Sum VLOOKUP?
  580. formating
  581. Count if if
  582. Invoice: customer database and billing information
  583. If function with calculation
  584. Merge Cells
  585. using if in a range
  586. Consolidate excel 2007
  587. Look for Min and second Min
  588. Look for Max and second Max
  589. Counting frequency in unsorted data
  590. Basic Question on autocomplete function
  591. how to key in a1 information on e1 wil appear at b1
  592. excel formula
  593. Adding dates in columns
  594. Non-contiguous range and Sumproduct to average
  595. Find 2 highest point to form resistance line
  596. Find 2 lowest point to form a trendline
  597. date Concatenation
  598. Extract if 1 shows up
  599. Delete 3 end row
  600. Removing multiple duplicate events
  601. Unprotect problem
  602. Customize accounting format
  603. different colour font in same cel
  604. Countif using cell refences
  605. Summing based on dates
  606. Summing based on dates
  607. Pivot table field list missing
  608. Macro - onAction arguments
  609. List from a Table
  610. Running total based upon current date
  611. separate text and number
  612. Help Creating Excel Formula
  613. Searching based on text
  614. vlookup formula error
  615. How do I set up a formula to give me an average based on IF?
  616. How to set up a conditinal formula w/letters vs numbers?
  617. Average with Conditions
  618. Excel 2007 - AVERAGEIF on rows that are non-continuous
  619. =INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR)
  620. Format cell based on cell color
  621. Return 0 if cell has data, of copy if it doesn't
  622. Time elapsed calculation
  623. sum column based on single cell match?
  624. Help for Medical Records sorting
  625. Counting Merged Cells
  626. Excel
  627. return 0 if cell has data?
  628. #VALUE error-- some cells?
  629. How do I truncate linked text?
  630. IF Formula
  631. Help with function, not sure which one
  632. Using VLookup with 2 Workbooks
  633. Clearing fields when differnt function selected
  634. Help With A Spreadsheet for a silent auction
  635. Format custom number: C-0000-L
  636. How do I stop Excel from automatically resizing my row height?
  637. Return column header based on last value in row
  638. Excel is reading formula as a value
  639. Protecting sheets with drop down boxes
  640. open workbook to specific sheet
  641. Help to resove this problem.
  642. Combine several spreadsheets with multiple worksheets into 1 file
  643. COUNT BLANK AND ZERO AS THE SAME THING
  644. Save As Macro
  645. Help with N/A in formulas
  646. Checking the results of a number of IF formula
  647. Sum with 3 conditions
  648. Include CDF to workbook
  649. Multiple variables to sort and sum, return values<0 with sum refer
  650. Calculation of weighed average
  651. How do I filter cells based on character case in Excel
  652. How do I write an IF function using dates?
  653. sumif..
  654. SUMIF with OFFSET
  655. hyperlink help
  656. Alphabetizing
  657. Conditional Formatting Confusion...
  658. How to count merged cells
  659. SUMIF Function
  660. Match a value to multple criteria both in rows and columns
  661. Excel 2003 formula
  662. How enter time DURATIONS mm:ss (not clock times), then sum?
  663. Summing Data based upon a condition
  664. How to copy & paste a worksheet but change 1 bit of the formula?
  665. Sorting
  666. Making it harder than it is?
  667. complicated drop down menu question
  668. Automatic refresh in linked worksheet if row is added
  669. change multiple links at once
  670. .csv to .txt
  671. Multiple IF statement
  672. Hiding rows and printing
  673. Date chart formula question?!?1
  674. Return of value when copying a formula
  675. to Sohail
  676. how to count#cells w/= value in other column and not count blank c
  677. how to convert amount into text automaticaly in excel
  678. Hostname from IP address
  679. Pivot Table Totals
  680. How do i compare and remove common names from 2 excel work sheets
  681. Depreciation Spreadsheet
  682. Better Workday function.
  683. excel crashes when changing web query
  684. how do I change number format from 3,999.89 to 399989
  685. How do I count # of cells with same value other column?
  686. Formula to Return age
  687. Hyperlink to the meat of a cell
  688. copy data from one sheet to another using a combo box
  689. trouble with closed workbook
  690. How do I write this logical argument?
  691. Function Lookup
  692. Formatting does not follow when copying from one cell to another
  693. Printing problems with hidden rows
  694. RE: Counting text within an Entire Workbook
  695. Excel data disappeared after getting message about compatibility M
  696. Changing coler of tracking cells
  697. conditional formatting?
  698. @Count
  699. RE: Return a quarterly month, based on a cell (3 months from cell date
  700. Why won't text show in SOME cells?
  701. What is the most straightforward (elegant) way to write this formu
  702. Countifs
  703. editing a hyperlink
  704. Summing 2 columns based on variables
  705. IF equation will not calculate
  706. Remove Arrow
  707. speeding up calculation: replacing array formula with databasefunction?
  708. Formula for counting frequency then sorting
  709. Using Worksheet Name
  710. Formatting background colors
  711. How do I sum cells that have values from a text formula?
  712. shared workbook is set up is not 'shared' on network
  713. Sumif weekday
  714. Excel Beginner-need help creating speeding fines system with butto
  715. Need to copy and match data from one workbook to another workbook
  716. Inserting a calculated field in a Pivot Table in Excel 2003
  717. cell selection
  718. H and V lookup or match?
  719. my paste special function won't let me copy formulas
  720. data
  721. Leading zero's trail Number
  722. Sumif across a table
  723. excel 2007 filter 3 text values at the same time from the same co.
  724. Auto fill
  725. How to stop time format changing when I merge cell contents?
  726. summarising_data..!
  727. Creating macro
  728. Explain INDEX MATCH
  729. Calculating Time?
  730. Need to bring back 2 vlookup values
  731. Ending Macro in Last Row within a column of Printable Items
  732. Repeating rows not wanted
  733. Sumproduct error
  734. numbers in a column are not sorting ascending
  735. RE: Sum Indirect
  736. Count Unique text in 3 different columns
  737. Re: Sum Indirect
  738. Sumif for unique values
  739. Help with interpolating values
  740. Formula assistance required
  741. How do I use 'between' 95% and 100% for a nested IF function?
  742. count identical values in 2 rows
  743. How do I find the minimum value in a range while ignoring zeros?
  744. VLOOKUP not working with data from PeopleSoft
  745. Automatic Sumning of Same Cell from Different Sheets
  746. Vlookup formula combining two columns
  747. Trying to calculate # of times text string is displayed
  748. Match Account ID from combining street names and numbers
  749. Date Format
  750. calculate diffence between old salary and new salary