General

SUMIF/AND combination?
I have a spreadsheet with data that shows transactions for a number of areas with a column showing which week the transaction belongs to eg (I have put row and column headings on for clarity later): Sheet1 A B C D 1 Area Week No Value Descrip... 19 Mar 2010 08:12

Highest number + company
Hi, I have created a spreadsheet in which companies submiting a tender will be scored. In order to make life easier for the committee reviewing the bids I would like to do the following: Display the top 3 scoring bids below: Using: =MAX(J14:J236) I can get the highest ranking score - but not the company... 19 Mar 2010 06:00

encryption
Hi, I remember there're some products for encrypting the VBA codes (Excel macros). Has anyone ever used that? -------------------------------------------------------------------------------- Many Thanks & Best Regards, HuaMin Chen ... 22 Mar 2010 08:17

Can I extract the only second word?
How can I extract the second word in a cell into a cell? I don't want the first word or any other words to go with it into the new cell from company name. e. g. from AL BASSAM INTERNATIONAL FACTORIES extract BASSAM only. Also I would like to know to extract only third word in case I may need for future altern... 19 Mar 2010 10:48

Sort Worksheets
I have a WorkBook with 200+ Worksheets. I sort these A-Z with a VBA code. Somewhere I read a tip on how to GoTo a Worksheet directly without scrolling the Tabs. Am I dreaming? Bob M. ... 19 Mar 2010 12:02

How can I choose which lines are frozen using "freeze pane"?
From the Microsoft Quick Reference Card at: http://office.microsoft.com/training/Training.aspx?AssetID=RP011212271033&CTT=6&Origin=RC011212161033 Freeze panes Keep titles in sight as you scroll through worksheets. To freeze titles, make a selection in the worksheet, and then click Freeze Panes on the Windows ... 19 Mar 2010 00:35

How do I import data into Excel from Bloomberg using Excel 2007?
How do I import data into Excel from Bloomberg using Excel 2007 (Microsoft Vista)? I need to import historical prices of 14 tickers into the same workbook. ... 19 Mar 2010 03:49

using VBA to retrieve values to ComboBox
i am trying to retrieve a range of data (the stock code of different phones) from worksheet("Inventory") based on the name of the branches of where the phones are stored. worksheet("Inventory") has branch (Column A) and stock code (Column B) i have 2 combobox. combobox1 contains values (name of branches) suc... 18 Mar 2010 23:29

Delete duplicate records from both columns
Hello, I've got 2 columns of data. How can I delete both records if the appear in both columns? This is in Excel 2007. Thanks ... 19 Mar 2010 14:23

tab to next unlocked cell
Hi... hope you can help. I have a spreadsheet with locked and unlocked cells. I would like to TAB to the next unlocked cell available. Is there an easy way to set this up? Thank you. ... 18 Mar 2010 22:22