Excel Experts

Brian Fantana · Oct 1, 2014

Morning NSC,

If there are any Excel experts around, I'd be grateful if you could drop me a PM as I've got something I need to achieve outside of my knowledge!

Cheers in advance!

Brian Fantana · Oct 1, 2014

A few people have PM'd, so I should be sorted. Cheers all.

Bozza · Oct 1, 2014

As disappointing threads go, this is right up there with the best (worst).

This was a perfect opportunity to hold a virtual beauty pageant of the Excel ninjas who grace this fine forum who could have dusted off their very best vlookups and done battle to be crowned Excel King.

But, no, you asked for PMs. Pathetic.

Tricky Dicky · Oct 1, 2014

Escel is one of the best apps. You can do so much with it, but can be a bit frustrating if you don't know how to achieve what you want to do, but I love it.

Westdene Seagull · Oct 1, 2014

Tricky Dicky said:
Escel is one of the best apps. You can do so much with it, but can be a bit frustrating if you don't know how to achieve what you want to do, but I love it.

Indeed - Microsoft have made some cracking apps - Excel, Exchange and Visio are amongst the best - yet they've also made some complete turkeys such as Project and Sharepoint.

leigull · Oct 1, 2014

Bozza said:
As disappointing threads go, this is right up there with the best (worst).

This was a perfect opportunity to hold a virtual beauty pageant of the Excel ninjas who grace this fine forum who could have dusted off their very best vlookups and done battle to be crowned Excel King.

But, no, you asked for PMs. Pathetic.

Exactly. What a waste. Gutted.

Tom Hark Preston Park · Oct 1, 2014

Bozza said:
As disappointing threads go, this is right up there with the best (worst).

This was a perfect opportunity to hold a virtual beauty pageant of the Excel ninjas who grace this fine forum who could have dusted off their very best vlookups and done battle to be crowned Excel King.

But, no, you asked for PMs. Pathetic.

Totally agree. It's like watching Countdown and Rachel keeping to herself how she's solved the Numbers Round. Disgraceful.

MattBackHome · Oct 1, 2014

Can you post the excel challenge anyway?

I don't consider myself an excel wiz by any stretch, but have improved recently and feel like taking a pop at the champs.

Bozza · Oct 1, 2014

MattBackHome said:
Can you post the excel challenge anyway?

I don't consider myself an excel wiz by any stretch, but have improved recently and feel like taking a pop at the champs.

Sssshhhhhh - I was trying to guilt it out of him.

CheeseRolls · Oct 1, 2014

Westdene Seagull said:
Indeed - Microsoft have made some cracking apps - Excel, Exchange and Visio are amongst the best - yet they've also made some complete turkeys such as Project and Sharepoint.

Visio was a brilliant product before Microsoft bought it. Some aspects may have benefited from the Office look and feel, but other useful pieces have fallen by the way side. Agree on Sharepoint though yuck !

kevo · Oct 1, 2014

Bozza said:
As disappointing threads go, this is right up there with the best (worst).

I think you taint him with faint praise. I think this has to be the worst thread ever in the history of NSC.

Any thread that mentions Excel in its title is nailed-on guaranteed to be mind-numbingly boring.

But to not even include the actual problem or the solution is unforgivable.

FKalinx · Oct 1, 2014

My INDEX and MATCH functions were ready to be unsheathed.

Petunia · Oct 1, 2014

FKalinx said:
My INDEX and MATCH functions were ready to be unsheathed.

Please, please unsheath them :blush:

I've never managed to get it to work!!

Birdie Boy · Oct 1, 2014

Solved it! File>New>Create... :thumbsup:

Brian Fantana · Oct 1, 2014

Bozza said:
Sssshhhhhh - I was trying to guilt it out of him.

Not going to work.

The nature of my, admittedly dull, query would not have been sufficient to testing the king of Excel.

Dorset Seagull · Oct 1, 2014

I love Excel and learn new things all the time......but pivot tables, what's that all about!

Brian Fantana · Oct 1, 2014

The answer to the issue was indeed a vlookup. Being an Excel novice, I'd never had cause to investigate or use this before.

The dull problem was that I had a full master customer list containing email address, name and a unique ID. I had another smaller list of just unique IDs of customers who I needed to contact, so I need to match the small list against the larger one to bring together the unique IDs with the corresponding name and email address.

There. Told you it was dull.

dadams2k11 · Oct 1, 2014

Brian Fantana said:
The answer to the issue was indeed a vlookup. Being an Excel novice, I'd never had cause to investigate or use this before.

The dull problem was that I had a full master customer list containing email address, name and a unique ID. I had another smaller list of just unique IDs of customers who I needed to contact, so I need to match the small list against the larger one to bring together the unique IDs with the corresponding name and email address.

There. Told you it was dull.

Such a child.

Easy 10 · Oct 1, 2014

Tch.

I was really looking forward to seeing some SPREADSHEET PORN when I opened this thread.

Mr Smggles · Oct 1, 2014

Westdene Seagull said:
Indeed - Microsoft have made some cracking apps - Excel, Exchange and Visio are amongst the best - yet they've also made some complete turkeys such as Project and Sharepoint.

Sharepoint is brilliant when used correctly.

Got something to say or just want fewer pesky ads? Join us... 😊

Excel Experts

Well-known member

Well-known member

You can change this

New member

aka Cap'n Carl Firecrotch

New member

Will Post For Cash

Well-known member

You can change this

Well-known member

Well-known member

New member

Living the dream

Well-known member

Well-known member

Once Dolphin, Now Seagull

Well-known member

ID10T Error

Brain dead MUG SHEEP

Well-known member

Share this page