shoes

  1. F

    How to take last data entry of previous product and substract from current product?

    Hello to all, I have the below macros IncomingProducts and RunAgain. - IncomingProducts: This macro simulates the input coming from users of StoreA and StoreB. For example purposes I've show the data entries from both stores with arrays. - RunAgain: This macro only calls IncomingProducts to...
  2. K

    Distinct Count Based on Multiple Criteria

    Hello, I am building a tab [results]; on this tab, I have a column [column A] which lists a unique value (description). In [column B]; I need to create a formula. This formula needs to look into the [raw data] tab, and count the number of distinct IDs which share the same (description) and...
  3. N

    Which formula should i use to sum some table and some criteria

    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...
  4. K

    Vba to convert csv (insert cells)

    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...
  5. L

    formula help

    Hello I need some help with creating a formula for the below table. What I am trying to achieve is in the "required results" column A. The "Name" entries will always have "Name" preceding <tbody> required results Name Jimmy Name Jimmy -shoes -shoes Name Tom Name Tom-Balls...
  6. B

    Return count of unique records in one field, based on sum of another field

    To illustrate the question I have created some dummy data below: <tbody> Country Product Sales Volume France Shoes 10 France Shoes 20 France Shoes 30 France Boots 5 France Boots 5 France Hat 10 France Hat 5 </tbody> I want to create a measure that will return the number of...
  7. J

    Find row number based on on mulitple criteria

    Hello, I am looking for a VBA solution that can find the latest data entry using 2 criteria. For instances, looking at the table below, if i were to enter the employee ID and the product type it would return $79. I am trying to avoid formulas to accomplish this task. Any help would be much much...
  8. C

    Macro that transposes and concatenates

    Hello I am trying to write a macro that joins strings of text together whilst also transposing. I'll try provide an example of what I'm after: So here is table 1, where we write the campaign name, the ad group name and its associated keyword(s). A B...
  9. IsabellaLearning

    Count by month ONLY FILTERED columns and exclude blanks

    Hi if it was just counting july - i think it would be easy: =SUMPRODUCT(--(MONTH(f:f)=7)) I would like to count only in the filtered data, only the July 2017s. The date column in F row is in format dd/mm/yyyy I want to ignore blanks in that row. I also would like to count by another condition...

Watch MrExcel Video

This Week's Hot Topics

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
Top