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

Hello,

Please find attached a schedule that I find some problems to sort, Actually dates should update automatically, I got them to work, but I guess my way is not really the right one,

if you can help, plz have a look at the file, all explained inside.

Thanks

Please find attached a schedule that I find some problems to sort, Actually dates should update automatically, I got them to work, but I guess my way is not really the right one,

if you can help, plz have a look at the file, all explained inside.

Thanks

Two issues: I am trying to identify the number of students by class level (there are several levels); of a specific grade, of a certain demographic (demographics is represented by a number). Each student is represented by a student ID--However I do not want to count the student twice..I have no idea how to do this.

This is the formula I've been using, =IFERROR(ROWS(UNIQUE(FILTER('FinalGrades19-20'!$C$2:$C$16777,('FinalGrades19-20'!$V$2:$V$16777="Level 1")*('FinalGrades19-20'!$T$2:$T$16777=9)))), 0)

Also, if I try to add another variable (demographic #) it errors. I'm not sure this is the most efficient formula. I'm new to excel. Confused. Frustrated.I've attached an example.

Example.xlsxExample.xlsx

This is the formula I've been using, =IFERROR(ROWS(UNIQUE(FILTER('FinalGrades19-20'!$C$2:$C$16777,('FinalGrades19-20'!$V$2:$V$16777="Level 1")*('FinalGrades19-20'!$T$2:$T$16777=9)))), 0)

Also, if I try to add another variable (demographic #) it errors. I'm not sure this is the most efficient formula. I'm new to excel. Confused. Frustrated.I've attached an example.

Example.xlsxExample.xlsx

Auto excel formula needed for next due date of employees air ticket after removing LOP. Ticket duration without Leave 365 days (LOP excluded)

Yearly employees have one holiday ticket approx (500$), It is eligible for 365 worked days. Suppose in between this duration one employee taken10 days leave then his next due date will be (duration 365+ leave days 10) = 375 days, means leave days excluded in 365 for due.

Please help for make a solution .

Thanks and regards,

Dackson

Yearly employees have one holiday ticket approx (500$), It is eligible for 365 worked days. Suppose in between this duration one employee taken10 days leave then his next due date will be (duration 365+ leave days 10) = 375 days, means leave days excluded in 365 for due.

Please help for make a solution .

Thanks and regards,

Dackson