Dear all,
I would once again really appreciate your help on the following below:
I need to find the row number when two conditions are met:
1. First, find in column 23 the value x
2. Second, find in column 91 the value shop
Wheb I run the code, it doesnt work yet. Do you have any tips?
Thanks!!
Please Login or Register to view this content.
Last edited by jeffreybrown; 02-17-2018 at 06:51 PM. Reason: Please use code tags!
I am not quite sure of the requirement, but this code will find where "x" is found in column 23, and then starting at that row, look for "shop" in column 91.
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
I guess Bundi wants the row where column 23 has "x" and column 91 has "shop".
Then, try the code below.
Please Login or Register to view this content.
Try
Please Login or Register to view this content.
Last edited by jindon; 02-18-2018 at 01:45 AM.
yujin, your code works great! THank you all for your help!
You are welcome, Bundi. Thank you for your feedback.
Personally, jindon's code, using an array, interests me.
Dear Jindon,
Indeed, your code works superfast with the same principle, very smart indeed.
I just have one stupid question; iso returning a message box with the line row, can a just be assigned with the row found and stop therafter?
Thanks!!!!!
Your help would be highly appreciated!
You mean like this?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks