Search results for:

I always prefer (and use) index/match instead of vlookup- no need to sort columns and the calculation process is suposed to be less resource intensive.

@aggi cheers- I can feel some sort of hybrid of the above coming together.

As always this forum rocks! (though Chandoo.org is pretty good for vba help).

without wearing a helmet

OMG! Did you call the police?

Can't use a PT unfortunately.

Thinking aloud- If I used a MAX/MIN based formula to create two new columns with dates I want (would I use an HLOOKUP or similar to do this?) and then had a third column with the number of days between the two, sort largest to smallest and then de dupe based on unique combined job+contractor ID would that theoretically work?

anyone got an idea on how I can automate the following:

Each row is a contractor it records their start and end date for the contract and has a unique ID for - Contractor, Job, and Placement.

There may be multiple rows for each contractor, some of these multiples will be for the same job as they have had their contracts extended. Some of the multiples will be because they have worked on more than one different jobs.

I need to de dupe these records so that I have one row per contractor per job where if the contract has been extended it takes the earliest date from the start date and the latest date from the end date.

Any ideas or is the guy in finance stuck with doing a boring manual review of these records each week?

What did you get the overall stack down to?

Wonder what the running costs on it are.

Moved to mare street a few months back- now the closest I've ever been to a compass drinks, under half a mile- will try to make it down this eve/soon

Dibs please- found a great home.

I don't believe so, the online offering is a bit limited in general I think. You outside London?

Oh man, why do I live on the second floor?

You'll have trouble- I think most 110s only come in +10 rise.

That and the buckfast one are the only bidons a discerning fashionista needs

Tory campaign promises:

£350 million for the NHS
Access to single market and retention of banks' passporting.
No more forrins allowed in.

Oh FFS.

Alu frame carbon fork. Eyelets on dropouts and forks for mudguards/panniers.

BT have been doing this for years anyway.

Thanks, looked at that a while back and the new 70w tesla stealth but instead opted for the Wismec RXmini- it is tiny.

Effectively when twinned with the potentiometer knob.

Ha!

15 mins?

HTFU

Sock puppet?

Dude, you need thicker skin, a dictionary (to look up troll), and a more conservative price on this bike.

I was trying to be helpful, I wouldn't expect to see that go for any more than £50-70.

I think you are the one with clown shoes on at the moment.