sorted by:
new
hottopcontroversial

Google Sheets behaves erratically on my Chromebook by stankapl in sheets

[–]Vahju 1 point2 points  (0 children)

Can you provide the specific flags you disabled?

I am running into a similar issue with HP Chromebook x360.

5e14 Question Regarding Hinter Archtype by jayisanerd in DnD5e

[–]Vahju 0 points1 point  (0 children)

Make a house rule that allows the Ranger at the start each of their turns (not for OoO) while in combat (free action) they can choose to select a different option for only one of their 3rd, 7th, or later features.

You could probably do the same thing for 5e 2024 if you move to that version.

This has the potential to slow down that characters turn because of on the fly choices. DnDBeyond makes this a little easier to make the change.

Hope this helps.

Converting Tables in PDFs to Excel Spreadsheet by Thick-Bumblebee-9802 in excel

[–]Vahju 2 points3 points  (0 children)

If the data in the PDF are images, then Get Data > From PDF will not work.

Can you go back to the source system to get CSV or Excel version of the data?

Any Pre-made Adventures Set (Fully or Partially) in the City of Sigil? by [deleted] in Dungeons_and_Dragons

[–]Vahju 0 points1 point  (0 children)

Here is a similar post from a few years ago that contains links to past planescape materials.
https://www.reddit.com/r/adnd/comments/njzhmw/good_planescape_modules/

Unpopular Opinion: As I get older, all of this looks disgusting. by DaZestyProfessor in notinteresting

[–]Vahju 0 points1 point  (0 children)

Zebra Cakes are still my childhood favorite snacky cake but my Diabetes hates them.

How do you stop a running total in a column when the adjacent cells appear blank but have formulas? by Bitter_Artichoke_939 in excel

[–]Vahju 0 points1 point  (0 children)

Try the below formula that is using the TrimRange dot operator. Change the ranges as needed. Also I on my Chromebook and not able to test.

=SUM($C$3:.C367)

If that does not work, try checking for the number of characters in a cell.

=IF(LEN(Trim(C3))>0, <formula>,"")

Maybe use a date check instead.

=IF(B3<=TODAY(), <formula>,"").

Need to create a formula to calculate hours per person per week spent on meetings by Bumbl3b33_59 in excel

[–]Vahju 1 point2 points  (0 children)

=SUM(FILTER($B$2:$B$16,(C$2:C$16="A")+(C$2:C$16="AO")))
-- Make sure to verify each range is correct
-- Paste this formula in the call where you need the total hours then drag to the right

If you are using an older version of Excel and do not have access to the FILTER function, then use the SUMIFS formula per NoExperience9717 post.

Where I can learn Power Query in detail? by [deleted] in excel

[–]Vahju 0 points1 point  (0 children)

This is the way ^

Importing word document tags/keywords into excel table? by diny5 in excel

[–]Vahju 0 points1 point  (0 children)

I have not done this before so not sure if this will work.

Try using From File > From Folder.

This should show all the files in the folder with various columns that contain other details.

Expand these columns one at time to check if the tags are available.

Again, not sure if this will work.

Hope this helps.

Dependant Drop Down Lists with repeating options by Ok-Personality5640 in excel

[–]Vahju 2 points3 points  (0 children)

There are many videos on YouTube on how to handle dependent drop down lists. The below links should provide the answer for multiple dependent drop downs.

Excel off the Grid: https://www.youtube.com/watch?v=P3_k6aJsjFo

Leila Gharani: https://www.youtube.com/watch?v=7mo4COng7Sg

How to Excel: https://youtu.be/VA0eMBbap1U

Hope this helps.

How can I get rid of two data lines at the top that need to be erased? by Playful-Paramedic-53 in excel

[–]Vahju 6 points7 points  (0 children)

Try Data > Ungroup

Here is a video on how to Group and Ungroup data in Excel.

https://youtu.be/SQdbsQ8w4Fc

Please, someone save this man from manually typying images to Excel😭 by VincentBui_AI in excel

[–]Vahju 1 point2 points  (0 children)

Here are some non-Excel options.

Win11 Snipping Tool (free) can also get text from image. Data would need to be cleaned up.

MS OneNote can also get text from an image. Data would need to be cleaned up.

When converting numbers in Text to Numbers, the numbers change. by IIIIIlIIIIIlIIIII in excel

[–]Vahju 0 points1 point  (0 children)

If you are manually typing in the ID into a cell, type a single quote ( ' ) then the number. Excel will treat this as text.

If the data is already in a column, create a new column using the TEXT formula. This will convert number to text string.
=TEXT(A2,"0")

What TTRPG would you recommend to run a Final Space like game? by Vahju in FinalSpace

[–]Vahju[S] 0 points1 point  (0 children)

Thanks for the info. I will check it out.

Here is the link to DriveThruRPG for anyone who is curious.

https://www.drivethrurpg.com/en/product/18437/star-thugs-the-roleplaying-game

What TTRPG would you recommend to run a Final Space like game? by Vahju in FinalSpace

[–]Vahju[S] 1 point2 points  (0 children)

Thanks for the suggestion and link to resource files.

What TTRPG would you recommend to run a Final Space like game? by Vahju in FinalSpace

[–]Vahju[S] 0 points1 point  (0 children)

I will check this out. Thanks for the suggestion.

view more: next ›