apple

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

Hi - I have workbookt1 that has all of my data in it, and workbook2 that i want to use a tracker. The code i'm using is below. Is there a way to use the sheet name a a variable in place of "Apple" and "Pear"? Both workbooks have the same sheet names and ideally the code would put the totals...

Hi, I am creating a spreadsheet with several values (one Text value in each cell) i.e. <tbody> Row1 Col. A Col. B Col. C Col. D Col. E (The Result) Row2 Apple Banana NA Pumpkin NA Row3 Cherry Apple Mango Pineapple NA Row4 Apple Banana NA Pumpkin Apple </tbody> I wish...

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

<tbody> Current Desired Result A B 1 Apple Apple 2 Apple Banana 3 Mango Mango 4 Mango Peach 5 Mango 6 Peach 7 Banana 8 Banana </tbody> I need the value only listed once (preferably in Alpha Order) from a data set column that lists that value...

Hi all, I'm really sorry as I'm struggling to even describe what I'm asking help for here. I basically have a list of 30,000 rows of data where Column C is the unique number relating to a customer and Column D is a product they hold. I'm looking for some code to do something like run down...

Hi all, I have a list of data: Apple 580 Pear 245 Orange 867 Cherry 870 etc. What I want to do is split my inventory between 5 locations randomly, but will only ever total the total inventory and then have VBA print the array so that it's like the following: Apple 156 Apple 142 Apple 52...

Can anyone help me with a VBA code that will take this list and create a summary list in column W-Y. Each item should have a subtotal like in the example in the next table. The Ticker and Name are in column A & B and the Amounts are in column P. The output should be place in in C. Greatly...

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

how to write a formula to add the "Product" field (New Column) to each entry under the same sub-group to create a new table (see below), your help is highly appreciated & thank you very much <colgroup><col><col><col><col><col span="2"><col></colgroup><tbody> Source Table Product-Order...

Hi there, I am very new to this but I would like to seek your views on how to go about doing this. What happened is I have 5 different worksheets which call the same thing by different names. For example, 1. Worksheet1: apple 2. Worksheet2: applie 3. Worksheet3: green apple 4. Worksheet4: red...

Hello, I have a question. I would like to calculated ratio's from a database with balancesheets in a pivot-table. The data is as follows: <tbody> Company Balance Sheet no Description Value Year Apple 3 Cash 25 2018 Apple 4 Inventories 35 2018 Apple 5 Short Term debt 75 2018 Facebook 3...

Hi everyone <tbody> Product wholeseller price/kg Apple ABC Rs 50 Orange ABC Rs 30 Apple XYZ Rs 40 </tbody> Using Product as the key i want to extract all the datas in new table like <tbody> Product ABC(Price) XYZ(Price) Apple Rs 50 40 Orange Rs 30 </tbody> I used formula to get...

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

Hi Lads, I have macro below which hides all rows and leaves all rows with text ''APPLE'' in F column on Sheet2, it works ok, but the problem is that in this table all cells are referrencing to different sheet i.e. ='Sheet1'!A1 which means Marco hides all rows not containing APPLE and all the...

Lads, Hope you can help me. I have Table in Sheet1 consisting of 100's of rows and about 20 columns similar to below. I need formula in Sheet2 that looks through Column A Sheet1 and if it finds APPLE IN CELL then it needs to copy whole row into Sheet2 and same for PEAR. This need to be in the...

Using " as a string is not as easy as I thought and I couldn't find any relevant informations on the net. Thank you very much fow your help!

Hi all. I would like to have a formula to replicate data from one row to one column skiping blanks. So I have in range A1:E1 ~~~> | apple | blank | pear | blank | orange | And I'm looking for a result like: B3 = apple B4 = pear B5 = orange Many thanks in advance