Hi ,
It looks like you're using an ad blocker.



The revenue generated from the adverts on the site is a critical part of our funding - and it's because of these ads that I can offer the site for free. But using the site for free AND blocking the ads doesn't feel like a great thing to do, which is why this box is so large and inconvenient. Some sites will completely block your access, but I'm not doing that - I'm appealing to your good nature instead. Did you know that you can allow ads for specific sites, whilst still blocking them on others?

Thanks,
Ian Williams aka Fetch

or for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers
EdJ
May 2023
9:38am, 18 May 2023
695 posts
  • Quote
  • Pin
EdJ
Have we ever had an Excel formulas DeathMatch?
May 2023
9:50am, 18 May 2023
145,698 posts
  • Quote
  • Pin
GregP
We have not, mainly because it's descend into a pitch battle between the index/match lot from the premiership and the non-league bullies from vlookup
SPR
May 2023
10:21am, 18 May 2023
40,550 posts
  • Quote
  • Pin
SPR
🤣🤣🤣
May 2023
11:21am, 18 May 2023
70,301 posts
  • Quote
  • Pin
GlennR
Spreadsheet Sunday cloggers.
SPR
May 2023
11:28am, 18 May 2023
40,551 posts
  • Quote
  • Pin
SPR
Vlookup is decent, but can it cut it on a rainy day in Stoke?
May 2023
11:48am, 18 May 2023
145,715 posts
  • Quote
  • Pin
GregP
It's okay going forwards...
SPR
May 2023
12:12pm, 18 May 2023
40,552 posts
  • Quote
  • Pin
SPR
A one trick pony...
May 2023
12:19pm, 18 May 2023
145,719 posts
  • Quote
  • Pin
GregP
It can't track backwards, it's painfully slow. People who's opinion is absolutely not to be trusted tell you it's a good solution to your needs...

https://youtu.be/tjQeBj7KwVE
um
May 2023
12:19pm, 18 May 2023
7,402 posts
  • Quote
  • Pin
um
It's very much root / route 1. But quite effective against some of those fancier and more tactical approaches.
May 2023
12:21pm, 18 May 2023
145,721 posts
  • Quote
  • Pin
GregP
Whisper it quietly, but I use it in a hurry because I know the syntax without thinking. Index/Match takes much more engagement of brain.

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...
  • Show full description...

Related Threads

  • excel
  • support
  • tech
  • work

Report This Content

You can report any content you believe to be unsafe. Please let me know why you believe this content is unsafe by choosing a category below.



Thank you for your report. The content will be assessed as soon as possible.










Back To Top

Tag A User

To tag a user, start typing their name here:
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 114,108 Fetchies!
Already a Fetchie? Sign in here