- Видео 5
- Просмотров 73 391
TheExcelU
Добавлен 17 фев 2013
Webcast #5 Formula to Pull Worksheet Tab Name into your workbook
www.TheExcelU.com
The following Microsoft Excel formula will pull the tab name into a cell of your worksheet:
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))
Copy the above formula and post it into your worksheet.
Please be sure to checkout our other webcast at www.TheExcelU.com
Please be sure to connect with me on LinkedIn: www.MikeOnLinkedIn.com
The following Microsoft Excel formula will pull the tab name into a cell of your worksheet:
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))
Copy the above formula and post it into your worksheet.
Please be sure to checkout our other webcast at www.TheExcelU.com
Please be sure to connect with me on LinkedIn: www.MikeOnLinkedIn.com
Просмотров: 2 663
Видео
Webcast #4 INDIRECT Function - Gather Data From Multiple Tabs
Просмотров 67 тыс.11 лет назад
www.TheExcelU.com In this webcast I review how to pull data from multiple tabs using the INDIRECT Function. You will learn how this function can be used to reference sheet tab names to retrieve a specific cell from multiple worksheets. Please be sure to checkout our other webcast at www.TheExcelU.com Please be sure to connect with me on LinkedIn: www.MikeOnLinkedIn.com
webcast_3_visual_basic_unhide_all_tabs
Просмотров 13911 лет назад
www.TheExcelU.com Wecaste - Episode #3 Visual Basic to Unhide All Tabs. Use the following code in Microsoft Excel Visual Basic to create a macro to unhide all tabs at one time: Sub UnhideAll_tabs() Dim ws As Worksheet Application.DisplayAlerts = False For Each ws In ActiveWorkbook.Worksheets ws.Visible = True Next ws Application.DisplayAlerts = True End Sub Find my additional Excel webcast on R...
Webcast 2 - IFERROR Functions
Просмотров 1,1 тыс.11 лет назад
www.TheExcelU.com This webcast review how to use the IFERROR function in Microsoft Excel. The IFERROR function can only be used in Microsoft Excel 2007 or newer. The IFERROR function is used to remove error codes from your formulas that display on your workbooks. The IFERROR function will allow you to display custom message in place of the following error codes: #N/A, #VALUE!, #REF!, #DIV/0!, #...
The VLOOKUP and TRIM Formulas
Просмотров 2,8 тыс.11 лет назад
www.TheExcleU.com. Learn how to use the VLOOKUP formula in Microsoft Excel. Learn how to trouble shoot for errors and use the TRIM formula. Quick Tip - learn a shortcut to display all formulas on a worksheet. We discuss all parts of the VLOOKUP formula: Lookup_value, Table_array, Col_index_num, and Range_lookup. I also show an example of when it is the correct time to use the "True" for the Ran...
I DON'T KNOW BUT ITS NOT WORKING IN MY EXCEL
Next time make video visible that we can see it
Suppose in the last sheet, Jan is repeated twice and i want to find the sum dynamically, how to integrate indirect with sumifs in that case??
Excelent video. Thanks a ton.
you are the Genius. Thanks a lot for the you explain. i was looking for this answer when sheet name has space. thanks a lot . wish you good luck
This doesnt work for me getting #REF! error
Hi guys if im on Google sheets and My tabs are numbers, it doesn’t work. Any advice
I found out a problem. Although the rand and rank functions work well on my simple quiz excel sheet (selecting random questions for users), the content change every time when a user only edit an answer field. This is not only annoying but also messing up the answer corresponding to the original question. Is there a way to stop refreshing please? Thanks a lot for comment.
Thank you
Thank you so much. It made the work so easy.
Can you do the same but in google sheets?
Very useful , Thank you that i lookink for.
Can anyone venture a guess as to why i might be getting #REF errors when trying to do exactly this?
same here!
You earned a new subscriber. This video helped me get what another video was trying to explain. Yours was clearer for this section. Thank you.
very useful...
since when is ! a quote?
If I added a sumif to this indirect function, will it still drag/fill down and across? I created a formula which works well but won't fill/drag. I have a feeling it has to do with too many ampersands but I am honestly not sure. Essentially I am trying to do a 3-d sum if (avoiding using VBA).
Very good technique, it's one of the strong formula in excel