shop

  1. C

    Link in Formula

    Hi, I'm using index match reference, but I have to change every formula one by one, is there a faster way? https://ibb.co/X2pcKzP See the photo attached, I have to change the formula in G56 from '[7 July Shop Yields.xlsx]1.7' to '[7 July Shop Yields.xlsx]2.7'! manually but whereby F56 already...
  2. K

    Button Selection

    Hi all. I have a user form with two buttons for a selection by the user. It is either the one or the other. You can not select both. If you select Mobile then the word "Mobile" is to be in cell M1. If you select In Shop then the text "In Shop" is to appear in cell M1. If no button is selected...
  3. Z

    partial lookup

    hello, i have an issue with some of my colleagues when typing for example shop names, not all of them write it the same way so i need a way to look for the written name in the excel report and look it up from the correct table. Example: Wrong Spelling/Name <tbody> Carrfour Maadi Correct...
  4. J

    Convert Data in Sub-Total Format to Pivot Friendly

    A program I use outputs data in a non-pivot friendly format. It has already grouped the data with different levels. I am trying to convert this data into data that is pivot table friendly. I currently have data like this where Location is always filled out and will have at least one (but...
  5. B

    COUNTIF / SUMPRODUCT with Multiple Criteria and/or Index Match

    Hi all I've been trying to come up with a solution for a little while but am just not seeing what I need to do to get there... I was hoping someone on these excellent forums may be able to assist? Background: I have 5 tables with 12 columns each (i.e. months) in my back pages. The 5 tables...
  6. B

    VBA - Vlookup returning entire column

    Hi, please help I’m stuck. I have been trying to write this with no success. I have two worksheets that I’m working from; Sheet1 will have a shop order reference number in cell C4. I would like to search Sheet2 Column C for the corresponding Shop order then proceed to copy the shop order and all...
  7. M

    macro with auto filter code requrires ammending

    HI I'm using excel 2016 the following macro deletes all the rows of data when the word "SHOP" is found in column c the issue I have is if the word "SHOP" is not found than all the data is removed except just one row how can I change this Sub Macro2() Application.ScreenUpdating = False...
  8. D

    Distilling down info from multiple rows

    Hi folks, I am wondering is there a way to summarise the table below so that it lets me know if an event had only newcomers, only returns, or returns and newcomers. For instance, I am trying to distill this table down to: On 11/11/19, the "Shop" had "New and Return" customers while the "Show"...
  9. A

    Counting activity by week

    I hope this will not be too difficult to explain but this is a tough one. I have 3 columns, A, B & C and each column has about 10 rows. Each cell is formatted to be a date. So for example, the rows are broken down into weeks, so the first 10 rows will be week 1, the next rows will be week 2...
  10. S

    Highlight same cells only once

    Hello, There is a warehouse with products. Every product consists of boxes with different weight. Every time a box from a warehouse goes to the shop it should be highlighted. So if the same weight from the warehouse is entered in the shop area, they both should be highlighted. But sometimes...
  11. M

    Designation & % of Achievement

    Hi friends, I have a Sales Incentive Program that payouts to staff based on their designation and % achieved. Below is the criteria table. <tbody> Designation Pay-1 90% Pay-2 100% Pay-3 110% Pay-4 120% Sales Associate 60 100 150 300 Watches Technician 60 100 150 300 Senior Sales...
  12. S

    Creating a Name to Time to populating a calendar formula

    Greetings! So I am currently working on a project at my job. It is something that I can do by hand, but requires a tedious amount of time. I'll try to explain briefly and then I need help figuring out how to use formulas to make this easier. We create hot rods from the ground up. We have...
  13. B

    Formula needed (index/match probably)

    Hi All, I need some help with constructing a formula. Basically I have a three column table, one column is transfer document, one is shop and one is goods code in the shop. What I'd like to see is what is the goods code of the same goods in the different shops. The only connection between the...
  14. S

    Searching multiple tables with multiple criteria

    Hi all, I'm trying to find a formula that will allow me to search multiple tables with multiple criteria e.g: I have a main sheet with multiple criteria: shop name, engine type, type of service. I then need to use these criteria to search within a number of different tables set out like...
  15. M

    Trying to build a load plan. need help ! thanks

    Hi, i'm trying to build load plan in which i require multipul shop cage counts to add up and then see where they fit on to a wagon. i have got that part done but im wondering if it is possible to fill in, as many boxes with a shop name as there are in the sum? wagon would be 3 boxes wide ,by...
  16. M

    Excel Work Sheet for Grocery Shop Complete Inventory Control

    Can anybody share Excel Work Sheet for Grocery Shop Complete Inventory Control
  17. M

    Excel Work Sheet for Grocery Shop Complete Inventory Control

    Can anybody share me a Excel Work Sheet for Grocery Shop Complete Inventory Control
  18. A

    Forecast in excel

    Dear Mr. Excel Can you please help me to prepare the data on excel sheet as per attachment. Regards <colgroup><col span="4"><col><col span="2"><col><col><col span="5"><col><col><col><col><col><col span="2"><col><col><col><col><col span="2"><col><col><col><col><col><col...
  19. C

    How to copy the data from multiple excel worksheets to a master sheet on same workbook

    Hello all, I am struggling to find a solution to my problem which is as below: I have a excel workbook with name - sales.xlsx which has 3 worksheets - online, shop and master. Currently we enter the data manually to worksheets online and shop. We want a macro which can automatically copy over...
  20. M

    Create table of uniques...

    Hi, My table is as follows: <tbody> Shop Fruit A Apple A Apple A Pear B Strawberry B Banana B Orange B Banana </tbody> And I need a DAX formula to create the following table: <tbody> Shop Fruit A Apple A Pear B Strawberry B Banana B Orange </tbody> Which...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top