-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
blueberry
-
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...- MikeL
- Thread
- blueberry col column kiwi orange
- Replies: 4
- Forum: Excel Questions
-
D
COUNTIF formula
Hello, I'm trying to use the following formula: =COUNTIF(D2,"Vanilla")+COUNTIF(D2,"BlueBerry")+COUNTIF(D2,"Cherry") I also would like to add if cell (D2) is blank, then use the data in Cell (C2). I'm not sure how to write that part of the formula. Example Data Sheet...- DarrenF
- Thread
- banana blueberry data formula vanilla
- Replies: 4
- Forum: Excel Questions
-
S
Concatenate double Vlookup in One Cell from two table
Hi, I am trying to concatenate vlookup formula in one cell from two different table. I am apply the following formula in formula required sheet but formula return NA...- SAXON10
- Thread
- bilberry blueberry formula sheet table
- Replies: 2
- Forum: Excel Questions
-
A
Compare the data
Hello All, I want to compare two data's. My A-D are main data, F-I are my ref data. I have to check is the reference data have the same value or not. If it dont have it then it should provide correct data. If you see Stephen have the same Fruits in both Main and Ref data. Some thing should...- anee_4285
- Thread
- apple banana blueberry compare 2 cells data
- Replies: 6
- Forum: Excel Questions
