hi
so far I don't find solution to my case. it should calculate price average in column(5) in list box and column E based on the sheet data and merge duplicate items based on column(2) in listbox and column B based on sheet data , also the first column(1) in listbox should be 1,2,3 not date when merge the data . that's all of that happens when write the item in textbox1 based on column(2) in listbox and column B based on sheet data . with considering when calculate the averge then should column (6) in listbox= column(4) x column(5)
note: merge duplicate item based on column(2) in listbox and column B in sheet of data and calculate price average in column(5) in list box and column E based on the sheet of data
as you see in picture two . I want after select optionbutton show data as in show in the picture2
pictur1 when search based on textbox1
I issued also in this forum https://www.mrexcel.com/board/thread.../#post-5783230
I hope finding solution here .
HTML Code:
Bookmarks