PDA

View Full Version : Excel Worksheet Functions


Pages : 1 |  2 |  3 |  4 |  5 |  6 |  7 |  8 |  9 |  10 |  11 |  12 |  13 |  14 |  15 |  16 |  17 |  18 |  19 |  20 |  21 |  22 |  23 |  24 |  25 |  26 |  27 |  28 |  29 |  30 |  31 |  32 |  33 |  34 |  35 |  36 |  37 |  38 |  [39] 40 |  41 |  42 |  43 |  44 |  45 |  46 |  47 |  48 |  49 |  50 |  51 |  52 |  53 |  54 |  55 |  56 |  57 |  58 |  59 |  60 |  61 |  62 |  63 |  64 |  65 |  66 |  67 |  68 |  69 |  70 |  71 |  72 |  73 |  74 |  75 |  76 |  77 |  78 |  79 |  80 |  81 |  82 |  83 |  84 |  85 |  86 |  87 |  88 |  89 | 

  1. Counting Staffs Reports
  2. Pivot Table Problems
  3. count pieces of records meet conditions in different columns
  4. Can the conditional format box be locked to the cell
  5. Data Lost While Using a Shared Workbook
  6. How do I set up spreadsheet for breakdown costs &quotes
  7. Financial functions in excel
  8. Pivot Table - Create new file with ONLY certain data - Excel 2003
  9. Import data from 1 cell on 1 worksheet to othr cell(s) in another
  10. how do i keep a total down a column , ie. say start with
  11. can no longer insert new columns & unhide hidden columns
  12. Data Validation
  13. Categories & Drop down boxes
  14. how to make value whole (remove decimal point)
  15. How do I delete everything after a / in a column?
  16. Formatting Rows of Data based on Column Data
  17. Formula displays, not value
  18. Excel Conditional Summing
  19. Challenging formatting formula
  20. Lookup help (I think)
  21. How to assign a formula to a letter?
  22. Calculating to add years - including leap year
  23. Excel Problem
  24. How do you multiple, subtract and divide in the Excel program?
  25. Comparing Text
  26. counting x instances of a string across columns...
  27. how do I cross out something in a cell to keep it visible
  28. Excel Formulas
  29. How to count(if) column B IF column A says "x"
  30. Shorten the Excel Sheet
  31. search for data matching some condition
  32. How do I add more than 30 arguments in a formula
  33. Loan Amortization Schedule
  34. Excel Function IF AND
  35. Drag multiple fields into data of pivot table
  36. Excel must display error message if two blocks don't have same num
  37. Pivot Tables
  38. VLOOKUP
  39. why can't i share my workbook
  40. VLOOKUP and OFFSET
  41. How do I replace text within a formula with a diff cell value?
  42. Delete a Column when in a Macro-Worksheet Event?
  43. Cannot Refresh Pivot Tables
  44. sumproduct a whole column
  45. Flipping a Spreadsheet
  46. How do i create a tick box in excel? 2003 version
  47. Create search in excel
  48. cell contents
  49. sum complications
  50. Question Reposted
  51. Subtotaling minus negative numbers and posative numbers
  52. Pivottable columns multiply in excel 2007
  53. how can I add degrees? ie 300degrees + 100 degrees = 40 degrees
  54. How can i make numbers have text format without insering ' at each
  55. Inserting .dwg file in excel opens the drawing in autocad...
  56. How do I make cells subtract?
  57. Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick, tota
  58. FORMULA TO FIGURE AGE
  59. =OR(IF(AND(....),HYPERLINK....
  60. populating a master worksheet with variables in other worksheets
  61. Formatting and Possible Transpose
  62. Counting/Matching
  63. Importing Data
  64. re:again
  65. Excel 2007 Protect Workbook issue
  66. i need help creating a function that will extract words from a string of text
  67. help on averaging function
  68. Excel does not recognize the word Desktop in a countif formula?
  69. vlookup lookup_value
  70. Sumif or sumproduct
  71. Summing not summing
  72. Find a Cell Value In a Range
  73. Linking data across workbooks
  74. Need help please-SUMPRODUCT and Dynamic Range
  75. Summary of multiple sheets
  76. linked formatting
  77. Year Fraction Formula (YEARFRAC)
  78. formulas populating dates - 1st Tuesday
  79. Transpose cell contents from multiple worksheets into rows
  80. Displaying the current system time - 2nd Try
  81. Displaying a time value, conditionally.
  82. IF LEN formula
  83. dates and 1st Tuesday of month
  84. List with total row and protecting
  85. Getting more than one lookup results in array
  86. Chg row color if certain criteria is met
  87. How do I make a cell in Excel "blink" if conditions are met?
  88. Make #N/A blank if no value is returned
  89. Date issue to automate calendar
  90. Advanced filter dates and nulls
  91. vlookup 19:50
  92. advance level of sorting data? by Ting
  93. How do I press TAB and get Excel to move through certain grid ref
  94. how to count without included duplicate records
  95. "list unique" instructions fr xldynamic site doent work
  96. Change :47:57 to 0:47:57
  97. Finding the list of the question I have asked
  98. look up / match / reference cell
  99. compare dates using a variable
  100. Copy range and past on another sheet
  101. an exact number if a number is less than
  102. dynamic range and data validation
  103. How to set the value of a filter field in a Pivot Table?
  104. Conditional Statement
  105. I, too, am having problems with SUMPRODUCT
  106. How to display empty text boxes
  107. Problems with the Right & Find functions
  108. sumif functions based on multiple data
  109. Shortcut for Referencing Tab Data?
  110. Correction to previous post
  111. IF FORMULAS NEEDED
  112. Problem with SUMPRODUCT....help please!
  113. A formula to look for a value in a blok (eg E1:J10) data
  114. last non-blank cell definition for plain excel user...
  115. formula to track timeframe by automatically highlighting cells
  116. How to automate datasheet stuffing?
  117. average in excle
  118. Creating a macro to line up data in 2 worksheets.
  119. Creating a macro to line up data in 2 worksheets.
  120. Creating a macro to line up data in 2 worksheets.
  121. Creating a macro to line up data in 2 worksheets.
  122. Weekly average in pivot
  123. Formula to return position of the next Non-blank cell in a column
  124. DATEDIF() The hidden function - You may find it useful.
  125. Finding Non-Duplicates
  126. Combo Box & Cell Colors
  127. SUMIF Value error
  128. What may cause macro modules to be created by accident?
  129. If then formula
  130. Data Validation
  131. changing text values to a different string
  132. Array functions that I wan to update only on command
  133. CHAR funtcion with double letter columns
  134. Synchronized combo box in excel form
  135. OFFSET
  136. converting date to text
  137. what is reversed conditional formatting?
  138. Int'l R1C1 or R1K1 or L1C1...
  139. 'name of spreadsheet' function... please help
  140. Dynamic List
  141. Break even points
  142. Excel 2007: request for help
  143. =WEEKNUM function
  144. Forms with conditions & mandatory selections
  145. very green at this formula stuff?
  146. My Problem - Help Please
  147. I'm looking to add cells (that are formated in %) in them.
  148. Month Calculation
  149. Date
  150. Referencing between two Excel Workbook Objects
  151. =SUM returns 5.54365E-11 instead of 0 (zero)
  152. Test for outline level of cell
  153. Make it Simple!
  154. Find last cell in column then SUM in cell directly below
  155. Merging Workbooks
  156. Extracting Data back and forth between Sheets
  157. test expression for empty cell in =SUMIF()
  158. SUM(ADDRESS(ROW(C2),COLUMN(C2),1,TRUE):ADDRESS(C14 +1,COLUMN(C2),1,
  159. Procedure to change Column heading from R1C1 to A1?
  160. Currency format
  161. Matching a value, which does not exceed Min or Max.
  162. Excel Database function
  163. Creating a Work place time sheet.
  164. copy cell based on date
  165. how to use MS Excel 5.0 Dialog
  166. How can I compare and filter data in 2 spreadsheets
  167. Next number function
  168. Condition depending on tab colour
  169. Update Formula's based on drop down list value
  170. sum cells based on criteria in first set of cells
  171. Countif
  172. Help - VBA Password Lost
  173. Excel database function
  174. how do I generate lists in worksheets based on a master list works
  175. auto save feature in excel
  176. how to sort a column of Randomly selected numbers?
  177. Excel Newbie...How To Re-Order Data
  178. Can I have a formula with inputs from multiple pages?
  179. Looking for a template or help with a template using sheets.
  180. How many Standard Deviations above and below the mean each number is.
  181. EXCEL Worksheet
  182. Auto-tab
  183. Easy Question
  184. Obi Wan Kenobi: You're My Only...HELP!!!!!!
  185. = or
  186. Conditional Formating in Excel 2007
  187. formulat to convert base 32 to decimal?
  188. Updating a range automatecally
  189. I want to change the column width on a spread sheet?
  190. Custom MsgBox
  191. "customer" msgbox.
  192. Sound File
  193. Drop down or Combo Box Help with VBA code and formula
  194. Formula with color fill?
  195. How do you create a pushbutton lookup control
  196. How do I link a value into a sentence in Excel?
  197. maybe it's simple with macro for this one?
  198. Macro that Fills Sequential numbers
  199. Hyperlinks and Email Addresses in Excel
  200. pasting
  201. Sum many unconnected cells
  202. sumproduct? sumif(sumproduct)?
  203. SUMIF using color
  204. Ranking a moving list
  205. Linking Workbooks using file names in a range
  206. IRR Syntax
  207. plus 1
  208. How can I determine what the compound interest rate is
  209. I Then logic help
  210. Repeat title to top of each worksheet
  211. My column cell values are -ve how do I make all cell value +ve,
  212. MROUND formula problem, help please!
  213. Sumproduct - sort of
  214. Filter Totals in a Pivot table?
  215. How do I change the font to all caps for the entire worksheet?
  216. Double lines
  217. Excel 2007 - table style default
  218. Right-to-Left direction
  219. offset and Sum function
  220. IF Function & Nework Days
  221. Excel 2003 - setting the Comment font size default
  222. copying cells
  223. Networkdays function
  224. Vlookup
  225. creating pivot from a horizontal table
  226. make one cell identical to another
  227. Typing problem
  228. read the values from a excel row
  229. IF functions
  230. selecting a row
  231. Stripping text from numbers in a cell
  232. Formula
  233. Status Bar box problem
  234. Text to Number
  235. again here's my another problem
  236. Cosmetics Capitals
  237. Formulas in subtotal worksheets?
  238. automatically format cell based on content of another cell
  239. Spell Check function on a protected sheet
  240. Linking a single number or text to a cell
  241. Worksheet Protection / Security from Viewing
  242. How to resize Data, form with current wksht information
  243. Using a dynamic pathname in VLOOKUP
  244. row lookup formula
  245. find and replace units of a formula
  246. Return the value in the last cell of the list
  247. DBSUM function but with function as criterion, not a range
  248. Combining one row into two
  249. Interactive Text message
  250. Getting a response other than true/false with an IF formula
  251. Offset every # of Rows
  252. formula for Canadian postal codes
  253. Blank and 0's in Cells
  254. How do i display a negative time as a res of distracting 2 times?
  255. Help with excel array - select, add and calculate result
  256. Help with Excel array functions - select, add & return result
  257. Turn around Time
  258. How i display True/Fale in one or two colum
  259. If - then help.
  260. simple, counting the last character in text
  261. formula to find all possible combinations
  262. shared advice appreciated
  263. shared advice appreciated
  264. named range with criteria.
  265. Excel Solver constraints
  266. Converting embedded objects in excel versus word
  267. copy selected tabs from multiple workbooks to a new workbook
  268. How do I get two rows of print in one cell?
  269. Nested IF Functions with OFFSET
  270. RANDBETWEEN in a conditional format gives error
  271. display a number in another cell
  272. allowed/taken
  273. Inventory Control
  274. Countif with Dynamic date ranges.
  275. Making two lines into one
  276. Display scenario name
  277. MY FORMULA WON'T WORK.. WHY??
  278. Modified:-> Macro to Generate a new Column!!!
  279. pmt function
  280. Indirect Use of XLM in Excel 2000 and Prior
  281. Excel 2007 sheet and workbook protection
  282. Interrupting Calculation Iterations
  283. Inserting Buttons as Hyperlinks
  284. JIS / ASC Functions in Excel 2007
  285. vlookup
  286. excel: count uppercase letters in a cell
  287. Is there a way?
  288. Thank You!
  289. Macro that Finds the First Value in a range using a Combobox (drop down menu)
  290. Conditional Format Formula Issue
  291. #N/A ErrorVLOOKUP HELP
  292. HOW TO DELETE ALL BLANK NONADJACENT ROWS IN LARGE LIST?
  293. Formula not working
  294. Annualize/ Estimate year-to-date from monthly expense
  295. PROPER FUNCTION
  296. delete macros
  297. Macro do works in excel...
  298. VLookup to join three + worksheets?
  299. Forumla works in all cells but 1
  300. NZ function equivalent in Excel
  301. Greater than but less than formula
  302. Dates formula problem
  303. How can I get 1 landscape Excel page # consistent with portraits?
  304. Spss verse excel
  305. Comparing two names
  306. 17 random numbers between 1 to 65
  307. allowed / taken
  308. How do I show web addresses in Excel, rather than their name
  309. Extract Middle Initial from Name
  310. repeat row button
  311. If, vlookup, data validation & dependent list
  312. sorting excel data
  313. Extending Logic beyond the numbers and into a Name! Is it Possible
  314. Conditional Formatting
  315. Average with multiple conditions
  316. Worksheet
  317. Trial Has Expired and I can't open spreadsheet created in trial -
  318. Formula / Counting
  319. Formula Suggestion Please?
  320. range, cell refrence, but with a new twist
  321. How do I maintain cell formatting when I export to a mail merge?
  322. How do I insert cells in a macro?
  323. How do I link text from mulitple cells to another spreadsheet
  324. Formula that compares data in adjoining cells
  325. Count IF/Sum IF
  326. How do I enter the same data no multiple cells with current data?
  327. Calculate value in a text filled cell
  328. VLOOKUP insert rows
  329. Sheet Name Changes how do i code for that
  330. How do prevent your column widths from changing in Excel?
  331. Need to parse column data only when text is present
  332. Frequency.... I think
  333. calculation in pivot table with value of a column
  334. 2 Part Formula
  335. Need help with =IF formula
  336. Editing Comments
  337. how do i change a formula to its value
  338. Combining data ranges
  339. Can I turn off the auto-select in Functions?
  340. Need a formula to look up 2 values and return result from 3rd colu
  341. When copying dates, they change by 4 yrs & 1 day, why?
  342. How to set-up data validation between sheets?
  343. Conditional Formula w/Date=Where did I go wrong?
  344. change fill color in 2 cells when data entered in one
  345. Long formula
  346. Pivot Tables and VLOOKUP
  347. sumproduct spanish version
  348. randbetween(1.1,1.25)
  349. How do I set up a simple checking book worksheet
  350. #N/A value is returned
  351. vlookup glitch
  352. paste special / skip empty cells doesn't work!?
  353. Import data from a website to excel
  354. Edit numerous cell entries
  355. Identify New Added Rows
  356. I need a formula to calculate rates based on current age
  357. VLOOKUP Question...
  358. Formula finding last cell in row containing data
  359. Modified:-> Macro to Generate a new Column!!!
  360. how get many days in March repeate in column have many dates
  361. Moving values from one colum to another when there is spaces betwe
  362. Rank
  363. How to repeat the same cells under each row
  364. Dependant Data Validation - for Whole Column
  365. Macro to generate a new column denpending upon existing one!
  366. finding exact matches
  367. Convert Function
  368. Worksheet disappear when saving on shared workbook
  369. pivot tables for likert-scale type survey items
  370. Using a single cell refernce to change multiple formulas
  371. Return Value of last cell in column with a value in Excel?
  372. Problem with getting numbers in some range values!?
  373. Leading "0"
  374. Vlookup value of #NA
  375. Is it possible to Link a Label control to a cell ?
  376. Alter Text in 900 cell entries
  377. how do I get word art from 2000 into 2007
  378. How do I track and save changes within an excel spreadsheet among.
  379. any macro
  380. Formula Disappears, converts to a value
  381. Negative Numbers in a Pivot Table
  382. any formula
  383. Subject: return a result from multiple conditions.
  384. How do I reference an empty cell in a formula?
  385. SUMPRODUCT troubles
  386. return a result from multiple conditions.
  387. how do i make a packing slip with a drop down menu
  388. how do i make a packing slip with a drop down menu
  389. Pivot table aging report sort order
  390. duplicate formula cells
  391. How do I print certain (specifics) columns in Excel spread sheet?
  392. combining sheets from different files into one file?
  393. Export Explorer Metadata to Excel
  394. Make each tab/worksheet into a separate document
  395. Formatting a number
  396. Clear Contents Of Cell If Value = 0 or Error
  397. Please Help...
  398. Sorting the spreadsheet!
  399. DSUM criteria
  400. automatically update macro
  401. Formula or Method for Deleting Duplicate Entries?
  402. Dynamically Megre/Unmerge Cells
  403. Sum.if criteria related to range of cells
  404. HOW TO CONVERT TIME FORMAT IN HOURS TO MINUTES
  405. Conditional Rounding Part deux
  406. Extract first second "word" from a Cell..
  407. Extract first to "works" from a Cell.
  408. know the excel
  409. Excel / Access User Conference - Oct 24-26, St Loiuis
  410. finding and summing data in somewhat complex matrix.
  411. Can you convert this formula to 2003 from 2007?
  412. Prohibit manual entry via Drop Down
  413. deleting the blank rows from the sheet
  414. Similar to paste special from another workbook
  415. Rounding up for a decimal
  416. Excel Formulas
  417. Referencing a different tab according to a formula result
  418. how do i get borders around selected cells in a worksheet?
  419. Excel file size too large
  420. How can I handle negative time values?
  421. Protect Workbook
  422. Pivot Table - How to keep data hidden
  423. Paying fee to someone who could extract data from web-page to excel!
  424. Federal tax withholding calculations - using IF statements..?
  425. remove hyphens from a list of part numbers
  426. Formula
  427. IF 5 years old by Dec 1 they will start Kindergarten
  428. Slightly OT (Maybe) printing problem
  429. sumif between dates (quarters)
  430. Worksheet function match - run time error
  431. Vlookup
  432. Get list of row #s with certain value
  433. Update reference in multiple formulas
  434. Conditional Formatting for Duplicates
  435. range,cell refrence
  436. coefficients of trend line
  437. Does excel have text effects?
  438. invisible color
  439. IF function results not displayed in cell
  440. PivotTable question about grouping numbers in it
  441. Excel 2007 question?
  442. Formula HELP
  443. Maximum Columns in Worksheet
  444. How to calculate bond value and current yield
  445. How to use goal seek
  446. conditional formating
  447. Vlookup problem in lookup range
  448. formulation setup() from 2003 good for 2007
  449. personal.xls
  450. Array Formula and 2 Tabs!
  451. Formula to subtract a $ value based on specific date
  452. how to return a result from 2 conditions?
  453. Recalculating in a circular reference
  454. supply order form
  455. Negative Column ????
  456. Relative Cell References When Linking
  457. Auto continue onto the next page.
  458. Get highest value and adjacent cell value
  459. Return Cell Address of MIN value - array formula
  460. conditional formula in Excel
  461. I'm still confused
  462. group_sheets print setup()
  463. How to set up variable data ranges in nested functions
  464. Excel Formula
  465. Deleting a consistant portion of all cells in a given column
  466. How can I combine data from two sheets where field contents match?
  467. Cell Reference
  468. Ticks!
  469. Adding blank rows between groups of similar names
  470. Formula Cannot Be Converted - Function Not Available
  471. referencing a different tab by referencing a list in the current s
  472. is there a formula to count something like this....
  473. How can i randomly select 780 rows from 4000 rows of data
  474. Assigning numerical value
  475. Autofill macro formulas
  476. copy graph from a Worksheet based on a field in another Worksheet
  477. Reference Previous Worksheet Built-in Function
  478. 'COUNTIF' and 'AND"
  479. Excel work Book Order
  480. Need to find highs and lows formula and how-to
  481. Dynamic Formulas
  482. language problem
  483. Automatic value is malfunctioning
  484. Excel function
  485. CREATE DATA FORM FOR DEPENDANT DROPDOWN LIST IN EXCEL
  486. Help to rename files
  487. Re: please help with formula for same cells in different sheets
  488. Adding percentages
  489. seperate field
  490. spreadsheets
  491. Add one more criteria
  492. cannot remove read-only from a file
  493. Is there a formula to capture data between "Tabs" on a spreadsheet
  494. Match and Lookup
  495. Make tick appear
  496. vlookup formulas
  497. Printing Troubles
  498. count if on Visible - Filtered
  499. MAX returns correct column, but row -1?
  500. Linking between workbooks in Engagement
  501. averages without zero
  502. CONCATENATES
  503. Change time format from :0 to 0:0
  504. Help avoiding a circular reference
  505. Sumproduct with OR
  506. Calculating productivity: widgets per hour
  507. EXCEL CLOSES
  508. Organizing data to sort in a spreadsheet.
  509. IF function to return values for cells with blank or - in them
  510. Quiero usar la funcion buscarh buscando un valor distinto de 0
  511. Create a credit (negative) column in Excel?
  512. Saving file using value in cell as the filename
  513. Average with #div
  514. Links & functions
  515. How can excel 2000 users open a 2007 .xlsm workbook
  516. Combining Worksheets
  517. I need to sum the last column - is there a formula for this
  518. how to identify unique list of 200 random entries from a list of 3
  519. Largest value in Col B for each unique value in col A
  520. Keep Same Cell Reference
  521. vlookup not working with defined name
  522. Does a number exist in a range
  523. create new paper size
  524. Clear Contents Of Cells Where Value = 0
  525. Is there a way to require a cell to be completed in Excel?
  526. Reference a Worksheet Tab in Formula
  527. Is it a formula or input data?
  528. How to insert a space between display results
  529. function add ins for english language
  530. Page Break Column Headers
  531. how to sum or count values with "<" symbol in excel?
  532. find matching text
  533. Need a way to determine the # of Saturdays in a month
  534. Reformat spreadsheet
  535. How to convert a static formula to dynamic formula ?
  536. Excel 2000, RAND and IF functions do not work together for me
  537. Conditional Formatting
  538. Find lowest 3 values and sum
  539. Insert Row "Missing" from my list
  540. How can I calculate a due interest of annuities for a certain peri
  541. A Formula for tracking Data on It's own tab in my spreadsheet?
  542. ASAP Utilities Problems
  543. Maybe a macro or whatever can do this easily...
  544. Need Help Organizing a Formula?
  545. Vlookup Returning #n/a
  546. Sumif banding on a condition
  547. Multiplying non consecutive rows, then adding it.
  548. conditional formula
  549. Finding highest values
  550. How to extract right-most word?
  551. Transferring cell contents from selected rows only.
  552. Too many nested IF functions!
  553. Inserting a range of cells
  554. Help to Tame the "formula" beast, PLEASE?
  555. automatic copy of results to another page
  556. Linking a selection in a drop down list to a calc in another cell
  557. Sorting
  558. Searching two columns against a specific criteria
  559. Scoring three groups, each with 6 levels
  560. time
  561. COUNTIF....
  562. Converting hours over 24 into decimal format
  563. ="my text" &TODAY()
  564. SUMIF ?! .... not quite enough....
  565. Hide / UnHide - is there a Function to automate this ?
  566. User time input
  567. convert row to columns for multiple rows
  568. Gray Out Expired Records
  569. How to fill a blank cell down to a filled cell
  570. Finding tops and bottoms using stock data
  571. If & Array
  572. min, dmin, etc
  573. Find/Replace External Data Web Query
  574. How do I create a first page index of worksheets in my workbook?
  575. Vlookup derived wrong value
  576. excel 2003: how to match records of 2 tables according to 2 columns?
  577. Merge Mail Wizard Changes
  578. Help with Formula
  579. Return Text or Blank
  580. Working with Time
  581. How to lock Excel files so that others can copy it & not chg it.
  582. Workbooks.Open Filename
  583. creating numbers to a fixed length string...
  584. IF, OR, AND FUNCTION HELP
  585. Adding in a piece of logic to my complicated formula!
  586. how do i change (or add) colour to the worksheet tabs (in excel)
  587. Sumproduct to find monthly bonuses
  588. read data from a cell absolutely
  589. how to encirle a word
  590. hiding huge formula's in an excel sheet
  591. Formula to return blank
  592. How to make the First alphabets in the cell to be blank.
  593. Searching two columns for information
  594. Excel Yes / No, True / False etc. cell selection buttons?
  595. Using IF to find text + wildcard?
  596. Huge sum function formula
  597. countif multiple conditions
  598. autopopulate multiple users personal info
  599. reference answer
  600. EXCEL MAXIMUM VALUE AND VLOOKUP NESTED?
  601. Quick solver question
  602. LINKING MAIN SHEET WITH MULTIPLE SUMMARY SHEETS
  603. Excel to form email in outlook
  604. sumproduct last 30 rows
  605. MegaStat Add-In
  606. Summation question
  607. Index to define a range
  608. Excel, how to copy conditional formats in sequential order 1,2,3
  609. How do I?
  610. Macro for a Pop-Up Box help....
  611. VLOOKUP variable range cell reference
  612. reorganize string
  613. Capturing a word sequence as part of a text in a spreadsheet cell
  614. Using Index & Match functions to find data on separate worksheet.
  615. Using Named Ranges with Charts: Part 2 (!)
  616. Difficulty displaying text
  617. Date format in a text string
  618. Addition help to edit a formula
  619. How i can set two different rows as header and footer
  620. Use of the Contents of a cell as a worksheet name in a function
  621. Help with editing a formula
  622. Utilizing a Cell even with a Formula located inside it
  623. Consolidating with empty-string ("") cells removed
  624. Autofill columns
  625. Making a Formula Contingent on Check Boxes
  626. What does the $ mean in "=B$6" for example
  627. Data validation dependencies
  628. My formula is =Sum(E38). How can I add text to the formula?
  629. Need formula
  630. Adding bytes, gigabytes, and megabytes in Excel
  631. How do I extrapolate from a given set of data?
  632. Sum the first x cells in a range
  633. Goal Seek Algebra Formula
  634. How do I set a value greater or less than
  635. qn on counting in drop down menus and protecting/hiding specific worksheets
  636. SUMPRODUCT formula messed up
  637. sumproduct formula
  638. Rename Sheet using Cell Reference
  639. concatenate link
  640. how to insert a special character (arrow) in IF statement
  641. Counting for unique values using 2 cells
  642. Bring Forward Balances and Formulas in a Spreadsheet
  643. URGENT: Using Named Ranges with Chart Wizard
  644. Auto Fill days of the month (not including weekends)
  645. Merging cells with no-adjacent data
  646. Is there a better formula than this Q
  647. Updatable Spreadsheet
  648. Split text to multiple cells
  649. sumproduct and if statement
  650. static date
  651. Showing Cummulative Top5 results with an array-formula...?
  652. Counting numbers greater or less than a number
  653. One more try!!
  654. Function returns a list
  655. If Max or Ron can answer this they are Gods!
  656. How to
  657. How do I get my rows and colums to show up when printing??
  658. data validation with a formula
  659. SPREADSHEET
  660. can i add colours cells only in excell
  661. Index & multiple sheets in one workbook
  662. Insert a progressive invoice number
  663. need help please inserting multiple rows based on cell value then copying to data sheet
  664. Calculating the sum if two criteria are met?
  665. Inserting a Row
  666. MISSING import external data from Excel to Excel
  667. Ignore Blank in Validation not working
  668. Index function - problem copying to other cells
  669. Average of only cells containing numeral value
  670. How to solve Error 2023 for Excel?
  671. Can excel export to an organizational chart?
  672. Problem with IF statement
  673. I want result of a function in the cell and not the function itsel
  674. Array Formulas with multiple criteria in the same row?
  675. Can I use an array formula with multiple criteria in the same row?
  676. Multiple Lookups - SIngle Result
  677. Referring to Sheet locations in a formula
  678. Returning a column name or number
  679. change background color of a cell with an "IF" command?
  680. Challenging Formula. Need help with writing a formula
  681. Excel Function
  682. How do I calculate a persn's age in years & months in Excel?
  683. Monter IF statement??? sorry long question
  684. Code simplification
  685. Eat Cookies and Loss Weight. See How
  686. Does loop function cause this problem?
  687. Showing Top 30 with array-formula?
  688. IF
  689. Prevent cut and paste over a range
  690. Show Top 10 with array formula
  691. Bizarre Excel 03 Problem - autosum not updating when cells are cha
  692. Is conditional formatting or formula possible by cell color?
  693. List Sorted/Split into groups
  694. convert columns to rows
  695. Check plan versus complete
  696. HELP--- adding duration of times
  697. Is there a way to sort a list of multi-line items?
  698. Advanced Sumif formula
  699. combination of AutoFilter and array formula?
  700. #VALUE message in cell
  701. Excel Formula add if someone types PTO have it =0
  702. How do I insert cells in a macro?
  703. Creating a series of cells with multiple incrimenting characters
  704. Rounding a sum to the quarter hour.
  705. Form drop down list
  706. Sequential VLookups
  707. Qual a melhor função logica a ser usada?
  708. ISBLANK()
  709. any ideas appreciated
  710. How do I use an If= statement with an apostrophe (IF(s4="jack's",.
  711. Offset Graph reference problem
  712. Conditional Formatting in Pivot Table
  713. why do i get #value! using this formula
  714. Show True if numbers match
  715. Dollar / Euro sign
  716. Any way of flagging blank cells?
  717. Please help me win my fantasy football league by answering this excel ?
  718. Autosave Locatio 2003 Excel
  719. calculating sample sizes for independent groups
  720. I want the result of formula resyricted upto 2 decimals
  721. Another SUMPRODUCT Query
  722. How to use Check Box input in a cell's fomula?
  723. how do i clean out all non-letter characters from an excel sheet
  724. Can IF do this?
  725. Format
  726. Time formatting
  727. formula to count easily
  728. List of Excel 2003 Functions
  729. Check if Conditional Format is True or False / Check cell Color
  730. Highlight if ...
  731. Eliminating invalid information
  732. On Excel, the auto filter feature is not filtering all the data
  733. what formula do I use for conditional formatting?
  734. How use info in Excel shared worksheets to create new worksheets
  735. Choice of Formula
  736. how do I set up a formula showing the day based on date?
  737. Excel 2007
  738. counting values in rows
  739. sum if question
  740. Formula conundrum calculating a percentage average...help!
  741. sumif or countif not sure
  742. Mulitple Formulas/Same Cell
  743. Searching within an excel document
  744. VLOOKUP JUST RETURNS THE TEXT OF THE COMMAND
  745. To return the column number of a string
  746. To return the column number of a string
  747. To return the column number of a string
  748. Allocation
  749. Bad result
  750. Convert rows to columns
  751. Conditional Formatting part 2
  752. Adding symbols to text cells
  753. Conditional Formatting
  754. Insert value from another cell AND text
  755. Match
  756. Formatting Dates
  757. How do I create a Form with check boxes in Excel
  758. How to ignore #DIV/0! in Sumproduct formula
  759. VLookup confusing
  760. Excel Conditional Formatting -- more than 4 conditions by row
  761. Conditional sum
  762. I need you Mike H!
  763. VLOOKUP help from yesterday's post
  764. wanted to use if function by comparing date
  765. Hiding formula to calculate % visits met
  766. When I change the font size in a cell the value changes.
  767. is anyone familiar with the pull formula in excel?
  768. Forming a trend line
  769. Linefeed Character
  770. How do I search for keywords in cells containing text?
  771. problem in deleting the named ranges
  772. Cancel calculation
  773. SUMPRODUCT problem
  774. Excel Convert Multiple Rows into Multiple Columns
  775. Generate list from column
  776. Grouping Date Data in a Pivot Table
  777. Getting text data from a pivot table
  778. How to match and compare two spreadsheets
  779. Excel 2003 Time Calculation
  780. Returning multiple indices for a lookup
  781. Sorting into Groups equal size
  782. Macro for Conditionally Formatting Comments
  783. Conditional Formatting for Comments
  784. Sorting Macro in Excel 2007
  785. Round Function Philosophy
  786. "countif" and "and" condition
  787. Scroll bar (control) doesn't scroll!! ???
  788. how to display mainframe negative numbers on excel
  789. Help with COMPARE??? IF??? VLOOKUP??? Don't know which to use
  790. Need Help Using Calculated Field or Item in Pivot Table
  791. calculate various cells to acheive a specific value
  792. IF - AND Function
  793. Batch Printing - filtered by Picklist
  794. Inserting Additional Text in Spreadsheet
  795. mirroring worksheets
  796. Alert user that row has been modified by changing row color
  797. How do you create roll-up rows in EXCEL?
  798. Advanced filter I think
  799. Re:Getting a cell reference when a value is less than 0 in Excel Works
  800. Indirect function
  801. Date and Time Formatting
  802. Find where else in a spreadsheet a cell is referenced with formula
  803. Name Embedded Chart
  804. Linking and displaying
  805. Web Site Lookup
  806. OLAP and number formatting
  807. Compare 2 data set
  808. How can I open an Excel Doc from the AutoSave option?
  809. Trying to merge from excel to word. New names won't merge
  810. Calculating Conditional Standard Deviation?
  811. getting the next date based on another date
  812. How to find the first non-blank number in a row?
  813. Counting instances of text???
  814. Microsoft Excel Sheet
  815. Check Box & Counter
  816. Run Time Error 1004
  817. Two Separate Conditions for Cond. formatting
  818. Dragging a formula containing external links
  819. Repeat Sort in Excel 2007
  820. If statement to replace #VALUE! code
  821. Excel Fromula showing as text but not value
  822. Checking and IF ?
  823. Can the worksheets in a work book be sorted ascending?
  824. Multiple a column of costs by a single factor
  825. Function to Identify the Modification of a Worksheet
  826. would like to substitute and return value of 0 for vlookup #N/A er
  827. Insert text in a formula
  828. Automatic sorting
  829. Average across cells with formulas
  830. Getting a cell reference when a value is less than 0
  831. Two conditions in a SUMIF function
  832. Count on Multiple Criteria over whole column
  833. COUNTIF cell reference won't work
  834. show 0.00 if referenced cell is empty
  835. Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet
  836. Grouping Date Data in a Pivot Table
  837. Automatically go to a certain cell
  838. summation
  839. vlookup for the second value of a list
  840. WorkSheet reference
  841. muliple sheet range + sumif / sumproduct
  842. Custom Section Numbering
  843. formula help - maybe vlookup, not sure
  844. Multiple passwords
  845. What Excel formula caluclates number of months between two dates?
  846. HOW TO USE BAHTTEXT FUNCTION?
  847. alternating colors
  848. Index or Match or what?
  849. Find and Add a number in a text field
  850. Auto Sum not working
  851. Date of last refresh?
  852. How to count the occurences in my range with 2 characters only?
  853. Formula to identify character formatting (bold, italic, etc)
  854. How to combine a symbol and a formula
  855. Limitations to 2 variable data tables?
  856. Find & Replace (DOH of the week)
  857. Combo box displays positions not date
  858. Formula - IF...then?
  859. Looking for a function
  860. Complex timesheets
  861. how to change number to text with specific format in function
  862. Find Duplicates and Move to New Worksheet
  863. 2 woorksheets 1 workbook, help with lookup
  864. if then formula
  865. if then forumla
  866. Automating a line item for several worksheets?
  867. multiple ranges & criteria for SUM-IF challenge
  868. if >200 and <300 formula
  869. Excel formulas
  870. file.xls is locked for editing by "user"
  871. sum if formula help requested
  872. How do I put "COPY" on a worksheet when printing
  873. I want to select a row and insert a copy later in the worksheet
  874. Unknown Sheets
  875. Function to incorporate worksheets that have yet to be created?
  876. Error message - PivotTable will not fit on sheet. Show as much as
  877. ifcount to compare two columns?
  878. multiple conditions with IF function.
  879. linked info
  880. Macro Request: Fill in empty cells with previous Filled cell in column
  881. Saving a Workbook where the worksheets are protected
  882. Copy formulas not working
  883. How do you lock a cell after making a selection from a dropdown b
  884. IF function not working in conditional formatting
  885. Unlocking a Shared Workbook
  886. difference between logical AND and multiplication?
  887. Excel / Access User Conference - Oct 24-26, St Loiuis
  888. Formula Help Please
  889. Pasting across worksheets
  890. Excel date format, NOT JUST DISPLAY !!
  891. sumifs in excel 2003
  892. password protecting a column for data entry in a sheet, how?
  893. How do I include part of a cell in text (string?) in another cell?
  894. macro sheet name conflicts
  895. Help with Dates in a Formula
  896. "Paste" overwrites Verification Controls
  897. COUNTIF
  898. top3 selection
  899. Top 3
  900. not to use again
  901. auto selection
  902. Re: Creating a formula that references the last value of a column
  903. Excel 2003 function for counting rows with two conditions.
  904. Creating a formula that references the last value of a column
  905. MS Excel
  906. Changing worksheet direction
  907. formula help
  908. Diabetic Recipes and More...
  909. How do I delete an instruction box?
  910. zero out
  911. frequency
  912. calculating # of days
  913. Splitting into Groups
  914. Excel- option button
  915. Windows Explorer
  916. Trying to convert hh.mm.ss in General format to minutes
  917. Omitting zeroes when looking for minimum values
  918. Moving many named cells at once to the next column
  919. Need to fix macro to list data underneath each other
  920. Financial calculation
  921. What does $ stand for in an excel formula
  922. Automatic Summary Sheet
  923. automatic summary page
  924. Add-ins, insert stock quotes
  925. Need a formula to sum no of times item no is used and sum up total quantity!
  926. Why do I get #NUM! for a GEOMEAN calc on a set of positive vals
  927. How do I delete the name for a named range i no longer require?
  928. How do I use Named Ranges as Data Validation Lists?
  929. How to change amount in figure to amount in words?
  930. Cell displays formula instead of the formula's result
  931. Can I get Excel to call my macro for number formatting?
  932. Excel 2007 backwards compatibility - nesting functions
  933. How do I count items based upon two separate values?
  934. sumif
  935. how to create macro to use cell references for data filter criteri
  936. How do I find top 3 in an unsorted list?
  937. Pivot table dynamic Filter
  938. conditional indirect with data range
  939. IF / SUMPRODUCT HELP
  940. Insert a column within a range of cells
  941. copy from Excel 97 output put in Excel 2000, colors don't work
  942. Formula not returning value
  943. Ending a Sheet
  944. VBE Help, when linked value change, color will not
  945. Exporting Quickbooks 2007 to Excel 2007
  946. Sum Amount if two conditions are met
  947. How do I create a detailed Timesheet?
  948. Calc order in pivot table with COUNT
  949. Converting to mailing labels
  950. Changes cell function to answer
  951. Automatic Fill of a Formula
  952. Run time error 91
  953. Problem with calculating hours in timesheet? (sysgulv)
  954. Sorting and Hidden Rows
  955. Converting Total Time hh.hh to HH:MM:SS
  956. Only weekdays (sysgulv)
  957. How do you display IF statement results in a different cell
  958. Copying a forumula to many cells -but keeping one element static
  959. how to compare two columns on two sheets and copy associated data from one sheet to the other?
  960. How do you display IF statement results in a different cell
  961. Can I copy Groups from one spreadsheet to another?
  962. now function
  963. How to Calculate no. of hours in a stipulated time?
  964. ¤j³°ª±Lineݯ¤k
  965. How do I send multi-sheet documents from Excel via Outlook?
  966. SUM by unique reference
  967. Can you add conditional formatting to columns that are linked?
  968. sumif function
  969. changing print borders
  970. Jogging Log and Elapsed time formats
  971. Transfer CELL value and spread it among 24 ROWs on another sheet
  972. @average function
  973. Sum of a column excluding hidden rows
  974. data filter criteria based on cell references?
  975. If logical value problems
  976. Lookup function from a different sheet!
  977. GREEN MARK IN THE TOP LEFT CORNER OF THE CELL
  978. Help with using functions....
  979. Smart Tags - Removed - How can I get them back????
  980. Link to text and return text into a formula?
  981. password cracker for spreadsheet
  982. Calculating Time from Speed and Distance?
  983. Pivot Table Calculations
  984. How do I compare two cells and display the lesser of the two cell.
  985. how do I mail merge data from excel to word as formated?
  986. Combining multiple files in Excel
  987. conditional formatting problem
  988. VBE Expert Help, Code linked to Cells
  989. Forward & Backwards Quarters from an Entered Date
  990. extracting text around the @ symbol
  991. Launching PowerPoint Viewer from EXCEL 2007 with vb
  992. Count only on visually populated cells
  993. Combine SUMIF and SUMPRODUCT
  994. countif function question
  995. Compare lists in Multiple workbooks
  996. Copy a text from one tab to another using a function
  997. How to copy formatting in validation cells?
  998. COUNTIF not working w/ cells result of SUM and VLOOKUP
  999. Summing Data by date from different tables
  1000. Zero Lines in Spreadsheets (removing)