Excel Consultancy - Fast Search

This is mainly aimed at the UK experts.

I have currently got a few companies who I have been doing some work for, mainly to advertise my skills.

It now seems that while none of them are able to hire me full time at the moment, they are talking about hiring me on a consultancy basis.

I was wondering if any of you could give me some advice on what rates to charge, whether to charge per project, hourly, discount for longer time spans etc.

I dont want to price myself out of the market, but as I am unemployed at the moment I want to pay some bills!

If you are not happy replying here, please feel free to PM me and I can give my e-mail address.

Thanks for any assistance you can give me

Regards

Darren

I have two ranges, and I want to walk through the first, and for each value there I want to see if there is a matching value somewhere in the second. I could write my own binary search. But I'm wondering if there's already a built-in function in VBA that does it. Fast.

Alternatively, if I was in the spreadsheet I would do a VLOOKUP or an INDEX(MATCH()). Is the best solution just to use those worksheet functions in VBA? Are they fast?

brid

I have 5 antibiotics (i.e. A B C D E)
I need to group them in doses of 3 (i.e. ABC, ACD, ADE, etc.)

Can anyone think of a way to put this in excel so that I can show all the possible doses?

Thanks!

Hi All

I have a VBA/excel workbook I and others use every day on the same computer.

When there are so many users on the same computer. The excel 2007 are therefore slow to startup I was wondering if there was a way to increase startup of a vba/excel file? maybe deactivating functions in excel or something else ??

sincerely
Me

I want to make a line colors in a rage, let say from A1 to A20, How can I color A1, A3, A5, A7, etc. only?
I want color one line yes and one line no, but I want to do it selecting range.

Comments are welcome

1. Select a cell in the Current Region/List and press Ctrl+Shift+*> or Ctrl+A.
2. Press Alt+=.
Or
Select Formulas -> AutoSum (in Function Library Group).
3. The SUM formula is added automatically at the bottom of each column.



1. Select a range of cells containing values, including a blank row and a blank column surrounding the range by selecting the first cell in a table, pressing the Shift> key. Then select the blank cell in the first cross blank row and column (cell D4 in the screenshot below).
2. Press Alt+=.
Or
3. Select Formulas -> AutoSum (in Function Library Group).
4. The SUM formula is added at the end of each row and at the bottom of each column.
Befo

After:




Select the range of cells along with a blank cell in a vertical or horizontal direction.
Press Alt+=.
Or
Select Formulas -> AutoSum (in Function Library Group).
The SUM formula is added to the blank cell.

I have a spreadsheet that uses a bunch of macros, huge amounts of copy/paste, checks words and phrases against 2 dictionaries...and I need to to be fast and able to handle 100-200,000 rows of data.

At the moment I'm running it in XP sp3 via Boot Camp on my MacBook Pro 2.4ghz/6gb and it takes about 35 seconds to run 20,000 rows (one column). The file size is about 165mb before I paste data into it.

Since I need my Mac, I'm planning to build a desktop system just for this.

If I need to, I'll buy Windows 7 Ultimate.

I've got a budget of about $1000 (max), so I've been looking at the i5 750, i7 860 and i7 920. Will one of those be dramatically better than the others? Will I be able to use more than 6gb of ram? Will that be enough?

I don't need to have the world's fastest system, but it needs to be better than my current setup. If the 920 will only be 5% faster than a 750, that's not worth it.

I've been asking in the various forums, but all I get are responses from people that disagree with each other.

So, what's gonna make Excel fast? CPU? Ram?

Thanks!

Hello there,

I have some questions regarding this Excel Automation (I'm not an expert on
this so please "excuse" if the questions are too trivial)...

I try to build a small application that will generate a very large number of
columns and rows into Excel sheets (lets say about 200 sheets each one with
50 000 rows and 100 columns). There is a way to store "Cell" objects in
arrays so I could lets say "create" them into this array and than add the
array to a specific range (similar to the "Text", double, short storage into
an array...)? Why I'm asking this is because my Cells must have a specific
format (they are somehow structured as "BLOCKS" and this block will repeat
itself for many times) and I need a fast way to "copy" this "block"... I
already did a sample where I'm generatig arround 10 000 "blocks" on a sheet,
each block containing 3 rows and 15 colums, having each cell with a different
color and a random border. The time until it was finished was arround 31
seconds... Can I do this faster? Any ideas are more than wellcome.

Thanks,
Tas

Hi All,

Does anyone one know a quick way to format the 1st example excel below to the 2nd example? I have a 270 colunms and 393 rows excel sheet I have to format to the second example - I have attached a example exel
Ex.1

http://www.mediafire.com/i/?rzktmntimwm

Ex.2
http://www.mediafire.com/?dym54otzynn

example file-

http://www.mediafire.com/file/dbdmo2t01l0/Example.xlsx

Please help!!!

for ages i have been trying to figure out what makes excel fast or slow. i have some formulas and sometimes it takes about 3 seconds for them to compute and for the cursor to go to the next cell.

well, i just added a new sheet with a chart on it and for some reason that has speeded up my excel enormously. why?