greater than

I am looking for a way to search the entire worksheet of multiple spreadsheets within a single folder for values greater than 100. If cells values of greater than 100 are found, then these will be listed in a worksheet/tab with file directory, worksheet name, cell address, cell value, and...

Hi, I am looking at returning a adjacent value that is 'less than' from an array. In this example I want to return what is in Column A where the value is less than 20. So for instance A B Website 60 Facebook 59 Twitter 47 Email 52 Third Party 10 This would return 'Third Party'. I have...

I have 4 cells with data, I want to compare the 1st 2 to find which is the greater, from that result, then state which cell is for start of a line, then compare the 2nd 2 cells to find which is the greater, and from that result, then state which cell is for end of a line. Draw line from stated...

Hi I am having trouble filtering greater than in one range and less than in another range at the same time. If i separate them, they work separately but not at the same time. What is going on and can anyone help. Here is the code below. Sub Filtergreater() Sheets("FolderSort").Select...

I write quite a bit of vba but I really cant get my head around this one! I have entered this in Cell L204 =SUMIF(N204:Z204,">0") Works a treat. I would like a vba that enters this in All rows this a value in column N Don't know why but I just cant seem to get my head around it today! Any...

Mr. Excel, I am attempting to find/write some VBA code for looking at a manufacturing Bill fo Material for a finished product, and deleting any Bill of Material Lines below purchased parts. Assuming the "Line#" heading below is in cell A1, can you help me with some VBA code for this? The...

Hi all, =TREND(known_y's,known_x's,new_x's,const) I am trying to use the TREND function to return a value for a certain x (in this case 10). The known y's come from column A and known_x's from column B. However, I only want to get the trend for functions for values greater than 0 in row C. I...

Hi I need help with an IF formula I need to calculate a charge based on the number of transactions for a customer. To explain, the customer gets charged £500 if they do 1000 orders. If they do 1001 they get charged £500 plus 1 times the second bracket- £0.40. Finally if they do 3001 orders...

Having trouble with this one - Pls Help me display the appropriate point, when the value falls within the following ranges. Have not been able to find the right vlookup combo. Note: As I will reuse the basic formula for different upper & lower data range values, I would like avoid hard-coding an...

I am struggling to create a formula that will give me a count of the cells in column c that are greater than their counterparts in column b and which have the value of "fall" in column h and "2008" in column I. Here is what I have tried so far:=COUNTIFS('ASA AWA Data'!$C2:$C1284,">"& 'ASA AWA...

Hi all, I have a question that's a little hard to explain.. I have 2 cells, A1 and A2 and also a table C1:D4. I want to use formulas, no VBA/macro, to input a value from the table into A3. Let me give an example.. <TBODY> A B C D 1 24 w 1 2 3 x 6 3 y 11 4 z 16...

this might be an elementary question but i cant think of the function to do this formula i'm trying to find a function that will sum up a value if is it greater that 5, and will sum up the total that is greater than 5 i.e. read the following sequence of numbers, --1,5,6,7,8, ---the function...

Hello, I would like to filter a column based on whether or not it is 'greater than' or 'less than' an adjacent cell. e.g: should the value in A1 be less than B1, it will show up in the results of a filter. and so on for A2 and B2, A3 and B3... Any ideas? Have I missed something?

Hi, this is what I want excell to do =SUMIF(additional,additional>0,Principal) count amount in "principal" row if aproprieate cell in "additional" row is greater than null but my "additional>0" is not apprehensible for excell could you help me?

I'm working on an array formula for dollar amounts and autofilling the necessary phrases based on a financial threshold. If amount in K3 is equal to or over $100,000, populate “WALT” in U3 If amount in K3 is less than $100,000, populate “MIKE” in U3 If K3 is blank, U3 remains blank I believe...

I use a "RTD" link to calculate a value. As the data changes over time, I want to save the Largest and the smallest value in another cell. Is there a simple way to record the largest or smallest value from the real time data? ...Replace if greater function?

Hello, I am trying to use the following formula: =IF(E31<=E27, J27,IF(E31>E29, $J$29, IF(E31=E28, $J$28, IF(E28>E31>E27, ((E31-E27)/(E28-E27))*$J$28, IF(E29>E31>E28, ((E31-E28)/(E29-E28)*($J$29-$J$28))+$J$28, ""))))) It works except for those values that fall in between two numbers, in this...

my formula below is returning #VALUE What I need is: If C2 is "New" and G2 is less than 7 but greater than 3 then return .0.1; If G2 is less than 5 but greater than 3 then return .0125; If G2 is less than 3 but greater than 0 then return .015; if G2 equals zero then return zero. If C2 is...

Without going into too much detail of the process, the tool I am designing allows the supervisors of a net repair shop calculate how long each panel will take to complete, and what time the net will be completed at. To calculate the time, the supervisor enters in information on each panel, and...

What i have been trying for hours and failing at is excel's daft logic when it comes to using 2 cells and a > combined with a < function. What i am trying to do is, (written in plain terms) IF F1600 is more than equal 5 BUT less than equal 7 AND M1600 is more than 0 BUT less than equal 2...