I'm a bit new to excel, or may be not so new but very green yet specially when it comes to nesting functions.

The below is to get how many years, months and days have passed since a given date.

It worked fine except that it would give me years/months/days even if it was just the 1 month (1months instead). With help I managed to sort out the days but tried different ways to get the same for the years and for the months but really struggling to nest the IF function to get month or months respectively and year or years.

=DATEDIF(H4,TODAY(),"y")&" years,"&DATEDIF(H4,TODAY(),"ym")&" months, "&DATEDIF(H4,TODAY(),"md")&IF(DATEDIF(H4,TODAY(),"md")>1," days"," day")

]]>The below is to get how many years, months and days have passed since a given date.

It worked fine except that it would give me years/months/days even if it was just the 1 month (1months instead). With help I managed to sort out the days but tried different ways to get the same for the years and for the months but really struggling to nest the IF function to get month or months respectively and year or years.

=DATEDIF(H4,TODAY(),"y")&" years,"&DATEDIF(H4,TODAY(),"ym")&" months, "&DATEDIF(H4,TODAY(),"md")&IF(DATEDIF(H4,TODAY(),"md")>1," days"," day")

I have a list of contact center employees with certain number of surveys and certain CSAT(Customer Satisfaction score for surveys). I figured out way to find maximum surveys and respective CSAT achieved for that particular number of surveys. I also have found formula to get names of employees matching max survey and max CSAT criteria.The problem with the formula is it omits duplicate entries. As in the example,there are 2 employees with same scores but the formula lists only employee 10. How do I improvise the formula to list all employees including duplicates? I have attached the sample data file and a screenshot below.

ForumPost1.xlsx

ForumPost1.xlsx

I'm using index match to match an id from one worksheet1 to worksheet 2 and populate the field worksheet 1 (ROW H). However, the index match isn't working for the entire array--I'm guessing it's because of the different lengths?? Is there something else I can do?

Good morning,

Please I need help in this excel sheet. (attached)

In Colomn B, I have mentioned 3 products.

Each one has a price:

ACUPX: 1000

ACUPY: 2000

ACUPZ: 3000

What I need is that the prices change automatically in Column D if we change the product mentioned in column B.

For example: if we change in column B4 ACUPZ to ACUPY the price change from 3000 to 2000.

Thanks for help, Book1.xlsxBook1.xlsx

Please I need help in this excel sheet. (attached)

In Colomn B, I have mentioned 3 products.

Each one has a price:

ACUPX: 1000

ACUPY: 2000

ACUPZ: 3000

What I need is that the prices change automatically in Column D if we change the product mentioned in column B.

For example: if we change in column B4 ACUPZ to ACUPY the price change from 3000 to 2000.

Thanks for help, Book1.xlsxBook1.xlsx

I have a list of competitors and their dogs that earn points in competitions that need to be tracked for the year. Currently, the standings are based on the total points earned by each team, but I would like to set up a scenario where I can see standings based only on the sum of a certain number of each team's top scores (either 5, 10, or 15).

I have formulas in place to sum up the number of competitions that each team has earned points in, as well as their total points earned for the year, but I don't know how to write the formula to add up only the top 5, 10 or 15 sets of points for each team. Is this possible?

I've attached my worksheet with my current progress.

Thank you

I have formulas in place to sum up the number of competitions that each team has earned points in, as well as their total points earned for the year, but I don't know how to write the formula to add up only the top 5, 10 or 15 sets of points for each team. Is this possible?

I've attached my worksheet with my current progress.

Thank you

Hi I have the formula below but it returns FALSE when I want it empty if C8 cell is empty.

Can you help pls?

=IF(C8="","",IF(AND(K8<>"",O8=""),"Needs Pricing",IF(AND(K8="",O8<>""),"Needs Quote",IF(AND(K8="",O8=""),"NoQuote NoPrice",IF(AND(K8<>"",O8<>""),"Quoted&Priced")))))

]]>Can you help pls?

=IF(C8="","",IF(AND(K8<>"",O8=""),"Needs Pricing",IF(AND(K8="",O8<>""),"Needs Quote",IF(AND(K8="",O8=""),"NoQuote NoPrice",IF(AND(K8<>"",O8<>""),"Quoted&Priced")))))

Hi gents,

I am trying to find the correct syntax/formula for getting a value from a table based on a value from another cell in an other sheet.

Eg this is the table

In my other sheet I have

61427 but a few cells lower i want to get the second value from the tabel "6152"

so in cel A1 I have =A10 and I want to get the below value from A11

hope that makes sence

]]>I am trying to find the correct syntax/formula for getting a value from a table based on a value from another cell in an other sheet.

Eg this is the table

In my other sheet I have

61427 but a few cells lower i want to get the second value from the tabel "6152"

so in cel A1 I have =A10 and I want to get the below value from A11

hope that makes sence

Hello, I have the following formula: SUMPRODUCT((YEAR(Breakdown1!$N$2:$N$155)<YEAR('Capacity v Demand'!C$1))*(Breakdown1!$O$2:$O$155='Capacity v Demand'!$A2)*(Breakdown1!$P$2:$P$155))

On the Breakdown sheet the number of rows is constantly changing. With the number of rows constantly changing I am getting #VALUE errors. in the capacity v demand work sheet. I'm not sure how to change my formula to accommodate for the changing number of rows.

Thanks in advance

]]>On the Breakdown sheet the number of rows is constantly changing. With the number of rows constantly changing I am getting #VALUE errors. in the capacity v demand work sheet. I'm not sure how to change my formula to accommodate for the changing number of rows.

Thanks in advance

Does anyone know of a formula that will total monthly hours for multiple cells: Example: D16:S16+D30:R31???

Hello. I need a Vlookup formula which searches one sheet for learners and retrieves data from a specific column. In the attached example, I believe the data to be retrieved is in column 15. I will use this as a template and update the 15 to the correct column number for future reports. Any assistance will be greatly appreciated!

Example.xlsxExample.xlsx

Example.xlsxExample.xlsx

An amateur at excel and wanting to learn more but with little time on my hands each day to take courses, I decided it was time to ask for help from professionals who use it daily. I don't expect someone to finish the project, only need help directing me to the correct place to obtain it. An air traffic control manager by trade, I am always looking ways to decrease my workload. This is where Excel has helped me in the past.

My issue is this this; Controllers work set days off. In the Master Entry Form worksheet, it tells me the set days off for each controller. I would like to find a function/formula which will take that basic weekly schedule and enter into a monthly schedule (Sheet1). Please attached file.

Thank you in advance for any help you can provide, to steer me in the right direction.

My issue is this this; Controllers work set days off. In the Master Entry Form worksheet, it tells me the set days off for each controller. I would like to find a function/formula which will take that basic weekly schedule and enter into a monthly schedule (Sheet1). Please attached file.

Thank you in advance for any help you can provide, to steer me in the right direction.

hey gurus, I'm very new to excel and only use it about once a year when my annual price increase takes effect, but I'd like to learn more outside of the issue I'm having so this will be great resource I'm sure.

I receive a spreadsheet from my vendors with the new pricing for the year, it has formulas aleady built in to price for my markup. What I wish to do is input a ceiling to round the retail numbers to the nearest whole multiple of 5.

my spreadsheet has a cell to input my markup margin, then a cell with a long formula to basically say hey take the wholesale cost, divided it by the margin and input it into the retail cell...

This is the long formula for that

=(100-(L12/100)*100)/100 with L12 being my markup %

then the retail cells say this formula

=IF(ISBLANK(Q8)," ",Q8/$Q$1) with q8 being the cost, and Q1 being the margin.

so example, L12 is 28, making Q1 .72

if the wholesale is $1046, it brings retail to $1453

I want to make the retail come up to the nearest whole 5 on the entire worksheet.

I hope this makes sense and I hope someone can help me figure this out. please ask if more info is needed and thanks hugely in advance if anyone knows what to do!!

]]>I receive a spreadsheet from my vendors with the new pricing for the year, it has formulas aleady built in to price for my markup. What I wish to do is input a ceiling to round the retail numbers to the nearest whole multiple of 5.

my spreadsheet has a cell to input my markup margin, then a cell with a long formula to basically say hey take the wholesale cost, divided it by the margin and input it into the retail cell...

This is the long formula for that

=(100-(L12/100)*100)/100 with L12 being my markup %

then the retail cells say this formula

=IF(ISBLANK(Q8)," ",Q8/$Q$1) with q8 being the cost, and Q1 being the margin.

so example, L12 is 28, making Q1 .72

if the wholesale is $1046, it brings retail to $1453

I want to make the retail come up to the nearest whole 5 on the entire worksheet.

I hope this makes sense and I hope someone can help me figure this out. please ask if more info is needed and thanks hugely in advance if anyone knows what to do!!