Microsoft 365 and Office Excel For business Android

1 answer

How do I calculate call center "service level 45 seconds" Q1 SLA "weighted average" please

How do I calculate call center "service level 45 seconds" Q1 and Q2 SLA "weighted average" please. I need these weighted averages for Q1 and Q2 highlighted in green. Not certain if my calculations are correct but I do know that the…

asked

Carrie Ward 80

commented

Ian-Ng 2,615 Microsoft External Staff Moderator

1 answer

Looking for GST HSN and SAC Codes related Formula in Excel 2021

Hallo dear micro soft techno community, Greetings of the day. Please note am not at all a tech savvy but an ordinary user of computer. I want to maintain a workbook for my GST related accounting for my little e-commerce resale purpose. For that, I…

asked

RK Tenali 0

commented

RK Tenali 0

1 answer

Android. F3 licence. Edit Excel gives error switch to work account

Since 20/08/2028 on android. if we open an xls as attachment in outlook , or in teams, or sharepoint. And we open it for editing then we get following error: Can't open file. Switch to your work or school account in the Excel app to open this managed…

asked

E. Vandewege 0

commented

Gabriel-N 4,570 Microsoft External Staff Moderator

1 answer

How do I show this trend MOM (month over month) by agent-I want to see each agents AHT so I can determine outliers+call center question

asked

Carrie Ward 80

accepted

Carrie Ward 80

1 answer

Including other documents when Exporting/Printing in Excel

I have an Excel form with an "output" sheet that compiles the information entered - this is intentionally not using mailmerge, and each time this form is used, it is a fresh copy of the document by necessity. Once the form is complete, the…

asked

Jason 0

commented

Austin-H 3,750 Microsoft External Staff Moderator

1 answer

how do i fix this problem 'you cannot add cells because the last row or column contains formulas or formatting blocking' - i have tried going to the last row and column and clearing contents

I have a spread sheet that i am trying to re - format and add columns to upon attempting to insert a cut column this message appears you cannot add cells because the last row or column contains formulas or formatting blocking that are blocking new…

asked

Carla Denham 20

accepted

Carla Denham 20

1 answer

Unable to scroll in Excel mobile Android

Since the last few updates of Excel mobile, scrolling has stopped working. The solution is to go to Excel settings and uninstall all Excel updates and reset Excel to the initial version. Scrolling now works again. Don't install updates until Microsoft…

asked

Rod Lamont 0

edited an answer

Hendrix-C 2,050 Microsoft External Staff Moderator

3 answers

Average value of Excel cells containing text that are the subject of individual weightings

Hi Community, I have a scenario whereby I have a column of 7 Excel text cells (let's define them as D4: D10). Each cell is driven by an Excel formula that will generate an outcome of either "A", "B" or "C". Please note, the…

asked

Anonymous

3 answers

Can't scroll sideways in Excel for Android.

No gesture works for left or right scrolling. Plus the scroll buttons appear randomly and are inoperable.

asked

Anonymous

2 answers

Filter Data from Mastersheet to other sheets

I am trying to filter data from one sheet(master) to another sheet based on the column that has a list of the months. I've tried using this formula but it is returns as value? 1. =filter(mastersheet!k3:k500=A1, "no match") …

asked

Anonymous

5 answers

Count Unique Values with Criteria

Hi, I have a table that shows species names and material. Some species appear more than once for each substrate type. How can I make a formula that counts the number of species on each material without counting the repeating names? I have species in…

asked

Anonymous

0 answers

Transfer Data automatically to Envelopes

I have one sheet A with two collums (Name and Last Name), which can have over 200 Names/Rows. Then I have another sheet B with DL-Envelopes Layout. I have already formated everything to the way i want to have it, however when I want to copy or duplicate…

asked

Anonymous

2 answers

Unable to convert Text to Number in Excel

I have a downloaded excel file from FTA. The numbers in the file appear to be in Text format. I have tried multiple options to convert it into Number format, but none are working. Appreciate help. Attaching the screenshot.

asked

Anonymous

9 answers

Excel IF OR and AND formula continues to deliver a zero result

Hi Colleagues, I have created an Excel drop down list in Cell B19, containing the options: Excellent, Strong, Reasonable. I am trying to write an Excel formula in Cell D19 that will return a respective "A", "B" or "C" result…

asked

Anonymous

1 answer

Excel crash

We have an ongoing issue of Excel file crash whenever we copy/paste, cut/paste or do insert since a long time. We tried everything mentioned in troubleshoot but it doesn't solve the issue. Can you please help.

asked

Anonymous

2 answers

How to recover replaced file !

Hello, Mistakenly i replaced file with my new version and the name of both files are same, but now i want my old version file, how can i recover it !

asked

Anonymous

11 answers

How to switch the creator of a form from editor to respondant

https://answers.microsoft.com/en-us/msoffice/forum/all/i-am-creating-a-form-within-teams-but-cannot/992a81da-24e3-4e50-99ee-75f44b7b3e45 except, my question is - How do I switch it so I can enter responses on the form myself?It always defaults me to my…

asked

Anonymous

4 answers

reference to other cell

Hello, I would like for a certain value to fill the cell with another value,as an example; if the result of the sum (F5) is equal to a value of H:H then the answer becomes J:J, so sum is 4 then 5, sum is 5 then 15, sum is 6 then 25, etc.

asked

Anonymous

1 answer

If formula

Hi all, I have taken over a spreadsheet from someone who left and although I understand the if formula there is something don't understand. It is a very simple formula which says if cell (A<0, "not done","done) however when I would…

asked

Anonymous

1 answer

Not open excel file

we found a problem to open excel file

asked

Anonymous

Microsoft 365 and Office | Excel | For business | Android

Filter

Content

135 questions with Microsoft 365 and Office | Excel | For business | Android tags

How do I calculate call center "service level 45 seconds" Q1 SLA "weighted average" please

Looking for GST HSN and SAC Codes related Formula in Excel 2021

Android. F3 licence. Edit Excel gives error switch to work account

How do I show this trend MOM (month over month) by agent-I want to see each agents AHT so I can determine outliers+call center question

Including other documents when Exporting/Printing in Excel

how do i fix this problem 'you cannot add cells because the last row or column contains formulas or formatting blocking' - i have tried going to the last row and column and clearing contents

Unable to scroll in Excel mobile Android

Average value of Excel cells containing text that are the subject of individual weightings

Can't scroll sideways in Excel for Android.

Filter Data from Mastersheet to other sheets

Count Unique Values with Criteria

Transfer Data automatically to Envelopes

Unable to convert Text to Number in Excel

Excel IF OR and AND formula continues to deliver a zero result

Excel crash

How to recover replaced file !

How to switch the creator of a form from editor to respondant

reference to other cell

If formula

Not open excel file