PDA

View Full Version : Microsoft Excel Misc


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 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254

  1. problem with fractions to decimal
  2. Re: Next July 1 or January 1
  3. Re: Next July 1 or January 1
  4. Re: Data Validation Error Not Working On Paste Special Values
  5. Re: Data Validation Error Not Working On Paste Special Values
  6. How to convert , comma to . dot in excel to do the following calculation?
  7. Re: If function with lots of criteria
  8. Re: This has got to be fairly simple, so...
  9. Re: Find First Negative Number after 'X' has been reached
  10. Re: Find First Negative Number after 'X' has been reached
  11. Re: Filling Empty Fields
  12. Re: Filling Empty Fields
  13. Re: How to Search down a column fo a specific number of digits
  14. disable f lock on HP pavilion dv7-4277
  15. Re: converting money formatting
  16. Re: converting money formatting
  17. Merge Multiple workbook sheets into one workbook
  18. Merging multiple columns into one column (dynamically)
  19. Find the max number of objects to be placed on a surface
  20. Re: Automatically Repeating Rows on Each Tab?
  21. Macro to duplicate row based on cell value
  22. Re: Removing Line Breaks Within a Cell
  23. Re: How to restore a file ??
  24. Re: How secure are Excel passwords?
  25. Re: How secure are Excel passwords?
  26. making a map with excel data
  27. Can I get date in this format?
  28. writing a sort macro
  29. Pivot table filter list - listing irrelevant subcategorys
  30. Using AutoFilter from VBA
  31. Stacking data in 3d Line graph with a multidimensional array [10][4][10]
  32. Activating hyperlinks
  33. Re: Formatting a Spreadsheet
  34. Formula help
  35. Re: Need IF Statement to yield percentages
  36. Re: Help/Check my Formula
  37. Re: Help/Check my Formula
  38. two macros together
  39. Excel Query setup
  40. What does { } mean in excel formulas?
  41. What does { } stand for in excel formulas?
  42. Starting a new line
  43. Trailing 30 days sum calculation with excel
  44. What does "" mean in Excel?
  45. Sum value in all columns that their title is the same
  46. Re: Can someone fix this IF(AND) for me?
  47. How to STOP Excel from changing my data
  48. Re: Split Business Name and Address into 2 fields
  49. counting blank cells within two columns
  50. Re: Dropbox change Trigger an event
  51. Excel to PDF or XPS boilerplate routines
  52. alt down arrow shortcut not working
  53. problems getting this macro to work
  54. macro to print xps then save with name value in (B2)
  55. Re: Sending An email through Gmail without STMP
  56. Re: Random time?
  57. Re: Associating messages with random numbers?
  58. Re: Locking Macros from being edited, but not viewed.
  59. Re: Locking Macros from being edited, but not viewed.
  60. Remove date format?
  61. Re: Help with an Excel macro please?
  62. Cannot copy worksheet to another file
  63. Splitting cell contents into other columns
  64. Re: how can i ask excel to find "Event" AND NOT "Eventdate"
  65. Excel Issue with "Average" showing in Status Bar
  66. Set chart series endpoint dynamically
  67. Re: End(xlDown) Issue
  68. Power Pivot Variance Column
  69. Re: how to get the total of two lines
  70. Re: how to get the total of two lines
  71. Re: how can i print non adjacent pages from a worksheet
  72. Re: how to add a combolist drop down to each row
  73. Re: how to append a phrase to a cellcontent
  74. Re: how to append a phrase to a cellcontent
  75. Re: why the macro is not included in the list?
  76. Seeing Two Different Excel Files At Once: How, please ?
  77. Re: what are the posting options in excelbanter?
  78. Lookups In Excel
  79. Pivot Table with Data Model Connection - getpivotdata #REF error
  80. Re: how to get a simple macro to paste value
  81. Re: how can i change a sequence of numbers using find replace
  82. Re: how can i change a sequence of numbers using find replace
  83. Re: Flag or Delete a line from Sheet 1 if a wildcard search matches from an Exclude list of words in sheet 2
  84. Copy unformatted value of cell via macro
  85. Excel 2007: Help creating a macro that will run Solver?
  86. Excel 2007: Help creating a macro that will run Solver?
  87. Excel 2007: Creating a macro that will run Solver.
  88. Re: is it possible to ask excel to input from another sheet?
  89. Re: is it possible to ask excel to input from another sheet?
  90. Re: if there is a blank ,how to get the blank cell in a range be highlighted
  91. Format Cells
  92. Re: Calculation based on year of entry
  93. convert CSV to XLS format using command
  94. Countifs or a pivot
  95. Re: Complicated Match Formula with conditions
  96. Exporting Data From Excel to SQL
  97. Split cell based on uppercase letter
  98. Pivot Table Counting Text Data
  99. shortcut-> deleting entire row (not just the data)
  100. Formula IF
  101. Need a formula for a descimal integer into a whole number
  102. Re: Find text in cell and copy from 4 characters in front of the found text.
  103. Re: Inserting a colon into text
  104. Re: Persistent "Formula refers to empty cells" error despite cellsevidently NOT being em
  105. Creating sequential numbers plus a letter
  106. Re: IF formula with certain conditions to achieve a desired value
  107. Expanding Date formula
  108. Entering a Text Symbol ?
  109. Having Blank Cells, etc. ?
  110. Sharing workbooks limitations - Merged Cells
  111. Re: The picture is too large and will be truncated
  112. PLS HELP ME TO SOLVE THIS PROBLEM
  113. Re: Can the IF function be used with values from multiple worksheets?
  114. Re: Drop down in Graph (excel 2003)
  115. Re: Persistent "Formula refers to empty cells" error despite cells evidently NOT being em
  116. Re: Golf scores
  117. Re: Inserting slashes in dates in Excel
  118. Conditional formatting for time
  119. Re: "natural join"
  120. Re: if row has duplicates, concat entries in another column?
  121. Re: if row has duplicates, concat entries in another column?
  122. Help with formula
  123. Re: Default font for comments
  124. Re: Default font for comments
  125. Re: Password protecting multiple pages, and then some.
  126. Code to format cells on several worksheets
  127. please help.is it possible re-edit macro to convert text like1530-2200 to time format automatically? i got macro which works with 4 digits
  128. data spans multiple rows within each cell is collapsed when FILTER is used
  129. When sharing, can I force an Excel document to open in a certain view?
  130. Re: Graphics in a Cell Comment
  131. microsoft excel has stopped working message giving by program
  132. How to delete ALL cells containing the same data --- REVISED
  133. How to delete ALL cells containing the same data
  134. Dates, And Their Corresponding Numbers: How To Show ?
  135. Re: Enter carriage return in Excel 2010 text string
  136. Re: New to Banter...
  137. Re: Parsing
  138. How to print cell # while printing in excel
  139. Re: When I insert a worksheet the cell format is accounting
  140. Re: Sorting Revision Labels in Excel
  141. what do these ----> {0.6,2,4,5,6,7,9} and {0,21,111,201,551,1101,2701}means in an excel formula?
  142. Re: Standard Deviation and Averages based on criteria
  143. Email notifications, does this forum have that deature?
  144. How to filter rows data based on background color of individual cells
  145. Print on only one page
  146. Re: Pie Chart and Table Query
  147. Re: IF Statement accepting only positive values
  148. Trendline Not Appearing In Chart Problem ?
  149. Keep spreadsheet on pc & laptop in sinc -how?
  150. Excel CSV Files; Creating Of
  151. Excel And Notepad
  152. Re: How to Update SUM formula after inserting rows
  153. Re: How to Update SUM formula after inserting rows
  154. Quote Marks Question
  155. For Claus Busch: From OP Re Quote Marks.
  156. Re: Comparing two lists in Excel
  157. if statement with vlookup
  158. Adding Quote Marks To A Very Long Column. How, Please ?
  159. Macro to push data to another workbook
  160. How can I keep a zero at the beginning of a mobile number?
  161. How can I keep zeros in the beginning of a mobile number @
  162. Re: Help with Sumproduct searching cell contents
  163. Re: Help with Sumproduct searching cell contents
  164. Re: If Function neglecting 0 as a number
  165. Re: If function..please help
  166. Re: Need help with IF statement (function)
  167. Re: Need help with a formula...
  168. Re: Need help with an IF Function
  169. Re: Need help with an IF Function
  170. Re: Locking Pages and/or Workbook
  171. Re: Search cell value in same column
  172. Web Query
  173. Pivot Table - Row Label Combination
  174. Change Color of cell
  175. Re: export data by selecting date range
  176. Re: Find value based on two lookup values
  177. VLookup or Macro?
  178. how to calculate hrs flown in last one year
  179. Re: V Lookup multiple entires
  180. VLOOKUP isn't working properly in Excel on Mac
  181. Re: Conditional formatting with dates
  182. Blank Sheet with Gridlines
  183. Calculating interest due on late loan payments
  184. Counting number of items excluding duplicates.
  185. Font is changing when editing a cell
  186. how to fix REF and VALUE with a circ ref with iteration
  187. iserror problem
  188. worksheet renames - specific
  189. sum last 3 numbers greater that 0 in a range
  190. Re: Help with an Excel formula please?
  191. Re: Help with an Excel formula please?
  192. Combining two non-contiguous lists into one for data validation, with one range being dynamic
  193. Weird behaviour when entering hyperlinks
  194. Keyboard shortcut to select a column?
  195. PivotTable - Filter Row
  196. How To Have A Cell Be Blank If...
  197. Re: convert CSV to XLS format using command
  198. Template Wizard w/ Data Tracking add-in
  199. Indirect
  200. Re: how to format cells -fill color
  201. Pivot table put multiple "Values" in one row but I want them in one column.
  202. Formulas Won't Run if I Open File from Explorer
  203. Excel 2007 - Pivot Tables Include Filtered / Hidden Values inSubtotal / Total
  204. Re: What does "" mean in an equation
  205. What does -- symbol mean in an excel formulae eg: SUMPRODUCT(--(A1:A10="Luke
  206. Re: what does ! mean in excel
  207. rows height
  208. Re: Code to delete rows based on value
  209. Re: Help please with cut paste and formulas
  210. Re: Help please with cut paste and formulas
  211. Help with last 7 days running total
  212. I need help please
  213. Re: If then formula with multiple cells
  214. Re: countif with some conditions
  215. Re: countif with some conditions
  216. Re: Greater Less or Equal
  217. Re: Greater Less or Equal
  218. Re: Greater Less or Equal
  219. Sumproduct, countif and format?
  220. Re: Create a new set of data from 2 data sets
  221. Re: Find Duplicate names listed in opposite order
  222. how to carry forward a total from one page to another
  223. Re: Remove border
  224. Re: How can count the number of cells that fulfill certain criteria in other cells
  225. Re: Data Lookup - Copy and Paste
  226. Re: Excel Saves Random .xlsm File Everytime I Save
  227. Re: Concatenate, currency & sum formula
  228. Re: Help with calculating time and a half - I've got straight time and double time.
  229. tiny discrepancies in fixed-point numbers
  230. How to create absolue path link to another workbook (Excel 2003)
  231. Excel Visual Basic to get current row number
  232. Excel Vlookup Help
  233. Automatically Enter Formula in a Cell After Entering Data in Another Cell
  234. Re: Help with drop down selection and populating related data...
  235. Re: Help with drop down selection and populating related data...
  236. Re: multiple scenerios in excel
  237. excel copy and paste...
  238. Yet More Excel VBA Help Please
  239. Re: Find date in excel string previous to last occurence of specific text
  240. More VBA Help please
  241. Re: Multiple worksheet summary
  242. Re: Multiple worksheet summary
  243. Excel VBA setting Ranges
  244. Re: Conditional Formatting
  245. Need to merge worksheets - Excel 2003
  246. Re: I need to cut characters off of a list of text cells...
  247. Re: "If" function and Upcoming Dates
  248. Re: Multiplying Values only less than 1.5
  249. Re: After Copy Past shows Error. (#VALUE!)
  250. CSV->Excel Data Problem
  251. Re: Are the parentheses the problem?
  252. Re: Are the parentheses the problem?
  253. Index/match across multiple columns?
  254. Re: Copy pair of columns
  255. Re:Copy pair of columns
  256. Re: use xlup and offset in a range of cells
  257. Re: Copy pair of columns
  258. Question about conditional formatting of zeros in Excel
  259. Re: Testing for hyperlink error
  260. Getting Text data using the Data - Subtotal feature
  261. Cannot remove empty rows
  262. Determine if night shift by start & end time
  263. Excel 2003 save as .XLSX
  264. Re: How create a Purchase Order Form that stores data?
  265. Re: How create a Purchase Order Form that stores data?
  266. Re: if cell is blank
  267. Compile Error help
  268. Re: Negative value to positive
  269. Re: Negative value to positive
  270. Problem Re Passwords, etc.
  271. How to invert Cols/Rows?
  272. Re: Help with Column to Row formatting
  273. Re: SUMIF evaluating blank DATE data
  274. Re: Advanced Sort/ look
  275. Spellchecker anomaly... Checks spelling on a Forms Button text label...?
  276. Re: Countifs with if and date range
  277. Re: Index/Match Lookup with a merged col
  278. Filtered drop down list
  279. Excel Stops Working
  280. Re: Spell Check Protected WORKBOOK
  281. Excel Stops Working
  282. Re: Change text color with an IF statement
  283. Re: the cells that some rows have in common
  284. Re: need to extract email addresses from excel files
  285. Re: a function that deletes all rows with no value in a certain column?
  286. Re: Ignoring specific number
  287. Re: Find & Replace problems... at the end of my thread (ha)
  288. Re: Need IF statement to categorize time into "Morning", "Afternoon", "Evening"
  289. Re: Count If Formula Not Working - Help!
  290. Drop Down Calendar in Excel with a Default Value
  291. Re: Trapped in a cell!
  292. Finding Text within an Array
  293. how to write a dependent validation with all numbers
  294. Paste embedded file corrupts?
  295. File extract error?!?
  296. Re: IF Statement Reading Zero's
  297. need help writing formulas.
  298. Speeding up Excel simulations
  299. Re: L2013 not running code from XL7, second posting
  300. Re: prevent deletion of a workbook in a shared network drive
  301. Re: IF statement help
  302. Re: Randomizer
  303. Re: Separting negative numbers from letters in cells
  304. Re: CountIf from multiple sheets in another workbook
  305. Re: if row has duplicates, concat entries in another column?
  306. Re: sumproduct with COUNTIF With An INDIRECT
  307. Re: Complicated Data Selection
  308. Formula Help
  309. Re: Count the number between range of cell for a particular person
  310. Re: Sum to a mid point in a dynamic table
  311. Re: Look UP and then caluclation with IS ERROR
  312. Re: Combining Duplicates
  313. Re: adding up checked boxes in cells in a row
  314. Re: Index and Match
  315. Re: need help in fine-tuning a formula that removes blank cells in a column range
  316. Re: Creating a Dropdown that is Related to the Value Given in Another Cell
  317. Re: Creating a Dropdown that is Related to the Value Given in Another Cell
  318. Converting billion to million
  319. Date Calculation - Astro Calculation
  320. Re: LookUP certain words and return back corresponding values
  321. Re: Formula help - Match & IF
  322. Re: Extract numeric values from an alphanumeric cell based on a criteria
  323. Re: How to count but exclude overlapping data
  324. Re: Excel.csv file problem
  325. Printing line numbers
  326. Re: Complex Timesheet
  327. Re: Highlighted
  328. Re: Highlighted
  329. Excel Copy & Paste Issue ??
  330. Re: Highlighted
  331. How to synchronize all cell values?
  332. Re: adding accross sheets
  333. Re: adding accross sheets
  334. data from multiple files: best way to extract
  335. Re: Formula fill series?
  336. Copy paste data from a column to a row
  337. HELP!! New to Excel. Need complex SUMIF.
  338. Re: Top 5 list if data meets a criteria
  339. Re: Complicated Look UP
  340. Re: Complicated Look UP
  341. Re: Complicated Look UP
  342. Re: Complicated Look UP
  343. Re: Number range as a percentage
  344. Re: Userrange to formula
  345. Re: Using Drop Down list to an If Statement to another Drop Down list
  346. Re: Removing Unwanted Data
  347. Re: Excel vba UserForm Lists not registering default values?
  348. Re: How to avergage colums
  349. Re: Improve speed of the routine
  350. Re: Colour Coding dates
  351. Re: Copy All Visible Cell Of Sheet1 To Sheet2 Last Blank Row
  352. Re: how to get the percentage symbol with the result?
  353. Re: Excel vba UserForm Lists not registering default values?
  354. Re: Excel vba UserForm Lists not registering default values?
  355. Re: Look UP formula for 2 and 3 conditions
  356. Re: how to make a sheet invisible?
  357. Re: Return values from one column IF a certain value in another column
  358. Anyone Has A Template For Aoristic Analysis?
  359. Re: how to get the percentage symbol with the result?
  360. Import Multiple CSV Files from Same Folder into Open Workbook
  361. Re: COMBIN
  362. Re: Matching data in columns
  363. "cannot shift objects off sheet" error
  364. Re: Using Excel VB, Update a specific cell, on any change of another specific cell
  365. Puzzling quotes around text
  366. Re: numerical value to text description
  367. Re: Possible to have multiple sheets refer to a master template sheet?
  368. Re: Convert multiple columns into a single row
  369. display '2+2' as '4' in a cell?
  370. Excel opening MSSynch in 2010? How to stop it?
  371. Re: countif on multiple criteria
  372. Re: Macro
  373. Re: how to select contents from a col which lies in between other columns
  374. Find values across a row and return a text value from the same column
  375. Re: How do I reference one OR another worksheet?
  376. Re: How do I reference one OR another worksheet?
  377. Re: Automatic printing by filter?
  378. Crazy Variance Formula
  379. summarizing data from various workbooks
  380. Assigning values
  381. Re: Excel equations
  382. Re: Multiple items selected multiple dependancies available
  383. Re: Excel equations
  384. Does Publisher 2013 have autoflow?
  385. Re: bullet point lists in Excel
  386. Axis formatting
  387. find -> list of records
  388. To Garry of GS Excel contribution fame
  389. Re: How to extract data from a spreadsheet into a form/create form from spreadsheet data
  390. Search OF Macros for a specific phrase
  391. check first 3 characters of a cell and compare to a table
  392. Re: how to convert grades into a value
  393. Re: how to convert grades into a value
  394. Currency autofit
  395. Re: Large Excel Email list with Non printing character
  396. How to use Sumifs with vertically and horizontally criterias
  397. Pulling a specific email from cells and putting info in new row
  398. Re: How Can I subtract from time within a 24 hour clock?
  399. Re: Cross referencing a weekly menu list with a grocery list
  400. If statement for a range of cells
  401. ="'"&F1&"'," Excel errors in one spreadsheet but not other one?
  402. Duplicates Deletion ?
  403. Changing Text To Numbers ?
  404. For Joey2004 et al. From OP: Re Appending Question
  405. Appending Text To Numbers ?
  406. Average problem
  407. Re: Countif to exclude blanks
  408. Re: Calculate horses age as at 1 August
  409. excel 365? develop offline?
  410. Re: Problem with user functions in Add-ins for multiple persons
  411. Some chart types cannot be combined...
  412. GETPIVOTDATA #REF! error XL2003/2010
  413. Re: Date Conditional Formatting
  414. Opening excel 2010 spreadsheet from Access
  415. Copying puzzle
  416. Unable to freeze panes
  417. Re: Dropdownlist and Vlookup
  418. U*nexplained ribbon change
  419. Re: Add image in forum
  420. Re: Permanently link formula references to Column Names and not Column Cell Numbers
  421. Re: Forgot Excel Password
  422. Re: Formula for percentage calculation
  423. Re: Add numbers if cell fill is a certain color; How To?
  424. Re: Conditional Format Entire Workbook
  425. Re: Add numbers if cell fill is a certain color; How To?
  426. Start sheet in a workbook
  427. Re: Excel on Iphone
  428. Re: Transpose
  429. Dynamic Excel data into locked Word form
  430. Copy rows to new sheet based on value in column A
  431. Re: Why cant I expand the equations parameters without error?
  432. Re: Subcategories in Drop Down List
  433. Trying to create a dynamic filepath within VB
  434. No tools manu?
  435. Unlink cells- how?
  436. Re: Averaging feet and inches (not decimal feet)
  437. Re: VBA not selecting worksheet with titles
  438. Cell not calculating after importing data
  439. Re: Delete certain text from cells
  440. Re: Using the If function for a date range
  441. Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons?
  442. Multi-demensional frequency distribution
  443. Copying data to the next blank row
  444. Re: How to Remove Excel Protection?
  445. Adding cells by 2 criteria that move.
  446. AUtofiltering dates
  447. Re: Import Images into cells from a file without using VBA or Macro. Can it be done ?
  448. Re: Excel Formula
  449. Hi, is there a way to access mouseover (hover) data in excel)?
  450. Re: sumproduct() function resulted in an error #DIV/0
  451. Re: How to read data from the workbook selectively?
  452. Formula help
  453. Re: Define a dynamic Print_Area
  454. Re: Dates
  455. Re: Dates
  456. Re: Dates
  457. Default font
  458. Re: Macro for saving file as cell ref
  459. PowerPivot How to chart with contiguous time axis?
  460. Question on the occupied field of the pivot table in excel spreadsheet
  461. Pivot Tables and Filter Criteria Display
  462. Re: Adding text to email body
  463. Re: Specific hours worked between two time intervals
  464. Formula Audit mode active in one column only; cannot kill.
  465. Re: how can I lock/unlock a range of cells depending on state of a checkbox?
  466. Re: Font options
  467. Tracking Access in Read-Only Files
  468. Tweaking VBA
  469. Re: Data Validation help
  470. vlookup
  471. For Claus From OP:
  472. To GS Re .csv Commas
  473. .csv Commas ?
  474. sum character
  475. File Name Chages ?
  476. Re: Formula- Count of items that meet a specific range criteria
  477. Re: Formula- Count of items that meet a specific range criteria
  478. Query of List Option
  479. Application.GetSaveAsFilename
  480. Duplicate Line by cell qty
  481. Re: number of months and days between two dates without approximation
  482. Re: filter result- total row numbers varies
  483. Re: Formulas
  484. Re: Formulas
  485. I'm loving Interse
  486. Re: Excel Shortcut Key
  487. Re: Excel 2007 - Sudden Disappearance of Character Spacing
  488. What is "--" in Excel Formula (SUMPRODUCT)
  489. Re: Drop Down Selection Assistance
  490. Re: Macro that sorts data with blanks at the bottom
  491. Re: VLookup using two criterias - looking for a efficient way
  492. Macro: finding a cell on one worksheet and copying to another worksheet
  493. Re: Look UP using 4 criterias
  494. Re: Multiple Regression - polynomial fit
  495. Move cells up
  496. Move cells up
  497. Re: Vlookup using two criteria -not working
  498. Re: Weighted Grades Worksheet
  499. Re: Weighted Grades Worksheet
  500. Re: how to add a letter to front of column sample ID
  501. Re: how to add a letter to front of column sample ID
  502. VBA : Class does not support automation error.
  503. Re: Function help: Reference cell based on another cell's value?
  504. Re: Function help: Reference cell based on another cell's value?
  505. Re: How to compare two work sheel cell by cell
  506. Simple Timer facility
  507. Re: New User: Copy Cell and Insert into Cell of Text.
  508. Printing Excel File Custom Properties in the Footer
  509. Re: if function
  510. Re: what does 6.9544E+23 stand for
  511. Re: if function
  512. Re: if function
  513. Re: multiple columns into one column and autofill(?) question
  514. Re: Macro adds "=" to each cell in defined range across multiple worksheets
  515. Re: Please Help
  516. Re: Having trouble with formula
  517. Re: Please Help
  518. Re: formula with text and rounding
  519. Re: XL 2003 very slow to Copy. XP SP3
  520. 3 variable 2 dimensional line graph
  521. retrieving values from a certain column
  522. Re: Bracers before text in a single cell
  523. Automatically join files
  524. Re: Find rows that contain capital letter?
  525. Re: Difference in Time hour what formula to use in excel?
  526. Re: Question regarding an auto-search facility
  527. Re: Question regarding an auto-search facility
  528. Re: Question regarding an auto-search facility
  529. Re: Compare a column of substring with another column of strings and get count
  530. Re: Complicated Look Up (without making changes to the blank spaces in the table)
  531. Re: Simple IF Statement Help!
  532. Re: how to get a warning when data is entered wrongly
  533. Re: Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) betweenentry time
  534. Re: the forumula bar is not visible
  535. Re: Complicated Vlookup and array
  536. Excell 2000 macro will not open file!
  537. Excel 2002, problem with Text to Columns
  538. formula question - weighted sales/distribution
  539. Re: I have an excel spreadsheet. I want to export each single rowsinto a new email on mi
  540. Re: Help matching combined text cells
  541. Re: Print Macro w/drop down list
  542. Running an app which requires quote defined parameters
  543. Re: Gridlines
  544. Re: Link data from Another cell
  545. Re: add multiple letters to the end of multiple cells
  546. Re: Gridlines
  547. Exchanging data
  548. % Difference between cells based on variable...
  549. Re: Remove Data which is not match with other column
  550. Re: Insert File name in Excel File
  551. Re: countif function
  552. Reading CSV with numbers in text format, Excel automatically convertsto scientific notation
  553. Re: VLOOKUP returning #N/A ??
  554. formula help... lookup or ref?
  555. freeze panes
  556. Re: Need Help Regarding Points of intersection in graph.
  557. Re: Extra help on Nth Day of month
  558. Re: Excel wont Paste Special wont paste formulas it says Unicode text
  559. Re: How to replace a constant from a cell containing date and time
  560. If statement with dates
  561. Re: Setting Range with a Loop
  562. Re: designing a macro
  563. Re: designing a macro
  564. Re: How to search specific list in different sheet
  565. Re: Project If Function
  566. Speech Recognition & Dictation in Excel: How to turn it on?
  567. Re: how do I search thru the values in my column and replace withnessesary values
  568. Remove colour change
  569. Edit File Information
  570. Spelling checker problem on a specific worksheet only
  571. expert needed...
  572. Re: How to count innings pitched?
  573. Convert HH:MM AM to HH:00 AM
  574. Re: Permutation/Combination/Pairs order unimportant.
  575. PowerPivot query
  576. Re: Auto populate from list on separate sheet
  577. Re: Auto populate from list on separate sheet
  578. Re: need help with excel
  579. place code where?
  580. Re: need help with excel
  581. Using Filter more than once
  582. Formula autofill to cells below formula arguments are cell areas in different columns
  583. separate questions and answers of a test
  584. from to 3 rows to 12 rows (please macro or formula)
  585. Re: Formula to change name format
  586. Re: Sort Marco won't work in 2010
  587. Re: How to calculate multiple conditions?
  588. Re: How to calculate multiple conditions?
  589. Re: Can you display entire rows that match a certain criteria...
  590. Populate row with work days
  591. Re: Sort Marco won't work in 2010
  592. Re: Sort Marco won't work in 2010
  593. Problem with Kill Syntax!
  594. Change all text on Spread sheet
  595. Need help deleting data
  596. Re: =IF function with current date
  597. Re: =IF function with current date
  598. Re: LEFT function not working with dates
  599. Re: LEFT function not working with dates
  600. Informal invite to "Excel Blackbelts"
  601. Need Help with VLOOKUP
  602. Re: Data Validation Query
  603. help on summing a random combination
  604. VLOOKUP returning #N/A result
  605. Re: Need to reorganize - transpose columns to rows per article number
  606. Re: V Look up with drop down functionality
  607. Re: Address fields in columns...
  608. Re: Problems with static dd/mm and rolling year
  609. Transpose, but how?
  610. Need to reorganize - transpose columns to rows per article number
  611. HELP - A formula or sheet you want to move or copy contains the name ....
  612. Number of work days between two dates entered into a user form text box
  613. Error message with nesting
  614. Re: V Look up with drop down functionality
  615. Re: Address fields in columns...
  616. Advance Macro help
  617. excel 2010 + copy array
  618. Re: adding small letter on top right of value
  619. Re: how to open PRN files in Excels?
  620. Re: Help with a Formula to turn various words into numbers
  621. Re: randomly picking up an array element from an array of elements
  622. Re: adding brackets to every cells without changing content
  623. Re: randomly picking up an array element from an array of elements
  624. Date format/value different when opening manually compare to VBA macro
  625. Re: Countifs formula
  626. Re: changing rows *and* columns in automatic formulae
  627. Re: Search for either one or the other
  628. Re: Summing across multiple columns
  629. Re: Search for either one or the other
  630. Re: Search for either one or the other
  631. Re: How do I stack data in Excel 2007?
  632. Re: Excel Invoice help
  633. Re: Excel Invoice help
  634. Re: Conditional Formatting in Excel 2003
  635. Total formula
  636. Re: Find Max value within a Offset
  637. Re: How do I insert a row without the formula changing?
  638. Re: Making inputs for average formula dynamic
  639. Re: Auto-populate spreadsheet based on database info?
  640. Re: Look up with multiple variables
  641. Re: Please Help! Can't solve excel problem
  642. Data Lookup Question
  643. Re: Rostering form: Adding New Lines to a table about a totals calculation.
  644. Re: Help! How do I ignore blanks cells in an array?
  645. Re: How to insert date continuosly onto sheets if the first sheet hadbeen put the date?
  646. Re: Help with a Formula to turn various words into numbers
  647. Re: Look Up with Multiple Conditions
  648. Re: How to insert date continuosly onto sheets if the first sheet hadbeen put the date?
  649. Re: Need help matching similar data...
  650. Help with this formula
  651. Help Writing a SUM Formula
  652. Excel 2007 Problem Paste/Enter Key
  653. Re: Conditional formatting disappears when cell contents deleted
  654. Re: Help Needed - Making Numbers
  655. Re: IF Function Question
  656. Formula Assistance
  657. Re: Comparing two columns with conditional formatting
  658. Re: Variations against one value
  659. Using 'indirect' function with full network path
  660. Re: Variations against one value
  661. Re: Worksheet name as a variable in VBA
  662. Re: trying to get data from rows to columns
  663. Re: Help with Look Up with multiple complex conditions
  664. Re: Rostering form: Adding New Lines to a table about a totals calculation.
  665. Re: Macro to add new sheet and then fill formula in a totals sheet to refernce this sheet
  666. Re: Calculation with a Blank or 0 Cell
  667. Re: Finding largest total of ANY two values in a data set
  668. Re: Conditional Formatting Dates Less Than 14 Years Ago
  669. Stacked graph
  670. Extending a selection
  671. Re: Sumif & Countif
  672. Move data from every other row to columns
  673. Sort by Every Other Row?
  674. how to strip an individual symbol from each row in a column
  675. Re: Auto populate monthly and quarterly data
  676. Re: Auto populate monthly and quarterly data
  677. Re: Macros and Email
  678. Re: Average with conditions
  679. Re: Separate Values
  680. Re: Separate Values
  681. Force zeros in Excel 2007 when cells blank and keep commas for thousands
  682. Matching records based on a common field
  683. Re: A way to extract info from multiple excel files, based on content?
  684. Re: A way to extract info from multiple excel files, based on content?
  685. Text to columns
  686. automating data across cells/sheets
  687. Format appears stuck..how to break formatting
  688. Re: Excel 2002 file is suddenly read-only?
  689. Re: Excel 2002 file is suddenly read-only?
  690. Help With Nested SumIf / Or
  691. Re: HOW-TO make a random selection from a set of data and divide itinto sub-team
  692. Re: Getting "N/A"
  693. Re: Colour cell yellow when there is not data entered
  694. Date and If problem
  695. formula to count text entries and return text with most entries
  696. Re: Multiple IF's ??
  697. Re: Dates and if statements
  698. Re: Duplicate with Criteria
  699. Re: input field linked to button to create a table
  700. "Unwrap" Excel list into table, to facilitate pivot
  701. Correct process for creating a linear trend line in Excel
  702. Re: Extracting specific info from cells
  703. Summarise data on multiple sheets
  704. Re: Extracting specific info from cells
  705. Re: CSV file conversion + True/False over multiple columns of data
  706. Re: Excel and date ranges
  707. Re: Need to have data in one column
  708. Tree from Parent/Child Pairs
  709. [HELP]CLOCK TIMER USING ECXEL
  710. Displaying time gaps
  711. Re: closet lookup
  712. Re: closet lookup
  713. Re: Calculating Work Time
  714. I can't copy and paste equations
  715. Re: SIMPLE DRAGGING issue
  716. Re: Populating cell with string not in workbook
  717. Max Length in a row
  718. Re: Saving Formulas in Excel
  719. Re: Making cells appear on screen but NOT print
  720. Re: printing on paper size of 10 inches X 12 inches
  721. FORMATTING CELLS
  722. Re: Making cells appear on screen but NOT print
  723. Conditional formatting
  724. Re: Excel Auto Sum
  725. Re: Dividing worksheet into multiple workbooks
  726. excel formula for markup and profit margin
  727. Re: Dividing worksheet into multiple workbooks
  728. Re: Avoiding display msg when saving a .xlsm file to .xlsx
  729. Re: Insert Rows Below
  730. Re: Insert Rows Below
  731. Need to highlight cells in special order
  732. Re: Insert Rows Below
  733. Re: Merge excel files with different column headings
  734. #VALUE error which disappears when I use F2, ENTER
  735. Re: Excel macro to copy the rightmost column to a new column
  736. Summarize the monthly recrods by name
  737. Example Spreadsheets
  738. convert time
  739. Re: Need Help copying part of an Excel Cell?
  740. Conditional Formatting assistance
  741. Why Not in a Single Cell
  742. Re: Restricting a Random Query?
  743. vlookup challenge with hyphen data placement
  744. Re: Linking Rows Between Sheets When Sorting
  745. Re: Title row
  746. How to do the following copying?
  747. Re: Auto fit text in linked cells of a protected worksheet
  748. best way to count something in one column using criteria in another column
  749. Re: CountIf Query
  750. Re: Add partial year to date