orange

  1. I

    Multiple values vlookup? Many to many - Two lists

    Hello, (I did search for a solution on here but couldn't find, hence the new thread) I have the following issue if anybody can help: (Many to many relationships) List 1 <tbody> Ref Property 1 Property 2 0.1 A E 0.2 B A 0.3 C D 0.4 D B </tbody> List 2 <tbody> Properties...
  2. 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...
  3. A

    Copy Fill Row to other Sheet

    Pseudo Code If any cell between (A1:D9) have color orange than Select the row of that orange cell and copy to the other sheet first available empty row and put current date to right side of copy row I have write some code but its not working Sub copy_next_Row2() If...
  4. I

    VBA: Specific number in a serie-of-numbers in a cell equals a color

    Hello, If I have numbers in a cell "1294392393", I want the 4th from the right side (the thousand number), I want a "color/border" on the whole columns. For instance: "1294392393" = 12943[9]393 ----- the nr "9" shall make a color blue on the whole column. In a row below the "12943" = 1[2]943...
  5. C

    Return value adjacent based on match

    Hi all, I believe I've done something similar to my current problem but I can't quite figure this one out. Would appreciate any advice! I'm trying to match 2 values in different columns and then return the adjacent value from a third column. Hopefully this demonstrates it clearly. <tbody>...
  6. smide

    Find average of last three occurences (data in two columns)

    Hello. In columns A (A2:A600) and B (B2:B600) I have products and in columns C (C2:C600) and D (D2:D600) 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 (in cells...
  7. M

    What is the best way to create a kit list

    Hi I have 2 sheets in a workbook. The first sheet ‘kit list’ has a table with a drop down boxin B12 to B210, so I can select a product from the drop down, then in C12 to C210,I can put the number of each of the products I want. There could be multiplevalues that are the same in column B...
  8. B

    Calculating the difference in quantity from a matrix

    Hi Everyone, Have come here seeking for some advice and will try to explain as best I can. The scenario is a food company that deliver's a set amount of products dependent on the amount of customers that are booked on a specific day. So I have a main spreadsheet with a list of food items...
  9. 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...
  10. 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...
  11. S

    VBA macro to paste in last row of A,B etc column by finding used row in multiple columns

    Hi, I need a macro code to paste the values as below of last used rows by finding in given 6 columns. For example: Here banana columns used more rows so based on more used i need your support to paste apple columns values on below. Please help me to get VBA code for below scenario...
  12. D

    Looking for a formula

    Hi, i need a help. I need a formula for the calculation for the below data <tbody> <tbody> Location </tbody> <tbody> Vehicle No. </tbody> <tbody> Transport </tbody> <tbody> Weighment </tbody> <tbody> Charges </tbody> <tbody> Total </tbody> <tbody> Credit...
  13. D

    VBA Count Duplicates from a varied range on one sheet using another sheets list

    Is it possible to count number of instances of duplicate and unique cells found from a varied range using a list of data from another sheet as a reference to on what to look for? My data will be varied with up to 20,000 rows and up to 10 columns Also the cells will contain both numbers and...
  14. C

    Search and Replace with Ranges

    Hi there, So I've been given a task to find and replace items in a spreadsheet with a range. Now I've had 0 experience in VBA before this, so I'm a bit confused. And could use some help. I will put it as simply as I can, because my brain gets confused when I go into the details of the task...
  15. D

    VBA Delete duplicate cells from a range then highlight original

    Hi, Is it possible to Delete all duplicate cells from a varied range but keeping the original string and highlight it? I will have up to 10 Columns and up to 30000 rows of data which will contain multiple duplicates strings that need removing, There will also be headers. Can anyone Help? Thanks...
  16. A

    Return Unique Value in Excel Using Formula

    Hi, is there any ways to return unique value in excel using formula? For instance as below: <tbody> Name Fruit Abi Apple Abi Apple Rex Watermelon Claudia Orange Ricky Grape Abi Orange Rex Pear Count of Unique Fruit 5 </tbody> Unique Value Apple Watermelon Orange Grape...
  17. E

    Bar Chart question

    Hey guys, I have a bar chart with two values for a given year and this done over a 5 year period. For example blocks highlighted blue will be ascending over time with amounts increasing each year and orange will be decreasing each year Can the difference between the total summed values for...
  18. P

    Regarding Excel Formula

    Hi Sentences 1 It is Apple 2 It is Orange A Column Contains this two sentence in random manner. I need a formula to extract word apple or orange from the given sentences.
  19. M

    column a: loop thru column range a1:a100 and copy/paste into other col in sheet at change in value

    Hi, Column A has a list of fruit. A1: orange A2: orange A3: orange A4: kiwi A5: kiwi A6: blueberry Requesting VBA to loop thru column A. Then Copy value to cell B1 until value changes. Then cell C1 etc. in example, result is: col b has b1 thru b3 with orange, col c has c1 thru c2 with...
  20. P

    Merge duplicate rows and sum column for each name

    Hi The data I'm trying to consolidate has this structure. I found pieces of code around the forum but i just can't make it work, is there a way using VBA or a formula I can do this? Make this: <tbody> A B John 1 apple 2 apple 1 orange Peter 1 Lemon 1 Orange 2 Lemon 3...

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