Respected members
Enter the data search formula in the Excel file
Requirement:
Search by atom list
Whatever the fall may be, let it be shown in its entirety
If more items are added, they should also be shown in the list
If an expert can make it even better, thanks!
Last edited by AliGW; 11-29-2023 at 07:47 AM. Reason: Thread title improved - generic thread titles are not of much use.
Welcome to the forum.
I have removed the formatting from your post - please do not post in that way, as it appears that you are shouting at us for attention.
Your sample workbook needs to include your expacted results mocked up.
Last edited by AliGW; 11-27-2023 at 03:14 AM. Reason: Typo fixed.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try this:
Formula:
Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Thank you dear sir
but problem here
If I enter new data it doesn't show in the search bar
kindly check
Last edited by AliGW; 11-28-2023 at 02:02 AM. Reason: Please do NOT quote unnecessarily! Use the QUICK REPLY button instead.
I can replicate your problem but I don't know how to fix it. I only have Office 365 and it works different, it makes arrayformulas by itself. If I had an older Excel version it would be easier to troubleshoot.
Anyone else?
I have closed your duplicate thread. Please continue here (and be patient).
HI
DEAR MEMBERS,
KINDLY PUT THE Excel Formula IN SEARCH BAR
If more items are ADDED IN DATA SHEET they should also be shown in the list
If an expert can make it even better, thanks!
I have updated the thread title to show you the sort of detail you need to give in future.
Please wait patiently.
thank you dear boss ,
Last edited by AliGW; 11-29-2023 at 07:58 AM. Reason: Please do NOT quote unnecessarily! Use the QUICK REPLY button instead.
FYI: Jacc put out a call for help on your behalf yesterday, so members are aware that you still need help. I looked at the issue myself this morning, and could not find a way to fix the problem. When someone finds a solution, they will let you know.
Explaining picture
if i enter new data in data sheet
didn't show in search bar Attachment 850964Attachment 850965
In C6 (Copy across and down)
Formula:Please Login or Register to view this content.
Or have I mis-understood?
Last edited by JohnTopley; 11-29-2023 at 09:49 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
That works John.
I did some research on my own solution and found that this part:Formula:Please Login or Register to view this content.
is what makes the array formula stop updating.
I split up the formula, using one extra column and now it works. I call bug.
Last edited by Jacc; 11-29-2023 at 12:07 PM.
Thank you dear boss mr jacc
problem solved
again thanks
thread closed
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks