Hi friends,

Please help me out in generating a formula to derive a number sequence.

For the set of data attached here, for every identifier I need a number pattern to be generated as the output, based on the columns C,D,E,F,G,H,I and J, also the sequencing should start from the beginning for every assessment.

In the example here, for Assessment1 even though row3 and row4 identifiers are the same but the individual constituents are different (for row3-P4="Y", whereas for row4-P4="G"), similarly for Assessment2 row9 and row11 have same identifiers and also the same constituents and hence the same sequence for both.

Kindly help me on this.

Thanks & regards

Snehith

Please help me out in generating a formula to derive a number sequence.

For the set of data attached here, for every identifier I need a number pattern to be generated as the output, based on the columns C,D,E,F,G,H,I and J, also the sequencing should start from the beginning for every assessment.

In the example here, for Assessment1 even though row3 and row4 identifiers are the same but the individual constituents are different (for row3-P4="Y", whereas for row4-P4="G"), similarly for Assessment2 row9 and row11 have same identifiers and also the same constituents and hence the same sequence for both.

Kindly help me on this.

Thanks & regards

Snehith

Hi to All,

I am not sure whether a formula is possible to calculate based on the selected criterias on my attached file because there are really lots of parameters affecting the sum of calculation. I tried to build the example file as much identical to my original and with required details as well. Hope someone may achieve to invent a proper formula to solve my crucial problem will be appreciated a lot. However I have no chance to deploy the file on xlsm format must be xlsx.

Thanks in advance for your support and advices.

I am not sure whether a formula is possible to calculate based on the selected criterias on my attached file because there are really lots of parameters affecting the sum of calculation. I tried to build the example file as much identical to my original and with required details as well. Hope someone may achieve to invent a proper formula to solve my crucial problem will be appreciated a lot. However I have no chance to deploy the file on xlsm format must be xlsx.

Thanks in advance for your support and advices.

Hey all!

I'm having some trouble figuring this specific formula out since I've changed how my spreadsheet operates. What I'm trying to do is calculate MPG based on the previous line of data:

(new mileage - previous mileage) / gallons filled

(B3 - B2) / C3

The catch is there isn't always data in the previous line (did not fill up with fuel) so I need to pull the mileage from the row above that. I would input a "-" symbol to indicate no fueling and my formula worked to check for that symbol. It worked but only if there is a maximum of 1 "blank" row above the newest row of data (see first block of data). I want to expand this so that a maximum of 4 "blank" rows can be between the newest row of data and the oldest (see second block of data) or all rows of data are filled (see third block of data). The formula I initially tried used a lot of nested IF functions but it did not work how I intended and manipulating the current formula I'm using to check for the "-" symbol also did not work.

I would like for the formula to continue infinitely (or at least for a few thousand rows) and I'm open to leaving the cells blank instead of using "-" if that will help with any formula solution. Thanks for any help!

I'm having some trouble figuring this specific formula out since I've changed how my spreadsheet operates. What I'm trying to do is calculate MPG based on the previous line of data:

(new mileage - previous mileage) / gallons filled

(B3 - B2) / C3

The catch is there isn't always data in the previous line (did not fill up with fuel) so I need to pull the mileage from the row above that. I would input a "-" symbol to indicate no fueling and my formula worked to check for that symbol. It worked but only if there is a maximum of 1 "blank" row above the newest row of data (see first block of data). I want to expand this so that a maximum of 4 "blank" rows can be between the newest row of data and the oldest (see second block of data) or all rows of data are filled (see third block of data). The formula I initially tried used a lot of nested IF functions but it did not work how I intended and manipulating the current formula I'm using to check for the "-" symbol also did not work.

I would like for the formula to continue infinitely (or at least for a few thousand rows) and I'm open to leaving the cells blank instead of using "-" if that will help with any formula solution. Thanks for any help!

Hello,

I've got a sum formula to calculate a simple calculation in 1 cell (F3)

Then i have in cells F7 - F14 different values and i want to calculate the total of these values from another value in another cell, so as described above i want the following and im typing...

=SUM(F3-F7:F14)

But all im getting is #VALUE!

What am i doing wrong?

]]>I've got a sum formula to calculate a simple calculation in 1 cell (F3)

Then i have in cells F7 - F14 different values and i want to calculate the total of these values from another value in another cell, so as described above i want the following and im typing...

=SUM(F3-F7:F14)

But all im getting is #VALUE!

What am i doing wrong?

Hi everyone, moderate excel user, but not expert by any means. Looking for help. I have a list of data that I want repeated based on it having the same "Code".

I have long list of items in column B, but this is just a snippet. My goal is to have a formula in column G that repeats the items in column b based on having the same "Code".

I was able to use a help column to create column F.

How can I create a formula to get results in column G? (What's shown below is entered manually.)

Thanks!!

3me4gjti5aq41.png

]]>I have long list of items in column B, but this is just a snippet. My goal is to have a formula in column G that repeats the items in column b based on having the same "Code".

I was able to use a help column to create column F.

How can I create a formula to get results in column G? (What's shown below is entered manually.)

Thanks!!

3me4gjti5aq41.png

Have formula (sheet 1, column 5)

=IF(ISBLANK(Sheet2!M18),"",Sheet2!M18)

I need it to read that if 'sheet2!m18' has a figure, to read that. If it is blank to read blank (whole row is blank). But also, that if the 'sheet2!m18' is blank, but there is a figure in L18(sheet 2) or column 3(sheet 1), to read 'sheet2!L18*1000' or 'C2*1000'

What ever i do at the moment, isn't working

Thankyou

=IF(ISBLANK(Sheet2!M18),"",Sheet2!M18)

I need it to read that if 'sheet2!m18' has a figure, to read that. If it is blank to read blank (whole row is blank). But also, that if the 'sheet2!m18' is blank, but there is a figure in L18(sheet 2) or column 3(sheet 1), to read 'sheet2!L18*1000' or 'C2*1000'

What ever i do at the moment, isn't working

Thankyou

Hi,

Excluding the very last cell with a value how do I find the last three cells in a range to find out how any cells has a positive value.

The formula first finds the last cell K5, it then inspects the previous three cell and then determine how many have a positive value. In this case H5 is negative and both I and J have positive values. The formula should then return 2 because only two cells have a positive value.

The formula will need to be dynamic to allow for new data being added in the future.

Hopefully I have explained this properly. The sample spreadsheet might help.

Excluding the very last cell with a value how do I find the last three cells in a range to find out how any cells has a positive value.

The formula first finds the last cell K5, it then inspects the previous three cell and then determine how many have a positive value. In this case H5 is negative and both I and J have positive values. The formula should then return 2 because only two cells have a positive value.

The formula will need to be dynamic to allow for new data being added in the future.

Hopefully I have explained this properly. The sample spreadsheet might help.

Hi guys,

I am having some trouble with a tool I am making for work.

On sheet 2, I have a roster of employees that report to certain managers. There is a numeric ID value, a text login value and a text manager name value. This data updates automatically depending on the manager names inputted on the main sheet.

On sheet 3, I have data regarding associate performance. There are several columns but the only values I am interested in are ID and total hours. Employees can appear multiple times in the same list.

On the main sheet, I would like a list of distinct associate logins and the total time they have spent performing task. I only want employees that appear in the roster to be included.

Is there a way I can do this?

I have included an example workbook to illustrate what I need. I have inputted the data on the main sheet manually to show what i would like.

I am having some trouble with a tool I am making for work.

On sheet 2, I have a roster of employees that report to certain managers. There is a numeric ID value, a text login value and a text manager name value. This data updates automatically depending on the manager names inputted on the main sheet.

On sheet 3, I have data regarding associate performance. There are several columns but the only values I am interested in are ID and total hours. Employees can appear multiple times in the same list.

On the main sheet, I would like a list of distinct associate logins and the total time they have spent performing task. I only want employees that appear in the roster to be included.

Is there a way I can do this?

I have included an example workbook to illustrate what I need. I have inputted the data on the main sheet manually to show what i would like.

Well, I'm not that great at explaining my problem in the title.

A little bit of context:

I have a full list of all my transactions.

Every transaction has been put in category.

Now i'm trying to sum the total amount of money (used in the transactions) per category in a certain month and year.

There is a attachment explaining the whole problem.

Hope someone can help me out :)

Thanks in advance.

A little bit of context:

I have a full list of all my transactions.

Every transaction has been put in category.

Now i'm trying to sum the total amount of money (used in the transactions) per category in a certain month and year.

There is a attachment explaining the whole problem.

Hope someone can help me out :)

Thanks in advance.

hi

i have data by date , by category and by location.

i am hoping for help with being able to just return the daily data in the front tab based on a date drop down (see data tab), by category type and location and also at a total level.

and then to sum up to a YTD position ( see data is split into M T W T F based on the date) but if i wanted the daily data as at 26/3/20 and also the YTD data (23/3/20 to 26/3/20)

hoping someone may be able to please assist with this!

i have data by date , by category and by location.

i am hoping for help with being able to just return the daily data in the front tab based on a date drop down (see data tab), by category type and location and also at a total level.

and then to sum up to a YTD position ( see data is split into M T W T F based on the date) but if i wanted the daily data as at 26/3/20 and also the YTD data (23/3/20 to 26/3/20)

hoping someone may be able to please assist with this!

Good afternoon,

I am trying to pull the last heading (in this case calendar months) if there is data in that column. In other words, for each person, what month has data in it? I have attached an example with completed results for clarity.

Thanks in advance!

(I am using Microsoft 10. Not sure how to edit my profile on my phone.)

I am trying to pull the last heading (in this case calendar months) if there is data in that column. In other words, for each person, what month has data in it? I have attached an example with completed results for clarity.

Thanks in advance!

(I am using Microsoft 10. Not sure how to edit my profile on my phone.)

I need a formula to knock off a single amount against multiple amounts so that they net to zero. The amounts are usually netted off against multiple similar amounts for eg. 55,000 against 5 amounts of 11,000 . However they might also be cases where dissimilar amounts might net to zero. Please provide a formula to identify and highlight these amounts. Sample excel sheet attached.

I am wondering if there is an existing formula or a VBA function for this. It needs to convert adjecent numbers with a "-" and non adjecent numbers with a ","

A few examples:

1 2 3 4 6 --> 1-4, 6

1 5 6 8 --> 1, 5-6, 8

1 2 3 4 5 6 7 --> 1-7

1 3 5 7 9 --> 1, 3, 5, 7, 9

It doesn`t matter if it is with a formula, function or VBA.

]]>A few examples:

1 2 3 4 6 --> 1-4, 6

1 5 6 8 --> 1, 5-6, 8

1 2 3 4 5 6 7 --> 1-7

1 3 5 7 9 --> 1, 3, 5, 7, 9

It doesn`t matter if it is with a formula, function or VBA.

Hi Guys,

I am in the process of creating a spreadsheet for a race night. The workbook with have a different sheet for each race (see image) I am trying to find a formula for the**WINNER** and **Win Value** columns.

**Winner Column**

Return a value of "YES" is the player has placed a bet on the horse that has won the race. The Winning horse is selected from the**1st Place Winner** dropdown. e.g Player **Name 1** placed 1 bet on Horse 7 which is the winning horse. The **WINNER** column should be populated with a value of "YES"

**Win Value**

If the player has won, e.g**WINNER** is "YES" calculate how much the player has one. The Payouts for each horse are listed below the main table. So if **Player 1** placed 3 bets on Horse 7 there payout would be 3 times the **payout per bet**

I have attached the workbook and appreciate any help i can get on this :)

I am in the process of creating a spreadsheet for a race night. The workbook with have a different sheet for each race (see image) I am trying to find a formula for the

Return a value of "YES" is the player has placed a bet on the horse that has won the race. The Winning horse is selected from the

If the player has won, e.g

I have attached the workbook and appreciate any help i can get on this :)

I am very new to Excel so any help would be very much appreciated. I am trying to combine two formulas without much luck.

Formula 1 - This formula counts the number of workplace incidents on a given sheet from a given business site:

=COUNTIF('Live Workplace Incidents'!C:C,"site1")

Formula 2 - This formula counts the number of workplace incidents that are recorded between a given date range. This formula functions strangely and reports back with the number of cases in a given date range but also adds the total number of cases on the sheet, hence the “-b15” to report just the cases in the date range:

=COUNTIF('Live Workplace Incidents'!E:E,">=01/03/20")+ COUNTIF('Live Workplace Incidents'!E:E,"<=31/03/20")-B15

I am trying to combine them into a formula that will give me the number of workplace incidents that are recorded between a given date range but also in a given business site (i.e. site1).

Again I would be really grateful for any assistance in combining these two formulas.

]]>Formula 1 - This formula counts the number of workplace incidents on a given sheet from a given business site:

=COUNTIF('Live Workplace Incidents'!C:C,"site1")

Formula 2 - This formula counts the number of workplace incidents that are recorded between a given date range. This formula functions strangely and reports back with the number of cases in a given date range but also adds the total number of cases on the sheet, hence the “-b15” to report just the cases in the date range:

=COUNTIF('Live Workplace Incidents'!E:E,">=01/03/20")+ COUNTIF('Live Workplace Incidents'!E:E,"<=31/03/20")-B15

I am trying to combine them into a formula that will give me the number of workplace incidents that are recorded between a given date range but also in a given business site (i.e. site1).

Again I would be really grateful for any assistance in combining these two formulas.