yet another superb tutorial - couldn't find the code though for onbarcode
@WorkflowWisdomКүн бұрын
You'll have to click on the video playing on the site that I gave, then you'll see the code in the description of that video. You can also just pause my video and copy the code that I highlighted. It will be the same code.
@praveenchawla69993 күн бұрын
Nice. Clear and Short.
@WorkflowWisdom2 күн бұрын
Glad it was helpful!
@Character-j1r3 күн бұрын
Thank you ❤ for your short videos focusing on the power of Google sheets. Can you also do an explanation of if you ever need a large data set with cells exceeding 10 billion cells on Googlesheets vs Excel? If you are working with data sets or are a data analyst / data scientist and can you still use Google sheets as a data scientist
@WorkflowWisdomКүн бұрын
I'll do my best to create a video for it in the future so stay tuned for that!
@Allen-L-Canada3 күн бұрын
what would be a usage of this function?
@WorkflowWisdomКүн бұрын
I will be posting a video on how to create a dynamic calendar here on the channel to show you how I used the SEQUENCE function, so do look forward to that!
@krishnatate47654 күн бұрын
Thank you ma'am 😊
@WorkflowWisdom2 күн бұрын
Most welcome 😊
@MISComputerNET5 күн бұрын
When and why would we need such a function in real life? Any examples you might have?
@WorkflowWisdomКүн бұрын
The CELL function gives you specific information about your cells. It's a great function to use when you're dealing with a large set of data and you want specifics about your cells. For example, when you want to know if your cell contains plain text, other values or just blank, the CELL Function will help you determine that with this formula: =CELL("Type",A1), if it returns an "l" you cell contains plain text, if it returns a "v" it contains other type of data like numbers and if it returns a "b" that means your cell is blank.
@Allen-L-Canada5 күн бұрын
thanks. Can I do a line or bar, showing where a current stock price fall into the 52-week high and low, like they do in Yahoo Finance. for example, if the 52-week range is 20-60, current price is 40, then we show something like this: -------------•------------. The dot shows the current price. Thanks!
@WorkflowWisdomКүн бұрын
You can do a line chart but it won't be able to highlight the current price like it does in Yahoo Finance. Unfortunately, Google Sheets charts don't allow you to highlight a specific gridline in your chart.
@WorkflowWisdom5 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom5 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom5 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom5 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@Allen-L-Canada5 күн бұрын
that was a cool function
@WorkflowWisdom5 күн бұрын
Great to hear you liked it.
@srikrishnanrengarajan61097 күн бұрын
Thanks ❤
@WorkflowWisdom5 күн бұрын
You're welcome 😊
@isaak19047 күн бұрын
Love This
@WorkflowWisdom5 күн бұрын
Hapy to hear that.
@IPlayIWA8 күн бұрын
Awesome work. Thank you very much. I assume you can also do this in an importrange if you are dealing with more than one sheet.
@WorkflowWisdom2 күн бұрын
Yes! You can absolutely do that. Just add the Function after the equal sign. For example, =SUM(IMPORTRANGE(spreadsheet_url, range_string)
@srikrishnanrengarajan61099 күн бұрын
Thankyou
@WorkflowWisdom5 күн бұрын
Welcome
@srikrishnanrengarajan610910 күн бұрын
Thank you so much... informative ❤
@WorkflowWisdom9 күн бұрын
My pleasure 😊
@isaak190410 күн бұрын
Thank you for sharing
@WorkflowWisdom9 күн бұрын
My pleasure
@srikrishnanrengarajan610912 күн бұрын
Excellent Thank you 😊
@WorkflowWisdom9 күн бұрын
Glad it was helpful!
@WorkflowWisdom12 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom12 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom12 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom12 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom12 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom12 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@srikrishnanrengarajan610913 күн бұрын
Excellent Thank you ❤
@WorkflowWisdom12 күн бұрын
You are welcome.
@kirk196814 күн бұрын
Whoever creates your video thumbnails deserves a raise, they're always really good 😁 Interesting comparison, I have never thought to use ArrayFormula for situations like that. But now it's another option, thanks!
@WorkflowWisdom12 күн бұрын
Glad you like them!
@MISComputerNET14 күн бұрын
Thanks for the tutorial. As you mentioned, it might depend on the situation, I mostly prefer using arrays. Especially for big data sets having more than one thousand rows, arrays work just fine.
@WorkflowWisdom12 күн бұрын
Thanks for sharing!
@srikrishnanrengarajan610914 күн бұрын
Thankyou nice update
@WorkflowWisdom12 күн бұрын
Thanks.
@AgendaBioBioCL15 күн бұрын
Can I let an empty column using Query?.... something like this =QUERY('Sheet 1!A1:E'; "SELECT A, B, " ", C, " ", D)
@WorkflowWisdom9 күн бұрын
You can't add empty spaces in between columns selected in the Query Function. And you're formula in selecting specific columns should be separated by commas and not semicolons, ex: =QUERY('Quarter 1 2022'!A1:E8,"Select A,B"). Semicolons are only used in separating your ranges in an array.
@srikrishnanrengarajan610917 күн бұрын
Thanks
@WorkflowWisdom15 күн бұрын
Welcome
@WorkflowWisdom19 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom19 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom19 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom19 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom19 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom19 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@mohammedzabiulla478721 күн бұрын
Hi, i need to do the same for 750 rows. Any shortcut method ?
@WorkflowWisdom15 күн бұрын
For now I haven't found a shortcut for this one, but once you've learned and followed the steps on the video, you'll be able to recreate these even with 750 rows.
@Zabiulla115 күн бұрын
Hi, Yes, I did the same I.e. I did it manually for all 750 rows. Thanks for this video!
@WorkflowWisdom12 күн бұрын
@Zabiulla1: You are welcome.
@srikrishnanrengarajan610921 күн бұрын
Thank you
@WorkflowWisdom19 күн бұрын
You're welcome
@krishnatate476521 күн бұрын
Very helpful madam ❤
@WorkflowWisdom21 күн бұрын
Glad to hear that
@wertyghjkl-fc3dx21 күн бұрын
How about if your sheet2 and sheet3 were both 1stQuarter for 2 different years and you wanted to link them to the annual, with the intention of finding the annual average?
@WorkflowWisdom19 күн бұрын
You can still link your sheets just make sure to rename your sheets with the proper year, for example, Sheet1 would be "2023 1st Quarter" then Sheet 2 would be "2024 1st Quarter." To get the annual average, just enter your formula at the end of your data set or table.
@kirk196823 күн бұрын
That is a very cool feature! I would not have known about it without this tutorial, many thanks 👏
@WorkflowWisdom19 күн бұрын
Happy to help!
@gagahguk23 күн бұрын
can you combine =ARRAYFORMULA(SUMIFS(
@WorkflowWisdom19 күн бұрын
Unfortunately, you cannot combine ARRAYFORMULA and SUMIFS in one formula.
@srikrishnanrengarajan610923 күн бұрын
Thanks
@WorkflowWisdom21 күн бұрын
Welcome
@srikrishnanrengarajan610924 күн бұрын
Thanks
@WorkflowWisdom21 күн бұрын
Welcome
@WorkflowWisdom25 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom25 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom25 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
@WorkflowWisdom25 күн бұрын
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈