|
Feb 2020
11:49am, 21 Feb 2020
117,995 posts
|
GregP
This might take some explaining. And I might get laughed at.
Why can't I do this and get a TRUE/FALSE result, please?
=F2:F10=G2:G10
|
|
Feb 2020
11:54am, 21 Feb 2020
1,120 posts
|
Nessie
Try this:
=IF(SUM(F2:F10)=SUM(G2:G10),TRUE,FALSE)
|
|
Feb 2020
11:55am, 21 Feb 2020
1,121 posts
|
Nessie
(but to answer the question, I don't know why your's doesn't work)
|
|
Feb 2020
11:55am, 21 Feb 2020
10,406 posts
|
larkim
That is odd, when you can do cell A1 to be =F2:F10 and cell B1 to be =G2:G10 and then =A1=B1 to be TRUE/FALSE.
Even as an Array formula it only evaluates the first row.
|
|
Feb 2020
12:00pm, 21 Feb 2020
117,998 posts
|
GregP
This works, but I don't understand:
{=AND(L12:L18=M12:M18)}
|
|
Feb 2020
12:28pm, 21 Feb 2020
336 posts
|
icenutter
Any idea show I can create hyperlinks more efficiently?
I've got a large list of engineering drawing numbers, and I have a copy of those drawings in pdf format. What I'd like to do is to have those hyperlinked so I can click on a link in excel and the drawing opens up. Obviously I can go through the list and create the links one by one, but there must be a better way.
The batch I'm working on at the moment has 210 in, but that's just the starting point. I've another list with a few thousand in...
|
|
Feb 2020
12:33pm, 21 Feb 2020
10,407 posts
|
larkim
=hyperlink(string for URL, friendly name)
So if cell A1 says fetcheveryone and B1 =hyperlink("www."&A1&".com","Fetch link") would create a clickable link.
Can you work it frmo there?
|
|
Feb 2020
12:37pm, 21 Feb 2020
47,705 posts
|
GlennR
Greppers, I can't even make sense out of your second example as logic.
|
|
Feb 2020
12:38pm, 21 Feb 2020
6,747 posts
|
paul the builder
We have such a drawing register file here (in excel). I didn't create it.
This is not a great answer, but if your drawing numbers are sequential, then you can drag down a cell with a hyperlink to create a new link in each cell following in sequence .
|
|
Feb 2020
10:25am, 22 Feb 2020
29,921 posts
|
SPR
I presume the AND is saying if L12=M12 and L13=M13, etc then return TRUE. Answer is true if all are true.
In the first example I guess it isn't sure how to evaluate it to one answer (as opposed to 7 TRUE/ FALSE statements) so just gives the first one.
|
Excel skills test
Mar 2019