orange

Hello, I am trying to pull data from another large spreadsheet (thousands of rows) which is currently sorted to look something like this; A === B === C === D Item === Quantity === Price === Running Total Qty. Apple === 50 === $2.00 === 50 Apple === 100 === $2.25 === 150 Apple === 75 === $2.75...

Hello, It is possible SUM green cell (F4, J4 ..) only if in orange cell (L4, P4...) is empty ? orange cell is one cell away from left to the right thank you )) Excel file : https://www.catupload.com/download/d...0fc0e0569.html

Hello All, I'm trying to work on a formula regarding vlookup. there are basically 3 column. Column A's data corresponds to the data in column B. (basically, they are partners) I need to find (using vlookup) the values from Column C that are in Column A together with Column B. <tbody>...

Hi all, I am trying to compare two different headers from 2 different excel files. For example, for the 1st excel file, I have Apple, Orange, Pear, honeydew For the 2nd excel file, I have Orange dragonFruit, starfruit, pear, Apple. I need to manipulate the columns till it becomes...

Here i paste one excel report. In this, In need to make a report form a Master data with search keys.. please find the attached file and help me please... thanks in advance.. <tbody> Master Data Item No. Name Code Price Cat. 245 Apple Red UK 1.50 10 4157 Orange Naval USA USA 1.30 11...

I am trying use Index combined with 2 Match but I am stuck with my first Match. In the formula below, J3 equals a 4 digit number that needs to be found in A7:A17. The problem is in this array each cell has various 4 digit numbers separated by comma. For example if J3 = 8580 A7 could be: New...

I have One sheet which have one ITEM many times for example I need a formula which copy UNIQUE Item ONE time to Other sheet. Example One Sheet APPLE APPLE APPLE ORANGE ORANGE BANANA Other Sheet APPLE ORANGE BANANA

Hi All, In cell A1 is the word Orange which is a formula resulting from another sheet. In cell B1 I have a formula =A1 which results: Orange In cell C1 I have conditional format rule formula: =$B$1="Orange" Format orange fill. The format rule doesn't work when the formula results in Orange but...

Example Data: Column B Column C Column F Apple 1234 1.00 Orange 1234 1.25 Orange 4321 5.00 Pineapple 4321 3.50 Banana 4321 3.50 Grape...

Hi Friends, I am trying to build a formula to count consecutive value in a column, But I failed to get the count. I would like to get a value of "Yes" counting "Apple" when it comes very next or very before Orange. <tbody> Details Required Result Apple Yes Apple Yes Orange Apple...

Hi, In column F i have cells filled with shapes. Rectangle 1, 2 etc. In E I have either the text RED, Orange or Green. The text string is made of this formula: =IF(HR!J7>HR!E7;"GREEN";IF(AND(HR!J7<HR!E7;(0,8*HR!E7<HR!J7));"ORANGE";"RED")) I want the shape inF to be filled with color according...

Given the following <tbody> Andy Bob Jeff Blue x Black x Purple x Green x Yellow x Red x Brown x Orange x </tbody> How can I get the output to be (or can I): <tbody> Andy Bob Jeff Blue Black Purple Green Yellow Red Brown Orange </tbody> I am...

Hi everyone, I'm in need of your expertise to create a formula that sums up the total based on a dynamic variable. Example below- I have the months in columns that goes all the way to December, and apple and oranges repeat in rows. I'm trying to create a dynamic formula that calculates the SUM...

Hello Everyone, May I request for your assistance to create a formula for Column C (Delivery Status) to match Column E. <tbody> Country Fruits Delivery Status Delivery Status Country Fruit England Apple Yes Yes England Mango US Orange No Yes US Apple No Japan Orange...

Hello, I have a table, something like: <tbody> Column 1 Column 2 Adam Orange Ben Blue Charlie Orange David White </tbody> I want to use a list type validation in another range with the list values being where Column 2 = Orange, so the list would be: Adam Charlie I've Created a...

Hi, I am looking for a formula that will be able to populate a cell with the max value in a range based on a custom list. Example. CUSTOM LIST (Smallest to Largest) = ORANGE 00, APPLE 05, BANANA / HOLD, PINEAPPLE (If I have to have the list somewhere in my workbook it will be on a sheet...

Hi, How do I add sequential numbering in excel? Say I have below data Cell A1 Mango Cell A2 Apple Cell A3 Orange Cell A4 Banana and I would like it to be like below which is a function in MS Word Cell A1 1. Mango Cell A2 2. Apple Cell A3 3. Orange Cell A4 4. Banana I don't want to use...

Hi all i have the below macro. it essentially copies data from "master" sheet into "template" and then creates seperate employee ID based sheets - exact copy of master except only containing the employee specific data. it works fine, however, I am not sure how I can make it also take into...

Hi all, Sorry for the poor title. I'm having trouble describing this and as a result I haven't had much luck with google searches for what I suspect will be a straight forward function. If you have a look at the link below you will see my sample data. I want to be able to change the orange...