apple

Hi guys, I have a spreadsheet with multiple customers and price they paid for different items. I am trying to find what percentage they spent on each items Can it be done with vlookup? Here is an example: <tbody> Name Item Price Percentage Breakdown John apple 2 Tom apple 3 Amy apple...

Hey excel gurus, I would like my match and index formula to output me values that are reoccurring in my column A and not just for the first instance. for example my data looks like this <tbody> column A column B column C column D apple apple sweet banana banana yellow apple...

have the following formula so If A1 is No and A2 contains Apple and either A3 or A4 contain Yes then the result is Yes This works fine whenever I change any of the cells. =IF(AND(A1="No",ISNUMBER(SEARCH("apple",A2,OR(A3="Yes",A4="Yes")))),"Yes","No") However If I change the formula from...

Hi, I have the sheet bellow: <tbody> Product Value Indication Apple 50 TRUE Apple 50 Cherries 20 Cherries 20 Bananas 45 TRUE Bananas 45 Bananas 45 </tbody> And I want the following result: <tbody> Product Value Indication Apple 50 TRUE Apple 50 TRUE Cherries 20...

I'm using the code below to delete all rows that don't contain a list of words. For some reason it is deleting the cell that contains the word Apple and keeps the other three with Banana, Orange & Apple Tree. Hopefully someone can help me out. Also is it possible to search for Apple and...

Hello All, I have some data set up as per below: Header has three rows then multiple columns: <colgroup><col><col span="8"></colgroup><tbody> ABC KOP KLP TGF KLO NOM DAN 1425 8745 4256 2536 458 985 74856 Apple Mango Apple Orange...

Hi Team, I am looking some help on creating a macro which could help me sum values in column for B for similar text in col A and insert the sum field in col b for after every group its sums up and also insert a blank row after its sum the data <tbody> Names Value Apple 25 Apple 10...

Hi I'm using the below bit of code: bk.Sheets(1).Range(addr).Value = Evaluate(Replace("IF(@<>""APPLE"",FALSE,@)", "@", addr)) addr is the range I'm searching through using xlUp. I'm trying to get to the above to work whereby it will find "Apple" anywhere in the string in the cells as its...

<tbody> column/row A B C D 1 Item Unit or pallet unit per case Total Case 2 Apple 50 2 25 (=50/2) 3 Apple on a pallet 4 2 8 (=4*2) 4 Orange 8 4 2 (=8/4) 5 Orange on a pallet 15 4 60 (=15*4) </tbody> I want to use if formula to calculate for column D. what should the formula be? I...

HI - I want to create a column with concatenated column 3 like below. Basically select values from column 1 and column 2 where column 2 value is non zero. Can anyone please help ? Highly appreciated. <tbody> Column1 Column2 Column3 Apple 10 10 Apple, 8 Car, 2 Home Mango 0 Car 8...

Hello, How to highlight the last cell in column of similar values in column having different sets of values...

I need to count for which store and how many this store has the lowest price for each product? For example result - Shop1=0, Shop2=1, Shop3=2 Prod. Shop Price Apple Shop1 5 Apple Shop2 3 Apple Shop3 4 Pears Shop1 8 Pears Shop2 7 Pears...

Hi There, Another day, another challenge! I'm working on a stock shortages report and cant figure out how to lookup the stock value in another sheet and then cumulative subtract as it moves down the list. E.g Stock levels (Sheet3) <tbody> Column Part Qty A Apple 12 B Banana 6 C Carrot...

Hi, I have text in a single excel cell which looks like this: * Apple: some general text. * Pear: more text. * Orange:some more text. I need to extract the each instance of the strings between the characters * and :, and put them in separate, adjacent cells. e.g. <tbody> A1 B1 C1 D1...

Hi All, Need a help please with either using excel formula or Excel VBA to lookup cells with comma separated values. I have 2 tables below: table 1 and table 2. I will like the Col B (2nd column) of Table 1 to return a true or yes when any of the value is in the Col A (first column) of table...

Hi there, I am having no luck with my index match formula. I am trying to create a formula that will match with the following criteria "Apple" and "FY19" to return the number 200. If anyone can help that would be really appreciated. Any suggestions on formulas? <tbody> Opportunity# Apple...

Hi, coming back after a long time:) coz i need your help very badly. I have 2 columns like below, I simply need to to transpose these data into columns in a new sheet List 1 List 2 Apple Boomerang Apple Offerings Apple Industrial Equipment Apple Chemicals & Natural Resources Apple Consumer...

I have data that is consolidated into single cells. I'd like to alphabetize the strings within the cells they are in: <tbody> Original Data Alphabetized Data Orange,Apple,Banana Apple,Banana,Orange Grape,Apple,Grape,Banana Apple,Grape,Grape,Banana Grape Grape Apple,Orange Apple,Orange...

OK - Not sure if that title even explains it properly... I have a questionnaire which asks several questions about a certain topic, and then later on a "double check" single question and I want to set up a formula to check if the answers in the first section are in line with what they answer in...

Hello All, I will need help with below tables calculation... There are huge datas all the way down from column A. So if its possible I need to place formulas to get proper calculatin base on given table below starts from column J Many Thanks...