I have to summarise what we borrowed for a month and what interest is due for that month.

There are two schedules. one at 9% and one at 8% I have to add the principle together and the interest is in seperate tabs.

I have searched through here and i know it will more than likely be sum ifs but i just can't work it out as it is over an 18month period and I'm getting confused with the years.

Sheet attached.

There are two schedules. one at 9% and one at 8% I have to add the principle together and the interest is in seperate tabs.

I have searched through here and i know it will more than likely be sum ifs but i just can't work it out as it is over an 18month period and I'm getting confused with the years.

Sheet attached.

Hello

this is my first time here.

Guys really would appreciate your help

we have a data set in excel..and we are using it for data import to our web analytics tool but it always faild to validate

the fact is that we got also the exact scheme from our web analytics tool how the first column should look like

However there are still som issue to be validate it as right file for import

Please can you look at it and help me to create csv file?

Below is first part of the file although it is longer sheet

What we need is to those columns belong to particular header in that column

Thing is there are as well commas and quotation marks

Please any help is apreciated..thanks a lot!!!!!

with respect Mayo

this is my first time here.

Guys really would appreciate your help

we have a data set in excel..and we are using it for data import to our web analytics tool but it always faild to validate

the fact is that we got also the exact scheme from our web analytics tool how the first column should look like

However there are still som issue to be validate it as right file for import

Please can you look at it and help me to create csv file?

Below is first part of the file although it is longer sheet

What we need is to those columns belong to particular header in that column

Thing is there are as well commas and quotation marks

Please any help is apreciated..thanks a lot!!!!!

with respect Mayo

Hello,

Thanks for reading my post. I would like to have some help on an if statements with 3 criteria.

I have attached a worksheet here. Commission rate is 10% with 3 exceptions:

1) If column A match any value in column K, zero commission

2) If column b > column c, zero commission

3) if in Column A the number is ANDR05, and column B is less than column C, then 5% commission, If column c is greater than column B, zero commission

Thanks for the help.

Jackson

Thanks for reading my post. I would like to have some help on an if statements with 3 criteria.

I have attached a worksheet here. Commission rate is 10% with 3 exceptions:

1) If column A match any value in column K, zero commission

2) If column b > column c, zero commission

3) if in Column A the number is ANDR05, and column B is less than column C, then 5% commission, If column c is greater than column B, zero commission

Thanks for the help.

Jackson

Hello everyone,

I manage a planning where people report different activity types, let's say "Work" or "Special activity" (with different types, like 1 2 or 3).

While keeping my main planning where everything is reported, I am looking for a way to filter out on all special activities (so: Special*), for all members.

It means that the dates do not matter anymore, I just need the raw list of all special activities per person, all regrouped below their name.

Example is in the below file.

Is there a way to get this without affecting my source data?

Many thanks!

I manage a planning where people report different activity types, let's say "Work" or "Special activity" (with different types, like 1 2 or 3).

While keeping my main planning where everything is reported, I am looking for a way to filter out on all special activities (so: Special*), for all members.

It means that the dates do not matter anymore, I just need the raw list of all special activities per person, all regrouped below their name.

Example is in the below file.

Is there a way to get this without affecting my source data?

Many thanks!

How can I extract rows matching some criteria to different sheet?

Pivot table requires summarizing data by I just want the raw data from the main sheet.

Filter only works in the current sheet and requires user to specify filter criteria.

vlookup requires a formula for each row but how do I know how many rows will be selected

For example:

The main "Data" sheet contains:

salesperson product qty saledate

Bob ddr3 10 12-mar-17

Bill ddr4 2 1-apr-16

Jane ddr 11 14-may-16

Bob rambus 44 23-jun-16

I would like to create a sheet for each salesperson (can be static)

"Bob" sheet:

ddr3 10 12-mar-17

rambus 44 23-jun-16

"Bill" sheet:

ddr4 2 1-apr-16

So, all the salesperson has to do is click on the tab corresponding to his sheet to view his sales.

]]>Pivot table requires summarizing data by I just want the raw data from the main sheet.

Filter only works in the current sheet and requires user to specify filter criteria.

vlookup requires a formula for each row but how do I know how many rows will be selected

For example:

The main "Data" sheet contains:

salesperson product qty saledate

Bob ddr3 10 12-mar-17

Bill ddr4 2 1-apr-16

Jane ddr 11 14-may-16

Bob rambus 44 23-jun-16

I would like to create a sheet for each salesperson (can be static)

"Bob" sheet:

ddr3 10 12-mar-17

rambus 44 23-jun-16

"Bill" sheet:

ddr4 2 1-apr-16

So, all the salesperson has to do is click on the tab corresponding to his sheet to view his sales.

So I am creating a form to calculate pay for a certain classification and I want a certain cell to be equal to or greater than a value, whereas the value is determined by another cell. For instance, if you select one of the classifications and that classification has a minimum pay of 1500, the value should be greater than or equal to the minimum.

Here is an example: In cell C4, I click on the list and select Class 1. Now Class 1 has a minimum pay of 1000 and I am required to put a start pay amount in cell D4. I input the value 950 and get an error. Therefore I change it to 1050 to meet the cell requirements.

Thanks in advance.

]]>Here is an example: In cell C4, I click on the list and select Class 1. Now Class 1 has a minimum pay of 1000 and I am required to put a start pay amount in cell D4. I input the value 950 and get an error. Therefore I change it to 1050 to meet the cell requirements.

Thanks in advance.

HI gurus

I need a formula which will allow me to get the number between the x and the space. example below and spreadsheet attached

For example in column A i have

Milo Drink 3x200ml

Kombucha Wonder Traditional 10x414ml

IN column b i need

3

10

Many thanks

I need a formula which will allow me to get the number between the x and the space. example below and spreadsheet attached

For example in column A i have

Milo Drink 3x200ml

Kombucha Wonder Traditional 10x414ml

IN column b i need

3

10

Many thanks

Hi Friends

I am having issue with formatting as date. The report came from system doesn't have proper date format. I have attached the example data.

Can you please help with the formula to fix this one?

Thanks a lot

Arpan

I am having issue with formatting as date. The report came from system doesn't have proper date format. I have attached the example data.

Can you please help with the formula to fix this one?

Thanks a lot

Arpan

Hi

I'm trying to use the countifs function where it's referencing data on another worksheet but within the same workbook.

The worksheet which has my Countifs formula is "Analysis"

The worksheet which has the data I'm referencing is "Leave"

There are 2 sets of criteria I've used in the formula.

=COUNTIFS(Leave!$C:$H,Analysis!$B2,Leave!$B:$B,Analysis!C$1)

I however get a #VALUE! error. Having google'd this error, it advises that it results from the data referenced being from a closed workbook, however I'm referencing from the same (open) workbook but from a different worksheet.

Any help would be appreciated.

Thanks

]]>I'm trying to use the countifs function where it's referencing data on another worksheet but within the same workbook.

The worksheet which has my Countifs formula is "Analysis"

The worksheet which has the data I'm referencing is "Leave"

There are 2 sets of criteria I've used in the formula.

=COUNTIFS(Leave!$C:$H,Analysis!$B2,Leave!$B:$B,Analysis!C$1)

I however get a #VALUE! error. Having google'd this error, it advises that it results from the data referenced being from a closed workbook, however I'm referencing from the same (open) workbook but from a different worksheet.

Any help would be appreciated.

Thanks

Hi, im trying to find the formula that would allow me to calculate an average which includes only a partial set of data based on a conditional value of a different set of data.

72559650acbc3b4afbb06c0ba85f840fafc91500667a3541939b2cfbc0c1b1d9922ce96b.jpg

so, here i would like to compute the average value of Column D but while only including a particular value if it is associated with a positive (and greater than zero) value with Column E.

so, for instance in this example, i would like a formula to compute the average of those 5 values: 1 // 0.5 // 0 // 1.11 and 2.61

Please help :(

]]>72559650acbc3b4afbb06c0ba85f840fafc91500667a3541939b2cfbc0c1b1d9922ce96b.jpg

so, here i would like to compute the average value of Column D but while only including a particular value if it is associated with a positive (and greater than zero) value with Column E.

so, for instance in this example, i would like a formula to compute the average of those 5 values: 1 // 0.5 // 0 // 1.11 and 2.61

Please help :(

Hi All,

I'm having a round down issue and I keep getting errors.

The following are just examples, the L17 is the cell with a value which needs to be rounded down.

If L17 = 5.94 Then M17 needs to round down to 5.93

If L17 = 5.91 Then M17 needs to round down to 5.87

If L17 = 5.67 Then M17 needs to remain the same as it ends in a 7

If L17 = 5.63 Then M17 needs to remain the same as it ends in a 3

Any help would be greatly appreciated.

Cheers

]]>I'm having a round down issue and I keep getting errors.

The following are just examples, the L17 is the cell with a value which needs to be rounded down.

If L17 = 5.94 Then M17 needs to round down to 5.93

If L17 = 5.91 Then M17 needs to round down to 5.87

If L17 = 5.67 Then M17 needs to remain the same as it ends in a 7

If L17 = 5.63 Then M17 needs to remain the same as it ends in a 3

Any help would be greatly appreciated.

Cheers

Hi again,

Since getting the help yesterday to complete my biggest challenge to date with my excel, I figured I'd be able to understand conditional formatting. I've done some simple conditional formatting in the past but what I'm hoping to achieve here hurts my brain to think about.

Attached is my file from yesterday with the formulae you guys helped me with, now what I'm looking to do is set up a colour scheme to match our projected start and end dates. I've seen a few examples on this forum but they went through a single reference point and I'm hoping to use the start and end dates to colour sections of a 6 month schedule based on dates entered in only one row then projected down.

Reading that back is slightly confusing to me, so any help is appreciated and happy to clarify anything I can. I've written on the spreadsheet in boxes to try to clarify.

Since getting the help yesterday to complete my biggest challenge to date with my excel, I figured I'd be able to understand conditional formatting. I've done some simple conditional formatting in the past but what I'm hoping to achieve here hurts my brain to think about.

Attached is my file from yesterday with the formulae you guys helped me with, now what I'm looking to do is set up a colour scheme to match our projected start and end dates. I've seen a few examples on this forum but they went through a single reference point and I'm hoping to use the start and end dates to colour sections of a 6 month schedule based on dates entered in only one row then projected down.

Reading that back is slightly confusing to me, so any help is appreciated and happy to clarify anything I can. I've written on the spreadsheet in boxes to try to clarify.

Hi, looking for a formula for the following:

A1 = formula

B1 = Data

C1 = Yes / No

So if C1=Yes, return the data from cell B1, into cell A1

Thx

]]>A1 = formula

B1 = Data

C1 = Yes / No

So if C1=Yes, return the data from cell B1, into cell A1

Thx

Hello All,

I have two columns, Names and Titles, and I would like to consolidate all the titles of the same name into one cell.

For example the data is in Column A and B.

Column A Column B

Adam M. Dog Catcher

Adam M. Chef

Bobby B. Dog Catcher

David C. Chef

David C. Excel Expert

Results that I would want is...

In column C, formula removing all duplicates in Column A to create a single list. Column D is the consolidation of match between A and C with the results of all the titles (B).

Column C Column D

Adam M. Dog Catcher, Chef

Bobby B. Dog Catcher

David C. Chef, Excel Expert

Thanks in advance!

]]>I have two columns, Names and Titles, and I would like to consolidate all the titles of the same name into one cell.

For example the data is in Column A and B.

Column A Column B

Adam M. Dog Catcher

Adam M. Chef

Bobby B. Dog Catcher

David C. Chef

David C. Excel Expert

Results that I would want is...

In column C, formula removing all duplicates in Column A to create a single list. Column D is the consolidation of match between A and C with the results of all the titles (B).

Column C Column D

Adam M. Dog Catcher, Chef

Bobby B. Dog Catcher

David C. Chef, Excel Expert

Thanks in advance!

Im trying to create circle shapes that will change colors based on a cell value (words not numbers in cells) I found a tutorial online but for the life of me it does not seem to work. Any ideas how to get this to work.

]]>