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