Log In
Register
Home
Active Member
March 16, 2023
Offline
Every week I will post product pictures on my facebook page. my customers will comment on the picture they want to buy with a comment (book) and if there are other customers who are interested in the same item, the next customer will comment on the queue book. I will record the name of the first customer to comment book in Excel. (STEP 1). Please refer to the file that I have attached.
My problem now is when my customer will comment book on the item that I posted in the previous week.
Should I use power query, vlookup or power Bi. which one is more suitable for my current situation?
Pardon my English.
Thank you.
See Answer
October 5, 2010
Offline
Hi Adam,
I'm afraid it's not clear what you are asking or what you want to achieve.
I've looked at the file and an see in Step 3 that you have created a list of people with the items they want to order, from the data you entered in Step 1.
I don't see how comments from the previous week come into this. Where is that data? What do you ant to do with it?
Can you please provide an example of the result you want and that might make it clearer.
Regards
Phil
Active Member
March 16, 2023
Offline
Hi Phil,
"I don't see how comments from the previous week come into this. Where is that data? What do you ant to do with it?"
The Data was obtained from customer comments that commented on items I had uploaded on Facebook Page in the previous week
"Can you please provide an example of the result you want and that might make it clearer."
I'm going to use this example to illustrate what I'm trying to get out of the data set, I hope it's more clear than the previous one. [as attached]
Thank you,
Adam
October 5, 2010
Offline
Hi Adam,
What version of Excel have you got? If you can use dynamic array functions you can solve this using
=UNIQUE(FILTER(Table1[NAME],NOT(ISBLANK(Table1[NAME]))))
See the new sheet Form 3 that I created in the attached file. Note that I turned your source data into a proper Excel table so that I could use table structured references to refer to the Name column.
Regards
Phil
Answers Post
Active Member
March 16, 2023
Offline
Hi Phil,
Thanks for the help and suggestions you provided but I am unable to perform dynamic array function yet because I am still using the 2016 version.
do I need to upgrade to Office 365 to accomplish this task or are there still other ways that can be figured out to solve this problem?
For now I'm trying to use VBA code along with user interface save, modification, delete function. If that doesn't work, it's time for me to upgrade to Office 365 then.
Regards,
Adam
October 5, 2010
Offline
Hi Adam,
Offie 365 would be better as it provides the best solution. Without that you'll have to rely on techniques shown here Excel Extract a Unique List
In the attached file I've used a multi-cell array formula on the Form 4 sheet, but if you delete a name from the source data, you could end up with 0 in your unique list. There are pros and cons to each technique in the post.
Regards
Phil
Active Member
March 16, 2023
Offline
Hi Phil,
I saw what you did in Form 4. as soon as the name is deleted, not only end up with 0 result in unique list but
other cells are also affected with item code everywhere in other cell once the customer's name from the data source is deleted.
So it's time for me to upgrade to Office 365 then , writing vba code is not an easy thing for me who is still a beginner.
Thank you so much Phil for helping me in solving this problem as well as introduced "dynamic array functions" to me.
Regards,
Adam
1 Guest(s)
