Email Active Sheet in Excel
7:59
6 ай бұрын
Пікірлер
@meesterkoen1018
@meesterkoen1018 13 сағат бұрын
Is it possible to use a second column with different values to rank the numbers that have the same value in the first column, like you can do with a filter?
@HanyAlfy
@HanyAlfy 5 күн бұрын
Awesome
@realmehranvahedi
@realmehranvahedi 10 күн бұрын
📺 Don't forget to also watch my other video on this very same topic for more valuable information: kzbin.info/www/bejne/bWOrhHhjZ9WrkMk 🔍 Got questions? Drop them in the comments below! For a detailed consultation or to have specific, customized questions answered, book a paid session with me at: topmate.io/mehran_vahedi 🌟 If you found this video helpful, please give it a thumbs up, share it, and subscribe to the channel for more insights! Your support means a lot and helps keep this content coming. 🚀 Thanks for watching, and I look forward to seeing your thoughts and questions!
@echoesofhonor
@echoesofhonor 13 күн бұрын
Hello, i wanted to ask a question... I have been paid a milestone a long time now and money is not in my Upwork balance, I have moved the funds outside of Upwork. What if i refuse arbitration and client pays, where will Upwork find the money to fully refund the client?
@realmehranvahedi
@realmehranvahedi 13 күн бұрын
Hi @echoesofhonor, great question! When a milestone is paid and the funds are moved outside of Upwork, they are no longer in Upwork's system. If there's a dispute and the client pays the arbitration fee but you don't, the client automatically wins the dispute. Upwork might then issue the refund to the client first and subsequently seek to recover the amount from you, potentially billing the payment method you have on file. This could include potential account restrictions or even suspension if you refuse to participate in the arbitration and also fail to refund the client. Conversely, if only you pay the arbitration fee and the client doesn’t, you'll automatically win the dispute. The arbitration fee will be returned to you, and you'll retain the amount claimed by the client. It's important to handle disputes thoughtfully as refusing arbitration could lead to further actions from Upwork, including potential account restrictions or financial liabilities. Always engage in the resolution process to find a fair outcome for both parties. Please note that I am not a legal expert, and this information is based on general experiences and understanding of Upwork's policies. It's a good idea to consult directly with the Upwork dispute team for specific advice. Also, feel free to ask more questions here-others in similar situations might benefit from the discussion as well. Thanks again for your comment, and I hope this helps!
@christopherfunakoshi1272
@christopherfunakoshi1272 23 күн бұрын
Thank you much for creating this video.
@realmehranvahedi
@realmehranvahedi 22 күн бұрын
Thanks a lot, @christopherfunakoshi1272! I’m really glad you enjoyed the video. Stay tuned for more content coming soon! 😊
@andreasmaier7013
@andreasmaier7013 23 күн бұрын
Wonderful, finally someone who can explain this topic! Thanks!
@realmehranvahedi
@realmehranvahedi 23 күн бұрын
@andreasmaier7013 Thank you so much for your kind words! I'm thrilled to hear you found the explanation helpful. Stay tuned for more cool Excel tips and tricks-I've got plenty more to share that I think you’ll find useful. Appreciate your support! 😊📊
@cyberburnzy
@cyberburnzy 29 күн бұрын
This is what worked for me -> 0.00;-0;;@
@realmehranvahedi
@realmehranvahedi 19 күн бұрын
Hey @cyberburnzy, thanks for sharing your approach! It's a great tip, and I'm excited to announce that I'll be creating a new video featuring it very soon. Keep an eye out! 😊👍
@realmehranvahedi
@realmehranvahedi 10 күн бұрын
Hi @cyberburnzy, I wanted to personally thank you for your valuable suggestion on enhancing Excel charts by hiding zeroes while keeping crucial decimal points. Inspired by your tip, I’ve created a video that dives into this technique to help others in the community make their data look clean and professional. You can check out the video here: kzbin.info/www/bejne/e6bNgKKlr9mLiKs Thank you for sharing your insights with the community! Your engagement helps us create more helpful content and keep delivering high-quality Excel tips to our community. If you have any more thoughts or suggestions, please feel free to share them. Thanks again for your contribution, and keep excelling! Mehran
@angelodeocampo3643
@angelodeocampo3643 Ай бұрын
is there a way to do this using an array formula instead of dragging down?thank you
@realmehranvahedi
@realmehranvahedi Ай бұрын
Hello @angelodeocampo3643, Thank you so much for your question! It's a great topic that many find challenging. I'm thrilled to share a solution that achieves exactly what you're asking for using an array formula in Excel for Office 365. Here's the formula we can use: =BYROW(A2:A17, LAMBDA(row, IF(COUNTIF(A$2:row, row) > 1, "", row))) Sure, here’s a crafted response for your KZbin commenter: Hello @angelodeocampo3643, Thank you so much for your question! It's a great topic that many find challenging. I'm thrilled to share a solution that achieves exactly what you're asking for using an array formula in Excel for Office 365. Here's the formula we can use: =BYROW(A2:A17, LAMBDA(row, IF(COUNTIF(A$2:row, row) > 1, "", row))) This formula uses BYROW to process each row individually in the range A2 The LAMBDA function takes each row and checks how many times its value has appeared up to that point using COUNTIF. If a value appears more than once, it returns an empty string for that row, ensuring only the first occurrence is displayed and subsequent ones are left blank. This is an array formula, so just enter it in the first cell (e.g., C2), and it will automatically handle the entire column dynamically-no need to drag down! If you have any more questions or need further explanation, feel free to ask. Your question has inspired me to create a new video explaining this solution in more detail, so stay tuned for that! Thanks again for bringing up such a valuable topic. You're the motivation behind this upcoming video, and I'm excited to delve deeper into it! Best regards, Mehran
@roxanachichi
@roxanachichi Ай бұрын
Hi. how about if i need letter after ZZ?
@realmehranvahedi
@realmehranvahedi Ай бұрын
Hello @roxanachichi, Thank you for this very interesting question! I'm glad you brought this up. I've developed a formula that continues the sequence after "ZZ" and goes into "AAA", "AAB", etc. Here’s the formula you can use: =IF(ROW(A1)-1<26, CHAR(65+ROW(A1)-1), IF(ROW(A1)-1<702, CHAR(65+INT((ROW(A1)-1)/26)-1) & CHAR(65+MOD(ROW(A1)-1,26)), CHAR(65+INT((ROW(A1)-1)/676)-1) & CHAR(65+MOD(INT((ROW(A1)-1)/26)-1,26)) & CHAR(65+MOD(ROW(A1)-1,26)) ) ) Just place this in the first cell of a column in Excel and drag down to extend the sequence as needed. This setup will reset at "AAA" after "ZZ". I'm also planning to create another video on this topic to explore it further. Feel free to ask any more questions you might have, and stay tuned!
@realmehranvahedi
@realmehranvahedi Ай бұрын
🔗 Using an older version of Excel? Watch my tutorial on INDEX MATCH for similar results: kzbin.info/www/bejne/a4rTiaKVnpeer6M 👇 Post your questions or comments below! Your feedback is appreciated. 👍 Like, Share, and Subscribe for more Excel tips!
@jenakaffee
@jenakaffee Ай бұрын
For me, I use the method: click the Chart, go to "Chart Design" on the toolbar, click "Select data" (or right click the chart to show the context menu), click "Hidden and Empty Cells", select Show empty cells as "Gaps", and "Show #N/A as an empty cell"
@jeffreyburnwood8084
@jeffreyburnwood8084 Ай бұрын
Beautifully explained! Thank you so much!
@realmehranvahedi
@realmehranvahedi Ай бұрын
Thanks so much for your kind words, Jeffrey! I’m thrilled to hear you enjoyed the video. Stick around for more tips and tutorials just like this one. And if there's a specific topic or challenge you're facing that you'd like me to cover, don't hesitate to let me know! Keep watching and learning with us! 🌟
@realmehranvahedi
@realmehranvahedi Ай бұрын
🌟 Master Excel with INDEX MATCH! Learn to retrieve the last non-empty value in a list for better data management. 📽 Next Up: Explore finding the last value in a column ignoring blank cells in this video: kzbin.info/www/bejne/rYrUm4yfe8drbdE 🔗 Need Help? Book a one-on-one session here: topmate.io/mehran_vahedi 💖 Support My Work: Consider buying me a coffee here: buymeacoffee.com/mehranvahedi 👍 Like, Share, and Subscribe for more tips! #ExcelTutorial #IndexMatch
@jeffreyburnwood8084
@jeffreyburnwood8084 Ай бұрын
Hi! Thank you for your videos! I’ve been checking them for guidance, but now I’m stuck. Is there a way to make this function to stop with “Rachel” and not count “Jack” until Jack is moved to the next cell after “Rachel”? I’ve tried a mix of your formulas, but can’t really figure this out :( Cheers!
@realmehranvahedi
@realmehranvahedi Ай бұрын
Hi @jeffreyburnwood8084 , Thank you very much for reaching out and for the interesting question! I've crafted a formula that should precisely meet your requirements for finding the last value in a column right before any empty cells. You can use the INDEX MATCH formula below to get exactly what you are seeking. Here it is: =INDEX(B:B, MATCH(TRUE, INDEX(ISBLANK(B:B), 0, 1), 0) - 1) Please try this solution in your Excel sheet and let me know how it works for you. Your feedback helps improve the content I provide. Also, feel free to share any other questions or comments you might have. Looking forward to your response! Best regards, Mehran
@jeffreyburnwood8084
@jeffreyburnwood8084 Ай бұрын
@@realmehranvahedi hello! It worked flawlessly! Thank you very much! I was using Index too, but somehow it was always showing the previous entry, and if a name was added after the blank, it would show the name on the previous 3 cells and so on, lol. Again, thank you very much!
@realmehranvahedi
@realmehranvahedi Ай бұрын
@@jeffreyburnwood8084 Hi, I'm so glad to hear that it worked flawlessly for you! 😊 Thank you for your kind words and for sharing your experience. It’s great to know that the solution helped you out. Your feedback and interesting questions have given me some great ideas for future content. I’m planning to create and publish a new video on this topic soon, so stay tuned for more detailed insights! Thanks again, and if you have any more questions or need further assistance, feel free to reach out! Best, Mehran
@jeffreyburnwood8084
@jeffreyburnwood8084 Ай бұрын
@@realmehranvahedi thank you so much for your kind words and for the time you took! I’ll be on the lookout for your content! Take care!
@realmehranvahedi
@realmehranvahedi Ай бұрын
Hi @@jeffreyburnwood8084, as promised I have created and published the aforementioned video demonstrating how to use the INDEX MATCH formula in order to find the last value in a column before the first blank cell. Check it out via the link below and let me know what you think and as always feel free to post your questions and comments : kzbin.info/www/bejne/eZ-rdax7o5t1mdEsi=qAx26wvMxsWmO8Jg
@mudassirahmedi5617
@mudassirahmedi5617 Ай бұрын
I am trying to paste from another sheet and it showing error , the paste area and copy area are not matching
@realmehranvahedi
@realmehranvahedi Ай бұрын
Hello @mudassirahmedi5617, Thanks for reaching out with your question! It sounds like you’re encountering a common issue where the copy and paste areas do not match. I've covered solutions to this problem in my recent videos. Particularly, in my latest video posted two weeks ago, I demonstrate how to handle this using VBA. You can find it here: kzbin.info/www/bejne/gqbSc4mPetOEfdE If you prefer not to use VBA, these two videos should help clarify and provide alternative solutions: Video 1: kzbin.info/www/bejne/nnSUc4Rrj9h-jdk Video 2: kzbin.info/www/bejne/emPbd3yelrZobNk I’m confident these videos will help resolve the error you're experiencing. Please let me know how it goes! And don’t hesitate to post any other questions or comments you might have, whether it's about this issue or any other topic. Your feedback is invaluable and helps improve our community. Cheers, Mehran
@emilieguillon30
@emilieguillon30 Ай бұрын
Hi thanks for this video. How do you do if you want to paste ABCD and not ABGH in the lines 3-4-9-10 ? Is it doable ? Thanks in advance for your answer.
@realmehranvahedi
@realmehranvahedi Ай бұрын
Hello @emilieguillon30, Thank you so much for your question and for watching the video! To specifically address your query about pasting "ABCD" instead of "ABGH" in specific lines, I recommend checking out these videos where I cover the exact topic you're interested in. These videos indeed provide the tips and steps you need: Video 1: kzbin.info/www/bejne/a5DRm6J3i62krsksi=BZNdNTiqlrbOW8an Video 2: kzbin.info/www/bejne/nnSUc4Rrj9h-jdksi=4KKuXgcIepJTNA2J Video 3: kzbin.info/www/bejne/gqbSc4mPetOEfdEsi=4H8lepmhg7XDzoNz I'm confident these will address the issue you’re facing. Please keep the comments coming and feel free to ask any more questions you might have. Your engagement is invaluable and inspires me to continue providing helpful content! Cheers, Mehran
@josnooy6844
@josnooy6844 Ай бұрын
Thanks!
@realmehranvahedi
@realmehranvahedi Ай бұрын
@josnooy6844 Thanks for your comment! I'm glad you enjoyed the video. Feel free to post any further questions or comments you might have-I look forward to hearing more from you!
@MichelleCrecelius
@MichelleCrecelius Ай бұрын
When I followed these instructions, all my cells that I wanted to got filled but only with the first cell that I selected from my copy column. It was in a different Excel file but I didn't think that would matter. I'm not sure what I'm doing wrong.
@realmehranvahedi
@realmehranvahedi Ай бұрын
Hi @MichelleCrecelius , Thanks for reaching out with your question. It sounds like you might be experiencing an issue with how Excel handles the 'Paste Special' function when dealing with data copied from another file. Make sure that after you select "Visible cells only" using the "Go To Special" dialog, you're copying the cells you want to paste into. Sometimes, Excel can default to pasting only the first copied cell across all selected visible cells if not done correctly. Also, I recommend checking out my latest videos on this very same topic for more tips and detailed steps that might help resolve your issue: Video 1: kzbin.info/www/bejne/a5DRm6J3i62krsksi=BZNdNTiqlrbOW8an Video 2: kzbin.info/www/bejne/nnSUc4Rrj9h-jdksi=4KKuXgcIepJTNA2J Video 3: kzbin.info/www/bejne/gqbSc4mPetOEfdEsi=4H8lepmhg7XDzoNz These should give you more insight and possibly address the issue you're facing. Feel free to post any further questions you might have! Cheers, Mehran
@TrongYangLim
@TrongYangLim Ай бұрын
Thank you very much for the super helpful video. Your kind effort is deeply appreciated.
@realmehranvahedi
@realmehranvahedi Ай бұрын
Hi @TrongYangLim , Thank you so much for your kind words! I'm thrilled to hear that you found the video helpful. If you have any questions or need further clarification on any points, please don't hesitate to ask. Looking forward to hearing from you again!
@TrongYangLim
@TrongYangLim Ай бұрын
@@realmehranvahedi 🥰
@RohitKudalkar
@RohitKudalkar Ай бұрын
Hlw sir How i can only link Filtered Data (Visible Cells)
@realmehranvahedi
@realmehranvahedi Ай бұрын
Hi @RohitKudalkar, thanks for your question! To link @RohitKudalkar Hi Rohit, thanks for your question! To link only the filtered data or visible cells in Excel, you can use the "Go To Special" feature. After filtering your data, select the range you want to link, go to "Find & Select" on the Home tab, and then choose "Go To Special". Select "Visible cells only" and press OK. Now, only the visible cells are selected, and you can copy and link them as needed. If you have any more questions on this or any other topic, feel free to ask. Also, you might find it helpful to check out my previous 3 videos on similar topics: Video #1: kzbin.info/www/bejne/a5DRm6J3i62krsk Video #2: kzbin.info/www/bejne/emPbd3yelrZobNk Video #3: kzbin.info/www/bejne/nnSUc4Rrj9h-jdk Hope this helps, and looking forward to hearing more from you! Regards, Mehran
@kubikrube784
@kubikrube784 Ай бұрын
Awesome Sessions mate - Clear and Easy to Understand - Effective outcomes
@realmehranvahedi
@realmehranvahedi Ай бұрын
Hi @kubikrube784 Thank you so much for your kind words! It truly means a lot to me. I'm glad you found the sessions effective. Feel free to share any more thoughts or questions you have in future comments-I look forward to hearing from you!
@Isabella-l8g5s
@Isabella-l8g5s 2 ай бұрын
What are the best strategies to protect my portfolio? I've heard that a downturn will devastate the financial market, so I'm concerned about my $200k stock portfolio.
@Benedict-s7d
@Benedict-s7d 2 ай бұрын
There are strategies that could be put in place for solid gains regardless of economy situation, but such execution is usually carried out by an investment specialist
@Aurora-g5x
@Aurora-g5x 2 ай бұрын
I've been in touch with a financial analyst ever since I started investing. Knowing today's culture The challenge is knowing when to purchase or sell when investing in trending stocks, which is pretty simple. On my portfolio, which has grown over $900k in a little over a year, my adviser chooses entry and exit orders
@Charlotte-t6l
@Charlotte-t6l 2 ай бұрын
Mind if I ask you to recommend this particular coach you using their service? Seems you've figured it all out.
@Aurora-g5x
@Aurora-g5x 2 ай бұрын
ANGELA LYNN SCHILLING' is her name. She is regarded as a genius in her area and works for Empower Financial Services. She’s quite known in her field, look-her up.
@Charlotte-t6l
@Charlotte-t6l 2 ай бұрын
Thank you for this tip. It was easy to find your coach. Did my due diligence on her before scheduling a phone call with her. She seems proficient considering her resume.
@raymondlew7
@raymondlew7 2 ай бұрын
but row 9 and 10 i would like my result to be C and D . can this be done ?
@realmehranvahedi
@realmehranvahedi 2 ай бұрын
Hello @raymondlew7 , I invite you to watch my most recent video on this same topic. I think it will answer your question. you can watch it via the link below. If you have any more questions after watching, please don't hesitate to ask! kzbin.info/www/bejne/gqbSc4mPetOEfdE
@ArizonaSunsetsUSA
@ArizonaSunsetsUSA 2 ай бұрын
Mehran - I want to send you a "buy me a coffee" or other way to support your channel, but I don't see anything......I appreciate your Excel tutorials - they've just helped me manage a spreadsheet that started with 19,380 rows!......
@realmehranvahedi
@realmehranvahedi 2 ай бұрын
Hi @WildWestHills, Thank you so much for your kind words and for reaching out with your support! It's incredible to hear that my Excel tutorials were helpful in managing such a hefty spreadsheet! I wasn't aware of BuyMeACoffee until now, but based on your suggestion, I've set up an account! You can find it here: www.buymeacoffee.com/MehranVahedi. If you ever feel like supporting further, that's where you can do so. But please know, just watching my videos and hearing that they've helped is already a huge motivation and means a lot to me. Thanks again for being a fantastic supporter! Best regards, Mehran
@retrojimmyx
@retrojimmyx 2 ай бұрын
Spot on, thanks.
@realmehranvahedi
@realmehranvahedi 2 ай бұрын
You're very welcome! I'm glad you found it useful!
@realmehranvahedi
@realmehranvahedi 2 ай бұрын
🚀 Exciting update! If you're looking to streamline your Excel tasks even further, check out my new video on automating the 'Paste into Visible Cells Only' process using VBA. It's a great way to enhance your skills and save time! Watch it here: kzbin.info/www/bejne/gqbSc4mPetOEfdE. Enjoy and let me know what you think!
@realmehranvahedi
@realmehranvahedi 2 ай бұрын
🚀 Exciting update! If you're looking to streamline your Excel tasks even further, check out my new video on automating the 'Paste into Visible Cells Only' process using VBA. It's a great way to enhance your skills and save time! Watch it here: kzbin.info/www/bejne/gqbSc4mPetOEfdE. Enjoy and let me know what you think!
@realmehranvahedi
@realmehranvahedi 2 ай бұрын
🚀 Exciting update! If you're looking to streamline your Excel tasks even further, check out my new video on automating the 'Paste into Visible Cells Only' process using VBA. It's a great way to enhance your skills and save time! Watch it here: kzbin.info/www/bejne/gqbSc4mPetOEfdE. Enjoy and let me know what you think!
@realmehranvahedi
@realmehranvahedi 2 ай бұрын
Dear awesome viewers! Check out the entire series on 'Paste into Visible Cells Only' to master this useful Excel feature: Video #1: kzbin.info/www/bejne/a5DRm6J3i62krsk Video #2: kzbin.info/www/bejne/emPbd3yelrZobNk Video #3: kzbin.info/www/bejne/nnSUc4Rrj9h-jdk Thank you for your amazing engagement! Remember, the most liked comment gets pinned - so start liking your favorites now! I love your questions and will try to respond to as many as I can. For quick generic queries, the comment section is perfect. But need more in-depth, personalized advice? Book a personalized consultation with me via topmate.io/mehran_vahedi. They're ideal for detailed, specific questions. Your support means the world to me. Let's keep the conversation going! Thank You!
@suzannecadden9044
@suzannecadden9044 2 ай бұрын
Your video has been very helpful. I am trying to figure out if I can use the unique/filter formula for multiple criteria in the following way: unique if 2 criteria are met using the * BUT the second criteria is a series of AND's. As I have it here, it does not work but I want a unique list if column F ="WA" AND the value "1401" is in columns I, J, L, or N but I don't want the spill to take up multiple columns. =UNIQUE(FILTER(Projects!$A$1:$A$258,(Projects!$F$1:$F$258="WA")*(((((Projects!$I$1:$I$258="1401")+(Projects!$J$1:$J$258="1401")+(Projects!$L$1:$L$258="1401")+(Projects!$N$1:$N$258="1401"))))))) I appreciate you taking a look at this!
@realmehranvahedi
@realmehranvahedi 2 ай бұрын
Hi @suzannecadden9044, I’m glad to hear the video was helpful! For your scenario where you want to filter with multiple criteria using AND, and ensure the unique list does not spill across multiple columns, you’ve got the right idea, but let’s tweak your formula a bit to make sure it works as intended. You can simplify the logical tests by using the OR function inside your FILTER function. Here's how you can adjust it: =UNIQUE(FILTER(Projects!$A$1:$A$258, (Projects!$F$1:$F$258="WA") * (OR(Projects!$I$1:$I$258="1401", Projects!$J$1:$J$258="1401", Projects!$L$1:$L$258="1401", Projects!$N$1:$N$258="1401")))) This version uses OR to check if "1401" appears in any of the specified columns while still meeting the first criterion that the value in column F must be "WA". The UNIQUE function then ensures that only unique values from column A are returned based on these conditions. Feel free to try this out and let me know if it helps or if you need further assistance!
@suzannecadden9044
@suzannecadden9044 2 ай бұрын
thank you so much but that didn't work. It gives me a list of all projects in WA but does not narrow that list by the ones that have 1401 in any of those columns referred to in the OR part of the formula. =UNIQUE(FILTER(Projects!$A$1:$A$258,(Projects!$F$1:$F$258="WA")*(OR(Projects!$I$1:$I$258="1401",Projects!$J$1:$J$258="1401",Projects!$L$1:$L$258="1401",Projects!$N$1:$N$258="1401"))))
@realmehranvahedi
@realmehranvahedi 2 ай бұрын
Hi @suzannecadden9044, Thank you for trying out the formula and for your feedback. Let's address the issue you're facing. The OR function in Excel formulas doesn't work as expected within array operations like FILTER because it returns a single TRUE or FALSE rather than an array of TRUE/FALSE values needed here. We need to adjust the approach to use a combination that correctly evaluates each row individually. Try this revised version of the formula: =UNIQUE(FILTER(Projects!$A$1:$A$258, (Projects!$F$1:$F$258="WA") * ((Projects!$I$1:$I$258="1401") + (Projects!$J$1:$J$258="1401") + (Projects!$L$1:$L$258="1401") + (Projects!$N$1:$N$258="1401")>0))) In this formula, we replace OR with an addition of logical tests (condition1 + condition2 + ... > 0), where each condition checks for "1401" in the respective columns. This approach ensures that for each row, if any column contains "1401", it returns TRUE for that row. The final result is filtered by "WA" in column F and then unique values are extracted from column A. Please test this updated formula and let me know how it goes!
@rudranseattai8653
@rudranseattai8653 2 ай бұрын
I want to write AAAA,AAAB THIS KIND OF SEQUENCE PLS HELP ME
@realmehranvahedi
@realmehranvahedi 2 ай бұрын
Hi @rudranseattai8653, Thank you for watching the video! To generate sequences like AAAA, AAAB, etc., you can use a similar approach but extend the formula to handle four characters. Here’s a quick way to do it: STEP 1] In cell A1, enter the starting sequence "AAAA". STEP 2] In cell A2, use the following formula: =IF(RIGHT(A1,1)="Z", IF(RIGHT(A1,2)="ZZ", IF(RIGHT(A1,3)="ZZZ", CHAR(CODE(LEFT(A1,1))+1)&"AAA", LEFT(A1,1)&CHAR(CODE(MID(A1,2,1))+1)&"AA"), LEFT(A1,1)&MID(A1,2,2)&CHAR(CODE(RIGHT(A1,1))+1)), LEFT(A1,1)&MID(A1,2,2)&CHAR(CODE(RIGHT(A1,1))+1)) STEP 3] Drag the formula down to continue the sequence as far as you need. I hope this helps! If you need further assistance, feel free to ask. Thanks again for viewing! Best regards, Mehran
@GODVAN1
@GODVAN1 3 ай бұрын
Can vba run it in same setting each time?
@realmehranvahedi
@realmehranvahedi 3 ай бұрын
Hello @GODVAN1, Yes, you can use VBA to automate the Fuzzy Lookup process in Excel. By creating a macro, you can configure a VBA script to run the Fuzzy Lookup with the same settings each time. Here’s how you might set it up: Step 1: Record a Macro - Begin by recording a macro while performing a Fuzzy Lookup to capture the necessary steps. Step 2: Edit the Macro - Once recorded, you can edit the macro to fine-tune the settings or parameters according to your needs. Step 3: Assign to a Button - Lastly, you can assign this macro to a button on your Excel sheet, allowing you to run the Fuzzy Lookup with a single click using the same settings every time. This method ensures that the Fuzzy Lookup is performed consistently, making your data analysis process more streamlined and efficient. Let me know if you need a more detailed walkthrough or any specific code examples! Best regards, Mehran
@GODVAN1
@GODVAN1 3 ай бұрын
@@realmehranvahedi thank for your reply, but macro record function not applicable for the fuzzy lookup.
@NismiNavoda
@NismiNavoda 3 ай бұрын
Thank you! This is really helpful
@realmehranvahedi
@realmehranvahedi 3 ай бұрын
You're very welcome @NismiNavoda. I'm glad you found it useful. Stay tuned for even more near Excel tips and tricks.
@TJ-tk4hz
@TJ-tk4hz 3 ай бұрын
Hello, Can you help me with a query? When we select a name from the drop-down list and once it repeats, the integer should increment on the other sheet in front of the exact name. Looking forward for your response. Thanks in advance!
@realmehranvahedi
@realmehranvahedi 3 ай бұрын
Hello @TJ-tk4hz, Thanks for reaching out with your query! It sounds like you're looking to set up a system where selecting a name from a dropdown list increments a corresponding integer on another sheet each time the name is selected again. You can achieve this using a combination of Excel formulas and features. Here’s a basic approach: [1] Setup your dropdown list: On your main sheet, set up your dropdown list using Data Validation to list the names. [2] Track the selections: On a second sheet, create a table with two columns: 'Name' and 'Count'. Every time a name is selected from the dropdown list, you'll record the event here. [3] Increment the count: You can use a combination of COUNTIF and VLOOKUP functions to update the count. In the 'Count' column next to each name, you could use a formula like the one below: =COUNTIF(MainSheet!A:A, NameCell) Replace MainSheet!A:A with the range of your dropdown list, and NameCell with the cell reference that corresponds to the name in the 'Name' column of your second sheet. This setup should increment the count on your second sheet every time a name is selected from the dropdown on the main sheet. If you need more detailed guidance or further customization, feel free to book a paid consultation with me @ : topmate.io/mehran_vahedi. Best, Mehran
@BTSBLISSMANIA
@BTSBLISSMANIA 3 ай бұрын
What if the milestone was not funded yet but you do the work and complete and now the client doesn't want to fund the milestone, the contract status was suspended by Upwork, Can I still receive my payment? What happens next? Thank you.
@realmehranvahedi
@realmehranvahedi 3 ай бұрын
@BTSBLISSMANIA, this is a tricky situation, and it emphasizes the importance of making sure the milestones are funded before you start working. When a milestone isn’t funded and the contract is suspended by Upwork, unfortunately, it significantly reduces your leverage in securing payment, as Upwork’s protection mainly covers funded milestones. In such cases, I recommend first reaching out to the client to try to resolve the issue amicably. Sometimes, clear communication can prompt the client to fund the milestone if the work meets their expectations. If direct communication doesn’t lead to a resolution, take screenshots of all your communications and work submissions as evidence and contact Upwork’s support for guidance on the next steps. They can provide specific advice based on the terms of the contract and the platform's policies. Moving forward, always ensure that milestones are funded before beginning work. This not only protects you but also aligns expectations between you and the client right from the start. Also, if you have any more questions or if you'd like to keep us updated on how things go, please feel free to share. Your experience could be very valuable to others in similar situations. Stay safe and keep freelancing smart!
@Nerdy-Together
@Nerdy-Together 3 ай бұрын
When I highlight the column where I want to find the value and then find all, it finds all in the entire sheet and not just in the highlighted column. What am I missing?
@realmehranvahedi
@realmehranvahedi 3 ай бұрын
Hi @Nerdy-Together, it sounds like you might need to adjust how you're setting the scope for the "Find" function in Excel. When you use the "Find" function, it defaults to searching the entire worksheet unless specified otherwise. Here’s how to ensure it searches only within your highlighted column: [1] Highlight the column where you want to search for the value. [2] Open the Find dialog box by pressing Ctrl + F. [3] Click 'Options' in the Find dialog box to expand it. [4] Set 'Within' to ‘Sheet’ and make sure 'Look in' is set to 'Values'. [5] Specify the search direction if needed, usually 'By Columns' is suitable for a column search. This should limit the search to just the highlighted column. If it still searches beyond, make sure no other cells or columns are selected. Sometimes Excel might seem to only highlight the column you clicked on, but actually, more of the sheet is selected. Double-check by clicking only on the column letter at the top of your column before starting the Find operation. Let me know if this helps or if you have any more questions!
@Mcfine2011
@Mcfine2011 3 ай бұрын
What do I do please if the number of visible cells is the same as the one I am copying from? When I do this it only takes the fist value. I am trying to copy one range from one sheet and paste it into another sheet within specific visible ceĺls.
@realmehranvahedi
@realmehranvahedi 3 ай бұрын
Hi @Mcfine2011, thanks for your question! If the number of visible cells matches the range you're copying from, but it's only pasting the first value, make sure you're using the "Fill Visible Cells" method in Excel properly. Here’s what you can do: [1] First, copy the range you want from your source sheet. [2] Then, go to the destination sheet and select the range of visible cells you want to paste into. [3] Use the shortcut Alt + ; (semicolon) to ensure only visible cells are selected. [4] Finally, paste the values using Ctrl + V. This should paste into each visible cell rather than repeating the first value. If this doesn’t work, you might need to use a more specific VBA macro to handle complex scenarios where standard pasting doesn’t behave as expected. I hope this helps! Let me know if you have any more questions.
@Mcfine2011
@Mcfine2011 3 ай бұрын
Thank you for replying. Unfortunately it still didn't work. It says I can't paste because copy and paste area aren't the same size. Although the visible cells are same size as the ones I copied. But I guess it considers all the hidden cells. And when I apply the one of the video it paste the first value on all cells.
@realmehranvahedi
@realmehranvahedi 3 ай бұрын
​@@Mcfine2011 Thank you for your feedback. It appears that the issue might be more complex due to the hidden cells being considered in the range. One approach to overcome this is by using a simple VBA macro that will only copy data into visible cells. Here’s a basic example of how you could set up such a macro assuming you want to copy from Sheet1 into hidden cells in sheet2: Sub CopyToVisibleCells() Dim sourceRange As Range Dim destRange As Range Dim cell As Range Dim i As Integer ' Define your source and destination ranges Set sourceRange = Sheets("Sheet1").Range("A2:A15") Set destRange = Sheets("Sheet2").Range("B2:B15") i = 1 For Each cell In destRange If cell.EntireRow.Hidden = False And cell.EntireColumn.Hidden = False Then cell.Value = sourceRange.Cells(i).Value i = i + 1 End If If i > sourceRange.Cells.Count Then Exit For Next cell End Sub This script will copy values from a specified range in Sheet1 to a matching range in Sheet2, but only into cells that are not hidden. Make sure to adjust "Sheet1" and "Sheet2" to the actual names of your sheets, and "A2:A15" and "B2:B15" to your specific ranges. To run this script, paste it into the VBA editor (you can access this by pressing ALT + F11 in Excel), and then run the macro. Ensure that macros are enabled in your Excel settings. Please let me know if this works for you or if there's anything else I can assist you with! Along with the VBA macro solution provided, I'm also planning to create a new video tutorial that will walk you through this process step-by-step. This video will help clarify how to implement the macro, ensuring you can effectively manage similar situations in the future. The video will cover everything from entering the macro into Excel to running it and checking the results. I'll let you know as soon as the video is uploaded. I hope this additional resource will make it even easier to resolve your Excel issues! Please stay tuned, and feel free to reach out if you have any further questions in the meantime.
@realmehranvahedi
@realmehranvahedi 2 ай бұрын
@Mcfine2011 I just wanted to let you know that I've created a video tutorial in response to your question about pasting into visible cells only in Excel. You can find the video here: kzbin.info/www/bejne/gqbSc4mPetOEfdE This tutorial guides you through using a VBA macro to ensure data only goes into visible cells, which directly addresses the complexities you mentioned with hidden cells. It covers everything from how to enter the macro into Excel to running it and checking the results. Thank you for inspiring this video! Your questions help create useful content for everyone, and I appreciate your active involvement. Feel free to ask more questions-they are a great inspiration for new videos!
@zukiswanodipho7435
@zukiswanodipho7435 3 ай бұрын
how do fuzzy lookup using 3 tables
@realmehranvahedi
@realmehranvahedi 3 ай бұрын
Great question! Fuzzy lookup in Excel is typically designed to work between two tables by comparing one column in each. To work with three tables, you would first perform a fuzzy lookup between two of the tables and create an intermediary result. Then, you'd use this result to perform another fuzzy lookup with the third table. This process involves multiple steps and careful setup to ensure the data aligns correctly across all tables. I'll consider covering this in more detail in a future video if there's more interest. Thanks for your question!
@waimingkwok-x1h
@waimingkwok-x1h 3 ай бұрын
Can it launch with the VBA code?
@realmehranvahedi
@realmehranvahedi 3 ай бұрын
Great question! Yes, you can use VBA to automate fuzzy lookup operations in Excel. This would involve writing a macro that sets up the fuzzy lookup parameters tailored to your data needs. I’ve noted your interest and might consider creating a tutorial on this topic in the future as part of my planned content. Stay tuned, and thanks for the suggestion!
@brasucafr
@brasucafr 3 ай бұрын
Thank you, it help a lot!!!
@realmehranvahedi
@realmehranvahedi 3 ай бұрын
Hi @brasucafr, I'm so glad to hear that the video was helpful! If you have any more questions or need further tips on Excel, feel free to ask. Thanks for watching!
@PatriciaMassengill
@PatriciaMassengill 3 ай бұрын
Thank you! You are the only one that has information on how to paste into visible cells only! Thank you!
@realmehranvahedi
@realmehranvahedi 3 ай бұрын
Hi @PatriciaMassengill, I'm so glad that you found the video useful! Thank you for your kind words. If you have any ideas for future topics or want to share more feedback, I’d love to hear from you!
@amadif1793
@amadif1793 3 ай бұрын
Very helpful. After many hours stuck on this specific problem, this video was exactly what I needed.
@realmehranvahedi
@realmehranvahedi 3 ай бұрын
Hi @amadif1793, it's fantastic to hear that the video was exactly what you needed, especially after being stuck for so long! If you have any suggestions or need more insights on related topics, feel free to share. Thanks for watching!
@michaelyonathan8518
@michaelyonathan8518 3 ай бұрын
can you do without formula ?
@realmehranvahedi
@realmehranvahedi 3 ай бұрын
Hello! Thank you for your question. Here's a simplified guide on how to copy and paste data into visible cells only in Excel, without affecting hidden cells and without using formulas: [1] Copy the Data: Start by copying the data you want to paste. [2] Select the Target Range: Highlight the area where you want to paste the data. This can include hidden cells. [3] Access Special Selection: > Click on the Home tab. > In the Editing group, find and click Find & Select. > Choose Go To Special from the dropdown menu. [4] Choose Visible Cells Only: In the dialog that appears, select Visible cells only and click OK. This will select only the cells that are currently visible. [5] Paste the Data: Press Ctrl+V to paste. Your data will only be pasted into the cells that were visible when you made your selection. This method ensures that your data goes exactly where you want it, without disturbing any hidden areas.
@realmehranvahedi
@realmehranvahedi 3 ай бұрын
Dear awesome viewers! Thank you for your amazing engagement! Remember, the most liked comment gets pinned - so start liking your favorites now! I love your questions and will try to respond to as many as I can. For quick generic queries, the comment section is perfect. But need more in-depth, personalized advice? Book a personalized consultations with me via topmate.io/mehran_vahedi. They're ideal for detailed, specific questions. Your support means the world to me. Let's keep the conversation going! Thank You!
@fatemehsamimi2205
@fatemehsamimi2205 3 ай бұрын
Thanks for the video
@realmehranvahedi
@realmehranvahedi 3 ай бұрын
Thank you for watching, @fatemehsamimi2205! I'm glad you found the video helpful. Stay tuned for more content like this! 😊
@abhinetrakumar
@abhinetrakumar 4 ай бұрын
Great 👍. Thank you for the explanation 😊
@realmehranvahedi
@realmehranvahedi 4 ай бұрын
Thanks a lot, @abhinetrakumar! I'm glad you found the explanation helpful. Stay tuned for more tips and tricks, and let me know if there's anything specific you'd like to see next. Cheers! 😊
@jmcclure76
@jmcclure76 4 ай бұрын
GENIUS!!!!!!!! Just saved my entire day!!
@realmehranvahedi
@realmehranvahedi 4 ай бұрын
Thank you so much, @jmcclure76! I'm thrilled to hear it made your day easier. If you have any other topics or questions you'd like me to cover in future videos, feel free to share them. Happy Excel-ing!
@90plus44
@90plus44 4 ай бұрын
so easy to understand😍
@realmehranvahedi
@realmehranvahedi 4 ай бұрын
Thank you so much, @90plus44! I'm thrilled to hear you found the video on Microsoft Excel Fuzzy Lookup easy to understand 😊. Stay tuned for more tips and tricks, and feel free to suggest any Excel features you'd like to see explained in future videos!
@realmehranvahedi
@realmehranvahedi 4 ай бұрын
Dear awesome viewers! Thank you for your amazing engagement! Remember, the most liked comment gets pinned - so start liking your favorites now! I love your questions and will try to respond to as many as I can. For quick generic queries, the comment section is perfect. But need more in-depth, personalized advice? Book a personalized consultations with me via topmate.io/mehran_vahedi. They're ideal for detailed, specific questions. Your support means the world to me. Let's keep the conversation going! Thank You!
@brianwithay7578
@brianwithay7578 4 ай бұрын
Absolutely, unequivocally, exponentially, diabolically MIND BOGGLING that this isn't the default freaking setting. When creating a bar chart in excel. Somebody needs to be fired. Hey Bill Gates, HIRE ME. I will fix so many obnoxious default settings in your programs.
@realmehranvahedi
@realmehranvahedi 4 ай бұрын
@brianwithay7578 Wow, your enthusiasm is contagious! It really can be surprising how some settings, like hiding zero values in charts, aren't the default in Excel. It sometimes feels like you need to have a secret handbook just to make the most out of these tools! Your comment gave me a good chuckle - “Hire me, Bill Gates” might just become the rallying cry for all of us who spend hours tweaking those pesky default settings. 😄 If you were at the helm, what would be the top three changes you’d implement in Excel? I’m genuinely curious and might even feature some of your ideas in a future video! Thanks for watching and sparking such an entertaining conversation. Looking forward to hearing more of your thoughts!