Using Excel 2010
Hello,
I am using formula Index Match in range AC6:BS211876 where Check column has 211876 row and N & T 6000 rows shown with small example but with large data freeze my PC. Also if data are not finds it display error #N/A.
It would be great if any VBA solution.
Regards,
Moti
Try
Check Sheet2
Please Login or Register to view this content.
Based on Bebo's previous posting: any errors are mine alone!
And for formula
in AC6
Formula:
Please Login or Register to view this content.
Last edited by JohnTopley; 03-19-2024 at 12:51 PM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Hello JohnTopley,Originally Posted by JohnTopley
No error at all VBA is a 5 star solutions worked with large data within eye blink time.
Thank you for editing formula without errors it is useful also.
I appreciate you time and help solving my problem.
Have a nice day, good week ahead and Good Luck!
Regards,
Moti
Last edited by Motilulla; 03-19-2024 at 04:17 PM.
Thank you for the rep ....but thanks are really due to Bebo as I "borrowed" his code.
This request is really interesting, and I believe using VBA code is definitely the optimal choice.
@JT, although you used my original code from the other topic, the additional part, the adjustments are indeed interesting.
@Motilulla, although it works well for your example, I still have a small note as follows:
It's true when in your example, "Text" column is "A, B, ..., Z"Please Login or Register to view this content.
If it's different, then the code above will be incorrect.
Quang PT
Hello bebo021999, thank you for the observation yes it is true. Please can you take a look if I changed N6 “A” to “Z” in this case as header AC5:AR5 has no match highlight the above line as you mention in your note.This request is really interesting, and I believe using VBA code is definitely the optimal choice.
@JT, although you used my original code from the other topic, the additional part, the adjustments are indeed interesting.
@Motilulla, although it works well for your example, I still have a small note as follows:
It's true when in your example, "Text" column is "A, B, ..., Z"Please Login or Register to view this content.
If it's different, then the code above will be incorrect.
Regards,
Moti
Your current row 5, only 16 columns (A:P), then
should expand to 26 (Z)Please Login or Register to view this content.
also, expand row 5 from AC to BA with A...ZPlease Login or Register to view this content.
Hello bebo021999, thank you for pointing out the modification, if I understand as letter “Z” has 26th position that’s why it ReDim & Resize has to be 26 instead 16 perfect got it.Your current row 5, only 16 columns (A:P), then
should expand to 26 (Z)Please Login or Register to view this content.
also, expand row 5 from AC to BA with A...ZPlease Login or Register to view this content.
Have a nice day and Good Luck!
Regards,
Moti
Last edited by Motilulla; 03-20-2024 at 12:19 AM.
@bebo: Good catch!
@Moti: please mark as SOLVED.
JohnTopley, I appreciate your kind help all has been fixed wisely.100% SOLVED.
Have a nice day and Good Luck!
Regards,
Moti
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks