Hi,

Can someone help me with putting up formulas for cells O12:O14 in "Summary" sheet. I would want to know how many got 90% and above for O12, 85% to 89.99% for O13, and 84.99% in O14.

Thanks!

Can someone help me with putting up formulas for cells O12:O14 in "Summary" sheet. I would want to know how many got 90% and above for O12, 85% to 89.99% for O13, and 84.99% in O14.

Thanks!

Hi.

I have a list of names that I either want the column colored red, green, or yellow. Right now I have two differnet rules, one for red, and one for yellow.

so for instance yellow is =AND(B1="ABC",C1<2) and red is =AND(B1="ABC",C1>2). I will add a third for green, but my question is what is the most clean and efficient way to do this? Can this be in one giant conditional format rule or do I need to make three different ones?

TY!

]]>I have a list of names that I either want the column colored red, green, or yellow. Right now I have two differnet rules, one for red, and one for yellow.

so for instance yellow is =AND(B1="ABC",C1<2) and red is =AND(B1="ABC",C1>2). I will add a third for green, but my question is what is the most clean and efficient way to do this? Can this be in one giant conditional format rule or do I need to make three different ones?

TY!

Hello,

I am trying to write an IF formula that returns values if the adjacent cell falls into a date range that is measured by the day number that year. For example, If the number is within 20 days of day 45 (less than day 45+10 (55) and greater than day 45-10 (35). I run into a problem when the range falls over the new year, day 365 and day 1. So I have the formula somewhat correct, just not sure on how to do the math for when the range falls over the new year. I imagine it is adding an if greater than 365 or less than 0 then add 365 etc. But can't seems to get it.

I have attached a sample sheet. Here are the columns:

A) The day number of the year represented by the formula --> =B3-DATE(YEAR(B3),1,1)+1

B) The date

C) Values A

D) Values B

E) The formula that only shows/repeats the value of values B/column D if the IF function is true

You will see the variable numbers highlighted yellow. If you change the day number and the range so it flows over the new year, day 1 or 365, All of the numbers disappear.

I really hope I am explaining this correctly.

Thanks so much!

I am trying to write an IF formula that returns values if the adjacent cell falls into a date range that is measured by the day number that year. For example, If the number is within 20 days of day 45 (less than day 45+10 (55) and greater than day 45-10 (35). I run into a problem when the range falls over the new year, day 365 and day 1. So I have the formula somewhat correct, just not sure on how to do the math for when the range falls over the new year. I imagine it is adding an if greater than 365 or less than 0 then add 365 etc. But can't seems to get it.

I have attached a sample sheet. Here are the columns:

A) The day number of the year represented by the formula --> =B3-DATE(YEAR(B3),1,1)+1

B) The date

C) Values A

D) Values B

E) The formula that only shows/repeats the value of values B/column D if the IF function is true

You will see the variable numbers highlighted yellow. If you change the day number and the range so it flows over the new year, day 1 or 365, All of the numbers disappear.

I really hope I am explaining this correctly.

Thanks so much!

Hello,

My problem is very simple.

I have a cell where there is a value which is a quantity.

I need to create a formula to change the price according to the quantity.

I already have the information of the different prices in the rows.

From 0 to 10 units, price is 10 euros, from 11 to 20 units the price is 8 euros, more than 20 units the price is 5 euros.

I tried to do that with the IF function by I guess you can't create multiple arguments such as bigger than x and smaller or equal than y.

Thank you for your help.

]]>My problem is very simple.

I have a cell where there is a value which is a quantity.

I need to create a formula to change the price according to the quantity.

I already have the information of the different prices in the rows.

From 0 to 10 units, price is 10 euros, from 11 to 20 units the price is 8 euros, more than 20 units the price is 5 euros.

I tried to do that with the IF function by I guess you can't create multiple arguments such as bigger than x and smaller or equal than y.

Thank you for your help.

Hello All, I am trying to do something that I think is simple but can't get to work. I would like to put a Date Stamp in a cell when another cell is edited. Any suggestions on and easy way to do this? Thanks in advance.

]]>hello everybody,

this is my first post here.

I send you a file so you can understand what i mean.

I need a conditional formula in order to consolidate some data using data in 2 columns. the 2 columns have rather low quality data, sometimes with blanks, sometimes with differences, and this formula is to make a complete column with all the data i need.

I let you have a look. I tried several things but each time i failed.

thanks for you help,

Aladin

this is my first post here.

I send you a file so you can understand what i mean.

I need a conditional formula in order to consolidate some data using data in 2 columns. the 2 columns have rather low quality data, sometimes with blanks, sometimes with differences, and this formula is to make a complete column with all the data i need.

I let you have a look. I tried several things but each time i failed.

thanks for you help,

Aladin

Hi

I attached data to excel and the odds are shown as dates. I attach a sample here. For example E2 is now "helmi.30" and it should be 2,3 and G2 is now "maalis.28" and it should be 3,28. How can i change it so that the odds are no longer mixed to dates...?

I attached data to excel and the odds are shown as dates. I attach a sample here. For example E2 is now "helmi.30" and it should be 2,3 and G2 is now "maalis.28" and it should be 3,28. How can i change it so that the odds are no longer mixed to dates...?

I'm not certain how to even ask this question. That frustrates me because I have the 2007 excel bible but I've had no luck looking it up.

The attached worksheet shows a simplified parts pick sheet for a warehouse. Based on Employee and selected options it tells the warehouse how much of a certain item to pack for an employee. There is a calculator based on simple IF, THEN, ELSE type of logic.

There is a text box on the sample file that clarifies the behavior of the calculator I am trying to control.

And, if this is something that is really long, involved, and a pain ... cool. I will happily take advice that points me in a general direction. Many thanks guys.

The attached worksheet shows a simplified parts pick sheet for a warehouse. Based on Employee and selected options it tells the warehouse how much of a certain item to pack for an employee. There is a calculator based on simple IF, THEN, ELSE type of logic.

There is a text box on the sample file that clarifies the behavior of the calculator I am trying to control.

And, if this is something that is really long, involved, and a pain ... cool. I will happily take advice that points me in a general direction. Many thanks guys.

Hi

I want to highlight only the cells that have the same name repeated more than 5 times between 2 columns.

The formula below works except when entering formula into conditional formatter in excel it highlights all the cells from D4:E10 which contains other names.

=SUMPRODUCT((D4:E10="Billy")*(D4:E10>5))

cam.PNG

Basically If Billy is repeated more than 5 times I want to highlight all Cells containing Billy within cells D4:E10.

I appreciate any help on this

]]>I want to highlight only the cells that have the same name repeated more than 5 times between 2 columns.

The formula below works except when entering formula into conditional formatter in excel it highlights all the cells from D4:E10 which contains other names.

=SUMPRODUCT((D4:E10="Billy")*(D4:E10>5))

cam.PNG

Basically If Billy is repeated more than 5 times I want to highlight all Cells containing Billy within cells D4:E10.

I appreciate any help on this

Hi

The sumifs formula in C6 is not working since I have started trying to use with trimmed data. The reason for trimming is that sometimes the data will have the dashes between numbers and sometimes not, or maybe there is another way to over come this.

Example below.

Any ideas would be greatly appreciated.

Thanks in advance

The sumifs formula in C6 is not working since I have started trying to use with trimmed data. The reason for trimming is that sometimes the data will have the dashes between numbers and sometimes not, or maybe there is another way to over come this.

Example below.

Any ideas would be greatly appreciated.

Thanks in advance

I'm trying to combine a "Vendor" summary sheet and a "Customer" summary sheet. The problem is some companies are on both lists and hence there are times when there is only one entry to move to the "Combined" list, and other times when there are two entries that need to be added and then moved to the list.

This the unsuccessful formula I have so far in cell C6:

Here's a screen grab of the sheet:

Combine Data.jpg

Here's a reduced version of the file (look under "Pallets - Year" tab):

This the unsuccessful formula I have so far in cell C6:

Formula:

=INDEX(U6:V47,MATCH(LEFT(B6,5),LEFT($U$6:$U$47,5),0),2)+INDEX(AN6:AO47,MATCH(LEFT(B6,5),LEFT($AN$6:$AN$47,5),0),2)

Here's a screen grab of the sheet:

Combine Data.jpg

Here's a reduced version of the file (look under "Pallets - Year" tab):

I need the formulas to calculate the C-1 and D-1 as per the drawing attached.

I believe that it should be easy for someone who knows trig and geometry.

The cells that are associated with these are as follows.

A-1 = C5

C-1 = C6

D-1 = C7

R-1 = C3

X-3 = C15

If you need the Diameter it is.

X-5 = C17 (Result 7918.00)

Thank you for and help you can provide.

Excel Help (2-26-2017).PNG

]]>I believe that it should be easy for someone who knows trig and geometry.

The cells that are associated with these are as follows.

A-1 = C5

C-1 = C6

D-1 = C7

R-1 = C3

X-3 = C15

If you need the Diameter it is.

X-5 = C17 (Result 7918.00)

Thank you for and help you can provide.

Excel Help (2-26-2017).PNG

HELLO,

I require a formula that will give count of unique values with multiple Criteria,

File attached.

Sheet 1:

- Column A = Membership Numbers

- Column B = Age

Sheet = 'Age Band'

formula that returns Count of Unique 'Membership Numbers' as per the age band set in Sheet 'Age Band'.

Thanks

I require a formula that will give count of unique values with multiple Criteria,

File attached.

Sheet 1:

- Column A = Membership Numbers

- Column B = Age

Sheet = 'Age Band'

formula that returns Count of Unique 'Membership Numbers' as per the age band set in Sheet 'Age Band'.

Thanks

Hi guys I hope some of you excel ninjas could help me out:

Basically I have a drop down menu with diffrent countries: and I have a dropdown list with them sorted, Basically I want a country flag next to selected country.

https://imghost.io/images/2017/02/26/heeeelp.png

It works perfectly for line 4, here is the code I used in formulas: "flagpic" =INDEX(Sheet2!$S$4:$S$6;MATCH(Sheet2!$D$4;Sheet2!$R$4:$R$6;0))

The problem Im having is when I try to add a new "line 5" the flag does not change based on D5 value but d4s value. what can I do to fix this ?

any help i would appricate :)

]]>Basically I have a drop down menu with diffrent countries: and I have a dropdown list with them sorted, Basically I want a country flag next to selected country.

https://imghost.io/images/2017/02/26/heeeelp.png

It works perfectly for line 4, here is the code I used in formulas: "flagpic" =INDEX(Sheet2!$S$4:$S$6;MATCH(Sheet2!$D$4;Sheet2!$R$4:$R$6;0))

The problem Im having is when I try to add a new "line 5" the flag does not change based on D5 value but d4s value. what can I do to fix this ?

any help i would appricate :)

I need a formula to change the cell that's referenced when I paste the data into another cell. Is there a way using offset or indirect to make this happen. The pasting needs to go like this In cell "H2" is data that's pasted in "L2" then "M2-Q2" has other formulas. In cell "R2" I want the value of "I2" then another five cells of formulas then I want the value of "J2" in "X2" and so.

I attached a spreadsheet further breaking down what I need. Thank you for all of you help.

I attached a spreadsheet further breaking down what I need. Thank you for all of you help.