PDA

View Full Version : Excel Discussion (Misc queries)


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 | 

  1. Delete certain text from cells
  2. Using the If function for a date range
  3. Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons?
  4. Autosize Merged Cell - Including auto shrink of cell
  5. Display Ticket Numbers in Other sheet based on condion
  6. Replace
  7. Calculating FED TAX in Excel
  8. Multi-demensional frequency distribution
  9. How to Remove Excel Protection?
  10. AUtofiltering dates
  11. Import Images into cells from a file without using VBA or Macro. Can it be done ?
  12. Excel Formula
  13. Re: Can't Break Links
  14. Hi, is there a way to access mouseover (hover) data in excel)?
  15. I think I may need to use a macro?
  16. Need a Macro
  17. Need to autosort excel data
  18. sumproduct() function resulted in an error #DIV/0
  19. How to read data from the workbook selectively?
  20. Formula help
  21. Array formula - help with #NUM! errors
  22. how to specify the first cell with data in it inside an if statement
  23. Define a dynamic Print_Area
  24. Dates
  25. contineous cont
  26. Default font
  27. Macro for saving file as cell ref
  28. PowerPivot How to chart with contiguous time axis?
  29. Pivot Tables and Filter Criteria Display
  30. Adding text to email body
  31. VBA creating draft emails from addresses in excel
  32. Specific hours worked between two time intervals
  33. Formula Audit mode active in one column only; cannot kill.
  34. combolist conditional format
  35. how can I lock/unlock a range of cells depending on state of a checkbox?
  36. How many pieces of trim molding to order?
  37. If+and+concatenate
  38. If+concatenate
  39. Re: Font options
  40. Help needed
  41. Help with Macro on moving data with headers into larger file..
  42. Tweaking VBA
  43. vlookup
  44. Data Validation help
  45. Grey ghost rectangle
  46. For Claus From OP:
  47. To GS Re .csv Commas
  48. .csv Commas ?
  49. VBA Macro Training in Chennai
  50. File Name Chages ?
  51. How do I designate dates using info from a cooresponding drop down list?
  52. Workgroup and Network in Windows 7
  53. Spin Button Settings
  54. Countif, IF condition is met
  55. Formula- Count of items that meet a specific range criteria
  56. Query of List Option
  57. Application.GetSaveAsFilename
  58. number of months and days between two dates without approximation
  59. Variable average
  60. excel formula is returning incorrect values
  61. filter result- total row numbers varies
  62. Insert prefix and suffix to existing string
  63. How do I insert a row or rows between each row of text and copy the row above?
  64. Updating VBA cell reference
  65. Formulas
  66. I'm loving Interse
  67. Mac Countif function not working at all
  68. Ticket Numbering
  69. Excel Shortcut Key
  70. Return only one result from list with multiple posibilities
  71. Re: Stakeholder analysis
  72. Shift Patterns
  73. how can I copy/paste a formula that skips 27 rows?
  74. Excel 2007 - Sudden Disappearance of Character Spacing
  75. Global Macro
  76. Conditionally format: Only if unique identifier and exceeds % of previous record
  77. Truncating Number Series
  78. Microsoft Excel Starter 2010
  79. How to create a dynamic table based on a set of other nested attributes
  80. Separating Duplicates??
  81. Help needed in Excel
  82. What is "--" in Excel Formula (SUMPRODUCT)
  83. Filtering by group in pivot table
  84. create a consolidated text list from multiple ranges
  85. Drop Down Selection Assistance
  86. VLookup using two criterias - looking for a efficient way
  87. Scenario Manager...Need Help
  88. Macro that sorts data with blanks at the bottom
  89. Multiple Regression - polynomial fit
  90. Move cells up
  91. Vlookup using two criteria -not working
  92. Weighted Grades Worksheet
  93. acquiring web data and processing them
  94. how to add a letter to front of column sample ID
  95. Multiple Criteria Lookup Function
  96. VBA : Class does not support automation error.
  97. Look UP using 4 criterias
  98. Combine excel files
  99. Function help: Reference cell based on another cell's value?
  100. Macro help?: move row to other sheet when text is entered in cell
  101. Creating Pivot Table with Macro using Multiple Sheets
  102. Unable to open templates
  103. Distance between latitude and longitude
  104. Simple Timer facility
  105. Copy and Pasting with Macros
  106. New User: Copy Cell and Insert into Cell of Text.
  107. Use excel to calculate an expiration date
  108. Help linking true false in column to start macros
  109. Display Hex codes from numeric input
  110. Compressing graphs from excel into word
  111. Some help
  112. Automatic If statement / macro to copy one cell to different worksheet and print!
  113. Issue with hidden field in Pivot table
  114. How to compare two work sheel cell by cell
  115. Formula to check presence of value between sheets
  116. Printing Excel File Custom Properties in the Footer
  117. want to understand Excel-VBA 2007 code
  118. countif text values to represent different numerical values
  119. if function
  120. what does 6.9544E+23 stand for
  121. Macro adds "=" to each cell in defined range across multiple worksheets
  122. multiple columns into one column and autofill(?) question
  123. Having trouble with formula
  124. Please Help
  125. Formula Not Updating when copied down
  126. formula with text and rounding
  127. XL 2003 very slow to Copy. XP SP3
  128. 3 variable 2 dimensional line graph
  129. Looking to added up based on a character from cell range
  130. Conditional Formatting 3 blanks in a row
  131. Pivot table Refresh problem - Excel 2003
  132. how to link audio files to a string in excel 2007?
  133. retrieving values from a certain column
  134. Conditional Format Formula for finding duplicates in a row
  135. Automatically join files
  136. Gridlines display in Print preview but do not print
  137. Macro with worksheet
  138. VLOOKUP a Pivot Table Filter
  139. Find rows that contain capital letter?
  140. Difference in Time hour what formula to use in excel?
  141. Help Needed
  142. Compare a column of substring with another column of strings and get count
  143. Question regarding an auto-search facility
  144. Bracers before text in a single cell
  145. Complicated Look Up (without making changes to the blank spaces in the table)
  146. date calculation in pivot table to show products over agreed date?
  147. Sale options on a CSV
  148. Auto deletion of cell entry in given circumstance
  149. Numaric to Inword in excel by VB
  150. Simple IF Statement Help!
  151. how to get a warning when data is entered wrongly
  152. how to find out the lowest value in an array
  153. the forumula bar is not visible
  154. Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) between entry time
  155. Complicated Vlookup and array
  156. Excell 2000 macro will not open file!
  157. Excel 2002, problem with Text to Columns
  158. How to add cell's reference to cell's content
  159. formula question - weighted sales/distribution
  160. Long Path Error
  161. Help matching combined text cells
  162. Running an app which requires quote defined parameters
  163. Help with finding result from data
  164. Printing all columns
  165. Print Macro w/drop down list
  166. Data Sorting Technique
  167. Gridlines
  168. add multiple letters to the end of multiple cells
  169. Link data from Another cell
  170. Exchanging data
  171. % Difference between cells based on variable...
  172. I have an excel spreadsheet. I want to export each single rows into a new email on mi
  173. Insert File name in Excel File
  174. Remove Data which is not match with other column
  175. countif function
  176. Add "+" plus symbol for a positive percentage
  177. Reading CSV with numbers in text format, Excel automatically convertsto scientific notation
  178. VLOOKUP returning #N/A ??
  179. freeze panes
  180. Need Help Regarding Points of intersection in graph.
  181. Extra help on Nth Day of month
  182. How to replace a constant from a cell containing date and time
  183. Setting Range with a Loop
  184. IT CertificationzzzZ.....100% GUARANTEED PASS.......!!!@!!!
  185. How to search specific list in different sheet
  186. formula to mark last and first row
  187. designing a macro
  188. Speech Recognition & Dictation in Excel: How to turn it on?
  189. Remove colour change
  190. Excel 2010 workbook protection
  191. how do I search thru the values in my column and replace with nessesary values
  192. Conditional Formatting
  193. Edit File Information
  194. Project If Function
  195. Excel (VBA) Macro Training in Chennai
  196. VBA Macro Training in Chennai
  197. Trying to reference two sets of data with one number
  198. How to automatically relist values in separate column
  199. VBA excel, MySQL DB
  200. how to find the posts which i have made so far in this forum
  201. Paste values whilst ignoring formulas.
  202. Spelling checker problem on a specific worksheet only
  203. Average of Days Between Customers Visits
  204. Hyperlinks Broken in Excel 07
  205. Lookup all occurences and return their column headings
  206. Reading the last for characters of a data.
  207. Scatter charts for name with two values
  208. How to count innings pitched?
  209. Permutation/Combination/Pairs order unimportant.
  210. Opening XLS (2003) workbooks in 2007 (XLSX)
  211. PowerPivot query
  212. Auto populate from list on separate sheet
  213. place code where?
  214. Using Filter more than once
  215. Formula autofill to cells below – formula arguments are cell areas in different columns
  216. need help with excel
  217. identify Numbers in a list as Mobile,Landline,STD or ISD numbers
  218. Sum of Numbers of a Rolling 6 month Period range
  219. Re: separate questions and answers of a test
  220. Excel as an inventory base
  221. Re: separate questions and answers of a test
  222. Ruler option is muted in Excel 2007
  223. Re: separate questions and answers of a test
  224. Excel not responding before calculations
  225. Re: separate questions and answers of a test
  226. Formula to change name format
  227. How to calculate multiple conditions?
  228. Can you display entire rows that match a certain criteria...
  229. calculating age of debt (30,60,90 days)
  230. excel formula problem
  231. Populate row with work days
  232. Conditional formula
  233. Problem with Kill Syntax!
  234. Conditional formatting with two columns
  235. Macro to copy data X number of times into a column
  236. Sort Marco won't work in 2010
  237. Change all text on Spread sheet
  238. Data Validation Tool and Tables Trouble
  239. VBA Copy multiple columns with the same heading from one sheet to another
  240. Remove duplicate items in the table
  241. Need help deleting data
  242. Formula to calculate Rank and % growth
  243. =IF function with current date
  244. LEFT function not working with dates
  245. If statements from multiple sheets
  246. How to hide rows having a specific value in cell of column A ?
  247. Need Help with VLOOKUP
  248. Data Validation Query
  249. help on summing a random combination
  250. VLOOKUP returning #N/A result
  251. Search and consolidate multiple values in multiple fields
  252. File not opening and crashing with macros
  253. Help with an IF Statement
  254. Re: calculating volume
  255. Help with show info on one row in Excel 2007
  256. Problems with static dd/mm and rolling year
  257. Need to reorganize - transpose columns to rows per article number
  258. Shade a section under line graph in excel
  259. Warnings on a certain date
  260. Problem with Formula of IF/AND/COUNT/SUM
  261. Bubble Charts
  262. hidden rows and autofill troubles
  263. Number of work days between two dates entered into a user form text box
  264. Error message with nesting
  265. Workbook hiding itself when it is opened!
  266. How to count non blank cells with a condition?
  267. V Look up with drop down functionality
  268. Change cell color if used in a formula?
  269. Advance Macro help
  270. excel 2010 + copy array
  271. Address fields in columns...
  272. Address fields in columns...
  273. adding small letter on top right of value
  274. Address fields in columns...
  275. how to open PRN files in Excels?
  276. Auto filling across multiple worksheets
  277. Are there any macros to lock a colum after a colum had been freezed-pane?
  278. randomly picking up an array element from an array of elements
  279. adding brackets to every cells without changing content
  280. Date format/value different when opening manually compare to VBA macro
  281. Countifs formula
  282. How do I stack data in Excel 2007?
  283. Where to Start
  284. changing rows *and* columns in automatic formulae
  285. Search for either one or the other
  286. Summing across multiple columns
  287. Excel Invoice help
  288. Conditional Formatting in Excel 2003
  289. Matching Rows with Multiple Columns in Two Worksheets
  290. Array counting
  291. Array counting
  292. Total formula
  293. How do I insert a row without the formula changing?
  294. Find Max value within a Offset
  295. Lookup based on list selection in cell
  296. Problem with dates in a Gannt chart - please help
  297. Locking by multiple users possible?
  298. Really complicated one.... Experts come rescue me!
  299. Making inputs for average formula dynamic
  300. Look up with multiple variables
  301. Auto-populate spreadsheet based on database info?
  302. Data Lookup Question
  303. Help showing active months between two dates
  304. Help showing active months between two dates
  305. Check if a date comes before/after a range of dates
  306. Please Help! Can't solve excel problem
  307. Help! How do I ignore blanks cells in an array?
  308. Look Up with Multiple Conditions
  309. help with copying data from many columns into one long column
  310. Wonky printout when I print entire workbook
  311. Displaying two dates in excel
  312. Conditional Formatting Training Expiry Dates
  313. How to insert date continuosly onto sheets if the first sheet had been put the date?
  314. Help with a Formula to turn various words into numbers
  315. Excel date question
  316. Help with this formula
  317. Help Writing a SUM Formula
  318. Need help matching similar data...
  319. Averaging Data across multiple sheets
  320. Conditional format not refreshing Excel 2007
  321. 2007 conditional formatting not playing ball
  322. Combobox and link to another cell
  323. Compare data in multiple columns
  324. Conditional formatting disappears when cell contents deleted
  325. Help Needed - Making Numbers
  326. Identify data in monthly sheets in WB and consolidate into master sheet
  327. SUMIF across 2 columns.
  328. Addidtional Calculation and Conditional Formating within pivot table
  329. Creating a Timeline
  330. How to convert 1.25 into million (1,250,000)?
  331. IF Function Question
  332. Formula Assistance
  333. Comparing two columns with conditional formatting
  334. Using 'indirect' function with full network path
  335. Excel 2003 with Reference error cause me a headache
  336. Variations against one value
  337. Worksheet name as a variable in VBA
  338. 2 Exce; Problems
  339. Finding first cell from the left above threshold using Monte Carlo Simulation
  340. Automation of copy/pasting data and retrieving results
  341. trying to get data from rows to columns
  342. Help with Look Up with multiple complex conditions
  343. mydoghasfleas
  344. Calculation with a Blank or 0 Cell
  345. Macro to add new sheet and then fill formula in a totals sheet to refernce this sheet
  346. Finding largest total of ANY two values in a data set
  347. Store Excel value
  348. Sort by Every Other Row?
  349. Move data from every other row to columns
  350. How to Remove Forbidden Characters
  351. Conditional Formatting Dates Less Than 14 Years Ago
  352. JESUS IS LORD!
  353. JESUS IS LORD!
  354. Stacked graph
  355. Using Data Validation in a Table
  356. Extending a selection
  357. Need help Extract numbers
  358. Pull Data With IF Statement And Sort.
  359. Sumif & Countif
  360. Macro to send email with multiple attachment
  361. Complicated Date Formula
  362. how to strip an individual symbol from each row in a column
  363. Work from Home. Earn $2000/month. No Investment. Part Time, 1-2h/day. .
  364. Macros and Email
  365. Auto populate monthly and quarterly data
  366. Average with conditions
  367. Rostering form: Adding New Lines to a table about a totals calculation.
  368. In Excel 2010, how do I set a chart to treat missing data points as zero?
  369. Force zeros in Excel 2007 when cells blank and keep commas for thousands
  370. Separate Values
  371. Autofilling dates
  372. Matching records based on a common field
  373. Page Breaks
  374. A way to extract info from multiple excel files, based on content?
  375. Text to columns
  376. automating data across cells/sheets
  377. Deleting Certain Data in Excell
  378. Format appears stuck..how to break formatting
  379. Excel 2002 file is suddenly read-only?
  380. Help With Nested SumIf / Or
  381. Getting "N/A"
  382. Colour cell yellow when there is not data entered
  383. HOW-TO make a random selection from a set of data and divide it into sub-team
  384. Date and If problem
  385. formula to count text entries and return text with most entries
  386. Dates and if statements
  387. Multiple IF's ??
  388. Duplicate with Criteria
  389. Formula for transferring data in rows to columns on two different Worksheets
  390. Pivot Items Filter using VBA
  391. "Unwrap" Excel list into table, to facilitate pivot
  392. input field linked to button to create a table
  393. Formulating The Price with Various Condition and Counting
  394. Correct process for creating a linear trend line in Excel
  395. Summarise data on multiple sheets
  396. Extracting specific info from cells
  397. Excel and date ranges
  398. Tree from Parent/Child Pairs
  399. CSV file conversion + True/False over multiple columns of data
  400. Macro attached to Autoshape Hyperlink not invoking
  401. Need to have data in one column
  402. Displaying time gaps
  403. closet lookup
  404. Calculating Work Time
  405. SIMPLE DRAGGING issue
  406. Max Length in a row
  407. Populating cell with string not in workbook
  408. Formula to match a data point in 2 wrkshts
  409. Saving Formulas in Excel
  410. FORMATTING CELLS
  411. printing on paper size of 10 inches X 12 inches
  412. Conditional formatting
  413. Making cells appear on screen but NOT print
  414. Excel Auto Sum
  415. Macro to delte Duplicate rows across multiple sheets
  416. excel formula for markup and profit margin
  417. Avoiding display msg when saving a .xlsm file to .xlsx
  418. Insert Rows Below
  419. Merge excel files with different column headings
  420. #VALUE error which disappears when I use F2, ENTER
  421. Excel macro to copy the rightmost column to a new column
  422. Summarize the monthly recrods by name
  423. Example Spreadsheets
  424. excel compare problem
  425. Dividing worksheet into multiple workbooks
  426. convert time
  427. Need Help copying part of an Excel Cell?
  428. IF statement with multiple VLOOKUPs
  429. Conditional Formatting assistance
  430. RPG Initiative Segment Counter help!
  431. Display excel workbook name in bar
  432. Why Not in a Single Cell
  433. Title row
  434. How to do the following copying?
  435. Pivot Table modelling with 1:many columns
  436. best way to count something in one column using criteria in another column
  437. Restricting a Random Query?
  438. Vlookup with an Arrayformula.... HELP!
  439. Auto fit text in linked cells of a protected worksheet
  440. CountIf Query
  441. relective formula
  442. Auto-summing similar lines
  443. Add partial year to date
  444. converting dates from file
  445. change the rows value based on conditions
  446. Calculating compass bearing or angles
  447. Row height puzzle
  448. Linking Rows Between Sheets When Sorting
  449. dates converted
  450. Deleting rows which contain blank cells
  451. 255 truncation
  452. Excel 2007 size of text in command button
  453. Spreadsheet formatting changes on different computers
  454. To copy Data from a row in one wrokbook and insert in a sheet of another workbook
  455. Please Help: color coding a timeline graph
  456. deleting workbooks as i go
  457. Executing a .BAT file using excel macro
  458. Hyperlinks changed by Excel again!
  459. CubeSet Excel 2010 Question
  460. Excel 2007 vlookup with Pivot table
  461. Deleting text from number cells
  462. Applying 2 filters via a Macro
  463. Excel macro to copy rows in one sheet and insert into another sheet
  464. Concatenate if there is a value or Find and Replace Null values
  465. Help changing the sheet name
  466. Macro settings in Excel
  467. Converting Numbers to text problems
  468. Problem with Excel Formatting
  469. Dropbox selection
  470. macro for calculate and compare
  471. Array of data in Excel Visual Basic
  472. Embedded Count If
  473. 2147467259 Unexpected Error from external database driver [Non admin user]
  474. Multiple seach and replace in excel
  475. Help with CountIF / SUM
  476. Picking out certain data from a cell
  477. Retirement savings in excel
  478. Search and Link across worksheets
  479. How to get SUM of range of cells based on two separate dropdown selections.
  480. Sorting based upon category and adding header
  481. SUMIFS formula, reading text
  482. Revenue Report
  483. WSFTP SSL Issue
  484. ISODD array formula
  485. Help with user selectable data presentation
  486. Dynamically Change Chart Data Range
  487. Formula's won't read copy / pasted data ?
  488. New BUG in Excel 2010?
  489. How to insert new worksheet based on # of rows in a data sourch
  490. How to consolidate different Excel sheets?
  491. Trend line Formulas
  492. Complex formula help , please.
  493. Change states of some checkboxes from drop-down list?
  494. Automatically copying data from sheet1 to sheet2
  495. How do you duplicate information if it matches a criteria
  496. Entering email addresses
  497. Random table of data - need to find every cell that contains specific data
  498. Missing Row Column Numbers Not Column Letters
  499. Expanding Single Items In Large Pivot Tables
  500. Finding and Replacing Sheet Names
  501. Un-Hide Col. A (Excel Starter)
  502. lookup value for form multiple combination in a Matrix
  503. Dependent validation for a contact directory
  504. How to add different text to one cell?
  505. Excel opening media player
  506. Flattening Data
  507. Searching cells
  508. how to get a word be spread to cells
  509. Medicare Levy Surcharge
  510. Help please - formula to calculate Tax
  511. Missing Formula Bar
  512. Bar chart problem
  513. bingo
  514. Copy Specific Cell information based off of multiple criteria
  515. =f14-(f14*$e$15)
  516. Trouble with Sheet programming
  517. MAX IF Function strange behavior
  518. Update workbook pages- how?
  519. Merging cells based on same values
  520. Sorting a column based on required order
  521. Adding multiple page breaks - at start of each day
  522. Sequential Rank Explaination Please
  523. Insert text box greyed out?
  524. Missing .xlw file
  525. Tutorial on creating barcodes in Excel
  526. Lookup function help required.
  527. Max-Min with specific criteria
  528. Edit text box in 2010 - how?
  529. Great lesson on Pivot tables
  530. Macro to add value of (1) to a selected cell or cells?
  531. Add value of (1) to a selected cell or cells
  532. Cut and "insert cut cells" in Excel 2007 doesn't work.
  533. Format Cells - Fill colour Help
  534. how to copy an excel sheet to this message
  535. how to insert serial numbers to rows?
  536. Tie additional cells to cell automatically updated
  537. User name and password
  538. Count unique entries in excel
  539. Count unige lines in a column based on a crieria in a other column
  540. Excel 2007: Three comparisons
  541. System resource problems
  542. Progress bar in Excel 2010
  543. Linked 75 MB excel files - HELP
  544. Two formulas in one cell?
  545. Excel wont Paste Special wont paste formulas it says Unicode text
  546. Excel functions
  547. How To Copy Text To Other Cells
  548. Macro / VBA help 4-5-12
  549. Printing Names & addresses on Envelopes - how?
  550. why the normal view is not coming in worksheet
  551. Excel 2007 pivot table: select multiple data easier
  552. XIRR Giving Negative Number on Positive Cash Flow Stream
  553. Alt Enter Creates Tab Character
  554. how to copy a formula to other cells-any shortcut
  555. Re: XIRR
  556. XIRR
  557. to give numbers to rows as per your wish
  558. Days between two dates?
  559. Creating a Credit Card Expense tracking sheet
  560. Reverse Index Match
  561. Copy not functioning (not a Paste issue) - Excel 2007
  562. Back calculating compound interest...
  563. how to find records that start with the same word in a worksheet
  564. OptionButton not included in a GroupBox
  565. Numbers from first column
  566. how to delete some rows without data which comes in between rows with data
  567. From Excel 97 to EXcel 2010 - TextBox on a Graph
  568. Creating MAX and MIN Formulas
  569. Advanced Functions and Formulas with excel dummies
  570. How to open a file in another window?
  571. Comparing two sheets - Please help!!!
  572. multiple sheet question
  573. Calculate No Of Months Seperate For Two Different Years
  574. Checking Hyperlinks
  575. Automatically plotting one cell from newly completed sheets
  576. Cell Protection
  577. Found out how to get the home tab back in Excel 2010
  578. images into excel
  579. Sending email with multiple attachments
  580. Changing coloue cell en text colour by clicking cell
  581. print formating for very numeroous files
  582. Generating Fresh Copies Of an Excel Document
  583. Need formula to randomize employee numbers for history audits
  584. Trying to figure the formula
  585. Copying functionality lost
  586. XL 2010 to XL 2007 backward compatibility
  587. Search all instances of word and retrieve column data
  588. Subtotal for text fields
  589. counting weeks in current month.
  590. Excel 2010 not allowing me to paste as formula
  591. excel file convert into word format
  592. if and then help!!
  593. Closing Help Window From Keyboard
  594. Specific words Categorizaion
  595. Hiding tabs in Excel
  596. Popups to look up on two variable columns
  597. Combining Conditional formatting Rules
  598. Matching 2 colums from 2 seperate tabs
  599. Insert Row and Countif Macro
  600. Vlookup with alphanumeric values
  601. Copy and Paste x amount of times.
  602. Count of colored excel Rows
  603. Need help with Excel Formula for calculating sum of products depending on criteria
  604. Need help with Excel Formula for calculating sum of products depending on criteria
  605. Excel 2007 Command button
  606. IP Address
  607. Unique Records Filter
  608. Modeling Non Linear Depletion Rates
  609. Formula confusion !!!!
  610. Sort Order - Non contiguous
  611. Simple Average Question
  612. How to edit MSN Stock Quotes Template in Excel 2007
  613. How should i call below function
  614. INDIRECT formula not working
  615. File won't open
  616. Copying formulas but incrementing the worsheet reference
  617. Pivot table overlaps another pivot table - how to find it
  618. Fill Series in Filtered Rows
  619. VB to move entire row to another sheet
  620. v lookup problem
  621. out 2 cents - auto rounding?
  622. Require formula to search across multiple worksheets
  623. nested IF without repeating the condition to be tested
  624. Extracting Text between 2 special characters of URL using Excel
  625. Round Amount
  626. Selecting all cells with content using a variable
  627. How do I create an isometric grid?
  628. conditional formatting formula to highlight items on column B inrelation to column A
  629. monthly calculation for storage
  630. How can I translate text in many cells of an Excel sheet from Englishto Greek with VBA
  631. How to Forecast Sales in Excel
  632. Attendance tracker
  633. Basic Functions with Excel Dummies
  634. FV Function (Excel)
  635. Dependant dropdown lists in a VBA form
  636. Formula help
  637. How to combine two column labels in a pivot table
  638. Command Button Visibility
  639. Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria)
  640. Pivot Tables
  641. Count values
  642. Insert row
  643. Vlookup Help
  644. BARCELONA** R4 DS CARTUCHOS **
  645. Delete empty rows
  646. Format a Range to Multiply by 1000
  647. Macro that will ignore all information within Parentheses
  648. Disallow special characters - Data Validation
  649. web query
  650. Adding dates in a IF Statement
  651. How to Reduce size of Macro Enabled Excel File
  652. Dynamic Graph: X-axis based on user input date
  653. Delete extra empty rows
  654. Formula, one field complex or multiple table field simple
  655. Auto substract by comparing the category
  656. Delete cells
  657. Delete cells
  658. Sumproduct with multiple criteria
  659. autocad Hyper links
  660. hyperlinks
  661. Re: Separating fields
  662. Daycare Birthday Program?
  663. Getting Min/Max/Average but cutting out data
  664. Formula Displays Instead of Result One Column Only
  665. Returning the month (mmm) from cell in date format dd/mm/yyyy
  666. Find number of particular values over an interval
  667. Insert full row from worksheer to another base on condition
  668. TEXT function
  669. separating cells
  670. Separating fields
  671. Auto-arrange
  672. Printing: page count exceeds pages in tab
  673. Summary Worksheet.
  674. Excel Help: if then searching multiple cells
  675. Making a rota list
  676. Subtract times?
  677. Using Subtotals tool to average multiple rows of non-continuous data based on ID #
  678. FIND ALL
  679. Paste Special Values
  680. Check dates against a date range.
  681. Formula Problem with IF (Negative and Positive Numbers)
  682. Repeat data
  683. Repeating cells
  684. Lottery
  685. Macros to check whether all cells are filled
  686. Finding an average with the lookup function
  687. Unique Value Count in 3 Columns Using Search Criteria
  688. formula error
  689. How to sort entire spreadsheet by one column sort
  690. Pasting HTML script to Excel 2007 converts the cells format to 'General'
  691. Printing edge to edge and automatically generating a new page query
  692. Extremely sloooooooooow subtotalling
  693. Shift cells right
  694. Shift cells
  695. Formula Returning "False"
  696. Newbie needing help with nested VLOOKUP IF function....
  697. Extension of Dependent Pulldown Lists
  698. Classifying times of day into sections
  699. Color Conditional Formating
  700. Macro
  701. Macro
  702. Deleting duplicates within a column?
  703. If value is true the check column for specific values
  704. Calculate date so many days before/after current date.
  705. Importing data from .xlsx files
  706. Find 0.00%
  707. Find cells
  708. Formula to explain
  709. Converting this raw data into something formulaic
  710. Text in Custom Number Formats
  711. Copy a shape's formatting
  712. Links to Excel Workbooks change
  713. Date Frequency
  714. Unique cells
  715. Detete matching cells
  716. Vlookup Multiple Criteria - Please help
  717. Combining Text From Cells
  718. updating a spreadsheet with a 'Search' User Form
  719. COUNTA for counting numerous text entries?
  720. Building Macros in 2003 and Running in 2007
  721. 3-4 conditions in a vlook-up
  722. Disregard text in a cell
  723. SUMPRODUCT with date range running slow
  724. Print range
  725. If cell is blank automatically enter today's date in the same cell
  726. Average Question
  727. count number of repeats in a column highlight result
  728. Subtracting Values from a Ranked List
  729. Transposing Multiple Rows into 2 Data columns
  730. HP printing
  731. Linked Excel Files - Shared Server
  732. Compare and Merge Workbook
  733. Tidying up workbook (and pivot table help)...
  734. Autofill data from one tab to another under certain criteria
  735. Re: Part of the screen has blank spots (not refreshing properly)
  736. Enabling Autofilter and Sorting in a Protected Sheet
  737. Save copy on Open, keeping old backup copies
  738. delete rows between tow inputs numbers
  739. Matching Names
  740. VLookup Method for Comma Delimited Field
  741. row height
  742. data table text alignment in excel chart
  743. Clearing ".csv" file using VBA
  744. One Click = Multiple Cells in Excel 2007
  745. Same Problem
  746. Sum / Lookup
  747. Copy a formula using Vlookup
  748. Using Excel VBA: sending output data table to created .csv file +append Options
  749. Re: Changing position of last used cell
  750. Split Cell Range into Multiple Cells
  751. Why does hyperlink fail?
  752. conditional formatting for 2 colums
  753. Macro to Delete the last N rows
  754. How to extract email addresses from 1 worksheet to another workbook
  755. template creates invoice - how to create summary worksheet?
  756. How calculate a difference btwn 2 TextBox and insert the result inthe appropriate cell
  757. Copied sheet causing duplicate range name error (Excel 2010)
  758. CommandButton as array ?
  759. Blinking Button
  760. Date and amount of last payment
  761. Populate empty cells to use for conversion
  762. Joining 2 if functions
  763. Popup to show ongoing activity
  764. Find
  765. Big Bertha Thing Chair
  766. Re: Copy value
  767. Re: Copy value
  768. calculate percent change
  769. Copy value
  770. Array Declaration.
  771. Office 2007 Compatibility Pack doesn't work
  772. Macro Help: Find Value, Cut and Paste Row
  773. Excel ignores LocaleID?
  774. opening CSV file in Excel 2010 from VBA
  775. Setting currency as string
  776. Summing rows using formulas with variables
  777. Sorting a sheet in VBA
  778. Calculating weeks
  779. view all text in formula bar
  780. Sumproduct formula help needed
  781. Sorting formula cells not same as sort of value cells? Yikes!
  782. Big Bertha Thing progress
  783. Excel trend line equation does not generate correct results
  784. Custom Number Format for text
  785. Re: Missing Excel Cell Gridlines
  786. Macro Error
  787. Merging data from several Excel 2010 spreadhseets
  788. Calculations based on cell colour
  789. Excel 2007 - How to get cell referrences from dates in combobox
  790. Split Print Area: How to make it print to one page
  791. remove lines in pivot table with zero values
  792. Formatting problem copying sheet
  793. recover an excel file
  794. Custome Views Greyed out
  795. xml transforms to rearrange worksheet data?
  796. shorten worksheet name
  797. loop through code and refernce text file for info
  798. How to make a number have a certain number of characters.
  799. I need url links to be activated in my cells
  800. Page Break Preview
  801. Satisfying several criteria
  802. Two Instances
  803. Big Bertha Thing pin-wheel
  804. Convert date to Age
  805. Help: Modulo... not... quite...right...
  806. Turning off this message?
  807. Disable Macro Alert
  808. How to slove: Circular Reference Warning
  809. Deleting blank rows
  810. Replace weird character
  811. help with a simple macro
  812. (Please Help) Merge coloms based on equal rows with information
  813. Combining multiple workbooks
  814. Hyperlinks for video files
  815. Weird corruption of hyperlinks
  816. Columns not sorting properly.
  817. How to copy a range of cells and paste into a new workbook in differentcolumns
  818. Line with length depending on the value of the cell
  819. Saving as XML
  820. How to lookup based in the first 3 characters of a cell
  821. Timetable
  822. Ctrl+Click doesn't select non contiguous cells
  823. Change to formula to make it go to next weekday (i.e., avoid weekend days)?
  824. Importing data from Excel worksheet into Excel template
  825. How smart is excel?
  826. Formula to display next Friday from B1 works except on the Friday itself.
  827. Formula Quesion
  828. Big Bertha Thing proton
  829. excel and searching for a string in a cell where comments have been added
  830. Possible Indirect query
  831. Excel Macro
  832. tabsheet-function to get the formatted text of a cell
  833. Excel 2007 noncontiguous cell highlight color=light,light blue. How do I make it darker, or like Excel 2003 ( I'm extremely shade blind-PLZ HELP !! )
  834. how to calculate divisors of a number
  835. Extract info based on Name
  836. Extracting data from spreadsheet to a graph
  837. Random Pairings with a Caveat
  838. VBA Macro Training in Chennai
  839. Search Box
  840. 2010>2003
  841. Need help
  842. How to sum values between dates
  843. convert 00:06 minutes to 6
  844. Any ideas for this formula???
  845. Formula to validate characters within a string of data in aparticular cell
  846. Help Writing a Complicated Formula
  847. Blank Suppression
  848. Row height setting problem
  849. Calculate quantity of shapes inside another shape
  850. Getting 1 list from 2 sheets
  851. Big Bertha Thing spider
  852. Excel 2010 Service Pack 1
  853. Extending existing coding to include new parameters
  854. Re: How Do I Find My Posts Here?
  855. Opeing older files in Excel 2007 - file date-stamp amended
  856. Conditional Formatting or VBA
  857. Set Column Width to Inches?
  858. Retrieving historic web data automatically
  859. Re: Loop
  860. Re: Loop
  861. Loop
  862. Referencing a pivot tables Grand Totals Column
  863. No entry in B1 unless A1 has a date AND it is earlier
  864. Find the number of weeks using an array
  865. Blank Lines Question
  866. External Data Toolbar permanently greyed out.
  867. Combination of INDEX MATCH FREQ ROW INDIRECT - find unique values using2 conds with UIDs that may have multiples
  868. Re: hi hawaiiham2000,it is not dashed line but it is margin line.
  869. Multi Dimensional Lookup
  870. http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo
  871. Trying to create Macro to search the Internet Movie Database
  872. Doing this in Excel?
  873. Macro to create Sort buttons
  874. Move cells down
  875. JustNN
  876. Average Formula Help
  877. Re: Array
  878. Either cell but not both
  879. Array
  880. Date shows as a number
  881. Marco Exits without error
  882. Answers Forum login problem?
  883. autocorrect question
  884. Combining two macros
  885. Incorpoarting cell contents into a message box
  886. Excel 2010 (64 bit) External Data connection with Access
  887. Lottery...
  888. Amending an existing formual to improve grammar
  889. Big Bertha Thing Positive
  890. File Path Too Long? Not Anymore! Check out Long Path Tool
  891. Concatenate for multiple columns
  892. HI.
  893. combo box2 reading a cell like vlookup
  894. How to make a receipt or invoice so that the receipt Nos. change automatically
  895. Macro to send email with attachements
  896. lookup and offset formula
  897. does xcel have a built in scheduler ?
  898. Countif using two columns?
  899. advise on how to import data into excel sheet
  900. MS Query refresh question
  901. formula help
  902. Big Bertha Thing letter
  903. Importing named range from another workbook
  904. Modifying a protect unprotect macro
  905. merging spreadsheet data
  906. Disable spreadsheet when copied to incorrect file path or differen ip address
  907. Qualifying permissions in protect unprotect macro.
  908. Need help
  909. Incrementally Updating worksheets in a workbook
  910. LIS file format to XPS
  911. Auto Fill formula when inserting a new line
  912. weekend timesheet formula help
  913. pytanie o kopiowanie bez zmiany formuły
  914. Add columns to reach a predetermined value
  915. Comparing text in columns
  916. Trying to Change Font Color Stops Excel 2007
  917. Excel 2010 error
  918. Wits end wrt automatic linking
  919. setting row height not to exceed...
  920. Determine accuracy percentage between two dates
  921. Average cells based on column header
  922. Find the position of a date
  923. Delete/Copy Path Too Long Files
  924. Chart to foreground
  925. Big Bertha Thing proton
  926. Minus Sign
  927. Need to lock 2 rows in a sheet
  928. Display plus sign for positive numbers
  929. A/B split testing question
  930. counting records by month and year / date format issues
  931. Automate form filling
  932. Excel Shared File
  933. Assign points based on two conditions
  934. Counting down formula
  935. Pivot Table Help
  936. Dividing existing content into two cells
  937. Changing Hours in working Days
  938. emailing from excel with Thundrbird
  939. Big Bertha Thing positron
  940. Re: You missed the point...
  941. frequency table
  942. Summation of 25 highest values out of total data of 35
  943. Data validation list using filtered range
  944. Double A copier paper.....0.80USD
  945. A chart wont recognise selected data
  946. Refresh Excel Sheet with Access Data Frequently
  947. pairing 2 column in one sheet
  948. help writing formula to merge two worksheets
  949. Help with if formula please.
  950. Excel "IF" Formula
  951. Showing the top result from a range of cells
  952. Duplicate Entries
  953. Lines cut off
  954. Conditional formatting ranges in VBA
  955. TOP Urgent
  956. All 0's on Pivot Table Sum, Data NOT text
  957. OX Excel en PDF Convertisseur
  958. Help displaying "Maximum" or "Minimum" if cell is max or min in a group?
  959. Suffule data to rearrange in specified format
  960. Automatically Insert New Rows
  961. Transpose Question: Column to Multiple Rows
  962. web query
  963. Auto Population data and color
  964. overlapping date ranges
  965. .xls not recognised as excel anymore
  966. Help pls with daily late fee
  967. Pivot Table WITHOUT summarized data
  968. Thousands separator in form and live calculations in form.
  969. Text to column from end or splitting
  970. Rows to columns keeping data integrity
  971. Open Excel file from VB and open MACRO
  972. filename!macroname as variables
  973. Problem using the IF function
  974. Need Help With Conditional Formatting
  975. Loops with sheet codenames
  976. application.match and value problem
  977. from one column into multiple columns
  978. Error on Working Macro
  979. how to copy multiple cells into one cell
  980. Dotted Border Quality in Excel:Mac 2011
  981. XIRR and IRR riddle - Please Help!
  982. Concatenate using Macro
  983. one column grows as another one grows excel 2003
  984. Text parsing HELP
  985. Conditional Formatting Help
  986. Include trailing zeroes in calculation
  987. A4 Copy Paper 80gsm Double A/paperone/ik Plus $0.80 Usd
  988. Mailing each worksheet in Workbook
  989. Bearing calculation
  990. Help!!!! Data Transfer.
  991. how to sum numbers from cells containing letters and numbes
  992. Vlookup for multiple searches
  993. Advanced cell reference
  994. Series of backed up files with time and date
  995. How to extract lines from sheet to another and delete them from the first one
  996. Excel AUTO HYPERLINK
  997. How to change the cell Colour when a date has been surpassed?
  998. Macro to increase to next column
  999. Macro to create a path and save a workbook in it
  1000. Including another "total" row in a pivot table