Nice video but i can't get it to work, i have this formula in X35: =IFERROR(H35+U35; "") (H35 is my start amount, and U35 is my PnL, and if it's empty it will be blank) How do i apply it to this formula i keep getting errors, can somebody pls help me? :)

God bless you

I've just rediscovered Wondershare Filmora (WF). Bought it many years ago.... I was using 11Labs text to speech AI voice cloning. Suffice to say, It is full of bugs and errors, where many of my small paragraphs of conversions become annoyingly recorded with ticks, and odd human noises (Which were not on the recording). The support was useless too, no replies to any of my emails. So, I have just used WF and the voice clone with text to speech conversion is brilliant, 5 stars... 🙂👍💯❤

How about if data in pivot is numbers and you will lookup is numbers also. Is it applicable even not letters/word?

How do I replicate the month so that I have a worksheet with 12 months instead of one? I want them to all to be the same size but to have them appear one after the other as I scroll down the page? I want to be able to view the upcoming months. Also at 9:15, how are the cells being frozen? What buttons are being pressed?

Thanks, Is there a way to make the chart show only months with values ie in this case only show Jan - Mar, on the chart but without changing the source data, so in the next month when data is provided for April, the chart shows this line without changing the data source?

Euro template is excellent, having lots of fun with lads :) Can't thank you enough.

I have no identifier for checks. It is just the check number. Same with deposits I have odd and different descriptions what if you just want the excel to look at date and amount or check number date and amount. Then allow us to use the reconciler tool X short cut if multiples and clear accordingly

Thank You

Great Awesome Spectacular

Hi. The last 16 fixtures are in correct. Do we change these ourselves? Please advise. Thanks

We're having trouble in our sheet, the teams aren't updating in the matches of the knockout round

Thanks, Man I appreciate your work

Hi, thanks for the template! Quick one, while doing overrides in players tabs it changes the scoring results. How to go around this?

how to put a link ???

Thanks for the video. Is there a way to connect a query to a website (eg Yahoo) to get 'today's' price?

Great video, very helpful. The S&P link refuses to connect via excel. I figured out a work around, using the download data URL from yahoo finance, but this makes it such that it won't automatically update daily. Any insight?

Can u create an index ? Trade economic data

Saya sort di kolom grand total kok gak bs kenapa ya kak?

Thank you so much, I have been looking for exactly this type of calender views for my inputs.

I tried to make a portofolio with dataset that i downloaded from Kaggle. So there are some error . It want to put a value on it. So what shpuld i do?

It would be more helpful if it wasnt so fast and was more descriptive. Seems this tutorial is already for users who are proficient with power query, who likely dont need this video anyway.

this is cool - but the description should probably be more specific - I thought this would help me generally create a custom function, but really it's just for one particular type of task (grabbing something from the web).

I am unable to extract data from websites I am getting an error!

you're god! thanks

helped

Super easy to follow. Thanks for posting this!

That was very helpful, thanks!

This is great - Five games played - Me 16pts (0-3-0-3-10), AI 15pts (3-3-3-3-3). Future predicted draws are already showing player prediction points?? So I'm recalculating as the games are played. (I think this only applies to 0:0 predictions). Work around is to enter (0:0) and re-enter 0:0 when the match is played so "no big deal".

Hi I have created a league with 23 players and have input all predictions on individual spreadsheets but I’m struggling to find all the points collated on one table to share with the group, would you be able to help please

When i'm downloading it doesn't give me the predictions tabs, can you advise please ?

Hi, thanks for creating this! I am running a league for my friends and I (8 of us) but the last two tabs are giving incorrect Total points for them. Is there anyway you could help? Thanks you are the best!

Hi, Thanks for creating it. I've downloaded it but the teams listed in the Table section disappears when I input the scores. pls advise

Great

Great tutorial. This solves the exact problem I was working on. 🥳

brilliant! Very helpful! Ty

I hate the date picker in Google Sheets (I'm all keyboard driven, no mouse). How do I turn it off? It drives me crazy.

Thanks a lot mate

what is... crt end??

Can you edit multiple external links within the data, as "Workbook Links" does manually. I have to change the domain in each cell in column of external links from other excel files. Brought in to the workbook with either with formula =[cell] or name. There are many workbooks that are aggregating external links and need to be changed. The external links appear as data and the url and only be managed with the "Workbook Links" feature, manually one by one. Can Power Query do this work dynamically?

hi, what if i want to highlight the difference between the high and base case (1) and (2) the base and low case?

Hello, I am having an issue with the spreadsheet, just testing to see if it calculates the correct scores for each result and it only seems to be calculating the scores for the first game and not any others could you help at all?

Hello. The Google Sheets file you have linked on your website is not write-protected. Someone (named "Ike" I guess) has edited the file, and I think there are some weird content added... Can you update the link with a clean table?

Thank you for the clear explanation 🤩

Hi, thank you for sharing the template. The Excel file shows an error message saying, "The column '(x$1000)' of the table wasn't found." Can you fix the problem?

Great tip!

I keep getting cant authenticate credentials error when I lad the data into excel?

That tabular view is the real tip here >.>

thanks for the information

Hey, I'm using this for a sweepstake and only using the actuals, is there anyway I can alter the team names to include the names from the sweepstake for instance Germany would end up being Germany (Name)?