for example EXCEL.jpg
i WANT TO SEARCH FOR TWO CELLS AT THE SAME TIME
for example EXCEL.jpg
i WANT TO SEARCH FOR TWO CELLS AT THE SAME TIME
Does order matter? What if E2 was black and E3 was green? Is that a match? Do you just want to return that there is a match or exactly where the match is? How large is your actual data set?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
i want to return that there is exactly the match and the data set is big 300 cells and add every week new infos.
What would the answer look like?
For example, you have the word "GREEN" in cells E2 and E5. Are you expecting to see "E2, E5" in cell N6, and E3 in cell N7 ?
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
No my friend. i have the word green in cell e2 and black e3 (order does matter becuse is one under the other every time) and i want to search green & black with some formula and take me in the cel e2 & e3 like multi-search but not one colour in e3 and other e8. they are pairs...one under the other.
Sorry for my english
i mean to show me those cells like ctrl+f which ''take'' you to current cell. i emphasize the cells are one under the other every time. i write green in cell r3 and black in r4 and show me at the panel where are the green in e2 and black e3. SOMETHING LIKE THAT
Press the button on the attachment.
very veryyyyyy good. YES that's the spirit
What i'M doING now i copy your vba to my book???
It's ok for my big data??
LOL - glad to help.
να έχεις μια όμορφη μέρα
::
If you need it, here's how to finish up:
Place this code in a 'code module' in the workbooks VBA project (can you do that)?
Place the button on the workbook (INSERT>SHAPES from the ribbon) - then right-click on the shape and 'assign macro' (pick buttonPress).
Please Login or Register to view this content.
Last edited by GeneralDisarray; 08-04-2015 at 01:13 PM.
I have already a vba project sortnumsincell called and i have a little problem....could you help me how i put your vba project?
sure, upload the workbook here please. I can add the project.
how upload the book. which is the icon???
You attach a file to a Reply....
*Instead of pressing "Post Quick Reply" press "Go Advanced"
*On the next page, below the message box, you will find a button labeled 'Manage Attachments'. Clicking this button will open a new window for uploading attachments.
*To upload a file from your computer, click the 'Browse' button and locate the file, then click 'Upload'.
*Once the upload is completed the file name will appear below the input boxes in this window.
*Press 'Submit Reply' to complete.
Here you ARE THE GOGIKTON SHEET IS WHERE I WANT TO DO
I THINK THAT YOU GONNA CRAZY WITH ALL THE FUNCTIONS AND FORMULAS,WHICH I PUT THERE.....I 'M novice in excel
Try the attached file.
sas.jpg
i have this problem when i turn on the order vba
HELP IS ON THE WAY
what is going wrong with help????
Sorry, I have no idea why you are getting that error - I posted a link to this in another thread, thought someone might be able to help.
ok my friend thanks a lot for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks