supermarket

Year Month Salesman Customer Name Category Sales 2018 Target for Jan 2019 2018 Jan Peter A Supermarket Milk 20 22 2018 Jan Peter A Supermarket Cheese 30 33 2018 Jan Peter A Supermarket Juice 15 16.5 2018 Jan Peter B Supermarket Milk 15 16.5 2018 Jan Peter B Supermarket Cheese 17 18.7 2018 Jan...

Hi, In B1 I have the following formula to search A1. Similarly, B2 to search A2, etc. =IF(ISNUMBER(SEARCH("COSTCO",A1)), "Supermarket","") However, I need to have multiple criteria all within the above formula. For example: IF "COSTCO" then display "Supermarket" IF "TESCO" then display...

Hi Everyone need your help. I am using combo box to select a group to hide and unhide rows. below is the code that I used Private Sub ComboBox1_Change() Rows("11:250").Hidden = True Select Case ComboBox1.Value Case "All" Rows("11:250").Hidden = False Case "All Day"...

Hi there! I have a table like below: <tbody> Order Date Brand Product ID Customer ID Supermarket Sales Volume Sales Value ($) 01/09/2016 Company A 3431 345452 Supermarket B 5 10 02/09/2016 Company A 3524 243784 Supermarket B 2 4 02/09/2016 Company B 3122 345452 Supermarket A 1 2...

Hi there! I have a few questions pertaining to a single dataset that looks like below. <tbody> Order Date Brand Product ID Customer ID Supermarket Sales Volume Sales Value ($) 01/09/2016 Company A 3431 345452 Supermarket B 5 10 02/09/2016 Company A 3524 243784 Supermarket B 2 4...

I have a sheet with a 1st column "supermarket", a 2nd one "type of product", a 3rd "product"and a last one "price". There is one row per product. I would like to make this sheet user friendly and create a form. But I would like the user to be able to, in the form, choose (just once) the name of...