Previous Topic Next Topic

Excel macro to find value with a condition

Closed
Sharad - 31 May 2010 à 06:39
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 31 May 2010 à 07:25
Hello,

Say, a code like C1180230 may occur more than once in column A, but its occurence with name "Recipe" in the previous cell is unique. I want the selection at "Recipe" cell at such a condition and proceed with further macro code those I already have. Is it possible?
Sharad
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
31 May 2010 à 06:50
So are you only searching for this C1180230 (is this a concern number ? data look so familiar)
Sharad
31 May 2010 à 07:22
no, i would search for other such occurences. for now it appears to me that i need separate codes for different searches. this is one instance.
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
31 May 2010 à 07:25
Sorry I was not clear earlier. What I wanted to know was how this number is picked to be searched etc. You need to provide some sample data and explain how you want

Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.