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. Re: Can't insert a new worksheet
  2. Re: Can't insert a new worksheet
  3. Subtracting based on 2 conditions
  4. RETURN VALUE OF ROW 1
  5. Match a UK postcode from a table of postcodes
  6. min if horizontal
  7. How do I get Rid of the Circumflex Accent (Caret)
  8. Upgrade question
  9. Dynamic col_index_num in VLOOKUP?
  10. Re: Need a formula which shows the table..
  11. IF FUNCTION
  12. Average of Subtotals in Pivot Table
  13. Workday Formula to include date
  14. Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous to that
  15. Re: Autofill Formulas
  16. Re: Autofill Formulas
  17. #N/A In Cells
  18. Lookup returning wrong results
  19. SUMIF, 3D FORMULA, EXCEL FORMULA HELP
  20. ADVANCED: Need to sum values in different worksheets based on a rowand column criteria.
  21. Return Min & Cell address
  22. Re: non repeating Random number generation
  23. Intercept and Slope of visible rows, please.
  24. Excel Macros help
  25. Re: How do I update my worksheet? Need Help
  26. Re: Time Zone Conversions
  27. Re: What formula would i need for this??
  28. Different renderings of same pixel heights
  29. Complex search and replace macro based on input variables.
  30. change all below or equal to an input number
  31. Convert Decimal fractions to binary and vice versa
  32. Weighted average till sum of exposure reaches a threshold
  33. Really need some help with a multi conditional SumProduct
  34. Re: difference between two cells
  35. Calculate focal length from FOV on cameras
  36. TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS
  37. Sorting day names chronologically
  38. Re: return a value of specific text within a sentence
  39. Delete rows based on contents of Col A
  40. Check for two sheets. Add or subtract as necessary.
  41. want to track time while paste value in multiple column of same roe
  42. Re: Is multiple IF statements what I'm looking for?
  43. Re: Is multiple IF statements what I'm looking for?
  44. Re: Count multiple specific terms
  45. Augmenting an integer in a column to reflect duplicates in another
  46. Two spreadsheets, filling data from one to the other.
  47. Is it possible to make Excel assume a time happens after another time?
  48. How to add straight line from cell value in pivot table chart.
  49. Re: Cell Auto Lock
  50. Re: Cell Auto Lock
  51. worksheet is not open and copy
  52. Re: Converting formula from Lotus123 to Excel
  53. hidden rows problem
  54. Reference the same cell based on tab name
  55. Conditional Format Cells to Change Color when used in formula of aDIFFERENT CELL
  56. How to enter start and end date/time in excel based on some specific value.
  57. year cant change
  58. Re: Index match formula with multiple conditions
  59. VBA to Filter on variable column
  60. Finding missorted cell in range
  61. Drop Down with dynamic named range offsheet source list
  62. Re: Vlookup an array and report min, max and average as a result
  63. Find Duplicates in a Schedule (Two fields: Time and ApplicantID)
  64. Re: Help with sumproduct
  65. Re: Help with sumproduct
  66. Sum every Nth Row (almost working)
  67. Re: Help
  68. Percentage of month passed formula
  69. Copy corresponding cell in Column B if cell in A contains certain text?
  70. Need to get minimum difference
  71. Making a Sheet copy
  72. Formula than understands midnight?
  73. Finding the weighted average of text that have been given values
  74. Re: Limit drop down items based on another cell
  75. Re: Countif or other formula needed for multiple data/critera results
  76. Autofill alphanumeric prefix in Excel
  77. Re: Countif or other formula needed for multiple data/critera results
  78. Re: Using multiple Lookup Functions
  79. add pass and fails
  80. Transpose Cell Contents
  81. Date / month / year
  82. Searching the formula (not the value) for a text string
  83. Re: Testing the case of text in a cell
  84. Calculate After hours
  85. Conditional Formatting Amendment
  86. Pivot Table with Data Model Connection - getpivotdata reference issue
  87. Formula to answer YES or No
  88. How can i put text in a cell depending on colour
  89. Help With VLOOKUP
  90. Re: Using =SUM...just can't figure this simple thing out...
  91. COUNTIFS ?
  92. Re: how to copy and paste value from one sheet to another
  93. Re: Lookup or search using the * character
  94. Re: List items based on the count given
  95. copying_data_using_FillHandle
  96. time_report_date-wise_employee-wise
  97. Problem formatting dates from CSV file
  98. Hide columns based on row values
  99. Created invoices in Excel - not working in Drive
  100. Pivot Table Data Aggregation
  101. Re: Cells not updated automatically
  102. Re: IF Statement on multiple levels
  103. Re: IF Statement on multiple levels
  104. how to do data validation in excel
  105. VanillaSoft Changes
  106. Re: Excel is too complicated for me
  107. Payment calculation
  108. Re: Match issue
  109. SUMIF Help
  110. Re: VLookup + IF
  111. SUMPRODUCT formula I think w/ wild card & number vs number as text
  112. Subtracting time...again
  113. Re: Adding cells until they are greater than a lookup cell and returning a value
  114. Re: Excel is too complicated for me
  115. Re: Excel is too complicated for me
  116. How to get largest date from a Vlookup
  117. Re: Sumif apllying to all sheets in workbook
  118. Returning 1 of 4 values if conditions are met
  119. Re: Sumif apllying to all sheets in workbook
  120. Function in Excel to count and list number of entries of text valuesin a row.
  121. Excel Average dates help
  122. Expanding Date Formula
  123. Need to convert an array of numbers to two columns in excel
  124. PLS HELP ME TO SOLVE THIS PROBLEM
  125. DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET
  126. need help on either doing a loop and counting specific values orusing subtotal function
  127. work hours with different hour prices
  128. Re: Getting a formula to reflect added columns
  129. using the =page! feature to transpose a row to column
  130. Payout based on hours rate and designation
  131. Simple nested if and statement
  132. Finding location (or start cell) of highest consecutive values
  133. Multiple arguments
  134. IRR of McDonalds expansion plan
  135. Finding NROI - no return on investment and RONI - return on noinvestment in Excel
  136. Wotksheets
  137. SUMIF between 2 dates
  138. SUMIF between date range
  139. Re: State Tax Business Calculations Help
  140. Pasting a range to a single cell
  141. Excel: counting times and dates during non-traditional hours
  142. Re: Formula not working properly
  143. Re: Carry over YTD balance to next worksheet
  144. Merging cells and formats
  145. IF formula
  146. Avoiding auxiliary cells
  147. add hyperlink using sheet names and cells(i,j)
  148. Time Sum in Excel
  149. IF function says too many nested
  150. Formula to multiply numbers intervals
  151. Re: XIRR vs. IRR Function
  152. Syncing between source worksheet and dependent worksheets
  153. How to update data entry to a linked worksheet and then return thenew value back to a master worksheet?
  154. Sort Question
  155. countifs Function not giving desired result with date criteria
  156. Need a ) somewhere in ISERROR formula but don't know where to put it
  157. Depedent Dropdown and INDIRECT($P$8) with a twist
  158. Re: XIRR vs. IRR Function
  159. calculating average handling time
  160. Re: Copy 2 cells to 1 cell
  161. Re: index function
  162. Conditional formatting dates
  163. Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell.
  164. Print on only one page
  165. Conditional Highlight
  166. Adding recognised Zeros
  167. Re: Filtering data
  168. lookup vaules which are not exist in a table
  169. Calculate End Date Using Start Date and No. of Days excluding specific days.
  170. Help with time function
  171. Re: need help with function
  172. Sum Values from different column
  173. Spacing in Column headers
  174. Re: XIRR vs. IRR Function
  175. Re: create pull down menu
  176. search function
  177. Close all without saving and exit without prompts
  178. #REF!
  179. Count columns that meet criterias
  180. can a cell be both input and output?
  181. Re: Help with a formula for a Time Sheet.
  182. Re: How can i find the max value within a time range ased on two cells
  183. Freeze Panes loss
  184. Re: How to refer to a criterie in a cell using excel sum.if function
  185. Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid?
  186. Re: Protected Sheet - Using Groups without a Macro
  187. Re: simple but can't make it, delete blank pages?!?!
  188. Re: Is it Possible?
  189. Re: Is it Possible?
  190. Re: Need formula for calculating time
  191. Re: Is it Possible?
  192. Creating a template that I can reproduce every month by keying ininformation from SAP
  193. I NEED HELP
  194. Re: Merge Name List Within Excel Spreadsheet
  195. Advanced Filter return blank
  196. Re: SUMPRODUCT(SUMIF(INDIRECT...returns #N/A
  197. Nested IF AND OR statement
  198. Change Color of cell
  199. excel time function
  200. I need Time Range to return Value
  201. vlookup or some other function that counts rows
  202. Event recognition.
  203. Drop Downs, Index Match or what?
  204. Restricting Cell entry to certain letters
  205. Sports summary sheet - think I put this in wrong place originally
  206. Sumproduct formula problem
  207. Conditional Formatting from a group
  208. Re: What does this mean'=ROUND(((F8/$C$4)*($C$4-E8)),)'
  209. Re: Data Validation - Custom question (multiple conditions)
  210. Re: Data Validation - Custom question (multiple conditions)
  211. Supress DIV/0
  212. Re: Need countifs forumla to analize in a time range
  213. Re: IF(OR statement not working
  214. Re: Finding Duplicate Rows & Highlighting them
  215. Re: Email?
  216. drop down box code
  217. Re: Finding Duplicate Rows & Highlighting them
  218. Extracting just the time portion
  219. NETWORKDAYS HELP
  220. Re: vlookup not working on calculated time
  221. Re: Month days over a time period
  222. rows height
  223. Count range of cells if not next to each other
  224. Sumproduct not working
  225. Re: converting number to dollar
  226. Re: converting number to dollar
  227. Re: Reconciliation... Again
  228. Excel help separating /
  229. Re: Help calculating scaled commissions please
  230. Re: Formula's to Find/Delete Duplicates from a list
  231. Re: Formula's to Find/Delete Duplicates from a list
  232. Tiered Pricing Formulae - is this possible?
  233. Re: Import multiple photos into excel
  234. Re: Weighted ranking of a series
  235. A find formul looking at two named ranges for two strings
  236. Re: Extracting data/using COUNTIFS
  237. IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows
  238. Determining if a number got hit before another
  239. Multiple Criteria, One Answer
  240. Re: Basic Statistics
  241. Re: IF AND Function Date Range Issues
  242. Re: IF AND Function Date Range Issues
  243. Peculiar default cell format
  244. Re: Need help with average/lookup formula
  245. Re: =substitute
  246. Re: =substitute
  247. Want To Shrink Formula
  248. Avoiding redundant calculations
  249. Trying to find additional ranges outside of min, max, and average
  250. Re: What Multiple functions do I need?
  251. Re: Round Down
  252. MROUND Help
  253. Re: COUNTIFS (the numbers in a column, when subtracted meet a certain criteria)
  254. Re: return multiple values when within range (greater than and less than)
  255. Re: return multiple values when within range (greater than and less than)
  256. Application.OnTime
  257. Re: Vlookup
  258. Re: trouble with (complicated) vlookup searching another workbook
  259. Re: trouble with (complicated) vlookup searching another workbook
  260. Link To File That No Longer Exists
  261. find out specific month and year
  262. Search function
  263. move worksheet to end of another workbook
  264. Match and delete rows on two different sheets from reference numbers
  265. SUM Char
  266. Calculating Average, Count, Min & Max against a range of Values
  267. What is the "--" (double dash) in MS Excel formula?
  268. Re: Excel formula help for calculating freight.
  269. Re: date mismatching
  270. Re: comparing sheet to sheet and adding value
  271. Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geometric Series
  272. Re: Using a Date and corresponding weekday to pull amounts
  273. Re: File upload
  274. Re: File upload
  275. excel copy and paste...
  276. Complex date VBA - insert a certain weekday
  277. Re: Unable to identify appropriate formula for very simple scenario
  278. use month in cell date to sum all relevant cells
  279. Help with a basic condition
  280. Delete rows that contain duplicates
  281. Use & with two formulas
  282. Re: Excel Formula Issue
  283. Re: Excel Formula Issue
  284. Re: Referencing cells in consecutive rows
  285. #DIV error
  286. Re: Userform to update rows of data
  287. Lookup formula of some sort
  288. Re: Progressive number with Excel then print a unique Pdf file
  289. Indirect formula errors if file is closed
  290. Re: Copy text into blank rows
  291. Re: How do I make #DIV/0! error message go away?
  292. hyperlink function fails in excel 2010
  293. Lower-Case Characters
  294. Re: Find Last instance colum A and return corresponding B Value
  295. Re: Simple Macros Table Count
  296. Re: Simple Macros Table Count
  297. Re: Conditional Formatting help (2003)
  298. Mapping strings to integers
  299. adding up time over & under a specified amount
  300. Re: Alternate Row Shading with Filter
  301. Convert multiple series into single series
  302. Re: Vlookup?
  303. Mapping integers to strings
  304. Re: Help With Formula for Posting
  305. Re: Force Distribution/ Force Ranking for Bell Curve
  306. comapering two sheets in excel 2010
  307. Re: 3 IFs argument in one formula
  308. Finding dynamic maxima
  309. Re: Pulling background color from master to other sheet
  310. How to record changing value of a cell
  311. Re: Dragging a formula down isn't working - where am I going wrong?
  312. Unhide column difficulty
  313. Re: Searching for text and returning text
  314. Re: IF Statement Table Help
  315. finding repeating numerical pattern using array functions?
  316. Re: Function or Sub to help with text string
  317. Re: Formula for calculating target hours against actual hours
  318. Re: Formula for calculating target hours against actual hours
  319. Questionnaire using Excel
  320. How do you Combine Two IF formulas
  321. Re: Macro to change referenced column to the next one
  322. if and replace function?
  323. Re: Advanced Drop-down Menu
  324. Re: Varying cell ranges in formulas according to number of cells with certain value
  325. Re: Automatically populate value of cell dependent on adajecent cell
  326. Re: Automatically populate value of cell dependent on adajecent cell
  327. Formula to add two spaces into a number stored as text
  328. Re: Generate series according to range and increment
  329. Re: Dynamic Ranges Adding Extra Row
  330. CONDITIONAL FORMATTING IN EXCEL 2010
  331. Re: Text Dates/times to d:hh:mm:ss
  332. Comparing two lists
  333. Re: Multiple VLOOKUP lookup values
  334. Removing #N/A from an "If/Then" statement
  335. Nameing a function
  336. Re: Converting a number into a cell reference
  337. Re: Converting a number into a cell reference
  338. Pulling From Multiple Sheet
  339. SUMIF with criteria "<>" & "="
  340. using duplicate function
  341. Re: Look up one value and return multiple corresponding values
  342. Re: Problems with conditional average
  343. Re: adding a forumla to cells with formula in them already
  344. Re: Help with an if then scenario
  345. Re: Excel PMT Function Help
  346. Re: Conditional Formatting
  347. Re: Conditional Formatting
  348. Re: Finding a Name
  349. Re: problem with time subtraction
  350. Re: Custom Autonumber with Prefix and Category Grouping
  351. Re: problem with time subtraction
  352. Re: Displaying Returns from another worksheet that change?
  353. weekday last year
  354. Curly Brackets
  355. Re: Counting multiple occcurrences between date range
  356. drag formula down from columns that go acros
  357. calculating volatility
  358. separating date and time
  359. Re: Multiple IF conditions
  360. Re: How do I combine 2 data sets using date?
  361. Re: linest internals
  362. Re: linest internals
  363. Re: linest internals
  364. Excel Formula question
  365. Re: Easter day formula.
  366. Re: Dividing after a long formula
  367. Re: Dividing after a long formula
  368. Re: Lower case date
  369. Re: If then formula with multiple Ifs
  370. Formula to tell day of week
  371. Re: 2 Formulas needed!!! :)
  372. Re: 2 Formulas needed!!! :)
  373. Re: Multiple column scroll
  374. Re: Multiple column scroll
  375. Help needed regarding calculating time
  376. Re: Can I disable the Save As Function?
  377. Sumproduct Help!
  378. Conditional Time Calculation
  379. Re: Sort by placement value from left to right & adding trailingzeros for short
  380. Re: Sort by placement value from left to right & adding trailingzeros for short
  381. Re: LOOKUP trouble
  382. Hlookup 3 criteria??
  383. Formatted cell column in drop down list
  384. Re: need help in creating a formula
  385. Re: CheckBox Control Copy and Paste
  386. Conditional formatting
  387. Macro to open CSV files
  388. SUM Q
  389. Hyperlinks with lookups
  390. Re: Combing a V Lookup result with ("00"&A2)*1 in same formula
  391. Financial Time Value of Money calculations
  392. Re: Needs help combining functions.
  393. Mick & Clause & Experts Please help me on this issue one more time
  394. VBA code for Sum and diff
  395. Gears
  396. Re: Delete Text in Multiple Cells
  397. Re: Count Word in long string
  398. Re: Delete Text in Multiple Cells
  399. Countifs bites again
  400. counting repeats.
  401. Re: Getting sum of values in another sheet while using condition
  402. Re: Help with lots of formulas
  403. INDEX return multiple columns
  404. Sumproduct?
  405. Re: calculate average values for 100 records in the shortest way?
  406. Re: Excel Countif Function - Calculating Between Two Sets of Values
  407. Re: Identifying text in a string
  408. Re: Identifying text in a string
  409. Re: Cell Auto Lock After Entering
  410. Changing Pivot Table Value Field Labels with VBA
  411. Combining an IF with another formula
  412. Calculate elapsed time excluding specific timeframe
  413. Absolute References and worksheets
  414. Re: Using a vlookup to search multiple criteria for one result?
  415. Re: Using a vlookup to search multiple criteria for one result?
  416. Re: Returning a value from a range
  417. Proprietary text on popup buttons
  418. Ms Excel Multiple Logical Test Function
  419. Re: I need a lot of help with MS Excel 2010
  420. Re: Multiple Columns in Sum Range using SUMIFS
  421. Numerals conversion
  422. workbook opens to the same sheet every time not the one it was saved as?
  423. Get percentage of whole
  424. New group but no Star to click...?
  425. Vlookup to reference offset
  426. Re: Problem using IF statement with dates as part of the formula
  427. Re: Problem using IF statement with dates as part of the formula
  428. Ttest across multiple worksheets
  429. Re: Excel help needed: Skipping cell without skipping cell reference
  430. Dragging a formula in a column
  431. Re: Excel 2010 Conditional Formatting
  432. Re: If Function
  433. Excel 2010 If Then logic - with time
  434. Function for summing or counting cells based on a specified fill color
  435. Go To a Named Range (2nd posting)
  436. Auto Change Formulas - Please Help.
  437. Conditional Formatting
  438. Re: help to remove space before the data
  439. Limit to MOD function
  440. Re: Time Calculation
  441. check value in cell
  442. Re: help to remove space before the data
  443. Re: help to remove space before the data
  444. Re: Index/Match Functions to Return Concatenated Response
  445. Re: Help with IF Function for times.
  446. Re: Help with IF Function for times.
  447. using mid find to either extract a number with 2 decimals or excludeFROM A STRING
  448. Excel check value i cell
  449. LINEST multiple known_x's separated arrays
  450. Re: Counting unique instances of a text string
  451. Re: Inequalities Function
  452. Re: Inequalities Function
  453. Can UDF return a customized hyperlink?
  454. Re: Excel Function Help
  455. Re: Why is excel rounding my numbers in VBA?
  456. Re: Why is excel rounding my numbers in VBA?
  457. Re: Divide a # into 3 #'s rounded to a whole #
  458. somewhat complex if statement help PLEASE!!!!
  459. Re: Divide a # into 3 #'s rounded to a whole #
  460. How Do I Avoid #REF! In Formulas?
  461. Re: Define a Range based on Cell Values
  462. Re: text to number graph
  463. Re: Variable interest rate loan calculations- PLEASE HELP!!!
  464. SUMIF "value if false" not working
  465. Data Validation - Complex Q
  466. Re: Looking up other sheet for value X depnding on sheet Y and Z colums
  467. If - Then Fields
  468. vlookup formatting problem
  469. product code a value
  470. Go To a Named Range
  471. lookup two different variables
  472. Re: Show value from one cell in another cell if today falls between a date range
  473. Re: Show value from one cell in another cell if today falls between adate range
  474. Re: Elementary SUMPRODUCT Question
  475. Re: Formula to predict future data
  476. Length cutting optimizer
  477. Calculating weighted average of Percent Change
  478. Re: Autosize Merged Cell
  479. Re: Sum Function has small remainder
  480. Generating a cut list
  481. Re: Auto populate date VBA code
  482. Re: =sum with a filter
  483. Rounding cents
  484. Index Match on Columns and Rows
  485. Re: Sumproduct giving #Value error
  486. Re: Sorting problem. My header rom is getting sorted with the rest.
  487. Re: Concatenate cells with line breaks in them
  488. Re: Year End totals
  489. Re: Rolling 12 month
  490. Re: Recurring Items in Spreadsheets
  491. Copying formulas across columns
  492. Re: Concatenate cells with line breaks in them
  493. Numbers in word
  494. Re: Rolling 12 month
  495. How Do I Find Different Values In A String?
  496. Line chart based on 3 columns
  497. complex sort search and replace macro
  498. Re: sumproduct
  499. Re: Can XIRR Work on Dates That Move Backwards in Time?
  500. Re: Can XIRR Work on Dates That Move Backwards in Time?
  501. Yes or blank, depending if value equals or exceeds value found inVLookup table.
  502. CountIf with And
  503. Re: sumproduct by year
  504. Percentage Increase
  505. Re: Help with a running total on multiple sheets
  506. Re: Vlookup doesn't work: results are wrong
  507. Macro to concatenate with previous bold cell
  508. How can I count deviations between two rows?
  509. multiple SUMIF help/advice
  510. Formula help needed please
  511. Re: Control F
  512. Find partial text and retrun value in corresponding column
  513. Re: Smoothing Data in Columsns in Excel 2012
  514. Copying a cell value to another sheet by using If statement
  515. TIME CALCULATION
  516. Re: Comparing MONTH and YEAR inside Formula ??
  517. Re: IF validation for time totaling
  518. Re: Drop Down List Dependant Formula
  519. Re: YTD SUMIF based on current date
  520. Testing a cell value for a specific weekday.
  521. How to ignore a column of numbers in Grand Total for rows
  522. COMPARING TWO COLUMNS AND DISPLAYING MSGBOX
  523. Re: How to calculate time percentage of number of parts being pick in a timeframe
  524. Copy columns, but not hidden ones
  525. Can I add a range and then divide that sum by a specific value?
  526. VLOOKUP, a table with text and numerics
  527. Re: Lookup in multiple & separate cells
  528. sum character
  529. Re: If value between 2 numbers
  530. Re: If value between 2 numbers
  531. How to reset excel worksheet form lilstbox and combo box
  532. Re: Multiplying a Number Found in an Alphanumeric String
  533. count not-overlapping days in a "Table" with Beginning and EndingsDates Specified
  534. Re: Antilog
  535. Re: excel formulas
  536. 2 dimensional date sort
  537. Calculate total by row number
  538. Re: Match/Index/Sum function with date range
  539. Re: Calendar Logic: Recurring Dates
  540. Learning arrays.
  541. Countifs with different restrictions
  542. Re: Index and match if field contains specific text in it
  543. Re: *Issue* Concatenate dates in a large range of cells in a row.
  544. Re: *Issue* Concatenate dates in a large range of cells in a row.
  545. How do I assign "Apple" to a cell reference in this evaluate code?
  546. Need help writing VBA module
  547. NumberFormat for small non-zero numbers?
  548. NumberFormat instead of an IF
  549. Re: Replace data to right of string problem
  550. Re: Replace data to right of string problem
  551. date & Time
  552. COUNTING THE SAME VALUES IN A SHEET
  553. Protect and Edit Object
  554. sorting noncontiguous data with exceptions
  555. Re: Matching two columns of data
  556. Re: Matching two columns of data
  557. Re: Simplifying multiple IF statements?
  558. Re: return a value depending on two previous values
  559. Vlookup and return sheet name also
  560. Re: Bitwise Functions?
  561. Re: Identifying common data between 2 cells
  562. Re: Multiple VLOOKUP in an IF statement
  563. Re: Evaluate Multiple Cells for any Value
  564. Re: Multiple VLOOKUP in an IF statement
  565. Re: Need help finding a substring in a array of strings.
  566. copying column multiple times
  567. Re: Validation of cell based on Drop down list
  568. Return Column Header from an Index/array, finding Large with a userinput date
  569. Re: Need formulas for searching for a value in a table and returning row/column name
  570. Re: Using IF, AND and OR functions together
  571. Re: Need help calculating probabilities
  572. Re: Month Calculation
  573. Re: Search Text and Add a Blank Line
  574. Re: Month Calculation
  575. Re: Pls Help - blank cell/formula issue
  576. Re: Help. Trying to do the opposite of VLOOKUP
  577. names dates & amounts stated multiple times in document
  578. Re: Help on the Sumif Function
  579. Re: Excel Template required for Daily managing daily income andexpense at Mobile shop
  580. Remove punctuation mark, Split cells & average accross column
  581. Re: Median Formula not working properly
  582. Help Needed : how do i compute this?
  583. Re: Copy values for every nth cell
  584. Re: Date reformatting question
  585. Countif with two criteria
  586. Re: Date reformatting question
  587. Re: Date reformatting question
  588. Re: Vlookup
  589. Re: Copy values for every nth cell
  590. Calculating Future Value
  591. LOOKUP function??
  592. Re: Generate 1 or 0 in xls with input probability
  593. Re: Simple COUNTIF function help
  594. Re: Help Needed! Using complex IF function
  595. Convert Number to Text for Index/Match
  596. Re: Help needed: Minimum value based upon either/or criteria
  597. Re: Help needed: Minimum value based upon either/or criteria
  598. Sort column beginning with blank?
  599. INDEX MATCH SMALL
  600. Re: Name break into half and reverse to upper case
  601. Re: help w indirect and index,match
  602. Re: Please Help! Delete all cells in range except "1934 - 1934"
  603. Re: how to count rows if 2 columns partially match
  604. Extract the 2 Lowest %
  605. Calculating time for 3rd shift
  606. Computer Properties
  607. Club Accounts
  608. Re: Extract Alphabets and Numbers from a Cell
  609. Re: Possible Sumproduct with Or Function
  610. preserving zeros in spreadsheet
  611. Re: coding descriptors
  612. Re: Extract Alphabets and Numbers from a Cell
  613. Re: Lookup Value From Sheet2
  614. range definition by cells numbers
  615. Logical formatting for multiple values
  616. Preserving trailing zeros for a fixed width file
  617. Re: Multiple Criteria Lookup
  618. Re: Conditional Formatting Formula
  619. Re: Conditional Formatting Formula
  620. VLOOKUP return cell location and hyperlink
  621. Re: Formulas won't function
  622. Re: Automatically sort alphabetically ignoring header
  623. Re: need help with Formula
  624. Re: Simple (maybe) percentage forumla
  625. Re: percentage calculation
  626. #value error for sumproduct using RIGHT cmd
  627. Re: percentage calculation
  628. Re: Series command grayed out
  629. Convert number to text as displayed
  630. Extract first and last login time for each day only
  631. Add time when working 3rd shift
  632. Re: help!
  633. Re: Nested If Statement help
  634. Re: Detailed Countdown
  635. Excel 2010,Voice Win7
  636. Re: Counting cells with SUMPRODUCT and conditionals...?
  637. Re: help!
  638. Distribution of capital contribution
  639. Re: VLookup sum multiple matches
  640. Re: Vlookup Returning Zero For Every Cell
  641. Re: Vlookup a subtotal
  642. Re: Display next available number
  643. Re: Vlookup Returning Zero For Every Cell
  644. Show latest date
  645. Re: Search for string based on two columns
  646. Re: Help with complex IF statement
  647. Re: Return a value if a range of cells contain text
  648. Re: Search a range for instances of a text string, return neighboringcell values each ti
  649. Extract Date formula Only
  650. Re: Complex Lookups
  651. Re: Complex Lookups
  652. Re: Problem with formula for finding last greater than/less thanor equal to value
  653. Re: Unable to nest my IF statements properly
  654. Re: Problem with formula for finding last greater than/less than orequal to value
  655. Calculating aggregate donation sums for a list of names
  656. Re: Unable to nest my IF statements properly
  657. Return the value from one range that does not exist in another
  658. Re: Complex Lookups
  659. Re: Using IF and VLOOKUP for range of cells
  660. Re: Using IF and VLOOKUP for range of cells
  661. Re: Using IF and VLOOKUP for range of cells
  662. Re: Using IF and VLOOKUP for range of cells
  663. Re: display Column Header based on cell value in a range
  664. Wage Calculator Q
  665. Re: Calculating days spent to complete a task
  666. Re: Deriving several lists from a master list
  667. Re: Deriving several lists from a master list
  668. Re: Sum of values in column A based on 0/1 of column B
  669. Re: How to calculate difference between two date & time along withworking hours and days
  670. Re: How to calculate difference between two date & time along with working hours and days
  671. Display data for rows where cell consists of whole number
  672. Re: Trying to count based on multiple criteria & cell comparisons
  673. Re: Trying to count based on multiple criteria & cell comparisons
  674. Compare 2 lists and return value
  675. Help! Is this possible
  676. Excel time leading 1st ZERO
  677. Solve for a number (x)
  678. Sorting by frequency
  679. Re: Urgent help with Excel formula. Please please help
  680. Re: Findiing highest and lowest in rows and columns
  681. Re: Findiing highest and lowest in rows and columns
  682. Re: Making data in appear in one worksheet from another
  683. Re: Conditional concatenating!!!
  684. Command Button to create a folder
  685. Re: Joining VLookups with line breaks but ignoring blanks
  686. conditional formatting update issue
  687. Re: Compressing multiple functions across an array into one cell
  688. Re: Multiple Nested If Function
  689. Re: Multiple Nested If Function
  690. Re: Multiple Nested If Function
  691. Re: One lookup option
  692. Re: Function to Combine Names and Middle Initital In Various Formats
  693. putting number against certain words formula
  694. Re: Countif year = help needed
  695. Solver Compiler issue
  696. Re: Conditional Formatting discarding zeros
  697. Re: Sum of Variable Cells in a fixed Row
  698. Re: Sum of Variable Cells in a fixed Row
  699. Re: Help in Median of a quartile
  700. Re: Index Match function for lookup HELP
  701. Re: Index Match function for lookup HELP
  702. Re: How do I convert cubic feet to cubic meters?
  703. Re: VLOOKUP Help
  704. Re: Lookup function to return highest value
  705. Re: Totaling Categories - Monthly and YTD
  706. Re: consolidation data in one row
  707. Re: consolidation data in one row
  708. Re: Excel Template required for Daily managing daily income andexpense at Mobile shop
  709. Re: 12 columns by 8 rows to one row
  710. Array formula lock-up
  711. Re: Use an "OR" around nested IF statements
  712. Re: Use an "OR" around nested IF statements
  713. Re: calulation
  714. Re: Help with count/sumif
  715. Run-time error 1004: Unable to set the left property of the OLEObject class
  716. is there a way to cut and paste text into excel with each paragraphimporting to it's own cell / row?
  717. Conditional Formatting in Excel when data changes
  718. Lookup Across Multiple Rows / Columns
  719. Don't know if it's possible, but...
  720. dynamic data copying between worksheets
  721. COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION
  722. Re: Over time?
  723. Re: Randomize numbers
  724. Re: match some character in b1 to c1 and display on d1
  725. How to Count Strike throughs
  726. Re: Looking up Duplicate values in table
  727. Re: combine three if functions
  728. Informal invite to "Excel Blackbelts"
  729. Re: Help with IF function
  730. Re: Remove numbers from text cells
  731. Re: Remove numbers from text cells
  732. Re: Help with IF function
  733. Help on randomly selecting cells to SUM
  734. Re: Formula Help on Interpolation
  735. FV when compounding occurs every 30 months
  736. Re: Get sum of values in a cell based on unique values in another cell
  737. Re: sumif issues
  738. Re: the specified form cannot be entered because it uses more levelsof nesting
  739. Countif formula perhaps
  740. Re: SUMIF with broken range
  741. Re: If formula producing #VALUE Error
  742. Re: Comparing 2 columns from 2 different Worksheet and Returing Valueof a 3rd column
  743. Re: Match Array returning #NA, Works individually
  744. Re: Returning next item in list
  745. Re: Condtional Formatting or LOOKUP ?
  746. Sumif to multiple tabs
  747. Re: Highlighting duplicates on different sheets
  748. Re: Matching people to skills.
  749. Re: Counting Text
  750. Re: sumproduct