hat

<tbody> 1 MIKE HAT JIM BAT JAMES BAT BOB HAT 2 BOB BAT JAMES HAT BILL HAT 3 JIM HAT 4 MIKE BAT JAMES HAT BOB BAT 5 BILL HAT MIKE HAT </tbody> above table Column A is day of month column followed by names than code to the right for each person. on another sheet I have the...

Hi All, I have problem in using excel formula to provide the correct result for my store performance. I already googling some formula, both Excel and Google Sheet but it make me confused because some formula didn't work. From that references I am using syntax Sumproduct, Sumif, Index and Match...

Hello, I am going to be importing a CSV file into a sheet weekly and need the column to line up properly. The Comma Seperated list I am importing does not account for spaces I need for the excel sheet. I made a dummy table below. Every person is ordering a shirt, a hat, shoes, or any...

I have a web form that collects data, there are 4 radio buttons depending on which radio button has been selected the value of that radio button goes into column B Radio buttons <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings>...

<tbody> 02/03-2017 date article sales 01/03-2017 hat 100 01/03-2017 jacket 50 01/03-2017 pants 600 02/03-2017 hat 200 02/03-2017 jacket 300 02/03-2017 pants 150 </tbody> Hi, Could someone help me with the formula for getting top 1, 2 and 3...

Hi Everyone, Ok, So Column K has Items listed in it and Column L Has the number of items ordered So K L ToyBOX 20 for example(carries on down the column with different Items on) so In Column P I want a macro that will go down column K look at the number column L and create alit...

Hi all, I hope someone can help me with a problem I'm trying to get around with multiple criteria of an Index/Match function. Column A is a list of clothes Hat Sock Mask etc. Column B is a list of body parts: Head Chest etc. I now need unique lists in columns D-F headed with the body part...