Hello @jeffbakker7241, You are most welcome. Thanks for your appreciation and feedback. Keep exploring Excel with ExcelDemy! Regards ExcelDemy

Hello @ravinryandomaoal1873, You are most welcome. Thanks for your feedback and appreciation. We are mainly focused on MS Excel but will update the Google Sheets tutorial sooner. We have some tutorials regarding salary sheets/slips. How to Make Salary Sheet in Excel: kzbin.info/www/bejne/inTdq5aFh7mri68 How to Create Salary Slip Format with Formula in Excel Sheet: www.exceldemy.com/salary-slip-format-in-excel-sheet-with-formula/ How to Make a Payroll System with Payslip in Microsoft Excel: www.exceldemy.com/how-to-make-a-payroll-system-in-microsoft-excel-with-payslip/ How to Create Automatic Salary Slip Generator Using Excel: www.exceldemy.com/automatic-salary-slip-generator-using-excel/ You can apply Excel concepts in Google Sheets. Regards ExcelDemy

Hello @Nat-s2b, You are most welcome. Thanks for your feedback and appreciation. Glad to hear our tutorial is easy to follow and helpful. Keep learning Excel with ExcelDemy! Regards ExcelDemy

Hello @sorindiaconescu8660, Thanks for your feedback and appreciation. Thanks for watching our video. Keep exploring Excel with ExcelDemy! Regards ExcelDemy

Hello @lopsidedxi4162, Yes, you can achieve this using a simple formula in Excel. You can use the COUNTIF function to count the number of times the word "day" appears, and then multiply that count by 9.5 hours. Here's an example formula: =COUNTIF(A1:A10, "day") * 9.5 This will count the occurrences of "day" in the range A1:A10 and then multiply that by 9.5 to give the total number of hours. Adjust the range as needed. Regards ExcelDemy

Thank you. Can you associate a few more words like bank holiday, study leave, induction etc’s that counts to 9.5 hours?

Hello @lopsidedxi4162, You can extend the formula by adding more conditions for different words like "bank holiday," "study leave," and "induction." Here's how you can adjust the formula: =COUNTIF(A1:A10, "day") * 9.5 + COUNTIF(A1:A10, "bank holiday") * 9.5 + COUNTIF(A1:A10, "study leave") * 9.5 + COUNTIF(A1:A10, "induction") * 9.5 This will sum up the total hours for each term. You can add more words by following the same pattern, multiplying by 9.5 for each occurrence. Regards ExcelDemy

can't see it😢

Hello @Venus_rey, In our article, you will get all the formulas to use. The article link is given in the description box. Here I am attaching it again: www.exceldemy.com/create-leave-tracker-in-excel/ Regards ExcelDemy

Hello @kaizellekaryllcrisdelmo7614, It sounds like you're encountering an issue with the "Paste Special" feature. Make sure you're selecting the "Formats" option under Paste Special, which should preserve the formatting. If it's still not working, try restarting Excel or checking if any add-ins are interfering. Sometimes, Excel settings or updates might affect how this feature behaves. Regards ExcelDemy

Hello @xiaoyupau01, You are most welcome. Thanks for your feedback and appreciation. Glad to hear our tutorial worked perfectly. Keep learning Excel with ExcelDemy! Regards ExcelDemy

Hello @giuseppedilizio8733, You are most welcome. Thanks for your feedback and appreciation. Glad to hear that our tutorial solved your problem in 2 minutes. Keep learning Excel with ExcelDemy! Regards ExcelDemy

Hello @nathones, To return a value from column G based on whether column B contains a string from column F, you can use the following formula: =IF(ISNUMBER(SEARCH(F1, B1)), G1, "") This checks if the value in column B contains the text from column F. If true, it returns the value in column G; otherwise, it returns an empty string. Adjust the row numbers based on your data. Let me know if you need more help! Regards ExcelDemy

Hello @sivaarunachalam7763, You can use VBA (Visual Basic for Applications) to extract and fix the value from cell A1 at 9:30 AM daily into B1. To open VBA Editor: Press Alt + F11, then click Insert > Module. Copy and Paste the code below: Dim RunTime As Date Sub SetValueAt930AM() If Time >= TimeValue("09:30:00") And Time < TimeValue("09:31:00") Then Sheets("Sheet1").Range("B1").Value = Sheets("Sheet1").Range("A1").Value End If RunTime = Now + TimeValue("00:01:00") Application.OnTime RunTime, "SetValueAt930AM" End Sub Sub StopScheduler() On Error Resume Next Application.OnTime RunTime, "SetValueAt930AM", , False End Sub Run SetValueAt930AM to start capturing the value. You can use StopScheduler to stop the scheduled task. Regards ExcelDemy

Hello @ChrisNCars, You are most welcome. Thanks for your feedback. Glad to hear that this tutorial boost your work. Keep exploring Excel with ExcelDemy! Regards ExcelDemy

Hello @SauvikRoy, Thank you for your comment! To include a hyperlink to the source row, you can use the HYPERLINK function in Excel. For example, if the source data is in Sheet1 and you want to link to cell A2, use the formula: =HYPERLINK("#Sheet1!A2","Link to Source") This creates a clickable link that takes you directly to the source row. Let me know if you need further assistance! Regards ExcelDemy

@exceldemy2006 Thank you for your reply. I just wanted to reference an entire column across tables in 2 different worksheets. A particular row when clicked, should take me to the exact row in the table.

Hello @SauvikRoy, Thank you for clarifying! To reference an entire column and link a specific row across worksheets, you can use the HYPERLINK function dynamically with the CELL function. For example: =HYPERLINK("#Sheet1!A"&ROW(), "Go to Source Row") This will create a clickable link in each row of your table that takes you to the corresponding row in the source worksheet. Regards ExcelDemy

@@exceldemy2006 thank you! it works! I used: HYPERLINK("#Sheet1!A"&ROW(), Sheet1!C2) And then dragged it for rows below! It saved hours of painful work!

@@exceldemy2006 it works! thank you! it saved hours of work for me!

Hello @kishoresairam, You're welcome! The issue arises because links between Excel files work only when the file paths are consistent. The link paths break when files are moved from a shared folder to a local drive. To resolve this: 1. Ensure files use relative paths instead of absolute ones if they stay within the same folder structure. 2. After moving the files, update the links in Excel by navigating to the Data tab >> Edit Links >> Change Source. 3. Use cloud services (e.g., OneDrive) to maintain seamless links online and offline. Let me know if further clarification is needed! Regards ExcelDemy

Hello @hamzawaheed4792!, You're most welcome. Glad to hear the formulas are all set now. Let me know if you need further help! Keep learning Excel with ExcelDemy! Regards ExcelDemy

Hello @yodathedeathshadow, Glad to hear the video is helpful to you. Thank you so much for the kind words! 😊 We appreciate your support and wish you all the best! Let us know if you need further help! Keep learning Excel with ExcelDemy! Regards ExcelDemy

Hello @onebunnechisom7874, You are most welcome. Glad to hear that you created the worksheet for 2024. To manage employee exits and entries on your summary sheet, you can follow these steps: For resignations: Remove the employee’s leave record from the active sheet but retain their historical data for past leave tracking. For new hires: Add their details with the appropriate start date. Formula adjustment: Use IF or IFERROR formulas to calculate leave based on their joining date and tenure. This ensures that the summary sheet remains accurate even with employee transitions throughout the year. Regards ExcelDemy

@exceldemy2006 thank you so much for this. I will implement it and see how that goes.

Hello @onebunnechisom7874, You are most welcome. We are glad you found the guide helpful. Best of luck implementing the solutions. Let us know how it goes or if you need further assistance! Regards ExcelDemy

Hello @dk5289, To create a sequence that starts at 0 and increases up to the value of n for each row in Excel, you can use a formula like this: =SEQUENCE(A1+1, 1, 0) Where A1 holds your desired n value. This formula generates a vertical list starting at 0 up to n. =TRANSPOSE(SEQUENCE(A1+1, 1, 0)) This formula generates a horizontal list starting at 0 up to n. Regards ExcelDemy

Hello @belle2046, It looks like you're referring to a timestamp in the video. Could you clarify if you're asking about something specific at 0:24:00? I'd be happy to help with any questions or comments you have about that part of the video! Regards ExcelDemy

Hello @Stephen_809, The reason for subtracting the payment without interest in cell E5 is to account for the payment made before interest is applied. The starting balance is indeed the amount you owe (like in cell H4), but the subtraction reflects the reduction in the balance after the payment is deducted before interest charges are calculated. This ensures that you're accurately tracking the amount remaining after your payment is made. Regards ExcelDemy

Hello @JustinSohail, To track employees who frequently take leaves on Fridays and Saturdays, you can customize your leave tracker by using conditional formatting to highlight these specific days. You can set up a formula to check if the leave date falls on a Friday or Saturday, then flag or count them accordingly. Additionally, you can create a summary table or pivot table to track the number of leaves taken on these days for easy monitoring. Regards ExcelDemy

Hello @Teesh1812, You are most welcome. To align the leave year with your financial year (April to March), you can adjust the leave balance formulas to reset in April. One approach is to use an IF formula that checks if the current date is after March and then resets the leave balance accordingly. You can also modify the year reference in your tracker to match this period. Regards ExcelDemy

Hello @ErinWells-o9n, It sounds like you're encountering an issue with filter visibility in a shared workbook. Filters in Excel are local to the user, meaning they only affect the person who applies them. To ensure that others can see the same filtered view, you can either: Share the filter settings: Have everyone apply the same filter by either creating a shared view (in Excel for Microsoft 365) or manually applying it. Use a Filter View (for Google Sheets or in shared Excel workbooks): If you're using Google Sheets, you can create filter views so that others see the same filtered data. If you want to send a filtered version by email, you may want to create a copy of the filtered data and share that file instead. Regards ExcelDemy

Hello @kaioumhossain6511, To merge rows in Excel, you’ll need to merge the cells across the row instead, as Excel does not directly support merging entire rows. To merge rows in Excel, you can use the "Merge & Center" option. 1. Select the cells you want to merge, 2. Go to the Home tab >> click Merge & Center under the Alignment group. For additional merging options, click the dropdown next to Merge & Center to choose options like Merge Across or Merge Cells. Regards ExcelDemy

Hello @markbozinovic706, You are most welcome. Thanks for your appreciation, it means a lot to us. Glad to hear the video was helpful and informative. Keep learning Excel with ExcelDemy! Regards ExcelDemy

Hello @isaacassabil3135, Thanks for your appreciation and glad to hear that. To preserve leading zeros in a CSV, try formatting your data as text before saving the file. 1. Select the cells with leading zeros, and format them as "Text". 2. Right-click > Format Cells > Text and then save as CSV. Another method is to prefix values with an apostrophe (') to retain zeros when importing the CSV back into Excel. This workaround will help keep leading zeros visible when opening or sharing the CSV. Regards ExcelDemy

Hello @LordHeath1972, You are most welcome. I'm glad that it was helpful and easy to understand. Thanks for your appreciation and feedback. Keep learning Excel with ExcelDemy! Regards ExcelDemy

Hello @roberth.9558, You are most welcome. Thanks for your appreciation and feedback. Keep learning Excel with ExcelDemy! Regards ExcelDemy

Hello @JigmeWangchuk-k8h, You are welcome. Keep learning Excel with ExcelDemy. Regards ExcelDemy

Hello @giovannialdarondo9481, You can use Excel's COUNTIF function combined with conditional formatting to capture duplicate names using a similar formula. This will highlight or identify duplicates within your range. For example, you could set up a formula like =COUNTIF(range, name) > 1 To detect names that appear more than once. Let me know if you'd like specific guidance on how to apply this! You can use another formula to identify duplicate names by using UNIQUE and FILTER together. =FILTER(range, COUNTIF(range, range) > 1) This formula will return only the names that appear more than once in your selected range. Let me know if you need additional details on setting it up! Regards ExcelDemy

Hello @karencitalegrand8391, You are most welcome. Thanks for your appreciation, it means a lot to us. Glad to hear that our explanation was easy and helpful to you. Keep learning Excel with ExcelDemy! Regards ExcelDemy

Hello @nssupplyllc, The error ByRef argument type mismatch often happens when the argument passed to a procedure or function doesn’t match the expected type. In your case, lastRow(database) might not be set up correctly to accept the database as an argument. 1. Ensure that lastRow is defined to accept a Worksheet type argument. Function lastRow(ws As Worksheet) As Long lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row End Function 2. Add declarations at the beginning of your code to avoid ambiguity. Dim database As Worksheet Dim r As Long Dim db_range As String 3. Update your UserForm_Activate code as follows: Private Sub UserForm_Activate() Set database = Worksheets("Sheet1") r = lastRow(database) + 1 db_range = "A1:G" & r End Sub This should address the error, assuming lastRow is properly defined to accept a Worksheet argument. Regards ExcelDemy

Hello @Mr_AlcoN, Worksheets(Target_Sheet) are a way to reference a specific worksheet in VBA. Target_Sheet should be the name or index number of the sheet you want to work with, enclosed in quotes if it's a name (e.g., Worksheets("Sheet1") for a sheet named "Sheet1"). If the code is obscured, try resizing the window or using the scroll bar to view more. Regards ExcelDemy

​@exceldemy2006 omg, it is your window in the video that is obscuring so you cant see the full code, look at 6:30 on your video. Interested to know what part fell away due to this.

Hello @Mr_AlcoN, Apologies for the obscured code at 6:30 in the video! To make it easier, we’ve provided a link in the video description where you can find the full VBA code to copy and paste directly. In the code, Worksheets("Target_Sheet") refers to the specific sheet by name (or index) you’re working with in VBA. Thank you for bringing this to our attention! Regards ExcelDemy Team

Hello @kingdomheartministries2402, You are most welcome. Thanks for your appreciation. Keep learning Excel with ExcelDemy! Regards ExcelDemy

Hello @Suma7777-qh4nn, Glad to hear that. Thanks for your support. We’re excited to hear that you’re looking for more videos. Stay tuned more content is on the way to help you dive deeper into Excel and VBA tips. Let us know if you have any specific topics you’d like covered! Regards ExcelDemy

Hello @rensigua1213, We created the extended dataset manually. However, you can create an extended dataset manually or generate it programmatically, depending on your needs. For demonstration or testing purposes, manually entering sample data or using Excel's fill options can work. Alternatively, you could use formulas or scripts to automate the creation of a larger dataset. Regards ExcelDemy

Hello @alihamza-il8dq, Thank you for your comment! This article covers creating a Forex trading journal in Excel, where the table format includes built-in filters. You can use the filter arrows on each column to view specific trades. We’ll also consider adding a full video tutorial on applying filters for more clarity. Let us know if there’s anything specific you’d like to see! Regards ExcelDemy

I want to cahk day filter weak filter monthly filter also add how many sl in weak in month and also tp ​@@exceldemy2006

Hello @alihamza-il8dq, To filter by day, week, and month, you can use Excel’s built-in filter options along with custom date columns. Here’s a quick guide: 1. Add Helper Columns: Insert columns to extract the day, week number, and month from your date column using Excel functions like TEXT (for the day) and WEEKNUM. 2. Apply Filters: Use the filter arrows on these helper columns to view data for specific days, weeks, or months. 3. Count SL and TP: Add a column for SL (Stop Loss) and TP (Take Profit) counts, then use Excel’s COUNTIF function to total these by week or month. Regards ExcelDemy

Hello @dude244342, The month starts on the 3rd of May because the 'Month Starting Date' in cell E5 is set to 3, meaning that the calendar dynamically begins from the third day of the month. This setup likely allows flexibility to start the monthly schedule from any chosen date instead of always defaulting to the 1st. If you'd prefer the dates to start from the 1st, try changing the value in the 'Month Starting Date' cell to 1. Let me know if you need help with this adjustment! Regards ExcelDemy

thanks, i had just failed to see the logic.

You are most welcome. Keep exploring Excel with ExcelDemy!

Hi @fernandomadruga, Thank you for your feedback! Unfortunately, some features are indeed Windows-specific, and Microsoft hasn’t yet made them available in Excel for Mac. Hopefully, future updates will bring more feature parity between the two versions. Thanks for sharing this important note. For Mac users, there are alternative methods to achieve autofill-like functionality. One option is using Excel’s Data Validation feature to create dropdown lists for easy data entry. You can also leverage AppleScript or VBA macros on Mac to automate filling cells, though VBA on Mac has some limitations compared to Windows. Additionally, Excel for Mac’s latest updates sometimes add Windows features, so it’s worth keeping Excel up-to-date. Regards ExcelDemy

Hello @thesith-f1t, You are most welcome. Thanks for your appreciation. Keep learning Excel with ExcelDemy! Regards Shamima Sultana ExcelDemy

Hello @tructran8304, You are most welcome. Thanks for your appreciation. Keep learning Excel with ExcelDemy! Regards Shamima Sultana ExcelDemy

Hello @mobeenalam3356, You are most welcome. Thanks for your appreciation. Glad to hear that our video made it easy for you. Keep learning Excel with ExcelDemy! Regards Shamima Sultana ExcelDemy

Hello, You are most welcome. Thanks for your appreciation. Keep learning Excel with ExcelDemy! Regards Shamima Sultana ExcelDemy

Hello Dear, You are most welcome. Thanks for your appreciation. Keep learning Excel with ExcelDemy! Regards Shamima Sultana ExcelDemy

Hello @rodrigoalejandreperez848, You're most welcome! Using table names is indeed beneficial for expanding data ranges. For an n relationship, creating an intermediate (or "junction") table is a good approach. This table typically holds unique entries that link records between the two tables, with each row representing a combination from each dataset. You can set it up in Excel by listing IDs from both tables in separate columns, making it easy to reference in PivotTables or other analyses. Keep learning Excel with ExcelDemy! Regards Shamima Sultana ExcelDemy

Hello @jschwone2607, You are most welcome. Thanks for your appreciation. Keep learning Excel with ExcelDemy! Regards ExcelDemy

Hello @chrisbooth8813, You can use the FILTER function in Google Sheets to achieve this. Here’s a formula that should work for your case: =ARRAYFORMULA(FILTER(F:F, ISNUMBER(SEARCH(E:E, B:B)))) This formula checks if the values in column E exist within the text strings in column B and, if they do, returns the corresponding values from column F. The SEARCH function identifies if there's a match, while ISNUMBER converts the results to TRUE or FALSE, allowing FILTER to pull only the matched rows. Ensure the ranges (E, B, F) cover your entire dataset. Regards ExcelDemy

Hello @easilyburnfat, You are most welcome. Thanks for your appreciation. Glad to hear that it is useful to you. Keep learning Excel with ExcelDemy! Regards Shamima Sultana ExcelDemy

Hello @avec5883, You're most welcome! I'm so glad the video helped you avoid all that extra work. That little fill handle in the bottom-right can be a lifesaver when copying formulas across cells. Thanks for the feedback, and best of luck with your assignment! Keep learning Excel with ExcelDemy! Regards Shamima Sultana ExcelDemy