Видео

Oh interesting! Yeah, I suppose that could be something, especially with some hunters editing map data and around the Appalachian trail! I suppose it also goes into a larger question: if any of the treasures were purchased /used to add a clue to the hunt…be interesting to see a solve once one is found! And thank you! I always appreciate hearing that! 😄 best of luck in the hunt!

@@AnonymousAnalysts nice! Is there any main points that got you there that you’re willing to share? Totally get it if not, I am not near that area so I’d not be a BOTG 😅 I just like hearing theories and solves!

Unfortunately still not added for the app... So going on your web browser, opening up the document with "request desktop view" you are able to add them, but it is clunky.

Hey there, agreed! Been nice although as you found, the filtering can be a bit problematic... That said,if you want to filter by a tag, you could use either the QUERY() function or a FILTER() with a REGEXMATCH in the condition. That said, these would match anything with the lookup as I mentioned in the video as well, so if you were looking for ice cream called "Chocolate" it would pull any that contains "Chocolate" in the name. If that would be a deal breaker, I would suggest making something like the EXACT_SPLIT tab and just filter on the TRUE/FALSE that you want. If it is okay to filter and your selections wouldn't have contained words like "Chocolate" and "Chocolate Chip" you could try one of the ones below: FILTER Method: =FILTER(Table2,ARRAYFORMULA(REGEXMATCH(Table2[top ice cream flavors],"Chocolate Chip")=TRUE)) Note: You could change the "Chocolate Chip" to a cell reference as well vs. writing out the flavor. QUERY Method: =QUERY(Table2,"SELECT Col1,Col2 WHERE Col2 CONTAINS 'Chocolate Chip'",0) Note to change the QUERY to a cell reference you'd need to put an apostrophe and quotes to end the query argument, use ampersands between the cell, then reverse thats below (with A1 being the cell): =QUERY(Table2,"SELECT Col1,Col2 WHERE Col2 CONTAINS '"&A1&"' " ,0) Hopefully this helps!

Hey there, sorry for a super late reply. Inside structured tables no, you can't really make those header rows for each one like that, without creating group views. It may not be the exact answer you'd want, but I would suggest Pivot tables as a potential option as you could organize it by departments first then expand/collapse based on departments. Hopefully gives you a potential idea!

Hey there. If you go into Drive you can download the entire document (Right click > Preview > Print or download.) I have a video showing how to print/download as a PDF but you can also try in a Word - just the formatting does "change" where each document tab is a different page on the single document. Usually with the document tab name as a page break /header. But hopefully what you are looking for! Video below if you want to watch it: ruclips.net/video/h3_nSATjxis/видео.html

@@matttechtidbits Holy S***! Thank you so much! I can not begin to describe how happy you just made!😃 I love the way you can use tabs, in google doc, but i needed to be able to backup the document in some way with tabs, just in case s*** goes down. In the modern world you can never truely trust the internet tech, so thank you from the the buttom of my heart!☺

Hey there! Happy new year! So if you are using the example table I used, you could look up a name using XLOOKUP and the table ranges. I would probably use a cell reference (maybe even use a drop down in it) for the names, but in this example It'll just look up the salary for "Sofia Collins" and return "not found" if the name isn't in the table: =XLOOKUP("Sofia Collins",Table1[full_name],Table1[salary],"not found") Note this only does one instance - say the table is salaries for each year, it wouldn't show all salaries for the person, just the first one found. (Filter or QUERY() would be an solution in this secondary example). Hopefully this answers your question and makes sense!

@@matttechtidbits thank you very much for your help! - works perfect? - I wish you All the Best for the New year!

Yeah not my first and certainly not my last 😅🐰

I assure you this treasure hunt is 100% fake

​@@AshcanWally how can you assure that?

@@butters4596 are you serious?🤣 Did you participate in the fake Forrest Fenn treasure hunt?

​@@AshcanWallybut this is not an answer. if you have an argument or evidence, please share

71619

I'm also focused on one in my geographic region Think about it. That laminated lionshare hint in the other box's is worth a value too. If I found one..i wouldn't reveal that clue until another hunter found and then I'd do a barter trade info and hunt together from there. T

Oh, I do see that as well! And yes, agreed! especially with things like this where there are clues "somewhere" in this book! Many potential things that could be clues. Excited for the treasures to be found and puzzles explained haha!

Thanks 😅 I’ll not make that mistake again ( hopefully)

Good luck!!

It cant be road because d is taken for field so i tried rock ;)

me too. now i just need to figure out what it means.

Apparently, instead of usB, I get into the directory of the usb , as if I'm supposed to pick files

Im using the Aptio Setup Utility and I had no idea how to boot device using Usb installer

YES please make it back to normal it is incredibly frustating just to edit. You have to unlink than relink, then redo your previous format every time super frustrating nightmare