Search results

Dear @yunus786, please navigate the GIF below, it's working accurately. I see no anomaly. And Yes, you must format manually since the Fill Handle tool doesn't format automatically. However, Excel sometimes tends to mess up. It's quite irritating. There are several reasons for not showing...

Dear @yunus786, thanks a ton for sending me the Excel file. I have used the INDEX-MATCH formula to call values from another sheet named Attendance. Here's how: 1. Use the following formula: =IFERROR(INDEX(Attendance!$C$3:$C$273, MATCH(1, (MONTH(Attendance!$A$3:$A$273) = MONTH('All...

Dear yunus786, first of all, thank you so much for your query. Can you please send me the Excel file? So that it would be helpful for me to serve you with the appropriate answer. Your problem is unique, so the answer should be creative too. Have a good day. Regards, MD Tanvir Rahman Excel and...

Dear @parveengarh, welcome to ExcelDemy Forum and thank you so much for your unique query. Yes, you can extract "410210" from "65GRFLOORSHOPNO-978SHREEKRISHNAPARADISENAVIMUMBAI410210TOLLFREENUMBER56789" by applying the following formula containing Excel TRIM, FIND, MID, LEN functions...

Dear @iqubalind, take my heartfelt gratitude. The RIGHT, LEFT, and MID are suitable functions since we are set to match a word (i.e. Train, Bus, Emigration, and so on) from the beginning of the text. But yes, without these functions, we can still develop formulas but those are not as simple as...

Dear @iqubalind, I hope you are in sound health. Yes, I got your issues. You are likely to match the text string and return the HSN number. Use the following formula, =IF(ISTEXT($E3),INDEX($C$3:$C$14, MATCH(TRUE, ISNUMBER(SEARCH(LEFT($E3, FIND(" ", $E3 & " ") - 1), $B$3:$B$14)), 0)),"") Please...

Dear @iqubalind, I have acknowledged that you wanted to use the shorter version of the following formula for partial match you mentioned above...

Dear @iqubalind, Are you looking for a dynamic formula? If your answer is Yes! please jump to the newly developed formula. =INDEX($C:$C, MATCH("*" & F8 & "*", $B:$B, 0)) I have attached a GIF. Please have a look carefully. You just require to change the column number (i.e. B,C,D) according to...

Dear iqubalind, you have my heartfelt gratitude. I have developed two formulas for direct match and partial match. Partial match is also applicable for direct match. Microsoft introduced VLOOKUP, INDEX, and MATCH functions in the Excel 2007 version. Formula applied in the G3 cell...

Dear valued user, Thank you for your queries. Use the following code and please follow the instruction properly. Let me know, about your further shortcomings. Sub copy_non_duplicate_rows() Dim Rng As Range, i As Long, j As Long Dim wsSource As Worksheet, wsDestination As Worksheet Dim newRow...