orange

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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