LinkBack URL
About LinkBacks
Hi all,
I need this Result in the pic
Please, without VBA & Helper column
with formula, please
Many thanks!
Hi all,
I need this Result in the pic
Please, without VBA & Helper column
with formula, please
Many thanks!
Last edited by Yaghoub61; 02-05-2021 at 09:42 AM.
Notice:
my main language is not English
I cannot tell from your workbook what criteria you are using to copy Product to Columns D or F. For example, why does M which appears once appear in Col D, while R and H (also once) appear in Col F and K (appears once) doesn't appear in either column?
Last edited by ChemistB; 02-04-2021 at 03:55 PM.
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
You are right
I'm so sorry for my mistake
I modified the file and photo
Thank you
The number of products is not important
It is necessary to specify unsold products (D) from column (B)
Products sold is a column (ّّF)
Last edited by Yaghoub61; 02-04-2021 at 04:12 PM.
Please try at D4
=IFERROR(INDEX($B$2:$B$13,AGGREGATE(15,6,$A$2:$A$13/(ISNA(MATCH($B$2:$B$13,$F$4:$F$13,))*MATCH($B$2:$B$13,$B$2:$B$13,)=$A$2:$A$13),ROWS(D$4:D4))),"")
Again, as always, it was great!
Thank you very much for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks