PDA

View Full Version : Excel Discussion (Misc queries)


Pages : 1 |  2 |  3 |  4 |  5 |  6 |  7 |  8 |  9 |  10 |  11 |  12 |  13 |  14 |  15 |  16 |  17 |  18 |  [19] 20 |  21 |  22 |  23 |  24 |  25 |  26 |  27 |  28 |  29 |  30 |  31 |  32 |  33 |  34 |  35 |  36 |  37 |  38 |  39 |  40 |  41 |  42 |  43 |  44 |  45 |  46 |  47 |  48 |  49 |  50 |  51 |  52 |  53 |  54 |  55 |  56 |  57 |  58 |  59 |  60 |  61 |  62 |  63 |  64 |  65 |  66 |  67 |  68 |  69 |  70 |  71 |  72 |  73 |  74 |  75 |  76 |  77 |  78 |  79 |  80 |  81 |  82 |  83 |  84 |  85 |  86 |  87 |  88 |  89 |  90 |  91 |  92 |  93 |  94 |  95 |  96 |  97 |  98 |  99 |  100 |  101 |  102 |  103 |  104 |  105 |  106 |  107 |  108 |  109 |  110 |  111 |  112 |  113 |  114 |  115 |  116 |  117 |  118 |  119 |  120 |  121 |  122 |  123 |  124 |  125 |  126 |  127 |  128 |  129 |  130 |  131 |  132 |  133 |  134 |  135 |  136 |  137 |  138 |  139 |  140 |  141 |  142 |  143 |  144 |  145 |  146 |  147 | 

  1. Inserting a picture into a cell
  2. Inserting a picture from file into a cell
  3. to create a formula by removing RC[number]
  4. Is it possible to use MS query to query the dta in same sheet
  5. Maximum value
  6. Indirect address
  7. Copy Data in excel 2003
  8. External web Data Multiple Sites
  9. Data Validation List: Text Size Query
  10. To run the formula from any active cell
  11. CREATE QUOTE NO
  12. eXCELL WORKBOOK
  13. count total dates for each month
  14. Pivot table sort order
  15. Identify Lowercase Letters in Cells Using Function
  16. How to save/move a personal workbook
  17. 當資料計數為0時,如何讓樞紐分析表 欄能呈現0
  18. Sorting by number of laps and completion time. Taking out DNF's.
  19. where can i find a weekly pay record that links into a wages book
  20. How to open new book (workbook) with other
  21. Equal column widths
  22. ROUNDING DOWN
  23. Financial Formulas
  24. Calculating Macro
  25. Can IF and VLOOKUP functions be inserted together?
  26. Forcing a line feed in the middle of a string
  27. EXcel 2007
  28. Omitting the whole number when formatting decimals
  29. Microsoft Accounting
  30. Excel Error Message
  31. exporting a macro
  32. Conditional Format Help...
  33. Copy file names
  34. COPYING THE ANSWERS TO NOTEPAD / WORD
  35. 2007 excel spreadsheet
  36. Trying to make a line graph that encomposses many worksheets
  37. timesheet
  38. Running Macros in a protected workbook
  39. macros deleting rows
  40. MACRO FUNCTION conflict with other macro's
  41. Disabling certain keys on keyboard
  42. Sum based on date in another cell
  43. Please Allow HTML CODE and Attachement
  44. conditional formatting in Excel 2007
  45. Macro deletion
  46. Set Hourglass On
  47. Not reduce fractions
  48. Excel 2007
  49. How best to...?
  50. Input a Value to Lookup the Data Series for a Chart
  51. Selecting series in a chart based on a range and manual inputs
  52. Formula in Macro
  53. have MS office 2000 installing 2007
  54. Formatting a number as accounting in a text reference.
  55. Don't show macro processing
  56. formula to add the highest value
  57. Formatting XML in Excel?
  58. Sumifs in Excel 2007 for only numerical values
  59. 1st, 5th, 10th, 15th Anniversary dates for employees base on Hire
  60. Pivot Tables & Excel 2007
  61. Copy Cells - using Variable
  62. Cells(r,c) or ???
  63. Vlook up nonblank in B:B and return in A columns
  64. How do I see the fill color on the screen?
  65. Re: Bring in cell format
  66. Bring in cell format
  67. Text and hyperlink in the same cell
  68. Sumproduct, single criteria identified within multiple in single c
  69. What am I doing wrong
  70. vlookup in reverse
  71. 2 Questions
  72. Copy and Paste Format in filtered rows
  73. How format number as text
  74. Not all pages printing in Excel 2007
  75. Re: Decision making tool for Excel
  76. Help with Formula
  77. How to set default calculation method in pivot tables?
  78. Forms in Excel
  79. hellllllp. (- multiple posts b/c of errors posting possibly)
  80. How to select text on multiple pages with MS Document Imaging
  81. Text box handles
  82. Check Boxes
  83. Pivot Tables
  84. Count down to a date
  85. maintain absolute reference when inserting rows
  86. Getting values from names by reference
  87. macro to change graph ranges?
  88. 'select table row'
  89. Opening old 2003 spreadsheet in 2007
  90. Validation; add items to named range
  91. Need a Formula please*
  92. Using a sub string in a COUNTIF
  93. Convert Ft'-In Fr" (5'-6 3/4") to Ft.dec (5.56)
  94. 2 Label Options - Forms Object vs Control Box Object
  95. Pulling partial data into a new worksheet
  96. Add cells using a diffrent column as the criteria
  97. How do I turn Compatibility checker off globally, at least tempora
  98. How do I password protect an excel workbook?
  99. I have Text in a Colunm but want to sort ...
  100. date
  101. Excel 2007 lock files don't go away on the server
  102. Please help me to find out number of column occured
  103. Themes
  104. Data in cell disappears, reappears by scrolling mouse over cell
  105. STOP Highlighting Multiple Cells
  106. Multiple responses for a column
  107. Disable Excel key tips
  108. to workout the formula from many column..
  109. Can I use "Harvey Balls" within excel?
  110. unicode entries
  111. Date format troubles
  112. Date Range Look up
  113. Creating 2 new Worksheets
  114. convert dd:hh:mm:ss to seconds
  115. #Name? Error help
  116. Please help to to derive a formula
  117. Custom Add Ins Follow Excel Program
  118. DataValidation Check in cell of excel
  119. pivot table chart
  120. Entering the time in a cell
  121. Day of the week and date
  122. Problem with "IF" in a range
  123. Insert Comment Options!
  124. How do I make read-only file
  125. ho do I set up a auto alert ,at the lowest number in a list of ch.
  126. Paste Link then Data Sort
  127. Headers & Footers _auto update info from a cell in the worksheet
  128. To show a messagebox
  129. sumif to work with times along a row
  130. Copying Hyperlinks by column
  131. prepare a Production Batch sheet from Datalist
  132. Exporting a Macro
  133. Automatically calculate the previous days total 'sales'
  134. Copying a form
  135. Need help with IF(AND function. Please help!!!
  136. how do i change the words from lower case to uppercase/capitals
  137. =IF function, reference problem to "text strings" in Data Validati
  138. Use variable in macro coding
  139. Change Server for Query
  140. Using variable for cell reference
  141. Excel 2007 auto fill help
  142. Conditional Formatting in Excel 2003 question
  143. VLOOKUP & IF used with > or <
  144. excel 2003 slow to load
  145. Excel 2007 save as pdf page size error
  146. 在同一EXCEL*汇入外部资料
  147. Recalculate 1 cell in a macro
  148. how to calculate variance and range
  149. How to separate x y data in 1 column to 2 colums of x and y data?
  150. Is there a function to perform this operation?
  151. File Bloat
  152. How do I convert a zip file to jpg(?) file?
  153. Using the tab key to move from cell to cell.
  154. Using Macro to Hide Rows with Certain Values
  155. Is it possible to split a full name to just the first (or last) name?
  156. sorting locked cells
  157. Can't update my workbook - Name bar shows as "[Group]"
  158. Different colors in a cell
  159. Locked cells
  160. Conditional formatting
  161. sum up combinations of numbers from list to get specific total
  162. "Alt ?" did weird things to my spreadsheet!
  163. how do I keep the top title row from being filtered
  164. Cell referencing
  165. can I change page layout in an entire existing Excel workbook?
  166. How do I change uppercase to lowercase without re-typing (Excel)
  167. Indent based on character length
  168. Format Question
  169. Spell Check Unlocked Cells Only
  170. Viewing data in a single column
  171. Need formula to extract a numeric value from a free-format text
  172. How do I bookmark an HTML page?
  173. Need simple formula to find one string in another
  174. My undo and redo functions are disabled, how do I get it back?
  175. hyperlinking from an Excel cell to a bookmark in Word
  176. Help with these formulas
  177. Enabling Auto-Complete on several worksheets?
  178. Is it possible to embed a PDF in an Excel document comment field
  179. Copy & paste range
  180. How come it say "Microsoft Excel cannot find any data to replace"?
  181. Security for excel worksheet
  182. How to specify order of moving to unlocked cells in a protected sh
  183. Potential Version Issue with Hlookup
  184. Make rows in a table more than one line
  185. Count number of time names appears
  186. how do I copy an Excel file created in XP to Vista on a new comput
  187. How to create a list from a table
  188. Mixed Data in column
  189. Date / month trouble
  190. Vlookup with a pick list for tables
  191. Dropdown lists and IF statements
  192. time entry-excel
  193. Formula for sliding scale calculations
  194. Creating a Complex Timesheet Record
  195. keeps converting text to date
  196. print problems
  197. Dynamic display
  198. How do I change a work book number. I always getting workbook 1
  199. Format of Cells Changing on thier own
  200. Create a Standard Footer
  201. Is there such a thing as a contains formula
  202. How to import xml into a format for quizzes?
  203. Graduated dial face
  204. Sorting Tied Teams in League Table by Matches Between Themselves
  205. Count if criteria is not equal to
  206. Collecting data from multiple files
  207. How do I calculate variance percetage if figures are negative
  208. Find and Replace with wild cards
  209. select file from which to extract specific data
  210. Values not showing in either cell or formula bar
  211. The size chestnut.
  212. stdole32.tlb appears when I start excel
  213. I can't get NETWORKDAYS formula to work, it returns #NAME?
  214. Calculating with 2 different formats
  215. how to use pivot data in formula or fuctions?
  216. Using MS Query in Excel 2007
  217. Scrolling on Print Preview
  218. Kombinations boks (Active-x object)
  219. Need a help display 0 value
  220. need help with a lookup and count and if statemnt
  221. copy and paste the cell with formula ="1"
  222. I need help with 2 Questions
  223. question deleted
  224. Need a format for team vs team
  225. Conditional Formatting - Reference to multiple column
  226. Not all buttons are active on Developer Tab
  227. RE: Insert row on multiple sheets
  228. Excel in Office 2000 Premium
  229. Multuiple Lookup Tables
  230. Conditional Format - Copy a cell instead of "true"
  231. Count Non-Blank Cells in Column If a Reference Criteria Met.
  232. Insert row on multiple sheets
  233. add a warning before running a macro
  234. Time formatting in Excel 2003
  235. Decision making tool for Excel
  236. Sort by number only in cell
  237. text lines to rows & columns
  238. Date stamping a cell change
  239. XLSX files not opening on Terminal Server
  240. remove square at end of data
  241. Multiple cell selection on one click!
  242. Allowing row deletion in worksheet with locked cells
  243. Excel 2000 and date math
  244. Populate Data Into Different Areas
  245. Deleting multiple columns in excel that are not in a row
  246. Problem Opening CSV Files from Web Links
  247. Attach Word document to a text box in Excel
  248. Can mulitple Excel workbooks be summarized into 1 workbook?
  249. Mail Merge Formating Issues
  250. cells linked from worksheet to worksheet
  251. Formula Question
  252. Excel reports to show different customers on each tab
  253. Dollar signs on all tabs
  254. Pasting Cells in Excel - Not copying all content
  255. getting cells to show on print preview & print out
  256. Count if with multiple criteria
  257. Desperately need help with a formula
  258. LOST FILE
  259. Trouble With Text Input
  260. Date range within a date range
  261. LOOKUP?
  262. Excel: remove cell content but retain formula
  263. Help with this formula
  264. Pdf Printing through Primo pdf
  265. Cell searching and delete function
  266. Excel file opens into a blue screen with no infomation
  267. Group Function Works Sporadically
  268. Arguments
  269. Countif and Vlookup in a single formula
  270. Syntax error in nested IF statement.
  271. Pivot Table loses formatting after refresh?
  272. Insert Picture into a cell
  273. After Windows update scheduled task uses wrong version of Excel
  274. how display 12/3 as fraction?
  275. Conditional Formatting - Formulas with IconSets
  276. countif and Vlookup
  277. Random numbers but with a bias
  278. Freezing calculation
  279. start date + net workdays = end date
  280. Insert/ Delete rows of a protected worksheet.
  281. Skew Question
  282. Working with Lists (Now Tables) in Excel 2007
  283. Excel 2000 Data Valadation, VLookUp, NameRange, with multiple crit
  284. Prevent multiple instances in Excel 2007
  285. Rounding cell totals
  286. Converting a number to a text (character)
  287. Excel file keeps locking - Strange problem
  288. conditional formatting excel 2007
  289. LOOKUP FORMULA - USING THRESHOLDS - HELP
  290. Gridlines
  291. Default Value Field Settings for Pivot Tables
  292. excel wants to replace what i type with the word "back".
  293. Conditional Formatting?
  294. numbers displayed wrong
  295. Save File at specific Time
  296. Attach Word document to a text box in Excel
  297. Searching Uppercase characters
  298. file is locked by other user
  299. Copy paste between workbooks yields Value only
  300. consolidate workbooks to worksheets in one workbook?
  301. Sheet Count & Insert NewRow
  302. Merge /Update Macro
  303. Auto Sum equivalent for Subtract / Multiply / Divide
  304. Review of Grand Theft Auto: Chinatown Wars for DS
  305. Sumif with not criterion
  306. Text Boxes in Shared Workbooks
  307. Barcode suffix ean128
  308. To find rate of each item from item.xls and to copy price.xls
  309. Negative Conditional Formatting Excel 2003
  310. can we map calender in to excel worksheet's cell.
  311. Can Excel do this or do I need a different program?
  312. how to make a default font for a precise row
  313. Excel formula
  314. RE: Not More Than or Maximum in a formula
  315. Fill Series for Lookup
  316. Copying down formatting
  317. HOW TO COUNT INSIDE A CELL
  318. Paste cell to last row in range
  319. Using Excel for Decision Making
  320. Turning Off an Advanced Filter
  321. SUMIF by Week.
  322. Vlookup I think
  323. Hyperlink w/ vlookup
  324. 'Enter' key is pasting...
  325. How to enable marco/vba editor?
  326. Shading row based on value in one of its columns
  327. Limit using pivot table with Access database?
  328. How to use a range of time to assign a score?
  329. HOW DO I INSERT 1 SPACE BEFORE A TELEPHONE NUMBER IN EXCEL SPREAD
  330. Vlookups don't recognize text to column cells - why?
  331. Paste Value Formula
  332. Links to folders used to store web pages
  333. how do i change to a bar code font in excel 2007
  334. Cells change color when another cell is activated or typed with an
  335. Conditional Formatting
  336. formula question
  337. link to calendar
  338. Need help with formatting / saving before I email my worksheet
  339. Scroll Lock stuck on
  340. Why is my question being repeatedly deleted?
  341. Why is my question being repeatedly deleted?
  342. Attach Word document to a text box in Excel
  343. Saving Excel 2007 file in 2003 creates very large file
  344. Copy & Paste Special Operations
  345. Why won't Excel open xls file after I saved it with notepad!
  346. sumif
  347. Formula Help Please
  348. IF statement syntax
  349. Looking for a formula to perform this additions
  350. Formula too large
  351. File Disappeared
  352. Pivot Table - Show difference
  353. taking the file extension out of the file name
  354. Display HTML
  355. Can I search for the displayed value in a cell, not the contents?
  356. Opening files in separate windows
  357. to write a formula to findout itemcode,discount from another works
  358. Emailing Linked Excel Files
  359. Unwanted Color Fill When Emailing
  360. accumulate time file is open
  361. Finding row, then copy paste (macro)
  362. A specific date used for calculation of a new date
  363. Match Cells expanded
  364. How to create a formula with multiple (IF) conditions
  365. Match cells
  366. type on one sheet automatically apear also on another sheet
  367. plotting line graph with 2 x values
  368. Macros & "Convert to Number"
  369. How do I use "sumif" for cells ">0" across multiple ranges?
  370. automatic scroll, how do I disable it?
  371. creating an new excel document (2002) to work out dates
  372. Vertical page breaks won't drag in Page Break Preview
  373. fig from excel not correct decimal place when merged. In word
  374. Change cell colour
  375. Automatic date entry
  376. Pivot Table - show all row fields
  377. Urgent: Excel 2003 - 2007 conflict!
  378. Using autofill in Excel 2007
  379. Numbering in blocks on 5
  380. add symbols to autocrrect in excel 2007
  381. Pivot table data need to show zero even no data under column
  382. Get excel to automatically go to the next cell w/o pressing enter
  383. Excel Cell Height - white space
  384. Count formula
  385. sumproduct with criteria and multiply problem
  386. Why must I configure excel with every use
  387. Help with Dual Conditional issue (sumif?)
  388. track and find crews or inventory
  389. A slightly complicated finance problem
  390. setting excel formula from code
  391. Conditional Formatting
  392. How can I update 2 or 3 duplicate workbooks in separate folders?
  393. Formula Help
  394. How do I set more then 3 Condition for a cell?
  395. randomize a list
  396. RE: How do I remove new line characters from a cell?(cathyc)
  397. How do I remove new line characters from a cell?
  398. 12 MONTH INCOME PROJECTION sheet template?
  399. in excel when i hit return, the cursor does not drop down 1 cell
  400. How can we scale Excel or Word to print and fit on 1 page?
  401. instead of using strikethrough, can you type a word
  402. Go to this section of a workshee if M2="Y" go to O2-U2 if "N" go t
  403. how can i automatically generate work order numbers from work orde
  404. Merging cell data into a document?
  405. conditional value in a cell
  406. Why does my 100% Normal Page view not match Print Preview?
  407. How to Alphebetize one column, but keep next column together with
  408. XL2007 crash using MS Query in vista 64
  409. Toolbar not working correctly in IE after loading Excel doc in bro
  410. Some comments stay hidden even after picking show/hide all why?
  411. looking for scheduling examples
  412. Date plus month, year, or years in workdays
  413. hyperlink
  414. Windows Mobile 6.1 Pocket Excel & Macros / VBA
  415. Combine text functions
  416. Freeze Panes?
  417. trying to find last row
  418. auto scale print area
  419. How to set up a worksheet to open where the next text should go?
  420. conditional formatting many rows
  421. How do I calculate standard error in excel?
  422. Crack excel passwords
  423. Change color of answer
  424. Need help for a formula
  425. Pivot Table
  426. SUMIFS using an "Or" condition?
  427. Display Issues
  428. Convert date to age
  429. conversion liter to kg
  430. I want to rename my worksheet tabs...
  431. Excel 2007 Crash Due to Linked File
  432. conversion liter to kilogram
  433. Concatenate problem
  434. Amend Formula
  435. Cannot See Sort Ascending/Descding option in drop down filter
  436. Multiple files open when starting Excel
  437. Excel file gets corrupt if saved in one particular drive
  438. Excel spreadsheet bunching up when filter
  439. Using LARGE function in incontiguous cells
  440. resizing calendar in excell 2003.
  441. If statement for alpha numeric combo AND numeric only
  442. I auto create a backup for each Word doc. How can I in Excel?
  443. OPENING AND CLOSING OF EXCEL 07 FILES
  444. Color parts of a chart
  445. Formula Help
  446. Excel formula Help
  447. When I save a workbook(2007) w/ a data connection to htm no data?
  448. Insert Large Arrow with Text
  449. Place shape/clipart over radio button
  450. Entering an "IF" formula
  451. Help with Cell Formula
  452. how to convert project management file to acrobat
  453. Help with Cell Formula
  454. excel previous weekday function
  455. excel weekday function
  456. Need to Insert Page Number Watermark in Excel 2007
  457. Sumproduct - Date Range
  458. Sumproduct - Date Range
  459. auto hide blank rows
  460. How do I copy first consonant from a word into new cell
  461. I need to have a record number change for every record
  462. Re: setting up excel to insert time of day
  463. Cursor movement
  464. formula to insert time of day in excel cell
  465. use of drag-fill handle in a crosstab
  466. how do I tell Excel to apply cell styles automatically
  467. hw can i total a sum of hours and minuts ans secnds with the time
  468. use of drag-fill handle in a crosstab
  469. Copy an array of Sheets
  470. Quattro Pro Conversion
  471. Can't download Excel templates using Vista Home Premium
  472. Can't download Excel templates using Vista Home Premium
  473. Can't download Excel templates using Vista Home Premium
  474. compare data from different worksheets and return matching results
  475. seksi djevojka
  476. seksi djevojka
  477. Let User Select Sheet to Pull Data From
  478. how do I insert a single quote on every cell in a column to make .
  479. seksi djevojka
  480. seksi djevojka
  481. Excel Formatting Problem
  482. Help with a pop-up msg
  483. Sumif ">today()"
  484. Link text between different worksheets within a workbook
  485. Named range/cell, sort & delete
  486. Import large number string
  487. Vlookup causes Excel to shut down
  488. sumif? array enter?
  489. Help! Names defined in Excel 2003 invalid in Excel 2007
  490. Subtotal of Pivot "Max" calculation problem
  491. Text Box Issue
  492. Select a list in 1 cell by selecting an item from another list in
  493. Problem (bug?) in the way Excel 2007 doesn't automatically load ma
  494. Locked worksheet & hyperlinks (w/ select locked cells unchecked)
  495. Average function
  496. Auto Fill Help
  497. Need formula help
  498. Help: Print settings removed between users!
  499. Countif based of partial cell contents
  500. Functions - Difference b/w two dates
  501. MS Query 2000 on dates with parameters
  502. Percentage
  503. UNABLE TO OPEN .CHM HELP FILE
  504. Convert Text in cell to hh:mm:ss
  505. Calculating STDEV for non zeroes
  506. Conditional extract from database
  507. Auto filling dates
  508. Converting an old Quattro Pro .wb2 to Excel 2007
  509. Pattern colors
  510. Linking worksheets - Specific Information
  511. including entire worksheet sort in a macro
  512. how do I shade alternating rows in spreadsheet
  513. Formula for Growth %
  514. Compare multiple cells and highlight differences
  515. Formulas in Pivot Table
  516. Transferring/Merging Data Between Worksheets
  517. how to replace an unrecognised character
  518. Change Case
  519. Selecting cells highlight
  520. Conditional Formatting a Report based on a query
  521. Deleting Macro Short Cuts
  522. Create New Table Styles
  523. Update total based on two columns
  524. Sorting in Tables
  525. Paste Link problems
  526. How to copy 2007 excel file formula results into a 2003 Excel file
  527. Lock Cell Borders
  528. How to interchange the values between two selected cells?
  529. Direct to sheet
  530. conditional formatting
  531. Copying a formula from original cell to mutilpe cells?
  532. How to use hyperlink to chart?
  533. How do I re - build border of my cell?
  534. Border
  535. Help to create biweekly dates excluding nonworking days
  536. Sum IF ?
  537. break column
  538. How do I get excel to open with cursor in same cell as when close
  539. DATE RANGE FORMULA
  540. XL 07 Data : Text to Columns
  541. New Excel 2007 user
  542. IF OR statement help
  543. Automation error '-2147417848 (80010108)' excel 2007
  544. recovering an unsaved file
  545. Find Feature
  546. VLOOKUP Error
  547. Skipping Rows with cursor
  548. IF STATEMENT HELP
  549. How do I turn off random multiple cell selection in Excel?
  550. Determining availability time
  551. Conditional Sum Formula needed
  552. add every other cell from another worksheet
  553. linking worksheets with hyperlinks
  554. Average Summary Not Working
  555. transfering data between sheets
  556. Excel 2002 : Any fast way of converting positive to negative numbe
  557. How to insert row on Col A field change
  558. Workshee LLinks
  559. Finding Duplicates in Multiple Columns
  560. Paste cells copied from another sheet
  561. Auto Cell Sorting from WS to WS
  562. delete characters at the end
  563. How to change a sum to an actual number I can paste into a new do.
  564. Excel 2007 - Email Option
  565. Match data duplicates
  566. How to find the first Word in a range ?
  567. EXCEL MACRO 2007
  568. Printing problems in Excel 2007
  569. Pictures and/or Graphs in Print Preview not Printing in Excel and
  570. More than 3 criteria in Conditional Formatting
  571. Adding items to a combo box on a user form
  572. Multiple Style in Excel 2003
  573. Find data not hi-lited
  574. hiding formula in cell
  575. Refresh Pivot table data in Protected sheet
  576. formula to calculate the number
  577. formula to calculate the number of people
  578. pdf file
  579. when I try to change office assistant I get "not enough memory...
  580. splitting data from one column into two
  581. merging text from two cells
  582. sorting text & numbers
  583. changing capslock letters into normal letters
  584. security for tabs
  585. If cell = now – current Qtr – 28 days then RED
  586. Excel Size ?
  587. COUNT A YES STATEMENT AGAINST A NAME
  588. Import External Data not picking up letters
  589. Deselect B1 & move curser to select A1
  590. How to transfer "text" into "date"?
  591. Is there a way to continuos sort data ?
  592. How can I find loan manager in MS Excel 2008?
  593. How to find the latest date?
  594. Data Entry Form
  595. How many number digits can I fit into one cell?
  596. Merging Worksheets via command button
  597. Refresh Pivot table data in protect sheet
  598. [Excel 2003] File size equal to zero
  599. LOOKUP OR MATCH QUESTION PLEASE
  600. how to set reminder?
  601. Excel formula help
  602. erratic response while working on a table in excel linked to a tab
  603. erratic response while working on a table in excel linked to a tab
  604. mutliply a worksheet by a constant
  605. Embedding an Excel 2007 worksheet into an email without attaching
  606. Hypertext link
  607. How do I print worksheet columns that aren't visible in preview?
  608. Hyperlinks
  609. improve clarity of excel data linked in PowerPoint
  610. Hiding amounts that equal 0
  611. Unable to sort "words" that are numbers and letters
  612. Data Validation
  613. how to put my own pictures onto toolbar buttons in excel 2007
  614. Hiding Header Columns abc... in 2007
  615. Excel: Format empty date cells
  616. Text into Numeric values?
  617. Cells
  618. Replacing using a wildcard
  619. Add days, excluding Sunday's and Holiday's
  620. vlookup help
  621. Dynamic Protected Range?
  622. Trying to develop equation
  623. show geographic locations on excel sheet
  624. Is there a function to round down in Excel?
  625. Copying Worksheet changes page alignment?
  626. Can you use math functions as arguments in a subtotal formula?
  627. Can Comments be printed in a spreadsheet?
  628. Pivot table and chart refresh not an option
  629. Page break issues
  630. Recent Documents
  631. Can you export comments?
  632. How do I stop the copyright symb from displaying when I type (C)
  633. Legend overlaps the plot data area in Excel 2007
  634. Pivot table column limits
  635. Pivot tables in excel
  636. Advanced IF Formula help needed
  637. mail merge not working
  638. Which formula is this" {sum()*()*()}"
  639. Sorting
  640. Average only if all cells filled
  641. Vlookup and sum
  642. outlook/excel
  643. EXCEL MACRO
  644. Add comma in last name first name
  645. unable to set the values property of the series class
  646. subscript
  647. if statement in formula
  648. Memos or Comments in Excel
  649. Menu Behavior
  650. Menu which appears when you right mouse click in excel sheet
  651. Show/Hide
  652. Pivot Table Editing or formulas
  653. Pivot tables - calculations based on different sets of data
  654. Trying to create formula...
  655. can't send form as e-mail
  656. how do I edit the content of a drop-down menu in excel?
  657. select a single cell in excel 07, currently selecting a goup
  658. If formula control conditional formatting
  659. My Recent Documents
  660. Why cant I exclude items with no data from the Page Field?
  661. EZ?- Trying to insert a simple formula using VB
  662. Count the Number of Weekdays by Month
  663. Excel Dropdown menu
  664. Sumproduct - several sheets ... indirect?
  665. advise calculation is complete
  666. Error Message
  667. Sheet becomes a hyperlink when protected
  668. how do i use excel to calculate weight (as in stone and lbs)?
  669. Close User Form
  670. Count macro
  671. Lock Drop down Menu
  672. CELL FORMULAS
  673. Solver doesn't seem to react
  674. Macro to create a Weekly Workbook
  675. new cells in excel default to locked?
  676. Internal cell margins (Excel 2003)
  677. Setting column width to specific row in Excel doc ??? Thanks!
  678. Divide by zero error
  679. How do I create a formula that gives number records with certain d
  680. Function to display details?
  681. multiple drop down menu
  682. How to keep UserForm open at all times while excel is running
  683. Merge excel files
  684. Round up an average
  685. Count total balance using two numbers
  686. How do I merge duplicated data in rows with different criteria
  687. Drop-Down Menu
  688. WK4 files
  689. conditionally formatting cells based on other cells
  690. Get the row count of different areas in the Excel
  691. Saving email attachments
  692. Macro to Close a specific workbook.
  693. Charting from Multiple Excel Files
  694. saving data?
  695. Macro saved .xls file is not opening in 2007
  696. IF formula
  697. SUMPRODUCT with 3 criteria
  698. Adjusting formula for month in vlookup?
  699. Pivot Table Calculations
  700. how do I get a top 25 on a pivot table in excel 2007
  701. How do I use Bin for data analysis?
  702. How do I freeze/ unfreeze a window pane in Excel 2007?
  703. MATCH A NUMBER IN A COLUMN WITH A COLUMN IN A DIFFERENT SHEET
  704. crazy format/formula
  705. why do I see " too many formats" message in Excel 2007
  706. Alpha sorting (with a twist...?)
  707. I want to change the page order so that page 3 and 4 become 1and2
  708. Pivot Data and Filter on separate sheets
  709. Lookup Ranges
  710. My spreadsheet in some cases automatically adds a row below how?
  711. Import Data, using a command line switch
  712. Unshared workbooks yet multiple people able to open
  713. keep variable value after code quits
  714. concatenate 2 columns (A2+B2) and compare for duplicates
  715. Nested if then else statement
  716. can you split and freeze simultaneously in the same excel document
  717. "paste picture link" behaving strangely
  718. #Value! error in cell
  719. Too Many differnt Cell Formats in excel sheet
  720. Too Many differnt Cell Formats in excel sheet
  721. how do I set up the openning type of file
  722. converting working hours to days
  723. Printing Charts Excel 2003/2007 - Rendering Problems
  724. Formula Help
  725. Formula quandary?
  726. Office 2007 Trial
  727. Clear Checkbox
  728. Unticking a Checkbox
  729. help with option lists - also, this qstion is supposedly not posti
  730. I need an option list for a table...
  731. i need an option list
  732. Vlookup - return exact phrase
  733. Pivot Table loses Data Connection
  734. Formula help please
  735. Converting number into proper date format
  736. AB or BA
  737. Date format plus calc
  738. formatting numbers
  739. Changing a cell value from another cell.
  740. Conditional Formatting
  741. lookup options
  742. Count same text from different rows
  743. Why will Excel not apply a theme
  744. Find Last cell in Range when range is date format
  745. Excel 2003
  746. Disable save on read only??
  747. Paste Graphs as Pics with 2003 in a VBE
  748. Returning to original view.
  749. Conditional Formatting??
  750. Copying subtotals Only
  751. I want a macro to run anywhere on a spreadsheet, based on cursor
  752. diagram i excel
  753. diable macro if a certain sheet is active
  754. auditor tickmarks
  755. I want to create a savings cash flow according to what I spend/sav
  756. Histograms with Cells and Curve Fitting
  757. drop down's
  758. spreadsheet disappeared
  759. Two sheets into one remapped? How to do it.
  760. a simple 'sum' formula is not adding all of the data in range
  761. Help please - not sure
  762. Troubleshooting 100% Stacked Bar Chart
  763. Compare worksheets
  764. Auto-Format Cell Shading
  765. conditional formatting
  766. Need the grand total pivot table filtered worksheet?
  767. problem with run-time error'424'
  768. Rows
  769. MAX function
  770. data type inconsistency
  771. how do I find my previous posts?
  772. problem filling in blank cells with data above -
  773. Strip away leading zeros
  774. Lock Cells Dependent on Prior Months
  775. Problem!
  776. Re: Analysis Add-on for Office 2003--How Load?
  777. How do I do a "mail merge" from excel to excel?
  778. Create a relative column formula
  779. SUM with multiple + and -
  780. Can't access Advanced Document Properties
  781. Conditional calculated field in pivot table?
  782. Formula Based on Table of Data
  783. to many formate
  784. Referrences of multiple cells from one worksheet to another
  785. Display state abbreviation from full name
  786. Auto adding a macro when Excel 2003 opens
  787. IF formula to conditionally format a cell
  788. If formula to conditonally format a cell
  789. File opens blank - but it's not blank
  790. Sort by last two characters, not the first.
  791. Subtotals and filters
  792. Extract from one sheet to another
  793. Clearing Contents
  794. Macros
  795. VLOOKUP with multiple lookup_value's
  796. Match function
  797. Pivot table data source
  798. If statement
  799. How can I higlight and clear contents but not formulas
  800. Minimum non-zero value
  801. Data Sort
  802. display a complete list of tasks by selecting on a task
  803. ALT+ENTER has stopped working in Excel
  804. general ledger
  805. When I hit 'enter' on a formula, nothing happens.
  806. Use commas as decimal separator
  807. =Text
  808. Searching from bottom to top with MATCH?
  809. Visual Basic: Get row count of a sheet in Excel
  810. What does "~" do to the data in a cell?
  811. Text to Formula
  812. How do i create a pivort table in excel
  813. solving nested IF statements
  814. Create an Invoice from a row of data
  815. SUM a range dependent on dates
  816. conditional minimum formula
  817. Excel 2003 VBA Macro
  818. Saving to different format without renaming workpage?
  819. Macro adjustment
  820. how can i change the colour of cursor only
  821. Linking to panes by changing value in a cell - is it possible?
  822. Pivot Refresh Error when calling Excel Macro from VB.NET program
  823. Sorting
  824. naming a column
  825. Formula help
  826. Formula Help
  827. Hold conditional formatting when sorting filtered data
  828. date range
  829. in spreadsheets copying cell contents plus font colour
  830. cell references in vba
  831. Subtotal by Date and Summary in Lists?
  832. sort a table without including titles which r on each page
  833. min if
  834. Conflict between Excel and Outlook
  835. Error message when attempting to set up an Excel workspace
  836. Trying to make both averages AND sums of one spreadsheet of data
  837. Best Way to Pull Data from Other Sheets
  838. Click Option Button 2x in a Row
  839. Copy & paste to protected sheet
  840. Insert letter in cell
  841. .xls file is not opening in excel 2007
  842. How to create a list of permutations and combinations?
  843. Delete rows
  844. Retriving text from a column
  845. UDF in module of personal.xls
  846. How to Substract a word from right side of the column using Right(
  847. sumproduct - <>
  848. Enlarge objects in excel
  849. Template NFL Season for a office pool
  850. array formula
  851. Use Formula to Replace A Cell
  852. Any Way to Use Vlookup in Reverse?
  853. Combo Box - How to Use Output in Vlookup
  854. Chart avisor
  855. Insert, Delete row and cell
  856. How to get a drop down menu to return another value
  857. Use macro to write formula
  858. Autoformat/Conditional Format of entered Number
  859. Excel 2007 workbook reference
  860. how can i find a value in a range?
  861. sum a range based on current financial year and client id
  862. Refreshing Pivot Table on a protected spreadsheet tab
  863. Q about sheet protection
  864. combining two sets of data
  865. Macro Fill Cells With Formula; Conditional To Seperate Column
  866. What's the vba code equivalent for Countif
  867. flash object dont work in my excel work sheet
  868. Guidelines for posting questions?
  869. Still more on loading a .CSV into a .XSLS
  870. link between cells
  871. How do you apply criteria in order of preference?
  872. copy formulas over merged cells
  873. Is there a formula that will return only the month from a date?
  874. Sorting rows of data of varying lengths
  875. how to zoom into excel line chart with about 2000 point tia sal22
  876. Can't Stop the clock
  877. copy from excell to word without grid
  878. copy excel 2007 to word 2007
  879. How do I abbreviate a year?
  880. How to create percentages for the combined rows?
  881. Random number macro
  882. cell address changes
  883. Macro in Hyperlink
  884. How can I fill a block of 300 cells with non-repeating random #s
  885. Dynamic Range Within INDEX
  886. Formula
  887. column to show certain percent positive AND negative
  888. Excel: Arrow keys scroll instead of moving to next cell??!!
  889. Totalling number of text entries on a worksheet
  890. formula
  891. color after depending on 1st value in a cell
  892. Merging Lines of data
  893. Tabbing within a cell
  894. can I create outlook reminders from worksheet data?
  895. View set to 'best fit' for User
  896. cell border problems in 2007
  897. I want to create an "average color" formula.
  898. Auto Refresh
  899. Lookup ?
  900. Conditional Formating
  901. Code problem
  902. Cell name to change name in codes of command buttons
  903. VLook Up Error
  904. End of document
  905. VLookup - Choose Which Occurence of Lookup value to bring back
  906. Vlookup
  907. Delete rows based on multiple criteria
  908. excel 2003
  909. sum up two result in one column
  910. VB help required
  911. writing coloured text with formulas
  912. Combo box
  913. How to shift a weekend date to the last or next workday
  914. Can't make excel do what i want...
  915. clock on user form
  916. Opening Office 2003 excel file in Office Excel 2007
  917. How do I add digits to all numbers in a column?
  918. protection
  919. combine rows and sum data with the same id
  920. ALPHA/NUMERICAL SORT
  921. getting rid of the "confirm delete" dialogue box when deleting a s
  922. formulas
  923. Convert to Values
  924. how do I select every third cell in a row in excel?
  925. MULTIPLE IF STATEMENTS PULLING DATA FROM MORE THAN ONE COLUMN
  926. formula to calculate sum of payment increased by 3% annually
  927. Text turns into date - how to stop?
  928. default page breaks in Excel 2007
  929. IF and THEN statements
  930. Excel 2007 - display negative numbers with minus sign and parenthe
  931. Re: Show only rows with duplicate values in a column?
  932. page names in a workbook
  933. IF/VLOOKUP with #N/A results
  934. RE: Need help w/ MS 2007 Excel/PowerPoint chart
  935. is 0.000000000000000055511151231258=0 in excell?
  936. very large WB-what can I do to find a specific tab w/o scrolling?
  937. checking the absolute value of a number
  938. Subtotals headings
  939. Finding Duplicate Rows (Macro)
  940. Check for Non Blank and Blank Cells Before Save
  941. Excel 2002: How to insert an Auto Fit Width button at the tool bar
  942. Locking Cells
  943. Date Formula for number of days between a date and today
  944. Musical Chairs using Excel.?
  945. Canadian GST Expense Report Templates
  946. Chart Number Decimal Places
  947. Formula or calculation for discount
  948. Only allow cell content if it lready exists
  949. Named Formula Not Always Calculating
  950. Excel change a group of positive numbers to negitive numbers
  951. Re: Format Number
  952. importing a poster created in Excel into Publisher
  953. how to make ........ even after a title in a cell?
  954. Change selected cell shading colour
  955. Postcode structure for data validation
  956. Copying formulas between different versions into Excel 2007
  957. borders between 2 specific words
  958. Best practice for managing updates w/in distrubted workbooks?
  959. Radio Buttons - Values
  960. Return Just the Unique Entries From a Range of Cells
  961. Print Area
  962. Re: Excel hyperlink loses its path on save (2)
  963. cell selection code
  964. Count yes against name
  965. How to use debugger
  966. Horizontal Data to Vertical Data
  967. Pivot Table - Hide (blank)
  968. option not avaliable
  969. "is not a valid Win32 application"
  970. How do I stop entry in one cell if another cell is occupied??
  971. How do I move and size a picture with a cell but keep the aspect r
  972. How to make db file in excel 2007
  973. Gratitude
  974. Annoying Paste Bug (Excel 2003)
  975. Ensuring Correct Vin Number is entered
  976. Working with times as conditions in formulas
  977. Sumproduct or VlookUp
  978. Get value at end of a row
  979. Excel Crashes on Start Up
  980. Synchronize option button
  981. Calculating date and placing the value in the right date range col
  982. Formula to define non-contiguous range?
  983. how to round figures?
  984. Under data/Group&outline/group
  985. Classic View
  986. Formula for 20 minute meetings
  987. Record Macro Toolbar
  988. For..Next..Loop
  989. re-numbering or sequence priorities formula
  990. Default zoom
  991. User Form Text Boxes - Copy format of text boxes
  992. Delete rows with multiple columns with 0 value
  993. default number of copies
  994. vlookup for an unique Text and return its address?
  995. Cells no longer linked after inserts
  996. Import list
  997. Allow Users To Edit Ranges - Excel 2003
  998. Grouping.
  999. shading based on change of values
  1000. Splitting Numbers into Columns.