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