1. M

    Updating values and highlight them based on external excel file

    Hey guys I have two versions of the same files. One of them is the updated one with the new data. Now I have troubles writing a macro which does the following: Ask which file I want to compare it to. Comparing two identification numbers in those two different files. If they match, it shall...
  2. H

    Getting Unique Values from List without VBA

    Hi, I'm using Excel (Microsoft 365 on a Mac) I'm using the formula =IFERROR(INDEX($B$2:$B$9, MATCH(0,COUNTIF($D$1:D1, $B$2:$B$9), 0)),"") B1 = Fruit, B2 etc = Apple, Orange, Apple, Banana, Banana, Apple, Pineapple, Peach D1 = Unique, D2 has the above formula I copied the example from...
  3. K

    SUMIF where range and sum_range are in every nth column

    Hello! I would like to get result of 19 in B7 for sum up values where criteria is always banana (A7) but there are multiple ranges(A,E,I) and sum_ranges(C,G,K) which are in every nth column. A B C D E F G H I J K 1 apple n/a 1 cherry n/a 1 banana n/a 10 2 banana n/a...
  4. B

    Rank and Count Formula

    I'm trying to create a formula that will rank and count responses to survey data that will summarize the top 5 in the format below. The data will be structured similar to the table below with new responses being added to the bottom of the table continually. For this example, the data is in...
  5. D

    Logical formula for calculating until a number has been reached

    Hi Guys, I would like help with creating a measure for the following data. I would like to categorize the products as i did manually for Apples - I calculated the total volume for the product and divided it by 3. Then I would like to start summing from the lowest volume of Apples to the highest...
  6. smide

    Return the second to last value - data in two columns

    Hello. In columns A and B (A1:A600 and B1:B600) I have product names and in columns C and D their prices. When product is in column A his price is in column C (same row) and when product is in column B his price is in column D. In column E I have a list of all products (E1:E50). With array...
  7. T

    Index/ match and match??

    Hi everyone, Appreciate if you can advise the formula that is applicable for this scenario. 1. Sheet 1 - table 1 This table shows the price of apples at different minimum order qty (MOQ) in Q2 <tbody> Types of apple MOQ 1 Unit price 1 MOQ 2 Unit price 2 MOQ 3 Unit price 3 Apple 1 500...
  8. A

    Conditional if in multiple rows and columns

    Greetings! I have a question that I believe it should be fairly easy to resolve for someone with experience. I have a data set that looks something like this: <tbody> Run Order Sequence CAR 1 2 CAR 2 1 CAR 3 3 CAR 4 4 APPLE 1 2 APPLE 2 1 APPLE 3 3 APPLE 4 - SODA 1 1 SODA...
  9. T

    Copy data on sheet2 to sheet1 base on column data.

    Please help me out. I want a vba that can automate this process that copy sheet2 to sheet1. For example on sheet2. Column D4 fruit column separate by a blank line with a new fruit with dates, purchase orders and quantity. There's six types of fruit that I need to keep track. What I want to do...
  10. D

    Identify cell address of first instance of duplicate value in vba

    I have a table Column A, Column B, Column C Row1 2 Red Apple Row2 5 Green Mango Row3 2 Yellow Banana Selected row3 with duplicate in Column A = value 2. I need a code or function to find...
  11. H

    Sum 2-dimension array

    Hi Everyone I have the excel file to control storage as attached link. The Sheet1 is an storage, and sheet2 contains goods which I want to take out.... I want to compare the quantity at Sheet2 with quantity at Sheet1 of item "Apple" with code is "AP" base on the current date&time and Expire...
  12. Z

    sumproduct or countA, but how :)

    <colgroup><col span="2"></colgroup><tbody> Fruits Years apple 2018 apple 2018 orange 2018 banana 2018 peach 2019 grape 2019 apple 2019 melon 2019 2018 3 </tbody> hi i got this case, can you help me out for the formula? as u can see the answer is 3, but when i change to...
  13. D

    Help me Excel Community

    Hey Team, I've developed a dashboard but have come across one error and I am hoping someone out there can help me! By using VBA code, I have columns which allows for multiple items in a drop-down list e.g. column A has the option to select Apple, Orange, Banana. Is there a way to produce a...
  14. K

    SUMIFS Question

    Hello, I have a table that contains 5 different groups of items. Each of those items have a price, on a separate reference table. I am trying to determine the total price of each group using a formula. <tbody> A B C D E 1 ITEM 1 ITEM 2 ITEM 3 ITEM 4 TOTAL PRICE 2 apple...
  15. C

    SUBTOTAL (average) on criteria

    Hello, I have an issue and i need your assistance Situation is like this: <tbody> Zone <tbody> StoreID </tbody> <tbody> Sortiments </tbody> <tbody> SoldQty(Kg) </tbody> EU <tbody> SHOP1 </tbody> APPLE 200 EU <tbody> SHOP1 </tbody> ORANGE 140 EU <tbody> SHOP1 </tbody>...
  16. K

    Formula to Retrieve Value base on specific text.

    Hi Guys, I am using Excel 2016. Its been awhile since I posted would appreciate some help on the following problem. :( I have the following list : <tbody> Fruit Price Apple 5.00 Watermelon 6.00 Mango 4.50 </tbody> <tbody> Fruit Price Watermelone 5KG Banana 300G Red Apple...
  17. P

    Index match vlookup

    Please help, I’m trying to accomplish the same result in this table with a formula when looking for thousands of data. Year Fruit Jan Feb March 2018 Banana. 1. 2. 3 2019 Banana 2. 3. 1 2018 Apple 4. 4. 4 2019 Apple. 2. 5. 3 Thanks
  18. M

    Find Missing Values

    What i am trying to do is we have multiple accounts and products, would like to find the missing products for each account. I saw solutions for matching one set but not multiples Account Product 1 Apple 1 Orange 1 Tomato 2 Orange 2...
  19. G

    CountIF Values (Text) related to a Cell

    I need to count how many times an item went from a certain source, and afterwards from which source it went the most. Say... <tbody> Source Item Wallmart Apple Wallmart Apple Newegg Apple Target Apple Wallmart Apple Target Apple Wallmart Apple </tbody> How do I, on a new...
  20. H

    Count Multiple Items in Same Column

    Hi - How do I add another variable to this code? I want it to count how many times "Apple" or "Pear" appear in the column? With Sheet1 Dim x As Long x = .Range("A" & Rows.Count).End(xlUp).Row Dim cnt As Integer cnt = 0 For i = 1 To x If .Cells(i, 1).Value = "Apple" Then...

Some videos you may like

This Week's Hot Topics