kiwi

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

<tbody> A B C D E 1 Apple Orange Kiwi Response 1 Response 2 2 =countif(D2:E2, "Apple") =countif(D2:E2,"Orange") =countif(D2:E2,"Kiwi") Apple Kiwi 3 </tbody> Do refer to the above for your understanding. Given that as time goes by, I will have data add on Column F, G, H, I and...

Hi Everyone, I have a data set where i have duplicate entries. I want to return first duplicate entry as Digit 1 and other duplicated entry of the same name as zero. For example Apple 1 Apple 0 Kiwi 1 Kiwi 0 Kiwi 0 Apple 1 As you can see in the example the other duplicate...

Hi, I have below requirement, can any one help; My data is like: Fruit Country Apple USA Apple China Apple UK Kiwi Germany Kiwi UK Grape USA Grape Canada I have to create two dropdowns Fruit: Apple, Kiwi, Grape Country: Populate Based on Selected Fruit I managed to create the Fruit...