User Profile
Vinod_Sir
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Goal Seek use + instead of Formula
When you use Goal Seek in Excel, it might not work right if you use a SUM formula. The results can look confusing. Try to understand what value you want to reach and which number needs to change. Instead of just summing, focus on the actual gap or target. Set Cell should be the formula you're trying to solve. To Value is the number you want to get. By Changing Cell is the input Excel should change. Set it up properly and Goal Seek will work instantly. Hope this helps someone. Just sharing a quick tip. Thanks.94Views0likes1CommentRe: OneDrive link not working once shared
This is well known issues while we working on 365 few options I could recommend Try sharing the folder instead of the video file, check permissions ( when you share it ensure you double check settings), use a different browser( Edge recommend or Chrome ) disable extensions ( some times we install extension which block ads it may cause this issue few security antivirus turned off those ) This possibility to solve your issue291Views0likes0CommentsRe: EXCEL
To highlight matching values: ( Conditional Formatting in Excel will help ) Let's Follow Along Step1 - Select the column in Sheet1. Step2 - Go to Conditional Formatting > New Rule. Step3 - Choose Use a Formula and enter: =COUNTIF(Sheet2!A:A, A1)>0 Step4 - select any formatting in this case pick color code42Views0likes0CommentsCTRL + Enter in Excel for data entry
Quick tip to use CTRL + Enter which will help to get similar value on rest of the other space meaning I have 2024 want to paste that A1 to A10 instead of copy and paste simply select range from A1 to A10 in blank type 2024 and press CTRL + Enter and get all values pasted from the A1 to A10 you can see magic :sparkles: 🪄 🪄494Views0likes2CommentsCOPILOT for Excel 2003
We understand ☺️ copilot is newly launched and majorly focusing on office 365 and the business user can access it as office 365 personal user don't have access for copilot I wish if there is way to create API or Chance to add COPILOT in office 365 personal and Excel Users of 2023 open AI is rapidly increasing we want COPILOT to reach276Views0likes1CommentAutomate Ribbon instead VBA script
Glad find useful resource where can share my best practices , in my case I had data present sr number , emp name , sales , order date , month, week and email id along with other fields untill BB column of excel now wish to see the data in pivot normally we use pivotable manually do a pivot in our excel for me find this call Automate ( Script ) loved to use this used below code find useful result function main(workbook: ExcelScript.Workbook) { // Define the range let dataSheet = workbook.getActiveWorksheet(); let dataRange = dataSheet.getRange("A1:BB50"); // Read data into a 2D array let dataArray = dataRange.getValues(); // Initialize variables for summary let summary = {}; // Loop through the data to calculate sales by month dataArray.forEach(row => { let month = row[0]; // Assuming the month is in the first column let sales = row[1]; // Assuming sales data is in the second column if (!summary[month]) { summary[month] = sales; } else { summary[month] += sales; } }); // Prepare the summary data for output let summaryArray = []; for (let month in summary) { summaryArray.push([month, summary[month]]); } // Output the summary to a new worksheet let summarySheet = workbook.addWorksheet("Summary"); let summaryRange = summarySheet.getRange("A1:B" + (summaryArray.length + 1)); summary Range.setValues(summaryArray); } If you want to leverage this automate script you can do this is available in my premium account of office 365 you can check :white_heavy_check_mark: yours if it's available in ribbon :ribbon: Please note - it's not macro519Views0likes0CommentsAttrition Rate calculation in Excel
To calculate Attrition in every MNC company they use formulas as below ( sharing own industry experience across wide range of community) MTD - Total Nos of attrition/ Total Nos of Head count YTD - total attrition from starting month to end month / average HC of starting month to end month Don't forget in headcount calculation we will also consider headcount attrited as a total calculationSolved898Views0likes1Comment
Groups
2026 MIE Expert Community
Join MIE Experts transforming learning through Microsoft's innovative tools.Recent Blog Articles
No content to show