banana

Hi all, I'm very new to excel queries and was wondering if i'd better off using VBA for what I'm trying to achieve? Also are queries the same as power query? Is power query an add in? (Like I say I'm very new) Essentially, I'm trying to combine worksheets into one Master workbook and then...

Hi all, This is taken from a previously asked question but that allowed VBa. In this case I am trying to do it via formula and not use multiple columns to get the result. IE only the cell in "C" has a formula. This should keep all guru's busy for awhile :laugh: I sure as heck have not got far...

Fairly experienced user of Excel but not really used anything more than a basic column/line graph for using two columns of data. I now have three columns of data and i feel like, with experience, it may be possible to work out a way to show the data in a useful manner - Though i haven't got a...

I have the following code in my macro: itemnocol = Application.Match("Item#", Worksheets("Prices").Range("1:1"), 0) banana = Application.Match("Dist Price", Worksheets("Prices").Range("1:1"), 0) I get the correct answer for "itemnocol", but using the exact same wording, I get an "Error 2042"...

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

Using the formula here: https://exceljet.net/formula/index-and-match-with-multiple-criteria I have an index-match setup with about 5 or 6 different criteria. for simplicity sake, let's say there are only two criteria <tbody> A B C D E 1 FRUIT SIZE PRICE 2 BANANA 10 £6.50 3...

I have the following data: <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> Jan Feb Mar Apr Apple 1 2 3 4 Orange 4 3 2 1 Banana 2 2 2 2 Apple 3 4 5 6 Orange 5 4 3 2 Banana 3 3...

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

Hello Gurus, Seeking your expert help in writing a Macro. Am a newbie. I have a below table: <colgroup><col><col><col><col><col><col span="6"></colgroup><tbody> Sold On Mon Tues Wed Thu Fri Sat Sun Item 1 Apple 10 20 30 40 50 60 70 2 Banana 11 12 13 14...

I am having a table with 2000 rows and trying to do a COUNTIFS to find how many combinations i have for the below example. With one criteria it is coming properly but when i add the next criteria it is not working. also i cannot type "Apple" i need to reference the cell since i have around...

I want to take the input cells, lookup their color values, then count the color occurrences. Probably need to use array but it's my achilles heel. Thanks!! <colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody> A B C D E F G H INPUT FRUIT...

Hi, So I have a case where I need to return all results in a column where 2 criteria are met into one cell. My table looks something like this +-----------+------+-------+ | Job | Type | Name | +-----------+------+-------+ | Tree | AA | Bob | | Apple | FF | John | |...

Dear All, Need some help on retrieve unique values into column E. Please refer below for samples. i have tried vlookup and hlookup but can't work :( <tbody> columnA columnB columnC columnD columnE reference apple not not not apple watermelon not orange not not orange banana not not...

Hi! This seems a very interesting code for me, however I couldn't figure out how I could solve it. I need to build an alphabeticel order from the words of cells. Sample: Column "A" (Input) The apple is red. Banana is unhealthy. Cambridge is a very nice place. Buy a camion. Visiting Canada is...

Dear All, Hope you could help me find an excel formula for below condition. Thank you <tbody> Celll reference result Item Qty Apple 3 Apple Banana 2 Apple Mango 0 Apple Apple 2 Banana Banana Apple Apple </tbody>

Hi! I need some help with a nested if function. There is a code which checkes for every word in my list and excutes some command based on the value of the cell. However, if the cell's value is on my list, then the "pair" of the word should be the cell's value which is stored on a list...

<tbody> Base FINAL STATUS DATA 1 DATA 2 DATA 3 Apple ok Orange no Mango sample Banana no </tbody> Based on the table above. I would like to know how can I merge the data from columns DATA 1 to DATA 3 into the FINAL STATUS column. Like the TABLE below. <tbody> Base FINAL...

Hello, I have a count in column Q. After I insert a blank row, I would like to do a find for the blank cells in column Q and do a sum of the data above each blank cell. For instance, each section is divided by each different fruits. Where the Total row is, that is where the total sum will...

Hello, I have a code below that will find changes in column J and will insert a blank row after the change. My issue is that when I continue with the rest of the code, it will leave the last row as blank instead of adding a footer with the header and formatting needed. I have data in columns...

Hello please help me with this: I have this: <tbody> apple red 20 max orange green 34 min banana yellow 56 max berry black 76 min watermelon yellow 40 min </tbody> I want this: <tbody> apple red 20 max orange green 34 min banana yellow 56 max berry...