Hi,

I have a log template that I created & using to track business travel mileage

As you will see through the template, I'm trying to sort through:

Column(s):

D - Dates

E - "A,B,C,D" - Original attempt to keep same order throughout template

These are 2 columns only needed to sort.

Issues I'm having is if my entries has the same date & then wen I sort, the "A,B,C,D" gets re-ordered instead of staying as is or will sort alphabetically.

How can I avoid this or sort groups of rows?

See attached example

Thanks

I have a log template that I created & using to track business travel mileage

As you will see through the template, I'm trying to sort through:

Column(s):

D - Dates

E - "A,B,C,D" - Original attempt to keep same order throughout template

These are 2 columns only needed to sort.

Issues I'm having is if my entries has the same date & then wen I sort, the "A,B,C,D" gets re-ordered instead of staying as is or will sort alphabetically.

How can I avoid this or sort groups of rows?

See attached example

Thanks

Hello,

I have a column in(A )that i don't want to change and another column in (B) and Column (C)

I want to match and order column(B) according to column (A)

while changing the values of (C) to the changing in (B)

for example:

Column A

TCGA-A2-A3XY

TCGA-XX-A89A

TCGA-B6-A0I2

will change to be

and so on

how can I do that?

]]>I have a column in(A )that i don't want to change and another column in (B) and Column (C)

I want to match and order column(B) according to column (A)

while changing the values of (C) to the changing in (B)

for example:

Column A

TCGA-A2-A3XY

TCGA-XX-A89A

TCGA-B6-A0I2

Code:

`column B column C`

TCGA-5L-AAT0 WHITE

TCGA-5L-AAT1 WHITE

TCGA-A2-A3XY NA

TCGA-A2-A04V WHITE

TCGA-A2-A04Y WHITE

Code:

`column B column C`

TCGA-A2-A3XY NA

how can I do that?

I want to save time and change my formulas that reference "C" to "E", I cannot just change one cell and then drag down to repeat the formulas since they are not in order and they also have text that needs to be different for each cell. Is there a way to simply make this change to the formula for the document without having to click on each cells formula individually and modifying it?

If this image is attached it will make a lot more sense.

Thank You!

Screen Shot 2017-02-25 at 11.01.35 PM.png

]]>If this image is attached it will make a lot more sense.

Thank You!

Screen Shot 2017-02-25 at 11.01.35 PM.png

hello,

I'm using Mac and I have downloaded microsoft office for mac

I have values as follows

TCGA.A2.A3XY

TCGA.XX.A89A

TCGA.B6.A0I2

TCGA.LL.A6FP

TCGA.EW.A423

I want to replace the . (dot) between the values to a - (dash)

for example the first value

TCGA-A2-A3XY

any help please

]]>I'm using Mac and I have downloaded microsoft office for mac

I have values as follows

TCGA.A2.A3XY

TCGA.XX.A89A

TCGA.B6.A0I2

TCGA.LL.A6FP

TCGA.EW.A423

I want to replace the . (dot) between the values to a - (dash)

for example the first value

TCGA-A2-A3XY

any help please

Hello, I am trying to press a button which will call a macro with arguments. I can do it for one argument only, but I need to pass 4, maybe more. I can cheat and put everything in one string, maybe, but there must be a better way.

So far I can do this on the Assign Macro of the button:

But I cannot do this:

The second argument breaks it.

Does anyone know how to go about this?

Thanks

]]>So far I can do this on the Assign Macro of the button:

Code:

`'Shares-Watchlist.xlsm'!'CreateSL("RDSB.L")'`

Code:

`'Shares-Watchlist.xlsm'!'CreateSL("RDSB.L","hello")'`

Does anyone know how to go about this?

Thanks

I need to calculate a project's end date and time based on duration (measured in labor hours). The constraints are a 40 hour work week (no evenings, weekends, or over time) and it cannot include holidays. The attached spreadsheet includes a second tab that lists the company holidays that cannot be counted. However, I'm okay with using Outlook/Excel's standard holiday list instead for simplification.

Any guidance on how to calculate this end date will greatly be appreciated!

Any guidance on how to calculate this end date will greatly be appreciated!

Hi all

im currently trying to create a spreadsheet for fuel control stock for 3 different outlets on the same site using the meter readings collected each morning each outlet has its own workbook and a fourth workbook is an overview of the previous 3 for the accounts team showing year on year and graphs and data so far so good.

but i have been asked to produce a stock tab where it will automatically display the current dates stock is there a formula for this

i have attached 1 of the work sheets (JETA1) and the overview sheet where there is a stock level tab i need the figure from the remaining colum on the stock sheet to appear when the admin team open up the stock level tab in overview

kind Regards

Steddas

im currently trying to create a spreadsheet for fuel control stock for 3 different outlets on the same site using the meter readings collected each morning each outlet has its own workbook and a fourth workbook is an overview of the previous 3 for the accounts team showing year on year and graphs and data so far so good.

but i have been asked to produce a stock tab where it will automatically display the current dates stock is there a formula for this

i have attached 1 of the work sheets (JETA1) and the overview sheet where there is a stock level tab i need the figure from the remaining colum on the stock sheet to appear when the admin team open up the stock level tab in overview

kind Regards

Steddas

Hi all thanks for accepting me to this forum your help would be much appreciated

im currently trying to create a spreadsheet for fuel control stock for 3 different outlets on the same site using the meter readings collected each morning each outlet has its own workbook and a fourth workbook is an overview of the previous 3 for the accounts team showing year on year and graphs and data so far so good.

but i have been asked to produce a stock tab where it will automatically display the current dates stock is there a formula for this

kind Regards

Steddas

im currently trying to create a spreadsheet for fuel control stock for 3 different outlets on the same site using the meter readings collected each morning each outlet has its own workbook and a fourth workbook is an overview of the previous 3 for the accounts team showing year on year and graphs and data so far so good.

but i have been asked to produce a stock tab where it will automatically display the current dates stock is there a formula for this

kind Regards

Steddas

What are the shortcut keystrokes to get to the bottom of a column, the end of a row, and the end of a spreadsheet? where the data ends.

Also, please add any commonly used navigation keystrokes. Thank you.

]]>Also, please add any commonly used navigation keystrokes. Thank you.

We have a large spreadsheet at work which has a lot of tabs of data. I wanted to create a "dashboard" to put some, not all, of the information at easy reach.

So you would pick a name and certain cells would contain specific information.

But I want it to look nice, not just a plain excel looking list.

Something like this (minus graphs):

dashboard_gray_grey.png

How easy is it to do something like that? And does it need VBA? I really rather not use VBA if I can help it, as it would change the extension which will cause my boss some headache (the file is on sharepoint with many versions).

All help is really appreciated.

]]>So you would pick a name and certain cells would contain specific information.

But I want it to look nice, not just a plain excel looking list.

Something like this (minus graphs):

dashboard_gray_grey.png

How easy is it to do something like that? And does it need VBA? I really rather not use VBA if I can help it, as it would change the extension which will cause my boss some headache (the file is on sharepoint with many versions).

All help is really appreciated.

Hey,

When I add a item like 'red', I want that excel counts it automatically in the cell next to it.

Is that possible and which formula I can use for it?

And do you have a source, so I can help myself further with this kind of formulas?

I added a wetransfer link, because I cannot upload any attachments.

Kind regards,

Floris

Screen Shot 2017-02-24 at 20.30.16.png

https://we.tl/icjxK2p92D

=SUMIF(C5:C11;"*"&F7&"*";D5:D11)

]]>When I add a item like 'red', I want that excel counts it automatically in the cell next to it.

Is that possible and which formula I can use for it?

And do you have a source, so I can help myself further with this kind of formulas?

I added a wetransfer link, because I cannot upload any attachments.

Kind regards,

Floris

Screen Shot 2017-02-24 at 20.30.16.png

https://we.tl/icjxK2p92D

=SUMIF(C5:C11;"*"&F7&"*";D5:D11)

I need help with the COUNTIFS function. Right now I have =COUNTIFS(D3:D59987,"<30",D3:D59987,">17"), but it's returning a "0", even though I know there are numbers within that range. I also want the resulting number returned as a percentage of the total number of rows, but exclude any row that is "0". For example the data is like:

First name, Last name, age

John, Doe, 16

John, Doe, 43

John, Doe, 30

John, Doe, 0

John, Doe, 44

John, Doe, 56

John, Doe, 57

John, Doe, 71

I don't have to capture/count anything related to the names, just the age. I want my results to show how many are within the below ranges:

Pax 1-17 = x%

Pax 18-29 = x%

Pax ...

Pax 70+ = x%

Total # of rows = 59986

If I need to, I can return just a regular number rather than a percentage and just create another results row to get the percentage. BTW, in my sheet, Column D is the age column.

]]>First name, Last name, age

John, Doe, 16

John, Doe, 43

John, Doe, 30

John, Doe, 0

John, Doe, 44

John, Doe, 56

John, Doe, 57

John, Doe, 71

I don't have to capture/count anything related to the names, just the age. I want my results to show how many are within the below ranges:

Pax 1-17 = x%

Pax 18-29 = x%

Pax ...

Pax 70+ = x%

Total # of rows = 59986

If I need to, I can return just a regular number rather than a percentage and just create another results row to get the percentage. BTW, in my sheet, Column D is the age column.

Quick question for a simulation build.

I am trying to replicate a game such as darts (disregard the points) or football where you have to make the same throw and hit a target. I get 80% of the way there in building the model, but cannot figure out how to replicate a change in a turn.

So for example:

I shoot first, my opponent needs to make the same shot or else I am awarded a point. If, however, I miss when shooting first the prerogative to shoot first moves to my opponent. I then have to replicate his shots until he misses a shot. At the same time I need to make all of his shots or else he is awarded a point. Is there a simple way to replicate this process that simulates the changing of who shoots first given the misses made? I have been trying to figure out IF functions using AND/OR functions to determine when a point is awarded.

]]>I am trying to replicate a game such as darts (disregard the points) or football where you have to make the same throw and hit a target. I get 80% of the way there in building the model, but cannot figure out how to replicate a change in a turn.

So for example:

I shoot first, my opponent needs to make the same shot or else I am awarded a point. If, however, I miss when shooting first the prerogative to shoot first moves to my opponent. I then have to replicate his shots until he misses a shot. At the same time I need to make all of his shots or else he is awarded a point. Is there a simple way to replicate this process that simulates the changing of who shoots first given the misses made? I have been trying to figure out IF functions using AND/OR functions to determine when a point is awarded.

I am hoping a spreadsheet like what I am looking for has already been created and I am just not finding it. I am looking to track education workshop criteria based on a condition. For example, I need the person to be completed from the training program with in one year of start date and have lead a workshop at least once a year after completion of the class to remain active. Then there is a second level that says they must have completed the training, and held 2 workshops in the first year then one workshop every other year to remain active.

Can anyone direct me to a spreadsheet like that that was already created so I can look at the formulas?

Currently I have the formula written as if today is less than the anniversary date, then Active, if not then #workshops completed must be greater than 1, if not then inactive. The problem with this is it doesn't account for year 3 ect.... (looks at a second sheet that tracks when all workshops are held and counts how many workshops each leader taught).

for the second level, I have if today is less than anniversary date then active, if not # of workshops completed must be greater than 2, but again it doesnt take into account year 3.

THanks!

]]>Can anyone direct me to a spreadsheet like that that was already created so I can look at the formulas?

Currently I have the formula written as if today is less than the anniversary date, then Active, if not then #workshops completed must be greater than 1, if not then inactive. The problem with this is it doesn't account for year 3 ect.... (looks at a second sheet that tracks when all workshops are held and counts how many workshops each leader taught).

for the second level, I have if today is less than anniversary date then active, if not # of workshops completed must be greater than 2, but again it doesnt take into account year 3.

THanks!

hello . I just stumbled upon an interesting problem in excel .

I hope you can understand

so . .

I want to calculate the sum of different numbers that are entered one by one is a cell , and the sum of all of those to be displayed in a different one .

so , for example :

in cell A1 I put the number 2 .

in cell C1 the sum will be ... 2 of course .

now .. in cell A1 I replace 2 with another number , lets say 5

in cell C1 the sum will be changed to 7 .

I hope this is clear

Can someone help me or tell at least tell me is this is possible ?

Thanks !

]]>I hope you can understand

so . .

I want to calculate the sum of different numbers that are entered one by one is a cell , and the sum of all of those to be displayed in a different one .

so , for example :

in cell A1 I put the number 2 .

in cell C1 the sum will be ... 2 of course .

now .. in cell A1 I replace 2 with another number , lets say 5

in cell C1 the sum will be changed to 7 .

I hope this is clear

Can someone help me or tell at least tell me is this is possible ?

Thanks !