Видео

OMG! Problem solved!! :D maraming salamat po sir :)

Finally! Lifesaver!! Thank you, Sir! :>

What If the time in is blank? which means that people didn't come, how do I go about that formula

please data source

This is incredible, thank you so much!

Boga

Can you do the Planned vs. Actual Cummulative.

Thanks for an easy to follow tutorial. Is it a 2 way link? Can I edit the content in Excel and push the changes to Google Sheets?

Thanks but This is not updating real time data.if i made any change in the sharepoint excel file then it don't reflect any solution pls

so you cant really cut them out. you just make it seem like it's cut out

Amazing solution. It worked so well for me. Thank you!!!!

hi thanks for this. i tried it on google and i get error "The result of the array was not expanded because it would replace data in cell F4." any ideas?

Nice that is clear and easy learn for basis Power BI.

This is very helpful. How about the computation of 1 hr lunch break from 12nn to 1pm and, the 1hr breaktime will not deduct for the employee reported for half day and undertime work hours? Thank you

informative!!!

Thank you well done

Paano po gwin yang maliit na table na may yellow sa taas?

Best video yet on explaining this. Most videos don't explain Delimiters vs Fixed Width, they just automatically tell you to use Delimited. Thank you for this video.

Still don't understand. Then again I am dumb

How beautiful u have explained is marvelous. Gbu

does it work on columns with formula?

thank you king

CAN u do it with 3 values. so lets say 2 in the columns, and one in the row. so imagine if in your data you also had a date function as a column. Where you need to find specific product in location ON A SPECIFIC DATE

Why cant use on table. If our array source is non-table, i can get the return value. But if i click Ctrl+T on that array source, it officially become table, and cant use this function anymore 😢 Is there any way?

do i need to complete all the actual start and finish date to generate the report? because i have set the baseline but the date are not complete yet as the project is ongoing, when i generate the report all the cummulative value in excel is 0

Hi, This works really well for what I need. However, for some reason if I choose a range down the whole column it wants to count a blank cell as December. Do you know why that is?

you can also copy/paste your chart from sheets, when you paste on slides it asks you if you want to link it.

Thanks, boss!

thanks kuya this helped

great help! Thanks!

THANK YOU SO MUCH SIR

Thank you so much. Since Excel 2016 Perpetual License does not have a stock ticker price function but Google Sheets does(=googlefinance(ticker)), I am trying to use your method of linking the spreadsheets to routinely pull stock prices into Excel. As such I am not converting the Google Sheet to a csv because I want to keep the formulas live in the Google Sheet cells. Thanks for pointing me in the right direction. Before discovering your solution I spent hours looking for free Excel Add-ins without success and the queries of financial data web sites are too cumbersome to use in a constantly changing environment.

Thanks.

This was very useful ! Thank you

yo dawg, i heard you like xlookup

Very helpful, thanks!

This is a great video. Deserves way more views and Likes

amazing! thank you!

Great! Thank you for perfect coaching So how can we have both earliest Scurve and latest Scurve as envelope.

I eventually got it, but at least in excel 2007, you need to not include that first column (as you say), but include the row in the array (which you don't say. Strange. Thanks for the explanation!

Thank you, helping a lot

nice function, what if you wanted to take it further and capture P for only John as an example

any way to find hours and minutes?

lol manually making the third axis

Hi sir, from available fields from visual reports, i dont have baseline cumulative work and cumulative work to add to selected fields.. what to do sir..?

Thank you !!! I was looking for a video that taught me how to do those indentions for the last 30 minutes 😅 . I've got a college assignment to develop 100 tasks in excel to transfer it into MS project later . I will follow your format for the WBS ✌️

Thank you for this video...

Easy and straight forward

Really helpful! Thanks

bad video, too complicated, just make easy example for 2 or 3 rows only