Hi, I am working with MS 365 Excel. I noticed sometimes when I open several Excel Sheets one of them would disappear. When I try to close all the Excel, I have to double click the close button and the Excel would ask me whether I want to save both the disappeared sheet and the active sheet or not. Any idea what's wrong with this? Thank you!

]]>Hi guys,

Working on a user conversion topic at the moment and trying to come up with a formula to determine if a user didn't use our product in the past and is using it now can be classed as a CONVERSION and if he has used it in the past and doesn't anymore to be classed as a LOSS - attached is a spreadsheet for example ,where my product is ABC.

Couldn't think of a single formula rather than using lots of additional columns to help me achieve this.

Any ideas?

Appreciate any help.

Ionut

User conversion_loss example.xlsx

]]>Working on a user conversion topic at the moment and trying to come up with a formula to determine if a user didn't use our product in the past and is using it now can be classed as a CONVERSION and if he has used it in the past and doesn't anymore to be classed as a LOSS - attached is a spreadsheet for example ,where my product is ABC.

Couldn't think of a single formula rather than using lots of additional columns to help me achieve this.

Any ideas?

Appreciate any help.

Ionut

User conversion_loss example.xlsx

I need help in carrying data over.

if the total of a sum is 124 units, how do I get it to calculate the amount owed if every 25th units starts with a new price.

example is that the first 25 units cost 10. the second 25 units cost 12, the 3rd 25 units is 14 and so on.

i added an excel sheet that might explane more.

hope you can help.

if the total of a sum is 124 units, how do I get it to calculate the amount owed if every 25th units starts with a new price.

example is that the first 25 units cost 10. the second 25 units cost 12, the 3rd 25 units is 14 and so on.

i added an excel sheet that might explane more.

hope you can help.

I have this formula that will post False and I want to be either blank or 0. my formula reads IF(AND($C13="N"),IF(W13<=$W$6,-$S$9,0)), however in cell C13 is Y. Is there another way to build the formula to read for a value of N or Y in cell C13?

]]>I wish to alter the default settings for numbers formatting, in particular to ensure that (without having to change numbers already entered retrospectively) negative numbers will appear without further intervention in red and with no brackets.

]]>I have a learning record tool that we use for people to record their learning and show details of their qualifications and personal details.

Currently the tool is set up in Excel. People fill in the required cells, then from a 'button press' a Word Template opens and via 'Mail Merge' the relevant sections are completed, and this then creates a 6 page document detailing this information.

I'm wondering if there is a better or simpler way to do this using the O365 tools available.

Any help or suggestions appreciated.

]]>Currently the tool is set up in Excel. People fill in the required cells, then from a 'button press' a Word Template opens and via 'Mail Merge' the relevant sections are completed, and this then creates a 6 page document detailing this information.

I'm wondering if there is a better or simpler way to do this using the O365 tools available.

Any help or suggestions appreciated.

I found a small excel sheet online that calculates the daily interest rate and added cells to show the daily interest * 30 days, a late fee and the new total due. Once I got it working, I copied it so I now have 12 of them. Next, I copied the formula in the New Total Due cell and pasted it in the Balance due cell of the next Unit/s, so on and so forth until all were programed. Now, I have 12 micro monthly calculators showing 12 months worth of delinquent charges. All I need to do is enter the beginning balance in the first month for each member which is past due. Wham, bam, thank you very much Excel. (See Attached).

Now for the member info and to link it with the correct values in the monthly calculators. I suppose I could use a separate sheet for each delinquent member since at this point there are on 25 or so. However, in the long run, that's not so practical. A better way might be to have 2 sheets, Monthly Calculators and Delinquent Members and kink them together. After watching several videos on linking sheets, it's will take a fair amount of time to come up with the best way to accomplish this task.

Ideally, I would be handy to show a form for entering member info and below that, the mini calculators. then as each member was loaded into the form along with the calculators, I could print it as an invoice. I see there are basic data entry forms (based on inserting a table) and some pretty cool looking forms (I don't know how to create those). For printing as an invoice, a basic data entry form is not the best choice because of the buttons.

If this were a database, it would be a 2 table relational setup. Im essence, I am looking to use Excel as a relational spreadsheet. What/How is the best way to get this done?

Thank you for any and all suggestions.

Now for the member info and to link it with the correct values in the monthly calculators. I suppose I could use a separate sheet for each delinquent member since at this point there are on 25 or so. However, in the long run, that's not so practical. A better way might be to have 2 sheets, Monthly Calculators and Delinquent Members and kink them together. After watching several videos on linking sheets, it's will take a fair amount of time to come up with the best way to accomplish this task.

Ideally, I would be handy to show a form for entering member info and below that, the mini calculators. then as each member was loaded into the form along with the calculators, I could print it as an invoice. I see there are basic data entry forms (based on inserting a table) and some pretty cool looking forms (I don't know how to create those). For printing as an invoice, a basic data entry form is not the best choice because of the buttons.

If this were a database, it would be a 2 table relational setup. Im essence, I am looking to use Excel as a relational spreadsheet. What/How is the best way to get this done?

Thank you for any and all suggestions.

Hi guys,

I am trying to transform or extract data from the table below and get it in my desired form shown in the image below that. Is there anyway to use VLookup or Index/Match to do this? My data set is gigantic so I cannot do this by hand. Ultimately this data will go to sas.

Current state of data:

pivot 1.png

Desired outcome of data:

pivot 2.png

]]>I am trying to transform or extract data from the table below and get it in my desired form shown in the image below that. Is there anyway to use VLookup or Index/Match to do this? My data set is gigantic so I cannot do this by hand. Ultimately this data will go to sas.

Current state of data:

pivot 1.png

Desired outcome of data:

pivot 2.png

Please see attached sheet. Staff needs to only complete column D "Cost Centre" but complain list is too long, and so want to either complete number or part of word to bring up options to select from - important that data validation is maintained as this will be used to import data.

I'm trying to say A = 4, B = 3, C = 2, D = 1; 100-90 = 4, 89-80 = 3, 79-70 = 2, 69-60 = 1, 59-0 = 0; 4.00-3.80 = 4, 3.79-3.6 =3.7, 3.59-3.40 = 3.5, 3.39-3.10 = 3.3, 3.09-2.80 = 3.0, 2.79-2.60 - 2.7, 2.59-2.40 = 2.5, 2.39-2.10 = 2.3, 2.09-1.80 = 2.0, 1.79-1.60 = 1.7, 1.59-1.40 = 1.5.

So far I've gotten this below. It stops working once I try to do in-between 100-90.

=IF(A2="A","4",IF(A2="B","3",IF(A2="C","2",IF(A2="D","1",IF(A2<>"100-90","4",IF(A2<>"89-80","3"))))))

]]>So far I've gotten this below. It stops working once I try to do in-between 100-90.

=IF(A2="A","4",IF(A2="B","3",IF(A2="C","2",IF(A2="D","1",IF(A2<>"100-90","4",IF(A2<>"89-80","3"))))))